BOM Comparison Tool Master Column

The central top portion of the tool window contains the master column section. From this section, you can select the desired master column option.

The master column is the column in the BOM file whose attributes are considered as a key in comparison and validation operations. Only columns with three attributes can be used as master columns, such as columns containing part ID, part name and part number. The master column data is used as a key for the following operations:

•	Update model attributes as in BOM

•	Complete BOM by querying model

•	Check model against BOM

Three master column combinations between the BOM and the model are allowed. The tool queries the data in the model based on any one of these column combinations:

•	Compare Part Id in BOM with Part Id in model: the tool compares the attributes of a part in the BOM with the part in the model using part id as the key.

•	Compare by Part Name in BOM with Part Name in model: the tool compares attributes of a part in the BOM with the part in the model using part name as the key.

•	Compare by Part Number in BOM with Part Name in model: the tool compares attributes of a part in the BOM with the part in the model using part number as the key.