09/12/2019 15:45:25 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0113','Longniddry Professionals shop,Longniddry Golf club,East Lothian,EH380NL','Ken Blowing','2019/12/9','Open','2070080242','COLIN FAIRWEATHER GOLF LTD','Ken@codeworx.ltd.uk')
09/12/2019 15:45:25 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0113','ADI-001','1','Pending','N')
09/12/2019 15:45:25 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0113','ADI-006','2','Pending','N')
09/12/2019 15:45:26 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0113','ADI-007','2','Pending','N')
09/12/2019 16:01:14 SQL used: INSERT INTO adidaspos.returns (acctno, partno, retreason, status, asm, asmemail, orderno, retdate) VALUES ('2070080242','ADI-007','Not required ordered in error','Pending','Ken Blowing','Ken@codeworx.ltd.uk','KB0113','2019/12/9')
09/12/2019 16:13:30 SQL used: UPDATE adidaspos.orderitems SET status = 'Returned' WHERE orderno = 'KB0113' AND partno = 'ADI-006'