BALANCES Table
View exposing summarized financial balance and budget measures by cost collector, general ledger account, and fiscal year including fiscal-year budgets, cumulative balances, commitments, and monthly activity used for financial planning and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANNUAL_FORECAST_BUDGET |
Annual forecast budget associated with the record. |
NUMBER |
13,2 |
APRIL_AMOUNT |
April amount associated with the record. |
NUMBER |
13,2 |
APRIL_BUDGET |
April budget associated with the record. |
NUMBER |
13,2 |
APRIL_DEPT_BUDGET |
April dept budget associated with the record. |
NUMBER |
13,2 |
AUGUST_AMOUNT |
August amount associated with the record. |
NUMBER |
13,2 |
AUGUST_BUDGET |
August budget associated with the record. |
NUMBER |
13,2 |
AUGUST_DEPT_BUDGET |
August dept budget associated with the record. |
NUMBER |
13,2 |
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 |
COST_COLLECTOR_FY_KEY |
Cost collector fy key associated with the record. |
VARCHAR2 |
12 |
COST_COLLECTOR_ID_WITH_TYPE |
Cost collector id with type associated with the record. |
VARCHAR2 |
8 |
COST_COLLECTOR_KEY |
Cost collector key associated with the record. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Cost collector key associated with the record. |
VARCHAR2 |
12 |
CUMULATIVE_AMOUNT |
Cumulative amount associated with the record. |
NUMBER |
13,2 |
DECEMBER_AMOUNT |
December amount associated with the record. |
NUMBER |
13,2 |
DECEMBER_BUDGET |
December budget associated with the record. |
NUMBER |
13,2 |
DECEMBER_DEPT_BUDGET |
December dept budget associated with the record. |
NUMBER |
13,2 |
FEBRUARY_AMOUNT |
February amount associated with the record. |
NUMBER |
13,2 |
FEBRUARY_BUDGET |
February budget associated with the record. |
NUMBER |
13,2 |
FEBRUARY_DEPT_BUDGET |
February dept budget associated with the record. |
NUMBER |
13,2 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FISCAL_YEAR_BUDGET |
Fiscal year budget associated with the record. |
NUMBER |
13,2 |
FISCAL_YEAR_DEPT_BUDGET |
Fiscal year dept budget associated with the record. |
NUMBER |
13,2 |
FYTD_AMOUNT |
Fytd amount associated with the record. |
NUMBER |
13,2 |
FY_COMMITMENT_AMOUNT |
Fy commitment amount associated with the record. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Gl account key associated with the record. |
VARCHAR2 |
10 |
GL_ACCOUNT_KEY |
Gl account key associated with the record. |
VARCHAR2 |
10 |
JANUARY_AMOUNT |
January amount associated with the record. |
NUMBER |
13,2 |
JANUARY_BUDGET |
January budget associated with the record. |
NUMBER |
13,2 |
JANUARY_DEPT_BUDGET |
January dept budget associated with the record. |
NUMBER |
13,2 |
JULY_AMOUNT |
July amount associated with the record. |
NUMBER |
13,2 |
JULY_BUDGET |
July budget associated with the record. |
NUMBER |
13,2 |
JULY_DEPT_BUDGET |
July dept budget associated with the record. |
NUMBER |
13,2 |
JUNE_AMOUNT |
June amount associated with the record. |
NUMBER |
13,2 |
JUNE_BUDGET |
June budget associated with the record. |
NUMBER |
13,2 |
JUNE_DEPT_BUDGET |
June dept budget associated with the record. |
NUMBER |
13,2 |
MARCH_AMOUNT |
March amount associated with the record. |
NUMBER |
13,2 |
MARCH_BUDGET |
March budget associated with the record. |
NUMBER |
13,2 |
MARCH_DEPT_BUDGET |
March dept budget associated with the record. |
NUMBER |
13,2 |
MAY_AMOUNT |
May amount associated with the record. |
NUMBER |
13,2 |
MAY_BUDGET |
May budget associated with the record. |
NUMBER |
13,2 |
MAY_DEPT_BUDGET |
May dept budget associated with the record. |
NUMBER |
13,2 |
NOVEMBER_AMOUNT |
November amount associated with the record. |
NUMBER |
13,2 |
NOVEMBER_BUDGET |
November budget associated with the record. |
NUMBER |
13,2 |
NOVEMBER_DEPT_BUDGET |
November dept budget associated with the record. |
NUMBER |
13,2 |
OCTOBER_AMOUNT |
October amount associated with the record. |
NUMBER |
13,2 |
OCTOBER_BUDGET |
October budget associated with the record. |
NUMBER |
13,2 |
OCTOBER_DEPT_BUDGET |
October dept budget associated with the record. |
NUMBER |
13,2 |
PREV_YEAR_CUM_AMOUNT |
Prev year cum amount associated with the record. |
NUMBER |
13,2 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
SEPTEMBER_AMOUNT |
September amount associated with the record. |
NUMBER |
13,2 |
SEPTEMBER_BUDGET |
September budget associated with the record. |
NUMBER |
13,2 |
SEPTEMBER_DEPT_BUDGET |
September dept budget associated with the record. |
NUMBER |
13,2 |
TOTAL_COMMITMENT_AMOUNT |
Total commitment amount associated with the record. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |