The following Excel document provides a detailed list of the tables in Microsoft Dynamics GP and many applications that integrate with it.
The diagrams that are available from the following links illustrate the database structure for Microsoft Dynamics GP. The following table indicates the colors used for each table type.
Type |
Color |
MSTR |
Yellow |
ROPT |
Green |
SETP |
Brown |
TEMP |
Grey |
WORK |
Pink |
SQL Only |
White |
All others |
Teal |