User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
SLG - System Modification Log
Module SLG
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.
Datafields
| 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 |
Datafield Description and Properties
Datafield INR Internal Unique ID
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.
Datafield LOGTYP Table ID of Record to be Logged
This field holds the table ID of the master file table.
Datafield LOGINR INR of Record to be Logged
This field holds the unique ID of the logged entry. The associated table is identified by the Table ID field.
Datafield FCT Function
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'.
Codetable
| Code | Text |
|---|---|
| U | Updated |
| D | Deleted |
| I | Inserted |
Datafield DATTIM Timestamp of Modification
Date and time when the modification was saved.
Datafield USR User ID
User ID of the user issuing the modification.
Datafield VER Version
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.
