Database Diagrams

The following Excel document provides a detailed list of the tables in Microsoft Dynamics GP and many applications that integrate with it.

• Table List

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.

• System Manager
• Company
• General Ledger
• Bank Reconciliation
• Multicurrency Management
• Multidimensional Analysis
• Advanced Financial Analysis
• Inventory and Bill of Materials
• Payables Management
• Purchase Order Processing
• Receivables Management
• Sales Order Processing
• Invoicing
• U.S. Payroll
• Direct Deposit