Home > Technical > Table Definitions > DELIVERYAREA

DELIVERYAREA

Delivery areas are used when calculating the delivery charge for an item. For each 'delivery area', there is a header record (DELIVERYAREATYPE) and multiple detail records containing postcode information (DELIVERYAREA).

The delivery charges themselves are stored in DELIVERYCHARGE and DELIVERYCHARGEDET.

Column

Type

Description

STRAREACODE

VARCHAR(10)

The area this detail belongs to.

DELIVERYAREATYPE.strCode

STRPOSTCODE

VARCHAR(15)

The postcode that belongs in this area.

 

Primary Key: STRAREACODE + STRPOSTCODE

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