
-- --------------------------------------------------------

--
-- Table structure for table `buy_products`
--

CREATE TABLE `buy_products` (
  `id` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `material` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `vessel` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `grade` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `gcv_as_per_report` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `available_at` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `city` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `state` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `total_payable_amount` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `minimum_quantity` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `price_per_mt` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `payment_terms` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tcs_if_applicable` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `basic_amount` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `gst` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cess` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tcs_amount` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `select_emd` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `emd_amount` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `token` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `full_payment_amount` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `received_from` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `first_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `last_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `phone_number` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `gst_number` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `company` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `buy_products`
--

INSERT INTO `buy_products` (`id`, `deleted_at`, `created_at`, `updated_at`, `material`, `vessel`, `grade`, `gcv_as_per_report`, `available_at`, `city`, `state`, `total_payable_amount`, `minimum_quantity`, `price_per_mt`, `payment_terms`, `tcs_if_applicable`, `basic_amount`, `gst`, `cess`, `tcs_amount`, `select_emd`, `emd_amount`, `token`, `full_payment_amount`, `received_from`, `first_name`, `last_name`, `phone_number`, `email`, `gst_number`, `company`, `user_status`) VALUES
(20, NULL, '2023-03-25 06:43:32', '2023-03-25 06:43:32', 'Usa Thermal Coal', 'MV LORDSHIP ', 'USA High GCV Coal Grade-A (6800 - 7100 NAR )', '7326', 'Ex Tuna Port, Gandhidham, Guja', '', '', '', '800', '17800', '', '', '', 'nogst', '', '', '', '', '', '', 'counter_offer_save', 'RANJET', 'SINGH', '7986515358', 'ranjeet.passproviders@gmail.com', '', 'PPP', 'Notlogin'),
(21, NULL, '2023-03-25 06:53:45', '2023-03-25 06:53:45', 'Usa Thermal Coal', 'MV LORDSHIP ', 'USA High GCV Coal Grade-A (6800 - 7100 NAR )', '7326', 'Ex Tuna Port, Gandhidham, Guja', '', '', '14109700', '800', '16650', '', 'YES', '13000000', '650000', '320000', '139700', '100%', '14109700', '', '', 'Buy_material_withoutlogin', 'ranjeet', 'singh', '7986515358', 'ranjeet.passproviders@gmail.com', '', 'joasjfis', 'Login'),
(22, NULL, '2023-03-25 06:56:50', '2023-03-25 06:56:50', 'Usa Thermal Coal', 'MV TRUE COURAGE', 'USA High GCV Coal Grade-A (6800 - 7100 NAR )', '6010', 'Ex Tuna Port, Gandhidham, Guja', '', '', '', '800', '19800', '', '', '', 'null', '', '', '', '', '', '', 'counter_offer_save', 'ranjeet', 'singh', '7986515358', 'ranjeet.passproviders@gmail.com', '', 'ergrg', 'Login'),
(23, NULL, '2023-03-28 08:27:34', '2023-03-28 08:27:34', 'Usa Thermal Coal', 'MV LORDSHIP ', 'USA High GCV Coal Grade-A (6800 - 7100 NAR )', '7326', 'Ex Tuna Port, Gandhidham, Guja', '', '', '26455687.5', '1500', '16650', '', 'YES', '24375000', '1218750', '600000', '261937.5', '100%', '26455687.5', '', '', 'Buy_material_withoutlogin', 'RANJEET', 'SINGH', '7986515358', 'ranjeet.passproviders@gmail.com', '', 'IOP', 'Login'),
(24, NULL, '2023-03-28 08:47:50', '2023-03-28 08:47:50', 'Usa Thermal Coal', 'MV LORDSHIP ', 'USA High GCV Coal Grade-A (6800 - 7100 NAR )', '7326', 'Ex Tuna Port, Gandhidham, Guja', '', '', '', '500', '16500', '', '', '', 'null', '', '', '', '', '', '', 'counter_offer_save', 'RANJEET', 'SINGH', '7986515358', 'ranjeet.passproviders@gmail.com', '', 'ranjeet.passp', 'Login'),
(25, NULL, '2023-03-29 06:57:18', '2023-03-29 06:57:18', 'Usa Thermal Coal', 'MV THALASSINI NIKI', 'USA High GCV Coal Grade-A (6800 - 7100 NAR )', '7144', 'Ex Tuna Port, Gandhidham, Guja', '', '', '13430980', '800', '15850', '', 'YES', '12360000', '618000', '320000', '132980', '10%', '1343098', '', '', 'Buy_material_withoutlogin', 'VISHWAS ', 'ARORA', '9592607080', 'mr.vishalnarang@gmail.com', '03AAWFP9900G1ZY', 'PP', 'Login'),
(26, NULL, '2023-03-29 07:04:02', '2023-03-29 07:04:02', 'Usa Thermal Coal', 'MV DENSA SHARK', 'USA High GCV Coal Grade-A (6800 - 7100 NAR )', '7213', 'Ex Tuna Port, Gandhidham, Guja', '', '', '', '8500', '19800', '', '', '', '03AAWFP9900G1ZY', '', '', '', '', '', '', 'counter_offer_save', 'VISHWAS ', 'ARORA', '9592607080', 'mr.vishalnarang@gmail.com', '', 'PP', 'Login');
