CUSTOMER ALL Table
View exposing customer master data used for accounts receivable and billing, including customer identifiers, name and address attributes, contact information, account grouping, and company-specific posting controls.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_GROUP |
Description of the customer account group. |
VARCHAR2 |
30 |
ACCOUNT_GROUP_CODE |
Code identifying the customer account group. |
VARCHAR2 |
4 |
CITY |
City associated with the customer address. |
VARCHAR2 |
35 |
COMPANY_CODE |
Financial company code associated with the customer record. |
VARCHAR2 |
4 |
COMPANY_POSTING_BLOCK |
Indicator identifying whether postings are blocked for the customer within the company code. |
VARCHAR2 |
1 |
CONTROLLING_AREA |
Controlling area associated with the customer record. |
VARCHAR2 |
4 |
COUNTRY_CODE |
Country code associated with the customer address. |
VARCHAR2 |
3 |
COUNTRY_NAME |
Country name associated with the customer address. |
VARCHAR2 |
15 |
CREATION_DATE |
Date the customer record was created in the source system. |
DATE |
|
CREATOR |
Identifier of the user who created the customer record in the source system. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
Surrogate identifier for the customer record. |
VARCHAR2 |
11 |
CUSTOMER_NAME_1 |
Primary customer name line. |
VARCHAR2 |
50 |
CUSTOMER_NAME_2 |
Additional customer name line. |
VARCHAR2 |
50 |
CUSTOMER_NAME_3 |
Additional customer name line. |
VARCHAR2 |
50 |
CUSTOMER_NAME_4 |
Additional customer name line. |
VARCHAR2 |
50 |
CUSTOMER_NUMBER |
Business identifier used to reference the customer in financial systems. |
VARCHAR2 |
10 |
FAX_NUMBER |
Customer fax number. |
VARCHAR2 |
31 |
PHONE_NUMBER |
Customer telephone number. |
VARCHAR2 |
16 |
POSTAL_CODE |
Postal code associated with the customer address. |
VARCHAR2 |
10 |
PO_BOX |
Post office box associated with the customer mailing address. |
VARCHAR2 |
10 |
RECON_GL_ACCOUNT_ID |
General ledger account used for reconciliation of customer balances. |
VARCHAR2 |
6 |
SEARCH_STRING |
Search value used to locate or match the customer record. |
VARCHAR2 |
11 |
SPONSOR_KEY |
Identifier of the sponsor associated with the customer record, when applicable. |
VARCHAR2 |
10 |
STATE |
State or province associated with the customer address. |
VARCHAR2 |
3 |
STREET |
Street address associated with the customer. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |