Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing System
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.

XML-Schema Name:CurrRateDesc Version:13.1 Return to Top
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

XML-Schema Name:ExtOfCurrRateDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfCurrRateDesc
Table Name Column Name API Type Column Length API Required API Description