Home > Technical > Table Definitions > DAILYSALESSPLIT

DAILYSALESSPLIT

Holds split transactions, based on the DAILYSALES table. Each transaction that is processed by Till Incoming service will be further processed into this table, splitting the value of transactions across the operators assigned to the transaction.

Sales types H, I, T and U are stored in this table.

The calculation for the amount each operator will be apportioned will be calculated taking into account the amount already apportioned – so that anomalies are distributed and not all applied to the last operator.

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. H=Header   I=Item    T=Tender     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).

INTTENDERCODE

INT

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

TENDER.intTenderCode

CURTENDERAMT

DECIMAL(19,4)

The amount actually paid.

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.

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

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

STRTYPE

VARCHAR(10)

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

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.

STRTAXCODE1

VARCHAR(10)

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

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

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.

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

INTTENDERDISCOUNTCODE

INT

The code of the discount 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 sales 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.

STRORDERCODE

VARCHAR(20)

The order code of the item

INTRIPID

INT

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

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.

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

INTAUTHORISEUSER

INTEGER

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

DTMPROCESSED

DATETIME

 

CURNORMALSELL

DECIMAL(19,4)

 

CUREXPECTEDREBATE

DECIMAL(19,4)

 

CTRDAILYSALES

BIGINT

Links to DAILYSALES record.

DBLAPPORTIONED

DECIMAL(19,4)

Weight of the apportioned value to this operator.

DBLORIGQTY

DECIMAL(19,4)

Original quantity sold.

 

Primary Key: CTRCODE + STRTRADECODE

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