 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
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 |
Version 13.0.1 |
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 |
Version 13.0.1 |
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. |