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','FTCL','000618','2024-05-29 21:11:02','052024','CO','32611596','ESTELLA','THOMAS','',' 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','2000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:11:02','2000','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-29 21:11:02',  800, 48019, 738, 368),('FVE','FTCL','000619','2024-05-29 21:23:49','052024','CO','1042242883','KERILIN','PANTOJA','',' 0','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','15400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:23:49','15400','347','BOD. FARMANORTE 347','1','15400','15400','15400','0','15400','1','0','0','','30/05/2024','',15400,0,0,'7707019401950','FIREXIFEN JARABE *120 ML','130','LABQUIFAR PHARMACEUTICA','2024-05-29 21:23:49',  7700, 45885, 738, 368),('FVE','FTCL','000620','2024-05-29 21:33:31','052024','CO','72052637','PALLARDO','MARCHENA','00000',' 3156566325','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','154900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:33:31','154900','347','BOD. FARMANORTE 347','1','139100','139100','139100','0','139100','1','0','775','5','30/05/2024','',154900,0,0,'7506205811340','ENFAMIL PREMIUM 1 PROMENTAL *800 GR','295','MEAD JOHNSON NUTRITION COLOMBIA','2024-05-29 21:33:31',  129334, 33603, 738, 368),('FVE','FTCL','000620','2024-05-29 21:33:31','052024','CO','72052637','PALLARDO','MARCHENA','00000',' 3156566325','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','154900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:33:31','154900','347','BOD. FARMANORTE 347','10','300','3000','3000','0','3000','0','10','775','','30/05/2024','',154900,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-29 21:33:31',  28997, 54625, 738, 368),('FVE','FTCL','000620','2024-05-29 21:33:31','052024','CO','72052637','PALLARDO','MARCHENA','00000',' 3156566325','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','154900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:33:31','154900','347','BOD. FARMANORTE 347','1','10100','10100','10100','0','10100','1','0','775','','30/05/2024','',154900,0,0,'7703186028938','PEDIASURE LIQUIDO VAINILLA *220 ML','659','ABBOTT NUTRICION','2024-05-29 21:33:31',  9020, 22283, 738, 368),('FVE','FTCL','000620','2024-05-29 21:33:31','052024','CO','72052637','PALLARDO','MARCHENA','00000',' 3156566325','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','154900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:33:31','154900','347','BOD. FARMANORTE 347','1','2700','2700','2700','0','2700','0','1','775','','30/05/2024','',154900,0,0,'7702057840310','SAL DE FRUTAS LUA *50 SOBRES','382','TECNOQUIMICAS','2024-05-29 21:33:31',  105944.66, 43290, 738, 368),('FVE','FTCL','000621','2024-05-29 21:50:13','052024','CO','1001822480','KENDRY','DE AGUAS','',' 00000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','1001313741','1048268367','CAMARGO JIMENEZ JERRI ANDERSON','','','3','10920.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:50:13','11000','347','BOD. FARMANORTE 347','1','4100','4100','4100','0','4100','0','1','0','','30/05/2024','',11000,0,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-29 21:50:13',  7000, 23704, 738, 368),('FVE','FTCL','000621','2024-05-29 21:50:13','052024','CO','1001822480','KENDRY','DE AGUAS','',' 00000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','1001313741','1048268367','CAMARGO JIMENEZ JERRI ANDERSON','','','3','10920.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:50:13','11000','347','BOD. FARMANORTE 347','1','6400','6400','6400','0','6400','0','1','0','','30/05/2024','',11000,0,0,'7709990733716','NORIFLAM 75MG/3ML CJA * 6 AMP','698','MED-LINE CONVENIO','2024-05-29 21:50:13',  13050, 48643, 738, 368),('FVE','FTCL','000621','2024-05-29 21:50:13','052024','CO','1001822480','KENDRY','DE AGUAS','',' 00000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','1001313741','1048268367','CAMARGO JIMENEZ JERRI ANDERSON','','','3','10920.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:50:13','11000','347','BOD. FARMANORTE 347','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','30/05/2024','',11000,0,0,'7707282990274','JERINGA 5ML DESECHABLE  21GX1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-29 21:50:13',  168.46, 58667, 738, 368),('FVE','FTCL','000622','2024-05-29 21:57:44','052024','CO','1048321058','EMANUEL','QUINTERO','',' 0 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','1512.6050420168067','287.3949579831933','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:57:45','1800','347','BOD. FARMANORTE 347','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/05/2024','',1800,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2024-05-29 21:57:44',  1190.721, 58852, 738, 368),('FVE','FTCL','000623','2024-05-29 21:59:57','052024','CO','1048277539','JEAN CARLOS','LABORNE','',' 3134569821','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','8099.1596638655465','1500.8403361344535','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:59:58','9600','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','30/05/2024','',9600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-29 21:59:57',  100, 44347, 738, 368),('FVE','FTCL','000623','2024-05-29 21:59:57','052024','CO','1048277539','JEAN CARLOS','LABORNE','',' 3134569821','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','8099.1596638655465','1500.8403361344535','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:59:58','9600','347','BOD. FARMANORTE 347','1','4700','4700','3949.5798319328','750.42016806723','4700','1','0','0','','30/05/2024','',9600,0,0,'7705890021076','HELADO GOURMET POPSY TROZOS MILKY WAY *60 GR','886','POPSY','2024-05-29 21:59:57',  3222, 59217, 738, 368),('FVE','FTCL','000623','2024-05-29 21:59:57','052024','CO','1048277539','JEAN CARLOS','LABORNE','',' 3134569821','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','8099.1596638655465','1500.8403361344535','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 21:59:58','9600','347','BOD. FARMANORTE 347','1','4700','4700','3949.5798319328','750.42016806723','4700','1','0','0','','30/05/2024','',9600,0,0,'7705890011190','HELADO CREMOSO GOURMET POPSY CHOCOLATE *60 GR','886','POPSY','2024-05-29 21:59:57',  2890, 59215, 738, 368),('FVE','FTCL','000624','2024-05-29 22:03:51','052024','CO','1048275858','JHONATAN ','ARIZA','',' 000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','11','8500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:03:52','8500','347','BOD. FARMANORTE 347','1','5500','5500','5500','0','5500','0','1','0','','30/05/2024','',0,8500,0,'7500435107020','VICK VAPORUB 12 GR *12 LATAS','820','PROCTER & GAMBLE CHC','2024-05-29 22:03:51',  56858, 40253, 738, 368),('FVE','FTCL','000624','2024-05-29 22:03:51','052024','CO','1048275858','JHONATAN ','ARIZA','',' 000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','11','8500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:03:52','8500','347','BOD. FARMANORTE 347','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',0,8500,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-29 22:03:51',  28997, 54625, 738, 368),('FVE','FTCL','000625','2024-05-29 22:12:09','052024','CO','1050724715','ELIZABETH','GARCIA','0',' 3004648865 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','2000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:12:09','2000','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-29 22:12:09',  800, 48019, 738, 368),('FVE','FTCL','000626','2024-05-29 22:14:56','052024','CO','1001824039','DANIEL ','ACEVEDO','',' 00000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:14:56','4600','347','BOD. FARMANORTE 347','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','30/05/2024','',4600,0,0,'7702090038064','JUGO HIT MORA *1 LT','192','POSTOBON GASEOSAS','2024-05-29 22:14:56',  2850.38, 53814, 738, 368),('FVE','FTCL','000627','2024-05-29 22:17:30','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','1512.6050420168067','287.3949579831933','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:17:30','1800','347','BOD. FARMANORTE 347','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/05/2024','',1800,0,0,'7702189056832','CHEETOS BOLIQUESO *38 GR','762','FRITO LAY','2024-05-29 22:17:30',  1159, 58744, 738, 368),('FVE','FTCL','000628','2024-05-29 22:17:58','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','4957.983193277311','942.0168067226887','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:17:58','5900','347','BOD. FARMANORTE 347','1','5900','5900','4957.9831932773','942.01680672269','5900','1','0','0','','30/05/2024','',5900,0,0,'7702090064186','GASEOSA MANZANA *2.5 LT','192','POSTOBON GASEOSAS','2024-05-29 22:17:58',  3503.36, 56646, 738, 368),('FVE','FTCL','000629','2024-05-29 22:30:36','052024','CO','5049655','EDER','ARAGON','',' 000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','5000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:30:36','5000','347','BOD. FARMANORTE 347','2','2500','5000','5000','0','5000','0','2','0','','30/05/2024','',5000,0,0,'7703381003365','MACRODANTINA 100 MG *40 CAP ','134','BOEHRINGER INGELHEIM FARMA','2024-05-29 22:30:36',  66600, 23844, 738, 368),('FVE','FTCL','000630','2024-05-29 22:39:51','052024','CO','72269870','BREINER','RODRIGUEZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','5','7988.605042016807','287.3949579831933','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:39:52','8276','347','BOD. FARMANORTE 347','4','1619','6476','6476','0','6476','0','4','0','','30/05/2024','',8276,0,0,'7702626214849','STREPSILS INTENSIVE MIEL-LIMON *16 TAB','357','RECKITT BENCKISER COLOMBIA S A','2024-05-29 22:39:51',  20656, 53074, 738, 368),('FVE','FTCL','000630','2024-05-29 22:39:51','052024','CO','72269870','BREINER','RODRIGUEZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','5','7988.605042016807','287.3949579831933','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:39:52','8276','347','BOD. FARMANORTE 347','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','30/05/2024','',8276,0,0,'7702189057877','CHEETOS HORNEADOS MAXI *40 GR','762','FRITO LAY','2024-05-29 22:39:51',  1159, 60825, 738, 368),('FVE','FTCL','000631','2024-05-29 22:41:13','052024','CO','32583919','YORINIS','ANAYA SERJE','00000',' 3007667858 3007667858','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','4600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:41:13','4600','347','BOD. FARMANORTE 347','2','2300','4600','4600','0','4600','0','2','0','','30/05/2024','',4600,0,0,'7702057092757','IBUFLASH MIGRAN *30 CAP','382','TECNOQUIMICAS','2024-05-29 22:41:13',  50677.65, 58898, 738, 368),('FVE','FTCL','000632','2024-05-29 22:42:36','052024','CO','1048267451','EMMANUEL','VILLALOBO','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','10','3000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:42:36','3000','347','BOD. FARMANORTE 347','10','300','3000','3000','0','3000','0','10','0','','30/05/2024','',3000,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-29 22:42:36',  28997, 54625, 738, 368),('FVE','FTCL','000633','2024-05-29 22:55:24','052024','CO','1002237120','YAMINALE','BAJAIRE','',' 00000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','3529.4117647058824','670.5882352941176','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:55:24','4200','347','BOD. FARMANORTE 347','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','30/05/2024','',4200,0,0,'7702090069235','HIT NECTAR MANZANA VNR *237 ML','192','POSTOBON GASEOSAS','2024-05-29 22:55:24',  1281.5, 60808, 738, 368),('FVE','FTCL','000633','2024-05-29 22:55:24','052024','CO','1002237120','YAMINALE','BAJAIRE','',' 00000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','3529.4117647058824','670.5882352941176','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:55:24','4200','347','BOD. FARMANORTE 347','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','30/05/2024','',4200,0,0,'7702090069242','HIT NECTAR PERA VNR *237 ML','192','POSTOBON GASEOSAS','2024-05-29 22:55:24',  1281.5, 60809, 738, 368),('FVE','FTCL','000634','2024-05-29 22:59:11','052024','CO','1048267670','CESAR','BARRIOS',' calle 10 #6-85  san jorge ',' 1 3218270040','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','4400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 22:59:12','4400','347','BOD. FARMANORTE 347','4','1100','4400','4400','0','4400','0','4','0','','30/05/2024','',4400,0,0,'7707355055626','NOXPIRIN PLUS *120 CAP','626','SIEGFRIED CONSUMO','2024-05-29 22:59:11',  102526, 55782, 738, 368),('FVE','FTCL','000635','2024-05-29 23:00:01','052024','CO','1048267670','CESAR','BARRIOS',' calle 10 #6-85  san jorge ',' 1 3218270040','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','8900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 23:00:01','8900','347','BOD. FARMANORTE 347','1','8900','8900','8900','0','8900','1','0','0','','30/05/2024','',8900,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-29 23:00:01',  6610, 54196, 738, 368),('FVE','FTCL','000636','2024-05-29 23:08:45','052024','CO','1048275422','KATHERINE','DEL VALLE','',' .000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','10','4000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 23:08:45','4000','347','BOD. FARMANORTE 347','10','400','4000','4000','0','4000','0','10','0','','30/05/2024','',4000,0,0,'7705959012397','ACIDO ACETILSALICILICO 100 MG * 100 TAB','193','GENFAR','2024-05-29 23:08:45',  21619.05, 25879, 738, 368),('FVE','FTCL','000637','2024-05-29 23:34:41','052024','CO','1048328349','CARLOS ','CERVANTES','',' 1 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 23:34:41','3100','347','BOD. FARMANORTE 347','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','0','','30/05/2024','',3100,0,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2024-05-29 23:34:41',  1956.4, 34397, 738, 368),('FVE','FTCL','000638','2024-05-29 23:40:32','052024','CO','72044523','JHONYS ','PEREZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','8800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 23:40:32','8800','347','BOD. FARMANORTE 347','1','2500','2500','2500','0','2500','0','1','0','','30/05/2024','',8800,0,0,'7709080992504','LYPTUS MIEL MENTOL CJA * 24 SOBRES','1000','NATURALMENTE','2024-05-29 23:40:32',  17000, 63438, 738, 368),('FVE','FTCL','000638','2024-05-29 23:40:32','052024','CO','72044523','JHONYS ','PEREZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','8800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-29 23:40:32','8800','347','BOD. FARMANORTE 347','1','6300','6300','6300','0','6300','1','0','0','','30/05/2024','',8800,0,0,'7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2024-05-29 23:40:32',  4500, 48626, 738, 368),('FVE','FTCL','000639','2024-05-30 00:06:00','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','840.3361344537816','159.6638655462184','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 00:06:00','1000','347','BOD. FARMANORTE 347','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','30/05/2024','',1000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-30 00:06:00',  9360, 46328, 738, 368),('FVE','FTCL','000640','2024-05-30 00:12:21','052024','CO','1002234498','JUAN','CASALLA','',' 0 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 00:12:21','4600','347','BOD. FARMANORTE 347','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','30/05/2024','',4600,0,0,'7702090038095','JUGO HIT FRUTAS TROPICALES *1 LT','192','POSTOBON GASEOSAS','2024-05-30 00:12:21',  2850.42, 54008, 738, 368),('FVE','FTCL','000641','2024-05-30 00:17:09','052024','CO','1046703803','ARIANA','VALENCIA','',' 3185117548','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','5900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 00:17:10','5900','347','BOD. FARMANORTE 347','1','1000','1000','1000','0','1000','1','0','0','','30/05/2024','',0,5900,0,'7707228361489','GASA ESTERIL NO TEJIDA 3X3 (7.5X7.5) *6 UNIDADES','429','ALFA SAFE','2024-05-30 00:17:09',  570, 58629, 738, 368),('FVE','FTCL','000641','2024-05-30 00:17:09','052024','CO','1046703803','ARIANA','VALENCIA','',' 3185117548','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','5900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 00:17:10','5900','347','BOD. FARMANORTE 347','1','4900','4900','4900','0','4900','1','0','0','','30/05/2024','',0,5900,0,'7707228362141','CINTA MICROPOROSA PIEL ALFASAFE 1 X 3 YD','429','ALFA SAFE','2024-05-30 00:17:09',  3036, 60552, 738, 368),('FVE','FTCL','000642','2024-05-30 00:19:27','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','4000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 00:19:27','4000','347','BOD. FARMANORTE 347','2','2000','4000','4000','0','4000','2','0','0','','30/05/2024','',4000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 00:19:27',  800, 48019, 738, 368),('FVE','FTCL','000643','2024-05-30 00:41:19','052024','CO','1192770266','MOLINO CAMARGO','ELIECER','calle 7B # 1J -47 SAN ANTONIO ',' 0 3137912776','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','10924.36974789916','2075.63025210084','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 00:41:20','13000','347','BOD. FARMANORTE 347','1','13000','13000','10924.369747899','2075.6302521008','13000','1','0','55','','30/05/2024','',13000,0,0,'7707263004259','CREMA DERMOPROTECTORA OCHO * 20GR','387','TRIDEX FARMACEUTICA','2024-05-30 00:41:19',  6468, 62401, 738, 368),('FVE','FTCL','000644','2024-05-30 00:45:29','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','5378.151260504202','1021.8487394957983','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 00:45:29','6400','347','BOD. FARMANORTE 347','2','3200','6400','5378.1512605042','1021.8487394958','6400','2','0','0','','30/05/2024','',6400,0,0,'7702004004932','CERVEZA COSTEÑA BACANA LATA *330 ML','119','BAVARIA S.A.','2024-05-30 00:45:29',  2028, 59067, 738, 368),('FVE','FTCL','000645','2024-05-30 01:00:42','052024','CO','72050863','JORGE ','ACOSTA URQUIJO','',' 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','5294.117647058823','1005.8823529411766','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 01:00:42','6300','347','BOD. FARMANORTE 347','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','30/05/2024','',6300,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-30 01:00:42',  3881.5, 56142, 738, 368);
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','FTCL','000646','2024-05-30 01:10:04','052024','CO','1002234522','DANIEL ','SANCHEZ','calle 11f cr 1c-108 apto 2 el ',' 0 3244737619','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','7731.092436974791','1468.9075630252094','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 01:10:04','9200','347','BOD. FARMANORTE 347','1','1300','1300','1092.4369747899','207.56302521008','1300','1','0','0','','30/05/2024','',0,9200,0,'7622201717575','GALLETA CLUB SOCIAL ORIGINAL *24 GR','754','DISCOB NORTE SAS','2024-05-30 01:10:04',  560.2, 62038, 738, 368),('FVE','FTCL','000647','2024-05-30 02:49:45','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','5000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 02:49:46','5000','347','BOD. FARMANORTE 347','1','5000','5000','5000','0','5000','1','0','0','','30/05/2024','',5000,0,0,'7706569001627','ACETAMINOFEN JBE *60 ML','614','A.G. MEDICAMENTOS','2024-05-30 02:49:45',  3709, 31154, 738, 368),('FVE','FTCL','000648','2024-05-30 02:50:53','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','1764.7058823529412','335.2941176470588','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 02:50:53','2100','347','BOD. FARMANORTE 347','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','30/05/2024','',2100,0,0,'7702090069242','HIT NECTAR PERA VNR *237 ML','192','POSTOBON GASEOSAS','2024-05-30 02:50:53',  1281.5, 60809, 738, 368),('FVE','FTCL','000649','2024-05-30 02:53:28','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','5500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 02:53:28','5500','347','BOD. FARMANORTE 347','1','5500','5500','5500','0','5500','0','1','0','','30/05/2024','',5500,0,0,'7500435107020','VICK VAPORUB 12 GR *12 LATAS','820','PROCTER & GAMBLE CHC','2024-05-30 02:53:28',  56858, 40253, 738, 368),('FVE','FTCL','000650','2024-05-30 05:49:35','052024','CO','1048270191','GUSTAVO ','GUTIERREZ HARPON','CRA 16 #12-29',' 3022407591','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','10336.134453781513','1963.865546218487','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 05:49:36','12300','347','BOD. FARMANORTE 347','2','1500','3000','2521.0084033613','478.99159663866','3000','2','0','52','','30/05/2024','',12300,0,0,'77082381','COCA COLA ZERO *250 ML','144','COCA COLA','2024-05-30 05:49:35',  1031.1666, 34412, 738, 368),('FVE','FTCL','000650','2024-05-30 05:49:35','052024','CO','1048270191','GUSTAVO ','GUTIERREZ HARPON','CRA 16 #12-29',' 3022407591','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','10336.134453781513','1963.865546218487','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 05:49:36','12300','347','BOD. FARMANORTE 347','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','52','','30/05/2024','',12300,0,0,'7702402055789','HELADO KIDS LLUVIA DE COLORES *55 GR','296','MEALS DE COLOMBIA','2024-05-30 05:49:35',  1190.721, 58852, 738, 368),('FVE','FTCL','000650','2024-05-30 05:49:35','052024','CO','1048270191','GUSTAVO ','GUTIERREZ HARPON','CRA 16 #12-29',' 3022407591','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','10336.134453781513','1963.865546218487','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 05:49:36','12300','347','BOD. FARMANORTE 347','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','52','','30/05/2024','',12300,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-05-30 05:49:35',  1050.4, 47478, 738, 368),('FVE','FTCL','000650','2024-05-30 05:49:35','052024','CO','1048270191','GUSTAVO ','GUTIERREZ HARPON','CRA 16 #12-29',' 3022407591','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','10336.134453781513','1963.865546218487','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 05:49:36','12300','347','BOD. FARMANORTE 347','1','3200','3200','2689.0756302521','510.9243697479','3200','1','0','52','','30/05/2024','',12300,0,0,'7702402054416','CHOCOCONO *90 GR','296','MEALS DE COLOMBIA','2024-05-30 05:49:35',  1806, 56307, 738, 368),('FVE','FTCL','000650','2024-05-30 05:49:35','052024','CO','1048270191','GUSTAVO ','GUTIERREZ HARPON','CRA 16 #12-29',' 3022407591','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','10336.134453781513','1963.865546218487','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 05:49:36','12300','347','BOD. FARMANORTE 347','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','52','','30/05/2024','',12300,0,0,'7702024034186','COCOSETTE MAXI WAFER * 46 GR','776','NESTLE FOOD & BEVERAGE','2024-05-30 05:49:35',  1091, 38319, 738, 368),('FVE','FTCL','000651','2024-05-30 06:01:17','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 06:01:17','500','347','BOD. FARMANORTE 347','1','500','500','420.16806722689','79.831932773109','500','0','1','0','','30/05/2024','',500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-30 06:01:17',  9360, 46328, 738, 368),('FVE','FTCL','000652','2024-05-30 06:17:37','052024','CO','32611546','JASIBIS ','HENAO ','cr 13 n 11-22','0 0 3003791618','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','45000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 06:17:38','45000','347','BOD. FARMANORTE 347','1','45000','45000','45000','0','45000','1','0','225','','30/05/2024','',45000,0,0,'7708152336741','SUREZINC TRANSFER KIDS VAINILLA * 400 GR ','1007','SUREZINC','2024-05-30 06:17:37',  16881, 61904, 738, 368),('FVE','FTCL','000653','2024-05-30 06:37:18','052024','CO','1002234759','YEIRINA ','MIRANDA','',' 000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','1001313741','1048268367','CAMARGO JIMENEZ JERRI ANDERSON','','','3','10920.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 06:37:19','11000','347','BOD. FARMANORTE 347','1','4100','4100','4100','0','4100','0','1','0','','30/05/2024','',0,11000,0,'7702896001231','DEXABLAS 8 MG *5 AMP (DEXAMETASONA) BLASKOV','132','BLASKOV','2024-05-30 06:37:18',  7000, 23704, 738, 368),('FVE','FTCL','000653','2024-05-30 06:37:18','052024','CO','1002234759','YEIRINA ','MIRANDA','',' 000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','1001313741','1048268367','CAMARGO JIMENEZ JERRI ANDERSON','','','3','10920.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 06:37:19','11000','347','BOD. FARMANORTE 347','1','6400','6400','6400','0','6400','0','1','0','','30/05/2024','',0,11000,0,'7709990733716','NORIFLAM 75MG/3ML CJA * 6 AMP','698','MED-LINE CONVENIO','2024-05-30 06:37:18',  13050, 48643, 738, 368),('FVE','FTCL','000653','2024-05-30 06:37:18','052024','CO','1002234759','YEIRINA ','MIRANDA','',' 000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','1001313741','1048268367','CAMARGO JIMENEZ JERRI ANDERSON','','','3','10920.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 06:37:19','11000','347','BOD. FARMANORTE 347','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','30/05/2024','',0,11000,0,'7707282990274','JERINGA 5ML DESECHABLE  21GX1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 06:37:18',  168.46, 58667, 738, 368),('FVE','FTCL','000654','2024-05-30 06:49:33','052024','CO','1006889370','JHON JAIME','POLO','',' 0000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','5000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 06:49:33','5000','347','BOD. FARMANORTE 347','2','2500','5000','5000','0','5000','0','2','0','','30/05/2024','',5000,0,0,'7703712080270','OXIFAR 20 MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 06:49:33',  11800, 53835, 738, 368),('FVE','FTCL','000655','2024-05-30 07:22:24','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','672.2689075630252','127.73109243697479','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 07:22:24','800','347','BOD. FARMANORTE 347','1','800','800','672.26890756303','127.73109243697','800','1','0','0','','30/05/2024','',800,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-05-30 07:22:24',  228.3, 39236, 738, 368),('FVE','FTCL','000656','2024-05-30 07:36:41','052024','CO','1003405395',' JUAN ',' CAMILO ','',' 0000','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','9900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 07:36:41','9900','347','BOD. FARMANORTE 347','1','9900','9900','9900','0','9900','1','0','0','','30/05/2024','',9900,0,0,'4005800254963','DUO LUBRICADO *3 PRESERVATIVOS','123','BDF (BEIERSDORF) ','2024-05-30 07:36:41',  9427.1, 23315, 738, 368),('FVE','FTCL','000657','2024-05-30 07:39:04','052024','CO','32710191','MARIA','MARGARITA','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','4','4400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 07:39:04','4400','347','BOD. FARMANORTE 347','4','1100','4400','4400','0','4400','0','4','0','','30/05/2024','',4400,0,0,'7707355055626','NOXPIRIN PLUS *120 CAP','626','SIEGFRIED CONSUMO','2024-05-30 07:39:04',  102526, 55782, 738, 368),('FVE','FTCL','000658','2024-05-30 07:42:09','052024','CO','1048280588','JENIFER',' VALENCIA ','',' 0000','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','560673','32743251','MEDINA ALANDETE SANDRA LUCIA','','','17','15100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 07:42:09','15100','347','BOD. FARMANORTE 347','15','700','10500','10500','0','10500','0','15','0','','30/05/2024','',15100,0,0,'7706569000026','AMOXICILINA 500MG *50 CAP','614','A.G. MEDICAMENTOS','2024-05-30 07:42:09',  21949, 31190, 738, 368),('FVE','FTCL','000658','2024-05-30 07:42:09','052024','CO','1048280588','JENIFER',' VALENCIA ','',' 0000','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','560673','32743251','MEDINA ALANDETE SANDRA LUCIA','','','17','15100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 07:42:09','15100','347','BOD. FARMANORTE 347','2','2300','4600','4600','0','4600','0','2','0','','30/05/2024','',15100,0,0,'7702123006947','APRONAX 275 MG *50 CAP','631','BAYER OTC','2024-05-30 07:42:09',  93020, 22870, 738, 368),('FVE','FTCL','000659','2024-05-30 08:31:12','052024','CO','1048295964','DANIELA','ARAUJO','Calle11b1f06 Bellavista','  3243256102','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','','3','31600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 08:31:12','31600','347','BOD. FARMANORTE 347','1','14200','14200','14200','0','14200','1','0','158','','30/05/2024','',0,31600,0,'7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA *60 ML','616','HALEON (GLAXO OTC)','2024-05-30 08:31:12',  12808.3, 54127, 738, 368),('FVE','FTCL','000659','2024-05-30 08:31:12','052024','CO','1048295964','DANIELA','ARAUJO','Calle11b1f06 Bellavista','  3243256102','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','','3','31600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 08:31:12','31600','347','BOD. FARMANORTE 347','1','15400','15400','15400','0','15400','1','0','158','','30/05/2024','',0,31600,0,'7707019401950','FIREXIFEN JARABE *120 ML','130','LABQUIFAR PHARMACEUTICA','2024-05-30 08:31:12',  7700, 45885, 738, 368),('FVE','FTCL','000659','2024-05-30 08:31:12','052024','CO','1048295964','DANIELA','ARAUJO','Calle11b1f06 Bellavista','  3243256102','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','','3','31600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 08:31:12','31600','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','158','','30/05/2024','',0,31600,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 08:31:12',  1500, 44348, 738, 368),('FVE','FTCL','000660','2024-05-30 08:35:49','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','2','3800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 08:35:49','3800','347','BOD. FARMANORTE 347','2','1900','3800','3800','0','3800','0','2','0','','30/05/2024','',3800,0,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-30 08:35:49',  131275.53, 43180, 738, 368),('FVE','FTCL','000661','2024-05-30 09:32:54','052024','CO','72052118','CARLOS','DE ALBA','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','1163248','1129567367','DE LA CRUZ LOPEZ JORGE LUIS','','','1','33915','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 09:32:55','33915','347','BOD. FARMANORTE 347','1','33915','33915','33915','0','33915','1','0','0','','30/05/2024','',33915,0,0,'7703546703079','SUPREFLUX FORTE DOBLE ACCION MENTA * 240 ML L-GASTR','314','NOVAMED FARMA','2024-05-30 09:32:54',  36577, 51594, 738, 368),('FVE','FTCL','000662','2024-05-30 09:47:02','052024','CO','8785635','JAMES','BELILLA','',' 3042766924 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','4600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 09:47:02','4600','347','BOD. FARMANORTE 347','2','1300','2600','2600','0','2600','0','2','0','','30/05/2024','',4600,0,0,'7702123006718','ASPIRINA EFERVESCENTE 500 MG *50 TAB','631','BAYER OTC','2024-05-30 09:47:02',  52660, 22880, 738, 368),('FVE','FTCL','000662','2024-05-30 09:47:02','052024','CO','8785635','JAMES','BELILLA','',' 3042766924 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','4600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 09:47:02','4600','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',4600,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 09:47:02',  800, 48019, 738, 368),('FVE','FTCL','000663','2024-05-30 10:04:17','052024','CO','72272698','JHOANA ','NOVA','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','5','9107.563025210084','1692.4369747899154','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:04:18','10800','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','30/05/2024','',10800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 10:04:17',  100, 44347, 738, 368),('FVE','FTCL','000663','2024-05-30 10:04:17','052024','CO','72272698','JHOANA ','NOVA','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','5','9107.563025210084','1692.4369747899154','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:04:18','10800','347','BOD. FARMANORTE 347','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','30/05/2024','',10800,0,0,'7702090031928','GASEOSA MANZANA POSTOBON *400 ML','192','POSTOBON GASEOSAS','2024-05-30 10:04:17',  1400.8, 40922, 738, 368),('FVE','FTCL','000663','2024-05-30 10:04:17','052024','CO','72272698','JHOANA ','NOVA','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','5','9107.563025210084','1692.4369747899154','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:04:18','10800','347','BOD. FARMANORTE 347','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','30/05/2024','',10800,0,0,'7702090032031','GASEOSA KOLA POSTOBON *400 ML','192','POSTOBON GASEOSAS','2024-05-30 10:04:17',  1400.6, 25798, 738, 368),('FVE','FTCL','000663','2024-05-30 10:04:17','052024','CO','72272698','JHOANA ','NOVA','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','5','9107.563025210084','1692.4369747899154','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:04:18','10800','347','BOD. FARMANORTE 347','1','3500','3500','2941.1764705882','558.82352941176','3500','1','0','0','','30/05/2024','',10800,0,0,'7702189056795','CHEESE TRIS CHEETOS HORNEADOS *80 GR','762','FRITO LAY','2024-05-30 10:04:17',  2173, 59002, 738, 368),('FVE','FTCL','000663','2024-05-30 10:04:17','052024','CO','72272698','JHOANA ','NOVA','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','5','9107.563025210084','1692.4369747899154','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:04:18','10800','347','BOD. FARMANORTE 347','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','30/05/2024','',10800,0,0,'7702189055484','NATUCHIPS PLATANO MADURO *38 GR','762','FRITO LAY','2024-05-30 10:04:17',  1449, 56938, 738, 368),('FVE','FTCL','000664','2024-05-30 10:37:34','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','','4','41189.91596638656','2810.0840336134443','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:37:35','44000','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','30/05/2024','',44000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 10:37:34',  100, 44347, 738, 368),('FVE','FTCL','000664','2024-05-30 10:37:34','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','','4','41189.91596638656','2810.0840336134443','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:37:35','44000','347','BOD. FARMANORTE 347','1','24200','24200','24200','0','24200','1','0','0','','30/05/2024','',44000,0,0,'7501043130769','DOLEX NINOS 7+ *120 ML  ','616','HALEON (GLAXO OTC)','2024-05-30 10:37:34',  17651, 26539, 738, 368),('FVE','FTCL','000664','2024-05-30 10:37:34','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','','4','41189.91596638656','2810.0840336134443','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:37:35','44000','347','BOD. FARMANORTE 347','1','17600','17600','14789.915966387','2810.0840336134','17600','1','0','0','','30/05/2024','',44000,0,0,'7709442489222','NUTRAGUM KIDS BOLSA * 45 GOMAS','694','N&F COLOMBIA','2024-05-30 10:37:34',  7728, 49170, 738, 368),('FVE','FTCL','000664','2024-05-30 10:37:34','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','','4','41189.91596638656','2810.0840336134443','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 10:37:35','44000','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',44000,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 10:37:34',  1500, 44348, 738, 368),('FVE','FTCL','000665','2024-05-30 11:34:49','052024','CO','32831117','LESLY','SOTO','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','2','4600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 11:34:49','4600','347','BOD. FARMANORTE 347','2','2300','4600','4600','0','4600','0','2','0','','30/05/2024','',4600,0,0,'7702123006947','APRONAX 275 MG *50 CAP','631','BAYER OTC','2024-05-30 11:34:49',  93020, 22870, 738, 368),('FVE','FTCL','000666','2024-05-30 13:37:58','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','4537.81512605042','862.1848739495795','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 13:37:59','5400','347','BOD. FARMANORTE 347','2','1300','2600','2184.8739495798','415.12605042017','2600','2','0','0','','30/05/2024','',5400,0,0,'7622201717575','GALLETA CLUB SOCIAL ORIGINAL *24 GR','754','DISCOB NORTE SAS','2024-05-30 13:37:58',  560.2, 62038, 738, 368),('FVE','FTCL','000666','2024-05-30 13:37:58','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','4537.81512605042','862.1848739495795','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 13:37:59','5400','347','BOD. FARMANORTE 347','2','1400','2800','2352.9411764706','447.05882352941','2800','2','0','0','','30/05/2024','',5400,0,0,'7702025136773','GALLETAS FESTIVAL FRESA *6 GALLETAS','816','GRUPO NUTRESA','2024-05-30 13:37:58',  872.083, 53162, 738, 368),('FVE','FTCL','000667','2024-05-30 14:11:57','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','11','5900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:11:57','5900','347','BOD. FARMANORTE 347','1','2900','2900','2900','0','2900','0','1','0','','30/05/2024','',5900,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-05-30 14:11:57',  18581.4, 46200, 738, 368);
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','FTCL','000668','2024-05-30 14:17:47','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','11','43440.336134453784','2059.6638655462175','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:17:47','45500','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','30/05/2024','',45500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 14:17:47',  100, 44347, 738, 368),('FVE','FTCL','000668','2024-05-30 14:17:47','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','11','43440.336134453784','2059.6638655462175','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:17:47','45500','347','BOD. FARMANORTE 347','2','8900','17800','17800','0','17800','2','0','0','','30/05/2024','',45500,0,0,'7501125176548','ELECTROLIT UVA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-30 14:17:47',  6785, 33916, 738, 368),('FVE','FTCL','000668','2024-05-30 14:17:47','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','11','43440.336134453784','2059.6638655462175','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:17:47','45500','347','BOD. FARMANORTE 347','6','2100','12600','12600','0','12600','0','6','0','','30/05/2024','',45500,0,0,'7703381002313','BUSCAPINA FEM *90 COMP ','772','OPELLA (SANOFI OTC)','2024-05-30 14:17:47',  134048.9, 23812, 738, 368),('FVE','FTCL','000668','2024-05-30 14:17:47','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','11','43440.336134453784','2059.6638655462175','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:17:47','45500','347','BOD. FARMANORTE 347','1','12900','12900','10840.336134454','2059.6638655462','12900','1','0','0','','30/05/2024','',45500,0,0,'7701021145949','WINNY TOALLITAS ALOE VERA *100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-05-30 14:17:47',  8414.1, 33273, 738, 368),('FVE','FTCL','000668','2024-05-30 14:17:47','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','11','43440.336134453784','2059.6638655462175','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:17:47','45500','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',45500,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 14:17:47',  1500, 44348, 738, 368),('FVE','FTCL','000669','2024-05-30 14:58:53','052024','CO','1048282649','KEVIN JOSE ','FLORIAN GUTIERREZ','Calle 18 # 28 a 36 concord',' 3147045429','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','17100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:58:53','17100','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','86','','30/05/2024','',0,17100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 14:58:53',  100, 44347, 738, 368),('FVE','FTCL','000669','2024-05-30 14:58:53','052024','CO','1048282649','KEVIN JOSE ','FLORIAN GUTIERREZ','Calle 18 # 28 a 36 concord',' 3147045429','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','17100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:58:53','17100','347','BOD. FARMANORTE 347','1','14900','14900','14900','0','14900','1','0','86','','30/05/2024','',0,17100,0,'7702425805323','KOTEX TOALLA NOCTURNA *16 UNID','141','COLOMBIANA KIMBERLY COLPAPEL','2024-05-30 14:58:53',  13256, 49879, 738, 368),('FVE','FTCL','000669','2024-05-30 14:58:53','052024','CO','1048282649','KEVIN JOSE ','FLORIAN GUTIERREZ','Calle 18 # 28 a 36 concord',' 3147045429','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','17100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 14:58:53','17100','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','86','','30/05/2024','',0,17100,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 14:58:53',  1500, 44348, 738, 368),('FVE','FTCL','000670','2024-05-30 16:45:13','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','3865.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 16:45:16','4600','347','BOD. FARMANORTE 347','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','30/05/2024','',4600,0,0,'7702090038095','JUGO HIT FRUTAS TROPICALES *1 LT','192','POSTOBON GASEOSAS','2024-05-30 16:45:13',  2850.42, 54008, 738, 368),('FVE','FTCL','000671','2024-05-30 16:55:07','052024','CO','1048330521','SHIRLY','DE LA ROSA','cr9#8-45 centro malmabo ',' 3045870199 3045870199','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','40115.966386554624','7584.0336134453755','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 16:55:08','47700','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','201','','30/05/2024','',47700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 16:55:07',  100, 44347, 738, 368),('FVE','FTCL','000671','2024-05-30 16:55:07','052024','CO','1048330521','SHIRLY','DE LA ROSA','cr9#8-45 centro malmabo ',' 3045870199 3045870199','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','40115.966386554624','7584.0336134453755','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 16:55:08','47700','347','BOD. FARMANORTE 347','1','47500','47500','39915.966386555','7584.0336134454','47500','1','0','201','','30/05/2024','',47700,0,0,'7701021118868','WINNY PANTS ET6 XXG *30 UND','653','TECNOQUIMICAS WINNY','2024-05-30 16:55:07',  35898.3, 58101, 738, 368),('FVE','FTCL','000672','2024-05-30 17:06:38','052024','CO','1047341051','SARA ESTHER','PACHECO POLO',' Calle 12B crr 23 villa espenc',' 3014502641','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','22300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 17:06:38','22300','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','30/05/2024','',0,22300,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 17:06:38',  1500, 44348, 738, 368),('FVE','FTCL','000672','2024-05-30 17:06:38','052024','CO','1047341051','SARA ESTHER','PACHECO POLO',' Calle 12B crr 23 villa espenc',' 3014502641','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','22300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 17:06:38','22300','347','BOD. FARMANORTE 347','1','20100','20100','20100','0','20100','1','0','0','','30/05/2024','',0,22300,0,'7704403005602','MUCOSINA GOTAS *30 ML ','616','HALEON (GLAXO OTC)','2024-05-30 17:06:38',  17123, 39126, 738, 368),('FVE','FTCL','000672','2024-05-30 17:06:38','052024','CO','1047341051','SARA ESTHER','PACHECO POLO',' Calle 12B crr 23 villa espenc',' 3014502641','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','22300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 17:06:38','22300','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','30/05/2024','',0,22300,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 17:06:38',  100, 44347, 738, 368),('FVE','FTCL','000673','2024-05-30 17:37:10','052024','CO','72052784','WILSON','CAMARGO','000000000',' 1 3245140774','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','43100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 17:37:10','43100','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','216','','30/05/2024','',43100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 17:37:10',  100, 44347, 738, 368),('FVE','FTCL','000673','2024-05-30 17:37:10','052024','CO','72052784','WILSON','CAMARGO','000000000',' 1 3245140774','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','43100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 17:37:10','43100','347','BOD. FARMANORTE 347','1','42900','42900','42900','0','42900','1','0','216','','30/05/2024','',43100,0,0,'7702024185635','KLIM CLASICA FORTIFICADA *840 GR','776','NESTLE FOOD & BEVERAGE','2024-05-30 17:37:10',  36462, 57204, 738, 368),('FVE','FTCL','000674','2024-05-30 17:52:53','052024','CO','123456789','ALFREDO','GUTIERREZ','CASINO HB 805 ','######0 3256546540','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','6000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 17:52:53','6000','347','BOD. FARMANORTE 347','1','6000','6000','6000','0','6000','1','0','0','','30/05/2024','',6000,0,0,'7709456424882','AGUA MAS BOTELLON * 4LTS','893','SALUS','2024-05-30 17:52:53',  4050, 61718, 738, 368),('FVE','FTCL','000675','2024-05-30 18:03:52','052024','CO','1193102067','KATINA PAOLA','CANEDO AR Eacute VALO ','Calle 11 g # 1D 154  estoy ant',' 3145771271 3145771271','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','13','29100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:03:52','29100','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','146','','30/05/2024','',29100,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 18:03:52',  1500, 44348, 738, 368),('FVE','FTCL','000675','2024-05-30 18:03:52','052024','CO','1193102067','KATINA PAOLA','CANEDO AR Eacute VALO ','Calle 11 g # 1D 154  estoy ant',' 3145771271 3145771271','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','13','29100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:03:52','29100','347','BOD. FARMANORTE 347','1','16900','16900','16900','0','16900','1','0','146','','30/05/2024','',29100,0,0,'7707274723224','BACTROSAFE 500 MG * 3 TAB','890','ALLEN PHARMA','2024-05-30 18:03:52',  12099, 58701, 738, 368),('FVE','FTCL','000675','2024-05-30 18:03:52','052024','CO','1193102067','KATINA PAOLA','CANEDO AR Eacute VALO ','Calle 11 g # 1D 154  estoy ant',' 3145771271 3145771271','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','13','29100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:03:52','29100','347','BOD. FARMANORTE 347','10','1000','10000','10000','0','10000','0','10','146','','30/05/2024','',29100,0,0,'7703712080195','IBUPROFAR 800 MG CJA * 60 TB /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 18:03:52',  40080, 53652, 738, 368),('FVE','FTCL','000675','2024-05-30 18:03:52','052024','CO','1193102067','KATINA PAOLA','CANEDO AR Eacute VALO ','Calle 11 g # 1D 154  estoy ant',' 3145771271 3145771271','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','13','29100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:03:52','29100','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','146','','30/05/2024','',29100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 18:03:52',  100, 44347, 738, 368),('FVE','FTCL','000676','2024-05-30 18:20:25','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','12276.470588235294','223.52941176470586','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:20:25','12500','347','BOD. FARMANORTE 347','1','2300','2300','2300','0','2300','0','1','0','','30/05/2024','',12500,0,0,'7702123006947','APRONAX 275 MG *50 CAP','631','BAYER OTC','2024-05-30 18:20:25',  93020, 22870, 738, 368),('FVE','FTCL','000676','2024-05-30 18:20:25','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','12276.470588235294','223.52941176470586','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:20:25','12500','347','BOD. FARMANORTE 347','1','8800','8800','8800','0','8800','1','0','0','','30/05/2024','',12500,0,0,'7703689031145','PIEL RESISTENTE *3 PRESERVATIVOS','344','PROFAMILIA','2024-05-30 18:20:25',  6129, 40577, 738, 368),('FVE','FTCL','000676','2024-05-30 18:20:25','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','12276.470588235294','223.52941176470586','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:20:25','12500','347','BOD. FARMANORTE 347','1','1400','1400','1176.4705882353','223.52941176471','1400','1','0','0','','30/05/2024','',12500,0,0,'7702025136735','GALLETA FESTIVAL VAINILLA *6 GALLETAS','816','GRUPO NUTRESA','2024-05-30 18:20:25',  872.0833, 53175, 738, 368),('FVE','FTCL','000677','2024-05-30 18:49:17','052024','CO','1143171341','SHADIA VANESA ','DURAN QUINTANILLA','Calle 5A #8-34 por el lavadero',' 3162652430','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','57872.268907563026','10577.731092436974','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:49:17','68450','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','289','','30/05/2024','',68450,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 18:49:17',  1500, 44348, 738, 368),('FVE','FTCL','000677','2024-05-30 18:49:17','052024','CO','1143171341','SHADIA VANESA ','DURAN QUINTANILLA','Calle 5A #8-34 por el lavadero',' 3162652430','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','57872.268907563026','10577.731092436974','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:49:17','68450','347','BOD. FARMANORTE 347','1','66250','66250','55672.268907563','10577.731092437','66250','1','0','289','','30/05/2024','',68450,0,0,'7701021147585','WINNY ULTRATRIM SEC ET4 *50 UND ','653','TECNOQUIMICAS WINNY','2024-05-30 18:49:17',  50094, 48906, 738, 368),('FVE','FTCL','000677','2024-05-30 18:49:17','052024','CO','1143171341','SHADIA VANESA ','DURAN QUINTANILLA','Calle 5A #8-34 por el lavadero',' 3162652430','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','57872.268907563026','10577.731092436974','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 18:49:17','68450','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','289','','30/05/2024','',68450,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 18:49:17',  100, 44347, 738, 368),('FVE','FTCL','000678','2024-05-30 19:18:16','052024','CO','1048274856','PAMELA','LONDO Ntilde O','Calle 11a 3 # 5 sur 85 bellavi','  3007220859','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','78300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:18:17','78300','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',0,78300,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 19:18:16',  1500, 44348, 738, 368),('FVE','FTCL','000678','2024-05-30 19:18:16','052024','CO','1048274856','PAMELA','LONDO Ntilde O','Calle 11a 3 # 5 sur 85 bellavi','  3007220859','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','78300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:18:17','78300','347','BOD. FARMANORTE 347','1','76100','76100','76100','0','76100','1','0','0','','31/05/2024','',0,78300,0,'7702057012922','ALERFAST D JBE *90 ML','877','TECNOQUIMICAS VM TQ','2024-05-30 19:18:16',  61149, 49721, 738, 368),('FVE','FTCL','000678','2024-05-30 19:18:16','052024','CO','1048274856','PAMELA','LONDO Ntilde O','Calle 11a 3 # 5 sur 85 bellavi','  3007220859','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','3','78300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:18:17','78300','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,78300,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 19:18:16',  100, 44347, 738, 368),('FVE','FTCL','000681','2024-05-30 19:18:17','052024','CR','1007970820','YUZELLY CAROLINA','RICARDO OROZCO','CRA 39B NO.6-43',' 3016670567','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','278046','1','45000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:45:21','45000','347','BOD. FARMANORTE 347','1','45000','45000','45000','0','45000','1','0','0','','31/05/2024','',0,0,45000,'7708152336673','SUREZINC ADVANCE VAINILLA * 400 GR','1007','SUREZINC','2024-05-30 19:18:17',  16881, 62036, 738, 368),('FVE','FTCL','000679','2024-05-30 19:34:55','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','10','3949.5798319327732','750.4201680672268','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:34:56','4700','347','BOD. FARMANORTE 347','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','31/05/2024','',4700,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-30 19:34:55',  15435, 56535, 738, 368),('FVE','FTCL','000680','2024-05-30 19:35:57','052024','CO','72755618','DAVID','ARIZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','5294.117647058823','1005.8823529411766','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:35:57','6300','347','BOD. FARMANORTE 347','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','31/05/2024','',6300,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-30 19:35:57',  3881.5, 56142, 738, 368),('FVE','FTCL','000682','2024-05-30 19:51:15','052024','CO','1048328032','DILAN','COLOMO','cr 13 n 11-22 centro','3006032830 0 3044546671','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','8376','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:51:16','8376','347','BOD. FARMANORTE 347','3','2792','8376','8376','0','8376','0','3','42','','31/05/2024','',0,8376,0,'7703454123761','MILPAX NF CEREZA *12 SACHET','183','FARMA DE COLOMBIA SA','2024-05-30 19:51:15',  31246.9, 49769, 738, 368),('FVE','FTCL','000683','2024-05-30 19:58:08','052024','CO','44152827','KELLY','ESCORCIA','',' 00000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','10300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:58:08','10300','347','BOD. FARMANORTE 347','2','1800','3600','3600','0','3600','0','2','0','','31/05/2024','',10300,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-30 19:58:08',  111600, 43550, 738, 368),('FVE','FTCL','000683','2024-05-30 19:58:08','052024','CO','44152827','KELLY','ESCORCIA','',' 00000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','10300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:58:08','10300','347','BOD. FARMANORTE 347','2','2100','4200','4200','0','4200','0','2','0','','31/05/2024','',10300,0,0,'7702132009656','ADVIL MAX *72 CAP','616','HALEON (GLAXO OTC)','2024-05-30 19:58:08',  120793.6, 51646, 738, 368),('FVE','FTCL','000683','2024-05-30 19:58:08','052024','CO','44152827','KELLY','ESCORCIA','',' 00000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','10300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:58:08','10300','347','BOD. FARMANORTE 347','1','2500','2500','2500','0','2500','0','1','0','','31/05/2024','',10300,0,0,'7709080992504','LYPTUS MIEL MENTOL CJA * 24 SOBRES','1000','NATURALMENTE','2024-05-30 19:58:08',  17000, 63438, 738, 368),('FVE','FTCL','000684','2024-05-30 19:59:25','052024','CO','29940285','EDGAR','ARIZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','33800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:59:25','33800','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',33800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 19:59:25',  100, 44347, 738, 368),('FVE','FTCL','000684','2024-05-30 19:59:25','052024','CO','29940285','EDGAR','ARIZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','33800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 19:59:25','33800','347','BOD. FARMANORTE 347','1','33600','33600','33600','0','33600','1','0','0','','31/05/2024','',33800,0,0,'7709990568288','DIOSMIT 3GR CAJA *6 SOBRES','313','NTI (NEW TRADE INTERNATIONAL)','2024-05-30 19:59:25',  14100, 54384, 738, 368),('FVE','FTCL','000685','2024-05-30 20:01:53','052024','CO','8647079','VICTOR ','BECERRA','',' 3043931055','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','6218.487394957983','1181.5126050420167','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:01:53','7400','347','BOD. FARMANORTE 347','1','7400','7400','6218.487394958','1181.512605042','7400','1','0','0','','31/05/2024','',7400,0,0,'7702057080075','YODORA CREMA *25 GR','889','TECNOQUIMICAS CONSUMO','2024-05-30 20:01:53',  5025.12, 42930, 738, 368);
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','FTCL','000687','2024-05-30 20:12:33','052024','CO','1067728965','GEIFER','ARGUELLES','',' 3008657722 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','17900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:12:33','17900','347','BOD. FARMANORTE 347','1','14300','14300','14300','0','14300','1','0','0','','31/05/2024','',0,17900,0,'7702057061265','OXIMETAZOLINA 0.05% NASAL *15 ML ADULTOS MK','654','MK ETICOS CONVENIO','2024-05-30 20:12:33',  10456.32, 43203, 738, 368),('FVE','FTCL','000687','2024-05-30 20:12:33','052024','CO','1067728965','GEIFER','ARGUELLES','',' 3008657722 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','17900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:12:33','17900','347','BOD. FARMANORTE 347','2','1800','3600','3600','0','3600','0','2','0','','31/05/2024','',0,17900,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-30 20:12:33',  111600, 43550, 738, 368),('FVE','FTCL','000688','2024-05-30 20:20:30','052024','CO','8014278','PAULO','GARCIA','HOTEL WAIT HABITACION 29',' 3233253135','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','16','77770.58823529413','1229.411764705882','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:20:31','79000.00000000001','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',1.4551915228367E-11,79000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 20:20:30',  100, 44347, 738, 368),('FVE','FTCL','000688','2024-05-30 20:20:30','052024','CO','8014278','PAULO','GARCIA','HOTEL WAIT HABITACION 29',' 3233253135','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','16','77770.58823529413','1229.411764705882','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:20:31','79000.00000000001','347','BOD. FARMANORTE 347','1','35000','35000','35000','0','35000','1','0','0','','31/05/2024','',1.4551915228367E-11,79000,0,'7703712080362','AZITROFAR 500 MG * 3 TAB /D24/','387','TRIDEX FARMACEUTICA','2024-05-30 20:20:30',  21600, 40614, 738, 368),('FVE','FTCL','000688','2024-05-30 20:20:30','052024','CO','8014278','PAULO','GARCIA','HOTEL WAIT HABITACION 29',' 3233253135','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','16','77770.58823529413','1229.411764705882','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:20:31','79000.00000000001','347','BOD. FARMANORTE 347','1','22500','22500','22500','0','22500','1','0','0','','31/05/2024','',1.4551915228367E-11,79000,0,'7702184021002','HEDERA HELIX + PROPOLEO JARABE FRASCO * 100 ML','249','ECAR','2024-05-30 20:20:30',  3000, 63778, 738, 368),('FVE','FTCL','000688','2024-05-30 20:20:30','052024','CO','8014278','PAULO','GARCIA','HOTEL WAIT HABITACION 29',' 3233253135','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','16','77770.58823529413','1229.411764705882','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:20:31','79000.00000000001','347','BOD. FARMANORTE 347','10','770','7700','6470.5882352941','1229.4117647059','7700','0','10','0','','31/05/2024','',1.4551915228367E-11,79000,0,'7702605109296','VITAMINA C + ZINC NARANJA * 100 TAB','193','GENFAR','2024-05-30 20:20:30',  47405, 49172, 738, 368),('FVE','FTCL','000688','2024-05-30 20:20:30','052024','CO','8014278','PAULO','GARCIA','HOTEL WAIT HABITACION 29',' 3233253135','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','16','77770.58823529413','1229.411764705882','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:20:31','79000.00000000001','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',1.4551915228367E-11,79000,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 20:20:30',  1500, 44348, 738, 368),('FVE','FTCL','000688','2024-05-30 20:20:30','052024','CO','8014278','PAULO','GARCIA','HOTEL WAIT HABITACION 29',' 3233253135','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','16','77770.58823529413','1229.411764705882','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:20:31','79000.00000000001','347','BOD. FARMANORTE 347','1','8900','8900','8900','0','8900','1','0','0','','31/05/2024','',1.4551915228367E-11,79000,0,'7501125104268,7','ELECTROLIT FRESA SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-30 20:20:30',  6610, 47205, 738, 368),('FVE','FTCL','000688','2024-05-30 20:20:30','052024','CO','8014278','PAULO','GARCIA','HOTEL WAIT HABITACION 29',' 3233253135','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','16','77770.58823529413','1229.411764705882','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:20:31','79000.00000000001','347','BOD. FARMANORTE 347','1','2700','2700','2700','0','2700','0','1','0','','31/05/2024','',1.4551915228367E-11,79000,0,'7707263000749','GRIPAC NOCHE PANELA - LIMON * 24 SOBRES /D15/','387','TRIDEX FARMACEUTICA','2024-05-30 20:20:30',  33370, 62346, 738, 368),('FVE','FTCL','000689','2024-05-30 20:21:54','052024','CO','32859976','ELENA ','URUETA','0',' 0 3002958968','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','559357','72049173','CASTRO GUTIERREZ HECTOR DANIEL','','','1','13800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:21:54','13800','347','BOD. FARMANORTE 347','1','13800','13800','13800','0','13800','1','0','69','30','31/05/2024','',13800,0,0,'7702057078799','QUETIAPINA 25 MG *30 TAB MK','654','MK ETICOS CONVENIO','2024-05-30 20:21:54',  10974.7, 43266, 738, 368),('FVE','FTCL','000690','2024-05-30 20:24:17','052024','CO','32873661','GIRELIS','MENDOZA','',' 3005111585','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','21596.638655462186','4103.361344537813','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:24:17','25700','347','BOD. FARMANORTE 347','2','10900','21800','18319.327731092','3480.6722689076','21800','0','2','0','','31/05/2024','',25700,0,0,'4054839015915','VIVERA CJA *8 SOBRES','820','PROCTER & GAMBLE CHC','2024-05-30 20:24:17',  57006, 48052, 738, 368),('FVE','FTCL','000690','2024-05-30 20:24:17','052024','CO','32873661','GIRELIS','MENDOZA','',' 3005111585','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','21596.638655462186','4103.361344537813','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:24:17','25700','347','BOD. FARMANORTE 347','1','3900','3900','3277.3109243697','622.68907563025','3900','1','0','0','','31/05/2024','',25700,0,0,'7702189053824','DORITOS MEGA QUESO *68 GR','762','FRITO LAY','2024-05-30 20:24:17',  2521, 54759, 738, 368),('FVE','FTCL','000691','2024-05-30 20:40:13','052024','CO','72041739','WILSON','PE Ntilde A','cra 6 #9-21 al lado tienda las',' 3126890174','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','2','9900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:40:13','9900','347','BOD. FARMANORTE 347','1','7900','7900','7900','0','7900','1','0','0','15','31/05/2024','',9900,0,0,'7705959881214','CARVEDILOL 6.25 MG *30 TAB','193','GENFAR','2024-05-30 20:40:13',  7271, 25945, 738, 368),('FVE','FTCL','000691','2024-05-30 20:40:13','052024','CO','72041739','WILSON','PE Ntilde A','cra 6 #9-21 al lado tienda las',' 3126890174','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','2','9900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 20:40:13','9900','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',9900,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 20:40:13',  1500, 44348, 738, 368),('FVE','FTCL','000692','2024-05-30 21:07:02','052024','CO','1001889399','EDUAR ','MERCADO','Carrera 23 #20a 42 Villa spenc',' 3194750458','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','40348.73949579832','351.26050420168053','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:07:03','40700','347','BOD. FARMANORTE 347','1','38500','38500','38500','0','38500','1','0','202','8','31/05/2024','',40700,0,0,'7702001104000','ALPINA BABY ETP 2 *400 GR','773','ALPINA BABY','2024-05-30 21:07:02',  33367.986, 48363, 738, 368),('FVE','FTCL','000692','2024-05-30 21:07:02','052024','CO','1001889399','EDUAR ','MERCADO','Carrera 23 #20a 42 Villa spenc',' 3194750458','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','40348.73949579832','351.26050420168053','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:07:03','40700','347','BOD. FARMANORTE 347','1','2200','2200','1848.7394957983','351.26050420168','2200','1','0','202','','31/05/2024','',40700,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-05-30 21:07:02',  1050.4, 47478, 738, 368),('FVE','FTCL','000693','2024-05-30 21:21:20','052024','CO','1001963771','ELIAN','ALVAREZ','00000000',' 1 3104511754','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','3800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:21:20','3800','347','BOD. FARMANORTE 347','2','1900','3800','3800','0','3800','0','2','0','','31/05/2024','',3800,0,0,'7702057168056','NORAVER-P MENTA *96 TAB','382','TECNOQUIMICAS','2024-05-30 21:21:20',  131276, 43182, 738, 368),('FVE','FTCL','000694','2024-05-30 21:38:33','052024','CO','72041383','EDWIN ','VALERA','calle12#6-76 el pradito',' 3177140856 3177140856','3456','DRINA STEFANNY','MIRANDA SERJE','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','1001313741','1001313741','CAMARGO JIMENEZ JERRY A','','','10','80800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:38:33','80800','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','404','','31/05/2024','',80800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 21:38:33',  100, 44347, 738, 368),('FVE','FTCL','000694','2024-05-30 21:38:33','052024','CO','72041383','EDWIN ','VALERA','calle12#6-76 el pradito',' 3177140856 3177140856','3456','DRINA STEFANNY','MIRANDA SERJE','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','1001313741','1001313741','CAMARGO JIMENEZ JERRY A','','','10','80800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:38:33','80800','347','BOD. FARMANORTE 347','3','7600','22800','22800','0','22800','0','3','404','','31/05/2024','',80800,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-05-30 21:38:33',  63045, 31775, 738, 368),('FVE','FTCL','000694','2024-05-30 21:38:33','052024','CO','72041383','EDWIN ','VALERA','calle12#6-76 el pradito',' 3177140856 3177140856','3456','DRINA STEFANNY','MIRANDA SERJE','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','1001313741','1001313741','CAMARGO JIMENEZ JERRY A','','','10','80800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:38:33','80800','347','BOD. FARMANORTE 347','2','15900','31800','31800','0','31800','0','2','404','','31/05/2024','',80800,0,0,'7702771001561','ENTEROGERMINA PLUS *5 AMP','772','OPELLA (SANOFI OTC)','2024-05-30 21:38:33',  74092.5, 48571, 738, 368),('FVE','FTCL','000694','2024-05-30 21:38:33','052024','CO','72041383','EDWIN ','VALERA','calle12#6-76 el pradito',' 3177140856 3177140856','3456','DRINA STEFANNY','MIRANDA SERJE','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','1001313741','1001313741','CAMARGO JIMENEZ JERRY A','','','10','80800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:38:33','80800','347','BOD. FARMANORTE 347','3','8000','24000','24000','0','24000','0','3','404','','31/05/2024','',80800,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-30 21:38:33',  53223.5, 41855, 738, 368),('FVE','FTCL','000694','2024-05-30 21:38:33','052024','CO','72041383','EDWIN ','VALERA','calle12#6-76 el pradito',' 3177140856 3177140856','3456','DRINA STEFANNY','MIRANDA SERJE','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','1001313741','1001313741','CAMARGO JIMENEZ JERRY A','','','10','80800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:38:33','80800','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','404','','31/05/2024','',80800,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 21:38:33',  1500, 44348, 738, 368),('FVE','FTCL','000695','2024-05-30 21:41:16','052024','CO','32611546','JASIBIS ','HENAO ','cr 13 n 11-22','0 0 3003791618','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','1932.7731092436975','367.2268907563025','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:41:16','2300','347','BOD. FARMANORTE 347','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','10','','31/05/2024','',2300,0,0,'7702402051361','HELADO CASERO RON CON PASAS *60 GR','296','MEALS DE COLOMBIA','2024-05-30 21:41:16',  1206, 52362, 738, 368),('FVE','FTCL','000696','2024-05-30 21:52:43','052024','CO','1048279155','JULIAN ','SARMIENTO','',' 00000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','15','23952','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:52:43','23952','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',23952,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 21:52:43',  100, 44347, 738, 368),('FVE','FTCL','000696','2024-05-30 21:52:43','052024','CO','1048279155','JULIAN ','SARMIENTO','',' 00000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','15','23952','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:52:43','23952','347','BOD. FARMANORTE 347','8','1619','12952','12952','0','12952','0','8','0','','31/05/2024','',23952,0,0,'7702626214849','STREPSILS INTENSIVE MIEL-LIMON *16 TAB','357','RECKITT BENCKISER COLOMBIA S A','2024-05-30 21:52:43',  20656, 53074, 738, 368),('FVE','FTCL','000696','2024-05-30 21:52:43','052024','CO','1048279155','JULIAN ','SARMIENTO','',' 00000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','15','23952','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:52:43','23952','347','BOD. FARMANORTE 347','6','1800','10800','10800','0','10800','0','6','0','','31/05/2024','',23952,0,0,'7707019413816','CLINBAC 300 MG * 24 CAP','130','LABQUIFAR PHARMACEUTICA','2024-05-30 21:52:43',  19720, 45899, 738, 368),('FVE','FTCL','000697','2024-05-30 21:57:18','052024','CO','1140897143','ANGIE ','MARQUEZ AMAYA','Carrera 7 10b 89 el pradito',' 3103283083 3103283083','3456','DRINA STEFANNY','MIRANDA SERJE','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','2','38722.68907563025','6977.310924369747','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:57:18','45700','347','BOD. FARMANORTE 347','1','43700','43700','36722.68907563','6977.3109243697','43700','1','0','194','','31/05/2024','',0,45700,0,'7701021114174','WINNY ULTRATRIM SEC ET5 *30 UND  ','653','TECNOQUIMICAS WINNY','2024-05-30 21:57:18',  32994.9, 43226, 738, 368),('FVE','FTCL','000697','2024-05-30 21:57:18','052024','CO','1140897143','ANGIE ','MARQUEZ AMAYA','Carrera 7 10b 89 el pradito',' 3103283083 3103283083','3456','DRINA STEFANNY','MIRANDA SERJE','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','2','38722.68907563025','6977.310924369747','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 21:57:18','45700','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','194','','31/05/2024','',0,45700,0,'DO','DOMICILIO','00','VARIOS','2024-05-30 21:57:18',  1500, 44348, 738, 368),('FVE','FTCL','000698','2024-05-30 22:03:14','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','9600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:03:14','9600','347','BOD. FARMANORTE 347','1','9600','9600','9600','0','9600','1','0','0','','31/05/2024','',9600,0,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-05-30 22:03:14',  8380, 22278, 738, 368),('FVE','FTCL','000699','2024-05-30 22:07:36','052024','CO','1140837266','ACRILETH','ORELLANO','CLL 11 N8-33 CENTRO','  3017564086 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','8065.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:07:36','8800','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',8800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 22:07:36',  100, 44347, 738, 368),('FVE','FTCL','000699','2024-05-30 22:07:36','052024','CO','1140837266','ACRILETH','ORELLANO','CLL 11 N8-33 CENTRO','  3017564086 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','8065.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:07:36','8800','347','BOD. FARMANORTE 347','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','31/05/2024','',8800,0,0,'7702090038071','JUGO HIT MANGO *1 LT','192','POSTOBON GASEOSAS','2024-05-30 22:07:36',  2850.42, 53815, 738, 368),('FVE','FTCL','000699','2024-05-30 22:07:36','052024','CO','1140837266','ACRILETH','ORELLANO','CLL 11 N8-33 CENTRO','  3017564086 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','8065.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:07:36','8800','347','BOD. FARMANORTE 347','2','2000','4000','4000','0','4000','2','0','0','','31/05/2024','',8800,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-30 22:07:36',  800, 48019, 738, 368),('FVE','FTCL','000700','2024-05-30 22:29:29','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','3393.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:29:29','4000','347','BOD. FARMANORTE 347','2','850','1700','1428.5714285714','271.42857142857','1700','2','0','0','','31/05/2024','',4000,0,0,'7707282990298','JERINGA 10ML DESECHABLE 21 GR *1 1/2','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-30 22:29:29',  256.9, 63651, 738, 368),('FVE','FTCL','000700','2024-05-30 22:29:29','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','3393.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:29:29','4000','347','BOD. FARMANORTE 347','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','31/05/2024','',4000,0,0,'7702090069235','HIT NECTAR MANZANA VNR *237 ML','192','POSTOBON GASEOSAS','2024-05-30 22:29:29',  1281.5, 60808, 738, 368),('FVE','FTCL','000700','2024-05-30 22:29:29','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','3393.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:29:29','4000','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',4000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 22:29:29',  100, 44347, 738, 368),('FVE','FTCL','000701','2024-05-30 22:33:03','052024','CO','1143269090','FABIO ANDRES','INFANTE','',' 3005426384','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','3729.4117647058824','670.5882352941176','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:33:04','4400','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,4400,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-30 22:33:03',  100, 44347, 738, 368),('FVE','FTCL','000701','2024-05-30 22:33:03','052024','CO','1143269090','FABIO ANDRES','INFANTE','',' 3005426384','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','3729.4117647058824','670.5882352941176','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:33:04','4400','347','BOD. FARMANORTE 347','2','2100','4200','3529.4117647059','670.58823529412','4200','2','0','0','','31/05/2024','',0,4400,0,'7702090069235','HIT NECTAR MANZANA VNR *237 ML','192','POSTOBON GASEOSAS','2024-05-30 22:33:03',  1281.5, 60808, 738, 368),('FVE','FTCL','000702','2024-05-30 22:38:39','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','4705.882352941177','894.1176470588234','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:38:39','5600','347','BOD. FARMANORTE 347','1','5600','5600','4705.8823529412','894.11764705882','5600','1','0','0','','31/05/2024','',5600,0,0,'7702004013514','PONY MALTA PET *1.5 LT','119','BAVARIA S.A.','2024-05-30 22:38:39',  3991.6, 36945, 738, 368),('FVE','FTCL','000703','2024-05-30 22:52:19','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','4600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 22:52:19','4600','347','BOD. FARMANORTE 347','2','2300','4600','4600','0','4600','0','2','0','','31/05/2024','',4600,0,0,'7702123006947','APRONAX 275 MG *50 CAP','631','BAYER OTC','2024-05-30 22:52:19',  93020, 22870, 738, 368),('FVE','FTCL','000704','2024-05-30 23:13:26','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','5000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:13:26','5000','347','BOD. FARMANORTE 347','1','3000','3000','3000','0','3000','0','1','0','','31/05/2024','',5000,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2024-05-30 23:13:26',  27350, 46776, 738, 368);
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','FTCL','000705','2024-05-30 23:24:13','052024','CO','72333454','JHONATAN','SOSA','',' 3022636315 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','13000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:24:14','13000','347','BOD. FARMANORTE 347','5','1400','7000','7000','0','7000','0','5','0','','31/05/2024','',13000,0,0,'7707019402063','DOSALDIN *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-30 23:24:13',  13040, 45886, 738, 368),('FVE','FTCL','000705','2024-05-30 23:24:13','052024','CO','72333454','JHONATAN','SOSA','',' 3022636315 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','13000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:24:14','13000','347','BOD. FARMANORTE 347','1','6000','6000','6000','0','6000','1','0','0','','31/05/2024','',13000,0,0,'7709456424882','AGUA MAS BOTELLON * 4LTS','893','SALUS','2024-05-30 23:24:13',  4050, 61718, 738, 368),('FVE','FTCL','000706','2024-05-30 23:28:22','052024','CO','72044523','JHONYS ','PEREZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','10','8430','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:28:23','8430','347','BOD. FARMANORTE 347','10','843','8430','8430','0','8430','0','10','0','','31/05/2024','',8430,0,0,'7707019412208','DEUCILINA 500 MG *30 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-30 23:28:22',  10600, 45895, 738, 368),('FVE','FTCL','000707','2024-05-30 23:33:04','052024','CO','72044523','JHONYS ','PEREZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','5000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:33:04','5000','347','BOD. FARMANORTE 347','2','2500','5000','5000','0','5000','0','2','0','','31/05/2024','',5000,0,0,'7709080992504','LYPTUS MIEL MENTOL CJA * 24 SOBRES','1000','NATURALMENTE','2024-05-30 23:33:04',  17000, 63438, 738, 368),('FVE','FTCL','000708','2024-05-30 23:43:52','052024','CO','72044523','JHONYS ','PEREZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','3193.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:43:52','3800','347','BOD. FARMANORTE 347','1','3800','3800','3193.2773109244','606.72268907563','3800','1','0','0','','31/05/2024','',3800,0,0,'7702090050974','SPEED MAX *1 LT','192','POSTOBON GASEOSAS','2024-05-30 23:43:52',  2451, 53555, 738, 368),('FVE','FTCL','000709','2024-05-30 23:57:21','052024','CO','72050863','JORGE ','ACOSTA URQUIJO','',' 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','11596.638655462184','2203.3613445378146','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:57:21','13799.999999999998','347','BOD. FARMANORTE 347','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','31/05/2024','',13800,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-30 23:57:21',  3881.5, 56142, 738, 368),('FVE','FTCL','000709','2024-05-30 23:57:21','052024','CO','72050863','JORGE ','ACOSTA URQUIJO','',' 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','11596.638655462184','2203.3613445378146','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:57:21','13799.999999999998','347','BOD. FARMANORTE 347','1','5200','5200','4369.7478991597','830.25210084034','5200','1','0','0','','31/05/2024','',13800,0,0,'7702010420962','PROTEX JABON LIMPIEZA PROFUNDA *110 GR','145','COLGATE PALMOLIVE COMPANIA','2024-05-30 23:57:21',  2652.9035, 52324, 738, 368),('FVE','FTCL','000709','2024-05-30 23:57:21','052024','CO','72050863','JORGE ','ACOSTA URQUIJO','',' 3000000000','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','11596.638655462184','2203.3613445378146','347','FARMANORTE 347','ADMINISTRADOR','2024-05-30 23:57:21','13799.999999999998','347','BOD. FARMANORTE 347','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','31/05/2024','',13800,0,0,'7702090031928','GASEOSA MANZANA POSTOBON *400 ML','192','POSTOBON GASEOSAS','2024-05-30 23:57:21',  1400.8, 40922, 738, 368),('FVE','FTCL','000710','2024-05-31 00:02:52','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','3200','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:02:52','3200','347','BOD. FARMANORTE 347','2','1600','3200','3200','0','3200','0','2','0','','31/05/2024','',3200,0,0,'7707019301007','VICERALGINA COMP *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-31 00:02:52',  11550, 23616, 738, 368),('FVE','FTCL','000711','2024-05-31 00:15:38','052024','CO','1048267451','EMMANUEL','VILLALOBO','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','7','14966.386554621848','1133.6134453781508','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:15:38','16099.999999999998','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',16100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 00:15:38',  100, 44347, 738, 368),('FVE','FTCL','000711','2024-05-31 00:15:38','052024','CO','1048267451','EMMANUEL','VILLALOBO','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','7','14966.386554621848','1133.6134453781508','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:15:38','16099.999999999998','347','BOD. FARMANORTE 347','2','2700','5400','5400','0','5400','0','2','0','','31/05/2024','',16100,0,0,'7702057840310','SAL DE FRUTAS LUA *50 SOBRES','382','TECNOQUIMICAS','2024-05-31 00:15:38',  105944.66, 43290, 738, 368),('FVE','FTCL','000711','2024-05-31 00:15:38','052024','CO','1048267451','EMMANUEL','VILLALOBO','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','7','14966.386554621848','1133.6134453781508','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:15:38','16099.999999999998','347','BOD. FARMANORTE 347','1','3400','3400','3400','0','3400','0','1','0','','31/05/2024','',16100,0,0,'7702057841256','BONFIEST PLUS *32 SOBRES','382','TECNOQUIMICAS','2024-05-31 00:15:38',  87257.22, 43283, 738, 368),('FVE','FTCL','000711','2024-05-31 00:15:38','052024','CO','1048267451','EMMANUEL','VILLALOBO','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','7','14966.386554621848','1133.6134453781508','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:15:38','16099.999999999998','347','BOD. FARMANORTE 347','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','31/05/2024','',16100,0,0,'7702189012579','PAPAS MARGARITA LIMON *30 GR','762','FRITO LAY','2024-05-31 00:15:38',  1594, 36674, 738, 368),('FVE','FTCL','000711','2024-05-31 00:15:38','052024','CO','1048267451','EMMANUEL','VILLALOBO','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','7','14966.386554621848','1133.6134453781508','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:15:38','16099.999999999998','347','BOD. FARMANORTE 347','1','2100','2100','1764.7058823529','335.29411764706','2100','1','0','0','','31/05/2024','',16100,0,0,'7702090069235','HIT NECTAR MANZANA VNR *237 ML','192','POSTOBON GASEOSAS','2024-05-31 00:15:38',  1281.5, 60808, 738, 368),('FVE','FTCL','000711','2024-05-31 00:15:38','052024','CO','1048267451','EMMANUEL','VILLALOBO','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','7','14966.386554621848','1133.6134453781508','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:15:38','16099.999999999998','347','BOD. FARMANORTE 347','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','31/05/2024','',16100,0,0,'7702189012494','PAPAS MARGARITA NATURAL *38 GR','762','FRITO LAY','2024-05-31 00:15:38',  1594, 36160, 738, 368),('FVE','FTCL','000712','2024-05-31 00:19:39','052024','CO','32584017','DRINA STEFANNY','MIRANDA SERJE','CRA 16 NO.12-29',' 3043345746','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','1800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:19:39','1800','347','BOD. FARMANORTE 347','1','1800','1800','1800','0','1800','1','0','1','','31/05/2024','',1800,0,0,'7702535010341','AGUA BRISA CON GAS * 600 ML','144','COCA COLA','2024-05-31 00:19:39',  1156, 57012, 738, 368),('FVE','FTCL','000713','2024-05-31 00:41:12','052024','CO','1048321058','EMANUEL','QUINTERO','',' 0 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','8721.008403361346','478.9915966386552','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:41:12','9200','347','BOD. FARMANORTE 347','2','3100','6200','6200','0','6200','0','2','0','','31/05/2024','',0,9200,0,'7703445030153','FLUIMUCIL 600 MG *30 S/S ','397','ZAMBON COLOMBIA ','2024-05-31 00:41:12',  77290, 44302, 738, 368),('FVE','FTCL','000713','2024-05-31 00:41:12','052024','CO','1048321058','EMANUEL','QUINTERO','',' 0 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','3','8721.008403361346','478.9915966386552','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 00:41:12','9200','347','BOD. FARMANORTE 347','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','0','','31/05/2024','',0,9200,0,'7702090036930','GASEOSA COLOMBIANA CERO *1 LT ECONOLITRO','192','POSTOBON GASEOSAS','2024-05-31 00:41:12',  2100.8, 53831, 738, 368),('FVE','FTCL','000714','2024-05-31 01:19:55','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','2','4000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 01:19:55','4000','347','BOD. FARMANORTE 347','2','2000','4000','4000','0','4000','0','2','0','','31/05/2024','',4000,0,0,'107703381000951','BUSCAPINA COMP N.F *100 TAB','772','OPELLA (SANOFI OTC)','2024-05-31 01:19:55',  161226.6, 23806, 738, 368),('FVE','FTCL','000715','2024-05-31 01:19:56','052024','CR','32584017','DRINA STEFANNY','MIRANDA SERJE','CRA 16 NO.12-29',' 3043345746','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','414806','6','55000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 01:35:04','55000','347','BOD. FARMANORTE 347','1','45000','45000','45000','0','45000','1','0','0','','31/05/2024','',0,0,55000,'7708152336055','SUREZINC ADVANCE FRESA * 400 GR','1007','SUREZINC','2024-05-31 01:19:56',  16881, 62181, 738, 368),('FVE','FTCL','000715','2024-05-31 01:19:56','052024','CR','32584017','DRINA STEFANNY','MIRANDA SERJE','CRA 16 NO.12-29',' 3043345746','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','414806','6','55000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 01:35:04','55000','347','BOD. FARMANORTE 347','5','2000','10000','10000','0','10000','0','5','0','','31/05/2024','',0,0,55000,'7708152336826','SUREZINC COLAGENO VAINILLA * 36 S/S','1007','SUREZINC','2024-05-31 01:19:56',  25000, 62506, 738, 368),('FVE','FTCL','000716','2024-05-31 01:40:47','052024','CO','1048270191','GUSTAVO ','GUTIERREZ HARPON','CRA 16 #12-29',' 3022407591','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','2000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 01:40:47','2000','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','0','1','10','','31/05/2024','',0,2000,0,'7708152336826','SUREZINC COLAGENO VAINILLA * 36 S/S','1007','SUREZINC','2024-05-31 01:40:47',  25000, 62506, 738, 368),('FVE','FTCL','000717','2024-05-31 01:42:17','052024','CO','32584017','DRINA STEFANNY','MIRANDA SERJE','CRA 16 NO.12-29',' 3043345746','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','1260.5042016806724','239.4957983193276','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 01:42:17','1500','347','BOD. FARMANORTE 347','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','1','','31/05/2024','',500,1000,0,'7702090049343','AGUA H2O LIMONATA BOTELLA * 250 ML','192','POSTOBON GASEOSAS','2024-05-31 01:42:17',  840.3, 52914, 738, 368),('FVE','FTCL','000718','2024-05-31 02:01:45','052024','CO','72052656','GEOVANNY ENRIQUE ','BUITRAGO SANDOBAL','0',' 3113957741 3113957741','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','64761.904761904756','3238.095238095244','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 02:01:45','68000','347','BOD. FARMANORTE 347','1','68000','68000','64761.904761905','3238.0952380952','68000','1','0','0','','31/05/2024','',0,68000,0,'7702049000906','AGUARDIENTE ANTIOQUEÑO *1000 ML T.AZUL S/AZUCAR ','808','ANTIOQUIA AGUARDIENTE','2024-05-31 02:01:45',  35042, 53941, 738, 368),('FVE','FTCL','000719','2024-05-31 02:11:49','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','10','4500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 02:11:49','4500','347','BOD. FARMANORTE 347','10','450','4500','4500','0','4500','0','10','0','','31/05/2024','',4500,0,0,'7706569000385','IBUPROFENO 800MG *50 TAB','614','A.G. MEDICAMENTOS','2024-05-31 02:11:49',  13144, 31502, 738, 368),('FVE','FTCL','000720','2024-05-31 04:48:09','052024','CO','72044523','JHONYS ','PEREZ','',' 3222222222','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','8900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 04:48:10','8900','347','BOD. FARMANORTE 347','1','8900','8900','8900','0','8900','1','0','0','','31/05/2024','',8900,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-31 04:48:09',  6610, 54196, 738, 368),('FVE','FTCL','000721','2024-05-31 04:51:39','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','8900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 04:51:40','8900','347','BOD. FARMANORTE 347','1','8900','8900','8900','0','8900','1','0','0','','31/05/2024','',8900,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-31 04:51:39',  6610, 54196, 738, 368),('FVE','FTCL','000722','2024-05-31 05:09:34','052024','CO','3732914','FERNANDO ','MIRANDA','000000000',' 3145158828','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','4','6476','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 05:09:34','6476','347','BOD. FARMANORTE 347','4','1619','6476','6476','0','6476','0','4','0','','31/05/2024','',6476,0,0,'7702626214849','STREPSILS INTENSIVE MIEL-LIMON *16 TAB','357','RECKITT BENCKISER COLOMBIA S A','2024-05-31 05:09:34',  20656, 53074, 738, 368),('FVE','FTCL','000723','2024-05-31 05:18:15','052024','CO','1010145105','DEIVAN','BOLIVAR','',' 0 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','16','11083','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 05:18:16','11083','347','BOD. FARMANORTE 347','1','2083','2083','2083','0','2083','0','1','0','','31/05/2024','',11083,0,0,'7703546703086','SUPREFLUX FORTE DOBLE ACCION MENTA * 12 S/S L-GASTR','314','NOVAMED FARMA','2024-05-31 05:18:15',  23099, 51593, 738, 368),('FVE','FTCL','000723','2024-05-31 05:18:15','052024','CO','1010145105','DEIVAN','BOLIVAR','',' 0 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','16','11083','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 05:18:16','11083','347','BOD. FARMANORTE 347','15','600','9000','9000','0','9000','0','15','0','','31/05/2024','',11083,0,0,'7703546131308','PRAZED 20 MG * 30 CAP L-CONSUM','630','NOVAMED OTC','2024-05-31 05:18:15',  13493, 38600, 738, 368),('FVE','FTCL','000724','2024-05-31 06:49:54','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','4780.672268907563','319.3277310924368','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 06:49:55','5100','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',5100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 06:49:54',  100, 44347, 738, 368),('FVE','FTCL','000724','2024-05-31 06:49:54','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','4780.672268907563','319.3277310924368','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 06:49:55','5100','347','BOD. FARMANORTE 347','1','2900','2900','2900','0','2900','1','0','0','','31/05/2024','',5100,0,0,'7702560000362','ALGODON JGB *25 GR','219','JGB','2024-05-31 06:49:54',  1750.1, 27772, 738, 368),('FVE','FTCL','000724','2024-05-31 06:49:54','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','4780.672268907563','319.3277310924368','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 06:49:55','5100','347','BOD. FARMANORTE 347','3','500','1500','1260.5042016807','239.49579831933','1500','3','0','0','','31/05/2024','',5100,0,0,'7707228361786','JERINGA 5 ML X21G X1 1/2 HIPODERMICA ALFASAFE','429','ALFA SAFE','2024-05-31 06:49:54',  255, 46100, 738, 368),('FVE','FTCL','000724','2024-05-31 06:49:54','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','6','4780.672268907563','319.3277310924368','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 06:49:55','5100','347','BOD. FARMANORTE 347','1','500','500','420.16806722689','79.831932773109','500','1','0','0','','31/05/2024','',5100,0,0,'7707282990274','JERINGA 5ML DESECHABLE  21GX1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-31 06:49:54',  168.46, 58667, 738, 368),('FVE','FTCL','000725','2024-05-31 06:51:20','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','9600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 06:51:20','9600','347','BOD. FARMANORTE 347','1','9600','9600','9600','0','9600','1','0','0','','31/05/2024','',9600,0,0,'7501033957376','PEDIALYTE MAX ZINC 60 UVA *500 ML','659','ABBOTT NUTRICION','2024-05-31 06:51:20',  8380, 22278, 738, 368),('FVE','FTCL','000726','2024-05-31 06:52:25','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','2000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 06:52:25','2000','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','0','1','0','','31/05/2024','',2000,0,0,'7703234103044','NOXPIRIN F DIA JUGO MANDARINA *24 S/S ','626','SIEGFRIED CONSUMO','2024-05-31 06:52:25',  31924, 31060, 738, 368),('FVE','FTCL','000727','2024-05-31 07:17:07','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3456','DRINA STEFANNY','MIRANDA SERJE','','TERCERO','VARIOS','','','','','','1','672.2689075630252','127.73109243697479','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 07:17:07','800','347','BOD. FARMANORTE 347','1','800','800','672.26890756303','127.73109243697','800','1','0','0','','31/05/2024','',800,0,0,'D1002','RECOLECTOR DE ORINA TAPA AZUL D1002','402','PARACLINICAS','2024-05-31 07:17:07',  228.3, 39236, 738, 368),('FVE','FTCL','000728','2024-05-31 07:57:05','052024','CO','1048289250','KEI NTILDE A','FERNANDEZ','','0  3145269812','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','559357','559357','CASTRO GUTIERREZ HECTOR DANIEL','','','1','139900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 07:57:06','139900','347','BOD. FARMANORTE 347','1','139900','139900','139900','0','139900','1','0','0','','31/05/2024','',139900,0,0,'7702057010935','CYTIL 200 MG FRASCO *7 TAB ','877','TECNOQUIMICAS VM TQ','2024-05-31 07:57:05',  139300, 42908, 738, 368),('FVE','FTCL','000729','2024-05-31 08:29:22','052024','CO','72048284','ALEX','SILVA','',' 3046795374 3222222222','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','22700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 08:29:22','22700','347','BOD. FARMANORTE 347','1','22700','22700','22700','0','22700','1','0','0','28','31/05/2024','',0,22700,0,'7896261006249','DIOVAN 80 MG X 28 TABLS  ','904','SIEGFRIED NOVARTIS','2024-05-31 08:29:22',  18486, 38668, 738, 368),('FVE','FTCL','000730','2024-05-31 08:57:51','052024','CO','1047362773','SANDRA ','RAMIRES ','CALLE 10A #6 106 TIMBRE 202. S',' 3023107381','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','559357','72049173','CASTRO GUTIERREZ HECTOR DANIEL','','','1','64800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 08:57:52','64800','347','BOD. FARMANORTE 347','1','64800','64800','64800','0','64800','1','0','0','','31/05/2024','',0,64800,0,'7703445109057','URSACOL 300 MG *20 TAB','397','ZAMBON COLOMBIA ','2024-05-31 08:57:51',  59770.5, 54996, 738, 368);
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','FTCL','000731','2024-05-31 10:21:32','052024','CO','1048268165','LISNEY',' LOPEZ','',' 000','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','13','42849.57983193277','750.4201680672268','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:21:32','43600','347','BOD. FARMANORTE 347','1','16200','16200','16200','0','16200','1','0','0','','31/05/2024','',43600,0,0,'7707172685778','DOLEX JARABE 2+ *90 ML ','616','HALEON (GLAXO OTC)','2024-05-31 10:21:32',  8035.7, 26537, 738, 368),('FVE','FTCL','000731','2024-05-31 10:21:32','052024','CO','1048268165','LISNEY',' LOPEZ','',' 000','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','13','42849.57983193277','750.4201680672268','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:21:32','43600','347','BOD. FARMANORTE 347','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','0','','31/05/2024','',43600,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-31 10:21:32',  15435, 56535, 738, 368),('FVE','FTCL','000731','2024-05-31 10:21:32','052024','CO','1048268165','LISNEY',' LOPEZ','',' 000','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','13','42849.57983193277','750.4201680672268','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:21:32','43600','347','BOD. FARMANORTE 347','1','22500','22500','22500','0','22500','1','0','0','','31/05/2024','',43600,0,0,'7702184021002','HEDERA HELIX + PROPOLEO JARABE FRASCO * 100 ML','249','ECAR','2024-05-31 10:21:32',  3000, 63778, 738, 368),('FVE','FTCL','000732','2024-05-31 10:23:44','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','4','1932.7731092436975','367.22689075630245','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:23:44','2300','347','BOD. FARMANORTE 347','1','300','300','252.10084033613','47.899159663866','300','0','1','0','','31/05/2024','',2300,0,0,'7622210427267','CHICLETS ADAMS MENTA *100 UNID','754','DISCOB NORTE SAS','2024-05-31 10:23:44',  13445.4, 34188, 738, 368),('FVE','FTCL','000732','2024-05-31 10:23:44','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','4','1932.7731092436975','367.22689075630245','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:23:44','2300','347','BOD. FARMANORTE 347','2','300','600','504.20168067227','95.798319327731','600','0','2','0','','31/05/2024','',2300,0,0,'7702007046137','JET GOOL BALONES *100 UND','816','GRUPO NUTRESA','2024-05-31 10:23:44',  13524, 52642, 738, 368),('FVE','FTCL','000732','2024-05-31 10:23:44','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','4','1932.7731092436975','367.22689075630245','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:23:44','2300','347','BOD. FARMANORTE 347','1','1400','1400','1176.4705882353','223.52941176471','1400','1','0','0','','31/05/2024','',2300,0,0,'7702025136773','GALLETAS FESTIVAL FRESA *6 GALLETAS','816','GRUPO NUTRESA','2024-05-31 10:23:44',  872.083, 53162, 738, 368),('FVE','FTCL','000733','2024-05-31 10:41:01','052024','CO','72041051','OSCAR','RODRIGUEZ FERRER','a',' 3222222222','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','577904','92189311','ARRIETA CASTRO EDILBERTO MANUEL','','','1','32000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:41:02','32000','347','BOD. FARMANORTE 347','1','32000','32000','32000','0','32000','1','0','0','','31/05/2024','',32000,0,0,'7707263004631','GALEZOL 500 MG * 6 TAB  /D28/','387','TRIDEX FARMACEUTICA','2024-05-31 10:41:01',  22800, 62671, 738, 368),('FVE','FTCL','000735','2024-05-31 10:41:08','052024','CR','1048296497','JHON DAVID','BELTR Aacute N MIRANDA','CALLE 13 NO.8-19',' 3012622598','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','260801','3','20700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:45:04','20700','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,0,20700,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 10:41:08',  100, 44347, 738, 368),('FVE','FTCL','000735','2024-05-31 10:41:08','052024','CR','1048296497','JHON DAVID','BELTR Aacute N MIRANDA','CALLE 13 NO.8-19',' 3012622598','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','260801','3','20700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:45:04','20700','347','BOD. FARMANORTE 347','1','18500','18500','18500','0','18500','1','0','0','','31/05/2024','',0,0,20700,'7707271451410','CYCLOFEMINA 25MG/5MG CJA * 1 AMP','313','NTI (NEW TRADE INTERNATIONAL)','2024-05-31 10:41:08',  17853, 52691, 738, 368),('FVE','FTCL','000735','2024-05-31 10:41:08','052024','CR','1048296497','JHON DAVID','BELTR Aacute N MIRANDA','CALLE 13 NO.8-19',' 3012622598','3402','YUZELLY CAROLINA','RICARDO OROZCO','983','JUAN CARLOS','RAMIREZ BARRIOS','','','','','260801','3','20700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:45:04','20700','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',0,0,20700,'DO','DOMICILIO','00','VARIOS','2024-05-31 10:41:08',  1500, 44348, 738, 368),('FVE','FTCL','000734','2024-05-31 10:42:42','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','1932.7731092436975','367.2268907563025','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 10:42:42','2300','347','BOD. FARMANORTE 347','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','31/05/2024','',2300,0,0,'7702402051361','HELADO CASERO RON CON PASAS *60 GR','296','MEALS DE COLOMBIA','2024-05-31 10:42:42',  1206, 52362, 738, 368),('FVE','FTCL','000736','2024-05-31 11:12:30','052024','CO','26356707','ANGELY ',' CASTRO',' escribir al whats',' 3107080413','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','46000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:12:30','46000','347','BOD. FARMANORTE 347','1','46000','46000','46000','0','46000','1','0','1','4','31/05/2024','',46000,0,0,'7501058626424','KLIM 1+ DESLACTOSADA LATA *800 GR','311','NESTLE NUTRICION','2024-05-31 11:12:30',  42616, 50766, 738, 368),('FVE','FTCL','000737','2024-05-31 11:14:21','052024','CO','1048291539','LEINER','RAMIREZ','',' 1','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','1001228355','1001228355','ROMERO CANTILLO KENIA LORENA','','','1','22600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:14:21','22600','347','BOD. FARMANORTE 347','1','22600','22600','22600','0','22600','1','0','0','','31/05/2024','',22600,0,0,'7703445050014','PANOTIL BETA GOTAS *8 ML ','397','ZAMBON COLOMBIA ','2024-05-31 11:14:21',  18620.7, 44318, 738, 368),('FVE','FTCL','000738','2024-05-31 11:26:55','052024','CO','1048289310','MAYERLIS','RUIZ CADRAZCO ','CALLE 4B1F # 2 SUR 49 MONTECAR',' 3005395487','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','4','32600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:26:55','32600','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','163','','31/05/2024','',0,32600,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 11:26:55',  1500, 44348, 738, 368),('FVE','FTCL','000738','2024-05-31 11:26:55','052024','CO','1048289310','MAYERLIS','RUIZ CADRAZCO ','CALLE 4B1F # 2 SUR 49 MONTECAR',' 3005395487','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','4','32600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:26:55','32600','347','BOD. FARMANORTE 347','1','16200','16200','16200','0','16200','1','0','163','','31/05/2024','',0,32600,0,'7707172685778','DOLEX JARABE 2+ *90 ML ','616','HALEON (GLAXO OTC)','2024-05-31 11:26:55',  8035.7, 26537, 738, 368),('FVE','FTCL','000738','2024-05-31 11:26:55','052024','CO','1048289310','MAYERLIS','RUIZ CADRAZCO ','CALLE 4B1F # 2 SUR 49 MONTECAR',' 3005395487','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','4','32600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:26:55','32600','347','BOD. FARMANORTE 347','1','14200','14200','14200','0','14200','1','0','163','','31/05/2024','',0,32600,0,'7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA *60 ML','616','HALEON (GLAXO OTC)','2024-05-31 11:26:55',  12808.3, 54127, 738, 368),('FVE','FTCL','000738','2024-05-31 11:26:55','052024','CO','1048289310','MAYERLIS','RUIZ CADRAZCO ','CALLE 4B1F # 2 SUR 49 MONTECAR',' 3005395487','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','4','32600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:26:55','32600','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','163','','31/05/2024','',0,32600,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 11:26:55',  100, 44347, 738, 368),('FVE','FTCL','000739','2024-05-31 11:41:52','052024','CO','72095843','IVAN ',' VASQUEZ','calle7#7-54 san jorge ',' 3028566514','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','5','86801.6806722689','2698.319327731091','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:41:52','89500','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,89500,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 11:41:52',  100, 44347, 738, 368),('FVE','FTCL','000739','2024-05-31 11:41:52','052024','CO','72095843','IVAN ',' VASQUEZ','calle7#7-54 san jorge ',' 3028566514','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','5','86801.6806722689','2698.319327731091','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:41:52','89500','347','BOD. FARMANORTE 347','1','27500','27500','27500','0','27500','1','0','0','','31/05/2024','',0,89500,0,'7703712080256','NISTAFAR FCO * 60 ML /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 11:41:52',  18300, 54477, 738, 368),('FVE','FTCL','000739','2024-05-31 11:41:52','052024','CO','72095843','IVAN ',' VASQUEZ','calle7#7-54 san jorge ',' 3028566514','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','5','86801.6806722689','2698.319327731091','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:41:52','89500','347','BOD. FARMANORTE 347','1','16900','16900','14201.680672269','2698.3193277311','16900','1','0','0','','31/05/2024','',0,89500,0,'7707232090757','BIOPRONNABIS CANNABIS SATIVA BARRA LABIAL * 5 GR','271','NATURAL FRESHLY','2024-05-31 11:41:52',  8901.09, 52165, 738, 368),('FVE','FTCL','000739','2024-05-31 11:41:52','052024','CO','72095843','IVAN ',' VASQUEZ','calle7#7-54 san jorge ',' 3028566514','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','5','86801.6806722689','2698.319327731091','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:41:52','89500','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',0,89500,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 11:41:52',  1500, 44348, 738, 368),('FVE','FTCL','000739','2024-05-31 11:41:52','052024','CO','72095843','IVAN ',' VASQUEZ','calle7#7-54 san jorge ',' 3028566514','3402','YUZELLY CAROLINA','RICARDO OROZCO','3895','LUIS ANGEL ','CORONANDO RODRíGUEZ ','','','','','','5','86801.6806722689','2698.319327731091','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:41:52','89500','347','BOD. FARMANORTE 347','1','42900','42900','42900','0','42900','1','0','0','','31/05/2024','',0,89500,0,'7702057013387','MICOFIX *30 ML ','382','TECNOQUIMICAS','2024-05-31 11:41:52',  36622.6, 43136, 738, 368),('FVE','FTCL','000740','2024-05-31 11:59:58','052024','CO','1007970820','YUZELLY CAROLINA','RICARDO OROZCO','CRA 39B NO.6-43',' 3016670567','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','2','9159.66386554622','1740.3361344537816','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:59:58','10900','347','BOD. FARMANORTE 347','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','1','','31/05/2024','',10900,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-31 11:59:58',  3881.5, 56142, 738, 368),('FVE','FTCL','000740','2024-05-31 11:59:58','052024','CO','1007970820','YUZELLY CAROLINA','RICARDO OROZCO','CRA 39B NO.6-43',' 3016670567','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','2','9159.66386554622','1740.3361344537816','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 11:59:58','10900','347','BOD. FARMANORTE 347','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','1','','31/05/2024','',10900,0,0,'7702090038064','JUGO HIT MORA *1 LT','192','POSTOBON GASEOSAS','2024-05-31 11:59:58',  2850.38, 53814, 738, 368),('FVE','FTCL','000741','2024-05-31 12:01:17','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','840.3361344537816','159.6638655462184','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:01:17','1000','347','BOD. FARMANORTE 347','2','500','1000','840.33613445378','159.66386554622','1000','0','2','0','','31/05/2024','',1000,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-31 12:01:17',  9360, 46328, 738, 368),('FVE','FTCL','000742','2024-05-31 12:06:43','052024','CO','1002234909','BRAULIO','MORENO','',' 3042435921','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','30000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:06:43','30000','347','BOD. FARMANORTE 347','1','30000','30000','30000','0','30000','1','0','0','','31/05/2024','',0,30000,0,'7707263004068','GLICERTOX NF JB * 125 ML /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 12:06:43',  20550, 53417, 738, 368),('FVE','FTCL','000743','2024-05-31 12:11:04','052024','CO','1048328563','FARID','SANCHES','',' 00000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','18000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:11:04','18000','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',18000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 12:11:04',  100, 44347, 738, 368),('FVE','FTCL','000743','2024-05-31 12:11:04','052024','CO','1048328563','FARID','SANCHES','',' 00000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','18000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:11:04','18000','347','BOD. FARMANORTE 347','2','8900','17800','17800','0','17800','2','0','0','','31/05/2024','',18000,0,0,'7501125104411','ELECTROLIT COCO SUERO *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-31 12:11:04',  6785, 47206, 738, 368),('FVE','FTCL','000744','2024-05-31 12:36:20','052024','CO','32870715','MILEIDIS','NAVARRO','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','2','14401.680672268909','2698.319327731091','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:36:20','17100','347','BOD. FARMANORTE 347','1','16900','16900','14201.680672269','2698.3193277311','16900','1','0','0','','31/05/2024','',17100,0,0,'650240035401','ASEPXIA JABON CARBON DETOX *100 GR','194','GENOMMA LABORATORIO COLOMBIA','2024-05-31 12:36:20',  12090, 51777, 738, 368),('FVE','FTCL','000744','2024-05-31 12:36:20','052024','CO','32870715','MILEIDIS','NAVARRO','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','2','14401.680672268909','2698.319327731091','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:36:20','17100','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',17100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 12:36:20',  100, 44347, 738, 368),('FVE','FTCL','000745','2024-05-31 12:42:09','052024','CO','1042443573','ANA MARIA','GONZALES ORTEGA','calle 9 #11-55 caracoli malamb',' 3146356520','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','420.1680672268908','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:42:09','500','347','BOD. FARMANORTE 347','1','500','500','420.16806722689','79.831932773109','500','0','1','2','','31/05/2024','',500,0,0,'D1531','TAPABOCAS EMPAQUE INDIVIDUAL *50 UNID','806','COVID19','2024-05-31 12:42:09',  9360, 46328, 738, 368),('FVE','FTCL','000746','2024-05-31 12:54:58','052024','CO','1042349205',' ANTONY VALERA','000','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','6700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:54:58','6700','347','BOD. FARMANORTE 347','1','2900','2900','2900','0','2900','0','1','0','','31/05/2024','',6700,0,0,'7707232099095','ACTIVOX ICE JENGIBRE MASTICABLES * 12 S/S','271','NATURAL FRESHLY','2024-05-31 12:54:58',  17937, 33638, 738, 368),('FVE','FTCL','000746','2024-05-31 12:54:58','052024','CO','1042349205',' ANTONY VALERA','000','',' 1','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','6700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:54:58','6700','347','BOD. FARMANORTE 347','2','1900','3800','3800','0','3800','0','2','0','','31/05/2024','',6700,0,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-31 12:54:58',  131275.53, 43180, 738, 368),('FVE','FTCL','000747','2024-05-31 12:59:16','052024','CO','30319516','MARELIS','PANTOJAS','0',' 3023600556','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','1','16000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 12:59:16','16000','347','BOD. FARMANORTE 347','1','16000','16000','16000','0','16000','1','0','0','','31/05/2024','',16000,0,0,'7707274722715','PROCATEC 500MG *10 TAB (CIPROFLOXACINO)','181','FAES FARMA','2024-05-31 12:59:16',  3174.1, 40629, 738, 368),('FVE','FTCL','000748','2024-05-31 13:12:27','052024','CO','8669458','GEOVANNY ','BERRIO','0','0 0 3222222222','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','49700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:12:27','49700','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',49700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 13:12:27',  100, 44347, 738, 368),('FVE','FTCL','000748','2024-05-31 13:12:27','052024','CO','8669458','GEOVANNY ','BERRIO','0','0 0 3222222222','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','49700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:12:27','49700','347','BOD. FARMANORTE 347','1','26500','26500','26500','0','26500','1','0','0','','31/05/2024','',49700,0,0,'7703712080652','NEPOLDEX GOTAS OFTALMICAS * 5 ML  /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 13:12:27',  22140, 56008, 738, 368),('FVE','FTCL','000748','2024-05-31 13:12:27','052024','CO','8669458','GEOVANNY ','BERRIO','0','0 0 3222222222','3402','YUZELLY CAROLINA','RICARDO OROZCO','','TERCERO','VARIOS','','','','','','3','49700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:12:27','49700','347','BOD. FARMANORTE 347','1','23000','23000','23000','0','23000','1','0','0','','31/05/2024','',49700,0,0,'7707172681114','EMULSION DE SCOTT CEREZA *360 ML','616','HALEON (GLAXO OTC)','2024-05-31 13:12:27',  20008, 26553, 738, 368),('FVE','FTCL','000749','2024-05-31 13:14:17','052024','CO','8669458','GEOVANNY ','BERRIO','0','0 0 3222222222','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','5800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:14:17','5800','347','BOD. FARMANORTE 347','2','2900','5800','5800','0','5800','0','2','0','','31/05/2024','',5800,0,0,'7702057803278','GASTROFAST ADVANCE *10 SACHETS','877','TECNOQUIMICAS VM TQ','2024-05-31 13:14:17',  22029.28, 58051, 738, 368),('FVE','FTCL','000750','2024-05-31 13:15:35','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:15:35','3500','347','BOD. FARMANORTE 347','1','3500','3500','3500','0','3500','0','1','0','','31/05/2024','',3500,0,0,'7702057013585','HIDRAPLUS 75 ZINC CEREZA *4 SOBRES','877','TECNOQUIMICAS VM TQ','2024-05-31 13:15:35',  11512.8, 49428, 738, 368),('FVE','FTCL','000751','2024-05-31 13:17:02','052024','CO','8669458','GEOVANNY ','BERRIO','0','0 0 3222222222','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','11100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:17:03','11100','347','BOD. FARMANORTE 347','1','10100','10100','10100','0','10100','1','0','0','','31/05/2024','',11100,0,0,'7703186028938','PEDIASURE LIQUIDO VAINILLA *220 ML','659','ABBOTT NUTRICION','2024-05-31 13:17:02',  9020, 22283, 738, 368);
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','FTCL','000752','2024-05-31 13:22:15','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','2800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:22:15','2800','347','BOD. FARMANORTE 347','2','1400','2800','2800','0','2800','0','2','0','','31/05/2024','',2800,0,0,'7707019402063','DOSALDIN *20 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-31 13:22:15',  13040, 45886, 738, 368),('FVE','FTCL','000753','2024-05-31 13:28:26','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','1000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:28:26','1000','347','BOD. FARMANORTE 347','1','1000','1000','1000','0','1000','1','0','0','','31/05/2024','',1000,0,0,'7702090037784','AGUA CRISTAL CON GAS BOTELLA *300 ML','192','POSTOBON GASEOSAS','2024-05-31 13:28:26',  583.3333, 52915, 738, 368),('FVE','FTCL','000754','2024-05-31 13:47:49','052024','CO','1043930885','YOUSEP','GARCIA','0',' 3244957555','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','2521.008403361345','478.9915966386552','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 13:47:49','3000','347','BOD. FARMANORTE 347','1','3000','3000','2521.0084033613','478.99159663866','3000','1','0','13','','31/05/2024','',3000,0,0,'7702090036930','GASEOSA COLOMBIANA CERO *1 LT ECONOLITRO','192','POSTOBON GASEOSAS','2024-05-31 13:47:49',  2100.8, 53831, 738, 368),('FVE','FTCL','000755','2024-05-31 14:07:45','052024','CO','32581190','MARIA ELENA','CUETO CAMPO','',' 3045319967','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','2100.840336134454','399.159663865546','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 14:07:46','2500','347','BOD. FARMANORTE 347','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','11','','31/05/2024','',0,2500,0,'7702090051636','NATU MALTA BOTELLA *400 ML','192','POSTOBON GASEOSAS','2024-05-31 14:07:45',  1743.6967, 54760, 738, 368),('FVE','FTCL','000756','2024-05-31 14:31:24','052024','CO','1042443573','ANA MARIA','GONZALES ORTEGA','calle 9 #11-55 caracoli malamb',' 3146356520','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','4000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 14:31:24','4000','347','BOD. FARMANORTE 347','2','2000','4000','4000','0','4000','0','2','20','','31/05/2024','',4000,0,0,'7708152336826','SUREZINC COLAGENO VAINILLA * 36 S/S','1007','SUREZINC','2024-05-31 14:31:24',  25000, 62506, 738, 368),('FVE','FTCL','000757','2024-05-31 14:48:41','052024','CO','32581190','MARIA ELENA','CUETO CAMPO','',' 3045319967','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','8268.90756302521','431.09243697478973','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 14:48:41','8700','347','BOD. FARMANORTE 347','1','1200','1200','1008.4033613445','191.59663865546','1200','1','0','41','','31/05/2024','',8700,0,0,'7702024007203','MORENITAS GALLETA *24 GR','776','NESTLE FOOD & BEVERAGE','2024-05-31 14:48:41',  669, 38407, 738, 368),('FVE','FTCL','000757','2024-05-31 14:48:41','052024','CO','32581190','MARIA ELENA','CUETO CAMPO','',' 3045319967','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','8268.90756302521','431.09243697478973','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 14:48:41','8700','347','BOD. FARMANORTE 347','1','1500','1500','1260.5042016807','239.49579831933','1500','1','0','41','','31/05/2024','',8700,0,0,'7702007224139','GALLETA JET WAFER LIMON *22 GR','816','GRUPO NUTRESA','2024-05-31 14:48:41',  632.1, 60297, 738, 368),('FVE','FTCL','000757','2024-05-31 14:48:41','052024','CO','32581190','MARIA ELENA','CUETO CAMPO','',' 3045319967','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','8268.90756302521','431.09243697478973','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 14:48:41','8700','347','BOD. FARMANORTE 347','1','6000','6000','6000','0','6000','1','0','41','','31/05/2024','',8700,0,0,'7709456424882','AGUA MAS BOTELLON * 4LTS','893','SALUS','2024-05-31 14:48:41',  4050, 61718, 738, 368),('FVE','FTCL','000758','2024-05-31 15:06:31','052024','CO','1042443573','ANA MARIA','GONZALES ORTEGA','calle 9 #11-55 caracoli malamb',' 3146356520','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','45000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:06:31','45000','347','BOD. FARMANORTE 347','1','45000','45000','45000','0','45000','1','0','225','','31/05/2024','',0,45000,0,'7708152336741','SUREZINC TRANSFER KIDS VAINILLA * 400 GR ','1007','SUREZINC','2024-05-31 15:06:31',  16881, 61904, 738, 368),('FVE','FTCL','000759','2024-05-31 15:08:49','052024','CO','1042443573','ANA MARIA','GONZALES ORTEGA','calle 9 #11-55 caracoli malamb',' 3146356520','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','10','3949.5798319327732','750.4201680672268','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:08:50','4700','347','BOD. FARMANORTE 347','10','470','4700','3949.5798319328','750.42016806723','4700','0','10','20','','31/05/2024','',4700,0,0,'7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-05-31 15:08:49',  15435, 56535, 738, 368),('FVE','FTCL','000760','2024-05-31 15:23:30','052024','CO','1045764781','ISDEI','CARRERO','',' 3135027621 3233333333','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','2900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:23:31','2900','347','BOD. FARMANORTE 347','1','2900','2900','2900','0','2900','0','1','0','','31/05/2024','',2900,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-05-31 15:23:30',  18581.4, 46200, 738, 368),('FVE','FTCL','000761','2024-05-31 15:31:32','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','2000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:31:32','2000','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 15:31:32',  800, 48019, 738, 368),('FVE','FTCL','000762','2024-05-31 15:31:33','052024','CR','1048277223','LUIS ANGEL ','CORONANDO RODR iacute GUEZ ','CALLE 4B2 -35 NO.1-89 VILLA ES',' 3017795145','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','603402','2','41324.36974789916','175.63025210084027','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:49:34','41500','347','BOD. FARMANORTE 347','1','40400','40400','40400','0','40400','1','0','0','','31/05/2024','',0,0,41500,'4104480705151','ABRILAR EA 575 JBE *100 ML ','365','MEGALABS','2024-05-31 15:31:33',  34966, 41953, 738, 368),('FVE','FTCL','000762','2024-05-31 15:31:33','052024','CR','1048277223','LUIS ANGEL ','CORONANDO RODR iacute GUEZ ','CALLE 4B2 -35 NO.1-89 VILLA ES',' 3017795145','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','603402','2','41324.36974789916','175.63025210084027','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:49:34','41500','347','BOD. FARMANORTE 347','1','1100','1100','924.36974789916','175.63025210084','1100','1','0','0','','31/05/2024','',0,0,41500,'7702025100156','GALLETA TOSH MIEL *30 GR','816','GRUPO NUTRESA','2024-05-31 15:31:33',  536.1, 37809, 738, 368),('FVE','FTCL','000763','2024-05-31 15:50:44','052024','CO','1044802145','JULIO','PACHECO','',' 3201589621','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3193.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:50:44','3800','347','BOD. FARMANORTE 347','1','3800','3800','3193.2773109244','606.72268907563','3800','1','0','1','','31/05/2024','',3800,0,0,'7702090050974','SPEED MAX *1 LT','192','POSTOBON GASEOSAS','2024-05-31 15:50:44',  2451, 53555, 738, 368),('FVE','FTCL','000764','2024-05-31 15:59:51','052024','CO','1048362598','CARLOS','FIGUEROA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','11','9600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:59:51','9600','347','BOD. FARMANORTE 347','1','7600','7600','7600','0','7600','0','1','0','','31/05/2024','',9600,0,0,'7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-05-31 15:59:51',  63045, 31775, 738, 368),('FVE','FTCL','000764','2024-05-31 15:59:51','052024','CO','1048362598','CARLOS','FIGUEROA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','11','9600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 15:59:51','9600','347','BOD. FARMANORTE 347','10','200','2000','2000','0','2000','0','10','0','','31/05/2024','',9600,0,0,'7702605101146','FUROSEMIDA 40 MG *100 TAB  GENFAR','193','GENFAR','2024-05-31 15:59:51',  16550, 26045, 738, 368),('FVE','FTCL','000765','2024-05-31 16:18:24','052024','CO','1042428165','ANTONIO','PACHECO','',' 1','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','5798.319327731093','1101.680672268907','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:18:24','6900','347','BOD. FARMANORTE 347','1','6900','6900','5798.3193277311','1101.6806722689','6900','1','0','0','','31/05/2024','',6900,0,0,'7702189053848','PAPAS MARGARITA TOMATE *105 GR','762','FRITO LAY','2024-05-31 16:18:24',  4629, 54640, 738, 368),('FVE','FTCL','000766','2024-05-31 16:26:09','052024','CO','22528877','MARIBELL ','DE LA HOZ','',' 0 3000000000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','5865.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:26:09','6600','347','BOD. FARMANORTE 347','1','4600','4600','3865.5462184874','734.45378151261','4600','1','0','0','','31/05/2024','',2000,4600,0,'7702090038088','JUGO HIT NARANJA-PIÑA *1 LT','192','POSTOBON GASEOSAS','2024-05-31 16:26:09',  2422.61, 53888, 738, 368),('FVE','FTCL','000766','2024-05-31 16:26:09','052024','CO','22528877','MARIBELL ','DE LA HOZ','',' 0 3000000000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','5865.546218487395','734.453781512605','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:26:09','6600','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',2000,4600,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 16:26:09',  800, 48019, 738, 368),('FVE','FTCL','000767','2024-05-31 16:37:05','052024','CO','32611509','EVELIN','VILLA','Urbanizaci oacute n las Cameli',' 3182000260','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','75300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:37:05','75300','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',75300,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 16:37:05',  100, 44347, 738, 368),('FVE','FTCL','000767','2024-05-31 16:37:05','052024','CO','32611509','EVELIN','VILLA','Urbanizaci oacute n las Cameli',' 3182000260','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','75300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:37:05','75300','347','BOD. FARMANORTE 347','1','45600','45600','45600','0','45600','1','0','0','','31/05/2024','',75300,0,0,'7896226501833','BACTRIM F *10 TAB','285','SIEGFRIED FARMA','2024-05-31 16:37:05',  46905, 41556, 738, 368),('FVE','FTCL','000767','2024-05-31 16:37:05','052024','CO','32611509','EVELIN','VILLA','Urbanizaci oacute n las Cameli',' 3182000260','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','75300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:37:05','75300','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',75300,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 16:37:05',  1500, 44348, 738, 368),('FVE','FTCL','000767','2024-05-31 16:37:05','052024','CO','32611509','EVELIN','VILLA','Urbanizaci oacute n las Cameli',' 3182000260','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','75300','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:37:05','75300','347','BOD. FARMANORTE 347','1','27500','27500','27500','0','27500','1','0','0','','31/05/2024','',75300,0,0,'7707019381269','CORTIDEXAN 30 MG *10 TAB','130','LABQUIFAR PHARMACEUTICA','2024-05-31 16:37:05',  17170, 45880, 738, 368),('FVE','FTCL','000768','2024-05-31 16:39:15','052024','CO','1048284894',' EDWIN ',' GALLARDO','',' 3028576347','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','12700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:39:15','12700','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',12700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 16:39:15',  100, 44347, 738, 368),('FVE','FTCL','000768','2024-05-31 16:39:15','052024','CO','1048284894',' EDWIN ',' GALLARDO','',' 3028576347','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','12700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 16:39:15','12700','347','BOD. FARMANORTE 347','1','12500','12500','12500','0','12500','1','0','0','5','31/05/2024','',12700,0,0,'7707288821220','ZOPICLONA 7.5 MG * 10 TAB','205','HUMAX PHARMACEUTICAL','2024-05-31 16:39:15',  6550, 27387, 738, 368),('FVE','FTCL','000769','2024-05-31 17:10:48','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','6000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:10:48','6000','347','BOD. FARMANORTE 347','3','2000','6000','6000','0','6000','3','0','0','','31/05/2024','',6000,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 17:10:48',  800, 48019, 738, 368),('FVE','FTCL','000770','2024-05-31 17:12:38','052024','CO','3883138','CARLOS ','GARCIA ','',' 1','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','11','12000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:12:38','12000','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',12000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 17:12:38',  100, 44347, 738, 368),('FVE','FTCL','000770','2024-05-31 17:12:38','052024','CO','3883138','CARLOS ','GARCIA ','',' 1','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','11','12000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:12:38','12000','347','BOD. FARMANORTE 347','10','1180','11800','11800','0','11800','0','10','0','','31/05/2024','',12000,0,0,'7706569022912','ACETAMINOFEN CODEINA 325/30MG *30 TAB','614','A.G. MEDICAMENTOS','2024-05-31 17:12:38',  27808, 49041, 738, 368),('FVE','FTCL','000771','2024-05-31 17:14:34','052024','CO','1140830314','ERNESTO','AMIN','',' 3107140625','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','4285.714285714286','814.2857142857138','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:14:34','5100','347','BOD. FARMANORTE 347','1','5100','5100','4285.7142857143','814.28571428571','5100','1','0','0','','31/05/2024','',5100,0,0,'7702402050234','POLET COOKIES & CREAM *70 GR','296','MEALS DE COLOMBIA','2024-05-31 17:14:34',  2996.6, 49295, 738, 368),('FVE','FTCL','000772','2024-05-31 17:15:52','052024','CO','72044523','JHONYS ','PEREZ','',' 3222222222','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3193.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:15:52','3800','347','BOD. FARMANORTE 347','1','3800','3800','3193.2773109244','606.72268907563','3800','1','0','0','','31/05/2024','',3800,0,0,'7702090050974','SPEED MAX *1 LT','192','POSTOBON GASEOSAS','2024-05-31 17:15:52',  2451, 53555, 738, 368),('FVE','FTCL','000773','2024-05-31 17:21:06','052024','CO','32866251','VERONICA PATRICIA ','BARRIOS VILLAREAL','',' 3013649802 3013649803','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','5242.01680672269','957.9831932773106','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:06','6200','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','26','','31/05/2024','',6200,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 17:21:06',  100, 44347, 738, 368),('FVE','FTCL','000773','2024-05-31 17:21:06','052024','CO','32866251','VERONICA PATRICIA ','BARRIOS VILLAREAL','',' 3013649802 3013649803','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','5242.01680672269','957.9831932773106','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:06','6200','347','BOD. FARMANORTE 347','1','2199.99','2199.99','1848.7394957983','351.26050420168','2200','1','0','26','','31/05/2024','',6200,0,0,'7702018316694','MINORA II PLUS MAQUINA MANGO LARGO','336','PROCTER & GAMBLE COLOMBIA','2024-05-31 17:21:06',  1565.1675, 49261, 738, 368),('FVE','FTCL','000773','2024-05-31 17:21:06','052024','CO','32866251','VERONICA PATRICIA ','BARRIOS VILLAREAL','',' 3013649802 3013649803','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','5242.01680672269','957.9831932773106','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:06','6200','347','BOD. FARMANORTE 347','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','26','','31/05/2024','',6200,0,0,'7622210427076','HALLS BARRA MENTA AZUL *9 PASTILLAS','754','DISCOB NORTE SAS','2024-05-31 17:21:06',  1176.5, 48069, 738, 368),('FVE','FTCL','000773','2024-05-31 17:21:06','052024','CO','32866251','VERONICA PATRICIA ','BARRIOS VILLAREAL','',' 3013649802 3013649803','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','5242.01680672269','957.9831932773106','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:06','6200','347','BOD. FARMANORTE 347','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','26','','31/05/2024','',6200,0,0,'7702133815782','HALLS BARRA YERBABUENA VERDE *9 PASTILLAS','754','DISCOB NORTE SAS','2024-05-31 17:21:06',  1176.5, 55160, 738, 368),('FVE','FTCL','000774','2024-05-31 17:21:23','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','42800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:23','42800','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',0,42800,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 17:21:23',  1500, 44348, 738, 368),('FVE','FTCL','000774','2024-05-31 17:21:23','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','42800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:23','42800','347','BOD. FARMANORTE 347','1','30600','30600','30600','0','30600','1','0','0','','31/05/2024','',0,42800,0,'7702057010201','AFLUX NINOS JBE *75 ML ','877','TECNOQUIMICAS VM TQ','2024-05-31 17:21:23',  26870.1, 42762, 738, 368),('FVE','FTCL','000774','2024-05-31 17:21:23','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','42800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:23','42800','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,42800,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 17:21:23',  100, 44347, 738, 368),('FVE','FTCL','000774','2024-05-31 17:21:23','052024','CO','1048319440','HECTOR','FERRER','Cr 20b # 18 - 30 concord  por ',' 3007284405','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','4','42800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:21:23','42800','347','BOD. FARMANORTE 347','1','10000','10000','10000','0','10000','1','0','0','','31/05/2024','',0,42800,0,'7706569021250','AMITRIPTILINA 25MG *30 TAB','614','A.G. MEDICAMENTOS','2024-05-31 17:21:23',  8730, 31177, 738, 368),('FVE','FTCL','000775','2024-05-31 17:33:21','052024','CO','1019074022','SANDRA PAOLA','REYES BALLESTEROS ','CALLE 11 A 3 # 4SUR-41 BELLAVI',' 3008495769','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1025181','55302272','ANGARITA JIMENEZ GIANNINA ANDREA','','','7','38100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:33:21','38100','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','191','','31/05/2024','',38100,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 17:33:21',  100, 44347, 738, 368);
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','FTCL','000775','2024-05-31 17:33:21','052024','CO','1019074022','SANDRA PAOLA','REYES BALLESTEROS ','CALLE 11 A 3 # 4SUR-41 BELLAVI',' 3008495769','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1025181','55302272','ANGARITA JIMENEZ GIANNINA ANDREA','','','7','38100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:33:21','38100','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','191','','31/05/2024','',38100,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 17:33:21',  1500, 44348, 738, 368),('FVE','FTCL','000775','2024-05-31 17:33:21','052024','CO','1019074022','SANDRA PAOLA','REYES BALLESTEROS ','CALLE 11 A 3 # 4SUR-41 BELLAVI',' 3008495769','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','1025181','55302272','ANGARITA JIMENEZ GIANNINA ANDREA','','','7','38100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:33:21','38100','347','BOD. FARMANORTE 347','4','5600','22400','22400','0','22400','0','4','191','','31/05/2024','',38100,0,0,'7709990568288','DIOSMIT 3GR CAJA *6 SOBRES','313','NTI (NEW TRADE INTERNATIONAL)','2024-05-31 17:33:21',  14100, 54384, 738, 368),('FVE','FTCL','000776','2024-05-31 17:56:52','052024','CO','115913884','JEISON ','SALAMANCA ','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','6000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 17:56:52','6000','347','BOD. FARMANORTE 347','2','3000','6000','6000','0','6000','0','2','0','','31/05/2024','',6000,0,0,'7702626211770','GAVISCON DOBLE ACCION *12 S/S','357','RECKITT BENCKISER COLOMBIA S A','2024-05-31 17:56:52',  27350, 46776, 738, 368),('FVE','FTCL','000777','2024-05-31 18:23:35','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','4','15822.689075630253','1277.3109243697472','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:23:35','17100','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,17100,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 18:23:35',  100, 44347, 738, 368),('FVE','FTCL','000777','2024-05-31 18:23:35','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','4','15822.689075630253','1277.3109243697472','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:23:35','17100','347','BOD. FARMANORTE 347','1','6900','6900','6900','0','6900','1','0','0','','31/05/2024','',0,17100,0,'7702027424113','NOSOTRAS INVISIBLE RAPIGEL * 10 GTS OBSEQUIO','337','FAMILIA SANCELA','2024-05-31 18:23:35',  5635, 51630, 738, 368),('FVE','FTCL','000777','2024-05-31 18:23:35','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','4','15822.689075630253','1277.3109243697472','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:23:35','17100','347','BOD. FARMANORTE 347','1','8000','8000','6722.6890756303','1277.3109243697','8000','1','0','0','','31/05/2024','',0,17100,0,'7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-05-31 18:23:35',  6163, 24467, 738, 368),('FVE','FTCL','000777','2024-05-31 18:23:35','052024','CO','32581430','LENNY','TERAAN','Cra 6A 14 130 bloque 4 casa 7 ',' 0 3002364367','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','4','15822.689075630253','1277.3109243697472','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:23:35','17100','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',0,17100,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 18:23:35',  1500, 44348, 738, 368),('FVE','FTCL','000778','2024-05-31 18:51:36','052024','CO','1002230585','JUAN','PI Ntilde A','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','139900','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:51:36','139900','347','BOD. FARMANORTE 347','1','139900','139900','139900','0','139900','1','0','0','','31/05/2024','',139900,0,0,'7702057010935','CYTIL 200 MG FRASCO *7 TAB ','877','TECNOQUIMICAS VM TQ','2024-05-31 18:51:36',  139300, 42908, 738, 368),('FVE','FTCL','000779','2024-05-31 18:55:31','052024','CO','1006576675','SERGIO','GALVEZ','',' 3025896321','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','7600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:55:31','7600','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',7600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 18:55:31',  100, 44347, 738, 368),('FVE','FTCL','000779','2024-05-31 18:55:31','052024','CO','1006576675','SERGIO','GALVEZ','',' 3025896321','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','7600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:55:31','7600','347','BOD. FARMANORTE 347','3','1800','5400','5400','0','5400','0','3','0','','31/05/2024','',7600,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-31 18:55:31',  111600, 43550, 738, 368),('FVE','FTCL','000779','2024-05-31 18:55:31','052024','CO','1006576675','SERGIO','GALVEZ','',' 3025896321','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','7600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:55:31','7600','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','0','','31/05/2024','',7600,0,0,'7709008052563','AGUA FARMANORTE *600 ML','893','SALUS','2024-05-31 18:55:31',  800, 48019, 738, 368),('FVE','FTCL','000780','2024-05-31 18:58:21','052024','CO','72213431','CESAR ','ARRIETA','','3023896032  3222222222','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','9800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:58:21','9800','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',9800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 18:58:21',  100, 44347, 738, 368),('FVE','FTCL','000780','2024-05-31 18:58:21','052024','CO','72213431','CESAR ','ARRIETA','','3023896032  3222222222','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','9800','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 18:58:21','9800','347','BOD. FARMANORTE 347','1','9600','9600','9600','0','9600','1','0','0','','31/05/2024','',9800,0,0,'7501033957369','PEDIALYTE MAX ZINC 60 MANZANA *500 ML','659','ABBOTT NUTRICION','2024-05-31 18:58:21',  8380, 22277, 738, 368),('FVE','FTCL','000781','2024-05-31 19:13:47','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3109.2436974789916','590.7563025210084','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:13:48','3700','347','BOD. FARMANORTE 347','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','31/05/2024','',3700,0,0,'7702004001917','CERVEZA AGUILA LATA *330 ML','119','BAVARIA S.A.','2024-05-31 19:13:47',  2100.8, 22826, 738, 368),('FVE','FTCL','000782','2024-05-31 19:31:01','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','3645.378151260504','654.6218487394958','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:31:02','4300','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',4300,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 19:31:01',  100, 44347, 738, 368),('FVE','FTCL','000782','2024-05-31 19:31:01','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','3645.378151260504','654.6218487394958','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:31:02','4300','347','BOD. FARMANORTE 347','1','1800','1800','1512.6050420168','287.39495798319','1800','1','0','0','','31/05/2024','',4300,0,0,'7702189057877','CHEETOS HORNEADOS MAXI *40 GR','762','FRITO LAY','2024-05-31 19:31:01',  1159, 60825, 738, 368),('FVE','FTCL','000782','2024-05-31 19:31:01','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','3645.378151260504','654.6218487394958','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:31:02','4300','347','BOD. FARMANORTE 347','1','2300','2300','1932.7731092437','367.2268907563','2300','1','0','0','','31/05/2024','',4300,0,0,'7702090031928','GASEOSA MANZANA POSTOBON *400 ML','192','POSTOBON GASEOSAS','2024-05-31 19:31:01',  1400.8, 40922, 738, 368),('FVE','FTCL','000785','2024-05-31 19:31:02','052024','CR','1044802144','MASIEL ANDREA','DE LA HOZ JIMENEZ','CRA 26C NO.26-98 CONCORD',' 3115841855','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','748866','4','53109.24369747899','590.7563025210084','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:42:06','53700','347','BOD. FARMANORTE 347','1','45000','45000','45000','0','45000','1','0','0','','31/05/2024','',0,0,53700,'7708152336055','SUREZINC ADVANCE FRESA * 400 GR','1007','SUREZINC','2024-05-31 19:31:02',  16881, 62181, 738, 368),('FVE','FTCL','000785','2024-05-31 19:31:02','052024','CR','1044802144','MASIEL ANDREA','DE LA HOZ JIMENEZ','CRA 26C NO.26-98 CONCORD',' 3115841855','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','748866','4','53109.24369747899','590.7563025210084','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:42:06','53700','347','BOD. FARMANORTE 347','2','2500','5000','5000','0','5000','0','2','0','','31/05/2024','',0,0,53700,'7703712080270','OXIFAR 20 MG * 10 CAP /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 19:31:02',  11800, 53835, 738, 368),('FVE','FTCL','000785','2024-05-31 19:31:02','052024','CR','1044802144','MASIEL ANDREA','DE LA HOZ JIMENEZ','CRA 26C NO.26-98 CONCORD',' 3115841855','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','748866','4','53109.24369747899','590.7563025210084','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:42:06','53700','347','BOD. FARMANORTE 347','1','3700','3700','3109.243697479','590.75630252101','3700','1','0','0','','31/05/2024','',0,0,53700,'7702090051827','NATU MALTA BOTELLA *1000 ML','192','POSTOBON GASEOSAS','2024-05-31 19:31:02',  2542, 55375, 738, 368),('FVE','FTCL','000783','2024-05-31 19:37:44','052024','CO','32612391','YASMIN ','VISCAINO','cr9#10-32 por el d1 de la 11 ','0 0 3003974959','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','72500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:37:44','72500','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','363','','31/05/2024','',72500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 19:37:44',  100, 44347, 738, 368),('FVE','FTCL','000783','2024-05-31 19:37:44','052024','CO','32612391','YASMIN ','VISCAINO','cr9#10-32 por el d1 de la 11 ','0 0 3003974959','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','72500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:37:44','72500','347','BOD. FARMANORTE 347','1','72300','72300','72300','0','72300','1','0','363','8','31/05/2024','',72500,0,0,'7891000078969','NESTOGENO 2 *800 GR  ','311','NESTLE NUTRICION','2024-05-31 19:37:44',  66842, 38457, 738, 368),('FVE','FTCL','000784','2024-05-31 19:40:17','052024','CO','1048315730','CLARISSE','YEPEZ','',' 324562918','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','9','16632.7731092437','367.2268907563024','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:40:18','17000','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',0,17000,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 19:40:17',  100, 44347, 738, 368),('FVE','FTCL','000784','2024-05-31 19:40:17','052024','CO','1048315730','CLARISSE','YEPEZ','',' 324562918','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','9','16632.7731092437','367.2268907563024','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:40:18','17000','347','BOD. FARMANORTE 347','4','1300','5200','5200','0','5200','0','4','0','','31/05/2024','',0,17000,0,'7703546031608','CONGESTEX * 60 CAP  L-TR-CAPS','630','NOVAMED OTC','2024-05-31 19:40:17',  67353, 38541, 738, 368),('FVE','FTCL','000784','2024-05-31 19:40:17','052024','CO','1048315730','CLARISSE','YEPEZ','',' 324562918','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','9','16632.7731092437','367.2268907563024','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:40:18','17000','347','BOD. FARMANORTE 347','1','9300','9300','9300','0','9300','1','0','0','','31/05/2024','',0,17000,0,'7702057010874','HIDRAPLUS 75 ZINC CEREZA *400 ML ','877','TECNOQUIMICAS VM TQ','2024-05-31 19:40:17',  8146.8, 46788, 738, 368),('FVE','FTCL','000784','2024-05-31 19:40:17','052024','CO','1048315730','CLARISSE','YEPEZ','',' 324562918','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','9','16632.7731092437','367.2268907563024','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:40:18','17000','347','BOD. FARMANORTE 347','1','1700','1700','1428.5714285714','271.42857142857','1700','1','0','0','','31/05/2024','',0,17000,0,'7702007039856','CHOCOLATINA GOL *31 GR','816','GRUPO NUTRESA','2024-05-31 19:40:17',  921.8333, 53166, 738, 368),('FVE','FTCL','000784','2024-05-31 19:40:17','052024','CO','1048315730','CLARISSE','YEPEZ','',' 324562918','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','9','16632.7731092437','367.2268907563024','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:40:18','17000','347','BOD. FARMANORTE 347','2','300','600','504.20168067227','95.798319327731','600','0','2','0','','31/05/2024','',0,17000,0,'7622210427267','CHICLETS ADAMS MENTA *100 UNID','754','DISCOB NORTE SAS','2024-05-31 19:40:17',  13445.4, 34188, 738, 368),('FVE','FTCL','000786','2024-05-31 19:53:40','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','2605.0420168067226','494.9579831932774','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:53:40','3100','347','BOD. FARMANORTE 347','1','3100','3100','2605.0420168067','494.95798319328','3100','1','0','1','','31/05/2024','',3100,0,0,'7702402056328','GALLETA CON HELADO NAPOLITANO *65 GR','296','MEALS DE COLOMBIA','2024-05-31 19:53:40',  1768.4, 60339, 738, 368),('FVE','FTCL','000787','2024-05-31 19:55:19','052024','CO','72432273','JHON ','RODRIGUEZ','',' 3128815987','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','3277.310924369748','622.6890756302519','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:55:20','3900','347','BOD. FARMANORTE 347','1','2000','2000','1680.6722689076','319.32773109244','2000','1','0','16','','31/05/2024','',3900,0,0,'7500435118026','MINORA CUCHILLA X 5 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-05-31 19:55:19',  1405.7958, 51908, 738, 368),('FVE','FTCL','000787','2024-05-31 19:55:19','052024','CO','72432273','JHON ','RODRIGUEZ','',' 3128815987','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','3277.310924369748','622.6890756302519','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 19:55:20','3900','347','BOD. FARMANORTE 347','1','1900','1900','1596.6386554622','303.36134453782','1900','1','0','16','','31/05/2024','',3900,0,0,'7702090069495','ACQUA POSTOBON MANZANA S/CALORIAS *400 ML','192','POSTOBON GASEOSAS','2024-05-31 19:55:19',  840.4, 60819, 738, 368),('FVE','FTCL','000788','2024-05-31 20:05:11','052024','CO','1235242372','MILAGROS ','URDANETA','calle 4 #6-29 esa es la direcc',' 3006791799 3025625357','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','5','15420.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:05:11','15500','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','77','','31/05/2024','',15500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:05:11',  100, 44347, 738, 368),('FVE','FTCL','000788','2024-05-31 20:05:11','052024','CO','1235242372','MILAGROS ','URDANETA','calle 4 #6-29 esa es la direcc',' 3006791799 3025625357','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','5','15420.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:05:11','15500','347','BOD. FARMANORTE 347','2','6400','12800','12800','0','12800','0','2','77','','31/05/2024','',15500,0,0,'7709990733716','NORIFLAM 75MG/3ML CJA * 6 AMP','698','MED-LINE CONVENIO','2024-05-31 20:05:11',  13050, 48643, 738, 368),('FVE','FTCL','000788','2024-05-31 20:05:11','052024','CO','1235242372','MILAGROS ','URDANETA','calle 4 #6-29 esa es la direcc',' 3006791799 3025625357','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','5','15420.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:05:11','15500','347','BOD. FARMANORTE 347','1','500','500','420.16806722689','79.831932773109','500','1','0','77','','31/05/2024','',15500,0,0,'7707282990274','JERINGA 5ML DESECHABLE  21GX1 1/2 ','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-05-31 20:05:11',  168.46, 58667, 738, 368),('FVE','FTCL','000788','2024-05-31 20:05:11','052024','CO','1235242372','MILAGROS ','URDANETA','calle 4 #6-29 esa es la direcc',' 3006791799 3025625357','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','5','15420.16806722689','79.8319327731092','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:05:11','15500','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','77','','31/05/2024','',15500,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 20:05:11',  1500, 44348, 738, 368),('FVE','FTCL','000789','2024-05-31 20:07:05','052024','CO','1001916040','WENDY ',' DIAS','',' 000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','31000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:07:05','31000','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',31000,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:07:05',  100, 44347, 738, 368),('FVE','FTCL','000789','2024-05-31 20:07:05','052024','CO','1001916040','WENDY ',' DIAS','',' 000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','31000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:07:05','31000','347','BOD. FARMANORTE 347','1','13900','13900','13900','0','13900','1','0','0','','31/05/2024','',31000,0,0,'7703712080065','BENMACIT 4% SUSP *10 ML   /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 20:07:05',  8280, 53778, 738, 368),('FVE','FTCL','000789','2024-05-31 20:07:05','052024','CO','1001916040','WENDY ',' DIAS','',' 000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','31000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:07:05','31000','347','BOD. FARMANORTE 347','1','8000','8000','8000','0','8000','0','1','0','','31/05/2024','',31000,0,0,'3582910009900','ENTEROGERMINA *10 AMP','772','OPELLA (SANOFI OTC)','2024-05-31 20:07:05',  53223.5, 41855, 738, 368),('FVE','FTCL','000789','2024-05-31 20:07:05','052024','CO','1001916040','WENDY ',' DIAS','',' 000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','4','31000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:07:05','31000','347','BOD. FARMANORTE 347','1','8900','8900','8900','0','8900','1','0','0','','31/05/2024','',31000,0,0,'7501125184864','ELECTROLIT MARACUYA *625 ML','780','PISA (SUEROS LIQUIDOS)','2024-05-31 20:07:05',  6610, 54196, 738, 368),('FVE','FTCL','000790','2024-05-31 20:08:21','052024','CO','1042439712','ADRIAN','BARRAZA','Carrera 7a 10b 61 casa amarill',' 3008253898','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','5','9000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:08:22','9000','347','BOD. FARMANORTE 347','5','1800','9000','9000','0','9000','0','5','0','','31/05/2024','',9000,0,0,'7707263003474','GRIPAC * 100 CAP /D20/','387','TRIDEX FARMACEUTICA','2024-05-31 20:08:21',  111600, 43550, 738, 368),('FVE','FTCL','000791','2024-05-31 20:09:53','052024','CO','12539130','CARLOS FERMIN ','VERGARA CASTELLANOS ','BARLOVENTO KRA 50B 9 90 BQUILL',' 3185464993','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','4905.882352941177','894.1176470588234','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:09:53','5800','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',5800,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:09:53',  100, 44347, 738, 368);
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','FTCL','000792','2024-05-31 20:11:17','052024','CO','72048537','ALQUIDEZ ','FLORIAN','1',' 3022419581 3147710217','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','11','8500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:11:17','8500','347','BOD. FARMANORTE 347','10','300','3000','3000','0','3000','0','10','43','','31/05/2024','',8500,0,0,'7703546021005','CRONOFEN 500 MG * 100 TB L-TR-CAPS','630','NOVAMED OTC','2024-05-31 20:11:17',  28997, 54625, 738, 368),('FVE','FTCL','000792','2024-05-31 20:11:17','052024','CO','72048537','ALQUIDEZ ','FLORIAN','1',' 3022419581 3147710217','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','11','8500','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:11:17','8500','347','BOD. FARMANORTE 347','1','5500','5500','5500','0','5500','0','1','43','','31/05/2024','',8500,0,0,'7500435107020','VICK VAPORUB 12 GR *12 LATAS','820','PROCTER & GAMBLE CHC','2024-05-31 20:11:17',  56858, 40253, 738, 368),('FVE','FTCL','000793','2024-05-31 20:12:19','052024','CO','30520983','LZ','RAMIREZ','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','9600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:12:19','9600','347','BOD. FARMANORTE 347','2','4800','9600','9600','0','9600','0','2','0','','31/05/2024','',9600,0,0,'7861073963585','ADORLAN *20 TAB','198','GRUNENTHAL COLOMBIANA','2024-05-31 20:12:19',  40000, 34301, 738, 368),('FVE','FTCL','000794','2024-05-31 20:15:41','052024','CO','1129537704','ENRIQUE','DIAZ','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','2','13700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:15:41','13700','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',13700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:15:41',  100, 44347, 738, 368),('FVE','FTCL','000794','2024-05-31 20:15:41','052024','CO','1129537704','ENRIQUE','DIAZ','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','2','13700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:15:41','13700','347','BOD. FARMANORTE 347','1','13500','13500','13500','0','13500','1','0','0','','31/05/2024','',13700,0,0,'7709530287648','TREEVER OFT * 5 ML','607','QUIRUPOS','2024-05-31 20:15:41',  8900.224, 57222, 738, 368),('FVE','FTCL','000795','2024-05-31 20:19:49','052024','CO','72238653','RAFAEL','PERTUZ','',' 000000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','10536.134453781513','1963.865546218487','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:19:50','12500','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',12500,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:19:49',  100, 44347, 738, 368),('FVE','FTCL','000795','2024-05-31 20:19:49','052024','CO','72238653','RAFAEL','PERTUZ','',' 000000','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','10536.134453781513','1963.865546218487','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:19:50','12500','347','BOD. FARMANORTE 347','1','12300','12300','10336.134453782','1963.8655462185','12300','1','0','0','','31/05/2024','',12500,0,0,'7613033986628','NESTUM TRIGO MIEL *200 GR','311','NESTLE NUTRICION','2024-05-31 20:19:49',  8760, 44821, 738, 368),('FVE','FTCL','000796','2024-05-31 20:25:36','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','4117.64705882353','782.3529411764703','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:25:36','4900','347','BOD. FARMANORTE 347','1','4900','4900','4117.6470588235','782.35294117647','4900','1','0','0','','31/05/2024','',4900,0,0,'7702090029512','GASEOSA MANZANA POSTOBON *1.5 LT ','192','POSTOBON GASEOSAS','2024-05-31 20:25:36',  2800.8, 25808, 738, 368),('FVE','FTCL','000797','2024-05-31 20:27:48','052024','CO','1048165343','CARLOS','MENDOZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','6993.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:27:49','7600','347','BOD. FARMANORTE 347','1','3800','3800','3193.2773109244','606.72268907563','3800','1','0','0','','31/05/2024','',7600,0,0,'7702090050974','SPEED MAX *1 LT','192','POSTOBON GASEOSAS','2024-05-31 20:27:48',  2451, 53555, 738, 368),('FVE','FTCL','000797','2024-05-31 20:27:48','052024','CO','1048165343','CARLOS','MENDOZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','6993.27731092437','606.7226890756301','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:27:49','7600','347','BOD. FARMANORTE 347','2','1900','3800','3800','0','3800','0','2','0','','31/05/2024','',7600,0,0,'7702057168070','NORAVER-P CEREZA *96 TAB','382','TECNOQUIMICAS','2024-05-31 20:27:48',  131275.53, 43180, 738, 368),('FVE','FTCL','000798','2024-05-31 20:32:03','052024','CO','1041895977','UBALDO','PACHECO','0',' 3012390593','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','15700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:32:03','15700','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',15700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:32:03',  100, 44347, 738, 368),('FVE','FTCL','000798','2024-05-31 20:32:03','052024','CO','1041895977','UBALDO','PACHECO','0',' 3012390593','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','15700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:32:03','15700','347','BOD. FARMANORTE 347','1','10000','10000','10000','0','10000','1','0','0','','31/05/2024','',15700,0,0,'7702184020227','CETIRIZINA 5MG/5ML MORA AZUL *60ML','249','ECAR','2024-05-31 20:32:03',  4300, 48351, 738, 368),('FVE','FTCL','000798','2024-05-31 20:32:03','052024','CO','1041895977','UBALDO','PACHECO','0',' 3012390593','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','15700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:32:03','15700','347','BOD. FARMANORTE 347','1','5500','5500','5500','0','5500','1','0','0','','31/05/2024','',15700,0,0,'7706659501174','SUERO FISIOLOGICO X 30 ML','143','COASPHARMA SAS','2024-05-31 20:32:03',  2600, 62018, 738, 368),('FVE','FTCL','000799','2024-05-31 20:33:55','052024','CO','1041895977','UBALDO','PACHECO','0',' 3012390593','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','117700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:33:55','117700','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',117700,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:33:55',  100, 44347, 738, 368),('FVE','FTCL','000799','2024-05-31 20:33:55','052024','CO','1041895977','UBALDO','PACHECO','0',' 3012390593','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','117700','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:33:55','117700','347','BOD. FARMANORTE 347','1','117500','117500','117500','0','117500','1','0','0','','31/05/2024','',117700,0,0,'7501058637901','NESTOGENO 1 *1400 GR','311','NESTLE NUTRICION','2024-05-31 20:33:55',  108463, 57511, 738, 368),('FVE','FTCL','000800','2024-05-31 20:34:53','052024','CO','1048293022','LUIS ','GUERRERO','calle8a#1j-40 san antonio por ',' 3175052603','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','107600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:34:53','107600','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','538','','31/05/2024','',107600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:34:53',  100, 44347, 738, 368),('FVE','FTCL','000800','2024-05-31 20:34:53','052024','CO','1048293022','LUIS ','GUERRERO','calle8a#1j-40 san antonio por ',' 3175052603','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','107600','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:34:53','107600','347','BOD. FARMANORTE 347','1','107400','107400','107400','0','107400','1','0','538','','31/05/2024','',107600,0,0,'7501058637918','NESTOGENO 2 *1400 GR','311','NESTLE NUTRICION','2024-05-31 20:34:53',  99378, 57515, 738, 368),('FVE','FTCL','000801','2024-05-31 20:52:19','052024','CO','22552835','OLGA','JIMENEZ','cra 26 c # 26-98 concord',' 3155200419','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','10','10000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:52:19','10000','347','BOD. FARMANORTE 347','10','1000','10000','10000','0','10000','0','10','1','','31/05/2024','',10000,0,0,'7703712080195','IBUPROFAR 800 MG CJA * 60 TB /D24/','387','TRIDEX FARMACEUTICA','2024-05-31 20:52:19',  40080, 53652, 738, 368),('FVE','FTCL','000802','2024-05-31 20:52:34','052024','CO','1048264710','AYNIS YICETH','MALDONADO PERTUZ','cr1c5  #19-60 villa rica 2',' 0 3028441575','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','3','29400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:52:34','29400','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','147','','31/05/2024','',29400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:52:34',  100, 44347, 738, 368),('FVE','FTCL','000802','2024-05-31 20:52:34','052024','CO','1048264710','AYNIS YICETH','MALDONADO PERTUZ','cr1c5  #19-60 villa rica 2',' 0 3028441575','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','3','29400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:52:34','29400','347','BOD. FARMANORTE 347','1','27200','27200','27200','0','27200','1','0','147','','31/05/2024','',29400,0,0,'7702057104603','CREMA N4 MEDICADA *60 GR','889','TECNOQUIMICAS CONSUMO','2024-05-31 20:52:34',  21573, 42898, 738, 368),('FVE','FTCL','000802','2024-05-31 20:52:34','052024','CO','1048264710','AYNIS YICETH','MALDONADO PERTUZ','cr1c5  #19-60 villa rica 2',' 0 3028441575','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','3790','STIVENT','CAMARGO LOPEZ','','','','','','3','29400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:52:34','29400','347','BOD. FARMANORTE 347','1','2000','2000','2000','0','2000','1','0','147','','31/05/2024','',29400,0,0,'DO','DOMICILIO','00','VARIOS','2024-05-31 20:52:34',  1500, 44348, 738, 368),('FVE','FTCL','000803','2024-05-31 20:59:01','052024','CO','1048276074','LUIS','DIAZ','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','7','16334.453781512606','3065.546218487394','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:59:02','19400','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',19400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 20:59:01',  100, 44347, 738, 368),('FVE','FTCL','000803','2024-05-31 20:59:01','052024','CO','1048276074','LUIS','DIAZ','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','7','16334.453781512606','3065.546218487394','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 20:59:02','19400','347','BOD. FARMANORTE 347','6','3200','19200','16134.453781513','3065.5462184874','19200','6','0','0','','31/05/2024','',19400,0,0,'7702004004932','CERVEZA COSTEÑA BACANA LATA *330 ML','119','BAVARIA S.A.','2024-05-31 20:59:01',  2028, 59067, 738, 368),('FVE','FTCL','000804','2024-05-31 21:02:45','052024','CO','1042453981','GERALDINE ',' GARCIA ','',' 00','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','9100','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:02:45','9100','347','BOD. FARMANORTE 347','1','9100','9100','9100','0','9100','1','0','0','','31/05/2024','',9100,0,0,'7501059276604','NESTOGENO 0-12 MESES BOLSA *135 GR','311','NESTLE NUTRICION','2024-05-31 21:02:45',  8329, 52291, 738, 368),('FVE','FTCL','000805','2024-05-31 21:08:20','052024','CO','1045754576','MAX','GONZALES','0',' 3125476391','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','15200.840336134454','399.159663865546','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:08:21','15600','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',15600,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 21:08:20',  100, 44347, 738, 368),('FVE','FTCL','000805','2024-05-31 21:08:20','052024','CO','1045754576','MAX','GONZALES','0',' 3125476391','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','15200.840336134454','399.159663865546','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:08:21','15600','347','BOD. FARMANORTE 347','1','12900','12900','12900','0','12900','1','0','0','','31/05/2024','',15600,0,0,'7706569001368','FLUCONAZOL 200MG *5 CAP','614','A.G. MEDICAMENTOS','2024-05-31 21:08:20',  10112, 31446, 738, 368),('FVE','FTCL','000805','2024-05-31 21:08:20','052024','CO','1045754576','MAX','GONZALES','0',' 3125476391','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','3','15200.840336134454','399.159663865546','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:08:21','15600','347','BOD. FARMANORTE 347','1','2500','2500','2100.8403361345','399.15966386555','2500','1','0','0','','31/05/2024','',15600,0,0,'7702189055484','NATUCHIPS PLATANO MADURO *38 GR','762','FRITO LAY','2024-05-31 21:08:20',  1449, 56938, 738, 368),('FVE','FTCL','000806','2024-05-31 21:10:07','052024','CO','6564316','CRISTEL','AVILA','',' 3122712737','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','2','22400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:10:07','22400','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',22400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 21:10:07',  100, 44347, 738, 368),('FVE','FTCL','000806','2024-05-31 21:10:07','052024','CO','6564316','CRISTEL','AVILA','',' 3122712737','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','1001811819','1140893144','LOZANO SARMIENTO JAVIER DANIEL','','','2','22400','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:10:07','22400','347','BOD. FARMANORTE 347','1','22200','22200','22200','0','22200','1','0','0','15','31/05/2024','',22400,0,0,'7702418000872,0','CONCOR 5 MG *30 TAB','305','MERCK COLOMBIA FARMA','2024-05-31 21:10:07',  20900, 32908, 738, 368),('FVE','FTCL','000807','2024-05-31 21:12:01','052024','CO','72283162','SAMIR ','RODRIGUEZ','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','5210.084033613445','989.9159663865548','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:12:01','6200','347','BOD. FARMANORTE 347','2','3100','6200','5210.0840336134','989.91596638655','6200','2','0','0','','31/05/2024','',0,6200,0,'7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2024-05-31 21:12:01',  1956.4, 34397, 738, 368),('FVE','FTCL','000808','2024-05-31 21:15:20','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','7','7000','0','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:15:20','7000','347','BOD. FARMANORTE 347','7','1000','7000','7000','0','7000','7','0','0','','31/05/2024','',7000,0,0,'R1001','PAQUETES CONEXRED','692','CONEXRED SA','2024-05-31 21:15:20',  0, 59924, 738, 368),('FVE','FTCL','000809','2024-05-31 21:17:38','052024','CO','22624776','CLAUDIA','MEZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','14394.117647058823','1005.8823529411766','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:17:38','15400','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',15400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 21:17:38',  100, 44347, 738, 368),('FVE','FTCL','000809','2024-05-31 21:17:38','052024','CO','22624776','CLAUDIA','MEZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','14394.117647058823','1005.8823529411766','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:17:38','15400','347','BOD. FARMANORTE 347','10','600','6000','6000','0','6000','0','10','0','','31/05/2024','',15400,0,0,'7703712080379','IBUPROFAR 400 MG CJA * 60 TB','387','TRIDEX FARMACEUTICA','2024-05-31 21:17:38',  9000, 53651, 738, 368),('FVE','FTCL','000809','2024-05-31 21:17:38','052024','CO','22624776','CLAUDIA','MEZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','14394.117647058823','1005.8823529411766','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:17:38','15400','347','BOD. FARMANORTE 347','1','2900','2900','2900','0','2900','0','1','0','','31/05/2024','',15400,0,0,'7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-05-31 21:17:38',  18581.4, 46200, 738, 368),('FVE','FTCL','000809','2024-05-31 21:17:38','052024','CO','22624776','CLAUDIA','MEZA','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','13','14394.117647058823','1005.8823529411766','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:17:38','15400','347','BOD. FARMANORTE 347','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','31/05/2024','',15400,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-31 21:17:38',  3881.5, 56142, 738, 368),('FVE','FTCL','000810','2024-05-31 21:18:58','052024','CO','1041276054','MAROS','POLO','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','7','16334.453781512606','3065.546218487394','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:18:58','19400','347','BOD. FARMANORTE 347','1','200','200','200','0','200','1','0','0','','31/05/2024','',19400,0,0,'BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-05-31 21:18:58',  100, 44347, 738, 368),('FVE','FTCL','000810','2024-05-31 21:18:58','052024','CO','1041276054','MAROS','POLO','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','7','16334.453781512606','3065.546218487394','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:18:58','19400','347','BOD. FARMANORTE 347','6','3200','19200','16134.453781513','3065.5462184874','19200','6','0','0','','31/05/2024','',19400,0,0,'7702004004932','CERVEZA COSTEÑA BACANA LATA *330 ML','119','BAVARIA S.A.','2024-05-31 21:18:58',  2028, 59067, 738, 368),('FVE','FTCL','000811','2024-05-31 21:21:03','052024','CO','1140846244','CRISTIAN ','VILLALOBO','',' 0','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','3025.2100840336134','574.7899159663866','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:21:03','3600','347','BOD. FARMANORTE 347','1','3600','3600','3025.2100840336','574.78991596639','3600','1','0','0','','31/05/2024','',3600,0,0,'7702535009987','POWERADE FRUTAS TROPICALES *500 ML','144','COCA COLA','2024-05-31 21:21:03',  1916.7, 36974, 738, 368),('FVE','FTCL','000812','2024-05-31 21:22:29','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','2','3697.478991596639','702.5210084033611','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:22:29','4400','347','BOD. FARMANORTE 347','2','2200','4400','3697.4789915966','702.52100840336','4400','2','0','0','','31/05/2024','',4400,0,0,'7702090039214','SPEED MAX LATA *269 ML','192','POSTOBON GASEOSAS','2024-05-31 21:22:29',  1050.4, 47478, 738, 368),('FVE','FTCL','000813','2024-05-31 21:25:06','052024','CO','99','CLIENTE ','PUNTO DE VENTA','','#####99 ','3162','MASIEL ANDREA','DE LA HOZ JIMENEZ','','TERCERO','VARIOS','','','','','','1','5294.117647058823','1005.8823529411766','347','FARMANORTE 347','ADMINISTRADOR','2024-05-31 21:25:06','6300','347','BOD. FARMANORTE 347','1','6300','6300','5294.1176470588','1005.8823529412','6300','1','0','0','','31/05/2024','',6300,0,0,'7702535024423','COCA COLA *1.5 LT','144','COCA COLA','2024-05-31 21:25:06',  3881.5, 56142, 738, 368);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '052024' AND DECODBOD='347';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '052024' AND DECODBOD='347';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '052024' AND DECODBOD='347';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '052024' AND DECODBOD='347';
