Home > Technical > Table Definitions > DISCQUALIFYITEM

DISCQUALIFYITEM

The items which are required for a qualifying group are required here. The qualifying groups are stored in DISCQUALIFYGROUP.

Column

Type

Description

LINTDISCOUNTCODE

INT(4)

The code which identifies the DISCHDR this record belongs to.

DISCHDR.ctrCode

LINTGROUPCODE

INT(4)

The code of the qualifying group the item belongs to.

DISCQUALIFYGROUP.ctrCode

CTRCODE

INT(4)

A unique number assigned by the system to identify the discount.

STRDEPTCODE

VARCHAR(10)

Only items in this department code qualify for this qualifying group. If not set then items from any department can qualify.

DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Only items in this category code qualify for this qualifying group. If not set then items from any category can qualify.

CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Only items in this group code qualify for this qualifying group. If not set then items from any group can qualify.

GROUPS.strGroupCode

STRSUBGROUPCODE

VARCHAR(10)

Only items in this subgroup code qualify for this qualifying group. If not set then items from any subgroup can qualify.

SUBGROUP.strSubGroupCode

STRCLASSCODE

VARCHAR(10)

Only items in this classification code qualify for this qualifying group. If not set then items from any classification can qualify.

CLASS.strClassCode

STRFAMILYCODE

VARCHAR(10)

Only items in this family code qualify for this qualifying group. If not set then items from any family can qualify.

FAMILY.strFamilyCode

LINTITEMNUMBER

INT(4)

Only items with this item number qualify for this qualifying group. If not set then items with any item number can qualify.

ITEM.lintItemNumber

YSNEXCLUDE

VARCHAR(1)

If this option is checked on, all items in the qualification group are NOT allowed to be in the transaction. For example, if you want to give a discount if the customer buys 3 items in Dep 1 except item 123.

You would add to entries the qualification group - one that matches Dept1 and one that matches item 123 and you tick the exclude flag for item 123 record.

STRPRODUCTBRANDNAME

VARCHAR(30)

Brand as means of indicating which items are included in (or excluded from) a discount.

STRSEASONCODE

VARCHAR(10)   

Items in this season can be discounted.

STRYEARCODE

VARCHAR(4)

Items in this year can be discounted.

 

Primary Key: LINTDISCOUNTCODE + LINTGROUPCODE + CTRCODE

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