SURCHARGE PERCENTAGES Table
Contains Overhead, EB, and Lab Allocation rates as they would have been calculated by the SAP costing sheets yesterday.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
SURCHARGE_BASE_PATTERN_KEY |
Key used to join the GL_ACCOUNT table with SURCHARGE_PERCENTAGES and SURCHARGE_POSTINGS tables. |
NUMBER |
22 |
SURCHARGE_CALC_ID |
ID generated to uniquely identify surcharge calculations for a combination of Surcharge_Base_Pattern_Key and Surcharge_Calc_Pattern_Key. |
NUMBER |
22 |
SURCHARGE_CALC_PATTERN_KEY |
Key used to join the COST_COLLECTORS_ACCESSIBLE table to the SURCHARGE_PERCENTAGES and SURCHARGE_POSTINGS tables. |
NUMBER |
22 |
SURCHARGE_PERCENT_ALLOCATION |
Calculated percentage of lab allocation charged on expenses. |
NUMBER |
22 |
SURCHARGE_PERCENT_EB |
Calculated percentage of employee benefits charged on expenses. |
NUMBER |
22 |
SURCHARGE_PERCENT_OH |
Calculated percentage of overhead charged on expenses. |
NUMBER |
22 |
SURCHARGE_PERCENT_TOTAL |
Calculated percentage showing the sum of the Surcharge_Percent_Eb, the Surcharge_Percent_Oh and the Surcharge_Percent_Allocation. |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |