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 |