TRANSACTIONXLOG - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

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.

TRANSACTIONXLOG Table Values
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.

TRANSACTIONXLOG Table Indexes.
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.