Miscellaneous Tables
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
Refer to documentation Implementation
Screen management
Entry screen
Presentation
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.
Close
Fields
The following fields are present on this tab :
Block number 1
| 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. |
| Enter the description of the relevant record. This long description is used as a title in screens and reports. |
| 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
|
|
| List of the codes belonging to each number of the table. These codes serve as an identifier within each table. |
| 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. |
|
|
| 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). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Company group short title. |
| 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. |
Legislation short title. |
| 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. |
|
|
Option
| 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. |
Close
Reports
By default, the following reports are associated with this function :
ATABDIV : Miscellaneous tables
This can be changed using a different setup.
Specific Buttons
The following fields are included on the window opened through this button : Block number 1
Block number 2
Close 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.. |
Tables used
Refer to documentation Implementation
Annex: number ranges used
Mind the following specific ranges:
Number ranges | Contents of the number ranges |
901-949 | Supervisor tables copied upon folder validation |
950-999 | Functional tables copied upon folder validation |
1000-1999 | Tables reserved for the vertical |
6000-6999 | Tables reserved for the specific |