Use Data models (GESAWM) under Development setup in the Development > Data and Parameters block to define a group of linked tables (either directly or through cascade) by links of type (1,1) or (1,N) to a main table.
-
- The data model (group of linked tables) can then be used in the following:
- A workflow rule: Either because it features the only available context to describe the tables to be scanned (if using the Manual type), or to enrich the triggering context (if using the other types).
- 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 with a workflow rule and the data model associated to the allocation rule must be absolutely identical.
- The Template code identifies the current record.
- The Properties section specifies the data model is linked to a structure, template with index, setup template, and/or a workflow.
- The Main table field identifies the main table from which other tables are read using direct links or through cascade.
- The Linked table identifies the table linked to the original table.
- The abbreviation corresponds to the abbreviation under which the linked table is open.
- If there is no entry at the Abbreviation field, the default abbreviation for the table is used.
- It is particularly useful to enter an abbreviation if the table appears several times in the grid, because several linked lines in the same table need to be online simultaneously.
- The Origin table field 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.
- The Key field defines the table key code used to read the linked lines. By default, the first key of the table is used.
- The Type field takes on one of the following values:
- 1,1: 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: 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.
- The Link expression field is defined as one or more calculated expressions separated by a semicolon.
- 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 tables previously defined in the link list.
-
Sage X3 and Sage Software are trademarks of Sage Software, Inc. Microsoft SQL Server, Microsoft SQL Enterprise Manager and SQL Server Management Studio are registered trademarks of Microsoft Corporation. Oracle is is a registered trademark or Oracle Corporation. All other product names used here are trademarks or registered trademarks of their respective owners.
-
