BALANCES SUMMARY Table
View exposing summarized budget, expense, commitment, and available balance measures by cost collector and fiscal period used for financial monitoring and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AVAILABLE_TOTAL |
Available total associated with the record. |
NUMBER |
|
COST_COLLECTOR_KEY |
Cost collector key associated with the record. |
VARCHAR2 |
12 |
CUMULATIVE_EXPENSES |
Cumulative expenses associated with the record. |
NUMBER |
|
CURRENT_MONTH_EXPENSES |
Current month expenses associated with the record. |
NUMBER |
|
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
6 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FYTD_EXPENSES |
Fytd expenses associated with the record. |
NUMBER |
|
IS_CURRENT |
Is current associated with the record. |
CHAR |
|
NON_BLANKET_COMMITMENTS |
Non blanket commitments associated with the record. |
NUMBER |
|
TOTAL_COMMITMENTS |
Total commitments associated with the record. |
NUMBER |
|
UNEXPENDED_BALANCE |
Unexpended balance associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |