The field is usually: TableName.FieldName. But tha...
# suiteql
t
The field is usually: TableName.FieldName. But that "TranDoc.KStatus" field value is odd. It appears to be the text version of the transaction status. I ran this to look at a few:
Copy code
SELECT
	Date,
	RecordTypeID,
	BUILTIN.DF( RecordTypeID ) AS RecordType,
	RecordID,
	Field,
	OldValue,
	NewValue,
	Name As EmployeeID,
	BUILTIN.DF( Name ) AS EmployeeName,
	Role,
	BUILTIN.DF( Role ) AS RoleName,
	Context,
	BUILTIN.DF( Context ) AS ContextName
FROM
	SystemNote
WHERE
	Field = 'TRANDOC.KSTATUS'
	AND ROWNUM <=10
ORDER BY
	Date ASC