|
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 |
|
Receipt row ID. |
|
ReceiptId |
int |
|
Receipt number. |
|
CashierId |
varchar(6) |
|
Cashier ID. |
|
ShopId |
varchar(6) |
|
Store ID. |
|
PosId |
varchar(4) |
|
POS ID. |
|
RowType |
varchar(11) |
|
|
|
DiscountType |
varchar(12) |
|
|
|
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
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 |
1 |
NULL |
0.15 |
0.15 |
0.15 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4793 |
49484 |
10877 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-02-09 09:13:42.000 |
0 |
10877-19-1-2023-02-09 |
|
110918 |
GABARDIINIHAME 40 |
2 |
NULL |
45.24 |
20.18 |
45.25 |
0.00 |
0 |
K |
0 |
1 |
0.00 |
-0.01 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4794 |
49485 |
10877 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-02-09 09:13:42.000 |
0 |
10877-19-1-2023-02-09 |
|
1359365 |
FARKKU-CAPRIT 42 |
1 |
NULL |
84.00 |
41.48 |
84.00 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4789 |
49480 |
10876 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-02-08 15:39:11.000 |
0 |
10876-19-1-2023-02-08 |
|
1174108 |
FARKKU-CAPRIT L |
1 |
NULL |
58.00 |
22.09 |
58.00 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4787 |
49478 |
10875 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-02-08 15:38:43.000 |
0 |
10875-19-1-2023-02-08 |
|
1424881 |
HAL ROMEO DMAXX PNT 38 |
1 |
NULL |
99.00 |
81.74 |
99.00 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4782 |
49473 |
10874 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-02-08 14:52:52.000 |
0 |
10874-19-1-2023-02-08 |
|
1426047 |
SQ HALF ZIP FLEECE PA 38 |
2 |
NULL |
79.00 |
47.15 |
79.00 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4783 |
49474 |
10874 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-02-08 14:52:52.000 |
0 |
10874-19-1-2023-02-08 |
|
1429938 |
JOULUSUKAT 38 |
1 |
NULL |
20.00 |
11.30 |
20.00 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4773 |
49464 |
10873 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-01-25 13:17:35.000 |
0 |
10873-19-1-2023-01-25 |
|
1429929 |
MUOVIKASSI |
2 |
NULL |
0.15 |
0.15 |
0.15 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4774 |
49465 |
10873 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-01-25 13:17:35.000 |
0 |
10873-19-1-2023-01-25 |
|
1330050 |
PAISLEY-PUSERO 42 |
1 |
NULL |
76.00 |
34.10 |
76.00 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4767 |
49458 |
10872 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-01-25 11:10:44.000 |
0 |
10872-19-1-2023-01-25 |
|
474436 |
V-AUKKOTRIKOO L |
2 |
NULL |
33.30 |
15.80 |
33.30 |
0.00 |
0 |
NULL |
0 |
1 |
0.00 |
0.00 |
0 |
24.00 |
NULL |
@ |
E |
1 |
NULL |
E |
NULL |
0 |
0 |
4768 |
49459 |
10872 |
1 |
1 |
19 |
Sale |
NoDiscount |
2023-01-25 11:10:44.000 |
0 |
10872-19-1-2023-01-25 |