Share this page
FM_COST_RATES_HISTORY
This table stores the old values of cost rates.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
COST_RATE_ID |
NOT NULL |
NUMBER |
Indicates the cost rate ID from FM_COST_RATES. |
|
EFFECTIVE_START_DATE |
NULLABLE |
DATE |
Effective start date for this rate |
|
EFFECTIVE_END_DATE |
NULLABLE |
DATE |
Effective end date for this rate. Null implies the rate is applicable forever. |
|
CURRENCY_CODE |
NOT NULL |
VARCHAR2 |
Three-letter currency code to which this rate is applied |
|
RATE |
NOT NULL |
NUMBER |
Actual rate multiplied by 100 so that decimals are not used |
|
COST_RULE_ID |
NULLABLE |
NUMBER |
Cost rule ID for which this rate is used |
|
AUDIT_EVENT_ID |
NULLABLE |
NUMBER |
Indicates the audit event ID from ITG_AUDIT_EVENTS |
|
FLAG |
NULLABLE |
NUMBER |
Flag to indicate whether the cost rate is edited or deleted. 0 means the cost rate is edited. 1 means the cost rate is deleted. |
Indexes
This table does not have any indexes.
Sequences
This table does not have any sequences.
