Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BALANCE SHEET BALANCES Table


View exposing balance sheet balances by account and reporting period used for financial statement reporting and analysis.


Field Name

Description

Data Type

Length

APRIL_AMOUNT

April amount associated with the record.

NUMBER

13,2

AUGUST_AMOUNT

August amount associated with the record.

NUMBER

13,2

BALANCE_SHEET_ACCOUNT_KEY

Balance sheet account key associated with the record.

VARCHAR2

12

CLOSING_PERIOD_13_AMOUNT

Closing period 13 amount associated with the record.

NUMBER

13,2

CLOSING_PERIOD_14_AMOUNT

Closing period 14 amount associated with the record.

NUMBER

13,2

CLOSING_PERIOD_15_AMOUNT

Closing period 15 amount associated with the record.

NUMBER

13,2

CLOSING_PERIOD_16_AMOUNT

Closing period 16 amount associated with the record.

NUMBER

13,2

COMPANY_CODE

Company code associated with the record.

VARCHAR2

4

CUMULATIVE_AMOUNT

Cumulative amount associated with the record.

NUMBER

13,2

DECEMBER_AMOUNT

December amount associated with the record.

NUMBER

13,2

FEBRUARY_AMOUNT

February amount associated with the record.

NUMBER

13,2

FISCAL_YEAR

Fiscal year associated with the record.

VARCHAR2

4

FYTD_AMOUNT

Fytd amount associated with the record.

NUMBER

13,2

GL_ACCOUNT_KEY

Gl account key associated with the record.

VARCHAR2

10

JANUARY_AMOUNT

January amount associated with the record.

NUMBER

13,2

JULY_AMOUNT

July amount associated with the record.

NUMBER

13,2

JUNE_AMOUNT

June amount associated with the record.

NUMBER

13,2

MARCH_AMOUNT

March amount associated with the record.

NUMBER

13,2

MAY_AMOUNT

May amount associated with the record.

NUMBER

13,2

NOVEMBER_AMOUNT

November amount associated with the record.

NUMBER

13,2

OCTOBER_AMOUNT

October amount associated with the record.

NUMBER

13,2

OPENING_BALANCE

Opening balance associated with the record.

NUMBER

13,2

PREV_YEAR_CUM_AMOUNT

Prev year cum amount associated with the record.

NUMBER

13,2

PROFIT_CENTER_KEY

Profit center key associated with the record.

VARCHAR2

11

RECORD_COUNTER

Record counter associated with the record.

NUMBER

SEPTEMBER_AMOUNT

September amount associated with the record.

NUMBER

13,2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE