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.
