This function is used to define the archiving and purging procedures for a table and possibly any associated detail tables, as well as all the tables linked to it in the dictionary and whose cancellation code is set to deletion. Taking for example the archiving formula SOH for the customer order table SORDER, the tables SORDERP, SORDERQ etc are also archived.
These archive formulas are used during the archiving / purging function.
It is a supervisor process, which starting from the archiving formulas and the parameterization, will carryout this archiving and purging. It is however possible to add customization in a process whose name will be identified in a purging formula.
Presentation
The entry of the purging formulas is carried out in a tab.
Close
Fields
The following fields are present on this tab :
Block number 1
|
This code identifies a purging formula. |
|
|
Characteristics
|
|
|
An activity code is used to:
If the activity code is disabled:
|
|
Select a module for the setup. Use this field to specify if the screen has to be created in the folder database. This is the case when the module linked to the screen is active on the folder. |
Processes
|
Select this check box to activate the current record. Disabled records keep their content and setup but cannot be used by recalling their code:
The authorizations for a given function can prohibit the creation of an active record. In this case, the check box is disabled by default. It can only be modified by an authorized user or through a signature workflow. |
|
Optional processes can include miscellaneous sub-programs that will be called during the execution of the archiving . See the characteristics of these sub-programs. The vertical developments must start with X; the specific/custom developments must start with either Y or Z. The update of the specific/custom process does not require protection by activity code. |
|
|
Grid Tables
|
Tables to be archived and purged. |
|
It is possible to assign a principal table as well as these detail tables. As a consequence, for a detail table, the principal table with which it is associated will be specified in this field. For a detail table, no other parameter will be entered. A table can be considered as a detail table if its primary key is made up of the primary key of the principal table + an identifier. It is possible to enter up to 20 detail tables per principal table. |
|
These fields (Company, Site and Date) are used to identify the fields in the principal table containing respectively the company, the site, the date. These are the standard criteria to filter the records in the principal table to be archived. |
|
|
|
|
This field is used to define the additional filters for a formula to archive the records. The purge function uses this formula when the archiving is not activated by the parameterization. |
Close
This button is used to copy an archiving formula to another folder Warning, the associated processes are not copied. Important remarkIt is important to note that the standard processes are passed on when the archiving or purging condition is not sufficient, and these standard processes must not be changed. Their poorly considered modification can provoke archiving and purging that could place the database stability in danger. It is recommended, if it is necessary to modify the archiving / purging rules, to complete the archiving formula by defining for example more restrictive criteria and to write if necessary the deletion of additional data created in the specific/custom tables in the specific/custom process. (see the methodology).
|
This menu item allows access to the documentation management on the first paragraph of the documentation (if there is one) associated with the current record.
This menu item allows access to link management. It is used to define the links between the current record and other records (for example, the links between functions and parameters). These links are specific to the documentation and are used to load the generation of documentation structures.
This menu item launches a documentation generation. You can also launch it from the Generation button at the bottom of the screen.
You can launch three types of generation one by one or simultaneously
The range suggested by default takes into account the current record, but you can modify it at launch time.
In addition to the generic error messages, the following messages can appear during the entry :
The table entered in the "Linked table" field must have been entered as a table to be processed in the "table" field.
An attempt has been made to enter more than 20 detail tables for a principal table.
Table YYYYYYY has been linked to a principal table. At least one primary key field for the principal table must exist in the detail table YYYYYYY.
Table YYYYYYY has been linked to a principal table. The XXXXX field of the primary key for the principal table exists in the detail table but it is of a different data type.
The field identification fields (company, site, date) must reference a field that exists in the principal table.
The Company Zone field must reference a zone of the type CPY or FCY.
The field Site Zone must reference a zone of the type CPY or FCY.
The field Date Zone must reference a zone of the type date.