Currencyrates

This table includes data related to the history of Currency Exchange Rates. To get the user that entered a currency rate, you can join this table to the Entity 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