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