Home > Technical > Table Definitions > AUDITMAINTVALUE

AUDITMAINTVALUE

Used to track updates to fields.

Column

Type

Description

INTAUDITCODE

INTEGER

Key from the header.
STRKEY STRING Value of the key to the maintenance table – e.g. STRUSERCODE.
STRWHO STRING Usercode of the person who made the update.
STRTRADECODE STRING Report location code where the person for the person making the update.
DTMWHEN DATETIME Date & time the change was committed to the database.
STROLDVALUE STRING Original value for a string field.
DBLOLDVALUE DECIMAL Original value for an integer or decimal field.
DTMOLDVALUE DATETIME Original value for a date or datetime field.
STRNEWVALUE STRING New value for a string field.
DBLNEWVALUE DECIMAL New value for an integer or decimal field.
DTMNEWVALUE DATETIME New value for a date or datetime field.

 

Primary Key: INTAUDITCODE + STRKEY

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)