Blogger Devon Southall has a look at how to find the right tables in Dynamics GP for reporting. Unfortunately she missed a couple of great resources so I'll add them here.
1) The GP Table Reference in the Download section of DynamicAccounting.net. The new 2010 version includes field names as well.
2) The Support Debugging Tool. Among it's other features, the Support Debugging Tool includes a great table and field resource.