← Back to Tables

Table: dbo.DaySale

DaySalID	DayDate	Floor	SalAmt	LSmonth	Profit
1	2014-04-01 00:00:00	BED & BATH	19035.0000	0	6133.0000
2	2014-04-01 00:00:00	BEDCOVER	3716.0000	0	1665.0000
3	2014-04-01 00:00:00	CARPET	2464.0000	0	1587.0000
4	2014-04-01 00:00:00	F ASS	1050.0000	0	883.0000
5	2014-04-01 00:00:00	FLOWER	748.0000	0	348.0000
6	2014-04-01 00:00:00	FURNSHG	71852.0000	0	35692.0000
7	2014-04-01 00:00:00	GIFT	33257.0000	0	13535.0000
8	2014-04-01 00:00:00	MAT	9062.0000	0	4504.0000
9	2014-04-01 00:00:00	MISC	37449.0000	0	16064.0000
10	2014-04-01 00:00:00	QUILTS	31376.0000	0	12840.0000
11	2014-04-01 00:00:00	T FABRIC`	12855.0000	0	7645.0000
12	2014-04-01 00:00:00	TOWEL	1509.0000	0	437.0000
13	2014-04-02 00:00:00	BED & BATH	14534.0000	0	5724.0000
14	2014-04-02 00:00:00	BEDCOVER	8236.0000	0	3511.0000
15	2014-04-02 00:00:00	CARPET	2944.0000	0	2024.0000
16	2014-04-02 00:00:00	DRAPERY ROD	8823.0000	0	5974.0000
17	2014-04-02 00:00:00	F ASS	680.0000	0	-595.0000
18	2014-04-02 00:00:00	FURNSHG	92287.0000	0	-27563.0000
19	2014-04-02 00:00:00	GIFT	22980.0000	0	8865.0000
20	2014-04-02 00:00:00	MAT	17645.0000	0	6504.0000
21	2014-04-02 00:00:00	MISC	3472.0000	0	1702.0000
22	2014-04-02 00:00:00	QUILTS	5040.0000	0	2272.0000
23	2014-04-02 00:00:00	T FABRIC`	1000.0000	0	-422.0000
24	2014-04-02 00:00:00	TOWEL	8530.0000	0	3466.0000
25	2014-04-02 00:00:00	WALL TO WALL Q	27490.0000	0	15084.0000
26	2014-04-03 00:00:00	BED & BATH	26576.0000	0	10821.0000
27	2014-04-03 00:00:00	BEDCOVER	5348.0000	0	2118.0000
28	2014-04-03 00:00:00	CARPET	3424.0000	0	2133.0000
29	2014-04-03 00:00:00	DRAPERY ROD	11142.0000	0	-323.0000
30	2014-04-03 00:00:00	F ASS	375.0000	0	315.0000
31	2014-04-03 00:00:00	FLOWER	3186.0000	0	1578.0000
32	2014-04-03 00:00:00	FURNSHG	251561.0000	0	127140.0000
33	2014-04-03 00:00:00	GIFT	46348.0000	0	21703.0000
34	2014-04-03 00:00:00	MAT	21817.0000	0	10240.0000
35	2014-04-03 00:00:00	MATTRESS Q	1139.0000	0	512.0000
36	2014-04-03 00:00:00	MISC	32305.0000	0	13061.0000
37	2014-04-03 00:00:00	QUILTS	19320.0000	0	8493.0000
38	2014-04-03 00:00:00	T FABRIC SOFA	5300.0000	0	-318.0000
39	2014-04-03 00:00:00	T FABRIC`	31762.0000	0	16377.0000
40	2014-04-04 00:00:00	BED & BATH	24549.0000	0	9740.0000
41	2014-04-04 00:00:00	BEDCOVER	10639.0000	0	4189.0000
42	2014-04-04 00:00:00	CARPET	7168.0000	0	4179.0000
43	2014-04-04 00:00:00	F ASS	490.0000	0	305.0000
44	2014-04-04 00:00:00	FLOWER	166.0000	0	71.0000
45	2014-04-04 00:00:00	FURNSHG	80452.0000	0	41349.0000
46	2014-04-04 00:00:00	GIFT	24711.0000	0	9805.0000
47	2014-04-04 00:00:00	MAT	7773.0000	0	3775.0000
48	2014-04-04 00:00:00	MATTRESS Q	2920.0000	0	1298.0000
49	2014-04-04 00:00:00	MISC	5006.0000	0	2356.0000
50	2014-04-04 00:00:00	QUILTS	9646.0000	0	4120.0000