Query: Check Cleared

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

Query Overview:

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

Query Location:

Queries > OBEER Banking Queries > Check Cleared Query

Example Data:

 

Query Script:

Here is the actual query text in OBeer.  If you do not already have this query, you can copy this and paste it into your Query Generator and Save into your OBeer database.

====

SELECT *

FROM OCHO T0

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

WHERE T0.CheckNum = [%0]

====