Retail Integration Bus Mappings Report
Release: 13.0.1
Application Name: Retail
Merchandising System
Version 13.0.1
XML-Schema or Node
Name:XMrchHrRclsRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
merch_hier_level
pend_merch_hier
hier_type
Yes
Indicates the
level of the merchandise hierarchy. Valid values are V (division), G
(group), D (department), C (class), and S (subclass).
merch_hier_id
pend_merch_hier
merch_hier_id
Yes
Contains the
merchandise hierarchy ID.
merch_hier_parent_id
pend_merch_hier
hier_parent_id
No
The parent of
the hierarchy identified in the merch_hier_id field.
merch_hier_grandparent_id
pend_merch_hier
merch_hier_grandparent_id
No
The grandparent
of the hierarchy identified in the merch_hier_id field. This column will
only be populated if the merch_hier_level = subclass. In this case, the
column will contain the dept number.