14/10/2021 13:26:12 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0352','HAMERSVELDSEWEG 22 D,HAMERSVELDSEWEG 22 D,GOLF USA LEUSDEN,LEUSDEN,3833 GP','Mirte de Jager','2021/10/14','Open','4200700227','DE GOLFSPECIALIST H.O.D.N.','Mirte.dejager@adidas.com') 14/10/2021 13:26:12 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0352','ADI-019','1','Pending','N') 14/10/2021 13:26:12 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0352','ADI-020','1','Pending','N') 14/10/2021 13:29:23 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber 14/10/2021 13:31:31 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('MD0353','SBC Adidas showroom B.47 Plesmanstraat 1 3833 LA Leusden The Netherlands ','Mirte de Jager','2021/10/14','Open','15','Mirte deJager','Mirte.dejager@adidas.com') 14/10/2021 13:31:31 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0353','ADI-022','2','Pending','N') 14/10/2021 13:31:31 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0353','ADI-019','1','Pending','N') 14/10/2021 13:31:31 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('MD0353','ADI-020','1','Pending','N')