Invantive EstateIn this form you can view transactions, specifically for Invantive Producer.
Open Form
A transaction is a change of the data which are registered by Invantive Producer. All transactions are saved.
For each transaction is recorded by whom (username), when (time), from which form (module), from which PC (machine), what action (action) was performed in which table (table) and within which session (session). Moreover, an ascending transaction number is allocated. Finally, every transaction refers to the data which was being changed with a table reference. This is a unique number in the table, so that changed data can be traced.
There are no entry fields.
The meaning of the other fields:
Login |
The user name as registered in Persons. |
Module |
The module that was used for the transaction. |
Machine |
The Internet address of the computer that generated the transaction. |
Table |
The name of the table in which the action was performed. |
Action |
The SQL action which was started by the transaction. The actions can be ‘select’, ‘update’, ‘insert’ or ‘delete’. |
Transaction |
Ascending transaction number |
Time |
The date and time the transaction was requested. |
Table Reference |
Unique number within the table that is stored in the ID column and refers to the data that has been changed. |
Database Session |
A unique alphanumeric value that identifies the database session. |
