General Ledger and Bank Reconcile Tables in Dynamic GP

Below are the tables most commonly used for Dynamics GP in SQL.

General Ledger Tables:

GL00100 – Account Master
GL00102 – Account Category Master
GL00105 – Account Index Master
GL00200 – Budget Master Header
GL00201 – Budget Master Detail
GL10000 – Transaction Work
GL10001 – Transaction Work
GL10110 – Open Year Summary Master
GL10111 – Historical Year Summary Master
GL20000 – Open Year Posted Transactions
GL30000 – Historical Year Transactions
GL40200 – Segment Description Master
DTA10100 – MDA Transaction Groups
DTA10200 – MDA Transaction Codes
GL01201 – Budget Summary Master View
GL11110 – Open Year Summary Master
GL11111 – Historical Year Summary Master

Bank Reconcile Tables:

CM00100 – Checkbook Master
CM10100 – Deposit Work
CM20100 – Bank Rec Journal
CM20200 – Transactions
CM20201 – Transaction Totals
CM20300 – Receipts
CM20400 – Distributions
CM20500 – Reconciliation Headers
CM20501 – Reconcile Adjustments
CM20600 – Transfers

Hope this helps!!!

One comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s