Related topics
In this table you define the validation table types that are valid for the item attribute search functionality. In addition, you define the values (for validation types of Short alphanumeric and Long alphanumeric table types) that will be valid for entry/selection for the fields that are defined in Item attribute templates. This controls the entry of values in those types of fields defined in Item attribute templates. Per Template field of those types (in Work with item attribute templates), you assign the code from this table that is to be valid. When you connect an Item attribute template to an item in the Item file, (and the end-user ultimately uses Attribute search mode to look up items), only the values held in this table for the connected Validation table code will be valid for entry/selection.
For Numeric and Date related validation types, you control the data entry of values via the Value range fields in the Item attribute template.
For File related validation types, you are able to connect a phyiscal file and the field for which you want to perform an attribute search, thereby being able to search for the values connected to that file/field. An example of this is the Signature file for the Signature field. The signature entered as a search attribute in Attribute search must exist in the file/field. Per Template field (in Work with item attribute templates), you assign the code from this table that is to be valid.
For Program related validation types, there may be data that you want to be able to perform a search on that does not exist in one specific file. Instead, you need to validate the data from several files. For this type of validation, you need to write a program that selects items holding a specific attribute.
Options
Values | Select this option to work with the values that will be valid for entry/selection for Short alphanumeric and Long alphanumeric related fields that are defined in the Item attribute templates. |
Selection fields
- Table
- This column lists the existing table codes.
- Type
- This column displays the panel value for the validation table type denoting what type of data is allowed.
Type Description B Short alphanumeric E Date G File M Long alphanumeric O Numeric Q Program
- Number of decimals
- This column is only applicable for a validation table of type “Numeric”. Displays the number of decimals that will be used for validation for a validation table of type “Numeric”.
- File
- This column is only applicable for a validation table of type “File”. Displays the file that will be used for validation for a validation table of type “File”.
- Comparison field
- This column is only applicable for a validation table of type “File”. Displays the comparison field from the file that will be used for validation for a validation table of type “File”.
- Program
- This column is only applicable for a validation table of type “Program”. Displays the program that will be used for validation for a validation table of type “Program”.
Work with item attr validation tables (DIR05504)
On this panel you define the validation table types that are valid for the Item attribute search functionality.
Function keys
- Table
- Enter a unique code to identify the table.
- Type
- Enter the panel value for the validation table type denoting what type of data is allowed.
Type Description B Short alphanumeric E Date G File M Long alphanumeric O Numeric Q Program
- Number of decimals
- This field is only applicable for a validation table of type “Numeric”. Enter the number of decimals that will be used for validation for a validation table of type “Numeric”.
- File
- This field is only applicable for a validation table of type “File”. Enter the file that will be used for validation for a validation table of type “File”.
- Comparison field
- This field is only applicable for a validation table of type “File”. Enter the comparison field from the file that will be used for validation for a validation table of type “File”.
- Program
- This field is only applicable for a validation table of type “Program”. Enter the program that will be used for validation for a validation table of type “Program”.
Work with item attr validation tables, Copy (DIR05505)
- Table
- Displays the table code(s) you selected to copy.
- New table
- Enter the new table code(s) that you are creating.