Home > Technical > Table Definitions > TERMAUDIT
The details of deleted or changed ITEMTERM and SUPPTERM records are written here.
| Column | Type | Description |
|
STRTYPE |
VARCHAR(1) |
Indicates where the term came from. I=ITEMTERM, S=SUPPTERM |
|
STRCODE |
VARCHAR(10) |
The code of the record the term was attached to. If it was attached to an ITEM, this will be lintItemNumber. If it was attached to a SUPPLIER, this will be the strSupplierCode. |
|
DTMWHEN |
DATETIME(8) |
The date the audit record was written. |
|
CTRCODE |
INT(4) |
A unique number assigned by the system. |
|
STRDETAILS |
VARCHAR(200) |
Details about the term being changed or deleted. |
|
STRWHO |
VARCHAR(20) |
The user who deleted the term. |
Primary Key: STRTYPE + STRCODE + DTMWHEN + CTRCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |