Dynamics GP Table Reference
Browse 761 tables across 37 modules. View columns, data types, and build SQL queries.
761 Tables
20,104 Columns
37 Modules
Modules
Advanced Go Tos
2 tables
Advanced Security
8 tables
Analysis Cubes for Excel
2 tables
Analytical Accounting
29 tables
Cash Flow Management
15 tables
Collections Management
15 tables
Control Account Management
11 tables
Electronic Reconcile
15 tables
Encumbrance Management
18 tables
Enhanced Commitment Management
7 tables
Enhanced Intrastat
16 tables
Excel-Based Budgeting
6 tables
FieldService
16 tables
Financials
48 tables
Fixed Assets
16 tables
Grant Management
20 tables
HITB Report
1 tables
Human Resources
26 tables
Interfund Management
5 tables
Inventory
33 tables
ML Checks
9 tables
Manufacturing
17 tables
Misc
18 tables
Payment Document Management
19 tables
Payroll
22 tables
Project Accounting
112 tables
Purchase Order Enhancements
11 tables
Purchasing
38 tables
Report Scheduler
13 tables
Revenue Expense Deferrals
15 tables
Safe Pay
10 tables
Sales
48 tables
SmartList
33 tables
SmartList Builder
15 tables
System
34 tables
Technical Service Tools
15 tables
VAT Daybook
23 tables