Home > Technical > Table Definitions > SUGGESTSTOCKCLASS
Column | Type | Description |
STRCLASSCODE |
VARCHAR(10) |
A unique code assigned by the system. |
STRTRADECODE |
VARCHAR(10) |
The location the setup details are for |
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) |