21/08/2023 07:51:29.7544   534 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-08-21 07:51:26',5,3,42101,0,50,-29,-1450,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-08-21 07:51:26',5,3,42101,0,100,-56,-5600,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-08-21 07:51:26',5,3,42101,0,200,-6,-1200,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-08-21 07:51:26',5,3,42101,0,500,-5,-2500,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-08-21 07:51:26',5,3,42101,0,1000,-3,-3000,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-08-21 07:51:26',5,3,42101,1,0,0,0,2,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

21/08/2023 10:41:35.2378   538 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
21/08/2023 11:47:37.8278   541 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-08-21 11:47:37' where payTraUID = 5225226753480020 and payStatus='V' and payEnabled=1
21/08/2023 14:54:27.6545   732 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-08-21 14:54:26' where traUID = 4847564276006700 and traStatus='V' and traEnabled=1
21/08/2023 14:57:43.6773   522 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-08-21 14:57:43' where payTraUID = 4923577442921500 and payStatus='V' and payEnabled=1
21/08/2023 15:03:29.1685   649 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5657581901191550,5031900336680650,2023,'2023-08-21 15:03:28','
Date:     8/21/2023 3:03:28 PM

Code:  451575331700327005012999
Entry Date:  8/21/2023 2:48:37 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2300738724
',0)
21/08/2023 15:19:10.0025   615 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-21 15:19:09',3,42101,0,100,1,100,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';

21/08/2023 15:19:43.1604   546 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-08-21 15:18:36',12,'V',5497571562814310,5298659729080960,2023,'2023-08-21 15:18:36',17,1,0,4,'2023-08-21 15:33:36','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
21/08/2023 17:23:44.1311   816 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-21 17:23:43',3,42101,0,50,1,50,1,'I','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';

21/08/2023 17:36:56.8307   561 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
21/08/2023 18:10:05.7937   512 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 15342, trcLastPrinted = '2300415342', trcLastDate = '2023-08-21 18:10:05' where trcStatus='V' and trcTerId = 4