DW_NS_WorkplaceMainAddress_D
This table contains information for addresses of Work place (Main office). This also can be used in conjunction with Home address.
Details
Module:
Key Columns
nkey
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| nkey | NUMBER | 38 | 0 | True | Key | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| override | VARCHAR2 | 16 | Override | ||||
| addr1 | VARCHAR2 | 512 | Address 1 | ||||
| addr2 | VARCHAR2 | 512 | Address 2 | ||||
| addrphone | VARCHAR2 | 128 | Phone | ||||
| addressee | VARCHAR2 | 256 | Addressee | ||||
| 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 | ||||
| state | VARCHAR2 | 64 | State/Province | DW_NS_state_D | shortname | ||
| zip | VARCHAR2 | 128 | Zip | ||||
| lastmodifieddate | TIMESTAMP | Last Modified Date |