Home > Technical > Table Definitions > ITEMCATEGORY

ITEMCATEGORY

The system allows an item to be classified into department, categories, groups, family groups and classification. This table allows an item to be classified into a user defined item category. Item categories can be placed into specific types of categories for general grouping of similar categories.

Example

Category

Type

Chardonnay

Style

Merlot

Style

Barossa

Region

Hunter

Region

 

Column

Type

Description

CTRCODE

INT(4)

A unique number assigned by the system.

STRDESCRIPTION

VARCHAR(50)

A description about the item category, for example CHARDONNAY.

STRCATEGORYTYPE

VARCHAR(10)

The type of item category.

ITEMCATEGORYTYPE.strCode

 

Primary Key: CTRCODE

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