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 | |
CNTTYPE | Contract Type |
String | 12 | View | |
STRTDATE | Start Date |
Date | 4 | View | |
ENDDATE | End Date |
Date | 4 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
SERLNMBR | Serial Number |
String | 22 | View | |
EQUIPID | Equipment ID |
Long Integer | 4 | View | |
DSCRIPTN | Description |
String | 32 | View | |
QUANTITY | QTY |
Currency | 10 | View | |
Effective_Date | Effective Date |
Date | 4 | View | |
CMXFRNUM | Transfer Number |
String | 22 | View | |
To_Customer_Number | To Customer Number |
String | 16 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
PRICSHED | Price Schedule |
String | 12 | View | |
CNTPRCOVR | Contract Price Overridden |
Boolean | 2 | View | |
TOTAL | Total |
Currency | 10 | View | |
SVC_Monthly_Price | SVC Monthly_Price |
Currency | 10 | View | |
DEDCAMNT_1 | Deduction Amount[1] |
Currency | 10 | View | |
DEDCAMNT_2 | Deduction Amount[2] |
Currency | 10 | View | |
DEDCAMNT_3 | Deduction Amount[3] |
Currency | 10 | View | |
DEDCAMNT_4 | Deduction Amount[4] |
Currency | 10 | View | |
DEDCAMNT_5 | Deduction Amount[5] |
Currency | 10 | View | |
RETNAGAM | Retainage Amount |
Currency | 10 | View | |
RTNBILLD | Retainage Billed |
Currency | 10 | View | |
NBRCAL | Max Number of Calls |
Integer | 2 | View | |
ACTCAL | Actual Number of Calls |
Integer | 2 | View | |
BLKTIM | Blocked Time |
Currency | 10 | View | |
VALTIM | Value of Time |
Currency | 10 | View | |
MKDTOPST | Marked To Post |
Boolean | 2 | View | |
POSTDATE | Post Date |
Date | 4 | View |