Oracle Portal
 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.