GP Tables

Financials

48 tables in this module

The Financials module is the core of Dynamics GP, containing General Ledger (GL), Bank Reconciliation, and Multicurrency tables. GL tables store the chart of accounts, journal entries, and period balances that form the foundation of all financial reporting.

Table Description
AF00100 Financials Subsidiary Master
AF10000 Prior Period Adjustment Work
AF40100 Financials Setup
AF40101 Financials Layout Setup
AF40102 Financials Header and Footer Setup
AF40103 Financials Column Setup
AF40104 Financials Column Infix Calculation Setup
AF40105 Financials Column Postfix Calculation Setup
AF40106 Financials Row Setup
AF40107 Financials Row Range Setup
AF40108 Financials Row Totals Setup
AF40109 Financials Picture Setup
AF40110 Financials Layout Options Setup
AF40200 Financials Accelerator Header Options
AF40201 Financials Accelerator Options
CM00001 CM_DepRcpt_RGLCash_LINE_TEMP
CM00101 Checkbook Electronic Funds Transfer Master
CM20200 CM Transaction
CM20203 Checkbook EFT Transaction Batch
CM20300 CM Receipt
CM20501 CM Reconcile Adjustments
CT00002 IC COST Standard Item Class Defaults
CT00102 IC COST Item Master
CT40401 IC COST Item Class Setup
DTA10100 MDA Transaction Groups
DTA10200 MDA Transaction Codes
GL00100 Account Master
GL00102 Account Category Master
GL00105 Account Index Master
GL00105V aaBudgetAcctRange
GL00200 Budget Master
GL00201 Budget Summary Master
GL10000 Transaction Work
GL10001 Transaction Work Line Detail
GL10110 Open Year Summary Master
GL10111 Historical Year Summary Master
GL10300 General Ledger Tax Work
GL20000 Open Year Posted Transactions
GL30000 Historical Year Transactions
GL40200 Segment Description Master
IEBEGBAL ieBegBalCustomerVendorImport
IEPMTRXI ieTrxPMImport
IERMTRXI ieTrxRMImport
MC00200 Multicurrency Account Master
MC00500 Multicurrency Posting Definitions Master
MC020102 Multicurrency Receivables Transactions
MC020103 Multicurrency Payables Transactions
MC10101 MC RM Distribution Temp File