10/11/2022 07:55:11.0281   724 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-10 07:54:56',5,3,42101,0,50,-24,-1200,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-10 07:54:56',5,3,42101,0,50,24,1200,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-10 07:54:56',5,3,42101,0,100,-55,-5500,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-10 07:54:56',5,3,42101,0,100,55,5500,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-10 07:54:56',5,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

10/11/2022 13:29:41.9459   520 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-11-10 13:29:41',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';

10/11/2022 14:08:51.5674   549 ms.           EXEC: update payInventory set invCreation = '2022-11-10 14:08:51',invModify = '2022-11-10 14:08:51',invUseId=0,invStatus='V' where invId = 21365
10/11/2022 14:15:33.2944   560 ms.           EXEC: update abbCards set carLastDate = '2022-11-10 14:15:32',carLastDirection='O' where carStatus='V' and carId = 14
10/11/2022 15:40:18.7856   594 ms.           EXEC: update payInventory set invCreation = '2022-11-10 15:40:18',invModify = '2022-11-10 15:40:18',invUseId=0,invStatus='V' where invId = 21406
10/11/2022 15:43:01.4068   507 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4733175977966490,5750671977573710,2022,'2022-11-10 15:43:00','----------------------------------
%The Mall P0006032390             


          End of payment          
----------------------------------

POF 

Entry : 11/10/2022 2:31:40 PM

Date : 11/10/2022 3:43:00 PM
Code : 448735230000327005012999

Total           : 100.00 KES

VAT 16%         : 13.79 KES
----------------------------------
   Paid            : 100.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
10/11/2022 15:46:05.7139   523 ms.           EXEC: update abbCards set carLastDate = '2022-11-10 15:46:05',carLastDirection='I' where carStatus='V' and carId = 36
10/11/2022 16:36:28.0802   608 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-10 16:36:27',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';