OVERHEAD RATES HISTORY Table
View exposing historical overhead rate records including rate values and effective periods used for retrospective financial analysis and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_SEQUENCE |
Access sequence associated with the record. |
VARCHAR2 |
4 |
ACCESS_SEQUENCE_DESC |
Description of access sequence. |
VARCHAR2 |
30 |
ALLOC_OFFSET_COST_COLLECTOR_ID |
Business identifier for the alloc offset cost collector. |
VARCHAR2 |
7 |
OVERHEAD_KEY |
Surrogate key identifying the overhead. |
VARCHAR2 |
6 |
OVERHEAD_KEY_FLAG |
Indicator identifying whether overhead key (Y/N). |
VARCHAR2 |
1 |
OVERHEAD_KEY_TYPE |
Overhead key type associated with the record. |
VARCHAR2 |
4 |
RATE |
Rate associated with the record. |
NUMBER |
11,2 |
RATE_VALID_FROM_DATE |
Date associated with rate valid from. |
DATE |
|
RATE_VALID_THRU_DATE |
Date associated with rate valid thru. |
DATE |
|
SURCHARGE_BASE_KEY |
Surrogate key identifying the surcharge base. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |