Related topics
This table displays the existing user defined table keys. The table is preloaded when the system is installed.
Note: Only users with DC1 administrator authority may add or delete records in this table.
The keys are used as search criteria in the user defined tables that can be referenced in configurator formulas for calculations of material usage, times per operation and additional prices. User defined tables can also be used in cost model equations to define margin/mark-up of costs to set price of a configurable item.
Options
| Display | Select this option to view a record. |
| Translate/Display translations | Select this option to either update or view information from the Table translation file. Displayed fields can be translated to any of the languages registered in Work with languages. |
Selection fields
The selection fields on this panel can be used separately or in combination with each other. If several fields exist on your panel, then the first field is always a positioning field.
The following selection types exist in tables, enquiries and files:
- Positioning
Used to display the sequential list, starting with the character or value that you have entered.
If only one positioning field exists on your panel, then it can be used in two ways. If you enter part of the value/code, the field will function as a positioning field. If you enter a complete value/code, the field will function as a direct access to that record.
Note: 'Work with' programs never give you a direct access.
- Exact match
Used to narrow down the number of records in a list. Only records that are equal to the value you have entered will be displayed.
- Search
Used to find a specific record in a list. Enter a search argument consisting of one or several characters. All records that hold the search argument that you have entered will be displayed.
Note: This selection type is primarily used for description-related fields (free text fields combining upper and lower case letters).
- Key
- The code that identifies the key.
- Description
- The description of the key.
- Active
- Indicates if the key is active. Active keys can be used in user defined tables.