SURCHARGE PERCENTAGES Table
View exposing surcharge percentage reference records including rate values and effective periods used in surcharge calculations.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
SURCHARGE_BASE_PATTERN_KEY |
Surrogate key identifying the surcharge base pattern. |
NUMBER |
|
SURCHARGE_CALC_ID |
Business identifier for the surcharge calc. |
VARCHAR2 |
50 |
SURCHARGE_CALC_PATTERN_KEY |
Surrogate key identifying the surcharge calc pattern. |
VARCHAR2 |
50 |
SURCHARGE_PERCENT_ALLOCATION |
Surcharge percent allocation associated with the record. |
NUMBER |
18,4 |
SURCHARGE_PERCENT_EB |
Surcharge percent eb associated with the record. |
NUMBER |
18,4 |
SURCHARGE_PERCENT_OH |
Surcharge percent oh associated with the record. |
NUMBER |
18,4 |
SURCHARGE_PERCENT_TOTAL |
Surcharge percent total associated with the record. |
NUMBER |
20,4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |