DELETE FROM consolida1 WHERE CODSUCURSAL = '351' AND (DVDIAOPE LIKE '%/08/2025' OR DDDIAOPE LIKE '%/08/2025');
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 , DOCUID) VALUES ('FVE','F351','058281','2025-07-31 21:26:41','072025','CO','55248278','GREY','MENDOZA','CRA 1 C  46 E 02   ',' 3017551839','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','4','188100','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:05:02','188100','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','188100','0','0','DO','DOMICILIO','00','VARIOS','2025-07-31 21:26:41',  0, 44348, 742, 372, 88286)
			   ,('FVE','F351','058281','2025-07-31 21:26:41','072025','CO','55248278','GREY','MENDOZA','CRA 1 C  46 E 02   ',' 3017551839','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','4','188100','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:05:02','188100','351','BOD. FARMANORTE 351','1','33400','33400','33400','0','33400','1','0','0','','01/08/2025','','188100','0','0','4048846001672','BERODUAL HFA AEROSOL * 10 ML ','134','BOEHRINGER INGELHEIM FARMA','2025-07-31 21:26:41',  33300, 23799, 742, 372, 88286)
			   ,('FVE','F351','058281','2025-07-31 21:26:41','072025','CO','55248278','GREY','MENDOZA','CRA 1 C  46 E 02   ',' 3017551839','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','4','188100','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:05:02','188100','351','BOD. FARMANORTE 351','1','76500','76500','76500','0','76500','1','0','0','','01/08/2025','','188100','0','0','7703546701501','PEPRED SOLUCION * 100 ML L-RESPI-ASM','314','NOVAMED FARMA','2025-07-31 21:26:41',  75750, 38598, 742, 372, 88286)
			   ,('FVE','F351','058281','2025-07-31 21:26:41','072025','CO','55248278','GREY','MENDOZA','CRA 1 C  46 E 02   ',' 3017551839','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','4','188100','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:05:02','188100','351','BOD. FARMANORTE 351','1','76200','76200','76200','0','76200','1','0','0','','01/08/2025','','188100','0','0','7702057012489','ALERFAST 30 MG/5 ML SUSP * 150 ML','877','TECNOQUIMICAS VM TQ','2025-07-31 21:26:41',  68100, 33575, 742, 372, 88286)
			   ,('FVE','F351','058282','2025-07-31 21:35:05','072025','CO','10019990927','MARIA','CARO','',' 1','2172','JOHELY','FORERO MORALES','','TERCERO','VARIOS','','','','','','3','11420.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:35:06','11500','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','0','1','0','','01/08/2025','','11500','0','0','7702896001231','DEXABLAS 8 MG * 5 AMP','132','BLASKOV','2025-07-31 21:35:05',  7548, 23704, 742, 372, 88287)
			   ,('FVE','F351','058282','2025-07-31 21:35:05','072025','CO','10019990927','MARIA','CARO','',' 1','2172','JOHELY','FORERO MORALES','','TERCERO','VARIOS','','','','','','3','11420.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:35:06','11500','351','BOD. FARMANORTE 351','1','6400','6400','6400','0','6400','0','1','0','','01/08/2025','','11500','0','0','7709990733716','NORIFLAM 75MG/3ML * 6 AMP','698','MED-LINE CONVENIO','2025-07-31 21:35:05',  14450, 48643, 742, 372, 88287)
			   ,('FVE','F351','058282','2025-07-31 21:35:05','072025','CO','10019990927','MARIA','CARO','',' 1','2172','JOHELY','FORERO MORALES','','TERCERO','VARIOS','','','','','','3','11420.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:35:06','11500','351','BOD. FARMANORTE 351','1','500','500','500','0','500','1','0','0','','01/08/2025','','11500','0','0','7707228361786','JERINGA 5 ML 21G * 1 1/2 HIPODERMICA','429','ALFA SAFE','2025-07-31 21:35:05',  162.45, 46100, 742, 372, 88287)
			   ,('FVE','F351','058283','2025-07-31 21:45:00','072025','CO','1143156328','YURLEIDYS','GONZALEZ','cra 4   50-45',' 3005515298','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','5','68245.3781512605','8539.621848739494','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:04:56','76785','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','01/08/2025','','0','76785','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-07-31 21:45:00',  0, 44347, 742, 372, 88288)
			   ,('FVE','F351','058283','2025-07-31 21:45:00','072025','CO','1143156328','YURLEIDYS','GONZALEZ','cra 4   50-45',' 3005515298','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','5','68245.3781512605','8539.621848739494','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:04:56','76785','351','BOD. FARMANORTE 351','1','40755','40755','34247.899159664','6507.1008403361','40755','1','0','0','','01/08/2025','','0','76785','0','7701021114006','WINNY ULTRATRIM SEC ET 4 * 30 UND ','653','TECNOQUIMICAS WINNY','2025-07-31 21:45:00',  32162.4, 43224, 742, 372, 88288)
			   ,('FVE','F351','058283','2025-07-31 21:45:00','072025','CO','1143156328','YURLEIDYS','GONZALEZ','cra 4   50-45',' 3005515298','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','5','68245.3781512605','8539.621848739494','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:04:56','76785','351','BOD. FARMANORTE 351','1','21000','21000','21000','0','21000','1','0','0','','01/08/2025','','0','76785','0','7701684055333','ALMIPRO UNG PARA LA PAÑALITIS * 60 GR','786','ALMIPRO','2025-07-31 21:45:00',  13034, 54469, 742, 372, 88288)
			   ,('FVE','F351','058283','2025-07-31 21:45:00','072025','CO','1143156328','YURLEIDYS','GONZALEZ','cra 4   50-45',' 3005515298','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','5','68245.3781512605','8539.621848739494','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:04:56','76785','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','0','76785','0','DO','DOMICILIO','00','VARIOS','2025-07-31 21:45:00',  0, 44348, 742, 372, 88288)
			   ,('FVE','F351','058283','2025-07-31 21:45:00','072025','CO','1143156328','YURLEIDYS','GONZALEZ','cra 4   50-45',' 3005515298','4943','JULIO CESAR','DE LOS REYES DA S','4127','MIKE MARK','MENDEZ MORALES','','','','','','5','68245.3781512605','8539.621848739494','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:04:56','76785','351','BOD. FARMANORTE 351','1','12730','12730','10697.478991597','2032.5210084034','12730','1','0','0','','01/08/2025','','0','76785','0','7701021145949','WINNY TOALLITAS ALOE VERA * 100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2025-07-31 21:45:00',  8750.7, 33273, 742, 372, 88288)
			   ,('FVE','F351','058284','2025-07-31 21:46:44','072025','CO','1020725415','DEINE','PE ntilde A','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','41070','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:46:44','41070','351','BOD. FARMANORTE 351','1','30970','30970','30970','0','30970','1','0','0','','01/08/2025','','0','41070','0','7702132009748','ADVIL CHILDREN * 100 ML ','616','HALEON (GLAXO OTC)','2025-07-31 21:46:44',  28233.117, 46798, 742, 372, 88289)
			   ,('FVE','F351','058284','2025-07-31 21:46:44','072025','CO','1020725415','DEINE','PE ntilde A','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','41070','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:46:44','41070','351','BOD. FARMANORTE 351','1','10100','10100','10100','0','10100','1','0','0','','01/08/2025','','0','41070','0','7501033957376','PEDIALYTE MAX ZINC 60 UVA * 500 ML','659','ABBOTT NUTRICION','2025-07-31 21:46:44',  8874, 22278, 742, 372, 88289)
			   ,('FVE','F351','058285','2025-07-31 21:52:54','072025','CO','1002210630','HENRY','RADA','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','105165','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:52:54','105165','351','BOD. FARMANORTE 351','1','48640','48640','48640','0','48640','1','0','0','','01/08/2025','','105165','0','0','7702024047612','KLIM 1+ BOLSA * 1000 GR','311','NESTLE NUTRICION','2025-07-31 21:52:54',  46827, 38366, 742, 372, 88290)
			   ,('FVE','F351','058285','2025-07-31 21:52:54','072025','CO','1002210630','HENRY','RADA','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','105165','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:52:54','105165','351','BOD. FARMANORTE 351','1','56525','56525','56525','0','56525','1','0','0','','01/08/2025','','105165','0','0','7501058631145','BABY KLIM 2 + LATA * 800 GR','311','NESTLE NUTRICION','2025-07-31 21:52:54',  55000, 51946, 742, 372, 88290)
			   ,('FVE','F351','058286','2025-07-31 21:57:13','072025','CO','1043000104','JULIO CESAR','DE LOS REYES DA S','CALLE 9 NO.20-24',' 3042754911','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','5293','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:57:14','5293','351','BOD. FARMANORTE 351','1','2900','2900','2900','0','2900','0','1','0','','01/08/2025','','2293','3000','0','7702057803292','GASTROFAST ADVANCE * 12 S/S','877','TECNOQUIMICAS VM TQ','2025-07-31 21:57:13',  28552, 59982, 742, 372, 88291)
			   ,('FVE','F351','058286','2025-07-31 21:57:13','072025','CO','1043000104','JULIO CESAR','DE LOS REYES DA S','CALLE 9 NO.20-24',' 3042754911','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','5293','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 21:57:14','5293','351','BOD. FARMANORTE 351','1','2393','2393','2393','0','2393','0','1','0','','01/08/2025','','2293','3000','0','7702626211770','GAVISCON DOBLE ACCION * 12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2025-07-31 21:57:13',  31508, 46776, 742, 372, 88291)
			   ,('FVE','F351','058287','2025-07-31 22:02:54','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','3','20657.14285714286','542.8571428571427','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:02:55','21200','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','01/08/2025','','0','21200','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-07-31 22:02:54',  0, 44347, 742, 372, 88293)
			   ,('FVE','F351','058287','2025-07-31 22:02:54','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','3','20657.14285714286','542.8571428571427','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:02:55','21200','351','BOD. FARMANORTE 351','1','17500','17500','17500','0','17500','1','0','0','','01/08/2025','','0','21200','0','7702870003589','POSTDAY * 1 TAB ','696','ABBOTT FARMA CONVENIO','2025-07-31 22:02:54',  11333.7225, 31697, 742, 372, 88293)
			   ,('FVE','F351','058287','2025-07-31 22:02:54','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','3','20657.14285714286','542.8571428571427','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:02:55','21200','351','BOD. FARMANORTE 351','1','3400','3400','2857.1428571429','542.85714285714','3400','1','0','0','','01/08/2025','','0','21200','0','7707133083216','HIT MORA * 500 ML','192','POSTOBON GASEOSAS','2025-07-31 22:02:54',  2000, 35520, 742, 372, 88293)
			   ,('FVE','F351','058288','2025-07-31 22:12:30','072025','CO','1001915543','RONNY ','OSPINO','',' 3001262686','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','1','14155','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:12:31','14155','351','BOD. FARMANORTE 351','1','14155','14155','14155','0','14155','1','0','0','','01/08/2025','','0','14155','0','7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA * 60 ML','616','HALEON (GLAXO OTC)','2025-07-31 22:12:30',  12896.334, 54127, 742, 372, 88294)
			   ,('FVE','F351','058289','2025-07-31 22:43:04','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','6','18836.81512605042','862.1848739495798','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:43:04','19699','351','BOD. FARMANORTE 351','1','8502.5','8502.5','8503','0','8503','1','0','0','','01/08/2025','','699','19000','0','7501125184864','ELECTROLIT MARACUYA * 625 ML','780','PISA (SUEROS LIQUIDOS)','2025-07-31 22:43:04',  7200, 54196, 742, 372, 88295)
			   ,('FVE','F351','058289','2025-07-31 22:43:04','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','6','18836.81512605042','862.1848739495798','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:43:04','19699','351','BOD. FARMANORTE 351','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','01/08/2025','','699','19000','0','7702192736455','GATORADE BLUE ICE * 500 ML','192','POSTOBON GASEOSAS','2025-07-31 22:43:04',  2785.7142, 63975, 742, 372, 88295)
			   ,('FVE','F351','058289','2025-07-31 22:43:04','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','6','18836.81512605042','862.1848739495798','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:43:04','19699','351','BOD. FARMANORTE 351','2','1948','3896','3896','0','3896','0','2','0','','01/08/2025','','699','19000','0','7702132008444','ADVIL ULTRA * 10 CAP','616','HALEON (GLAXO OTC)','2025-07-31 22:43:04',  17743.374, 39000, 742, 372, 88295)
			   ,('FVE','F351','058289','2025-07-31 22:43:04','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','6','18836.81512605042','862.1848739495798','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:43:04','19699','351','BOD. FARMANORTE 351','1','1900','1900','1900','0','1900','0','1','0','','01/08/2025','','699','19000','0','650240000010','X RAY DOL * 48 TAB','194','GENOMMA LABORATORIO COLOMBIA','2025-07-31 22:43:04',  67217.1831, 49672, 742, 372, 88295)
			   ,('FVE','F351','058289','2025-07-31 22:43:04','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','6','18836.81512605042','862.1848739495798','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 22:43:04','19699','351','BOD. FARMANORTE 351','1','800','800','672.26890756303','127.73109243697','800','1','0','0','','01/08/2025','','699','19000','0','7707228361793','JERINGA 10 ML * 21 G X 1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2025-07-31 22:43:04',  234.65, 46955, 742, 372, 88295)
			   ,('FVE','F351','058290','2025-07-31 23:04:33','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','11','12700','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 23:04:33','12700','351','BOD. FARMANORTE 351','1','8700','8700','8700','0','8700','1','0','0','','01/08/2025','','2500','10200','0','7707019341805','FINAPAR SUSP * 20 ML ','130','LABQUIFAR PHARMACEUTICA','2025-07-31 23:04:33',  3680.5, 23569, 742, 372, 88297)
			   ,('FVE','F351','058290','2025-07-31 23:04:33','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','11','12700','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 23:04:33','12700','351','BOD. FARMANORTE 351','10','400','4000','4000','0','4000','0','10','0','','01/08/2025','','2500','10200','0','7706569000415','LORATADINA 10 MG * 20 TAB','614','A.G. MEDICAMENTOS','2025-07-31 23:04:33',  2663, 31562, 742, 372, 88297)
			   ,('FVE','F351','058291','2025-07-31 23:42:43','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','5','41600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 23:42:43','41600','351','BOD. FARMANORTE 351','4','2300','9200','9200','0','9200','0','4','0','','01/08/2025','','3200','38400','0','7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2025-07-31 23:42:43',  72000, 55304, 742, 372, 88298)
			   ,('FVE','F351','058291','2025-07-31 23:42:43','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','5','41600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 23:42:43','41600','351','BOD. FARMANORTE 351','1','32400','32400','32400','0','32400','1','0','0','','01/08/2025','','3200','38400','0','7707274721619','FEVENY 0.625 MG * 28 TAB','181','FAES FARMA','2025-07-31 23:42:43',  28258, 23024, 742, 372, 88298)
			   ,('FVE','F351','058292','2025-07-31 23:52:54','072025','CO','1042241350','GISELLE','CAGUANA','Calle 51 c #3d93',' 3244255003','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','3','51600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 23:52:54','51600','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','01/08/2025','','0','51600','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-07-31 23:52:54',  0, 44347, 742, 372, 88299)
			   ,('FVE','F351','058292','2025-07-31 23:52:54','072025','CO','1042241350','GISELLE','CAGUANA','Calle 51 c #3d93',' 3244255003','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','3','51600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 23:52:54','51600','351','BOD. FARMANORTE 351','1','35150','35150','35150','0','35150','1','0','0','','01/08/2025','','0','51600','0','7703381000753','BISOLVON NINOS * 120 ML','772','OPELLA (SANOFI OTC)','2025-07-31 23:52:54',  30085.029, 23804, 742, 372, 88299)
			   ,('FVE','F351','058292','2025-07-31 23:52:54','072025','CO','1042241350','GISELLE','CAGUANA','Calle 51 c #3d93',' 3244255003','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','3','51600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-07-31 23:52:54','51600','351','BOD. FARMANORTE 351','1','16150','16150','16150','0','16150','1','0','0','','01/08/2025','','0','51600','0','7707172685778','DOLEX JARABE 2+ * 90 ML ','616','HALEON (GLAXO OTC)','2025-07-31 23:52:54',  14755.851, 26537, 742, 372, 88299)
			   ,('FVE','F351','058293','2025-08-01 00:01:27','072025','CO','22514594','JULIA','LEZCANO','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','16','42290.336134453784','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:01:28','42450','351','BOD. FARMANORTE 351','1','6400','6400','6400','0','6400','0','1','0','','01/08/2025','','42450','0','0','7709990733716','NORIFLAM 75MG/3ML * 6 AMP','698','MED-LINE CONVENIO','2025-08-01 00:01:27',  14450, 48643, 742, 372, 88300)
			   ,('FVE','F351','058293','2025-08-01 00:01:27','072025','CO','22514594','JULIA','LEZCANO','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','16','42290.336134453784','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:01:28','42450','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','0','1','0','','01/08/2025','','42450','0','0','7702896001231','DEXABLAS 8 MG * 5 AMP','132','BLASKOV','2025-08-01 00:01:27',  7548, 23704, 742, 372, 88300)
			   ,('FVE','F351','058293','2025-08-01 00:01:27','072025','CO','22514594','JULIA','LEZCANO','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','16','42290.336134453784','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:01:28','42450','351','BOD. FARMANORTE 351','6','2000','12000','12000','0','12000','0','6','0','','01/08/2025','','42450','0','0','7702057168056','NORAVER-P MENTA * 96 TAB','382','TECNOQUIMICAS','2025-08-01 00:01:27',  143090.81, 43182, 742, 372, 88300)
			   ,('FVE','F351','058293','2025-08-01 00:01:27','072025','CO','22514594','JULIA','LEZCANO','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','16','42290.336134453784','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:01:28','42450','351','BOD. FARMANORTE 351','5','1900','9500','9500','0','9500','0','5','0','','01/08/2025','','42450','0','0','7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2025-08-01 00:01:27',  59592, 43550, 742, 372, 88300)
			   ,('FVE','F351','058293','2025-08-01 00:01:27','072025','CO','22514594','JULIA','LEZCANO','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','16','42290.336134453784','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:01:28','42450','351','BOD. FARMANORTE 351','1','8950','8950','8950','0','8950','1','0','0','','01/08/2025','','42450','0','0','7501125184864','ELECTROLIT MARACUYA * 625 ML','780','PISA (SUEROS LIQUIDOS)','2025-08-01 00:01:27',  7200, 54196, 742, 372, 88300)
			   ,('FVE','F351','058293','2025-08-01 00:01:27','072025','CO','22514594','JULIA','LEZCANO','',' 1','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','16','42290.336134453784','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:01:28','42450','351','BOD. FARMANORTE 351','2','500','1000','840.33613445378','159.66386554622','1000','2','0','0','','01/08/2025','','42450','0','0','7707228361786','JERINGA 5 ML 21G * 1 1/2 HIPODERMICA','429','ALFA SAFE','2025-08-01 00:01:27',  162.45, 46100, 742, 372, 88300)
				  ,('FVE','F351','058294','2025-08-01 00:06:39','082025','CO','1042241350','GISELLE','CAGUANA','Calle 51 c #3d93',' 3244255003','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','7217.64705882353','782.3529411764703','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:06:39','8000','351','BOD. FARMANORTE 351','1','4900','4900','4117.6470588235','782.35294117647','4900','1','0','0','','01/08/2025','','2000','6000','0','7702535022061','JUGO DEL VALLE FRUTAS CITRICAS * 1.5 LT','144','COCA COLA','2025-08-01 00:06:39',  2678.583, 57040, 742, 372, 88301);
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 , DOCUID) VALUES ('FVE','F351','058294','2025-08-01 00:06:39','082025','CO','1042241350','GISELLE','CAGUANA','Calle 51 c #3d93',' 3244255003','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','7217.64705882353','782.3529411764703','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:06:39','8000','351','BOD. FARMANORTE 351','1','3100','3100','3100','0','3100','0','1','0','','01/08/2025','','2000','6000','0','7702870071502','LUMBAL FORTE * 36 TAB','633','ABBOTT CONSUMER HEALTH CARE','2025-08-01 00:06:39',  51999, 37241, 742, 372, 88301)
			   ,('FVE','F351','058295','2025-08-01 00:58:42','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','1','14621.8487394958','2778.1512605042008','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 00:58:42','17400','351','BOD. FARMANORTE 351','1','17400','17400','17400','0','17400','1','0','0','','01/08/2025','','17400','0','0','7707277580459','MULTI SOLUTER SOLUCION * 50 ML','124','BELLEZA EXPRESS SA','2025-08-01 00:58:42',  9400, 24819, 742, 372, 88302)
			   ,('FVE','F351','058296','2025-08-01 06:34:02','082025','CO','72216452','ROBERTO CARLOS','OROZCO MARTINEZ','1',' 3001916632','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','2','25350','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 06:34:03','25350','351','BOD. FARMANORTE 351','1','16400','16400','16400','0','16400','0','1','0','','01/08/2025','','25350','0','0','7702771001561','ENTEROGERMINA PLUS * 5 AMP','772','OPELLA (SANOFI OTC)','2025-08-01 06:34:02',  56783.511, 48571, 742, 372, 88303)
			   ,('FVE','F351','058296','2025-08-01 06:34:02','082025','CO','72216452','ROBERTO CARLOS','OROZCO MARTINEZ','1',' 3001916632','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','559443','8705771','COMAS YACOMELO LUIS CARLOS','','','2','25350','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 06:34:03','25350','351','BOD. FARMANORTE 351','1','8950','8950','8950','0','8950','1','0','0','','01/08/2025','','25350','0','0','7501125184864','ELECTROLIT MARACUYA * 625 ML','780','PISA (SUEROS LIQUIDOS)','2025-08-01 06:34:02',  7200, 54196, 742, 372, 88303)
			   ,('FVE','F351','058297','2025-08-01 06:38:39','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','5714.285714285715','1085.7142857142853','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 06:38:39','6800','351','BOD. FARMANORTE 351','1','3400','3400','2857.1428571429','542.85714285714','3400','1','0','0','','01/08/2025','','0','6800','0','7702090029864','HIT MANGO * 500 ML','192','POSTOBON GASEOSAS','2025-08-01 06:38:39',  2000, 35518, 742, 372, 88305)
			   ,('FVE','F351','058297','2025-08-01 06:38:39','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','5714.285714285715','1085.7142857142853','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 06:38:39','6800','351','BOD. FARMANORTE 351','1','3400','3400','2857.1428571429','542.85714285714','3400','1','0','0','','01/08/2025','','0','6800','0','7707133052670','HIT TROPICAL * 500 ML','192','POSTOBON GASEOSAS','2025-08-01 06:38:39',  2000, 35524, 742, 372, 88305)
			   ,('FVE','F351','058298','2025-08-01 06:55:01','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','4169.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 06:55:01','4473','351','BOD. FARMANORTE 351','1','1900','1900','1900','0','1900','1','0','0','','01/08/2025','','4473','0','0','7702007037197','CHOCOLATINA JUMBO MANI * 18 GR','816','GRUPO NUTRESA','2025-08-01 06:55:01',  1008.375, 53182, 742, 372, 88296)
			   ,('FVE','F351','058298','2025-08-01 06:55:01','072025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','4169.638655462185','303.36134453781506','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 06:55:01','4473','351','BOD. FARMANORTE 351','1','2573','2573','2573','0','2573','0','1','0','','01/08/2025','','4473','0','0','7707232095769','MIELTERTOS PASTILLAS MASTICABLES * 12 S/S','271','NATURAL FRESHLY','2025-08-01 06:55:01',  17652.33, 46200, 742, 372, 88296)
			   ,('FVE','F351','058299','2025-08-01 07:44:46','082025','CO','1005582247','OMAR','FERNANDEZ','',' 31478596 ','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','2','39800','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 07:44:46','39800','351','BOD. FARMANORTE 351','1','21900','21900','21900','0','21900','1','0','0','','01/08/2025','','39800','0','0','7703712080485','FARAMOX 250 * 60 ML /D20/','387','TRIDEX FARMACEUTICA','2025-08-01 07:44:46',  5700, 58878, 742, 372, 88309)
			   ,('FVE','F351','058299','2025-08-01 07:44:46','082025','CO','1005582247','OMAR','FERNANDEZ','',' 31478596 ','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','2','39800','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 07:44:46','39800','351','BOD. FARMANORTE 351','1','17900','17900','17900','0','17900','1','0','0','','01/08/2025','','39800','0','0','7703546033107','CRONOFEN L JBE * 100 ML  L-RESPI-RIN','1039','NOVAMED BABY ','2025-08-01 07:44:46',  15900, 43430, 742, 372, 88309)
			   ,('FVE','F351','058300','2025-08-01 08:03:52','082025','CO','1129523871','YUDY','SANTANA','CALLE 47 B  2 SUR -28',' 3017920371','3327','ALICIA REGINA','CARRASCAL POLO','2750','BILLY','NAVARRO','','','','','','3','110500','5700','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:25:36','116200','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','116200','0','0','DO','DOMICILIO','00','VARIOS','2025-08-01 08:03:52',  0, 44348, 742, 372, 88310)
			   ,('FVE','F351','058300','2025-08-01 08:03:52','082025','CO','1129523871','YUDY','SANTANA','CALLE 47 B  2 SUR -28',' 3017920371','3327','ALICIA REGINA','CARRASCAL POLO','2750','BILLY','NAVARRO','','','','','','3','110500','5700','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:25:36','116200','351','BOD. FARMANORTE 351','1','78500','78500','78500','0','78500','1','0','0','10','01/08/2025','','116200','0','0','7702001104017','ALPINA BABY ETP 2 * 800 GR','773','ALPINA BABY','2025-08-01 08:03:52',  60788.516448, 48240, 742, 372, 88310)
			   ,('FVE','F351','058300','2025-08-01 08:03:52','082025','CO','1129523871','YUDY','SANTANA','CALLE 47 B  2 SUR -28',' 3017920371','3327','ALICIA REGINA','CARRASCAL POLO','2750','BILLY','NAVARRO','','','','','','3','110500','5700','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:25:36','116200','351','BOD. FARMANORTE 351','1','35700','35700','30000','5700','35700','1','0','0','','01/08/2025','','116200','0','0','7701021111821','WINNY ULTRATRIM SEC ET 3 * 30 + 10 TOALLITAS','653','TECNOQUIMICAS WINNY','2025-08-01 08:03:52',  26695, 43221, 742, 372, 88310)
			   ,('FVE','F351','058301','2025-08-01 08:35:08','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','12600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 08:35:08','12600','351','BOD. FARMANORTE 351','1','12600','12600','12600','0','12600','0','1','0','','01/08/2025','','0','12600','0','7702870002049','EROXIM FAST 50 MG * 2 TAB','696','ABBOTT FARMA CONVENIO','2025-08-01 08:35:08',  14156.18, 31397, 742, 372, 88312)
			   ,('FVE','F351','058302','2025-08-01 08:52:22','082025','CO','41789969','JANET','MARTINEZ','',' 3013340874','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','7300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 08:52:22','7300','351','BOD. FARMANORTE 351','1','7300','7300','7300','0','7300','1','0','0','','01/08/2025','','7300','0','0','7707228365739','ESPARADRAPO TELA BLANCO 1 * 5 YD (2.5 * 450 CM)','429','ALFA SAFE','2025-08-01 08:52:22',  3657.5, 60549, 742, 372, 88314)
			   ,('FVE','F351','058303','2025-08-01 09:02:50','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','5700','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 09:02:50','5700','351','BOD. FARMANORTE 351','1','5700','5700','5700','0','5700','0','1','0','','01/08/2025','','5700','0','0','7500435107020','VICK VAPORUB 12 GR * 12 LATAS','820','PROCTER & GAMBLE CHC','2025-08-01 09:02:50',  55688.541399, 40253, 742, 372, 88311)
			   ,('FVE','F351','058304','2025-08-01 10:21:12','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','10','8000','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 10:21:12','8000','351','BOD. FARMANORTE 351','10','800','8000','8000','0','8000','0','10','0','','01/08/2025','','8000','0','0','7706569000026','AMOXICILINA 500 MG * 50 CAP','614','A.G. MEDICAMENTOS','2025-08-01 10:21:12',  35700, 31190, 742, 372, 88318)
			   ,('FVE','F351','058305','2025-08-01 10:25:17','082025','CO','1002025517','DALIS MILENA','CHAVEZ LOZANO','CRA 1  C 2   46  E  -  16   TE',' 3009484384','3327','ALICIA REGINA','CARRASCAL POLO','2750','BILLY','NAVARRO','','','','','','2','32000','5700','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:25:42','37700','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','0','37700','0','DO','DOMICILIO','00','VARIOS','2025-08-01 10:25:17',  0, 44348, 742, 372, 88315)
			   ,('FVE','F351','058305','2025-08-01 10:25:17','082025','CO','1002025517','DALIS MILENA','CHAVEZ LOZANO','CRA 1  C 2   46  E  -  16   TE',' 3009484384','3327','ALICIA REGINA','CARRASCAL POLO','2750','BILLY','NAVARRO','','','','','','2','32000','5700','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:25:42','37700','351','BOD. FARMANORTE 351','1','35700','35700','30000','5700','35700','1','0','0','10','01/08/2025','','0','37700','0','7701021111821','WINNY ULTRATRIM SEC ET 3 * 30 + 10 TOALLITAS','653','TECNOQUIMICAS WINNY','2025-08-01 10:25:17',  26695, 43221, 742, 372, 88315)
			   ,('FVE','F351','058306','2025-08-01 11:01:10','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','2200','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 11:01:10','2200','351','BOD. FARMANORTE 351','1','2200','2200','2200','0','2200','1','0','0','','01/08/2025','','2200','0','0','7709008052563','AGUA FARMANORTE * 600 ML','893','SALUS','2025-08-01 11:01:10',  939, 48019, 742, 372, 88316)
			   ,('FVE','F351','058307','2025-08-01 11:09:05','082025','CO','1143116829','GLELIA','FERNANDEZ','',' 3154522222','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','4','60779.83193277311','1820.1680672268903','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 11:09:05','62600','351','BOD. FARMANORTE 351','1','51200','51200','51200','0','51200','1','0','0','','01/08/2025','','62600','0','0','7702024047612','KLIM 1+ BOLSA * 1000 GR','311','NESTLE NUTRICION','2025-08-01 11:09:05',  46827, 38366, 742, 372, 88320)
			   ,('FVE','F351','058307','2025-08-01 11:09:05','082025','CO','1143116829','GLELIA','FERNANDEZ','',' 3154522222','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','4','60779.83193277311','1820.1680672268903','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 11:09:05','62600','351','BOD. FARMANORTE 351','3','3800','11400','9579.8319327731','1820.1680672269','11400','3','0','0','','01/08/2025','','62600','0','0','7702027472527','TENA SLIP CLASICO (ANTES BASIC) L *1 UND','337','FAMILIA SANCELA','2025-08-01 11:09:05',  2827.8, 40383, 742, 372, 88320)
			   ,('FVE','F351','058308','2025-08-01 11:43:38','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','15','10500','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 11:43:38','10500','351','BOD. FARMANORTE 351','15','700','10500','10500','0','10500','0','15','0','','01/08/2025','','0','10500','0','7703546012539','TENSOFAR 50 MG * 30 TAB L-CONSUM','630','NOVAMED OTC','2025-08-01 11:43:38',  3504.4, 49874, 742, 372, 88321)
			   ,('FVE','F351','058309','2025-08-01 12:00:52','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','3800','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 12:00:52','3800','351','BOD. FARMANORTE 351','1','3800','3800','3800','0','3800','1','0','0','','01/08/2025','','3800','0','0','7702560026577','ALCOHOL JGB *120 ML','219','JGB','2025-08-01 12:00:52',  2529, 27762, 742, 372, 88323)
			   ,('FVE','F351','058310','2025-08-01 12:33:33','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','4900','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 12:33:33','4900','351','BOD. FARMANORTE 351','1','4900','4900','4900','0','4900','1','0','0','','01/08/2025','','4900','0','0','7707228362141','CINTA MICROPOROSA PIEL 1 * 3 YD (2.5 * 270 CM)','429','ALFA SAFE','2025-08-01 12:33:33',  2884.2, 60552, 742, 372, 88322)
			   ,('FVE','F351','058311','2025-08-01 12:43:51','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','3','10500','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 12:43:51','10500','351','BOD. FARMANORTE 351','3','3500','10500','10500','0','10500','0','3','0','','01/08/2025','','10500','0','0','7702123005513','APRONAX 550 MG * 60 TAB','631','BAYER OTC','2025-08-01 12:43:51',  150000, 46716, 742, 372, 88326)
			   ,('FVE','F351','058312','2025-08-01 12:44:15','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','2','3600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 12:44:15','3600','351','BOD. FARMANORTE 351','2','1800','3600','3600','0','3600','0','2','0','','01/08/2025','','3600','0','0','7707397791636','DOLEX FORTE * 100 TAB','616','HALEON (GLAXO OTC)','2025-08-01 12:44:15',  184000, 63445, 742, 372, 88327)
			   ,('FVE','F351','058313','2025-08-01 12:53:19','082025','CO','1045724992','YEFER ','SUEREZ','bloque  178  aprt  301',' 3243241616','3327','ALICIA REGINA','CARRASCAL POLO','2750','BILLY','NAVARRO','','','','','','2','20403.361344537814','3496.638655462186','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:25:52','23900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','0','23900','0','DO','DOMICILIO','00','VARIOS','2025-08-01 12:53:19',  0, 44348, 742, 372, 88328)
			   ,('FVE','F351','058313','2025-08-01 12:53:19','082025','CO','1045724992','YEFER ','SUEREZ','bloque  178  aprt  301',' 3243241616','3327','ALICIA REGINA','CARRASCAL POLO','2750','BILLY','NAVARRO','','','','','','2','20403.361344537814','3496.638655462186','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:25:52','23900','351','BOD. FARMANORTE 351','1','21900','21900','18403.361344538','3496.6386554622','21900','1','0','0','','01/08/2025','','0','23900','0','7613035652583','NESTUM ARROZ *350 GR','311','NESTLE NUTRICION','2025-08-01 12:53:19',  18487.395, 52292, 742, 372, 88328)
			   ,('FVE','F351','058314','2025-08-01 13:16:53','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','18200','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 13:16:53','18200','351','BOD. FARMANORTE 351','1','18200','18200','18200','0','18200','1','0','0','','01/08/2025','','18200','0','0','7702132009977','TODAY MUTUAL SENSATION * 3 PRESERVATIVOS  ','616','HALEON (GLAXO OTC)','2025-08-01 13:16:53',  11493.2466297, 48067, 742, 372, 88334)
			   ,('FVE','F351','058315','2025-08-01 13:27:46','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','2','5294.117647058823','1005.8823529411761','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 13:27:47','6300','351','BOD. FARMANORTE 351','1','3500','3500','3500','0','3500','1','0','0','','01/08/2025','','6300','0','0','7702402054898','TOSH BARRA HELADA FRESA * 75 GR','296','MEALS DE COLOMBIA','2025-08-01 13:27:46',  1805.1995, 58218, 742, 372, 88335)
			   ,('FVE','F351','058315','2025-08-01 13:27:46','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','2','5294.117647058823','1005.8823529411761','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 13:27:47','6300','351','BOD. FARMANORTE 351','1','2800','2800','2800','0','2800','1','0','0','','01/08/2025','','6300','0','0','7702402059121','HELADO CASERO RON CON PASAS * 60 GR','296','MEALS DE COLOMBIA','2025-08-01 13:27:46',  1663.256, 52362, 742, 372, 88335)
			   ,('FVE','F351','058316','2025-08-01 13:42:59','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','3109.2436974789916','590.7563025210084','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 13:43:00','3700','351','BOD. FARMANORTE 351','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','01/08/2025','','0','3700','0','7702026031329','PEQUEÑIN PAÑOS HUMEDOS ALMENDRA * 24 UND','337','FAMILIA SANCELA','2025-08-01 13:42:59',  2476.8, 44961, 742, 372, 88337)
			   ,('FVE','F351','058317','2025-08-01 13:58:37','082025','CO','1063146588','SANDRA MARCELA','BALLESTEROS JULIO','cra 1a4 n 47b frente al colegi',' 3018727275','4943','JULIO CESAR','DE LOS REYES DA S','2750','BILLY','NAVARRO','','','','','','2','35300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:26:02','35300','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','177','','01/08/2025','','0','35300','0','DO','DOMICILIO','00','VARIOS','2025-08-01 13:58:37',  0, 44348, 742, 372, 88339)
			   ,('FVE','F351','058317','2025-08-01 13:58:37','082025','CO','1063146588','SANDRA MARCELA','BALLESTEROS JULIO','cra 1a4 n 47b frente al colegi',' 3018727275','4943','JULIO CESAR','DE LOS REYES DA S','2750','BILLY','NAVARRO','','','','','','2','35300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:26:02','35300','351','BOD. FARMANORTE 351','1','33300','33300','33300','0','33300','1','0','177','','01/08/2025','','0','35300','0','7501058631138','BABY KLIM 2 + LATA * 400 GR','311','NESTLE NUTRICION','2025-08-01 13:58:37',  30940, 51304, 742, 372, 88339)
			   ,('FVE','F351','058318','2025-08-01 14:00:00','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','1848.7394957983195','351.26050420168053','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:00:00','2200','351','BOD. FARMANORTE 351','1','2200','2200','2200','0','2200','1','0','0','','01/08/2025','','2200','0','0','7702402043359,7','PALETA ALOHA AGUA LIMON * 65 GR','296','MEALS DE COLOMBIA','2025-08-01 14:00:00',  1162.2892, 32692, 742, 372, 88340)
			   ,('FVE','F351','058319','2025-08-01 14:16:45','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','1260.5042016806724','239.4957983193276','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:16:45','1500','351','BOD. FARMANORTE 351','1','1500','1500','1500','0','1500','1','0','0','','01/08/2025','','1500','0','0','7702090039627','AGUA H2O LIMA-LIMON BOTELLA * 250 ML','192','POSTOBON GASEOSAS','2025-08-01 14:16:45',  928.57, 49161, 742, 372, 88338)
			   ,('FVE','F351','058320','2025-08-01 14:31:08','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','1200','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 14:31:08','1200','351','BOD. FARMANORTE 351','1','1200','1200','1200','0','1200','1','0','0','','01/08/2025','','1200','0','0','7702090037784','AGUA CRISTAL CON GAS BOTELLA * 300 ML','192','POSTOBON GASEOSAS','2025-08-01 14:31:08',  630, 52915, 742, 372, 88342)
			   ,('FVE','F351','058321','2025-08-01 15:21:46','082025','CO','1129511692','JHON FREDDY ','LEGARDA KLEVER ','calle 46 h # 1 c - 30',' 3246372368','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','59500','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 15:21:47','59500','351','BOD. FARMANORTE 351','1','59500','59500','59500','0','59500','1','0','298','10','01/08/2025','','59500','0','0','7501058631145','BABY KLIM 2 + LATA * 800 GR','311','NESTLE NUTRICION','2025-08-01 15:21:46',  54970, 51946, 742, 372, 88346)
			   ,('FVE','F351','058322','2025-08-01 15:27:19','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','5','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 15:27:19','11300','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','01/08/2025','','11300','0','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-08-01 15:27:19',  0, 44347, 742, 372, 88341)
				  ,('FVE','F351','058322','2025-08-01 15:27:19','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','5','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 15:27:19','11300','351','BOD. FARMANORTE 351','2','1000','2000','2000','0','2000','2','0','0','','01/08/2025','','11300','0','0','7707228361489','GASA ESTERIL NO TEJIDA 7.5 CM * 7.5 CM * 6 UND ','429','ALFA SAFE','2025-08-01 15:27:19',  475, 58629, 742, 372, 88341);
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 , DOCUID) VALUES ('FVE','F351','058322','2025-08-01 15:27:19','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','5','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 15:27:19','11300','351','BOD. FARMANORTE 351','2','4500','9000','9000','0','9000','2','0','0','','01/08/2025','','11300','0','0','7702136648943','CUREBAND MICROPORE PIEL 1/2 * 10 YARDAS','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-08-01 15:27:19',  3554.23, 45305, 742, 372, 88341)
			   ,('FVE','F351','058323','2025-08-01 15:32:39','082025','CO','7501125176531','ELI','MENDEZ','',' 0 3154522222','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','8950','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 15:32:39','8950','351','BOD. FARMANORTE 351','1','8950','8950','8950','0','8950','1','0','0','','01/08/2025','','8950','0','0','7501125149221','ELECTROLIT FRESA-KIWI SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2025-08-01 15:32:39',  7200, 33981, 742, 372, 88348)
			   ,('FVE','F351','058324','2025-08-01 15:33:23','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','2016.8067226890757','383.19327731092426','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 15:33:23','2400','351','BOD. FARMANORTE 351','1','2400','2400','2400','0','2400','1','0','0','','01/08/2025','','2400','0','0','7702402057844','PALETA CHOCOLISTO COOKIES & CREAM * 60 GR ','296','MEALS DE COLOMBIA','2025-08-01 15:33:23',  1468.66, 62382, 742, 372, 88349)
			   ,('FVE','F351','058325','2025-08-01 16:09:07','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','2352.9411764705883','447.0588235294117','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 16:09:07','2800','351','BOD. FARMANORTE 351','1','2800','2800','2800','0','2800','1','0','0','','01/08/2025','','2800','0','0','7702402059121','HELADO CASERO RON CON PASAS * 60 GR','296','MEALS DE COLOMBIA','2025-08-01 16:09:07',  1663.256, 52362, 742, 372, 88351)
			   ,('FVE','F351','058326','2025-08-01 16:17:45','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','2941.1764705882356','558.8235294117644','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 16:17:46','3500','351','BOD. FARMANORTE 351','1','3500','3500','3500','0','3500','1','0','0','','01/08/2025','','3500','0','0','6910021007206','COLGATE CEPILLO PREMIER CLEAN MEDIO','145','COLGATE PALMOLIVE COMPANIA','2025-08-01 16:17:45',  2038.8189, 47117, 742, 372, 88345)
			   ,('FVE','F351','058327','2025-08-01 16:18:20','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','3109.2436974789916','590.7563025210084','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 16:18:21','3700','351','BOD. FARMANORTE 351','1','3700','3700','3700','0','3700','1','0','0','','01/08/2025','','3700','0','0','7702402054416','CHOCOCONO * 90 GR','296','MEALS DE COLOMBIA','2025-08-01 16:18:20',  2125.538, 56307, 742, 372, 88353)
			   ,('FVE','F351','058328','2025-08-01 16:51:11','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 16:51:11','4600','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','1','0','0','','01/08/2025','','4600','0','0','7702192422051','GATORADE TROPICAL FRUIT * 500 ML','192','POSTOBON GASEOSAS','2025-08-01 16:51:11',  2507.1425, 25826, 742, 372, 88355)
			   ,('FVE','F351','058329','2025-08-01 16:58:56','082025','CO','1042429767','RODOLFO','CERVANTES','Cra 8b sur #46 79 Parque pituf',' 3217531231','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','3','89500','11400','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 16:58:56','100900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','0','100900','0','DO','DOMICILIO','00','VARIOS','2025-08-01 16:58:56',  0, 44348, 742, 372, 88354)
			   ,('FVE','F351','058329','2025-08-01 16:58:56','082025','CO','1042429767','RODOLFO','CERVANTES','Cra 8b sur #46 79 Parque pituf',' 3217531231','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','3','89500','11400','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 16:58:56','100900','351','BOD. FARMANORTE 351','1','27500','27500','27500','0','27500','1','0','0','','01/08/2025','','0','100900','0','7707351597106','MUCOFAN JARABE * 120 ML','1000','NATURALMENTE','2025-08-01 16:58:56',  5500, 34303, 742, 372, 88354)
			   ,('FVE','F351','058329','2025-08-01 16:58:56','082025','CO','1042429767','RODOLFO','CERVANTES','Cra 8b sur #46 79 Parque pituf',' 3217531231','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','3','89500','11400','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 16:58:56','100900','351','BOD. FARMANORTE 351','1','71400','71400','60000','11400','71400','1','0','0','','01/08/2025','','0','100900','0','7701021117786','WINNY PANTS ET4 XG * 50 UND','653','TECNOQUIMICAS WINNY','2025-08-01 16:58:56',  53600.4, 56587, 742, 372, 88354)
			   ,('FVE','F351','058330','2025-08-01 17:06:31','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','100554.6218487395','3145.378151260502','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:06:31','103700','351','BOD. FARMANORTE 351','1','42900','42900','42900','0','42900','1','0','0','','01/08/2025','','103700','0','0','7702024185635','KLIM CLASICA FORTIFICADA * 840 GR','776','NESTLE FOOD & BEVERAGE','2025-08-01 17:06:31',  36462, 57204, 742, 372, 88347)
			   ,('FVE','F351','058330','2025-08-01 17:06:31','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','100554.6218487395','3145.378151260502','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:06:31','103700','351','BOD. FARMANORTE 351','1','19700','19700','16554.621848739','3145.3781512605','19700','1','0','0','','01/08/2025','','103700','0','0','7702057082130','YODORA CREMA * 32 GR * 2 PRECIO ESPECIAL','889','TECNOQUIMICAS CONSUMO','2025-08-01 17:06:31',  12874.59, 42931, 742, 372, 88347)
			   ,('FVE','F351','058330','2025-08-01 17:06:31','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','100554.6218487395','3145.378151260502','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:06:31','103700','351','BOD. FARMANORTE 351','1','20500','20500','20500','0','20500','1','0','0','','01/08/2025','','103700','0','0','7707263006406','CEVIT NF CEREZA * 30 ML /D18/','387','TRIDEX FARMACEUTICA','2025-08-01 17:06:31',  7600, 60894, 742, 372, 88347)
			   ,('FVE','F351','058330','2025-08-01 17:06:31','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','100554.6218487395','3145.378151260502','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:06:31','103700','351','BOD. FARMANORTE 351','1','20600','20600','20600','0','20600','1','0','0','','01/08/2025','','103700','0','0','7590002012468','VICK VAPORUB *50 GR','820','PROCTER & GAMBLE CHC','2025-08-01 17:06:31',  14767.1538, 40254, 742, 372, 88347)
			   ,('FVE','F351','058331','2025-08-01 17:21:24','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','6900','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:21:25','6900','351','BOD. FARMANORTE 351','1','6900','6900','6900','0','6900','1','0','0','','01/08/2025','','0','6900','0','7706569001276','SILDENAFIL 50 MG * 2 TAB','614','A.G. MEDICAMENTOS','2025-08-01 17:21:24',  2364.075, 31766, 742, 372, 88358)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','01/08/2025','','77350','0','0','7702402058858','GALLETA CON HELADO NAPOLITANO * 65 GR','296','MEALS DE COLOMBIA','2025-08-01 17:32:28',  1960, 60339, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','2800','2800','2352.9411764706','447.05882352941','2800','1','0','0','','01/08/2025','','77350','0','0','7702402059091','HELADO CASERO COCO * 60 GR','296','MEALS DE COLOMBIA','2025-08-01 17:32:28',  1472, 50688, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','01/08/2025','','77350','0','0','7702402043359,7','PALETA ALOHA AGUA LIMON * 65 GR','296','MEALS DE COLOMBIA','2025-08-01 17:32:28',  1293, 32692, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','01/08/2025','','77350','0','0','7702402054324','PALETA ALOHA MANGO BICHE *65 GR CON LIMON Y SAL','296','MEALS DE COLOMBIA','2025-08-01 17:32:28',  1693, 56104, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','2600','2600','2184.8739495798','415.12605042017','2600','1','0','0','','01/08/2025','','77350','0','0','7702402058292','PALETA KIDS NUBE COLORIDA * 50 GR','296','MEALS DE COLOMBIA','2025-08-01 17:32:28',  1277, 64033, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','13000','13000','10924.369747899','2075.6302521008','13000','1','0','0','','01/08/2025','','77350','0','0','0724373709079','FULLREADY * 60 ML','916','BIOZENPHARMA','2025-08-01 17:32:28',  5600, 60600, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','7600','7600','6386.5546218487','1213.4453781513','7600','1','0','0','','01/08/2025','','77350','0','0','7702535024423','COCA COLA * 1.5 LT','144','COCA COLA','2025-08-01 17:32:28',  4120, 56142, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','01/08/2025','','77350','0','0','77082381','COCA COLA ZERO * 250 ML','144','COCA COLA','2025-08-01 17:32:28',  1031, 34412, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','2400','2400','2400','0','2400','1','0','0','','01/08/2025','','77350','0','0','7702027434020','NOSOTRAS DIARIOS * 15 UND','337','FAMILIA SANCELA','2025-08-01 17:32:28',  1426, 40279, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','2800','2800','2352.9411764706','447.05882352941','2800','1','0','0','','01/08/2025','','77350','0','0','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2025-08-01 17:32:28',  1816, 54241, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','3400','3400','2857.1428571429','542.85714285714','3400','1','0','0','','01/08/2025','','77350','0','0','7702027479472','TENA SLIP CLASICO (ANTES BASIC) M * 1 UND ','337','FAMILIA SANCELA','2025-08-01 17:32:28',  2401, 40591, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','5100','5100','4285.7142857143','814.28571428571','5100','1','0','0','','01/08/2025','','77350','0','0','7702189059932','DETODITO BBQ * 80 GR ','762','FRITO LAY','2025-08-01 17:32:28',  2648, 65746, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','8000','8000','6722.6890756303','1277.3109243697','8000','1','0','0','','01/08/2025','','77350','0','0','041333431482','DURACELL AAA * 2 UND','194','GENOMMA LABORATORIO COLOMBIA','2025-08-01 17:32:28',  3194, 44379, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','1000','1000','840.33613445378','159.66386554622','1000','1','0','0','','01/08/2025','','77350','0','0','D1002','RECOLECTOR DE ORINA TAPA AZUL','1058','GRAN ANDINA','2025-08-01 17:32:28',  207, 39236, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','3200','3200','3200','0','3200','1','0','0','','01/08/2025','','77350','0','0','7702090020847','GASEOSA BRETANA * 300 ML','192','POSTOBON GASEOSAS','2025-08-01 17:32:28',  2149, 35287, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','01/08/2025','','77350','0','0','7702090032031','GASEOSA KOLA * 400 ML','192','POSTOBON GASEOSAS','2025-08-01 17:32:28',  1815, 25798, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','01/08/2025','','77350','0','0','7702090031942','GASEOSA UVA * 400 ML','192','POSTOBON GASEOSAS','2025-08-01 17:32:28',  1769, 25814, 742, 372, 88360)
			   ,('COT','F351','01420','2025-08-01 17:32:28','082025','CO','1042448800','ALICIA REGINA','CARRASCAL POLO','CRA 19 NO.63-39',' 3015525860','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','18','67323.10924369749','10026.890756302517','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:47:30','77350','351','BOD. FARMANORTE 351','1','8950','8950','8950','0','8950','1','0','0','','01/08/2025','','77350','0','0','7501125184864','ELECTROLIT MARACUYA * 625 ML','780','PISA (SUEROS LIQUIDOS)','2025-08-01 17:32:28',  7200, 54196, 742, 372, 88360)
			   ,('FVE','F351','058332','2025-08-01 17:46:52','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','2200','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:46:52','2200','351','BOD. FARMANORTE 351','1','2200','2200','2200','0','2200','1','0','0','','01/08/2025','','2200','0','0','7709008052563','AGUA FARMANORTE * 600 ML','893','SALUS','2025-08-01 17:46:52',  939, 48019, 742, 372, 88359)
			   ,('FVE','F351','058333','2025-08-01 17:52:35','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','1848.7394957983195','351.26050420168053','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:52:35','2200','351','BOD. FARMANORTE 351','1','2200','2200','2200','0','2200','1','0','0','','01/08/2025','','2200','0','0','7702189057884','CHEETOS TRISSITOS PICANTES * 34 GR','762','FRITO LAY','2025-08-01 17:52:35',  1304, 60824, 742, 372, 88361)
			   ,('FVE','F351','058334','2025-08-01 17:58:59','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','8433.613445378152','766.3865546218485','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:58:59','9200','351','BOD. FARMANORTE 351','2','2200','4400','4400','0','4400','0','2','0','','01/08/2025','','9200','0','0','7702057092757','IBUFLASH MIGRAN * 30 CAP','382','TECNOQUIMICAS','2025-08-01 17:58:59',  50677.65, 58898, 742, 372, 88363)
			   ,('FVE','F351','058334','2025-08-01 17:58:59','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','8433.613445378152','766.3865546218485','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 17:58:59','9200','351','BOD. FARMANORTE 351','2','2400','4800','4800','0','4800','2','0','0','','01/08/2025','','9200','0','0','7702402057844','PALETA CHOCOLISTO COOKIES & CREAM * 60 GR ','296','MEALS DE COLOMBIA','2025-08-01 17:58:59',  1468.66, 62382, 742, 372, 88363)
			   ,('FVE','F351','058335','2025-08-01 18:13:34','082025','CO','52960152','MARIA','CALVO','BLOQUE 113 APT 201',' 3016207491','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','5','26900','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:13:34','26900','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','0','26900','0','DO','DOMICILIO','00','VARIOS','2025-08-01 18:13:34',  0, 44348, 742, 372, 88364)
			   ,('FVE','F351','058335','2025-08-01 18:13:34','082025','CO','52960152','MARIA','CALVO','BLOQUE 113 APT 201',' 3016207491','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','5','26900','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:13:34','26900','351','BOD. FARMANORTE 351','3','8200','24600','24600','0','24600','0','3','0','','01/08/2025','','0','26900','0','3582910009900','ENTEROGERMINA * 10 AMP','772','OPELLA (SANOFI OTC)','2025-08-01 18:13:34',  54055.2138228, 41855, 742, 372, 88364)
			   ,('FVE','F351','058335','2025-08-01 18:13:34','082025','CO','52960152','MARIA','CALVO','BLOQUE 113 APT 201',' 3016207491','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','5','26900','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:13:34','26900','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','01/08/2025','','0','26900','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-08-01 18:13:34',  0, 44347, 742, 372, 88364)
				  ,('FVE','F351','058336','2025-08-01 18:21:19','082025','CO','32772194','CLAUDIA','DIAZ','CRA 46  H   1-17  APART 2',' 3002938473','3327','ALICIA REGINA','CARRASCAL POLO','','','','','','','','','2','26705.88235294118','4694.117647058822','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:21:19','31400','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','0','31400','0','DO','DOMICILIO','00','VARIOS','2025-08-01 18:21:19',  0, 44348, 742, 372, 88352);
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 , DOCUID) VALUES ('FVE','F351','058336','2025-08-01 18:21:19','082025','CO','32772194','CLAUDIA','DIAZ','CRA 46  H   1-17  APART 2',' 3002938473','3327','ALICIA REGINA','CARRASCAL POLO','','','','','','','','','2','26705.88235294118','4694.117647058822','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:21:19','31400','351','BOD. FARMANORTE 351','1','29400','29400','24705.882352941','4694.1176470588','29400','1','0','0','','01/08/2025','','0','31400','0','7703332003178','ALERGIBON AVENA * 90 GR ','365','MEGALABS','2025-08-01 18:21:19',  26470.59, 42037, 742, 372, 88352)
			   ,('FVE','F351','058337','2025-08-01 18:31:01','082025','CO','1044611334','DANIELA','HERRERA','CALLE 51 C 3 B 76  CARRIZAL',' 3015281849','3327','ALICIA REGINA','CARRASCAL POLO','','','','','','','','','2','51915.966386554624','9484.033613445376','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:31:02','61400','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','01/08/2025','','0','61400','0','DO','DOMICILIO','00','VARIOS','2025-08-01 18:31:01',  0, 44348, 742, 372, 88357)
			   ,('FVE','F351','058337','2025-08-01 18:31:01','082025','CO','1044611334','DANIELA','HERRERA','CALLE 51 C 3 B 76  CARRIZAL',' 3015281849','3327','ALICIA REGINA','CARRASCAL POLO','','','','','','','','','2','51915.966386554624','9484.033613445376','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:31:02','61400','351','BOD. FARMANORTE 351','1','59400','59400','49915.966386555','9484.0336134454','59400','1','0','0','','01/08/2025','','0','61400','0','7770947094112','CITRATO DE MAGNESIO * 100 DISCOS MASTICABLES','1000','NATURALMENTE','2025-08-01 18:31:01',  21280, 64116, 742, 372, 88357)
			   ,('FVE','F351','058338','2025-08-01 18:48:36','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','18500','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:48:36','18500','351','BOD. FARMANORTE 351','1','18500','18500','18500','0','18500','1','0','0','','01/08/2025','','18500','0','0','7702184530023','ATLETICS GEL * 60 GR ','249','ECAR','2025-08-01 18:48:36',  6589.0063, 58868, 742, 372, 88362)
			   ,('FVE','F351','058339','2025-08-01 18:49:56','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','8950','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 18:49:56','8950','351','BOD. FARMANORTE 351','1','8950','8950','8950','0','8950','1','0','0','','01/08/2025','','0','8950','0','7501125184864','ELECTROLIT MARACUYA * 625 ML','780','PISA (SUEROS LIQUIDOS)','2025-08-01 18:49:56',  7200, 54196, 742, 372, 88367)
			   ,('FVE','F351','058340','2025-08-01 19:17:40','082025','CO','1045682771','MELQUISEDEC ','LARA VILLAMIZAR ','cra 1d n 46e38',' 3046394238','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','1','66218.48739495799','12581.512605042008','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:17:40','78800','351','BOD. FARMANORTE 351','1','78800','78800','66218.487394958','12581.512605042','78800','1','0','331','','02/08/2025','','0','78800','0','7701021117908','WINNY PANTS ET5 XXG * 50 UND','653','TECNOQUIMICAS WINNY','2025-08-01 19:17:40',  58843.8, 56752, 742, 372, 88373)
			   ,('FVE','F351','058341','2025-08-01 19:18:14','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3327','ALICIA REGINA','CARRASCAL POLO','','TERCERO','VARIOS','','','','','','2','16400','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:18:14','16400','351','BOD. FARMANORTE 351','2','8200','16400','16400','0','16400','0','2','0','','02/08/2025','','16400','0','0','3582910009900','ENTEROGERMINA * 10 AMP','772','OPELLA (SANOFI OTC)','2025-08-01 19:18:14',  54055.2138228, 41855, 742, 372, 88374)
			   ,('FVE','F351','058342','2025-08-01 19:20:03','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:20:03','2500','351','BOD. FARMANORTE 351','1','2500','2500','2500','0','2500','1','0','0','','02/08/2025','','2500','0','0','7702402059275','PALETA CHOCOLISTO * 50 GR','296','MEALS DE COLOMBIA','2025-08-01 19:20:03',  1468.66, 55601, 742, 372, 88376)
			   ,('FVE','F351','058343','2025-08-01 19:25:09','082025','CO','1079654656','MARIA JOSE ','MOVILLA ESCORCIA ','bloque 169 apto 401',' 3105099702','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','7500','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:25:10','7500','351','BOD. FARMANORTE 351','1','7500','7500','7500','0','7500','1','0','38','','02/08/2025','','7500','0','0','7702184020258','CLORFENIRAMINA JBE * 120 ML','249','ECAR','2025-08-01 19:25:09',  3208.1844666667, 48626, 742, 372, 88378)
			   ,('FVE','F351','058344','2025-08-01 19:25:55','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:25:55','500','351','BOD. FARMANORTE 351','1','500','500','500','0','500','1','0','0','','02/08/2025','','500','0','0','7707228361786','JERINGA 5 ML 21G * 1 1/2 HIPODERMICA','429','ALFA SAFE','2025-08-01 19:25:55',  162.45, 46100, 742, 372, 88379)
			   ,('FVE','F351','058345','2025-08-01 19:27:13','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','8320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:27:13','8400','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','02/08/2025','','8400','0','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-08-01 19:27:13',  0, 44347, 742, 372, 88380)
			   ,('FVE','F351','058345','2025-08-01 19:27:13','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','8320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:27:13','8400','351','BOD. FARMANORTE 351','1','500','500','500','0','500','1','0','0','','02/08/2025','','8400','0','0','7707282990274','JERINGA 5ML DESECHABLE  21G * 1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2025-08-01 19:27:13',  159.6, 58667, 742, 372, 88380)
			   ,('FVE','F351','058345','2025-08-01 19:27:13','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','8320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:27:13','8400','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','0','1','0','','02/08/2025','','8400','0','0','7702896001231','DEXABLAS 8 MG * 5 AMP','132','BLASKOV','2025-08-01 19:27:13',  7548, 23704, 742, 372, 88380)
			   ,('FVE','F351','058345','2025-08-01 19:27:13','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','4','8320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:27:13','8400','351','BOD. FARMANORTE 351','1','3000','3000','3000','0','3000','0','1','0','','02/08/2025','','8400','0','0','7702626211770','GAVISCON DOBLE ACCION * 12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2025-08-01 19:27:13',  31508, 46776, 742, 372, 88380)
			   ,('FVE','F351','058346','2025-08-01 19:33:34','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','1','7300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:33:35','7300','351','BOD. FARMANORTE 351','1','7300','7300','7300','0','7300','1','0','0','','02/08/2025','','7300','0','0','7707228365739','ESPARADRAPO TELA BLANCO 1 * 5 YD (2.5 * 450 CM)','429','ALFA SAFE','2025-08-01 19:33:34',  3657.5, 60549, 742, 372, 88381)
			   ,('FVE','F351','058347','2025-08-01 19:40:24','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','3','5320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:40:24','5400','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','02/08/2025','','5400','0','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-08-01 19:40:24',  0, 44347, 742, 372, 88382)
			   ,('FVE','F351','058347','2025-08-01 19:40:24','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','3','5320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:40:24','5400','351','BOD. FARMANORTE 351','1','4600','4600','4600','0','4600','0','1','0','','02/08/2025','','5400','0','0','7702896001231','DEXABLAS 8 MG * 5 AMP','132','BLASKOV','2025-08-01 19:40:24',  7548, 23704, 742, 372, 88382)
			   ,('FVE','F351','058347','2025-08-01 19:40:24','082025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','4943','JULIO CESAR','DE LOS REYES DA S','','TERCERO','VARIOS','','','','','','3','5320.16806722689','79.8319327731092','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:40:24','5400','351','BOD. FARMANORTE 351','1','500','500','500','0','500','1','0','0','','02/08/2025','','5400','0','0','7707282990274','JERINGA 5ML DESECHABLE  21G * 1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2025-08-01 19:40:24',  159.6, 58667, 742, 372, 88382)
			   ,('FVE','F351','058348','2025-08-01 19:43:52','082025','CO','1192782670','YUBISAY','PARDO','bloque 34  piso 3  aprt 301',' 3018097606','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','6','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:43:52','11300','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','0','','02/08/2025','','0','11300','0','DO','DOMICILIO','00','VARIOS','2025-08-01 19:43:52',  0, 44348, 742, 372, 88383)
			   ,('FVE','F351','058348','2025-08-01 19:43:52','082025','CO','1192782670','YUBISAY','PARDO','bloque 34  piso 3  aprt 301',' 3018097606','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','6','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:43:52','11300','351','BOD. FARMANORTE 351','1','5000','5000','5000','0','5000','1','0','0','','02/08/2025','','0','11300','0','7706659500146','AGUA OXIGENADA * 120 ML','143','COASPHARMA SAS','2025-08-01 19:43:52',  2896.731925, 49419, 742, 372, 88383)
			   ,('FVE','F351','058348','2025-08-01 19:43:52','082025','CO','1192782670','YUBISAY','PARDO','bloque 34  piso 3  aprt 301',' 3018097606','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','6','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:43:52','11300','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','02/08/2025','','0','11300','0','7702136646628','CURITAS CURE BAND *10 UNID  ','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-08-01 19:43:52',  1423.58, 42905, 742, 372, 88383)
			   ,('FVE','F351','058348','2025-08-01 19:43:52','082025','CO','1192782670','YUBISAY','PARDO','bloque 34  piso 3  aprt 301',' 3018097606','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','6','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:43:52','11300','351','BOD. FARMANORTE 351','2','1000','2000','2000','0','2000','2','0','0','','02/08/2025','','0','11300','0','7707228361489','GASA ESTERIL NO TEJIDA 7.5 CM * 7.5 CM * 6 UND ','429','ALFA SAFE','2025-08-01 19:43:52',  475, 58629, 742, 372, 88383)
			   ,('FVE','F351','058348','2025-08-01 19:43:52','082025','CO','1192782670','YUBISAY','PARDO','bloque 34  piso 3  aprt 301',' 3018097606','4943','JULIO CESAR','DE LOS REYES DA S','','','','','','','','','6','11300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:43:52','11300','351','BOD. FARMANORTE 351','1','300','300','300','0','300','1','0','0','','02/08/2025','','0','11300','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-08-01 19:43:52',  0, 44347, 742, 372, 88383)
			   ,('FVE','F351','058349','2025-08-01 19:57:14','082025','CO','7959185','ILARIOS','DE LEON','',' 3222222222','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','1','79100','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 19:57:14','79100','351','BOD. FARMANORTE 351','1','79100','79100','79100','0','79100','1','0','0','','02/08/2025','','79100','0','0','8427030004549','ENSURE ADVANCE VAINILA * 400 GR','659','ABBOTT NUTRICION','2025-08-01 19:57:14',  71241, 22225, 742, 372, 88384)
			   ,('FVE','F351','058350','2025-08-01 20:20:15','082025','CO','1002212445','NADIR','DEL RIO','F',' 3015721981','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','198700','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:20:15','198700','351','BOD. FARMANORTE 351','1','87900','87900','87900','0','87900','1','0','0','','02/08/2025','','0','198700','0','7702870070772','GYNFLU D 75MG/1000 MG * 4 TAB','619','ABBOTT FARMA','2025-08-01 20:20:15',  77285, 31480, 742, 372, 88386)
			   ,('FVE','F351','058350','2025-08-01 20:20:15','082025','CO','1002212445','NADIR','DEL RIO','F',' 3015721981','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','198700','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:20:15','198700','351','BOD. FARMANORTE 351','1','110800','110800','110800','0','110800','1','0','0','','02/08/2025','','0','198700','0','7703153024321','VAXIDUO * 5 OVULOS  ','334','PROCAPS OTX','2025-08-01 20:20:15',  79900, 39919, 742, 372, 88386)
			   ,('FVE','F351','058351','2025-08-01 20:23:42','082025','CO','1065999125','ANA JUDITH ','MARTINEZ PACHECO ','',' 3028542275','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','44100','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:23:43','44100','351','BOD. FARMANORTE 351','1','9400','9400','9400','0','9400','1','0','221','','02/08/2025','','0','44100','0','7706569000088','CIPROFLOXACINO 500 MG * 10 TAB','614','A.G. MEDICAMENTOS','2025-08-01 20:23:42',  4013.37, 31300, 742, 372, 88387)
			   ,('FVE','F351','058351','2025-08-01 20:23:42','082025','CO','1065999125','ANA JUDITH ','MARTINEZ PACHECO ','',' 3028542275','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','44100','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:23:43','44100','351','BOD. FARMANORTE 351','1','34700','34700','34700','0','34700','1','0','221','','02/08/2025','','0','44100','0','7707263007755','CLINDABACT 100/100MG * 3 OVULOS /D24/','387','TRIDEX FARMACEUTICA','2025-08-01 20:23:42',  10523.076923077, 59529, 742, 372, 88387)
			   ,('FVE','F351','058352','2025-08-01 20:33:19','082025','CO','1129570411','emily johana ','perez','Carrera 4B sur #47C 27 ',' 3107804712','2175','NINI JOHANA','ALBOR VARGAS','','','','','','','','','17','19600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:33:19','19600','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','0','0','1','','02/08/2025','','19600','0','0','DO','DOMICILIO','00','VARIOS','2025-08-01 20:33:19',  0, 44348, 742, 372, 88385)
			   ,('FVE','F351','058352','2025-08-01 20:33:19','082025','CO','1129570411','emily johana ','perez','Carrera 4B sur #47C 27 ',' 3107804712','2175','NINI JOHANA','ALBOR VARGAS','','','','','','','','','17','19600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:33:19','19600','351','BOD. FARMANORTE 351','1','7100','7100','7100','0','7100','1','0','1','','02/08/2025','','19600','0','0','7702057033262','HIDROCLOROTIAZIDA 12.5 MG * 30 TAB','654','MK ETICOS CONVENIO','2025-08-01 20:33:19',  5600, 37329, 742, 372, 88385)
			   ,('FVE','F351','058352','2025-08-01 20:33:19','082025','CO','1129570411','emily johana ','perez','Carrera 4B sur #47C 27 ',' 3107804712','2175','NINI JOHANA','ALBOR VARGAS','','','','','','','','','17','19600','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:33:19','19600','351','BOD. FARMANORTE 351','15','700','10500','10500','0','10500','0','15','1','','02/08/2025','','19600','0','0','7706569021618','LOSARTAN 50 MG * 30 TAB','614','A.G. MEDICAMENTOS','2025-08-01 20:33:19',  9451, 31567, 742, 372, 88385)
			   ,('FVE','F351','058353','2025-08-01 20:49:29','082025','CO','1129514626','MARIO ','AHUMADA','',' 3111111111','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','1','59500','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:49:29','59500','351','BOD. FARMANORTE 351','1','59500','59500','59500','0','59500','1','0','0','15','02/08/2025','','59500','0','0','7501058631145','BABY KLIM 2 + LATA * 800 GR','311','NESTLE NUTRICION','2025-08-01 20:49:29',  54970, 51946, 742, 372, 88388)
			   ,('FVE','F351','058354','2025-08-01 20:50:09','082025','CO','1002213615','GERALDIN','CRESPO','',' 3012745943','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','28300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:50:10','28300','351','BOD. FARMANORTE 351','1','10800','10800','10800','0','10800','1','0','0','','02/08/2025','','0','28300','0','7702870071526','FACETIX SUAVE * 28 TAB','619','ABBOTT FARMA','2025-08-01 20:50:09',  8609.72, 25109, 742, 372, 88389)
			   ,('FVE','F351','058354','2025-08-01 20:50:09','082025','CO','1002213615','GERALDIN','CRESPO','',' 3012745943','2175','NINI JOHANA','ALBOR VARGAS','','TERCERO','VARIOS','','','','','','2','28300','0','351','FARMANORTE 351','ADMINISTRADOR','2025-08-01 20:50:10','28300','351','BOD. FARMANORTE 351','1','17500','17500','17500','0','17500','1','0','0','','02/08/2025','','0','28300','0','7702870003589','POSTDAY * 1 TAB ','696','ABBOTT FARMA CONVENIO','2025-08-01 20:50:09',  11333.7225, 31697, 742, 372, 88389);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '082025' AND DECODBOD='351';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '082025' AND DECODBOD='351';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '082025' AND DECODBOD='351';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '082025' AND DECODBOD='351';
DELETE FROM consolida2 WHERE PERIODOESPE = '082025' AND CODSUCURSAL = '351';
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2172','JOHELY FORERO MORALES','7702896001231','DEXABLAS 8 MG * 5 AMP','1','4600','10','460','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2172','JOHELY FORERO MORALES','7709990733716','NORIFLAM 75MG/3ML * 6 AMP','1','6400','10','640','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7702870003589','POSTDAY * 1 TAB ','1','17500','8','1400','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7707019341805','FINAPAR SUSP * 20 ML ','1','8700','12','1044','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7706569000415','LORATADINA 10 MG * 20 TAB','10','4000','10','400','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','4','9200','8','736','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7709990733716','NORIFLAM 75MG/3ML * 6 AMP','1','6400','10','640','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7702896001231','DEXABLAS 8 MG * 5 AMP','1','4600','10','460','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7707263003474','GRIPAC * 100 CAP /D20/','5','9500','15','1425','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','2175','NINI JOHANA ALBOR VARGAS','7707232095769','MIELTERTOS PASTILLAS MASTICABLES * 12 S/S','1','2573','10','257.3','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7703712080485','FARAMOX 250 * 60 ML /D20/','1','21900','15','3285','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7703546033107','CRONOFEN L JBE * 100 ML  L-RESPI-RIN','1','17900','8','1432','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7702870002049','EROXIM FAST 50 MG * 2 TAB','1','12600','10','1260','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7706569000026','AMOXICILINA 500 MG * 50 CAP','10','8000','10','800','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7709008052563','AGUA FARMANORTE * 600 ML','1','2200','5','110','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7703546012539','TENSOFAR 50 MG * 30 TAB L-CONSUM','15','10500','8','840','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','4943','JULIO CESAR DE LOS REYES DA S','7707351597106','MUCOFAN JARABE * 120 ML','1','27500','10','2750','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','4943','JULIO CESAR DE LOS REYES DA S','7707263006406','CEVIT NF CEREZA * 30 ML /D18/','1','20500','15','3075','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','4943','JULIO CESAR DE LOS REYES DA S','7706569001276','SILDENAFIL 50 MG * 2 TAB','1','6900','10','690','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7709008052563','AGUA FARMANORTE * 600 ML','1','2200','5','110','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','3327','ALICIA REGINA CARRASCAL POLO','7770947094112','CITRATO DE MAGNESIO * 100 DISCOS MASTICABLES','1','49915.966386555','10','4991.596638655501','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('082025','2025-08-01','4943','JULIO CESAR DE LOS REYES DA S','7702184530023','ATLETICS GEL * 60 GR ','1','18500','10','1850','351','FARMANORTE 351','');
