| Data element |
Definition |
| ADDRESS_LINE1
Indexed - no
Format - varchar2(50)
May be null? Yes
|
Contains the street address of the individual identified by associated ADDRESS_TYPE. |
| ADDRESS_LINE2
Indexed - no
Format – varchar2(50)
May be null? Yes
|
Contains additional address information of the individual identified by associated ADDRESS_TYPE. |
| ADDRESS_TYPE
Indexed - yes
Format – varchar2(50)
May be null? Yes
|
Denotes whether the address information relates to the shipper or receiver of a shipment. |
| CITY
Indexed - no
Format – varchar2(50)
May be null? Yes
|
Denotes the city of the individual identified by the associated ADDRESS_TYPE. |
| COMPANY_NAME
Indexed - no
Format – varchar2(50)
May be null? Yes
|
Denotes the company name of the individual identified by the associated ADDRESS_TYPE. |
| COUNTRY
Indexed - no
Format – varchar2(2)
May be null? Yes
|
Denotes the country of the individual identified by the associated ADDRESS_TYPE. |
| NAME
Indexed - no
Format – varchar2(50)
May be null? Yes
|
Denotes the name of the individual identified by the associated ADDRESS_TYPE. |
| POSTAL
Indexed - no
Format – varchar2(12)
May be null? Yes
|
Denotes the zip code of the individual identified by the associated ADDRESS_TYPE. |
| STATE
Indexed - no
Format – varchar2(30)
May be null? Yes
|
Denotes the state of the individual identified by the associated ADDRESS_TYPE. |
| TRANSACTION_ADDRESS_ID
Indexed - yes
Format – number(12)
May be null? No
|
Unique identifier of each address within a transaction. |
| TRANSACTION_MASTER_ID
Indexed - yes
Format – number(12)
May be null? Yes
|
A sequence of numbers used to uniquely identify a transaction. |
