(5048,'B','6048',6048,'1','18','','5048','1','','1',0,0,NULL,'2220','9500','30-05-2026','','',NULL,'2'),(5049,'B','6049',6049,'1','18','','5049','1','','1',0,0,NULL,'1600','6800','30-05-2026','','',NULL,'3'),(5050,'B','6050',6050,'1','18','','5050','1','','1',0,0,NULL,'2575','10500','30-05-2026','','',NULL,'3'),(5051,'B','6051',6051,'1','18','','5051','1','','1',0,0,NULL,'3500','14000','30-05-2026','','',NULL,'3'),(5052,'B','6052',6052,'1','18','','5052','1','','1',0,0,NULL,'3500','14500','30-05-2026','','',NULL,'3'),(5053,'B','6053',6053,'1','18','','5053','1','','1',0,0,NULL,'1050','4500','30-05-2026','','',NULL,'3'),(5054,'B','6054',6054,'1','18','','5054','1','','1',0,0,NULL,'2880','11900','30-05-2026','','',NULL,'3'),(5055,'B','6055',6055,'1','18','','5055','1','','1',0,0,NULL,'4060','16500','30-05-2026','','',NULL,'3'),(5056,'B','6056',6056,'1','18','','5056','1','','1',0,0,NULL,'2425','9900','30-05-2026','','',NULL,'3'),(5057,'B','6057',6057,'1','18','','5057','1','','1',0,0,NULL,'6475','26500','30-05-2026','','',NULL,'2'),(5058,'B','6058',6058,'1','18','','5058','1','','1',0,0,NULL,'1580','6650','30-05-2026','','',NULL,'2'),(5059,'B','6059',6059,'1','18','','5059','1','','1',0,0,NULL,'1580','6650','30-05-2026','','',NULL,'2'),(5060,'B','6060',6060,'1','18','','5060','1','','1',0,0,NULL,'3700','14900','30-05-2026','','',NULL,'2'),(5061,'B','6061',6061,'1','18','','5061','1','','1',0,0,NULL,'5500','22900','30-05-2026','','',NULL,'2'),(5062,'B','6062',6062,'1','18','','5062','1','','1',0,0,NULL,'6500','26500','30-05-2026','','',NULL,'3'),(5063,'B','6063',6063,'1','18','','5063','1','','1',0,0,NULL,'3750','14900','30-05-2026','','',NULL,'3'),(5064,'B','6064',6064,'1','18','','5064','1','','1',0,0,NULL,'2190','8900','30-05-2026','','',NULL,'2'),(5065,'B','6065',6065,'1','18','','5065','1','','1',0,0,NULL,'3395','13900','30-05-2026','','',NULL,'2'),(5066,'B','6066',6066,'1','18','','5066','1','','1',0,0,NULL,'2110','8500','30-05-2026','','',NULL,'2'),(5067,'B','6067',6067,'1','3','','5067','1','','1',0,0,NULL,'350','2000','03-06-2026','','',NULL,'3'),(5068,'B','6068',6068,'1','3','','5068','1','','1',0,0,NULL,'350','2000','03-06-2026','','',NULL,'3'),(5069,'B','6069',6069,'1','3','','5069','1','','1',0,0,NULL,'420','2800','03-06-2026','','',NULL,'3'),(5070,'B','6070',6070,'1','3','','5070','1','','1',0,0,NULL,'420','2800','03-06-2026','','',NULL,'3'),(5071,'B','6071',6071,'1','3','','5071','1','','1',0,0,NULL,'420','2800','03-06-2026','','',NULL,'3'),(5072,'B','6072',6072,'1','3','','5072','1','','1',0,0,NULL,'350','2000','03-06-2026','','',NULL,'3'),(5073,'B','6073',6073,'1','3','','5073','1','','1',0,0,NULL,'350','2000','03-06-2026','','',NULL,'3'),(5074,'B','6074',6074,'1','3','','5074','1','','1',0,0,NULL,'300','2000','03-06-2026','','',NULL,'3'),(5075,'B','6075',6075,'1','3','','5075','1','','1',0,0,NULL,'520','3200','03-06-2026','','',NULL,'3'),(5076,'B','6076',6076,'1','3','','5076','1','','1',0,0,NULL,'520','3200','03-06-2026','','',NULL,'3'),(5077,'B','6077',6077,'1','3','','5077','1','','1',0,0,NULL,'350','2000','03-06-2026','','',NULL,'3'),(5078,'B','6078',6078,'1','3','','5078','1','','1',0,0,NULL,'400','2900','03-06-2026','','',NULL,'3'),(5079,'B','6079',6079,'1','3','','5079','1','','1',0,0,NULL,'370','2230','03-06-2026','','',NULL,'3'),(5080,'B','6080',6080,'1','3','','5080','1','','1',0,0,NULL,'370','2500','03-06-2026','','',NULL,'3'),(5081,'B','6081',6081,'1','3','','5081','1','','1',0,0,NULL,'500','3300','03-06-2026','','',NULL,'3'),(5082,'B','6082',6082,'1','3','','5082','1','','1',0,0,NULL,'500','3300','03-06-2026','','',NULL,'3'),(5083,'B','6083',6083,'1','3','','5083','1','','1',0,0,NULL,'500','3300','03-06-2026','','',NULL,'3'),(5084,'B','6084',6084,'1','3','','5084','1','','1',0,0,NULL,'600','3500','03-06-2026','','',NULL,'3'),(5085,'B','6085',6085,'1','3','','5085','1','','1',0,0,NULL,'600','3700','03-06-2026','','',NULL,'3'),(5086,'B','6086',6086,'1','3','','5086','1','','1',0,0,NULL,'600','3700','03-06-2026','','',NULL,'3'),(5087,'B','6087',6087,'1','3','','5087','1','','1',0,0,NULL,'600','3700','03-06-2026','','',NULL,'3'),(5088,'B','6088',6088,'1','3','','5088','1','','1',0,0,NULL,'390','2300','03-06-2026','','',NULL,'3'),(5089,'B','6089',6089,'1','3','','5089','1','','1',0,0,NULL,'390','2400','03-06-2026','','',NULL,'3'),(5090,'B','6090',6090,'1','3','','5090','1','','1',0,0,NULL,'550','3400','03-06-2026','','',NULL,'3'),(5091,'B','6091',6091,'1','3','','5091','1','','1',0,0,NULL,'550','3200','03-06-2026','','',NULL,'3'),(5092,'B','6092',6092,'1','3','','5092','1','','1',0,0,NULL,'550','3200','03-06-2026','','',NULL,'3'),(5093,'B','6093',6093,'1','3','','5093','1','','1',0,0,NULL,'380','2500','03-06-2026','','',NULL,'3'),(5094,'B','6094',6094,'1','3','','5094','1','','1',0,0,NULL,'380','2500','03-06-2026','','',NULL,'3'),(5095,'B','6095',6095,'1','3','','5095','1','','1',0,0,NULL,'380','2500','03-06-2026','','',NULL,'3'),(5096,'B','6096',6096,'1','3','','5096','1','','1',0,0,NULL,'600','4000','03-06-2026','','',NULL,'3'),(5097,'B','6097',6097,'1','3','','5097','1','','1',0,0,NULL,'520','3200','03-06-2026','','',NULL,'3'),(5098,'B','6098',6098,'1','3','','5098','1','','1',0,0,NULL,'520','3200','03-06-2026','','',NULL,'3'),(5099,'B','6099',6099,'1','3','','5099','1','','1',0,0,NULL,'310','1800','03-06-2026','','',NULL,'3'),(5100,'B','6100',6100,'1','3','','5100','1','','1',0,0,NULL,'310','1800','03-06-2026','','',NULL,'3'),(5101,'B','6101',6101,'1','3','','5101','1','','1',0,0,NULL,'260','2080','03-06-2026','','',NULL,'3'),(5102,'B','6102',6102,'1','3','','5102','1','','1',0,0,NULL,'425','2500','03-06-2026','','',NULL,'3'),(5103,'B','6103',6103,'1','3','','5103','1','','1',0,0,NULL,'425','2500','03-06-2026','','',NULL,'3'),(5104,'B','6104',6104,'1','3','','5104','1','','1',0,0,NULL,'520','3000','03-06-2026','','',NULL,'3'),(5105,'B','6105',6105,'1','3','','5105','1','','1',0,0,NULL,'520','3000','03-06-2026','','',NULL,'3'),(5106,'B','6106',6106,'1','3','','5106','1','','1',0,0,NULL,'520','3000','03-06-2026','','',NULL,'3'),(5107,'B','6107',6107,'1','3','','5107','1','','1',0,0,NULL,'520','3000','03-06-2026','','',NULL,'3'),(5108,'B','6108',6108,'1','3','','5108','1','','1',0,0,NULL,'300','1900','03-06-2026','','',NULL,'3'),(5109,'B','6109',6109,'1','3','','5109','1','','1',0,0,NULL,'300','1900','03-06-2026','','',NULL,'3'),(5110,'B','6110',6110,'1','3','','5110','1','','1',0,0,NULL,'300','1900','03-06-2026','','',NULL,'3'),(5111,'B','6111',6111,'1','3','','5111','1','','1',0,0,NULL,'300','1900','03-06-2026','','',NULL,'3'),(5112,'B','6112',6112,'1','3','','5112','1','','1',0,0,NULL,'280','1800','03-06-2026','','',NULL,'3'),(5113,'B','6113',6113,'1','3','','5113','1','','1',0,0,NULL,'280','1800','03-06-2026','','',NULL,'3'),(5114,'B','6114',6114,'1','3','','5114','1','','1',0,0,NULL,'280','1800','03-06-2026','','',NULL,'3'),(5115,'B','6115',6115,'1','3','','5115','1','','1',0,0,NULL,'280','1800','03-06-2026','','',NULL,'3'),(5116,'B','6116',6116,'1','3','','5116','1','','1',0,0,NULL,'310','1800','03-06-2026','','',NULL,'3'),(5117,'B','6117',6117,'1','3','','5117','1','','1',0,0,NULL,'600','2700','09-06-2026','','',NULL,'3'),(5118,'B','6118',6118,'1','3','','5118','1','','1',0,0,NULL,'850','3825','09-06-2026','','',NULL,'3'),(5119,'B','6119',6119,'1','3','','5119','1','','1',0,0,NULL,'700','3150','09-06-2026','','',NULL,'3'),(5120,'B','6120',6120,'1','3','','5120','1','','1',0,0,NULL,'700','3150','09-06-2026','','',NULL,'3'),(5121,'B','6121',6121,'1','3','','5121','1','','1',0,0,NULL,'850','3825','09-06-2026','','',NULL,'3'),(5122,'B','6122',6122,'1','3','','5122','1','','1',0,0,NULL,'700','3150','09-06-2026','','',NULL,'3'),(5123,'B','6123',6123,'1','3','','5123','1','','1',0,0,NULL,'850','3825','09-06-2026','','',NULL,'3'),(5124,'B','6124',6124,'1','1','','5124','1','','1',0,0,NULL,'7300','32850','09-06-2026','','',NULL,'1'),(5125,'B','6125',6125,'1','1','','5125','1','','1',0,0,NULL,'6500','29250','09-06-2026','','',NULL,'1'),(5126,'B','6126',6126,'1','1','','5126','1','','1',0,0,NULL,'6700','30150','09-06-2026','','',NULL,'1'),(5127,'B','6127',6127,'1','2','','5127','1','','1',0,0,NULL,'2500','11250','09-06-2026','','',NULL,'2'),(5128,'B','6128',6128,'1','2','','5128','1','','1',0,0,NULL,'2500','11250','09-06-2026','','',NULL,'2'),(5129,'B','6129',6129,'1','1','','5129','1','','1',0,0,NULL,'5000','22500','09-06-2026','','',NULL,'1'),(5130,'B','6130',6130,'1','1','','5130','1','','1',0,0,NULL,'2000','8000','09-06-2026','','',NULL,'1'),(5131,'B','6131',6131,'1','1','','5131','1','','1',0,0,NULL,'6000','27000','09-06-2026','','',NULL,'1'),(5132,'B','6132',6132,'1','1','','5132','1','','1',0,0,NULL,'4700','21150','09-06-2026','','',NULL,'1'),(5133,'B','6133',6133,'1','2','','5133','1','','1',0,0,NULL,'800','3600','09-06-2026','','',NULL,'2'),(5134,'B','6134',6134,'1','1','','5134','1','','1',0,0,NULL,'3550','15975','09-06-2026','','',NULL,'1'),(5135,'B','6135',6135,'1','1','','5135','1','','1',1,0,NULL,'2200','9900','09-06-2026','','',NULL,'1'),(5136,'B','6136',6136,'1','1','','5136','1','','1',0,0,NULL,'2800','12600','09-06-2026','','',NULL,'1'),(5137,'B','6137',6137,'1','1','','5137','1','','1',0,0,NULL,'2500','11250','09-06-2026','','',NULL,'1'),(5138,'B','6138',6138,'1','1','','5138','1','','1',0,0,NULL,'3800','17100','09-06-2026','','',NULL,'1'),(5139,'B','6139',6139,'1','1','','5139','1','','1',0,0,NULL,'2900','13050','09-06-2026','','',NULL,'1'),(5140,'B','6140',6140,'1','1','','5140','1','','1',0,0,NULL,'4400','19800','09-06-2026','','',NULL,'1'),(5141,'B','6141',6141,'1','2','','5141','1','','1',0,0,NULL,'2000','9000','09-06-2026','','',NULL,'2'),(5142,'B','6142',6142,'1','1','','5142','1','','1',0,0,NULL,'1100','4950','09-06-2026','','',NULL,'1'),(5143,'B','6143',6143,'1','1','','5143','1','','1',0,0,NULL,'1100','4950','09-06-2026','','',NULL,'1'),(5144,'B','6144',6144,'1','1','','5144','1','','1',0,0,NULL,'1100','4950','09-06-2026','','',NULL,'1'),(5145,'B','6145',6145,'1','1','','5145','1','','1',1,0,NULL,'1400','6300','09-06-2026','','',NULL,'1'),(5146,'B','6146',6146,'1','3','','5146','1','','1',0,0,NULL,'340','1940','09-06-2026','','',NULL,'3'),(5147,'B','6147',6147,'1','3','','5147','1','','1',0,0,NULL,'520','3200','09-06-2026','','',NULL,'3'),(5148,'B','6148',6148,'1','3','','5148','1','','1',0,0,NULL,'310','2480','09-06-2026','','',NULL,'3'),(5149,'B','6149',6149,'1','3','','5149','1','','1',0,0,NULL,'310','2480','09-06-2026','','',NULL,'3'),(5150,'B','6150',6150,'1','3','','5150','1','','1',0,0,NULL,'310','2480','09-06-2026','','',NULL,'3'),(5151,'B','6151',6151,'1','3','','5151','1','','1',0,0,NULL,'310','2480','09-06-2026','','',NULL,'3'),(5152,'B','6152',6152,'1','3','','5152','1','','1',0,0,NULL,'310','2480','09-06-2026','','',NULL,'3'),(5153,'B','6153',6153,'1','3','','5153','1','','1',0,0,NULL,'310','2480','09-06-2026','','',NULL,'3'),(5154,'B','6154',6154,'1','3','','5154','1','','1',0,0,NULL,'260','1730','09-06-2026','','',NULL,'3'),(5155,'B','6155',6155,'1','3','','5155','1','','1',0,0,NULL,'290','2100','09-06-2026','','',NULL,'3'),(5156,'B','6156',6156,'1','3','','5156','1','','1',0,0,NULL,'290','2100','09-06-2026','','',NULL,'3'),(5157,'B','6157',6157,'1','3','','5157','1','','1',0,0,NULL,'210','1680','09-06-2026','','',NULL,'3'),(5158,'B','6158',6158,'1','3','','5158','1','','1',0,0,NULL,'240','2130','09-06-2026','','',NULL,'3'),(5159,'B','6159',6159,'1','3','','5159','1','','1',0,0,NULL,'240','2130','09-06-2026','','',NULL,'3'),(5160,'B','6160',6160,'1','3','','5160','1','','1',0,0,NULL,'200','1330','09-06-2026','','',NULL,'3'),(5161,'B','6161',6161,'1','3','','5161','1','','1',0,0,NULL,'230','1840','09-06-2026','','',NULL,'3'),(5162,'B','6162',6162,'1','3','','5162','1','','1',0,0,NULL,'230','1840','09-06-2026','','',NULL,'3'),(5163,'B','6163',6163,'1','3','','5163','1','','1',0,0,NULL,'170','1360','09-06-2026','','',NULL,'3'),(5164,'B','6164',6164,'1','3','','5164','1','','1',0,0,NULL,'200','2000','09-06-2026','','',NULL,'3'),(5165,'B','6165',6165,'1','3','','5165','1','','1',0,0,NULL,'200','2000','09-06-2026','','',NULL,'3'),(5166,'B','6166',6166,'1','3','','5166','1','','1',0,0,NULL,'140','1240','09-06-2026','','',NULL,'3'),(5167,'B','6167',6167,'1','3','','5167','1','','1',0,0,NULL,'160','1600','09-06-2026','','',NULL,'3'),(5168,'B','6168',6168,'1','3','','5168','1','','1',0,0,NULL,'160','1600','09-06-2026','','',NULL,'3'),(5169,'B','6169',6169,'1','3','','5169','1','','1',0,0,NULL,'220','1500','09-06-2026','','',NULL,'3'),(5170,'B','6170',6170,'1','3','','5170','1','','1',0,0,NULL,'240','2400','09-06-2026','','',NULL,'3'),(5171,'B','6171',6171,'1','3','','5171','1','','1',0,0,NULL,'240','2400','09-06-2026','','',NULL,'3'),(5172,'B','6172',6172,'1','3','','5172','1','','1',0,0,NULL,'260','1400','09-06-2026','','',NULL,'3'),(5173,'B','6173',6173,'1','3','','5173','1','','1',0,0,NULL,'290','2320','09-06-2026','','',NULL,'3'),(5174,'B','6174',6174,'1','3','','5174','1','','1',0,0,NULL,'290','2320','09-06-2026','','',NULL,'3'),(5175,'B','6175',6175,'1','3','','5175','1','','1',0,0,NULL,'150','1200','09-06-2026','','',NULL,'3'),(5176,'B','6176',6176,'1','3','','5176','1','','1',0,0,NULL,'175','1750','09-06-2026','','',NULL,'3'),(5177,'B','6177',6177,'1','3','','5177','1','','1',0,0,NULL,'175','1750','09-06-2026','','',NULL,'3'),(5178,'B','6178',6178,'1','3','','5178','1','','1',0,0,NULL,'110','880','09-06-2026','','',NULL,'3'),(5179,'B','6179',6179,'1','3','','5179','1','','1',0,0,NULL,'130','1300','09-06-2026','','',NULL,'3'),(5180,'B','6180',6180,'1','3','','5180','1','','1',0,0,NULL,'130','1300','09-06-2026','','',NULL,'3');
COMMIT;

-- Dumped table `stock_details` with 5180 row(s)
--

--
-- Table structure for table `sub_category`
--

CREATE TABLE `sub_category` (
  `subcat_id` int NOT NULL AUTO_INCREMENT,
  `fkcat_id` int NOT NULL,
  `subcat_name` varchar(255) NOT NULL,
  PRIMARY KEY (`subcat_id`),
  KEY `subcat_id` (`subcat_id`),
  KEY `fkcat_id` (`fkcat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_category`
--

SET autocommit=0;
COMMIT;

-- Dumped table `sub_category` with 0 row(s)
--

--
-- Table structure for table `term_of_payment`
--

CREATE TABLE `term_of_payment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `term_of_payment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `term_of_payment`
--

SET autocommit=0;
INSERT INTO `term_of_payment` VALUES (3,'wewewe1122'),(4,'IMMEDIATE'),(5,'Return '),(6,'confirmed'),(7,'BARTER FREE');
COMMIT;

-- Dumped table `term_of_payment` with 5 row(s)
--

--
-- Table structure for table `unit`
--

CREATE TABLE `unit` (
  `id` int NOT NULL AUTO_INCREMENT,
  `unit` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `unit`
--

SET autocommit=0;
INSERT INTO `unit` VALUES (1,'SET'),(2,'PC'),(3,'PAIR'),(4,'');
COMMIT;

-- Dumped table `unit` with 4 row(s)
--

--
-- Table structure for table `vat`
--

CREATE TABLE `vat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vat_desc` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vat`
--

SET autocommit=0;
INSERT INTO `vat` VALUES (7,'CGST/SGST'),(8,'IGST');
COMMIT;

-- Dumped table `vat` with 2 row(s)
--

--
-- Table structure for table `vendordetails`
--

CREATE TABLE `vendordetails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `companyname` varchar(250) DEFAULT NULL,
  `nick_name` varchar(255) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `street2` varchar(255) DEFAULT NULL,
  `street3` varchar(255) DEFAULT NULL,
  `city_id` varchar(255) DEFAULT NULL,
  `state_id` varchar(255) DEFAULT NULL,
  `c_area` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `acc_num` varchar(20) DEFAULT NULL,
  `gstin` varchar(16) DEFAULT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `mobile` varchar(250) DEFAULT NULL,
  `sale_open_bal` varchar(255) DEFAULT NULL,
  `pur_open_bal` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `dis_per` varchar(255) DEFAULT NULL,
  `dis_type` varchar(255) DEFAULT NULL,
  `credit_limit` varchar(255) DEFAULT NULL,
  `broker_name` varchar(1000) DEFAULT NULL,
  `broker_per` varchar(255) DEFAULT NULL,
  `transport` varchar(255) DEFAULT NULL,
  `tax_type` varchar(255) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `security` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `concern_person` varchar(255) DEFAULT NULL,
  `client_code` varchar(255) DEFAULT NULL,
  `deals_in` varchar(255) DEFAULT NULL,
  `fax_no` varchar(255) DEFAULT NULL,
  `min_order_days` varchar(11) DEFAULT NULL,
  `due_days` varchar(11) DEFAULT NULL,
  `branch_add` varchar(1000) DEFAULT NULL,
  `acc_type` varchar(255) DEFAULT NULL,
  `acc_name` varchar(255) DEFAULT NULL,
  `ifsc_code` varchar(255) DEFAULT NULL,
  `bnick_name` varchar(255) DEFAULT NULL,
  `vendor_type` varchar(255) DEFAULT NULL,
  `fssai` varchar(20) DEFAULT NULL,
  `date_added` varchar(20) DEFAULT NULL,
  `pan_no` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `city_id` (`city_id`,`state_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vendordetails`
--

SET autocommit=0;
INSERT INTO `vendordetails` VALUES (3,'JBR MFG','','','','','1','11','28','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','30-12-2020',''),(4,'radhika','radhs jbr','46, RATNAJYOT INDUSTRIAL ESTATE, OFF S.V. ROAD, IRLA, VILE PARLE WEST, Mumbai Suburban, Maharashtra, 400056','','400056','1','11','28','','','','','','','','','','','','','','Select Transport','CGST/SGST','Sale','Normal','','radhika','111','mfg','','','','46, RATNAJYOT INDUSTRIAL ESTATE, OFF S.V. ROAD, IRLA, VILE PARLE WEST, Mumbai Suburban, Maharashtra, 400056','1','','','','Select Vendor Type','','15-03-2021',''),(5,'JBR ASSOCITE ','RADHIKA JBR','46, RATNAJYOT INDUSTRIAL ESTATE, OFF S.V. ROAD, IRLA, VILE PARLE WEST, Mumbai Suburban, Maharashtra, 400056','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Sale','Normal','','RADHIKA','','','','','','46, RATNAJYOT INDUSTRIAL ESTATE, OFF S.V. ROAD, IRLA, VILE PARLE WEST, Mumbai Suburban, Maharashtra, 400056','1','','','','Select Vendor Type','','15-03-2021',''),(6,'ASSOCIATE','RNC','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Sale','Normal','','RADHKA','','','','','','','1','','','','Select Vendor Type','','15-03-2021',''),(7,'RNC1','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Sale','Normal','','','','','','','','','1','','','','Select Vendor Type','','15-03-2021',''),(8,'RNC 2','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Sale','Normal','','','','','','','','','1','','','','Select Vendor Type','','15-03-2021',''),(9,'RNC 3','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Sale','Normal','','','','','','','','','1','','','','Select Vendor Type','','15-03-2021',''),(10,'BHAVYA CREATION ','','GANDHI COLONY , CHURU, RAJASTHAN ','','','6','32','Select Area','STATE BANK OF INDIA','37457173129','08DVMPS6583L1ZG','9351308825','8003572222','','','','','','','','','Select Transport','IGST','Purchase','Normal','','','','MIX IMMITATION JEWELLERY ','','','','CHURU','1','BHAVYA CREATION','SBIN0031138','','Select Vendor Type','','07-05-2021','DVMPS6583L'),(11,'MEET ART','M ART','702 QUANTUM TOWER ,RAMBAUGH LANE OFF S.V.ROAD \r\nMALAD WEST MUMBAI -400064','','400064','1','11','Select Area','SHAMRO VITHAL COOP BANK','104304180000236','27BZZPS6612M1Z9','02228823196','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','MALAD MUMBAI','1','MANISH SHAH','SVCB0000043','','Select Vendor Type','','07-05-2021','BZZPS6612M'),(12,'ASVI ENTERPRISE','ASVI','7A ARCHANA BUILDING, 97 KISHAN ROAD\r\nMALAD WEST MUMBAI','','400064','1','11','21','BANK OF BARODA','04020200001374','27AACHD8535R1ZO','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','MALAD WEST','1','','BARB0MALADX','','Select Vendor Type','','07-05-2021','AACHD8535R'),(13,'PANORAMA INDUSTRIES','PAN IND','SHOP NO 2 & 3 PADMA PRABHA SOCIETY NEAR CANARA BANK\r\nBANGUR NAGAR \r\nGOREGAON-WEST MUMBAI','','400104','1','11','23','UNION BANK OF INDIA','358201010050802','27CAXPB9133Q1ZS','9833772877','8657268885','','','info@teacoffeevendingmachine.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','KANDIVALI-WEST','1','','UBIN0535826','','Select Vendor Type','','07-05-2021','CAXPB9133Q1ZS'),(14,'AKBARALI & SONS','AKBARLI','4  BANIAN ROAD (A.E.ROAD), OPP SAIFI SCHOOL, PYDHONI\r\nMUMBAI','','400003','1','11','Select Area','','','27AWQPS1930D1ZD','022 66337630','022 23462584','','','infoakbarali@gmail.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','07-05-2021','AQQPS1930D'),(15,'RUDRA INC','RUDRA INC','ROOM NO 6/B FIRST FLOOR, 384K JITENDRA NIWAS\r\nDABHOLKARWADI , KALBADEVI\r\nMUMBAI','','','1','11','Select Area','','','27AABPB3831D1ZE','','9820061124','','','punitsbansal@yahoo.co.in','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','07-05-2021','AABPD3831D'),(16,'KUNDANKALI JEWELLS PVT LTD','KJPL','41 THATHERWARA \r\nMERRUT  (UTTAR PRADESH)','','250002','7','37','0','','','09AADCK5791J1Z0','','','','','','','','','','','Select Transport','IGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','07-05-2021','AADCK5791J'),(17,'PATIL & SONS JEWELLERS','PATILSONS','SHOP NO 16 FIRST FLOOR BUILDING NO 103-115\r\nSHAIKH MEMON STREET , ZAVERI BAZAR\r\nMUMBAI','','','1','11','102','KOTAK MAHINDRA BANK','','27AHRPK4256G1Z0','','','','','pramodpatil8579@gmail.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','MUMBAI BANDRA HILL ROAD','1','','','','Select Vendor Type','','07-05-2021','AZRPK4256G'),(18,'IMPES TECHNOLOGY','IMPES','1ST FLOOR SCO-55, SECTOR 16-A\r\nFARIDABAD  HARYANA \r\n','','121002','8','19','Select Area','','','06BXEPA8976R1ZN','','','','','','','','','','','Select Transport','IGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','07-05-2021','BXEPA8976R'),(19,'BOMBINO EXPRESS','BOMBINO','1 & 2 GROUND FLOOR MAROL PINE LINE\r\nANDHERI KURLA ROAD MUMBAI','','400059','1','11','103','AXIS BANK LTD','328010200002646','27AAACB6311J4ZT','','022 66400000','','','billing@bombinoexp.com','','','','','','Select Transport','CGST/SGST','Sale','Normal','','','','','','','','','1','','UTIB0000328','','Select Vendor Type','','07-05-2021','AAACB6311J'),(20,'ANTRAWAB TECHNOLOGIES PVT LTD','ANTRAWEB','STEEL HOUSE WING B 1ST FLOOR, OFF MAHAKALI VAVES ROAD\r\nANDHERI-EAST , MUMBAI-400093','','400093','1','11','26','DBS BANK','9AWT76806','27AAACA9776A1ZP','','022 40864086','','','sales@antraweb.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','FORT','1','','DBSS0IN0811','','Select Vendor Type','','07-05-2021','AAACA9776A'),(21,'BRIJ DESIGN STUDIO','BRIJ','D08 PARLE COLONY SAHKAR ROAD\r\nVILE PARLE  EAST  MUMBAI','','400057','1','11','2','ICIC BANK','021105005654','27AWVPS4073L1ZJ','','9833589989','','','birju@brijdesignstudio.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','www.brijdesignstudio.com','','','','','','','VILE PARLE EAST ','1','','ICIC0000211','','Select Vendor Type','','07-05-2021','AWVPS4073L'),(22,'SOCIA MEDIA FACTORY','SOCIAL MEDIA','C/8 NANDHAM  INDUSTRIAL ESTATE,MAROL\r\nANDHERI-EAST, MUMBAI','','400059','1','11','26','ICIC BANK','108605001105','','9699055898','9930610566','','','mail@socialmediafactory.in','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','SHIKHA MANHOT','','','','','','J B NAGAR BRANCH ANDHERI EAST MUMBAI','1','','ICIC0001086','','Select Vendor Type','','07-05-2021','ACJFS7333K'),(23,'BOMBINO EXPRESS PVT LTD','BOMBINO','B 1 & 2 GROUND FLOOR MAROL PIPE LINE ANDHERI KURLA ROAD\r\nMUMBAI -400059','','400059','1','11','26','AXIS BANK LTD','328010200002646','27AAACB6311J4ZT','022266400000','','','','billing@bombinoexp.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','COURIER','','','','','1','','UTIB0000328','','Select Vendor Type','','11-05-2021','AAACB6311J'),(24,'ZAMIK INFOTECH','ZAMIK','404 PRAGATI SHOPPING CENTRE OPP RAILWAY STATION \r\nMALAD EAST MUMBAI-400097','','400097','1','11','20','HDFC BANK ','50200014448521','27BFNPM1871G1Z6','7045730402','9769284209 ','','','zamikinfotech@yahoo.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','ZAMIKINFOTECH.COM/ZAMIKINFOTECH.IN','','','','','','','MALAD EAST','1','','HDFC0000398','','Select Vendor Type','','11-05-2021','BFNPM1871G'),(25,'IMPES TECHNOLOGY','','1ST FLOOR SCO-SS SECTOR -16A\r\nFARIDABAD HARYANA 121002','','121002','8','19','Select Area','','','06BXEPA8976R1ZN','','','','','','','','','','','Select Transport','IGST','Purchase','Normal','','','','ADVERTISING BOOST','','','','','1','','','','Select Vendor Type','','11-05-2021','BXEPA8976R'),(26,'PRAMOD TRADERS','PRAMOD TPRAMOD SONAWANE','3115 SHREE HANUMAN INDUSTRIAL ESTATE \r\nNEAR DADAR EAST MONORAIL STATION\r\nDADAR EAST MUMBAI -4000031 MAHARASHTRA','','400031','1','11','38','KOTAK MAHINDRA BANK','451371683','27EWBPS0791F2ZA','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','2','','KKBK0000648','','Select Vendor Type','','11-05-2021','EWBPS0791F'),(27,'ADANI ELECTRICITY ','adani','RNA CORPORATE PARK OLD KALAMANDIR  \r\nNEAR COLLECTORS OFFICE\r\nBANDRA-EAST MUMBAI-400051','','400051','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','www adanielectricity.com','','','','','','','','1','','','','Select Vendor Type','','11-05-2021',''),(28,'RATAN JYOT INDUSTRIAL PERMISES COOP SOC LTD','RATNA JYOT SOCIETY','','','','1','11','28','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','11-05-2021',''),(29,'SUDEEPA BHATTACHARYA','','','','','4','39','Select Area','ICIC BANK','106401505702','','','','','','','','','','','','Select Transport','IGST','Purchase','Normal','','','','','','','','','1','SUDEEPA BHATTACHARYA','ICIC0001064','','Select Vendor Type','','11-05-2021',''),(30,'BALAJI COMPUTER SERVICE & OFFICE STATIONERY','BALAJI COMPUTER','SAMTA SOCEITY OPP KAILAS INDUSTRAIL COMPLEX\r\nHIRANANDANI LINK ROAD\r\nVIKHROLI WEST MUMBAI-400079','','400079','1','11','86','PUNJAB NATIONAL BANK','','27AXOPB2367A1ZR','9867172628','9029587151','','','','','','','','','Select Transport','CGST/SGST','Sale','Normal','','','','PRINTING & STATINERY','','','','POWAI','1','BALAJI COMPUTER SERVICE & OFFICE STATIONERY','PUNB0063210','','Select Vendor Type','','20-05-2021','AXOPB2367A'),(31,'SSEC','SSEC','VOLE LIGHTING & PLASTIC INDUSTRIES,STREET NO 20, PLOT NO D 4 , MIDC, ANDHERI EAST','','400093','1','11','26','','','CVVVZXC','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','CAD','RADHIKA','SSEC CAD','CAD','','','','','1','','','','Select Vendor Type','','09-06-2021',''),(32,'SSEC','CAD SSEC','VOLE LIGHTING & PLASTIC INDUSTRIES,STREET NO 20, PLOT NO D 4 , MIDC, ANDHERI EAST','','400093','1','11','26','','','','','','','','','','','','','','Select Transport','CGST/SGST','InHouse','Normal','CADSSEC','NC','CAD SSEC','CAD','','','','','1','','','','Select Vendor Type','','09-06-2021',''),(33,'J K JEWEL BOX','','PLOT NO 5 ROOM NO 3090 \r\nGAJANNA COLONY\r\nGOWANDI  \r\nMUMBAI-400043','','400043','1','11','Select Area','KOKAN BANK','750061101004267','27HYGPK7792L1ZF','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','GOWANI','1','J K JEWEL BOX','KKBK0KMCB06','','Select Vendor Type','','15-06-2021','HYGPK7792L'),(34,'Lakhotia Trading Company ','','21-Bhanushali Building, shop  no 2\r\nMaruti Lane (Old Phulgali)  Bhuleshwar\r\nmumbai','','400002','1','11','102','BANK OF INDIA','000820110000261','27AAAL3199F1Z0','','','','','LTCGEMS@GMAIL.COM','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','immitation jewellerry','','','','BULLION EXCHANGE ','1','LAKHOTIA TRADING COMPANY','BKID0000008','','Select Vendor Type','','15-06-2021','AAAPL3199F'),(35,'SIYONA NX','','231 SHAIKH MEMON STREET\r\nZAVERI BAZAR\r\nMUMBAI-400 002','','400002','1','11','Select Area','AXIS BANK LTD','912020024807681','27ACCFS6361E1Z4','23445655','','','','info@siyonaartjewellers.com','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','ASSORTED JEWELLERY','','','','ZAVERI BAZAR','1','SIYONA NX','UTIB0001705','','Select Vendor Type','','15-06-2021','ACCFS6361E'),(36,'RAMDAYAL ','','','','','1','11','Select Area','','','','','9820482541','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','REPAIRING CIVIL WORK','','','','','1','','','','Select Vendor Type','','15-06-2021',''),(37,'Salary expenses','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','16-06-2021',''),(38,'SHIPROCKET','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','16-06-2021',''),(39,'kotak bank credit card','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','16-06-2021',''),(40,'infibeam ','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','16-06-2021',''),(41,'NIRAJ CHITALI','','','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','17-06-2021',''),(42,'staff welfare ','staff welfare ','46, RATNAJYOT INDUSTRIAL ESTATE, OFF S.V. ROAD, IRLA, VILE PARLE WEST, Mumbai Suburban, Maharashtra, 400056','','','1','11','28','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','dilip','','staff welfare expenses','','','','46, RATNAJYOT INDUSTRIAL ESTATE, OFF S.V. ROAD, IRLA, VILE PARLE WEST, Mumbai Suburban, Maharashtra, 400056','1','','','','Select Vendor Type','','18-06-2021',''),(43,'JEWELS BY RADHIKA','','46 , RATNAJYOT INDUSTRIAL ESTATE, IRLA LANE, VILE','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','','','','','','','','','1','','','','Select Vendor Type','','15-09-2021',''),(44,'JEWELS BY RADHIKA','','46 , RATNAJYOT INDUSTRIAL ESTATE, IRLA LANE, VILE','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','InHouse','Normal','','','','','','','','','1','','','','Select Vendor Type','','15-09-2021',''),(45,'ahaanya','ahaanya','9819019198','','','1','11','Select Area','','','','','','','','','','','','','','Select Transport','CGST/SGST','Purchase','Normal','shopahaanya.com','niraj','','','','','','','1','','','','Select Vendor Type','','13-04-2026','');
COMMIT;

-- Dumped table `vendordetails` with 43 row(s)
--


