StructurePairView & StructurePairMasterView reference

The StructurePairView and StructurePairMasterView are parent-child lists of all BOM 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 (row) number, quantity and unit of measure. The parent (typically an assembly) may have zero, one, or many child (component) records.

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 the parent and child items' custom attributes.

When a parent part has a pending iteration (that is, the PendingRevID is not null), then it displays the markup Find numbers, items, RefDes, and notes. When a parent has only a released iteration (the PendingRevID is null, RevID is not null, and IsCanceled is false), then it displays the current released child iteration (Revision_Child, Lifecycle_Child, etc.) with Find, RefDes and notes. If a child part has a pending iteration, that's shown in separate columns (PendingRevision_Child, PendingLifecycle_Child, etc.) but is not yet assigned to the parent's current configuration. A query that requires the current released parent must test that the PendingRevID is null and IsCanceled is false.

The basic SQL statement is SELECT * FROM StructurePairView

In earlier PDXpert releases, the structure views contained reference documents. These are now contained in separate ReferencePair views.

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 are not 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
ItemId ... Notes see: ItemView columns parent item standard attributes
ItemId_Child ... Notes_Child see: ItemView columns child item standard attributes
Find integer row Find number
Per integer (note 1) row Per
Quantity real number row Quantity
Unit Unit of Measure Name row Unit
RefDes string row RefDes
RowNotes string row Notes

Notes:

  1. BOM quantity category values are: 0=Per Assembly; 1=Per Setup; 2=As Needed

StructurePairMasterView §

Column name Data type Record attribute
ItemId ...  custom_Member see: ItemMasterView columns parent item standard and custom attributes
ItemId_Child ... custom_Member_Child see: ItemMasterView columns child item standard and custom attributes
Find integer row Find number
Per integer (note 1) row Per
Quantity real number row Quantity
Unit Unit of Measure Name row Unit
RefDes string row RefDes
RowNotes string row Notes

Notes:

  1. BOM quantity category values are: 0=Per Assembly; 1=Per Setup; 2=As Needed

1176