Home > Technical > Table Definitions > BOORDERHDR

BOORDERHDR

Back office orders are similar to customer orders except they are done at the back office. BOORDERHDR stores the header information while BOORDERDTL stores the item information. Once the order has been accepted, the system will create CUSTORDERHDR, CUSTORDERITEM, etc records so that the order goes through the correct channels like POS customer orders do.

Column

Type

Description

LINTORDERCODE

INT

A unique number assigned by the system.

LINTCUSTOMERNUM

INT

The number of the customer to which this order belongs.

CUSTOMER.lintCustomerNum

INTPICKUPTYPE

INT

Indicates whether the order is to be a delivery or a pickup.

 0=Deliver/1=Pickup

STRTRADECODE

VARCHAR(10)

The location that will either deliver the items or from where the items will be picked up.

TRADUNIT.strTradeCode

STRADDR1

VARCHAR(50)

The first line of the delivery address.

STRADDR2

VARCHAR(50)

The second line of the delivery address.

STRCITY

VARCHAR(50)

The suburb/city of the delivery address.

STRSTATE

VARCHAR(20)

The state of the delivery address.

STRPOSTCODE

VARCHAR(15)

The postcode of the delivery address.

DTMDELIVERYDATE

DATETIME

The delivery/pickup date.

STRDELIVERYTIME

VARCHAR(20)

The delivery/pickup time.

STRAUTHORISEDBY

VARCHAR(20)

The user who authorised this transaction to be accepted.

STRPHONE

VARCHAR(20)

The phone number of the customer.

STRFAX

VARCHAR(20)

The fax number of the customer.

MEMCOMMENTS

TEXT

General comments about the order.

STRSTATUS

VARCHAR(10)

Status of the order - New/Accepted.

DTMWHEN

DATETIME

When the transaction was created.

STRWHO

VARCHAR(20)

The user who created the transaction.

INTCHANGEFLAG

INT

A flag indicating that the record has been changed.

INTNEWFLAG

INT

A flag indicating that the record is new.

STRWAREHOUSE

VARCHAR(10)   

Not currently used. Added for possible future mod.

 

Primary Key: LINTORDERCODE

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