Home > Technical > Table Definitions > SUGGESTPERIODADJ

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.

TRADUNIT.strTradeCode

STRDEPTCODE

VARCHAR(10)

The department this adjustment is applicable to. This is not required if the adjustment applies to all departments.

DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

The category this adjustment is applicable to. This is not required if the adjustment applies to all categories within the department.

CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

The group this adjustment is applicable to. This is not required if the adjustment applies to all groups within the category.

GROUPS.strGroupCode

STRFROMYEARWEEK

VARCHAR(10)

The adjustment will apply to any orders placed during or after this period.

STATSPER.strYearWeek

STRTOYEARWEEK

VARCHAR(10)

The adjustment will apply to any orders placed before or during this period.

STATSPER.strYearWeekk

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)