INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FNVL','022110','2024-05-29 19:48:48','052024','CO','1006769058','LICE ','CALDERON ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2773.109243697479','526.8907563025209','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 19:48:48','3300','87','BOD. FARMANORTE 87','1','3300','3300','2773.1092436975','526.89075630252','3300','1','0','1','','30/05/2024','',3300,0,0,'7702006298940','EGO GEL FOR MEN ATTRACTION *110 ML','388','UNILEVER ANDINA COLOMBIA','2024-05-29 19:48:48',  2314, 54210, 223, 99),('FVE','FNVL','022111','2024-05-29 19:50:13','052024','CO','1082845614','CINDY PAOLA','FLORES PUERTAS','KRA 21A 3 N 29G-38 LOS FAROLES',' 3046047442','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','8','43300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 19:50:14','43300','87','BOD. FARMANORTE 87','5','1800','9000','9000','0','9000','0','5','217','','30/05/2024','',43300,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-29 19:50:13',  111600, 43550, 223, 99),('FVE','FNVL','022111','2024-05-29 19:50:13','052024','CO','1082845614','CINDY PAOLA','FLORES PUERTAS','KRA 21A 3 N 29G-38 LOS FAROLES',' 3046047442','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','8','43300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 19:50:14','43300','87','BOD. FARMANORTE 87','2','15800','31600','31600','0','31600','2','0','217','','30/05/2024','',43300,0,0,'7707210530572','SIMPIOX GOTAS *5 ML  ','256','GERCO','2024-05-29 19:50:13',  8081, 29858, 223, 99),('FVE','FNVL','022111','2024-05-29 19:50:13','052024','CO','1082845614','CINDY PAOLA','FLORES PUERTAS','KRA 21A 3 N 29G-38 LOS FAROLES',' 3046047442','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','8','43300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 19:50:14','43300','87','BOD. FARMANORTE 87','1','2700','2700','2700','0','2700','0','1','217','','30/05/2024','',43300,0,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-05-29 19:50:13',  33370, 62346, 223, 99),('FVE','FNVL','022112','2024-05-29 20:11:33','052024','CO','1007780615','PEDRO ','FUENTE ','',' 3000000000','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','3529.4117647058824','670.5882352941176','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:11:33','4200','87','BOD. FARMANORTE 87','1','4200','4200','3529.4117647059','670.58823529412','4200','1','0','0','','30/05/2024','',4200,0,0,'7702535027868','AGUA BRISA MANZANA *1.5 LT','144','COCA COLA','2024-05-29 20:11:33',  2104.2, 57786, 223, 99),('FVE','FNVL','022113','2024-05-29 20:21:30','052024','CO','1083028894','LEIDY ','REDONDO ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','8571.428571428572','1628.5714285714275','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:21:31','10200','87','BOD. FARMANORTE 87','1','10200','10200','8571.4285714286','1628.5714285714','10200','1','0','0','','30/05/2024','',0,10200,0,'7702123003137','ACID MANTLE JABON *90 GR','631','BAYER OTC','2024-05-29 20:21:30',  5800, 22843, 223, 99),('FVE','FNVL','022114','2024-05-29 20:32:41','052024','CO','85476242','ARTURO','CHARRIS','MZ L CASA 256 VILLA MARBELLA',' 3107091747  3107091747 ','4142','SANDRO  JUNIOR','OSORIO  CARMONA','2589','ALEXANDER YOEL ','BRITO ALVAREZ','1620586','1620586','RIVERA DE LA HOZ JOSE LUIS','','','2','53500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:32:41','53500','87','BOD. FARMANORTE 87','1','51500','51500','51500','0','51500','1','0','0','27','30/05/2024','',0,53500,0,'7841141002712','ILTUX 40 MG *28 COMP ','380','TECNOFARMA','2024-05-29 20:32:41',  53000, 42677, 223, 99),('FVE','FNVL','022114','2024-05-29 20:32:41','052024','CO','85476242','ARTURO','CHARRIS','MZ L CASA 256 VILLA MARBELLA',' 3107091747  3107091747 ','4142','SANDRO  JUNIOR','OSORIO  CARMONA','2589','ALEXANDER YOEL ','BRITO ALVAREZ','1620586','1620586','RIVERA DE LA HOZ JOSE LUIS','','','2','53500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:32:41','53500','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',0,53500,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 20:32:41',  1500, 44348, 223, 99),('FVE','FNVL','022115','2024-05-29 20:38:20','052024','CO','26761907','CAROLINA','CURIEL','al lado de la optica, reja bla',' 3105799445','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','2','28290.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:38:21','28690','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','141','','30/05/2024','',0,28690,0,'7702189055453','NATUCHIPS PLATANO VERDE *38 GR','762','FRITO LAY','2024-05-29 20:38:20',  1479, 57247, 223, 99),('FVE','FNVL','022115','2024-05-29 20:38:20','052024','CO','26761907','CAROLINA','CURIEL','al lado de la optica, reja bla',' 3105799445','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','2','28290.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:38:21','28690','87','BOD. FARMANORTE 87','1','26190','26190','26190','0','26190','1','0','141','','30/05/2024','',0,28690,0,'7703889000552','TRIGENTAX CREMA *20 GR','242','CHALVER ','2024-05-29 20:38:20',  23921, 29000, 223, 99),('FVE','FNVL','022116','2024-05-29 20:53:48','052024','CO','1083006602','SHARON ','SERRANO','',' 3239233116','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','2','15494.117647058823','1005.8823529411766','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:53:48','16500','87','BOD. FARMANORTE 87','1','10200','10200','10200','0','10200','1','0','0','','30/05/2024','',1300,15200,0,'7702870002636','NOFERTYL AMP *1ML +JGA ','619','ABBOTT FARMA','2024-05-29 20:53:48',  7588, 31651, 223, 99),('FVE','FNVL','022116','2024-05-29 20:53:48','052024','CO','1083006602','SHARON ','SERRANO','',' 3239233116','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','2','15494.117647058823','1005.8823529411766','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:53:48','16500','87','BOD. FARMANORTE 87','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','30/05/2024','',1300,15200,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-29 20:53:48',  3881.5, 56142, 223, 99),('FVE','FNVL','022117','2024-05-29 20:55:33','052024','CO','1002280733','JUAN ','SEBASTIAN','',' 0','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','10','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 20:55:33','3000','87','BOD. FARMANORTE 87','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-29 20:55:33',  28997, 54625, 223, 99),('FVE','FNVL','022118','2024-05-29 21:07:23','052024','CO','1007780614','NELZON','FER','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:07:23','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/05/2024','',2500,0,0,'7702189012579','PAPAS MARGARITA LIMON *30 GR','762','FRITO LAY','2024-05-29 21:07:23',  1594, 36674, 223, 99),('FVE','FNVL','022119','2024-05-29 21:09:05','052024','CO','1221970109','DANIEL ','GONGORA','',' 00','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','9900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:09:05','9900','87','BOD. FARMANORTE 87','1','9900','9900','9900','0','9900','1','0','0','','30/05/2024','',9900,0,0,'4005800254963','DUO LUBRICADO *3 PRESERVATIVOS','123','BDF (BEIERSDORF) ','2024-05-29 21:09:05',  9427.1, 23315, 223, 99),('FVE','FNVL','022120','2024-05-29 21:19:36','052024','CO','118566359','ANDRES','B','0','  00','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','8936.974789915967','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:19:36','9400','87','BOD. FARMANORTE 87','1','6500','6500','6500','0','6500','1','0','0','','30/05/2024','',9400,0,0,'7706569020079','SILDENAFIL 50 MG * 2 TAB MASTICABLES','614','A.G. MEDICAMENTOS','2024-05-29 21:19:36',  4856, 31770, 223, 99),('FVE','FNVL','022120','2024-05-29 21:19:36','052024','CO','118566359','ANDRES','B','0','  00','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','8936.974789915967','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:19:36','9400','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/05/2024','',9400,0,0,'7702007212501','CHOCOLATINA JUMBO MANI *40 GR','816','GRUPO NUTRESA','2024-05-29 21:19:36',  2202.5, 53169, 223, 99),('FVE','FNVL','022121','2024-05-29 21:23:30','052024','CO','1080877995','JULIAN','CASTILLO','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2941.1764705882356','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:23:30','3500','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','30/05/2024','',3500,0,0,'6910021007206','COLGATE CEPILLO PREMIER CLEAN MEDIO','145','COLGATE PALMOLIVE COMPANIA','2024-05-29 21:23:30',  2293.0796, 47117, 223, 99),('FVE','FNVL','022122','2024-05-29 21:24:55','052024','CO','7634360','SERGIO','FORRERO','mza d  casa 16 villa universit',' 3015990786','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','959257','43616615','AGUDELO MARULANDA SANDRA MILENA','','','4','45905.04201680672','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:24:55','46400','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','230','','30/05/2024','',0,46400,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 21:24:55',  100, 44347, 223, 99),('FVE','FNVL','022122','2024-05-29 21:24:55','052024','CO','7634360','SERGIO','FORRERO','mza d  casa 16 villa universit',' 3015990786','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','959257','43616615','AGUDELO MARULANDA SANDRA MILENA','','','4','45905.04201680672','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:24:55','46400','87','BOD. FARMANORTE 87','1','14200','14200','14200','0','14200','1','0','230','','30/05/2024','',0,46400,0,'7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA *60 ML','616','HALEON (GLAXO OTC)','2024-05-29 21:24:55',  12808.3, 54127, 223, 99),('FVE','FNVL','022122','2024-05-29 21:24:55','052024','CO','7634360','SERGIO','FORRERO','mza d  casa 16 villa universit',' 3015990786','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','959257','43616615','AGUDELO MARULANDA SANDRA MILENA','','','4','45905.04201680672','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:24:55','46400','87','BOD. FARMANORTE 87','1','28900','28900','28900','0','28900','1','0','230','15','30/05/2024','',0,46400,0,'7702024025733','KLIM 1+ BOLSA *500 GR','311','NESTLE NUTRICION','2024-05-29 21:24:55',  26210, 38369, 223, 99),('FVE','FNVL','022122','2024-05-29 21:24:55','052024','CO','7634360','SERGIO','FORRERO','mza d  casa 16 villa universit',' 3015990786','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','959257','43616615','AGUDELO MARULANDA SANDRA MILENA','','','4','45905.04201680672','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:24:55','46400','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','230','','30/05/2024','',0,46400,0,'7702090029857','HIT MORA *500 ML','192','POSTOBON GASEOSAS','2024-05-29 21:24:55',  1750.7, 35520, 223, 99),('FVE','FNVL','022123','2024-05-29 21:38:14','052024','CO','20658437','JOSE','FRANCO','NO DIO',' 3005169718','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1642619','8701544','CABRERA PEREZ JULIO CESAR','','','1','16200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:38:14','16200','87','BOD. FARMANORTE 87','1','16200','16200','16200','0','16200','1','0','81','','30/05/2024','',16200,0,0,'7707229971137','ENEMATROL ENEMA RECTAL *133 ML  ','351','QUIBI','2024-05-29 21:38:14',  9420.2, 41539, 223, 99),('FVE','FNVL','022124','2024-05-29 21:45:33','052024','CO','7634360','SERGIO','FORRERO','mza d  casa 16 villa universit',' 3015990786','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','17058.823529411766','3241.176470588234','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:45:34','20300','87','BOD. FARMANORTE 87','1','20300','20300','17058.823529412','3241.1764705882','20300','1','0','85','11','30/05/2024','',0,20300,0,'7613034027610','NESTUM TRIGO MIEL *350 GR','311','NESTLE NUTRICION','2024-05-29 21:45:33',  14240, 38465, 223, 99),('FVE','FNVL','022125','2024-05-29 21:47:09','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','2104282','10022029','AGUDELO ISAZA JHON JAIRO','','','2','16200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:47:09','16200','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','30/05/2024','',16200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 21:47:09',  100, 44347, 223, 99),('FVE','FNVL','022125','2024-05-29 21:47:09','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','2104282','10022029','AGUDELO ISAZA JHON JAIRO','','','2','16200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:47:09','16200','87','BOD. FARMANORTE 87','1','16000','16000','16000','0','16000','1','0','0','','30/05/2024','',16200,0,0,'7703546131308','PRAZED 20 MG * 30 CAP L-CONSUM','630','NOVAMED OTC','2024-05-29 21:47:09',  13493, 38600, 223, 99),('FVE','FNVL','022126','2024-05-29 21:50:11','052024','CO','7437320','MANUEL','ANTEQUERA','',' 3135140409 3222222222','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','6325.210084033613','574.7899159663866','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:50:11','6900','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','30/05/2024','',6900,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 21:50:11',  100, 44347, 223, 99),('FVE','FNVL','022126','2024-05-29 21:50:11','052024','CO','7437320','MANUEL','ANTEQUERA','',' 3135140409 3222222222','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','6325.210084033613','574.7899159663866','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:50:11','6900','87','BOD. FARMANORTE 87','1','3100','3100','3100','0','3100','0','1','0','','30/05/2024','',6900,0,0,'7702057804855','SAL DE FRUTAS LUA PLUS CAJA *22 SOBRES','382','TECNOQUIMICAS','2024-05-29 21:50:11',  48942.14, 61384, 223, 99),('FVE','FNVL','022126','2024-05-29 21:50:11','052024','CO','7437320','MANUEL','ANTEQUERA','',' 3135140409 3222222222','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','6325.210084033613','574.7899159663866','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:50:11','6900','87','BOD. FARMANORTE 87','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','30/05/2024','',6900,0,0,'7702001044504,7','AVENA ALPINA NATURAL *250 GR','110','ALPINA PRODS. ALIMENTICIOS S.A.','2024-05-29 21:50:11',  2318, 22451, 223, 99),('FVE','FNVL','022127','2024-05-29 21:58:24','052024','CO','85461183','LARRIS','MOZO','',' 3017409416','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','5865.546218487395','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:58:24','6600','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',6600,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-29 21:58:24',  800, 48019, 223, 99),('FVE','FNVL','022127','2024-05-29 21:58:24','052024','CO','85461183','LARRIS','MOZO','',' 3017409416','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','5865.546218487395','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 21:58:24','6600','87','BOD. FARMANORTE 87','2','2300','4600','3865.5462184874','734.45378151261','4600','2','0','0','','30/05/2024','',6600,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2024-05-29 21:58:24',  1358, 50688, 223, 99),('FVE','FNVL','022128','2024-05-29 22:08:56','052024','CO','1082834313','ALBERTO','BOLA Ntilde O','',' 3215952995','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:08:56','2900','87','BOD. FARMANORTE 87','1','2900','2900','2900','0','2900','0','1','0','','30/05/2024','',2900,0,0,'7702057160999','NORAVER GRIPA BEBIDA NOCHE *24 SOBRES','382','TECNOQUIMICAS','2024-05-29 22:08:56',  54049.64, 33743, 223, 99),('FVE','FNVL','022129','2024-05-29 22:13:52','052024','CO','1082944216','DARWIN','VIZCAINO','panndo',' 3233226827 3233226827','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','3','21780','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:13:52','21780','87','BOD. FARMANORTE 87','3','7260','21780','21780','0','21780','0','3','109','','30/05/2024','',21780,0,0,'7707019332124','CINDIMIZOL 200 MG *5 CAP','130','LABQUIFAR PHARMACEUTICA','2024-05-29 22:13:52',  6470, 27599, 223, 99),('FVE','FNVL','022130','2024-05-29 22:18:18','052024','CO','1118568206','JHONJAIRO','MARTINEZ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','558800','22500328','ARELLANA BUCAR ZAIDA','','','5','8500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:18:18','8500','87','BOD. FARMANORTE 87','5','1700','8500','8500','0','8500','0','5','0','','30/05/2024','',8500,0,0,'7707019402100','ESPASMYDOL *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-29 22:18:18',  15690, 23565, 223, 99),('FVE','FNVL','022131','2024-05-29 22:22:08','052024','CO','85152687','JAIR ','ARIAS','',' 00','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','9100','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:22:09','9100','87','BOD. FARMANORTE 87','1','9100','9100','9100','0','9100','1','0','0','','30/05/2024','',0,9100,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-05-29 22:22:08',  8329, 52291, 223, 99),('FVE','FNVL','022132','2024-05-29 22:23:18','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','1764.7058823529412','335.2941176470588','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:23:18','2100','87','BOD. FARMANORTE 87','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','30/05/2024','',2100,0,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2024-05-29 22:23:18',  999.61, 55601, 223, 99),('FVE','FNVL','022133','2024-05-29 22:45:30','052024','CO','32864705','MARVI','GUERRERA','mz b casa 11 villa marbella',' 3002023648','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1832644','71740027','ALCARAZ CARTAGENA VICTOR HUGO','','','1','31500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:45:30','31500','87','BOD. FARMANORTE 87','1','31500','31500','31500','0','31500','1','0','158','','30/05/2024','',0,31500,0,'7707263007755','CLINDABACT 100/100MG  X 3 OVULOS /D20/','387','TRIDEX FARMACEUTICA','2024-05-29 22:45:30',  22800, 59529, 223, 99),('FVE','FNVL','022134','2024-05-29 22:49:10','052024','CO','1083018864','KAREN','MENDOZA','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1001491469','1065647882','CLAVIJO DURAN JUAN CARLOS','','','5','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:49:11','7000','87','BOD. FARMANORTE 87','3','1200','3600','3600','0','3600','0','3','0','','30/05/2024','',7000,0,0,'7703153007102','METRONIDAZOL 500 MG *10 OVULOS','422','COLMED','2024-05-29 22:49:10',  13900.7, 39832, 223, 99),('FVE','FNVL','022134','2024-05-29 22:49:10','052024','CO','1083018864','KAREN','MENDOZA','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1001491469','1065647882','CLAVIJO DURAN JUAN CARLOS','','','5','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 22:49:11','7000','87','BOD. FARMANORTE 87','2','1700','3400','3400','0','3400','0','2','0','','30/05/2024','',7000,0,0,'7707019402100','ESPASMYDOL *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-29 22:49:10',  15690, 23565, 223, 99),('FVE','FNVL','022135','2024-05-29 23:07:27','052024','CO','1082836352','MANUEL ','RODRIGUEZ ','3','00 3044807828 3044807828','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','4','7200.8403361344535','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 23:07:27','7600','87','BOD. FARMANORTE 87','3','1700','5100','5100','0','5100','0','3','0','','30/05/2024','',7600,0,0,'7707019402100','ESPASMYDOL *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-29 23:07:27',  15690, 23565, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FNVL','022136','2024-05-29 23:44:09','052024','CO','1081823920','YEISON','VILLAREAL','',' 3017431828','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','4','2400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 23:44:09','2400','87','BOD. FARMANORTE 87','4','600','2400','2400','0','2400','0','4','0','','30/05/2024','',2400,0,0,'7702184560020','PASEDOL 50MG *100 TAB','249','ECAR','2024-05-29 23:44:09',  23625, 29755, 223, 99),('FVE','FNVL','022137','2024-05-29 23:54:49','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','5294.117647058823','1005.8823529411766','87','FARMANORTE 87','ADMINISTRADOR','2024-05-29 23:54:49','6300','87','BOD. FARMANORTE 87','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','30/05/2024','',6300,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-29 23:54:49',  3881.5, 56142, 223, 99),('FVE','FNVL','022138','2024-05-30 00:01:21','052024','CO','30284788','GABRIELA ','PINO','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','11','13400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 00:01:21','13400','87','BOD. FARMANORTE 87','1','8900','8900','8900','0','8900','1','0','0','','30/05/2024','',0,13400,0,'7501125149221','ELECTROLIT FRESA-KIWI SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-30 00:01:21',  6785, 33981, 223, 99),('FVE','FNVL','022138','2024-05-30 00:01:21','052024','CO','30284788','GABRIELA ','PINO','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','11','13400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 00:01:21','13400','87','BOD. FARMANORTE 87','10','450','4500','4500','0','4500','0','10','0','','30/05/2024','',0,13400,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-05-30 00:01:21',  13144, 31502, 223, 99),('FVE','FNVL','022139','2024-05-30 00:14:52','052024','CO','85449185','MOISES','REDONDO','',' 000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','2104282','10022029','AGUDELO ISAZA JHON JAIRO','','','1','6900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 00:14:52','6900','87','BOD. FARMANORTE 87','1','6900','6900','6900','0','6900','1','0','0','','30/05/2024','',6900,0,0,'7706569000415','LORATADINA 10MG *20 TAB','614','A.G. MEDICAMENTOS','2024-05-30 00:14:52',  5340, 31562, 223, 99),('FVE','FNVL','022140','2024-05-30 00:36:35','052024','CO','1007780619','AMILCAR','ORO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','11008.403361344539','2091.596638655461','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 00:36:35','13100','87','BOD. FARMANORTE 87','1','7900','7900','6638.6554621849','1261.3445378151','7900','1','0','0','','30/05/2024','',13100,0,0,'7702057645595','COPITOS PAGUE 50 LLEVE 80 UND','624','TECNOQUIMICAS CUIDADO DE HERIDA','2024-05-30 00:36:35',  5379.9, 54712, 223, 99),('FVE','FNVL','022140','2024-05-30 00:36:35','052024','CO','1007780619','AMILCAR','ORO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','11008.403361344539','2091.596638655461','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 00:36:35','13100','87','BOD. FARMANORTE 87','1','5200','5200','4369.7478991597','830.25210084034','5200','1','0','0','','30/05/2024','',13100,0,0,'7702010421006','PROTEX JABON HERBAL *110 GR','145','COLGATE PALMOLIVE COMPANIA','2024-05-30 00:36:35',  2300.23, 52311, 223, 99),('FVE','FNVL','022141','2024-05-30 00:43:36','052024','CO','1007780613','LIRENA ','MORENO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','3400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 00:43:36','3400','87','BOD. FARMANORTE 87','1','3400','3400','3400','0','3400','0','1','0','','30/05/2024','',3400,0,0,'7702057841256','BONFIEST PLUS *32 SOBRES','382','TECNOQUIMICAS','2024-05-30 00:43:36',  87257.22, 43283, 223, 99),('FVE','FNVL','022142','2024-05-30 01:07:50','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 01:07:50','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 01:07:50',  800, 48019, 223, 99),('FVE','FNVL','022143','2024-05-30 01:17:37','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','1512.6050420168067','287.3949579831933','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 01:17:37','1800','87','BOD. FARMANORTE 87','2','900','1800','1512.6050420168','287.39495798319','1800','2','0','0','','30/05/2024','',1800,0,0,'7702025133161','DUCALES GALLETAS * 3 ','816','GRUPO NUTRESA','2024-05-30 01:17:37',  510.1111, 53730, 223, 99),('FVE','FNVL','022144','2024-05-30 01:19:04','052024','CO','1007780613','LIRENA ','MORENO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 01:19:04','3100','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/05/2024','',3100,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2024-05-30 01:19:04',  1956.4, 34397, 223, 99),('FVE','FNVL','022145','2024-05-30 01:33:29','052024','CO','100780614','CLARA ','RANJEL','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 01:33:29','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 01:33:29',  800, 48019, 223, 99),('FVE','FNVL','022146','2024-05-30 01:58:10','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 01:58:10','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 01:58:10',  800, 48019, 223, 99),('FVE','FNVL','022147','2024-05-30 02:12:44','052024','CO','1007780615','PEDRO ','FUENTE ','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 02:12:45','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 02:12:44',  800, 48019, 223, 99),('FVE','FNVL','022148','2024-05-30 02:22:08','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','3800','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 02:22:08','3800','87','BOD. FARMANORTE 87','1','3800','3800','3800','0','3800','1','0','0','','30/05/2024','',3800,0,0,'7702560026577','ALCOHOL JGB *120 ML','219','JGB','2024-05-30 02:22:08',  2529, 27762, 223, 99),('FVE','FNVL','022149','2024-05-30 02:24:15','052024','CO','1007780619','AMILCAR','ORO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','8700','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 02:24:16','8700','87','BOD. FARMANORTE 87','2','3000','6000','6000','0','6000','0','2','0','','30/05/2024','',8700,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2024-05-30 02:24:15',  27350, 46776, 223, 99),('FVE','FNVL','022149','2024-05-30 02:24:15','052024','CO','1007780619','AMILCAR','ORO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','8700','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 02:24:16','8700','87','BOD. FARMANORTE 87','1','2700','2700','2700','0','2700','1','0','0','','30/05/2024','',8700,0,0,'7702090020847','GASEOSA BRETANA *300 ML','192','POSTOBON GASEOSAS','2024-05-30 02:24:15',  1657.5, 35287, 223, 99),('FVE','FNVL','022150','2024-05-30 02:52:21','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','4000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 02:52:22','4000','87','BOD. FARMANORTE 87','2','2000','4000','4000','0','4000','2','0','0','','30/05/2024','',4000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 02:52:21',  800, 48019, 223, 99),('FVE','FNVL','022151','2024-05-30 04:08:25','052024','CO','1007780612','ANDRES','FUENTE ','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','4000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 04:08:26','4000','87','BOD. FARMANORTE 87','2','2000','4000','4000','0','4000','2','0','0','','30/05/2024','',4000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 04:08:25',  800, 48019, 223, 99),('FVE','FNVL','022152','2024-05-30 04:55:21','052024','CO','1007780615','PEDRO ','FUENTE ','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','10','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 04:55:21','3000','87','BOD. FARMANORTE 87','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-30 04:55:21',  28997, 54625, 223, 99),('FVE','FNVL','022153','2024-05-30 05:55:05','052024','CO','12555906','RAFAEL','SANCHEZ','',' NO DIO','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','9000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 05:55:05','9000','87','BOD. FARMANORTE 87','5','1800','9000','9000','0','9000','0','5','0','','30/05/2024','',9000,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-30 05:55:05',  111600, 43550, 223, 99),('FVE','FNVL','022154','2024-05-30 06:03:27','052024','CO','1007780618','MARCELA ','PEREA','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 06:03:28','4000','87','BOD. FARMANORTE 87','2','2000','4000','3361.3445378151','638.65546218487','4000','2','0','0','','30/05/2024','',4000,0,0,'7707228360253','GUANTE CIRUGIA ESTERIL T/8','429','ALFA SAFE','2024-05-30 06:03:27',  1375, 62082, 223, 99),('FVE','FNVL','022155','2024-05-30 06:11:39','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 06:11:40','500','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/05/2024','',500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-30 06:11:39',  9360, 46328, 223, 99),('FVE','FNVL','022156','2024-05-30 06:37:01','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','1260.5042016806724','239.4957983193276','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 06:37:01','1500','87','BOD. FARMANORTE 87','3','500','1500','1260.5042016807','239.49579831933','1500','0','3','0','','30/05/2024','',1500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-30 06:37:01',  9360, 46328, 223, 99),('FVE','FNVL','022157','2024-05-30 06:39:35','052024','CO','1082834832','CRISTAL ','RANJEL','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','10000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 06:39:35','10000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','30/05/2024','',10000,0,0,'7707282990953','PRUEBA DE EMBARAZO CASSETTE','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 06:39:35',  1400, 58459, 223, 99),('FVE','FNVL','022157','2024-05-30 06:39:35','052024','CO','1082834832','CRISTAL ','RANJEL','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','10000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 06:39:35','10000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',10000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 06:39:35',  800, 48019, 223, 99),('FVE','FNVL','022158','2024-05-30 07:28:39','052024','CO','1004501029','MAURICIO','ARGUMEDO','',' 3157085604','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','6','23193.27731092437','4406.722689075628','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 07:28:39','27600','87','BOD. FARMANORTE 87','6','4600','27600','23193.277310924','4406.7226890756','27600','6','0','0','','30/05/2024','',0,27600,0,'7702090038095','JUGO HIT FRUTAS TROPICALES *1 LT','192','POSTOBON GASEOSAS','2024-05-30 07:28:39',  2850.42, 54008, 223, 99),('FVE','FNVL','022159','2024-05-30 07:55:09','052024','CO','1083008513','LAURA ','BOD','',' 3222222222','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','7500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 07:55:09','7500','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','30/05/2024','',7500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 07:55:09',  100, 44347, 223, 99),('FVE','FNVL','022159','2024-05-30 07:55:09','052024','CO','1083008513','LAURA ','BOD','',' 3222222222','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','7500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 07:55:09','7500','87','BOD. FARMANORTE 87','1','7300','7300','7300','0','7300','1','0','0','','30/05/2024','',7500,0,0,'7707228362158','CINTA MICROPOROSA PIEL ALFASAFE 1 X 5 YD','429','ALFA SAFE','2024-05-30 07:55:09',  4428, 60551, 223, 99),('FVE','FNVL','022160','2024-05-30 08:08:20','052024','CO','1082893276','MARIO ','PERTUS','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','10','5000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 08:08:21','5000','87','BOD. FARMANORTE 87','10','500','5000','5000','0','5000','0','10','0','','30/05/2024','',5000,0,0,'7707019337105','MEXICAN 7.5 MG * 30 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-30 08:08:20',  6040, 23590, 223, 99),('FVE','FNVL','022161','2024-05-30 08:09:11','052024','CO','1083020344','LAURA','VALLAR','KRA21A CALLE 29K 5-31',' 3023205260  3023205260  3023205260 ','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','3','12300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 08:09:12','12300','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','30/05/2024','',12300,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 08:09:11',  100, 44347, 223, 99),('FVE','FNVL','022161','2024-05-30 08:09:11','052024','CO','1083020344','LAURA','VALLAR','KRA21A CALLE 29K 5-31',' 3023205260  3023205260  3023205260 ','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','3','12300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 08:09:12','12300','87','BOD. FARMANORTE 87','1','10100','10100','10100','0','10100','1','0','0','','30/05/2024','',12300,0,0,'7703186028938','PEDIASURE LIQUIDO VAINILLA *220 ML','659','ABBOTT NUTRICION','2024-05-30 08:09:11',  9020, 22283, 223, 99),('FVE','FNVL','022161','2024-05-30 08:09:11','052024','CO','1083020344','LAURA','VALLAR','KRA21A CALLE 29K 5-31',' 3023205260  3023205260  3023205260 ','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','3','12300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 08:09:12','12300','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',12300,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 08:09:11',  1500, 44348, 223, 99),('FVE','FNVL','022163','2024-05-30 08:09:12','052024','CR','1221978376','JEISON DARIO ','NORE ntilde A FERN aacute NDEZ ','CALLE 18 NO.36-57',' 3006278000','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','851608','2','7731.09243697479','1468.90756302521','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 08:53:18','9200','87','BOD. FARMANORTE 87','2','4600','9200','7731.0924369748','1468.9075630252','9200','2','0','0','','30/05/2024','',0,0,9200,'7702090038071','JUGO HIT MANGO *1 LT','192','POSTOBON GASEOSAS','2024-05-30 08:09:12',  2850.42, 53815, 223, 99),('FVE','FNVL','022162','2024-05-30 08:51:50','052024','CO','1083020344','LAURA','VALLAR','KRA21A CALLE 29K 5-31',' 3023205260  3023205260  3023205260 ','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','2','12100','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 08:51:50','12100','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','1','','30/05/2024','',12100,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 08:51:50',  1500, 44348, 223, 99),('FVE','FNVL','022162','2024-05-30 08:51:50','052024','CO','1083020344','LAURA','VALLAR','KRA21A CALLE 29K 5-31',' 3023205260  3023205260  3023205260 ','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','2','12100','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 08:51:50','12100','87','BOD. FARMANORTE 87','1','10100','10100','10100','0','10100','1','0','1','','30/05/2024','',12100,0,0,'7703186028938','PEDIASURE LIQUIDO VAINILLA *220 ML','659','ABBOTT NUTRICION','2024-05-30 08:51:50',  9020, 22283, 223, 99),('FVE','FNVL','022164','2024-05-30 09:09:07','052024','CO','5162264','GERARDO','CUELLO','',' 0 ','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','3445.378151260504','654.6218487394958','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 09:09:07','4100','87','BOD. FARMANORTE 87','1','4100','4100','3445.3781512605','654.6218487395','4100','1','0','0','','30/05/2024','',4100,0,0,'7702026174675','TENA PANTS CLASICO M X 1 UND','337','FAMILIA SANCELA','2024-05-30 09:09:07',  3100, 51916, 223, 99),('FVE','FNVL','022165','2024-05-30 09:45:56','052024','CO','1082949794','MAR iacute A ALEJANDRA ','SAUCEDO GONZ aacute LEZ ','kra 21a n 29g-64 los faroles',' 3012866025','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','7','12429.546218487394','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 09:45:57','13164','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','62','','30/05/2024','',13164,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 09:45:56',  100, 44347, 223, 99),('FVE','FNVL','022165','2024-05-30 09:45:56','052024','CO','1082949794','MAR iacute A ALEJANDRA ','SAUCEDO GONZ aacute LEZ ','kra 21a n 29g-64 los faroles',' 3012866025','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','7','12429.546218487394','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 09:45:57','13164','87','BOD. FARMANORTE 87','1','2500','2500','2500','0','2500','0','1','62','','30/05/2024','',13164,0,0,'7709080992504','LYPTUS MIEL MENTOL CJA * 24 SOBRES','1000','NATURALMENTE','2024-05-30 09:45:56',  17000, 63438, 223, 99),('FVE','FNVL','022165','2024-05-30 09:45:56','052024','CO','1082949794','MAR iacute A ALEJANDRA ','SAUCEDO GONZ aacute LEZ ','kra 21a n 29g-64 los faroles',' 3012866025','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','7','12429.546218487394','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 09:45:57','13164','87','BOD. FARMANORTE 87','4','1466','5864','5864','0','5864','0','4','62','','30/05/2024','',13164,0,0,'7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2024-05-30 09:45:56',  66736, 55304, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FNVL','022166','2024-05-30 09:57:51','052024','CO','1004319301','YELIZA','TOREJANO ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','12048.73949579832','2251.2605042016803','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 09:57:51','14300','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','1','','30/05/2024','',0,14300,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 09:57:51',  100, 44347, 223, 99),('FVE','FNVL','022166','2024-05-30 09:57:51','052024','CO','1004319301','YELIZA','TOREJANO ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','12048.73949579832','2251.2605042016803','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 09:57:51','14300','87','BOD. FARMANORTE 87','1','14100','14100','11848.739495798','2251.2605042017','14100','1','0','1','','30/05/2024','',0,14300,0,'4005800137655','NIVEA CREMA *30 GR','123','BDF (BEIERSDORF) ','2024-05-30 09:57:51',  9002.9, 23201, 223, 99),('FVE','FNVL','022167','2024-05-30 10:12:36','052024','CO','39144184','DIANA','PEREZ ','CAR 21 C2 NUME29G1 -27 VILA  B','  3226650741','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','2','18300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 10:12:36','18300','87','BOD. FARMANORTE 87','1','16300','16300','16300','0','16300','1','0','92','10','30/05/2024','',18300,0,0,'7702057074456','IRBESARTAN 300 MG *14 TAB MK','654','MK ETICOS CONVENIO','2024-05-30 10:12:36',  15500, 43078, 223, 99),('FVE','FNVL','022167','2024-05-30 10:12:36','052024','CO','39144184','DIANA','PEREZ ','CAR 21 C2 NUME29G1 -27 VILA  B','  3226650741','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','2','18300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 10:12:36','18300','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','92','','30/05/2024','',18300,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 10:12:36',  1500, 44348, 223, 99),('FVE','FNVL','022168','2024-05-30 10:14:42','052024','CO','7141421','FERNANDO','GUTIERREZ','',' NO 3042154789','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','6300','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 10:14:43','6300','87','BOD. FARMANORTE 87','1','6300','6300','6300','0','6300','1','0','0','','30/05/2024','',6300,0,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2024-05-30 10:14:42',  4500, 48626, 223, 99),('FVE','FNVL','022169','2024-05-30 12:08:55','052024','CO','1081793410','DAVID','MAESTRE','',' 3012366796','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','4','5880.672268907563','319.3277310924368','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:08:55','6200','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','30/05/2024','',6200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 12:08:55',  100, 44347, 223, 99),('FVE','FNVL','022169','2024-05-30 12:08:55','052024','CO','1081793410','DAVID','MAESTRE','',' 3012366796','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','4','5880.672268907563','319.3277310924368','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:08:55','6200','87','BOD. FARMANORTE 87','1','4000','4000','4000','0','4000','1','0','0','','30/05/2024','',6200,0,0,'7707141349304','CLORURO DE SODIO S.S. 9% *500 ML  ','235','BAXTER','2024-05-30 12:08:55',  1740, 28628, 223, 99),('FVE','FNVL','022169','2024-05-30 12:08:55','052024','CO','1081793410','DAVID','MAESTRE','',' 3012366796','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','4','5880.672268907563','319.3277310924368','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:08:55','6200','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','30/05/2024','',6200,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-05-30 12:08:55',  255, 46100, 223, 99),('FVE','FNVL','022169','2024-05-30 12:08:55','052024','CO','1081793410','DAVID','MAESTRE','',' 3012366796','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','4','5880.672268907563','319.3277310924368','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:08:55','6200','87','BOD. FARMANORTE 87','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','30/05/2024','',6200,0,0,'7705326079022','SUBMARINO MARINELA AREQUIPE *33 GR','126','BIMBO DE COLOMBIA S.A.','2024-05-30 12:08:55',  871, 57121, 223, 99),('FVE','FNVL','022170','2024-05-30 12:17:03','052024','CO','1083046552','MARIA FERNANDA','CHACON','',' NO DIO','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','2900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:17:03','2900','87','BOD. FARMANORTE 87','1','2900','2900','2900','0','2900','0','1','0','','30/05/2024','',2900,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-05-30 12:17:03',  18581.4, 46200, 223, 99),('FVE','FNVL','022171','2024-05-30 12:45:41','052024','CO','1082939368','DUVAN','DURAN','00',' 3008923996','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','9579.83193277311','1820.1680672268903','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:45:41','11400','87','BOD. FARMANORTE 87','1','11400','11400','9579.8319327731','1820.1680672269','11400','1','0','48','','30/05/2024','',11400,0,0,'7702031563327','LISTERINE ZERO COOL MINT MENTA SUAVE *180 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-05-30 12:45:41',  7553, 28062, 223, 99),('FVE','FNVL','022172','2024-05-30 12:54:17','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:54:17','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 12:54:17',  800, 48019, 223, 99),('FVE','FNVL','022173','2024-05-30 12:57:58','052024','CO','900319786',' A 2001 ','REPRESENTACIONS.A.S','',' 0','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','5400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 12:57:59','5400','87','BOD. FARMANORTE 87','3','1800','5400','5400','0','5400','0','3','0','','30/05/2024','',0,5400,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-30 12:57:58',  111600, 43550, 223, 99),('FVE','FNVL','022174','2024-05-30 13:41:24','052024','CO','1082897103','JOSE ','ZAPATA','',' 00','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','2','3865.546218487395','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 13:41:25','4600','87','BOD. FARMANORTE 87','2','2300','4600','3865.5462184874','734.45378151261','4600','2','0','0','','30/05/2024','',4600,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2024-05-30 13:41:24',  1358, 50688, 223, 99),('FVE','FNVL','022175','2024-05-30 13:44:22','052024','CO','1081000256','MARIA','CASTRO','',' 0','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','10','4500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 13:44:22','4500','87','BOD. FARMANORTE 87','10','450','4500','4500','0','4500','0','10','0','','30/05/2024','',0,4500,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-05-30 13:44:22',  13144, 31502, 223, 99),('FVE','FNVL','022176','2024-05-30 13:54:55','052024','CO','85380092','FREDI','ROMERO','bgvhfdty',' 3015869432','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','3','148500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 13:54:55','148500','87','BOD. FARMANORTE 87','3','49500','148500','148500','0','148500','3','0','743','','30/05/2024','',148500,0,0,'7501082242010','CIALIS 20 MG *1 COMP','173','ELI LILLY INTERAMERICA INC','2024-05-30 13:54:55',  30978, 25299, 223, 99),('FVE','FNVL','022177','2024-05-30 14:20:33','052024','CO','1083038403','YEINER ALFONSO ','CASSIANI YANEZ ','no dio',' 3136237625','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','1137006','12540152','LACERA GARCIA DEVIS ALONSO','','','1','34900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 14:20:34','34900','87','BOD. FARMANORTE 87','1','34900','34900','34900','0','34900','1','0','175','','30/05/2024','',34900,0,0,'7703546191807','NEUMOLEX SUSP * 120 ML  L-RESPI-ASM','314','NOVAMED FARMA','2024-05-30 14:20:33',  30191, 38596, 223, 99),('FVE','FNVL','022178','2024-05-30 14:40:44','052024','CO','1083552960','AMALIA FER','FERNANDEZ','URB VILLA MARBELLA Mz G CASA 1',' 3165379113','3164','ARELIS ESTHER','VARGAS GALLARDO ','3256','LEIDER MANUEL','PUA NAVARRO','571170','57435943','CANTILLO TINOCO ELIANA EUGENIA','','','3','54600','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 14:40:44','54600','87','BOD. FARMANORTE 87','2','26300','52600','52600','0','52600','0','2','0','','30/05/2024','',600,54000,0,'D1012','PULMICORT 0.5 MG *5 RESPULES','117','ASTRAZENECA COLOMBIA','2024-05-30 14:40:44',  112621, 22772, 223, 99),('FVE','FNVL','022178','2024-05-30 14:40:44','052024','CO','1083552960','AMALIA FER','FERNANDEZ','URB VILLA MARBELLA Mz G CASA 1',' 3165379113','3164','ARELIS ESTHER','VARGAS GALLARDO ','3256','LEIDER MANUEL','PUA NAVARRO','571170','57435943','CANTILLO TINOCO ELIANA EUGENIA','','','3','54600','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 14:40:44','54600','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',600,54000,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 14:40:44',  1500, 44348, 223, 99),('FVE','FNVL','022179','2024-05-30 15:18:12','052024','CO','57427433','LORENA ','MONTES','Kra 21 a2 # 29f 91 los faroles',' 3145956854','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','571503','85454829','PALACIO PALACIO RICARDO JOSE','','','2','15800','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:18:12','15800','87','BOD. FARMANORTE 87','1','13800','13800','13800','0','13800','1','0','79','','30/05/2024','',15800,0,0,'7702057078799','QUETIAPINA 25 MG *30 TAB MK','654','MK ETICOS CONVENIO','2024-05-30 15:18:12',  10974.7, 43266, 223, 99),('FVE','FNVL','022179','2024-05-30 15:18:12','052024','CO','57427433','LORENA ','MONTES','Kra 21 a2 # 29f 91 los faroles',' 3145956854','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','571503','85454829','PALACIO PALACIO RICARDO JOSE','','','2','15800','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:18:12','15800','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','79','','30/05/2024','',15800,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 15:18:12',  1500, 44348, 223, 99),('FVE','FNVL','022180','2024-05-30 15:24:30','052024','CO','1083552960','AMALIA FER','FERNANDEZ','URB VILLA MARBELLA Mz G CASA 1',' 3165379113','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','6','16789.915966386554','2810.0840336134456','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:24:30','19600','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',0,19600,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 15:24:30',  1500, 44348, 223, 99),('FVE','FNVL','022180','2024-05-30 15:24:30','052024','CO','1083552960','AMALIA FER','FERNANDEZ','URB VILLA MARBELLA Mz G CASA 1',' 3165379113','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','6','16789.915966386554','2810.0840336134456','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:24:30','19600','87','BOD. FARMANORTE 87','1','5500','5500','4621.8487394958','878.1512605042','5500','1','0','0','','30/05/2024','',0,19600,0,'7707336090882','KIT MICRONEBULIZADOR PEDIATRICO  ZIBOJET','398','ZIBOJECT','2024-05-30 15:24:30',  2400, 44346, 223, 99),('FVE','FNVL','022180','2024-05-30 15:24:30','052024','CO','1083552960','AMALIA FER','FERNANDEZ','URB VILLA MARBELLA Mz G CASA 1',' 3165379113','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','6','16789.915966386554','2810.0840336134456','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:24:30','19600','87','BOD. FARMANORTE 87','1','10600','10600','8907.5630252101','1692.4369747899','10600','1','0','0','','30/05/2024','',0,19600,0,'7702535024447','COCA COLA *3 LT','144','COCA COLA','2024-05-30 15:24:30',  6260.5, 56143, 223, 99),('FVE','FNVL','022180','2024-05-30 15:24:30','052024','CO','1083552960','AMALIA FER','FERNANDEZ','URB VILLA MARBELLA Mz G CASA 1',' 3165379113','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','6','16789.915966386554','2810.0840336134456','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:24:30','19600','87','BOD. FARMANORTE 87','3','500','1500','1260.5042016807','239.49579831933','1500','0','3','0','','30/05/2024','',0,19600,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-30 15:24:30',  9360, 46328, 223, 99),('FVE','FNVL','022181','2024-05-30 15:25:22','052024','CO','38290687','AMALIA','TOVAR','',' 00','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','2','9200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:25:22','9200','87','BOD. FARMANORTE 87','2','4600','9200','9200','0','9200','0','2','0','','30/05/2024','',9200,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 15:25:22',  27780, 54056, 223, 99),('FVE','FNVL','022182','2024-05-30 15:41:41','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','4600','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 15:41:42','4600','87','BOD. FARMANORTE 87','1','4600','4600','4600','0','4600','0','1','23','','30/05/2024','',4600,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 15:41:41',  27780, 54056, 223, 99),('FVE','FNVL','022183','2024-05-30 16:23:59','052024','CO','26694584','CANDELARIA','SIMANCA ','KRA 21B N 29D3  CASA 4 ESQUINA',' 3046107929','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','571578','12546467','ROBLES SOLANO CESAR ELIAS','','','2','16000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:24:00','16000','87','BOD. FARMANORTE 87','1','14000','14000','14000','0','14000','1','0','80','','30/05/2024','',16000,0,0,'7709225183057','NOVOXICAN 15MG *10 TAB','873','NOVOFAR','2024-05-30 16:23:59',  2270, 58552, 223, 99),('FVE','FNVL','022183','2024-05-30 16:23:59','052024','CO','26694584','CANDELARIA','SIMANCA ','KRA 21B N 29D3  CASA 4 ESQUINA',' 3046107929','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','571578','12546467','ROBLES SOLANO CESAR ELIAS','','','2','16000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:24:00','16000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','80','','30/05/2024','',16000,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 16:23:59',  1500, 44348, 223, 99),('FVE','FNVL','022184','2024-05-30 16:37:50','052024','CO','1083572271','KEVIN ','TORREGROSA ','',' 10','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','5','5400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:37:50','5400','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','30/05/2024','',5400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 16:37:50',  100, 44347, 223, 99),('FVE','FNVL','022184','2024-05-30 16:37:50','052024','CO','1083572271','KEVIN ','TORREGROSA ','',' 10','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','5','5400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:37:50','5400','87','BOD. FARMANORTE 87','4','1300','5200','5200','0','5200','0','4','0','','30/05/2024','',5400,0,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-30 16:37:50',  114652, 26533, 223, 99),('FVE','FNVL','022185','2024-05-30 16:49:00','052024','CO','1082876001','CAMILO ANDRES ','LOPEZ ESCOBAR ','',' 3022712570','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','2689.075630252101','510.92436974789916','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:49:01','3200','87','BOD. FARMANORTE 87','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','13','','30/05/2024','',3200,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-05-30 16:49:00',  1806, 56307, 223, 99),('FVE','FNVL','022186','2024-05-30 16:55:28','052024','CO','1085229616','JUAN ','ARRIETA','',' 0 ','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','5','11500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:55:29','11500','87','BOD. FARMANORTE 87','5','2300','11500','11500','0','11500','0','5','0','','30/05/2024','',11500,0,0,'7702123006947','APRONAX 275 MG *50 CAP','631','BAYER OTC','2024-05-30 16:55:28',  93020, 22870, 223, 99),('FVE','FNVL','022187','2024-05-30 16:59:37','052024','CO','26690778','ELVIA ESTHER','RODRIGUEZ','mza c casa 39  villa marbella',' 3015209210','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','19104.201680672268','1995.7983193277305','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:59:37','21100','87','BOD. FARMANORTE 87','2','4300','8600','8600','0','8600','2','0','0','','30/05/2024','',21100,0,0,'7702605102044','OMEPRAZOL 20 MG * 10 CAP','193','GENFAR','2024-05-30 16:59:37',  2863, 26149, 223, 99),('FVE','FNVL','022187','2024-05-30 16:59:37','052024','CO','26690778','ELVIA ESTHER','RODRIGUEZ','mza c casa 39  villa marbella',' 3015209210','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','19104.201680672268','1995.7983193277305','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 16:59:37','21100','87','BOD. FARMANORTE 87','1','12500','12500','10504.201680672','1995.7983193277','12500','1','0','0','','30/05/2024','',21100,0,0,'7702113017922','TINTE COLORISS KIT NEGRO NATURAL 1-0','278','RECAMIER','2024-05-30 16:59:37',  6961.5, 30757, 223, 99),('FVE','FNVL','022188','2024-05-30 17:05:20','052024','CO','1005626167','GABRIELA ','SUARES ','VILLA MARBELLA  MANZA 0 CASA 3','  3215934019','2718','YERIKA','CUDRIZ PéREZ ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','12','14200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:05:20','14200','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','30/05/2024','',14200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 17:05:20',  100, 44347, 223, 99),('FVE','FNVL','022188','2024-05-30 17:05:20','052024','CO','1005626167','GABRIELA ','SUARES ','VILLA MARBELLA  MANZA 0 CASA 3','  3215934019','2718','YERIKA','CUDRIZ PéREZ ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','12','14200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:05:20','14200','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',14200,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 17:05:20',  1500, 44348, 223, 99),('FVE','FNVL','022188','2024-05-30 17:05:20','052024','CO','1005626167','GABRIELA ','SUARES ','VILLA MARBELLA  MANZA 0 CASA 3','  3215934019','2718','YERIKA','CUDRIZ PéREZ ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','12','14200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:05:20','14200','87','BOD. FARMANORTE 87','10','1200','12000','12000','0','12000','0','10','0','','30/05/2024','',14200,0,0,'7707019402117','COLESPAS 10 MG CJA *30 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-30 17:05:20',  11800, 53948, 223, 99),('FVE','FNVL','022189','2024-05-30 17:05:23','052024','CO','12448735','JUNIOR','CABRERA','',' NO DIO','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','11','19349.579831932773','750.4201680672268','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:05:23','20100','87','BOD. FARMANORTE 87','1','15400','15400','15400','0','15400','1','0','0','','30/05/2024','',20100,0,0,'7707019401950','FIREXIFEN JARABE *120 ML','130','LABQUIFAR PHARMACEUTICA','2024-05-30 17:05:23',  7700, 45885, 223, 99),('FVE','FNVL','022189','2024-05-30 17:05:23','052024','CO','12448735','JUNIOR','CABRERA','',' NO DIO','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','11','19349.579831932773','750.4201680672268','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:05:23','20100','87','BOD. FARMANORTE 87','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','30/05/2024','',20100,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-30 17:05:23',  15435, 56535, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FNVL','022190','2024-05-30 17:22:11','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','5','10620.168067226892','1979.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:22:11','12600.000000000002','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','53','','30/05/2024','',12600,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-05-30 17:22:11',  1768.4, 60339, 223, 99),('FVE','FNVL','022190','2024-05-30 17:22:11','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','5','10620.168067226892','1979.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:22:11','12600.000000000002','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','53','','30/05/2024','',12600,0,0,'7702402056304','GALLETA CON HELADO VAINILLA PASAS *65 GR','296','MEALS DE COLOMBIA','2024-05-30 17:22:11',  1768.403, 60390, 223, 99),('FVE','FNVL','022190','2024-05-30 17:22:11','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','5','10620.168067226892','1979.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:22:11','12600.000000000002','87','BOD. FARMANORTE 87','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','53','','30/05/2024','',12600,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-05-30 17:22:11',  1806, 56307, 223, 99),('FVE','FNVL','022190','2024-05-30 17:22:11','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','5','10620.168067226892','1979.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:22:11','12600.000000000002','87','BOD. FARMANORTE 87','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','53','','30/05/2024','',12600,0,0,'7702402054409','HELADO ARTESANAL DULCE DE MORAS *70 GR','296','MEALS DE COLOMBIA','2024-05-30 17:22:11',  1782, 56354, 223, 99),('FVE','FNVL','022191','2024-05-30 17:45:28','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','1680.6722689075632','319.3277310924368','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:45:28','2000','87','BOD. FARMANORTE 87','1','2000','2000','1680.6722689076','319.32773109244','2000','1','0','0','','30/05/2024','',2000,0,0,'7707228360239','GUANTE CIRUGIA ESTERIL T/7','429','ALFA SAFE','2024-05-30 17:45:28',  1375, 62083, 223, 99),('FVE','FNVL','022192','2024-05-30 17:50:43','052024','CO','57434793','ERICA','ALVAREZ','',' NO DIO','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','2','111800','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:50:43','111800','87','BOD. FARMANORTE 87','2','55900','111800','111800','0','111800','2','0','0','','30/05/2024','',111800,0,0,'7703186976314','PEDIASURE VAINILLA *400 GR','659','ABBOTT NUTRICION','2024-05-30 17:50:43',  50180, 22284, 223, 99),('FVE','FNVL','022193','2024-05-30 17:57:05','052024','CO','1005626167','GABRIELA ','SUARES ','VILLA MARBELLA  MANZA 0 CASA 3','  3215934019','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','4285.714285714286','814.2857142857138','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 17:57:05','5100','87','BOD. FARMANORTE 87','1','5100','5100','4285.7142857143','814.28571428571','5100','1','0','0','','30/05/2024','',5100,0,0,'7702402053556','CONO BOCATTO FRESA *85 GR','296','MEALS DE COLOMBIA','2024-05-30 17:57:05',  2980, 55871, 223, 99),('FVE','FNVL','022194','2024-05-30 18:14:43','052024','CO','1084791276','SERGIO ','MOLINA ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 18:14:43','3100','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','1','','30/05/2024','',3100,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-05-30 18:14:43',  1768.4, 60339, 223, 99),('FVE','FNVL','022195','2024-05-30 18:24:13','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','61260.50420168068','11639.495798319324','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 18:24:15','72900','87','BOD. FARMANORTE 87','1','72900','72900','61260.504201681','11639.495798319','72900','1','0','306','','30/05/2024','',0,52900,0,'751273783052','SUPER MAGNESIUM 400 MG * 100 SOFTGELS','641','HEALTHY DE AMERICA COLOMBIA','2024-05-30 18:24:13',  34327.3, 52286, 223, 99),('FVE','FNVL','022196','2024-05-30 18:34:39','052024','CO','1082977726','WINNY TATIANA ','PATINO BUSTAMANTE ','VILLA BELLA',' 3113483563','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','15','14994.117647058823','1005.8823529411766','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 18:34:39','16000','87','BOD. FARMANORTE 87','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','75','','30/05/2024','',0,16000,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-30 18:34:39',  3881.5, 56142, 223, 99),('FVE','FNVL','022196','2024-05-30 18:34:39','052024','CO','1082977726','WINNY TATIANA ','PATINO BUSTAMANTE ','VILLA BELLA',' 3113483563','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','15','14994.117647058823','1005.8823529411766','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 18:34:39','16000','87','BOD. FARMANORTE 87','4','1300','5200','5200','0','5200','0','4','75','','30/05/2024','',0,16000,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-30 18:34:39',  114652, 26533, 223, 99),('FVE','FNVL','022196','2024-05-30 18:34:39','052024','CO','1082977726','WINNY TATIANA ','PATINO BUSTAMANTE ','VILLA BELLA',' 3113483563','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','15','14994.117647058823','1005.8823529411766','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 18:34:39','16000','87','BOD. FARMANORTE 87','10','450','4500','4500','0','4500','0','10','75','','30/05/2024','',0,16000,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-05-30 18:34:39',  13144, 31502, 223, 99),('FVE','FNVL','022197','2024-05-30 19:10:17','052024','CO','20457021','JOSE LUIS','BRECENO HERNANDEZ','KRA 21A 3 N 29F-71APTO 202 LOS',' 3042899761','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','44243.6974789916','8406.302521008403','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:10:17','52650','87','BOD. FARMANORTE 87','1','12900','12900','10840.336134454','2059.6638655462','12900','1','0','221','10','30/05/2024','',52650,0,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-05-30 19:10:17',  8414.1, 33273, 223, 99),('FVE','FNVL','022197','2024-05-30 19:10:17','052024','CO','20457021','JOSE LUIS','BRECENO HERNANDEZ','KRA 21A 3 N 29F-71APTO 202 LOS',' 3042899761','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','44243.6974789916','8406.302521008403','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:10:17','52650','87','BOD. FARMANORTE 87','1','39750','39750','33403.361344538','6346.6386554622','39750','1','0','221','10','30/05/2024','',52650,0,0,'7701021116635','WINNY PANTS ET4 XG *30 UNID','653','TECNOQUIMICAS WINNY','2024-05-30 19:10:17',  30058.2, 55727, 223, 99),('FVE','FNVL','022198','2024-05-30 19:15:01','052024','CO','1082837693','JULIAN','PABON','URB VILLA MARBELLA MZ G CASA 1',' 3017553179','2718','YERIKA','CUDRIZ PéREZ ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','1001611782','1098721309','ARGUMEDO GARRIDO ANGEL RENE','','','4','80900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:15:01','80900','87','BOD. FARMANORTE 87','3','26300','78900','78900','0','78900','0','3','405','','30/05/2024','',0,80900,0,'D1012','PULMICORT 0.5 MG *5 RESPULES','117','ASTRAZENECA COLOMBIA','2024-05-30 19:15:01',  112621, 22772, 223, 99),('FVE','FNVL','022198','2024-05-30 19:15:01','052024','CO','1082837693','JULIAN','PABON','URB VILLA MARBELLA MZ G CASA 1',' 3017553179','2718','YERIKA','CUDRIZ PéREZ ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','1001611782','1098721309','ARGUMEDO GARRIDO ANGEL RENE','','','4','80900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:15:01','80900','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','405','','30/05/2024','',0,80900,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 19:15:01',  1500, 44348, 223, 99),('FVE','FNVL','022199','2024-05-30 19:25:56','052024','CO','1082950422','MANUEL ','MANJARREZ','mz  n casa 325  villa marbella',' 3013154299','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','2','30900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:25:56','30900','87','BOD. FARMANORTE 87','1','28900','28900','28900','0','28900','1','0','155','10','31/05/2024','',10900,20000,0,'7702024025733','KLIM 1+ BOLSA *500 GR','311','NESTLE NUTRICION','2024-05-30 19:25:56',  26210, 38369, 223, 99),('FVE','FNVL','022199','2024-05-30 19:25:56','052024','CO','1082950422','MANUEL ','MANJARREZ','mz  n casa 325  villa marbella',' 3013154299','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','2','30900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:25:56','30900','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','155','','31/05/2024','',10900,20000,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 19:25:56',  1500, 44348, 223, 99),('FVE','FNVL','022200','2024-05-30 19:31:49','052024','CO','19620339','EFREIN','LINCON','',' NO DIO','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','672.2689075630252','127.73109243697479','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:31:49','800','87','BOD. FARMANORTE 87','1','800','800','672.26890756303','127.73109243697','800','1','0','1','','31/05/2024','',800,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-05-30 19:31:49',  228.3, 39236, 223, 99),('FVE','FNVL','022201','2024-05-30 19:35:23','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','14000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:35:24','14000','87','BOD. FARMANORTE 87','1','14000','14000','14000','0','14000','1','0','70','','31/05/2024','',14000,0,0,'7703712012097','DERMASKIN CREMA *20 GR','793','COASPHARMA MEDIBRAND OTX','2024-05-30 19:35:23',  8595, 24273, 223, 99),('FVE','FNVL','022202','2024-05-30 19:41:54','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','3','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 19:41:55','3000','87','BOD. FARMANORTE 87','3','1000','3000','3000','0','3000','3','0','15','','31/05/2024','',3000,0,0,'7702090037784','AGUA CRISTAL CON GAS BOTELLA *300 ML','192','POSTOBON GASEOSAS','2024-05-30 19:41:54',  583.3333, 52915, 223, 99),('FVE','FNVL','022203','2024-05-30 20:09:31','052024','CO','1007499508','ALDAIR','ORTIZ','LOS ALMENDROS',' 3017862706 ','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','1','19500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 20:09:32','19500','87','BOD. FARMANORTE 87','1','19500','19500','19500','0','19500','1','0','0','29','31/05/2024','',19500,0,0,'7703546012119','TENSOFAR 100 MG * 30 TAB L-CONSUM','630','NOVAMED OTC','2024-05-30 20:09:31',  27849, 48401, 223, 99),('FVE','FNVL','022204','2024-05-30 20:52:11','052024','CO','1193123316','CAMILO','ALVAREZ','',' 3222222222','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','10062.18487394958','1037.81512605042','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 20:52:11','11100','87','BOD. FARMANORTE 87','2','2300','4600','4600','0','4600','0','2','0','','31/05/2024','',11100,0,0,'7702057092757','IBUFLASH MIGRAN *30 CAP','382','TECNOQUIMICAS','2024-05-30 20:52:11',  50677.65, 58898, 223, 99),('FVE','FNVL','022204','2024-05-30 20:52:11','052024','CO','1193123316','CAMILO','ALVAREZ','',' 3222222222','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','10062.18487394958','1037.81512605042','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 20:52:11','11100','87','BOD. FARMANORTE 87','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','31/05/2024','',11100,0,0,'7702402051347','HELADO CASERO GUANABANA *60 GR','296','MEALS DE COLOMBIA','2024-05-30 20:52:11',  1206, 50721, 223, 99),('FVE','FNVL','022204','2024-05-30 20:52:11','052024','CO','1193123316','CAMILO','ALVAREZ','',' 3222222222','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','10062.18487394958','1037.81512605042','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 20:52:11','11100','87','BOD. FARMANORTE 87','2','2100','4200','3529.4117647059','670.58823529412','4200','2','0','0','','31/05/2024','',11100,0,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2024-05-30 20:52:11',  999.61, 55601, 223, 99),('FVE','FNVL','022205','2024-05-30 20:54:16','052024','CO','1083009784','LAURA ','ARIZA','Manzana 84 casa 1 ciudadela ',' 3016754231','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','27400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 20:54:16','27400','87','BOD. FARMANORTE 87','1','12900','12900','12900','0','12900','1','0','0','','31/05/2024','',0,27400,0,'7706569001245','AZITROMICINA 500MG *3 TAB','614','A.G. MEDICAMENTOS','2024-05-30 20:54:16',  4968, 31223, 223, 99),('FVE','FNVL','022205','2024-05-30 20:54:16','052024','CO','1083009784','LAURA ','ARIZA','Manzana 84 casa 1 ciudadela ',' 3016754231','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','27400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 20:54:16','27400','87','BOD. FARMANORTE 87','1','14500','14500','14500','0','14500','1','0','0','27','31/05/2024','',0,27400,0,'7702870004425','BELLAFACE *21 TAB ','619','ABBOTT FARMA','2024-05-30 20:54:16',  12656, 31230, 223, 99),('FVE','FNVL','022206','2024-05-30 21:00:14','052024','CO','85461736','YAQUELIN','MEJIA','calle 6 13-19 pescaito',' 3014505585','4142','SANDRO  JUNIOR','OSORIO  CARMONA','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','2','20500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:00:14','20500','87','BOD. FARMANORTE 87','1','18500','18500','18500','0','18500','1','0','0','','31/05/2024','',20500,0,0,'736085132069','NAZIL GOTAS OFT *15 ML','636','SOPHIA DE COLOMBIA OTC','2024-05-30 21:00:14',  8969, 31133, 223, 99),('FVE','FNVL','022206','2024-05-30 21:00:14','052024','CO','85461736','YAQUELIN','MEJIA','calle 6 13-19 pescaito',' 3014505585','4142','SANDRO  JUNIOR','OSORIO  CARMONA','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','2','20500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:00:14','20500','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',20500,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 21:00:14',  1500, 44348, 223, 99),('FVE','FNVL','022207','2024-05-30 21:05:45','052024','CO','1051671133','YENIFER','POMARES','',' 1','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','9394.117647058823','1005.8823529411761','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:05:45','10400','87','BOD. FARMANORTE 87','1','3900','3900','3900','0','3900','1','0','0','','31/05/2024','',0,10400,0,'7709478324955','DIPIRONA SODICA 1GR/2ML *1 AMP','701','VITALIS COMERCIAL','2024-05-30 21:05:45',  2100, 54744, 223, 99),('FVE','FNVL','022207','2024-05-30 21:05:45','052024','CO','1051671133','YENIFER','POMARES','',' 1','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','9394.117647058823','1005.8823529411761','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:05:45','10400','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','31/05/2024','',0,10400,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-05-30 21:05:45',  255, 46100, 223, 99),('FVE','FNVL','022207','2024-05-30 21:05:45','052024','CO','1051671133','YENIFER','POMARES','',' 1','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','9394.117647058823','1005.8823529411761','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:05:45','10400','87','BOD. FARMANORTE 87','2','2900','5800','4873.9495798319','926.05042016807','5800','2','0','0','','31/05/2024','',0,10400,0,'7702007212501','CHOCOLATINA JUMBO MANI *40 GR','816','GRUPO NUTRESA','2024-05-30 21:05:45',  2202.5, 53169, 223, 99),('FVE','FNVL','022207','2024-05-30 21:05:45','052024','CO','1051671133','YENIFER','POMARES','',' 1','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','9394.117647058823','1005.8823529411761','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:05:45','10400','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,10400,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 21:05:45',  100, 44347, 223, 99),('FVE','FNVL','022208','2024-05-30 21:09:03','052024','CO','1010107188','JESSICA','PANNEFLEK','',' 3015326100','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','6','13164','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:09:03','13164','87','BOD. FARMANORTE 87','1','3200','3200','3200','0','3200','0','1','0','','31/05/2024','',13164,0,0,'7703153040949','DICLOFENACO 75MG/3ML CJA * 10 AMP','422','COLMED','2024-05-30 21:09:03',  5600, 61834, 223, 99),('FVE','FNVL','022208','2024-05-30 21:09:03','052024','CO','1010107188','JESSICA','PANNEFLEK','',' 3015326100','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','6','13164','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:09:03','13164','87','BOD. FARMANORTE 87','1','4100','4100','4100','0','4100','0','1','0','','31/05/2024','',13164,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-30 21:09:03',  7000, 23704, 223, 99),('FVE','FNVL','022208','2024-05-30 21:09:03','052024','CO','1010107188','JESSICA','PANNEFLEK','',' 3015326100','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','6','13164','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:09:03','13164','87','BOD. FARMANORTE 87','4','1466','5864','5864','0','5864','0','4','0','','31/05/2024','',13164,0,0,'7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2024-05-30 21:09:03',  66736, 55304, 223, 99),('FVE','FNVL','022209','2024-05-30 21:12:01','052024','CO','1007780619','AMILCAR','ORO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','8000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:12:01','8000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','31/05/2024','',0,8000,0,'7707282990953','PRUEBA DE EMBARAZO CASSETTE','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 21:12:01',  1400, 58459, 223, 99),('FVE','FNVL','022210','2024-05-30 21:33:49','052024','CO','1007780613','LIRENA ','MORENO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2521.008403361345','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:33:49','3000','87','BOD. FARMANORTE 87','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','31/05/2024','',3000,0,0,'7702090048193','GASEOSA SEVEN UP *1 LT ECONOLITRO','192','POSTOBON GASEOSAS','2024-05-30 21:33:49',  2100.84, 56026, 223, 99),('FVE','FNVL','022211','2024-05-30 21:40:43','052024','CO','100463666','JUAN','CARLOS','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','36722.68907563025','6977.310924369747','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:40:43','43700','87','BOD. FARMANORTE 87','1','43700','43700','36722.68907563','6977.3109243697','43700','1','0','0','','31/05/2024','',43700,0,0,'7701021116666','WINNY PANTS ET5 XXG *30 UNID','653','TECNOQUIMICAS WINNY','2024-05-30 21:40:43',  32994.9, 55738, 223, 99),('FVE','FNVL','022212','2024-05-30 21:53:06','052024','CO','1007358891','ISSAC','JIMENEZ','',' 3138027127','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1001612017','1144041482','DURAN LARA JUAN SEBASTIAN','','','2','31000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:53:06','31000','87','BOD. FARMANORTE 87','1','23000','23000','23000','0','23000','1','0','155','','31/05/2024','',0,31000,0,'7703712080270','OXIFAR 20 MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 21:53:06',  11800, 53835, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FNVL','022213','2024-05-30 21:59:51','052024','CO','1120753694','SAID ','CAMARGO ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','18840.336134453784','2059.6638655462175','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:59:51','20900','87','BOD. FARMANORTE 87','1','12900','12900','10840.336134454','2059.6638655462','12900','1','0','0','','31/05/2024','',0,20900,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-05-30 21:59:51',  8414.1, 33273, 223, 99),('FVE','FNVL','022213','2024-05-30 21:59:51','052024','CO','1120753694','SAID ','CAMARGO ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','18840.336134453784','2059.6638655462175','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 21:59:51','20900','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','0','1','0','','31/05/2024','',0,20900,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-30 21:59:51',  53223.5, 41855, 223, 99),('FVE','FNVL','022214','2024-05-30 22:21:19','052024','CO','1082920895','YULI','VERGARA','care 21b #29 b 3 19 bulevar de','  3046546201 3046546201','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1001901843','1090986080','CARVAJALINO SANTIAGO EDWARD','','','12','16200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 22:21:19','16200','87','BOD. FARMANORTE 87','10','700','7000','7000','0','7000','0','10','0','','31/05/2024','',16200,0,0,'7706569000026','AMOXICILINA 500MG *50 CAP','614','A.G. MEDICAMENTOS','2024-05-30 22:21:19',  21949, 31190, 223, 99),('FVE','FNVL','022214','2024-05-30 22:21:19','052024','CO','1082920895','YULI','VERGARA','care 21b #29 b 3 19 bulevar de','  3046546201 3046546201','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','1001901843','1090986080','CARVAJALINO SANTIAGO EDWARD','','','12','16200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 22:21:19','16200','87','BOD. FARMANORTE 87','2','4600','9200','9200','0','9200','0','2','0','','31/05/2024','',16200,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 22:21:19',  27780, 54056, 223, 99),('FVE','FNVL','022215','2024-05-30 22:23:39','052024','CO','1001885756','NELSON','PEREZ','',' 3008534542','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','8000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 22:23:39','8000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','30','31/05/2024','',8000,0,0,'7707282990953','PRUEBA DE EMBARAZO CASSETTE','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 22:23:39',  1400, 58459, 223, 99),('FVE','FNVL','022216','2024-05-30 22:36:37','052024','CO','10824754428','MARTIN','LOPEZ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','8000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 22:36:37','8000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','31/05/2024','',8000,0,0,'7707282990953','PRUEBA DE EMBARAZO CASSETTE','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 22:36:37',  1400, 58459, 223, 99),('FVE','FNVL','022217','2024-05-30 22:46:33','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','1848.7394957983195','351.26050420168053','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 22:46:33','2200','87','BOD. FARMANORTE 87','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','31/05/2024','',2200,0,0,'7622201776664','TRIDENT MENTA *8.5 GR','754','DISCOB NORTE SAS','2024-05-30 22:46:33',  1050.4, 57675, 223, 99),('FVE','FNVL','022218','2024-05-30 22:47:59','052024','CO','414550','CARLOS','ALVARADO','cara 21 a 3 No 29 j 99 los lau',' 3178601362','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','9900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 22:48:00','9900','87','BOD. FARMANORTE 87','1','9900','9900','9900','0','9900','1','0','0','','31/05/2024','',9900,0,0,'4005800254963','DUO LUBRICADO *3 PRESERVATIVOS','123','BDF (BEIERSDORF) ','2024-05-30 22:47:59',  9427.1, 23315, 223, 99),('FVE','FNVL','022219','2024-05-30 23:35:48','052024','CO','1007780619','AMILCAR','ORO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 23:35:49','3000','87','BOD. FARMANORTE 87','1','3000','3000','3000','0','3000','0','1','0','','31/05/2024','',3000,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2024-05-30 23:35:48',  27350, 46776, 223, 99),('FVE','FNVL','022220','2024-05-30 23:53:37','052024','CO','8485730','EDER ','BETANCUR','','0 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','8369.747899159665','830.2521008403355','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 23:53:37','9200','87','BOD. FARMANORTE 87','1','5200','5200','4369.7478991597','830.25210084034','5200','1','0','0','','31/05/2024','',9200,0,0,'7702010420993','PROTEX JABON PRO-HIDRATA MACADAMIA *110 GR','145','COLGATE PALMOLIVE COMPANIA','2024-05-30 23:53:37',  2300.23, 52325, 223, 99),('FVE','FNVL','022220','2024-05-30 23:53:37','052024','CO','8485730','EDER ','BETANCUR','','0 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','3','8369.747899159665','830.2521008403355','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 23:53:37','9200','87','BOD. FARMANORTE 87','2','2000','4000','4000','0','4000','2','0','0','','31/05/2024','',9200,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 23:53:37',  800, 48019, 223, 99),('FVE','FNVL','022221','2024-05-30 23:55:19','052024','CO','1002326638','SARETH','CHARRIS','',' NO DIO','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 23:55:19','3100','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','31/05/2024','',3100,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-05-30 23:55:19',  1768.4, 60339, 223, 99),('FVE','FNVL','022222','2024-05-30 23:59:00','052024','CO','1192781809','FRAN ','GOMEZ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','8840','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 23:59:00','8840','87','BOD. FARMANORTE 87','4','1710','6840','6840','0','6840','0','4','0','','31/05/2024','',8840,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-30 23:59:00',  2500, 57400, 223, 99),('FVE','FNVL','022222','2024-05-30 23:59:00','052024','CO','1192781809','FRAN ','GOMEZ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','5','8840','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-30 23:59:00','8840','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',8840,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 23:59:00',  800, 48019, 223, 99),('FVE','FNVL','022223','2024-05-31 00:45:17','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','10','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 00:45:17','3000','87','BOD. FARMANORTE 87','10','300','3000','3000','0','3000','0','10','0','','31/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-31 00:45:17',  28997, 54625, 223, 99),('FVE','FNVL','022224','2024-05-31 00:49:39','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 00:49:39','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 00:49:39',  800, 48019, 223, 99),('FVE','FNVL','022225','2024-05-31 00:52:13','052024','CO','1007780612','ANDRES','FUENTE ','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 00:52:13','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 00:52:13',  800, 48019, 223, 99),('FVE','FNVL','022226','2024-05-31 01:04:56','052024','CO','1005663384','VANESA','GUERRERO','','00 3122329955','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','7983.193277310925','1516.8067226890753','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 01:04:56','9500','87','BOD. FARMANORTE 87','1','8500','8500','7142.8571428571','1357.1428571429','8500','1','0','0','','31/05/2024','',9500,0,0,'7702189051455','PAPAS MARGARITA RECETA CLASICA ALITAS BBQ *120 GR','762','FRITO LAY','2024-05-31 01:04:56',  5555, 53362, 223, 99),('FVE','FNVL','022226','2024-05-31 01:04:56','052024','CO','1005663384','VANESA','GUERRERO','','00 3122329955','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','7983.193277310925','1516.8067226890753','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 01:04:56','9500','87','BOD. FARMANORTE 87','1','1000','1000','840.33613445378','159.66386554622','1000','1','0','0','','31/05/2024','',9500,0,0,'77010148','JET CHOCOLATINA *12 GR','816','GRUPO NUTRESA','2024-05-31 01:04:56',  632.88, 47412, 223, 99),('FVE','FNVL','022227','2024-05-31 01:05:59','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 01:05:59','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 01:05:59',  800, 48019, 223, 99),('FVE','FNVL','022228','2024-05-31 02:20:55','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','4','5200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 02:20:56','5200','87','BOD. FARMANORTE 87','4','1300','5200','5200','0','5200','0','4','0','','31/05/2024','',5200,0,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-31 02:20:55',  114652, 26533, 223, 99),('FVE','FNVL','022229','2024-05-31 04:33:14','052024','CO','1007780615','PEDRO ','FUENTE ','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','2672.268907563025','127.73109243697479','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 04:33:15','2800','87','BOD. FARMANORTE 87','1','800','800','672.26890756303','127.73109243697','800','1','0','0','','31/05/2024','',2800,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-05-31 04:33:14',  228.3, 39236, 223, 99),('FVE','FNVL','022229','2024-05-31 04:33:14','052024','CO','1007780615','PEDRO ','FUENTE ','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','2672.268907563025','127.73109243697479','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 04:33:15','2800','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2800,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 04:33:14',  800, 48019, 223, 99),('FVE','FNVL','022230','2024-05-31 05:31:00','052024','CO','1007780619','AMILCAR','ORO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','21008.40336134454','3991.596638655461','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 05:31:00','25000','87','BOD. FARMANORTE 87','1','25000','25000','21008.403361345','3991.5966386555','25000','1','0','0','','31/05/2024','',25000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-31 05:31:00',  9360, 46328, 223, 99),('FVE','FNVL','022231','2024-05-31 06:06:29','052024','CO','1007780613','LIRENA ','MORENO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','2268.90756302521','431.09243697478985','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 06:06:29','2700','87','BOD. FARMANORTE 87','1','800','800','672.26890756303','127.73109243697','800','1','0','0','','31/05/2024','',2700,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-05-31 06:06:29',  228.3, 39236, 223, 99),('FVE','FNVL','022231','2024-05-31 06:06:29','052024','CO','1007780613','LIRENA ','MORENO','',' 3000000000','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','2268.90756302521','431.09243697478985','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 06:06:29','2700','87','BOD. FARMANORTE 87','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','31/05/2024','',2700,0,0,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-05-31 06:06:29',  1142.8, 60397, 223, 99),('FVE','FNVL','022232','2024-05-31 06:19:27','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','1','1260.5042016806724','239.4957983193276','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 06:19:27','1500','87','BOD. FARMANORTE 87','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','31/05/2024','',1500,0,0,'7705326079022','SUBMARINO MARINELA AREQUIPE *33 GR','126','BIMBO DE COLOMBIA S.A.','2024-05-31 06:19:27',  871, 57121, 223, 99),('FVE','FNVL','022233','2024-05-31 06:41:49','052024','CO','12326930','RICARDO','SIFUENTE ','',' 0','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','2','6000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 06:41:50','6000','87','BOD. FARMANORTE 87','2','3000','6000','6000','0','6000','0','2','0','','31/05/2024','',6000,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2024-05-31 06:41:49',  27350, 46776, 223, 99),('FVE','FNVL','022234','2024-05-31 07:07:54','052024','CO','1126253994','KARINA','SALCEDO','',' 3022355494','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','6','15440.33613445378','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:07:55','15600','87','BOD. FARMANORTE 87','2','4100','8200','8200','0','8200','0','2','77','','31/05/2024','',15600,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-31 07:07:54',  7000, 23704, 223, 99),('FVE','FNVL','022234','2024-05-31 07:07:54','052024','CO','1126253994','KARINA','SALCEDO','',' 3022355494','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','6','15440.33613445378','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:07:55','15600','87','BOD. FARMANORTE 87','2','3200','6400','6400','0','6400','0','2','77','','31/05/2024','',15600,0,0,'7703153040949','DICLOFENACO 75MG/3ML CJA * 10 AMP','422','COLMED','2024-05-31 07:07:54',  5600, 61834, 223, 99),('FVE','FNVL','022234','2024-05-31 07:07:54','052024','CO','1126253994','KARINA','SALCEDO','',' 3022355494','4142','SANDRO  JUNIOR','OSORIO  CARMONA','','TERCERO','VARIOS','','','','','','6','15440.33613445378','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:07:55','15600','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','2','0','77','','31/05/2024','',15600,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-05-31 07:07:54',  255, 46100, 223, 99),('FVE','FNVL','022235','2024-05-31 07:15:24','052024','CO','1081907898','MARTHA','ACU Ntilde A','MNZ 23 CASA 6 CENTENARIO',' 3013433170','4142','SANDRO  JUNIOR','OSORIO  CARMONA','3256','LEIDER MANUEL','PUA NAVARRO','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','14','35929.747899159665','830.252100840336','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:15:24','36760','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','180','','31/05/2024','',36760,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 07:15:24',  100, 44347, 223, 99),('FVE','FNVL','022235','2024-05-31 07:15:24','052024','CO','1081907898','MARTHA','ACU Ntilde A','MNZ 23 CASA 6 CENTENARIO',' 3013433170','4142','SANDRO  JUNIOR','OSORIO  CARMONA','3256','LEIDER MANUEL','PUA NAVARRO','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','14','35929.747899159665','830.252100840336','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:15:24','36760','87','BOD. FARMANORTE 87','1','29360','29360','29360','0','29360','1','0','180','','31/05/2024','',36760,0,0,'7703381000753','BISOLVON NINOS *120 ML','772','OPELLA (SANOFI OTC)','2024-05-31 07:15:24',  31293.9, 23804, 223, 99),('FVE','FNVL','022235','2024-05-31 07:15:24','052024','CO','1081907898','MARTHA','ACU Ntilde A','MNZ 23 CASA 6 CENTENARIO',' 3013433170','4142','SANDRO  JUNIOR','OSORIO  CARMONA','3256','LEIDER MANUEL','PUA NAVARRO','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','14','35929.747899159665','830.252100840336','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:15:24','36760','87','BOD. FARMANORTE 87','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','180','','31/05/2024','',36760,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-31 07:15:24',  15435, 56535, 223, 99),('FVE','FNVL','022235','2024-05-31 07:15:24','052024','CO','1081907898','MARTHA','ACU Ntilde A','MNZ 23 CASA 6 CENTENARIO',' 3013433170','4142','SANDRO  JUNIOR','OSORIO  CARMONA','3256','LEIDER MANUEL','PUA NAVARRO','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','14','35929.747899159665','830.252100840336','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:15:24','36760','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','1','0','180','','31/05/2024','',36760,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-05-31 07:15:24',  255, 46100, 223, 99),('FVE','FNVL','022235','2024-05-31 07:15:24','052024','CO','1081907898','MARTHA','ACU Ntilde A','MNZ 23 CASA 6 CENTENARIO',' 3013433170','4142','SANDRO  JUNIOR','OSORIO  CARMONA','3256','LEIDER MANUEL','PUA NAVARRO','1994657','8102240','CASTANO MAYA JUAN CARLOS','','','14','35929.747899159665','830.252100840336','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:15:24','36760','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','180','','31/05/2024','',36760,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 07:15:24',  1500, 44348, 223, 99),('FVE','FNVL','022236','2024-05-31 07:33:28','052024','CO','26694584','CANDELARIA','SIMANCA ','KRA 21B N 29D3  CASA 4 ESQUINA',' 3046107929','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','5','13120.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:33:28','13200','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','66','','31/05/2024','',13200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 07:33:28',  100, 44347, 223, 99),('FVE','FNVL','022236','2024-05-31 07:33:28','052024','CO','26694584','CANDELARIA','SIMANCA ','KRA 21B N 29D3  CASA 4 ESQUINA',' 3046107929','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','5','13120.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:33:28','13200','87','BOD. FARMANORTE 87','1','6400','6400','6400','0','6400','0','1','66','','31/05/2024','',13200,0,0,'7709990733716','NORIFLAM 75MG/3ML CJA * 6 AMP','698','MED-LINE CONVENIO','2024-05-31 07:33:28',  13050, 48643, 223, 99),('FVE','FNVL','022236','2024-05-31 07:33:28','052024','CO','26694584','CANDELARIA','SIMANCA ','KRA 21B N 29D3  CASA 4 ESQUINA',' 3046107929','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','5','13120.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:33:28','13200','87','BOD. FARMANORTE 87','1','4100','4100','4100','0','4100','0','1','66','','31/05/2024','',13200,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-31 07:33:28',  7000, 23704, 223, 99),('FVE','FNVL','022236','2024-05-31 07:33:28','052024','CO','26694584','CANDELARIA','SIMANCA ','KRA 21B N 29D3  CASA 4 ESQUINA',' 3046107929','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','5','13120.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:33:28','13200','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','1','0','66','','31/05/2024','',13200,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-05-31 07:33:28',  255, 46100, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FNVL','022237','2024-05-31 07:50:31','052024','CO','24370316','ANDRIS','SILVA','',' 3222222222','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','19243.6974789916','3656.3025210084015','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:50:32','22900','87','BOD. FARMANORTE 87','1','22900','22900','19243.697478992','3656.3025210084','22900','1','0','0','10','31/05/2024','',22900,0,0,'7701021118332','WINNY ULTRATRIM SEC ET4 *16 UNID','653','TECNOQUIMICAS WINNY','2024-05-31 07:50:31',  16654.51, 57266, 223, 99),('FVE','FNVL','022238','2024-05-31 07:53:40','052024','CO','1193137142','SUGEY ','BENITES ','KARERA 21B29F3NUMER 10 villa b','   3242846454','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','11','20000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:53:40','20000','87','BOD. FARMANORTE 87','10','1800','18000','18000','0','18000','0','10','0','','31/05/2024','',20000,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-31 07:53:40',  111600, 43550, 223, 99),('FVE','FNVL','022238','2024-05-31 07:53:40','052024','CO','1193137142','SUGEY ','BENITES ','KARERA 21B29F3NUMER 10 villa b','   3242846454','2718','YERIKA','CUDRIZ PéREZ ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','11','20000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 07:53:40','20000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',20000,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 07:53:40',  1500, 44348, 223, 99),('FVE','FNVL','022239','2024-05-31 11:20:12','052024','CO','77093105','AMAURIS','MARTINEZ','MZ A CASA 56 TREBOL',' 3215336033 3000000000','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','15800','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 11:20:12','15800','87','BOD. FARMANORTE 87','1','15800','15800','15800','0','15800','1','0','1','','31/05/2024','',15800,0,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-05-31 11:20:12',  14234, 54385, 223, 99),('FVE','FNVL','022240','2024-05-31 12:09:43','052024','CO','1082920895','YULI','VERGARA','care 21b #29 b 3 19 bulevar de','  3046546201 3046546201','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','1','31500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:09:44','31500','87','BOD. FARMANORTE 87','1','31500','31500','31500','0','31500','1','0','0','','31/05/2024','',31500,0,0,'7702132009748','ADVIL CHILDREN *100 ML ','616','HALEON (GLAXO OTC)','2024-05-31 12:09:43',  28044, 46798, 223, 99),('FVE','FNVL','022241','2024-05-31 12:11:59','052024','CO','1082920895','YULI','VERGARA','care 21b #29 b 3 19 bulevar de','  3046546201 3046546201','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','29860.504201680673','239.4957983193276','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:11:59','30100','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','31/05/2024','',30100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 12:11:59',  100, 44347, 223, 99),('FVE','FNVL','022241','2024-05-31 12:11:59','052024','CO','1082920895','YULI','VERGARA','care 21b #29 b 3 19 bulevar de','  3046546201 3046546201','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','29860.504201680673','239.4957983193276','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:11:59','30100','87','BOD. FARMANORTE 87','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','31/05/2024','',30100,0,0,'7705326079022','SUBMARINO MARINELA AREQUIPE *33 GR','126','BIMBO DE COLOMBIA S.A.','2024-05-31 12:11:59',  871, 57121, 223, 99),('FVE','FNVL','022241','2024-05-31 12:11:59','052024','CO','1082920895','YULI','VERGARA','care 21b #29 b 3 19 bulevar de','  3046546201 3046546201','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','29860.504201680673','239.4957983193276','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:11:59','30100','87','BOD. FARMANORTE 87','1','28400','28400','28400','0','28400','1','0','0','','31/05/2024','',30100,0,0,'7702024025719','KLIM 3+ BOLSA *500 GR','311','NESTLE NUTRICION','2024-05-31 12:11:59',  25782, 38373, 223, 99),('FVE','FNVL','022242','2024-05-31 12:26:54','052024','CO','1003275328','KAREN','VELOZA','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','11680.672268907565','2219.327731092436','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:26:54','13900','87','BOD. FARMANORTE 87','1','8800','8800','7394.9579831933','1405.0420168067','8800','1','0','0','','31/05/2024','',0,13900,0,'070847038764','MONSTER ENERGY MANGO LOCO LATA *473 ML','144','COCA COLA','2024-05-31 12:26:54',  5290.2, 60471, 223, 99),('FVE','FNVL','022242','2024-05-31 12:26:54','052024','CO','1003275328','KAREN','VELOZA','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','11680.672268907565','2219.327731092436','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:26:54','13900','87','BOD. FARMANORTE 87','1','5100','5100','4285.7142857143','814.28571428571','5100','1','0','0','','31/05/2024','',0,13900,0,'7702402050234','POLET COOKIES & CREAM *70 GR','296','MEALS DE COLOMBIA','2024-05-31 12:26:54',  2996.6, 49295, 223, 99),('FVE','FNVL','022243','2024-05-31 12:33:27','052024','CO','39001779','YAISIRIS','NAVARRO','',' 3001102549','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','5','5000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:33:28','5000','87','BOD. FARMANORTE 87','5','1000','5000','5000','0','5000','5','0','25','','31/05/2024','',5000,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2024-05-31 12:33:27',  570, 58629, 223, 99),('FVE','FNVL','022244','2024-05-31 12:52:42','052024','CO','85462239','JOSE','MEJIA','VILLA BELLA',' 3012604228','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','3361.3445378151264','638.6554621848736','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 12:52:42','4000','87','BOD. FARMANORTE 87','1','4000','4000','3361.3445378151','638.65546218487','4000','1','0','17','','31/05/2024','',4000,0,0,'7702535022061','JUGO DEL VALLE FRUTAS CITRICAS *1.5 LT','144','COCA COLA','2024-05-31 12:52:42',  2389.8, 57040, 223, 99),('FVE','FNVL','022245','2024-05-31 14:17:55','052024','CO','1004109493','CRISTIAN','MENDOZA','',' 3016997064','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','10500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 14:17:55','10500','87','BOD. FARMANORTE 87','1','10500','10500','10500','0','10500','1','0','53','','31/05/2024','',0,10500,0,'7709208753895','PRUEBA DE EMBARAZO DB LIFE LAPICERO','750','DIAGNOSTICOS BIOMEDICOS','2024-05-31 14:17:55',  3100, 62932, 223, 99),('FVE','FNVL','022246','2024-05-31 14:24:59','052024','CO','1019124528','JOHANA ','GUTIERRES ','',' 3000000000','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','18000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 14:24:59','18000','87','BOD. FARMANORTE 87','1','18000','18000','18000','0','18000','1','0','0','','31/05/2024','',0,18000,0,'7707341100040','IMPODINA 5 MG * 10 TAB','152','COMERLAT PHARMACEUTICAL','2024-05-31 14:24:59',  6080, 63582, 223, 99),('FVE','FNVL','022247','2024-05-31 14:42:12','052024','CO','7265479','YAIR ','CASTA Ntilde O ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','42','73086.55462184874','5013.44537815126','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 14:42:13','78100','87','BOD. FARMANORTE 87','1','22000','22000','18487.394957983','3512.6050420168','22000','1','0','0','','31/05/2024','',0,78100,0,'7891010501105','REACH SEDA DENTAL ESSENCIAL *100 MT','221','JOHNSON Y JOHNSON DE COL SA','2024-05-31 14:42:12',  15592, 28179, 223, 99),('FVE','FNVL','022247','2024-05-31 14:42:12','052024','CO','7265479','YAIR ','CASTA Ntilde O ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','42','73086.55462184874','5013.44537815126','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 14:42:13','78100','87','BOD. FARMANORTE 87','1','20700','20700','20700','0','20700','1','0','0','','31/05/2024','',0,78100,0,'7703712080171','GRIBONGIN 2% JARABE * 120 ML /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 14:42:12',  12001, 53836, 223, 99),('FVE','FNVL','022247','2024-05-31 14:42:12','052024','CO','7265479','YAIR ','CASTA Ntilde O ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','42','73086.55462184874','5013.44537815126','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 14:42:13','78100','87','BOD. FARMANORTE 87','20','1300','26000','26000','0','26000','0','20','0','','31/05/2024','',0,78100,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-31 14:42:12',  114652, 26533, 223, 99),('FVE','FNVL','022247','2024-05-31 14:42:12','052024','CO','7265479','YAIR ','CASTA Ntilde O ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','42','73086.55462184874','5013.44537815126','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 14:42:13','78100','87','BOD. FARMANORTE 87','20','470','9400','7899.1596638655','1500.8403361345','9400','0','20','0','','31/05/2024','',0,78100,0,'7702184835982','VITAMINA C + ZINC TUTI FRUTI * 100 TAB','249','ECAR','2024-05-31 14:42:12',  15435, 58540, 223, 99),('FVE','FNVL','022248','2024-05-31 15:25:01','052024','CO','1045766738','DANIEL ','CASTANENA','3',' 9 3205011790','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','12','11905.882352941177','894.1176470588234','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:25:01','12800','87','BOD. FARMANORTE 87','4','1800','7200','7200','0','7200','0','4','1','','31/05/2024','',12800,0,0,'7707397791636','DOLEX FORTE * 100 TAB','616','HALEON (GLAXO OTC)','2024-05-31 15:25:01',  148233, 63445, 223, 99),('FVE','FNVL','022248','2024-05-31 15:25:01','052024','CO','1045766738','DANIEL ','CASTANENA','3',' 9 3205011790','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','12','11905.882352941177','894.1176470588234','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:25:01','12800','87','BOD. FARMANORTE 87','8','700','5600','4705.8823529412','894.11764705882','5600','0','8','1','','31/05/2024','',12800,0,0,'8850769024852','EUGICA COFF HERBAL LOZENGES *120 TAB','802','MEGA WE CARE','2024-05-31 15:25:01',  42685.2, 62763, 223, 99),('FVE','FNVL','022249','2024-05-31 15:28:49','052024','CO','1082939368','DUVAN','DURAN','00',' 3008923996','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','15789.0756302521','510.92436974789916','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:28:49','16300','87','BOD. FARMANORTE 87','1','13100','13100','13100','0','13100','1','0','79','','31/05/2024','',1300,15000,0,'7709530287624','OFTAGENT GOTAS *5 ML','607','QUIRUPOS','2024-05-31 15:28:49',  7900.46, 57223, 223, 99),('FVE','FNVL','022249','2024-05-31 15:28:49','052024','CO','1082939368','DUVAN','DURAN','00',' 3008923996','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','15789.0756302521','510.92436974789916','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:28:49','16300','87','BOD. FARMANORTE 87','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','79','','31/05/2024','',1300,15000,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-05-31 15:28:49',  1806, 56307, 223, 99),('FVE','FNVL','022250','2024-05-31 15:39:35','052024','CO','36556574',' ANA MARIA','GARCIA','MZ D CASA 80 URB VILLA MARBELL',' 3215826584','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','6','17210.084033613446','989.9159663865548','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:39:36','18200','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','0','1','0','','31/05/2024','',500,17700,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-31 15:39:35',  53223.5, 41855, 223, 99),('FVE','FNVL','022250','2024-05-31 15:39:35','052024','CO','36556574',' ANA MARIA','GARCIA','MZ D CASA 80 URB VILLA MARBELL',' 3215826584','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','6','17210.084033613446','989.9159663865548','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:39:36','18200','87','BOD. FARMANORTE 87','2','3100','6200','5210.0840336134','989.91596638655','6200','2','0','0','','31/05/2024','',500,17700,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-05-31 15:39:35',  1768.4, 60339, 223, 99),('FVE','FNVL','022250','2024-05-31 15:39:35','052024','CO','36556574',' ANA MARIA','GARCIA','MZ D CASA 80 URB VILLA MARBELL',' 3215826584','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','6','17210.084033613446','989.9159663865548','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:39:36','18200','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',500,17700,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 15:39:35',  800, 48019, 223, 99),('FVE','FNVL','022250','2024-05-31 15:39:35','052024','CO','36556574',' ANA MARIA','GARCIA','MZ D CASA 80 URB VILLA MARBELL',' 3215826584','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','6','17210.084033613446','989.9159663865548','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:39:36','18200','87','BOD. FARMANORTE 87','2','1000','2000','2000','0','2000','2','0','0','','31/05/2024','',500,17700,0,'7702090037784','AGUA CRISTAL CON GAS BOTELLA *300 ML','192','POSTOBON GASEOSAS','2024-05-31 15:39:35',  583.3333, 52915, 223, 99),('FVE','FNVL','022251','2024-05-31 15:41:04','052024','CO','7702535022054','RONALD','RUIZ','',' 0 ','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','9596.638655462186','303.36134453781506','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:41:04','9900','87','BOD. FARMANORTE 87','1','6000','6000','6000','0','6000','0','1','0','','31/05/2024','',9900,0,0,'7707019381108','VIGRADINA 50 MG * 2 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-31 15:41:04',  2440, 45876, 223, 99),('FVE','FNVL','022251','2024-05-31 15:41:04','052024','CO','7702535022054','RONALD','RUIZ','',' 0 ','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','9596.638655462186','303.36134453781506','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:41:04','9900','87','BOD. FARMANORTE 87','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','31/05/2024','',9900,0,0,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-05-31 15:41:04',  1142.8, 60397, 223, 99),('FVE','FNVL','022251','2024-05-31 15:41:04','052024','CO','7702535022054','RONALD','RUIZ','',' 0 ','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','3','9596.638655462186','303.36134453781506','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:41:04','9900','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',9900,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 15:41:04',  800, 48019, 223, 99),('FVE','FNVL','022252','2024-05-31 15:54:09','052024','CO','1005710396','GUADLUPE ','REBOLLEDO ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','4500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 15:54:09','4500','87','BOD. FARMANORTE 87','1','4500','4500','4500','0','4500','0','1','0','','31/05/2024','',0,4500,0,'7707210530114','FORZ CREMA *24 SOBRES ','256','GERCO','2024-05-31 15:54:09',  57865, 46090, 223, 99),('FVE','FNVL','022253','2024-05-31 16:02:27','052024','CO','39031714','ENIRA','COLINA','',' NO DIO','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','49','39798.31932773109','3001.680672268907','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:02:27','42800','87','BOD. FARMANORTE 87','2','2','400','400','0','400','2','0','0','','31/05/2024','',42800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 16:02:27',  100, 44347, 223, 99),('FVE','FNVL','022253','2024-05-31 16:02:27','052024','CO','39031714','ENIRA','COLINA','',' NO DIO','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','49','39798.31932773109','3001.680672268907','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:02:27','42800','87','BOD. FARMANORTE 87','4','3100','12400','12400','0','12400','0','4','0','','31/05/2024','',42800,0,0,'7703445030153','FLUIMUCIL 600 MG *30 S/S ','397','ZAMBON COLOMBIA ','2024-05-31 16:02:27',  77290, 44302, 223, 99),('FVE','FNVL','022253','2024-05-31 16:02:27','052024','CO','39031714','ENIRA','COLINA','',' NO DIO','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','49','39798.31932773109','3001.680672268907','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:02:27','42800','87','BOD. FARMANORTE 87','4','2800','11200','11200','0','11200','0','4','0','','31/05/2024','',42800,0,0,'7707232098074','MIELTERTOS GRIPA NOCHE PANELA-LIMON *24 S/S','271','NATURAL FRESHLY','2024-05-31 16:02:27',  36283.5, 25785, 223, 99),('FVE','FNVL','022253','2024-05-31 16:02:27','052024','CO','39031714','ENIRA','COLINA','',' NO DIO','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','49','39798.31932773109','3001.680672268907','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:02:27','42800','87','BOD. FARMANORTE 87','40','470','18800','15798.319327731','3001.6806722689','18800','0','40','0','','31/05/2024','',42800,0,0,'7702184835982','VITAMINA C + ZINC TUTI FRUTI * 100 TAB','249','ECAR','2024-05-31 16:02:27',  15435, 58540, 223, 99),('FVE','FNVL','022254','2024-05-31 16:14:11','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','8900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:14:11','8900','87','BOD. FARMANORTE 87','1','8900','8900','8900','0','8900','1','0','0','','31/05/2024','',8900,0,0,'7501125104688','ELECTROLIT NARANJA-MANDARINA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-31 16:14:11',  6785, 47204, 223, 99),('FVE','FNVL','022255','2024-05-31 16:23:21','052024','CO','6625924','FABIAN ','CAMPO ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','10200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:23:22','10200','87','BOD. FARMANORTE 87','1','2200','2200','2200','0','2200','1','0','0','','31/05/2024','',10200,0,0,'6971831832204','EXTASIS LUBRICADO *3 PRESERVATIVOS','819','INOVY','2024-05-31 16:23:21',  900, 62041, 223, 99),('FVE','FNVL','022255','2024-05-31 16:23:21','052024','CO','6625924','FABIAN ','CAMPO ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','10200','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:23:22','10200','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','0','1','0','','31/05/2024','',10200,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-31 16:23:21',  53223.5, 41855, 223, 99),('FVE','FNVL','022256','2024-05-31 16:32:38','052024','CO','19516224','JOSE ','SIERRA','',' 3103644692','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','9','45199.15966386555','5300.840336134452','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:32:38','50500','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','138','','31/05/2024','',50500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 16:32:38',  100, 44347, 223, 99),('FVE','FNVL','022256','2024-05-31 16:32:38','052024','CO','19516224','JOSE ','SIERRA','',' 3103644692','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','9','45199.15966386555','5300.840336134452','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:32:38','50500','87','BOD. FARMANORTE 87','1','12200','12200','10252.100840336','1947.8991596639','12200','1','0','138','','31/05/2024','',50500,0,0,'7702626215235','K-Y GEL LUBRICANTE *15 GR','357','RECKITT BENCKISER COLOMBIA S A','2024-05-31 16:32:38',  7337, 54754, 223, 99),('FVE','FNVL','022256','2024-05-31 16:32:38','052024','CO','19516224','JOSE ','SIERRA','',' 3103644692','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','9','45199.15966386555','5300.840336134452','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:32:38','50500','87','BOD. FARMANORTE 87','1','17100','17100','17100','0','17100','1','0','138','','31/05/2024','',50500,0,0,'7702132008307','TODAY LONG ACTION *3 PRESERVATIVOS  ','616','HALEON (GLAXO OTC)','2024-05-31 16:32:38',  14339.2, 39151, 223, 99);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FNVL','022257','2024-05-31 16:54:14','052024','CO','1083012497','LINDA ','ARTEAGA ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','5700','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:54:15','5700','87','BOD. FARMANORTE 87','1','3000','3000','3000','0','3000','1','0','0','','31/05/2024','',5700,0,0,'7707282990786','VENDA ELASTICA 4 X 5 YARDAS PIEL BEGUT','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-31 16:54:14',  1796, 50107, 223, 99),('FVE','FNVL','022257','2024-05-31 16:54:14','052024','CO','1083012497','LINDA ','ARTEAGA ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','5700','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:54:15','5700','87','BOD. FARMANORTE 87','1','2700','2700','2700','0','2700','1','0','0','','31/05/2024','',5700,0,0,'7707228365746','ESPARADRAPO TELA BLANCO ALFASAFE 1 X 1 YD','429','ALFA SAFE','2024-05-31 16:54:14',  1600, 58642, 223, 99),('FVE','FNVL','022258','2024-05-31 16:59:06','052024','CO','39004204','PILAR','LLANOS','condomin ca ntilde averal  cas',' 3013713464','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','2689.075630252101','510.92436974789916','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 16:59:06','3200','87','BOD. FARMANORTE 87','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','31/05/2024','',3200,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-05-31 16:59:06',  1806, 56307, 223, 99),('FVE','FNVL','022259','2024-05-31 17:05:00','052024','CO','1083006042','FRANSISCO SIERRA','SANCHEZ','',' 3104563981','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','11600','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 17:05:00','11600','87','BOD. FARMANORTE 87','1','8900','8900','8900','0','8900','1','0','58','','31/05/2024','',0,11600,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-31 17:05:00',  6610, 54196, 223, 99),('FVE','FNVL','022259','2024-05-31 17:05:00','052024','CO','1083006042','FRANSISCO SIERRA','SANCHEZ','',' 3104563981','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','11600','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 17:05:00','11600','87','BOD. FARMANORTE 87','1','2700','2700','2700','0','2700','0','1','58','','31/05/2024','',0,11600,0,'7702057840310','SAL DE FRUTAS LUA *50 SOBRES','382','TECNOQUIMICAS','2024-05-31 17:05:00',  105944.66, 43290, 223, 99),('FVE','FNVL','022260','2024-05-31 17:39:38','052024','CO','36520680','ANA ','PE Ntilde ARAMDA ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','22500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 17:39:38','22500','87','BOD. FARMANORTE 87','1','22500','22500','22500','0','22500','1','0','1','','31/05/2024','',22500,0,0,'7702184021002','HEDERA HELIX + PROPOLEO JARABE FRASCO * 100 ML','249','ECAR','2024-05-31 17:39:38',  3000, 63778, 223, 99),('FVE','FNVL','022261','2024-05-31 18:01:13','052024','CO','1082845614','CINDY PAOLA','FLORES PUERTAS','KRA 21A 3 N 29G-38 LOS FAROLES',' 3046047442','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','114672.26890756303','10577.731092436974','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:01:16','125250','87','BOD. FARMANORTE 87','1','59000','59000','59000','0','59000','1','0','573','','31/05/2024','',0,115250,0,'7701684000135','ALMIPRO UNG PARA LA PAÑALITIS *500 GR','786','ALMIPRO','2024-05-31 18:01:13',  44242, 54420, 223, 99),('FVE','FNVL','022261','2024-05-31 18:01:13','052024','CO','1082845614','CINDY PAOLA','FLORES PUERTAS','KRA 21A 3 N 29G-38 LOS FAROLES',' 3046047442','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','2','114672.26890756303','10577.731092436974','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:01:16','125250','87','BOD. FARMANORTE 87','1','66250','66250','55672.268907563','10577.731092437','66250','1','0','573','10','31/05/2024','',0,115250,0,'7701021147585','WINNY ULTRATRIM SEC ET4 *50 UND ','653','TECNOQUIMICAS WINNY','2024-05-31 18:01:13',  50094, 48906, 223, 99),('FVE','FNVL','022262','2024-05-31 18:05:57','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:05:57','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 18:05:57',  800, 48019, 223, 99),('FVE','FNVL','022263','2024-05-31 18:24:07','052024','CO','85154076','ALEXANDER ','FERNANDES ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','10','3000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:24:07','3000','87','BOD. FARMANORTE 87','10','300','3000','3000','0','3000','0','10','0','','31/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-31 18:24:07',  28997, 54625, 223, 99),('FVE','FNVL','022264','2024-05-31 18:26:55','052024','CO','1067722094','YERIKA','CUDRIZ P eacute REZ ','BARRIO 11 DE NOV MANZANA 2 CAS',' 3043784605','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','22','7417.142857142857','542.8571428571427','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:26:55','7960','87','BOD. FARMANORTE 87','10','256','2560','2560','0','2560','0','10','1','','31/05/2024','',0,7960,0,'7702184010280','TIAMINA 300 MG *250 TAB','249','ECAR','2024-05-31 18:26:55',  47100, 29762, 223, 99),('FVE','FNVL','022264','2024-05-31 18:26:55','052024','CO','1067722094','YERIKA','CUDRIZ P eacute REZ ','BARRIO 11 DE NOV MANZANA 2 CAS',' 3043784605','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','22','7417.142857142857','542.8571428571427','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:26:55','7960','87','BOD. FARMANORTE 87','10','200','2000','2000','0','2000','0','10','1','','31/05/2024','',0,7960,0,'7702184010082','COMPLEJO B *250 GRAG ECAR','249','ECAR','2024-05-31 18:26:55',  37500, 29732, 223, 99),('FVE','FNVL','022264','2024-05-31 18:26:55','052024','CO','1067722094','YERIKA','CUDRIZ P eacute REZ ','BARRIO 11 DE NOV MANZANA 2 CAS',' 3043784605','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','22','7417.142857142857','542.8571428571427','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:26:55','7960','87','BOD. FARMANORTE 87','2','1700','3400','2857.1428571429','542.85714285714','3400','2','0','1','','31/05/2024','',0,7960,0,'7702189056245','CHOKIS CHOCOBASE *47 GR','762','FRITO LAY','2024-05-31 18:26:55',  1050, 57555, 223, 99),('FVE','FNVL','022265','2024-05-31 18:34:15','052024','CO','1002072007','JORGE','GUTIERREZ','DIVINO NI NTILDE O',' 3126745241 ','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','19900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:34:15','19900','87','BOD. FARMANORTE 87','1','19900','19900','19900','0','19900','1','0','0','','31/05/2024','',19900,0,0,'7702870002728','POSTDAY *2 TAB ','696','ABBOTT FARMA CONVENIO','2024-05-31 18:34:15',  18085, 31699, 223, 99),('FVE','FNVL','022266','2024-05-31 18:41:41','052024','CO','1098685933','JEFERSON','ANAYA','',' 3104062640','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','1001611782','1098721309','ARGUMEDO GARRIDO ANGEL RENE','','','2','27400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:41:41','27400','87','BOD. FARMANORTE 87','1','9000','9000','9000','0','9000','1','0','0','','31/05/2024','',0,27400,0,'7707019340204','SEAMIB 500 MG * 4 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-31 18:41:41',  2230, 45864, 223, 99),('FVE','FNVL','022266','2024-05-31 18:41:41','052024','CO','1098685933','JEFERSON','ANAYA','',' 3104062640','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','1001611782','1098721309','ARGUMEDO GARRIDO ANGEL RENE','','','2','27400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:41:41','27400','87','BOD. FARMANORTE 87','1','18400','18400','18400','0','18400','1','0','0','','31/05/2024','',0,27400,0,'7707263004518','KENCYCAPS 100MG *10 CAP  /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 18:41:41',  12159, 58219, 223, 99),('FVE','FNVL','022267','2024-05-31 18:49:22','052024','CO','57466864','SARIT','SALAS','Cra 21 A4 No. 29G-76, Barrio L',' 3003316743','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','19','32439.49579831933','3560.504201680671','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:49:22','36000','87','BOD. FARMANORTE 87','2','2','400','400','0','400','2','0','162','','31/05/2024','',0,36000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 18:49:22',  100, 44347, 223, 99),('FVE','FNVL','022267','2024-05-31 18:49:22','052024','CO','57466864','SARIT','SALAS','Cra 21 A4 No. 29G-76, Barrio L',' 3003316743','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','19','32439.49579831933','3560.504201680671','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:49:22','36000','87','BOD. FARMANORTE 87','5','1500','7500','7500','0','7500','0','5','162','','31/05/2024','',0,36000,0,'7707263004051','GRIPAC 4 * 100 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 18:49:22',  94299, 58014, 223, 99),('FVE','FNVL','022267','2024-05-31 18:49:22','052024','CO','57466864','SARIT','SALAS','Cra 21 A4 No. 29G-76, Barrio L',' 3003316743','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','19','32439.49579831933','3560.504201680671','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:49:22','36000','87','BOD. FARMANORTE 87','2','2900','5800','5800','0','5800','0','2','162','','31/05/2024','',0,36000,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-05-31 18:49:22',  18581.4, 46200, 223, 99),('FVE','FNVL','022267','2024-05-31 18:49:22','052024','CO','57466864','SARIT','SALAS','Cra 21 A4 No. 29G-76, Barrio L',' 3003316743','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','19','32439.49579831933','3560.504201680671','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:49:22','36000','87','BOD. FARMANORTE 87','1','17600','17600','14789.915966387','2810.0840336134','17600','1','0','162','','31/05/2024','',0,36000,0,'7709442489222','NUTRAGUM KIDS BOLSA * 45 GOMAS','694','N&F COLOMBIA','2024-05-31 18:49:22',  7728, 49170, 223, 99),('FVE','FNVL','022267','2024-05-31 18:49:22','052024','CO','57466864','SARIT','SALAS','Cra 21 A4 No. 29G-76, Barrio L',' 3003316743','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','553543','6881902','GRONDONA SEVERICH JAIME ALBERTO','','','19','32439.49579831933','3560.504201680671','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:49:22','36000','87','BOD. FARMANORTE 87','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','162','','31/05/2024','',0,36000,0,'7702184835982','VITAMINA C + ZINC TUTI FRUTI * 100 TAB','249','ECAR','2024-05-31 18:49:22',  15435, 58540, 223, 99),('FVE','FNVL','022268','2024-05-31 18:59:12','052024','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','1600','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 18:59:12','1600','87','BOD. FARMANORTE 87','1','1600','1600','1600','0','1600','0','1','0','','31/05/2024','',1600,0,0,'7703546701518','CONGESTEX BEBIDA CALIENTE LIMON * 30 S/S L-TR-CAPS','630','NOVAMED OTC','2024-05-31 18:59:12',  42347, 49747, 223, 99),('FVE','FNVL','022269','2024-05-31 19:04:02','052024','CO','1082836735','RAFAEL ','COGOLLO','CARRERA 21C  29K- 21 LAURELES ',' 3002177623','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','10','13000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:04:03','13000','87','BOD. FARMANORTE 87','10','1300','13000','13000','0','13000','0','10','65','','31/05/2024','',13000,0,0,'7702057074838','METOCARBAMOL 750 MG *20 TAB','654','MK ETICOS CONVENIO','2024-05-31 19:04:02',  16516.61, 43129, 223, 99),('FVE','FNVL','022270','2024-05-31 19:10:08','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','3','2436.9747899159665','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:10:08','2900','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','0','2','12','','31/05/2024','',2900,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-31 19:10:08',  9360, 46328, 223, 99),('FVE','FNVL','022270','2024-05-31 19:10:08','052024','CO','12536566','ALVARO ENRIQUE','VARGAS MARTINEZZ','',' 3126895296','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','3','2436.9747899159665','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:10:08','2900','87','BOD. FARMANORTE 87','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','12','','31/05/2024','',2900,0,0,'7622210427076','HALLS BARRA MENTA AZUL *9 PASTILLAS','754','DISCOB NORTE SAS','2024-05-31 19:10:08',  1176.5, 48069, 223, 99),('FVE','FNVL','022271','2024-05-31 19:12:30','052024','CO','1082964329','EFRAIN','TORRES','bgvhfdty',' 3004578412','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','4','27500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:12:31','27500','87','BOD. FARMANORTE 87','3','9100','27300','27300','0','27300','3','0','138','','31/05/2024','',27500,0,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-05-31 19:12:30',  8329, 52291, 223, 99),('FVE','FNVL','022271','2024-05-31 19:12:30','052024','CO','1082964329','EFRAIN','TORRES','bgvhfdty',' 3004578412','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','4','27500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:12:31','27500','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','138','','31/05/2024','',27500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 19:12:30',  100, 44347, 223, 99),('FVE','FNVL','022272','2024-05-31 19:13:54','052024','CO','27017140','PATRIC ','TRECE ','',' 00','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','1','7394.957983193278','1405.0420168067221','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:13:55','8800','87','BOD. FARMANORTE 87','1','8800','8800','7394.9579831933','1405.0420168067','8800','1','0','0','','31/05/2024','',0,8800,0,'7702189036629','DETODITO MIX *165 GR','762','FRITO LAY','2024-05-31 19:13:54',  5714, 34700, 223, 99),('FVE','FNVL','022273','2024-05-31 19:23:22','052024','CO','32985204','MIGUEL','ACOSTA','',' 3201565487','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','3','6134.453781512605','1165.5462184873945','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:23:22','7300','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','31/05/2024','',7300,0,0,'7702189056795','CHEESE TRIS CHEETOS HORNEADOS *80 GR','762','FRITO LAY','2024-05-31 19:23:22',  2173, 59002, 223, 99),('FVE','FNVL','022273','2024-05-31 19:23:22','052024','CO','32985204','MIGUEL','ACOSTA','',' 3201565487','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','3','6134.453781512605','1165.5462184873945','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:23:22','7300','87','BOD. FARMANORTE 87','2','1900','3800','3193.2773109244','606.72268907563','3800','2','0','0','','31/05/2024','',7300,0,0,'7702189056788','CHEESE TRIS CHEETOS HORNEADOS *42 GR','762','FRITO LAY','2024-05-31 19:23:22',  1160, 59055, 223, 99),('FVE','FNVL','022274','2024-05-31 19:26:29','052024','CO','1004162338','EDUIN','CORREA','',' 000','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','17','9611.764705882353','1788.2352941176468','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:26:29','11400','87','BOD. FARMANORTE 87','1','200','200','200','0','200','1','0','0','','31/05/2024','',11400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 19:26:29',  100, 44347, 223, 99),('FVE','FNVL','022274','2024-05-31 19:26:29','052024','CO','1004162338','EDUIN','CORREA','',' 000','2718','YERIKA','CUDRIZ PéREZ ','','TERCERO','VARIOS','','','','','','17','9611.764705882353','1788.2352941176468','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:26:29','11400','87','BOD. FARMANORTE 87','16','700','11200','9411.7647058824','1788.2352941176','11200','0','16','0','','31/05/2024','',11400,0,0,'8850769024852','EUGICA COFF HERBAL LOZENGES *120 TAB','802','MEGA WE CARE','2024-05-31 19:26:29',  42685.2, 62763, 223, 99),('FVE','FNVL','022275','2024-05-31 19:39:58','052024','CO','7141201','LUIS EMILIO','REDONDO TEJEDA','CR 21 A 4 N 29 F 353 VILLA BEL',' 3135792762','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','15800','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:39:58','15800','87','BOD. FARMANORTE 87','1','15800','15800','15800','0','15800','1','0','79','','31/05/2024','',15800,0,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-05-31 19:39:58',  14234, 54385, 223, 99),('FVE','FNVL','022276','2024-05-31 19:42:39','052024','CO','57299967','VIKY','WILCHES','',' 0','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','15','18900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:42:40','18900','87','BOD. FARMANORTE 87','10','800','8000','8000','0','8000','0','10','0','','31/05/2024','',18900,0,0,'7703363005554','DOLEX 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-31 19:42:39',  65149.5, 33555, 223, 99),('FVE','FNVL','022276','2024-05-31 19:42:39','052024','CO','57299967','VIKY','WILCHES','',' 0','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','15','18900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:42:40','18900','87','BOD. FARMANORTE 87','2','2900','5800','5800','0','5800','0','2','0','','31/05/2024','',18900,0,0,'7702057160999','NORAVER GRIPA BEBIDA NOCHE *24 SOBRES','382','TECNOQUIMICAS','2024-05-31 19:42:39',  54049.64, 33743, 223, 99),('FVE','FNVL','022276','2024-05-31 19:42:39','052024','CO','57299967','VIKY','WILCHES','',' 0','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','15','18900','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:42:40','18900','87','BOD. FARMANORTE 87','3','1700','5100','5100','0','5100','0','3','0','','31/05/2024','',18900,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-05-31 19:42:39',  50000, 31759, 223, 99),('FVE','FNVL','022277','2024-05-31 19:56:57','052024','CO','108291714','ROSA','CERVANTES','',' 0','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 19:56:58','15000','87','BOD. FARMANORTE 87','1','15000','15000','15000','0','15000','1','0','0','','31/05/2024','',15000,0,0,'7703546034029','LIBELLE * 2 TAB L-CONSUM','630','NOVAMED OTC','2024-05-31 19:56:57',  17031, 54785, 223, 99),('FVE','FNVL','022278','2024-05-31 20:01:36','052024','CO','1082865349','MICBETH','PACHECO','CRA 21A  CLL 69E-45 DETRAS DE ',' 3146401819','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','2','17400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 20:01:36','17400','87','BOD. FARMANORTE 87','1','15400','15400','15400','0','15400','1','0','0','','31/05/2024','',17400,0,0,'7707019314113','EUMOXINA 250MG/5ML SUSP FCO *100 ML','130','LABQUIFAR PHARMACEUTICA','2024-05-31 20:01:36',  8160, 45840, 223, 99),('FVE','FNVL','022278','2024-05-31 20:01:36','052024','CO','1082865349','MICBETH','PACHECO','CRA 21A  CLL 69E-45 DETRAS DE ',' 3146401819','3164','ARELIS ESTHER','VARGAS GALLARDO ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','2','17400','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 20:01:36','17400','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',17400,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 20:01:36',  1500, 44348, 223, 99),('FVE','FNVL','022279','2024-05-31 20:03:55','052024','CO','1080421297','MARIANGEL','RIASGOS','',' 0','3164','ARELIS ESTHER','VARGAS GALLARDO ','','TERCERO','VARIOS','','','','','','1','5500','0','87','FARMANORTE 87','ADMINISTRADOR','2024-05-31 20:03:55','5500','87','BOD. FARMANORTE 87','1','5500','5500','5500','0','5500','1','0','0','','31/05/2024','',5500,0,0,'7706569001443','NAPROXENO 250MG *10 TAB','614','A.G. MEDICAMENTOS','2024-05-31 20:03:55',  4157, 31629, 223, 99);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '052024' AND DECODBOD='87';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '052024' AND DECODBOD='87';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '052024' AND DECODBOD='87';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '052024' AND DECODBOD='87';
