Home > Technical > Table Definitions > 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) |