-- ============================================ -- Import Tally Ledgers into `customers` table -- Total: 872 customers/vendors -- Generated: 2026-03-27 10:54:28 -- ============================================ SET NAMES utf8mb4; -- ============================================ -- Part 1: Customers -- ============================================ INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (1, '3 Ideal Technology LLP( CASH)', '8356887464', '27AABFZ4932D1Z7', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (2, '9 Gold Enterprise', '9930032003', '27AAOPT7558G1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (3, 'A Ahmedally & Co P Ltd', '8801022538', '36AABCA4938P1Z8', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (4, 'Aalap Industries', '9824372339', '24AJVPB7670B1Z8', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (5, 'Aassto Enterprises', '9893349020', '09IZBPS7079K1ZD', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (6, 'Abbasbhai & Sons', '2223421739', '27AAAFA2798R1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (7, 'Abbas Industrial Tools', '9035829071', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (8, 'Abc', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (9, 'A B Corporation (Parel)', '8211080129', '27AAMFA4306K1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (10, 'ACE Diamond Tools', '9821174934', '27ALLPM5777A1ZV', 'Maharashtra', 'both', 'Mishra', 'bill', 'credit', 0, NOW(), NOW()), (11, 'Acme Engineering', '9979997777', '24ABFFA1280J1ZO', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (12, 'Adaro Dental Laboratory', '7045943807', '27AAQFA7738M1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (13, 'Adarsh Corporation', '9819836140', '27AGLPJ9083H1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (14, 'Advance Engineering Enterprises', '9052569221', '36ACEPH2132G1Z4', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (15, 'Agarwal and Company', '9829966799', '08ADZPA2164K1Z6', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (16, 'Agkem Impex Private Limited ( Jaipur )', '', '08AAECA6828P1Z3', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (17, 'Agkem Impex Pvt. Ltd', '', '09AAECA6828P1Z1', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (18, 'Agkem Impex Pvt Ltd ( Delhi)', '', '07AAECA6828P1Z5', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (19, 'A H Tools Centre', '9820786447', '27AZVPS4307G1ZV', 'Maharashtra', 'both', 'Husain', 'bill', 'credit', 0, NOW(), NOW()), (20, 'Ahuja Magnet & Electronic', '9810005816', '07AADPA4788L1ZG', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (21, 'Ajanta Marketing', '', '24AAFPZ7637M1ZX', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (22, 'Ajanta Tools', '8007867253', '27AFRPB1572N1Z1', 'Maharashtra', 'both', 'Shk Mukaram Bhai', 'bill', 'credit', 0, NOW(), NOW()), (23, 'Ajay Needle Files', '8144085511', '33ARHPV7025L1ZD', 'Tamil Nadu', 'both', 'B Vadilal', 'bill', 'credit', 0, NOW(), NOW()), (24, 'Akar Arts', '8369834855', '27AEIPD9649C1ZF', 'Maharashtra', 'both', 'Bharat Bhai', 'bill', 'credit', 0, NOW(), NOW()), (25, 'Akash diamond tools', '9821057039', '27AAPPS9039N1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (26, 'Akash Trading Co.', '', '27AAOPS5927Q1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (27, 'Akbar Travels of India Pvt Ltd', '', '27AADCA2140D1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (28, 'Akber Parcel Service', '', '36AMDPK5976E3ZT', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (29, 'Akshay Tools Centre', '9004075613', '27ABAPS2559M1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (30, 'A K & Sons', '9312279525', '07AAPPM3761R1ZT', 'Delhi', 'both', 'Rashid', 'bill', 'credit', 0, NOW(), NOW()), (31, 'Ak Tools', '', '27CSLPK8184L1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (32, 'Alamdaar Tools Corner', '9028002152', '27AAIFA8340H1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (33, 'Al Azhar Enterprise', '9819976852', '27AAQPB4872M1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (34, 'Alif Stationary Mart', '9820488921', '27ARPPP7487E1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (35, 'Alihusain Akbarali Rangwala', '9825452819', '24ABOPR9276J1ZT', 'Gujarat', 'both', 'Muntazir Rangwala', 'bill', 'credit', 0, NOW(), NOW()), (36, 'All Bound Global Freight', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (37, 'Alliance Corporation', '', '27ACWPL4322J1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (38, 'Alliance Trading Corporation', '2223421645', '27AABPT8144P1ZZ', 'Maharashtra', 'both', 'Narendra / Rahul', 'bill', 'credit', 0, NOW(), NOW()), (39, 'Allied Enterprises', '2223428949', '27AABFA0318C1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (40, 'All India Tools Centre', '9820096834', '27AAAFA2471K1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (41, 'Alplas Polymers', '', '27AEDPN6215R1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (42, 'Ambe Jewels', '9867417325', '27AHYPM5663L1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (43, 'Amcol Engineering Stores', '9819593002', '27AABPP5995N1ZU', 'Maharashtra', 'both', 'Mihir Parikh', 'bill', 'credit', 0, NOW(), NOW()), (44, 'Amish Enterprise', '9022507339', '27AMUPS4444E1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (45, 'Amit Industries', '', '24CUWPP2359B1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (46, 'Amit tools center', '9890070501', '27ABMPS1423J1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (47, 'Amtrade', '9920179490', '27AAJFA7407L1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (48, 'Amu Industries', '9830125760', '19AAEFA5228J1ZE', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (49, 'Andhra Hardware Mart', '9989084531', '36AAHFA0461E1ZX', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (50, 'Angira Diamond & Jewellery Pvt Ltd', '9342015661', '29AAHCM4010A1Z1', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (51, 'Aniket Traders ( Jodhpur)', '8890691855', '08CDOPS1044R1ZQ', 'Rajasthan', 'both', 'Ram Gopal Soni', 'bill', 'credit', 0, NOW(), NOW()), (52, 'Anjna Industries', '9924488096', '24AAYPV6344G1Z1', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (53, 'Ankist Jewellery Tools & Mc (Coimbatore)', '6383049960', '33AAYFA6008J1Z8', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (54, 'Ankitst Exim Inc', '2242724050', '27AAJFA6712C1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (55, 'Anksist Jewellery & Machine', '9610447325', '', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (56, 'Anmol Trading Co.', '', '27AAWFA0473F1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (57, 'Anon Products', '7575808569', '24AAUFA2424N1Z7', 'Gujarat', 'both', 'VARSHA', 'bill', 'credit', 0, NOW(), NOW()), (58, 'A One Traders', '', '24ADOPS4416K1Z6', 'Gujarat', 'both', 'Bharat Bhai', 'bill', 'credit', 0, NOW(), NOW()), (59, 'A-Plus Jewel Tools', '9867218949', '27ABPFA8213K1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (60, 'Aqmar Trading Corp.', '9845305951', '29AAPPB0207R1ZF', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (61, 'Aradhika General Store', '9732093476', '09CFYPS3727R1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (62, 'ARC Distributors India Pvt Ltd', '2228603349', '27AAGCA9220M1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (63, 'Arham Chains', '9167170055', '27ACJPJ1261F2ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (64, 'Arham Enterprise', '9322407806', '27AHGPR1492N1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (65, 'Arihant Bearing Centre', '9819593020', '27AHKPD0521G1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (66, 'Arihant Enterprise', '9820569739', '27AMGPS5254E1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (67, 'Arihant International', '', '27AAAFA6537G1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (68, 'Arihant Sai Traders ( Jaipur )', '9351792373', '08AAIPR1561R1ZZ', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (69, 'ARNTZ Techsaw Private Limited', '7314051579', '23AALCA4818L1ZI', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (70, 'Arrow Speciality Co.', '24070070', '27AABPG4673Q1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (71, 'A R Tools Collection', '9821107765', '27BAQPS0727K1Z5', 'Maharashtra', 'both', 'Achintu', 'bill', 'credit', 0, NOW(), NOW()), (72, 'Arun Enterprise', '', '27ASIPD8374N1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (73, 'Arvind Art Jewellers', '9823040000', '27AANFM5747R1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (74, 'Arvind Kumar ( URD)', '8449942925', '', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (75, 'A S Enterprises', '9820341872', '27AIHPN4146P1ZO', 'Maharashtra', 'both', 'Sandeep Nalawade', 'bill', 'credit', 0, NOW(), NOW()), (76, 'Asgarally Yusufally', '9820786447', '27AAAFA3616J1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (77, 'Ashok Press and Machine Tools', '', '24BCAPS7322E1ZV', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (78, 'Ashwin Enterprises', '', '27AABPB7987N1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (79, 'Asian Industries', '', '', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (80, 'A to Z Hydraulics & Pneumatics', '8347062853', '24ABBFA0583A2Z6', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (81, 'A to Z Magnetic Inspection Assebmbling and Equipments', '9921185348', '27AOCPM0802J1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (82, 'A to Z Magnets Mfg Co.', '', '07AHXPB4085A1ZE', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (83, 'Auto Tools', '9930044421', '27ABIPV8060G1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (84, 'Aven Tools Centre', '', '27AAAFA0427H1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (85, 'Avenue Marketing', '', '27BHAPS2299M1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (86, 'Avinash Cargo Pvt Ltd', '8805797979', '27AAFCA7488L1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (87, 'Avon Time', '', '27AAEPG6153A1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (88, 'Azad Stores', '', '27ADTPG8608A1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (89, 'Azarro Traders', '', '27ADBPV1381M1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (90, 'Aziz & Sons Button Wala', '9820075961', '07ABDFA2564K1ZF', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (91, 'Badshah Traders', '9225602289', '27AWEPB3934E1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (92, 'B. A Enterprise (Cash)', '9820262664', '27APTPK7744R1ZN', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (93, 'Balaji Enterprise', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (94, 'Balaji Industries ( Rajkot )', '9227253843', '24AFBPJ0348E1Z2', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (95, 'Balaji Traders', '9820046772', '27AAIPU0869M1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (96, 'Barun Sanatan Hait', '9819020841', '27ABWPH0067P1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (97, 'B C Oswal & Co.', '9371011550', '27AACPO4791L1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (98, 'B.D.Jogani and Co', '', '27ACHPJ6723E1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (99, 'Beauty Founder', '', '', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (100, 'Best Hardware Mart', '8838172793', '33AOAPK3181N1ZW', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (101, 'Best Trading Company', '9841032098', '33BEBPS0747E1ZS', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (102, 'Better Services Privae Limited', '9930597335', '27AAGCB9410L1ZG', 'Maharashtra', 'both', ' Primary Mobile No.', 'bill', 'credit', 0, NOW(), NOW()), (103, 'BF Jewellery Tools', '9821238607', '27AETPG6522L1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (104, 'Bhagat and Company', '9820584010', '27AAEFB7702L1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (105, 'Bhagwati Machine Tools', '9825679880', '24AGBPS8298K1ZP', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (106, 'Bhandare Bag House', '9022530026', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (107, 'Bharat Bolts & Engineer Co.', '', '27ACEPS9358R1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (108, 'Bhoomi Corporation', '9819838994', '27ABDPS4741E1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (109, 'Big Foot Retail', '', '29AAECB7131Q1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (110, 'Bikaner Jwellers', '9549831333', '18AAUFB7714L1ZS', 'Assam', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (111, 'Bizcoin Fintech Labs (P) Ltd', '', '07AAICB5550B1Z0', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (112, 'B.L.D Enterprises', '9845030998', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (113, 'Blue Bird Impex', '9820371210', '27AFEPR3336P1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (114, 'Blue Teraa Company', '', '27AAVFB1772B1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (115, 'B M Trading Co', '9837114525', '27AIYPJ5018K1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (116, 'BNL EXPRESS CARGO PRIVATE LIMITED', '', '27AAICB3875D1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (117, 'Bolzen and Mutter Ind Pvt Ltd', '', '27AAHCB4724C1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (118, 'BOMBAY JALANDHAR TRANSPORT COMPANY', '', '03AAKFB0481A1Z6', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (119, 'Bombay Tools Center ( Vapi)', '8460882030', '26AAGFB5794C1ZG', 'Dadra & Nagar Haveli and Daman & Diu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (120, 'Bombay Tools Centre ( Jodhpur )', '9782372360', '08AFPPB2296D1ZH', 'Rajasthan', 'both', 'Anil', 'bill', 'credit', 0, NOW(), NOW()), (121, 'B P Enterprises', '8655193909', '27AFKPM7354N1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (122, 'Bright Buff Manufacture Co', '9324316556', '27AMTPS1790A1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (123, 'B S Trading Co', '9769481949', '27BAOPS5002H1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (124, 'Burhani Alloys and Machinery', '9892698899', '27ANSPB0599A1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (125, 'Burhani Tools & Hardware', '9825900822', '24AEIPT1031L1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (126, 'Burhani Traders', '23413488', '27AARFB4529J1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (127, 'Burhani Traders ( Thane )', '8097136153', '27BDYPB7113B1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (128, 'Butma Enterprise', '', '27AADPS4174Q1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (129, 'Cambridge Time Spare', '', '27AAAFC0825B1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (130, 'Carigar Power Tools Private Limited', '7989878828', '36AAJCC4340B1Z3', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (131, 'Cash Sales', '9819684355', '', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (132, 'Cebon Apparel Pvt Ltd', '', '27AAACC2088B1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (133, 'Central Dental Co', '9820372514', '27AAAFC1177A1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (134, 'Chaman Tools Store', '9814138216', '03AADFC4253C1Z6', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (135, 'Chandra & Company ( Trichi )', '9944400700', '33AAMPS6885M1ZQ', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (136, 'Chandra Traders ( Ahmedabad )', '9428593600', '24BGKPS5550A1ZJ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (137, 'Chankya International Pvt Ltd', '9136188105', '27AAACC4592Q1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (138, 'C.M.Enterprise', '9323016100', '27AEIPM3649B1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (139, 'Comrade Appliances Pvt. Ltd.', '9833012144', '27AAGCC9056P1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (140, 'Continental Commercial Co.', '8828133808', '27AAQFC3658N1ZP', 'Maharashtra', 'both', 'Yusuf', 'bill', 'credit', 0, NOW(), NOW()), (141, 'CONTINENTAL WAREHOUSING CORPORATION NS LIMITED', '', '27AAACC5849C1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (142, 'Core Tech Engg.', '9370070621', '27AGOPC3253D1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (143, 'Cosmos Abrasives', '9820850106', '27AMYPS1101J1ZP', 'Maharashtra', 'both', 'Kaushik Shah', 'bill', 'credit', 0, NOW(), NOW()), (144, 'Cosmos Jewellery Tools', '', '27AACPK2092C1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (145, 'C R Gandhi & Co', '9820103412', '27AAAFC1212G1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (146, 'Crystal Polishing Meterial Industries', '9810447208', '09AOXPK6131R1ZW', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (147, 'Crystal Polyshing Material Industries ( Closed)', '9810447208', '09ADNPK9781A1Z6', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (148, 'Customer', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (149, 'Custom Logics', '9930333885', '27AACCC4488M1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (150, 'Darshan Jewel Tools Pvt. Ltd.', '', '27AACCD1551G1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (151, 'Darshan Tools (Surat)', '7405109335', '24EXCPS4173K1Z3', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (152, 'Darsh Designs', '9820523482', '27ADJPL0039J1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (153, 'Darshini Enterprises', '9820316366', '27BFAPS5479D1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (154, 'Dass Jewellery Tools', '8802488850', '07DSNPD4795P1ZS', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (155, 'Dawat E Hadiyah', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (156, 'Debit Note Agst Form H', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (157, 'Debkumar Tools Centre', '9167821232', '27CCNPB3424N1ZE', 'Maharashtra', 'both', 'Devu', 'bill', 'credit', 0, NOW(), NOW()), (158, 'Deburring India Private Limited', '9922401408', '27AAICD1657K1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (159, 'Decent Lorry Service', '', '36AABFD8065B1ZQ', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (160, 'Delhivery LTD', '', '06AAPCS9575E1ZR', 'Haryana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (161, 'Deluxe Electronics and Photos', '', '27AAAPF0699J1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (162, 'Delux Roadways', '', '07AAAFD0873A1Z2', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (163, 'Deogiri College', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (164, 'Deora Agency', '23448110', '27AFFPD8301R1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (165, 'Deora and Company', '222346138', '27ADPPD4906N1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (166, 'Devansh Enterprises', '8976262897', '27AIOPC1546K1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (167, 'Dev Enterprise', '9898142738', '24AOLPS0603Q1ZL', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (168, 'Dev Funner', '9752609102', '23ECVPR3915Q1ZM', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (169, 'Dg Digital Dental Lab', '', '27AFYPJ8647P1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (170, 'Dhana Sree Engg. Works', '7893539223', '36BRIPR1801G1ZW', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (171, 'Dharm Industries', '9426234471', '24AQNPP0016E1Z8', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (172, 'Dhirajlal And Co', '9320079632', '27BHEPS0069M1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (173, 'Dhruvil Enterprise', '9969850822', '27APZPS3565C1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (174, 'D.H.Shah', '9823033522', '27AAAFD8878K1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (175, 'Dhwani Jewels ( Kutub Sami)', '', '27AABPP8624N1Z6', 'Maharashtra', 'both', 'Nikhil Sureshbhai Parekh', 'bill', 'credit', 0, NOW(), NOW()), (176, 'Diamond Pvs Engineering', '9004948041', '27AUJPS4077L1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (177, 'Dilip Enterprises', '9820820918', '27AAEPD4357R1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (178, 'Dina Tools Corporation', '9821734331', '27AAKPS9079F1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (179, 'Doshi Enterprises', '9819900380', '27AABFD9794R1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (180, 'Drishti Enterprises', '9897086305', '09EYZPK2731K1ZM', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (181, 'D. R Sons', '9837639057', '09BFVPK6292M1ZC', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (182, 'Dry- Air Technologies', '9943691024', '33AOYPB0427L1ZU', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (183, 'Duroflex Private Limited', '', '27AABCD8855E1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (184, 'Dwarkesh Enterprises', '2223441344', '27AAAFD5544L1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (185, 'Dymak Acryplast Industries', '9820244240', '27AEQPM4913C1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (186, 'Dynamic Tools Pvt Ltd', '9075636585', '36AABCD6280D1ZV', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (187, 'Dynosour International', '9999555888', '09AKXPA5123H1Z1', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (188, 'Eagle Exports', '7016596962', '24AACFE5131A1ZA', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (189, 'Eagle Industries', '7016596962', '24AABFE8119R1Z2', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (190, 'Eagle Tools Centre', '7016596962', '24AACFE0587A1Z0', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (191, 'Ekta Dies and Machince', '9824293195', '24AIFPR1707A1ZU', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (192, 'Electrospark Engineers', '9422009064', '27AADPH2369A1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (193, 'Electro Steel Power Transmissions Co.', '9325594938', '27AABFE9161D1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (194, 'Empire Time Industries', '9891155989', '07AANPP6056G1ZD', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (195, 'Encore Hardware Mart', '9601878653', '36BHLPP1906K3ZZ', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (196, 'Engineering Tools & Equipments', '7892882508', '29AAAFE4000E1Z4', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (197, 'Esskay Traders Cash', '', '27ADFPS2861K1Z4', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (198, 'Euro Diamonds Pvt. Ltd.', '9819128461', '27AABCE1722F1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 1, NOW(), NOW()), (199, 'Evergreen Paper Box', '9870864800', '27AMTPM4139P1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (200, 'Ezzy Tools Centre', '9600192424', '33DJZPS2606K1ZK', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (201, 'Ezzy Tools Corporation', '9819684355', '27AAGFE0725J1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (202, 'Famous Technologies', '9820310679', '27AKWPK8047P1Z0', 'Maharashtra', 'both', 'Abdulkader Saifuddin Kagalwala', 'bill', 'credit', 0, NOW(), NOW()), (203, 'F.H.Khambati', '', '27AADPK3585H1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (204, 'FIRSTGEAR AUTO TECHNOLOGIES PRIVATE LIMITED', '', '27AAECF8187G1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (205, 'Flame Proof Equipment P Ltd', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (206, 'Flamingo', '', '27ADUPS7865G1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (207, 'Florida Engineering Company', '9820622425', '27AABFF8184F1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (208, 'Friends Eng Ind Priv Ltd', '9820101259', '27AABCF5457A1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (209, 'Ganapathy Enterprise', '1948720077', '33AABFG1780E1ZV', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (210, 'Gandiva Tools India LLP', '9999950826', '07ABAFG1113H1Z0', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (211, 'Gastronics', '9123434724', '27AGCPK5604J1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (212, 'Gauri Tools Centre', '9352920213', '08BLNPM7394C1ZN', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (213, 'Gautam Impex', '9323947784', '27ABAPS9191D1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (214, 'Gautam Labhdi Enterprises', '9320451454', '27AAGPD1339M1ZP', 'Maharashtra', 'both', 'Urmish Doshi', 'bill', 'credit', 0, NOW(), NOW()), (215, 'Gayatri Industries', '', '24AARPN6310R1Z3', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (216, 'G Dass Enterprises', '', '07AADFG5019Q1Z3', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (217, 'Gemax Industries', '', '27APTPS0922D1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (218, 'General Tools and Wheels', '9443427152', '33AATFG2537P1ZT', 'Tamil Nadu', 'both', 'Hakim / Mustafa', 'bill', 'credit', 0, NOW(), NOW()), (219, 'General Tools Centre', '', '33AAEFG5745J1ZC', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (220, 'Gidhandas & Sons', '', '27AAAFG2766P1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (221, 'Gifts 2 Gifts', '7262863962', '27ABIPR5122K1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (222, 'Gigs Fintech Private Limited', '9870594107', '27AAHCG5165E1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (223, 'Giriraj Agencies', '23401650', '27AACPS5534R1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (224, 'Giriraj Trading Corporation', '', '27AABPS8321H1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (225, 'Global Solution', '9892560635', '27CBOPS2386E1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (226, 'Global Threads', '', '27AQQPB0284R1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (227, 'Global Tools & Metals', '9840220622', '33AGNPR1175J1Z3', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (228, 'Glowel', '9810100523', '07ACJPN4392F1ZE', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (229, 'Gogna Twezer Works', '', '03AASFG4751E1ZG', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (230, 'Golden Precision Products', '9503528925', '27AACCG6543R1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (231, 'Goldfins Enterprises', '9830375195', '19AIHPA9031C1ZN', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (232, 'Gold Side Production', '9428035458', '24AAPFG1880P1ZS', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (233, 'GoMechanic', '', '06ABGCS6923C1ZG', 'Haryana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (234, 'Goodluck Enterprises', '9323503485', '27BBQPK2600C1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (235, 'Goodluck Jewellery Tools and Boxes', '9737969093', '24HDAPS0949J1Z9', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (236, 'Gorbhanbhai Nathabhai Ghataliya', '9904825288', '', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (237, 'Government Polytechnic Kolhapur', '9370637373', '27AAAGG0710N1ZK', 'Maharashtra', 'both', 'The Principal', 'bill', 'credit', 0, NOW(), NOW()), (238, 'Green Star SA Pvt Ltd', '9781987924', '03AAECG4904C1Z9', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (239, 'Greston India Magnets', '', '27AIVPD9608E1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (240, 'Grow India Crafts', '9997512464', '09AQJPA0520C1ZM', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (241, 'Gujarat Goods Service', '', '24AAFFG8339R1ZQ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (242, 'Gulab\'s', '9829615199', '08ADJPF5075C1ZQ', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (243, 'Gupta Enterprise', '9820935343', '27ANGPG9807N1ZG', 'Maharashtra', 'both', 'Rakesh', 'bill', 'credit', 0, NOW(), NOW()), (244, 'Gurukripa Tools', '9610688825', '08AQIPB0430H1ZD', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (245, 'GVS and Company', '9426216435', '24AHGPS8329H1Z1', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (246, 'H.A Hardware & Power Tools', '9972188851', '29AQMPA5016A1ZC', 'Karnataka', 'both', 'Mohammed Bhai', 'bill', 'credit', 0, NOW(), NOW()), (247, 'Hakeem CLOSED', '9884369812', '33ABRPD6918J1ZE', 'Tamil Nadu', 'both', 'Shabbir', 'bill', 'credit', 0, NOW(), NOW()), (248, 'HANS TRAVELS I PRIVATE LIMITED', '', '23AACCH6478A1ZV', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (249, 'Hardware and Tools Centre', '9011911044', '27AADFH0452L1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (250, 'Hari Crystal Shine Pvt Ltd', '', '09AADCH0641J1ZO', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (251, 'Hari Om Enterpises ( Mumbai )', '9324764294', '27ACKPS5274L1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (252, 'Hariom Enterprises', '9867245130', '27AOPPC4042R1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (253, 'Hari Om Enterprises ( Jaipur )', '9887853052', '08ALFPA4794H1Z0', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (254, 'Harsh Enterprise', '9426216435', '24AHGPS8338E1Z6', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (255, 'Harsiddhi Enterprise', '1932399889', '27ATMPS0604D1ZU', 'Maharashtra', 'both', 'Parag Shah', 'bill', 'credit', 0, NOW(), NOW()), (256, 'Hatim Enterprise', '9029266652', '27AHOPD7937N1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (257, 'Hatim Tools', '9892955843', '27AZFPM9518B1ZC', 'Maharashtra', 'both', 'Shabbir Bhai Bangali', 'bill', 'credit', 0, NOW(), NOW()), (258, 'H Doshi Traders', '9987291915', '27AADPD0657K1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (259, 'Heena Enterprises (Cash)', '9324544613', '27AANPS9000P1ZZ', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (260, 'Hemal Enterprise ( Cash )', '9821300579', '27ACEPS2664Q1ZU', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (261, 'Hemant Brothers', '9322245587', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (262, 'Hemco Tools Corporation (India)', '9819267819', '27AAAFH1138G1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (263, 'Hemnav Ventures Private Limited', '9699976833', '27AAACH6616E1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (264, 'Hetvi International', '9324611864', '27AACPS2445R1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (265, 'Hindustan Magnets & Electronic Co.', '', '27AADFH5130R1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (266, 'Hindustan Minerals', '', '', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (267, 'Hiral Trading Co', '9892406323', '27AADPS6025Q1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (268, 'Hi Tech Industries', '9820016415', '27AABPB1627P1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (269, 'Hi Tech Precision Tools', '9602744282', '08ABLPD5048F1ZR', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (270, 'H K Enterprise', '8104969099', '27BOKPS9447G1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (271, 'H M Enterprises', '9820371210', '27GFQPR8453R1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (272, 'H M Enterprises Closed', '9820371210', '27AABPR8541G1ZJ', 'Maharashtra', 'both', 'Hakim / Mustafa', 'bill', 'credit', 0, NOW(), NOW()), (273, 'Hobby Craft', '9167600340', '27AXJPM8849H1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (274, 'Honesty Engineering Company', '9821365456', '27AAEFH7753B1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (275, 'Horolap International', '9811856100', '07ABFPB2227C1ZG', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (276, 'Hutaib Engineering Co', '9920227415', '27AOOPM3626E1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (277, 'Hutaib Jewellery Tools', '9769947201', '27BVAPB8366E1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (278, 'Ideal Tools Center', '8879172322', '27AGTPD5157C1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (279, 'Imadi Fastech', '8197321718', '29AERPA3084K1Z3', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (280, 'Imtex Industries', '9610447325', '08ALJPK0896N2ZD', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (281, 'INDCO Tools', '9029031786', '27ADMPL5985E1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (282, 'India Bearing and Tools', '9820510235', '24AHUPB5004E1ZS', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (283, 'Indian Cab Corporation', '', '27AABFI0779F1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (284, 'Industrial and Construction Equipment', '9820952651', '27DGWPK6358G1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (285, 'Industrial Supplies ( Kalyan)', '', '27BHMPS6265H1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (286, 'Industrial Tools Supply Co(Bang)', '9880016261', '29AABFI0898P1ZM', 'Karnataka', 'both', 'Mufaddal', 'bill', 'credit', 0, NOW(), NOW()), (287, 'International Traders (Drs)', '9076046526', '27AAAFI0671D1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (288, 'International Watch Trading Co.', '9820290177', '27AAAFI1288C1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (289, 'Inventa Tools and Technologies', '', '24CWCPB8076R1Z0', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (290, 'Invision', '', '27ATLPP9649Q1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (291, 'Isanctuary Impex Pvt Ltd', '', '27AACCI4406K1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (292, 'Jai Ambe Enterprises', '9029710899', '27AKSPP8497N1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (293, 'Jai Ambe Gifts & Stationery', '9320482480', '27AGEPA6729Q1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (294, 'Jai Bhawani Electric & Hardware', '8452924387', '27FYQPS2547F1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (295, 'Jainam Enterprise', '9324778538', '27AAKPS3825K1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (296, 'Jain Enterprises', '9819350332', '27AGLPS7868M1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (297, 'Jain Trading Company', '9351255808', '08AGRPJ1122B1ZU', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (298, 'JAIPUR GOLDEN TRANSPORT CO. PVT. LTD.', '', '27AAACJ4124B1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (299, 'Jalaram Enterprises', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (300, 'Jalpa Jewellery Impex', '9909909166', '24ABGPA4331F1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (301, 'Janatha Gems Silver Jewellery', '9895124343', '32AADFJ9716B1ZQ', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (302, 'Janhavi Enterprises', '9370673872', '27BZEPK1621D1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (303, 'Jariwala Robotics Pvt.Ltd', '8369940932', '27AADCJ1715D1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (304, 'Jawahar Tools Centre', '', '27AAOFJ1981H1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (305, 'Jay Ambe Gold Steel Enterprise', '', '24AARFJ1097R1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (306, 'Jayantilal & Associates', '', '27AACFJ9009Q1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (307, 'Jayantilal & Company', '9831004080', '19AASFJ4550G1ZZ', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (308, 'Jay Industries', '', '', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (309, 'Jay Kay Engineering', '9820451251', '27AALPM3622R1Z3', 'Maharashtra', 'both', 'Jignesh', 'bill', 'credit', 0, NOW(), NOW()), (310, 'Jay Khodiyar Industries', '9879074051', '24AFVPM3761Q1ZJ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (311, 'Jaykumars Overseas', '9638500550', '24AVKPP5440L1Z8', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (312, 'Jay Shree Steel Corp.', '9324601400', '27AAOFJ7248P1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (313, 'J B Enterprise', '9821314294', '27AACPP3298D1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (314, 'J . B Traders', '9820047351', '27AGLPS5603G1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (315, 'JCEX Express (IND) Pvt Ltd', '', '07AADCJ5337K1ZD', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (316, 'Jewel Tech Equipments', '9087332277', '33BCRPA9476Q1ZP', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (317, 'Jewel Tools International', '', '27AAFHA9004B1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (318, 'Jewel Tools International (CRS)', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (319, 'Jignesh Enterprises', '9892560635', '27AOJPS0324L1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (320, 'Jinesh Enterprise', '7977151060', '27AHNPK4479R1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (321, 'Jipsy Metal Industries', '9824220550', '24AAOPP1213G1ZZ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (322, 'Jitendra Hardware Mart', '9820120243', '27AAIPS7704B1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (323, 'J K Bearing Husain', '9880647758', '', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (324, 'J.K.Engineering Diamond Works', '9869482514', '27AAAFJ1549H1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (325, 'J.K.Enterprises', '40023533', '27AGAPM5144R1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (326, 'J. K Enterprises ( Kandiwali)', '9820159045', '27AEUPD3899J1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (327, 'J. M. International', '9320123115', '27AFFPD3249A1Z0', 'Maharashtra', 'both', 'Manish', 'bill', 'credit', 0, NOW(), NOW()), (328, 'Jobby Engineers Pvt Ltd', '9893263875', '23AAACJ5497K1Z9', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (329, 'Johnson Chetna Jewellery tools', '8949588545', '08ABVPS9540D1Z1', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (330, 'Jolly Enterprise', '9819816307', '27ALGPM3471L1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (331, 'Jullandar Surgical Works', '9814062533', '03AASPM2601H1ZY', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (332, 'Jv Gift Basket', '', '27AKFPD2078N2ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (333, 'Kalash Star', '7738260685', '27AARFK3349R1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (334, 'Kalika Tools', '8800160244', '07AOLPJ6544B1Z1', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (335, 'Kalyan Jewellers India Ltd', '8591621019', '19AADCK6079K1ZY', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (336, 'Kamal Tools', '9391025437', '36AANPP8675R1ZC', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (337, 'Kamal Tools Centre', '9247712770', '36AEJPP6674A1ZC', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (338, 'Kamruddin Adamjee & Co.', '', '27AAAFK7525L1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (339, 'Karpagam Tools', '9894095917', '33AACFK3989L1ZW', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (340, 'Kartikeya Enterprises', '8450933955', '27APLPK2280E1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (341, 'Keval Industries', '9228140066', '24CBSPV4538F1Z5', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (342, 'Keval Trading Corporation', '9320001145', '27AABPJ0149C1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (343, 'Khambati Jewellery Tools', '9149714353', '27AANFK5644H1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (344, 'Khambati Tools Centre (DRS)', '9821150149', '27AACPK2094E1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (345, 'Khambati Tools Collection', '9967066884', '27AALFK1282H1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (346, 'Khambati Traders', '9821155034', '27ACWPK6333L1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (347, 'Khatri Packaging', '9300458887', '23AHMPK2598J1ZX', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (348, 'Khazana Jewellery Pvt Ltd.', '', '27AAACK2564Q1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (349, 'King Tools Centre LLP', '', '27AARFK6397H1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (350, 'Kinjal Enterprise', '', '24AAUFK5457D1Z3', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (351, 'Kinjal Enterprise ( Mumbai)', '9819599721', '27BIOPS1253C1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (352, 'Kohinoor Electrical and Hardware Stores', '9820389830', '27AVGPC1792A1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (353, 'K P Sales Corp', '9820268900', '27AACPS1384H1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (354, 'Kraftix Digital Private Limited', '', '19AAFCK5909A1ZO', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (355, 'Krish Enterprises (Cash)', '', '27AGSPM9859K1Z7', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (356, 'Krish International', '', '27AABPA0730G1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (357, 'Krishna Industries', '9328657594', '24AVHPT6190L1ZY', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (358, 'Kristeel Shinwa Ind LTD.', '9892230882', '26AAACK4226H1ZS', 'Dadra & Nagar Haveli and Daman & Diu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (359, 'K R K Jewellery Tools', '9994567487', '33AFZPR5202H1Z6', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (360, 'K S B International', '', '07AAMPB1995P1Z3', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (361, 'K S B Metalex Corporation', '9810067678', '07AGPPB4858A2ZI', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (362, 'K.Tools Centre', '9819913561', '27BEIPS8282R1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (363, 'Kuber Tools Center', '9963656607', '37BCWPR0011H1ZH', 'Andhra Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (364, 'Lagu Bandhu Motiwale Pvt Ltd', '9769453797', '27AAACL0079M1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (365, 'Lakhani Goldsmith Tools Machinery and Die', '9376670700', '24AAPPL0980R1ZZ', 'Gujarat', 'both', 'Imran Bhai', 'bill', 'credit', 0, NOW(), NOW()), (366, 'Lakhani Traders', '9376670700', '24ABDPL5834H1ZR', 'Gujarat', 'both', 'Imran Bhai', 'bill', 'credit', 0, NOW(), NOW()), (367, 'Laxmi Sales Services', '9821112508', '27AAIPT0929R1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (368, 'Laxmi Stores', '9007463317', '19ADRPB3177H1ZA', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (369, 'Laxmi Wooden Finish', '9426719329', '24AQCPS4975N1Z5', 'Gujarat', 'both', 'Ashwinbhai', 'bill', 'credit', 0, NOW(), NOW()), (370, 'Leena Corporation', '9604447395', '27AUNPP0395A1ZK', 'Maharashtra', 'both', 'Ramesh Pawar', 'bill', 'credit', 0, NOW(), NOW()), (371, 'Lite Kiran', '', '27AAAFL1366N1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (372, 'Lithium Leather Enterprise', '9051569588', '19ATDPD8854D1ZN', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (373, 'Lookman and Sons', '9552520914', '27AABFL0317Q1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (374, 'Lucky Hardware', '9820133152', '27AABFL6063H1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (375, 'Lucky Keychain and Gifts Novelty', '', '27AKSPG0407H1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (376, 'Lucky Machine Tools', '9820133152', '27AACFL2179F1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (377, 'Lucky Surgical Works ( Crs)', '9530903430', '03AJXPK9169L1ZA', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (378, 'Lucky Trading Co.', '9463687601', '03ASRPK0002B1ZL', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (379, 'Luxury Jewelery ( India ) Pvt. Ltd.', '8850089962', '27AAGCI6554C1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (380, 'Madhav Tools Corp', '9825679880', '24BBLPS2585K1Z2', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (381, 'Madhu Tools Centre', '9994454947', '33AVHPB6789P1ZW', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (382, 'Maestro Computers', '9820177952', '27AJNPB5174E1Z9', 'Maharashtra', 'both', 'Mufaddal Bharmal', 'bill', 'credit', 0, NOW(), NOW()), (383, 'Magnet & Electronic (India)', '', '07AADPG4882D1ZW', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (384, 'Magneticks', '', '27FREPS2017H1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (385, 'Mahalaxami Steel Centre', '9833260429', '27AYJPG0067C2ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (386, 'Mahalaxmi Bangles', '8433853481', '27BVZPJ6622C2Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (387, 'Mahalaxmi Steel Corp.', '8080636268', '27ABSPP9423B1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (388, 'Maharashtra Jewellery Tools', '9820047830', '27ABFFM3420L1Z8', 'Maharashtra', 'both', 'Shamshuddin Bhai', 'bill', 'credit', 0, NOW(), NOW()), (389, 'Mahavir Export Corporation', '2812360035', '24AKCPC9963C1ZE', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (390, 'Mahavir Impex ( Dr)', '9321493174', '27AAJHR6539Q1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (391, 'Mahavir Stores', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (392, 'Manek Ojarwala', '9537783797', '24ASUPM8571A1ZG', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (393, 'Manibhadra', '9489610848', '33AIYPJ4171D2Z5', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (394, 'Manibhadra Tools', '9920799954', '27AATHM9403N1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (395, 'Manmohan Tools Centre', '7874943119', '24AIPPR7971J1ZF', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (396, 'Manthan Enterprise', '9082344545', '27ATKPP1130H1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (397, 'Mariya Distributors', '9870062873', '32AKZPP2560R2Z6', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (398, 'Maru Enterprises', '8080085360', '27BEYPM1253E1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (399, 'Marvel Enterprises', '8291591049', '27CFLPG8090Q1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (400, 'Master and Company', '9820655077', '27AAHFM5319F1ZB', 'Maharashtra', 'both', ' Primary Mobile No.', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (401, 'Master Packaging Solutions', '9699074326', '27BASPK6875L1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (402, 'Mauli Jewellery Tools', '9920681474', '27BAMPP9552K1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (403, 'Max Technology India', '', '27ADGPR7453R1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (404, 'Max Techno Solutions', '', '27AATPR2132B1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (405, 'Mayur Enterprises', '8149732758', '27ANIPS9830M1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (406, 'Mbmg Diamonds Private Limited', '', '27AAFCM5904R1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (407, 'M.D.International', '9833752709', '27AEBPD8476L1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (408, 'Medallion Synergies Pvt Ltd', '9810058705', '07AANCM5528M1ZV', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (409, 'Medensco', '2222625460', '27AACPB3160A1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (410, 'Mehta Brothers', '9820092052', '27AFHPM2946M1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (411, 'Mehta Enterprises', '9821171608', '27AEMPM8065M1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (412, 'Mesh World Eco Pvt Ltd', '9768756643', '27AAGCM8628M1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (413, 'Metalia and Co', '', '27AHHPG2776P1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (414, 'Metro Tools Corporation', '', '27AEYPP4023Q1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (415, 'Mgm Traders', '9819631307', '27AAEPM2638Q1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (416, 'Microtech', '8806144881', '27AHYPB8704F1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (417, 'Miit corporation', '9820293202', '27ABJPJ7385F1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (418, 'M I K Dental', '9833400664', '27ABDFM5002C1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (419, 'Minesh Traders', '9228105001', '24ABWPL4742R1ZQ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (420, 'Mittal Applianes Ltd ( Cash)', '9004775205', '23AABCM1903A1ZF', 'Dadra & Nagar Haveli and Daman & Diu', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (421, 'Mittal Coin Pvt Ltd', '', '23AAICM9813G1ZF', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (422, 'Mittal Mill and Hardware Store', '9719116020', '09AASPM7868A1Z5', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (423, 'Mk Auto & Bearings', '9323767650', '27AFEPG7343D1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (424, 'M K International', '', '27CGNPS0595K1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (425, 'M K Trading', '9619019016', '27BQGPS2242M1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (426, 'M.M.M. Buxabhoy & Co', '', '27AACFM0148B1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (427, 'M M Sales', '9371153142', '27ABQPH6257B1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (428, 'Modern Fitting Stores', '9773582418', '27AAAPU5816G1ZL', 'Maharashtra', 'both', 'Imran', 'bill', 'credit', 0, NOW(), NOW()), (429, 'Modern Jewellery Tools', '7899932151', '29AALFM5210H1Z9', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (430, 'Modern Leather Bags', '8879529622', '27AAAPU6305Q1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (431, 'Modern Tools Store', '7307304596', '03CLQPS7959P1ZT', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (432, 'Modi Hardware Stores', '9923427860', '27AAPFM2117B1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (433, 'Mohamadi Hardware and Engineering Stores', '9892030030', '27ABCFM6618F1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (434, 'Mohammed Shadab Shaikh', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (435, 'Mohandas Parmanand Sof Fdr', '9833687183', '27AAAFM9942R1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (436, 'Mohandas & Sons', '', '27AAAFM1588M1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (437, 'Mohanlal Ghanshamdas', '9821210405', '27AABFM0050D1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (438, 'Mohini Organics Pvt Ltd', '', '27AAACM3174G1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (439, 'Moiz Traders', '', '27AABPK7330G1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (440, 'Moon Machinery Mart', '9821018849', '27AAAFM3647B1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (441, 'Moonwin Tools', '', '27AAZPS0402R1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (442, 'Moti Tools Center', '9561943929', '27ARVPM0860A1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (443, 'M R International', '', '07ADEPR5516K1ZA', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (444, 'M. Sakshi International', '9820828148', '27AEFPJ1253B1Z2', 'Maharashtra', 'both', 'Bunty', 'bill', 'credit', 0, NOW(), NOW()), (445, 'M/s Jenil Syndicate', '9324871200', '27ANHPS7740R1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (446, 'M S Sales Corporation', '8657225092', '29BHYPC7217H1ZV', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (447, 'M/s Ssr Services', '9869976471', '27AFVPN0656H1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (448, 'M/s Vardhaman Corporation', '9821325421', '27AAGPM9844A1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (449, 'Mtc Trading Company', '9829020875', '08ABAFM4310J1ZI', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (450, 'Mufaddal Arts', '9769165312', '27ANAPT0287D1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (451, 'Mukesh and Co', '9821080566', '27AVKPS3032K2Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (452, 'Mukesh Enterprise', '9426980906', '24AQSPS8111L1Z9', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (453, 'Mulchand R Shah', '9820094653', '27AACFM0165G1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (454, 'Multi Trade Link', '9042316811', '', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (455, 'Munisuvrata Enterprise', '9820351910', '27AAGPS5572H1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (456, 'NAC Jewellery Pvt Ltd', '', '33AACCN8833F1ZJ', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (457, 'Nakoda Traders', '9425056366', '23ADSPS8188A1Z4', 'Madhya Pradesh', 'both', 'Ravish A Jain', 'bill', 'credit', 0, NOW(), NOW()), (458, 'National Goods Carrier', '9312534606', '07BBIPS5626J2Z6', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (459, 'National Surgical Industries', '9814665860', '03AAAFN7394Q1ZP', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (460, 'National Tools Industries', '9892939735', '27ACBPS6235L1Z8', 'Maharashtra', 'both', ' Primary Mobile No.', 'bill', 'credit', 0, NOW(), NOW()), (461, 'National Trading Company', '', '27ADIPG3455E1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (462, 'Navbharat Carbon Company', '', '27AAAFN3943P1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (463, 'Navin Enterprises', '9820999253', '27ACPPM8827J2ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (464, 'Navketan Enterprise', '9920799954', '27AABPM3617N1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (465, 'Nayan Enterprises', '9821187678', '27AAOPS5854L1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (466, 'N.D.K Enterprise', '9821645665', '27AAEPS2869P1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (467, 'Neelam Corporation', '9825074616', '24ACMPM5269P1ZT', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (468, 'Neetaa Oversees', '', '27ACIPT2887L1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (469, 'Neeta Optical Gallery', '8080503145', '27AQOPS7443R1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (470, 'New Bombay Tools Centre', '9940177997', '33ACVPB6780D2ZI', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (471, 'New Era Transport Pvt Limited', '', '27AAHCN9245Q1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (472, 'New Jodhpur Tools Centre', '9887795951', '08BOGPS9633N1Z1', 'Rajasthan', 'both', 'Nitin Soni', 'bill', 'credit', 0, NOW(), NOW()), (473, 'New Kolkata Tools ( Secunderabad )', '9966653769', '36ACFPH7816Q1Z1', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (474, 'Newlite Agency', '2223471878', '27AALFM4268K1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (475, 'New Mayuri Tools', '9841810423', '33AAFPI8040R1ZE', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (476, 'New Rajumani Transport', '', '27AAEFN8402F1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (477, 'New Shri Lakshmi and Co', '9345101316', '33AAJPU6108J1ZH', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (478, 'New Tech Manufacturng Co', '', '24AFHPS6549A2ZF', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (479, 'New Trade Enter', '', '27ARUPS2631N1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (480, 'Nickunj Eximp Enterprises P Ltd. ( Dr)', '', '27AABCN0991K1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (481, 'Nilkanth Enterprise', '9924488096', '24ARUPV1822G1ZH', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (482, 'Nippo Enterprises', '9821281783', '27ACKPS7696C1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (483, 'Nitco Logistics Pvt Ltd', '', '27AAACN6345A2ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (484, 'Nitin Industries', '9825586462', '24BSSPV7069P1ZE', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (485, 'Nitin Works', '', '24ABUPV1922B1ZN', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (486, 'Nk Hearwell Solution', '9167545222', '27AMGPS9701A1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (487, 'N K Traders', '9820263900', '27AAEPS6458E1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (488, 'Noble Enterprise', '9867353350', '27ALGPM3548J1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (489, 'Noorani General Store', '9724865252', '24AAIPH3467J1ZM', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (490, 'Noor Handicrafts', '9149264827', '09AGEPA3442N1ZE', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (491, 'N V Traders', '9892087258', '27BFDPS6000P1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (492, 'N.Y.S. Corporation', '7041378413', '24DCUPS5909F1Z2', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (493, 'Ohasban India', '0651111112', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (494, 'Omega Tools India', '8506852595', '07BSEPG1851N1ZL', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (495, 'Omkar Electronics', '', '27AMAPP4930E1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (496, 'Om Traders', '7498895331', '27AXHPS0614G1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (497, 'On Time Express', '', '27AAPPK0170LIZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (498, 'Oriental Tools', '9925154403', '24AAAFO3358B1ZR', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (499, 'Orient Hardware & Tools Corporation', '9443715690', '33AAAFO4838Q1ZU', 'Tamil Nadu', 'both', 'Rashida Imani', 'bill', 'credit', 0, NOW(), NOW()), (500, 'Osborn Lippert India Pvt . Ltd', '', '27AAACL5555G1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (501, 'P and P Enterprise', '9821502512', '27ADEPD8513C1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (502, 'Paper Packs and Prints', '9820866315', '27AANFP5908M1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (503, 'Parakh Dia Jewels', '9425241122', '22AAUFP1033A1ZS', 'Chhattisgarh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (504, 'Param Enterprises', '9819767920', '27AAAPD7731P1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (505, 'Paras Corporation', '9819099414', '27AACPR2497N1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (506, 'Paras Ornaments House', '9915532323', '03AAFFP4218A1ZY', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (507, 'Parekh Packets and Tools', '8850938622', '27AAUPP4053E1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (508, 'Parshwa Traders', '9833196906', '27AHAPV9022A1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (509, 'Parth Tools', '9033271727', '24AADHA5336E1ZU', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (510, 'Penta Gas Industries', '9820959359', '27AJBPK4327L1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (511, 'Perfect Magnets (Drs)', '', '27AACHN3759B1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (512, 'Perfect Tablet Tools (CASH)', '9223538340', '27ATJPB7801Q1ZA', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (513, 'Perfect Tablet Tools LLP', '9223538340', '27ABCFP2493H1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (514, 'Perfect Tools Center', '9769549811', '27CECPS0781N1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (515, 'Permag Tradelink', '8928902273', '27AAIPN4131D1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (516, 'Pharmachine India', '9930240329', '27AACFP2824M1Z2', 'Maharashtra', 'both', 'Ratan Singhania', 'bill', 'credit', 0, NOW(), NOW()), (517, 'P J Engineering Corporation', '9892680707', '27AABPD3334P1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (518, 'P Kamdar & Co', '', '27AEPPK1413G1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (519, 'P K Enterprise', '9033131787', '24AAOPT9718Q1ZK', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (520, 'P K Shah & Co', '7303968504', '27AAEPS7083H1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (521, 'Poly Weight', '9819429431', '27AWGPS3863B1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (522, 'Poornima Enterprises ( Dombivali)', '9223416477', '27AGSPP5547P1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (523, 'Poornima Impex', '9924035044', '24CFIPP3099D1ZB', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (524, 'Popular Enterprises', '9821556873', '27AFZPS4171C1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (525, 'Popular Hardware Stores ( CLOSED)', '9945309452', '29AABFP8454C1Z6', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (526, 'Popular Tools Centre', '9004141275', '27AAFFP0808G1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (527, 'Porter', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (528, 'Power Plastic Product ( Closed)', '', '24AAEPS8293F1ZE', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (529, 'Power Plastic Products', '', '27AAEPS8293F1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (530, 'Prabhudas & Co', '9820277520', '27AAAPV6621N1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (531, 'Prachi and Company', '9987646373', '27AUPPS3859L1ZL', 'Maharashtra', 'both', 'Dharmendra Solanki', 'bill', 'credit', 0, NOW(), NOW()), (532, 'Pragati Diamonds Tools', '', '27AAHPM1544L1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (533, 'Pragati Glass & Industries Pvt Ltd', '', '24AABCP7377H1Z8', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (534, 'Prakash Metal Corporation', '9967848011', '27AACPJ7408D1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (535, 'Prashant Marketing and Services', '', '27AAVPA9277C1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (536, 'Pratima Jewellery Tools', '9769904351', '27BMKPP6143A1Z4', 'Maharashtra', 'both', 'Praveen Patil', 'bill', 'credit', 0, NOW(), NOW()), (537, 'Precision Engineers ( Kolhapur)', '7776008555', '27AAPFP4093H1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (538, 'Pregna International Ltd', '9904332444', '25AABCP3773B1ZQ', 'Dadra & Nagar Haveli and Daman & Diu', 'both', 'Viren Shah', 'bill', 'credit', 0, NOW(), NOW()), (539, 'Premaa Tools', '9362289290', '33ADXPJ2230K1ZF', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (540, 'Premnath Tools', '9964729956', '29ABTPB5444M1Z2', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (541, 'Prime Engineers', '', '24AELPB0575L1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (542, 'Prime Goods Distributors', '9867728075', '27EQPPS7562L2ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (543, 'Prime International', '', '03AANPB0297K1ZR', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (544, 'Prince Hallmarking and Refinery Pvt Ltd', '9892641496', '27AAJCP2423Q1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (545, 'Print Excellence', '', '27AAAFP2998Q1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (546, 'Prism Industries', '8080085360', '27AALHD8954M1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (547, 'Priyanka Enterprise', '9324367788', '27ABAPS7679C1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (548, 'Professional Couriers', '', '27AACPP5215G1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (549, 'Proficient Kiln Service LLP', '', '27AAXFP5809K1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (550, 'Prominent Surgical Co', '1814011783', '03AADFP0824A1Z4', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (551, 'Prospect Trading Co.', '9820395270', '27AACPD8168Q1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (552, 'Protosys Technologies Pvt Ltd', '9125905900', '27AAACP6182B1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (553, 'P. S Arts', '', '27APLPM0185Q1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (554, 'PS Impex', '9911915464', '07CSKPS7190F1Z7', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (555, 'P Tech Enterprises', '9892926491', '27BECPK0581B1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (556, 'Punit Impex', '9819337484', '27AACPB5028R1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (557, 'Punjani Opticals', '9810020993', '07AAEPP1339H1ZS', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (558, 'Quality Tools Centre ( Jaipur)', '9414051009', '08ASFPS6293L1ZX', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (559, 'Quantity Tools Corporation', '9833513258', '27AAEPM8705G1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (560, 'Qumos Enterprises', '9820258552', '27AAYPU0913C1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (561, 'Quresh Kothari', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (562, 'Qutbi Tools Corporation', '9820952651', '27APNPK7359G1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (563, 'Rahul Tools', '9981666660', '22BDUPS0314P2Z3', 'Chhattisgarh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (564, 'Rainbow Creations', '', '27AAPPK0170L1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (565, 'Rajaram & Sons', '9930755660', '27ABLFR3871L1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (566, 'Raja Traders', '', '07AARPS4055Q1ZQ', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (567, 'Rajendra Tools', '', '08ACLPJ2711J1ZM', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (568, 'Rajesh Enterprises', '', '24BOKPS3903M1ZK', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (569, 'Raj International', '', '27AAAPH1029G1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (570, 'Rajkot Jewellery Tools', '9350562639', '07AOZPS3965B1ZB', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (571, 'Raj Metals', '9167303304', '27AQUPM9775G1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (572, 'Raj Tools', '9320515152', '27AEAPM6387E1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (573, 'Raj Yog Corp.', '9819042064', '27AAIFR3030K1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (574, 'Ramdas M Nathdwarawala', '9824031274', '24AACFR0769D1ZH', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (575, 'Ramesh & Brothers', '1982360222', '27AAAPA8409R1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (576, 'Ramesh B Shah & Co', '3223455770', '27AAPPS1792L1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (577, 'Rameshchandra and Company', '2223465451', '27AADPS5610B1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (578, 'Rangwala Advisory and Consultants', '', '27AAPFR9216A1Z4', 'Maharashtra', 'both', 'Aziz Rangwala', 'bill', 'credit', 0, NOW(), NOW()), (579, 'Rasika Enterprise', '9004665058', '27ABKPU6909P1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (580, 'Ratna Tools Enterprises', '', '24AFHPS6550B2ZK', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (581, 'Rattansons International', '9988533636', '03AAPFR6380R2ZB', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (582, 'Ravi International', '1132911210', '', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (583, 'Raviratna Manufacturers', '9825256020', '24AQRPK5468K1Z6', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (584, 'Raydans Supplies Pvt. Ltd.', '2225853535', '27AAFCR9525F1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (585, 'R D Brothers', '9324646802', '27AABPV6702F1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (586, 'Reasonable Tools Corporation', '9375711052', '24AJYPM3706E1Z3', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (587, 'R E Diamond Tools', '9664706852', '24CONPN7759E1ZG', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (588, 'Regal Industries', '9650588065', '07ABAPW6112C1Z0', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (589, 'Rekhi Jewellery Tools & Machineries', '9855142025', '03CDQPR2195Q1ZN', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (590, 'Reliance Corporation ( Cash)', '', '27AEPPD9843P1ZL', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (591, 'Reshmo Tools', '', '27AAFPS2666B1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (592, 'R H Enterprises', '', '27BLQPS9127N2ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (593, 'R.H.Industries', '', '24ACTPM8280F1Z6', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (594, 'Rhyah Group', '9810058705', '07AZNPB9236H1Z6', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (595, 'Rian Inc Dr', '8558877924', '03ABBFR3814K1ZD', 'Punjab', 'both', 'Ashoke Khinder', 'bill', 'credit', 0, NOW(), NOW()), (596, 'Rian Inc Drs Closed', '1812202317', '03AESPK4574M1ZX', 'Punjab', 'both', 'Ashok Khinder', 'bill', 'credit', 0, NOW(), NOW()), (597, 'Riddhi Traders', '9819059165', '27AALPK2929D1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (598, 'Rima Soumen Paramanick', '', '27ACSPL0089L1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (599, 'Rishab Tools', '9000022332', '36ACLPJ0742K1ZI', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (600, 'R K Das Jewellery Tools', '9002597021', '19AXSPD4999E1ZS', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (601, 'R K GEMTEC', '9029031786', '27ABIPL1203H1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (602, 'R K Tools', '', '03AAGFR8700G1ZG', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (603, 'Romil Jewelry', '9892476545', '27AAKFR7911D1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (604, 'Roshan Traders', '2223422165', '27AAAFR5720L1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (605, 'Rotek Pharma Technologies', '9930130101', '27AMQPB4613C1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (606, 'Rotek Pharma Technologies Pvt Ltd', '8291210105', '27AAKCR8240A1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (607, 'Royal Diamonds and Tools', '9444332704', '33AAFFR2197A1ZJ', 'Tamil Nadu', 'both', 'Lakesh Jain', 'bill', 'credit', 0, NOW(), NOW()), (608, 'Royal Enterprise', '9820834312', '27AAKPG9240J1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (609, 'Royal Hand Tools', '', '08ADKPS9437J1ZR', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (610, 'Royal International ( Shabbir Mukadam )', '9821334952', '27AAEFR0957M1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (611, 'Royal Mech Engineers', '9029553805', '27CBIPS9933H1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (612, 'Royal Metals', '9820781132', '27AADPR7698L1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (613, 'Royal Time Industries', '', '24AACFR5141D1ZP', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (614, 'Royal Trade Agency', '9341241320', '29BPHPM7716J1ZC', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (615, 'Royal Traders', '9820075961', '27AADPR4380D1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (616, 'R.R. Impex CLOSED', '8976804762', '27AATFR4754P1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (617, 'R R Impex Elite India Pvt Ltd', '9136640694', '27AAMCR3632E1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (618, 'R.R.Jewellers', '9824020062', '24AANFR4269B1Z7', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (619, 'R.S Exim', '4065606514', '36AAHHS4492P1Z9', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (620, 'R.T.International', '8875373238', '08AFVPG9791E1ZQ', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (621, 'Rushabh Enterprises', '9029036007', '27AHYPM5666R1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (622, 'Ruth International', '9811114022', '06ALNPB6505F1ZE', 'Haryana', 'both', 'Ashoke Bhardwaj', 'bill', 'credit', 0, NOW(), NOW()), (623, 'S A Bukhari Tools Suppliers', '9414269851', '08ABJPS6891H1ZX', 'Rajasthan', 'both', 'S Akbar', 'bill', 'credit', 0, NOW(), NOW()), (624, 'Sadhana Enterprises', '9029804060', '27AHMPG4636P1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (625, 'Safe Dispomed', '', '27ACKPG6212A1Z5', 'Maharashtra', 'both', 'Gaurav', 'bill', 'credit', 0, NOW(), NOW()), (626, 'Safina Impex ( Tarmal)', '', '27ABNFS8420Q1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (627, 'Sagar Trade Centre (Cash)', '', '27AACHB7612P1Z2', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (628, 'Sagar Universal', '9769991774', '27ABRFS6636A1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (629, 'Sahni Tools Store', '9811163665', '07AARFS0966Q1Z7', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (630, 'Saif Trading and Services', '9004558252', '27ADVPI6312H1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (631, 'Sai Gold Private Limited', '', '27AAPCS0080A1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (632, 'SAINATH EXPRESS SERVICE PRIVATE LIMITED', '', '24AATCS1290G1Z5', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (633, 'Sai Packagings', '9619900619', '27ARYPS9919D1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (634, 'Sai Rubber Industries', '', '24NAWPS8295G1ZF', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (635, 'S Akbaraly (Cash)', '23425716', '27AAPFS9968Q1ZN', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()), (636, 'Samrath Hira Enterprises', '', '27OXVPS3277P1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (637, 'Samrath Industries', '', '27ALTPB8579R1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (638, 'Samyak Tools', '2249739899', '27BOXPS1317A1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (639, 'Sanghavi Abrasives', '9819476223', '27AAYPS3747A1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (640, 'Sap Enterprises', '9920997291', '27AJYPS1821Q1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (641, 'Sarthak Impex', '9320001145', '27APVPJ3273Q1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (642, 'Saru Enterprises', '9819877537', '27ACWPD5101F1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (643, 'Sarvodaya Trading Corporation', '2223735923', '27AACFS4886L1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (644, 'Satpur Industrial Tools Centre', '8055805152', '27AGOPM6609B1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (645, 'Satyam Tools', '8128440845', '24AEOFS3355J1ZN', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (646, 'Savai Printers Pvt Ltd', '9820635691', '27AAACS5624F1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (647, 'SB Traders', '9819425289', '27ABHPY6626Q1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (648, 'Sea Marin', '', '27AGZPA4933H1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (649, 'Seema Enterprise', '9821220051', '27ALVPS7815D1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (650, 'Semson International', '9821712340', '27AAWPM9338D1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (651, 'Semsons Diamond Tools', '9821712340', '27ACEPM8226E1ZN', 'Maharashtra', 'both', 'Pikesh Babulal Mehta', 'bill', 'credit', 0, NOW(), NOW()), (652, 'Semsons Packets & Tools', '9821147870', '27AAWPM9225D1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (653, 'Sethia and Co', '9833173218', '27APAPS5419L1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (654, 'Shadow Exports', '9987437786', '27AAAFS0564P1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (655, 'Shafa Tools', '', '27AAMFS3625D1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (656, 'Shahaji Kashiram More', '9323047432', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (657, 'Shah Associates', '9821248620', '27BADPS8539N1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (658, 'Shah Enterprises', '9320523222', '27AACFS4404J1Z9', 'Maharashtra', 'both', 'Yogesh Shah', 'bill', 'credit', 0, NOW(), NOW()), (659, 'Shah Files & Drills Pvt. Ltd.', '', '27AAACS7143P1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (660, 'Shahid Exports', '', '', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (661, 'Shah Industries', '', '24AFHPS6552D1ZF', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (662, 'Shah & Parekh Traders LLP', '', '27ADPFS6863H1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (663, 'Shah Sales Corporation', '9773007670', '27AALFS9545H1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (664, 'Shah Tools & Bearing Co.', '', '27AAAFS1134M1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (665, 'Shaman Trading Co.', '', '07AAOPI2470E1ZT', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (666, 'SHAMS AUTOMOBILE LLP', '', '27AEKFS9703G1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (667, 'Shangai YA GU Trading Co Ltd', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (668, 'Shankeshwar Sales Corp.', '9820434734', '27BIKPS8919K1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (669, 'Sharma Tansports', '', '27ADPFS9020E1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (670, 'Sharp Enterprise', '7405406309', '24ACUFS7214E1ZY', 'Gujarat', 'both', 'Vijay', 'bill', 'credit', 0, NOW(), NOW()), (671, 'Shashwat Tools', '9821149899', '27AFBPG8815M1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (672, 'Shayona Enterprises', '', '27ARWPP3297K1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (673, 'Sheth Enterprises', '9324611864', '27AADHK2099E1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (674, 'Shilpa Arts (C/F Mufaddal Sharbat)', '9820400354', '27ACVFS3662B1ZT', 'Maharashtra', 'both', 'Amal Paramanick', 'bill', 'credit', 0, NOW(), NOW()), (675, 'Shilpa Engineering', '9225136825', '27AJRPK2357E1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (676, 'Shiv Enterprises', '9729960016', '08COOPG7914R1Z0', 'Rajasthan', 'both', 'KUMAR GOURAV', 'bill', 'credit', 0, NOW(), NOW()), (677, 'Shiv Tools & Machines', '', '24BDKPN6597B1ZB', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (678, 'Shree Ambika Enterprises', '9821126039', '27ALJPV6432H1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (679, 'Shree Durga Trading', '9689191002', '27AURPD9772B1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (680, 'Shree Electronics', '9167545222', '27AEWPD6251L1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (681, 'Shree Ganesh Tools Centre', '9594473506', '27CYCPP0669N1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (682, 'Shree Jain Traders', '9660576408', '08AJEPJ2947E1ZB', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (683, 'Shreeji Enterprises', '9920187321', '27AGHPC1080B1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (684, 'Shreeji Industries ( Nasik)', '9673587082', '27ANHPB3375R1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (685, 'Shreeji Industries (Rajkot)', '9374929215', '24AFFPV3896M1ZM', 'Gujarat', 'both', 'Bharat', 'bill', 'credit', 0, NOW(), NOW()), (686, 'Shreeji Trading Company', '9820454550', '27AKEPM1013F1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (687, 'Shree Khima Kanchi', '', '27ACFPK3175R1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (688, 'Shree Khodiyar Industries', '', '24DILPS9326F1ZV', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (689, 'Shree Mahadev Bag Shop', '', '27ASNPP1185G1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (690, 'Shree Mt Impex', '9717357960', '07CETPM8809J1ZO', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (691, 'Shri Balvi Tools Centre', '9374857685', '24AFCPC8100Q1ZL', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (692, 'Shri Enterprise', '6351785313', '24ADWPT9639D1ZT', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (693, 'Shriji Ojarwala', '9825830764', '24AADHS7040F1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (694, 'Shrinath Industries', '', '24ADYPD2827P1ZY', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (695, 'Shripadam Trading Company', '', '27ADUFS1722Q1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (696, 'Shri Tirupati Box', '9993815616', '23AWLPS7262F1Z9', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (697, 'Shyamlal Radhakrishna & Co.', '', '27AALFS2322Q1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (698, 'Sieko Brushware ( INDIA)', '8860449766', '07AACFS1123J1ZH', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (699, 'Silverwing Patel Carrier', '', '08ABJFS1218G1Z9', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (700, 'Simran Tools International', '9958281414', '07ABNPS2017H1ZL', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (701, 'S J Marketing', '8211378850', '27AZVPS3963L1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (702, 'S.K.Products', '', '27ABBPL0607N1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (703, 'S K Sales Agencies', '9930595596', '27ATZPB4256F1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (704, 'Slicer Grinding Wheels', '9324085585', '27AZCPS4138E1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (705, 'Smart Tools', '9877493893', '03AZKPG4759K1Z3', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (706, 'Smb Automation Pvt.Ltd', '2243400553', '27AAUCS4161M1ZL', 'Maharashtra', 'both', 'Huzaifa Biviji', 'bill', 'credit', 0, NOW(), NOW()), (707, 'S M Enterprises CLOSED', '9828166070', '08EKTPK5149D1ZR', 'Rajasthan', 'both', 'Vikas', 'bill', 'credit', 0, NOW(), NOW()), (708, 'Smithshine', '9825090766', '24AFMPP2691D2ZC', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (709, 'S.M. Soni Tools & Box Stores', '8469545346', '24BLFPG9968Q1Z6', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (710, 'Sndt Women University', '9082221527', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (711, 'Sndtwu V.Vok', '', '27AACTS2211D1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (712, 'Sonal Jewellery Tools', '9920222452', '24AEQPB8546L1Z2', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (713, 'Sonal Sales Agency ( Sk Sales)', '8080595596', '27AJDPB9024B1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (714, 'Soni Chaman Lal', '', '', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (715, 'Sonisat Machine Tools Corporation', '', '27AELFS0854F1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (716, 'Soni Tools', '8469620239', '', 'Gujarat', 'both', 'Shahid Shaikh', 'bill', 'credit', 0, NOW(), NOW()), (717, 'Soni Tools Centre ( Yunus )', '9819561852', '27AAAFS7672J1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (718, 'Soni Tools ( Surat )', '9913032154', '24AEDPS0610P1ZH', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (719, 'Soni Trading Co ( Rajkot)', '9429244868', '24AGBPS7204H1ZK', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (720, 'Sonu Electrical and Hardware', '9322685458', '24AAKPS3827M1Z7', 'Gujarat', 'both', 'Girish', 'bill', 'credit', 0, NOW(), NOW()), (721, 'Spacetec Industries', '9152379266', '27AATPM7474R1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (722, 'S P G Medisales Pvt Ltd', '', '27ABECS1908D1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (723, 'Spm Technologies', '9964397309', '33CAWPM0887K1ZY', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (724, 'Spr Suppliers', '8949570205', '33AEUPB6413Q1Z3', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (725, 'S P Scientific Works', '', '06AEYPP4952N1ZG', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (726, 'S.R. Enterprises', '9829069410', '08AFGFS7033E1ZZ', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (727, 'S R Enterprises ( Mumbai )', '7715064534', '27AACPS6675F1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (728, 'Sri Amritha Tools Centre', '9363145288', '33ADEPM5850H1ZM', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (729, 'Sri Aurobindo Handmade Paper', '9363249842', '34AABTS0117KRZ0', 'Puducherry', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (730, 'Sri Chakra Traders', '', '27AAIPM2997G1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (731, 'Sri Laxmi Tools and Chemical', '9100655094', '36AHCPP3350K1Z9', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (732, 'Sri Mahalaxmi Tools ( Secunderabad)', '9849912614', '36ARVPP5165H1Z3', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (733, 'Srinathji Jewellery Machinery and Tools', '9558002011', '24AEGFS1299M1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (734, 'S.R. Industries', '8490957777', '24AMDPM0010B1Z5', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (735, 'Sri Rounak Jewellery Equipments', '9962597479', '33AFCPJ0713N1ZQ', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (736, 'Sri Vinayaka Tools', '7702770007', '37ASKPD6181F1ZO', 'Andhra Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (737, 'S S Impex (Jaipur)', '9314088318', '08AGNPJ7861K1ZP', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (738, 'S.S. Measuring Tools Co.', '9029506957', '27ACPPM8416K1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (739, 'SS Overseas', '', '07CKTPS5015G1ZS', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (740, 'Star', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (741, 'Star C', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (742, 'Star Enterprises 72 Narayan', '9819041735', '27AFTPC5556M1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (743, 'Starex', '9810761134', '07CZXPD6242H1Z0', 'Delhi', 'both', ' Primary Mobile No.', 'bill', 'credit', 0, NOW(), NOW()), (744, 'Star Gold', '9820050474', '27ALWPS1407J1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (745, 'Star International', '9444132126', '33AAYFS4619K1ZJ', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (746, 'Star Machine and Tools', '9324798925', '27AYBPP8248E1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (747, 'Star Surgical Work Pvt Ltd', '9876104147', '03ABNCS2052D1ZP', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (748, 'Star Tools Corporation', '', '07AANPK4424H1ZO', 'Delhi', 'both', 'Kapoor', 'bill', 'credit', 0, NOW(), NOW()), (749, 'Star Tools ( Trivedum)', '9892181600', '32AARFS7048F1ZY', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (750, 'Sterling Enterprises', '', '27AAAPM6811H1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (751, 'S T R Tools Centre', '9943981971', '33AAPFS5494M1ZD', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (752, 'St. Xaviers College', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (753, 'Subhash Industries', '9322295385', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (754, 'Subhash Jewellery Tools', '9892704382', '27AQEPM4901E1Z4', 'Maharashtra', 'both', 'Subhash', 'bill', 'credit', 0, NOW(), NOW()), (755, 'Suguru Tools', '8949250813', '08AJAPC4799F1Z6', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (756, 'Sun B International', '9810067678', '07AAIPB4716E1Z5', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (757, 'Sundaram Enterprise', '7710071402', '27DDZPP9203H1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (758, 'Sunil Industries', '', '27CZZPG4990B1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (759, 'Sunil Traders', '9322881671', '27AAEPS2001D1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (760, 'Sunraj Industries', '9869482514', '27AACPG8089M1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (761, 'Sunrise International', '9814007925', '03AIVPK7936J1ZN', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (762, 'Sunrise Tools India Pvt Ltd', '9814007925', '03AAECS7037A1ZV', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (763, 'Sunshine Polishing Industries ( Sk Sales)', '9920222452', '24ADZFS9251P1ZV', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (764, 'Super Hydro Pheumatic', '9004689677', '27AACPS6050N1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (765, 'Super Pneumatics', '8879909994', '27BHTPS1660M1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (766, 'Superstar Enterprises', '22005186', '27AADPM6625N1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (767, 'Super Technology & Co', '9834089644', '27AFGPY0145M3ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (768, 'Super Tools Centre ( Dhanji)', '', '27ACRPN1937A1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (769, 'Surya Abrasives', '9414283440', '08ADTPS8358R1Z0', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (770, 'Surya Funners', '9893383598', '23BQOPR4748H1ZD', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (771, 'Surya Tools Centre', '9769711566', '32AFHPR5818R1ZR', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (772, 'Suryavanshi & Sons', '', '27AYIPS7230C1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (773, 'S V Enterprises', '', '27AWGPS3489K1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (774, 'Swamy Tools Centre', '9362343308', '33AAZPN3194R1ZK', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (775, 'Swastik Jewels', '9870709302', '27ACHFS9103K1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (776, 'Swastik Metal Products', '9869439865', '27AAAPC4460C1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (777, 'Swati Electricals', '9427161138', '24AFQPV7516M1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (778, 'Taj Sales Corporations', '9326775252', '27AADFT1582H1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (779, 'Tally (India) Private Limited', '', '29AACCT3705E1ZJ', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (780, 'Tanna Tools Corporation', '9819779912', '27AAAPT5057A1ZX', 'Maharashtra', 'both', 'Bipin Babulal Tanna', 'bill', 'credit', 0, NOW(), NOW()), (781, 'Tapan Art & Craft', '9820659072', '27AAIHJ7892P1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (782, 'Target Publications Pvt Ltd', '8879939712', '27AADCT3346E1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (783, 'Tayebali Son\'s', '', '27AAAFT9744N1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (784, 'Techno Tools Traders', '9840133315', '33AACFT2457N1ZY', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (785, 'Techtone Electronics', '9323465680', '27AAAPF0646H1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (786, 'Techvin', '8268574791', '27BRQPS4005P1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (787, 'Tejal Trading Company', '9892560635', '27AAMPS5006Q1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (788, 'The Arihant Packet & Tools', '9440141483', '36AFMPJ1286Q1ZQ', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (789, 'Thermo Forg Company', '9909009945', '24AANFT0554D1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (790, 'The Silver Scientific Time Industries', '9825203266', '24AFNPS7255P1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (791, 'The Time', '9811147903', '07AAFPG4432M1ZP', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (792, 'Tiana Jewellery Exports Pvt Ltd', '2230830000', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (793, 'Time Spare', '9313677369', '07ACGPB3104J1Z4', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (794, 'T K Ramaraj', '', '33AKHPR8139C1Z5', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (795, 'T N Enterprises', '9827725533', '23BBAPM1792F1ZX', 'Madhya Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (796, 'Tools Impex', '9820298311', '27ABQPH7607D2ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (797, 'Tools Traders Turbe Pvt Ltd', '9867330421', '27AAECT5753C1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (798, 'Tools World', '9824223456', '24ACFPG4426R1ZD', 'Gujarat', 'both', 'Kamlesh / Praful', 'bill', 'credit', 0, NOW(), NOW()), (799, 'Toy Kids', '', '27AANHS8328C1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (800, 'Trackon Courier Private Ltd', '', '07AABCC8298E1ZH', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (801, 'Trimurti Enterprise', '', '27AJQPG3512L1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (802, 'Troupe Technologies Private Limited', '9833012144', '27AAGCT4765Q1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (803, 'T.Subburam Tools Merchant', '9790347376', '33AZRPS8946B1ZV', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (804, 'Udupi Venkatesj Shet', '', '29ANAPS9623E1ZR', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (805, 'Uk Abrasive', '9312478882', '07ATVPJ8645A1ZD', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (806, 'U K Electronics', '9322049865', '27AYXPS2841J1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (807, 'Ultramech', '9821381141', '27AFFPJ7350A1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (808, 'Uni Corp', '', '27AUGPK7134F1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (809, 'Unique Enterprises', '9892208448', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (810, 'Unique Industries (Crs)', '', '24ABUPB3572F1ZP', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (811, 'Unique Saws and Machinery Pvt Ltd', '9329635229', '23AAACU7070K1Z9', 'Madhya Pradesh', 'both', 'Mahesh', 'bill', 'credit', 0, NOW(), NOW()), (812, 'Unique Tools Center', '', '27AADPK6297Q1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (813, 'United Industries', '9898233456', '24AACFU1500B1Z3', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (814, 'Unitek Impex', '9820013916', '27AAAFU0755C1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (815, 'Universal Enterprise', '9029939641', '27ASJPR4862L1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (816, 'Universal Enterprises ( Kolhapur )', '8208601881', '27AIPPG5415J1Z1', 'Maharashtra', 'both', 'Dheeraj A Ghatage', 'bill', 'credit', 0, NOW(), NOW()), (817, 'Universal Plastic', '7947130054', '24BEMPP0481B1ZQ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (818, 'Universal Tools & Engg.', '9841036208', '33AHYPS0884R1Z3', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (819, 'USM Enterprises', '9898690886', '24AVJPL5308E1ZT', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (820, 'U S Pharma India Private Limited', '', '27AAACU6722G1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (821, 'Utkal Arts', '', '27AEEPM4586R1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (822, 'Vaishali Traders', '9322595591', '27AGSPD7593D1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (823, 'Vaja Traders', '9833569772', '27AFPPV7502N1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (824, 'Valisons and Company', '', '27AAAFV5145M1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (825, 'Vandana Enterprises', '', '27BNFPS9703P1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (826, 'Vapson Jewellery Equipments Pvt Ltd', '9820287720', '27AACCV0184B1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (827, 'Vardhaman Enterprise', '9820882634', '27BDSPS9830E1ZW', 'Maharashtra', 'both', 'Ganesh', 'bill', 'credit', 0, NOW(), NOW()), (828, 'Vardhaman Sales', '9594931553', '27AQVPS3030K1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (829, 'Vardhaman Steel', '', '27ACEPS2549E1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (830, 'Vardhman Enterprise', '8000014183', '24AMDPD1375J1ZB', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (831, 'Vardhman Jewellery Tools', '9845665556', '29ADEPS9481L1ZL', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (832, 'Vardhman Traders', '9870005771', '27AAWFV9674P1ZK', 'Maharashtra', 'both', 'Bipin Shah', 'bill', 'credit', 0, NOW(), NOW()), (833, 'Vasant Enterprise', '9820388240', '27AADPM4454B1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (834, 'Vazirbun Trading', '9962507451', '33AAAFV0380L1Z8', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (835, 'Vector Machine Tools Co', '', '27AAAFV1532A1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (836, 'Vedika Traders', '', '27AFCPM5030K1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (837, 'Veer Tranmission', '8850710515', '27AEIPM3648A1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (838, 'Vijay Sales India Pvt Ltd', '', '27AAHCV3778L1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (839, 'Vijay Traders', '9702272976', '27AAEFV2253N1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (840, 'Vikram Enterprise', '9322386076', '27ANIPS6068B1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (841, 'Vimal Engineering Company', '9821232159', '27AAVPS0371F1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (842, 'Vimal Hardware Corporation', '7021744690', '27AAPPP8786K1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (843, 'Viraj Enterprise', '', '27AACPS5221M1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (844, 'Visak Jewellery Tools', '', '27AULPP8494L1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (845, 'Vishal Eng Co', '', '27ANQPS6878M1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (846, 'Vishal Trading Co. VICKY Sadanand', '9818023050', '07ALLPD6213G1ZD', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (847, 'Vishay Semiconductor India Pvt. Ltd.', '982105208', '27AAACS6827Q1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 1, NOW(), NOW()), (848, 'Vishrolia Machinery Stores', '9033033309', '24ACWPV8921B1Z6', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (849, 'Vishwakarma Wooden', '8487887887', '24AGNPD9646C1ZF', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (850, 'Vitraj Int', '9821184567', '27ALAPM9640D1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES (851, 'V Mehta Abrasives Pvt Ltd', '9820217456', '27AAJCV1465G1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (852, 'V Mehta & Co', '9820217456', '27AAAPM2223P1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (853, 'V P Industries', '8825748985', '33BREPR0462D1Z5', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (854, 'V R Steel Craft (Mandre Kolapur College)', '9921834183', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (855, 'Vrudhi Entp', '9821045391', '27AADPC0544J1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (856, 'Vyoma Trading Co.', '9323404686', '27AAOPS1998K1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (857, 'Watch Market', '', '07AKWPK6247P1Z4', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (858, 'Western Enterprises', '', '27AAQPS7478C1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (859, 'Whalaxy International', '9586851515', '24BXBPB8139G1ZR', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (860, 'Wholesale Enterprise', '9511705358', '27AIEPT3168Q1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (861, 'WJT India Pvt Ltd', '', '27AADCW3581C1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (862, 'Xavier Electric', '', '27ALZPA7408E1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (863, 'Yaf Stationery Mart', '', '27AAAFY0144P1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (864, 'Yaman Impex', '9820441301', '27AAAPZ0813E1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (865, 'Yash Enterprises', '', '27ACMPV3129P1ZR', 'Maharashtra', 'both', 'SUDHIR NARSIDAS VORA', 'bill', 'credit', 0, NOW(), NOW()), (866, 'Yash Enterprises ( Mahesh Koticha)', '9820775528', '27AAKPK3410E1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (867, 'Yogesh Das', '9967917524', '27AFHPD0013N1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (868, 'Yogiraj Engineering', '', '24EYKPP8934G1ZW', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (869, 'Y S Patrawala and Company', '9224348616', '27AAAFY0134D1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (870, 'Zai Jewellery Tools', '', '27ACTPB4470G1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (871, 'Zan Tools Centre', '9029097037', '27ANSPN2854L1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()), (872, 'Zen Clothing Company', '7900199244', '27AAAFZ0127B1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()); -- ============================================ -- Part 2: Opening Balances -- Uses company_id = 1, fiscal_year = 2024-2025 -- direction: 'receive' = customer owes us -- 'payable' = we owe vendor -- ============================================ INSERT IGNORE INTO `opening_balances` (`customer_id`, `company_id`, `amount`, `direction`, `as_of_date`, `fiscal_year`) VALUES (3, 1, 72000.00, 'receive', '2025-04-01', '2024-2025'), (9, 1, 570112.40, 'receive', '2025-04-01', '2024-2025'), (20, 1, 43011.00, 'payable', '2025-04-01', '2024-2025'), (24, 1, 16142.00, 'receive', '2025-04-01', '2024-2025'), (30, 1, 94080.00, 'payable', '2025-04-01', '2024-2025'), (33, 1, 25000.00, 'receive', '2025-04-01', '2024-2025'), (36, 1, 107388.00, 'receive', '2025-04-01', '2024-2025'), (40, 1, 2065.00, 'receive', '2025-04-01', '2024-2025'), (46, 1, 20650.00, 'receive', '2025-04-01', '2024-2025'), (49, 1, 7089.00, 'receive', '2025-04-01', '2024-2025'), (67, 1, 91350.00, 'payable', '2025-04-01', '2024-2025'), (68, 1, 1688.00, 'receive', '2025-04-01', '2024-2025'), (93, 1, 18357.00, 'receive', '2025-04-01', '2024-2025'), (94, 1, 4720.00, 'payable', '2025-04-01', '2024-2025'), (100, 1, 35318.00, 'receive', '2025-04-01', '2024-2025'), (131, 1, 114099.00, 'payable', '2025-04-01', '2024-2025'), (135, 1, 27494.00, 'receive', '2025-04-01', '2024-2025'), (138, 1, 1888.00, 'receive', '2025-04-01', '2024-2025'), (146, 1, 17204.00, 'payable', '2025-04-01', '2024-2025'), (150, 1, 2.00, 'payable', '2025-04-01', '2024-2025'), (163, 1, 3245.00, 'receive', '2025-04-01', '2024-2025'), (185, 1, 4838.00, 'payable', '2025-04-01', '2024-2025'), (201, 1, 96532.68, 'receive', '2025-04-01', '2024-2025'), (206, 1, 182900.00, 'payable', '2025-04-01', '2024-2025'), (218, 1, 36799.00, 'receive', '2025-04-01', '2024-2025'), (229, 1, 158918.00, 'payable', '2025-04-01', '2024-2025'), (231, 1, 84326.00, 'payable', '2025-04-01', '2024-2025'), (237, 1, 5192.00, 'receive', '2025-04-01', '2024-2025'), (238, 1, 18349.00, 'receive', '2025-04-01', '2024-2025'), (246, 1, 15954.00, 'receive', '2025-04-01', '2024-2025'), (266, 1, 45400.00, 'receive', '2025-04-01', '2024-2025'), (272, 1, 33276.00, 'receive', '2025-04-01', '2024-2025'), (275, 1, 33866.00, 'receive', '2025-04-01', '2024-2025'), (279, 1, 8644.00, 'receive', '2025-04-01', '2024-2025'), (288, 1, 101108.00, 'receive', '2025-04-01', '2024-2025'), (297, 1, 86966.00, 'receive', '2025-04-01', '2024-2025'), (303, 1, 2832.00, 'receive', '2025-04-01', '2024-2025'), (309, 1, 177420.00, 'receive', '2025-04-01', '2024-2025'), (316, 1, 32468.00, 'receive', '2025-04-01', '2024-2025'), (317, 1, 365194.13, 'receive', '2025-04-01', '2024-2025'), (322, 1, 5900.00, 'receive', '2025-04-01', '2024-2025'), (360, 1, 114430.00, 'receive', '2025-04-01', '2024-2025'), (361, 1, 15812.00, 'receive', '2025-04-01', '2024-2025'), (363, 1, 22656.00, 'receive', '2025-04-01', '2024-2025'), (374, 1, 3257.00, 'receive', '2025-04-01', '2024-2025'), (377, 1, 238330.00, 'payable', '2025-04-01', '2024-2025'), (380, 1, 23562.00, 'payable', '2025-04-01', '2024-2025'), (387, 1, 2832.00, 'receive', '2025-04-01', '2024-2025'), (392, 1, 24106.00, 'receive', '2025-04-01', '2024-2025'), (402, 1, 4418.00, 'receive', '2025-04-01', '2024-2025'); INSERT IGNORE INTO `opening_balances` (`customer_id`, `company_id`, `amount`, `direction`, `as_of_date`, `fiscal_year`) VALUES (419, 1, 27928.00, 'receive', '2025-04-01', '2024-2025'), (429, 1, 95378.14, 'receive', '2025-04-01', '2024-2025'), (443, 1, 160008.00, 'payable', '2025-04-01', '2024-2025'), (444, 1, 43919.00, 'receive', '2025-04-01', '2024-2025'), (449, 1, 25000.00, 'payable', '2025-04-01', '2024-2025'), (455, 1, 18762.00, 'receive', '2025-04-01', '2024-2025'), (463, 1, 15394.90, 'payable', '2025-04-01', '2024-2025'), (472, 1, 12036.00, 'receive', '2025-04-01', '2024-2025'), (475, 1, 9000.00, 'receive', '2025-04-01', '2024-2025'), (485, 1, 37052.00, 'payable', '2025-04-01', '2024-2025'), (493, 1, 17516.00, 'receive', '2025-04-01', '2024-2025'), (499, 1, 23954.00, 'receive', '2025-04-01', '2024-2025'), (514, 1, 168099.96, 'receive', '2025-04-01', '2024-2025'), (521, 1, 4577.90, 'receive', '2025-04-01', '2024-2025'), (529, 1, 33158.00, 'payable', '2025-04-01', '2024-2025'), (537, 1, 8290.00, 'receive', '2025-04-01', '2024-2025'), (540, 1, 23010.00, 'receive', '2025-04-01', '2024-2025'), (568, 1, 50000.00, 'receive', '2025-04-01', '2024-2025'), (578, 1, 29500.00, 'payable', '2025-04-01', '2024-2025'), (597, 1, 12702.00, 'receive', '2025-04-01', '2024-2025'), (599, 1, 70658.00, 'payable', '2025-04-01', '2024-2025'), (600, 1, 3056.00, 'payable', '2025-04-01', '2024-2025'), (615, 1, 11800.00, 'receive', '2025-04-01', '2024-2025'), (619, 1, 102913.20, 'payable', '2025-04-01', '2024-2025'), (628, 1, 16398.00, 'payable', '2025-04-01', '2024-2025'), (652, 1, 1463.00, 'receive', '2025-04-01', '2024-2025'), (655, 1, 1912.00, 'receive', '2025-04-01', '2024-2025'), (656, 1, 22174.00, 'payable', '2025-04-01', '2024-2025'), (667, 1, 46046.54, 'payable', '2025-04-01', '2024-2025'), (682, 1, 78851.00, 'receive', '2025-04-01', '2024-2025'), (683, 1, 5428.00, 'receive', '2025-04-01', '2024-2025'), (685, 1, 10620.00, 'receive', '2025-04-01', '2024-2025'), (707, 1, 24608.00, 'receive', '2025-04-01', '2024-2025'), (726, 1, 5101.00, 'payable', '2025-04-01', '2024-2025'), (736, 1, 22916.00, 'receive', '2025-04-01', '2024-2025'), (739, 1, 47200.00, 'payable', '2025-04-01', '2024-2025'), (746, 1, 77308.00, 'payable', '2025-04-01', '2024-2025'), (747, 1, 41950.00, 'payable', '2025-04-01', '2024-2025'), (748, 1, 5000.00, 'receive', '2025-04-01', '2024-2025'), (749, 1, 11953.00, 'receive', '2025-04-01', '2024-2025'), (751, 1, 24526.60, 'payable', '2025-04-01', '2024-2025'), (762, 1, 16815.00, 'receive', '2025-04-01', '2024-2025'), (784, 1, 88677.00, 'receive', '2025-04-01', '2024-2025'), (794, 1, 602959.00, 'payable', '2025-04-01', '2024-2025'), (797, 1, 3186.00, 'receive', '2025-04-01', '2024-2025'), (798, 1, 24308.00, 'receive', '2025-04-01', '2024-2025'), (802, 1, 221561.00, 'payable', '2025-04-01', '2024-2025'), (810, 1, 76464.00, 'payable', '2025-04-01', '2024-2025'), (814, 1, 168086.50, 'receive', '2025-04-01', '2024-2025'), (819, 1, 41005.00, 'payable', '2025-04-01', '2024-2025'); INSERT IGNORE INTO `opening_balances` (`customer_id`, `company_id`, `amount`, `direction`, `as_of_date`, `fiscal_year`) VALUES (826, 1, 18455.00, 'receive', '2025-04-01', '2024-2025'), (832, 1, 4306.00, 'receive', '2025-04-01', '2024-2025');