DW_GLOBAL_EXCH_RATE_CG

This table contains information about the global exchange rate.

Details

Module:

Key Columns

CONVERSION_DATE, FROM_CURRENCY_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FROM_CURRENCY_CODE VARCHAR2 16 True From currency code.
CONVERSION_DATE DATE True Exchange date.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source record identifier.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURR_CONVERSION_TYPE VARCHAR2 32 Global currency conversion type.
GLOBAL_EXCHANGE_RATE NUMBER Global currency conversion rate.
GLOBAL_EXCHANGE_RATE_BD BIGDECIMAL 10 Global currency conversion rate in BigDecimal format.