User defined columns
You can add columns to your tables in order to define additional custom information.
Do not use "ID" or "Key" as your column names. These are reserved words that will cause issues when using the table column.

- Open the Input Table to which you want to add columns.
- Click Add Column.
- Enter the Name. Do not use "ID" or "Key" as your column names. These are reserved words that will cause issues when using the table column. The Name must be unique within the table.
- Select the Data Type for the column – one of Text, Integer, Decimal, Date. Text columns are limited to 300 characters.
- If you are creating a Text column, select the Usage. The Usage determines what values will be displayed by default for the column. For example, if you select Usage = “Products”, the column will display Products, Product filters and Product groups in the drop down for the column. Select “None” if the column does not reference existing data columns. Usage can be one of:
- None – This usage is for columns that are not based on existing data in the model.
- Sites
- Customers
- Location – This returns both Sites and Customers.
- Products
- Modes
- Periods
- Bill Of Materials
- Inventory Processes
- Inventory Process Steps
- Production Processes
- Production Process Steps
- Returns Processes
- Returns Process Steps
- Sourcing Processes
- Sourcing Process Steps
- Transportation Processes
- Transportation Process Steps
- Transportation Assets
- Drone Type
- Work Centers
- Work Resources
- Space
- Expressions – This returns any Expression Names defined in the model.
- Status - This usage supports the Include/Exclude mechanism for controlling which records are used when the model is run.
- Click OK.
The column is added at the right end of the table. It is displayed with a user icon to indicate that it is a user defined column.

- Click the column features icon
on the column you want to delete.
- Select Delete Column. You are asked to confirm the deletion.
- Click Yes to confirm the deletion.
Last modified: Thursday February 27, 2025