Bonus Columns
Bonus columns are custom fields you add to a type of record, such as parts, customers, quotes or vendors. Use Bonus Columns to add one, change its title or default, or drop it.Updated Nov 9 2026
Before you start
- Bonus Columns is under Admin > Maintenance and needs the Can Edit Maintenance permission (the Maintenance role by default). Without it, Cetec sends you to the home page with "Admin users only!".
- Plan the field first: a title users will see, a technical name with no digits in it, and the data type. A field's data type can't be changed after it is added.
-
Choose the record type
- Go to Admin > Maintenance > Bonus Columns. The page is headed Add Bonus Columns.
- Find the record type in the Type column. Has Bonus Columns shows how many active bonus columns that type already has.
- Click the type (for example Part). The Bonus Columns For type page opens.
-
Add a bonus column
- On Admin > Maintenance > Bonus Columns, click the record type. The Bonus Columns For type page opens; its first table row is for the new column.
- In that row, type the Title(displayed to user) and the Technical Name (the unique name
used behind the scenes; no numbers, so write "twenty", not "20"). If you leave Technical
Name empty, Cetec builds it from the title. Cetec adds
_bcto the end, socoloris saved ascolor_bc. - Pick the Data Type: Text, Up To 50 Chars, Text, Up To 100 Chars, Check Box (Check For 'Yes'), Select Box, Multi-Select Box, Date, Radio Buttons (Check 'Yes' or 'No') or Textarea (large text input).
- Optionally type a Default Value (the box says (required, displayed to users), but it can be left empty). It fills every existing record when the column is added; changing it later only affects new records.
- Click Add New. Cetec shows "bonus columns created" and lists the column below.
-
Change or drop a bonus column
- On Admin > Maintenance > Bonus Columns, click the record type.
- In the column's row, change the Sort Order, Title(displayed to user), Searchable? or Default Value. For a Select Box or Multi-Select Box column, type the choices in Select Options (comma separated) under the row, and tick Unset Option ? to offer an empty choice.
- To remove a column, tick Drop ? on its row.
- Click Update at the bottom of the table. Cetec shows "bonus columns updated".