Home > Technical > Table Definitions > BOORDERDTL

BOORDERDTL

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.

Column

Type

Description

LINTORDERCODE

INT

The code of the back office order to which the item belongs.

BOORDERHDR.lintOrderCode

CTRCODE

INT

A unique number assigned by the system.

LINTITEMNUMBER

INT

The item number being ordered.

ITEM.lintItemNumber

STRDESCRIPTION

VARCHAR(100)

Description of the item.

CURSELLPRICE

DECIMAL(19,4)

The sell price of the item.

DBLQUANTITY

DECIMAL(19,4)

Quantity being sold.

CUREXTENDEDSALE

DECIMAL(19,4)

The total sales value of the item.

 

Primary Key: LINTORDERCODE + CTRCODE

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