← Back to Tables

Table: dbo.CashMemoDetRel

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	RelDetID	StkR
1	1	0	172010	0	1.0000	0	0	0	.00	.00	4199.4000	6999.0000	49	12.0000	503.9300	83540	83540	83540	83530	40.0000	2799.6000	4703.3300	—	503.9300	—	Checking	1	0	0	1	0	6427	8015	2214	H4015	2799.6000	C	—	—	—	ANIL	2019-08-11 21:04:25	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	3199.4700	—	—	0	—	0
2	1	0	199610	0	1.0000	0	0	0	.00	.00	1950.0000	3250.0000	49	12.0000	234.0000	83540	83540	83540	83530	40.0000	1300.0000	2184.0000	—	234.0000	—	Checking	1	0	0	1	0	6427	8015	2214	SB3634	1300.0000	C	—	—	—	ANIL	2019-08-11 21:04:25	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1175.0000	—	—	0	—	0
3	1	0	199990	0	1.0000	0	0	0	.00	.00	2340.0000	3900.0000	49	12.0000	280.8000	83540	83540	83540	83530	40.0000	1560.0000	2620.8000	—	280.8000	—	Checking	1	0	0	1	0	6427	8015	2214	SB3697	1560.0000	C	—	—	—	ANIL	2019-08-11 21:04:25	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1657.1400	—	—	0	—	0
4	1	0	198515	0	1.0000	0	0	0	.00	.00	2334.0000	3890.0000	49	12.0000	280.0800	83540	83540	83540	83530	40.0000	1556.0000	2614.0800	—	280.0800	—	Checking	1	0	0	1	0	6427	8015	2214	P5035	1556.0000	C	—	—	—	ANIL	2019-08-11 21:04:25	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1275.0000	—	—	0	—	0
5	2	0	42789	0	12.0000	0	0	0	.00	.00	237.0000	395.0000	50	18.0000	511.9200	83541	83541	83541	83531	40.0000	1896.0000	3355.9200	—	511.9200	—	Checking	1	0	0	1	0	6426	7917	357	C1522	1896.0000	C	—	—	—	ANIL	2019-08-11 21:21:24	1	Pcs	0	12.00	14	0	0	12.00	0	0	0	128.1600	—	—	0	—	0
6	2	0	42787	0	12.0000	0	0	0	.00	.00	294.0000	490.0000	50	18.0000	635.0400	83541	83541	83541	83531	40.0000	2352.0000	4163.0400	—	635.0400	—	Checking	1	0	0	1	0	6426	7917	357	C1520	2352.0000	C	—	—	—	ANIL	2019-08-11 21:21:24	1	Pcs	0	12.00	14	0	0	12.00	0	0	0	176.2200	—	—	0	—	0
7	2	0	52783	0	12.0000	0	0	0	.00	.00	192.0000	320.0000	50	18.0000	414.7200	83541	83541	83541	83531	40.0000	1536.0000	2718.7200	—	414.7200	—	Checking	1	0	0	1	0	6426	7917	357	C193	1536.0000	C	—	—	—	ANIL	2019-08-11 21:21:24	1	Pcs	0	12.00	14	0	0	12.00	0	0	0	141.5100	—	—	0	—	0
8	2	0	42792	0	6.0000	0	0	0	.00	.00	243.7500	325.0000	50	18.0000	263.2500	83541	83541	83541	83531	25.0000	487.5000	1725.7500	—	263.2500	—	Checking	1	0	0	1	0	6426	7917	357	C1525	487.5000	C	—	—	—	ANIL	2019-08-11 21:21:24	1	Pcs	0	6.00	14	0	0	6.00	0	0	0	149.5200	—	—	0	—	0
9	2	0	49767	0	1.0000	0	0	0	.00	.00	393.7500	525.0000	50	18.0000	70.8800	83541	83541	83541	83531	25.0000	131.2500	464.6300	—	70.8800	—	Checking	1	0	0	1	0	6426	7917	357	C1821	131.2500	C	—	—	—	ANIL	2019-08-11 21:21:24	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	242.9700	—	—	0	—	0
10	2	0	200600	0	2.0000	0	0	0	.00	.00	1089.6700	1450.0000	50	18.0000	392.2800	83541	83541	83541	83531	24.8500	720.6500	2571.6200	—	392.2800	—	Checking	1	0	0	1	0	6426	7917	357	H4610	720.6500	C	—	—	—	ANIL	2019-08-11 21:21:24	0	Pcs	0	2.00	14	0	0	2.00	0	0	0	673.7600	—	—	0	—	0
11	3	0	195723	0	1.0000	0	0	0	.00	.00	3414.4196	4499.0000	49	12.0000	409.7300	83540	83540	83540	83530	15.0000	674.8500	3824.1500	—	409.7300	—	Checking	1	0	1	0	0	6665	6760	2214	SB2849	674.8500	C	—	—	4499.0000	ANIL	2021-06-27 20:24:44	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	2410.0000	—	—	0	331067	0
12	3	0	221905	0	1.0000	0	0	0	.00	.00	2050.0000	3280.0000	49	12.0000	246.0000	83540	83540	83540	83530	30.0000	984.0000	2296.0000	—	246.0000	—	Checking	1	0	1	0	0	6665	6760	2214	SB7036	984.0000	C	—	—	3280.0000	ANIL	2021-06-27 20:24:44	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	984.7500	—	—	0	331068	0
13	3	0	171547	0	1.0000	0	0	0	.00	.00	4374.3750	6999.0000	49	12.0000	524.9200	83540	83540	83540	83530	30.0000	2099.7000	4899.3000	—	524.9200	—	Checking	1	0	1	0	0	6665	6760	2214	M8633	2099.7000	C	—	—	6999.0000	ANIL	2021-06-27 20:24:44	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	3221.3142	—	—	0	331069	0
14	3	0	168800	0	1.0000	0	0	0	.00	.00	3737.5000	5980.0000	49	12.0000	448.5000	83540	83540	83540	83530	30.0000	1794.0000	4186.0000	—	448.5000	—	Checking	1	0	1	0	0	6665	6760	2214	B8125	1794.0000	C	—	—	5980.0000	ANIL	2021-06-27 20:24:44	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	2208.7500	—	—	0	331070	0
15	3	0	228760	0	1.0000	0	0	0	.00	.00	5678.5714	7950.0000	49	12.0000	681.4300	83540	83540	83540	83530	20.0000	1590.0000	6360.0000	—	681.4300	—	Checking	1	0	1	0	0	6668	6926	1685	DA7110	1590.0000	C	—	—	7950.0000	ANIL	2021-06-27 20:24:44	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	3502.1750	—	—	0	331071	0
16	4	0	160230	0	44.0000	0	0	0	.00	.00	616.0714	1095.0000	49	12.0000	3252.8600	83540	83540	83540	83530	36.9863	17820.0000	30360.0000	—	3252.8600	—	Checking	1	0	1	0	0	6729	2008	1698	N2235	17820.0000	C	—	—	1095.0000	ANIL	2021-10-10 18:50:36	0	Pcs	0	44.00	14	0	0	44.00	0	0	0	503.4300	—	—	0	344816	0
17	5	0	207848	44	1.0000	0	0	0	.00	.00	10700.0000	14980.0000	49	12.0000	1091.4000	83540	83540	83540	83530	20.0000	2996.0000	11984.0000	—	1284.0000	—	Checking	1	0	1	0	44	6751	3985	1685	0	2996.0000	—	—	—	.0000	ANIL	2021-11-01 16:36:04	1	—	0	1.00	—	—	—	1.00	0	0	Null	5880.5000	—	—	0	352140	0
18	6	0	237140	0	1.0000	0	0	0	.00	.00	952.2571	2999.0000	55	5.0000	47.6100	83539	83539	83539	83564	66.6600	1999.1300	999.8700	—	47.6100	—	Checking	1	0	1	0	0	6760	4728	2214	L6456	1999.1300	C	—	—	2999.0000	ANIL	2021-11-03 14:25:38	0	Pcs	0	1.00	14	0	0	1.00	0	0	0	760.0000	—	—	0	353059	0
19	6	0	242564	0	2.0000	0	0	0	.00	.00	952.2571	2999.0000	55	5.0000	95.2300	83539	83539	83539	83564	66.6600	3998.2700	1999.7400	—	95.2300	—	Checking	1	0	1	0	0	6760	4728	2214	L6741	3998.2700	C	—	—	2999.0000	ANIL	2021-11-03 14:25:38	0	Pcs	0	2.00	14	0	0	2.00	0	0	0	695.0000	—	—	0	353060	0
20	7	0	237402	0	4.0000	0	0	0	.00	.00	4664.6875	9499.0000	49	12.0000	2239.0500	83540	83540	83540	83530	45.0000	17098.2000	20897.8000	—	2239.0500	—	Checking	1	0	1	0	0	6762	4979	2214	L6468	17098.2000	C	—	—	9499.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	4.00	14	0	0	4.00	0	0	0	5089.2900	—	—	0	354299	0
21	7	0	237399	0	13.0000	0	0	0	.00	.00	1718.2589	3499.0000	49	12.0000	2680.4800	83540	83540	83540	83530	45.0000	20469.1500	25017.8500	—	2680.4800	—	Checking	1	0	1	0	0	6762	4979	2214	L6465	20469.1500	C	—	—	3499.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	13.00	14	0	0	13.00	0	0	0	1562.5000	—	—	0	354300	0
22	7	0	241262	0	6.0000	0	0	0	.00	.00	1450.3125	2499.0000	49	12.0000	1044.2200	83540	83540	83540	83530	35.0000	5247.9000	9746.1000	—	1044.2200	—	Checking	1	0	1	0	0	6762	4979	2214	T4087	5247.9000	C	—	—	2499.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	6.00	14	0	0	6.00	0	0	0	870.0000	—	—	0	354301	0
23	7	0	230989	0	1.0000	0	0	0	.00	.00	3655.6696	6299.0000	49	12.0000	438.6800	83540	83540	83540	83530	35.0000	2204.6500	4094.3500	—	438.6800	—	Checking	1	0	1	0	0	6762	4979	2214	SB8388	2204.6500	C	—	—	6299.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	2008.4800	—	—	0	354302	0
24	7	0	237401	0	17.0000	0	0	0	.00	.00	1472.7232	2999.0000	49	12.0000	3004.3600	83540	83540	83540	83530	45.0000	22942.3500	28040.6500	—	3004.3600	—	Checking	1	0	1	0	0	6762	4979	2214	L6467	22942.3500	C	—	—	2999.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	17.00	14	0	0	17.00	0	0	0	1339.2900	—	—	0	354303	0
25	8	0	237402	0	4.0000	0	0	0	.00	.00	4664.6875	9499.0000	49	12.0000	2239.0500	83540	83540	83540	83530	45.0000	17098.2000	20897.8000	—	2239.0500	—	Checking	1	0	1	0	0	6762	4979	2214	L6468	17098.2000	C	—	—	9499.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	4.00	14	0	0	4.00	0	0	0	5089.2900	—	—	0	354299	0
26	8	0	237399	0	13.0000	0	0	0	.00	.00	1718.2589	3499.0000	49	12.0000	2680.4800	83540	83540	83540	83530	45.0000	20469.1500	25017.8500	—	2680.4800	—	Checking	1	0	1	0	0	6762	4979	2214	L6465	20469.1500	C	—	—	3499.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	13.00	14	0	0	13.00	0	0	0	1562.5000	—	—	0	354300	0
27	8	0	241262	0	6.0000	0	0	0	.00	.00	1450.3125	2499.0000	49	12.0000	1044.2200	83540	83540	83540	83530	35.0000	5247.9000	9746.1000	—	1044.2200	—	Checking	1	0	1	0	0	6762	4979	2214	T4087	5247.9000	C	—	—	2499.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	6.00	14	0	0	6.00	0	0	0	870.0000	—	—	0	354301	0
28	8	0	230989	0	1.0000	0	0	0	.00	.00	3655.6696	6299.0000	49	12.0000	438.6800	83540	83540	83540	83530	35.0000	2204.6500	4094.3500	—	438.6800	—	Checking	1	0	1	0	0	6762	4979	2214	SB8388	2204.6500	C	—	—	6299.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	2008.4800	—	—	0	354302	0
29	8	0	237401	0	17.0000	0	0	0	.00	.00	1472.7232	2999.0000	49	12.0000	3004.3600	83540	83540	83540	83530	45.0000	22942.3500	28040.6500	—	3004.3600	—	Checking	1	0	1	0	0	6762	4979	2214	L6467	22942.3500	C	—	—	2999.0000	ANIL	2021-11-12 16:06:38	1	Pcs	0	17.00	14	0	0	17.00	0	0	0	1339.2900	—	—	0	354303	0
30	9	0	205866	0	1.0000	0	0	0	.00	.00	3140.0000	6280.0000	49	12.0000	376.8000	83540	83540	83540	83530	50.0000	3140.0000	3516.8000	—	376.8000	—	Checking	1	0	0	1	0	6778	6285	2448	MA1738	3140.0000	C	—	—	6280.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1694.6858	—	—	0	357832	0
31	9	0	244716	0	1.0000	0	0	0	.00	.00	7187.5000	11500.0000	49	12.0000	862.5000	83540	83540	83540	83530	30.0000	3450.0000	8050.0000	—	862.5000	—	Checking	1	0	1	0	0	6778	6282	1685	MA5011	3450.0000	C	—	—	11500.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	3654.0000	—	—	0	357833	0
32	9	0	238943	0	1.0000	0	0	0	.00	.00	3078.1250	4925.0000	49	12.0000	369.3800	83540	83540	83540	83530	30.0000	1477.5000	3447.5000	—	369.3800	—	Checking	1	0	1	0	0	6778	6282	1685	MA4525	1477.5000	C	—	—	4925.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1940.0000	—	—	0	357834	0
33	9	0	127714	0	1.0000	0	0	0	.00	.00	2175.0000	3480.0000	49	12.0000	261.0000	83540	83540	83540	83530	30.0000	1044.0000	2436.0000	—	261.0000	—	Checking	1	0	1	0	0	6778	6283	2214	V2038	1044.0000	C	—	—	3480.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1350.0000	—	—	0	357835	0
34	9	0	119953	0	1.0000	0	0	0	.00	.00	1612.5000	2580.0000	49	12.0000	193.5000	83540	83540	83540	83530	30.0000	774.0000	1806.0000	—	193.5000	—	Checking	1	0	1	0	0	6778	6283	2214	N1437	774.0000	C	—	—	2580.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	850.0000	—	—	0	357836	0
35	9	0	224606	0	2.0000	0	0	0	.00	.00	1156.2500	1850.0000	49	12.0000	277.5000	83540	83540	83540	83530	30.0000	1110.0000	2590.0000	—	277.5000	—	Checking	1	0	1	0	0	6778	6283	2214	BA559	1110.0000	C	—	—	1850.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	2.00	14	0	0	2.00	0	0	0	825.0000	—	—	0	357837	0
36	9	0	241615	0	1.0000	0	0	0	.00	.00	3681.2500	5890.0000	49	12.0000	441.7500	83540	83540	83540	83530	30.0000	1767.0000	4123.0000	—	441.7500	—	Checking	1	0	1	0	0	6778	6283	2214	MA4799	1767.0000	C	—	—	5890.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	2090.0000	—	—	0	357838	0
37	9	0	228797	0	1.0000	0	0	0	.00	.00	559.3750	895.0000	49	12.0000	67.1200	83540	83540	83540	83530	30.0000	268.5000	626.5000	—	67.1200	—	Checking	1	0	1	0	0	6778	6284	2592	RA4148	268.5000	C	—	—	895.0000	ANIL	2021-12-17 16:15:04	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	375.0000	—	—	0	357839	1
38	9	0	246022	0	2.0000	0	0	0	.00	.00	683.9286	1395.0000	49	12.0000	164.1400	83540	83540	83540	83530	45.0896	1258.0000	1532.0000	—	164.1400	—	Checking	1	0	1	0	0	6778	6284	2592	SC511	1258.0000	C	—	—	1395.0000	ANIL	2021-12-17 16:15:04	0	Pcs	0	2.00	14	0	0	2.00	0	0	0	384.7500	—	—	0	357840	0
39	10	0	242837	0	1.0000	0	0	0	.00	.00	3408.0000	5680.0000	49	12.0000	408.9600	83540	83540	83540	83530	40.0000	2272.0000	3816.9600	—	408.9600	—	Checking	1	0	0	1	0	6778	6289	2448	FA4379	2272.0000	C	—	—	5680.0000	ANIL	2021-12-17 16:18:07	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1961.1000	—	—	0	357842	0
40	10	0	243650	0	2.0000	0	0	0	.00	.00	455.0000	650.0000	55	5.0000	45.5000	83539	83539	83539	83564	30.0000	390.0000	955.5000	—	45.5000	—	Checking	1	0	0	1	0	6778	6288	2413	KA2796	390.0000	C	—	—	650.0000	ANIL	2021-12-17 16:18:07	1	Pcs	0	2.00	14	0	0	2.00	0	0	0	350.0000	—	—	0	357843	0
41	10	0	237138	0	4.0000	0	0	0	.00	.00	385.0000	550.0000	55	5.0000	77.0000	83539	83539	83539	83564	30.0000	660.0000	1617.0000	—	77.0000	—	Checking	1	0	0	1	0	6778	6288	2413	A9421	660.0000	C	—	—	550.0000	ANIL	2021-12-17 16:18:07	1	Pcs	0	4.00	14	0	0	4.00	0	0	0	215.0000	—	—	0	357844	0
42	10	0	228797	0	1.0000	0	0	0	.00	.00	559.3750	895.0000	49	12.0000	67.1200	83540	83540	83540	83530	30.0000	268.5000	626.5000	—	67.1200	—	Checking	1	0	1	0	0	6778	6287	2592	RA4148	268.5000	C	—	—	895.0000	ANIL	2021-12-17 16:18:07	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	375.0000	—	—	0	357845	1
43	10	0	187772	0	2.0000	0	0	0	.00	.00	621.8750	995.0000	49	12.0000	149.2500	83540	83540	83540	83530	30.0000	597.0000	1393.0000	—	149.2500	—	Checking	1	0	1	0	0	6778	6287	2592	O3492	597.0000	C	—	—	995.0000	ANIL	2021-12-17 16:18:07	1	Pcs	0	2.00	14	0	0	2.00	0	0	0	479.8000	—	—	0	357846	0
44	10	0	228045	0	1.0000	0	0	0	.00	.00	2499.3750	3999.0000	49	12.0000	299.9200	83540	83540	83540	83530	30.0000	1199.7000	2799.3000	—	299.9200	—	Checking	1	0	1	0	0	6778	6286	2873	BA736	1199.7000	C	—	—	3999.0000	ANIL	2021-12-17 16:18:07	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1713.7100	—	—	0	357847	0
45	10	0	237399	0	1.0000	0	0	0	.00	.00	2186.8750	3499.0000	49	12.0000	262.4200	83540	83540	83540	83530	30.0000	1049.7000	2449.3000	—	262.4200	—	Checking	1	0	1	0	0	6778	6286	2873	L6465	1049.7000	C	—	—	3499.0000	ANIL	2021-12-17 16:18:07	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	1562.5000	—	—	0	357848	0
46	11	0	244716	0	1.0000	0	0	0	.00	.00	7187.5000	11500.0000	49	12.0000	862.5000	83540	83540	83540	83530	30.0000	3450.0000	8050.0000	—	862.5000	—	Checking	1	0	1	0	0	6783	6676	1685	MA5011	3450.0000	C	—	—	11500.0000	MAIN-01	2021-12-27 18:13:29	1	Pcs	0	1.00	14	0	0	1.00	0	0	0	3654.0000	—	—	0	358998	0
47	11	0	243650	0	2.0000	0	0	0	.00	.00	455.0000	650.0000	55	5.0000	45.5000	83539	83539	83539	83564	30.0000	390.0000	955.5000	—	45.5000	—	Checking	1	0	0	1	0	6782	6557	2972	KA2796	390.0000	C	—	—	650.0000	MAIN-01	2021-12-27 18:13:29	1	Pcs	0	2.00	14	0	0	2.00	0	0	0	350.0000	—	—	0	358999	0
48	11	0	125486	0	2.0000	0	0	0	.00	.00	216.5254	365.0000	50	18.0000	77.9500	83541	83541	83541	83531	30.0000	219.0000	511.0000	—	77.9500	—	Checking	1	0	1	0	0	6782	6557	2972	A4182	219.0000	C	—	—	365.0000	MAIN-01	2021-12-27 18:13:29	1	Pcs	0	2.00	14	0	0	2.00	0	0	0	140.0000	—	—	0	359000	0
49	12	0	183133	0	1.0000	0	0	0	.00	.00	8470.3390	9995.0000	50	18.0000	1138.8360	83541	83541	83541	83531	.0000	.0000	9995.0000	—	1524.6600	—	Checking	1	0	1	0	0	6786	6975	357	P4543	.0000	C	—	—	9995.0000	ANIL	2022-01-25 18:33:18	0	Pcs	0	1.00	14	0	0	1.00	0	0	0	5932.2000	—	—	0	361169	0
50	12	0	246669	0	1.0000	0	0	0	.00	.00	6232.1429	6980.0000	49	12.0000	558.6097	83540	83540	83540	83530	.0000	.0000	6980.0000	—	747.8600	—	Checking	1	0	1	0	0	6786	6975	357	FA4786	.0000	C	—	—	6980.0000	ANIL	2022-01-25 18:33:18	0	Pcs	0	1.00	14	0	0	1.00	0	0	0	2568.6000	—	—	0	361170	0