Home > Technical > Table Definitions > TERMAUDIT

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)