('01','KC',49868,'KCRFV06','KC431','2025-09-01','14:25:59',NULL,'promociones septiembre se reporta fuera de hora porque no había sistema RTR','KCSUP01',2,NULL),('01','KC',49869,'KCRFV06','KC432','2025-09-01','14:26:52',NULL,'promociónes Septiembre se reporta fuera de hora porque no había sistema RTR','KCSUP01',2,NULL),('01','KC',49870,'KCRFV06','KC433','2025-09-01','14:27:36',NULL,'promociones septiembre se reporta fuera de hora porque no había sistema RTR','KCSUP01',2,NULL),('01','KC',49871,'KCRFV06','KC434','2025-09-01','14:28:30',NULL,'promociones septiembre se reporta fuera de hora porque no había sistema RTR','KCSUP01',2,NULL),('01','KC',49872,'KCRFV06','KC760','2025-09-01','14:29:33',NULL,'promociones septiembre se reporta fuera de hora porque no había sistema RTR','KCSUP01',2,NULL),('01','KC',49873,'KCRFV06','KC1015','2025-09-01','14:30:21',NULL,'promociones septiembre se reporta fuera de hora porque no había sistema RTR','KCSUP01',2,NULL),('01','KC',49874,'KCRFV06','KC489','2025-09-01','14:31:33',NULL,'promociones septiembre','KCSUP01',2,NULL),('01','KC',49875,'KCRFV02','KC048','2025-09-01','15:08:47',NULL,'','KCSUP01',2,NULL),('01','KC',49876,'KCRFV04','KCRFV04N','2025-08-29','15:15:17',NULL,'Inauguración farmacia FARMADETODITO av. Principal Raúl leoni por la trigo pan ., un la participación de jornadas médicas y dia producto desde las 8:30 hasta las 12: 00  para la apertura realizaron la compra de kimiceg y tener el inventario disponible para el dia producto','KCSUP01',2,NULL),('01','KC',49877,'KCRFV04','KC816','2025-09-01','15:27:25',NULL,'','KCSUP01',2,NULL),('01','KC',49878,'KCRFV04','KC079','2025-09-01','15:27:31',NULL,'','KCSUP01',2,NULL),('01','KC',49879,'KCRFV04','KC083','2025-09-01','15:27:38',NULL,'','KCSUP01',2,NULL),('01','KC',49880,'KCRFV04','KC091','2025-09-01','15:27:43',NULL,'','KCSUP01',2,NULL),('01','KC',49881,'KCRFV04','KC1005','2025-09-01','15:27:48',NULL,'','KCSUP01',2,NULL),('01','KC',49882,'KCRFV02','KC016','2025-09-01','15:37:58',NULL,'','KCSUP01',2,NULL),('01','KC',49883,'KCRFV02','KC071','2025-09-01','15:46:49',NULL,'','KCSUP01',2,NULL),('01','KC',49884,'KCRFV02','KC019','2025-09-01','15:47:03',NULL,'','KCSUP01',2,NULL),('01','KC',49885,'KCRFV02','KC925','2025-09-01','15:50:08',NULL,'','KCSUP01',2,NULL),('01','KC',49886,'KCRFV02','KC049','2025-09-01','15:51:21',NULL,'','KCSUP01',2,NULL),('01','KC',49887,'KCRFV03','KC276','2025-09-01','16:39:23',NULL,'Cobranza.','KCSUP01',2,NULL),('01','KC',49888,'KCRFV03','KC287','2025-09-01','16:40:11',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',49889,'KCRFV03','KC325','2025-09-01','16:40:45',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49890,'KCRFV03','KC324','2025-09-01','16:45:44',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49891,'KCRFV03','KC310','2025-09-01','16:45:59',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49892,'KCRFV03','KC309','2025-09-01','16:46:16',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49893,'KCRFV04','KC094','2025-09-01','17:11:04',NULL,'','KCSUP01',2,NULL),('01','KC',49894,'KCRFV04','KC829','2025-09-01','17:11:08',NULL,'','KCSUP01',2,NULL),('01','KC',49895,'KCRFV04','KC818','2025-09-01','17:11:12',NULL,'','KCSUP01',2,NULL),('01','KC',49896,'KCRFV04','KC899','2025-09-01','17:12:18',NULL,'','KCSUP01',2,NULL),('01','KC',49897,'KCRFV07','KC694','2025-09-01','18:38:49',NULL,'día de Producto de 9 00 a 12 00 ...envío a esta hora en la mañana  RTR no me permitía entrar','KCSUP01',2,NULL),('01','KC',49898,'KCRFV07','KC697','2025-09-01','18:39:31',NULL,'visitada el día de hoy','KCSUP01',2,NULL),('01','KC',49899,'KCRFV07','KC695','2025-09-01','18:40:27',NULL,'visitada el día de hoy ...rtr no me permitía entrar','KCSUP01',2,NULL),('01','KC',49900,'KCRFV07','KC696','2025-09-01','18:42:14',NULL,'visitada el día de hoy  RTR no me permitía entrar','KCSUP01',2,NULL),('01','KC',49901,'KCRFV07','KC700','2025-09-01','18:43:03',NULL,'visitada el día de hoy ...','KCSUP01',2,NULL),('01','KC',49902,'KCRFV07','KC701','2025-09-01','18:43:46',NULL,'visitada el día de hoy ....','KCSUP01',2,NULL),('01','KC',49903,'KCRFV07','KC702','2025-09-01','18:45:56',NULL,'visitada el Día de Hoy ......','KCSUP01',2,NULL),('01','KC',49904,'KCRFV07','KC698','2025-09-01','18:47:04',NULL,'visitada el Día de Hoy ....','KCSUP01',2,NULL),('01','KC',49905,'KCRFV07','KC984','2025-09-01','18:48:22',NULL,'visitada el Día de Hoy ...RTR no me permitía entrar','KCSUP01',2,NULL),('01','KC',49906,'KCRFV05','KC138','2025-09-01','08:22:33',NULL,'Revisión de inventario y colocación de exhibición de los productos OTC','KCSUP01',2,NULL),('01','KC',49907,'KCRFV05','KC261','2025-09-01','08:22:38',NULL,'Revisión de inventario y negociación de Pedido','KCSUP01',2,NULL),('01','KC',49908,'KCRFV05','KCRFV05N','2025-08-29','08:22:43',NULL,'Inauguración de Saas Av. Vargas \nRevisión de inventario \nPromoción del portafolio','KCSUP01',2,NULL),('01','KC',49909,'KCRFV05','KC136','2025-08-29','08:22:50',NULL,'Revisión de inventario y promoción de los productos OTC','KCSUP01',2,NULL),('01','KC',49910,'KCRFV05','KC137','2025-08-29','08:22:54',NULL,'Revisión de inventario y promoción de los productos antigripal','KCSUP01',2,NULL),('01','KC',49911,'KCRFV05','KCRFV05N','2025-08-29','08:45:25',NULL,'Revisión de inventario y negociación de Pedido por Drogueria Nena','KCSUP01',2,NULL),('01','KC',49912,'KCRFV05','KC141','2025-08-29','08:45:29',NULL,'Revisión de inventario y promoción de los productos OTC','KCSUP01',2,NULL),('01','KC',49913,'KCRFV05','KC156','2025-08-29','08:45:33',NULL,'Revisión de inventario y promoción de los productos antigripal y cardio','KCSUP01',2,NULL),('01','KC',49914,'KCRFV05','KC139','2025-08-29','08:45:36',NULL,'Revisión de inventario y promoción de los productos antigripal y antibiótico.','KCSUP01',2,NULL),('01','KC',49915,'KCRFV05','KC181','2025-08-29','08:45:40',NULL,'Revisión de inventario y promoción de los productos antigripal y cardio','KCSUP01',2,NULL),('01','KC',49916,'KCRFV05','KC261','2025-08-29','08:45:44',NULL,'Revisión de inventario y negociación de Pedido','KCSUP01',2,NULL),('01','KC',49917,'KCRFV05','KC193','2025-08-28','08:45:47',NULL,'Revisión de inventario y promoción de los productos OTC','KCSUP01',2,NULL),('01','KC',49918,'KCRFV05','KC203','2025-08-28','08:45:50',NULL,'Revisión de inventario y promoción de los productos antigripal y cardio. \nse realizó exhibición en cabezal principal.','KCSUP01',2,NULL),('01','KC',49919,'KCRFV06','KC544','2025-09-02','09:37:11',NULL,'Efectuó pedido','KCSUP01',2,NULL),('01','KC',49920,'KCRFV04','KC102','2025-09-02','09:57:17',NULL,'','KCSUP01',2,NULL),('01','KC',49921,'KCRFV04','KC103','2025-09-02','10:07:27',NULL,'','KCSUP01',2,NULL),('01','KC',49922,'KCRFV02','KC023','2025-09-02','10:12:40',NULL,'','KCSUP01',2,NULL),('01','KC',49923,'KCRFV02','KC052','2025-09-01','10:12:45',NULL,'','KCSUP01',2,NULL),('01','KC',49924,'KCRFV02','KC024','2025-09-02','10:13:03',NULL,'','KCSUP01',2,NULL),('01','KC',49925,'KCRFV06','KC438','2025-09-02','10:29:33',NULL,'promociones septiembre y dctos','KCSUP01',2,NULL),('01','KC',49926,'KCRFV06','KC437','2025-09-02','10:41:41',NULL,'dctos y promociones septiembre','KCSUP01',2,NULL),('01','KC',49927,'KCRFV04','KC104','2025-09-02','10:43:15',NULL,'','KCSUP01',2,NULL),('01','KC',49928,'KCRFV06','KCRFV06N','2025-09-02','10:51:35',NULL,'Farmacia Puky,c.a Rif J 501211515','KCSUP01',2,NULL),('01','KC',49929,'KCRFV06','KC439','2025-09-02','11:05:15',NULL,'promociónes septiembre y dctos','KCSUP01',2,NULL),('01','KC',49930,'KCRFV07','KC933','2025-09-02','11:08:02',NULL,'','KCSUP01',2,NULL),('01','KC',49931,'KCRFV06','KC1007','2025-09-02','11:16:13',NULL,'promociones septiembre y dctos kimiceg','KCSUP01',2,NULL),('01','KC',49932,'KCRFV04','KC105','2025-09-02','11:22:23',NULL,'','KCSUP01',2,NULL),('01','KC',49933,'KCRFV04','KC106','2025-09-02','11:52:27',NULL,'','KCSUP01',2,NULL),('01','KC',49934,'KCRFV06','KC441','2025-09-02','11:54:26',NULL,'dectos y promociones septiembre','KCSUP01',2,NULL),('01','KC',49935,'KCRFV06','KC442','2025-09-02','11:58:18',NULL,'ofertas septiembre y dctos','KCSUP01',2,NULL),('01','KC',49936,'KCRFV06','KC443','2025-09-02','12:15:50',NULL,'promociones septiembre y dctos','KCSUP01',2,NULL),('01','KC',49937,'KCRFV06','KC449','2025-09-02','12:18:44',NULL,'Esta Drogueria  está en el mismo local de la farmacia Merca farma\n,c.a','KCSUP01',2,NULL),('01','KC',49938,'KCRFV06','KC444','2025-09-02','12:36:42',NULL,'Efectuó pedido por Drogueria Drovencentro','KCSUP01',2,NULL),('01','KC',49939,'KCRFV06','KC446','2025-09-02','13:03:43',NULL,'ofertas y descuentos septiembre planificación día impulsó mes de septiembre','KCSUP01',2,NULL),('01','KC',49940,'KCRFV04','KCRFV04N','2025-09-02','15:38:51',NULL,'Trabajo administrativo pasando pedido mesa negocion Droguería Nena','KCSUP01',2,NULL),('01','KC',49941,'KCRFV02','KC726','2025-09-02','16:01:47',NULL,'','KCSUP01',2,NULL),('01','KC',49942,'KCRFV02','KC057','2025-09-02','16:02:01',NULL,'','KCSUP01',2,NULL),('01','KC',49943,'KCRFV02','KC059','2025-09-02','16:02:17',NULL,'','KCSUP01',2,NULL),('01','KC',49944,'KCRFV04','KC106','2025-09-02','16:03:28',NULL,'','KCSUP01',2,NULL),('01','KC',49945,'KCRFV04','KC109','2025-09-02','16:28:54',NULL,'','KCSUP01',2,NULL),('01','KC',49946,'KCRFV03','KC286','2025-09-02','17:26:08',NULL,'Cobranza.','KCSUP01',2,NULL),('01','KC',49947,'KCRFV03','KC283','2025-09-02','17:26:50',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',49948,'KCRFV03','KC315','2025-09-02','17:27:28',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49949,'KCRFV03','KC302','2025-09-02','17:27:44',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49950,'KCRFV03','KC307','2025-09-02','17:28:09',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49951,'KCRFV03','KC301','2025-09-02','17:28:24',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49952,'KCRFV07','KC650','2025-09-02','17:50:49',NULL,'','KCSUP01',2,NULL),('01','KC',49953,'KCRFV07','KC648','2025-09-02','18:01:36',NULL,'','KCSUP01',2,NULL),('01','KC',49954,'KCRFV07','KC649','2025-09-02','18:20:25',NULL,'','KCSUP01',2,NULL),('01','KC',49955,'KCRFV07','KC651','2025-09-02','18:41:02',NULL,'','KCSUP01',2,NULL),('01','KC',49956,'KCRFV07','KC639','2025-09-03','09:13:20',NULL,'','KCSUP01',2,NULL),('01','KC',49957,'KCRFV04','KC116','2025-09-03','09:51:30',NULL,'','KCSUP01',2,NULL),('01','KC',49958,'KCRFV07','KC943','2025-09-03','09:57:01',NULL,'','KCSUP01',2,NULL),('01','KC',49959,'KCRFV04','KC818','2025-09-03','10:04:39',NULL,'','KCSUP01',2,NULL),('01','KC',49960,'KCRFV07','KC640','2025-09-03','10:06:16',NULL,'','KCSUP01',2,NULL),('01','KC',49961,'KCRFV02','KC780','2025-09-03','10:18:03',NULL,'','KCSUP01',2,NULL),('01','KC',49962,'KCRFV07','KC944','2025-09-03','10:18:22',NULL,'','KCSUP01',2,NULL),('01','KC',49963,'KCRFV02','KC055','2025-09-03','10:46:34',NULL,'','KCSUP01',2,NULL),('01','KC',49964,'KCRFV02','KC046','2025-09-03','10:49:54',NULL,'','KCSUP01',2,NULL),('01','KC',49965,'KCRFV02','KC035','2025-09-03','10:55:42',NULL,'','KCSUP01',2,NULL),('01','KC',49966,'KCRFV02','KC788','2025-09-03','11:02:24',NULL,'','KCSUP01',2,NULL),('01','KC',49967,'KCRFV02','KC037','2025-09-03','11:08:53',NULL,'','KCSUP01',2,NULL),('01','KC',49968,'KCRFV02','KC043','2025-09-03','11:13:54',NULL,'','KCSUP01',2,NULL),('01','KC',49969,'KCRFV04','KC907','2025-09-03','11:24:57',NULL,'','KCSUP01',2,NULL),('01','KC',49970,'KCRFV06','KC448','2025-09-03','11:25:42',NULL,'','KCSUP01',2,NULL),('01','KC',49971,'KCRFV06','KC455','2025-09-03','11:34:36',NULL,'promociones septiembre Planificación impulsó','KCSUP01',2,NULL),('01','KC',49972,'KCRFV06','KC451','2025-09-03','11:51:14',NULL,'ofertas y promociones Septiembre','KCSUP01',2,NULL),('01','KC',49973,'KCRFV06','KC452','2025-09-03','12:07:39',NULL,'promociones septiembre','KCSUP01',2,NULL),('01','KC',49974,'KCRFV06','KC453','2025-09-03','12:18:22',NULL,'Promocion Reto  Mucomax dctos Septiembres y ofertas','KCSUP01',2,NULL),('01','KC',49975,'KCRFV06','KC457','2025-09-03','12:44:20',NULL,'posible pedido para las 5 cedes se le informo los dectos por volumen y ofertas septiembre','KCSUP01',2,NULL),('01','KC',49976,'KCRFV06','KC456','2025-09-03','12:59:11',NULL,'promoción Reto Mucomax dctos y ofertas septiembre kimiceg','KCSUP01',2,NULL),('01','KC',49977,'KCRFV06','KC792','2025-09-03','13:21:14',NULL,'promociones septiembre','KCSUP01',2,NULL),('01','KC',49978,'KCRFV02','KC051','2025-09-03','13:25:32',NULL,'','KCSUP01',2,NULL),('01','KC',49979,'KCRFV02','KC053','2025-09-03','13:25:44',NULL,'','KCSUP01',2,NULL),('01','KC',49980,'KCRFV02','KC045','2025-09-03','13:27:55',NULL,'','KCSUP01',2,NULL),('01','KC',49981,'KCRFV06','KC437','2025-09-03','13:34:17',NULL,'planificación día impulsó 30 de septiembre efectuará pedido por Droguería Drovencentro','KCSUP01',2,NULL),('01','KC',49982,'KCRFV06','KC458','2025-09-03','14:00:23',NULL,'Revisión inventarios planificación día Impulsó mes septiembre','KCSUP01',2,NULL),('01','KC',49983,'KCRFV06','KC447','2025-09-03','14:22:08',NULL,'planificación día Impulsó','KCSUP01',2,NULL),('01','KC',49984,'KCRFV06','KC462','2025-09-03','14:41:24',NULL,'Promociónes septiembre y dctos efectuará pedido el próximo Martes','KCSUP01',2,NULL),('01','KC',49985,'KCRFV07','KCRFV07N','2025-09-03','15:36:48',NULL,'Representaciones Medica R Y 2015 c.a. .......','KCSUP01',2,NULL),('01','KC',49986,'KCRFV04','KC905','2025-09-03','16:37:02',NULL,'','KCSUP01',2,NULL),('01','KC',49987,'KCRFV04','KC917','2025-09-03','16:37:57',NULL,'Visita gestión de orden de compra','KCSUP01',2,NULL),('01','KC',49988,'KCRFV03','KC271','2025-09-03','18:32:17',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',49989,'KCRFV03','KC279','2025-09-03','18:32:38',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',49990,'KCRFV03','KC306','2025-09-03','18:33:16',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49991,'KCRFV03','KC323','2025-09-03','18:33:33',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49992,'KCRFV03','KC298','2025-09-03','18:33:50',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',49993,'KCRFV03','KC291','2025-09-03','18:35:24',NULL,'Negociación próxima transferencia.','KCSUP01',2,NULL),('01','KC',49994,'KCRFV07','KC983','2025-09-04','09:11:40',NULL,'','KCSUP01',2,NULL),('01','KC',49995,'KCRFV06','KCRFV06N','2025-09-04','09:15:11',NULL,'Asistencia al evento Mesa de negocios Drogueria Santo Remedio en la ciudad de Barquisineto','KCSUP01',2,NULL),('01','KC',49996,'KCRFV07','KC654','2025-09-04','09:27:29',NULL,'','KCSUP01',2,NULL),('01','KC',49997,'KCRFV02','KC015','2025-09-04','09:38:54',NULL,'','KCSUP01',2,NULL),('01','KC',49998,'KCRFV07','KC873','2025-09-04','09:41:38',NULL,'','KCSUP01',2,NULL),('01','KC',49999,'KCRFV07','KCRFV07N','2025-09-04','09:56:03',NULL,'Farmacia Rojas c.a.    Sii fichar','KCSUP01',2,NULL),('01','KC',50000,'KCRFV07','KC653','2025-09-04','10:06:05',NULL,'','KCSUP01',2,NULL),('01','KC',50001,'KCRFV07','KC846','2025-09-04','10:27:30',NULL,'','KCSUP01',2,NULL),('01','KC',50002,'KCRFV01','KC731','2025-09-04','10:36:39',NULL,'se visito y se verifico el inventario.','KCSUP01',2,NULL),('01','KC',50003,'KCRFV07','KC652','2025-09-04','10:52:29',NULL,'','KCSUP01',2,NULL),('01','KC',50004,'KCRFV07','KC658','2025-09-04','11:27:15',NULL,'','KCSUP01',2,NULL),('01','KC',50005,'KCRFV02','KC047','2025-09-04','11:30:13',NULL,'','KCSUP01',2,NULL),('01','KC',50006,'KCRFV02','KC920','2025-09-04','11:30:38',NULL,'','KCSUP01',2,NULL),('01','KC',50007,'KCRFV01','KC369','2025-09-04','11:36:13',NULL,'se verifico el inventario y el encargo quedó en compartir el pedido.','KCSUP01',2,NULL),('01','KC',50008,'KCRFV07','KC655','2025-09-04','11:49:06',NULL,'','KCSUP01',2,NULL),('01','KC',50009,'KCRFV07','KC725','2025-09-04','12:02:50',NULL,'','KCSUP01',2,NULL),('01','KC',50010,'KCRFV02','KC058','2025-09-04','14:33:53',NULL,'','KCSUP01',2,NULL),('01','KC',50011,'KCRFV02','KC926','2025-09-04','14:34:01',NULL,'','KCSUP01',2,NULL),('01','KC',50012,'KCRFV02','KC800','2025-09-04','15:32:21',NULL,'','KCSUP01',2,NULL),('01','KC',50013,'KCRFV07','KC350','2025-09-04','15:58:58',NULL,'','KCSUP01',2,NULL),('01','KC',50014,'KCRFV07','KC657','2025-09-04','16:11:59',NULL,'entrega bonificacion','KCSUP01',2,NULL),('01','KC',50015,'KCRFV07','KC945','2025-09-04','16:29:37',NULL,'','KCSUP01',2,NULL),('01','KC',50016,'KCRFV07','KC663','2025-09-04','16:45:04',NULL,'','KCSUP01',2,NULL),('01','KC',50017,'KCRFV01','KC412','2025-09-04','18:31:18',NULL,'hoy se visito a la de compras ya que estaba de cumpleaños.','KCSUP01',2,NULL),('01','KC',50018,'KCRFV03','KC270','2025-09-04','18:53:51',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50019,'KCRFV03','KC280','2025-09-04','18:54:37',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50020,'KCRFV03','KC330','2025-09-04','18:55:15',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50021,'KCRFV03','KC297','2025-09-04','18:55:31',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50022,'KCRFV03','KC319','2025-09-04','18:55:46',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50023,'KCRFV03','KC322','2025-09-04','18:56:01',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50024,'KCRFV07','KC641','2025-09-05','09:33:51',NULL,'','KCSUP01',2,NULL),('01','KC',50025,'KCRFV07','KC645','2025-09-05','09:56:58',NULL,'','KCSUP01',2,NULL),('01','KC',50026,'KCRFV07','KC659','2025-09-05','10:12:23',NULL,'','KCSUP01',2,NULL),('01','KC',50027,'KCRFV07','KC913','2025-09-05','10:43:30',NULL,'','KCSUP01',2,NULL),('01','KC',50028,'KCRFV07','KC642','2025-09-05','10:53:59',NULL,'','KCSUP01',2,NULL),('01','KC',50029,'KCRFV07','KC644','2025-09-05','11:08:17',NULL,'','KCSUP01',2,NULL),('01','KC',50030,'KCRFV07','KC643','2025-09-05','11:52:19',NULL,'','KCSUP01',2,NULL),('01','KC',50031,'KCRFV01','KC404','2025-09-05','13:08:58',NULL,'Se realizó un día producto','KCSUP01',2,NULL),('01','KC',50032,'KCRFV06','KCRFV06N','2025-09-05','13:27:45',NULL,'Asistencia Evento Mesa de negocios Drogueria Santo Remedio en Barquisimeto Edo Lara','KCSUP01',2,NULL),('01','KC',50033,'KCRFV07','KC665','2025-09-05','14:04:23',NULL,'','KCSUP01',2,NULL),('01','KC',50034,'KCRFV07','KC666','2025-09-05','14:23:44',NULL,'','KCSUP01',2,NULL),('01','KC',50035,'KCRFV07','KC723','2025-09-05','14:46:26',NULL,'','KCSUP01',2,NULL),('01','KC',50036,'KCRFV01','KC413','2025-09-05','16:10:12',NULL,'se converso con el encargado de compras y quedó en compartir otra propuesta.','KCSUP01',2,NULL),('01','KC',50037,'KCRFV03','KC269','2025-09-05','16:41:17',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50038,'KCRFV03','KC273','2025-09-05','16:41:43',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50039,'KCRFV03','KC313','2025-09-05','16:42:23',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50040,'KCRFV03','KC317','2025-09-05','16:42:40',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50041,'KCRFV03','KC311','2025-09-05','16:42:57',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50042,'KCRFV06','KC544','2025-09-08','09:21:46',NULL,'Pedido','KCSUP01',2,NULL),('01','KC',50043,'KCRFV07','KC721','2025-09-08','09:27:23',NULL,'','KCSUP01',2,NULL),('01','KC',50044,'KCRFV06','KC445','2025-09-08','09:37:57',NULL,'promociones septiembre y dctos','KCSUP01',2,NULL),('01','KC',50045,'KCRFV07','KC661','2025-09-08','09:45:46',NULL,'','KCSUP01',2,NULL),('01','KC',50046,'KCRFV06','KC460','2025-09-08','10:04:12',NULL,'promociones septiembres y descuentos','KCSUP01',2,NULL),('01','KC',50047,'KCRFV04','KC871','2025-09-08','10:06:26',NULL,'','KCSUP01',2,NULL),('01','KC',50048,'KCRFV06','KC461','2025-09-08','10:14:46',NULL,'dectos y ofertas septiembre','KCSUP01',2,NULL),('01','KC',50049,'KCRFV07','KC662','2025-09-08','10:23:53',NULL,'','KCSUP01',2,NULL),('01','KC',50050,'KCRFV06','KC463','2025-09-08','10:30:52',NULL,'ofertas y promociones Septiembre promoción Reto Mucomax','KCSUP01',2,NULL),('01','KC',50051,'KCRFV04','KCRFV04N','2025-09-08','10:45:34',NULL,'FARMACIA FARMA RODRIGUEZ','KCSUP01',2,NULL),('01','KC',50052,'KCRFV06','KC464','2025-09-08','10:50:44',NULL,'promocio septiembre y dctos kimiceg','KCSUP01',2,NULL),('01','KC',50053,'KCRFV07','KC332','2025-09-08','10:54:07',NULL,'','KCSUP01',2,NULL),('01','KC',50054,'KCRFV01','KC771','2025-09-08','11:02:34',NULL,'se promocionó la crema triple acción','KCSUP01',2,NULL),('01','KC',50055,'KCRFV06','KC742','2025-09-08','11:07:15',NULL,'','KCSUP01',2,NULL),('01','KC',50056,'KCRFV07','KCRFV07N','2025-09-08','11:24:44',NULL,'Farmacia La Isabelica c.a. (Farmatodo) labor de fichaje','KCSUP01',2,NULL),('01','KC',50057,'KCRFV06','KC535','2025-09-08','11:28:49',NULL,'promoción Reto Mucomax y ofertas septiembre','KCSUP01',2,NULL),('01','KC',50058,'KCRFV01','KC388','2025-09-08','11:32:18',NULL,'se converso con la encargada de compras y quedó en compartir pedido.','KCSUP01',2,NULL),('01','KC',50059,'KCRFV04','KC824','2025-09-08','11:35:46',NULL,'','KCSUP01',2,NULL),('01','KC',50060,'KCRFV01','KC401','2025-09-08','11:41:09',NULL,'se converso con la dueña y se cuadro una charla','KCSUP01',2,NULL),('01','KC',50061,'KCRFV06','KC1010','2025-09-08','11:47:02',NULL,'Revisión de inventarios kimiceg y promociones septiembre','KCSUP01',2,NULL),('01','KC',50062,'KCRFV07','KC668','2025-09-08','12:07:53',NULL,'','KCSUP01',2,NULL),('01','KC',50063,'KCRFV04','KC822','2025-09-08','12:23:10',NULL,'','KCSUP01',2,NULL),('01','KC',50064,'KCRFV01','KC772','2025-09-08','12:51:34',NULL,'se verifico en inventario y quedó en compartir el pedido.','KCSUP01',2,NULL),('01','KC',50065,'KCRFV04','KC112','2025-09-08','15:09:11',NULL,'','KCSUP01',2,NULL),('01','KC',50066,'KCRFV06','KC502','2025-09-08','15:23:59',NULL,'promociones Septiembres y dctos','KCSUP01',2,NULL),('01','KC',50067,'KCRFV07','KC667','2025-09-08','15:26:03',NULL,'','KCSUP01',2,NULL),('01','KC',50068,'KCRFV06','KC509','2025-09-08','15:33:36',NULL,'Revisión de inventarios y dctos Septiembre','KCSUP01',2,NULL),('01','KC',50069,'KCRFV04','KC114','2025-09-08','16:09:50',NULL,'','KCSUP01',2,NULL),('01','KC',50070,'KCRFV03','KC1013','2025-09-08','16:56:21',NULL,'Negociación próxima transferencia.','KCSUP01',2,NULL),('01','KC',50071,'KCRFV03','KC284','2025-09-08','16:56:39',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50072,'KCRFV03','KC303','2025-09-08','16:57:18',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50073,'KCRFV03','KC314','2025-09-08','16:57:34',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50074,'KCRFV03','KC320','2025-09-08','16:57:48',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50075,'KCRFV03','KC316','2025-09-08','16:58:02',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50076,'KCRFV07','KC647','2025-09-08','17:04:53',NULL,'','KCSUP01',2,NULL),('01','KC',50077,'KCRFV01','KC423','2025-09-08','17:13:11',NULL,'se montó ODC.','KCSUP01',2,NULL),('01','KC',50078,'KCRFV07','KC660','2025-09-08','17:18:55',NULL,'','KCSUP01',2,NULL),('01','KC',50079,'KCRFV02','KC638','2025-09-08','17:51:28',NULL,'','KCSUP01',2,NULL),('01','KC',50080,'KCRFV04','KC918','2025-09-09','09:24:28',NULL,'','KCSUP01',2,NULL),('01','KC',50081,'KCRFV07','KC570','2025-09-09','10:01:26',NULL,'','KCSUP01',2,NULL),('01','KC',50082,'KCRFV06','KC465','2025-09-09','10:05:09',NULL,'promociones septiembre  y dctos','KCSUP01',2,NULL),('01','KC',50083,'KCRFV06','KC467','2025-09-09','10:17:55',NULL,'Promociones septiembre','KCSUP01',2,NULL),('01','KC',50084,'KCRFV07','KC735','2025-09-09','10:19:04',NULL,'','KCSUP01',2,NULL),('01','KC',50085,'KCRFV04','KC108','2025-09-09','10:24:12',NULL,'Sabaneta de Barinas','KCSUP01',2,NULL),('01','KC',50086,'KCRFV06','KC468','2025-09-09','10:52:36',NULL,'Dctos Septiembre y promociones kimiceg','KCSUP01',2,NULL),('01','KC',50087,'KCRFV07','KC558','2025-09-09','10:56:51',NULL,'','KCSUP01',2,NULL),('01','KC',50088,'KCRFV04','KCRFV04N','2025-09-09','10:58:38',NULL,'FARMACIA MULTIDROGA SABANETA DE BARINAS','KCSUP01',2,NULL),('01','KC',50089,'KCRFV06','KC469','2025-09-09','11:08:37',NULL,'Promociones septiembre kimiceg','KCSUP01',2,NULL),('01','KC',50090,'KCRFV02','KC997','2025-09-09','11:11:48',NULL,'','KCSUP01',2,NULL),('01','KC',50091,'KCRFV07','KC571','2025-09-09','11:14:23',NULL,'','KCSUP01',2,NULL),('01','KC',50092,'KCRFV06','KC470','2025-09-09','11:18:04',NULL,'promociones septiembre día producto Drovencentro 5 % de dctos para ese día en los productos kimiceg','KCSUP01',2,NULL),('01','KC',50093,'KCRFV06','KC472','2025-09-09','11:30:59',NULL,'ofertas y promociones septiembre','KCSUP01',2,NULL),('01','KC',50094,'KCRFV07','KC572','2025-09-09','11:41:21',NULL,'','KCSUP01',2,NULL),('01','KC',50095,'KCRFV06','KC471','2025-09-09','11:49:28',NULL,'Promociones septiembre','KCSUP01',2,NULL),('01','KC',50096,'KCRFV06','KC924','2025-09-09','12:01:25',NULL,'Promociones septiembres y descuentos','KCSUP01',2,NULL),('01','KC',50097,'KCRFV06','KC919','2025-09-09','12:20:28',NULL,'promociones septiembres','KCSUP01',2,NULL),('01','KC',50098,'KCRFV06','KC473','2025-09-09','12:36:17',NULL,'ofertas y Promociones septiembre dectos','KCSUP01',2,NULL),('01','KC',50099,'KCRFV04','KC126','2025-09-09','12:39:37',NULL,'SABANETA DE BARINAS','KCSUP01',2,NULL),('01','KC',50100,'KCRFV02','KC637','2025-09-09','12:52:02',NULL,'','KCSUP01',2,NULL),('01','KC',50101,'KCRFV01','KC352','2025-09-09','13:03:10',NULL,'se realizó un día producto. y se tomó pedido.','KCSUP01',2,NULL),('01','KC',50102,'KCRFV06','KC534','2025-09-09','13:17:46',NULL,'','KCSUP01',2,NULL),('01','KC',50103,'KCRFV07','KC559','2025-09-09','14:01:37',NULL,'','KCSUP01',2,NULL),('01','KC',50104,'KCRFV02','KC066','2025-09-09','14:38:25',NULL,'','KCSUP01',2,NULL),('01','KC',50105,'KCRFV06','KCRFV06N','2025-09-09','14:56:34',NULL,'Farmacia Farmashop Ciudad Jardín,c.a Rij J506547880','KCSUP01',2,NULL),('01','KC',50106,'KCRFV04','KC828','2025-09-09','15:18:30',NULL,'','KCSUP01',2,NULL),('01','KC',50107,'KCRFV06','KC728','2025-09-09','15:27:54',NULL,'','KCSUP01',2,NULL),('01','KC',50108,'KCRFV04','KC953','2025-09-09','16:11:29',NULL,'','KCSUP01',2,NULL),('01','KC',50109,'KCRFV01','KC414','2025-09-09','17:04:58',NULL,'se cuadro un día producto y se verifico las fallas','KCSUP01',2,NULL),('01','KC',50110,'KCRFV03','KC275','2025-09-09','17:35:12',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50111,'KCRFV03','KC288','2025-09-09','17:35:44',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50112,'KCRFV03','KC329','2025-09-09','17:37:14',NULL,'Solicitud de apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50113,'KCRFV03','KC331','2025-09-09','17:37:29',NULL,'Solicitud de apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50114,'KCRFV03','KC300','2025-09-09','17:37:43',NULL,'Solicitud de apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50115,'KCRFV03','KC321','2025-09-09','17:37:57',NULL,'Solicitud de apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50116,'KCRFV07','KC737','2025-09-10','09:25:00',NULL,'','KCSUP01',2,NULL),('01','KC',50117,'KCRFV04','KC094','2025-09-10','09:48:33',NULL,'','KCSUP01',2,NULL),('01','KC',50118,'KCRFV04','KC951','2025-09-10','10:07:26',NULL,'','KCSUP01',2,NULL),('01','KC',50119,'KCRFV07','KC933','2025-09-10','10:30:43',NULL,'','KCSUP01',2,NULL),('01','KC',50120,'KCRFV06','KC488','2025-09-10','10:31:10',NULL,'tramites pedidos cobranza y promociones','KCSUP01',2,NULL),('01','KC',50121,'KCRFV04','KC080','2025-09-10','10:43:34',NULL,'','KCSUP01',2,NULL),('01','KC',50122,'KCRFV01','KC412','2025-09-10','11:16:19',NULL,'se converso sobre una ODC y sobre las condionrd de pagos.','KCSUP01',2,NULL),('01','KC',50123,'KCRFV06','KC478','2025-09-10','11:24:17',NULL,'promociones septiembre y dctos kimiceg','KCSUP01',2,NULL),('01','KC',50124,'KCRFV06','KC480','2025-09-10','11:45:25',NULL,'Inventarios kimiceg y dctos septiembre','KCSUP01',2,NULL),('01','KC',50125,'KCRFV04','KC081','2025-09-10','11:57:37',NULL,'','KCSUP01',2,NULL),('01','KC',50126,'KCRFV06','KC513','2025-09-10','12:17:49',NULL,'Revisión de inventarios y ofertas septiembre','KCSUP01',2,NULL),('01','KC',50127,'KCRFV06','KC479','2025-09-10','12:32:39',NULL,'Revisión inventarios','KCSUP01',2,NULL),('01','KC',50128,'KCRFV01','KC912','2025-09-10','12:33:18',NULL,'se converso con la de compras y quedó en compartir ODC','KCSUP01',2,NULL),('01','KC',50129,'KCRFV06','KC481','2025-09-10','12:49:42',NULL,'dctos y promociones septiembre promoción no Reto Mucomax','KCSUP01',2,NULL),('01','KC',50130,'KCRFV06','KC482','2025-09-10','12:55:09',NULL,'promociones septiembre kimiceg','KCSUP01',2,NULL),('01','KC',50131,'KCRFV06','KC483','2025-09-10','13:09:28',NULL,'planificación día impulso','KCSUP01',2,NULL),('01','KC',50132,'KCRFV06','KC484','2025-09-10','13:27:05',NULL,'promociones septiembre planificación día impulso Kimiceg promoción Reto Mucomax','KCSUP01',2,NULL),('01','KC',50133,'KCRFV06','KC485','2025-09-10','13:44:24',NULL,'Revisión de inventarios planificación día impulso kimiceg','KCSUP01',2,NULL),('01','KC',50134,'KCRFV02','KCRFV02N','2025-09-10','13:49:04',NULL,'drogueria loagro, ya realizar pedido y ya lo pagaron estamos a la espera de despacho','KCSUP01',2,NULL),('01','KC',50135,'KCRFV07','KC341','2025-09-10','13:49:42',NULL,'','KCSUP01',2,NULL),('01','KC',50136,'KCRFV06','KC486','2025-09-10','13:58:42',NULL,'Dctos septiembre y promociones 1x1 Loratadina+ Ambroxol tabletas','KCSUP01',2,NULL),('01','KC',50137,'KCRFV07','KC349','2025-09-10','14:01:56',NULL,'','KCSUP01',2,NULL),('01','KC',50138,'KCRFV07','KC346','2025-09-10','14:11:04',NULL,'','KCSUP01',2,NULL),('01','KC',50139,'KCRFV07','KC342','2025-09-10','14:23:07',NULL,'','KCSUP01',2,NULL),('01','KC',50140,'KCRFV02','KC783','2025-09-10','14:38:47',NULL,'realizaron pedido.','KCSUP01',2,NULL),('01','KC',50141,'KCRFV04','KC815','2025-09-10','14:49:54',NULL,'','KCSUP01',2,NULL),('01','KC',50142,'KCRFV07','KC344','2025-09-10','14:50:12',NULL,'','KCSUP01',2,NULL),('01','KC',50143,'KCRFV04','KC951','2025-09-10','15:11:55',NULL,'','KCSUP01',2,NULL),('01','KC',50144,'KCRFV07','KC348','2025-09-10','15:21:38',NULL,'','KCSUP01',2,NULL),('01','KC',50145,'KCRFV07','KC347','2025-09-10','15:47:37',NULL,'','KCSUP01',2,NULL),('01','KC',50146,'KCRFV07','KC343','2025-09-10','16:02:49',NULL,'','KCSUP01',2,NULL),('01','KC',50147,'KCRFV02','KC787','2025-09-10','16:08:48',NULL,'realizaron la cobranza, están montando pedido','KCSUP01',2,NULL),('01','KC',50148,'KCRFV01','KC849','2025-09-10','16:16:30',NULL,'se verifico el inventario','KCSUP01',2,NULL),('01','KC',50149,'KCRFV01','KC366','2025-09-10','16:34:00',NULL,'se verifico el inventario y se converso con la supervisora.','KCSUP01',2,NULL),('01','KC',50150,'KCRFV04','KC905','2025-09-10','17:03:22',NULL,'Tarde de día producto','KCSUP01',2,NULL),('01','KC',50151,'KCRFV01','KC355','2025-09-10','17:41:17',NULL,'se converso con supervisor y se cuadro un día producto.','KCSUP01',2,NULL),('01','KC',50152,'KCRFV03','KC804','2025-09-10','17:50:23',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50153,'KCRFV03','KC278','2025-09-10','17:50:47',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50154,'KCRFV03','KC296','2025-09-10','17:51:27',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50155,'KCRFV03','KC326','2025-09-10','17:51:42',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50156,'KCRFV03','KC304','2025-09-10','17:51:59',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50157,'KCRFV06','KC490','2025-09-12','08:16:44',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50158,'KCRFV06','KC491','2025-09-12','08:17:52',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50159,'KCRFV06','KC493','2025-09-12','08:18:21',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50160,'KCRFV06','KC494','2025-09-12','08:20:23',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50161,'KCRFV06','KC730','2025-09-12','08:22:21',NULL,'Visitada 11 de septiembre','KCSUP01',2,NULL),('01','KC',50162,'KCRFV06','KCRFV06N','2025-09-12','08:27:05',NULL,'Farmacia Farmachiven,c.a. Rif J 506359200.  Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50163,'KCRFV06','KC495','2025-09-12','08:27:56',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50164,'KCRFV06','KC496','2025-09-12','08:28:36',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50165,'KCRFV06','KC497','2025-09-12','08:29:16',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50166,'KCRFV06','KC499','2025-09-12','08:29:54',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50167,'KCRFV06','KC500','2025-09-12','08:30:35',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50168,'KCRFV06','KC501','2025-09-12','08:31:17',NULL,'Visitada el de septiembre','KCSUP01',2,NULL),('01','KC',50169,'KCRFV06','KC489','2025-09-12','08:31:54',NULL,'Visitada el 11 de Septiembre','KCSUP01',2,NULL),('01','KC',50170,'KCRFV06','KC886','2025-09-12','08:32:34',NULL,'Visitada el 11 de septiembre','KCSUP01',2,NULL),('01','KC',50171,'KCRFV05','KC143','2025-09-10','08:32:45',NULL,'Revisión de inventario y colocación de exhibición en frentillo de los productos OTC','KCSUP01',2,NULL),('01','KC',50172,'KCRFV05','KC225','2025-09-10','08:32:48',NULL,'Revisión de inventario y negociación de Pedido \nPromoción de Clotrimazol, \nLoratadina + ambroxol jarabe y tabla','KCSUP01',2,NULL),('01','KC',50173,'KCRFV05','KC160','2025-09-10','08:32:56',NULL,'Revisión de inventario y colocación de exhibición de los productos OTC','KCSUP01',2,NULL),('01','KC',50174,'KCRFV05','KC223','2025-09-10','08:33:00',NULL,'Revisión de inventario y negociación de Pedido \nPromoción de los productos: Clotrimazol, Loratadina + ambroxol y Carvedilol','KCSUP01',2,NULL),('01','KC',50175,'KCRFV05','KC222','2025-09-10','08:33:03',NULL,'Revisión de inventario y negociación de Pedido. \nPromoción de los productos: Loratadina + ambroxol jarabe y tabla. \nclotrimazol \nCarvedilol','KCSUP01',2,NULL),('01','KC',50176,'KCRFV05','KC260','2025-09-10','08:33:07',NULL,'Revisión de inventario y negociación de precios. \nPlanificación de actividad promocional con Terbinafina','KCSUP01',2,NULL),('01','KC',50177,'KCRFV05','KC261','2025-09-10','08:33:11',NULL,'Revisión de inventario y negociación de Pedido :\n504 unidades.','KCSUP01',2,NULL),('01','KC',50178,'KCRFV05','KC136','2025-09-09','08:33:15',NULL,'Revisión de inventario y promoción de los productos: Clotrimazol, Loratadina + ambroxol jarabe y tabla, Carvedilol','KCSUP01',2,NULL),('01','KC',50179,'KCRFV05','KC184','2025-09-09','08:33:46',NULL,'Revisión de inventario y negociación de Pedido \nPromoción de los productos: Clotrimazol, loratadina + ambroxol jarabe y tabletas','KCSUP01',2,NULL),('01','KC',50180,'KCRFV05','KC219','2025-09-09','08:33:50',NULL,'Revisión de inventario y negociación de Pedido \nPromoción de los productos: Clotrimazol, Loratadina + Ambroxol jarabe y tabla \nCarvedilol','KCSUP01',2,NULL),('01','KC',50181,'KCRFV05','KC233','2025-09-09','08:33:54',NULL,'Revisión de inventario y negociación de Pedido \nPromoción de los productos: Loratadina + ambroxol jarabe y tableta \nCarvedilol \nclotrimazol','KCSUP01',2,NULL),('01','KC',50182,'KCRFV05','KC217','2025-09-09','08:33:58',NULL,'Revisión de inventario y negociación de Pedido. \nPromoción de los productos: Loratadina + ambroxol jarabe y tabla. \nClotrimazol \nCarvedilol','KCSUP01',2,NULL),('01','KC',50183,'KCRFV05','KC216','2025-09-09','08:34:01',NULL,'Revisión de inventario y negociación de Pedido. \nPromoción de los productos: loratadina + ambroxol jarabe y tabla. \nclotrimazol \nCarvedilol','KCSUP01',2,NULL),('01','KC',50184,'KCRFV05','KC185','2025-09-09','08:34:04',NULL,'Revisión de inventario y promoción de los productos Loratadina + ambroxol jarabe y tabla, clotrimazol y Carvedilol','KCSUP01',2,NULL),('01','KC',50185,'KCRFV06','KCRFV06N','2025-09-12','08:34:58',NULL,'Farmaciasol Michelena II ,c.a  Rif J 505647083','KCSUP01',2,NULL),('01','KC',50186,'KCRFV05','KC203','2025-09-12','08:46:54',NULL,'Visita realizada el 11/09/2025\nRevisión de inventario y negociación de Pedido. \nPromoción de Clotrimazol, Loratadina + ambroxol jarabe y tabla','KCSUP01',2,NULL),('01','KC',50187,'KCRFV04','KC074','2025-09-12','09:04:19',NULL,'Visita FARMADETODO','KCSUP01',2,NULL),('01','KC',50188,'KCRFV05','KC206','2025-09-12','09:07:22',NULL,'visita el 11/09/2925\nRevisión de inventario y negociación de Pedido. \nPromoción de los productos antigripal y cardio','KCSUP01',2,NULL),('01','KC',50189,'KCRFV05','KC196','2025-09-12','09:08:57',NULL,'visita 11/09/3025\nRevisión de inventario y negociación de Pedido. \nPromoción de Clotrimazol y Loratadina + ambroxol jarabe y tabla.','KCSUP01',2,NULL),('01','KC',50190,'KCRFV05','KC207','2025-09-12','09:09:47',NULL,'revisión de inventario y negociación de Pedido. \nPromoción de los productos antigripal y cardio','KCSUP01',2,NULL),('01','KC',50191,'KCRFV05','KC190','2025-09-12','09:11:44',NULL,'Visita 11/09/2025\nRevisión de inventario colocación de exhibición de los productos OTC','KCSUP01',2,NULL),('01','KC',50192,'KCRFV05','KC192','2025-09-12','09:13:03',NULL,'Revisión de inventario y negociación de Pedido. \nPromoción de Clotrimazol y Loratadina + ambroxol jarabe y tab.\nCarvedilol','KCSUP01',2,NULL),('01','KC',50193,'KCRFV05','KC195','2025-09-12','09:16:22',NULL,'Revisión de inventario y colocación de exhibición de frentillo de los productos OTC','KCSUP01',2,NULL),('01','KC',50194,'KCRFV05','KC194','2025-09-12','09:18:10',NULL,'Visita el 11/09/2025\nRevisión de inventario y promoción de los productos Clotrimazol, Carvedidol y Loratadina +ambroxol jarabe y tableta.','KCSUP01',2,NULL),('01','KC',50195,'KCRFV05','KC197','2025-09-12','09:19:14',NULL,'Visita 11/09/2025\nRevisión de inventario y negociación de Pedido. \nPromoción de los productos antigripal y cardio','KCSUP01',2,NULL),('01','KC',50196,'KCRFV05','KC209','2025-09-12','09:20:54',NULL,'visita el 11/09/2025\nRevisión de inventario y negociación de Pedido. \nPromoción de los productos Loratadina +ambroxol jarabe y tableta. \nClotrimazol','KCSUP01',2,NULL),('01','KC',50197,'KCRFV05','KC210','2025-09-12','09:21:54',NULL,'Visita 11/09/2025\nRevisión de inventario y negociación de Pedido \nPromoción de los productos antigripal y cardio','KCSUP01',2,NULL),('01','KC',50198,'KCRFV05','KC199','2025-09-12','09:23:00',NULL,'Visita 11/09/2025\nRevisión de inventario y negociación de Pedido \nPromoción de los productos antigripal y cardio.','KCSUP01',2,NULL),('01','KC',50199,'KCRFV05','KC200','2025-09-12','09:25:32',NULL,'Visita 11/09/2025\nRevisión de inventario y negociación de Pedido \nPromoción de los productos antigripal y cardio','KCSUP01',2,NULL),('01','KC',50200,'KCRFV05','KC210','2025-09-12','09:27:34',NULL,'Visita 11/09/2025\nRevisión de inventario y colocación de exhibición de los productos OTC en frentillo.','KCSUP01',2,NULL),('01','KC',50201,'KCRFV05','KC268','2025-09-12','09:27:41',NULL,'Revisión de inventario y negociación de Pedido.','KCSUP01',2,NULL),('01','KC',50202,'KCRFV05','KC182','2025-09-08','09:27:45',NULL,'Revisión de inventario y promoción de los productos Loratadina + ambroxol jarabe y tableta, clotrimazol y Carvedilol','KCSUP01',2,NULL),('01','KC',50203,'KCRFV05','KC167','2025-09-08','09:27:49',NULL,'Revisión de inventario y promoción de los productos colocados en exhibición','KCSUP01',2,NULL),('01','KC',50204,'KCRFV05','KC147','2025-09-08','09:27:52',NULL,'Revisión de inventario y promoción de los productos Loratadina + ambroxol jarabe y tabla. clotrimazol vag y Carvedilol','KCSUP01',2,NULL),('01','KC',50205,'KCRFV05','KC206','2025-09-08','09:27:55',NULL,'Revisión de inventario y colocación de exhibición de los productos OTC en cabezal.','KCSUP01',2,NULL),('01','KC',50206,'KCRFV05','KC171','2025-09-08','09:27:58',NULL,'Revisión de inventario y negociación de Pedido. \nPromoción de Loratadina + ambroxol jarabe y tabla. \nClotrimazol vaginal \n Carvedilol','KCSUP01',2,NULL),('01','KC',50207,'KCRFV05','KC164','2025-09-08','09:28:01',NULL,'Revisión de inventario y negociación de Pedido','KCSUP01',2,NULL),('01','KC',50208,'KCRFV05','KC162','2025-09-08','09:28:06',NULL,'Revisión de inventario y negociación de Pedido. \nPromoción de Loratadina + ambroxol jarabe y tabla. \nclotrimazol y carvedilol','KCSUP01',2,NULL),('01','KC',50209,'KCRFV04','KC1005','2025-09-12','09:39:15',NULL,'','KCSUP01',2,NULL),('01','KC',50210,'KCRFV06','KC533','2025-09-12','09:46:30',NULL,'promociones septiembre y dctos kimiceg','KCSUP01',2,NULL),('01','KC',50211,'KCRFV01','KC1000','2025-09-12','09:52:10',NULL,'se visito el 11-09 \n\nse verifico el inventario','KCSUP01',2,NULL),('01','KC',50212,'KCRFV01','KC354','2025-09-12','09:53:27',NULL,'se visito el 12-09\n\n\nse chequeo rl inventario.','KCSUP01',2,NULL),('01','KC',50213,'KCRFV01','KC364','2025-09-12','09:54:39',NULL,'se visito el 11-09 \n\nse converso con la de compras y quedamos en hacer un día producto.','KCSUP01',2,NULL),('01','KC',50214,'KCRFV01','KC374','2025-09-12','09:55:35',NULL,'se visito el 11-09\n\nse verifico el inventario.','KCSUP01',2,NULL),('01','KC',50215,'KCRFV06','KC508','2025-09-12','10:02:06',NULL,'promociones septiembre y dctos','KCSUP01',2,NULL),('01','KC',50216,'KCRFV06','KC511','2025-09-12','10:13:45',NULL,'promocion septiembre ofertas y dctos','KCSUP01',2,NULL),('01','KC',50217,'KCRFV07','KCRFV07N','2025-09-12','10:17:41',NULL,'visita  Drosurven c.a.','KCSUP01',2,NULL),('01','KC',50218,'KCRFV06','KC512','2025-09-12','10:28:52',NULL,'promoción septiembre y ofertas','KCSUP01',2,NULL),('01','KC',50219,'KCRFV07','KC738','2025-09-12','10:58:13',NULL,'','KCSUP01',2,NULL),('01','KC',50220,'KCRFV06','KC505','2025-09-12','11:42:33',NULL,'planificación dia impulsó Revisión de inventarios','KCSUP01',2,NULL),('01','KC',50221,'KCRFV06','KC504','2025-09-12','12:01:36',NULL,'promociones septiembre ofertas y dctos','KCSUP01',2,NULL),('01','KC',50222,'KCRFV06','KC506','2025-09-12','12:09:33',NULL,'dctos y promociones septiembre promoción 1x1 loratadina mas Ambroxol.  tabletas','KCSUP01',2,NULL),('01','KC',50223,'KCRFV04','KC901','2025-09-12','12:17:32',NULL,'Día producto 9:51 HASTA LAS 12:00','KCSUP01',2,NULL),('01','KC',50224,'KCRFV06','KC507','2025-09-12','12:35:17',NULL,'promociones septiembres y dctos kimiceg','KCSUP01',2,NULL),('01','KC',50225,'KCRFV07','KC724','2025-09-12','13:26:28',NULL,'','KCSUP01',2,NULL),('01','KC',50226,'KCRFV01','KC371','2025-09-12','13:29:14',NULL,'se verifico el inventario','KCSUP01',2,NULL),('01','KC',50227,'KCRFV01','KC618','2025-09-12','13:36:57',NULL,'se cuadro una charla','KCSUP01',2,NULL),('01','KC',50228,'KCRFV07','KC339','2025-09-12','13:39:40',NULL,'','KCSUP01',2,NULL),('01','KC',50229,'KCRFV07','KC338','2025-09-12','13:52:29',NULL,'','KCSUP01',2,NULL),('01','KC',50230,'KCRFV01','KC361','2025-09-12','13:53:47',NULL,'se promocionó el producto Balsader','KCSUP01',2,NULL),('01','KC',50231,'KCRFV07','KCRFV07N','2025-09-12','14:13:02',NULL,'representantaciones médicas RY','KCSUP01',2,NULL),('01','KC',50232,'KCRFV01','KC354','2025-09-12','14:21:28',NULL,'se cuadro una charla','KCSUP01',2,NULL),('01','KC',50233,'KCRFV04','KC856','2025-09-12','14:45:12',NULL,'','KCSUP01',2,NULL),('01','KC',50234,'KCRFV03','KC272','2025-09-12','16:29:55',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50235,'KCRFV03','KC272','2025-09-12','16:31:47',NULL,'Negociación próxima OC. visitado el jueves 11/9','KCSUP01',2,NULL),('01','KC',50236,'KCRFV03','KC293','2025-09-12','16:32:25',NULL,'Negociación próxima transferencia.','KCSUP01',2,NULL),('01','KC',50237,'KCRFV03','KC290','2025-09-12','16:33:30',NULL,'Negociación próxima transferencia. Visitado el jueves 11/9','KCSUP01',2,NULL),('01','KC',50238,'KCRFV03','KC308','2025-09-12','16:34:21',NULL,'Solicitud apoyo rotación cartera de Kimiceg. Visitado el jueves 11/9','KCSUP01',2,NULL),('01','KC',50239,'KCRFV03','KC312','2025-09-12','16:34:32',NULL,'Solicitud apoyo rotación cartera de Kimiceg. Visitado el jueves 11/9','KCSUP01',2,NULL),('01','KC',50240,'KCRFV03','KC305','2025-09-12','16:34:40',NULL,'Solicitud apoyo rotación cartera de Kimiceg. Visitado el jueves 11/9','KCSUP01',2,NULL),('01','KC',50241,'KCRFV03','KC276','2025-09-12','16:35:27',NULL,'Cobranza.','KCSUP01',2,NULL),('01','KC',50242,'KCRFV03','KC274','2025-09-12','16:35:58',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50243,'KCRFV03','KC328','2025-09-12','16:36:38',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50244,'KCRFV03','KC327','2025-09-12','16:36:50',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50245,'KCRFV05','KC139','2025-09-12','19:58:21',NULL,'Día Producto hasta las 6 pm','KCSUP01',2,NULL),('01','KC',50246,'KCRFV05','KC138','2025-09-12','19:58:24',NULL,'Revisión de inventario y promoción de los productos Clotrimazol, Loratadina + ambroxol jarabe y tableta. \nCarvedilol','KCSUP01',2,NULL),('01','KC',50247,'KCRFV05','KC261','2025-09-12','19:58:28',NULL,'Presentación de la página de Transferencia. \nplanificación de actividades promocionales en el mes de Septiembre.','KCSUP01',2,NULL),('01','KC',50248,'KCRFV05','KC153','2025-09-12','19:58:31',NULL,'Revisión de inventario y se colocó exhibición en cabezal principal de los productos OTC','KCSUP01',2,NULL),('01','KC',50249,'KCRFV06','KC1018','2025-09-15','09:00:04',NULL,'promociones septiembre ofertas y dctos','KCSUP01',2,NULL),('01','KC',50250,'KCRFV07','KC842','2025-09-15','09:02:04',NULL,'','KCSUP01',2,NULL),('01','KC',50251,'KCRFV07','KC844','2025-09-15','09:20:13',NULL,'','KCSUP01',2,NULL),('01','KC',50252,'KCRFV06','KC526','2025-09-15','09:26:18',NULL,'','KCSUP01',2,NULL),('01','KC',50253,'KCRFV07','KC573','2025-09-15','09:38:36',NULL,'','KCSUP01',2,NULL),('01','KC',50254,'KCRFV06','KC527','2025-09-15','09:39:39',NULL,'planificación día impulso','KCSUP01',2,NULL),('01','KC',50255,'KCRFV06','KC528','2025-09-15','10:03:17',NULL,'promociones septiembre y dctos','KCSUP01',2,NULL),('01','KC',50256,'KCRFV04','KC090','2025-09-15','10:08:30',NULL,'','KCSUP01',2,NULL),('01','KC',50257,'KCRFV06','KC525','2025-09-15','10:21:38',NULL,'ofertas y promociones septiembre','KCSUP01',2,NULL),('01','KC',50258,'KCRFV02','KC002','2025-09-15','10:25:17',NULL,'jornada medica desde las 9 hasta las 12','KCSUP01',2,NULL),('01','KC',50259,'KCRFV02','KC018','2025-09-15','10:29:31',NULL,'se realizo pedido por dronena, se visito el día jueves','KCSUP01',2,NULL),('01','KC',50260,'KCRFV07','KC985','2025-09-15','10:30:00',NULL,'','KCSUP01',2,NULL),('01','KC',50261,'KCRFV02','KC038','2025-09-15','10:30:04',NULL,'se visito el día jueves','KCSUP01',2,NULL),('01','KC',50262,'KCRFV02','KCRFV02N','2025-09-15','10:30:53',NULL,'farmacia atenes san criatobal eso tachira  se viaito el dia jueves','KCSUP01',2,NULL),('01','KC',50263,'KCRFV06','KC530','2025-09-15','10:35:02',NULL,'promociones septiembre kimiceg','KCSUP01',2,NULL),('01','KC',50264,'KCRFV02','KC072','2025-09-15','10:38:23',NULL,'se visito el jueves a 11-09','KCSUP01',2,NULL),('01','KC',50265,'KCRFV07','KCRFV07N','2025-09-15','10:39:48',NULL,'Farma Milán Santa Rita c.a...envío información por correo de Data de la farmacia','KCSUP01',2,NULL),('01','KC',50266,'KCRFV06','KC524','2025-09-15','10:48:10',NULL,'promoción 5% de dctos día Kimiceg con droguería Drovencentro dia16 de septiembre','KCSUP01',2,NULL),('01','KC',50267,'KCRFV06','KC531','2025-09-15','10:59:06',NULL,'promociones septiembre','KCSUP01',2,NULL),('01','KC',50268,'KCRFV02','KC1017','2025-09-15','11:13:38',NULL,'se visito el jueves  11-09','KCSUP01',2,NULL),('01','KC',50269,'KCRFV02','KC799','2025-09-15','11:14:55',NULL,'se visito el viernes 12-09','KCSUP01',2,NULL),('01','KC',50270,'KCRFV02','KC927','2025-09-15','11:15:56',NULL,'se visito el 12-09','KCSUP01',2,NULL),('01','KC',50271,'KCRFV06','KC533','2025-09-15','11:16:35',NULL,'promoción día Kimiceg en Droguería Drovencentro 5% de dcto','KCSUP01',2,NULL),('01','KC',50272,'KCRFV02','KC928','2025-09-15','11:16:48',NULL,'se visito el día 12-09','KCSUP01',2,NULL),('01','KC',50273,'KCRFV02','KC795','2025-09-15','11:18:40',NULL,'se realizo la vista el viernes 12','KCSUP01',2,NULL),('01','KC',50274,'KCRFV02','KC796','2025-09-15','11:19:45',NULL,'se visito el dia viernes 12-9','KCSUP01',2,NULL),('01','KC',50275,'KCRFV07','KC574','2025-09-15','11:20:08',NULL,'','KCSUP01',2,NULL),('01','KC',50276,'KCRFV02','KC797','2025-09-15','11:20:51',NULL,'se visto el 12-9','KCSUP01',2,NULL),('01','KC',50277,'KCRFV02','KC794','2025-09-15','11:22:09',NULL,'se visto el día viernes 12-09','KCSUP01',2,NULL),('01','KC',50278,'KCRFV02','KC780','2025-09-15','11:24:05',NULL,'se visto y se retiro material dejado en la drogueria ya que esa semana estuve trabajando en zona foránea tachira','KCSUP01',2,NULL),('01','KC',50279,'KCRFV06','KC954','2025-09-15','11:33:14',NULL,'promoción día 16 por Droguería Drovencentro 5%,dctos en todo los productos kimiceg','KCSUP01',2,NULL),('01','KC',50280,'KCRFV02','KC630','2025-09-15','11:37:07',NULL,'','KCSUP01',2,NULL),('01','KC',50281,'KCRFV02','KC006','2025-09-15','11:37:20',NULL,'','KCSUP01',2,NULL),('01','KC',50282,'KCRFV04','KC871','2025-09-15','11:37:30',NULL,'','KCSUP01',2,NULL),('01','KC',50283,'KCRFV07','KC845','2025-09-15','11:49:37',NULL,'','KCSUP01',2,NULL),('01','KC',50284,'KCRFV01','KC379','2025-09-15','11:57:11',NULL,'se cuadro una jornada médica','KCSUP01',2,NULL),('01','KC',50285,'KCRFV04','KC856','2025-09-15','11:58:58',NULL,'','KCSUP01',2,NULL),('01','KC',50286,'KCRFV07','KC575','2025-09-15','12:02:12',NULL,'','KCSUP01',2,NULL),('01','KC',50287,'KCRFV07','KC561','2025-09-15','12:13:40',NULL,'','KCSUP01',2,NULL),('01','KC',50288,'KCRFV02','KC633','2025-09-15','12:17:57',NULL,'','KCSUP01',2,NULL),('01','KC',50289,'KCRFV01','KC366','2025-09-15','12:24:23',NULL,'se verifico el inventario','KCSUP01',2,NULL),('01','KC',50290,'KCRFV07','KC576','2025-09-15','12:31:08',NULL,'','KCSUP01',2,NULL),('01','KC',50291,'KCRFV06','KC435','2025-09-15','12:31:44',NULL,'planificación día Impulsó','KCSUP01',2,NULL),('01','KC',50292,'KCRFV02','KC005','2025-09-15','15:05:25',NULL,'','KCSUP01',2,NULL),('01','KC',50293,'KCRFV02','KC007','2025-09-15','15:05:34',NULL,'','KCSUP01',2,NULL),('01','KC',50294,'KCRFV04','KC900','2025-09-15','15:31:04',NULL,'','KCSUP01',2,NULL),('01','KC',50295,'KCRFV02','KC039','2025-09-15','15:36:48',NULL,'','KCSUP01',2,NULL),('01','KC',50296,'KCRFV02','KC041','2025-09-15','16:43:59',NULL,'','KCSUP01',2,NULL),('01','KC',50297,'KCRFV03','KC274','2025-09-15','18:24:07',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50298,'KCRFV03','KC270','2025-09-15','18:24:50',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50299,'KCRFV03','KC328','2025-09-15','18:25:34',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50300,'KCRFV03','KC327','2025-09-15','18:25:42',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50301,'KCRFV03','KC291','2025-09-15','18:26:56',NULL,'Negociación próxima transferencia.','KCSUP01',2,NULL),('01','KC',50302,'KCRFV04','KC1003','2025-09-15','20:04:38',NULL,'Desde las 3 hasta 5:30','KCSUP01',2,NULL),('01','KC',50303,'KCRFV06','KC444','2025-09-16','08:12:39',NULL,'Entrega de bonificación 1x1 promocion','KCSUP01',2,NULL),('01','KC',50304,'KCRFV06','KC488','2025-09-16','08:33:52',NULL,'Participación día producto Kimiceg promoción 5% de dcto','KCSUP01',2,NULL),('01','KC',50305,'KCRFV07','KC933','2025-09-16','09:47:51',NULL,'','KCSUP01',2,NULL),('01','KC',50306,'KCRFV06','KC514','2025-09-16','09:58:08',NULL,'ofertas día Kimiceg por Droguería Drovencentro','KCSUP01',2,NULL),('01','KC',50307,'KCRFV01','KC368','2025-09-16','10:01:24',NULL,'se verifico el inventario','KCSUP01',2,NULL),('01','KC',50308,'KCRFV06','KC517','2025-09-16','10:12:32',NULL,'está cerrada','KCSUP01',2,NULL),('01','KC',50309,'KCRFV06','KC518','2025-09-16','10:14:10',NULL,'promoción 5% Por Droguería Drovencentro hoy 16 de septiembre','KCSUP01',2,NULL),('01','KC',50310,'KCRFV06','KC519','2025-09-16','11:00:13',NULL,'promoción día Kimiceg 5% hoy 16 de septiembre por Droguería Drovencentro','KCSUP01',2,NULL),('01','KC',50311,'KCRFV04','KC870','2025-09-16','11:03:23',NULL,'Visita al personal de la Droguería','KCSUP01',2,NULL),('01','KC',50312,'KCRFV06','KC520','2025-09-16','11:15:00',NULL,'promoción Droguería Drovencentro solo hoy 16 de septiembre 5% de dcto','KCSUP01',2,NULL),('01','KC',50313,'KCRFV06','KC487','2025-09-16','11:43:07',NULL,'promociones septiembre kimiceg','KCSUP01',2,NULL),('01','KC',50314,'KCRFV02','KC577','2025-09-16','11:44:53',NULL,'','KCSUP01',2,NULL),('01','KC',50315,'KCRFV02','KC632','2025-09-16','11:46:43',NULL,'','KCSUP01',2,NULL),('01','KC',50316,'KCRFV02','KC629','2025-09-16','11:47:18',NULL,'','KCSUP01',2,NULL),('01','KC',50317,'KCRFV01','KC393','2025-09-16','12:07:11',NULL,'se sacó pedido por Droguería Activa','KCSUP01',2,NULL),('01','KC',50318,'KCRFV02','KC634','2025-09-16','12:11:36',NULL,'','KCSUP01',2,NULL),('01','KC',50319,'KCRFV06','KC521','2025-09-16','12:18:59',NULL,'promoción 5%de dctos por Droguería Drovencentro el día 16 de septiembre','KCSUP01',2,NULL),('01','KC',50320,'KCRFV02','KC631','2025-09-16','12:20:36',NULL,'','KCSUP01',2,NULL),('01','KC',50321,'KCRFV02','KC895','2025-09-16','12:29:22',NULL,'','KCSUP01',2,NULL),('01','KC',50322,'KCRFV02','KC001','2025-09-16','12:34:36',NULL,'','KCSUP01',2,NULL),('01','KC',50323,'KCRFV02','KC003','2025-09-16','12:34:47',NULL,'','KCSUP01',2,NULL),('01','KC',50324,'KCRFV02','KC012','2025-09-16','12:43:58',NULL,'','KCSUP01',2,NULL),('01','KC',50325,'KCRFV06','KC522','2025-09-16','12:47:24',NULL,'promociones septiembre','KCSUP01',2,NULL),('01','KC',50326,'KCRFV06','KC523','2025-09-16','13:14:48',NULL,'promociones septiembre','KCSUP01',2,NULL),('01','KC',50327,'KCRFV01','KC386','2025-09-16','13:15:41',NULL,'se promocionó el Balsader','KCSUP01',2,NULL),('01','KC',50328,'KCRFV07','KC875','2025-09-16','14:02:51',NULL,'','KCSUP01',2,NULL),('01','KC',50329,'KCRFV07','KC678','2025-09-16','14:19:41',NULL,'','KCSUP01',2,NULL),('01','KC',50330,'KCRFV07','KC677','2025-09-16','14:28:29',NULL,'','KCSUP01',2,NULL),('01','KC',50331,'KCRFV07','KC946','2025-09-16','14:38:54',NULL,'','KCSUP01',2,NULL),('01','KC',50332,'KCRFV07','KC679','2025-09-16','15:12:58',NULL,'','KCSUP01',2,NULL),('01','KC',50333,'KCRFV07','KC676','2025-09-16','15:43:46',NULL,'','KCSUP01',2,NULL),('01','KC',50334,'KCRFV04','KC1003','2025-09-16','15:44:08',NULL,'','KCSUP01',2,NULL),('01','KC',50335,'KCRFV04','KC822','2025-09-16','15:57:57',NULL,'','KCSUP01',2,NULL),('01','KC',50336,'KCRFV01','KC370','2025-09-16','15:59:40',NULL,'se verifico el inventario','KCSUP01',2,NULL),('01','KC',50337,'KCRFV07','KC675','2025-09-16','16:12:36',NULL,'excelente pedido por Intercontinental','KCSUP01',2,NULL),('01','KC',50338,'KCRFV04','KC091','2025-09-16','16:15:56',NULL,'','KCSUP01',2,NULL),('01','KC',50339,'KCRFV04','KC083','2025-09-16','16:17:10',NULL,'','KCSUP01',2,NULL),('01','KC',50340,'KCRFV01','KC731','2025-09-16','16:51:06',NULL,'se converso con la Regente y se cuadro un día producto','KCSUP01',2,NULL),('01','KC',50341,'KCRFV04','KC906','2025-09-16','17:06:10',NULL,'','KCSUP01',2,NULL),('01','KC',50342,'KCRFV04','KC1006','2025-09-16','17:25:10',NULL,'','KCSUP01',2,NULL),('01','KC',50343,'KCRFV07','KC663','2025-09-17','09:08:41',NULL,'','KCSUP01',2,NULL),('01','KC',50344,'KCRFV06','KC544','2025-09-17','09:11:57',NULL,'efectuó pedido','KCSUP01',2,NULL),('01','KC',50345,'KCRFV04','KC857','2025-09-17','09:36:23',NULL,'Serví farmacia barinitas','KCSUP01',2,NULL),('01','KC',50346,'KCRFV01','KC419','2025-09-17','09:36:36',NULL,'Se converso para volver activar los pedidos','KCSUP01',2,NULL),('01','KC',50347,'KCRFV06','KC535','2025-09-17','09:38:03',NULL,'tramites triángulacion por Drovencentro','KCSUP01',2,NULL),('01','KC',50348,'KCRFV02','KC782','2025-09-17','09:39:48',NULL,'','KCSUP01',2,NULL),('01','KC',50349,'KCRFV06','KC536','2025-09-17','09:57:48',NULL,'promoción septiembre','KCSUP01',2,NULL),('01','KC',50350,'KCRFV06','KC537','2025-09-17','10:09:15',NULL,'Revisión inventarios','KCSUP01',2,NULL),('01','KC',50351,'KCRFV06','KC540','2025-09-17','10:19:11',NULL,'ofertas y dctos septiembre','KCSUP01',2,NULL),('01','KC',50352,'KCRFV01','KC404','2025-09-17','10:27:08',NULL,'se montó pedido','KCSUP01',2,NULL),('01','KC',50353,'KCRFV06','KC538','2025-09-17','10:29:21',NULL,'Revisión de inventarios','KCSUP01',2,NULL),('01','KC',50354,'KCRFV02','KC040','2025-09-17','10:30:12',NULL,'','KCSUP01',2,NULL),('01','KC',50355,'KCRFV04','KCRFV04N','2025-09-17','10:40:48',NULL,'FARMACIA GRAMA BARINITAS','KCSUP01',2,NULL),('01','KC',50356,'KCRFV04','KC951','2025-09-17','10:40:54',NULL,'Por favor cambiar el nombre para edentificarlano se cual de estas qué apare como divina pastora es la de barinitas pueden corregir por favor FARMACIA LA PASTOREÑA ( Grupo divina pastora)','KCSUP01',2,NULL),('01','KC',50357,'KCRFV02','KC957','2025-09-17','10:46:29',NULL,'','KCSUP01',2,NULL),('01','KC',50358,'KCRFV06','KC542','2025-09-17','10:57:42',NULL,'ofertas y promociones septiembre','KCSUP01',2,NULL),('01','KC',50359,'KCRFV02','KC582','2025-09-17','11:10:37',NULL,'','KCSUP01',2,NULL),('01','KC',50360,'KCRFV06','KC541','2025-09-17','11:22:20',NULL,'promociones septiembres','KCSUP01',2,NULL),('01','KC',50361,'KCRFV04','KCRFV04N','2025-09-17','11:25:14',NULL,'FARMACIA FARMABIEN BARINITAS','KCSUP01',2,NULL),('01','KC',50362,'KCRFV06','KC543','2025-09-17','11:45:05',NULL,'promociones septiembre y dctos','KCSUP01',2,NULL),('01','KC',50363,'KCRFV02','KC010','2025-09-17','11:50:29',NULL,'','KCSUP01',2,NULL),('01','KC',50364,'KCRFV02','KC009','2025-09-17','11:50:41',NULL,'','KCSUP01',2,NULL),('01','KC',50365,'KCRFV02','KC011','2025-09-17','11:50:50',NULL,'','KCSUP01',2,NULL),('01','KC',50366,'KCRFV02','KC013','2025-09-17','11:52:30',NULL,'se solicitó  el inventario de todo el grupo y se planifico actividad para los 51aniversatio de farmacia la nueva en pampan','KCSUP01',2,NULL),('01','KC',50367,'KCRFV07','KC333','2025-09-17','14:25:40',NULL,'','KCSUP01',2,NULL),('01','KC',50368,'KCRFV07','KC334','2025-09-17','14:39:50',NULL,'','KCSUP01',2,NULL),('01','KC',50369,'KCRFV07','KC345','2025-09-17','14:54:31',NULL,'','KCSUP01',2,NULL),('01','KC',50370,'KCRFV07','KC337','2025-09-17','15:13:02',NULL,'','KCSUP01',2,NULL),('01','KC',50371,'KCRFV07','KC336','2025-09-17','15:25:50',NULL,'','KCSUP01',2,NULL),('01','KC',50372,'KCRFV07','KC335','2025-09-17','16:02:40',NULL,'','KCSUP01',2,NULL),('01','KC',50373,'KCRFV01','KC417','2025-09-17','16:54:56',NULL,'se converso sobre las promociónes y pago de facturas pendientes','KCSUP01',2,NULL),('01','KC',50374,'KCRFV04','KC917','2025-09-17','18:08:58',NULL,'Presencia de KIMICEG EN Droguería san Gregorio cumpleaños del Dr SALME DUEÑO DE LA DROGUERÍA','KCSUP01',2,NULL),('01','KC',50375,'KCRFV03','KC275','2025-09-17','18:10:57',NULL,'Visitado el 16-9-25. Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50376,'KCRFV03','KC283','2025-09-17','18:12:06',NULL,'Visitado el 16-9-25. Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50377,'KCRFV03','KC329','2025-09-17','18:12:52',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50378,'KCRFV03','KC331','2025-09-17','18:13:09',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50379,'KCRFV03','KC300','2025-09-17','18:13:28',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50380,'KCRFV03','KC321','2025-09-17','18:13:44',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50381,'KCRFV03','KC286','2025-09-17','18:16:04',NULL,'Negociación próxima OC.','KCSUP01',2,NULL),('01','KC',50382,'KCRFV03','KC315','2025-09-17','18:17:09',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50383,'KCRFV03','KC302','2025-09-17','18:20:00',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50384,'KCRFV03','KC307','2025-09-17','18:20:18',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50385,'KCRFV03','KC301','2025-09-17','18:27:03',NULL,'Solicitud apoyo rotación cartera de Kimiceg.','KCSUP01',2,NULL),('01','KC',50386,'KCRFV04','KC118','2025-09-12','08:48:47',NULL,'','KCSUP01',2,NULL),('01','KC',50387,'KCRFV07','KCRFV07N','2025-09-18','09:09:56',NULL,'Farma Milán Santa Rita c.a.   Día de Producto de 9 00 a 12 00 .......envío fotos de la actividad y también ficha de la farmacia que pertenece al grupo Farma Milán','KCSUP01',2,NULL),('01','KC',50388,'KCRFV06','KC760','2025-09-18','09:47:21',NULL,'promociones septiembres','KCSUP01',2,NULL),('01','KC',50389,'KCRFV01','KC397','2025-09-18','09:57:19',NULL,'se verifico el inventario','KCSUP01',2,NULL),('01','KC',50390,'KCRFV06','KC766','2025-09-18','09:59:38',NULL,'promociones septiembre y dctos','KCSUP01',2,NULL),('01','KC',50391,'KCRFV01','KC399','2025-09-18','10:07:33',NULL,'se promoció el Balsader','KCSUP01',2,NULL),('01','KC',50392,'KCRFV06','KC767','2025-09-18','10:15:28',NULL,'promociones y dctos septiembre','KCSUP01',2,NULL),('01','KC',50393,'KCRFV06','KC1014','2025-09-18','10:22:36',NULL,'promociones septiembre y dctos día Kimiceg el 22 de septiembre','KCSUP01',2,NULL),('01','KC',50394,'KCRFV04','KC824','2025-09-18','10:37:02',NULL,'','KCSUP01',2,NULL),('01','KC',50395,'KCRFV04','KC079','2025-09-18','10:37:07',NULL,'','KCSUP01',2,NULL),('01','KC',50396,'KCRFV06','KC436','2025-09-18','10:48:48',NULL,'Revisión inventarios','KCSUP01',2,NULL),('01','KC',50397,'KCRFV06','KC1011','2025-09-18','11:02:27',NULL,'promociones y ofertas septiembre','KCSUP01',2,NULL),('01','KC',50398,'KCRFV06','KC769','2025-09-18','11:23:25',NULL,'promociones septiembre','KCSUP01',2,NULL),('01','KC',50399,'KCRFV06','KC1012','2025-09-18','11:38:11',NULL,'promoción día Kimiceg con Droguería Drovencentro el 22 de septiembre','KCSUP01',2,NULL),('01','KC',50400,'KCRFV06','KC748','2025-09-18','11:47:14',NULL,'Promocion día Kimiceg 22 de septiembre ofertas y dctos','KCSUP01',2,NULL),('01','KC',50401,'KCRFV06','KC759','2025-09-18','11:58:07',NULL,'promoción dia 22 de septiembre por Drovencentro 5% de dcto','KCSUP01',2,NULL),('01','KC',50402,'KCRFV01','KC414','2025-09-18','12:42:23',NULL,'se montó ODC','KCSUP01',2,NULL),('01','KC',50403,'KCRFV07','KC845','2025-09-18','12:44:52',NULL,'','KCSUP01',2,NULL),('01','KC',50404,'KCRFV07','KC985','2025-09-18','13:02:57',NULL,'','KCSUP01',2,NULL),('01','KC',50405,'KCRFV06','KC746','2025-09-18','13:29:37',NULL,'promoción 5% día 22 de septiembre por Droguería Drovencentro ofertas y dctos','KCSUP01',2,NULL),('01','KC',50406,'KCRFV07','KC570','2025-09-18','13:48:20',NULL,'','KCSUP01',2,NULL),('01','KC',50407,'KCRFV04','KC111','2025-09-18','15:13:17',NULL,'','KCSUP01',2,NULL),('01','KC',50408,'KCRFV04','KC818','2025-09-18','15:13:25',NULL,'Dia de impulso  10:30 a 12:00','KCSUP01',2,NULL),('01','KC',50409,'KCRFV04','KC816','2025-09-18','16:14:19',NULL,'','KCSUP01',2,NULL),('01','KC',50410,'KCRFV01','KC422','2025-09-18','16:42:01',NULL,'se converso sobre la rotación de los productos','KCSUP01',2,NULL),('01','KC',50411,'KCRFV04','KC855','2025-09-18','17:22:11',NULL,'','KCSUP01',2,NULL),('01','KC',50412,'KCRFV04','KC905','2025-09-18','17:22:16',NULL,'','KCSUP01',2,NULL);

--
-- Table structure for table `t_precio_monedas`
--

CREATE TABLE `t_precio_monedas` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `idprecio_moneda` int NOT NULL AUTO_INCREMENT COMMENT 'Este es el identificador unico de precio moneda',
  `idpais` varchar(3) DEFAULT NULL COMMENT 'En este Caso la empresa es VEN, Identificador del pais al que pertenece la empresa',
  `idmoneda` int DEFAULT NULL COMMENT 'codigo de la moneda Bs. que se maneja en el pais donde esta la empresa',
  `tasa_precio_moneda` decimal(17,8) DEFAULT NULL COMMENT 'Indica la tasa de precio de la moneda',
  `fecha_precio` date NOT NULL COMMENT 'Indica la fecha del precio',
  `fecha_precio_registro` datetime DEFAULT NULL COMMENT 'Indica la fecha en que se registro el precio',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus de precio moneda, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`idprecio_moneda`),
  KEY `fk_tpreciomoneda_toperador_idx` (`idOperador`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_precio_monedas`
--


--
-- Table structure for table `t_productos`
--

CREATE TABLE `t_productos` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idfabricante` varchar(11) NOT NULL COMMENT 'Este es el Identificador del Fabricante de este Producto',
  `idproducto` varchar(11) NOT NULL COMMENT 'Este es el identificador del producto',
  `idPersona` varchar(11) NOT NULL COMMENT 'Este es el identificador de la Persona que registra este Producto',
  `idMayorista` varchar(11) NOT NULL COMMENT 'Este es el identificador del Mayorista que vende o mercadea este Producto',
  `idpais` varchar(3) DEFAULT NULL COMMENT 'En este Caso la empresa es VEN, Identificador del pais al que pertenece la empresa',
  `ididioma` varchar(3) DEFAULT NULL COMMENT 'codigo del idioma en este Caso es ESP,  que se maneja la Persona en el pais donde esta la empresa',
  `idmoneda` varchar(3) DEFAULT NULL COMMENT 'codigo de la moneda Bs. que se maneja en el pais donde esta la empresa',
  `idlinea_producto` varchar(5) NOT NULL COMMENT 'Este es el identificador unico de  linea o grupo de producto  a la que pertenece este  producto',
  `idtipo_producto` int NOT NULL COMMENT 'Este es el codigo de los tipos de productos o familia de tipo que agrpan los producto',
  `nombre_producto` varchar(100) NOT NULL COMMENT 'Este es el campo para el nombre del producto',
  `descripcion_producto` longtext COMMENT 'En este campo va la descripcion del producto, es decir donde se muestran las caracteristica',
  `principio_producto` longtext COMMENT 'En este campo va la descripcion del principio activo del producto',
  `Precio_producto` decimal(17,2) DEFAULT '0.00' COMMENT 'En este camo va contenido el precio del producto',
  `Descuento_producto` decimal(17,2) DEFAULT '0.00' COMMENT 'Este campo contiene el Descuento del producto',
  `idcategorias` varchar(5) NOT NULL COMMENT 'Este es el identificador de categoria a la que pertenece este producto',
  `presentacion` varchar(20) NOT NULL COMMENT 'Este es el campo de las Medidas en que está el producto. Este puede ser 1. grageas, 2. jarabe, 3. comprimidos, 4. polvo, 5. cremas, 6. masticables, 7. mg, 8. ml, 9. gramos, etc.',
  `cantidad_producto_existente` int DEFAULT NULL COMMENT 'Este campo indica la cantidad del producto ',
  `fechaRegistro_producto` date DEFAULT NULL COMMENT 'Indica la fecha de registro del producto para su venta',
  `fechaExpedicion_producto` date DEFAULT NULL COMMENT 'Indica la fecha de elaboracion del producto',
  `fechaVencimiento_producto` date DEFAULT NULL COMMENT 'Indica la fecha de Vencimiento del producto',
  `dias_publicacion` varchar(3) DEFAULT NULL COMMENT 'Prioridad como el producto mas buscado niveles 1,2,3,4,5.....Producto en Oferta y mas buscado',
  `idpromocion` int DEFAULT NULL COMMENT 'Este es el identificador de la promocion',
  `lote` varchar(20) DEFAULT 'S/L' COMMENT 'Este es el numero o identificacion del lote de la muestra a ser entregada al cliente',
  `FechaInicioPublicacion` date DEFAULT NULL COMMENT 'Indica la fecha en que inicio la publicacion del producto o servicio',
  `FechaFinPublicacion` date DEFAULT NULL COMMENT 'Indica la fecha en que culminó la publicacion del producto o servicio',
  `estatus_producto` int DEFAULT '1' COMMENT 'Indica el estatus de producto, este puede ser 1.Activo, 2. Inactivo',
  `idunidades` int DEFAULT NULL,
  PRIMARY KEY (`idproducto`,`idcategorias`,`presentacion`),
  UNIQUE KEY `idproducto_UNIQUE` (`idproducto`,`idfabricante`),
  KEY `fk_tproducto_toperador_idx` (`idOperador`),
  KEY `fk_tproducto_tfabricante_idx` (`idfabricante`),
  KEY `fk_tproducto_tpersonaregistrador_idx` (`idPersona`),
  KEY `fk_tproducto_tmayorista_idx` (`idMayorista`),
  KEY `fk_tproducto_ttipoproducto_idx` (`idtipo_producto`),
  KEY `fk_tprodcuto_tcategoriaproducto_idx` (`idcategorias`),
  KEY `fk_tproducto_tunidades_idx` (`presentacion`),
  KEY `fk_tproducto_tlinea_idx` (`idlinea_producto`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_productos`
--

INSERT INTO `t_productos` VALUES ('01','FCPHARMA','2050310','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'ANAPIR  200 MG 10xCAPSULAS BLANDAS','ANAPIR  200 MG 10xCAPSULAS BLANDAS',NULL,1.00,0.00,'FARM','S/P',9976,'2018-03-01','2018-07-11','2018-07-11',NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','DEMO','20606100','DEMO','MAY00001','237','es',NULL,'PED',7,'HT BRUSH PEINE C/MANGO GOMA','HT BRUSH PEINE C/MANGO GOMA',NULL,75000.00,0.00,'MUES','Unico',100000,'2018-03-01',NULL,NULL,NULL,NULL,'SIN-LOTE',NULL,NULL,0,NULL),('01','FCPHARMA','20706100','FCPHARMA','MAY00001','237','es',NULL,'PED',7,'HT BRUSH PEINE ACERO','HT BRUSH PEINE ACERO',NULL,15220.20,0.00,'FARM','Unico',99988,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','20804200','FCPHARMA','MAY00001','237','es',NULL,'TRA',7,'ARNICA FC PLUS GEL','ARNICA FC PLUS GEL',NULL,20520.45,0.00,'FARM','250 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','21007150','FCPHARMA','MAY00001','237','es',NULL,'GIN',7,'AMARENFEM','AMARENFEM',NULL,25520.75,0.00,'FARM','150 grs X 1',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','21108200','FCPHARMA','MAY00001','237','es',NULL,'GIN',7,'PERLAVIS FEMME','PERLAVIS FEMME',NULL,75005.00,0.00,'FARM','200 ml',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','21208200','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'PERLAVIS HOMME','PERLAVIS HOMME',NULL,75006.00,0.00,'FARM','200 ml',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','21308200','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'NACIVIT E','NACIVIT E',NULL,75002.00,0.00,'FARM','200 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','21408200','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'NACIVIT C','NACIVIT C',NULL,75001.00,0.00,'FARM','200 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','21508360','FCPHARMA','MAY00001','237','es',NULL,'GIN',7,'PERLAVIS FEMME','PERLAVIS FEMME',NULL,75004.00,0.00,'FARM','360 ml',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2160531','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'VITAMINA C','VITAMINA C',NULL,15220.20,0.00,'FARM','500 grs. X 30',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2180930','FCPHARMA','MAY00001','237','es',NULL,'GIN',7,'DARMADE','DARMADE',NULL,75000.00,0.00,'FARM','1000 UI X 30',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2190390','FCPHARMA','MAY00001','237','es',NULL,'TRA',7,'ARNICA FC PLUS ROLL ON','ARNICA FC PLUS ROLL ON',NULL,15220.20,0.00,'FARM','90 grs',99976,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2200390','FCPHARMA','MAY00001','237','es',NULL,'TRA',7,'ARNICA FC FORTE ROLL ON','ARNICA FC FORTE ROLL ON',NULL,20520.45,0.00,'FARM','90 grs',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','22104250','FCPHARMA','MAY00001','237','es',NULL,'TRA',7,'ARNICA FC GEL','ARNICA FC GEL',NULL,75000.00,0.00,'FARM','250 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','22204200','FCPHARMA','MAY00001','237','es',NULL,'TRA',7,'ARNICA FC FORTE GEL','ARNICA FC FORTE GEL',NULL,25520.75,0.00,'FARM','250 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','22308200','FCPHARMA','MAY00001','237','es',NULL,'GIN',7,'PERLAVIS FEMME TEENS','PERLAVIS FEMME TEENS',NULL,75003.00,0.00,'FARM','200 ml',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2240830','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'MENTORUB','MENTORUB',NULL,15220.20,0.00,'FARM','30 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2260860','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'MENTORUB','MENTORUB',NULL,75000.00,0.00,'FARM','60 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','22708200','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'MAXWET GEL FIJADOR P/CABELLO','MAXWET GEL FIJADOR P/CABELLO',NULL,20520.45,0.00,'FARM','250 grs.',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','22808120','FCPHARMA','MAY00001','237','es',NULL,'PED',7,'HT BRUSH GEL ESPUMANTE','HT BRUSH GEL ESPUMANTE',NULL,25520.75,0.00,'FARM','60 ml',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','22911120','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'JARABE DE ZABILA CON MIEL','JARABE DE ZABILA CON MIEL',NULL,15220.20,0.00,'FARM','120 cm3',99965,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','22911121','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'JARABE DE ZABILA CON MIEL','JARABE DE ZABILA CON MIEL',NULL,75000.00,0.00,'FARM','120 cm3',99969,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','23112120','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'JARABE DE VALERIANA','JARABE DE VALERIANA',NULL,20520.75,0.00,'FARM','120 cm3',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2320360','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'GOTAS DE ARNICA','GOTAS DE ARNICA',NULL,25520.75,0.00,'FARM','60 cm3',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2420205','FCPHARMA','MAY00001','237','es',NULL,'OTR',7,'SINUTIL NOCHE','SINUTIL NOCHE',NULL,20520.45,0.00,'FARM',' X 5',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','2451560','FCPHARMA','MAY00001','237','es',NULL,'PED',7,'SOLUCION FISIOLOGICA','SOLUCION FISIOLOGICA',NULL,75000.00,0.00,'FARM','60 ml',100000,'2018-03-01',NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','DEMO','5478','SIIFADMIN','DEMOM1',NULL,NULL,NULL,'DLIN',1,'DEMOPRODUC','DEMOPRODUC',NULL,NULL,NULL,'MUES','S/N',10,'2025-02-06','2025-02-06','2025-02-28',NULL,NULL,'20',NULL,NULL,1,NULL),('01','DEMO','6363','SIIFADMIN','DEMOM1',NULL,NULL,NULL,'DLIN',1,'DEMOPRODUC2','DEMOPRODUC2',NULL,0.00,NULL,'MUES','S/P',929292,'2021-12-22','2021-12-22','2022-03-31',NULL,NULL,'72727',NULL,NULL,1,NULL),('01','001','B001','SIIFADMIN','215457',NULL,NULL,NULL,'02',20,'SPIRULINA','SPIRULINA',NULL,600.00,5.00,'BIMO1','S/N',800,'2025-02-20','2025-02-20','2026-08-08',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','DEMO','DPROD11','SIIFADMIN','DMAY11','237','es',NULL,'DLIN',1,'PROD11','DESC PROD11','PRINCIP11',48960.00,0.00,'PROD','UNICO',99621,'2018-03-14','2018-03-14',NULL,'-1',NULL,'S/L',NULL,NULL,1,5),('01','DEMO','DPROD12','SIIFADMIN','DMAY12','237','es',NULL,'DLIN',1,'PROD12','DESC PROD12','PRINCIP12',215300.00,0.00,'PROD','UNICO',99889,'2018-03-15','2018-03-15',NULL,'-1',NULL,'S/L',NULL,NULL,1,6),('01','DEMO','DPROD13','SIIFADMIN','DMAY13','237','es',NULL,'DLIN',1,'PROD13','DESC PROD13','PRINCIP13',34500.00,0.00,'PROD','UNICO',99919,'2018-03-16','2018-03-16',NULL,'-1',NULL,'S/L',NULL,NULL,1,1),('01','DEMO','DPROD14','SIIFADMIN','DMAY14','237','es',NULL,'DLIN',1,'PROD14','DESC PROD14','PRINCIP14',26700.00,0.00,'PROD','UNICO',99960,'2018-03-17','2018-03-17',NULL,'-1',NULL,'S/L',NULL,NULL,1,2),('01','DEMO','DPROD15','SIIFADMIN','DMAY15','237','es',NULL,'DLIN',1,'PROD15','DESC PROD15','PRINCIP15',95000.00,0.00,'PROD','UNICO',99869,'2018-03-18','2018-03-18',NULL,'-1',NULL,'S/L',NULL,NULL,1,3),('01','DEMO','DPROD16','SIIFADMIN','DMAY16','237','es',NULL,'DLIN',1,'PROD16','DESC PROD16','PRINCIP16',100000.00,0.00,'PROD','UNICO',99953,'2018-03-19','2018-03-19',NULL,'-1',NULL,'S/L',NULL,NULL,1,4),('01','DEMO','DPROD17','SIIFADMIN','DMAY17','237','es',NULL,'DLIN',1,'PROD17','DESC PROD17','PRINCIP17',47800.00,0.00,'PROD','UNICO',99969,'2018-03-20','2018-03-20',NULL,'-1',NULL,'S/L',NULL,NULL,1,5),('01','DEMO','DPROD87','SIIFADMIN','DMAY87','237','es',NULL,'DLIN',1,'PROD87\r\n','PROD87\r\n','PROD87\r\n',1.00,0.00,'MUES','UNICO',99390,'2018-03-01',NULL,NULL,NULL,0,'LOTE1','2025-06-18',NULL,1,0),('01','DEMO','DPROD88','SIIFADMIN','DMAY88','237','es',NULL,'DLIN',1,'PROD88\r\n','PROD88\r\n','PROD88\r\n',1.00,0.00,'MUES','UNICO',99933,'2018-03-01',NULL,NULL,NULL,NULL,'LOTE 2','2025-06-18',NULL,0,NULL),('01','DEMO','DPROD89','SIIFADMIN','DMAY89','237','es',NULL,'DLIN',1,'PROD89\r\n','PROD89\r\n','PROD89\r\n',25520.75,0.00,'MUES','UNICO',99758,'2018-03-01',NULL,NULL,NULL,NULL,'S/L','2025-06-18',NULL,0,NULL),('01','FCPHARMA','FC02311260','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Thimerosal','Thimerosal',' 60 ML',3040.00,0.00,'FARM','S/P',8490,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC025512120','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Jar Pasiflora','Jar Pasiflora','120 ml',16800.00,0.00,'FARM','S/P',5014,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC02561260','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Gota Valeriana','Gota Valeriana',' 60 ml',4160.00,0.00,'FARM','S/P',5117,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','001','FC20051008','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'acetaminofen 50000ml','200 MG 10xCAPSULAS BLANDAS ','NA',1.00,0.00,'FARM','31',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','001','FC20061008','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'acetaminofen 500ml','200 MG 10xCAPSULAS BLANDAS ','NA',1.00,0.00,'FARM','31',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2010210','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Sinutil D','Sinutil D','500 MG-10MG-2MG X 10 CAPS',24000.00,0.00,'FARM','S/P',7150,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2020210','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,' SINUTIL NOCHE X 10 CAPSULAS BLANDAS',' X 10 CAPSULAS BLANDAS',' X 10 CAPSULAS BLANDAS',1.00,0.00,'FARM','UNICA',1000,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','FC2030310','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Apyrene','Apyrene','650 MG X 10 CAPS',14384.00,0.00,'FARM','S/P',9242,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC203080','SIIFADMIN','DROGU2001',NULL,NULL,NULL,'OTR',10,'Darlide 1000','Darlide 1000',NULL,13000.00,0.00,'FARM','S/N',1000000,'2019-05-07','2019-05-01','2020-12-31',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','FCPHARMA','FC2040390','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Arnica Plus 90','Arnica Plus 90','90 GR',14800.00,0.00,'FARM','S/P',30437,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2050310','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Anapir 200','Anapir 200','200 MG 10xCAPSULAS BLANDAS ',11440.00,0.00,'FARM','S/P',5606,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2050320','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Anapir 400','Anapir 400','400 MG X10 CAPS',20800.00,0.00,'FARM','S/P',6882,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC20606100','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Htbrush Goma','Htbrush Goma','MANGO DE GOMA',28763.00,0.00,'FARM','S/P',48323,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC20706100','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Htbrush Acero','Htbrush Acero',' ACERO INOXIDABLE',32480.00,0.00,'FARM','S/P',4734,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC20804200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Arnica Plus 250','Arnica Plus 250','PLUS (TARRO)',21600.00,0.00,'FARM','S/P',7624,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC21007150','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Amarenfem','Amarenfem',' 150 mg CÁPSULAS BLANDAS',51200.00,0.00,'FARM','S/P',8146,NULL,'2018-08-07','2018-08-07',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC21108200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Perlavis 200','Perlavis 200','200 ML.',26912.00,0.00,'FARM','S/P',12075,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC21208200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Perlavis Homme','Perlavis Homme','200 ML.',26912.00,0.00,'FARM','S/P',9084,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC21308200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Nacivit E','Nacivit E','GEL CORPORAL 200 GR.',19488.00,0.00,'FARM','S/P',7945,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC21408200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Nacivit C','Nacivit C','GEL CORPORAL 200 GR.',19488.00,0.00,'FARM','S/P',7169,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC21508360','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Perlavis 360','Perlavis 360',' 360 ML.',35264.00,0.00,'FARM','S/P',6318,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2160515','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Vit C X 15','Vit C X 15',' 500 mg. 15 CAPSULAS BLANDAS',13280.00,0.00,'FARM','S/P',8822,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2160530','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Vit C X 30','Vit C X 30','X 30 CAPS ',25440.00,0.00,'FARM','S/P',7987,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2180930','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Darmade','Darmade','1000 MUI 30 CAPSULAS BLANDAS',17600.00,0.00,'FARM','S/P',9014,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2190390','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Arnica FC 250','Arnica FC 250',' 90 GR.',21120.00,0.00,'FARM','S/P',6061,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2200390','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Arnica FC 90','Arnica FC 90','90 GR.',13120.00,0.00,'FARM','S/P',3708,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC22104250','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Arnica For 250','Arnica For 250','250 GR.',21120.00,0.00,'FARM','S/P',33481,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC22204200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Arnica For 90','Arnica For 90',' FORTE 250 GR.',14800.00,0.00,'FARM','S/P',6097,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC22308200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Perlavis Teen','Perlavis Teen','200 ML',27840.00,0.00,'FARM','S/P',24453,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2240830','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Mentorub 30','Mentorub 30','30 GRMS',18189.00,0.00,'FARM','S/P',8591,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2260860','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Mentorub 60','Mentorub 60','60 GRMS',33037.00,0.00,'FARM','S/P',9323,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC22708200','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Maxwet','Maxwet','250 GR.',18931.00,0.00,'FARM','S/P',8725,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC227082023','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Amarenfem 150 Mg. 1 Capsula Blanda','Acido Ibandronico','Acido Ibandronico',1.00,0.00,'FARM','UNICA',1000,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','FC22808120','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Htbrush Gel','Htbrush Gel','ESPUMANTE PARA PIOJOS',13363.00,0.00,'FARM','S/P',62399,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC22911120','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Jar Zabila Pedriatico','Jar Zabila Pedriatico','(ADULTO) 120 CM³',15840.00,0.00,'FARM','S/P',9344,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC23011120','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Jar Zabila Adult','Jar Zabila Adult','(PEDIATRICO) 120 CM³',16000.00,0.00,'FARM','S/P',9353,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC23112120','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Jar Valeriana','Jar Valeriana','120 CM³',16000.00,0.00,'FARM','S/P',7530,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2320360','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Gota Arnica','Gota Arnica','60 CM3',4000.00,0.00,'FARM','S/P',9359,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2330364','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Arnica Spray','Arnica Spray','AEROSOL 64 GR',17818.00,0.00,'FARM','S/P',4352,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2420205','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Sinutil N','Sinutil N','500MG-2MG  X 5 CAPS',12800.00,0.00,'FARM','S/P',7205,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC24311120','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Jar Jengibre','Jar Jengibre','X 120ML',14240.00,0.00,'FARM','S/P',189720,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2451530','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Solucion 30','Solucion 30','30 ML',5600.00,0.00,'FARM','S/P',7990,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2451560','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Solucion 60','Solucion 60','60 ML',10880.00,0.00,'FARM','S/P',8242,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2461625','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'BICARBONATO DE SODIO X 25GR','25GR','25GR',1.00,0.00,'FARM','UNICA',1000,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,0,NULL),('01','FCPHARMA','FC25712120','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Agua de Rosas','Agua de Rosas',' 120 ml',12064.00,0.00,'FARM','S/P',9820,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2610024','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Dra Crema FC','Dra Crema FC','Oxido de Zinc',27840.00,0.00,'FARM','S/P',5876,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FC2610025','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Barrocutina','Barrocutina','Acido Salicilico',12960.00,0.00,'FARM','S/P',9798,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','FCPHARMA','FCN1','SIIFADMIN','DROGU2003',NULL,NULL,NULL,'OTR',10,'Bicarbonato 25','Bicarbonato 25',NULL,10720.00,0.00,'FARM','S/P',100000000,'2018-10-10','2018-10-10','2020-01-31',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','FCPHARMA','FCTBD','SIIFADMIN','MAY00001',NULL,NULL,NULL,'OTR',2,'Sinutil D/N','Sinutil D/N',' 500mg x 9 CAPS',23840.00,0.00,'FARM','S/P',9688,NULL,'2018-08-08','2018-08-08',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC102011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CIPROFLOXACINA 500 mg x 6  Tabletas','CIPROFLOXACINA 500 mg x 6  Tabletas','LAMOTRIGINA',105.37,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC110011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CLOTRIMAZOL CREMA 1% x 20 g','CLOTRIMAZOL CREMA 1% x 20 g','LAMOTRIGINA',121.99,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC110021','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CLOTRIMAZOL CREMA 1%x 50 g','CLOTRIMAZOL CREMA 1%x 50 g','LAMOTRIGINA',184.16,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC11021','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'ATENOLOL 50 mg x 30 Tabletas','ATENOLOL 50 mg x 30 Tabletas','LAMOTRIGINA',141.09,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13021','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'AMLODIPINA 5 mg x 30 Tabletas','AMLODIPINA 5 mg x 30 Tabletas','LAMOTRIGINA',87.08,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13501402','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'AMLODIPINA 10 mg x 20 Tabletas','AMLODIPINA 10 mg x 20 Tabletas','LAMOTRIGINA',62.95,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13536604','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LOSARTAN POTASICO 50 mg x 20 Tabletas','LOSARTAN POTASICO 50 mg x 20 Tabletas','LAMOTRIGINA',75.10,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557604','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'FEBRILIX GRIP 500mg-2mg x10 TABLETAS RECUBIERTAS','FEBRILIX GRIP 500mg-2mg x10 TABLETAS RECUBIERTAS','LAMOTRIGINA',67.13,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC135576101','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LORATADINA AMBROXOL TABL ','LORATADINA AMBROXOL TABL ','LAMOTRIGINA',100.14,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC135576102','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'AMOX.ACCLAV.500mg125mgX 10 TAB. REC.','AMOX.ACCLAV.500mg125mgX 10 TAB. REC.','LAMOTRIGINA',479.47,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557614','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CAPTOPRIL 25mg ESTUCHE x 20 Tabletas','CAPTOPRIL 25mg ESTUCHE x 20 Tabletas','LAMOTRIGINA',76.83,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557637','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LOSARTAN POTASICO 100 mg x 10 Tabletas','LOSARTAN POTASICO 100 mg x 10 Tabletas','LAMOTRIGINA',90.84,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557639','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LOSARTAN POTASICO 100 mg x 30 Tabletas','LOSARTAN POTASICO 100 mg x 30 Tabletas','LAMOTRIGINA',217.52,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557655','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'DESLORATADINA 5 mg x 10 Tabletas','DESLORATADINA 5 mg x 10 Tabletas','LAMOTRIGINA',73.93,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557659','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'SILDENAFIL 50 mgX 2TABLETAS RECUBIERTAS','SILDENAFIL 50 mgX 2TABLETAS RECUBIERTAS','LAMOTRIGINA',44.10,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557661','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CARVEDILOL 6,25 mg x 20 Tabletas','CARVEDILOL 6,25 mg x 20 Tabletas','LAMOTRIGINA',114.28,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557662','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CARVEDILOL 12,5 mg x 20 Tabletas','CARVEDILOL 12,5 mg x 20 Tabletas','LAMOTRIGINA',150.33,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557665','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CARVEDILOL 25 mg x 20 Tabletas','CARVEDILOL 25 mg x 20 Tabletas','LAMOTRIGINA',266.70,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557690','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'TAMSULOSINA CLORH 0,4mgX 20 TABLETAS','TAMSULOSINA CLORH 0,4mgX 20 TABLETAS','LAMOTRIGINA',146.02,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557709','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'TAMSULOSINA DUTASTERIDE0,4 mg / 0,5 mg CAPS X 30','TAMSULOSINA DUTASTERIDE0,4 mg / 0,5 mg CAPS X 30','LAMOTRIGINA',466.70,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13557802','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'AMOX.AC.CLAV.PPSU400mg57mg/5mLPPSUSP.','AMOX.AC.CLAV.PPSU400mg57mg/5mLPPSUSP.','LAMOTRIGINA',372.44,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13657901','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'DESLORATADINA JBE 2,5mg/5ml x 60 ml','DESLORATADINA JBE 2,5mg/5ml x 60 ml','LAMOTRIGINA',102.30,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13658109','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'TRIMETOPR SULFAMETOX SUSP40-200 mg/5 mL SUSP 60 mL','TRIMETOPR SULFAMETOX SUSP40-200 mg/5 mL SUSP 60 mL','LAMOTRIGINA',125.72,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13658305','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LORATADINA-AMBROXOL CLOH5mg-30mg/5mL SOL  ORAL','LORATADINA-AMBROXOL CLOH5mg-30mg/5mL SOL  ORAL','LAMOTRIGINA',77.09,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13658306','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'MUCOMAX PLUS 5mg-30mg/5mLSOLUCION ORAL 60 ml','MUCOMAX PLUS 5mg-30mg/5mLSOLUCION ORAL 60 ml','LAMOTRIGINA',94.47,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13658307','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'MUCOMAX 15mg/5mL SOL ORALUSO PEDIATRICO 120 ml','MUCOMAX 15mg/5mL SOL ORALUSO PEDIATRICO 120 ml','LAMOTRIGINA',79.90,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13658309','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'MUCOMAX 30mg/5mL SOLUCION','MUCOMAX 30mg/5mL SOLUCION','LAMOTRIGINA',87.42,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13758402','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'KETOCONAZOL CREMA 2% x 15 g','KETOCONAZOL CREMA 2% x 15 g','LAMOTRIGINA',140.01,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13758410','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CLOCIM 1% CREMA TOPICA x20 g','CLOCIM 1% CREMA TOPICA x20 g','LAMOTRIGINA',82.33,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13758411','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'KETOMIZOL 2% CREMA x 15 g ','KETOMIZOL 2% CREMA x 15 g ','LAMOTRIGINA',145.21,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13758412','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'TERBINAFINA CLORH 1% CREMA','TERBINAFINA CLORH 1% CREMA','LAMOTRIGINA',195.08,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13758414','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CLOTRIMAZOLNEOMICINADEXAMETASONA1%,0,50%,0,04%CREM','CLOTRIMAZOLNEOMICINADEXAMETASONA1%,0,50%,0,04%CREM','LAMOTRIGINA',211.62,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13758415','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CLOTRIMAZOL CREMA VAG 10%POR 5 g CON 1 CANULA','CLOTRIMAZOL CREMA VAG 10%POR 5 g CON 1 CANULA','LAMOTRIGINA',182.11,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC13758418','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'BETAMETASONAGENTAMICINACLIOQUINOL 0,05%,0,10%,1%CR','BETAMETASONAGENTAMICINACLIOQUINOL 0,05%,0,10%,1%CR','LAMOTRIGINA',224.30,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC165021','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'DICLOFENACO POTASICO 50 mg x 20 Tabletas','DICLOFENACO POTASICO 50 mg x 20 Tabletas','LAMOTRIGINA',56.83,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC192021','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'ENALAPRIL 20 mg x 30 Tabletas','ENALAPRIL 20 mg x 30 Tabletas','LAMOTRIGINA',82.58,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC197011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'FAMOTIDINA 40mg x 10Tabletas','FAMOTIDINA 40mg x 10Tabletas','LAMOTRIGINA',64.71,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC198011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'FEBRILIX 500mg x 20Tabletas','FEBRILIX 500mg x 20Tabletas','LAMOTRIGINA',54.03,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC200021','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'FLUCONAZOL 150 mg x 2 CAPCAPSULAS','FLUCONAZOL 150 mg x 2 CAPCAPSULAS','LAMOTRIGINA',90.01,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC203011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'FEBRILIX 120mg/5ml SOLUCION ORAL','FEBRILIX 120mg/5ml SOLUCION ORAL','LAMOTRIGINA',81.00,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC21011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'BACITRACINA UNGÜENTO x 15g','BACITRACINA UNGÜENTO x 15g','LAMOTRIGINA',151.96,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC220011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'IBUPROFEN 400 mg x 10Tabletas','IBUPROFEN 400 mg x 10Tabletas','LAMOTRIGINA',67.55,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC221011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'IBUPROFENO SUSPENSION100 mg/5mL x 60 mL','IBUPROFENO SUSPENSION100 mg/5mL x 60 mL','LAMOTRIGINA',77.56,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC30011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'BALSADER POMADA x 30 g ','BALSADER POMADA x 30 g ','LAMOTRIGINA',102.72,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC361011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LORATADINA 10 mg x 10 Tabletas','LORATADINA 10 mg x 10 Tabletas','LAMOTRIGINA',43.94,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC362011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LORATADINA JARABE 1mg/ml x 60 ml','LORATADINA JARABE 1mg/ml x 60 ml','LAMOTRIGINA',64.64,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC367011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'LOSARTAN+HCT 50mg/12,5 mg x 10 Tabletas','LOSARTAN+HCT 50mg/12,5 mg x 10 Tabletas','LAMOTRIGINA',58.97,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC375011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'MELOXICAM 15 mg x 10 Tabletas','MELOXICAM 15 mg x 10 Tabletas','LAMOTRIGINA',128.51,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC382011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'METRONIDAZOL BENZOIL 125mg/5ml x 120ml','METRONIDAZOL BENZOIL 125mg/5ml x 120ml','LAMOTRIGINA',174.82,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC383011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'METRONIDAZOL BENZOIL SUSP. 250mg/5ml x 120 ml','METRONIDAZOL BENZOIL SUSP. 250mg/5ml x 120 ml','LAMOTRIGINA',233.07,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC471011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'SECNIDAZOL 500 mg x 4 Tabletas','SECNIDAZOL 500 mg x 4 Tabletas','LAMOTRIGINA',91.49,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC480011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'SULFADIAZINA DE PLATA CREMA 1% x 30 g','SULFADIAZINA DE PLATA CREMA 1% x 30 g','LAMOTRIGINA',191.97,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC5011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CLORHIDRATO DE AMBROXOL PEDIATRICO 15mg/5ml x 120','CLORHIDRATO DE AMBROXOL PEDIATRICO 15mg/5ml x 120','LAMOTRIGINA',96.01,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KC','KC83011','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'CETIRIZINA JARABE 1mg/ml x 60 ml','CETIRIZINA JARABE 1mg/ml x 60 ml','LAMOTRIGINA',80.95,0.00,'PROD','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KIMICEG','KCMUE01','SIIFADMIN','DROKIMI2',NULL,NULL,NULL,'KILIN',14,'MUESTRAS FARMACO 01','MUESTRAS FARMACO 01',NULL,0.00,NULL,'MUES','S/P',88,'2025-02-23','2025-02-24','2025-07-31',NULL,NULL,'KMLOTE01',NULL,NULL,1,NULL),('01','KIMICEG','KCMUE02','SIIFADMIN','DROKIMI2',NULL,NULL,NULL,'KILIN',14,'MUESTRA FARMACO 02','MUESTRA FARMACO 02',NULL,0.00,NULL,'MUES','S/P',994,'2025-02-25','2025-02-25','2025-11-30',NULL,NULL,'KMLOTE2',NULL,NULL,1,NULL),('01','KIMICEG','KCMUE03','SIIFADMIN','DROKIMI3',NULL,NULL,NULL,'KILIN',14,'MUESTRA FARMACO 03','MUESTRA FARMACO 03',NULL,0.00,NULL,'MUES','S/P',993,'2025-02-25','2025-02-26','2026-10-30',NULL,NULL,'KMLOTE3',NULL,NULL,1,NULL),('01','KC','KCMUES01','SIIFADMIN','LANENA',NULL,NULL,NULL,'KILIN',7,'MUESTRA NUEVA','MUESTRA ','LAMOTRIGINA',0.00,0.00,'MUES','CAJA',NULL,NULL,NULL,NULL,NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO1','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'CLOTRIMAZOL 20ML','CLOTRIMAZOL 20ML',NULL,9800.00,0.00,'PROD','S/N',999913,'2019-07-10','2019-07-10','2019-07-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO10','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'MUCOMAX 30MG PLUS SOL.','MUCOMAX 30MG PLUS SOL.',NULL,12600.00,0.00,'PROD','S/N',999941,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO11','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'MUCOMAX 15MG PEDRIATICO','MUCOMAX 15MG PEDRIATICO',NULL,17200.00,0.00,'PROD','S/N',99930,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO12','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'KETOCONAZOL 15G','KETOCONAZOL 15G',NULL,10700.00,0.00,'PROD','S/N',99940,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO13','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'DICLOFENACO 50MG','DICLOFENACO 50MG',NULL,10700.00,0.00,'PROD','S/N',999959,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO14','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'BALSADER 30G','BALSADER 30G',NULL,6700.00,0.00,'PROD','S/P',9974,'2019-07-10','2019-07-10','2025-03-06',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO2','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'CLOTRIMAZOL 25ML','CLOTRIMAZOL 25ML',NULL,11050.00,0.00,'PROD','S/N',999997,'2019-07-10','2019-07-01','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO3','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'AMLODIPINA 10MG','AMLODIPINA 10MG',NULL,19200.00,0.00,'PROD','S/N',999997,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO33','SIIFADMIN','DROKIMI3',NULL,NULL,NULL,'KILIN',14,'MAGNESIO 500MG','MAGNESIO 500MG',NULL,35.00,2.00,'PROD','S/P',1336,'2025-03-06','2025-01-06','2025-12-09',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO4','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'DESLORATADINA 5MG','DESLORATADINA 5MG',NULL,14500.00,0.00,'PROD','S/N',99999,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO5','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'SILDENAFIL 50MG','SILDENAFIL 50MG',NULL,4200.00,0.00,'PROD','S/N',100000,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO6','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'CARVEDILOL 6,25MG','CARVEDILOL 6,25MG',NULL,17400.00,0.00,'PROD','S/N',1000000,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO7','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'CARVEDILOL 25MG','CARVEDILOL 25MG',NULL,32000.00,0.00,'PROD','S/N',100000,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO8','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'CLOPIDOGREL 75MG','CLOPIDOGREL 75MG',NULL,42000.00,0.00,'PROD','S/N',99998,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','KIMICEG','KIMIPRO9','SIIFADMIN','MNENA',NULL,NULL,NULL,'KILIN',14,'MUCOMAX 30MG SOL.','MUCOMAX 30MG SOL.',NULL,17600.00,0.00,'PROD','S/N',99985,'2019-07-10','2019-07-10','2019-07-10',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MaxPro','MAXM1','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Muestra','Muestra',NULL,NULL,NULL,'MUES','S/N',99937,'2019-08-25','2019-08-01','2019-08-26',NULL,NULL,'100',NULL,NULL,0,NULL),('01','MaxPro','MAXMF1','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Mentorub 60','Mentorub 60',NULL,NULL,NULL,'MUES','S/N',100000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF10','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Arnica plus Tar','Arnica plus Tar',NULL,NULL,NULL,'MUES','S/N',100000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF11','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Arnica Term Rol','Arnica Term Rol',NULL,NULL,NULL,'MUES','S/N',1000000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF12','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Arnica Term Tar ','Arnica Term Tar ',NULL,NULL,NULL,'MUES','S/N',100000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF13','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Barrocutina','Barrocutina',NULL,NULL,NULL,'MUES','S/N',100000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF2','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Mentorub 30','Mentorub 30',NULL,NULL,NULL,'MUES','S/N',1000000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF3','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Anapir 200','Anapir 200',NULL,NULL,NULL,'MUES','S/N',1000000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF4','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Anapir 400','Anapir 400',NULL,NULL,NULL,'MUES','S/N',100000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF5','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Anapyrene 600','Anapyrene 600',NULL,NULL,NULL,'MUES','S/N',1000000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF6','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Arnica FC Atom','Arnica FC Atom',NULL,NULL,NULL,'MUES','S/N',100000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF7','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Arnica FC Rol','Arnica FC Rol',NULL,NULL,NULL,'MUES','S/N',100000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF8','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Arnica FC Tar','Arnica FC Tar',NULL,NULL,NULL,'MUES','S/N',1000000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMF9','SIIFADMIN','MAXD1',NULL,NULL,NULL,'12',15,'Arnica plus Rol','Arnica plus Rol',NULL,NULL,NULL,'MUES','S/N',1000000,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'2',NULL,NULL,1,NULL),('01','MaxPro','MAXMV1','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Dayflu D x10','Dayflu D x10',NULL,NULL,NULL,'MUES','S/N',99998,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV10','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Ilana Óvulos','Ilana Óvulos',NULL,NULL,NULL,'MUES','S/N',99988,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV2','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Dayflu N x10','Dayflu N x10',NULL,NULL,NULL,'MUES','S/N',99994,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV3','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Dayflu D/N x15','Dayflu D/N x15',NULL,NULL,NULL,'MUES','S/N',9999991,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV4','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Alivax F 650x10','Alivax F 650x10',NULL,NULL,NULL,'MUES','S/N',99999,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV5','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Cevax X30','Cevax X30',NULL,NULL,NULL,'MUES','S/N',999952,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV6','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Neuribe','Neuribe',NULL,NULL,NULL,'MUES','S/N',99999,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV7','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Vitamina E  X30','Vitamina E  X30',NULL,NULL,NULL,'MUES','S/N',99962,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV8','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Evigax 125 X10','Evigax 125 X10',NULL,NULL,NULL,'MUES','S/N',99999,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MaxPro','MAXMV9','SIIFADMIN','MAXD1',NULL,NULL,NULL,'11',15,'Evigax 125 X20','Evigax 125 X20',NULL,NULL,NULL,'MUES','S/N',99999,'2019-09-01','2019-09-01','2019-09-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MAXFC','MMFC1','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Mentorub 60','Mentorub 60',NULL,NULL,NULL,'MUES','S/N',999999776,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC10','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Forte T','Arnica Forte T',NULL,NULL,NULL,'MUES','S/N',999999947,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC11','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Term Rol','Arnica Term Rol',NULL,NULL,NULL,'MUES','S/N',999999941,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC12','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Term Tar','Arnica Term Tar',NULL,NULL,NULL,'MUES','S/N',99999978,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC13','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Barrocutina','Barrocutina',NULL,NULL,NULL,'MUES','S/N',99999914,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC2','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Mentorub 30','Mentorub 30',NULL,NULL,NULL,'MUES','S/N',9999916,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC20','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Material POP','Material POP',NULL,NULL,NULL,'MUES','S/N',999999948,'2019-09-25','2019-09-25','2019-09-26',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC21','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'CHARLA','CHARLA',NULL,NULL,NULL,'MUES','S/N',1000000,'2019-11-25','2019-11-25','2019-11-25',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC3','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Anapir 200','Anapir 200',NULL,NULL,NULL,'MUES','S/N',99999221,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC4','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Anapir 400','Anapir 400',NULL,NULL,NULL,'MUES','S/N',99999669,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC5','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Apyrene 600','Apyrene 600',NULL,NULL,NULL,'MUES','S/N',99999171,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC6','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica FC Atom','Arnica FC Atom',NULL,NULL,NULL,'MUES','S/N',999895,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC7','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica FC Rol','Arnica FC Rol',NULL,NULL,NULL,'MUES','S/N',9999966,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC8','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica FC Tar','Arnica FC Tar',NULL,NULL,NULL,'MUES','S/N',999999902,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MMFC9','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Forte R','Arnica Forte R',NULL,NULL,NULL,'MUES','S/N',9999900,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'FC',NULL,NULL,1,NULL),('01','MAXFC','MPFC1','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Mentorub 60','Mentorub 60',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC10','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Forte T','Arnica Forte T',NULL,1.00,0.00,'PROD','S/N',100000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC11','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Term Rol','Arnica Term Rol',NULL,1.00,0.00,'PROD','S/N',100000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC12','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Term Tar ','Arnica Term Tar ',NULL,1.00,0.00,'PROD','S/N',100000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC13','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Barrocutina','Barrocutina',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC2','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Mentorub 30','Mentorub 30',NULL,1.00,0.00,'PROD','S/N',100000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC3','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Anapir 200','Anapir 200',NULL,1.00,0.00,'PROD','S/N',1000000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC4','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Anapir 400','Anapir 400',NULL,1.00,0.00,'PROD','S/N',1000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC5','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Apyrene 600','Apyrene 600',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC6','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica FC Atom','Arnica FC Atom',NULL,1.00,0.00,'PROD','S/N',1000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC7','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica FC Rol','Arnica FC Rol',NULL,1.00,0.00,'PROD','S/N',1000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC8','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica FC Tar','Arnica FC Tar',NULL,1.00,0.00,'PROD','S/N',1000000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXFC','MPFC9','SIIFADMIN','MFCD1',NULL,NULL,NULL,'LFC1',16,'Arnica Forte R','Arnica Forte R',NULL,1.00,0.00,'PROD','S/N',100000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','FCPH','MUES1','SIIFADMIN','COBECA',NULL,NULL,NULL,'332',19,'Muestra 1','Muestra 1',NULL,NULL,NULL,'MUES','S/N',100000,'2022-01-06','2022-01-05','2022-01-25',NULL,NULL,'1',NULL,NULL,1,NULL),('01','POLINAC','MUESTPOLI1','SIIFADMIN','POLIDRO1',NULL,NULL,NULL,'101',13,'LAPIZ POLINAC','LAPIZ POLINAC',NULL,NULL,NULL,'MUES','S/N',133333,'2019-07-11','2019-07-11','2019-07-11',NULL,NULL,'122222',NULL,NULL,1,NULL),('01','FCPH','muestra1','SIIFADMIN','DRONENA',NULL,NULL,NULL,'332',19,'Muestra1','Muestra1',NULL,NULL,NULL,'MUES','S/N',99999997,'2021-12-29','2021-12-29','2021-12-30',NULL,NULL,'1',NULL,NULL,1,NULL),('01','FCPHARMA','MUESTRAFC1','SIIFADMIN','DROGU2002',NULL,NULL,NULL,'OTR',10,'Porta Cosmetico','Porta Cosmetico',NULL,0.00,0.00,'MUES','S/P',9999924,'2018-08-06','2018-08-06','2019-07-01',NULL,NULL,'1',NULL,NULL,1,NULL),('01','FCPHARMA','MUESTRAFC2','SIIFADMIN','DROGU2002',NULL,NULL,NULL,'OTR',10,'Tasas Cafe','Tasas Cafe',NULL,0.00,0.00,'MUES','S/P',999965,'2018-08-06','2018-08-06','2020-05-01',NULL,NULL,'1',NULL,NULL,1,NULL),('01','FCPHARMA','MUESTRAFC3','SIIFADMIN','DROGU2002',NULL,NULL,NULL,'OTR',10,'Cal. Porta Lapiz','Cal. Porta Lapiz',NULL,0.00,0.00,'MUES','S/P',999909,'2018-08-06','2018-08-01','2021-05-01',NULL,NULL,'1',NULL,NULL,1,NULL),('01','FCPHARMA','MUESTRAFC4','SIIFADMIN','DROGU2002',NULL,NULL,NULL,'OTR',10,'Cale. Libro','Cale. Libro',NULL,0.00,0.00,'MUES','S/P',999916,'2018-08-06','2018-08-06','2021-09-03',NULL,NULL,'1',NULL,NULL,1,NULL),('01','FCPHARMA','MUESTRAFC5','SIIFADMIN','DROGU2002',NULL,NULL,NULL,'OTR',10,'Tapasol Morado','Tapasol Morado',NULL,0.00,0.00,'MUES','S/P',9999975,'2018-08-06','2018-08-06','2021-09-01',NULL,NULL,'1',NULL,NULL,1,NULL),('01','FCPHARMA','MUESTRAFC6','SIIFADMIN','DROGU2002',NULL,NULL,NULL,'OTR',10,'Bandada','Bandada',NULL,0.00,0.00,'MUES','S/P',9999962,'2018-08-06','2018-08-06','2021-09-01',NULL,NULL,'1',NULL,NULL,1,NULL),('01','FCPHARMA','MUESTRAFC7','SIIFADMIN','DROGU2002',NULL,NULL,NULL,'OTR',10,'Otro Material','Otro Material',NULL,0.00,0.00,'MUES','S/P',999961,'2018-08-06','2018-08-06','2021-09-01',NULL,NULL,'1',NULL,NULL,0,NULL),('01','FCPHARMA','MUESTRAFC8','SIIFADMIN','DROGU2001',NULL,NULL,NULL,'OTR',10,'Por. Toalla Sanitaria','Por. Toalla Sanitaria',NULL,0.00,0.00,'MUES','S/P',999945,'2018-08-06','2018-08-06','2021-09-01',NULL,NULL,'1',NULL,NULL,1,NULL),('01','MAXVI','MVM1','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Dayflu D x10','Dayflu D x10',NULL,NULL,NULL,'MUES','S/N',99999749,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM10','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ilana Óvulos','Ilana Óvulos',NULL,NULL,NULL,'MUES','S/N',99999788,'2019-09-16','2019-09-18','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM11','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'CHARLA','CHARLA',NULL,NULL,NULL,'MUES','S/N',999031,'2019-11-23','2019-11-23','2019-11-23',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM12','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ibuvax Fem','Ibuvax Fem',NULL,NULL,NULL,'MUES','S/N',999994,'2020-02-19','2020-02-03','2020-02-20',NULL,NULL,'Vivax',NULL,NULL,1,NULL),('01','MAXVI','MVM13','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Cevax x15','Cevax x15',NULL,NULL,NULL,'MUES','S/N',99965,'2020-02-19','2020-02-04','2020-02-27',NULL,NULL,'Vivax',NULL,NULL,1,NULL),('01','MAXVI','MVM14','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Vitamina E x15','Vitamina E x15',NULL,NULL,NULL,'MUES','S/N',99982,'2020-02-19','2020-02-04','2020-02-26',NULL,NULL,'Vivax',NULL,NULL,1,NULL),('01','MAXVI','MVM15','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ambroxol x15','Ambroxol x15',NULL,NULL,NULL,'MUES','S/N',99997,'2020-02-20','2020-02-04','2020-02-28',NULL,NULL,'Vivax',NULL,NULL,1,NULL),('01','MAXVI','MVM16','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ambroxol x30','Ambroxol x30',NULL,NULL,NULL,'MUES','S/N',99999,'2020-02-20','2020-02-05','2020-02-27',NULL,NULL,'Vivax',NULL,NULL,1,NULL),('01','MAXVI','MVM2','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Dayflu N x10','Dayflu N x10',NULL,NULL,NULL,'MUES','S/N',9999790,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM3','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Dayflu D/N x15','Dayflu D/N x15',NULL,NULL,NULL,'MUES','S/N',99999735,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM4','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Alivax F 650x10','Alivax F 650x10',NULL,NULL,NULL,'MUES','S/N',9999440,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM5','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Cevax X30','Cevax X30',NULL,NULL,NULL,'MUES','S/N',9999684,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM6','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Neuribe','Neuribe',NULL,NULL,NULL,'MUES','S/N',9999938,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM7','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Vitamina E  X30','Vitamina E  X30',NULL,NULL,NULL,'MUES','S/N',99999761,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM8','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Evigax 125 X10','Evigax 125 X10',NULL,NULL,NULL,'MUES','S/N',99999893,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVM9','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Evigax 125 X20','Evigax 125 X20',NULL,NULL,NULL,'MUES','S/N',9999800,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,'VIVAX',NULL,NULL,1,NULL),('01','MAXVI','MVP1','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Dayflu D x10','Dayflu D x10',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP10','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ilana Óvulos','Ilana Óvulos',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-17','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP11','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ezolium x20','Ezolium x20',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-08','2020-01-08','2020-01-28',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP12','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Cetirivax x10','Cetirivax x10',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-08','2020-01-08','2020-01-21',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP13','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ibuvax Cap x30','Ibuvax Cap x30',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-08','2020-01-08','2020-01-28',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP14','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Metrovax 15','Metrovax 15',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-11','2020-01-07','2020-01-21',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP15','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'NYTAXIN 500','NYTAXIN 500',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-23','2020-01-22','2020-01-23',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP16','SIIFADMIN','MVD2',NULL,NULL,NULL,'MLINE',17,'Alzit 10 mg','Alzit 10 mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP17','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Atovarol 10mg','Atovarol 10mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP18','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Atovarol 20mg','Atovarol 20mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP19','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Atovarol 40mg','Atovarol 40mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP2','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Dayflu N x10','Dayflu N x10',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP20','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Biprin 300mg','Biprin 300mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP21','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Carvix cap30','Carvix cap30',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP22','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Clenox 20mg','Clenox 20mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP23','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Clenox 40mg','Clenox 40mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP24','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Cuticlin 10mg','Cuticlin 10mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP25','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Clenox 60mg','Clenox 60mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP26','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Cuticlin 20mg','Cuticlin 20mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP27','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ketian 25g','Ketian 25g',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP28','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Levotiroxina Tab 30','Levotiroxina Tab 30',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP29','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Melovax 15mg','Melovax 15mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP3','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Dayflu D/N x15','Dayflu D/N x15',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP30','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Menistin 16mg','Menistin 16mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP31','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Moxen 400mg','Moxen 400mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP32','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Acetazolamida 250mg','Acetazolamida 250mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP33','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ambroxol 15g','Ambroxol 15g',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP34','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ambroxol 30mg','Ambroxol 30mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP35','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Amoxicilina 500mg','Amoxicilina 500mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP36','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ampicilina','Ampicilina',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP37','SIIFADMIN','MVD2',NULL,NULL,NULL,'MLINE',17,'Cetirizina 10mg','Cetirizina 10mg',NULL,1.00,0.00,'PROD','S/N',100000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP38','SIIFADMIN','MVD2',NULL,NULL,NULL,'MLINE',17,'Claritromicina 500mg','Claritromicina 500mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP39','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Complejo B 30Cap','Complejo B 30Cap',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP4','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Alivax F 650x10','Alivax F 650x10',NULL,1.00,0.00,'PROD','S/N',1000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP40','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Esomeprazol 40mg','Esomeprazol 40mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP41','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Gentamicina 80mg','Gentamicina 80mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP42','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Montelukast 5mg','Montelukast 5mg',NULL,1.00,0.00,'PROD','S/N',120000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP43','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Pantoprazol 20mg','Pantoprazol 20mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP44','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Pantoprazol 40mg','Pantoprazol 40mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP45','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Rispen 1mg x 14','Rispen 1mg x 14',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP46','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Rispen 1mg x 7','Rispen 1mg x 7',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP47','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Rispen 2mg x 14','Rispen 2mg x 14',NULL,1.00,0.00,'PROD','S/N',100000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP48','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Secnidazol 1g x 2Tab','Secnidazol 1g x 2Tab',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP49','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Sertralina 50mg','Sertralina 50mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP5','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Cevax X30','Cevax X30',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP50','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Tearsoft','Tearsoft',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP51','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Valsartan 80mg','Valsartan 80mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP52','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Varteral 80 5 mg','Varteral 80 5 mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP53','SIIFADMIN','MVD2',NULL,NULL,NULL,'MLINE',17,'Varteral 160 10mg','Varteral 160 10mg',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP54','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Varteral 160 5 mg','Varteral 160 5 mg',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP55','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Vitamina A 25','Vitamina A 25',NULL,1.00,0.00,'PROD','S/N',100000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP56','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Vitamina A 50','Vitamina A 50',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP57','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Albisec Cap12','Albisec Cap12',NULL,1.00,0.00,'PROD','S/N',10000000,'2020-01-24','2020-01-23','2020-01-24',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP58','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ibuvax Fem','Ibuvax Fem',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-02-19','2020-02-04','2020-02-25',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP59','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Vitamina E x 15','Vitamina E x 15',NULL,1.00,0.00,'PROD','S/N',100000,'2020-02-19','2020-02-04','2020-02-26',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP6','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Neuribe','Neuribe',NULL,1.00,0.00,'PROD','S/N',1000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP60','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Cevax x15','Cevax x15',NULL,1.00,0.00,'PROD','S/N',100000,'2020-02-19','2020-02-12','2020-02-26',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP61','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Ambroxol x15','Ambroxol x15',NULL,1.00,0.00,'PROD','S/N',100000,'2020-02-20','2020-02-04','2020-02-28',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP7','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Vitamina E  X30','Vitamina E  X30',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP8','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Evigax 125 X10','Evigax 125 X10',NULL,1.00,0.00,'PROD','S/N',100000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','MAXVI','MVP9','SIIFADMIN','MVD1',NULL,NULL,NULL,'MLINE',17,'Evigax 125 X20','Evigax 125 X20',NULL,1.00,0.00,'PROD','S/N',10000000,'2019-09-16','2019-09-16','2019-09-17',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI0001','SIIFADMIN','DRO01',NULL,NULL,NULL,'101',13,'Diadex crema 50g.','Diadex crema 50g.','NA',121.00,0.00,'PROD','S/P',999976,NULL,'2018-10-02','2018-10-02',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','POLINAC','POLI0002','SIIFADMIN','DRO01',NULL,NULL,NULL,'101',13,'Diadex pHis 120 ml.','Diadex pHis 120 ml.','NA',96.00,0.00,'PROD','S/P',999976,NULL,'2018-10-02','2018-10-02',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','POLINAC','POLI0003','SIIFADMIN','DRO01',NULL,NULL,NULL,'101',13,'Madecassol polvo 5g.','Madecassol polvo 5g.','NA',275.00,0.00,'PROD','S/P',9998,NULL,'2018-10-02','2018-10-02',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','POLINAC','POLI0004','SIIFADMIN','DRO01',NULL,NULL,NULL,'101',13,'Madecassol tubo 10g.','Madecassol tubo 10g.','NA',80.00,0.00,'PROD','S/P',99998,NULL,'2018-10-02','2018-10-02',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','POLINAC','POLI0005','SIIFADMIN','DRO01',NULL,NULL,NULL,'101',13,'Lisomucin 4mg 120 ml.','Lisomucin 4mg 120 ml.','NA',112.00,0.00,'PROD','S/P',99994,NULL,'2018-10-02','2018-10-02',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','POLINAC','POLI0006','SIIFADMIN','DRO01',NULL,NULL,NULL,'101',13,'Lisomucin 8mg 120 ml','Lisomucin 8mg 120 ml','NA',117.00,0.00,'PROD','S/P',99994,NULL,'2018-10-02','2018-10-02',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','POLINAC','POLI0007','SIIFADMIN','DRO01',NULL,NULL,NULL,'101',13,'Polifix 22g.','Polifix 22g.','NA',29.00,0.00,'PROD','S/P',1000,NULL,'2018-10-02','2018-10-02',NULL,NULL,'S/L',NULL,NULL,1,NULL),('01','POLINAC','POLI0011','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'POLIFIX  56','POLIFIX  56',NULL,1.00,0.00,'PROD','S/P',10000,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI00202','SIIFADMIN','POLIDRO1',NULL,NULL,NULL,'101',13,'MADECASSOL 30 TAB','MADECASSOL 30 TAB',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-01-23','2020-01-15','2020-01-23',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI008','SIIFADMIN','DRO02',NULL,NULL,NULL,'101',13,'BENFLUX JARABE 120 ml','BENFLUX JARABE 120 ml',NULL,116.00,0.00,'PROD','S/P',10000,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI009','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'BENFLUX TAB Caja 20','BENFLUX TAB Caja 20',NULL,47.00,0.00,'PROD','S/P',100000,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI010','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'BROMEXINA 8mg/5ml Jarabe 120 ml','BROMEXINA 8mg/5ml Jarabe 120 ml',NULL,26.00,0.00,'PROD','S/P',99994,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI011','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'COMPLEJO B COMPOSITUM','COMPLEJO B COMPOSITUM',NULL,23.00,0.00,'PROD','S/P',999976,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI012','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'DIADEX PHIS Frasco 1000','DIADEX PHIS Frasco 1000',NULL,1.00,0.00,'PROD','S/P',1,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI013','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'MADECASSOL 10 mg Caja 50 Tab','MADECASSOL 10 mg Caja 50 Tab',NULL,1.00,0.00,'PROD','S/P',1,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI014','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'MADECASSOL Tubo 20 g','MADECASSOL Tubo 20 g',NULL,156.00,0.00,'PROD','S/P',999998,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI015','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'MADECASSOL POLVO 10g','MADECASSOL POLVO 10g',NULL,1.00,0.00,'PROD','S/P',1,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI016','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'MADECASSOL POLVO Caja 20','MADECASSOL POLVO Caja 20',NULL,1.00,0.00,'PROD','S/P',1,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI111','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'VITAMINA B12','VITAMINA B12',NULL,1.00,0.00,'PROD','S/P',100000,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI112','SIIFADMIN','DRO04',NULL,NULL,NULL,'101',13,'POLANTAC 30 Tab','POLANTAC 30 Tab',NULL,42.00,0.00,'PROD','S/P',999952,'2018-06-11','2018-06-11','2018-06-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','POLINAC','POLI2000','SIIFADMIN','POLIDRO1',NULL,NULL,NULL,'101',13,'ACICLOVIR 200 MG','ACICLOVIR 200 MG',NULL,1.00,0.00,'PROD','S/N',1000000,'2020-02-02','2020-02-04','2020-02-11',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','FCPHARMA','PROD00003','SIIFADMIN','DROGU2001',NULL,NULL,NULL,'CAR',3,'lamotrigina','lamotrigina',NULL,100.00,0.00,'ALIM','S/N',100,'2025-02-06','2025-02-06','2025-02-28',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','FCPH','PROFC1','SIIFADMIN','COBECA',NULL,NULL,NULL,'332',19,'ARNICA ROL AZUL','ARNICA ROL AZUL',NULL,1.00,0.00,'PROD','S/N',10000000,'2022-01-06','2022-01-05','2022-01-12',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','TURBOF','TURBOM1','SIIFADMIN','DISTRI1',NULL,NULL,NULL,'85555',18,'MUESTRA1','MUESTRA1',NULL,NULL,NULL,'MUES','S/N',99999,'2020-04-29','2020-04-01','2020-04-29',NULL,NULL,'TF2',NULL,NULL,1,NULL),('01','TURBOF','TURBOP1','SIIFADMIN','DISTRI1',NULL,NULL,NULL,'85555',18,'TUNEL MODELO S','TUNEL MODELO S',NULL,1.00,0.00,'PROD','S/N',100000,'2020-04-28','2020-04-01','2020-04-20',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','TURBOF','TURBOP2','SIIFADMIN','DISTRI1',NULL,NULL,NULL,'85555',18,'TUNEL MODELO P','TUNEL MODELO P',NULL,1.00,0.00,'PROD','S/N',100000,'2020-04-28','2020-04-01','2020-04-28',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','TURBOF','TURBOP3','SIIFADMIN','DISTRI1',NULL,NULL,NULL,'85555',18,'C. MODELO LITE','C. MODELO LITE',NULL,1.00,0.00,'PROD','S/N',10000,'2020-04-28','2020-04-01','2020-04-28',NULL,NULL,NULL,NULL,NULL,1,NULL),('01','TURBOF','TURBOP4','SIIFADMIN','DISTRI1',NULL,NULL,NULL,'85555',18,'T. FRESH MOVIL','T. FRESH MOVIL',NULL,1.00,0.00,'PROD','S/N',100000,'2020-04-28','2020-04-01','2020-04-28',NULL,NULL,NULL,NULL,NULL,1,NULL);

--
-- Table structure for table `t_ranking_clientes`
--

CREATE TABLE `t_ranking_clientes` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Este es el codigo del ranking del cliente dentro del negocio, este es asignado por el Cliente, este puede ser 1. Excelente, 2. Muy Bueno, 3. Bueno, 4. Regular, 5. Malo, 0. sin ranking.',
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `descripcion_ranking_cliente` varchar(60) DEFAULT NULL COMMENT 'En este campo se describe el ranking del Cliente, Este ranking lo asigna el Laboratorio',
  `estatus` int DEFAULT '1' COMMENT 'Indica el estatus de ranking del cliente, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_ranking_clientes`
--

INSERT INTO `t_ranking_clientes` VALUES (1,'01','DEMO','Alto',1),(2,'01','DEMO','Medio',1),(3,'01','DEMO','Bajo',1),(4,'01','FCPHARMA','Alto',1),(5,'01','FCPHARMA','Medio',1),(6,'01','FCPHARMA','Bajo',1),(7,'01','BIOLIFE','ALTA',1),(8,'01','POLINAC','Alta',1),(9,'01','KIMICEG','Alto',1),(10,'01','VPOLINAC','Alto',1),(11,'01','MaxPro','Alto',1),(12,'01','MAXFC','Alto',1),(13,'01','MAXVI','Alto',1),(14,'01','TURBOF','Alto',1),(15,'01','30.450.345','Alto',1),(16,'01','1234','Alto',1),(17,'01','343.546.765','Alto',1),(18,'01','FCPH','Alto',1),(19,'01','22779444','Altos',1),(20,'01','21615025','Alto',1),(21,'01','32312123','Alto',1),(22,'01','001','Elevado',1),(23,'01','1','Alto',1),(24,'01','KC','Alto',1);

--
-- Table structure for table `t_redes_sociales`
--

CREATE TABLE `t_redes_sociales` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `cod_redes_sociales` varchar(3) NOT NULL COMMENT 'Este es el codigo de las redes sociales, este puede ser FAC-FACEBOOK, TWI-TWITTER, INS-INSTAGRAM, LIN-LINKEDIN  ',
  `descripcion_redes_sociales` varchar(60) DEFAULT NULL COMMENT 'En este campo se describe la red social',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus de redes sociales, este puede ser 1.Activo, 2. Inactivo',
  KEY `fk_redessociales_operador_idx` (`idOperador`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_redes_sociales`
--


--
-- Table structure for table `t_rol_perfil`
--

CREATE TABLE `t_rol_perfil` (
  `idperfil` int NOT NULL,
  `idrol` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_rol_perfil`
--

INSERT INTO `t_rol_perfil` VALUES (2,'0401'),(2,'040101'),(2,'04020101'),(2,'040201'),(2,'040202'),(2,'04020201'),(2,'040203'),(2,'040204'),(2,'040205'),(2,'040301'),(2,'040302'),(2,'040303'),(2,'040304'),(2,'0501'),(2,'0502'),(2,'0503'),(2,'0504'),(2,'0505'),(2,'06'),(2,'07'),(2,'08'),(2,'09'),(4,'040101'),(4,'040201'),(4,'040202'),(4,'04020201'),(4,'040203'),(4,'040204'),(4,'040205'),(4,'0501'),(4,'0505'),(4,'06'),(4,'07'),(4,'08'),(4,'09'),(6,'0101'),(6,'0201'),(6,'020101'),(6,'020102'),(6,'02010201'),(6,'0203'),(6,'0204'),(6,'0301'),(7,'0101'),(7,'0201'),(7,'020101'),(7,'020102'),(7,'02010201'),(7,'0202'),(7,'0203'),(7,'0204'),(7,'0301'),(7,'0302'),(2,'0102'),(6,'99910'),(6,'99911'),(6,'99912'),(6,'99913'),(6,'99914'),(6,'99916'),(6,'99917'),(6,'99918'),(6,'99919'),(6,'99920'),(6,'99921'),(6,'99923'),(6,'99933'),(7,'99910'),(7,'99911'),(7,'99912'),(7,'99913'),(7,'99914'),(7,'99916'),(7,'99917'),(7,'99918'),(7,'99919'),(7,'99920'),(7,'99921'),(7,'99923'),(7,'99933'),(6,'9991'),(6,'0302'),(6,'9995'),(6,'9999'),(7,'9991'),(7,'9995'),(7,'9996'),(6,'9997'),(2,'99934'),(2,'9998'),(7,'9997'),(7,'9999'),(6,'9996'),(6,'0102'),(6,'99931'),(4,'0102'),(2,'99931'),(4,'0101'),(2,'0101'),(4,'99919'),(2,'99919'),(2,'9990'),(2,'99920'),(2,'99921'),(2,'9999'),(2,'99910'),(2,'99911'),(4,'9990'),(4,'0204'),(4,'0302'),(4,'0401'),(4,'99920'),(4,'99921'),(4,'99931'),(4,'9998'),(4,'9999'),(4,'99910'),(4,'99911'),(4,'99923'),(2,'99923'),(3,'0101'),(3,'0102'),(3,'0204'),(3,'0302'),(3,'06'),(3,'07'),(3,'08'),(3,'09'),(3,'9999'),(3,'99910'),(3,'99911'),(3,'99919'),(3,'99920'),(3,'99921'),(3,'99923'),(3,'99931'),(2,'99930'),(4,'99930'),(2,'99929'),(4,'99929'),(4,'04020101'),(2,'99924'),(4,'99924'),(2,'99925'),(4,'99925'),(2,'99915'),(4,'99915'),(2,'99926'),(4,'99926'),(2,'99983'),(4,'99983'),(2,'99984'),(4,'99984'),(2,'99985'),(4,'99985'),(2,'99986'),(4,'99986'),(2,'99987'),(4,'99987'),(2,'99988'),(4,'99988'),(4,'99928'),(2,'99928'),(4,'99927'),(2,'99927'),(4,'0502'),(4,'0503'),(4,'0504'),(6,'9991'),(7,'9991'),(2,'050101'),(2,'050102'),(2,'050103'),(2,'050104'),(2,'050105'),(2,'050106'),(2,'050107'),(2,'050108'),(2,'050109'),(2,'05010101'),(2,'05010801'),(2,'05010901'),(4,'050101'),(4,'05010101'),(4,'050102'),(4,'050103'),(4,'050104'),(4,'050105'),(4,'050106'),(4,'050107'),(4,'050108'),(4,'05010801'),(4,'050109'),(4,'05010901'),(2,'040305'),(2,'040402'),(2,'040403'),(2,'040404'),(2,'040405'),(2,'040501'),(2,'040502'),(2,'040503'),(2,'040504'),(2,'040505'),(2,'040801'),(2,'040802'),(2,'040803'),(2,'040804'),(2,'040701'),(2,'040702'),(2,'040706'),(2,'040707'),(2,'040708'),(2,'040709'),(2,'040710'),(2,'040711'),(2,'99935'),(2,'99936'),(2,'99937'),(2,'99938'),(2,'99939'),(2,'99940'),(2,'99941'),(2,'99942'),(2,'99943'),(2,'99944'),(2,'99945'),(2,'99946'),(2,'99947'),(2,'99948'),(2,'99949'),(2,'99950'),(2,'99951'),(2,'99952'),(2,'99953'),(2,'99954'),(2,'99955'),(2,'99956'),(2,'99957'),(2,'99958'),(2,'99959'),(2,'99960'),(2,'99961'),(2,'99962'),(2,'99963'),(2,'99964'),(2,'99965'),(2,'99966'),(2,'99967'),(2,'99968'),(2,'99969'),(2,'99970'),(2,'99971'),(2,'99972'),(2,'99973'),(2,'99974'),(2,'99975'),(2,'99976'),(2,'99977'),(2,'99978'),(2,'99979'),(2,'99980'),(2,'99981'),(2,'99982'),(2,'99989'),(2,'99990'),(2,'99991'),(2,'99992'),(2,'99993'),(2,'99994'),(2,'99995'),(2,'99996'),(2,'99997'),(2,'99998'),(2,'99999'),(2,'999100'),(2,'999101'),(2,'999102'),(2,'999103'),(2,'999104'),(2,'999105'),(2,'999106'),(2,'999107'),(2,'999108'),(4,'99932'),(4,'99933'),(4,'99934'),(4,'99935'),(4,'99936'),(4,'99937'),(4,'99938'),(4,'99939'),(4,'99940'),(4,'99941'),(4,'99942'),(4,'99943'),(4,'99944'),(4,'99945'),(4,'99946'),(4,'99947'),(4,'99948'),(4,'99949'),(4,'99950'),(4,'99951'),(4,'99952'),(4,'99953'),(4,'99954'),(4,'99955'),(4,'99956'),(4,'99957'),(4,'99958'),(4,'99959'),(4,'99960'),(4,'99961'),(4,'99962'),(4,'99963'),(4,'99964'),(4,'99965'),(4,'99966'),(4,'99967'),(4,'99968'),(4,'99969'),(4,'99970'),(4,'99971'),(4,'99972'),(4,'99973'),(4,'99974'),(4,'99975'),(4,'99976'),(4,'99977'),(4,'99978'),(4,'99979'),(4,'99980'),(4,'99981'),(4,'99982'),(4,'99989'),(4,'99990'),(4,'99991'),(4,'99992'),(4,'99993'),(4,'99994'),(4,'99995'),(4,'99996'),(4,'99997'),(4,'99998'),(4,'99999'),(4,'999100'),(4,'999101'),(4,'999102'),(4,'999103'),(4,'999104'),(4,'999105'),(4,'999106'),(4,'999107'),(4,'999108'),(4,'040301'),(4,'040302'),(4,'040303'),(4,'040304'),(6,'9991'),(7,'9991'),(4,'040305'),(4,'040402'),(4,'040403'),(4,'040404'),(4,'040405'),(4,'040501'),(4,'040502'),(4,'040503'),(4,'040504'),(4,'040505'),(4,'040801'),(4,'040802'),(4,'040803'),(4,'040804'),(4,'040701'),(4,'040702'),(4,'040706'),(4,'040707'),(4,'040708'),(4,'040709'),(4,'040710'),(4,'040711'),(2,'05010701'),(4,'05010701'),(2,'999143'),(4,'999143'),(2,'999109'),(2,'999110'),(2,'999111'),(2,'999112'),(2,'999113'),(2,'999114'),(2,'999115'),(2,'999116'),(2,'999117'),(2,'999118'),(2,'999119'),(2,'999120'),(2,'999121'),(2,'999122'),(2,'999123'),(2,'999124'),(2,'999125'),(2,'999126'),(2,'999127'),(2,'999128'),(2,'999129'),(2,'999130'),(2,'999131'),(2,'999132'),(2,'999133'),(2,'999134'),(2,'999135'),(2,'999136'),(2,'999137'),(2,'999138'),(2,'999139'),(2,'999140'),(2,'999141'),(2,'999142'),(4,'999109'),(4,'999110'),(4,'999111'),(4,'999112'),(4,'999113'),(4,'999114'),(4,'999115'),(4,'999116'),(4,'999117'),(4,'999118'),(4,'999119'),(4,'999120'),(4,'999121'),(4,'999122'),(4,'999123'),(4,'999124'),(4,'999125'),(4,'999126'),(4,'999127'),(4,'999128'),(4,'999129'),(4,'999130'),(4,'999131'),(4,'999132'),(4,'999133'),(4,'999134'),(4,'999135'),(4,'999136'),(4,'999137'),(4,'999138'),(4,'999139'),(4,'999140'),(4,'999141'),(4,'999142'),(2,'050110'),(2,'05011001'),(4,'050110'),(4,'05011001'),(2,'050111'),(4,'050111'),(2,'05011101'),(4,'05011101'),(2,'040703'),(4,'040703'),(2,'040704'),(4,'040704'),(2,'040705'),(4,'040705'),(7,'99934'),(2,'040601'),(2,'040602'),(2,'040603'),(2,'040604'),(4,'040601'),(4,'040602'),(4,'040603'),(4,'040604'),(2,'05010201'),(4,'05010201'),(2,'05010301'),(4,'05010301'),(2,'999143'),(4,'999143'),(2,'999144'),(4,'999144'),(2,'999145'),(4,'999145'),(2,'999146'),(4,'999146'),(2,'999147'),(4,'999147'),(2,'040401'),(4,'040401'),(6,'999148'),(7,'999148'),(6,'999149'),(6,'999150'),(6,'999151'),(7,'999151'),(2,'999152'),(4,'999152'),(2,'999153'),(4,'999153'),(2,'999154'),(4,'999154'),(6,'99934'),(2,'040206'),(4,'040206');

--
-- Table structure for table `t_roles`
--

CREATE TABLE `t_roles` (
  `idrol` varchar(20) NOT NULL,
  `descripcion_rol` varchar(45) DEFAULT NULL,
  `idestatus` int DEFAULT '1',
  PRIMARY KEY (`idrol`),
  UNIQUE KEY `idrol_UNIQUE` (`idrol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_roles`
--

INSERT INTO `t_roles` VALUES ('0101','Consulta Reporte',1),('0102','Reportes Gerenciales',1),('0201','RTR',1),('020101','Reporte Nuevo',1),('020102','RTR -Clientes con visitas',1),('02010201','RTR - Ver citas agendadas',1),('0202','RTR - Clientes agendados',1),('0203','RTR - Agenda - Planificador',1),('0204','Lista Reportes',1),('0301','CT - Formulario Pedido',1),('0302','CT - Seguimiento',1),('0401','Seleccion Fabricante a Facturar',1),('040101','Formulario Facturar',1),('040201','Personas',1),('04020101','Lista Persona y Formulario',1),('0402010101','Guardar Persona',1),('04020102','Listar Personas',1),('040202','Productos',1),('04020201','Formulario Producto',1),('0402020101','Guardar Producto',1),('04020202','Listar Productos',1),('040203','Ordenes',1),('040204','Facturas',1),('040205','Categorias',1),('040206','Reportes Admin',1),('040301','Aspecto Social - Grupo Persona',1),('040302','Aspecto Social -Tipo Persona',1),('040303','Aspecto Social - Clase Persona',1),('040304','Aspecto Social - Especialidad',1),('040305','Aspecto Social - Titulo',1),('040401','Localizacion',1),('040402','Zonas',1),('040403','Cadenas',1),('040404','Tipo Localizacion',1),('040405','Clientes a Visitar',1),('040501','Cobertura',1),('040502','Ciclos',1),('040503','Frecuencia',1),('040504','Ranking',1),('040505','Parametros',1),('040601','Auditorias',1),('040602','Logs',1),('040603','Perfiles',1),('040604','Roles',1),('040701','Configuracion - Pais',1),('040702','Configuracion - Idioma',1),('040703','Configuracion - Moneda',1),('040706','Configuracion - Redes Sociales',1),('040707','Configuracion - Dias Feriados',1),('040708','Configuracion - Dias Habiles',1),('040709','Configuracion - Horarios',1),('040710','Configuracion - Actividades',1),('040711','Configuracion - Incidentes',1),('040801','Esquema Promocional',1),('040802','Linea Producto',1),('040803','Tipo Producto',1),('040804','Unidades',1),('0501','Monitor de Archivos',1),('050101','Formato de Zona',1),('05010101','Cargar Formato Zona',1),('050102','Formato de Ruta',1),('05010201','Carga de Formato Ruta',1),('050103','Formato de Cadenas',1),('05010301','Carga de Formato Cadena',1),('050104','Formato CategoriaProducto',1),('050105','Formato LineaProducto',1),('050106','Formato TipoProducto',1),('050107','Formato Producto',1),('05010701','Cargar Producto',1),('050108','Formato Cliente-Rfv',1),('05010801','Cargar Formato Cliente-RFV',1),('050109','Formato Cliente-Materiales',1),('05010901','Cargar Formato Cliente-Materiales',1),('050110','Formato Persona',1),('05011001','Cargar Formato Persona',1),('050111','Formato Cliente-Dias',1),('05011101','Cargar Cliente-Dias',1),('0502','Parametros',1),('0503','Alertas',1),('0504','Historicos',1),('0505','Notificaciones',1),('06','Contacto',1),('07','Manual',1),('08','Preguntas Frecuentes',1),('09','Videos',1),('9990','Cambiar el Fabricante (Empresa)',1),('9991','Buscador Cliente',1),('99910','Mostrar Orden',1),('999100','Borrar Horarios',1),('999101','Agregar Tipo Incidente',1),('999102','Modificar Tipo Incidente',1),('999103','Borrar Tipo Incidente',1),('999104','Mostrar Esquema Promocional',1),('999105','Agregar Esquema Promocional',1),('999106','Modificar Esquema Promocional',1),('999107','Borrar Esquema Promocional',1),('999108','Mostrar Clientes Visitar',1),('999109','Buscar Paises',1),('99911','Mostrar Actividad',1),('999110','Agregar Redes Sociales',1),('999111','Modificar Redes Sociales',1),('999112','Borrar Redes Sociales',1),('999113','Mostrar Redes Sociales',1),('999114','Agregar Dias Visita',1),('999115','Modificar Dias Visita',1),('999116','Borrar Dias Visita',1),('999117','Mostrar Categorias',1),('999118','Agregar Linea Producto',1),('999119','Modificar Linea Producto',1),('99912','Mostrar Mayoristas',1),('999120','Borrar Linea Producto',1),('999121','Agregar Tipo Producto',1),('999122','Modificar Tipo Producto',1),('999123','Borrar Tipo Producto',1),('999124','Agregar Unidades',1),('999125','Modificar Unidades',1),('999126','Borrar Unidades',1),('999127','Mostrar Unidades',1),('999128','Agregar Cadenas',1),('999129','Modificar Cadenas',1),('99913','Mostrar Muestras',1),('999130','Borrar Cadenas',1),('999131','Mostrar Zonas',1),('999132','Agregar Zonas',1),('999133','Modificar Zonas',1),('999134','Borrar Zonas',1),('999135','Agregar Parametros',1),('999136','Modificar Parametros',1),('999137','Borrar Parametros',1),('999138','Mostrar Parametros',1),('999139','Mostrar Lista Negra',1),('99914','Mostrar Productos',1),('999140','Agregar Categorias',1),('999141','Modificar Categorias',1),('999142','Borrar Categorias',1),('999143','Mostrar Moneda',1),('999144','Agregar Listanegra',1),('999145','Modificar Lista Negra',1),('999146','Borrar Lista Negra',1),('999147','Mostrar Personas Por Grupo',1),('999148','Agregar Planificacion Temporal',1),('999149','Buscar RFVs para Planificar',1),('99915','Mostrar Productos 2',1),('999150','Borrar Planificacion Temporal',1),('999151','Contrasena de Confirmacion',1),('999152','Mostrar Logs',1),('999153','Mostar Auditables',1),('999154','Anular Auditables',1),('99916','Clientes disponibles en agenda',1),('99917','Agendar Cita',1),('99918','Mostrar Agenda',1),('99919','Consultas para actividades',1),('9992','RFV_clientes',1),('99920','Consultas para ordenes',1),('99921','Consultas para facturas',1),('99922','Agregar notificacion',1),('99923','Generar PDF de Consultas Reportes',1),('99924','Admin - Mostrar Categoria Producto',1),('99925','Admin - Mostrar Categoria Personas',1),('99926','Admin - Mostrar Lista Personas',1),('99927','Admin - Mostrar Estados por un pais',1),('99928','Admin - Mostrar Ciudad por un estado',1),('99929','Admin - Listar Ordenes',1),('9993','Buscar Cliente por ID',1),('99930','Admin - Listar Facturas',1),('99931','Consulta Gerencial',1),('99932','Admin - Listar Clases',1),('99933','Admin - Listar Grupos',1),('99934','Detalle- citas agendadas',1),('99935','Mostrar detalle Factura',1),('99936','Mostrar Ciclos',1),('99937','Mostrar Frecuencia',1),('99938','Mostrar Ranking',1),('99939','Agregar Ciclos',1),('9994','Buscar Cliente por nombre',1),('99940','Modificar Ciclos',1),('99941','Borrar Ciclos',1),('99942','Agragar Tipo Persona',1),('99943','Modificar Tipo Persona',1),('99944','Borrar Tipo Persona',1),('99945','Agregar Clase Persona',1),('99946','Modificar Clase Persona',1),('99947','Borrar Clase Persona',1),('99948','Agregar Especialidad Persona',1),('99949','Modificar Especialidad Persona',1),('9995','Reportar Cita',1),('99950','Borrar Especialidad Persona',1),('99951','Agregar Titulos',1),('99952','Modificar Titulos',1),('99953','Borrar Titulos',1),('99954','Agregar Grupo Persona',1),('99955','Modificar Grupo Persona',1),('99956','Borrar Grupo Persona',1),('99957','Mostrar Tipo Actividad',1),('99958','Mostrar Tipo Incidente',1),('99959','Mostrar Redes Sociales',1),('9996','Reportar nueva cita',1),('99960','Mostrar Horarios',1),('99961','Mostrar Localizacion',1),('99962','Mostar Tipo de Localizacion',1),('99963','Mostrar Cadenas',1),('99964','Mostrar Tipo Producto',1),('99965','Mostar Linea Producto',1),('99966','Agregar Actividad',1),('99967','Modificar Actividad',1),('99968','Borrar Actividad',1),('99969','Agregar Frecuencias',1),('9997','Crear Orden',1),('99970','Modificar Frecuencias',1),('99971','Borrar Frecuencias',1),('99972','Agregar Ranking',1),('99973','Modificar Ranking',1),('99974','Borrar Ranking',1),('99975','Mostrar Dias Habiles',1),('99976','Mostrar Dias Feriados',1),('99977','Agregar Persona',1),('99978','Modificar Persona',1),('99979','Borrar Persona',1),('9998','Conciliar Orden',1),('99980','Agregar Producto',1),('99981','Modificar Producto',1),('99982','Borrar Producto',1),('99983','Agregar Localizacion',1),('99984','Modificar Localizacion',1),('99985','Borrar Localizacion',1),('99986','Agregar Paises',1),('99987','Modificar Paises',1),('99988','Borrar Paises',1),('99989','Agregar Idiomas',1),('9999','Filtrar Orden por Estatus',1),('99990','Modificar Idiomas',1),('99991','Borrar Idiomas',1),('99992','Agregar Moneda',1),('99993','Modificar Moneda',1),('99994','Borrar Moneda',1),('99995','Agregar Dia Feriado',1),('99996','Modificar Dia Feriado',1),('99997','Borrar Dia Feriado',1),('99998','Agregar Horarios',1),('99999','Modificar Horarios',1);

--
-- Table structure for table `t_sub_especialidad`
--

CREATE TABLE `t_sub_especialidad` (
  `id` varchar(5) NOT NULL COMMENT ' Este es el codigo de la Actividad o Negocio al que se dedica el cliente. esta puede ser Visitador Medico, Representante Venta Repuestos,etc',
  `descripcion_actividad_negocio` varchar(30) DEFAULT NULL COMMENT ' Este campo contiene en detalle la Actividad o Negocio al que se dedica el Cliente, esta puede ser Visitador Medico, Representante Venta Repuestos,etc,',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus de la actividad del negocio al que se dedica el cliente, este puede ser 1. Activo, 2. Inactivo',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_sub_especialidad`
--

INSERT INTO `t_sub_especialidad` VALUES ('0','TEST',1),('CAR','Cardiologia',1),('END','Endocrina',1),('GAS','Gastroenterologia',1),('GIN','Ginecologia',1),('OFT','Oftalmologia',1),('OST','Ostetrica',1),('OTR','Otro',1),('PED','Pediatrica',1),('TRA','Traumatologica',1),('VET','Veterinaria',1);

--
-- Table structure for table `t_tipo_actividades`
--

CREATE TABLE `t_tipo_actividades` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `idtipo_actividades` int NOT NULL AUTO_INCREMENT COMMENT 'Este es el codigo del tipo de Actividad a Realizar, este puede ser 1. Visita Entrega de Material, 2. Visita Congreso, 3. Visita Exposición, 4. Visita Charla, 5. Visita Transferencia, 6. Visita Merchandising, 7. Visita Trabajo de Impulso, 8. Visita Toma de Pedido, 9. Visita Cobranza, 10. Visita acompañada por el Gte.Dtto, 11. Visita acompañada por otros, 12. Visita Punto de encuentro, 13. Fin de jornada, 14. Fin de jornada adelantado, 15. Visita acompañada por mercadeo, 16. Visita Situación personal',
  `descripcion_tipo_actividades` varchar(50) DEFAULT NULL COMMENT 'Este es el campo de la descripcion de la actividad a realizar',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus del tipo de actividades, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`idtipo_actividades`),
  KEY `fk_ttipo_actividades_toperador` (`idOperador`)
) ENGINE=InnoDB AUTO_INCREMENT=35253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_actividades`
--

INSERT INTO `t_tipo_actividades` VALUES ('01','DEMO',1,'MEDICA',1),('01','DEMO',2,'FARMACIAS',1),('01','DEMO',3,'DROGERIA',1),('01','DEMO',4,'ENTREGA MATERIALES',1),('01','DEMO',5,'PROSPECCION Y CAPACITACION',1),('01','DEMO',6,'NUEVOS PRODUCTOS',1),('01','FCPHARMA',7,'VISITA ACOMPAÑADO',1),('01','FCPHARMA',8,'VISITA SOLO',1),('01','FCPHARMA',9,'PERMISO LABORAL',1),('01','FCPHARMA',10,'IMPREVISTO',1),('01','FCPHARMA',11,'ENTREGA MATERIALES',1),('01','FCPHARMA',12,'SALIDA CON RDV',1),('01','DEMO',13,'PEDIDOS',1),('01','BIOLIFE',15,'VISITA',1),('01','BIOLIFE',16,'ENTREGA MATERIALES',1),('01','FCPHARMA',64,'VISITA CON GNT. DISTRITO',1),('01','FCPHARMA',66,'VISITA CON GNT. MERCADEO',1),('01','FCPHARMA',67,'REUNION FC',1),('01','FCPHARMA',71,'TRAMITES ADM. FC',1),('01','FCPHARMA',73,'VISITA TELEFONICA',1),('01','FCPHARMA',74,'DIA FESTIVO',1),('01','FCPHARMA',75,'REPOSO',1),('01','FCPHARMA',77,'VISITA CON  GNT. VENTAS',1),('01','FCPHARMA',78,'TRANSFERENCIA',1),('01','POLINAC',100,'TRANSFERENCIA POLINAC',1),('01','POLINAC',101,'LLAMADA EFECTIVA',1),('01','POLINAC',102,'ENVIAR CORREO',1),('01','FCPHARMA',120,'LLAMADA EFECTIVA FC',1),('01','FCPHARMA',121,'LLAMADA NO EFECTIVA',1),('01','001',1000,'charla bienestar',1),('01','KIMICEG',2000,'LLAMADA EFECTIVA KIMICEG',1),('01','FCPH',4144,'PROMOCION',1),('01','DEMO',10001,'SEGUIMIENTO POSTVENTA',1),('01','KIMICEG',10002,'VISITA',1),('01','KIMICEG',10003,'ENTREGA MATERIALES',1),('01','POLINAC',10005,'ENTREGA MATERIALES',1),('01','MaxPro',10006,'VISITA SOLO MAX',1),('01','MaxPro',10007,'VISITA ACOMPAÑADO SUP.',1),('01','MaxPro',10008,'VISITA',1),('01','MaxPro',10009,'ENTREGA MATERIALES',1),('01','MAXFC',10010,'VISITA',1),('01','MAXFC',10011,'ENTREGA MATERIALES',1),('01','MAXVI',10012,'VISITA',1),('01','MAXVI',10013,'ENTREGA MATERIALES',1),('01','MAXFC',10055,'CHARLA FC',1),('01','MAXFC',10056,'VISITA ACOMP. SUPERVISOR',1),('01','MAXVI',10100,'CHARLA VIVAX',1),('01','MAXVI',10111,'VISITA ACOM. SUP.',1),('01','TURBOF',10112,'VISITA',1),('01','TURBOF',10113,'ENTREGA MATERIALES',1),('01','TURBOF',35222,'VENTA',1),('01','30.450.345',35223,'VISITA',1),('01','30.450.345',35224,'ENTREGA MATERIALES',1),('01','1234',35225,'VISITA',1),('01','1234',35226,'ENTREGA MATERIALES',1),('01','343.546.765',35227,'VISITA',1),('01','343.546.765',35228,'ENTREGA MATERIALES',1),('01','FCPH',35229,'VISITA',1),('01','FCPH',35230,'ENTREGA MATERIALES',1),('01','22779444',35231,'VISITA',1),('01','22779444',35232,'ENTREGA MATERIALES',1),('01','21615025',35233,'VISITA',1),('01','21615025',35234,'ENTREGA MATERIALES',1),('01','32312123',35235,'VISITA',1),('01','32312123',35236,'ENTREGA MATERIALES',1),('01','1',35237,'VISITA',1),('01','1',35238,'ENTREGA MATERIALES',1),('01','001',35239,'ACONDICIONMIENTO',1),('01','001',35240,'CUL DOWN',1),('01','KC',35245,'1. Farmacia',1),('01','KC',35246,'2. Drogueria',1),('01','KC',35247,'3. Act. Especial',1);

--
-- Table structure for table `t_tipo_especialidad`
--

CREATE TABLE `t_tipo_especialidad` (
  `idOperador` varchar(2) NOT NULL,
  `idespecialidad` varchar(5) NOT NULL,
  `descripcion` varchar(45) NOT NULL,
  `estatus` int NOT NULL,
  PRIMARY KEY (`idespecialidad`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_especialidad`
--

INSERT INTO `t_tipo_especialidad` VALUES ('01','DRO','Drogueria',1),('01','FAR','Farmaceutica',1),('01','MED','Medico',1),('01','PER','Perfumeria',1),('01','SUP','Supermercado',1);

--
-- Table structure for table `t_tipo_incidentes`
--

CREATE TABLE `t_tipo_incidentes` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `idtipo_incidentes` int NOT NULL AUTO_INCREMENT COMMENT 'Este es el codigo del tipo de incidente que reporta el Representante de la fuerza de venta a visitar a un Cliente',
  `descripcion_tipo_incidentes` varchar(40) DEFAULT NULL COMMENT 'Descripcion tipo de incidente que reporta el Representante de la fuerza de venta a visitar a un Cliente',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus del tipo de Incidente, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`idtipo_incidentes`),
  KEY `fk_incidente_operador` (`idOperador`)
) ENGINE=InnoDB AUTO_INCREMENT=202508 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_incidentes`
--

INSERT INTO `t_tipo_incidentes` VALUES ('01','DEMO',1,'SIN INCIDENTES',1),('01','DEMO',2,'CLIENTE CONFORME',1),('01','DEMO',3,'CLIENTE NO DISPONIBLE',1),('01','DEMO',4,'CLIENTE DESCONTENTO',1),('01','DEMO',5,'SOLICITUD INFORMACION',1),('01','DEMO',6,'OTRO',1),('01','DEMO',7,'CLIENTE DESCONFORME',0),('01','FCPHARMA',11,'SOLICITUD INFORMACION',0),('01','BIOLIFE',13,'SIN INCIDENTES',1),('01','FCPHARMA',81,'PROMOCION A MEDICO',1),('01','FCPHARMA',82,'VENTA DIRECTA FC',1),('01','FCPHARMA',83,'ACTIVIDADES CORPORATIVAS',1),('01','FCPHARMA',84,'CHARLA',1),('01','FCPHARMA',86,'TRANSFERENCIA',0),('01','FCPHARMA',87,'CONGRESO',1),('01','FCPHARMA',88,'DIA PRODUCTO',1),('01','FCPHARMA',89,'VISITA ACOMPAÑADA',1),('01','FCPHARMA',90,'DIA FESTIVO',1),('01','FCPHARMA',91,'PROMOCION PUNTO DE VENTA',1),('01','001',101,'CLIENTE SATISFECHO',0),('01','POLINAC',103,'CLIENTE INCONFORME',1),('01','POLINAC',105,'CLIENTE CONFORME POLINAC',1),('01','FCPHARMA',1000,'REUNION FC',1),('01','FCPHARMA',1205,'IMPULSO PUNTO DE VENTA',1),('01','MaxPro',2004,'PROMOCION PUNTO DE VENTA MAX',1),('01','FCPHARMA',2222,'LLAMADA MEDICO',1),('01','FCPHARMA',2223,'LLAMADA FARMACIA',1),('01','FCPHARMA',12000,'MERCHADISING',1),('01','FCPHARMA',12001,'REUNION CON CLIENTE',1),('01','FCPHARMA',12002,'NO CONTESTARON',1),('01','FCPHARMA',12004,'VOLVER A LLAMAR',1),('01','FCPHARMA',12006,'TRANSFERENCIA FC',1),('01','KIMICEG',12007,'SIN INCIDENTES',1),('01','KIMICEG',20001,'ENVIAR CORREO',1),('01','KIMICEG',20002,'TRANSFERENCIA KIMICEG',1),('01','POLINAC',20003,'SIN INCIDENTES',1),('01','MaxPro',20005,'SIN INCIDENTES',1),('01','MAXFC',20006,'SIN INCIDENTES',1),('01','MAXVI',20007,'SIN INCIDENTES',1),('01','MAXVI',20010,'MERCHANDISING VIVAX',1),('01','TURBOF',35888,'ENTREGA DE INFORMACION',1),('01','FCPH',41112,'PEDIDO',0),('01','MAXVI',200081,'CHARLA VIVAX',1),('01','MAXVI',200082,'VISITA ACOM. SUP. VI',1),('01','MAXFC',200087,'MERCHANDISING FC',1),('01','MAXFC',200089,'CHARLA FC',1),('01','MAXFC',200090,'VISITA ACOM. SUP.',1),('01','MAXFC',200091,'VISITA',1),('01','TURBOF',200092,'SIN INCIDENTES',1),('01','30.450.345',200093,'SIN INCIDENTES',1),('01','1234',200094,'SIN INCIDENTES',1),('01','343.546.765',200095,'SIN INCIDENTES',1),('01','FCPH',200096,'SIN INCIDENTES',1),('01','22779444',200097,'SIN INCIDENTES',1),('01','21615025',200098,'SIN INCIDENTES',1),('01','32312123',200099,'SIN INCIDENTES',1),('01','1',200100,'SIN INCIDENTES',1),('01','KC',200103,'SIN INCIDENTES',0),('01','KC',202501,'CT- Si',1),('01','KC',202502,'CT- No',1),('01','KC',202503,'Dia de Producto',1),('01','KC',202504,'Jornada Medica',1),('01','KC',202505,'Coffe Break',1),('01','KC',202506,'Inventario',1),('01','KC',202507,'Cliente Nuevo',1);

--
-- Table structure for table `t_tipo_localizaciones`
--

CREATE TABLE `t_tipo_localizaciones` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `cod_tipo_localizacion` varchar(3) NOT NULL COMMENT 'Este es el codigo del tipo de localizacion',
  `descripcion_tipo_localizacion` varchar(60) DEFAULT NULL COMMENT 'Este es el campo de la descripcion del tipo de localizacion',
  `idestatus` varchar(1) DEFAULT NULL COMMENT 'Indica el estatus del tipo de localizacion, este puede ser 1.Activo, 2. Inactivo'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_localizaciones`
--

INSERT INTO `t_tipo_localizaciones` VALUES ('01','22779444','01','Sabana Grande','1'),('01','22779444','2','San Martin','1'),('01','22779444','3','Agua Salud','1'),('01','001','10','BMprueba','1'),('01','DEMO','123','123456','1');

--
-- Table structure for table `t_tipo_notificaciones`
--

CREATE TABLE `t_tipo_notificaciones` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `id` int NOT NULL AUTO_INCREMENT COMMENT ' Id del tipo de notificación que le llegaa al RFV',
  `titulo` varchar(60) DEFAULT NULL COMMENT 'Este campo describe el tipo de notificacion',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus del tmp de producto, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_notificaciones`
--

INSERT INTO `t_tipo_notificaciones` VALUES ('01','DEMO',1,'GENERAL',1),('01','FCPHARMA',2,'GENERAL',1);

--
-- Table structure for table `t_tipo_operacion`
--

CREATE TABLE `t_tipo_operacion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(20) NOT NULL DEFAULT '',
  `estatus` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_operacion`
--

INSERT INTO `t_tipo_operacion` VALUES (1,'Orden - Pedido',1),(2,'Devolucion',1);

--
-- Table structure for table `t_tipo_personas`
--

CREATE TABLE `t_tipo_personas` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Este es el codigo  del tipo de persona, este puede ser 1. Persona Natural 2. Persona Juridica 3. Fundación 4. Pasaporte 5. Extranjero',
  `descripcion_tipo_persona` varchar(60) NOT NULL COMMENT 'Este es el campo de la descripcion del tipo de persona',
  `estatus` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_personas`
--

INSERT INTO `t_tipo_personas` VALUES (1,'Natural',1),(2,'Juridica',1),(3,'Fundacion',1),(4,'Organizacion',1),(5,'Gubernamental',1),(6,'Sin fines de lucro',1),(7,'PRUEBA',1);

--
-- Table structure for table `t_tipo_productos`
--

CREATE TABLE `t_tipo_productos` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `idtipo_producto` int NOT NULL AUTO_INCREMENT COMMENT 'Este es el codigo de los tipos de productos',
  `descripcion_tipo_producto` varchar(60) DEFAULT NULL COMMENT 'Este es el campo de la descripcion del tipo de producto',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus del tipo de producto, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`idtipo_producto`),
  UNIQUE KEY `idtipo_producto_UNIQUE` (`idtipo_producto`),
  KEY `fk_ttipoproducto_toperador_idx` (`idOperador`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tipo_productos`
--

INSERT INTO `t_tipo_productos` VALUES ('01','DEMO',1,'TIPO DEMO',1),('01','KC',2,'OTC',1),('01','KC',3,'ANALGESICO',1),('01','KC',4,'ANTIBIOTICO',1),('01','KC',5,'ANTISEPTICO',1),('01','KC',6,'VITAMINAS',1),('01','KC',7,'FARMACEUTICOS',1),('01','KC',8,'COSMETICOS',1),('01','KC',9,'VITAMINAS',1),('01','KC',10,'OTROS',1),('01','DEMO',11,'POP',1),('01','BIOLIFE',12,'BIOLIFE',1),('01','POLINAC',13,'GENERICO',1),('01','KC',14,'FARMA',1),('01','MaxPro',15,'FARMA',1),('01','MAXFC',16,'FARMA',1),('01','MAXVI',17,'FARMA',1),('01','TURBOF',18,'PORTATIL 1',1),('01','FCPH',19,'Material 1',1),('01','001',20,'SUPLEMENTO',1);

--
-- Table structure for table `t_titulos`
--

CREATE TABLE `t_titulos` (
  `id` varchar(5) NOT NULL COMMENT 'Este es el identificador del titulo de la Persona, es decir Dr.- DOCTOR,  Sr. - Señor, Ing. - Ingeniero, Lic. - Licenciado ',
  `descripcion` varchar(60) DEFAULT NULL COMMENT 'Este es el campo de la descripcion del titulo',
  `idestatus` int DEFAULT '1' COMMENT 'Indica el estatus, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_titulos`
--

INSERT INTO `t_titulos` VALUES ('bach','bachiller',0),('Doc','Doctor',1),('Est','Estudiante',1),('fffff','fffff',0),('Ing','Ingeniero',1),('Lic','Licenciado',1),('Mag','Magiste',0),('Past','Pasante',1),('SEP','sEPTIEMBRE',0),('Sr','Sr.',1),('Sra','Sra.',1),('TSU','Tecnico Superior Universitario',1);

--
-- Table structure for table `t_tmp_planificadores`
--

CREATE TABLE `t_tmp_planificadores` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `idOperador` varchar(2) NOT NULL DEFAULT '',
  `idFabricante` varchar(11) NOT NULL DEFAULT '',
  `idRFV` varchar(11) NOT NULL DEFAULT '',
  `idCliente` varchar(11) NOT NULL DEFAULT '',
  `Fecha` date DEFAULT NULL,
  `Hora` time DEFAULT NULL,
  `idSupervisor` varchar(11) DEFAULT NULL,
  `idstatus` int DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=1335 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_tmp_planificadores`
--

INSERT INTO `t_tmp_planificadores` VALUES (1,'01','DEMO','DEMORFV1','DCLI1','2018-05-23','01:15:00','DEMOSUP',2),(2,'01','DEMO','DEMORFV1','DCLI17','2018-05-16','00:55:00','DEMOSUP',2),(45,'01','DEMO','DEMORFV4','DCLI32','2018-08-02','01:59:00','DEMOSUP2',1),(46,'01','DEMO','DEMORFV4','DCLI12','2018-08-02','02:10:00','DEMOSUP2',1),(293,'01','FCPHARMA','15761482','FC36','2018-09-18','00:00:00','V12111343',1),(304,'01','FCPHARMA','15761482','FC49','2018-09-19','00:00:00','V12111343',1),(312,'01','FCPHARMA','15761482','FC59','2018-09-19','00:00:00','V12111343',1),(322,'01','FCPHARMA','15761482','FC67','2018-09-20','00:59:00','V12111343',1),(638,'01','FCPHARMA','V11035568','FC1000','2018-10-16','04:00:00','V6822122',1),(680,'01','FCPHARMA','V11035568','FC698','2018-10-23','10:59:00','V6822122',1),(683,'01','FCPHARMA','V11035568','FC682','2018-10-23','02:00:00','V6822122',1),(684,'01','FCPHARMA','V11035568','FC683','2018-10-23','03:00:00','V6822122',1),(685,'01','FCPHARMA','V11035568','FC693','2018-10-23','04:01:00','V6822122',1),(686,'01','FCPHARMA','V11035568','FC656','2018-10-24','07:00:00','V6822122',1),(687,'01','FCPHARMA','V11035568','FC654','2018-10-24','08:00:00','V6822122',1),(688,'01','FCPHARMA','V11035568','FC655','2018-10-24','09:01:00','V6822122',1),(689,'01','FCPHARMA','V11035568','FC653','2018-10-24','10:00:00','V6822122',1),(690,'01','FCPHARMA','V11035568','FC662','2018-10-24','11:00:00','V6822122',1),(691,'01','FCPHARMA','V11035568','FC663','2018-10-24','00:00:00','V6822122',1),(692,'01','FCPHARMA','V11035568','FC650','2018-10-24','01:00:00','V6822122',1),(693,'01','FCPHARMA','V11035568','FC648','2018-10-24','02:01:00','V6822122',1),(694,'01','FCPHARMA','V11035568','FC649','2018-10-24','03:01:00','V6822122',1),(695,'01','FCPHARMA','V11035568','FC652','2018-10-24','04:01:00','V6822122',1),(696,'01','FCPHARMA','V11035568','FC661','2018-10-24','05:17:00','V6822122',1),(697,'01','FCPHARMA','V11035568','FC1000','2018-10-25','07:00:00','V6822122',1),(698,'01','FCPHARMA','V11035568','FC713','2018-10-25','09:00:00','V6822122',1),(699,'01','FCPHARMA','V11035568','FC709','2018-10-25','10:59:00','V6822122',1),(700,'01','FCPHARMA','V11035568','FC703','2018-10-25','11:47:00','V6822122',1),(701,'01','FCPHARMA','V11035568','FC700','2018-10-25','00:01:00','V6822122',1),(702,'01','FCPHARMA','V11035568','FC708','2018-10-25','01:39:00','V6822122',1),(703,'01','FCPHARMA','V11035568','FC701','2018-10-25','02:10:00','V6822122',1),(704,'01','FCPHARMA','V11035568','FC710','2018-10-25','03:01:00','V6822122',1),(705,'01','FCPHARMA','V11035568','FC707','2018-10-25','04:01:00','V6822122',1),(706,'01','FCPHARMA','V11035568','FC640','2018-10-26','07:00:00','V6822122',1),(707,'01','FCPHARMA','V11035568','FC644','2018-10-26','08:00:00','V6822122',1),(708,'01','FCPHARMA','V11035568','FC645','2018-10-26','09:00:00','V6822122',1),(709,'01','FCPHARMA','V11035568','FC641','2018-10-26','10:59:00','V6822122',1),(710,'01','FCPHARMA','V11035568','FC643','2018-10-26','11:00:00','V6822122',1),(711,'01','FCPHARMA','V11035568','FC642','2018-10-26','00:01:00','V6822122',1),(712,'01','FCPHARMA','V11035568','FC1000','2018-10-26','02:00:00','V6822122',1),(713,'01','FCPHARMA','V11035568','FC689','2018-10-29','07:00:00','V6822122',1),(714,'01','FCPHARMA','V11035568','FC674','2018-10-29','08:03:00','V6822122',1),(715,'01','FCPHARMA','V11035568','FC684','2018-10-29','09:05:00','V6822122',1),(716,'01','FCPHARMA','V11035568','FC696','2018-10-29','10:59:00','V6822122',1),(717,'01','FCPHARMA','V11035568','FC673','2018-10-29','11:08:00','V6822122',1),(718,'01','FCPHARMA','V11035568','FC685','2018-10-29','11:00:00','V6822122',1),(719,'01','FCPHARMA','V11035568','FC686','2018-10-29','01:02:00','V6822122',1),(720,'01','FCPHARMA','V11035568','FC690','2018-10-29','02:02:00','V6822122',1),(721,'01','FCPHARMA','V11035568','FC697','2018-10-29','03:06:00','V6822122',1),(722,'01','FCPHARMA','V11035568','FC695','2018-10-29','04:00:00','V6822122',1),(723,'01','FCPHARMA','V11035568','FC667','2018-10-30','07:00:00','V6822122',1),(724,'01','FCPHARMA','V11035568','FC668','2018-10-30','08:01:00','V6822122',1),(725,'01','FCPHARMA','V11035568','FC668','2018-10-30','08:01:00','V6822122',1),(726,'01','FCPHARMA','V11035568','FC672','2018-10-30','09:01:00','V6822122',1),(727,'01','FCPHARMA','V11035568','FC665','2018-10-30','10:59:00','V6822122',1),(728,'01','FCPHARMA','V11035568','FC1000','2018-10-30','11:01:00','V6822122',1),(729,'01','FCPHARMA','V11035568','FC702','2018-10-30','00:01:00','V6822122',1),(730,'01','FCPHARMA','V11035568','FC711','2018-10-30','01:58:00','V6822122',1),(731,'01','FCPHARMA','V11035568','FC712','2018-10-30','02:00:00','V6822122',1),(732,'01','FCPHARMA','V11035568','FC1000','2018-10-30','03:00:00','V6822122',1),(733,'01','FCPHARMA','V11035568','FC704','2018-10-30','04:01:00','V6822122',1),(734,'01','FCPHARMA','V11035568','FC705','2018-10-30','05:00:00','V6822122',1),(735,'01','FCPHARMA','V11035568','FC595','2018-10-31','07:01:00','V6822122',1),(736,'01','FCPHARMA','V11035568','FC597','2018-10-31','09:00:00','V6822122',1),(737,'01','FCPHARMA','V11035568','FC1000','2018-10-31','11:00:00','V6822122',1),(738,'01','FCPHARMA','V11035568','FC596','2018-10-31','00:01:00','V6822122',1),(739,'01','FCPHARMA','V11035568','FC600','2018-10-31','01:02:00','V6822122',1),(740,'01','FCPHARMA','V11035568','FC599','2018-10-31','02:05:00','V6822122',1),(741,'01','FCPHARMA','V11035568','FC593','2018-10-31','03:01:00','V6822122',1),(742,'01','FCPHARMA','V11035568','FC594','2018-10-31','04:00:00','V6822122',1),(906,'01','DEMO','DEMORFV3','DCLI7','2018-11-01','01:05:00','DEMOSUP2',1),(907,'01','DEMO','DEMORFV3','DCLI3','2018-11-02','02:10:00','DEMOSUP2',1),(910,'01','FCPHARMA','15761482','FC104','2018-11-07','01:06:00','V12111343',1),(913,'01','FCPHARMA','HUMBERFC','FC001','2019-08-15','11:30:00','VCARLOS',1),(914,'01','FCPHARMA','HUMBERFC','FC001','2019-08-28','02:30:00','VCARLOS',1),(915,'01','FCPHARMA','HUMBERFC','FC001','2019-08-23','03:30:00','VCARLOS',1),(916,'01','FCPHARMA','HUMBERFC','FC001','2019-08-21','01:05:00','VCARLOS',1),(917,'01','FCPHARMA','HUMBERFC','FC001','2019-08-13','11:29:00','VCARLOS',1),(1010,'01','FCPHARMA','HUMBERFC','FC001','2019-08-28','11:00:00','VCARLOS',1),(1113,'01','MaxPro','MaxR11','MAXC539','2019-09-17','10:30:00','MaxS2',1),(1114,'01','MaxPro','MaxR11','MAXC541','2019-09-17','11:00:00','MaxS2',1),(1115,'01','MaxPro','MaxR11','MAXC540','2019-09-17','00:00:00','MaxS2',1),(1116,'01','MaxPro','MaxR11','MAXC537','2019-09-17','00:30:00','MaxS2',1),(1177,'01','MaxPro','MaxR11','MAXC517','2019-09-23','10:29:00','MaxS2',1),(1205,'01','MAXFC','MFCR2','MFCC11','2019-09-30','11:30:00','MFCS1',1),(1206,'01','MAXFC','MFCR2','MFCC12','2019-09-23','15:30:00','MFCS1',1),(1207,'01','MAXFC','MFCR2','MFCC13','2019-09-30','16:30:00','MFCS1',1),(1208,'01','MAXFC','MFCR2','MFCC12','2019-09-30','15:30:00','MFCS1',1),(1209,'01','MAXFC','MFCR2','MFCC15','2019-10-01','11:30:00','MFCS1',1),(1210,'01','MAXFC','MFCR2','MFCC14','2019-10-01','15:30:00','MFCS1',1),(1211,'01','MAXFC','MFCR2','MFCC18','2019-10-02','11:30:00','MFCS1',1),(1212,'01','MAXFC','MFCR2','MFCC19','2019-10-02','12:30:00','MFCS1',1),(1213,'01','MAXFC','MFCR2','MFCC16','2019-10-02','15:30:00','MFCS1',1),(1214,'01','MAXFC','MFCR2','MFCC15','2019-10-03','11:30:00','MFCS1',1),(1215,'01','MAXFC','MFCR2','MFCC17','2019-10-03','15:30:00','MFCS1',1),(1216,'01','MAXFC','MFCR2','MFCC14','2019-10-04','11:30:00','MFCS1',1),(1217,'01','MAXFC','MFCR2','MFCC16','2019-10-04','15:30:00','MFCS1',1),(1218,'01','MAXFC','MFCR5','MFCC43','2019-09-24','11:30:00','MFCS1',1),(1219,'01','MAXFC','MFCR5','MFCC44','2019-09-24','15:30:00','MFCS1',1),(1220,'01','MAXFC','MFCR5','MFCC43','2019-09-23','11:29:00','MFCS1',1),(1221,'01','MAXFC','MFCR5','MFCC43','2019-09-23','11:29:00','MFCS1',1),(1222,'01','MAXFC','MFCR5','MFCC44','2019-09-23','15:30:00','MFCS1',1),(1223,'01','MAXFC','MFCR5','MFCC47','2019-09-25','11:30:00','MFCS1',1),(1224,'01','MAXFC','MFCR5','MFCC48','2019-09-25','15:30:00','MFCS1',1),(1225,'01','MAXFC','MFCR5','MFCC49','2019-09-26','11:30:00','MFCS1',1),(1226,'01','DEMO','DEMOHUMB','DCLI0','2021-12-22','09:00:00','DEMOSUP',1),(1227,'01','DEMO','DEMOHUMB','DCLI10','2021-12-21','11:59:00','DEMOSUP',1),(1228,'01','DEMO','DEMOHUMB','DCLI0','2021-12-23','01:30:00','DEMOSUP',1),(1229,'01','DEMO','DEMOHUMB','DCLI1','2021-12-28','11:04:00','DEMOSUP',1),(1230,'01','DEMO','DEMOHUMB','DCLI100','2021-12-28','03:30:00','DEMOSUP',1),(1231,'01','DEMO','DEMOHUMB','DCLI2','2021-12-30','13:00:00','DEMOSUP',1),(1232,'01','DEMO','DEMO5','DCLI11','2025-02-06','09:09:00','DEMOADM',1),(1233,'01','DEMO','DEMO5','DCLI10','2025-02-07','01:05:00','DEMOADM',1),(1234,'01','DEMO','DEMO5','DCLI12','2025-02-07','01:05:00','DEMOADM',1),(1235,'01','DEMO','DEMO5','DCLI100','2025-02-07','01:05:00','DEMOADM',1),(1236,'01','DEMO','DEMO5','DCLI26','2025-02-10','09:30:00','DEMOADM',1),(1237,'01','DEMO','DEMO5','DCLI11','2025-02-11','01:05:00','DEMOADM',1),(1238,'01','DEMO','DEMO5','DCLI1','2025-02-12','01:05:00','DEMOADM',1),(1239,'01','DEMO','DEMO5','DCLI20','2025-02-13','10:00:00','DEMOADM',1),(1240,'01','DEMO','DEMO5','DCLI100','2025-02-24','09:30:00','DEMOADM',1),(1241,'01','DEMO','DEMO5','DCLI26','2025-02-24','11:12:00','DEMOADM',1),(1242,'01','DEMO','DEMO5','DCLI11','2025-02-13','10:15:00','DEMOADM',1),(1243,'01','DEMO','DEMO5','DCLI100','2025-02-14','10:00:00','DEMOADM',1),(1244,'01','DEMO','DEMO5','DCLI12','2025-02-14','10:01:00','DEMOADM',1),(1245,'01','DEMO','DEMO5','DCLI100','2025-02-17','15:00:00','DEMOADM',1),(1246,'01','KIMICEG','KC10','KIMI10','2025-02-24','09:00:00','SHUMBERTO',1),(1247,'01','KIMICEG','KC10','KIMI100','2025-02-24','09:00:00','SHUMBERTO',1),(1248,'01','DEMO','DEMO5','DCLI11','2025-02-24','15:05:00','DEMOADM',1),(1249,'01','KIMICEG','KC10','KIMI10','2025-02-28','06:40:00','SHUMBERTO',1),(1250,'01','KIMICEG','KC10','KIMI10','2025-02-28','10:30:00','SHUMBERTO',1),(1251,'01','KIMICEG','KC10','KIMI12','2025-02-28','10:45:00','SHUMBERTO',1),(1252,'01','KIMICEG','KC13','KIMI14','2025-03-10','09:01:00','SHUMBERTO',1),(1253,'01','DEMO','DEMO5','DCLI10','2025-03-10','07:55:00','DEMOADM',1),(1254,'01','DEMO','DEMO5','DCLI100','2025-03-10','10:30:00','DEMOADM',1),(1255,'01','DEMO','DEMO5','DCLI13','2025-03-11','11:00:00','DEMOADM',1),(1256,'01','DEMO','DEMO5','DCLI100','2025-03-12','11:56:00','DEMOADM',1),(1257,'01','DEMO','DEMOHUMB','DCLI100','2025-03-13','11:10:00','DEMOSUP',1),(1258,'01','KIMICEG','KC10','KIMI12','2025-03-15','11:05:00','SHUMBERTO',1),(1259,'01','KIMICEG','KC10','KIMI64','2025-03-15','09:50:00','SHUMBERTO',1),(1260,'01','DEMO','DEMORFV4','DCLI28','2025-03-17','10:10:00','DEMOADM',1),(1261,'01','DEMO','DEMORFV4','DCLI28','2025-03-17','01:10:00','DEMOADM',1),(1262,'01','DEMO','DEMO5','DCLI100','2025-03-16','11:10:00','DEMOADM',1),(1263,'01','DEMO','DEMO5','DCLI1','2025-03-16','11:05:00','DEMOADM',1),(1264,'01','DEMO','DEMO5','DCLI1','2025-03-17','01:05:00','DEMOADM',1),(1265,'01','DEMO','DEMO5','DCLI1','2025-03-17','05:25:00','DEMOADM',1),(1266,'01','DEMO','DEMORFV4','DCLI12','2025-03-17','09:05:00','DEMOADM',1),(1267,'01','DEMO','DEMORFV4','DCLI16','2025-03-18','07:44:00','DEMOADM',1),(1268,'01','DEMO','DEMORFV4','DCLI100','2025-03-17','07:40:00','DEMOADM',1),(1269,'01','DEMO','DEMORFV4','DCLI100','2025-03-17','05:31:00','DEMOADM',1),(1270,'01','DEMO','DEMO5','DCLI0','2025-03-17','04:40:00','DEMOADM',1),(1271,'01','DEMO','DEMO5','DCLI1','2025-03-18','07:25:00','DEMOADM',1),(1272,'01','DEMO','DEMO5','DCLI1','2025-03-18','06:45:00','DEMOADM',1),(1273,'01','DEMO','DEMO5','DCLI1','2025-03-17','03:30:00','DEMOADM',1),(1274,'01','KIMICEG','KC10','KIMI10','2025-03-21','07:51:00','SHUMBERTO',1),(1275,'01','KIMICEG','KC10','KIMI100','2025-03-18','08:36:00','SHUMBERTO',1),(1276,'01','KIMICEG','KC10','KIMI11','2025-03-18','08:05:00','SHUMBERTO',1),(1277,'01','KIMICEG','KC10','KIMI100','2025-03-19','08:30:00','SHUMBERTO',1),(1278,'01','KIMICEG','KC10','KIMI64','2025-03-18','11:00:00','SHUMBERTO',1),(1279,'01','KIMICEG','KC10','KIMI12','2025-03-19','11:00:00','SHUMBERTO',1),(1280,'01','KIMICEG','KC10','KIMI11','2025-03-20','11:00:00','SHUMBERTO',1),(1281,'01','KIMICEG','KC10','KIMI64','2025-03-19','09:10:00','SHUMBERTO',1),(1282,'01','DEMO','DEMORFV4','DCLI64','2025-03-21','11:01:00','DEMOADM',1),(1283,'01','DEMO','DEMORFV4','DCLI64','2025-03-20','02:16:00','DEMOADM',1),(1284,'01','DEMO','DEMORFV4','DCLI12','2025-03-17','14:20:00','DEMOADM',1),(1285,'01','DEMO','DEMORFV4','DCLI44','2025-03-17','16:20:00','DEMOADM',1),(1286,'01','DEMO','DEMOHUMB','DCLI11','2025-03-20','11:35:00','DEMOSUP',1),(1287,'01','DEMO','DEMO5','DCLI18','2025-03-21','13:21:00','DEMOADM',1),(1288,'01','DEMO','DEMORFV4','DCLI32','2025-03-21','13:25:00','DEMOADM',1),(1289,'01','DEMO','DEMORFV4','DCLI16','2025-03-24','10:58:00','DEMOADM',1),(1290,'01','DEMO','DEMORFV4','DCLI48','2025-03-24','11:37:00','DEMOADM',1),(1291,'01','DEMO','DEMORFV4','DCLI4','2025-03-24','12:18:00','DEMOADM',1),(1292,'01','DEMO','DEMORFV4','DCLI100','2025-03-24','10:35:00','DEMOADM',1),(1293,'01','DEMO','DEMORFV4','DCLI12','2025-03-24','10:45:00','DEMOADM',1),(1294,'01','DEMO','DEMORFV4','DCLI40','2025-03-24','11:02:00','DEMOADM',1),(1295,'01','DEMO','DEMORFV4','DCLI40','2025-03-24','11:11:00','DEMOADM',1),(1296,'01','DEMO','DEMORFV4','DCLI48','2025-03-24','11:14:00','DEMOADM',1),(1297,'01','DEMO','DEMORFV4','DCLI40','2025-03-24','11:16:00','DEMOADM',1),(1298,'01','DEMO','DEMORFV4','DCLI32','2025-03-24','11:36:00','DEMOADM',1),(1299,'01','DEMO','DEMO5','DCLI1','2025-03-27','15:41:00','DEMOADM',1),(1300,'01','KC','KCRFV04','KC115','2025-04-01','09:20:00','KCSUP02',1),(1301,'01','KC','KCRFV04','KCRFV04N','2025-04-01','09:40:00','KCSUP02',1),(1302,'01','KC','KCRFV04','KCRFV04N','2025-04-01','10:30:00','KCSUP02',1),(1303,'01','KC','KCRFV04','KCRFV04N','2025-04-01','11:00:00','KCSUP02',1),(1304,'01','KC','KCRFV04','KC083','2025-04-01','08:30:00','KCSUP02',1),(1305,'01','KC','KCRFV04','KCRFV04N','2025-04-01','02:14:00','KCSUP02',1),(1306,'01','KC','KCRFV04','KC119','2025-04-01','15:20:00','KCSUP02',1),(1307,'01','KC','KCRFV04','KC118','2025-04-01','16:25:00','KCSUP02',1),(1308,'01','KC','KCRFV04','KC116','2025-04-02','08:01:00','KCSUP02',1),(1309,'01','KC','KCRFV04','KC117','2025-04-02','08:39:00','KCSUP02',1),(1310,'01','KC','KCRFV04','KC118','2025-04-02','09:14:00','KCSUP02',1),(1311,'01','DEMO','DEMO5','DCLI100','2025-04-04','13:05:00','DEMOADM',1),(1312,'01','DEMO','DEMO5','DCLI1','2025-04-04','11:06:00','DEMOADM',1),(1313,'01','DEMO','DEMO5','DCLI1','2025-04-12','11:25:00','DEMOADM',1),(1314,'01','DEMO','DEMO5','DCLI10','2025-05-13','18:30:00','DEMOADM',1),(1315,'01','DEMO','DEMO5','DCLI11','2025-05-13','18:10:00','DEMOADM',1),(1316,'01','DEMO','DEMORFV04','DCLI10','2025-05-22','11:05:00','DEMOADM',1),(1317,'01','DEMO','DEMORFV04','DCLI100','2025-05-22','11:21:00','DEMOADM',1),(1318,'01','DEMO','DEMORFV04','DCLI1','2025-06-04','08:10:00','DEMOADM',1),(1319,'01','DEMO','DEMORFV04','DCLI1','2025-06-03','09:30:00','DEMOADM',1),(1320,'01','DEMO','DEMORFV04','DCLI1','2025-06-06','00:06:00','DEMOADM',1),(1321,'01','DEMO','DEMOHUMB','DCLI16','2025-06-18','08:10:00','DEMOSUP',1),(1322,'01','DEMO','DEMOHUMB','DCLI13','2025-06-18','11:30:00','DEMOSUP',1),(1323,'01','DEMO','DEMOHUMB','DCLI11','2025-06-21','03:05:00','DEMOSUP',1),(1324,'01','DEMO','DEMOHUMB','DCLI11','2025-06-21','01:06:00','DEMOSUP',1),(1325,'01','DEMO','DEMOHUMB','DCLI11','2025-06-16','01:44:00','DEMOSUP',1),(1326,'01','DEMO','DEMOHUMB','DCLI11','2025-06-21','14:10:00','DEMOSUP',1),(1327,'01','DEMO','DEMOHUMB','DCLI11','2025-06-24','01:05:00','DEMOSUP',1),(1328,'01','DEMO','DEMOHUMB','DCLI14','2025-06-26','00:00:00','DEMOSUP',1),(1329,'01','DEMO','DEMOHUMB','DCLI15','2025-06-25','00:10:00','DEMOSUP',1),(1330,'01','KC','KCRFV01','KC352','2025-06-25','12:05:00','KCSUP01',1),(1331,'01','DEMO','DEMOHUMB','DCLI11','2025-07-08','02:11:00','DEMOSUP',1),(1332,'01','DEMO','DEMOHUMB','DCLI11','2025-07-15','11:10:00','DEMOSUP',1),(1333,'01','DEMO','DEMOHUMB','DCLI0','2025-07-14','11:56:00','DEMOSUP',1),(1334,'01','DEMO','DEMOHUMB','DCLI0','2025-08-25','01:05:00','DEMOSUP',1);

--
-- Table structure for table `t_unidades`
--

CREATE TABLE `t_unidades` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Este es el indicador de Medidas en que está el producto. 1. grageas, jarabe, comprimidos, polvo, cremas, masticables, mg, ml, gramos, etc.',
  `descripcion_unidades` varchar(100) NOT NULL COMMENT 'Este campo describe la unidad de medida',
  `idestatus` int NOT NULL DEFAULT '1' COMMENT 'Indica el estatus de la unidad de medida, este puede ser 1.Activo, 2. Inactivo',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_unidades`
--

INSERT INTO `t_unidades` VALUES (1,'Kg. Kilos',1),(2,'Gr. Gramos',1),(3,'Mgr. Miligramos',1),(4,'Lt. Litros',1),(5,'Ml. Mililitros',1),(6,'Gg. Gagreas',1),(7,'Ot OTRO',1),(8,'MICROGRAMOS',1);

--
-- Table structure for table `t_zonas`
--

CREATE TABLE `t_zonas` (
  `idOperador` varchar(2) NOT NULL COMMENT 'Este es el identificador de la Empresa que Opera el Sistema',
  `idFabricante` varchar(11) NOT NULL COMMENT 'Fabricante empresa cliente del operador',
  `idzona` int NOT NULL AUTO_INCREMENT COMMENT 'En este campo indica la zona del RV ',
  `descripcion_zona` varchar(40) DEFAULT NULL COMMENT 'En este campo indica la zona del RV ',
  `idestatus` varchar(1) DEFAULT '1' COMMENT 'Indica el estatus de la zona, este puede ser 1.Activo, 2. Inactivo',
  `idciudad` int DEFAULT NULL,
  `idestado` varchar(4) DEFAULT NULL,
  `idpais` varchar(3) NOT NULL,
  PRIMARY KEY (`idzona`),
  KEY `fk_zonaoperador_operador_idx` (`idOperador`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `t_zonas`
--

INSERT INTO `t_zonas` VALUES ('01','KC',1,'Amazonas','1',47263,'4020','237'),('01','KC',2,'Anzoategui','1',47265,'4021','237'),('01','KC',3,'Apure','1',47271,'4022','237'),('01','KC',4,'Aragua','1',47276,'4023','237'),('01','KC',5,'Barinas','1',47281,'4024','237'),('01','KC',6,'Bolivar','1',47283,'4025','237'),('01','KC',7,'Delta Amacuro','1',48317,'4028','237'),('01','KC',8,'Distrito Capital','1',48315,'4029','237'),('01','KC',9,'Falcon','1',47297,'4030','237'),('01','KC',10,'Guarico','1',47302,'4031','237'),('01','KC',11,'Lara','1',47305,'4032','237'),('01','KC',12,'Merida','1',47313,'4033','237'),('01','KC',13,'Miranda','1',47328,'4034','237'),('01','KC',14,'Monagas','1',47333,'4035','237'),('01','KC',15,'Nueva Esparta','1',48318,'4036','237'),('01','KC',16,'Portuguesa','1',47336,'4037','237'),('01','KC',17,'Sucre','1',47339,'4038','237'),('01','KC',18,'Tachira','1',47343,'4039','237'),('01','KC',19,'Trujillo','1',47346,'4040','237'),('01','KC',20,'La Guaira','1',47349,'4041','237'),('01','KC',21,'Yaracuy','1',47353,'4042','237'),('01','KC',22,'Zulia','1',47360,'4043','237'),('01','KC',23,'Carabobo','1',47294,'4026','237'),('01','KC',24,'Cojedes','1',47295,'4027','237'),('01','DEMO',123,'123456','0',21568,'1705','103');


