Home > Technical > Table Definitions > DEPT

DEPT

Items can be placed into a four-level hierarchical grouping - Department, CategoryGroup and Subgroup. This table contains the valid department.

Column

Type

Description

STRDEPTCODE

VARCHAR(10)

A unique code assigned by the user.

STRDEPTDESCRIPTION

VARCHAR(50)

Department name

YSNWEIGHATPOS

VARCHAR(1)

‘T’ if items in this department can be weighed at the POS Register, ‘F’ otherwise.

YSNNEW

VARCHAR(1)

No longer used.

YSNCHANGED

VARCHAR(1)

No longer used.

DBLCOSTRATIO

DECIMAL(19,4)

No longer used.

INTCOGSMETHOD

INT

No longer used.

 

Primary Key: STRDEPTCODE

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