Transactional form dictionaries page

Admin |

Forms management tile > Elements > Form > Transactional Form Dictionaries

Purpose of the page

This page allows you to create a dictionary for transactional forms. Once a dictionary has been defined, it can be associated with a column of a transactional form (see Transactional form columns page).

Attributes tab

Element	Description
Code	Dictionary filter code.
Description	Description of the dictionary filter.
Dictionary type	Dictionary filter type selection: - Dictionary by Entity: allows you to define the dictionary filter element based on the entity. - Dictionary independent of Entity: allows you to define the same dictionary filter elements as valid for all entities. - Predefined dimension: the dictionary filter elements are those present in the elements table of an entity or account dimension, custom dimension or category specified in the Dimension field. - SQL Query: allows you to define the dictionary filter elements via an SQL query.
Elements	Only with Dictionary by Entity and Dictionary independent of Entity. Allows you to define the elements of the dictionary filter.
Size	Only with Predefined dimension. Allows you to select an entity, account, custom dimensions or category.
Elements selection query	Only with SQL Query. Allows you to insert an SQL query for the definition of the dictionary filter values. IMPORTANT: When creating the dictionary, the descriptions of some data retrieved by the SQL query may be declared as significant for GDPR purposes. Such descriptions are then encrypted and stored in the application database and must be decrypted when the form is opened in data entry and navigation, regardless of whether the dictionary filter is associated with a matrix field or whether it is a parameter of the form.
Attributes
Attribute 1 ... 5	(Optional) Allows you to insert up to five custom attributes which, in the data entry step, are shown next to the column with which the dictionary filter is associated.