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