| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| OFFNAME |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
Field Type...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
Field Type...(more) Join Now
|
|
|
|
| ZIP |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CNTCPRSN |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| FAXNUMBR |
char(21)
''
|
Fax Number...(more) Join Now
|
SOP10100.FAXNUMBR
|
|
|
| TECHEMAIL |
char(99)
''
|
Field Type...(more) Join Now
|
|
|
|
| MANAGER |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| TIMEZONE |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| LOCCODBK |
char(11)
''
|
|
|
|
|
| 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
|
|
|
|
| Return_Location_Code |
char(11)
''
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| ADDRESS3 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|