ESTIMATED SURCHARGES Table
View exposing estimated surcharge records including overhead, employee benefit, and allocation surcharge amounts calculated on expenses and commitments by cost collector, general ledger account, and fiscal period.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
18,2 |
COMMITMENT_AMOUNT |
Commitment amount associated with the record. |
NUMBER |
13,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
EST_EB_ON_AMOUNT |
Est eb on amount associated with the record. |
NUMBER |
13,2 |
EST_EB_ON_COMMITMENT |
Est eb on commitment associated with the record. |
NUMBER |
13,2 |
EST_EB_ON_COMMIT_NON_BL |
Est eb on commit non bl associated with the record. |
NUMBER |
13,2 |
EST_LAB_ALLOC_ON_AMOUNT |
Est lab alloc on amount associated with the record. |
NUMBER |
13,2 |
EST_LAB_ALLOC_ON_COMMITMENT |
Est lab alloc on commitment associated with the record. |
NUMBER |
13,2 |
EST_LAB_ALLOC_ON_COM_NON_BL |
Est lab alloc on com non bl associated with the record. |
NUMBER |
13,2 |
EST_OH_ON_AMOUNT |
Est oh on amount associated with the record. |
NUMBER |
13,2 |
EST_OH_ON_COMMITMENT |
Est oh on commitment associated with the record. |
NUMBER |
13,2 |
EST_OH_ON_COMMIT_NON_BL |
Est oh on commit non bl associated with the record. |
NUMBER |
13,2 |
EST_SURCHARGE_ON_AMOUNT |
Est surcharge on amount associated with the record. |
NUMBER |
13,2 |
EST_SURCHARGE_ON_COMMITMENT |
Est surcharge on commitment associated with the record. |
NUMBER |
13,2 |
EST_SURCHARGE_ON_COMMIT_NON_BL |
Est surcharge on commit non bl associated with the record. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
NON_BL_ORDER_COMMITMENT_AMOUNT |
Non bl order commitment amount associated with the record. |
NUMBER |
13,2 |
RECORD_TYPE |
Record type associated with the record. |
VARCHAR2 |
3 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
TIMESTAMP(6) |