It can be frustrating at times to find where data is stored in the Dynamics GP database because the table names are 8 characters long. Using Resource Descriptions (MDGP Button >> Tools >> Resource Description >> Tables) can be helpful, but also can be a difficult to manage/navigate. You can also try and use the Software Development Kit (SDK), but it is a separate installation and can be even more confusing to use.
Microsoft has released a very nice file that contains tables listed by product. This list also contains references to product numbers which can be extremely useful when reviewing dexsql.logs.
You can download the files below