Finding SQL tables for Microsoft Dynamics GP

Written By: Julie Jensen of Integrity Data

from February 27, 2013

At times, the Resource Descriptions can be a useful tool when figuring out a table name.  However, it can be difficult to track down the exact table needed if all you know is the GP window.

For example, I would like to find the SQL table for the Employee Deduction Maintenance window.  One way to limit the search in the Resource Description table is to select Tools > Integrate > Table Import from the Employee Deduction Maintenance window.

This opens the Select a Table window which displays all the tables used for the Deduction Maintenance window.

Now you can open the Tables Names window (Tools > Resource Descriptions > Tables) and search by Table Display Name from the list of tables in the Select a Table window.