| CUSTNMBR |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_1 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_2 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_3 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_4 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_5 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_6 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_7 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_1 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_2 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_3 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_4 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_5 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_6 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_7 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_1 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_2 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_3 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_4 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_5 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_6 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_7 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| LSTSRVDTE |
datetime
'1/1/1900'
|
|
|
|
|
| SVCAREA |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| TECHID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| TIMEZONE |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| SRVTYPE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| Bill_To_Customer |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Address_Option |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Misc_Address_Code |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_PM_Date |
smallint
0
|
|
|
|
|
| SVC_PM_Day |
smallint
0
|
|
|
|
|
| SVC_PM_Allowed |
tinyint
0
|
|
|
|
|
| SVC_Allow_Contract_0_SOP |
tinyint
0
|
|
|
|
|
| svcPreferredDay_1 |
tinyint
0
|
|
|
|
|
| svcPreferredDay_2 |
tinyint
0
|
|
|
|
|
| svcPreferredDay_3 |
tinyint
0
|
|
|
|
|
| svcPreferredDay_4 |
tinyint
0
|
|
|
|
|
| svcPreferredDay_5 |
tinyint
0
|
|
|
|
|
| svcPreferredDay_6 |
tinyint
0
|
|
|
|
|
| svcPreferredDay_7 |
tinyint
0
|
|
|
|
|
| svcPreferredStartTime_1 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredStartTime_2 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredStartTime_3 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredStartTime_4 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredStartTime_5 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredStartTime_6 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredStartTime_7 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredEndTime_1 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredEndTime_2 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredEndTime_3 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredEndTime_4 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredEndTime_5 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredEndTime_6 |
datetime
'1/1/1900'
|
|
|
|
|
| svcPreferredEndTime_7 |
datetime
'1/1/1900'
|
|
|
|
|
| CNSOLDTD |
tinyint
0
|
|
|
|
|
| svcConsolidateContractIn |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|