CUSTOMER Table
View exposing customer master data used in accounts receivable and billing.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_GROUP |
Account group as provided by the source. |
VARCHAR2 |
30 |
ACCOUNT_GROUP_CODE |
Code identifying account group. |
VARCHAR2 |
4 |
CITY |
City as provided by the source. |
VARCHAR2 |
35 |
COUNTRY_CODE |
Code identifying country. |
VARCHAR2 |
3 |
COUNTRY_NAME |
Country name as provided by the source. |
VARCHAR2 |
15 |
CREATION_DATE |
Date associated with creation. |
DATE |
|
CREATOR |
Creator as provided by the source. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
Surrogate key identifying the customer. |
VARCHAR2 |
11 |
CUSTOMER_NAME_1 |
Customer name 1 as provided by the source. |
VARCHAR2 |
50 |
CUSTOMER_NAME_2 |
Customer name 2 as provided by the source. |
VARCHAR2 |
50 |
CUSTOMER_NAME_3 |
Customer name 3 as provided by the source. |
VARCHAR2 |
50 |
CUSTOMER_NAME_4 |
Customer name 4 as provided by the source. |
VARCHAR2 |
50 |
CUSTOMER_NUMBER |
Customer number as provided by the source. |
VARCHAR2 |
10 |
FAX_NUMBER |
Fax number as provided by the source. |
VARCHAR2 |
31 |
PHONE_NUMBER |
Phone number associated with the record. |
VARCHAR2 |
16 |
POSTAL_CODE |
Code identifying postal. |
VARCHAR2 |
10 |
PO_BOX |
Po box as provided by the source. |
VARCHAR2 |
10 |
SEARCH_STRING |
Search string as provided by the source. |
VARCHAR2 |
11 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
10 |
STATE |
State as provided by the source. |
VARCHAR2 |
3 |
STREET |
Street as provided by the source. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
DATE |