← Back to Tables

Table: dbo.BookReceiptDet

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	AliasName	IUnit	SiteManId	TQty	TsectionID	TGrndetID	TBarID	TTQty	BSectionID	TConsignID	ICost
1	1	0	112107	0	1.00	.00	.00	.00	1.00	1.00	1088.8900	1225.0000	42	12.5000	136.1100	20511	20511	43352	20509	.0000	.0000	1225.0000	—	136.1100	—	—	1	0	1	0	0	16	1	251	D5719	.0000	C	—	—	—	POS-GIFT3	2013-09-16 12:25:44	0	—	Pcs	—	1	Null	Null	Null	Null	14	0	490.0000
2	1	0	110683	0	1.00	.00	.00	.00	1.00	1.00	623.3300	825.0000	42	12.5000	77.9200	20511	20511	43352	20509	15.0000	123.7500	701.2500	—	77.9200	—	—	1	0	1	0	0	16	1	251	A3342	123.7500	C	—	—	—	POS-GIFT3	2013-09-16 12:25:44	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	439.9700
3	2	0	101918	0	4.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10001	1562	C2398	330.0000	C	—	—	—	POS-GIFT1	2013-09-16 13:52:33	1	—	Pcs	—	4	Null	Null	Null	Null	14	0	181.8750
4	2	0	101913	0	4.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10001	1562	C2393	330.0000	C	—	—	—	POS-GIFT1	2013-09-16 13:52:33	1	—	Pcs	—	4	Null	Null	Null	Null	14	0	181.8750
5	3	0	101909	0	2.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10002	1562	C2389	105.0000	C	—	—	—	POS-GIFT1	2013-09-16 13:57:48	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	111.5625
6	3	0	87609	0	3.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10002	1562	C1855	247.5000	C	—	—	—	POS-GIFT1	2013-09-16 13:57:48	1	—	Pcs	—	3	Null	Null	Null	Null	14	0	196.0000
7	4	0	43859	0	10.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10003	539	A1719	247.5000	C	—	—	—	POS-GIFT1	2013-09-16 17:59:53	1	—	Pcs	—	10	Null	Null	Null	Null	14	0	78.0000
8	4	0	90112	0	4.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10003	539	K2563	165.0000	C	—	—	—	POS-GIFT1	2013-09-16 17:59:53	1	—	Pcs	—	4	Null	Null	Null	Null	14	0	116.0000
9	4	0	99219	0	2.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10003	539	M3764	127.5000	C	—	—	—	POS-GIFT1	2013-09-16 17:59:53	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	210.0000
10	4	0	90111	0	4.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10003	539	K2562	165.0000	C	—	—	—	POS-GIFT1	2013-09-16 17:59:53	1	—	Pcs	—	4	Null	Null	Null	Null	14	0	116.0000
11	5	0	69590	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10004	357	F1706	102.0000	C	—	—	—	POS-GIFT1	2013-09-16 18:01:32	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	392.8900
12	6	0	83256	0	1.00	.00	.00	.00	1.00	1.00	600.0000	675.0000	42	12.5000	75.0000	20511	20511	43352	20509	.0000	.0000	675.0000	—	75.0000	—	—	1	0	1	0	0	5679	10005	1562	P1535	.0000	C	—	—	—	POS-GIFT1	2013-09-16 18:09:32	0	—	Pcs	—	1	Null	Null	Null	Null	14	0	143.5500
13	6	0	83255	0	2.00	.00	.00	.00	2.00	2.00	600.0000	675.0000	42	12.5000	150.0000	20511	20511	43352	20509	.0000	.0000	1350.0000	—	150.0000	—	—	1	0	1	0	0	5679	10005	1562	P1534	.0000	C	—	—	—	POS-GIFT1	2013-09-16 18:09:32	0	—	Pcs	—	2	Null	Null	Null	Null	14	0	190.5700
14	7	0	111189	0	2.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10006	1521	L2969	50.4000	C	—	—	—	POS-BEDGF	2013-09-16 21:12:26	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	80.0000
15	7	0	108731	0	3.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10006	1521	L2858	80.1000	C	—	—	—	POS-BEDGF	2013-09-16 21:12:26	1	—	Pcs	—	3	Null	Null	Null	Null	14	0	83.0000
16	8	0	111189	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10007	1521	L2969	25.2000	C	—	—	—	POS-BEDGF	2013-09-16 21:23:24	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	80.0000
17	9	0	86269	0	2.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10008	1562	B3708	19.5000	C	—	—	—	POS-GIFT1	2013-09-16 19:38:38	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	30.0000
18	9	0	101148	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10008	1562	B4550	17.2500	C	—	—	—	POS-GIFT1	2013-09-16 19:38:38	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	50.0000
19	9	0	69589	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10008	1562	F1695	217.5000	C	—	—	—	POS-GIFT1	2013-09-16 19:38:38	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	590.0000
20	9	0	112445	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10008	1562	B5099	551.2500	C	—	—	—	POS-GIFT1	2013-09-16 19:38:38	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	1800.0000
21	10	0	75323	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10009	357	A1221	277.5000	C	—	—	—	POS-GIFT1	2013-09-16 19:38:56	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	1432.0000
22	11	0	94994	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10010	1562	A2715	519.7500	C	—	—	—	POS-GIFT1	2013-09-16 19:48:25	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	2002.0000
23	11	0	49383	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10010	1562	B3278	91.5000	C	—	—	—	POS-GIFT1	2013-09-16 19:48:25	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	345.8600
24	12	0	91500	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10011	35	F3307	74.2500	C	—	—	—	POS-GIFT1	2013-09-16 19:53:51	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	211.5000
25	12	0	110023	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10011	35	F4551	48.7500	C	—	—	—	POS-GIFT1	2013-09-16 19:53:51	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	170.0000
26	13	0	93622	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10012	1425	S8304	63.7500	C	—	—	—	POS-GIFT1	2013-09-16 20:09:12	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	190.0000
27	14	0	112073	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10013	1009	SA881	81.7500	C	—	—	—	POS-BEDGF	2013-09-17 14:43:49	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	255.0000
28	15	0	69019	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10014	1562	L1125	14.8500	C	—	—	—	POS-GIFT1	2013-09-17 12:05:47	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	55.4800
29	15	0	108377	0	2.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10014	1562	SA439	36.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:05:47	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	72.0000
30	15	0	108379	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10014	1562	SA441	27.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:05:47	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	108.0000
31	15	0	111553	0	2.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10014	1562	L2994	244.5000	C	—	—	—	POS-GIFT1	2013-09-17 12:05:47	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	456.7600
32	15	0	98198	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10014	1562	L2104	23.2500	C	—	—	—	POS-GIFT1	2013-09-17 12:05:47	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	86.8700
33	16	0	110483	0	1.00	.00	.00	.00	1.00	1.00	825.7100	1020.0000	47	5.0000	41.2900	51681	51681	43352	51680	15.0000	153.0000	867.0000	—	41.2900	—	—	1	0	1	0	0	5679	10015	594	N1382	153.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:06:21	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	631.4800
34	17	0	59469	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10016	1652	B769	56.8500	C	—	—	—	POS-BEDGF	2013-09-17 14:51:43	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	243.7468
35	18	0	95867	0	6.00	.00	.00	.00	6.00	6.00	528.8900	595.0000	42	12.5000	396.6700	20511	20511	43352	20509	.0000	.0000	3570.0100	—	396.6700	—	—	1	0	1	0	0	5679	10017	1562	O845	.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:11:00	0	—	Pcs	—	6	Null	Null	Null	Null	14	0	150.0000
36	18	0	95868	0	6.00	.00	.00	.00	6.00	6.00	440.0000	495.0000	42	12.5000	330.0000	20511	20511	43352	20509	.0000	.0000	2970.0000	—	330.0000	—	—	1	0	1	0	0	5679	10017	1562	O849	.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:11:00	0	—	Pcs	—	6	Null	Null	Null	Null	14	0	100.0000
37	18	0	95870	0	6.00	.00	.00	.00	6.00	6.00	311.1100	350.0000	42	12.5000	233.3300	20511	20511	43352	20509	.0000	.0000	2099.9900	—	233.3300	—	—	1	0	1	0	0	5679	10017	1562	O860	.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:11:00	0	—	Pcs	—	6	Null	Null	Null	Null	14	0	125.0000
38	18	0	95869	0	6.00	.00	.00	.00	6.00	6.00	155.5600	175.0000	42	12.5000	116.6700	20511	20511	43352	20509	.0000	.0000	1050.0300	—	116.6700	—	—	1	0	1	0	0	5679	10017	1562	O857	.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:11:00	0	—	Pcs	—	6	Null	Null	Null	Null	14	0	82.5000
39	18	0	95872	0	2.00	.00	.00	.00	2.00	2.00	400.0000	450.0000	42	12.5000	100.0000	20511	20511	43352	20509	.0000	.0000	900.0000	—	100.0000	—	—	1	0	1	0	0	5679	10017	1562	O870	.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:11:00	0	—	Pcs	—	2	Null	Null	Null	Null	14	0	125.0000
40	18	0	95871	0	6.00	.00	.00	.00	6.00	6.00	111.1100	125.0000	42	12.5000	83.3300	20511	20511	43352	20509	.0000	.0000	749.9900	—	83.3300	—	—	1	0	1	0	0	5679	10017	1562	O869	.0000	C	—	—	—	POS-GIFT1	2013-09-17 12:11:00	0	—	Pcs	—	6	Null	Null	Null	Null	14	0	35.0000
41	19	0	98737	0	1.00	.00	.00	.00	1.00	1.00	9062.8900	11995.0000	42	12.5000	1132.8600	20511	20511	43352	20509	15.0000	1799.2500	10195.7500	—	1132.8600	—	—	1	0	1	0	0	5679	10018	1562	S9100	1799.2500	C	—	—	—	POS-GIFT1	2013-09-17 12:31:13	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	5940.0000
42	19	0	53642	0	3.00	.00	.00	.00	3.00	3.00	117.1100	155.0000	42	12.5000	43.9200	20511	20511	43352	20509	15.0000	69.7500	395.2500	—	43.9200	—	—	1	0	1	0	0	5679	10018	1562	B277	69.7500	C	—	—	—	POS-GIFT1	2013-09-17 12:31:13	1	—	Pcs	—	3	Null	Null	Null	Null	14	0	75.0000
43	19	0	94174	0	2.00	.00	.00	.00	2.00	2.00	210.8000	279.0000	42	12.5000	52.7000	20511	20511	43352	20509	15.0000	83.7000	474.3000	—	52.7000	—	—	1	0	1	0	0	5679	10018	1562	V1010	83.7000	C	—	—	—	POS-GIFT1	2013-09-17 12:31:13	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	164.9200
44	19	0	94171	0	1.00	.00	.00	.00	1.00	1.00	120.1300	159.0000	42	12.5000	15.0200	20511	20511	43352	20509	15.0000	23.8500	135.1500	—	15.0200	—	—	1	0	1	0	0	5679	10018	1562	V1007	23.8500	C	—	—	—	POS-GIFT1	2013-09-17 12:31:13	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	93.9800
45	20	0	45593	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10019	1636	D2162	138.7500	C	—	—	—	POS-GIFT1	2013-09-17 12:31:41	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	200.0000
46	21	0	56361	0	1.00	.00	.00	.00	1.00	1.00	751.7800	995.0000	42	12.5000	93.9700	20511	20511	43352	20509	15.0000	149.2500	845.7500	—	93.9700	—	—	1	0	1	0	0	5679	10020	1009	F477	149.2500	C	—	—	—	POS-BEDGF	2013-09-17 15:27:49	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	575.0000
47	22	0	49389	0	1.00	.00	.00	.00	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	—	—	1	0	1	0	0	5679	10021	1562	B3284	102.0000	C	—	—	—	POS-GIFT1	2013-09-17 14:07:58	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	409.3200
48	23	0	101756	0	2.00	.00	.00	.00	2.00	2.00	259.0500	320.0000	47	5.0000	25.9000	51681	51681	43352	51680	15.0000	96.0000	544.0000	—	25.9000	—	—	1	0	1	0	0	5679	10022	1009	M3947	96.0000	C	—	—	—	POS-BEDGF	2013-09-17 17:13:50	1	—	Pcs	—	2	Null	Null	Null	Null	14	0	140.0000
49	23	0	102471	0	1.00	.00	.00	.00	1.00	1.00	222.6200	275.0000	47	5.0000	11.1300	51681	51681	43352	51680	15.0000	41.2500	233.7500	—	11.1300	—	—	1	0	1	0	0	5679	10022	1009	K3301	41.2500	C	—	—	—	POS-BEDGF	2013-09-17 17:13:50	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	116.0000
50	23	0	102470	0	1.00	.00	.00	.00	1.00	1.00	222.6200	275.0000	47	5.0000	11.1300	51681	51681	43352	51680	15.0000	41.2500	233.7500	—	11.1300	—	—	1	0	1	0	0	5679	10022	1009	K3300	41.2500	C	—	—	—	POS-BEDGF	2013-09-17 17:13:50	1	—	Pcs	—	1	Null	Null	Null	Null	14	0	116.0000