Home > Technical > Table Definitions > NONREVENUESALES

NONREVENUESALES

When items such as gift certificates are sold, they are treated as non-revenue. Such items are identified in System Settings. They are stored in DAILYSALES with curSales of zero. This table records the full details of these items including what they were sold for.

Column

Type

Description

INTORDERCODE

BIGINIT(8)

Links to the transaction in which the non-revenue item was included.

DAILYSALES.intOrderCode

CTRCODE

BIGINIT(8)

A unique number assigned by the system.

DTMSALEDATETIME

DATETIME(8)

The date and time the sale was made.

INTOPERATORID

INT(4)

The operator who made the sale.

INTSALEID

INT(4)

The number assigned by the till to this sale.

STRTILLCODE

VARCHAR(10)

The till which made this sale.

TILL.strTillCode

STRTRADECODE

VARCHAR(10)

The location where the till resides.

TRADUNIT.strTradeCode

LINTITEMNUMBER

INT(4)

The item which was sold.

ITEM.lintItemNumber

DBLQTYSOLD

DECIMAL(9)19,4

The quantity of the item sold.

CURSALES

DECIMAL(9)19,4

The sales value of the item. This will be set to zero in the corresponding DAILYSALE record.

DTMTRADEDATE

DATETIME(8)

The trading date the sale was made on. If a venue trades after midnight, dtmSalesDateTime will be set to the actual date, while dtmTradeDate will be set to the day before. This ensures all sales within a trading period and recorded against the same date.

LINTLNKCODE

BIGINIT(8)

Links back to the specific DAILYSALES record which this item came from.

DAILYSALES.ctrCode

LINTMEMBERID

INT(4)

The customer who made this sale, if any.

CUSTOMER.lintCustomerNum

LINTGIFTNUM

VARCHAR(10)

The number of the gift certificate or credit note that was associated with this item. Most non-revenue items will be gift certificates or credit notes. So when they are sold they will get a number associated with them.

POSCREDIT.ctrCode

STRTAXCODE1

VARCHAR(10)

If using US Tax System then this is the first sales tax code charged on the item. Not used for other tax systems.

TAX.strTaxCode

STRTAXCODE2

VARCHAR(10)

If using US Tax System then this is the second sales tax code charged on the item. If using GST then this is the sales tax code charged on the item.

TAX.strTaxCode

STRTAXCODE3

VARCHAR(10)

If using US Tax System then this is the third sales tax code charged on the item. Not used for other tax systems.

CURTAXAMT1

DECIMAL(9)19,4

The amount of tax charged for the item based on strTaxCode1.

CURTAXAMT2

DECIMAL(9)19,4

The amount of tax charged for the item based on strTaxCode2.

CURTAXAMT3

DECIMAL(9)19,4

The amount of tax charged for the item based on strTaxCode3.

 

Primary Key: INTORDERCODE + CTRCODE

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