 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:XCostChgDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| item | item_supp_country | item | 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 | item_supp_country | supplier | Yes | 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. |
| origin_country_id | item_supp_country | origin_country_id | Yes | 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. |
| diff_id | item_master | diff_1, diff_2, diff_3, diff_4 | 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 | item_supp_country | unit_cost | Yes | 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. |
| recalc_ord_ind | n/a | n/a | Yes | 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). |
| currency_code | currency | currency_code | Yes | The currency code of the unit cost. This value must be predefined on the CURRENCIES table and must be the currency of the supplier. |
| hier_level | n/a | n/a | No | 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). |
| XCostChgHrDtl | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:XCostChgHrDtl |
| 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 hierarchy value at the specified level of the hierarchy which encompasses the locations affected by the cost change. |