28/05/2025 08:42:38.0469   699 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 ('2025-05-28 08:42:36',0,'V',5247415393757550,4625864012680490,2025,'2025-05-28 08:42:36',3,1,0,4,'2025-05-28 08:57:36','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
28/05/2025 08:42:42.5896  4531 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4625864012680490,5247415393757550,2025,'2025-05-28 08:42:38','----------------------------------
%The Mall P0006032390             


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

POF 

Entry : 5/28/2025 8:28:49 AM

Date : 5/28/2025 8:42:36 AM
Code : 458033052900327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
28/05/2025 08:42:45.9768  2824 ms.           EXEC: update paycash set casCreation = '2025-05-28 08:42:43',casModify = '2025-05-28 08:42:43',casUseId=0,casStatus='V' where casId = 223252
28/05/2025 08:42:49.1682  3191 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-05-28 08:42: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';

28/05/2025 08:42:49.7677   598 ms.           EXEC: update payInventory set invCreation = '2025-05-28 08:42:49',invModify = '2025-05-28 08:42:49',invUseId=0,invStatus='V' where invId = 253182
28/05/2025 11:19:03.7349   512 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
28/05/2025 12:13:05.9623   541 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-05-28 12:13:05' where traUID = 5514186132750050 and traStatus='V' and traEnabled=1
28/05/2025 12:19:18.6720   518 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 3 ms.)
28/05/2025 12:38:12.5150   562 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
28/05/2025 13:45:15.9028   614 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-05-28 13:45:15' where traUID = 5034915943878650 and traStatus='V' and traEnabled=1
28/05/2025 14:19:03.7872   549 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-05-28 14:19:03',0,0,'V',4643391476917480,4952688286973130,2025,'2025-05-28 14:19:03',3,'KES',1,100,100,'N','');

28/05/2025 14:56:15.0024   520 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 ('2025-05-28 14:53:38',12,'V',5602813652053120,5320166845256880,2025,'2025-05-28 14:53:38',17,1,0,4,'2025-05-28 15:08:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
28/05/2025 20:20:48.5884   515 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-05-28 20:20:47',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';