← Back to Tables

Table: dbo.CreditNoteDet

CrDetID	CrId	ItemDetid	Qty	Rate	Disc	TaxId	TaxPRate	TaxAmt	TaxAccId	Amt	CamoDetID	UserName	UseDate	NonStockID	ORate
1	1	81102	1.00	2757.7778	547.5000	42	12.50	344.7200	20509	3102.5000	758	SB	2013-09-24 22:17:00	0	—
2	2	100407	1.00	7879.1111	2216.0000	42	12.50	984.8900	20509	8864.0000	1760	SB	2013-09-29 19:56:55	0	—
3	3	100480	4.00	321.1100	255.0000	42	12.50	160.5600	20509	1445.0000	1971	HB	2013-09-30 19:23:24	0	—
4	3	87067	1.00	2984.4400	592.5000	42	12.50	373.0600	20509	3357.5000	1973	HB	2013-09-30 19:23:24	0	—
5	4	11223	4.50	670.2900	558.9000	47	5.00	150.8200	51680	3167.1200	3968	HB	2013-10-16 19:35:13	5	—
6	5	105806	1.00	319.7600	59.2500	47	5.00	15.9900	51680	335.7500	6706	HB	2013-10-19 15:25:42	0	—
7	6	111380	1.00	1983.3300	367.5000	47	5.00	99.1700	51680	2082.5000	5771	HB	2013-10-19 18:21:30	0	—
8	6	115075	1.00	2111.4300	1478.0000	47	5.00	105.5700	51680	2217.0000	5772	HB	2013-10-19 18:21:30	0	—
9	6	115077	1.00	2454.2900	1718.0000	47	5.00	122.7100	51680	2577.0000	5773	HB	2013-10-19 18:21:30	0	—
10	6	110668	1.00	3387.8600	627.7500	47	5.00	169.3900	51680	3557.2500	5774	HB	2013-10-19 18:21:30	0	—
11	7	114594	2.50	484.0952	224.2500	47	5.00	60.5100	51680	1270.7500	7223	SB	2013-10-23 20:07:59	0	—
12	8	70621	1.00	4265.1111	846.7500	42	12.50	533.1400	20509	4798.2500	11820	SB	2013-11-02 15:54:36	62	—
13	9	109423	1.00	3237.2900	599.8500	47	5.00	161.8600	51680	3399.1500	6032	SB	2013-11-05 17:28:59	0	—
14	9	114778	1.00	3642.0500	674.8500	47	5.00	182.1000	51680	3824.1500	6033	SB	2013-11-05 17:28:59	0	—
15	10	95971	15.50	451.7100	1297.3500	47	5.00	350.0800	51683	7351.5800	12964	HB	2013-11-07 14:58:32	0	—
16	10	8490	1.50	208.8600	58.0500	47	5.00	15.6600	51683	328.9500	12965	HB	2013-11-07 14:58:32	0	—
17	10	74622	6.00	330.2900	367.2000	47	5.00	99.0900	51683	2080.8300	12966	HB	2013-11-07 14:58:32	0	—
18	10	8355	6.00	168.3800	187.2000	47	5.00	50.5100	51683	1060.7900	12967	HB	2013-11-07 14:58:32	0	—
19	10	99408	18.60	403.1400	1389.4200	47	5.00	374.9200	51683	7873.3200	12968	HB	2013-11-07 14:58:32	0	—
20	10	54787	10.00	222.6200	412.5000	47	5.00	111.3100	51683	2337.5100	12969	HB	2013-11-07 14:58:32	79	—
21	10	51922	6.00	345.0000	.0000	0	.00	.0000	0	2070.0000	12970	HB	2013-11-07 14:58:32	0	—
22	10	79759	50.00	50.0000	.0000	0	.00	.0000	0	2500.0000	12971	HB	2013-11-07 14:58:32	0	—
23	10	82012	5.00	395.0000	.0000	0	.00	.0000	0	1975.0000	12972	HB	2013-11-07 14:58:32	0	—
24	10	53999	3.00	100.0000	.0000	0	.00	.0000	0	300.0000	12973	HB	2013-11-07 14:58:32	0	—
25	11	54785	59.00	68.8100	752.2500	47	5.00	202.9900	51680	4262.7800	11581	SB	2013-11-14 16:44:11	100	—
26	12	54791	1.00	500.0000	.0000	0	.00	.0000	0	500.0000	11757	SB	2013-11-14 16:46:51	28	—
27	13	117349	1.00	6741.3333	1896.0000	42	12.50	842.6700	20509	7584.0000	13252	SB	2013-11-16 18:14:14	0	—
28	14	115077	1.00	2045.2381	2147.5000	47	5.00	102.2600	51680	2147.5000	13445	SB	2013-11-23 18:09:38	0	—
29	15	96106	3.00	3513.3333	2092.5000	42	12.50	1317.5000	20509	11857.5000	9535	HB	2013-11-30 19:26:53	0	—
30	15	116625	3.00	7140.0000	4252.5000	42	12.50	2677.5000	20509	24097.5000	9536	HB	2013-11-30 19:26:53	16	—
31	16	112534	1.00	7715.5556	.0000	42	12.50	964.4400	20509	8680.0000	15858	SB	2013-12-05 20:20:27	0	—
32	17	96612	2.50	1188.5714	.0000	47	5.00	148.5700	51680	3120.0000	16791	SB	2013-12-10 18:40:25	0	—
33	18	118429	1.00	4133.3300	.0000	42	12.50	516.6700	20509	4650.0000	17526	SB	2013-12-15 17:09:17	0	—
34	19	113513	2.00	1452.3810	.0000	47	5.00	145.2400	51680	3050.0000	18750	HB	2014-01-05 18:07:31	0	—
35	20	118347	1.00	217.7800	.0000	42	12.50	27.2200	20509	245.0000	18853	HB	2014-01-05 19:23:04	0	—
36	21	114139	2.00	3804.4444	.0000	41	12.50	951.1100	20510	8560.0000	20068	AB	2014-01-19 13:15:28	0	—
37	21	49408	1.00	822.2222	.0000	41	12.50	102.7800	20510	925.0000	20069	AB	2014-01-19 13:15:28	0	—
38	22	99273	4.00	150.4762	.0000	47	5.00	30.1000	51680	632.0000	19997	HB	2014-01-24 14:07:51	0	—
39	23	108225	2.00	1309.5238	300.1200	47	5.00	130.9500	51680	2750.0000	18845	SB	2014-01-25 20:51:00	0	—
40	24	118665	1.00	6004.4400	.0000	42	12.50	750.5600	20509	6755.0000	19384	SB	2014-01-28 16:03:39	0	—
41	25	118711	4.00	521.9000	.0000	47	5.00	104.3800	51683	2191.9800	21223	AB	2014-01-30 15:58:16	0	—
42	26	99417	2.50	1026.6700	.0000	47	5.00	128.3300	51680	2695.0100	0	SB	2014-01-30 19:02:19	5	—
43	27	108557	2.00	1300.0000	.0000	47	5.00	130.0000	51680	2730.0000	20830	SB	2014-02-02 19:35:54	0	—
44	28	57524	4.00	984.0000	.0000	42	12.50	492.0000	20509	4428.0000	18700	SB	2014-02-04 18:40:34	34	—
45	28	57524	6.00	133.3333	.0000	42	12.50	100.0000	20509	900.0000	18701	SB	2014-02-04 18:40:34	34	—
46	29	88750	1.00	13476.1905	.0000	47	5.00	673.8100	51680	14150.0000	20458	HB	2014-02-05 15:40:25	0	—
47	30	119229	2.00	738.0952	.0000	48	5.00	73.8100	51680	1550.0000	20286	SB	2014-02-08 18:54:52	0	—
48	30	119228	2.00	928.5714	.0000	48	5.00	92.8600	51680	1950.0000	20287	SB	2014-02-08 18:54:52	0	—
49	31	113010	10.00	357.1400	.0000	47	5.00	178.5700	51680	3749.9700	22505	AB	2014-02-10 17:11:43	0	—
50	32	119215	3.00	738.0952	.0000	47	5.00	110.7100	51680	2325.0000	22740	AB	2014-02-10 19:13:43	0	—