Actions (Report)

General Contents - Templates - Archiving

the actions

For the archiving (process for each main table)
OUVRE At the beginning of the process
FILTRE Before the execution of the archiving
HISTO for each record archived in the main table
FERME At the end of the process
For the purging(process for each main table)
OUVRE At the beginning of the process
FILTRE Before executing the purge
EPURE for each record purged in the main table
FERME At the end of the process

the variables

APPLI Current folder
HISAPL Archived folder
TMP Flag (0/1) waiting message (by default: 1)
TRA Flag (0/1/9) log generation (by default: 1)
HISTO Flag (0/1) requested archiving
1 - archiving phase under progress (if archiving has been requested)
0 - purging phase under progress
SIMUL Flag (0/1) simulation
OKHIS Flag (0/1) archiving ok (upon recording the main table)
OKEPU Flag (0/1) purging ok (upon recording the main table)
TRACEDET Flag (0/1) detailed log
TABLE Mmain table under process
TEMPS Filing time on main table (in number of days)
SOCIETE Company entered upon starting
SITE Sites deduced from the company
FILTSUP Filter applied to the main table under process
MAXDEL number of records deleted by transaction (by default: 1000)
NPDEL number of records deleted by main table
NBLNK number of records deleted by linked table
NRDEL number of records deleted by main table + linked tables
NBRES number of remaining records by main table
TOTHIS total number of archived records
TOTDEL total number of purged records

The tables

[F1] Main table
[L1]...[L20] 20 Linked tables
[F2] Archived table
[H1]...[H20] 20 Archived linked tables