Tables for General System Settings

table_name

string40

N

N

Name of the table whose record was deleted.

key_xml

string1700

N

N

This XML string holds the details about the record that was deleted. Generally, this includes the primary key and perhaps the row_id for the row being deleted. For example, deleting a job from the job table results in the following XML entry:

<delete>

<wo_id>20201002.3</wo_id>

<oper_id>10</oper_id>

<seq_no>1</seq_no>

<row_id>8</row_id>

</delete>

deleted_time

tdatetime

N

N

The date and time when the record was deleted.

row_id

bigint64

Y

N

Unique row identifier, for audit trail.