Purpose
This program is used to delete superfluous entries from the text tablesof the system tables for conditions.
The entries in the text tables are language-dependent. If an entry isdeleted in a data table, the corresponding entry is also deleted in thetext table. Only the entry in the original language is deleted however.Text entries in other languages are not deleted.
This program cleans up these inconsistencies.

Features
The program cleans up the following text tables:

• FICOB_AMT_T (Text table for table of amount categories),


• FICOB_APPL_T (Text table for table of applications),


• FICOB_CALCCATG_T (Text table for table of calculation categories),


• FICOB_COND_T (Text table for table of condition categories),


• FICOB_DATE_T (Text table for table of date categories) and


• FICOB_LIST_T (Text table for table of condition group categories).


• The report also cleans up the control table FICOB_DIFF_T (texts for
differentiation categories) for all clients - because they areclient-dependent.
A log is issued of the affected data records.

Selection
The only parameter on the selection screen for the program is the "testrun" checkbox.
If you select the field (default setting), then no changes are made tothe database.

Output
The system outputs a list of the affected data records for each table.
If it is only a test run, then the records are listed as to bedeleted; if it is an update run, then the system logs the recordsthat were actually removed from the database tables.