| 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 |