Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:XPriceChgDesc.xsd
Tag Name Table Name Column Name API Req Description
item item_zone_price item Yes The item to which the price change will apply. The item level of the item should be at or above the transaction level if no diff is specified, or above the transaction level if a diff is specified.
diff_id item_master diff_1, diff_2, diff_3, diff_4 No The diff id used with an above transaction level item to group multiple items for the price change. The diff must be valid for the item specified. This value must be a diff id, not a diff group.
selling_unit_retail item_zone_price selling_unit_retail No The unit retail of the price change in the currency specified on the message. If multi unit retail is not populated, this is required.
selling_uom item_zone_price selling_uom No A unit of measure which is predefined in RMS.
multi_units item_zone_price multi_units No The number of units for the multi unit price change. This field is required for a multi unit price change.
multi_unit_retail item_zone_price multi_unit_retail No The multi unit retail in the currency specified on the message. This field is required for a multi unit price change. If single unit retail is not populated, this is required.
multi_selling_uom item_zone_price multi_selling_uom No The unit of measure for the item's multi-unit retail. This value must be predefined in RMS. This field is required for a multi unit price change.
currency_code currencies currency_code Yes The code of the currency in which the retail is represented. This currency must be predefined in the CURRENCIES table.
country country country_id No The code of the country used to limit the locations to which the price change applies. This code must be predefined on the COUNTRY table.
hier_level n/a n/a Yes The level of the organizational hierarchy in which are the stores to which the price change applies. Valid values are 'CH' chain, 'AR' area, 'RE' region, 'DI' district, 'S' store, and 'W' warehouse.
XPriceChgHrDtl * * * *
XPriceChgExcSt * * * *

Application Name: Retail Merchandising System
XML-Schema or Node Name:XPriceChgHrDtl
Tag Name Table Name Column Name API Req Description
hier_value chain, area, region, district, store, wh chain, area, region, district, store, wh Yes The ID of the specified level of the hierarchy which encompasses the locations affected by the price change.

Application Name: Retail Merchandising System
XML-Schema or Node Name:XPriceChgExcSt
Tag Name Table Name Column Name API Req Description
exception_stores store store Yes The id of a store which will be EXCLUDED from the price change. This field should be used only if the hier_level field indicates a level of the organizational hierarchy.