07/08/2025 08:04:22.6490 810 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 07/08/2025 10:59:42.2078 516 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-07 10:59:41',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'; 07/08/2025 13:31:33.0346 2920 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 ('2025-08-07 13:31:30',0,'V',5593505445777710,5507776901517310,2025,'2025-08-07 13:31:30',18,1,0,4,'2025-08-07 13:46:30','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/08/2025 13:42:26.5074 747 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-08-07 13:42:25',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 ('2025-08-07 13:42: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'; 07/08/2025 15:43:23.1605 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/08/2025 16:00:55.9619 750 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-07 16:00:55',3,41101,0,10,2,20,1,'I','C'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+20,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 10 and curType = 'C'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-07 16:00:55',3,41101,0,20,1,20,1,'I','C'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+20,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 20 and curType = 'C'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-08-07 16:00:55',3,41003,0,5,2,10,2,'I','C'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+10,5) where curTerId = 3 and curDevCode = 41003 and curChannelId = 2 and curValue = 5 and curType = 'C'; 07/08/2025 16:09:23.6636 579 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-08-07 16:09:23' where traUID = 5263951586023970 and traStatus='V' and traEnabled=1