By default, the BOM table contains the Number, Name and Quantity columns, Thumbnails, or the desired configuration, previously defined in a template .bom file stored in BOMTEMPLATE system variable.
Using the Configure option of the BMBOM command you can add more columns, such as Description, Density, Volume, Mass, Material, Thickness (for sheet metal parts), and Parameters (for parametric components).
You can add any built-in property of components, instances or block references to the BOM table. Custom evaluated columns are also supported, using the DataExtraction technology.
BOM tables list unique components only; multiple inserts of the same components are grouped, according to the Grouping mode.
- Auto (default mode)
Multiple inserts of the same components are grouped together with respect to their parameters and added properties. It means that multiple inserts of the same parametric component are always grouped in separate BOM rows with respect to their parameters, regardless if those parameters are added to BOM as columns.
- By components and columns
In this mode, multiple inserts of the same components are grouped together with respect to added properties only. It means that multiple inserts of the same parametric component could be grouped in the same row even if their parameters are different, depending on what columns are added to BOM. However, instances of different components are always grouped in different rows. This mode is useful, if some parameters correspond to different states of components but not result in being different parts.
- By columns only
In this mode, inserts of components are grouped with respect to their properties added to the BOM, regardless if they are inserts of the same component. This mode is useful to get a summary table, such as a list of all physical materials or a list of all sizes of pipes.
Visible and invisible columns
You can make any column in the BOM table invisible. Invisible columns do not appear in the table in the document. However, you can still use these columns in formulas. Invisible columns are also displayed in the BOM Manager.
- Sum: Sum the grouped values.
- Average: Find the average value of grouped values.
- Minimum: Find the minimal value of grouped values.
- Maximum: Find the maximal value of grouped values.
- Concatenate: Concatenate all unique values in the group in ascending order.
- Concatenate with counts: Concatenate all unique values with their number of counts in the group.
For example, take the following BOM table:
Apply an aggregate function to the Length column. The results are combined in the following table:
|Component||Width||Height||Length (sum)||Length (average)||Length (minimal)||Length (maximal)||Length (concatenate)||Length (concatenate with counts)|
|Beam||16||10||650||216.6667||200||250||200; 250||2x200; 250|
|Beam||20||20||870||217.5||215||225||215; 225||3x215; 225|
- Adjust the position of the number of counts (in front or behind the value).
- Add the delimiter between values.
- Add the delimiter between values and their number of counts.
- Define the postfix and/or prefix for the number of counts.
If an aggregated column is used in an evaluated column, the final values are used by default. However, it is possible to apply an aggregate function to an evaluated column. In this case, the results for such an evaluated column is first computed for all original values (before aggregation), and then the resulted values are aggregated.
Number column and column roles
A number column is a special column to enumerate rows. It assigns numbers automatically for all rows in the BOM table, without skips and independently of other tables. Rows are numbered starting from 1.
- Prefix: A string that is added in front of any number. For example, you want all numbers to start with "A".
- Suffix: A string that is added after the number. For example, you want to add "-1" to all numbers.
- Number type: Specifies the number format:
- Full: Numbers are formatted as "1.2.3".
- Short: Only numbers for the current level show. It is used together with the Level column, which shows the level of the current part in the assembly.
- Continuous: All components are numbered continuously starting from 1, regardless of their level.
- Delimiter: Specifies the symbol to separate numbers for different levels when the number type is set to Full.
- Number: The column contains numbers for annotations.
- Name: The column contains part names for annotations.
- Quantity: The column contains quantities of parts for annotations.
- Regular: The column has no special role.
Only one column can have a Number, Name or Quantity role. If no column has one of these roles assigned, automatic annotations are not possible.
By default, the width of each column is set automatically, so its content fits without additional line breaks. However, it is possible to set a fixed column width.
- Select the required column in the BOM manager, then type a value for the Width property in layout units.
- Change the width of the required column in the associated table. BOM tables automatically keep the width of columns that have been changed manually.
To restore the automatic width mode, select the column in the BOM manager and select Auto in the drop-down list for the Width property.
- Select the required column in the BOM manager.
- Choose the Format option in the context menu.
- Define the desired format in the Format dialog box.
Because BOM tables use DataExtraction technology, you can list properties of mechanical components and entity properties, for example, block references in BOM tables.
- Mechanical only(default property set): Only properties of mechanical components are listed.
- All except coordinates: Lists all properties of components, except coordinate ones. Coordinate properties are typically used only for component instances.
- All properties: Lists all possible properties of components and component instances.
You may change the property set for a BOM table in the BOM Manager or use BMBOM when you add a new table.