16/05/2024 07:43:43.8623   640 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4775160675171330,5403841624302580,2024,'2024-05-16 07:43:43','----------------------------------
%The Mall P0006032390             


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

POF 

Entry : 5/16/2024 6:53:01 AM

Date : 5/16/2024 7:43:41 AM
Code : 454262478100327001012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 100.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 50.00 KES',0)
16/05/2024 11:28:42.5400   515 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,'2024-05-16 11:28:42','V',5552927376947080,2024,'2024-05-16 11:28:41','454263925400327005012999',2,2,2,'O','',0,'2024-05-16 11:28:42',1,'','',0)
16/05/2024 13:26:27.4914   703 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,'2024-05-16 13:26:26','V',5078218175119060,2024,'2024-05-16 13:26:26','454264481700327005012999',2,2,2,'O','',0,'2024-05-16 13:26:26',1,'','',0)
16/05/2024 13:39:47.1822   640 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 ('2024-05-16 13:39:44',0,'V',5754104748645290,5697038627029440,2024,'2024-05-16 13:39:44',3,1,0,4,'2024-05-16 13:54:44','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
16/05/2024 14:35:43.1741   531 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc
16/05/2024 14:38:28.3009  1140 ms.           OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
16/05/2024 14:46:44.8098   515 ms.           EXEC: update paycash set casCreation = '2024-05-16 14:46:44',casModify = '2024-05-16 14:46:44',casUseId=0,casStatus='V' where casId = 164900
16/05/2024 17:38:57.1310   546 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-05-16 17:38:56' where payTraUID = 5147097451327880 and payStatus='V' and payEnabled=1