The table contains the overview of all database tables with descriptions.

The Datengruppe specifies whether a table belongs to the

• Dyn - dynamic data
• Sta - master data (master file)
• Sys - system files.

System data contain general settings that can be adjusted; however, as a rule they are independent of the using bank and of whether the system is intended for test or production purposes.

Master data refers to all data used for the processing and settlement of business transactions but do not change in the course of processing, such as parties, accounts and conditions.

Dynamic data are data that arise from the processing of business transactions, such as contract data, transactions or workflow entries. Or they may result directly from using the system, such as session entries.

If additional customer-specific tables are entered in an installation, it makes sense to also assign these to one of these groups (by an appropriate entry in the relevant section of the SYSDBA.INI file). This assignment is important for the transactions 'Database administration“ (SYSDBA) and 'Initialize database' (SYSINI). Only in this way can it be ensured that data belonging together remain consistently contained or deleted.

For multi-entity systems, the assignment indicates at what level the assignment of a single set of a table is made to the possible units entity (ETY), entity group (ETG) or global system (Global).

In the case of 'ETY', the database table contains an 'ETYEXTKEY' column with the key for the relevant entity. 'ETG' contains the table of an 'ETGEXTKEY' column with the key of the relevant entity group.

The entries 'Log. ETY' and 'Log. ETG' mean that no explicit assignment exists for these tables via the code of the entity or entity group; however, each data set refers to a specified entry of another table which, in turn, is clearly assigned to an entity or entity group.
Example: the 'LET' table contains the INR of the relevant 'LED' entry which, in turn, contains the ETYEXTKEY.

If necessary for specific projects, the assignments of tables can also be defined differently in principle. On the other hand, both the dependencies of the tables among one another and a number of technical restrictions need to be borne in mind.