Home > Technical > Table Definitions > FREIGHTRATE

FREIGHTRATE

Contains a record for each valid freight code. Freight is used when calculating landed cost. There can be multiple records for a single FREIGHT record.

Column Type Description
STRFREIGHTCODE VARCHAR(10) Freight code these rates apply to.
FREIGHT.strFreightCode
STRTRADECODE VARCHAR(15) Trading unit this freight rate applies to.
TRADUNIT.strTradeCode
STRDEPTCODE VARCHAR(10) Department this rate applies to. This is not required if the rate applies to all departments within the location.
DEPT.strDeptCode
STRCATCODE VARCHAR(10) Category this rate applies to. This is not required if the rate applies to all categories within the department.
CATEGORY.strCatCode
STRGROUPCODE VARCHAR(10) Group this rate applies to. This is not required if the rate applies to all groups within the category.
GROUPS.strGroupCode
CURRATE DECIMAL(19,6) Rate used in conjunction with strRateType below to calculate the freight rate.
STRRATETYPE VARCHAR(10) 2=$/Carton3=$/kg
CTRCODE INT A unique number assigned by the system.
STRSUBGROUPCODE VARCHAR(10) The subgroup this freight rate is applicable to. This is not required if the rate applies to all subgroups within the group.
SUBGROUP.strSubGroupCode
STRCURRENCYCODE VARCHAR(5) The currency code for which this freight is specified.

CURRENCY.strCurrencyCode

DTMSTART DATETIME The date the freight rate becomes effective. If left empty then always effective.
DTMEND DATETIME The date the freight rate expires. If left empty then never expires
STRCLASSCODE VARCHAR(10) The classification this freight rate is applicable to. This is not required if the rate applies to all classifications.
CLASS.strClassCode
 

Primary Key: STRFREIGHTCODE + CTRCODE

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