SVC00615 - SVC_Contract_Billing_WORK | Prospr

SVC00615 - SVC_Contract_Billing_WORK

Select * from SVC00615

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
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
Bill_To_Customer	Bill To Customer	String	16	View
SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	16	View
svcConsolidateContractIn	svcConsolidateContractInvoice	Boolean	2	View