09/09/2025 09:26:09.0662 1163 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,'2025-09-09 09:26:07','V',5433971022771590,2025,'2025-09-09 09:26:07','459073396700327005012999',1,2,16,'I','',1,0,1,'','0230004100099',144,0) 09/09/2025 10:46:28.2675 608 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-09-09 10:46:27',0,'V',5266484311886410,4778726967475490,2025,'2025-09-09 10:46:27',3,1,0,4,'2025-09-09 11:01:27','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 09/09/2025 13:10:21.8885 515 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/09/2025 13:28:23.0144 2617 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/09/2025 13:28:24.0105 993 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-09-09 13:28:23' where payTraUID = 5148536248109680 and payStatus='V' and payEnabled=1 09/09/2025 13:31:22.6995 1516 ms. EXEC: update payReceipt set recCreation = '2025-09-09 13:31:21',recModify = '2025-09-09 13:31:21',recUseId=0,recStatus='V' where recId = 414330 09/09/2025 13:31:24.3683 1664 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-09-09 13:31:22',0,0,'V',4795284630474480,5058706208863450,2025,'2025-09-09 13:31:22',3,'KES',1,100,100,'N',''); 09/09/2025 13:31:58.4974 717 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-09-09 13:31:56',0,'V',5432286015351010,4829745378722660,2025,'2025-09-09 13:31:56',3,1,0,4,'2025-09-09 13:46:56','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 09/09/2025 13:32:46.7590 1473 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,'2025-09-09 13:32:45','V',5149658455826170,2025,'2025-09-09 13:32:45','459074876500327005012999',1,2,16,'I','',1,0,1,'','',4) 09/09/2025 13:32:47.5923 829 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/09/2025 14:08:49.1807 901 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,'2025-09-09 14:08:48','V',5120533072749980,2025,'2025-09-09 14:08:47','459075092700327005012999',1,2,16,'I','',1,0,1,'','',4) 09/09/2025 14:08:51.3694 2185 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/09/2025 14:08:55.8977 526 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-09-09 14:07:34',1,'V',5453898362581870,4820764959772790,2025,'2025-09-09 14:07:34',4,1,0,4,'2025-09-09 14:22:34','P','KES',200,200,0,'','','',1,200,0,0,'',0,0) 09/09/2025 14:08:56.6047 601 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 479371 else acvFstPayId end),acvLstPayId = 479371 where acvSftId = 1224 and acvCodeId = 3 09/09/2025 14:45:10.2653 637 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5528738497511750,5487672256552890,2025,'2025-09-09 14:45:09','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 9/9/2025 9:58:47 AM Date : 9/9/2025 2:45:09 PM Code : 459073592700327005012999 Total : 300.00 KES VAT 16% : 41.38 KES ---------------------------------- Paid : 1000.00 KES Coin changed : 0.00 KES Note changed : 400.00 KES Not changed Note : 300.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 09/09/2025 15:18:21.8394 722 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,'2025-09-09 15:18:21','V',4776953593761200,2025,'2025-09-09 15:18:20','459074036300327001012999',2,2,2,'O','',0,'2025-09-09 15:18:21',1,'','',0) 09/09/2025 23:05:34.3572 11655 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '459077911000327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc