FM_COST_RATES

This table stores rates for each cost rule - the currency, the rate, the period in which the rate is in effect, and so on.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

FM_COST_RULES

COST_RULE_ID

COST_RULE_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

COST_RATE_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually.

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(255)

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

CREATED_BY

NOT NULL

NUMBER

User who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

COST_RULE_ID

NULLABLE

NUMBER

Cost rule ID for which this rate is used

COST_RATE_SEQ

NULLABLE

NUMBER

Chronological sequence when multiple cost rates are used for the same cost rule. 0 indicates the rate with the most recent effective start/end dates.

Indexes

Index Name

Index Type

Sequence

Column Name

FK9CD3EB194F9984D7_I

NONUNIQUE

1

COST_RULE_ID

SYS_C005201518

UNIQUE

1

COST_RATE_ID

Sequences

Sequence Name

Sequence Type

FM_COST_RATES_S

COST_RATE_ID