← Back to Tables

Table: dbo.SalesScheme

SalesSchemeId	SalesSchemeName	Fdate	Tdate	UseDate	Username	SAmt	SAmt1	SAmt2	SDaily	SWeek	SAll	SActive	ShowRoom	SMS	AddDisc	AllowPOS	ITaxable	FATHER	SaleRemarks
1	APRIL	2013-04-26 00:00:00	2013-04-26 00:00:00	2013-04-26 19:20:04	ANIL	—	50.0000	—	0	0	0	1	1	0	.00	0	0	0	—
2	HAPPY MOTHERS DAY	2013-05-11 00:00:00	2013-05-11 00:00:00	2014-05-10 19:55:52	ANIL	—	50.0000	—	0	0	0	1	1	0	.00	0	0	0	—
3	100	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
4	2L	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
5	35 % SEP SPECIAL OFFER	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
6	500	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
7	AAJ KA DUM	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
8	APRIL SALE	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
9	JAI MATA DI DIWALI SALE	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
10	HAPPY MOTHERS DAY	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
11	REPUBLIC DAY OFFER	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
12	SEP SALE	2013-09-16 00:00:00	2013-09-22 00:00:00	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
13	WISH YOU A VERY HAPPY NEW YEAR 2011	—	—	—	—	—	—	—	0	0	0	0	0	0	.00	0	0	0	—
14	SEP SALE	2013-09-16 00:00:00	2013-09-22 00:00:00	2013-09-16 13:24:52	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
15	JAI MATA DI DIWALI SALE	2013-10-05 00:00:00	2013-11-03 00:00:00	2013-10-20 19:20:17	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
16	25 ANNIVERSARY	2014-02-09 00:00:00	2014-02-10 00:00:00	2014-02-11 13:25:53	ANIL	—	.0000	—	0	0	0	1	1	0	30.00	1	0	0	—
17	APRIL SALE	2014-03-22 00:00:00	2014-04-20 00:00:00	2014-04-20 13:14:34	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
18	HAPPY MOTHERS DAY	2014-05-11 00:00:00	2014-05-11 00:00:00	2014-05-10 19:55:41	ANIL	—	50.0000	—	0	0	0	1	1	0	.00	0	0	0	—
19	25% SPL OFFER 14-21 SEP	2014-09-14 00:00:00	2014-09-21 00:00:00	2014-09-14 12:32:02	ANIL	—	.0000	—	0	0	0	1	1	0	25.00	1	0	0	—
20	2ND OCT	2014-10-02 00:00:00	2014-10-02 00:00:00	2015-10-02 20:37:50	ANIL	—	.0000	—	0	0	0	1	1	0	30.00	1	0	0	—
21	JAI MATA DI DIWALI SALE	2014-09-27 00:00:00	2014-10-23 00:00:00	2014-10-19 16:23:28	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
22	SEP SALE	2014-08-28 00:00:00	2014-09-21 00:00:00	2014-10-19 18:13:15	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
23	APRIL SPECIAL	2015-04-19 00:00:00	2015-04-20 00:00:00	2015-04-19 10:57:11	ANIL	—	.0000	—	0	0	0	1	1	0	35.00	1	0	0	—
24	HAPPY MOTHERS DAY	2015-05-10 00:00:00	2015-05-10 00:00:00	2015-05-09 20:54:57	ANIL	—	50.0000	—	0	0	0	1	1	0	.00	0	0	0	—
25	WISH YOU A HAPPY INDEPENDENCE DAY	2015-08-15 00:00:00	2015-08-15 00:00:00	2015-08-14 20:58:11	ANIL	—	.0000	—	0	0	0	1	1	0	30.00	1	0	0	—
26	SEP SALE	2015-08-21 00:00:00	2015-09-13 00:00:00	2015-09-13 16:58:29	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
27	2ND OCT	2015-10-02 00:00:00	2015-10-02 00:00:00	2015-10-02 20:52:35	ANIL	—	.0000	—	0	0	0	1	1	0	.00	1	0	0	—
28	JAI MATA DI DIWALI SALE	2015-10-13 00:00:00	2015-11-11 00:00:00	2015-10-13 12:12:31	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
29	26 JAN	2016-01-26 00:00:00	2016-01-26 00:00:00	2016-01-26 14:40:41	ANIL	—	.0000	—	0	0	0	1	1	0	26.00	1	0	0	—
30	APRIL SALE	2016-03-26 00:00:00	2016-04-17 00:00:00	2016-03-26 14:59:50	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
31	APRIL SALE	2015-04-01 00:00:00	2015-04-18 00:00:00	2016-04-15 16:56:49	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
32	APRIL SPECIAL	2016-04-18 00:00:00	2016-04-18 00:00:00	2016-04-17 18:21:38	ANIL	—	.0000	—	0	0	0	1	1	0	30.00	1	0	0	—
33	HAPPY MOTHERS DAY	2016-05-08 00:00:00	2016-05-08 00:00:00	2016-05-08 11:49:05	ANIL	—	50.0000	—	0	0	0	1	1	0	.00	0	0	0	—
34	WISH YOU A HAPPY INDEPENDENCE DAY	2016-08-14 00:00:00	2016-08-15 00:00:00	2016-08-14 11:22:39	ANIL	—	.0000	—	0	0	0	1	1	0	30.00	1	0	0	—
35	SEP SALE	2016-08-27 00:00:00	2016-09-18 00:00:00	2016-08-27 12:59:33	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
36	JAI MATA DI DIWALI SALE	2016-10-01 00:00:00	2016-10-30 00:00:00	2016-10-06 12:41:01	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
37	26 JAN	2017-01-26 00:00:00	2017-01-29 00:00:00	2017-01-27 11:35:52	ANIL	—	.0000	—	0	0	0	1	1	0	40.00	1	0	0	—
38	APRIL SALE	2017-03-25 00:00:00	2017-04-16 00:00:00	2017-03-25 14:21:52	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
39	APRIL SPECIAL	2017-04-22 00:00:00	2017-04-23 00:00:00	2017-04-21 19:16:59	ANIL	—	.0000	—	0	0	0	1	1	0	40.00	1	1	0	—
40	HAPPY MOTHERS DAY	2017-05-14 00:00:00	2017-05-14 00:00:00	2017-05-13 20:08:54	ANIL	—	50.0000	—	0	0	0	1	1	0	.00	1	1	0	—
41	WISH YOU A HAPPY INDEPENDENCE DAY	2017-08-15 00:00:00	2017-08-15 00:00:00	2017-08-15 12:02:57	ANIL	—	.0000	—	0	0	0	1	1	0	30.00	1	1	0	—
42	SEP SALE	2017-08-27 00:00:00	2017-09-20 00:00:00	2017-09-21 11:39:36	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
43	JAI MATA DI DIWALI SALE	2017-09-21 00:00:00	2017-10-20 00:00:00	2017-10-20 19:19:35	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
44	26 JAN	2018-01-26 00:00:00	2018-01-29 00:00:00	2018-01-27 11:24:22	ANIL	—	.0000	—	0	0	0	1	1	0	40.00	1	1	0	—
45	APRIL SPECIAL	2018-04-28 00:00:00	2018-04-30 00:00:00	2018-04-27 21:17:26	ANIL	—	.0000	—	0	0	0	1	1	0	35.00	1	0	0	—
46	HAPPY MOTHERS DAY	2018-05-13 00:00:00	2018-05-13 00:00:00	2018-05-12 20:47:47	ANIL	—	50.0000	—	0	0	0	1	1	0	.00	0	0	0	—
47	HAPPY FATHER DAY	2018-06-17 00:00:00	2018-06-17 00:00:00	2018-06-17 11:26:59	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	1	—
48	WISH YOU A HAPPY INDEPENDENCE DAY	2018-08-15 00:00:00	2018-08-15 00:00:00	2020-08-15 13:41:07	ANIL	—	.0000	.0000	0	0	0	1	1	0	36.00	1	0	0	—
49	SEP SALE	2018-08-19 00:00:00	2018-09-23 00:00:00	2018-08-28 12:09:42	ANIL	—	.0000	—	0	0	0	1	1	0	.00	0	0	0	—
50	2ND OCT	2018-10-02 00:00:00	2018-10-02 00:00:00	2018-09-28 21:01:43	ANIL	—	.0000	30.0000	0	0	0	1	1	0	.00	0	0	0	—