Advanced Retail (UK) Ltd
Company Wiki

use priarch

–Search top 1000 PO's
SELECT TOP 1000 * from dbo.purchaseorder_hdr
Order by date_time desc

–Search supplier specified PO's
SELECT TOP 1000 * from dbo.purchaseorder_hdr
where guid_supp = '@guid_supp'
Order by date_time desc

–Check PO details using guid from hdr\
SELECT * from dbo.purchaseorder_det
where guid_hdr = '@guid_hdr'
Order by date_time desc

–Update “Complete” column to make PO available back onto traxs for store.
update dbo.purchaseorder_det SET complete = 0 where guid_hdr = '@guid_hdr'