 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemRef.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| item | item_master | item | Yes | The unique identifier for the item. |
| hier_level | n/a | n/a | No | The level of the Organizational Hierarchy of the message. Valid values are; Chain, Area, Region, District |
| XItemSupRef | * | * | No | Child node. |
| XItemVATRef | * | * | No | Child node. |
| XItemImageRef | * | * | No | Child node that is not used. |
| XItemSeasonRef | * | * | No | Child node that is not used. |
| XItemUDARef | * | * | No | Child node that is not used. |
| XItemBOMRef | * | * | No | Child node. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemSupRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| supplier | item_supplier | supplier | Yes | Item Supplier affected by the deletion activity. |
| delete_children_ind | * | * | Yes | Indicates whether the deletion should be applied to all associated item/supplier records below the item level of the item specified on the deletion message. |
| XItemSupCtyRef | * | * | No | Child node. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemSupCtyRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| origin_country_id | item_supp_country | origin_country_id | Yes | The supplier country affected by the deletion activity. |
| XISCLocRef | * | * | No | Child node |
| XISCDimRef | * | * | No | Child node that is not used. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XISCLocRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| hier_id | * | * | Yes | The id of the location hierarchy level affected by the message. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XISCDimRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| dim_object | * | * | No | This node is not used. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemVATRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| vat_type | vat_item | vat_type | Yes | The vat type of the vat item info to be deleted. |
| vat_region | vat_item | vat_region | Yes | The vat region of the vat item info to be deleted. |
| vat_code | vat_item | vat_code | Yes | The vat code of the vat item info to be deleted. |
| active_date | vat_item | active_date | Yes | The active date of the vat item info to be deleted. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemImageRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| image_name | * | * | No | This node is not used. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemSeasonRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| season_id | * | * | No | This node is not used. |
| phase_id | * | * | No | Not used. |
| diff_id | * | * | No | Not used. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemUDARef |
| Tag Name | Table Name | Column Name | API Req | Description |
| uda_id | * | * | No | This node is not used. |
| display_type | * | * | No | Not used. |
| uda_value | * | * | No | Not used. |
| Application Name: Retail Merchandising System |
|
XML-Schema or Node Name:XItemBOMRef |
| Tag Name | Table Name | Column Name | API Req | Description |
| component_item | packitem | item | Yes | The pack item to be deleted. |