Home > Technical > Table Definitions > DELIVERY

DELIVERY

This table records details about delivery addresses for items that have been sold.

Column

Type

Description

INTORDERCODE

BIGINT

The transaction to which this delivery is being linked.

If transaction is completed then link to:

DAILYSALES.intTransNum

If transaction is still pending then:

CUSTORDERHDR.ctrCode

CTRCODE

INT

A unique number assigned by the system

STRADDR1

VARCHAR(50)

The first line of the delivery address.

STRADDR2

VARCHAR(50)

The second line of the delivery address.

STRCITY

VARCHAR(50)

The city/suburb of the delivery address.

STRSTATE

VARCHAR(20)

The state of the delivery address.

STRPOSTCODE

VARCHAR(15)

The postcode of the delivery address.

DTMWHEN

DATE

Date delivery is required.

STRCOMMENT

VARCHAR(255)

General comments about delivery, for example beware of dog.

STRTIME

VARCHAR(20)

The time delivery is required. This is a text field to allow times to be entered like 'AFTER 3.00PM'.

YSNDELIVERED

VARCHAR(1)

'T' indicates that this delivery address has already been printed. 'F' indicates not printed.

STRPRINTBATCH

VARCHAR(38)

 

 

Primary Key: INTORDERCODE + CTRCODE

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