 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XClearanceDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| item | item_loc | item | Yes | The item to which the markdown will apply. A valid item will have an item level at or above the transaction level if no diff is specified, or above the transaction level if a diff is specified. The item must be predefined in RMS. |
| diff_id | item_master | diff_1, diff_2, diff_3, diff_4 | No | The diff id used with an item above transaction level item to group multiple items for the markdown. The diff must be valid for the item specified. This value must be a diff id, not a diff group. |
| selling_unit_retail | item_loc | selling_unit_retail | Yes | The unit retail of the markdown in the currency specified on the message. |
| selling_uom | item_loc | selling_uom | Yes | A unit of measure which is predefined in RMS. |
| currency_code | currencies | currency_code | No | The code of the currency in which the retail is represented. This currency must be predefined in the CURRENCIES table. |
| country | country | country_id | Yes | The code of the country used to limit the locations to which the markdown 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 markdown applies. Valid values are 'CH' chain, 'AR' area, 'RE' region, 'DI' district, 'S' store, and 'W' warehouse. |
| XClearanceHrDtl | * | * | * | * |
| XClearanceExcSt | * | * | * | * |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XClearanceHrDtl |
| 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 value at the specified level of the hierarchy which encompasses the locations affected by the markdown. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XClearanceExcSt |
| 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 markdown. This field should be used only if the hier_level field indicates a level of the organizational hierarchy. |