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