05/12/2019 10:17:24 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-001' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
05/12/2019 10:17:37 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0110','Tewkesbury Road, Cheltenham','Ken Blowing','2019/12/5','Open','1001','American Golf Cheltenham','Ken@codeworx.ltd.uk')
05/12/2019 10:17:38 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0110','ADI-001','2','Pending','N')
05/12/2019 10:17:59 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-001' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'
05/12/2019 10:18:11 Details request error: SELECT t1.partno,t1.allocation,t2.availstk,t3.notes FROM adidaspos.allocations as t1, adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t1.partno = 'ADI-001a' AND t1.partno = t2.partno AND t1.partno = t3.partnumber AND t1.asmemail = 'Ken@codeworx.ltd.uk'