User Manual 2.2/Reference

Reference tab

Definitions

References define data types. This is for the purpose of inputs, processing, outputs, or storage by the application regarding fields and their parameters. In the configuration of a column, it specifies the data type that it contains. Reference examples include the following: string, date, integer, list, and search.

Search validation: In some cases the user can use a pop-up window to fill in a selected field. The pop-up facilitates the selection from the list with a possibility of using different filters. These fields are created with the search type reference.

Tabs

• Reference: Defines specific fields and their parameters. References can be by type, data type, validation by list, validation by table, or validation by selector.

• List validation: Defines the possible values for a list type reference. This type of reference is used only when there is a unique set of possibilities that are not significantly different from one another. A good example of such a list are days of the week. This list can only be modified by the system administrator.

• Table validation: Allows the user to choose a table and a column that are related to the table type reference. This reference is used when a selected column does not meet the rule "table name"+_ID. In this case the TableDir reference cannot be used and it is essential to create a table type reference indicating the Table and Column that the user wants to make a reference to. For example, the user can find in M_LocatorTo_ID column in M_MovementLine table. To be TableDir it is M_Locator_ID with a table type reference locator.

• Search validation: The user defines a table and a column referenced.

• Search validations columns: The user defines other columns that the selector needs. The pop-up windows are created manually.

Process Information

In the configuration of a column, the user can specify the data type and a field type that appear in the window. As means to do that the user selects a data type reference. If he/she selects table, list or selector reference, they are required to also choose a corresponding validation type reference.