Retail Integration Bus Mappings Report Release:13.1

(Retail Merchandizing System)

Application Retail Merchandizing 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. XMrchHrRclsRef ExtOfXMrchHrRclsRef

XML-Schema Name:XMrchHrRclsRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For XMrchHrRclsRef Table Name Column Name API Type Column Length API Required 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 only be populated if the merch_hier_level = subclass. In this case, the column will contain the dept number. ExtOfXMrchHrRclsRef:ExtOfXMrchHrRclsRef * 0 1 Provide an extension hook to customize XMrchHrRclsRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfXMrchHrRclsRef Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXMrchHrRclsRef Table Name Column Name API Type Column Length API Required API Description