08/12/2023 10:34:15.0041   562 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4765491617910170,5244455474026060,2023,'2023-12-08 10:34:14','----------------------------------
%The Mall P0006032390             


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

POF 

Entry : 12/8/2023 10:08:03 AM

Date : 12/8/2023 10:34:13 AM
Code : 452663648300327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
08/12/2023 11:34:06.8467   515 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc
08/12/2023 11:56:07.4173   671 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2023-12-08 11:56:06','V',5101951993769790,2023,'2023-12-08 11:56:06','452664296600327005012999',1,2,16,'I','',1,0,1,'','',4)
08/12/2023 12:48:07.2971   531 ms.           EXEC: update payInventory set invCreation = '2023-12-08 12:48:06',invModify = '2023-12-08 12:48:06',invUseId=0,invStatus='V' where invId = 147025
08/12/2023 15:08:23.7034   640 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-12-08 15:08:23' where traUID = 5288414870031490 and traStatus='V' and traEnabled=1
08/12/2023 15:26:22.4278   657 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-12-08 15:26:21',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';

08/12/2023 15:53:45.0947   562 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-12-08 15:53:44',0,0,'V',4981070873677810,5050488243292320,2023,'2023-12-08 15:53:44',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-12-08 15:53:44',0,0,'V',4981070873677810,5050488243292320,2023,'2023-12-08 15:53:44',3,'KES',-1,100,-100,'N','');

08/12/2023 16:35:05.0888   593 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2023-12-08 16:35:04','V',5583046730897610,2023,'2023-12-08 16:35:03','452665970300327005012999',1,2,16,'I','',1,0,1,'','',4)
08/12/2023 16:36:58.5495   562 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2023-12-08 16:36:57','V',5112357924432130,2023,'2023-12-08 16:36:56','452665981600327005012999',1,2,16,'I','',1,0,1,'','0810007106930',88,0)
08/12/2023 20:06:44.2068   546 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2023-12-08 20:06:43','V',5181797422056800,2023,'2023-12-08 20:06:42','452666712800327005012999',2,2,2,'O','',0,'2023-12-08 20:06:43',1,'','',0)
08/12/2023 21:55:39.9634   515 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-12-08 21:55:38' where traUID = 5581651247377160 and traStatus='V' and traEnabled=1