How do I define a look-up table?

To define a new look-up table: from the standard menu select Favourites | Functions | Standing Data | Scripts | Look-up Tables.

This will present you with a list of all the tables that you have already defined, if any. The First Dimension and Second Dimension columns define the axes of the table, the actual table entries are defined by the Qualifiers. To create a new table press the New button.

This will present you with a form that allows you to define the dimensions of the table. Each dimension is defined by the value of something within the system. For example, a material type, a resource name, a code, etc. You first define the type of the value. For dimension 1 you do this by pressing the Dimension 1 type ellipsis and selecting the type from the list, then you define the value by pressing the Dimension 1 value ellipsis and selecting the value you want. The process is the same for dimension 2.

If you wish to define a look-up table that only requires one dimension, then just set both dimension 1 and dimension 2 to the same type and value.

Press Save to make your selection permanent. You define the value(s) of the table entry as qualifiers in the usual way on the Items tab.

Note: You can also define look-up tables 'on-the-fly'. If you reference a table entry in your product configurator that does not exist, then you will be given the opportunity to define it as it comes across it.


Lets imagine you have an operation that involves wrapping something; and how long that operation takes is dependent on which machine you use and what type of wrapping material you use.

To set-up a table to do this, you would define dimension 1 as the machine, dimension 2 as the material (or the other way round) and an entry that defines how long it takes for that combination of machine and material. You would define similar entries for every combination of machine and material you wish to use.

You can either pre-set every combination, or you can do it 'on-the-fly'. If a product configurator references a combination that you haven't defined you will be given the opportunity to define as it is encountered.