Home > Technical > Table Definitions > SUGGESTPERIODADJ
This table is used as part of the suggested ordering. It records an adjustment factor for a specified department and period range. When the system calculates the amount of stock to order it will multiple by this factor, if appropriate.
Column | Type | Description |
CTRCODE |
INT(4) |
A unique code assigned by the system. |
STRSTORECODE |
VARCHAR(10) |
The trading unit this adjustment is applicable to. If empty then applicable to all trading units. |
STRDEPTCODE |
VARCHAR(10) |
The department this adjustment is applicable to. This is not required if the adjustment applies to all departments. |
STRCATCODE |
VARCHAR(10) |
The category this adjustment is applicable to. This is not required if the adjustment applies to all categories within the department. |
STRGROUPCODE |
VARCHAR(10) |
The group this adjustment is applicable to. This is not required if the adjustment applies to all groups within the category. |
STRFROMYEARWEEK |
VARCHAR(10) |
The adjustment will apply to any orders placed during or after this period. |
STRTOYEARWEEK |
VARCHAR(10) |
The adjustment will apply to any orders placed before or during this period. |
DBLFACTOR |
DECIMAL(19,4) |
The adjustment factor. To order 10% more stock this would be 1.1. To order 10% less this would be 0.9. |
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |