Hierarchy is built up by Nodes and Leaves. A Leaf can be of type Item or Deal. A Deal can have Item or Deal Lines. In Hospitality, hierarchy Leaf Items can have a Modifier and/or a Recipe.
Hierarchy
Id: FINEDINING
Node
HierarchyCode: FINEDINING (Hiearchy Id)
Id: SETMENU
Leaf (Deal)
HierarchyCode: FINEDINING (Hiearchy Id)
NodeId: SETMENU (Node Id)
Id: S10011
Type: Deal
Deal
HierarchyCode: FINEDINING (Hiearchy Id)
ParentNode: SETMENU (Node Id)
DealNo: S10011 (Leaf Id)
No: COFFEE
DealLine
HierarchyCode: FINEDINING (Hiearchy Id)
ParentNode: SETMENU (Node Id)
DealNo: S10011 (Leaf Id)
DealLineCode: COFFEE (Deal No)
DealLineNo: 10000
ItemNo: 30086
Hierarchy
Id: FINEDINING
Node
HierarchyCode: FINEDINING (Hiearchy Id)
Id: MAINS
Leaf (Item)
HierarchyCode: FINEDINING (Hiearchy Id)
NodeId: MAINS (Node Id)
Id: R0001
Type: Item
Item Modifier
HierarchyCode: FINEDINING (Hiearchy Id)
ParentNode: MAINS (Node Id)
ParentItem: R0001 (Leaf Id)
Code: POT+RICE
SubCode: 04
ItemNo: 33030
Type: Item
Recipe
HierarchyCode: FINEDINING (Hiearchy Id)
ParentNode: MAINS (Node Id)
RecipeNo: R0001 (Leaf Id)
ItemNo: 34003