25/02/2023 10:48:25.3387 537 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-25 10:48:24','V',5476990060708130,2023,'2023-02-25 10:48:24','449803714400327005012999',2,2,2,'O','',0,'2023-02-25 10:48:24',1,'','',0) 25/02/2023 14:41:42.7611 591 ms. EXEC: update payReceipt set recCreation = '2023-02-25 14:41:42',recModify = '2023-02-25 14:41:42',recUseId=0,recStatus='V' where recId = 77519 25/02/2023 15:41:20.5468 513 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-25 15:39:38',4,3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-25 15:39:38',4,3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 25/02/2023 21:17:54.0735 593 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 ('2023-02-25 21:17:37',6,'V',5397464293887830,4755190098575090,2023,'2023-02-25 21:17:37',4,1,0,4,'2023-02-25 21:32:37','P','KES',100,100,0,'','','',1,100,0,0,'',0,0)