For Stardard situation,
Orders (Order_ID, ....)
|
/|\
OrdItems (Order_ID, ITEM, QTY, ....)
|
/|\
Shipment (SHIP_NO, Order_ID, ITEM, SHIPQTY, ....)
Serval Shipment to Finish this Orders!
How to Calculate the Left QTY (Not send to Shipment for the Orders)?
Thank you!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.