Home > Technical > Table Definitions > LOGAPN

LOGAPN

Contains a log of changes to the APN table. Records when an APN is deleted and added (modifications are a delete followed by an add). We can send this file to another site to modify their APN file in the same order.

Column

Type

Description

CTRCODE

INT(4)

Unique number assigned by the system.

DTMWHEN

DATETIME(8)

Time the APN was added/deleted.

STRTYPE

VARCHAR(1)

Type of action to the APN. A=Add, D=Delete.

LINTITEMNUMBER

INT(4)

The IPN of the item the APN belongs to.

ITEM.lintItemNumber

DBLAPN

FLOAT(8)

The APN/PLU number.

STRSTORECODE

VARCHAR(10)

If filled in, the log record will only be sent to this store. If empty, the record will be sent to all stores.

TRADUNIT.strTradeCode

STRAPN

VARCHAR(20)

The APN/PLU number.

 

Primary Key: CTRCODE

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