DAILYSALES

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. In a standard sales transaction

H=Header   I=Item sold    T=Tender taken    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 customer associated with this transaction, if any.
CUSTOMER.lintCustomerNum

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

TENDER.intTenderCode

The amount actually paid.

The number of customers recorded on the sale. This will usually be 1. It will be zero for a No Sale.

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.

The reason for a refund/return.
REASONS.intCode

No longer used.

The time the record was created. The difference between this and DTMSALEDATETIME can be used to measure the responsiveness of the system.

The table number from where the sale was made.

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'.

No longer used. See STATBUCKET

The normal sell price for one item. If using GST Tax System, this will include the GST.

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).

No longer used.

No longer used.

The type of transaction this record was involved in: SALE, RETURN, and so on.

Points to the delivery address for an item. If zero then no delivery required.
DELIVERY.ctrCode

The date the warranty will expire or for SUV the used date for committed vouchers..

If the sale was for a customer, then this number is the contact within the customer.
CUSTCONTACT.ctrCode

The gift certificate/ credit note number used.

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.

No longer used.

A general comment. It can be used to store serial numbers for item or as a campaign code in SUV.

The customer's reference number for this sale transaction.

No longer used.

The expected rebate for this item.

If an account payment is made, or a sale is placed on account, this is the type of account used.
ACLEGDER.strLedgerCode

If using US Tax System then this is the tax group that indicates the tax rate payable on purchases. A tax group holds 1 or more tax codes so that the system can support multiple tax codes being applied to an 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 tax group that indicates the tax rate payable on sales.

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 tax group that indicates the tax rate payable.

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.

No longer used.

No longer used.

No longer used.

The number of points given to this item for loyalty purposes.

The date a tax invoice was produced for this transaction.

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 offer discount.

The promotion ID 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 tender 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.

No longer used.

No longer used.

No longer used. See STRAPN.

The order code of the item

The tax number of the customer. Used for Taiwan tax receipts.

The preprint receipt number calculated by the system. Used for Taiwan tax receipts.

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

The authorisation number for an EFTPOS payment or for SUV the response message returned from the voucher service.

The customer's card number scanned for this transaction. It should link to CUSTCARDS.strCardNum. However if the POS was offline, we still accept the number scanned even though it may not actually exist. For SUV the voucher code.

The card number for an EFTPOS transaction or for SUV the transaction reference returned from the voucher service.

The barcode scanned to sell this item.

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.

The receipt number (excluding the prefix number information) used in that transaction. This field can be used by Linea Informatica to say what reference id have been recorded in the relevant outlet.