Summary
This query shows all the entries in a Deposit
How to Find
It can be found here: Queries > Orchestrated Banking Queries > Deposit Detail
Example
====
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]
====
Version 4.5.1.0
This section reads as follows:
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]