11/08/2023 09:25:11.2576   569 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-11 09:25:10',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';

11/08/2023 10:19:33.0026   510 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
11/08/2023 10:27:58.0064   533 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-11 10:27:57',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';

11/08/2023 10:57:51.3579   542 ms.           EXEC: update payInventory set invCreation = '2023-08-11 10:57:50',invModify = '2023-08-11 10:57:50',invUseId=0,invStatus='V' where invId = 113899
11/08/2023 14:58:34.2235   587 ms.           OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '451475058800327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1
11/08/2023 15:13:30.6836   680 ms.           EXEC: update paycash set casCreation = '2023-08-11 15:13:30',casModify = '2023-08-11 15:13:30',casUseId=0,casStatus='V' where casId = 102413
11/08/2023 15:13:31.2005   516 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-11 15:13:29',3,42101,0,200,-2,-400,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';

11/08/2023 15:14:14.1194   707 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-11 15:14:13',3,42101,0,100,-1,-100,1,'O','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';

11/08/2023 15:21:59.4540   572 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-08-11 15:21:58',0,0,'V',5536243943693130,5488685672177820,2023,'2023-08-11 15:21:58',3,'KES',1,100,100,'N','');

11/08/2023 15:22:00.8463   650 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-11 15:22:00',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';

11/08/2023 16:07:47.2876   650 ms.           EXEC: update payReceipt set recCreation = '2023-08-11 16:07:46',recModify = '2023-08-11 16:07:46',recUseId=0,recStatus='V' where recId = 151144
11/08/2023 16:10:22.0115   523 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-11 16:09:44',6,'V',5637627761089280,4738790528719220,2023,'2023-08-11 16:09:44',4,1,0,4,'2023-08-11 16:24:44','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
11/08/2023 16:40:42.7163   663 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-08-11 16:40:41' where traUID = 5721038991584980 and traStatus='V' and traEnabled=1
11/08/2023 16:41:25.6659   538 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-08-11 16:41:25' where payTraUID = 5592811531346960 and payStatus='V' and payEnabled=1
11/08/2023 19:34:51.6418   610 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-11 19:34:51',0,'V',5100399727774980,5312641602647670,2023,'2023-08-11 19:34:51',18,1,0,4,'2023-08-11 19:49:51','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
11/08/2023 23:40:07.9996   646 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-08-11 23:40:07' where payTraUID = 5610278598169460 and payStatus='V' and payEnabled=1