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 |