DW_NS_purchaseOrderShippingAddress_D
This table contains information for Shipping addresses used in Purchase Orders.
Details
Module:
Key Columns
nkey
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| nkey | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| addr1 | VARCHAR2 | 512 | Address 1 | ||||
| addr2 | VARCHAR2 | 512 | Address 2 | ||||
| addressee | VARCHAR2 | 256 | Addressee | ||||
| addrphone | VARCHAR2 | 128 | Phone | ||||
| addrtext | VARCHAR2 | 999 | Address | ||||
| attention | VARCHAR2 | 512 | Attention | ||||
| city | VARCHAR2 | 128 | City | ||||
| country | VARCHAR2 | 128 | Country | DW_NS_Country_D | id | ||
| dropdownstate | VARCHAR2 | 128 | State | ||||
| override | VARCHAR2 | 16 | Override | ||||
| state | VARCHAR2 | 64 | State/Province | DW_NS_state_D | shortname | ||
| zip | VARCHAR2 | 128 | Zip | ||||
| lastmodifieddate | TIMESTAMP | Last Modified Date |