This table contains details about customer location.
Module: Receivables
CUSTOMER_LOCATION_ID
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 | 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, 2023, Oracle and/or its affiliates.