This topic is contained in the PDXpert help file: select Contents from the application's Help menu.
StructurePairView & StructurePairMasterView reference
The StructurePairView and StructurePairMasterView are parent-child lists of all home and partner items. The view is a side-by-side set of the parent item attributes; a single child item's attributes; and the parent-child relation attributes such as find-item, quantity and unit of measure. The parent (for example, an assembly) may have zero, one, or many structure child (component) records.
A parent structure may also simply be a single purchased or designed part with a document as a reference on its structure list.
The StructurePairView is derived from the ItemView list of items, and excludes custom attributes from the parent and child items. The StructurePairMasterView is derived from the ItemMasterView list of items, and includes custom attributes.
The basic SQL statement is SELECT * FROM StructureItemView
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.
StructurePairView
| Column name | Data type | Record attribute (note 1) |
|---|---|---|
| ItemId ... Notes | refer to the ItemView reference | parent item standard attributes |
| ItemId_Child ... Notes_Child | refer to the ItemView reference | child item standard attributes |
| Find | integer | structure row Find |
| Per | integer (note 2) | structure row Per |
| Quantity | real number | structure row Quantity |
| Unit | Unit of Measure Name | structure row Unit |
| RefDes | string | structure row RefDes |
| RowNotes | string | structure row Notes |
StructurePairMasterView
| Column name | Data type | Record attribute (note 1) |
|---|---|---|
| ItemId ... custom_Member | refer to the ItemMasterView column reference | parent item standard and custom attributes |
| ItemId_Child ... custom_Member_Child | refer to the ItemMasterView column reference | child item standard and custom attributes |
| Find | integer | structure row Find |
| Per | integer (note 2) | structure row Per |
| Quantity | real number | structure row Quantity |
| Unit | Unit of Measure Name | structure row Unit |
| RefDes | string | structure row RefDes |
| RowNotes | string | structure row Notes |
Notes:
- Part attributes are undefined for document rows (that is, where child record's Class is 2).
- Permitted values are: 0=Per Assembly; 1=Per Setup or 2=As Needed
1176
Help topics describe the most current PDXpert PLM software release, and may differ from earlier releases.
