INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DP1','022186','2025-02-22 08:02:07','022025','CR','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','22222.689075630253','1277.3109243697472','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-24 13:33:48','23500','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','15500','0','15500','1','0','0','','25/02/2025','','0','0','23500','7707321981539','DIHIDROCODEINA 2.42MG/ML *120 ML','205','HUMAX PHARMACEUTICAL','2025-02-22 08:02:07',  7819, 49898, 2, 19, 8278786)
			   ,('FVE','DP1','022186','2025-02-22 08:02:07','022025','CR','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','22222.689075630253','1277.3109243697472','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-24 13:33:48','23500','50','DEPOSITO CUCUTA ','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','0','','25/02/2025','','0','0','23500','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-22 08:02:07',  6163, 24467, 2, 19, 8278786)
			   ,('FVE','DP1','022180','2025-02-22 09:19:48','022025','CR','700228873-2','ROSA JOSEFINA ','SIRA ','CALLE 20 AN 2 145 PRADOS NORTE',' 3178709832','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' AUXFINANZAS2 Autoriza la Venta por Cupo. February 22, 2025, 9:20 am','','2','732100.8403361345','139099.15966386546','00','DEPOSITO CUCUTA','AUXFINANZAS2','2025-02-22 09:21:19','871200','50','DEPOSITO CUCUTA ','1','871200.00000000','871200.00000000','732100.84033613','139099.15966387','871200','1','0','0','','22/02/2025','','0','0','871200','D2006','ARRIENDO MES DE ABRIL 2025','00','VARIOS','2025-02-22 09:19:48',  0, 65623, 2, 19, 8279200)
			   ,('FVE','DP1','022181','2025-02-22 09:22:55','022025','CR','1036392280-9','ELVIA ROSA','HERNANDEZ VALENCIA ','CARRERA 66 51 99',' 3042928000','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' AUXFINANZAS2 Autoriza la Venta por Cupo. February 22, 2025, 9:25 am','','2','420168.06722689077','79831.93277310923','00','DEPOSITO CUCUTA','AUXFINANZAS2','2025-02-22 09:44:45','500000','50','DEPOSITO CUCUTA ','1','500000.00000000','500000.00000000','420168.06722689','79831.932773109','500000','1','0','0','','22/02/2025','','0','0','500000','D1994','ARRIENDO MARZO 2025','00','VARIOS','2025-02-22 09:22:55',  0, 65385, 2, 19, 8279217)
			   ,('FVE','DB1','002082','2025-02-22 11:24:06','022025','CR','1129532465','JESUS CAMILO','GARCIA GUTIERREZ','CALLE 136 NO.9-160 MANZANA 2 T',' 3044141920','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','66571.42857142857','3328.571428571435','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-22 11:34:56','69900','DB','DEPOSITO BARRANQUILLA','1','69900.00000000','69900.00000000','66571.428571429','3328.5714285714','69900','1','0','0','','22/02/2025','','0','0','69900','7702049100620','RON MEDELLIN 3 AÑOS * 1 LT','808','ANTIOQUIA AGUARDIENTE','2025-02-22 11:24:06',  58152, 53942, 119, 53, 8280151)
			   ,('FVE','DB2','003991','2025-02-22 12:02:26','022025','CR','1095955840','GEYSON ANDR eacute S ','CELIS RINC oacute N ','CALLE 57 NO.22C-130 CARRIZAL C',' 3163185278','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','30869.747899159665','5865.252100840335','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-02-22 12:19:59','36735','DBU','DEPOSITO BUCARAMANGA','1','36735.00000000','36735.00000000','30869.74789916','5865.2521008403','36735','1','0','0','','22/02/2025','','0','0','36735','7702113043259','TANGA BLOQ SPF 50 CREMA *130ML','278','RECAMIER','2025-02-22 12:02:26',  24482.7224, 61925, 426, 249, 8280422)
			   ,('FVE','DB2','003994','2025-02-22 12:48:04','022025','CR','1010065677','BAYRON STEVEN ','VELASCO SANABRIA ','CRA 18 NO.56-51',' 3187738179','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','1764.7058823529412','335.2941176470588','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-22 12:55:38','2100','DBU','DEPOSITO BUCARAMANGA','1','2100.00000000','2100.00000000','1764.7058823529','335.29411764706','2100','1','0','0','','22/02/2025','','0','0','2100','7702024034186','COCOSETTE MAXI WAFER * 46 GR','776','NESTLE FOOD & BEVERAGE','2025-02-22 12:48:04',  1091, 38319, 426, 249, 8280714)
			   ,('FVE','DP1','022182','2025-02-22 12:51:53','022025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','20000','3800','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-22 12:55:38','23800','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','0','','22/02/2025','','0','0','23800','4005900915795','NIVEA AGUA MICELAR AGUA DE ROSAS * 100 ML ','123','BDF (BEIERSDORF) ','2025-02-22 12:51:53',  10702, 64281, 2, 19, 8280734)
			   ,('FVE','DP1','022182','2025-02-22 12:51:53','022025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','20000','3800','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-22 12:55:38','23800','50','DEPOSITO CUCUTA ','1','8300.00000000','8300.00000000','6974.7899159664','1325.2100840336','8300','1','0','0','','22/02/2025','','0','0','23800','7702026032142','POMYS RUEDITAS DESMAQUILLADORAS * 60 UND','337','FAMILIA SANCELA','2025-02-22 12:51:53',  5776.2, 40372, 2, 19, 8280734)
			   ,('FVE','DB2','003995','2025-02-22 13:44:46','022025','CR','1193443657','JOHAN SEBASTI aacute N','ORD oacute  ntilde EZ BECERRA ','CALLE 3 NO.14-21 CECI',' 3104810150','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','15505.042016806723','2394.957983193277','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-24 16:12:50','17900','DBU','DEPOSITO BUCARAMANGA','1','15000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','1','0','0','','25/02/2025','','0','0','17900','7702006301480','PONDS LIMPIADOR FACIAL DIARIO *50 GR','388','UNILEVER ANDINA COLOMBIA','2025-02-22 13:44:46',  9621, 62641, 426, 249, 8280955)
			   ,('FVE','DB2','003995','2025-02-22 13:44:46','022025','CR','1193443657','JOHAN SEBASTI aacute N','ORD oacute  ntilde EZ BECERRA ','CALLE 3 NO.14-21 CECI',' 3104810150','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','15505.042016806723','2394.957983193277','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-24 16:12:50','17900','DBU','DEPOSITO BUCARAMANGA','1','2900.00000000','2900.00000000','2900','0','2900','1','0','0','','25/02/2025','','0','0','17900','7702560000362','ALGODON JGB * 25 GR','219','JGB','2025-02-22 13:44:46',  1962, 27772, 426, 249, 8280955)
			   ,('FVE','DP1','022183','2025-02-24 07:37:48','022025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','5400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-24 08:04:20','5400','50','DEPOSITO CUCUTA ','1','2700.00000000','2700.00000000','2700','0','2700','0','1','0','','25/02/2025','','0','0','5400','7707232098081','MIELTERTOS GRIPA DIA PANELA - NARANJA * 24 SOBRES','271','NATURAL FRESHLY','2025-02-24 07:37:48',  34469.30619, 33334, 2, 19, 8284351)
			   ,('FVE','DP1','022183','2025-02-24 07:37:48','022025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','5400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-24 08:04:20','5400','50','DEPOSITO CUCUTA ','1','2700.00000000','2700.00000000','2700','0','2700','0','1','0','','25/02/2025','','0','0','5400','7707232098074','MIELTERTOS GRIPA NOCHE PANELA-LIMON *24 S/S','271','NATURAL FRESHLY','2025-02-24 07:37:48',  34469.30619, 25785, 2, 19, 8284351)
			   ,('FVE','DP1','022184','2025-02-24 08:18:31','022025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','16800','0','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-24 08:25:31','16800','50','DEPOSITO CUCUTA ','6','2800.00000000','16800.00000000','16800','0','16800','0','6','0','','25/02/2025','','0','0','16800','7702870071502','LUMBAL FORTE CJA *36 TAB','633','ABBOTT CONSUMER HEALTH CARE','2025-02-24 08:18:31',  41501, 37241, 2, 19, 8284741)
			   ,('FVE','DB2','004002','2025-02-24 08:55:43','022025','CR','1096064470','CAMILO ANDRES','MU ntilde OZ PABON ','',' 3158373232','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','14163.865546218487','1836.134453781513','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-02-27 07:10:56','16000','DBU','DEPOSITO BUCARAMANGA','1','4500.00000000','4500.00000000','4500','0','4500','1','0','0','','27/02/2025','','0','0','16000','7709478324955','DIPIRONA SODICA 1GR/2ML *1 AMP','701','VITALIS COMERCIAL','2025-02-24 08:55:43',  2392, 54744, 426, 249, 8285061)
			   ,('FVE','DB2','004002','2025-02-24 08:55:43','022025','CR','1096064470','CAMILO ANDRES','MU ntilde OZ PABON ','',' 3158373232','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','14163.865546218487','1836.134453781513','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-02-27 07:10:56','16000','DBU','DEPOSITO BUCARAMANGA','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','27/02/2025','','0','0','16000','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-24 08:55:43',  8027, 49624, 426, 249, 8285061)
			   ,('FVE','DP1','022185','2025-02-24 09:06:58','022025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','3613.4453781512607','686.5546218487393','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-24 09:10:02','4300','50','DEPOSITO CUCUTA ','1','4300.00000000','4300.00000000','3613.4453781513','686.55462184874','4300','1','0','1','','25/02/2025','','4300','0','0','7891000248768','KITKAT *41.5 GR','776','NESTLE FOOD & BEVERAGE','2025-02-24 09:06:58',  2926, 60774, 2, 19, 8285162)
			   ,('FVE','DP1','022187','2025-02-24 13:59:40','022025','CR','1005064699','SAMUEL JOSUE','SOLANO ROJAS','AVENIDA 0 NO.3-330 BOCONO',' 3224552356','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','16722.689075630253','3177.3109243697463','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 14:29:43','19900','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','25/02/2025','','0','0','19900','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-24 13:59:40',  3253, 40145, 2, 19, 8287203)
			   ,('FVE','DP1','022187','2025-02-24 13:59:40','022025','CR','1005064699','SAMUEL JOSUE','SOLANO ROJAS','AVENIDA 0 NO.3-330 BOCONO',' 3224552356','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','16722.689075630253','3177.3109243697463','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 14:29:43','19900','50','DEPOSITO CUCUTA ','1','14900.00000000','14900.00000000','12521.008403361','2378.9915966387','14900','1','0','0','','25/02/2025','','0','0','19900','7509546653532','COLGATE CREMA DENTAL TOTAL12 ANTI SARRO *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-24 13:59:40',  10407, 56561, 2, 19, 8287203)
			   ,('FVE','DB2','003996','2025-02-24 17:01:26','022025','CR','1097781524','JOHAN NICOL aacute S ','FLOREZ ROJAS','MANZANA C CASA 17, BARILOCHE 1',' 3244170946','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','10400','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-24 17:04:37','10400','DBU','DEPOSITO BUCARAMANGA','1','10400.00000000','10400.00000000','10400','0','10400','1','0','0','','25/02/2025','','0','0','10400','7707228365753','ESPARADRAPO TELA BLANCO ALFASAFE 2 X 5 YD','429','ALFA SAFE','2025-02-24 17:01:26',  5956.6615, 58647, 426, 249, 8288663)
			   ,('FVE','DP1','022188','2025-02-24 17:14:41','022025','CO','1004924037','KAROL ALEJANDRA ','JAIMES HERNANDEZ','CALLE 6N NO.12-71 ANTONIO NARI',' 3203610879','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','30000','0','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 17:14:41','30000','50','DEPOSITO CUCUTA ','1','30000.00000000','30000.00000000','30000','0','30000','1','0','1','','25/02/2025','','0','30000','0','7703234100401','HELMINTREL SUSP *15 ML','128','BIOCHEM FARMA','2025-02-24 17:14:41',  28500, 23508, 2, 19, 8288688)
			   ,('FVE','DP1','022189','2025-02-24 17:15:27','022025','CR','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','23','23484.03361344538','1915.9663865546208','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 17:18:27','25400','50','DEPOSITO CUCUTA ','1','6500.00000000','6500.00000000','6500','0','6500','1','0','0','','25/02/2025','','0','0','25400','7702184020258','CLORFENIRAMINA JBE * 120 ML','249','ECAR','2025-02-24 17:15:27',  3072, 48626, 2, 19, 8288774)
			   ,('FVE','DP1','022189','2025-02-24 17:15:27','022025','CR','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','23','23484.03361344538','1915.9663865546208','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 17:18:27','25400','50','DEPOSITO CUCUTA ','1','6900.00000000','6900.00000000','6900','0','6900','1','0','0','','25/02/2025','','0','0','25400','7706569000415','LORATADINA 10MG *20 TAB','614','A.G. MEDICAMENTOS','2025-02-24 17:15:27',  2537, 31562, 2, 19, 8288774)
			   ,('FVE','DP1','022189','2025-02-24 17:15:27','022025','CR','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','23','23484.03361344538','1915.9663865546208','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 17:18:27','25400','50','DEPOSITO CUCUTA ','20','600.00000000','12000.00000000','10084.033613445','1915.9663865546','12000','0','20','0','','25/02/2025','','0','0','25400','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2025-02-24 17:15:27',  15763, 56535, 2, 19, 8288774)
			   ,('FVE','DP1','022190','2025-02-24 17:22:57','022025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','4033.6134453781515','766.3865546218484','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 17:22:57','4800','50','DEPOSITO CUCUTA ','2','400.00000000','800.00000000','672.26890756303','127.73109243697','800','0','2','1','','25/02/2025','','4800','0','0','D1649','RECOLECTOR COPROLOGICO BOLSA *25 UND','402','PARACLINICAS','2025-02-24 17:22:57',  4250, 60601, 2, 19, 8288796)
			   ,('FVE','DP1','022190','2025-02-24 17:22:57','022025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','4033.6134453781515','766.3865546218484','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-24 17:22:57','4800','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','1','','25/02/2025','','4800','0','0','7702277865964','TOALLITAS ARRURRU AVENA Y KARITE * 20 UND','124','BELLEZA EXPRESS SA','2025-02-24 17:22:57',  2006, 54335, 2, 19, 8288796)
			   ,('FVE','DP1','022191','2025-02-25 07:48:55','022025','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','15500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 07:55:20','15500','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','15500','0','15500','1','0','1','','25/02/2025','','15500','0','0','7707321981539','DIHIDROCODEINA 2.42MG/ML *120 ML','205','HUMAX PHARMACEUTICAL','2025-02-25 07:48:55',  7819, 49898, 2, 19, 8290233)
			   ,('FVE','DP1','022192','2025-02-25 07:52:32','022025','CR','1090507448','KAREN PAOLA','PADUA ASCANIO','AVENIDA 15 CALLE 12 BELISARIO ',' 3228296015','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','4369.7478991596645','830.2521008403355','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 07:55:20','5200','50','DEPOSITO CUCUTA ','2','2600.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','2','0','0','','25/02/2025','','0','0','5200','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-02-25 07:52:32',  1613.7, 52184, 2, 19, 8290256)
			   ,('FVE','DB1','002083','2025-02-25 10:21:31','022025','CO','1043116013','ARNOVIS ','QUINTERO TONCEL ','CALLE 28 NO.143B-93 VILLA SAN ',' 3044761332','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','75000','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-25 10:27:02','75000','DB','DEPOSITO BARRANQUILLA','1','75000.00000000','75000.00000000','75000','0','75000','1','0','1','','25/02/2025','','0','75000','0','5099864016987','SIMILAC 1 5HMOS *350 GR','659','ABBOTT NUTRICION','2025-02-25 10:21:31',  68940, 61909, 119, 53, 8291608)
			   ,('FVE','DP1','022194','2025-02-25 16:42:42','022025','CR','1090450152','ELIETH','SANCHEZ MEDINA','AV 2 MZ 8 LT 16 # 0-38 LOS ALM',' 3125910187','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','10100','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 16:45:45','10100','50','DEPOSITO CUCUTA ','1','10100.00000000','10100.00000000','10100','0','10100','1','0','0','','25/02/2025','','0','0','10100','7709990305098','CLORHEXIDINA 4% JABON ANTIBACTERIAL * 120 ML','717','ALFAMEDICAL','2025-02-25 16:42:42',  6935, 54066, 2, 19, 8294618)
			   ,('FVE','DB2','004001','2025-02-25 16:44:25','022025','CR','1095955906','JHON NICOLS ','SANDOVAL SILVA','CRA 16A NO.14B-12 BARRIO LOS B',' 3106986853','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','47100','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-26 16:58:35','47100','DBU','DEPOSITO BUCARAMANGA','1','47100.00000000','47100.00000000','47100','0','47100','1','0','0','','26/02/2025','','0','0','47100','7501298217536','NEUROBION * 3 AMP  ','820','PROCTER & GAMBLE CHC','2025-02-25 16:44:25',  27819, 32979, 426, 249, 8294634)
			   ,('FVE','DP1','022193','2025-02-25 16:45:13','022025','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','18500','0','00','DEPOSITO CUCUTA','A.PLATA ','2025-02-25 16:45:13','18500','50','DEPOSITO CUCUTA ','1','18500.00000000','18500.00000000','18500','0','18500','1','0','1','','25/02/2025','','18500','0','0','7706309000262','NAFAZOL ADULT GOTAS * 15 ML ','260','INCOBRA FARMA','2025-02-25 16:45:13',  17528, 29913, 2, 19, 8288889)
			   ,('FVE','DB2','003997','2025-02-25 16:50:59','022025','CR','1007676712','JOHAN FERNANDO ','VERGEL FEREZ ','MANZANA 0 CASA 15 PISO 3 MIRAD',' 3106570475','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','2773.109243697479','526.8907563025209','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-25 16:56:13','3300','DBU','DEPOSITO BUCARAMANGA','1','3300.00000000','3300.00000000','2773.1092436975','526.89075630252','3300','1','0','0','','25/02/2025','','0','0','3300','7702645200250','BALSAMO TRANQUILO ONZA','263','LEON','2025-02-25 16:50:59',  2100.8, 45490, 426, 249, 8294707)
			   ,('FVE','DP1','022195','2025-02-25 17:12:34','022025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','6386.55462184874','1213.4453781512598','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 17:21:50','7600','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','25/02/2025','','7600','0','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-25 17:12:34',  3253, 40145, 2, 19, 8294864)
			   ,('FVE','DP1','022195','2025-02-25 17:12:34','022025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','6386.55462184874','1213.4453781512598','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 17:21:50','7600','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','0','','25/02/2025','','7600','0','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-02-25 17:12:34',  1613.7, 52184, 2, 19, 8294864)
			   ,('FVE','DP1','022196','2025-02-25 17:14:04','022025','CR','1127066591','JUSTO ANDERSSON ','PALENCIA RINC oacute N ','KDXB 84 MONTEVIDEO',' 3506172741','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','11','5042.01680672269','957.9831932773104','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 17:21:50','6000','50','DEPOSITO CUCUTA ','10','600.00000000','6000.00000000','5042.0168067227','957.98319327731','6000','0','10','0','','25/02/2025','','0','0','6000','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2025-02-25 17:14:04',  15763, 56535, 2, 19, 8294957)
			   ,('FVE','DP1','022197','2025-02-25 17:32:22','022025','CO','1092033205','KLEIVER ALFONSO','RODRIGUEZ GARCIA','URBANIZACION MONACO CALLE 2 NO',' 3227518613','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','15500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 17:32:22','15500','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','15500','0','15500','1','0','1','','25/02/2025','','0','15500','0','7707321981539','DIHIDROCODEINA 2.42MG/ML *120 ML','205','HUMAX PHARMACEUTICAL','2025-02-25 17:32:22',  7819, 49898, 2, 19, 8295081)
			   ,('FVE','DP1','022198','2025-02-25 17:47:06','022025','CO','1093785231','YELITZA KATHERINE','SILVA CONTRERAS','CALLE 3 NO.1-37 SAN MATEO','5845734 3115081821','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','17058.823529411766','3241.176470588234','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 17:49:02','20300','50','DEPOSITO CUCUTA ','1','20300.00000000','20300.00000000','17058.823529412','3241.1764705882','20300','1','0','1','','25/02/2025','','20300','0','0','7613034027610','NESTUM TRIGO MIEL *350 GR','311','NESTLE NUTRICION','2025-02-25 17:47:06',  14240, 38465, 2, 19, 8295248)
			   ,('FVE','DP1','022199','2025-02-25 17:48:37','022025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','47100','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 17:48:37','47100','50','DEPOSITO CUCUTA ','1','47100.00000000','47100.00000000','47100','0','47100','1','0','1','','25/02/2025','','47100','0','0','7501298217536','NEUROBION * 3 AMP  ','820','PROCTER & GAMBLE CHC','2025-02-25 17:48:37',  27819, 32979, 2, 19, 8295125)
			   ,('FVE','DP1','022200','2025-02-25 18:19:50','022025','CR','1093751562','DIEGO ALEXANDER','NI ntilde O CASTILLO','CL 15A # 8-70 TIERRA LINDA LOS','5553105 3132555071','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','37500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-25 18:41:16','37500','50','DEPOSITO CUCUTA ','1','37500.00000000','37500.00000000','37500','0','37500','1','0','0','','26/02/2025','','0','0','37500','7702870940549','BELLANEW 1.5MG/2MG *28 TAB','619','ABBOTT FARMA','2025-02-25 18:19:50',  32727.5, 54895, 2, 19, 8295511)
				  ,('FVE','DB2','003998','2025-02-26 08:58:20','022025','CR','860001697-8','GASEOSAS LUX ','SAS','CL 52 47 42 ANTIOQUIA',' 5765122','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. February 26, 2025, 9:05 am','','4','3380000','642200','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-02-26 09:11:12','4022200','DBU','DEPOSITO BUCARAMANGA','1','4022200.00000000','4022200.00000000','3380000','642200','4022200','1','0','0','','26/02/2025','','0','0','4022200','PCRE0405','EXHIBICIONES 4Q 2024','00','VARIOS','2025-02-26 08:58:20',  0, 50141, 426, 249, 8296991);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DP1','022201','2025-02-26 10:02:51','022025','CO','1092526785','OSCAR ANDRES','LIZCANO CLARO','AVENIDA 2 NO.4-71 LA VICTORIA',' 3212392812','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','13','10642.01680672269','957.9831932773104','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 10:02:51','11600','50','DEPOSITO CUCUTA ','2','2800.00000000','5600.00000000','5600','0','5600','0','2','1','','26/02/2025','','11600','0','0','7707232099095','ACTIVOX ICE JENGIBRE MASTICABLES * 12 S/S','271','NATURAL FRESHLY','2025-02-26 10:02:51',  17054, 33638, 2, 19, 8297190)
			   ,('FVE','DP1','022201','2025-02-26 10:02:51','022025','CO','1092526785','OSCAR ANDRES','LIZCANO CLARO','AVENIDA 2 NO.4-71 LA VICTORIA',' 3212392812','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','13','10642.01680672269','957.9831932773104','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 10:02:51','11600','50','DEPOSITO CUCUTA ','10','600.00000000','6000.00000000','5042.0168067227','957.98319327731','6000','0','10','1','','26/02/2025','','11600','0','0','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2025-02-26 10:02:51',  15763, 56535, 2, 19, 8297190)
			   ,('FVE','DP1','022202','2025-02-26 10:03:02','022025','CR','1004842741','ANGEL GABRIELA ','CONTRERAS RIA Ntilde O','CALLE 3 NO.1-37 SAN MATEO PART',' 3202279289','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','9605.042016806723','1824.957983193277','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 10:13:33','11430','50','DEPOSITO CUCUTA ','1','11430.00000000','11430.00000000','9605.0420168067','1824.9579831933','11430','1','0','0','','26/02/2025','','0','0','11430','7702277152347','TOALLITAS ARRURRU ALOE Y MANZANILLA *120 UND ','124','BELLEZA EXPRESS SA','2025-02-26 10:03:02',  7004, 55329, 2, 19, 8297399)
			   ,('FVE','DP1','022203','2025-02-26 10:13:40','022025','CR','1090516234','KEILA','CARRILLO PARRA ','CALLE 9 AVENIDA 19 NO.16 NUEVO',' 3138620788','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','41449.57983193277','7875.420168067223','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 10:27:40','49325','50','DEPOSITO CUCUTA ','2','18900.00000000','37800.00000000','31764.705882353','6035.2941176471','37800','2','0','0','','26/02/2025','','0','0','49325','7702031905240','NEUTROGENA JABON ORIGINAL BARRA *80 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-02-26 10:13:40',  11848.965, 53762, 2, 19, 8297441)
			   ,('FVE','DP1','022203','2025-02-26 10:13:40','022025','CR','1090516234','KEILA','CARRILLO PARRA ','CALLE 9 AVENIDA 19 NO.16 NUEVO',' 3138620788','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','41449.57983193277','7875.420168067223','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 10:27:40','49325','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','0','','26/02/2025','','0','0','49325','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-02-26 10:13:40',  1613.7, 52184, 2, 19, 8297441)
			   ,('FVE','DP1','022203','2025-02-26 10:13:40','022025','CR','1090516234','KEILA','CARRILLO PARRA ','CALLE 9 AVENIDA 19 NO.16 NUEVO',' 3138620788','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','41449.57983193277','7875.420168067223','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 10:27:40','49325','50','DEPOSITO CUCUTA ','1','8925.00000000','8925.00000000','7500','1425','8925','1','0','0','','26/02/2025','','0','0','49325','7702277395256','TOALLITAS ARRURRU AVENA Y KARITE *100 UND ','124','BELLEZA EXPRESS SA','2025-02-26 10:13:40',  5788.5, 55332, 2, 19, 8297441)
			   ,('FVE','DB2','004000','2025-02-26 13:11:25','022025','CR','1097781524','JOHAN NICOL aacute S ','FLOREZ ROJAS','MANZANA C CASA 17, BARILOCHE 1',' 3244170946','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','10840.336134453783','2059.6638655462175','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-26 16:57:03','12900','DBU','DEPOSITO BUCARAMANGA','1','12900.00000000','12900.00000000','10840.336134454','2059.6638655462','12900','1','0','0','','26/02/2025','','0','0','12900','7702560045790','SEDA DENTAL FLUOCARDENT LIMPIEZA MAX * 35 MET LLEVE 60 MET','219','JGB','2025-02-26 13:11:25',  8858, 59692, 426, 249, 8298386)
			   ,('FVE','DP1','022204','2025-02-26 15:21:28','022025','CR','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','58306.72268907563','3193.277310924369','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 15:29:36','61500','50','DEPOSITO CUCUTA ','1','3700.00000000','3700.00000000','3109.243697479','590.75630252101','3700','1','0','0','','26/02/2025','','0','0','61500','7702006298940','EGO GEL FOR MEN ATTRACTION *110 ML','388','UNILEVER ANDINA COLOMBIA','2025-02-26 15:21:28',  2543, 54210, 2, 19, 8299160)
			   ,('FVE','DP1','022204','2025-02-26 15:21:28','022025','CR','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','58306.72268907563','3193.277310924369','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 15:29:36','61500','50','DEPOSITO CUCUTA ','1','6700.00000000','6700.00000000','5630.2521008403','1069.7478991597','6700','1','0','0','','26/02/2025','','0','0','61500','7898422746759','DOVE JABON ORIGINAL *90 GR ','388','UNILEVER ANDINA COLOMBIA','2025-02-26 15:21:28',  4795, 43836, 2, 19, 8299160)
			   ,('FVE','DP1','022204','2025-02-26 15:21:28','022025','CR','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','58306.72268907563','3193.277310924369','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 15:29:36','61500','50','DEPOSITO CUCUTA ','1','9600.00000000','9600.00000000','8067.2268907563','1532.7731092437','9600','1','0','0','','26/02/2025','','0','0','61500','7509546007083','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-26 15:21:28',  6823, 24472, 2, 19, 8299160)
			   ,('FVE','DP1','022204','2025-02-26 15:21:28','022025','CR','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','58306.72268907563','3193.277310924369','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 15:29:36','61500','50','DEPOSITO CUCUTA ','1','41500.00000000','41500.00000000','41500','0','41500','1','0','0','','26/02/2025','','0','0','61500','8850769023589','AVARIN * 10 CAP','802','MEGA WE CARE','2025-02-26 15:21:28',  24239, 60656, 2, 19, 8299160)
			   ,('FVE','DB2','003999','2025-02-26 16:54:06','022025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','8319.327731092439','1580.6722689075623','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-26 16:56:41','9900','DBU','DEPOSITO BUCARAMANGA','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','0','','26/02/2025','','0','0','9900','7702010420955','PROTEX JABON AVENA *110 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-26 16:54:06',  2836, 52613, 426, 249, 8299917)
			   ,('FVE','DB2','003999','2025-02-26 16:54:06','022025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','8319.327731092439','1580.6722689075623','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-26 16:56:41','9900','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','26/02/2025','','0','0','9900','7509546677002','PALMOLIVE JABON INTENSA RENOVACION *120 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-26 16:54:06',  2482, 52692, 426, 249, 8299917)
			   ,('FVE','DP1','022205','2025-02-26 17:29:03','022025','CR','1090484261','ANDERSSON JESUS','BOHADA VILLALBA','AVENIDA 9B # 16LN-26 VILLA NUE','5780943 3203784930','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','16386.55462184874','3113.4453781512602','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 17:38:27','19500','50','DEPOSITO CUCUTA ','1','19500.00000000','19500.00000000','16386.554621849','3113.4453781513','19500','1','0','0','','26/02/2025','','0','0','19500','7702006208512','SAVITAL FUSION PROTEINAS Y SABILA * 510','388','UNILEVER ANDINA COLOMBIA','2025-02-26 17:29:03',  11459, 62940, 2, 19, 8300223)
			   ,('FVE','DP1','022206','2025-02-26 17:30:11','022025','CR','1004821121','YURLEY ','DURAN ','CALLE 15 NO:19-60 NUEVO HORIZO',' 3228709991','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','38000','7220','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 17:57:48','45220','50','DEPOSITO CUCUTA ','1','9870.00000000','9870.00000000','8294.1176470588','1575.8823529412','9870','1','0','0','','26/02/2025','','0','0','45220','7702277074663','ARRURRU SHAMPOO CABELLO OSCURO *220 ML','124','BELLEZA EXPRESS SA','2025-02-26 17:30:11',  10235, 46958, 2, 19, 8300244)
			   ,('FVE','DP1','022206','2025-02-26 17:30:11','022025','CR','1004821121','YURLEY ','DURAN ','CALLE 15 NO:19-60 NUEVO HORIZO',' 3228709991','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','38000','7220','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 17:57:48','45220','50','DEPOSITO CUCUTA ','1','17500.00000000','17500.00000000','14705.882352941','2794.1176470588','17500','1','0','0','','26/02/2025','','0','0','45220','7891010037185','JOHNSON CREMA LIQ BABY * 200 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-26 17:30:11',  11182.7625, 28003, 2, 19, 8300244)
			   ,('FVE','DP1','022206','2025-02-26 17:30:11','022025','CR','1004821121','YURLEY ','DURAN ','CALLE 15 NO:19-60 NUEVO HORIZO',' 3228709991','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','38000','7220','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 17:57:48','45220','50','DEPOSITO CUCUTA ','1','17850.00000000','17850.00000000','15000','2850','17850','1','0','0','','26/02/2025','','0','0','45220','7702277074403','COLONIA ARRURRU ROSADA * 120 ML','124','BELLEZA EXPRESS SA','2025-02-26 17:30:11',  13982.4, 34503, 2, 19, 8300244)
			   ,('FVE','DP1','022207','2025-02-26 17:57:25','022025','CR','1090496828','MARIA FERNANDA ','ACOSTA CABARCAS','URBANIZACION LA FORTUNA PATIOS','3046614144 3046614144','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 18:17:43','4000','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','26/02/2025','','0','0','4000','7702277047582','PEINILLA SACA PIOJOS SHOCK * 1 UND','124','BELLEZA EXPRESS SA','2025-02-26 17:57:25',  1683, 48931, 2, 19, 8300472)
			   ,('FVE','DP1','022208','2025-02-26 18:14:14','022025','CR','1092353008','ANGID NELYSA','NAVARRO CASTIBLANCO','CRA 44 NO.64-44 EDIF LA GLORIA',' 3222842984','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','14','37669.747899159665','2730.2521008403355','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 18:29:13','40400','50','DEPOSITO CUCUTA ','1','11800.00000000','11800.00000000','9915.9663865546','1884.0336134454','11800','1','0','0','','27/02/2025','','0','0','40400','7702035432117','LISTERINE COOL MINT * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-26 18:14:14',  7518.6183, 28031, 2, 19, 8300564)
			   ,('FVE','DP1','022208','2025-02-26 18:14:14','022025','CR','1092353008','ANGID NELYSA','NAVARRO CASTIBLANCO','CRA 44 NO.64-44 EDIF LA GLORIA',' 3222842984','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','14','37669.747899159665','2730.2521008403355','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 18:29:13','40400','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','27/02/2025','','0','0','40400','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-26 18:14:14',  3375, 24465, 2, 19, 8300564)
			   ,('FVE','DP1','022208','2025-02-26 18:14:14','022025','CR','1092353008','ANGID NELYSA','NAVARRO CASTIBLANCO','CRA 44 NO.64-44 EDIF LA GLORIA',' 3222842984','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','14','37669.747899159665','2730.2521008403355','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 18:29:13','40400','50','DEPOSITO CUCUTA ','1','4300.00000000','4300.00000000','4300','0','4300','0','1','0','','27/02/2025','','0','0','40400','7707210530114','FORZ CREMA * 24 S/S','256','GERCO','2025-02-26 18:14:14',  34320, 46090, 2, 19, 8300564)
			   ,('FVE','DP1','022208','2025-02-26 18:14:14','022025','CR','1092353008','ANGID NELYSA','NAVARRO CASTIBLANCO','CRA 44 NO.64-44 EDIF LA GLORIA',' 3222842984','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','14','37669.747899159665','2730.2521008403355','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-26 18:29:13','40400','50','DEPOSITO CUCUTA ','10','1900.00000000','19000.00000000','19000','0','19000','0','10','0','','27/02/2025','','0','0','40400','7707019402100','ESPASMYDOL * 20 TAB','130','LABQUIFAR PHARMACEUTICA','2025-02-26 18:14:14',  13336.5, 23565, 2, 19, 8300564)
			   ,('FVE','DP1','022209','2025-02-27 08:33:08','022025','CO','1090429584','JESSICA  KATHERINE','NI Ntilde O CARO ','CALLE 21 NO. 18-62 SAN JOSE CU','3142233732 3142233732','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','2184.8739495798322','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 08:33:08','2600','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','27/02/2025','','2600','0','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-02-27 08:33:08',  1613.7, 52184, 2, 19, 8301860)
			   ,('FVE','DP1','022210','2025-02-27 08:42:17','022025','CR','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','18','42268.90756302521','8031.092436974788','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 08:44:23','50300','50','DEPOSITO CUCUTA ','1','34700.00000000','34700.00000000','29159.663865546','5540.3361344538','34700','1','0','0','','27/02/2025','','0','0','50300','7702031976493','LISTERINE ANTICARIES ZERO ALCOHOL * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-27 08:42:17',  21937.3371, 50830, 2, 19, 8302135)
			   ,('FVE','DP1','022210','2025-02-27 08:42:17','022025','CR','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','18','42268.90756302521','8031.092436974788','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 08:44:23','50300','50','DEPOSITO CUCUTA ','3','5200.00000000','15600.00000000','13109.243697479','2490.756302521','15600','3','0','0','','27/02/2025','','0','0','50300','7702010420993','PROTEX JABON PRO-HIDRATA MACADAMIA *110 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-27 08:42:17',  2836, 52325, 2, 19, 8302135)
			   ,('FVE','DP1','022211','2025-02-27 11:40:45','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','15','42605.04201680672','8094.957983193276','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 11:40:45','50700','50','DEPOSITO CUCUTA ','1','11800.00000000','11800.00000000','9915.9663865546','1884.0336134454','11800','1','0','1','','27/02/2025','','0','50700','0','7702035432117','LISTERINE COOL MINT * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-27 11:40:45',  7518.6183, 28031, 2, 19, 8299151)
			   ,('FVE','DP1','022211','2025-02-27 11:40:45','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','15','42605.04201680672','8094.957983193276','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 11:40:45','50700','50','DEPOSITO CUCUTA ','1','25900.00000000','25900.00000000','21764.705882353','4135.2941176471','25900','1','0','1','','27/02/2025','','0','50700','0','4005808315093','NIVEA BODY NUTRITIVA P/EXTRASC *250 ML','123','BDF (BEIERSDORF) ','2025-02-27 11:40:45',  16320, 23185, 2, 19, 8299151)
			   ,('FVE','DP1','022211','2025-02-27 11:40:45','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','15','42605.04201680672','8094.957983193276','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 11:40:45','50700','50','DEPOSITO CUCUTA ','10','600.00000000','6000.00000000','5042.0168067227','957.98319327731','6000','0','10','1','','27/02/2025','','0','50700','0','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2025-02-27 11:40:45',  15763, 56535, 2, 19, 8299151)
			   ,('FVE','DP1','022211','2025-02-27 11:40:45','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','15','42605.04201680672','8094.957983193276','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 11:40:45','50700','50','DEPOSITO CUCUTA ','2','3500.00000000','7000.00000000','5882.3529411765','1117.6470588235','7000','2','0','1','','27/02/2025','','0','50700','0','6910021007206','COLGATE CEPILLO PREMIER CLEAN MEDIO','145','COLGATE PALMOLIVE COMPANIA','2025-02-27 11:40:45',  1965, 47117, 2, 19, 8299151)
			   ,('FVE','DP1','022212','2025-02-27 11:42:15','022025','CR','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','15500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 14:44:40','15500','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','15500','0','15500','1','0','0','','27/02/2025','','0','0','15500','7707321981539','DIHIDROCODEINA 2.42MG/ML *120 ML','205','HUMAX PHARMACEUTICAL','2025-02-27 11:42:15',  7819, 49898, 2, 19, 8303595)
			   ,('FVE','DB1','002084','2025-02-27 15:49:26','022025','CR','1001831818','ERICK GABRIEL ','VELEZ DIAZ ','CALLE 14 NO.50-74 1RO DE MAYO',' 3156518373','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','19243.6974789916','3656.3025210084015','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-27 15:59:28','22900','DB','DEPOSITO BARRANQUILLA','1','22900.00000000','22900.00000000','19243.697478992','3656.3025210084','22900','1','0','0','','27/02/2025','','0','0','22900','7791293022581','REXONA MEN XTRA COOL AEROSOL * 150ML (89G)','388','UNILEVER ANDINA COLOMBIA','2025-02-27 15:49:26',  15483, 61105, 119, 53, 8305210)
			   ,('FVE','DB2','004003','2025-02-27 16:40:42','022025','CR','800118334-5','BELLEZA EXPRESS','SA','CL 36 134 201 KM 6 VIA CALI - ','5552255 3136519547','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. February 27, 2025, 4:46 pm','','2','2865756.3025210085','544493.6974789915','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-02-27 16:48:18','3410250','DBU','DEPOSITO BUCARAMANGA','1','3410249.64000000','3410249.64000000','2865756.302521','544493.69747899','3410250','1','0','0','','27/02/2025','','0','0','3410250','PCRE0405','EXHIBICIONES 4Q 2024','00','VARIOS','2025-02-27 16:40:42',  0, 50141, 426, 249, 8305539)
			   ,('FVE','DB2','004004','2025-02-27 16:57:15','022025','CR','800118334-5','BELLEZA EXPRESS','SA','CL 36 134 201 KM 6 VIA CALI - ','5552255 3136519547','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. February 27, 2025, 4:58 pm','','2','4175148.7394957985','793278.2605042015','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-02-27 17:09:55','4968427','DBU','DEPOSITO BUCARAMANGA','1','4968427.31000000','4968427.31000000','4175148.7394958','793278.2605042','4968427','1','0','0','','27/02/2025','','0','0','4968427','PCRE0405','EXHIBICIONES 4Q 2024','00','VARIOS','2025-02-27 16:57:15',  0, 50141, 426, 249, 8305652)
			   ,('FVE','DP1','022214','2025-02-27 17:32:25','022025','CR','13505546-5','ISMAEL ','MALDONADO BADILLO','CONJUNTO CALLEJAS RESERVADO CA',' 3124523897','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' AUXFINANZAS2 Autoriza la Venta por Cupo. February 27, 2025, 5:33 pm','','2','1512605.0420168068','287394.9579831932','00','DEPOSITO CUCUTA','AUXFINANZAS2','2025-02-27 17:56:29','1800000','50','DEPOSITO CUCUTA ','1','1800000.00000000','1800000.00000000','1512605.0420168','287394.95798319','1800000','1','0','0','','27/02/2025','','0','0','1800000','D1974','ARRIENDO FEBRERO 2025','1053','SERVICIOS','2025-02-27 17:32:25',  0, 64942, 2, 19, 8305987)
			   ,('FVE','DP1','022213','2025-02-27 17:32:59','022025','CO','1193479640','JHOAN JOS eacute  ','HERRERA CELIS ','CALLE 4 NO.1-39 BARRIO LA VICT',' 3229272401','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','5714.285714285715','1085.7142857142853','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-27 17:56:29','6800','50','DEPOSITO CUCUTA ','1','6800.00000000','6800.00000000','5714.2857142857','1085.7142857143','6800','1','0','1','','27/02/2025','','6800','0','0','7707822757541','PILAS ALKALINA AAA * 2 UND','950','TRONEX','2025-02-27 17:32:59',  2604, 62095, 2, 19, 8305912)
			   ,('FVE','DP1','022215','2025-02-28 07:34:16','022025','CR','1090371784','LEANDRO ENRIQUE','SUAREZ CARRERO','AV  11E #21-27 LOS LAURELES',' 3124105086 3144328532','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','27500','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 07:37:20','27500','50','DEPOSITO CUCUTA ','1','27500.00000000','27500.00000000','27500','0','27500','1','0','0','','28/02/2025','','0','0','27500','7703445103109','FLUIMUCIL 2% JB *120 ML','397','ZAMBON COLOMBIA ','2025-02-28 07:34:16',  21610, 55878, 2, 19, 8307154)
			   ,('FVE','DP1','022216','2025-02-28 09:42:20','022025','CR','1102381933-1','ANGIE CAMILA','BELTRAN SUESCUN ','CL 9 7 96 LC 22 BRR CENTRO ',' 3045893698','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' AUXFINANZAS2 Autoriza la Venta por Cupo. February 28, 2025, 9:43 am','','2','1440336.1344537816','273663.86554621835','00','DEPOSITO CUCUTA','AUXFINANZAS2','2025-02-28 09:44:31','1714000','50','DEPOSITO CUCUTA ','1','1714000.00000000','1714000.00000000','1440336.1344538','273663.86554622','1714000','1','0','0','','28/02/2025','','0','0','1714000','D1974','ARRIENDO FEBRERO 2025','1053','SERVICIOS','2025-02-28 09:42:20',  0, 64942, 2, 19, 8308269)
			   ,('FVE','DP1','022217','2025-02-28 09:58:35','022025','CO','900929396-4','SSP ASISTENCIAS ','SAS','CL 0 B N 7 A 42','5781374 3007512180','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','','','','2','126050.42016806723','23949.579831932773','00','DEPOSITO CUCUTA','AUXFINANZAS2','2025-02-28 09:59:07','150000','50','DEPOSITO CUCUTA ','1','150000.00000000','150000.00000000','126050.42016807','23949.579831933','150000','1','0','0','','28/02/2025','','0','150000','0','D1969','SERVICIO DE PARQUEADERO','1053','SERVICIOS','2025-02-28 09:58:35',  0, 64854, 2, 19, 8308402)
			   ,('FVE','DP1','022218','2025-02-28 09:59:34','022025','CO','900929396-4','SSP ASISTENCIAS ','SAS','CL 0 B N 7 A 42','5781374 3007512180','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','','','','2','126050.42016806723','23949.579831932773','00','DEPOSITO CUCUTA','AUXFINANZAS2','2025-02-28 09:59:34','150000','50','DEPOSITO CUCUTA ','1','150000.00000000','150000.00000000','126050.42016807','23949.579831933','150000','1','0','0','','28/02/2025','','0','150000','0','D1969','SERVICIO DE PARQUEADERO','1053','SERVICIOS','2025-02-28 09:59:34',  0, 64854, 2, 19, 8308421)
			   ,('FVE','DB1','002085','2025-02-28 10:22:41','022025','CR','1001871706','JOSE LUIS','CORDEDO VILLAFANE','CALLE 56D NO.36-31 VILLA DEL C',' 3022362183','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','21512.605042016807','4087.3949579831933','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 10:24:59','25600','DB','DEPOSITO BARRANQUILLA','1','25600.00000000','25600.00000000','21512.605042017','4087.3949579832','25600','1','0','0','','28/02/2025','','0','0','25600','079400052926','REXONA CLINICAL WOMEN ROSADO *48 GR','388','UNILEVER ANDINA COLOMBIA','2025-02-28 10:22:41',  16746, 43747, 119, 53, 8308600)
				  ,('FVE','DP1','022219','2025-02-28 10:27:56','022025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','6890.756302521009','1309.2436974789912','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 10:29:57','8200','50','DEPOSITO CUCUTA ','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','1','','28/02/2025','','8200','0','0','7702010111501','COLGATE CREMA DENTAL T/ACCION *60 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 10:27:56',  3100, 48361, 2, 19, 8308634);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DP1','022219','2025-02-28 10:27:56','022025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','6890.756302521009','1309.2436974789912','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 10:29:57','8200','50','DEPOSITO CUCUTA ','1','3500.00000000','3500.00000000','2941.1764705882','558.82352941176','3500','1','0','1','','28/02/2025','','8200','0','0','7703378010185','LAPIZ DELINEADOR SAMY # 25. MARSALA CON SACAPUNTAS','1013','COSMETICOS SAMY S.A.','2025-02-28 10:27:56',  1650.2, 63886, 2, 19, 8308634)
			   ,('FVE','DB2','004005','2025-02-28 13:57:45','022025','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','8','42184.873949579836','8015.126050420166','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 13:57:45','50200','DBU','DEPOSITO BUCARAMANGA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','1','','28/02/2025','','0','50200','0','7702006206808','REXONA CLINICAL MEN *30 GR','388','UNILEVER ANDINA COLOMBIA','2025-02-28 13:57:45',  2788, 56054, 426, 249, 8309970)
			   ,('FVE','DB2','004005','2025-02-28 13:57:45','022025','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','8','42184.873949579836','8015.126050420166','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 13:57:45','50200','DBU','DEPOSITO BUCARAMANGA','2','1500.00000000','3000.00000000','2521.0084033613','478.99159663866','3000','2','0','1','','28/02/2025','','0','50200','0','7702024007203','MORENITAS GALLETA * 24 GR','776','NESTLE FOOD & BEVERAGE','2025-02-28 13:57:45',  875, 38407, 426, 249, 8309970)
			   ,('FVE','DB2','004005','2025-02-28 13:57:45','022025','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','8','42184.873949579836','8015.126050420166','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 13:57:45','50200','DBU','DEPOSITO BUCARAMANGA','1','28200.00000000','28200.00000000','23697.478991597','4502.5210084034','28200','1','0','1','','28/02/2025','','0','50200','0','7702560043499','KOLA GRANULADA JGB FRESA * 330 GTS 80 GR','219','JGB','2025-02-28 13:57:45',  19999, 27878, 426, 249, 8309970)
			   ,('FVE','DB2','004005','2025-02-28 13:57:45','022025','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','8','42184.873949579836','8015.126050420166','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 13:57:45','50200','DBU','DEPOSITO BUCARAMANGA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','28/02/2025','','0','50200','0','7702031401032','JOHNSON BABYJABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 13:57:45',  3269, 56126, 426, 249, 8309970)
			   ,('FVE','DB2','004005','2025-02-28 13:57:45','022025','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','8','42184.873949579836','8015.126050420166','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 13:57:45','50200','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','1','','28/02/2025','','0','50200','0','7702031414346','JOHNSON JABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 13:57:45',  2601, 56006, 426, 249, 8309970)
			   ,('FVE','DB2','004005','2025-02-28 13:57:45','022025','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','8','42184.873949579836','8015.126050420166','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 13:57:45','50200','DBU','DEPOSITO BUCARAMANGA','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','28/02/2025','','0','50200','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 13:57:45',  3375, 24465, 426, 249, 8309970)
			   ,('FVE','DP1','022220','2025-02-28 14:00:40','022025','CR','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','3','31680.672268907565','6019.327731092435','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 14:54:24','37700','50','DEPOSITO CUCUTA ','1','10100.00000000','10100.00000000','8487.3949579832','1612.6050420168','10100','1','0','0','','28/02/2025','','0','0','37700','7891010560737','JOHNSON COPITOS PAGUE 60 LLEVE 75 UND','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 14:00:40',  6233.7849, 27985, 2, 19, 8310013)
			   ,('FVE','DP1','022220','2025-02-28 14:00:40','022025','CR','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','3','31680.672268907565','6019.327731092435','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 14:54:24','37700','50','DEPOSITO CUCUTA ','1','27600.00000000','27600.00000000','23193.277310924','4406.7226890756','27600','1','0','0','','28/02/2025','','0','0','37700','D1985','CABLE DUAL TIPO C ','819','INOVY','2025-02-28 14:00:40',  0, 65135, 2, 19, 8310013)
			   ,('FVE','DP1','022221','2025-02-28 16:53:52','022025','CR','1093747409','JUAN CAMILO','YANES SANCHEZ','CALLE 24 #6A-40 PORTAL DE LOS ',' 3016556754','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','1092.4369747899161','207.56302521008388','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:05:39','1300','50','DEPOSITO CUCUTA ','1','1300.00000000','1300.00000000','1092.4369747899','207.56302521008','1300','1','0','0','','28/02/2025','','0','0','1300','D1037, 75010659','H & S SHAMPOO SOBRE SURTIDO','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 16:53:52',  572, 32623, 2, 19, 8311298)
			   ,('FVE','DP1','022222','2025-02-28 16:56:28','022025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','52395.79831932773','3704.2016806722686','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:05:39','56100','50','DEPOSITO CUCUTA ','2','3500.00000000','7000.00000000','5882.3529411765','1117.6470588235','7000','2','0','1','','28/02/2025','','0','56100','0','7702010420153','PROTEX JABON AVENA * 75 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 16:56:28',  1924, 57147, 2, 19, 8311278)
			   ,('FVE','DP1','022222','2025-02-28 16:56:28','022025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','52395.79831932773','3704.2016806722686','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:05:39','56100','50','DEPOSITO CUCUTA ','1','16200.00000000','16200.00000000','13613.445378151','2586.5546218487','16200','1','0','1','','28/02/2025','','0','56100','0','7702031976387','LISTERINE ANTICARIES ZERO * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 16:56:28',  10373.7756, 49922, 2, 19, 8311278)
			   ,('FVE','DP1','022222','2025-02-28 16:56:28','022025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','52395.79831932773','3704.2016806722686','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:05:39','56100','50','DEPOSITO CUCUTA ','1','32900.00000000','32900.00000000','32900','0','32900','1','0','1','','28/02/2025','','0','56100','0','7707019469837','ALGINACID SUSP * 360 ML','130','LABQUIFAR PHARMACEUTICA','2025-02-28 16:56:28',  9010, 45938, 2, 19, 8311278)
			   ,('FVE','DP1','022223','2025-02-28 17:02:25','022025','CR','88261284','RAFAEL YADIR ','MOROS RIVERA ','CONJUNTO CERRADO TERRAVIVA  AP',' 3003412502','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','59747.899159663866','11352.100840336132','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:05:39','71100','50','DEPOSITO CUCUTA ','1','26400.00000000','26400.00000000','22184.87394958','4215.1260504202','26400','1','0','0','','28/02/2025','','0','0','71100','7501035911376','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT * 150 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:02:25',  18844, 24471, 2, 19, 8311350)
			   ,('FVE','DP1','022223','2025-02-28 17:02:25','022025','CR','88261284','RAFAEL YADIR ','MOROS RIVERA ','CONJUNTO CERRADO TERRAVIVA  AP',' 3003412502','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','59747.899159663866','11352.100840336132','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:05:39','71100','50','DEPOSITO CUCUTA ','1','34700.00000000','34700.00000000','29159.663865546','5540.3361344538','34700','1','0','0','','28/02/2025','','0','0','71100','7702035432445','LISTERINE CONTROL CALCULO * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:02:25',  21937, 28024, 2, 19, 8311350)
			   ,('FVE','DP1','022223','2025-02-28 17:02:25','022025','CR','88261284','RAFAEL YADIR ','MOROS RIVERA ','CONJUNTO CERRADO TERRAVIVA  AP',' 3003412502','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','59747.899159663866','11352.100840336132','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:05:39','71100','50','DEPOSITO CUCUTA ','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','0','','28/02/2025','','0','0','71100','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:02:25',  3253, 40145, 2, 19, 8311350)
			   ,('FVE','DP1','022224','2025-02-28 17:04:32','022025','CO','1092524382','EXLENDY CAMILA ','RUBIO GELVIZ ','CALLE 21 AVENIDA 51-04 ANTONIA',' 3115615142','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','17400','0','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:05:39','17400','50','DEPOSITO CUCUTA ','1','17400.00000000','17400.00000000','17400','0','17400','1','0','1','','28/02/2025','','0','17400','0','7703153021672','LEVOTIROXINA 50 MCG * 30 TAB','422','COLMED','2025-02-28 17:04:32',  7849, 39820, 2, 19, 8311283)
			   ,('FVE','DP1','022227','2025-02-28 17:05:06','022025','CR','1140422333','LUIS','FLOREZ','AV 5 N?2-22 BARRIO MOLINOS DEL','3222796309 3222796309','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','6722.689075630253','1277.3109243697472','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:16:59','8000','50','DEPOSITO CUCUTA ','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','0','','28/02/2025','','0','0','8000','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:05:06',  6163, 24467, 2, 19, 8311363)
			   ,('FVE','DP1','022225','2025-02-28 17:08:57','022025','CO','1148214960','ERICKSSON GUSTAVO ','VILLAMIZAR CORTEZ ','CALLE 2 NO. 0A-22 BOCONO',' 3026897867','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','4453.781512605042','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:08:57','5300','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','28/02/2025','','0','5300','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:08:57',  3375, 24465, 2, 19, 8311388)
			   ,('FVE','DP1','022226','2025-02-28 17:09:24','022025','CR','1090492046','JHON HEINER ','SILVA VELASQUEZ ','',' 3128022122','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','29000','0','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:15:36','29000','50','DEPOSITO CUCUTA ','1','29000.00000000','29000.00000000','29000','0','29000','1','0','0','','28/02/2025','','0','0','29000','736085405422','SPLASH TEARS LAGRIMAS ARTIFICIALES *15 ML','636','SOPHIA DE COLOMBIA OTC','2025-02-28 17:09:24',  12742, 31136, 2, 19, 8311404)
			   ,('FVE','DP1','022228','2025-02-28 17:14:41','022025','CR','1090429584','JESSICA  KATHERINE','NI Ntilde O CARO ','CALLE 21 NO. 18-62 SAN JOSE CU','3142233732 3142233732','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','13','65042.01680672269','957.9831932773104','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:17:37','66000','50','DEPOSITO CUCUTA ','10','600.00000000','6000.00000000','5042.0168067227','957.98319327731','6000','0','10','0','','28/02/2025','','0','0','66000','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2025-02-28 17:14:41',  15763, 56535, 2, 19, 8311431)
			   ,('FVE','DP1','022228','2025-02-28 17:14:41','022025','CR','1090429584','JESSICA  KATHERINE','NI Ntilde O CARO ','CALLE 21 NO. 18-62 SAN JOSE CU','3142233732 3142233732','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','13','65042.01680672269','957.9831932773104','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:17:37','66000','50','DEPOSITO CUCUTA ','2','30000.00000000','60000.00000000','60000','0','60000','2','0','0','','28/02/2025','','0','0','66000','7707232096186','CLORURO DE MAGNESIO *50 CAP','271','NATURAL FRESHLY','2025-02-28 17:14:41',  16171.812, 46205, 2, 19, 8311431)
			   ,('FVE','DB1','002087','2025-02-28 17:15:05','022025','CR','1045734020','JESUS GABRIEL ','RODRIGUEZ MENDOZA ','CRA 13E 2 NO.70-119',' 3024322053','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','7','106426.05042016807','8573.94957983193','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:25:32','115000','DB','DEPOSITO BARRANQUILLA','1','22000.00000000','22000.00000000','18487.394957983','3512.6050420168','22000','1','0','0','','28/02/2025','','0','0','115000','7702277299165','COLONIA ROSADA *120ML GTS JABON AVENA *110GR','124','BELLEZA EXPRESS SA','2025-02-28 17:15:05',  13982.5, 62006, 119, 53, 8311433)
			   ,('FVE','DB1','002087','2025-02-28 17:15:05','022025','CR','1045734020','JESUS GABRIEL ','RODRIGUEZ MENDOZA ','CRA 13E 2 NO.70-119',' 3024322053','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','7','106426.05042016807','8573.94957983193','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:25:32','115000','DB','DEPOSITO BARRANQUILLA','1','5400.00000000','5400.00000000','5400','0','5400','1','0','0','','28/02/2025','','0','0','115000','7702031800682','STAYFREE ESPECIAL NORMAL SUAVE ALAS PROMO 12','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:15:05',  4488, 28228, 119, 53, 8311433)
			   ,('FVE','DB1','002087','2025-02-28 17:15:05','022025','CR','1045734020','JESUS GABRIEL ','RODRIGUEZ MENDOZA ','CRA 13E 2 NO.70-119',' 3024322053','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','7','106426.05042016807','8573.94957983193','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:25:32','115000','DB','DEPOSITO BARRANQUILLA','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','0','','28/02/2025','','0','0','115000','7702560044717','CREMA DENTAL FLUOCARDENT NIÑOS * 50 GR + CEPILLO','219','JGB','2025-02-28 17:15:05',  5614, 27828, 119, 53, 8311433)
			   ,('FVE','DB1','002087','2025-02-28 17:15:05','022025','CR','1045734020','JESUS GABRIEL ','RODRIGUEZ MENDOZA ','CRA 13E 2 NO.70-119',' 3024322053','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','7','106426.05042016807','8573.94957983193','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:25:32','115000','DB','DEPOSITO BARRANQUILLA','1','19700.00000000','19700.00000000','16554.621848739','3145.3781512605','19700','1','0','0','','28/02/2025','','0','0','115000','7509546651019','COLGATE LUMINOUS WHITE CARBON ACTIVADO * 75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:15:05',  14052, 56068, 119, 53, 8311433)
			   ,('FVE','DB1','002087','2025-02-28 17:15:05','022025','CR','1045734020','JESUS GABRIEL ','RODRIGUEZ MENDOZA ','CRA 13E 2 NO.70-119',' 3024322053','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','7','106426.05042016807','8573.94957983193','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:25:32','115000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','28/02/2025','','0','0','115000','78924222','REXONA DESO MINIROLLON BAMBOO *30 ML  ','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:15:05',  2563.9857, 43765, 119, 53, 8311433)
			   ,('FVE','DB1','002087','2025-02-28 17:15:05','022025','CR','1045734020','JESUS GABRIEL ','RODRIGUEZ MENDOZA ','CRA 13E 2 NO.70-119',' 3024322053','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','7','106426.05042016807','8573.94957983193','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:25:32','115000','DB','DEPOSITO BARRANQUILLA','1','55900.00000000','55900.00000000','55900','0','55900','1','0','0','','28/02/2025','','0','0','115000','7703186976314','PEDIASURE VAINILLA *400 GR','659','ABBOTT NUTRICION','2025-02-28 17:15:05',  50180, 22284, 119, 53, 8311433)
			   ,('FVE','DB1','002086','2025-02-28 17:17:48','022025','CR','1007891376','C eacute SAR LUIS ','VASQUEZ MENDOZA ','CRA 16 NO.22-30 GALAPA',' 3238451741','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','4453.781512605042','846.2184873949582','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:21:08','5300','DB','DEPOSITO BARRANQUILLA','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','28/02/2025','','0','0','5300','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:17:48',  3375, 24465, 119, 53, 8311445)
			   ,('FVE','DP1','022229','2025-02-28 17:19:17','022025','CR','1090515053','LUIS ANGEL','OSPINA RODRIGUEZ','CALLE 7# 9-51 ALTO PAMPLONITA ',' 3152824645','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','60000','11400','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:20:22','71400','50','DEPOSITO CUCUTA ','1','71400.00000000','71400.00000000','60000','11400','71400','1','0','0','','28/02/2025','','0','0','71400','7701021117786','WINNY PANTS ET4 XG * 50 UND','653','TECNOQUIMICAS WINNY','2025-02-28 17:19:17',  53600.4, 56587, 2, 19, 8311450)
			   ,('FVE','DP1','022231','2025-02-28 17:20:27','022025','CR','1090518110','SOF iacute A ','RAMIREZ ','CALLE 4A NO. 14-45 LOMAS DE BO',' 3118253134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','4','26722.689075630253','5077.310924369747','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:22:32','31800','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','28/02/2025','','0','0','31800','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-02-28 17:20:27',  4412, 55331, 2, 19, 8311456)
			   ,('FVE','DP1','022231','2025-02-28 17:20:27','022025','CR','1090518110','SOF iacute A ','RAMIREZ ','CALLE 4A NO. 14-45 LOMAS DE BO',' 3118253134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','4','26722.689075630253','5077.310924369747','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:22:32','31800','50','DEPOSITO CUCUTA ','1','11800.00000000','11800.00000000','9915.9663865546','1884.0336134454','11800','1','0','0','','28/02/2025','','0','0','31800','7702035432117','LISTERINE COOL MINT * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:20:27',  7518.6183, 28031, 2, 19, 8311456)
			   ,('FVE','DP1','022231','2025-02-28 17:20:27','022025','CR','1090518110','SOF iacute A ','RAMIREZ ','CALLE 4A NO. 14-45 LOMAS DE BO',' 3118253134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','4','26722.689075630253','5077.310924369747','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:22:32','31800','50','DEPOSITO CUCUTA ','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','28/02/2025','','0','0','31800','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:20:27',  8027, 49624, 2, 19, 8311456)
			   ,('FVE','DP1','022230','2025-02-28 17:20:51','022025','CO','1127066591','JUSTO ANDERSSON ','PALENCIA RINC oacute N ','KDXB 84 MONTEVIDEO',' 3506172741','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','12','7201.680672268908','798.319327731092','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:20:51','8000','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','28/02/2025','','0','8000','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:20:51',  3253, 40145, 2, 19, 8311451)
			   ,('FVE','DP1','022230','2025-02-28 17:20:51','022025','CO','1127066591','JUSTO ANDERSSON ','PALENCIA RINC oacute N ','KDXB 84 MONTEVIDEO',' 3506172741','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','12','7201.680672268908','798.319327731092','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:20:51','8000','50','DEPOSITO CUCUTA ','10','300.00000000','3000.00000000','3000','0','3000','0','10','1','','28/02/2025','','0','8000','0','7706569020659','ACETAMINOFEN 500MG *100 TAB','614','A.G. MEDICAMENTOS','2025-02-28 17:20:51',  6368, 31151, 2, 19, 8311451)
			   ,('FVE','DP1','022232','2025-02-28 17:22:34','022025','CR','1090534653','JHONIER','SANCHEZ BURGOS','CALLE 32 NO.36-26',' 3227358678','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','7142.857142857143','1357.1428571428569','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:31:38','8500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','28/02/2025','','0','0','8500','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-02-28 17:22:34',  4412, 55331, 2, 19, 8311471)
			   ,('FVE','DP1','022233','2025-02-28 17:24:43','022025','CR','1004999037','JULIETH DANIELA','GUARIN CHAVEZ','CALLE 7 NO.16-91',' 3114568028','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','7142.857142857143','1357.1428571428569','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:31:38','8500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','28/02/2025','','0','0','8500','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-02-28 17:24:43',  4412, 55331, 2, 19, 8311481)
			   ,('FVE','DP1','022234','2025-02-28 17:25:14','022025','CR','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','12605.042016806723','2394.957983193277','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','15000','50','DEPOSITO CUCUTA ','1','15000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','1','0','0','','28/02/2025','','0','0','15000','42277040','NIVEA C/FACIAL CUIDADO NUTRITIVO *50 ML','123','BDF (BEIERSDORF) ','2025-02-28 17:25:14',  9121, 50790, 2, 19, 8311483)
			   ,('FVE','DP1','022236','2025-02-28 17:26:26','022025','CR','1090470026','JOAN MANUEL','OVIEDO VILLALBA','',' 3137975659','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','4','25798.319327731093','4901.680672268906','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','30700','50','DEPOSITO CUCUTA ','1','7100.00000000','7100.00000000','5966.3865546218','1133.6134453782','7100','1','0','0','','28/02/2025','','0','0','30700','7702031669647','NEKO JABON ALOE * 125 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:26:26',  5034, 34315, 2, 19, 8311504)
			   ,('FVE','DP1','022236','2025-02-28 17:26:26','022025','CR','1090470026','JOAN MANUEL','OVIEDO VILLALBA','',' 3137975659','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','4','25798.319327731093','4901.680672268906','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','30700','50','DEPOSITO CUCUTA ','1','4800.00000000','4800.00000000','4033.6134453782','766.38655462185','4800','1','0','0','','28/02/2025','','0','0','30700','7501006711615','PRO 425 SUAVE UND PROCTER & GAMBLE','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:26:26',  3243.4644, 44951, 2, 19, 8311504)
				  ,('FVE','DP1','022236','2025-02-28 17:26:26','022025','CR','1090470026','JOAN MANUEL','OVIEDO VILLALBA','',' 3137975659','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','4','25798.319327731093','4901.680672268906','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','30700','50','DEPOSITO CUCUTA ','1','18800.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','1','0','0','','28/02/2025','','0','0','30700','7702035468154','LUBRIDERM UV-15 *120 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:26:26',  11611, 28154, 2, 19, 8311504);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DB1','002088','2025-02-28 17:26:38','022025','CR','1043134472','LIONARD','MIRANDA','CRA 51A NO.21-25',' 3245126701','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','26050.420168067227','4949.579831932773','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:31:38','31000','DB','DEPOSITO BARRANQUILLA','2','1500.00000000','3000.00000000','2521.0084033613','478.99159663866','3000','2','0','0','','28/02/2025','','0','0','31000','7702024007203','MORENITAS GALLETA * 24 GR','776','NESTLE FOOD & BEVERAGE','2025-02-28 17:26:38',  875, 38407, 119, 53, 8311508)
			   ,('FVE','DB1','002088','2025-02-28 17:26:38','022025','CR','1043134472','LIONARD','MIRANDA','CRA 51A NO.21-25',' 3245126701','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','26050.420168067227','4949.579831932773','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:31:38','31000','DB','DEPOSITO BARRANQUILLA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','28/02/2025','','0','0','31000','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:26:38',  3253, 40145, 119, 53, 8311508)
			   ,('FVE','DB1','002088','2025-02-28 17:26:38','022025','CR','1043134472','LIONARD','MIRANDA','CRA 51A NO.21-25',' 3245126701','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','26050.420168067227','4949.579831932773','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:31:38','31000','DB','DEPOSITO BARRANQUILLA','2','11500.00000000','23000.00000000','19327.731092437','3672.268907563','23000','2','0','0','','28/02/2025','','0','0','31000','7702277653417','POMO FREESTYLE BASE COLORS * 4 UND ','124','BELLEZA EXPRESS SA','2025-02-28 17:26:38',  0, 64760, 119, 53, 8311508)
			   ,('FVE','DP1','022235','2025-02-28 17:27:24','022025','CO','1004924606','YURI ALEXANDRA','GARCIA PEREZ','CALLE 1N NO.5N-27 BARRIO SANTA',' 3114922356','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','7142.857142857143','1357.1428571428569','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:31:38','8500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','1','','28/02/2025','','0','8500','0','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-02-28 17:27:24',  4412, 55331, 2, 19, 8311509)
			   ,('FVE','DP1','022237','2025-02-28 17:28:36','022025','CO','1091384385','LUIS JESUS ','SIERRA MOROS ','CALLE 4 CRA 11 BARRIO JOSE FEL',' 3203764959','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','12100.840336134454','2299.1596638655465','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:31:38','14400','50','DEPOSITO CUCUTA ','4','3600.00000000','14400.00000000','12100.840336134','2299.1596638655','14400','0','4','1','','28/02/2025','','14400','0','0','7702113043365','TANGA BLOQ SPF 100 DISPLAY 10 ML *12 UND','278','RECAMIER','2025-02-28 17:28:36',  26405, 61917, 2, 19, 8311525)
			   ,('FVE','DB1','002089','2025-02-28 17:29:46','022025','CR','1001871706','JOSE LUIS','CORDEDO VILLAFANE','CALLE 56D NO.36-31 VILLA DEL C',' 3022362183','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','8703.361344537816','1596.638655462184','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:31:38','10300','DB','DEPOSITO BARRANQUILLA','1','300.00000000','300.00000000','300','0','300','1','0','0','','28/02/2025','','0','0','10300','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-02-28 17:29:46',  0, 44347, 119, 53, 8311558)
			   ,('FVE','DB1','002089','2025-02-28 17:29:46','022025','CR','1001871706','JOSE LUIS','CORDEDO VILLAFANE','CALLE 56D NO.36-31 VILLA DEL C',' 3022362183','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','8703.361344537816','1596.638655462184','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:31:38','10300','DB','DEPOSITO BARRANQUILLA','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','0','','28/02/2025','','0','0','10300','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:29:46',  3253, 40145, 119, 53, 8311558)
			   ,('FVE','DP1','022238','2025-02-28 17:30:14','022025','CO','1004842741','ANGEL GABRIELA ','CONTRERAS RIA Ntilde O','CALLE 3 NO.1-37 SAN MATEO PART',' 3202279289','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','29663.86554621849','5636.134453781511','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:31:38','35300','50','DEPOSITO CUCUTA ','1','11600.00000000','11600.00000000','9747.8991596639','1852.1008403361','11600','1','0','1','','28/02/2025','','0','35300','0','7891010035617','JOHNSON CREMA LIQ ORIGINAL * 100 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:30:14',  7375.86, 28004, 2, 19, 8311546)
			   ,('FVE','DP1','022238','2025-02-28 17:30:14','022025','CO','1004842741','ANGEL GABRIELA ','CONTRERAS RIA Ntilde O','CALLE 3 NO.1-37 SAN MATEO PART',' 3202279289','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','29663.86554621849','5636.134453781511','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:31:38','35300','50','DEPOSITO CUCUTA ','1','10900.00000000','10900.00000000','9159.6638655462','1740.3361344538','10900','1','0','1','','28/02/2025','','0','35300','0','7707363365373','MASGLO BRILLO EVOLUCION GEL *13.5 ML','801','CERESCOS','2025-02-28 17:30:14',  7118.4, 62121, 2, 19, 8311546)
			   ,('FVE','DP1','022238','2025-02-28 17:30:14','022025','CO','1004842741','ANGEL GABRIELA ','CONTRERAS RIA Ntilde O','CALLE 3 NO.1-37 SAN MATEO PART',' 3202279289','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','29663.86554621849','5636.134453781511','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:31:38','35300','50','DEPOSITO CUCUTA ','2','6400.00000000','12800.00000000','10756.302521008','2043.6974789916','12800','2','0','1','','28/02/2025','','0','35300','0','7702010130625','COLGATE CEPILLO EXTRA CLEAN DURA','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:30:14',  3807, 48362, 2, 19, 8311546)
			   ,('FVE','DP1','022239','2025-02-28 17:31:02','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','57058.823529411755','10841.176470588234','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','67899.99999999999','50','DEPOSITO CUCUTA ','1','20500.00000000','20500.00000000','17226.890756303','3273.1092436975','20500','1','0','1','','28/02/2025','','0','67900','0','7702277120971','MENTICOL AZUL SPRAY *250 ML','124','BELLEZA EXPRESS SA','2025-02-28 17:31:02',  12263, 49808, 2, 19, 8311542)
			   ,('FVE','DP1','022239','2025-02-28 17:31:02','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','57058.823529411755','10841.176470588234','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','67899.99999999999','50','DEPOSITO CUCUTA ','1','23900.00000000','23900.00000000','20084.033613445','3815.9663865546','23900','1','0','1','','28/02/2025','','0','67900','0','7707263005676','OCHO BABY ACEITE HUMECTANTE *230 ML','387','TRIDEX FARMACEUTICA','2025-02-28 17:31:02',  14014, 64021, 2, 19, 8311542)
			   ,('FVE','DP1','022239','2025-02-28 17:31:02','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','57058.823529411755','10841.176470588234','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','67899.99999999999','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','28/02/2025','','0','67900','0','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:31:02',  2765, 40129, 2, 19, 8311542)
			   ,('FVE','DP1','022239','2025-02-28 17:31:02','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','57058.823529411755','10841.176470588234','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','67899.99999999999','50','DEPOSITO CUCUTA ','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','1','','28/02/2025','','0','67900','0','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:31:02',  8027, 49624, 2, 19, 8311542)
			   ,('FVE','DP1','022239','2025-02-28 17:31:02','022025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','57058.823529411755','10841.176470588234','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:31:38','67899.99999999999','50','DEPOSITO CUCUTA ','2','3500.00000000','7000.00000000','5882.3529411765','1117.6470588235','7000','2','0','1','','28/02/2025','','0','67900','0','6910021007206','COLGATE CEPILLO PREMIER CLEAN MEDIO','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:31:02',  1965, 47117, 2, 19, 8311542)
			   ,('FVE','DP1','022241','2025-02-28 17:31:46','022025','CR','1004844958','ANGIE CAMILA ','MORENO RINCON','CALLE 20A NO.22-15',' 3192134878','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','11','5042.01680672269','957.9831932773104','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:34:18','6000','50','DEPOSITO CUCUTA ','10','600.00000000','6000.00000000','5042.0168067227','957.98319327731','6000','0','10','0','','28/02/2025','','0','0','6000','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2025-02-28 17:31:46',  15763, 56535, 2, 19, 8311565)
			   ,('FVE','DB1','002090','2025-02-28 17:32:01','022025','CR','1002213647','CARLOS JOS eacute  ','LAMADRID BUELVAS','CALLE 13 NO.91-31',' 3001509823','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','44842.01680672269','4757.98319327731','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:34:18','49600','DB','DEPOSITO BARRANQUILLA','1','19800.00000000','19800.00000000','16638.655462185','3161.3445378151','19800','1','0','0','','28/02/2025','','0','0','49600','7702314180586','KIT ORTODONCIA ECONOMICO','778','PROQUIDENT','2025-02-28 17:32:01',  12095, 54137, 119, 53, 8311566)
			   ,('FVE','DB1','002090','2025-02-28 17:32:01','022025','CR','1002213647','CARLOS JOS eacute  ','LAMADRID BUELVAS','CALLE 13 NO.91-31',' 3001509823','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','44842.01680672269','4757.98319327731','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:34:18','49600','DB','DEPOSITO BARRANQUILLA','1','19800.00000000','19800.00000000','19800','0','19800','1','0','0','','28/02/2025','','0','0','49600','7702057080396','BLANKISIMA 2% FRASCO * 32 GR','889','TECNOQUIMICAS CONSUMO','2025-02-28 17:32:01',  15380, 42836, 119, 53, 8311566)
			   ,('FVE','DB1','002090','2025-02-28 17:32:01','022025','CR','1002213647','CARLOS JOS eacute  ','LAMADRID BUELVAS','CALLE 13 NO.91-31',' 3001509823','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','44842.01680672269','4757.98319327731','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:34:18','49600','DB','DEPOSITO BARRANQUILLA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','28/02/2025','','0','0','49600','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:32:01',  2765, 40129, 119, 53, 8311566)
			   ,('FVE','DB1','002090','2025-02-28 17:32:01','022025','CR','1002213647','CARLOS JOS eacute  ','LAMADRID BUELVAS','CALLE 13 NO.91-31',' 3001509823','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','44842.01680672269','4757.98319327731','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:34:18','49600','DB','DEPOSITO BARRANQUILLA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','28/02/2025','','0','0','49600','7702031401032','JOHNSON BABYJABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:32:01',  3269, 56126, 119, 53, 8311566)
			   ,('FVE','DP1','022240','2025-02-28 17:32:57','022025','CO','1090496828','MARIA FERNANDA ','ACOSTA CABARCAS','URBANIZACION LA FORTUNA PATIOS','3046614144 3046614144','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','19600','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:32:57','19600','50','DEPOSITO CUCUTA ','2','9800.00000000','19600.00000000','19600','0','19600','2','0','1','','28/02/2025','','0','19600','0','7702057088835','CREMA N4 * 20 GR ','889','TECNOQUIMICAS CONSUMO','2025-02-28 17:32:57',  7645, 42902, 2, 19, 8311559)
			   ,('FVE','DP1','022242','2025-02-28 17:33:51','022025','CO','1004844958','ANGIE CAMILA ','MORENO RINCON','CALLE 20A NO.22-15',' 3192134878','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','11','5042.01680672269','957.9831932773104','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:34:18','6000','50','DEPOSITO CUCUTA ','10','600.00000000','6000.00000000','5042.0168067227','957.98319327731','6000','0','10','1','','28/02/2025','','0','6000','0','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2025-02-28 17:33:51',  15763, 56535, 2, 19, 8311573)
			   ,('FVE','DB1','002091','2025-02-28 17:34:35','022025','CR','1128146141','GABRIEL JES Atilde  ordm S ','CARO ESPA Atilde  plusmn A ','CRA 6C NO.47-87 METROPOLITANO',' 3207312086','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','30168.06722689076','5731.932773109243','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','35900','DB','DEPOSITO BARRANQUILLA','1','3600.00000000','3600.00000000','3025.2100840336','574.78991596639','3600','1','0','0','','28/02/2025','','0','0','35900','7702057086831','YODORA MINI ROLLON TOTAL CONTROL *30 GR ','889','TECNOQUIMICAS CONSUMO','2025-02-28 17:34:35',  2302.52, 59365, 119, 53, 8311597)
			   ,('FVE','DB1','002091','2025-02-28 17:34:35','022025','CR','1128146141','GABRIEL JES Atilde  ordm S ','CARO ESPA Atilde  plusmn A ','CRA 6C NO.47-87 METROPOLITANO',' 3207312086','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','30168.06722689076','5731.932773109243','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','35900','DB','DEPOSITO BARRANQUILLA','1','11800.00000000','11800.00000000','9915.9663865546','1884.0336134454','11800','1','0','0','','28/02/2025','','0','0','35900','7702035432117','LISTERINE COOL MINT * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:34:35',  7518.6183, 28031, 119, 53, 8311597)
			   ,('FVE','DB1','002091','2025-02-28 17:34:35','022025','CR','1128146141','GABRIEL JES Atilde  ordm S ','CARO ESPA Atilde  plusmn A ','CRA 6C NO.47-87 METROPOLITANO',' 3207312086','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','30168.06722689076','5731.932773109243','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','35900','DB','DEPOSITO BARRANQUILLA','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','0','','28/02/2025','','0','0','35900','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:34:35',  8629, 24473, 119, 53, 8311597)
			   ,('FVE','DB1','002091','2025-02-28 17:34:35','022025','CR','1128146141','GABRIEL JES Atilde  ordm S ','CARO ESPA Atilde  plusmn A ','CRA 6C NO.47-87 METROPOLITANO',' 3207312086','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','30168.06722689076','5731.932773109243','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','35900','DB','DEPOSITO BARRANQUILLA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','28/02/2025','','0','0','35900','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:34:35',  3253, 40145, 119, 53, 8311597)
			   ,('FVE','DP1','022243','2025-02-28 17:37:12','022025','CO','1090438621','SERGIO GABRIEL ','PAEZ APONTE','CALLE 21 A NO.69 SAN MARTIN',' 3174246376','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','7142.857142857143','1357.1428571428569','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 17:37:12','8500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','1','','28/02/2025','','8500','0','0','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-02-28 17:37:12',  4412, 55331, 2, 19, 8311582)
			   ,('FVE','DB1','002092','2025-02-28 17:37:52','022025','CR','1007368192','KEVIN JESUS','DE LA HOZ JIMENEZ','CRA 14A NO.84-64 LA ESMERALDA',' 3042195024','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','16554.621848739494','3145.3781512605037','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','19700','DB','DEPOSITO BARRANQUILLA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','28/02/2025','','0','0','19700','7702010111501','COLGATE CREMA DENTAL T/ACCION *60 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:37:52',  3100, 48361, 119, 53, 8311635)
			   ,('FVE','DB1','002092','2025-02-28 17:37:52','022025','CR','1007368192','KEVIN JESUS','DE LA HOZ JIMENEZ','CRA 14A NO.84-64 LA ESMERALDA',' 3042195024','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','16554.621848739494','3145.3781512605037','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','19700','DB','DEPOSITO BARRANQUILLA','3','5000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','3','0','0','','28/02/2025','','0','0','19700','7702031401049','JOHNSON JABON BABY CREMOSO HUMECT *110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-02-28 17:37:52',  3093.1, 56125, 119, 53, 8311635)
			   ,('FVE','DP1','022244','2025-02-28 17:39:38','022025','CO','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','60070.336134453784','7759.663865546216','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:42:59','67830','50','DEPOSITO CUCUTA ','1','48600.00000000','48600.00000000','40840.336134454','7759.6638655462','48600','1','0','1','','28/02/2025','','0','67830','0','4054839106644','BION3 DEFENSAS ADULTO *30 TAB','820','PROCTER & GAMBLE CHC','2025-02-28 17:39:38',  29584, 52658, 2, 19, 8311596)
			   ,('FVE','DP1','022244','2025-02-28 17:39:38','022025','CO','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','60070.336134453784','7759.663865546216','00','DEPOSITO CUCUTA','AUXAUDITOR7','2025-02-28 17:42:59','67830','50','DEPOSITO CUCUTA ','3','6410.00000000','19230.00000000','19230','0','19230','0','3','1','','28/02/2025','','0','67830','0','3582910009900','ENTEROGERMINA * 10 AMP','772','OPELLA (SANOFI OTC)','2025-02-28 17:39:38',  50000, 41855, 2, 19, 8311596)
			   ,('FVE','DB1','002093','2025-02-28 17:40:14','022025','CR','1048069289','JHOSUAR DE JESUS','VANEGAS CERMENO','CALLE 50 NO.2D3-10 SAN VICENTE',' 3046332176','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','74172.26890756303','5827.731092436974','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','80000','DB','DEPOSITO BARRANQUILLA','1','21000.00000000','21000.00000000','17647.058823529','3352.9411764706','21000','1','0','0','','28/02/2025','','0','0','80000','7702870101636','INTIBON MUJER VINAGRE DE MANZANA Y CALENDULA * 210 GR','124','BELLEZA EXPRESS SA','2025-02-28 17:40:14',  12060, 52799, 119, 53, 8311669)
			   ,('FVE','DB1','002093','2025-02-28 17:40:14','022025','CR','1048069289','JHOSUAR DE JESUS','VANEGAS CERMENO','CALLE 50 NO.2D3-10 SAN VICENTE',' 3046332176','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','74172.26890756303','5827.731092436974','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','80000','DB','DEPOSITO BARRANQUILLA','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','0','','28/02/2025','','0','0','80000','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:40:14',  8629, 24473, 119, 53, 8311669)
			   ,('FVE','DB1','002093','2025-02-28 17:40:14','022025','CR','1048069289','JHOSUAR DE JESUS','VANEGAS CERMENO','CALLE 50 NO.2D3-10 SAN VICENTE',' 3046332176','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','74172.26890756303','5827.731092436974','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 17:42:59','80000','DB','DEPOSITO BARRANQUILLA','1','43500.00000000','43500.00000000','43500','0','43500','1','0','0','','28/02/2025','','0','0','80000','650240027543','LOMECAN V CREMA VAG 2% * 20 GR','194','GENOMMA LABORATORIO COLOMBIA','2025-02-28 17:40:14',  36413, 47499, 119, 53, 8311669)
			   ,('FVE','DP1','022245','2025-02-28 17:40:41','022025','CO','1093292328','MARTIN ALEXANDER','SILVA VELASQUEZ','CALLE 2 NO.3-67  CECI',' 3123011712','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','3','47490.75630252101','5109.243697478989','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:42:59','52600','50','DEPOSITO CUCUTA ','1','32000.00000000','32000.00000000','26890.756302521','5109.243697479','32000','1','0','237','','28/02/2025','','0','52600','0','650240029158','MEDICASP SHAMPOO *100 ML','194','GENOMMA LABORATORIO COLOMBIA','2025-02-28 17:40:41',  21075.2367, 46791, 2, 19, 8311622)
			   ,('FVE','DP1','022245','2025-02-28 17:40:41','022025','CO','1093292328','MARTIN ALEXANDER','SILVA VELASQUEZ','CALLE 2 NO.3-67  CECI',' 3123011712','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','3','47490.75630252101','5109.243697478989','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:42:59','52600','50','DEPOSITO CUCUTA ','1','20600.00000000','20600.00000000','20600','0','20600','1','0','237','','28/02/2025','','0','52600','0','7590002012468','VICK VAPORUB *50 GR','820','PROCTER & GAMBLE CHC','2025-02-28 17:40:41',  13925, 40254, 2, 19, 8311622)
			   ,('FVE','DP1','022246','2025-02-28 17:44:08','022025','CO','6664195','FRANCISCO SAID','RODRIGUEZ CASTIBLANCO','CONJUNTO CERRADO VALLARTA CASA','5703269 3002692042','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','17563.025210084033','3336.9747899159656','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:44:08','20900','50','DEPOSITO CUCUTA ','3','5200.00000000','15600.00000000','13109.243697479','2490.756302521','15600','3','0','1','','28/02/2025','','0','20900','0','7702010421013','PROTEX JABON FOR MEN 10X SPORT *110 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:44:08',  2268.189, 52459, 2, 19, 8311671)
			   ,('FVE','DP1','022246','2025-02-28 17:44:08','022025','CO','6664195','FRANCISCO SAID','RODRIGUEZ CASTIBLANCO','CONJUNTO CERRADO VALLARTA CASA','5703269 3002692042','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','17563.025210084033','3336.9747899159656','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 17:44:08','20900','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','28/02/2025','','0','20900','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:44:08',  3375, 24465, 2, 19, 8311671)
			   ,('FVE','DB1','002094','2025-02-28 17:44:47','022025','CR','1010124899','ANDRES FELIPE','ARGOTE GAVIRIA','CRA 5A NO.33E-14 GIRON',' 3013099734','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','24381.51260504202','718.4873949579828','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','25100','DB','DEPOSITO BARRANQUILLA','1','20600.00000000','20600.00000000','20600','0','20600','1','0','0','','28/02/2025','','0','0','25100','7590002012468','VICK VAPORUB *50 GR','820','PROCTER & GAMBLE CHC','2025-02-28 17:44:47',  13925, 40254, 119, 53, 8311701)
			   ,('FVE','DB1','002094','2025-02-28 17:44:47','022025','CR','1010124899','ANDRES FELIPE','ARGOTE GAVIRIA','CRA 5A NO.33E-14 GIRON',' 3013099734','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','24381.51260504202','718.4873949579828','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','25100','DB','DEPOSITO BARRANQUILLA','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','0','','28/02/2025','','0','0','25100','7702010111587','COLGATE CREMA DENTAL TRIPLE EXTRA BLANCURA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:44:47',  3100, 48567, 119, 53, 8311701)
				  ,('FVE','DP1','022247','2025-02-28 17:46:01','022025','CO','1010086333','ESNEIDER STYVEN','BECERRA BECERRA','',' 3008081615','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','11200','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 18:00:59','11200','50','DEPOSITO CUCUTA ','1','11200.00000000','11200.00000000','11200','0','11200','1','0','1','','28/02/2025','','0','11200','0','7703086201035','NIXODERM CREMA * 20 GR','416','INCOBRA CONSUMO','2025-02-28 17:46:01',  7847, 29928, 2, 19, 8311700);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DB1','002095','2025-02-28 17:47:02','022025','CR','1007360501','WILFRIDO JOSE','NOVOA HERNANDEZ','CALLE 77 NO.59B-27',' 3225042586','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','19579.83193277311','3720.16806722689','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','23300','DB','DEPOSITO BARRANQUILLA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','28/02/2025','','0','0','23300','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:47:02',  3253, 40145, 119, 53, 8311722)
			   ,('FVE','DB1','002095','2025-02-28 17:47:02','022025','CR','1007360501','WILFRIDO JOSE','NOVOA HERNANDEZ','CALLE 77 NO.59B-27',' 3225042586','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','19579.83193277311','3720.16806722689','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','23300','DB','DEPOSITO BARRANQUILLA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','28/02/2025','','0','0','23300','7509546677002','PALMOLIVE JABON INTENSA RENOVACION *120 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:47:02',  2482, 52692, 119, 53, 8311722)
			   ,('FVE','DB1','002095','2025-02-28 17:47:02','022025','CR','1007360501','WILFRIDO JOSE','NOVOA HERNANDEZ','CALLE 77 NO.59B-27',' 3225042586','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','19579.83193277311','3720.16806722689','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','23300','DB','DEPOSITO BARRANQUILLA','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','0','','28/02/2025','','0','0','23300','7702010410895','PALMOLIVE JABON AVENA Y AZUCAR *120 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:47:02',  1780, 52458, 119, 53, 8311722)
			   ,('FVE','DB1','002095','2025-02-28 17:47:02','022025','CR','1007360501','WILFRIDO JOSE','NOVOA HERNANDEZ','CALLE 77 NO.59B-27',' 3225042586','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','19579.83193277311','3720.16806722689','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','23300','DB','DEPOSITO BARRANQUILLA','1','3800.00000000','3800.00000000','3193.2773109244','606.72268907563','3800','1','0','0','','28/02/2025','','0','0','23300','7702057080044','YODORA CREMA * 12 GR ','889','TECNOQUIMICAS CONSUMO','2025-02-28 17:47:02',  2421, 42929, 119, 53, 8311722)
			   ,('FVE','DB1','002095','2025-02-28 17:47:02','022025','CR','1007360501','WILFRIDO JOSE','NOVOA HERNANDEZ','CALLE 77 NO.59B-27',' 3225042586','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','19579.83193277311','3720.16806722689','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','23300','DB','DEPOSITO BARRANQUILLA','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','28/02/2025','','0','0','23300','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:47:02',  3375, 24465, 119, 53, 8311722)
			   ,('FVE','DB1','002096','2025-02-28 17:49:36','022025','CR','1143250980','ESNEIDER JOS eacute  ','RODR iacute GUEZ PADILLA ','CALLE 81 NO.11-70',' 3013341105','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','17142.85714285714','3257.1428571428564','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','20399.999999999996','DB','DEPOSITO BARRANQUILLA','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','0','','28/02/2025','','0','0','20400','7702010421006','PROTEX JABON HERBAL *110 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:49:36',  2836, 52311, 119, 53, 8311735)
			   ,('FVE','DB1','002096','2025-02-28 17:49:36','022025','CR','1143250980','ESNEIDER JOS eacute  ','RODR iacute GUEZ PADILLA ','CALLE 81 NO.11-70',' 3013341105','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','17142.85714285714','3257.1428571428564','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','20399.999999999996','DB','DEPOSITO BARRANQUILLA','1','3300.00000000','3300.00000000','2773.1092436975','526.89075630252','3300','1','0','0','','28/02/2025','','0','0','20400','7500435154420','PRESTOBARBA ULTRAGRIP GILLETTE','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 17:49:36',  1803, 40148, 119, 53, 8311735)
			   ,('FVE','DB1','002096','2025-02-28 17:49:36','022025','CR','1143250980','ESNEIDER JOS eacute  ','RODR iacute GUEZ PADILLA ','CALLE 81 NO.11-70',' 3013341105','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','17142.85714285714','3257.1428571428564','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','20399.999999999996','DB','DEPOSITO BARRANQUILLA','1','3800.00000000','3800.00000000','3193.2773109244','606.72268907563','3800','1','0','0','','28/02/2025','','0','0','20400','7702057080044','YODORA CREMA * 12 GR ','889','TECNOQUIMICAS CONSUMO','2025-02-28 17:49:36',  2421, 42929, 119, 53, 8311735)
			   ,('FVE','DB1','002096','2025-02-28 17:49:36','022025','CR','1143250980','ESNEIDER JOS eacute  ','RODR iacute GUEZ PADILLA ','CALLE 81 NO.11-70',' 3013341105','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','17142.85714285714','3257.1428571428564','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','20399.999999999996','DB','DEPOSITO BARRANQUILLA','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','0','','28/02/2025','','0','0','20400','7793100151224','COLGATE CEPILLO KIDS RABBIT SUAVE 2+','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:49:36',  1736, 46705, 119, 53, 8311735)
			   ,('FVE','DB1','002096','2025-02-28 17:49:36','022025','CR','1143250980','ESNEIDER JOS eacute  ','RODR iacute GUEZ PADILLA ','CALLE 81 NO.11-70',' 3013341105','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','17142.85714285714','3257.1428571428564','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','20399.999999999996','DB','DEPOSITO BARRANQUILLA','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','28/02/2025','','0','0','20400','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:49:36',  3375, 24465, 119, 53, 8311735)
			   ,('FVE','DB2','004006','2025-02-28 17:51:16','022025','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','3489','CAMILO ','RODRIGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','3','33781.51260504202','6418.48739495798','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 18:00:59','40200','DBU','DEPOSITO BUCARAMANGA','1','4200.00000000','4200.00000000','3529.4117647059','670.58823529412','4200','1','0','1','','28/02/2025','','0','40200','0','7509546652139','COLGATE CREMA MENTA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:51:16',  2700, 56066, 426, 249, 8311721)
			   ,('FVE','DB2','004006','2025-02-28 17:51:16','022025','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','3489','CAMILO ','RODRIGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','3','33781.51260504202','6418.48739495798','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 18:00:59','40200','DBU','DEPOSITO BUCARAMANGA','1','36000.00000000','36000.00000000','30252.100840336','5747.8991596639','36000','1','0','1','','28/02/2025','','0','40200','0','650240035166','TIO NACHO SHAMPOO ENGROSADOR V/CAPILAR *415 ML','194','GENOMMA LABORATORIO COLOMBIA','2025-02-28 17:51:16',  17789, 52313, 426, 249, 8311721)
			   ,('FVE','DB1','002097','2025-02-28 17:53:01','022025','CR','1129504297','CAMILO ANDR eacute S','GIM eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','103277.31092436974','19622.68907563025','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','122899.99999999999','DB','DEPOSITO BARRANQUILLA','2','25599.99000000','51199.98000000','43025.210084034','8174.7899159664','51200','2','0','0','','28/02/2025','','0','0','122900','079400052919','REXONA CLINICAL MEN AZUL *48 GR','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:53:01',  17301, 43744, 119, 53, 8311744)
			   ,('FVE','DB1','002097','2025-02-28 17:53:01','022025','CR','1129504297','CAMILO ANDR eacute S','GIM eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','103277.31092436974','19622.68907563025','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','122899.99999999999','DB','DEPOSITO BARRANQUILLA','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','28/02/2025','','0','0','122900','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 17:53:01',  3375, 24465, 119, 53, 8311744)
			   ,('FVE','DB1','002097','2025-02-28 17:53:01','022025','CR','1129504297','CAMILO ANDR eacute S','GIM eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','103277.31092436974','19622.68907563025','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','122899.99999999999','DB','DEPOSITO BARRANQUILLA','1','40500.00000000','40500.00000000','34033.613445378','6466.3865546218','40500','1','0','0','','28/02/2025','','0','0','122900','7702006201032','DOVE ORIGINAL 2*1 * SPRAY 150 ML','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:53:01',  28506, 51671, 119, 53, 8311744)
			   ,('FVE','DB1','002097','2025-02-28 17:53:01','022025','CR','1129504297','CAMILO ANDR eacute S','GIM eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','103277.31092436974','19622.68907563025','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:00:59','122899.99999999999','DB','DEPOSITO BARRANQUILLA','1','25900.00000000','25900.00000000','21764.705882353','4135.2941176471','25900','1','0','0','','28/02/2025','','0','0','122900','7702277148081','DEPILEX CREMA DEPI BIKINI Y AXILAS 2 UNID * 100 GR','124','BELLEZA EXPRESS SA','2025-02-28 17:53:01',  14977, 49827, 119, 53, 8311744)
			   ,('FVE','DB2','004007','2025-02-28 17:54:11','022025','CR','1005157627','YOJAN ALEXIS','GUEVARA CABALLERO ','MANZANA C NO.25-26 SECROT 5',' 3026092127','3489','CAMILO ','RODRIGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','6','29747.899159663866','5652.100840336132','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 18:00:59','35400','DBU','DEPOSITO BUCARAMANGA','2','4000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','2','0','0','','28/02/2025','','0','0','35400','78931633','DOVE DESO ROLL ON ORIGINAL *30 ML','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:54:11',  2947, 43713, 426, 249, 8311746)
			   ,('FVE','DB2','004007','2025-02-28 17:54:11','022025','CR','1005157627','YOJAN ALEXIS','GUEVARA CABALLERO ','MANZANA C NO.25-26 SECROT 5',' 3026092127','3489','CAMILO ','RODRIGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','6','29747.899159663866','5652.100840336132','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 18:00:59','35400','DBU','DEPOSITO BUCARAMANGA','2','4000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','2','0','0','','28/02/2025','','0','0','35400','78930841','REXONA DESO MINIROLLON V8 X 30 ML','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:54:11',  3132, 43766, 426, 249, 8311746)
			   ,('FVE','DB2','004007','2025-02-28 17:54:11','022025','CR','1005157627','YOJAN ALEXIS','GUEVARA CABALLERO ','MANZANA C NO.25-26 SECROT 5',' 3026092127','3489','CAMILO ','RODRIGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','6','29747.899159663866','5652.100840336132','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-02-28 18:00:59','35400','DBU','DEPOSITO BUCARAMANGA','1','19400.00000000','19400.00000000','16302.521008403','3097.4789915966','19400','1','0','0','','28/02/2025','','0','0','35400','7702006208604','SAVITAL SHAMPOO CON COLAGENO Y SABILA * 510 ML','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:54:11',  16890.8, 62303, 426, 249, 8311746)
			   ,('FVE','DP1','022248','2025-02-28 17:57:32','022025','CR','1090534653','JHONIER','SANCHEZ BURGOS','CALLE 32 NO.36-26',' 3227358678','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','14000','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 18:00:59','14000','50','DEPOSITO CUCUTA ','1','14000.00000000','14000.00000000','14000','0','14000','1','0','0','','28/02/2025','','0','0','14000','7702184011485','SULFATO FERROSO 300 MG * 100 TAB','249','ECAR','2025-02-28 17:57:32',  10185, 52790, 2, 19, 8311776)
			   ,('FVE','DB1','002099','2025-02-28 17:59:36','022025','CR','1003115092','KEINER RAFAEL','TORRES ALCINA','',' 3007450397','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','49495.79831932773','9404.201680672266','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:06:57','58900','DB','DEPOSITO BARRANQUILLA','1','39500.00000000','39500.00000000','33193.277310924','6306.7226890756','39500','1','0','0','','28/02/2025','','0','0','58900','7702006653305','SHAMPOO + ACONDICIONADOR DOVE RECONSTRUCCION COMPLETA * 370 ML (2)','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:59:36',  27451, 62321, 119, 53, 8311788)
			   ,('FVE','DB1','002099','2025-02-28 17:59:36','022025','CR','1003115092','KEINER RAFAEL','TORRES ALCINA','',' 3007450397','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','49495.79831932773','9404.201680672266','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:06:57','58900','DB','DEPOSITO BARRANQUILLA','1','19400.00000000','19400.00000000','16302.521008403','3097.4789915966','19400','1','0','0','','28/02/2025','','0','0','58900','7702006208598','SAVITAL ACOND COLAGENO Y SABILA * 490 ML','388','UNILEVER ANDINA COLOMBIA','2025-02-28 17:59:36',  13668.3, 62312, 119, 53, 8311788)
			   ,('FVE','DP1','022249','2025-02-28 18:02:39','022025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSE ALBERTO','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','2700','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-02-28 18:02:39','2700','50','DEPOSITO CUCUTA ','1','2700.00000000','2700.00000000','2700','0','2700','1','0','1','','28/02/2025','','2700','0','0','7702057077112','ALGODON MK * 25 GR','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-02-28 18:02:39',  1851, 42770, 2, 19, 8311152)
			   ,('FVE','DB1','002098','2025-02-28 18:03:01','022025','CR','1041771898','ADRI aacute N ENRIQUE','HERN aacute NDEZ RUIZ','CALLE 29A NO.10B-28 VILLA CARO',' 3001401377','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','58231.092436974795','9068.90756302521','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:09:41','67300','DB','DEPOSITO BARRANQUILLA','1','23800.00000000','23800.00000000','20000','3800','23800','1','0','0','','28/02/2025','','0','0','67300','7702123011613','MEXSANA TALCO * 150GR + 85 GR PROMO PACK','631','BAYER OTC','2025-02-28 18:03:01',  15910, 56176, 119, 53, 8311801)
			   ,('FVE','DB1','002098','2025-02-28 18:03:01','022025','CR','1041771898','ADRI aacute N ENRIQUE','HERN aacute NDEZ RUIZ','CALLE 29A NO.10B-28 VILLA CARO',' 3001401377','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','58231.092436974795','9068.90756302521','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:09:41','67300','DB','DEPOSITO BARRANQUILLA','2','3700.00000000','7400.00000000','6218.487394958','1181.512605042','7400','2','0','0','','28/02/2025','','0','0','67300','7702010972270','SPEED STICK  MINI CREMA  XTREME NIGHT * 30 GR','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 18:03:01',  2548, 47596, 119, 53, 8311801)
			   ,('FVE','DB1','002098','2025-02-28 18:03:01','022025','CR','1041771898','ADRI aacute N ENRIQUE','HERN aacute NDEZ RUIZ','CALLE 29A NO.10B-28 VILLA CARO',' 3001401377','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','58231.092436974795','9068.90756302521','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:09:41','67300','DB','DEPOSITO BARRANQUILLA','1','10500.00000000','10500.00000000','10500','0','10500','1','0','0','','28/02/2025','','0','0','67300','7706569001269','CLOTRIMAZOL CREMA TOPICA *40 GR','614','A.G. MEDICAMENTOS','2025-02-28 18:03:01',  4692.24, 31314, 119, 53, 8311801)
			   ,('FVE','DB1','002098','2025-02-28 18:03:01','022025','CR','1041771898','ADRI aacute N ENRIQUE','HERN aacute NDEZ RUIZ','CALLE 29A NO.10B-28 VILLA CARO',' 3001401377','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','6','58231.092436974795','9068.90756302521','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:09:41','67300','DB','DEPOSITO BARRANQUILLA','1','25599.99000000','25599.99000000','21512.605042017','4087.3949579832','25600','1','0','0','','28/02/2025','','0','0','67300','079400052919','REXONA CLINICAL MEN AZUL *48 GR','388','UNILEVER ANDINA COLOMBIA','2025-02-28 18:03:01',  17301, 43744, 119, 53, 8311801)
			   ,('FVE','DB1','002102','2025-02-28 18:06:01','022025','CR','1046693396','JORMAN DAVID','BUELVAS PADILLA','CALLE 113A NO.83-24',' 3011161085','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','16806.722689075632','3193.277310924368','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:21:06','20000','DB','DEPOSITO BARRANQUILLA','1','20000.00000000','20000.00000000','16806.722689076','3193.2773109244','20000','1','0','0','','28/02/2025','','0','0','20000','D1346','CABLE IPHONE','819','INOVY','2025-02-28 18:06:01',  7983, 51478, 119, 53, 8311817)
			   ,('FVE','DB1','002100','2025-02-28 18:11:33','022025','CR','1042453665','ARLIS ','DE LA HOZ YANETH ','CRA 7B NO.5-79 FERRY',' 3224065848','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','33193.27731092437','6306.722689075628','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-02-28 18:17:51','39500','DB','DEPOSITO BARRANQUILLA','1','39500.00000000','39500.00000000','33193.277310924','6306.7226890756','39500','1','0','0','','28/02/2025','','0','0','39500','7702006653305','SHAMPOO + ACONDICIONADOR DOVE RECONSTRUCCION COMPLETA * 370 ML (2)','388','UNILEVER ANDINA COLOMBIA','2025-02-28 18:11:33',  27451, 62321, 119, 53, 8311849)
			   ,('FVE','DP1','022250','2025-02-28 18:12:56','022025','CO','37398259','LILIANA ','RINC oacute N MEDINA','CALLE 20A 22 15 MUJERES DEL FU',' 3133135840','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','14537.81512605042','2762.18487394958','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 18:12:56','17300','50','DEPOSITO CUCUTA ','1','15300.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','1','0','1','','28/02/2025','','0','17300','0','7500435019811','H & S  SHAMPO 2EN1 SUAVE MANEJABLE *180 ML','336','PROCTER & GAMBLE COLOMBIA','2025-02-28 18:12:56',  9201, 53527, 2, 19, 8311409)
			   ,('FVE','DP1','022250','2025-02-28 18:12:56','022025','CO','37398259','LILIANA ','RINC oacute N MEDINA','CALLE 20A 22 15 MUJERES DEL FU',' 3133135840','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','14537.81512605042','2762.18487394958','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 18:12:56','17300','50','DEPOSITO CUCUTA ','2','1000.00000000','2000.00000000','1680.6722689076','319.32773109244','2000','2','0','1','','28/02/2025','','0','17300','0','7702645208041','ACIDO BORICO SOBRE LEON','263','LEON','2025-02-28 18:12:56',  506.25, 47127, 2, 19, 8311409)
			   ,('FVE','DP1','022251','2025-02-28 18:14:10','022025','CO','1090534835','MARIA FERNANDA','ACEVEDO LAZARO','AVENIDA 1 NO.1-25 CARLOS RAMIR',' 3023279745','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','20168.06722689076','3831.9327731092417','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 18:14:10','24000','50','DEPOSITO CUCUTA ','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','101','','28/02/2025','','24000','0','0','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-02-28 18:14:10',  6163, 24467, 2, 19, 8311713)
			   ,('FVE','DP1','022251','2025-02-28 18:14:10','022025','CO','1090534835','MARIA FERNANDA','ACEVEDO LAZARO','AVENIDA 1 NO.1-25 CARLOS RAMIR',' 3023279745','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','20168.06722689076','3831.9327731092417','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-02-28 18:14:10','24000','50','DEPOSITO CUCUTA ','1','16000.00000000','16000.00000000','13445.378151261','2554.6218487395','16000','1','0','101','','28/02/2025','','24000','0','0','4005900624116','NIVEA ACLARADO EFECTO SATIN ROLLON *50 ML','123','BDF (BEIERSDORF) ','2025-02-28 18:14:10',  9893, 42127, 2, 19, 8311713);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '022025' AND DECODBOD='00';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '022025' AND DECODBOD='00';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '022025' AND DECODBOD='00';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '022025' AND DECODBOD='00';
DELETE FROM consolida2 WHERE PERIODOESPE = '022025' AND CODSUCURSAL = '00';
