Follow

Query: Check Cleared

Summary

This query displays whether or not a check has cleared.  It prompts the user for a check #.

 

Query Location:

Queries > Orchestarted Banking Queries > Check Cleared Query

 

Example Data:

 

Query Script:

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.

====

SELECT *

FROM OCHO T0

INNER JOIN JDT1 T1 ON T1.CheckAbs = T0.CheckKey

WHERE T0.CheckNum = [%0]

====

 

 

Version 4.5.1.0

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments