| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| UPSZONE |
char(3)
|
UPS Zone: ...(more) Join Now
|
RM00101.UPSZONE
|
|
|
| SHIPMTHD |
char(15)
|
Shipping M...(more) Join Now
|
RM20101.SHIPMTHD
|
|
join ... more text available
|
| TAXSCHID |
char(15)
|
|
|
|
join ... more text available
|
| CNTCPRSN |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
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
|
|
|
|
| PHONE1 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| PHONE3 |
char(21)
|
Phone 3: ...(more) Join Now
|
RM00101.PHONE3
|
|
|
| FAX |
char(21)
|
Fax: Same...(more) Join Now
|
RM00101.FAX
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| CREATDDT |
datetime
|
Field Type...(more) Join Now
|
|
|
|
| GPSFOINTEGRATIONID |
char(31)
|
GPSFO Inte...(more) Join Now
|
RM00101.GPSFOINTEGRATIONID
|
|
|
| INTEGRATIONSOURCE |
smallint
|
Integratio...(more) Join Now
|
RM00101.INTEGRATIONSOURCE
|
|
|
| INTEGRATIONID |
char(31)
|
Integratio...(more) Join Now
|
RM00101.INTEGRATIONID
|
|
|
| CCode |
char(7)
|
Country Co...(more) Join Now
|
RM00101.CCode
|
|
|
| DECLID |
char(15)
|
Declarant ...(more) Join Now
|
RM00101.DECLID
|
|
|
| LOCNCODE |
char(11)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| SALSTERR |
char(15)
|
Sales Terr...(more) Join Now
|
RM10301.SALSTERR
|
|
join ... more text available
|
| USERDEF1 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|