DW_GLOBAL_EXCH_RATE_CG

This table contains information about the global exchange rate.

Details

Module:

Key Columns

FROM_CURRENCY_CODE, CONVERSION_DATE

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     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.