Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
Target Name Space http://www.oracle.com/retail/integration/base/bo/CurrRateDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:CurrRateDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CurrRateDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
from_currency varchar23 1 1 Contains the currency code that the rate exchange is from. RMS.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. RMS.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. RMS.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. RMS.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. RMS.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.