ODBC based General Ledger report

SOLVED

I am using ODBC and want a BASIC listing of all transactions. e.g. Date, AccountId, amount. So far I have looked at the tables starting with GENERAL_ (e.g. GENERAL_GL) but have not been able to tie them back to the reports that would be run in the front end. 

I am hHoping some kind sole here can point me to documentation to help me get the query to the basic transactions information