Definition of miscellaneous tables

• Table number (field NUMTAB)

Entered here is the number that uniquely identifies the table to be set up.

• Description (field LNGDES)

This long description is used as a title in screens and reports. This title can be translated and is recorded in the user's connection language.
You can add your translation in another language using the Translation function.

• Click Translation from the Actions icon in the field concerned.
• In the Translation window, add a new language code with the translation in this language.

• Short description (field SHODES)

This short title is used in the screens and reports. This title can be translated and is saved in the connection language of the user. If it is necessary to translate this title into another language, it is possible to access via right click this field in the corresponding translation function.

• Module (field MODULE)

[object Object]

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

• Access code (field ACS)

This access code makes it possible to prohibit access to the current record for some users.

As a matter of fact, if the field is completed, only the users having this access code with read rights (respectively write rights) can view (respectively modify) the concerned record.

• Changeable (field UPDFLG)

If this box is un-checked, it will not be possible to modify the contents of this miscellaneous table.

• Company filter (field FLGSOC)

This checkbox is used to display also the column 'Company' in the Management of Miscellaneous tables:

• checked : The column "Company group" is displayed in the management of Miscellaneous tables. If the variable GCURLEG is assigned, a filter will be applied on selection and the legislation of the current company will be controlled.
• not checked : Not additional field, no filter

• Filter legislation (field FLGLEG)

This checkbox is used to display also the column 'Legislation' in the Management of Miscellaneous tables:

• checked : The column "Legislation" is displayed in the management of Miscellaneous tables. If the variable GCURLEG is assigned, a filter will be applied on selection and the legislation of the current company will be controlled.
• not checked : Not additional field, no filter

• Legislation mandatory (field OBLLEG)

• Active flag (field FLGENA)

• Modifiable length (field LNGFLG)

Define if the length of the code in the miscellaneous table is modifiable. The user will then define the length of these codes by means as a function of personalization of the miscellaneous tables, within the limit of the maximum length defined in the folder parameters(parameter MAXADI).

• Length (field LNG)

The length of the code in the current table is entered here. This length cannot be exceed the maximum length defined in the folder parameters (MAXADI parameter).

• Dependency table (field DEPNUM)

This field is used to make the values entered in a miscellaneous table dependent on the values entered in another field in the same screen, itself controlled by another miscellaneous table (whose number is indicated here). see document.

The fact that this field is defined adds a column titled Dependance in the entry of the lines in the miscellaneous table. It is in this column that the values of the code coming from the dependence table are entered.

• Description (field COLALPDES)

• Type (field COLALPTYP)

• Option (field COLALPSUP)

• Description (field COLNUMDES)

• Type (field COLNUMTYP)

• Option (field COLNUMSUP)