Currency_exchange_rates

This table stores currency exchange rates.
The Multiple Currency feature must be enabled.

Columns

Name Type Length Precision Scale References In Description
anchor_currency_id NUMBER 39 0 Anchor currency ID (used only when Currency Exchange Rate Integration feature is enabled)
base_currency_id NUMBER 39 0 Base currency ID
currency_id NUMBER 39 0 Currency ID for source currency (also called transaction currency or foreign currency)
currency_rate_id NUMBER 39 0 Currency rate ID
currency_rate_provider_id VARCHAR2 8 Currency rate provider ID (used only when Currency Exchange Rate Integration feature is enabled)
currency_rate_type_id NUMBER 39 0 currency_rate_type_id
Currency_exchange_rate_types
Currency exchange rate type ID (used only when Currency Exchange Rate Types feature is enabled)
date_effective TIMESTAMP Date the exchange rate becomes effective
date_last_modified TIMESTAMP Date last modified
entity_id NUMBER 39 0 entity_id
Entity
Entity ID of associated entity
exchange_rate NUMBER 30 15 Currency exchange rate
is_anchor_only VARCHAR2 3 This column does not return results. Do not use this column in your queries.
update_method_id VARCHAR2 8 Method by which exchange rate was obtained

Primary key

PK Column Name
currency_rate_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
currency_exchange_rates_currency_exchange_rate_types_fk currency_rate_type_id Currency_exchange_rate_types currency_rate_type_id 1
currency_exchange_rates_entity_fk entity_id Entity entity_id 1