Exchange Rate Mapping
The exchange rate data is loaded from the EXCH_RATE.csv file or from RMFCS.
| Measure | Target Table | Target Column | Data Source |
|---|---|---|---|
|
Start Date |
W_PDS_EXCH_RATE_G |
EFFECTIVE_DATE |
W_EXCH_RATE_G.START_DT |
|
From Currency Code |
W_PDS_EXCH_RATE_G |
FROM_CURRENCY_CODE |
W_EXCH_RATE_G.W_FROM_CURCY_CODE |
|
To Currency Code |
W_PDS_EXCH_RATE_G |
TO_CURRENCY_CODE |
W_EXCH_RATE_G.W_TO_CURCY_CODE |
|
Exchange Rate Type |
W_PDS_EXCH_RATE_G |
EXCHANGE_TYPE |
W_EXCH_RATE_G.RATE_TYPE |
|
Exchange Rate |
W_PDS_EXCH_RATE_G |
EXCHANGE_RATE |
W_EXCH_RATE_G.EXCH_RATE |