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.