07/11/2022 08:49:25.2092 607 ms. EXEC: update payInventory set invCreation = '2022-11-07 08:49:24',invModify = '2022-11-07 08:49:24',invUseId=0,invStatus='V' where invId = 20061 07/11/2022 09:42:42.2078 550 ms. EXEC: update payReceipt set recCreation = '2022-11-07 09:42:41',recModify = '2022-11-07 09:42:41',recUseId=0,recStatus='V' where recId = 23054 07/11/2022 09:46:37.9180 501 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2022-11-07 09:46:37' where payTraUID = 5261551673491820 and payStatus='V' and payEnabled=1 07/11/2022 11:03:11.0136 673 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2022-11-07 11:03:10','V',5749215781175290,2022,'2022-11-07 11:03:10','448703719100327005012999',2,2,2,'O','',0,'2022-11-07 11:03:10',1,'','',0) 07/11/2022 14:53:36.0610 523 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-07 14:53:35',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 07/11/2022 15:22:30.2812 520 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4826558683135360,4997841301235370,2022,'2022-11-07 15:22:29','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/7/2022 3:11:46 PM Date : 11/7/2022 3:22:28 PM Code : 448705470600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/11/2022 15:53:11.1163 641 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-11-07 15:53:10' where traUID = 4895012578019190 and traStatus='V' and traEnabled=1 07/11/2022 18:44:10.5531 662 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2022-11-07 18:44:09' where payTraUID = 5406297811562680 and payStatus='V' and payEnabled=1 07/11/2022 20:19:31.2071 682 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-11-07 20:19:30' where traUID = 5624968200482290 and traStatus='V' and traEnabled=1 07/11/2022 20:19:31.2502 725 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-07 20:19:30',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 07/11/2022 20:19:31.9917 673 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-07 20:19:31',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-07 20:19:31',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N';