SQLs behind the "Detailed Subledger Report"

I wish to have the information from the OPM financials "Detailed Subledger report" in an excel format.  In addition, the individual lines would need to show all the header information on the journal lines.  I started putting the SQL together but it started getting too hard for me.  I know some of the tables where the information can be found but some of the sources are unknown to me.  I am having the most problem getting the gl accounts, batch number and step number, receipt number, sales order number and line, po number and line.  The gl accounts may be simplier than I