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.    

Copyright © 2019, 2024, Oracle and/or its affiliates.