Home > Technical > Table Definitions > ROUNDRULEUSAGE

ROUNDRULEUSAGE

This table controls which rounding rules are used by which types of products.

Column Type Description
CTRCODE INT Unique code assigned by the system to identify the record.
STRTRADECODE VARCHAR(10) Trading unit this rule applies to.
TRADUNIT.strTradeCode
STRDEPTCODE VARCHAR(10) The department to which this rule applies. This is not required if the rule applies to all departments.
DEPT.strDeptCode
STRCATCODE VARCHAR(10) The category to which this rule applies. This is not required if the rule applies to all categories within the department.
CATEGORY.strCatCode
STRGROUPCODE VARCHAR(10) The group to which this rule applies. This is not required if the charge applies to all groups within the category.
GROUPS.strGroupCode
STRSUBGROUPCODE VARCHAR(10) The subgroup to which this rule applies. This is not required if the rule applies to all subgroups within the group.
SUBGROUP.strSubGroupCode
LINTROUNDRULE INT The code of the rounding rule to be used by these items.
ROUNDRULEHDR.ctrCode
DTMSTART DATETIME Date the rounding rule takes effect. If left empty then effective immediately.
DTMEND DATETIME Date the rounding rule expires. If left empty then never expires.
STRCLASSCODE VARCHAR(10) The classification to which this rule applies. This is not required if the rule applies to all classifications.

CLASS.strClassCode

 

Primary Key: CTRCODE

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