← Back to Tables

Table: dbo.AdvCashMemoDet

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
1	1	0	109407	0	2.0000	0	0	0	2.00	2.00	1809.5200	2375.0000	47	5.0000	180.9500	51681	51681	43352	51680	20.00	950.0000	3799.9900	—	180.9500	—	Null	1	0	1	0	0	5679	10380	1521	B4939	950.0000	—	—	—	—	MAIN-02	2013-09-23 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0,1135.25	1135.2500
2	1	0	99855	0	1.0000	0	0	0	1.00	1.00	2400.0000	3150.0000	47	5.0000	120.0000	51681	51681	43352	51680	20.00	630.0000	2520.0000	—	120.0000	—	Null	1	0	1	0	0	5679	10380	1521	P2257	630.0000	—	—	—	—	MAIN-02	2013-09-23 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,1525	1525.0000
3	1	0	112601	0	1.0000	0	0	0	1.00	1.00	3771.4300	4950.0000	47	5.0000	188.5700	51681	51681	43352	51680	20.00	990.0000	3960.0000	—	188.5700	—	Null	1	0	1	0	0	5679	10380	1521	R8117	990.0000	—	—	—	—	MAIN-02	2013-09-23 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,2200	2200.0000
4	2	0	110812	0	5.0000	0	0	0	5.00	5.00	415.5600	550.0000	42	12.5000	259.7300	20511	20511	43352	20509	15.00	412.5000	2337.5300	—	259.7300	—	Null	1	0	1	0	0	5679	10550	1562	B5005	412.5000	—	—	—	—	MAIN-02	2013-09-28 00:00:00	1	Pcs	0	5	Null	Null	Null	Null	0	—	0,225	225.0000
5	3	0	106951	0	3.0000	0	0	0	3.00	3.00	1473.3300	1950.0000	42	12.5000	552.5000	20511	20511	43352	20509	15.00	877.5000	4972.4900	—	552.5000	—	Null	1	0	1	0	0	5679	10588	357	I1403	877.5000	—	—	—	—	ANIL	2013-09-29 00:00:00	1	Pcs	0	3	Null	Null	Null	Null	0	—	0,721.875	721.8750
6	4	0	113288	0	50.0000	0	0	0	50.00	50.00	1044.4444	1495.0000	42	12.5000	6527.7800	20511	20511	0	20509	21.40	16000.0100	58750.0000	—	6527.7800	—	Null	1	0	1	0	0	5690	749	35	B5137	16000.0100	—	—	—	—	MAIN-02	2013-09-30 00:00:00	0	Pcs	0	50	Null	Null	Null	Null	0	—	0,575	575.0000
7	4	0	113283	0	1.0000	0	0	0	1.00	1.00	1822.2222	2595.0000	42	12.5000	227.7800	20511	20511	0	20509	21.00	545.0000	2050.0000	—	227.7800	—	Null	1	0	1	0	0	5690	749	35	B5132	545.0000	—	—	—	—	MAIN-02	2013-09-30 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,1000	1000.0000
8	5	0	62290	0	2.0000	0	0	0	2.00	2.00	133.5714	165.0000	47	5.0000	13.3600	51681	51681	0	51680	15.00	49.5000	280.5000	—	13.3600	—	Null	1	0	1	0	0	5687	637	1009	W284	49.5000	—	—	—	—	ANIL	2013-10-03 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0,66	66.0000
9	5	0	70622	118	2.0000	0	0	0	2.00	2.00	829.7619	1025.0000	47	5.0000	82.9800	51681	51681	0	51680	15.00	307.5000	1742.5000	—	82.9800	—	Null	1	0	1	0	118	5687	637	1009	0	307.5000	—	—	—	—	ANIL	2013-10-03 00:00:00	1	Null	0	2	Null	Null	Null	Null	0	—	Null,0	.0000
10	6	0	42816	0	2.0000	0	0	0	2.00	2.00	9600.0000	13775.0000	42	12.5000	2400.0000	20511	20511	0	20509	21.60	5950.0000	21600.0000	—	2400.0000	—	Null	1	0	1	0	0	5694	913	1562	D1888	5950.0000	—	—	—	—	MAIN-02	2013-10-06 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0,6332.77	6332.7700
11	6	0	54399	0	1.0000	0	0	0	1.00	1.00	2753.0578	3950.0000	42	12.5000	344.1300	20511	20511	0	20509	21.59	852.8100	3097.1900	—	344.1300	—	Null	1	0	1	0	0	5694	913	1562	D288	852.8100	—	—	—	—	MAIN-02	2013-10-06 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,1805.02	1805.0200
12	6	0	43835	0	1.0000	0	0	0	1.00	1.00	5906.8889	8475.0000	42	12.5000	738.3600	20511	20511	0	20509	21.59	1829.7500	6645.2500	—	738.3600	—	Null	1	0	1	0	0	5694	913	1562	D2023	1829.7500	—	—	—	—	MAIN-02	2013-10-06 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,3799.41	3799.4100
13	7	0	63560	0	1.0000	0	0	0	1.00	1.00	2954.7619	3650.0000	47	5.0000	147.7400	51681	51681	0	51680	15.00	547.5000	3102.5000	—	147.7400	—	Null	1	0	1	0	0	5696	1112	1685	R2092	547.5000	—	—	—	—	ANIL	2013-10-10 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,1700	1700.0000
14	8	0	106868	0	1.0000	0	0	0	1.00	1.00	2408.3300	2975.0000	47	5.0000	120.4200	51681	51681	43352	51680	15.00	446.2500	2528.7500	—	120.4200	—	Null	1	0	1	0	0	5679	11186	1421	SA144	446.2500	—	—	—	—	ANIL	2013-10-10 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,1377.5	1377.5000
15	8	0	113918	0	1.0000	0	0	0	1.00	1.00	1615.0000	1995.0000	47	5.0000	80.7500	51681	51681	43352	51680	15.00	299.2500	1695.7500	—	80.7500	—	Null	1	0	1	0	0	5679	11186	1421	SA1175	299.2500	—	—	—	—	ANIL	2013-10-10 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,1167.3	1167.3000
16	8	0	103238	0	1.0000	0	0	0	1.00	1.00	1983.3300	2450.0000	47	5.0000	99.1700	51681	51681	43352	51680	15.00	367.5000	2082.5000	—	99.1700	—	Null	1	0	1	0	0	5679	11186	1421	B4643	367.5000	—	—	—	—	ANIL	2013-10-10 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,1064	1064.0000
17	8	0	110670	0	1.0000	0	0	0	1.00	1.00	2165.4800	2675.0000	47	5.0000	108.2700	51681	51681	43352	51680	15.00	401.2500	2273.7500	—	108.2700	—	Null	1	0	1	0	0	5679	11186	1421	M4456	401.2500	—	—	—	—	ANIL	2013-10-10 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,1315	1315.0000
18	9	0	112215	0	1.0000	0	0	0	1.00	1.00	3764.2857	4650.0000	47	5.0000	178.5925	51681	51681	0	51680	15.00	697.5000	3952.5000	—	188.2100	—	Null	1	0	1	0	0	5696	1129	396	F4672	697.5000	—	—	—	—	ANIL	2013-10-12 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,2090	2090.0000
19	10	0	113285	0	12.0000	0	0	0	12.00	12.00	1955.5556	2750.0000	42	12.5000	2933.3300	20511	20511	43352	20509	20.00	6600.0000	26400.0000	—	2933.3300	—	Null	1	0	1	0	0	5679	12074	1562	B5134	6600.0000	—	—	—	—	ANIL	2013-10-19 00:00:00	1	Pcs	0	12	Null	Null	Null	Null	0	—	0,1050	1050.0000
20	10	0	115175	0	8.0000	0	0	0	8.00	8.00	3306.6667	4650.0000	42	12.5000	3306.6700	20511	20511	43352	20509	20.00	7440.0000	29760.0000	—	3306.6700	—	Null	1	0	1	0	0	5679	12074	1562	D6046	7440.0000	—	—	—	—	ANIL	2013-10-19 00:00:00	1	Pcs	0	8	Null	Null	Null	Null	0	—	0,1644.46	1644.4600
21	10	0	115186	0	8.0000	0	0	0	8.00	8.00	7107.5556	9995.0000	42	12.5000	7107.5600	20511	20511	43352	20509	20.00	15992.0000	63968.0000	—	7107.5600	—	Null	1	0	1	0	0	5679	12074	1562	D6047	15992.0000	—	—	—	—	ANIL	2013-10-19 00:00:00	1	Pcs	0	8	Null	Null	Null	Null	0	—	0,3555.6	3555.6000
22	11	0	70614	16	1.0000	0	0	0	1.00	1.00	3973.3333	7450.0000	42	12.5000	496.6700	20511	20511	0	20509	40.00	2980.0000	4470.0000	—	496.6700	—	Null	1	0	1	0	16	5694	952	1724	0	2980.0000	—	—	—	—	ANIL	2013-10-20 00:00:00	1	Null	0	1	Null	Null	Null	Null	0	—	Null,0	.0000
23	12	0	95876	0	24.0000	0	0	0	24.00	24.00	93.3333	175.0000	42	12.5000	280.0000	20511	20511	0	20509	40.00	1680.0000	2520.0000	—	280.0000	—	Null	1	0	1	0	0	5694	953	1724	O879	1680.0000	—	—	—	—	ANIL	2013-10-20 00:00:00	0	Pcs	0	24	Null	Null	Null	Null	0	—	0,82.5	82.5000
24	12	0	70614	16	1.0000	0	0	0	1.00	1.00	186.6667	350.0000	42	12.5000	23.3300	20511	20511	0	20509	40.00	140.0000	210.0000	—	23.3300	—	Null	1	0	1	0	16	5694	953	1724	0	140.0000	—	—	—	—	ANIL	2013-10-20 00:00:00	0	Null	0	1	Null	Null	Null	Null	0	—	Null,100	100.0000
25	12	0	70614	16	3.0000	0	0	0	3.00	3.00	240.0000	450.0000	42	12.5000	90.0000	20511	20511	0	20509	40.00	540.0000	810.0000	—	90.0000	—	Null	1	0	1	0	16	5694	953	1724	0	540.0000	—	—	—	—	ANIL	2013-10-20 00:00:00	1	Null	0	3	Null	Null	Null	Null	0	—	Null,0	.0000
26	12	0	70614	16	18.0000	0	0	0	18.00	18.00	317.3333	595.0000	42	12.5000	714.0000	20511	20511	0	20509	40.00	4284.0000	6426.0000	—	714.0000	—	Null	1	0	1	0	16	5694	953	1724	0	4284.0000	—	—	—	—	ANIL	2013-10-20 00:00:00	1	Null	0	18	Null	Null	Null	Null	0	—	Null,0	.0000
27	12	0	70614	16	1.0000	0	0	0	1.00	1.00	186.6667	350.0000	42	12.5000	23.3300	20511	20511	0	20509	40.00	140.0000	210.0000	—	23.3300	—	Null	1	0	1	0	16	5694	953	1724	0	140.0000	—	—	—	—	ANIL	2013-10-20 00:00:00	1	Null	0	1	Null	Null	Null	Null	0	—	Null,0	.0000
28	13	0	114300	0	1.0000	0	0	0	1.00	1.00	238.0000	315.0000	42	12.5000	29.7500	20511	20511	0	20509	15.00	47.2500	267.7500	—	29.7500	—	Null	1	0	1	0	0	5694	954	1724	SA1402	47.2500	—	—	—	—	ANIL	2013-10-20 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,168	168.0000
29	13	0	109824	0	1.0000	0	0	0	1.00	1.00	562.6190	695.0000	47	5.0000	28.1300	51681	51681	0	51680	15.00	104.2500	590.7500	—	28.1300	—	Null	1	0	1	0	0	5694	954	1724	SA602	104.2500	—	—	—	—	ANIL	2013-10-20 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,417	417.0000
30	14	0	108862	0	6.0000	0	0	0	6.00	6.00	967.3810	1195.0000	47	5.0000	290.2100	51681	51681	0	51680	15.00	1075.5000	6094.5000	—	290.2100	—	Null	1	0	1	0	0	5687	690	1009	Y1183	1075.5000	—	—	—	—	ANIL	2013-10-22 00:00:00	0	Pcs	0	6	Null	Null	Null	Null	0	—	0,541.5	541.5000
31	15	0	110092	0	1.0000	0	0	0	1.00	1.00	3278.3600	4339.0000	42	12.5000	409.8000	20511	20511	43352	20509	15.00	650.8500	3688.1600	—	409.8000	—	Null	1	0	1	0	0	5679	12305	357	SA625	650.8500	—	—	—	—	ANIL	2013-10-22 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,2431.8	2431.8000
32	16	0	95877	0	12.0000	0	0	0	12.00	12.00	186.6700	350.0000	42	12.5000	280.0000	20511	20511	43352	20509	40.00	1680.0000	2520.0400	—	280.0000	—	Null	1	0	1	0	0	5679	12361	1702	O883	1680.0000	—	—	—	—	ANIL	2013-10-23 00:00:00	1	Pcs	0	12	Null	Null	Null	Null	0	—	0,125	125.0000
33	16	0	95875	0	12.0000	0	0	0	12.00	12.00	264.0000	495.0000	42	12.5000	396.0000	20511	20511	43352	20509	40.00	2376.0000	3564.0000	—	396.0000	—	Null	1	0	1	0	0	5679	12361	1702	O873	2376.0000	—	—	—	—	ANIL	2013-10-23 00:00:00	1	Pcs	0	12	Null	Null	Null	Null	0	—	0,100	100.0000
34	16	0	95874	0	12.0000	0	0	0	12.00	12.00	317.3300	595.0000	42	12.5000	476.0000	20511	20511	43352	20509	40.00	2856.0000	4283.9600	—	476.0000	—	Null	1	0	1	0	0	5679	12361	1702	O872	2856.0000	—	—	—	—	ANIL	2013-10-23 00:00:00	1	Pcs	0	12	Null	Null	Null	Null	0	—	0,150	150.0000
35	16	0	95876	0	12.0000	0	0	0	12.00	12.00	93.3300	175.0000	42	12.5000	140.0000	20511	20511	43352	20509	40.00	840.0000	1259.9600	—	140.0000	—	Null	1	0	1	0	0	5679	12361	1702	O879	840.0000	—	—	—	—	ANIL	2013-10-23 00:00:00	1	Pcs	0	12	Null	Null	Null	Null	0	—	0,82.5	82.5000
36	16	0	95878	0	12.0000	0	0	0	12.00	12.00	66.6700	125.0000	42	12.5000	100.0000	20511	20511	43352	20509	40.00	600.0000	900.0400	—	100.0000	—	Null	1	0	1	0	0	5679	12361	1702	O884	600.0000	—	—	—	—	ANIL	2013-10-23 00:00:00	1	Pcs	0	12	Null	Null	Null	Null	0	—	0,35	35.0000
37	16	0	95879	0	2.0000	0	0	0	2.00	2.00	240.0000	450.0000	42	12.5000	60.0000	20511	20511	43352	20509	40.00	360.0000	540.0000	—	60.0000	—	Null	1	0	1	0	0	5679	12361	1702	O887	360.0000	—	—	—	—	ANIL	2013-10-23 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0,125	125.0000
38	17	0	116455	0	1.0000	0	0	0	1.00	1.00	1624.4400	2150.0000	42	12.5000	203.0600	20511	20511	43352	20509	15.00	322.5000	1827.5000	—	203.0600	—	Null	1	0	1	0	0	5679	13028	357	SA1771	322.5000	—	—	—	—	ANIL	2013-10-27 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,755.56	755.5600
39	18	0	116410	0	1.0000	0	0	0	1.00	1.00	5953.7778	7880.0000	42	12.5000	744.2200	20511	20511	0	20509	15.00	1182.0000	6698.0000	—	744.2200	—	Null	1	0	1	0	0	5709	1623	1425	W1121	1182.0000	—	—	—	—	ANIL	2013-10-27 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,3215.4	3215.4000
40	19	0	111085	0	2.0000	0	0	0	2.00	2.00	1453.0952	1795.0000	47	5.0000	145.3100	51681	51681	0	51680	15.00	538.5000	3051.5000	—	145.3100	—	Null	1	0	1	0	0	5709	1632	481	K3834	538.5000	—	—	—	—	ANIL	2013-10-29 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0,850	850.0000
41	19	0	103375	0	2.0000	0	0	0	2.00	2.00	1736.4286	2145.0000	47	5.0000	173.6400	51681	51681	0	51680	15.00	643.5000	3646.5000	—	173.6400	—	Null	1	0	1	0	0	5709	1632	481	K3381	643.5000	—	—	—	—	ANIL	2013-10-29 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0,950	950.0000
42	19	0	96046	0	2.0000	0	0	0	2.00	2.00	1218.3333	1505.0000	47	5.0000	121.8300	51681	51681	0	51680	15.00	451.5000	2558.5000	—	121.8300	—	Null	1	0	1	0	0	5709	1632	481	K2956	451.5000	—	—	—	—	ANIL	2013-10-29 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0,595	595.0000
43	19	0	113372	0	2.0000	0	0	0	2.00	2.00	2262.6190	2795.0000	47	5.0000	226.2600	51681	51681	0	51680	15.00	838.5000	4751.5000	—	226.2600	—	Null	1	0	1	0	0	5709	1632	481	K3998	838.5000	—	—	—	—	ANIL	2013-10-29 00:00:00	0	Pcs	0	2	Null	Null	Null	Null	0	—	0,1270	1270.0000
44	19	0	74807	0	1.0000	0	0	0	1.00	1.00	1307.3810	1615.0000	47	5.0000	65.3700	51681	51681	0	51680	15.00	242.2500	1372.7500	—	65.3700	—	Null	1	0	1	0	0	5709	1632	481	K1678	242.2500	—	—	—	—	ANIL	2013-10-29 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,600	600.0000
45	19	0	69518	0	4.0000	0	0	0	4.00	4.00	222.6190	275.0000	47	5.0000	44.5200	51681	51681	0	51680	15.00	165.0000	935.0000	—	44.5200	—	Null	1	0	1	0	0	5709	1632	481	W299	165.0000	—	—	—	—	ANIL	2013-10-29 00:00:00	0	Pcs	0	4	Null	Null	Null	Null	0	—	0,121	121.0000
46	19	0	101090	0	1.0000	0	0	0	1.00	1.00	951.1905	1175.0000	47	5.0000	47.5600	51681	51681	0	51680	15.00	176.2500	998.7500	—	47.5600	—	Null	1	0	1	0	0	5709	1632	481	Y1114	176.2500	—	—	—	—	ANIL	2013-10-29 00:00:00	0	Pcs	0	1	Null	Null	Null	Null	0	—	0,532	532.0000
47	20	0	72348	0	2.0000	0	0	0	2.00	2.00	1548.8900	2050.0000	42	12.5000	387.2200	20511	20511	43352	20509	15.00	615.0000	3485.0000	—	387.2200	—	Null	1	0	1	0	0	5679	13545	1728	L1333	615.0000	—	—	—	—	MAIN-02	2013-10-30 00:00:00	1	Pcs	0	2	Null	Null	Null	Null	0	—	0,888.9	888.9000
48	20	0	42230	0	1.0000	0	0	0	1.00	1.00	321.1100	425.0000	42	12.5000	40.1400	20511	20511	43352	20509	15.00	63.7500	361.2500	—	40.1400	—	Null	1	0	1	0	0	5679	13545	1728	B2775	63.7500	—	—	—	—	MAIN-02	2013-10-30 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,200.22	200.2200
49	21	0	114039	0	16.0000	0	0	0	16.00	16.00	1734.0000	2295.0000	42	12.5000	3468.0000	20511	20511	43352	20509	15.00	5508.0000	31212.0000	—	3468.0000	—	Null	1	0	1	0	0	5679	13650	1686	M4763	5508.0000	—	—	—	—	MAIN-02	2013-10-30 00:00:00	1	Pcs	0	16	Null	Null	Null	Null	0	—	0,700	700.0000
50	22	0	44914	0	1.0000	0	0	0	1.00	1.00	6535.5600	8650.0000	42	12.5000	816.9400	20511	20511	43352	20509	15.00	1297.5000	7352.5000	—	816.9400	—	Null	1	0	1	0	0	5679	13714	1562	Q63	1297.5000	—	—	—	—	MAIN-02	2013-10-31 00:00:00	1	Pcs	0	1	Null	Null	Null	Null	0	—	0,3440.043	3440.0430