BOM integration
TOP allows the generation of bills of materials (BOMs) based on part usage.
The application already includes several standard BOMs that cover the most common cases. Refer to the TOP manual for more information on BOM management.
TOP Layout allows the integration of additional BOMs beyond the ones provided with TOP.
The BOM integration is done via an Excel sheet.
The Excel sheet provided with the application contains a DISTINTE (BOM) sheet, which looks like the following:
The fields used are:
- ID
Must be a numerical value and unique for each row. - DISTINTA
The name of the BOM for which the row-attribute is defined. - DESCRIZIONE
Description of the BOM. This is the text that appears in the TOP BOM dialog. - ATTRIBUTO
The name of the attribute to be included in the BOM. If an attribute needs to be included in multiple BOMs, duplicate the rows. - NUMERO
Indicates if the attribute is numeric. Use "Y" for yes. If the cell is empty, the attribute is considered non-numeric. - FUNZIONE
Indicates the function to be passed for the attribute. - DEFAULT
Indicates the default value for the attribute. If not filled, the attribute takes this value. - ORDINAMENTO
Defines the sorting index for the attributes in the BOM. - RAGGRUPPAMENTO
Defines the grouping index for the attribute. - SOMMA
Indicates if the attribute should be summed in the BOM. - QMARK
Considers records with an empty attribute as equal for grouping purposes. - TABBLOCK
Specifies the path of the block to be used in AutoCAD for insertion into the drawing.