← Back to Tables

Table: dbo.CashMemoDet

CaMoDetID	CaMoID	BarId	ItemDetID	NonStockID	Quantity	Length	Width	Thickness	AreaMtr	AreaFt	Rate	ORate	TaxID	TaxPrate	TaxAmt	CrSaleAccID	CashSaleAccID	SaleDiscAccID	SaleTaxAccID	DiscPct	DiscAmt	Amount	NetDiscount	NetTax	NetCost	Narration	Taxable	TaxPaid	IncTax	ExTax	AliasID	BookSlipID	BookSlipNum	SalManID	ItemCode	DiscountAmount	lstChar	curstockqty	TaxAmt1	SRate1	UserName	UseDate	Actualdisc	IUnit	SiteManID	TQty	TSectionID	TGrndetID	TBarID	TTQty	Mat	WebOrderID	TConsignID	ICost	SFloorID	IDesc	DiscNotAllow	StkR
1	1	0	112107	0	1.0000	0	0	0	1.00	1.00	925.5556	1225.0000	42	12.5000	115.6900	20511	20511	0	20509	15.0000	183.7500	1041.2500	—	115.6900	—	Null	1	0	1	0	0	5678	1	251	D5719	183.7500	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	490.0000	—	—	0	0
2	1	0	110683	0	1.0000	0	0	0	1.00	1.00	623.3333	825.0000	42	12.5000	77.9200	20511	20511	0	20509	15.0000	123.7500	701.2500	—	77.9200	—	Null	1	0	1	0	0	5678	1	251	A3342	123.7500	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	439.9700	—	—	0	0
3	2	0	71146	0	1.0000	0	0	0	1.00	1.00	366.4444	485.0000	42	12.5000	45.8100	20511	20511	0	20509	15.0000	72.7500	412.2500	—	45.8100	—	Null	1	0	1	0	0	5678	2	251	M1832	72.7500	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	231.1140	—	—	0	0
4	3	0	101918	0	4.0000	0	0	0	4.00	4.00	415.5600	550.0000	42	12.5000	207.7800	20511	20511	43352	20509	15.0000	330.0000	1870.0200	—	207.7800	—	Null	1	0	1	0	0	5679	10001	251	C2398	330.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	4	Null	Null	Null	Null	0	—	0	181.8750	—	—	0	0
5	3	0	101913	0	4.0000	0	0	0	4.00	4.00	415.5600	550.0000	42	12.5000	207.7800	20511	20511	43352	20509	15.0000	330.0000	1870.0200	—	207.7800	—	Null	1	0	1	0	0	5679	10001	251	C2393	330.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	4	Null	Null	Null	Null	0	—	0	181.8750	—	—	0	0
6	4	0	101909	0	2.0000	0	0	0	2.00	2.00	264.4400	350.0000	42	12.5000	66.1100	20511	20511	43352	20509	15.0000	105.0000	594.9900	—	66.1100	—	Null	1	0	1	0	0	5679	10002	251	C2389	105.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0	111.5625	—	—	0	0
7	4	0	87609	0	3.0000	0	0	0	3.00	3.00	415.5600	550.0000	42	12.5000	155.8400	20511	20511	43352	20509	15.0000	247.5000	1402.5200	—	155.8400	—	Null	1	0	1	0	0	5679	10002	251	C1855	247.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	3	Null	Null	Null	Null	0	—	0	196.0000	—	—	0	0
8	5	0	75396	0	1.0000	0	0	0	1.00	1.00	868.8889	1150.0000	42	12.5000	108.6100	20511	20511	0	20509	15.0000	172.5000	977.5000	—	108.6100	—	Null	1	0	1	0	0	5678	4	251	A1228	172.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	1528.0000	—	—	0	0
9	5	0	110765	0	1.0000	0	0	0	1.00	1.00	566.6667	750.0000	42	12.5000	70.8300	20511	20511	0	20509	15.0000	112.5000	637.5000	—	70.8300	—	Null	1	0	1	0	0	5678	4	251	A3390	112.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	399.9700	—	—	0	0
11	6	0	41949	0	2.0000	0	0	0	2.00	2.00	498.6667	660.0000	42	12.5000	124.6700	20511	20511	0	20509	15.0000	198.0000	1122.0000	—	124.6700	—	Null	1	0	1	0	0	5678	3	1698	L2173	198.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0	405.4700	—	—	0	0
12	7	0	43859	0	10.0000	0	0	0	10.00	10.00	124.6700	165.0000	42	12.5000	155.8400	20511	20511	43352	20509	15.0000	247.5000	1402.5400	—	155.8400	—	Null	1	0	1	0	0	5679	10003	539	A1719	247.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	10	Null	Null	Null	Null	0	—	0	78.0000	—	—	0	0
13	7	0	90112	0	4.0000	0	0	0	4.00	4.00	222.6200	275.0000	47	5.0000	44.5200	51681	51681	43352	51680	15.0000	165.0000	935.0000	—	44.5200	—	Null	1	0	1	0	0	5679	10003	539	K2563	165.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	4	Null	Null	Null	Null	0	—	0	116.0000	—	—	0	0
14	7	0	99219	0	2.0000	0	0	0	2.00	2.00	344.0500	425.0000	47	5.0000	34.4000	51681	51681	43352	51680	15.0000	127.5000	722.5000	—	34.4000	—	Null	1	0	1	0	0	5679	10003	539	M3764	127.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0	210.0000	—	—	0	0
15	7	0	90111	0	4.0000	0	0	0	4.00	4.00	222.6200	275.0000	47	5.0000	44.5200	51681	51681	43352	51680	15.0000	165.0000	935.0000	—	44.5200	—	Null	1	0	1	0	0	5679	10003	539	K2562	165.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	4	Null	Null	Null	Null	0	—	0	116.0000	—	—	0	0
16	8	0	69590	0	1.0000	0	0	0	1.00	1.00	513.7800	680.0000	42	12.5000	64.2200	20511	20511	43352	20509	15.0000	102.0000	578.0000	—	64.2200	—	Null	1	0	1	0	0	5679	10004	357	F1706	102.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	392.8900	—	—	0	0
17	9	0	111189	0	2.0000	0	0	0	2.00	2.00	136.0000	168.0000	47	5.0000	13.6000	51681	51681	43352	51680	15.0000	50.4000	285.6000	—	13.6000	—	Null	1	0	1	0	0	5679	10006	1521	L2969	50.4000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0	80.0000	—	—	0	0
18	9	0	108731	0	3.0000	0	0	0	3.00	3.00	144.1000	178.0000	47	5.0000	21.6200	51681	51681	43352	51680	15.0000	80.1000	453.9200	—	21.6200	—	Null	1	0	1	0	0	5679	10006	1521	L2858	80.1000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	3	Null	Null	Null	Null	0	—	0	83.0000	—	—	0	0
20	11	0	83256	0	1.0000	0	0	0	1.00	1.00	600.0000	675.0000	42	12.5000	37.5000	20511	20511	43352	20509	.0000	.0000	675.0000	—	75.0000	—	Null	1	0	1	0	0	5679	10005	251	P1535	.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	143.5500	—	—	0	0
21	11	0	83255	0	2.0000	0	0	0	2.00	2.00	600.0000	675.0000	42	12.5000	75.0000	20511	20511	43352	20509	.0000	.0000	1350.0000	—	150.0000	—	Null	1	0	1	0	0	5679	10005	251	P1534	.0000	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0	190.5700	—	—	0	0
22	12	0	111189	0	1.0000	0	0	0	1.00	1.00	136.0000	168.0000	47	5.0000	6.8000	51681	51681	43352	51680	15.0000	25.2000	142.8000	—	6.8000	—	Null	1	0	1	0	0	5679	10007	1521	L2969	25.2000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	80.0000	—	—	0	0
23	10	0	111190	0	6.0000	0	0	0	6.00	6.00	123.0476	152.0000	47	5.0000	36.9100	51681	51681	0	51680	15.0000	136.8000	775.2000	—	36.9100	—	Null	1	0	1	0	0	5680	101	1521	L2970	136.8000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	6	Null	Null	Null	Null	0	—	0	83.0000	—	—	0	0
24	13	0	86269	0	2.0000	0	0	0	2.00	2.00	49.1100	65.0000	42	12.5000	12.2800	20511	20511	43352	20509	15.0000	19.5000	110.5000	—	12.2800	—	Null	1	0	1	0	0	5679	10008	251	B3708	19.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0	30.0000	—	—	0	0
25	13	0	101148	0	1.0000	0	0	0	1.00	1.00	86.8900	115.0000	42	12.5000	10.8600	20511	20511	43352	20509	15.0000	17.2500	97.7500	—	10.8600	—	Null	1	0	1	0	0	5679	10008	251	B4550	17.2500	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	50.0000	—	—	0	0
26	13	0	69589	0	1.0000	0	0	0	1.00	1.00	1095.5600	1450.0000	42	12.5000	136.9400	20511	20511	43352	20509	15.0000	217.5000	1232.5000	—	136.9400	—	Null	1	0	1	0	0	5679	10008	251	F1695	217.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	590.0000	—	—	0	0
27	13	0	112445	0	1.0000	0	0	0	1.00	1.00	2776.6700	3675.0000	42	12.5000	347.0800	20511	20511	43352	20509	15.0000	551.2500	3123.7500	—	347.0800	—	Null	1	0	1	0	0	5679	10008	251	B5099	551.2500	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	1800.0000	—	—	0	0
28	14	0	75323	0	1.0000	0	0	0	1.00	1.00	1397.7800	1850.0000	42	12.5000	174.7200	20511	20511	43352	20509	15.0000	277.5000	1572.5000	—	174.7200	—	Null	1	0	1	0	0	5679	10009	357	A1221	277.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	1432.0000	—	—	0	0
29	15	0	94994	0	1.0000	0	0	0	1.00	1.00	2618.0000	3465.0000	42	12.5000	327.2500	20511	20511	43352	20509	15.0000	519.7500	2945.2500	—	327.2500	—	Null	1	0	1	0	0	5679	10010	251	A2715	519.7500	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	2002.0000	—	—	0	0
30	15	0	49383	0	1.0000	0	0	0	1.00	1.00	460.8900	610.0000	42	12.5000	57.6100	20511	20511	43352	20509	15.0000	91.5000	518.5000	—	57.6100	—	Null	1	0	1	0	0	5679	10010	251	B3278	91.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	345.8600	—	—	0	0
31	16	0	91500	0	1.0000	0	0	0	1.00	1.00	374.0000	495.0000	42	12.5000	46.7500	20511	20511	43352	20509	15.0000	74.2500	420.7500	—	46.7500	—	Null	1	0	1	0	0	5679	10011	35	F3307	74.2500	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	211.5000	—	—	0	0
32	16	0	110023	0	1.0000	0	0	0	1.00	1.00	245.5600	325.0000	42	12.5000	30.7000	20511	20511	43352	20509	15.0000	48.7500	276.2600	—	30.7000	—	Null	1	0	1	0	0	5679	10011	35	F4551	48.7500	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	170.0000	—	—	0	0
33	17	0	93622	0	1.0000	0	0	0	1.00	1.00	321.1100	425.0000	42	12.5000	40.1400	20511	20511	43352	20509	15.0000	63.7500	361.2500	—	40.1400	—	Null	1	0	1	0	0	5679	10012	1425	S8304	63.7500	—	—	—	—	ANIL	2013-09-16 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	190.0000	—	—	0	0
34	18	0	70083	0	1.0000	0	0	0	1.00	1.00	434.4444	575.0000	42	12.5000	54.3100	20511	20511	0	20509	15.0000	86.2500	488.7500	—	54.3100	—	Null	1	0	1	0	0	5678	5	1425	B1480	86.2500	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	275.0000	—	—	0	0
35	19	0	73153	0	1.0000	0	0	0	1.00	1.00	430.6667	570.0000	42	12.5000	45.7555	20511	20511	0	20509	15.0000	85.5000	484.5000	—	53.8300	—	Null	1	0	1	0	0	0	0	251	M1993	85.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	302.2260	—	—	0	0
36	19	0	110222	0	1.0000	0	0	0	1.00	1.00	596.8889	790.0000	42	12.5000	63.4185	20511	20511	0	20509	15.0000	118.5000	671.5000	—	74.6100	—	Null	1	0	1	0	0	0	0	251	D5580	118.5000	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	421.3300	—	—	0	0
37	20	0	110708	0	1.0000	0	0	0	1.00	1.00	850.0000	1125.0000	42	12.5000	106.2500	20511	20511	0	20509	15.0000	168.7500	956.2500	—	106.2500	—	Null	1	0	1	0	0	5678	6	251	A3364	168.7500	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	599.9600	—	—	0	0
38	20	0	43111	0	1.0000	0	0	0	1.00	1.00	91.4222	121.0000	42	12.5000	11.4300	20511	20511	0	20509	15.0000	18.1500	102.8500	—	11.4300	—	Null	1	0	1	0	0	5678	6	251	S4719	18.1500	—	—	—	—	ANIL	2013-09-16 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	67.8100	—	—	0	0
39	21	0	70263	0	1.0000	0	0	0	1.00	1.00	415.5556	550.0000	42	12.5000	51.9400	20511	20511	0	20509	15.0000	82.5000	467.5000	—	51.9400	—	Null	1	0	1	0	0	5678	7	539	U468	82.5000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0	268.6700	—	—	0	0
40	22	0	108352	16	2.0000	0	0	0	2.00	2.00	328.6667	435.0000	42	12.5000	82.1700	20511	20511	0	20509	15.0000	130.5000	739.5000	—	82.1700	—	Null	1	0	1	0	16	5678	9	357	0	130.5000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Null	0	2	Null	Null	Null	Null	0	—	Null	.0000	—	—	0	0
41	23	0	95873	0	1.0000	0	0	0	1.00	1.00	186.6667	350.0000	42	12.5000	23.3300	20511	20511	0	20509	40.0000	140.0000	210.0000	—	23.3300	—	Null	1	0	1	0	0	5678	8	251	O871	140.0000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	100.0000	—	—	0	0
42	24	0	45593	0	1.0000	0	0	0	1.00	1.00	698.8900	925.0000	42	12.5000	87.3600	20511	20511	43352	20509	15.0000	138.7500	786.2500	—	87.3600	—	Null	1	0	1	0	0	5679	10019	251	D2162	138.7500	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	200.0000	—	—	0	0
43	25	0	112073	0	1.0000	0	0	0	1.00	1.00	441.1900	545.0000	47	5.0000	22.0600	51681	51681	43352	51680	15.0000	81.7500	463.2500	—	22.0600	—	Null	1	0	1	0	0	5679	10013	1009	SA881	81.7500	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	255.0000	—	—	0	0
44	26	0	59469	0	1.0000	0	0	0	1.00	1.00	306.8100	379.0000	47	5.0000	15.3400	51681	51681	43352	51680	15.0000	56.8500	322.1500	—	15.3400	—	Null	1	0	1	0	0	5679	10016	251	B769	56.8500	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	243.7468	—	—	0	0
45	27	0	69019	0	1.0000	0	0	0	1.00	1.00	80.1400	99.0000	47	5.0000	4.0100	51681	51681	43352	51680	15.0000	14.8500	84.1500	—	4.0100	—	Null	1	0	1	0	0	5679	10014	251	L1125	14.8500	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	55.4800	—	—	0	0
46	27	0	108377	0	2.0000	0	0	0	2.00	2.00	97.1400	120.0000	47	5.0000	9.7100	51681	51681	43352	51680	15.0000	36.0000	203.9900	—	9.7100	—	Null	1	0	1	0	0	5679	10014	251	SA439	36.0000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0	72.0000	—	—	0	0
47	27	0	108379	0	1.0000	0	0	0	1.00	1.00	145.7100	180.0000	47	5.0000	7.2900	51681	51681	43352	51680	15.0000	27.0000	153.0000	—	7.2900	—	Null	1	0	1	0	0	5679	10014	251	SA441	27.0000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	108.0000	—	—	0	0
48	27	0	111553	0	2.0000	0	0	0	2.00	2.00	659.7600	815.0000	47	5.0000	65.9800	51681	51681	43352	51680	15.0000	244.5000	1385.5000	—	65.9800	—	Null	1	0	1	0	0	5679	10014	251	L2994	244.5000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0	456.7600	—	—	0	0
49	27	0	98198	0	1.0000	0	0	0	1.00	1.00	125.4800	155.0000	47	5.0000	6.2700	51681	51681	43352	51680	15.0000	23.2500	131.7500	—	6.2700	—	Null	1	0	1	0	0	5679	10014	251	L2104	23.2500	—	—	—	—	MAIN-02	2013-09-17 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0	86.8700	—	—	0	0
50	28	0	95867	0	6.0000	0	0	0	6.00	6.00	528.8900	595.0000	42	12.5000	238.0020	20511	20511	43352	20509	.0000	.0000	3570.0100	—	396.6700	—	Null	1	0	1	0	0	5679	10017	251	O845	.0000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	0	Pcs	0	6	Null	Null	Null	Null	0	—	0	150.0000	—	—	0	0
51	28	0	95868	0	6.0000	0	0	0	6.00	6.00	440.0000	495.0000	42	12.5000	198.0000	20511	20511	43352	20509	.0000	.0000	2970.0000	—	330.0000	—	Null	1	0	1	0	0	5679	10017	251	O849	.0000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	0	Pcs	0	6	Null	Null	Null	Null	0	—	0	100.0000	—	—	0	0
52	28	0	95870	0	6.0000	0	0	0	6.00	6.00	311.1100	350.0000	42	12.5000	139.9980	20511	20511	43352	20509	.0000	.0000	2099.9900	—	233.3300	—	Null	1	0	1	0	0	5679	10017	251	O860	.0000	—	—	—	—	MAIN-02	2013-09-17 00:00:00	0	Pcs	0	6	Null	Null	Null	Null	0	—	0	125.0000	—	—	0	0