SVC30603 - SVC_Contract_Line_Invoice_HIST | Prospr

SVC30603 - SVC_Contract_Line_Invoice_HIST

Select * from SVC30603

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
SVC_Invoice_SEQ_Number	SVC_Invoice_SEQ_Number	Long Integer	4	View
INVODATE	Invoice Date	Date	4	View
DOCAMNT	Document 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
POSTED	Posted	Boolean	2	View
POSTEDDT	Posted Date	Date	4	View
PSTDAMNT	Posted Amount	Currency	10	View
SVC_Invoice_Credit_Amoun	SVC_Invoice_Credit_Amount	Currency	10	View
SVC_Daily_Rate	SVC_Daily_Rate	Currency	10	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	Currency	10	View
ORIGPSTDAMNT	SVC Originating Posted Amount	Currency	10	View
OrigInvCreditAmt	Originating Invoice Credit Amount	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
SVC_Contract_Version	SVC_Contract_Version	Integer	2	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
SOPNUMBE	SOP Number	String	22	View
svcReverseType	svcReverseType	Integer	2	View