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, the payment methods and the freight terms...

This function is used to define the characteristics of these tables (or to modify to a certain extent the characteristics of existing tables). The definition of such a table is made by specifying its number, a title (and a short title) defining the information that it will store, and the titles for the 4 fields that can be entered (Alpha 1, Alpha 2, Numerical 1, Numerical 2).

The length of the code is based on the MAXADI folder parameter. It remains possible for some tables to enter a length shorter than or equal to the length of the MAXADI parameter.

An activity code can be associated with any table, which is used to activate or to deactivate it, or even to indicate that the table is a specific/custom development when the activity code starts with one of the letters X,Y or Z.

The tables are assigned according to a standardized numbering plan. The grid below specifies the reserved ranges for any product:

Number range

Module

 1-100

Supervisor

 101-900

Standard tables (sub-splitting according to the product)

 901-999

Standard tables systematically recopied in the client folder

 1000-1999

Reserved for the vertical miscellaneous tables

 6000-6999

Reserved for the specific/custom miscellaneous tables

 8000-8099

Localization for the USA

 8100-8199

Localization for England

 8200-8299

Localization for Spain

 8300-8399

Localization for Portugal

 8400-8499

Localization for Italy

 8500-8599

Localization for Argentina

 8600-8699

Localization for Germany

Tables 901 to 999:

Usually the miscellaneous tables are copied upon folder creation and are then no longer updated by Adonix. For some tables, such as table 901 of the chapters for parameters, it is necessary to perform an update upon each client folder validation.
This copy mechansim is applied to the tables of the 901 to 999 bracket:

  •   901 - 949 tables of the supervisor
  •   950 - 999 Functional tables

The table setup (ATABTAB) is copied from the reference folder.
The table content (ATABDIV) is copied from the copy folder.

Be careful with the update of the data by the client: If these tables can be modified, only the codes >= "X" are kept, all the others are updated.
It is thus recommended to only set the "modifiable" flag on a new table of this bracket if it turns out to be necessary.

The grid below specifies the reserved ranges for the X3 product:

Number range

Module

 101-200

Purchasing

 201-300

Sales

 301-400

Financials/A/P - A/R Accounting/Fixed assets

 401-500

Customer Relation

 501-700

Abel

 801-900

Manufacturing

The grid below specifies the reserved ranges for the Sage X3 People product:

Number range

Module

 301-450

 Common data / Payroll / Time

 451-500

Training

 501-550

Payroll with the BIL activity code (social balance sheet)

 551-600

Expenses

 601-700

Common data

The grid below specifies the reserved ranges for the Sage GEODE GX product:

Number range

Module

 101-900

 Geode

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Presentation

    This tab is used to enter the characteristics of each miscellaneous table.

    Close

     

    Fields

    The following fields are present on this tab :

    Identifier

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

    • Title (field LNGDES)

    This long 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.

    General

    • Short title (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)

    Module belonging to the setup. This field is used to specify whether the screen has to be created in the folder database. It is specified when the module linked to the screen is active in the folder.

    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.

    This access code is used to to limit access to the current record for certain users.
    If the field is entered, only the users having this access code in their profiles can view and modify this record.

    Properties

    • 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)
    • Filter legislation (field FLGLEG)
    • 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

    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.

    Table Alphanumeric columns

    • Title (field COLALPDES)

     

     

    • Option (field COLALPSUP)

     

    Table Numeric columns

    • Title (field COLNUMDES)

     

     

    • Option (field COLNUMSUP)

     

    Close

     

    Specific Buttons

    This button is used to revalidate all the screens having a field of type ADI in the current miscellaneous table. This is used to take into account a change in the length of the code in the screens.

    Menu Bar

    Documentation / Paragraphs

    This function is used to access the documentation management on the first paragraph of the documentation (if there is one) associated to the current record.

    Documentation / Links

    This function is used to access the links management. It is used to define the links between the current and other records (for example the links between functions and setups). These links are specific to the documentation and are used to load the generation of documentation structures.

    Documentation / Generation

    This menu is used to launch a documentation generation. The generation can also be launched from the [Generation] button at the bottom of the window.

    Three types of generation can be launched one by one or simultaneously:

    • the generation of the documentation structure from the dictionary (tables ADOCUMENT, ADOCBLB, ADOCCLB).
    • the generation of the documentation from the previous tables.
    • the generation of the field documentation.

    The range suggested by default takes into account the current record but it can be modified upon launch.

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    You are going to modify a dependence used by xxxxx

    An attempt has been made to modify the code of a dependence table when it is used as a parameter in the xxxxx screen.

    Impossible link

    An attempt is being made to declare the current table as a dependent table to itself.

    Data type incorrect

    The internal type of the data type entered is not accepted for this column.

    Length too great

    An attempt has been made to enter a length, for a code in the table that is greater than that declared at folder level.

    Tables used

    SEEREFERTTO Refer to documentation Implementation

    Specific to the miscellaneous tables used for the statistics

    The titles of these miscellaneous tables can be modified in the following local menus:

    • 206 for tables 20 to 24 concerning the product statistics
    • 207 for tables 30 to 34 concerning the customer statistics
    • 208 for tables 40 to 44 concerning the supplier statistics
    • 3005 for tables 440 to 444 concerning the contract statistics
    • 3007 for tables 445 to 449 concerning the service request statistics