Item Hierarchy
In ScopeTechnical: ITEM_HIERARCHY | ID: OR-STO-ITEM_HIERARCHY-ITEM_HIERARCHY
merchandise hierarchy mastar table.
See how this object fits into Store Operations
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_HIERARCHY
Field Definitions(5)
Rules & Considerations(12)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | STATUS | CLASS_ID | CLASS_NAME | SUBCLASS_ID | DEPARTMENT_ID | PURCHASE_TYPE | SUBCLASS_NAME | DEPARTMENT_NAME |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE |
| default | 3 | P | 1000000003 | Womenswear | 1000000003 | 1000000003 | 1 | Fashion Range | Item Hierarchy Secondary |
| default | 5 | A | 1000000005 | Kidswear | 1000000005 | 1000000005 | 2 | Value Range | Item Hierarchy Core |
Example values from field definitions
- IDRPK
- 1
- STATUS
- S
- CLASS_ID
- 1
- CLASS_NAME
- SAMPLE
- SUBCLASS_ID
- 1
- DEPARTMENT_ID
- 1
- PURCHASE_TYPE
- 1
- SUBCLASS_NAME
- SAMPLE
- DEPARTMENT_NAME
- SAMPLE
default
- IDRPK
- 3
- STATUS
- P
- CLASS_ID
- 1000000003
- CLASS_NAME
- Womenswear
- SUBCLASS_ID
- 1000000003
- DEPARTMENT_ID
- 1000000003
- PURCHASE_TYPE
- 1
- SUBCLASS_NAME
- Fashion Range
- DEPARTMENT_NAME
- Item Hierarchy Secondary
default
- IDRPK
- 5
- STATUS
- A
- CLASS_ID
- 1000000005
- CLASS_NAME
- Kidswear
- SUBCLASS_ID
- 1000000005
- DEPARTMENT_ID
- 1000000005
- PURCHASE_TYPE
- 2
- SUBCLASS_NAME
- Value Range
- DEPARTMENT_NAME
- Item Hierarchy Core
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 12