Home > Technical > Table Definitions > ITEMSTOCKMANDATORY
This table indicates whether an item is mandatory at certain locations. This will force the creation of a STORERNG record, even if the Create New Store Range option in System Settings is checked off.
Column |
Type |
Description |
LINTITEMNUMBER |
INT |
The item that this tax record belongs to. |
STRTRADECODE |
VARCHAR(10) |
The location at which this item is mandatory. |
DTMEFFECTIVE |
DATETIME |
The date from which the item is considered mandatory. If this is null, the item is mandatory immediately. |
DTMEXPIRY |
DATETIME |
The date to which the item is considered mandatory. If this is null, the item is mandatory forever. |
Primary Key: LINTITEMNUMBER + STRTRADECODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |