Format: sql
Size: 329 MB
all raw:30,163,342
INSERT INTO `distributors` (`id`, `tenant_id`, `user_id`, `user_name`, `is_have_user`, `tier_id`, `tier_name`, `category_id`, `category_name`, `channel_name`, `distributor_status_id`, `tax_status_id`, `tax_status_name`, `channel_id`, `tax_status_code`, `name`, `opening_time`, `closing_time`, `address`, `second_address`, `ntn`, `exp_code`, `start_date`, `end_date`, `gst_reg_no`, `gst_reg_start_date`, `longitude`, `latitude`, `contact_name`, `contact_email`, `contact_phone_no`, `contact_cell_no`, `contact_cnic`, `contact_fax`, `is_base_town`, `outlet_geo_tagged_status`, `is_gst_required`, `warehouse_geo_tagged_status`, `distributor_status_code`, `distributor_status_name`, `gst_charged`, `is_generate_default_routes`, `is_active`, `created_at`, `updated_at`, `deleted_at`, `vendi_id`) VALUES
Sample:
Size: 329 MB
all raw:30,163,342
INSERT INTO `distributors` (`id`, `tenant_id`, `user_id`, `user_name`, `is_have_user`, `tier_id`, `tier_name`, `category_id`, `category_name`, `channel_name`, `distributor_status_id`, `tax_status_id`, `tax_status_name`, `channel_id`, `tax_status_code`, `name`, `opening_time`, `closing_time`, `address`, `second_address`, `ntn`, `exp_code`, `start_date`, `end_date`, `gst_reg_no`, `gst_reg_start_date`, `longitude`, `latitude`, `contact_name`, `contact_email`, `contact_phone_no`, `contact_cell_no`, `contact_cnic`, `contact_fax`, `is_base_town`, `outlet_geo_tagged_status`, `is_gst_required`, `warehouse_geo_tagged_status`, `distributor_status_code`, `distributor_status_name`, `gst_charged`, `is_generate_default_routes`, `is_active`, `created_at`, `updated_at`, `deleted_at`, `vendi_id`) VALUES
Quote:https://fex.net/ru/s/mveepfc
Sample:
(1, 1, 2599, 'Kamboh Traders Faisalabad', 1, 1, 'Bronze', 3, 'Consumer Pack', 'Traditional', 2, 2, NULL, 1, NULL, 'Kamboh Traders Faisalabad', '09:00', '17:00', 'Chak # 202, R Bhai Wala Phatak. Ghona Road FSD', 'Chak # 202, R Bhai Wala Phatak. Ghona Road FSD', 5661288, 'MSH000002', '2019-06-26', '2025-11-13', '5661288', NULL, '73.125694914449', '31.446527508989', 'Muhammad Khalid', '[email protected]', '073006356627777', '03007673862', '33100-9288749-1', 'aa', 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-02 07:23:00', NULL, 10),
(2, 1, NULL, NULL, NULL, NULL, NULL, 3, 'Consumer Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'H Y Traders Faisalabad', NULL, NULL, 'Afganabad Street # 06 Faisalabad', NULL, NULL, '10389', '2019-06-17', NULL, NULL, NULL, NULL, NULL, 'Muhammad Ali', '[email protected]', '0344-3004200', '0344-3004200', NULL, NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 11),
(3, 1, NULL, NULL, NULL, 2, 'Bronze', 1, 'Bulk Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Haji Imdad Traders Faisalabad', NULL, NULL, 'Gulfishan Colony Jhang Road Faisalabad', NULL, NULL, 'MSH000015', '2019-08-31', NULL, NULL, NULL, NULL, NULL, 'Mohsin Imdad Ali', '[email protected]', '412650467', '3017020350', NULL, NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 12),
(4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'Dummy Dis', NULL, NULL, 'Faisalabad', NULL, NULL, '52000', '2019-07-02', NULL, NULL, NULL, NULL, NULL, 'Dummy', '[email protected]', '041-1215121', '0300-061616', NULL, NULL, 0, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 14),
(5, 1, 2543, 'Shan Traders Faisalabad', 1, 1, 'Silver', 1, 'Bulk Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'Shan Traders Faisalabad', NULL, NULL, 'D-Type Colony,Main Bazar Faisalabad', NULL, NULL, 'MSH000005', '2019-08-31', '2021-12-10', NULL, NULL, NULL, NULL, 'Abu Bakar', '[email protected]', '0304-6653981', '3017122181', NULL, NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-12-20 02:12:53', NULL, 15),
(6, 1, 2617, 'Ilyas Traders Gujranwala', 1, 1, 'Bronze', 2, 'All Pack', 'Traditional', 2, 2, NULL, 1, NULL, 'Ilyas Traders Gujranwala', NULL, NULL, 'Gala Taal Wala, Moh Noor Bawa, St # 8 Gujranwala', NULL, 310350, 'FTA000013', '2019-06-30', NULL, NULL, NULL, NULL, NULL, 'M. Allyass', '[email protected]', '0320-6572007', '0320-6572007', '3410140621945', NULL, 0, 'open', 0, 'open', NULL, 'Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-17 09:36:17', NULL, 16),
(7, 1, NULL, NULL, NULL, 2, 'Silver', 2, 'All Pack', 'Traditional', 2, 2, NULL, 1, NULL, 'Ehsan Traders Gujranwala', NULL, NULL, 'Kangni Wala Bypass, Lateef Market Gujranwala', 'Kangni Wala Bypass, Lateef Market Gujranwala', NULL, 'FTA000015', '2019-07-02', NULL, NULL, NULL, NULL, NULL, 'Haroon Rasheed', '[email protected]', '3316461044', NULL, '34104-5596283-5', NULL, 0, 'open', 0, 'open', NULL, 'Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-06 05:37:15', NULL, 17),
(8, 1, NULL, NULL, NULL, 2, 'Bronze', 2, 'All Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Abdullah Traders Gujranwala', NULL, NULL, 'Saad Abdullah Kanda,Asad Colony, Sheikhu Pura Road Gujranwala', NULL, 5559808, 'FTA000014', '2019-07-02', NULL, '3280000000000', NULL, NULL, NULL, 'Ijaz Ahmad', '[email protected]', '0321-6456402', '0321-6456402', '34101-1792450-1', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 18),
(9, 1, 2625, 'Haq Bahoo Traders Sialkot', 1, 3, 'Gold', 2, 'All Pack', 'Traditional', 2, 2, NULL, 1, NULL, 'Haq Bahoo Traders Sialkot', NULL, NULL, 'Razi Yaqoob Road,Near Sanyarian Wala Pul,Sialkot', NULL, 2894368, 'DTR000035', '2019-06-30', NULL, '3280000000000', NULL, NULL, NULL, 'Shahzad Ahmad', '[email protected]', '0322-7376718', '0342-648005', '34603-7238961-9', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-02 07:29:16', NULL, 20),
(10, 1, NULL, NULL, NULL, 2, 'Bronze', 2, 'All Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'AB Traders Lahore', NULL, NULL, 'Main Wahdat Road Mustafa Town Lahore\n', 'Transfer from Bhatti to Ayyan on Date 20-05-2022', 3716805, 'DTR000350', '2019-10-04', NULL, '3716805', NULL, 'DTR000276', 'DTR000350', 'Qasim Mahmood Bhatti', '[email protected]', '0300-8044551', '0300-8044551', '35401-18293069', '-', 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 22),
(11, 1, NULL, NULL, NULL, NULL, NULL, 2, 'All Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'Butt Traders Lahore', NULL, NULL, 'Amin Park St 8 H# 18 Lahore', NULL, NULL, '10266', '2019-10-02', NULL, NULL, NULL, NULL, NULL, 'M Imran Butt', '[email protected]', '0322-7313125', '0322-7313125', '35200-5588066-9', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 23),
(12, 1, NULL, NULL, NULL, NULL, NULL, 2, 'All Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'Ibrahim Traders Lahore', NULL, NULL, 'Dars Road Near Carpet Factory Lahore Public School', NULL, NULL, 'FTA000021', '2019-10-01', NULL, NULL, NULL, NULL, NULL, 'M Rashid Khan', '[email protected]', '0331-2011260', '0331-2011260', '35201-1282143-1', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 24),
(13, 1, NULL, NULL, NULL, NULL, NULL, 2, 'All Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'S.Z Traders Lahore', NULL, NULL, 'Township Lahore', NULL, NULL, '10264', '2019-10-03', NULL, NULL, NULL, NULL, NULL, 'Imran Akram', '[email protected]', '3361102975', '3361102975', '35201-8800113-9', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 25),
(14, 1, NULL, NULL, NULL, 2, 'Bronze', 2, 'All Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'HA Traders Lahore', NULL, NULL, 'H#2A Main Canal Rd Mughal Pura', NULL, NULL, 'DTR000343', '2022-11-09', NULL, NULL, NULL, 'DTR000288', 'DTR000343', 'Usman Asif', '[email protected]', '0324-4731744', '0324-4731744', '35201-9763190-5', 'DTR000288', 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 26),
(15, 1, 2609, 'Azmat Traders Faisalabad', 1, NULL, NULL, 3, 'Consumer Pack', 'Traditional', 2, 2, NULL, 1, NULL, 'Azmat Traders Faisalabad', NULL, NULL, '200-D People\'s Colony 1 Khizra Masjid Road Faisalabad', '200-D People\'s Colony 1 Khizra Masjid Road Faisalabad', 7657615, 'MSH000017', '2019-08-21', NULL, '3280000000000', NULL, NULL, NULL, 'Tasleem Akhtar', '[email protected]', '3217171919', '3217171919', '33100-0603716-9', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-02 07:24:28', NULL, 27),
(16, 1, NULL, NULL, NULL, NULL, NULL, 3, 'Consumer Pack', 'Traditional', 2, 2, NULL, 1, NULL, 'Hyder & Company Faisalabad', NULL, NULL, 'Samundari Road Pull Korian Faisalabad', NULL, 3187144, 'MSH000013', '2019-08-23', NULL, '3280000000000', NULL, NULL, NULL, 'Jaleel Haider', '[email protected]', '3028663131', '3028663131', '33102-1807615-7', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-02 07:24:09', NULL, 28),
(17, 1, NULL, NULL, NULL, 1, 'Bronze', 3, 'Consumer Pack', 'Traditional', 2, 2, NULL, 1, NULL, 'M S Traders Faisalabad', NULL, NULL, 'Rehmania Town Rehmania Road Faisalabad', NULL, NULL, 'MSH000016', '2019-08-25', NULL, NULL, NULL, NULL, NULL, 'Mian Liaqat Ali', '[email protected]', '3167000200', '3167000200', '33102-1794920-9', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-02 07:23:56', NULL, 29),
(18, 1, 1340, 'A One Marketing Faisalabad', 1, 1, 'Bronze', 3, 'Consumer Pack', 'Traditional', 2, 2, NULL, 6, NULL, 'A One Marketing Faisalabad', NULL, NULL, 'New Civil Line Sargodha Road Faisalabad', 'New Civil Line Faisalabad', 5741543, 'MSH000048', '2019-08-27', NULL, '3330000000000', NULL, NULL, NULL, 'Muhammad Zeeshan Abdullah', '[email protected]', '041-8788740', '0300-7210740', '33303-1121949-5', NULL, 1, 'open', 0, 'open', NULL, 'Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2024-02-14 08:19:07', NULL, 30),
(19, 1, NULL, NULL, NULL, 2, 'Bronze', 1, 'Bulk Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Ashraf Brothers Faisalabad', NULL, NULL, 'Makhdoom Road,In front of Gate # 4,Ghalla Mandi Faisalabad', NULL, NULL, 'MSH000004', '2019-08-31', NULL, NULL, NULL, NULL, NULL, 'Tariq Mehmood', '[email protected]', '3336565435', '3328665369', NULL, NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 0, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 31),
(20, 1, NULL, NULL, NULL, NULL, NULL, 1, 'Bulk Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Asif Traders Faisalabad', NULL, NULL, 'Naseer Abad St # 5 Chibban Road', NULL, NULL, 'MSH000003', '2019-09-03', NULL, NULL, NULL, NULL, NULL, 'Rashid Ali', NULL, '3146380011', '3027000053', '33100-0757170-5', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 32),
(21, 1, NULL, NULL, NULL, 1, 'Silver', 1, 'Bulk Pack', 'Traditional', 1, 1, 'Un-Registered', 1, NULL, 'Rakha Traders Faisalabad', NULL, NULL, 'Hajweri Town,Millat Road Faisalabad', NULL, NULL, 'MSH000018', '2019-09-02', NULL, NULL, NULL, NULL, NULL, 'Ahsaan Ellahi', NULL, '3216635239', '3216672012', NULL, NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 33),
(22, 1, NULL, NULL, NULL, 3, 'Diamond', 1, 'Bulk Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Ibtsaam Traders Faisalabad', NULL, NULL, 'Yakta Market Haji Abad Sheikhu Pura Road Faisalabad', NULL, NULL, 'MSH000009', '2019-09-02', NULL, NULL, NULL, NULL, NULL, 'Haji Irshad Ul Haq', '[email protected]', '3336563532', '3336563532', '33100-0626009-5', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 34),
(23, 1, NULL, NULL, NULL, NULL, NULL, 1, 'Bulk Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Abbass Traders Faisalabad', NULL, NULL, 'Taj Colony Millat Road Faisalabad', NULL, NULL, 'MSH000020', '2019-09-03', NULL, NULL, NULL, NULL, NULL, 'Abdul Rasheed', '[email protected]', '3007298098', '3007298098', '33100-0962949-3', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 35),
(24, 1, NULL, NULL, NULL, 3, 'Diamond', 1, 'Bulk Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Al Rafay Traders Faisalabad', NULL, NULL, 'Redex Road,St # 8,Nisar Colony Faisalabad', NULL, NULL, 'MSH000041', '2019-09-03', NULL, NULL, NULL, NULL, NULL, 'Muhammad Younas', '[email protected]', '3087690900', '3336535780', '33100-1009590-9', NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 36),
(25, 1, NULL, NULL, NULL, NULL, NULL, 1, 'Bulk Pack', 'Traditional', 1, 2, 'Registered', 1, NULL, 'Alvi Traders Faisalabad', NULL, NULL, 'Haidri Chowk,Madina Town Faisalabad', NULL, NULL, 'MSH000006', '2019-09-05', NULL, NULL, NULL, NULL, NULL, 'Amaad Alvi', '[email protected]', '[email protected]', NULL, NULL, NULL, 1, 'open', 0, 'open', NULL, 'Non-Implemented', 0, 0, 1, '2023-10-30 20:50:10', '2023-10-30 20:50:10', NULL, 37),