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','F351','020985','2024-04-28 18:47:33','042024','CO','33308015','CARMEN ','ARRIETA ','CALLE 47 D # 1 C - 242',' 3145804639','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','6','13697.47899159664','2602.521008403361','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 18:47:33','16300','351','BOD. FARMANORTE 351','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','28/04/2024','',0,16300,0,'7702189054166','DETODITO MEGA BBQ *65 GR','762','FRITO LAY','2024-04-28 18:47:33',  2391, 54668, 742, 372),('FVE','F351','020985','2024-04-28 18:47:33','042024','CO','33308015','CARMEN ','ARRIETA ','CALLE 47 D # 1 C - 242',' 3145804639','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','6','13697.47899159664','2602.521008403361','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 18:47:33','16300','351','BOD. FARMANORTE 351','2','1600','3200','2689.0756302521','510.9243697479','3200','2','0','0','','28/04/2024','',0,16300,0,'7702133009037','GALLETA OREO ORIGINAL *54 GR','754','DISCOB NORTE SAS','2024-04-28 18:47:33',  980.3916, 53741, 742, 372),('FVE','F351','020986','2024-04-28 19:01:02','042024','CO','1193547468','STEFANIA ','GALAN','',' 3114782105','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','8','39240.50420168067','239.4957983193276','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:01:02','39480','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','28/04/2024','',39480,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-28 19:01:02',  100, 44347, 742, 372),('FVE','F351','020986','2024-04-28 19:01:02','042024','CO','1193547468','STEFANIA ','GALAN','',' 3114782105','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','8','39240.50420168067','239.4957983193276','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:01:02','39480','351','BOD. FARMANORTE 351','2','6040','12080','12080','0','12080','0','2','0','','28/04/2024','',39480,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-04-28 19:01:02',  53223.5, 41855, 742, 372),('FVE','F351','020986','2024-04-28 19:01:02','042024','CO','1193547468','STEFANIA ','GALAN','',' 3114782105','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','8','39240.50420168067','239.4957983193276','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:01:02','39480','351','BOD. FARMANORTE 351','3','5600','16800','16800','0','16800','0','3','0','','28/04/2024','',39480,0,0,'7709990568288','DIOSMIT 3GR CAJA *6 SOBRES','313','NTI (NEW TRADE INTERNATIONAL)','2024-04-28 19:01:02',  14100, 54384, 742, 372),('FVE','F351','020986','2024-04-28 19:01:02','042024','CO','1193547468','STEFANIA ','GALAN','',' 3114782105','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','8','39240.50420168067','239.4957983193276','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:01:02','39480','351','BOD. FARMANORTE 351','1','8900','8900','8900','0','8900','1','0','0','','28/04/2024','',39480,0,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-28 19:01:02',  6610, 47205, 742, 372),('FVE','F351','020986','2024-04-28 19:01:02','042024','CO','1193547468','STEFANIA ','GALAN','',' 3114782105','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','8','39240.50420168067','239.4957983193276','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:01:02','39480','351','BOD. FARMANORTE 351','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','28/04/2024','',39480,0,0,'7622300124526','GALLETA RITZ SANDWICH QUESO *30 GR','754','DISCOB NORTE SAS','2024-04-28 19:01:02',  924.4, 35207, 742, 372),('FVE','F351','020987','2024-04-28 19:03:16','042024','CO','72256405','HERNAN','NI Ntilde O','',' 3103204040','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','6040','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:03:16','6040','351','BOD. FARMANORTE 351','1','6040','6040','6040','0','6040','0','1','0','','28/04/2024','',6040,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-04-28 19:03:16',  53223.5, 41855, 742, 372),('FVE','F351','020988','2024-04-28 19:12:24','042024','CO','22622606','MERCEDES','DE LA HOZ ','C',' 3003456287','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','3','4705.042016806723','494.9579831932772','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:12:24','5200','351','BOD. FARMANORTE 351','1','2100','2100','2100','0','2100','0','1','0','','28/04/2024','',0,5200,0,'7703381002313','BUSCAPINA FEM *90 COMP ','772','OPELLA (SANOFI OTC)','2024-04-28 19:12:24',  134048.9, 23812, 742, 372),('FVE','F351','020988','2024-04-28 19:12:24','042024','CO','22622606','MERCEDES','DE LA HOZ ','C',' 3003456287','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','3','4705.042016806723','494.9579831932772','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:12:24','5200','351','BOD. FARMANORTE 351','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','28/04/2024','',0,5200,0,'7702133009037','GALLETA OREO ORIGINAL *54 GR','754','DISCOB NORTE SAS','2024-04-28 19:12:24',  980.3916, 53741, 742, 372),('FVE','F351','020988','2024-04-28 19:12:24','042024','CO','22622606','MERCEDES','DE LA HOZ ','C',' 3003456287','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','3','4705.042016806723','494.9579831932772','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:12:24','5200','351','BOD. FARMANORTE 351','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','28/04/2024','',0,5200,0,'77082381','COCA COLA ZERO *250 ML','144','COCA COLA','2024-04-28 19:12:24',  1031.1666, 34412, 742, 372),('FVE','F351','020989','2024-04-28 19:17:13','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','22476.190476190477','1123.809523809523','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:17:13','23600','351','BOD. FARMANORTE 351','1','23600','23600','22476.19047619','1123.8095238095','23600','1','0','0','','28/04/2024','',23600,0,0,'7702049001637','AGUARDIENTE ANTIOQUEÑO *375 ML T.VERDE S/AZUCAR','808','ANTIOQUIA AGUARDIENTE','2024-04-28 19:17:13',  12036, 58355, 742, 372),('FVE','F351','020990','2024-04-28 19:19:45','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','8900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:19:45','8900','351','BOD. FARMANORTE 351','1','8900','8900','8900','0','8900','1','0','0','','28/04/2024','',8900,0,0,'7501125184277','ELECTROLIT MORA AZUL SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-28 19:19:45',  6785, 59848, 742, 372),('FVE','F351','020991','2024-04-28 19:30:08','042024','CO','72247713','PEDRO','MIRANDA','',' 3014578904','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','18','37400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:30:08','37400','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','28/04/2024','',0,37400,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-28 19:30:08',  100, 44347, 742, 372),('FVE','F351','020991','2024-04-28 19:30:08','042024','CO','72247713','PEDRO','MIRANDA','',' 3014578904','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','18','37400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:30:08','37400','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','28/04/2024','',0,37400,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-04-28 19:30:08',  28997, 54625, 742, 372),('FVE','F351','020991','2024-04-28 19:30:08','042024','CO','72247713','PEDRO','MIRANDA','',' 3014578904','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','18','37400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:30:08','37400','351','BOD. FARMANORTE 351','1','17100','17100','17100','0','17100','1','0','0','','28/04/2024','',0,37400,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-04-28 19:30:08',  2500, 57400, 742, 372),('FVE','F351','020991','2024-04-28 19:30:08','042024','CO','72247713','PEDRO','MIRANDA','',' 3014578904','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','18','37400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:30:08','37400','351','BOD. FARMANORTE 351','5','1500','7500','7500','0','7500','0','5','0','','28/04/2024','',0,37400,0,'7707263004051','GRIPAC 4 * 100 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-04-28 19:30:08',  94299, 58014, 742, 372),('FVE','F351','020991','2024-04-28 19:30:08','042024','CO','72247713','PEDRO','MIRANDA','',' 3014578904','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','18','37400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:30:08','37400','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','28/04/2024','',0,37400,0,'7501033961540','PEDIALYTE MAX ZINC 60 COCO *500 ML','659','ABBOTT NUTRICION','2024-04-28 19:30:08',  8380, 55720, 742, 372),('FVE','F351','020992','2024-04-28 19:45:07','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','2689.075630252101','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:45:07','3200','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','28/04/2024','',3200,0,0,'7702402057554','CHOCOCONO BAKANO *110 GR','296','MEALS DE COLOMBIA','2024-04-28 19:45:07',  1875, 61619, 742, 372),('FVE','F351','020993','2024-04-28 19:47:00','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','4','5200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:47:00','5200','351','BOD. FARMANORTE 351','4','1300','5200','5200','0','5200','0','4','0','','28/04/2024','',5200,0,0,'7703546031608','CONGESTEX * 60 CAP  L-TR-CAPS','630','NOVAMED OTC','2024-04-28 19:47:00',  67353, 38541, 742, 372),('FVE','F351','020994','2024-04-28 19:47:34','042024','CO','1007968250','DAVID','MENDOZA','0',' 3167134322','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','19200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:47:34','19200','351','BOD. FARMANORTE 351','1','19200','19200','19200','0','19200','1','0','0','28','28/04/2024','',19200,0,0,'7703689000448','CYCLOFEM 0.5 ML AMP + JERINGA  ','344','PROFAMILIA','2024-04-28 19:47:34',  16550, 40547, 742, 372),('FVE','F351','020995','2024-04-28 19:48:46','042024','CO','1140875432','ANDY','GUSMAN','',' 0','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','56500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:48:46','56500','351','BOD. FARMANORTE 351','1','56500','56500','56500','0','56500','1','0','0','','28/04/2024','',56500,0,0,'0427030004938','SIMILAC AR *375 GR','659','ABBOTT NUTRICION','2024-04-28 19:48:46',  77760, 22300, 742, 372),('FVE','F351','020996','2024-04-28 19:52:38','042024','CO','17903750','CARLOS','BARRAZA','',' 3192717206','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','9100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:52:39','9100','351','BOD. FARMANORTE 351','1','9100','9100','9100','0','9100','1','0','0','','28/04/2024','',9100,0,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-04-28 19:52:38',  8329, 52291, 742, 372),('FVE','F351','020997','2024-04-28 19:52:47','042024','CO','1045676812','MARLON','MARTINEZ','',' 3135633375','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','4320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:52:47','4400','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','28/04/2024','',4400,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-04-28 19:52:47',  255, 46100, 742, 372),('FVE','F351','020997','2024-04-28 19:52:47','042024','CO','1045676812','MARLON','MARTINEZ','',' 3135633375','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','4320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:52:47','4400','351','BOD. FARMANORTE 351','1','3900','3900','3900','0','3900','1','0','0','','28/04/2024','',4400,0,0,'7709478324955','DIPIRONA SODICA 1GR/2ML *1 AMP','701','VITALIS COMERCIAL','2024-04-28 19:52:47',  2100, 54744, 742, 372),('FVE','F351','020998','2024-04-28 19:55:49','042024','CO','1234094860','CARLOS','GONZALES','',' 3016462084','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','4','37800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:55:49','37800','351','BOD. FARMANORTE 351','1','14900','14900','14900','0','14900','1','0','0','','28/04/2024','',37800,0,0,'7707019328653','ASMIKET *120 ML','130','LABQUIFAR PHARMACEUTICA','2024-04-28 19:55:49',  9220, 45846, 742, 372),('FVE','F351','020998','2024-04-28 19:55:49','042024','CO','1234094860','CARLOS','GONZALES','',' 3016462084','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','4','37800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:55:49','37800','351','BOD. FARMANORTE 351','1','17100','17100','17100','0','17100','1','0','0','','28/04/2024','',37800,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-04-28 19:55:49',  2500, 57400, 742, 372),('FVE','F351','020998','2024-04-28 19:55:49','042024','CO','1234094860','CARLOS','GONZALES','',' 3016462084','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','4','37800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 19:55:49','37800','351','BOD. FARMANORTE 351','2','2900','5800','5800','0','5800','0','2','0','','28/04/2024','',37800,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-04-28 19:55:49',  18581.4, 46200, 742, 372),('FVE','F351','020999','2024-04-28 20:03:40','042024','CR','1001944748','JOSE GABRIEL','GLENN DURAN ','CRA 26B NO.39-67',' 3008370045','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','726914','3','11092.436974789918','2107.5630252100827','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:06:27','13200','351','BOD. FARMANORTE 351','1','10000','10000','8403.3613445378','1596.6386554622','10000','1','0','0','','29/04/2024','',0,0,13200,'7891010560737','JOHNSON COPITOS PAGUE 60 LLEVE 75 UND','221','JOHNSON Y JOHNSON DE COL SA','2024-04-28 20:03:40',  6582, 27985, 742, 372),('FVE','F351','020999','2024-04-28 20:03:40','042024','CR','1001944748','JOSE GABRIEL','GLENN DURAN ','CRA 26B NO.39-67',' 3008370045','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','726914','3','11092.436974789918','2107.5630252100827','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:06:27','13200','351','BOD. FARMANORTE 351','1','1300','1300','1092.4369747899','207.56302521008','1300','1','0','0','','29/04/2024','',0,0,13200,'7622201717575','GALLETA CLUB SOCIAL ORIGINAL *24 GR','754','DISCOB NORTE SAS','2024-04-28 20:03:40',  560.2, 62038, 742, 372),('FVE','F351','020999','2024-04-28 20:03:40','042024','CR','1001944748','JOSE GABRIEL','GLENN DURAN ','CRA 26B NO.39-67',' 3008370045','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','726914','3','11092.436974789918','2107.5630252100827','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:06:27','13200','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','29/04/2024','',0,0,13200,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-04-28 20:03:40',  1142.8, 60397, 742, 372),('FVE','F351','021000','2024-04-28 20:20:16','042024','CO','1047215087','JHON','HEREDIA','',' 3122482985','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','12720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:20:16','12800','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','29/04/2024','',12800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-28 20:20:16',  100, 44347, 742, 372),('FVE','F351','021000','2024-04-28 20:20:16','042024','CO','1047215087','JHON','HEREDIA','',' 3122482985','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','12720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:20:16','12800','351','BOD. FARMANORTE 351','1','4100','4100','4100','0','4100','0','1','0','','29/04/2024','',12800,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-04-28 20:20:16',  7000, 23704, 742, 372),('FVE','F351','021000','2024-04-28 20:20:16','042024','CO','1047215087','JHON','HEREDIA','',' 3122482985','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','12720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:20:16','12800','351','BOD. FARMANORTE 351','1','3200','3200','3200','0','3200','0','1','0','','29/04/2024','',12800,0,0,'7703153040949','DICLOFENACO 75MG/3ML CJA * 10 AMP','422','COLMED','2024-04-28 20:20:16',  5600, 61834, 742, 372),('FVE','F351','021000','2024-04-28 20:20:16','042024','CO','1047215087','JHON','HEREDIA','',' 3122482985','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','12720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:20:16','12800','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/04/2024','',12800,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-04-28 20:20:16',  255, 46100, 742, 372),('FVE','F351','021000','2024-04-28 20:20:16','042024','CO','1047215087','JHON','HEREDIA','',' 3122482985','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','12720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:20:16','12800','351','BOD. FARMANORTE 351','3','1600','4800','4800','0','4800','0','3','0','','29/04/2024','',12800,0,0,'7703712085046','BINAFAR 200MG/500MG CJA * 24 TB /D24/','387','TRIDEX FARMACEUTICA','2024-04-28 20:20:16',  24900, 54476, 742, 372),('FVE','F351','021001','2024-04-28 20:24:18','042024','CO','55308401','OLGA ESTER','LARA','CALLE 45 C N 3 - 90 CIUDADELA ','  3104622187','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','92000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:24:18','92000','351','BOD. FARMANORTE 351','2','46000','92000','92000','0','92000','2','0','0','15','29/04/2024','',0,92000,0,'7501058626424','KLIM 1+ DESLACTOSADA LATA *800 GR','311','NESTLE NUTRICION','2024-04-28 20:24:18',  42616, 50766, 742, 372),('FVE','F351','021002','2024-04-28 20:26:01','042024','CO','1007174069','CARLOS','VASQUEZ','',' 0','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','10','13000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:26:01','13000','351','BOD. FARMANORTE 351','10','1300','13000','13000','0','13000','0','10','0','','29/04/2024','',13000,0,0,'8850769020106','ZIRIN 10 MG CJA * 50 CAPS','802','MEGA WE CARE','2024-04-28 20:26:01',  47007, 55996, 742, 372),('FVE','F351','021003','2024-04-28 20:26:07','042024','CO','55308401','OLGA ESTER','LARA','CALLE 45 C N 3 - 90 CIUDADELA ','  3104622187','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2521.008403361345','478.9915966386552','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:26:07','3000','351','BOD. FARMANORTE 351','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','29/04/2024','',0,3000,0,'7702090036923','GASEOSA MANZANA CERO *1 LT','192','POSTOBON GASEOSAS','2024-04-28 20:26:07',  1785.7, 53832, 742, 372),('FVE','F351','021004','2024-04-28 20:41:13','042024','CO','1042851780','ALEXIO','MURILLO','',' 0','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','15740','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:41:14','15740','351','BOD. FARMANORTE 351','4','1710','6840','6840','0','6840','0','4','0','','29/04/2024','',0,15740,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-04-28 20:41:13',  2500, 57400, 742, 372);
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','F351','021005','2024-04-28 20:45:36','042024','CO','72259114','LEONARDO','KABIES','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','7889.0756302521','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:45:36','8400','351','BOD. FARMANORTE 351','4','1300','5200','5200','0','5200','0','4','0','','29/04/2024','',8400,0,0,'7703546031608','CONGESTEX * 60 CAP  L-TR-CAPS','630','NOVAMED OTC','2024-04-28 20:45:36',  67353, 38541, 742, 372),('FVE','F351','021005','2024-04-28 20:45:36','042024','CO','72259114','LEONARDO','KABIES','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','7889.0756302521','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 20:45:36','8400','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','29/04/2024','',8400,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-28 20:45:36',  1806, 56307, 742, 372),('FVE','F351','021006','2024-04-28 21:01:39','042024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','44936.3025210084','2043.6974789915967','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:01:39','46980','351','BOD. FARMANORTE 351','2','6040','12080','12080','0','12080','0','2','0','','29/04/2024','',0,46980,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-04-28 21:01:39',  53223.5, 41855, 742, 372),('FVE','F351','021006','2024-04-28 21:01:39','042024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','44936.3025210084','2043.6974789915967','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:01:39','46980','351','BOD. FARMANORTE 351','1','22100','22100','22100','0','22100','1','0','0','','29/04/2024','',0,46980,0,'7707288822906','SULZINC SOLUCION * 120 ML','205','HUMAX PHARMACEUTICAL','2024-04-28 21:01:39',  19425, 27380, 742, 372),('FVE','F351','021006','2024-04-28 21:01:39','042024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','44936.3025210084','2043.6974789915967','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:01:39','46980','351','BOD. FARMANORTE 351','4','3200','12800','10756.302521008','2043.6974789916','12800','4','0','0','','29/04/2024','',0,46980,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-28 21:01:39',  1806, 56307, 742, 372),('FVE','F351','021007','2024-04-28 21:16:39','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','10','3000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:16:39','3000','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','29/04/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-04-28 21:16:39',  28997, 54625, 742, 372),('FVE','F351','021008','2024-04-28 21:21:17','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1975','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:21:17','1975','351','BOD. FARMANORTE 351','1','1975','1975','1975','0','1975','0','1','0','','29/04/2024','',1975,0,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-04-28 21:21:17',  14234, 54385, 742, 372),('FVE','F351','021009','2024-04-28 21:24:20','042024','CO','72244195','JOHAN ','BARRANCO','',' 0','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','14500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:24:20','14500','351','BOD. FARMANORTE 351','1','14500','14500','14500','0','14500','1','0','0','','29/04/2024','',14500,0,0,'7702870071465','BELLAFACE SUAVE *28 TAB','619','ABBOTT FARMA','2024-04-28 21:24:20',  12656, 47121, 742, 372),('FVE','F351','021010','2024-04-28 21:35:15','042024','CO','1130264067','ISAURA','DIAZ','',' 3215641246','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','22177.310924369747','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:35:15','22800','351','BOD. FARMANORTE 351','1','18900','18900','18900','0','18900','1','0','0','','29/04/2024','',22800,0,0,'7706569001191','CLOTRIMAZOL CREMA VAGINAL *40 GR','614','A.G. MEDICAMENTOS','2024-04-28 21:35:15',  14158, 31316, 742, 372),('FVE','F351','021010','2024-04-28 21:35:15','042024','CO','1130264067','ISAURA','DIAZ','',' 3215641246','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','22177.310924369747','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 21:35:15','22800','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','29/04/2024','',22800,0,0,'7702192224051','GATORADE MARACUYA *500 ML','192','POSTOBON GASEOSAS','2024-04-28 21:35:15',  2451, 35306, 742, 372),('FVE','F351','021011','2024-04-28 22:02:31','042024','CO','1143131184','PATRICIA','QUINTERO','',' 3012868437','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','19940.336134453784','2059.6638655462175','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:02:32','22000','351','BOD. FARMANORTE 351','1','12900','12900','10840.336134454','2059.6638655462','12900','1','0','0','10','29/04/2024','',22000,0,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-04-28 22:02:31',  8414.1, 33273, 742, 372),('FVE','F351','021011','2024-04-28 22:02:31','042024','CO','1143131184','PATRICIA','QUINTERO','',' 3012868437','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','19940.336134453784','2059.6638655462175','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:02:32','22000','351','BOD. FARMANORTE 351','1','9100','9100','9100','0','9100','1','0','0','3','29/04/2024','',22000,0,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-04-28 22:02:31',  8329, 52291, 742, 372),('FVE','F351','021012','2024-04-28 22:08:13','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','6386.55462184874','1213.4453781512602','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:08:13','7600','351','BOD. FARMANORTE 351','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','29/04/2024','',7600,0,0,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2024-04-28 22:08:13',  1159, 58744, 742, 372),('FVE','F351','021012','2024-04-28 22:08:13','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','6386.55462184874','1213.4453781512602','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:08:13','7600','351','BOD. FARMANORTE 351','2','2900','5800','4873.9495798319','926.05042016807','5800','2','0','0','','29/04/2024','',7600,0,0,'7702402052399','HELADO ARTESANAL MARACUYA *70 GR','296','MEALS DE COLOMBIA','2024-04-28 22:08:13',  1746.453, 54651, 742, 372),('FVE','F351','021013','2024-04-28 22:12:39','042024','CO','1007894070','YENEDITH','SANCHEZ','',' 3153010971','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','21889.0756302521','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:12:40','22400','351','BOD. FARMANORTE 351','1','19200','19200','19200','0','19200','1','0','0','27','29/04/2024','',0,22400,0,'7703689000448','CYCLOFEM 0.5 ML AMP + JERINGA  ','344','PROFAMILIA','2024-04-28 22:12:39',  16550, 40547, 742, 372),('FVE','F351','021013','2024-04-28 22:12:39','042024','CO','1007894070','YENEDITH','SANCHEZ','',' 3153010971','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','21889.0756302521','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:12:40','22400','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','29/04/2024','',0,22400,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-28 22:12:39',  1806, 56307, 742, 372),('FVE','F351','021014','2024-04-28 22:18:56','042024','CO','1042431409','JAIR','POLO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','8500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:18:57','8500','351','BOD. FARMANORTE 351','1','8500','8500','8500','0','8500','1','0','0','','29/04/2024','',8500,0,0,'7702057074470','IRBESARTAN 150 MG *14 TAB MK','654','MK ETICOS CONVENIO','2024-04-28 22:18:56',  6250.1, 43077, 742, 372),('FVE','F351','021015','2024-04-28 22:52:49','042024','CO','22643760','YESENIA PATRICIA','DE LA CRUZ RODRIGUEZ','11','0  3017162543','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','7800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:52:49','7800','351','BOD. FARMANORTE 351','1','7800','7800','7800','0','7800','1','0','0','','29/04/2024','',7800,0,0,'7703038065630','ACETAMINOFEN JARABE *90 ML','275','LAPROFF','2024-04-28 22:52:49',  3270.84, 46646, 742, 372),('FVE','F351','021016','2024-04-28 22:54:34','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','3277.310924369748','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 22:54:34','3900','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','29/04/2024','',3900,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','POSTOBON GASEOSAS','2024-04-28 22:54:34',  2451, 25826, 742, 372),('FVE','F351','021017','2024-04-28 23:14:18','042024','CO','32612444','EIMY JHOANA','RIVERA GUZMAN','',' 3128862660','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','8900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 23:14:18','8900','351','BOD. FARMANORTE 351','1','8900','8900','8900','0','8900','1','0','1','','29/04/2024','',8900,0,0,'7501125176548','ELECTROLIT UVA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-28 23:14:18',  6785, 33916, 742, 372),('FVE','F351','021018','2024-04-28 23:17:26','042024','CO','1045749686','DAVID','GOMEZ','',' 3015941449','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','5500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 23:17:26','5500','351','BOD. FARMANORTE 351','1','5500','5500','5500','0','5500','0','1','0','','29/04/2024','',0,5500,0,'7500435107020','VICK VAPORUB 12 GR *12 LATAS','820','PROCTER & GAMBLE CHC','2024-04-28 23:17:26',  56858, 40253, 742, 372),('FVE','F351','021019','2024-04-28 23:26:56','042024','CO','1143229403','ADRIAN','PEREZ','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','8095','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 23:26:56','8095','351','BOD. FARMANORTE 351','5','1619','8095','8095','0','8095','0','5','0','','29/04/2024','',8095,0,0,'7702626214849','STREPSILS INTENSIVE MIEL-LIMON *16 TAB','357','RECKITT BENCKISER COLOMBIA S A','2024-04-28 23:26:56',  20656, 53074, 742, 372),('FVE','F351','021020','2024-04-28 23:28:39','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','5614.285714285715','135.71428571428567','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 23:28:40','5750','351','BOD. FARMANORTE 351','1','850','850','714.28571428571','135.71428571429','850','1','0','0','','29/04/2024','',5750,0,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-04-28 23:28:39',  369, 46955, 742, 372),('FVE','F351','021020','2024-04-28 23:28:39','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','5614.285714285715','135.71428571428567','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 23:28:40','5750','351','BOD. FARMANORTE 351','1','4900','4900','4900','0','4900','1','0','0','','29/04/2024','',5750,0,0,'7707228362141','CINTA MICROPOROSA PIEL ALFASAFE 1 X 3 YD','429','ALFA SAFE','2024-04-28 23:28:39',  3036, 60552, 742, 372),('FVE','F351','021021','2024-04-28 23:41:09','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','3361.3445378151264','638.6554621848736','351','FARMANORTE 351','ADMINISTRADOR','2024-04-28 23:41:09','4000','351','BOD. FARMANORTE 351','1','4000','4000','3361.3445378151','638.65546218487','4000','1','0','0','','29/04/2024','',4000,0,0,'7702535022061','JUGO DEL VALLE FRUTAS CITRICAS *1.5 LT','144','COCA COLA','2024-04-28 23:41:09',  2389.8, 57040, 742, 372),('FVE','F351','021022','2024-04-29 00:41:57','042024','CO','1010118662','RONALDO','HERDENEZ','CRA 19   74 A 02 LOS CEDROS',' 3006556108','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','12300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 00:41:57','12300','351','BOD. FARMANORTE 351','1','3400','3400','3400','0','3400','0','1','0','','29/04/2024','',12300,0,0,'7702057841256','BONFIEST PLUS *32 SOBRES','382','TECNOQUIMICAS','2024-04-29 00:41:57',  87257.22, 43283, 742, 372),('FVE','F351','021022','2024-04-29 00:41:57','042024','CO','1010118662','RONALDO','HERDENEZ','CRA 19   74 A 02 LOS CEDROS',' 3006556108','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','12300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 00:41:57','12300','351','BOD. FARMANORTE 351','1','8900','8900','8900','0','8900','1','0','0','','29/04/2024','',12300,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-29 00:41:57',  6610, 54196, 742, 372),('FVE','F351','021023','2024-04-29 00:59:29','042024','CO','1044600562','JORDAN JESUS','ANGULO SIERRA','TRANSVERSAL 41D NO.41-08',' 3014127743','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','5500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 00:59:29','5500','351','BOD. FARMANORTE 351','1','2500','2500','2500','0','2500','0','1','1','','29/04/2024','',5500,0,0,'7709080992573','LYPTUS MIEL CHERRY CJA * 24 SOBRES','1000','NATURALMENTE','2024-04-29 00:59:29',  17000, 63439, 742, 372),('FVE','F351','021023','2024-04-29 00:59:29','042024','CO','1044600562','JORDAN JESUS','ANGULO SIERRA','TRANSVERSAL 41D NO.41-08',' 3014127743','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','5500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 00:59:29','5500','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','1','','29/04/2024','',5500,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-04-29 00:59:29',  28997, 54625, 742, 372),('FVE','F351','021024','2024-04-29 01:18:48','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 01:18:49','3100','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','29/04/2024','',3100,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2024-04-29 01:18:48',  1956.4, 34397, 742, 372),('FVE','F351','021025','2024-04-29 01:18:49','042024','CR','32612444','EIMY JHOANA','RIVERA GUZMAN','',' 3128862660','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','493529','3','5630.252100840336','1069.747899159664','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 02:00:37','6700','351','BOD. FARMANORTE 351','2','1800','3600','3025.2100840336','574.78991596639','3600','2','0','0','','29/04/2024','',0,0,6700,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2024-04-29 01:18:49',  1159, 58744, 742, 372),('FVE','F351','021025','2024-04-29 01:18:49','042024','CR','32612444','EIMY JHOANA','RIVERA GUZMAN','',' 3128862660','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','493529','3','5630.252100840336','1069.747899159664','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 02:00:37','6700','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','29/04/2024','',0,0,6700,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2024-04-29 01:18:49',  1956.4, 34397, 742, 372),('FVE','F351','021026','2024-04-29 02:10:42','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','3277.310924369748','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 02:10:42','3900','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','29/04/2024','',3900,0,0,'7702192224051','GATORADE MARACUYA *500 ML','192','POSTOBON GASEOSAS','2024-04-29 02:10:42',  2451, 35306, 742, 372),('FVE','F351','021027','2024-04-29 06:25:40','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 06:25:40','3100','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','29/04/2024','',3100,0,0,'7702090029888','HIT TROPICAL *500 ML','192','POSTOBON GASEOSAS','2024-04-29 06:25:40',  1750.7, 35524, 742, 372),('FVE','F351','021028','2024-04-29 06:31:41','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','10','3949.5798319327732','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 06:31:41','4700','351','BOD. FARMANORTE 351','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','29/04/2024','',4700,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-04-29 06:31:41',  15435, 56535, 742, 372),('FVE','F351','021029','2024-04-29 06:53:25','042024','CO','1143444113','LEYDI','ALEJANDRA AREVALO','CRA44B #44-14 CASA URB. EL PAR',' 3005545867','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2689.075630252101','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 06:53:25','3200','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','29/04/2024','',0,3200,0,'7702535014233','FUZE TEA TE NEGRO DURAZNO 400ML','144','COCA COLA','2024-04-29 06:53:25',  1712, 35164, 742, 372),('FVE','F351','021030','2024-04-29 06:55:38','042024','CO','1048209364','ALVARO','HERRERA','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','6050.420168067227','1149.5798319327732','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 06:55:38','7200','351','BOD. FARMANORTE 351','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','29/04/2024','',7200,0,0,'7702535009994','POWERADE BLAST *500 ML','144','COCA COLA','2024-04-29 06:55:38',  1916.6667, 36976, 742, 372),('FVE','F351','021030','2024-04-29 06:55:38','042024','CO','1048209364','ALVARO','HERRERA','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','6050.420168067227','1149.5798319327732','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 06:55:38','7200','351','BOD. FARMANORTE 351','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','29/04/2024','',7200,0,0,'7702535009987','POWERADE FRUTAS TROPICALES *500 ML','144','COCA COLA','2024-04-29 06:55:38',  1916.7, 36974, 742, 372),('FVE','F351','021031','2024-04-29 07:52:00','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 07:52:00','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','29/04/2024','',1900,0,0,'7702090069495','ACQUA POSTOBON MANZANA S/CALORIAS *400 ML','192','POSTOBON GASEOSAS','2024-04-29 07:52:00',  840.4, 60819, 742, 372),('DVE','F351','00034','2024-04-29 08:02:30','042024','CO','1001915582','SAMUEL','SIMANCA ','1',' 3006686349','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','CAMBIO DE PRODUCTO POR LA FACTURA 20923','006','1','28400','0','351','FARMANORTE 351','AUDITORIA','2024-04-29 08:02:31','28400','351','BOD. FARMANORTE 351','1','28400','28400','28400','0','28400','1','0','0','','29/04/2024','29/04/2024',0,0,0,'7706142707113','NEOFUNGINA TALCO *100 GR','272','LAB NEO','2024-04-29 08:02:30',  20031.2564, 30348, 742, 372);
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','F351','021032','2024-04-29 08:21:43','042024','CR','1001944748','JOSE GABRIEL','GLENN DURAN ','CRA 26B NO.39-67',' 3008370045','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','823544','1','1428.5714285714287','271.42857142857133','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 08:22:43','1700','351','BOD. FARMANORTE 351','1','1700','1700','1428.5714285714','271.42857142857','1700','1','0','0','','29/04/2024','',0,0,1700,'7702189056214','CHOKIS CLASICA *37 GR.','762','FRITO LAY','2024-04-29 08:21:43',  1050, 57344, 742, 372),('FVE','F351','021033','2024-04-29 08:29:11','042024','CO','22389509','MARINA','GONZALES','cra 1 c 46 e -16  ',' 3209204','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','3','39920.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 08:29:11','40000','351','BOD. FARMANORTE 351','1','37500','37500','37500','0','37500','1','0','0','','29/04/2024','',40000,0,0,'8027950200245','KENACORT-A AMP *5 ML','137','BRISTOL MYERS SQUIBB','2024-04-29 08:29:11',  31941, 32959, 742, 372),('FVE','F351','021033','2024-04-29 08:29:11','042024','CO','22389509','MARINA','GONZALES','cra 1 c 46 e -16  ',' 3209204','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','3','39920.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 08:29:11','40000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',40000,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-29 08:29:11',  1500, 44348, 742, 372),('FVE','F351','021033','2024-04-29 08:29:11','042024','CO','22389509','MARINA','GONZALES','cra 1 c 46 e -16  ',' 3209204','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','3','39920.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 08:29:11','40000','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/04/2024','',40000,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-04-29 08:29:11',  255, 46100, 742, 372),('FVE','F351','021034','2024-04-29 11:44:28','042024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','1975','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 11:44:28','1975','351','BOD. FARMANORTE 351','1','1975','1975','1975','0','1975','0','1','1','','29/04/2024','',1975,0,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-04-29 11:44:28',  14234, 54385, 742, 372),('FVE','F351','021035','2024-04-29 13:12:27','042024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','8','15988.235294117649','1061.7647058823527','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:12:27','17050','351','BOD. FARMANORTE 351','1','3500','3500','3500','0','3500','0','1','0','','29/04/2024','',17050,0,0,'7702123005513','APRONAX 550 MG *60 TAB','631','BAYER OTC','2024-04-29 13:12:27',  175720, 46716, 742, 372),('FVE','F351','021035','2024-04-29 13:12:27','042024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','8','15988.235294117649','1061.7647058823527','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:12:27','17050','351','BOD. FARMANORTE 351','1','850','850','714.28571428571','135.71428571429','850','1','0','0','','29/04/2024','',17050,0,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-04-29 13:12:27',  369, 46955, 742, 372),('FVE','F351','021035','2024-04-29 13:12:27','042024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','8','15988.235294117649','1061.7647058823527','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:12:27','17050','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/04/2024','',17050,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-04-29 13:12:27',  255, 46100, 742, 372),('FVE','F351','021035','2024-04-29 13:12:27','042024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','8','15988.235294117649','1061.7647058823527','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:12:27','17050','351','BOD. FARMANORTE 351','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','29/04/2024','',17050,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2024-04-29 13:12:27',  1358, 50688, 742, 372),('FVE','F351','021035','2024-04-29 13:12:27','042024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','8','15988.235294117649','1061.7647058823527','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:12:27','17050','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','29/04/2024','',17050,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-29 13:12:27',  1806, 56307, 742, 372),('FVE','F351','021035','2024-04-29 13:12:27','042024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','8','15988.235294117649','1061.7647058823527','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:12:27','17050','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','0','1','0','','29/04/2024','',17050,0,0,'7707232099095','ACTIVOX ICE JENGIBRE MASTICABLES * 12 S/S','271','NATURAL FRESHLY','2024-04-29 13:12:27',  17937, 33638, 742, 372),('FVE','F351','021035','2024-04-29 13:12:27','042024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','8','15988.235294117649','1061.7647058823527','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:12:27','17050','351','BOD. FARMANORTE 351','2','2000','4000','4000','0','4000','2','0','0','','29/04/2024','',17050,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 13:12:27',  800, 48019, 742, 372),('FVE','F351','021036','2024-04-29 13:15:14','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','2436.9747899159665','463.02521008403346','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:15:14','2900','351','BOD. FARMANORTE 351','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/04/2024','',2900,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2024-04-29 13:15:14',  1782, 54650, 742, 372),('FVE','F351','021037','2024-04-29 13:24:06','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','3800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:24:06','3800','351','BOD. FARMANORTE 351','1','3800','3800','3800','0','3800','1','0','0','','29/04/2024','',3800,0,0,'7702560026577','ALCOHOL JGB *120 ML','219','JGB','2024-04-29 13:24:06',  2529, 27762, 742, 372),('FVE','F351','021038','2024-04-29 13:50:07','042024','CO','33066848','CANDI','ESPA Ntilde A','',' 0','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','10','3200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 13:50:07','3200','351','BOD. FARMANORTE 351','10','320','3200','3200','0','3200','0','10','0','','29/04/2024','',3200,0,0,'7703546024501','TIAMINA 300 MG * 50 CAP L-CONSUM','630','NOVAMED OTC','2024-04-29 13:50:07',  11680.4, 45621, 742, 372),('FVE','F351','021039','2024-04-29 14:07:58','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','3000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 14:08:07','3000','351','BOD. FARMANORTE 351','2','1500','3000','3000','0','3000','0','2','0','','29/04/2024','',3000,0,0,'7707263004051','GRIPAC 4 * 100 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-04-29 14:07:58',  94299, 58014, 742, 372),('FVE','F351','021040','2024-04-29 14:26:33','042024','CO','1140867233','ANDRES ','MARTINEZ ','CARRERA 1 C 3 # 48 B - 14',' 3014762662','4119','KEVIN ','TOAMASSE','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','2','40655.46218487395','7344.537815126052','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 14:26:33','48000','351','BOD. FARMANORTE 351','1','46000','46000','38655.462184874','7344.5378151261','46000','1','0','0','','29/04/2024','',48000,0,0,'7705028000287','K-CIT GEL CON CALENDULA Y ALOE *15 GR','252','FARPAG','2024-04-29 14:26:33',  31724, 48552, 742, 372),('FVE','F351','021040','2024-04-29 14:26:33','042024','CO','1140867233','ANDRES ','MARTINEZ ','CARRERA 1 C 3 # 48 B - 14',' 3014762662','4119','KEVIN ','TOAMASSE','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','2','40655.46218487395','7344.537815126052','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 14:26:33','48000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',48000,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-29 14:26:33',  1500, 44348, 742, 372),('FVE','F351','021041','2024-04-29 16:02:43','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','2436.9747899159665','463.02521008403346','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:02:43','2900','351','BOD. FARMANORTE 351','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/04/2024','',2900,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-04-29 16:02:43',  1768.4, 60339, 742, 372),('FVE','F351','021042','2024-04-29 16:02:44','042024','CR','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','393460','19','34689.075630252104','6210.924369747899','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:43:42','40900','351','BOD. FARMANORTE 351','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','29/04/2024','',0,0,40900,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-04-29 16:02:44',  1050.4, 47478, 742, 372),('FVE','F351','021042','2024-04-29 16:02:44','042024','CR','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','393460','19','34689.075630252104','6210.924369747899','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:43:42','40900','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','29/04/2024','',0,0,40900,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2024-04-29 16:02:44',  1956.4, 34397, 742, 372),('FVE','F351','021042','2024-04-29 16:02:44','042024','CR','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','393460','19','34689.075630252104','6210.924369747899','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:43:42','40900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',0,0,40900,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 16:02:44',  800, 48019, 742, 372),('FVE','F351','021042','2024-04-29 16:02:44','042024','CR','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','393460','19','34689.075630252104','6210.924369747899','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:43:42','40900','351','BOD. FARMANORTE 351','16','2100','33600','28235.294117647','5364.7058823529','33600','16','0','0','','29/04/2024','',0,0,40900,'7702024034186','COCOSETTE MAXI WAFER * 46 GR','776','NESTLE FOOD & BEVERAGE','2024-04-29 16:02:44',  1091, 38319, 742, 372),('FVE','F351','021046','2024-04-29 16:44:04','042024','CR','1143135566','KEVIN ','TOAMASSE','CALLE 78B 21A-28 LOS ROBLES',' 3004147317','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','818577','2','6974.789915966387','1325.2100840336134','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 17:25:32','8300','351','BOD. FARMANORTE 351','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','29/04/2024','',0,0,8300,'7702090038088','JUGO HIT NARANJA-PIÑA *1 LT','192','POSTOBON GASEOSAS','2024-04-29 16:44:04',  2422.61, 53888, 742, 372),('FVE','F351','021046','2024-04-29 16:44:04','042024','CR','1143135566','KEVIN ','TOAMASSE','CALLE 78B 21A-28 LOS ROBLES',' 3004147317','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','818577','2','6974.789915966387','1325.2100840336134','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 17:25:32','8300','351','BOD. FARMANORTE 351','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','29/04/2024','',0,0,8300,'7702189054166','DETODITO MEGA BBQ *65 GR','762','FRITO LAY','2024-04-29 16:44:04',  2391, 54668, 742, 372),('FVE','F351','021043','2024-04-29 16:54:48','042024','CO','9100734','LEONARDO','VELEZ','',' 3106821396','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','24700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:54:48','24700','351','BOD. FARMANORTE 351','1','22700','22700','22700','0','22700','1','0','0','','29/04/2024','',24700,0,0,'7896261006249','DIOVAN 80 MG X 28 TABLS  ','904','SIEGFRIED NOVARTIS','2024-04-29 16:54:48',  18486, 38668, 742, 372),('FVE','F351','021043','2024-04-29 16:54:48','042024','CO','9100734','LEONARDO','VELEZ','',' 3106821396','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','24700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:54:48','24700','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',24700,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 16:54:48',  800, 48019, 742, 372),('FVE','F351','021044','2024-04-29 16:59:31','042024','CO','44155531','LUZ ELENA ','REGINO MADERA ','',' 3015554090','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','4993.27731092437','606.7226890756301','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:59:31','5600','351','BOD. FARMANORTE 351','1','3800','3800','3193.2773109244','606.72268907563','3800','1','0','0','','29/04/2024','',0,5600,0,'7702090069648','GASEOSA KOLA POSTOBON *1 LT','192','POSTOBON GASEOSAS','2024-04-29 16:59:31',  1785.7, 60902, 742, 372),('FVE','F351','021044','2024-04-29 16:59:31','042024','CO','44155531','LUZ ELENA ','REGINO MADERA ','',' 3015554090','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','4993.27731092437','606.7226890756301','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 16:59:31','5600','351','BOD. FARMANORTE 351','1','1800','1800','1800','0','1800','1','0','0','','29/04/2024','',0,5600,0,'7702535010341','AGUA BRISA CON GAS * 600 ML','144','COCA COLA','2024-04-29 16:59:31',  1156, 57012, 742, 372),('FVE','F351','021045','2024-04-29 17:23:16','042024','CO','1143169915','MELISSA','CANO','',' 3004613188','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','12016.806722689076','2283.193277310924','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 17:23:16','14300','351','BOD. FARMANORTE 351','1','14300','14300','12016.806722689','2283.1932773109','14300','1','0','0','','29/04/2024','',14300,0,0,'7707232090535','JABON DE AZUFRE *90 GR','271','NATURAL FRESHLY','2024-04-29 17:23:16',  6293.7, 30324, 742, 372),('FVE','F351','021047','2024-04-29 17:25:53','042024','CO','1143125172','JOSE MANUEL','MENDOZA','',' 3127050114','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','7800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 17:25:53','7800','351','BOD. FARMANORTE 351','1','7800','7800','7800','0','7800','1','0','0','','29/04/2024','',7800,0,0,'7703038065630','ACETAMINOFEN JARABE *90 ML','275','LAPROFF','2024-04-29 17:25:53',  3270.84, 46646, 742, 372),('FVE','F351','021048','2024-04-29 17:43:39','042024','CO','1129521855','JHONATAN ','SANTOS ','calle 49 1 a 76',' 3012826499','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','22941.176470588238','4358.823529411762','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 17:43:40','27300','351','BOD. FARMANORTE 351','1','27300','27300','22941.176470588','4358.8235294118','27300','1','0','0','','29/04/2024','',27300,0,0,'7701021118011','WINNY GOLD SENSITIVE ET1 *30 UND + 20 TOALLITAS','653','TECNOQUIMICAS WINNY','2024-04-29 17:43:39',  19786.31, 57318, 742, 372),('FVE','F351','021049','2024-04-29 18:05:08','042024','CO','22516504','TANIA ','REYNEL','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','11','48000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:05:08','48000','351','BOD. FARMANORTE 351','1','35000','35000','35000','0','35000','1','0','0','','29/04/2024','',48000,0,0,'7709465967349','DERGINTREX CREMA TOPICA * 40 GR','1000','NATURALMENTE','2024-04-29 18:05:08',  10200, 62080, 742, 372),('FVE','F351','021049','2024-04-29 18:05:08','042024','CO','22516504','TANIA ','REYNEL','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','11','48000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:05:08','48000','351','BOD. FARMANORTE 351','10','1300','13000','13000','0','13000','0','10','0','','29/04/2024','',48000,0,0,'8850769020106','ZIRIN 10 MG CJA * 50 CAPS','802','MEGA WE CARE','2024-04-29 18:05:08',  47007, 55996, 742, 372),('FVE','F351','021050','2024-04-29 18:35:04','042024','CO','1143164100','ANDREA ','HERRERA','CARRERA 8 B SUR No. 46 79 Parq',' 0 3114102492','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','2','34689.075630252104','6210.924369747896','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:35:05','40900','351','BOD. FARMANORTE 351','1','38900','38900','32689.075630252','6210.9243697479','38900','1','0','0','10','29/04/2024','',40900,0,0,'7701021115751','WINNY ULTRATRIM SEC ET1 *50 UND','653','TECNOQUIMICAS WINNY','2024-04-29 18:35:04',  28530.9, 57302, 742, 372),('FVE','F351','021050','2024-04-29 18:35:04','042024','CO','1143164100','ANDREA ','HERRERA','CARRERA 8 B SUR No. 46 79 Parq',' 0 3114102492','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','2','34689.075630252104','6210.924369747896','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:35:05','40900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',40900,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-29 18:35:04',  1500, 44348, 742, 372),('FVE','F351','021051','2024-04-29 18:37:21','042024','CO','1143164100','ANDREA ','HERRERA','CARRERA 8 B SUR No. 46 79 Parq',' 0 3114102492','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','1848.7394957983195','351.26050420168053','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:37:21','2200','351','BOD. FARMANORTE 351','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','29/04/2024','',2200,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-04-29 18:37:21',  1050.4, 47478, 742, 372),('FVE','F351','021052','2024-04-29 18:40:24','042024','CO','1193514833','DANIELA ','MARTINEZ','COJUNTO PUERTO GAITA TORRE 11 ',' 3046591486','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','5','28700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:40:24','28700','351','BOD. FARMANORTE 351','1','5500','5500','5500','0','5500','0','1','0','','29/04/2024','',0,28700,0,'7500435107020','VICK VAPORUB 12 GR *12 LATAS','820','PROCTER & GAMBLE CHC','2024-04-29 18:40:24',  56858, 40253, 742, 372),('FVE','F351','021052','2024-04-29 18:40:24','042024','CO','1193514833','DANIELA ','MARTINEZ','COJUNTO PUERTO GAITA TORRE 11 ',' 3046591486','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','5','28700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:40:24','28700','351','BOD. FARMANORTE 351','1','15800','15800','15800','0','15800','1','0','0','','29/04/2024','',0,28700,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-04-29 18:40:24',  14234, 54385, 742, 372),('FVE','F351','021052','2024-04-29 18:40:24','042024','CO','1193514833','DANIELA ','MARTINEZ','COJUNTO PUERTO GAITA TORRE 11 ',' 3046591486','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','5','28700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:40:24','28700','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',0,28700,0,'DO','DOMICILIO','00','VARIOS','2024-04-29 18:40:24',  1500, 44348, 742, 372);
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','F351','021053','2024-04-29 18:53:53','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:53:54','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','29/04/2024','',1900,0,0,'7702090069495','ACQUA POSTOBON MANZANA S/CALORIAS *400 ML','192','POSTOBON GASEOSAS','2024-04-29 18:53:53',  840.4, 60819, 742, 372),('FVE','F351','021054','2024-04-29 18:56:29','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 18:56:29','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','29/04/2024','',1900,0,0,'7622210427199','HALLS BARRA FRUIT MIX *9 PASTILLAS','754','DISCOB NORTE SAS','2024-04-29 18:56:29',  1176.47, 48743, 742, 372),('FVE','F351','021055','2024-04-29 19:01:03','042024','CO','32742133','VIVIANA','RAMIREZ','',' 3007537378','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','15200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:01:03','15200','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','29/04/2024','',15200,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-04-29 19:01:03',  28997, 54625, 742, 372),('FVE','F351','021055','2024-04-29 19:01:03','042024','CO','32742133','VIVIANA','RAMIREZ','',' 3007537378','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','15200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:01:03','15200','351','BOD. FARMANORTE 351','1','6300','6300','6300','0','6300','1','0','0','','29/04/2024','',15200,0,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2024-04-29 19:01:03',  4500, 48626, 742, 372),('FVE','F351','021055','2024-04-29 19:01:03','042024','CO','32742133','VIVIANA','RAMIREZ','',' 3007537378','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','15200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:01:03','15200','351','BOD. FARMANORTE 351','1','5900','5900','5900','0','5900','1','0','0','','29/04/2024','',15200,0,0,'7706569001467','CETIRIZINA 10MG *10 TAB','614','A.G. MEDICAMENTOS','2024-04-29 19:01:03',  4488, 31293, 742, 372),('FVE','F351','021056','2024-04-29 19:06:29','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','12700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:06:29','12700','351','BOD. FARMANORTE 351','1','12700','12700','12700','0','12700','1','0','0','','29/04/2024','',12700,0,0,'7707019402186','HEMETIL GOTAS *30 ML','130','LABQUIFAR PHARMACEUTICA','2024-04-29 19:06:29',  5620, 45889, 742, 372),('FVE','F351','021057','2024-04-29 19:08:11','042024','CO','1143155453','JERSON','DE LA HOZ','Carrera 1B#47-62',' 3246023542','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','6','26640','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:08:11','26640','351','BOD. FARMANORTE 351','1','16900','16900','16900','0','16900','1','0','0','','29/04/2024','',26640,0,0,'7707274723224','BACTROSAFE 500 MG * 3 TAB','890','ALLEN PHARMA','2024-04-29 19:08:11',  12099, 58701, 742, 372),('FVE','F351','021057','2024-04-29 19:08:11','042024','CO','1143155453','JERSON','DE LA HOZ','Carrera 1B#47-62',' 3246023542','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','6','26640','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:08:11','26640','351','BOD. FARMANORTE 351','4','1710','6840','6840','0','6840','0','4','0','','29/04/2024','',26640,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-04-29 19:08:11',  2500, 57400, 742, 372),('FVE','F351','021057','2024-04-29 19:08:11','042024','CO','1143155453','JERSON','DE LA HOZ','Carrera 1B#47-62',' 3246023542','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','6','26640','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:08:11','26640','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','0','1','0','','29/04/2024','',26640,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-04-29 19:08:11',  18581.4, 46200, 742, 372),('FVE','F351','021058','2024-04-29 19:09:31','042024','CO','1129510117','YOYARWIN','BARRIOS','calle 50 c  1 f  67  carrizal ',' 3022437845','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','3','96575.63025210085','7424.36974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:09:32','104000','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','29/04/2024','',104000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 19:09:31',  100, 44347, 742, 372),('FVE','F351','021058','2024-04-29 19:09:31','042024','CO','1129510117','YOYARWIN','BARRIOS','calle 50 c  1 f  67  carrizal ',' 3022437845','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','3','96575.63025210085','7424.36974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:09:32','104000','351','BOD. FARMANORTE 351','1','57300','57300','57300','0','57300','1','0','0','','29/04/2024','',104000,0,0,'7703546722407','NUTRIBEN NATAL 1 *400 GR','672','NOVAMED NUTRICIONAL','2024-04-29 19:09:31',  52126, 34333, 742, 372),('FVE','F351','021058','2024-04-29 19:09:31','042024','CO','1129510117','YOYARWIN','BARRIOS','calle 50 c  1 f  67  carrizal ',' 3022437845','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','3','96575.63025210085','7424.36974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:09:32','104000','351','BOD. FARMANORTE 351','1','46500','46500','39075.630252101','7424.3697478992','46500','1','0','0','','29/04/2024','',104000,0,0,'7701021115874','WINNY ULTRATRIM SEC ET2 *50 +20 TOALLITAS','653','TECNOQUIMICAS WINNY','2024-04-29 19:09:31',  34088.4, 58109, 742, 372),('FVE','F351','021059','2024-04-29 19:10:58','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','2','5378.151260504202','1021.8487394957983','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:10:58','6400','351','BOD. FARMANORTE 351','2','3200','6400','5378.1512605042','1021.8487394958','6400','2','0','0','','29/04/2024','',6400,0,0,'7702402057554','CHOCOCONO BAKANO *110 GR','296','MEALS DE COLOMBIA','2024-04-29 19:10:58',  1875, 61619, 742, 372),('FVE','F351','021060','2024-04-29 19:30:46','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','3500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:30:46','3500','351','BOD. FARMANORTE 351','1','3500','3500','3500','0','3500','0','1','0','','29/04/2024','',3500,0,0,'7702123005513','APRONAX 550 MG *60 TAB','631','BAYER OTC','2024-04-29 19:30:46',  175720, 46716, 742, 372),('FVE','F351','021061','2024-04-29 19:31:09','042024','CO','1007920651','DANIEL ','ROMERO','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','69100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:31:10','69100','351','BOD. FARMANORTE 351','1','69100','69100','69100','0','69100','1','0','0','','29/04/2024','',69100,0,0,'7506205808944','ENFAMIL PREMIUM 2 PROMENTAL *375 GR ','295','MEAD JOHNSON NUTRITION COLOMBIA','2024-04-29 19:31:09',  64190, 44681, 742, 372),('FVE','F351','021062','2024-04-29 19:31:47','042024','CO','72240684','JIMMY ',' ARIZA','BLOQUE 185 APT 102',' 3160427699','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','48','28400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:31:47','28400','351','BOD. FARMANORTE 351','5','1800','9000','9000','0','9000','0','5','0','','29/04/2024','',0,28400,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-04-29 19:31:47',  111600, 43550, 742, 372),('FVE','F351','021062','2024-04-29 19:31:47','042024','CO','72240684','JIMMY ',' ARIZA','BLOQUE 185 APT 102',' 3160427699','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','48','28400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:31:47','28400','351','BOD. FARMANORTE 351','2','2700','5400','5400','0','5400','0','2','0','','29/04/2024','',0,28400,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-04-29 19:31:47',  33370, 62346, 742, 372),('FVE','F351','021062','2024-04-29 19:31:47','042024','CO','72240684','JIMMY ',' ARIZA','BLOQUE 185 APT 102',' 3160427699','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','48','28400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:31:47','28400','351','BOD. FARMANORTE 351','40','300','12000','12000','0','12000','0','40','0','','29/04/2024','',0,28400,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-04-29 19:31:47',  28997, 54625, 742, 372),('FVE','F351','021062','2024-04-29 19:31:47','042024','CO','72240684','JIMMY ',' ARIZA','BLOQUE 185 APT 102',' 3160427699','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','48','28400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:31:47','28400','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',0,28400,0,'DO','DOMICILIO','00','VARIOS','2024-04-29 19:31:47',  1500, 44348, 742, 372),('FVE','F351','021063','2024-04-29 19:43:31','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','1975','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:43:31','1975','351','BOD. FARMANORTE 351','1','1975','1975','1975','0','1975','0','1','0','','30/04/2024','',1975,0,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-04-29 19:43:31',  14234, 54385, 742, 372),('FVE','F351','021068','2024-04-29 19:43:31','042024','CR','1001944748','JOSE GABRIEL','GLENN DURAN ','CRA 26B NO.39-67',' 3008370045','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','766450','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:20:06','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2024','',0,0,1900,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-04-29 19:43:31',  1142.8, 60397, 742, 372),('FVE','F351','021064','2024-04-29 19:45:34','042024','CO','1045724058','EDISON','ALTAMAR','CRA 2 A SUR 50B -20',' 3017379885','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','2','23764.70588235294','4135.2941176470595','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:45:34','27900','351','BOD. FARMANORTE 351','1','25900','25900','21764.705882353','4135.2941176471','25900','1','0','0','','30/04/2024','',27900,0,0,'7703332003178','ALERGIBON AVENA *90 GR ','365','MEGALABS','2024-04-29 19:45:34',  18736, 42037, 742, 372),('FVE','F351','021064','2024-04-29 19:45:34','042024','CO','1045724058','EDISON','ALTAMAR','CRA 2 A SUR 50B -20',' 3017379885','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','2','23764.70588235294','4135.2941176470595','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 19:45:34','27900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',27900,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-29 19:45:34',  1500, 44348, 742, 372),('FVE','F351','021065','2024-04-29 20:03:24','042024','CO','72231407','JORGE ','SANCHEZ ','',' 3104919134','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','9','21958.823529411766','1341.1764705882351','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:03:24','23300','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,23300,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 20:03:24',  100, 44347, 742, 372),('FVE','F351','021065','2024-04-29 20:03:24','042024','CO','72231407','JORGE ','SANCHEZ ','',' 3104919134','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','9','21958.823529411766','1341.1764705882351','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:03:24','23300','351','BOD. FARMANORTE 351','3','4900','14700','14700','0','14700','3','0','0','','30/04/2024','',0,23300,0,'7707228362141','CINTA MICROPOROSA PIEL ALFASAFE 1 X 3 YD','429','ALFA SAFE','2024-04-29 20:03:24',  3036, 60552, 742, 372),('FVE','F351','021065','2024-04-29 20:03:24','042024','CO','72231407','JORGE ','SANCHEZ ','',' 3104919134','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','9','21958.823529411766','1341.1764705882351','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:03:24','23300','351','BOD. FARMANORTE 351','5','1680','8400','7058.8235294118','1341.1764705882','8400','5','0','0','','30/04/2024','',0,23300,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2024-04-29 20:03:24',  999.61, 55601, 742, 372),('FVE','F351','021066','2024-04-29 20:05:49','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','2','3176.470588235294','603.5294117647059','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:05:49','3780','351','BOD. FARMANORTE 351','1','1680','1680','1411.7647058824','268.23529411765','1680','1','0','0','','30/04/2024','',3780,0,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2024-04-29 20:05:49',  999.61, 55601, 742, 372),('FVE','F351','021066','2024-04-29 20:05:49','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','2','3176.470588235294','603.5294117647059','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:05:49','3780','351','BOD. FARMANORTE 351','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','30/04/2024','',3780,0,0,'7702402051361','HELADO CASERO RON CON PASAS *60 GR','296','MEALS DE COLOMBIA','2024-04-29 20:05:49',  1206, 52362, 742, 372),('FVE','F351','021067','2024-04-29 20:05:49','042024','CR','1143135566','KEVIN ','TOAMASSE','CALLE 78B 21A-28 LOS ROBLES',' 3004147317','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','741459','5','7897.478991596639','1462.521008403361','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:12:06','9360','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,0,9360,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 20:05:49',  100, 44347, 742, 372),('FVE','F351','021067','2024-04-29 20:05:49','042024','CR','1143135566','KEVIN ','TOAMASSE','CALLE 78B 21A-28 LOS ROBLES',' 3004147317','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','741459','5','7897.478991596639','1462.521008403361','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:12:06','9360','351','BOD. FARMANORTE 351','2','1680','3360','2823.5294117647','536.47058823529','3360','2','0','0','','30/04/2024','',0,0,9360,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2024-04-29 20:05:49',  999.61, 55601, 742, 372),('FVE','F351','021067','2024-04-29 20:05:49','042024','CR','1143135566','KEVIN ','TOAMASSE','CALLE 78B 21A-28 LOS ROBLES',' 3004147317','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','741459','5','7897.478991596639','1462.521008403361','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:12:06','9360','351','BOD. FARMANORTE 351','2','2900','5800','4873.9495798319','926.05042016807','5800','2','0','0','','30/04/2024','',0,0,9360,'7702402054898','TOSH BARRA HELADA FRESA *75 GR','296','MEALS DE COLOMBIA','2024-04-29 20:05:49',  1791, 58218, 742, 372),('FVE','F351','021069','2024-04-29 20:20:14','042024','CO','19597971','ELIECER','PERTUZ','',' 3045836650','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','11450','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:20:14','11450','351','BOD. FARMANORTE 351','2','4600','9200','9200','0','9200','0','2','0','','30/04/2024','',11450,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-04-29 20:20:14',  27780, 54056, 742, 372),('FVE','F351','021069','2024-04-29 20:20:14','042024','CO','19597971','ELIECER','PERTUZ','',' 3045836650','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','7','11450','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:20:14','11450','351','BOD. FARMANORTE 351','5','450','2250','2250','0','2250','0','5','0','','30/04/2024','',11450,0,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-04-29 20:20:14',  13144, 31502, 742, 372),('FVE','F351','021070','2024-04-29 20:48:29','042024','CO','23190617','VIRGINIA','JULIO','',' 3201548794','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','12973.10924369748','2426.8907563025205','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:48:29','15400','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/04/2024','',15400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 20:48:29',  100, 44347, 742, 372),('FVE','F351','021070','2024-04-29 20:48:29','042024','CO','23190617','VIRGINIA','JULIO','',' 3201548794','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','12973.10924369748','2426.8907563025205','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 20:48:29','15400','351','BOD. FARMANORTE 351','4','3800','15200','12773.109243697','2426.8907563025','15200','4','0','0','','30/04/2024','',15400,0,0,'7702027472527','TENA SLIP CLASICO (ANTES BASIC) L *1 UND','337','FAMILIA SANCELA','2024-04-29 20:48:29',  2999, 40383, 742, 372),('FVE','F351','021071','2024-04-29 21:09:15','042024','CO','72281738','NELSON','GIRALDO','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','12857.142857142857','2442.857142857143','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 21:09:15','15300','351','BOD. FARMANORTE 351','1','15300','15300','12857.142857143','2442.8571428571','15300','1','0','0','','30/04/2024','',15300,0,0,'7500435019811','H & S  SHAMPO 2EN1 SUAVE MANEJABLE *180 ML','336','PROCTER & GAMBLE COLOMBIA','2024-04-29 21:09:15',  11750.7, 53527, 742, 372),('FVE','F351','021072','2024-04-29 21:21:36','042024','CO','1140837772','JASSIR','PACHECO','4',' 3113822821','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','9100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 21:21:36','9100','351','BOD. FARMANORTE 351','1','9100','9100','9100','0','9100','1','0','0','3','30/04/2024','',9100,0,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-04-29 21:21:36',  8329, 52291, 742, 372),('FVE','F351','021073','2024-04-29 21:44:38','042024','CO','1044623904','SEBASTIAN','DURAN','',' 3006983225','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 21:44:38','4600','351','BOD. FARMANORTE 351','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','30/04/2024','',0,4600,0,'4891228530136','SCHICK QUATTRO TITANIUM DESECHABLE X 1  ','180','EVEREADY DE COLOMBIA','2024-04-29 21:44:38',  3253.6458, 25501, 742, 372),('FVE','F351','021074','2024-04-29 21:52:13','042024','CO','1148142537','RAMON','BARRIO','Bloque 178 apartamento 302 ter',' 311 349247','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','31500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 21:52:13','31500','351','BOD. FARMANORTE 351','1','31500','31500','31500','0','31500','1','0','0','','30/04/2024','',0,31500,0,'7702132009748','ADVIL CHILDREN *100 ML ','616','HALEON (GLAXO OTC)','2024-04-29 21:52:13',  28044, 46798, 742, 372),('FVE','F351','021075','2024-04-29 21:52:55','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 21:52:55','4600','351','BOD. FARMANORTE 351','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','30/04/2024','',4600,0,0,'7702090038071','JUGO HIT MANGO *1 LT','192','POSTOBON GASEOSAS','2024-04-29 21:52:55',  2850.42, 53815, 742, 372);
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','F351','021076','2024-04-29 21:59:59','042024','CO','22589413','ROXANA','DIAZ','cra 4 .49 e -111 ',' 1  3215304357','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','6','13950','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 21:59:59','13950','351','BOD. FARMANORTE 351','5','1090','5450','5450','0','5450','0','5','0','','30/04/2024','',13950,0,0,'7706569001450','NAPROXENO 500 MG *10 TAB','614','A.G. MEDICAMENTOS','2024-04-29 21:59:59',  8563, 31632, 742, 372),('FVE','F351','021077','2024-04-29 22:01:32','042024','CO','1193040898','JUAN','OSORIO','',' 3103102020','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','9300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:01:32','9300','351','BOD. FARMANORTE 351','3','3100','9300','9300','0','9300','0','3','0','','30/04/2024','',9300,0,0,'7703445030153','FLUIMUCIL 600 MG *30 S/S ','397','ZAMBON COLOMBIA ','2024-04-29 22:01:32',  77290, 44302, 742, 372),('FVE','F351','021078','2024-04-29 22:04:58','042024','CO','1129512414','OSCAR','ARIAS','N',' 3013348030','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:04:58','2700','351','BOD. FARMANORTE 351','1','2700','2700','2700','0','2700','0','1','0','','30/04/2024','',0,2700,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-04-29 22:04:58',  33370, 62346, 742, 372),('FVE','F351','021079','2024-04-29 22:17:52','042024','CO','1007968250','DAVID','MENDOZA','0',' 3167134322','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:17:52','2900','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','1','0','0','','30/04/2024','',2900,0,0,'7702560000362','ALGODON JGB *25 GR','219','JGB','2024-04-29 22:17:52',  1750.1, 27772, 742, 372),('FVE','F351','021080','2024-04-29 22:20:27','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1260.5042016806724','239.4957983193276','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:20:27','1500','351','BOD. FARMANORTE 351','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','30/04/2024','',1500,0,0,'77082381','COCA COLA ZERO *250 ML','144','COCA COLA','2024-04-29 22:20:27',  1031.1666, 34412, 742, 372),('FVE','F351','021081','2024-04-29 22:29:08','042024','CO','1045726279','RUBEN','RUIZ','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','13445.378151260506','2554.6218487394945','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:29:08','16000','351','BOD. FARMANORTE 351','5','3200','16000','13445.378151261','2554.6218487395','16000','5','0','0','','30/04/2024','',16000,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-29 22:29:08',  1806, 56307, 742, 372),('FVE','F351','021082','2024-04-29 22:34:52','042024','CO','72190248','HILMER','PALMA','CALLE 45 DN 1K -21',' 3005192887 3205487963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','7260','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:34:52','7260','351','BOD. FARMANORTE 351','1','7260','7260','7260','0','7260','0','1','0','','30/04/2024','',7260,0,0,'7707019332124','CINDIMIZOL 200 MG *5 CAP','130','LABQUIFAR PHARMACEUTICA','2024-04-29 22:34:52',  6470, 27599, 742, 372),('FVE','F351','021083','2024-04-29 22:48:05','042024','CO','1001821373','VALENTIN','GUERRERO','',' 3012458963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','10057.310924369747','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:48:06','10680','351','BOD. FARMANORTE 351','2','1090','2180','2180','0','2180','0','2','0','','30/04/2024','',10680,0,0,'7706569001450','NAPROXENO 500 MG *10 TAB','614','A.G. MEDICAMENTOS','2024-04-29 22:48:05',  8563, 31632, 742, 372),('FVE','F351','021083','2024-04-29 22:48:05','042024','CO','1001821373','VALENTIN','GUERRERO','',' 3012458963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','10057.310924369747','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:48:06','10680','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','0','1','0','','30/04/2024','',10680,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-04-29 22:48:05',  27780, 54056, 742, 372),('FVE','F351','021083','2024-04-29 22:48:05','042024','CO','1001821373','VALENTIN','GUERRERO','',' 3012458963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','10057.310924369747','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:48:06','10680','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','30/04/2024','',10680,0,0,'7702192224051','GATORADE MARACUYA *500 ML','192','POSTOBON GASEOSAS','2024-04-29 22:48:05',  2451, 35306, 742, 372),('FVE','F351','021084','2024-04-29 22:54:15','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2184.8739495798322','415.12605042016776','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:54:15','2600','351','BOD. FARMANORTE 351','1','2600','2600','2184.8739495798','415.12605042017','2600','1','0','0','','30/04/2024','',2600,0,0,'7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-04-29 22:54:15',  1649.56, 52184, 742, 372),('FVE','F351','021085','2024-04-29 22:54:26','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','12184.873949579833','2315.1260504201673','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:54:26','14500','351','BOD. FARMANORTE 351','2','2900','5800','4873.9495798319','926.05042016807','5800','2','0','0','','30/04/2024','',14500,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-04-29 22:54:26',  1768.4, 60339, 742, 372),('FVE','F351','021085','2024-04-29 22:54:26','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','12184.873949579833','2315.1260504201673','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 22:54:26','14500','351','BOD. FARMANORTE 351','3','2900','8700','7310.9243697479','1389.0756302521','8700','3','0','0','','30/04/2024','',14500,0,0,'7702402056304','GALLETA CON HELADO VAINILLA PASAS *65 GR','296','MEALS DE COLOMBIA','2024-04-29 22:54:26',  1768.403, 60390, 742, 372),('FVE','F351','021086','2024-04-29 23:01:21','042024','CO','1102822984','EDWIN','MARQUEZ','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','22500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 23:01:21','22500','351','BOD. FARMANORTE 351','1','22500','22500','22500','0','22500','1','0','0','','30/04/2024','',22500,0,0,'7709990988116','BRONCOHELIX JARABE * 120 ML','642','GFC','2024-04-29 23:01:21',  4250, 37258, 742, 372),('FVE','F351','021087','2024-04-29 23:54:29','042024','CO','1002032483','STEBAN','TRUJILLO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','3950','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-29 23:54:29','3950','351','BOD. FARMANORTE 351','2','1975','3950','3950','0','3950','0','2','0','','30/04/2024','',3950,0,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-04-29 23:54:29',  14234, 54385, 742, 372),('FVE','F351','021088','2024-04-30 00:06:02','042024','CO','1007117821','ELIAN','MANRIQUE','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:06:02','3100','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/04/2024','',0,3100,0,'7702090029864','HIT MANGO *500 ML','192','POSTOBON GASEOSAS','2024-04-30 00:06:02',  1750.42, 35518, 742, 372),('FVE','F351','021089','2024-04-30 00:07:00','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','4525.042016806723','494.9579831932774','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:07:00','5020','351','BOD. FARMANORTE 351','1','1920','1920','1920','0','1920','0','1','0','','30/04/2024','',5020,0,0,'7702132008611','ADVIL MAX *10 CAP','616','HALEON (GLAXO OTC)','2024-04-30 00:07:00',  17038, 38992, 742, 372),('FVE','F351','021089','2024-04-30 00:07:00','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','4525.042016806723','494.9579831932774','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:07:00','5020','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/04/2024','',5020,0,0,'7702090029864','HIT MANGO *500 ML','192','POSTOBON GASEOSAS','2024-04-30 00:07:00',  1750.42, 35518, 742, 372),('FVE','F351','021090','2024-04-30 00:16:53','042024','CO','1129520998','MIRLEYDIS','HENAO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','10','3000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:16:53','3000','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','30/04/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-04-30 00:16:53',  28997, 54625, 742, 372),('FVE','F351','021091','2024-04-30 00:27:51','042024','CO','1042449450','KATERIN','GONZALES','',' 3245788689','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','562175','8745513','VERGARA AVENDANO WISTON HENRY','','','3','49500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:27:51','49500','351','BOD. FARMANORTE 351','2','9000','18000','18000','0','18000','2','0','0','','30/04/2024','',0,49500,0,'7707019381627','SEAMIB 1 GR * 2 TAB','130','LABQUIFAR PHARMACEUTICA','2024-04-30 00:27:51',  2860, 52429, 742, 372),('FVE','F351','021091','2024-04-30 00:27:51','042024','CO','1042449450','KATERIN','GONZALES','',' 3245788689','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','562175','8745513','VERGARA AVENDANO WISTON HENRY','','','3','49500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:27:51','49500','351','BOD. FARMANORTE 351','1','31500','31500','31500','0','31500','1','0','0','','30/04/2024','',0,49500,0,'7707263007755','CLINDABACT 100/100MG  X 3 OVULOS /D20/','387','TRIDEX FARMACEUTICA','2024-04-30 00:27:51',  22800, 59529, 742, 372),('FVE','F351','021092','2024-04-30 00:34:28','042024','CO','22643760','YESENIA PATRICIA','DE LA CRUZ RODRIGUEZ','11','0  3017162543','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','6','10588.235294117647','2011.7647058823532','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:34:29','12600','351','BOD. FARMANORTE 351','6','2100','12600','10588.235294118','2011.7647058824','12600','6','0','0','','30/04/2024','',12600,0,0,'7702402051361','HELADO CASERO RON CON PASAS *60 GR','296','MEALS DE COLOMBIA','2024-04-30 00:34:28',  1206, 52362, 742, 372),('FVE','F351','021093','2024-04-30 00:38:10','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1350','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:38:11','1350','351','BOD. FARMANORTE 351','1','1350','1350','1350','0','1350','0','1','0','','30/04/2024','',1350,0,0,'7702605102808','SILIMARINA 150 MG * 20 TAB','193','GENFAR','2024-04-30 00:38:10',  18459, 26212, 742, 372),('FVE','F351','021094','2024-04-30 00:56:36','042024','CO','8797619','ANGEL','VELASQUEZ','',' 3007279346 3102562558','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','6040','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:56:36','6040','351','BOD. FARMANORTE 351','1','6040','6040','6040','0','6040','0','1','0','','30/04/2024','',0,6040,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-04-30 00:56:36',  53223.5, 41855, 742, 372),('FVE','F351','021095','2024-04-30 00:57:42','042024','CO','1129579648','ALBERTO','SANTODOMINGO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','17200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:57:43','17200','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','30/04/2024','',17200,0,0,'7501033961557','PEDIALYTE MAX ZINC 60 FRESA *500 ML','659','ABBOTT NUTRICION','2024-04-30 00:57:42',  8380, 55721, 742, 372),('FVE','F351','021095','2024-04-30 00:57:42','042024','CO','1129579648','ALBERTO','SANTODOMINGO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','17200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 00:57:43','17200','351','BOD. FARMANORTE 351','1','7600','7600','7600','0','7600','0','1','0','','30/04/2024','',17200,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-04-30 00:57:42',  63045, 31775, 742, 372),('FVE','F351','021096','2024-04-30 01:16:37','042024','CO','8707651','JAVIER','RODRIGUEZ','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','13000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 01:16:37','13000','351','BOD. FARMANORTE 351','1','13000','13000','13000','0','13000','1','0','0','','30/04/2024','',13000,0,0,'7702057061265','OXIMETAZOLINA 0.05% NASAL *15 ML ADULTOS MK','654','MK ETICOS CONVENIO','2024-04-30 01:16:37',  10456.32, 43203, 742, 372),('FVE','F351','021097','2024-04-30 01:18:05','042024','CO','1129576369','DWIGHT','GRANADOS','bloque 66 apto 302 la ciudadel',' 3174086368 3225199797','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','28900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 01:18:06','28900','351','BOD. FARMANORTE 351','1','28900','28900','28900','0','28900','1','0','0','7','30/04/2024','',18900,10000,0,'7702024025733','KLIM 1+ BOLSA *500 GR','311','NESTLE NUTRICION','2024-04-30 01:18:05',  26210, 38369, 742, 372),('FVE','F351','021098','2024-04-30 01:21:02','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 01:21:02','1600','351','BOD. FARMANORTE 351','1','1600','1600','1600','0','1600','0','1','0','','30/04/2024','',1600,0,0,'7703712085046','BINAFAR 200MG/500MG CJA * 24 TB /D24/','387','TRIDEX FARMACEUTICA','2024-04-30 01:21:02',  24900, 54476, 742, 372),('FVE','F351','021099','2024-04-30 05:27:11','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 05:27:11','3100','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/04/2024','',3100,0,0,'7702090029888','HIT TROPICAL *500 ML','192','POSTOBON GASEOSAS','2024-04-30 05:27:11',  1750.7, 35524, 742, 372),('FVE','F351','021100','2024-04-30 06:18:38','042024','CO','1001997663','ALEX','PEREZ','',' 3046315076','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','27900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 06:18:38','27900','351','BOD. FARMANORTE 351','10','1200','12000','12000','0','12000','0','10','0','','30/04/2024','',27900,0,0,'7707019402117','COLESPAS 10 MG CJA *30 TAB','130','LABQUIFAR PHARMACEUTICA','2024-04-30 06:18:38',  11800, 53948, 742, 372),('FVE','F351','021100','2024-04-30 06:18:38','042024','CO','1001997663','ALEX','PEREZ','',' 3046315076','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','27900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 06:18:38','27900','351','BOD. FARMANORTE 351','1','15900','15900','15900','0','15900','0','1','0','','30/04/2024','',27900,0,0,'7702771001561','ENTEROGERMINA PLUS *5 AMP','772','OPELLA (SANOFI OTC)','2024-04-30 06:18:38',  74092.5, 48571, 742, 372),('FVE','F351','021101','2024-04-30 06:55:14','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 06:55:14','2900','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','0','1','0','','30/04/2024','',2900,0,0,'7707232099095','ACTIVOX ICE JENGIBRE MASTICABLES * 12 S/S','271','NATURAL FRESHLY','2024-04-30 06:55:14',  17937, 33638, 742, 372),('FVE','F351','021102','2024-04-30 07:18:09','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 07:18:09','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-30 07:18:09',  800, 48019, 742, 372),('FVE','F351','021103','2024-04-30 07:46:45','042024','CO','32616526','ASTRIS','JULIAO ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','4453.781512605042','846.2184873949582','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 07:46:45','5300','351','BOD. FARMANORTE 351','1','5300','5300','4453.781512605','846.21848739496','5300','1','0','0','','30/04/2024','',5300,0,0,'7702027478741','TENA SLIP ULTRA L *1 UND','337','FAMILIA SANCELA','2024-04-30 07:46:45',  4282, 33335, 742, 372),('FVE','F351','021104','2024-04-30 07:54:57','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 07:54:57','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2024','',1900,0,0,'7702090069495','ACQUA POSTOBON MANZANA S/CALORIAS *400 ML','192','POSTOBON GASEOSAS','2024-04-30 07:54:57',  840.4, 60819, 742, 372),('FVE','F351','021105','2024-04-30 09:31:55','042024','CO','1045707904','WILLIAN','FARID','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','19800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 09:31:55','19800','351','BOD. FARMANORTE 351','1','19800','19800','19800','0','19800','1','0','0','','30/04/2024','',19800,0,0,'7707019314120','CEFAFLEX 250 MG SUSP *100 ML','130','LABQUIFAR PHARMACEUTICA','2024-04-30 09:31:55',  9400, 23558, 742, 372),('FVE','F351','021106','2024-04-30 09:32:33','042024','CO','32697327','ANA MILENA','ESPINOZA','CRA 14 D 65-03 VILLA ESTADIO  ',' 3011655580','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','4','155272.26890756303','10577.731092436974','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 09:32:33','165850','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/04/2024','',165850,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 09:32:33',  100, 44347, 742, 372),('FVE','F351','021106','2024-04-30 09:32:33','042024','CO','32697327','ANA MILENA','ESPINOZA','CRA 14 D 65-03 VILLA ESTADIO  ',' 3011655580','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','4','155272.26890756303','10577.731092436974','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 09:32:33','165850','351','BOD. FARMANORTE 351','1','97400','97400','97400','0','97400','1','0','0','10','30/04/2024','',165850,0,0,'7702024061052','KLIM 1+ BOLSA *2000 GR','311','NESTLE NUTRICION','2024-04-30 09:32:33',  89984, 48112, 742, 372),('FVE','F351','021106','2024-04-30 09:32:33','042024','CO','32697327','ANA MILENA','ESPINOZA','CRA 14 D 65-03 VILLA ESTADIO  ',' 3011655580','3327','ALICIA REGINA','CARRASCAL POLO ','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','4','155272.26890756303','10577.731092436974','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 09:32:33','165850','351','BOD. FARMANORTE 351','1','66250','66250','55672.268907563','10577.731092437','66250','1','0','0','10','30/04/2024','',165850,0,0,'7701021147585','WINNY ULTRATRIM SEC ET4 *50 UND ','653','TECNOQUIMICAS WINNY','2024-04-30 09:32:33',  50094, 48906, 742, 372);
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','F351','021107','2024-04-30 09:55:26','042024','CR','1001944748','JOSE GABRIEL','GLENN DURAN ','CRA 26B NO.39-67',' 3008370045','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','890452','2','14320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 10:36:25','14400','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','30/04/2024','',0,0,14400,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-04-30 09:55:26',  255, 46100, 742, 372),('FVE','F351','021107','2024-04-30 09:55:26','042024','CR','1001944748','JOSE GABRIEL','GLENN DURAN ','CRA 26B NO.39-67',' 3008370045','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','890452','2','14320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 10:36:25','14400','351','BOD. FARMANORTE 351','1','13900','13900','13900','0','13900','1','0','0','','30/04/2024','',0,0,14400,'7703712080065','BENMACIT 4% SUSP *10 ML   /D24/','387','TRIDEX FARMACEUTICA','2024-04-30 09:55:26',  8280, 53778, 742, 372),('FVE','F351','021108','2024-04-30 11:59:39','042024','CO','72217065','ANDRES ','DE LA SALAS','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','6600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 11:59:39','6600','351','BOD. FARMANORTE 351','2','2300','4600','4600','0','4600','0','2','0','','30/04/2024','',6600,0,0,'7702057092757','IBUFLASH MIGRAN *30 CAP','382','TECNOQUIMICAS','2024-04-30 11:59:39',  50677.65, 58898, 742, 372),('FVE','F351','021108','2024-04-30 11:59:39','042024','CO','72217065','ANDRES ','DE LA SALAS','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','6600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 11:59:39','6600','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',6600,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-30 11:59:39',  800, 48019, 742, 372),('FVE','F351','021109','2024-04-30 12:06:02','042024','CO','72289495','LUIS EDUARDO','MURILLO RAMIREZ','CRA 6 C SUR NO.47D-29 BQUILLA',' 3112382701','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','5210.084033613445','989.9159663865547','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 12:06:02','6200','351','BOD. FARMANORTE 351','1','800','800','672.26890756303','127.73109243697','800','1','0','1','','30/04/2024','',6200,0,0,'7622201390167','GALLETA RITZ SALADITAS *20 GR','754','DISCOB NORTE SAS','2024-04-30 12:06:02',  462.2, 62414, 742, 372),('FVE','F351','021109','2024-04-30 12:06:02','042024','CO','72289495','LUIS EDUARDO','MURILLO RAMIREZ','CRA 6 C SUR NO.47D-29 BQUILLA',' 3112382701','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','5210.084033613445','989.9159663865547','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 12:06:02','6200','351','BOD. FARMANORTE 351','1','5400','5400','4537.8151260504','862.18487394958','5400','1','0','1','','30/04/2024','',6200,0,0,'7702090051810','NATU MALTA BOTELLA *1.5 LT','192','POSTOBON GASEOSAS','2024-04-30 12:06:02',  3781.5, 56325, 742, 372),('FVE','F351','021110','2024-04-30 12:10:09','042024','CO','1007118683','KEVIN','VILLA','.',' 0 3011128214','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','13000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 12:10:09','13000','351','BOD. FARMANORTE 351','1','13000','13000','13000','0','13000','1','0','0','','30/04/2024','',13000,0,0,'7702057061265','OXIMETAZOLINA 0.05% NASAL *15 ML ADULTOS MK','654','MK ETICOS CONVENIO','2024-04-30 12:10:09',  10456.32, 43203, 742, 372),('FVE','F351','021111','2024-04-30 12:36:44','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','8500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 12:36:44','8500','351','BOD. FARMANORTE 351','1','8500','8500','8500','0','8500','1','0','0','','30/04/2024','',8500,0,0,'7702057073459','SILDENAFIL 50 MG * 2 TAB','654','MK ETICOS CONVENIO','2024-04-30 12:36:44',  5425.59, 43298, 742, 372),('FVE','F351','021112','2024-04-30 12:41:29','042024','CO','1143135566','KEVIN ','TOAMASSE','CALLE 78B 21A-28 LOS ROBLES',' 3004147317','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 12:41:29','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','1','','30/04/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-30 12:41:29',  800, 48019, 742, 372),('FVE','F351','021113','2024-04-30 13:31:34','042024','CO','8691826','JORGE ELIESER','BAENA MIRANDA','cra 1 c 3   46e -24',' 3002439760','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','22','28549.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 13:31:34','29300','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/04/2024','',29300,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 13:31:34',  100, 44347, 742, 372),('FVE','F351','021113','2024-04-30 13:31:34','042024','CO','8691826','JORGE ELIESER','BAENA MIRANDA','cra 1 c 3   46e -24',' 3002439760','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','22','28549.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 13:31:34','29300','351','BOD. FARMANORTE 351','1','21400','21400','21400','0','21400','1','0','0','','30/04/2024','',29300,0,0,'7702132009731','ADVIL CHILDREN *60 ML ','616','HALEON (GLAXO OTC)','2024-04-30 13:31:34',  19286, 46638, 742, 372),('FVE','F351','021113','2024-04-30 13:31:34','042024','CO','8691826','JORGE ELIESER','BAENA MIRANDA','cra 1 c 3   46e -24',' 3002439760','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','22','28549.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 13:31:34','29300','351','BOD. FARMANORTE 351','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','30/04/2024','',29300,0,0,'7702184835982','VITAMINA C + ZINC TUTI FRUTI * 100 TAB','249','ECAR','2024-04-30 13:31:34',  15435, 58540, 742, 372),('FVE','F351','021113','2024-04-30 13:31:34','042024','CO','8691826','JORGE ELIESER','BAENA MIRANDA','cra 1 c 3   46e -24',' 3002439760','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','22','28549.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 13:31:34','29300','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','30/04/2024','',29300,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-04-30 13:31:34',  28997, 54625, 742, 372),('FVE','F351','021114','2024-04-30 13:39:28','042024','CO','72004374','JORGE','ARRIETA','',' 3052400456','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','4','8151.26050420168','1548.7394957983192','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 13:39:28','9700','351','BOD. FARMANORTE 351','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/04/2024','',9700,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2024-04-30 13:39:28',  1782, 54650, 742, 372),('FVE','F351','021114','2024-04-30 13:39:28','042024','CO','72004374','JORGE','ARRIETA','',' 3052400456','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','4','8151.26050420168','1548.7394957983192','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 13:39:28','9700','351','BOD. FARMANORTE 351','2','1800','3600','3025.2100840336','574.78991596639','3600','2','0','0','','30/04/2024','',9700,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2024-04-30 13:39:28',  1190.721, 58852, 742, 372),('FVE','F351','021114','2024-04-30 13:39:28','042024','CO','72004374','JORGE','ARRIETA','',' 3052400456','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','4','8151.26050420168','1548.7394957983192','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 13:39:28','9700','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',9700,0,0,'7702535018651','FUZETEA MANZANILLA Y MANGO *400 ML','144','COCA COLA','2024-04-30 13:39:28',  1806, 57011, 742, 372),('FVE','F351','021115','2024-04-30 14:05:04','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','2','5126.050420168067','973.9495798319326','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 14:05:04','6100','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',6100,0,0,'7702402057554','CHOCOCONO BAKANO *110 GR','296','MEALS DE COLOMBIA','2024-04-30 14:05:04',  1875, 61619, 742, 372),('FVE','F351','021115','2024-04-30 14:05:04','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','2','5126.050420168067','973.9495798319326','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 14:05:04','6100','351','BOD. FARMANORTE 351','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/04/2024','',6100,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-04-30 14:05:04',  1768.4, 60339, 742, 372),('FVE','F351','021116','2024-04-30 14:10:06','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','2689.075630252101','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 14:10:06','3200','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',3200,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-30 14:10:06',  1806, 56307, 742, 372),('FVE','F351','021117','2024-04-30 15:28:33','042024','CO','1058324271','LUZ NELA','SALGADO','CRA 45 H  4 -76 SEGUNDO PISO','  3012831562','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','2','38722.68907563025','6977.310924369747','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 15:28:33','45700','351','BOD. FARMANORTE 351','1','43700','43700','36722.68907563','6977.3109243697','43700','1','0','0','10','30/04/2024','',0,45700,0,'7701021114174','WINNY ULTRATRIM SEC ET5 *30 UND  ','653','TECNOQUIMICAS WINNY','2024-04-30 15:28:33',  32994.9, 43226, 742, 372),('FVE','F351','021117','2024-04-30 15:28:33','042024','CO','1058324271','LUZ NELA','SALGADO','CRA 45 H  4 -76 SEGUNDO PISO','  3012831562','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','2','38722.68907563025','6977.310924369747','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 15:28:33','45700','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',0,45700,0,'DO','DOMICILIO','00','VARIOS','2024-04-30 15:28:33',  1500, 44348, 742, 372),('FVE','F351','021118','2024-04-30 15:51:16','042024','CO','72174474','JHON ','QUINTANA ','',' 3114183818','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','60100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 15:51:16','60100','351','BOD. FARMANORTE 351','1','60100','60100','60100','0','60100','1','0','0','','30/04/2024','',60100,0,0,'7896261001572','PROCTO-GLYVENOL CREMA *30 GR','616','HALEON (GLAXO OTC)','2024-04-30 15:51:16',  48520, 38791, 742, 372),('FVE','F351','021119','2024-04-30 16:18:29','042024','CO','8789308','ADALBERTO','HERNANDEZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','21','16200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 16:18:29','16200','351','BOD. FARMANORTE 351','10','750','7500','7500','0','7500','0','10','0','','30/04/2024','',16200,0,0,'7706569000439','DICLOXACILINA 500MG *50 CAP','614','A.G. MEDICAMENTOS','2024-04-30 16:18:29',  26823, 31350, 742, 372),('FVE','F351','021119','2024-04-30 16:18:29','042024','CO','8789308','ADALBERTO','HERNANDEZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','21','16200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 16:18:29','16200','351','BOD. FARMANORTE 351','10','450','4500','4500','0','4500','0','10','0','','30/04/2024','',16200,0,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-04-30 16:18:29',  13144, 31502, 742, 372),('FVE','F351','021119','2024-04-30 16:18:29','042024','CO','8789308','ADALBERTO','HERNANDEZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','21','16200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 16:18:29','16200','351','BOD. FARMANORTE 351','1','4200','4200','4200','0','4200','1','0','0','','30/04/2024','',16200,0,0,'7705366903028','CLORURO DE SODIO S.S. 9% *500 ML ','156','CORPAUL','2024-04-30 16:18:29',  3653.8, 58440, 742, 372),('FVE','F351','021120','2024-04-30 16:35:27','042024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','4119','KEVIN ','TOAMASSE','','TERCERO','VARIOS','','','','','','1','19200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 16:35:27','19200','351','BOD. FARMANORTE 351','1','19200','19200','19200','0','19200','1','0','0','','30/04/2024','',19200,0,0,'7703689000448','CYCLOFEM 0.5 ML AMP + JERINGA  ','344','PROFAMILIA','2024-04-30 16:35:27',  16550, 40547, 742, 372),('FVE','F351','021121','2024-04-30 17:13:57','042024','CO','72198786','SAMUEL ','RODRIGUEZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','54113.445378151264','8286.554621848736','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 17:13:57','62400','351','BOD. FARMANORTE 351','1','10500','10500','10500','0','10500','1','0','0','','30/04/2024','',62400,0,0,'7706569001269','CLOTRIMAZOL CREMA TOPICA *40 GR','614','A.G. MEDICAMENTOS','2024-04-30 17:13:57',  7803, 31314, 742, 372),('FVE','F351','021121','2024-04-30 17:13:57','042024','CO','72198786','SAMUEL ','RODRIGUEZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','54113.445378151264','8286.554621848736','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 17:13:57','62400','351','BOD. FARMANORTE 351','1','51900','51900','43613.445378151','8286.5546218487','51900','1','0','0','','30/04/2024','',62400,0,0,'302993923046','CETAPHIL BARRA *127 GR','190','GALDERMA DE COLOMBIA','2024-04-30 17:13:57',  34700, 25673, 742, 372),('FVE','F351','021122','2024-04-30 17:29:52','042024','CO','1129583066','ARLEY','BARRIO','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','14200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 17:29:52','14200','351','BOD. FARMANORTE 351','1','14200','14200','14200','0','14200','1','0','0','','30/04/2024','',14200,0,0,'7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA *60 ML','616','HALEON (GLAXO OTC)','2024-04-30 17:29:52',  12808.3, 54127, 742, 372),('FVE','F351','021123','2024-04-30 17:33:20','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','2268.90756302521','431.09243697478985','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 17:33:21','2700','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2024','',2700,0,0,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-04-30 17:33:20',  1142.8, 60397, 742, 372),('FVE','F351','021123','2024-04-30 17:33:20','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','2268.90756302521','431.09243697478985','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 17:33:21','2700','351','BOD. FARMANORTE 351','1','800','800','672.26890756303','127.73109243697','800','1','0','0','','30/04/2024','',2700,0,0,'7622201390167','GALLETA RITZ SALADITAS *20 GR','754','DISCOB NORTE SAS','2024-04-30 17:33:20',  462.2, 62414, 742, 372),('FVE','F351','021124','2024-04-30 17:46:54','042024','CO','8711085','FREDDY','TORRES','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','7900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 17:46:54','7900','351','BOD. FARMANORTE 351','2','2500','5000','5000','0','5000','0','2','0','','30/04/2024','',7900,0,0,'7709080992511','LYPTUS MIEL NARANJA CJA * 24 SOBRES','1000','NATURALMENTE','2024-04-30 17:46:54',  17000, 63441, 742, 372),('FVE','F351','021124','2024-04-30 17:46:54','042024','CO','8711085','FREDDY','TORRES','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','7900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 17:46:54','7900','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','0','1','0','','30/04/2024','',7900,0,0,'7702057803278','GASTROFAST ADVANCE *10 SACHETS','877','TECNOQUIMICAS VM TQ','2024-04-30 17:46:54',  22029.28, 58051, 742, 372),('FVE','F351','021125','2024-04-30 18:05:54','042024','CO','7743227','PEDRO','JOSE','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','22436.97478991597','4263.0252100840335','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 18:05:54','26700.000000000004','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',26700,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-30 18:05:54',  1806, 56307, 742, 372),('FVE','F351','021125','2024-04-30 18:05:54','042024','CO','7743227','PEDRO','JOSE','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','22436.97478991597','4263.0252100840335','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 18:05:54','26700.000000000004','351','BOD. FARMANORTE 351','2','2900','5800','4873.9495798319','926.05042016807','5800','2','0','0','','30/04/2024','',26700,0,0,'7702402054508','VASO HELADINO KIDS LLUVIA DE COLORES *54 GR','296','MEALS DE COLOMBIA','2024-04-30 18:05:54',  2016.8333, 58851, 742, 372),('FVE','F351','021125','2024-04-30 18:05:54','042024','CO','7743227','PEDRO','JOSE','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','22436.97478991597','4263.0252100840335','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 18:05:54','26700.000000000004','351','BOD. FARMANORTE 351','2','3900','7800','6554.6218487395','1245.3781512605','7800','2','0','0','','30/04/2024','',26700,0,0,'7702189053824','DORITOS MEGA QUESO *68 GR','762','FRITO LAY','2024-04-30 18:05:54',  2521, 54759, 742, 372),('FVE','F351','021125','2024-04-30 18:05:54','042024','CO','7743227','PEDRO','JOSE','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','22436.97478991597','4263.0252100840335','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 18:05:54','26700.000000000004','351','BOD. FARMANORTE 351','2','1800','3600','3025.2100840336','574.78991596639','3600','2','0','0','','30/04/2024','',26700,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2024-04-30 18:05:54',  1190.721, 58852, 742, 372),('FVE','F351','021125','2024-04-30 18:05:54','042024','CO','7743227','PEDRO','JOSE','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','22436.97478991597','4263.0252100840335','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 18:05:54','26700.000000000004','351','BOD. FARMANORTE 351','3','2100','6300','5294.1176470588','1005.8823529412','6300','3','0','0','','30/04/2024','',26700,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2024-04-30 18:05:54',  1358, 50688, 742, 372),('FVE','F351','021126','2024-04-30 18:07:21','042024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 18:07:21','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-30 18:07:21',  800, 48019, 742, 372),('FVE','F351','021127','2024-04-30 18:12:00','042024','CO','1140903414','DANIELA ','QUINTERO ','CALLE 47 C # 1 A 4 - 45',' 3145671523','4119','KEVIN ','TOAMASSE','3632','JOSE GABRIEL','GLENN DURAN ','','','','','','3','18441.176470588234','558.8235294117644','351','FARMANORTE 351','ADMINISTRADOR','2024-04-30 18:12:02','19000','351','BOD. FARMANORTE 351','1','13500','13500','13500','0','13500','1','0','0','21','30/04/2024','',0,19000,0,'7702870003596','SINOVUL *21 TAB','696','ABBOTT FARMA CONVENIO','2024-04-30 18:12:00',  11255, 31773, 742, 372);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '042024' AND DECODBOD='351';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '042024' AND DECODBOD='351';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '042024' AND DECODBOD='351';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '042024' AND DECODBOD='351';
