Home > Technical > Table Definitions > 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. |
STRTRADECODE |
VARCHAR(10) |
Trading unit this freight rate applies to. |
STRDEPTCODE |
VARCHAR(10) |
Department this rate applies to. This is not required if the rate applies to all departments within the location. |
STRCATCODE |
VARCHAR(10) |
Category this rate applies to. This is not required if the rate applies to all categories within the department. |
STRGROUPCODE |
VARCHAR(10) |
Group this rate applies to. This is not required if the rate applies to all groups within the category. |
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) |