Home > Technical > Table Definitions > 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. |
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. |
STRTRADECODE |
VARCHAR(10) |
The location where the till resides. |
LINTITEMNUMBER |
INT(4) |
The item which was sold. |
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. |
LINTMEMBERID |
INT(4) |
The customer who made this sale, if any. |
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. |
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. |
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. |
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) |