COMMIT;

-- Dumped table `stock_details` with 4941 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)
--


