14/05/2024 07:24:31.7240 515 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 299452 else acvFstPayId end),acvLstPayId = 299452 where acvSftId = 715 and acvCodeId = 3 14/05/2024 10:26:58.4065 593 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-05-14 10:26:57',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/05/2024 11:33:53.7040 562 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-05-14 11:33:53' where traUID = 5468562615733020 and traStatus='V' and traEnabled=1 14/05/2024 11:42:59.9356 578 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-14 11:45:44',6,'V',5492095707837830,4935152617626580,2024,'2024-05-14 11:45:44',4,1,0,4,'2024-05-14 12:00:44','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/05/2024 14:14:54.0957 609 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4906974268350200,5667899049844270,2024,'2024-05-14 14:14:53',' Date: 5/14/2024 2:17:38 PM Code: 454244812600327005012999 Entry Date: 5/14/2024 1:22:06 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400406977 ',0) 14/05/2024 17:09:54.4395 515 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-05-14 17:09:53' where payTraUID = 4736114987641330 and payStatus='V' and payEnabled=1 14/05/2024 20:59:29.2730 593 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100