Páginas filhas
  • Monthly Cleanup (FINA400 - SIGAFIN)

This routine cleans data tables of Financials. The cleanup considers records no longer used and those within the range of days informed.

Before the monthly cleanup, the routine generates an archive with data to be deleted. The archive file name is suggested considering:

  • Alias second and third positions of the file;
  • The company code;
  • The processing date (base date);
  • The processing month (base date).

Files are generated with extension .AMT.

Example:

If the cleanup is done in file SC9 of company 07 on 10/9/1996, the name suggested will be C9070910.AMT. If necessary, you can change this name.

Tip:

Before cleaning the files, create a general backup of the system.



Procedures

To do the monthly cleanup:

1. Click Monthly Cleanup.

A message is displayed informing that files involved in the cleanup must not be in use in other stations.

2. Make sure there is no user logged on in the system and confirm.

The Parameters window appears.

3. Fill out required data according to help instructions.

4. Confirm.

5. In the Monthly Cleanup window, enter:

a) Limit date: final date to be considered for selecting records in the data table.

b) Directory: directory where deleted records from the main database are saved (backup directory).

c) Files: names of files to be copied to the backup directory.

6. Fill out data according to field help instructions and confirm the processing.

The monthly cleanup process is started.