POS Technical Documents
Microsoft RMS - Remove closed purchase orders
execute the following SQL statements individually and in successive order:delete PurchaseOrder where status=2
delete PurchaseOrderEntry where PurchaseOrderID not in (select ID from
PurchaseOrder)
delete PurchaseOrderEntryDetail where PurchaseOrderEntryID not in (select
PurchaseOrderEntryID from PurchaseOrderEntry)