Home > Technical > Table Definitions > SALESFREIGHTRATE

SALESFREIGHTRATE

Contains a record for each valid sales freight code. Sales freight is used as part of the Wholesaling system. There can be multiple records for a single SALESFREIGHT record.

Column Type Description

STRFREIGHTCODE

VARCHAR(10)

Freight code these rates apply to.

link.gif (858 bytes) SALESFREIGHT.strFreightCode

STRTRADECODE

VARCHAR(10)

Trading unit this freight rate applies to.

link.gif (858 bytes) TRADUNIT.strTradeCode

STRDEPTCODE

VARCHAR(10)

Department this rate applies to. This is not required if the rate applies to all departments within the location.

link.gif (858 bytes) DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Category this rate applies to. This is not required if the rate applies to all categories within the department.

link.gif (858 bytes) CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Group this rate applies to. This is not required if the rate applies to all groups within the category.

link.gif (858 bytes) GROUPS.strGroupCode

CURRATE

DECIMAL9(19,4)

Rate used in conjunction with strRateType below to calculate the freight rate.

STRRATETYPE

VARCHAR(10)

2=$/Carton3=$/kg

CTRCODE

INT(4)

A unique number assigned by the system.

 

Primary Key: STRFREIGHTCODE + CTRCODE

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