Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For CurrRateDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
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 (e.g. Consolidation, Operational, etc.) is translated to an exchange type code (C, O, etc) by reading the fif_currency_xref table. |
ExtOfCurrRateDesc:ExtOfCurrRateDesc
|
*
|
0
|
1
|
Provide an extension hook to customize CurrRateDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|