Adding Spool Parameters to the Status Table The first 21 column headers in the status table, from Ctrl No. to Complete Date, are defined by the program and cannot be changed. Most of these columns are updated with information from the drawing each time a drawing is saved. The columns to the right of Complete Date have user-defined headers as in the example below.
To edit the the user-defined headers, select Edit, Master Files, Fabrication Status.<cf>
You can have up to 60 user-defined column headers. If you choose to use any of the reserved headers listed in Table 1, those columns will be populated automatically and updated each time a drawing is saved.
For example, if you enter DIComplete as one of your custom headers, that column will automatically be populated with the number of diameter inches of weld on that spool for which a welderID has been entered. This value will be updated each time that spool is resaved. Reserved headers are not case-sensitive.
Table 1, List of Reserved Headers
Sample BBoxM and BBoxFT output:
Another way you can arrange for a column to populate automatically is to set up an extra drawing item whose title is the same as the header. For example, in the example shown, if you have an extra drawing entry called “Fab Location”, the corresponding entry will appear in that column.
Usually columns with headers like “Fab.Comp. Date” or “PT Comp. Date” are not set up to be updated via Extra Drawing Information. Usually these columns are either updated manually by typing directly into the table, or they are updated using data from a bar code reader.
This article focuses on taking data from the drawing and displaying it on the Status Table. To take data from the Status Table and display it on the drawing, see document K0032.
The reserved headers PRICE and INVOICE are different from the others in that they do not update the status table each time the drawing is saved. They are only updated when batch mode is used. For example, if you are invoicing for spools 36, 38 and 78, you first select File, Make New List and select only those three drawings.
Then select File, Batch Operation, check the two boxes as shown, and enter the desired invoice number, shown here as 678.
When the batch runs, the prices of spools 36, 38 and 78 will be written to the PRICE column in the status table and the invoice number to the INVOICE column. At the same time, the pricing details are placed on the clipboard and are available for pasting to Excel.