This function is used to specify the selection reference(s) used during an intra-group transfer operation, in order to define the asset population concerned.

A selection can be composed of several criteria, each criterion being based on the content of a section of the asset.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

A Sélection reference must be defined for a company.

It is composed of 1 to 5 criteria, each being set up on one of the lines of the table and linked to the following by one of the following Boolean operators: And, Or.

The process for selection criteria entry is as follows:

1/ Enter, or select from the list obtained by a right click the field in the asset table FXDASSETS which contains the information to which the selection is applied.

2/ Then select the operator: Irrelevant., Equal, Different, Greater than or equal, Less than, Lessthan or equal to, Like.
The operator Like is only valid for the numerical sections. It makes it possible to use meta characters.

3/ Enter a value. The list of possible values for the chosen field can be obtained via right click, when these values are contained in a local menu or in a table (miscellaneous table, common table, accounting table…).

Block number 1

Reference (field REFSELCIG)
Description (field SELCIGDES)

Description of the selection.

Company (field CPYSRC)

This non modifiable field displays the reference for the source company to which the selection is applied.

Block number 2

Table (field TBL1)
Field (field FLD1)

Indicate a field from the table.
Operator (field OPE1)

Indicate the comparison operation:

  • The "indifferent" operator is used to obtain all records of an object.
  • The '* ?' operator is used to define wildcards.
Value (field VAL1)

This field is used to indicate the comparison value (without quotation marks for the alphabetic fields).
And/or (field ANDOR2)

Indicate the link between the criteria lines.

For instance:
If you enter Expr1 and Expr2 or Expr3, then you get (Expr1 & (Expr2 | (Expr3)))
Table (field TBL2)
Field (field FLD2)
Operator (field OPE2)
Value (field VAL2)
And/or (field ANDOR3)
Table (field TBL3)
Field (field FLD3)
Operator (field OPE3)
Value (field VAL3)
And/or (field ANDOR4)
Table (field TBL4)
Field (field FLD4)
Operator (field OPE4)
Value (field VAL4)
And/or (field ANDOR5)
Table (field TBL5)
Field (field FLD5)
Operator (field OPE5)
Value (field VAL5)

Block number 3

Query (field REQUETE)

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation