Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:CurrRateDesc.xsd
Tag Name Table Name Column Name API Req Description
from_currency currency_rates currency_code Yes Contains the currency code that the rate exchange is from.
to_currency system_options currency_code Yes Contains the currency code that the rate exchange is to. This must match the primary RMS currency system option.
conversion_date currency_rates effective_date Yes Date on which the currency rate became or will become active.
conversion_rate currency_rates exchange_rate Yes Contains the exchange rate for the specified currency/type/effective date combination.
user_conversion_type currency_rates exchange_type 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.