SELECT TOP (100) PERCENT dbo.CM20200.CHEKBKID, dbo.CM20200.CMTrxNum, dbo.CM20200.CMTrxType, dbo.CM20200.TRXDATE, dbo.CM20200.GLPOSTDT,
dbo.CM20200.TRXAMNT, dbo.CM20200.CURNCYID, dbo.CM20200.paidtorcvdfrom, dbo.CM20200.DSCRIPTN, dbo.CM20200.Recond, dbo.CM20200.RECONUM,
dbo.CM20200.ClrdAmt, dbo.CM20200.clearedate, dbo.CM20200.VOIDED, dbo.CM20200.AUDITTRAIL, dbo.CM20200.SOURCDOC, dbo.CM20200.SRCDOCTYP,
dbo.CM20200.SRCDOCNUM, dbo.CM20200.POSTEDDT, dbo.CM20200.Checkbook_Amount, dbo.GL00100.ACTDESCR, dbo.GL00105.ACTNUMST,
dbo.CM20400.DEBITAMT, dbo.CM20400.CRDTAMNT, dbo.CM20400.DistRef, dbo.CM20200.VOIDDATE
FROM dbo.CM20200 INNER JOIN
dbo.CM20400 ON dbo.CM20200.CMRECNUM = dbo.CM20400.CMDNUMWK INNER JOIN
dbo.GL00100 ON dbo.CM20400.ACTINDX = dbo.GL00100.ACTINDX INNER JOIN
dbo.GL00105 ON dbo.CM20400.ACTINDX = dbo.GL00105.ACTINDX
WHERE (dbo.CM20200.SOURCDOC = 'cmtrx')
ORDER BY dbo.CM20200.CMRECNUM
No comments:
Post a Comment