Data models

• Template code (field MODELE)

Code identifying the current record.

• Title (field ZINTIT)

• Active (field ENAFLG)

This check box is used to activate or deactivate the current record without losing its content.

A deactivated record cannot be used (by calling its code) in other records (documents, setups, etc.) or during mass processings.

The authorizations for a given function can prohibit the creation of an active record. In this case, the box is cleared by default and it can only be modified by an authorized user or via a signature circuit defined by Workflow.

• Activity code (field CODACT)

An activity code is used to:

• make optional an element in the dictionary if the value associated with the activity code is null.
• identify the specific/custom elements if they are marked with a code starting with X, Y or Z.
• size a maximum number of lines when the activity code marks elements from a grid.

In this way, if the activity code is disabled, the marked element will not be useable, and the associated code (if any) will neither be generated nor can be activated.

• Module (field MODULE)

Module belonging to the setup. This field is used to specify whether the screen has to be created in the folder database. It is specified when the module linked to the screen is active in the folder.

• Template w. index (field FLGEXA)

• Setup templates (field FLGAPH)

• Workflow (field FLGWRK)

• Deliverable definition (field FLGADLV)

• Main table (field TABREF)

It identifies the main table from which other tables are read via direct links or through cascade. This table is supposed to be on line if the model is used in a Workflow rule of the Manual type. In the case of a Manual Workflow, it belongs to the join that is open and run through upon Workflow execution.

• Linked table (field TABLNK)

It identifies the table linked to the table of origin.

• Abbrev. (field ABRLNK)

It corresponds to the abbreviation under which the linked table is open.

If this field is not populated, the default abbreviation of the table is used. It is particularly useful to enter an abbreviation if the table appears several times in the grid, since several linked lines in the same table need to be on line simultaneously.

• Origin table (field TABORI)

It identifies the main table at the origin of the link described on the current line. It may be the main table, or one of the linked tables on the previous lines.

• Abbrev. (field ABRORI)

It corresponds to the abbreviation under which the linked table is open.

If this field is not populated, the default abbreviation of the table is used. It is particularly useful to enter an abbreviation if the table appears several times in the grid, since several linked lines in the same table need to be on line simultaneously.

• Key (field CLELNK)

It defines the table key code used to read the linked lines. By default, the first key of the table is used.

• Type (field TYPLNK)

This type takes on one of the two following values:

• 1,1 : it means that for each line in the table of origin, only one line in the linked table is read (this line is defined by the key expression).
• 1,N: in this case, several lines in the linked tables can be read. They are defined by the key expression, that can be incomplete if it is divided into several parts (those lines whose entered key elements correspond to the given value are run through).

• Link expression (field EXPLNK)

This field is defined as one or more calculated expressions separated by a semi colon. Each expression is evaluated, and the result used to identify the value of the key used to perform the join. When multiple joins are authorized, only the first elements of the key can be given.

In the expressions, constants can be used, as well as fields coming from the tables previously defined in the link list.

• Selection expression (field EXPSEL)

• Company field (field FLDCPY)

This field defines the current company, from the Workflow rule viewpoint. In this way, when the allocation rule is available by company, the proper rule is used depending on the value of the field.

• Site field (field FLDFCY)

This field defines a current site, which enables the current company to be derived from it (if it is not defined in the company field), from the Workflow rule viewpoint. In this way, when the allocation rule is available by company, the proper rule is selected depending on the value of the field.

• Legislation field (field FLDLEG)

• Option title (field AZOPTLIB)

• Option code (field OPTCOD)

• Option condition (field OPTCND)

• Error message (field AZOPTERR)