part this-partnumber this-name is handled by this-buyer
=======================================================
     S123        crankcase seal          Fred Lyons
     C821        valve cover             Jim Turner


PO this-POnum to this-vendor requires a shipment by this-date of this-qty of the part this-number this-name
===============================================================================================================
    PO298        AA manufacturing                   20020805      300                 S123      crankcase seal
    PO299        Bristol Metals                     20020808      250                 S123      crankcase seal
    PO300        Bridge Steel Co                    20020820      400                 C821      valve cover
    PO301        Reengineering LLC                  20020820      100                 C821      valve cover



for PO this-POnum shipment this-shipnum was of this-qty of the part this-partnumber this-name 
============================================================================================================
     PO298                 1                     99                     S123                crankcase seal  
     PO298                 2                     1                      S123                crankcase seal  
     PO298                 3                     200                    S123                crankcase seal  
     PO299                 1                     250                    S123                crankcase seal  
     PO300                 1                     400                    C821                valve cover  
     PO301                 1                     100                    C821                valve cover  


PO some-POnum to some-vendor requires a shipment by some-date of some-rqty of the part some-partnumber some-name
sum a-sqty : for PO that-POnum shipment some-shipnum was of some-sqty of the part that-partnumber that-name = a-total
-------------------------------------------------------------------------------------------------------------------
for PO that-POnum that-total units of the reqd that-rqty of the part that-partnumber that-name have been shipped so far


PO some-POnum to some-vendor requires a shipment by some-date of some-rqty of the part some-partnumber some-name
not : for PO that-POnum one or more shipments have been made
-------------------------------------------------------------------------------------------------------------------
for PO that-POnum 0 units of the reqd that-rqty of the part that-partnumber that-name have been shipped so far


for PO some-POnum shipment some-shipnum was of some-qty of the part some-partnumber some-name
---------------------------------------------------------------------------------------------
for PO that-POnum one or more shipments have been made


for PO some-POnum some-vendor could ship up to some-qty of the part some-partnumber some-name
for PO that-POnum the next shipment number is some-shipnum
add : for PO that-POnum shipment that-shipnum was of that-qty of the part that-partnumber that-name
-----------------------------------------------------------------------------------------------------------
SEND SHIP NOTICE that-POnum that-shipnum : that-vendor ships that-qty of the part that-partnumber that-name


for PO some-POnum shipment some-shipnum was of some-qty of the part some-partnumber some-name
del : for PO some-POnum shipment some-shipnum was of some-qty of the part some-partnumber some-name
---------------------------------------------------------------------------------------------------
REMOVE the records for shipment number that-shipnum


PO some-POnum to some-vendor requires a shipment by some-date of some-rqty of the part that-partnumber some-name
for PO that-POnum some-sqty units of the reqd that-rqty of the part that-partnumber that-name have been shipped so far
that-rqty - that-sqty = some-qty
---------------------------------------------------------------------------------------------------------------
for PO that-POnum that-vendor could ship up to that-qty of the part that-partnumber that-name


part some-partnumber some-name is handled by some-buyer
PO some-POnum to some-vendor requires a shipment by some-date of some-qtyreqd of the part that-partnumber that-name
on PO that-POnum the number of parts shipped so far is some-qtyshipped
--------------------------------------------------------------------------------------------------------------------
part that-partnumber that-name handled by buyer that-buyer has POs for vendor, date, qty reqd, and has a qty shipped
    that-POnum  that-vendor that-date  that-qtyreqd  that-qtyshipped


PO some-POnum to some-vendor requires a shipment by some-date of some-qty of the part that-number some-name
-----------------------------------------------------------------------------------------------------------
PO that-POnum is on record


PO some-POnum is on record
sum some-qty : for PO that-POnum shipment some-shipnum was of some-qty of the part some-partnumber some-name = some-total
-------------------------------------------------------------------------------------------------------------------------
on PO that-POnum the number of parts shipped so far is that-total


PO some-POnum is on record
not : for PO that-POnum there is a shipment
--------------------------------------------------------
on PO that-POnum the number of parts shipped so far is 0


for PO some-POnum shipment some-shipnum was of some-qty of the part some-partnumber some-name
---------------------------------------------------------------------------------------------
for PO that-POnum there is a shipment that-shipnum


for PO some-POnum there is a shipment some-shipnum
--------------------------------------------------
for PO that-POnum there is a shipment


PO some-POnum is on record
not : for PO that-POnum there is a shipment
-----------------------------------------------
for PO that-POnum the next shipment number is 1


PO some-POnum is on record
for PO that-POnum there is a shipment
max some-shipnum : for PO that-POnum there is a shipment some-shipnum = some-max-shipnum
that-max-shipnum + 1 = some-next-shipnum
----------------------------------------------------------------------------------------
for PO that-POnum the next shipment number is that-next-shipnum