26/06/2024 09:59:48.3967 520 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-06-26 09:59:43',5,3,42101,0,50,14,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+14,5),curAmount=round(curAmount+700,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-06-26 09:59:43',5,3,42101,0,100,3,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 26/06/2024 12:20:44.4977 650 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4964088731800740,5119400721912150,2024,'2024-06-26 12:20:43',' Date: 6/26/2024 12:20:43 PM Code: 454674092600327005012999 Entry Date: 6/26/2024 11:22:06 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400728551 ',0) 26/06/2024 16:35:59.2401 560 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-06-26 16:35:58' where payTraUID = 4960746287527230 and payStatus='V' and payEnabled=1 26/06/2024 17:07:16.7341 520 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-06-26 17:07:16',0,0,'V',4671437831721480,5024074409180730,2024,'2024-06-26 17:07:16',3,'KES',1,100,100,'N','');