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 |
PK Column Name |
---|
currency_rate_id |
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 |