25/07/2023 09:11:19.7934  1501 ms.           OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal
25/07/2023 11:25:21.5940   745 ms.           EXEC: update payInventory set invCreation = '2023-07-25 11:25:20',invModify = '2023-07-25 11:25:20',invUseId=0,invStatus='V' where invId = 107957
25/07/2023 12:20:47.9467   615 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2023-07-25 12:20:46',0,'V',5416919733094000,5195265572085080,2023,'2023-07-25 12:20:46',3,1,0,4,'2023-07-25 12:35:46','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
25/07/2023 12:26:03.2594   701 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-25 12:26:02',3,42101,0,50,2,100,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';

25/07/2023 13:24:25.9627   691 ms.           EXEC: update payReceipt set recCreation = '2023-07-25 13:24:25',recModify = '2023-07-25 13:24:25',recUseId=0,recStatus='V' where recId = 144456
25/07/2023 15:14:47.6403   798 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,'2023-07-25 15:14:46','V',5595942824656030,2023,'2023-07-25 15:14:46','451304707300327005012999',2,2,2,'O','',0,'2023-07-25 15:14:46',1,'','',0)