-- Tender Management System Database Export
-- Generated on: 2025-09-28 13:58:01
-- Laravel Version: 12.31.1

SET FOREIGN_KEY_CHECKS = 0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

-- Table structure for table `migrations`
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `migration` VARCHAR NOT NULL,
  `batch` INT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `migrations`
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_09_26_201551_add_role_to_users_table', 1),
(5, '2025_09_26_201614_create_categories_table', 1),
(6, '2025_09_26_201623_create_subcategories_table', 1),
(7, '2025_09_26_201630_create_products_table', 1),
(8, '2025_09_26_201638_create_product_audits_table', 1),
(9, '2025_09_26_201647_create_user_activity_logs_table', 1),
(10, '2025_09_26_210415_make_product_fields_nullable', 2),
(11, '2025_09_26_211413_add_measurement_unit_to_products_table', 3),
(12, '2025_09_26_221101_create_tenders_table', 4),
(13, '2025_09_26_221110_create_tender_products_table', 4),
(14, '2025_09_27_072927_create_product_merges_table', 5),
(15, '2025_09_27_094532_add_pricing_percentages_to_tenders_table', 6),
(16, '2025_09_27_094543_add_three_tier_pricing_to_tender_products_table', 6),
(17, '2025_09_27_104446_create_tender_bids_table', 7),
(18, '2025_09_27_110906_add_tender_timeline_and_bidding_companies_to_tenders_table', 8),
(19, '2025_09_27_194615_add_active_tender_fields_to_tenders_table', 9),
(20, '2025_09_27_200642_create_document_types_table', 10),
(21, '2025_09_27_200656_create_tender_document_requirements_table', 10),
(25, '2025_09_27_200716_create_tender_document_requirements_table', 11),
(26, '2025_09_27_200740_create_tender_document_submissions_table', 12),
(29, '2025_09_27_201430_migrate_existing_tender_documents_to_dynamic_system', 13),
(30, '2025_09_27_220005_update_user_roles_enum', 14),
(31, '2025_09_27_220707_add_soft_deletes_to_users_table', 14),
(32, '2025_09_28_063129_create_incomes_table', 15),
(33, '2025_09_28_063140_create_expenses_table', 15),
(34, '2025_09_28_063153_create_investments_table', 15);

-- Table structure for table `password_reset_tokens`
DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
  `email` VARCHAR,
  `token` VARCHAR NOT NULL,
  `created_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `sessions`
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` VARCHAR,
  `user_id` INT NULL,
  `ip_address` VARCHAR NULL,
  `user_agent` TEXT NULL,
  `payload` TEXT NOT NULL,
  `last_activity` INT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `sessions`
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('3ssqA95jpBN6IoGgdlzDKycKcEKqfyWfvhtRWh7D', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYjRqTm9QSHYzUHczd0xjQ1c3S1B2MDVSbWdaeU4zSjVzYXk1SnpJZyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMwOiJodHRwOi8vMTI3LjAuMC4xOjgwMDEvcHJvZHVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1759067513),
('kc8vPjmfDEmjIAP4W2X249aEuurKzQ64f57PdxyW', NULL, '127.0.0.1', 'curl/8.11.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQkh2MGYzYjNoMTNaMVRnSkFCUlBmNXJiV1I2eXNLdHdWSGU4Yzh6NSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759060732),
('OwGEjl07kDqU9SpV3DXVHB6jmPZfCnDT2fBF36WG', NULL, '127.0.0.1', 'curl/8.11.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWmJycUVHUnFkVTRaOVhsMG1wbUtWQU1FS3F3eU9HRFpndXVkSWZIYSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759061082),
('RvxKMDy6z31iNOGE29r1fuxLEbkvzbw8fGJLiJ6w', NULL, '127.0.0.1', 'curl/8.11.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicnFrSENkWEVheUJ6QkFNT3ZpbmYxTFI3UXpLWFJwVWR3bHZJSFVDUCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759061445),
('mR7lBBtCDFeGC4lBlhCeBGvNA1xwFdAJFKRAIehV', NULL, '127.0.0.1', 'curl/8.11.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTE1hSk9ONnREVmRWQ2RreTBIcW5pcTlFUnJ2UzY5SWVQb1ZaTjlaSCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759061559),
('hDw7cl2KL6kRS3PMYWOHkn3RvaaP7ukW9C0ys2pL', NULL, '127.0.0.1', 'curl/8.11.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRlRxWHlDRmlMSFdSRUJsbVN5c0diWlJMVmJwTGw1cEtVV3BaTnhZMCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759065323),
('CxzKDf02PXxxpu3t7C8UKRiorERoJn5h0SPRdw9i', NULL, '127.0.0.1', 'curl/8.11.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRW1sWVNCOW1DdFNGZjFMSW5NSW9IYmxtdnFub1BUTHRtQVRVdW1ubiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1759065391),
('YLnkc5SryWgJIWIWuyydOpKAfAFkWXkgeVqLUa63', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSXNlaTMzdnJITmhseE5hdEVsNFJFdE5vNk1IUTc3SGh6dXpsRkJEbyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM4OiJodHRwOi8vMTI3LjAuMC4xOjgwMDEvdGVuZGVycy83P3BhZ2U9MiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1759067036),
('zj2Va3ItE3nErOkL4Z7H5Ci9iiGcNBtU3EYTs4co', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZm8zYmhkdjlqTllEUW1ONloyYmwxc2NuMXJhU1FSeWlrZXlVS25CeCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMwOiJodHRwOi8vbG9jYWxob3N0OjgwMDEvcHJvZHVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1759066600);

-- Table structure for table `cache`
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` VARCHAR,
  `value` TEXT NOT NULL,
  `expiration` INT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `cache_locks`
DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` VARCHAR,
  `owner` VARCHAR NOT NULL,
  `expiration` INT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `jobs`
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `queue` VARCHAR NOT NULL,
  `payload` TEXT NOT NULL,
  `attempts` INT NOT NULL,
  `reserved_at` INT NULL,
  `available_at` INT NOT NULL,
  `created_at` INT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `job_batches`
DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE `job_batches` (
  `id` VARCHAR,
  `name` VARCHAR NOT NULL,
  `total_jobs` INT NOT NULL,
  `pending_jobs` INT NOT NULL,
  `failed_jobs` INT NOT NULL,
  `failed_job_ids` TEXT NOT NULL,
  `options` TEXT NULL,
  `cancelled_at` INT NULL,
  `created_at` INT NOT NULL,
  `finished_at` INT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `failed_jobs`
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `uuid` VARCHAR NOT NULL,
  `connection` TEXT NOT NULL,
  `queue` TEXT NOT NULL,
  `payload` TEXT NOT NULL,
  `exception` TEXT NOT NULL,
  `failed_at` TEXT NOT NULL DEFAULT 'CURRENT_TIMESTAMP'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `categories`
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `categories`
INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'MSR Medicine Non-EDCL', '2025-09-26 20:49:47', '2025-09-26 20:49:47'),
(2, 'MSR Medical Instruments', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(3, 'MSR Linen', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(4, 'MSR Gauze Bandage & Absorbent Cotton', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(5, 'MSR Furniture', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(6, 'Cleaning', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(7, 'OCC & Others', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(8, 'Linen Washing', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(9, 'Re-Agent', '2025-09-26 20:49:48', '2025-09-26 20:49:48'),
(10, 'Electronics', '2025-09-27 07:41:58', '2025-09-27 07:41:58');

-- Table structure for table `subcategories`
DROP TABLE IF EXISTS `subcategories`;
CREATE TABLE `subcategories` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR NOT NULL,
  `category_id` INT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `subcategories`
INSERT INTO `subcategories` (`id`, `name`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 'Mobile Phones', 10, '2025-09-27 07:41:58', '2025-09-27 07:41:58');

-- Table structure for table `product_audits`
DROP TABLE IF EXISTS `product_audits`;
CREATE TABLE `product_audits` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `product_id` INT NOT NULL,
  `user_id` INT NOT NULL,
  `action` VARCHAR NOT NULL,
  `field_changes` TEXT NOT NULL,
  `reason` TEXT NULL,
  `ip_address` VARCHAR NULL,
  `user_agent` TEXT NULL,
  `created_at` TEXT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `user_activity_logs`
DROP TABLE IF EXISTS `user_activity_logs`;
CREATE TABLE `user_activity_logs` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `user_id` INT NOT NULL,
  `action` VARCHAR NOT NULL,
  `table_name` VARCHAR NOT NULL,
  `record_id` INT NULL,
  `details` TEXT NULL,
  `ip_address` VARCHAR NULL,
  `created_at` TEXT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `products`
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR NOT NULL,
  `country_of_origin` VARCHAR NULL,
  `description` TEXT NULL,
  `category_id` INT NULL,
  `subcategory_id` INT NULL,
  `price` TEXT NULL,
  `version` INT NOT NULL DEFAULT ''1'',
  `created_by` INT NOT NULL,
  `updated_by` INT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL,
  `deleted_at` TEXT NULL,
  `measurement_unit` VARCHAR NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `products`
INSERT INTO `products` (`id`, `name`, `country_of_origin`, `description`, `category_id`, `subcategory_id`, `price`, `version`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`, `measurement_unit`) VALUES
(1, 'Test Product - Step by Step', NULL, NULL, NULL, NULL, NULL, 1, 1, 1, '2025-09-26 21:11:09', '2025-09-27 07:42:34', '2025-09-27 07:42:34', NULL),
(2, 'Partially Complete Product', 'USA', NULL, 1, NULL, NULL, 1, 1, 1, '2025-09-26 21:11:21', '2025-09-27 07:42:34', '2025-09-27 07:42:34', NULL),
(3, 'Complete Product', 'Canada', 'This is a complete product with all details.', 1, NULL, 29.99, 1, 1, 1, '2025-09-26 21:11:33', '2025-09-27 07:42:34', '2025-09-27 07:42:34', NULL),
(4, 'Test Product with Measurement Unit', 'USA', 'Complete product with measurement unit', 1, NULL, 39.99, 1, 1, 1, '2025-09-26 21:21:36', '2025-09-26 21:21:36', NULL, 'kg'),
(5, 'Test Measurement Unit Product', NULL, NULL, NULL, NULL, NULL, 1, 1, 1, '2025-09-26 21:23:00', '2025-09-26 21:23:00', NULL, 'pieces'),
(6, 'Test Simple Import Product', NULL, NULL, NULL, NULL, NULL, 1, 1, 1, '2025-09-26 21:37:47', '2025-09-26 21:37:47', NULL, NULL),
(7, 'Atraumatic chromic catgut round body, No- 1', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:09', '2025-09-26 21:43:09', NULL, NULL),
(8, 'Atraumatic chromic catgut round body, No- 1/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(9, 'Atraumatic chromic catgut round body, No- 2/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(10, 'Atraumatic chromic catgut round body, No- 3/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(11, 'Atraumatic Silk catgut cutting body, No- 1', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(12, 'Atraumatic Silk catgut round body, No- 1/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(13, 'Atraumatic Silk catgut cutting body, No- 2/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(14, 'Atraumatic Vicryl 3/8 circle round body , No- 1/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(15, 'Atraumatic Vicryl 3/8 circle Cutting body , No- 2/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:10', '2025-09-26 21:43:10', NULL, NULL),
(16, 'Atraumatic Vicryl 3/8 circle round body , No- 4/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:11', '2025-09-26 21:43:11', NULL, NULL),
(17, 'Atraumatic Vicryl 3/8 circle cutting body , No- 3/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:11', '2025-09-26 21:43:11', NULL, NULL),
(18, 'Atraumatic proline (round body) no-1', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:11', '2025-09-26 21:43:11', NULL, NULL),
(19, 'Atraumatic proline (round body) no-1/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:11', '2025-09-26 21:43:11', NULL, NULL),
(20, 'Atraumatic proline (cutting body) no-2/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:11', '2025-09-26 21:43:11', NULL, NULL),
(21, 'Atraumatic proline (cutting body) no-3/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:11', '2025-09-26 21:43:11', NULL, NULL),
(22, 'Atraumatic proline (cutting body) no-4/0', 'Dozon', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:11', '2025-09-26 21:43:11', NULL, NULL),
(23, 'Boyel Davis Mouth Gag Std. Size', 'Nos', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(24, 'B.P Machine ALPK-2', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(25, 'B.P Blade sterile (Size 12/15/20/22//24/11)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(26, 'Blood Set Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(27, 'Bandage cutting Scissor Std. Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(28, 'Cannula I.V 18G', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(29, 'Cannula I.V 20G', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(30, 'Cannula I.V 22G', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:12', '2025-09-26 21:43:12', NULL, NULL),
(31, 'Cannula I.V 24G', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(32, 'Catheter Foley\'s 2 way No: 14', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(33, 'Cord clam', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(34, 'Circuit Adult Std. Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(35, 'Circuit Child (Child)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(36, 'Diamond bar( Round, Fissure, inverted) Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(37, 'Disposable plastic syringe with needle(3ml)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(38, 'Disposable plastic syringe with needle(5ml)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:13', '2025-09-26 21:43:13', NULL, NULL),
(39, 'Disposable plastic syringe with needle(10ml)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(40, 'Disposable plastic syringe with needle(20ml)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(41, 'Delivery Set Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(42, 'Emergency charger Light Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(43, 'Endotracheal Tube (Size-5,5.5,6,6.5,7,7.5)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(44, 'Forcep Artery (Medium) 6\'\'', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(45, 'Feeding Tube (5G+6G)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(46, 'Gloves (Surgical rubber hand) sterile, size- 6/6.5/7/7.5', 'Pair', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(47, 'Glucometer (Best Quality)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:14', '2025-09-26 21:43:14', NULL, NULL),
(48, 'Hand Piece (Best Quality)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(49, 'Insuline Syringe, Std.Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(50, 'Luc\'s Forcefs, Std.Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(51, 'Liftere jar, Std.Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(52, 'Mosquito forcef', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(53, 'Micro Bunet Set, Std.Size', 'Set', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(54, 'Nebulizer Machine, Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(55, 'Nebulizer Mask, JPD-500D, Jumper', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:15', '2025-09-26 21:43:15', NULL, NULL),
(56, 'Needle Holder straight S.S (Hilbro or equivalent) 6\'\',8\'\'', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(57, 'Needle (Various Size)', 'Box', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(58, 'Rubber Chatether 16-18', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(59, 'Refrigerator,10 CFT Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(60, 'Spinal needle with Indroducer (Pencil Point)- 0.50X 90 mm, Must be CE Marked (B.Barun or Equivalent) No.25', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(61, 'Stethoscope, Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(62, 'Sucker Machine (Electrical), Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(63, 'Scissor 10\'\'', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:16', '2025-09-26 21:43:16', NULL, NULL),
(64, 'Scissor 6\'\'', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(65, 'Spot Light, Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(66, 'Saline Set, Std. Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(67, 'Slide Wrench 12\'\'', 'piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(68, 'Towel clip, Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(69, 'Tourch Light( big size),', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(70, 'Tissue Forcefs, Std. Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(71, 'Tooth Forcefs, Std. Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(72, 'Thermometer, Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:17', '2025-09-26 21:43:17', NULL, NULL),
(73, 'Urine collecting bag (Various size)', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(74, 'Weight Machine (Baby) , Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(75, 'Weight Machine (Neonatal), Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(76, 'X-ray View Box, Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(77, 'EDTA Tube , 1000/Pack', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(78, 'ESR Tube, Std. Size', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(79, 'Blood Bag, Best Quality', 'Piece', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(80, 'Cover Slip, 18*18', 'Box', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:43:18', '2025-09-26 21:43:18', NULL, NULL),
(81, 'of Item\"', 'Measurement Unit', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:56', '2025-09-26 21:50:56', NULL, NULL),
(82, 'নেবুলাইজার মেশিন', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:56', '2025-09-26 21:50:56', NULL, NULL),
(83, 'সিজার ফাইন(র্কাভ ) ৬', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:56', '2025-09-26 21:50:56', NULL, NULL),
(84, 'সিজার ফাইন (স্ট্রইেট) ৬?', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:56', '2025-09-26 21:50:56', NULL, NULL),
(85, 'ষ্টিচ কাটিং সিজার ৪?', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:56', '2025-09-26 21:50:56', NULL, NULL),
(86, 'টুথ ফরসেফ ৬?', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(87, 'বিপি বদ্বেড ২০/২২ সাইজ', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(88, 'র্আটারি ফরসপে ৪?', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(89, 'র্আটারি ফরসপে ৬?', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(90, 'নিডেল হোল্ডার ৬?', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(91, 'নিডেল হোল্ডার ৯?', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(92, 'নেজোগ্যাসট্রকি টউিব ১৮সাইজ', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(93, 'প্লাস্টার কাটিং স', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(94, 'বিপি মশেনি এনরেয়ডে ( এনালগ)', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:57', '2025-09-26 21:50:57', NULL, NULL),
(95, 'ষ্টেথোস্কোপ ? এডাল্ট', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(96, 'ক্যাট গাট এট্রামটেকি নং ১/০', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(97, 'ক্যাট গাট এট্রামেটিক নং ২/০', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(98, 'ক্যাট গাট এট্রামেটিক নং ৩/০', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(99, 'প্রোলিন নং ১/০ কাটিং বডি নিডেল সহ', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(100, 'প্রোলিন নং ৩/০ কাটিং বডি নিডেল সহ', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(101, 'ভিক্রিল নং ২/০ কাটিং বডি নিডেল সহ', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(102, 'ডেক্সান ১/০ কাটিং বডি নিডেল সহ', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:58', '2025-09-26 21:50:58', NULL, NULL),
(103, 'এট্রামটেকি সল্কি নং', NULL, NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(104, '১ কাটিং বডি নিডেল সহ\"', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(105, 'এট্রামটেকি সল্কি নং', NULL, NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(106, '১/০ কাটিং বডি নিডেল সহ\"', 'P/doz', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(107, 'গ্লাবস (র্সজক্যিাল রাবার হ্যান্ড) ননস্টরোইল৬.৫/৭ সাইজ', 'P/pair', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(108, 'গ্লাবস (র্সজক্যিাল রাবার হ্যান্ড) স্টরোইল৬.৫/৭ সাইজ', 'P/pair', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(109, 'ফলিস ক্যাথটোর টু ওয়ে ১৬ সাইজ', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(110, 'ফলিস ক্যাথটোর টু ওয়ে ১৮ সাইজ', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(111, 'ইউরিন কালেকটিং ব্যাগ', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:50:59', '2025-09-26 21:50:59', NULL, NULL),
(112, 'আই ভি ক্যানুলা সাইজ 20', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:51:00', '2025-09-26 21:51:00', NULL, NULL),
(113, 'আই ভি ক্যানুলা সাইজ ২৪', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:51:00', '2025-09-26 21:51:00', NULL, NULL),
(114, 'ডিসপোজেবল সিরিঞ্জি ৩ সিসি', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:51:00', '2025-09-26 21:51:00', NULL, NULL),
(115, 'ডিসপোজেবল সিরিঞ্জ ৫ সিসি', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:51:00', '2025-09-26 21:51:00', NULL, NULL),
(116, 'ডিসপোজেবল সিরিঞ্জ ১০ সিসি', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:51:00', '2025-09-26 21:51:00', NULL, NULL),
(117, 'ডিসপোজেবল সিরিঞ্জ ২০ সিসি', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:51:00', '2025-09-26 21:51:00', NULL, NULL),
(118, 'ওয়টে মেশিন', 'P/pcs', NULL, 2, NULL, NULL, 1, 1, 1, '2025-09-26 21:51:00', '2025-09-26 21:51:00', NULL, NULL),
(119, 'Iron Cot (Special Type)', '', 'Measurement-Length:- 84\'\', Breadth:-37\'\', Height: 36-37\'\'; Head side and front side should be made of S.S tube; Haisa should be made of MS Angle with 2\'\' X 2\'\'X2\'\' tube; Bed should be made of 3/4 \'\' X 3/4\'\' X 20 G Square base pipe and to be fitted at a distance of 3\'\' from one pipe to another, Bed should be painted by Electro static powder. Minimum 03 Years warranty and After sales service.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:37', '2025-09-27 07:21:37', NULL, 'Piece'),
(120, 'Bed side locker:', '', 'S.S 30\'\'x18\'\'x18\'\', Frame should be made of 3/4 S.S non magnetic tube-4 (four) legs. Total height 32\'\' with riling; One lower cabinet size H-18\'\' x 218\'\' Depth with of 18\'\' with handle lock; Top cover & side cover to be made by S.S sheet 22 SWG SS shee (Cabinet door to be made by 20 SWG S.S sheet 3 (three side railings and front handle to be made by 1/2 S.S tube two level; Minimum 03 Years warranty and After sales service.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:37', '2025-09-27 07:21:37', NULL, 'Piece'),
(121, 'Chair for Doctor & Nurses:', '', 'Frame should of made by M.S tube of 19mm with arm total height 32cm grand to sent 40cm straight back, Seat made by best quality foam with synthetic leather cover thickness 6 cm. Seat size 41 cm x 41cm; Back by best quality 5cm foam & synthetic leather cover on M.S sheet 18 SWG. Rubber cap at the bottom of the eas Minimum 18 months warranty and After sales service.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:37', '2025-09-27 07:21:37', NULL, 'Piece'),
(122, 'Guest Chair Steel', '', 'Chair frame by M.S tube 10mm- Total height 82cm ground to sent height 40cm seat size-41 x 41 cm seat & back by best quality foam with synthetic leather cover thickness 6 cm, rubber cap at the bottom of the legs, Minimum 18 months warranty and After sales service.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:37', '2025-09-27 07:21:37', NULL, 'Piece'),
(123, '4 Drawer steel file cabinet:', '', 'Measurement: Height: 54\'\', Width: 24\'\', Depth: 19\'\' Made of high grade cold rolled steel sheet of 18 SWG thickness reinforced with stiffeners equipped with castors made high strength drawer channels, nylon drawer gnp and imported central locking system. Roller with solid steel bearing for, smooth operation of drawers. All steel parts chemically-de-rusted, zinc phosphate coated stowing paint finished and cured in oven at 150°-200° C; Minimum 02 Years warranty and After sales service.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, 'Piece'),
(124, 'Food Trolley (S.S) 9 With big wheel:', '', 'Length:- 3 feet. Width:- 20\'\'; Height:- feet including the wheel, (18/20)kg Wheel must be of good quality; Minimum 18 months warranty and After sales service of complete set.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, 'Piece'),
(125, 'Special Tray to carry food:', '', 'Size: H-6\'\'; Wide-17\'\'; Length-24\'\'; Handle 2 way, ss (18/20 SWG), with lid: Minimum 02 Years warranty and After sales service.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, 'Piece'),
(126, 'Steel Almirah', '', 'Length: -190 cm Width: -100 cm Depth: 50 cm 18 kg High quality rolled sheet will be used on the top, bottom, two sides and back; shelves and locks. The shelves inside the cupboard will be 20 kg. There will be five shelves at equal distances. The lid should have a handle lock. The door should have a domestic lock. Paint: Spray paint should be done in a good way. Minimum 02 Years warranty and After sales service.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, 'Piece'),
(127, 'Patient carrying trolley', '', 'Size: 78 × 23 cm in height: 33 Wheel', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, 'Piece'),
(128, 'Steel bowl', '', 'Dia 6\'\'; Height 1.5\'\'.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, 'Piece'),
(129, 'Note: Sample must be submitted.\"', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, NULL),
(130, 'Aluminum desk (large size)', '', 'Dia:- 30\'\'; Height:- 22\'\'.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:38', '2025-09-27 07:21:38', NULL, 'Piece'),
(131, 'Pata puta', '', 'Big size (made of stone)', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, 'Piece'),
(132, 'Wok', '', 'Std size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, 'Piece'),
(133, 'Wok With Handle', '', 'Std size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, 'Piece'),
(134, 'Aluminum saucepan (with lid)', '', 'Size: Dia 22.5\'\' Height: 10.5\'\'.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, 'Kg'),
(135, 'Note: Sample must be submitted.\"', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, NULL),
(136, 'Attendant Tool', '', 'Plastic. Standard Size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, 'Piece'),
(137, 'Gamla', '', 'Stainless Steel-standard size.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, 'Piece'),
(138, 'Note: Sample must be submitted.\"', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:39', '2025-09-27 07:21:39', NULL, NULL),
(139, 'Dust Dram Carry Trolley', '', 'The base height will be 30\'\', length will be 32\'\', width will be 30\'\'. The entire frame will be made of 1.5\'\' X 1.5\'\'4 mm MS angle and the top sheet will be MS 18 kg sheet. The height of the sheet from the floor will be 12\'\' and the top frame from the shaft will be 18\'\'. Four high quality 6\'\' wheels. Two handles .It will be ss Soya one pipe.Minimum 02 years warranty and After sales service', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(140, 'Three-seat patient chair', '', 'The frame of the three-seat waiting chair will be made entirely of SS pipe. 1.-54\'\', W-Total 18\'\', H-24\'\', the shear pipe will be SS one and a half dia, 1.5 mm the middle pulls will be 3/4\'\' dia ss pipe.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(141, 'Instrument Cabinet', '', 'Standard (Std) size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(142, 'Instrument Trolley', '', 'Std size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(143, 'Dressing trolley', '', 'Std size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(144, 'Medicine Trolley with wheel SS', '', 'Std size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(145, 'Labour Table', '', 'Fixed Still', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(146, 'Bed side stand 3 parts with screen (Metallic)', '', 'Std. size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(147, 'Patient Examination Table with Foam & rexin cover', '', 'Std. size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:40', '2025-09-27 07:21:40', NULL, 'Piece'),
(148, 'Wheel chair (steel)', '', 'Std. size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:41', '2025-09-27 07:21:41', NULL, 'Piece'),
(149, 'Da (iron)', '', 'Std. size', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:41', '2025-09-27 07:21:41', NULL, 'Piece'),
(150, 'Bucket (Plastic)', '', '30 liter capacity', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:41', '2025-09-27 07:21:41', NULL, 'Piece'),
(151, 'Saline stand (ss)', '', 'Std size.', 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:41', '2025-09-27 07:21:41', NULL, 'Piece'),
(152, 'Note: Sample must be submitted.\"', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:21:41', '2025-09-27 07:21:41', NULL, NULL),
(153, 'Description', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:24:20', '2025-09-27 07:24:20', NULL, NULL),
(154, 'Patient Bed', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:24:21', '2025-09-27 07:24:21', NULL, NULL),
(155, 'রোগী বহন করার ট্র্রলী', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:24:21', '2025-09-27 07:24:21', NULL, NULL),
(156, 'Instrument Troly', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:24:21', '2025-09-27 07:24:21', NULL, NULL),
(157, 'Medicine Troly', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:24:21', '2025-09-27 07:24:21', NULL, NULL),
(158, 'Gumla Plastic', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:24:21', '2025-09-27 07:24:21', NULL, NULL),
(159, 'Bucket Plastic', NULL, NULL, 5, NULL, NULL, 1, 1, 1, '2025-09-27 07:24:21', '2025-09-27 07:24:21', NULL, NULL),
(160, 'iPhone 13 Pro', 'USA', 'Apple iPhone 13 Pro with 128GB storage', 10, 1, 120000, 1, 1, 1, '2025-09-27 07:41:58', '2025-09-27 07:41:58', NULL, 'piece'),
(161, 'iPhone 13 Pro Max', 'USA', 'Apple iPhone 13 Pro Max with 256GB storage', 10, 1, 135000, 1, 1, 1, '2025-09-27 07:41:58', '2025-09-27 07:41:58', NULL, 'piece'),
(162, 'iPhone 13', 'USA', 'Apple iPhone 13 with 128GB storage', 10, 1, 95000, 1, 1, 1, '2025-09-27 07:41:58', '2025-09-27 07:41:58', NULL, 'piece'),
(163, 'Samsung Galaxy S22', 'South Korea', 'Samsung Galaxy S22 with 128GB storage', 10, 1, 85000, 1, 1, 1, '2025-09-27 07:41:59', '2025-09-27 07:41:59', NULL, 'piece'),
(164, 'Samsung Galaxy S22 Ultra', 'South Korea', 'Samsung Galaxy S22 Ultra with 256GB storage', 10, 1, 125000, 1, 1, 1, '2025-09-27 07:41:59', '2025-09-27 07:41:59', NULL, 'piece'),
(165, 'Merged Product Test', NULL, 'Merged product from: Test Product - Step by Step, Partially Complete Product, Complete Product', NULL, NULL, 29.99, 1, 1, 1, '2025-09-27 07:42:34', '2025-09-27 07:42:34', NULL, NULL),
(166, '1GG/1GM Dengue (laa)', '', 'Per Piece', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:00', '2025-09-28 13:36:00', NULL, ''),
(167, '5% Acetic Acid (Glacial) 500 ml bottle', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:01', '2025-09-28 13:36:01', NULL, ''),
(168, 'Albumin', '', 'Pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:01', '2025-09-28 13:36:01', NULL, ''),
(169, 'Acetic Acid Glacial (500ml Bottle)', '', '(500ml Bottle)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:01', '2025-09-28 13:36:01', NULL, ''),
(170, 'Anti HCV (device WB/S/P) 30 test', '', '(device WB/S/P) 30 test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:01', '2025-09-28 13:36:01', NULL, ''),
(171, 'Anti-septic Solution (Hand scrub) 250 ml/bott', '', '250 ml/bott', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:01', '2025-09-28 13:36:01', NULL, ''),
(172, 'ASO (complete test kit) 100test', '', '100test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:01', '2025-09-28 13:36:01', NULL, ''),
(173, 'ASO titre kit (50 test pac)', '', 'pac', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(174, 'AST for Auto Analyzer R1=10x25ml, R2=10x7ml (1600 test)', '', '(1600 test)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(175, 'ALT/GPT (R1: 644 ml, R2: 611 ml (1500 Test/Pack)', '', 'Pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(176, 'AST/GOT R1: 644 ml, R2: 611 ml (1500 Test/Pack', '', 'Pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(177, 'Alpha Amylase (For Manual Analyzer) 10x12 ML/ 120 Test', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(178, 'Alcohol', '', 'Per Piece', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(179, 'Amphetamine', '', 'Per Piece', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(180, 'ABX-Minidill (Diluent) 10 Liter', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:02', '2025-09-28 13:36:02', NULL, ''),
(181, 'ABG Analyzer Reagent Pack (100 test)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:03', '2025-09-28 13:36:03', NULL, ''),
(182, 'ABX-Miniclean-1L/ Bottle', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:03', '2025-09-28 13:36:03', NULL, ''),
(183, 'ABX-Minoclair-0.5L/Bottle', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:03', '2025-09-28 13:36:03', NULL, ''),
(184, 'ABX-Minilyse 1 Liter', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:03', '2025-09-28 13:36:03', NULL, ''),
(185, 'Benedicts Solution 500ml Bottle', '', '500ml Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:03', '2025-09-28 13:36:03', NULL, ''),
(186, 'Bilirubin liquicolor (for Manual Analyzer) 2x100ml/ 200test', '', '2x100ml/ 200test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:03', '2025-09-28 13:36:03', NULL, ''),
(187, 'Blood grouping reagent Anti1-A (10 ml/Vial)', '', '(10 ml/Vial)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:03', '2025-09-28 13:36:03', NULL, ''),
(188, 'Blood grouping reagent Anti1-B (10 ml/Vial)', '', '(10 ml/Vial)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(189, 'Blood grouping reagent Anti-D (Rh) (10 ml/Vial)', '', '(10 ml/Vial)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(190, 'Blood Grouping Reagent Anti-AB(10 ml/vail)', '', 'P/Vail', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(191, 'Blood glucose reagent 10ml', '', 'liter', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(192, 'Bilirubin Total R1: 644 ml, R2: 611 ml (1200 Test/Pack)', '', 'Pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(193, 'Blood Bag', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(194, 'Bnuella = Abortus, Melitensis', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(195, 'Blood roller mixtuer', '', 'Per Piece', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:04', '2025-09-28 13:36:04', NULL, ''),
(196, 'Bilirubin D+T (For semi Auto Biochemistry Analyzer 2x100m', '', '200 Test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(197, 'Benzodiazepine', '', 'P/Strip', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(198, 'Calcium (For manual analyzer)', '', '(For manual analyzer)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(199, 'Cholesterol kit (For manual analyzer) 4x250ml', '', '4x250ml', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(200, 'Creatinine Liquicolor (for Manual Analyzer) 200ml/200test', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(201, 'Creatinine (for manual analyzer), 200 ml/200 Test', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(202, 'Cell Clean', '', 'Box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(203, 'Cell Counter Reagent', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(204, 'CRP (complete test kil) 100test kit', '', '100test kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:05', '2025-09-28 13:36:05', NULL, ''),
(205, 'Cassette, (12\'\'15\'\')', '', 'Per/pc', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(206, 'Cassette, (10\'\'12\'\')', '', 'Per/pc', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(207, 'Calcium R1: 1012 ml (500 Test/Pack)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(208, 'Cholesterol R1: 1044 ml (2000 Test/Pack)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(209, 'C-Reactive Protein R1: 240 ml, R2: 210 ml (400 Test/Pack)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(210, 'Creatinine R1: 544 ml, R2: 511 ml (1250 Test/Pack)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(211, 'Crystal Iodine 100gm', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(212, 'Carbolic Acid', '', 'kg', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:06', '2025-09-28 13:36:06', NULL, ''),
(213, 'cTnI Standard Pack Size', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:07', '2025-09-28 13:36:07', NULL, ''),
(214, 'cTnI Calivrator(Backmun)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:07', '2025-09-28 13:36:07', NULL, ''),
(215, 'Centrifuge machine', '', 'Per Piece', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:07', '2025-09-28 13:36:07', NULL, ''),
(216, 'Cover slip', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:07', '2025-09-28 13:36:07', NULL, ''),
(217, 'Cannabinoids', '', 'P/Strip', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:07', '2025-09-28 13:36:07', NULL, ''),
(218, 'Cider wood oil', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:07', '2025-09-28 13:36:07', NULL, ''),
(219, 'Dip Stick for urine Suger, 50 test', '', 'Box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:07', '2025-09-28 13:36:07', NULL, ''),
(220, 'Dengue NS1 (Device)', '', 'Box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:08', '2025-09-28 13:36:08', NULL, ''),
(221, 'Dengue IgG, IgM (Device)', '', 'Box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:08', '2025-09-28 13:36:08', NULL, ''),
(222, 'Dip Stick Strip for Urine Sg, Gl, Pr, Ph.(4-parameters) 100 tests/box', '', 'Box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:08', '2025-09-28 13:36:08', NULL, ''),
(223, 'Dialunt ,20 litter can', '', 'Can', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:08', '2025-09-28 13:36:08', NULL, ''),
(224, 'Drabkins solution Hb%(500ml bottle)', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:08', '2025-09-28 13:36:08', NULL, ''),
(225, 'Dope Test kit', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:08', '2025-09-28 13:36:08', NULL, ''),
(226, 'Distilled Water (500 ml) 500ml /bottle', '', 'per bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:08', '2025-09-28 13:36:08', NULL, ''),
(227, 'Disposable syringe 5 cc', '', 'Per piece', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:09', '2025-09-28 13:36:09', NULL, ''),
(228, 'Digital X-ray film (10?14?) Compatible with FUJIFILM', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:09', '2025-09-28 13:36:09', NULL, ''),
(229, 'Digital X-ray film (10?14?) Compatible with FUJIFILM', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:09', '2025-09-28 13:36:09', NULL, ''),
(230, 'Dental X-ray film, 100Pc/Pack', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:09', '2025-09-28 13:36:09', NULL, ''),
(231, 'ECG Gel', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:09', '2025-09-28 13:36:09', NULL, ''),
(232, 'ECG Paper Channel, 6/3 channel', '', 'Per Role', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:09', '2025-09-28 13:36:09', NULL, ''),
(233, 'Ebra Elite H-Clean(50 ml/Vial)', '', 'Set', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:09', '2025-09-28 13:36:09', NULL, ''),
(234, 'Ebra H-360 Dill(20 Litres)', '', 'Set', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:10', '2025-09-28 13:36:10', NULL, ''),
(235, 'Ebra H-360 Lyse (500ml)', '', 'Set', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:10', '2025-09-28 13:36:10', NULL, ''),
(236, 'Erba Lyte plus Reagent pack(1000ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:10', '2025-09-28 13:36:10', NULL, ''),
(237, 'Erba Lyte K, electrode fill solution(15ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:10', '2025-09-28 13:36:10', NULL, ''),
(238, 'Erba Lyte Na,cl,ph electrode fill solution(15ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:10', '2025-09-28 13:36:10', NULL, ''),
(239, 'Erba Lyte ca Electrode fill solution(15ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:10', '2025-09-28 13:36:10', NULL, ''),
(240, 'Erba Lyte reference Electrode fill solution (15ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:10', '2025-09-28 13:36:10', NULL, ''),
(241, 'Erba Lyte QC solution(100ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:11', '2025-09-28 13:36:11', NULL, ''),
(242, 'Erba Lyte CA QC solution(100ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:11', '2025-09-28 13:36:11', NULL, ''),
(243, 'Erba Lyte Urine Diluent(100ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:11', '2025-09-28 13:36:11', NULL, ''),
(244, 'Erba Lyte NA conditioner solution(100ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:11', '2025-09-28 13:36:11', NULL, ''),
(245, 'Erba Lyte cleaning solution(100ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:11', '2025-09-28 13:36:11', NULL, ''),
(246, 'Erba Lyte co2 standard fill solution (100ml)', '', 'Per Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:11', '2025-09-28 13:36:11', NULL, ''),
(247, 'ESR (Visson pro Analyzer machine supprotrd)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:11', '2025-09-28 13:36:11', NULL, ''),
(248, 'ESR Fluid', '', '500ml/bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:12', '2025-09-28 13:36:12', NULL, ''),
(249, 'EC Cartdidge S (Erba)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:12', '2025-09-28 13:36:12', NULL, ''),
(250, 'Eusol Solution, 450ml', '', 'Pieces', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:12', '2025-09-28 13:36:12', NULL, ''),
(251, 'EDTA Tube', '', 'Tube', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:12', '2025-09-28 13:36:12', NULL, ''),
(252, 'ECG paper (6 Channel) (210mm*140mm size) 12pic per pack', '', 'pakt', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:12', '2025-09-28 13:36:12', NULL, ''),
(253, 'ep tips standard 0. 1-10 micro 1000 per box', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:13', '2025-09-28 13:36:13', NULL, ''),
(254, 'ep tips standard 2-200 micro 1000 per bo', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:13', '2025-09-28 13:36:13', NULL, ''),
(255, 'ep tips standard 50-1000 micro 1000 per box', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:13', '2025-09-28 13:36:13', NULL, ''),
(256, 'Ethanol 100% (2.5 liter)', '', 'jar', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:13', '2025-09-28 13:36:13', NULL, ''),
(257, 'Eugenol 100ml', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:13', '2025-09-28 13:36:13', NULL, ''),
(258, 'Elite H 580 Diluent (20 ltre)', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:14', '2025-09-28 13:36:14', NULL, ''),
(259, 'Elite H 580 Lyse-1(500ml)', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:14', '2025-09-28 13:36:14', NULL, ''),
(260, 'Elite H 580 Lyse-2(500ml)', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:14', '2025-09-28 13:36:14', NULL, ''),
(261, 'Elite H 580 Lyse-3 (1 ltre)', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:14', '2025-09-28 13:36:14', NULL, ''),
(262, 'Elite H clean (50ml)', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:15', '2025-09-28 13:36:15', NULL, ''),
(263, 'Eosin red powder', '', 'pk', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:15', '2025-09-28 13:36:15', NULL, ''),
(264, 'FT4(Backmun) Standard Pack Size', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:15', '2025-09-28 13:36:15', NULL, ''),
(265, 'FT3(Backmun) Standard Pack Size', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:15', '2025-09-28 13:36:15', NULL, ''),
(266, 'Febrile Antigen with bracelet vial', '', 'P/vail', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:15', '2025-09-28 13:36:15', NULL, ''),
(267, 'Formaldehyde 37-40% 2.5 liter/bottle', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:16', '2025-09-28 13:36:16', NULL, ''),
(268, 'Geimsa stain powder (25gm Pack)', '', '100test kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:16', '2025-09-28 13:36:16', NULL, ''),
(269, 'Glass slide 72pcs Pack', '', '72pcs Pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:16', '2025-09-28 13:36:16', NULL, ''),
(270, 'Glucose (For Manual Analyzer) 1000ml / 1000test', '', '1000ml / 1000test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:17', '2025-09-28 13:36:17', NULL, ''),
(271, 'Glucose LS (mono Reagent) (4 x 250=1000: R1 = 4 x 250ml: R2 = 1 x 3ml)', '', 'Box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:17', '2025-09-28 13:36:17', NULL, ''),
(272, 'Gonorea (Device)', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:17', '2025-09-28 13:36:17', NULL, ''),
(273, 'G.P Point', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:17', '2025-09-28 13:36:17', NULL, ''),
(274, 'QC NORM (4*5ml)', '', 'Per Vail', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:18', '2025-09-28 13:36:18', NULL, ''),
(275, 'QC PATH (4*5ml)', '', 'Per Vail', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:18', '2025-09-28 13:36:18', NULL, ''),
(276, 'Glycerine pure', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:18', '2025-09-28 13:36:18', NULL, ''),
(277, 'H Pylori Devices', '', 'Devices', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:18', '2025-09-28 13:36:18', NULL, ''),
(278, 'HbsAg Strip/Devices  30 test', '', '30 test/pcs', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:18', '2025-09-28 13:36:18', NULL, ''),
(279, 'HIV Strip/Device (25 tast pack)', '', '(25 tast pack)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:18', '2025-09-28 13:36:18', NULL, ''),
(280, 'HCV Strip/Device(25 tast pack)', '', '(25 tast pack)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(281, 'HDL Cholesterol 100ml', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(282, 'Hanger, (12\'\'15\'\')', '', 'Per/pc', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(283, 'Hanger, (10\'\'12\'\')', '', 'Per/pc', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(284, 'Hemoglobin = 200 test reagent (analyzen)', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(285, 'Hematology analyzer machine with UPS', '', 'Per Piece', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(286, 'Hematology analyzer Reagent(package)', '', 'Per Package', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(287, 'Hemocue Devices', '', 'Devices', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:19', '2025-09-28 13:36:19', NULL, ''),
(288, 'HbAic = 100 test reagent', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:20', '2025-09-28 13:36:20', NULL, ''),
(289, 'Hexisol 100 ml/bottle', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:20', '2025-09-28 13:36:20', NULL, ''),
(290, 'Hydrogen Per Oxide (100 ml bottle)', '', 'bottlr', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:20', '2025-09-28 13:36:20', NULL, ''),
(291, 'Hard plaster', '', 'pk', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:20', '2025-09-28 13:36:20', NULL, ''),
(292, 'Intensifying Screen, (12\'\'15\'\')', '', 'Per/pc', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:20', '2025-09-28 13:36:20', NULL, ''),
(293, 'Intensifying Screen, (10\'\'12\'\')', '', 'Per/pc', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:20', '2025-09-28 13:36:20', NULL, ''),
(294, 'I.GG /IGM for Dengue (laa)', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:21', '2025-09-28 13:36:21', NULL, ''),
(295, 'I.GG /IGM for Dengue (lam)', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:21', '2025-09-28 13:36:21', NULL, ''),
(296, 'IGE reagent 100 test', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:21', '2025-09-28 13:36:21', NULL, ''),
(297, 'Iodine solution (500 ml/bottle)', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:21', '2025-09-28 13:36:21', NULL, ''),
(298, 'Impression Alginate Material', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:21', '2025-09-28 13:36:21', NULL, ''),
(299, 'LDL (For Manual Analyzer)', '', '100 Test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:21', '2025-09-28 13:36:21', NULL, ''),
(300, 'Local anesthesia spray 10%', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:21', '2025-09-28 13:36:21', NULL, ''),
(301, 'Lugol\'s iodine solution- 500ml', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:22', '2025-09-28 13:36:22', NULL, ''),
(302, 'Leishman powder 25gm/', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:22', '2025-09-28 13:36:22', NULL, ''),
(303, 'Leishman stain solution', '', 'Per ltr', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:22', '2025-09-28 13:36:22', NULL, ''),
(304, 'Lyzer Cell, 500 ml', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:22', '2025-09-28 13:36:22', NULL, ''),
(305, 'Jelly for U. S. G Machine 100gm/tube', '', '100gm/tube', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:22', '2025-09-28 13:36:22', NULL, ''),
(306, 'Jelly for E. C. G Machine 100gm/tube', '', '100gm/tube', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:22', '2025-09-28 13:36:22', NULL, ''),
(307, 'Malaria WB device 40test kit', '', '40test kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:23', '2025-09-28 13:36:23', NULL, ''),
(308, 'Methylated spirit 1ltr/ Bottle', '', '1ltr/ Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:23', '2025-09-28 13:36:23', NULL, ''),
(309, 'M.P (Device)', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:23', '2025-09-28 13:36:23', NULL, ''),
(310, 'Mixing Pad 3^3 Inch', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:23', '2025-09-28 13:36:23', NULL, ''),
(311, 'Mercury Triple Distilled', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:23', '2025-09-28 13:36:23', NULL, ''),
(312, 'Methyl Alcohol (methanol) Original Actinon fre', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:23', '2025-09-28 13:36:23', NULL, ''),
(313, 'One Time Bandage', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:24', '2025-09-28 13:36:24', NULL, ''),
(314, 'Opiates', '', 'P/Strip', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:24', '2025-09-28 13:36:24', NULL, ''),
(315, 'Povidine Iodide Oinrment USP 6% (25gm Tube)', '', '(25gm Tube)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:24', '2025-09-28 13:36:24', NULL, ''),
(316, 'Povidine Iodide USP 10% (1 litre jar)', '', '(1 litre jar)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:24', '2025-09-28 13:36:24', NULL, ''),
(317, 'PATH R1: 45 ml, R1: 120 ml', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:24', '2025-09-28 13:36:24', NULL, ''),
(318, 'Pregnancy test 25test kit', '', '25test kit box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:24', '2025-09-28 13:36:24', NULL, ''),
(319, 'Protcus = OXK,OX2,OX19', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:25', '2025-09-28 13:36:25', NULL, ''),
(320, 'Proteus OXK (5ml /kit )', '', 'per kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:25', '2025-09-28 13:36:25', NULL, ''),
(321, 'Proteus OX2 (5ml /kit )', '', 'per kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:25', '2025-09-28 13:36:25', NULL, ''),
(322, 'Proteus OX19 (5ml /kit )', '', 'per kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:25', '2025-09-28 13:36:25', NULL, ''),
(323, 'Probe Cleanser Solution ( 1 bottle)', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:25', '2025-09-28 13:36:25', NULL, ''),
(324, 'Paraffin wax (Solid)/Kg', '', 'kg', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:25', '2025-09-28 13:36:25', NULL, ''),
(325, 'Plaster of Paris (Ordinary Plaster) 25kg/bag', '', 'bag', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:26', '2025-09-28 13:36:26', NULL, ''),
(326, 'Pregnancy test kit(25test/kit)', '', 'per kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:26', '2025-09-28 13:36:26', NULL, ''),
(327, 'Potassium Iodine', '', 'kg', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:26', '2025-09-28 13:36:26', NULL, ''),
(328, 'Pulp Devitalize', '', 'pk', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:26', '2025-09-28 13:36:26', NULL, ''),
(329, 'RA test latex 100test', '', '100test box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:26', '2025-09-28 13:36:26', NULL, ''),
(330, 'Red Tube', '', 'Tube', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:26', '2025-09-28 13:36:26', NULL, ''),
(331, 'Reaction Vessel(Backmun)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:26', '2025-09-28 13:36:26', NULL, ''),
(332, 'Rectified Sprit(clear) 99% Ethanol', '', 'Per litre', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:27', '2025-09-28 13:36:27', NULL, ''),
(333, 'Root canal sealer', '', '14gm Power', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:27', '2025-09-28 13:36:27', NULL, ''),
(334, 'S. G. O. T (kinetic) (For Manual Analyzer) 5100ml', '', '(For Manual Analyzer) 5100ml', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:27', '2025-09-28 13:36:27', NULL, ''),
(335, 'S. G. P. T (kinetic) (For Manual Analyzer) 5100ml', '', '(For Manual Analyzer) 5100ml', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:27', '2025-09-28 13:36:27', NULL, ''),
(336, 'Syplish Strips (TPHA) 100 test/kit', '', 'kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:27', '2025-09-28 13:36:27', NULL, ''),
(337, 'S. Total cholesterol liquicolor 100ml', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:28', '2025-09-28 13:36:28', NULL, ''),
(338, 'Serum Ueria. 500 test', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:28', '2025-09-28 13:36:28', NULL, ''),
(339, 'Serum bilirubin liquicilor 100 ml', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:28', '2025-09-28 13:36:28', NULL, ''),
(340, 'Substrate Standard Pack Size', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:28', '2025-09-28 13:36:28', NULL, ''),
(341, 'Surgical Mask', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:28', '2025-09-28 13:36:28', NULL, ''),
(342, 'Serum electrolyte', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:28', '2025-09-28 13:36:28', NULL, ''),
(343, 'S. Creatinine 200 ml/200 test', '', 'kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:29', '2025-09-28 13:36:29', NULL, ''),
(344, 'Semi Automatic Biochemistry Analyzer washing solution (500ml)', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:29', '2025-09-28 13:36:29', NULL, ''),
(345, 'Silver alloy (30gm/pack)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:29', '2025-09-28 13:36:29', NULL, ''),
(346, 'Serum Amylase Re-Agent. R-1=200test. R-2=200ml', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:29', '2025-09-28 13:36:29', NULL, ''),
(347, 'Serum Calcium Re-Agent. 500test', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:29', '2025-09-28 13:36:29', NULL, ''),
(348, 'Sodium Hypochlorite solution 5.25% (To be used in Nepro Hemodialysis machine)', '', '5 liters/cane', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:30', '2025-09-28 13:36:30', NULL, ''),
(349, 'TSH, 96 Test', '', 'Kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:30', '2025-09-28 13:36:30', NULL, ''),
(350, 'TSH Calivrator(Backmun) Standard Pack Size', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:30', '2025-09-28 13:36:30', NULL, ''),
(351, 'Triglyceride (For Manual Analyzer) 4x100ML/400Test', '', '4x100ML/400Test per vail', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:30', '2025-09-28 13:36:30', NULL, ''),
(352, 'Tri-Glycerides liquicolor 100ml', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:31', '2025-09-28 13:36:31', NULL, ''),
(353, 'Triglycerides R1: 1044 ml (2000 Test/Pack)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:31', '2025-09-28 13:36:31', NULL, ''),
(354, 'Tourniquet', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:31', '2025-09-28 13:36:31', NULL, ''),
(355, 'TPHA', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:31', '2025-09-28 13:36:31', NULL, ''),
(356, 'Test Tube (12 x 100)', '', 'pcs', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:32', '2025-09-28 13:36:32', NULL, ''),
(357, 'TSI Media', '', 'pk', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:32', '2025-09-28 13:36:32', NULL, ''),
(358, 'Urea (For Manual Analyzer) 10x50ml', '', '10x50ml', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:32', '2025-09-28 13:36:32', NULL, ''),
(359, 'Uric Acid (For Manual Analyzer) 10x50ml', '', '10x50ml', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:32', '2025-09-28 13:36:32', NULL, ''),
(360, 'Ultra Sound Printer Paper, 110mm (W) x 20m (L)', '', '110mm (W) x 20m (L)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:33', '2025-09-28 13:36:33', NULL, ''),
(361, 'USG Paper', '', 'Roll', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:33', '2025-09-28 13:36:33', NULL, ''),
(362, 'Uric Acie (for manual analyzer), 10*50 ml', '', 'Bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:33', '2025-09-28 13:36:33', NULL, ''),
(363, 'Uric Acid R1: 544 ml, R2: 511 ml (1000 Test/Pack)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:34', '2025-09-28 13:36:34', NULL, ''),
(364, 'Urinanalysis Strip for sugar+ Albumin +PH', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:34', '2025-09-28 13:36:34', NULL, ''),
(365, 'Ultra Glossy Paper (High Glossy)', '', 'Box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:34', '2025-09-28 13:36:34', NULL, ''),
(366, 'Urine Reagent strips (glucose, protine ph)', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:34', '2025-09-28 13:36:34', NULL, ''),
(367, 'Urinery Collection Cup', '', 'pcs', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:35', '2025-09-28 13:36:35', NULL, ''),
(368, 'Uric 3v-gp, 100 Piece Pack', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:35', '2025-09-28 13:36:35', NULL, ''),
(369, 'Uric 2v(100 strip)', '', 'pakt', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:35', '2025-09-28 13:36:35', NULL, ''),
(370, 'Urine Sample pot', '', 'Pieces', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:35', '2025-09-28 13:36:35', NULL, ''),
(371, 'Ultra sonogram Gel. 100gm tube', '', 'Pieces', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:36', '2025-09-28 13:36:36', NULL, ''),
(372, 'VDRL (RPR) (Complete test kit) 100test kit', '', '100test kit', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:36', '2025-09-28 13:36:36', NULL, ''),
(373, 'VDRL tests (25 test pack)', '', '25 test pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:36', '2025-09-28 13:36:36', NULL, ''),
(374, 'Vaseline (White)', '', 'Kg', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:36', '2025-09-28 13:36:36', NULL, ''),
(375, 'Widal test (Complete test kit) AO 5ml Vial/100test', '', 'AO 5ml Vial/100test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:37', '2025-09-28 13:36:37', NULL, ''),
(376, 'Widal test (Complete test kit) BH 5ml Vial/100test', '', 'BH 5ml Vial/100test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:37', '2025-09-28 13:36:37', NULL, ''),
(377, 'Widal test (Complete test kit) TH 5ml Vial/100test', '', 'TH 5ml Vial/100test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:37', '2025-09-28 13:36:37', NULL, ''),
(378, 'Widal test (AH) 10ml', '', '100test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:37', '2025-09-28 13:36:37', NULL, ''),
(379, 'Widal test (TO) 10ml', '', '100test', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:38', '2025-09-28 13:36:38', NULL, ''),
(380, 'Wash Buffer(Backmun)', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:38', '2025-09-28 13:36:38', NULL, ''),
(381, 'Washing solution for manual analizer 100 ml', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:38', '2025-09-28 13:36:38', NULL, ''),
(382, 'X-Ray Developer 10ltr/can', '', '10ltr/can Packet', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:38', '2025-09-28 13:36:38', NULL, ''),
(383, 'X-Ray film 100 sheets/ box (12 inc x15inc)', '', '(12 inc x15inc) box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:38', '2025-09-28 13:36:38', NULL, ''),
(384, 'X-Ray film 100 sheets/ box (10 inc x12inc)', '', '(10 inc x12inc) box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:38', '2025-09-28 13:36:38', NULL, ''),
(385, 'X-Ray film 100 sheets/ box (8 inc x10inc)', '', '(8 inc x10inc)', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:38', '2025-09-28 13:36:38', NULL, ''),
(386, 'X-ray film (Dental with liquid)', '', 'box', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:39', '2025-09-28 13:36:39', NULL, ''),
(387, 'X-Ray fixing salt 10ltr/can', '', '10ltr/can Packet', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:39', '2025-09-28 13:36:39', NULL, ''),
(388, 'XL MULTICALIBRATOR R1: 43 ml', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:39', '2025-09-28 13:36:39', NULL, ''),
(389, 'XL Wash R1: 4100 ml', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:39', '2025-09-28 13:36:39', NULL, ''),
(390, 'XL Auto Wash AC/AL R1: 544 ml, R2: 544 ml', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:39', '2025-09-28 13:36:39', NULL, ''),
(391, 'Xylene 2.5 liter bottle', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:39', '2025-09-28 13:36:39', NULL, ''),
(392, 'Yellow tips.1000Pc/Pack', '', 'pack', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:39', '2025-09-28 13:36:39', NULL, ''),
(393, 'Zine Oxide Powder 25gm/Pk', '', '25gm/Pk', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:40', '2025-09-28 13:36:40', NULL, ''),
(394, 'Zinc Oxide 500gm Bottle', '', 'bottle', 9, NULL, NULL, 1, 1, 1, '2025-09-28 13:36:40', '2025-09-28 13:36:40', NULL, '');

-- Table structure for table `tenders`
DROP TABLE IF EXISTS `tenders`;
CREATE TABLE `tenders` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR NOT NULL,
  `description` TEXT NULL,
  `reference_number` VARCHAR NOT NULL,
  `status` VARCHAR NOT NULL DEFAULT ''draft'',
  `budget` TEXT NULL,
  `currency` VARCHAR NOT NULL DEFAULT ''BDT'',
  `deadline` TEXT NULL,
  `published_date` TEXT NULL,
  `requirements` TEXT NULL,
  `contact_person` VARCHAR NULL,
  `contact_email` VARCHAR NULL,
  `contact_phone` VARCHAR NULL,
  `terms_conditions` TEXT NULL,
  `created_by` INT NOT NULL,
  `updated_by` INT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL,
  `deleted_at` TEXT NULL,
  `vat_tax_percentage` TEXT NOT NULL DEFAULT ''0'',
  `bidding_percentage` TEXT NOT NULL DEFAULT ''0'',
  `tender_buying_time` TEXT NULL,
  `submission_time` TEXT NULL,
  `security_money_time` TEXT NULL,
  `bidding_companies` TEXT NULL,
  `requires_tin_document` TEXT NOT NULL DEFAULT ''0'',
  `requires_bin_document` TEXT NOT NULL DEFAULT ''0'',
  `requires_audit_report` TEXT NOT NULL DEFAULT ''0'',
  `requires_trade_license` TEXT NOT NULL DEFAULT ''0'',
  `requires_bank_guarantee` TEXT NOT NULL DEFAULT ''0'',
  `requires_company_registration` TEXT NOT NULL DEFAULT ''0'',
  `qualification_requirements` TEXT NULL,
  `other_required_files` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `tenders`
INSERT INTO `tenders` (`id`, `name`, `description`, `reference_number`, `status`, `budget`, `currency`, `deadline`, `published_date`, `requirements`, `contact_person`, `contact_email`, `contact_phone`, `terms_conditions`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`, `vat_tax_percentage`, `bidding_percentage`, `tender_buying_time`, `submission_time`, `security_money_time`, `bidding_companies`, `requires_tin_document`, `requires_bin_document`, `requires_audit_report`, `requires_trade_license`, `requires_bank_guarantee`, `requires_company_registration`, `qualification_requirements`, `other_required_files`) VALUES
(1, 'Office Equipment Procurement 2025', 'Procurement of office equipment including computers, printers, and furniture for the new branch office.', 'TND-202509-0001', 'closed', 500000, 'BDT', '2025-10-26 00:00:00', '2025-09-21 00:00:00', NULL, 'John Smith', 'john.smith@company.com', '+880-1234-567890', 'All items must be delivered within 15 days of order confirmation. Payment terms: 30 days net.', 1, 1, '2025-09-26 22:26:18', '2025-09-27 20:49:26', NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL),
(2, 'IT Infrastructure Upgrade', 'Complete IT infrastructure upgrade including servers, networking equipment, and software licenses.', 'TND-202509-0002', 'draft', 1200000, 'BDT', '2025-11-10 22:26:18', NULL, NULL, 'Sarah Johnson', 'sarah.johnson@company.com', '+880-1234-567891', 'Technical specifications must be met exactly as described. Installation and configuration included.', 1, 1, '2025-09-26 22:26:18', '2025-09-26 22:26:18', NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL),
(3, 'Stationery and Office Supplies', 'Annual procurement of stationery items, office supplies, and consumables.', 'TND-202509-0003', 'active', 75000, 'BDT', '2025-10-11 00:00:00', '2025-09-16 00:00:00', NULL, 'Mike Wilson', 'mike.wilson@company.com', '+880-1234-567892', 'Monthly delivery schedule. Quality certificates required for all items.', 1, 1, '2025-09-26 22:26:19', '2025-09-28 06:06:04', NULL, 15, 10, NULL, NULL, NULL, '[\"Aerolith Solution\"]', 0, 0, 0, 0, 0, 0, NULL, NULL),
(4, 'Software Development Services 2025', 'Procurement of software development services for custom applications and system integration.', 'TND-202509-0004', 'draft', 500000, 'BDT', '2025-11-15 00:00:00', '2025-09-28 00:00:00', NULL, NULL, NULL, NULL, NULL, 1, 1, '2025-09-27 11:16:43', '2025-09-27 11:16:43', NULL, 0, 0, '2025-09-30 10:00:00', '2025-11-10 17:00:00', '2025-11-05 15:00:00', '[\"Aerolith Solution\",\"CSB Enterprise\",\"Rita Enterprise\",\"TechCorp Bangladesh\",\"Digital Solutions BD\"]', 0, 0, 0, 0, 0, 0, NULL, NULL),
(5, 'Test Single Company Selection', NULL, 'TND-202509-0005', 'draft', NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2025-09-27 19:42:46', '2025-09-27 19:43:29', NULL, 0, 0, NULL, NULL, NULL, '[\"CSB Enterprise\"]', 0, 0, 0, 0, 0, 0, NULL, NULL),
(6, 'Test Active Tender - IT Equipment', 'Test tender to verify active tender display', 'TND-202509-0006', 'active', 100000, 'BDT', '2025-10-27 20:54:25', '2025-09-27 20:54:25', NULL, 'Test Manager', 'test@example.com', '+880-1234-567890', NULL, 1, 1, '2025-09-27 20:54:25', '2025-09-27 20:54:25', NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL),
(7, 'Procurement of Furniture the Fiscal Year 2025-2026_Nawabganj Upazila Health Complex', 'Nawabganj Upazila Health Complex, Dhaka', 'TND-202509-0007', 'active', NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2025-09-27 22:21:39', '2025-09-27 22:21:39', NULL, 0, 0, NULL, '2025-10-13 13:00:00', NULL, '[\"Aerolith Solution\"]', 0, 0, 0, 0, 0, 0, NULL, NULL);

-- Table structure for table `tender_products`
DROP TABLE IF EXISTS `tender_products`;
CREATE TABLE `tender_products` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `tender_id` INT NOT NULL,
  `product_id` INT NULL,
  `name` VARCHAR NOT NULL,
  `description` TEXT NULL,
  `country_of_origin` VARCHAR NULL,
  `category_id` INT NULL,
  `subcategory_id` INT NULL,
  `market_price_bdt` TEXT NULL,
  `price_usd` TEXT NULL,
  `measurement_unit` VARCHAR NULL,
  `quantity_required` INT NULL,
  `total_price_bdt` TEXT NULL,
  `specifications` TEXT NULL,
  `priority` VARCHAR NOT NULL DEFAULT ''medium'',
  `is_mandatory` TEXT NOT NULL DEFAULT ''1'',
  `notes` TEXT NULL,
  `csv_row_number` INT NULL,
  `import_status` VARCHAR NOT NULL DEFAULT ''imported'',
  `similar_products` TEXT NULL,
  `created_by` INT NOT NULL,
  `updated_by` INT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL,
  `inc_vat_tax_price_bdt` TEXT NULL,
  `bidding_price_bdt` TEXT NULL,
  `total_market_price_bdt` TEXT NULL,
  `total_inc_vat_tax_price_bdt` TEXT NULL,
  `total_bidding_price_bdt` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `tender_products`
INSERT INTO `tender_products` (`id`, `tender_id`, `product_id`, `name`, `description`, `country_of_origin`, `category_id`, `subcategory_id`, `market_price_bdt`, `price_usd`, `measurement_unit`, `quantity_required`, `total_price_bdt`, `specifications`, `priority`, `is_mandatory`, `notes`, `csv_row_number`, `import_status`, `similar_products`, `created_by`, `updated_by`, `created_at`, `updated_at`, `inc_vat_tax_price_bdt`, `bidding_price_bdt`, `total_market_price_bdt`, `total_inc_vat_tax_price_bdt`, `total_bidding_price_bdt`) VALUES
(5, 2, NULL, 'Server Rack', 'Sample product for IT Infrastructure Upgrade', 'Bangladesh', 1, NULL, 150000, NULL, 'piece', 2, 300000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:18', '2025-09-26 22:26:18', NULL, NULL, NULL, NULL, NULL),
(6, 2, NULL, 'Network Switch', 'Sample product for IT Infrastructure Upgrade', 'Bangladesh', 1, NULL, 35000, NULL, 'piece', 5, 175000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:19', '2025-09-26 22:26:19', NULL, NULL, NULL, NULL, NULL),
(7, 2, NULL, 'UPS System', 'Sample product for IT Infrastructure Upgrade', 'Bangladesh', 1, NULL, 80000, NULL, 'piece', 3, 240000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:19', '2025-09-26 22:26:19', NULL, NULL, NULL, NULL, NULL),
(8, 2, NULL, 'Firewall Device', 'Sample product for IT Infrastructure Upgrade', 'Bangladesh', 1, NULL, 120000, NULL, 'piece', 1, 120000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:19', '2025-09-26 22:26:19', NULL, NULL, NULL, NULL, NULL),
(9, 3, NULL, 'A4 Paper', 'Sample product for Stationery and Office Supplies', 'Bangladesh', 1, NULL, 500, NULL, 'ream', 100, 50000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:19', '2025-09-28 06:05:54', 575, 560, 50000, 57500, 56000),
(10, 3, NULL, 'Ballpoint Pen', 'Sample product for Stationery and Office Supplies', 'Bangladesh', 1, NULL, 15, NULL, 'piece', 500, 7500, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:19', '2025-09-28 06:05:54', 17.25, 16.5, 7500, 8625, 8250),
(11, 3, NULL, 'Stapler', 'Sample product for Stationery and Office Supplies', 'Bangladesh', 1, NULL, 250, NULL, 'piece', 20, 5000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:19', '2025-09-28 06:05:54', 287.5, 275, 5000, 5750, 5500),
(12, 3, NULL, 'File Folder', 'Sample product for Stationery and Office Supplies', 'Bangladesh', 1, NULL, 25, NULL, 'piece', 200, 5000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-26 22:26:19', '2025-09-28 06:05:54', 28.75, 27.5, 5000, 5750, 5500),
(15, 1, 153, 'Description', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 2, 'imported', NULL, 1, 1, '2025-09-27 09:12:48', '2025-09-27 09:12:48', NULL, NULL, NULL, NULL, NULL),
(17, 1, 154, 'Patient Bed', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 4, 'imported', NULL, 1, 1, '2025-09-27 09:12:48', '2025-09-27 09:12:48', NULL, NULL, NULL, NULL, NULL),
(18, 1, 155, 'রোগী বহন করার ট্র্রলী', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 5, 'imported', NULL, 1, 1, '2025-09-27 09:12:48', '2025-09-27 09:12:48', NULL, NULL, NULL, NULL, NULL),
(19, 1, 156, 'Instrument Troly', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 6, 'imported', NULL, 1, 1, '2025-09-27 09:12:49', '2025-09-27 09:12:49', NULL, NULL, NULL, NULL, NULL),
(20, 1, 157, 'Medicine Troly', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 7, 'imported', NULL, 1, 1, '2025-09-27 09:12:49', '2025-09-27 09:12:49', NULL, NULL, NULL, NULL, NULL),
(21, 1, 158, 'Gumla Plastic', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 8, 'imported', NULL, 1, 1, '2025-09-27 09:12:49', '2025-09-27 09:12:49', NULL, NULL, NULL, NULL, NULL),
(22, 1, 159, 'Bucket Plastic', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 9, 'imported', NULL, 1, 1, '2025-09-27 09:12:49', '2025-09-27 09:12:49', NULL, NULL, NULL, NULL, NULL),
(23, 1, 151, 'Saline stand (ss)', 'Std size.', '', 5, NULL, NULL, NULL, 'Piece', 1, NULL, NULL, 'medium', 1, NULL, 11, 'imported', NULL, 1, 1, '2025-09-27 09:12:49', '2025-09-27 09:12:49', NULL, NULL, NULL, NULL, NULL),
(26, 1, 126, 'Steel Almirah', 'Length: -190 cm Width: -100 cm Depth: 50 cm 18 kg High quality rolled sheet will be used on the top, bottom, two sides and back; shelves and locks. The shelves inside the cupboard will be 20 kg. There will be five shelves at equal distances. The lid should have a handle lock. The door should have a domestic lock. Paint: Spray paint should be done in a good way. Minimum 02 Years warranty and After sales service.', '', 5, NULL, NULL, NULL, 'Piece', 1, NULL, NULL, 'medium', 1, NULL, 10, 'imported', '\"[{\\\"id\\\":126,\\\"name\\\":\\\"Steel Almirah\\\",\\\"similarity\\\":92.86}]\"', 1, 1, '2025-09-27 09:13:01', '2025-09-27 09:13:01', NULL, NULL, NULL, NULL, NULL),
(28, 1, NULL, 'Test Pricing Product', 'Product to test three-tier pricing system', 'Bangladesh', NULL, NULL, 10000, NULL, 'piece', 2, 20000, NULL, 'medium', 1, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-27 10:01:45', '2025-09-27 20:40:50', 10000, 13000, 20000, 20000, 26000),
(29, 1, NULL, 'Three-Tier Test Product', 'Testing the three-tier pricing system functionality', 'Bangladesh', NULL, NULL, 5000, NULL, 'piece', 3, 15000, NULL, 'medium', 0, NULL, NULL, 'manual_added', NULL, 1, 1, '2025-09-27 10:09:18', '2025-09-27 20:40:50', 5000, 6325, 15000, 15000, 18975),
(30, 7, 154, 'Patient Bed', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 2, 'imported', NULL, 1, 1, '2025-09-27 22:22:24', '2025-09-27 22:22:24', NULL, NULL, NULL, NULL, NULL),
(31, 7, 155, 'রোগী বহন করার ট্র্রলী', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 3, 'imported', NULL, 1, 1, '2025-09-27 22:22:24', '2025-09-27 22:22:24', NULL, NULL, NULL, NULL, NULL),
(32, 7, 156, 'Instrument Troly', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 4, 'imported', NULL, 1, 1, '2025-09-27 22:22:24', '2025-09-27 22:22:24', NULL, NULL, NULL, NULL, NULL),
(33, 7, 157, 'Medicine Troly', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 5, 'imported', NULL, 1, 1, '2025-09-27 22:22:24', '2025-09-27 22:22:24', NULL, NULL, NULL, NULL, NULL),
(34, 7, 158, 'Gumla Plastic', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 6, 'imported', NULL, 1, 1, '2025-09-27 22:22:25', '2025-09-27 22:22:25', NULL, NULL, NULL, NULL, NULL),
(35, 7, 159, 'Bucket Plastic', NULL, NULL, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'medium', 1, NULL, 7, 'imported', NULL, 1, 1, '2025-09-27 22:22:25', '2025-09-27 22:22:25', NULL, NULL, NULL, NULL, NULL),
(36, 7, 151, 'Saline stand (ss)', 'Std size.', '', 5, NULL, NULL, NULL, 'Piece', 1, NULL, NULL, 'medium', 1, NULL, 9, 'imported', NULL, 1, 1, '2025-09-27 22:22:25', '2025-09-27 22:22:25', NULL, NULL, NULL, NULL, NULL),
(37, 7, 126, 'Steel Almirah', 'Length: -190 cm Width: -100 cm Depth: 50 cm 18 kg High quality rolled sheet will be used on the top, bottom, two sides and back; shelves and locks. The shelves inside the cupboard will be 20 kg. There will be five shelves at equal distances. The lid should have a handle lock. The door should have a domestic lock. Paint: Spray paint should be done in a good way. Minimum 02 Years warranty and After sales service.', '', 5, NULL, NULL, NULL, 'Piece', 1, NULL, NULL, 'medium', 1, NULL, 8, 'imported', '\"[{\\\"id\\\":126,\\\"name\\\":\\\"Steel Almirah\\\",\\\"similarity\\\":92.86}]\"', 1, 1, '2025-09-27 22:22:42', '2025-09-27 22:22:42', NULL, NULL, NULL, NULL, NULL),
(38, 7, 166, '1GG/1GM Dengue (laa)', 'Per Piece', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 2, 'imported', NULL, 1, 1, '2025-09-28 13:38:40', '2025-09-28 13:38:40', NULL, NULL, NULL, NULL, NULL),
(39, 7, 167, '5% Acetic Acid (Glacial) 500 ml bottle', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 3, 'imported', NULL, 1, 1, '2025-09-28 13:38:40', '2025-09-28 13:38:40', NULL, NULL, NULL, NULL, NULL),
(40, 7, 168, 'Albumin', 'Pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 4, 'imported', NULL, 1, 1, '2025-09-28 13:38:40', '2025-09-28 13:38:40', NULL, NULL, NULL, NULL, NULL),
(41, 7, 169, 'Acetic Acid Glacial (500ml Bottle)', '(500ml Bottle)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 5, 'imported', NULL, 1, 1, '2025-09-28 13:38:40', '2025-09-28 13:38:40', NULL, NULL, NULL, NULL, NULL),
(42, 7, 170, 'Anti HCV (device WB/S/P) 30 test', '(device WB/S/P) 30 test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 6, 'imported', NULL, 1, 1, '2025-09-28 13:38:40', '2025-09-28 13:38:40', NULL, NULL, NULL, NULL, NULL),
(43, 7, 171, 'Anti-septic Solution (Hand scrub) 250 ml/bott', '250 ml/bott', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 7, 'imported', NULL, 1, 1, '2025-09-28 13:38:40', '2025-09-28 13:38:40', NULL, NULL, NULL, NULL, NULL),
(44, 7, 172, 'ASO (complete test kit) 100test', '100test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 8, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(45, 7, 173, 'ASO titre kit (50 test pac)', 'pac', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 9, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(46, 7, 174, 'AST for Auto Analyzer R1=10x25ml, R2=10x7ml (1600 test)', '(1600 test)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 10, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(47, 7, 175, 'ALT/GPT (R1: 644 ml, R2: 611 ml (1500 Test/Pack)', 'Pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 11, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(48, 7, 176, 'AST/GOT R1: 644 ml, R2: 611 ml (1500 Test/Pack', 'Pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 12, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(49, 7, 177, 'Alpha Amylase (For Manual Analyzer) 10x12 ML/ 120 Test', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 13, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(50, 7, 178, 'Alcohol', 'Per Piece', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 14, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(51, 7, 179, 'Amphetamine', 'Per Piece', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 15, 'imported', NULL, 1, 1, '2025-09-28 13:38:41', '2025-09-28 13:38:41', NULL, NULL, NULL, NULL, NULL),
(52, 7, 180, 'ABX-Minidill (Diluent) 10 Liter', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 16, 'imported', NULL, 1, 1, '2025-09-28 13:38:42', '2025-09-28 13:38:42', NULL, NULL, NULL, NULL, NULL),
(53, 7, 181, 'ABG Analyzer Reagent Pack (100 test)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 17, 'imported', NULL, 1, 1, '2025-09-28 13:38:42', '2025-09-28 13:38:42', NULL, NULL, NULL, NULL, NULL),
(54, 7, 182, 'ABX-Miniclean-1L/ Bottle', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 18, 'imported', NULL, 1, 1, '2025-09-28 13:38:42', '2025-09-28 13:38:42', NULL, NULL, NULL, NULL, NULL),
(55, 7, 183, 'ABX-Minoclair-0.5L/Bottle', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 19, 'imported', NULL, 1, 1, '2025-09-28 13:38:42', '2025-09-28 13:38:42', NULL, NULL, NULL, NULL, NULL),
(56, 7, 184, 'ABX-Minilyse 1 Liter', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 20, 'imported', NULL, 1, 1, '2025-09-28 13:38:42', '2025-09-28 13:38:42', NULL, NULL, NULL, NULL, NULL),
(57, 7, 185, 'Benedicts Solution 500ml Bottle', '500ml Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 21, 'imported', NULL, 1, 1, '2025-09-28 13:38:42', '2025-09-28 13:38:42', NULL, NULL, NULL, NULL, NULL),
(58, 7, 186, 'Bilirubin liquicolor (for Manual Analyzer) 2x100ml/ 200test', '2x100ml/ 200test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 22, 'imported', NULL, 1, 1, '2025-09-28 13:38:42', '2025-09-28 13:38:42', NULL, NULL, NULL, NULL, NULL),
(59, 7, 187, 'Blood grouping reagent Anti1-A (10 ml/Vial)', '(10 ml/Vial)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 23, 'imported', NULL, 1, 1, '2025-09-28 13:38:43', '2025-09-28 13:38:43', NULL, NULL, NULL, NULL, NULL),
(60, 7, 188, 'Blood grouping reagent Anti1-B (10 ml/Vial)', '(10 ml/Vial)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 24, 'imported', NULL, 1, 1, '2025-09-28 13:38:43', '2025-09-28 13:38:43', NULL, NULL, NULL, NULL, NULL),
(61, 7, 189, 'Blood grouping reagent Anti-D (Rh) (10 ml/Vial)', '(10 ml/Vial)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 25, 'imported', NULL, 1, 1, '2025-09-28 13:38:43', '2025-09-28 13:38:43', NULL, NULL, NULL, NULL, NULL),
(62, 7, 190, 'Blood Grouping Reagent Anti-AB(10 ml/vail)', 'P/Vail', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 26, 'imported', NULL, 1, 1, '2025-09-28 13:38:43', '2025-09-28 13:38:43', NULL, NULL, NULL, NULL, NULL),
(63, 7, 191, 'Blood glucose reagent 10ml', 'liter', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 27, 'imported', NULL, 1, 1, '2025-09-28 13:38:43', '2025-09-28 13:38:43', NULL, NULL, NULL, NULL, NULL),
(64, 7, 192, 'Bilirubin Total R1: 644 ml, R2: 611 ml (1200 Test/Pack)', 'Pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 28, 'imported', NULL, 1, 1, '2025-09-28 13:38:43', '2025-09-28 13:38:43', NULL, NULL, NULL, NULL, NULL),
(65, 7, 193, 'Blood Bag', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 29, 'imported', NULL, 1, 1, '2025-09-28 13:38:43', '2025-09-28 13:38:43', NULL, NULL, NULL, NULL, NULL),
(66, 7, 194, 'Bnuella = Abortus, Melitensis', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 30, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(67, 7, 195, 'Blood roller mixtuer', 'Per Piece', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 31, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(68, 7, 196, 'Bilirubin D+T (For semi Auto Biochemistry Analyzer 2x100m', '200 Test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 32, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(69, 7, 197, 'Benzodiazepine', 'P/Strip', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 33, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(70, 7, 198, 'Calcium (For manual analyzer)', '(For manual analyzer)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 34, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(71, 7, 199, 'Cholesterol kit (For manual analyzer) 4x250ml', '4x250ml', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 35, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(72, 7, 200, 'Creatinine Liquicolor (for Manual Analyzer) 200ml/200test', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 36, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(73, 7, 201, 'Creatinine (for manual analyzer), 200 ml/200 Test', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 37, 'imported', NULL, 1, 1, '2025-09-28 13:38:44', '2025-09-28 13:38:44', NULL, NULL, NULL, NULL, NULL),
(74, 7, 202, 'Cell Clean', 'Box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 38, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(75, 7, 203, 'Cell Counter Reagent', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 39, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(76, 7, 204, 'CRP (complete test kil) 100test kit', '100test kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 40, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(77, 7, 205, 'Cassette, (12\'\'15\'\')', 'Per/pc', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 41, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(78, 7, 206, 'Cassette, (10\'\'12\'\')', 'Per/pc', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 42, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(79, 7, 207, 'Calcium R1: 1012 ml (500 Test/Pack)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 43, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(80, 7, 208, 'Cholesterol R1: 1044 ml (2000 Test/Pack)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 44, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(81, 7, 209, 'C-Reactive Protein R1: 240 ml, R2: 210 ml (400 Test/Pack)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 45, 'imported', NULL, 1, 1, '2025-09-28 13:38:45', '2025-09-28 13:38:45', NULL, NULL, NULL, NULL, NULL),
(82, 7, 210, 'Creatinine R1: 544 ml, R2: 511 ml (1250 Test/Pack)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 46, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(83, 7, 211, 'Crystal Iodine 100gm', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 47, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(84, 7, 212, 'Carbolic Acid', 'kg', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 48, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(85, 7, 213, 'cTnI Standard Pack Size', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 49, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(86, 7, 214, 'cTnI Calivrator(Backmun)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 50, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(87, 7, 215, 'Centrifuge machine', 'Per Piece', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 51, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(88, 7, 216, 'Cover slip', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 52, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(89, 7, 217, 'Cannabinoids', 'P/Strip', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 53, 'imported', NULL, 1, 1, '2025-09-28 13:38:46', '2025-09-28 13:38:46', NULL, NULL, NULL, NULL, NULL),
(90, 7, 218, 'Cider wood oil', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 54, 'imported', NULL, 1, 1, '2025-09-28 13:38:47', '2025-09-28 13:38:47', NULL, NULL, NULL, NULL, NULL),
(91, 7, 219, 'Dip Stick for urine Suger, 50 test', 'Box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 55, 'imported', NULL, 1, 1, '2025-09-28 13:38:47', '2025-09-28 13:38:47', NULL, NULL, NULL, NULL, NULL),
(92, 7, 220, 'Dengue NS1 (Device)', 'Box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 56, 'imported', NULL, 1, 1, '2025-09-28 13:38:47', '2025-09-28 13:38:47', NULL, NULL, NULL, NULL, NULL),
(93, 7, 221, 'Dengue IgG, IgM (Device)', 'Box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 57, 'imported', NULL, 1, 1, '2025-09-28 13:38:47', '2025-09-28 13:38:47', NULL, NULL, NULL, NULL, NULL),
(94, 7, 222, 'Dip Stick Strip for Urine Sg, Gl, Pr, Ph.(4-parameters) 100 tests/box', 'Box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 58, 'imported', NULL, 1, 1, '2025-09-28 13:38:47', '2025-09-28 13:38:47', NULL, NULL, NULL, NULL, NULL),
(95, 7, 223, 'Dialunt ,20 litter can', 'Can', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 59, 'imported', NULL, 1, 1, '2025-09-28 13:38:47', '2025-09-28 13:38:47', NULL, NULL, NULL, NULL, NULL),
(96, 7, 224, 'Drabkins solution Hb%(500ml bottle)', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 60, 'imported', NULL, 1, 1, '2025-09-28 13:38:48', '2025-09-28 13:38:48', NULL, NULL, NULL, NULL, NULL),
(97, 7, 225, 'Dope Test kit', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 61, 'imported', NULL, 1, 1, '2025-09-28 13:38:48', '2025-09-28 13:38:48', NULL, NULL, NULL, NULL, NULL),
(98, 7, 226, 'Distilled Water (500 ml) 500ml /bottle', 'per bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 62, 'imported', NULL, 1, 1, '2025-09-28 13:38:48', '2025-09-28 13:38:48', NULL, NULL, NULL, NULL, NULL),
(99, 7, 227, 'Disposable syringe 5 cc', 'Per piece', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 63, 'imported', NULL, 1, 1, '2025-09-28 13:38:48', '2025-09-28 13:38:48', NULL, NULL, NULL, NULL, NULL),
(100, 7, 228, 'Digital X-ray film (10?14?) Compatible with FUJIFILM', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 64, 'imported', NULL, 1, 1, '2025-09-28 13:38:48', '2025-09-28 13:38:48', NULL, NULL, NULL, NULL, NULL),
(101, 7, 230, 'Dental X-ray film, 100Pc/Pack', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 66, 'imported', NULL, 1, 1, '2025-09-28 13:38:48', '2025-09-28 13:38:48', NULL, NULL, NULL, NULL, NULL),
(102, 7, 231, 'ECG Gel', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 67, 'imported', NULL, 1, 1, '2025-09-28 13:38:49', '2025-09-28 13:38:49', NULL, NULL, NULL, NULL, NULL),
(103, 7, 232, 'ECG Paper Channel, 6/3 channel', 'Per Role', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 68, 'imported', NULL, 1, 1, '2025-09-28 13:38:49', '2025-09-28 13:38:49', NULL, NULL, NULL, NULL, NULL),
(104, 7, 233, 'Ebra Elite H-Clean(50 ml/Vial)', 'Set', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 69, 'imported', NULL, 1, 1, '2025-09-28 13:38:49', '2025-09-28 13:38:49', NULL, NULL, NULL, NULL, NULL),
(105, 7, 234, 'Ebra H-360 Dill(20 Litres)', 'Set', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 70, 'imported', NULL, 1, 1, '2025-09-28 13:38:49', '2025-09-28 13:38:49', NULL, NULL, NULL, NULL, NULL),
(106, 7, 235, 'Ebra H-360 Lyse (500ml)', 'Set', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 71, 'imported', NULL, 1, 1, '2025-09-28 13:38:49', '2025-09-28 13:38:49', NULL, NULL, NULL, NULL, NULL),
(107, 7, 236, 'Erba Lyte plus Reagent pack(1000ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 72, 'imported', NULL, 1, 1, '2025-09-28 13:38:49', '2025-09-28 13:38:49', NULL, NULL, NULL, NULL, NULL),
(108, 7, 237, 'Erba Lyte K, electrode fill solution(15ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 73, 'imported', NULL, 1, 1, '2025-09-28 13:38:49', '2025-09-28 13:38:49', NULL, NULL, NULL, NULL, NULL),
(109, 7, 238, 'Erba Lyte Na,cl,ph electrode fill solution(15ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 74, 'imported', NULL, 1, 1, '2025-09-28 13:38:50', '2025-09-28 13:38:50', NULL, NULL, NULL, NULL, NULL),
(110, 7, 239, 'Erba Lyte ca Electrode fill solution(15ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 75, 'imported', NULL, 1, 1, '2025-09-28 13:38:50', '2025-09-28 13:38:50', NULL, NULL, NULL, NULL, NULL),
(111, 7, 240, 'Erba Lyte reference Electrode fill solution (15ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 76, 'imported', NULL, 1, 1, '2025-09-28 13:38:50', '2025-09-28 13:38:50', NULL, NULL, NULL, NULL, NULL),
(112, 7, 241, 'Erba Lyte QC solution(100ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 77, 'imported', NULL, 1, 1, '2025-09-28 13:38:50', '2025-09-28 13:38:50', NULL, NULL, NULL, NULL, NULL),
(113, 7, 242, 'Erba Lyte CA QC solution(100ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 78, 'imported', NULL, 1, 1, '2025-09-28 13:38:50', '2025-09-28 13:38:50', NULL, NULL, NULL, NULL, NULL),
(114, 7, 243, 'Erba Lyte Urine Diluent(100ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 79, 'imported', NULL, 1, 1, '2025-09-28 13:38:50', '2025-09-28 13:38:50', NULL, NULL, NULL, NULL, NULL),
(115, 7, 244, 'Erba Lyte NA conditioner solution(100ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 80, 'imported', NULL, 1, 1, '2025-09-28 13:38:50', '2025-09-28 13:38:50', NULL, NULL, NULL, NULL, NULL),
(116, 7, 245, 'Erba Lyte cleaning solution(100ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 81, 'imported', NULL, 1, 1, '2025-09-28 13:38:51', '2025-09-28 13:38:51', NULL, NULL, NULL, NULL, NULL),
(117, 7, 246, 'Erba Lyte co2 standard fill solution (100ml)', 'Per Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 82, 'imported', NULL, 1, 1, '2025-09-28 13:38:51', '2025-09-28 13:38:51', NULL, NULL, NULL, NULL, NULL),
(118, 7, 247, 'ESR (Visson pro Analyzer machine supprotrd)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 83, 'imported', NULL, 1, 1, '2025-09-28 13:38:51', '2025-09-28 13:38:51', NULL, NULL, NULL, NULL, NULL),
(119, 7, 248, 'ESR Fluid', '500ml/bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 84, 'imported', NULL, 1, 1, '2025-09-28 13:38:51', '2025-09-28 13:38:51', NULL, NULL, NULL, NULL, NULL),
(120, 7, 249, 'EC Cartdidge S (Erba)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 85, 'imported', NULL, 1, 1, '2025-09-28 13:38:51', '2025-09-28 13:38:51', NULL, NULL, NULL, NULL, NULL),
(121, 7, 250, 'Eusol Solution, 450ml', 'Pieces', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 86, 'imported', NULL, 1, 1, '2025-09-28 13:38:52', '2025-09-28 13:38:52', NULL, NULL, NULL, NULL, NULL),
(122, 7, 251, 'EDTA Tube', 'Tube', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 87, 'imported', NULL, 1, 1, '2025-09-28 13:38:52', '2025-09-28 13:38:52', NULL, NULL, NULL, NULL, NULL),
(123, 7, 252, 'ECG paper (6 Channel) (210mm*140mm size) 12pic per pack', 'pakt', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 88, 'imported', NULL, 1, 1, '2025-09-28 13:38:52', '2025-09-28 13:38:52', NULL, NULL, NULL, NULL, NULL),
(124, 7, 253, 'ep tips standard 0. 1-10 micro 1000 per box', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 89, 'imported', NULL, 1, 1, '2025-09-28 13:38:52', '2025-09-28 13:38:52', NULL, NULL, NULL, NULL, NULL),
(125, 7, 254, 'ep tips standard 2-200 micro 1000 per bo', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 90, 'imported', NULL, 1, 1, '2025-09-28 13:38:52', '2025-09-28 13:38:52', NULL, NULL, NULL, NULL, NULL),
(126, 7, 255, 'ep tips standard 50-1000 micro 1000 per box', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 91, 'imported', NULL, 1, 1, '2025-09-28 13:38:53', '2025-09-28 13:38:53', NULL, NULL, NULL, NULL, NULL),
(127, 7, 256, 'Ethanol 100% (2.5 liter)', 'jar', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 92, 'imported', NULL, 1, 1, '2025-09-28 13:38:53', '2025-09-28 13:38:53', NULL, NULL, NULL, NULL, NULL),
(128, 7, 257, 'Eugenol 100ml', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 93, 'imported', NULL, 1, 1, '2025-09-28 13:38:53', '2025-09-28 13:38:53', NULL, NULL, NULL, NULL, NULL),
(129, 7, 258, 'Elite H 580 Diluent (20 ltre)', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 94, 'imported', NULL, 1, 1, '2025-09-28 13:38:53', '2025-09-28 13:38:53', NULL, NULL, NULL, NULL, NULL),
(130, 7, 259, 'Elite H 580 Lyse-1(500ml)', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 95, 'imported', NULL, 1, 1, '2025-09-28 13:38:54', '2025-09-28 13:38:54', NULL, NULL, NULL, NULL, NULL),
(131, 7, 260, 'Elite H 580 Lyse-2(500ml)', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 96, 'imported', NULL, 1, 1, '2025-09-28 13:38:54', '2025-09-28 13:38:54', NULL, NULL, NULL, NULL, NULL),
(132, 7, 261, 'Elite H 580 Lyse-3 (1 ltre)', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 97, 'imported', NULL, 1, 1, '2025-09-28 13:38:54', '2025-09-28 13:38:54', NULL, NULL, NULL, NULL, NULL),
(133, 7, 262, 'Elite H clean (50ml)', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 98, 'imported', NULL, 1, 1, '2025-09-28 13:38:54', '2025-09-28 13:38:54', NULL, NULL, NULL, NULL, NULL),
(134, 7, 263, 'Eosin red powder', 'pk', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 99, 'imported', NULL, 1, 1, '2025-09-28 13:38:54', '2025-09-28 13:38:54', NULL, NULL, NULL, NULL, NULL),
(135, 7, 264, 'FT4(Backmun) Standard Pack Size', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 100, 'imported', NULL, 1, 1, '2025-09-28 13:38:54', '2025-09-28 13:38:54', NULL, NULL, NULL, NULL, NULL),
(136, 7, 265, 'FT3(Backmun) Standard Pack Size', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 101, 'imported', NULL, 1, 1, '2025-09-28 13:38:55', '2025-09-28 13:38:55', NULL, NULL, NULL, NULL, NULL),
(137, 7, 266, 'Febrile Antigen with bracelet vial', 'P/vail', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 102, 'imported', NULL, 1, 1, '2025-09-28 13:38:55', '2025-09-28 13:38:55', NULL, NULL, NULL, NULL, NULL),
(138, 7, 267, 'Formaldehyde 37-40% 2.5 liter/bottle', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 103, 'imported', NULL, 1, 1, '2025-09-28 13:38:55', '2025-09-28 13:38:55', NULL, NULL, NULL, NULL, NULL),
(139, 7, 268, 'Geimsa stain powder (25gm Pack)', '100test kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 104, 'imported', NULL, 1, 1, '2025-09-28 13:38:55', '2025-09-28 13:38:55', NULL, NULL, NULL, NULL, NULL),
(140, 7, 269, 'Glass slide 72pcs Pack', '72pcs Pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 105, 'imported', NULL, 1, 1, '2025-09-28 13:38:55', '2025-09-28 13:38:55', NULL, NULL, NULL, NULL, NULL),
(141, 7, 270, 'Glucose (For Manual Analyzer) 1000ml / 1000test', '1000ml / 1000test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 106, 'imported', NULL, 1, 1, '2025-09-28 13:38:55', '2025-09-28 13:38:55', NULL, NULL, NULL, NULL, NULL),
(142, 7, 271, 'Glucose LS (mono Reagent) (4 x 250=1000: R1 = 4 x 250ml: R2 = 1 x 3ml)', 'Box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 107, 'imported', NULL, 1, 1, '2025-09-28 13:38:55', '2025-09-28 13:38:55', NULL, NULL, NULL, NULL, NULL),
(143, 7, 272, 'Gonorea (Device)', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 108, 'imported', NULL, 1, 1, '2025-09-28 13:38:56', '2025-09-28 13:38:56', NULL, NULL, NULL, NULL, NULL),
(144, 7, 273, 'G.P Point', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 109, 'imported', NULL, 1, 1, '2025-09-28 13:38:56', '2025-09-28 13:38:56', NULL, NULL, NULL, NULL, NULL),
(145, 7, 274, 'QC NORM (4*5ml)', 'Per Vail', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 110, 'imported', NULL, 1, 1, '2025-09-28 13:38:56', '2025-09-28 13:38:56', NULL, NULL, NULL, NULL, NULL),
(146, 7, 275, 'QC PATH (4*5ml)', 'Per Vail', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 111, 'imported', NULL, 1, 1, '2025-09-28 13:38:56', '2025-09-28 13:38:56', NULL, NULL, NULL, NULL, NULL),
(147, 7, 276, 'Glycerine pure', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 112, 'imported', NULL, 1, 1, '2025-09-28 13:38:56', '2025-09-28 13:38:56', NULL, NULL, NULL, NULL, NULL),
(148, 7, 277, 'H Pylori Devices', 'Devices', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 113, 'imported', NULL, 1, 1, '2025-09-28 13:38:56', '2025-09-28 13:38:56', NULL, NULL, NULL, NULL, NULL),
(149, 7, 278, 'HbsAg Strip/Devices  30 test', '30 test/pcs', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 114, 'imported', NULL, 1, 1, '2025-09-28 13:38:56', '2025-09-28 13:38:56', NULL, NULL, NULL, NULL, NULL),
(150, 7, 279, 'HIV Strip/Device (25 tast pack)', '(25 tast pack)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 115, 'imported', NULL, 1, 1, '2025-09-28 13:38:57', '2025-09-28 13:38:57', NULL, NULL, NULL, NULL, NULL),
(151, 7, 280, 'HCV Strip/Device(25 tast pack)', '(25 tast pack)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 116, 'imported', NULL, 1, 1, '2025-09-28 13:38:57', '2025-09-28 13:38:57', NULL, NULL, NULL, NULL, NULL),
(152, 7, 281, 'HDL Cholesterol 100ml', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 117, 'imported', NULL, 1, 1, '2025-09-28 13:38:57', '2025-09-28 13:38:57', NULL, NULL, NULL, NULL, NULL),
(153, 7, 282, 'Hanger, (12\'\'15\'\')', 'Per/pc', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 118, 'imported', NULL, 1, 1, '2025-09-28 13:38:57', '2025-09-28 13:38:57', NULL, NULL, NULL, NULL, NULL),
(154, 7, 283, 'Hanger, (10\'\'12\'\')', 'Per/pc', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 119, 'imported', NULL, 1, 1, '2025-09-28 13:38:57', '2025-09-28 13:38:57', NULL, NULL, NULL, NULL, NULL),
(155, 7, 284, 'Hemoglobin = 200 test reagent (analyzen)', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 120, 'imported', NULL, 1, 1, '2025-09-28 13:38:57', '2025-09-28 13:38:57', NULL, NULL, NULL, NULL, NULL),
(156, 7, 285, 'Hematology analyzer machine with UPS', 'Per Piece', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 121, 'imported', NULL, 1, 1, '2025-09-28 13:38:58', '2025-09-28 13:38:58', NULL, NULL, NULL, NULL, NULL),
(157, 7, 286, 'Hematology analyzer Reagent(package)', 'Per Package', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 122, 'imported', NULL, 1, 1, '2025-09-28 13:38:58', '2025-09-28 13:38:58', NULL, NULL, NULL, NULL, NULL),
(158, 7, 287, 'Hemocue Devices', 'Devices', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 123, 'imported', NULL, 1, 1, '2025-09-28 13:38:58', '2025-09-28 13:38:58', NULL, NULL, NULL, NULL, NULL),
(159, 7, 288, 'HbAic = 100 test reagent', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 124, 'imported', NULL, 1, 1, '2025-09-28 13:38:58', '2025-09-28 13:38:58', NULL, NULL, NULL, NULL, NULL),
(160, 7, 289, 'Hexisol 100 ml/bottle', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 125, 'imported', NULL, 1, 1, '2025-09-28 13:38:58', '2025-09-28 13:38:58', NULL, NULL, NULL, NULL, NULL),
(161, 7, 290, 'Hydrogen Per Oxide (100 ml bottle)', 'bottlr', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 126, 'imported', NULL, 1, 1, '2025-09-28 13:38:58', '2025-09-28 13:38:58', NULL, NULL, NULL, NULL, NULL),
(162, 7, 291, 'Hard plaster', 'pk', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 127, 'imported', NULL, 1, 1, '2025-09-28 13:38:58', '2025-09-28 13:38:58', NULL, NULL, NULL, NULL, NULL),
(163, 7, 292, 'Intensifying Screen, (12\'\'15\'\')', 'Per/pc', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 128, 'imported', NULL, 1, 1, '2025-09-28 13:38:59', '2025-09-28 13:38:59', NULL, NULL, NULL, NULL, NULL),
(164, 7, 293, 'Intensifying Screen, (10\'\'12\'\')', 'Per/pc', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 129, 'imported', NULL, 1, 1, '2025-09-28 13:38:59', '2025-09-28 13:38:59', NULL, NULL, NULL, NULL, NULL),
(165, 7, 294, 'I.GG /IGM for Dengue (laa)', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 130, 'imported', NULL, 1, 1, '2025-09-28 13:38:59', '2025-09-28 13:38:59', NULL, NULL, NULL, NULL, NULL),
(166, 7, 295, 'I.GG /IGM for Dengue (lam)', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 131, 'imported', NULL, 1, 1, '2025-09-28 13:38:59', '2025-09-28 13:38:59', NULL, NULL, NULL, NULL, NULL),
(167, 7, 296, 'IGE reagent 100 test', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 132, 'imported', NULL, 1, 1, '2025-09-28 13:38:59', '2025-09-28 13:38:59', NULL, NULL, NULL, NULL, NULL),
(168, 7, 297, 'Iodine solution (500 ml/bottle)', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 133, 'imported', NULL, 1, 1, '2025-09-28 13:38:59', '2025-09-28 13:38:59', NULL, NULL, NULL, NULL, NULL),
(169, 7, 298, 'Impression Alginate Material', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 134, 'imported', NULL, 1, 1, '2025-09-28 13:39:00', '2025-09-28 13:39:00', NULL, NULL, NULL, NULL, NULL),
(170, 7, 299, 'LDL (For Manual Analyzer)', '100 Test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 135, 'imported', NULL, 1, 1, '2025-09-28 13:39:00', '2025-09-28 13:39:00', NULL, NULL, NULL, NULL, NULL),
(171, 7, 300, 'Local anesthesia spray 10%', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 136, 'imported', NULL, 1, 1, '2025-09-28 13:39:00', '2025-09-28 13:39:00', NULL, NULL, NULL, NULL, NULL),
(172, 7, 301, 'Lugol\'s iodine solution- 500ml', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 137, 'imported', NULL, 1, 1, '2025-09-28 13:39:00', '2025-09-28 13:39:00', NULL, NULL, NULL, NULL, NULL),
(173, 7, 302, 'Leishman powder 25gm/', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 138, 'imported', NULL, 1, 1, '2025-09-28 13:39:00', '2025-09-28 13:39:00', NULL, NULL, NULL, NULL, NULL),
(174, 7, 303, 'Leishman stain solution', 'Per ltr', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 139, 'imported', NULL, 1, 1, '2025-09-28 13:39:00', '2025-09-28 13:39:00', NULL, NULL, NULL, NULL, NULL),
(175, 7, 304, 'Lyzer Cell, 500 ml', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 140, 'imported', NULL, 1, 1, '2025-09-28 13:39:01', '2025-09-28 13:39:01', NULL, NULL, NULL, NULL, NULL),
(176, 7, 305, 'Jelly for U. S. G Machine 100gm/tube', '100gm/tube', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 141, 'imported', NULL, 1, 1, '2025-09-28 13:39:01', '2025-09-28 13:39:01', NULL, NULL, NULL, NULL, NULL),
(177, 7, 306, 'Jelly for E. C. G Machine 100gm/tube', '100gm/tube', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 142, 'imported', NULL, 1, 1, '2025-09-28 13:39:01', '2025-09-28 13:39:01', NULL, NULL, NULL, NULL, NULL),
(178, 7, 307, 'Malaria WB device 40test kit', '40test kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 143, 'imported', NULL, 1, 1, '2025-09-28 13:39:01', '2025-09-28 13:39:01', NULL, NULL, NULL, NULL, NULL),
(179, 7, 308, 'Methylated spirit 1ltr/ Bottle', '1ltr/ Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 144, 'imported', NULL, 1, 1, '2025-09-28 13:39:01', '2025-09-28 13:39:01', NULL, NULL, NULL, NULL, NULL),
(180, 7, 309, 'M.P (Device)', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 145, 'imported', NULL, 1, 1, '2025-09-28 13:39:01', '2025-09-28 13:39:01', NULL, NULL, NULL, NULL, NULL),
(181, 7, 310, 'Mixing Pad 3^3 Inch', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 146, 'imported', NULL, 1, 1, '2025-09-28 13:39:01', '2025-09-28 13:39:01', NULL, NULL, NULL, NULL, NULL),
(182, 7, 311, 'Mercury Triple Distilled', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 147, 'imported', NULL, 1, 1, '2025-09-28 13:39:02', '2025-09-28 13:39:02', NULL, NULL, NULL, NULL, NULL),
(183, 7, 312, 'Methyl Alcohol (methanol) Original Actinon fre', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 148, 'imported', NULL, 1, 1, '2025-09-28 13:39:02', '2025-09-28 13:39:02', NULL, NULL, NULL, NULL, NULL),
(184, 7, 313, 'One Time Bandage', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 149, 'imported', NULL, 1, 1, '2025-09-28 13:39:02', '2025-09-28 13:39:02', NULL, NULL, NULL, NULL, NULL),
(185, 7, 314, 'Opiates', 'P/Strip', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 150, 'imported', NULL, 1, 1, '2025-09-28 13:39:02', '2025-09-28 13:39:02', NULL, NULL, NULL, NULL, NULL),
(186, 7, 315, 'Povidine Iodide Oinrment USP 6% (25gm Tube)', '(25gm Tube)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 151, 'imported', NULL, 1, 1, '2025-09-28 13:39:02', '2025-09-28 13:39:02', NULL, NULL, NULL, NULL, NULL),
(187, 7, 316, 'Povidine Iodide USP 10% (1 litre jar)', '(1 litre jar)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 152, 'imported', NULL, 1, 1, '2025-09-28 13:39:02', '2025-09-28 13:39:02', NULL, NULL, NULL, NULL, NULL),
(188, 7, 317, 'PATH R1: 45 ml, R1: 120 ml', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 153, 'imported', NULL, 1, 1, '2025-09-28 13:39:03', '2025-09-28 13:39:03', NULL, NULL, NULL, NULL, NULL),
(189, 7, 318, 'Pregnancy test 25test kit', '25test kit box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 154, 'imported', NULL, 1, 1, '2025-09-28 13:39:03', '2025-09-28 13:39:03', NULL, NULL, NULL, NULL, NULL),
(190, 7, 319, 'Protcus = OXK,OX2,OX19', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 155, 'imported', NULL, 1, 1, '2025-09-28 13:39:03', '2025-09-28 13:39:03', NULL, NULL, NULL, NULL, NULL),
(191, 7, 320, 'Proteus OXK (5ml /kit )', 'per kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 156, 'imported', NULL, 1, 1, '2025-09-28 13:39:03', '2025-09-28 13:39:03', NULL, NULL, NULL, NULL, NULL),
(192, 7, 321, 'Proteus OX2 (5ml /kit )', 'per kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 157, 'imported', NULL, 1, 1, '2025-09-28 13:39:03', '2025-09-28 13:39:03', NULL, NULL, NULL, NULL, NULL),
(193, 7, 322, 'Proteus OX19 (5ml /kit )', 'per kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 158, 'imported', NULL, 1, 1, '2025-09-28 13:39:03', '2025-09-28 13:39:03', NULL, NULL, NULL, NULL, NULL),
(194, 7, 323, 'Probe Cleanser Solution ( 1 bottle)', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 159, 'imported', NULL, 1, 1, '2025-09-28 13:39:04', '2025-09-28 13:39:04', NULL, NULL, NULL, NULL, NULL),
(195, 7, 324, 'Paraffin wax (Solid)/Kg', 'kg', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 160, 'imported', NULL, 1, 1, '2025-09-28 13:39:04', '2025-09-28 13:39:04', NULL, NULL, NULL, NULL, NULL),
(196, 7, 325, 'Plaster of Paris (Ordinary Plaster) 25kg/bag', 'bag', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 161, 'imported', NULL, 1, 1, '2025-09-28 13:39:04', '2025-09-28 13:39:04', NULL, NULL, NULL, NULL, NULL),
(197, 7, 326, 'Pregnancy test kit(25test/kit)', 'per kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 162, 'imported', NULL, 1, 1, '2025-09-28 13:39:04', '2025-09-28 13:39:04', NULL, NULL, NULL, NULL, NULL),
(198, 7, 327, 'Potassium Iodine', 'kg', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 163, 'imported', NULL, 1, 1, '2025-09-28 13:39:05', '2025-09-28 13:39:05', NULL, NULL, NULL, NULL, NULL),
(199, 7, 328, 'Pulp Devitalize', 'pk', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 164, 'imported', NULL, 1, 1, '2025-09-28 13:39:05', '2025-09-28 13:39:05', NULL, NULL, NULL, NULL, NULL),
(200, 7, 329, 'RA test latex 100test', '100test box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 165, 'imported', NULL, 1, 1, '2025-09-28 13:39:05', '2025-09-28 13:39:05', NULL, NULL, NULL, NULL, NULL),
(201, 7, 330, 'Red Tube', 'Tube', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 166, 'imported', NULL, 1, 1, '2025-09-28 13:39:05', '2025-09-28 13:39:05', NULL, NULL, NULL, NULL, NULL),
(202, 7, 331, 'Reaction Vessel(Backmun)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 167, 'imported', NULL, 1, 1, '2025-09-28 13:39:05', '2025-09-28 13:39:05', NULL, NULL, NULL, NULL, NULL),
(203, 7, 332, 'Rectified Sprit(clear) 99% Ethanol', 'Per litre', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 168, 'imported', NULL, 1, 1, '2025-09-28 13:39:06', '2025-09-28 13:39:06', NULL, NULL, NULL, NULL, NULL),
(204, 7, 333, 'Root canal sealer', '14gm Power', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 169, 'imported', NULL, 1, 1, '2025-09-28 13:39:06', '2025-09-28 13:39:06', NULL, NULL, NULL, NULL, NULL),
(205, 7, 334, 'S. G. O. T (kinetic) (For Manual Analyzer) 5100ml', '(For Manual Analyzer) 5100ml', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 170, 'imported', NULL, 1, 1, '2025-09-28 13:39:06', '2025-09-28 13:39:06', NULL, NULL, NULL, NULL, NULL),
(206, 7, 335, 'S. G. P. T (kinetic) (For Manual Analyzer) 5100ml', '(For Manual Analyzer) 5100ml', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 171, 'imported', NULL, 1, 1, '2025-09-28 13:39:06', '2025-09-28 13:39:06', NULL, NULL, NULL, NULL, NULL),
(207, 7, 336, 'Syplish Strips (TPHA) 100 test/kit', 'kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 172, 'imported', NULL, 1, 1, '2025-09-28 13:39:07', '2025-09-28 13:39:07', NULL, NULL, NULL, NULL, NULL),
(208, 7, 337, 'S. Total cholesterol liquicolor 100ml', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 173, 'imported', NULL, 1, 1, '2025-09-28 13:39:07', '2025-09-28 13:39:07', NULL, NULL, NULL, NULL, NULL),
(209, 7, 338, 'Serum Ueria. 500 test', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 174, 'imported', NULL, 1, 1, '2025-09-28 13:39:07', '2025-09-28 13:39:07', NULL, NULL, NULL, NULL, NULL),
(210, 7, 339, 'Serum bilirubin liquicilor 100 ml', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 175, 'imported', NULL, 1, 1, '2025-09-28 13:39:07', '2025-09-28 13:39:07', NULL, NULL, NULL, NULL, NULL),
(211, 7, 340, 'Substrate Standard Pack Size', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 176, 'imported', NULL, 1, 1, '2025-09-28 13:39:07', '2025-09-28 13:39:07', NULL, NULL, NULL, NULL, NULL),
(212, 7, 341, 'Surgical Mask', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 177, 'imported', NULL, 1, 1, '2025-09-28 13:39:08', '2025-09-28 13:39:08', NULL, NULL, NULL, NULL, NULL),
(213, 7, 342, 'Serum electrolyte', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 178, 'imported', NULL, 1, 1, '2025-09-28 13:39:08', '2025-09-28 13:39:08', NULL, NULL, NULL, NULL, NULL),
(214, 7, 343, 'S. Creatinine 200 ml/200 test', 'kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 179, 'imported', NULL, 1, 1, '2025-09-28 13:39:08', '2025-09-28 13:39:08', NULL, NULL, NULL, NULL, NULL),
(215, 7, 344, 'Semi Automatic Biochemistry Analyzer washing solution (500ml)', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 180, 'imported', NULL, 1, 1, '2025-09-28 13:39:08', '2025-09-28 13:39:08', NULL, NULL, NULL, NULL, NULL),
(216, 7, 345, 'Silver alloy (30gm/pack)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 181, 'imported', NULL, 1, 1, '2025-09-28 13:39:09', '2025-09-28 13:39:09', NULL, NULL, NULL, NULL, NULL),
(217, 7, 346, 'Serum Amylase Re-Agent. R-1=200test. R-2=200ml', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 182, 'imported', NULL, 1, 1, '2025-09-28 13:39:09', '2025-09-28 13:39:09', NULL, NULL, NULL, NULL, NULL),
(218, 7, 347, 'Serum Calcium Re-Agent. 500test', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 183, 'imported', NULL, 1, 1, '2025-09-28 13:39:09', '2025-09-28 13:39:09', NULL, NULL, NULL, NULL, NULL),
(219, 7, 348, 'Sodium Hypochlorite solution 5.25% (To be used in Nepro Hemodialysis machine)', '5 liters/cane', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 184, 'imported', NULL, 1, 1, '2025-09-28 13:39:09', '2025-09-28 13:39:09', NULL, NULL, NULL, NULL, NULL),
(220, 7, 349, 'TSH, 96 Test', 'Kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 185, 'imported', NULL, 1, 1, '2025-09-28 13:39:09', '2025-09-28 13:39:09', NULL, NULL, NULL, NULL, NULL),
(221, 7, 350, 'TSH Calivrator(Backmun) Standard Pack Size', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 186, 'imported', NULL, 1, 1, '2025-09-28 13:39:09', '2025-09-28 13:39:09', NULL, NULL, NULL, NULL, NULL),
(222, 7, 351, 'Triglyceride (For Manual Analyzer) 4x100ML/400Test', '4x100ML/400Test per vail', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 187, 'imported', NULL, 1, 1, '2025-09-28 13:39:10', '2025-09-28 13:39:10', NULL, NULL, NULL, NULL, NULL),
(223, 7, 352, 'Tri-Glycerides liquicolor 100ml', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 188, 'imported', NULL, 1, 1, '2025-09-28 13:39:10', '2025-09-28 13:39:10', NULL, NULL, NULL, NULL, NULL),
(224, 7, 353, 'Triglycerides R1: 1044 ml (2000 Test/Pack)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 189, 'imported', NULL, 1, 1, '2025-09-28 13:39:10', '2025-09-28 13:39:10', NULL, NULL, NULL, NULL, NULL),
(225, 7, 354, 'Tourniquet', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 190, 'imported', NULL, 1, 1, '2025-09-28 13:39:10', '2025-09-28 13:39:10', NULL, NULL, NULL, NULL, NULL),
(226, 7, 355, 'TPHA', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 191, 'imported', NULL, 1, 1, '2025-09-28 13:39:11', '2025-09-28 13:39:11', NULL, NULL, NULL, NULL, NULL),
(227, 7, 356, 'Test Tube (12 x 100)', 'pcs', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 192, 'imported', NULL, 1, 1, '2025-09-28 13:39:11', '2025-09-28 13:39:11', NULL, NULL, NULL, NULL, NULL),
(228, 7, 357, 'TSI Media', 'pk', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 193, 'imported', NULL, 1, 1, '2025-09-28 13:39:11', '2025-09-28 13:39:11', NULL, NULL, NULL, NULL, NULL),
(229, 7, 358, 'Urea (For Manual Analyzer) 10x50ml', '10x50ml', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 194, 'imported', NULL, 1, 1, '2025-09-28 13:39:11', '2025-09-28 13:39:11', NULL, NULL, NULL, NULL, NULL),
(230, 7, 359, 'Uric Acid (For Manual Analyzer) 10x50ml', '10x50ml', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 195, 'imported', NULL, 1, 1, '2025-09-28 13:39:12', '2025-09-28 13:39:12', NULL, NULL, NULL, NULL, NULL),
(231, 7, 360, 'Ultra Sound Printer Paper, 110mm (W) x 20m (L)', '110mm (W) x 20m (L)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 196, 'imported', NULL, 1, 1, '2025-09-28 13:39:12', '2025-09-28 13:39:12', NULL, NULL, NULL, NULL, NULL),
(232, 7, 361, 'USG Paper', 'Roll', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 197, 'imported', NULL, 1, 1, '2025-09-28 13:39:12', '2025-09-28 13:39:12', NULL, NULL, NULL, NULL, NULL),
(233, 7, 362, 'Uric Acie (for manual analyzer), 10*50 ml', 'Bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 198, 'imported', NULL, 1, 1, '2025-09-28 13:39:12', '2025-09-28 13:39:12', NULL, NULL, NULL, NULL, NULL),
(234, 7, 363, 'Uric Acid R1: 544 ml, R2: 511 ml (1000 Test/Pack)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 199, 'imported', NULL, 1, 1, '2025-09-28 13:39:12', '2025-09-28 13:39:12', NULL, NULL, NULL, NULL, NULL),
(235, 7, 364, 'Urinanalysis Strip for sugar+ Albumin +PH', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 200, 'imported', NULL, 1, 1, '2025-09-28 13:39:12', '2025-09-28 13:39:12', NULL, NULL, NULL, NULL, NULL),
(236, 7, 365, 'Ultra Glossy Paper (High Glossy)', 'Box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 201, 'imported', NULL, 1, 1, '2025-09-28 13:39:12', '2025-09-28 13:39:12', NULL, NULL, NULL, NULL, NULL),
(237, 7, 366, 'Urine Reagent strips (glucose, protine ph)', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 202, 'imported', NULL, 1, 1, '2025-09-28 13:39:13', '2025-09-28 13:39:13', NULL, NULL, NULL, NULL, NULL),
(238, 7, 367, 'Urinery Collection Cup', 'pcs', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 203, 'imported', NULL, 1, 1, '2025-09-28 13:39:13', '2025-09-28 13:39:13', NULL, NULL, NULL, NULL, NULL),
(239, 7, 368, 'Uric 3v-gp, 100 Piece Pack', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 204, 'imported', NULL, 1, 1, '2025-09-28 13:39:13', '2025-09-28 13:39:13', NULL, NULL, NULL, NULL, NULL),
(240, 7, 369, 'Uric 2v(100 strip)', 'pakt', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 205, 'imported', NULL, 1, 1, '2025-09-28 13:39:13', '2025-09-28 13:39:13', NULL, NULL, NULL, NULL, NULL),
(241, 7, 370, 'Urine Sample pot', 'Pieces', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 206, 'imported', NULL, 1, 1, '2025-09-28 13:39:13', '2025-09-28 13:39:13', NULL, NULL, NULL, NULL, NULL),
(242, 7, 371, 'Ultra sonogram Gel. 100gm tube', 'Pieces', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 207, 'imported', NULL, 1, 1, '2025-09-28 13:39:13', '2025-09-28 13:39:13', NULL, NULL, NULL, NULL, NULL),
(243, 7, 372, 'VDRL (RPR) (Complete test kit) 100test kit', '100test kit', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 208, 'imported', NULL, 1, 1, '2025-09-28 13:39:13', '2025-09-28 13:39:13', NULL, NULL, NULL, NULL, NULL),
(244, 7, 373, 'VDRL tests (25 test pack)', '25 test pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 209, 'imported', NULL, 1, 1, '2025-09-28 13:39:14', '2025-09-28 13:39:14', NULL, NULL, NULL, NULL, NULL),
(245, 7, 374, 'Vaseline (White)', 'Kg', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 210, 'imported', NULL, 1, 1, '2025-09-28 13:39:14', '2025-09-28 13:39:14', NULL, NULL, NULL, NULL, NULL),
(246, 7, 375, 'Widal test (Complete test kit) AO 5ml Vial/100test', 'AO 5ml Vial/100test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 211, 'imported', NULL, 1, 1, '2025-09-28 13:39:14', '2025-09-28 13:39:14', NULL, NULL, NULL, NULL, NULL),
(247, 7, 376, 'Widal test (Complete test kit) BH 5ml Vial/100test', 'BH 5ml Vial/100test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 212, 'imported', NULL, 1, 1, '2025-09-28 13:39:14', '2025-09-28 13:39:14', NULL, NULL, NULL, NULL, NULL),
(248, 7, 377, 'Widal test (Complete test kit) TH 5ml Vial/100test', 'TH 5ml Vial/100test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 213, 'imported', NULL, 1, 1, '2025-09-28 13:39:14', '2025-09-28 13:39:14', NULL, NULL, NULL, NULL, NULL),
(249, 7, 378, 'Widal test (AH) 10ml', '100test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 214, 'imported', NULL, 1, 1, '2025-09-28 13:39:14', '2025-09-28 13:39:14', NULL, NULL, NULL, NULL, NULL),
(250, 7, 379, 'Widal test (TO) 10ml', '100test', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 215, 'imported', NULL, 1, 1, '2025-09-28 13:39:14', '2025-09-28 13:39:14', NULL, NULL, NULL, NULL, NULL),
(251, 7, 380, 'Wash Buffer(Backmun)', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 216, 'imported', NULL, 1, 1, '2025-09-28 13:39:15', '2025-09-28 13:39:15', NULL, NULL, NULL, NULL, NULL),
(252, 7, 381, 'Washing solution for manual analizer 100 ml', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 217, 'imported', NULL, 1, 1, '2025-09-28 13:39:15', '2025-09-28 13:39:15', NULL, NULL, NULL, NULL, NULL),
(253, 7, 382, 'X-Ray Developer 10ltr/can', '10ltr/can Packet', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 218, 'imported', NULL, 1, 1, '2025-09-28 13:39:15', '2025-09-28 13:39:15', NULL, NULL, NULL, NULL, NULL),
(254, 7, 383, 'X-Ray film 100 sheets/ box (12 inc x15inc)', '(12 inc x15inc) box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 219, 'imported', NULL, 1, 1, '2025-09-28 13:39:15', '2025-09-28 13:39:15', NULL, NULL, NULL, NULL, NULL),
(255, 7, 384, 'X-Ray film 100 sheets/ box (10 inc x12inc)', '(10 inc x12inc) box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 220, 'imported', NULL, 1, 1, '2025-09-28 13:39:15', '2025-09-28 13:39:15', NULL, NULL, NULL, NULL, NULL),
(256, 7, 385, 'X-Ray film 100 sheets/ box (8 inc x10inc)', '(8 inc x10inc)', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 221, 'imported', NULL, 1, 1, '2025-09-28 13:39:15', '2025-09-28 13:39:15', NULL, NULL, NULL, NULL, NULL),
(257, 7, 386, 'X-ray film (Dental with liquid)', 'box', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 222, 'imported', NULL, 1, 1, '2025-09-28 13:39:16', '2025-09-28 13:39:16', NULL, NULL, NULL, NULL, NULL),
(258, 7, 387, 'X-Ray fixing salt 10ltr/can', '10ltr/can Packet', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 223, 'imported', NULL, 1, 1, '2025-09-28 13:39:16', '2025-09-28 13:39:16', NULL, NULL, NULL, NULL, NULL),
(259, 7, 388, 'XL MULTICALIBRATOR R1: 43 ml', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 224, 'imported', NULL, 1, 1, '2025-09-28 13:39:16', '2025-09-28 13:39:16', NULL, NULL, NULL, NULL, NULL),
(260, 7, 389, 'XL Wash R1: 4100 ml', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 225, 'imported', NULL, 1, 1, '2025-09-28 13:39:16', '2025-09-28 13:39:16', NULL, NULL, NULL, NULL, NULL),
(261, 7, 390, 'XL Auto Wash AC/AL R1: 544 ml, R2: 544 ml', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 226, 'imported', NULL, 1, 1, '2025-09-28 13:39:16', '2025-09-28 13:39:16', NULL, NULL, NULL, NULL, NULL),
(262, 7, 391, 'Xylene 2.5 liter bottle', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 227, 'imported', NULL, 1, 1, '2025-09-28 13:39:16', '2025-09-28 13:39:16', NULL, NULL, NULL, NULL, NULL),
(263, 7, 392, 'Yellow tips.1000Pc/Pack', 'pack', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 228, 'imported', NULL, 1, 1, '2025-09-28 13:39:16', '2025-09-28 13:39:16', NULL, NULL, NULL, NULL, NULL),
(264, 7, 393, 'Zine Oxide Powder 25gm/Pk', '25gm/Pk', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 229, 'imported', NULL, 1, 1, '2025-09-28 13:39:17', '2025-09-28 13:39:17', NULL, NULL, NULL, NULL, NULL),
(265, 7, 394, 'Zinc Oxide 500gm Bottle', 'bottle', '', 9, NULL, NULL, NULL, '', 1, NULL, NULL, 'medium', 1, NULL, 230, 'imported', NULL, 1, 1, '2025-09-28 13:39:17', '2025-09-28 13:39:17', NULL, NULL, NULL, NULL, NULL);

-- Table structure for table `product_merges`
DROP TABLE IF EXISTS `product_merges`;
CREATE TABLE `product_merges` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `merged_product_id` INT NOT NULL,
  `merged_product_name` VARCHAR NOT NULL,
  `original_products` TEXT NOT NULL,
  `merge_reason` TEXT NULL,
  `merge_metadata` TEXT NULL,
  `merged_by` INT NOT NULL,
  `merged_at` TEXT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `product_merges`
INSERT INTO `product_merges` (`id`, `merged_product_id`, `merged_product_name`, `original_products`, `merge_reason`, `merge_metadata`, `merged_by`, `merged_at`, `created_at`, `updated_at`) VALUES
(1, 165, 'Merged Product Test', '[{\"id\":1,\"name\":\"Test Product - Step by Step\",\"description\":null,\"country_of_origin\":null,\"category_id\":null,\"subcategory_id\":null,\"price\":null,\"measurement_unit\":null},{\"id\":2,\"name\":\"Partially Complete Product\",\"description\":null,\"country_of_origin\":\"USA\",\"category_id\":1,\"subcategory_id\":null,\"price\":null,\"measurement_unit\":null},{\"id\":3,\"name\":\"Complete Product\",\"description\":\"This is a complete product with all details.\",\"country_of_origin\":\"Canada\",\"category_id\":1,\"subcategory_id\":null,\"price\":\"29.99\",\"measurement_unit\":null}]', 'Testing merge functionality', NULL, 1, '2025-09-27 07:42:34', '2025-09-27 07:42:34', '2025-09-27 07:42:34');

-- Table structure for table `tender_bids`
DROP TABLE IF EXISTS `tender_bids`;
CREATE TABLE `tender_bids` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `tender_id` INT NOT NULL,
  `company_name` VARCHAR NOT NULL,
  `bid_value` TEXT NOT NULL,
  `position` INT NULL,
  `submitted_at` TEXT NOT NULL,
  `notes` TEXT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `tender_bids`
INSERT INTO `tender_bids` (`id`, `tender_id`, `company_name`, `bid_value`, `position`, `submitted_at`, `notes`, `created_at`, `updated_at`) VALUES
(1, 1, 'ABC Office Solutions Ltd.', 32000, 2, '2025-09-22 10:48:53', 'Complete office equipment package with 2-year warranty', '2025-09-27 10:48:53', '2025-09-27 11:06:23'),
(2, 1, 'TechCorp Bangladesh', 34500, 3, '2025-09-23 10:48:53', 'Premium quality equipment with extended support', '2025-09-27 10:48:53', '2025-09-27 11:06:23'),
(3, 1, 'Modern Office Supplies', 36800, 4, '2025-09-24 10:48:53', 'High-end equipment with installation service', '2025-09-27 10:48:53', '2025-09-27 11:06:23'),
(4, 1, 'Digital Solutions BD', 38200, 5, '2025-09-25 10:48:53', 'Latest technology with comprehensive training', '2025-09-27 10:48:53', '2025-09-27 11:06:23'),
(5, 3, 'Stationery World Ltd.', 62000, 1, '2025-09-24 10:48:53', 'Bulk supply with quarterly delivery schedule', '2025-09-27 10:48:53', '2025-09-27 10:48:53'),
(6, 3, 'Office Mart Bangladesh', 64500, 2, '2025-09-25 10:48:53', 'Premium quality stationery with fast delivery', '2025-09-27 10:48:54', '2025-09-27 10:48:54'),
(7, 3, 'Paper Plus Solutions', 67200, 3, '2025-09-26 10:48:53', 'Eco-friendly products with recycling program', '2025-09-27 10:48:54', '2025-09-27 10:48:54'),
(8, 1, 'New Tech Solutions Ltd.', 30000, 1, '2025-09-27 11:06:00', 'Competitive bid with excellent service guarantee', '2025-09-27 11:06:22', '2025-09-27 11:06:23'),
(9, 6, 'Tech Solutions A', 95000, 3, '2025-09-26 18:54:25', 'Test bid for active tender', '2025-09-27 20:54:25', '2025-09-27 20:54:26'),
(10, 6, 'IT Services B', 87000, 1, '2025-09-26 16:54:25', 'Test bid for active tender', '2025-09-27 20:54:25', '2025-09-27 20:54:26'),
(11, 6, 'Computer Corp C', 92000, 2, '2025-09-27 01:54:25', 'Test bid for active tender', '2025-09-27 20:54:25', '2025-09-27 20:54:26');

-- Table structure for table `document_types`
DROP TABLE IF EXISTS `document_types`;
CREATE TABLE `document_types` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR NOT NULL,
  `description` TEXT NULL,
  `is_active` TEXT NOT NULL DEFAULT ''1'',
  `sort_order` INT NOT NULL DEFAULT ''0'',
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `document_types`
INSERT INTO `document_types` (`id`, `name`, `description`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 'TIN (Tax Identification Number) document', 'Tax Identification Number certificate issued by the National Board of Revenue', 1, 1, '2025-09-27 20:14:18', '2025-09-27 20:14:18'),
(2, 'BIN (Business Identification Number) document', 'Business Identification Number certificate for business registration', 1, 2, '2025-09-27 20:14:18', '2025-09-27 20:14:18'),
(3, 'Audit report', 'Latest audited financial statements prepared by a certified auditor', 1, 3, '2025-09-27 20:14:18', '2025-09-27 20:14:18'),
(4, 'Trade License', 'Valid trade license issued by the local government authority', 1, 4, '2025-09-27 20:14:18', '2025-09-27 20:14:18'),
(5, 'Bank Guarantee', 'Bank guarantee or security deposit as per tender requirements', 1, 5, '2025-09-27 20:14:19', '2025-09-27 20:14:19'),
(6, 'Company Registration Certificate', 'Certificate of incorporation or company registration document', 1, 6, '2025-09-27 20:14:19', '2025-09-27 20:14:19');

-- Table structure for table `tender_document_requirements`
DROP TABLE IF EXISTS `tender_document_requirements`;
CREATE TABLE `tender_document_requirements` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `tender_id` INT NOT NULL,
  `document_type_id` INT NOT NULL,
  `is_required` TEXT NULL DEFAULT '1',
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `tender_document_requirements`
INSERT INTO `tender_document_requirements` (`id`, `tender_id`, `document_type_id`, `is_required`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 1, '2025-09-27 22:18:55', '2025-09-27 22:18:55'),
(2, 3, 3, 1, '2025-09-27 22:18:56', '2025-09-27 22:18:56'),
(3, 3, 5, 1, '2025-09-27 22:18:56', '2025-09-27 22:18:56'),
(4, 3, 6, 1, '2025-09-27 22:18:56', '2025-09-27 22:18:56'),
(5, 7, 1, 1, '2025-09-27 22:21:40', '2025-09-27 22:21:40'),
(6, 7, 2, 1, '2025-09-27 22:21:40', '2025-09-27 22:21:40'),
(7, 7, 3, 1, '2025-09-27 22:21:40', '2025-09-27 22:21:40'),
(8, 7, 4, 1, '2025-09-27 22:21:40', '2025-09-27 22:21:40'),
(9, 7, 5, 1, '2025-09-27 22:21:40', '2025-09-27 22:21:40'),
(10, 7, 6, 1, '2025-09-27 22:21:40', '2025-09-27 22:21:40');

-- Table structure for table `tender_document_submissions`
DROP TABLE IF EXISTS `tender_document_submissions`;
CREATE TABLE `tender_document_submissions` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `tender_id` INT NOT NULL,
  `document_type_id` INT NOT NULL,
  `status` VARCHAR(255) NULL DEFAULT '"pending"',
  `notes` TEXT NULL,
  `submitted_at` TEXT NULL,
  `submitted_by` INT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `tender_document_submissions`
INSERT INTO `tender_document_submissions` (`id`, `tender_id`, `document_type_id`, `status`, `notes`, `submitted_at`, `submitted_by`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'pending', NULL, NULL, NULL, '2025-09-27 20:40:56', '2025-09-27 20:42:07'),
(2, 1, 2, 'pending', NULL, NULL, NULL, '2025-09-27 20:40:58', '2025-09-27 20:42:09'),
(3, 1, 3, 'pending', NULL, NULL, NULL, '2025-09-27 20:40:59', '2025-09-27 20:42:10'),
(4, 1, 4, 'pending', NULL, NULL, NULL, '2025-09-27 20:41:01', '2025-09-27 20:42:11'),
(5, 1, 6, 'pending', NULL, NULL, NULL, '2025-09-27 20:41:22', '2025-09-27 20:42:12');

-- Table structure for table `users`
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR NOT NULL,
  `email` VARCHAR NOT NULL,
  `email_verified_at` TEXT NULL,
  `password` VARCHAR NOT NULL,
  `remember_token` VARCHAR NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL,
  `role` VARCHAR NOT NULL DEFAULT '"viewer"',
  `deleted_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `users`
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `deleted_at`) VALUES
(1, 'Admin User', 'admin@example.com', '2025-09-26 20:49:46', '$2y$12$afFy7UhkM2Kgq95200Z8HuQRSBxoZ2l3D3LrQUpdwwSCXwcOFkhIW', NULL, '2025-09-26 20:49:46', '2025-09-26 20:49:46', 'admin', NULL),
(2, 'Manager User', 'manager@example.com', '2025-09-26 20:49:47', '$2y$12$S.bxEKQDQ.ZY79YNg.a6HuPq3wgWxVorsJV1ilOOZhh0H92DTxQei', NULL, '2025-09-26 20:49:47', '2025-09-26 20:49:47', 'manager', NULL),
(3, 'Viewer User', 'viewer@example.com', '2025-09-26 20:49:47', '$2y$12$mYcuRoqpOIr7i7qlArAtjOORHCVvcKjiDmdhQbDcnsUPkH0CdCJle', NULL, '2025-09-26 20:49:47', '2025-09-26 20:49:47', 'viewer', NULL),
(4, 'Tender Specialist', 'tender.creator@example.com', '2025-09-27 22:05:37', '$2y$12$gCE18Lqgl9hNxzbzG1cBkesYyC5WAy8rDHkeo42G0PdhiqFl6KXy6', NULL, '2025-09-27 22:05:38', '2025-09-27 22:05:38', 'tender_creator', NULL),
(5, 'Product Specialist', 'product.creator@example.com', '2025-09-27 22:05:37', '$2y$12$6gOD/MmzmBj36mmI3hKty.wSFy3rYKx/mcqh/jj7NVMEi7oOUNfZO', NULL, '2025-09-27 22:05:38', '2025-09-27 22:26:48', 'product_creator', NULL);

-- Table structure for table `incomes`
DROP TABLE IF EXISTS `incomes`;
CREATE TABLE `incomes` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR NOT NULL,
  `description` TEXT NULL,
  `amount` TEXT NOT NULL,
  `category` VARCHAR NOT NULL,
  `payment_method` VARCHAR NOT NULL,
  `source` VARCHAR NULL,
  `reference_number` VARCHAR NULL,
  `income_date` TEXT NOT NULL,
  `status` VARCHAR NOT NULL DEFAULT ''received'',
  `receipt_file` VARCHAR NULL,
  `created_by` INT NOT NULL,
  `updated_by` INT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL,
  `deleted_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `incomes`
INSERT INTO `incomes` (`id`, `title`, `description`, `amount`, `category`, `payment_method`, `source`, `reference_number`, `income_date`, `status`, `receipt_file`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Tender Project Alpha Revenue', 'Payment received for completed tender project', 25000, 'tender_revenue', 'bank_transfer', 'ABC Corporation', 'INV-2024-001', '2025-09-23 06:56:21', 'received', NULL, 1, 1, '2025-09-28 06:56:21', '2025-09-28 06:56:21', NULL),
(2, 'Product Sales - Q4', 'Quarterly product sales revenue', 15000, 'product_sales', 'online_payment', 'Various Customers', 'SALES-Q4-2024', '2025-09-18 06:56:21', 'received', NULL, 1, 1, '2025-09-28 06:56:21', '2025-09-28 06:56:21', NULL),
(3, 'Consulting Services', 'Business consulting services provided', 8000, 'consulting_fees', 'check', 'XYZ Ltd', 'CONS-2024-003', '2025-09-13 06:56:21', 'received', NULL, 1, 1, '2025-09-28 06:56:21', '2025-09-28 06:56:21', NULL),
(4, 'Interest Income', 'Bank interest earned', 500, 'interest_income', 'bank_transfer', 'First National Bank', 'INT-2024-12', '2025-09-26 06:56:21', 'received', NULL, 1, 1, '2025-09-28 06:56:21', '2025-09-28 06:56:21', NULL);

-- Table structure for table `expenses`
DROP TABLE IF EXISTS `expenses`;
CREATE TABLE `expenses` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR NOT NULL,
  `description` TEXT NULL,
  `amount` TEXT NOT NULL,
  `category` VARCHAR NOT NULL,
  `payment_method` VARCHAR NOT NULL,
  `vendor` VARCHAR NULL,
  `invoice_number` VARCHAR NULL,
  `expense_date` TEXT NOT NULL,
  `status` VARCHAR NOT NULL DEFAULT ''pending'',
  `receipt_file` VARCHAR NULL,
  `approved_by` INT NULL,
  `approved_at` TEXT NULL,
  `approval_notes` TEXT NULL,
  `created_by` INT NOT NULL,
  `updated_by` INT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL,
  `deleted_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `expenses`
INSERT INTO `expenses` (`id`, `title`, `description`, `amount`, `category`, `payment_method`, `vendor`, `invoice_number`, `expense_date`, `status`, `receipt_file`, `approved_by`, `approved_at`, `approval_notes`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Office Rent - December', 'Monthly office space rental', 3000, 'rent', 'bank_transfer', 'Property Management Co.', 'RENT-DEC-2024', '2025-09-25 06:56:22', 'paid', NULL, NULL, NULL, NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(2, 'Marketing Campaign', 'Digital marketing and advertising expenses', 2500, 'marketing', 'credit_card', 'Digital Marketing Agency', 'MKT-2024-045', '2025-09-21 06:56:22', 'approved', NULL, NULL, NULL, NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(3, 'Office Supplies', 'Stationery and office equipment', 750, 'office_supplies', 'cash', 'Office Depot', 'OFC-2024-123', '2025-09-16 06:56:22', 'paid', NULL, NULL, NULL, NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(4, 'Software Licenses', 'Annual software subscription renewals', 1200, 'software_licenses', 'online_payment', 'Software Solutions Inc.', 'SW-2024-789', '2025-09-08 06:56:22', 'pending', NULL, NULL, NULL, NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(5, 'Utilities - December', 'Electricity and internet bills', 450, 'utilities', 'bank_transfer', 'City Utilities', 'UTIL-DEC-2024', '2025-09-27 06:56:22', 'pending', NULL, NULL, NULL, NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(6, 'Anowar Bhai', 'Test', 50000, 'other_expenses', 'cash', NULL, NULL, '2025-09-28 00:00:00', 'paid', NULL, NULL, NULL, NULL, 1, 1, '2025-09-28 11:47:28', '2025-09-28 11:47:36', NULL);

-- Table structure for table `investments`
DROP TABLE IF EXISTS `investments`;
CREATE TABLE `investments` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR NOT NULL,
  `description` TEXT NULL,
  `amount` TEXT NOT NULL,
  `type` VARCHAR NOT NULL,
  `source` VARCHAR NOT NULL,
  `interest_rate` TEXT NULL,
  `term_months` INT NULL,
  `monthly_payment` TEXT NULL,
  `start_date` TEXT NOT NULL,
  `maturity_date` TEXT NULL,
  `next_payment_date` TEXT NULL,
  `outstanding_balance` TEXT NOT NULL DEFAULT ''0'',
  `total_paid` TEXT NOT NULL DEFAULT ''0'',
  `status` VARCHAR NOT NULL DEFAULT ''active'',
  `terms_conditions` TEXT NULL,
  `contract_file` VARCHAR NULL,
  `created_by` INT NOT NULL,
  `updated_by` INT NOT NULL,
  `created_at` TEXT NULL,
  `updated_at` TEXT NULL,
  `deleted_at` TEXT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `investments`
INSERT INTO `investments` (`id`, `title`, `description`, `amount`, `type`, `source`, `interest_rate`, `term_months`, `monthly_payment`, `start_date`, `maturity_date`, `next_payment_date`, `outstanding_balance`, `total_paid`, `status`, `terms_conditions`, `contract_file`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Business Expansion Loan', 'Bank loan for business expansion and equipment purchase', 50000, 'bank_loan', 'First National Bank', 6.5, 60, 975, '2025-03-28 06:56:22', '2030-03-28 06:56:22', '2025-10-13 06:56:22', 44000, 6000, 'active', 'Standard business loan terms with monthly payments', NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(2, 'Angel Investment Round A', 'Initial angel investment for startup capital', 100000, 'angel_investment', 'Tech Angels Group', NULL, NULL, NULL, '2024-09-28 06:56:22', NULL, NULL, 0, 0, 'active', '15% equity stake, no repayment required', NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(3, 'Equipment Credit Line', 'Credit line for equipment purchases', 25000, 'credit_line', 'Business Credit Union', 8, 36, 800, '2025-06-28 06:56:22', '2028-06-28 06:56:22', '2025-10-08 06:56:22', 22500, 2500, 'active', 'Revolving credit line for equipment purchases', NULL, 1, 1, '2025-09-28 06:56:22', '2025-09-28 06:56:22', NULL),
(4, 'Afzal bhai', 'Hello', 3000000, 'investor_funding', 'Afzal Bhai', NULL, NULL, NULL, '2025-09-28 00:00:00', NULL, NULL, 3000000, 0, 'active', NULL, NULL, 1, 1, '2025-09-28 11:48:31', '2025-09-28 11:48:31', NULL);

SET FOREIGN_KEY_CHECKS = 1;
