SVC00635 - svcContractBillingReversalWork | Prospr

SVC00635 - svcContractBillingReversalWork

Select * from SVC00635

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
CONSTS	Contract Record Type	Integer	2	View
CONTNBR	Contract Number	String	12	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
CNTTYPE	Contract Type	String	12	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
LSTBLDTE	Last Bill Date	Date	4	View
NXTBLDTE	Next Bill Date	Date	4	View
TOTBIL	Total Billed	Currency	10	View
Last_Amount_Billed	Last Amount Billed	Currency	10	View
Invoiced_Amount	Invoiced Amount	Currency	10	View
CUSTNMBR	Customer Number	String	16	View
ADRSCODE	Address Code	String	16	View
MKDTOPST	Marked To Post	Boolean	2	View
POSTED	Posted	Boolean	2	View
ORIGTOTBIL	Originating Total Billed	Currency	10	View
ORIGLASTAmountBilled	Originating Last Amount Billed	Currency	10	View
Orig_Invoiced_Amount	Originating Invoiced Amount	Currency	10	View
ERMSGNBR	Error Message Number	Integer	2	View
ERMSGTXT	Error Message Text	String	256	View
ERMSGTX2	Error Message Text 2	String	256	View