XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for CurrRateDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
from_currency |
varchar23 |
1 |
1 |
Contains the currency code that the rate exchange is from. |
currency_rates |
currency_code |
null |
null |
Yes |
Contains the currency code that the rate exchange is from. |
to_currency |
varchar23 |
1 |
1 |
Contains the currency code that the rate exchange is to. This must match the primary RMS currency system option. |
system_options |
currency_code |
null |
null |
Yes |
Contains the currency code that the rate exchange is to. This must match the primary RMS currency system option. |
conversion_date |
xs:dateTime |
1 |
1 |
Date on which the currency rate became or will become active. |
currency_rates |
effective_date |
null |
null |
Yes |
Date on which the currency rate became (or will become active). |
conversion_rate |
number20_10 |
1 |
1 |
Contains the exchange rate for the specified currency/type/effective date combination. |
currency_rates |
exchange_rate |
null |
null |
Yes |
Contains the exchange rate for the specified currency/type/effective date combination. |
user_conversion_type |
varchar230 |
1 |
1 |
Incoming conversion type (e.g. Consolidation, Operational, etc.) is translated to an exchange type code (C, O, etc) by reading the fif_currency_xref table. |
currency_rates |
exchange_type |
null |
null |
Yes |
Incoming conversion type (such as Consolidation or Operational) is translated to an exchange type code (such as C or O) by reading the fif_currency_xref table. |