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','FNK','017541','2024-02-28 09:00:17','022024','CO','1091673013','HAMILTON','PE Ntilde ARANDA','Manzana f2 casa 2 apto 101   a',' 3226105173','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','2','24428.57142857143','4261.428571428569','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 09:00:17','28690','09','BOD. FARMANORTE 09','1','26690','26690','22428.571428571','4261.4285714286','26690','1','0','0','','28/02/2024','',28690,0,0,'7702277623724','ARRURRU SHAMPOO & BAÑO LIQ 2EN1 ORIGINAL *750ML','124','BELLEZA EXPRESS SA','2024-02-28 09:00:17',  20578.5, 61985, 11, 9),('FVE','FNK','017542','2024-02-28 09:40:54','022024','CO','88201881','JOSE ARMANDO','CRISTANCHO RUIZ','','123 3005674119','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','26218.487394957985','4981.512605042015','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 09:40:54','31200','09','BOD. FARMANORTE 09','1','31200','31200','26218.487394958','4981.512605042','31200','1','0','0','','28/02/2024','',31200,0,0,'7702027478024','TENA SLIP CLASICO (ANTES BASIC) XL X 9 UND','337','FAMILIA SANCELA','2024-02-28 09:40:54',  25291, 51918, 11, 9),('FVE','FNK','017543','2024-02-28 10:52:38','022024','CO','9830321','JOSE','COLMENARES','',' 0','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','10500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 10:52:38','10500','09','BOD. FARMANORTE 09','1','10500','10500','10500','0','10500','1','0','0','','28/02/2024','',10500,0,0,'7706569001269','CLOTRIMAZOL CREMA TOPICA *40 GR','614','A.G. MEDICAMENTOS','2024-02-28 10:52:38',  7803, 31314, 11, 9),('FVE','FNK','017544','2024-02-28 11:09:41','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','4000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 11:09:41','4000','09','BOD. FARMANORTE 09','2','2000','4000','4000','0','4000','0','2','0','','28/02/2024','',4000,0,0,'7708152336758','SUREZINC TRANSFER VAINILLA * 36 S/S','1007','SUREZINC','2024-02-28 11:09:41',  25000, 62424, 11, 9),('FVE','FNK','017545','2024-02-28 11:39:30','022024','CO','1090450589','JHON JAIRO','ANGARITA BUITRAGO ','calle 27 #1-59 cumbres del nor',' 3103527457','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','211100','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 11:39:30','211100','09','BOD. FARMANORTE 09','1','211100','211100','211100','0','211100','1','0','0','','28/02/2024','',211100,0,0,'7703153035310','JARIT 200 MG *30 CAP','910','PROCAPS RX','2024-02-28 11:39:30',  198000, 25175, 11, 9),('FVE','FNK','017546','2024-02-28 12:00:12','022024','CO','1090414754','ANDREA','GOMEZ','','3134647494  3222222222','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','9900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:00:12','9900','09','BOD. FARMANORTE 09','1','9900','9900','9900','0','9900','1','0','0','7','28/02/2024','',9900,0,0,'7702057613204','DULOXETINA 30 MG CJA *7 TAB','654','MK ETICOS CONVENIO','2024-02-28 12:00:12',  6943, 37320, 11, 9),('FVE','FNK','017547','2024-02-28 12:04:23','022024','CO','1093771796','KAREN ','CASTRO','AVENIDA 8 #9-13 PANAMERICANO',' 3213954548','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3319','LUIS FERNANDO','PRADA CUADROS','','','','','','2','76800','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:04:23','76800','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','28/02/2024','',0,76800,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 12:04:23',  1500, 44348, 11, 9),('FVE','FNK','017547','2024-02-28 12:04:23','022024','CO','1093771796','KAREN ','CASTRO','AVENIDA 8 #9-13 PANAMERICANO',' 3213954548','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3319','LUIS FERNANDO','PRADA CUADROS','','','','','','2','76800','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:04:23','76800','09','BOD. FARMANORTE 09','1','74800','74800','74800','0','74800','1','0','0','14','28/02/2024','',0,76800,0,'7702024076490','KLIM 3+ CAJA *1800 GR','311','NESTLE NUTRICION','2024-02-28 12:04:23',  81288, 54121, 11, 9),('FVE','FNK','017548','2024-02-28 12:12:38','022024','CO','1004879101','DAYANA MELISSA','GARCIA CORDOBA','av 9 #5-45 barrio panamericano',' 3168105738','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3319','LUIS FERNANDO','PRADA CUADROS','','','','','','7','32918.487394957985','3081.5126050420154','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:12:38','36000','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','28/02/2024','',36000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 12:12:38',  100, 44347, 11, 9),('FVE','FNK','017548','2024-02-28 12:12:38','022024','CO','1004879101','DAYANA MELISSA','GARCIA CORDOBA','av 9 #5-45 barrio panamericano',' 3168105738','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3319','LUIS FERNANDO','PRADA CUADROS','','','','','','7','32918.487394957985','3081.5126050420154','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:12:38','36000','09','BOD. FARMANORTE 09','3','500','1500','1260.5042016807','239.49579831933','1500','3','0','0','','28/02/2024','',36000,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-02-28 12:12:38',  255, 46100, 11, 9),('FVE','FNK','017548','2024-02-28 12:12:38','022024','CO','1004879101','DAYANA MELISSA','GARCIA CORDOBA','av 9 #5-45 barrio panamericano',' 3168105738','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3319','LUIS FERNANDO','PRADA CUADROS','','','','','','7','32918.487394957985','3081.5126050420154','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:12:38','36000','09','BOD. FARMANORTE 09','1','14500','14500','14500','0','14500','1','0','0','','28/02/2024','',36000,0,0,'7703546043038','CRONOFEN NIÑOS CEREZA GOTAS * 30 ML   L-RESPI-RIN','1039','NOVAMED BABY ','2024-02-28 12:12:38',  12674, 38543, 11, 9),('FVE','FNK','017548','2024-02-28 12:12:38','022024','CO','1004879101','DAYANA MELISSA','GARCIA CORDOBA','av 9 #5-45 barrio panamericano',' 3168105738','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3319','LUIS FERNANDO','PRADA CUADROS','','','','','','7','32918.487394957985','3081.5126050420154','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:12:38','36000','09','BOD. FARMANORTE 09','1','17800','17800','14957.983193277','2842.0168067227','17800','1','0','0','','28/02/2024','',36000,0,0,'7709285612627','TERMOMETRO DIGITAL MODELO MT-502B','750','DIAGNOSTICOS BIOMEDICOS','2024-02-28 12:12:38',  6000, 57559, 11, 9),('FVE','FNK','017548','2024-02-28 12:12:38','022024','CO','1004879101','DAYANA MELISSA','GARCIA CORDOBA','av 9 #5-45 barrio panamericano',' 3168105738','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3319','LUIS FERNANDO','PRADA CUADROS','','','','','','7','32918.487394957985','3081.5126050420154','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:12:38','36000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','28/02/2024','',36000,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 12:12:38',  1500, 44348, 11, 9),('FVE','FNK','017549','2024-02-28 12:47:38','022024','CO','1092941732','ADRIANA','JARAMILLO','Calle 14 #10-10 barrio toledo','  3223188743','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','33000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:47:38','33000','09','BOD. FARMANORTE 09','1','33000','33000','33000','0','33000','1','0','0','','28/02/2024','',8000,25000,0,'7707019402117','COLESPAS 10 MG CJA *30 TAB','130','LABQUIFAR PHARMACEUTICA','2024-02-28 12:47:38',  11800, 53948, 11, 9),('FVE','FNK','017550','2024-02-28 12:59:54','022024','CO','1090444006','ESDRAS','AGUILAR','',' 3145351564','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','13100','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 12:59:55','13100','09','BOD. FARMANORTE 09','1','13100','13100','13100','0','13100','1','0','0','','28/02/2024','',0,13100,0,'7709530287624','OFTAGENT GOTAS *5 ML','607','QUIRUPOS','2024-02-28 12:59:54',  7900.46, 57223, 11, 9),('FVE','FNK','017551','2024-02-28 13:02:53','022024','CO','27067219','JOSE','ISEA','',' 3114871054','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','10266.38655462185','1133.6134453781506','09','FARMANORTE 09','VENDEDOR','2024-02-28 13:02:53','11400','09','BOD. FARMANORTE 09','2','2150','4300','4300','0','4300','0','2','0','','28/02/2024','',11400,0,0,'7702057092757','IBUFLASH MIGRAN *30 CAP','382','TECNOQUIMICAS','2024-02-28 13:02:53',  50677.65, 58898, 11, 9),('FVE','FNK','017551','2024-02-28 13:02:53','022024','CO','27067219','JOSE','ISEA','',' 3114871054','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','10266.38655462185','1133.6134453781506','09','FARMANORTE 09','VENDEDOR','2024-02-28 13:02:53','11400','09','BOD. FARMANORTE 09','1','7100','7100','5966.3865546218','1133.6134453782','7100','1','0','0','','28/02/2024','',11400,0,0,'7702090064209','GASEOSA PEPSI *2.5 LT','192','POSTOBON GASEOSAS','2024-02-28 13:02:53',  3503.2, 58758, 11, 9),('FVE','FNK','017552','2024-02-28 13:13:45','022024','CO','1090427763','ARLEDIS','SANABRIA RAMIREZ','0',' 3123154238','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','8900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 13:13:45','8900','09','BOD. FARMANORTE 09','1','8900','8900','8900','0','8900','1','0','0','','28/02/2024','',8900,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-02-28 13:13:45',  6610, 54196, 11, 9),('FVE','FNK','017553','2024-02-28 13:24:10','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','3277.310924369748','622.6890756302519','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 13:24:10','3900','09','BOD. FARMANORTE 09','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','28/02/2024','',3900,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','POSTOBON GASEOSAS','2024-02-28 13:24:10',  2451, 25826, 11, 9),('FVE','FNK','017554','2024-02-28 14:36:24','022024','CO','1004809795','DAYANA','CHACON','',' 3212696481','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','3529.4117647058824','670.5882352941176','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 14:36:24','4200','09','BOD. FARMANORTE 09','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','28/02/2024','',4200,0,0,'7702402051361','HELADO CASERO RON CON PASAS *60 GR','296','MEALS DE COLOMBIA','2024-02-28 14:36:24',  1206, 52362, 11, 9),('FVE','FNK','017554','2024-02-28 14:36:24','022024','CO','1004809795','DAYANA','CHACON','',' 3212696481','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','3529.4117647058824','670.5882352941176','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 14:36:24','4200','09','BOD. FARMANORTE 09','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','28/02/2024','',4200,0,0,'7702402051347','HELADO CASERO GUANABANA *60 GR','296','MEALS DE COLOMBIA','2024-02-28 14:36:24',  1206, 50721, 11, 9),('FVE','FNK','017555','2024-02-28 14:44:02','022024','CO','1093772302','DISNEY ','BEJARANO ','AV 7 CLL 18 NUMER 7-31 EL SALA','0000000000 3147373028','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','11','4012.6050420168067','287.3949579831933','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 14:44:02','4300','09','BOD. FARMANORTE 09','10','250','2500','2500','0','2500','0','10','0','','28/02/2024','',4300,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-02-28 14:44:02',  28997, 54625, 11, 9),('FVE','FNK','017555','2024-02-28 14:44:02','022024','CO','1093772302','DISNEY ','BEJARANO ','AV 7 CLL 18 NUMER 7-31 EL SALA','0000000000 3147373028','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','11','4012.6050420168067','287.3949579831933','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 14:44:02','4300','09','BOD. FARMANORTE 09','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','28/02/2024','',4300,0,0,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2024-02-28 14:44:02',  1159, 58744, 11, 9),('FVE','FNK','017556','2024-02-28 15:16:17','022024','CO','1090461241','JAIME ','ROJAS','avenida 9 #2-15 panamericano','2 3176457353','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','124700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 15:16:18','124700','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','28/02/2024','',124700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 15:16:17',  100, 44347, 11, 9),('FVE','FNK','017556','2024-02-28 15:16:17','022024','CO','1090461241','JAIME ','ROJAS','avenida 9 #2-15 panamericano','2 3176457353','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','124700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 15:16:18','124700','09','BOD. FARMANORTE 09','1','122500','122500','122500','0','122500','1','0','0','','28/02/2024','',124700,0,0,'7506205811357','ENFAMIL PREMIUM 2 PROMENTAL *800 GR  ','295','MEAD JOHNSON NUTRITION COLOMBIA','2024-02-28 15:16:17',  113850, 50175, 11, 9),('FVE','FNK','017556','2024-02-28 15:16:17','022024','CO','1090461241','JAIME ','ROJAS','avenida 9 #2-15 panamericano','2 3176457353','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','124700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 15:16:18','124700','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','28/02/2024','',124700,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 15:16:17',  1500, 44348, 11, 9),('FVE','FNK','017557','2024-02-28 15:32:58','022024','CO','1056688459','DANILO','GUERRERO','',' 0 3134151172','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','2','41145.378151260506','4454.621848739494','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 15:32:59','45600','09','BOD. FARMANORTE 09','1','17700','17700','17700','0','17700','1','0','0','','28/02/2024','',45600,0,0,'7702057109714','CREMA N4 MEDICADA *30 GR','889','TECNOQUIMICAS CONSUMO','2024-02-28 15:32:58',  14011, 42897, 11, 9),('FVE','FNK','017557','2024-02-28 15:32:58','022024','CO','1056688459','DANILO','GUERRERO','',' 0 3134151172','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','2','41145.378151260506','4454.621848739494','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 15:32:59','45600','09','BOD. FARMANORTE 09','1','27900','27900','23445.378151261','4454.6218487395','27900','1','0','0','','28/02/2024','',45600,0,0,'7701021115805','WINNY ULTRATRIM SEC ET2 *30 +10 TOALLITAS','653','TECNOQUIMICAS WINNY','2024-02-28 15:32:58',  20453.4, 33276, 11, 9),('FVE','FNK','017558','2024-02-28 15:45:43','022024','CO','1005040105','FRANQUIL','MARTINEZ','',' 0','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','4','6000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 15:45:43','6000','09','BOD. FARMANORTE 09','4','1500','6000','6000','0','6000','0','4','0','','28/02/2024','',6000,0,0,'7703546703109','NAPROFLASH 250MG * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2024-02-28 15:45:43',  64680, 55343, 11, 9),('FVE','FNK','017559','2024-02-28 16:37:02','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569286','569286','AROCA BLANCO ASDRUBAL JOSE','','','7','57200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:37:02','57200','09','BOD. FARMANORTE 09','1','15400','15400','15400','0','15400','1','0','0','','28/02/2024','',57200,0,0,'7707019401950','FIREXIFEN JARABE *120 ML','130','LABQUIFAR PHARMACEUTICA','2024-02-28 16:37:02',  7700, 45885, 11, 9),('FVE','FNK','017559','2024-02-28 16:37:02','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569286','569286','AROCA BLANCO ASDRUBAL JOSE','','','7','57200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:37:02','57200','09','BOD. FARMANORTE 09','1','20000','20000','20000','0','20000','1','0','0','','28/02/2024','',57200,0,0,'7707019314229','SUPRIBAC F SUSP * 120 ML','130','LABQUIFAR PHARMACEUTICA','2024-02-28 16:37:02',  9330, 41317, 11, 9),('FVE','FNK','017559','2024-02-28 16:37:02','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569286','569286','AROCA BLANCO ASDRUBAL JOSE','','','7','57200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:37:02','57200','09','BOD. FARMANORTE 09','3','3500','10500','10500','0','10500','0','3','0','','28/02/2024','',57200,0,0,'7709990110999','COPROBIOTIC+PREBIOTICOS+PROBIOTICOS CJA *20S/S','1000','NATURALMENTE','2024-02-28 16:37:02',  28600, 61315, 11, 9),('FVE','FNK','017559','2024-02-28 16:37:02','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569286','569286','AROCA BLANCO ASDRUBAL JOSE','','','7','57200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:37:02','57200','09','BOD. FARMANORTE 09','1','9300','9300','9300','0','9300','1','0','0','','28/02/2024','',57200,0,0,'7702057010874','HIDRAPLUS 75 ZINC CEREZA *400 ML ','877','TECNOQUIMICAS VM TQ','2024-02-28 16:37:02',  8146.8, 46788, 11, 9),('FVE','FNK','017559','2024-02-28 16:37:02','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569286','569286','AROCA BLANCO ASDRUBAL JOSE','','','7','57200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:37:02','57200','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','28/02/2024','',57200,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 16:37:02',  1500, 44348, 11, 9),('FVE','FNK','017560','2024-02-28 16:42:57','022024','CO','63504766','SUSANA','CARRE Ntilde O','',' 3247423770','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','10','4500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:42:57','4500','09','BOD. FARMANORTE 09','10','450','4500','4500','0','4500','0','10','0','','28/02/2024','',4500,0,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-02-28 16:42:57',  13144, 31502, 11, 9),('FVE','FNK','017561','2024-02-28 16:43:39','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','3','111200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:43:39','111200','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','28/02/2024','',0,111200,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 16:43:39',  100, 44347, 11, 9),('FVE','FNK','017561','2024-02-28 16:43:39','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','3','111200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:43:39','111200','09','BOD. FARMANORTE 09','1','88000','88000','88000','0','88000','1','0','0','25','28/02/2024','',0,111200,0,'7708152336604','SUREZINC TRANSFER KIDS FRESA * 1000 GR','1007','SUREZINC','2024-02-28 16:43:39',  29650, 61607, 11, 9),('FVE','FNK','017561','2024-02-28 16:43:39','022024','CO','1090466240','YURLEY','QUINTERO','0','  3146172719','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','3','111200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:43:39','111200','09','BOD. FARMANORTE 09','1','23000','23000','23000','0','23000','1','0','0','','28/02/2024','',0,111200,0,'7707172681114','EMULSION DE SCOTT CEREZA *360 ML','616','HALEON (GLAXO OTC)','2024-02-28 16:43:39',  20008, 26553, 11, 9),('FVE','FNK','017562','2024-02-28 16:47:50','022024','CO','37272373','ALEYDA','SINISTERRA SINISTERRA ','',' 3123282493','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','1','74800','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:47:52','74800','09','BOD. FARMANORTE 09','1','74800','74800','74800','0','74800','1','0','1','','28/02/2024','',66200,0,0,'7702024076490','KLIM 3+ CAJA *1800 GR','311','NESTLE NUTRICION','2024-02-28 16:47:50',  81288, 54121, 11, 9),('FVE','FNK','017563','2024-02-28 16:49:16','022024','CO','1092358414','NELSON','RESTREPO','CALLE 11N #3A-54 BOSQUE PARAIS',' 322 3082748','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','2','65613.44537815126','12086.554621848736','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:49:16','77700','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','28/02/2024','',77700,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 16:49:16',  1500, 44348, 11, 9);
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','FNK','017564','2024-02-28 16:50:46','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','1','25900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:50:46','25900','09','BOD. FARMANORTE 09','1','25900','25900','25900','0','25900','1','0','0','','28/02/2024','',25900,0,0,'7702626214849','STREPSILS INTENSIVE MIEL-LIMON *16 TAB','357','RECKITT BENCKISER COLOMBIA S A','2024-02-28 16:50:46',  20656, 53074, 11, 9),('FVE','FNK','017565','2024-02-28 16:51:21','022024','CO','27577870','ANA','ESLAVA','Manzana G.1 - Casa 13 - Tercer','   321.215.7669','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','2','31831.932773109245','5668.067226890755','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:51:22','37500','09','BOD. FARMANORTE 09','1','35500','35500','29831.932773109','5668.0672268908','35500','1','0','0','','28/02/2024','',37500,0,0,'7501057006432','LUBRIDERM EXTRA HUMECTANTE *400 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-02-28 16:51:21',  25303, 28137, 11, 9),('FVE','FNK','017565','2024-02-28 16:51:21','022024','CO','27577870','ANA','ESLAVA','Manzana G.1 - Casa 13 - Tercer','   321.215.7669','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','2','31831.932773109245','5668.067226890755','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:51:22','37500','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','28/02/2024','',37500,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 16:51:21',  1500, 44348, 11, 9),('FVE','FNK','017566','2024-02-28 16:53:48','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','8','41000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:53:48','41000','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','28/02/2024','',0,41000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 16:53:48',  100, 44347, 11, 9),('FVE','FNK','017566','2024-02-28 16:53:48','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','8','41000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:53:48','41000','09','BOD. FARMANORTE 09','1','30800','30800','30800','0','30800','1','0','0','','28/02/2024','',0,41000,0,'7702132009748','ADVIL CHILDREN *100 ML ','616','HALEON (GLAXO OTC)','2024-02-28 16:53:48',  28044, 46798, 11, 9),('FVE','FNK','017566','2024-02-28 16:53:48','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','8','41000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:53:48','41000','09','BOD. FARMANORTE 09','5','1600','8000','8000','0','8000','0','5','0','','28/02/2024','',0,41000,0,'7703445030047','FLUIMUCIL 200 MG *30 S/S ','397','ZAMBON COLOMBIA ','2024-02-28 16:53:48',  43192.8, 44300, 11, 9),('FVE','FNK','017566','2024-02-28 16:53:48','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','8','41000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 16:53:48','41000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','28/02/2024','',0,41000,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 16:53:48',  1500, 44348, 11, 9),('FVE','FNK','017567','2024-02-28 17:09:56','022024','CO','88229433','JOSEE','PRADA','',' 0','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','16638.655462184874','3161.3445378151264','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:09:56','19800','09','BOD. FARMANORTE 09','2','9900','19800','16638.655462185','3161.3445378151','19800','2','0','0','','28/02/2024','',19800,0,0,'D1554','MEGA VIT ADVANCE *2 TAB','813','NATURALS IMPORTADOS','2024-02-28 17:09:56',  800, 56917, 11, 9),('FVE','FNK','017568','2024-02-28 17:14:17','022024','CO','7260108','MIRIAM','SEQUEDA','',' 3044929756','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','5900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:14:17','5900','09','BOD. FARMANORTE 09','1','5900','5900','5900','0','5900','1','0','0','','28/02/2024','',5900,0,0,'7706569001467','CETIRIZINA 10MG *10 TAB','614','A.G. MEDICAMENTOS','2024-02-28 17:14:17',  4488, 31293, 11, 9),('FVE','FNK','017569','2024-02-28 17:16:53','022024','CO','1090389726','DAYANNA ','PINZON','1',' 3223529586  3223529586 ','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','10500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:16:53','10500','09','BOD. FARMANORTE 09','1','10500','10500','10500','0','10500','1','0','0','','28/02/2024','',10500,0,0,'7709299854228','PRUEBA DE EMBARAZO ESFERO ','398','ZIBOJECT','2024-02-28 17:16:53',  3150, 55608, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','28/02/2024','',257900,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 17:33:02',  100, 44347, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','10','1200','12000','12000','0','12000','0','10','0','','28/02/2024','',257900,0,0,'8850769020106','ZIRIN 10 MG CJA * 50 CAPS','802','MEGA WE CARE','2024-02-28 17:33:02',  47007, 55996, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','1','18500','18500','18500','0','18500','1','0','0','','28/02/2024','',257900,0,0,'7703712080218','HISLORT 10 MG CJA * 10 TB /D24/','387','TRIDEX FARMACEUTICA','2024-02-28 17:33:02',  15000, 22185, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','1','70300','70300','70300','0','70300','1','0','0','','28/02/2024','',257900,0,0,'7707274721930','CLAVUTEC 500/125MG *14 TAB','181','FAES FARMA','2024-02-28 17:33:02',  65837.4, 33399, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','1','3900','3900','3900','0','3900','0','1','0','','28/02/2024','',257900,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-02-28 17:33:02',  7000, 23704, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','1','16500','16500','16500','0','16500','1','0','0','','28/02/2024','',257900,0,0,'7707019413632','CORTISOLONA 1% CREMA *40 GR','130','LABQUIFAR PHARMACEUTICA','2024-02-28 17:33:02',  6570, 61061, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','1','136000','136000','136000','0','136000','1','0','0','','28/02/2024','',257900,0,0,'7703546702041','AZEFLU SPRAY NASAL * 30 ML','314','NOVAMED FARMA','2024-02-28 17:33:02',  118883, 55637, 11, 9),('FVE','FNK','017570','2024-02-28 17:33:02','022024','CO','1093767601','JENNIFER','VELOZA RAMIREZ','',' 3124335758','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','17','257820.16806722688','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:33:03','257900','09','BOD. FARMANORTE 09','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','28/02/2024','',257900,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-02-28 17:33:02',  255, 46100, 11, 9),('FVE','FNK','017571','2024-02-28 17:35:39','022024','CO','7260108','MIRIAM','SEQUEDA','',' 3044929756','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','28600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 17:35:39','28600','09','BOD. FARMANORTE 09','1','28600','28600','28600','0','28600','1','0','0','','28/02/2024','',28600,0,0,'7707232096186','CLORURO DE MAGNESIO *50 CAP','271','NATURAL FRESHLY','2024-02-28 17:35:39',  17022.96, 46205, 11, 9),('FVE','FNK','017572','2024-02-28 17:59:26','022024','CR','1093781128','CRUZ DELINA','VERA FLOREZ','AV 10 MZ 18 LTE 229 VIDELSO LO',' 3154372806','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','988893','1','22700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 18:08:33','22700','09','BOD. FARMANORTE 09','1','22700','22700','22700','0','22700','1','0','0','28','28/02/2024','',0,0,22700,'7896261006249','DIOVAN 80 MG X 28 TABLS  ','904','SIEGFRIED NOVARTIS','2024-02-28 17:59:26',  18486, 38668, 11, 9),('FVE','FNK','017573','2024-02-28 18:18:19','022024','CO','1098677748','JORGE LEONIDAS','PEREZ','calle 6 nuer 3-16 aeropuerto','######0  3105537817','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','17426.89075630252','3273.1092436974786','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 18:18:19','20700','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','28/02/2024','',20700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 18:18:19',  100, 44347, 11, 9),('FVE','FNK','017573','2024-02-28 18:18:19','022024','CO','1098677748','JORGE LEONIDAS','PEREZ','calle 6 nuer 3-16 aeropuerto','######0  3105537817','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','17426.89075630252','3273.1092436974786','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 18:18:19','20700','09','BOD. FARMANORTE 09','1','11500','11500','9663.8655462185','1836.1344537815','11500','1','0','0','','28/02/2024','',20700,0,0,'7702354939960','EGO CERA PARA PEINAR *160 ML','388','UNILEVER ANDINA COLOMBIA','2024-02-28 18:18:19',  6154, 49396, 11, 9),('FVE','FNK','017573','2024-02-28 18:18:19','022024','CO','1098677748','JORGE LEONIDAS','PEREZ','calle 6 nuer 3-16 aeropuerto','######0  3105537817','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','17426.89075630252','3273.1092436974786','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 18:18:19','20700','09','BOD. FARMANORTE 09','2','4500','9000','7563.025210084','1436.974789916','9000','2','0','0','','28/02/2024','',20700,0,0,'7702045563726','BALANCE CLINICAL CREMA MINI MEN * 32 GR','203','HENKEL COLOMBIANA','2024-02-28 18:18:19',  2890.8, 52775, 11, 9),('FVE','FNK','017574','2024-02-28 18:19:24','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','12','11500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 18:19:24','11500','09','BOD. FARMANORTE 09','11.5','1000','11500','11500','0','11500','12','0','0','','28/02/2024','',11500,0,0,'R1001','PAQUETES CONEXRED','692','CONEXRED SA','2024-02-28 18:19:24',  0, 59924, 11, 9),('FVE','FNK','017575','2024-02-28 18:51:45','022024','CO','1004879101','DAYANA MELISSA','GARCIA CORDOBA','av 9 #5-45 barrio panamericano',' 3168105738','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','2430116','1127953864','CLARO CEBALLOS RICHARD DANIEL','','','2','87000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 18:51:45','87000','09','BOD. FARMANORTE 09','1','85000','85000','85000','0','85000','1','0','0','','29/02/2024','',87000,0,0,'3838957889570,3','CURAM JUNIOR 457 MG *70 ML  ','183','FARMA DE COLOMBIA SA','2024-02-28 18:51:45',  72795.5, 38658, 11, 9),('FVE','FNK','017575','2024-02-28 18:51:45','022024','CO','1004879101','DAYANA MELISSA','GARCIA CORDOBA','av 9 #5-45 barrio panamericano',' 3168105738','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','2430116','1127953864','CLARO CEBALLOS RICHARD DANIEL','','','2','87000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 18:51:45','87000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',87000,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 18:51:45',  1500, 44348, 11, 9),('FVE','FNK','017576','2024-02-28 19:06:12','022024','CO','1093746062','GIOVANNY','MARTINEZ','CALLE 18 NO. 21-60 SIMON BOLIV',' 3112892693','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','569751','13453950','MARCIALES TOLOZA ANDRES','','','1','14500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 19:06:12','14500','09','BOD. FARMANORTE 09','1','14500','14500','14500','0','14500','1','0','1','27','29/02/2024','',14500,0,0,'7702870071465','BELLAFACE SUAVE *28 TAB','619','ABBOTT FARMA','2024-02-28 19:06:12',  12656, 47121, 11, 9),('FVE','FNK','017577','2024-02-28 19:13:28','022024','CO','1090432196','CARLOS','RUEDA','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','5210.084033613445','989.9159663865548','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 19:13:28','6200','09','BOD. FARMANORTE 09','2','3100','6200','5210.0840336134','989.91596638655','6200','2','0','0','','29/02/2024','',6200,0,0,'7702090029871','HIT NARANJA PINA *500 ML','192','POSTOBON GASEOSAS','2024-02-28 19:13:28',  1488.095, 35521, 11, 9),('FVE','FNK','017578','2024-02-28 19:24:59','022024','CO','1090456912','OSCAR','MANSERA','CALLE0AV8 8-10 PANAMERICANO','5879009 3133130842','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','18400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 19:24:59','18400','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',18400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 19:24:59',  100, 44347, 11, 9),('FVE','FNK','017578','2024-02-28 19:24:59','022024','CO','1090456912','OSCAR','MANSERA','CALLE0AV8 8-10 PANAMERICANO','5879009 3133130842','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','18400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 19:24:59','18400','09','BOD. FARMANORTE 09','1','9100','9100','9100','0','9100','1','0','0','','29/02/2024','',18400,0,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-02-28 19:24:59',  8380, 22278, 11, 9),('FVE','FNK','017578','2024-02-28 19:24:59','022024','CO','1090456912','OSCAR','MANSERA','CALLE0AV8 8-10 PANAMERICANO','5879009 3133130842','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','18400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 19:24:59','18400','09','BOD. FARMANORTE 09','1','9100','9100','9100','0','9100','1','0','0','','29/02/2024','',18400,0,0,'7501033957369','PEDIALYTE MAX ZINC 60 MANZANA *500 ML','659','ABBOTT NUTRICION','2024-02-28 19:24:59',  8380, 22277, 11, 9),('FVE','FNK','017579','2024-02-28 19:34:33','022024','CO','1090518569','KARINE','PEREZ','AV 3 NUM 21-50 AEROPUER',' 3112188270','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','18600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 19:34:33','18600','09','BOD. FARMANORTE 09','2','9300','18600','18600','0','18600','2','0','0','','29/02/2024','',0,18600,0,'7702057088835','CREMA N4 *20 GR ','889','TECNOQUIMICAS CONSUMO','2024-02-28 19:34:33',  3293, 42902, 11, 9),('FVE','FNK','017580','2024-02-28 20:25:27','022024','CO','88275993','ALEXANDER ','MORALES','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','26500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:25:27','26500','09','BOD. FARMANORTE 09','1','26500','26500','26500','0','26500','1','0','0','','29/02/2024','',0,26500,0,'7703712080652','NEPOLDEX GOTAS OFTALMICAS * 5 ML  /D24/','387','TRIDEX FARMACEUTICA','2024-02-28 20:25:27',  22140, 56008, 11, 9),('FVE','FNK','017581','2024-02-28 20:38:29','022024','CO','1093751104','CARLOS ','VEGA','CALL 234 6-20 VILLAS DEL TEJAR',' 3138318147','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','4453.781512605042','846.2184873949582','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:38:29','5300','09','BOD. FARMANORTE 09','1','5300','5300','4453.781512605','846.21848739496','5300','1','0','0','','29/02/2024','',5300,0,0,'7702090064599','HIT TROPICAL *1.5 LT','192','POSTOBON GASEOSAS','2024-02-28 20:38:29',  3501.4, 56796, 11, 9),('FVE','FNK','017582','2024-02-28 20:44:21','022024','CO','1112764318','CRISTIN','MARTINEZ','CUCUTA',' 5 ','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','4705.882352941177','894.1176470588234','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:44:22','5600','09','BOD. FARMANORTE 09','1','5600','5600','4705.8823529412','894.11764705882','5600','1','0','0','','29/02/2024','',5600,0,0,'7702007056396','MONTBLANC ALMENDRA BLANCA *60 GR','816','GRUPO NUTRESA','2024-02-28 20:44:21',  4750.75, 53171, 11, 9),('FVE','FNK','017583','2024-02-28 20:48:44','022024','CO','1010059830','MARCELA','GOMEZ','AV 1D 26-64 VIRGILIO BARCOS','  3134839876','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','15','35859.66386554622','3640.3361344537807','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:48:44','39500','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',39500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 20:48:44',  100, 44347, 11, 9),('FVE','FNK','017583','2024-02-28 20:48:44','022024','CO','1010059830','MARCELA','GOMEZ','AV 1D 26-64 VIRGILIO BARCOS','  3134839876','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','15','35859.66386554622','3640.3361344537807','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:48:44','39500','09','BOD. FARMANORTE 09','1','4500','4500','4500','0','4500','1','0','0','','29/02/2024','',39500,0,0,'7706659500146','AGUA OXIGENADA * 120 ML','143','COASPHARMA SAS','2024-02-28 20:48:44',  2377, 49419, 11, 9),('FVE','FNK','017583','2024-02-28 20:48:44','022024','CO','1010059830','MARCELA','GOMEZ','AV 1D 26-64 VIRGILIO BARCOS','  3134839876','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','15','35859.66386554622','3640.3361344537807','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:48:44','39500','09','BOD. FARMANORTE 09','10','1000','10000','10000','0','10000','10','0','0','','29/02/2024','',39500,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2024-02-28 20:48:44',  570, 58629, 11, 9),('FVE','FNK','017583','2024-02-28 20:48:44','022024','CO','1010059830','MARCELA','GOMEZ','AV 1D 26-64 VIRGILIO BARCOS','  3134839876','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','15','35859.66386554622','3640.3361344537807','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:48:44','39500','09','BOD. FARMANORTE 09','1','12900','12900','10840.336134454','2059.6638655462','12900','1','0','0','','29/02/2024','',39500,0,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-02-28 20:48:44',  8414.1, 33273, 11, 9),('FVE','FNK','017583','2024-02-28 20:48:44','022024','CO','1010059830','MARCELA','GOMEZ','AV 1D 26-64 VIRGILIO BARCOS','  3134839876','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','15','35859.66386554622','3640.3361344537807','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:48:44','39500','09','BOD. FARMANORTE 09','1','9900','9900','8319.3277310924','1580.6722689076','9900','1','0','0','','29/02/2024','',39500,0,0,'7702123003137','ACID MANTLE JABON *90 GR','631','BAYER OTC','2024-02-28 20:48:44',  5800, 22843, 11, 9);
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','FNK','017584','2024-02-28 20:56:14','022024','CO','60445797','YURI','BOTERO','MZ E1 LOTE 10 LA CONCORDIA',' 3123782694','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','1000141354','27604104','FLOREZ NUNCIRA MARTHA LUCIA','','','4','31657.983193277312','2842.0168067226878','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:56:14','34500','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',34500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 20:56:14',  100, 44347, 11, 9),('FVE','FNK','017584','2024-02-28 20:56:14','022024','CO','60445797','YURI','BOTERO','MZ E1 LOTE 10 LA CONCORDIA',' 3123782694','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','1000141354','27604104','FLOREZ NUNCIRA MARTHA LUCIA','','','4','31657.983193277312','2842.0168067226878','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:56:14','34500','09','BOD. FARMANORTE 09','1','17800','17800','14957.983193277','2842.0168067227','17800','1','0','0','','29/02/2024','',34500,0,0,'7709285612627','TERMOMETRO DIGITAL MODELO MT-502B','750','DIAGNOSTICOS BIOMEDICOS','2024-02-28 20:56:14',  6000, 57559, 11, 9),('FVE','FNK','017584','2024-02-28 20:56:14','022024','CO','60445797','YURI','BOTERO','MZ E1 LOTE 10 LA CONCORDIA',' 3123782694','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','1000141354','27604104','FLOREZ NUNCIRA MARTHA LUCIA','','','4','31657.983193277312','2842.0168067226878','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:56:14','34500','09','BOD. FARMANORTE 09','1','14500','14500','14500','0','14500','1','0','0','','29/02/2024','',34500,0,0,'7702870004425','BELLAFACE *21 TAB ','619','ABBOTT FARMA','2024-02-28 20:56:14',  12656, 31230, 11, 9),('FVE','FNK','017584','2024-02-28 20:56:14','022024','CO','60445797','YURI','BOTERO','MZ E1 LOTE 10 LA CONCORDIA',' 3123782694','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','1000141354','27604104','FLOREZ NUNCIRA MARTHA LUCIA','','','4','31657.983193277312','2842.0168067226878','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:56:14','34500','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',34500,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 20:56:14',  1500, 44348, 11, 9),('FVE','FNK','017585','2024-02-28 20:59:24','022024','CO','1050946495','MARIA','DEL PILAR','0','0 3017691920','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','27980','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:59:25','27980','09','BOD. FARMANORTE 09','2','6840','13680','13680','0','13680','0','2','0','','29/02/2024','',27980,0,0,'4048846006578','NIFLAMIN PL 7.5MG *5 CAP','134','BOEHRINGER INGELHEIM FARMA','2024-02-28 20:59:24',  29878.9, 49424, 11, 9),('FVE','FNK','017585','2024-02-28 20:59:24','022024','CO','1050946495','MARIA','DEL PILAR','0','0 3017691920','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','27980','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 20:59:25','27980','09','BOD. FARMANORTE 09','1','14300','14300','14300','0','14300','1','0','0','','29/02/2024','',27980,0,0,'7702184530023','ATLETICS GEL *60 GR ','249','ECAR','2024-02-28 20:59:24',  6200, 58868, 11, 9),('FVE','FNK','017586','2024-02-28 21:11:48','022024','CO','37342964','RUBIELA','CARDENAS','','1 ','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:11:49','500','09','BOD. FARMANORTE 09','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/02/2024','',500,0,0,'7707228361762','JERINGA 3ML 1G *1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-02-28 21:11:48',  213, 60547, 11, 9),('FVE','FNK','017587','2024-02-28 21:16:01','022024','CO','1010085917','NEIDER','CELIS','',' 3222222222','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','12500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:16:01','12500','09','BOD. FARMANORTE 09','1','12500','12500','12500','0','12500','1','0','0','','29/02/2024','',12500,0,0,'7707288821220','ZOPICLONA 7.5 MG * 10 TAB','205','HUMAX PHARMACEUTICAL','2024-02-28 21:16:01',  6550, 27387, 11, 9),('FVE','FNK','017588','2024-02-28 21:17:09','022024','CO','13167914','RAFAEL','RIOS','AV 40 N 30-21 DIVINA PASTORA','5  ','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','1344.5378151260504','255.46218487394958','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:17:09','1600','09','BOD. FARMANORTE 09','2','800','1600','1344.5378151261','255.46218487395','1600','2','0','0','','29/02/2024','',1600,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-02-28 21:17:09',  228.3, 39236, 11, 9),('FVE','FNK','017589','2024-02-28 21:17:52','022024','CO','1093774067','INGRI','PAEZ','0','0 3124010465','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','33370.58823529412','1229.411764705882','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:17:53','34600','09','BOD. FARMANORTE 09','1','10000','10000','10000','0','10000','1','0','0','','29/02/2024','',0,34600,0,'7707019420722','RESFRYGRIP PLUS *10 CAP','130','LABQUIFAR PHARMACEUTICA','2024-02-28 21:17:52',  5090, 45904, 11, 9),('FVE','FNK','017589','2024-02-28 21:17:52','022024','CO','1093774067','INGRI','PAEZ','0','0 3124010465','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','33370.58823529412','1229.411764705882','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:17:53','34600','09','BOD. FARMANORTE 09','1','16900','16900','16900','0','16900','1','0','0','','29/02/2024','',0,34600,0,'7707274723224','BACTROSAFE 500 MG * 3 TAB','890','ALLEN PHARMA','2024-02-28 21:17:52',  12099, 58701, 11, 9),('FVE','FNK','017589','2024-02-28 21:17:52','022024','CO','1093774067','INGRI','PAEZ','0','0 3124010465','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','33370.58823529412','1229.411764705882','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:17:53','34600','09','BOD. FARMANORTE 09','10','770','7700','6470.5882352941','1229.4117647059','7700','0','10','0','','29/02/2024','',0,34600,0,'7702605109296','VITAMINA C + ZINC NARANJA * 100 TAB','193','GENFAR','2024-02-28 21:17:52',  47405, 49172, 11, 9),('FVE','FNK','017590','2024-02-28 21:18:31','022024','CO','13496229','HENRY ','OREJUELA','HOTEL TEXMANT AV LAS AMERICAS ',' 3506036828','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','6','171600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:18:32','171600','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',171600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 21:18:31',  100, 44347, 11, 9),('FVE','FNK','017590','2024-02-28 21:18:31','022024','CO','13496229','HENRY ','OREJUELA','HOTEL TEXMANT AV LAS AMERICAS ',' 3506036828','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','6','171600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:18:32','171600','09','BOD. FARMANORTE 09','2','62500','125000','125000','0','125000','2','0','0','27','29/02/2024','',171600,0,0,'7702635710202','DIOVAN HCT 160/12.5 *28 TAB   ','904','SIEGFRIED NOVARTIS','2024-02-28 21:18:31',  55229, 38670, 11, 9),('FVE','FNK','017590','2024-02-28 21:18:31','022024','CO','13496229','HENRY ','OREJUELA','HOTEL TEXMANT AV LAS AMERICAS ',' 3506036828','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','6','171600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:18:32','171600','09','BOD. FARMANORTE 09','2','22200','44400','44400','0','44400','2','0','0','29','29/02/2024','',171600,0,0,'7702418000872,0','CONCOR 5 MG *30 TAB','305','MERCK COLOMBIA FARMA','2024-02-28 21:18:31',  20900, 32908, 11, 9),('FVE','FNK','017590','2024-02-28 21:18:31','022024','CO','13496229','HENRY ','OREJUELA','HOTEL TEXMANT AV LAS AMERICAS ',' 3506036828','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','6','171600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:18:32','171600','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',171600,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 21:18:31',  1500, 44348, 11, 9),('FVE','FNK','017591','2024-02-28 21:34:14','022024','CO','1090479029','ALEJANDRA','MULLER','Torres de bolivar et 2 apt 104','  3142003464 3209657698','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','1642505','13484200','RAMIREZ GOMEZ IGOR','','','12','167900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:34:14','167900','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,167900,0,'DO','DOMICILIO','00','VARIOS','2024-02-28 21:34:14',  1500, 44348, 11, 9),('FVE','FNK','017591','2024-02-28 21:34:14','022024','CO','1090479029','ALEJANDRA','MULLER','Torres de bolivar et 2 apt 104','  3142003464 3209657698','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','1642505','13484200','RAMIREZ GOMEZ IGOR','','','12','167900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:34:14','167900','09','BOD. FARMANORTE 09','10','14500','145000','145000','0','145000','10','0','0','','29/02/2024','',0,167900,0,'7702870004425','BELLAFACE *21 TAB ','619','ABBOTT FARMA','2024-02-28 21:34:14',  12656, 31230, 11, 9),('FVE','FNK','017591','2024-02-28 21:34:14','022024','CO','1090479029','ALEJANDRA','MULLER','Torres de bolivar et 2 apt 104','  3142003464 3209657698','1981','EDWIN YESID','MENDOZA VELASCO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','1642505','13484200','RAMIREZ GOMEZ IGOR','','','12','167900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:34:14','167900','09','BOD. FARMANORTE 09','1','20900','20900','20900','0','20900','1','0','0','','29/02/2024','',0,167900,0,'7707019412628','ACTIVIRAL 800 MG * 10 TAB','130','LABQUIFAR PHARMACEUTICA','2024-02-28 21:34:14',  11660, 45897, 11, 9),('FVE','FNK','017592','2024-02-28 21:44:21','022024','CO','1093798045','LUZY','ORTEGA','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','10','5900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:44:22','5900','09','BOD. FARMANORTE 09','10','590','5900','5900','0','5900','0','10','0','','29/02/2024','',5900,0,0,'7706569000026','AMOXICILINA 500MG *50 CAP','614','A.G. MEDICAMENTOS','2024-02-28 21:44:21',  21949, 31190, 11, 9),('FVE','FNK','017593','2024-02-28 21:48:08','022024','CO','1090447528','GERMAN','CHUSCANO','CALLE 4 #1-84 AEROPUERTO CUCUT',' 3204729558','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','6600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:48:09','6600','09','BOD. FARMANORTE 09','1','2700','2700','2700','0','2700','1','0','0','','29/02/2024','',6600,0,0,'7702090020847','GASEOSA BRETANA *300 ML','192','POSTOBON GASEOSAS','2024-02-28 21:48:08',  1657.5, 35287, 11, 9),('FVE','FNK','017593','2024-02-28 21:48:08','022024','CO','1090447528','GERMAN','CHUSCANO','CALLE 4 #1-84 AEROPUERTO CUCUT',' 3204729558','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','6600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:48:09','6600','09','BOD. FARMANORTE 09','1','3900','3900','3900','0','3900','1','0','0','','29/02/2024','',6600,0,0,'7707364802181','VENDA ELASTICA  5*5 YDS','774','MEDICAL SUPPLIES CORP','2024-02-28 21:48:08',  2200, 58470, 11, 9),('FVE','FNK','017594','2024-02-28 21:55:17','022024','CO','13259777','GERARDO','RIVAS','0','0 5870794','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','11100','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:55:17','11100','09','BOD. FARMANORTE 09','1','11100','11100','11100','0','11100','1','0','0','','29/02/2024','',11100,0,0,'7703186031525','GLUCERNA LIQUIDO FRESA *237 ML','659','ABBOTT NUTRICION','2024-02-28 21:55:17',  11850, 51643, 11, 9),('FVE','FNK','017595','2024-02-28 21:59:52','022024','CO','1093756550','KELY TATIANA ','ALBARRACIN ALBARRACIN ','Calle 15 B. Kdx 408-25 -1A pan',' 3014644416','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','569971','13470807','RODRIGUEZ SANTAMARIA DAGOBERTO','','','10','23000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 21:59:52','23000','09','BOD. FARMANORTE 09','10','2300','23000','23000','0','23000','0','10','0','','29/02/2024','',23000,0,0,'7703381003365','MACRODANTINA 100 MG *40 CAP ','134','BOEHRINGER INGELHEIM FARMA','2024-02-28 21:59:52',  66600, 23844, 11, 9),('FVE','FNK','017596','2024-02-28 22:04:16','022024','CO','1092352190','VIVIANA','SANDOVAL ORTIZ','','  3004878481','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','13800','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:04:17','13800','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',13800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 22:04:16',  100, 44347, 11, 9),('FVE','FNK','017596','2024-02-28 22:04:16','022024','CO','1092352190','VIVIANA','SANDOVAL ORTIZ','','  3004878481','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','13800','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:04:17','13800','09','BOD. FARMANORTE 09','10','450','4500','4500','0','4500','0','10','0','','29/02/2024','',13800,0,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-02-28 22:04:16',  13144, 31502, 11, 9),('FVE','FNK','017596','2024-02-28 22:04:16','022024','CO','1092352190','VIVIANA','SANDOVAL ORTIZ','','  3004878481','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','13800','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:04:17','13800','09','BOD. FARMANORTE 09','1','9100','9100','9100','0','9100','1','0','0','','29/02/2024','',13800,0,0,'7501033961540','PEDIALYTE MAX ZINC 60 COCO *500 ML','659','ABBOTT NUTRICION','2024-02-28 22:04:16',  8380, 55720, 11, 9),('FVE','FNK','017597','2024-02-28 22:09:27','022024','CO','1090511688','DAYANA ','GONZALEZ','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','24650','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:09:28','24650','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',24650,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 22:09:27',  100, 44347, 11, 9),('FVE','FNK','017597','2024-02-28 22:09:27','022024','CO','1090511688','DAYANA ','GONZALEZ','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','24650','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:09:28','24650','09','BOD. FARMANORTE 09','1','2850','2850','2850','0','2850','0','1','0','','29/02/2024','',24650,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2024-02-28 22:09:27',  27350, 46776, 11, 9),('FVE','FNK','017597','2024-02-28 22:09:27','022024','CO','1090511688','DAYANA ','GONZALEZ','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','24650','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:09:28','24650','09','BOD. FARMANORTE 09','1','2700','2700','2700','0','2700','0','1','0','','29/02/2024','',24650,0,0,'7702057840310','SAL DE FRUTAS LUA *50 SOBRES','382','TECNOQUIMICAS','2024-02-28 22:09:27',  105944.66, 43290, 11, 9),('FVE','FNK','017597','2024-02-28 22:09:27','022024','CO','1090511688','DAYANA ','GONZALEZ','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','24650','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:09:28','24650','09','BOD. FARMANORTE 09','1','18900','18900','18900','0','18900','1','0','0','','29/02/2024','',24650,0,0,'7709465967332','DERGINTREX CREMA TOPICA * 20 GR','1000','NATURALMENTE','2024-02-28 22:09:27',  6160, 63246, 11, 9),('FVE','FNK','017598','2024-02-28 22:10:36','022024','CO','13471859','LUIS','LIZCANO','',' 5 3229520123','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','3900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:10:36','3900','09','BOD. FARMANORTE 09','1','3900','3900','3900','0','3900','1','0','0','','29/02/2024','',3900,0,0,'7702605101634','LORATADINA 10 MG *10 TAB','193','GENFAR','2024-02-28 22:10:36',  2554, 26098, 11, 9),('FVE','FNK','017599','2024-02-28 22:13:01','022024','CO','79565167','JAIRO','JIMENEZ','','7  3135561243','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','7','16720','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:13:02','16720','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',16720,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 22:13:01',  100, 44347, 11, 9),('FVE','FNK','017599','2024-02-28 22:13:01','022024','CO','79565167','JAIRO','JIMENEZ','','7  3135561243','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','7','16720','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:13:02','16720','09','BOD. FARMANORTE 09','4','955','3820','3820','0','3820','0','4','0','','29/02/2024','',16720,0,0,'7707355055626','NOXPIRIN PLUS *120 CAP','626','SIEGFRIED CONSUMO','2024-02-28 22:13:01',  102526, 55782, 11, 9),('FVE','FNK','017599','2024-02-28 22:13:01','022024','CO','79565167','JAIRO','JIMENEZ','','7  3135561243','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','7','16720','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:13:02','16720','09','BOD. FARMANORTE 09','1','10000','10000','10000','0','10000','1','0','0','','29/02/2024','',16720,0,0,'7703546091107','LORDINEX 10 MG * 10 TAB L-CONSUM','630','NOVAMED OTC','2024-02-28 22:13:01',  5273, 46914, 11, 9),('FVE','FNK','017599','2024-02-28 22:13:01','022024','CO','79565167','JAIRO','JIMENEZ','','7  3135561243','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','7','16720','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:13:02','16720','09','BOD. FARMANORTE 09','1','2700','2700','2700','0','2700','0','1','0','','29/02/2024','',16720,0,0,'7702057160999','NORAVER GRIPA BEBIDA NOCHE *24 SOBRES','382','TECNOQUIMICAS','2024-02-28 22:13:01',  54049.64, 33743, 11, 9),('FVE','FNK','017600','2024-02-28 22:23:21','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','4453.781512605042','846.2184873949582','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:23:21','5300','09','BOD. FARMANORTE 09','1','5300','5300','4453.781512605','846.21848739496','5300','1','0','0','','29/02/2024','',5300,0,0,'7702090064599','HIT TROPICAL *1.5 LT','192','POSTOBON GASEOSAS','2024-02-28 22:23:21',  3501.4, 56796, 11, 9),('FVE','FNK','017601','2024-02-28 22:28:26','022024','CO','1193446146','NAREN','PE NTILDE A','',' 0 3008795357','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','6638.655462184874','1261.3445378151257','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:28:26','7899.999999999999','09','BOD. FARMANORTE 09','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','29/02/2024','',7900,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-02-28 22:28:26',  1050.4, 47478, 11, 9),('FVE','FNK','017601','2024-02-28 22:28:26','022024','CO','1193446146','NAREN','PE NTILDE A','',' 0 3008795357','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','6638.655462184874','1261.3445378151257','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:28:26','7899.999999999999','09','BOD. FARMANORTE 09','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/02/2024','',7900,0,0,'7702090029819','MR TEA LIMA LIMON *500 ML','192','POSTOBON GASEOSAS','2024-02-28 22:28:26',  1750.7, 25852, 11, 9),('FVE','FNK','017601','2024-02-28 22:28:26','022024','CO','1193446146','NAREN','PE NTILDE A','',' 0 3008795357','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','6638.655462184874','1261.3445378151257','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:28:26','7899.999999999999','09','BOD. FARMANORTE 09','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','29/02/2024','',7900,0,0,'7702535009994','POWERADE BLAST *500 ML','144','COCA COLA','2024-02-28 22:28:26',  1916.6667, 36976, 11, 9);
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','FNK','017603','2024-02-28 22:34:53','022024','CO','1083569176','WILDER','VARGAS','',' 3006907282 ','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','7','8380','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:34:53','8380','09','BOD. FARMANORTE 09','2','1690','3380','3380','0','3380','0','2','0','','29/02/2024','',8380,0,0,'7707397791636','DOLEX FORTE * 100 TAB','616','HALEON (GLAXO OTC)','2024-02-28 22:34:53',  148233, 63445, 11, 9),('FVE','FNK','017603','2024-02-28 22:34:53','022024','CO','1083569176','WILDER','VARGAS','',' 3006907282 ','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','7','8380','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:34:53','8380','09','BOD. FARMANORTE 09','5','1000','5000','5000','0','5000','0','5','0','','29/02/2024','',8380,0,0,'7707019420722','RESFRYGRIP PLUS *10 CAP','130','LABQUIFAR PHARMACEUTICA','2024-02-28 22:34:53',  5090, 45904, 11, 9),('FVE','FNK','017604','2024-02-28 22:41:13','022024','CO','1090487385','YEFERON','CAICEDO','',' 3132558974 ','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','13600','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:41:14','13600','09','BOD. FARMANORTE 09','1','13600','13600','13600','0','13600','1','0','0','','29/02/2024','',0,13600,0,'7707355052014','ADOREM JBE *120 ML ','626','SIEGFRIED CONSUMO','2024-02-28 22:41:13',  10723, 30936, 11, 9),('FVE','FNK','017605','2024-02-28 22:47:48','022024','CO','1010021903','HYLLARY','LOPEZ ','Av 2#22-65 barrio aeropuerto',' 3176935353','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','41274.78991596639','375.21008403361327','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:47:48','41650','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',41650,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 22:47:48',  100, 44347, 11, 9),('FVE','FNK','017605','2024-02-28 22:47:48','022024','CO','1010021903','HYLLARY','LOPEZ ','Av 2#22-65 barrio aeropuerto',' 3176935353','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','41274.78991596639','375.21008403361327','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:47:48','41650','09','BOD. FARMANORTE 09','3','7900','23700','23700','0','23700','3','0','0','','29/02/2024','',41650,0,0,'7707236123581','CLINDAMICINA 600MG/4ML *1 AMP','701','VITALIS COMERCIAL','2024-02-28 22:47:48',  5000, 54110, 11, 9),('FVE','FNK','017605','2024-02-28 22:47:48','022024','CO','1010021903','HYLLARY','LOPEZ ','Av 2#22-65 barrio aeropuerto',' 3176935353','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','41274.78991596639','375.21008403361327','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:47:48','41650','09','BOD. FARMANORTE 09','3','500','1500','1260.5042016807','239.49579831933','1500','3','0','0','','29/02/2024','',41650,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-02-28 22:47:48',  255, 46100, 11, 9),('FVE','FNK','017605','2024-02-28 22:47:48','022024','CO','1010021903','HYLLARY','LOPEZ ','Av 2#22-65 barrio aeropuerto',' 3176935353','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','41274.78991596639','375.21008403361327','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:47:48','41650','09','BOD. FARMANORTE 09','1','4000','4000','4000','0','4000','1','0','0','','29/02/2024','',41650,0,0,'7707141349304','CLORURO DE SODIO S.S. 9% *500 ML  ','235','BAXTER','2024-02-28 22:47:48',  1740, 28628, 11, 9),('FVE','FNK','017605','2024-02-28 22:47:48','022024','CO','1010021903','HYLLARY','LOPEZ ','Av 2#22-65 barrio aeropuerto',' 3176935353','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','41274.78991596639','375.21008403361327','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:47:48','41650','09','BOD. FARMANORTE 09','2','3900','7800','7800','0','7800','0','2','0','','29/02/2024','',41650,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-02-28 22:47:48',  7000, 23704, 11, 9),('FVE','FNK','017605','2024-02-28 22:47:48','022024','CO','1010021903','HYLLARY','LOPEZ ','Av 2#22-65 barrio aeropuerto',' 3176935353','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','41274.78991596639','375.21008403361327','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:47:48','41650','09','BOD. FARMANORTE 09','1','3600','3600','3600','0','3600','1','0','0','','29/02/2024','',41650,0,0,'7702560026577','ALCOHOL JGB *120 ML','219','JGB','2024-02-28 22:47:48',  2529, 27762, 11, 9),('FVE','FNK','017605','2024-02-28 22:47:48','022024','CO','1010021903','HYLLARY','LOPEZ ','Av 2#22-65 barrio aeropuerto',' 3176935353','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','12','41274.78991596639','375.21008403361327','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:47:48','41650','09','BOD. FARMANORTE 09','1','850','850','714.28571428571','135.71428571429','850','1','0','0','','29/02/2024','',41650,0,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-02-28 22:47:48',  369, 46955, 11, 9),('FVE','FNK','017606','2024-02-28 22:49:57','022024','CO','4609398','JOSE','BERMUDEZ','CLL 16 #12-55 TOLEDO PLATA',' 3166036023 3153762336','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','3','36420.16806722689','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:49:57','36500','09','BOD. FARMANORTE 09','1','32000','32000','32000','0','32000','1','0','0','','29/02/2024','',36500,0,0,'7703381000463','BERODUAL SOL INHALADOR *20 ML ','134','BOEHRINGER INGELHEIM FARMA','2024-02-28 22:49:57',  29600, 23800, 11, 9),('FVE','FNK','017606','2024-02-28 22:49:57','022024','CO','4609398','JOSE','BERMUDEZ','CLL 16 #12-55 TOLEDO PLATA',' 3166036023 3153762336','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','3','36420.16806722689','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:49:57','36500','09','BOD. FARMANORTE 09','1','4000','4000','4000','0','4000','1','0','0','','29/02/2024','',36500,0,0,'7707141349304','CLORURO DE SODIO S.S. 9% *500 ML  ','235','BAXTER','2024-02-28 22:49:57',  1740, 28628, 11, 9),('FVE','FNK','017606','2024-02-28 22:49:57','022024','CO','4609398','JOSE','BERMUDEZ','CLL 16 #12-55 TOLEDO PLATA',' 3166036023 3153762336','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','3','36420.16806722689','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:49:57','36500','09','BOD. FARMANORTE 09','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/02/2024','',36500,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-02-28 22:49:57',  255, 46100, 11, 9),('FVE','FNK','017607','2024-02-28 22:54:14','022024','CO','1090430730','ALFREDO ','RIVAS','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','15','15750','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:54:14','15750','09','BOD. FARMANORTE 09','5','1450','7250','7250','0','7250','0','5','0','','29/02/2024','',15750,0,0,'7707019301007','VICERALGINA COMP *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-02-28 22:54:14',  11550, 23616, 11, 9),('FVE','FNK','017607','2024-02-28 22:54:14','022024','CO','1090430730','ALFREDO ','RIVAS','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','15','15750','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 22:54:14','15750','09','BOD. FARMANORTE 09','10','850','8500','8500','0','8500','0','10','0','','29/02/2024','',15750,0,0,'7707232091600','UROVITAL CRANBERRY CAJA  *60 CAPS','271','NATURAL FRESHLY','2024-02-28 22:54:14',  29895.1, 50162, 11, 9),('FVE','FNK','017608','2024-02-28 23:06:46','022024','CO','88245791','ERASMO ','LEAL','CALLE AV  CALLE    13    00   ',' 3202735519 3204853276','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','1848.7394957983195','351.26050420168053','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:06:46','2200','09','BOD. FARMANORTE 09','2','1100','2200','1848.7394957983','351.26050420168','2200','2','0','0','','29/02/2024','',2200,0,0,'7622300758943','GALLETA CLUB SOCIAL MANTEQUILLA *26 GR','754','DISCOB NORTE SAS','2024-02-28 23:06:46',  560.224, 27450, 11, 9),('FVE','FNK','017609','2024-02-28 23:16:04','022024','CO','1093772302','DISNEY ','BEJARANO ','AV 7 CLL 18 NUMER 7-31 EL SALA','0000000000 3147373028','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','45701.68067226891','2698.319327731091','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:16:04','48400','09','BOD. FARMANORTE 09','1','31500','31500','31500','0','31500','1','0','0','','29/02/2024','',48400,0,0,'7707263007755','CLINDABACT 100/100MG  X 3 OVULOS /D20/','387','TRIDEX FARMACEUTICA','2024-02-28 23:16:04',  22800, 59529, 11, 9),('FVE','FNK','017609','2024-02-28 23:16:04','022024','CO','1093772302','DISNEY ','BEJARANO ','AV 7 CLL 18 NUMER 7-31 EL SALA','0000000000 3147373028','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','45701.68067226891','2698.319327731091','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:16:04','48400','09','BOD. FARMANORTE 09','1','16900','16900','14201.680672269','2698.3193277311','16900','1','0','0','','29/02/2024','',48400,0,0,'7707263009872','TRIVAG SOLUCION VAGINAL FCO X 120 ML  /D24/','387','TRIDEX FARMACEUTICA','2024-02-28 23:16:04',  5622, 63519, 11, 9),('FVE','FNK','017610','2024-02-28 23:23:06','022024','CO','13270726','CESAR','JARAMILLO','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','10900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:23:07','10900','09','BOD. FARMANORTE 09','1','10900','10900','10900','0','10900','1','0','0','','29/02/2024','',10900,0,0,'7707236128517','VITATRIOL OFT * 5 ML','701','VITALIS COMERCIAL','2024-02-28 23:23:06',  6600, 44245, 11, 9),('FVE','FNK','017611','2024-02-28 23:28:38','022024','CO','1148145742','WILMER','SANDOVAL','0',' 3128337739  3128337739 3158776114','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','23225.210084033613','4374.789915966386','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:28:38','27600','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',27600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-28 23:28:38',  100, 44347, 11, 9),('FVE','FNK','017611','2024-02-28 23:28:38','022024','CO','1148145742','WILMER','SANDOVAL','0',' 3128337739  3128337739 3158776114','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','23225.210084033613','4374.789915966386','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:28:38','27600','09','BOD. FARMANORTE 09','1','23500','23500','19747.899159664','3752.1008403361','23500','1','0','0','','29/02/2024','',27600,0,0,'7701021115706','WINNY ULTRATRIM SEC ET1 *30 + 20 TOALLITAS','653','TECNOQUIMICAS WINNY','2024-02-28 23:28:38',  17118.9, 34273, 11, 9),('FVE','FNK','017611','2024-02-28 23:28:38','022024','CO','1148145742','WILMER','SANDOVAL','0',' 3128337739  3128337739 3158776114','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','23225.210084033613','4374.789915966386','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:28:38','27600','09','BOD. FARMANORTE 09','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','29/02/2024','',27600,0,0,'7702192218050','GATORADE NARANJA-MANDARINA *500 ML','192','POSTOBON GASEOSAS','2024-02-28 23:28:38',  2451, 25824, 11, 9),('FVE','FNK','017612','2024-02-28 23:31:12','022024','CO','1093611892','MANUEL','GALBAN','','0 3112688364','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','4300','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-28 23:31:12','4300','09','BOD. FARMANORTE 09','2','2150','4300','4300','0','4300','0','2','0','','29/02/2024','',4300,0,0,'7702057092757','IBUFLASH MIGRAN *30 CAP','382','TECNOQUIMICAS','2024-02-28 23:31:12',  50677.65, 58898, 11, 9),('FVE','FNK','017613','2024-02-29 00:10:54','022024','CO','1004922672','JUAN ','CABARCA','',' 0','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','95247.61904761904','4752.380952380961','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 00:10:54','100000','09','BOD. FARMANORTE 09','2','49900','99800','95047.619047619','4752.380952381','99800','2','0','0','','29/02/2024','',100000,0,0,'7702168278477','AGUARDIENTE AMARILLO DE MANZANARES *750 ML','809','COMORIENTE','2024-02-29 00:10:54',  37636, 61766, 11, 9),('FVE','FNK','017613','2024-02-29 00:10:54','022024','CO','1004922672','JUAN ','CABARCA','',' 0','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','95247.61904761904','4752.380952380961','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 00:10:54','100000','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',100000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 00:10:54',  100, 44347, 11, 9),('FVE','FNK','017614','2024-02-29 00:13:11','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','1512.6050420168067','287.3949579831933','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 00:13:11','1800','09','BOD. FARMANORTE 09','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','29/02/2024','',1800,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2024-02-29 00:13:11',  1190.721, 58852, 11, 9),('FVE','FNK','017615','2024-02-29 00:15:53','022024','CO','1193213284','LUIS','LEON','','0 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','10000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 00:15:54','10000','09','BOD. FARMANORTE 09','1','10000','10000','10000','0','10000','1','0','0','','29/02/2024','',1200,8800,0,'7707019336603','OSTEOSAN 20 MG * 10 CAP ','130','LABQUIFAR PHARMACEUTICA','2024-02-29 00:15:53',  4660, 23600, 11, 9),('FVE','FNK','017616','2024-02-29 00:52:27','022024','CO','1090498117','YESID','GARCIA','',' 0 3222222222','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','2436.9747899159665','463.02521008403346','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 00:52:27','2900','09','BOD. FARMANORTE 09','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/02/2024','',2900,0,0,'7702402054409','HELADO ARTESANAL DULCE DE MORAS *70 GR','296','MEALS DE COLOMBIA','2024-02-29 00:52:27',  1782, 56354, 11, 9),('FVE','FNK','017617','2024-02-29 01:17:05','022024','CO','29680872','ANTONI','TORCAT','',' 3142369835','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','6082.352941176471','1117.6470588235288','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:17:06','7200','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',7200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 01:17:05',  100, 44347, 11, 9),('FVE','FNK','017617','2024-02-29 01:17:05','022024','CO','29680872','ANTONI','TORCAT','',' 3142369835','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','6082.352941176471','1117.6470588235288','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:17:06','7200','09','BOD. FARMANORTE 09','2','1300','2600','2184.8739495798','415.12605042017','2600','2','0','0','','29/02/2024','',7200,0,0,'7702025136759','GALLETA FESTIVAL CHOCOLATE *6 GALLETAS','816','GRUPO NUTRESA','2024-02-29 01:17:05',  671.7, 53186, 11, 9),('FVE','FNK','017617','2024-02-29 01:17:05','022024','CO','29680872','ANTONI','TORCAT','',' 3142369835','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','6082.352941176471','1117.6470588235288','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:17:06','7200','09','BOD. FARMANORTE 09','2','2200','4400','3697.4789915966','702.52100840336','4400','2','0','0','','29/02/2024','',7200,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-02-29 01:17:05',  1050.4, 47478, 11, 9),('FVE','FNK','017618','2024-02-29 01:23:28','022024','CO','1093749224','VICTOR ','GARCIA','','0 3012381175','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','11','19400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:23:28','19400','09','BOD. FARMANORTE 09','10','590','5900','5900','0','5900','0','10','0','','29/02/2024','',19400,0,0,'7706569000026','AMOXICILINA 500MG *50 CAP','614','A.G. MEDICAMENTOS','2024-02-29 01:23:28',  21949, 31190, 11, 9),('FVE','FNK','017618','2024-02-29 01:23:28','022024','CO','1093749224','VICTOR ','GARCIA','','0 3012381175','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','11','19400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:23:28','19400','09','BOD. FARMANORTE 09','1','13500','13500','13500','0','13500','1','0','0','','29/02/2024','',19400,0,0,'7702870003596','SINOVUL *21 TAB','696','ABBOTT FARMA CONVENIO','2024-02-29 01:23:28',  11255, 31773, 11, 9),('FVE','FNK','017619','2024-02-29 01:41:17','022024','CO','13490739','HECTOR','NAVARRO','CALLE 14   16-57 TOLEDO',' 3156228146','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','11764.705882352942','2235.294117647058','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:41:17','14000','09','BOD. FARMANORTE 09','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','29/02/2024','',14000,0,0,'7702010111501','COLGATE CREMA DENTAL T/ACCION *60 ML','145','COLGATE PALMOLIVE COMPANIA','2024-02-29 01:41:17',  3341.65, 48361, 11, 9),('FVE','FNK','017619','2024-02-29 01:41:17','022024','CO','13490739','HECTOR','NAVARRO','CALLE 14   16-57 TOLEDO',' 3156228146','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','11764.705882352942','2235.294117647058','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:41:17','14000','09','BOD. FARMANORTE 09','1','9500','9500','7983.1932773109','1516.8067226891','9500','1','0','0','','29/02/2024','',14000,0,0,'3014260802189','ORAL B CEPILLO COMPLETE 40 MEDIANO','336','PROCTER & GAMBLE COLOMBIA','2024-02-29 01:41:17',  6623.43, 39977, 11, 9),('FVE','FNK','017620','2024-02-29 01:48:05','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','1848.7394957983195','351.26050420168053','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 01:48:05','2200','09','BOD. FARMANORTE 09','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','29/02/2024','',2200,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-02-29 01:48:05',  1050.4, 47478, 11, 9),('FVE','FNK','017621','2024-02-29 02:58:00','022024','CO','1093611892','MANUEL','GALBAN','','0 3112688364','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','8537.81512605042','862.1848739495795','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 02:58:00','9400','09','BOD. FARMANORTE 09','2','2000','4000','4000','0','4000','2','0','0','','29/02/2024','',4400,5000,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-02-29 02:58:00',  800, 48019, 11, 9),('FVE','FNK','017621','2024-02-29 02:58:00','022024','CO','1093611892','MANUEL','GALBAN','','0 3112688364','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','8537.81512605042','862.1848739495795','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 02:58:00','9400','09','BOD. FARMANORTE 09','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/02/2024','',4400,5000,0,'7702189055453','NATUCHIPS PLATANO VERDE *38 GR','762','FRITO LAY','2024-02-29 02:58:00',  1479, 57247, 11, 9),('FVE','FNK','017621','2024-02-29 02:58:00','022024','CO','1093611892','MANUEL','GALBAN','','0 3112688364','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','8537.81512605042','862.1848739495795','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 02:58:00','9400','09','BOD. FARMANORTE 09','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/02/2024','',4400,5000,0,'7702007212501','CHOCOLATINA JUMBO MANI *40 GR','816','GRUPO NUTRESA','2024-02-29 02:58:00',  2202.5, 53169, 11, 9),('FVE','FNK','017622','2024-02-29 03:19:54','022024','CO','1093589155','VIVIAN','CONTRERAS','Mzp2-52 concordia con villa ju',' 0  0 310 7822547','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','1','16000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 03:19:54','16000','09','BOD. FARMANORTE 09','1','16000','16000','16000','0','16000','1','0','0','','29/02/2024','',16000,0,0,'7707019413908','TRICLIMBAC SOLUCION OTICA *10 ML','130','LABQUIFAR PHARMACEUTICA','2024-02-29 03:19:54',  7000, 45901, 11, 9);
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','FNK','017623','2024-02-29 04:14:44','022024','CO','88232847','DIEGO','AGUDELO','','0 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','4583','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 04:14:44','4583','09','BOD. FARMANORTE 09','1','2500','2500','2500','0','2500','0','1','0','','29/02/2024','',4583,0,0,'7707232098081','MIELTERTOS GRIPA DIA PANELA - NARANJA * 24 SOBRES','271','NATURAL FRESHLY','2024-02-29 04:14:44',  36283.5, 33334, 11, 9),('FVE','FNK','017624','2024-02-29 04:45:23','022024','CO','1004914578','ALEXANDER','RODRIGUEZ','',' 0','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','55602.24089635854','3297.75910364146','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 04:45:23','58900','09','BOD. FARMANORTE 09','1','54500','54500','51904.761904762','2595.2380952381','54500','1','0','0','','29/02/2024','',0,58900,0,'7702168217308','RON VIEJO DE CALDAS *750 ML','809','COMORIENTE','2024-02-29 04:45:23',  43582, 55320, 11, 9),('FVE','FNK','017624','2024-02-29 04:45:23','022024','CO','1004914578','ALEXANDER','RODRIGUEZ','',' 0','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','55602.24089635854','3297.75910364146','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 04:45:23','58900','09','BOD. FARMANORTE 09','2','2200','4400','3697.4789915966','702.52100840336','4400','2','0','0','','29/02/2024','',0,58900,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-02-29 04:45:23',  1050.4, 47478, 11, 9),('FVE','FNK','017625','2024-02-29 04:59:52','022024','CO','1090402452','JAVIER','CASTILLO','CUCUTA',' 3132414603','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','3066','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 04:59:52','3066','09','BOD. FARMANORTE 09','2','1533','3066','3066','0','3066','0','2','0','','29/02/2024','',3066,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-02-29 04:59:52',  50000, 31759, 11, 9),('FVE','FNK','017626','2024-02-29 06:10:09','022024','CO','88231386','IVAN','SUAREZ','',' 5702896','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','6','11892','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 06:10:09','11892','09','BOD. FARMANORTE 09','6','1982','11892','11892','0','11892','0','6','0','','29/02/2024','',11892,0,0,'7703381002313','BUSCAPINA FEM *90 COMP ','772','OPELLA (SANOFI OTC)','2024-02-29 06:10:09',  134048.9, 23812, 11, 9),('FVE','FNK','017627','2024-02-29 06:58:50','022024','CR','1090397782','EDWIN YESID','MENDOZA VELASCO','CALLE 11 AVENIDA1RA KDX-396',' 3507308755','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','339580','1','3781.512605042017','718.4873949579828','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 07:01:27','4500','09','BOD. FARMANORTE 09','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','29/02/2024','',0,0,4500,'7702010111501','COLGATE CREMA DENTAL T/ACCION *60 ML','145','COLGATE PALMOLIVE COMPANIA','2024-02-29 06:58:50',  3341.65, 48361, 11, 9),('FVE','FNK','017628','2024-02-29 07:32:37','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','2','1344.5378151260504','255.46218487394958','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 07:32:37','1600','09','BOD. FARMANORTE 09','2','800','1600','1344.5378151261','255.46218487395','1600','2','0','0','','29/02/2024','',1600,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-02-29 07:32:37',  228.3, 39236, 11, 9),('FVE','FNK','017629','2024-02-29 07:59:34','022024','CO','1094162260','LEYDI MAYERLY ','NI ntilde O P eacute REZ ','diagonal 13 numero 8-53 paname',' 3214472132','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','3','34714.28571428572','135.71428571428567','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 07:59:35','34850','09','BOD. FARMANORTE 09','1','32000','32000','32000','0','32000','1','0','0','','29/02/2024','',0,34850,0,'7703381000463','BERODUAL SOL INHALADOR *20 ML ','134','BOEHRINGER INGELHEIM FARMA','2024-02-29 07:59:34',  29600, 23800, 11, 9),('FVE','FNK','017629','2024-02-29 07:59:34','022024','CO','1094162260','LEYDI MAYERLY ','NI ntilde O P eacute REZ ','diagonal 13 numero 8-53 paname',' 3214472132','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','3','34714.28571428572','135.71428571428567','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 07:59:35','34850','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,34850,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 07:59:34',  1500, 44348, 11, 9),('FVE','FNK','017629','2024-02-29 07:59:34','022024','CO','1094162260','LEYDI MAYERLY ','NI ntilde O P eacute REZ ','diagonal 13 numero 8-53 paname',' 3214472132','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','3','34714.28571428572','135.71428571428567','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 07:59:35','34850','09','BOD. FARMANORTE 09','1','850','850','714.28571428571','135.71428571429','850','1','0','0','','29/02/2024','',0,34850,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-02-29 07:59:34',  369, 46955, 11, 9),('FVE','FNK','017630','2024-02-29 08:40:04','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','4','2000','0','09','FARMANORTE 09','VENDEDOR','2024-02-29 08:40:04','2000','09','BOD. FARMANORTE 09','4','500','2000','2000','0','2000','0','4','0','','29/02/2024','',2000,0,0,'7702184560020','PASEDOL 50MG *100 TAB','249','ECAR','2024-02-29 08:40:04',  23625, 29755, 11, 9),('FVE','FNK','017631','2024-02-29 08:47:24','022024','CO','1090441777','LEYDI KATHERINE ','OCHOA SIERRA','CALLE 4N  15-AE65 CONJUCTO VIL',' 3158280843 3158280843','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','10','53685.71428571429','814.2857142857138','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 08:47:24','54500','09','BOD. FARMANORTE 09','2','2','400','400','0','400','2','0','0','','29/02/2024','',0,54500,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 08:47:24',  100, 44347, 11, 9),('FVE','FNK','017631','2024-02-29 08:47:24','022024','CO','1090441777','LEYDI KATHERINE ','OCHOA SIERRA','CALLE 4N  15-AE65 CONJUCTO VIL',' 3158280843 3158280843','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','10','53685.71428571429','814.2857142857138','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 08:47:24','54500','09','BOD. FARMANORTE 09','4','1725','6900','6900','0','6900','0','4','0','','29/02/2024','',0,54500,0,'7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2024-02-29 08:47:24',  66736, 55304, 11, 9),('FVE','FNK','017631','2024-02-29 08:47:24','022024','CO','1090441777','LEYDI KATHERINE ','OCHOA SIERRA','CALLE 4N  15-AE65 CONJUCTO VIL',' 3158280843 3158280843','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','10','53685.71428571429','814.2857142857138','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 08:47:24','54500','09','BOD. FARMANORTE 09','1','17100','17100','17100','0','17100','1','0','0','','29/02/2024','',0,54500,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-02-29 08:47:24',  2500, 57400, 11, 9),('FVE','FNK','017631','2024-02-29 08:47:24','022024','CO','1090441777','LEYDI KATHERINE ','OCHOA SIERRA','CALLE 4N  15-AE65 CONJUCTO VIL',' 3158280843 3158280843','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','10','53685.71428571429','814.2857142857138','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 08:47:24','54500','09','BOD. FARMANORTE 09','1','5100','5100','4285.7142857143','814.28571428571','5100','1','0','0','','29/02/2024','',0,54500,0,'7702402053556','CONO BOCATTO FRESA *85 GR','296','MEALS DE COLOMBIA','2024-02-29 08:47:24',  2980, 55871, 11, 9),('FVE','FNK','017631','2024-02-29 08:47:24','022024','CO','1090441777','LEYDI KATHERINE ','OCHOA SIERRA','CALLE 4N  15-AE65 CONJUCTO VIL',' 3158280843 3158280843','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','10','53685.71428571429','814.2857142857138','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 08:47:24','54500','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,54500,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 08:47:24',  1500, 44348, 11, 9),('FVE','FNK','017631','2024-02-29 08:47:24','022024','CO','1090441777','LEYDI KATHERINE ','OCHOA SIERRA','CALLE 4N  15-AE65 CONJUCTO VIL',' 3158280843 3158280843','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','10','53685.71428571429','814.2857142857138','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 08:47:24','54500','09','BOD. FARMANORTE 09','1','11500','11500','11500','0','11500','1','0','0','','29/02/2024','',0,54500,0,'8710428018670','ENSURE ADVANCE LIQUIDO VAINILLA *220 ML','659','ABBOTT NUTRICION','2024-02-29 08:47:24',  10680, 33849, 11, 9),('FVE','FNK','017631','2024-02-29 08:47:24','022024','CO','1090441777','LEYDI KATHERINE ','OCHOA SIERRA','CALLE 4N  15-AE65 CONJUCTO VIL',' 3158280843 3158280843','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','10','53685.71428571429','814.2857142857138','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 08:47:24','54500','09','BOD. FARMANORTE 09','1','11500','11500','11500','0','11500','1','0','0','','29/02/2024','',0,54500,0,'8710428018717','ENSURE ADVANCE LIQUIDO FRESA *220 ML','659','ABBOTT NUTRICION','2024-02-29 08:47:24',  10680, 48587, 11, 9),('FVE','FNK','017632','2024-02-29 09:02:05','022024','CO','13229725','RAFAEL','PULIDO','',' 3132312332','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','20000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 09:02:05','20000','09','BOD. FARMANORTE 09','1','20000','20000','20000','0','20000','1','0','0','','29/02/2024','',20000,0,0,'7707019381115','VIGRADINA 50 MG * 4 TAB','130','LABQUIFAR PHARMACEUTICA','2024-02-29 09:02:05',  3920, 23617, 11, 9),('FVE','FNK','017633','2024-02-29 09:22:39','022024','CO','1127045587','RAMON','VALBUENA RODRIGUEZ','CARRETERA 17 NO. 1-82 AEROUERT',' 3143870306','087','WILMER JAVIER ','DUARTE MENDOZA','','TERCERO','VARIOS','','','','','','1','17100','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 09:22:39','17100','09','BOD. FARMANORTE 09','1','17100','17100','17100','0','17100','1','0','0','','29/02/2024','',17100,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-02-29 09:22:39',  2500, 57400, 11, 9),('FVE','FNK','017634','2024-02-29 09:30:34','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','087','WILMER JAVIER ','DUARTE MENDOZA','','TERCERO','VARIOS','','','','','','1','6090','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 09:30:35','6090','09','BOD. FARMANORTE 09','1','6090','6090','6090','0','6090','0','1','0','','29/02/2024','',6090,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-02-29 09:30:34',  53223.5, 41855, 11, 9),('FVE','FNK','017635','2024-02-29 10:01:26','022024','CO','13640507','PEDRO ','HERRERA ','','0000000000 ','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','6218.487394957983','1181.5126050420167','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 10:01:27','7400','09','BOD. FARMANORTE 09','1','7400','7400','6218.487394958','1181.512605042','7400','1','0','0','','29/02/2024','',7400,0,0,'7702057080075','YODORA CREMA *25 GR','889','TECNOQUIMICAS CONSUMO','2024-02-29 10:01:26',  5025.12, 42930, 11, 9),('FVE','FNK','017636','2024-02-29 10:25:30','022024','CO','1090383028','FLORINDA','MOROS','av 7a  # 23-26 barrio el salad',' 1 3142097552','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','2','17200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 10:25:30','17200','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',17200,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 10:25:30',  1500, 44348, 11, 9),('FVE','FNK','017636','2024-02-29 10:25:30','022024','CO','1090383028','FLORINDA','MOROS','av 7a  # 23-26 barrio el salad',' 1 3142097552','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','2','17200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 10:25:30','17200','09','BOD. FARMANORTE 09','1','15200','15200','15200','0','15200','1','0','0','13','29/02/2024','',17200,0,0,'7702057011284','INMOX 30MG CAJA *14 CAP','877','TECNOQUIMICAS VM TQ','2024-02-29 10:25:30',  15600, 33737, 11, 9),('FVE','FNK','017637','2024-02-29 10:53:46','022024','CO','80816438','JHONATAN','GARCIA','MZ 35 LOTE 14 SAN FERNANDO DEL',' 3123535074 ','087','WILMER JAVIER ','DUARTE MENDOZA','','TERCERO','VARIOS','569289','13337912','ASCENCIO GUTIERREZ JAIRO ENRIQUE','','','1','14200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 10:53:46','14200','09','BOD. FARMANORTE 09','1','14200','14200','14200','0','14200','1','0','0','','29/02/2024','',14200,0,0,'7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA *60 ML','616','HALEON (GLAXO OTC)','2024-02-29 10:53:46',  12808.3, 54127, 11, 9),('FVE','FNK','017638','2024-02-29 10:59:04','022024','CO','88199332','OSCAR','LIZARAZO PE Ntilde A','',' 3133909656','087','WILMER JAVIER ','DUARTE MENDOZA','','TERCERO','VARIOS','','','','','','1','64621.8487394958','12278.1512605042','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 10:59:05','76900','09','BOD. FARMANORTE 09','1','76900','76900','64621.848739496','12278.151260504','76900','1','0','0','','29/02/2024','',76900,0,0,'7701021143525','WINNY GOLD ET4 XG *50 UND ','653','TECNOQUIMICAS WINNY','2024-02-29 10:59:04',  57805.2, 43236, 11, 9),('FVE','FNK','017639','2024-02-29 11:36:39','022024','CO','1093784759','MICHEL ','GALVIS','Calle 14 A # 17-63 Toledo plat',' 3235102836 3222222222','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','23380','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:36:39','23380','09','BOD. FARMANORTE 09','2','5600','11200','11200','0','11200','0','2','0','','29/02/2024','',23380,0,0,'7709990568288','DIOSMIT 3GR CAJA *6 SOBRES','313','NTI (NEW TRADE INTERNATIONAL)','2024-02-29 11:36:39',  14100, 54384, 11, 9),('FVE','FNK','017639','2024-02-29 11:36:39','022024','CO','1093784759','MICHEL ','GALVIS','Calle 14 A # 17-63 Toledo plat',' 3235102836 3222222222','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','23380','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:36:39','23380','09','BOD. FARMANORTE 09','2','6090','12180','12180','0','12180','0','2','0','','29/02/2024','',23380,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-02-29 11:36:39',  53223.5, 41855, 11, 9),('FVE','FNK','017640','2024-02-29 11:42:06','022024','CO','1093770249','JHOAN CAMILO','RODRIGUEZ','',' 0','087','WILMER JAVIER ','DUARTE MENDOZA','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','5','64526.05042016807','6673.949579831933','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:42:06','71200','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',0,71200,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 11:42:06',  100, 44347, 11, 9),('FVE','FNK','017640','2024-02-29 11:42:06','022024','CO','1093770249','JHOAN CAMILO','RODRIGUEZ','',' 0','087','WILMER JAVIER ','DUARTE MENDOZA','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','5','64526.05042016807','6673.949579831933','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:42:06','71200','09','BOD. FARMANORTE 09','2','20900','41800','35126.050420168','6673.9495798319','41800','2','0','0','','29/02/2024','',0,71200,0,'7701021144829','WINNY GOLD SENSITIVE ET0 *30 +10 TOALLITAS','653','TECNOQUIMICAS WINNY','2024-02-29 11:42:06',  15193, 43229, 11, 9),('FVE','FNK','017640','2024-02-29 11:42:06','022024','CO','1093770249','JHOAN CAMILO','RODRIGUEZ','',' 0','087','WILMER JAVIER ','DUARTE MENDOZA','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','5','64526.05042016807','6673.949579831933','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:42:06','71200','09','BOD. FARMANORTE 09','1','27200','27200','27200','0','27200','1','0','0','','29/02/2024','',0,71200,0,'7702057104603','CREMA N4 MEDICADA *60 GR','889','TECNOQUIMICAS CONSUMO','2024-02-29 11:42:06',  21573, 42898, 11, 9),('FVE','FNK','017640','2024-02-29 11:42:06','022024','CO','1093770249','JHOAN CAMILO','RODRIGUEZ','',' 0','087','WILMER JAVIER ','DUARTE MENDOZA','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','','','','','','5','64526.05042016807','6673.949579831933','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:42:06','71200','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,71200,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 11:42:06',  1500, 44348, 11, 9),('FVE','FNK','017641','2024-02-29 11:48:25','022024','CO','88215784','OSCAR','MORALES','MZ 1 #11A COLINAS DEL NORTE','  3223048485','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','2','111000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:48:25','111000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',111000,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 11:48:25',  1500, 44348, 11, 9),('FVE','FNK','017641','2024-02-29 11:48:25','022024','CO','88215784','OSCAR','MORALES','MZ 1 #11A COLINAS DEL NORTE','  3223048485','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3917','OSMAN ANTONIO','ANGARITA HERNANDEZ ','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','2','111000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 11:48:25','111000','09','BOD. FARMANORTE 09','1','109000','109000','109000','0','109000','1','0','0','','29/02/2024','',111000,0,0,'7706309000767','NECROXIL 500 MG CJA *30 TAB','260','INCOBRA FARMA','2024-02-29 11:48:25',  85435.6, 29920, 11, 9),('FVE','FNK','017642','2024-02-29 12:04:06','022024','CO','1090425010','DEISY','CONTRERAS','','0 3144752193','087','WILMER JAVIER ','DUARTE MENDOZA','','TERCERO','VARIOS','','','','','','1','14789.915966386556','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:04:06','17600','09','BOD. FARMANORTE 09','1','17600','17600','14789.915966387','2810.0840336134','17600','1','0','0','','29/02/2024','',17600,0,0,'7707195906430','EXTRACTOR DE LECHE PLUS VIDRIO RICHARD','402','PARACLINICAS','2024-02-29 12:04:06',  11321.5, 41730, 11, 9),('FVE','FNK','017643','2024-02-29 12:20:05','022024','CO','20705242','FLOR MARIA','PINEDA MARIN','calle 21 av 1 casa 20-40 aerop',' 04241578862 3113654065','087','WILMER JAVIER ','DUARTE MENDOZA','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','2','66700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:20:05','66700','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,66700,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 12:20:05',  1500, 44348, 11, 9),('FVE','FNK','017643','2024-02-29 12:20:05','022024','CO','20705242','FLOR MARIA','PINEDA MARIN','calle 21 av 1 casa 20-40 aerop',' 04241578862 3113654065','087','WILMER JAVIER ','DUARTE MENDOZA','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','2','66700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:20:05','66700','09','BOD. FARMANORTE 09','1','64700','64700','64700','0','64700','1','0','0','','29/02/2024','',0,66700,0,'7501058631152','BABY KLIM 1+ LATA *800 GR','311','NESTLE NUTRICION','2024-02-29 12:20:05',  59868, 51947, 11, 9),('FVE','FNK','017644','2024-02-29 12:24:18','022024','CO','91431858','MANUEL','CASTA ATILDE','',' 3216977932','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','1','72000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:24:18','72000','09','BOD. FARMANORTE 09','1','72000','72000','72000','0','72000','1','0','0','','29/02/2024','',0,72000,0,'7708152336826','SUREZINC COLAGENO VAINILLA * 36 S/S','1007','SUREZINC','2024-02-29 12:24:18',  25000, 62506, 11, 9),('FVE','FNK','017645','2024-02-29 12:33:40','022024','CO','1090453905','DEISY','VILLAMIZAR','CALLE 5 #3A-08 CASA 2 AEROPUER','123 3229437111','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','6025.210084033613','574.7899159663866','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:33:41','6600','09','BOD. FARMANORTE 09','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','29/02/2024','',6600,0,0,'7702057080044','YODORA CREMA *12 GR ','889','TECNOQUIMICAS CONSUMO','2024-02-29 12:33:40',  2411.48, 42929, 11, 9),('FVE','FNK','017645','2024-02-29 12:33:40','022024','CO','1090453905','DEISY','VILLAMIZAR','CALLE 5 #3A-08 CASA 2 AEROPUER','123 3229437111','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','6025.210084033613','574.7899159663866','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:33:41','6600','09','BOD. FARMANORTE 09','3','1000','3000','3000','0','3000','3','0','0','','29/02/2024','',6600,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2024-02-29 12:33:40',  570, 58629, 11, 9);
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','FNK','017647','2024-02-29 12:49:14','022024','CO','1090479248','ANYELA','GARCIA','CALLE 19 #3-04 APTO 102 AEROPU',' 3108063573','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','2','27000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:49:14','27000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','1','','29/02/2024','',27000,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 12:49:14',  1500, 44348, 11, 9),('FVE','FNK','017647','2024-02-29 12:49:14','022024','CO','1090479248','ANYELA','GARCIA','CALLE 19 #3-04 APTO 102 AEROPU',' 3108063573','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','2','27000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:49:14','27000','09','BOD. FARMANORTE 09','1','25000','25000','25000','0','25000','0','1','1','','29/02/2024','',27000,0,0,'7703281004189,7','NOVORAPID FLEX PEN *5 DISP (REFRIGERADO)','316','NOVO NORDISK COLOMBIA SAS','2024-02-29 12:49:14',  109738, 38866, 11, 9),('FVE','FNK','017648','2024-02-29 12:58:24','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','1680.6722689075632','319.3277310924368','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 12:58:24','2000','09','BOD. FARMANORTE 09','1','2000','2000','1680.6722689076','319.32773109244','2000','1','0','0','','29/02/2024','',2000,0,0,'7707228360222','GUANTE CIRUGIA ESTERIL T 6 1/2 ','429','ALFA SAFE','2024-02-29 12:58:24',  1375, 53095, 11, 9),('FVE','FNK','017649','2024-02-29 13:06:05','022024','CO','11721679','MARIA','GONZALES','',' 3202927478','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','95','58925','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:06:05','58925','09','BOD. FARMANORTE 09','80','250','20000','20000','0','20000','0','80','0','','29/02/2024','',58925,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-02-29 13:06:05',  28997, 54625, 11, 9),('FVE','FNK','017649','2024-02-29 13:06:05','022024','CO','11721679','MARIA','GONZALES','',' 3202927478','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','95','58925','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:06:05','58925','09','BOD. FARMANORTE 09','15','2595','38925','38925','0','38925','0','15','0','','29/02/2024','',58925,0,0,'7707263003542','CEFLAXILIN 500 MG * 20 CAP /D22/','387','TRIDEX FARMACEUTICA','2024-02-29 13:06:05',  32088, 43534, 11, 9),('FVE','FNK','017650','2024-02-29 13:13:52','022024','CO','1005541415','YAJAIRA','ANGARITA','CALLE 29 #1-12 VIRGILIO BARCO ',' 3228431448','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','7922.689075630253','327.3109243697478','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:13:53','8250','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',8250,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 13:13:52',  100, 44347, 11, 9),('FVE','FNK','017650','2024-02-29 13:13:52','022024','CO','1005541415','YAJAIRA','ANGARITA','CALLE 29 #1-12 VIRGILIO BARCO ',' 3228431448','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','7922.689075630253','327.3109243697478','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:13:53','8250','09','BOD. FARMANORTE 09','1','4000','4000','4000','0','4000','1','0','0','','29/02/2024','',8250,0,0,'7707141349304','CLORURO DE SODIO S.S. 9% *500 ML  ','235','BAXTER','2024-02-29 13:13:52',  1740, 28628, 11, 9),('FVE','FNK','017650','2024-02-29 13:13:52','022024','CO','1005541415','YAJAIRA','ANGARITA','CALLE 29 #1-12 VIRGILIO BARCO ',' 3228431448','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','7922.689075630253','327.3109243697478','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:13:53','8250','09','BOD. FARMANORTE 09','1','1200','1200','1008.4033613445','191.59663865546','1200','0','1','0','','29/02/2024','',8250,0,0,'7702645205231',' ALCANFOR * 36 BARRAS','263','LEON','2024-02-29 13:13:52',  26750, 62749, 11, 9),('FVE','FNK','017650','2024-02-29 13:13:52','022024','CO','1005541415','YAJAIRA','ANGARITA','CALLE 29 #1-12 VIRGILIO BARCO ',' 3228431448','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','7922.689075630253','327.3109243697478','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:13:53','8250','09','BOD. FARMANORTE 09','1','850','850','714.28571428571','135.71428571429','850','1','0','0','','29/02/2024','',8250,0,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-02-29 13:13:52',  369, 46955, 11, 9),('FVE','FNK','017650','2024-02-29 13:13:52','022024','CO','1005541415','YAJAIRA','ANGARITA','CALLE 29 #1-12 VIRGILIO BARCO ',' 3228431448','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','7922.689075630253','327.3109243697478','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:13:53','8250','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',8250,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 13:13:52',  1500, 44348, 11, 9),('FVE','FNK','017651','2024-02-29 13:17:42','022024','CO','1094426785','SERGIO','AMAYA','CALLE 3 #2-66  AEROPUERTO','0 3115701275','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','23','97689.91596638656','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:17:43','100500','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,100500,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 13:17:42',  1500, 44348, 11, 9),('FVE','FNK','017651','2024-02-29 13:17:42','022024','CO','1094426785','SERGIO','AMAYA','CALLE 3 #2-66  AEROPUERTO','0 3115701275','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','23','97689.91596638656','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:17:43','100500','09','BOD. FARMANORTE 09','3','19900','59700','59700','0','59700','3','0','0','','29/02/2024','',0,100500,0,'7506205808272','ENFAMIL PREMIUM 1 LIQUIDO *6 BOTELLAS','295','MEAD JOHNSON NUTRITION COLOMBIA','2024-02-29 13:17:42',  20149, 58001, 11, 9),('FVE','FNK','017651','2024-02-29 13:17:42','022024','CO','1094426785','SERGIO','AMAYA','CALLE 3 #2-66  AEROPUERTO','0 3115701275','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','23','97689.91596638656','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:17:43','100500','09','BOD. FARMANORTE 09','1','10500','10500','10500','0','10500','1','0','0','','29/02/2024','',0,100500,0,'7709299854228','PRUEBA DE EMBARAZO ESFERO ','398','ZIBOJECT','2024-02-29 13:17:42',  3150, 55608, 11, 9),('FVE','FNK','017651','2024-02-29 13:17:42','022024','CO','1094426785','SERGIO','AMAYA','CALLE 3 #2-66  AEROPUERTO','0 3115701275','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','23','97689.91596638656','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:17:43','100500','09','BOD. FARMANORTE 09','1','12900','12900','10840.336134454','2059.6638655462','12900','1','0','0','','29/02/2024','',0,100500,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-02-29 13:17:42',  8414.1, 33273, 11, 9),('FVE','FNK','017651','2024-02-29 13:17:42','022024','CO','1094426785','SERGIO','AMAYA','CALLE 3 #2-66  AEROPUERTO','0 3115701275','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','23','97689.91596638656','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:17:43','100500','09','BOD. FARMANORTE 09','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','29/02/2024','',0,100500,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-02-29 13:17:42',  15435, 56535, 11, 9),('FVE','FNK','017651','2024-02-29 13:17:42','022024','CO','1094426785','SERGIO','AMAYA','CALLE 3 #2-66  AEROPUERTO','0 3115701275','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','23','97689.91596638656','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:17:43','100500','09','BOD. FARMANORTE 09','6','1750','10500','10500','0','10500','0','6','0','','29/02/2024','',0,100500,0,'7702057168056','NORAVER-P MENTA *96 TAB','382','TECNOQUIMICAS','2024-02-29 13:17:42',  131276, 43182, 11, 9),('FVE','FNK','017651','2024-02-29 13:17:42','022024','CO','1094426785','SERGIO','AMAYA','CALLE 3 #2-66  AEROPUERTO','0 3115701275','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','23','97689.91596638656','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:17:43','100500','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',0,100500,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 13:17:42',  100, 44347, 11, 9),('FVE','FNK','017652','2024-02-29 13:24:06','022024','CO','37399238','MARCELA','LOZADA','MZ A2 LOTE 7 LA CONCORDIA',' 3159275017','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','2','34000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:24:06','34000','09','BOD. FARMANORTE 09','1','32000','32000','32000','0','32000','1','0','0','','29/02/2024','',34000,0,0,'7703381000463','BERODUAL SOL INHALADOR *20 ML ','134','BOEHRINGER INGELHEIM FARMA','2024-02-29 13:24:06',  29600, 23800, 11, 9),('FVE','FNK','017652','2024-02-29 13:24:06','022024','CO','37399238','MARCELA','LOZADA','MZ A2 LOTE 7 LA CONCORDIA',' 3159275017','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','2','34000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:24:06','34000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',34000,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 13:24:06',  1500, 44348, 11, 9),('FVE','FNK','017653','2024-02-29 13:47:07','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','13081.512605042017','718.4873949579828','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:47:07','13800','09','BOD. FARMANORTE 09','1','9300','9300','9300','0','9300','1','0','0','','29/02/2024','',0,13800,0,'7702057088835','CREMA N4 *20 GR ','889','TECNOQUIMICAS CONSUMO','2024-02-29 13:47:07',  3293, 42902, 11, 9),('FVE','FNK','017653','2024-02-29 13:47:07','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','13081.512605042017','718.4873949579828','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:47:07','13800','09','BOD. FARMANORTE 09','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','29/02/2024','',0,13800,0,'7501058645623','COMPOTA GERBER DE MANZANA 6+ *113 GR','311','NESTLE NUTRICION','2024-02-29 13:47:07',  3158, 56283, 11, 9),('FVE','FNK','017654','2024-02-29 13:53:06','022024','CO','1093771427','JOHANNA','RODRIGUEZ','AEROPUERTO',' 3138752534','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','4','37490','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:53:06','37490','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',37490,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 13:53:06',  100, 44347, 11, 9),('FVE','FNK','017654','2024-02-29 13:53:06','022024','CO','1093771427','JOHANNA','RODRIGUEZ','AEROPUERTO',' 3138752534','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','4','37490','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:53:06','37490','09','BOD. FARMANORTE 09','1','17600','17600','17600','0','17600','1','0','0','','29/02/2024','',37490,0,0,'7707019437225','BUPROFEN JBE *120 ML ','130','LABQUIFAR PHARMACEUTICA','2024-02-29 13:53:06',  8100, 23556, 11, 9),('FVE','FNK','017654','2024-02-29 13:53:06','022024','CO','1093771427','JOHANNA','RODRIGUEZ','AEROPUERTO',' 3138752534','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','4','37490','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:53:06','37490','09','BOD. FARMANORTE 09','1','13600','13600','13600','0','13600','1','0','0','','29/02/2024','',37490,0,0,'7707355052014','ADOREM JBE *120 ML ','626','SIEGFRIED CONSUMO','2024-02-29 13:53:06',  10723, 30936, 11, 9),('FVE','FNK','017654','2024-02-29 13:53:06','022024','CO','1093771427','JOHANNA','RODRIGUEZ','AEROPUERTO',' 3138752534','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','4','37490','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 13:53:06','37490','09','BOD. FARMANORTE 09','1','6090','6090','6090','0','6090','0','1','0','','29/02/2024','',37490,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-02-29 13:53:06',  53223.5, 41855, 11, 9),('FVE','FNK','017655','2024-02-29 14:03:50','022024','CO','1094353302','SHOSELIN ','MALDONADO ','',' 3027510998','029','CARLOS ANDRES ','MIRANDA GARCIA','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','103400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:03:50','103400','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',0,103400,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 14:03:50',  100, 44347, 11, 9),('FVE','FNK','017655','2024-02-29 14:03:50','022024','CO','1094353302','SHOSELIN ','MALDONADO ','',' 3027510998','029','CARLOS ANDRES ','MIRANDA GARCIA','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','103400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:03:50','103400','09','BOD. FARMANORTE 09','1','9100','9100','9100','0','9100','1','0','0','','29/02/2024','',0,103400,0,'7501033961557','PEDIALYTE MAX ZINC 60 FRESA *500 ML','659','ABBOTT NUTRICION','2024-02-29 14:03:50',  8380, 55721, 11, 9),('FVE','FNK','017655','2024-02-29 14:03:50','022024','CO','1094353302','SHOSELIN ','MALDONADO ','',' 3027510998','029','CARLOS ANDRES ','MIRANDA GARCIA','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','103400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:03:50','103400','09','BOD. FARMANORTE 09','1','27500','27500','27500','0','27500','1','0','0','','29/02/2024','',0,103400,0,'7703712080256','NISTAFAR FCO * 60 ML /D24/','387','TRIDEX FARMACEUTICA','2024-02-29 14:03:50',  18300, 54477, 11, 9),('FVE','FNK','017655','2024-02-29 14:03:50','022024','CO','1094353302','SHOSELIN ','MALDONADO ','',' 3027510998','029','CARLOS ANDRES ','MIRANDA GARCIA','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','103400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:03:50','103400','09','BOD. FARMANORTE 09','1','64600','64600','64600','0','64600','1','0','0','','29/02/2024','',0,103400,0,'7506205808944','ENFAMIL PREMIUM 2 PROMENTAL *375 GR ','295','MEAD JOHNSON NUTRITION COLOMBIA','2024-02-29 14:03:50',  64190, 44681, 11, 9),('FVE','FNK','017655','2024-02-29 14:03:50','022024','CO','1094353302','SHOSELIN ','MALDONADO ','',' 3027510998','029','CARLOS ANDRES ','MIRANDA GARCIA','3901','ERNESTO JAVIER','RODRIGUEZ MURILLO','','','','','','5','103400','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:03:50','103400','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,103400,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 14:03:50',  1500, 44348, 11, 9),('FVE','FNK','017656','2024-02-29 14:32:05','022024','CO','1090445560','ANDREA','BOTELLO','CLL 6 LOTE 75 MOLINO 3  2 CUAD',' 3227564766','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','185599.15966386555','9100.840336134454','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:32:05','194700','09','BOD. FARMANORTE 09','1','135700','135700','135700','0','135700','1','0','0','30','29/02/2024','',0,194700,0,'7795320050127','ADVANTAN CREMA *15 GR','239','BIOPAS','2024-02-29 14:32:05',  119400, 22855, 11, 9),('FVE','FNK','017656','2024-02-29 14:32:05','022024','CO','1090445560','ANDREA','BOTELLO','CLL 6 LOTE 75 MOLINO 3  2 CUAD',' 3227564766','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','185599.15966386555','9100.840336134454','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:32:05','194700','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,194700,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 14:32:05',  1500, 44348, 11, 9),('FVE','FNK','017656','2024-02-29 14:32:05','022024','CO','1090445560','ANDREA','BOTELLO','CLL 6 LOTE 75 MOLINO 3  2 CUAD',' 3227564766','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','185599.15966386555','9100.840336134454','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:32:05','194700','09','BOD. FARMANORTE 09','1','57000','57000','47899.159663866','9100.8403361345','57000','1','0','0','','29/02/2024','',0,194700,0,'751273771707','VITAMINA E 1000 IU + SELENIUM * 50 SOFTGELS','641','HEALTHY DE AMERICA COLOMBIA','2024-02-29 14:32:05',  28739.4, 58862, 11, 9),('FVE','FNK','017657','2024-02-29 14:55:05','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','1428.5714285714287','271.42857142857133','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 14:55:05','1700','09','BOD. FARMANORTE 09','1','1700','1700','1428.5714285714','271.42857142857','1700','1','0','0','','29/02/2024','',1700,0,0,'7702354946463','SPARTAN ENERGY LATA *269 ML','350','QUALA','2024-02-29 14:55:05',  1050, 55680, 11, 9),('FVE','FNK','017658','2024-02-29 15:14:09','022024','CO','1004809795','DAYANA','CHACON','',' 3212696481','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','4789.075630252101','909.9243697478987','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 15:14:10','5699','09','BOD. FARMANORTE 09','1','2798.88','2798.88','2352.1008403361','446.89915966387','2799','1','0','0','','29/02/2024','',5699,0,0,'7702535013212','AGUA BRISA MANZANA *600 ML','144','COCA COLA','2024-02-29 15:14:09',  1528.3333, 57464, 11, 9),('FVE','FNK','017658','2024-02-29 15:14:09','022024','CO','1004809795','DAYANA','CHACON','',' 3212696481','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','2','4789.075630252101','909.9243697478987','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 15:14:10','5699','09','BOD. FARMANORTE 09','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/02/2024','',5699,0,0,'7702007212501','CHOCOLATINA JUMBO MANI *40 GR','816','GRUPO NUTRESA','2024-02-29 15:14:09',  2202.5, 53169, 11, 9),('FVE','FNK','017659','2024-02-29 15:34:59','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','27300','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 15:34:59','27300','09','BOD. FARMANORTE 09','3','9100','27300','27300','0','27300','3','0','0','','29/02/2024','',27300,0,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-02-29 15:34:59',  8329, 52291, 11, 9),('FVE','FNK','017660','2024-02-29 16:14:45','022024','CO','13392907','JAVIER','CASTRILLO','cll 15 nuemer 27-48 simon boli',' 5 3144312415','3421','JESUS HUMBERTO','BERBESI CAICEDO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','92100','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 16:14:46','92100','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',92100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 16:14:45',  100, 44347, 11, 9),('FVE','FNK','017660','2024-02-29 16:14:45','022024','CO','13392907','JAVIER','CASTRILLO','cll 15 nuemer 27-48 simon boli',' 5 3144312415','3421','JESUS HUMBERTO','BERBESI CAICEDO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','92100','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 16:14:46','92100','09','BOD. FARMANORTE 09','1','89900','89900','89900','0','89900','1','0','0','15','29/02/2024','',92100,0,0,'7703546720908','NUTRIBEN CRECIMIENTO 3 POTE *800 GR','672','NOVAMED NUTRICIONAL','2024-02-29 16:14:45',  81647, 33416, 11, 9),('FVE','FNK','017660','2024-02-29 16:14:45','022024','CO','13392907','JAVIER','CASTRILLO','cll 15 nuemer 27-48 simon boli',' 5 3144312415','3421','JESUS HUMBERTO','BERBESI CAICEDO','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','3','92100','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 16:14:46','92100','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',92100,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 16:14:45',  1500, 44348, 11, 9);
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','FNK','017661','2024-02-29 16:40:57','022024','CO','28696973','EDGARDO','CARO','av5 con calle 18 -54 aeropuert',' 0 3222748962','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','0','0','CANTILLO VARGAS JULIETH KATHERINE','','','4','60855.462184873955','11144.537815126047','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 16:40:57','72000','09','BOD. FARMANORTE 09','1','12900','12900','10840.336134454','2059.6638655462','12900','1','0','0','','29/02/2024','',72000,0,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-02-29 16:40:57',  8414.1, 33273, 11, 9),('FVE','FNK','017661','2024-02-29 16:40:57','022024','CO','28696973','EDGARDO','CARO','av5 con calle 18 -54 aeropuert',' 0 3222748962','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','0','0','CANTILLO VARGAS JULIETH KATHERINE','','','4','60855.462184873955','11144.537815126047','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 16:40:57','72000','09','BOD. FARMANORTE 09','1','56900','56900','47815.12605042','9084.8739495798','56900','1','0','0','','29/02/2024','',72000,0,0,'7701021111845','WINNY ULTRATRIM SEC ET3 *50 UND ','653','TECNOQUIMICAS WINNY','2024-02-29 16:40:57',  41579.1, 50913, 11, 9),('FVE','FNK','017661','2024-02-29 16:40:57','022024','CO','28696973','EDGARDO','CARO','av5 con calle 18 -54 aeropuert',' 0 3222748962','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','0','0','CANTILLO VARGAS JULIETH KATHERINE','','','4','60855.462184873955','11144.537815126047','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 16:40:57','72000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',72000,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 16:40:57',  1500, 44348, 11, 9),('FVE','FNK','017662','2024-02-29 16:43:02','022024','CO','1956383','ALBERTO','SAAVEDRA','CALLE 8   10-23 AEROPUERTO',' 3107953817','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','1','17900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 16:43:02','17900','09','BOD. FARMANORTE 09','1','17900','17900','17900','0','17900','1','0','0','','29/02/2024','',17900,0,0,'736085278507','MANZANILLA SOLUCION OFT *15ML','636','SOPHIA DE COLOMBIA OTC','2024-02-29 16:43:02',  7415, 31131, 11, 9),('FVE','FNK','017663','2024-02-29 17:22:59','022024','CO','1193276349','VIVIANA','ARMENTA','cll 13 0-40 aropuerto',' 0  0 ','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','2','25900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 17:23:00','25900','09','BOD. FARMANORTE 09','1','23900','23900','23900','0','23900','1','0','0','27','29/02/2024','',25900,0,0,'7702207312520','GYNORELL *28 TAB','619','ABBOTT FARMA','2024-02-29 17:22:59',  21344, 31483, 11, 9),('FVE','FNK','017663','2024-02-29 17:22:59','022024','CO','1193276349','VIVIANA','ARMENTA','cll 13 0-40 aropuerto',' 0  0 ','111','SERGIO ANDRES','QUINONEZ JIMENEZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','2','25900','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 17:23:00','25900','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',25900,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 17:22:59',  1500, 44348, 11, 9),('FVE','FNK','017664','2024-02-29 17:51:59','022024','CO','1093757192','LISBETH','MOJICA','Calle 10 #2-36 segundo piso','579791799  3202846718','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','14500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 17:52:00','14500','09','BOD. FARMANORTE 09','1','14500','14500','14500','0','14500','1','0','0','26','29/02/2024','',14500,0,0,'7702870004425','BELLAFACE *21 TAB ','619','ABBOTT FARMA','2024-02-29 17:51:59',  12656, 31230, 11, 9),('FVE','FNK','017665','2024-02-29 17:52:39','022024','CO','88001766','GUILLERMO','ORTIZ','','0 0','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 17:52:40','500','09','BOD. FARMANORTE 09','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/02/2024','',500,0,0,'7707228361762','JERINGA 3ML 1G *1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-02-29 17:52:39',  213, 60547, 11, 9),('FVE','FNK','017666','2024-02-29 18:00:28','022024','CO','1090483554','MAIRA ','RINCON ','MOLINOS DEL NORTE CONJUNTO B I','3146164219 0 ','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','1','14789.915966386556','2810.0840336134443','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:00:29','17600','09','BOD. FARMANORTE 09','1','17600','17600','14789.915966387','2810.0840336134','17600','1','0','0','','29/02/2024','',17600,0,0,'7709442489222','NUTRAGUM KIDS BOLSA * 45 GOMAS','694','N&F COLOMBIA','2024-02-29 18:00:28',  7728, 49170, 11, 9),('FVE','FNK','017667','2024-02-29 18:10:05','022024','CO','1090503284','MARIA','SUARES','',' 0','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','23','36443.6974789916','1756.3025210084033','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:10:05','38200','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',0,38200,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 18:10:05',  100, 44347, 11, 9),('FVE','FNK','017667','2024-02-29 18:10:05','022024','CO','1090503284','MARIA','SUARES','',' 0','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','23','36443.6974789916','1756.3025210084033','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:10:05','38200','09','BOD. FARMANORTE 09','10','1100','11000','9243.6974789916','1756.3025210084','11000','0','10','0','','29/02/2024','',0,38200,0,'751273785568','VITAMINA E 1000 IU + SELENIUM * 60 SOFTGELS','641','HEALTHY DE AMERICA COLOMBIA','2024-02-29 18:10:05',  38319.2, 50923, 11, 9),('FVE','FNK','017667','2024-02-29 18:10:05','022024','CO','1090503284','MARIA','SUARES','',' 0','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','23','36443.6974789916','1756.3025210084033','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:10:05','38200','09','BOD. FARMANORTE 09','10','950','9500','9500','0','9500','0','10','0','','29/02/2024','',0,38200,0,'7703712080195','IBUPROFAR 800 MG CJA * 60 TB /D24/','387','TRIDEX FARMACEUTICA','2024-02-29 18:10:05',  40080, 53652, 11, 9),('FVE','FNK','017667','2024-02-29 18:10:05','022024','CO','1090503284','MARIA','SUARES','',' 0','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','23','36443.6974789916','1756.3025210084033','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:10:05','38200','09','BOD. FARMANORTE 09','1','15500','15500','15500','0','15500','1','0','0','','29/02/2024','',0,38200,0,'7703153016050','CLOTRIMAZOL 100MG *10 OVULOS','422','COLMED','2024-02-29 18:10:05',  7285.3295, 40784, 11, 9),('FVE','FNK','017667','2024-02-29 18:10:05','022024','CO','1090503284','MARIA','SUARES','',' 0','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','569317','3745317','BARRIOS CASTILLO MIGUEL EDUARDO','','','23','36443.6974789916','1756.3025210084033','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:10:05','38200','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,38200,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 18:10:05',  1500, 44348, 11, 9),('FVE','FNK','017668','2024-02-29 18:15:15','022024','CO','1094283463','ONOFRE','SALAS','0','0 0 3242177924','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','13361.344537815126','2538.6554621848736','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:15:15','15900','09','BOD. FARMANORTE 09','1','15900','15900','13361.344537815','2538.6554621849','15900','1','0','0','','29/02/2024','',15900,0,0,'7707195903453','EXTRACTOR DE LECHE PLUS PLASTICO RICHARD','402','PARACLINICAS','2024-02-29 18:15:15',  10224.8, 41729, 11, 9),('FVE','FNK','017669','2024-02-29 18:16:21','022024','CO','1094283463','ONOFRE','SALAS','0','0 0 3242177924','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3109.2436974789916','590.7563025210084','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:16:21','3700','09','BOD. FARMANORTE 09','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','29/02/2024','',3700,0,0,'03888,770253500','COCA COLA LATA *330 ML','144','COCA COLA','2024-02-29 18:16:21',  2347.8, 34417, 11, 9),('FVE','FNK','017670','2024-02-29 18:23:56','022024','CO','13457677','GUSTAVO','CALDERON','CALLE 19 #25-48 SIMON BOLIVAR','3160535285 3115742107','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','3','56700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:23:56','56700','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',56700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 18:23:56',  100, 44347, 11, 9),('FVE','FNK','017670','2024-02-29 18:23:56','022024','CO','13457677','GUSTAVO','CALDERON','CALLE 19 #25-48 SIMON BOLIVAR','3160535285 3115742107','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','3','56700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:23:56','56700','09','BOD. FARMANORTE 09','1','34000','34000','34000','0','34000','1','0','0','','29/02/2024','',56700,0,0,'7703202221237','BISOLVON ADULTO *120 ML ','772','OPELLA (SANOFI OTC)','2024-02-29 18:23:56',  30000, 23803, 11, 9),('FVE','FNK','017670','2024-02-29 18:23:56','022024','CO','13457677','GUSTAVO','CALDERON','CALLE 19 #25-48 SIMON BOLIVAR','3160535285 3115742107','002','CRUZ DELINA','VERA FLOREZ','','TERCERO','VARIOS','','','','','','3','56700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:23:56','56700','09','BOD. FARMANORTE 09','1','22500','22500','22500','0','22500','1','0','0','','29/02/2024','',56700,0,0,'650240028199','X RAY DOL *12 TAB','194','GENOMMA LABORATORIO COLOMBIA','2024-02-29 18:23:56',  20369, 49673, 11, 9),('FVE','FNK','017671','2024-02-29 18:29:33','022024','CO','1090477933','CARLA','TORRES','AV 3 NUMERO 7 -51 LA VICTORIA ',' 3222384489','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','7','134617.64705882352','6482.352941176468','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:29:33','141100','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',0,141100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 18:29:33',  100, 44347, 11, 9),('FVE','FNK','017671','2024-02-29 18:29:33','022024','CO','1090477933','CARLA','TORRES','AV 3 NUMERO 7 -51 LA VICTORIA ',' 3222384489','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','7','134617.64705882352','6482.352941176468','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:29:33','141100','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',0,141100,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 18:29:33',  1500, 44348, 11, 9),('FVE','FNK','017671','2024-02-29 18:29:33','022024','CO','1090477933','CARLA','TORRES','AV 3 NUMERO 7 -51 LA VICTORIA ',' 3222384489','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','7','134617.64705882352','6482.352941176468','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:29:33','141100','09','BOD. FARMANORTE 09','1','66000','66000','66000','0','66000','1','0','0','','29/02/2024','',0,141100,0,'7707232097701','VENASFULL MAX FORTE *60 CAP','271','NATURAL FRESHLY','2024-02-29 18:29:33',  38121.8, 47190, 11, 9),('FVE','FNK','017671','2024-02-29 18:29:33','022024','CO','1090477933','CARLA','TORRES','AV 3 NUMERO 7 -51 LA VICTORIA ',' 3222384489','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','7','134617.64705882352','6482.352941176468','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:29:33','141100','09','BOD. FARMANORTE 09','1','37000','37000','31092.43697479','5907.5630252101','37000','1','0','0','','29/02/2024','',0,141100,0,'7709936891302','FLEXAFLEX VEN GEL * 60 GR','642','GFC','2024-02-29 18:29:33',  12739, 57531, 11, 9),('FVE','FNK','017671','2024-02-29 18:29:33','022024','CO','1090477933','CARLA','TORRES','AV 3 NUMERO 7 -51 LA VICTORIA ',' 3222384489','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','7','134617.64705882352','6482.352941176468','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:29:33','141100','09','BOD. FARMANORTE 09','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','29/02/2024','',0,141100,0,'7702057086824','YODORA MINI ROLLON DERMA CONTROL *30 GR ','889','TECNOQUIMICAS CONSUMO','2024-02-29 18:29:33',  2329.35, 59364, 11, 9),('FVE','FNK','017671','2024-02-29 18:29:33','022024','CO','1090477933','CARLA','TORRES','AV 3 NUMERO 7 -51 LA VICTORIA ',' 3222384489','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','7','134617.64705882352','6482.352941176468','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:29:33','141100','09','BOD. FARMANORTE 09','1','20300','20300','20300','0','20300','1','0','0','','29/02/2024','',0,141100,0,'7590002012468','VICK VAPORUB *50 GR','820','PROCTER & GAMBLE CHC','2024-02-29 18:29:33',  19188, 40254, 11, 9),('FVE','FNK','017671','2024-02-29 18:29:33','022024','CO','1090477933','CARLA','TORRES','AV 3 NUMERO 7 -51 LA VICTORIA ',' 3222384489','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','7','134617.64705882352','6482.352941176468','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:29:33','141100','09','BOD. FARMANORTE 09','1','12000','12000','12000','0','12000','1','0','0','','29/02/2024','',0,141100,0,'7702870553770','MOVIDOL *8 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-02-29 18:29:33',  10027, 60556, 11, 9),('FVE','FNK','017672','2024-02-29 18:34:41','022024','CO','13457677','GUSTAVO','CALDERON','CALLE 19 #25-48 SIMON BOLIVAR','3160535285 3115742107','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','4','72200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:34:41','72200','09','BOD. FARMANORTE 09','1','200','200','200','0','200','1','0','0','','29/02/2024','',72200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-02-29 18:34:41',  100, 44347, 11, 9),('FVE','FNK','017672','2024-02-29 18:34:41','022024','CO','13457677','GUSTAVO','CALDERON','CALLE 19 #25-48 SIMON BOLIVAR','3160535285 3115742107','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','4','72200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:34:41','72200','09','BOD. FARMANORTE 09','2','35000','70000','70000','0','70000','2','0','0','','29/02/2024','',72200,0,0,'7703712080362','AZITROFAR 500 MG * 3 TAB /D24/','387','TRIDEX FARMACEUTICA','2024-02-29 18:34:41',  21600, 40614, 11, 9),('FVE','FNK','017672','2024-02-29 18:34:41','022024','CO','13457677','GUSTAVO','CALDERON','CALLE 19 #25-48 SIMON BOLIVAR','3160535285 3115742107','002','CRUZ DELINA','VERA FLOREZ','3591','ANJELO JOSSUE','SANCHEZ PENALOZA','','','','','','4','72200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:34:41','72200','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','1','0','0','','29/02/2024','',72200,0,0,'DO','DOMICILIO','00','VARIOS','2024-02-29 18:34:41',  1500, 44348, 11, 9),('FVE','FNK','017673','2024-02-29 18:37:15','022024','CO','1094167603','JHON','ESPINOZA','0',' 3214864224','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','64700','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:37:15','64700','09','BOD. FARMANORTE 09','1','64700','64700','64700','0','64700','1','0','0','7','29/02/2024','',64700,0,0,'7501058631152','BABY KLIM 1+ LATA *800 GR','311','NESTLE NUTRICION','2024-02-29 18:37:15',  59868, 51947, 11, 9),('FVE','FNK','017674','2024-02-29 18:38:46','022024','CO','30766053','SIMON ','RONDON','0','0 3175257529','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','44429.41176470588','670.5882352941176','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:38:46','45100','09','BOD. FARMANORTE 09','1','32000','32000','32000','0','32000','1','0','0','','29/02/2024','',0,45100,0,'7707263004631','GALEZOL 500 MG * 6 TAB  /D28/','387','TRIDEX FARMACEUTICA','2024-02-29 18:38:46',  22800, 62671, 11, 9),('FVE','FNK','017674','2024-02-29 18:38:46','022024','CO','30766053','SIMON ','RONDON','0','0 3175257529','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','44429.41176470588','670.5882352941176','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:38:46','45100','09','BOD. FARMANORTE 09','2','2100','4200','3529.4117647059','670.58823529412','4200','2','0','0','','29/02/2024','',0,45100,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2024-02-29 18:38:46',  999.61, 55601, 11, 9),('FVE','FNK','017674','2024-02-29 18:38:46','022024','CO','30766053','SIMON ','RONDON','0','0 3175257529','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','44429.41176470588','670.5882352941176','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:38:46','45100','09','BOD. FARMANORTE 09','1','8900','8900','8900','0','8900','1','0','0','','29/02/2024','',0,45100,0,'7702057075101','ALCOHOL MK *700 ML','624','TECNOQUIMICAS CUIDADO DE HERIDA','2024-02-29 18:38:46',  6411.65, 42767, 11, 9),('FVE','FNK','017675','2024-02-29 18:56:43','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','029','CARLOS ANDRES ','MIRANDA GARCIA','','TERCERO','VARIOS','','','','','','1','22200','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 18:56:44','22200','09','BOD. FARMANORTE 09','1','22200','22200','22200','0','22200','1','0','0','','29/02/2024','',22200,0,0,'7702418000872,0','CONCOR 5 MG *30 TAB','305','MERCK COLOMBIA FARMA','2024-02-29 18:56:43',  20900, 32908, 11, 9),('FVE','FNK','017676','2024-02-29 19:03:22','022024','CO','1093775191','BRENDA ','BECERRA CARDENAS','Calle 29 #1a-11 virgilio barco',' 3114703418','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','992741','22732595','CHARRIS MARIN JULIETH SOFIA','','','1','16500','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 19:03:22','16500','09','BOD. FARMANORTE 09','1','16500','16500','16500','0','16500','1','0','0','29','29/02/2024','',0,16500,0,'7703546012539','TENSOFAR 50 MG * 30 TAB L-CONSUM','630','NOVAMED OTC','2024-02-29 19:03:22',  15893, 49874, 11, 9),('FVE','FNK','017677','2024-02-29 19:04:14','022024','CO','1093781128','CRUZ DELINA','VERA FLOREZ','AV 10 MZ 18 LTE 229 VIDELSO LO',' 3154372806','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3529.4117647058824','670.5882352941176','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 19:04:14','4200','09','BOD. FARMANORTE 09','1','4200','4200','3529.4117647059','670.58823529412','4200','1','0','0','','29/02/2024','',4200,0,0,'7702001124763','BON YURT PIAZZA *174 GR','110','ALPINA PRODS. ALIMENTICIOS S.A.','2024-02-29 19:04:14',  2867, 53828, 11, 9),('FVE','FNK','017678','2024-02-29 19:15:33','022024','CO','1003241042','CAMILO','MADARIAGA','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','7000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 19:15:34','7000','09','BOD. FARMANORTE 09','1','2500','2500','2500','0','2500','0','1','0','','29/02/2024','',7000,0,0,'7707232098074','MIELTERTOS GRIPA NOCHE PANELA-LIMON *24 S/S','271','NATURAL FRESHLY','2024-02-29 19:15:33',  36283.5, 25785, 11, 9),('FVE','FNK','017678','2024-02-29 19:15:33','022024','CO','1003241042','CAMILO','MADARIAGA','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','7000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 19:15:34','7000','09','BOD. FARMANORTE 09','1','2500','2500','2500','0','2500','0','1','0','','29/02/2024','',7000,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-02-29 19:15:33',  18581.4, 46200, 11, 9),('FVE','FNK','017678','2024-02-29 19:15:33','022024','CO','1003241042','CAMILO','MADARIAGA','',' 0','1981','EDWIN YESID','MENDOZA VELASCO','','TERCERO','VARIOS','','','','','','3','7000','0','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 19:15:34','7000','09','BOD. FARMANORTE 09','1','2000','2000','2000','0','2000','0','1','0','','29/02/2024','',7000,0,0,'7708152336758','SUREZINC TRANSFER VAINILLA * 36 S/S','1007','SUREZINC','2024-02-29 19:15:33',  25000, 62424, 11, 9),('FVE','FNK','017679','2024-02-29 19:31:05','022024','CO','99','CLIENTE ','PUNTO DE VENTA','1','#####99 #####99 3206730451','111','SERGIO ANDRES','QUINONEZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3193.27731092437','606.7226890756301','09','FARMANORTE 09','ADMINISTRADOR','2024-02-29 19:31:06','3800','09','BOD. FARMANORTE 09','1','3800','3800','3193.2773109244','606.72268907563','3800','1','0','0','','29/02/2024','',3800,0,0,'7702535022061','JUGO DEL VALLE FRUTAS CITRICAS *1.5 LT','144','COCA COLA','2024-02-29 19:31:05',  2389.8, 57040, 11, 9);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '022024' AND DECODBOD='09';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '022024' AND DECODBOD='09';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '022024' AND DECODBOD='09';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '022024' AND DECODBOD='09';
