19/11/2022 01:09:06.7737 591 ms. EXEC: update payReceipt set recCreation = '2022-11-19 01:09:06',recModify = '2022-11-19 01:09:06',recUseId=0,recStatus='V' where recId = 29007 19/11/2022 06:47:10.0517 525 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-19 06:47:05',4,3,42101,0,50,10,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+10,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-19 06:47:05',4,3,42101,0,200,2,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-11-19 06:47:05',4,3,42101,0,100,6,600,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+6,5),curAmount=round(curAmount+600,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 19/11/2022 12:25:17.2167 805 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-11-19 12:25:16','V',4739684615866810,2022,'2022-11-19 12:25:16','448824471600327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2022 14:34:30.0956 545 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2022-11-19 14:34:29','V',5699994128515750,2022,'2022-11-19 14:34:28','448825246800327005012999',1,2,16,'I','',1,0,1,'','0230003957463',25,0) 19/11/2022 14:50:23.1624 605 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-11-19 14:50:22',0,0,'V',5455156694488800,5612065003938080,2022,'2022-11-19 14:50:22',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-11-19 14:50:22',0,0,'V',5455156694488800,5612065003938080,2022,'2022-11-19 14:50:22',3,'KES',-1,100,-100,'N',''); 19/11/2022 21:11:02.2097 570 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-11-19 21:11:01',0,0,'V',4897889949071560,5015893923049020,2022,'2022-11-19 21:11:01',3,'KES',1,50,50,'N','');