CUSTOMER Table
Customer data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_GROUP |
XXX |
VARCHAR2 |
30 |
ACCOUNT_GROUP_CODE |
XXX |
VARCHAR2 |
4 |
CITY |
City. |
VARCHAR2 |
35 |
COUNTRY_CODE |
The 3 digit code which identifies a country (Example: USA United States of America). |
VARCHAR2 |
3 |
COUNTRY_NAME |
The long name of the country (Example United States, France) |
VARCHAR2 |
40 |
CREATION_DATE |
The date a record was created. |
DATE |
8 |
CREATOR |
The name of the person who created the record. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
This key is to be used to join the FINANCIAL_DETAIL and the PROJECT or PROJECT_OSP tables. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
11 |
CUSTOMER_NAME_1 |
XXX |
VARCHAR2 |
35 |
CUSTOMER_NAME_2 |
XXX |
VARCHAR2 |
35 |
CUSTOMER_NAME_3 |
XXX |
VARCHAR2 |
35 |
CUSTOMER_NAME_4 |
XXX |
VARCHAR2 |
35 |
CUSTOMER_NUMBER |
Identifies the customer. |
VARCHAR2 |
10 |
FAX_NUMBER |
The employee's FAX number. |
VARCHAR2 |
31 |
PHONE_NUMBER |
Phone number of the credit card holder or verifier. |
VARCHAR2 |
8 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
15 |
PO_BOX |
Post Office Box. |
VARCHAR2 |
10 |
SEARCH_STRING |
XXX |
VARCHAR2 |
10 |
SPONSOR_KEY |
Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
10 |
STATE |
State. |
VARCHAR2 |
30 |
STREET |
In the SPONSORED_BILLING_CUSTOMER and VENDOR tables, the street address of a person or business doing business with MIT. |
VARCHAR2 |
35 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |