DAILYSALESSPLIT

Description

The till which made this sale.
TILL.strTillCode

The number assigned by the till to this sale. This cannot be considered a unique number. It is basically unique for the POS. However, its value is normally taken from a setting in DYNAMIC.INI and can be reset. This means you could have the same sale id for different transactions on the same POS. See INTORDERCODE and INTTRANSNUM

The type of sale. H=Header   I=Item    T=Tender     U=US Taxes..... See Daily Sales for a description of the codes used.

The location where the till resides.
TRADUNIT.strTradeCode 

The operator who made the sale.
USERCODE.intUserCode

The date and time the sale was made. I you are tracking individual times, the date/time could be different for each record within a transaction.

The hour the sale was made. Stored as 0-23. Converted from DTMSALEDATETIME

The quarter hour in which the sale was made. Stored as 0, 15, 30 or 45. Converted from DTMSALEDATETIME

The item which was sold. 0 where strSaleType is H or T.
ITEM.lintItemNumber

A unique number assigned by the system.

If STRSALETYPE=‘H’, total value of sale.

If STRSALETYPE=’I’, sale value of item. This is a line value not a unit value. If using GST Tax System then this amount will NOT include the GST which was charged. In this case, Revenue = curSales + curTaxAmt1+curTaxAmt2+curTaxAmt3

If STRSALETYPE=‘H’, total unique items sold (not the total items sold). If STRSALETYPE=’I’, number of this item in the sale.

If STRSALETYPE=’I’, cost of items sold. This is a line value (not unit).

The tender used for a payment, refund, paid in/out.

TENDER.intTenderCode

The amount actually paid.

The trading date the sale was made on. If a venue trades after midnight, DTMSALEDATETIME 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.

An item can have up to five sell prices. This is a number from 1 to 5 that indicates which sell price was used. If the user modified the sell price, this will be 'P'.

The item discount for a single item. (Stored as a negative number). If this is the 'H' record, this will be the total items discount. This is a unit value.

The key of the discount record used for the item discount.
DISCHDR.ctrCode

The key of the discount record used for the offer discount.
DISCHDR.ctrCode

Usually the same as LINTITEMNUMBER unless the item was linked to a parent item (as for a set meal item).

The type of transaction this record was involved in: SALE, RETURN, POINTS, and so on. See Daily Sales for further information.

A unique number assigned by the system. All records within the same transaction will have this same number. It is used instead of INTSALEID because INTSALEID can actually be repeated.

If using US Tax System then this is the first sales tax code charged on the item. If using GST then this is the CESS tax code charged on the item.
TAX.strTaxCode

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

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

The amount of tax charged for the item based on strTaxCode1. If this is the 'H' record, this will be the total of curTaxAmt1 for all items in the transaction. This is a line value, not unit.

The amount of tax charged for the item based on strTaxCode2. If this is the 'H' record, this will be the total of curTaxAmt2 for all items in the transaction. This is a line value, not unit.

The amount of tax charged for the item based on strTaxCode3. If this is the 'H' record, this will be the total of curTaxAmt3 for all items in the transaction. This is a line value, not unit.

The sell price at Price Level 1 for this item. If using GST Tax System, this will include the GST.

The code of the foreign currency used on this sale, if any.
CURRENCYCODE.strCurrencyCode

The exchange rate. Only required if STRCURRENCYCODE is entered.

The actual amount tendered using the foreign currency (CURTENDERAMT contains the exchanged value). Only required if STRCURRENCYCODE is entered.

The amount of the sales discount for a single unit. Stored as a negative number. If this is the 'H' record, this will be the total sales discount.

The code of the discount used to give the sale discount.
DISCHDR.ctrCode

The amount of the offer discount for a single unit. Stored as a negative number. If this is the 'H' record, this will be the total sales discount.

The code of the discount used to give the tender  discount.
DISCHDR.ctrCode

The amount of the tender discount for a single unit. Stored as a negative number. If this is the 'H' record, this will be the total sales discount.

A unique number for a transaction. For a layby where there will be multiple payments, each transaction recorded in DAILYSALES will have a different INTORDERCODE, potentially a different INTSALEID (depending on POS used) but the same intTransNum. This allows allows actions against the one transaction to be tracked.

The order code of the item

The trip code on which the sale was made. Used for Stena.

The original selling price of the item when it was added to the transaction. If the sell price is manually changed, this field will still contain the original sell price.

Original quantity sold.