Home > Technical > Table Definitions > SUPPLIERFEES
These records store the service fees and ullage charges for a supplier.
Column | Type | Description |
STRSUPPLIERCODE | VARCHAR(10) | The code of
the supplier, this trading term applies to.![]() |
STRCHRGTYPE | VARCHAR(15) | Indicates the type of charge. Service Fee/Ullage. |
STRDEPTCODE | VARCHAR(10) | The
department to which this charge applies. This is not required if
the charge applies to all departments.![]() |
STRCATCODE | VARCHAR(10) | The
category to which this charge applies. This is not required if the
charge applies to all categories within the department.![]() |
STRGROUPCODE | VARCHAR(10) | The group
to which this charge applies. This is not required if the charge
applies to all groups within the category.![]() |
DBLRATE | DECIMAL(19,4) | The rate of fees used in conjunction with strRateType below to calculate the charge. |
CTRCODE | INT | Unique code assigned by the system to identify the record. |
STRRATETYPE | VARCHAR(10) | The method used to calculate the fee.1=% of Cost2=$/Carton |
STRCLASSCODE | VARCHAR(10) | The
classification of goods to which this charge applies. This is not
required if the charge applies to all classifications.![]() |
STRSUBGROUPCODE | VARCHAR(10) | The
subgroup this charge is applicable to. This is not required if the
charge applies to all subgroups within the group.![]() |
STRTRADECODE | VARCHAR(10) | Trading
unit this charge applies to.![]() |
STRCURRENCYCODE | VARCHAR(5) | The currency code this supplier uses for their
costs.![]() |
DTMSTART | DATETIME | The date the fee becomes effective. If left empty then always effective. |
DTMEND | DATETIME | The date the fee expires. If left empty then never expires. |
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |