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