The columns to be displayed in the BOM on a drawing are defined on the BOM columns form.You can choose existing Isah fields as the columns, or you could use a script to fill columns with other data originating from Isah.
Note: If in the Field field you choose columns for a BOM definition of an engineering item, some fields will be duplicated in the list. This is true, for example, for the Length field. As the BOM of the engineering item can contain parts as well as engineering items, both part fields and engineering item fields are displayed in the list (the engineering item fields originate from the Engineering items form, and the part fields originate from the Engineering BOM field or the Parts form).
It does not matter which of the two corresponding fields you select: The field will be selected automatically based on whether the BOM line contains an engineering item or a part. You can also display the engineering item field and the part field in separate columns in the BOM on the drawing. You could, for example, display both the remark entered for the engineering item and the remark entered for the part. In that case, select both fields.
It is possible to include a line with additional information in the BOM on the drawing, to allow you to display more text in the BOM. Examples include a memo text with an assembly instruction, such as 'Fit gasket when dry'. To do so, select the Additional line check box. Only one field per BOM can be marked as an additional line.
The position in the list of columns determines the starting column for the additional line.
Examples
If the additional line is the first in the list, the line will appear at the top of the BOM over the full width.
Line number
Quantity
Description
Assembly instructions: Fit gasket when dry
10
5
Part A
20
10
Part B
30
5
Part C
If the additional line is the second in the list, the line will appear below all columns, starting from the second column.
Line number
Quantity
Description
10
5
Part A
20
10
Part B
Assembly instructions: Fit gasket when dry
Note: Additional lines can be specified only if there is a link with AutoCAD.
You can choose existing Isah fields as the columns, or you could use a script to fill columns with other data originating from Isah. To use an existing Isah field for the column, select 'Field'. To control the contents of a column using a custom script, select 'Script'.
If you selected 'Field' in the Field type field, select the field that is to supply the contents for the column in the BOM on the drawing. The fields you can choose from depend on the settings made on the BOM definitions form.
Heeft in het veld Veldtype gekozen voor 'Script', dan geeft u hier het script op dat de inhoud bepaalt van de kolom van de stuklijst op tekening. The script can be executed only if it contains the following input parameters: IsahTableId, IsahPrimKey, and BomLineNr. Parameters allow you to retrieve additional information. Het resultaat van het script is de waarde die in cel van de kolom van de stuklijst getoond wordt. Houd er rekening mee dat een script voor iedere regel uitgevoerd wordt en Isah trager kan maken.
Example
Om de dimensies in de tabel weer te geven, maakt u een script zoals hieronder die de lengte, breedte en hoogte van het artikel opvraagt. De notatie definieert u ook in het script. Heeft het artikel een lengte van 10,5 mm, breedte van 40,0 mm en een hoogte van 100,0 mm dan is het resultaat '10,5x40,0x100,0'. Die waarde wordt in de kolom bij de artikelregel in de stuklijst gezet.
function Dimensions(IsahTableId, IsahPrimKey, BomLineNr)
Dim lQueryStr
Dim lQuery
Dim lDimension
lDimension = ""
lQueryStr = "SELECT Length,Width,Height FROM T_BillOfMat WHERE PartCode = '"& IsahPrimKey & "' AND BomLineNr = " & BomLineNr
Set lQuery = Application.Database.CreateQuery ( lQueryStr )
If you selected 'Script' in the Field type field, enter the name of the function within the script that will determine the value of the column for the part line. If you leave this field blank, the function name 'Main' will be used.
Use the Vertical alignment field to set the text alignment in a cell relative to the top and bottom of the cell, for example 'Top' or 'Center'. Not all CAD applications support this option.
Change the order of the columns. Click the icons to move the columns. Clicking will move the column one position up in the list, and one position to the left in the BOM on the drawing. Clicking will move the column one position down in the list, and one position to the right in the BOM on the drawing. The icons are available only if the Edit mode is disabled.