Sales Rows

Column	Format	Unique value	Contents
Sku	varchar(13)		EAN.
ProductName	varchar(40)		Product name.
RowNo	int		Receipt row number.
PackageCount	varchar(3)		Package quantity.
SalesPrice	decimal(8,2)		Sales price.
PurhasePrice	decimal(8,2)		Purhase price.
RowTotal	decimal(8,2)		Row total price.
DiscountPercentage	decimal(8,2)		Discount percentage.
OrderedQty	varchar(8)		Quantity of sales order products.
DiscountCode	varchar(1)		Discount ID.
VatClass	varchar(1)		Vat ID; see VAT Percents .
BonusAccrual	varchar(1)
DiscountSum	decimal(8,2)		Discount sum.
ExtraDiscount	decimal(8,2)		Extra discount sum.
PackageRef	varchar(2)		Package reference.
VatPercentage	decimal(8,2)		VAT percentage.
Unit	varchar(6)		Unit.
Type	varchar(1)		Type.
Currency	varchar(1)		Currency.
Quantity	varchar(9)		Quantity.
OrderLineRef	varchar(9)		Sales rows order number.
IsTaxFree	varchar(1)		K = tax free E = tax included
SalesOrderNo	varchar(3)		Sales order row number.
RowNo2	varchar(1)		Second row number.
CampaignNo	int		Campaign ID.
RunningUniqueNo	int		Sales data row unique ID.
EventId	int	Unique combination EventId + ReceiptId + ShopId + PosId	Receipt row ID.
ReceiptId	int	Unique combination EventId + ReceiptId + ShopId + PosId	Receipt number.
CashierId	varchar(6)		Cashier ID.
ShopId	varchar(6)	Unique combination EventId + ReceiptId + ShopId + PosId	Store ID.
PosId	varchar(4)	Unique combination EventId + ReceiptId + ShopId + PosId	POS ID.
RowType	varchar(11)		Sale Void Refund Reclamation Unknown
DiscountType	varchar(12)		NoDiscount DiscountEur DiscountSum DiscountPerc N/A
Created	datetime		Time of sale.
CustomerNo	varchar(6)		Customer ID.
ReceiptUniqueId	varchar(273)		Receipt unique identifier, constructed from receipt number, POS ID, store ID and timestamp of the sale.

Giftcard sales not included

Example Data

Query

SQL

SELECT TOP 10 *
  FROM dbo.SalesRowsAll

Result

_Sku	_ProductName	_RowNo	_PackageCount	_SalesPrice	_{PurchasePrice}	_RowTotal	_{DiscountPercentage}	_OrderedQty	_DiscountCode	_VatClass	_BonusAccrual	_DiscountSum	_{ExtraDiscount}	_PackageRef	_{VatPercentage}	_Unit	_Type	_Currency	_Quantity	_OrderLineRef	_IsTaxFree	_SalesOrderNo	_RowNo2	_CampaignNo	_{RunningUniqueNo}	_EventId	_ReceiptId	_CashierId	_ShopId	_PosId	_RowType	_DiscountType	_Created	_CustomerNo	_{ReceiptUniqueId}
_1429929	_MUOVIKASSI	₁	_NULL	_0.15	_0.15	_0.15	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₉₃	₄₉₄₈₄	₁₀₈₇₇	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-02-09 09:13:42.000}	₀	_{10877-19-1-2023-02-09}
₁₁₀₉₁₈	_{GABARDIINIHAME 40}	₂	_NULL	_45.24	_20.18	_45.25	_0.00	₀	_K	₀	₁	_0.00	_-0.01	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₉₄	₄₉₄₈₅	₁₀₈₇₇	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-02-09 09:13:42.000}	₀	_{10877-19-1-2023-02-09}
_1359365	_{FARKKU-CAPRIT 42}	₁	_NULL	_84.00	_41.48	_84.00	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₈₉	₄₉₄₈₀	₁₀₈₇₆	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-02-08 15:39:11.000}	₀	_{10876-19-1-2023-02-08}
_1174108	_{FARKKU-CAPRIT L}	₁	_NULL	_58.00	_22.09	_58.00	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₈₇	₄₉₄₇₈	₁₀₈₇₅	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-02-08 15:38:43.000}	₀	_{10875-19-1-2023-02-08}
_1424881	_{HAL ROMEO DMAXX PNT 38}	₁	_NULL	_99.00	_81.74	_99.00	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₈₂	₄₉₄₇₃	₁₀₈₇₄	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-02-08 14:52:52.000}	₀	_{10874-19-1-2023-02-08}
_1426047	_{SQ HALF ZIP FLEECE PA 38}	₂	_NULL	_79.00	_47.15	_79.00	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₈₃	₄₉₄₇₄	₁₀₈₇₄	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-02-08 14:52:52.000}	₀	_{10874-19-1-2023-02-08}
_1429938	_{JOULUSUKAT 38}	₁	_NULL	_20.00	_11.30	_20.00	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₇₃	₄₉₄₆₄	₁₀₈₇₃	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-01-25 13:17:35.000}	₀	_{10873-19-1-2023-01-25}
_1429929	_MUOVIKASSI	₂	_NULL	_0.15	_0.15	_0.15	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₇₄	₄₉₄₆₅	₁₀₈₇₃	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-01-25 13:17:35.000}	₀	_{10873-19-1-2023-01-25}
_1330050	_{PAISLEY-PUSERO 42}	₁	_NULL	_76.00	_34.10	_76.00	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₆₇	₄₉₄₅₈	₁₀₈₇₂	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-01-25 11:10:44.000}	₀	_{10872-19-1-2023-01-25}
₄₇₄₄₃₆	_{V-AUKKOTRIKOO L}	₂	_NULL	_33.30	_15.80	_33.30	_0.00	₀	_NULL	₀	₁	_0.00	_0.00	₀	_24.00	_NULL	_@	_E	₁	_NULL	_E	_NULL	₀	₀	₄₇₆₈	₄₉₄₅₉	₁₀₈₇₂	₁	₁	₁₉	_Sale	_NoDiscount	_{2023-01-25 11:10:44.000}	₀	_{10872-19-1-2023-01-25}