-- Table structure for table `migration_configuration`
--

SET autocommit=0;
COMMIT;

-- Dumped table `migration_configuration` with 0 row(s)
--

--
-- Table structure for table `mill`
--

CREATE TABLE `mill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_start` date DEFAULT NULL,
  `time_start` time DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `time_end` time DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT 0,
  `soap_type_id` char(2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `comment` longtext DEFAULT NULL,
  `mill_name` varchar(255) DEFAULT NULL,
  `lot_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mill_soap_type_id_foreign` (`soap_type_id`),
  CONSTRAINT `mill_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mill`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mill` with 0 row(s)
--

--
-- Table structure for table `mill_items`
--

CREATE TABLE `mill_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(10) unsigned DEFAULT 0,
  `mill_id` int(10) unsigned DEFAULT 0,
  `height_to_mill` decimal(12,3) DEFAULT 0.000 COMMENT 'Peso de entrada',
  `total_height` decimal(12,3) DEFAULT 0.000 COMMENT 'Peso dle insumo ',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`item`)),
  `quantity` decimal(12,3) DEFAULT 0.000 COMMENT 'Peso dle insumo ',
  `item_extra_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`item_extra_data`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mill_items`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mill_items` with 0 row(s)
--

--
-- Table structure for table `mi_tienda_pe`
--

CREATE TABLE `mi_tienda_pe` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` text DEFAULT NULL COMMENT 'Numero de pedido',
  `transaction_code` text DEFAULT NULL COMMENT 'Codigo de pasareña',
  `order_note_id` int(10) unsigned DEFAULT 0,
  `document_id` int(10) unsigned DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mi_tienda_pe`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mi_tienda_pe` with 0 row(s)
--

--
-- Table structure for table `mobile_idempotency_keys`
--

CREATE TABLE `mobile_idempotency_keys` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `idempotency_key` varchar(100) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'processing',
  `model` varchar(20) DEFAULT NULL,
  `record_id` int(10) unsigned DEFAULT NULL,
  `response_payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`response_payload`)),
  `error_message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mik_user_est_key_unique` (`user_id`,`establishment_id`,`idempotency_key`),
  KEY `mobile_idempotency_keys_status_index` (`status`),
  KEY `mobile_idempotency_keys_establishment_id_foreign` (`establishment_id`),
  CONSTRAINT `mobile_idempotency_keys_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mobile_idempotency_keys_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mobile_idempotency_keys`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mobile_idempotency_keys` with 0 row(s)
--

--
-- Table structure for table `mobile_physical_counts`
--

CREATE TABLE `mobile_physical_counts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `establishment_id` int(10) unsigned NOT NULL,
  `warehouse_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'draft',
  `notes` text DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `submitted_at` timestamp NULL DEFAULT NULL,
  `submitted_by` int(10) unsigned DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `approved_by` int(10) unsigned DEFAULT NULL,
  `rejected_at` timestamp NULL DEFAULT NULL,
  `rejected_by` int(10) unsigned DEFAULT NULL,
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `cancelled_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mobile_physical_counts_warehouse_id_status_index` (`warehouse_id`,`status`),
  KEY `mobile_physical_counts_user_id_status_index` (`user_id`,`status`),
  KEY `mobile_physical_counts_submitted_by_foreign` (`submitted_by`),
  KEY `mobile_physical_counts_approved_by_foreign` (`approved_by`),
  KEY `mobile_physical_counts_rejected_by_foreign` (`rejected_by`),
  KEY `mobile_physical_counts_cancelled_by_foreign` (`cancelled_by`),
  KEY `mobile_physical_counts_est_status_created_idx` (`establishment_id`,`status`,`created_at`),
  CONSTRAINT `mobile_physical_counts_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`),
  CONSTRAINT `mobile_physical_counts_cancelled_by_foreign` FOREIGN KEY (`cancelled_by`) REFERENCES `users` (`id`),
  CONSTRAINT `mobile_physical_counts_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `mobile_physical_counts_rejected_by_foreign` FOREIGN KEY (`rejected_by`) REFERENCES `users` (`id`),
  CONSTRAINT `mobile_physical_counts_submitted_by_foreign` FOREIGN KEY (`submitted_by`) REFERENCES `users` (`id`),
  CONSTRAINT `mobile_physical_counts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `mobile_physical_counts_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mobile_physical_counts`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mobile_physical_counts` with 0 row(s)
--

--
-- Table structure for table `mobile_physical_count_events`
--

CREATE TABLE `mobile_physical_count_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `physical_count_id` int(10) unsigned NOT NULL,
  `line_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item_unit_type_id` int(10) unsigned DEFAULT NULL,
  `lot_group_id` int(10) unsigned DEFAULT NULL,
  `barcode` varchar(100) DEFAULT NULL,
  `factor` decimal(12,4) NOT NULL DEFAULT 1.0000,
  `quantity` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `quantity_base` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `source` varchar(30) NOT NULL DEFAULT 'scan',
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mobile_physical_count_events_physical_count_id_item_id_index` (`physical_count_id`,`item_id`),
  KEY `mobile_physical_count_events_line_id_foreign` (`line_id`),
  KEY `mobile_physical_count_events_user_id_foreign` (`user_id`),
  KEY `mobile_physical_count_events_item_id_foreign` (`item_id`),
  KEY `mobile_physical_count_events_item_unit_type_id_foreign` (`item_unit_type_id`),
  KEY `mobile_physical_count_events_lot_group_id_foreign` (`lot_group_id`),
  CONSTRAINT `mobile_physical_count_events_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `mobile_physical_count_events_item_unit_type_id_foreign` FOREIGN KEY (`item_unit_type_id`) REFERENCES `item_unit_types` (`id`),
  CONSTRAINT `mobile_physical_count_events_line_id_foreign` FOREIGN KEY (`line_id`) REFERENCES `mobile_physical_count_lines` (`id`) ON DELETE SET NULL,
  CONSTRAINT `mobile_physical_count_events_lot_group_id_foreign` FOREIGN KEY (`lot_group_id`) REFERENCES `item_lots_group` (`id`),
  CONSTRAINT `mobile_physical_count_events_physical_count_id_foreign` FOREIGN KEY (`physical_count_id`) REFERENCES `mobile_physical_counts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mobile_physical_count_events_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mobile_physical_count_events`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mobile_physical_count_events` with 0 row(s)
--

--
-- Table structure for table `mobile_physical_count_lines`
--

CREATE TABLE `mobile_physical_count_lines` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `physical_count_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item_unit_type_id` int(10) unsigned DEFAULT NULL,
  `lot_group_id` int(10) unsigned DEFAULT NULL,
  `lot_code` varchar(100) DEFAULT NULL,
  `line_key` varchar(160) NOT NULL,
  `counted_qty_base` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `system_qty_snapshot` decimal(12,4) DEFAULT NULL,
  `difference_qty` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `inventory_id` int(10) unsigned DEFAULT NULL,
  `scanned_times` int(10) unsigned NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL,
  `last_counted_by` int(10) unsigned DEFAULT NULL,
  `last_counted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mobile_physical_count_lines_unique` (`physical_count_id`,`line_key`),
  KEY `mobile_physical_count_lines_item_id_lot_group_id_index` (`item_id`,`lot_group_id`),
  KEY `mobile_physical_count_lines_item_unit_type_id_foreign` (`item_unit_type_id`),
  KEY `mobile_physical_count_lines_lot_group_id_foreign` (`lot_group_id`),
  KEY `mobile_physical_count_lines_inventory_id_foreign` (`inventory_id`),
  KEY `mobile_physical_count_lines_last_counted_by_foreign` (`last_counted_by`),
  CONSTRAINT `mobile_physical_count_lines_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`),
  CONSTRAINT `mobile_physical_count_lines_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `mobile_physical_count_lines_item_unit_type_id_foreign` FOREIGN KEY (`item_unit_type_id`) REFERENCES `item_unit_types` (`id`),
  CONSTRAINT `mobile_physical_count_lines_last_counted_by_foreign` FOREIGN KEY (`last_counted_by`) REFERENCES `users` (`id`),
  CONSTRAINT `mobile_physical_count_lines_lot_group_id_foreign` FOREIGN KEY (`lot_group_id`) REFERENCES `item_lots_group` (`id`),
  CONSTRAINT `mobile_physical_count_lines_physical_count_id_foreign` FOREIGN KEY (`physical_count_id`) REFERENCES `mobile_physical_counts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mobile_physical_count_lines`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mobile_physical_count_lines` with 0 row(s)
--

--
-- Table structure for table `mobile_push_devices`
--

SET autocommit=0;
COMMIT;

-- Dumped table `mobile_push_devices` with 0 row(s)
--

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `value` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `order_menu` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `modules`
--

SET autocommit=0;
INSERT INTO `modules` VALUES (1,'documents','Ventas',2,NULL,NULL),(2,'purchases','Compras',7,NULL,NULL),(3,'advanced','Documentos Avanzados',8,NULL,NULL),(4,'reports','Reportes',9,NULL,NULL),(5,'configuration','Configuration',12,NULL,NULL),(6,'pos','Punto de venta (POS)',3,NULL,NULL),(7,'dashboard','Dashboard',1,NULL,NULL),(8,'inventory','Inventario',7,NULL,NULL),(9,'accounting','Contabilidad',10,NULL,NULL),(10,'ecommerce','Ecommerce',4,NULL,NULL),(11,'cuenta','Cuenta',13,NULL,NULL),(12,'finance','Finanzas',11,NULL,NULL),(14,'establishments','Usuarios/Locales & Series',7,NULL,NULL),(15,'hotels','Hoteles',14,NULL,NULL),(16,'documentary-procedure','Trámite documentario',15,NULL,NULL),(17,'items','Productos/Servicios',5,NULL,NULL),(18,'persons','Clientes',6,NULL,NULL),(19,'digemid','Farmacos',15,'2026-07-17 12:15:23','2026-07-17 12:15:23'),(20,'apps','Apps',13,NULL,NULL),(21,'suscription_app','Suscriptiones',16,NULL,NULL),(22,'production_app','Producción',17,NULL,NULL),(23,'restaurant_app','Restaurante',18,NULL,NULL),(24,'full_suscription_app','Suscripción Servicios SAAS',17,NULL,NULL),(25,'generate_link_app','Generador de link de pago',19,NULL,NULL),(26,'app_2_generator','Generador APP 2.0',20,NULL,NULL),(27,'guia','Guia de remisión',3,NULL,NULL),(28,'veterinary','Veterinaria',20,'2026-07-17 12:15:34','2026-07-17 12:15:34'),(29,'clinica','Clínica',20,'2026-07-17 12:15:35','2026-07-17 12:15:35');
COMMIT;

-- Dumped table `modules` with 28 row(s)
--

--
-- Table structure for table `module_levels`
--

CREATE TABLE `module_levels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `value` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `module_id` int(10) unsigned NOT NULL,
  `route_name` varchar(255) DEFAULT NULL,
  `route_path` varchar(255) DEFAULT NULL,
  `label_menu` varchar(3) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `module_levels_module_id_foreign` (`module_id`),
  CONSTRAINT `module_levels_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `module_levels`
--

SET autocommit=0;
INSERT INTO `module_levels` VALUES (1,'new_document','Nuevo comprobante',1,'tenant.documents.create','/documents/create','NC',NULL,NULL),(2,'list_document','L. Comprobantes',1,NULL,NULL,NULL,NULL,NULL),(3,'document_not_sent','Doc. No enviados',1,NULL,NULL,NULL,NULL,NULL),(4,'document_contingengy','Doc. Contingencia',1,NULL,NULL,NULL,NULL,NULL),(5,'catalogs','Catálogos',1,NULL,NULL,NULL,NULL,NULL),(6,'summary_voided','Resúmenes y Anulaciones',1,NULL,NULL,NULL,NULL,NULL),(7,'quotations','Cotizaciones',1,NULL,NULL,NULL,NULL,NULL),(8,'sale_notes','Notas de Venta',1,'tenant.sale_notes.index','/sale-notes','NV',NULL,NULL),(9,'incentives','Comisiones',1,NULL,NULL,NULL,NULL,NULL),(10,'sale-opportunity','Oportunidad de venta',1,NULL,NULL,NULL,NULL,NULL),(11,'contracts','Contratos',1,NULL,NULL,NULL,NULL,NULL),(12,'order-note','Pedidos',1,'tenant.order_notes.index','/order-notes','PED',NULL,NULL),(13,'technical-service','Servicios de soporte técnico',1,NULL,NULL,NULL,NULL,NULL),(14,'regularize_shipping','CPE pendientes de rectificación',1,NULL,NULL,NULL,NULL,NULL),(15,'pos','Punto de venta',6,'tenant.pos.index','/pos','POS',NULL,NULL),(16,'cash','Caja chica POS',6,NULL,NULL,NULL,NULL,NULL),(17,'ecommerce','Ir a la tienda',10,NULL,NULL,NULL,NULL,NULL),(18,'ecommerce_orders','Pedidos',10,NULL,NULL,NULL,NULL,NULL),(19,'ecommerce_items','Productos tienda virtual',10,NULL,NULL,NULL,NULL,NULL),(20,'ecommerce_tags','Etiquetas',10,NULL,NULL,NULL,NULL,NULL),(21,'ecommerce_promotions','Promociones - Banners',10,NULL,NULL,NULL,NULL,NULL),(22,'ecommerce_settings','Configuración',10,NULL,NULL,NULL,NULL,NULL),(23,'items','Productos',17,'tenant.items.index','/items','PRO',NULL,NULL),(24,'items_packs','Packs',17,NULL,NULL,NULL,NULL,NULL),(25,'items_services','Servicios',17,NULL,NULL,NULL,NULL,NULL),(26,'items_categories','Categorías',17,NULL,NULL,NULL,NULL,NULL),(27,'items_brands','Marcas',17,NULL,NULL,NULL,NULL,NULL),(28,'items_lots','Series',17,NULL,NULL,NULL,NULL,NULL),(29,'clients','Clientes',18,NULL,NULL,NULL,NULL,NULL),(30,'clients_types','Tipos de clientes',18,NULL,NULL,NULL,NULL,NULL),(31,'purchases_create','Nueva Compra',2,'tenant.purchases.create','/purchases/create','NC',NULL,NULL),(32,'purchases_list','Listado',2,NULL,NULL,NULL,NULL,NULL),(33,'purchases_orders','Ordenes de compra',2,NULL,NULL,NULL,NULL,NULL),(34,'purchases_expenses','Gastos diversos',2,NULL,NULL,NULL,NULL,NULL),(35,'purchases_suppliers','Proveedores',2,NULL,NULL,NULL,NULL,NULL),(36,'purchases_quotations','Solicitar cotización',2,NULL,NULL,NULL,NULL,NULL),(37,'purchases_fixed_assets_items','Activos fijos - Ítems',2,NULL,NULL,NULL,NULL,NULL),(38,'purchases_fixed_assets_purchases','Activos fijos - Compras',2,NULL,NULL,NULL,NULL,NULL),(39,'inventory','Movimientos',8,'inventory.index','/inventory','INV',NULL,NULL),(40,'inventory_transfers','Traslados',8,NULL,NULL,NULL,NULL,NULL),(41,'inventory_devolutions','Devoluciones',8,NULL,NULL,NULL,NULL,NULL),(42,'inventory_report_kardex','Reporte kardex',8,NULL,NULL,NULL,NULL,NULL),(43,'inventory_report','Reporte inventario',8,NULL,NULL,NULL,NULL,NULL),(44,'inventory_report_valued_kardex','Kardex valorizado',8,NULL,NULL,NULL,NULL,'2026-07-17 12:15:28'),(45,'users','Usuarios',14,'tenant.users.index','/users','USR',NULL,NULL),(46,'users_establishments','Establecimientos',14,'tenant.establishments.index','/establishments','ES',NULL,NULL),(47,'advanced_retentions','Retenciones',3,NULL,NULL,NULL,NULL,NULL),(49,'advanced_perceptions','Percepciones',3,NULL,NULL,NULL,NULL,NULL),(50,'advanced_order_forms','Ordenes de pedido',3,NULL,NULL,NULL,NULL,NULL),(51,'account_report','Exportar reporte',9,NULL,NULL,NULL,NULL,NULL),(52,'account_formats','Exportar formatos',9,NULL,NULL,NULL,NULL,NULL),(53,'account_summary','Reporte resumido - Ventas',9,NULL,NULL,NULL,NULL,NULL),(54,'finances_movements','Movimientos',12,NULL,NULL,NULL,NULL,NULL),(55,'finances_incomes','Ingresos',12,NULL,NULL,NULL,NULL,NULL),(56,'finances_unpaid','Cuentas por cobrar',12,NULL,NULL,NULL,NULL,NULL),(57,'finances_to_pay','Cuentas por pagar',12,NULL,NULL,NULL,NULL,NULL),(58,'finances_payments','Pagos',12,NULL,NULL,NULL,NULL,NULL),(59,'finances_balance','Balance',12,NULL,NULL,NULL,NULL,NULL),(60,'finances_payment_method_types','Ingresos y Egresos - M. Pago',12,NULL,NULL,NULL,NULL,NULL),(61,'account_users_settings','Configuración',11,NULL,NULL,NULL,NULL,NULL),(62,'account_users_list','Lista de pagos',11,NULL,NULL,NULL,NULL,NULL),(63,'hotels_reception','Recepción',15,NULL,NULL,NULL,NULL,NULL),(64,'hotels_rates','Tarifas',15,NULL,NULL,NULL,NULL,NULL),(65,'hotels_floors','Pisos',15,NULL,NULL,NULL,NULL,NULL),(66,'hotels_cats','Categorías',15,NULL,NULL,NULL,NULL,NULL),(67,'hotels_rooms','Habitaciones',15,NULL,NULL,NULL,NULL,NULL),(68,'documentary_offices','Oficinas',16,NULL,NULL,NULL,NULL,NULL),(69,'documentary_process','Procesos',16,NULL,NULL,NULL,NULL,NULL),(70,'documentary_documents','Tipos de documento',16,NULL,NULL,NULL,NULL,NULL),(71,'documentary_actions','Acciones',16,NULL,NULL,NULL,NULL,NULL),(72,'documentary_files','Expedientes',16,NULL,NULL,NULL,NULL,NULL),(73,'digemid','Productos (legado)',19,NULL,NULL,NULL,'2026-07-17 12:15:23','2026-07-17 12:15:23'),(74,'documentary_requirements','Requerimientos',16,NULL,NULL,NULL,'2026-07-17 12:15:23','2026-07-17 12:15:23'),(75,'inventory_item_extra_data','Datos extra de items',8,NULL,NULL,NULL,NULL,NULL),(76,'configuration_company','Empresa',5,'tenant.companies.create','/companies/create','ME',NULL,NULL),(77,'configuration_advance','Avanzado',5,NULL,NULL,NULL,NULL,NULL),(78,'configuration_visual','Visual',5,NULL,NULL,NULL,NULL,NULL),(79,'advanced_purchase_settlements','Liquidaciones de compra',3,NULL,NULL,NULL,NULL,NULL),(80,'suscription_app_client','Cliente',21,NULL,NULL,NULL,NULL,NULL),(81,'suscription_app_service','Servicio',21,NULL,NULL,NULL,NULL,NULL),(82,'suscription_app_payments','Pagos',21,NULL,NULL,NULL,NULL,NULL),(83,'suscription_app_plans','Planes',21,NULL,NULL,NULL,NULL,NULL),(85,'digemid_health_report','Cumplimiento Regulatorio',19,'reports.compliance.index','/prescriptions/digemid/compliance','CUM','2026-07-17 12:15:31','2026-07-17 12:15:31'),(86,'digemid_doctors','Medicos',19,'tenant.prescriptions.doctors.index','/prescriptions/doctors','MED','2026-07-17 12:15:31','2026-07-17 12:15:31'),(87,'digemid_cie10','CIE 10',19,'tenant.prescriptions.cie10.index','/prescriptions/cie10','C10','2026-07-17 12:15:31','2026-07-17 12:15:31'),(88,'digemid_psychotropics_report','Reporte de Psicotropicos',19,'tenant.prescriptions.reports.index','/prescriptions/reports','RPS','2026-07-17 12:15:31','2026-07-17 12:15:31'),(89,'digemid_purchase_reception','Recepcion de productos farmaceuticos',19,'tenant.reports.purchases.format_09.index','/reports/purchases/format_09','RPF','2026-07-17 12:15:31','2026-07-17 12:15:31'),(90,'items_coupons','Cupones',17,NULL,NULL,NULL,'2026-07-17 12:15:31','2026-07-17 12:15:31'),(91,'veterinary','Veterinaria',28,NULL,NULL,NULL,'2026-07-17 12:15:34','2026-07-17 12:15:34'),(92,'vet_panel','Panel',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(93,'vet_pets','Mascotas',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(94,'vet_appointments','Citas / Agenda',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(95,'vet_boardings','Hospedaje',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(96,'vet_reminders','Recordatorios',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(97,'vet_memberships','Membresías',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(98,'vet_reports','Reportes',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(99,'vet_settings','Configuración',28,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(100,'clinica','Clínica',29,NULL,NULL,NULL,'2026-07-17 12:15:35','2026-07-17 12:15:35'),(101,'inventory_reconciliation','Reporte de conciliación de inventario',8,'reports.inventory_reconciliation.index','/reports/inventory-reconciliation','REC','2026-07-30 16:51:14','2026-07-30 16:51:14');
COMMIT;

-- Dumped table `module_levels` with 99 row(s)
--

--
-- Table structure for table `module_level_user`
--

CREATE TABLE `module_level_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module_level_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `module_level_user`
--

SET autocommit=0;
INSERT INTO `module_level_user` VALUES (1,76,0),(2,77,0),(3,78,0),(70,1,2),(71,2,2),(72,3,2),(73,4,2),(74,5,2),(75,6,2),(76,7,2),(77,8,2),(78,9,2),(79,10,2),(80,11,2),(81,12,2),(82,13,2),(83,14,2),(84,15,2),(85,16,2),(86,23,2),(87,24,2),(88,25,2),(89,26,2),(90,27,2),(91,28,2),(92,29,2),(93,30,2),(94,31,2),(95,32,2),(96,33,2),(97,34,2),(98,35,2),(99,36,2),(100,37,2),(101,38,2),(102,39,2),(103,40,2),(104,41,2),(105,42,2),(106,43,2),(107,44,2),(108,75,2),(109,45,2),(110,47,2),(111,49,2),(112,50,2),(113,79,2),(114,51,2),(115,52,2),(116,53,2),(117,54,2),(118,55,2),(119,56,2),(120,57,2),(121,58,2),(122,59,2),(123,60,2),(124,76,2),(125,77,2),(126,78,2),(127,61,2),(128,62,2),(129,1,1),(130,2,1),(131,3,1),(132,4,1),(133,5,1),(134,6,1),(135,7,1),(136,8,1),(137,9,1),(138,10,1),(139,11,1),(140,12,1),(141,13,1),(142,14,1),(143,15,1),(144,16,1),(145,23,1),(146,24,1),(147,25,1),(148,26,1),(149,27,1),(150,28,1),(151,29,1),(152,30,1),(153,31,1),(154,32,1),(155,33,1),(156,34,1),(157,35,1),(158,36,1),(159,37,1),(160,38,1),(161,39,1),(162,40,1),(163,41,1),(164,42,1),(165,43,1),(166,44,1),(167,45,1),(168,46,1),(169,47,1),(170,49,1),(171,50,1),(172,51,1),(173,52,1),(174,53,1),(175,54,1),(176,55,1),(177,56,1),(178,57,1),(179,58,1),(180,59,1),(181,60,1),(182,61,1),(183,62,1),(184,75,1),(185,76,1),(186,77,1),(187,78,1),(188,79,1),(189,85,1),(190,86,1),(191,87,1),(192,88,1),(193,89,1),(194,96,1),(195,97,1),(196,98,1),(197,99,1),(198,85,2),(199,86,2),(200,87,2),(201,88,2),(202,89,2),(203,15,3),(204,16,3),(205,8,4),(206,12,4),(207,14,4),(208,15,4),(209,16,4),(210,23,4),(211,29,4),(212,30,4),(213,31,4),(214,32,4),(215,33,4),(216,34,4),(217,35,4),(218,36,4),(219,37,4),(220,38,4),(221,39,4),(222,40,4),(223,41,4),(224,42,4),(225,43,4),(226,44,4),(227,75,4);
COMMIT;

-- Dumped table `module_level_user` with 161 row(s)
--

--
-- Table structure for table `module_user`
--

CREATE TABLE `module_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `module_user`
--

SET autocommit=0;
INSERT INTO `module_user` VALUES (16,7,2),(17,1,2),(18,6,2),(19,17,2),(20,18,2),(21,2,2),(22,8,2),(23,14,2),(24,3,2),(25,4,2),(26,9,2),(27,12,2),(28,5,2),(29,11,2),(30,19,2),(31,1,1),(32,2,1),(33,3,1),(34,4,1),(35,5,1),(36,6,1),(37,7,1),(38,8,1),(39,9,1),(40,11,1),(41,12,1),(42,14,1),(43,17,1),(44,18,1),(45,19,1),(46,6,3),(47,1,4),(48,6,4),(49,17,4),(50,18,4),(51,2,4),(52,8,4);
COMMIT;

-- Dumped table `module_user` with 37 row(s)
--

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `document_id` int(10) unsigned NOT NULL,
  `note_type` enum('credit','debit') NOT NULL,
  `note_credit_type_id` varchar(255) DEFAULT NULL,
  `note_debit_type_id` varchar(255) DEFAULT NULL,
  `note_description` varchar(255) NOT NULL,
  `affected_document_id` int(10) unsigned DEFAULT NULL,
  `data_affected_document` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data_affected_document`)),
  PRIMARY KEY (`id`),
  KEY `notes_document_id_foreign` (`document_id`),
  KEY `notes_note_credit_type_id_foreign` (`note_credit_type_id`),
  KEY `notes_note_debit_type_id_foreign` (`note_debit_type_id`),
  KEY `notes_affected_document_id_foreign` (`affected_document_id`),
  CONSTRAINT `notes_affected_document_id_foreign` FOREIGN KEY (`affected_document_id`) REFERENCES `documents` (`id`),
  CONSTRAINT `notes_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notes_note_credit_type_id_foreign` FOREIGN KEY (`note_credit_type_id`) REFERENCES `cat_note_credit_types` (`id`),
  CONSTRAINT `notes_note_debit_type_id_foreign` FOREIGN KEY (`note_debit_type_id`) REFERENCES `cat_note_debit_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notes`
--

SET autocommit=0;
COMMIT;

-- Dumped table `notes` with 0 row(s)
--

--
-- Table structure for table `offline_configurations`
--

CREATE TABLE `offline_configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_client` tinyint(1) NOT NULL DEFAULT 0,
  `token_server` varchar(255) DEFAULT NULL,
  `url_server` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offline_configurations`
--

SET autocommit=0;
INSERT INTO `offline_configurations` VALUES (1,0,NULL,NULL,NULL,NULL);
COMMIT;

-- Dumped table `offline_configurations` with 1 row(s)
--

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `external_id` char(36) NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `shipping_address` varchar(255) DEFAULT NULL,
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`items`)),
  `total` decimal(12,2) NOT NULL,
  `reference_payment` varchar(255) NOT NULL,
  `document_external_id` char(36) DEFAULT NULL,
  `number_document` varchar(255) DEFAULT NULL,
  `status_order_id` tinyint(3) unsigned DEFAULT NULL,
  `purchase` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`purchase`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `apply_restaurant` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `orders_status_order_id_foreign` (`status_order_id`),
  CONSTRAINT `orders_status_order_id_foreign` FOREIGN KEY (`status_order_id`) REFERENCES `status_orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

SET autocommit=0;
COMMIT;

-- Dumped table `orders` with 0 row(s)
--

--
-- Table structure for table `order_forms`
--

CREATE TABLE `order_forms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `external_id` char(36) NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `establishment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`establishment`)),
  `soap_type_id` char(2) NOT NULL,
  `state_type_id` char(2) NOT NULL,
  `prefix` varchar(255) NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `observations` text NOT NULL,
  `transport_mode_type_id` varchar(255) NOT NULL,
  `transfer_reason_type_id` varchar(255) NOT NULL,
  `transfer_reason_description` varchar(255) NOT NULL,
  `date_of_shipping` date NOT NULL,
  `transshipment_indicator` tinyint(1) NOT NULL,
  `port_code` varchar(255) DEFAULT NULL,
  `unit_type_id` varchar(255) NOT NULL,
  `total_weight` decimal(10,2) NOT NULL,
  `packages_number` int(11) NOT NULL,
  `container_number` int(11) DEFAULT NULL,
  `origin` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`origin`)),
  `delivery` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`delivery`)),
  `dispatcher_id` int(10) unsigned NOT NULL,
  `driver_id` int(10) unsigned NOT NULL,
  `license_plates` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`license_plates`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `optional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`optional`)),
  `filename` varchar(255) DEFAULT NULL,
  `qr` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_forms_dispatcher_id_foreign` (`dispatcher_id`),
  KEY `order_forms_driver_id_foreign` (`driver_id`),
  KEY `order_forms_user_id_foreign` (`user_id`),
  KEY `order_forms_establishment_id_foreign` (`establishment_id`),
  KEY `order_forms_soap_type_id_foreign` (`soap_type_id`),
  KEY `order_forms_state_type_id_foreign` (`state_type_id`),
  KEY `order_forms_customer_id_foreign` (`customer_id`),
  KEY `order_forms_unit_type_id_foreign` (`unit_type_id`),
  KEY `order_forms_transport_mode_type_id_foreign` (`transport_mode_type_id`),
  KEY `order_forms_transfer_reason_type_id_foreign` (`transfer_reason_type_id`),
  KEY `order_forms_date_of_issue_index` (`date_of_issue`),
  CONSTRAINT `order_forms_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `order_forms_dispatcher_id_foreign` FOREIGN KEY (`dispatcher_id`) REFERENCES `dispatchers` (`id`),
  CONSTRAINT `order_forms_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`),
  CONSTRAINT `order_forms_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `order_forms_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `order_forms_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `order_forms_transfer_reason_type_id_foreign` FOREIGN KEY (`transfer_reason_type_id`) REFERENCES `cat_transfer_reason_types` (`id`),
  CONSTRAINT `order_forms_transport_mode_type_id_foreign` FOREIGN KEY (`transport_mode_type_id`) REFERENCES `cat_transport_mode_types` (`id`),
  CONSTRAINT `order_forms_unit_type_id_foreign` FOREIGN KEY (`unit_type_id`) REFERENCES `cat_unit_types` (`id`),
  CONSTRAINT `order_forms_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_forms`
--

SET autocommit=0;
COMMIT;

-- Dumped table `order_forms` with 0 row(s)
--

--
-- Table structure for table `order_form_items`
--

CREATE TABLE `order_form_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_form_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`item`)),
  `quantity` decimal(12,4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `order_form_items_order_form_id_foreign` (`order_form_id`),
  KEY `order_form_items_item_id_foreign` (`item_id`),
  CONSTRAINT `order_form_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `order_form_items_order_form_id_foreign` FOREIGN KEY (`order_form_id`) REFERENCES `order_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_form_items`
--

SET autocommit=0;
COMMIT;

-- Dumped table `order_form_items` with 0 row(s)
--

--
-- Table structure for table `order_notes`
--

CREATE TABLE `order_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `external_id` char(36) NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `establishment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`establishment`)),
  `soap_type_id` char(2) NOT NULL,
  `state_type_id` char(2) NOT NULL,
  `prefix` char(3) NOT NULL,
  `date_of_issue` date NOT NULL,
  `time_of_issue` time NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `customer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`customer`)),
  `shipping_address` text DEFAULT NULL,
  `currency_type_id` varchar(255) NOT NULL,
  `payment_method_type_id` char(2) DEFAULT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `total_prepayment` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exportation` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_free` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxed` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_unaffected` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exonerated` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_igv` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_igv_free` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_value` decimal(12,2) NOT NULL DEFAULT 0.00,
  `subtotal` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `prepayments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`prepayments`)),
  `guides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`guides`)),
  `related` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`related`)),
  `perception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`perception`)),
  `detraction` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`detraction`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_data`)),
  `filename` varchar(255) DEFAULT NULL,
  `observation` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `quotation_id` int(10) unsigned DEFAULT 0 COMMENT 'Relacion con cotizaciones',
  PRIMARY KEY (`id`),
  KEY `order_notes_user_id_foreign` (`user_id`),
  KEY `order_notes_establishment_id_foreign` (`establishment_id`),
  KEY `order_notes_customer_id_foreign` (`customer_id`),
  KEY `order_notes_soap_type_id_foreign` (`soap_type_id`),
  KEY `order_notes_state_type_id_foreign` (`state_type_id`),
  KEY `order_notes_currency_type_id_foreign` (`currency_type_id`),
  KEY `order_notes_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `order_notes_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `order_notes_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `order_notes_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `order_notes_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `order_notes_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `order_notes_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `order_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_notes`
--

SET autocommit=0;
COMMIT;

-- Dumped table `order_notes` with 0 row(s)
--

--
-- Table structure for table `order_note_items`
--

CREATE TABLE `order_note_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_note_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`item`)),
  `quantity` decimal(12,4) NOT NULL,
  `unit_value` decimal(16,6) NOT NULL,
  `affectation_igv_type_id` varchar(255) NOT NULL,
  `total_base_igv` decimal(12,2) NOT NULL,
  `percentage_igv` decimal(12,2) NOT NULL,
  `total_igv` decimal(12,2) NOT NULL,
  `system_isc_type_id` varchar(255) DEFAULT NULL,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_plastic_bag_taxes` decimal(6,2) DEFAULT 0.00 COMMENT 'Impuesto bolsa plastica',
  `total_taxes` decimal(12,2) NOT NULL,
  `price_type_id` varchar(255) NOT NULL,
  `unit_price` decimal(16,6) NOT NULL,
  `total_value` decimal(12,2) NOT NULL,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attributes`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  `additional_information` longtext DEFAULT NULL COMMENT 'Informacion adcional',
  `warehouse_id` int(10) unsigned DEFAULT NULL,
  `name_product_pdf` longtext DEFAULT NULL COMMENT 'Nombre del producto para el pdf',
  PRIMARY KEY (`id`),
  KEY `order_note_items_order_note_id_foreign` (`order_note_id`),
  KEY `order_note_items_item_id_foreign` (`item_id`),
  KEY `order_note_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `order_note_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `order_note_items_price_type_id_foreign` (`price_type_id`),
  KEY `order_note_items_warehouse_id_foreign` (`warehouse_id`),
  CONSTRAINT `order_note_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `order_note_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `order_note_items_order_note_id_foreign` FOREIGN KEY (`order_note_id`) REFERENCES `order_notes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_note_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `order_note_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`),
  CONSTRAINT `order_note_items_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_note_items`
--

SET autocommit=0;
COMMIT;

-- Dumped table `order_note_items` with 0 row(s)
--

--
-- Table structure for table `origin_addresses`
--

CREATE TABLE `origin_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(255) NOT NULL,
  `location_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`location_id`)),
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `origin_addresses`
--

SET autocommit=0;
COMMIT;

-- Dumped table `origin_addresses` with 0 row(s)
--

--
-- Table structure for table `packaging`
--

CREATE TABLE `packaging` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `soap_type_id` char(2) DEFAULT NULL,
  `item_extra_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`item_extra_data`)),
  `establishment_id` int(10) unsigned DEFAULT NULL,
  `quantity` decimal(8,2) DEFAULT 0.00,
  `number_packages` decimal(8,2) DEFAULT 0.00,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`item`)),
  `observation` longtext DEFAULT NULL,
  `lot_code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `time_start` time DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `time_end` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `packaging_collaborator` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `packaging_soap_type_id_foreign` (`soap_type_id`),
  CONSTRAINT `packaging_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packaging`
--

SET autocommit=0;
COMMIT;

-- Dumped table `packaging` with 0 row(s)
--

--
-- Table structure for table `padrones`
--

CREATE TABLE `padrones` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ruc` varchar(255) NOT NULL,
  `nombre_razon_social` varchar(155) NOT NULL,
  `estado_contribuyente` varchar(100) NOT NULL,
  `condicion_domicilio` varchar(100) NOT NULL,
  `ubigeo` varchar(50) NOT NULL,
  `tipo_via` varchar(20) NOT NULL,
  `nombre_via` varchar(50) NOT NULL,
  `codigo_zona` varchar(155) NOT NULL,
  `tipo_zona` varchar(20) NOT NULL,
  `numero` varchar(155) NOT NULL,
  `interior` varchar(50) NOT NULL,
  `lote` varchar(20) NOT NULL,
  `departamento` varchar(100) NOT NULL,
  `manzana` varchar(20) NOT NULL,
  `kilometro` varchar(20) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `padrones_ruc_index` (`ruc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `padrones`
--

SET autocommit=0;
COMMIT;

-- Dumped table `padrones` with 0 row(s)
--

--
-- Table structure for table `password_resets`
--

SET autocommit=0;
COMMIT;

-- Dumped table `password_resets` with 0 row(s)
--

--
-- Table structure for table `payment_conditions`
--

CREATE TABLE `payment_conditions` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `days` int(11) NOT NULL DEFAULT 0,
  `is_locked` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_conditions`
--

SET autocommit=0;
INSERT INTO `payment_conditions` VALUES ('01','Contado',0,1,1),('02','Crédito',0,1,1);
COMMIT;

-- Dumped table `payment_conditions` with 2 row(s)
--

--
-- Table structure for table `payment_configurations`
--

SET autocommit=0;
COMMIT;

-- Dumped table `payment_configurations` with 1 row(s)
--

--
-- Table structure for table `payment_files`
--

CREATE TABLE `payment_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `payment_type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_index` (`payment_id`,`payment_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_files`
--

SET autocommit=0;
COMMIT;

-- Dumped table `payment_files` with 0 row(s)
--

--
-- Table structure for table `payment_links`
--

CREATE TABLE `payment_links` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `soap_type_id` char(2) NOT NULL,
  `uuid` char(36) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `payment_link_type_id` char(2) NOT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `payment_type` varchar(255) DEFAULT NULL,
  `total` decimal(12,2) NOT NULL,
  `uploaded_filename` varchar(255) DEFAULT NULL,
  `query_transaction` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_links_uuid_unique` (`uuid`),
  KEY `payment_index` (`payment_id`,`payment_type`),
  KEY `payment_links_user_id_foreign` (`user_id`),
  KEY `payment_links_soap_type_id_foreign` (`soap_type_id`),
  KEY `payment_links_payment_link_type_id_foreign` (`payment_link_type_id`),
  CONSTRAINT `payment_links_payment_link_type_id_foreign` FOREIGN KEY (`payment_link_type_id`) REFERENCES `payment_link_types` (`id`),
  CONSTRAINT `payment_links_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `payment_links_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_links`
--

SET autocommit=0;
COMMIT;

-- Dumped table `payment_links` with 0 row(s)
--

--
-- Table structure for table `payment_link_types`
--

CREATE TABLE `payment_link_types` (
  `id` char(2) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_link_types`
--

SET autocommit=0;
INSERT INTO `payment_link_types` VALUES ('01','Yape'),('02','Mercado Pago');
COMMIT;

-- Dumped table `payment_link_types` with 2 row(s)
--

--
-- Table structure for table `payment_method_types`
--

CREATE TABLE `payment_method_types` (
  `id` char(2) NOT NULL,
  `description` varchar(255) NOT NULL,
  `has_card` tinyint(1) NOT NULL DEFAULT 0,
  `charge` decimal(12,2) DEFAULT NULL,
  `number_days` int(11) DEFAULT NULL,
  `is_credit` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Define si es tipo credito',
  `is_cash` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Define si es es efectivo',
  `active_pos` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Visible en POS para contado',
  `pos_bank_account_id` int(10) unsigned DEFAULT NULL COMMENT 'Cuenta bancaria por defecto en POS contado. Null => caja',
  PRIMARY KEY (`id`),
  KEY `payment_method_types_is_credit_index` (`is_credit`),
  KEY `payment_method_types_active_pos_index` (`active_pos`),
  KEY `payment_method_types_pos_bank_account_id_index` (`pos_bank_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_method_types`
--

SET autocommit=0;
INSERT INTO `payment_method_types` VALUES ('01','Efectivo',0,NULL,NULL,0,1,1,NULL),('02','Yape',0,NULL,NULL,0,0,1,NULL),('03','Plin',0,NULL,NULL,0,0,1,NULL),('04','Transferencia',0,NULL,NULL,0,0,1,NULL),('05','Factura a 30 dias',0,NULL,30,1,0,0,NULL),('09','Credito',0,NULL,NULL,1,0,0,NULL);
COMMIT;

-- Dumped table `payment_method_types` with 6 row(s)
--

--
-- Table structure for table `perceptions`
--

SET autocommit=0;
COMMIT;

-- Dumped table `perceptions` with 0 row(s)
--

--
-- Table structure for table `perception_documents`
--

CREATE TABLE `perception_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `perception_id` int(10) unsigned NOT NULL,
  `document_type_id` varchar(255) NOT NULL,
  `number` varchar(255) NOT NULL,
  `date_of_issue` date NOT NULL,
  `date_of_perception` date NOT NULL,
  `currency_type_id` varchar(255) NOT NULL,
  `total_document` decimal(10,2) NOT NULL,
  `total_perception` decimal(10,2) NOT NULL,
  `payments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payments`)),
  `series` varchar(255) NOT NULL,
  `exchange_rate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`exchange_rate`)),
  `total_to_pay` decimal(10,2) NOT NULL,
  `total_payment` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `perception_details_perception_id_foreign` (`perception_id`),
  KEY `perception_documents_document_type_id_foreign` (`document_type_id`),
  KEY `perception_documents_currency_type_id_foreign` (`currency_type_id`),
  CONSTRAINT `perception_details_perception_id_foreign` FOREIGN KEY (`perception_id`) REFERENCES `perceptions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `perception_documents_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `perception_documents_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `perception_documents`
--

SET autocommit=0;
COMMIT;

-- Dumped table `perception_documents` with 0 row(s)
--

--
-- Table structure for table `persons`
--

CREATE TABLE `persons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('customers','suppliers') NOT NULL,
  `identity_document_type_id` varchar(255) NOT NULL,
  `number` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `birthdate` date DEFAULT NULL,
  `gender` char(1) DEFAULT NULL,
  `trade_name` varchar(255) DEFAULT NULL,
  `internal_code` varchar(100) DEFAULT NULL,
  `barcode` varchar(150) DEFAULT NULL,
  `country_id` char(2) NOT NULL,
  `nationality_id` char(2) DEFAULT NULL,
  `department_id` char(2) DEFAULT NULL,
  `province_id` char(4) DEFAULT NULL,
  `district_id` char(6) DEFAULT NULL,
  `address_type_id` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `condition` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `accumulated_points` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT 'sistema por puntos',
  `perception_agent` tinyint(1) NOT NULL DEFAULT 0,
  `person_type_id` int(10) unsigned DEFAULT NULL,
  `contact` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`contact`)),
  `comment` varchar(255) DEFAULT NULL,
  `percentage_perception` decimal(12,2) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `website` text DEFAULT NULL COMMENT 'Sitio Web',
  `zone` longtext DEFAULT NULL COMMENT 'Zona',
  `observation` longtext DEFAULT NULL COMMENT 'Observaciones',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `credit_days` int(10) unsigned DEFAULT 0 COMMENT 'establece los dias de credito',
  `optional_email` longtext DEFAULT NULL COMMENT 'Conjunto de correos de envio',
  `parent_id` int(10) unsigned DEFAULT 0 COMMENT 'Se relaciona con si mismo, numero mayor a 0 es el id del padre.',
  `zone_id` int(10) unsigned DEFAULT NULL,
  `seller_id` int(10) unsigned DEFAULT NULL,
  `has_discount` tinyint(1) NOT NULL DEFAULT 0,
  `discount_type` char(2) NOT NULL DEFAULT '01',
  `discount_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `price_list` tinyint(3) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `persons_identity_document_type_id_foreign` (`identity_document_type_id`),
  KEY `persons_country_id_foreign` (`country_id`),
  KEY `persons_department_id_foreign` (`department_id`),
  KEY `persons_province_id_foreign` (`province_id`),
  KEY `persons_district_id_foreign` (`district_id`),
  KEY `persons_name_index` (`name`),
  KEY `persons_number_index` (`number`),
  KEY `persons_type_index` (`type`),
  KEY `persons_person_type_id_foreign` (`person_type_id`),
  KEY `persons_enabled_index` (`enabled`),
  KEY `persons_address_type_id_foreign` (`address_type_id`),
  KEY `persons_seller_id_index` (`seller_id`),
  KEY `persons_nationality_id_foreign` (`nationality_id`),
  CONSTRAINT `persons_address_type_id_foreign` FOREIGN KEY (`address_type_id`) REFERENCES `cat_address_types` (`id`),
  CONSTRAINT `persons_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `persons_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `persons_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  CONSTRAINT `persons_identity_document_type_id_foreign` FOREIGN KEY (`identity_document_type_id`) REFERENCES `cat_identity_document_types` (`id`),
  CONSTRAINT `persons_nationality_id_foreign` FOREIGN KEY (`nationality_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `persons_person_type_id_foreign` FOREIGN KEY (`person_type_id`) REFERENCES `person_types` (`id`),
  CONSTRAINT `persons_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `persons`
--

SET autocommit=0;
INSERT INTO `persons` VALUES (1,'customers','0','99999999','Clientes - Varios',NULL,NULL,NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'2026-07-17 12:15:27','2026-07-17 12:15:27',1,0,NULL,0,NULL,NULL,0,'01',0.00,1),(2,'customers','1','75478910','VEGA SALAZAR, JEAN CLAUDE',NULL,NULL,NULL,NULL,NULL,'PE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2026-07-17 12:45:36','2026-07-17 12:45:36',1,0,NULL,0,NULL,NULL,0,'01',0.00,1),(3,'suppliers','6','20611683643','PATTY FARMA S.A.C.',NULL,NULL,NULL,NULL,NULL,'PE',NULL,'15','1501','150132',NULL,'AV. GRAN CHIMU NRO. 1231 INT. 2DO URB. ZARATE','HABIDO','ACTIVO',NULL,NULL,0.00,0,NULL,'{\"full_name\":null,\"phone\":null}',NULL,0.00,1,NULL,NULL,NULL,'2026-07-27 12:55:46','2026-07-27 12:55:46',1,0,NULL,0,NULL,NULL,0,'01',0.00,1);
COMMIT;

-- Dumped table `persons` with 3 row(s)
--

--
-- Table structure for table `person_address`
--

CREATE TABLE `person_address` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned NOT NULL,
  `department_id` char(2) DEFAULT NULL,
  `province_id` char(4) DEFAULT NULL,
  `district_id` char(6) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `person_address_person_id_foreign` (`person_id`),
  KEY `person_address_department_id_foreign` (`department_id`),
  KEY `person_address_province_id_foreign` (`province_id`),
  KEY `person_address_district_id_foreign` (`district_id`),
  CONSTRAINT `person_address_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `person_address_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  CONSTRAINT `person_address_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `person_address_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_address`
--

SET autocommit=0;
COMMIT;

-- Dumped table `person_address` with 0 row(s)
--

--
-- Table structure for table `person_addresses`
--

CREATE TABLE `person_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned NOT NULL,
  `country_id` char(2) NOT NULL,
  `department_id` char(2) DEFAULT NULL,
  `province_id` char(4) DEFAULT NULL,
  `district_id` char(6) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `main` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `person_addresses_person_id_foreign` (`person_id`),
  KEY `person_addresses_country_id_foreign` (`country_id`),
  KEY `person_addresses_department_id_foreign` (`department_id`),
  KEY `person_addresses_province_id_foreign` (`province_id`),
  KEY `person_addresses_district_id_foreign` (`district_id`),
  CONSTRAINT `person_addresses_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `person_addresses_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `person_addresses_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  CONSTRAINT `person_addresses_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `person_addresses_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_addresses`
--

SET autocommit=0;
COMMIT;

-- Dumped table `person_addresses` with 0 row(s)
--

--
-- Table structure for table `person_types`
--

CREATE TABLE `person_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_types`
--

SET autocommit=0;
INSERT INTO `person_types` VALUES (1,'Interno','2026-07-17 12:15:17','2026-07-17 12:15:17'),(2,'Distribuidor','2026-07-17 12:15:17','2026-07-17 12:15:17');
COMMIT;

-- Dumped table `person_types` with 2 row(s)
--

--
-- Table structure for table `pharmacy_configurations`
--

CREATE TABLE `pharmacy_configurations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `establishment_id` int(10) unsigned NOT NULL,
  `profit_field` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pharmacy_configurations`
--

SET autocommit=0;
INSERT INTO `pharmacy_configurations` VALUES (1,1,0,'2026-07-17 12:42:57','2026-07-17 12:42:57');
COMMIT;

-- Dumped table `pharmacy_configurations` with 1 row(s)
--

--
-- Table structure for table `points`
--

CREATE TABLE `points` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `person_id` int(10) unsigned NOT NULL,
  `folio` varchar(255) NOT NULL,
  `points` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `banned` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `points_person_id_foreign` (`person_id`),
  CONSTRAINT `points_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `persons` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `points`
--

SET autocommit=0;
COMMIT;

-- Dumped table `points` with 0 row(s)
--

--
-- Table structure for table `pos_parked_sales`
--

CREATE TABLE `pos_parked_sales` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `cash_id` int(10) unsigned NOT NULL,
  `created_by_user_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `payload` longtext NOT NULL,
  `locked_by_user_id` int(10) unsigned DEFAULT NULL,
  `lock_expires_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pos_parked_sales_uuid_unique` (`uuid`),
  KEY `idx_pos_parked_sales_cash_id` (`cash_id`),
  KEY `idx_pos_parked_sales_created_by` (`created_by_user_id`),
  KEY `idx_pos_parked_sales_lock_expires` (`lock_expires_at`),
  KEY `idx_pos_parked_sales_created_at` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pos_parked_sales`
--

SET autocommit=0;
COMMIT;

-- Dumped table `pos_parked_sales` with 0 row(s)
--

--
-- Table structure for table `preprinted_format_templates`
--

CREATE TABLE `preprinted_format_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `formats` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `preprinted_format_templates`
--

SET autocommit=0;
COMMIT;

-- Dumped table `preprinted_format_templates` with 0 row(s)
--

--
-- Table structure for table `prescription_cie10`
--

CREATE TABLE `prescription_cie10` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `diagnoses_code` varchar(255) NOT NULL,
  `diagnoses_description` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prescription_cie10`
--

SET autocommit=0;
COMMIT;

-- Dumped table `prescription_cie10` with 0 row(s)
--

--
-- Table structure for table `prescription_doctors`
--

CREATE TABLE `prescription_doctors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cmp` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prescription_doctors`
--

SET autocommit=0;
COMMIT;

-- Dumped table `prescription_doctors` with 0 row(s)
--

--
-- Table structure for table `prescription_prescriptions`
--

CREATE TABLE `prescription_prescriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `presentation_unit_type_id` int(10) unsigned DEFAULT NULL,
  `document_id` int(10) unsigned DEFAULT NULL,
  `sale_note_id` int(10) unsigned DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `prescription_number` varchar(255) DEFAULT NULL,
  `prescription_date` date DEFAULT NULL,
  `prescription_doctor_id` int(10) unsigned DEFAULT NULL,
  `doctor_name` varchar(255) DEFAULT NULL,
  `prescription_cie10_id` int(10) unsigned DEFAULT NULL,
  `diagnosis_text` varchar(255) DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `warehouse_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `prescription_prescriptions_customer_id_foreign` (`customer_id`),
  KEY `prescription_prescriptions_item_id_foreign` (`item_id`),
  KEY `prescription_prescriptions_prescription_doctor_id_foreign` (`prescription_doctor_id`),
  KEY `prescription_prescriptions_prescription_cie10_id_foreign` (`prescription_cie10_id`),
  KEY `prescription_prescriptions_user_id_foreign` (`user_id`),
  KEY `prescription_prescriptions_warehouse_id_foreign` (`warehouse_id`),
  KEY `prescription_presentation_idx` (`presentation_unit_type_id`),
  CONSTRAINT `prescription_prescriptions_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `prescription_prescriptions_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `prescription_prescriptions_prescription_cie10_id_foreign` FOREIGN KEY (`prescription_cie10_id`) REFERENCES `prescription_cie10` (`id`),
  CONSTRAINT `prescription_prescriptions_prescription_doctor_id_foreign` FOREIGN KEY (`prescription_doctor_id`) REFERENCES `prescription_doctors` (`id`),
  CONSTRAINT `prescription_prescriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `prescription_prescriptions_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prescription_prescriptions`
--

SET autocommit=0;
COMMIT;

-- Dumped table `prescription_prescriptions` with 0 row(s)
--

--
-- Table structure for table `procedures`
--

CREATE TABLE `procedures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `procedures`
--

SET autocommit=0;
COMMIT;

-- Dumped table `procedures` with 0 row(s)
--

--
-- Table structure for table `production`
--

CREATE TABLE `production` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT 0,
  `soap_type_id` char(2) DEFAULT NULL,
  `item_id` int(10) unsigned DEFAULT 0,
  `inventory_id_reference` int(10) unsigned DEFAULT NULL,
  `quantity` decimal(12,4) DEFAULT 0.0000 COMMENT 'Peso dle insumo ',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `machine_id` int(10) unsigned NOT NULL DEFAULT 0,
  `production_order` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `comment` longtext DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `time_start` time DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `time_end` time DEFAULT NULL,
  `lot_code` varchar(255) DEFAULT NULL,
  `item_extra_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`item_extra_data`)),
  `mix_date_start` date DEFAULT NULL,
  `mix_time_start` time DEFAULT NULL,
  `mix_date_end` date DEFAULT NULL,
  `mix_time_end` time DEFAULT NULL,
  `informative` tinyint(3) unsigned DEFAULT 0,
  `agreed` decimal(8,2) DEFAULT 0.00,
  `imperfect` decimal(8,2) DEFAULT 0.00,
  `proccess_type` longtext DEFAULT NULL,
  `production_collaborator` text DEFAULT NULL,
  `mix_collaborator` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `production_soap_type_id_foreign` (`soap_type_id`),
  CONSTRAINT `production_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `production`
--

SET autocommit=0;
COMMIT;

-- Dumped table `production` with 0 row(s)
--

--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item_unit_type_id` int(10) unsigned DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `apply_restaurant` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `promotions_item_id_foreign` (`item_id`),
  KEY `promotion_iut_idx` (`item_unit_type_id`),
  CONSTRAINT `promotions_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `promotions_item_unit_type_id_fk` FOREIGN KEY (`item_unit_type_id`) REFERENCES `item_unit_types` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotions`
--

SET autocommit=0;
COMMIT;

-- Dumped table `promotions` with 0 row(s)
--

--
-- Table structure for table `provinces`
--

CREATE TABLE `provinces` (
  `id` char(4) NOT NULL,
  `department_id` char(2) NOT NULL,
  `description` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `provinces_department_id_foreign` (`department_id`),
  CONSTRAINT `provinces_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provinces`
--

SET autocommit=0;
INSERT INTO `provinces` VALUES ('0101','01','Chachapoyas',1),('0102','01','Bagua',1),('0103','01','Bongará',1),('0104','01','Condorcanqui',1),('0105','01','Luya',1),('0106','01','Rodríguez de Mendoza',1),('0107','01','Utcubamba',1),('0201','02','Huaraz',1),('0202','02','Aija',1),('0203','02','Antonio Raymondi',1),('0204','02','Asunción',1),('0205','02','Bolognesi',1),('0206','02','Carhuaz',1),('0207','02','Carlos Fermín Fitzcarrald',1),('0208','02','Casma',1),('0209','02','Corongo',1),('0210','02','Huari',1),('0211','02','Huarmey',1),('0212','02','Huaylas',1),('0213','02','Mariscal Luzuriaga',1),('0214','02','Ocros',1),('0215','02','Pallasca',1),('0216','02','Pomabamba',1),('0217','02','Recuay',1),('0218','02','Santa',1),('0219','02','Sihuas',1),('0220','02','Yungay',1),('0301','03','Abancay',1),('0302','03','Andahuaylas',1),('0303','03','Antabamba',1),('0304','03','Aymaraes',1),('0305','03','Cotabambas',1),('0306','03','Chincheros',1),('0307','03','Grau',1),('0401','04','Arequipa',1),('0402','04','Camaná',1),('0403','04','Caravelí',1),('0404','04','Castilla',1),('0405','04','Caylloma',1),('0406','04','Condesuyos',1),('0407','04','Islay',1),('0408','04','La Uniòn',1),('0501','05','Huamanga',1),('0502','05','Cangallo',1),('0503','05','Huanca Sancos',1),('0504','05','Huanta',1),('0505','05','La Mar',1),('0506','05','Lucanas',1),('0507','05','Parinacochas',1),('0508','05','Pàucar del Sara Sara',1),('0509','05','Sucre',1),('0510','05','Víctor Fajardo',1),('0511','05','Vilcas Huamán',1),('0601','06','Cajamarca',1),('0602','06','Cajabamba',1),('0603','06','Celendín',1),('0604','06','Chota',1),('0605','06','Contumazá',1),('0606','06','Cutervo',1),('0607','06','Hualgayoc',1),('0608','06','Jaén',1),('0609','06','San Ignacio',1),('0610','06','San Marcos',1),('0611','06','San Miguel',1),('0612','06','San Pablo',1),('0613','06','Santa Cruz',1),('0701','07','Prov. Const. del Callao',1),('0801','08','Cusco',1),('0802','08','Acomayo',1),('0803','08','Anta',1),('0804','08','Calca',1),('0805','08','Canas',1),('0806','08','Canchis',1),('0807','08','Chumbivilcas',1),('0808','08','Espinar',1),('0809','08','La Convención',1),('0810','08','Paruro',1),('0811','08','Paucartambo',1),('0812','08','Quispicanchi',1),('0813','08','Urubamba',1),('0901','09','Huancavelica',1),('0902','09','Acobamba',1),('0903','09','Angaraes',1),('0904','09','Castrovirreyna',1),('0905','09','Churcampa',1),('0906','09','Huaytará',1),('0907','09','Tayacaja',1),('1001','10','Huánuco',1),('1002','10','Ambo',1),('1003','10','Dos de Mayo',1),('1004','10','Huacaybamba',1),('1005','10','Huamalíes',1),('1006','10','Leoncio Prado',1),('1007','10','Marañón',1),('1008','10','Pachitea',1),('1009','10','Puerto Inca',1),('1010','10','Lauricocha',1),('1011','10','Yarowilca',1),('1101','11','Ica',1),('1102','11','Chincha',1),('1103','11','Nasca',1),('1104','11','Palpa',1),('1105','11','Pisco',1),('1201','12','Huancayo',1),('1202','12','Concepción',1),('1203','12','Chanchamayo',1),('1204','12','Jauja',1),('1205','12','Junín',1),('1206','12','Satipo',1),('1207','12','Tarma',1),('1208','12','Yauli',1),('1209','12','Chupaca',1),('1301','13','Trujillo',1),('1302','13','Ascope',1),('1303','13','Bolívar',1),('1304','13','Chepén',1),('1305','13','Julcán',1),('1306','13','Otuzco',1),('1307','13','Pacasmayo',1),('1308','13','Pataz',1),('1309','13','Sánchez Carrión',1),('1310','13','Santiago de Chuco',1),('1311','13','Gran Chimú',1),('1312','13','Virú',1),('1401','14','Chiclayo',1),('1402','14','Ferreñafe',1),('1403','14','Lambayeque',1),('1501','15','Lima',1),('1502','15','Barranca',1),('1503','15','Cajatambo',1),('1504','15','Canta',1),('1505','15','Cañete',1),('1506','15','Huaral',1),('1507','15','Huarochirí',1),('1508','15','Huaura',1),('1509','15','Oyón',1),('1510','15','Yauyos',1),('1601','16','Maynas',1),('1602','16','Alto Amazonas',1),('1603','16','Loreto',1),('1604','16','Mariscal Ramón Castilla',1),('1605','16','Requena',1),('1606','16','Ucayali',1),('1607','16','Datem del Marañón',1),('1608','16','Putumayo',1),('1701','17','Tambopata',1),('1702','17','Manu',1),('1703','17','Tahuamanu',1),('1801','18','Mariscal Nieto',1),('1802','18','General Sánchez Cerro',1),('1803','18','Ilo',1),('1901','19','Pasco',1),('1902','19','Daniel Alcides Carrión',1),('1903','19','Oxapampa',1),('2001','20','Piura',1),('2002','20','Ayabaca',1),('2003','20','Huancabamba',1),('2004','20','Morropón',1),('2005','20','Paita',1),('2006','20','Sullana',1),('2007','20','Talara',1),('2008','20','Sechura',1),('2101','21','Puno',1),('2102','21','Azángaro',1),('2103','21','Carabaya',1),('2104','21','Chucuito',1),('2105','21','El Collao',1),('2106','21','Huancané',1),('2107','21','Lampa',1),('2108','21','Melgar',1),('2109','21','Moho',1),('2110','21','San Antonio de Putina',1),('2111','21','San Román',1),('2112','21','Sandia',1),('2113','21','Yunguyo',1),('2201','22','Moyobamba',1),('2202','22','Bellavista',1),('2203','22','El Dorado',1),('2204','22','Huallaga',1),('2205','22','Lamas',1),('2206','22','Mariscal Cáceres',1),('2207','22','Picota',1),('2208','22','Rioja',1),('2209','22','San Martín',1),('2210','22','Tocache',1),('2301','23','Tacna',1),('2302','23','Candarave',1),('2303','23','Jorge Basadre',1),('2304','23','Tarata',1),('2401','24','Tumbes',1),('2402','24','Contralmirante Villar',1),('2403','24','Zarumilla',1),('2501','25','Coronel Portillo',1),('2502','25','Atalaya',1),('2503','25','Padre Abad',1),('2504','25','Purús',1);
COMMIT;

-- Dumped table `provinces` with 196 row(s)
--

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `external_id` char(36) NOT NULL,
  `xml_fingerprint_sha256` char(64) DEFAULT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `soap_type_id` char(2) NOT NULL,
  `state_type_id` char(2) NOT NULL,
  `group_id` char(2) NOT NULL,
  `document_type_id` varchar(255) NOT NULL,
  `series` char(4) NOT NULL,
  `number` int(11) NOT NULL,
  `date_of_issue` date NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `time_of_issue` time NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `purchase_order_id` int(10) unsigned DEFAULT NULL,
  `currency_type_id` varchar(255) NOT NULL,
  `payment_condition_id` varchar(255) DEFAULT NULL,
  `observation` text DEFAULT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `total_prepayment` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exportation` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_free` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxed` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_unaffected` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_exonerated` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_igv` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_plastic_bag_taxes` decimal(6,2) NOT NULL DEFAULT 0.00,
  `total_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_value` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `total_canceled` tinyint(1) NOT NULL DEFAULT 0,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `perception_date` date DEFAULT NULL,
  `perception_number` int(11) DEFAULT NULL,
  `total_perception` decimal(12,2) DEFAULT NULL,
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `prepayments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`prepayments`)),
  `guides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`guides`)),
  `related` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`related`)),
  `perception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`perception`)),
  `detraction` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`detraction`)),
  `legends` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`legends`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `purchases_xml_fingerprint_unique` (`xml_fingerprint_sha256`),
  KEY `purchases_user_id_foreign` (`user_id`),
  KEY `purchases_establishment_id_foreign` (`establishment_id`),
  KEY `purchases_soap_type_id_foreign` (`soap_type_id`),
  KEY `purchases_state_type_id_foreign` (`state_type_id`),
  KEY `purchases_group_id_foreign` (`group_id`),
  KEY `purchases_document_type_id_foreign` (`document_type_id`),
  KEY `purchases_currency_type_id_foreign` (`currency_type_id`),
  KEY `purchases_purchase_order_id_foreign` (`purchase_order_id`),
  KEY `purchases_customer_id_foreign` (`customer_id`),
  KEY `purchases_payment_condition_id_foreign` (`payment_condition_id`),
  KEY `purchases_supplier_document_series_number_idx` (`supplier_id`,`document_type_id`,`series`,`number`),
  CONSTRAINT `purchases_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `purchases_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `purchases_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `cat_document_types` (`id`),
  CONSTRAINT `purchases_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `purchases_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `purchases_payment_condition_id_foreign` FOREIGN KEY (`payment_condition_id`) REFERENCES `general_payment_conditions` (`id`),
  CONSTRAINT `purchases_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`),
  CONSTRAINT `purchases_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `purchases_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `purchases_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `purchases_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchases`
--

SET autocommit=0;
INSERT INTO `purchases` VALUES (1,2,'d5b22778-5090-41e6-882d-3cbbac976eb4',NULL,1,'02','01','01','01','F002',25902,'2026-07-25','2026-07-25','12:54:19',3,'{\"identity_document_type_id\":\"6\",\"identity_document_type\":{\"id\":\"6\",\"description\":\"RUC\"},\"number\":\"20611683643\",\"name\":\"PATTY FARMA S.A.C.\",\"trade_name\":null,\"country_id\":\"PE\",\"country\":{\"id\":\"PE\",\"description\":\"PERU\"},\"department_id\":\"15\",\"department\":{\"id\":\"15\",\"description\":\"LIMA\"},\"province_id\":\"1501\",\"province\":{\"id\":\"1501\",\"description\":\"Lima\"},\"district_id\":\"150132\",\"district\":{\"id\":\"150132\",\"description\":\"San Juan de Lurigancho\"},\"address\":\"AV. GRAN CHIMU NRO. 1231 INT. 2DO URB. ZARATE\",\"email\":null,\"telephone\":null,\"perception_agent\":false,\"address_id\":null,\"internal_code\":null,\"address_type_id\":null,\"address_type\":{\"id\":null,\"description\":null}}',NULL,'PEN','01',NULL,3.411,0.00,0.00,0.00,0.00,0.00,603.73,0.00,0.00,108.67,0.00,0.00,0.00,0.00,0.00,108.67,603.73,712.40,'F002-25902-1-20260730',1,NULL,NULL,NULL,NULL,'[]','[]',NULL,'[]',NULL,NULL,NULL,NULL,'2026-07-30 16:35:41','2026-07-30 16:35:44',NULL);
COMMIT;

-- Dumped table `purchases` with 1 row(s)
--

--
-- Table structure for table `purchase_fee`
--

CREATE TABLE `purchase_fee` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` int(10) unsigned NOT NULL,
  `date` date NOT NULL,
  `currency_type_id` varchar(255) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_method_type_id` char(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_fee_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_fee_currency_type_id_foreign` (`currency_type_id`),
  KEY `purchase_fee_payment_method_type_id_foreign` (`payment_method_type_id`),
  CONSTRAINT `purchase_fee_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `purchase_fee_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `purchase_fee_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_fee`
--

SET autocommit=0;
COMMIT;

-- Dumped table `purchase_fee` with 0 row(s)
--

--
-- Table structure for table `purchase_items`
--

CREATE TABLE `purchase_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`item`)),
  `item_lot_group_id` int(10) unsigned DEFAULT NULL,
  `lot_code` varchar(255) DEFAULT NULL,
  `quantity` decimal(12,4) NOT NULL,
  `unit_value` decimal(16,6) NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `affectation_igv_type_id` varchar(255) NOT NULL,
  `total_base_igv` decimal(12,4) NOT NULL,
  `percentage_igv` decimal(12,4) NOT NULL,
  `total_igv` decimal(12,4) NOT NULL,
  `system_isc_type_id` varchar(255) DEFAULT NULL,
  `total_base_isc` decimal(12,4) NOT NULL,
  `percentage_isc` decimal(12,4) NOT NULL,
  `total_isc` decimal(12,4) NOT NULL,
  `total_base_other_taxes` decimal(12,4) NOT NULL,
  `percentage_other_taxes` decimal(12,4) NOT NULL,
  `total_other_taxes` decimal(12,4) NOT NULL,
  `total_taxes` decimal(12,4) NOT NULL,
  `price_type_id` varchar(255) NOT NULL,
  `unit_price` decimal(16,6) NOT NULL,
  `total_value` decimal(12,4) NOT NULL,
  `total_charge` decimal(12,4) NOT NULL,
  `total_discount` decimal(12,4) NOT NULL,
  `total` decimal(12,4) NOT NULL,
  `attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attributes`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  `warehouse_id` int(10) unsigned DEFAULT NULL,
  `name_product_pdf` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_items_purchase_id_foreign` (`purchase_id`),
  KEY `purchase_items_item_id_foreign` (`item_id`),
  KEY `purchase_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `purchase_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `purchase_items_price_type_id_foreign` (`price_type_id`),
  KEY `purchase_items_warehouse_id_foreign` (`warehouse_id`),
  KEY `purchase_items_item_lot_group_id_index` (`item_lot_group_id`),
  CONSTRAINT `purchase_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `purchase_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `purchase_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `purchase_items_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`),
  CONSTRAINT `purchase_items_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_items`
--

SET autocommit=0;
INSERT INTO `purchase_items` VALUES (1,1,638,'{\"id\":638,\"item_code\":null,\"full_description\":\"BEPANTHEN BABY\",\"description\":\"BEPANTHEN BABY\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":30,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":900,\"description\":\"Unidad\",\"item_id\":638,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"30.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"900NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000638\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":30,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 30.00\",\"created_at\":\"2026-07-27 13:01:26\",\"updated_at\":\"2026-07-27 13:01:26\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":25,\"presentation\":{\"id\":900,\"description\":\"Unidad\",\"item_id\":638,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"30.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"900NIU1\"}}',NULL,NULL,1.0000,21.186441,NULL,'10',21.1900,18.0000,3.8100,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.8100,'01',25.000000,21.1900,0.0000,0.0000,25.0000,'[]','[]','[]',1,NULL),(2,1,235,'{\"id\":235,\"item_code\":null,\"full_description\":\"BEPANTHEN\",\"description\":\"BEPANTHEN\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":28.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":337,\"description\":\"Unidad\",\"item_id\":235,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"28.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"337NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":\"BEPANTHEN PLUS 5 % + 0.5 %\",\"second_name\":null,\"model\":null,\"barcode\":\"000000000235\",\"brand\":\"BAYER S.A.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":28.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 28.50\",\"created_at\":\"2026-07-21 17:37:02\",\"updated_at\":\"2026-07-21 23:06:14\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"23.70\",\"presentation\":{\"id\":337,\"description\":\"Unidad\",\"item_id\":235,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"28.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"337NIU1\"}}',NULL,NULL,1.0000,20.084746,NULL,'10',20.0800,18.0000,3.6200,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.6200,'01',23.700000,20.0800,0.0000,0.0000,23.7000,'[]','[]','[]',1,NULL),(3,1,474,'{\"id\":474,\"item_code\":null,\"full_description\":\"FRUTIFLEX  ADULTO\",\"description\":\"FRUTIFLEX  ADULTO\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":9,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":728,\"description\":\"Unidad\",\"item_id\":474,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"9.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"728NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000474\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"2.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":9,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 9.00\",\"created_at\":\"2026-07-22 23:16:35\",\"updated_at\":\"2026-07-22 23:16:35\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"2.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"2.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"7.20\",\"presentation\":{\"id\":728,\"description\":\"Unidad\",\"item_id\":474,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"9.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"728NIU1\"}}',NULL,NULL,3.0000,6.101695,NULL,'10',18.3100,18.0000,3.2900,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.2900,'01',7.200000,18.3100,0.0000,0.0000,21.6000,'[]','[]','[]',1,NULL),(4,1,433,'{\"id\":433,\"item_code\":null,\"full_description\":\"60569 - CAFAZOLBAC 1 g\",\"description\":\"CAFAZOLBAC 1 g\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":15,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":657,\"description\":\"Unidad\",\"item_id\":433,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"15.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"657NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EE15171\",\"cod_digemid\":\"60569\",\"unit_type_text\":\"Unidades\",\"name\":\"CAFAZOLBAC 1 g\",\"second_name\":null,\"model\":null,\"barcode\":\"60569\",\"brand\":\"CAFERMA S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"60569\",\"item_code_gs1\":null,\"stock\":\"3.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":15,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 15.00\",\"created_at\":\"2026-07-22 17:41:52\",\"updated_at\":\"2026-07-22 17:41:52\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"3.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"3.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":323,\"code\":\"2512106\",\"quantity\":4,\"date_of_due\":\"2028-12-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"2512106\",\"date_of_due\":\"2028-12-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"5.50\",\"presentation\":{\"id\":657,\"description\":\"Unidad\",\"item_id\":433,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"15.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"657NIU1\"}}',389,'2512104',4.0000,4.661017,'2028-12-31','10',18.6400,18.0000,3.3600,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.3600,'01',5.500000,18.6400,0.0000,0.0000,22.0000,'[]','[]','[]',1,NULL),(5,1,155,'{\"id\":155,\"item_code\":null,\"full_description\":\"45001 - MENSILLE 25 mg\\/ 5 mg\",\"description\":\"MENSILLE 25 mg\\/ 5 mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":23,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":214,\"description\":\"Unidad\",\"item_id\":155,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"21.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"214NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EE06034\",\"cod_digemid\":\"45001\",\"unit_type_text\":\"Unidades\",\"name\":\"MENSILLE 25 mg\\/ 5 mg\",\"second_name\":null,\"model\":null,\"barcode\":\"45001\",\"brand\":\"TECHSPHERE PERU S.A.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"45001\",\"item_code_gs1\":null,\"stock\":\"1.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":23,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 23.00\",\"created_at\":\"2026-07-21 14:43:53\",\"updated_at\":\"2026-07-21 14:43:53\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"1.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"1.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":102,\"code\":\"I2406570\",\"quantity\":1,\"date_of_due\":\"2028-06-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"I2406570\",\"date_of_due\":\"2028-06-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"12.50\",\"presentation\":{\"id\":214,\"description\":\"Unidad\",\"item_id\":155,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"21.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"214NIU1\"}}',390,'12602297',3.0000,10.593220,'2030-01-01','10',31.7800,18.0000,5.7200,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,5.7200,'01',12.500000,31.7800,0.0000,0.0000,37.5000,'[]','[]','[]',1,NULL),(6,1,641,'{\"id\":641,\"item_code\":null,\"full_description\":\"44472 - MEDRAVOL 50 mg\",\"description\":\"MEDRAVOL 50 mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":1.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":904,\"description\":\"Bl\\u00edster\",\"item_id\":641,\"unit_type_id\":\"BL\",\"quantity_unit\":\"10.00\",\"price1\":\"15.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"904BL10\"},{\"id\":905,\"description\":\"Unidad\",\"item_id\":641,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"1.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"905NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN05427\",\"cod_digemid\":\"44472\",\"unit_type_text\":\"Unidades\",\"name\":\"MEDRAVOL 50 mg\",\"second_name\":null,\"model\":null,\"barcode\":\"44472\",\"brand\":\"MEDROCK CORPORATION S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"44472\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":1.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 1.50\",\"created_at\":\"2026-07-27 13:58:24\",\"updated_at\":\"2026-07-27 13:58:24\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"0.165000\"}',391,'212145',100.0000,0.139831,'2028-12-31','10',13.9800,18.0000,2.5200,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,2.5200,'01',0.165000,13.9800,0.0000,0.0000,16.5000,'[]','[]','[]',1,NULL),(7,1,640,'{\"id\":640,\"item_code\":null,\"full_description\":\"54587 - MIODEL RELAX NF 450 mg + 35 mg\",\"description\":\"MIODEL RELAX NF 450 mg + 35 mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":2,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":902,\"description\":\"Caja\",\"item_id\":640,\"unit_type_id\":\"BX\",\"quantity_unit\":\"100.00\",\"price1\":\"0.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"902BX100\"},{\"id\":903,\"description\":\"Unidad\",\"item_id\":640,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"2.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"903NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN07491\",\"cod_digemid\":\"54587\",\"unit_type_text\":\"Unidades\",\"name\":\"MIODEL RELAX NF 450 mg + 35 mg\",\"second_name\":null,\"model\":null,\"barcode\":\"7752301000717\",\"brand\":\"LABORATORIOS DELFARMA S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"54587\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":2,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 2.00\",\"created_at\":\"2026-07-27 13:19:41\",\"updated_at\":\"2026-07-27 13:56:51\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"0.730000\"}',392,'2050066',100.0000,0.618644,'2029-05-31','10',61.8600,18.0000,11.1400,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,11.1400,'01',0.730000,61.8600,0.0000,0.0000,73.0000,'[]','[]','[]',1,NULL),(8,1,539,'{\"id\":539,\"item_code\":null,\"full_description\":\"VITIS JUNIOR\",\"description\":\"VITIS JUNIOR\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":20,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":799,\"description\":\"Unidad\",\"item_id\":539,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"20.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"799NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000539\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":20,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 20.00\",\"created_at\":\"2026-07-24 23:27:15\",\"updated_at\":\"2026-07-24 23:27:15\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"16.50\",\"presentation\":{\"id\":799,\"description\":\"Unidad\",\"item_id\":539,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"20.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"799NIU1\"}}',NULL,NULL,1.0000,13.983051,'2028-12-01','10',13.9800,18.0000,2.5200,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,2.5200,'01',16.500000,13.9800,0.0000,0.0000,16.5000,'[]','[]','[]',1,NULL),(9,1,642,'{\"id\":642,\"item_code\":null,\"full_description\":\"40736 - HIRUDOID 0.3 %\",\"description\":\"HIRUDOID 0.3 %\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":17.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":906,\"description\":\"Unidad\",\"item_id\":642,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"17.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"906NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN01337\",\"cod_digemid\":\"40736\",\"unit_type_text\":\"Unidades\",\"name\":\"HIRUDOID 0.3 %\",\"second_name\":null,\"model\":null,\"barcode\":\"40736\",\"brand\":\"DEUTSCHE PHARMA S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"40736\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":17.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 17.50\",\"created_at\":\"2026-07-27 14:15:18\",\"updated_at\":\"2026-07-27 14:15:18\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":14,\"presentation\":{\"id\":906,\"description\":\"Unidad\",\"item_id\":642,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"17.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"906NIU1\"}}',393,'20202796',1.0000,11.864407,'2031-02-28','10',11.8600,18.0000,2.1400,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,2.1400,'01',14.000000,11.8600,0.0000,0.0000,14.0000,'[]','[]','[]',1,NULL),(10,1,639,'{\"id\":639,\"item_code\":null,\"full_description\":\"48185 - DICLOFIX 75 mg\\/ 3 mL\",\"description\":\"DICLOFIX 75 mg\\/ 3 mL\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":8,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":901,\"description\":\"Unidad\",\"item_id\":639,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"8.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"901NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EE07112\",\"cod_digemid\":\"48185\",\"unit_type_text\":\"Unidades\",\"name\":\"DICLOFIX 75 mg\\/ 3 mL\",\"second_name\":null,\"model\":null,\"barcode\":\"48185\",\"brand\":\"DROGUERIA DISTRIBUIDORA DANY S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"48185\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":8,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 8.00\",\"created_at\":\"2026-07-27 13:16:06\",\"updated_at\":\"2026-07-27 13:55:11\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"0.450000\",\"presentation\":[]}',394,'198240702',10.0000,0.381356,'2027-07-01','10',3.8100,18.0000,0.6900,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.6900,'01',0.450000,3.8100,0.0000,0.0000,4.5000,'[]','[]','[]',1,NULL),(11,1,643,'{\"id\":643,\"item_code\":null,\"full_description\":\"VITIS ENCIAS 100mL\",\"description\":\"VITIS ENCIAS 100mL\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":23.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":907,\"description\":\"Unidad\",\"item_id\":643,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"23.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"907NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000643\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":23.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 23.50\",\"created_at\":\"2026-07-27 14:22:53\",\"updated_at\":\"2026-07-27 14:22:53\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"18.50\",\"presentation\":{\"id\":907,\"description\":\"Unidad\",\"item_id\":643,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"23.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"907NIU1\"}}',NULL,NULL,1.0000,15.677966,NULL,'10',15.6800,18.0000,2.8200,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,2.8200,'01',18.500000,15.6800,0.0000,0.0000,18.5000,'[]','[]','[]',1,NULL),(12,1,644,'{\"id\":644,\"item_code\":null,\"full_description\":\"VITIS KIDS 50mL\",\"description\":\"VITIS KIDS 50mL\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":20,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":908,\"description\":\"Unidad\",\"item_id\":644,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"20.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"908NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000644\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":20,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 20.00\",\"created_at\":\"2026-07-27 14:24:30\",\"updated_at\":\"2026-07-27 14:24:30\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"14.5\",\"presentation\":{\"id\":908,\"description\":\"Unidad\",\"item_id\":644,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"20.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"908NIU1\"}}',NULL,NULL,1.0000,12.288136,NULL,'10',12.2900,18.0000,2.2100,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,2.2100,'01',14.500000,12.2900,0.0000,0.0000,14.5000,'[]','[]','[]',1,NULL),(13,1,645,'{\"id\":645,\"item_code\":null,\"full_description\":\"COREGA ULTRA MENTA 20g\",\"description\":\"COREGA ULTRA MENTA 20g\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":27,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":909,\"description\":\"Unidad\",\"item_id\":645,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"27.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"909NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000645\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":27,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 27.00\",\"created_at\":\"2026-07-27 14:28:13\",\"updated_at\":\"2026-07-27 14:28:13\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"22.00\",\"presentation\":{\"id\":909,\"description\":\"Unidad\",\"item_id\":645,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"27.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"909NIU1\"}}',NULL,NULL,2.0000,18.644068,NULL,'10',37.2900,18.0000,6.7100,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,6.7100,'01',22.000000,37.2900,0.0000,0.0000,44.0000,'[]','[]','[]',1,NULL),(14,1,417,'{\"id\":417,\"item_code\":null,\"full_description\":\"45485 - ENTEROGERMINA 2000 millones(2 millardos)\\/ 5\",\"description\":\"ENTEROGERMINA 2000 millones(2 millardos)\\/ 5\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":4.2,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":626,\"description\":\"Unidad\",\"item_id\":417,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"4.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"626NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"BE00937\",\"cod_digemid\":\"45485\",\"unit_type_text\":\"Unidades\",\"name\":\"ENTEROGERMINA 2000 millones(2 millardos)\\/ 5\",\"second_name\":null,\"model\":null,\"barcode\":\"45485\",\"brand\":\"SANOFI - AVENTIS DEL PERU S.A.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"45485\",\"item_code_gs1\":null,\"stock\":\"3.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":4.2,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 4.20\",\"created_at\":\"2026-07-22 15:31:35\",\"updated_at\":\"2026-07-22 15:31:35\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"3.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"3.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":311,\"code\":\"61022\",\"quantity\":6,\"date_of_due\":\"2027-12-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"61022\",\"date_of_due\":\"2027-12-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"3.680000\"}',311,'61022',10.0000,3.118644,'2027-12-01','10',31.1900,18.0000,5.6100,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,5.6100,'01',3.680000,31.1900,0.0000,0.0000,36.8000,'[]','[]','[]',1,NULL),(15,1,646,'{\"id\":646,\"item_code\":null,\"full_description\":\"52646 - SIMETICONA 80 mg\",\"description\":\"SIMETICONA 80 mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":0.7,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":910,\"description\":\"Bl\\u00edster\",\"item_id\":646,\"unit_type_id\":\"BL\",\"quantity_unit\":\"10.00\",\"price1\":\"5.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"910BL10\"},{\"id\":911,\"description\":\"Unidad\",\"item_id\":646,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"0.70\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"911NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN04991\",\"cod_digemid\":\"52646\",\"unit_type_text\":\"Unidades\",\"name\":\"SIMETICONA 80 mg\",\"second_name\":null,\"model\":null,\"barcode\":\"52646\",\"brand\":\"INSTITUTO QUIMIOTERAPICO S.A. - IQFARMA\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"52646\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":0.7,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 0.70\",\"created_at\":\"2026-07-27 14:36:55\",\"updated_at\":\"2026-07-27 14:42:07\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"0.250000\"}',395,'20300926',30.0000,0.211864,'2029-03-30','10',6.3600,18.0000,1.1400,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.1400,'01',0.250000,6.3600,0.0000,0.0000,7.5000,'[]','[]','[]',1,NULL),(16,1,647,'{\"id\":647,\"item_code\":null,\"full_description\":\"53332 - FISIODOL FORTE PLUS 2.32 %\",\"description\":\"FISIODOL FORTE PLUS 2.32 %\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":19.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":912,\"description\":\"Unidad\",\"item_id\":647,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"19.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"912NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN08671\",\"cod_digemid\":\"53332\",\"unit_type_text\":\"Unidades\",\"name\":\"FISIODOL FORTE PLUS 2.32 %\",\"second_name\":null,\"model\":null,\"barcode\":\"53332\",\"brand\":\"MED FARMA SOCIEDAD ANONIMA CERRADA - MED FARMA S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"53332\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":19.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 19.50\",\"created_at\":\"2026-07-27 14:44:49\",\"updated_at\":\"2026-07-27 14:44:49\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"14.40\",\"presentation\":{\"id\":912,\"description\":\"Unidad\",\"item_id\":647,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"19.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"912NIU1\"}}',396,'2050396',1.0000,12.203390,'2029-05-30','10',12.2000,18.0000,2.2000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,2.2000,'01',14.400000,12.2000,0.0000,0.0000,14.4000,'[]','[]','[]',1,NULL),(17,1,648,'{\"id\":648,\"item_code\":null,\"full_description\":\"FLORIL 0.03% 8ml\",\"description\":\"FLORIL 0.03% 8ml\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":10,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":913,\"description\":\"Unidad\",\"item_id\":648,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"10.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"913NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000648\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":10,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 10.00\",\"created_at\":\"2026-07-27 14:49:24\",\"updated_at\":\"2026-07-27 14:49:24\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"7.50\",\"presentation\":{\"id\":913,\"description\":\"Unidad\",\"item_id\":648,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"10.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"913NIU1\"}}',NULL,NULL,1.0000,6.355932,NULL,'10',6.3600,18.0000,1.1400,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.1400,'01',7.500000,6.3600,0.0000,0.0000,7.5000,'[]','[]','[]',1,NULL),(18,1,649,'{\"id\":649,\"item_code\":null,\"full_description\":\"38424 - HUMED 0.3 %\",\"description\":\"HUMED 0.3 %\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":14.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":914,\"description\":\"Unidad\",\"item_id\":649,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"14.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"914NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN03624\",\"cod_digemid\":\"38424\",\"unit_type_text\":\"Unidades\",\"name\":\"HUMED 0.3 %\",\"second_name\":null,\"model\":null,\"barcode\":\"38424\",\"brand\":\"LABORATORIOS LANSIER S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"38424\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":14.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 14.50\",\"created_at\":\"2026-07-27 14:52:32\",\"updated_at\":\"2026-07-27 14:52:32\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"9.90\",\"presentation\":{\"id\":914,\"description\":\"Unidad\",\"item_id\":649,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"14.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"914NIU1\"}}',397,'202026',1.0000,8.389831,'2029-02-28','10',8.3900,18.0000,1.5100,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.5100,'01',9.900000,8.3900,0.0000,0.0000,9.9000,'[]','[]','[]',1,NULL),(19,1,650,'{\"id\":650,\"item_code\":null,\"full_description\":\"DEXAMETASONA 4mg\",\"description\":\"DEXAMETASONA 4mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":0.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":915,\"description\":\"Unidad\",\"item_id\":650,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"0.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"915NIU1\"},{\"id\":916,\"description\":\"Bl\\u00edster\",\"item_id\":650,\"unit_type_id\":\"BL\",\"quantity_unit\":\"10.00\",\"price1\":\"3.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":0,\"barcode\":\"916BL10\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN04152\",\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000650\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":0.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 0.50\",\"created_at\":\"2026-07-27 15:00:34\",\"updated_at\":\"2026-07-27 15:00:34\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"0.110000\"}',398,'2030156',100.0000,0.093220,'2029-03-30','10',9.3200,18.0000,1.6800,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.6800,'01',0.110000,9.3200,0.0000,0.0000,11.0000,'[]','[]','[]',1,NULL),(20,1,651,'{\"id\":651,\"item_code\":null,\"full_description\":\"GASEOVET GOTAS ANIS\",\"description\":\"GASEOVET GOTAS ANIS\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":26,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":917,\"description\":\"Unidad\",\"item_id\":651,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"26.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"917NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN01922\",\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000651\",\"brand\":\"MEDIFARMA S.A.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":26,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 26.00\",\"created_at\":\"2026-07-27 17:42:55\",\"updated_at\":\"2026-07-27 17:42:55\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"22.50\",\"presentation\":{\"id\":917,\"description\":\"Unidad\",\"item_id\":651,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"26.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"917NIU1\"}}',399,'2060115',1.0000,19.067797,'2029-06-30','10',19.0700,18.0000,3.4300,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.4300,'01',22.500000,19.0700,0.0000,0.0000,22.5000,'[]','[]','[]',1,NULL),(21,1,652,'{\"id\":652,\"item_code\":null,\"full_description\":\"59766 - ACI-TIP 400 mg\\/ 5 mL + 30 mg\\/ 5 mL\",\"description\":\"ACI-TIP 400 mg\\/ 5 mL + 30 mg\\/ 5 mL\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":28,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":918,\"description\":\"Unidad\",\"item_id\":652,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"28.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"918NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN09830\",\"cod_digemid\":\"59766\",\"unit_type_text\":\"Unidades\",\"name\":\"ACI-TIP 400 mg\\/ 5 mL + 30 mg\\/ 5 mL\",\"second_name\":null,\"model\":null,\"barcode\":\"59766\",\"brand\":\"MEGA LABS LATAM S.A.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"59766\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":28,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 28.00\",\"created_at\":\"2026-07-27 17:53:45\",\"updated_at\":\"2026-07-27 17:53:45\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"23.00\",\"presentation\":{\"id\":918,\"description\":\"Unidad\",\"item_id\":652,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"28.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"918NIU1\"}}',400,'20201246',1.0000,19.491525,'2029-02-28','10',19.4900,18.0000,3.5100,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.5100,'01',23.000000,19.4900,0.0000,0.0000,23.0000,'[]','[]','[]',1,NULL),(22,1,161,'{\"id\":161,\"item_code\":null,\"full_description\":\"BABY TEST CASSETE\",\"description\":\"BABY TEST CASSETE\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":12,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":221,\"description\":\"Unidad\",\"item_id\":161,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"12.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"221NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000161\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"2.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":12,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 12.00\",\"created_at\":\"2026-07-21 14:57:34\",\"updated_at\":\"2026-07-21 14:57:34\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"2.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"2.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":107,\"code\":\"HCG25070149\",\"quantity\":2,\"date_of_due\":\"2028-06-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"HCG25070149\",\"date_of_due\":\"2028-06-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"2.50\",\"presentation\":{\"id\":221,\"description\":\"Unidad\",\"item_id\":161,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"12.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"221NIU1\"}}',401,'HCG26020077',3.0000,2.118644,'2029-01-30','10',6.3600,18.0000,1.1400,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.1400,'01',2.500000,6.3600,0.0000,0.0000,7.5000,'[]','[]','[]',1,NULL),(23,1,237,'{\"id\":237,\"item_code\":null,\"full_description\":\"PHILLIPS LECHE MAGNESIA KIDS\",\"description\":\"PHILLIPS LECHE MAGNESIA KIDS\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":9.8,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":339,\"description\":\"Unidad\",\"item_id\":237,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"9.80\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"339NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000237\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"1.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":9.8,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 9.80\",\"created_at\":\"2026-07-21 17:39:23\",\"updated_at\":\"2026-07-21 17:39:23\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"1.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"1.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"7.70\",\"presentation\":{\"id\":339,\"description\":\"Unidad\",\"item_id\":237,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"9.80\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"339NIU1\"}}',NULL,NULL,1.0000,6.525424,NULL,'10',6.5300,18.0000,1.1700,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.1700,'01',7.700000,6.5300,0.0000,0.0000,7.7000,'[]','[]','[]',1,NULL),(24,1,473,'{\"id\":473,\"item_code\":null,\"full_description\":\"46830 - ACICLAV 500MG\\/125MG\",\"description\":\"ACICLAV 500MG\\/125MG\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":2,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":727,\"description\":\"Unidad\",\"item_id\":473,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"3.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"727NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EE07610\",\"cod_digemid\":\"46830\",\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"46830\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"46830\",\"item_code_gs1\":null,\"stock\":\"14.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":2,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 2.00\",\"created_at\":\"2026-07-22 23:03:23\",\"updated_at\":\"2026-07-27 14:03:45\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"14.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"14.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":387,\"code\":\"2601307\",\"quantity\":14,\"date_of_due\":\"2029-01-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"0.914286\",\"presentation\":[]}',387,'2601307',14.0000,0.774819,'2029-01-01','10',10.8500,18.0000,1.9500,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.9500,'01',0.914286,10.8500,0.0000,0.0000,12.8000,'[]','[]','[]',1,NULL),(25,1,653,'{\"id\":653,\"item_code\":null,\"full_description\":\"ARNICA SPORT SPRAY  75ML\",\"description\":\"ARNICA SPORT SPRAY  75ML\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":32.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":919,\"description\":\"Unidad\",\"item_id\":653,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"32.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"919NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000653\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":32.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 32.50\",\"created_at\":\"2026-07-27 19:03:44\",\"updated_at\":\"2026-07-27 19:03:44\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"25.50\",\"presentation\":{\"id\":919,\"description\":\"Unidad\",\"item_id\":653,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"32.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"919NIU1\"}}',NULL,NULL,1.0000,21.610169,NULL,'10',21.6100,18.0000,3.8900,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.8900,'01',25.500000,21.6100,0.0000,0.0000,25.5000,'[]','[]','[]',1,NULL),(26,1,389,'{\"id\":389,\"item_code\":null,\"full_description\":\"45062 - DESAZONA 4 mg\",\"description\":\"DESAZONA 4 mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":1.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":585,\"description\":\"Caja\",\"item_id\":389,\"unit_type_id\":\"BX\",\"quantity_unit\":\"10.00\",\"price1\":\"0.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"585BX10\"},{\"id\":586,\"description\":\"Unidad\",\"item_id\":389,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"1.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"586NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN06068\",\"cod_digemid\":\"45062\",\"unit_type_text\":\"Unidades\",\"name\":\"DESAZONA 4 mg\",\"second_name\":null,\"model\":null,\"barcode\":\"45062\",\"brand\":\"LABORATORIOS NATURALES Y GENERICOS S.A.C.- NATURGEN S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"45062\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":1.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 1.50\",\"created_at\":\"2026-07-21 21:56:12\",\"updated_at\":\"2026-07-21 21:56:12\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":295,\"code\":\"2014756\",\"quantity\":6,\"date_of_due\":\"2029-01-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"2014756\",\"date_of_due\":\"2029-01-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"0.09\",\"presentation\":{\"id\":586,\"description\":\"Unidad\",\"item_id\":389,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"1.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"586NIU1\"}}',402,'2047956',100.0000,0.076271,'2029-04-01','10',7.6300,18.0000,1.3700,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.3700,'01',0.090000,7.6300,0.0000,0.0000,9.0000,'[]','[]','[]',1,NULL),(27,1,654,'{\"id\":654,\"item_code\":null,\"full_description\":\"CLOTRIMAZOL 1% CREMA 20MG\",\"description\":\"CLOTRIMAZOL 1% CREMA 20MG\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":4,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":920,\"description\":\"Unidad\",\"item_id\":654,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"4.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"920NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN-04909\",\"cod_digemid\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000654\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":4,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 4.00\",\"created_at\":\"2026-07-27 22:07:00\",\"updated_at\":\"2026-07-27 22:07:00\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"1.80\",\"presentation\":{\"id\":920,\"description\":\"Unidad\",\"item_id\":654,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"4.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"920NIU1\"}}',403,'2047846',6.0000,1.525424,'2030-04-30','10',9.1500,18.0000,1.6500,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.6500,'01',1.800000,9.1500,0.0000,0.0000,10.8000,'[]','[]','[]',1,NULL),(28,1,62,'{\"id\":62,\"item_code\":null,\"full_description\":\"53190 - ACICLOVIR CREMA 5g\",\"description\":\"ACICLOVIR CREMA 5g\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":4.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":73,\"description\":\"Unidad\",\"item_id\":62,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"4.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"73NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":true,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN-01565\",\"cod_digemid\":\"53190\",\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"53190\",\"brand\":\"LABORATORIOS PORTUGAL S.R.L.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"53190\",\"item_code_gs1\":null,\"stock\":\"3.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":4.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 4.50\",\"created_at\":\"2026-07-21 10:59:28\",\"updated_at\":\"2026-07-27 16:07:38\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"3.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"3.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":13,\"code\":\"2039806\",\"quantity\":4,\"date_of_due\":\"2029-03-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"2039806\",\"date_of_due\":\"2029-03-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"1.40\",\"presentation\":{\"id\":73,\"description\":\"Unidad\",\"item_id\":62,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"4.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"73NIU1\"}}',13,'2039806',3.0000,1.186441,'2029-03-01','10',3.5600,18.0000,0.6400,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.6400,'01',1.400000,3.5600,0.0000,0.0000,4.2000,'[]','[]','[]',1,NULL),(29,1,88,'{\"id\":88,\"item_code\":null,\"full_description\":\"35636 - ENALAPRIL 10 mg\",\"description\":\"ENALAPRIL 10 mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":2,\"purchase_unit_price\":0,\"unit_type_id\":\"BL\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":109,\"description\":\"Bl\\u00edster\",\"item_id\":88,\"unit_type_id\":\"BL\",\"quantity_unit\":\"10.00\",\"price1\":\"1.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"109BL10\",\"_follow\":false}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":true,\"oppf_excluded\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN00872\",\"cod_digemid\":\"35636\",\"concentration\":\"10 mg\",\"unit_type_text\":\"Unidades\",\"name\":\"ENALAPRIL 10 mg\",\"second_name\":null,\"model\":null,\"barcode\":\"35636\",\"brand\":\"LABORATORIOS NATURALES Y GENERICOS S.A.C.- NATURGEN S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"35636\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":2,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 2.00\",\"created_at\":\"2026-07-21 11:53:03\",\"updated_at\":\"2026-07-21 11:53:03\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":37,\"code\":\"2012576\",\"quantity\":1,\"date_of_due\":\"2028-01-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"2012576\",\"date_of_due\":\"2028-01-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"0.040000\"}',404,'2074415',100.0000,0.033898,'2027-07-31','10',3.3900,18.0000,0.6100,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.6100,'01',0.040000,3.3900,0.0000,0.0000,4.0000,'[]','[]','[]',1,NULL),(30,1,89,'{\"id\":89,\"item_code\":null,\"full_description\":\"39236 - DICLOFENACO 1 %\",\"description\":\"DICLOFENACO 1 %\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":6,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":110,\"description\":\"Unidad\",\"item_id\":89,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"6.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"110NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":true,\"oppf_excluded\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN02764\",\"cod_digemid\":\"39236\",\"concentration\":\"1 %\",\"unit_type_text\":\"Unidades\",\"name\":\"DICLOFENACO 1 %\",\"second_name\":null,\"model\":null,\"barcode\":\"39236\",\"brand\":\"LABORATORIOS NATURALES Y GENERICOS S.A.C.- NATURGEN S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"39236\",\"item_code_gs1\":null,\"stock\":\"1.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":6,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 6.00\",\"created_at\":\"2026-07-21 11:54:47\",\"updated_at\":\"2026-07-21 11:54:47\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"1.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"1.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[{\"id\":38,\"code\":\"2124155\",\"quantity\":2,\"date_of_due\":\"2029-12-01\",\"checked\":false,\"compromise_quantity\":0}],\"lots\":[],\"is_set\":false,\"lot_code\":\"2124155\",\"date_of_due\":\"2029-12-01T05:00:00.000000Z\",\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"3.00\",\"presentation\":{\"id\":110,\"description\":\"Unidad\",\"item_id\":89,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"6.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"110NIU1\"}}',405,'2069446',4.0000,2.542373,'2030-06-01','10',10.1700,18.0000,1.8300,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.8300,'01',3.000000,10.1700,0.0000,0.0000,12.0000,'[]','[]','[]',1,NULL),(31,1,667,'{\"id\":667,\"item_code\":null,\"full_description\":\"BISMUTOL TABLETA\",\"description\":\"BISMUTOL TABLETA\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":1.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":false,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":933,\"description\":\"Unidad\",\"item_id\":667,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"1.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"933NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"oppf_excluded\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":null,\"cod_digemid\":null,\"concentration\":null,\"unit_type_text\":\"Unidades\",\"name\":null,\"second_name\":null,\"model\":null,\"barcode\":\"000000000667\",\"brand\":null,\"category_description\":null,\"warehouse_id\":null,\"internal_id\":null,\"item_code_gs1\":null,\"stock\":\"99.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":1.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 1.50\",\"created_at\":\"2026-07-27 23:56:58\",\"updated_at\":\"2026-07-27 23:56:58\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"99.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"99.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"0.970000\"}',NULL,NULL,100.0000,0.822034,NULL,'10',82.2000,18.0000,14.8000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,14.8000,'01',0.970000,82.2000,0.0000,0.0000,97.0000,'[]','[]','[]',1,NULL),(32,1,847,'{\"id\":847,\"item_code\":null,\"full_description\":\"42657 - GINGISONA B 0.30 %\",\"description\":\"GINGISONA B 0.30 %\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":33,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":1115,\"description\":\"Unidad\",\"item_id\":847,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"33.00\",\"price2\":\"27.50\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"1115NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"oppf_excluded\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EE03829\",\"cod_digemid\":\"42657\",\"concentration\":\"0.30 %\",\"unit_type_text\":\"Unidades\",\"name\":\"GINGISONA B 0.30 %\",\"second_name\":null,\"model\":null,\"barcode\":\"42657\",\"brand\":\"TEVA PERU S.A.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"42657\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":33,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 33.00\",\"created_at\":\"2026-07-30 12:29:34\",\"updated_at\":\"2026-07-30 12:29:34\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"unit_price\":\"27.50\",\"presentation\":{\"id\":1115,\"description\":\"Unidad\",\"item_id\":847,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"33.00\",\"price2\":\"27.50\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"1115NIU1\"}}',406,'06ZH',1.0000,23.305085,'2029-09-01','10',23.3100,18.0000,4.1900,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,4.1900,'01',27.500000,23.3100,0.0000,0.0000,27.5000,'[]','[]','[]',1,NULL),(33,1,848,'{\"id\":848,\"item_code\":null,\"full_description\":\"40243 - NAPROXPORT 550 mg\",\"description\":\"NAPROXPORT 550 mg\",\"currency_type_id\":\"PEN\",\"currency_type_symbol\":\"S\\/\",\"sale_unit_price\":1.5,\"purchase_unit_price\":0,\"unit_type_id\":\"NIU\",\"sale_affectation_igv_type_id\":\"10\",\"purchase_affectation_igv_type_id\":\"10\",\"purchase_has_igv\":true,\"has_perception\":false,\"lots_enabled\":true,\"percentage_perception\":null,\"item_unit_types\":[{\"id\":1116,\"description\":\"Caja\",\"item_id\":848,\"unit_type_id\":\"BX\",\"quantity_unit\":\"100.00\",\"price1\":\"0.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"1116BX100\",\"_follow\":false},{\"id\":1117,\"description\":\"Bl\\u00edster\",\"item_id\":848,\"unit_type_id\":\"BL\",\"quantity_unit\":\"10.00\",\"price1\":\"0.00\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"1117BL10\"},{\"id\":1118,\"description\":\"Unidad\",\"item_id\":848,\"unit_type_id\":\"NIU\",\"quantity_unit\":\"1.00\",\"price1\":\"1.50\",\"price2\":\"0.00\",\"price3\":\"0.00\",\"price_default\":1,\"barcode\":\"1118NIU1\"}],\"series_enabled\":false,\"purchase_has_isc\":false,\"purchase_system_isc_type_id\":null,\"purchase_percentage_isc\":\"0.00\",\"name_disa\":null,\"laboratory\":null,\"exportable_pharmacy\":false,\"oppf_excluded\":false,\"colors\":[],\"stock_by_extra\":{\"total\":null,\"CatItemStatus\":{\"detailed\":[],\"total\":null},\"CatItemUnitBusiness\":{\"detailed\":[],\"total\":null},\"CatItemMoldCavity\":{\"detailed\":[],\"total\":null},\"CatItemPackageMeasurement\":{\"detailed\":[],\"total\":null},\"CatItemUnitsPerPackage\":{\"detailed\":[],\"total\":null},\"CatItemMoldProperty\":{\"detailed\":[],\"total\":null},\"CatItemProductFamily\":{\"detailed\":[],\"total\":null},\"colors\":{\"detailed\":[],\"total\":null},\"CatItemSize\":{\"detailed\":[],\"total\":null}},\"sanitary\":\"EN02886\",\"cod_digemid\":\"40243\",\"concentration\":\"550 mg\",\"unit_type_text\":\"Unidades\",\"name\":\"NAPROXPORT 550 mg\",\"second_name\":null,\"model\":null,\"barcode\":\"40243\",\"brand\":\"LABORATORIOS NATURALES Y GENERICOS S.A.C.- NATURGEN S.A.C.\",\"category_description\":null,\"warehouse_id\":null,\"internal_id\":\"40243\",\"item_code_gs1\":null,\"stock\":\"0.0000\",\"stock_min\":\"1.00\",\"amount_sale_unit_price\":1.5,\"calculate_quantity\":false,\"has_igv\":true,\"active\":true,\"has_movements\":false,\"has_igv_description\":\"Si\",\"purchase_has_igv_description\":\"Si\",\"sale_unit_price_with_igv\":\"S\\/ 1.50\",\"created_at\":\"2026-07-30 12:55:04\",\"updated_at\":\"2026-07-30 12:55:04\",\"warehouses\":[{\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"stock\":\"0.0000\",\"warehouse_id\":1,\"checked\":true}],\"apply_store\":false,\"apply_restaurant\":false,\"image_url\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_medium\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"image_url_small\":\"https:\\/\\/vifarma.sysfarma.pe\\/logo\\/imagen-no-disponible.jpg\",\"tags\":[],\"tags_id\":[],\"is_for_production\":false,\"supplies\":[],\"total_stock\":\"0.00\",\"owner_warehouse_id\":1,\"owner_warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"is_local_product\":false,\"is_owned_by_current_user\":true,\"text_filter\":null,\"warehouse_description\":\"Almac\\u00e9n Oficina Principal\",\"extra\":{\"colors\":null,\"CatItemUnitsPerPackage\":null,\"CatItemMoldProperty\":null,\"CatItemProductFamily\":null,\"CatItemMoldCavity\":null,\"CatItemPackageMeasurement\":null,\"CatItemStatus\":null,\"CatItemSize\":null,\"CatItemUnitBusiness\":null},\"category\":null,\"purchase_unit_value\":0,\"original_unit_type_id\":\"NIU\",\"sale_affectation_igv_type\":{\"id\":\"10\",\"active\":1,\"exportation\":0,\"free\":0,\"description\":\"Gravado - Operaci\\u00f3n Onerosa\"},\"has_plastic_bag_taxes\":false,\"amount_plastic_bag_taxes\":\"0.10\",\"CatItemUnitsPerPackage\":[],\"CatItemMoldProperty\":[],\"CatItemProductFamily\":[],\"CatItemMoldCavity\":[],\"CatItemPackageMeasurement\":[],\"CatItemStatus\":[],\"CatItemSize\":[],\"CatItemUnitBusiness\":[],\"attributes\":[],\"lots_group\":[],\"lots\":[],\"is_set\":false,\"lot_code\":null,\"date_of_due\":null,\"change_free_affectation_igv\":false,\"original_affectation_igv_type_id\":\"10\",\"payWithPoints\":false,\"has_isc\":false,\"system_isc_type_id\":null,\"percentage_isc\":\"0.00\",\"subject_to_detraction\":false,\"exchange_points\":false,\"quantity_of_points\":0,\"exchanged_for_points\":false,\"used_points_for_exchange\":null,\"factory_code\":null,\"restrict_sale_cpe\":false,\"editable_sale_price\":false,\"name_product_pdf\":null,\"presentation\":[],\"unit_price\":\"0.305000\"}',407,'2115355',100.0000,0.258475,'2028-11-30','10',25.8500,18.0000,4.6500,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,4.6500,'01',0.305000,25.8500,0.0000,0.0000,30.5000,'[]','[]','[]',1,NULL);
COMMIT;

-- Dumped table `purchase_items` with 33 row(s)
--

--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `external_id` char(36) NOT NULL,
  `establishment_id` int(10) unsigned NOT NULL,
  `soap_type_id` char(2) NOT NULL,
  `state_type_id` char(2) NOT NULL,
  `prefix` varchar(255) NOT NULL DEFAULT 'OC',
  `date_of_issue` date NOT NULL,
  `date_of_due` date DEFAULT NULL,
  `time_of_issue` time NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `supplier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`supplier`)),
  `currency_type_id` varchar(255) NOT NULL,
  `exchange_rate_sale` decimal(13,3) NOT NULL,
  `total_prepayment` decimal(12,4) NOT NULL,
  `total_charge` decimal(12,4) NOT NULL,
  `total_discount` decimal(12,4) NOT NULL,
  `total_exportation` decimal(12,4) NOT NULL,
  `total_free` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxed` decimal(12,4) NOT NULL,
  `total_unaffected` decimal(12,4) NOT NULL,
  `total_exonerated` decimal(12,4) NOT NULL,
  `total_igv` decimal(12,4) NOT NULL,
  `total_base_isc` decimal(12,4) NOT NULL,
  `total_isc` decimal(12,4) NOT NULL,
  `total_base_other_taxes` decimal(12,4) NOT NULL,
  `total_other_taxes` decimal(12,4) NOT NULL,
  `total_taxes` decimal(12,4) NOT NULL,
  `total_value` decimal(12,4) NOT NULL,
  `total` decimal(12,4) NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `upload_filename` varchar(255) DEFAULT NULL,
  `purchase_quotation_id` int(10) unsigned DEFAULT NULL,
  `sale_opportunity_id` int(10) unsigned DEFAULT NULL,
  `payment_method_type_id` char(2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_orders_purchase_quotation_id_foreign` (`purchase_quotation_id`),
  KEY `purchase_orders_user_id_foreign` (`user_id`),
  KEY `purchase_orders_establishment_id_foreign` (`establishment_id`),
  KEY `purchase_orders_supplier_id_foreign` (`supplier_id`),
  KEY `purchase_orders_soap_type_id_foreign` (`soap_type_id`),
  KEY `purchase_orders_state_type_id_foreign` (`state_type_id`),
  KEY `purchase_orders_currency_type_id_foreign` (`currency_type_id`),
  KEY `purchase_orders_payment_method_type_id_foreign` (`payment_method_type_id`),
  KEY `purchase_orders_sale_opportunity_id_foreign` (`sale_opportunity_id`),
  CONSTRAINT `purchase_orders_currency_type_id_foreign` FOREIGN KEY (`currency_type_id`) REFERENCES `cat_currency_types` (`id`),
  CONSTRAINT `purchase_orders_establishment_id_foreign` FOREIGN KEY (`establishment_id`) REFERENCES `establishments` (`id`),
  CONSTRAINT `purchase_orders_payment_method_type_id_foreign` FOREIGN KEY (`payment_method_type_id`) REFERENCES `payment_method_types` (`id`),
  CONSTRAINT `purchase_orders_purchase_quotation_id_foreign` FOREIGN KEY (`purchase_quotation_id`) REFERENCES `purchase_quotations` (`id`),
  CONSTRAINT `purchase_orders_sale_opportunity_id_foreign` FOREIGN KEY (`sale_opportunity_id`) REFERENCES `sale_opportunities` (`id`),
  CONSTRAINT `purchase_orders_soap_type_id_foreign` FOREIGN KEY (`soap_type_id`) REFERENCES `soap_types` (`id`),
  CONSTRAINT `purchase_orders_state_type_id_foreign` FOREIGN KEY (`state_type_id`) REFERENCES `state_types` (`id`),
  CONSTRAINT `purchase_orders_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `persons` (`id`),
  CONSTRAINT `purchase_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_orders`
--

SET autocommit=0;
COMMIT;

-- Dumped table `purchase_orders` with 0 row(s)
--

--
-- Table structure for table `purchase_order_items`
--

CREATE TABLE `purchase_order_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`item`)),
  `quantity` int(11) NOT NULL,
  `unit_value` decimal(16,6) NOT NULL,
  `affectation_igv_type_id` varchar(255) NOT NULL,
  `total_base_igv` decimal(12,2) NOT NULL,
  `percentage_igv` decimal(12,2) NOT NULL,
  `total_igv` decimal(12,2) NOT NULL,
  `system_isc_type_id` varchar(255) DEFAULT NULL,
  `total_base_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_isc` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_base_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `percentage_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_other_taxes` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_taxes` decimal(12,2) NOT NULL,
  `price_type_id` varchar(255) NOT NULL,
  `unit_price` decimal(16,6) NOT NULL,
  `total_value` decimal(12,2) NOT NULL,
  `total_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL,
  `attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attributes`)),
  `discounts` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`discounts`)),
  `charges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`charges`)),
  PRIMARY KEY (`id`),
  KEY `purchase_order_items_purchase_order_id_foreign` (`purchase_order_id`),
  KEY `purchase_order_items_item_id_foreign` (`item_id`),
  KEY `purchase_order_items_affectation_igv_type_id_foreign` (`affectation_igv_type_id`),
  KEY `purchase_order_items_system_isc_type_id_foreign` (`system_isc_type_id`),
  KEY `purchase_order_items_price_type_id_foreign` (`price_type_id`),
  CONSTRAINT `purchase_order_items_affectation_igv_type_id_foreign` FOREIGN KEY (`affectation_igv_type_id`) REFERENCES `cat_affectation_igv_types` (`id`),
  CONSTRAINT `purchase_order_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `purchase_order_items_price_type_id_foreign` FOREIGN KEY (`price_type_id`) REFERENCES `cat_price_types` (`id`),
  CONSTRAINT `purchase_order_items_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_order_items_system_isc_type_id_foreign` FOREIGN KEY (`system_isc_type_id`) REFERENCES `cat_system_isc_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_order_items`
--

SET autocommit=0;
COMMIT;

-- Dumped table `purchase_order_items` with 0 row(s)
--

--
-- Table structure for table `purchase_payments`
--

