Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
NaomiP 4/23/2007 3:09:00 PM

Dynamics GP Receivables Management (RM) tables

This table contains all the table names, technical names, and user-friendly names for the tables in the Receivables Management module for Dynamics GP


IVC10100 Invoicing Transaction Work IVC_HDR_WORK
IVC10101 Invoicing Transaction Amounts Work IVC_LINE_WORK
IVC10102 Invoicing Serial and Lot Number Work IVC_Serial_Lot_WORK
IVC10103 Invoicing Line Comments IVC_LINE_Comment
IVC10200 Invoicing Payments Work IVC_Payment_WORK
IVC10300 Invoicing Distributions IVC_Distribution
IVC10400 Invoicing Commissions IVC_Commission
IVC10500 Invoicing Taxes IVC_Taxes
IVC30100 Invoicing Batch History IVC_Batch_HIST
IVC30101 Invoicing Transaction History IVC_HDR_HIST
IVC30102 Invoicing Transaction Amounts History IVC_LINE_HIST
IVC40100 Invoicing Setup IVC_SETP
IVC40101 Invoicing Document Setup IVC_Document_SETP
MC020102 Multicurrency Receivables Transactions MC_RM_Transactions
MC020102 Multicurrency Receivables Transactions Debit MC_RM_TransactionsDebitCopy
MC020104 Multicurrency RM Revaluation Activity MC_RM_Revaluation
MC10101 MC RM Distribution Temp File MC_RM_Apply_Dist_TEMP
PA00001 Customer Vendor Master paCustomerVendorMSTR
PA00002 Customer Checks Setup paCustomerCheckSETP
PA00010 Bank Account Master paBankAccount
PA50100 Customer Checks Work paCustomerChecksWORK
PA50102 Customer RM Applied Work paCustomerRMAppliedWork
PA50103 Vendor PM Applied Work paCustomerPMAppliedWork
PA50105 RMPMOpen paRMPMOpen
PT00101 Project Costing Master ptProjectMstr
PT10000 Project Distributions ptProjectDistributions
PT40100 Project Costing Setup ptSetup
RM00101 RM Customer MSTR RM_Customer_MSTR
RM00102 Customer Master Address File RM_Customer_MSTR_ADDR
RM00103 Customer Master Summary RM_Customer_MSTR_SUM
RM00104 Customer Period Summary RM_Customer_MSTR_Period_SUM
RM00105 RM National Accounts Master RM_NationalAccounts_MSTR
RM00106 RM Statements E-mail Addresses rmStmtEmailAddrs
RM00201 RM_Class_MSTR RM_Class_MSTR
RM00301 RM Salesperson Master RM_Salesperson_MSTR
RM00302 Salesperson Master Summary File RM_Salesperson_MSTR_SUM
RM00303 Sales Territory Master File RM_Sales_Territory_MSTR
RM00305 Sales Territory Master Summary RM_Sales_Territory_MSTR_SUM
RM00401 RM Key File RM_Keys_MSTR
RM00500 Extended Pricing Price Sheet Links rmExtPricingSheetLinks
RM00700 RM Report Options RM_Options_ROPT
RM10101 RM Distribution Work File RM_Distribution_WORK
RM10201 RM Cash Receipts Work File RM_Cash_WORK
RM10301 RM Sales Work File RM_Sales_WORK
RM10501 RM Commission Work File RM_Commission_WORK
RM10504 RM Unpaid Removed Commissions RM_Unpaid_Removed_Commissions
RM10601 RM Tax Work File RM_Tax_WORK
RM10901 RM Aging Reconcile Control RM_Aging_Reconcile_Control
RM20101 RM Open File RM_OPEN
RM20101 RM Open File Debit Copy RM_OPENDebitCopy
RM20102 RM Realtime Posting File RM_Realtime_OPEN_WORK
RM20201 RM Apply Open File RM_Applied_OPEN
RM20400 RM Scheduled Payment Header RM_SCH_HDR
RM20401 RM Scheduled Payment Line RM_SCH_LINE
RM30101 RM History File RM_HISTORY
RM30201 RM Apply History File RM_Applied_History
RM30202 RM Apply Reprint Journal File RM_Applied_Journal_Reprint
RM30301 Receivables GL Distribution History RM_Distribution_History
RM30401 RM Scheduled Payment Header History RM_SCH_HDR_HIST
RM30501 Commission History RM_Commission_History
RM30502 RM Batch History RM_Batch_History
RM30601 RM Tax History File RM_Tax_History
RM30701 RM Reprint Statements Header File rmReprintStmtsHDR
RM30702 RM Reprint Statements Transactions File rmReprintStmtsTRX
RM40101 RM Module Setup File RM_Module_SETP
RM40102 RM Reprint Statements Identifier File rmReprintStmtsIdentifier
RM40201 RM Period Setup RM_Period_SETP
RM40401 Document Type Setup File RM_Document_SETP
RM40501 RM Statements Options File RM_Statements_ROPT
RM40601 RM Statement Messages Setup File RM_Statement_Messages_SETP
RM50100 RM History Removal Tempoary File rmHistRemovalTemp
RM50101 Statements Emailed Header Temp rmStmtsEmailedHdrTemp
RM50102 Statements Emailed RecipientsTemp rmStmtsEmailedRecipientsTemp
RM50103 RM Email Statements Header Temporary File rmEmailStmtsHDR
RM50104 RM Email Statements Transactions Temporary F rmEmailStmtsTRX
RMV0100 RM Scheduled Payment Header View RM_SCH_HDR_VIEW
SOP00100 Sales Process Holds Master SOP_Process_Holds_MSTR
SOP00200 Sales Prospect Master SOP_Prospect_MSTR
SOP00300 Sales Customer Item Substitute sopCustomerItemSubstitute
SOP10100 Sales Transaction Work SOP_HDR_WORK
SOP10101 Sales Commissions Work and History SOP_Commission_WORK_HIST
SOP10102 Sales Distribution Work and History SOP_Distribution_WORK_HIST
SOP10103 Sales Payment Work and History SOP_Payment_WORK_HIST
SOP10104 Sales Process Holds Work and History SOP_Process_Holds_WORK_HIST
SOP10105 Sales Taxes Work and History SOP_Tax_WORK_HIST
SOP10106 Sales User-Defined Work History sopUsrDefWorkHist
SOP10107 Sales Tracking Numbers Work History sopTrackingNumbersWorkHist
SOP10108 Extended Pricing Price Group Header sopExtPricingGroupHeader
SOP10109 Extended Pricing Price Book Header sopExtPricingPriceBookHeader
SOP10110 Extended Pricing Price Sheet Header sopExtPricingPriceSheetHeader
SOP10111 Sales Picking Instruction Master sopPickingInstructionMstr
SOP10112 Sales Workflow Work and History sopWorkflowWorkHist
SOP10200 Sales Transaction Amounts Work SOP_LINE_WORK
SOP10201 Sales Serial/Lot Work and History SOP_Serial_Lot_WORK_HIST
SOP10202 Sales Line Comment Work and History SOP_LINE_CMT_WORK_HIST
SOP10203 Sales Order Bin Quantities Work and History sopBinWorkHist
SOP10204 Extended Pricing Promotion Work sopExtPricingPromoWork
SOP10205 Extended Pricing Price Book Work sopExtPricingPriceBookWork
SOP10206 Sales Bulk Print Header sopBulkPrintHdr
SOP10207 Sales Bulk Print Line sopBulkPrintLine
SOP30100 Sales Batch History SOP_Batch_HIST
SOP30200 Sales Transaction History SOP_HDR_HIST
SOP30201 Sales Deposit History SOP_Deposit_HIST
SOP30300 Sales Transaction Amounts History SOP_LINE_HIST
SOP40100 Sales Setup SOP_SETP
SOP40101 Sales Workflow Setup sopWorkflowSetup
SOP40200 Sales Type ID Setup SOP_ID_SETP
SOP40201 Sales Default Process Holds Setup SOP_Default_Holds_SETP
SOP40300 Sales Document Setup SOP_Document_SETP
SOP40400 Sales User Defined Table Setup SOP_User_Defined_SETP
SOP40500 Sales Master Number Setup SOP_Master_Number_SETP
SOP40600 Sales Non-IV Item Currency Setup sopNonIVItemCurr
SOP40700 Extended Pricing Customer Price Report sopExtPricingCustPriceReport
SOP40701 Extended Pricing Price List Report sopExtPricingPLPriceReport
SOP40702 Extended Pricing Base Prices sopExtPricingBasePrices
SOP40703 Extended Pricing Quantity Breaks sopExtPricingQuantityBreaks
SOP40704 Extended Pricing Quantity Breaks For Price S sopExtPricingQuantityBreaksForPriceS
SOP40705 Extended Pricing Generate Dates sopExtPricingGenDates
SOP40706 Extended Pricing Price Book Prices sopExtPricingPriceBookPrices
SOP40708 Extended Pricing Base Currencies sopExtPricingBaseCurr
SOP40709 Extended Pricing Group Currencies sopExtPricingGroupCurr
SOP50100 Sales Process Documents Temp SOP_Process_TEMP
SOP50200 Sales Document Header Temp SOP_Document_HDR_TEMP
SOP50300 Sales Document Line Temp sopDocumentLineTemp
SOP50400 Extended Pricing Promotion Inquiry Temp sopExtPricingPromoInquiryTemp
SOP50401 Extended Pricing Promotion Report Temp sopExtPricingPromoReportTemp
SOP60200 Sales Picking Instruction Cross Reference sopPickingInstructionXref
SOP60300 Sales Customer Item Cross Reference sopCustomerItemXref
SOP70100 Sales Inquiry Restrictions SOP_Restrictions_MSTR
VAT10100 RM Class Intrastat MSTR RM_Class_Intrastat_MSTR
VAT10101 RM Customer Intrastat MSTR RM_Customer_Intrastat_MSTR
paActvty Lock Box Activity Tracking Master paActivityTrackingMSTR
palbCash Lockbox Cash Work paRMCashWORK
palbInvc Lockbox Invoice Work paRMInvoiceWORK
palbdtl Lockbox Setup Details paLockboxDetails
palbmstr Lockbox Master paLockboxMSTR
palbrdty Lockbox Record Types paLockboxRecordTypes
palbsetp Lockbox Setup palbSetup
Version: GP 10
Section: Dynamics GP
This thread has been marked as 'Closed' and archived

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables