LineId in Product Hierarchy
Use of Line Id in the Product Hierarchy
· The value of Line Id is important when the same product comes more than once in Product Hierarchy.
· User has to specify the different Line Ids for the product of the different brands.
· Suppose, we have two brands of camera i.e., Sony and Cannon Both brands manufacture cameras.
· If the Camera of Sony is given ‘0’ as Line Id, then the Camera of Cannon will be given ‘1’ as Line Id.
· This is done to eliminate any confusion while creating parent-child relation.
· Example,
Product Master
| Product id | Line Id |
|---|---|
| Sony | 0 |
| Cannon | 0 |
| Camera | 0 |
| Camera | 1 |
Product Detail
| Parent Product Id | Parent Line Id | Child Product Id | Child Line Id |
|---|---|---|---|
| Sony | 0 | Camera | 0 |
| Cannon | 0 | Camera | 1 |