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

  • RM00103 field definitions

    Here are field definitions for the RM00103 table

     

    Name

    Physical Name Type Storage
    GPS_Reserved GPS_RESERVED Long Integer 4
    Total Amount Of NSF Checks Life TNSFCLIF Currency 10
    Number Of NSF Checks Life NONSFLIF Long Integer 4
    Customer Number CUSTNMBR String 16
    Customer Balance CUSTBLNC Currency 10
    Aging Period Amounts AGPERAMT Currency 70
    Last Aged LASTAGED Date 4
    First Invoice Date FRSTINDT Date 4
    Last NSF Check Date LSTNSFCD Date 4
    Last Payment Amount LPYMTAMT Currency 10
    Last Payment Date LASTPYDT Date 4
    Last Transaction Date LSTTRXDT Date 4
    Last Transaction Amount LSTTRXAM Currency 10
    Last Finance Charge Amount LSTFCHAM Currency 10
    Unpaid Finance Charges YTD UPFCHYTD Currency 10
    Average Days to Pay - LYR AVDTPLYR Integer 2
    Average Days To Pay - Life AVDTPLIF Integer 2
    Average Days To Pay - Year AVGDTPYR Integer 2
    Number ADTP Documents - Life NUMADTPL Long Integer 4
    Number ADTP Documents - Year NUMADTPY Long Integer 4
    Number ADTP Documents - LYR NUMADTPR Long Integer 4
    Total Discounts Taken YTD TDTKNYTD Currency 10
    Total Discounts Taken LYR TDTKNLYR Currency 10
    Total Discounts Taken LTD TDTKNLTD Currency 10
    Total Discounts Available YTD TDISAYTD Currency 10
    Retainage RETAINAG Currency 10
    Total Amount Of NSF Checks YTD TNSFCYTD Currency 10
    Number Of NSF Checks YTD NONSFYTD Long Integer 4
    Unposted Sales Amount UNPSTDSA Currency 10
    Unposted Cash Amount UNPSTDCA Currency 10
    Unposted Other Sales Amount UNPSTOSA Currency 10
    Unposted Other Cash Amount UNPSTOCA Currency 10
    Non Current Scheduled Payments NCSCHPMT Currency 10
    Total Sales YTD TTLSLYTD Currency 10
    Total Sales LTD TTLSLLTD Currency 10
    Total Sales LYR TTLSLLYR Currency 10
    Total Costs YTD TCOSTYTD