Home > Technical > Table Definitions > 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) |