05/04/2023 10:42:51.4637   529 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-04-05 10:42:50',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';

05/04/2023 14:39:51.3869   604 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-04-05 14:39:50','V',5262635810666860,2023,'2023-04-05 14:39:50','450195279000327005012999',1,2,16,'I','',1,0,1,'','',4)
05/04/2023 14:42:44.8231   614 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-04-05 14:42:44',0,0,'V',5112994594121050,5633063658054790,2023,'2023-04-05 14:42:44',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 ('2023-04-05 14:42:44',0,0,'V',5112994594121050,5633063658054790,2023,'2023-04-05 14:42:44',3,'KES',-1,100,-100,'N','');

05/04/2023 15:18:18.6262   507 ms.           EXEC: update payReceipt set recCreation = '2023-04-05 15:18:18',recModify = '2023-04-05 15:18:18',recUseId=0,recStatus='V' where recId = 96119
05/04/2023 15:26:43.6855   543 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,'2023-04-05 15:26:43','V',5510076921332050,2023,'2023-04-05 15:26:42','450195560200327005012999',1,2,16,'I','',1,0,1,'','0230003943530',44,0)
05/04/2023 16:59:12.5097   759 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-04-05 16:59:11',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';

05/04/2023 19:00:50.5283   556 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5162152206273110,4643139701107160,2023,'2023-04-05 19:00:49','----------------------------------
%The Mall P0006032390             


          End of payment          
----------------------------------

POF 

Entry : 4/5/2023 6:38:47 PM

Date : 4/5/2023 7:00:49 PM
Code : 450196712700327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)