BALANCES BY FISCAL PERIOD Table
View exposing summarized financial balances and budget measures by cost collector, general ledger account, and fiscal period including cumulative, fiscal-year-to-date, and commitment measures used for financial planning and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
13,2 |
ANNUAL_FORECAST_BUDGET |
Annual forecast budget associated with the record. |
NUMBER |
13,2 |
COST_COLLECTOR_FP_KEY |
Cost collector fp key associated with the record. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Cost collector fy 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 |
DEPARTMENT_BUDGET |
Department budget associated with the record. |
NUMBER |
13,2 |
FYTD_AMOUNT |
Fytd amount associated with the record. |
NUMBER |
13,2 |
FYTD_DEPARTMENT_BUDGET |
Fytd department budget associated with the record. |
NUMBER |
13,2 |
FYTD_INSTITUTE_BUDGET |
Fytd institute budget associated with the record. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Gl account key associated with the record. |
VARCHAR2 |
10 |
INSTITUTE_BUDGET |
Institute budget associated with the record. |
NUMBER |
13,2 |
MONTH_END_COMMITMENT_AMOUNT |
Month end commitment amount associated with the record. |
NUMBER |
13,2 |
MONTH_END_COMMIT_AMOUNT_FY |
Month end commit amount fy associated with the record. |
NUMBER |
13,2 |
MONTH_END_NON_BL_COMMIT_AMT_FY |
Month end non bl commit amt fy associated with the record. |
NUMBER |
13,2 |
MONTH_END_NON_BL_ORDER_COM_AMT |
Month end non bl order com amt associated with the record. |
NUMBER |
13,2 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
TIME_MONTH_KEY |
Time month key associated with the record. |
VARCHAR2 |
6 |
TOTAL_DEPARTMENT_BUDGET |
Total department budget associated with the record. |
NUMBER |
13,2 |
TOTAL_INSTITUTE_BUDGET |
Total institute budget associated with the record. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |