10/10/2023 08:00:24.1103   875 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-10 08:00:18',5,3,42101,0,50,-22,-1100,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-10 08:00:18',5,3,42101,0,100,-65,-6500,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-10 08:00:18',5,3,42101,0,200,-13,-2600,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-10 08:00:18',5,3,42101,0,500,-7,-3500,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-10 08:00:18',5,3,42101,0,1000,-1,-1000,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-10 08:00:18',5,3,42101,1,0,0,0,2,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

10/10/2023 08:18:41.8339  1796 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
10/10/2023 11:11:43.2581   518 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5537659621894290,5453046348962170,2023,'2023-10-10 11:11:42','----------------------------------
%The Mall P0006032390             


          End of payment          
----------------------------------

POF 

Entry : 10/10/2023 11:02:25 AM

Date : 10/10/2023 11:11:41 AM
Code : 452073974500327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
10/10/2023 11:59:08.9358   671 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
10/10/2023 16:14:26.5458   609 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-10-10 16:14:25' where traUID = 5324705700237720 and traStatus='V' and traEnabled=1
10/10/2023 17:23:23.5458   516 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-10-10 17:23:23' where payTraUID = 4893074797252940 and payStatus='V' and payEnabled=1
10/10/2023 17:52:12.0844  1703 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
10/10/2023 18:10:01.4515   515 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
10/10/2023 20:26:02.7400   515 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-10-10 20:26:02' where traUID = 4962686274452930 and traStatus='V' and traEnabled=1