07/04/2021 09:40:12 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0131','UNIT 20 WILSON PLACE,NERSTON INDUSTRIAL ESTATE, EAST KILBRIDE,GLASGOW,G74 4QD','Ken Blowing','2021/4/7','Open','2070081371','AFFORDABLE GOLF LTD','Ken@codeworx.ltd.uk')
07/04/2021 09:40:12 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0131','ADI-003','2','Pending','N')
07/04/2021 09:40:13 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0131','ADI-008','1','Pending','N')
07/04/2021 09:48:36 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0132','DOWNFIELD GOLF CLUB,TURNBERRY AVENUE,DUNDEE,DD2 3QP','Ken Blowing','2021/4/7','Open','2070081658','BARRY SMITH GOLF PRO LTD','Ken@codeworx.ltd.uk')
07/04/2021 09:48:37 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0132','ADI-003','1','Pending','N')
07/04/2021 09:51:48 SQL used: UPDATE adidaspos.orderitems SET status = 'Returned' WHERE orderno = 'KB0131' AND partno = 'ADI-008'
07/04/2021 09:57:13 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
07/04/2021 12:03:15 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0133','WINDYHILL GOLF CLUB,BALJAFFRAY ROAD,BEARSDEN,G61 4QQ','Ken Blowing','2021/4/7','Open','2070083657','CHRIS DUFFY','Ken@codeworx.ltd.uk')
07/04/2021 12:03:15 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0133','ADI-003','2','Pending','N')
07/04/2021 12:03:15 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0133','ADI-008','1','Pending','N')
07/04/2021 12:04:14 SQL used: UPDATE adidaspos.orderitems SET status = 'Returned' WHERE orderno = 'KB0131' AND partno = 'ADI-003'