Created
May 24, 2022 07:01
-
-
Save dubeyji10/0af3d8bed1ac127c1c0cbc8b94723351 to your computer and use it in GitHub Desktop.
backup of db
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| create a test db | |
| use that db | |
| to test and export sql dump | |
| */ | |
| /* create a table clients */ | |
| CREATE TABLE clients ( | |
| id int(11) NOT NULL DEFAULT '0', | |
| contact_person1 varchar(45) NOT NULL, | |
| contact_person2 varchar(45) DEFAULT NULL, | |
| company_name varchar(200) NOT NULL, | |
| company_grade varchar(15) DEFAULT NULL, | |
| phone_no varchar(300) DEFAULT NULL, | |
| mobile_no1 varchar(30) DEFAULT NULL, | |
| mobile_no2 varchar(30) DEFAULT NULL, | |
| email varchar(50) NOT NULL, | |
| designation varchar(45) DEFAULT NULL, | |
| address varchar(500) DEFAULT NULL, | |
| website varchar(45) DEFAULT NULL, | |
| user_id varchar(45) NOT NULL, | |
| added_on datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| last_conversation varchar(1000) DEFAULT NULL, | |
| followup_on datetime DEFAULT NULL, | |
| last_mail_no smallint(6) NOT NULL DEFAULT '0', | |
| last_mail_on datetime DEFAULT NULL, | |
| last_sms_no int(6) DEFAULT '0', | |
| last_sms_on datetime DEFAULT NULL, | |
| email2 varchar(50) DEFAULT NULL, | |
| Country varchar(45) DEFAULT NULL, | |
| phonecode varchar(10) DEFAULT NULL | |
| ) ENGINE=InnoDB; | |
| /* insert into clients*/ | |
| INSERT INTO clients VALUES (3397,'Ajay Bongale','','J G Khatawkar & Co','C','8364251223','9845023750',NULL,'[email protected]','','B-14 , 3rd Cross. Hosur. Hubli-580021. Karnataka','','nitisha70701','2015-01-02 13:30:48','invoice sent ','2017-11-14 12:20:18',21292,'2018-07-19 14:02:24',0,NULL,NULL,'India','91'),(3398,'Kishaloy Roy','','Goldtex Fashion Ltd','Please Select',NULL,'1920911106',NULL,'[email protected]','','Bangladesh','','bhawna','2015-01-02 15:59:38',NULL,NULL,15,'2015-02-05 13:21:11',0,NULL,NULL,'Bangladesh','880'),(3399,'Nitin kumar','','surya industries','Please Select',NULL,'8527766922',NULL,'[email protected]','','32-B Anand Industrial Estate, Mohan Nagar, Ghaziabad, Pincode No - 201007 Uttar Pradesh, India','http://www.suryaindustries.net.in/','bhawna','2015-01-02 16:12:31',NULL,NULL,15,'2015-02-05 13:21:12',0,NULL,NULL,'India','91'),(3400,'rajeshu kumar','','Apollo tyres','B',NULL,'9818228992',NULL,'[email protected]','','','','nitisha70701','2015-01-02 16:50:17','they mainly require the price in reports , which are not available . Hence not interested ','2015-01-11 16:51:22',21292,'2018-07-19 14:02:26',0,NULL,NULL,'India','91'),(3401,'Ibrahim','','sabibrahi traders','Please Select',NULL,'9943067069',NULL,'[email protected]','','Tamil Nadu','ANI TRADERS','bhawna','2015-01-02 16:51:54',NULL,NULL,15,'2015-02-05 13:21:12',0,NULL,NULL,'India','91'),(3402,'Neil Philip','R.Raja','High valley insulation Pvt Ltd','C',NULL,'9941095999',NULL,'[email protected]','','','','nitisha70701','2015-01-02 17:34:56',NULL,NULL,21292,'2018-07-19 14:02:28',0,NULL,NULL,'India','91'),(3403,'NAJMU SAKIB','','Shirin Foods','C',NULL,'9871814494',NULL,'[email protected]','','','','priyanka','2015-01-02 17:43:18','Sample shared with quote','2018-09-22 16:50:57',21291,'2018-07-17 13:46:59',0,NULL,NULL,'India','91'),(3404,' Souliyah','','KPN TAPIOCA FACTORY','A',NULL,'21480528',NULL,'[email protected]','','','http://www.kpn-pharma.com/','priyanka','2015-01-02 17:45:22','Data have to send','2015-05-06 19:00:23',21291,'2018-07-17 13:47:00',0,NULL,NULL,'Laos','856'),(3405,'Alex Felman','','Carmit Candy Industries','Please Select',NULL,'972546757616',NULL,'[email protected]','','','','pooja','2015-01-02 17:45:31',NULL,NULL,22,'2015-06-08 16:20:19',0,NULL,NULL,NULL,NULL),(3406,' riddhi','','swatichem','Please Select',NULL,'9924066617',NULL,'[email protected]','','','','pooja','2015-01-02 17:47:06',NULL,NULL,22,'2015-06-08 16:20:20',0,NULL,NULL,'India','91'),(3407,'AJAY PATEL','','CAST & BLOWER CO. (GUJ.) PVT. LTD','C',NULL,'9909944640',NULL,'[email protected]','','','','nitisha70701','2015-01-02 17:48:08',NULL,NULL,21292,'2018-07-19 14:02:30',0,NULL,NULL,'India','91'),(3408,'Deepika','','Pranav Enterprises','Please Select',NULL,'9028264646',NULL,'[email protected]','','','','barkha','2015-01-02 18:25:18','doesnt require data. need promoters','2015-01-04 16:38:31',0,NULL,0,NULL,NULL,'India','91'),(3409,'Ramesh Doshi','','Prasanthi','Please Select',NULL,'9821043851',NULL,'[email protected]','','','','barkha','2015-01-02 18:26:35','he filled the form just like that. he doesnt require any data.','2015-01-05 17:50:41',6,'2015-01-12 12:42:05',0,NULL,NULL,'India','91'),(3410,'Geetha','','Sri Lakshmi Enterprises','Please Select',NULL,'9845645710',NULL,'[email protected]','','','','barkha','2015-01-02 18:27:54','require latest data for Bangalore ICD','2015-01-01 16:47:13',6,'2015-01-12 12:42:05',0,NULL,NULL,'India','91'),(3411,'Anand','','Aarambhlifescince','C',NULL,'9167010129',NULL,'[email protected]','','','','Hina','2015-01-03 12:06:17','he said another source offering him china export data with buyer name.. He is not interest with our services.','2015-01-05 15:40:11',21204,'2018-03-21 13:50:42',0,NULL,NULL,'India','91'),(3412,'Manoj','','Global Impex','Please Select',NULL,'9567077999',NULL,'[email protected]','','INDIA','','bhawna','2015-01-03 12:23:45',NULL,NULL,15,'2015-02-05 13:21:13',0,NULL,NULL,'India','91'),(3413,'MAHENDRA GOKHARU','','SHREEJI TRADE LINK','Please Select',NULL,'9829046223',NULL,'[email protected]','','','','barkha','2015-01-03 12:36:11','dropped this project','2015-01-04 16:36:55',0,NULL,0,NULL,NULL,'India','91'),(3414,'Osama Bawazir','','Makaseb','C',NULL,'966506620121',NULL,'[email protected]','','','','anuj09','2015-01-03 15:42:45','no one picked the call, lead closed','2015-01-08 16:54:08',21120,'2017-11-02 13:26:54',0,NULL,NULL,NULL,NULL),(3415,'P Saraf','','P Saraf','B',NULL,'9433031725',NULL,'[email protected]','','','','priyanka','2015-01-03 17:36:42',NULL,NULL,21151,'2017-11-02 16:46:31',0,NULL,NULL,'India','91'),(3416,'kishor','','fruits4u trading','Please Select',NULL,'9767545343',NULL,'[email protected]','','','','pooja','2015-01-03 17:50:09',NULL,NULL,22,'2015-06-08 16:20:22',0,NULL,NULL,'India','91'),(3417,'rajnish uppal','','prince cycles','Please Select','1675250937','9814109342',NULL,'[email protected]','','B-1, Industrial Estate, Malerkotla - 148023, Punjab - INDIA','www.princecycle.com','bhawna','2015-01-05 11:59:10',NULL,NULL,15,'2015-02-05 13:21:14',0,NULL,NULL,'India','91'),(3418,'KARUN','','MAX INTERNATION','C',NULL,'9803806611',NULL,'[email protected]','','','','anuj09','2015-01-05 12:08:04','No reply by Mail, tried to call but his number but no one picked up the call, lead closed','2015-01-11 15:24:29',21120,'2017-11-02 13:26:54',0,NULL,NULL,'India','91'),(3419,'Sarah Wang','','Weifang Polygrand Chemical Co.,LTD.','Please Select','13806363936','',NULL,'[email protected]','','','','barkha','2015-01-05 12:29:37','not interested','2015-01-06 18:23:17',6,'2015-01-12 12:42:06',0,NULL,NULL,'China','86'),(3420,'VIPUL','','vrandavan brass industries','Please Select',NULL,'8000930012',NULL,'[email protected]','','','','barkha','2015-01-05 12:31:36','didnt receive call. reminder mail dropped.','2015-01-13 17:55:11',0,NULL,0,NULL,NULL,'India','91'),(3421,'Khaled','','Burj Trading','Please Select','99448880','',NULL,'[email protected]','','Kuwait','','barkha','2015-01-05 12:32:57','no reply till now','2015-01-11 16:36:17',0,NULL,0,NULL,NULL,'Kuwait','965'),(3422,'Sherif','Vinodkumar','Hama Holding For Financial Investments','B','[email protected]','1207671222',NULL,'[email protected]','','','','Shakim.k','2015-01-05 12:44:14',NULL,NULL,21120,'2017-11-02 13:26:55',0,NULL,NULL,'Egypt','20'),(3423,'ANIQ','','INDIANTOUCH','Please Select',NULL,'9412244819',NULL,'[email protected]','','136,LAJPAT NAGAR MORADABAD INDIA.','','pooja','2015-01-05 12:45:12',NULL,NULL,22,'2015-06-08 16:20:24',0,NULL,NULL,'India','91'),(3424,'Ashok Bhanushali','','Nav Bharat Electronics Co','Please Select',NULL,'9712909739',NULL,'[email protected]','','Plot No.: 739, New G.I.D.C.,Phase-II, Gundlav-396 035, District-Valsad Gujarat. India.','http://www.navbharateyelets.com/','bhawna','2015-01-05 12:56:31',NULL,NULL,15,'2015-02-05 13:21:14',0,NULL,NULL,'India','91'),(3425,'urooj ali','','yellow seas exim ltd','C',NULL,'9839786577',NULL,'[email protected]','','','','anuj09','2015-01-05 13:28:15','not interested','2015-01-06 15:43:12',21120,'2017-11-02 13:26:56',0,NULL,NULL,'India','91'),(3426,'Manjunath','','Uma Industries','Please Select',NULL,'9901748200',NULL,'[email protected]','','','','barkha','2015-01-05 15:00:48','no revert after receiving sample.','2015-01-12 15:13:13',0,NULL,0,NULL,NULL,'India','91'),(3427,'Mahendra kumar gowda','Shivaram-9886558969','Golden Hill Ex-Im Incorporation','Please Select',NULL,'9342504189',NULL,'[email protected]','','','[email protected]','barkha','2015-01-05 15:03:03','his junior said they do not need any database. they need promoter s.','2015-01-06 16:23:15',6,'2015-01-12 12:42:07',0,NULL,NULL,'India','91'),(3428,'Edwin Thebez','','PT. THEBEZ','Please Select','313540757','',NULL,'[email protected]','[email protected]','Jl. Mliwis No.39-41, Surabaya 60175 Indonesia','','bhawna','2015-01-05 17:15:24',NULL,NULL,15,'2015-02-05 13:21:16',0,NULL,NULL,'Indonesia','62'),(3429,'Sahil Aggarwal','','Nu-Cork Products (P) Ltd.','A',NULL,'9887442580',NULL,'[email protected]','','','','priyanka','2015-01-05 17:24:49',NULL,NULL,21151,'2017-11-02 16:46:33',0,NULL,NULL,'India','91'),(3430,'Xuan','','A Au','D','967032336','',NULL,'[email protected]','','','','priyanka','2015-01-05 17:33:24',NULL,NULL,21151,'2017-11-02 16:46:34',0,NULL,NULL,NULL,NULL),(3431,'Lauren','','Opentide','B',NULL,'821098732132',NULL,'[email protected]','','','','nitisha70701','2015-01-05 17:44:03',NULL,NULL,9059,'2017-03-09 12:39:12',0,NULL,NULL,NULL,NULL),(3432,'SaiVinoth.J','','WORLDGATE EXPRESS LINES INTERNATIONAL PVT LTD','C',NULL,'9600011033',NULL,'[email protected]','','','','nitisha70701','2015-01-05 17:46:38',NULL,NULL,21292,'2018-07-19 14:02:32',0,NULL,NULL,'India','91'),(3433,'Vighnesh Pulukunte','','Bal Pharma Limited','B',NULL,'8041379542',NULL,'[email protected]','','','','nitisha70701','2015-01-05 17:48:27',NULL,NULL,21292,'2018-07-19 14:02:34',0,NULL,NULL,'India','91'),(3434,'BHARAT PATEL ','','ATLAS INDUSTRIES','C','2767220100','9825077781',NULL,'[email protected]','','','','nitisha70701','2015-01-05 17:56:01',NULL,NULL,21292,'2018-07-19 14:02:36',0,NULL,NULL,'India','91'),(3435,'AJAY SUNEJA','','SINOSTEEL INDIA PVT.LTD','C','1142895600','9999975073',NULL,'[email protected]','','','','nitisha70701','2015-01-05 18:01:55','they have finalized with somebody else ','2015-01-19 16:24:06',21292,'2018-07-19 14:02:38',0,NULL,NULL,'India','91'),(3436,'Divyashree sj','','ISEC','B',NULL,'9481078297',NULL,'[email protected]','','','','nitisha70701','2015-01-05 18:12:16',NULL,NULL,21292,'2018-07-19 14:02:40',0,NULL,NULL,'India','91'),(3437,'vijay','','Grinding Mill Product','Please Select',NULL,'9824213011',NULL,'[email protected]','','','','pooja','2015-01-05 18:14:24',NULL,NULL,22,'2015-06-08 16:20:26',0,NULL,NULL,'India','91'),(3438,'Anil','','Seajin Technology Pvt. Ltd.','Please Select',NULL,'9740035551',NULL,'[email protected]','','','','pooja','2015-01-05 18:16:25',NULL,NULL,22,'2015-06-08 16:20:27',0,NULL,NULL,'India','91'),(3439,'Digvijay Dodia','','Fasal Farmers Enterprise','Please Select',NULL,'9723829797',NULL,'[email protected]','','','','pooja','2015-01-05 18:18:40',NULL,NULL,22,'2015-06-08 16:20:29',0,NULL,NULL,'India','91'),(3440,'AYYANAR RAJA','','VELMURUGAN TRADING COMPANY','D',NULL,'9597926260',NULL,'[email protected]','','','','anuj09','2015-01-06 11:48:29','not interested, he is thinking we are nay kind of buyer or supplier','2015-01-06 15:37:09',21120,'2017-11-02 13:26:56',0,NULL,NULL,'India','91'),(3441,'Andy Gautam','','BNB Imp Exp Firm','D',NULL,'9779813226683',NULL,'[email protected]','','','','anuj09','2015-01-06 12:00:00','he is not interested','2015-01-14 15:20:21',21120,'2017-11-02 13:26:57',0,NULL,NULL,NULL,NULL),(3442,'Nickolay','','BHS','C',NULL,'375296295820',NULL,'[email protected]','','','','anuj09','2015-01-06 12:08:07','No reply by Mail, tried to call but his number but no one picked up the call, lead closed','2015-01-07 16:54:56',21120,'2017-11-02 13:26:58',0,NULL,NULL,NULL,NULL),(3443,'Parag Shah','','parag auto center','Please Select',NULL,'9377736769',NULL,'[email protected]','','Shop No 6, Prime Centre, Old Jansatta Press, Mirzapur, Mirzapur, Ahmedabad, Gujarat 380001','','bhawna','2015-01-06 12:09:50',NULL,NULL,15,'2015-02-05 13:21:17',0,NULL,NULL,'India','91'),(3444,'Pradipta Dasgupta','','Nagreeka Export Ltd','B','61447437','',NULL,'[email protected]','AGM(Procurement & Systems)','','','nitisha70701','2015-01-06 14:39:56','sample sent ','2020-07-28 13:21:10',21120,'2017-11-02 13:26:59',0,NULL,NULL,'India','91'),(3445,'Kaushik Dutta','','Naga Limited - Foods','Please Select',NULL,'7708111336',NULL,'[email protected]','','No. 1, Trichy Road, Dindigul - 624005 tamil nadu','http://www.nagamills.com/','Priyanka','2015-01-06 14:55:16',NULL,NULL,21291,'2018-07-17 13:47:42',0,NULL,NULL,'India','91'),(3446,'kundan pandya','','shiva exim','D',NULL,'8347780399',NULL,'[email protected]','','','','nitisha70701','2015-01-06 18:16:50',NULL,NULL,21292,'2018-07-19 14:02:42',0,NULL,NULL,'India','91'),(3448,'Subhash shah','','Ami Pigments Pvt. Ltd','C','7965451718','9227649261',NULL,'[email protected]','','','','nitisha70701','2015-01-06 18:21:08',NULL,NULL,21292,'2018-07-19 14:02:43',0,NULL,NULL,'India','91'),(3449,'Vargas','','Swissecology','B',NULL,'41216970010',NULL,'[email protected]','','','','anuj09','2015-01-07 12:43:13','not picking up phone ','2015-02-23 16:50:43',21120,'2017-11-02 13:27:00',0,NULL,NULL,NULL,NULL),(3450,'Kaleem ur rehman ','','Unique Collection','Please Select',NULL,'9997757000',NULL,'[email protected]','','138,Lajpat Nagar Moradabad - 244001 INDIA','','Hemlata04','2015-01-07 13:12:49','get data from other source','2015-08-30 16:56:12',9058,'2017-03-01 13:11:09',0,NULL,NULL,'India','91'),(3451,'Vijaypal Reddy.M ','','Dr.Reddys Laboratories Ltd ','A',NULL,'9000660478',NULL,'[email protected]','','','','anuj09','2015-01-07 14:37:09','not interested','2015-02-16 14:43:35',21120,'2017-11-02 13:27:00',0,NULL,NULL,'India','91'),(3452,'Deepak choudhary','','Unique Arts','Please Select',NULL,'9828577554',NULL,'[email protected]','','Jaisingh Pura Road, Bhankrota, Jaipur','','Hemlata04','2015-01-07 15:58:11','invoice','2020-08-15 18:26:24',21207,'2018-05-16 13:46:29',0,NULL,NULL,'India','91'),(3453,'Angie Ng','','Top Glove Sdn Bhd','B','333921992','',NULL,'[email protected]','','Malaysia','','nitisha70701','2015-01-07 17:51:35',NULL,NULL,21292,'2018-07-19 14:02:46',0,NULL,NULL,'Malaysia','60'),(3454,'Abbas Travadi','','KMPL','C',NULL,'9925190160',NULL,'[email protected]','','','','Priyanka','2015-01-07 17:54:02',NULL,NULL,11065,'2017-06-28 13:35:03',0,NULL,NULL,'India','91'),(3455,'Pinky Mulchandani','','Phoeniks Agro & Engg Pvt Ltd','A','','7350200555','','[email protected]','','','','priyanka','2015-01-07 18:14:20',NULL,NULL,21291,'2018-07-17 13:47:05',0,NULL,'[email protected]','India','91'),(3456,'Bhavin','','Tripada Export','C',NULL,'9429833333',NULL,'[email protected]','','','','priyanka','2015-01-07 18:16:17',NULL,NULL,21151,'2017-11-02 16:46:35',0,NULL,NULL,'India','91'),(3457,'Mr. Samkit','','Aditya Birla','A','6281546500929','','','[email protected]','','','','nitisha70701','2015-01-07 18:19:30','invoice hard copy sent ','2017-08-16 13:30:05',21292,'2018-07-19 14:02:48',0,NULL,'','Indonesia','62'),(3458,'Vishwanath Kamath','','Ambika Exports','Please Select',NULL,'7507711300',NULL,'[email protected]','','INDIA','','bhawna','2015-01-08 11:38:28','will revert after 15 days','2015-02-18 12:00:42',15,'2015-02-05 13:21:19',0,NULL,NULL,'India','91'),(3459,'Madhavi Kale','','Sandoz-Novartis','A','2227679769','9920789568',NULL,'[email protected]','Asst.Manager Sourcing – API & Excipient','','','anuj09','2015-01-08 11:58:41','not interested','2015-02-15 15:41:39',21120,'2017-11-02 13:27:01',0,NULL,NULL,'India','91'),(3460,'Muthupandian','','PEARLS AGENCIES','C',NULL,'9976907615',NULL,'[email protected]','','','','anuj09','2015-01-08 13:18:59','he thought we are any kind of buyer','2015-01-08 14:48:35',21120,'2017-11-02 13:27:02',0,NULL,NULL,'India','91'),(3461,'stephen freeedman','','sports development labs','Please Select',NULL,'7242630817',NULL,'[email protected]','','','','bhawna','2015-01-08 15:04:51',NULL,NULL,15,'2015-02-05 13:21:20',0,NULL,NULL,'India','91'),(3462,'Rajpreet Walia','','Marketsandmarkets','B',NULL,'7720014800',NULL,'[email protected]','','','','nitisha70701','2015-01-08 15:21:40','not picking up phone, closed the lead','2015-01-21 12:36:22',21120,'2017-11-02 13:27:04',0,NULL,NULL,'India','91'),(3463,'Hussain Zakee','','Havells','A','1203332395','',NULL,'[email protected]','','','','anuj09','2015-01-08 15:29:23','price issue, not interested','2015-01-15 16:09:56',21120,'2017-11-02 13:27:05',0,NULL,NULL,'India','91'),(3464,'Rohit Gupta','','Arcom Paper','C','2503215687','',NULL,'[email protected]','','GALA NO.G-25, SHAILESH INDUSTRIAL COMPLEX, SATIVALI ROAD, NEAR PROFESSIONAL COURIER, VASAI ROAD (EAST), THANE - 401208','','anuj09','2015-01-08 15:43:39','Data sent','2015-01-11 17:48:19',9001,'2016-10-27 15:43:09',0,NULL,NULL,'India','91'),(3465,'Adeel Qamar','','Engro Fertilzers','B',NULL,'923018220732',NULL,'[email protected]','','','','anuj09','2015-01-08 16:51:14','not interested','2015-01-21 12:35:47',21120,'2017-11-02 13:27:06',0,NULL,NULL,NULL,NULL),(3466,'Mrugesh Patel ','','Santosh Cera Tiles','C',NULL,'9727300678',NULL,'[email protected]','','NH-8A, Morbi','','nitisha70701','2015-01-08 18:10:27','payment done','2020-08-21 13:47:10',21292,'2018-07-19 14:02:50',0,NULL,NULL,'India','91'),(3467,'Gautam Kalra','Aarushi Kalra','Suryansh Pharmachem','Please Select','1722268435','9814142790',NULL,'[email protected]','','C-27,Industrial Area,Phase 2 S.A.S. Nagar, Mohali, Punjab, India','www.suryanshgroup.com','Priyanka','2015-01-08 18:15:39',NULL,NULL,21291,'2018-07-17 13:50:53',0,NULL,NULL,'India','91'),(3468,'baljit','','Fitco Engineers Pvt. Ltd.','Please Select','2228596187','9819900293',NULL,'[email protected]','','212, Gokul Industrial, Estate, Marol Co-operative Industrial Estate, Andheri Kurla Road, Marol, Andheri East, Andheri East, Mumbai, Maharashtra 400059','http://www.fitcoseals.com/','Hemlata04','2015-01-09 11:11:35','closed','2016-08-07 12:22:05',21207,'2018-05-16 11:34:04',0,NULL,NULL,'India','91'),(3469,'Darshan P. Patel','','Flexatherm Expanllow Pvt. Ltd.','B','2652644941','9662546354',NULL,'[email protected]','','','','anuj09','2015-01-09 11:18:04','Data sent','2015-01-29 16:49:45',9001,'2016-10-27 15:43:12',0,NULL,NULL,'India','91'),(3470,'Rohit Prasad','','GRP Limited','B','2267082549','',NULL,'[email protected]','','','','anuj09','2015-01-09 16:06:33','Data sent','2015-01-13 18:10:49',9001,'2016-10-27 15:43:14',0,NULL,NULL,'India','91'),(3471,'S K SINGH','','shri Lakhmichand metal india Pvt Ltd','Please Select',NULL,'9752490048',NULL,'[email protected]','','INDIA','','bhawna','2015-01-09 17:32:01',NULL,NULL,15,'2015-02-05 13:21:22',0,NULL,NULL,'India','91'),(3472,'Amit Jain','','jainco trading','Please Select',NULL,'9810147002',NULL,'[email protected]','','','','pooja','2015-01-10 10:44:21',NULL,NULL,22,'2015-06-08 16:20:34',0,NULL,NULL,'India','91'),(3473,'v.sivakumar','','vsk trading company','Please Select',NULL,'9943253622',NULL,'[email protected]','','','','pooja','2015-01-10 10:46:08',NULL,NULL,22,'2015-06-08 16:20:36',0,NULL,NULL,'India','91'),(3474,'enjela','','geoexport','Please Select',NULL,'',NULL,'[email protected]','','','','pooja','2015-01-10 10:48:56',NULL,NULL,22,'2015-06-08 16:20:38',0,NULL,NULL,NULL,NULL),(3475,'s.arul mozhi','','subam pooja products p ltd','Please Select',NULL,'',NULL,'[email protected]','','','','pooja','2015-01-10 10:50:19',NULL,NULL,22,'2015-06-08 16:20:39',0,NULL,NULL,NULL,NULL),(3476,'VIKAS VARSHNEY','','MY INTERNATIONAL','D',NULL,'9810191273',NULL,'[email protected]','','','','priyanka','2015-01-10 10:52:23',NULL,NULL,21151,'2017-11-02 16:46:37',0,NULL,NULL,'India','91'),(3477,'dinesh goel','','bindal sales corp','Please Select',NULL,'9811305851',NULL,'[email protected]','','','','pooja','2015-01-10 10:52:28',NULL,NULL,22,'2015-06-08 16:20:41',0,NULL,NULL,'India','91'),(3478,'F. RAHMAN','','S.K PACKAGE MACHINE','C',NULL,'9723627074',NULL,'[email protected]','','','','priyanka','2015-01-10 10:55:48','No response ','2017-11-15 14:51:05',21151,'2017-11-02 16:46:38',0,NULL,NULL,'India','91'),(3479,'JOSEPH J NEDUMKUNNEL','','mechelonic welders p ltd','C',NULL,'9845470392',NULL,'[email protected]','','','','Hemlata04','2015-01-10 12:43:30','budget is around 3000 INR only and need 3 years database for Import','2015-01-12 16:06:43',21120,'2017-11-02 13:27:07',0,NULL,NULL,'India','91'),(3480,'Sandeep Gupta','','Association of Indian Forging Industry','B','26634451','8975903717',NULL,'[email protected]','','','','barkha','2015-01-10 13:35:40','cheque received need to send database.','2015-01-19 16:00:49',2,'2016-09-01 11:15:43',0,NULL,NULL,'India','91'),(3481,'Ana Moreira','','Porto World','C','223238606','',NULL,'[email protected]','','','','nitisha70701','2015-01-10 13:37:45',NULL,NULL,21292,'2018-07-19 14:02:52',0,NULL,NULL,'Portugal','351'),(3482,'KAMAL AGGARWAL','','Chemcon Speciality Chemicals P. Ltd','B',NULL,'',NULL,'[email protected]','','3, sardar Estate, Ajwa Road, Vadodara, Gujarat, India','','nitisha70701','2015-01-10 13:40:15',NULL,NULL,21292,'2018-07-19 14:02:54',0,NULL,NULL,'India','91'),(3483,'Mr. Ajay','Astha','Eastman Global ','A',NULL,'9810499393',NULL,'[email protected]','','','','nitisha70701','2015-01-10 13:41:39','report sent','2015-02-26 13:08:18',21292,'2018-07-19 14:02:56',0,NULL,NULL,'India','91'),(3485,'Aman Arora','','Beroe Consulting (I) Pvt. Ltd','A',NULL,'9003129750',NULL,'[email protected]','','','','nitisha70701','2015-01-10 13:43:56',NULL,NULL,21292,'2018-07-19 14:02:57',0,NULL,NULL,'India','91'),(3486,'Mr. Harshad Parmar','','Gujarat Filter','C',NULL,'9727676595',NULL,'[email protected]','','','','priyanka','2015-01-10 15:26:00','Shipment confirmed','2015-01-27 12:44:51',21291,'2018-07-17 13:47:09',0,NULL,NULL,'India','91'),(3487,'Amit Nangre','','Arnav Engineering','B',NULL,'9158592111',NULL,'[email protected]','','','','nitisha70701','2015-01-10 15:56:33',NULL,NULL,21292,'2018-07-19 14:02:59',0,NULL,NULL,'India','91'),(3488,'manoj kumar','','sunshine impex','D',NULL,'9217899098',NULL,'[email protected]','','8, kasturba nagar, nalwa road, jalandhar cantt-144005, punjab, india','','nitisha70701','2015-01-10 15:58:30',NULL,NULL,21292,'2018-07-19 14:03:01',0,NULL,NULL,'India','91'),(3489,'VIPUL DESAI','','V. C. ENTERPRISE','Please Select',NULL,'9830132238',NULL,'[email protected]','','','','barkha','2015-01-12 12:18:16','sample has been sent. ','2015-01-12 16:00:09',0,NULL,0,NULL,NULL,'India','91'),(3490,'Vipul Dinesh Chheda','','Chheda enterprises','Please Select',NULL,'9322266111',NULL,'[email protected]','','B1-402 Labh Darshan Opp Audute Nagar Near Sub Way Bhishar, East , Mumbai - 400068, Maharashtra, India','','bhawna','2015-01-12 12:30:19',NULL,NULL,15,'2015-02-05 13:21:23',0,NULL,NULL,'India','91'),(3491,'Shreyas C','','CARBORUNDUM UNIVERSAL LIMITED','A','8030937306','9886008965',NULL,'[email protected]','Purchase Dept.','PLOT NO.77,JIGANI-BOMMAASANDRA LINK ROAD, JIGANI INDUSTRIAL AREA, JIGANI,ANEKAL TQ., BANGALORE ','','aashita_8','2015-01-12 12:31:29','invoice','2018-12-20 17:36:05',0,NULL,0,NULL,NULL,'India','91'),(3492,'Inder Dawar','','S.K TRADERS','Please Select',NULL,'9990770779',NULL,'[email protected]','','','','barkha','2015-01-12 13:05:20','shifted to Bhawna','2015-01-18 15:47:32',0,NULL,0,NULL,NULL,'India','91'),(3493,'Mr. Upinder Wanchoo','','ForDe International','B','01145725740/41','9810158805',NULL,'[email protected]','','F-645, Third Floor, Palam Extension, Sector-7, Dwarka, New Delhi-110077.','','priyanka','2015-01-12 15:04:52','price quoted','2017-06-24 17:43:21',21291,'2018-07-17 13:47:10',0,NULL,NULL,'India','91'),(3494,'Mr. Vishal Maheshwari','','EURO SOLAR SYSTEM','B',NULL,'9099016724',NULL,'[email protected]','','S-14/23, Shakti Arcade, Opp Water tank, Science city road, Sola. Ahmedabad-380060','','priyanka','2015-01-12 15:56:38','Closed with subscription','2017-03-20 20:00:44',21291,'2018-07-17 13:47:11',0,NULL,NULL,'India','91'),(3495,'Santosh Joglekar','','Sara Hongkong Pvt. Ltd','B','2267564919','',NULL,'[email protected]','','','','nitisha70701','2015-01-12 18:11:00',NULL,NULL,21292,'2018-07-19 14:03:03',0,NULL,NULL,'India','91'),(3496,'sant kumarr','','Mohammad Al Sahen','C',NULL,'9953445849',NULL,'[email protected]','','','','nitisha70701','2015-01-12 18:14:06',NULL,NULL,21292,'2018-07-19 14:03:05',0,NULL,NULL,'India','91'),(3497,'Mr. Yirgalem Tagel (GM)','','Yirgalem Tagel Import Export','C','911526800','',NULL,'[email protected]','','','','nitisha70701','2015-01-12 18:15:35',NULL,NULL,21292,'2018-07-19 14:03:07',0,NULL,NULL,'Ethiopia','251'),(3498,' manoj','','global agencies','Please Select',NULL,'9846056991',NULL,'[email protected]','','','','pooja','2015-01-12 18:26:00',NULL,NULL,22,'2015-06-08 16:20:43',0,NULL,NULL,'India','91'); | |
| /* create table clients */ | |
| CREATE TABLE conversation ( | |
| s_n int(11) NOT NULL DEFAULT '0', | |
| with_email varchar(50) CHARACTER SET utf8 NOT NULL, | |
| user_id varchar(45) CHARACTER SET utf8 NOT NULL, | |
| added_on datetime DEFAULT CURRENT_TIMESTAMP, | |
| followup_on datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| msg varchar(1000) CHARACTER SET utf8 NOT NULL | |
| ) ENGINE=InnoDB; | |
| /* insert into conversation */ | |
| INSERT INTO conversation VALUES (6545,'[email protected]','barkha','2015-01-02 12:48:20','2015-01-03 12:48:17','INVOICE TO BE SEND'),(6546,'[email protected]','nitisha70701','2015-01-02 13:19:08','2015-01-06 13:18:43','he will confirm by monday , which ports he wants , kolkata or mundra'),(6547,'[email protected]','nitisha70701','2015-01-02 13:30:48','2015-01-05 13:29:11','invoice to to be sent '),(6548,'[email protected]','nitisha70701','2015-01-02 13:37:44','2015-01-05 13:37:19','number switched off , follow up mail sent '),(6549,'[email protected]','nitisha70701','2015-01-02 13:46:36','2015-01-05 13:46:10','invoice to be set . they are making payment today'),(6550,'[email protected]','nitisha70701','2015-01-02 14:47:27','2015-01-13 14:47:03','vacations going on in USA and it might take more couple of day to get if approved.'),(6551,'[email protected]','nitisha70701','2015-01-02 14:53:53','2015-01-07 14:53:27','he required exact contact person name and details , but since they are not available . He requires Brazil report for his product as a trail free of cost , so that he can check if details are available with ICC. .'),(6552,'[email protected]','nitisha70701','2015-01-02 14:54:21','2015-01-05 14:53:57','not taking the calls , will call tomorow'),(6553,'[email protected]','nitisha70701','2015-01-02 14:56:08','2015-01-01 14:55:43','they will let me know if required'),(6554,'[email protected]','nitisha70701','2015-01-02 14:57:40','2015-01-01 14:57:10','still quotes are not workable , he wants all his products in 5000INR only '),(6555,'[email protected]','nitisha70701','2015-01-02 14:59:57','2015-01-06 14:59:29','Follow up mail sent'),(6556,'[email protected]','nitisha70701','2015-01-02 15:02:38','2015-01-01 15:02:14','no response from client side '),(6557,'[email protected]','nitisha70701','2015-01-02 15:04:28','2015-01-06 15:04:02','follow up mail sent'),(6558,'[email protected]','nitisha70701','2015-01-02 15:07:20','2015-01-07 15:06:57','Follow up mail sent'),(6559,'[email protected]','barkha','2015-01-02 15:08:33','2015-01-06 15:08:28','not in office today. will ask about payment on Tuesday'),(6560,'[email protected]','nitisha70701','2015-01-02 15:34:25','2015-01-02 15:34:01','report sent , new invoice o be generated and sent'),(6561,'[email protected]','priyanka','2015-01-02 15:36:58','2015-01-02 11:00:45','closed successfully '),(6562,'[email protected]','nitisha70701','2015-01-02 15:38:38','2015-01-06 15:38:14','invoice for dec 14 sent'),(6563,'[email protected]','nitisha70701','2015-01-02 15:44:08','2015-01-05 11:00:41','no response on mail and will cal him on monday morning last time'),(6564,'[email protected]','nitisha70701','2015-01-02 15:45:32','2015-01-07 15:45:08','not answering calls , follow up mail sent'),(6565,'[email protected]','nitisha70701','2015-01-02 15:49:17','2015-01-05 15:48:53','Asked to send the invoice and will confirm the requirement by monday'),(6566,'[email protected]','barkha','2015-01-02 15:50:35','2015-01-05 15:50:31','hasnt received the sample yet. sample mailed again.'),(6567,'[email protected]','bhawna','2015-01-02 15:59:38','2015-01-06 11:00:29','mail dropped about the company profile wait for the reply'),(6568,'[email protected]','bhawna','2015-01-02 16:01:51','2015-01-05 12:00:41','mail bounced wait for two days'),(6569,'[email protected]','nitisha70701','2015-01-02 16:07:25','2015-01-05 16:07:01','not taking calls , follow up mail sent'),(6570,'[email protected]','bhawna','2015-01-02 16:12:31','2015-01-02 17:00:22','need to work on it now'),(6571,'[email protected]','barkha','2015-01-02 16:44:14','2015-01-05 16:44:10','didnt receive call'),(6572,'[email protected]','barkha','2015-01-02 16:47:42','2015-01-05 16:47:38','not in office. will discuss about data on Monday'),(6573,'[email protected]','nitisha70701','2015-01-02 16:50:17','2015-01-05 16:49:51','For them teh price is reports was important . However the, a sample for pakistan import based on BL'),(6574,'[email protected]','bhawna','2015-01-02 16:51:54','2015-01-02 18:00:26','need to work on this lead now'),(6575,'[email protected]','nitisha70701','2015-01-02 16:57:36','2015-01-07 16:57:12','he will get in touch with me sometime around monday'),(6576,'[email protected]','nitisha70701','2015-01-02 16:58:56','2015-01-01 16:58:26','he was just a beginer in import-export ans felt 1500 INR is too costly for monthly reports '),(6577,'[email protected]','nitisha70701','2015-01-02 16:59:38','2015-01-01 16:59:12','he informed , he will get back as and when required '),(6578,'[email protected]','nitisha70701','2015-01-02 17:02:27','2015-01-08 17:02:03','Follow up mail sent'),(6579,'[email protected]','nitisha70701','2015-01-02 17:03:39','2015-01-10 17:03:15','number switched off , follow up mail sent '),(6580,'[email protected]','nitisha70701','2015-01-02 17:03:39','2015-01-10 17:03:15','number switched off , follow up mail sent '),(6581,'[email protected]','nitisha70701','2015-01-02 17:12:36','2015-01-01 17:12:07','he do not require it right now '),(6582,'[email protected]','priyanka','2015-01-02 17:24:46','2015-01-19 17:24:39','followup mail sent'),(6583,'[email protected]','pankaj','2015-01-02 17:31:43','2015-01-27 05:29:55','2'),(6584,'[email protected]','nitisha70701','2015-01-02 17:34:56','2015-01-05 17:34:31','sample & quotes sent'),(6585,'[email protected]','nitisha70701','2015-01-02 17:41:17','2015-01-01 17:40:54','still his product is not identified and even he do not know the HS code '),(6586,'[email protected]','priyanka','2015-01-02 17:43:18','2015-01-03 11:00:08','sample sent'),(6587,'[email protected]','priyanka','2015-01-02 17:45:22','2015-01-05 11:00:07','sample sent'),(6588,'[email protected]','pooja','2015-01-02 17:45:31','2015-01-05 11:00:21','company detail sent'),(6589,'[email protected]','barkha','2015-01-02 17:46:01','2015-01-15 17:45:58','reminder mail dropped.'),(6590,'[email protected]','barkha','2015-01-02 17:46:38','2015-01-15 17:46:34','no reply till now'),(6591,'[email protected]','priyanka','2015-01-02 17:47:06','2015-01-03 11:00:55','will mail the details tomorrow'),(6592,'[email protected]','pooja','2015-01-02 17:47:06','2015-01-05 11:00:58','sample sent'),(6593,'[email protected]','barkha','2015-01-02 17:47:07','2015-01-16 17:47:03','no reply till now'),(6594,'[email protected]','priyanka','2015-01-02 17:47:37','2015-01-13 17:47:32','Didnot received call'),(6595,'[email protected]','barkha','2015-01-02 17:47:57','2015-01-06 17:47:53','busy today. he will let me know about the sample soon.'),(6596,'[email protected]','nitisha70701','2015-01-02 17:48:08','2015-01-02 17:47:42','details mailed '),(6597,'[email protected]','priyanka','2015-01-02 17:48:20','2015-01-05 11:00:05','waiting for further response'),(6598,'[email protected]','nitisha70701','2015-01-02 17:48:20','2015-01-01 17:47:56','details mailed '),(6599,'[email protected]','nitisha70701','2015-01-02 17:48:53','2015-01-07 17:48:29','disconnecting calls , follow up mail sent'),(6600,'[email protected]','priyanka','2015-01-02 17:50:14','2015-01-01 17:50:03','not interested'),(6601,'[email protected]','priyanka','2015-01-02 17:57:10','2015-01-20 11:00:56','have to discuss with partner then let you know'),(6602,'[email protected]','bhawna','2015-01-02 18:01:15','2015-01-05 12:00:05','mail dropped wid attached sample report wait for the reply'),(6603,'[email protected]','bhawna','2015-01-02 18:01:49','2015-01-03 15:00:42','mail dropped wid attached sample report wait for the reply'),(6604,'[email protected]','bhawna','2015-01-02 18:02:16','2015-01-03 16:00:11','call tmrw'),(6605,'[email protected]','bhawna','2015-01-02 18:02:45','2015-01-05 13:00:36','call on monday phone is not reachable'),(6606,'[email protected]','bhawna','2015-01-02 18:03:11','2015-01-05 15:00:05','CALL MONDAY'),(6607,'[email protected]','priyanka','2015-01-02 18:03:23','2015-01-02 18:03:18','Price quoted'),(6608,'[email protected]','bhawna','2015-01-02 18:03:41','2015-01-03 12:00:34','in conversation wid d client will reply by tmrw'),(6609,'[email protected]','bhawna','2015-01-02 18:04:18','2015-01-03 12:30:05','PRICE QUOTES SENT WAIT FOR THE REPLY'),(6610,'[email protected]','bhawna','2015-01-02 18:05:33','2015-01-06 12:00:16','not answeriing d calls try MONDAY '),(6611,'[email protected]','barkha','2015-01-02 18:05:48','2015-01-06 18:05:44','didnt receive call'),(6612,'[email protected]','barkha','2015-01-02 18:06:20','2015-01-06 18:06:15','not in office'),(6613,'[email protected]','bhawna','2015-01-02 18:06:33','2015-01-06 13:00:25','SPOKE TO CLIENT WILL REVERT BY NEXT WEEK '),(6614,'[email protected]','barkha','2015-01-02 18:06:54','2015-01-06 18:06:50','will ask about the payment on Tuesday'),(6615,'[email protected]','bhawna','2015-01-02 18:07:00','2015-01-03 16:00:53','call tmrw'),(6616,'[email protected]','bhawna','2015-01-02 18:07:29','2015-01-06 12:00:21','CALL NEXT WEEK'),(6617,'[email protected]','priyanka','2015-01-02 18:11:24','2015-01-05 11:00:05','Invoice Sent'),(6618,'[email protected]','barkha','2015-01-02 18:25:18','2015-01-03 17:00:12','she will let me know the HS Codes tomorrow'),(6619,'[email protected]','barkha','2015-01-02 18:26:35','2015-01-03 16:00:28','he asked to c all tomorrow.'),(6620,'[email protected]','barkha','2015-01-02 18:27:54','2015-01-03 18:27:51','sample has been sent. '),(6621,'[email protected]','priyanka','2015-01-02 18:28:21','2015-01-12 14:00:10','no response received'),(6622,'[email protected]','anuj09','2015-01-03 10:37:54','2015-01-05 10:37:42','call monday'),(6623,'[email protected]','anuj09','2015-01-03 10:38:13','2015-01-01 10:37:56','not interested'),(6624,'[email protected]','anuj09','2015-01-03 10:38:32','2015-01-07 10:38:16','he will revert back this month'),(6625,'[email protected]','anuj09','2015-01-03 10:38:57','2015-01-05 11:00:43','take followup monday'),(6626,'[email protected]','anuj09','2015-01-03 10:39:17','2015-01-05 11:00:03','call monday'),(6627,'[email protected]','anuj09','2015-01-03 10:39:54','2015-01-01 10:39:36','no shipments under his code from sahar Air, so he rejected the plan'),(6628,'[email protected]','anuj09','2015-01-03 10:40:19','2015-01-03 13:00:05','call in second half'),(6629,'[email protected]','anuj09','2015-01-03 10:40:38','2015-01-05 12:00:24','he is not in office, call him monday'),(6630,'[email protected]','anuj09','2015-01-03 10:40:57','2015-01-03 12:00:44','call him after 12'),(6631,'[email protected]','anuj09','2015-01-03 10:41:17','2015-01-09 10:41:04','no approval yet, will revert back next week'),(6632,'[email protected]','anuj09','2015-01-03 10:41:48','2015-01-03 13:00:35','He is busy will contact me on monday'),(6633,'[email protected]','anuj09','2015-01-03 10:42:23','2015-01-06 11:00:08','no reply received by mail'),(6634,'[email protected]','anuj09','2015-01-03 10:42:47','2015-01-05 12:00:31','not picking up phone call back monday'),(6635,'[email protected]','anuj09','2015-01-03 10:43:10','2015-01-06 11:00:56','not picking up phone call back next week'),(6636,'[email protected]','anuj09','2015-01-03 10:43:38','2015-01-05 13:00:24','he is going to call me on monday'),(6637,'[email protected]','anuj09','2015-01-03 10:43:56','2015-01-05 14:00:42','Not checked the mail. Will check mail then revert back'),(6638,'[email protected]','priyanka','2015-01-03 11:20:37','2015-01-09 11:20:28','busy these days will inform after 3-4 days'),(6639,'[email protected]','anuj09','2015-01-03 11:52:08','2015-01-05 11:00:53','accounts detail mailed, he is going to do the payment monday'),(6640,'[email protected]','bhawna','2015-01-03 11:59:04','2015-01-05 12:00:57','sat off vl speak on monday'),(6641,'[email protected]','bhawna','2015-01-03 12:03:07','2015-01-08 14:00:00','mail dropped again follow next week now'),(6642,'[email protected]','anuj09','2015-01-03 12:06:17','2015-01-03 14:00:04','Sample Mailed, Call After 2 hours'),(6643,'[email protected]','bhawna','2015-01-03 12:06:59','2015-01-19 12:00:28','spoke to the assistant will take it fr nov & dec together (chennai sea)'),(6644,'[email protected]','bhawna','2015-01-03 12:11:26','2015-01-07 14:00:20','reply awaited mail dropped'); | |
| /* create table invoice_info*/ | |
| CREATE TABLE invoice_info ( | |
| Id int(20) NOT NULL DEFAULT '0', | |
| invoice_no int(11) DEFAULT NULL, | |
| invoice_of varchar(45) DEFAULT NULL, | |
| Customer_name varchar(100) DEFAULT NULL, | |
| Company_Name varchar(150) NOT NULL, | |
| Customer_Designation varchar(45) DEFAULT NULL, | |
| Address varchar(500) NOT NULL, | |
| City varchar(50) DEFAULT NULL, | |
| State varchar(50) DEFAULT NULL, | |
| Tel_No varchar(100) DEFAULT NULL, | |
| Fax varchar(50) DEFAULT NULL, | |
| Mob varchar(50) DEFAULT NULL, | |
| Email varchar(100) DEFAULT NULL, | |
| User_Id varchar(45) DEFAULT NULL, | |
| added_on datetime DEFAULT NULL, | |
| payment_detail varchar(200) DEFAULT NULL, | |
| payment_on date DEFAULT NULL, | |
| payment_in varchar(100) NOT NULL DEFAULT 'PNB - ExportGenius', | |
| data_detail varchar(500) DEFAULT NULL, | |
| amount_recieved varchar(100) DEFAULT NULL, | |
| data_sent_on datetime DEFAULT NULL, | |
| immediate tinyint(1) NOT NULL DEFAULT '0', | |
| tds_percentage tinyint(4) NOT NULL DEFAULT '0', | |
| sale_rule varchar(20) NOT NULL DEFAULT '', | |
| sale_amount float NOT NULL DEFAULT '0' | |
| ) ENGINE=InnoDB; | |
| /* insert into invoice_info */ | |
| INSERT INTO invoice_info VALUES (601,6145,'EG','Aditya Gupta','AAA Roller Flour Mills Pvt. Ltd.','Director','Gut No.114, Dingrajwadi, Taluka- Shirur','Dist-Pune','Maharastra ','2228245673','','9867362746','[email protected]','barkha','2015-01-02 12:55:00','neft','2015-01-02','PNB - ExportGenius','kindly confirm to your client','1124','2015-01-02 16:48:36',0,0,'Total of Items',1000),(602,6146,'EG','Ajay Bongale','J G Khatawkar & Co','','B-14 , 3rd Cross. Hosur',' Hubli-580021',' Karnataka','0836-4251223','','09845023750','[email protected]','nitisha70701','2015-01-02 13:31:34','neft','2015-01-03','PNB - ExportGenius','Kindly confirm to your client','7416','2015-01-05 18:13:50',0,0,'Total of Items',6600),(603,6147,'EG','Jeni','Keerthy Agencies','','Kodimatha ','Kottayam - 686039',' Kerala','','','9605944444','[email protected]','nitisha70701','2015-01-02 13:47:55','neft','2015-01-05','PNB - ExportGenius','kindly confirm to your client','2809','2015-01-05 18:13:00',0,0,'Total of Items',2500),(604,6148,'EG','Phil Wilkins ',' D+P Services LTD.','','POBox 366 ','Wanaka 9343 ','New Zealand','64 21 341 929','','','[email protected]','nitisha70701','2015-01-02 15:35:31','paypal','2015-01-05','PNB - ExportGenius','kindly confirm to your client','6529.19','2015-02-02 18:28:44',0,0,'Recieved Amount',6529.19),(605,6149,'EG','Raj','A.D.JEYAVEERAPANDIA NADAR & BROS.(NAGAPATTINAM)','','#5, C.C.B.F Road, Alamadhi, Redhills ','Chennai - 600052','Tamil Nadu','44 26322325','','9884304230','[email protected]','nitisha70701','2015-01-02 15:49:56',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(607,6150,'EG','Mr. Sanjay Moolchandani','Cipla Limited','','Cipla Ltd., Mumbai Central, Mumbai – 400 008 India.','Mumbai','Maharashtra','91 22 23082891','91 22 23070013','09619818820','[email protected]','priyanka','2015-01-02 18:09:45','CQ- 708740 2015-01-23','2015-01-31','PNB - ExportGenius','','138186','2016-01-11 16:33:29',0,10,'Total of Items',135000),(608,6151,'EG','Bhargav Faldu','Duracon Vitrified Pvt Ltd','','8-A National Highway,, Sartanpar Road','','Gujarat','','','919909909197','[email protected]','bhawna','2015-01-03 16:24:21','cq- 020296','2015-01-06','PNB - ExportGenius','kindly confirm to your client','8989','2015-01-03 18:53:04',0,0,'Total of Items',8000),(609,65,'IBN','Rajesh','World wide Translogistic Pvt Ltd.','','FLAT NO 3, PLOT NO. 185, MEHZABEEN BLDG SECTOR 28, VASHI, NAVI MUMBAI - 400705 Maharashtra - INDIA','','','','','9820439554','[email protected]','pooja','2015-01-05 11:33:21','cash','2015-01-07','ICICI - IBN','kindly confirm to your client','5000','2015-01-08 17:10:47',0,0,'Total of Items',5000),(610,6152,'EG','ANIQ','INDIANTOUCH','','136,LAJPAT NAGAR MORADABAD INDIA.','','','','','9412244819','[email protected]','pooja','2015-01-05 12:45:52',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(611,66,'IBN','ANIQ','INDIANTOUCH','','136,LAJPAT NAGAR MORADABAD INDIA.','','','','','9412244819','[email protected]','pooja','2015-01-05 13:00:01','CASH','2015-01-05','ICICI - IBN','kindly confirm to your client','1500','2015-01-05 18:09:37',0,0,'Total of Items',1500),(612,67,'IBN','praveen jain','sri tirumala traders','','','','','','','9885039691','[email protected]','barkha','2015-01-05 16:40:57','CASH','2015-01-05','ICICI - IBN','kindly confirm to your client','4000','2015-01-05 18:24:26',0,0,'Total of Items',4000),(613,68,'IBN','Mr. NAJMU SAKIB','SHIRIN FOODS','','Shirin Foods Limited,37, LGF, 17-Barakhamba Road, Vijaya Building, Connaught Place, Pin Code : 110001','Delhi','Delhi','01123350662','','09871814494','[email protected]','priyanka','2015-01-06 11:26:02','cash','2015-01-06','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','5650','2015-01-07 18:22:03',0,0,'Total of Items',5670),(614,6153,'EG','Mr. Matias Lobos','Ajay NorthAmerica','','1400 Industry Rd. Powder Springs, GA. 30127-0127, USA','Georgia','USA','6787739718','1.770.439.0369','','[email protected]','priyanka','2015-01-06 12:47:37','wire','2015-01-08','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','37676','2015-01-29 18:15:01',0,0,'Recieved Amount',37676),(615,6154,'EG','Shivaji Krishna Khavanewadkar','Beetachem Industries','Marketing Head','A205 TTC MIDC, Pawane, South Central Rd., Navi Mumbai 400710. MAH INDIA.','Mumbai','Maharashtra','91 22 24224776','91 22 24222248 ','09224368647','[email protected]','priyanka','2015-01-06 13:27:41','neft','2015-01-08','PNB - ExportGenius','kindly confirm to your client','6742','2015-01-27 15:02:46',0,0,'Total of Items',6000),(616,6155,'EG','Aditya Gupta','AAA Roller Flour Mills Pvt. Ltd.','Director','Gut No.114, Dingrajwadi Taluka - Shirur Dist - Pune (Maharashtra)','','','2228245673','','9867362746','[email protected]','barkha','2015-01-06 14:37:06','Transfer','2015-01-06','PNB - ExportGenius','kindly confirm to your client','3371','2015-01-06 10:19:00',0,0,'Total of Items',3000),(617,6156,'EG','Pradipta Dasgupta','Nagreeka Indcon Products Pvt. Ltd.','AGM(Procurement & Systems)','258/3 village Dadra UT of Dadra & Nagar Haveli','','Dadra & Nagar Haveli- 395230','+91-22-61447506','','','[email protected]','anuj09','2015-01-06 14:41:44',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(618,6157,'EG','Mahesh Jain','Shree Paper Co.Pvt.Ltd.','','3980/2, Chawri Bazar, Chawri Bazar ','New delhi ','Delhi','01123911660','','9810113301','[email protected]','nitisha70701','2015-01-06 15:47:35','cq- 519552 2015-01-06','2015-01-08','PNB - ExportGenius','kindly confirm to your client','2247.20','2015-01-08 16:50:33',0,0,'Total of Items',2000),(619,6158,'EG','Sanjeev','Yashanis Overseas','','10 A, Willow Edenwoods, Pokharan- 2, T','HANE- (W )- 400610.','Maharashtra','22 25891873','','9322600307','[email protected]','nitisha70701','2015-01-06 16:22:49',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(620,69,'IBN','Sanjeev','Yashanis Overseas','','10 A, Willow Edenwoods, Pokharan- 2,','THANE- (W )- 400610','Maharashtra','22 25891873','','9322600307','[email protected]','nitisha70701','2015-01-06 16:24:02','transfer','2015-01-07','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','1000','2015-01-07 17:19:08',0,0,'Total of Items',1000),(621,6159,'EG','S. L','S L','','','','','','','1234567890','[email protected]','ankur','2015-01-06 16:29:24','neft','2015-01-07','PNB - ExportGenius','kindly confirm to your client','18809.16','2015-01-05 16:36:02',0,0,'Total of Items',16740),(622,6160,'EG','Gyan','Wave Infratrade Pvt Ltd','','C-1, Sector 3','Noida ','Uttar Pradesh','','','7838386963','[email protected]','nitisha70701','2015-01-06 16:32:00','cq- 198973 2015-01-07','2015-01-09','PNB - ExportGenius','kindly confirm to your client','1123','2015-01-13 11:52:25',0,0,'Total of Items',1000),(623,6161,'EG','Gyan','Wave Infratrade Pvt Ltd','','C-1, Sector 3','Noida ','Uttar Pradesh','','','7838386963','[email protected]','nitisha70701','2015-01-06 16:33:59',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(624,70,'IBN','Jitender Kharbanda','New Steel World','','','','','91-11-45521842','','9910173845 ','[email protected]','nitisha70701','2015-01-06 16:49:22','cash','2015-01-20','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','1500','2015-01-07 17:18:20',1,0,'Total of Items',1500),(625,6162,'EG','saurabh','Shakun Group','','583, Model Town, Near Shakuntala Mandir, Panipat - 132103. Haryana- INDIA','','','','','1802652860','[email protected]','pooja','2015-01-06 17:05:46','',NULL,'PNB - ExportGenius','','',NULL,0,0,'',0),(626,6163,'EG','Lalendra','Hay Carb PLC','','','','','94 773760806','','','[email protected]','ankur','2015-01-06 17:19:32','paypal','2015-01-07','PNB - ExportGenius','both report sent kindly confirm to your client','11675.77','2015-01-20 15:34:13',0,0,'Recieved Amount',11675.8),(627,71,'IBN','Sanjeev','Yashanis Overseas','','10 A, Willow Edenwoods, Pokharan- 2, ','THANE- (W )- 400610. ','Maharashtra','22 2589187','','9322600307','[email protected]','nitisha70701','2015-01-06 18:10:30','transfer','2015-01-07','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','1000','2015-01-07 18:09:43',0,0,'Total of Items',1000),(628,6164,'EG','nikhil b shah','FOUR STAR INDUSTRIES','','Unit No 6, Anand Industrial Estate,Raghunath Nagar','Thane -400602','Maharashtra','','','9820115959','[email protected]','nitisha70701','2015-01-07 11:06:52','neft','2015-01-07','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','2247.20','2015-01-07 18:25:24',0,0,'Total of Items',2000),(629,6165,'EG','saurabh','shakun fibres','','Address- 203/4, near hanuman mandir, Panipat-132103. Haryana','','','','','1802652860','[email protected]','pooja','2015-01-07 12:43:58','cq- 000152 2015-01-07','2015-01-08','PNB - ExportGenius','kindly confirm to your client','1910','2015-01-08 16:52:18',0,0,'Total of Items',1700),(630,72,'IBN','Kaleem ur rehman ','Unique Collection','','138,Lajpat Nagar Moradabad - 244001 INDIA','','','','','9997757000','[email protected]','pooja','2015-01-07 13:18:32','cash','2015-01-07','ICICI - IBN','kindly confirm to your client','2500','2015-01-08 15:56:07',0,0,'Total of Items',2500),(631,6166,'EG','Aditya Gupta','AAA Roller Flour Mills Pvt. Ltd.','Director','Gut No.114, Dingrajwadi Taluka - Shirur Dist - Pune (Maharashtra)','','','2228245673','','9867362746','[email protected]','barkha','2015-01-07 13:24:05','neft','2015-01-07','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','3371','2015-01-07 18:11:24',0,0,'Total of Items',3000),(632,6167,'EG','Jigar Gala ','Aarti Industries Limited ','EA','','','','22-67976596','','9920225180','[email protected]','pooja','2015-01-07 15:13:13','CQ. NO:267130','2015-01-15','PNB - ExportGenius','kindly confirm to your client','1280','2015-01-14 11:43:51',0,0,'Total of Items',1250),(633,6168,'EG','Cherian Moonjely','INDOFIL INDUSTRIES LIMITED','Senior Manager - International Business','','Mumbai','Maharastra-400059','2266637737','','9819171765','[email protected]','barkha','2015-01-07 15:17:09','neft','2015-01-15','PNB - ExportGenius','kindly confirm to your client','2247','2015-01-08 16:16:05',0,0,'Total of Items',2000),(634,6169,'EG','Deepak choudhary','Unique Arts','','Jaisingh Pura Road, Bhankrota, Jaipur','','','','','9828577554','[email protected]','pooja','2015-01-07 15:58:59',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(635,73,'IBN','Deepak choudhary','Unique Arts','','Jaisingh Pura Road, Bhankrota, Jaipur','','','','','9828577554','[email protected]','pooja','2015-01-07 16:03:49','cash','2015-01-09','ICICI - IBN','kindly confirm to your client','1350','2015-01-09 18:29:38',0,0,'Total of Items',1350),(636,6170,'EG','Vispi Nagwaswalla','Meril Life Sciences Pvt Ltd','','M1-M2 Meril Park Muktanand Marg Chala Vapi ','','Gujarat','','','09737299966','[email protected]','bhawna','2015-01-07 16:04:27','CQ- 988213 2015-01-19','2015-01-24','PNB - ExportGenius','kindly confirm to your client','22472','2015-01-15 18:30:26',0,0,'Total of Items',20000),(637,6171,'EG','Lalendra','Hay Carb PLC','','','','','94 773760806','','','[email protected]','ankur','2015-01-07 16:24:47','paypal','2015-01-09','PNB - ExportGenius','kindly confirm to your client','4570.8','2015-01-10 16:17:44',0,0,'Recieved Amount',4570.8),(638,6172,'EG','Prashant Shah','HEER PHARMA PVT LTD ','Owner','317, Unique Industrial Estate, Twin Tower Lane, Off Veer Savarkar Marg , Prabhadevi ','Mumbai','Maharashtra','','','9820051881','[email protected]','nitisha70701','2015-01-07 16:55:31','NEFT','2015-01-14','PNB - ExportGenius','kindly confirm to your client','4550','2015-01-16 10:58:36',0,10,'Total of Items',4500),(639,127,'CI','Naveen Kaul','Printlink Plates pvt. ltd','','asai Taluka Industrial Co-operative Society, Golani Naka, Vasai East',' Nala Sopara',' Maharashtra 401208','','','9702988857','[email protected]','nitisha70701','2015-01-07 17:49:45','CASH','2015-01-08','PNB - AshitaGupta','kindly confirm to your client','3000','2015-01-08 15:24:42',0,0,'Total of Items',3000),(640,6173,'EG','Ravin Jain','Jain Carpet Industries','Director','JCI House,Near Modern Hospital, Vibhav Nagar,Agra-282001,U.P India','Agra','U.P.','91-562-4031198','','8006772363','[email protected]','priyanka','2015-01-07 18:30:25','',NULL,'PNB - ExportGenius','','',NULL,0,0,'',0),(641,6174,'EG','Aditya Gupta','AAA Roller Flour Mills Pvt. Ltd.','Director','Gut No.114, Dingrajwadi Taluka - Shirur Dist - Pune (Maharashtra)','','','2228245673','','9867362746','[email protected]','barkha','2015-01-08 13:24:33','neft','2015-01-08','PNB - ExportGenius','kindly confirm to your client','2247','2015-01-08 16:54:56',0,0,'Total of Items',2000),(642,6175,'EG','Pinky Mulchandani','Phoeniks Agro & Engg Pvt Ltd','','J - 308, Mega Centre, Pune - Solapur Road, Hadapsar, Pune- 411028','Maharashtra, India','','+91 020 30461099','','7350200555','[email protected]','priyanka','2015-01-08 13:31:41','neft','2015-01-08','PNB - ExportGenius','kindly confirm to your client','1348.32','2015-01-09 13:38:30',0,0,'Total of Items',1200),(643,6176,'EG','LYN','SN','Manager','','','','','','8686868686','[email protected]','ankur','2015-01-08 14:18:28','paypal','2015-01-09','PNB - ExportGenius','kindly confirm to your client','5985.13','2015-01-08 16:43:38',0,0,'Recieved Amount',5985.13),(644,74,'IBN','Ravin Jain','Jain Carpet Industries','Director','JCI House,Near Modern Hospital, Vibhav Nagar,Agra-282001,U.P India','Agra','U.P.','91-562-4031198','','8006772363','[email protected]','priyanka','2015-01-08 15:20:06','neft','2015-01-28','ICICI - IBN','','20000','2016-01-11 13:14:22',0,0,'Total of Items',20000),(645,75,'IBN','ANIQ','INDIANTOUCH','','136,LAJPAT NAGAR MORADABAD INDIA.','','','','','9412244819','[email protected]','pooja','2015-01-08 15:23:49','cash','2015-01-08','ICICI - IBN','kindly confirm to your client','1500','2015-01-08 10:35:43',0,0,'Total of Items',1500),(646,6177,'EG','Anirban Chakraborty','Samsung C&T Corporation India Private Limited','Manager - Steel Division','Unit-602B, Tower 2, 6th Floor, Konnectus Building Bhavbhuti Marg, Near Minto Bridge, Connaught Place ','New Delhi - 110002','New delhi','+91 11 66069000','','+91 999 943 3630','[email protected]','nitisha70701','2015-01-08 15:26:42','NEFT','2015-01-14','PNB - ExportGenius','','71393','2015-01-14 16:09:58',0,10,'Total of Items',70600),(647,6178,'EG','Mr. Sumit Sehgal','BANSAL SPINNING MILLS LIMITED ','','G T Road, Giaspura Chowk, Adj Kansal Service Station, G T Road, Ludhiana, Punjab 141003','Ludhiana','Punjab','0161 251 0771','91-161-2845793','9316689118','[email protected]','priyanka','2015-01-08 15:32:21','CQ- 563196','2015-01-17','PNB - ExportGenius','sent till dec15','18540','2016-01-07 14:58:25',0,0,'Total of Items',20000),(648,76,'IBN','Sanjeev','Yashanis Overseas','','10 A, Willow Edenwoods, Pokharan- 2, ','THANE- (W )- 400610. ','Maharashtra','22 2589187','','9322600307','[email protected]','nitisha70701','2015-01-08 15:44:09','Transfer','2015-01-19','ICICI - IBN','kindly confirm to your client','3000','2015-01-20 18:09:35',0,0,'Total of Items',3000),(649,6179,'EG','Rohit Gupta','Arcom Paper','','GALA NO.G-25, SHAILESH INDUSTRIAL COMPLEX, SATIVALI ROAD, NEAR PROFESSIONAL COURIER, VASAI ROAD (EAST)',' THANE - 401208','Maharashtra','02503215687','','','[email protected]','anuj09','2015-01-08 15:44:35','neft','2015-01-10','PNB - ExportGenius','kindly confirm to your client','2247','2015-01-12 15:15:59',0,0,'Total of Items',2000),(650,77,'IBN',' Mr. Alok Upadyaya','Kiri Industries Ltd.','','Plot.No.299/1/A&B,293/2, Phase II, Near Water Tank, G.I.D.C. Industrial Estate, Vatva, Ahmedabad-382445-Gujarat-India','Ahmedabad','Gujarat','91-79-25894477, 40237404','',' 919825888145','[email protected]','priyanka','2015-01-08 16:26:11','neft','2015-01-08','ICICI - IBN','kindly confirm to your client','2500','2015-01-09 13:37:48',0,0,'Total of Items',2500),(651,6180,'EG','Vishwanath S.Kamath','Ambika Enterprises','','12 Sneh Milan CHS Ltd. Dewan Man Vasai (w) Thane ','','Mumbai','','','7507711300','[email protected]','bhawna','2015-01-08 18:05:17',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(652,78,'IBN','Mrugesh Patel ','Santosh Cera Tiles','','NH-8A, ','Morbi','Gujarat','','','9727300678','[email protected]','barkha','2015-01-08 18:12:16','cash','2015-01-09','ICICI - IBN','kindly confirm to your client','5000','2015-01-09 18:34:49',0,0,'Total of Items',5000),(653,6181,'EG','Mr. Anand','Anand Minerals and Chemicals','Director','Plot No.: 3/33, Sy. No.: 34/5 , Near Uplaon Cross, Humnabad Main Road,','Gulbarga','Karnataka','','','9916379365','[email protected]','nitisha70701','2015-01-09 11:34:41','cash','2015-01-08','PNB - ExportGenius','kindly confirm to your client','1240','2015-01-09 18:35:49',0,0,'Total of Items',1100),(654,6182,'EG','Kaushik Dutta','Naga Limited - Foods','','No. 1, Trichy Road, Dindigul - 624005','','TAMIL NADU','04512410121','','7708111336','[email protected]','bhawna','2015-01-09 13:26:04','neft','2015-01-10','PNB - ExportGenius','kindly confirm to your client','2696','2015-01-12 15:15:10',0,0,'Total of Items',2400),(655,6183,'EG','R.S.Bajoria','BAJORIA SHELLAC & GENERAL EXPORTS (P) LTD','','23A, NETAJI SUBASH ROAD, 7th floor, Room No.9 ',' KOLKATA-700 001','WEST BENGAL','','','','[email protected]','nitisha70701','2015-01-09 15:07:08','cash 2ND PAYMENT 2015-01-22 CASH','2015-01-14','PNB - ExportGenius','kindly confirm to your client','1250, 100','2015-01-09 18:36:48',0,0,'Total of Items',1200),(656,6184,'EG','Sanchit Garg','Garg Inox Ltd','','Vpo -Asaudha -siwan','Bahadurgarh','Haryana (INDIA)','1276 - 222222','1276 - 222000','9999880743','[email protected]','nitisha70701','2015-01-09 16:01:49','cq- 215665 2015-01-14','2015-01-15','PNB - ExportGenius','kindly confirm to your client','76588','2015-02-05 16:33:24',0,0,'Total of Items',75000),(657,6185,'EG','Rohit Prasad','GRP Limited','','510 \"A\" Wing Kohinoor City Commercial – I Kirol Road Off. L.B.Shastri Marg Kurla (W) ','Mumbai – 400070','Maharashtra','02267082549','','','[email protected]','anuj09','2015-01-09 16:08:18','neft','2015-01-13','PNB - ExportGenius','','2809','2015-01-14 13:02:26',0,0,'Total of Items',2500),(658,6186,'EG','Mr. Vinay Shetye','Ameera Shipping &Logistics Pvt Ltd.','Sales Head','601, Gauri Complex, 6th, Floor, Sector - 11, Opp Bank of India, CBD Belapur, Navi Mumbai- 400614.','Mumbai','Maharashtra','91-22-4012 8320','91-22-2757 0673','9821681719','[email protected]','priyanka','2015-01-09 16:48:21','neft','2015-01-12','PNB - ExportGenius','kindly confirm to your client','2247','2015-01-12 15:11:26',0,0,'Total of Items',2000),(659,6187,'EG','B. Murugesh','Ootys Enterprises Private Limited','','KEVGUCHI VILLAGE AT POST, DIST. THE NILGIRIRAH',' Ooty - 643104',' Tamil Nadu','4266-272787','','9442094420','[email protected]','barkha','2015-01-09 17:03:12','cash','2015-01-10','PNB - ExportGenius','kindly confirm to your client','1100','2015-01-10 16:40:00',0,0,'Total of Items',1000),(660,6188,'EG','jignesh','hari krishna enterprise','','A/4, Dhiyanagar society, opp. A.M.T.S Bus Stand','Naroda','Ahemdabad-382330','','','9879206333','[email protected]','pooja','2015-01-09 17:32:22','NEFT','2015-01-12','PNB - ExportGenius','kindly confirm to your client','2247','2015-01-12 15:14:04',0,0,'Total of Items',2000),(661,79,'IBN','Aswath','SRK Traders','','SRK Traders, 28, Tirupur Road, ','Udumalpet-642126 ','Tamil Nadu ','','','9566951663','[email protected]','pooja','2015-01-09 18:11:16',NULL,NULL,'ICICI - IBN',NULL,NULL,NULL,0,0,'',0),(662,6189,'EG','Sandeep Gupta','Association of Indian Forging Industry','','101/112 Nyati Millennium, Off Nagar Road, Vimannagar','Pune-411014','Maharashtra','020-26634099','','8975903717 ','[email protected]','anuj09','2015-01-10 13:42:30','cq. no:- 000278 2nd cq no- 000281 cq dt2015-01-21 rec dt2015-01-27','2015-01-14','PNB - ExportGenius','','7500, 7500','2015-01-28 17:29:09',0,0,'Total of Items',13350),(663,6190,'EG','Neeraj','PVR TEXTILES','','1026-1029, World Trade Center, Ring Road','Surat - 395002','Gujarat','0261-2341350','','','[email protected]','anuj09','2015-01-10 16:21:18','neft','2015-01-12','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','4500','2015-01-15 16:39:38',0,0,'Total of Items',4005),(664,6191,'EG','Baljit S Sabharwal','Fitco Engineers Pvt. Ltd.','Sales Director ','212, Gokul Industrial Estate, Marol, Andheri East ','','Mumbai','02265173455','','9819900293','[email protected]','bhawna','2015-01-12 12:02:10','NEFT','2015-01-14','PNB - ExportGenius','kindly confirm to your client','20224','2015-01-14 19:40:04',0,0,'Total of Items',18000),(665,6192,'EG','Shreyas C','CARBORUNDUM UNIVERSAL LIMITED','Purchase Dept.','PLOT NO.77,JIGANI-BOMMAASANDRA LINK ROAD, JIGANI INDUSTRIAL AREA, JIGANI,ANEKAL TQ., BANGALORE ','BANGALORE','KARNATAKA','080-30937306','','9886008965','[email protected]','aashita_8','2015-01-12 12:32:49','',NULL,'PNB - ExportGenius','','',NULL,0,0,'',0),(666,6193,'EG','Vikil Maheshwari','Sahara Polymers','','Q-10/41 Mangol Puri Near Katran Market ','New Delhi 110083','New Delhi','011–64717249 ','','9211523875','[email protected]','nitisha70701','2015-01-12 14:39:29',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(667,6194,'EG','Ash','Kookaburra Global Pty Limited ','','53 /31 Third Avenue , Blacktown','NSW','Australia -2148 ','','','','[email protected]','nitisha70701','2015-01-12 14:46:11','neft','2015-01-14','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','1912','2015-01-15 17:56:53',0,0,'Total of Items',1700),(668,6195,'EG','T R BHOWMICK','MEGACITY IRON & STEEL PRIVATE LIMITED','','No. 11-A, Charu Avenue ','Kolkata - 700 033','West Bengal , India','033-2424 2509 ','','9830060210','[email protected]','nitisha70701','2015-01-12 15:14:07','TRANSFER','2015-01-17','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','1685','2015-01-29 18:23:55',0,0,'Total of Items',1500),(669,6196,'EG','Salim Nedarya','Recon Exim India Pvt.Ltd','G.M.Operation','C-29 Raj Industrial Complex Millitary Road, Marol Maroshi Andheri (E) ','Mumbai 400059','Maharashtra','02242603333','','','[email protected]','anuj09','2015-01-12 15:20:49','cq- 037755 2015-01-13','2015-01-15','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','26545','2015-01-15 11:22:51',0,10,'Total of Items',26250),(670,6197,'EG','Mr. Upinder Wanchoo','ForDe International','','F-645, Third Floor, Palam Extension, Sector-7, Dwarka, New Delhi-110077.','Delhi','Delhi','011 45725740/41','91-11-45725742','9810158805','[email protected]','priyanka','2015-01-12 15:21:01','cash','2015-01-13','PNB - ExportGenius','kindly confirm to your client','5618','2015-01-15 12:30:53',0,0,'Total of Items',5000),(671,6198,'EG','KAMAL AGGARWAL','CHEMCON SPECIALITY CHEMICALS PRIVATE LIMITED','','Block No. 355, Manjusar-Kumpad Road, Manjusar Village, Savli','Vadodara-391 775','Gujrat','02667264103 ','','9825008195','[email protected]','nitisha70701','2015-01-12 16:09:46','NEFT','2015-01-13','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','86517','2015-01-24 12:09:38',0,0,'Total of Items',77000),(672,6199,'EG','Mr. Walter','PORTNEX INTERNATIONAL (PTY) LTD','Trader','Ground Floor, Chancellor House, 46 B Wierda Road West, Wierda Valley, Sandton, South Africa','','','27117830541','','27117830541','[email protected]','ankur','2015-01-12 16:15:55','WIRE','2015-01-19','PNB - ExportGenius','','7188','2015-01-19 13:06:42',0,0,'Recieved Amount',7188),(673,80,'IBN','Mr. Vishal Maheshwari','EURO SOLAR SYSTEM','','S-14/23, Shakti Arcade, Opp Water tank, Science city road, Sola. Ahmedabad-380060','Ahmedabad','Gujarat','','','9099016724','[email protected]','priyanka','2015-01-12 16:17:42','cq- 000188','2015-01-21','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','16000','2015-04-20 18:43:15',0,0,'Total of Items',16000),(674,6200,'EG','Manish Kumar','Krishana Exporters','','158 N C.C Complex New Road ','Kovilpatti - 628 501','Tamil Nadu','04632225598','','9894382021','[email protected]','anuj09','2015-01-13 10:31:06','NEFT','2015-01-13','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','1461','2015-01-21 17:32:57',0,0,'Total of Items',1300),(675,128,'CI','Kamal ','Hindustan Trading co.','','21 Kanhiya Naidu Street ','Chennai 600079','Tamil Nadu','44 2536 0054','','9840794409','[email protected]','nitisha70701','2015-01-13 14:43:31','CASH','2015-01-13','PNB - AshitaGupta','kindly confirm to your client','5800','2015-01-13 18:08:45',0,0,'Total of Items',5800),(676,6201,'EG','Jigar Gala','Aarti Industries Limited','EA','UDYOG KSHETRA , 2ND FLOOR, MULUND GOREGAON LINK ROAD ,ABOVE KRISHNA MOTORS,MULUND','WEST MUMBAI - 400080','','22-67976596','','9920225180','[email protected]','pooja','2015-01-13 18:07:13','cq- 267229','2015-01-29','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','2559','2015-01-29 12:00:01',0,0,'Total of Items',2500),(677,81,'IBN','Govind Bharuka','Bharuka Impeax','Director','56/2 , Balaji temple road','Hosur','TAMIL NADU','','','7667799990','[email protected]','nitisha70701','2015-01-14 10:54:37','cash','2015-01-14','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','4700','2015-01-29 16:52:38',0,0,'Total of Items',4700),(678,6202,'EG','Mr. Ganesh ','Sundaram & co.- Kammam','','4/8/4 prakash nagar, /khammam-507003 Telangana','','','','','09849121738','[email protected]','pooja','2015-01-14 11:57:44','neft','2015-01-14','PNB - ExportGenius','','7865','2015-01-14 15:49:36',0,0,'Total of Items',7000),(679,6203,'EG','Kaushik Dutta','Naga Limited - Foods','','No. 1, Trichy Road, Dindigul - 624005','','TAMIL NADU','04512410121','','7708111336','[email protected]','bhawna','2015-01-14 15:21:46',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(680,6204,'EG','Michele Paccagnini','PACCAGNINI & CO','','Via Ponte Salmoiraghi 16/18 , 20022 Castano Primo','Milan','Italy','','','','[email protected]','nitisha70701','2015-01-14 16:08:44','wire','2015-01-21','PNB - ExportGenius','kindly confirm to your client','9321','2015-01-21 13:22:44',0,0,'Recieved Amount',9321),(681,6205,'EG','Sherif','Hama Holding For Financial Investments','','105, Omar Ebn El-khatab Street, Almaza','Cairo','Egypt',' 002024139400 ','','00201207671222','[email protected]','anuj09','2015-01-14 17:23:49',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(682,6206,'EG','Sherif','Hama Holding For Financial Investments','','105, Omar Ebn El-khatab Street, Almaza','Cairo','Egypt',' 002024139400 ','','00201207671222','[email protected]','anuj09','2015-01-14 17:26:09',NULL,NULL,'PNB - ExportGenius',NULL,NULL,NULL,0,0,'',0),(683,6207,'EG','Umesh Mendapara','Apex Healthcare Ltd','MD','4710-GIDC Industrial Estate, Ankleshwar - 393 002','Ankleshwar','Gujarat','912646223525','91-2646-222525','9825711244','[email protected]','priyanka','2015-01-14 17:56:20','cq- 008075','2015-01-20','PNB - ExportGenius','kindly confirm to your client','3371','2015-01-20 19:44:47',0,0,'Total of Items',3000),(684,6208,'EG','J.S.Sethi','G. S. Sethisons','Owner','601, Central Plaza, 166,CST Road, Kalina','Mumbai','maharashtra','022-26650898','','','[email protected]','ankur','2015-01-14 19:42:44','NEFT','2015-01-15','PNB - ExportGenius','kindly confirm to your client','5056','2015-01-16 16:01:28',0,0,'Total of Items',4500),(685,6209,'EG','Yashwant Dadheech','modern insulators Ltd','','Post Box No. 23, Talheti Abu Road - 307 026','','Rajasthan','','','9413811308','[email protected]','anuj09','2015-01-16 10:51:29','cq- 019302 2015-02-03','2015-02-09','PNB - ExportGenius','','20224.80','2015-04-27 18:34:57',0,0,'Total of Items',18000),(686,6210,'EG','Mr. Ganesh ','Sundaram & co.- Kammam','','4/8/4 prakash nagar, /khammam-507003 Telangana','','','','','09849121738','[email protected]','pooja','2015-01-16 11:09:01','neft','2015-01-16','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','15700','2015-01-16 17:22:53',0,0,'Total of Items',14000),(687,6211,'EG','Jeni','Keerthy Agencies','','Kodimatha ','Kottayam - 686039',' Kerala','','','9605944444','[email protected]','nitisha70701','2015-01-16 12:24:57','neft','2015-01-16','PNB - ExportGenius','kindly confirm to your client','2809','2015-01-17 17:01:40',0,0,'Total of Items',2500),(688,129,'CI','Gautam Kalra','Suryansh Pharmachem','','C-27,Industrial Area,Phase 2 S.A.S. Nagar, Mohali','','Punjab','1722268435','','09876082829','[email protected]','bhawna','2015-01-16 14:35:21','CASH','2015-01-16','PNB - AshitaGupta','KINDLY CONFIRM TO YOUR CLIENT','3000','2015-01-16 17:24:45',0,0,'Total of Items',3000),(689,6212,'EG','Darshan P. Patel','Flexatherm Expanllow Pvt. Ltd.','','354, G.I.D.C. Makarpura','Vadodara - 390010','Gujarat','02652644941','','9662546354','[email protected]','anuj09','2015-01-16 15:12:00','NEFT','2015-01-29','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','25590','2015-01-29 18:34:30',0,10,'Total of Items',25000),(690,130,'CI','George','Pooppally Coir Mills','','AS Road','Alleppey 688 007','Kerala','0477 224 5518','','','[email protected]','nitisha70701','2015-01-16 16:34:06','cash','2015-01-16','PNB - AshitaGupta','kindly confirm to your client','3000','2015-01-16 13:47:42',1,0,'Total of Items',3000),(691,6213,'EG','Hashim Shah','GAINSCOM LOGISTICS PVT. LTD.','','16, 1st Floor, Faiz-E-Edroos, 371/373, Narshi Natha Street','Masjid (West)','Mumbai 400009','','','9820182598','[email protected]','pooja','2015-01-16 17:21:07','cq- 288462','2015-01-19','PNB - ExportGenius','kindly confirm to your client','1123.60','2015-01-19 18:06:06',0,0,'Total of Items',1000),(692,82,'IBN','Mr. Kartavya','KASHISH INCORPORATION ','Owner','D-30 Lajpat Nagar-i,, New Delhi, Delhi, India','Delhi','Delhi','91-11-29812151','91-11-29812151','9873759588','[email protected]','priyanka','2015-01-16 17:51:20','neft','2015-01-21','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','2000','2015-01-21 17:31:22',0,0,'Total of Items',2000),(693,6214,'EG','R.S.Bajoria','BAJORIA SHELLAC & GENERAL EXPORTS (P) LTD','','23A, NETAJI SUBASH ROAD, 7th floor, Room No.9 ',' KOLKATA-700 001','WEST BENGAL','','','','[email protected]','nitisha70701','2015-01-17 10:37:59','CASH','2015-01-22','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','3600','2015-01-22 18:34:15',0,0,'Total of Items',3200),(694,83,'IBN','Zulfikar','Apex Tarmac Pvt. Ltd.','','Bypass Road, Nr.RTO Office,Opp. Amosa','Himmatnagar-383 001','Gujrat (INDIA)','2772-223693/94','2772-223694','9825817656','[email protected]','barkha','2015-01-17 10:43:50','CASH','2015-01-16','ICICI - IBN','kindly confirm to your client','5000','2015-01-17 13:49:25',0,0,'Total of Items',5000),(695,84,'IBN','Nishant','NISHANT INTERNATIONAL','','SHOP NO.205, 1ST FLOOR, OREVA,LANDMARK,, BELOW HOTEL SHIV AJANTA, NR. TRAJPAR CROSSING','MORBI','GUJARAT-363642','2822-250003/251707','','9377751707','[email protected]','barkha','2015-01-17 10:55:29','cash','2015-01-13','ICICI - IBN','KINDLY CONFIRM TO YOUR CLIENT','1000','2015-01-30 17:27:14',0,0,'Total of Items',1000),(696,85,'IBN','saurabh Arora','Batra Trading','','jodhpur, Rajasthan','','','','','9413873691','[email protected]','pooja','2015-01-17 11:50:03','NEFT','2015-01-17','ICICI - IBN','kindly confirm to your client','2500','2015-01-17 13:50:09',0,0,'Total of Items',2500),(697,86,'IBN','Hardik','Paramount Plastic Corporation','Director','AJ LAXMI COMPLEX, BJ-18, KALHER AREA, BHIWANDI ROAD','DIST-THANE, Bhiwandi - 421302,','Maharastra ','','022 23714835','9967329031','[email protected]','barkha','2015-01-17 12:22:25','neft','2015-01-27','ICICI - IBN','kindly confirm to your client','2400','2015-01-27 14:34:34',0,0,'Total of Items',2400),(698,6215,'EG','Anil Soni','WELLPACK INDUSTRIES','','9-AJI Vasahat, 80Ft. Road, Near Ajay Weigh Bridge','Rajkot-360003','Gujarat','281-6592888','','9925528703','[email protected]','barkha','2015-01-17 13:00:32','NEFT','2015-01-19','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','5056','2015-01-29 18:12:20',0,0,'Total of Items',4500),(699,6216,'EG','VV Krishna Reddy','Sri Krishna Pharmaceuticals Ltd','','C-4;Industrial Area,Uppal','Hyderabad - 500039','Andhra Pradesh','040-27201101','','9849003256','[email protected]','anuj09','2015-01-17 13:08:11','neft','2015-01-22','PNB - ExportGenius','sent jnpt import SENT TILL DEC15, jnpt export sent till DEC15, import party dec15','71652','2016-01-14 17:25:40',0,0,'Total of Items',70000),(700,6217,'EG','MANISH ','Maize Product','','1E/19B, 2nd Floor, Jhandewalan Extension ','New Delhi-110055','Delhi','','','9891855160','[email protected]','anuj09','2015-01-17 13:36:39','CQ- 573529 2015-01-19','2015-01-19','PNB - ExportGenius','kindly confirm to your client','4000','2015-01-19 18:13:19',0,0,'Total of Items',3560),(701,6218,'EG','ankit','lykis limited','','Grandeur Building, 4th Floor, Opp. Gundecha Symphony, Veera Desai Road, Andheri (W)','Mumbai-400053','Maharashtra','','','9167775723','[email protected]','anuj09','2015-01-17 13:43:56','neft','2015-01-29','PNB - ExportGenius','KINDLY CONFIRM TO YOUR CLIENT','10112','2015-01-29 13:37:03',0,10,'Total of Items',10000); | |
| /* create table invoice_items*/ | |
| CREATE TABLE invoice_items ( | |
| Id int(11) NOT NULL DEFAULT '0', | |
| invoice_id int(11) NOT NULL, | |
| Data_Type varchar(100) NOT NULL, | |
| Query varchar(200) NOT NULL, | |
| Date_From date NOT NULL, | |
| Date_To date NOT NULL, | |
| Total_Months tinyint(4) NOT NULL, | |
| Amount bigint(20) NOT NULL, | |
| Mode_Of_Delivery varchar(45) NOT NULL, | |
| Currency int(1) NOT NULL DEFAULT '0', | |
| status varchar(25) DEFAULT 'Proceed', | |
| added_on datetime DEFAULT NULL, | |
| user_id varchar(45) DEFAULT NULL, | |
| payment_status varchar(25) DEFAULT 'Not Recieved', | |
| data_status varchar(25) DEFAULT 'Not Sent', | |
| for_customization int(1) DEFAULT '0', | |
| country varchar(100) DEFAULT NULL, | |
| direction varchar(45) DEFAULT NULL | |
| ) ENGINE=InnoDB; | |
| /* insert into invoice items */ | |
| INSERT INTO invoice_items VALUES (832,601,'Kolkata Sea Export','1101','2014-04-01','2014-04-30',1,1000,'Email',0,'Processed','2015-01-02 12:55:00','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(833,602,'JNPT export ','0904','2014-09-01','2014-11-30',3,6600,'Email',0,'Processed','2015-01-02 13:31:34','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(834,603,'Cochin sea import ','Roof tile','2014-11-01','2014-11-30',1,2500,'Email',0,'Processed','2015-01-02 13:47:55','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(835,604,'china export ','15050000','2014-12-01','2014-12-31',1,112,'Email',1,'Processed','2015-01-02 15:35:31','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(836,605,'Chennai Sea export ','0703','2014-11-01','2014-11-30',1,2000,'Email',0,'Canceled','2015-01-02 15:49:56','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(838,607,'India export ','Chapter 29','2015-01-01','2015-12-31',12,135000,'Email',0,'Processed','2015-01-02 18:09:45','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(839,608,'MUNDRA EXPORT','6908','2013-11-01','2015-01-03',13,8000,'Email',0,'Canceled','2015-01-03 16:24:21','bhawna','Not Recieved','Not Sent',0,NULL,NULL),(840,609,'CH-52, 17, 11 (Cotton, Sugar, Wheat Flour)','JNPT Export','2014-12-01','2014-12-31',1,5000,'Email',0,'Processed','2015-01-05 11:33:21','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(841,610,'JNPT export','76169990','2014-11-01','2014-11-30',1,1500,'Email',0,'Canceled','2015-01-05 12:45:52','pooja','Not Recieved','Not Sent',0,NULL,NULL),(842,611,'JNPT EXPORT SP','76169990','2014-11-01','2014-11-30',1,1500,'Email',0,'Processed','2015-01-05 13:00:01','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(843,612,'JNPT Import Both Sides & TKD Import','6804','2014-11-01','2014-11-30',1,4000,'Email',0,'Processed','2015-01-05 16:40:57','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(844,613,'China Import','02023000','2014-11-01','2014-11-30',1,5670,'Email',1,'Canceled','2015-01-06 11:26:02','priyanka','Not Recieved','Not Sent',0,NULL,NULL),(845,614,'India export (All Ports)','282760','2015-07-01','2015-12-31',6,620,'Email',1,'Canceled','2015-01-06 12:47:37','priyanka','Not Recieved','Not Sent',0,NULL,NULL),(846,613,'China Import','02023000 (Beef Meat)','2014-11-01','2014-11-30',1,5670,'Email',0,'Processed','2015-01-06 13:13:24','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(847,615,'China Export','29309020 ( Xanthate) ','2014-12-01','2014-12-31',1,6000,'Email',0,'Processed','2015-01-06 13:27:41','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(848,616,'Kolkata Sea Export','1101','2013-12-01','2014-02-28',3,3000,'Email',0,'Processed','2015-01-06 14:37:06','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(849,617,'JNPT Import Both Side','Chapter 72 and 76','2014-12-01','2014-12-31',1,5000,'Email',0,'Canceled','2015-01-06 14:41:44','anuj09','Not Recieved','Not Sent',0,NULL,NULL),(850,617,'JNPT Export','7615','2014-12-01','2014-12-31',1,1500,'Email',0,'Canceled','2015-01-06 14:42:30','anuj09','Not Recieved','Not Sent',0,NULL,NULL),(851,608,'MUNDRA EXPORT','6908','2013-11-01','2014-11-30',13,8000,'Email',0,'Processed','2015-01-06 14:57:16','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(852,618,'JNPT import SP ','Ch-48','2014-12-01','2014-12-31',1,2000,'Email',0,'Processed','2015-01-06 15:47:35','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(853,619,'JNPT import SP','53061090','2014-12-01','2014-12-31',1,1000,'Email',0,'Canceled','2015-01-06 16:22:49','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(854,620,'JNPT import SP','53061090','2014-12-01','2014-12-31',1,1000,'Email',0,'Processed','2015-01-06 16:24:02','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(855,621,'Vietnam Import ','HS Code: 44034910 ','2014-03-01','2014-08-31',6,16740,'Email',0,'Processed','2015-01-06 16:29:24','ankur','Payment Recieved','Data Sent',0,NULL,NULL),(856,622,'Nhava Sheva Import Partial ','Ch-40','2014-12-01','2014-12-31',1,1000,'Email',0,'Processed','2015-01-06 16:32:00','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(857,623,'Nhava Sheva Import SP','ch-40','2014-12-01','2014-12-31',1,2000,'Email',0,'Canceled','2015-01-06 16:33:59','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(858,624,'JNPT import SP','ch-72','2014-12-01','2014-12-31',1,1500,'Email',0,'Processed','2015-01-06 16:49:22','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(859,625,'JNPT IMPORT ','ch-51','2014-12-01','2014-12-31',1,1700,'Email',0,'Canceled','2015-01-06 17:05:46','pooja','Not Recieved','Not Sent',0,NULL,NULL),(860,626,'Indonesia Import & Export','HS Code 38021000','2014-10-01','2014-10-31',1,200,'Email',1,'Processed','2015-01-06 17:19:32','ankur','Payment Recieved','Data Sent',0,NULL,NULL),(861,627,'JNPT import SP ','55101110','2014-06-01','2014-06-30',1,1000,'Email',0,'Processed','2015-01-06 18:10:30','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(862,614,'India export ','282760','2014-07-01','2014-12-31',6,620,'Email',1,'Processed','2015-01-07 10:47:09','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(863,628,'Nhava Sheva Import Partial ','87089900 ','2013-06-01','2013-06-30',1,1000,'Email',0,'Processed','2015-01-07 11:06:52','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(864,628,'Mumbai air Import partial','84314990','2013-05-01','2013-05-31',1,1000,'Email',0,'Processed','2015-01-07 11:07:49','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(865,625,'JNPT IMPORT ','ch-51','2014-12-01','2014-12-31',1,1700,'Email',0,'Canceled','2015-01-07 12:15:16','pooja','Not Recieved','Not Sent',0,NULL,NULL),(866,629,'JNPT IMP. both side','ch-51','2014-12-01','2014-12-31',1,1700,'Email',0,'Processed','2015-01-07 12:43:58','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(867,630,'Delhi air & JNPT export ','63049280 (ABC Home concept)','2014-11-01','2014-11-30',1,1500,'Email',0,'Processed','2015-01-07 13:18:32','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(868,630,'Delhi Air export','63049280','2014-09-01','2014-09-30',1,500,'Email',0,'Canceled','2015-01-07 13:19:30','pooja','Not Recieved','Not Sent',0,NULL,NULL),(869,630,'TKD export','63049280 (ABC Home concept)','2014-08-01','2014-08-31',1,1000,'Email',0,'Canceled','2015-01-07 13:20:39','pooja','Not Recieved','Not Sent',0,NULL,NULL),(870,630,'Delhi Air export','63049280 (ABC Home concept)','2014-09-01','2014-09-30',1,500,'Email',0,'Processed','2015-01-07 13:22:26','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(871,631,'Mundra Export','1101','2014-12-01','2014-12-31',1,1000,'Email',0,'Canceled','2015-01-07 13:24:05','barkha','Not Recieved','Not Sent',0,NULL,NULL),(872,630,'TKD Export','63049280 (ABC Home concept)','2014-08-01','2014-08-31',1,500,'Email',0,'Processed','2015-01-07 13:24:12','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(873,631,'Mundra Export','1101, 1001 & 1006','2014-12-01','2014-12-31',1,3000,'Email',0,'Processed','2015-01-07 14:01:51','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(874,632,'JNPT EXPORT SP','hs code 3402 ','2014-12-01','2014-12-31',1,1250,'Email',0,'Processed','2015-01-07 15:13:13','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(875,633,'JNPT Export SP','3808','2014-12-01','2014-12-31',1,2000,'Email',0,'Processed','2015-01-07 15:17:09','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(876,634,'Mundra Export','94036000 , 94032090 , 94035090 ','2014-11-01','2014-11-30',1,1350,'Email',0,'Canceled','2015-01-07 15:58:59','pooja','Not Recieved','Not Sent',0,NULL,NULL),(877,635,'Mundra Export','94036000 , 94032090 ','2014-11-01','2014-11-30',1,1350,'Email',0,'Processed','2015-01-07 16:03:49','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(878,636,'INDIA EXPORT(all available ports)','IEC Wise Data','2014-01-01','2014-01-31',1,5000,'Email',0,'Processed','2015-01-07 16:04:27','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(879,636,'INDIA EXPORT(all available ports)','IEC Wise Data','2014-02-01','2014-02-28',1,5000,'Email',0,'Processed','2015-01-07 16:05:35','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(880,636,'INDIA EXPORT(all available ports)','IEC Wise Data','2014-04-01','2014-04-30',1,5000,'Email',0,'Processed','2015-01-07 16:06:32','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(881,636,'INDIA EXPORT(all available ports)','IEC Wise Data','2014-10-01','2014-10-31',1,5000,'Email',0,'Processed','2015-01-07 16:07:31','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(882,637,'Vietnam Export Data','HS Code 38021000','2014-11-01','2014-11-30',1,80,'Email',1,'Processed','2015-01-07 16:24:47','ankur','Payment Recieved','Data Sent',0,NULL,NULL),(883,638,'JNPT export ','ch-29','2014-12-01','2014-12-31',1,5000,'Email',0,'Canceled','2015-01-07 16:55:31','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(884,639,'JNPT export ','39206290','2014-11-01','2014-12-31',2,3000,'Email',0,'Processed','2015-01-07 17:49:45','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(885,640,'Export- JNPT (SP) & Delhi Air','5701','2015-01-01','2015-12-31',12,20000,'Email',0,'Canceled','2015-01-07 18:30:25','priyanka','Not Recieved','Not Sent',0,NULL,NULL),(886,641,'JNPT Export SP','1006 & 1101','2014-12-01','2014-12-31',1,2000,'Email',0,'Processed','2015-01-08 13:24:33','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(887,642,'JNPT Export (SP)','Ch 9','2014-11-01','2014-11-30',1,1200,'Email',0,'Processed','2015-01-08 13:31:41','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(888,643,'JNPT Export','Ch 29 Export','2014-10-01','2014-11-30',2,50,'Email',1,'Processed','2015-01-08 14:18:29','ankur','Payment Recieved','Data Sent',0,NULL,NULL),(889,644,'Export- JNPT (SP) & Delhi Air','5701','2015-01-01','2015-12-31',12,20000,'Email',0,'Processed','2015-01-08 15:20:06','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(890,645,'JNPT EXPORT SP','HS CODE: 17019990 ','2014-12-01','2014-12-31',1,1500,'Email',0,'Processed','2015-01-08 15:23:49','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(891,646,'JNPT , Kandla , Mundra, Chennai sea , Kolkata Sea import ','ch-72','2014-04-01','2014-12-31',9,64836,'Email',0,'Processed','2015-01-08 15:26:42','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(892,646,'BPT import ','ch-72','2014-09-01','2014-12-31',4,5764,'Email',0,'Processed','2015-01-08 15:27:44','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(893,647,'JNPT Export (SP)','5509 & 5107','2015-01-01','2015-12-31',12,20000,'Email',0,'Processed','2015-01-08 15:32:21','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(894,648,'JNPT import SP','55101110','2014-09-01','2014-09-30',1,1000,'Email',0,'Canceled','2015-01-08 15:44:09','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(895,648,'JNPT import SP','55101110','2014-12-01','2014-12-31',1,1000,'Email',0,'Canceled','2015-01-08 15:44:27','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(896,649,'JNPT Import Both Side','48119099','2014-10-01','2014-10-31',1,2000,'Email',0,'Processed','2015-01-08 15:44:35','anuj09','Payment Recieved','Data Sent',0,NULL,NULL),(897,650,'Export- JNPT (SP), Ahmedabad ICD, Mundra, Pipav','3204','2014-12-01','2014-12-31',1,2500,'Email',0,'Processed','2015-01-08 16:26:11','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(898,651,'JNPT EXPORT','Chapter-07','2014-12-01','2014-12-31',1,2000,'Email',0,'Canceled','2015-01-08 18:05:17','bhawna','Not Recieved','Not Sent',0,NULL,NULL),(899,652,'Mundra Sea Export','69089090','2014-07-01','2014-12-31',6,5000,'Email',0,'Processed','2015-01-08 18:12:16','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(900,653,'JNPT export ','25081090','2014-12-01','2014-12-31',1,1100,'Email',0,'Processed','2015-01-09 11:34:41','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(901,654,'Chennai Sea Export','CHAPTER-11 & 19','2014-11-01','2014-11-30',1,2400,'Email',0,'Processed','2015-01-09 13:26:04','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(902,655,'Kolkata Air export ','13019099','2014-12-01','2014-12-31',1,1200,'Email',0,'Processed','2015-01-09 15:07:08','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(903,656,'Indonesia import ','72230001','2014-08-01','2014-10-31',3,17000,'Email',0,'Canceled','2015-01-09 16:01:49','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(904,656,'Indonesia Import ','72230091','2014-08-01','2014-10-31',1,17000,'Email',0,'Canceled','2015-01-09 16:04:22','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(905,656,'Philippines Import','72230091','2014-07-01','2014-09-30',3,15000,'Email',0,'Processed','2015-01-09 16:05:46','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(906,656,'Indonesia import ','72230091','2014-08-01','2014-10-31',3,17000,'Email',0,'Processed','2015-01-09 16:06:25','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(907,656,'Sri Lanka Import ','Aluminium alloy','2013-10-01','2013-11-30',2,7000,'Email',0,'Processed','2015-01-09 16:07:56','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(908,657,'USA Import','Reclaim Rubber (40030000)','2014-05-01','2014-05-31',1,2500,'Email',0,'Processed','2015-01-09 16:08:18','anuj09','Payment Recieved','Data Sent',0,NULL,NULL),(909,656,'Brazil Import Partial ','72230091','2014-01-01','2014-12-31',12,30000,'Email',0,'Processed','2015-01-09 16:08:51','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(910,656,'Russia import ','72230091 and 76052990','2014-03-01','2014-05-31',3,6000,'Email',0,'Processed','2015-01-09 16:10:29','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(911,658,'JNPT Export (SP)','6203','2014-10-01','2014-10-31',1,2000,'Email',0,'Processed','2015-01-09 16:48:21','priyanka','Payment Recieved','Data Sent',0,NULL,NULL),(912,659,'Tughlakabad ICD Import One Side','090240','2014-11-01','2014-11-30',1,1000,'Email',0,'Processed','2015-01-09 17:03:12','barkha','Payment Recieved','Data Sent',0,NULL,NULL),(913,660,'JNPT EXPORT SP','Hs code : 72159020 ','2014-11-01','2014-12-31',2,2000,'Email',0,'Processed','2015-01-09 17:32:22','pooja','Payment Recieved','Data Sent',0,NULL,NULL),(914,661,'Chennai sea export','Hs Code 12024210 ','2014-11-01','2014-11-30',1,1300,'Email',0,'Proceed','2015-01-09 18:11:16','pooja','Not Recieved','Not Sent',0,NULL,NULL),(915,574,'JNPT export ','Ch-84','2014-11-01','2014-12-31',2,4500,'Email',0,'Processed','2015-01-10 11:49:15','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(916,662,'India Import Statistical Data','21 HS code','2013-04-01','2014-03-31',12,13350,'Email',0,'Processed','2015-01-10 13:42:30','anuj09','Payment Recieved','Data Sent',0,NULL,NULL),(917,663,'JNPT Export','Chapter 62','2014-12-01','2014-12-31',1,1335,'Email',0,'Processed','2015-01-10 16:21:18','anuj09','Payment Recieved','Data Sent',0,NULL,NULL),(918,663,'Kolkata Sea Export','Chapter 62','2014-09-01','2014-09-30',1,1335,'Email',0,'Processed','2015-01-10 16:22:00','anuj09','Payment Recieved','Data Sent',0,NULL,NULL),(919,663,'Tuticorin Sea Export','Chapter 10, 19, 33 & 34','2014-07-01','2014-07-31',1,1335,'Email',0,'Canceled','2015-01-10 16:22:39','anuj09','Not Recieved','Not Sent',0,NULL,NULL),(920,664,'JNPT EXPORT','CHAPTER-40','2014-01-01','2014-09-30',9,10800,'Email',0,'Processed','2015-01-12 12:02:10','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(921,664,'MUMBAI AIR EXPORT','CHAPTER-40','2014-01-01','2014-02-28',2,2400,'Email',0,'Processed','2015-01-12 12:06:04','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(922,664,'MUMBAI AIR EXPORT','CHAPTER-40','2014-04-01','2014-04-30',1,1200,'Email',0,'Processed','2015-01-12 12:07:16','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(923,664,'MUMBAI AIR EXPORT','CHAPTER-40','2014-05-01','2014-05-31',1,1200,'Email',0,'Processed','2015-01-12 12:08:14','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(924,664,'MUMBAI AIR EXPORT','CHAPTER-40','2014-08-01','2014-08-31',1,1200,'Email',0,'Processed','2015-01-12 12:09:19','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(925,664,'MUMBAI AIR EXPORT','CHAPTER-40','2014-09-01','2014-09-30',1,1200,'Email',0,'Processed','2015-01-12 12:10:30','bhawna','Payment Recieved','Data Sent',0,NULL,NULL),(926,665,'INDIA IMPORT','84 & 85','2013-10-01','2014-03-31',6,62500,'Email',0,'Canceled','2015-01-12 12:32:49','aashita_8','Not Recieved','Not Sent',0,NULL,NULL),(927,638,'JNPT export ','ch-29','2014-12-01','2014-12-31',1,1500,'Email',0,'Processed','2015-01-12 12:55:38','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(928,638,'Hyderabad air export ','ch-29','2014-08-01','2014-09-30',2,3000,'Email',0,'Processed','2015-01-12 12:56:21','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(929,663,'Tuticorin Sea Export','Chapter 62','2014-07-01','2014-07-31',1,1335,'Email',0,'Processed','2015-01-12 12:56:41','anuj09','Payment Recieved','Data Sent',0,NULL,NULL),(930,666,'JNPT Export ','Ch-39','2014-11-01','2014-12-31',2,2000,'Email',0,'Canceled','2015-01-12 14:39:29','nitisha70701','Not Recieved','Not Sent',0,NULL,NULL),(931,667,'chennai sea import','ch-41','2014-12-01','2014-12-31',1,1700,'Email',0,'Processed','2015-01-12 14:46:11','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL),(932,668,'Kolkata Sea export','73259910','2014-09-01','2014-09-30',1,1500,'Email',0,'Processed','2015-01-12 15:14:07','nitisha70701','Payment Recieved','Data Sent',0,NULL,NULL); | |
| /* create leads table */ | |
| CREATE TABLE leads ( | |
| id int(11) NOT NULL DEFAULT '0', | |
| client_id int(11) NOT NULL, | |
| lead_source varchar(100) DEFAULT NULL, | |
| importance varchar(45) NOT NULL DEFAULT 'High', | |
| added_on datetime NOT NULL, | |
| user_id varchar(45) NOT NULL, | |
| requirement varchar(250) NOT NULL, | |
| report_type varchar(100) DEFAULT NULL, | |
| time_from date DEFAULT NULL, | |
| time_to date DEFAULT NULL, | |
| opening_price varchar(200) DEFAULT NULL, | |
| closing_price varchar(20) DEFAULT NULL, | |
| status varchar(45) NOT NULL DEFAULT 'Followup', | |
| causes varchar(100) DEFAULT NULL, | |
| invoice_id int(11) DEFAULT NULL, | |
| temp varchar(1000) DEFAULT NULL | |
| ) ENGINE=InnoDB; | |
| /* insert into leads */ | |
| INSERT INTO `leads` VALUES (3642,2184,'Email','High','2015-01-02 12:48:20','barkha','1101','Kolkata Sea Export',NULL,NULL,'','1000','Close Successfully','',601,NULL),(3643,3397,'Email','High','2015-01-02 13:30:48','nitisha70701','0904','JNPT export ',NULL,NULL,'6600','6600','Close Successfully','',602,NULL),(3644,1764,'Email','High','2015-01-02 13:46:36','nitisha70701','Roof tile','Cochin sea import ','2014-11-01','2014-11-30','2500','2500','Close Successfully','',603,NULL),(3645,1129,'Email','High','2015-01-02 15:34:25','nitisha70701','15050000','china export ',NULL,NULL,'112','112','Close Successfully','',604,NULL),(3646,2816,'Email','High','2015-01-02 15:49:17','nitisha70701','0703','Chennai Sea export ','2014-11-01','2014-11-30','2000',NULL,'Not Intrested','Not Required',605,NULL),(3647,3398,'Email','High','2015-01-02 15:59:38','bhawna','not specified','not specified',NULL,NULL,'','','Followup','',NULL,NULL),(3648,3399,'Email','High','2015-01-02 16:12:31','bhawna','various products ','INDIA EXPORT',NULL,NULL,'','','Followup','',NULL,NULL),(3649,3400,'Email','Medium','2015-01-02 16:50:17','nitisha70701','tyres','pakistan import',NULL,NULL,'','','Not Intrested','Data Report Availability',NULL,NULL),(3650,3401,'Email','High','2015-01-02 16:51:54','bhawna','vegetables, milk products etc','',NULL,NULL,'','','Followup','',NULL,NULL),(3651,2490,'Email','High','2015-01-02 17:31:43','pankaj','29','export','2015-01-07','2015-01-08','1200',NULL,'Not Intrested','Not Required',606,NULL),(3652,3402,'Email','High','2015-01-02 17:34:56','nitisha70701','3919(self adhesive tape)','JNPT export ',NULL,NULL,'','','Not Intrested','Company Drop the Project for a While',NULL,NULL),(3653,3403,'Email','High','2015-01-02 17:43:18','priyanka','02023000','china Import',NULL,NULL,'','5670','Close Successfully','Not Required',613,NULL),(3654,3404,'Email','High','2015-01-02 17:45:22','priyanka','Not Specified','',NULL,NULL,'','310','Close Successfully','',770,NULL),(3655,3405,'Email','High','2015-01-02 17:45:31','pooja','not specified','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3656,3406,'Email','High','2015-01-02 17:47:06','pooja','trigonox 101 ','ind. imp.',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3657,3407,'Email','High','2015-01-02 17:48:08','nitisha70701','User Registration','User Registration',NULL,NULL,'','','Followup','',NULL,NULL),(3658,2490,'Email','High','2015-01-02 18:03:23','priyanka','Chapter 29','India export ',NULL,NULL,'','135000','Close Successfully','',607,NULL),(3659,3408,'Email','High','2015-01-02 18:25:18','barkha','nothing mentioned','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3660,3409,'Email','High','2015-01-02 18:26:35','barkha','nothing mentioned','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3661,3410,'Email','High','2015-01-02 18:27:54','barkha','Neem Leaf','India Export',NULL,NULL,'','','Not Intrested','Data Report Availability',NULL,NULL),(3662,3411,'Email','High','2015-01-03 12:06:17','anuj09','Not specified any requirement','China Export Data',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3663,3412,'Email','High','2015-01-03 12:23:45','bhawna','not specified','not specified',NULL,NULL,'','','Followup','',NULL,NULL),(3664,3413,'Email','High','2015-01-03 12:36:11','barkha','INTERESTED IN MINERAL LIKE QUARTZ/FEDLSPAR/MICA','India Export',NULL,NULL,'','','Not Intrested','Company Drop the Project for a While',NULL,NULL),(3665,3412,'Email','High','2015-01-03 13:33:42','bhawna','4802(A4 PAPER)','india import & JNPT IMPORT',NULL,NULL,'','','Followup','',NULL,NULL),(3666,3414,'Email','High','2015-01-03 15:42:45','anuj09','Chicken Feet','Vietnam Import Data',NULL,NULL,'','','Not Intrested','Concern Person is not Available',NULL,NULL),(3667,3260,'Email','High','2015-01-03 16:20:07','bhawna','6908','MUNDRA EXPORT',NULL,NULL,'','8000','Close Successfully','',608,NULL),(3668,3415,'Email','High','2015-01-03 17:36:42','priyanka','coal','IMPORT DATA ',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3669,3416,'Email','High','2015-01-03 17:50:09','pooja','not specified','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3670,1662,'Self Generated','High','2015-01-05 11:32:33','pooja','JNPT Export','CH-52, 17, 11 (Cotton, Sugar, Wheat Flour)',NULL,NULL,'','5000','Close Successfully','',609,NULL),(3671,3417,'Email','High','2015-01-05 11:59:10','bhawna','bicycles & parts','INDIA EXPORT',NULL,NULL,'','','Followup','',NULL,NULL),(3672,3418,'Email','High','2015-01-05 12:08:04','anuj09','Sports Good','India export data',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3673,3419,'Email','High','2015-01-05 12:29:37','barkha','chlorinated polyethylene','India Import',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3674,3420,'Email','High','2015-01-05 12:31:36','barkha','brass cable gland','India Export',NULL,NULL,'','','Followup','',NULL,NULL),(3675,3421,'Email','High','2015-01-05 12:32:57','barkha','nothing mentioned','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3676,3422,'Email','High','2015-01-05 12:44:14','anuj09','Not specified any requirement','',NULL,NULL,'',NULL,'Not Intrested','Not Required',681,NULL),(3677,3423,'Self Generated','High','2015-01-05 12:45:12','pooja','76169990','JNPT export','2014-11-01','2014-11-30','1500',NULL,'Invoice Sent','',610,NULL),(3678,3424,'Email','High','2015-01-05 12:56:31','bhawna','Eyelets','INDIA EXPORT',NULL,NULL,'','','Followup','',NULL,NULL),(3679,3423,'Self Generated','High','2015-01-05 12:59:13','pooja','76169990','JNPT EXPORT SP',NULL,NULL,'','1500','Close Successfully','',611,NULL),(3680,3425,'Email','High','2015-01-05 13:28:15','anuj09','De Oiled Rice Bran','India Export data',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3681,3426,'Email','High','2015-01-05 15:00:48','barkha','planning to export Basmati rice ','India Export',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3682,3427,'Email','High','2015-01-05 15:03:03','barkha','nothing mentioned','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3683,1292,'Email','High','2015-01-05 16:38:39','barkha','6804','JNPT Import Both Sides & TKD Import',NULL,NULL,'4000','4000','Close Successfully','',612,NULL),(3684,3428,'Email','High','2015-01-05 17:15:24','bhawna','Gum Copal, Gum Damar and Damar Batu ','Indonesia import ',NULL,NULL,'','','Followup','',NULL,NULL),(3685,3429,'Email','High','2015-01-05 17:24:49','priyanka','45041090 & 72269990 ','Export report',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3686,3430,'Email','High','2015-01-05 17:33:24','priyanka','induction hob/stoves','Vietnam Importers',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3687,2191,'Email','High','2015-01-05 17:36:58','bhawna','Ronidazole & Glyoxylic acid ','india import , brazil & china',NULL,NULL,'','','Followup','',NULL,NULL),(3688,3431,'Email','Medium','2015-01-05 17:44:03','nitisha70701','Not Specified','India import',NULL,NULL,'','','Followup','',NULL,NULL),(3689,3432,'Email','High','2015-01-05 17:46:38','nitisha70701','Not Specified','India import & export ',NULL,NULL,'','','Followup','',NULL,NULL),(3690,3433,'Email','High','2015-01-05 17:48:27','nitisha70701','ch-29 & 30','JNPT export ',NULL,NULL,'','23500','Close Successfully','',859,NULL),(3691,3434,'Email','High','2015-01-05 17:56:01','nitisha70701','12119032','Ahmedabad ICD , JNPT and Mundra',NULL,NULL,'','','Followup','',NULL,NULL),(3692,3435,'Email','High','2015-01-05 18:01:55','nitisha70701','84553000','India import',NULL,NULL,'','','Not Intrested','Competitor Interfearence\r\n ',NULL,NULL),(3693,3436,'Email','High','2015-01-05 18:12:16','nitisha70701','tea , coffee & rubber ','India import and export ',NULL,NULL,'','','Followup','',NULL,NULL),(3694,3437,'Email','High','2015-01-05 18:14:24','pooja','machine exp.','india export',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3695,3438,'Email','High','2015-01-05 18:16:25','pooja','not specified','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3696,3439,'Email','High','2015-01-05 18:18:40','pooja','peanut exp.','india export',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3697,3440,'Email','High','2015-01-06 11:48:29','anuj09','Kerosene Stove Pump','India Export data',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3698,3441,'Email','High','2015-01-06 12:00:00','anuj09','Not specified any requirement','',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3699,3442,'Email','High','2015-01-06 12:08:07','anuj09','Not specified any requirement','',NULL,NULL,'','','Not Intrested','Concern Person is not Available',NULL,NULL),(3700,3443,'Email','High','2015-01-06 12:09:50','bhawna','Automobile TURBO CORE','india import',NULL,NULL,'','','Followup','',NULL,NULL),(3701,422,'Email','High','2015-01-06 13:22:59','priyanka','29309020 (Sodium Iso propyl Xanthate) ','China Export',NULL,NULL,'','6000','Close Successfully','',615,NULL),(3702,2184,'Email','High','2015-01-06 14:35:59','barkha','1101','Kolkata Sea Export',NULL,NULL,'','3000','Close Successfully','',616,NULL),(3703,3444,'Email','High','2015-01-06 14:39:56','anuj09','Chapter 72 and 76','JNPT Import Both Side',NULL,NULL,'',NULL,'Not Intrested','Not Required',617,NULL),(3704,3445,'Email','High','2015-01-06 14:55:16','bhawna','Atta, Maida, Sooji, Bran Wheat Germ. ','INDIA EXPORT',NULL,NULL,'','2400','Close Successfully','',654,NULL),(3705,1784,'Email','High','2015-01-06 15:47:12','nitisha70701','Ch-48','JNPT import SP ','2014-12-01','2014-12-31','2000','2000','Close Successfully','',618,NULL),(3706,3226,'Email','High','2015-01-06 16:22:07','nitisha70701','53061090','JNPT import SP',NULL,NULL,'1000',NULL,'Not Intrested','Not Required',619,NULL),(3707,3226,'Email','High','2015-01-06 16:23:17','nitisha70701','53061090','JNPT import SP',NULL,NULL,'','1000','Close Successfully','',620,NULL),(3708,3292,'Email','High','2015-01-06 16:28:17','ankur','HS Code: 44034910 ','Vietnam Import ','2014-03-01','2014-08-31','USD 45 Per Month','16740','Close Successfully','',621,NULL),(3709,196,'Email','High','2015-01-06 16:28:50','nitisha70701','Ch-40','Nhava Sheva Import ',NULL,NULL,'','1000','Close Successfully','',622,NULL),(3710,196,'Email','High','2015-01-06 16:33:24','nitisha70701','ch-40','Nhava Sheva Import SP',NULL,NULL,'2000',NULL,'Not Intrested','Not Required',623,NULL),(3711,2526,'Email','High','2015-01-06 16:48:38','nitisha70701','ch-72','JNPT import SP',NULL,NULL,'1500','1500','Close Successfully','',624,NULL),(3712,2841,'Self Generated','High','2015-01-06 17:03:31','pooja','ch-51','JNPT IMPORT ','2014-12-01','2014-12-31','1700',NULL,'Close Successfully','',625,NULL),(3713,184,'Email','High','2015-01-06 17:18:52','ankur','HS Code 38021000','Indonesia Import & Export','2014-10-01','2014-10-31','USD 100 Per Month','200','Close Successfully','',626,NULL),(3714,3226,'Email','High','2015-01-06 18:09:58','nitisha70701','55101110','JNPT import SP ','2014-06-01','2014-06-30','1000','1000','Close Successfully','',627,NULL),(3715,3446,'Email','Medium','2015-01-06 18:16:50','nitisha70701','wood','JNPT Import',NULL,NULL,'','','Followup','',NULL,NULL),(3716,3448,'Email','Medium','2015-01-06 18:21:08','nitisha70701','3204','usa,Canada,UK,brazil,Indonesia,argentina and other latin American countries import',NULL,NULL,'','','Followup','',NULL,NULL),(3717,2965,'Email','High','2015-01-07 11:01:58','nitisha70701','87089900 & 84314990','Nhava Sheva and India import',NULL,NULL,'','2000','Close Successfully','',628,NULL),(3718,1592,'Email','High','2015-01-07 12:16:39','bhawna','71042000','india import',NULL,NULL,'','','Followup','',NULL,NULL),(3719,3449,'Email','High','2015-01-07 12:43:13','anuj09','Waste Paper','Brazil Export',NULL,NULL,'','','Not Intrested','Company Drop the Project for a While',NULL,NULL),(3720,2841,'Email','High','2015-01-07 12:43:19','pooja','ch-51','JNPT IMP. both side','2014-12-01','2014-12-31','','1700','Close Successfully','',629,NULL),(3721,3450,'Email','High','2015-01-07 13:12:49','pooja','63049280','india export',NULL,NULL,'','2500','Close Successfully','',630,NULL),(3722,2184,'Email','High','2015-01-07 13:22:43','barkha','1101','Mundra Export',NULL,NULL,'1000','3000','Close Successfully','',631,NULL),(3723,3451,'Email','High','2015-01-07 14:37:09','anuj09','Import','India, Argenitna and Vietnam',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3724,238,'Email','High','2015-01-07 15:12:28','pooja','hs code 3402 ','JNPT EXPORT SP','2014-12-01','2014-12-31','','1250','Close Successfully','',632,NULL),(3725,2515,'Email','High','2015-01-07 15:13:02','barkha','3808','JNPT Export SP',NULL,NULL,'','2000','Close Successfully','',633,NULL),(3726,3452,'Email','High','2015-01-07 15:58:11','pooja','94036000 , 94032090 , 94035090 ','Mundra Export',NULL,NULL,'',NULL,'Not Intrested','Not Required',634,NULL),(3727,3452,'Self Generated','High','2015-01-07 16:01:34','pooja','94036000 , 94032090 ','Mundra Export','2014-11-01','2014-11-30','','1350','Close Successfully','',635,NULL),(3728,184,'Email','High','2015-01-07 16:23:23','ankur','HS Code 38021000','Vietnam Export Data','2014-11-01','2015-11-30','USD 80','80','Close Successfully','',637,NULL),(3729,201,'Email','High','2015-01-07 16:51:37','nitisha70701','ch-29','JNPT export ',NULL,NULL,'5000','4500','Close Successfully','',638,NULL),(3730,677,'Email','High','2015-01-07 17:47:03','nitisha70701','39206290','JNPT export ','2014-11-01','2014-12-31','3000','3000','Close Successfully','',639,NULL),(3731,3453,'Email','High','2015-01-07 17:51:35','nitisha70701','40151900 & 40151100','Brazil Import',NULL,NULL,'','','Followup','',NULL,NULL),(3732,3454,'Email','High','2015-01-07 17:54:02','nitisha70701','82013000','China export & south african countries import',NULL,NULL,'','','Followup','',NULL,NULL),(3733,3455,'Email','High','2015-01-07 18:14:20','priyanka','Ch 9','Export report',NULL,NULL,'','1200','Close Successfully','Not Required',642,NULL),(3734,3456,'Email','High','2015-01-07 18:16:17','priyanka','Not Specified','Export report',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3735,3457,'Email','High','2015-01-07 18:19:30','priyanka','Not Specified','Indonesia Export',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3736,356,'Email','High','2015-01-07 18:27:46','priyanka','5701','Export report',NULL,NULL,'',NULL,'Not Intrested','Not Required',640,NULL),(3737,356,'Email','High','2015-01-08 11:12:26','priyanka','5701','Export report',NULL,NULL,'','20000','Close Successfully','',644,NULL),(3738,3458,'Email','High','2015-01-08 11:38:28','bhawna','Chapter-7','jnpt export',NULL,NULL,'',NULL,'Invoice Sent','',651,NULL),(3739,3459,'Self Generated','High','2015-01-08 11:58:41','anuj09','Not specified any requirement','India Export And Import',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL),(3740,2184,'Email','High','2015-01-08 12:25:40','barkha','1006 & 1101','JNPT Export SP',NULL,NULL,'','2000','Close Successfully','',641,NULL),(3741,3460,'Email','High','2015-01-08 13:18:59','anuj09','Garments','India Export data',NULL,NULL,'','','Not Intrested','Not Required',NULL,NULL); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment