| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
|
| LOCNDSCR |
char(31)
''
|
Internal S...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| ADDRESS1 |
char(61)
''
|
Address 1:...(more) Join Now
|
RM00101.ADDRESS1
|
|
|
| ADDRESS2 |
char(61)
''
|
Address 2:...(more) Join Now
|
RM00101.ADDRESS2
|
|
|
| ADDRESS3 |
char(61)
''
|
Address 3:...(more) Join Now
|
RM00101.ADDRESS3
|
|
|
| CITY |
char(35)
''
|
City: City...(more) Join Now
|
RM00101.CITY
|
|
|
| STATE |
char(29)
''
|
State: Up...(more) Join Now
|
RM00101.STATE
|
|
|
| ZIPCODE |
char(11)
''
|
Zip Code: ...(more) Join Now
|
SOP10100.ZIPCODE
|
|
|
| COUNTRY |
char(61)
''
|
Country: C...(more) Join Now
|
RM00101.COUNTRY
|
|
|
| PHONE1 |
char(21)
''
|
Phone 1: ...(more) Join Now
|
RM00101.PHONE1
|
|
|
| PHONE2 |
char(21)
''
|
Phone 2: ...(more) Join Now
|
RM00101.PHONE2
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: ...(more) Join Now
|
RM00101.PHONE3
|
|
|
| FAXNUMBR |
char(21)
''
|
Fax Number...(more) Join Now
|
SOP10100.FAXNUMBR
|
|
|
| Location_Segment |
char(67)
''
|
Field Type...(more) Join Now
|
SVC00600.Location_Segment
|
|
|
| STAXSCHD |
char(15)
''
|
A state sales tax code / ID,
|
TheNibbler
|
|
|
| PCTAXSCH |
char(15)
''
|
|
|
|
|
| INCLDDINPLNNNG |
tinyint
0
|
Included i...(more) Join Now
|
IV00102.INCLDDINPLNNNG
|
|
|
| PORECEIPTBIN |
char(15)
''
|
Purchase R...(more) Join Now
|
IV00102.PORECEIPTBIN
|
|
|
| PORETRNBIN |
char(15)
''
|
Purchase R...(more) Join Now
|
IV00102.PORETRNBIN
|
|
|
| SOFULFILLMENTBIN |
char(15)
''
|
SO Fulfill...(more) Join Now
|
IV00102.SOFULFILLMENTBIN
|
|
|
| SORETURNBIN |
char(15)
''
|
SO Return ...(more) Join Now
|
IV00102.SORETURNBIN
|
|
|
| BOMRCPTBIN |
char(15)
''
|
BOM Receip...(more) Join Now
|
IV00102.BOMRCPTBIN
|
|
|
| MATERIALISSUEBIN |
char(15)
''
|
Material I...(more) Join Now
|
IV00102.MATERIALISSUEBIN
|
|
|
| MORECEIPTBIN |
char(15)
''
|
MO Receipt...(more) Join Now
|
IV00102.MORECEIPTBIN
|
|
|
| REPAIRISSUESBIN |
char(15)
''
|
Repair Iss...(more) Join Now
|
IV00102.REPAIRISSUESBIN
|
|
|
| WMSINT |
tinyint
0
|
|
|
|
|
| PICKTICKETSITEOPT |
smallint
0
|
|
|
|
|
| BINBREAK |
smallint
0
|
|
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
RM00101.CCode
|
|
|
| DECLID |
char(15)
''
|
Declarant ...(more) Join Now
|
RM00101.DECLID
|
|
|
| INACTIVE |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|