SUMMARY STATEMENT DETAIL Table
View exposing summary statement detail records including financial statement line items, balances, and reporting attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
|
ANNUAL_FORECAST_BUDGET |
Annual forecast budget associated with the record. |
NUMBER |
|
COMMITMENT_AMOUNT |
Commitment amount associated with the record. |
NUMBER |
13,2 |
COMMITMENT_AMOUNT_FY |
Commitment amount fy associated with the record. |
NUMBER |
13,2 |
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CUMULATIVE_AMOUNT |
Cumulative amount associated with the record. |
NUMBER |
|
DEPARTMENT_BUDGET |
Department budget associated with the record. |
NUMBER |
|
FYTD_AMOUNT |
Fytd amount associated with the record. |
NUMBER |
|
FYTD_DEPARTMENT_BUDGET |
Fytd department budget associated with the record. |
NUMBER |
|
FYTD_INSTITUTE_BUDGET |
Fytd institute budget associated with the record. |
NUMBER |
|
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
INSTITUTE_BUDGET |
Institute budget associated with the record. |
NUMBER |
|
NON_BL_ORDER_COMMITMENT_AMOUNT |
Non bl order commitment amount associated with the record. |
NUMBER |
13,2 |
NON_BL_ORDER_COMMIT_AMOUNT_FY |
Non bl order commit amount fy associated with the record. |
NUMBER |
13,2 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
RECORD_TYPE |
Record type associated with the record. |
VARCHAR2 |
10 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
TOTAL_DEPARTMENT_BUDGET |
Total department budget associated with the record. |
NUMBER |
|
TOTAL_INSTITUTE_BUDGET |
Total institute budget associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |