27/12/2022 02:16:26.2983   562 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
27/12/2022 13:04:25.8472   593 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-12-27 13:04:25',3,41101,0,10,1,10,1,'I','C');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+10,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 ('2022-12-27 13:04:25',3,41101,0,20,2,40,1,'I','C');
update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+40,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 20 and curType = 'C';

27/12/2022 16:42:51.7118   656 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-12-27 16:42:50',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 ('2022-12-27 16:42:50',3,42101,0,100,-1,-100,1,'O','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';

27/12/2022 20:58:33.9159   563 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-12-27 20:58:33',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';