Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
SRVRECTYPE | Service Record Type |
Integer | 2 | View | |
CALLNBR | Service Call Number |
String | 12 | View | |
ENTDTE | Entry Date |
Date | 4 | View | |
COMPDTE | Complete Date |
Date | 4 | View | |
SRVSTAT | Service Call Status |
String | 4 | View | |
STSDESCR | Status Description |
String | 32 | View | |
SRVTYPE | Service Type |
String | 12 | View | |
PORDNMBR | Purchase Order Number |
String | 22 | View | |
TECHID | Tech ID |
String | 12 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
CUSTNAME | Customer Name |
String | 66 | View | |
Customer_Reference | Customer Reference |
String | 22 | View | |
CONTNBR | Contract Number |
String | 12 | View | |
OFFID | Office ID |
String | 12 | View | |
HISTORY | History |
Boolean | 2 | View |