 |
The following explains, over which tables the geometric data are connected to the ERP data.
The two most important tables in the database model in the LINKDB are the LINKTABLE and the ERPTABLE.[13]
Under PARTlinkManager -> Extras -> Configure ERP environment -> PARTlinkManager preferences tabbed page -> Modify column display the columns of the Link table and the ERP table are listed. The Table columns shows the corresponding allocation.
The ERP table serves to save data from third party systems.
The table consists of three columns in its basic form. You can apply as many more columns as desired (potential maximum depends on license). These are then inserted in the ERP table.
The columns in the Link table contain information regarding to which project and which row the attribute and/or variant of the part corresponds.
The most important columns are:
Running number for user-specific variations of a characteristic within a Line ID
For example, a user can define different materials or special measurements outside of the standard, or vary value range fields.
Saves the version of the project.
(The current version is always shown in the PARTdataManager.)
Value range 0/1: If a geometry value of a NON-value range field is changed, the value is set from '0' to '1'. For more information, see:Section 1.7.1.3.2, “Internal treatment of variants”.
Saves all geometric information of a part; contains all geometric variables with values
The primary key of this table is a combination of the PSOL Project, Line ID, Line sub ID and Version. With these entries a part is specifically identified.