Home > Technical > Table Definitions > COMMISSIONDTL

COMMISSIONDTL

When calculating the commission payable to a salesperson, the system uses records from this table and the COMMISSIONLEVEL table to determine the what commission is payable and how much it is worth.

Column Type Description
STRCODE VARCHAR(10) The commission to which this record belongs.

COMMISSIONHDR.strCode

INTLEVELCODE INT The code of the level that this rule applies.

COMMISSIONLEVEL.intCode

INTCODE INT A unique number assigned by the system.
STRTRADECODE VARCHAR(10) The location to which this rule applies.

TRADUNIT.strTradeCode

STRDESCRIPTION VARCHAR(50) A description of this rule.
STRDEPTCODE VARCHAR(10) The department code to which this rule belongs. If you want it to apply to any department, the code should left empty
DEPT.strDeptCode
STRCATCODE VARCHAR(10) The category code to which this rule belongs. If you want it to apply to any category, the code should left empty
CATEGORY.strCatCode
STRGROUPCODE VARCHAR(10) The group code to which this rule belongs. If you want it to apply to any group, the code should left empty
GROUPS.strGroupCode
STRSUBGROUPCODE VARCHAR(10) The subgroup code to which this rule belongs. If you want it to apply to any subgroup, the code should left empty
SUPPLIER.strSupplierCode
STRCLASSCODE VARCHAR(10) The classification code to which this rule belongs. If you want it to apply to any classification, the code should left empty
CLASS.strClassCode
LINTITEMNUMBER INT The item number to which this rule belongs. If you want it to apply to any item, the code should left empty.

ITEM.lintItemNumber

YSNEXCLUDE VARCHAR(1) If 'T', the above fields act as an exclusive, that is calculate the totals for all items that' don't match this criteria.
DBLRATE DECIMAL(19,4) The rate of commission. This is used with STRRATETYPE to determine the actual commission payment.
STRRATETYPE VARCHAR(5) A code which indicates the way the DBLRATE field will be used to calculate the commission amount.
EXS   % of Ex Tax Sales
INCS   % of Inc Tax Sales
GP   % of Gross Profit
UNIT   Amount/Unit
 

Primary Key: STRCODE + INTLEVELCODE + INTCODE

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