Follow

Query: Deposit Detail

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

 

 

Was this article helpful?
0 out of 1 found this helpful

Comments

  • Avatar
    Jane Soltys

    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]