Home > Technical > Table Definitions > SUPPLIERFEES

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.
SUPPLIER.strSupplierCode
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.
DEPT.strDeptCode
STRCATCODE VARCHAR(10) The category to which this charge applies. This is not required if the charge applies to all categories within the department.
CATEGORY.strCatCode
STRGROUPCODE VARCHAR(10) The group to which this charge applies. This is not required if the charge applies to all groups within the category.
GROUPS.strGroupCode
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.
CLASS.strClassCode
STRSUBGROUPCODE VARCHAR(10) The subgroup this charge is applicable to. This is not required if the charge applies to all subgroups within the group.
SUBGROUP.strSubGroupCode
STRTRADECODE VARCHAR(10) Trading unit this charge applies to.
TRADUNIT.strTradeCode
STRCURRENCYCODE VARCHAR(5) The currency code this supplier uses for their costs.
CURRENCYCODE.strCurrencyCode
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)