23/02/2023 07:38:57.8969   991 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,50,-19,-950,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,50,19,950,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,100,-62,-6200,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,100,62,6200,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,200,-10,-2000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,200,10,2000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,500,-2,-1000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,0,500,2,1000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 07:38:20',4,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

23/02/2023 13:06:00.5086   691 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 13:05:59',3,42101,0,100,1,100,2,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N';

23/02/2023 14:12:11.8508   720 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-02-23 14:12:11',0,0,'V',5301302333447980,4666900849162250,2023,'2023-02-23 14:12:11',3,'KES',1,100,100,'N','');

23/02/2023 14:12:12.4492   515 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 14:12:11',3,42101,0,100,1,100,2,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N';

23/02/2023 14:55:44.3485   678 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-23 14:55:43',3,42101,0,50,1,50,2,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N';

23/02/2023 17:47:33.7455   507 ms.           EXEC: update paycash set casCreation = '2023-02-23 17:47:33',casModify = '2023-02-23 17:47:33',casUseId=0,casStatus='V' where casId = 54513
23/02/2023 20:35:03.2528   506 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-02-23 20:35:02','V',5279357476512950,2023,'2023-02-23 20:35:01','449787170900327001012999',2,2,2,'O','',0,'2023-02-23 20:35:02',1,'','',0)