13/02/2023 09:36:48.0904   631 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 = 12 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
13/02/2023 11:54:20.1699   535 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4955357638979370,4612891801364240,2023,'2023-02-13 11:54:19','----------------------------------
%The Mall P0006032390             


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

POF 

Entry : 2/13/2023 11:16:55 AM

Date : 2/13/2023 11:54:19 AM
Code : 449684061500327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
13/02/2023 12:57:19.2509   614 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-13 12:57:18',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';

13/02/2023 14:23:07.0557   590 ms.           EXEC: update abbCards set carLastDate = '2023-02-13 14:23:06',carLastDirection='O' where carStatus='V' and carId = 8
13/02/2023 17:48:12.1362   591 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-02-13 17:48:11' where traUID = 5066120572698090 and traStatus='V' and traEnabled=1
13/02/2023 19:04:53.5993   829 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
13/02/2023 19:22:35.9085   529 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-02-13 19:22:35','V',4733100968454630,2023,'2023-02-13 19:22:35','449686847900327005012999',2,2,2,'O','',0,'2023-02-13 19:22:35',1,'','',0)
13/02/2023 19:47:08.1962   620 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 7414, trcLastPrinted = '2300707414', trcLastDate = '2023-02-13 19:47:07' where trcStatus='V' and trcTerId = 18