Added in Version 7.0
The SALESORDERADDRESS table stores the address information for sales orders. This information includes number and street, city, state, postal code, description, county, and country.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SALESLORDERADDRESSID (PK) |
char(12) |
NOT NULL |
SALESORDERADDRESS_ID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
SALESORDERID (FK) |
char(12) |
NOT NULL |
SALESORDERADDRESS_SALESORDERID(IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
ADDRESS1 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS2 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS3 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS4 |
varchar(64) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
CITY |
varchar(32) |
NULLS |
|
|
|
|
STATE |
varchar(32) |
NULLS |
|
|
|
|
POSTALCODE |
varchar(24) |
NULLS |
|
|
|
|
COUNTY |
varchar(32) |
NULLS |
|
|
|
|
COUNTRY |
varchar(32) |
NULLS |
|
|
|
|
ADDRESSID |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
APPID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
SALESORDERADDRESS_GLOBALSYNC (IE) |
|
|
|
TICK |
int |
NULLS |
|
|
|
|
SALUTATION |
varchar(64) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| COUNTRYCODE | varchar (3) | NULLS | |||
| ADDRESS5 |
varchar(64) |
NULLS |
|||
| ADDRESS6 |
varchar(64) |
NULLS |