Currencyrates

This table is used for backward compatibility only. To retrieve data about currency exchange rates, use the Currency_exchange_rates table.

Columns

Name Type Length Precision Scale References In Description
anchor_currency_id NUMBER 39 0 Anchor currency ID
base_currency_id NUMBER 39 0 Base currency ID
currency_id NUMBER 39 0 Currency ID
currencyrate_id NUMBER 39 0 Currency rate ID
currencyrate_provider_id VARCHAR2 8 Currency rate provider ID
date_effective TIMESTAMP Date effective
date_last_modified TIMESTAMP Date last modified
entity_id NUMBER 39 0 entity_id
Entity
User who entered a currency rate
exchange_rate NUMBER 30 15 Exchange rate
is_anchor_only VARCHAR2 3 Whether it is anchor only
update_method_id VARCHAR2 8 Update method ID

Primary key

PK Column Name
currencyrate_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
currencyrates_entity_fk entity_id Entity entity_id 1