Record deletion
WARNING!!! Incorrect configuration of record deletion parameters may have SEVERE CONSEQUENCES
The information you delete cannot be restored. Incorrect configuration may result in the deletion of critical datasets, rendering the system inoperable. Undoing the deletion is impossible!!!
Path: Record Deletion (the SA Record Deletion extension must be installed via Extension Management)
To display a list of tables available for editing, use the Insert/Update Tables function on the Prepare tab. This updates the record count for existing entries. As a result, the rows will display the editable tables with the following pre-filled fields:
| Field | Description |
|---|---|
| Table ID | The table number. |
| Table Name | The table name. |
| No. of Records | The number of available records. Selecting this value navigates to the Record Deletion Fields page, where fields to be deleted can be added. |
| No. of Table Relation Errors | The number of errors in related tables. Selecting this value navigates to the Record Deletion Table Relation Error page, which shows related table errors. |
| Company | The company. |
| No. of Fields to Clear | The number of selected fields to be cleared. This is filled automatically based on the fields selected in Record Deletion Fields. |
Additional table-related functions are displayed on the Related tab.
| Field | Description |
|---|---|
| View Records | Displays the contents of the selected table. Useful for viewing the table's fields, determining field numbers for specific deletions, or verifying deletion results. |
| Record Deletion Fields | Displays table fields to be cleared by checking the Enabled to Clear checkbox in the relevant row. New fields can also be added. Field selection is mandatory for deleting specific fields using the Clear Fields function. |
| Record Deletion Table Relation Errors | Displays errors after record deletions or field clearing. |
Tables the records of which should be deleted can be selected manually by checking the Delete Records field for record deletion or the Clear Fields field for clearing specific field values without deleting all data. Next, on the Delete tab, select the Delete Records or Clear Fields option. The records or field values will be deleted.
Tables can also be selected using the following functions on the Prepare tab: Suggest Record to Delete – the system suggests tables for record deletion by checking the Delete Records field. Suggest Master Data to Delete – the system suggests tables from Master Data for record deletion by checking the Delete Records field. Suggest User Tables to Delete – the system suggests User Tables for record deletion by checking the Delete Records field. Suggest Fields to Clear – the system suggests fields to clear by checking the Clear Fields field.
If you need to undo the table selection, use the Clear Records to Delete function on the Prepare tab or manually uncheck the boxes.
WARNING!!! Incorrect configuration of record deletion parameters may have SEVERE CONSEQUENCES
The information you delete cannot be restored. Incorrect configuration may result in the deletion of critical datasets, rendering the system inoperable. Undoing the deletion is impossible!!!