06/04/2024 08:18:34.9716   671 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-04-06 08:18:29',5,3,42101,0,50,20,1000,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+20,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-04-06 08:18:29',5,3,42101,0,200,2,400,1,'I','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';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-04-06 08:18:29',5,3,42101,0,100,11,1100,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+11,5),curAmount=round(curAmount+1100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

06/04/2024 12:26:21.9369   531 ms.           EXEC: update payInventory set invCreation = '2024-04-06 12:26:21',invModify = '2024-04-06 12:26:21',invUseId=0,invStatus='V' where invId = 176606
06/04/2024 13:43:08.9862   656 ms.           EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-04-06 13:43:08',0,16,'2024-04-06 13:43:08','','Manual Open Barrier  Entry 2')
06/04/2024 19:08:20.3982   625 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
06/04/2024 20:25:27.8230   515 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-04-06 20:25:27',0,0,'V',5161000960327280,5701472726320380,2024,'2024-04-06 20:25:27',3,'KES',-1,50,-50,'N','');