Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/XCostChgDesc/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:XCostChgDesc 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 XCostChgDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
item varchar225 1 1 The item to which the cost change applies. It can be a parent item, but its item level cannot be greater than its transaction level. This cannot be a buyer pack. item_supp_country item varchar2 25 Yes The item to which the cost change applies. It can be a parent item, but its item level cannot be greater than its transaction level. This cannot be a buyer pack.
supplier number10 1 1 The number of the supplier that sources the items the cost change affects. This value must be predefined on the SUPS table. This can be a primary or non-primary supplier. item_supp_country supplier varchar2 10 Yes The number of the supplier that sources the items affected by the cost change. This value must be predefined on the SUPS table. This can be a primary or non-primary supplier.
origin_country_id varchar23 1 1 The identifier of the origin country of the item\supplier to which the cost change will apply. This value must be predefined on the COUNTRIES table. This can be the primary or a non-primary country. item_supp_country origin_country_id varchar2 3 Yes The identifier of the origin country of the item\supplier to which the cost change applies. This value must be predefined in the COUNTRIES table. This can be the primary or a non-primary country.
diff_id varchar210 0 1 The identifier for a differentiator. This can be used with a parent or grandparent item. The cost change will "explode" to all the parent's transaction level items with the differentiator. This value must be predefined on the DIFF_IDS table. item_master diff_1, diff_2, diff_3, diff_4 null null No The identifier for a differentiator. This can be used with a parent or grandparent item. The cost change will "explode" to all the parent's transaction level items with the differentiator. This value must be predefined on the DIFF_IDS table.
unit_cost number20_4 1 1 The new unit cost of the item in the currency specified on the message. Tables item_supp_country_loc, item_loc_soh, and ordloc can also be updated, depending on the values in tags hier_level and hier_value. item_supp_country unit_cost null null Yes The new unit cost of the item in the currency specified in the message. The tables, item_supp_country_loc, item_loc_soh, and ordloc also can be updated, depending on the values in tags, hier_level and hier_value.
recalc_ord_ind varchar21 1 1 This field will indicate if orders in approved status for items on the cost change will be recalculated with the new cost. Valid values will be Y (yes) and N (no). n/a n/a null null Yes This field indicates whether orders in Approved status for items on the cost change will be recalculated with the new cost. Valid values are Y and N.
currency_code varchar23 1 1 The currency code of the unit cost. This value must be predefined on the CURRENCIES table and must be the currency of the supplier. currency currency_code null null Yes The currency code of the unit cost. This value must be predefined in the CURRENCIES table and must be the currency of the supplier.
hier_level varchar22 0 1 The hierarchy level of the hierarchy value. This field will indicate the level of the organizational hierarchy to which the cost change applies. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse). n/a n/a null null No The hierarchy level of the hierarchy value. This field indicates the level of the organizational hierarchy to which the cost change applies. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse).
XCostChgHrDtl * 0 unbounded Description is not available.

XML-Schema Name:XCostChgHrDtl 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 XCostChgHrDtl in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
hier_value number10 1 1 The hierarchy value at the specified level of the hierarchy which encompasses the locations affected by the cost change. chain, area, region, district, store, wh chain, area, region, district, store, wh null null Yes The hierarchy value at the specified level of the hierarchy that encompasses the locations affected by the cost change.