Currency_exchange_rates

Columns

Name Type Length Precision Scale References In Description
anchor_currency_id NUMBER 39 0
base_currency_id NUMBER 39 0
currency_id NUMBER 39 0
currency_rate_id NUMBER 39 0
currency_rate_provider_id VARCHAR2 8
currency_rate_type_id NUMBER 39 0 currency_rate_type_id
Currency_exchange_rate_types
date_effective TIMESTAMP
date_last_modified TIMESTAMP
entity_id NUMBER 39 0 entity_id
Entity
exchange_rate NUMBER 30 15
is_anchor_only VARCHAR2 3
update_method_id VARCHAR2 8

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