This topic is contained in the PDXpert help file: select Contents from the application's Help menu.

SourceItemMasterView reference

The SourceItemMasterView is specifically intended for use in a CAD environment for part look-up, where the CAD tool may require dedicated custom parameters and/or display up to three approved part sources.

The SourceItemMasterView is derived from the ItemMasterView list of items, and includes custom attributes from the parent and child items. In addition, up to 3 sources are shown side-by-side with the parent item; each set of source columns are identified by the suffixes _1, _2, and _3. Sources are listed in the order defined by the Rank shown on the parent list. Sources sharing the same rank value do not have a specified column order.

Column definitions

There may exist in the view one or more "housekeeping" columns that have been reserved for PDXpert's private use. These columns' names begin with the prefix HK (for instance, HK1). Housekeeping columns may be redefined or eliminated in a future PDXpert release without notice. These will not be documented, and you should ignore these columns in your own SQL queries. Do not create any custom attributes that use the HK prefix. You may want to create a user-defined view that excludes the housekeeping columns.

The column ordering may not be exactly as shown in this table, and may change in a future PDXpert release. Use the column name, not ordinal position, in your SQL queries.

1174

Help topics describe the most current PDXpert PLM software release, and may differ from earlier releases.