| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| ADRSCODE | Address Code |
String | 16 | View | |
| WORKDYS_1 | Work Days[1] |
Boolean | 2 | View | |
| WORKDYS_2 | Work Days[2] |
Boolean | 2 | View | |
| WORKDYS_3 | Work Days[3] |
Boolean | 2 | View | |
| WORKDYS_4 | Work Days[4] |
Boolean | 2 | View | |
| WORKDYS_5 | Work Days[5] |
Boolean | 2 | View | |
| WORKDYS_6 | Work Days[6] |
Boolean | 2 | View | |
| WORKDYS_7 | Work Days[7] |
Boolean | 2 | View | |
| WORKSTRT_1 | Work Start[1] |
Time | 4 | View | |
| WORKSTRT_2 | Work Start[2] |
Time | 4 | View | |
| WORKSTRT_3 | Work Start[3] |
Time | 4 | View | |
| WORKSTRT_4 | Work Start[4] |
Time | 4 | View | |
| WORKSTRT_5 | Work Start[5] |
Time | 4 | View | |
| WORKSTRT_6 | Work Start[6] |
Time | 4 | View | |
| WORKSTRT_7 | Work Start[7] |
Time | 4 | View | |
| WORKEND_1 | Work End[1] |
Time | 4 | View | |
| WORKEND_2 | Work End[2] |
Time | 4 | View | |
| WORKEND_3 | Work End[3] |
Time | 4 | View | |
| WORKEND_4 | Work End[4] |
Time | 4 | View | |
| WORKEND_5 | Work End[5] |
Time | 4 | View | |
| WORKEND_6 | Work End[6] |
Time | 4 | View | |
| WORKEND_7 | Work End[7] |
Time | 4 | View | |
| LSTSRVDTE | Last Service Date |
Date | 4 | View | |
| SVCAREA | Service Area |
String | 12 | View | |
| OFFID | Office ID |
String | 12 | View | |
| TECHID | Tech ID |
String | 12 | View | |
| TIMEZONE | TimeZone |
String | 4 | View | |
| SRVTYPE | Service Type |
String | 12 | View | |
| Bill_To_Customer | Bill To Customer |
String | 16 | View | |
| SVC_Address_Option | SVC_Address_Option |
Integer | 2 | View | |
| SVC_Misc_Address_Code | SVC_Misc_Address_Code |
String | 16 | View | |
| SVC_PM_Date | SVC PM Month |
Integer | 2 | View | |
| SVC_PM_Day | SVC PM Day |
Integer | 2 | View | |
| SVC_PM_Allowed | SVC PM Allowed |
Boolean | 2 | View | |
| SVC_Allow_Contract_0_SOP | SVC Allow Contract 0 SOP |
Boolean | 2 | View | |
| svcPreferredDay_1 | svc Preferred Day[1] |
Boolean | 2 | View | |
| svcPreferredDay_2 | svc Preferred Day[2] |
Boolean | 2 | View | |
| svcPreferredDay_3 | svc Preferred Day[3] |
Boolean | 2 | View | |
| svcPreferredDay_4 | svc Preferred Day[4] |
Boolean | 2 | View | |
| svcPreferredDay_5 | svc Preferred Day[5] |
Boolean | 2 | View | |
| svcPreferredDay_6 | svc Preferred Day[6] |
Boolean | 2 | View | |
| svcPreferredDay_7 | svc Preferred Day[7] |
Boolean | 2 | View | |
| svcPreferredStartTime_1 | svc Preferred Start Time[1] |
Time | 4 | View | |
| svcPreferredStartTime_2 | svc Preferred Start Time[2] |
Time | 4 | View | |
| svcPreferredStartTime_3 | svc Preferred Start Time[3] |
Time | 4 | View | |
| svcPreferredStartTime_4 | svc Preferred Start Time[4] |
Time | 4 | View | |
| svcPreferredStartTime_5 | svc Preferred Start Time[5] |
Time | 4 | View | |
| svcPreferredStartTime_6 | svc Preferred Start Time[6] |
Time | 4 | View | |
| svcPreferredStartTime_7 | svc Preferred Start Time[7] |
Time | 4 | View | |
| svcPreferredEndTime_1 | svc Preferred End Time[1] |
Time | 4 | View | |
| svcPreferredEndTime_2 | svc Preferred End Time[2] |
Time | 4 | View | |
| svcPreferredEndTime_3 | svc Preferred End Time[3] |
Time | 4 | View | |
| svcPreferredEndTime_4 | svc Preferred End Time[4] |
Time | 4 | View | |
| svcPreferredEndTime_5 | svc Preferred End Time[5] |
Time | 4 | View | |
| svcPreferredEndTime_6 | svc Preferred End Time[6] |
Time | 4 | View | |
| svcPreferredEndTime_7 | svc Preferred End Time[7] |
Time | 4 | View | |
| CNSOLDTD | Consolidated |
Boolean | 2 | View | |
| svcConsolidateContractIn | svcConsolidateContractInvoice |
Boolean | 2 | View |