Data Model

Data Flow and Table Names UPDATED
This post is an update and combination of the  Dynamics GP Table Names article and the Moving Transactions from Work to Open to History article. It's been updated to expand the data progression explanation and to add more table names.
 
Dynamics GP Table Names
This post explains the naming convention for the GP tables. Reading this will help you find the data you are looking for.

Moving Transactions from Work to Open to History
This post explains how transactions move from the Work table, to Open (if applicable), and then to the History table. Modules covered are GL, AP, AR, SOP, POP, and Inventory.