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. |
| usernum | 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 |
| trasnactionxlog4 | logdate |
Note: The transactionxlog3 index on itemnum only
exists in new OnBase databases created with OnBase 11.0 and higher. The
trasnactionxlog4 index only exists in new OnBase databases
created with OnBase 18.0 and higher.