BALANCE SHEET ACCOUNT CUR Table
Balance sheet account for campus (CUR)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BALANCE_SHEET_ACCOUNT_ID |
XXX |
VARCHAR2 |
7 |
BALANCE_SHEET_ACCOUNT_KEY |
Key used to join the Balance Sheet Balances or the Balance Sheet Balances by Fiscal Period tables to other tables, NOT for reporting. |
VARCHAR2 |
12 |
BALANCE_SHEET_ACCOUNT_NAME |
XXX |
VARCHAR2 |
50 |
BALANCE_SHEET_ACCOUNT_TYPE |
XXX |
VARCHAR2 |
20 |
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 |
PROFIT_CENTER_ID |
A unique key that identifies the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
11 |
SECTION_CODE |
A code which classifies cost collectors into sections for financial statement reporting purposes |
VARCHAR2 |
3 |
SECTION_NAME |
Description associated with the Section Code. |
VARCHAR2 |
60 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |