Home > Technical > Table Definitions > 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. | ||||||
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.
|
||||||
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) |