Added in version 8.3
The QUOTEADDRESS 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 |
|---|---|---|---|---|---|
|
QUOTEADDRESSID (PK) |
nchar(12) |
NOT NULL
|
QUOTEADDRESS_ADDRESSID_PK (AK) |
|
|
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
QUOTEID (FK) |
nchar(12) |
NULLS |
QUOTEADDRESS_QUOTEID (IE) |
(One) to (Many) |
|
|
ADDRESS1 |
varchar(64) |
NULLS |
|
||
|
ADDRESS2 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS3 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS4 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS5 |
varchar(64) |
NULLS |
|||
|
ADDRESS6 |
varchar(64) |
NULLS |
|||
|
CITY |
varchar(32) |
NULLS |
|
|
|
|
STATE |
varchar(32) |
NULLS |
|
|
|
|
POSTALCODE |
varchar(24) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|||
|
COUNTRY |
varchar(32) |
NULLS |
|
|
|
|
COUNTRYCODE |
varchar(3) |
NULLS |
|||
|
COUNTY |
varchar(32) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
|
SALUTATION |
varchar(64) |
NULLS |
|
|
|
|
ADDRESSID |
char(12) |
NULLS |
|
(Many) to (One) |