Hello,
I have following design for Shipment and Packaging
Shipment Item ---------* Packing Content *----------- Shipment Package
And Data requirement is :
Shipment Item
--------------
ID PART # PART CONTROL QTY
-- ----- ------------ ----
21. ABC NA 50
22. XYZ PK#1 10
23. XYZ PK#2 15
24. XYZ PK#3 20
25. ABX NA 30
26. XBV NA 20
Now,
Shipment Package needs to have following:
1. SP1 consists of:
PART# ABC QTY: 10
XYZ QTY: 15
2. SP2 consists of:
SP: SP1
XYZ QTY:10
3. SP3 consists of
XYZ QTY: 20
ABX QTY: 30
4. SP4 consists of
SP1
SP2
XBV QTY: 15
5. SP5:
XBV QTY: 5
7. SP6:
SP4
SP5
etc... cause there are various nested levels of shipment packages can
be achieved,
Question is anyone has any sugguestions on these model, casue
Parent-Child case will not work in this case.
Thanks in advance for resposes,
Anil G
>> Stay informed about: Shipment Packaging Data Model Question