Home > Technical > Table Definitions > DAILYSALES

DAILYSALES

Each sale that comes from a POS will generate records into INCOMINGTRANS. These records are processed by Incoming Transactions Handler which will translate the data into DAILYSALES. These records are then used to perform X/Z Reads, Customer Flows, and so on. There will be one record for the sale header, one for each item sold within the sale, and one or more for each tender amount (Cash, Cheque, and so on).

See Daily Sales and Sales From POS To Database for further information.

Column

Type

Description

STRTILLCODE

VARCHAR(10)

The till which made this sale.
TILL.strTillCode

INTSALEID

INT

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

STRSALETYPE

VARCHAR(1)

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.

STRTRADECODE

VARCHAR(10)

The location where the till resides.
TRADUNIT.strTradeCode 

INTOPERATORID

INT

The operator who made the sale.
USERCODE.intUserCode

DTMSALEDATETIME

DATETIME

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.

INTHOUR

INT

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

INTMINUTE

INT

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

LINTITEMNUMBER

INT

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

CTRCODE

BIGINT

A unique number assigned by the system.

CURSALES

DECIMAL(19,4)

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

DBLQTYSOLD

DECIMAL(19,4)

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

CURCOGS

DECIMAL(19,4)

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

LINTMEMBERID

INT

The customer associated with this transaction, if any.
CUSTOMER.lintCustomerNum

INTTENDERCODE

INT

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

TENDER.intTenderCode

CURTENDERAMT

DECIMAL(19,4)

The amount actually paid.

LINTCUSTOMERCOUNT

INT

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

DTMTRADEDATE

DATETIME

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.

STRREASON

VARCHAR(10)

The reason for a refund/return.
REASONS.intCode

CURINVOICECOGS

DECIMAL(19,4)

No longer used.

DTMPROCESSED

DATETIME

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

STRREFERENCE

VARCHAR(20)

The table number from where the sale was made.

STRPRICELEVEL

VARCHAR(1)

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

YSNSTATSPROCESSED

VARCHAR(1)

No longer used. See STATBUCKET

CURNORMALSELL

DECIMAL(19,4)

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

CURDISCOUNT

DECIMAL(19,4)

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.

INTDISCOUNTCODE

INT

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

INTOFFERCODE

INT

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

LINTPARENTITEM

INT

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

DBLDISCOUNTPER

DECIMAL(19,4)

No longer used.

CURCOMMLEVEL

DECIMAL(19,4)

No longer used.

STRTYPE

VARCHAR(10)

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

ACTIVATE

Givex gift card activation.

BALANCE

Givex balance inquiry.

BTILL ADJ

Back office till adjust (income and expenses).

CARD

 

CLAYBY

Completed lay by.

CORDER

The order is complete that is all items have been paid for and released to the customer.

CQUOTE

Completed quote.

EXCHANGE

Exchange transaction.

LAYBY

Lay by transaction.

LOGIN

Log in.

LOGOUT

When selected in Till Maintenance.

MANADJ

Givex manual adjustment.

NOSALE

No sale transaction.

ORDER

Items have been entered. There may also have been partial payments but there is an outstanding balance due.

PORDER

Items have been entered and fully paid for but the goods have not been released to the customer.

PRINTBILL

Print bill.

QUOTE

Quote transaction.

REFUND

Refund.

REPRINT

Reprinted transaction.

RETURN

Return.

SALE

Sales transaction.

SODFLOAT

Start of day float.

STOCK

Stock adjustment at the POS.

STSHIFT

Start shift.

TILL ADJ

Till adjust.

TIP

Added after a EFT payment in POS.

TOPUP

Givex gift card top up.

TRAINOFF

Training off.

TRAINON

Training on.

XACTIVATE

Cancelled Givex gift card activation.

XLAYBY

Cancelled lay by.

XORDER

Cancelled order.

XQUOTE

Cancelled quote.

XREAD

X read.

XSALE

Cancelled sale.

XTOPUP

Cancelled Givex top up.

ZREAD

Z read.

LINTDELIVERYADDRESS

INT

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

DTMWARRANTY

DATETIME

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

LINTCONTACTNUM

INT

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

LINTGIFTNUM

VARCHAR(10)

The gift certificate/ credit note number used.

INTORDERCODE

BIGINT

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.

CURSALESTAX

DECIMAL(19,4)

No longer used.

STRCOMMENT

VARCHAR(100)

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

STRPONUMBER

VARCHAR(50)

The customer's reference number for this sale transaction.

LINTFIFOCODE

INT

No longer used.

CUREXPECTEDREBATE

DECIMAL(19,4)

The expected rebate for this item.

STRLEDGERCODE

VARCHAR(10)

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

STRTAXCODE1

VARCHAR(10)

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

STRTAXCODE2

VARCHAR(10)

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

STRTAXCODE3

VARCHAR(10)

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

CURTAXAMT1

DECIMAL(19,4)

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.

CURTAXAMT2

DECIMAL(19,4)

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.

CURTAXAMT3

DECIMAL(19,4)

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.

CURSELLPRICE1

DECIMAL(19,4)

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

YSNCLAIMSUPPLIER

VARCHAR(1)

No longer used.

YSNCLAIMMANUFACTURER

VARCHAR(1)

No longer used.

YSNCLAIMHEADOFFICE

VARCHAR(1)

No longer used.

LINTPOINTS

DECIMAL(19,4)

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

DTMTAXINVOICE

DATETIME

The date a tax invoice was produced for this transaction.

STRCURRENCYCODE

VARCHAR(5)

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

DBLEXCHANGERATE

DECIMAL(19,4)

The exchange rate. Only required if STRCURRENCYCODE is entered.

CURFOREIGNAMT

DECIMAL(19,4)

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

CURSALESDISCOUNT

DECIMAL(19,4)

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.

INTSALESDISCOUNTCODE

INT

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

CUROFFERDISCOUNT

DECIMAL(19,4)

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.

INTTENDERDISCOUNTCODE

INT

The promotion ID used to give the tender discount.
DISCHDR.ctrCode

CURTENDERDISCOUNT

DECIMAL(19,4)

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.

INTTRANSNUM

BIGINT

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.

INTORIGSALEID

INT

No longer used.

INTORIGTAXID

INT

No longer used.

DBLAPN

DECIMAL(19,4)

No longer used. See STRAPN.

STRORDERCODE

VARCHAR(20)

The order code of the item

STRCUSTTAXNUM

VARCHAR(20)

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

STRPREPRINTSALEID

VARCHAR(20)

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

INTRIPID

INT

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

STRAUTHORISATION

VARCHAR(30)

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

STRCARDNUM

VARCHAR(38)

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.

STRCREDITCARDNUM

VARCHAR(20)

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

STRAPN

VARCHAR(20)

The barcode scanned to sell this item.

CURORIGSELL

DECIMAL(19,4)

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.

STRROUTECODE

VARCHAR(10)

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

YSNASKDELIVERYITEM

VARCHAR(1)

If 'T' POS will ask how the item is to be delivered.

INTDELIVERYSOURCE

INTEGER

Whether from store or warehouse or direct from supplier.

INTSHIFTCODE

INTEGER

The shift in which this transaction was completed.

SHIFTCODE.intCode

INTSALESMETHOD

INTEGER

The sales method used for this item.

SALESMETHOD.intCode

STRCREDITCARDNUM

VARCHAR(30)

The credit card number used on a Mosaic EFT transaction.

INTITEMDISCREASON

INTEGER

The reason for giving an item discount.  

REASONS.intCode

INTSALEDISCREASON

INTEGER

The reason for giving a sale discount.

REASONS.intCode

INTCHGPRICEREASON

INTEGER

Records the reason for doing a price change.

REASONS.intCode

STRGIFTNUMTO

VARCHAR(10)

The 'To' Gift certificate number, if a range of numbers was entered.

CURGOVERNMENTREBATE

DECIMAL(19,4)

The total value of the government rebate that will be given on this item. Mainly used for script items.

INTAUTHORISEUSER

INTEGER

The user code of the user who authorised a task, for example cancel sale, sale discount, and so on, on the transaction.

YSNSALESTAXAMENDED

VARCHAR(1)

Has the sales tax been amended for this item?

STRORIGTAXCODE1

VARCHAR(10)

Original tax group 1 code for this item (not currently used).

STRORIGTAXCODE2

VARCHAR(10)

Original sales tax group for this item.

STRORIGTAXCODE3

VARCHAR(10)

Original tax group 3 code for this item (not currently used).

INTFISCALID

INTEGER

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.

 

Primary Key: CTRCODE + STRTRADECODE

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