Home > Technical > Table Definitions > ITEMSTOCKMANDATORY

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.

ITEM.lintItemNumber

STRTRADECODE

VARCHAR(10)

The location at which this item is mandatory.

TRADUNIT.strTradeCode

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)