DELETE FROM consolida1 WHERE CODSUCURSAL = '351' AND (DVDIAOPE LIKE '%/06/2023' OR DDDIAOPE LIKE '%/06/2023');
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','000001','2023-06-29 18:11:23','062023','CO','1129488173','YOLIMAR ','VENAVIDES  ','calle 46g  1C3 -18  CIUDADELA ','  3006265594','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','12','52370','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 18:11:23','52370','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','0','0','','30/06/2023','',52370,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 18:11:23',  1000, 44347, 742, 372, 3)
			   ,('FVE','F351','000001','2023-06-29 18:11:23','062023','CO','1129488173','YOLIMAR ','VENAVIDES  ','calle 46g  1C3 -18  CIUDADELA ','  3006265594','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','12','52370','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 18:11:23','52370','351','BOD. FARMANORTE 351','1','31600','31600','31600','0','31600','1','0','0','','30/06/2023','',52370,0,0,'7707232095608','MIELTERTOS ADULTOS *240 ML     ','271','NATURAL FRESHLY','2023-06-29 18:11:23',  19930.05, 30328, 742, 372, 3)
			   ,('FVE','F351','000001','2023-06-29 18:11:23','062023','CO','1129488173','YOLIMAR ','VENAVIDES  ','calle 46g  1C3 -18  CIUDADELA ','  3006265594','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','12','52370','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 18:11:23','52370','351','BOD. FARMANORTE 351','10','2067','20670','20670','0','20670','0','10','0','','30/06/2023','',52370,0,0,'7703153031251','TRIMEBUTINA+SIMETICONA 200MG/120MG CJA * 30 TB','422','COLMED','2023-06-29 18:11:23',  42806, 54483, 742, 372, 3)
			   ,('FVE','F351','000002','2023-06-29 18:22:19','062023','CO','8689341','JERMANDO ','MARTINNES VERGARA','',' 0','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','1','5500','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 18:22:19','5500','351','BOD. FARMANORTE 351','1','5500','5500','5500','0','5500','1','0','0','','30/06/2023','',5500,0,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2023-06-29 18:22:19',  2900, 48626, 742, 372, 4)
			   ,('FVE','F351','000003','2023-06-29 18:57:07','062023','CO','1151474597','ANDRIUS ','ARIAS ','',' 1 ','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','11428.57142857143','2171.4285714285706','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 18:57:07','13600','351','BOD. FARMANORTE 351','1','13600','13600','11428.571428571','2171.4285714286','13600','1','0','0','','30/06/2023','',13600,0,0,'036600814013','CHAPSTICK FRESA *4.2 GR','616','HALEON (GLAXO OTC)','2023-06-29 18:57:07',  10980.0974, 39041, 742, 372, 5)
			   ,('FVE','F351','000004','2023-06-29 18:59:08','062023','CO','72151680','RICARDO MANUEL ','LEO WETTE','',' 0','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','4','6668','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 18:59:09','6668','351','BOD. FARMANORTE 351','4','1667','6668','6668','0','6668','0','4','0','','30/06/2023','',6668,0,0,'650240028199','X RAY DOL *12 TAB','194','GENOMMA LABORATORIO COLOMBIA','2023-06-29 18:59:08',  17052.8, 49673, 742, 372, 2)
			   ,('FVE','F351','000005','2023-06-29 19:49:07','062023','CO','12181620','HILDA','NAVARRO','',' 3138913820 ','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','10','2500','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 19:49:07','2500','351','BOD. FARMANORTE 351','10','250','2500','2500','0','2500','0','10','0','','30/06/2023','',2500,0,0,'7702184010280','TIAMINA 300 MG *250 TAB','249','ECAR','2023-06-29 19:49:07',  27300, 29762, 742, 372, 7)
			   ,('FVE','F351','000006','2023-06-29 20:26:43','062023','CO','1129515067','DANY','CHARRIS','CALLE 45 F N 1 C36 PISO 2',' 3103821188','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','3','18000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:26:43','18000','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,18000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 20:26:43',  1000, 44347, 742, 372, 16)
			   ,('FVE','F351','000006','2023-06-29 20:26:43','062023','CO','1129515067','DANY','CHARRIS','CALLE 45 F N 1 C36 PISO 2',' 3103821188','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','3','18000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:26:43','18000','351','BOD. FARMANORTE 351','1','7400','7400','7400','0','7400','1','0','0','','30/06/2023','',0,18000,0,'7703712034679','HIDROCORTISONA CREMA 1% *15 GR COASPHARMA','143','COASPHARMA SAS','2023-06-29 20:26:43',  1040, 24310, 742, 372, 16)
			   ,('FVE','F351','000006','2023-06-29 20:26:43','062023','CO','1129515067','DANY','CHARRIS','CALLE 45 F N 1 C36 PISO 2',' 3103821188','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','3','18000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:26:43','18000','351','BOD. FARMANORTE 351','1','10500','10500','10500','0','10500','1','0','0','','30/06/2023','',0,18000,0,'7706569001269','CLOTRIMAZOL CREMA TOPICA *40 GR','614','A.G. MEDICAMENTOS','2023-06-29 20:26:43',  7803, 31314, 742, 372, 16)
			   ,('COT','F351','00003','2023-06-29 20:38:37','062023','CO','32660838','MIRIAM','DE LA HOZ','CALLE 416 K 1 C 82',' 3174442083','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','4','260700','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:42:04','260700','351','BOD. FARMANORTE 351','1','36400','36400','36400','0','36400','1','0','0','','30/06/2023','',260700,0,0,'7707288820155','MESALAZINA 500 MG X 30 TABLS HUMAX','205','HUMAX PHARMACEUTICAL','2023-06-29 20:38:37',  30450, 27365, 742, 372, 21)
			   ,('COT','F351','00003','2023-06-29 20:38:37','062023','CO','32660838','MIRIAM','DE LA HOZ','CALLE 416 K 1 C 82',' 3174442083','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','4','260700','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:42:04','260700','351','BOD. FARMANORTE 351','1','85800','85800','85800','0','85800','1','0','0','','30/06/2023','',260700,0,0,'7703454920568','BEDOYECTA *3 JERINGAS PRELLENADAS','205','HUMAX PHARMACEUTICAL','2023-06-29 20:38:37',  82272.6, 25533, 742, 372, 21)
			   ,('COT','F351','00003','2023-06-29 20:38:37','062023','CO','32660838','MIRIAM','DE LA HOZ','CALLE 416 K 1 C 82',' 3174442083','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','4','260700','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:42:04','260700','351','BOD. FARMANORTE 351','1','106500','106500','106500','0','106500','1','0','0','','30/06/2023','',260700,0,0,'7501298220185','NEUROBION DC *3 JERINGAS PRELLENADAS','820','PROCTER & GAMBLE CHC','2023-06-29 20:38:37',  89023.2, 32976, 742, 372, 21)
			   ,('COT','F351','00003','2023-06-29 20:38:37','062023','CO','32660838','MIRIAM','DE LA HOZ','CALLE 416 K 1 C 82',' 3174442083','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','4','260700','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:42:04','260700','351','BOD. FARMANORTE 351','1','32000','32000','32000','0','32000','1','0','0','','30/06/2023','',260700,0,0,'7707232096964','VENASFULL MAX FORTE CJA * 30 CAPS NATURAL F.','271','NATURAL FRESHLY','2023-06-29 20:38:37',  25830, 46221, 742, 372, 21)
			   ,('FVE','F351','000007','2023-06-29 20:44:29','062023','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','1','6000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:44:29','6000','351','BOD. FARMANORTE 351','1','6000','6000','6000','0','6000','1','0','0','','30/06/2023','',6000,0,0,'7707019340105','FINAPAR X 2 TABLS','130','LABQUIFAR PHARMACEUTICA','2023-06-29 20:44:29',  1100, 23570, 742, 372, 18)
			   ,('FVE','F351','000008','2023-06-29 20:55:14','062023','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','2','21600','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:55:14','21600','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','0','0','','30/06/2023','',21600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 20:55:14',  1000, 44347, 742, 372, 19)
			   ,('FVE','F351','000008','2023-06-29 20:55:14','062023','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','2','21600','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 20:55:14','21600','351','BOD. FARMANORTE 351','1','21500','21500','21500','0','21500','1','0','0','','30/06/2023','',21600,0,0,'7702418004696','CEBION GOTAS NARANJA *30 ML','820','PROCTER & GAMBLE CHC','2023-06-29 20:55:14',  18800.32, 32886, 742, 372, 19)
			   ,('FVE','F351','000009','2023-06-29 21:02:56','062023','CO','32782690','YANELIS ','MANGA PEREZ ','CARRERA 1C2 # 46E --45  ','  3004007740','2098','AURA ESTHER','JIMENEZ PARRA','1871','MIGUEL ANGEL','PINO GIL','','','','','','2','24529.411764705885','4470.588235294115','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 21:02:56','29000','351','BOD. FARMANORTE 351','1','28000','28000','23529.411764706','4470.5882352941','28000','1','0','0','','30/06/2023','',0,29000,0,'7702277074410','COLONIA ARRURRU ROSADA *220 ML ','124','BELLEZA EXPRESS SA','2023-06-29 21:02:56',  17340, 45395, 742, 372, 17)
			   ,('FVE','F351','000009','2023-06-29 21:02:56','062023','CO','32782690','YANELIS ','MANGA PEREZ ','CARRERA 1C2 # 46E --45  ','  3004007740','2098','AURA ESTHER','JIMENEZ PARRA','1871','MIGUEL ANGEL','PINO GIL','','','','','','2','24529.411764705885','4470.588235294115','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 21:02:56','29000','351','BOD. FARMANORTE 351','1','1000','1000','1000','0','1000','1','0','0','','30/06/2023','',0,29000,0,'DO','DOMICILIO','00','VARIOS','2023-06-29 21:02:56',  500, 44348, 742, 372, 17)
			   ,('FVE','F351','000010','2023-06-29 21:06:40','062023','CO','8485512','ISMAEL','ARIAS','CUIDADELA 20 DE JULIO',' 3006350654','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','10','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 21:06:40','2000','351','BOD. FARMANORTE 351','10','200','2000','2000','0','2000','0','10','0','','30/06/2023','',2000,0,0,'7706569020659','ACETAMINOFEN 500MG *100 TAB','614','A.G. MEDICAMENTOS','2023-06-29 21:06:40',  12768, 31151, 742, 372, 24)
			   ,('FVE','F351','000011','2023-06-29 22:37:33','062023','CO','11476935396','OSCAR','NU ntilde EZ','N',' 3017846346','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','1','13300','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 22:37:33','13300','351','BOD. FARMANORTE 351','1','13300','13300','13300','0','13300','1','0','0','','30/06/2023','',13300,0,0,'7707210530572','SIMPIOX GOTAS *5 ML  ','256','GERCO','2023-06-29 22:37:33',  7089, 29858, 742, 372, 27)
			   ,('FVE','F351','000012','2023-06-29 22:42:58','062023','CO','25544588','JORGE','COLMENARES','N',' 3011082255','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','2','2900','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 22:42:58','2900','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','1','0','','30/06/2023','',2900,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 22:42:58',  1000, 44347, 742, 372, 29)
			   ,('FVE','F351','000012','2023-06-29 22:42:58','062023','CO','25544588','JORGE','COLMENARES','N',' 3011082255','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','2','2900','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 22:42:58','2900','351','BOD. FARMANORTE 351','1','2800','2800','2800','0','2800','0','1','0','','30/06/2023','',2900,0,0,'7702057804855','SAL DE FRUTAS LUA PLUS CAJA *22 SOBRES','382','TECNOQUIMICAS','2023-06-29 22:42:58',  50197.3, 61384, 742, 372, 29)
			   ,('FVE','F351','000013','2023-06-29 22:49:49','062023','CO','55308354','FABIOLA','TELLO','N',' N','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','1','6700','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 22:49:49','6700','351','BOD. FARMANORTE 351','1','6700','6700','6700','0','6700','0','1','0','','30/06/2023','',6700,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-29 22:49:49',  57323.8, 41855, 742, 372, 30)
			   ,('FVE','F351','000014','2023-06-29 23:10:15','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','12','29100','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 23:10:15','29100','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','10','0','','30/06/2023','',0,29100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 23:10:15',  1000, 44347, 742, 372, 31)
			   ,('FVE','F351','000014','2023-06-29 23:10:15','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','12','29100','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 23:10:15','29100','351','BOD. FARMANORTE 351','10','1500','15000','15000','0','15000','0','10','0','','30/06/2023','',0,29100,0,'7707019312645','KLIACEF 500 MG X 20 TABLS ','130','LABQUIFAR PHARMACEUTICA','2023-06-29 23:10:15',  8550, 23577, 742, 372, 31)
			   ,('FVE','F351','000014','2023-06-29 23:10:15','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','12','29100','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 23:10:15','29100','351','BOD. FARMANORTE 351','1','14000','14000','14000','0','14000','1','0','0','','30/06/2023','',0,29100,0,'7709225183057','NOVOXICAN 15MG *10 TAB','873','NOVOFAR','2023-06-29 23:10:15',  3412, 58552, 742, 372, 31)
			   ,('FVE','F351','000015','2023-06-29 23:12:13','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','2','13400','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 23:12:13','13400','351','BOD. FARMANORTE 351','2','6700','13400','13400','0','13400','0','2','0','','30/06/2023','',0,13400,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-29 23:12:13',  57323.8, 41855, 742, 372, 32)
			   ,('FVE','F351','000016','2023-06-29 23:30:34','062023','CO','55308354','FABIOLA','TELLO','N',' N','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','2','2080','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-29 23:30:34','2080','351','BOD. FARMANORTE 351','2','1040','2080','2080','0','2080','0','2','0','','30/06/2023','',2080,0,0,'7702123006718','ASPIRINA EFERVESCENTE 500MG *50 TAB','631','BAYER OTC','2023-06-29 23:30:34',  42660, 22880, 742, 372, 34)
			   ,('FVE','F351','000017','2023-06-30 00:41:14','062023','CO','1143255013','Alejandra Marcela ','Padilla delgado ','',' 3005239814','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','4','7000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 00:41:14','7000','351','BOD. FARMANORTE 351','4','1750','7000','7000','0','7000','0','4','0','','30/06/2023','',7000,0,0,'7702132009656','ADVIL MAX *72 CAPS','616','HALEON (GLAXO OTC)','2023-06-30 00:41:14',  113956.35, 51646, 742, 372, 35)
			   ,('FVE','F351','000018','2023-06-30 01:43:59','062023','CO','1143255013','Alejandra Marcela ','Padilla delgado ','',' 3005239814','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','1','5133','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 01:43:59','5133','351','BOD. FARMANORTE 351','1','5133','5133','5133','0','5133','0','1','0','','30/06/2023','',5133,0,0,'7500435107020','VICK VAPORUB 12GR *12 LATAS','336','PROCTER & GAMBLE COLOMBIA','2023-06-30 01:43:59',  55206, 40253, 742, 372, 36)
			   ,('FVE','F351','000019','2023-06-30 01:52:46','062023','CO','55308354','FABIOLA','TELLO','N',' N','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','1','3277.310924369748','622.6890756302519','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 01:52:46','3900','351','BOD. FARMANORTE 351','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','30/06/2023','',3900,0,0,'7701021143655','WINNY TOALLITAS ALOE+VITAMINA E *24 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2023-06-30 01:52:46',  2540.7, 43316, 742, 372, 37)
			   ,('FVE','F351','000020','2023-06-30 05:05:58','062023','CO','55308354','FABIOLA','TELLO','N',' N','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','1','2016.8067226890757','383.19327731092426','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 05:05:58','2400','351','BOD. FARMANORTE 351','1','2400','2400','2016.8067226891','383.19327731092','2400','1','0','0','','30/06/2023','',2400,0,0,'7702010111464','COLGATE CREMA DENTAL T/ACCION *22 ML','145','COLGATE PALMOLIVE COMPANIA','2023-06-30 05:05:58',  1728.3651, 24463, 742, 372, 38)
			   ,('FVE','F351','000021','2023-06-30 05:49:04','062023','CO','55308354','FABIOLA','TELLO','N',' N','2098','AURA ESTHER','JIMENEZ PARRA','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 05:49:04','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 05:49:04',  866.6667, 48019, 742, 372, 40)
			   ,('FVE','F351','000022','2023-06-30 07:15:49','062023','CO','1192801349','DARWIN','ORTEGA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','4','34800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:15:49','34800','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,34800,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 07:15:49',  1000, 44347, 742, 372, 42)
			   ,('FVE','F351','000022','2023-06-30 07:15:49','062023','CO','1192801349','DARWIN','ORTEGA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','4','34800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:15:49','34800','351','BOD. FARMANORTE 351','1','23000','23000','23000','0','23000','1','0','0','','30/06/2023','',0,34800,0,'7703712080645','FUCIFAR 2% CREMA  * 15 GR','387','TRIDEX FARMACEUTICA','2023-06-30 07:15:49',  18879, 54481, 742, 372, 42)
			   ,('FVE','F351','000022','2023-06-30 07:15:49','062023','CO','1192801349','DARWIN','ORTEGA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','4','34800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:15:49','34800','351','BOD. FARMANORTE 351','1','7300','7300','7300','0','7300','1','0','0','','30/06/2023','',0,34800,0,'7707228362158','CINTA MICROPOROSA PIEL ALFASAFE 1 X 5 YD','429','ALFA SAFE','2023-06-30 07:15:49',  4428, 60551, 742, 372, 42)
			   ,('FVE','F351','000022','2023-06-30 07:15:49','062023','CO','1192801349','DARWIN','ORTEGA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','4','34800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:15:49','34800','351','BOD. FARMANORTE 351','1','4400','4400','4400','0','4400','1','0','0','','30/06/2023','',0,34800,0,'7706659500146','AGUA OXIGENADA *120 ML','143','COASPHARMA SAS','2023-06-30 07:15:49',  3124.58, 49419, 742, 372, 42)
			   ,('FVE','F351','000023','2023-06-30 07:24:45','062023','CO','5819618','LUZ','CARLOS','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','3','14800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:24:45','14800','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','0','0','','30/06/2023','',14800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 07:24:45',  1000, 44347, 742, 372, 43)
			   ,('FVE','F351','000023','2023-06-30 07:24:45','062023','CO','5819618','LUZ','CARLOS','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','3','14800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:24:45','14800','351','BOD. FARMANORTE 351','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',14800,0,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 07:24:45',  6064, 47205, 742, 372, 43)
				  ,('FVE','F351','000023','2023-06-30 07:24:45','062023','CO','5819618','LUZ','CARLOS','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','3','14800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:24:45','14800','351','BOD. FARMANORTE 351','1','6700','6700','6700','0','6700','0','1','0','','30/06/2023','',14800,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-30 07:24:45',  57323.8, 41855, 742, 372, 43);
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','000024','2023-06-30 07:48:28','062023','CO','1129488173','YOLIMAR ','VENAVIDES  ','calle 46g  1C3 -18  CIUDADELA ','  3006265594','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','3','7200','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 07:48:28','7200','351','BOD. FARMANORTE 351','3','2400','7200','7200','0','7200','0','3','0','','30/06/2023','',7200,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2023-06-30 07:48:28',  17742.24, 46200, 742, 372, 52)
			   ,('FVE','F351','000025','2023-06-30 08:39:12','062023','CO','7411194','MAXILIANO','BARRASA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','11','6000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 08:39:12','6000','351','BOD. FARMANORTE 351','10','200','2000','2000','0','2000','0','10','0','','30/06/2023','',6000,0,0,'7706569020659','ACETAMINOFEN 500MG *100 TAB','614','A.G. MEDICAMENTOS','2023-06-30 08:39:12',  12768, 31151, 742, 372, 53)
			   ,('FVE','F351','000025','2023-06-30 08:39:12','062023','CO','7411194','MAXILIANO','BARRASA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','11','6000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 08:39:12','6000','351','BOD. FARMANORTE 351','1','4000','4000','4000','0','4000','1','0','0','','30/06/2023','',6000,0,0,'7702560009532','ALCOHOL JGB *350 ML','219','JGB','2023-06-30 08:39:12',  3287.1, 27763, 742, 372, 53)
			   ,('FVE','F351','000026','2023-06-30 11:29:02','062023','CO','1129577657','TERESA','PERTUZ','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','20','39210.08403361345','7449.91596638655','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 11:29:02','46660','351','BOD. FARMANORTE 351','20','2333','46660','39210.084033613','7449.9159663866','46660','0','20','0','','30/06/2023','',6660,40000,0,'7707263009650','ACICUTIN * 60 TAB','387','TRIDEX FARMACEUTICA','2023-06-30 11:29:02',  54000, 61323, 742, 372, 55)
			   ,('FVE','F351','000027','2023-06-30 11:32:38','062023','CO','1129576369','DUAINER','GRANADO','CALLE 85 N41D 32',' 3174086368 ','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','46000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 11:32:38','46000','351','BOD. FARMANORTE 351','1','46000','46000','46000','0','46000','1','0','0','7','30/06/2023','',46000,0,0,'7501058626424','KLIM 1+ DESLACTOSADA LATA *800 GR','311','NESTLE NUTRICION','2023-06-30 11:32:38',  42616, 50766, 742, 372, 56)
			   ,('FVE','F351','000028','2023-06-30 13:34:58','062023','CO','72273288','MIGUEL','FAJARDO','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','29900','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 13:34:58','29900','351','BOD. FARMANORTE 351','1','29900','29900','29900','0','29900','1','0','0','','30/06/2023','',0,29900,0,'7701684000128','ALMIPRO UNG PARA LA PAÑALITIS *125 GR','786','ALMIPRO','2023-06-30 13:34:58',  23904, 54418, 742, 372, 57)
			   ,('FVE','F351','000029','2023-06-30 14:22:32','062023','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','4','3500','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 14:22:32','3500','351','BOD. FARMANORTE 351','3.5','1000','3500','3500','0','3500','4','0','0','','30/06/2023','',3500,0,0,'R1001','PAQUETES CONEXRED','692','CONEXRED SA','2023-06-30 14:22:32',  500, 59924, 742, 372, 61)
			   ,('FVE','F351','000030','2023-06-30 14:45:02','062023','CO','55246323','YWNIFER ','VASA','',' 0','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','2','840.3361344537816','159.6638655462184','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 14:45:02','1000','351','BOD. FARMANORTE 351','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','30/06/2023','',1000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-30 14:45:02',  9360, 46328, 742, 372, 58)
			   ,('COT','F351','00005','2023-06-30 15:37:15','062023','CO','8725525','OSVALDO','RODRIGUES RAUL','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','2','132000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 15:38:31','132000','351','BOD. FARMANORTE 351','1','43500','43500','43500','0','43500','1','0','0','','30/06/2023','',132000,0,0,'7702502015430','DIPROSPAN JERINGA PRELLENADA *1 ML','306','MSD FARMA (MERCK SHARP DOHME COLOMBIA SAS)','2023-06-30 15:37:15',  42228, 33055, 742, 372, 65)
			   ,('COT','F351','00005','2023-06-30 15:37:15','062023','CO','8725525','OSVALDO','RODRIGUES RAUL','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','2','132000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 15:38:31','132000','351','BOD. FARMANORTE 351','1','88500','88500','88500','0','88500','1','0','0','','30/06/2023','',132000,0,0,'7703153020545','BETADUO 2ML *1 JERINGA PRELLENADA ','334','PROCAPS OTX','2023-06-30 15:37:15',  40000, 39660, 742, 372, 65)
			   ,('FVE','F351','000031','2023-06-30 15:55:34','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','4','22800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 15:55:34','22800','351','BOD. FARMANORTE 351','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,22800,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 15:55:34',  1000, 44347, 742, 372, 62)
			   ,('FVE','F351','000031','2023-06-30 15:55:34','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','4','22800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 15:55:34','22800','351','BOD. FARMANORTE 351','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',0,22800,0,'7501125185182','ELECTROLIT JAMAICA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 15:55:34',  6064, 59849, 742, 372, 62)
			   ,('FVE','F351','000031','2023-06-30 15:55:34','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','4','22800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 15:55:34','22800','351','BOD. FARMANORTE 351','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',0,22800,0,'7501125104688','ELECTROLIT NARANJA-MANDARINA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 15:55:34',  6064, 47204, 742, 372, 62)
			   ,('FVE','F351','000031','2023-06-30 15:55:34','062023','CO','1045724618','LINA','VILLA','CALLE 46 J N 1C 87 CIUDADELA',' 3148251729','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','4','22800','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 15:55:34','22800','351','BOD. FARMANORTE 351','1','6700','6700','6700','0','6700','0','1','0','','30/06/2023','',0,22800,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-30 15:55:34',  57323.8, 41855, 742, 372, 62)
			   ,('FVE','F351','000032','2023-06-30 16:03:35','062023','CO','1001819574','JOEL ENRIQUE ','JASSIR MAR Atilde  shy N','CALLE 5 NO.3-24 BARRIO AEROPUE',' 3112540977','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 16:03:35','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 16:03:35',  866.6667, 48019, 742, 372, 64)
			   ,('FVE','F351','000033','2023-06-30 16:22:10','062023','CO','8660332','LUIS  ENRIQU ','POLO CUETO','',' 0','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','1','11764.705882352942','2235.2941176470576','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 16:22:12','14000','351','BOD. FARMANORTE 351','1','14000','14000','11764.705882353','2235.2941176471','14000','1','0','0','','30/06/2023','',14000,0,0,'650240035401','ASEPXIA JABON CARBON DETOX *100 GR','194','GENOMMA LABORATORIO COLOMBIA','2023-06-30 16:22:10',  10821.6, 51777, 742, 372, 69)
			   ,('FVE','F351','000034','2023-06-30 16:28:40','062023','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','23000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 16:28:40','23000','351','BOD. FARMANORTE 351','1','23000','23000','23000','0','23000','1','0','0','','30/06/2023','',23000,0,0,'7703712080645','FUCIFAR 2% CREMA  * 15 GR','387','TRIDEX FARMACEUTICA','2023-06-30 16:28:40',  18879, 54481, 742, 372, 70)
			   ,('FVE','F351','000035','2023-06-30 16:47:53','062023','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 16:47:53','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 16:47:53',  866.6667, 48019, 742, 372, 71)
			   ,('FVE','F351','000036','2023-06-30 17:46:58','062023','CO','1234098502','ROSANA ','MOLINA','',' 0','576','DIOMAR','QUINTERO','','TERCERO','VARIOS','','','','','','6','8940','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 17:46:59','8940','351','BOD. FARMANORTE 351','6','1490','8940','8940','0','8940','0','6','0','','30/06/2023','',8940,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2023-06-30 17:46:58',  47826, 31759, 742, 372, 72)
			   ,('FVE','F351','000037','2023-06-30 18:48:17','062023','CO','1001819574','JOEL ENRIQUE ','JASSIR MAR Atilde  shy N','CALLE 5 NO.3-24 BARRIO AEROPUE',' 3112540977','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 18:48:17','2000','351','BOD. FARMANORTE 351','1','2000','2000','2000','0','2000','1','0','10','','30/06/2023','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 18:48:17',  866.6667, 48019, 742, 372, 74)
			   ,('FVE','F351','000038','2023-06-30 18:50:19','062023','CO','1045728192','ISMAEL','PADILLA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','8000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 18:50:19','8000','351','BOD. FARMANORTE 351','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',8000,0,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 18:50:19',  6064, 47205, 742, 372, 76)
			   ,('FVE','F351','000039','2023-06-30 19:00:02','062023','CO','1127577802','KARINA','VILLANUEVA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','10','2000','0','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 19:00:02','2000','351','BOD. FARMANORTE 351','10','200','2000','2000','0','2000','0','10','0','','30/06/2023','',2000,0,0,'7706569020659','ACETAMINOFEN 500MG *100 TAB','614','A.G. MEDICAMENTOS','2023-06-30 19:00:02',  12768, 31151, 742, 372, 77)
			   ,('FVE','F351','000040','2023-06-30 19:02:54','062023','CO','1051744860','OMAIRA','TAPIA','',' 0','1206','JOEL ENRIQUE ','JASSIR MARíN','','TERCERO','VARIOS','','','','','','1','11764.705882352942','2235.2941176470576','351','FARMANORTE 351','ADMINISTRADOR','2023-06-30 19:02:54','14000','351','BOD. FARMANORTE 351','1','14000','14000','11764.705882353','2235.2941176471','14000','1','0','0','','30/06/2023','',14000,0,0,'650240035401','ASEPXIA JABON CARBON DETOX *100 GR','194','GENOMMA LABORATORIO COLOMBIA','2023-06-30 19:02:54',  10821.6, 51777, 742, 372, 78);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '062023' AND DECODBOD='351';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '062023' AND DECODBOD='351';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '062023' AND DECODBOD='351';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '062023' AND DECODBOD='351';
DELETE FROM consolida2 WHERE PERIODOESPE = '062023' AND CODSUCURSAL = '351';
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','576','DIOMAR QUINTERO','7707232095608','MIELTERTOS ADULTOS *240 ML     ','1','31600','10','3160','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','576','DIOMAR QUINTERO','7702184020258','CLORFENIRAMINA JBE *120 ML','1','5500','10','550','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','2098','AURA ESTHER JIMENEZ PARRA','7706569001269','CLOTRIMAZOL CREMA TOPICA *40 GR','1','10500','10','1050','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','2098','AURA ESTHER JIMENEZ PARRA','7707019340105','FINAPAR X 2 TABLS','1','6000','12','720','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','2098','AURA ESTHER JIMENEZ PARRA','7706569020659','ACETAMINOFEN 500MG *100 TAB','10','2000','10','200','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','2098','AURA ESTHER JIMENEZ PARRA','7707210530572','SIMPIOX GOTAS *5 ML  ','1','13300','5','665','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','2098','AURA ESTHER JIMENEZ PARRA','7707019312645','KLIACEF 500 MG X 20 TABLS ','10','15000','12','1800','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','2098','AURA ESTHER JIMENEZ PARRA','7709225183057','NOVOXICAN 15MG *10 TAB','1','14000','10','1400','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','2098','AURA ESTHER JIMENEZ PARRA','7709008052563','AGUA FARMANORTE *600 ML','1','2000','5','100','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7703712080645','FUCIFAR 2% CREMA  * 15 GR','1','23000','15','3450','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7706659500146','AGUA OXIGENADA *120 ML','1','4400','5','220','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','3','7200','10','720','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7706569020659','ACETAMINOFEN 500MG *100 TAB','10','2000','10','200','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7707263009650','ACICUTIN * 60 TAB','20','39210.084033613','10','3921.0084033613','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7709008052563','AGUA FARMANORTE *600 ML','1','2000','5','100','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7703712080645','FUCIFAR 2% CREMA  * 15 GR','1','23000','15','3450','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7709008052563','AGUA FARMANORTE *600 ML','1','2000','5','100','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7709008052563','AGUA FARMANORTE *600 ML','1','2000','5','100','351','FARMANORTE 351','');
INSERT INTO consolida2(PERIODOESPE, FECHAESPE , CODVENDE , NOMVENDE , CODPRODUCTO , NOMPRODUCTO , CANTIVENTA , VALORVENTA , PORCENBONI , VALORCOMI , CODSUCURSAL ,  NOMSUCURSAL , PAGADO ) VALUES ('062023','2023-06-30','1206','JOEL ENRIQUE  JASSIR MARíN','7706569020659','ACETAMINOFEN 500MG *100 TAB','10','2000','10','200','351','FARMANORTE 351','');
