Query: Deposit Detail

Owned by Brad Windecker (Unlicensed)
Feb 09, 2014
1 min read

This query shows all the entries in a Deposit

It can be found here: Queries > OBEER Banking Queries > Deposit Detail

 

====

SELECT T0.[CardCode], T1.[CardName], T0.[CheckKey], T0.[CheckDate],T0.[CheckNum],  T0.[BankCode], T0.[CheckSum], T2.[DeposNum] AS 'Deposit No.', T2.[DeposDate] AS 'Deposit Date', T3.[FormatCode] AS 'GL Account Deposited', T4.[DocNum] AS 'Incoming Payment Doc No.', T4.[DocDate] AS 'Incoming Payment Date'

FROM OCHH T0  

INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode

LEFT JOIN ODPS T2 ON T0.DpstAbs = T2.DeposId

LEFT JOIN OACT T3 ON T2.BanckAcct = T3.AcctCode

LEFT JOIN ORCT T4 ON T4.DocEntry = T0.RcptNum

WHERE T2.[DeposNum] = [%0]

====