10/12/2019 09:33:12 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0114','Tewkesbury Road, Cheltenham','Ken Blowing','2019/12/10','Open','1001','American Golf Cheltenham','Ken@codeworx.ltd.uk')
10/12/2019 09:33:12 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0114','ADI-001','1','Pending','N')
10/12/2019 09:33:12 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0114','ADI-006','1','Pending','N')
10/12/2019 09:33:12 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0114','ADI-007','1','Pending','N')
10/12/2019 13:32:45 SQL used: INSERT INTO adidaspos.queries (raisedby, type, details, status, dateopened, asmemail) VALUES ('Ken Blowing','Part','Part Query for ADI-001: How big is it ','Open','2019/12/10','Ken@codeworx.ltd.uk')
10/12/2019 13:36:30 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0115','ROYAL DORNOCH GOLF CLUB,GOLF ROAD,DORNOCH,IV25 3LW','Ken Blowing','2019/12/10','Open','2070083282','ANDREW SKINNER','Ken@codeworx.ltd.uk')
10/12/2019 13:36:31 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0115','ADI-001','1','Pending','N')
10/12/2019 13:36:31 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0115','ADI-006','2','Pending','N')
10/12/2019 13:37:53 SQL used: UPDATE adidaspos.orderitems SET status = 'Returned' WHERE orderno = 'KB0109' AND partno = 'ADI-006'