ProSteel Partlist Database Details

The reporting tool reads ProSteel object information from an Access database rather than directly from the design file. Supporting Item Types in a ProSteel report extended the ProSteel database structure.

A field is added to a partlist table for every Item Type that is attached to an object in the table (as marked in red in the above image).

The field name is based on the Item Type name. It is prefixed with "ItemType" to differentiate it from other fields.
The field value is a unique identifier for the first object that was found with the attached Item.

A table is added to the database for each ItemType field that was added to the Partlist table. Each record in the table is a unique Item (set of property values).

The table name matches the Partlist field name.
The first field-named ItemTypeKey-is used to join the Item (set of property values) to one or more objects in the Partlist table.
The remaining fields are named for the Item Type properties. The field values are the individual property values as strings. The fields can hold up to 255 characters.

The List & Label field names are based on the Access table and field names. The Access naming restrictions cause the special character substitutions and truncations described in the Name Details section.