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

XML-Schema Name:XCostChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XCostChgDesc
Table Name Column Name API Type Column Length API Required 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.
ExtOfXCostChgDesc:ExtOfXCostChgDesc * 0 1 Provide an extension hook to customize XCostChgDesc. NA NA NA NA NA NA
LocOfXCostChgDesc:LocOfXCostChgDesc * 0 1 Provide an extension hook to localize XCostChgDesc. NA NA NA NA NA NA

XML-Schema Name:XCostChgHrDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XCostChgHrDtl
Table Name Column Name API Type Column Length API Required 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.
ExtOfXCostChgDesc:ExtOfXCostChgHrDtl * 0 1 Provide an extension hook to customize XCostChgHrDtl. NA NA NA NA NA NA
LocOfXCostChgDesc:LocOfXCostChgHrDtl * 0 1 Provide an extension hook to localize XCostChgHrDtl. NA NA NA NA NA NA

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

XML-Schema Name:LocOfXCostChgHrDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXCostChgHrDtl
Table Name Column Name API Type Column Length API Required API Description
InXCostChgDesc:InXCostChgHrDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrXCostChgDesc:BrXCostChgHrDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

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

XML-Schema Name:LocOfXCostChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXCostChgDesc
Table Name Column Name API Type Column Length API Required API Description
InXCostChgDesc:InXCostChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXCostChgDesc:BrXCostChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA