The SLG-table holds records for each modification of master file tables as AIJ. The record contents is stored separately as a blob with savedata with the INR of the SLG-record as identification.
These entries are created by then central log functions in the Systemmodule prefixed by Slg.
Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
LOGTYP | Table ID of Record to be Logged | Text | 6 | |
LOGINR | INR of Record to be Logged | Text | 8 | |
LOGFRM | ID of Transaction Creating log entry | Text | 8 | |
FCT | Function | Text | 1 | Embedded |
DATTIM | Timestamp of Modification | Datetime | 15 | |
USR | User ID | Text | 8 | |
VER | Version | Text | 4 |
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field holds the table ID of the master file table.
This field holds the unique ID of the logged entry. The associated table is identified by the Table ID field.
This field identifies the logged function type. Because of the possibility of recovering a 'Delete', the functions 'Insert' and 'Delete' can be executed more than once in the historic sequence of modifications. When 'Undeleting' an entry, this is stored as an 'Insert'.
Code | Text |
---|---|
U | Updated |
D | Deleted |
I | Inserted |
Date and time when the modification was saved.
User ID of the user issuing the modification.
The versionnumber in table SLG refers to the entry specified by table ID and INR. This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.