SVC00605 - SVC_Contract_Invoice_HIST | Prospr

SVC00605 - SVC_Contract_Invoice_HIST

Select * from SVC00605

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
SOPNUMBE	SOP Number	String	22	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
INVODATE	Invoice Date	Date	4	View
Invoiced_Amount	Invoiced Amount	Currency	10	View
Amount_To_Invoice	Amount To Invoice	Currency	10	View
Orig_Invoiced_Amount	Originating Invoiced Amount	Currency	10	View
Orig_Amount_To_Invoice	Originating Amount To Invoice	Currency	10	View
svcReverseFlag	svcReverseFlag	Boolean	2	View