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 |