Home > Technical > Table Definitions > STOCKAREAS

STOCKAREAS

This table contains the store stock area information used in stocktake templates.

Column Type Description

CTRCODE

INT

Unique code assigned to the stock area.

STRNAME

VARCHAR(20)

Description of the stock area. This must be unique for a location, however multiple locations may share the same name.

STRTRADECODE

VARCHAR(12)

Store location (department) the stock area belongs to.

INTSEQ

INT(2)

The sequence number the stock area will appear in relation to other stock areas.

This must be unique for a location however multiple locations will share sequence numbers.

  

Primary Key: CTRCODE

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