a window made-up of a header and one or more tabs located in the right-hand section and a selection list located on the left ("browser"). A record is managed at the same time.
a window made-up of a single screen containing a list of the records in the table.
This object is used to manage a record in a table (a business partner record for example), or in several tables (the order header and the corresponding lines).
In addition to the principal left list of the object, it is possible to define additional left lists where this gives an advantage. This is carried out by the declaration of a browser type object for each additional left list.
Refer to documentation Implementation
Presentation
The header is used to specify the object.
Close
Fields
The following fields are present on this tab :
| The object code is comprised of 1 to 3 alphanumeric characters. The Adonix reserved words are prohibited. |
| Enter the description of the relevant record. This long description is used as a title in screens and reports. |
|   |
| Code for the principal table managed by the object. |
|   |
Close
Fields
The following fields are present on this tab :
General
| Indicate the application module to which the record is attached (and the attached code if necessary). The records used by several modules are classified in one of the modules common data or supervisor. A development associated with a module (and the corresponding code) can only be used if the module is active in the current folder. |
| In the case where the managed object is identified by a key made up of 2 components (for example a miscellaneous table where the first component represents the number of the table), the first key component becomes a parameter for the management of the object. You must therefore give a label for this parameter (Table number in the example above).
|
| If it is defined, an activity code attached to an object is used to make it optional. |
| Defined here is the principal record field where the site code is found to which the entry is attached. The fact of defining this site makes it possible to automatically manage the access restrictions for the site data. |
| The field in the principal table where the access code attached to the record is found is defined here. The fact of defining this code makes it possible to automatically manage the access restrictions for access code data. |
Block number 2
| This characteristic defines the manner in which the object manages the records in the table. The possible choices are Simple, In grid, Combined. A forth value equal to the Browser makes it possible to independently create the browsers that will then be integrated in a window. Simple. this is the most common type. It corresponds to the case where an entry in the principal table is managed in a record, a list of records being displayed in the left list. The object management screen obeys this logic itself (it is an object itself, its code is AOB), but numerous other examples exist : customers, invoices, postings, orders... are all simple objects. Grid. This corresponds to the case where the table, if sufficiently small, can be directly loaded in the lines of a single grid displayed in the screen. In this case, the left list no longer exists (it is of no use). The management of the section coding is carried out in this way. Combined. This corresponds to the case where a group of records are loaded in a grid, records where the key is made for N (N>1) sections, where the N-1 sections are fixed and the last section varies. Warning, this is not the case for the invoices (which have a key type document/line number), because in this case, the management of a simple object is carried out in the header and the loading of the lines is managed in the code associated with the object. An example of such an object is the management of technical records : for a control code, there is 1 to N lines present in a grid. Browser. This type is used to define the left lists that will then be attached to a window. The information to be entered in this object type is reduced to the information required to construct a left list. |
Links
| This field defines the menu code in which the management function for the object will be present for the user ADMIN. |
| Indicate the rank where the function will appear in the menu above. In a menu the functions are sorted by rank in ascending order. |
| This print code defines the report(s) launched when the File / Print menu option. It should be noted that the report ranges can be entered from the current record : in fact, the File / Print choice is only accessible if a current record is displayed on the screen. By default, when using these button, the software will attempt to print the reports whose names are given here. But a non-direction table exists that is used to redefine, from the internal code given here, one or more reports (e.g. the printing of the picking lists, and delivery advice notes in the shipments object). |
| This print code defines the report(s) launched when the File / List menu option. The File / Listchoice is always accessible and it is designed to be used to print general lists linked to the online tables. By default, when using these button, the software will attempt to print the reports whose names are given here. But a non-direction table exists that is used to redefine, from the internal code given here, one or more reports (e.g. the printing of the picking lists, and delivery advice notes in the shipments object). |
| Used to propose the requests in the File/List menu for the function when no list is planned for. If this field is entered, the supervisor proposes all the requests and SQL requests having the GROUPE field equal to this entered value. If not entered, the value used is that of the object code. If no request is parameterized, the supervisor proposes the automatic creation of a request, structured by the columns in the left list. |
Options
| This tick box allows the activation of the "Statistics" button in the object. This button is used to call the statistics interrogations where the first criteria are defined by the data linked to the principal table or to the tables linked to the object. |
| The supervisor will authorize or not the deferred deletions in the principal table as well as the secondary tables managed by the object. This possibility is offered for the parameterized users on deletion confirmation. When this user deleted a record in the object, a confirmation window is displayed. The user can check the "deferred deletion" box in this window. The record will therefore remain present until the differed deletion utility is launched. |
| This field makes it possible to specify that the object can be imported by the function import-export. |
| Used to trigger the logical lock when going to modify a record, where as standard it is set to the display of the record. In order to use modification mode, it is necessary to click on the key.
|
| In an object managing two elements of the key other than the site or the depositor, the two elements that will appear in the case of an error in a record is indicated here.
|
| Indicate whether there is the notion of the site or depositor in this function. The notion of a depositor will be determined by the presence of the DEP field in the primary key of the table linked to the object. The supervisor automations on the subject of the site or depositor for a function, are the following :
|
Block number 5
| Processes in which, it will be possible to write additional sub-programs for the management of the object for this function. One process is reserved for the standard development, the next for the verticals and the last for the custom/specific. Development help. |
|   |
| Processes in which, it will be possible to write additional sub-programs for the management of the object for this function. One process is reserved for the standard development, the next for the verticals and the last for the custom/specific. Development help. |
Close
Presentation
All the information that is used to construct the principal left list for the object as well as the selection window is found here. In addition, there is the possibility to define the selection options.
This grid is used to define the selection criteria that affect the records in the managed table. These filters, expressed in the form of logical conditions applied to the fields in the table and any constants, are identified by a letter (uppercase for the standard, lowercase for the specific). They are then set or not on the fields that have a data type linked to this object.
For example :
In the entry of sales orders, only active customer will be authorized. To do this, a selection filter is defined in the Customer object, with the condition BPCSTA=2 and the title "Active customer". In the orders screen SOH0, there is a customer field BPCORD with the data type BPC (type is linked to the object BPC). In the contextual menu with the data type BPC, the "Options" menu is used to set or not each of the declared filters in the customers object.
The list of columns that must appear in the left list is entered in the grid at the bottom of the second tab. These columns can be the fields in the principal table or a secondary table identified in the 3rd tab if the link expression is entered. They can also be an expression; in this case, it is necessary to specify the type of data to store the result of the expression.
Close
Fields
The following fields are present on this tab :
Grid Selection options
| This grid is used to define the options for the management of the object. One option makes it possible to characterize the sub set of records identified by a condition (active customers, open accounts,...) An option can be defined by :
|
| This grid is used to define the options for the management of the object. One option makes it possible to characterize the sub set of records identified by a condition (active customers, open accounts,...) An option can be defined by :
|
|   |
|   |
Selection screen
| This field is used to define an index for the principal file for the display in the left list and in the selection windows. If this field is empty, it is the first index in the table that is used. |
| This field is used to define the direction from moving through the principal table for the display in the left list and the selection windows for the object. |
| This field makes it possible to specify one or many options for the records present in the selection window. |
| When the key chosen for the let list is composed of several parts, the list presents only the first part of the key initially. By double clicking on one of the values of the key there is the possibility to explore the sub-values of the key and thus through the number of levels of existing sub-keys. When all the key levels are explored, a record can be selected from the table. An example of this functioning can be seen in the site management object : each site being attached to a company, the initial display is the list of companies and there is then the possibility to expand a company by double clicking it : the list of sites then appears and it is possible to select one of these. if the box is not checked, it is a simple list. |
| Any field in a screen where the type is linked to a object has available a selection field accessible by right click or by. This value is used to define the number of characters used to specify where the selection should start, as a function of what has been entered in the field before the selection. If this value is N, the selections starts from the first key where the first N characters are greater than or equal to the string entered. Indeed :
|
| The table in which the field to be displayed is located is entered here. This table is either the principal table or one of the tables defined as linked to the principal table in the object definition. This field can be empty if a calculated expression is displayed. |
| The fields present in the left list are entered here. They come from the table previously defined. |
| When a column from the left list is evaluated, a calculated expression is defined here whose result is placed in the column. A data type is then required to format the field. |
| This label is used as a column title both in the left list and in the selection windows for the object. By default, the field label is used. It should be noted that this title can be translated. Thus if an unknown title is entered, the window that is used to create a new text in the dictionary opens automatically. |
| This data type is used to forma the previous expression in the left list. |
| This information is used to format the data by the choice of option. The options depend on the data type (use the search window). |
| Possibility to indicate a length for an alphanumeric column constructed by an expression. If not entered, a length of 30 characters is used by default. |
| Indicate the hierarchical level. This is used to dissociate the hierarchical levels in the left list from the key structure. Warning, the parameterization is insufficient and development is required. |
Close
Presentation
Is used to define a set of tables necessary for the function to be executed, the screen-table link for the import management, the additional screens that can be accessed via button or menu for the web services.
Close
Fields
The following fields are present on this tab :
| Additional tables to the principal table managed by the object. These tables are opened then automatically closed on the execution of the object, under the abbreviation indicated otherwise under the dictionary abbreviation. The fields in these tables are accessible in the object. In addition, the fields in these tables are used to define a left list column and the selection screens from the moment when the link expression is entered. It is possible to define the hierarchy links, on the condition that these tables are entered in the grid in the hierarchy order. The link key must be unique. If it is not entered, the supervisor takes the primary key. |
|   |
|   |
|   |
|   |
Grid Import
| Specify all the tables that will be updated for the import. Then, for each table, the screen(s) are specified that it will generate. And finally, for each grid section, the variableat the bottom of the grid is specified when this information is used to load a detail table. |
|   |
|   |
Grid Additional screens
| For WEB services, indicate the additional screens used in the object management from the button at the bottom of the screen or a menu.
|
|   |
Close
Action icon
This button is used to create automatically the necessary links to the translated text tables ATEXTRA.
Close
Presentation
Is used to define a set of views necessary to execute the function. These views are opened and closed in the processing generated linked to the WO object.
Close
Fields
The following fields are present on this tab :
| These views are opened then automatically closed on the execution of the object, under the abbreviation indicated otherwise under the dictionary abbreviation. The fields in these views are accessible in the object. |
|   |
|   |
Close
By default, the following reports are associated with this function :
PRTSCR : Screen print
This can be changed using a different setup.
The confirmation is used to generate the automatic process linked to the object (WOxxx, where xxx is the object code) |
The following fields are included on the window opened through this button : Block number 1
Block number 2
Close This button is used to copy the definition of the object to another folder. Warning, it will be necessary to confirm the object in the destination folder. |
In addition to the generic error messages, the following messages can appear during the entry :
The linked table is mandatory for the objects except for the browsers.
In a hierarchy list (simple or picking), the number of elements declared for the left list must be greater than or equal to the number of elements in the index used.
If the "site" field is entered, the value entered is a field name that must exist in the principal table.
For technical reasons the character "«" is prohibited in all the text fields: the object title, the setup title, the options title, the condition expression, the error message, the link expression.
The expression entered does not respect the X3 syntax. An explanatory message details the error.
An attempt to enter a selection option, does not exist in the selection options grid.
The table must be declared in the list of tables to be opened in the "Environment" tab.
The table must be declared in the list of tables to be opened in the "Environment" tab and have a correct link expression.
The field must exist in the table entered in the previous field.
The field entered is of the type "AXX". This signifies that it does not exist in the database but is used only to link to the text table ATEXTRA.
The field entered is of a data type that is not authorized for use in the left list : "AXX" Type, Clob or Blob.
An attempt has been made to lift the "import" flag when the import template already exists.
The abbreviation of a table or of a view must be unique for all the tables and views defined for the object.