Home > Technical > Table Definitions > STOCKENTRYZONE

STOCKENTRYZONE

The STOCKENTRY table is used to record the counts of items, either via a manual sheet or a PDE. This table allows the counts to be divided into zones. The zone simply indicates whether any counts have been loaded for the zone and when they were processed. The user can quickly see this and know what still needs to be counted.

Column

Type

Description

STRSOURCE

VARCHAR(5)

The transaction type to which this entry is linked., for example STK would indicate a stocktake.

LINTREFERENCE

INT

The reference of the source transaction. If the source was STK, this number would be the stocktake number.

INTZONE

INT

A unique number indicating the zone

INTCOUNT

INT

The number of records entered for this zone.

DTMLASTLOADED

DATETIME

The date/time data was loaded against the zone.

DTMLASTPROCESSED

DATETIME

The date/time the data was actually processed.

 

Primary Key: STRSOURCE + LINTREFERENCE + INTZONE

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