← Back to Tables

Table: dbo.AliasItem

AliasID	ItemName	Code	UnitID	PlaceID	Discountable	DiscountRange	Taxapp	TaxPaid	TaxRate1	TaxRate2	Job	UserName	UseDate	PurchID	Rel	ITID	AFloorID	AplComb	UptoAmt	UptoTax1	UptoTax2	AfterAmt	AfterTax1	AfterTax2	PurchCID	Exp	HSNCODE	GSTID	UpToPurchID	UpToPurchCID	AfterPurchID	AfterPurchCID
5	FURNISHING FABRICS	123	1	14	0	.00	1	0	55	56	0	ANIL	2016-04-01 11:20:20	83554	0	0	13	0	.0000	0	0	.0000	0	0	83560	0	—	—	—	—	—	—
6	BED SHEET	23	2	11	0	.00	1	0	55	56	0	ANIL	2010-12-09 13:09:55	83554	1	70613	12	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
7	PILLOW COV	2	2	11	0	.00	1	0	55	56	0	ANIL	2012-02-21 13:08:57	83554	0	0	12	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
8	CURTAIN CLOTH	3	1	8	0	.00	1	0	55	56	1	Anil	2009-03-22 14:27:34	83554	0	0	13	0	.0000	0	0	.0000	0	0	83560	0	—	—	0	0	0	0
13	P,V.C TILE	P.V.C TILE	2	8	0	.00	1	0	49	52	0	Anil	2005-09-13 16:11:23	83543	0	0	40	0	.0000	0	0	.0000	0	0	83561	0	—	—	—	—	—	—
14	SPRING MATTRESSES	SPRING MAT	2	11	0	.00	1	0	50	53	0	ANIL	2012-02-21 13:08:34	83544	1	54775	18	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
15	H/L DARI	DARI	2	8	0	.00	1	0	55	56	0	ANIL	2008-05-01 13:29:30	83554	0	0	20	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
16	CROCKERY ITEM	CROCKERY	2	8	0	.00	1	0	49	52	0	HARSH	2009-05-05 14:20:35	83543	1	70614	19	0	.0000	0	0	.0000	0	0	83561	0	—	—	0	0	0	0
19	TOWEL	TOWEL	2	11	0	.00	1	0	55	56	0	ANIL	2010-12-09 13:10:59	83554	1	70615	23	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
22	DIVINITI	DIVINITI	2	8	0	.00	0	0	—	—	0	GIFT	2008-05-01 13:31:12	2733	0	0	19	0	.0000	—	—	.0000	—	—	28409	0	—	—	—	—	—	—
23	QUILT	QUILT	2	11	0	.00	1	0	55	56	0	ANIL	2012-02-21 13:08:46	83554	0	79172	17	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
24	BED COVER	BED COVER	2	11	0	.00	1	0	55	56	0	ANIL	2010-12-09 13:09:40	83554	0	133810	53	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
25	MISC ITEM	MICS MICS	2	8	0	.00	0	0	—	—	1	Anil	2008-09-06 12:58:37	2733	0	0	13	0	.0000	—	—	.0000	—	—	28409	0	—	—	—	—	—	—
26	CUR LINING	LINING	1	8	0	.00	1	0	55	56	0	Anil	2009-03-22 14:50:21	83554	0	0	13	0	.0000	0	0	.0000	0	0	83554	0	—	—	—	—	—	—
27	CUSHION	CUSHION	2	11	0	.00	1	0	50	53	0	ANIL	2011-10-17 14:14:48	83544	0	125528	16	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
28	T FABRICS	T FABRICS	2	8	0	.00	1	0	55	56	0	Anil	2009-03-22 14:50:33	83554	1	54791	46	0	.0000	0	0	.0000	0	0	83560	0	—	—	0	0	0	0
29	FLOWER	FLOWER	2	8	0	.00	1	0	50	53	0	Anil	2005-09-13 16:09:04	83544	0	0	21	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
30	DRAPERY ROD	DRAPERY	2	14	0	.00	1	0	50	53	1	ANIL	2016-09-21 14:21:55	83544	1	54781	55	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
31	CARPET	CARPET	2	8	0	.00	1	0	49	52	1	ANIL	2009-01-22 19:54:28	83543	1	70616	20	0	.0000	0	0	.0000	0	0	83561	0	—	—	0	0	0	0
32	VENETIAN BLIND	V.BLIND	2	11	0	.00	1	0	50	53	1	ANIL	2011-03-03 18:26:51	83544	1	54786	40	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
33	PVC FLOORING	PVC FLOORI	2	8	0	.00	1	0	50	53	1	Anil	2005-09-13 16:12:05	83544	1	57105	40	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
34	RUBBER MAT	MAT	2	14	0	.00	1	0	50	53	0	ANIL	2017-11-25 16:35:34	83544	1	57524	16	0	.0000	0	0	.0000	0	0	83559	0	0	—	0	0	0	0
35	BEAN BAG	BEAN BAG	2	8	0	.00	1	0	50	53	0	SIDE-COUNTER	2008-07-25 21:10:05	83544	1	54798	17	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
36	TRAY	TRAY	2	8	0	.00	1	0	55	56	0	GIFT	2008-05-04 12:37:30	83554	0	0	19	0	.0000	0	0	.0000	0	0	83560	0	—	—	0	0	0	0
37	TABLE SHEET PVC.	CUTLERY	2	8	0	.00	1	0	55	56	0	GIFT	2007-12-16 13:27:37	83554	0	0	16	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
38	PVC ITEM	PVC ITEM	2	8	0	.00	1	0	50	53	0	Anil	2005-09-13 16:12:12	83544	0	0	40	0	.0000	0	0	.0000	0	0	83559	0	—	—	—	—	—	—
39	TABLE CLOTH	TABLE CLOT	2	11	0	.00	1	0	55	56	0	ANIL	2010-12-09 13:12:17	83554	1	70617	15	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
40	COARD	COARD	2	8	0	.00	1	0	49	52	0	ANIL	2008-05-01 21:24:17	83543	0	0	55	0	.0000	0	0	.0000	0	0	83561	0	—	—	0	0	0	0
41	SH. CURTAIN	SHOWER CUR	2	8	0	.00	1	0	49	52	0	Anil	2009-03-27 15:49:37	83543	0	0	15	0	.0000	0	0	.0000	0	0	83561	0	—	—	0	0	0	0
44	BLANKET	BLANKET	2	11	0	.00	1	0	55	56	0	Anil	2010-02-06 17:29:13	83554	0	192991	17	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
45	BATH GOWN	BATH GOWN	2	8	0	.00	1	0	55	56	0	SIDE-COUNTER	2008-07-25 21:04:49	83554	0	0	53	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
46	NAPKIN	NAPKIN	2	11	0	.00	1	0	55	56	0	ANIL	2010-12-09 13:12:33	83554	0	0	19	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
47	SHIELD	SHIELD	2	8	0	.00	1	0	55	56	0	OFFICE-FIRST	2008-06-06 19:06:44	83554	0	0	43	0	.0000	0	0	.0000	0	0	83560	0	—	—	—	—	—	—
49	FRINGES	FRINGES	2	14	0	.00	1	0	49	52	0	ANIL	2020-02-02 14:02:58	83543	1	70618	55	0	.0000	0	0	.0000	0	0	83561	0	0	—	0	0	0	0
50	TESSEL	TESSEL	2	14	0	.00	1	0	55	56	0	ANIL	2019-08-25 17:50:05	83554	1	70619	55	0	.0000	0	0	.0000	0	0	83560	0	0	—	0	0	0	0
52	SYN CARPET	SYN CARPET	2	8	0	.00	1	0	49	52	0	ANIL	2009-01-22 19:59:34	83543	1	54783	20	0	.0000	0	0	.0000	0	0	83561	0	—	—	0	0	0	0
53	SOFA BACK	SOFA BACK	2	8	0	.00	1	0	55	56	0	ANIL	2008-05-01 13:32:17	83554	1	70620	15	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
55	BONE CHINA ITEM	BONE CHINA	2	8	0	.00	1	0	50	53	0	SIDE-COUNTER	2008-07-25 21:01:18	83544	0	0	19	0	.0000	0	0	.0000	0	0	83559	0	—	—	—	—	—	—
57	FURNITURE ITEM	FURNITURE	2	14	0	.00	1	0	50	53	0	ANIL	2017-11-25 16:33:56	83544	1	79162	49	0	.0000	0	0	.0000	0	0	83559	0	0	—	0	0	0	0
60	LAMP SHADE	LAMP	2	8	0	.00	1	0	49	52	0	Anil	2005-09-13 16:10:03	83543	0	0	19	0	.0000	0	0	.0000	0	0	83561	0	—	—	—	—	—	—
61	METAL ITEM	METAL DUST	2	8	0	.00	1	0	49	52	0	GIFT	2009-02-15 17:14:56	83543	1	54789	19	0	.0000	0	0	.0000	0	0	83561	0	—	—	—	—	—	—
62	GIFT ITEM	GIFT ITEM	2	8	0	.00	1	0	50	53	0	GIFT	2007-08-14 14:18:56	83544	1	70621	19	0	.0000	0	0	.0000	0	0	83559	0	—	—	—	—	—	—
63	MATTRESSES	COIR MATTE	2	11	0	.00	1	0	49	52	1	ANIL	2010-12-09 13:11:41	83543	0	0	18	0	.0000	0	0	.0000	0	0	83561	0	—	—	—	—	—	—
64	SHEET	SHEET	2	8	0	.00	1	0	55	56	0	ANIL	2008-05-01 13:31:41	83554	0	0	15	0	.0000	0	0	.0000	0	0	83560	0	—	—	—	—	—	—
65	FANCY CURTAINS	CURTAIN FA	1	8	0	.00	1	0	55	56	1	ANIL	2009-04-09 13:15:40	83554	0	0	43	-1	1000.0000	55	56	1000.0000	49	52	83560	0	—	—	83554	83560	83543	83561
66	SOFA CLOTH	SOFA CLOTH	1	8	0	.00	1	0	55	56	1	Anil	2009-03-22 20:53:10	83554	0	0	13	0	.0000	0	0	.0000	0	0	83560	0	—	—	—	—	—	—
67	BOOKING	BOOKING	2	8	0	.00	1	0	0	0	1	Anil	2008-04-17 13:28:29	2733	0	0	—	0	.0000	—	—	.0000	—	—	28409	0	—	—	—	—	—	—
72	ELECTRICAL ITEM	ELECTRIC	2	14	0	.00	1	0	50	53	0	ANIL	2017-11-25 16:33:47	83544	0	0	19	0	.0000	0	0	.0000	0	0	83559	0	0	—	0	0	0	0
79	CHANNEL ALUMINIUM	CHANNEL	2	11	0	.00	1	0	50	53	0	ANIL	2011-02-20 14:52:29	83544	1	54787	55	0	.0000	0	0	.0000	0	0	83559	0	—	—	0	0	0	0
80	TAPE	TAPE	1	14	0	.00	1	0	55	56	0	ANIL	2017-08-04 14:05:55	83554	0	70028	43	0	.0000	0	0	.0000	0	0	83560	0	0	—	0	0	0	0