DW_GLOBAL_EXCH_RATE_CG
This table contains information about the global exchange rate.
Details
Module:
Key Columns
CONVERSION_DATE, FROM_CURRENCY_CODE
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. |