Home > Technical > Table Definitions > SALESADJDETAIL

SALESADJDETAIL

Sales adjustment are used to adjust sales for non-scanning items, and so on. An adjustment consist of one SALESADJHEADER and one or more SALESADJDETAIL.An adjustment record is created for each item that needs to be adjusted.

Column Type Description

CTRCODE

INT(4)

A unique number assigned by the system.

LINTSALESADJCODE

INT(4)

The adjustment header this detail is for

link.gif (858 bytes) SALESADJHEADER.lintSalesAdjCode

DTMSALEDATETIME

DATETIME(8)

The date the item was sold.

LINTITEMNUMBER

INT(4)

The item which was sold.

link.gif (858 bytes) ITEM.lintItemNumber

DBLQTYSOLD

DECIMAL9(19,4)

The number of units sold.

CURSELL

DECIMAL9(19,4)

The unit sell price of the item.

STRDESCRIPTION

VARCHAR(100)

The description of the item. This is set by the system.

CURCOGS

DECIMAL9(19,4)

The amount of tax in this transaction.

CURTAXAMT

DECIMAL9(19,4)

 

 

Primary Key: CTRCODE

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