Home > Technical > Table Definitions > DELIVERYCHARGEDET

DELIVERYCHARGEDET

Delivery charges are used when calculating the delivery charge for an item. For each 'delivery charge', there is a header record (DELIVERYCHARGE) and multiple detail records containing the actual charge details (DELIVERYCHARGEDET).

Column

Type

Description

CTRCODE

INTEGER(4)

A unique number assigned by the system.

STRDELIVERYCODE

VARCHAR(10)

The delivery charge that this detail belongs to.

DELIVERYCHARGE.strCode

STRTRADECODE

VARCHAR(10)

The location to which this charge belongs.

TRADUNIT.strTradeCode

STRCATEGORY1

VARCHAR(10)

The type of customer to which this charge applies. If left empty, no check is done.

CUSTOMERCATEGORY.strCode

STRAREA

VARCHAR(10)

The delivery area to which this charge belongs.

DELIVERYAREATYPE.strCode

DBLQTYLIMIT

DECIMAL(9)19,4

The quantity to be sold before this charge is used. You need to enter all the possibilities here. For example, if you charge $10 per carton, you would need records set up for each carton and the TOTAL amount to be charged. If we charged $10 for the first two cartons and then $5 for the remaining cartons, you would need records as follows: 12 = $10, 24 = $20, 36 = $25, 48 = $30, and so on.

CURCHARGE

DECIMAL(9)19,4

The amount to be charged for this quantity.

CURIGNOREIFSALESEXCEED

DECIMAL(9)19,4

This charge will not be used if the total sale value exceeds this amount. Usually 999999.

 

Primary Key: CTRCODE

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