Currency_exchange_rate_types
This table stores currency exchange rate types.
The following features must be enabled: Currency Exchange Rate Types, Multiple Currency, and Intercompany Framework features.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
currency_rate_type_extid |
VARCHAR2 |
255 |
|
|
|
|
Currency exchange rate type external ID |
currency_rate_type_id |
NUMBER |
|
39 |
0 |
|
|
Currency exchange rate type ID |
date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
description |
VARCHAR2 |
2000 |
|
|
|
|
Optional description of currency exchange rate type |
is_default |
VARCHAR2 |
3 |
|
|
|
|
Whether currency exchange rate type is the default |
is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Whether the currency exchange rate type is inactive |
name |
VARCHAR2 |
200 |
|
|
|
|
Unique name for currency exchange rate type |
Primary key
PK Column Name |
currency_rate_type_id |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Currency_exchange_rates_currency_exchange_rate_types_fk |
currency_rate_type_id |
Currency_exchange_rates |
currency_rate_type_id |
1 |