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','FN87','071355','2023-06-28 20:38:37','062023','CO','56076124','VIVIANA','MARTINES','CALLE 8 N  16B - 47 BARRIO  OB',' 30125254658  30125254658  30125254658','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','8','16200','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 20:38:37','16200','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','29/06/2023','',0,16200,0,'DO','DOMICILIO','00','VARIOS','2023-06-28 20:38:37',  500, 44348, 223, 99),('FVE','FN87','071356','2023-06-28 20:42:24','062023','CO','1004425154','PAULA','GARCERAN','',' 3122986107','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','19000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 20:42:24','19000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',19000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 20:42:24',  1000, 44347, 223, 99),('FVE','FN87','071356','2023-06-28 20:42:24','062023','CO','1004425154','PAULA','GARCERAN','',' 3122986107','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','19000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 20:42:24','19000','87','BOD. FARMANORTE 87','1','18900','18900','18900','0','18900','1','0','0','','29/06/2023','',19000,0,0,'7703689000448','CYCLOFEM 0.5ML AMP + JERINGA  ','344','PROFAMILIA','2023-06-28 20:42:24',  16550, 40547, 223, 99),('FVE','FN87','071357','2023-06-28 21:31:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','7300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:31:47','7300','87','BOD. FARMANORTE 87','5','1000','5000','5000','0','5000','0','5','0','','29/06/2023','',7300,0,0,'7707019420722','RESFRYGRIP PLUS *10 CAP','130','LABQUIFAR PHARMACEUTICA','2023-06-28 21:31:47',  4800, 45904, 223, 99),('FVE','FN87','071357','2023-06-28 21:31:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','7300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:31:47','7300','87','BOD. FARMANORTE 87','1','2300','2300','2300','0','2300','0','1','0','','29/06/2023','',7300,0,0,'7707232098074','MIELTERTOS GRIPA NOCHE PANELA-LIMON *24 S/S','271','NATURAL FRESHLY','2023-06-28 21:31:47',  34555.41, 25785, 223, 99),('FVE','FN87','071358','2023-06-28 21:39:47','062023','CO','12618419','RADA','DIOMAR','','0  ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','3529.4117647058824','670.5882352941176','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:39:47','4200','87','BOD. FARMANORTE 87','1','4200','4200','3529.4117647059','670.58823529412','4200','1','0','0','','29/06/2023','',0,4200,0,'7509546652139','COLGATE CREMA MENTA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2023-06-28 21:39:47',  2838.9056, 56066, 223, 99),('FVE','FN87','071359','2023-06-28 21:40:54','062023','CO','1193527265','ANGELA','VARGASS','SANTA ANA  CALLE 29H N30d-45',' 3116627619','2791','Tania Margarita ','Cortes peña','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','3','53256.3025210084','3943.697478991595','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:40:55','57200','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','29/06/2023','',0,57200,0,'DO','DOMICILIO','00','VARIOS','2023-06-28 21:40:54',  500, 44348, 223, 99),('FVE','FN87','071359','2023-06-28 21:40:54','062023','CO','1193527265','ANGELA','VARGASS','SANTA ANA  CALLE 29H N30d-45',' 3116627619','2791','Tania Margarita ','Cortes peña','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','3','53256.3025210084','3943.697478991595','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:40:55','57200','87','BOD. FARMANORTE 87','1','31500','31500','31500','0','31500','1','0','0','','29/06/2023','',0,57200,0,'7707263007755','CLINDABACT 100/100MG  X 3 OVULOS','387','TRIDEX FARMACEUTICA','2023-06-28 21:40:54',  22800, 59529, 223, 99),('FVE','FN87','071359','2023-06-28 21:40:54','062023','CO','1193527265','ANGELA','VARGASS','SANTA ANA  CALLE 29H N30d-45',' 3116627619','2791','Tania Margarita ','Cortes peña','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','3','53256.3025210084','3943.697478991595','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:40:55','57200','87','BOD. FARMANORTE 87','1','24700','24700','20756.302521008','3943.6974789916','24700','1','0','0','','29/06/2023','',0,57200,0,'7707341203215','LIDALCYD JABON INTIMO CALE-VIN-MAN FCO * 210ML','195','GIMED SA','2023-06-28 21:40:54',  16723, 62076, 223, 99),('FVE','FN87','071360','2023-06-28 21:43:33','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','364','JEFREY ANDREY','CRUZ SANTIAGO','','TERCERO','VARIOS','','','','','','2','3613.4453781512607','686.5546218487393','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:43:33','4300','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',4300,0,0,'7702090033601','HIT LULO *500 ML','192','GASEOSAS HIPINTO','2023-06-28 21:43:33',  1750.42, 25835, 223, 99),('FVE','FN87','071360','2023-06-28 21:43:33','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','364','JEFREY ANDREY','CRUZ SANTIAGO','','TERCERO','VARIOS','','','','','','2','3613.4453781512607','686.5546218487393','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:43:33','4300','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','29/06/2023','',4300,0,0,'7702914112017','PONQUE GALA CHOCOLATE TAJADA *60 GR','342','PRODUCTOS RAMO','2023-06-28 21:43:33',  1143, 40519, 223, 99),('FVE','FN87','071361','2023-06-28 21:44:52','062023','CO','1083009784','LAURA ','ARIZA','Manzana 84 casa 1 ciudadela CA','    3016754231','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','6600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:44:52','6600','87','BOD. FARMANORTE 87','1','6600','6600','6600','0','6600','1','0','0','','29/06/2023','',6600,0,0,'7703331105118','MICROGYNON SUAVE X 21 GRAG','380','TECNOFARMA','2023-06-28 21:44:52',  5647, 40562, 223, 99),('FVE','FN87','071362','2023-06-28 21:52:52','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:52:53','2300','87','BOD. FARMANORTE 87','1','2300','2300','2300','0','2300','0','1','0','','29/06/2023','',2300,0,0,'7707232098074','MIELTERTOS GRIPA NOCHE PANELA-LIMON *24 S/S','271','NATURAL FRESHLY','2023-06-28 21:52:52',  34555.41, 25785, 223, 99),('FVE','FN87','071363','2023-06-28 21:56:04','062023','CO','27799918','ESPERANZA','SUAREZ','FRENTE MERCADO BELEN','00  ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','11864.705882352942','2235.2941176470576','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:56:04','14100','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',0,14100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 21:56:04',  1000, 44347, 223, 99),('FVE','FN87','071363','2023-06-28 21:56:04','062023','CO','27799918','ESPERANZA','SUAREZ','FRENTE MERCADO BELEN','00  ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','11864.705882352942','2235.2941176470576','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:56:04','14100','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/06/2023','',0,14100,0,'7702617487368','NECTAR MANZANA CALIFORNIA *300 ML','823','GLORIA COLOMBIA SA','2023-06-28 21:56:04',  1885, 57239, 223, 99),('FVE','FN87','071363','2023-06-28 21:56:04','062023','CO','27799918','ESPERANZA','SUAREZ','FRENTE MERCADO BELEN','00  ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','11864.705882352942','2235.2941176470576','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:56:04','14100','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/06/2023','',0,14100,0,'7702617487382','NECTAR PERA CALIFORNIA *300 ML','823','GLORIA COLOMBIA SA','2023-06-28 21:56:04',  1885, 54989, 223, 99),('FVE','FN87','071363','2023-06-28 21:56:04','062023','CO','27799918','ESPERANZA','SUAREZ','FRENTE MERCADO BELEN','00  ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','11864.705882352942','2235.2941176470576','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:56:04','14100','87','BOD. FARMANORTE 87','1','1200','1200','1008.4033613445','191.59663865546','1200','1','0','0','','29/06/2023','',0,14100,0,'7702007039856','CHOCOLATINA GOL *31 GR','816','GRUPO NUTRESA','2023-06-28 21:56:04',  806.7227, 53166, 223, 99),('FVE','FN87','071363','2023-06-28 21:56:04','062023','CO','27799918','ESPERANZA','SUAREZ','FRENTE MERCADO BELEN','00  ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','11864.705882352942','2235.2941176470576','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:56:04','14100','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',0,14100,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2023-06-28 21:56:04',  1693, 60339, 223, 99),('FVE','FN87','071363','2023-06-28 21:56:04','062023','CO','27799918','ESPERANZA','SUAREZ','FRENTE MERCADO BELEN','00  ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','6','11864.705882352942','2235.2941176470576','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:56:04','14100','87','BOD. FARMANORTE 87','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','29/06/2023','',0,14100,0,'7702402054607','PALETA POLET BOMBON DE PARIS *75 GR','296','MEALS DE COLOMBIA','2023-06-28 21:56:04',  2920.4, 57508, 223, 99),('FVE','FN87','071364','2023-06-28 21:58:32','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','5021.008403361345','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:58:32','5500','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','1','0','','29/06/2023','',5500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 21:58:32',  1000, 44347, 223, 99),('FVE','FN87','071364','2023-06-28 21:58:32','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','5021.008403361345','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:58:32','5500','87','BOD. FARMANORTE 87','1','2400','2400','2400','0','2400','0','1','0','','29/06/2023','',5500,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2023-06-28 21:58:32',  17742.24, 46200, 223, 99),('FVE','FN87','071364','2023-06-28 21:58:32','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','5021.008403361345','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 21:58:32','5500','87','BOD. FARMANORTE 87','2','1500','3000','2521.0084033613','478.99159663866','3000','2','0','0','','29/06/2023','',5500,0,0,'7702402043359,7','PALETA ALOHA AGUA LIMON X 65 GR','296','MEALS DE COLOMBIA','2023-06-28 21:58:32',  1008, 32692, 223, 99),('FVE','FN87','071365','2023-06-28 22:09:59','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','10352.100840336136','1947.8991596638643','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:10:00','12300','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',12300,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 22:09:59',  1000, 44347, 223, 99),('FVE','FN87','071365','2023-06-28 22:09:59','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','10352.100840336136','1947.8991596638643','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:10:00','12300','87','BOD. FARMANORTE 87','1','12200','12200','10252.100840336','1947.8991596639','12200','1','0','0','','29/06/2023','',12300,0,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2023-06-28 22:09:59',  8414.1, 33273, 223, 99),('FVE','FN87','071366','2023-06-28 22:12:27','062023','CO','1082896925','SINDY JANETH','GUTIERREZ PACHECO','URB. PARQUES DE BOLIVAR ETAPA ',' 3023889972','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','4117.64705882353','782.3529411764703','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:12:27','4900','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',0,4900,0,'7702090029888','HIT TROPICAL *500 ML','192','GASEOSAS HIPINTO','2023-06-28 22:12:27',  1750.366, 35524, 223, 99),('FVE','FN87','071366','2023-06-28 22:12:27','062023','CO','1082896925','SINDY JANETH','GUTIERREZ PACHECO','URB. PARQUES DE BOLIVAR ETAPA ',' 3023889972','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','4117.64705882353','782.3529411764703','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:12:27','4900','87','BOD. FARMANORTE 87','1','1200','1200','1008.4033613445','191.59663865546','1200','1','0','0','','29/06/2023','',0,4900,0,'7702025142910','GALLETAS MINICHIPS CHOCOCHIP *35 GR','816','GRUPO NUTRESA','2023-06-28 22:12:27',  806.5, 57536, 223, 99),('FVE','FN87','071366','2023-06-28 22:12:27','062023','CO','1082896925','SINDY JANETH','GUTIERREZ PACHECO','URB. PARQUES DE BOLIVAR ETAPA ',' 3023889972','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','4117.64705882353','782.3529411764703','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:12:27','4900','87','BOD. FARMANORTE 87','1','1200','1200','1008.4033613445','191.59663865546','1200','1','0','0','','29/06/2023','',0,4900,0,'7702007039856','CHOCOLATINA GOL *31 GR','816','GRUPO NUTRESA','2023-06-28 22:12:27',  806.7227, 53166, 223, 99),('FVE','FN87','071367','2023-06-28 22:18:48','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','2368.90756302521','431.09243697478996','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:18:48','2800','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',2800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 22:18:48',  1000, 44347, 223, 99),('FVE','FN87','071367','2023-06-28 22:18:48','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','2368.90756302521','431.09243697478996','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:18:48','2800','87','BOD. FARMANORTE 87','1','2700','2700','2268.9075630252','431.09243697479','2700','1','0','0','','29/06/2023','',2800,0,0,'7702277865964','TOALLITAS ARRURRU AVENA Y KARITE X 20 UND','124','BELLEZA EXPRESS SA','2023-06-28 22:18:48',  1891.25, 54335, 223, 99),('FVE','FN87','071368','2023-06-28 22:23:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','28955.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:23:46','30233','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',30233,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 22:23:46',  1000, 44347, 223, 99),('FVE','FN87','071368','2023-06-28 22:23:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','28955.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:23:46','30233','87','BOD. FARMANORTE 87','1','15000','15000','15000','0','15000','1','0','0','','29/06/2023','',30233,0,0,'7707172685778','DOLEX JARABE 2+ *90 ML ','616','HALEON (GLAXO OTC)','2023-06-28 22:23:46',  13827.73, 26537, 223, 99),('FVE','FN87','071368','2023-06-28 22:23:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','28955.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:23:46','30233','87','BOD. FARMANORTE 87','1','8000','8000','6722.6890756303','1277.3109243697','8000','1','0','0','','29/06/2023','',30233,0,0,'041333431482','DURACELL AAA PAR','194','GENOMMA LABORATORIO COLOMBIA','2023-06-28 22:23:46',  3561, 44379, 223, 99),('FVE','FN87','071368','2023-06-28 22:23:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','28955.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:23:46','30233','87','BOD. FARMANORTE 87','1','5133','5133','5133','0','5133','0','1','0','','29/06/2023','',30233,0,0,'7500435107020','VICK VAPORUB 12GR *12 LATAS','336','PROCTER & GAMBLE COLOMBIA','2023-06-28 22:23:46',  55206, 40253, 223, 99),('FVE','FN87','071368','2023-06-28 22:23:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','28955.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:23:46','30233','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','29/06/2023','',30233,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-28 22:23:46',  866.6667, 48019, 223, 99),('FVE','FN87','071369','2023-06-28 22:24:24','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','5133','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:24:24','5133','87','BOD. FARMANORTE 87','1','5133','5133','5133','0','5133','0','1','0','','29/06/2023','',5133,0,0,'7500435107020','VICK VAPORUB 12GR *12 LATAS','336','PROCTER & GAMBLE COLOMBIA','2023-06-28 22:24:24',  55206, 40253, 223, 99),('FVE','FN87','071370','2023-06-28 22:30:52','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','9900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:30:52','9900','87','BOD. FARMANORTE 87','1','9900','9900','9900','0','9900','1','0','0','','29/06/2023','',9900,0,0,'4005800254963','DUO LUBRICADO *3 PRESERVATIVOS','123','BDF (BEIERSDORF) ','2023-06-28 22:30:52',  8805.9, 23315, 223, 99),('FVE','FN87','071371','2023-06-28 22:33:19','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','7563.025210084034','1436.9747899159656','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:33:19','9000','87','BOD. FARMANORTE 87','1','9000','9000','7563.025210084','1436.974789916','9000','1','0','0','','29/06/2023','',9000,0,0,'7702277156673','TOALLITAS ARRURRU AVENA Y KARITE X 70 UND','124','BELLEZA EXPRESS SA','2023-06-28 22:33:19',  6230.5, 55331, 223, 99),('FVE','FN87','071372','2023-06-28 22:34:54','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','13600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:34:54','13600','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',13600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 22:34:54',  1000, 44347, 223, 99),('FVE','FN87','071372','2023-06-28 22:34:54','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','13600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:34:54','13600','87','BOD. FARMANORTE 87','1','9100','9100','9100','0','9100','1','0','0','','29/06/2023','',13600,0,0,'74410248','LECHE DE MAGNESIA PHILLIPS *120 ML','116','ASPEN COLOMBIANA SAS','2023-06-28 22:34:54',  7989, 28686, 223, 99),('FVE','FN87','071372','2023-06-28 22:34:54','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','13600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:34:54','13600','87','BOD. FARMANORTE 87','1','4400','4400','4400','0','4400','1','0','0','','29/06/2023','',13600,0,0,'7706659500146','AGUA OXIGENADA *120 ML','143','COASPHARMA SAS','2023-06-28 22:34:54',  3124.58, 49419, 223, 99);
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','FN87','071374','2023-06-28 22:55:58','062023','CO','1082896925','SINDY JANETH','GUTIERREZ PACHECO','URB. PARQUES DE BOLIVAR ETAPA ',' 3023889972','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','5882.352941176471','1117.6470588235288','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 22:55:58','7000','87','BOD. FARMANORTE 87','1','7000','7000','5882.3529411765','1117.6470588235','7000','1','0','0','','29/06/2023','',7000,0,0,'070847038764','MONSTER ENERGY MANGO LOCO LATA *473 ML','144','COCA COLA','2023-06-28 22:55:58',  4003.5, 60471, 223, 99),('FVE','FN87','071375','2023-06-28 23:04:52','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','7983.193277310926','1516.8067226890748','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:04:52','9500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',9500,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2023-06-28 23:04:52',  1693, 60339, 223, 99),('FVE','FN87','071375','2023-06-28 23:04:52','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','7983.193277310926','1516.8067226890748','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:04:52','9500','87','BOD. FARMANORTE 87','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','29/06/2023','',9500,0,0,'7702402053556','CONO BOCATTO FRESA *85 GR','296','MEALS DE COLOMBIA','2023-06-28 23:04:52',  2980, 55871, 223, 99),('FVE','FN87','071375','2023-06-28 23:04:52','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','7983.193277310926','1516.8067226890748','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:04:52','9500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',9500,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2023-06-28 23:04:52',  1638.588, 54650, 223, 99),('FVE','FN87','071376','2023-06-28 23:09:06','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:09:06','4600','87','BOD. FARMANORTE 87','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','29/06/2023','',4600,0,0,'7702535011706','QUATRO TORONJA *1.5 LT','144','COCA COLA','2023-06-28 23:09:06',  2836.1667, 37030, 223, 99),('FVE','FN87','071377','2023-06-28 23:10:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','4999','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:10:46','4999','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','3','0','','29/06/2023','',4999,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-28 23:10:46',  1000, 44347, 223, 99),('FVE','FN87','071377','2023-06-28 23:10:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','4999','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:10:46','4999','87','BOD. FARMANORTE 87','3','1633','4899','4899','0','4899','0','3','0','','29/06/2023','',4999,0,0,'7703381002313','BUSCAPINA FEM X 90 COMP ','772','OPELLA (SANOFI OTC)','2023-06-28 23:10:46',  122002.258, 23812, 223, 99),('FVE','FN87','071378','2023-06-28 23:21:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2436.9747899159665','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:21:47','2900','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/06/2023','',2900,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2023-06-28 23:21:47',  1788.297, 34397, 223, 99),('FVE','FN87','071379','2023-06-28 23:45:50','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','18700','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:45:50','18700','87','BOD. FARMANORTE 87','1','6700','6700','6700','0','6700','0','1','0','','29/06/2023','',18700,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-28 23:45:50',  57323.8, 41855, 223, 99),('FVE','FN87','071379','2023-06-28 23:45:50','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','18700','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:45:50','18700','87','BOD. FARMANORTE 87','10','1200','12000','12000','0','12000','0','10','0','','29/06/2023','',18700,0,0,'7703712085060','IBUPROFAR COMPUESTO CJA * 48 CAPS','387','TRIDEX FARMACEUTICA','2023-06-28 23:45:50',  29880, 53776, 223, 99),('FVE','FN87','071380','2023-06-28 23:48:40','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','12900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-28 23:48:40','12900','87','BOD. FARMANORTE 87','1','12900','12900','12900','0','12900','1','0','0','','29/06/2023','',12900,0,0,'7707019379464','ACTIVIRAL 5% CREMA TBO * 15G (ACICLOVIR) TBO BIOQUIFAR','130','LABQUIFAR PHARMACEUTICA','2023-06-28 23:48:40',  4000, 45874, 223, 99),('FVE','FN87','071381','2023-06-29 00:08:38','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','14722.689075630253','1277.310924369748','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:08:38','16000','87','BOD. FARMANORTE 87','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','29/06/2023','',16000,0,0,'7622201776633','TRIDENT SANDIA *8.5 GR','754','DISCOB NORTE SAS','2023-06-29 00:08:38',  933.7222, 57672, 223, 99),('FVE','FN87','071381','2023-06-29 00:08:38','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','14722.689075630253','1277.310924369748','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:08:38','16000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','29/06/2023','',16000,0,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-29 00:08:38',  6064, 47205, 223, 99),('FVE','FN87','071381','2023-06-29 00:08:38','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','14722.689075630253','1277.310924369748','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:08:38','16000','87','BOD. FARMANORTE 87','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','29/06/2023','',16000,0,0,'7702535011706','QUATRO TORONJA *1.5 LT','144','COCA COLA','2023-06-29 00:08:38',  2836.1667, 37030, 223, 99),('FVE','FN87','071381','2023-06-29 00:08:38','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','14722.689075630253','1277.310924369748','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:08:38','16000','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','29/06/2023','',16000,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2023-06-29 00:08:38',  1197.56, 50688, 223, 99),('FVE','FN87','071382','2023-06-29 00:31:11','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','15500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:31:11','15500','87','BOD. FARMANORTE 87','1','15500','15500','15500','0','15500','1','0','0','','29/06/2023','',15500,0,0,'7703712035485','HIDROXIDO DE ALUMINIO +SIMETICONA *360 ML','143','COASPHARMA SAS','2023-06-29 00:31:11',  8037, 46879, 223, 99),('FVE','FN87','071383','2023-06-29 00:45:28','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','21900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:45:28','21900','87','BOD. FARMANORTE 87','10','590','5900','5900','0','5900','0','10','0','','29/06/2023','',0,21900,0,'7706569000026','AMOXICILINA 500MG *50 CAP','614','A.G. MEDICAMENTOS','2023-06-29 00:45:28',  20707, 31190, 223, 99),('FVE','FN87','071383','2023-06-29 00:45:28','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','21900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:45:28','21900','87','BOD. FARMANORTE 87','1','16000','16000','16000','0','16000','1','0','0','','29/06/2023','',0,21900,0,'7706309000262','NAFAZOL ADULT GOTAS *15 ML ','260','INCOBRA FARMA','2023-06-29 00:45:28',  5434, 29913, 223, 99),('FVE','FN87','071384','2023-06-29 00:51:50','062023','CO','26858991','ISMARY','RODRIGUEZ','BOULEVARD DE LA ROSA',' 3148686798','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','10','3450','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 00:51:50','3450','87','BOD. FARMANORTE 87','10','345','3450','3450','0','3450','0','10','0','','29/06/2023','',3450,0,0,'7706569000415','LORATADINA 10MG *20 TAB','614','A.G. MEDICAMENTOS','2023-06-29 00:51:50',  5062, 31562, 223, 99),('FVE','FN87','071385','2023-06-29 01:07:56','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','5882.352941176471','1117.6470588235288','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 01:07:56','7000','87','BOD. FARMANORTE 87','2','3500','7000','5882.3529411765','1117.6470588235','7000','2','0','0','','29/06/2023','',7000,0,0,'7702090051827','NATU MALTA BOTELLA *1000 ML','192','GASEOSAS HIPINTO','2023-06-29 01:07:56',  2500, 55375, 223, 99),('FVE','FN87','071386','2023-06-29 01:45:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5462.184873949581','1037.8151260504196','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 01:45:35','6500','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','29/06/2023','',6500,0,0,'6910021007206','COLGATE CEPILLO PREMIER CLEAN MEDIO','145','COLGATE PALMOLIVE COMPANIA','2023-06-29 01:45:35',  2301.1503, 47117, 223, 99),('FVE','FN87','071386','2023-06-29 01:45:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5462.184873949581','1037.8151260504196','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 01:45:35','6500','87','BOD. FARMANORTE 87','1','1000','1000','840.33613445378','159.66386554622','1000','1','0','0','','29/06/2023','',6500,0,0,'7702025136735','GALLETA FESTIVAL VAINILLA *6 GALLETAS','816','GRUPO NUTRESA','2023-06-29 01:45:35',  671.71, 53175, 223, 99),('FVE','FN87','071386','2023-06-29 01:45:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5462.184873949581','1037.8151260504196','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 01:45:35','6500','87','BOD. FARMANORTE 87','1','1000','1000','840.33613445378','159.66386554622','1000','1','0','0','','29/06/2023','',6500,0,0,'7702025142033','GALLETA FESTIVAL RECREO *6 GALLETAS','816','GRUPO NUTRESA','2023-06-29 01:45:35',  671.67, 53633, 223, 99),('FVE','FN87','071386','2023-06-29 01:45:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5462.184873949581','1037.8151260504196','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 01:45:35','6500','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','29/06/2023','',6500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-29 01:45:35',  9360, 46328, 223, 99),('FVE','FN87','071387','2023-06-29 01:55:21','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','4789.915966386555','910.0840336134452','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 01:55:21','5700','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',5700,0,0,'7702007212501','CHOCOLATINA JUMBO MANI *40 GR','816','GRUPO NUTRESA','2023-06-29 01:55:21',  1721.9, 53169, 223, 99),('FVE','FN87','071387','2023-06-29 01:55:21','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','4789.915966386555','910.0840336134452','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 01:55:21','5700','87','BOD. FARMANORTE 87','2','1600','3200','2689.0756302521','510.9243697479','3200','2','0','0','','29/06/2023','',5700,0,0,'7702189056245','CHOKIS CHOCOBASE * 47 GR','762','FRITO LAY','2023-06-29 01:55:21',  1033, 57555, 223, 99),('FVE','FN87','071388','2023-06-29 04:13:09','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 04:13:09','3100','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','29/06/2023','',3100,0,0,'7702004007360','CERVEZA POKER LATA *330 ML','119','BAVARIA S.A.','2023-06-29 04:13:09',  21393.3, 22837, 223, 99),('FVE','FN87','071389','2023-06-29 04:44:34','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 04:44:34','3100','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','29/06/2023','',3100,0,0,'7702004007360','CERVEZA POKER LATA *330 ML','119','BAVARIA S.A.','2023-06-29 04:44:34',  21393.3, 22837, 223, 99),('FVE','FN87','071390','2023-06-29 06:18:04','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4873.949579831933','926.0504201680674','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 06:18:04','5800','87','BOD. FARMANORTE 87','1','5300','5300','4453.781512605','846.21848739496','5300','1','0','0','','29/06/2023','',5800,0,0,'7702027478741','TENA SLIP ULTRA L *1 UND','337','FAMILIA SANCELA','2023-06-29 06:18:04',  4259.51, 33335, 223, 99),('FVE','FN87','071390','2023-06-29 06:18:04','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4873.949579831933','926.0504201680674','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 06:18:04','5800','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','29/06/2023','',5800,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-29 06:18:04',  9360, 46328, 223, 99),('FVE','FN87','071391','2023-06-29 06:42:21','062023','CO','27739333','ESEQUIEL','CARRASCO','',' 3043945117','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','10200','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 06:42:21','10200','87','BOD. FARMANORTE 87','1','8200','8200','8200','0','8200','1','0','0','','29/06/2023','',10200,0,0,'7501033957413','PEDIALYTE ZINC 45 FRESA *500 ML','659','ABBOTT NUTRICION','2023-06-29 06:42:21',  6980, 22275, 223, 99),('FVE','FN87','071391','2023-06-29 06:42:21','062023','CO','27739333','ESEQUIEL','CARRASCO','',' 3043945117','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','10200','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 06:42:21','10200','87','BOD. FARMANORTE 87','10','200','2000','2000','0','2000','0','10','0','','29/06/2023','',10200,0,0,'7706569020659','ACETAMINOFEN 500MG *100 TAB','614','A.G. MEDICAMENTOS','2023-06-29 06:42:21',  12768, 31151, 223, 99),('FVE','FN87','071392','2023-06-29 07:09:47','062023','CO','789654','PEDRO','TORRES','','0  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','10000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 07:09:47','10000','87','BOD. FARMANORTE 87','5','2000','10000','10000','0','10000','5','0','0','','29/06/2023','',10000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-29 07:09:47',  866.6667, 48019, 223, 99),('FVE','FN87','071394','2023-06-29 08:20:39','062023','CR','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','360113','2','4957.983193277311','942.0168067226887','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 08:31:06','5900','87','BOD. FARMANORTE 87','1','3400','3400','2857.1428571429','542.85714285714','3400','1','0','0','','29/06/2023','',0,0,5900,'7702001044504,7','AVENA ALPINA NATURAL *250 GR','110','ALPINA PRODS. ALIMENTICIOS S.A.','2023-06-29 08:20:39',  2226, 22451, 223, 99),('FVE','FN87','071394','2023-06-29 08:20:39','062023','CR','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','360113','2','4957.983193277311','942.0168067226887','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 08:31:06','5900','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',0,0,5900,'7702914114004','PONQUE CHOCORAMO TAJADA *65 GR','342','PRODUCTOS RAMO','2023-06-29 08:20:39',  1505, 40516, 223, 99),('FVE','FN87','071393','2023-06-29 08:29:34','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 08:29:35','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',2500,0,0,'7702090033601','HIT LULO *500 ML','192','GASEOSAS HIPINTO','2023-06-29 08:29:34',  1750.42, 25835, 223, 99),('FVE','FN87','071395','2023-06-29 08:47:41','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','20646.21848739496','2953.781512605041','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 08:47:41','23600','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',23600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 08:47:41',  1000, 44347, 223, 99),('FVE','FN87','071395','2023-06-29 08:47:41','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','20646.21848739496','2953.781512605041','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 08:47:41','23600','87','BOD. FARMANORTE 87','1','5000','5000','5000','0','5000','1','0','0','','29/06/2023','',23600,0,0,'7707236129583','TRAMADOL 100MG/2ML *1 AMP','701','VITALIS COMERCIAL','2023-06-29 08:47:41',  2400, 54113, 223, 99),('FVE','FN87','071395','2023-06-29 08:47:41','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','20646.21848739496','2953.781512605041','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 08:47:41','23600','87','BOD. FARMANORTE 87','1','18500','18500','15546.218487395','2953.781512605','18500','1','0','0','','29/06/2023','',23600,0,0,'7702057082130','YODORA CREMA *32 GR X2 PRECIO ESPECIAL','889','TECNOQUIMICAS CONSUMO','2023-06-29 08:47:41',  12328, 42931, 223, 99),('FVE','FN87','071396','2023-06-29 09:06:15','062023','CO','5529193','CARLOS','DIAZ','cll 45 n 26-53 santa cruz','   3004446365','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','34880','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 09:06:15','34880','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','3','0','','29/06/2023','',34880,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 09:06:15',  1000, 44347, 223, 99);
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','FN87','071396','2023-06-29 09:06:15','062023','CO','5529193','CARLOS','DIAZ','cll 45 n 26-53 santa cruz','   3004446365','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','34880','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 09:06:15','34880','87','BOD. FARMANORTE 87','1','16000','16000','16000','0','16000','1','0','0','','29/06/2023','',34880,0,0,'7706309000262','NAFAZOL ADULT GOTAS *15 ML ','260','INCOBRA FARMA','2023-06-29 09:06:15',  5434, 29913, 223, 99),('FVE','FN87','071397','2023-06-29 09:55:10','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','3041.1764705882356','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 09:55:10','3600','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',3600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 09:55:10',  1000, 44347, 223, 99),('FVE','FN87','071397','2023-06-29 09:55:10','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','3041.1764705882356','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 09:55:10','3600','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','29/06/2023','',3600,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2023-06-29 09:55:10',  255, 46100, 223, 99),('FVE','FN87','071397','2023-06-29 09:55:10','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','3041.1764705882356','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 09:55:10','3600','87','BOD. FARMANORTE 87','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','29/06/2023','',3600,0,0,'7702535009994','POWERADE BLAST *500 ML','144','COCA COLA','2023-06-29 09:55:10',  1642.8333, 36976, 223, 99),('FVE','FN87','071398','2023-06-29 09:56:20','062023','CO','27799918','ESPERANZA','SUAREZ','FRENTE MERCADO BELEN','00  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','10','3500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 09:56:20','3500','87','BOD. FARMANORTE 87','10','350','3500','3500','0','3500','0','10','0','','29/06/2023','',3500,0,0,'7703153024796','VITAMINA E 400 UI X 100 TAB PROCAPS COLMED','422','COLMED','2023-06-29 09:56:20',  17280, 39934, 223, 99),('FVE','FN87','071399','2023-06-29 10:46:20','062023','CO','20457021','JOSE LUIS','BRECENO HERNANDEZ','KRA 21A 3 N 29F-70 APTO 202 LO',' 3042899761','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','4','108815.12605042016','9084.873949579829','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 10:46:21','117900','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','544','','29/06/2023','',65900,52000,0,'DO','DOMICILIO','00','VARIOS','2023-06-29 10:46:20',  500, 44348, 223, 99),('FVE','FN87','071399','2023-06-29 10:46:20','062023','CO','20457021','JOSE LUIS','BRECENO HERNANDEZ','KRA 21A 3 N 29F-70 APTO 202 LO',' 3042899761','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','4','108815.12605042016','9084.873949579829','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 10:46:21','117900','87','BOD. FARMANORTE 87','1','56900','56900','47815.12605042','9084.8739495798','56900','1','0','544','','29/06/2023','',65900,52000,0,'7701021111845','WINNY ULTRATRIM SEC ET3 *50 UND ','653','TECNOQUIMICAS WINNY','2023-06-29 10:46:20',  41577.836, 50913, 223, 99),('FVE','FN87','071399','2023-06-29 10:46:20','062023','CO','20457021','JOSE LUIS','BRECENO HERNANDEZ','KRA 21A 3 N 29F-70 APTO 202 LO',' 3042899761','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','4','108815.12605042016','9084.873949579829','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 10:46:21','117900','87','BOD. FARMANORTE 87','1','59900','59900','59900','0','59900','1','0','544','','29/06/2023','',65900,52000,0,'5391523056304','SIMILAC 1 PROSENSITIVE *400 GR','659','ABBOTT NUTRICION','2023-06-29 10:46:20',  54490, 51750, 223, 99),('FVE','FN87','071399','2023-06-29 10:46:20','062023','CO','20457021','JOSE LUIS','BRECENO HERNANDEZ','KRA 21A 3 N 29F-70 APTO 202 LO',' 3042899761','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','4','108815.12605042016','9084.873949579829','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 10:46:21','117900','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','544','','29/06/2023','',65900,52000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 10:46:20',  1000, 44347, 223, 99),('FVE','FN87','071400','2023-06-29 12:04:33','062023','CO','5407525','LUIS ','ROMERO','','00 3003348054 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','11','26634','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:04:34','26634','87','BOD. FARMANORTE 87','3','3500','10500','10500','0','10500','0','3','0','','29/06/2023','',26634,0,0,'7709990110999','COPROBIOTIC+PREBIOTICOS+PROBIOTICOS CJA *20S/S','1000','NATURALMENTE','2023-06-29 12:04:33',  26000, 61315, 223, 99),('FVE','FN87','071400','2023-06-29 12:04:33','062023','CO','5407525','LUIS ','ROMERO','','00 3003348054 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','11','26634','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:04:34','26634','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',26634,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 12:04:33',  1000, 44347, 223, 99),('FVE','FN87','071400','2023-06-29 12:04:33','062023','CO','5407525','LUIS ','ROMERO','','00 3003348054 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','11','26634','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:04:34','26634','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','29/06/2023','',26634,0,0,'7501125149221','ELECTROLIT FRESA - KIWI SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-29 12:04:33',  6064, 33981, 223, 99),('FVE','FN87','071400','2023-06-29 12:04:33','062023','CO','5407525','LUIS ','ROMERO','','00 3003348054 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','11','26634','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:04:34','26634','87','BOD. FARMANORTE 87','6','1339','8034','8034','0','8034','0','6','0','','29/06/2023','',26634,0,0,'7707019340907','METROXAZIDE 600/200MG *18 TAB','130','LABQUIFAR PHARMACEUTICA','2023-06-29 12:04:33',  12300, 23587, 223, 99),('FVE','FN87','071401','2023-06-29 12:12:33','062023','CO','60266902','LUZ','GUERRA QUIROZ','cra 21 a 3 # 29 f 45 los farol','  3012214788','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','5100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:12:33','5100','87','BOD. FARMANORTE 87','3','1700','5100','5100','0','5100','0','3','0','','29/06/2023','',5100,0,0,'7707263003474','GRIPAC X 100 CAPSULAS','387','TRIDEX FARMACEUTICA','2023-06-29 12:12:33',  100000, 43550, 223, 99),('FVE','FN87','071402','2023-06-29 12:28:05','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','4201.680672268908','798.319327731092','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:28:05','5000','87','BOD. FARMANORTE 87','2','2500','5000','4201.6806722689','798.31932773109','5000','2','0','21','','29/06/2023','',0,5000,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2023-06-29 12:28:05',  1638.588, 54650, 223, 99),('FVE','FN87','071403','2023-06-29 12:40:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','4621.848739495798','878.1512605042017','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:40:47','5500','87','BOD. FARMANORTE 87','1','5500','5500','4621.8487394958','878.1512605042','5500','1','0','0','','29/06/2023','',5500,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2023-06-29 12:40:47',  3871.0833, 56142, 223, 99),('FVE','FN87','071404','2023-06-29 12:53:52','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','3361.3445378151264','638.6554621848736','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 12:53:52','4000','87','BOD. FARMANORTE 87','1','4000','4000','3361.3445378151','638.65546218487','4000','1','0','0','','29/06/2023','',4000,0,0,'7702609009752,7','GASEOSA KOLA ROMAN *1.5 LT','144','COCA COLA','2023-06-29 12:53:52',  2521, 35291, 223, 99),('FVE','FN87','071405','2023-06-29 13:17:27','062023','CO','1082878231','VALENTINA','IBARRA','',' 3138807764','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','14941','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:17:27','14941','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',14941,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 13:17:27',  1000, 44347, 223, 99),('FVE','FN87','071405','2023-06-29 13:17:27','062023','CO','1082878231','VALENTINA','IBARRA','',' 3138807764','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','14941','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:17:27','14941','87','BOD. FARMANORTE 87','2','3033','6066','6066','0','6066','0','2','0','','29/06/2023','',14941,0,0,'7702123005513','APRONAX 550MG *60 TAB','631','BAYER OTC','2023-06-29 13:17:27',  104842, 46716, 223, 99),('FVE','FN87','071405','2023-06-29 13:17:27','062023','CO','1082878231','VALENTINA','IBARRA','',' 3138807764','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','14941','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:17:27','14941','87','BOD. FARMANORTE 87','1','3875','3875','3875','0','3875','0','1','0','','29/06/2023','',14941,0,0,'7707210530114','FORZ CREMA *24 SOBRES ','256','GERCO','2023-06-29 13:17:27',  52605, 46090, 223, 99),('FVE','FN87','071405','2023-06-29 13:17:27','062023','CO','1082878231','VALENTINA','IBARRA','',' 3138807764','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','14941','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:17:27','14941','87','BOD. FARMANORTE 87','1','4900','4900','4900','0','4900','1','0','0','','29/06/2023','',14941,0,0,'7707228362141','CINTA MICROPOROSA PIEL ALFASAFE 1 X 3 YD','429','ALFA SAFE','2023-06-29 13:17:27',  3036, 60552, 223, 99),('FVE','FN87','071406','2023-06-29 13:45:56','062023','CO','26976942','MAIRA MILENA ','TONCEL SIERRA','MZ9A CASA12 FILADELFIA',' 3046634583 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','10','2700','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:45:56','2700','87','BOD. FARMANORTE 87','10','270','2700','2700','0','2700','0','10','0','','29/06/2023','',2700,0,0,'7703546021005','CRONOFEN 500 MG CJA * 100 TB L-TR-CAPS','630','NOVAMED OTC','2023-06-29 13:45:56',  26301, 54625, 223, 99),('FVE','FN87','071407','2023-06-29 13:55:39','062023','CO','57296461','Diana Margarita ','Pomares Jacquin ','bulevar de la 19 mz N  casa 25',' 3158817534 3158817534','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','7','23802.52100840336','1197.4789915966385','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:55:39','25000','87','BOD. FARMANORTE 87','1','5500','5500','5500','0','5500','1','0','0','','29/06/2023','',0,25000,0,'7706569001443','NAPROXENO 250MG *10 TAB','614','A.G. MEDICAMENTOS','2023-06-29 13:55:39',  3922, 31629, 223, 99),('FVE','FN87','071407','2023-06-29 13:55:39','062023','CO','57296461','Diana Margarita ','Pomares Jacquin ','bulevar de la 19 mz N  casa 25',' 3158817534 3158817534','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','7','23802.52100840336','1197.4789915966385','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:55:39','25000','87','BOD. FARMANORTE 87','1','10900','10900','10900','0','10900','1','0','0','','29/06/2023','',0,25000,0,'7706569001450','NAPROXENO 500MG *10 TAB','614','A.G. MEDICAMENTOS','2023-06-29 13:55:39',  7892, 31632, 223, 99),('FVE','FN87','071407','2023-06-29 13:55:39','062023','CO','57296461','Diana Margarita ','Pomares Jacquin ','bulevar de la 19 mz N  casa 25',' 3158817534 3158817534','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','7','23802.52100840336','1197.4789915966385','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:55:39','25000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',0,25000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 13:55:39',  1000, 44347, 223, 99),('FVE','FN87','071407','2023-06-29 13:55:39','062023','CO','57296461','Diana Margarita ','Pomares Jacquin ','bulevar de la 19 mz N  casa 25',' 3158817534 3158817534','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','7','23802.52100840336','1197.4789915966385','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:55:39','25000','87','BOD. FARMANORTE 87','3','2500','7500','6302.5210084034','1197.4789915966','7500','3','0','0','','29/06/2023','',0,25000,0,'7702402052399','HELADO ARTESANAL MARACUYA *70 GR','296','MEALS DE COLOMBIA','2023-06-29 13:55:39',  1638.588, 54651, 223, 99),('FVE','FN87','071407','2023-06-29 13:55:39','062023','CO','57296461','Diana Margarita ','Pomares Jacquin ','bulevar de la 19 mz N  casa 25',' 3158817534 3158817534','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','7','23802.52100840336','1197.4789915966385','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 13:55:39','25000','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','29/06/2023','',0,25000,0,'DO','DOMICILIO','00','VARIOS','2023-06-29 13:55:39',  500, 44348, 223, 99),('FVE','FN87','071408','2023-06-29 14:03:59','062023','CO','56076124','VIVIANA','MARTINES','CALLE 8 N  16B - 47 BARRIO  OB',' 30125254658  30125254658  30125254658','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','2','7700','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:03:59','7700','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','29/06/2023','',7700,0,0,'DO','DOMICILIO','00','VARIOS','2023-06-29 14:03:59',  500, 44348, 223, 99),('FVE','FN87','071408','2023-06-29 14:03:59','062023','CO','56076124','VIVIANA','MARTINES','CALLE 8 N  16B - 47 BARRIO  OB',' 30125254658  30125254658  30125254658','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','2','7700','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:03:59','7700','87','BOD. FARMANORTE 87','1','6700','6700','6700','0','6700','0','1','0','','29/06/2023','',7700,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-29 14:03:59',  57323.8, 41855, 223, 99),('FVE','FN87','071409','2023-06-29 14:05:33','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:05:33','4600','87','BOD. FARMANORTE 87','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','19','','29/06/2023','',4600,0,0,'7702535011706','QUATRO TORONJA *1.5 LT','144','COCA COLA','2023-06-29 14:05:33',  2836.1667, 37030, 223, 99),('FVE','FN87','071410','2023-06-29 14:17:00','062023','CO','36727960','NAIROBIS','BARRIOS','',' 3002302145','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','7400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:17:00','7400','87','BOD. FARMANORTE 87','1','7400','7400','7400','0','7400','1','0','0','','29/06/2023','',7400,0,0,'7707210530169','OTOGLICAR GOTAS *30 ML  ','256','GERCO','2023-06-29 14:17:00',  4899, 29857, 223, 99),('FVE','FN87','071411','2023-06-29 14:18:22','062023','CO','12546260','ELKIN','ACEDO','',' 3117703124','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','2521.008403361345','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:18:22','3000','87','BOD. FARMANORTE 87','5','600','3000','2521.0084033613','478.99159663866','3000','5','0','0','','29/06/2023','',3000,0,0,'D1002','RECOLECTOR ORINA TAPA AZUL D1002','402','PARACLINICAS','2023-06-29 14:18:22',  228.3177, 39236, 223, 99),('FVE','FN87','071412','2023-06-29 14:22:09','062023','CO','12486643','ARMANDO RAFAEL','DIAZ','',' 0','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','13268.90756302521','431.09243697478996','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:22:09','13700','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',13700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 14:22:09',  1000, 44347, 223, 99),('FVE','FN87','071412','2023-06-29 14:22:09','062023','CO','12486643','ARMANDO RAFAEL','DIAZ','',' 0','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','13268.90756302521','431.09243697478996','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:22:09','13700','87','BOD. FARMANORTE 87','1','10900','10900','10900','0','10900','1','0','0','','29/06/2023','',13700,0,0,'7703153018368','METFORMINA 850 MG X 30 TABL  ','652','PROCAPS DIABETRICS','2023-06-29 14:22:09',  7000, 39828, 223, 99),('FVE','FN87','071412','2023-06-29 14:22:09','062023','CO','12486643','ARMANDO RAFAEL','DIAZ','',' 0','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','13268.90756302521','431.09243697478996','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 14:22:09','13700','87','BOD. FARMANORTE 87','1','2700','2700','2268.9075630252','431.09243697479','2700','1','0','0','','29/06/2023','',13700,0,0,'7702277865964','TOALLITAS ARRURRU AVENA Y KARITE X 20 UND','124','BELLEZA EXPRESS SA','2023-06-29 14:22:09',  1891.25, 54335, 223, 99),('FVE','FN87','071413','2023-06-29 15:03:03','062023','CO','1050462269','OSANNA','SANMENO',' Ntilde LKJ','   NO DIO','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 15:03:04','15000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','1','0','','29/06/2023','',15000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 15:03:03',  1000, 44347, 223, 99),('FVE','FN87','071413','2023-06-29 15:03:03','062023','CO','1050462269','OSANNA','SANMENO',' Ntilde LKJ','   NO DIO','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 15:03:04','15000','87','BOD. FARMANORTE 87','1','6700','6700','6700','0','6700','0','1','0','','29/06/2023','',15000,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-29 15:03:03',  57323.8, 41855, 223, 99),('FVE','FN87','071413','2023-06-29 15:03:03','062023','CO','1050462269','OSANNA','SANMENO',' Ntilde LKJ','   NO DIO','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 15:03:04','15000','87','BOD. FARMANORTE 87','1','8200','8200','8200','0','8200','1','0','0','','29/06/2023','',15000,0,0,'7501033957413','PEDIALYTE ZINC 45 FRESA *500 ML','659','ABBOTT NUTRICION','2023-06-29 15:03:03',  6980, 22275, 223, 99),('FVE','FN87','071414','2023-06-29 15:31:21','062023','CO','5049336','EDUARD','SALTARIN','',' 3117083193','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','22000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 15:31:21','22000','87','BOD. FARMANORTE 87','1','22000','22000','22000','0','22000','1','0','0','','29/06/2023','',22000,0,0,'7709990253542','FUNGIMED CREMA *20 GR','698','MED-LINE CONVENIO','2023-06-29 15:31:21',  5900, 46717, 223, 99),('FVE','FN87','071415','2023-06-29 15:56:51','062023','CR','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','959996','12','9338.991596638656','1421.008403361344','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 15:59:19','10760','87','BOD. FARMANORTE 87','1','1300','1300','1092.4369747899','207.56302521008','1300','1','0','0','','29/06/2023','',0,0,10760,'77082381','COCA COLA ZERO *250 ML','144','COCA COLA','2023-06-29 15:56:51',  687.4, 34412, 223, 99);
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','FN87','071415','2023-06-29 15:56:51','062023','CR','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','959996','12','9338.991596638656','1421.008403361344','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 15:59:19','10760','87','BOD. FARMANORTE 87','10','186','1860','1860','0','1860','0','10','0','','29/06/2023','',0,0,10760,'7702605100019','ACETAMINOFEN 500 MG X 100 TBS GENFAR-WINTHROP','715','GENFAR CONVENIO','2023-06-29 15:56:51',  9293.2, 25866, 223, 99),('FVE','FN87','071416','2023-06-29 16:21:50','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','11175.630252100842','1724.3697478991594','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:21:50','12900.000000000002','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','56','','29/06/2023','',12900,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 16:21:50',  1000, 44347, 223, 99),('FVE','FN87','071416','2023-06-29 16:21:50','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','11175.630252100842','1724.3697478991594','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:21:50','12900.000000000002','87','BOD. FARMANORTE 87','1','7700','7700','6470.5882352941','1229.4117647059','7700','1','0','56','','29/06/2023','',12900,0,0,'070847004707','MONSTER ENERGY GREEN LATA *473 ML','144','COCA COLA','2023-06-29 16:21:50',  3995.3, 32784, 223, 99),('FVE','FN87','071416','2023-06-29 16:21:50','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','11175.630252100842','1724.3697478991594','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:21:50','12900.000000000002','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','56','','29/06/2023','',12900,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-29 16:21:50',  866.6667, 48019, 223, 99),('FVE','FN87','071416','2023-06-29 16:21:50','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','11175.630252100842','1724.3697478991594','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:21:50','12900.000000000002','87','BOD. FARMANORTE 87','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','56','','29/06/2023','',12900,0,0,'7622201693213','GALLETA OREO ORIGINAL *108 GR ','754','DISCOB NORTE SAS','2023-06-29 16:21:50',  2226.9, 61320, 223, 99),('FVE','FN87','071417','2023-06-29 16:23:10','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','4453.781512605043','846.2184873949577','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:23:10','5300','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','22','','29/06/2023','',5300,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','GASEOSAS HIPINTO','2023-06-29 16:23:10',  2451, 25826, 223, 99),('FVE','FN87','071417','2023-06-29 16:23:10','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','4453.781512605043','846.2184873949577','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:23:10','5300','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','22','','29/06/2023','',5300,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2023-06-29 16:23:10',  1197.56, 50688, 223, 99),('FVE','FN87','071418','2023-06-29 16:27:07','062023','CO','12562988','CARLOS A','NU NTILDE EZ','MANZANA 99 CASA 18 CIUDADELA',' 3205280453 3203404752','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','2941.1764705882356','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:27:07','3500','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','29/06/2023','',3500,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','GASEOSAS HIPINTO','2023-06-29 16:27:07',  2451, 25826, 223, 99),('FVE','FN87','071419','2023-06-29 16:29:43','062023','CO','1083036701','YISELA CALVO','caballero','kra 5 n 34-385  san pablo ','     3218229065','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','24','15116','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:29:44','15116','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','2','0','','29/06/2023','',15116,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 16:29:43',  1000, 44347, 223, 99),('FVE','FN87','071419','2023-06-29 16:29:43','062023','CO','1083036701','YISELA CALVO','caballero','kra 5 n 34-385  san pablo ','     3218229065','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','24','15116','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:29:44','15116','87','BOD. FARMANORTE 87','2','1508','3016','3016','0','3016','0','2','0','','29/06/2023','',15116,0,0,'7703234103044','NOXPIRIN F DIA JUGO MANDARINA *24 S/S ','626','SIEGFRIED CONSUMO','2023-06-29 16:29:43',  25273, 31060, 223, 99),('FVE','FN87','071419','2023-06-29 16:29:43','062023','CO','1083036701','YISELA CALVO','caballero','kra 5 n 34-385  san pablo ','     3218229065','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','24','15116','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:29:44','15116','87','BOD. FARMANORTE 87','10','450','4500','4500','0','4500','0','10','0','','29/06/2023','',15116,0,0,'7709492276612','KEOPS VIT MANDARINA *100 TAB','811','KEOPS FARMACEUTICA','2023-06-29 16:29:43',  16500, 56845, 223, 99),('FVE','FN87','071419','2023-06-29 16:29:43','062023','CO','1083036701','YISELA CALVO','caballero','kra 5 n 34-385  san pablo ','     3218229065','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','24','15116','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:29:44','15116','87','BOD. FARMANORTE 87','10','650','6500','6500','0','6500','0','10','0','','29/06/2023','',15116,0,0,'7702123008668','DITOPAX *50 TAB','405','EUROFARMA','2023-06-29 16:29:43',  26985, 33063, 223, 99),('FVE','FN87','071419','2023-06-29 16:29:43','062023','CO','1083036701','YISELA CALVO','caballero','kra 5 n 34-385  san pablo ','     3218229065','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','24','15116','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:29:44','15116','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','29/06/2023','',15116,0,0,'DO','DOMICILIO','00','VARIOS','2023-06-29 16:29:43',  500, 44348, 223, 99),('FVE','FN87','071420','2023-06-29 16:36:47','062023','CO','36549805','RUBI','ORTEGA','',' 3005275240','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','9259.66386554622','1740.3361344537811','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:36:47','11000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',11000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 16:36:47',  1000, 44347, 223, 99),('FVE','FN87','071420','2023-06-29 16:36:47','062023','CO','36549805','RUBI','ORTEGA','',' 3005275240','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','9259.66386554622','1740.3361344537811','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:36:47','11000','87','BOD. FARMANORTE 87','2','1500','3000','2521.0084033613','478.99159663866','3000','2','0','0','','29/06/2023','',11000,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2023-06-29 16:36:47',  1033, 58852, 223, 99),('FVE','FN87','071420','2023-06-29 16:36:47','062023','CO','36549805','RUBI','ORTEGA','',' 3005275240','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','9259.66386554622','1740.3361344537811','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:36:47','11000','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',11000,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2023-06-29 16:36:47',  1638.588, 54650, 223, 99),('FVE','FN87','071420','2023-06-29 16:36:47','062023','CO','36549805','RUBI','ORTEGA','',' 3005275240','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','5','9259.66386554622','1740.3361344537811','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:36:47','11000','87','BOD. FARMANORTE 87','1','5400','5400','4537.8151260504','862.18487394958','5400','1','0','0','','29/06/2023','',11000,0,0,'7702402057493','PALETA POLET CARAMELO CROCANTE *100 GR','296','MEALS DE COLOMBIA','2023-06-29 16:36:47',  3565.266, 61530, 223, 99),('FVE','FN87','071421','2023-06-29 16:44:54','062023','CO','1123400245','CARLOS','IPUANA','',' 3022359152 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','13445.378151260506','2554.621848739495','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:44:54','16000','87','BOD. FARMANORTE 87','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','29/06/2023','',16000,0,0,'7702535009987','POWERADE FRUTAS TROPICALES *500 ML','144','COCA COLA','2023-06-29 16:44:54',  1478.5, 36974, 223, 99),('FVE','FN87','071421','2023-06-29 16:44:54','062023','CO','1123400245','CARLOS','IPUANA','',' 3022359152 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','13445.378151260506','2554.621848739495','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:44:54','16000','87','BOD. FARMANORTE 87','1','7600','7600','6386.5546218487','1213.4453781513','7600','1','0','0','','29/06/2023','',16000,0,0,'7702189045782','DORITOS MEGA QUESO *185 GR','762','FRITO LAY','2023-06-29 16:44:54',  5341, 48062, 223, 99),('FVE','FN87','071421','2023-06-29 16:44:54','062023','CO','1123400245','CARLOS','IPUANA','',' 3022359152 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','13445.378151260506','2554.621848739495','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:44:54','16000','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','29/06/2023','',16000,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2023-06-29 16:44:54',  1788.297, 34397, 223, 99),('FVE','FN87','071421','2023-06-29 16:44:54','062023','CO','1123400245','CARLOS','IPUANA','',' 3022359152 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','13445.378151260506','2554.621848739495','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:44:54','16000','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',16000,0,0,'7702007212501','CHOCOLATINA JUMBO MANI *40 GR','816','GRUPO NUTRESA','2023-06-29 16:44:54',  1721.9, 53169, 223, 99),('FVE','FN87','071422','2023-06-29 16:49:18','062023','CO','85464282','ALVARO ENRIQUE','THOMAS LOPEZ','MANZANA 9A CASA 1 FILADELFIA','  3233880552','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 16:49:18','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',2500,0,0,'7702090069471','GASEOSA NARANJA POSTOBON *1 LT ECONOLITRO','192','GASEOSAS HIPINTO','2023-06-29 16:49:18',  1750.7202, 60897, 223, 99),('FVE','FN87','071423','2023-06-29 17:01:54','062023','CO','85464282','ALVARO ENRIQUE','THOMAS LOPEZ','MANZANA 9A CASA 1 FILADELFIA','  3233880552','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','840.3361344537816','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 17:01:54','1000','87','BOD. FARMANORTE 87','1','1000','1000','840.33613445378','159.66386554622','1000','1','0','0','','29/06/2023','',1000,0,0,'7590011205158,7','CLUB SOCIAL ORIGINAL *26 GR','754','DISCOB NORTE SAS','2023-06-29 17:01:54',  504.2222, 27452, 223, 99),('FVE','FN87','071424','2023-06-29 17:14:50','062023','CO','12562988','CARLOS A','NU NTILDE EZ','MANZANA 99 CASA 18 CIUDADELA',' 3205280453 3203404752','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','2941.176470588235','558.8235294117646','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 17:14:50','3500','87','BOD. FARMANORTE 87','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','29/06/2023','',3500,0,0,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2023-06-29 17:14:50',  1087, 58744, 223, 99),('FVE','FN87','071424','2023-06-29 17:14:50','062023','CO','12562988','CARLOS A','NU NTILDE EZ','MANZANA 99 CASA 18 CIUDADELA',' 3205280453 3203404752','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','2941.176470588235','558.8235294117646','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 17:14:50','3500','87','BOD. FARMANORTE 87','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','29/06/2023','',3500,0,0,'7702050013025','DORITOS MEGA QUESO *34 GR','762','FRITO LAY','2023-06-29 17:14:50',  1282, 34772, 223, 99),('FVE','FN87','071425','2023-06-29 17:27:10','062023','CO','56076124','VIVIANA','MARTINES','CALLE 8 N  16B - 47 BARRIO  OB',' 30125254658  30125254658  30125254658','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','4','14500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 17:27:11','14500','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','2','0','','29/06/2023','',14500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 17:27:10',  1000, 44347, 223, 99),('FVE','FN87','071425','2023-06-29 17:27:10','062023','CO','56076124','VIVIANA','MARTINES','CALLE 8 N  16B - 47 BARRIO  OB',' 30125254658  30125254658  30125254658','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','4','14500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 17:27:11','14500','87','BOD. FARMANORTE 87','2','6700','13400','13400','0','13400','0','2','0','','29/06/2023','',14500,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-29 17:27:10',  57323.8, 41855, 223, 99),('FVE','FN87','071425','2023-06-29 17:27:10','062023','CO','56076124','VIVIANA','MARTINES','CALLE 8 N  16B - 47 BARRIO  OB',' 30125254658  30125254658  30125254658','932','ALVARO ENRIQUE','THOMAS LOPEZ','3157','BRAYAN YESID','POLO LERMA','','','','','','4','14500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 17:27:11','14500','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','29/06/2023','',14500,0,0,'DO','DOMICILIO','00','VARIOS','2023-06-29 17:27:10',  500, 44348, 223, 99),('FVE','FN87','071426','2023-06-29 17:29:56','062023','CO','26976942','MAIRA MILENA ','TONCEL SIERRA','MZ9A CASA12 FILADELFIA',' 3046634583 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','7500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 17:29:57','7500','87','BOD. FARMANORTE 87','1','7500','7500','7500','0','7500','1','0','0','','29/06/2023','',7500,0,0,'7703712034273','VITAMINA C GOTAS *30 ML COASPHARMA','143','COASPHARMA SAS','2023-06-29 17:29:56',  4743, 24389, 223, 99),('FVE','FN87','071427','2023-06-29 18:09:28','062023','CO','1123400245','CARLOS','IPUANA','',' 3022359152 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:09:28','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','29/06/2023','',2500,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2023-06-29 18:09:28',  1661.1, 56307, 223, 99),('FVE','FN87','071428','2023-06-29 18:23:16','062023','CO','1083040242','NERY ','CEBALLOS','',' 3005234917','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','21100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:23:16','21100','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',0,21100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 18:23:16',  1000, 44347, 223, 99),('FVE','FN87','071428','2023-06-29 18:23:16','062023','CO','1083040242','NERY ','CEBALLOS','',' 3005234917','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','21100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:23:16','21100','87','BOD. FARMANORTE 87','3','7000','21000','21000','0','21000','3','0','0','20','29/06/2023','',0,21100,0,'7707274721053','ACTIVA 21 (LEVO+ETIL) CJA *21 BCN MEDICAL','181','FAES FARMA','2023-06-29 18:23:16',  5476.6202, 46291, 223, 99),('FVE','FN87','071429','2023-06-29 18:23:39','062023','CO','1006572628','ROSA','LARRAda','KRA 21a 4 n 29c-87 bulevard de','    3105120656','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','30400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:23:39','30400','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','29/06/2023','',30400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 18:23:39',  1000, 44347, 223, 99),('FVE','FN87','071429','2023-06-29 18:23:39','062023','CO','1006572628','ROSA','LARRAda','KRA 21a 4 n 29c-87 bulevard de','    3105120656','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','30400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:23:39','30400','87','BOD. FARMANORTE 87','1','26300','26300','26300','0','26300','1','0','0','','29/06/2023','',30400,0,0,'77011626','SULFAPLATA *30 GR','667','BUSSIE OTC','2023-06-29 18:23:39',  23250, 28852, 223, 99),('FVE','FN87','071429','2023-06-29 18:23:39','062023','CO','1006572628','ROSA','LARRAda','KRA 21a 4 n 29c-87 bulevard de','    3105120656','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','30400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:23:39','30400','87','BOD. FARMANORTE 87','3','1000','3000','3000','0','3000','3','0','0','','29/06/2023','',30400,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2023-06-29 18:23:39',  570, 58629, 223, 99),('FVE','FN87','071429','2023-06-29 18:23:39','062023','CO','1006572628','ROSA','LARRAda','KRA 21a 4 n 29c-87 bulevard de','    3105120656','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','30400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:23:39','30400','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','29/06/2023','',30400,0,0,'DO','DOMICILIO','00','VARIOS','2023-06-29 18:23:39',  500, 44348, 223, 99),('FVE','FN87','071430','2023-06-29 18:32:11','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','700','133','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:32:11','833','87','BOD. FARMANORTE 87','1','833','833','700','133','833','1','0','0','','29/06/2023','',833,0,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2023-06-29 18:32:11',  369, 46955, 223, 99),('FVE','FN87','071431','2023-06-29 18:48:13','062023','CO','26976942','MAIRA MILENA ','TONCEL SIERRA','MZ9A CASA12 FILADELFIA',' 3046634583 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','4100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:48:13','4100','87','BOD. FARMANORTE 87','2','2050','4100','4100','0','4100','0','2','0','','29/06/2023','',4100,0,0,'7702057092757','IBUFLASH MIGRAN *30 CAP','382','TECNOQUIMICAS','2023-06-29 18:48:13',  51976.79, 58898, 223, 99),('FVE','FN87','071432','2023-06-29 18:56:11','062023','CO','12562988','CARLOS A','NU NTILDE EZ','MANZANA 99 CASA 18 CIUDADELA',' 3205280453 3203404752','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','10','19373','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:56:11','19373','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','6','0','','29/06/2023','',19373,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 18:56:11',  1000, 44347, 223, 99),('FVE','FN87','071432','2023-06-29 18:56:11','062023','CO','12562988','CARLOS A','NU NTILDE EZ','MANZANA 99 CASA 18 CIUDADELA',' 3205280453 3203404752','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','10','19373','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:56:11','19373','87','BOD. FARMANORTE 87','6','1490','8940','8940','0','8940','0','6','0','','29/06/2023','',19373,0,0,'7702870070888','SEVEDOL EXTRAFUERTE *60 TAB','633','ABBOTT CONSUMER HEALTH CARE','2023-06-29 18:56:11',  47826, 31759, 223, 99);
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','FN87','071432','2023-06-29 18:56:11','062023','CO','12562988','CARLOS A','NU NTILDE EZ','MANZANA 99 CASA 18 CIUDADELA',' 3205280453 3203404752','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','10','19373','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 18:56:11','19373','87','BOD. FARMANORTE 87','1','5133','5133','5133','0','5133','0','1','0','','29/06/2023','',19373,0,0,'7500435107020','VICK VAPORUB 12GR *12 LATAS','336','PROCTER & GAMBLE COLOMBIA','2023-06-29 18:56:11',  55206, 40253, 223, 99),('FVE','FN87','071433','2023-06-29 19:10:57','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','2300.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 19:10:57','2700','87','BOD. FARMANORTE 87','2','100','200','200','0','200','0','2','0','','30/06/2023','',2700,0,0,'7702003010194','CURITAS HANSAPLAST IMPERMEABLES *100 UND','123','BDF (BEIERSDORF) ','2023-06-29 19:10:57',  5894.41, 57605, 223, 99),('FVE','FN87','071433','2023-06-29 19:10:57','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','2300.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 19:10:57','2700','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',2700,0,0,'7702402052412','HELADO ARTESANAL TRES LECHES *70 GR','296','MEALS DE COLOMBIA','2023-06-29 19:10:57',  1638.588, 54650, 223, 99),('FVE','FN87','071434','2023-06-29 19:12:50','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 19:12:50','7000','87','BOD. FARMANORTE 87','1','7000','7000','7000','0','7000','1','0','0','','30/06/2023','',7000,0,0,'6937579900339','PRUEBA DE EMBARAZO CASSETTE ','750','DIAGNOSTICOS BIOMEDICOS','2023-06-29 19:12:50',  1100, 52920, 223, 99),('FVE','FN87','071435','2023-06-29 19:14:21','062023','CO','18002236','ARTURO','JIMENEZ','',' 3106481751 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','22400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 19:14:21','22400','87','BOD. FARMANORTE 87','1','12900','12900','12900','0','12900','1','0','0','','30/06/2023','',0,22400,0,'7707019379464','ACTIVIRAL 5% CREMA TBO * 15G (ACICLOVIR) TBO BIOQUIFAR','130','LABQUIFAR PHARMACEUTICA','2023-06-29 19:14:21',  4000, 45874, 223, 99),('FVE','FN87','071435','2023-06-29 19:14:21','062023','CO','18002236','ARTURO','JIMENEZ','',' 3106481751 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','22400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 19:14:21','22400','87','BOD. FARMANORTE 87','5','1900','9500','9500','0','9500','0','5','0','','30/06/2023','',0,22400,0,'7707019412628','ACTIVIRAL 800MG *10 TAB','130','LABQUIFAR PHARMACEUTICA','2023-06-29 19:14:21',  11000, 45897, 223, 99),('FVE','FN87','071436','2023-06-29 19:16:31','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 19:16:31','2600','87','BOD. FARMANORTE 87','1','2600','2600','2600','0','2600','0','1','0','','30/06/2023','',2600,0,0,'7702057803278','GASTROFAST ADVANCE *10 SACHETS','877','TECNOQUIMICAS VM TQ','2023-06-29 19:16:31',  22594, 58051, 223, 99),('FVE','FN87','071437','2023-06-29 19:28:59','062023','CO','1082896925','SINDY JANETH','GUTIERREZ PACHECO','URB. PARQUES DE BOLIVAR ETAPA ',' 3023889972','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','10','14300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 19:28:59','14300','87','BOD. FARMANORTE 87','10','1430','14300','14300','0','14300','0','10','0','','30/06/2023','',14300,0,0,'7707019402100','ESPASMYDOL X 20 TAB','130','LABQUIFAR PHARMACEUTICA','2023-06-29 19:28:59',  14800, 23565, 223, 99),('FVE','FN87','071438','2023-06-29 20:03:15','062023','CO','1234093913','KINEREERETH','FIGUEREDO','MZA I CASA 186 BULEVAR DE LA R','    3012207138','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','15','9000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:03:15','9000','87','BOD. FARMANORTE 87','10','450','4500','4500','0','4500','0','10','0','','30/06/2023','',9000,0,0,'7709492276612','KEOPS VIT MANDARINA *100 TAB','811','KEOPS FARMACEUTICA','2023-06-29 20:03:15',  16500, 56845, 223, 99),('FVE','FN87','071438','2023-06-29 20:03:15','062023','CO','1234093913','KINEREERETH','FIGUEREDO','MZA I CASA 186 BULEVAR DE LA R','    3012207138','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','15','9000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:03:15','9000','87','BOD. FARMANORTE 87','4','1100','4400','4400','0','4400','0','4','0','','30/06/2023','',9000,0,0,'7451079001529','DOLEX GRIPA 500 MG *100 TAB','616','HALEON (GLAXO OTC)','2023-06-29 20:03:15',  95536.78, 26533, 223, 99),('FVE','FN87','071438','2023-06-29 20:03:15','062023','CO','1234093913','KINEREERETH','FIGUEREDO','MZA I CASA 186 BULEVAR DE LA R','    3012207138','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','15','9000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:03:15','9000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',9000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 20:03:15',  1000, 44347, 223, 99),('FVE','FN87','071439','2023-06-29 20:48:05','062023','CO','1007654703','Luis Mois eacute s ','Baquero ','',' 3226129699 3226129699','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','44721.8487394958','8478.151260504199','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:48:05','53200','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','224','','30/06/2023','',53200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 20:48:05',  1000, 44347, 223, 99),('FVE','FN87','071439','2023-06-29 20:48:05','062023','CO','1007654703','Luis Mois eacute s ','Baquero ','',' 3226129699 3226129699','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','44721.8487394958','8478.151260504199','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:48:05','53200','87','BOD. FARMANORTE 87','1','12200','12200','10252.100840336','1947.8991596639','12200','1','0','224','','30/06/2023','',53200,0,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2023-06-29 20:48:05',  8414.1, 33273, 223, 99),('FVE','FN87','071439','2023-06-29 20:48:05','062023','CO','1007654703','Luis Mois eacute s ','Baquero ','',' 3226129699 3226129699','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','44721.8487394958','8478.151260504199','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:48:05','53200','87','BOD. FARMANORTE 87','1','40900','40900','34369.74789916','6530.2521008403','40900','1','0','224','','30/06/2023','',53200,0,0,'7701021114006','WINNY ULTRATRIM SEC ET4 *30 UND ','653','TECNOQUIMICAS WINNY','2023-06-29 20:48:05',  30058.2, 43224, 223, 99),('FVE','FN87','071440','2023-06-29 20:50:48','062023','CO','36720864','YULIS','BECERRA JIMENEZ','',' 3003780236 ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','19500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:50:49','19500','87','BOD. FARMANORTE 87','1','19500','19500','19500','0','19500','1','0','0','','30/06/2023','',19500,0,0,'7702132009731','ADVIL CHILDREN *60 ML ','616','HALEON (GLAXO OTC)','2023-06-29 20:50:48',  18283.11, 46638, 223, 99),('FVE','FN87','071441','2023-06-29 20:54:14','062023','CO','19591797','CATALINO','SIMANCA','','0 3007459559 ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','5500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 20:54:14','5500','87','BOD. FARMANORTE 87','1','5500','5500','5500','0','5500','1','0','0','','30/06/2023','',5500,0,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2023-06-29 20:54:14',  2900, 48626, 223, 99),('FVE','FN87','071442','2023-06-29 21:01:12','062023','CO','1082400863','ISAMARA','VALENCIA','VILLA BELLA',' 3044342928','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','19000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:01:12','19000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,19000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 21:01:12',  1000, 44347, 223, 99),('FVE','FN87','071442','2023-06-29 21:01:12','062023','CO','1082400863','ISAMARA','VALENCIA','VILLA BELLA',' 3044342928','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','19000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:01:12','19000','87','BOD. FARMANORTE 87','1','18900','18900','18900','0','18900','1','0','0','25','30/06/2023','',0,19000,0,'7703689000448','CYCLOFEM 0.5ML AMP + JERINGA  ','344','PROFAMILIA','2023-06-29 21:01:12',  16550, 40547, 223, 99),('FVE','FN87','071443','2023-06-29 21:03:05','062023','CO','19591797','CATALINO','SIMANCA','','0 3007459559 ','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','40168.06722689076','7631.932773109242','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:03:05','47800','87','BOD. FARMANORTE 87','1','47800','47800','40168.067226891','7631.9327731092','47800','1','0','0','','30/06/2023','',47800,0,0,'7709746106696','MINOXIDIL + CBD 5% TONICO *60 ML','882','AIPHEX GLOBALPHARMA','2023-06-29 21:03:05',  18252, 59045, 223, 99),('FVE','FN87','071444','2023-06-29 21:03:52','062023','CO','26976942','MAIRA MILENA ','TONCEL SIERRA','MZ9A CASA12 FILADELFIA',' 3046634583 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','1344.5378151260504','255.46218487394958','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:03:52','1600','87','BOD. FARMANORTE 87','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','30/06/2023','',1600,0,0,'7622201776664','TRIDENT MENTA *8.5 GR','754','DISCOB NORTE SAS','2023-06-29 21:03:52',  933.73, 57675, 223, 99),('FVE','FN87','071445','2023-06-29 21:05:44','062023','CO','7634360','SERGIO','FORERO','mza d  casa 16 villa universit','   3015990786','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','3361.3445378151264','638.6554621848736','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:05:44','4000','87','BOD. FARMANORTE 87','1','4000','4000','3361.3445378151','638.65546218487','4000','1','0','0','','30/06/2023','',4000,0,0,'7702609009752,7','GASEOSA KOLA ROMAN *1.5 LT','144','COCA COLA','2023-06-29 21:05:44',  2521, 35291, 223, 99),('FVE','FN87','071446','2023-06-29 21:23:13','062023','CO','1082949979','JORGE','SERME NTILDE O','NO DIO','3 3 3022221421','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','28400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:23:13','28400','87','BOD. FARMANORTE 87','1','28400','28400','28400','0','28400','1','0','0','','30/06/2023','',28400,0,0,'7702024025719','KLIM 3+ BOLSA *500 GR','311','NESTLE NUTRICION','2023-06-29 21:23:13',  25782, 38373, 223, 99),('FVE','FN87','071447','2023-06-29 21:27:05','062023','CO','85152004','GEISON','AVENDA ntilde O','',' 000','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','20500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:27:05','20500','87','BOD. FARMANORTE 87','1','20500','20500','20500','0','20500','1','0','0','','30/06/2023','',0,20500,0,'7702870002728','POSTDAY *2 TAB ','696','ABBOTT FARMA CONVENIO','2023-06-29 21:27:05',  8400, 31699, 223, 99),('FVE','FN87','071448','2023-06-29 21:35:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','12400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:35:35','12400','87','BOD. FARMANORTE 87','1','10000','10000','10000','0','10000','1','0','0','','30/06/2023','',12400,0,0,'7707019420722','RESFRYGRIP PLUS *10 CAP','130','LABQUIFAR PHARMACEUTICA','2023-06-29 21:35:35',  4800, 45904, 223, 99),('FVE','FN87','071448','2023-06-29 21:35:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','12400','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:35:35','12400','87','BOD. FARMANORTE 87','1','2400','2400','2400','0','2400','0','1','0','','30/06/2023','',12400,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2023-06-29 21:35:35',  17742.24, 46200, 223, 99),('FVE','FN87','071449','2023-06-29 21:39:33','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:39:33','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',2500,0,0,'7702090066548','GASEOSA UVA POSTOBON *1 LT','192','GASEOSAS HIPINTO','2023-06-29 21:39:33',  1488.095, 60826, 223, 99),('FVE','FN87','071450','2023-06-29 21:42:11','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','7','12284.873949579835','2315.1260504201673','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:42:11','14600.000000000002','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',1.8189894035459E-12,14600,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 21:42:11',  1000, 44347, 223, 99),('FVE','FN87','071450','2023-06-29 21:42:11','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','7','12284.873949579835','2315.1260504201673','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:42:11','14600.000000000002','87','BOD. FARMANORTE 87','2','3500','7000','5882.3529411765','1117.6470588235','7000','2','0','0','','30/06/2023','',1.8189894035459E-12,14600,0,'7702402055802','VASO ALOHA RASPADO KOLA *160 GR ','296','MEALS DE COLOMBIA','2023-06-29 21:42:11',  2285.36, 59636, 223, 99),('FVE','FN87','071450','2023-06-29 21:42:11','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','7','12284.873949579835','2315.1260504201673','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:42:11','14600.000000000002','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',1.8189894035459E-12,14600,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2023-06-29 21:42:11',  1661.1, 56307, 223, 99),('FVE','FN87','071450','2023-06-29 21:42:11','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','7','12284.873949579835','2315.1260504201673','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:42:11','14600.000000000002','87','BOD. FARMANORTE 87','2','2100','4200','3529.4117647059','670.58823529412','4200','2','0','0','','30/06/2023','',1.8189894035459E-12,14600,0,'7702617022149','NECTAR PERA CALIFORNIA *200 ML','823','GLORIA COLOMBIA SA','2023-06-29 21:42:11',  1260, 59088, 223, 99),('FVE','FN87','071450','2023-06-29 21:42:11','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','7','12284.873949579835','2315.1260504201673','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:42:11','14600.000000000002','87','BOD. FARMANORTE 87','1','800','800','672.26890756303','127.73109243697','800','1','0','0','','30/06/2023','',1.8189894035459E-12,14600,0,'77010148','JET CHOCOLATINA *12 GR','816','GRUPO NUTRESA','2023-06-29 21:42:11',  459.42, 47412, 223, 99),('FVE','FN87','071451','2023-06-29 21:43:12','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','4621.848739495798','878.1512605042017','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:43:12','5500','87','BOD. FARMANORTE 87','1','5500','5500','4621.8487394958','878.1512605042','5500','1','0','0','','30/06/2023','',5500,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2023-06-29 21:43:12',  3871.0833, 56142, 223, 99),('FVE','FN87','071452','2023-06-29 21:48:51','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:48:51','4600','87','BOD. FARMANORTE 87','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','30/06/2023','',4600,0,0,'7702535011706','QUATRO TORONJA *1.5 LT','144','COCA COLA','2023-06-29 21:48:51',  2836.1667, 37030, 223, 99),('FVE','FN87','071453','2023-06-29 21:52:19','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','9747.899159663866','1852.1008403361338','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:52:19','11600','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','30/06/2023','',11600,0,0,'7702045200324','BALANCE CLINICAL CREMA MINI  WOMEN * 32 GR','203','HENKEL COLOMBIANA','2023-06-29 21:52:19',  2342.949, 52774, 223, 99),('FVE','FN87','071453','2023-06-29 21:52:19','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','9747.899159663866','1852.1008403361338','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:52:19','11600','87','BOD. FARMANORTE 87','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','30/06/2023','',11600,0,0,'7702010470479','SPEED STICK MEN MINI CLINICAL CREMA *30 GR','145','COLGATE PALMOLIVE COMPANIA','2023-06-29 21:52:19',  2700, 52614, 223, 99),('FVE','FN87','071453','2023-06-29 21:52:19','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','9747.899159663866','1852.1008403361338','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:52:19','11600','87','BOD. FARMANORTE 87','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','30/06/2023','',11600,0,0,'7702057080044','YODORA CREMA *12 GR ','889','TECNOQUIMICAS CONSUMO','2023-06-29 21:52:19',  2319, 42929, 223, 99),('FVE','FN87','071454','2023-06-29 21:59:41','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','3500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 21:59:42','3500','87','BOD. FARMANORTE 87','1','3500','3500','3500','0','3500','1','0','0','','30/06/2023','',3500,0,0,'7707141349359','LACTATO DE RINGER SLN HARTMAN *500 ML','235','BAXTER','2023-06-29 21:59:41',  2420, 28629, 223, 99),('FVE','FN87','071455','2023-06-29 22:02:09','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','3361.3445378151264','638.6554621848736','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:02:09','4000','87','BOD. FARMANORTE 87','1','4000','4000','3361.3445378151','638.65546218487','4000','1','0','0','','30/06/2023','',4000,0,0,'7702031401032','JOHNSONS JABON BABY ORIGINAL X 110 GRS ','221','JOHNSON Y JOHNSON DE COL SA','2023-06-29 22:02:09',  3137.1356, 56126, 223, 99),('FVE','FN87','071456','2023-06-29 22:05:05','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:05:05','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-29 22:05:05',  866.6667, 48019, 223, 99),('FVE','FN87','071457','2023-06-29 22:08:59','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','5462.18487394958','1037.81512605042','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:08:59','6500','87','BOD. FARMANORTE 87','1','6500','6500','5462.1848739496','1037.8151260504','6500','1','0','0','','30/06/2023','',0,6500,0,'7702277082545','CORTAUÑAS GRANDE CURVO FSTYLE','124','BELLEZA EXPRESS SA','2023-06-29 22:08:59',  3570, 46816, 223, 99);
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','FN87','071459','2023-06-29 22:11:13','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','5200','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:11:13','5200','87','BOD. FARMANORTE 87','2','2600','5200','5200','0','5200','0','2','0','','30/06/2023','',5200,0,0,'7702057840310','SAL DE FRUTAS LUA *50 SOBRES','382','TECNOQUIMICAS','2023-06-29 22:11:13',  108660.8, 43290, 223, 99),('FVE','FN87','071460','2023-06-29 22:12:44','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:12:44','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',2500,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2023-06-29 22:12:44',  1661.1, 56307, 223, 99),('FVE','FN87','071461','2023-06-29 22:15:26','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','6218.487394957983','1181.5126050420167','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:15:26','7400','87','BOD. FARMANORTE 87','1','7400','7400','6218.487394958','1181.512605042','7400','1','0','0','','30/06/2023','',7400,0,0,'7702057080075','YODORA CREMA *25 GR','889','TECNOQUIMICAS CONSUMO','2023-06-29 22:15:26',  4832, 42930, 223, 99),('FVE','FN87','071462','2023-06-29 22:16:25','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','7100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:16:25','7100','87','BOD. FARMANORTE 87','1','7100','7100','7100','0','7100','1','0','0','','30/06/2023','',7100,0,0,'7702057073930','MAGNESIA *120 ML','382','TECNOQUIMICAS','2023-06-29 22:16:25',  5801.4, 43118, 223, 99),('FVE','FN87','071463','2023-06-29 22:17:27','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','16900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:17:27','16900','87','BOD. FARMANORTE 87','1','16900','16900','16900','0','16900','1','0','0','','30/06/2023','',16900,0,0,'7707274723224','BACTROSAFE 500 MG * 3 TAB','890','ALLEN PHARMA','2023-06-29 22:17:27',  4950, 58701, 223, 99),('FVE','FN87','071464','2023-06-29 22:19:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','9','29348.73949579832','351.26050420168053','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:19:47','29700','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','6','0','','30/06/2023','',0,29700,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 22:19:47',  1000, 44347, 223, 99),('FVE','FN87','071464','2023-06-29 22:19:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','9','29348.73949579832','351.26050420168053','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:19:47','29700','87','BOD. FARMANORTE 87','6','1750','10500','10500','0','10500','0','6','0','','30/06/2023','',0,29700,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2023-06-29 22:19:47',  134641.28, 43180, 223, 99),('FVE','FN87','071464','2023-06-29 22:19:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','9','29348.73949579832','351.26050420168053','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:19:47','29700','87','BOD. FARMANORTE 87','1','16900','16900','16900','0','16900','1','0','0','','30/06/2023','',0,29700,0,'7707274723224','BACTROSAFE 500 MG * 3 TAB','890','ALLEN PHARMA','2023-06-29 22:19:47',  4950, 58701, 223, 99),('FVE','FN87','071464','2023-06-29 22:19:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','9','29348.73949579832','351.26050420168053','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:19:47','29700','87','BOD. FARMANORTE 87','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','0','','30/06/2023','',0,29700,0,'7702609006508','GASEOSA KOLA ROMAN *400 ML','144','COCA COLA','2023-06-29 22:19:47',  1433.5, 35294, 223, 99),('FVE','FN87','071465','2023-06-29 22:36:19','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:36:19','15000','87','BOD. FARMANORTE 87','1','14900','14900','14900','0','14900','1','0','0','','30/06/2023','',0,15000,0,'7702425805323','KOTEX TOALLA NOCTURNA *16 UNID','141','COLOMBIANA KIMBERLY COLPAPEL','2023-06-29 22:36:19',  13256, 49879, 223, 99),('FVE','FN87','071465','2023-06-29 22:36:19','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:36:19','15000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,15000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-29 22:36:19',  1000, 44347, 223, 99),('FVE','FN87','071466','2023-06-29 22:45:37','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','3500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 22:45:38','3500','87','BOD. FARMANORTE 87','1','3500','3500','3500','0','3500','1','0','0','','30/06/2023','',3500,0,0,'7707141349304','CLORURO DE SODIO  S.S. 9% * 500 ML  ','235','BAXTER','2023-06-29 22:45:37',  2400, 28628, 223, 99),('FVE','FN87','071467','2023-06-29 23:16:42','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4453.781512605043','846.2184873949577','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 23:16:42','5300','87','BOD. FARMANORTE 87','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/06/2023','',5300,0,0,'7702007212105','JET CHOCOLATINA DE LECHE *30 GR','816','GRUPO NUTRESA','2023-06-29 23:16:42',  1239.6, 35626, 223, 99),('FVE','FN87','071467','2023-06-29 23:16:42','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4453.781512605043','846.2184873949577','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 23:16:42','5300','87','BOD. FARMANORTE 87','1','3400','3400','2857.1428571429','542.85714285714','3400','1','0','0','','30/06/2023','',5300,0,0,'7702535027868','AGUA BRISA MANZANA *1.5 LT','144','COCA COLA','2023-06-29 23:16:42',  2104.1666, 57786, 223, 99),('FVE','FN87','071468','2023-06-29 23:35:34','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','10200','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-29 23:35:34','10200','87','BOD. FARMANORTE 87','3','3400','10200','10200','0','10200','0','3','0','','30/06/2023','',10200,0,0,'7702057841256','BONFIEST PLUS *32 SOBRES','382','TECNOQUIMICAS','2023-06-29 23:35:34',  89494.8, 43283, 223, 99),('FVE','FN87','071469','2023-06-30 00:03:00','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','13521.008403361346','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 00:03:00','14000','87','BOD. FARMANORTE 87','2','1500','3000','3000','0','3000','0','2','0','','30/06/2023','',14000,0,0,'7707397791421','DOLEX FORTE *96 TAB   ','616','HALEON (GLAXO OTC)','2023-06-30 00:03:00',  130016.6667, 59553, 223, 99),('FVE','FN87','071469','2023-06-30 00:03:00','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','13521.008403361346','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 00:03:00','14000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',14000,0,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 00:03:00',  6064, 47205, 223, 99),('FVE','FN87','071469','2023-06-30 00:03:00','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','4','13521.008403361346','478.9915966386552','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 00:03:00','14000','87','BOD. FARMANORTE 87','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','30/06/2023','',14000,0,0,'7702535009987','POWERADE FRUTAS TROPICALES *500 ML','144','COCA COLA','2023-06-30 00:03:00',  1478.5, 36974, 223, 99),('FVE','FN87','071470','2023-06-30 00:17:33','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','6134.453781512605','1165.546218487395','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 00:17:33','7300','87','BOD. FARMANORTE 87','1','5500','5500','4621.8487394958','878.1512605042','5500','1','0','0','','30/06/2023','',7300,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2023-06-30 00:17:33',  3871.0833, 56142, 223, 99),('FVE','FN87','071470','2023-06-30 00:17:33','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','6134.453781512605','1165.546218487395','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 00:17:33','7300','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/06/2023','',7300,0,0,'7702914112017','PONQUE GALA CHOCOLATE TAJADA *60 GR','342','PRODUCTOS RAMO','2023-06-30 00:17:33',  1143, 40519, 223, 99),('FVE','FN87','071471','2023-06-30 00:27:08','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','16300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 00:27:09','16300','87','BOD. FARMANORTE 87','1','16300','16300','16300','0','16300','1','0','0','','30/06/2023','',16300,0,0,'7702870003589','POSTDAY *1 TAB ','696','ABBOTT FARMA CONVENIO','2023-06-30 00:27:08',  11094, 31697, 223, 99),('FVE','FN87','071472','2023-06-30 00:28:15','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 00:28:15','2000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 00:28:15',  866.6667, 48019, 223, 99),('FVE','FN87','071473','2023-06-30 01:15:50','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','86666.66666666666','4333.333333333343','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:15:50','91000','87','BOD. FARMANORTE 87','1','91000','91000','86666.666666667','4333.3333333333','91000','1','0','0','','30/06/2023','',0,91000,0,'5000267013626','WHISKY JOHNNIE WALKER RED LABEL *1 LT','827','MEICO LICORES','2023-06-30 01:15:50',  163999, 38151, 223, 99),('FVE','FN87','071474','2023-06-30 01:17:25','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','12101.8487394958','878.1512605042017','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:17:25','12980','87','BOD. FARMANORTE 87','2','1040','2080','2080','0','2080','0','2','0','','30/06/2023','',12980,0,0,'7702123006718','ASPIRINA EFERVESCENTE 500MG *50 TAB','631','BAYER OTC','2023-06-30 01:17:25',  42660, 22880, 223, 99),('FVE','FN87','071474','2023-06-30 01:17:25','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','12101.8487394958','878.1512605042017','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:17:25','12980','87','BOD. FARMANORTE 87','1','3400','3400','3400','0','3400','0','1','0','','30/06/2023','',12980,0,0,'7702057841256','BONFIEST PLUS *32 SOBRES','382','TECNOQUIMICAS','2023-06-30 01:17:25',  89494.8, 43283, 223, 99),('FVE','FN87','071474','2023-06-30 01:17:25','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','12101.8487394958','878.1512605042017','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:17:25','12980','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',12980,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 01:17:25',  866.6667, 48019, 223, 99),('FVE','FN87','071474','2023-06-30 01:17:25','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','12101.8487394958','878.1512605042017','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:17:25','12980','87','BOD. FARMANORTE 87','1','5500','5500','4621.8487394958','878.1512605042','5500','1','0','0','','30/06/2023','',12980,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2023-06-30 01:17:25',  3871.0833, 56142, 223, 99),('FVE','FN87','071475','2023-06-30 01:21:13','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','8000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:21:13','8000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',8000,0,0,'7501125149221','ELECTROLIT FRESA - KIWI SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 01:21:13',  6064, 33981, 223, 99),('FVE','FN87','071476','2023-06-30 01:28:36','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5898.319327731093','1101.6806722689073','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:28:36','7000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',7000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 01:28:36',  1000, 44347, 223, 99),('FVE','FN87','071476','2023-06-30 01:28:36','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5898.319327731093','1101.6806722689073','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:28:36','7000','87','BOD. FARMANORTE 87','2','1600','3200','2689.0756302521','510.9243697479','3200','2','0','0','','30/06/2023','',7000,0,0,'7702189056245','CHOKIS CHOCOBASE * 47 GR','762','FRITO LAY','2023-06-30 01:28:36',  1033, 57555, 223, 99),('FVE','FN87','071476','2023-06-30 01:28:36','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5898.319327731093','1101.6806722689073','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:28:36','7000','87','BOD. FARMANORTE 87','1','1200','1200','1008.4033613445','191.59663865546','1200','1','0','0','','30/06/2023','',7000,0,0,'7702025142910','GALLETAS MINICHIPS CHOCOCHIP *35 GR','816','GRUPO NUTRESA','2023-06-30 01:28:36',  806.5, 57536, 223, 99),('FVE','FN87','071476','2023-06-30 01:28:36','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','5','5898.319327731093','1101.6806722689073','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:28:36','7000','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',7000,0,0,'7702090029857','HIT MORA *500 ML','192','GASEOSAS HIPINTO','2023-06-30 01:28:36',  1488.1, 35520, 223, 99),('FVE','FN87','071477','2023-06-30 01:31:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','7058.823529411765','1341.1764705882351','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:31:48','8400','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/06/2023','',8400,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2023-06-30 01:31:47',  1788.297, 34397, 223, 99),('FVE','FN87','071477','2023-06-30 01:31:47','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','7058.823529411765','1341.1764705882351','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:31:48','8400','87','BOD. FARMANORTE 87','1','5500','5500','4621.8487394958','878.1512605042','5500','1','0','0','','30/06/2023','',8400,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2023-06-30 01:31:47',  3871.0833, 56142, 223, 99),('FVE','FN87','071478','2023-06-30 01:38:18','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','5000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:38:18','5000','87','BOD. FARMANORTE 87','10','300','3000','3000','0','3000','0','10','0','','30/06/2023','',5000,0,0,'7707288820247','BISACODILO 5 MG CJA * 100 TB HUMAX','205','HUMAX PHARMACEUTICAL','2023-06-30 01:38:18',  15900, 46302, 223, 99),('FVE','FN87','071478','2023-06-30 01:38:18','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','11','5000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:38:18','5000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',5000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 01:38:18',  866.6667, 48019, 223, 99),('FVE','FN87','071479','2023-06-30 01:42:32','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:42:32','4000','87','BOD. FARMANORTE 87','2','2000','4000','4000','0','4000','2','0','0','','30/06/2023','',4000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 01:42:32',  866.6667, 48019, 223, 99),('FVE','FN87','071480','2023-06-30 01:52:36','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','2436.9747899159665','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 01:52:36','2900','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/06/2023','',2900,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2023-06-30 01:52:36',  1788.297, 34397, 223, 99),('FVE','FN87','071481','2023-06-30 02:07:16','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4957.983193277311','942.0168067226887','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 02:07:16','5900','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/06/2023','',5900,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2023-06-30 02:07:16',  1788.297, 34397, 223, 99),('FVE','FN87','071481','2023-06-30 02:07:16','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4957.983193277311','942.0168067226887','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 02:07:16','5900','87','BOD. FARMANORTE 87','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','30/06/2023','',5900,0,0,'7702535009994','POWERADE BLAST *500 ML','144','COCA COLA','2023-06-30 02:07:16',  1642.8333, 36976, 223, 99);
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','FN87','071483','2023-06-30 02:29:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','16444.537815126052','255.46218487394958','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 02:29:35','16700','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',16700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 02:29:35',  1000, 44347, 223, 99),('FVE','FN87','071483','2023-06-30 02:29:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','16444.537815126052','255.46218487394958','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 02:29:35','16700','87','BOD. FARMANORTE 87','1','15000','15000','15000','0','15000','1','0','0','','30/06/2023','',16700,0,0,'7702132007706','TODAY HOT SENSATION X 3 PRESERVATIVOS','616','HALEON (GLAXO OTC)','2023-06-30 02:29:35',  10843.7102, 39150, 223, 99),('FVE','FN87','071483','2023-06-30 02:29:35','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','16444.537815126052','255.46218487394958','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 02:29:35','16700','87','BOD. FARMANORTE 87','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','30/06/2023','',16700,0,0,'7622201776633','TRIDENT SANDIA *8.5 GR','754','DISCOB NORTE SAS','2023-06-30 02:29:35',  933.7222, 57672, 223, 99),('FVE','FN87','071484','2023-06-30 02:37:50','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','4621.848739495798','878.1512605042017','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 02:37:50','5500','87','BOD. FARMANORTE 87','1','5500','5500','4621.8487394958','878.1512605042','5500','1','0','0','','30/06/2023','',5500,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2023-06-30 02:37:50',  3871.0833, 56142, 223, 99),('FVE','FN87','071485','2023-06-30 02:56:58','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 02:56:59','4000','87','BOD. FARMANORTE 87','2','2000','4000','4000','0','4000','2','0','0','','30/06/2023','',4000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 02:56:58',  866.6667, 48019, 223, 99),('FVE','FN87','071486','2023-06-30 03:56:29','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4436.9747899159665','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 03:56:29','4900','87','BOD. FARMANORTE 87','1','2900','2900','2436.974789916','463.02521008403','2900','1','0','0','','30/06/2023','',4900,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2023-06-30 03:56:29',  1788.297, 34397, 223, 99),('FVE','FN87','071486','2023-06-30 03:56:29','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','2','4436.9747899159665','463.02521008403346','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 03:56:29','4900','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','1','0','0','','30/06/2023','',4900,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2023-06-30 03:56:29',  866.6667, 48019, 223, 99),('FVE','FN87','071487','2023-06-30 05:42:05','062023','CO','1082896925','SINDY JANETH','GUTIERREZ PACHECO','URB. PARQUES DE BOLIVAR ETAPA ',' 3023889972','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','13500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 05:42:05','13500','87','BOD. FARMANORTE 87','1','13500','13500','13500','0','13500','1','0','0','','30/06/2023','',13500,0,0,'7709530287648','TREEVER OFT *5ML','607','QUIRUPOS','2023-06-30 05:42:05',  8900.1, 57222, 223, 99),('FVE','FN87','071488','2023-06-30 05:52:55','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','1344.5378151260506','255.46218487394947','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 05:52:55','1600','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','30/06/2023','',1600,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-30 05:52:55',  9360, 46328, 223, 99),('FVE','FN87','071488','2023-06-30 05:52:55','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','3','1344.5378151260506','255.46218487394947','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 05:52:55','1600','87','BOD. FARMANORTE 87','1','600','600','504.20168067227','95.798319327731','600','1','0','0','','30/06/2023','',1600,0,0,'D1002','RECOLECTOR ORINA TAPA AZUL D1002','402','PARACLINICAS','2023-06-30 05:52:55',  228.3177, 39236, 223, 99),('FVE','FN87','071489','2023-06-30 06:44:18','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','3364','SINDY JANETH','GUTIERREZ PACHECO','','TERCERO','VARIOS','','','','','','1','4300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 06:44:18','4300','87','BOD. FARMANORTE 87','1','4300','4300','4300','0','4300','1','0','0','','30/06/2023','',4300,0,0,'7703038062646','AMLODIPINO 5 MG *10 TAB LAPROFF','275','LAPROFF','2023-06-30 06:44:18',  3456.95, 30409, 223, 99),('FVE','FN87','071490','2023-06-30 07:16:09','062023','CO','1036941004','ESTEBAN ','HAYALA','',' 3014834815','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','13','21981.51260504202','718.4873949579828','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:16:09','22700','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',22700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 07:16:09',  1000, 44347, 223, 99),('FVE','FN87','071490','2023-06-30 07:16:09','062023','CO','1036941004','ESTEBAN ','HAYALA','',' 3014834815','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','13','21981.51260504202','718.4873949579828','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:16:09','22700','87','BOD. FARMANORTE 87','1','17100','17100','17100','0','17100','1','0','0','','30/06/2023','',22700,0,0,'7706309000132','OFTALMOTRISOL X 15 ML  ','260','INCOBRA FARMA','2023-06-30 07:16:09',  8000, 29930, 223, 99),('FVE','FN87','071490','2023-06-30 07:16:09','062023','CO','1036941004','ESTEBAN ','HAYALA','',' 3014834815','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','13','21981.51260504202','718.4873949579828','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:16:09','22700','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','30/06/2023','',22700,0,0,'DO','DOMICILIO','00','VARIOS','2023-06-30 07:16:09',  500, 44348, 223, 99),('FVE','FN87','071490','2023-06-30 07:16:09','062023','CO','1036941004','ESTEBAN ','HAYALA','',' 3014834815','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','13','21981.51260504202','718.4873949579828','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:16:09','22700','87','BOD. FARMANORTE 87','10','450','4500','3781.512605042','718.48739495798','4500','0','10','0','','30/06/2023','',22700,0,0,'7707321120068','VITAMINA C 500MG + ZINC 5MG CJA *100 TAB','1000','NATURALMENTE','2023-06-30 07:16:09',  14500, 61795, 223, 99),('FVE','FN87','071491','2023-06-30 07:21:00','062023','CO','1004499900','Tania Margarita ','Cortes pe ntilde a','MANZANA 74 CASA 2 EL PANDO',' 3008778285','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','6974.789915966387','1325.2100840336134','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:21:00','8300','87','BOD. FARMANORTE 87','1','8300','8300','6974.7899159664','1325.2100840336','8300','1','0','35','','30/06/2023','',8300,0,0,'7702001044702','AVENA ALPINA *1000 ML ','110','ALPINA PRODS. ALIMENTICIOS S.A.','2023-06-30 07:21:00',  5744, 22452, 223, 99),('FVE','FN87','071492','2023-06-30 07:33:16','062023','CO','789654123','ROSA','DIAZ','','5869574  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','11344.53781512605','2155.4621848739494','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:33:16','13500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',13500,0,0,'7702090029871','HIT NARANJA PINA *500 ML','192','GASEOSAS HIPINTO','2023-06-30 07:33:16',  1488.0925, 35521, 223, 99),('FVE','FN87','071492','2023-06-30 07:33:16','062023','CO','789654123','ROSA','DIAZ','','5869574  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','11344.53781512605','2155.4621848739494','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:33:16','13500','87','BOD. FARMANORTE 87','2','5500','11000','9243.6974789916','1756.3025210084','11000','2','0','0','','30/06/2023','',13500,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2023-06-30 07:33:16',  3871.0833, 56142, 223, 99),('FVE','FN87','071493','2023-06-30 07:43:43','062023','CO','1004347568','ROYER','MACHACON','','0 0 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','10','17250','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:43:43','17250','87','BOD. FARMANORTE 87','10','1725','17250','17250','0','17250','0','10','0','','30/06/2023','',17250,0,0,'7703712080263','FLOXFAR 400 MG CJA * 20 TB','387','TRIDEX FARMACEUTICA','2023-06-30 07:43:43',  17640, 54769, 223, 99),('FVE','FN87','071494','2023-06-30 07:46:36','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','6','6500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 07:46:36','6500','87','BOD. FARMANORTE 87','6.5','1000','6500','6500','0','6500','7','0','0','','30/06/2023','',6500,0,0,'R1001','PAQUETES CONEXRED','692','CONEXRED SA','2023-06-30 07:46:36',  500, 59924, 223, 99),('FVE','FN87','071495','2023-06-30 08:00:23','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','6000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:00:23','6000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',6000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 08:00:23',  1000, 44347, 223, 99),('FVE','FN87','071495','2023-06-30 08:00:23','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','6000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:00:23','6000','87','BOD. FARMANORTE 87','1','5900','5900','5900','0','5900','1','0','0','','30/06/2023','',6000,0,0,'7706569001467','CETIRIZINA 10MG *10 TAB','614','A.G. MEDICAMENTOS','2023-06-30 08:00:23',  4295, 31293, 223, 99),('FVE','FN87','071496','2023-06-30 08:03:14','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','8000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:03:14','8000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',8000,0,0,'7501125149221','ELECTROLIT FRESA - KIWI SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 08:03:14',  6064, 33981, 223, 99),('FVE','FN87','071497','2023-06-30 08:33:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','2840.3361344537816','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:33:46','3000','87','BOD. FARMANORTE 87','1','2000','2000','2000','0','2000','0','1','0','','30/06/2023','',3000,0,0,'7703445030047','FLUIMUCIL 200 MG *30 S/S ','397','ZAMBON COLOMBIA ','2023-06-30 08:33:46',  41322.3714, 44300, 223, 99),('FVE','FN87','071497','2023-06-30 08:33:46','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','2840.3361344537816','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:33:46','3000','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','30/06/2023','',3000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-30 08:33:46',  9360, 46328, 223, 99),('FVE','FN87','071498','2023-06-30 08:49:25','062023','CO','1082952765','LORAINE','SANCHEZ','',' 3012293587','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','14000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:49:25','14000','87','BOD. FARMANORTE 87','1','14000','14000','14000','0','14000','1','0','0','','30/06/2023','',0,14000,0,'7709225183057','NOVOXICAN 15MG *10 TAB','873','NOVOFAR','2023-06-30 08:49:25',  3412, 58552, 223, 99),('FVE','FN87','071499','2023-06-30 08:50:09','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','19441.176470588234','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:50:09','20000','87','BOD. FARMANORTE 87','1','16500','16500','16500','0','16500','1','0','0','','30/06/2023','',20000,0,0,'736085132069','NAZIL GOTAS OFT *15 ML','636','SOPHIA DE COLOMBIA OTC','2023-06-30 08:50:09',  7767.3, 31133, 223, 99),('FVE','FN87','071499','2023-06-30 08:50:09','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','19441.176470588234','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:50:09','20000','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','30/06/2023','',20000,0,0,'7702192422051','GATORADE TROPICAL FRUIT *500 ML','192','GASEOSAS HIPINTO','2023-06-30 08:50:09',  2451, 25826, 223, 99),('FVE','FN87','071500','2023-06-30 08:54:22','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','3377.310924369748','622.6890756302519','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:54:22','4000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',4000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 08:54:22',  1000, 44347, 223, 99),('FVE','FN87','071500','2023-06-30 08:54:22','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','3377.310924369748','622.6890756302519','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 08:54:22','4000','87','BOD. FARMANORTE 87','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','30/06/2023','',4000,0,0,'7702090038071','JUGO HIT MANGO *1 LT','192','GASEOSAS HIPINTO','2023-06-30 08:54:22',  2706.7227, 53815, 223, 99),('FVE','FN87','071501','2023-06-30 09:23:33','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','840.3361344537816','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 09:23:33','1000','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','30/06/2023','',1000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-30 09:23:33',  9360, 46328, 223, 99),('FVE','FN87','071502','2023-06-30 09:30:13','062023','CO','12594867','WALBERTO','RODRIGUEZ','NIEVES',' 3128150930 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','9100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 09:30:13','9100','87','BOD. FARMANORTE 87','1','9100','9100','9100','0','9100','1','0','0','','30/06/2023','',9100,0,0,'74410248','LECHE DE MAGNESIA PHILLIPS *120 ML','116','ASPEN COLOMBIANA SAS','2023-06-30 09:30:13',  7989, 28686, 223, 99),('FVE','FN87','071503','2023-06-30 09:45:26','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','10','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 09:45:26','7000','87','BOD. FARMANORTE 87','10','700','7000','7000','0','7000','0','10','0','','30/06/2023','',7000,0,0,'7451079000669,7','DOLEX 500MG *200 TAB','616','HALEON (GLAXO OTC)','2023-06-30 09:45:26',  122765.24, 26516, 223, 99),('FVE','FN87','071504','2023-06-30 10:38:05','062023','CO','1083028173','IVAN','DE  LA ROSA','',' 3155918158','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','22689.0756302521','4310.9243697479','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 10:38:06','27000','87','BOD. FARMANORTE 87','1','27000','27000','22689.075630252','4310.9243697479','27000','1','0','0','','30/06/2023','',0,27000,0,'7702057089290','YODORA CREMA *60 GR GRATIS 32 GR','889','TECNOQUIMICAS CONSUMO','2023-06-30 10:38:05',  17768, 42934, 223, 99),('FVE','FN87','071505','2023-06-30 10:44:24','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','13041.176470588238','2458.823529411763','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 10:44:25','15500','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',3500,12000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 10:44:24',  1000, 44347, 223, 99),('FVE','FN87','071505','2023-06-30 10:44:24','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','13041.176470588238','2458.823529411763','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 10:44:25','15500','87','BOD. FARMANORTE 87','1','10200','10200','8571.4285714286','1628.5714285714','10200','1','0','0','','30/06/2023','',3500,12000,0,'7509546000343','COLGATE CREMA DENTAL T/ACCION *100 ML','145','COLGATE PALMOLIVE COMPANIA','2023-06-30 10:44:24',  7493, 24460, 223, 99),('FVE','FN87','071505','2023-06-30 10:44:24','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','13041.176470588238','2458.823529411763','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 10:44:25','15500','87','BOD. FARMANORTE 87','1','5200','5200','4369.7478991597','830.25210084034','5200','1','0','0','','30/06/2023','',3500,12000,0,'7702010420955','PROTEX JABON AVENA *110 GR','145','COLGATE PALMOLIVE COMPANIA','2023-06-30 10:44:24',  3096, 52613, 223, 99),('FVE','FN87','071506','2023-06-30 10:45:09','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','2500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 10:45:09','2500','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','1','0','','30/06/2023','',2500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 10:45:09',  1000, 44347, 223, 99),('FVE','FN87','071506','2023-06-30 10:45:09','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','2500','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 10:45:09','2500','87','BOD. FARMANORTE 87','1','2400','2400','2400','0','2400','0','1','0','','30/06/2023','',2500,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2023-06-30 10:45:09',  17742.24, 46200, 223, 99),('FVE','FN87','071507','2023-06-30 10:51:57','062023','CO','26686377','FELICIA','ahumada parra','TORRE A APTO 301MIRADOR DE LA ',' 3002526569  3002526569 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','15','25210.084033613446','4789.915966386554','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 10:51:57','30000','87','BOD. FARMANORTE 87','15','2000','30000','25210.084033613','4789.9159663866','30000','0','15','0','','30/06/2023','',30000,0,0,'7709437129317','ENERXIS MULTIVITAMINICO CJA * 30 CAPS','1009','ENERXIS','2023-06-30 10:51:57',  12000, 56915, 223, 99);
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','FN87','071509','2023-06-30 11:19:45','062023','CO','85448528','JORJE ','CORRALES','',' 0 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','16600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 11:19:45','16600','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',16600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 11:19:45',  1000, 44347, 223, 99),('FVE','FN87','071509','2023-06-30 11:19:45','062023','CO','85448528','JORJE ','CORRALES','',' 0 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','16600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 11:19:45','16600','87','BOD. FARMANORTE 87','1','16500','16500','16500','0','16500','1','0','0','','30/06/2023','',16600,0,0,'736085132069','NAZIL GOTAS OFT *15 ML','636','SOPHIA DE COLOMBIA OTC','2023-06-30 11:19:45',  7767.3, 31133, 223, 99),('FVE','FN87','071510','2023-06-30 11:29:03','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','5340.336134453782','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 11:29:03','5500','87','BOD. FARMANORTE 87','1','4500','4500','4500','0','4500','1','0','0','','30/06/2023','',5500,0,0,'7702057075088','ALCOHOL MK *350 ML ','624','TECNOQUIMICAS CUIDADO DE HERIDA','2023-06-30 11:29:03',  3478, 42766, 223, 99),('FVE','FN87','071510','2023-06-30 11:29:03','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','3','5340.336134453782','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 11:29:03','5500','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','30/06/2023','',5500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-30 11:29:03',  9360, 46328, 223, 99),('FVE','FN87','071511','2023-06-30 12:09:00','062023','CO','789654','PEDRO','TORRES','','0  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','7242.857142857143','1357.1428571428567','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:09:00','8600','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',8600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 12:09:00',  1000, 44347, 223, 99),('FVE','FN87','071511','2023-06-30 12:09:00','062023','CO','789654','PEDRO','TORRES','','0  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','7242.857142857143','1357.1428571428567','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:09:00','8600','87','BOD. FARMANORTE 87','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','0','','30/06/2023','',8600,0,0,'7702007212105','JET CHOCOLATINA DE LECHE *30 GR','816','GRUPO NUTRESA','2023-06-30 12:09:00',  1239.6, 35626, 223, 99),('FVE','FN87','071511','2023-06-30 12:09:00','062023','CO','789654','PEDRO','TORRES','','0  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','7242.857142857143','1357.1428571428567','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:09:00','8600','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',8600,0,0,'7702007212501','CHOCOLATINA JUMBO MANI *40 GR','816','GRUPO NUTRESA','2023-06-30 12:09:00',  1721.9, 53169, 223, 99),('FVE','FN87','071511','2023-06-30 12:09:00','062023','CO','789654','PEDRO','TORRES','','0  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','7242.857142857143','1357.1428571428567','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:09:00','8600','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',8600,0,0,'7702914114004','PONQUE CHOCORAMO TAJADA *65 GR','342','PRODUCTOS RAMO','2023-06-30 12:09:00',  1505, 40516, 223, 99),('FVE','FN87','071511','2023-06-30 12:09:00','062023','CO','789654','PEDRO','TORRES','','0  ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','5','7242.857142857143','1357.1428571428567','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:09:00','8600','87','BOD. FARMANORTE 87','1','1600','1600','1344.5378151261','255.46218487395','1600','1','0','0','','30/06/2023','',8600,0,0,'7702133265938','TRIDENT MORA AZUL *8.5 GR','754','DISCOB NORTE SAS','2023-06-30 12:09:00',  933.72, 37847, 223, 99),('FVE','FN87','071512','2023-06-30 12:31:23','062023','CO','12559286','NORBERTO ','DE LEON','',' 3008372321','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:31:24','15000','87','BOD. FARMANORTE 87','1','15000','15000','15000','0','15000','1','0','0','','30/06/2023','',15000,0,0,'7702132007706','TODAY HOT SENSATION X 3 PRESERVATIVOS','616','HALEON (GLAXO OTC)','2023-06-30 12:31:23',  10843.7102, 39150, 223, 99),('FVE','FN87','071513','2023-06-30 12:31:51','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','8000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:31:51','8000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',8000,0,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 12:31:51',  6064, 47205, 223, 99),('FVE','FN87','071514','2023-06-30 12:51:59','062023','CO','1083033675','MARTA ','GRANADOS','CRA 21 A  29K4-41 EL TREBOL',' 3105490699 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:52:00','7000','87','BOD. FARMANORTE 87','2','3500','7000','7000','0','7000','0','2','0','','30/06/2023','',7000,0,0,'7709990110999','COPROBIOTIC+PREBIOTICOS+PROBIOTICOS CJA *20S/S','1000','NATURALMENTE','2023-06-30 12:51:59',  26000, 61315, 223, 99),('FVE','FN87','071515','2023-06-30 12:52:45','062023','CO','1083033675','MARTA ','GRANADOS','CRA 21 A  29K4-41 EL TREBOL',' 3105490699 ','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','8000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 12:52:46','8000','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',8000,0,0,'7501125104688','ELECTROLIT NARANJA-MANDARINA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 12:52:45',  6064, 47204, 223, 99),('FVE','FN87','071516','2023-06-30 13:24:50','062023','CO','1129535386','nataly','granadoz','calle 29h n 30-11 santa ana ','    3145338997','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','28900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 13:24:51','28900','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,28900,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 13:24:50',  1000, 44347, 223, 99),('FVE','FN87','071516','2023-06-30 13:24:50','062023','CO','1129535386','nataly','granadoz','calle 29h n 30-11 santa ana ','    3145338997','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','28900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 13:24:51','28900','87','BOD. FARMANORTE 87','1','8000','8000','8000','0','8000','1','0','0','','30/06/2023','',0,28900,0,'7501125149221','ELECTROLIT FRESA - KIWI SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2023-06-30 13:24:50',  6064, 33981, 223, 99),('FVE','FN87','071516','2023-06-30 13:24:50','062023','CO','1129535386','nataly','granadoz','calle 29h n 30-11 santa ana ','    3145338997','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','28900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 13:24:51','28900','87','BOD. FARMANORTE 87','3','6600','19800','19800','0','19800','0','3','0','','30/06/2023','',0,28900,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2023-06-30 13:24:50',  60043, 31775, 223, 99),('FVE','FN87','071516','2023-06-30 13:24:50','062023','CO','1129535386','nataly','granadoz','calle 29h n 30-11 santa ana ','    3145338997','932','ALVARO ENRIQUE','THOMAS LOPEZ','3256','LEIDER MANUEL','PUA NAVARRO','','','','','','6','28900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 13:24:51','28900','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','30/06/2023','',0,28900,0,'DO','DOMICILIO','00','VARIOS','2023-06-30 13:24:50',  500, 44348, 223, 99),('FVE','FN87','071517','2023-06-30 13:27:21','062023','CO','1004284052','ARIEL','SAUMETH','',' NO DIO','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','10','15000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 13:27:21','15000','87','BOD. FARMANORTE 87','10','1500','15000','15000','0','15000','0','10','0','','30/06/2023','',15000,0,0,'7707019312645','KLIACEF 500 MG X 20 TABLS ','130','LABQUIFAR PHARMACEUTICA','2023-06-30 13:27:21',  8550, 23577, 223, 99),('FVE','FN87','071518','2023-06-30 13:57:14','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','840.3361344537816','159.6638655462184','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 13:57:15','1000','87','BOD. FARMANORTE 87','2','500','1000','840.33613445378','159.66386554622','1000','0','2','4','','30/06/2023','',1000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2023-06-30 13:57:14',  9360, 46328, 223, 99),('FVE','FN87','071519','2023-06-30 14:13:08','062023','CO','1140873607','ANDRES','ASHTON','',' 3007427938 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','4873.949579831933','926.0504201680669','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:13:09','5800','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/06/2023','',0,5800,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2023-06-30 14:13:08',  1197.56, 50688, 223, 99),('FVE','FN87','071519','2023-06-30 14:13:08','062023','CO','1140873607','ANDRES','ASHTON','',' 3007427938 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','4873.949579831933','926.0504201680669','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:13:09','5800','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',0,5800,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2023-06-30 14:13:08',  1693, 60339, 223, 99),('FVE','FN87','071519','2023-06-30 14:13:08','062023','CO','1140873607','ANDRES','ASHTON','',' 3007427938 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','4873.949579831933','926.0504201680669','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:13:09','5800','87','BOD. FARMANORTE 87','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','0','','30/06/2023','',0,5800,0,'7702402043359,7','PALETA ALOHA AGUA LIMON X 65 GR','296','MEALS DE COLOMBIA','2023-06-30 14:13:08',  1008, 32692, 223, 99),('FVE','FN87','071520','2023-06-30 14:39:25','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','2873.109243697479','526.8907563025209','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:39:25','3400','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','14','','30/06/2023','',3400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 14:39:25',  1000, 44347, 223, 99),('FVE','FN87','071520','2023-06-30 14:39:25','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','2873.109243697479','526.8907563025209','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:39:25','3400','87','BOD. FARMANORTE 87','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','14','','30/06/2023','',3400,0,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2023-06-30 14:39:25',  1224, 55601, 223, 99),('FVE','FN87','071520','2023-06-30 14:39:25','062023','CO','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','2873.109243697479','526.8907563025209','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:39:25','3400','87','BOD. FARMANORTE 87','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','14','','30/06/2023','',3400,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2023-06-30 14:39:25',  1033, 58852, 223, 99),('FVE','FN87','071521','2023-06-30 14:40:47','062023','CO','85464282','ALVARO ENRIQUE','THOMAS LOPEZ','MANZANA 9A CASA 1 FILADELFIA','  3233880552','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:40:48','2500','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',2500,0,0,'7702090069471','GASEOSA NARANJA POSTOBON *1 LT ECONOLITRO','192','GASEOSAS HIPINTO','2023-06-30 14:40:47',  1750.7202, 60897, 223, 99),('FVE','FN87','071522','2023-06-30 14:53:18','062023','CO','12564807','CARLOS','GARCIA','kra 21 b  n 29 g-19 villa bell','  3022784651','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','28116.806722689074','383.19327731092426','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:53:18','28500','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',28500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 14:53:18',  1000, 44347, 223, 99),('FVE','FN87','071522','2023-06-30 14:53:18','062023','CO','12564807','CARLOS','GARCIA','kra 21 b  n 29 g-19 villa bell','  3022784651','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','28116.806722689074','383.19327731092426','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:53:18','28500','87','BOD. FARMANORTE 87','1','16000','16000','16000','0','16000','1','0','0','','30/06/2023','',28500,0,0,'7707019413908','TRICLIMBAC SOLUCION OTICA *10 ML','130','LABQUIFAR PHARMACEUTICA','2023-06-30 14:53:18',  6600, 45901, 223, 99),('FVE','FN87','071522','2023-06-30 14:53:18','062023','CO','12564807','CARLOS','GARCIA','kra 21 b  n 29 g-19 villa bell','  3022784651','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','28116.806722689074','383.19327731092426','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:53:18','28500','87','BOD. FARMANORTE 87','1','10000','10000','10000','0','10000','1','0','0','','30/06/2023','',28500,0,0,'7707019420722','RESFRYGRIP PLUS *10 CAP','130','LABQUIFAR PHARMACEUTICA','2023-06-30 14:53:18',  4800, 45904, 223, 99),('FVE','FN87','071522','2023-06-30 14:53:18','062023','CO','12564807','CARLOS','GARCIA','kra 21 b  n 29 g-19 villa bell','  3022784651','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','28116.806722689074','383.19327731092426','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:53:18','28500','87','BOD. FARMANORTE 87','1','2400','2400','2016.8067226891','383.19327731092','2400','1','0','0','','30/06/2023','',28500,0,0,'7702090060553','CRISTAL ALOE BEBIDA DE AGUA CON ALOE Y LIMON *330 ML','192','GASEOSAS HIPINTO','2023-06-30 14:53:18',  1400.56, 55771, 223, 99),('FVE','FN87','071523','2023-06-30 14:56:07','062023','CO','1082972196','KEVIN','BRUZON','mz a casa 10 a urb villa marbe','  NO DIO','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','12','26722.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:56:07','28000','87','BOD. FARMANORTE 87','10','2000','20000','20000','0','20000','0','10','0','','30/06/2023','',0,28000,0,'7703445030047','FLUIMUCIL 200 MG *30 S/S ','397','ZAMBON COLOMBIA ','2023-06-30 14:56:07',  41322.3714, 44300, 223, 99),('FVE','FN87','071523','2023-06-30 14:56:07','062023','CO','1082972196','KEVIN','BRUZON','mz a casa 10 a urb villa marbe','  NO DIO','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','12','26722.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:56:07','28000','87','BOD. FARMANORTE 87','1','4500','4500','3781.512605042','718.48739495798','4500','1','0','0','','30/06/2023','',0,28000,0,'7702402054393','PALETA POLET FRUTOS DEL BOSQUE *70 GR','296','MEALS DE COLOMBIA','2023-06-30 14:56:07',  2980, 56380, 223, 99),('FVE','FN87','071523','2023-06-30 14:56:07','062023','CO','1082972196','KEVIN','BRUZON','mz a casa 10 a urb villa marbe','  NO DIO','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','12','26722.689075630253','1277.3109243697472','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 14:56:07','28000','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','30/06/2023','',0,28000,0,'7702402055802','VASO ALOHA RASPADO KOLA *160 GR ','296','MEALS DE COLOMBIA','2023-06-30 14:56:07',  2285.36, 59636, 223, 99),('FVE','FN87','071524','2023-06-30 15:06:12','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','5126.050420168067','973.9495798319326','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:06:12','6100','87','BOD. FARMANORTE 87','2','1800','3600','3025.2100840336','574.78991596639','3600','2','0','0','','30/06/2023','',6100,0,0,'7702402054171','PALETA CHOCOLISTO *50 GR','296','MEALS DE COLOMBIA','2023-06-30 15:06:12',  1224, 55601, 223, 99),('FVE','FN87','071524','2023-06-30 15:06:12','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','3','5126.050420168067','973.9495798319326','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:06:12','6100','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',6100,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2023-06-30 15:06:12',  1693, 60339, 223, 99),('FVE','FN87','071525','2023-06-30 15:18:04','062023','CO','39030757','CARMEN','RETAMOZO MENDOZA','',' 3014206631','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','4300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:18:04','4300','87','BOD. FARMANORTE 87','1','4300','4300','4300','0','4300','1','0','0','','30/06/2023','',4300,0,0,'7703038062646','AMLODIPINO 5 MG *10 TAB LAPROFF','275','LAPROFF','2023-06-30 15:18:04',  3456.95, 30409, 223, 99),('FVE','FN87','071526','2023-06-30 15:29:21','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','2941.1764705882356','558.8235294117644','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:29:21','3500','87','BOD. FARMANORTE 87','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','30/06/2023','',3500,0,0,'7702004003508','CERVEZA CLUB COLOMBIA DORADA LATA *330 ML','119','BAVARIA S.A.','2023-06-30 15:29:21',  24233.5, 22832, 223, 99),('FVE','FN87','071527','2023-06-30 15:40:33','062023','CO','1082903670','AYLIN','ACOSTA','',' 3013865276 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','40210.08403361344','4789.915966386554','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:40:34','45000','87','BOD. FARMANORTE 87','1','15000','15000','15000','0','15000','1','0','0','','30/06/2023','',45000,0,0,'7707019344202','NITOXIPAR 500 MG X 6 TAB','130','LABQUIFAR PHARMACEUTICA','2023-06-30 15:40:33',  8800, 23597, 223, 99),('FVE','FN87','071527','2023-06-30 15:40:33','062023','CO','1082903670','AYLIN','ACOSTA','',' 3013865276 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','2','40210.08403361344','4789.915966386554','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:40:34','45000','87','BOD. FARMANORTE 87','1','30000','30000','25210.084033613','4789.9159663866','30000','1','0','0','','30/06/2023','',45000,0,0,'7709562377607','VIT MAX B + ZINC CJA * 30 CAPS','1000','NATURALMENTE','2023-06-30 15:40:33',  7200, 48941, 223, 99),('FVE','FN87','071528','2023-06-30 15:42:44','062023','CO','1083049166','DEVINSON','TRIGOS','',' 123 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','13050.420168067227','1149.5798319327732','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:42:44','14200','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',14200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 15:42:44',  1000, 44347, 223, 99);
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','FN87','071528','2023-06-30 15:42:44','062023','CO','1083049166','DEVINSON','TRIGOS','',' 123 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','13050.420168067227','1149.5798319327732','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:42:44','14200','87','BOD. FARMANORTE 87','4','1800','7200','6050.4201680672','1149.5798319328','7200','4','0','0','','30/06/2023','',14200,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2023-06-30 15:42:44',  1197.56, 50688, 223, 99),('FVE','FN87','071529','2023-06-30 15:59:26','062023','CO','1128324452','JORGE','MARTINEZ','',' 3145414788','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','37900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 15:59:26','37900','87','BOD. FARMANORTE 87','1','37900','37900','37900','0','37900','1','0','0','','30/06/2023','',37900,0,0,'4104480705151','ABRILAR EA 575 JBE *100 ML ','365','MEGALABS','2023-06-30 15:59:26',  31990, 41953, 223, 99),('FVE','FN87','071530','2023-06-30 16:05:21','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','4','10800','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:05:21','10800','87','BOD. FARMANORTE 87','4','2700','10800','10800','0','10800','0','4','0','','30/06/2023','',10800,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2023-06-30 16:05:21',  27350, 46776, 223, 99),('FVE','FN87','071531','2023-06-30 16:07:07','062023','CO','37721787','VIVIANA','CALDERON','',' 3007270214','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','18','51998','133','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:07:07','52131','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',52131,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 16:07:07',  1000, 44347, 223, 99),('FVE','FN87','071531','2023-06-30 16:07:07','062023','CO','37721787','VIVIANA','CALDERON','',' 3007270214','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','18','51998','133','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:07:07','52131','87','BOD. FARMANORTE 87','1','18900','18900','18900','0','18900','1','0','0','30','30/06/2023','',52131,0,0,'7703689000448','CYCLOFEM 0.5ML AMP + JERINGA  ','344','PROFAMILIA','2023-06-30 16:07:07',  16550, 40547, 223, 99),('FVE','FN87','071531','2023-06-30 16:07:07','062023','CO','37721787','VIVIANA','CALDERON','',' 3007270214','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','18','51998','133','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:07:07','52131','87','BOD. FARMANORTE 87','14','507','7098','7098','0','7098','0','14','0','','30/06/2023','',52131,0,0,'7702123006817','ASPIRINA 100 MG *140 TAB','631','BAYER OTC','2023-06-30 16:07:07',  56392.75, 46696, 223, 99),('FVE','FN87','071531','2023-06-30 16:07:07','062023','CO','37721787','VIVIANA','CALDERON','',' 3007270214','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','18','51998','133','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:07:07','52131','87','BOD. FARMANORTE 87','1','25200','25200','25200','0','25200','1','0','0','','30/06/2023','',52131,0,0,'7703712080607','GRINOX SUSP *60 ML','387','TRIDEX FARMACEUTICA','2023-06-30 16:07:07',  17970, 57023, 223, 99),('FVE','FN87','071531','2023-06-30 16:07:07','062023','CO','37721787','VIVIANA','CALDERON','',' 3007270214','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','18','51998','133','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:07:07','52131','87','BOD. FARMANORTE 87','1','833','833','700','133','833','1','0','0','','30/06/2023','',52131,0,0,'7707228361793','JERINGA 10ML *21G X1 1/2 HIPODERMICA ALFASAFE ','429','ALFA SAFE','2023-06-30 16:07:07',  369, 46955, 223, 99),('FVE','FN87','071533','2023-06-30 16:07:08','062023','CR','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','346836','2','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:16:10','7000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,0,7000,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 16:07:08',  1000, 44347, 223, 99),('FVE','FN87','071533','2023-06-30 16:07:08','062023','CR','1082945193','NATALIA','ROJAS','CRA 29 L1-03 SANTA ANA',' 3157524993','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','346836','2','7000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:16:10','7000','87','BOD. FARMANORTE 87','1','6900','6900','6900','0','6900','1','0','0','','30/06/2023','',0,0,7000,'7702026177874','NOSOTRAS INVISIBLE RAPIGEL *10 + OBSEQUIO','337','FAMILIA SANCELA','2023-06-30 16:07:08',  5605.2, 50903, 223, 99),('FVE','FN87','071532','2023-06-30 16:08:42','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','1','1000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:08:43','1000','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','30/06/2023','',1000,0,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2023-06-30 16:08:42',  570, 58629, 223, 99),('FVE','FN87','071534','2023-06-30 16:45:48','062023','CO','1014198727','MARCELA','MENDEZ','CARERA 21A1 29E-61','   3196880241','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','6906.72268907563','1293.2773109243694','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:45:48','8200','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',8200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 16:45:48',  1000, 44347, 223, 99),('FVE','FN87','071534','2023-06-30 16:45:48','062023','CO','1014198727','MARCELA','MENDEZ','CARERA 21A1 29E-61','   3196880241','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','6906.72268907563','1293.2773109243694','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:45:48','8200','87','BOD. FARMANORTE 87','2','1800','3600','3025.2100840336','574.78991596639','3600','2','0','0','','30/06/2023','',8200,0,0,'7702402051330','HELADO CASERO COCO *60 GR','296','MEALS DE COLOMBIA','2023-06-30 16:45:48',  1197.56, 50688, 223, 99),('FVE','FN87','071534','2023-06-30 16:45:48','062023','CO','1014198727','MARCELA','MENDEZ','CARERA 21A1 29E-61','   3196880241','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','6906.72268907563','1293.2773109243694','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:45:48','8200','87','BOD. FARMANORTE 87','3','1500','4500','3781.512605042','718.48739495798','4500','3','0','0','','30/06/2023','',8200,0,0,'7702402043359,7','PALETA ALOHA AGUA LIMON X 65 GR','296','MEALS DE COLOMBIA','2023-06-30 16:45:48',  1008, 32692, 223, 99),('FVE','FN87','071535','2023-06-30 16:50:43','062023','CO','42497930','EUNICE ','GIMENEZ','KRA 22 N13-30 CONJUNTO KAREN M',' 3045466896','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','11','35100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:50:43','35100','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,35100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 16:50:43',  1000, 44347, 223, 99),('FVE','FN87','071535','2023-06-30 16:50:43','062023','CO','42497930','EUNICE ','GIMENEZ','KRA 22 N13-30 CONJUNTO KAREN M',' 3045466896','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','11','35100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:50:43','35100','87','BOD. FARMANORTE 87','1','4400','4400','4400','0','4400','1','0','0','','30/06/2023','',0,35100,0,'7706659500146','AGUA OXIGENADA *120 ML','143','COASPHARMA SAS','2023-06-30 16:50:43',  3124.58, 49419, 223, 99),('FVE','FN87','071535','2023-06-30 16:50:43','062023','CO','42497930','EUNICE ','GIMENEZ','KRA 22 N13-30 CONJUNTO KAREN M',' 3045466896','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','11','35100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:50:43','35100','87','BOD. FARMANORTE 87','5','1000','5000','5000','0','5000','5','0','0','','30/06/2023','',0,35100,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2023-06-30 16:50:43',  570, 58629, 223, 99),('FVE','FN87','071535','2023-06-30 16:50:43','062023','CO','42497930','EUNICE ','GIMENEZ','KRA 22 N13-30 CONJUNTO KAREN M',' 3045466896','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','11','35100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:50:43','35100','87','BOD. FARMANORTE 87','1','8200','8200','8200','0','8200','1','0','0','','30/06/2023','',0,35100,0,'7703186816511','PEDIALYTE 30 COCO *500 ML','659','ABBOTT NUTRICION','2023-06-30 16:50:43',  6980, 22269, 223, 99),('FVE','FN87','071535','2023-06-30 16:50:43','062023','CO','42497930','EUNICE ','GIMENEZ','KRA 22 N13-30 CONJUNTO KAREN M',' 3045466896','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','11','35100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:50:43','35100','87','BOD. FARMANORTE 87','1','8200','8200','8200','0','8200','1','0','0','','30/06/2023','',0,35100,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2023-06-30 16:50:43',  6980, 22278, 223, 99),('FVE','FN87','071535','2023-06-30 16:50:43','062023','CO','42497930','EUNICE ','GIMENEZ','KRA 22 N13-30 CONJUNTO KAREN M',' 3045466896','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','11','35100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:50:43','35100','87','BOD. FARMANORTE 87','1','8200','8200','8200','0','8200','1','0','0','','30/06/2023','',0,35100,0,'7501033957369','PEDIALYTE MAX ZINC 60 MANZANA *500 ML','659','ABBOTT NUTRICION','2023-06-30 16:50:43',  6980, 22277, 223, 99),('FVE','FN87','071535','2023-06-30 16:50:43','062023','CO','42497930','EUNICE ','GIMENEZ','KRA 22 N13-30 CONJUNTO KAREN M',' 3045466896','2791','Tania Margarita ','Cortes peña','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','11','35100','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:50:43','35100','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','30/06/2023','',0,35100,0,'DO','DOMICILIO','00','VARIOS','2023-06-30 16:50:43',  500, 44348, 223, 99),('FVE','FN87','071536','2023-06-30 16:58:52','062023','CO','1082917714','ROSA','CERVANTE','cr 21a4n 29f3-39 villa bella ','  3016436997','932','ALVARO ENRIQUE','THOMAS LOPEZ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','9','20259.663865546216','3640.336134453781','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:58:52','23899.999999999996','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',0,23900,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 16:58:52',  1000, 44347, 223, 99),('FVE','FN87','071536','2023-06-30 16:58:52','062023','CO','1082917714','ROSA','CERVANTE','cr 21a4n 29f3-39 villa bella ','  3016436997','932','ALVARO ENRIQUE','THOMAS LOPEZ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','9','20259.663865546216','3640.336134453781','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:58:52','23899.999999999996','87','BOD. FARMANORTE 87','3','2100','6300','5294.1176470588','1005.8823529412','6300','3','0','0','','30/06/2023','',0,23900,0,'7702617022132','NECTAR MANZANA CALIFORNIA *200 ML','823','GLORIA COLOMBIA SA','2023-06-30 16:58:52',  1400, 36455, 223, 99),('FVE','FN87','071536','2023-06-30 16:58:52','062023','CO','1082917714','ROSA','CERVANTE','cr 21a4n 29f3-39 villa bella ','  3016436997','932','ALVARO ENRIQUE','THOMAS LOPEZ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','9','20259.663865546216','3640.336134453781','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:58:52','23899.999999999996','87','BOD. FARMANORTE 87','1','1000','1000','1000','0','1000','1','0','0','','30/06/2023','',0,23900,0,'DO','DOMICILIO','00','VARIOS','2023-06-30 16:58:52',  500, 44348, 223, 99),('FVE','FN87','071536','2023-06-30 16:58:52','062023','CO','1082917714','ROSA','CERVANTE','cr 21a4n 29f3-39 villa bella ','  3016436997','932','ALVARO ENRIQUE','THOMAS LOPEZ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','9','20259.663865546216','3640.336134453781','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:58:52','23899.999999999996','87','BOD. FARMANORTE 87','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/06/2023','',0,23900,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2023-06-30 16:58:52',  1661.1, 56307, 223, 99),('FVE','FN87','071536','2023-06-30 16:58:52','062023','CO','1082917714','ROSA','CERVANTE','cr 21a4n 29f3-39 villa bella ','  3016436997','932','ALVARO ENRIQUE','THOMAS LOPEZ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','9','20259.663865546216','3640.336134453781','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:58:52','23899.999999999996','87','BOD. FARMANORTE 87','2','1500','3000','2521.0084033613','478.99159663866','3000','2','0','0','','30/06/2023','',0,23900,0,'7702402043359,7','PALETA ALOHA AGUA LIMON X 65 GR','296','MEALS DE COLOMBIA','2023-06-30 16:58:52',  1008, 32692, 223, 99),('FVE','FN87','071536','2023-06-30 16:58:52','062023','CO','1082917714','ROSA','CERVANTE','cr 21a4n 29f3-39 villa bella ','  3016436997','932','ALVARO ENRIQUE','THOMAS LOPEZ','2589','ALEXANDER YOEL ','BRITO ALVAREZ','','','','','','9','20259.663865546216','3640.336134453781','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 16:58:52','23899.999999999996','87','BOD. FARMANORTE 87','1','11000','11000','9243.6974789916','1756.3025210084','11000','1','0','0','','30/06/2023','',0,23900,0,'7702277305170','TOALLITAS ARRURRU AVENA Y KARITE X 100 UND ','124','BELLEZA EXPRESS SA','2023-06-30 16:58:52',  7711.2008, 55332, 223, 99),('FVE','FN87','071537','2023-06-30 17:18:52','062023','CO','37293676','LUISA','ARIAS','',' 0 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','7320.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:18:52','7400','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','1','0','','30/06/2023','',7400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 17:18:52',  1000, 44347, 223, 99),('FVE','FN87','071537','2023-06-30 17:18:52','062023','CO','37293676','LUISA','ARIAS','',' 0 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','7320.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:18:52','7400','87','BOD. FARMANORTE 87','1','3000','3000','3000','0','3000','0','1','0','','30/06/2023','',7400,0,0,'7707236127589','DICLOFENACO 75MG *10 AMP','701','VITALIS COMERCIAL','2023-06-30 17:18:52',  9400, 44220, 223, 99),('FVE','FN87','071537','2023-06-30 17:18:52','062023','CO','37293676','LUISA','ARIAS','',' 0 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','7320.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:18:52','7400','87','BOD. FARMANORTE 87','1','3800','3800','3800','0','3800','0','1','0','','30/06/2023','',7400,0,0,'7702896001231','DEXABLAS  8 MG X 5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2023-06-30 17:18:52',  18762.091, 23704, 223, 99),('FVE','FN87','071537','2023-06-30 17:18:52','062023','CO','37293676','LUISA','ARIAS','',' 0 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','4','7320.16806722689','79.8319327731092','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:18:52','7400','87','BOD. FARMANORTE 87','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','30/06/2023','',7400,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2023-06-30 17:18:52',  255, 46100, 223, 99),('FVE','FN87','071538','2023-06-30 17:22:04','062023','CO','1007934000','SINDY','GOMEZ','',' 3161580913','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','6600','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:22:04','6600','87','BOD. FARMANORTE 87','1','6600','6600','6600','0','6600','1','0','0','25','30/06/2023','',6600,0,0,'7896116860972','MICROGYNON X 21 GRAG ','380','TECNOFARMA','2023-06-30 17:22:04',  5647, 40564, 223, 99),('FVE','FN87','071539','2023-06-30 17:22:40','062023','CO','85477345','DAVID','PEREZ','',' BNO DIO','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','22000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:22:41','22000','87','BOD. FARMANORTE 87','1','100','100','100','0','100','1','0','0','','30/06/2023','',22000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2023-06-30 17:22:40',  1000, 44347, 223, 99),('FVE','FN87','071539','2023-06-30 17:22:40','062023','CO','85477345','DAVID','PEREZ','',' BNO DIO','2791','Tania Margarita ','Cortes peña','','TERCERO','VARIOS','','','','','','2','22000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:22:41','22000','87','BOD. FARMANORTE 87','1','21900','21900','21900','0','21900','1','0','0','','30/06/2023','',22000,0,0,'7707263005188','ACED FULL MENTA *360 ML','387','TRIDEX FARMACEUTICA','2023-06-30 17:22:40',  10495, 59332, 223, 99),('FVE','FN87','071540','2023-06-30 17:33:52','062023','CO','85464282','ALVARO ENRIQUE','THOMAS LOPEZ','MANZANA 9A CASA 1 FILADELFIA','  3233880552','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','6000','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 17:33:53','6000','87','BOD. FARMANORTE 87','1','6000','6000','6000','0','6000','1','0','0','','30/06/2023','',6000,0,0,'7707236127688','GENTAMICINA 160MG/2ML *1 AMP','701','VITALIS COMERCIAL','2023-06-30 17:33:52',  3200, 54109, 223, 99),('FVE','FN87','071541','2023-06-30 18:22:48','062023','CO','57435540','CLARA','CHARRIS','LA LUCHA CERRO',' 3003156850','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','16300','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 18:22:48','16300','87','BOD. FARMANORTE 87','1','16300','16300','16300','0','16300','1','0','0','','30/06/2023','',16300,0,0,'7702870003589','POSTDAY *1 TAB ','696','ABBOTT FARMA CONVENIO','2023-06-30 18:22:48',  11094, 31697, 223, 99),('FVE','FN87','071542','2023-06-30 18:37:00','062023','CO','91213292','JOSE','BONILLA','',' 00','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','6','8034','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 18:37:00','8034','87','BOD. FARMANORTE 87','6','1339','8034','8034','0','8034','0','6','0','','30/06/2023','',8034,0,0,'7707019340907','METROXAZIDE 600/200MG *18 TAB','130','LABQUIFAR PHARMACEUTICA','2023-06-30 18:37:00',  12300, 23587, 223, 99),('FVE','FN87','071543','2023-06-30 18:38:38','062023','CO','26976942','MAIRA MILENA ','TONCEL SIERRA','MZ9A CASA12 FILADELFIA',' 3046634583 ','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','16900','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 18:38:39','16900','87','BOD. FARMANORTE 87','1','16900','16900','16900','0','16900','1','0','0','','30/06/2023','',16900,0,0,'7702057710163','LOSARTAN 50 MG *30 TAB','654','MK ETICOS CONVENIO','2023-06-30 18:38:38',  14176, 53327, 223, 99),('FVE','FN87','071544','2023-06-30 18:43:31','062023','CO','12562988','CARLOS A','NU NTILDE EZ','MANZANA 99 CASA 18 CIUDADELA',' 3205280453 3203404752','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','2857.1428571428573','542.8571428571427','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 18:43:31','3400','87','BOD. FARMANORTE 87','1','3400','3400','2857.1428571429','542.85714285714','3400','1','0','0','','30/06/2023','',3400,0,0,'7702189054166','DETODITO MEGA BBQ *65 GR','762','FRITO LAY','2023-06-30 18:43:31',  2318, 54668, 223, 99),('FVE','FN87','071545','2023-06-30 18:55:49','062023','CO','99','CLIENTE',' PUNTO DE VENTA','NO DIO','#####99 #####99 #####99 #####99 #','932','ALVARO ENRIQUE','THOMAS LOPEZ','','TERCERO','VARIOS','','','','','','1','6700','0','87','FARMANORTE 87','ADMINISTRADOR','2023-06-30 18:55:50','6700','87','BOD. FARMANORTE 87','1','6700','6700','6700','0','6700','0','1','0','','30/06/2023','',6700,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2023-06-30 18:55:49',  57323.8, 41855, 223, 99);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '062023' AND DECODBOD='87';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '062023' AND DECODBOD='87';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '062023' AND DECODBOD='87';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '062023' AND DECODBOD='87';
