10/03/2024 08:10:54.1064   633 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,50,-17,-850,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,50,17,850,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,100,-44,-4400,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,100,44,4400,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,200,-18,-3600,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,200,18,3600,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,500,-1,-500,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,500,1,500,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,1000,-1,-1000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,0,1000,1,1000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-10 08:10:43',5,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

10/03/2024 12:03:27.4977   549 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-03-10 12:03:26' where traUID = 5640128045984520 and traStatus='V' and traEnabled=1
10/03/2024 12:10:32.1036   506 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-03-10 12:10:31',0,0,'V',5562640858405910,5245287109377160,2024,'2024-03-10 12:10:31',3,'KES',-1,50,-50,'N','');

10/03/2024 13:18:23.3477   541 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-10 13:18:22',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';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-10 13:18:22',3,42101,0,200,1,200,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';

10/03/2024 13:23:43.4766   507 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-10 13:23:42',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';

10/03/2024 16:12:26.2384   533 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-03-10 16:12:25' where traUID = 4780464598051070 and traStatus='V' and traEnabled=1
10/03/2024 23:07:58.8830   835 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1