Figure 5: Subset of QAYPEMIUSR fields and timestamp from QAYPETIDX

SELECT SUBSTR(A.QMUDTA,5,20) AS ApplicationID, B.QTITSP,
SUBSTR(A.QMUDTA,26,10) AS TxnID, SUBSTR(A.QMUDTA,25,1) AS TxnType,
SUBSTR(A.QMUDTA,41,10) AS UserID, SUBSTR(A.QMUDTA,51,8) AS
CustomerID, A.QMUADBR, A.QMUADBW, A.QMUSDBR, A.QMUSDBW
FROM MIUSR A, TIDX B WHERE A.QRECN=B.QRECN ORDER BY 2,3