Home > Technical > Table Definitions > SUGGESTSTOCKCLASS

SUGGESTSTOCKCLASS

Column Type Description

STRCLASSCODE

VARCHAR(10)

A unique code assigned by the system.

STRTRADECODE

VARCHAR(10)

The location the setup details are for

TRADUNIT.strTradeCode

DBLMINSTOCKCOVER

DECIMAL9(19,4)

Once the number of weeks stock drops under this amount, the item must be reordered.

DBLMAXSTOCKCOVER

DECIMAL9(19,4)

The maximum number of weeks stock that is required. The system will not order more than this amount of stock.

DBLREORDERSTOCKCOVER

DECIMAL9(19,4)

Once the number of weeks stock drops under this amount, the item may be reordered. This is used in conjunction with dblMinStockCover. At least one item must be below the minimum stock level. Once this occurs the system will then order any other items which are less than the reorder level. This is basically saying 'if I have to order some stock I may as well reorder other items which aren't urgent but require reordering'.

 

Primary Key: STRCLASSCODE + STRTRADECODE

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