Site Search:
Sign in | Join | Help

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
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