Extracting Detailed Journal Entries

I am trying to write an GL detail report in Crystal or SQL that should include the following data. I think I can get most of the information from GLTRANS. Lawson suggested I extract the data from GL90 but that seems very simple Company department code account code as assigned by client in their GL Sub account Fiscal Month Fiscal year amount Post date of the transaction line Item description of the transaction line Journal number Journal line umber Journal entry type Journal entry sequence number Journal entry line description batch number effective date update date adjusted total transaction ID