A million thanks to Mark Polino for putting up an amazing presentation on understanding Table Structure in GP. Please visit Mark's blog post which contains a link to the powerpoint. A must see for anybody who writes reports for GP.
Here are the gems from his powerpoint about table naming logic in-
1. ‘00000’ - Master tables contain all the permanent data about your business. Accounts, vendors, customers, items, and so on.
2. ‘10000’ - Work tables contain unposted batches of transactions entered using windows that can be opened using the Transactions button on the toolbar. Temporary transactions that can be changed or deleted until they are posted to an open table.
3. ‘20000’ - Open tables contain posted transactions for the current year, of which some may be unpaid. Information in open tables is moved to history tables when the transactions are paid.
4. ‘30000’ - History tables contain paid transactions, or transactions from a previous year.
5. ‘40000’ and up - Setup tables contain all the default settings and module options you’ve specified in the setup windows for each series.
In addition to that, I think the tables in 50000 series are the temp tables.
Based on this Logic - Review some of the Receivables Management(RM) Tables in GP
RM00101 RM Customer Mater
RM00102 Customer Master Address File
RM10101 RM Distribution Work File
RM10201 RM Cash Receipts Work File
RM20101 RM Open File
RM20101 RM Open File Debit Copy
RM30101 RM History File
RM30201 RM Apply History File
RM40101 RM Module Setup File
RM40201 RM Period Setup
Now review the Payables Management(PM) Table
PM00100 PM Class Master File
PM00200 PM Vendor Master File
PM10000 PM Transaction WORK File
PM10100 PM Distribution WORK OPEN
PM20000 PM Transaction OPEN File
PM20100 PM Apply To OPEN OPEN Temporary File
PM30200 PM Paid Transaction History File
PM30300 PM Apply To History File
PM40100 PM Setup File
PM40101 PM Period Setup File
and the General Ledger(GL) Tables
GL00100 Account Master
GL00100 Distribution Account Master
GL10000 Transaction Work
GL10001 Transaction Amounts Work
GL20000 Year-to-Date Transaction Open
GL30000 Account Transaction History
GL40000 General Ledger Setup
GL40100 Quick Journal Setup
GL50010 General Ledger Period Header Temporary
GL50011 General Ledger Period Temporary