The OnBase TRANSACTIONXLOG table stores information regarding modifications to a document. The itemnum of a document (stored in the num field) can be used to retrieve all of the logged information about a document. The TRANSACTIONXLOG table is located in DBSpace1.
| Column Name | Data Type | Description |
|---|---|---|
| transactionnum | bigint | |
| tmessage | char(200) | Text message describing the change that occurred to the document. |
| action | bigint | |
| logdate | datetime | The date the transaction was logged. |
| num | bigint | The Document Handle of the modified document. |
| userunum | bigint | The unique identifier of the OnBase user who modified the document (cross-referenced to USERACCOUNT). |
| itemnum | bigint | |
| docrevnum | bigint | |
| registernum | bigint | The unique identifier of the Client workstation from which the action was performed. |
| actionnum | bigint | |
| subactionnum | bigint | |
| severityflag | bigint | |
| tracelvl | bigint | |
| extrainfo1 | bigint | |
| extrainfo2 | bigint |
The indexes for the TRANSACTIONXLOG table are located in DBSpace1.
| Index Name | Included Columns |
|---|---|
| transactionxlog1 | transactionnum |
| transactionxlog2 | num |
| trasnactionxlog3 | itemnum |
Note: The transactionxlog3 index on itemnum
only exists in new OnBase databases created with OnBase 11.0 and higher.