28/10/2022 12:55:05.3594 513 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,'2022-10-28 12:55:04','V',5592665743631460,2022,'2022-10-28 12:55:04','448603567000327005012999',2,2,2,'O','',0,'2022-10-28 12:55:04',1,'','',0) 28/10/2022 14:14:48.7551 522 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 ('2022-10-28 14:14:48',0,'V',4642803993918200,5031635158740910,2022,'2022-10-28 14:14:48',18,1,0,4,'2022-10-28 14:29:48','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/10/2022 15:16:25.8754 662 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-10-28 15:16:25',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'; 28/10/2022 19:21:29.5987 591 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-10-28 19:21:28',3,42101,0,500,1,500,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 500 and curType = 'N'; 28/10/2022 19:21:30.1813 514 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-10-28 19:21:29',0,0,'V',5050767790663180,5191920702831320,2022,'2022-10-28 19:21:29',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-10-28 19:21:29',0,0,'V',5050767790663180,5191920702831320,2022,'2022-10-28 19:21:29',3,'KES',-2,200,-400,'N',''); 28/10/2022 22:55:04.9030 547 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-10-28 22:55:04' where traUID = 4670991437333380 and traStatus='V' and traEnabled=1