08/07/2023 08:04:44.3219   534 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-08 08:04:40',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 ('2023-07-08 08:04:40',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 ('2023-07-08 08:04:40',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;

08/07/2023 09:08:26.1485   526 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 13019, trcLastPrinted = '2300413019', trcLastDate = '2023-07-08 09:08:25' where trcStatus='V' and trcTerId = 4
08/07/2023 12:02:19.7613   505 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
08/07/2023 20:56:06.6283   854 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-08 20:56:05',0,0,'V',4668037477896620,5705101191413210,2023,'2023-07-08 20:56:05',3,'KES',-1,50,-50,'N','');
insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-08 20:56:05',0,0,'V',4668037477896620,5705101191413210,2023,'2023-07-08 20:56:05',3,'KES',-4,100,-400,'N','');

08/07/2023 22:53:24.0615   527 ms.           EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL)