Name:

The same name must be entered here that was used when setting up the ODBC interface under PARTadmin -> Category ERP environment -> Database connection -> Active database connection (see following figure).

Active database connection

Link table

ERP table

Join statement [Join statement] (link table)

Join statement defines which primary key is assigned to which foreign key in the LINKTABLE and ERPTABLE tables. In this case "erp_pdm_number".

Project table

PRJTABLE is used for the Edit project table function (see Section 4.24.8.2.7, “ Edit project table ”).

Structure table

The TREETABLE is required to display the red-green status in the directory tree. As of V9, this is necessary due to the new index structure (especially for links).