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 |