← Back to Tables

Table: dbo.SalesAE

SalesID	SalesDate	ItemNumber	Quantity	Price	TaxAmount
1	2015-02-01 00:00:00	A1009	1.00	1511.1115	188.8879
2	2015-05-01 00:00:00	A1009	2.00	1631.2527	203.9055
3	2016-11-02 00:00:00	A1009	1.00	1598.0000	199.7500
4	2014-05-11 00:00:00	A1009	1.00	1282.4418	160.3044
5	2015-08-17 00:00:00	A1009	1.00	1880.0000	235.0000
6	2016-08-14 00:00:00	A1009	1.00	1480.5000	185.0660
7	2013-09-30 00:00:00	A1009	2.00	1428.0000	178.5000
8	2014-03-16 00:00:00	A1009	1.00	1768.8900	221.1100
9	2016-04-10 00:00:00	A1009	1.00	1598.0000	199.7500
10	2016-02-21 00:00:00	A1012	1.00	1692.0000	211.5000
11	2013-09-22 00:00:00	A1012	2.00	1428.0000	178.5000
12	2014-02-10 00:00:00	A1012	1.00	1238.2230	154.7770
13	2014-06-08 00:00:00	A1012	1.00	1857.7800	232.2200
14	2014-05-05 00:00:00	A1012	2.00	1853.0446	231.6281
15	2015-08-26 00:00:00	A1012	1.00	1598.0000	199.7500
16	2016-08-03 00:00:00	A1012	2.00	1667.2950	208.4119
17	2014-04-20 00:00:00	A1012	1.00	1538.9454	192.3694
18	2013-10-06 00:00:00	A1013	1.00	1428.0000	178.5000
19	2015-07-20 00:00:00	A1013	1.00	1592.0010	198.9990
20	2014-04-20 00:00:00	A1013	1.00	1503.5600	187.9400
21	2015-10-20 00:00:00	A1013	1.00	1518.0985	189.7623
22	2015-10-20 00:00:00	A1014	1.00	1518.0985	189.7623
23	2014-02-02 00:00:00	A1014	1.00	1768.8900	221.1100
24	2015-12-10 00:00:00	A1014	1.00	1401.6773	175.2097
25	2016-03-06 00:00:00	A1014	1.00	1880.0000	235.0000
26	2015-04-30 00:00:00	A1030	1.00	1916.4460	239.5540
27	2013-10-09 00:00:00	A1030	2.00	2190.2222	273.7800
28	2015-11-12 00:00:00	A1030	1.00	1848.0000	231.0000
29	2016-04-17 00:00:00	A1053	1.00	2833.3300	354.1700
30	2014-01-16 00:00:00	A1053	1.00	3333.3333	416.6700
31	2013-11-01 00:00:00	A1053	1.00	2833.3333	354.1700
32	2016-09-03 00:00:00	A1053	1.00	2250.0000	281.2500
33	2015-07-25 00:00:00	A1055	1.00	2666.6640	333.3360
34	2014-04-03 00:00:00	A1055	1.00	2833.3300	354.1700
35	2015-10-31 00:00:00	A1055	1.00	2833.3300	354.1700
36	2014-07-26 00:00:00	A1119	1.50	670.2900	33.5133
37	2014-05-24 00:00:00	A1119	12.00	788.5700	39.4283
38	2014-10-28 00:00:00	A1169	70.50	345.3300	17.2665
39	2013-09-19 00:00:00	A1188	1.00	3328.0000	416.0000
40	2015-05-01 00:00:00	A1188	1.00	3380.0000	422.5000
41	2014-02-10 00:00:00	A1221	1.00	1151.1080	143.8920
42	2013-09-16 00:00:00	A1221	1.00	1397.7800	174.7200
43	2016-04-27 00:00:00	A1221	1.00	1295.0000	161.8800
44	2016-04-27 00:00:00	A1228	1.00	805.0000	100.6200
45	2013-09-16 00:00:00	A1228	1.00	868.8889	108.6100
46	2013-09-29 00:00:00	A1228	1.00	868.8900	108.6100
47	2016-02-04 00:00:00	A1228	1.00	919.9980	115.0020
48	2016-08-16 00:00:00	A1229	3.00	868.8870	108.6102
49	2014-02-20 00:00:00	A1229	2.00	868.8870	108.6130
50	2015-05-31 00:00:00	A1229	2.00	1022.2200	127.7800