This query displays whether or not a check has cleared. It prompts the user for a check #.
Queries > Orchestarted Banking Queries > Check Cleared Query
Here is the actual query text in Orchestrated. If you do not already have this query, you can copy this and paste it into your Query Generator and Save into your Orchestrated database.
FROM OCHO T0
INNER JOIN JDT1 T1 ON T1.CheckAbs = T0.CheckKey
WHERE T0.CheckNum = [%0]