18/09/2023 03:18:25.0295 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/09/2023 07:11:25.5754 711 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-09-18 07:11:24','V',5273629267298420,2023,'2023-09-18 07:11:24','451852384700327005012999',2,2,2,'O','',0,'2023-09-18 07:11:24',1,'','',0) 18/09/2023 09:20:57.7152 521 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-09-18 09:20:57','V',4967352002377880,2023,'2023-09-18 09:20:56','451853365600327005012999',1,2,16,'I','',1,0,1,'','',4) 18/09/2023 09:36:48.4099 509 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-18 09:36:47',3,42101,0,50,1,50,1,'I','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'; 18/09/2023 10:39:01.9143 524 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-18 10:39:01',3,42101,0,50,1,50,1,'I','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'; 18/09/2023 13:22:55.7798 581 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5412669543042450,4910849412542280,2023,'2023-09-18 13:22:55',' Data: 9/18/2023 1:21:23 PM Codice: 451854775900327005012999 Ingresso: 9/18/2023 1:15:59 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2300606145 ',0) 18/09/2023 13:56:53.1749 549 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-18 13:56:52' where traUID = 5095947051205930 and traStatus='V' and traEnabled=1 18/09/2023 17:36:24.1089 683 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-18 17:36:23',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';