← Back to Tables

Table: dbo.Sales2

SalesID	SalesDate	ItemNumber	Quantity	Price	TaxAmount
1	2015-12-06 00:00:00	S559	5.00	4444.4444	2777.7800
2	2016-10-19 00:00:00	V231	2.00	2984.4444	746.1100
3	2014-11-14 00:00:00	V231	1.00	22222.2222	2777.7800
4	2022-05-28 00:00:00	V231	1.00	2627.1186	472.8800
5	2022-06-25 00:00:00	V231	1.00	5932.2034	1067.8000
6	2022-09-20 00:00:00	V231	1.00	2118.6441	381.3600
7	2015-05-10 00:00:00	M175	1.00	1480.0000	185.0000
8	2015-05-10 00:00:00	M175	1.00	806.4356	100.8028
9	2015-05-10 00:00:00	M175	1.00	1023.5023	127.9386
10	2015-05-10 00:00:00	M175	2.00	259.8223	64.9572
11	2015-05-10 00:00:00	M175	4.00	148.0000	74.0000
12	2017-01-19 00:00:00	M175	2.00	2455.5556	613.8900
13	2017-01-19 00:00:00	M175	4.00	866.6667	433.3300
14	2017-01-19 00:00:00	M175	2.00	13051.2000	3262.8000
15	2017-01-19 00:00:00	M175	1.00	5176.0000	647.0000
16	2017-01-19 00:00:00	M175	8.00	240.0000	240.0000
17	2017-01-19 00:00:00	M175	8.00	240.0000	240.0000
18	2018-05-19 00:00:00	M175	1.00	1263.7235	227.4753
19	2019-03-12 00:00:00	M175	10.00	84.7458	152.5400
20	2019-03-17 00:00:00	M175	18.00	10.1695	32.9500
21	2017-10-09 00:00:00	E34	2.00	827.6695	297.9600
22	2017-10-15 00:00:00	E34	2.00	493.4322	177.6400
23	2016-10-26 00:00:00	E34	1.00	517.5556	64.6900
24	2016-10-20 00:00:00	E34	6.00	944.4444	708.3300
25	2016-03-15 00:00:00	E34	1.00	1288.8889	161.1100
26	2016-03-15 00:00:00	E34	1.00	871.1111	108.8900
27	2016-04-08 00:00:00	E34	1.00	740.4444	92.5600
28	2018-11-14 00:00:00	D326	460.25	196.4286	10848.7500
29	2018-10-23 00:00:00	D327	855.00	60.2508	9272.5924
30	2018-10-23 00:00:00	D327	228.00	68.6000	2815.3400
31	2018-10-23 00:00:00	D327	285.00	68.6000	3519.1800
32	2018-10-23 00:00:00	D327	228.00	70.0000	2872.8000
33	2016-06-05 00:00:00	D327	5.00	1955.5556	1222.2200
34	2016-10-08 00:00:00	M176	1.00	2798.6000	349.8200
35	2017-01-19 00:00:00	M177	29.00	534.2857	774.7100
36	2017-01-19 00:00:00	M177	15.00	182.1429	136.6100
37	2014-04-05 00:00:00	M177	1.00	47.6190	2.3800
38	2018-12-14 00:00:00	M177	10.00	221.2500	398.2500
39	2018-05-19 00:00:00	M177	52.00	221.2454	2070.8566
40	2018-05-19 00:00:00	M177	48.00	296.2438	2559.5463
41	2018-03-28 00:00:00	M177	22.00	157.4383	623.4556
42	2018-03-28 00:00:00	M177	8.00	206.4191	297.2435
43	2013-11-22 00:00:00	H41	1.00	88.8889	11.1100
44	2015-06-07 00:00:00	H41	2.00	81.7540	20.4365
45	2016-11-02 00:00:00	H41	1.00	1700.0000	212.5000
46	2016-07-29 00:00:00	H41	1.00	577.7780	72.2263
47	2016-05-08 00:00:00	H41	2.00	135.5556	33.8916
48	2016-08-07 00:00:00	M178	4.00	124.4444	62.2200
49	2015-10-01 00:00:00	M178	1.00	2568.8889	321.1130
50	2015-10-08 00:00:00	M178	1.00	422.2222	52.7800