20/03/2023 11:15:35.3050 514 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5109854719575670,5347837639615570,2023,'2023-03-20 11:15:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 3/20/2023 10:53:03 AM Date : 3/20/2023 11:15:33 AM Code : 450033918300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 20/03/2023 15:32:54.9149 516 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-03-20 15:32:54',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';