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.