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 |