There are a couple but for this example we are looking to recreate a fixed asset report.  There are no sample reports to choose from for fixed assets that I can see which is why I'm trying to build it myself. 

Hey Jessica , can you give me where in Sage you find fixed asset report?   That would tell me where to look in SQL.  

It's an add-in module called Noming Asset Management.  All of our reports are under the AM63A in the Sage program files.  

Ahhh ok, then I don't think the default db would have the fields created, believe it would create them afterwards.    If you have direct SQL access via MS Management Studio, you can look for the tables.   They SHOULD show up in connector I believe or you can create a raw container and just write the SQL.   

Field names will be easy, they'll match a file export, just a matter of finding tables and the keys pairs

Ahhh ok, then I don't think the default db would have the fields created, believe it would create them afterwards.    If you have direct SQL access via MS Management Studio, you can look for the tables.   They SHOULD show up in connector I believe or you can create a raw container and just write the SQL.   

Field names will be easy, they'll match a file export, just a matter of finding tables and the keys pairs

www.dropbox.com/.../am62fields.txt

Looking @ the views , linking them to together header (batch) to detail

inner join [amadjh] on [amadjh].[adjhid] = [amadjud].[ADJID}

One of the easiest ways, now that you know tables/views, is to export from the entries and look in the files with the common keys.