The miscellaneous tables are related tables used in all contexts of the software for storing codes and some restrictions for attached information. For example, stored here are the tax regimes, payment types, non-payment types…

These common tables, identified by a number, allow the storing of the following elements:

*    codes serving as identifiers, and that are stored in the fields using the data type ADI. The number of characters can be made available for setup by the user in certain miscellaneous tables, in the table definition. The user can define the length of these codes by means of a dedicated function.

*    the corresponding long and short titles. These titles can be translated/ The texts are stored in the ATEXTRA table.

*    a possible dependence link toward the key of another miscellaneous table (to manage, for example, the fact that a sub-group cannot be attached to a given group).

*    1 to 4 user-defined fields.

The meaning of some of these tables is pre-defined in the software but it is possible to add tables in the framework of a vertical or specific processings.  The range reserved is defined in the document annex.

These miscellaneous tables are, for technical reasons, stored in a single table in the database. The entry of values in these miscellaneous tables is assured by this function.

Tables 900 to 999 are always delivered in the standard version. If it is necessary to add records in these tables, the records must hence have an identifier starting with X, Y or Z to be kept. If this is not the case, the records are deleted during the next folder validation.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Once the table number is entered, the existing table code is loaded, and then the following can be entered line by line, the codes, the corresponding long and short titles, additional associated values if necessary, and the code of the linked group (these columns only appear if the additional fields and/or a dependence link have been defined). These additional values can be selected and controlled.

When this function is called directly by tunnel from the entry of a code value, the table number is imposed. It is then not possible to change it.

Block number 1

Table (field NUMTAB)

This number identifies the miscellaneous table. A certain number of numbers are predefined in the software, but it is possible to add to them, by specific/custom development, using number ranges reserved for this purpose.
Description (field ZINTIT)
Dependency table (field DEPNUM)

Indicate here the number of the miscellaneous table that serves as a reference to enter the Dependence column. During the use of the miscellaneous table, it imposes a dependence between two fields entered by the linked miscellaneous tables.

Grid List of values

No. (field NUMLIG)
Code (field CODE)

List of the codes belonging to each number of the table. These codes serve as an identifier within each table.
Description (field LNGDES)

This title, associated with the table code is entered by default in the connection language, but it can be translated into other languages. In fact, by a right click on the field, it is possible to open a window that is used to enter a list of language codes and associated titles. If not, the function text translation is used, by selecting the chapter Miscellaneous tables, to carryout a translation in all the languages of the texts that have been selected.
Short description (field SHODES)
field A1

The entry values in the additional columns depending on the parameterization of the miscellaneous table (up to four additional values can be used and also a value for the depending code).
Dependency (field DEPCOD)
field SOC

Company group short title.

field INTSOC

This column "Company group" appears when the check box "Company filter" has been checked in the miscellaneous table definition. If the GSOCIETE variable is entered in a calling function, a filter will be applied on this table in selection mode and the legislation of the current company will be controlled.

field LEG

This field displays the legislation code for the country, for example FRA for French legislation.

This code is attached to a company and assigns predetermined rules and parameters necessary to fulfill country-specific legal requirements. It can include calculation rules, legal reports, legal declarations, tax management, and so on.

Legislations are defined in Miscellaneous table 909. General parameters can also be defined at the legislation level.
field INTLEG

This column "Legislation" appears when the check box "Legislation filter" has been checked in the miscellaneous table definition. If the GCURLEG variable is entered in a calling function, a filter will be applied on this table in selection mode and the legislation of the current company will be controlled.

field ENAFLG

Option

Default value (field VALDEF)

This value, chosen from amongst the codes available in the table, is proposed by default during the entry of a field controlled by this miscellaneous table.

Reports

By default, the following reports are associated with this function :

  ATABDIV : Miscellaneous tables

This can be changed using a different setup.

Specific Buttons

This button allows the recopying at the same time of the miscellaneous table setup structure and its contents (the contents of the previous miscellaneous table are lost) to another folder..

Block number 1

field OBJET
field CLES

Block number 2

From folder (field DOSORG)

Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix.
All folders (field TOUDOS)

Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution).
To folder (field DOSDES)

Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix.