CUSTOMER TECR Table
TechReview customers
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_GROUP |
XXX |
VARCHAR2 |
30 |
ACCOUNT_GROUP_CODE |
XXX |
VARCHAR2 |
4 |
CITY |
City. |
VARCHAR2 |
35 |
COMPANY_CODE |
Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory. |
VARCHAR2 |
4 |
COMPANY_POSTING_BLOCK |
Indicates whether a vendor has been blocked for posting for a specific company code. Values are Y (blocked) or N (not blocked). |
VARCHAR2 |
1 |
CONTROLLING_AREA |
XXX |
VARCHAR2 |
4 |
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 |
RECON_GL_ACCOUNT_ID |
XXX |
VARCHAR2 |
6 |
SEARCH_STRING |
XXX |
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 |