Home > Technical > Table Definitions > DPTCATGR

DPTCATGR

This table is used to store valid combinations of departments, categories, groups and subgroups. In addition, it also allows the entry of numeric codes for the department, category and group combination. However, this particular feature has been replaced by the XREFDPTCATGR.

Column

Type

Description

STRDEPTCODE

VARCHAR(10)

Department code.
DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Category code.
CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Group code.
GROUPS.strGroupCode

INTDEPTCODE

SMALLINT

No longer used

INTCATCODE

SMALLINT

No longer used

INTGROUPCODE

SMALLINT

No longer used

YSNNEW

VARCHAR(1)

No longer used

YSNCHANGED

VARCHAR(1)

No longer used

YSNDISCOUNTCALC

VARCHAR(1)

No longer used

YSNASKCOMMENT

VARCHAR(1)

No longer used

STRSUBGROUPCODE

VARCHAR(10)

Sub-Group code.
SUBGROUP.strSubGroupCode

 

Primary Key: STRDEPTCODE + STRCATCODE + STRGROUPCODE + STRSUBGROUPCODE

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