Advanced Retail (UK) Ltd
Company Wiki

Peregrine are using my new po send mechanism - detailed here: https://docs.google.com/document/d/1LV01NVvauHD3prl44kAUmvuTdXl4C1lkjNx3GRAdYV8/

https://advancedretail.freshdesk.com/a/tickets/190486

The new mechanism is super easy to check for outcomes:

-- get PO guid
SELECT * FROM vw_POHdr WHERE po = '?-?'

-- use view for new mechanism
SELECT * FROM [vw_POSend] WHERE guid_po = '?'

-- get same info but joined to job queue for the job that sent the data
SELECT * FROM [vw_POSend_WithJobQueue] WHERE guid_po = '?'