SPONSORED BILLING CUSTOMER Table
View exposing sponsored-billing customer master data including customer identifiers, names, mailing address, contact information, account-group attributes, search string, creator, and creation date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_GROUP |
Account group associated with the record. |
VARCHAR2 |
30 |
ACCOUNT_GROUP_CODE |
Code identifying account group. |
VARCHAR2 |
4 |
CITY |
City associated with the record. |
VARCHAR2 |
35 |
COUNTRY_CODE |
Country code associated with the record. |
VARCHAR2 |
3 |
COUNTRY_NAME |
Country name associated with the record. |
VARCHAR2 |
15 |
CREATION_DATE |
Date associated with creation. |
DATE |
|
CREATOR |
Creator associated with the record. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
Surrogate key identifying the customer. |
VARCHAR2 |
11 |
CUSTOMER_NAME_1 |
Customer name 1 associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_NAME_2 |
Customer name 2 associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_NAME_3 |
Customer name 3 associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_NAME_4 |
Customer name 4 associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_NUMBER |
Customer number associated with the record. |
VARCHAR2 |
10 |
FAX_NUMBER |
Fax number associated with the record. |
VARCHAR2 |
31 |
PHONE_NUMBER |
Phone number associated with the record. |
VARCHAR2 |
16 |
POSTAL_CODE |
Postal code associated with the record. |
VARCHAR2 |
10 |
PO_BOX |
Po box associated with the record. |
VARCHAR2 |
10 |
SEARCH_STRING |
Search string associated with the record. |
VARCHAR2 |
11 |
STATE |
State associated with the record. |
VARCHAR2 |
3 |
STREET |
Street associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |