To create a report, you need to decide which tables data will come from. If all the data for your report is stored in a single table, you can select the table as the main table for the report and begin creating your report.
If a single table doesn’t contain all the data you need for your report, you must choose one table as the primary table, and then link additional tables to it. You can select either the table that contains the majority of the fields for your report or the table that contains the most general information as your main table. Once you’ve selected a main table, link other tables to that table as needed.
A table group is a group of logically-related tables. For example, a customer master table, a customer address table, and a customer history table all compose a table group. Every table in Microsoft Dynamics GP is part of a table group. Often, the data for a report will come from the tables in a table group.
The table types described in Table types – setup, master, work, open and history – are actually table groups. These table groups are actually composed of information stored in several separate tables. For example, the General Ledger Transaction Work Table is a table group, made up of the following tables:
Technical table names are shown above in parentheses. General information about each transaction, such as the audit trail code and date, are stored in the Transaction Work (GL_TRX_HDR_WORK) table, and transaction amounts are stored in the Transaction Amounts Work (GL_TRX_LINE_WORK) or Transaction Clearing Amounts Work (GL_TRX_Clearing_WORK) table, depending upon whether you’ve entered a standard transaction or a clearing transaction.
In some cases, a table group will contain only one table. For many system tables, the table group is made up of a single table with the same name as the table group.
You can use the Software Development Kit (SDK) to find additional information about tables in Microsoft Dynamics GP.