ESTIMATED SURCHARGES Table
Overhead, EB, and Allocation surcharges calculated on expenses for the open period(s) in which Costing Sheets have not run yet.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount. |
NUMBER |
13.2 |
COMMITMENT_AMOUNT |
The dollars committed (set aside) but not yet paid for the line item. |
NUMBER |
11 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
EST_EB_ON_AMOUNT |
Estimated EB surcharge on posted amount |
NUMBER |
22 |
EST_EB_ON_COMMITMENT |
Estimated EB surcharge on commitment amount |
NUMBER |
22 |
EST_EB_ON_COMMIT_NON_BL |
Estimated EB surcharge on non-blanket order commitment amount |
NUMBER |
22 |
EST_LAB_ALLOC_ON_AMOUNT |
Estimated lab allocation surcharge on posted amount |
NUMBER |
22 |
EST_LAB_ALLOC_ON_COMMITMENT |
Estimated lab allocation surcharge on commitment amount |
NUMBER |
22 |
EST_LAB_ALLOC_ON_COM_NON_BL |
Estimated lab allocation surcharge on non-blanket order commitment amount |
NUMBER |
22 |
EST_OH_ON_AMOUNT |
Estimated overhead on posted amount |
NUMBER |
22 |
EST_OH_ON_COMMITMENT |
Estimated overhead on commitment amount |
NUMBER |
22 |
EST_OH_ON_COMMIT_NON_BL |
Estimated overhead on non-blanket order commitment amount |
NUMBER |
22 |
EST_SURCHARGE_ON_AMOUNT |
Estimated total surcharge on posted amount |
NUMBER |
22 |
EST_SURCHARGE_ON_COMMITMENT |
Estimated total surcharge on commitment amount |
NUMBER |
22 |
EST_SURCHARGE_ON_COMMIT_NON_BL |
Estimated total surcharge on non-blanket order commitment amount |
NUMBER |
22 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
NON_BL_ORDER_COMMITMENT_AMOUNT |
Non-blanket order commitment amount. |
NUMBER |
22 |
RECORD_TYPE |
This field can contain different values in different tables. In the Summary Statement Detail table, it contains either "Posted" or "Calculated", referring to the nature of the record. In the Estimated Surcharges table, field values are "ACT"(actual) or "EST" (estimated). |
VARCHAR2 |
3 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |