Retrieve GP Table Listing

The following tables can be queried to retrieve the table listings in the Great Plains database.

Retrieve the list of tables, the series they belong to, and their physical names:

SELECT --top 100 
   *
FROM DYNAMICS..SY40501

Retrieve the BARULEID and AliasName for each field:

SELECT --top 100 
   *
FROM DYNAMICS..SY40502

Retrieve the columns for the tables:

SELECT --top 100 
   *
FROM DYNAMICS..SY40503