This function makes it possible to define a groupe of linked tables (either directly or through cascade) by links of type (1,1) or (1,N) to a main table supposed to be on line.

Such a data model can then be used:

  • in a Workflow rule, either because it features the only available context to describe the tables to be scanned (case of a rule of Manual type, where the model is compulsory), or to enrich the triggering context (case of the other types).
  • in an allocation rule, where the model is compulsory. It defines the group of tables containing the fields on which the user allocation rule is based. The data model associated to a Workflow rule and the data model associated to the allocation rule must be absolutely identical.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Fields

The following fields are present on this tab :

Block number 1

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.

Characteristics

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.

Properties

  • Template w. index (field FLGEXA)
  • Setup templates (field FLGAPH)
  • Workflow (field FLGWRK)
  • Deliverable definition (field FLGADLV)

 

Close

 

Entry screen

Presentation

The definition screen shows the whole tree structure of the tables to run through, these tables all being directly or indirectly linked to the main table. The grid lines define the successive joins to be performed in order to have available the whole context on line.

Close

 

Fields

The following fields are present on this tab :

Block number 1

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.

Table

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.

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)

Close

 

Tab Miscellaneous

Fields

The following fields are present on this tab :

Workflow

  • 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.

Setup templates

  • Legislation field (field FLDLEG)

Table Options

  • Option title (field AZOPTLIB)

 

  • Option code (field OPTCOD)

 

  • Option condition (field OPTCND)

 

  • Error message (field AZOPTERR)

 

Close

 

Specific Buttons

The following fields are present on the window opened through this button :

Block number 1

  • field OBJET

 

  • field CLES

 

Block number 2

  • From folder (field DOSORG)

This field is used to define the folder from which the record is going be copied. The possible syntaxes are described in the dedicated appendix.

  • All folders (field TOUDOS)

This option is used to copy the record to all the folders defined in the dictionary (ADOSSIER table from the current solution).

  • To folder (field DOSDES)

This field used to define the folder in which the record is going be copied. The possible syntaxes are described in the dedicated appendix.

Close

This is used to copy the current record into another folder.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation