INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FTSV','016651','2024-04-29 20:24:43','042024','CO','1005665260','VALENTINA ','SALGADO ','',' 3004213749','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','9','14228.57142857143','271.42857142857133','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:24:44','14500','358','BOD. FARMANORTE 358','1','1700','1700','1428.5714285714','271.42857142857','1700','1','0','0','','29/04/2024','',0,14500,0,'7702189056245','CHOKIS CHOCOBASE *47 GR','762','FRITO LAY','2024-04-29 20:24:43',  1050, 57555, 749, 379),('FVE','FTSV','016652','2024-04-29 20:25:00','042024','CO','1027800236','CRISTIAN ','ARROYO','Direcci oacute n: TR 22 CL 4C ',' 3152181196','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','24','16900.33613445378','159.6638655462184','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:25:21','17060','358','BOD. FARMANORTE 358','1','3900','3900','3900','0','3900','1','0','0','','29/04/2024','',12060,0,0,'7702605101634','LORATADINA 10 MG *10 TAB','193','GENFAR','2024-04-29 20:25:00',  2554, 26098, 749, 379),('FVE','FTSV','016652','2024-04-29 20:25:00','042024','CO','1027800236','CRISTIAN ','ARROYO','Direcci oacute n: TR 22 CL 4C ',' 3152181196','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','24','16900.33613445378','159.6638655462184','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:25:21','17060','358','BOD. FARMANORTE 358','10','300','3000','3000','0','3000','0','10','0','','29/04/2024','',12060,0,0,'7702605100019','ACETAMINOFEN 500 MG X 100 TBS GENFAR-WINTHROP','193','GENFAR','2024-04-29 20:25:00',  4500, 25866, 749, 379),('FVE','FTSV','016652','2024-04-29 20:25:00','042024','CO','1027800236','CRISTIAN ','ARROYO','Direcci oacute n: TR 22 CL 4C ',' 3152181196','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','24','16900.33613445378','159.6638655462184','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:25:21','17060','358','BOD. FARMANORTE 358','10','256','2560','2560','0','2560','0','10','0','','29/04/2024','',12060,0,0,'7702184010280','TIAMINA 300 MG *250 TAB','249','ECAR','2024-04-29 20:25:00',  47100, 29762, 749, 379),('FVE','FTSV','016652','2024-04-29 20:25:00','042024','CO','1027800236','CRISTIAN ','ARROYO','Direcci oacute n: TR 22 CL 4C ',' 3152181196','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','24','16900.33613445378','159.6638655462184','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:25:21','17060','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',12060,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 20:25:00',  800, 48019, 749, 379),('FVE','FTSV','016652','2024-04-29 20:25:00','042024','CO','1027800236','CRISTIAN ','ARROYO','Direcci oacute n: TR 22 CL 4C ',' 3152181196','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','24','16900.33613445378','159.6638655462184','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:25:21','17060','358','BOD. FARMANORTE 358','1','4600','4600','4600','0','4600','0','1','0','','29/04/2024','',12060,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-04-29 20:25:00',  27780, 54056, 749, 379),('FVE','FTSV','016652','2024-04-29 20:25:00','042024','CO','1027800236','CRISTIAN ','ARROYO','Direcci oacute n: TR 22 CL 4C ',' 3152181196','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','24','16900.33613445378','159.6638655462184','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:25:21','17060','358','BOD. FARMANORTE 358','1','1000','1000','840.33613445378','159.66386554622','1000','1','0','0','','29/04/2024','',12060,0,0,'77010148','JET CHOCOLATINA *12 GR','816','GRUPO NUTRESA','2024-04-29 20:25:00',  632.88, 47412, 749, 379),('FVE','FTSV','016653','2024-04-29 20:32:15','042024','CR','1103217206','JOS eacute  EDUARDO ','MENDOZA MONTERROZA ','',' 3024593158','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','905885','1','2100.840336134454','399.159663865546','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:34:18','2500','358','BOD. FARMANORTE 358','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/04/2024','',0,0,2500,'7702189055453','NATUCHIPS PLATANO VERDE *38 GR','762','FRITO LAY','2024-04-29 20:32:15',  1479, 57247, 749, 379),('FVE','FTSV','016654','2024-04-29 20:47:18','042024','CO','64703919','LEIDA ','HERNANDEZ','',' 3015801823','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','7','10450','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:47:19','10450','358','BOD. FARMANORTE 358','5','1300','6500','6500','0','6500','0','5','0','','29/04/2024','',10450,0,0,'8850769020106','ZIRIN 10 MG CJA * 50 CAPS','802','MEGA WE CARE','2024-04-29 20:47:18',  47007, 55996, 749, 379),('FVE','FTSV','016654','2024-04-29 20:47:18','042024','CO','64703919','LEIDA ','HERNANDEZ','',' 3015801823','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','7','10450','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:47:19','10450','358','BOD. FARMANORTE 358','2','1975','3950','3950','0','3950','0','2','0','','29/04/2024','',10450,0,0,'650240032592','NEXT GL GRIPA *8 TAB ','194','GENOMMA LABORATORIO COLOMBIA','2024-04-29 20:47:18',  14234, 54385, 749, 379),('FVE','FTSV','016655','2024-04-29 20:49:06','042024','CO','64703919','LEIDA ','HERNANDEZ','',' 3015801823','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','1','1512.6050420168067','287.3949579831933','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 20:49:07','1800','358','BOD. FARMANORTE 358','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','29/04/2024','',1800,0,0,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2024-04-29 20:49:06',  1159, 58744, 749, 379),('FVE','FTSV','016657','2024-04-29 21:00:40','042024','CO','1101813228','RODRIGO','RICARDO','Kra 38A 22 64  Barrio Florenci',' 3004487957','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','1','57700','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:00:40','57700','358','BOD. FARMANORTE 358','1','57700','57700','57700','0','57700','1','0','0','','29/04/2024','',0,57700,0,'7501058631145','BABY KLIM 2+ LATA *800 GR','311','NESTLE NUTRICION','2024-04-29 21:00:40',  53365, 51946, 749, 379),('FVE','FTSV','016658','2024-04-29 21:06:24','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','2','1176.4705882352941','223.52941176470586','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:06:24','1400','358','BOD. FARMANORTE 358','2','700','1400','1176.4705882353','223.52941176471','1400','2','0','0','','29/04/2024','',1400,0,0,'7702025136049  ','SALTIN NOEL ROJA * 216 GR','816','GRUPO NUTRESA','2024-04-29 21:06:24',  437.1111, 53641, 749, 379),('FVE','FTSV','016659','2024-04-29 21:14:56','042024','CO','1100691079','ROMARIO ','MAURI ','',' 3002572890','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','24380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:14:57','24380','358','BOD. FARMANORTE 358','2','6040','12080','12080','0','12080','0','2','0','','29/04/2024','',24380,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-04-29 21:14:56',  53223.5, 41855, 749, 379),('FVE','FTSV','016659','2024-04-29 21:14:56','042024','CO','1100691079','ROMARIO ','MAURI ','',' 3002572890','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','24380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:14:57','24380','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',24380,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 21:14:56',  800, 48019, 749, 379),('FVE','FTSV','016659','2024-04-29 21:14:56','042024','CO','1100691079','ROMARIO ','MAURI ','',' 3002572890','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','24380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:14:57','24380','358','BOD. FARMANORTE 358','1','7600','7600','7600','0','7600','0','1','0','','29/04/2024','',24380,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-04-29 21:14:56',  63045, 31775, 749, 379),('FVE','FTSV','016659','2024-04-29 21:14:56','042024','CO','1100691079','ROMARIO ','MAURI ','',' 3002572890','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','24380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:14:57','24380','358','BOD. FARMANORTE 358','1','2700','2700','2700','0','2700','0','1','0','','29/04/2024','',24380,0,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-04-29 21:14:56',  33370, 62346, 749, 379),('FVE','FTSV','016660','2024-04-29 21:15:30','042024','CO','1100684719','FABIO','TIRADO PINEDA','',' 3103556874','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','9142.857142857143','1357.1428571428569','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:15:30','10500','358','BOD. FARMANORTE 358','1','8500','8500','7142.8571428571','1357.1428571429','8500','1','0','0','','29/04/2024','',10500,0,0,'7709804466977','LAZARO BEBIDA SOBRE X 70ML ','1012','BORN DC ','2024-04-29 21:15:30',  0, 63339, 749, 379),('FVE','FTSV','016660','2024-04-29 21:15:30','042024','CO','1100684719','FABIO','TIRADO PINEDA','',' 3103556874','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','9142.857142857143','1357.1428571428569','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:15:30','10500','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','29/04/2024','',10500,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 21:15:30',  800, 48019, 749, 379),('FVE','FTSV','016661','2024-04-29 21:34:13','042024','CO','92506004','NILSON','FERIAS','kra 36 n 23b-37 b florencia po',' 1 3207335847','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','1','19033.613445378152','3616.3865546218476','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:34:15','22650','358','BOD. FARMANORTE 358','1','22650','22650','19033.613445378','3616.3865546218','22650','1','0','0','','30/04/2024','',0,22650,0,'7701021115706','WINNY ULTRATRIM SEC ET1 *30 + 20 TOALLITAS','653','TECNOQUIMICAS WINNY','2024-04-29 21:34:13',  17118.9, 34273, 749, 379),('FVE','FTSV','016662','2024-04-29 21:35:05','042024','CO','12533818','PAOLA','ALVAREZ','',' 3017756757','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','4','14811.764705882353','1788.235294117646','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:35:05','16600','358','BOD. FARMANORTE 358','2','2700','5400','5400','0','5400','0','2','0','','30/04/2024','',16600,0,0,'7702870071502','LUMBAL FORTE CJA *36 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-04-29 21:35:05',  50000, 37241, 749, 379),('FVE','FTSV','016662','2024-04-29 21:35:05','042024','CO','12533818','PAOLA','ALVAREZ','',' 3017756757','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','4','14811.764705882353','1788.235294117646','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:35:05','16600','358','BOD. FARMANORTE 358','1','5100','5100','4285.7142857143','814.28571428571','5100','1','0','0','','30/04/2024','',16600,0,0,'7702402053556','CONO BOCATTO FRESA *85 GR','296','MEALS DE COLOMBIA','2024-04-29 21:35:05',  2980, 55871, 749, 379),('FVE','FTSV','016662','2024-04-29 21:35:05','042024','CO','12533818','PAOLA','ALVAREZ','',' 3017756757','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','4','14811.764705882353','1788.235294117646','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:35:05','16600','358','BOD. FARMANORTE 358','1','6100','6100','5126.0504201681','973.94957983193','6100','1','0','0','','30/04/2024','',16600,0,0,'7702535011799','COCA COLA ZERO *1.5 LT','144','COCA COLA','2024-04-29 21:35:05',  3770.75, 34406, 749, 379),('FVE','FTSV','016663','2024-04-29 21:43:06','042024','CO','12533817','MARCO','LOPEZ','',' 3242818431','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','6','12500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:43:06','12500','358','BOD. FARMANORTE 358','5','1900','9500','9500','0','9500','0','5','0','','30/04/2024','',12500,0,0,'7707019312607','SUPRIBAC F * 10 TAB','130','LABQUIFAR PHARMACEUTICA','2024-04-29 21:43:06',  5510, 45829, 749, 379),('FVE','FTSV','016663','2024-04-29 21:43:06','042024','CO','12533817','MARCO','LOPEZ','',' 3242818431','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','6','12500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:43:06','12500','358','BOD. FARMANORTE 358','1','3000','3000','3000','0','3000','0','1','0','','30/04/2024','',12500,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2024-04-29 21:43:06',  27350, 46776, 749, 379),('FVE','FTSV','016664','2024-04-29 21:51:02','042024','CO','1102856696','MELINA','MARTINEZ','Calle 25c # 52 a 128 barrio lo',' 3004973965','3540','JESUS ERNESTO','ANICHARICO LOPEZ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','3','12700','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:51:03','12700','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',0,12700,0,'DO','DOMICILIO','00','VARIOS','2024-04-29 21:51:02',  1500, 44348, 749, 379),('FVE','FTSV','016664','2024-04-29 21:51:02','042024','CO','1102856696','MELINA','MARTINEZ','Calle 25c # 52 a 128 barrio lo',' 3004973965','3540','JESUS ERNESTO','ANICHARICO LOPEZ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','3','12700','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:51:03','12700','358','BOD. FARMANORTE 358','1','10500','10500','10500','0','10500','1','0','0','','30/04/2024','',0,12700,0,'7709299854228','PRUEBA DE EMBARAZO ESFERO ','398','ZIBOJECT','2024-04-29 21:51:02',  3150, 55608, 749, 379),('FVE','FTSV','016664','2024-04-29 21:51:02','042024','CO','1102856696','MELINA','MARTINEZ','Calle 25c # 52 a 128 barrio lo',' 3004973965','3540','JESUS ERNESTO','ANICHARICO LOPEZ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','3','12700','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:51:03','12700','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,12700,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 21:51:02',  100, 44347, 749, 379),('FVE','FTSV','016665','2024-04-29 21:54:48','042024','CO','1045016224','JULIO','CASTA Ntilde O','',' 3223086227','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','578429','578429','PAEZ CASTELLANOS JORGE HERNANDO','','','6','92500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:54:51','92500','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',92500,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 21:54:48',  800, 48019, 749, 379),('FVE','FTSV','016665','2024-04-29 21:54:48','042024','CO','1045016224','JULIO','CASTA Ntilde O','',' 3223086227','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','578429','578429','PAEZ CASTELLANOS JORGE HERNANDO','','','6','92500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:54:51','92500','358','BOD. FARMANORTE 358','2','14900','29800','29800','0','29800','2','0','0','','30/04/2024','',92500,0,0,'7707210530572','SIMPIOX GOTAS *5 ML  ','256','GERCO','2024-04-29 21:54:48',  8081, 29858, 749, 379),('FVE','FTSV','016665','2024-04-29 21:54:48','042024','CO','1045016224','JULIO','CASTA Ntilde O','',' 3223086227','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','578429','578429','PAEZ CASTELLANOS JORGE HERNANDO','','','6','92500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:54:51','92500','358','BOD. FARMANORTE 358','1','17000','17000','17000','0','17000','1','0','0','','30/04/2024','',92500,0,0,'7707210530015','CALADERM LOCION * 120 ML  ','256','GERCO','2024-04-29 21:54:48',  15787, 29839, 749, 379),('FVE','FTSV','016665','2024-04-29 21:54:48','042024','CO','1045016224','JULIO','CASTA Ntilde O','',' 3223086227','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','578429','578429','PAEZ CASTELLANOS JORGE HERNANDO','','','6','92500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:54:51','92500','358','BOD. FARMANORTE 358','1','43500','43500','43500','0','43500','1','0','0','','30/04/2024','',92500,0,0,'7703889000569','TRIGENTAX CREMA *40 GR ','242','CHALVER ','2024-04-29 21:54:48',  37500, 29001, 749, 379),('FVE','FTSV','016665','2024-04-29 21:54:48','042024','CO','1045016224','JULIO','CASTA Ntilde O','',' 3223086227','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','578429','578429','PAEZ CASTELLANOS JORGE HERNANDO','','','6','92500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 21:54:51','92500','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',92500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 21:54:48',  100, 44347, 749, 379),('FVE','FTSV','016666','2024-04-29 22:14:46','042024','CO','1100690345','DELIMIRO','PEREZ','0',' 3234568056','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','4','26052.38095238095','847.6190476190495','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:14:47','26900','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,26900,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 22:14:46',  100, 44347, 749, 379),('FVE','FTSV','016666','2024-04-29 22:14:46','042024','CO','1100690345','DELIMIRO','PEREZ','0',' 3234568056','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','4','26052.38095238095','847.6190476190495','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:14:47','26900','358','BOD. FARMANORTE 358','2','8900','17800','16952.380952381','847.61904761905','17800','2','0','0','','30/04/2024','',0,26900,0,'5410316983693','SMIRNOFF ICE BOTELLA *275 ML','827','MEICO LICORES','2024-04-29 22:14:46',  5101, 33225, 749, 379),('FVE','FTSV','016666','2024-04-29 22:14:46','042024','CO','1100690345','DELIMIRO','PEREZ','0',' 3234568056','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','4','26052.38095238095','847.6190476190495','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:14:47','26900','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','0','','30/04/2024','',0,26900,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-29 22:14:46',  6610, 54196, 749, 379),('FVE','FTSV','016667','2024-04-29 22:16:14','042024','CO','78696024','JOSE','NARANJO','',' 3218274540','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','15','16000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:16:16','16000','358','BOD. FARMANORTE 358','10','800','8000','8000','0','8000','0','10','0','','30/04/2024','',16000,0,0,'7451079000669,7','DOLEX 500 MG *200 TAB','616','HALEON (GLAXO OTC)','2024-04-29 22:16:14',  125586, 26516, 749, 379),('FVE','FTSV','016667','2024-04-29 22:16:14','042024','CO','78696024','JOSE','NARANJO','',' 3218274540','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','15','16000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:16:16','16000','358','BOD. FARMANORTE 358','2','1800','3600','3600','0','3600','0','2','0','','30/04/2024','',16000,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-04-29 22:16:14',  111600, 43550, 749, 379),('FVE','FTSV','016667','2024-04-29 22:16:14','042024','CO','78696024','JOSE','NARANJO','',' 3218274540','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','15','16000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:16:16','16000','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',16000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 22:16:14',  100, 44347, 749, 379),('FVE','FTSV','016667','2024-04-29 22:16:14','042024','CO','78696024','JOSE','NARANJO','',' 3218274540','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','15','16000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:16:16','16000','358','BOD. FARMANORTE 358','2','2100','4200','4200','0','4200','0','2','0','','30/04/2024','',16000,0,0,'7702132008529','ADVIL ULTRA *72 CAP ','616','HALEON (GLAXO OTC)','2024-04-29 22:16:14',  139438.1, 39002, 749, 379);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FTSV','016669','2024-04-29 22:29:28','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','2','16800','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 22:29:28','16800','358','BOD. FARMANORTE 358','2','8400','16800','16800','0','16800','0','2','0','','30/04/2024','',16800,0,0,'7594002621989','FLORATIL 250MG *10 SOBRES','761','AXON PHARMA ','2024-04-29 22:29:28',  60742.6, 33629, 749, 379),('FVE','FTSV','016670','2024-04-29 23:10:17','042024','CO','1102888452','LUZ MARIA','ACU Ntilde A','0',' 3106117305','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','6','24720.168067226892','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:10:17','24800','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',10000,14800,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 23:10:17',  100, 44347, 749, 379),('FVE','FTSV','016670','2024-04-29 23:10:17','042024','CO','1102888452','LUZ MARIA','ACU Ntilde A','0',' 3106117305','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','6','24720.168067226892','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:10:17','24800','358','BOD. FARMANORTE 358','1','2100','2100','2100','0','2100','0','1','0','','30/04/2024','',10000,14800,0,'7703381002313','BUSCAPINA FEM *90 COMP ','772','OPELLA (SANOFI OTC)','2024-04-29 23:10:17',  134048.9, 23812, 749, 379),('FVE','FTSV','016670','2024-04-29 23:10:17','042024','CO','1102888452','LUZ MARIA','ACU Ntilde A','0',' 3106117305','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','6','24720.168067226892','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:10:17','24800','358','BOD. FARMANORTE 358','1','14500','14500','14500','0','14500','1','0','0','26','30/04/2024','',10000,14800,0,'7702870071465','BELLAFACE SUAVE *28 TAB','619','ABBOTT FARMA','2024-04-29 23:10:17',  12656, 47121, 749, 379),('FVE','FTSV','016670','2024-04-29 23:10:17','042024','CO','1102888452','LUZ MARIA','ACU Ntilde A','0',' 3106117305','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','6','24720.168067226892','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:10:17','24800','358','BOD. FARMANORTE 358','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','30/04/2024','',10000,14800,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-04-29 23:10:17',  255, 46100, 749, 379),('FVE','FTSV','016670','2024-04-29 23:10:17','042024','CO','1102888452','LUZ MARIA','ACU Ntilde A','0',' 3106117305','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','6','24720.168067226892','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:10:17','24800','358','BOD. FARMANORTE 358','1','4300','4300','4300','0','4300','1','0','0','','30/04/2024','',10000,14800,0,'7709990045826','BETAMETASONA 4MG/1ML *1 AMP','701','VITALIS COMERCIAL','2024-04-29 23:10:17',  1800, 54345, 749, 379),('FVE','FTSV','016670','2024-04-29 23:10:17','042024','CO','1102888452','LUZ MARIA','ACU Ntilde A','0',' 3106117305','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','6','24720.168067226892','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:10:17','24800','358','BOD. FARMANORTE 358','1','3200','3200','3200','0','3200','0','1','0','','30/04/2024','',10000,14800,0,'7703153040949','DICLOFENACO 75MG/3ML CJA * 10 AMP','422','COLMED','2024-04-29 23:10:17',  5600, 61834, 749, 379),('FVE','FTSV','016671','2024-04-29 23:12:07','042024','CO','64555215','NAIDED  MARIA','ROBLES RIVEIRA','sincelejo',' 3012546801','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:12:10','1900','358','BOD. FARMANORTE 358','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2024','',1900,0,0,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-04-29 23:12:07',  1142.8, 60397, 749, 379),('FVE','FTSV','016672','2024-04-29 23:26:07','042024','CO','1233344025','ANGELLO','NARANJO ROBLES','MANZANA 7 LOTE 19 RANCHO GRAND',' 3244138189','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','1','2600','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:26:07','2600','358','BOD. FARMANORTE 358','1','2600','2600','2600','0','2600','1','0','1','','30/04/2024','',2600,0,0,'7702535010280','GASEOSA SODA SCHWEPPES BOTELLA *400 ML','144','COCA COLA','2024-04-29 23:26:07',  1937.5833, 57234, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,52600,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-29 23:57:45',  100, 44347, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',0,52600,0,'7702535014240','FUZE TEA TE NEGRO LIMON *400 ML','144','COCA COLA','2024-04-29 23:57:45',  1711.8, 35165, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',0,52600,0,'7702535016688','FUZE TEA MANZANA *400 ML','144','COCA COLA','2024-04-29 23:57:45',  1902.1666, 56145, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','1','6900','6900','5798.3193277311','1101.6806722689','6900','1','0','0','','30/04/2024','',0,52600,0,'7702189053770','PAPAS MARGARITA DE POLLO *105 GR','762','FRITO LAY','2024-04-29 23:57:45',  4629, 54305, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','5','2000','10000','10000','0','10000','5','0','0','','30/04/2024','',0,52600,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-29 23:57:45',  800, 48019, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','2','2500','5000','4201.6806722689','798.31932773109','5000','2','0','0','','30/04/2024','',0,52600,0,'7702189055484','NATUCHIPS PLATANO MADURO *38 GR','762','FRITO LAY','2024-04-29 23:57:45',  1449, 56938, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','5','2900','14500','12184.87394958','2315.1260504202','14500','5','0','0','','30/04/2024','',0,52600,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2024-04-29 23:57:45',  1782, 54650, 749, 379),('FVE','FTSV','016673','2024-04-29 23:57:45','042024','CO','1005660933','DIEGO ','GENEI','0',' 313531194','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','19','45830.252100840335','6769.747899159662','358','FARMANORTE 358','ADMINISTRADOR','2024-04-29 23:57:45','52600','358','BOD. FARMANORTE 358','3','3200','9600','8067.2268907563','1532.7731092437','9600','3','0','0','','30/04/2024','',0,52600,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-04-29 23:57:45',  1806, 56307, 749, 379),('FVE','FTSV','016674','2024-04-30 00:42:53','042024','CO','1143346830','HECTOR','GOMEZ','',' 0','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','14821.008403361346','478.9915966386552','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 00:42:54','15300','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','0','','30/04/2024','',15300,0,0,'7501125104411','ELECTROLIT COCO SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-30 00:42:53',  6785, 47206, 749, 379),('FVE','FTSV','016674','2024-04-30 00:42:53','042024','CO','1143346830','HECTOR','GOMEZ','',' 0','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','14821.008403361346','478.9915966386552','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 00:42:54','15300','358','BOD. FARMANORTE 358','2','1600','3200','3200','0','3200','0','2','0','','30/04/2024','',15300,0,0,'7703712085046','BINAFAR 200MG/500MG CJA * 24 TB /D24/','387','TRIDEX FARMACEUTICA','2024-04-30 00:42:53',  24900, 54476, 749, 379),('FVE','FTSV','016674','2024-04-30 00:42:53','042024','CO','1143346830','HECTOR','GOMEZ','',' 0','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','14821.008403361346','478.9915966386552','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 00:42:54','15300','358','BOD. FARMANORTE 358','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','30/04/2024','',15300,0,0,'7702090036923','GASEOSA MANZANA CERO *1 LT','192','POSTOBON GASEOSAS','2024-04-30 00:42:53',  1785.7, 53832, 749, 379),('FVE','FTSV','016674','2024-04-30 00:42:53','042024','CO','1143346830','HECTOR','GOMEZ','',' 0','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','14821.008403361346','478.9915966386552','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 00:42:54','15300','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',15300,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 00:42:53',  100, 44347, 749, 379),('FVE','FTSV','016675','2024-04-30 04:25:09','042024','CO','91297815','SAMUEL','MARIN','','0 ','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','10551.26050420168','1548.7394957983188','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:25:09','12100','358','BOD. FARMANORTE 358','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2024','',12100,0,0,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-04-30 04:25:09',  1142.8, 60397, 749, 379),('FVE','FTSV','016675','2024-04-30 04:25:09','042024','CO','91297815','SAMUEL','MARIN','','0 ','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','10551.26050420168','1548.7394957983188','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:25:09','12100','358','BOD. FARMANORTE 358','2','1200','2400','2400','0','2400','0','2','0','','30/04/2024','',12100,0,0,'7702123006787','ALKA SELTZER *60 TAB','631','BAYER OTC','2024-04-30 04:25:09',  58340, 46895, 749, 379),('FVE','FTSV','016675','2024-04-30 04:25:09','042024','CO','91297815','SAMUEL','MARIN','','0 ','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','10551.26050420168','1548.7394957983188','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:25:09','12100','358','BOD. FARMANORTE 358','2','3900','7800','6554.6218487395','1245.3781512605','7800','2','0','0','','30/04/2024','',12100,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','POSTOBON GASEOSAS','2024-04-30 04:25:09',  2451, 25826, 749, 379),('FVE','FTSV','016676','2024-04-30 04:39:08','042024','CO','64555215','NAIDED  MARIA','ROBLES RIVEIRA','sincelejo',' 3012546801','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','8722.689075630253','1277.3109243697475','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:39:08','10000','358','BOD. FARMANORTE 358','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/04/2024','',10000,0,0,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2024-04-30 04:39:08',  1159, 58744, 749, 379),('FVE','FTSV','016676','2024-04-30 04:39:08','042024','CO','64555215','NAIDED  MARIA','ROBLES RIVEIRA','sincelejo',' 3012546801','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','8722.689075630253','1277.3109243697475','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:39:08','10000','358','BOD. FARMANORTE 358','1','1300','1300','1092.4369747899','207.56302521008','1300','1','0','0','','30/04/2024','',10000,0,0,'7702025136773','GALLETAS FESTIVAL FRESA *6 GALLETAS','816','GRUPO NUTRESA','2024-04-30 04:39:08',  872.083, 53162, 749, 379),('FVE','FTSV','016676','2024-04-30 04:39:08','042024','CO','64555215','NAIDED  MARIA','ROBLES RIVEIRA','sincelejo',' 3012546801','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','8722.689075630253','1277.3109243697475','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:39:08','10000','358','BOD. FARMANORTE 358','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2024','',10000,0,0,'7705326076588','PONQUE BIMBO *60 GR','126','BIMBO DE COLOMBIA S.A.','2024-04-30 04:39:08',  1149, 23461, 749, 379),('FVE','FTSV','016676','2024-04-30 04:39:08','042024','CO','64555215','NAIDED  MARIA','ROBLES RIVEIRA','sincelejo',' 3012546801','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','8722.689075630253','1277.3109243697475','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:39:08','10000','358','BOD. FARMANORTE 358','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','30/04/2024','',10000,0,0,'7702090036923','GASEOSA MANZANA CERO *1 LT','192','POSTOBON GASEOSAS','2024-04-30 04:39:08',  1785.7, 53832, 749, 379),('FVE','FTSV','016676','2024-04-30 04:39:08','042024','CO','64555215','NAIDED  MARIA','ROBLES RIVEIRA','sincelejo',' 3012546801','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','5','8722.689075630253','1277.3109243697475','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 04:39:08','10000','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','0','1','0','','30/04/2024','',10000,0,0,'7708152336758','SUREZINC TRANSFER VAINILLA * 36 S/S','1007','SUREZINC','2024-04-30 04:39:08',  25000, 62424, 749, 379),('FVE','FTSV','016677','2024-04-30 06:19:17','042024','CO','1233344025','ANGELLO','NARANJO ROBLES','MANZANA 7 LOTE 19 RANCHO GRAND',' 3244138189','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','2','1092.436974789916','207.563025210084','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 06:19:17','1300','358','BOD. FARMANORTE 358','1','800','800','672.26890756303','127.73109243697','800','1','0','1','','30/04/2024','',1300,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-04-30 06:19:17',  228.3, 39236, 749, 379),('FVE','FTSV','016677','2024-04-30 06:19:17','042024','CO','1233344025','ANGELLO','NARANJO ROBLES','MANZANA 7 LOTE 19 RANCHO GRAND',' 3244138189','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','2','1092.436974789916','207.563025210084','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 06:19:17','1300','358','BOD. FARMANORTE 358','1','500','500','420.16806722689','79.831932773109','500','0','1','1','','30/04/2024','',1300,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-04-30 06:19:17',  9360, 46328, 749, 379),('FVE','FTSV','016678','2024-04-30 06:36:53','042024','CO','22762008','EDUARDO','GUTIERRES','',' 3127802160','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','3','3057.1428571428573','542.8571428571428','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 06:36:54','3600','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',3600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 06:36:53',  100, 44347, 749, 379),('FVE','FTSV','016678','2024-04-30 06:36:53','042024','CO','22762008','EDUARDO','GUTIERRES','',' 3127802160','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','3','3057.1428571428573','542.8571428571428','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 06:36:54','3600','358','BOD. FARMANORTE 358','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','30/04/2024','',3600,0,0,'7702617022132','NECTAR CALIFORNIA MANZANA  *200 ML','823','GLORIA COLOMBIA SA','2024-04-30 06:36:53',  1222.3, 36455, 749, 379),('FVE','FTSV','016678','2024-04-30 06:36:53','042024','CO','22762008','EDUARDO','GUTIERRES','',' 3127802160','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','3','3057.1428571428573','542.8571428571428','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 06:36:54','3600','358','BOD. FARMANORTE 358','1','1100','1100','924.36974789916','175.63025210084','1100','1','0','0','','30/04/2024','',3600,0,0,'7702025100156','GALLETA TOSH MIEL *30 GR','816','GRUPO NUTRESA','2024-04-30 06:36:53',  536.1, 37809, 749, 379),('FVE','FTSV','016679','2024-04-30 07:06:35','042024','CR','1233344025','ANGELLO','NARANJO ROBLES','MANZANA 7 LOTE 19 RANCHO GRAND',' 3244138189','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','317022','1','8900','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 07:15:13','8900','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','0','','30/04/2024','',0,0,8900,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-30 07:06:35',  6610, 54196, 749, 379),('FVE','FTSV','016680','2024-04-30 08:04:41','042024','CO','64577502','ELIZABETH ','MARTINEZ  RAMOS','',' 3043426093','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','7600','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 08:04:41','7600','358','BOD. FARMANORTE 358','1','7600','7600','7600','0','7600','0','1','0','','30/04/2024','',7600,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-04-30 08:04:41',  63045, 31775, 749, 379),('FVE','FTSV','016681','2024-04-30 08:13:04','042024','CO','1102801352','LUISA FERNANDA ','MARQUEZ PEREZ ','0',' 3014386935','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','7','2352.9411764705883','447.0588235294116','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 08:13:05','2800','358','BOD. FARMANORTE 358','7','400','2800','2352.9411764706','447.05882352941','2800','7','0','0','','30/04/2024','',2800,0,0,'7702133414442','TRIDENT MENTA *1.8 GR','754','DISCOB NORTE SAS','2024-04-30 08:13:04',  147.058, 27530, 749, 379),('FVE','FTSV','016682','2024-04-30 08:53:03','042024','CO','1108767698','RAQUEL','BARRIOS','barrio las pe ntilde itas ',' 3125107707','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','4','3109.2436974789916','590.7563025210081','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 08:53:04','3700','358','BOD. FARMANORTE 358','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','30/04/2024','',3700,0,0,'7622201776633','TRIDENT SANDIA *8.5 GR','754','DISCOB NORTE SAS','2024-04-30 08:53:03',  1115.8, 57672, 749, 379),('FVE','FTSV','016682','2024-04-30 08:53:03','042024','CO','1108767698','RAQUEL','BARRIOS','barrio las pe ntilde itas ',' 3125107707','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','4','3109.2436974789916','590.7563025210081','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 08:53:04','3700','358','BOD. FARMANORTE 358','3','500','1500','1260.5042016807','239.49579831933','1500','0','3','0','','30/04/2024','',3700,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-04-30 08:53:03',  9360, 46328, 749, 379),('FVE','FTSV','016683','2024-04-30 09:03:56','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 09:03:57','500','358','BOD. FARMANORTE 358','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/04/2024','',500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-04-30 09:03:56',  9360, 46328, 749, 379);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FTSV','016685','2024-04-30 09:45:57','042024','CO','1102795942','CAROLINA ','MUFARRI','',' 3022497956','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','10','18502.52100840336','1197.4789915966383','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 09:45:58','19700','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',19700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 09:45:57',  100, 44347, 749, 379),('FVE','FTSV','016685','2024-04-30 09:45:57','042024','CO','1102795942','CAROLINA ','MUFARRI','',' 3022497956','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','10','18502.52100840336','1197.4789915966383','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 09:45:58','19700','358','BOD. FARMANORTE 358','6','2000','12000','12000','0','12000','0','6','0','','30/04/2024','',19700,0,0,'650240000010','X RAY DOL *48 TAB','194','GENOMMA LABORATORIO COLOMBIA','2024-04-30 09:45:57',  70566, 49672, 749, 379),('FVE','FTSV','016685','2024-04-30 09:45:57','042024','CO','1102795942','CAROLINA ','MUFARRI','',' 3022497956','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','10','18502.52100840336','1197.4789915966383','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 09:45:58','19700','358','BOD. FARMANORTE 358','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/04/2024','',19700,0,0,'7702001116973','GELATINA BOGGY FRESA VASO *108 GR','110','ALPINA PRODS. ALIMENTICIOS S.A.','2024-04-30 09:45:57',  1417, 53553, 749, 379),('FVE','FTSV','016685','2024-04-30 09:45:57','042024','CO','1102795942','CAROLINA ','MUFARRI','',' 3022497956','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','10','18502.52100840336','1197.4789915966383','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 09:45:58','19700','358','BOD. FARMANORTE 358','1','2400','2400','2016.8067226891','383.19327731092','2400','1','0','0','','30/04/2024','',19700,0,0,'7702001116980','GELATINA BOGGY MORA VASO *108 GR','110','ALPINA PRODS. ALIMENTICIOS S.A.','2024-04-30 09:45:57',  1417, 53693, 749, 379),('FVE','FTSV','016685','2024-04-30 09:45:57','042024','CO','1102795942','CAROLINA ','MUFARRI','',' 3022497956','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','10','18502.52100840336','1197.4789915966383','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 09:45:58','19700','358','BOD. FARMANORTE 358','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','30/04/2024','',19700,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-04-30 09:45:57',  1050.4, 47478, 749, 379),('FVE','FTSV','016686','2024-04-30 10:08:58','042024','CO','9193291','YONY','DAYA','',' 3017568767','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','12','64400','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:08:58','64400','358','BOD. FARMANORTE 358','1','42000','42000','42000','0','42000','1','0','0','','30/04/2024','',64400,0,0,'7708109834184','COLLAGENFIT COLAGENO HIDROLIZADO X 700G','1000','NATURALMENTE','2024-04-30 10:08:58',  20000, 60996, 749, 379),('FVE','FTSV','016686','2024-04-30 10:08:58','042024','CO','9193291','YONY','DAYA','',' 3017568767','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','12','64400','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:08:58','64400','358','BOD. FARMANORTE 358','10','2220','22200','22200','0','22200','0','10','0','','30/04/2024','',64400,0,0,'7703153031251','TRIMEBUTINA+SIMETICONA 200MG/120MG CJA *30 TAB','422','COLMED','2024-04-30 10:08:58',  42658.8, 54483, 749, 379),('FVE','FTSV','016686','2024-04-30 10:08:58','042024','CO','9193291','YONY','DAYA','',' 3017568767','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','12','64400','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:08:58','64400','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',64400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 10:08:58',  100, 44347, 749, 379),('FVE','FTSV','016687','2024-04-30 10:19:35','042024','CO','1102868856','JORGE','CAMARGO','',' 0','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:19:35','4000','358','BOD. FARMANORTE 358','2','2000','4000','3361.3445378151','638.65546218487','4000','2','0','0','','30/04/2024','',4000,0,0,'7707228360239','GUANTE CIRUGIA ESTERIL T/7','429','ALFA SAFE','2024-04-30 10:19:35',  1375, 62083, 749, 379),('FVE','FTSV','016688','2024-04-30 10:36:59','042024','CO','37251400','DORIS ','PEREZ','sincelejo','0 3000000000','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','5','11796.638655462186','2203.361344537814','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:37:05','14000','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,14000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 10:36:59',  100, 44347, 749, 379),('FVE','FTSV','016688','2024-04-30 10:36:59','042024','CO','37251400','DORIS ','PEREZ','sincelejo','0 3000000000','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','5','11796.638655462186','2203.361344537814','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:37:05','14000','358','BOD. FARMANORTE 358','1','4900','4900','4117.6470588235','782.35294117647','4900','1','0','0','','30/04/2024','',0,14000,0,'7702535011706','QUATRO TORONJA *1.5 LT','144','COCA COLA','2024-04-30 10:36:59',  3025.2, 37030, 749, 379),('FVE','FTSV','016688','2024-04-30 10:36:59','042024','CO','37251400','DORIS ','PEREZ','sincelejo','0 3000000000','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','5','11796.638655462186','2203.361344537814','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:37:05','14000','358','BOD. FARMANORTE 358','1','6900','6900','5798.3193277311','1101.6806722689','6900','1','0','0','','30/04/2024','',0,14000,0,'7702189053848','PAPAS MARGARITA TOMATE *105 GR','762','FRITO LAY','2024-04-30 10:36:59',  4629, 54640, 749, 379),('FVE','FTSV','016688','2024-04-30 10:36:59','042024','CO','37251400','DORIS ','PEREZ','sincelejo','0 3000000000','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','5','11796.638655462186','2203.361344537814','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:37:05','14000','358','BOD. FARMANORTE 358','2','1000','2000','1680.6722689076','319.32773109244','2000','2','0','0','','30/04/2024','',0,14000,0,'77010148','JET CHOCOLATINA *12 GR','816','GRUPO NUTRESA','2024-04-30 10:36:59',  632.88, 47412, 749, 379),('FVE','FTSV','016689','2024-04-30 10:54:16','042024','CO','1005441727','CARLOS ','ROMERO ','',' 3205534615','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','4000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:54:18','4000','358','BOD. FARMANORTE 358','2','2000','4000','4000','0','4000','2','0','0','','30/04/2024','',4000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-30 10:54:16',  800, 48019, 749, 379),('FVE','FTSV','016690','2024-04-30 10:58:04','042024','CO','92545932','JUAN','TRUJILLO ','',' 3002161684','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','12','18649.579831932773','750.4201680672268','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:58:05','19400','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',19400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 10:58:04',  100, 44347, 749, 379),('FVE','FTSV','016690','2024-04-30 10:58:04','042024','CO','92545932','JUAN','TRUJILLO ','',' 3002161684','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','12','18649.579831932773','750.4201680672268','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:58:05','19400','358','BOD. FARMANORTE 358','1','14500','14500','14500','0','14500','1','0','0','','30/04/2024','',19400,0,0,'7702057070939','AZITROMICINA 500 MG * 3 TAB','654','MK ETICOS CONVENIO','2024-04-30 10:58:04',  10217.3, 42809, 749, 379),('FVE','FTSV','016690','2024-04-30 10:58:04','042024','CO','92545932','JUAN','TRUJILLO ','',' 3002161684','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','12','18649.579831932773','750.4201680672268','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 10:58:05','19400','358','BOD. FARMANORTE 358','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','30/04/2024','',19400,0,0,'7702184835982','VITAMINA C + ZINC TUTI FRUTI * 100 TAB','249','ECAR','2024-04-30 10:58:04',  15435, 58540, 749, 379),('FVE','FTSV','016691','2024-04-30 11:12:12','042024','CO','2759289','ALEXANDER ','PEREZ ','kr28A#24D-32 BARRIO LA TOSCANA',' 3007649060','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','3','387200','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 11:12:12','387200','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',387200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 11:12:12',  100, 44347, 749, 379),('FVE','FTSV','016691','2024-04-30 11:12:12','042024','CO','2759289','ALEXANDER ','PEREZ ','kr28A#24D-32 BARRIO LA TOSCANA',' 3007649060','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','3','387200','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 11:12:12','387200','358','BOD. FARMANORTE 358','1','385000','385000','385000','0','385000','1','0','0','59','30/04/2024','',387200,0,0,'7703153036034','LIPOMEGA PS 20 MG *60 CAP','910','PROCAPS RX','2024-04-30 11:12:12',  334600, 56699, 749, 379),('FVE','FTSV','016691','2024-04-30 11:12:12','042024','CO','2759289','ALEXANDER ','PEREZ ','kr28A#24D-32 BARRIO LA TOSCANA',' 3007649060','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','3','387200','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 11:12:12','387200','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',387200,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-30 11:12:12',  1500, 44348, 749, 379),('FVE','FTSV','016692','2024-04-30 12:19:00','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','37500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:19:01','37500','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',37500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 12:19:00',  100, 44347, 749, 379),('FVE','FTSV','016692','2024-04-30 12:19:00','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','37500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:19:01','37500','358','BOD. FARMANORTE 358','2','7600','15200','15200','0','15200','0','2','0','','30/04/2024','',37500,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-04-30 12:19:00',  63045, 31775, 749, 379),('FVE','FTSV','016692','2024-04-30 12:19:00','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','37500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:19:01','37500','358','BOD. FARMANORTE 358','2','5600','11200','11200','0','11200','0','2','0','','30/04/2024','',37500,0,0,'7709990568288','DIOSMIT 3GR CAJA *6 SOBRES','313','NTI (NEW TRADE INTERNATIONAL)','2024-04-30 12:19:00',  14100, 54384, 749, 379),('FVE','FTSV','016692','2024-04-30 12:19:00','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','37500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:19:01','37500','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','0','','30/04/2024','',37500,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-30 12:19:00',  6610, 54196, 749, 379),('FVE','FTSV','016692','2024-04-30 12:19:00','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','37500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:19:01','37500','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',37500,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-30 12:19:00',  1500, 44348, 749, 379),('FVE','FTSV','016693','2024-04-30 12:24:52','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','38380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:24:52','38380','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','1','','30/04/2024','',38380,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 12:24:52',  100, 44347, 749, 379),('FVE','FTSV','016693','2024-04-30 12:24:52','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','38380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:24:52','38380','358','BOD. FARMANORTE 358','2','6040','12080','12080','0','12080','0','2','1','','30/04/2024','',38380,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-04-30 12:24:52',  53223.5, 41855, 749, 379),('FVE','FTSV','016693','2024-04-30 12:24:52','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','38380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:24:52','38380','358','BOD. FARMANORTE 358','2','7600','15200','15200','0','15200','0','2','1','','30/04/2024','',38380,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-04-30 12:24:52',  63045, 31775, 749, 379),('FVE','FTSV','016693','2024-04-30 12:24:52','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','38380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:24:52','38380','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','1','','30/04/2024','',38380,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-30 12:24:52',  6610, 54196, 749, 379),('FVE','FTSV','016693','2024-04-30 12:24:52','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','7','38380','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:24:52','38380','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','1','','30/04/2024','',38380,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-30 12:24:52',  1500, 44348, 749, 379),('FVE','FTSV','016694','2024-04-30 12:30:20','042024','CO','1103095731','MARIO ','QUIROZ ','',' 3012007115','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','5500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:30:20','5500','358','BOD. FARMANORTE 358','1','5500','5500','5500','0','5500','0','1','0','','30/04/2024','',5500,0,0,'7500435107020','VICK VAPORUB 12 GR *12 LATAS','820','PROCTER & GAMBLE CHC','2024-04-30 12:30:20',  56858, 40253, 749, 379),('FVE','FTSV','016695','2024-04-30 12:58:22','042024','CO','1118850876','DANIEL','MORELO','barrio sevilla ',' 3043080760','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','37200','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 12:58:22','37200','358','BOD. FARMANORTE 358','1','37200','37200','37200','0','37200','1','0','0','2','30/04/2024','',0,37200,0,'7501058631121','BABY KLIM 1+ LATA *400 GR','311','NESTLE NUTRICION','2024-04-30 12:58:22',  33718, 51305, 749, 379),('FVE','FTSV','016696','2024-04-30 13:03:03','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','5500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 13:03:03','5500','358','BOD. FARMANORTE 358','1','5500','5500','5500','0','5500','0','1','0','','30/04/2024','',5500,0,0,'7500435107020','VICK VAPORUB 12 GR *12 LATAS','820','PROCTER & GAMBLE CHC','2024-04-30 13:03:03',  56858, 40253, 749, 379),('FVE','FTSV','016697','2024-04-30 13:13:08','042024','CO','1108767250','YURIS DAYANA ','RIOS RIVERA ','',' 3013080475','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','3949.5798319327732','750.4201680672268','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 13:13:08','4700','358','BOD. FARMANORTE 358','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',4700,0,0,'7702189055552','DETODITO NATURAL *50 GR','762','FRITO LAY','2024-04-30 13:13:08',  1811, 56444, 749, 379),('FVE','FTSV','016697','2024-04-30 13:13:08','042024','CO','1108767250','YURIS DAYANA ','RIOS RIVERA ','',' 3013080475','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','3949.5798319327732','750.4201680672268','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 13:13:08','4700','358','BOD. FARMANORTE 358','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','30/04/2024','',4700,0,0,'7702090051575','NATU MALTA BOTELLA *200 ML','192','POSTOBON GASEOSAS','2024-04-30 13:13:08',  910.3641, 54814, 749, 379),('FVE','FTSV','016698','2024-04-30 13:46:31','042024','CO','78024161','ADOLFO ','GARCES','SINCELEJO',' 3148944573 3148944573','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','30000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 13:46:31','30000','358','BOD. FARMANORTE 358','1','30000','30000','30000','0','30000','1','0','0','','30/04/2024','',0,30000,0,'7709214528746','VIMAX JARABE X 240ML','1000','NATURALMENTE','2024-04-30 13:46:31',  7000, 60283, 749, 379),('FVE','FTSV','016699','2024-04-30 14:03:37','042024','CO','1143349973','LAURA','BALLESTERO','Kra 50 #27-100 apto 101A edifi',' 3046332415 3046332415','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','15','33500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:03:37','33500','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,33500,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 14:03:37',  100, 44347, 749, 379),('FVE','FTSV','016699','2024-04-30 14:03:37','042024','CO','1143349973','LAURA','BALLESTERO','Kra 50 #27-100 apto 101A edifi',' 3046332415 3046332415','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','15','33500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:03:37','33500','358','BOD. FARMANORTE 358','2','2700','5400','5400','0','5400','0','2','0','','30/04/2024','',0,33500,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-04-30 14:03:37',  33370, 62346, 749, 379),('FVE','FTSV','016699','2024-04-30 14:03:37','042024','CO','1143349973','LAURA','BALLESTERO','Kra 50 #27-100 apto 101A edifi',' 3046332415 3046332415','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','15','33500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:03:37','33500','358','BOD. FARMANORTE 358','10','1500','15000','15000','0','15000','0','10','0','','30/04/2024','',0,33500,0,'7707263004051','GRIPAC 4 * 100 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-04-30 14:03:37',  94299, 58014, 749, 379),('FVE','FTSV','016699','2024-04-30 14:03:37','042024','CO','1143349973','LAURA','BALLESTERO','Kra 50 #27-100 apto 101A edifi',' 3046332415 3046332415','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3461','JOSé EDUARDO ','MENDOZA MONTERROZA ','','','','','','15','33500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:03:37','33500','358','BOD. FARMANORTE 358','1','10900','10900','10900','0','10900','1','0','0','','30/04/2024','',0,33500,0,'7706569001450','NAPROXENO 500 MG *10 TAB','614','A.G. MEDICAMENTOS','2024-04-30 14:03:37',  8563, 31632, 749, 379);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FTSV','016700','2024-04-30 14:17:44','042024','CO','1102880905','LINA','SANCHEZ','barrio vida ',' 3222222222','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','3393.27731092437','606.7226890756303','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:17:44','4000','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,4000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 14:17:44',  100, 44347, 749, 379),('FVE','FTSV','016700','2024-04-30 14:17:44','042024','CO','1102880905','LINA','SANCHEZ','barrio vida ',' 3222222222','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','3393.27731092437','606.7226890756303','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:17:44','4000','358','BOD. FARMANORTE 358','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/04/2024','',0,4000,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2024-04-30 14:17:44',  1956.4, 34397, 749, 379),('FVE','FTSV','016700','2024-04-30 14:17:44','042024','CO','1102880905','LINA','SANCHEZ','barrio vida ',' 3222222222','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','3393.27731092437','606.7226890756303','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:17:44','4000','358','BOD. FARMANORTE 358','1','700','700','588.23529411765','111.76470588235','700','1','0','0','','30/04/2024','',0,4000,0,'7702025136049  ','SALTIN NOEL ROJA * 216 GR','816','GRUPO NUTRESA','2024-04-30 14:17:44',  437.1111, 53641, 749, 379),('FVE','FTSV','016701','2024-04-30 14:20:24','042024','CO','92641555','DAIRO','MEZA','',' 3042061181','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','63460.50420168067','239.4957983193276','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:20:27','63700','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,63700,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 14:20:24',  100, 44347, 749, 379),('FVE','FTSV','016701','2024-04-30 14:20:24','042024','CO','92641555','DAIRO','MEZA','',' 3042061181','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','63460.50420168067','239.4957983193276','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:20:27','63700','358','BOD. FARMANORTE 358','1','62000','62000','62000','0','62000','1','0','0','','30/04/2024','',0,63700,0,'7707239275737','FREEGEN *15 ML GTS 10 ML','175','ESPECIALIDADES OFTALMOLOGICAS','2024-04-30 14:20:24',  65060, 25352, 749, 379),('FVE','FTSV','016701','2024-04-30 14:20:24','042024','CO','92641555','DAIRO','MEZA','',' 3042061181','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','63460.50420168067','239.4957983193276','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 14:20:27','63700','358','BOD. FARMANORTE 358','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','30/04/2024','',0,63700,0,'7622300124526','GALLETA RITZ SANDWICH QUESO *30 GR','754','DISCOB NORTE SAS','2024-04-30 14:20:24',  924.4, 35207, 749, 379),('FVE','FTSV','016702','2024-04-30 15:00:02','042024','CO','1005625562','FRANCO','CAPUTO','',' 3005984543','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','2','26600','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:00:02','26600','358','BOD. FARMANORTE 358','1','24500','24500','24500','0','24500','1','0','0','','30/04/2024','',26600,0,0,'7702560000102','CITROMEL *310 ML ','219','JGB','2024-04-30 15:00:02',  18540.5, 27805, 749, 379),('FVE','FTSV','016702','2024-04-30 15:00:02','042024','CO','1005625562','FRANCO','CAPUTO','',' 3005984543','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','2','26600','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:00:02','26600','358','BOD. FARMANORTE 358','1','2100','2100','2100','0','2100','1','0','0','','30/04/2024','',26600,0,0,'7702090023008','AGUA CRISTAL CON GAS BOTELLA * 600ML','192','POSTOBON GASEOSAS','2024-04-30 15:00:02',  1254.2, 27731, 749, 379),('FVE','FTSV','016703','2024-04-30 15:21:00','042024','CO','1193072336','JESUS','ENAMORADO','',' 3006043834','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','2','840.3361344537816','159.6638655462184','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:21:02','1000','358','BOD. FARMANORTE 358','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','30/04/2024','',1000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-04-30 15:21:00',  9360, 46328, 749, 379),('FVE','FTSV','016704','2024-04-30 15:52:11','042024','CO','1100623937','ANDREA','ACU ntilde A ','COASMEDA ',' 3107293188','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','10252.100840336136','1947.899159663865','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:52:37','12200','358','BOD. FARMANORTE 358','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/04/2024','',12200,0,0,'7702189030122','PAPAS MARGARITA NATURAL *36 GR','762','FRITO LAY','2024-04-30 15:52:11',  1449, 36676, 749, 379),('FVE','FTSV','016704','2024-04-30 15:52:11','042024','CO','1100623937','ANDREA','ACU ntilde A ','COASMEDA ',' 3107293188','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','10252.100840336136','1947.899159663865','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:52:37','12200','358','BOD. FARMANORTE 358','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/04/2024','',12200,0,0,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2024-04-30 15:52:11',  1159, 58744, 749, 379),('FVE','FTSV','016704','2024-04-30 15:52:11','042024','CO','1100623937','ANDREA','ACU ntilde A ','COASMEDA ',' 3107293188','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','10252.100840336136','1947.899159663865','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:52:37','12200','358','BOD. FARMANORTE 358','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','0','','30/04/2024','',12200,0,0,'7702402856010','CHOCOCONO + FLOW *95 GR','296','MEALS DE COLOMBIA','2024-04-30 15:52:11',  1837.5, 32599, 749, 379),('FVE','FTSV','016704','2024-04-30 15:52:11','042024','CO','1100623937','ANDREA','ACU ntilde A ','COASMEDA ',' 3107293188','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','10252.100840336136','1947.899159663865','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:52:37','12200','358','BOD. FARMANORTE 358','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','30/04/2024','',12200,0,0,'7702007080681','JET CHOCOLATINA DE LECHE *25 GR','816','GRUPO NUTRESA','2024-04-30 15:52:11',  1483.7, 35626, 749, 379),('FVE','FTSV','016704','2024-04-30 15:52:11','042024','CO','1100623937','ANDREA','ACU ntilde A ','COASMEDA ',' 3107293188','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','5','10252.100840336136','1947.899159663865','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 15:52:37','12200','358','BOD. FARMANORTE 358','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/04/2024','',12200,0,0,'7702189055484','NATUCHIPS PLATANO MADURO *38 GR','762','FRITO LAY','2024-04-30 15:52:11',  1449, 56938, 749, 379),('FVE','FTSV','016705','2024-04-30 16:01:17','042024','CO','1102803533','FERNANDO ','DIAZ ','',' 3052347601','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','7373.1092436974795','526.8907563025209','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:01:19','7900','358','BOD. FARMANORTE 358','1','4600','4600','4600','0','4600','0','1','0','','30/04/2024','',7900,0,0,'7707263003986','O.K.A.P 37.5MG/325MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-04-30 16:01:17',  27780, 54056, 749, 379),('FVE','FTSV','016705','2024-04-30 16:01:17','042024','CO','1102803533','FERNANDO ','DIAZ ','',' 3052347601','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','7373.1092436974795','526.8907563025209','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:01:19','7900','358','BOD. FARMANORTE 358','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/04/2024','',7900,0,0,'7702189056009','CHOCLITOS LIMÓN *45 GR','762','FRITO LAY','2024-04-30 16:01:17',  1159, 57047, 749, 379),('FVE','FTSV','016705','2024-04-30 16:01:17','042024','CO','1102803533','FERNANDO ','DIAZ ','',' 3052347601','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','7373.1092436974795','526.8907563025209','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:01:19','7900','358','BOD. FARMANORTE 358','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','30/04/2024','',7900,0,0,'7702090051575','NATU MALTA BOTELLA *200 ML','192','POSTOBON GASEOSAS','2024-04-30 16:01:17',  910.3641, 54814, 749, 379),('FVE','FTSV','016706','2024-04-30 16:06:41','042024','CO','1003408708','JOSE ','GONZALES ','',' 3015225536','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','9600','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:06:43','9600','358','BOD. FARMANORTE 358','1','9600','9600','9600','0','9600','1','0','0','','30/04/2024','',9600,0,0,'7703186577030','PEDIALYTE 30 CEREZA *500 ML','659','ABBOTT NUTRICION','2024-04-30 16:06:41',  8380, 22268, 749, 379),('FVE','FTSV','016707','2024-04-30 16:32:36','042024','CO','92540698','JAIME ARTURO','NARANJO VASQUEZ','cr38a #23-37 barrio florencia ',' 3046467952','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','2','15200','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:32:37','15200','358','BOD. FARMANORTE 358','2','7600','15200','15200','0','15200','0','2','0','','30/04/2024','',10200,5000,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-04-30 16:32:36',  63045, 31775, 749, 379),('FVE','FTSV','016708','2024-04-30 16:34:05','042024','CO','1102845817','DARWIN ','LANBRA Ntilde O','',' 3122744550','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','1','5126.050420168068','973.9495798319322','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:34:06','6100','358','BOD. FARMANORTE 358','1','6100','6100','5126.0504201681','973.94957983193','6100','1','0','0','','30/04/2024','',6100,0,0,'7702535011799','COCA COLA ZERO *1.5 LT','144','COCA COLA','2024-04-30 16:34:05',  3770.75, 34406, 749, 379),('FVE','FTSV','016709','2024-04-30 16:59:56','042024','CO','64699247','KAROLINA ','OSPINA ','KR27A#23A-16 BARRIO LA TOSCANA',' 3142115029','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','6','134215.12605042016','534.8739495798317','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:59:56','134750','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',134750,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 16:59:56',  100, 44347, 749, 379),('FVE','FTSV','016709','2024-04-30 16:59:56','042024','CO','64699247','KAROLINA ','OSPINA ','KR27A#23A-16 BARRIO LA TOSCANA',' 3142115029','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','6','134215.12605042016','534.8739495798317','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:59:56','134750','358','BOD. FARMANORTE 358','1','125000','125000','125000','0','125000','1','0','0','','30/04/2024','',134750,0,0,'D1012','PULMICORT 0.5 MG *5 RESPULES','117','ASTRAZENECA COLOMBIA','2024-04-30 16:59:56',  112621, 22772, 749, 379),('FVE','FTSV','016709','2024-04-30 16:59:56','042024','CO','64699247','KAROLINA ','OSPINA ','KR27A#23A-16 BARRIO LA TOSCANA',' 3142115029','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','6','134215.12605042016','534.8739495798317','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:59:56','134750','358','BOD. FARMANORTE 358','1','4200','4200','4200','0','4200','1','0','0','','30/04/2024','',134750,0,0,'7705366903028','CLORURO DE SODIO S.S. 9% *500 ML ','156','CORPAUL','2024-04-30 16:59:56',  3653.8, 58440, 749, 379),('FVE','FTSV','016709','2024-04-30 16:59:56','042024','CO','64699247','KAROLINA ','OSPINA ','KR27A#23A-16 BARRIO LA TOSCANA',' 3142115029','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','6','134215.12605042016','534.8739495798317','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:59:56','134750','358','BOD. FARMANORTE 358','1','850','850','714.28571428571','135.71428571429','850','1','0','0','','30/04/2024','',134750,0,0,'7707282990298','JERINGA 10ML DESECHABLE 21 GR *1 1/2','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-04-30 16:59:56',  256.9, 63651, 749, 379),('FVE','FTSV','016709','2024-04-30 16:59:56','042024','CO','64699247','KAROLINA ','OSPINA ','KR27A#23A-16 BARRIO LA TOSCANA',' 3142115029','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','6','134215.12605042016','534.8739495798317','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:59:56','134750','358','BOD. FARMANORTE 358','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/04/2024','',134750,0,0,'7702189055453','NATUCHIPS PLATANO VERDE *38 GR','762','FRITO LAY','2024-04-30 16:59:56',  1479, 57247, 749, 379),('FVE','FTSV','016709','2024-04-30 16:59:56','042024','CO','64699247','KAROLINA ','OSPINA ','KR27A#23A-16 BARRIO LA TOSCANA',' 3142115029','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','3107','ESTITH DAVID','AYALA MONTERROSA','','','','','','6','134215.12605042016','534.8739495798317','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 16:59:56','134750','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',134750,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-30 16:59:56',  1500, 44348, 749, 379),('FVE','FTSV','016710','2024-04-30 17:00:46','042024','CO','92529484','FABIO ','RUIZ ','SINCELEJO ',' 3235411317','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','578444','92555071','PATERNINA BALETA HENRY ANTONIO','','','1','58000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:00:46','58000','358','BOD. FARMANORTE 358','1','58000','58000','58000','0','58000','1','0','0','','30/04/2024','',58000,0,0,'7703283403928','ALDACTONE 25 MG *30 TAB','326','PFIZER FARMA','2024-04-30 17:00:46',  44200, 39004, 749, 379),('FVE','FTSV','016711','2024-04-30 17:11:48','042024','CO','1102872298','JEAN CARLOS','ROMERO GONZALES','CRA 24F #6D-30 CASA DE REJAS N',' 3006030506','3540','JESUS ERNESTO','ANICHARICO LOPEZ','3602','YEISON EDUARDO','GONZALEZ MENDEZ','','','','','','6','31023.529411764706','5476.470588235293','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:11:48','36500','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',36500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 17:11:48',  100, 44347, 749, 379),('FVE','FTSV','016711','2024-04-30 17:11:48','042024','CO','1102872298','JEAN CARLOS','ROMERO GONZALES','CRA 24F #6D-30 CASA DE REJAS N',' 3006030506','3540','JESUS ERNESTO','ANICHARICO LOPEZ','3602','YEISON EDUARDO','GONZALEZ MENDEZ','','','','','','6','31023.529411764706','5476.470588235293','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:11:48','36500','358','BOD. FARMANORTE 358','1','15500','15500','13025.210084034','2474.7899159664','15500','1','0','0','','30/04/2024','',36500,0,0,'099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-04-30 17:11:48',  8195.0405, 24473, 749, 379),('FVE','FTSV','016711','2024-04-30 17:11:48','042024','CO','1102872298','JEAN CARLOS','ROMERO GONZALES','CRA 24F #6D-30 CASA DE REJAS N',' 3006030506','3540','JESUS ERNESTO','ANICHARICO LOPEZ','3602','YEISON EDUARDO','GONZALEZ MENDEZ','','','','','','6','31023.529411764706','5476.470588235293','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:11:48','36500','358','BOD. FARMANORTE 358','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','30/04/2024','',36500,0,0,'7702031407362','JOHNSON JABON ALMENDRAS Y AVENA ADULTO *110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-04-30 17:11:48',  2689.775, 28080, 749, 379),('FVE','FTSV','016711','2024-04-30 17:11:48','042024','CO','1102872298','JEAN CARLOS','ROMERO GONZALES','CRA 24F #6D-30 CASA DE REJAS N',' 3006030506','3540','JESUS ERNESTO','ANICHARICO LOPEZ','3602','YEISON EDUARDO','GONZALEZ MENDEZ','','','','','','6','31023.529411764706','5476.470588235293','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:11:48','36500','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',36500,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-30 17:11:48',  1500, 44348, 749, 379),('FVE','FTSV','016711','2024-04-30 17:11:48','042024','CO','1102872298','JEAN CARLOS','ROMERO GONZALES','CRA 24F #6D-30 CASA DE REJAS N',' 3006030506','3540','JESUS ERNESTO','ANICHARICO LOPEZ','3602','YEISON EDUARDO','GONZALEZ MENDEZ','','','','','','6','31023.529411764706','5476.470588235293','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:11:48','36500','358','BOD. FARMANORTE 358','1','6900','6900','5798.3193277311','1101.6806722689','6900','1','0','0','','30/04/2024','',36500,0,0,'7702189053831','PAPAS MARGARITA MAYONESA *105 GR','762','FRITO LAY','2024-04-30 17:11:48',  4629, 54416, 749, 379),('FVE','FTSV','016711','2024-04-30 17:11:48','042024','CO','1102872298','JEAN CARLOS','ROMERO GONZALES','CRA 24F #6D-30 CASA DE REJAS N',' 3006030506','3540','JESUS ERNESTO','ANICHARICO LOPEZ','3602','YEISON EDUARDO','GONZALEZ MENDEZ','','','','','','6','31023.529411764706','5476.470588235293','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:11:48','36500','358','BOD. FARMANORTE 358','1','8000','8000','6722.6890756303','1277.3109243697','8000','1','0','0','','30/04/2024','',36500,0,0,'7705326002044','PONQUE CASERO TRES LECHES *220 GR','126','BIMBO DE COLOMBIA S.A.','2024-04-30 17:11:48',  4855, 58078, 749, 379),('FVE','FTSV','016712','2024-04-30 17:18:50','042024','CO','1104428563','JAIME ANDR eacute S ','RAM iacute REZ RODR iacute GUEZ ','MANZANA BQ 3APTO 401',' 3108186261','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','2521.008403361345','478.9915966386552','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:18:51','3000','358','BOD. FARMANORTE 358','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','1','','30/04/2024','',3000,0,0,'7702090041989','SPEED MAX LATA *473 ML','192','POSTOBON GASEOSAS','2024-04-30 17:18:50',  1750.7, 49222, 749, 379),('FVE','FTSV','016713','2024-04-30 17:24:09','042024','CO','15443518','EFREN','LOPEZ','CLL 24D #27A-49 MIRADOR DE VEN',' 3112360794','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','4','8267.226890756303','1532.773109243697','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:24:09','9800','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,9800,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 17:24:09',  100, 44347, 749, 379),('FVE','FTSV','016713','2024-04-30 17:24:09','042024','CO','15443518','EFREN','LOPEZ','CLL 24D #27A-49 MIRADOR DE VEN',' 3112360794','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','4','8267.226890756303','1532.773109243697','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:24:09','9800','358','BOD. FARMANORTE 358','3','3200','9600','8067.2268907563','1532.7731092437','9600','3','0','0','','30/04/2024','',0,9800,0,'7702402856010','CHOCOCONO + FLOW *95 GR','296','MEALS DE COLOMBIA','2024-04-30 17:24:09',  1837.5, 32599, 749, 379),('FVE','FTSV','016714','2024-04-30 17:27:46','042024','CO','1102881949','ANGIE','OYOLA','Calle 42 #17E - 49',' 3173919472','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','1','1596.638655462185','303.36134453781506','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:27:47','1900','358','BOD. FARMANORTE 358','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/04/2024','',1900,0,0,'7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2024-04-30 17:27:46',  1142.8, 60397, 749, 379),('FVE','FTSV','016715','2024-04-30 17:30:08','042024','CO','1102884961','ANDRES FELIPE ','RIVERO ','BARRIO PUERTA ROJA ',' 3005303194','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','6600','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:30:08','6600','358','BOD. FARMANORTE 358','1','6600','6600','6600','0','6600','1','0','0','20','30/04/2024','',6600,0,0,'7703331105118','MICROGYNON SUAVE *21 GRAG','380','TECNOFARMA','2024-04-30 17:30:08',  5647, 40562, 749, 379),('FVE','FTSV','016716','2024-04-30 17:37:28','042024','CO','30584082','GIZELA ','MISGER ','el socoro',' 3015018520','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','3193.27731092437','606.7226890756301','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:37:28','3800','358','BOD. FARMANORTE 358','1','3800','3800','3193.2773109244','606.72268907563','3800','1','0','0','','30/04/2024','',3800,0,0,'7705326053206','MARINELA PINGUINOS *80 GR','126','BIMBO DE COLOMBIA S.A.','2024-04-30 17:37:28',  2177, 23425, 749, 379),('FVE','FTSV','016717','2024-04-30 17:41:28','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:41:29','3100','358','BOD. FARMANORTE 358','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/04/2024','',3100,0,0,'7702090029864','HIT MANGO *500 ML','192','POSTOBON GASEOSAS','2024-04-30 17:41:28',  1750.42, 35518, 749, 379);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID) VALUES ('FVE','FTSV','016718','2024-04-30 17:45:43','042024','CO','30584082','GIZELA ','MISGER ','el socoro',' 3015018520','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','3445.3781512605046','654.6218487394956','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 17:45:43','4100','358','BOD. FARMANORTE 358','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','30/04/2024','',4100,0,0,'7705326070371','CHOCOSO TRADICIONAL BIMBO *65 GR','126','BIMBO DE COLOMBIA S.A.','2024-04-30 17:45:43',  1327, 57069, 749, 379),('FVE','FTSV','016719','2024-04-30 18:14:38','042024','CO','43416508','GLORIA ','HIGUITA ','BARRIO LOS TEJARES ',' 3222222222','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','19500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 18:14:38','19500','358','BOD. FARMANORTE 358','1','17500','17500','17500','0','17500','1','0','0','27','30/04/2024','',19500,0,0,'7702123006800','ASPIRINA 100 MG CJA *28 TAB','631','BAYER OTC','2024-04-30 18:14:38',  13580, 33646, 749, 379),('FVE','FTSV','016719','2024-04-30 18:14:38','042024','CO','43416508','GLORIA ','HIGUITA ','BARRIO LOS TEJARES ',' 3222222222','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','2','19500','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 18:14:38','19500','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',19500,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-04-30 18:14:38',  800, 48019, 749, 379),('DVE','F358','00020','2024-04-30 18:29:13','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','CAMBIO POR FRA 16693','006','1','35300','0','358','FARMANORTE 358','AUDITORIA','2024-04-30 18:29:13','35300','358','BOD. FARMANORTE 358','0.2','7600','15200','15200','0','15200','0','2','0','','30/04/2024','30/04/2024',0,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-04-30 18:29:13',  63045, 31775, 749, 379),('DVE','F358','00020','2024-04-30 18:29:13','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','CAMBIO POR FRA 16693','006','1','35300','0','358','FARMANORTE 358','AUDITORIA','2024-04-30 18:29:13','35300','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','0','','30/04/2024','30/04/2024',0,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-30 18:29:13',  6610, 54196, 749, 379),('DVE','F358','00020','2024-04-30 18:29:13','042024','CO','1102869265','MARIA JOSE ','GARCIA','Carrera 34 # 23 - 16 Florencia',' 3217575259','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','CAMBIO POR FRA 16693','006','1','35300','0','358','FARMANORTE 358','AUDITORIA','2024-04-30 18:29:13','35300','358','BOD. FARMANORTE 358','0.33333333333333','5600','11200','11200','0','11200','0','2','0','','30/04/2024','30/04/2024',0,0,0,'7709990568288','DIOSMIT 3GR CAJA *6 SOBRES','313','NTI (NEW TRADE INTERNATIONAL)','2024-04-30 18:29:13',  14100, 54384, 749, 379),('FVE','FTSV','016720','2024-04-30 18:38:41','042024','CO','53120863','ADRIANA','IRIARTE','',' 3016261532','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','15','17000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 18:38:42','17000','358','BOD. FARMANORTE 358','10','800','8000','8000','0','8000','0','10','0','','30/04/2024','',17000,0,0,'7451079000669,7','DOLEX 500 MG *200 TAB','616','HALEON (GLAXO OTC)','2024-04-30 18:38:41',  125586, 26516, 749, 379),('FVE','FTSV','016720','2024-04-30 18:38:41','042024','CO','53120863','ADRIANA','IRIARTE','',' 3016261532','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','15','17000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 18:38:42','17000','358','BOD. FARMANORTE 358','5','1800','9000','9000','0','9000','0','5','0','','30/04/2024','',17000,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-04-30 18:38:41',  111600, 43550, 749, 379),('FVE','FTSV','016721','2024-04-30 18:45:04','042024','CO','12533818','PAOLA','ALVAREZ','',' 3017756757','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','4','3200','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 18:45:04','3200','358','BOD. FARMANORTE 358','4','800','3200','3200','0','3200','0','4','0','','30/04/2024','',3200,0,0,'7702132004484','MAREOL *72 TAB','616','HALEON (GLAXO OTC)','2024-04-30 18:45:04',  41636, 39116, 749, 379),('FVE','FTSV','016722','2024-04-30 19:11:58','042024','CO','3860268','ROBERTO ','GAMARRA ','',' 3208727531','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','3','30100','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:11:59','30100','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',30100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 19:11:58',  100, 44347, 749, 379),('FVE','FTSV','016722','2024-04-30 19:11:58','042024','CO','3860268','ROBERTO ','GAMARRA ','',' 3208727531','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','3','30100','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:11:59','30100','358','BOD. FARMANORTE 358','1','21900','21900','21900','0','21900','1','0','0','','30/04/2024','',30100,0,0,'7707263005188','ACED FULL MENTA * 360 ML /D14/','387','TRIDEX FARMACEUTICA','2024-04-30 19:11:58',  10495, 59332, 749, 379),('FVE','FTSV','016722','2024-04-30 19:11:58','042024','CO','3860268','ROBERTO ','GAMARRA ','',' 3208727531','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','3','30100','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:11:59','30100','358','BOD. FARMANORTE 358','1','8000','8000','8000','0','8000','1','0','0','','30/04/2024','',30100,0,0,'7702057073930','MAGNESIA *120 ML','382','TECNOQUIMICAS','2024-04-30 19:11:58',  5982.67, 43118, 749, 379),('FVE','FTSV','016723','2024-04-30 19:14:06','042024','CO','64871288','SAMARA','PEREZ VASQUEZ','CL 23 #30A -31 FLORENCIA',' 3044039442','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','1','8900','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:14:06','8900','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','0','','30/04/2024','',8900,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-30 19:14:06',  6610, 54196, 749, 379),('FVE','FTSV','016724','2024-04-30 19:28:27','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','13045.378151260506','654.6218487394958','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:28:27','13700.000000000002','358','BOD. FARMANORTE 358','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/04/2024','',13700,0,0,'7702090029857','HIT MORA *500 ML','192','POSTOBON GASEOSAS','2024-04-30 19:28:27',  1750.7, 35520, 749, 379),('FVE','FTSV','016724','2024-04-30 19:28:27','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','13045.378151260506','654.6218487394958','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:28:27','13700.000000000002','358','BOD. FARMANORTE 358','1','9600','9600','9600','0','9600','1','0','0','','30/04/2024','',13700,0,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-04-30 19:28:27',  8380, 22278, 749, 379),('FVE','FTSV','016724','2024-04-30 19:28:27','042024','CO','99','CLIENTE ','PUNTO DE VENTA','',' ','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','3','13045.378151260506','654.6218487394958','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:28:27','13700.000000000002','358','BOD. FARMANORTE 358','1','1000','1000','840.33613445378','159.66386554622','1000','1','0','0','','30/04/2024','',13700,0,0,'77010148','JET CHOCOLATINA *12 GR','816','GRUPO NUTRESA','2024-04-30 19:28:27',  632.88, 47412, 749, 379),('FVE','FTSV','016725','2024-04-30 19:48:50','042024','CO','1048287067','DAIRO ALBERTO ','LONDO Ntilde O ARANGO ','CALLE 17 NO.1B3-19 BARRIO JUAN',' 3045651370','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','4117.64705882353','782.3529411764703','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:48:51','4900','358','BOD. FARMANORTE 358','1','4900','4900','4117.6470588235','782.35294117647','4900','1','0','1','','30/04/2024','',4900,0,0,'7702535011706','QUATRO TORONJA *1.5 LT','144','COCA COLA','2024-04-30 19:48:50',  3025.2, 37030, 749, 379),('FVE','FTSV','016728','2024-04-30 19:48:54','042024','CR','1104428563','JAIME ANDR eacute S ','RAM iacute REZ RODR iacute GUEZ ','MANZANA BQ 3APTO 401',' 3108186261','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','267720','2','38015.12605042017','7184.873949579829','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:12:10','45200','358','BOD. FARMANORTE 358','1','45000','45000','37815.12605042','7184.8739495798','45000','1','0','0','','30/04/2024','',0,0,45200,'7707263004334','VASOMED GEL CALMANTE Y RELAJANTE * 400 GR','387','TRIDEX FARMACEUTICA','2024-04-30 19:48:54',  23400, 62769, 749, 379),('FVE','FTSV','016728','2024-04-30 19:48:54','042024','CR','1104428563','JAIME ANDR eacute S ','RAM iacute REZ RODR iacute GUEZ ','MANZANA BQ 3APTO 401',' 3108186261','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','267720','2','38015.12605042017','7184.873949579829','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:12:10','45200','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',0,0,45200,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 19:48:54',  100, 44347, 749, 379),('FVE','FTSV','016726','2024-04-30 19:59:12','042024','CO','92545537','FABIO','SIERRA','',' 0','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','26','64301.68067226891','798.319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:59:12','65100','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',65100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 19:59:12',  100, 44347, 749, 379),('FVE','FTSV','016726','2024-04-30 19:59:12','042024','CO','92545537','FABIO','SIERRA','',' 0','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','26','64301.68067226891','798.319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:59:12','65100','358','BOD. FARMANORTE 358','1','31500','31500','31500','0','31500','1','0','0','','30/04/2024','',65100,0,0,'7702132009748','ADVIL CHILDREN *100 ML ','616','HALEON (GLAXO OTC)','2024-04-30 19:59:12',  28044, 46798, 749, 379),('FVE','FTSV','016726','2024-04-30 19:59:12','042024','CO','92545537','FABIO','SIERRA','',' 0','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','26','64301.68067226891','798.319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:59:12','65100','358','BOD. FARMANORTE 358','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/04/2024','',65100,0,0,'7702189055484','NATUCHIPS PLATANO MADURO *38 GR','762','FRITO LAY','2024-04-30 19:59:12',  1449, 56938, 749, 379),('FVE','FTSV','016726','2024-04-30 19:59:12','042024','CO','92545537','FABIO','SIERRA','',' 0','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','26','64301.68067226891','798.319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:59:12','65100','358','BOD. FARMANORTE 358','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/04/2024','',65100,0,0,'7702189056023','PAPAS MARGARITA LIMON *36 GR','762','FRITO LAY','2024-04-30 19:59:12',  1449, 60428, 749, 379),('FVE','FTSV','016726','2024-04-30 19:59:12','042024','CO','92545537','FABIO','SIERRA','',' 0','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','26','64301.68067226891','798.319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:59:12','65100','358','BOD. FARMANORTE 358','12','1700','20400','20400','0','20400','0','12','0','','30/04/2024','',65100,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2024-04-30 19:59:12',  50000, 31759, 749, 379),('FVE','FTSV','016726','2024-04-30 19:59:12','042024','CO','92545537','FABIO','SIERRA','',' 0','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','26','64301.68067226891','798.319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 19:59:12','65100','358','BOD. FARMANORTE 358','10','800','8000','8000','0','8000','0','10','0','','30/04/2024','',65100,0,0,'7451079000669,7','DOLEX 500 MG *200 TAB','616','HALEON (GLAXO OTC)','2024-04-30 19:59:12',  125586, 26516, 749, 379),('FVE','FTSV','016727','2024-04-30 20:09:05','042024','CO','1102797052','KARLIN','MORALES','cra 29-N24a-35 edif CAROLINA A',' 3015015091','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','9','18871','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:09:05','18871','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',18871,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 20:09:05',  100, 44347, 749, 379),('FVE','FTSV','016727','2024-04-30 20:09:05','042024','CO','1102797052','KARLIN','MORALES','cra 29-N24a-35 edif CAROLINA A',' 3015015091','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','9','18871','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:09:05','18871','358','BOD. FARMANORTE 358','4','1300','5200','5200','0','5200','0','4','0','','30/04/2024','',18871,0,0,'7703546031608','CONGESTEX * 60 CAP  L-TR-CAPS','630','NOVAMED OTC','2024-04-30 20:09:05',  67353, 38541, 749, 379),('FVE','FTSV','016727','2024-04-30 20:09:05','042024','CO','1102797052','KARLIN','MORALES','cra 29-N24a-35 edif CAROLINA A',' 3015015091','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','9','18871','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:09:05','18871','358','BOD. FARMANORTE 358','1','6900','6900','6900','0','6900','1','0','0','','30/04/2024','',18871,0,0,'7706569000415','LORATADINA 10MG *20 TAB','614','A.G. MEDICAMENTOS','2024-04-30 20:09:05',  5340, 31562, 749, 379),('FVE','FTSV','016727','2024-04-30 20:09:05','042024','CO','1102797052','KARLIN','MORALES','cra 29-N24a-35 edif CAROLINA A',' 3015015091','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','9','18871','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:09:05','18871','358','BOD. FARMANORTE 358','1','2000','2000','2000','0','2000','1','0','0','','30/04/2024','',18871,0,0,'DO','DOMICILIO','00','VARIOS','2024-04-30 20:09:05',  1500, 44348, 749, 379),('FVE','FTSV','016727','2024-04-30 20:09:05','042024','CO','1102797052','KARLIN','MORALES','cra 29-N24a-35 edif CAROLINA A',' 3015015091','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','9','18871','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:09:05','18871','358','BOD. FARMANORTE 358','1','2700','2700','2700','0','2700','0','1','0','','30/04/2024','',18871,0,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-04-30 20:09:05',  33370, 62346, 749, 379),('FVE','FTSV','016727','2024-04-30 20:09:05','042024','CO','1102797052','KARLIN','MORALES','cra 29-N24a-35 edif CAROLINA A',' 3015015091','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','2977','ALCIDES MANUEL ','JIMéNEZ DE HOYOS ','','','','','','9','18871','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:09:05','18871','358','BOD. FARMANORTE 358','1','1871','1871','1871','0','1871','0','1','0','','30/04/2024','',18871,0,0,'7703234103044','NOXPIRIN F DIA JUGO MANDARINA *24 S/S ','626','SIEGFRIED CONSUMO','2024-04-30 20:09:05',  31924, 31060, 749, 379),('FVE','FTSV','016729','2024-04-30 20:12:25','042024','CO','1102872086','LUISA MARIA','PADILLA JARABA','',' 3004630723','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','2','44160','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:12:26','44160','358','BOD. FARMANORTE 358','1','36900','36900','36900','0','36900','1','0','0','','30/04/2024','',44160,0,0,'7707263008240','CLINDABACT CREMA VAGINAL * 20GR /D22/','387','TRIDEX FARMACEUTICA','2024-04-30 20:12:25',  21300, 62806, 749, 379),('FVE','FTSV','016729','2024-04-30 20:12:25','042024','CO','1102872086','LUISA MARIA','PADILLA JARABA','',' 3004630723','3540','JESUS ERNESTO','ANICHARICO LOPEZ','','TERCERO','VARIOS','','','','','','2','44160','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:12:26','44160','358','BOD. FARMANORTE 358','1','7260','7260','7260','0','7260','0','1','0','','30/04/2024','',44160,0,0,'7707019332124','CINDIMIZOL 200 MG *5 CAP','130','LABQUIFAR PHARMACEUTICA','2024-04-30 20:12:25',  6470, 27599, 749, 379),('FVE','FTSV','016730','2024-04-30 20:16:52','042024','CO','1102812880','JHONATAN','ARROYO','',' 00 3017696210','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','4','53100','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:16:52','53100','358','BOD. FARMANORTE 358','1','200','200','200','0','200','1','0','0','','30/04/2024','',53100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-04-30 20:16:52',  100, 44347, 749, 379),('FVE','FTSV','016730','2024-04-30 20:16:52','042024','CO','1102812880','JHONATAN','ARROYO','',' 00 3017696210','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','4','53100','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:16:52','53100','358','BOD. FARMANORTE 358','1','33000','33000','33000','0','33000','1','0','0','','30/04/2024','',53100,0,0,'7707019334302','FUNGISTEROL SHAMPOO FCO * 200 ML','130','LABQUIFAR PHARMACEUTICA','2024-04-30 20:16:52',  19190, 55307, 749, 379),('FVE','FTSV','016730','2024-04-30 20:16:52','042024','CO','1102812880','JHONATAN','ARROYO','',' 00 3017696210','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','4','53100','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:16:52','53100','358','BOD. FARMANORTE 358','1','9400','9400','9400','0','9400','1','0','0','','30/04/2024','',53100,0,0,'7707019332605','FUNGISTEROL 200 MG * 10 TAB','130','LABQUIFAR PHARMACEUTICA','2024-04-30 20:16:52',  4560, 45853, 749, 379),('FVE','FTSV','016730','2024-04-30 20:16:52','042024','CO','1102812880','JHONATAN','ARROYO','',' 00 3017696210','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','4','53100','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:16:52','53100','358','BOD. FARMANORTE 358','1','10500','10500','10500','0','10500','1','0','0','','30/04/2024','',53100,0,0,'7709299854228','PRUEBA DE EMBARAZO ESFERO ','398','ZIBOJECT','2024-04-30 20:16:52',  3150, 55608, 749, 379),('FVE','FTSV','016731','2024-04-30 20:32:20','042024','CO','9195601','JHON ','GOMEZ ','',' 3126115883','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','1','8900','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:32:20','8900','358','BOD. FARMANORTE 358','1','8900','8900','8900','0','8900','1','0','0','','30/04/2024','',8900,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-04-30 20:32:20',  6610, 54196, 749, 379),('FVE','FTSV','016732','2024-04-30 20:46:10','042024','CO','1102839392','JOSE ANDRES','GOMEZ','0',' 0','1653','ANGELLO','NARANJO ROBLES','','TERCERO','VARIOS','','','','','','1','17000','0','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:46:11','17000','358','BOD. FARMANORTE 358','1','17000','17000','17000','0','17000','1','0','0','','30/04/2024','',17000,0,0,'7702132655396','TODAY REAL SENSATION *3 PRESERVATIVOS OFERTA','616','HALEON (GLAXO OTC)','2024-04-30 20:46:10',  0, 63623, 749, 379),('FVE','FTSV','016733','2024-04-30 20:50:16','042024','CO','42206931','IRASEMA ','CICILIANI ','',' 3007651549','3102','JAIME ANDRéS ','RAMíREZ RODRíGUEZ ','','TERCERO','VARIOS','','','','','','3','5320.16806722689','79.8319327731092','358','FARMANORTE 358','ADMINISTRADOR','2024-04-30 20:50:16','5400','358','BOD. FARMANORTE 358','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/04/2024','',5400,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-04-30 20:50:16',  9360, 46328, 749, 379);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '042024' AND DECODBOD='358';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '042024' AND DECODBOD='358';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '042024' AND DECODBOD='358';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '042024' AND DECODBOD='358';
