A new table you create will be stored in the appropriate database, based on the table series you specified for the table in Dexterity. For series values such as Sales or Financial, your third-party table will be accessed in each company database set up in the accounting system. If you specify System as the series, your third-party table will be accessed in the DYNAMICS database.
If you want your tables to be accessed from some other location, you must add the tables to table groups. Then you can add records to the SY_Pathnames table (SY02100) to specify the locations for third-party tables. An alternative to adding records through code is to use the Pathnames window in Microsoft Dynamics GP to specify pathnames for third-party tables.
The Pathnames window is not directly accessible in Microsoft Dynamics GP. You must add it as a shortcut so that it can be accessed from the Navigation pane.
To support pathnames for third-party tables, you must define table groups using the Table Group Definition window in Dexterity. Once you’ve defined table groups, set the location of tables using the Pathnames window. Refer to Table Groups for information about creating table groups.
Depending upon how you want to organize your application’s table groups, use the following guidelines:
You cannot add a third-party table to an existing Microsoft Dynamics GP table group, nor can you add a Microsoft Dynamics GP table to a third-party group.
To change the location of your application’s data, use the Pathnames window. This window writes pathname records to the SY_Pathnames table (SY02100). When the SQLPath procedure in the accounting system runs, it checks the SY_Pathnames table for a pathname based upon the company ID, product ID and series for the table group being accessed. It then performs the table operation using that path.