27/05/2023 09:25:32.1166   533 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-27 09:25:31',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';

27/05/2023 11:31:49.1800   583 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-27 11:31:48',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';

27/05/2023 11:42:10.3388   799 ms.           EXEC: update payReceipt set recCreation = '2023-05-27 11:42:09',recModify = '2023-05-27 11:42:09',recUseId=0,recStatus='V' where recId = 118959
27/05/2023 11:54:04.8074   504 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-05-27 11:53:57',12,'V',5703981151728510,4946064548590320,2023,'2023-05-27 11:53:57',17,1,0,4,'2023-05-27 12:08:57','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
27/05/2023 12:21:01.4689   557 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2023-05-27 12:21:00','V',5574388216050700,2023,'2023-05-27 12:21:00','450714446000327005012999',1,2,16,'I','',1,0,1,'','0230003947192',37,0)
27/05/2023 13:14:12.0995   764 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-05-27 13:14:11',0,0,'V',5519542662693930,5128528941934100,2023,'2023-05-27 13:14:11',3,'KES',-1,200,-200,'N','');

27/05/2023 13:39:49.9420   517 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-27 13:39:49',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 ('2023-05-27 13:39:49',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';

27/05/2023 13:51:49.7020   639 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-05-27 13:51:49' where traUID = 5613094184290480 and traStatus='V' and traEnabled=1
27/05/2023 14:28:22.1836   521 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-05-27 14:28:21','V',5742698667538540,2023,'2023-05-27 14:28:21','450714756000327005012999',2,2,2,'O','',0,'2023-05-27 14:28:21',1,'','',0)
27/05/2023 16:20:09.6058   653 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-27 16:20:08',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 ('2023-05-27 16:20:08',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';

27/05/2023 16:30:37.1136   675 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-05-27 16:30:36','V',4658141897112360,2023,'2023-05-27 16:30:36','450715773500327005012999',2,2,2,'O','',0,'2023-05-27 16:30:36',1,'','',0)
27/05/2023 17:56:20.4490   652 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-05-27 17:56:19','V',4722511379582590,2023,'2023-05-27 17:56:18','450716287400327005012999',2,2,2,'O','',0,'2023-05-27 17:56:19',1,'','',0)
27/05/2023 18:32:05.6720   534 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-27 18:32:05',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';

27/05/2023 18:48:28.8655   583 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-05-27 18:48:28',0,'V',4731472433014290,5388706743741750,2023,'2023-05-27 18:48:28',18,1,0,4,'2023-05-27 19:03:28','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)