Home > Technical > Table Definitions > COMMISSIONLEVEL

COMMISSIONLEVEL

This stores the level information for a commission rule (stored in COMMISSIONHDR). A commission rule can have multiple levels. The system looks through each level and works out which one is applicable. It uses the COMMISSIONDTL records to determine which items are to be included in the base calculation. If the base calculation passes the level test, the commission can be calculated and recorded for the salesperson.

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

COMMISSIONHDR.strCode

INTCODE INT A unique number assigned by the system.
DTMEFFECTIVE DATETIME The date the level will apply. If it applies immediately, it can be left empty.
DTMEXPIRY DATETIME The date the level will expire. If it never expires, it can be left empty.
STRTYPE VARCHAR(10) Indicates the numbers on which the commission will be calculated.
EXS   Ex Tax Sales
INCS   Inc Tax Sales
GP   Gross Profit

CURFROMLEVEL

DECIMAL(19,4)

If the value of the number determined by STRTYPE is less than this number, the level does not pass.

CURTOLEVEL

DECIMAL(19,4)

If the value of the number determined by STRTYPE is greater than this number, the level does not pass.

 

Primary Key: STRCODE + INTCODE

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