Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BALANCE SHEET ACCOUNT CUR Table


View exposing current balance sheet account reference data including active account identifiers, account names, grouping attributes, and reporting classifications.


Field Name

Description

Data Type

Length

BALANCE_SHEET_ACCOUNT_ID

Balance sheet account id associated with the record.

VARCHAR2

7

BALANCE_SHEET_ACCOUNT_KEY

Balance sheet account key associated with the record.

VARCHAR2

12

BALANCE_SHEET_ACCOUNT_NAME

Balance sheet account name associated with the record.

VARCHAR2

60

BALANCE_SHEET_ACCOUNT_TYPE

Balance sheet account type associated with the record.

VARCHAR2

20

COMPANY_CODE

Company code associated with the record.

VARCHAR2

4

PROFIT_CENTER_ID

Profit center id associated with the record.

VARCHAR2

7

PROFIT_CENTER_KEY

Profit center key associated with the record.

VARCHAR2

11

SECTION_CODE

Section code associated with the record.

VARCHAR2

3

SECTION_NAME

Section name associated with the record.

VARCHAR2

60

SUPERVISOR

Supervisor associated with the record.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE