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','021596','2024-12-26 08:04:03','122024','CR','1090507448','KAREN','ASCANIO','AVENIDA 15 CALLE 12 BELISARIO ',' 3228296015','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','2','10000','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 08:29:13','10000','50','DEPOSITO CUCUTA ','1','10000.00000000','10000.00000000','10000','0','10000','1','0','0','','26/12/2024','','0','0','10000','7707019420722','RESFRYGRIP PLUS *10 CAP','130','LABQUIFAR PHARMACEUTICA','2024-12-26 08:04:03',  4326.5, 45904, 2, 19, 7999824)
			   ,('FVE','DB2','003829','2024-12-26 08:16:32','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','10','133361.34453781514','25338.65546218487','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 08:16:32','158700','DBU','DEPOSITO BUCARAMANGA','1','16000.00000000','16000.00000000','13445.378151261','2554.6218487395','16000','1','0','1','','26/12/2024','','0','158700','0','7501054526131','NIVEA ACLARADO EFECTO SATIN ROLLON *50 ML','123','BDF (BEIERSDORF) ','2024-12-26 08:16:32',  8146, 42127, 426, 249, 7999732)
			   ,('FVE','DB2','003829','2024-12-26 08:16:32','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','10','133361.34453781514','25338.65546218487','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 08:16:32','158700','DBU','DEPOSITO BUCARAMANGA','3','4900.00000000','14700.00000000','12352.941176471','2347.0588235294','14700','3','0','1','','26/12/2024','','0','158700','0','7702031401025','JOHNSON JABON BABY AVENA * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-26 08:16:32',  3093.139971, 28086, 426, 249, 7999732)
			   ,('FVE','DB2','003829','2024-12-26 08:16:32','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','10','133361.34453781514','25338.65546218487','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 08:16:32','158700','DBU','DEPOSITO BUCARAMANGA','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','1','','26/12/2024','','0','158700','0','78928503','DOVE DESO ROLLON DERMO ACLARANT *50 ML','388','UNILEVER ANDINA COLOMBIA','2024-12-26 08:16:32',  14286, 43708, 426, 249, 7999732)
			   ,('FVE','DB2','003829','2024-12-26 08:16:32','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','10','133361.34453781514','25338.65546218487','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 08:16:32','158700','DBU','DEPOSITO BUCARAMANGA','1','60000.00000000','60000.00000000','50420.168067227','9579.8319327731','60000','1','0','1','','26/12/2024','','0','158700','0','4005900491046','NIVEA BODY MILK NUTRITIVA PIEL E/SECA *1000 ML','123','BDF (BEIERSDORF) ','2024-12-26 08:16:32',  40880.43, 48662, 426, 249, 7999732)
			   ,('FVE','DB2','003829','2024-12-26 08:16:32','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','10','133361.34453781514','25338.65546218487','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 08:16:32','158700','DBU','DEPOSITO BUCARAMANGA','1','15700.00000000','15700.00000000','13193.277310924','2506.7226890756','15700','1','0','1','','26/12/2024','','0','158700','0','7509546063331','COLGATE CREMA TRIPLE ACCION *150 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-26 08:16:32',  8780, 48127, 426, 249, 7999732)
			   ,('FVE','DB2','003829','2024-12-26 08:16:32','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','10','133361.34453781514','25338.65546218487','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 08:16:32','158700','DBU','DEPOSITO BUCARAMANGA','1','36800.00000000','36800.00000000','30924.369747899','5875.6302521008','36800','1','0','1','','26/12/2024','','0','158700','0','7702006200981','REXONA V8 2X1 SPRAY *90 GR','388','UNILEVER ANDINA COLOMBIA','2024-12-26 08:16:32',  22141.944, 52340, 426, 249, 7999732)
			   ,('FVE','DP1','021615','2024-12-26 09:51:54','122024','CR','1143168041','OSCAR FABIAN ','OTERO RODRIGUEZ','CALLE 47 NO.44-152',' 3022070318','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','5','9600','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:49:54','9600','50','DEPOSITO CUCUTA ','4','2400.00000000','9600.00000000','9600','0','9600','0','4','0','','26/12/2024','','0','0','9600','7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2024-12-26 09:51:54',  37278, 55304, 2, 19, 8000972)
			   ,('FVE','DP1','021597','2024-12-26 10:06:02','122024','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','2184.8739495798322','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 10:06:27','2600','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','26/12/2024','','2600','0','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-12-26 10:06:02',  1613.7, 52184, 2, 19, 8001137)
			   ,('FVE','DB1','001990','2024-12-26 10:23:57','122024','CO','1007963867','CARLOS ANDRES','MEDINA MENDOZA','CALLE 14 NO.17B-144 LA LUZ',' 3243273899','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','23619.04761904762','1180.9523809523816','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-26 10:23:57','24800','DB','DEPOSITO BARRANQUILLA','1','24800.00000000','24800.00000000','23619.047619048','1180.9523809524','24800','1','0','0','','26/12/2024','','0','24800','0','7702049001637','AGUARDIENTE ANTIOQUEÑO *375ML VERDE S/AZUCAR','808','ANTIOQUIA AGUARDIENTE','2024-12-26 10:23:57',  18591, 58355, 119, 53, 8001310)
			   ,('FVE','DP1','021598','2024-12-26 10:28:44','122024','CO','1090516234','KEILA','CARRILLO PARRA ','CALLE 9 AVENIDA 19 NO.16 NUEVO',' 3138620788','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','2','18487.394957983193','3512.6050420168067','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 10:28:44','22000','50','DEPOSITO CUCUTA ','1','22000.00000000','22000.00000000','18487.394957983','3512.6050420168','22000','1','0','1','','26/12/2024','','1','21999','0','42277057','NIVEA C/FACIAL CUIDADO NUTRITIVO *100 ML','123','BDF (BEIERSDORF) ','2024-12-26 10:28:44',  11548.9977, 50792, 2, 19, 8001330)
			   ,('FVE','DP1','021599','2024-12-26 13:23:13','122024','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','49000','0','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-26 13:23:13','49000','50','DEPOSITO CUCUTA ','2','24500.00000000','49000.00000000','49000','0','49000','2','0','0','','26/12/2024','','49000','0','0','7702560000102','CITROMEL *310 ML ','219','JGB','2024-12-26 13:23:13',  18540.48, 27805, 2, 19, 8002454)
			   ,('FVE','DP1','021600','2024-12-26 13:57:27','122024','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','5546.218487394958','1053.7815126050416','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 14:09:48','6600','50','DEPOSITO CUCUTA ','1','2100.00000000','2100.00000000','1764.7058823529','335.29411764706','2100','1','0','1','','26/12/2024','','0','6600','0','7702024034186','COCOSETTE MAXI WAFER * 46 GR','776','NESTLE FOOD & BEVERAGE','2024-12-26 13:57:27',  1091, 38319, 2, 19, 8002671)
			   ,('FVE','DP1','021600','2024-12-26 13:57:27','122024','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','5546.218487394958','1053.7815126050416','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 14:09:48','6600','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','26/12/2024','','0','6600','0','7702010111587','COLGATE CREMA DENTAL TRIPLE EXTRA BLANCURA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-26 13:57:27',  2913, 48567, 2, 19, 8002671)
			   ,('FVE','DB2','003830','2024-12-26 14:21:41','122024','CO','1102550074','CRISTIAN ANDR eacute S','MART iacute NEZ ','CRA 21B NO.1A-33 PIEDECUESTA',' 3023652984','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','25630.25210084034','4869.747899159662','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2024-12-26 14:21:41','30500','DBU','DEPOSITO BUCARAMANGA','1','30500.00000000','30500.00000000','25630.25210084','4869.7478991597','30500','1','0','1','','26/12/2024','','0','30500','0','7702027479588','TENA SLIP CLASICO (ANTES BASIC) L X 9 UND','337','FAMILIA SANCELA','2024-12-26 14:21:41',  21113.1, 33297, 426, 249, 8002748)
			   ,('FVE','DP1','021601','2024-12-26 14:30:27','122024','CO','1090481181','YORLANDO ','DUARTE QUINTERO','CALLE 16 LN NO. 8-84 BARRIO CE',' 3142085335','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','57177.142857142855','2858.857142857145','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 14:30:27','60036','50','DEPOSITO CUCUTA ','1','61500.00000000','61500.00000000','57177.142857143','2858.8571428571','60036','1','0','1','','26/12/2024','','0','60036','0','7702673001089','VINO BLANCO GRAN CELEBRACION * 2600 ML','809','COMORIENTE','2024-12-26 14:30:27',  0, 65129, 2, 19, 8002754)
			   ,('FVE','DB2','003831','2024-12-26 14:33:49','122024','CO','1097489167','DANIELA CAROLINA ','BLANCO DUR aacute N ','CRA 9 OCCIDENTE 36-100',' 3142856435','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','7983.193277310925','1516.8067226890753','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 14:33:49','9500','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','1','','26/12/2024','','0','9500','0','7702010111501','COLGATE CREMA DENTAL T/ACCION *60 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-26 14:33:49',  2913.62454, 48361, 426, 249, 8000000)
			   ,('FVE','DB2','003831','2024-12-26 14:33:49','122024','CO','1097489167','DANIELA CAROLINA ','BLANCO DUR aacute N ','CRA 9 OCCIDENTE 36-100',' 3142856435','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','7983.193277310925','1516.8067226890753','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 14:33:49','9500','DBU','DEPOSITO BUCARAMANGA','1','4800.00000000','4800.00000000','4033.6134453782','766.38655462185','4800','1','0','1','','26/12/2024','','0','9500','0','7501006711615','PRO 425 SUAVE UND PROCTER & GAMBLE','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 14:33:49',  3170.664, 44951, 426, 249, 8000000)
			   ,('FVE','DP1','021602','2024-12-26 15:51:43','122024','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','2500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 15:52:17','2500','50','DEPOSITO CUCUTA ','1','2500.00000000','2500.00000000','2500','0','2500','0','1','0','','26/12/2024','','2500','0','0','7706263200654','PAX NOCHE PANELA-LIMON *24 SOBRES','405','EUROFARMA','2024-12-26 15:51:43',  43099, 45764, 2, 19, 8003608)
			   ,('FVE','DP1','021603','2024-12-26 16:07:28','122024','CR','1005064699','SAMUEL JOSUE','SOLANO ROJAS','AVENIDA 0 NO.3-330 BOCONO',' 3224552356','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','47310.924369747896','8989.0756302521','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:09:06','56300','50','DEPOSITO CUCUTA ','1','37500.00000000','37500.00000000','31512.605042017','5987.3949579832','37500','1','0','0','','26/12/2024','','0','0','56300','7500435158749','DESODORANTE GILLETTE HYDRA GEL * 82 GR X 2 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:07:28',  0, 65505, 2, 19, 8003762)
			   ,('FVE','DP1','021603','2024-12-26 16:07:28','122024','CR','1005064699','SAMUEL JOSUE','SOLANO ROJAS','AVENIDA 0 NO.3-330 BOCONO',' 3224552356','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','47310.924369747896','8989.0756302521','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:09:06','56300','50','DEPOSITO CUCUTA ','1','18800.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','1','0','0','','26/12/2024','','0','0','56300','7500435234818','CEPILLO ORAL B COMPLETE CLEAN MEDIO * 4 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:07:28',  0, 65513, 2, 19, 8003762)
			   ,('FVE','DP1','021604','2024-12-26 16:10:42','122024','CO','1004923811','BRAYAN ANDRES ','PLATA HERNANDEZ ','CALLE 10 AVENIDA 1 NO.9-49 COM',' 3134439122','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','9159.66386554622','1740.3361344537807','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:16:50','10900','50','DEPOSITO CUCUTA ','1','10900.00000000','10900.00000000','9159.6638655462','1740.3361344538','10900','1','0','1','','26/12/2024','','0','10900','0','7500435170949','CEPILLO ORAL B CLEAN COMPLETE BLACK MEDIO * 2 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:10:42',  0, 65506, 2, 19, 8003787)
			   ,('FVE','DP1','021606','2024-12-26 16:11:05','122024','CR','1092389349','ALEJANDRO','MIRANDA','CALLE 29 MANZANA J CASA 4 BARR',' 3115979075','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','69663.86554621848','13236.134453781513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:19:02','82900','50','DEPOSITO CUCUTA ','1','38000.00000000','38000.00000000','31932.773109244','6067.2268907563','38000','1','0','0','','26/12/2024','','0','0','82900','7506295348221','GILLETTE GEL FUSION AFEITAR HIDRATANTE *200 ML 198 GR','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:11:05',  26386.6, 33760, 2, 19, 8003806)
			   ,('FVE','DP1','021606','2024-12-26 16:11:05','122024','CR','1092389349','ALEJANDRO','MIRANDA','CALLE 29 MANZANA J CASA 4 BARR',' 3115979075','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','69663.86554621848','13236.134453781513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:19:02','82900','50','DEPOSITO CUCUTA ','1','44900.00000000','44900.00000000','37731.092436975','7168.9075630252','44900','1','0','0','','26/12/2024','','0','0','82900','7506195178645','CEPILLO ORAL B PRO-SALUD SUAVE 7 BEN * 5 UND','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:11:05',  0, 65509, 2, 19, 8003806)
			   ,('FVE','DP1','021605','2024-12-26 16:15:27','122024','CO','736941','NORIANNY PAOLA ','VILCHEZ SOTO ','CALLE 7AN # 15AE-52 BARRIO SAN',' 3143929208','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','47731.092436974795','9068.907563025208','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:16:50','56800','50','DEPOSITO CUCUTA ','1','18800.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','1','0','1','','26/12/2024','','56800','0','0','7500435234818','CEPILLO ORAL B COMPLETE CLEAN MEDIO * 4 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:15:27',  0, 65513, 2, 19, 8003830)
			   ,('FVE','DP1','021605','2024-12-26 16:15:27','122024','CO','736941','NORIANNY PAOLA ','VILCHEZ SOTO ','CALLE 7AN # 15AE-52 BARRIO SAN',' 3143929208','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','47731.092436974795','9068.907563025208','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:16:50','56800','50','DEPOSITO CUCUTA ','1','38000.00000000','38000.00000000','31932.773109244','6067.2268907563','38000','1','0','1','','26/12/2024','','56800','0','0','7506339315479','VENUS SKIN COMFORT BREEZE AFEITADORA','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:15:27',  28052, 64050, 2, 19, 8003830)
			   ,('FVE','DP1','021607','2024-12-26 16:19:32','122024','CR','1092364331','JAVIER YECID ','PIMIENTO GUERRERO','CALLE 17 NO.19-31 VALLESTER',' 3205792362','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','15798.319327731093','3001.680672268907','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:24:09','18800','50','DEPOSITO CUCUTA ','1','18800.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','1','0','0','','26/12/2024','','0','0','18800','7500435234818','CEPILLO ORAL B COMPLETE CLEAN MEDIO * 4 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:19:32',  0, 65513, 2, 19, 8003892)
			   ,('FVE','DP1','021608','2024-12-26 16:44:36','122024','CO','1193479640','JHOAN JOS eacute  ','HERRERA CELIS ','CALLE 4 NO.1-39 BARRIO LA VICT',' 3229272401','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','18151.26050420168','3448.739495798319','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:44:36','21600','50','DEPOSITO CUCUTA ','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','1','','26/12/2024','','2800','18800','0','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2024-12-26 16:44:36',  1823.4, 54241, 2, 19, 8003812)
			   ,('FVE','DP1','021608','2024-12-26 16:44:36','122024','CO','1193479640','JHOAN JOS eacute  ','HERRERA CELIS ','CALLE 4 NO.1-39 BARRIO LA VICT',' 3229272401','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','18151.26050420168','3448.739495798319','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:44:36','21600','50','DEPOSITO CUCUTA ','1','18800.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','1','0','1','','26/12/2024','','2800','18800','0','7500435234818','CEPILLO ORAL B COMPLETE CLEAN MEDIO * 4 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:44:36',  0, 65513, 2, 19, 8003812)
			   ,('FVE','DP1','021609','2024-12-26 16:46:49','122024','CO','1091378849','DANIXON YONEYKER','PE ntilde UELA GOMEZ','BARRIO EL CALLEJON',' 3143877138','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','42184.873949579836','8015.126050420167','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:47:20','50200','50','DEPOSITO CUCUTA ','2','15700.00000000','31400.00000000','26386.554621849','5013.4453781513','31400','2','0','1','','26/12/2024','','50200','0','0','7509546063331','COLGATE CREMA TRIPLE ACCION *150 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-26 16:46:49',  8780, 48127, 2, 19, 8004181)
			   ,('FVE','DP1','021609','2024-12-26 16:46:49','122024','CO','1091378849','DANIXON YONEYKER','PE ntilde UELA GOMEZ','BARRIO EL CALLEJON',' 3143877138','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','42184.873949579836','8015.126050420167','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 16:47:20','50200','50','DEPOSITO CUCUTA ','1','18800.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','1','0','1','','26/12/2024','','50200','0','0','7500435234818','CEPILLO ORAL B COMPLETE CLEAN MEDIO * 4 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 16:46:49',  0, 65513, 2, 19, 8004181)
			   ,('FVE','DP1','021610','2024-12-26 17:35:40','122024','CO','1001999319','CARLOS DANIEL','CARDONA DIAZ','',' 3023519363','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','15798.319327731093','3001.680672268907','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:35:40','18800','50','DEPOSITO CUCUTA ','1','18800.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','1','0','1','','27/12/2024','','18800','0','0','7500435234818','CEPILLO ORAL B COMPLETE CLEAN MEDIO * 4 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 17:35:40',  0, 65513, 2, 19, 8003822)
			   ,('FVE','DP1','021611','2024-12-26 17:42:03','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','31634.453781512606','3065.546218487394','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:42:03','34700','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','15500','0','15500','1','0','1','','27/12/2024','','0','34700','0','7707321981539','DIHIDROCODEINA 2.42MG/ML *120 ML','205','HUMAX PHARMACEUTICAL','2024-12-26 17:42:03',  6966.6666666667, 49898, 2, 19, 8001476)
			   ,('FVE','DP1','021611','2024-12-26 17:42:03','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','31634.453781512606','3065.546218487394','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:42:03','34700','50','DEPOSITO CUCUTA ','1','10900.00000000','10900.00000000','9159.6638655462','1740.3361344538','10900','1','0','1','','27/12/2024','','0','34700','0','7707194538168','MASGLO ESMALTE EVOLUCION GEL TIZA *13.5 ML','801','CERESCOS','2024-12-26 17:42:03',  7118.4, 62130, 2, 19, 8001476)
			   ,('FVE','DP1','021611','2024-12-26 17:42:03','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','31634.453781512606','3065.546218487394','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:42:03','34700','50','DEPOSITO CUCUTA ','1','8300.00000000','8300.00000000','6974.7899159664','1325.2100840336','8300','1','0','1','','27/12/2024','','0','34700','0','7702433330749','VOGUE ESMALTE EFECTO GEL SECRETO','245','VOGUE','2024-12-26 17:42:03',  0, 52238, 2, 19, 8001476)
			   ,('FVE','DP1','021612','2024-12-26 17:43:08','122024','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','137563.02521008407','26136.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:43:08','163700.00000000003','50','DEPOSITO CUCUTA ','1','32000.00000000','32000.00000000','26890.756302521','5109.243697479','32000','1','0','1','','27/12/2024','','163700','0','0','7702018037803','GILLETTE MACH 3 MAQ. SENSITIVE RECARGABLE','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 17:43:08',  22829, 40104, 2, 19, 8003854)
			   ,('FVE','DP1','021612','2024-12-26 17:43:08','122024','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','137563.02521008407','26136.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:43:08','163700.00000000003','50','DEPOSITO CUCUTA ','1','24200.00000000','24200.00000000','20336.134453782','3863.8655462185','24200','1','0','1','','27/12/2024','','163700','0','0','7500435177023','CREMA DENTAL ORAL B 3D WHITE * 67 ML X 2 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 17:43:08',  0, 65508, 2, 19, 8003854)
			   ,('FVE','DP1','021612','2024-12-26 17:43:08','122024','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','137563.02521008407','26136.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:43:08','163700.00000000003','50','DEPOSITO CUCUTA ','1','60000.00000000','60000.00000000','50420.168067227','9579.8319327731','60000','1','0','1','','27/12/2024','','163700','0','0','7702018037896','GILLETTE MACH 3 REP. SENSITIVE X 4 CARTUCHOS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 17:43:08',  42819, 40116, 2, 19, 8003854)
			   ,('FVE','DP1','021612','2024-12-26 17:43:08','122024','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','137563.02521008407','26136.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:43:08','163700.00000000003','50','DEPOSITO CUCUTA ','1','25800.00000000','25800.00000000','21680.672268908','4119.3277310924','25800','1','0','1','','27/12/2024','','163700','0','0','7891150089983','REXONA CLINICAL INTENSE FRESH AEROSOL *150 ML ','388','UNILEVER ANDINA COLOMBIA','2024-12-26 17:43:08',  19747.8992, 63963, 2, 19, 8003854)
			   ,('FVE','DP1','021612','2024-12-26 17:43:08','122024','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','137563.02521008407','26136.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:43:08','163700.00000000003','50','DEPOSITO CUCUTA ','1','6400.00000000','6400.00000000','5378.1512605042','1021.8487394958','6400','1','0','1','','27/12/2024','','163700','0','0','7707822752515','PILAS ALKALINA TRONEX AA * 2UND','950','TRONEX','2024-12-26 17:43:08',  2604, 62094, 2, 19, 8003854)
				  ,('FVE','DP1','021612','2024-12-26 17:43:08','122024','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','137563.02521008407','26136.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:43:08','163700.00000000003','50','DEPOSITO CUCUTA ','1','15300.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','1','0','1','','27/12/2024','','163700','0','0','7501086454198','PRO CEPILLO 900 MEDIANO 2 X 1 ','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 17:43:08',  9287.8002, 40002, 2, 19, 8003854);
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','021613','2024-12-26 17:44:59','122024','CO','1092353008','ANGID NELYSA','NAVARRO CASTIBLANCO','CRA 44 NO.64-44 EDIF LA GLORIA',' 3222842984','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','4600','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:45:28','4600','50','DEPOSITO CUCUTA ','2','2300.00000000','4600.00000000','4600','0','4600','0','2','1','','27/12/2024','','4600','0','0','7702057092757','IBUFLASH MIGRAN *30 CAP','382','TECNOQUIMICAS','2024-12-26 17:44:59',  50677.65, 58898, 2, 19, 8004834)
			   ,('FVE','DP1','021614','2024-12-26 17:46:05','122024','CR','1093751562','DIEGO ALEXANDER','NI ntilde O CASTILLO','CL 15A # 8-70 TIERRA LINDA LOS','5553105 3132555071','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','11764.70588235294','2235.2941176470586','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:49:21','14000','50','DEPOSITO CUCUTA ','1','8100.00000000','8100.00000000','6806.7226890756','1293.2773109244','8100','1','0','0','','27/12/2024','','0','0','14000','75062613','GILLETTE ESPUMA DE AFEITAR SENSITIVE * 57 ML','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 17:46:05',  3900.0528, 52600, 2, 19, 8004861)
			   ,('FVE','DP1','021614','2024-12-26 17:46:05','122024','CR','1093751562','DIEGO ALEXANDER','NI ntilde O CASTILLO','CL 15A # 8-70 TIERRA LINDA LOS','5553105 3132555071','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','11764.70588235294','2235.2941176470586','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-26 17:49:21','14000','50','DEPOSITO CUCUTA ','1','5900.00000000','5900.00000000','4957.9831932773','942.01680672269','5900','1','0','0','','27/12/2024','','0','0','14000','3014260019723','ORAL B CEPILLO KIDS MICKEY 3 ANOS','336','PROCTER & GAMBLE COLOMBIA','2024-12-26 17:46:05',  3894, 39985, 2, 19, 8004861)
			   ,('FVE','DB2','003832','2024-12-26 17:56:23','122024','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','13025.210084033613','2474.7899159663866','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-26 17:56:38','15500','DBU','DEPOSITO BUCARAMANGA','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','1','','27/12/2024','','0','15500','0','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-26 17:56:23',  9366, 24473, 426, 249, 8004938)
			   ,('FVE','DB2','003833','2024-12-27 08:42:04','122024','CO','1101360138','IVAN DANIEL','NOVA VILLALBA','CASTILLA REAL 1 MANZANA D CASA',' 3202944469','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','21','17647.058823529413','3352.9411764705874','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-27 08:42:04','21000','DBU','DEPOSITO BUCARAMANGA','10','2100.00000000','21000.00000000','17647.058823529','3352.9411764706','21000','10','0','88','','27/12/2024','','0','21000','0','7702024034186','COCOSETTE MAXI WAFER * 46 GR','776','NESTLE FOOD & BEVERAGE','2024-12-27 08:42:04',  1091, 38319, 426, 249, 8006755)
			   ,('FVE','DP1','021616','2024-12-27 09:03:05','122024','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','6','8900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 09:03:05','8900','50','DEPOSITO CUCUTA ','1','2900.00000000','2900.00000000','2900','0','2900','0','1','1','','27/12/2024','','8900','0','0','7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-12-27 09:03:05',  17652.33, 46200, 2, 19, 8006939)
			   ,('FVE','DP1','021616','2024-12-27 09:03:05','122024','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','6','8900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 09:03:05','8900','50','DEPOSITO CUCUTA ','4','1500.00000000','6000.00000000','6000','0','6000','0','4','1','','27/12/2024','','8900','0','0','7451079001543','DOLEX GRIPA 500 MG *12 TAB','616','HALEON (GLAXO OTC)','2024-12-27 09:03:05',  13707.9, 26534, 2, 19, 8006939)
			   ,('FVE','DB1','001992','2024-12-27 09:33:27','122024','CR','1093799237','IVAN ANDR eacute S ','REYES QUINTANA ','CALLE 3 NO. 5-50 DONA NIDIA CU','5812969 3219192760','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','15684.873949579833','415.12605042016776','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-27 18:22:15','16100','DB','DEPOSITO BARRANQUILLA','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','0','','28/12/2024','','0','0','16100','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-12-27 09:33:27',  1613.7, 52184, 119, 53, 8007299)
			   ,('FVE','DB1','001992','2024-12-27 09:33:27','122024','CR','1093799237','IVAN ANDR eacute S ','REYES QUINTANA ','CALLE 3 NO. 5-50 DONA NIDIA CU','5812969 3219192760','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','15684.873949579833','415.12605042016776','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-27 18:22:15','16100','DB','DEPOSITO BARRANQUILLA','1','13500.00000000','13500.00000000','13500','0','13500','1','0','0','','28/12/2024','','0','0','16100','7702605102808','SILIMARINA 150 MG * 20 TAB','193','GENFAR','2024-12-27 09:33:27',  17536.05, 26212, 119, 53, 8007299)
			   ,('FVE','DP1','021617','2024-12-27 10:56:49','122024','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','109075.63025210085','20724.369747899153','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 10:56:49','129800','50','DEPOSITO CUCUTA ','1','16400.00000000','16400.00000000','13781.512605042','2618.487394958','16400','1','0','1','','27/12/2024','','0','129800','0','7702035430090','LISTERINE CONTROL CALCULO * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-12-27 10:56:49',  10373.793, 28021, 2, 19, 7955313)
			   ,('FVE','DP1','021617','2024-12-27 10:56:49','122024','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','109075.63025210085','20724.369747899153','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 10:56:49','129800','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','27/12/2024','','0','129800','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-12-27 10:56:49',  1613.7, 52184, 2, 19, 7955313)
			   ,('FVE','DP1','021617','2024-12-27 10:56:49','122024','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','109075.63025210085','20724.369747899153','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 10:56:49','129800','50','DEPOSITO CUCUTA ','1','38000.00000000','38000.00000000','31932.773109244','6067.2268907563','38000','1','0','1','','27/12/2024','','0','129800','0','7506295348221','GILLETTE GEL FUSION AFEITAR HIDRATANTE *200 ML 198 GR','336','PROCTER & GAMBLE COLOMBIA','2024-12-27 10:56:49',  26386.6, 33760, 2, 19, 7955313)
			   ,('FVE','DP1','021617','2024-12-27 10:56:49','122024','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','109075.63025210085','20724.369747899153','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 10:56:49','129800','50','DEPOSITO CUCUTA ','1','25800.00000000','25800.00000000','21680.672268908','4119.3277310924','25800','1','0','1','','27/12/2024','','0','129800','0','7891150089983','REXONA CLINICAL INTENSE FRESH AEROSOL *150 ML ','388','UNILEVER ANDINA COLOMBIA','2024-12-27 10:56:49',  19747.8992, 63963, 2, 19, 7955313)
			   ,('FVE','DP1','021617','2024-12-27 10:56:49','122024','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','109075.63025210085','20724.369747899153','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 10:56:49','129800','50','DEPOSITO CUCUTA ','1','47000.00000000','47000.00000000','39495.798319328','7504.2016806723','47000','1','0','1','','27/12/2024','','0','129800','0','7500435132008','GILLETTE FUSION 5 MAQUINA DE AFEITAR * 1 ','336','PROCTER & GAMBLE COLOMBIA','2024-12-27 10:56:49',  0, 65278, 2, 19, 7955313)
			   ,('FVE','DP1','021618','2024-12-27 13:06:50','122024','CR','1127066591','JUSTO ANDERSSON ','PALENCIA RINC oacute N ','KDXB 84 MONTEVIDEO',' 3506172741','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','12','6554.621848739496','1245.3781512605037','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-27 13:11:36','7800','50','DEPOSITO CUCUTA ','10','500.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','0','10','0','','27/12/2024','','0','0','7800','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-12-27 13:06:50',  14986.5, 56535, 2, 19, 8008812)
			   ,('FVE','DP1','021618','2024-12-27 13:06:50','122024','CR','1127066591','JUSTO ANDERSSON ','PALENCIA RINC oacute N ','KDXB 84 MONTEVIDEO',' 3506172741','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','12','6554.621848739496','1245.3781512605037','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-27 13:11:36','7800','50','DEPOSITO CUCUTA ','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','0','','27/12/2024','','0','0','7800','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2024-12-27 13:06:50',  1823.4, 54241, 2, 19, 8008812)
			   ,('FVE','DP1','021619','2024-12-27 13:33:27','122024','CR','1193510750','JUAN SEBASTIAN ','BAUTISTA ORTIZ ','AVENIDA 12 NO.8DN-15 MARIA PAZ',' 3148738783','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','22016.806722689078','4183.193277310922','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 13:35:08','26200','50','DEPOSITO CUCUTA ','2','13100.00000000','26200.00000000','22016.806722689','4183.1932773109','26200','2','0','0','','27/12/2024','','0','0','26200','6920354824395','COLGATE C/DENTAL NATURAL EXTRACTS CARBON/MENTA *66 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-27 13:33:27',  8157.51, 56067, 2, 19, 8008936)
			   ,('FVE','DB1','001991','2024-12-27 13:58:38','122024','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','','','','','','2','3361.3445378151264','638.6554621848736','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-27 14:10:14','4000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','27/12/2024','','0','0','4000','7701021143655','WINNY TOALLITAS ALOE + VITAMINA E * 24 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-12-27 13:58:38',  2510, 43316, 119, 53, 8009073)
			   ,('FVE','DP1','021620','2024-12-27 14:33:27','122024','CO','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','9159.66386554622','1740.3361344537807','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 14:35:15','10900','50','DEPOSITO CUCUTA ','1','10900.00000000','10900.00000000','9159.6638655462','1740.3361344538','10900','1','0','1','','27/12/2024','','0','10900','0','7500435170949','CEPILLO ORAL B CLEAN COMPLETE BLACK MEDIO * 2 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-27 14:33:27',  0, 65506, 2, 19, 8009293)
			   ,('FVE','DP1','021621','2024-12-27 14:35:29','122024','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','29500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 14:35:29','29500','50','DEPOSITO CUCUTA ','1','29500.00000000','29500.00000000','29500','0','29500','1','0','1','','27/12/2024','','0','29500','0','7703538000025','ANTIPLAC-B ENJUAGUE BUCO SPRAY *180 ML','267','INTERLABS S.A.S.','2024-12-27 14:35:29',  19600, 30280, 2, 19, 8009310)
			   ,('FVE','DP1','021622','2024-12-27 14:36:00','122024','CR','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','108151.26050420168','20548.73949579832','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 14:38:27','128700','50','DEPOSITO CUCUTA ','1','128700.00000000','128700.00000000','108151.2605042','20548.739495798','128700','1','0','0','','27/12/2024','','0','0','128700','7703153033828','NUTRIGEL ADVANCE MANDARINA * 30 S/S','334','PROCAPS OTX','2024-12-27 14:36:00',  95157, 50908, 2, 19, 8009321)
			   ,('FVE','DP1','021623','2024-12-27 14:53:53','122024','CO','900929396-4','SSP ASISTENCIAS ','SAS','CL 0 B N 7 A 42','5781374 3007512180','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','','','','2','100840.33613445378','19159.663865546216','00','DEPOSITO CUCUTA','AUXFINANZAS2','2024-12-27 14:53:53','120000','50','DEPOSITO CUCUTA ','1','120000.00000000','120000.00000000','100840.33613445','19159.663865546','120000','1','0','0','','27/12/2024','','0','120000','0','D1969','SERVICIO DE PARQUEADERO','1053','SERVICIOS','2024-12-27 14:53:53',  0, 64854, 2, 19, 8009440)
			   ,('FVE','DB2','003834','2024-12-27 16:03:57','122024','CO','1095955906','JHON NICOLS ','SANDOVAL SILVA','CRA 16A NO.14B-12 BARRIO LOS B',' 3213246583','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','15841.176470588236','558.8235294117644','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-27 16:03:57','16400','DBU','DEPOSITO BUCARAMANGA','1','12900.00000000','12900.00000000','12900','0','12900','1','0','1','','27/12/2024','','0','16400','0','7706569001245','AZITROMICINA 500MG *3 TAB','614','A.G. MEDICAMENTOS','2024-12-27 16:03:57',  4719.6, 31223, 426, 249, 8006404)
			   ,('FVE','DB2','003834','2024-12-27 16:03:57','122024','CO','1095955906','JHON NICOLS ','SANDOVAL SILVA','CRA 16A NO.14B-12 BARRIO LOS B',' 3213246583','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','15841.176470588236','558.8235294117644','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-27 16:03:57','16400','DBU','DEPOSITO BUCARAMANGA','1','3500.00000000','3500.00000000','2941.1764705882','558.82352941176','3500','1','0','1','','27/12/2024','','0','16400','0','7702024056010','MILO NUGGETS *40 GR','776','NESTLE FOOD & BEVERAGE','2024-12-27 16:03:57',  2093, 36492, 426, 249, 8006404)
			   ,('FVE','DB2','003835','2024-12-27 16:05:57','122024','CR','1193460355','LUIS ALBERTO ','JIM eacute NEZ MAR iacute N ','CALLE 11 NO.26-17 ARENALES',' 3208394948','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','71155','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-27 16:41:38','71155','DBU','DEPOSITO BUCARAMANGA','1','74900.00000000','74900.00000000','71155','0','71155','1','0','0','','27/12/2024','','0','0','71155','7704232001752','FITOSTIMOLINE SOL *30 ML','178','EUROETIKA','2024-12-27 16:05:57',  64847, 50997, 426, 249, 8010005)
			   ,('FVE','DB2','003836','2024-12-27 16:42:48','122024','CR','1102549654','JUAN CAMILO ','VILLANOVA RUEDA ','CRA6C # 13-65 PIEDECUESTA SANT',' 3133522719','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','2','9200','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-27 16:45:52','9200','DBU','DEPOSITO BUCARAMANGA','1','9200.00000000','9200.00000000','9200','0','9200','1','0','0','','27/12/2024','','0','0','9200','7705959012663','DOXICICLINA 100 MG * 10 TAB','193','GENFAR','2024-12-27 16:42:48',  6403, 26023, 426, 249, 8010323)
			   ,('FVE','DP1','021624','2024-12-27 16:49:40','122024','CO','1094046024','JOEL','OTALVAREZ ','PALMERAS PARTE BAJA',' 3134607035','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','11','4201.680672268908','798.319327731092','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 16:51:51','5000','50','DEPOSITO CUCUTA ','10','500.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','0','10','1','','27/12/2024','','5000','0','0','7702184828908','VITAMINA C + ZINC NARANJA * 100 TAB','249','ECAR','2024-12-27 16:49:40',  14986.5, 56535, 2, 19, 8010362)
			   ,('FVE','DB2','003837','2024-12-27 17:04:58','122024','CR','1097781524','JOHAN NICOL aacute S ','FLOREZ ROJAS','MANZANA C CASA 17, BARILOCHE 1',' 3244170946','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','18823.529411764706','3576.4705882352937','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-27 17:11:17','22400','DBU','DEPOSITO BUCARAMANGA','1','22400.00000000','22400.00000000','18823.529411765','3576.4705882353','22400','1','0','0','','27/12/2024','','0','0','22400','7506306213906','AXE ICE CHILL EFECTO FRIO SPRAY *150 ML','388','UNILEVER ANDINA COLOMBIA','2024-12-27 17:04:58',  13309, 54512, 426, 249, 8010500)
			   ,('FVE','DP1','021625','2024-12-27 18:05:16','122024','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','2','14000','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-27 18:21:08','14000','50','DEPOSITO CUCUTA ','1','14000.00000000','14000.00000000','14000','0','14000','1','0','1','','28/12/2024','','14000','0','0','7703763334018','OXIMETAZOLINA 0.05 % *15 ML','261','LA SANTE GENERICO','2024-12-27 18:05:16',  9233, 41154, 2, 19, 8011010)
			   ,('FVE','DB1','001993','2024-12-27 18:24:57','122024','CO','1001782737','BRAYAN ENRIQUE ','POLO MURILLO ','CALLE 50B NO.3A-09 SOLEDAD',' 3013130195','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','30100','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-27 18:29:03','30100','DB','DEPOSITO BARRANQUILLA','1','10900.00000000','10900.00000000','10900','0','10900','1','0','1','','28/12/2024','','0','30100','0','7702057062880','CLOBEGEN CREMA * 20 GR','654','MK ETICOS CONVENIO','2024-12-27 18:24:57',  8070.96, 61271, 119, 53, 8011137)
			   ,('FVE','DB1','001993','2024-12-27 18:24:57','122024','CO','1001782737','BRAYAN ENRIQUE ','POLO MURILLO ','CALLE 50B NO.3A-09 SOLEDAD',' 3013130195','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','30100','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-27 18:29:03','30100','DB','DEPOSITO BARRANQUILLA','1','19200.00000000','19200.00000000','19200','0','19200','1','0','1','','28/12/2024','','0','30100','0','7703689000448','CYCLOFEM 0.5 ML AMP + JERINGA  ','344','PROFAMILIA','2024-12-27 18:24:57',  16509.1, 40547, 119, 53, 8011137)
			   ,('FVE','DP1','021626','2024-12-28 07:48:37','122024','CR','1090481181','YORLANDO ','DUARTE QUINTERO','CALLE 16 LN NO. 8-84 BARRIO CE',' 3142085335','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','2','12900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-28 07:51:48','12900','50','DEPOSITO CUCUTA ','1','12900.00000000','12900.00000000','12900','0','12900','1','0','0','','28/12/2024','','0','0','12900','7706569001245','AZITROMICINA 500MG *3 TAB','614','A.G. MEDICAMENTOS','2024-12-28 07:48:37',  4719.6, 31223, 2, 19, 8012246)
			   ,('FVE','DB2','003843','2024-12-28 08:45:18','122024','CR','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','32596.638655462186','303.36134453781506','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 12:50:44','32900','DBU','DEPOSITO BUCARAMANGA','2','12900.00000000','25800.00000000','25800','0','25800','2','0','0','','28/12/2024','','0','0','32900','7706569001245','AZITROMICINA 500MG *3 TAB','614','A.G. MEDICAMENTOS','2024-12-28 08:45:18',  4719.6, 31223, 426, 249, 8012539)
			   ,('FVE','DB2','003843','2024-12-28 08:45:18','122024','CR','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','32596.638655462186','303.36134453781506','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 12:50:44','32900','DBU','DEPOSITO BUCARAMANGA','1','1900.00000000','1900.00000000','1596.6386554622','303.36134453782','1900','1','0','0','','28/12/2024','','0','0','32900','7707228366507','APLICADORES DE MADERA PUNTA DE ALGODON *20 UNID','429','ALFA SAFE','2024-12-28 08:45:18',  831.25, 42561, 426, 249, 8012539)
			   ,('FVE','DB2','003843','2024-12-28 08:45:18','122024','CR','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','32596.638655462186','303.36134453781506','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 12:50:44','32900','DBU','DEPOSITO BUCARAMANGA','1','5200.00000000','5200.00000000','5200','0','5200','1','0','0','','28/12/2024','','0','0','32900','7702560000010','AGUA OXIGENADA *120 ML ','219','JGB','2024-12-28 08:45:18',  4082, 27760, 426, 249, 8012539)
			   ,('FVE','DP1','021627','2024-12-28 09:14:19','122024','CO','1010086333','ESNEIDER STYVEN','BECERRA BECERRA','',' 3008081615','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','71092.43697478992','13507.563025210082','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-28 09:14:19','84600','50','DEPOSITO CUCUTA ','1','84600.00000000','84600.00000000','71092.43697479','13507.56302521','84600','1','0','1','','28/12/2024','','84600','0','0','7702132001018','CENTRUM SILVER WOMEN 50+ *60 TAB','616','HALEON (GLAXO OTC)','2024-12-28 09:14:19',  61928.97282, 60323, 2, 19, 8012318)
			   ,('FVE','DP1','021628','2024-12-28 10:10:00','122024','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','12','28378.1512605042','2921.8487394957974','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-28 10:10:00','31300','50','DEPOSITO CUCUTA ','10','1300.00000000','13000.00000000','13000','0','13000','0','10','1','','28/12/2024','','31300','0','0','7702057074838','METOCARBAMOL 750 MG * 20 TAB','654','MK ETICOS CONVENIO','2024-12-28 10:10:00',  17920.85, 43129, 2, 19, 8013212)
			   ,('FVE','DP1','021628','2024-12-28 10:10:00','122024','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','12','28378.1512605042','2921.8487394957974','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-28 10:10:00','31300','50','DEPOSITO CUCUTA ','1','18300.00000000','18300.00000000','15378.151260504','2921.8487394958','18300','1','0','1','','28/12/2024','','31300','0','0','7509546054650','COLGATE CREMA DENTAL LUMINOUS WHITE *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-28 10:10:00',  11322.18, 24441, 2, 19, 8013212)
			   ,('FVE','DB2','003838','2024-12-28 10:32:11','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','23719.32773109244','1580.6722689075627','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:36:15','25300','DBU','DEPOSITO BUCARAMANGA','1','3200.00000000','3200.00000000','2689.0756302521','510.9243697479','3200','1','0','0','','28/12/2024','','0','0','25300','7707194537109','ADMISS ESMALTE LUCHO *10 ML','801','CERESCOS','2024-12-28 10:32:11',  2057.28, 55482, 426, 249, 8013418)
			   ,('FVE','DB2','003838','2024-12-28 10:32:11','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','23719.32773109244','1580.6722689075627','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:36:15','25300','DBU','DEPOSITO BUCARAMANGA','1','6700.00000000','6700.00000000','5630.2521008403','1069.7478991597','6700','1','0','0','','28/12/2024','','0','0','25300','7707773839723','MASGLO ESMALTE BRILLO DESTELLOS * 13.5 ML','801','CERESCOS','2024-12-28 10:32:11',  4722.24, 57102, 426, 249, 8013418)
				  ,('FVE','DB2','003838','2024-12-28 10:32:11','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','23719.32773109244','1580.6722689075627','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:36:15','25300','DBU','DEPOSITO BUCARAMANGA','1','13400.00000000','13400.00000000','13400','0','13400','1','0','0','','28/12/2024','','0','0','25300','7707397791056','MEBUCAINA FORTE *10 TAB','199','GRUPO UNIPHARM SA','2024-12-28 10:32:11',  11385.4725, 54455, 426, 249, 8013418);
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','DB2','003838','2024-12-28 10:32:11','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','23719.32773109244','1580.6722689075627','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:36:15','25300','DBU','DEPOSITO BUCARAMANGA','1','2000.00000000','2000.00000000','2000','0','2000','1','0','0','','28/12/2024','','0','0','25300','7707282990793','VENDA ELASTICA 3 X 5 YARDAS PIEL BEGUT','892','BEGUT SEVENPHARMA IMPORTACIONES','2024-12-28 10:32:11',  1548.5, 50088, 426, 249, 8013418)
			   ,('FVE','DB2','003839','2024-12-28 10:34:57','122024','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','16386.55462184874','3113.4453781512602','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:36:31','19500','DBU','DEPOSITO BUCARAMANGA','1','19500.00000000','19500.00000000','16386.554621849','3113.4453781513','19500','1','0','0','','28/12/2024','','0','0','19500','7702645201844','CLORURO DE MAGNESIO *1 LIBRA ','263','LEON','2024-12-28 10:34:57',  9450, 30219, 426, 249, 8013444)
			   ,('FVE','DB2','003840','2024-12-28 10:36:54','122024','CR','1065870246','ANDR eacute S FELIPE ','PERALTA BUITRAGO ','CRA 16C NO.60A-65 LA ESMERALDA',' 3042297170','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','91512.6050420168','17387.39495798319','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:46:11','108900','DBU','DEPOSITO BUCARAMANGA','1','66500.00000000','66500.00000000','55882.352941176','10617.647058824','66500','1','0','0','','28/12/2024','','0','0','108900','7702113043372','TANGA BLOQ ADULTOS SPF 100 CREMA *130 ML','278','RECAMIER','2024-12-28 10:36:54',  40689.075, 61916, 426, 249, 8013453)
			   ,('FVE','DB2','003840','2024-12-28 10:36:54','122024','CR','1065870246','ANDR eacute S FELIPE ','PERALTA BUITRAGO ','CRA 16C NO.60A-65 LA ESMERALDA',' 3042297170','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','91512.6050420168','17387.39495798319','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:46:11','108900','DBU','DEPOSITO BUCARAMANGA','1','23400.00000000','23400.00000000','19663.865546218','3736.1344537815','23400','1','0','0','','28/12/2024','','0','0','108900','4005800137679','NIVEA CREMA *60 GR','123','BDF (BEIERSDORF) ','2024-12-28 10:36:54',  13651.6398, 23202, 426, 249, 8013453)
			   ,('FVE','DB2','003840','2024-12-28 10:36:54','122024','CR','1065870246','ANDR eacute S FELIPE ','PERALTA BUITRAGO ','CRA 16C NO.60A-65 LA ESMERALDA',' 3042297170','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','91512.6050420168','17387.39495798319','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 10:46:11','108900','DBU','DEPOSITO BUCARAMANGA','1','19000.00000000','19000.00000000','15966.386554622','3033.6134453782','19000','1','0','0','','28/12/2024','','0','0','108900','4005808377534','NIVEA LIP CARE FRUTY SHINE *4.8 GR','123','BDF (BEIERSDORF) ','2024-12-28 10:36:54',  13372.8, 23233, 426, 249, 8013453)
			   ,('FVE','DB1','001994','2024-12-28 10:40:44','122024','CR','1044607386','JOHAN DAVID','ROMO RUIZ ','CALLE 52 NO.4C-36 CARRIZAL',' 3044634016','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','3781.512605042017','718.4873949579828','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-28 10:46:11','4500','DB','DEPOSITO BARRANQUILLA','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','0','','28/12/2024','','0','0','4500','7702010470486','LADY SPEED STICK CLINICAL MINI POWDER CREMA *30 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-28 10:40:44',  2474.568, 53264, 119, 53, 8013492)
			   ,('FVE','DB2','003841','2024-12-28 11:02:49','122024','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','12521.008403361344','2378.991596638655','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 11:04:59','14900','DBU','DEPOSITO BUCARAMANGA','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','28/12/2024','','0','0','14900','7707363369616','MASGLO ESMALTE UÑAS MORDIDAS','801','CERESCOS','2024-12-28 11:02:49',  5263.68, 56584, 426, 249, 8013658)
			   ,('FVE','DB2','003841','2024-12-28 11:02:49','122024','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','12521.008403361344','2378.991596638655','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 11:04:59','14900','DBU','DEPOSITO BUCARAMANGA','1','3199.91000000','3199.91000000','2689.0756302521','510.9243697479','3200','1','0','0','','28/12/2024','','0','0','14900','7707773838436','ADMISS ESMALTE OSCAR * 10 ML','801','CERESCOS','2024-12-28 11:02:49',  0, 55490, 426, 249, 8013658)
			   ,('FVE','DB2','003841','2024-12-28 11:02:49','122024','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','5','12521.008403361344','2378.991596638655','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 11:04:59','14900','DBU','DEPOSITO BUCARAMANGA','1','3199.91000000','3199.91000000','2689.0756302521','510.9243697479','3200','1','0','0','','28/12/2024','','0','0','14900','7707363361290','ADMISS ESMALTE MARIO * 10 ML','801','CERESCOS','2024-12-28 11:02:49',  1773.12, 59131, 426, 249, 8013658)
			   ,('FVE','DB2','003842','2024-12-28 11:32:00','122024','CO','1097489167','DANIELA CAROLINA ','BLANCO DUR aacute N ','CRA 9 OCCIDENTE 36-100',' 3142856435','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','12900','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-28 11:32:00','12900','DBU','DEPOSITO BUCARAMANGA','1','12900.00000000','12900.00000000','12900','0','12900','1','0','1','','28/12/2024','','0','12900','0','7702605100491','AZITROMICINA 500 MG * 3 TAB','193','GENFAR','2024-12-28 11:32:00',  8831.2, 25916, 426, 249, 8013619)
			   ,('FVE','DP1','021629','2024-12-28 12:05:24','122024','CO','13515975','OSCAR FERNANDO ','GOMEZ GOMEZ ','CRA 46 NO.96-20',' 3229513277','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','2','7800','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-28 12:05:24','7800','50','DEPOSITO CUCUTA ','1','7800.00000000','7800.00000000','7800','0','7800','0','1','1','','28/12/2024','','7800','0','0','7702207188620','SMECTA *10 S/S','633','ABBOTT CONSUMER HEALTH CARE','2024-12-28 12:05:24',  64773.85, 31775, 2, 19, 8014167)
			   ,('FVE','DB1','001995','2024-12-28 13:00:45','122024','CR','1193548352','HUMBERTO LUIS','RODR iacute GUEZ CASTILLO ','CRA 33 NO.17-31 REBOLO',' 3107713261','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','2941.1764705882356','558.8235294117644','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-28 13:03:01','3500','DB','DEPOSITO BARRANQUILLA','1','3500.00000000','3500.00000000','2941.1764705882','558.82352941176','3500','1','0','0','','28/12/2024','','0','0','3500','7702277865964','TOALLITAS ARRURRU AVENA Y KARITE *20 UND','124','BELLEZA EXPRESS SA','2024-12-28 13:00:45',  2006, 54335, 119, 53, 8014579)
			   ,('FVE','DP1','021630','2024-12-28 16:33:55','122024','CR','1004844958','ANGIE CAMILA ','MORENO RINCON','CALLE 20A NO.22-15',' 3192134878','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','4','28000','0','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-28 16:40:38','28000','50','DEPOSITO CUCUTA ','1','28000.00000000','28000.00000000','28000','0','28000','1','0','0','','29/12/2024','','0','0','28000','7707019402131','DOSALDIN GOTAS * 30 ML','130','LABQUIFAR PHARMACEUTICA','2024-12-28 16:33:55',  15138.5, 45887, 2, 19, 8015518)
			   ,('FVE','DP1','021631','2024-12-28 16:39:17','122024','CR','1064186455','JOS eacute  GUILLERMO','BELTR aacute N URANGO','CLL 31 CR 11 ALTOS DE BUENA VI',' 3195762890','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','2','26974.789915966387','5125.210084033613','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-28 16:41:45','32100','50','DEPOSITO CUCUTA ','1','32100.00000000','32100.00000000','26974.789915966','5125.2100840336','32100','1','0','0','','29/12/2024','','0','0','32100','7702502017700','MEXSANA TALCO * 300 GR + 85 GR PROMO','631','BAYER OTC','2024-12-28 16:39:17',  22670, 33173, 2, 19, 8015535)
			   ,('FVE','DP1','021632','2024-12-28 20:22:17','122024','CR','1127361595','JORGE','NIETO','CRA 14 NO.25-12 GRAN COLOMBIA',' 3155354339','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','13900','0','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-28 20:29:07','13900','50','DEPOSITO CUCUTA ','1','13900.00000000','13900.00000000','13900','0','13900','1','0','0','','29/12/2024','','0','0','13900','7707355053363','NOXPIRIN F JBE PED *120 ML','626','SIEGFRIED CONSUMO','2024-12-28 20:22:17',  6100.9, 31061, 2, 19, 8016141)
			   ,('FVE','DP1','021633','2024-12-30 07:50:48','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','70963.02521008404','3336.974789915965','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 07:50:48','74300.00000000001','50','DEPOSITO CUCUTA ','3','15500.00000000','46500.00000000','46500','0','46500','3','0','1','','30/12/2024','','9500','64800','0','7707321981539','DIHIDROCODEINA 2.42MG/ML *120 ML','205','HUMAX PHARMACEUTICAL','2024-12-30 07:50:48',  6966.6666666667, 49898, 2, 19, 8009283)
			   ,('FVE','DP1','021633','2024-12-30 07:50:48','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','70963.02521008404','3336.974789915965','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 07:50:48','74300.00000000001','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','30/12/2024','','9500','64800','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-12-30 07:50:48',  1613.7, 52184, 2, 19, 8009283)
			   ,('FVE','DP1','021633','2024-12-30 07:50:48','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','70963.02521008404','3336.974789915965','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 07:50:48','74300.00000000001','50','DEPOSITO CUCUTA ','1','6900.00000000','6900.00000000','6900','0','6900','1','0','1','','30/12/2024','','9500','64800','0','7702026177874','NOSOTRAS INVISIBLE RAPIGEL *10 + OBSEQUIO','337','FAMILIA SANCELA','2024-12-30 07:50:48',  5071.5, 50903, 2, 19, 8009283)
			   ,('FVE','DP1','021633','2024-12-30 07:50:48','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','70963.02521008404','3336.974789915965','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 07:50:48','74300.00000000001','50','DEPOSITO CUCUTA ','1','18300.00000000','18300.00000000','15378.151260504','2921.8487394958','18300','1','0','1','','30/12/2024','','9500','64800','0','7702018951185','GILLETTE ESPUMA DE AFEITAR FOAMY SENSITIVE *150 GR','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 07:50:48',  10425.6, 40074, 2, 19, 8009283)
			   ,('FVE','DP1','021634','2024-12-30 09:22:40','122024','CR','1073327359','MANUELA ALEJANDRA','DIEZ CARDENAS','CALLE 18 NO.1-61 AEROPUERTO',' 3106963265','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','2','2900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 09:37:48','2900','50','DEPOSITO CUCUTA ','1','2900.00000000','2900.00000000','2900','0','2900','0','1','0','','30/12/2024','','0','0','2900','7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-12-30 09:22:40',  17652.33, 46200, 2, 19, 8019157)
			   ,('FVE','DB1','001996','2024-12-30 09:34:08','122024','CR','1193548352','HUMBERTO LUIS','RODR iacute GUEZ CASTILLO ','CRA 33 NO.17-31 REBOLO',' 3107713261','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','23613.44537815126','4486.55462184874','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 09:37:42','28100','DB','DEPOSITO BARRANQUILLA','1','28100.00000000','28100.00000000','23613.445378151','4486.5546218487','28100','1','0','0','','30/12/2024','','0','0','28100','7702123013693','ACID MANTLE TATTOO CREMA * 30GR','631','BAYER OTC','2024-12-30 09:34:08',  20000, 63588, 119, 53, 8019261)
			   ,('FVE','DP1','021635','2024-12-30 09:48:12','122024','CR','60291739','ELCIDA ','SUAREZ RODRIGUEZ','CALLE 17 NO. 19-36 VALLESTER L',' 3183666721','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','2184.8739495798322','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 11:37:05','2600','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','0','','30/12/2024','','0','0','2600','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-12-30 09:48:12',  1613.7, 52184, 2, 19, 8019379)
			   ,('FVE','DP1','021636','2024-12-30 12:09:44','122024','CO','1082848063','JOS iuml  iquest  frac12  ALBERTO ','VELEZ MARTINEZ ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','5800','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 12:09:44','5800','50','DEPOSITO CUCUTA ','2','2900.00000000','5800.00000000','5800','0','5800','0','2','1','','30/12/2024','','5800','0','0','7702057840310','SAL DE FRUTAS LUA * 50 S/S','382','TECNOQUIMICAS','2024-12-30 12:09:44',  114420.62, 43290, 2, 19, 7872296)
			   ,('FVE','DP1','021637','2024-12-30 13:34:31','122024','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','10672.268907563026','2027.731092436974','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 13:37:12','12700','50','DEPOSITO CUCUTA ','1','12700.00000000','12700.00000000','10672.268907563','2027.731092437','12700','1','0','0','','30/12/2024','','0','0','12700','7702277152347','TOALLITAS ARRURRU ALOE Y MANZANILLA *120 UND ','124','BELLEZA EXPRESS SA','2024-12-30 13:34:31',  7004, 55329, 2, 19, 8020860)
			   ,('FVE','DB1','001997','2024-12-30 13:58:17','122024','CR','1007174299','JAIME JUNIOR ','CORRALES ROMERO ','CRA 33 NO.17-31',' 3044504160','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','3949.5798319327732','750.4201680672268','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 14:04:12','4700','DB','DEPOSITO BARRANQUILLA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','30/12/2024','','0','0','4700','7509546677002','PALMOLIVE JABON INTENSA RENOVACION *120 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 13:58:17',  2234.682, 52692, 119, 53, 8020958)
			   ,('FVE','DP1','021638','2024-12-30 14:00:06','122024','CO','1093747409','JUAN CAMILO','YANES SANCHEZ','CALLE 24 #6A-40 PORTAL DE LOS ',' 3016556754','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','840.3361344537816','159.6638655462184','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 14:03:38','1000','50','DEPOSITO CUCUTA ','1','1000.00000000','1000.00000000','840.33613445378','159.66386554622','1000','1','0','1','','30/12/2024','','1000','0','0','D1037, 75010659','H & S SHAMPOO SOBRE SURTIDO','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 14:00:06',  572.093904, 32623, 2, 19, 8020947)
			   ,('FVE','DB2','003844','2024-12-30 14:16:33','122024','CR','1020223396','JOHAN SEBASTIAN','PEREZ RAMIREZ','DIAGONAL 16 NO.17-17',' 3153285566','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','10903.361344537814','2071.6386554621854','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 14:36:05','12975','DBU','DEPOSITO BUCARAMANGA','1','3199.91000000','3199.91000000','2689.0756302521','510.9243697479','3200','1','0','0','','30/12/2024','','0','0','12975','7707194534597','ADMISS ESMALTE JUNIOR * 10 ML ','801','CERESCOS','2024-12-30 14:16:33',  0, 59125, 426, 249, 8021035)
			   ,('FVE','DB2','003844','2024-12-30 14:16:33','122024','CR','1020223396','JOHAN SEBASTIAN','PEREZ RAMIREZ','DIAGONAL 16 NO.17-17',' 3153285566','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','10903.361344537814','2071.6386554621854','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 14:36:05','12975','DBU','DEPOSITO BUCARAMANGA','1','9775.00000000','9775.00000000','8214.2857142857','1560.7142857143','9775','1','0','0','','30/12/2024','','0','0','12975','7703378002159','POLVO COMPACTO SIN ESPEJO SAMY # 02.BEIGE','1013','COSMETICOS SAMY S.A.','2024-12-30 14:16:33',  5432.6, 63917, 426, 249, 8021035)
			   ,('FVE','DB2','003845','2024-12-30 14:36:19','122024','CR','1007676712','JOHAN FERNANDO ','VERGEL FEREZ ','MANZANA 0 CASA 15 PISO 3 MIRAD',' 3106570475','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','20600','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 14:55:14','20600','DBU','DEPOSITO BUCARAMANGA','1','20600.00000000','20600.00000000','20600','0','20600','1','0','0','','30/12/2024','','0','0','20600','7590002012468','VICK VAPORUB *50 GR','820','PROCTER & GAMBLE CHC','2024-12-30 14:36:19',  13460.70525, 40254, 426, 249, 8021124)
			   ,('FVE','DB2','003846','2024-12-30 14:58:11','122024','CR','1101360138','IVAN DANIEL','NOVA VILLALBA','CASTILLA REAL 1 MANZANA D CASA',' 3202944469','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','12016.806722689076','2283.193277310924','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 15:34:56','14300','DBU','DEPOSITO BUCARAMANGA','1','14300.00000000','14300.00000000','12016.806722689','2283.1932773109','14300','1','0','0','','30/12/2024','','0','0','14300','7707232090535','JABON DE AZUFRE *90 GR','271','NATURAL FRESHLY','2024-12-30 14:58:11',  5979.015, 30324, 426, 249, 8021258)
			   ,('FVE','DB1','001998','2024-12-30 15:07:10','122024','CR','1001788897','JESUS ENRIQUE','AHUMADA MARTINEZ','CALLE 16 NO.10-54 LA ESPERANZA',' 3042341867','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','8','33274.78991596639','5125.210084033613','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 15:33:05','38400','DB','DEPOSITO BARRANQUILLA','1','6300.00000000','6300.00000000','6300','0','6300','1','0','0','','30/12/2024','','0','0','38400','7702184020258','CLORFENIRAMINA JBE *120 ML','249','ECAR','2024-12-30 15:07:10',  3071.6666666667, 48626, 119, 53, 8021291)
			   ,('FVE','DB1','001998','2024-12-30 15:07:10','122024','CR','1001788897','JESUS ENRIQUE','AHUMADA MARTINEZ','CALLE 16 NO.10-54 LA ESPERANZA',' 3042341867','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','8','33274.78991596639','5125.210084033613','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 15:33:05','38400','DB','DEPOSITO BARRANQUILLA','1','32100.00000000','32100.00000000','26974.789915966','5125.2100840336','32100','1','0','0','','30/12/2024','','0','0','38400','7702502017700','MEXSANA TALCO * 300 GR + 85 GR PROMO','631','BAYER OTC','2024-12-30 15:07:10',  22670, 33173, 119, 53, 8021291)
			   ,('FVE','DP1','021639','2024-12-30 16:27:21','122024','CO','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','38823.529411764706','7376.470588235293','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 16:28:10','46200','50','DEPOSITO CUCUTA ','1','21700.00000000','21700.00000000','18235.294117647','3464.7058823529','21700','1','0','1','','30/12/2024','','0','46200','0','7702123011545','MEXSANA CLASICO AEROSOL *260 ML','631','BAYER OTC','2024-12-30 16:27:21',  13203, 33107, 2, 19, 8021775)
			   ,('FVE','DP1','021639','2024-12-30 16:27:21','122024','CO','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','38823.529411764706','7376.470588235293','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 16:28:10','46200','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','1','','30/12/2024','','0','46200','0','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 16:27:21',  9366, 24473, 2, 19, 8021775)
			   ,('FVE','DP1','021639','2024-12-30 16:27:21','122024','CO','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','38823.529411764706','7376.470588235293','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 16:28:10','46200','50','DEPOSITO CUCUTA ','2','4500.00000000','9000.00000000','7563.025210084','1436.974789916','9000','2','0','1','','30/12/2024','','0','46200','0','7702045563726','BALANCE CLINICAL CREMA MINI MEN * 32 GR','203','HENKEL COLOMBIANA','2024-12-30 16:27:21',  2819, 52775, 2, 19, 8021775)
			   ,('FVE','DP1','021640','2024-12-30 16:34:55','122024','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','2','25210.084033613446','4789.915966386554','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 16:34:55','30000','50','DEPOSITO CUCUTA ','1','30000.00000000','30000.00000000','25210.084033613','4789.9159663866','30000','1','0','1','','30/12/2024','','30000','0','0','7708109834054','COLAGENO + BIOTINA CJA * 30 CAPS','1000','NATURALMENTE','2024-12-30 16:34:55',  7000, 60289, 2, 19, 8021819)
			   ,('FVE','DP1','021641','2024-12-30 16:46:21','122024','CO','1093785231','YELITZA KATHERINE','SILVA CONTRERAS','CALLE 3 NO.1-37 SAN MATEO','5845734 3115081821','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','14400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 16:46:21','14400','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','4500','0','4500','1','0','1','','30/12/2024','','14400','0','0','7708971288665','ESBELTA TOALLA HIGIÉNICA NOCTURNA TELA * 10 UNID','1055','PROVICOL','2024-12-30 16:46:21',  0, 65244, 2, 19, 8021864)
			   ,('FVE','DP1','021641','2024-12-30 16:46:21','122024','CO','1093785231','YELITZA KATHERINE','SILVA CONTRERAS','CALLE 3 NO.1-37 SAN MATEO','5845734 3115081821','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','14400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 16:46:21','14400','50','DEPOSITO CUCUTA ','1','9900.00000000','9900.00000000','9900','0','9900','1','0','1','','30/12/2024','','14400','0','0','7708971288641','ESBELTA TOALLA HIGIÉNICA TELA * 30 UNID','1055','PROVICOL','2024-12-30 16:46:21',  0, 65307, 2, 19, 8021864)
			   ,('FVE','DP1','021642','2024-12-30 16:55:34','122024','CR','830016128-5','PHARMA MARKET ','LTDA','AUT NORTE 114-78 OF 101','3176453849 3176453849','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' M.ACOSTA Autoriza la Venta por Cupo. December 30, 2024, 5:01 pm','','41399','8187758.823529412','1555674.176470588','00','DEPOSITO CUCUTA','M.ACOSTA','2024-12-30 17:01:59','9743433','50','DEPOSITO CUCUTA ','41398','235.36000000','9743433.28000000','8187758.8235294','1555674.1764706','9743433','41398','0','0','','30/12/2024','','0','0','9743433','D1147','VENTA DE FORMULAS A CLOSE UP MES DE NOVIEMBRE  2024','348','PROVEEDORES VARIOS','2024-12-30 16:55:34',  0, 41226, 2, 19, 8021977)
			   ,('FVE','DP1','021643','2024-12-30 17:03:55','122024','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','46974.789915966394','8925.21008403361','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:03:55','55900','50','DEPOSITO CUCUTA ','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','1','','30/12/2024','','0','55900','0','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:03:55',  5102.97003, 24467, 2, 19, 8022015)
				  ,('FVE','DP1','021643','2024-12-30 17:03:55','122024','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','46974.789915966394','8925.21008403361','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:03:55','55900','50','DEPOSITO CUCUTA ','4','4700.00000000','18800.00000000','15798.319327731','3001.6806722689','18800','4','0','1','','30/12/2024','','0','55900','0','7702031414346','JOHNSON JABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:03:55',  2601.3, 56006, 2, 19, 8022015);
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','021643','2024-12-30 17:03:55','122024','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','46974.789915966394','8925.21008403361','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:03:55','55900','50','DEPOSITO CUCUTA ','1','29100.00000000','29100.00000000','24453.781512605','4646.218487395','29100','1','0','1','','30/12/2024','','0','55900','0','047400097728','GILLETTE GEL COOL WAVE *113 GR P/ESPE','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:03:55',  21484, 40049, 2, 19, 8022015)
			   ,('FVE','DP1','021644','2024-12-30 17:07:03','122024','CO','1093757452','RICARDO ALEXIS','HERNANDEZ DEMOYA','CALLE 6B NO.13A-69 MIRADORES D',' 3186344384','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','69663.8655462185','13236.13445378151','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:07:03','82900','50','DEPOSITO CUCUTA ','3','3900.00000000','11700.00000000','9831.9327731092','1868.0672268908','11700','3','0','1','','30/12/2024','','0','82900','0','7702006402200','REXONA JABON BAMBOO FRESH BARRA *110 GR','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:07:03',  2808.456952, 51004, 2, 19, 8022014)
			   ,('FVE','DP1','021644','2024-12-30 17:07:03','122024','CO','1093757452','RICARDO ALEXIS','HERNANDEZ DEMOYA','CALLE 6B NO.13A-69 MIRADORES D',' 3186344384','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','69663.8655462185','13236.13445378151','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:07:03','82900','50','DEPOSITO CUCUTA ','1','32000.00000000','32000.00000000','26890.756302521','5109.243697479','32000','1','0','1','','30/12/2024','','0','82900','0','650240029158','MEDICASP SHAMPOO *100 ML','194','GENOMMA LABORATORIO COLOMBIA','2024-12-30 17:07:03',  21075.2367, 46791, 2, 19, 8022014)
			   ,('FVE','DP1','021644','2024-12-30 17:07:03','122024','CO','1093757452','RICARDO ALEXIS','HERNANDEZ DEMOYA','CALLE 6B NO.13A-69 MIRADORES D',' 3186344384','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','69663.8655462185','13236.13445378151','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:07:03','82900','50','DEPOSITO CUCUTA ','1','34700.00000000','34700.00000000','29159.663865546','5540.3361344538','34700','1','0','1','','30/12/2024','','0','82900','0','7702035432445','LISTERINE CONTROL CALCULO * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:07:03',  19743.2754, 28024, 2, 19, 8022014)
			   ,('FVE','DP1','021644','2024-12-30 17:07:03','122024','CO','1093757452','RICARDO ALEXIS','HERNANDEZ DEMOYA','CALLE 6B NO.13A-69 MIRADORES D',' 3186344384','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','69663.8655462185','13236.13445378151','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:07:03','82900','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','30/12/2024','','0','82900','0','7702010111587','COLGATE CREMA DENTAL TRIPLE EXTRA BLANCURA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:07:03',  2913, 48567, 2, 19, 8022014)
			   ,('FVE','DP1','021645','2024-12-30 17:08:41','122024','CO','1090518110','SOF iacute A ','RAMIREZ ','CALLE 4A NO. 14-45 LOMAS DE BO',' 3118253134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','9747.899159663866','1852.1008403361338','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:10:52','11600','50','DEPOSITO CUCUTA ','1','11600.00000000','11600.00000000','9747.8991596639','1852.1008403361','11600','1','0','1','','30/12/2024','','11600','0','0','7891010035617','JOHNSON CREMA LIQ ORIGINAL * 100 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:08:41',  7375.86, 28004, 2, 19, 8022047)
			   ,('FVE','DB1','001999','2024-12-30 17:10:00','122024','CR','1007116962','CRISTIAN CAMILO','VIDES OBREDOR','CALLE 51C NO.3D-47',' 3054479249','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','28200','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 17:13:50','28200','DB','DEPOSITO BARRANQUILLA','3','7800.00000000','23400.00000000','23400','0','23400','0','3','0','','30/12/2024','','0','0','28200','7702605101580','KETOROLACO * 5 AMP','193','GENFAR','2024-12-30 17:10:00',  37000, 26088, 119, 53, 8022073)
			   ,('FVE','DB1','001999','2024-12-30 17:10:00','122024','CR','1007116962','CRISTIAN CAMILO','VIDES OBREDOR','CALLE 51C NO.3D-47',' 3054479249','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','5','28200','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 17:13:50','28200','DB','DEPOSITO BARRANQUILLA','1','4800.00000000','4800.00000000','4800','0','4800','0','1','0','','30/12/2024','','0','0','28200','7702896001231','DEXABLAS 8 MG * 5 AMP','132','BLASKOV','2024-12-30 17:10:00',  7950, 23704, 119, 53, 8022073)
			   ,('FVE','DP1','021646','2024-12-30 17:11:51','122024','CO','1090429584','JESSICA  KATHERINE','NI Ntilde O CARO ','CALLE 21 NO. 18-62 SAN JOSE CU','3142233732 3142233732','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','34789.91596638656','6610.084033613442','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:11:51','41400','50','DEPOSITO CUCUTA ','1','41400.00000000','41400.00000000','34789.915966387','6610.0840336134','41400','1','0','1','','30/12/2024','','41400','0','0','7702132011048','CENTRUM SILVER + 50 * 30 TAB','616','HALEON (GLAXO OTC)','2024-12-30 17:11:51',  30484, 49164, 2, 19, 8022081)
			   ,('FVE','DP1','021647','2024-12-30 17:13:08','122024','CO','1004821121','YURLEY ','DURAN ','CALLE 15 NO:19-60 NUEVO HORIZO',' 3228709991','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','37815.12605042017','7184.873949579829','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:13:08','45000','50','DEPOSITO CUCUTA ','1','45000.00000000','45000.00000000','37815.12605042','7184.8739495798','45000','1','0','1','','30/12/2024','','0','45000','0','7702035870407','LUBRIDERM REPARACION INTENSIVA * 400 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:13:08',  28218.6327, 28153, 2, 19, 8022077)
			   ,('FVE','DP1','021648','2024-12-30 17:17:54','122024','CO','1092353617','GONZALO','SUAREZ FLOREZ','',' 3118366507','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','16890.75630252101','3209.2436974789907','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:17:54','20100','50','DEPOSITO CUCUTA ','1','12100.00000000','12100.00000000','10168.067226891','1931.9327731092','12100','1','0','1','','30/12/2024','','0','20100','0','7702502705300','MEXSANA TALCO * 85 GR S.PLOUGH','631','BAYER OTC','2024-12-30 17:17:54',  8750, 33174, 2, 19, 8022128)
			   ,('FVE','DP1','021648','2024-12-30 17:17:54','122024','CO','1092353617','GONZALO','SUAREZ FLOREZ','',' 3118366507','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','16890.75630252101','3209.2436974789907','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:17:54','20100','50','DEPOSITO CUCUTA ','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','1','','30/12/2024','','0','20100','0','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:17:54',  5102.97003, 24467, 2, 19, 8022128)
			   ,('FVE','DB1','002000','2024-12-30 17:18:57','122024','CO','1042460032','JAIRO ALONSO','TORRES YANES','CRA 54 NO.14-23 BARRIO 1RA DE ',' 3024390967','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','20840.33613445378','3959.6638655462193','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 17:18:57','24800','DB','DEPOSITO BARRANQUILLA','1','24800.00000000','24800.00000000','20840.336134454','3959.6638655462','24800','1','0','1','','30/12/2024','','0','24800','0','7702113043914','SHAMPOO MUSS CASPA CANNABIS * 400 ML','278','RECAMIER','2024-12-30 17:18:57',  0, 63707, 119, 53, 8022130)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','1','300.00000000','300.00000000','300','0','300','1','0','1','','30/12/2024','','0','98400','0','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2024-12-30 17:19:12',  0, 44347, 2, 19, 8022110)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','1','28500.00000000','28500.00000000','23949.579831933','4550.4201680672','28500','1','0','1','','30/12/2024','','0','98400','0','7702057089290','YODORA CREMA * 60 GR GRATIS 32 GR','889','TECNOQUIMICAS CONSUMO','2024-12-30 17:19:12',  18555.21, 42934, 2, 19, 8022110)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','1','11000.00000000','11000.00000000','9243.6974789916','1756.3025210084','11000','1','0','1','','30/12/2024','','0','98400','0','7702277120902','MENTICOL AMARILLO FCO *130 ML','124','BELLEZA EXPRESS SA','2024-12-30 17:19:12',  6552, 46903, 2, 19, 8022110)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','30/12/2024','','0','98400','0','7702010470486','LADY SPEED STICK CLINICAL MINI POWDER CREMA *30 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:19:12',  2474.568, 53264, 2, 19, 8022110)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','2','1200.00000000','2400.00000000','2016.8067226891','383.19327731092','2400','2','0','1','','30/12/2024','','0','98400','0','7702024007203','MORENITAS GALLETA *24 GR','776','NESTLE FOOD & BEVERAGE','2024-12-30 17:19:12',  669, 38407, 2, 19, 8022110)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','2','4600.00000000','9200.00000000','7731.0924369748','1468.9075630252','9200','2','0','1','','30/12/2024','','0','98400','0','4891228530136','SCHICK QUATTRO TITANIUM DESECHABLE X 1  ','180','EVEREADY DE COLOMBIA','2024-12-30 17:19:12',  2931.66336, 25501, 2, 19, 8022110)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','2','8000.00000000','16000.00000000','13445.378151261','2554.6218487395','16000','2','0','1','','30/12/2024','','0','98400','0','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:19:12',  5102.97003, 24467, 2, 19, 8022110)
			   ,('FVE','DP1','021649','2024-12-30 17:19:12','122024','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','11','82736.97478991597','15663.02521008403','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:19:12','98400','50','DEPOSITO CUCUTA ','1','26500.00000000','26500.00000000','22268.907563025','4231.0924369748','26500','1','0','1','','30/12/2024','','0','98400','0','7501006721133','PANTENE SHAMPOO RESTAURACION *400 ML  ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:19:12',  16740.6879, 40230, 2, 19, 8022110)
			   ,('FVE','DB1','002001','2024-12-30 17:20:15','122024','CR','1007963867','CARLOS ANDRES','MEDINA MENDOZA','CALLE 14 NO.17B-144 LA LUZ',' 3243273899','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','22857.142857142855','4342.857142857143','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 17:45:02','27200','DB','DEPOSITO BARRANQUILLA','1','15300.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','1','0','0','','30/12/2024','','0','0','27200','7500435138017','H & S SHAMPO PURIFICACION CAPILAR *180 ML','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:20:15',  9200.8329, 56014, 119, 53, 8022151)
			   ,('FVE','DB1','002001','2024-12-30 17:20:15','122024','CR','1007963867','CARLOS ANDRES','MEDINA MENDOZA','CALLE 14 NO.17B-144 LA LUZ',' 3243273899','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','3','22857.142857142855','4342.857142857143','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 17:45:02','27200','DB','DEPOSITO BARRANQUILLA','1','11900.00000000','11900.00000000','10000','1900','11900','1','0','0','','30/12/2024','','0','0','27200','7509546670522','SPEED STICK PRACTI-GEL XTREME NIGHT *70 GR ','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:20:15',  5040, 59469, 119, 53, 8022151)
			   ,('FVE','DP1','021650','2024-12-30 17:20:49','122024','CO','1004999037','JULIETH DANIELA','GUARIN CHAVEZ','CALLE 7 NO.16-91',' 3114568028','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','9747.899159663866','1852.1008403361338','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:23:42','11600','50','DEPOSITO CUCUTA ','1','11600.00000000','11600.00000000','9747.8991596639','1852.1008403361','11600','1','0','1','','30/12/2024','','11600','0','0','7891010035617','JOHNSON CREMA LIQ ORIGINAL * 100 ML','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:20:49',  7375.86, 28004, 2, 19, 8022148)
			   ,('FVE','DP1','021651','2024-12-30 17:23:07','122024','CO','1090534835','MARIA FERNANDA','ACEVEDO LAZARO','AVENIDA 1 NO.1-25 CARLOS RAMIR',' 3023279745','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','8571.428571428572','1628.5714285714284','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:23:07','10200','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','43','','30/12/2024','','10200','0','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:23:07',  3375, 24465, 2, 19, 8022100)
			   ,('FVE','DP1','021651','2024-12-30 17:23:07','122024','CO','1090534835','MARIA FERNANDA','ACEVEDO LAZARO','AVENIDA 1 NO.1-25 CARLOS RAMIR',' 3023279745','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','8571.428571428572','1628.5714285714284','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:23:07','10200','50','DEPOSITO CUCUTA ','1','4900.00000000','4900.00000000','4117.6470588235','782.35294117647','4900','1','0','43','','30/12/2024','','10200','0','0','7702031900870','JOHNSON JABON BABY ANTES DE DORMIR * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:23:07',  3093.116829, 28082, 2, 19, 8022100)
			   ,('FVE','DB2','003847','2024-12-30 17:25:10','122024','CO','1090519336','JHONATAN DAVID ','ZERPA VILLAMIZAR ','MZ D15 CASA 6 TORCOROMA 2 TORC','5768090 3507990281','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','47142.85714285714','8957.142857142855','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:25:10','56099.99999999999','DBU','DEPOSITO BUCARAMANGA','1','29200.00000000','29200.00000000','24537.81512605','4662.1848739496','29200','1','0','1','','30/12/2024','','0','56100','0','7702006404303','TALCO REXONA EFFICIENT SPRAY 210 ML X2 UND','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:25:10',  16920, 59190, 426, 249, 8022147)
			   ,('FVE','DB2','003847','2024-12-30 17:25:10','122024','CO','1090519336','JHONATAN DAVID ','ZERPA VILLAMIZAR ','MZ D15 CASA 6 TORCOROMA 2 TORC','5768090 3507990281','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','47142.85714285714','8957.142857142855','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:25:10','56099.99999999999','DBU','DEPOSITO BUCARAMANGA','1','14900.00000000','14900.00000000','12521.008403361','2378.9915966387','14900','1','0','1','','30/12/2024','','0','56100','0','7509546653532','COLGATE CREMA DENTAL TOTAL12 ANTI SARRO *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:25:10',  9219.42, 56561, 426, 249, 8022147)
			   ,('FVE','DB2','003847','2024-12-30 17:25:10','122024','CO','1090519336','JHONATAN DAVID ','ZERPA VILLAMIZAR ','MZ D15 CASA 6 TORCOROMA 2 TORC','5768090 3507990281','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','47142.85714285714','8957.142857142855','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:25:10','56099.99999999999','DBU','DEPOSITO BUCARAMANGA','1','7000.00000000','7000.00000000','5882.3529411765','1117.6470588235','7000','1','0','1','','30/12/2024','','0','56100','0','7702006301442','TALCO REXONA EFFICIENT X 55 GR','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:25:10',  3603.2181, 44092, 426, 249, 8022147)
			   ,('FVE','DB2','003847','2024-12-30 17:25:10','122024','CO','1090519336','JHONATAN DAVID ','ZERPA VILLAMIZAR ','MZ D15 CASA 6 TORCOROMA 2 TORC','5768090 3507990281','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','47142.85714285714','8957.142857142855','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:25:10','56099.99999999999','DBU','DEPOSITO BUCARAMANGA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','30/12/2024','','0','56100','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:25:10',  2765.121, 40145, 426, 249, 8022147)
			   ,('FVE','DB2','003848','2024-12-30 17:27:01','122024','CO','1095957979','DARLY YULYTZA ','ROA RUEDA','CALLE 6H NO.32-39',' 3108637007','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','2','21764.70588235294','4135.2941176470595','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:30:58','25900','DBU','DEPOSITO BUCARAMANGA','1','25900.00000000','25900.00000000','21764.705882353','4135.2941176471','25900','1','0','1','','30/12/2024','','0','25900','0','7506306214989','REXONA CLINICAL EXPERT WOMEN CLASSIC SPRAY * 150 ML','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:27:01',  15401, 56420, 426, 249, 8022194)
			   ,('FVE','DP1','021652','2024-12-30 17:28:20','122024','CO','1090438621','SERGIO GABRIEL ','PAEZ APONTE','CALLE 21 A NO.69 SAN MARTIN',' 3174246376','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','30252.100840336137','5747.899159663863','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:28:20','36000','50','DEPOSITO CUCUTA ','1','26500.00000000','26500.00000000','22268.907563025','4231.0924369748','26500','1','0','1','','30/12/2024','','36000','0','0','7500435138000','H & S SHAMPOO PURIFICACION CAPILAR * 375 ML','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:28:20',  16210.275, 56015, 2, 19, 8022178)
			   ,('FVE','DP1','021652','2024-12-30 17:28:20','122024','CO','1090438621','SERGIO GABRIEL ','PAEZ APONTE','CALLE 21 A NO.69 SAN MARTIN',' 3174246376','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','30252.100840336137','5747.899159663863','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:28:20','36000','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','30/12/2024','','36000','0','0','7702045200324','BALANCE CLINICAL CREMA MINI  WOMEN * 32 GR','203','HENKEL COLOMBIANA','2024-12-30 17:28:20',  2640.0846, 52774, 2, 19, 8022178)
			   ,('FVE','DP1','021652','2024-12-30 17:28:20','122024','CO','1090438621','SERGIO GABRIEL ','PAEZ APONTE','CALLE 21 A NO.69 SAN MARTIN',' 3174246376','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','30252.100840336137','5747.899159663863','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:28:20','36000','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','30/12/2024','','36000','0','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:28:20',  2765.121, 40145, 2, 19, 8022178)
			   ,('FVE','DP1','021653','2024-12-30 17:29:47','122024','CO','1091384385','LUIS JESUS ','SIERRA MOROS ','CALLE 4 CRA 11 BARRIO JOSE FEL',' 3203764959','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','21344.537815126052','4055.46218487395','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:30:58','25400','50','DEPOSITO CUCUTA ','1','15300.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','1','0','1','','30/12/2024','','0','25400','0','7500435019484','H & S SHAMPOO MEN 3EN1 CONTROL CASPA *180 ML','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:29:47',  9200.8329, 54219, 2, 19, 8022210)
			   ,('FVE','DP1','021653','2024-12-30 17:29:47','122024','CO','1091384385','LUIS JESUS ','SIERRA MOROS ','CALLE 4 CRA 11 BARRIO JOSE FEL',' 3203764959','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','21344.537815126052','4055.46218487395','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:30:58','25400','50','DEPOSITO CUCUTA ','1','10100.00000000','10100.00000000','8487.3949579832','1612.6050420168','10100','1','0','1','','30/12/2024','','0','25400','0','7891010560737','JOHNSON COPITOS PAGUE 60 LLEVE 75 UND','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:29:47',  6233.7849, 27985, 2, 19, 8022210)
			   ,('FVE','DB2','003849','2024-12-30 17:30:28','122024','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','7','50090.75630252101','5109.243697478991','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:30:28','55200','DBU','DEPOSITO BUCARAMANGA','2','11600.00000000','23200.00000000','23200','0','23200','2','0','1','','30/12/2024','','0','55200','0','7896116861139','DIANE 35 *21 TAB ','120','BAYER FARMA','2024-12-30 17:30:28',  8915, 22928, 426, 249, 8022131)
			   ,('FVE','DB2','003849','2024-12-30 17:30:28','122024','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','7','50090.75630252101','5109.243697478991','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:30:28','55200','DBU','DEPOSITO BUCARAMANGA','1','14100.00000000','14100.00000000','11848.739495798','2251.2605042017','14100','1','0','1','','30/12/2024','','0','55200','0','7702277028147','ARRURRU SHAMPOO CABELLO CLARO * 220 ML','124','BELLEZA EXPRESS SA','2024-12-30 17:30:28',  9393, 45373, 426, 249, 8022131)
			   ,('FVE','DB2','003849','2024-12-30 17:30:28','122024','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','7','50090.75630252101','5109.243697478991','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:30:28','55200','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','1','','30/12/2024','','0','55200','0','7702031414346','JOHNSON JABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:30:28',  2601.3, 56006, 426, 249, 8022131)
			   ,('FVE','DB2','003849','2024-12-30 17:30:28','122024','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','7','50090.75630252101','5109.243697478991','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:30:28','55200','DBU','DEPOSITO BUCARAMANGA','1','4900.00000000','4900.00000000','4117.6470588235','782.35294117647','4900','1','0','1','','30/12/2024','','0','55200','0','7702031401025','JOHNSON JABON BABY AVENA * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:30:28',  3093.139971, 28086, 426, 249, 8022131)
				  ,('FVE','DB2','003849','2024-12-30 17:30:28','122024','CO','1093886374','WILLIAN MIGUEL ','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','7','50090.75630252101','5109.243697478991','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:30:28','55200','DBU','DEPOSITO BUCARAMANGA','1','8300.00000000','8300.00000000','6974.7899159664','1325.2100840336','8300','1','0','1','','30/12/2024','','0','55200','0','7702026032142','POMYS RUEDITAS ALGODON *60','337','FAMILIA SANCELA','2024-12-30 17:30:28',  5776.2, 40372, 426, 249, 8022131);
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','021654','2024-12-30 17:31:23','122024','CO','1004924606','YURI ALEXANDRA','GARCIA PEREZ','CALLE 1N NO.5N-27 BARRIO SANTA',' 3114922356','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','5800','0','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:31:23','5800','50','DEPOSITO CUCUTA ','2','2900.00000000','5800.00000000','5800','0','5800','0','2','1','','30/12/2024','','0','5800','0','7707232095769','MIELTERTOS PASTILLAS MASTICABLES *12 S/S','271','NATURAL FRESHLY','2024-12-30 17:31:23',  17652.33, 46200, 2, 19, 8022162)
			   ,('FVE','DP1','021655','2024-12-30 17:32:18','122024','CO','1090466899','DEIVER FABI aacute N','TORRES MIRANDA','CALLE 13 SUR AV 7 K 111-16 BAR',' 3013680911','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','140380.67226890757','6019.327731092436','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:32:18','146400','50','DEPOSITO CUCUTA ','1','16400.00000000','16400.00000000','13781.512605042','2618.487394958','16400','1','0','1','','30/12/2024','','0','146400','0','7702035833815','LISTERINE CUIDADO TOTAL * 180 ML ','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:32:18',  10373.8104, 28038, 2, 19, 8022192)
			   ,('FVE','DP1','021655','2024-12-30 17:32:18','122024','CO','1090466899','DEIVER FABI aacute N','TORRES MIRANDA','CALLE 13 SUR AV 7 K 111-16 BAR',' 3013680911','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','140380.67226890757','6019.327731092436','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:32:18','146400','50','DEPOSITO CUCUTA ','1','14900.00000000','14900.00000000','12521.008403361','2378.9915966387','14900','1','0','1','','30/12/2024','','0','146400','0','7509546653532','COLGATE CREMA DENTAL TOTAL12 ANTI SARRO *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:32:18',  9219.42, 56561, 2, 19, 8022192)
			   ,('FVE','DP1','021655','2024-12-30 17:32:18','122024','CO','1090466899','DEIVER FABI aacute N','TORRES MIRANDA','CALLE 13 SUR AV 7 K 111-16 BAR',' 3013680911','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','140380.67226890757','6019.327731092436','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:32:18','146400','50','DEPOSITO CUCUTA ','1','74500.00000000','74500.00000000','74500','0','74500','1','0','1','','30/12/2024','','0','146400','0','676194963485','MULTI - MEN * 100 TABS','906','ALFA VITAMINS','2024-12-30 17:32:18',  44631, 61329, 2, 19, 8022192)
			   ,('FVE','DP1','021655','2024-12-30 17:32:18','122024','CO','1090466899','DEIVER FABI aacute N','TORRES MIRANDA','CALLE 13 SUR AV 7 K 111-16 BAR',' 3013680911','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','140380.67226890757','6019.327731092436','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:32:18','146400','50','DEPOSITO CUCUTA ','2','17100.00000000','34200.00000000','34200','0','34200','2','0','1','','30/12/2024','','0','146400','0','7702132008307','TODAY LONG ACTION *3 PRESERVATIVOS  ','616','HALEON (GLAXO OTC)','2024-12-30 17:32:18',  14129.1, 39151, 2, 19, 8022192)
			   ,('FVE','DP1','021655','2024-12-30 17:32:18','122024','CO','1090466899','DEIVER FABI aacute N','TORRES MIRANDA','CALLE 13 SUR AV 7 K 111-16 BAR',' 3013680911','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','7','140380.67226890757','6019.327731092436','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:32:18','146400','50','DEPOSITO CUCUTA ','1','6400.00000000','6400.00000000','5378.1512605042','1021.8487394958','6400','1','0','1','','30/12/2024','','0','146400','0','7702010130625','COLGATE CEPILLO EXTRA CLEAN DURA','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:32:18',  3807, 48362, 2, 19, 8022192)
			   ,('FVE','DP1','021656','2024-12-30 17:33:03','122024','CO','60375776','SANDRA MILENA ','MANZANO OVALLOS ','CALLE 4 NO.12-02 COMUNEROS',' 3218098416','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','29052.94117647059','4247.058823529409','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:33:03','33300','50','DEPOSITO CUCUTA ','1','6700.00000000','6700.00000000','6700','0','6700','1','0','1','','30/12/2024','','33300','0','0','7702026182335','NOSOTRAS INVISIBLE CLASICA MULTIESTILO *10 UND +OBSEQUIO','337','FAMILIA SANCELA','2024-12-30 17:33:03',  4990.5, 55176, 2, 19, 8022238)
			   ,('FVE','DP1','021656','2024-12-30 17:33:03','122024','CO','60375776','SANDRA MILENA ','MANZANO OVALLOS ','CALLE 4 NO.12-02 COMUNEROS',' 3218098416','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','29052.94117647059','4247.058823529409','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:33:03','33300','50','DEPOSITO CUCUTA ','1','21500.00000000','21500.00000000','18067.226890756','3432.7731092437','21500','1','0','1','','30/12/2024','','33300','0','0','7702123010784','REDOXITOS TOTAL GOMITAS 2 BOLSAS * 25 P/ESPECIAL','631','BAYER OTC','2024-12-30 17:33:03',  15390, 55892, 2, 19, 8022238)
			   ,('FVE','DP1','021656','2024-12-30 17:33:03','122024','CO','60375776','SANDRA MILENA ','MANZANO OVALLOS ','CALLE 4 NO.12-02 COMUNEROS',' 3218098416','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','29052.94117647059','4247.058823529409','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:33:03','33300','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','30/12/2024','','33300','0','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-12-30 17:33:03',  1613.7, 52184, 2, 19, 8022238)
			   ,('FVE','DP1','021656','2024-12-30 17:33:03','122024','CO','60375776','SANDRA MILENA ','MANZANO OVALLOS ','CALLE 4 NO.12-02 COMUNEROS',' 3218098416','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','29052.94117647059','4247.058823529409','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:33:03','33300','50','DEPOSITO CUCUTA ','1','2500.00000000','2500.00000000','2100.8403361345','399.15966386555','2500','1','0','1','','30/12/2024','','33300','0','0','7702645100406','ACEITE DE ALMENDRAS X 1 ONZA ','263','LEON','2024-12-30 17:33:03',  1557.6923076923, 30195, 2, 19, 8022238)
			   ,('FVE','DP1','021657','2024-12-30 17:33:53','122024','CO','1090496828','MARIA FERNANDA ','ACOSTA CABARCAS','URBANIZACION LA FORTUNA PATIOS','3046614144 3046614144','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','19075.63025210084','3624.369747899159','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:36:37','22700','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','30/12/2024','','0','22700','0','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:33:53',  2765.121, 40129, 2, 19, 8022252)
			   ,('FVE','DP1','021657','2024-12-30 17:33:53','122024','CO','1090496828','MARIA FERNANDA ','ACOSTA CABARCAS','URBANIZACION LA FORTUNA PATIOS','3046614144 3046614144','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','19075.63025210084','3624.369747899159','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:36:37','22700','50','DEPOSITO CUCUTA ','3','5900.00000000','17700.00000000','14873.949579832','2826.0504201681','17700','3','0','1','','30/12/2024','','0','22700','0','7891150019560','DOVE JABON KARITE X 90 GR ','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:33:53',  4209, 49943, 2, 19, 8022252)
			   ,('FVE','DB2','003850','2024-12-30 17:34:05','122024','CR','1095957979','DARLY YULYTZA ','ROA RUEDA','CALLE 6H NO.32-39',' 3108637007','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','30184.03361344538','5734.96638655462','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:40:21','35919','DBU','DEPOSITO BUCARAMANGA','1','30000.00000000','30000.00000000','22032.773109244','4186.2268907563','26219','1','0','0','','30/12/2024','','0','0','35919','7708109834054','COLAGENO + BIOTINA CJA * 30 CAPS','1000','NATURALMENTE','2024-12-30 17:34:05',  7000, 60289, 426, 249, 8022267)
			   ,('FVE','DB2','003850','2024-12-30 17:34:05','122024','CR','1095957979','DARLY YULYTZA ','ROA RUEDA','CALLE 6H NO.32-39',' 3108637007','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','30184.03361344538','5734.96638655462','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:40:21','35919','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','30/12/2024','','0','0','35919','7702031414346','JOHNSON JABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:34:05',  2601.3, 56006, 426, 249, 8022267)
			   ,('FVE','DB2','003850','2024-12-30 17:34:05','122024','CR','1095957979','DARLY YULYTZA ','ROA RUEDA','CALLE 6H NO.32-39',' 3108637007','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','4','30184.03361344538','5734.96638655462','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:40:21','35919','DBU','DEPOSITO BUCARAMANGA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','30/12/2024','','0','0','35919','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:34:05',  2765.121, 40129, 426, 249, 8022267)
			   ,('FVE','DP1','021658','2024-12-30 17:34:43','122024','CO','1090470026','JOAN MANUEL','OVIEDO VILLALBA','',' 3137975659','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','18403.361344537814','3496.638655462186','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:36:37','21900','50','DEPOSITO CUCUTA ','1','21900.00000000','21900.00000000','18403.361344538','3496.6386554622','21900','1','0','1','','30/12/2024','','0','21900','0','7501056330293','PONDS CLARANT B3 N/GRASA * 50 GR','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:34:43',  10437.5473104, 43964, 2, 19, 8022266)
			   ,('FVE','DP1','021659','2024-12-30 17:37:45','122024','CO','1004806523','VERONICA','MENDEZ BELTRAN ','CALLE 14A NO.21-05 NUEVO HORIZ',' 3106995449','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','22268.907563025212','4231.092436974788','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:37:45','26500','50','DEPOSITO CUCUTA ','1','26500.00000000','26500.00000000','22268.907563025','4231.0924369748','26500','1','0','1','','30/12/2024','','0','26500','0','7501006721133','PANTENE SHAMPOO RESTAURACION *400 ML  ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:37:45',  16740.6879, 40230, 2, 19, 8022137)
			   ,('FVE','DP1','021660','2024-12-30 17:38:12','122024','CO','1093795610','ADRIANA GICELA ','PE Atilde  plusmn ARANDA ROJAS','AV 13 # 16-15 LA LIBERTAD-CUCU',' 3134507750','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','10000','1900','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:41:55','11900','50','DEPOSITO CUCUTA ','1','11900.00000000','11900.00000000','10000','1900','11900','1','0','1','','30/12/2024','','11900','0','0','7702277772545','INTIBON MUJER VINAG MANZA,CALEND *120 ML','124','BELLEZA EXPRESS SA','2024-12-30 17:38:12',  7210, 52096, 2, 19, 8022281)
			   ,('FVE','DP1','021661','2024-12-30 17:38:53','122024','CO','6664195','FRANCISCO SAID','RODRIGUEZ CASTIBLANCO','CONJUNTO CERRADO VALLARTA CASA','5703269 3002692042','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','87563.02521008404','16636.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:38:53','104200','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','1','','30/12/2024','','0','104200','0','7702006206808','REXONA CLINICAL MEN *30 GR','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:38:53',  2788, 56054, 2, 19, 8022158)
			   ,('FVE','DP1','021661','2024-12-30 17:38:53','122024','CO','6664195','FRANCISCO SAID','RODRIGUEZ CASTIBLANCO','CONJUNTO CERRADO VALLARTA CASA','5703269 3002692042','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','87563.02521008404','16636.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:38:53','104200','50','DEPOSITO CUCUTA ','1','22600.00000000','22600.00000000','18991.596638655','3608.4033613445','22600','1','0','1','','30/12/2024','','0','104200','0','7791293025797','AXE BODY SPRAY DARK TEMPTATION *150 ML','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:38:53',  15657.5379, 47452, 2, 19, 8022158)
			   ,('FVE','DP1','021661','2024-12-30 17:38:53','122024','CO','6664195','FRANCISCO SAID','RODRIGUEZ CASTIBLANCO','CONJUNTO CERRADO VALLARTA CASA','5703269 3002692042','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','87563.02521008404','16636.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:38:53','104200','50','DEPOSITO CUCUTA ','1','18300.00000000','18300.00000000','15378.151260504','2921.8487394958','18300','1','0','1','','30/12/2024','','0','104200','0','7702113042030','MUSS CREMA DE PEINAR ALTA NUTRICION *300 GR','278','RECAMIER','2024-12-30 17:38:53',  11419.325, 60205, 2, 19, 8022158)
			   ,('FVE','DP1','021661','2024-12-30 17:38:53','122024','CO','6664195','FRANCISCO SAID','RODRIGUEZ CASTIBLANCO','CONJUNTO CERRADO VALLARTA CASA','5703269 3002692042','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','87563.02521008404','16636.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:38:53','104200','50','DEPOSITO CUCUTA ','1','14500.00000000','14500.00000000','12184.87394958','2315.1260504202','14500','1','0','1','','30/12/2024','','0','104200','0','7509546668673','LADY SPEED STICK CLINICAL ANTIBACTERIAL *100 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:38:53',  8444.25, 57775, 2, 19, 8022158)
			   ,('FVE','DP1','021661','2024-12-30 17:38:53','122024','CO','6664195','FRANCISCO SAID','RODRIGUEZ CASTIBLANCO','CONJUNTO CERRADO VALLARTA CASA','5703269 3002692042','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','87563.02521008404','16636.974789915963','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:38:53','104200','50','DEPOSITO CUCUTA ','1','44800.00000000','44800.00000000','37647.058823529','7152.9411764706','44800','1','0','1','','30/12/2024','','0','104200','0','7500435128315','GILLETTE CLEAR GEL ANTIBACTERIAL X2 * 113 GR P/ESPECIAL','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:38:53',  26867.6793, 54035, 2, 19, 8022158)
			   ,('FVE','DP1','021662','2024-12-30 17:41:29','122024','CO','88261284','RAFAEL YADIR ','MOROS RIVERA ','CONJUNTO CERRADO TERRAVIVA  AP',' 3003412502','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','61512.6050420168','11687.394957983191','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:41:55','73200','50','DEPOSITO CUCUTA ','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','1','','30/12/2024','','0','73200','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:41:29',  2765.121, 40145, 2, 19, 8022296)
			   ,('FVE','DP1','021662','2024-12-30 17:41:29','122024','CO','88261284','RAFAEL YADIR ','MOROS RIVERA ','CONJUNTO CERRADO TERRAVIVA  AP',' 3003412502','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','61512.6050420168','11687.394957983191','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:41:55','73200','50','DEPOSITO CUCUTA ','1','36800.00000000','36800.00000000','30924.369747899','5875.6302521008','36800','1','0','1','','30/12/2024','','0','73200','0','7702006200981','REXONA V8 2X1 SPRAY *90 GR','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:41:29',  22141.944, 52340, 2, 19, 8022296)
			   ,('FVE','DP1','021662','2024-12-30 17:41:29','122024','CO','88261284','RAFAEL YADIR ','MOROS RIVERA ','CONJUNTO CERRADO TERRAVIVA  AP',' 3003412502','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','5','61512.6050420168','11687.394957983191','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:41:55','73200','50','DEPOSITO CUCUTA ','1','26400.00000000','26400.00000000','22184.87394958','4215.1260504202','26400','1','0','1','','30/12/2024','','0','73200','0','7501001100285','ORAL B CEPILLO PRO-SALUD 7 BENEFICIOS 2X1','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:41:29',  16287.075, 39987, 2, 19, 8022296)
			   ,('FVE','DB2','003851','2024-12-30 17:41:45','122024','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','4','65913.44537815126','12523.554621848736','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:41:45','78437','DBU','DEPOSITO BUCARAMANGA','1','26000.00000000','26000.00000000','21848.739495798','4151.2605042017','26000','1','0','1','','30/12/2024','','0','78437','0','4022679136473','VITAMINA C+B2+ZINC *20 TAB','777','PHARMARIS COLOMBIA','2024-12-30 17:41:45',  14453.78, 56184, 426, 249, 8022242)
			   ,('FVE','DB2','003851','2024-12-30 17:41:45','122024','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','4','65913.44537815126','12523.554621848736','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:41:45','78437','DBU','DEPOSITO BUCARAMANGA','2','30000.00000000','60000.00000000','44064.705882353','8372.2941176471','52437','2','0','1','','30/12/2024','','0','78437','0','7708109834054','COLAGENO + BIOTINA CJA * 30 CAPS','1000','NATURALMENTE','2024-12-30 17:41:45',  7000, 60289, 426, 249, 8022242)
			   ,('FVE','DB2','003852','2024-12-30 17:42:01','122024','CR','1098764157','JOSE LUIS','NIETO SOSA','CALLE 50 NO.23-39 BARRIO LA CO',' 3186574901','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','24849.579831932773','750.4201680672268','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:44:25','25600','DBU','DEPOSITO BUCARAMANGA','1','20900.00000000','20900.00000000','20900','0','20900','1','0','0','','30/12/2024','','0','0','25600','736085278507','MANZANILLA SOLUCION OFT *15ML','636','SOPHIA DE COLOMBIA OTC','2024-12-30 17:42:01',  13058.76, 31131, 426, 249, 8022318)
			   ,('FVE','DB2','003852','2024-12-30 17:42:01','122024','CR','1098764157','JOSE LUIS','NIETO SOSA','CALLE 50 NO.23-39 BARRIO LA CO',' 3186574901','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','24849.579831932773','750.4201680672268','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:44:25','25600','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','30/12/2024','','0','0','25600','7702010111501','COLGATE CREMA DENTAL T/ACCION *60 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:42:01',  2913.62454, 48361, 426, 249, 8022318)
			   ,('FVE','DP1','021663','2024-12-30 17:42:59','122024','CO','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','9747.899159663866','1852.1008403361334','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:42:59','11600','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','30/12/2024','','11600','0','0','7702010470486','LADY SPEED STICK CLINICAL MINI POWDER CREMA *30 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:42:59',  2474.568, 53264, 2, 19, 8022316)
			   ,('FVE','DP1','021663','2024-12-30 17:42:59','122024','CO','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','9747.899159663866','1852.1008403361334','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:42:59','11600','50','DEPOSITO CUCUTA ','1','7100.00000000','7100.00000000','5966.3865546218','1133.6134453782','7100','1','0','1','','30/12/2024','','11600','0','0','7702031668787','NEKO JABON BLANCO *125 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 17:42:59',  4379.3625, 34241, 2, 19, 8022316)
			   ,('FVE','DP1','021664','2024-12-30 17:44:44','122024','CO','1005029164','JOHAN','PE ntilde ARANDA','CALLE 10 NO.1-25 MOTILONES. CU',' 3138860242','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','2','23529.411764705885','4470.588235294115','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:44:44','28000','50','DEPOSITO CUCUTA ','1','28000.00000000','28000.00000000','23529.411764706','4470.5882352941','28000','1','0','1','','30/12/2024','','0','28000','0','7500435019491','H & S SHAMPOO MEN 3EN1 CONTROL CASPA *375 ML','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:44:44',  14899.059, 54720, 2, 19, 8022339)
			   ,('FVE','DP1','021665','2024-12-30 17:48:12','122024','CO','1092363327','JESUS JAVIER ','MARTINEZ GARCIA','CALLE 28N NO.13-60 NAVARRO WOL',' 3245602976','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','8','38571.42857142857','7328.571428571427','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:48:20','45900','50','DEPOSITO CUCUTA ','2','4700.00000000','9400.00000000','7899.1596638655','1500.8403361345','9400','2','0','1','','30/12/2024','','0','45900','0','7702010111501','COLGATE CREMA DENTAL T/ACCION *60 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:48:12',  2913.62454, 48361, 2, 19, 8022354)
			   ,('FVE','DP1','021665','2024-12-30 17:48:12','122024','CO','1092363327','JESUS JAVIER ','MARTINEZ GARCIA','CALLE 28N NO.13-60 NAVARRO WOL',' 3245602976','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','8','38571.42857142857','7328.571428571427','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:48:20','45900','50','DEPOSITO CUCUTA ','2','4000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','2','0','1','','30/12/2024','','0','45900','0','7702006206808','REXONA CLINICAL MEN *30 GR','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:48:12',  2788, 56054, 2, 19, 8022354)
			   ,('FVE','DP1','021665','2024-12-30 17:48:12','122024','CO','1092363327','JESUS JAVIER ','MARTINEZ GARCIA','CALLE 28N NO.13-60 NAVARRO WOL',' 3245602976','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','8','38571.42857142857','7328.571428571427','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:48:20','45900','50','DEPOSITO CUCUTA ','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','1','','30/12/2024','','0','45900','0','7702277152330','TOALLITAS ARRURRU ALOE Y MANZANILLA *70 UND ','124','BELLEZA EXPRESS SA','2024-12-30 17:48:12',  4411.5, 55330, 2, 19, 8022354)
			   ,('FVE','DP1','021665','2024-12-30 17:48:12','122024','CO','1092363327','JESUS JAVIER ','MARTINEZ GARCIA','CALLE 28N NO.13-60 NAVARRO WOL',' 3245602976','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','8','38571.42857142857','7328.571428571427','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:48:20','45900','50','DEPOSITO CUCUTA ','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','1','','30/12/2024','','0','45900','0','7702010421006','PROTEX JABON HERBAL *110 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 17:48:12',  2552.3127, 52311, 2, 19, 8022354)
			   ,('FVE','DP1','021665','2024-12-30 17:48:12','122024','CO','1092363327','JESUS JAVIER ','MARTINEZ GARCIA','CALLE 28N NO.13-60 NAVARRO WOL',' 3245602976','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','8','38571.42857142857','7328.571428571427','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:48:20','45900','50','DEPOSITO CUCUTA ','1','15300.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','1','0','1','','30/12/2024','','0','45900','0','7500435138017','H & S SHAMPO PURIFICACION CAPILAR *180 ML','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:48:12',  9200.8329, 56014, 2, 19, 8022354)
			   ,('FVE','DP1','021666','2024-12-30 17:49:51','122024','CO','1127361595','JORGE','NIETO','CRA 14 NO.25-12 GRAN COLOMBIA',' 3155354339','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','16554.621848739498','3145.378151260502','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:49:51','19700','50','DEPOSITO CUCUTA ','1','19700.00000000','19700.00000000','16554.621848739','3145.3781512605','19700','1','0','1','','30/12/2024','','0','19700','0','7702057082130','YODORA CREMA * 32 GR * 2 PRECIO ESPECIAL','889','TECNOQUIMICAS CONSUMO','2024-12-30 17:49:51',  12875, 42931, 2, 19, 8022150)
			   ,('FVE','DP1','021667','2024-12-30 17:53:12','122024','CO','1127066591','JUSTO ANDERSSON ','PALENCIA RINC oacute N ','KDXB 84 MONTEVIDEO',' 3506172741','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','13949.579831932773','2650.4201680672268','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:53:12','16600','50','DEPOSITO CUCUTA ','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','1','','30/12/2024','','0','16600','0','7702026181789','NOSOTRAS JABON INTIMO SENSITI-V X 130 ML ','337','FAMILIA SANCELA','2024-12-30 17:53:12',  6882.3, 59612, 2, 19, 8022388)
				  ,('FVE','DP1','021667','2024-12-30 17:53:12','122024','CO','1127066591','JUSTO ANDERSSON ','PALENCIA RINC oacute N ','KDXB 84 MONTEVIDEO',' 3506172741','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','13949.579831932773','2650.4201680672268','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 17:53:12','16600','50','DEPOSITO CUCUTA ','1','5100.00000000','5100.00000000','4285.7142857143','814.28571428571','5100','1','0','1','','30/12/2024','','0','16600','0','7506339334357','GILLETTE PRESTOBARBA 3 HOMBRE SENSE CARE','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:53:12',  2765.121, 33561, 2, 19, 8022388);
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','DB2','003853','2024-12-30 17:54:48','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','43063.02521008404','7136.974789915965','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:59:41','50200','DBU','DEPOSITO BUCARAMANGA','1','34700.00000000','34700.00000000','29159.663865546','5540.3361344538','34700','1','0','0','','30/12/2024','','0','0','50200','7702006001014','AXE BODY DARK TEMPTATION SPRAY *160 ML X2','388','UNILEVER ANDINA COLOMBIA','2024-12-30 17:54:48',  20089, 47947, 426, 249, 8022426)
			   ,('FVE','DB2','003853','2024-12-30 17:54:48','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','43063.02521008404','7136.974789915965','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:59:41','50200','DBU','DEPOSITO BUCARAMANGA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','30/12/2024','','0','0','50200','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:54:48',  2765.121, 40129, 426, 249, 8022426)
			   ,('FVE','DB2','003853','2024-12-30 17:54:48','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','43063.02521008404','7136.974789915965','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:59:41','50200','DBU','DEPOSITO BUCARAMANGA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','30/12/2024','','0','0','50200','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 17:54:48',  2765.121, 40145, 426, 249, 8022426)
			   ,('FVE','DB2','003853','2024-12-30 17:54:48','122024','CR','1004360497','WENDY CAROLINA ','TERNERA URIELES ','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','6','43063.02521008404','7136.974789915965','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-30 17:59:41','50200','DBU','DEPOSITO BUCARAMANGA','1','5500.00000000','5500.00000000','5500','0','5500','1','0','0','','30/12/2024','','0','0','50200','7706569001443','NAPROXENO 250MG *10 TAB','614','A.G. MEDICAMENTOS','2024-12-30 17:54:48',  2369.49, 31629, 426, 249, 8022426)
			   ,('FVE','DP1','021668','2024-12-30 17:59:20','122024','CO','1004842741','ANGEL GABRIELA ','CONTRERAS RIA Ntilde O','CALLE 3 NO.1-37 SAN MATEO PART',' 3202279289','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','52100.84033613445','9899.159663865546','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 17:59:20','62000','50','DEPOSITO CUCUTA ','1','62000.00000000','62000.00000000','52100.840336134','9899.1596638655','62000','1','0','1','','30/12/2024','','0','62000','0','42210283','NIVEA SUN PROTECCION SOLAR *125 ML','123','BDF (BEIERSDORF) ','2024-12-30 17:59:20',  33529.4118, 41135, 2, 19, 8022393)
			   ,('FVE','DP1','021669','2024-12-30 18:02:06','122024','CO','1010086333','ESNEIDER STYVEN','BECERRA BECERRA','',' 3008081615','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','13025.210084033613','2474.7899159663866','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:02:06','15500','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','1','','30/12/2024','','0','15500','0','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 18:02:06',  9366, 24473, 2, 19, 8022488)
			   ,('FVE','DP1','021670','2024-12-30 18:04:40','122024','CO','1090429584','JESSICA  KATHERINE','NI Ntilde O CARO ','CALLE 21 NO. 18-62 SAN JOSE CU','3142233732 3142233732','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','5546.218487394958','1053.7815126050418','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 18:04:40','6600','50','DEPOSITO CUCUTA ','1','4600.00000000','4600.00000000','3865.5462184874','734.45378151261','4600','1','0','1','','30/12/2024','','6600','0','0','4891228530136','SCHICK QUATTRO TITANIUM DESECHABLE X 1  ','180','EVEREADY DE COLOMBIA','2024-12-30 18:04:40',  2931.66336, 25501, 2, 19, 8022489)
			   ,('FVE','DP1','021670','2024-12-30 18:04:40','122024','CO','1090429584','JESSICA  KATHERINE','NI Ntilde O CARO ','CALLE 21 NO. 18-62 SAN JOSE CU','3142233732 3142233732','423','JOSï¿½ ALBERTO ','VELEZ MARTINEZ ','','TERCERO','VARIOS','','','','','','3','5546.218487394958','1053.7815126050418','00','DEPOSITO CUCUTA','J.VELEZ','2024-12-30 18:04:40','6600','50','DEPOSITO CUCUTA ','1','2000.00000000','2000.00000000','1680.6722689076','319.32773109244','2000','1','0','1','','30/12/2024','','6600','0','0','7500435118026','MINORA CUCHILLA X 5 UNDS','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 18:04:40',  1349.035485, 51908, 2, 19, 8022489)
			   ,('FVE','DP1','021671','2024-12-30 18:05:06','122024','CO','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','47226.89075630253','8973.109243697476','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:05:06','56200','50','DEPOSITO CUCUTA ','1','10500.00000000','10500.00000000','8823.5294117647','1676.4705882353','10500','1','0','1','','30/12/2024','','56200','0','0','7702277395256','TOALLITAS ARRURRU AVENA Y KARITE *100 UND ','124','BELLEZA EXPRESS SA','2024-12-30 18:05:06',  5788.5, 55332, 2, 19, 8022382)
			   ,('FVE','DP1','021671','2024-12-30 18:05:06','122024','CO','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','47226.89075630253','8973.109243697476','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:05:06','56200','50','DEPOSITO CUCUTA ','1','9500.00000000','9500.00000000','7983.1932773109','1516.8067226891','9500','1','0','1','','30/12/2024','','56200','0','0','3014260802189','ORAL B CEPILLO COMPLETE 40 MEDIANO','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 18:05:06',  4929.9246, 39977, 2, 19, 8022382)
			   ,('FVE','DP1','021671','2024-12-30 18:05:06','122024','CO','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','47226.89075630253','8973.109243697476','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:05:06','56200','50','DEPOSITO CUCUTA ','1','21700.00000000','21700.00000000','18235.294117647','3464.7058823529','21700','1','0','1','','30/12/2024','','56200','0','0','7702502015201','MEXSANA LADY AEROSOL *260 ML','631','BAYER OTC','2024-12-30 18:05:06',  15310, 33104, 2, 19, 8022382)
			   ,('FVE','DP1','021671','2024-12-30 18:05:06','122024','CO','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','47226.89075630253','8973.109243697476','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:05:06','56200','50','DEPOSITO CUCUTA ','1','14500.00000000','14500.00000000','12184.87394958','2315.1260504202','14500','1','0','1','','30/12/2024','','56200','0','0','7509546668673','LADY SPEED STICK CLINICAL ANTIBACTERIAL *100 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 18:05:06',  8444.25, 57775, 2, 19, 8022382)
			   ,('FVE','DP1','021672','2024-12-30 18:08:46','122024','CO','1093793999','HEIDY','GARCIA','CALLE 8 NO.9-77 DO?A CECI',' 3228462233','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','32184.873949579836','6115.126050420165','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:08:46','38300','50','DEPOSITO CUCUTA ','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','1','','30/12/2024','','0','38300','0','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE *70 UND','124','BELLEZA EXPRESS SA','2024-12-30 18:08:46',  4411.5, 55331, 2, 19, 8022295)
			   ,('FVE','DP1','021672','2024-12-30 18:08:46','122024','CO','1093793999','HEIDY','GARCIA','CALLE 8 NO.9-77 DO?A CECI',' 3228462233','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','32184.873949579836','6115.126050420165','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:08:46','38300','50','DEPOSITO CUCUTA ','1','21500.00000000','21500.00000000','18067.226890756','3432.7731092437','21500','1','0','1','','30/12/2024','','0','38300','0','7702123010784','REDOXITOS TOTAL GOMITAS 2 BOLSAS * 25 P/ESPECIAL','631','BAYER OTC','2024-12-30 18:08:46',  15390, 55892, 2, 19, 8022295)
			   ,('FVE','DP1','021672','2024-12-30 18:08:46','122024','CO','1093793999','HEIDY','GARCIA','CALLE 8 NO.9-77 DO?A CECI',' 3228462233','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','32184.873949579836','6115.126050420165','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:08:46','38300','50','DEPOSITO CUCUTA ','4','2200.00000000','8800.00000000','7394.9579831933','1405.0420168067','8800','4','0','1','','30/12/2024','','0','38300','0','77012159','BESO DE AMOR *32 GR','776','NESTLE FOOD & BEVERAGE','2024-12-30 18:08:46',  1190, 38309, 2, 19, 8022295)
			   ,('FVE','DB1','002002','2024-12-30 18:30:03','122024','CO','1045737657','NABYS  DE JES uacute S ','MORENO RIVERO ','CALLE 19 NO. 50-32 VISTA HERMO',' 3147425494','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','24201.680672268907','4598.319327731092','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 18:30:03','28800','DB','DEPOSITO BARRANQUILLA','2','11900.00000000','23800.00000000','20000','3800','23800','2','0','1','','30/12/2024','','0','28800','0','7509546670522','SPEED STICK PRACTI-GEL XTREME NIGHT *70 GR ','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 18:30:03',  5040, 59469, 119, 53, 8018256)
			   ,('FVE','DB1','002002','2024-12-30 18:30:03','122024','CO','1045737657','NABYS  DE JES uacute S ','MORENO RIVERO ','CALLE 19 NO. 50-32 VISTA HERMO',' 3147425494','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','24201.680672268907','4598.319327731092','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 18:30:03','28800','DB','DEPOSITO BARRANQUILLA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','30/12/2024','','0','28800','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2024-12-30 18:30:03',  2855, 40145, 119, 53, 8018256)
			   ,('FVE','DB1','002003','2024-12-30 18:37:24','122024','CR','1001875540','JOSE MIGUEL ','PE ntilde A GONZ aacute LEZ','CALLE 80 NO.2D-14',' 3004877031','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','4','12352.94117647059','2347.058823529411','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-30 18:43:09','14700','DB','DEPOSITO BARRANQUILLA','3','4900.00000000','14700.00000000','12352.941176471','2347.0588235294','14700','3','0','0','','30/12/2024','','0','0','14700','7702031401032','JOHNSON BABYJABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2024-12-30 18:37:24',  3093.103779, 56126, 119, 53, 8022760)
			   ,('FVE','DP1','021673','2024-12-30 18:44:25','122024','CO','91537765','CARLOS ARTURO','GOMEZ GOMEZ','',' 3188355744','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','86358.54341736695','6341.456582633049','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:44:25','92700','50','DEPOSITO CUCUTA ','1','12500.00000000','12500.00000000','10504.201680672','1995.7983193277','12500','1','0','1','','30/12/2024','','92700','0','0','D1427','CABLE TIPO C ANDROID','819','INOVY','2024-12-30 18:44:25',  6134.45, 53897, 2, 19, 8020284)
			   ,('FVE','DP1','021673','2024-12-30 18:44:25','122024','CO','91537765','CARLOS ARTURO','GOMEZ GOMEZ','',' 3188355744','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','86358.54341736695','6341.456582633049','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:44:25','92700','50','DEPOSITO CUCUTA ','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','1','','30/12/2024','','92700','0','0','7702354940980','EGO CERA PARA PEINAR * 60 ML','388','UNILEVER ANDINA COLOMBIA','2024-12-30 18:44:25',  3235.328488, 49397, 2, 19, 8020284)
			   ,('FVE','DP1','021673','2024-12-30 18:44:25','122024','CO','91537765','CARLOS ARTURO','GOMEZ GOMEZ','',' 3188355744','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','86358.54341736695','6341.456582633049','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:44:25','92700','50','DEPOSITO CUCUTA ','1','75500.00000000','75500.00000000','71904.761904762','3595.2380952381','75500','1','0','1','','30/12/2024','','92700','0','0','5011013100156','BAILEYS ORIGINAL * 700 ML','827','MEICO LICORES','2024-12-30 18:44:25',  64569, 53955, 2, 19, 8020284)
			   ,('FVE','DP1','021674','2024-12-30 18:46:07','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','25221.8487394958','878.1512605042012','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:46:07','26100','50','DEPOSITO CUCUTA ','1','20600.00000000','20600.00000000','20600','0','20600','1','0','1','','30/12/2024','','0','26100','0','7590002012468','VICK VAPORUB *50 GR','820','PROCTER & GAMBLE CHC','2024-12-30 18:46:07',  13460.70525, 40254, 2, 19, 8021946)
			   ,('FVE','DP1','021674','2024-12-30 18:46:07','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','25221.8487394958','878.1512605042012','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:46:07','26100','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','1','','30/12/2024','','0','26100','0','8412765508905','ENCENDEDOR CLIPPER RECARGABLE','950','TRONEX','2024-12-30 18:46:07',  2042, 62092, 2, 19, 8021946)
			   ,('FVE','DP1','021674','2024-12-30 18:46:07','122024','CO','1090531686','ELIAB DANIEL ','ROMERO PARRA ','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','25221.8487394958','878.1512605042012','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 18:46:07','26100','50','DEPOSITO CUCUTA ','1','1500.00000000','1500.00000000','1260.5042016807','239.49579831933','1500','1','0','1','','30/12/2024','','0','26100','0','7707822759255','SUPER PEGA ROCKET * 3GR','950','TRONEX','2024-12-30 18:46:07',  756, 62093, 2, 19, 8021946)
			   ,('FVE','DP1','021675','2024-12-30 19:06:47','122024','CR','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','11008.403361344539','2091.596638655461','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-30 19:10:04','13100','50','DEPOSITO CUCUTA ','1','13100.00000000','13100.00000000','11008.403361345','2091.5966386555','13100','1','0','0','','31/12/2024','','0','0','13100','6920354824395','COLGATE C/DENTAL NATURAL EXTRACTS CARBON/MENTA *66 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-30 19:06:47',  8157.51, 56067, 2, 19, 8022884)
			   ,('FVE','DP1','021676','2024-12-30 19:14:36','122024','CO','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','2024-12-30 19:14:36','37500','50','DEPOSITO CUCUTA ','1','37500.00000000','37500.00000000','37500','0','37500','1','0','1','','31/12/2024','','0','37500','0','7702870940549','BELLANEW 1.5MG/2MG *28 TAB','619','ABBOTT FARMA','2024-12-30 19:14:36',  32727.5, 54895, 2, 19, 8022908)
			   ,('FVE','DP1','021681','2024-12-31 07:58:35','122024','CO','1004924037','KAROL ALEJANDRA ','JAIMES HERNANDEZ','CALLE 6N NO.12-71 ANTONIO NARI',' 3203610879','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','13781.512605042017','2618.487394957983','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 10:00:05','16400','50','DEPOSITO CUCUTA ','1','11900.00000000','11900.00000000','10000','1900','11900','1','0','1','','31/12/2024','','0','16400','0','7509546670522','SPEED STICK PRACTI-GEL XTREME NIGHT *70 GR ','145','COLGATE PALMOLIVE COMPANIA','2024-12-31 07:58:35',  5040, 59469, 2, 19, 8022262)
			   ,('FVE','DP1','021681','2024-12-31 07:58:35','122024','CO','1004924037','KAROL ALEJANDRA ','JAIMES HERNANDEZ','CALLE 6N NO.12-71 ANTONIO NARI',' 3203610879','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','13781.512605042017','2618.487394957983','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 10:00:05','16400','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','31/12/2024','','0','16400','0','7702010470486','LADY SPEED STICK CLINICAL MINI POWDER CREMA *30 GR','145','COLGATE PALMOLIVE COMPANIA','2024-12-31 07:58:35',  2474.568, 53264, 2, 19, 8022262)
			   ,('FVE','DP1','021682','2024-12-31 08:02:05','122024','CO','1090507312','WILLIAM YOHANN','ESTUPI ntilde AN ORTEGA','AV 3B NO.21-05 PUENTE BARCO. C',' 3155682383','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','18991.596638655465','3608.4033613445354','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 10:00:05','22600','50','DEPOSITO CUCUTA ','1','22600.00000000','22600.00000000','18991.596638655','3608.4033613445','22600','1','0','1','','31/12/2024','','0','22600','0','7791293025797','AXE BODY SPRAY DARK TEMPTATION *150 ML','388','UNILEVER ANDINA COLOMBIA','2024-12-31 08:02:05',  15657.5379, 47452, 2, 19, 8022217)
			   ,('FVE','DP1','021683','2024-12-31 08:17:54','122024','CO','1001999319','CARLOS DANIEL','CARDONA DIAZ','',' 3023519363','206','DIANA PATRICIA','DIAZ MIRANDA','','TERCERO','VARIOS','','','','','','4','8907.563025210085','1692.436974789915','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 10:00:05','10600','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','31/12/2024','','10600','0','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2024-12-31 08:17:54',  2765.121, 40145, 2, 19, 8023605)
			   ,('FVE','DP1','021683','2024-12-31 08:17:54','122024','CO','1001999319','CARLOS DANIEL','CARDONA DIAZ','',' 3023519363','206','DIANA PATRICIA','DIAZ MIRANDA','','TERCERO','VARIOS','','','','','','4','8907.563025210085','1692.436974789915','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 10:00:05','10600','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','31/12/2024','','10600','0','0','7702045563726','BALANCE CLINICAL CREMA MINI MEN * 32 GR','203','HENKEL COLOMBIANA','2024-12-31 08:17:54',  2819, 52775, 2, 19, 8023605)
			   ,('FVE','DP1','021683','2024-12-31 08:17:54','122024','CO','1001999319','CARLOS DANIEL','CARDONA DIAZ','',' 3023519363','206','DIANA PATRICIA','DIAZ MIRANDA','','TERCERO','VARIOS','','','','','','4','8907.563025210085','1692.436974789915','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 10:00:05','10600','50','DEPOSITO CUCUTA ','1','1100.00000000','1100.00000000','924.36974789916','175.63025210084','1100','1','0','1','','31/12/2024','','10600','0','0','77020104704627','SPEED STICK CLINICAL DRY SOBRE','145','COLGATE PALMOLIVE COMPANIA','2024-12-31 08:17:54',  699, 49212, 2, 19, 8023605)
			   ,('FVE','DP1','021684','2024-12-31 09:08:58','122024','CO','1093751562','DIEGO ALEXANDER','NI ntilde O CASTILLO','CL 15A # 8-70 TIERRA LINDA LOS','5553105 3132555071','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','17200','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 10:00:05','17200','50','DEPOSITO CUCUTA ','1','17200.00000000','17200.00000000','17200','0','17200','1','0','1','','31/12/2024','','0','17200','0','7702123006916','APRONAX 275 MG * 8 CAP','631','BAYER OTC','2024-12-31 09:08:58',  12755, 22873, 2, 19, 8023812)
			   ,('FVE','DP1','021685','2024-12-31 10:44:44','122024','CO','900929396-4','SSP ASISTENCIAS ','SAS','CL 0 B N 7 A 42','5781374 3007512180','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','','','','2','100840.33613445378','19159.663865546216','00','DEPOSITO CUCUTA','AUXFINANZAS2','2024-12-31 10:44:44','120000','50','DEPOSITO CUCUTA ','1','120000.00000000','120000.00000000','100840.33613445','19159.663865546','120000','1','0','0','','31/12/2024','','0','120000','0','D1969','SERVICIO DE PARQUEADERO','1053','SERVICIOS','2024-12-31 10:44:44',  0, 64854, 2, 19, 8024222)
			   ,('FVE','DP1','021686','2024-12-31 10:50:57','122024','CO','900929396-4','SSP ASISTENCIAS ','SAS','CL 0 B N 7 A 42','5781374 3007512180','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','','','','2','100840.33613445378','19159.663865546216','00','DEPOSITO CUCUTA','AUXFINANZAS2','2024-12-31 10:50:57','120000','50','DEPOSITO CUCUTA ','1','120000.00000000','120000.00000000','100840.33613445','19159.663865546','120000','1','0','0','','31/12/2024','','0','120000','0','D1969','SERVICIO DE PARQUEADERO','1053','SERVICIOS','2024-12-31 10:50:57',  0, 64854, 2, 19, 8024263)
			   ,('FVE','DP1','021687','2024-12-31 11:02:10','122024','CO','1014257783','DIANA PAOLA','ROBAYO MATEUS','CALLE 16 NO.10-40 VIDELSO',' 3013565944','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','50000','9499.999999999996','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 11:02:10','59500','50','DEPOSITO CUCUTA ','1','20000.00000000','20000.00000000','16806.722689076','3193.2773109244','20000','1','0','1','','31/12/2024','','0','59500','0','7702277074403','COLONIA ARRURRU ROSADA *120 ML','124','BELLEZA EXPRESS SA','2024-12-31 11:02:10',  13982.4, 34503, 2, 19, 8023049)
			   ,('FVE','DP1','021687','2024-12-31 11:02:10','122024','CO','1014257783','DIANA PAOLA','ROBAYO MATEUS','CALLE 16 NO.10-40 VIDELSO',' 3013565944','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','50000','9499.999999999996','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 11:02:10','59500','50','DEPOSITO CUCUTA ','1','20000.00000000','20000.00000000','16806.722689076','3193.2773109244','20000','1','0','1','','31/12/2024','','0','59500','0','7702277074328','COLONIA ARRURRU AZUL *120 ML ','124','BELLEZA EXPRESS SA','2024-12-31 11:02:10',  13982.5, 34506, 2, 19, 8023049)
			   ,('FVE','DP1','021687','2024-12-31 11:02:10','122024','CO','1014257783','DIANA PAOLA','ROBAYO MATEUS','CALLE 16 NO.10-40 VIDELSO',' 3013565944','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','50000','9499.999999999996','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 11:02:10','59500','50','DEPOSITO CUCUTA ','1','19500.00000000','19500.00000000','16386.554621849','3113.4453781513','19500','1','0','1','','31/12/2024','','0','59500','0','7702006208420','SAVITAL SHAMPOO MULTIVITAMINAS Y SABILA *510 ML','388','UNILEVER ANDINA COLOMBIA','2024-12-31 11:02:10',  13481, 62658, 2, 19, 8023049)
			   ,('FVE','DP1','021688','2024-12-31 11:25:22','122024','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','5200','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 11:25:29','5200','50','DEPOSITO CUCUTA ','4','1300.00000000','5200.00000000','5200','0','5200','0','4','0','','31/12/2024','','5200','0','0','7702123006718','ASPIRINA EFERVESCENTE 500 MG * 50 TAB','631','BAYER OTC','2024-12-31 11:25:22',  37840, 22880, 2, 19, 8024679)
			   ,('FVE','DB2','003854','2024-12-31 13:10:17','122024','CO','1090519336','JHONATAN DAVID ','ZERPA VILLAMIZAR ','MZ D15 CASA 6 TORCOROMA 2 TORC','5768090 3507990281','3489','CAMILO ','RODRíGUEZ LARROTA ','','TERCERO','VARIOS','','','','','','2','5100','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:10:17','5100','DBU','DEPOSITO BUCARAMANGA','1','5100.00000000','5100.00000000','5100','0','5100','1','0','1','','31/12/2024','','0','5100','0','7707236122102','FUROSEMIDA 20MG/2ML *1 AMP','701','VITALIS COMERCIAL','2024-12-31 13:10:17',  3500, 54343, 426, 249, 8025105)
				  ,('FVE','DB2','003855','2024-12-31 13:11:00','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','106500','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:11:00','106500','DBU','DEPOSITO BUCARAMANGA','1','67500.00000000','67500.00000000','67500','0','67500','1','0','1','','31/12/2024','','0','106500','0','7702626211794','GAVISCON DOBLE ACCION SUSP FRASCO * 300 ML','357','RECKITT BENCKISER COLOMBIA S A','2024-12-31 13:11:00',  56480, 46847, 426, 249, 8022356);
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','DB2','003855','2024-12-31 13:11:00','122024','CO','1095793618','EDWIN','NU ntilde EZ RODR iacute GUEZ','CRA 30 NO.16-4 APTO 303. BUCAR',' 3152249905','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','3','106500','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:11:00','106500','DBU','DEPOSITO BUCARAMANGA','1','39000.00000000','39000.00000000','39000','0','39000','1','0','1','','31/12/2024','','0','106500','0','7708152336598','EREX BEBIDA * 500 ML','982','LAB PHARMACIENCIA SAS','2024-12-31 13:11:00',  18000, 62528, 426, 249, 8022356)
			   ,('FVE','DB2','003856','2024-12-31 13:17:36','122024','CO','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','7','49833.61344537815','4566.386554621848','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:17:36','54400','DBU','DEPOSITO BUCARAMANGA','1','5700.00000000','5700.00000000','5700','0','5700','1','0','1','','31/12/2024','','0','54400','0','7702057075088','ALCOHOL MK * 350 ML ','624','TECNOQUIMICAS CUIDADO DE HERIDA','2024-12-31 13:17:36',  4290, 42766, 426, 249, 8022232)
			   ,('FVE','DB2','003856','2024-12-31 13:17:36','122024','CO','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','7','49833.61344537815','4566.386554621848','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:17:36','54400','DBU','DEPOSITO BUCARAMANGA','1','26000.00000000','26000.00000000','21848.739495798','4151.2605042017','26000','1','0','1','','31/12/2024','','0','54400','0','4022679136473','VITAMINA C+B2+ZINC *20 TAB','777','PHARMARIS COLOMBIA','2024-12-31 13:17:36',  14453.78, 56184, 426, 249, 8022232)
			   ,('FVE','DB2','003856','2024-12-31 13:17:36','122024','CO','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','7','49833.61344537815','4566.386554621848','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:17:36','54400','DBU','DEPOSITO BUCARAMANGA','1','8900.00000000','8900.00000000','8900','0','8900','1','0','1','','31/12/2024','','0','54400','0','7703689627614','PIEL RETARDANTE X 3 UND','344','PROFAMILIA','2024-12-31 13:17:36',  3260.4, 63606, 426, 249, 8022232)
			   ,('FVE','DB2','003856','2024-12-31 13:17:36','122024','CO','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','7','49833.61344537815','4566.386554621848','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:17:36','54400','DBU','DEPOSITO BUCARAMANGA','1','11200.00000000','11200.00000000','11200','0','11200','1','0','1','','31/12/2024','','0','54400','0','7501159033442','DUREX EXTRA SEGURO * 3 UND','357','RECKITT BENCKISER COLOMBIA S A','2024-12-31 13:17:36',  8952, 41708, 426, 249, 8022232)
			   ,('FVE','DB2','003856','2024-12-31 13:17:36','122024','CO','72296154','MARLON','MU ntilde OZ','CRA 5B NO.49B-51 EL SANTUARIO',' 3013525408','2140','CRISTIAN ANDRéS','MARTíNEZ ','','TERCERO','VARIOS','','','','','','7','49833.61344537815','4566.386554621848','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2024-12-31 13:17:36','54400','DBU','DEPOSITO BUCARAMANGA','2','1300.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','0','2','1','','31/12/2024','','0','54400','0','7702645205231',' ALCANFOR * 36 BARRAS','263','LEON','2024-12-31 13:17:36',  23262, 62749, 426, 249, 8022232)
			   ,('FVE','DP1','021689','2024-12-31 13:18:30','122024','CO','13515975','OSCAR FERNANDO ','GOMEZ GOMEZ ','CRA 46 NO.96-20',' 3229513277','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','4','16784.873949579833','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 13:19:48','17200','50','DEPOSITO CUCUTA ','1','7000.00000000','7000.00000000','7000','0','7000','1','0','1','','31/12/2024','','17200','0','0','7702184010150','LOPERAMIDA 2 MG *6 TAB','249','ECAR','2024-12-31 13:18:30',  1721.75, 29743, 2, 19, 8025850)
			   ,('FVE','DP1','021689','2024-12-31 13:18:30','122024','CO','13515975','OSCAR FERNANDO ','GOMEZ GOMEZ ','CRA 46 NO.96-20',' 3229513277','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','4','16784.873949579833','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 13:19:48','17200','50','DEPOSITO CUCUTA ','1','7600.00000000','7600.00000000','7600','0','7600','0','1','1','','31/12/2024','','17200','0','0','7594002621989','FLORATIL 250MG *10 SOBRES','761','AXON PHARMA ','2024-12-31 13:18:30',  46090, 33629, 2, 19, 8025850)
			   ,('FVE','DP1','021689','2024-12-31 13:18:30','122024','CO','13515975','OSCAR FERNANDO ','GOMEZ GOMEZ ','CRA 46 NO.96-20',' 3229513277','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','4','16784.873949579833','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 13:19:48','17200','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','31/12/2024','','17200','0','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2024-12-31 13:18:30',  1613.7, 52184, 2, 19, 8025850)
			   ,('FVE','DP1','021691','2024-12-31 13:24:46','122024','CR','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','7563.025210084034','1436.9747899159656','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 14:45:18','9000','50','DEPOSITO CUCUTA ','1','9000.00000000','9000.00000000','7563.025210084','1436.974789916','9000','1','0','0','','31/12/2024','','0','0','9000','7702425804821','HUGGIES TOALLITAS MANITOS Y CARITA ANTIBACTERIAL *80 UND','141','COLOMBIANA KIMBERLY COLPAPEL','2024-12-31 13:24:46',  5280.03, 56907, 2, 19, 8025888)
			   ,('FVE','DP1','021690','2024-12-31 13:34:40','122024','CR','1066865433','EDWIN DANILO ','CUVIDES PAEZ ','CALLE 23 NO.12-18 MONTEVIDEO 1',' 3209625939','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','4','37353.78151260504','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 13:36:57','38200','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','31/12/2024','','0','0','38200','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2024-12-31 13:34:40',  3375, 24465, 2, 19, 8025931)
			   ,('FVE','DP1','021690','2024-12-31 13:34:40','122024','CR','1066865433','EDWIN DANILO ','CUVIDES PAEZ ','CALLE 23 NO.12-18 MONTEVIDEO 1',' 3209625939','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','4','37353.78151260504','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 13:36:57','38200','50','DEPOSITO CUCUTA ','1','20000.00000000','20000.00000000','20000','0','20000','1','0','0','','31/12/2024','','0','0','38200','7707019334203','FUNGISTEROL SHAMPOO * 100 ML','130','LABQUIFAR PHARMACEUTICA','2024-12-31 13:34:40',  9554, 45856, 2, 19, 8025931)
			   ,('FVE','DP1','021690','2024-12-31 13:34:40','122024','CR','1066865433','EDWIN DANILO ','CUVIDES PAEZ ','CALLE 23 NO.12-18 MONTEVIDEO 1',' 3209625939','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','4','37353.78151260504','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 13:36:57','38200','50','DEPOSITO CUCUTA ','1','12900.00000000','12900.00000000','12900','0','12900','1','0','0','','31/12/2024','','0','0','38200','7702605100491','AZITROMICINA 500 MG * 3 TAB','193','GENFAR','2024-12-31 13:34:40',  8831.2, 25916, 2, 19, 8025931)
			   ,('FVE','DB1','002004','2024-12-31 13:47:47','122024','CR','1046693396','JORMAN DAVID','BUELVAS PADILLA','CALLE 113A NO.83-24',' 3244162184','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-31 13:55:41','4000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','31/12/2024','','0','0','4000','7701021143655','WINNY TOALLITAS ALOE + VITAMINA E * 24 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2024-12-31 13:47:47',  2510.1, 43316, 119, 53, 8026037)
			   ,('FVE','DB1','002005','2024-12-31 13:51:58','122024','CO','1042460032','JAIRO ALONSO','TORRES YANES','CRA 54 NO.14-23 BARRIO 1RA DE ',' 3024390967','985','NABYS  DE JESúS ','MORENO RIVERO ','','TERCERO','VARIOS','','','','','','2','13025.210084033613','2474.7899159663866','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2024-12-31 13:55:41','15500','DB','DEPOSITO BARRANQUILLA','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','1','','31/12/2024','','0','15500','0','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2024-12-31 13:51:58',  9366, 24473, 119, 53, 8026063)
			   ,('FVE','DP1','021692','2024-12-31 14:43:33','122024','CR','37398259','LILIANA ','RINC oacute N MEDINA','CALLE 20A 22 15 MUJERES DEL FU',' 3133135840','4362','JULIANA VALENTINA','GOMEZ PABON','','TERCERO','VARIOS','','','','','','3','56000','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 14:59:55','56000','50','DEPOSITO CUCUTA ','2','28000.00000000','56000.00000000','56000','0','56000','2','0','0','','31/12/2024','','0','0','56000','7707019402131','DOSALDIN GOTAS * 30 ML','130','LABQUIFAR PHARMACEUTICA','2024-12-31 14:43:33',  15138.5, 45887, 2, 19, 8026630)
			   ,('FVE','DP1','021693','2024-12-31 15:00:40','122024','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','33163.86554621848','3736.134453781513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 15:00:40','36900','50','DEPOSITO CUCUTA ','1','13500.00000000','13500.00000000','13500','0','13500','1','0','1','','31/12/2024','','36900','0','0','7502253072993','LECHE DE MAGNESIA PHILLIPS * 120 ML','116','ASPEN COLOMBIANA SAS','2024-12-31 15:00:40',  11839, 28686, 2, 19, 8026597)
			   ,('FVE','DP1','021693','2024-12-31 15:00:40','122024','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','33163.86554621848','3736.134453781513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 15:00:40','36900','50','DEPOSITO CUCUTA ','1','23400.00000000','23400.00000000','19663.865546218','3736.1344537815','23400','1','0','1','','31/12/2024','','36900','0','0','4005800137679','NIVEA CREMA *60 GR','123','BDF (BEIERSDORF) ','2024-12-31 15:00:40',  12176.2782, 23202, 2, 19, 8026597)
			   ,('FVE','DP1','021694','2024-12-31 16:20:06','122024','CO','1092526785','OSCAR ANDRES','LIZCANO CLARO','AVENIDA 2 NO.4-71 LA VICTORIA',' 3212392812','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','23529.411764705885','4470.588235294115','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2024-12-31 16:20:06','28000','50','DEPOSITO CUCUTA ','1','28000.00000000','28000.00000000','23529.411764706','4470.5882352941','28000','1','0','0','','31/12/2024','','28000','0','0','7500435019491','H & S SHAMPOO MEN 3EN1 CONTROL CASPA *375 ML','336','PROCTER & GAMBLE COLOMBIA','2024-12-31 16:20:06',  14899.059, 54720, 2, 19, 8022222);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '122024' AND DECODBOD='00';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '122024' AND DECODBOD='00';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '122024' AND DECODBOD='00';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '122024' AND DECODBOD='00';
DELETE FROM consolida2 WHERE PERIODOESPE = '122024' AND CODSUCURSAL = '00';
