on 2020 Jul 28 10:10 AM
SELECT
T0.MthAcctCod
,T0.MatchNum
,T0.Totals
,T0.MatchDate
,T1.TransId
,t1.DueDate
,T1.[Account]
,T1.[Debit]
,T1.[Credit]
,T1.[IntrnMatch]
,T1.[ExtrMatch]
,T1.Ref1
,T1.[LineMemo]
,T2.DueDate
,T2.DebAmount
,T2.CredAmnt
,T2.Sequence
FROM OMTH T0
INNER JOIN JDT1 T1 ON T0.MatchNum = T1.[ExtrMatch]
inner join OBNK T2 ON T2.BankMatch = T0.MatchNum
where
T0.MatchNum = [%0]
--and
--T0.MthAcctCod = '1.01.01.02.01'
--AND T1.[Account] = '1.01.01.02.01'
--AND T2.AcctCode = '1.01.01.02.01'
order by T0.MatchNum , t1.TransId
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
9 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.