Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

Application	Retail Merchandising 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.
	CurrRateDesc ExtOfCurrRateDesc

XML-Schema Name:CurrRateDesc

Version:13.1.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.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