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