11/07/2024 09:41:53.6080 580 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5132108334931260,5345961631745800,2024,'2024-07-11 09:41:53',' Date: 7/11/2024 9:41:52 AM Code: 454822916300327005012999 Entry Date: 7/11/2024 8:06:03 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400730801 ',0) 11/07/2024 09:43:54.1607 950 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-07-11 09:43:53',3,42101,0,50,-1,-50,1,'O','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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-07-11 09:43:53',3,42101,0,100,-1,-100,1,'O','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'; 11/07/2024 11:07:02.2796 620 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-07-11 11:07:01' where traUID = 4712038610722520 and traStatus='V' and traEnabled=1 11/07/2024 12:06:55.4877 550 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/07/2024 14:34:36.1797 510 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-07-11 14:34:35',4,9,'2024-07-11 14:34:35','454824919200327001012999','Payed (Credit Card ) Ticket ') 11/07/2024 18:38:02.1714 520 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-07-11 18:38:01' where payTraUID = 4745427670514740 and payStatus='V' and payEnabled=1 11/07/2024 20:07:38.5685 590 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4717709346788550,4644227269501610,2024,'2024-07-11 20:07:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 7/11/2024 7:49:09 PM Date : 7/11/2024 8:07:37 PM Code : 454827134900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 500.00 KES Coin changed : 0.00 KES Note changed : 450.00 KES',0) 11/07/2024 22:08:08.9394 670 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-07-11 22:08:08' where traUID = 4805252106650980 and traStatus='V' and traEnabled=1