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