Home > Technical > Table Definitions > 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. |
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 |
|
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. |
INTOPERATORID |
INT |
The operator who made the sale. |
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 |
INT |
The item which was sold. 0 where strSaleType is H or T. |
|
BIGINT |
A unique number assigned by the system. |
|
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. |
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. |
INTOFFERCODE |
INT |
The key of the discount record used for the offer discount. |
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. |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
VARCHAR(5) |
The code of the foreign currency used on this sale, if any. |
|
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. |
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. |
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. |
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. |
INTSALEDISCREASON |
INTEGER |
The reason for giving a sale discount. |
INTCHGPRICEREASON |
INTEGER |
Records the reason for doing a price change. |
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) |