DW_CUSTOMER_LOCATION_D

This table contains details about customer location.

Details

Module: Receivables

Key Columns

CUSTOMER_LOCATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CUSTOMER_LOCATION_ID NUMBER 38 0 True Customer location identifier.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier. Value is same as the customer location identifier.
STREET_ADDRESS1 VARCHAR2 256 Street name of the customer location.
STREET_ADDRESS2 VARCHAR2 256 Street number of the customer location.
STREET_ADDRESS3 VARCHAR2 256 Street description of the address.
STREET_ADDRESS4 VARCHAR2 256 Street description of the address.
POSTAL_CODE VARCHAR2 64 Postal code of the customer location.
CITY VARCHAR2 64 City of the customer location.
COUNTY VARCHAR2 64 County name of the customer location.
STATE_PROVINCE_CODE VARCHAR2 64 State of the customer location. Possible values are AZ, CA, and so on.
COUNTRY_CODE VARCHAR2 16 Country code of the customer location. Possible values are USA for United States of America, UK for United Kingdom, and so on.
ACTIVE_FLAG VARCHAR2 16 Indicates an active customer location.