01/07/2023 10:09:58.0407   786 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
01/07/2023 10:29:35.8087  1029 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
01/07/2023 11:26:01.7888   651 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-01 11:26:01',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';

01/07/2023 11:30:40.6724   552 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-01 11:30:40',0,0,'V',5118143343008300,5041923080270760,2023,'2023-07-01 11:30:40',3,'KES',1,100,100,'N','');

01/07/2023 13:36:33.3835   638 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-01 13:36:32',0,0,'V',5170842858634210,5496775865883300,2023,'2023-07-01 13:36:32',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-01 13:36:32',0,0,'V',5170842858634210,5496775865883300,2023,'2023-07-01 13:36:32',3,'KES',-1,100,-100,'N','');

01/07/2023 13:51:12.1421   806 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-07-01 01:51:39',9,'V',4860330585103110,5617297466074170,2023,'2023-07-01 01:51:39',4,1,0,4,'2023-07-01 02:06:39','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
01/07/2023 14:45:12.3256   532 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-01 14:45:11',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';

01/07/2023 14:52:37.8650   577 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-01 14:52:37',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';

01/07/2023 15:23:15.8359   525 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-07-01 15:23:14',0,'V',5142567232434270,5757522360524640,2023,'2023-07-01 15:23:14',3,1,0,4,'2023-07-01 15:38:14','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
01/07/2023 15:48:22.5880   591 ms.           EXEC: update payReceipt set recCreation = '2023-07-01 15:48:21',recModify = '2023-07-01 15:48:21',recUseId=0,recStatus='V' where recId = 134403
01/07/2023 15:49:37.5621   725 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-01 15:49:36',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';

01/07/2023 15:55:53.1874   506 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-01 15:55:52',0,0,'V',5186620041728440,5734604016678520,2023,'2023-07-01 15:55:52',3,'KES',1,50,50,'N','');

01/07/2023 18:27:46.6193   511 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-01 18:27:46',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';

01/07/2023 19:35:52.1285   633 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-01 19:35:51' where traUID = 5483441605245020 and traStatus='V' and traEnabled=1
01/07/2023 21:37:11.3554   550 ms.           EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2023-07-01 21:37:10',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','')