Totalizer - Maintenance History
This procedure copies all Service Orders that are released and completed up to the maintenance date chosen by the parameter, copying all his relationships as inputs, stages, events and causes of delay. Thus all such information will be recorded in the history, making the tables related to the Service Order Service less populated, improving System performance. All queries and reports related to the Service Order also consider this history for the result.
Procedures
Running a Totalizer - Maintenance History:
| 1. | When you select the option Total - Main. History, the parameters window is displayed. |
| 2. | Fill out fields according to field help instructions. |
| 3. | Check data and confirm action. |
Note:
To ensure data integrity, a check is done for compatibility between the tables involved to assess whether all fields in the standard tables are also in the history tables, given the fact that the characteristic of the System allows the user to to include specific fields.
If any inconsistency is found, the System displays on screen the Description of Structure Problem, indicating the field (with System ID) and the problem identified.
Important: Remember that for the records to be physically deleted is necessary to perform the specific procedures in MPSDU. To ensure data integrity, the System checks for compatibility between the tables involved to assess whether all fields in the standard tables are also in the history tables, given the fact that the characteristic of the Product Microsiga Protheus® allows the user to to include specific fields. If any inconsistency is found, the System displays a screen describing the problem of the structure. Check this information to make the correction. |