Business location Dimension
Module:
LOCATION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
LOCATION_ID | NUMBER | 38 | 0 | True | Business Location ID | DW_WORKER_LOCATION_D_TL | LOCATION_ID |
SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Unique record Identifier.Business location ID as Primary Key | |||
LOCATION_CODE | VARCHAR2 | 256 | Internal Location Code | ||||
ADDRESS_LINE_1 | VARCHAR2 | 256 | First line of address | ||||
ADDRESS_LINE_2 | VARCHAR2 | 256 | Second line of address | ||||
ADDRESS_LINE_3 | VARCHAR2 | 256 | Third line of address | ||||
ADDRESS_LINE_4 | VARCHAR2 | 256 | Fourth line of address | ||||
TOWN_OR_CITY | VARCHAR2 | 64 | Name of the Town or City for the address | ||||
POSTAL_CODE | VARCHAR2 | 32 | Postal code of the address | ||||
REGION1 | VARCHAR2 | 128 | Primary region in which the address is located. | ||||
REGION2 | VARCHAR2 | 128 | Sub-region of Region 1. | ||||
REGION3 | VARCHAR2 | 128 | Sub-region of Region 2. | ||||
COUNTRY | VARCHAR2 | 64 | Country of the address. For translation refer table DW_COUNTRY_D_TL. | DW_COUNTRY_D_TL | COUNTRY | ||
MAIN_PHONE_NUMBER | VARCHAR2 | 256 | Main Phone Number | ||||
MAIN_PHONE_EXTENSION | VARCHAR2 | 64 | Main Phone Extension | ||||
FAX_NUMBER | VARCHAR2 | 256 | Fax Number | ||||
FAX_NUMBER_EXTENSION | VARCHAR2 | 64 | Fax Extension | ||||
OTHER_PHONE_NUMBER | VARCHAR2 | 256 | Other Phone Number | ||||
OTHER_PHONE_EXTENSION | VARCHAR2 | 64 | Pther pHone extension | ||||
EMAIL_ADDRESS | VARCHAR2 | 256 | Email Address | ||||
ACTIVE | VARCHAR2 | 32 | Active | ||||
INVENTORY_ORGANIZATION_NAME | VARCHAR2 | 256 | Represents the inventory organization id the location is attached. This attribute is not supported. |
Copyright © 2019, 2024, Oracle and/or its affiliates.