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','023428','2024-05-29 06:45:20','052024','CR','32612444','EIMY JHOANA','RIVERA GUZMAN','',' 3128862660','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','919459','3','6134.453781512605','1165.5462184873948','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 06:59:13','7300','351','BOD. FARMANORTE 351','1','1200','1200','1008.4033613445','191.59663865546','1200','1','0','0','','29/05/2024','',0,0,7300,'7702025114023','GALLETAS DUCALES TENTACION','816','GRUPO NUTRESA','2024-05-29 06:45:20',  658.75, 35236, 742, 372),('FVE','F351','023428','2024-05-29 06:45:20','052024','CR','32612444','EIMY JHOANA','RIVERA GUZMAN','',' 3128862660','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','919459','3','6134.453781512605','1165.5462184873948','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 06:59:13','7300','351','BOD. FARMANORTE 351','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','29/05/2024','',0,0,7300,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2024-05-29 06:45:20',  1782, 54650, 742, 372),('FVE','F351','023429','2024-05-29 07:28:27','052024','CO','1001996528','YERLIN ','BLANCO','cra 3 e   49 e 41 carrizal CER',' 3246818573','3877','EIMY JHOANA','RIVERA GUZMAN','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','2','90900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 07:28:27','90900','351','BOD. FARMANORTE 351','1','88900','88900','88900','0','88900','1','0','1','','29/05/2024','',0,90900,0,'7501058630797','NESTOGENO 2 *1100 GR','311','NESTLE NUTRICION','2024-05-29 07:28:27',  81923, 52400, 742, 372),('FVE','F351','023429','2024-05-29 07:28:27','052024','CO','1001996528','YERLIN ','BLANCO','cra 3 e   49 e 41 carrizal CER',' 3246818573','3877','EIMY JHOANA','RIVERA GUZMAN','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','2','90900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 07:28:27','90900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','1','','29/05/2024','',0,90900,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 07:28:27',  1500, 44348, 742, 372),('FVE','F351','023430','2024-05-29 07:29:42','052024','CO','1234889977','ESNEIDER','MORENO','',' 3008381103','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','57700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 07:29:42','57700','351','BOD. FARMANORTE 351','1','57700','57700','57700','0','57700','1','0','0','10','29/05/2024','',57700,0,0,'7501058631145','BABY KLIM 2+ LATA *800 GR','311','NESTLE NUTRICION','2024-05-29 07:29:42',  53365, 51946, 742, 372),('FVE','F351','023431','2024-05-29 08:33:39','052024','CO','7451079001529','MIGUEL','DOL','',' 0 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','5','8100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 08:33:39','8100','351','BOD. FARMANORTE 351','1','1700','1700','1700','0','1700','0','1','0','','29/05/2024','',0,8100,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-05-29 08:33:39',  50000, 31759, 742, 372),('FVE','F351','023431','2024-05-29 08:33:39','052024','CO','7451079001529','MIGUEL','DOL','',' 0 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','5','8100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 08:33:39','8100','351','BOD. FARMANORTE 351','2','1900','3800','3800','0','3800','0','2','0','','29/05/2024','',0,8100,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-29 08:33:39',  131275.53, 43180, 742, 372),('FVE','F351','023431','2024-05-29 08:33:39','052024','CO','7451079001529','MIGUEL','DOL','',' 0 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','5','8100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 08:33:39','8100','351','BOD. FARMANORTE 351','2','1300','2600','2600','0','2600','0','2','0','','29/05/2024','',0,8100,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-29 08:33:39',  114652, 26533, 742, 372),('FVE','F351','023432','2024-05-29 08:59:15','052024','CO','72230951','HECTR','VEREDECTI','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','3800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 08:59:15','3800','351','BOD. FARMANORTE 351','1','3800','3800','3800','0','3800','1','0','0','','29/05/2024','',3800,0,0,'7702560026577','ALCOHOL JGB *120 ML','219','JGB','2024-05-29 08:59:15',  2529, 27762, 742, 372),('FVE','F351','023433','2024-05-29 09:11:08','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','3277.310924369748','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:11:08','3900','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','29/05/2024','',3900,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','POSTOBON GASEOSAS','2024-05-29 09:11:08',  2451, 25826, 742, 372),('FVE','F351','023434','2024-05-29 09:17:28','052024','CO','32748474','DARLYS','RODRIGUEZ','CLL 47 #1B1-11 CASA  AL FRENTE',' 3003351776','3327','ALICIA REGINA','CARRASCAL POLO ','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','4','30800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:17:28','30800','351','BOD. FARMANORTE 351','2','9600','19200','19200','0','19200','2','0','0','','29/05/2024','',30800,0,0,'7501033961557','PEDIALYTE MAX ZINC 60 FRESA *500 ML','659','ABBOTT NUTRICION','2024-05-29 09:17:28',  8380, 55721, 742, 372),('FVE','F351','023434','2024-05-29 09:17:28','052024','CO','32748474','DARLYS','RODRIGUEZ','CLL 47 #1B1-11 CASA  AL FRENTE',' 3003351776','3327','ALICIA REGINA','CARRASCAL POLO ','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','4','30800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:17:28','30800','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','29/05/2024','',30800,0,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-05-29 09:17:28',  8380, 22278, 742, 372),('FVE','F351','023434','2024-05-29 09:17:28','052024','CO','32748474','DARLYS','RODRIGUEZ','CLL 47 #1B1-11 CASA  AL FRENTE',' 3003351776','3327','ALICIA REGINA','CARRASCAL POLO ','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','4','30800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:17:28','30800','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',30800,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 09:17:28',  1500, 44348, 742, 372),('FVE','F351','023435','2024-05-29 09:38:22','052024','CO','1001996528','YERLIN ','BLANCO','cra 3 e   49 e 41 carrizal CER',' 3246818573','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','6','9000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:38:22','9000','351','BOD. FARMANORTE 351','6','1500','9000','9000','0','9000','0','6','0','','29/05/2024','',9000,0,0,'7707263000213','AMPLIEX 500 MG * 100 CAPS /D20/','387','TRIDEX FARMACEUTICA','2024-05-29 09:38:22',  97200, 43524, 742, 372),('FVE','F351','023436','2024-05-29 09:47:27','052024','CO','32828632','LUDIBET','CASTELLARES','CALLE 50 C 1 F 15',' 3013833239','3327','ALICIA REGINA','CARRASCAL POLO ','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','2','21200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:47:27','21200','351','BOD. FARMANORTE 351','1','19200','19200','19200','0','19200','1','0','0','28','29/05/2024','',21200,0,0,'7703689000448','CYCLOFEM 0.5 ML AMP + JERINGA  ','344','PROFAMILIA','2024-05-29 09:47:27',  16550, 40547, 742, 372),('FVE','F351','023436','2024-05-29 09:47:27','052024','CO','32828632','LUDIBET','CASTELLARES','CALLE 50 C 1 F 15',' 3013833239','3327','ALICIA REGINA','CARRASCAL POLO ','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','2','21200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:47:27','21200','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',21200,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 09:47:27',  1500, 44348, 742, 372),('FVE','F351','023437','2024-05-29 09:49:13','052024','CO','72262107','ALEXANDER MAURICIO','PRECIADO GUZMAN','CRA 1 B - 47 D -21  ',' 3215690446','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','7','10900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:49:13','10900','351','BOD. FARMANORTE 351','1','4900','4900','4900','0','4900','1','0','55','','29/05/2024','',10900,0,0,'7707228362141','CINTA MICROPOROSA PIEL ALFASAFE 1 X 3 YD','429','ALFA SAFE','2024-05-29 09:49:13',  3036, 60552, 742, 372),('FVE','F351','023437','2024-05-29 09:49:13','052024','CO','72262107','ALEXANDER MAURICIO','PRECIADO GUZMAN','CRA 1 B - 47 D -21  ',' 3215690446','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','7','10900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 09:49:13','10900','351','BOD. FARMANORTE 351','6','1000','6000','6000','0','6000','6','0','55','','29/05/2024','',10900,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2024-05-29 09:49:13',  570, 58629, 742, 372),('FVE','F351','023438','2024-05-29 10:22:37','052024','CO','1140888455','SANDRA','DIAZ','Calle 46g 1c 49 ciudadela 20 d',' 3128166263','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','13600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 10:22:37','13600','351','BOD. FARMANORTE 351','1','11600','11600','11600','0','11600','1','0','0','','29/05/2024','',13600,0,0,'7702026147679','NOSOTRAS TAMPONES DIGITAL REGULAR *10 +15 MULTIESTILO','337','FAMILIA SANCELA','2024-05-29 10:22:37',  8621.5, 51308, 742, 372),('FVE','F351','023438','2024-05-29 10:22:37','052024','CO','1140888455','SANDRA','DIAZ','Calle 46g 1c 49 ciudadela 20 d',' 3128166263','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','13600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 10:22:37','13600','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',13600,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 10:22:37',  1500, 44348, 742, 372),('FVE','F351','023439','2024-05-29 11:39:56','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','5400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 11:39:56','5400','351','BOD. FARMANORTE 351','2','2700','5400','5400','0','5400','2','0','0','','29/05/2024','',5400,0,0,'7702090020847','GASEOSA BRETANA *300 ML','192','POSTOBON GASEOSAS','2024-05-29 11:39:56',  1657.5, 35287, 742, 372),('FVE','F351','023440','2024-05-29 11:42:35','052024','CO','72167223','RAMON','ALFARO','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','15800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 11:42:35','15800','351','BOD. FARMANORTE 351','1','15800','15800','15800','0','15800','1','0','0','','29/05/2024','',15800,0,0,'7707210530572','SIMPIOX GOTAS *5 ML  ','256','GERCO','2024-05-29 11:42:35',  8081, 29858, 742, 372),('FVE','F351','023441','2024-05-29 12:34:25','052024','CO','22396392','CANDELARIA','ARRIETA','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','2','5210.084033613445','989.9159663865548','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 12:34:26','6200','351','BOD. FARMANORTE 351','2','3100','6200','5210.0840336134','989.91596638655','6200','2','0','0','','29/05/2024','',6200,0,0,'7702402056304','GALLETA CON HELADO VAINILLA PASAS *65 GR','296','MEALS DE COLOMBIA','2024-05-29 12:34:25',  1768.403, 60390, 742, 372),('FVE','F351','023442','2024-05-29 13:05:10','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','1764.7058823529412','335.2941176470588','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:05:11','2100','351','BOD. FARMANORTE 351','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','29/05/2024','',2100,0,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2024-05-29 13:05:10',  999.61, 55601, 742, 372),('FVE','F351','023443','2024-05-29 13:22:15','052024','CO','1129510117','YOYARWIN','BARRIOS','calle 50 c  1 f  67  carrizal ',' 3022437845','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','14200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:22:15','14200','351','BOD. FARMANORTE 351','1','14200','14200','14200','0','14200','1','0','0','','29/05/2024','',0,14200,0,'7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA *60 ML','616','HALEON (GLAXO OTC)','2024-05-29 13:22:15',  12808.3, 54127, 742, 372),('FVE','F351','023444','2024-05-29 13:32:01','052024','CO','72241058','ELVER','TOVAR','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','8500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:32:01','8500','351','BOD. FARMANORTE 351','1','8500','8500','8500','0','8500','1','0','0','','29/05/2024','',8500,0,0,'7702057073459','SILDENAFIL 50 MG * 2 TAB','654','MK ETICOS CONVENIO','2024-05-29 13:32:01',  5425.59, 43298, 742, 372),('FVE','F351','023445','2024-05-29 13:36:53','052024','CO','25435406','LUIS','M','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','6300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:36:53','6300','351','BOD. FARMANORTE 351','1','6300','6300','6300','0','6300','1','0','0','','29/05/2024','',6300,0,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2024-05-29 13:36:53',  4500, 48626, 742, 372),('FVE','F351','023446','2024-05-29 13:40:05','052024','CO','32765798','ADRIANA ','NAVARRO','Bloque 107 apto 301 Ciudadela ',' 3012752485','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','13','28649.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:40:05','29400','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','29/05/2024','',29400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 13:40:05',  100, 44347, 742, 372),('FVE','F351','023446','2024-05-29 13:40:05','052024','CO','32765798','ADRIANA ','NAVARRO','Bloque 107 apto 301 Ciudadela ',' 3012752485','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','13','28649.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:40:05','29400','351','BOD. FARMANORTE 351','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','29/05/2024','',29400,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-29 13:40:05',  15435, 56535, 742, 372),('FVE','F351','023446','2024-05-29 13:40:05','052024','CO','32765798','ADRIANA ','NAVARRO','Bloque 107 apto 301 Ciudadela ',' 3012752485','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','13','28649.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:40:05','29400','351','BOD. FARMANORTE 351','1','22500','22500','22500','0','22500','1','0','0','','29/05/2024','',29400,0,0,'7709990988116','BRONCOHELIX JARABE * 120 ML','642','GFC','2024-05-29 13:40:05',  4250, 37258, 742, 372),('FVE','F351','023446','2024-05-29 13:40:05','052024','CO','32765798','ADRIANA ','NAVARRO','Bloque 107 apto 301 Ciudadela ',' 3012752485','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','13','28649.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:40:05','29400','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',29400,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 13:40:05',  1500, 44348, 742, 372),('FVE','F351','023447','2024-05-29 13:53:23','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','3781.512605042017','718.4873949579828','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 13:53:23','4500','351','BOD. FARMANORTE 351','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','29/05/2024','',4500,0,0,'7702045563726','BALANCE CLINICAL CREMA MINI MEN * 32 GR','203','HENKEL COLOMBIANA','2024-05-29 13:53:23',  2890.8, 52775, 742, 372),('FVE','F351','023448','2024-05-29 14:01:01','052024','CO','1022945161','LEIDYS','DIAZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','3109.2436974789916','590.7563025210084','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 14:01:01','3700','351','BOD. FARMANORTE 351','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','29/05/2024','',3700,0,0,'7702090051827','NATU MALTA BOTELLA *1000 ML','192','POSTOBON GASEOSAS','2024-05-29 14:01:01',  2542, 55375, 742, 372),('FVE','F351','023449','2024-05-29 14:38:32','052024','CO','22383708','ISIDRA ','LOPEZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','11','20900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 14:38:32','20900','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','29/05/2024','',20900,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-29 14:38:32',  28997, 54625, 742, 372),('FVE','F351','023449','2024-05-29 14:38:32','052024','CO','22383708','ISIDRA ','LOPEZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','11','20900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 14:38:32','20900','351','BOD. FARMANORTE 351','1','17900','17900','17900','0','17900','1','0','0','','29/05/2024','',20900,0,0,'7703546033107','CRONOFEN L JBE * 100 ML  L-RESPI-RIN','1039','NOVAMED BABY ','2024-05-29 14:38:32',  7500, 43430, 742, 372),('FVE','F351','023450','2024-05-29 14:47:15','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','7720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 14:47:15','7800','351','BOD. FARMANORTE 351','1','3200','3200','3200','0','3200','0','1','0','','29/05/2024','',0,7800,0,'7703153040949','DICLOFENACO 75MG/3ML CJA * 10 AMP','422','COLMED','2024-05-29 14:47:15',  5600, 61834, 742, 372),('FVE','F351','023450','2024-05-29 14:47:15','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','7720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 14:47:15','7800','351','BOD. FARMANORTE 351','1','4100','4100','4100','0','4100','0','1','0','','29/05/2024','',0,7800,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-29 14:47:15',  7000, 23704, 742, 372),('FVE','F351','023450','2024-05-29 14:47:15','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','7720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 14:47:15','7800','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/05/2024','',0,7800,0,'7707282990274','JERINGA 5ML DESECHABLE  21GX1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-29 14:47:15',  168.46, 58667, 742, 372),('FVE','F351','023451','2024-05-29 14:54:02','052024','CO','32664997','MARIA','DEL PILAR','cll47d 1a4-15',' 3017355680','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','25210.084033613446','4789.915966386554','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 14:54:02','30000','351','BOD. FARMANORTE 351','1','30000','30000','25210.084033613','4789.9159663866','30000','1','0','1','','29/05/2024','',30000,0,0,'7709562377607','VIT MAX B + ZINC * 30 CAP','1000','NATURALMENTE','2024-05-29 14:54:02',  9730, 48941, 742, 372),('FVE','F351','023452','2024-05-29 15:00:40','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','8900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:00:41','8900','351','BOD. FARMANORTE 351','1','8900','8900','8900','0','8900','1','0','0','','29/05/2024','',0,8900,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-29 15:00:40',  6610, 47205, 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','023456','2024-05-29 15:07:14','052024','CR','1129543572','CAROLINA','HERRERA BARROS','CALLE 50A NO.11-143',' 3012287395','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','411331','1','40500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:39:21','40500','351','BOD. FARMANORTE 351','1','40500','40500','40500','0','40500','1','0','0','','29/05/2024','',0,0,40500,'7500435120050','CLEARBLUE DIGITAL PRUEBA DE EMBARAZO ','336','PROCTER & GAMBLE COLOMBIA','2024-05-29 15:07:14',  38041.6, 53687, 742, 372),('FVE','F351','023454','2024-05-29 15:17:59','052024','CO','1045698441','MELISA','ORTIZ','CRA 4  49 E 124 ',' 3116566035','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','3','19600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:17:59','19600','351','BOD. FARMANORTE 351','1','8000','8000','8000','0','8000','0','1','0','','29/05/2024','',0,19600,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-29 15:17:59',  53223.5, 41855, 742, 372),('FVE','F351','023454','2024-05-29 15:17:59','052024','CO','1045698441','MELISA','ORTIZ','CRA 4  49 E 124 ',' 3116566035','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','3','19600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:17:59','19600','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',0,19600,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 15:17:59',  1500, 44348, 742, 372),('FVE','F351','023454','2024-05-29 15:17:59','052024','CO','1045698441','MELISA','ORTIZ','CRA 4  49 E 124 ',' 3116566035','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','3','19600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:17:59','19600','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','29/05/2024','',0,19600,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-05-29 15:17:59',  8380, 22278, 742, 372),('FVE','F351','023455','2024-05-29 15:32:26','052024','CO','21070965','RUTH','AVILA','KRA 1E # 45G-50 BLOQUE 162 APT',' 3156275814  3156275814 ','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','48800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:32:26','48800','351','BOD. FARMANORTE 351','2','2900','5800','5800','0','5800','0','2','0','','29/05/2024','',48800,0,0,'7707232099095','ACTIVOX ICE JENGIBRE MASTICABLES * 12 S/S','271','NATURAL FRESHLY','2024-05-29 15:32:26',  17937, 33638, 742, 372),('FVE','F351','023455','2024-05-29 15:32:26','052024','CO','21070965','RUTH','AVILA','KRA 1E # 45G-50 BLOQUE 162 APT',' 3156275814  3156275814 ','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','48800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:32:26','48800','351','BOD. FARMANORTE 351','1','22500','22500','22500','0','22500','1','0','0','','29/05/2024','',48800,0,0,'7709990988116','BRONCOHELIX JARABE * 120 ML','642','GFC','2024-05-29 15:32:26',  4250, 37258, 742, 372),('FVE','F351','023455','2024-05-29 15:32:26','052024','CO','21070965','RUTH','AVILA','KRA 1E # 45G-50 BLOQUE 162 APT',' 3156275814  3156275814 ','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','48800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:32:26','48800','351','BOD. FARMANORTE 351','1','18500','18500','18500','0','18500','1','0','0','','29/05/2024','',48800,0,0,'7707233003443,7','GRIPAC X 10 CAP','387','TRIDEX FARMACEUTICA','2024-05-29 15:32:26',  10200, 43549, 742, 372),('FVE','F351','023455','2024-05-29 15:32:26','052024','CO','21070965','RUTH','AVILA','KRA 1E # 45G-50 BLOQUE 162 APT',' 3156275814  3156275814 ','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','48800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 15:32:26','48800','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',48800,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 15:32:26',  1500, 44348, 742, 372),('FVE','F351','023457','2024-05-29 16:02:16','052024','CO','72336617','ERWIN','MELO','',' 3004643375 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','33403.361344537814','6346.638655462186','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 16:02:16','39750','351','BOD. FARMANORTE 351','1','39750','39750','33403.361344538','6346.6386554622','39750','1','0','1','','29/05/2024','',39750,0,0,'7701021116635','WINNY PANTS ET4 XG *30 UNID','653','TECNOQUIMICAS WINNY','2024-05-29 16:02:16',  30058.2, 55727, 742, 372),('FVE','F351','023458','2024-05-29 16:09:38','052024','CO','72336617','ERWIN','MELO','',' 3004643375 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','8928.57142857143','1696.4285714285706','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 16:09:38','10625','351','BOD. FARMANORTE 351','1','10625','10625','8928.5714285714','1696.4285714286','10625','1','0','0','','29/05/2024','',0,10625,0,'7702277395256','TOALLITAS ARRURRU AVENA Y KARITE *100 UND ','124','BELLEZA EXPRESS SA','2024-05-29 16:09:38',  8177, 55332, 742, 372),('FVE','F351','023459','2024-05-29 16:18:03','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','6','9714','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 16:18:03','9714','351','BOD. FARMANORTE 351','6','1619','9714','9714','0','9714','0','6','0','','29/05/2024','',9714,0,0,'7702626214849','STREPSILS INTENSIVE MIEL-LIMON *16 TAB','357','RECKITT BENCKISER COLOMBIA S A','2024-05-29 16:18:03',  20656, 53074, 742, 372),('FVE','F351','023460','2024-05-29 16:28:36','052024','CO','8780367','ABEDOL','RINCON','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','14500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 16:28:36','14500','351','BOD. FARMANORTE 351','1','14500','14500','14500','0','14500','1','0','0','','29/05/2024','',14500,0,0,'7702057070939','AZITROMICINA 500 MG * 3 TAB','654','MK ETICOS CONVENIO','2024-05-29 16:28:36',  10217.3, 42809, 742, 372),('FVE','F351','023461','2024-05-29 16:40:55','052024','CO','1002092686','TAILA','TEJA ','calle 48b n 1b 42 cuidadela',' 3007664419  3007664419 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','2900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 16:40:55','2900','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','1','0','0','','29/05/2024','',2900,0,0,'7702560000362','ALGODON JGB *25 GR','219','JGB','2024-05-29 16:40:55',  1750.1, 27772, 742, 372),('FVE','F351','023462','2024-05-29 17:26:35','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','3800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:26:35','3800','351','BOD. FARMANORTE 351','1','3800','3800','3800','0','3800','1','0','0','','29/05/2024','',3800,0,0,'7702560026577','ALCOHOL JGB *120 ML','219','JGB','2024-05-29 17:26:35',  2529, 27762, 742, 372),('FVE','F351','023463','2024-05-29 17:30:36','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','4','5828.571428571428','271.42857142857133','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:30:37','6100','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','29/05/2024','',6100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 17:30:36',  100, 44347, 742, 372),('FVE','F351','023463','2024-05-29 17:30:36','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','4','5828.571428571428','271.42857142857133','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:30:37','6100','351','BOD. FARMANORTE 351','1','4200','4200','4200','0','4200','1','0','0','','29/05/2024','',6100,0,0,'7705366903028','CLORURO DE SODIO S.S. 9% *500 ML ','156','CORPAUL','2024-05-29 17:30:36',  3653.8, 58440, 742, 372),('FVE','F351','023463','2024-05-29 17:30:36','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','4','5828.571428571428','271.42857142857133','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:30:37','6100','351','BOD. FARMANORTE 351','2','850','1700','1428.5714285714','271.42857142857','1700','2','0','0','','29/05/2024','',6100,0,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-05-29 17:30:36',  369, 46955, 742, 372),('FVE','F351','023464','2024-05-29 17:37:42','052024','CO','32616751','LOURDES MARIA','BARROS BLANCO','',' 3043971955','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','4500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:37:42','4500','351','BOD. FARMANORTE 351','1','4500','4500','4500','0','4500','0','1','23','','29/05/2024','',4500,0,0,'7707210530114','FORZ CREMA *24 SOBRES ','256','GERCO','2024-05-29 17:37:42',  57865, 46090, 742, 372),('FVE','F351','023465','2024-05-29 17:54:08','052024','CO','22523772','JOHANA','AGUILAR','CRA 1 C 3 45H 21  2 piso ciuda',' 3054616786','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','12','29100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:54:08','29100','351','BOD. FARMANORTE 351','10','1000','10000','10000','0','10000','0','10','0','','29/05/2024','',29100,0,0,'7706569021168','CEFALEXINA 500MG *50 TAB','614','A.G. MEDICAMENTOS','2024-05-29 17:54:08',  40132, 31286, 742, 372),('FVE','F351','023465','2024-05-29 17:54:08','052024','CO','22523772','JOHANA','AGUILAR','CRA 1 C 3 45H 21  2 piso ciuda',' 3054616786','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','12','29100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:54:08','29100','351','BOD. FARMANORTE 351','1','17100','17100','17100','0','17100','1','0','0','','29/05/2024','',29100,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-29 17:54:08',  2500, 57400, 742, 372),('FVE','F351','023465','2024-05-29 17:54:08','052024','CO','22523772','JOHANA','AGUILAR','CRA 1 C 3 45H 21  2 piso ciuda',' 3054616786','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','12','29100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 17:54:08','29100','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',29100,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 17:54:08',  1500, 44348, 742, 372),('FVE','F351','023469','2024-05-29 17:54:09','052024','CR','72335744','JORGE LUIS','VEGA DOMINGUEZ','CALLE 46 NO.1-44',' 3045575404','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','847963','6','49019.32773109243','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:09:33','50599.99999999999','351','BOD. FARMANORTE 351','1','38500','38500','38500','0','38500','1','0','0','','29/05/2024','',0,0,50600,'7704232001998','FITOSTIMOLINE CREMA *15 GR','178','EUROETIKA','2024-05-29 17:54:09',  34291, 56823, 742, 372),('FVE','F351','023469','2024-05-29 17:54:09','052024','CR','72335744','JORGE LUIS','VEGA DOMINGUEZ','CALLE 46 NO.1-44',' 3045575404','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','847963','6','49019.32773109243','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:09:33','50599.99999999999','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','29/05/2024','',0,0,50600,'7702189053824','DORITOS MEGA QUESO *68 GR','762','FRITO LAY','2024-05-29 17:54:09',  2521, 54759, 742, 372),('FVE','F351','023469','2024-05-29 17:54:09','052024','CR','72335744','JORGE LUIS','VEGA DOMINGUEZ','CALLE 46 NO.1-44',' 3045575404','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','847963','6','49019.32773109243','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:09:33','50599.99999999999','351','BOD. FARMANORTE 351','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','29/05/2024','',0,0,50600,'7702189054005','DETODITO MEGA NATURAL *65 GR','762','FRITO LAY','2024-05-29 17:54:09',  2437, 54667, 742, 372),('FVE','F351','023469','2024-05-29 17:54:09','052024','CR','72335744','JORGE LUIS','VEGA DOMINGUEZ','CALLE 46 NO.1-44',' 3045575404','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','847963','6','49019.32773109243','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:09:33','50599.99999999999','351','BOD. FARMANORTE 351','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','29/05/2024','',0,0,50600,'7702090031928','GASEOSA MANZANA POSTOBON *400 ML','192','POSTOBON GASEOSAS','2024-05-29 17:54:09',  1400.8, 40922, 742, 372),('FVE','F351','023469','2024-05-29 17:54:09','052024','CR','72335744','JORGE LUIS','VEGA DOMINGUEZ','CALLE 46 NO.1-44',' 3045575404','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','847963','6','49019.32773109243','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:09:33','50599.99999999999','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','29/05/2024','',0,0,50600,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 17:54:09',  100, 44347, 742, 372),('FVE','F351','023469','2024-05-29 17:54:09','052024','CR','72335744','JORGE LUIS','VEGA DOMINGUEZ','CALLE 46 NO.1-44',' 3045575404','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','847963','6','49019.32773109243','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:09:33','50599.99999999999','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',0,0,50600,'DO','DOMICILIO','00','VARIOS','2024-05-29 17:54:09',  1500, 44348, 742, 372),('FVE','F351','023466','2024-05-29 18:05:08','052024','CO','111122','PAGO ','FALTANTES','','    311 ','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','10','5581.344537815126','638.6554621848736','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:05:08','6220','351','BOD. FARMANORTE 351','2','500','1000','840.33613445378','159.66386554622','1000','2','0','0','','29/05/2024','',6220,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-05-29 18:05:08',  255, 46100, 742, 372),('FVE','F351','023466','2024-05-29 18:05:08','052024','CO','111122','PAGO ','FALTANTES','','    311 ','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','10','5581.344537815126','638.6554621848736','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:05:08','6220','351','BOD. FARMANORTE 351','2','1110','2220','2220','0','2220','0','2','0','','29/05/2024','',6220,0,0,'7702123006787','ALKA SELTZER *60 TAB','631','BAYER OTC','2024-05-29 18:05:08',  58340, 46895, 742, 372),('FVE','F351','023466','2024-05-29 18:05:08','052024','CO','111122','PAGO ','FALTANTES','','    311 ','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','10','5581.344537815126','638.6554621848736','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:05:08','6220','351','BOD. FARMANORTE 351','6','500','3000','2521.0084033613','478.99159663866','3000','0','6','0','','29/05/2024','',6220,0,0,'D1572','TAPABOCAS QUIRURGICOS NIñOS *50 UND','806','COVID19','2024-05-29 18:05:08',  9360, 50062, 742, 372),('FVE','F351','023467','2024-05-29 18:05:46','052024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','3900','0','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:05:46','3900','351','BOD. FARMANORTE 351','1','3900','3900','3900','0','3900','0','1','1','','29/05/2024','',3900,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-29 18:05:46',  7000, 23704, 742, 372),('FVE','F351','023468','2024-05-29 18:06:54','052024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','43','272477.64705882355','4582.352941176468','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:06:55','277060','351','BOD. FARMANORTE 351','16','1110','17760','17760','0','17760','0','16','1','','29/05/2024','',277060,0,0,'7702123006787','ALKA SELTZER *60 TAB','631','BAYER OTC','2024-05-29 18:06:54',  58340, 46895, 742, 372),('FVE','F351','023468','2024-05-29 18:06:54','052024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','43','272477.64705882355','4582.352941176468','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:06:55','277060','351','BOD. FARMANORTE 351','3','35000','105000','105000','0','105000','3','0','1','','29/05/2024','',277060,0,0,'7709465967349','DERGINTREX CREMA TOPICA * 40 GR','1000','NATURALMENTE','2024-05-29 18:06:54',  10200, 62080, 742, 372),('FVE','F351','023468','2024-05-29 18:06:54','052024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','43','272477.64705882355','4582.352941176468','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:06:55','277060','351','BOD. FARMANORTE 351','2','25000','50000','50000','0','50000','0','2','1','','29/05/2024','',277060,0,0,'D1012','PULMICORT 0.5 MG *5 RESPULES','117','ASTRAZENECA COLOMBIA','2024-05-29 18:06:54',  112621, 22772, 742, 372),('FVE','F351','023468','2024-05-29 18:06:54','052024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','43','272477.64705882355','4582.352941176468','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:06:55','277060','351','BOD. FARMANORTE 351','15','1000','15000','15000','0','15000','0','15','1','','29/05/2024','',277060,0,0,'7703712032019','HIOSCINA N-BUTIL BROMURO 10MG *20 TAB','143','COASPHARMA SAS','2024-05-29 18:06:54',  10096.1, 24315, 742, 372),('FVE','F351','023468','2024-05-29 18:06:54','052024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','43','272477.64705882355','4582.352941176468','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:06:55','277060','351','BOD. FARMANORTE 351','6','10100','60600','60600','0','60600','6','0','1','','29/05/2024','',277060,0,0,'7703186518101','PEDIASURE LIQUIDO FRESA *220 ML ','659','ABBOTT NUTRICION','2024-05-29 18:06:54',  9020, 45576, 742, 372),('FVE','F351','023468','2024-05-29 18:06:54','052024','CO','1042448800','ALICIA REGINA','CARRASCAL POLO ','CRA 19 NO.63-39',' 3015525860','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','43','272477.64705882355','4582.352941176468','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:06:55','277060','351','BOD. FARMANORTE 351','1','28700','28700','24117.647058824','4582.3529411765','28700','1','0','1','','29/05/2024','',277060,0,0,'650240032691','TEATRICAL CREMA FACIAL ANTIARRUGAS *100 GR','194','GENOMMA LABORATORIO COLOMBIA','2024-05-29 18:06:54',  20804, 54079, 742, 372),('FVE','F351','023470','2024-05-29 18:13:53','052024','CO','111122','PAGO ','FALTANTES','','    311 ','112','WILMER ARMANDO ','DURÁN MALAGON ','','TERCERO','VARIOS','','','','','','112','11200','0','351','FARMANORTE 351','AUXAUDITOR10','2024-05-29 18:13:53','11200','351','BOD. FARMANORTE 351','112','100','11200','11200','0','11200','112','0','0','','29/05/2024','',11200,0,0,'D99','GRACIAS POR SU COMPRA','348','PROVEEDORES VARIOS','2024-05-29 18:13:53',  0, 40609, 742, 372),('FVE','F351','023471','2024-05-29 18:16:27','052024','CO','1001994710','ANDRES','M','','02 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','24200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:16:27','24200','351','BOD. FARMANORTE 351','1','24200','24200','24200','0','24200','1','0','1','','29/05/2024','',24200,0,0,'7501043130769','DOLEX NINOS 7+ *120 ML  ','616','HALEON (GLAXO OTC)','2024-05-29 18:16:27',  17651, 26539, 742, 372),('FVE','F351','023472','2024-05-29 18:24:02','052024','CO','8784879','CARLOS ARTURO','SERNA','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','20700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:24:02','20700','351','BOD. FARMANORTE 351','1','20700','20700','20700','0','20700','1','0','0','','29/05/2024','',20700,0,0,'7703712080171','GRIBONGIN 2% JARABE * 120 ML /D24/','387','TRIDEX FARMACEUTICA','2024-05-29 18:24:02',  12001, 53836, 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','023474','2024-05-29 18:49:35','052024','CO','1045667920','JONATAN','PATI Ntilde O','calle 57 b  33 a -24  gaviota ',' 3008182120','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','19','42030','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:49:35','42030','351','BOD. FARMANORTE 351','2','8900','17800','17800','0','17800','2','0','0','','29/05/2024','',2000,40030,0,'7501125149221','ELECTROLIT FRESA-KIWI SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-29 18:49:35',  6785, 33981, 742, 372),('FVE','F351','023474','2024-05-29 18:49:35','052024','CO','1045667920','JONATAN','PATI Ntilde O','calle 57 b  33 a -24  gaviota ',' 3008182120','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','19','42030','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:49:35','42030','351','BOD. FARMANORTE 351','10','483','4830','4830','0','4830','0','10','0','','29/05/2024','',2000,40030,0,'7706569002853','METOCLOPRAMIDA 10MG *30 TAB','614','A.G. MEDICAMENTOS','2024-05-29 18:49:35',  11219, 31597, 742, 372),('FVE','F351','023474','2024-05-29 18:49:35','052024','CO','1045667920','JONATAN','PATI Ntilde O','calle 57 b  33 a -24  gaviota ',' 3008182120','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','19','42030','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:49:35','42030','351','BOD. FARMANORTE 351','6','2900','17400','17400','0','17400','0','6','0','','29/05/2024','',2000,40030,0,'7702057803278','GASTROFAST ADVANCE *10 SACHETS','877','TECNOQUIMICAS VM TQ','2024-05-29 18:49:35',  22029.28, 58051, 742, 372),('FVE','F351','023474','2024-05-29 18:49:35','052024','CO','1045667920','JONATAN','PATI Ntilde O','calle 57 b  33 a -24  gaviota ',' 3008182120','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','19','42030','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:49:35','42030','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',2000,40030,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 18:49:35',  1500, 44348, 742, 372),('FVE','F351','023475','2024-05-29 18:57:38','052024','CO','1129519737','JOSE','CUETO','',' 3015437251','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','9200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:57:38','9200','351','BOD. FARMANORTE 351','2','4600','9200','9200','0','9200','0','2','0','','29/05/2024','',0,9200,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-29 18:57:38',  27780, 54056, 742, 372),('FVE','F351','023476','2024-05-29 18:58:49','052024','CO','1143163258','YULISSA ','MENDEZ','CL 48 N 1 B 62 CASA BLANCA','0 3011939798','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','15','30495.798319327732','3704.2016806722677','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:58:49','34200','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','29/05/2024','',34200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 18:58:49',  100, 44347, 742, 372),('FVE','F351','023476','2024-05-29 18:58:49','052024','CO','1143163258','YULISSA ','MENDEZ','CL 48 N 1 B 62 CASA BLANCA','0 3011939798','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','15','30495.798319327732','3704.2016806722677','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:58:49','34200','351','BOD. FARMANORTE 351','1','18500','18500','15546.218487395','2953.781512605','18500','1','0','0','','29/05/2024','',34200,0,0,'7702132004606','CHAPSTICK MEDICADO *4.2 GR','616','HALEON (GLAXO OTC)','2024-05-29 18:58:49',  13336.9, 39044, 742, 372),('FVE','F351','023476','2024-05-29 18:58:49','052024','CO','1143163258','YULISSA ','MENDEZ','CL 48 N 1 B 62 CASA BLANCA','0 3011939798','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','15','30495.798319327732','3704.2016806722677','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:58:49','34200','351','BOD. FARMANORTE 351','1','5900','5900','5900','0','5900','1','0','0','','29/05/2024','',34200,0,0,'7702560009532','ALCOHOL JGB *350 ML','219','JGB','2024-05-29 18:58:49',  3550.4, 27763, 742, 372),('FVE','F351','023476','2024-05-29 18:58:49','052024','CO','1143163258','YULISSA ','MENDEZ','CL 48 N 1 B 62 CASA BLANCA','0 3011939798','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','15','30495.798319327732','3704.2016806722677','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:58:49','34200','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','1','0','0','','29/05/2024','',34200,0,0,'7702560000362','ALGODON JGB *25 GR','219','JGB','2024-05-29 18:58:49',  1750.1, 27772, 742, 372),('FVE','F351','023476','2024-05-29 18:58:49','052024','CO','1143163258','YULISSA ','MENDEZ','CL 48 N 1 B 62 CASA BLANCA','0 3011939798','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','15','30495.798319327732','3704.2016806722677','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:58:49','34200','351','BOD. FARMANORTE 351','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','29/05/2024','',34200,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-29 18:58:49',  15435, 56535, 742, 372),('FVE','F351','023476','2024-05-29 18:58:49','052024','CO','1143163258','YULISSA ','MENDEZ','CL 48 N 1 B 62 CASA BLANCA','0 3011939798','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','15','30495.798319327732','3704.2016806722677','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 18:58:49','34200','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','29/05/2024','',34200,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 18:58:49',  1500, 44348, 742, 372),('FVE','F351','023477','2024-05-29 19:13:15','052024','CO','3771124','EDUARDO','ARIZA','bloque 172 apto 201',' 3116561358 3116561358','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','22000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:13:16','22000','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','110','','30/05/2024','',22000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 19:13:15',  100, 44347, 742, 372),('FVE','F351','023477','2024-05-29 19:13:15','052024','CO','3771124','EDUARDO','ARIZA','bloque 172 apto 201',' 3116561358 3116561358','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','22000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:13:16','22000','351','BOD. FARMANORTE 351','1','13800','13800','13800','0','13800','1','0','110','','30/05/2024','',22000,0,0,'7702057078799','QUETIAPINA 25 MG *30 TAB MK','654','MK ETICOS CONVENIO','2024-05-29 19:13:15',  10974.7, 43266, 742, 372),('FVE','F351','023477','2024-05-29 19:13:15','052024','CO','3771124','EDUARDO','ARIZA','bloque 172 apto 201',' 3116561358 3116561358','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','22000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:13:16','22000','351','BOD. FARMANORTE 351','10','800','8000','8000','0','8000','0','10','110','','30/05/2024','',22000,0,0,'7703363005554','DOLEX 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-29 19:13:15',  65149.5, 33555, 742, 372),('FVE','F351','023478','2024-05-29 19:13:50','052024','CO','39002300','DELIA ','PEREZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','25','45000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:13:50','45000','351','BOD. FARMANORTE 351','15','2800','42000','42000','0','42000','0','15','0','','30/05/2024','',45000,0,0,'7707263003542','CEFLAXILIN 500 MG * 20 CAP /D22/','387','TRIDEX FARMACEUTICA','2024-05-29 19:13:50',  32088, 43534, 742, 372),('FVE','F351','023478','2024-05-29 19:13:50','052024','CO','39002300','DELIA ','PEREZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','25','45000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:13:50','45000','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',45000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-29 19:13:50',  28997, 54625, 742, 372),('FVE','F351','023479','2024-05-29 19:16:59','052024','CO','32616751','LOURDES MARIA','BARROS BLANCO','',' 3043971955','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','1344.5378151260504','255.46218487394958','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:16:59','1600','351','BOD. FARMANORTE 351','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','7','','30/05/2024','',1600,0,0,'7702025142910','GALLETAS MINICHIPS CHOCOCHIP *35 GR','816','GRUPO NUTRESA','2024-05-29 19:16:59',  1011.0833, 57536, 742, 372),('FVE','F351','023480','2024-05-29 19:17:46','052024','CO','32616751','LOURDES MARIA','BARROS BLANCO','',' 3043971955','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','5500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:17:47','5500','351','BOD. FARMANORTE 351','1','5500','5500','5500','0','5500','1','0','28','','30/05/2024','',5500,0,0,'7706659501174','SUERO FISIOLOGICO X 30 ML','143','COASPHARMA SAS','2024-05-29 19:17:46',  2600, 62018, 742, 372),('FVE','F351','023481','2024-05-29 19:25:45','052024','CO','1045667920','JONATAN','PATI Ntilde O','calle 57 b  33 a -24  gaviota ',' 3008182120','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','19','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:25:46','53200','351','BOD. FARMANORTE 351','8','4900','39200','39200','0','39200','0','8','0','','30/05/2024','',14000,39200,0,'7703153015763','MUVETT S 200 MG * 21 TAB','334','PROCAPS OTX','2024-05-29 19:25:45',  52700, 39853, 742, 372),('FVE','F351','023481','2024-05-29 19:25:45','052024','CO','1045667920','JONATAN','PATI Ntilde O','calle 57 b  33 a -24  gaviota ',' 3008182120','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','19','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:25:46','53200','351','BOD. FARMANORTE 351','10','1200','12000','12000','0','12000','0','10','0','','30/05/2024','',14000,39200,0,'7707019402117','COLESPAS 10 MG CJA *30 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-29 19:25:45',  11800, 53948, 742, 372),('FVE','F351','023481','2024-05-29 19:25:45','052024','CO','1045667920','JONATAN','PATI Ntilde O','calle 57 b  33 a -24  gaviota ',' 3008182120','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','19','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:25:46','53200','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',14000,39200,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 19:25:45',  1500, 44348, 742, 372),('FVE','F351','023482','2024-05-29 19:48:16','052024','CO','1001779264','HELEN JULIANA','P Atilde  copy REZ CARRILLO','bloque 85 parte de atras',' 3214998180','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','3','230100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:48:16','230100','351','BOD. FARMANORTE 351','1','219200','219200','219200','0','219200','1','0','0','20','30/05/2024','',230100,0,0,'7506205811104','ENFAMIL PREMIUM 2 PROMENTAL *1650 GR','295','MEAD JOHNSON NUTRITION COLOMBIA','2024-05-29 19:48:16',  203724, 52265, 742, 372),('FVE','F351','023482','2024-05-29 19:48:16','052024','CO','1001779264','HELEN JULIANA','P Atilde  copy REZ CARRILLO','bloque 85 parte de atras',' 3214998180','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','3','230100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:48:16','230100','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',230100,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 19:48:16',  1500, 44348, 742, 372),('FVE','F351','023482','2024-05-29 19:48:16','052024','CO','1001779264','HELEN JULIANA','P Atilde  copy REZ CARRILLO','bloque 85 parte de atras',' 3214998180','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','3','230100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:48:16','230100','351','BOD. FARMANORTE 351','1','8900','8900','8900','0','8900','1','0','0','','30/05/2024','',230100,0,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-29 19:48:16',  6610, 47205, 742, 372),('FVE','F351','023483','2024-05-29 19:49:20','052024','CO','1143170123','HANSEL','BETTER','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','3','22500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:49:20','22500','351','BOD. FARMANORTE 351','2','2700','5400','5400','0','5400','0','2','0','','30/05/2024','',22500,0,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-05-29 19:49:20',  33370, 62346, 742, 372),('FVE','F351','023483','2024-05-29 19:49:20','052024','CO','1143170123','HANSEL','BETTER','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','3','22500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 19:49:20','22500','351','BOD. FARMANORTE 351','1','17100','17100','17100','0','17100','1','0','0','','30/05/2024','',22500,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-29 19:49:20',  2500, 57400, 742, 372),('FVE','F351','023484','2024-05-29 20:01:26','052024','CO','32658571','MARBEL','ZAPATA','','0 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','3','8014.285714285715','135.71428571428567','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:01:26','8150','351','BOD. FARMANORTE 351','1','4100','4100','4100','0','4100','0','1','0','','30/05/2024','',0,8150,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-29 20:01:26',  7000, 23704, 742, 372),('FVE','F351','023484','2024-05-29 20:01:26','052024','CO','32658571','MARBEL','ZAPATA','','0 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','3','8014.285714285715','135.71428571428567','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:01:26','8150','351','BOD. FARMANORTE 351','1','850','850','714.28571428571','135.71428571429','850','1','0','0','','30/05/2024','',0,8150,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-05-29 20:01:26',  369, 46955, 742, 372),('FVE','F351','023484','2024-05-29 20:01:26','052024','CO','32658571','MARBEL','ZAPATA','','0 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','3','8014.285714285715','135.71428571428567','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:01:26','8150','351','BOD. FARMANORTE 351','1','3200','3200','3200','0','3200','0','1','0','','30/05/2024','',0,8150,0,'7703153040949','DICLOFENACO 75MG/3ML CJA * 10 AMP','422','COLMED','2024-05-29 20:01:26',  5600, 61834, 742, 372),('FVE','F351','023485','2024-05-29 20:05:12','052024','CO','3389735','GERMAN','MILLAN','calle 48 b n 1b - 54  por el p','  3022347513','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','12000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:05:12','12000','351','BOD. FARMANORTE 351','1','12000','12000','12000','0','12000','1','0','0','','30/05/2024','',0,12000,0,'7707019339123','DIFLENAC 100 MG *20 CAP','130','LABQUIFAR PHARMACEUTICA','2024-05-29 20:05:12',  7840, 56951, 742, 372),('FVE','F351','023486','2024-05-29 20:09:30','052024','CO','22616043','MARGARITA','CAMARGO','',' 3205487961','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','10','14000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:09:30','14000','351','BOD. FARMANORTE 351','10','1400','14000','14000','0','14000','0','10','0','','30/05/2024','',14000,0,0,'7707019402063','DOSALDIN *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-29 20:09:30',  13040, 45886, 742, 372),('FVE','F351','023487','2024-05-29 20:10:13','052024','CO','72220480','MARCO','COREGA','CALLE 45 C 5 B -104  BUENO AIR',' 3008801978','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','27000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:10:13','27000','351','BOD. FARMANORTE 351','1','25000','25000','25000','0','25000','1','0','0','','30/05/2024','',0,27000,0,'7709990733730','FLUIMED * 120 ML','698','MED-LINE CONVENIO','2024-05-29 20:10:13',  11550, 27603, 742, 372),('FVE','F351','023487','2024-05-29 20:10:13','052024','CO','72220480','MARCO','COREGA','CALLE 45 C 5 B -104  BUENO AIR',' 3008801978','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','27000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:10:13','27000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',0,27000,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 20:10:13',  1500, 44348, 742, 372),('FVE','F351','023489','2024-05-29 20:10:13','052024','CR','13515918','WILSON RUBIEL','RUEDA MARTINEZ','CALLE 47 NO.1C-76 CIUDADELA',' 3013508823','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','693147','1','3277.310924369748','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:18:57','3900','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','30/05/2024','',0,0,3900,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','POSTOBON GASEOSAS','2024-05-29 20:10:13',  2451, 25826, 742, 372),('FVE','F351','023488','2024-05-29 20:18:07','052024','CO','7183329','JORGE','NAVARRO','',' 3225354758','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','8200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:18:07','8200','351','BOD. FARMANORTE 351','1','4200','4200','4200','0','4200','1','0','1','','30/05/2024','',8200,0,0,'7705366903028','CLORURO DE SODIO S.S. 9% *500 ML ','156','CORPAUL','2024-05-29 20:18:07',  3653.8, 58440, 742, 372),('FVE','F351','023488','2024-05-29 20:18:07','052024','CO','7183329','JORGE','NAVARRO','',' 3225354758','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','5','8200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:18:07','8200','351','BOD. FARMANORTE 351','4','1000','4000','4000','0','4000','4','0','1','','30/05/2024','',8200,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2024-05-29 20:18:07',  570, 58629, 742, 372),('FVE','F351','023490','2024-05-29 20:21:58','052024','CO','1045672302','JAVIER','CANO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','14000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:21:58','14000','351','BOD. FARMANORTE 351','1','6300','6300','6300','0','6300','1','0','0','','30/05/2024','',14000,0,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2024-05-29 20:21:58',  4500, 48626, 742, 372),('FVE','F351','023490','2024-05-29 20:21:58','052024','CO','1045672302','JAVIER','CANO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','14000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:21:58','14000','351','BOD. FARMANORTE 351','1','7700','7700','7700','0','7700','1','0','0','','30/05/2024','',14000,0,0,'7703712030534','PREDNISOLONA 5 MG * 30 TAB','143','COASPHARMA SAS','2024-05-29 20:21:58',  2769.2, 24361, 742, 372),('FVE','F351','023491','2024-05-29 20:26:27','052024','CO','22649967','DAINIRS','ROMERO','',' 3046570367','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','4900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:26:27','4900','351','BOD. FARMANORTE 351','1','4900','4900','4900','0','4900','1','0','0','','30/05/2024','',4900,0,0,'7707228362141','CINTA MICROPOROSA PIEL ALFASAFE 1 X 3 YD','429','ALFA SAFE','2024-05-29 20:26:27',  3036, 60552, 742, 372),('FVE','F351','023492','2024-05-29 20:30:32','052024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','3420','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:30:32','3420','351','BOD. FARMANORTE 351','2','1710','3420','3420','0','3420','0','2','0','','30/05/2024','',3420,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-29 20:30:32',  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','023494','2024-05-29 20:34:23','052024','CO','8733871','ARGEMIRO','DIAZ','',' 3155526123','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','4500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:34:23','4500','351','BOD. FARMANORTE 351','1','4500','4500','4500','0','4500','0','1','0','','30/05/2024','',0,4500,0,'7707210530114','FORZ CREMA *24 SOBRES ','256','GERCO','2024-05-29 20:34:23',  57865, 46090, 742, 372),('FVE','F351','023495','2024-05-29 20:35:30','052024','CO','32822903','JUDITH','CHAR','',' 3067277 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','13500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:35:30','13500','351','BOD. FARMANORTE 351','1','13500','13500','13500','0','13500','1','0','0','','30/05/2024','',13500,0,0,'7702605100156','ACICLOVIR 5% UNG *15 GR','193','GENFAR','2024-05-29 20:35:30',  9674, 25876, 742, 372),('FVE','F351','023496','2024-05-29 20:38:52','052024','CO','1233338875','JUAN FELIPE','BRU','',' 3016397247','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','6','9664','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:38:52','9664','351','BOD. FARMANORTE 351','4','1466','5864','5864','0','5864','0','4','0','','30/05/2024','',9664,0,0,'7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2024-05-29 20:38:52',  66736, 55304, 742, 372),('FVE','F351','023496','2024-05-29 20:38:52','052024','CO','1233338875','JUAN FELIPE','BRU','',' 3016397247','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','6','9664','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:38:52','9664','351','BOD. FARMANORTE 351','2','1900','3800','3800','0','3800','0','2','0','','30/05/2024','',9664,0,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-29 20:38:52',  131275.53, 43180, 742, 372),('FVE','F351','023497','2024-05-29 20:46:20','052024','CO','3132821','ALEX','GALINDO','',' 0','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','3697.478991596639','702.5210084033611','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 20:46:20','4400','351','BOD. FARMANORTE 351','1','4400','4400','3697.4789915966','702.52100840336','4400','1','0','0','','30/05/2024','',4400,0,0,'7702031401032','JOHNSON BABYJABON ORIGINAL *110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-05-29 20:46:20',  3201, 56126, 742, 372),('FVE','F351','023498','2024-05-29 21:18:37','052024','CO','22643760','YESENIA PATRICIA','DE LA CRUZ RODRIGUEZ','11','0  3017162543','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','5900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:18:37','5900','351','BOD. FARMANORTE 351','1','5900','5900','5900','0','5900','1','0','30','','30/05/2024','',5900,0,0,'7702560009532','ALCOHOL JGB *350 ML','219','JGB','2024-05-29 21:18:37',  3550.4, 27763, 742, 372),('FVE','F351','023499','2024-05-29 21:24:41','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','5100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:24:41','5100','351','BOD. FARMANORTE 351','3','1700','5100','5100','0','5100','0','3','0','','30/05/2024','',5100,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-05-29 21:24:41',  50000, 31759, 742, 372),('FVE','F351','023500','2024-05-29 21:32:03','052024','CO','72335203','EDWIN','FAJARDO','cra 7 sur    50-23 conidec','  3024776963','3877','EIMY JHOANA','RIVERA GUZMAN','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','20900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:32:03','20900','351','BOD. FARMANORTE 351','1','18900','18900','18900','0','18900','1','0','0','','30/05/2024','',20900,0,0,'7702184011560','ATORVASTATINA 40 MG *10 TAB  ','249','ECAR','2024-05-29 21:32:03',  16900, 51290, 742, 372),('FVE','F351','023500','2024-05-29 21:32:03','052024','CO','72335203','EDWIN','FAJARDO','cra 7 sur    50-23 conidec','  3024776963','3877','EIMY JHOANA','RIVERA GUZMAN','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','20900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:32:03','20900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',20900,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 21:32:03',  1500, 44348, 742, 372),('FVE','F351','023501','2024-05-29 21:33:43','052024','CO','72335203','EDWIN','FAJARDO','cra 7 sur    50-23 conidec','  3024776963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','10','3949.5798319327732','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:33:43','4700','351','BOD. FARMANORTE 351','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','30/05/2024','',4700,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-29 21:33:43',  15435, 56535, 742, 372),('FVE','F351','023502','2024-05-29 21:36:46','052024','CO','1045670924','URBANO','LAFAURIE','3',' 3046474509','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','562210','8704718','VILLAFANE FLOREZ JUAN CARLOS','','','12','40357.98319327731','2842.0168067226878','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:36:47','43200','351','BOD. FARMANORTE 351','1','17800','17800','14957.983193277','2842.0168067227','17800','1','0','0','','30/05/2024','',43200,0,0,'7709285612627','TERMOMETRO DIGITAL MODELO MT-502B','750','DIAGNOSTICOS BIOMEDICOS','2024-05-29 21:36:46',  6000, 57559, 742, 372),('FVE','F351','023502','2024-05-29 21:36:46','052024','CO','1045670924','URBANO','LAFAURIE','3',' 3046474509','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','562210','8704718','VILLAFANE FLOREZ JUAN CARLOS','','','12','40357.98319327731','2842.0168067226878','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:36:47','43200','351','BOD. FARMANORTE 351','10','800','8000','8000','0','8000','0','10','0','','30/05/2024','',43200,0,0,'7703363005554','DOLEX 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-29 21:36:46',  65149.5, 33555, 742, 372),('FVE','F351','023502','2024-05-29 21:36:46','052024','CO','1045670924','URBANO','LAFAURIE','3',' 3046474509','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','562210','8704718','VILLAFANE FLOREZ JUAN CARLOS','','','12','40357.98319327731','2842.0168067226878','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:36:47','43200','351','BOD. FARMANORTE 351','1','17400','17400','17400','0','17400','1','0','0','','30/05/2024','',43200,0,0,'7707019312607','SUPRIBAC F * 10 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-29 21:36:46',  5510, 45829, 742, 372),('FVE','F351','023503','2024-05-29 21:39:52','052024','CO','1007118683','KEVIN','VILLA','.',' 0 3011128214','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','7789.0756302521','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:39:52','8300','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/05/2024','',8300,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-05-29 21:39:52',  1806, 56307, 742, 372),('FVE','F351','023503','2024-05-29 21:39:52','052024','CO','1007118683','KEVIN','VILLA','.',' 0 3011128214','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','7789.0756302521','510.92436974789916','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:39:52','8300','351','BOD. FARMANORTE 351','3','1700','5100','5100','0','5100','0','3','0','','30/05/2024','',8300,0,0,'7707019402100','ESPASMYDOL *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-29 21:39:52',  15690, 23565, 742, 372),('FVE','F351','023504','2024-05-29 21:42:01','052024','CO','72255694','GELMU','CASTRO','','0 0 3215392653','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','14650','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:42:01','14650','351','BOD. FARMANORTE 351','10','975','9750','9750','0','9750','0','10','0','','30/05/2024','',14650,0,0,'7703283131036','VIBAZINA *40 TAB','326','PFIZER FARMA','2024-05-29 21:42:01',  36703, 39201, 742, 372),('FVE','F351','023504','2024-05-29 21:42:01','052024','CO','72255694','GELMU','CASTRO','','0 0 3215392653','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','14650','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:42:01','14650','351','BOD. FARMANORTE 351','1','4900','4900','4900','0','4900','0','1','0','','30/05/2024','',14650,0,0,'7706440000671','NEURO-15 FOSFORO *20 CAP','260','INCOBRA FARMA','2024-05-29 21:42:01',  76304.4, 29922, 742, 372),('FVE','F351','023505','2024-05-29 21:47:14','052024','CO','7481515','CANDALOSO','SILVERIO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','14500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 21:47:14','14500','351','BOD. FARMANORTE 351','1','14500','14500','14500','0','14500','1','0','0','','30/05/2024','',14500,0,0,'7702057070939','AZITROMICINA 500 MG * 3 TAB','654','MK ETICOS CONVENIO','2024-05-29 21:47:14',  10217.3, 42809, 742, 372),('FVE','F351','023506','2024-05-29 22:08:21','052024','CO','1143143932','LICETH','ZUBIRIA ','Calle 47b # 1a4-63 piso 2',' 3142068643','3877','EIMY JHOANA','RIVERA GUZMAN','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','6','8000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 22:08:21','8000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',8000,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-29 22:08:21',  1500, 44348, 742, 372),('FVE','F351','023506','2024-05-29 22:08:21','052024','CO','1143143932','LICETH','ZUBIRIA ','Calle 47b # 1a4-63 piso 2',' 3142068643','3877','EIMY JHOANA','RIVERA GUZMAN','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','6','8000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 22:08:21','8000','351','BOD. FARMANORTE 351','5','1200','6000','6000','0','6000','0','5','0','','30/05/2024','',8000,0,0,'7703153007102','METRONIDAZOL 500 MG *10 OVULOS','422','COLMED','2024-05-29 22:08:21',  13900.7, 39832, 742, 372),('FVE','F351','023507','2024-05-29 22:20:55','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 22:20:55','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/05/2024','',1900,0,0,'7702189057884','CHEETOS TRISSITOS PICANTES *34 GR','762','FRITO LAY','2024-05-29 22:20:55',  1159, 60824, 742, 372),('FVE','F351','023508','2024-05-29 22:23:31','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1092.4369747899161','207.56302521008388','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 22:23:32','1300','351','BOD. FARMANORTE 351','1','1300','1300','1092.4369747899','207.56302521008','1300','1','0','0','','30/05/2024','',1300,0,0,'7590011251100','GALLETA OREO ORIGINAL *36 GR','754','DISCOB NORTE SAS','2024-05-29 22:23:31',  742.3, 27459, 742, 372),('FVE','F351','023509','2024-05-29 22:31:50','052024','CO','1001997718','GUSTAVO','BALOCO','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','8907.563025210085','1692.4369747899154','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 22:31:50','10600','351','BOD. FARMANORTE 351','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','30/05/2024','',0,10600,0,'7702090051827','NATU MALTA BOTELLA *1000 ML','192','POSTOBON GASEOSAS','2024-05-29 22:31:50',  2542, 55375, 742, 372),('FVE','F351','023509','2024-05-29 22:31:50','052024','CO','1001997718','GUSTAVO','BALOCO','',' 1','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','8907.563025210085','1692.4369747899154','351','FARMANORTE 351','ADMINISTRADOR','2024-05-29 22:31:50','10600','351','BOD. FARMANORTE 351','1','6900','6900','5798.3193277311','1101.6806722689','6900','1','0','0','','30/05/2024','',0,10600,0,'7702189056719','PAPAS MARGARITAS CREMA CEBOLLA *110 GR','762','FRITO LAY','2024-05-29 22:31:50',  4873.95, 58604, 742, 372),('FVE','F351','023510','2024-05-30 00:41:42','052024','CO','1129540808','LUIS ALFONSO','CASTRO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','4300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 00:41:42','4300','351','BOD. FARMANORTE 351','1','4300','4300','4300','0','4300','1','0','0','','30/05/2024','',4300,0,0,'7709990045826','BETAMETASONA 4MG/1ML *1 AMP','701','VITALIS COMERCIAL','2024-05-30 00:41:42',  1800, 54345, 742, 372),('FVE','F351','023511','2024-05-30 04:43:05','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','4600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 04:43:06','4600','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','0','1','0','','30/05/2024','',4600,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 04:43:05',  27780, 54056, 742, 372),('FVE','F351','023512','2024-05-30 06:33:06','052024','CO','72006409','EVER','POLO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','7720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 06:33:07','7800','351','BOD. FARMANORTE 351','1','3200','3200','3200','0','3200','0','1','0','','30/05/2024','',0,7800,0,'7703153040949','DICLOFENACO 75MG/3ML CJA * 10 AMP','422','COLMED','2024-05-30 06:33:06',  5600, 61834, 742, 372),('FVE','F351','023512','2024-05-30 06:33:06','052024','CO','72006409','EVER','POLO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','7720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 06:33:07','7800','351','BOD. FARMANORTE 351','1','4100','4100','4100','0','4100','0','1','0','','30/05/2024','',0,7800,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-30 06:33:06',  7000, 23704, 742, 372),('FVE','F351','023512','2024-05-30 06:33:06','052024','CO','72006409','EVER','POLO','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','7720.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 06:33:07','7800','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','30/05/2024','',0,7800,0,'7707282990274','JERINGA 5ML DESECHABLE  21GX1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 06:33:06',  168.46, 58667, 742, 372),('FVE','F351','023513','2024-05-30 06:47:43','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','6700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 06:47:43','6700','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','0','1','0','','30/05/2024','',6700,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-05-30 06:47:43',  18581.4, 46200, 742, 372),('FVE','F351','023513','2024-05-30 06:47:43','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','6700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 06:47:43','6700','351','BOD. FARMANORTE 351','2','1900','3800','3800','0','3800','0','2','0','','30/05/2024','',6700,0,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-30 06:47:43',  131275.53, 43180, 742, 372),('FVE','F351','023514','2024-05-30 06:56:21','052024','CO','1001889343','DULLIS','VALENCIA','Calle 46j #1c-55 ',' 3013681513','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','20600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 06:56:21','20600','351','BOD. FARMANORTE 351','1','16000','16000','16000','0','16000','1','0','0','','30/05/2024','',0,20600,0,'7707019413908','TRICLIMBAC SOLUCION OTICA *10 ML','130','LABQUIFAR PHARMACEUTICA','2024-05-30 06:56:21',  7000, 45901, 742, 372),('FVE','F351','023514','2024-05-30 06:56:21','052024','CO','1001889343','DULLIS','VALENCIA','Calle 46j #1c-55 ',' 3013681513','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','20600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 06:56:21','20600','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','0','1','0','','30/05/2024','',0,20600,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 06:56:21',  27780, 54056, 742, 372),('FVE','F351','023515','2024-05-30 07:18:33','052024','CO','32723795','MACOLFA','REINA','cra 1 c   46 e 53  ciudadela a',' 3005215490','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','17600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 07:18:33','17600','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','30/05/2024','',17600,0,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-05-30 07:18:33',  8380, 22278, 742, 372),('FVE','F351','023515','2024-05-30 07:18:33','052024','CO','32723795','MACOLFA','REINA','cra 1 c   46 e 53  ciudadela a',' 3005215490','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','17600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 07:18:33','17600','351','BOD. FARMANORTE 351','10','800','8000','8000','0','8000','0','10','0','','30/05/2024','',17600,0,0,'7703363005554','DOLEX 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-30 07:18:33',  65149.5, 33555, 742, 372),('FVE','F351','023516','2024-05-30 07:26:40','052024','CO','1143142899','DANIELA','SANCHEZ','CRA1B1 #47-28 CIUDADELA 20 JUL',' 3008119874','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','15400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 07:26:40','15400','351','BOD. FARMANORTE 351','1','15400','15400','15400','0','15400','1','0','0','','30/05/2024','',0,15400,0,'7707019334012','HONGISTINA SUSPENSION *60 ML BIOQUIFAR','130','LABQUIFAR PHARMACEUTICA','2024-05-30 07:26:40',  7950, 45855, 742, 372),('FVE','F351','023517','2024-05-30 07:34:04','052024','CO','8640786','RAFAEL','AMADOR','',' 3209469847','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','10000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 07:34:04','10000','351','BOD. FARMANORTE 351','1','8000','8000','8000','0','8000','0','1','0','','30/05/2024','',10000,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-30 07:34:04',  53223.5, 41855, 742, 372),('FVE','F351','023517','2024-05-30 07:34:04','052024','CO','8640786','RAFAEL','AMADOR','',' 3209469847','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','10000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 07:34:04','10000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','1','0','','30/05/2024','',10000,0,0,'107703381000951','BUSCAPINA COMP N.F *100 TAB','772','OPELLA (SANOFI OTC)','2024-05-30 07:34:04',  161226.6, 23806, 742, 372),('FVE','F351','023518','2024-05-30 07:51:33','052024','CO','1045710070','JESUS','COTES','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','4','6840','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 07:51:33','6840','351','BOD. FARMANORTE 351','4','1710','6840','6840','0','6840','0','4','0','','30/05/2024','',6840,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-30 07:51:33',  2500, 57400, 742, 372),('FVE','F351','023519','2024-05-30 08:31:29','052024','CO','722444863','HAROL','SANTIAGO','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','32000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 08:31:29','32000','351','BOD. FARMANORTE 351','1','32000','32000','32000','0','32000','1','0','0','','30/05/2024','',32000,0,0,'7707263004631','GALEZOL 500 MG * 6 TAB  /D28/','387','TRIDEX FARMACEUTICA','2024-05-30 08:31:29',  22800, 62671, 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','023521','2024-05-30 10:16:34','052024','CO','72202858','JUSTO','PALMA','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','15','6500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 10:16:34','6500','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',6500,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-30 10:16:34',  28997, 54625, 742, 372),('FVE','F351','023521','2024-05-30 10:16:34','052024','CO','72202858','JUSTO','PALMA','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','15','6500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 10:16:34','6500','351','BOD. FARMANORTE 351','5','700','3500','3500','0','3500','0','5','0','','30/05/2024','',6500,0,0,'7702605100309','AMOXICILINA 500MG *50 CAP','193','GENFAR','2024-05-30 10:16:34',  24112, 25902, 742, 372),('FVE','F351','023522','2024-05-30 10:44:51','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 10:44:51','500','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/05/2024','',500,0,0,'D1572','TAPABOCAS QUIRURGICOS NIñOS *50 UND','806','COVID19','2024-05-30 10:44:51',  9360, 50062, 742, 372),('FVE','F351','023523','2024-05-30 12:17:35','052024','CO','1129530497','MICHELL','YEPEZ','CALLE 47 N 1 J - 100 BLOQUE 86',' 3004680165','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','3','17600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 12:17:35','17600','351','BOD. FARMANORTE 351','2','7800','15600','15600','0','15600','2','0','0','','30/05/2024','',17600,0,0,'7703038065630','ACETAMINOFEN JARABE *90 ML','275','LAPROFF','2024-05-30 12:17:35',  3270.84, 46646, 742, 372),('FVE','F351','023523','2024-05-30 12:17:35','052024','CO','1129530497','MICHELL','YEPEZ','CALLE 47 N 1 J - 100 BLOQUE 86',' 3004680165','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','3','17600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 12:17:35','17600','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',17600,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 12:17:35',  1500, 44348, 742, 372),('FVE','F351','023524','2024-05-30 13:05:43','052024','CO','85126132','WILFRIDO','COLON','0',' 0  0 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','11','20100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 13:05:43','20100','351','BOD. FARMANORTE 351','1','11900','11900','11900','0','11900','1','0','0','','30/05/2024','',20100,0,0,'8710428018670','ENSURE ADVANCE LIQUIDO VAINILLA *220 ML','659','ABBOTT NUTRICION','2024-05-30 13:05:43',  10680, 33849, 742, 372),('FVE','F351','023524','2024-05-30 13:05:43','052024','CO','85126132','WILFRIDO','COLON','0',' 0  0 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','11','20100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 13:05:43','20100','351','BOD. FARMANORTE 351','10','820','8200','8200','0','8200','0','10','0','','30/05/2024','',20100,0,0,'7707232097671','HEPATODREN TRIPLE ACCION *60 CAP','271','NATURAL FRESHLY','2024-05-30 13:05:43',  26073.9, 33811, 742, 372),('FVE','F351','023525','2024-05-30 13:24:21','052024','CO','','','','',' 3002692042','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','5','7500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 13:24:21','7500','351','BOD. FARMANORTE 351','5','1500','7500','7500','0','7500','0','5','1','','30/05/2024','',7500,0,0,'7707263004051','GRIPAC 4 * 100 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 13:24:21',  94299, 58014, 742, 372),('FVE','F351','023526','2024-05-30 15:25:53','052024','CO','1048324271','JHON','MU Ntilde OZ','BLOQUE 193 APTO 101 45H #4-76',' 1 3016824014','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','4','72922.68907563025','6977.310924369747','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 15:25:53','79900','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/05/2024','',0,79900,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 15:25:53',  100, 44347, 742, 372),('FVE','F351','023526','2024-05-30 15:25:53','052024','CO','1048324271','JHON','MU Ntilde OZ','BLOQUE 193 APTO 101 45H #4-76',' 1 3016824014','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','4','72922.68907563025','6977.310924369747','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 15:25:53','79900','351','BOD. FARMANORTE 351','1','34000','34000','34000','0','34000','1','0','0','','30/05/2024','',0,79900,0,'7701684000128','ALMIPRO UNG PARA LA PAÑALITIS *125 GR','786','ALMIPRO','2024-05-30 15:25:53',  23904, 54418, 742, 372),('FVE','F351','023526','2024-05-30 15:25:53','052024','CO','1048324271','JHON','MU Ntilde OZ','BLOQUE 193 APTO 101 45H #4-76',' 1 3016824014','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','4','72922.68907563025','6977.310924369747','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 15:25:53','79900','351','BOD. FARMANORTE 351','1','43700','43700','36722.68907563','6977.3109243697','43700','1','0','0','','30/05/2024','',0,79900,0,'7701021114174','WINNY ULTRATRIM SEC ET5 *30 UND  ','653','TECNOQUIMICAS WINNY','2024-05-30 15:25:53',  32994.9, 43226, 742, 372),('FVE','F351','023526','2024-05-30 15:25:53','052024','CO','1048324271','JHON','MU Ntilde OZ','BLOQUE 193 APTO 101 45H #4-76',' 1 3016824014','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','4','72922.68907563025','6977.310924369747','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 15:25:53','79900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',0,79900,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 15:25:53',  1500, 44348, 742, 372),('FVE','F351','023527','2024-05-30 15:34:48','052024','CO','1001851194','ELKIN','PALMA','',' 3024417809','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','2','1848.7394957983195','351.26050420168053','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 15:34:48','2200','351','BOD. FARMANORTE 351','2','1100','2200','1848.7394957983','351.26050420168','2200','2','0','0','','30/05/2024','',2200,0,0,'7702025125531','GALLETAS TOSH YOGURT Y FRESAS *24.8 GR','816','GRUPO NUTRESA','2024-05-30 15:34:48',  700, 35255, 742, 372),('FVE','F351','023528','2024-05-30 16:07:58','052024','CO','11143165485','BRIANA','SUAREZ','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','3000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 16:07:58','3000','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-30 16:07:58',  28997, 54625, 742, 372),('FVE','F351','023529','2024-05-30 16:43:37','052024','CO','1143451602','SANTI','SOLANO','',' 3105434967','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','33403.361344537814','6346.638655462186','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 16:43:37','39750','351','BOD. FARMANORTE 351','1','39750','39750','33403.361344538','6346.6386554622','39750','1','0','0','10','30/05/2024','',39750,0,0,'7701021116635','WINNY PANTS ET4 XG *30 UNID','653','TECNOQUIMICAS WINNY','2024-05-30 16:43:37',  30058.2, 55727, 742, 372),('FVE','F351','023530','2024-05-30 16:46:04','052024','CO','5484426','YOSELIN','VASQUEZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','7','21540.33613445378','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 16:46:04','21700','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/05/2024','',21700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 16:46:04',  100, 44347, 742, 372),('FVE','F351','023530','2024-05-30 16:46:04','052024','CO','5484426','YOSELIN','VASQUEZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','7','21540.33613445378','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 16:46:04','21700','351','BOD. FARMANORTE 351','2','6900','13800','13800','0','13800','2','0','0','','30/05/2024','',21700,0,0,'7707236127688','GENTAMICINA 160MG/2ML *1 AMP','701','VITALIS COMERCIAL','2024-05-30 16:46:04',  4400, 54109, 742, 372),('FVE','F351','023530','2024-05-30 16:46:04','052024','CO','5484426','YOSELIN','VASQUEZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','7','21540.33613445378','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 16:46:04','21700','351','BOD. FARMANORTE 351','2','500','1000','840.33613445378','159.66386554622','1000','2','0','0','','30/05/2024','',21700,0,0,'7707228361762','JERINGA 3ML 1G *1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2024-05-30 16:46:04',  213, 60547, 742, 372),('FVE','F351','023530','2024-05-30 16:46:04','052024','CO','5484426','YOSELIN','VASQUEZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','7','21540.33613445378','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 16:46:04','21700','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','1','0','0','','30/05/2024','',21700,0,0,'7702560000362','ALGODON JGB *25 GR','219','JGB','2024-05-30 16:46:04',  1750.1, 27772, 742, 372),('FVE','F351','023530','2024-05-30 16:46:04','052024','CO','5484426','YOSELIN','VASQUEZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','7','21540.33613445378','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 16:46:04','21700','351','BOD. FARMANORTE 351','1','3800','3800','3800','0','3800','1','0','0','','30/05/2024','',21700,0,0,'7702560026577','ALCOHOL JGB *120 ML','219','JGB','2024-05-30 16:46:04',  2529, 27762, 742, 372),('FVE','F351','023531','2024-05-30 17:01:05','052024','CO','1042348854','EVER','DE LA HOZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','13','8700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:01:05','8700','351','BOD. FARMANORTE 351','3','1900','5700','5700','0','5700','0','3','0','','30/05/2024','',8700,0,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-30 17:01:05',  131275.53, 43180, 742, 372),('FVE','F351','023531','2024-05-30 17:01:05','052024','CO','1042348854','EVER','DE LA HOZ','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','13','8700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:01:05','8700','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',8700,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-30 17:01:05',  28997, 54625, 742, 372),('FVE','F351','023532','2024-05-30 17:14:15','052024','CO','1143445003','HECTOR ','LOPEZ','CALLE 37 C # 1 J 1 - 20-- Cra ',' 3215874108','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','4','50256.3025210084','5843.697478991595','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:14:15','56100','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/05/2024','',0,56100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 17:14:15',  100, 44347, 742, 372),('FVE','F351','023532','2024-05-30 17:14:15','052024','CO','1143445003','HECTOR ','LOPEZ','CALLE 37 C # 1 J 1 - 20-- Cra ',' 3215874108','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','4','50256.3025210084','5843.697478991595','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:14:15','56100','351','BOD. FARMANORTE 351','1','17300','17300','17300','0','17300','1','0','0','','30/05/2024','',0,56100,0,'7703712010000','NELIND CREMA * 40 GR','795','COASPHARMA MEDIBRAND OTC','2024-05-30 17:14:15',  11132.63, 24352, 742, 372),('FVE','F351','023532','2024-05-30 17:14:15','052024','CO','1143445003','HECTOR ','LOPEZ','CALLE 37 C # 1 J 1 - 20-- Cra ',' 3215874108','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','4','50256.3025210084','5843.697478991595','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:14:15','56100','351','BOD. FARMANORTE 351','1','36600','36600','30756.302521008','5843.6974789916','36600','1','0','0','','30/05/2024','',0,56100,0,'7709990613124','AFTAKIDS GEL CON ACIDO HIALURONICO *15 GR','944','PF FARMACEUTICA SA','2024-05-30 17:14:15',  26890.8, 54391, 742, 372),('FVE','F351','023532','2024-05-30 17:14:15','052024','CO','1143445003','HECTOR ','LOPEZ','CALLE 37 C # 1 J 1 - 20-- Cra ',' 3215874108','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','4','50256.3025210084','5843.697478991595','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:14:15','56100','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',0,56100,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 17:14:15',  1500, 44348, 742, 372),('FVE','F351','023533','2024-05-30 17:20:54','052024','CO','32895182','DORMELINA','GARCIA','KRA 1  B 2    47-15',' 3052489044','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','7900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:20:54','7900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',7900,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 17:20:54',  1500, 44348, 742, 372),('FVE','F351','023533','2024-05-30 17:20:54','052024','CO','32895182','DORMELINA','GARCIA','KRA 1  B 2    47-15',' 3052489044','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','7900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:20:54','7900','351','BOD. FARMANORTE 351','1','5900','5900','5900','0','5900','1','0','0','','30/05/2024','',7900,0,0,'7703689317386','OCEIRA *21 TAB','344','PROFAMILIA','2024-05-30 17:20:54',  4800, 57132, 742, 372),('FVE','F351','023534','2024-05-30 17:44:12','052024','CO','72262107','ALEXANDER MAURICIO','PRECIADO GUZMAN','CRA 1 B - 47 D -21  ',' 3215690446','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','9','10000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:44:12','10000','351','BOD. FARMANORTE 351','8','1000','8000','8000','0','8000','8','0','50','','30/05/2024','',10000,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2024-05-30 17:44:12',  570, 58629, 742, 372),('FVE','F351','023534','2024-05-30 17:44:12','052024','CO','72262107','ALEXANDER MAURICIO','PRECIADO GUZMAN','CRA 1 B - 47 D -21  ',' 3215690446','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','9','10000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:44:12','10000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','50','','30/05/2024','',10000,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 17:44:12',  1500, 44348, 742, 372),('FVE','F351','023535','2024-05-30 17:55:13','052024','CO','26812413','TERESA','SALA','calle 46 g n 1 c - 81',' 3114063131','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','5800','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 17:55:13','5800','351','BOD. FARMANORTE 351','2','2900','5800','5800','0','5800','0','2','0','','30/05/2024','',5800,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-05-30 17:55:13',  18581.4, 46200, 742, 372),('FVE','F351','023536','2024-05-30 18:09:57','052024','CO','8740307','LUIS ','SOTO','000',' 3214589653','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','3','18400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 18:09:57','18400','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/05/2024','',18400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 18:09:57',  100, 44347, 742, 372),('FVE','F351','023536','2024-05-30 18:09:57','052024','CO','8740307','LUIS ','SOTO','000',' 3214589653','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','3','18400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 18:09:57','18400','351','BOD. FARMANORTE 351','2','9100','18200','18200','0','18200','2','0','0','6','30/05/2024','',18400,0,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-05-30 18:09:57',  8329, 52291, 742, 372),('FVE','F351','023537','2024-05-30 18:43:48','052024','CO','72338790','FABIAN','CARMELO','',' 0','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','9700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 18:43:48','9700','351','BOD. FARMANORTE 351','1','9700','9700','9700','0','9700','1','0','0','','30/05/2024','',9700,0,0,'7702026149567','NOSOTRAS BUENAS NOCHES TELA *10 UND','337','FAMILIA SANCELA','2024-05-30 18:43:48',  8769, 40265, 742, 372),('FVE','F351','023538','2024-05-30 18:53:08','052024','CO','1129543572','CAROLINA','HERRERA BARROS','CALLE 50A NO.11-143',' 3012287395','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','1176.4705882352941','223.52941176470586','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 18:53:08','1400','351','BOD. FARMANORTE 351','1','1400','1400','1176.4705882353','223.52941176471','1400','1','0','1','','30/05/2024','',1400,0,0,'7702025136797','GALLETA FESTIVAL LIMON *6 GALLETAS','816','GRUPO NUTRESA','2024-05-30 18:53:08',  872.0833, 53167, 742, 372),('FVE','F351','023539','2024-05-30 18:56:07','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','10','3000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 18:56:08','3000','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-30 18:56:07',  28997, 54625, 742, 372),('FVE','F351','023540','2024-05-30 19:05:37','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','3250','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:05:37','3250','351','BOD. FARMANORTE 351','1','3250','3250','3250','0','3250','0','1','0','','30/05/2024','',3250,0,0,'7706569020079','SILDENAFIL 50 MG * 2 TAB MASTICABLES','614','A.G. MEDICAMENTOS','2024-05-30 19:05:37',  4856, 31770, 742, 372),('FVE','F351','023541','2024-05-30 19:13:01','052024','CO','32883851','MAGALY','OCHOA','BLOQUE 19 APTO 201 CIUDADELA 2','0 3006278070','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','24','28100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:13:01','28100','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/05/2024','',28100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 19:13:01',  100, 44347, 742, 372),('FVE','F351','023541','2024-05-30 19:13:01','052024','CO','32883851','MAGALY','OCHOA','BLOQUE 19 APTO 201 CIUDADELA 2','0 3006278070','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','24','28100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:13:01','28100','351','BOD. FARMANORTE 351','10','700','7000','7000','0','7000','0','10','0','','30/05/2024','',28100,0,0,'7706569000026','AMOXICILINA 500MG *50 CAP','614','A.G. MEDICAMENTOS','2024-05-30 19:13:01',  21949, 31190, 742, 372),('FVE','F351','023541','2024-05-30 19:13:01','052024','CO','32883851','MAGALY','OCHOA','BLOQUE 19 APTO 201 CIUDADELA 2','0 3006278070','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','24','28100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:13:01','28100','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',28100,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 19:13:01',  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','023541','2024-05-30 19:13:01','052024','CO','32883851','MAGALY','OCHOA','BLOQUE 19 APTO 201 CIUDADELA 2','0 3006278070','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','24','28100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:13:01','28100','351','BOD. FARMANORTE 351','4','2125','8500','8500','0','8500','0','4','0','','30/05/2024','',28100,0,0,'7702057012410','BENZIRIN VERDE EUCALIPTO CJA *100 TAB','877','TECNOQUIMICAS VM TQ','2024-05-30 19:13:01',  201875, 33594, 742, 372),('FVE','F351','023542','2024-05-30 19:21:54','052024','CO','1045705515','KAROLINA ','RODRIGUEZ','CALLE47 N 1B1 11','  3013368481','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','6','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:21:55','53200','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','30/05/2024','',0,53200,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 19:21:54',  100, 44347, 742, 372),('FVE','F351','023542','2024-05-30 19:21:54','052024','CO','1045705515','KAROLINA ','RODRIGUEZ','CALLE47 N 1B1 11','  3013368481','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','6','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:21:55','53200','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','30/05/2024','',0,53200,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-05-30 19:21:54',  8380, 22278, 742, 372),('FVE','F351','023542','2024-05-30 19:21:54','052024','CO','1045705515','KAROLINA ','RODRIGUEZ','CALLE47 N 1B1 11','  3013368481','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','6','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:21:55','53200','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','30/05/2024','',0,53200,0,'7703186577030','PEDIALYTE 30 CEREZA *500 ML','659','ABBOTT NUTRICION','2024-05-30 19:21:54',  8380, 22268, 742, 372),('FVE','F351','023542','2024-05-30 19:21:54','052024','CO','1045705515','KAROLINA ','RODRIGUEZ','CALLE47 N 1B1 11','  3013368481','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','6','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:21:55','53200','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',0,53200,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 19:21:54',  1500, 44348, 742, 372),('FVE','F351','023542','2024-05-30 19:21:54','052024','CO','1045705515','KAROLINA ','RODRIGUEZ','CALLE47 N 1B1 11','  3013368481','2644','CAROLINA','HERRERA BARROS','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','6','53200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:21:55','53200','351','BOD. FARMANORTE 351','2','15900','31800','31800','0','31800','0','2','0','','30/05/2024','',0,53200,0,'7702771001561','ENTEROGERMINA PLUS *5 AMP','772','OPELLA (SANOFI OTC)','2024-05-30 19:21:54',  74092.5, 48571, 742, 372),('FVE','F351','023543','2024-05-30 19:25:56','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','2700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:25:56','2700','351','BOD. FARMANORTE 351','1','2700','2700','2700','0','2700','0','1','0','','30/05/2024','',2700,0,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-05-30 19:25:56',  33370, 62346, 742, 372),('FVE','F351','023544','2024-05-30 19:33:27','052024','CO','1143333869','YASMIN','CAMARGO','0',' 3005456234','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','30','9949.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:33:27','10700','351','BOD. FARMANORTE 351','20','300','6000','6000','0','6000','0','20','0','','31/05/2024','',0,10700,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-30 19:33:27',  28997, 54625, 742, 372),('FVE','F351','023544','2024-05-30 19:33:27','052024','CO','1143333869','YASMIN','CAMARGO','0',' 3005456234','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','30','9949.579831932773','750.4201680672268','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:33:27','10700','351','BOD. FARMANORTE 351','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','31/05/2024','',0,10700,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-30 19:33:27',  15435, 56535, 742, 372),('FVE','F351','023545','2024-05-30 19:40:14','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','5','19300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:40:14','19300','351','BOD. FARMANORTE 351','1','10900','10900','10900','0','10900','1','0','0','','31/05/2024','',19300,0,0,'7706569001450','NAPROXENO 500 MG *10 TAB','614','A.G. MEDICAMENTOS','2024-05-30 19:40:14',  8563, 31632, 742, 372),('FVE','F351','023545','2024-05-30 19:40:14','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','5','19300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:40:14','19300','351','BOD. FARMANORTE 351','4','2100','8400','8400','0','8400','0','4','0','','31/05/2024','',19300,0,0,'7702132008529','ADVIL ULTRA *72 CAP ','616','HALEON (GLAXO OTC)','2024-05-30 19:40:14',  139438.1, 39002, 742, 372),('FVE','F351','023546','2024-05-30 19:43:18','052024','CO','1143239401','YEISON','CORDERO','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','18','58998.31932773109','3001.680672268907','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:43:18','62000','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,62000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 19:43:18',  100, 44347, 742, 372),('FVE','F351','023546','2024-05-30 19:43:18','052024','CO','1143239401','YEISON','CORDERO','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','18','58998.31932773109','3001.680672268907','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:43:18','62000','351','BOD. FARMANORTE 351','1','31500','31500','31500','0','31500','1','0','0','','31/05/2024','',0,62000,0,'7702132009748','ADVIL CHILDREN *100 ML ','616','HALEON (GLAXO OTC)','2024-05-30 19:43:18',  28044, 46798, 742, 372),('FVE','F351','023546','2024-05-30 19:43:18','052024','CO','1143239401','YEISON','CORDERO','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','18','58998.31932773109','3001.680672268907','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:43:18','62000','351','BOD. FARMANORTE 351','4','1300','5200','5200','0','5200','0','4','0','','31/05/2024','',0,62000,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-30 19:43:18',  114652, 26533, 742, 372),('FVE','F351','023546','2024-05-30 19:43:18','052024','CO','1143239401','YEISON','CORDERO','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','18','58998.31932773109','3001.680672268907','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:43:18','62000','351','BOD. FARMANORTE 351','1','6300','6300','6300','0','6300','1','0','0','','31/05/2024','',0,62000,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2024-05-30 19:43:18',  4500, 48626, 742, 372),('FVE','F351','023546','2024-05-30 19:43:18','052024','CO','1143239401','YEISON','CORDERO','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','18','58998.31932773109','3001.680672268907','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:43:18','62000','351','BOD. FARMANORTE 351','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','31/05/2024','',0,62000,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-30 19:43:18',  15435, 56535, 742, 372),('FVE','F351','023546','2024-05-30 19:43:18','052024','CO','1143239401','YEISON','CORDERO','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','18','58998.31932773109','3001.680672268907','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:43:18','62000','351','BOD. FARMANORTE 351','1','14099.99','14099.99','11848.739495798','2251.2605042017','14100','1','0','0','','31/05/2024','',0,62000,0,'7501086453931','PRO CEPILLO 425 MEDIO 2X1','336','PROCTER & GAMBLE COLOMBIA','2024-05-30 19:43:18',  8902.1333, 39999, 742, 372),('FVE','F351','023547','2024-05-30 19:44:03','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','4200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 19:44:03','4200','351','BOD. FARMANORTE 351','1','4200','4200','4200','0','4200','1','0','0','','31/05/2024','',4200,0,0,'7705366903028','CLORURO DE SODIO S.S. 9% *500 ML ','156','CORPAUL','2024-05-30 19:44:03',  3653.8, 58440, 742, 372),('FVE','F351','023548','2024-05-30 20:11:44','052024','CO','55308401','OLGA ESTER','LARA','CALLE 45 C N 3 - 90 CIUDADELA ','  3104622187','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','48000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:11:44','48000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',0,48000,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 20:11:44',  1500, 44348, 742, 372),('FVE','F351','023548','2024-05-30 20:11:44','052024','CO','55308401','OLGA ESTER','LARA','CALLE 45 C N 3 - 90 CIUDADELA ','  3104622187','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','48000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:11:44','48000','351','BOD. FARMANORTE 351','1','46000','46000','46000','0','46000','1','0','0','10','31/05/2024','',0,48000,0,'7501058626424','KLIM 1+ DESLACTOSADA LATA *800 GR','311','NESTLE NUTRICION','2024-05-30 20:11:44',  42616, 50766, 742, 372),('FVE','F351','023549','2024-05-30 20:18:29','052024','CO','55247128','LIZBETH','RODRIGUEZ','',' 3013910055','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','18','20400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:18:29','20400','351','BOD. FARMANORTE 351','10','800','8000','8000','0','8000','0','10','0','','31/05/2024','',20400,0,0,'7703363005554','DOLEX 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-30 20:18:29',  65149.5, 33555, 742, 372),('FVE','F351','023549','2024-05-30 20:18:29','052024','CO','55247128','LIZBETH','RODRIGUEZ','',' 3013910055','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','18','20400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:18:29','20400','351','BOD. FARMANORTE 351','4','1300','5200','5200','0','5200','0','4','0','','31/05/2024','',20400,0,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-30 20:18:29',  114652, 26533, 742, 372),('FVE','F351','023549','2024-05-30 20:18:29','052024','CO','55247128','LIZBETH','RODRIGUEZ','',' 3013910055','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','18','20400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:18:29','20400','351','BOD. FARMANORTE 351','2','1900','3800','3800','0','3800','0','2','0','','31/05/2024','',20400,0,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-30 20:18:29',  131275.53, 43180, 742, 372),('FVE','F351','023549','2024-05-30 20:18:29','052024','CO','55247128','LIZBETH','RODRIGUEZ','',' 3013910055','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','18','20400','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:18:29','20400','351','BOD. FARMANORTE 351','2','1700','3400','3400','0','3400','0','2','0','','31/05/2024','',20400,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-05-30 20:18:29',  50000, 31759, 742, 372),('FVE','F351','023550','2024-05-30 20:21:54','052024','CO','1049029525','ESNIDER','OSPINO ','',' 3173217482','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1344.5378151260504','255.46218487394958','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:21:54','1600','351','BOD. FARMANORTE 351','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','31/05/2024','',1600,0,0,'7702133009037','GALLETA OREO ORIGINAL *54 GR','754','DISCOB NORTE SAS','2024-05-30 20:21:54',  980.3916, 53741, 742, 372),('FVE','F351','023551','2024-05-30 20:56:54','052024','CO','1140850731','SERGIO','VEGA','0',' 3002660779','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','27731.09243697479','5268.907563025208','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 20:56:54','33000','351','BOD. FARMANORTE 351','1','33000','33000','27731.092436975','5268.9075630252','33000','1','0','0','6','31/05/2024','',33000,0,0,'7701021111821','WINNY ULTRATRIM SEC ET3 *30 + 10 TOALLITAS','653','TECNOQUIMICAS WINNY','2024-05-30 20:56:54',  24948.9, 43221, 742, 372),('FVE','F351','023552','2024-05-30 21:13:09','052024','CO','1140897949','LINA MARCELA ','MATHIEU DIAZ','kra 3 n 50 a - 25 carrizal',' 3014870009','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','28900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 21:13:09','28900','351','BOD. FARMANORTE 351','1','28900','28900','28900','0','28900','1','0','145','6','31/05/2024','',0,28900,0,'7702024025733','KLIM 1+ BOLSA *500 GR','311','NESTLE NUTRICION','2024-05-30 21:13:09',  26210, 38369, 742, 372),('FVE','F351','023553','2024-05-30 21:18:16','052024','CO','1143160551','ANDREA','ALVARADO','CRA1B 47 09 CASA',' 3206957955','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','14500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 21:18:17','14500','351','BOD. FARMANORTE 351','1','14500','14500','14500','0','14500','1','0','0','20','31/05/2024','',0,14500,0,'7702870004425','BELLAFACE *21 TAB ','619','ABBOTT FARMA','2024-05-30 21:18:16',  12656, 31230, 742, 372),('FVE','F351','023554','2024-05-30 21:29:22','052024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','5294.117647058823','1005.8823529411766','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 21:29:22','6300','351','BOD. FARMANORTE 351','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','31/05/2024','',0,6300,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-30 21:29:22',  3881.5, 56142, 742, 372),('FVE','F351','023555','2024-05-30 21:47:12','052024','CO','1046697763','MICHEL','TOBON','',' 3','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','11600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 21:47:12','11600','351','BOD. FARMANORTE 351','1','11600','11600','11600','0','11600','1','0','0','','31/05/2024','',11600,0,0,'7702026147679','NOSOTRAS TAMPONES DIGITAL REGULAR *10 +15 MULTIESTILO','337','FAMILIA SANCELA','2024-05-30 21:47:12',  8621.5, 51308, 742, 372),('FVE','F351','023556','2024-05-30 21:49:37','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','21','4420.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 21:49:37','4500','351','BOD. FARMANORTE 351','20','200','4000','4000','0','4000','0','20','0','','31/05/2024','',4500,0,0,'7702184010082','COMPLEJO B *250 GRAG ECAR','249','ECAR','2024-05-30 21:49:37',  37500, 29732, 742, 372),('FVE','F351','023556','2024-05-30 21:49:37','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','21','4420.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 21:49:37','4500','351','BOD. FARMANORTE 351','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','31/05/2024','',4500,0,0,'7707282990274','JERINGA 5ML DESECHABLE  21GX1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 21:49:37',  168.46, 58667, 742, 372),('FVE','F351','023557','2024-05-30 22:04:09','052024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:04:09','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','31/05/2024','',1900,0,0,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-05-30 22:04:09',  1142.8, 60397, 742, 372),('FVE','F351','023558','2024-05-30 22:17:30','052024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','6420','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:17:30','6420','351','BOD. FARMANORTE 351','2','1710','3420','3420','0','3420','0','2','0','','31/05/2024','',6420,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-30 22:17:30',  2500, 57400, 742, 372),('FVE','F351','023558','2024-05-30 22:17:30','052024','CO','9999','JOSE DOMINGO','RIVIERA','NO',' NO 3123248625','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','6420','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:17:30','6420','351','BOD. FARMANORTE 351','2','1500','3000','3000','0','3000','0','2','0','','31/05/2024','',6420,0,0,'7707263004051','GRIPAC 4 * 100 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 22:17:30',  94299, 58014, 742, 372),('FVE','F351','023559','2024-05-30 22:25:30','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2125','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:25:30','2125','351','BOD. FARMANORTE 351','1','2125','2125','2125','0','2125','0','1','0','','31/05/2024','',2125,0,0,'7702057012410','BENZIRIN VERDE EUCALIPTO CJA *100 TAB','877','TECNOQUIMICAS VM TQ','2024-05-30 22:25:30',  201875, 33594, 742, 372),('FVE','F351','023560','2024-05-30 22:31:11','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','3','3600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:31:11','3600','351','BOD. FARMANORTE 351','3','1200','3600','3600','0','3600','0','3','0','','31/05/2024','',3600,0,0,'7706569001450','NAPROXENO 500 MG *10 TAB','614','A.G. MEDICAMENTOS','2024-05-30 22:31:11',  8563, 31632, 742, 372),('FVE','F351','023561','2024-05-30 22:53:35','052024','CO','1143164298','LAURA','JIMENES','CRA 8 C SUR 467E -17 parque lo',' 3017672881','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','6','119500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:53:35','119500','351','BOD. FARMANORTE 351','1','91500','91500','91500','0','91500','1','0','0','9','31/05/2024','',0,119500,0,'7702207308097','ZIMAQUIN 50MG *10 TAB','619','ABBOTT FARMA','2024-05-30 22:53:35',  84139, 31878, 742, 372),('FVE','F351','023561','2024-05-30 22:53:35','052024','CO','1143164298','LAURA','JIMENES','CRA 8 C SUR 467E -17 parque lo',' 3017672881','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','6','119500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:53:35','119500','351','BOD. FARMANORTE 351','4','3500','14000','14000','0','14000','0','4','0','','31/05/2024','',0,119500,0,'7702123005513','APRONAX 550 MG *60 TAB','631','BAYER OTC','2024-05-30 22:53:35',  175720, 46716, 742, 372),('FVE','F351','023561','2024-05-30 22:53:35','052024','CO','1143164298','LAURA','JIMENES','CRA 8 C SUR 467E -17 parque lo',' 3017672881','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','6','119500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:53:35','119500','351','BOD. FARMANORTE 351','1','14000','14000','14000','0','14000','1','0','0','','31/05/2024','',0,119500,0,'7709225183057','NOVOXICAN 15MG *10 TAB','873','NOVOFAR','2024-05-30 22:53:35',  2270, 58552, 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','023562','2024-05-30 22:59:13','052024','CO','1001780254','KATHERIN DE','ALBA','CALLE 50 1G 16  CARRIZAL CASA ','  3043409302','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','32500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 22:59:13','32500','351','BOD. FARMANORTE 351','1','6500','6500','6500','0','6500','1','0','0','','31/05/2024','',32500,0,0,'7706569000194','HIDROCORTISONA CREMA *15 GR','614','A.G. MEDICAMENTOS','2024-05-30 22:59:13',  4859, 31494, 742, 372),('FVE','F351','023563','2024-05-30 23:06:34','052024','CO','72173951','CARLOS','GOZALES','',' 3215487963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','6500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:06:34','6500','351','BOD. FARMANORTE 351','1','6500','6500','6500','0','6500','1','0','0','','31/05/2024','',6500,0,0,'7706569020079','SILDENAFIL 50 MG * 2 TAB MASTICABLES','614','A.G. MEDICAMENTOS','2024-05-30 23:06:34',  4856, 31770, 742, 372),('FVE','F351','023564','2024-05-30 23:07:06','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:07:07','1900','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','31/05/2024','',1900,0,0,'7702090069495','ACQUA POSTOBON MANZANA S/CALORIAS *400 ML','192','POSTOBON GASEOSAS','2024-05-30 23:07:06',  840.4, 60819, 742, 372),('FVE','F351','023565','2024-05-30 23:16:12','052024','CO','1129519053','EDMAR','MORALES','',' 3145263030','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','12619.327731092437','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:16:12','14200','351','BOD. FARMANORTE 351','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','31/05/2024','',0,14200,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-05-30 23:16:12',  1768.4, 60339, 742, 372),('FVE','F351','023565','2024-05-30 23:16:12','052024','CO','1129519053','EDMAR','MORALES','',' 3145263030','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','12619.327731092437','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:16:12','14200','351','BOD. FARMANORTE 351','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','31/05/2024','',0,14200,0,'7702402055802','VASO ALOHA RASPADO KOLA *160 GR ','296','MEALS DE COLOMBIA','2024-05-30 23:16:12',  2332, 59636, 742, 372),('FVE','F351','023565','2024-05-30 23:16:12','052024','CO','1129519053','EDMAR','MORALES','',' 3145263030','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','12619.327731092437','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:16:12','14200','351','BOD. FARMANORTE 351','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','31/05/2024','',0,14200,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2024-05-30 23:16:12',  1358, 50688, 742, 372),('FVE','F351','023565','2024-05-30 23:16:12','052024','CO','1129519053','EDMAR','MORALES','',' 3145263030','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','12619.327731092437','1580.6722689075627','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:16:12','14200','351','BOD. FARMANORTE 351','1','4300','4300','4300','0','4300','1','0','0','','31/05/2024','',0,14200,0,'7702605102044','OMEPRAZOL 20 MG * 10 CAP','193','GENFAR','2024-05-30 23:16:12',  2863, 26149, 742, 372),('FVE','F351','023566','2024-05-30 23:30:11','052024','CO','72335203','EDWIN','FAJARDO','cra 7 sur    50-23 conidec','  3024776963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','20200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:30:11','20200','351','BOD. FARMANORTE 351','1','14300','14300','14300','0','14300','1','0','0','','31/05/2024','',20200,0,0,'7702057061265','OXIMETAZOLINA 0.05% NASAL *15 ML ADULTOS MK','654','MK ETICOS CONVENIO','2024-05-30 23:30:11',  10456.32, 43203, 742, 372),('FVE','F351','023566','2024-05-30 23:30:11','052024','CO','72335203','EDWIN','FAJARDO','cra 7 sur    50-23 conidec','  3024776963','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','20200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:30:11','20200','351','BOD. FARMANORTE 351','1','5900','5900','5900','0','5900','1','0','0','','31/05/2024','',20200,0,0,'7706569001467','CETIRIZINA 10MG *10 TAB','614','A.G. MEDICAMENTOS','2024-05-30 23:30:11',  4488, 31293, 742, 372),('FVE','F351','023567','2024-05-30 23:59:46','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-30 23:59:46','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 23:59:46',  800, 48019, 742, 372),('FVE','F351','023568','2024-05-31 01:26:11','052024','CO','32612444','EIMY JHOANA','RIVERA GUZMAN','',' 3128862660','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','9900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 01:26:11','9900','351','BOD. FARMANORTE 351','1','9900','9900','9900','0','9900','1','0','1','','31/05/2024','',9900,0,0,'4005800254963','DUO LUBRICADO *3 PRESERVATIVOS','123','BDF (BEIERSDORF) ','2024-05-31 01:26:11',  9427.1, 23315, 742, 372),('FVE','F351','023569','2024-05-31 01:35:53','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','5882.352941176471','1117.6470588235288','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 01:35:54','7000','351','BOD. FARMANORTE 351','2','3500','7000','5882.3529411765','1117.6470588235','7000','2','0','0','','31/05/2024','',7000,0,0,'7702004007360','CERVEZA POKER LATA *330 ML','119','BAVARIA S.A.','2024-05-31 01:35:53',  1732.717, 22837, 742, 372),('FVE','F351','023570','2024-05-31 03:15:27','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 03:15:28','2300','351','BOD. FARMANORTE 351','1','2300','2300','2300','0','2300','0','1','0','','31/05/2024','',2300,0,0,'7702123006947','APRONAX 275 MG *50 CAP','631','BAYER OTC','2024-05-31 03:15:27',  93020, 22870, 742, 372),('FVE','F351','023571','2024-05-31 05:51:15','052024','CO','1045771231','FLOR','MORON','',' 3202081387','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','3','38300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 05:51:15','38300','351','BOD. FARMANORTE 351','1','16200','16200','16200','0','16200','1','0','0','','31/05/2024','',0,38300,0,'7707172685778','DOLEX JARABE 2+ *90 ML ','616','HALEON (GLAXO OTC)','2024-05-31 05:51:15',  8035.7, 26537, 742, 372),('FVE','F351','023571','2024-05-31 05:51:15','052024','CO','1045771231','FLOR','MORON','',' 3202081387','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','3','38300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 05:51:15','38300','351','BOD. FARMANORTE 351','1','14200','14200','14200','0','14200','1','0','0','','31/05/2024','',0,38300,0,'7707172681107','EMULSION DE SCOTT CEREZA *180 ML','616','HALEON (GLAXO OTC)','2024-05-31 05:51:15',  12110.9, 26551, 742, 372),('FVE','F351','023571','2024-05-31 05:51:15','052024','CO','1045771231','FLOR','MORON','',' 3202081387','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','3','38300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 05:51:15','38300','351','BOD. FARMANORTE 351','1','7900','7900','7900','0','7900','1','0','0','','31/05/2024','',0,38300,0,'7703712034273','VITAMINA C GOTAS * 30 ML','143','COASPHARMA SAS','2024-05-31 05:51:15',  4590, 24389, 742, 372),('FVE','F351','023572','2024-05-31 05:57:59','052024','CO','72428221','RUBEN ','RIVERA','',' 3013441863','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','2','5378.151260504202','1021.8487394957983','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 05:57:59','6400','351','BOD. FARMANORTE 351','2','3200','6400','5378.1512605042','1021.8487394958','6400','2','0','0','','31/05/2024','',0,6400,0,'7702004004932','CERVEZA COSTEÑA BACANA LATA *330 ML','119','BAVARIA S.A.','2024-05-31 05:57:59',  2028, 59067, 742, 372),('FVE','F351','023573','2024-05-31 06:20:29','052024','CO','1143148453','SUJEIDIS','TORRES','',' 3127926302','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','20555','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 06:20:29','20555','351','BOD. FARMANORTE 351','1','9300','9300','9300','0','9300','1','0','0','','31/05/2024','',20555,0,0,'7702057010874','HIDRAPLUS 75 ZINC CEREZA *400 ML ','877','TECNOQUIMICAS VM TQ','2024-05-31 06:20:29',  8146.8, 46788, 742, 372),('FVE','F351','023573','2024-05-31 06:20:29','052024','CO','1143148453','SUJEIDIS','TORRES','',' 3127926302','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','20555','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 06:20:29','20555','351','BOD. FARMANORTE 351','4','1710','6840','6840','0','6840','0','4','0','','31/05/2024','',20555,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-31 06:20:29',  2500, 57400, 742, 372),('FVE','F351','023573','2024-05-31 06:20:29','052024','CO','1143148453','SUJEIDIS','TORRES','',' 3127926302','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','20555','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 06:20:29','20555','351','BOD. FARMANORTE 351','5','483','2415','2415','0','2415','0','5','0','','31/05/2024','',20555,0,0,'7706569002853','METOCLOPRAMIDA 10MG *30 TAB','614','A.G. MEDICAMENTOS','2024-05-31 06:20:29',  11219, 31597, 742, 372),('FVE','F351','023573','2024-05-31 06:20:29','052024','CO','1143148453','SUJEIDIS','TORRES','',' 3127926302','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','11','20555','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 06:20:29','20555','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',20555,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 06:20:29',  800, 48019, 742, 372),('FVE','F351','023574','2024-05-31 06:42:10','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','2500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 06:42:10','2500','351','BOD. FARMANORTE 351','1','2500','2500','2500','0','2500','0','1','0','','31/05/2024','',2500,0,0,'7709080992504','LYPTUS MIEL MENTOL CJA * 24 SOBRES','1000','NATURALMENTE','2024-05-31 06:42:10',  17000, 63438, 742, 372),('FVE','F351','023575','2024-05-31 07:03:43','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','5620','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 07:03:44','5620','351','BOD. FARMANORTE 351','2','1100','2200','2200','0','2200','0','2','0','','31/05/2024','',5620,0,0,'7707355053486','NOXPIRIN SINUS *12 TAB PAGUE 10 LLEVE 12','626','SIEGFRIED CONSUMO','2024-05-31 07:03:43',  8844, 33749, 742, 372),('FVE','F351','023575','2024-05-31 07:03:43','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','4','5620','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 07:03:44','5620','351','BOD. FARMANORTE 351','2','1710','3420','3420','0','3420','0','2','0','','31/05/2024','',5620,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-31 07:03:43',  2500, 57400, 742, 372),('FVE','F351','023576','2024-05-31 07:05:47','052024','CO','1007890439','NAZARI','CHACON ','0000',' 3214586953','3877','EIMY JHOANA','RIVERA GUZMAN','','TERCERO','VARIOS','','','','','','1','33100','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 07:05:47','33100','351','BOD. FARMANORTE 351','1','33100','33100','33100','0','33100','1','0','0','','31/05/2024','',33100,0,0,'7501058631138','BABY KLIM 2+ LATA *400 GR','311','NESTLE NUTRICION','2024-05-31 07:05:47',  30064, 51304, 742, 372),('FVE','F351','023577','2024-05-31 07:47:56','052024','CO','1045707980','LUZ','SANTIESTEBAN','',' 3','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','34500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 07:47:57','34500','351','BOD. FARMANORTE 351','10','1180','11800','11800','0','11800','0','10','0','','31/05/2024','',4500,30000,0,'7706569022912','ACETAMINOFEN CODEINA 325/30MG *30 TAB','614','A.G. MEDICAMENTOS','2024-05-31 07:47:56',  27808, 49041, 742, 372),('FVE','F351','023577','2024-05-31 07:47:56','052024','CO','1045707980','LUZ','SANTIESTEBAN','',' 3','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','34500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 07:47:57','34500','351','BOD. FARMANORTE 351','1','10200','10200','10200','0','10200','1','0','0','','31/05/2024','',4500,30000,0,'7702870002636','NOFERTYL AMP *1ML +JGA ','619','ABBOTT FARMA','2024-05-31 07:47:56',  7588, 31651, 742, 372),('FVE','F351','023577','2024-05-31 07:47:56','052024','CO','1045707980','LUZ','SANTIESTEBAN','',' 3','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','12','34500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 07:47:57','34500','351','BOD. FARMANORTE 351','1','12500','12500','12500','0','12500','1','0','0','','31/05/2024','',4500,30000,0,'7702057070571','METOPROLOL 50 MG *30 TAB','654','MK ETICOS CONVENIO','2024-05-31 07:47:56',  9917.72, 43131, 742, 372),('FVE','F351','023578','2024-05-31 08:31:32','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','3813.4453781512607','686.5546218487394','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:31:32','4500','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','31/05/2024','',4500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 08:31:32',  100, 44347, 742, 372),('FVE','F351','023578','2024-05-31 08:31:32','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','3813.4453781512607','686.5546218487394','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:31:32','4500','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','31/05/2024','',4500,0,0,'7702535014233','FUZE TEA TE NEGRO DURAZNO 400ML','144','COCA COLA','2024-05-31 08:31:32',  1712, 35164, 742, 372),('FVE','F351','023578','2024-05-31 08:31:32','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','3813.4453781512607','686.5546218487394','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:31:32','4500','351','BOD. FARMANORTE 351','1','1100','1100','924.36974789916','175.63025210084','1100','1','0','0','','31/05/2024','',4500,0,0,'7622300758943','GALLETA CLUB SOCIAL MANTEQUILLA *26 GR','754','DISCOB NORTE SAS','2024-05-31 08:31:32',  560.224, 27450, 742, 372),('FVE','F351','023579','2024-05-31 08:40:48','052024','CO','13930164','ALEXANDER','GARCIA AYALA','Calle 49 No. 1E-120 ciudadela ',' 3 3226635945','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','34000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:40:48','34000','351','BOD. FARMANORTE 351','4','8000','32000','32000','0','32000','0','4','170','','31/05/2024','',0,34000,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-31 08:40:48',  53223.5, 41855, 742, 372),('FVE','F351','023579','2024-05-31 08:40:48','052024','CO','13930164','ALEXANDER','GARCIA AYALA','Calle 49 No. 1E-120 ciudadela ',' 3 3226635945','3327','ALICIA REGINA','CARRASCAL POLO ','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','34000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:40:48','34000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','170','','31/05/2024','',0,34000,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 08:40:48',  1500, 44348, 742, 372),('FVE','F351','023580','2024-05-31 08:49:50','052024','CO','72255248','JHOBER','COLINA','',' 3128771430','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','16600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:49:50','16600','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','31/05/2024','',16600,0,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-05-31 08:49:50',  8380, 22278, 742, 372),('FVE','F351','023580','2024-05-31 08:49:50','052024','CO','72255248','JHOBER','COLINA','',' 3128771430','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','16600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:49:50','16600','351','BOD. FARMANORTE 351','1','7000','7000','7000','0','7000','1','0','0','','31/05/2024','',16600,0,0,'7702184010150','LOPERAMIDA 2 MG *6 TAB','249','ECAR','2024-05-31 08:49:50',  3400, 29743, 742, 372),('FVE','F351','023581','2024-05-31 08:59:47','052024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','20','21855','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:59:47','21855','351','BOD. FARMANORTE 351','4','1710','6840','6840','0','6840','0','4','109','','31/05/2024','',0,21855,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-31 08:59:47',  2500, 57400, 742, 372),('FVE','F351','023581','2024-05-31 08:59:47','052024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','20','21855','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:59:47','21855','351','BOD. FARMANORTE 351','5','483','2415','2415','0','2415','0','5','109','','31/05/2024','',0,21855,0,'7706569002853','METOCLOPRAMIDA 10MG *30 TAB','614','A.G. MEDICAMENTOS','2024-05-31 08:59:47',  11219, 31597, 742, 372),('FVE','F351','023581','2024-05-31 08:59:47','052024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','20','21855','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:59:47','21855','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','109','','31/05/2024','',0,21855,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-31 08:59:47',  28997, 54625, 742, 372),('FVE','F351','023581','2024-05-31 08:59:47','052024','CO','72270672','RICARDO ','CAMPO MART iacute NEZ ','',' 3004310912','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','20','21855','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 08:59:47','21855','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','109','','31/05/2024','',0,21855,0,'7501033961557','PEDIALYTE MAX ZINC 60 FRESA *500 ML','659','ABBOTT NUTRICION','2024-05-31 08:59:47',  8380, 55721, 742, 372),('FVE','F351','023582','2024-05-31 09:04:53','052024','CR','13515918','WILSON RUBIEL','RUEDA MARTINEZ','CALLE 47 NO.1C-76 CIUDADELA',' 3013508823','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','262503','1','2184.8739495798322','415.12605042016776','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 09:05:45','2600','351','BOD. FARMANORTE 351','1','2600','2600','2184.8739495798','415.12605042017','2600','1','0','0','','31/05/2024','',0,0,2600,'7702609006508','GASEOSA KOLA ROMAN *400 ML','144','COCA COLA','2024-05-31 09:04:53',  1544.4166, 35294, 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','023584','2024-05-31 09:13:03','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','3000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 09:13:03','3000','351','BOD. FARMANORTE 351','10','300','3000','3000','0','3000','0','10','0','','31/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-31 09:13:03',  28997, 54625, 742, 372),('FVE','F351','023585','2024-05-31 09:16:56','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','2184.8739495798322','415.12605042016776','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 09:16:56','2600','351','BOD. FARMANORTE 351','1','2600','2600','2184.8739495798','415.12605042017','2600','1','0','0','','31/05/2024','',2600,0,0,'7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-05-31 09:16:56',  1649.56, 52184, 742, 372),('FVE','F351','023586','2024-05-31 10:25:17','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','4','5200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 10:25:17','5200','351','BOD. FARMANORTE 351','4','1300','5200','5200','0','5200','0','4','0','','31/05/2024','',5200,0,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2024-05-31 10:25:17',  114652, 26533, 742, 372),('FVE','F351','023587','2024-05-31 10:52:40','052024','CO','28968108','NUBIA','CABEZA','',' N','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','25000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 10:52:41','25000','351','BOD. FARMANORTE 351','1','25000','25000','25000','0','25000','1','0','0','','31/05/2024','',25000,0,0,'7707141366165','TRAVAD ORAL *133 ML ','877','TECNOQUIMICAS VM TQ','2024-05-31 10:52:40',  22582.3, 43329, 742, 372),('FVE','F351','023588','2024-05-31 12:02:57','052024','CO','7412022','ANTONIO','JIMENES','',' 3114120706','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','40','12000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 12:02:57','12000','351','BOD. FARMANORTE 351','40','300','12000','12000','0','12000','0','40','0','','31/05/2024','',12000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-31 12:02:57',  28997, 54625, 742, 372),('FVE','F351','023589','2024-05-31 12:40:27','052024','CO','3771124','EDUARDO','ARIZA','bloque 172 apto 201',' 3116561358 3116561358','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','4','6476','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 12:40:27','6476','351','BOD. FARMANORTE 351','4','1619','6476','6476','0','6476','0','4','32','','31/05/2024','',6476,0,0,'7702626214849','STREPSILS INTENSIVE MIEL-LIMON *16 TAB','357','RECKITT BENCKISER COLOMBIA S A','2024-05-31 12:40:27',  20656, 53074, 742, 372),('FVE','F351','023590','2024-05-31 13:25:00','052024','CO','1143151155','JAINER','GALINDO','cra 1 sur 41 c 17     ciudadel',' 3024362409','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','41915.966386554624','7584.0336134453755','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 13:25:00','49500','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',0,49500,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 13:25:00',  1500, 44348, 742, 372),('FVE','F351','023590','2024-05-31 13:25:00','052024','CO','1143151155','JAINER','GALINDO','cra 1 sur 41 c 17     ciudadel',' 3024362409','3327','ALICIA REGINA','CARRASCAL POLO ','4146','ARGENIS HUMBERO','CHIRINOS VILLA','','','','','','2','41915.966386554624','7584.0336134453755','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 13:25:00','49500','351','BOD. FARMANORTE 351','1','47500','47500','39915.966386555','7584.0336134454','47500','1','0','0','10','31/05/2024','',0,49500,0,'7701021118868','WINNY PANTS ET6 XXG *30 UND','653','TECNOQUIMICAS WINNY','2024-05-31 13:25:00',  35898.3, 58101, 742, 372),('FVE','F351','023591','2024-05-31 13:34:39','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','6722.689075630252','1277.3109243697477','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 13:34:40','8000','351','BOD. FARMANORTE 351','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','31/05/2024','',8000,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-05-31 13:34:39',  1806, 56307, 742, 372),('FVE','F351','023591','2024-05-31 13:34:39','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','6722.689075630252','1277.3109243697477','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 13:34:40','8000','351','BOD. FARMANORTE 351','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','31/05/2024','',8000,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2024-05-31 13:34:39',  1190.721, 58852, 742, 372),('FVE','F351','023591','2024-05-31 13:34:39','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','6722.689075630252','1277.3109243697477','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 13:34:40','8000','351','BOD. FARMANORTE 351','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','31/05/2024','',8000,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2024-05-31 13:34:39',  1782, 54650, 742, 372),('FVE','F351','023592','2024-05-31 13:45:49','052024','CO','1044606650','ZHARICK','JIMENEZ CARDENAS ','',' 3042297094','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','15200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 13:45:49','15200','351','BOD. FARMANORTE 351','2','7600','15200','15200','0','15200','0','2','76','','31/05/2024','',0,15200,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-05-31 13:45:49',  63045, 31775, 742, 372),('FVE','F351','023593','2024-05-31 14:30:08','052024','CO','1042417873','NOHEMY','BORJA','CL 50 N 2 C 34 CARRIZAL APTO 2',' 3015497049','2644','CAROLINA','HERRERA BARROS','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','3','25700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 14:30:08','25700','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',25700,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 14:30:08',  1500, 44348, 742, 372),('FVE','F351','023593','2024-05-31 14:30:08','052024','CO','1042417873','NOHEMY','BORJA','CL 50 N 2 C 34 CARRIZAL APTO 2',' 3015497049','2644','CAROLINA','HERRERA BARROS','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','3','25700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 14:30:08','25700','351','BOD. FARMANORTE 351','1','23500','23500','23500','0','23500','1','0','0','','31/05/2024','',25700,0,0,'7707141350270','ENEMA TRAVAD FOSFATO RECTAL *133 ML','877','TECNOQUIMICAS VM TQ','2024-05-31 14:30:08',  14500, 42970, 742, 372),('FVE','F351','023593','2024-05-31 14:30:08','052024','CO','1042417873','NOHEMY','BORJA','CL 50 N 2 C 34 CARRIZAL APTO 2',' 3015497049','2644','CAROLINA','HERRERA BARROS','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','3','25700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 14:30:08','25700','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','31/05/2024','',25700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 14:30:08',  100, 44347, 742, 372),('FVE','F351','023594','2024-05-31 14:52:55','052024','CO','1143126998','EDUARDO ','QUIROGA','0',' 0 3002476905','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','19200','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 14:52:55','19200','351','BOD. FARMANORTE 351','1','19200','19200','19200','0','19200','1','0','0','','31/05/2024','',19200,0,0,'7703689000448','CYCLOFEM 0.5 ML AMP + JERINGA  ','344','PROFAMILIA','2024-05-31 14:52:55',  16550, 40547, 742, 372),('FVE','F351','023595','2024-05-31 15:04:50','052024','CO','1143142751','HOMEL','HERAZO','',' N','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','6','10600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 15:04:50','10600','351','BOD. FARMANORTE 351','2','2700','5400','5400','0','5400','0','2','0','','31/05/2024','',0,10600,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-05-31 15:04:50',  33370, 62346, 742, 372),('FVE','F351','023595','2024-05-31 15:04:50','052024','CO','1143142751','HOMEL','HERAZO','',' N','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','6','10600','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 15:04:50','10600','351','BOD. FARMANORTE 351','4','1300','5200','5200','0','5200','0','4','0','','31/05/2024','',0,10600,0,'7703546031608','CONGESTEX * 60 CAP  L-TR-CAPS','630','NOVAMED OTC','2024-05-31 15:04:50',  67353, 38541, 742, 372),('FVE','F351','023596','2024-05-31 15:11:05','052024','CO','72262107','ALEXANDER MAURICIO','PRECIADO GUZMAN','CRA 1 B - 47 D -21  ',' 3215690446','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','4900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 15:11:05','4900','351','BOD. FARMANORTE 351','1','4900','4900','4900','0','4900','1','0','25','','31/05/2024','',4900,0,0,'7707228362141','CINTA MICROPOROSA PIEL ALFASAFE 1 X 3 YD','429','ALFA SAFE','2024-05-31 15:11:05',  3036, 60552, 742, 372),('FVE','F351','023597','2024-05-31 15:21:32','052024','CO','1143140148','WILIAN  ','ARAUJO','',' 3022831123','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','72300','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 15:21:32','72300','351','BOD. FARMANORTE 351','1','72300','72300','72300','0','72300','1','0','362','10','31/05/2024','',72300,0,0,'7891000078969','NESTOGENO 2 *800 GR  ','311','NESTLE NUTRICION','2024-05-31 15:21:32',  66842, 38457, 742, 372),('FVE','F351','023598','2024-05-31 15:34:19','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','10588.235294117647','2011.7647058823532','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 15:34:19','12600','351','BOD. FARMANORTE 351','2','6300','12600','10588.235294118','2011.7647058824','12600','2','0','0','','31/05/2024','',12600,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-31 15:34:19',  3881.5, 56142, 742, 372),('FVE','F351','023599','2024-05-31 15:36:19','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','3420','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 15:36:19','3420','351','BOD. FARMANORTE 351','2','1710','3420','3420','0','3420','0','2','0','','31/05/2024','',3420,0,0,'7706462000000','NIMESULIDA 100 MG *10 TAB','938','FARMANAL','2024-05-31 15:36:19',  2500, 57400, 742, 372),('FVE','F351','023600','2024-05-31 16:02:56','052024','CO','1143444103','MARIA ','ARZUEGA','',' 3003453567','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','16900','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 16:02:56','16900','351','BOD. FARMANORTE 351','1','16900','16900','16900','0','16900','1','0','0','','31/05/2024','',0,16900,0,'7707274723224','BACTROSAFE 500 MG * 3 TAB','890','ALLEN PHARMA','2024-05-31 16:02:56',  12099, 58701, 742, 372),('FVE','F351','023601','2024-05-31 16:16:47','052024','CO','57415226','DALGYS','OLIVELLA','',' 0','2644','CAROLINA','HERRERA BARROS','','TERCERO','VARIOS','','','','','','1','12500','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 16:16:47','12500','351','BOD. FARMANORTE 351','1','12500','12500','12500','0','12500','1','0','0','','31/05/2024','',12500,0,0,'7703197053059','WASSERTROL SUSP OFTALMICA *5 ML  ','622','MK OFTALMOLOGICO CONVENIO','2024-05-31 16:16:47',  11900, 43398, 742, 372),('FVE','F351','023602','2024-05-31 16:41:56','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','1848.7394957983195','351.26050420168053','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 16:41:56','2200','351','BOD. FARMANORTE 351','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','31/05/2024','',2200,0,0,'7622201776664','TRIDENT MENTA *8.5 GR','754','DISCOB NORTE SAS','2024-05-31 16:41:56',  1050.4, 57675, 742, 372),('FVE','F351','023603','2024-05-31 16:47:12','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 16:47:12','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','1','0','','31/05/2024','',2000,0,0,'107703381000951','BUSCAPINA COMP N.F *100 TAB','772','OPELLA (SANOFI OTC)','2024-05-31 16:47:12',  161226.6, 23806, 742, 372),('FVE','F351','023604','2024-05-31 17:03:55','052024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','278184.0336134454','11415.966386554619','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:03:55','289600.00000000006','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','31/05/2024','',5.8207660913467E-11,289600,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 17:03:55',  100, 44347, 742, 372),('FVE','F351','023604','2024-05-31 17:03:55','052024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','278184.0336134454','11415.966386554619','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:03:55','289600.00000000006','351','BOD. FARMANORTE 351','1','16500','16500','13865.546218487','2634.4537815126','16500','1','0','0','','31/05/2024','',5.8207660913467E-11,289600,0,'7702031878452','JOHNSON CREMA PEINAR EXTR HUMECT HIDRAT INTENS *200 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-05-31 17:03:55',  11761, 28013, 742, 372),('FVE','F351','023604','2024-05-31 17:03:55','052024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','278184.0336134454','11415.966386554619','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:03:55','289600.00000000006','351','BOD. FARMANORTE 351','1','215900','215900','215900','0','215900','1','0','0','','31/05/2024','',5.8207660913467E-11,289600,0,'7703186031891','SIMILAC 2 5HMOS *1400 GR','659','ABBOTT NUTRICION','2024-05-31 17:03:55',  200740, 52579, 742, 372),('FVE','F351','023604','2024-05-31 17:03:55','052024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','278184.0336134454','11415.966386554619','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:03:55','289600.00000000006','351','BOD. FARMANORTE 351','1','55000','55000','46218.487394958','8781.512605042','55000','1','0','0','','31/05/2024','',5.8207660913467E-11,289600,0,'7701021111845','WINNY ULTRATRIM SEC ET3 *50 UND ','653','TECNOQUIMICAS WINNY','2024-05-31 17:03:55',  41579.1, 50913, 742, 372),('FVE','F351','023604','2024-05-31 17:03:55','052024','CO','1143140587','MARIO','MARTINEZ','calle 47 n 1 e - 120 ciudadela',' 3155890900','2644','CAROLINA','HERRERA BARROS','2155','KEVIN ANDRES','MOLINA MORENO','','','','','','5','278184.0336134454','11415.966386554619','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:03:55','289600.00000000006','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',5.8207660913467E-11,289600,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 17:03:55',  1500, 44348, 742, 372),('FVE','F351','023605','2024-05-31 17:09:31','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','4632.773109243697','367.2268907563025','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:09:31','5000','351','BOD. FARMANORTE 351','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','31/05/2024','',0,5000,0,'7702090031928','GASEOSA MANZANA POSTOBON *400 ML','192','POSTOBON GASEOSAS','2024-05-31 17:09:31',  1400.8, 40922, 742, 372),('FVE','F351','023605','2024-05-31 17:09:31','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','2','4632.773109243697','367.2268907563025','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:09:31','5000','351','BOD. FARMANORTE 351','1','2700','2700','2700','0','2700','0','1','0','','31/05/2024','',0,5000,0,'7702057840310','SAL DE FRUTAS LUA *50 SOBRES','382','TECNOQUIMICAS','2024-05-31 17:09:31',  105944.66, 43290, 742, 372),('FVE','F351','023606','2024-05-31 17:11:23','052024','CO','32748474','DARLYS','RODRIGUEZ','CLL 47 #1B1-11 CASA  AL FRENTE',' 3003351776','2644','CAROLINA','HERRERA BARROS','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','4','27700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:11:23','27700','351','BOD. FARMANORTE 351','1','200','200','200','0','200','1','0','0','','31/05/2024','',27700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 17:11:23',  100, 44347, 742, 372),('FVE','F351','023606','2024-05-31 17:11:23','052024','CO','32748474','DARLYS','RODRIGUEZ','CLL 47 #1B1-11 CASA  AL FRENTE',' 3003351776','2644','CAROLINA','HERRERA BARROS','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','4','27700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:11:23','27700','351','BOD. FARMANORTE 351','1','15900','15900','15900','0','15900','0','1','0','','31/05/2024','',27700,0,0,'7702771001561','ENTEROGERMINA PLUS *5 AMP','772','OPELLA (SANOFI OTC)','2024-05-31 17:11:23',  74092.5, 48571, 742, 372),('FVE','F351','023606','2024-05-31 17:11:23','052024','CO','32748474','DARLYS','RODRIGUEZ','CLL 47 #1B1-11 CASA  AL FRENTE',' 3003351776','2644','CAROLINA','HERRERA BARROS','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','4','27700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:11:23','27700','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',27700,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 17:11:23',  1500, 44348, 742, 372),('FVE','F351','023606','2024-05-31 17:11:23','052024','CO','32748474','DARLYS','RODRIGUEZ','CLL 47 #1B1-11 CASA  AL FRENTE',' 3003351776','2644','CAROLINA','HERRERA BARROS','3448','VICTOR MANUELL','CANTILLO DE LA HOZ','','','','','','4','27700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:11:23','27700','351','BOD. FARMANORTE 351','1','9600','9600','9600','0','9600','1','0','0','','31/05/2024','',27700,0,0,'7501033961540','PEDIALYTE MAX ZINC 60 COCO *500 ML','659','ABBOTT NUTRICION','2024-05-31 17:11:23',  8380, 55720, 742, 372),('FVE','F351','023607','2024-05-31 17:33:11','052024','CO','22741276','SALLY','MARENGO','',' 3184636547','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','1','9700','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:33:11','9700','351','BOD. FARMANORTE 351','1','9700','9700','9700','0','9700','1','0','0','','31/05/2024','',9700,0,0,'7702026149567','NOSOTRAS BUENAS NOCHES TELA *10 UND','337','FAMILIA SANCELA','2024-05-31 17:33:11',  8769, 40265, 742, 372),('FVE','F351','023608','2024-05-31 17:36:19','052024','CO','1044607446','OMAR','FONTALVO','',' 3216093140','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','10','9750','0','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:36:19','9750','351','BOD. FARMANORTE 351','10','975','9750','9750','0','9750','0','10','0','','31/05/2024','',9750,0,0,'7703283131036','VIBAZINA *40 TAB','326','PFIZER FARMA','2024-05-31 17:36:19',  36703, 39201, 742, 372),('FVE','F351','023609','2024-05-31 17:42:38','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3327','ALICIA REGINA','CARRASCAL POLO ','','TERCERO','VARIOS','','','','','','3','4521.008403361345','478.9915966386552','351','FARMANORTE 351','ADMINISTRADOR','2024-05-31 17:42:39','5000','351','BOD. FARMANORTE 351','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','31/05/2024','',5000,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2024-05-31 17:42:38',  1782, 54650, 742, 372);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '052024' AND DECODBOD='351';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '052024' AND DECODBOD='351';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '052024' AND DECODBOD='351';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '052024' AND DECODBOD='351';
