Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/XMrchHrRclsRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:XMrchHrRclsRef Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XMrchHrRclsRef in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
merch_hier_level varchar21 1 1 Indicates the level of the merchandise hierarchy. Valid values are V (division), G (group), D (department), C (class), and S (subclass). pend_merch_hier hier_type null null 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 number4 1 1 Contains the merchandise hierarchy ID. pend_merch_hier merch_hier_id null null Yes Contains the merchandise hierarchy ID.
merch_hier_parent_id number4 0 1 The parent of the hierarchy identified in the merch_hier_id field. pend_merch_hier hier_parent_id null null No The parent of the hierarchy identified in the merch_hier_id field.
merch_hier_grandparent_id number4 0 1 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. pend_merch_hier merch_hier_grandparent_id null null No The grandparent of the hierarchy identified in the merch_hier_id field. This column will be populated only if the merch_hier_level = subclass. In this case, the column will contain the department number.