SVC30604 - SVC_Contract_Line_Revenue_HIST | Prospr

SVC30604 - SVC_Contract_Line_Revenue_HIST

Select * from SVC30604

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CONSTS	Contract Record Type	Integer	2	View
CONTNBR	Contract Number	String	12	View
LNSEQNBR	Line SEQ Number	Currency	10	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
Status	Status	Integer	2	View
POSTEDDT	Posted Date	Date	4	View
Transaction_Date	Transaction Date	Date	4	View
USERID	User ID	String	16	View
PSTDAMNT	Posted Amount	Currency	10	View
Originating_PostedAmount	Originating Posted Amount	Currency	10	View
Source_Trx_Document_Type	Source Trx Document Type	String	4	View
SourceTrxDocumentNumber	Source Trx Document Number	String	256	View
Transaction_Amount	Transaction Amount	Currency	10	View
OrigTransactionAmount	Originating Transaction Amount	Currency	10	View
SVC_Coverage_Start_Date	SVC_Coverage_Start_Date	Date	4	View
SVC_Coverage_End_Date	SVC_Coverage_End_Date	Date	4	View
SVC_Invoice_Credit_Amoun	SVC_Invoice_Credit_Amount	Currency	10	View
OrigInvCreditAmt	Originating Invoice Credit Amount	Currency	10	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
Net_Transaction_Amount	Net Transaction Amount	Currency	10	View
OrigNetTransactionAmount	Originating Net Transaction Amount	Currency	10	View
SVC_Contract_Version	SVC_Contract_Version	Integer	2	View