Added in Version 7.0
The RMAADDRESS table stores Return address information. This table contains information including, but not limited to, description, number and street, city, state, postal code, county, and country.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
RMAADDRESSID (PK) |
char(12) |
NOT NULL |
RMAADDRESS_RMAADDRESSID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
RMAID (FK) |
char(12) |
NOT NULL |
RMAADDRESS_RMAID(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 |
|
|
|
|
RMAADDRESS |
varchar(64) |
NULLS |
|
|
|
|
SALUTATION |
varchar(64) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
|
COUNTRYCODE |
nvarchar(3) |
NULLS |
|
|
|
|
ADDRESS5 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS6 |
varchar(64) |
NULLS |
|
|
|