Site Search:
Sign in | Join | Help
4Penny.net

Dynamics GP

Notes, Tips and Tricks on Developing in Dynamics GP

Dynamics GP 9.0 General Ledger (GL) Tables

AF00100 Financials Subsidiary Master AF_Subsidiary_MSTR
AF10000 Prior Period Adjustment Work AF_Prior_Period_ADJ_WORK
AF40100 Financials Setup AF_Report_SETP
AF40101 Financials Layout Setup AF_Report_Layout_SETP
AF40102 Financials Header and Footer Setup AF_Report_HDR_FTR_SETP
AF40103 Financials Column Setup AF_Report_Column_SETP
AF40104 Financials Column Infix Calculation Setup AF_Report_COL_Infix_SETP
AF40105 Financials Column Postfix Calculation Setup AF_Report_COL_Postfix_SETP
AF40106 Financials Row Setup AF_Report_Row_SETP
AF40107 Financials Row Range Setup AF_Report_Row_Range_SETP
AF40108 Financials Row Totals Setup AF_Report_Row_Total_SETP
AF40109 Financials Picture Setup AF_Report_Picture_SETP
AF40110 Financials Layout Options Setup AF_Report_Layout_Options_SETP
AF40200 Financials Accelerator Header Options AF_Accelerator_HDR
AF40201 Financials Accelerator Options AF_Accelerator_LINE
AF40202 Financials Activity AF_Activity
AF40203 Financials Report Layout Changes Temporary AF_Report_Layout_Changes
AF40204 Financials Modified Report Temporary AF_Reports_Being_Modified
AF50000 Net Profit Temporary AF_Net_Profit_TEMP
AF50001 Net Profit Header Temporary AF_Net_Profit_HDR_TEMP
AF50004 Net Profit Account TEMP AF_Net_Profit_ACCT_TEMP
AF50100 Financials Total Temporary AF_Total_TEMP
AF50200 Financials Subsidiary Total Temporary AF_Subsidiary_Total_TEMP
AF50300 Report Column Temporary AF_Report_Column_TEMP
CM00001 CM_DepRcpt_RGLCash_LINE_TEMP CM_DepRcpt_RGLCash_LINE_TEMP
CM00002 CM Unreconciled TEMP CM_Unreconciled_TEMP
CM00100 CM Checkbook Master CM_Checkbook_MSTR
CM00101 Checkbook Electronic Funds Transfer Master cmCheckbookEFT
CM00200 CM Merchant Setup cmMerchantSetup
CM00201 CM Merchant Checkbook Store cmMerchantCheckbookStore
CM00500 CM_CheckbookList CM_CheckbookList_View
CM10100 CM Deposit Work CM_Deposit_WORK
CM10101 CM Deposit Work Totals CM_Deposit_Work_Totals
CM20100 CM Journal CM_Journal
CM20200 CM Transaction CM_Transaction
CM20201 CM Transaction Totals CM_Transaction_Totals
CM20202 Checkbook Transaction Electronic Funds Trans cmTransactionEFT
CM20300 CM Receipt CM_Receipt
CM20400 CM Distribution CM_Distribution
CM20400 CM Distribution Duplicate CM_Distribution_DUP
CM20500 CM Reconcile Header CM_Reconcile_HDR
CM20501 CM Reconcile Adjustments CM_Reconcile_Adjustments
CM20600 CM Transfer CM_Transfer
CM40100 CM Setup CM_SETP
CM40101 CM Transaction Type Setup CM_Transaction_SETP
CM90000 CM Transmission Log cmTransmissionLog
DTA00100 Analysis Group Master DTA_Group_MSTR
DTA00200 Analysis Codes Master DTA_Code_MSTR
DTA00300 Account Analysis Groups DTA_Account_Groups
DTA00301 Account Analysis Group Codes DTA_Account_Group_Codes
DTA00700 Transaction Analysis Report Options DTA_Analysis_ROPT
DTA10100 Transaction Analysis Groups DTA_Transaction_Groups_WORK
DTA10200 Transaction Analysis Codes DTA_Transaction_Codes_WORK
GL00100 Account Master GL_Account_MSTR
GL00100 Account Master Copy A GL_Account_MSTR_CopyA
GL00100 Distribution Account Master GL_Distribution_Account_MSTR
GL00100 Breakdown Account Master GL_Breakdown_Account_MSTR
GL00100F1 Account Master Filter1 GL_Account_MSTR_Filter1
GL00100F2 Account Master Filter2 GL_Account_MSTR_Filter2
GL00100F3 Account Master Filter3 GL_Account_MSTR_Filter3
GL00100F4 Account Master Filter4 GL_Account_MSTR_Filter4
GL00102 Account Category Master GL_Account_Category_MSTR
GL00103 Fixed Allocation Master GL_Allocation_Fixed_MSTR
GL00104 Variable Allocation Master GL_Allocation_Variable_MSTR
GL00105 Account Index Master GL_Account_Index_MSTR
GL00200 Budget Master GL_Budget_MSTR
GL00201 Budget Summary Master GL_Budget_SUM_MSTR
GL01201 GL_Budget_SUM_MSTR_View GL_Budget_SUM_MSTR_View
GL10000 Transaction Work GL_TRX_HDR_WORK
GL10001 Transaction Amounts Work GL_TRX_LINE_WORK
GL10002 Transaction Clearing Amounts Work GL_TRX_Clearing_WORK
GL10100 Quick Journal Work GL_Business_Form_HDR_WORK
GL10101 Quick Journal Amounts Work GL_Business_Form_LINE_WORK
GL10110 Account Current Summary Master GL_Account_SUM_MSTR
GL10111 Account Summary History GL_Account_SUM_HIST
GL10300 General Ledger Tax Work glTaxWork
GL11000 GL Distribution Register Temporary GL_Distribution_Register_WORK
GL11110 Account Summary Master View GL_Account_SUM_MSTR_View
GL11111 Account Summary History View GL_Account_SUM_HIST_View
GL20000 Year-to-Date Transaction Open GL_YTD_TRX_OPEN
GL30000 Account Transaction History GL_Account_TRX_HIST
GL40000 General Ledger Setup GL_SETP
GL40100 Quick Journal Setup GL_Business_Form_SETP
GL40101 Quick Journal Account Setup GL_Business_Form_Account_SETP
GL40200 Segment Description Master GL_Segment_Description_SETP
GL40300 Posting Numbers Setup glPostingNumbersSetup
GL50010 General Ledger Period Header Temporary GL_Period_Balance_HDR_TEMP
GL50011 General Ledger Period Temporary GL_Period_Balance_TEMP
GL50101 Allocation Amounts Temporary GL_Allocation_Register_WORK
GL50102 Audit Trail Code Temporary GL_Audit_Trail_WORK
GL50400 Period Consolidation Activity GL_Period_Consolidation_Activity
GL70500 General Ledger Report Options GL_Options_ROPT
GL70501 General Ledger Report Options Temporary GL_Options_TEMP
IEBEGBAL ieBegBalCustomerVendorImport ieBegBalCustomerVendorImport
IEERRLOG ieTrxErrorLog ieTrxErrorLog
IEGLTRXI ieTrxGLImport ieTrxGLImport
IEPMTRXI ieTrxPMImport ieTrxPMImport
IERMTRXI ieTrxRMImport ieTrxRMImport
IESTATLG ieTrxStatusLog ieTrxStatusLog
LK000001 Trx Matching Setup LK_Linker_Setup
LK000002 Trx Matching Link Header LK_Link_HDR
LK000003 Trx Matching Link Line LK_Link_LINE
LK000004 Trx Matching Group Header LK_Link_Group_HDR
LK000005 Trx Matching Groups LK_Link_Groups
LK000101 Trx Matching Link Key Master LK_Link_Key_MSTR
LK000102 Trx Matching Link Header History LK_Link_HDR_HIST
LK000103 Trx Matching Link Line History LK_Link_LINE_HIST
LK4000 Trx Matching Report Options LK_Options_ROPT
LK40001 Trx Matching Report Option Names LK_Report_Names_ROPT
MC00200 Multicurrency Account Master MC_Currency_Account_MSTR
MC00201 Multicurrency Summary Master MC_Account_Summary_MSTR
MC00300 Multicurrency Account Historical Rates MC_Account_Rate_MSTR
MC10000 Multicurrency Revaluaton Work MC_Revaluation_HDR_WORK
MC10001 Multicurrency Revaluation Currency Work MC_Revaluation_LINE_WORK
MC30001 Multicurrency Account Summary History MC_Account_Summary_HIST
MC40000 Multicurrency Setup MC_SETP
MC40100 Multicurrency Rate Type Setup MC_Rate_Type_SETP
MC40201 Multicurrency Account Setup MC_Currency_Account_SETP
MC40301 Multicurrency Rate Type Account Setup MC_Exchange_Table_Account_SETP
MC40500 Multicurrency User Preferences MC_User_Preferences
MC50100 Multicurrency Period Balances Temporary MC_Period_Balance_TEMP
MC50200 Multicurrency Account Rate Temporary MC_Account_Rate_TEMP
MC60400 Euro Enable Setup mcEuroEnable
SE000100 Account Rollups Account Segment Summary SE_Account_Segment_SUM
SE000200 Account Rollups Account Segment Index SE_Account_Segment_Index
SE000300 Account Rollups Options Header SE_Options_HDR
SE000301 Account Rollups Options SE_Options
SE000401 Account Rollups Account Period Detail SE_Account_Detail_Period
SE00400 Account Rollups Account Detail SE_Account_Detail
SE465546 Account Rollups Calculated Column SE_Calculated_Column
SE810000 Account Rollups Account List SE_Account_List
SE90001 Account Rollups Account List Accelerator SE_Account_List_Accel
SE988977 Account Rollups Options Columns SE_Options_Columns
SY04100 Bank Master CM_Bank_MSTR

Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add

About Steve Gray

Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.