Home > Technical > Table Definitions > ITEMCHG

ITEMCHG

Records when an item department code is changed.

Column

Type

Description

INTCHANGECODE

Bigint

Incrementing value, starting at 1

LINTITEMNUMBER

Integer

Item number affected

DTMCHANGE

Datetime

Date and time the department change was made.

STROLDDEPT

Varchar(10)

Old Department code

STRNEWDEPT

Varchar(10)

New Department code

INTEXTRACTCODE

Bigint

Initially set to NULL. When the Extract process is run, the value will be set to the INTEXTRACTCODE from the E5EXPORT table.

 

Primary Key: INTCHANGECODE

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