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','022734','2025-04-12 17:45:04','042025','CR','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','23781.51260504202','4518.487394957981','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-12 18:05:19','28300','50','DEPOSITO CUCUTA ','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','0','','13/04/2025','','0','0','28300','7702045563726','BALANCE CLINICAL CREMA MINI MEN * 30 GR','203','HENKEL COLOMBIANA','2025-04-12 17:45:04',  2640, 52775, 2, 19, 8571511)
			   ,('FVE','DP1','022734','2025-04-12 17:45:04','042025','CR','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','23781.51260504202','4518.487394957981','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-12 18:05:19','28300','50','DEPOSITO CUCUTA ','1','4300.00000000','4300.00000000','3613.4453781513','686.55462184874','4300','1','0','0','','13/04/2025','','0','0','28300','7702006202831','SAVITAL SHAMPOO MULTIVITAMINAS Y SAVILA * 100 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-12 17:45:04',  2280, 60676, 2, 19, 8571511)
			   ,('FVE','DP1','022734','2025-04-12 17:45:04','042025','CR','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','23781.51260504202','4518.487394957981','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-12 18:05:19','28300','50','DEPOSITO CUCUTA ','1','4300.00000000','4300.00000000','3613.4453781513','686.55462184874','4300','1','0','0','','13/04/2025','','0','0','28300','7702006404594','SAVITAL ACOND FUERZA EXTRAORDINARIA * 100 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-12 17:45:04',  0, 60678, 2, 19, 8571511)
			   ,('FVE','DP1','022734','2025-04-12 17:45:04','042025','CR','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','23781.51260504202','4518.487394957981','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-12 18:05:19','28300','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','13/04/2025','','0','0','28300','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2025-04-12 17:45:04',  3090, 40129, 2, 19, 8571511)
			   ,('FVE','DP1','022734','2025-04-12 17:45:04','042025','CR','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','23781.51260504202','4518.487394957981','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-12 18:05:19','28300','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','13/04/2025','','0','0','28300','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-04-12 17:45:04',  3090, 40145, 2, 19, 8571511)
			   ,('FVE','DB1','002241','2025-04-13 17:15:22','042025','CR','1143265157','LUIS JESUS','ORTIZ RAMIREZ','CRA 85 NO.129-27 CIUDAD CARIBE',' 3024387336','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','10924.36974789916','2075.63025210084','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-13 17:36:25','13000','DB','DEPOSITO BARRANQUILLA','1','13000.00000000','13000.00000000','10924.369747899','2075.6302521008','13000','1','0','0','','13/04/2025','','0','0','13000','7501032916176','AMBIENTADOR GLADE SPRAY PARAISO AZUL * 400 ML','825','SC JOHNSON ','2025-04-13 17:15:22',  5112, 57841, 119, 53, 8573300)
			   ,('FVE','DB1','002242','2025-04-13 17:21:37','042025','CR','1050839168','JORDIN DAVID','IBA ntilde EZ MARTINEZ','CRA 96 CALLE 130-141 CARIBE VE',' 3005953291','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','21344.537815126052','4055.462184873948','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-13 17:36:25','25400','DB','DEPOSITO BARRANQUILLA','1','25400.00000000','25400.00000000','21344.537815126','4055.4621848739','25400','1','0','0','','13/04/2025','','0','0','25400','7702045006681','KONZIL C/PEINAR ACEITE DE ALMENDRAS X 2 * 230 ML C/U','203','HENKEL COLOMBIANA','2025-04-13 17:21:37',  16344, 55743, 119, 53, 8573311)
			   ,('FVE','DP1','022735','2025-04-14 07:12:33','042025','CO','1148214960','ERICKSSON GUSTAVO','VILLAMIZAR CORTEZ','CALLE 2 NO. 0A-22 BOCONO',' 3026897867','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','21','4000','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-14 07:32:31','4000','50','DEPOSITO CUCUTA ','10','400.00000000','4000.00000000','4000','0','4000','0','10','1','','13/04/2025','','4000','0','0','7702605101795','METRONIDAZOL 500 MG * 100 TAB','193','GENFAR','2025-04-14 07:12:33',  19635, 26122, 2, 19, 8574030)
			   ,('FVE','DP1','022736','2025-04-14 07:22:50','042025','CO','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','3','4400','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-14 07:32:31','4400','50','DEPOSITO CUCUTA ','2','2200.00000000','4400.00000000','4400','0','4400','0','2','1','','13/04/2025','','4400','0','0','7702057092757','IBUFLASH MIGRAN * 30 CAP','382','TECNOQUIMICAS','2025-04-14 07:22:50',  50678, 58898, 2, 19, 8574110)
			   ,('FVE','DP1','022738','2025-04-14 07:30:06','042025','CR','1090371784','LEANDRO ENRIQUE','SUAREZ CARRERO','AV  11E #21-27 LOS LAURELES',' 3124105086 3144328532','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','59600','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 08:26:22','59600','50','DEPOSITO CUCUTA ','1','59600.00000000','59600.00000000','59600','0','59600','1','0','0','','13/04/2025','','0','0','59600','7702057015602','ZELIX 500 MG *6 TAB','877','TECNOQUIMICAS VM TQ','2025-04-14 07:30:06',  52363.15, 61548, 2, 19, 8574192)
			   ,('FVE','DP1','022737','2025-04-14 07:57:59','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','10','96134.4537815126','18265.54621848739','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 07:57:59','114399.99999999999','50','DEPOSITO CUCUTA ','1','17300.00000000','17300.00000000','14537.81512605','2762.1848739496','17300','1','0','1','','13/04/2025','','0','114400','0','7702006653527','EGO CREMA PEINAR FIJACION DURADERA * 265 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-14 07:57:59',  0, 65417, 2, 19, 8574571)
			   ,('FVE','DP1','022737','2025-04-14 07:57:59','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','10','96134.4537815126','18265.54621848739','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 07:57:59','114399.99999999999','50','DEPOSITO CUCUTA ','1','35200.00000000','35200.00000000','29579.831932773','5620.1680672269','35200','1','0','1','','13/04/2025','','0','114400','0','7702031976493','LISTERINE ANTICARIES ZERO ALCOHOL * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-14 07:57:59',  21937.3, 50830, 2, 19, 8574571)
			   ,('FVE','DP1','022737','2025-04-14 07:57:59','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','10','96134.4537815126','18265.54621848739','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 07:57:59','114399.99999999999','50','DEPOSITO CUCUTA ','3','5000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','3','0','1','','13/04/2025','','0','114400','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-04-14 07:57:59',  3090, 40145, 2, 19, 8574571)
			   ,('FVE','DP1','022737','2025-04-14 07:57:59','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','10','96134.4537815126','18265.54621848739','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 07:57:59','114399.99999999999','50','DEPOSITO CUCUTA ','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','1','','13/04/2025','','0','114400','0','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-14 07:57:59',  8027, 49624, 2, 19, 8574571)
			   ,('FVE','DP1','022737','2025-04-14 07:57:59','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','10','96134.4537815126','18265.54621848739','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 07:57:59','114399.99999999999','50','DEPOSITO CUCUTA ','1','25000.00000000','25000.00000000','21008.403361345','3991.5966386555','25000','1','0','1','','13/04/2025','','0','114400','0','42332862','NIVEA MEN INVISIBLE BLACK & WHITE BARRA *50 GR','123','BDF (BEIERSDORF) ','2025-04-14 07:57:59',  15610, 52628, 2, 19, 8574571)
			   ,('FVE','DP1','022737','2025-04-14 07:57:59','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','10','96134.4537815126','18265.54621848739','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 07:57:59','114399.99999999999','50','DEPOSITO CUCUTA ','2','5200.00000000','10400.00000000','8739.4957983193','1660.5042016807','10400','2','0','1','','13/04/2025','','0','114400','0','7702010420993','PROTEX JABON PRO-HIDRATA MACADAMIA *110 GR','145','COLGATE PALMOLIVE COMPANIA','2025-04-14 07:57:59',  2836, 52325, 2, 19, 8574571)
			   ,('FVE','DP1','022739','2025-04-14 08:53:04','042025','CR','1014257783','DIANA PAOLA','ROBAYO MATEUS','CALLE 8 # 2-16 COMUNEROS',' 3013565944','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','3','7142.857142857143','1357.1428571428564','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-14 08:55:56','8500','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','0','','14/04/2025','','0','0','8500','7702010111587','COLGATE CREMA DENTAL TRIPLE EXTRA BLANCURA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-14 08:53:04',  2914, 48567, 2, 19, 8575665)
			   ,('FVE','DP1','022739','2025-04-14 08:53:04','042025','CR','1014257783','DIANA PAOLA','ROBAYO MATEUS','CALLE 8 # 2-16 COMUNEROS',' 3013565944','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','3','7142.857142857143','1357.1428571428564','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-14 08:55:56','8500','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','14/04/2025','','0','0','8500','7702277865964','TOALLITAS ARRURRU AVENA Y KARITE * 20 UND','124','BELLEZA EXPRESS SA','2025-04-14 08:53:04',  2006, 54335, 2, 19, 8575665)
			   ,('FVE','DP1','022740','2025-04-14 09:04:04','042025','CO','88256247','ELKIN ANTONIO','RODRIGUEZ MALAGON','CALLE 27 NO. 11-35 BELLA VISTA','5781240 3144803965','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','2184.8739495798322','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 09:05:56','2600','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','14/04/2025','','2600','0','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-14 09:04:04',  1613.7, 52184, 2, 19, 8575755)
			   ,('FVE','DP1','022741','2025-04-14 09:53:40','042025','CR','1193479640','JHOAN JOS eacute ','HERRERA CELIS','CALLE 4 NO.1-39 BARRIO LA VICT',' 3229272401','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','38500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 09:56:25','38500','50','DEPOSITO CUCUTA ','1','38500.00000000','38500.00000000','38500','0','38500','1','0','0','','14/04/2025','','0','0','38500','7702605102211','CLARITROMICINA 500 MG * 10 TAB ','193','GENFAR','2025-04-14 09:53:40',  26400, 25964, 2, 19, 8576400)
			   ,('FVE','DP1','022742','2025-04-14 11:37:01','042025','CO','1093785231','YELITZA KATHERINE','SILVA CONTRERAS','CALLE 3 NO.1-37 SAN MATEO','5845734 3115081821','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','7142.857142857143','1357.1428571428569','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 11:41:04','8500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','1','','14/04/2025','','0','8500','0','7707773834698','MASGLO ESMALTE BASE UÑAS FUERTES *13.5 ML','801','CERESCOS','2025-04-14 11:37:01',  5657.28, 55554, 2, 19, 8577438)
			   ,('FVE','DP1','022743','2025-04-14 12:11:24','042025','CR','1004821121','YURLEY','DURAN PEREZ','CALLE 15 NO:19-60 NUEVO HORIZO',' 3228709991','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 12:53:31','4000','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','14/04/2025','','0','0','4000','7702277865964','TOALLITAS ARRURRU AVENA Y KARITE * 20 UND','124','BELLEZA EXPRESS SA','2025-04-14 12:11:24',  2006, 54335, 2, 19, 8577687)
			   ,('FVE','DP1','022744','2025-04-14 13:38:40','042025','CO','1090519336','JHONATAN DAVID ','ZERPA VILLAMIZAR ','MZ D15 CASA 6 TORCOROMA 2 TORC','5768090 3507990281','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','4453.781512605042','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 13:39:44','5300','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','14/04/2025','','5300','0','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-14 13:38:40',  3375, 24465, 2, 19, 8578111)
			   ,('FVE','DP1','022745','2025-04-14 14:07:20','042025','CR','1090434374','JESSICA LORENA','VELANDIA DAZA','',' 3165717093','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','9663.865546218487','1836.134453781513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 14:18:34','11500','50','DEPOSITO CUCUTA ','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','14/04/2025','','0','0','11500','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-14 14:07:20',  8027, 49624, 2, 19, 8578271)
			   ,('FVE','DP1','022746','2025-04-14 14:56:28','042025','CR','1090507448','KAREN','ASCANIO','AVENIDA 15 CALLE 12 BELISARIO ',' 3228296015','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','11512.605042016807','2187.3949579831924','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 15:11:37','13700','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','14/04/2025','','0','0','13700','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-04-14 14:56:28',  4412, 55331, 2, 19, 8578657)
			   ,('FVE','DP1','022746','2025-04-14 14:56:28','042025','CR','1090507448','KAREN','ASCANIO','AVENIDA 15 CALLE 12 BELISARIO ',' 3228296015','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','11512.605042016807','2187.3949579831924','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 15:11:37','13700','50','DEPOSITO CUCUTA ','2','2600.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','2','0','0','','14/04/2025','','0','0','13700','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-14 14:56:28',  1613.7, 52184, 2, 19, 8578657)
			   ,('FVE','DP1','022747','2025-04-14 15:38:37','042025','CR','1127361595','JORGE','NIETO','CRA 14 NO.25-12 GRAN COLOMBIA',' 3155354339','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','15500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 15:41:05','15500','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','15500','0','15500','1','0','0','','14/04/2025','','0','0','15500','7702057070465','AMOXICILINA 250 MG * 100 ML','654','MK ETICOS CONVENIO','2025-04-14 15:38:37',  10937, 42793, 2, 19, 8579007)
			   ,('FVE','DP1','022748','2025-04-14 15:51:03','042025','CR','1004842741','ANGEL GABRIELA','CONTRERAS RIA Ntilde O','CALLE 3 NO.1-37 SAN MATEO PART',' 3202279289','3976','JOEL','OTALVAREZ','','TERCERO','VARIOS','','','','','','3','19400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 15:54:05','19400','50','DEPOSITO CUCUTA ','2','9700.00000000','19400.00000000','19400','0','19400','2','0','0','','14/04/2025','','0','0','19400','7702026149567','NOSOTRAS BUENAS NOCHES TELA *10 UND','337','FAMILIA SANCELA','2025-04-14 15:51:03',  7892, 40265, 2, 19, 8579129)
			   ,('FVE','DP1','022749','2025-04-14 16:01:26','042025','CO','88256247','ELKIN ANTONIO','RODRIGUEZ MALAGON','CALLE 27 NO. 11-35 BELLA VISTA','5781240 3144803965','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','6386.55462184874','1213.4453781512602','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 16:04:43','7600','50','DEPOSITO CUCUTA ','1','7600.00000000','7600.00000000','6386.5546218487','1213.4453781513','7600','1','0','1','','14/04/2025','','7600','0','0','7702006301442','TALCO REXONA EFFICIENT * 55 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-14 16:01:26',  4992, 44092, 2, 19, 8579233)
			   ,('FVE','DB1','002243','2025-04-14 16:10:35','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','18','65992.43697478992','4007.5630252100837','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:10:35','70000','DB','DEPOSITO BARRANQUILLA','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','14/04/2025','','0','70000','0','7702027478741','TENA SLIP ULTRA L *1 UND','337','FAMILIA SANCELA','2025-04-14 16:10:35',  4283, 33335, 119, 53, 8570808)
			   ,('FVE','DB1','002243','2025-04-14 16:10:35','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','18','65992.43697478992','4007.5630252100837','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:10:35','70000','DB','DEPOSITO BARRANQUILLA','1','5900.00000000','5900.00000000','4957.9831932773','942.01680672269','5900','1','0','1','','14/04/2025','','0','70000','0','7702027477744','TENA SLIP ULTRA XL *1 UND','337','FAMILIA SANCELA','2025-04-14 16:10:35',  4156.2, 49069, 119, 53, 8570808)
			   ,('FVE','DB1','002243','2025-04-14 16:10:35','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','18','65992.43697478992','4007.5630252100837','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:10:35','70000','DB','DEPOSITO BARRANQUILLA','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','1','','14/04/2025','','0','70000','0','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2025-04-14 16:10:35',  1823.4, 54241, 119, 53, 8570808)
			   ,('FVE','DB1','002243','2025-04-14 16:10:35','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','18','65992.43697478992','4007.5630252100837','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:10:35','70000','DB','DEPOSITO BARRANQUILLA','1','6900.00000000','6900.00000000','6900','0','6900','1','0','1','','14/04/2025','','0','70000','0','7702027424113','NOSOTRAS INVISIBLE RAPIGEL * 10 GTS OBSEQUIO','337','FAMILIA SANCELA','2025-04-14 16:10:35',  6000, 51630, 119, 53, 8570808)
			   ,('FVE','DB1','002243','2025-04-14 16:10:35','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','18','65992.43697478992','4007.5630252100837','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:10:35','70000','DB','DEPOSITO BARRANQUILLA','1','3900.00000000','3900.00000000','3277.3109243697','622.68907563025','3900','1','0','1','','14/04/2025','','0','70000','0','7701021120144','CONTENT MEDICAL L * 1 UND','653','TECNOQUIMICAS WINNY','2025-04-14 16:10:35',  2728, 64543, 119, 53, 8570808)
			   ,('FVE','DB1','002243','2025-04-14 16:10:35','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','18','65992.43697478992','4007.5630252100837','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:10:35','70000','DB','DEPOSITO BARRANQUILLA','2','3600.00000000','7200.00000000','6050.4201680672','1149.5798319328','7200','2','0','1','','14/04/2025','','0','70000','0','7701021112484','CONTENT ULTRASEC TALLA L *1 UND (INACTIVO)','653','TECNOQUIMICAS WINNY','2025-04-14 16:10:35',  2604, 58782, 119, 53, 8570808)
			   ,('FVE','DB1','002243','2025-04-14 16:10:35','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','18','65992.43697478992','4007.5630252100837','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:10:35','70000','DB','DEPOSITO BARRANQUILLA','2','19000.00000000','38000.00000000','38000','0','38000','2','0','1','','14/04/2025','','0','70000','0','7702026190545','NOSOTRAS INVISIBLE ORGANICO * 24 UND ','337','FAMILIA SANCELA','2025-04-14 16:10:35',  0, 58683, 119, 53, 8570808)
			   ,('FVE','DB1','002244','2025-04-14 16:14:40','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','5','114100','0','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:14:40','114100','DB','DEPOSITO BARRANQUILLA','1','43600.00000000','43600.00000000','43600','0','43600','1','0','1','','14/04/2025','','0','114100','0','7707019332124','CINDIMIZOL 200 MG * 5 CAP','130','LABQUIFAR PHARMACEUTICA','2025-04-14 16:14:40',  5500, 27599, 119, 53, 8570778)
			   ,('FVE','DB1','002244','2025-04-14 16:14:40','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','5','114100','0','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:14:40','114100','DB','DEPOSITO BARRANQUILLA','1','5200.00000000','5200.00000000','5200','0','5200','1','0','1','','14/04/2025','','0','114100','0','7703038060420','DIFENHIDRAMINA *120 ML','275','LAPROFF','2025-04-14 16:14:40',  3273, 30429, 119, 53, 8570778)
			   ,('FVE','DB1','002244','2025-04-14 16:14:40','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','5','114100','0','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:14:40','114100','DB','DEPOSITO BARRANQUILLA','1','23400.00000000','23400.00000000','23400','0','23400','1','0','1','','14/04/2025','','0','114100','0','7702057711931','AZITROMICINA 200 MG/5 MG SUSP * 15 ML','654','MK ETICOS CONVENIO','2025-04-14 16:14:40',  17125, 42808, 119, 53, 8570778)
			   ,('FVE','DB1','002244','2025-04-14 16:14:40','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','5','114100','0','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:14:40','114100','DB','DEPOSITO BARRANQUILLA','1','41900.00000000','41900.00000000','41900','0','41900','1','0','1','','14/04/2025','','0','114100','0','7702057070502','AMOXICILINA 500 MG * 60 CAP','654','MK ETICOS CONVENIO','2025-04-14 16:14:40',  26773, 42794, 119, 53, 8570778)
				  ,('FVE','DB1','002245','2025-04-14 16:16:00','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','7','126900','0','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:16:00','126900','DB','DEPOSITO BARRANQUILLA','1','9400.00000000','9400.00000000','9400','0','9400','1','0','1','','14/04/2025','','0','126900','0','7702560009525','ALCOHOL JGB *700 ML','219','JGB','2025-04-14 16:16:00',  6669, 27765, 119, 53, 8570790);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DB1','002245','2025-04-14 16:16:00','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','7','126900','0','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:16:00','126900','DB','DEPOSITO BARRANQUILLA','3','25500.00000000','76500.00000000','76500','0','76500','3','0','1','','14/04/2025','','0','126900','0','7707141350270','ENEMA TRAVAD FOSFATO RECTAL * 133 ML','877','TECNOQUIMICAS VM TQ','2025-04-14 16:16:00',  22134, 42970, 119, 53, 8570790)
			   ,('FVE','DB1','002245','2025-04-14 16:16:00','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','7','126900','0','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-14 16:16:00','126900','DB','DEPOSITO BARRANQUILLA','2','20500.00000000','41000.00000000','41000','0','41000','2','0','1','','14/04/2025','','0','126900','0','7707229971137','ENEMATROL ENEMA RECTAL *133 ML  ','351','QUIBI','2025-04-14 16:16:00',  9706, 41539, 119, 53, 8570790)
			   ,('FVE','DP1','022750','2025-04-14 18:35:08','042025','CO','1093785231','YELITZA KATHERINE','SILVA CONTRERAS','CALLE 3 NO.1-37 SAN MATEO','5845734 3115081821','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','12900','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-14 18:49:08','12900','50','DEPOSITO CUCUTA ','1','12900.00000000','12900.00000000','12900','0','12900','1','0','1','','15/04/2025','','0','12900','0','7706569001245','AZITROMICINA 500 MG * 3 TAB','614','A.G. MEDICAMENTOS','2025-04-14 18:35:08',  5097, 31223, 2, 19, 8580331)
			   ,('FVE','DP1','022751','2025-04-14 18:38:55','042025','CO','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','45238.09523809524','2261.9047619047633','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-14 18:38:55','47500','50','DEPOSITO CUCUTA ','1','52500.00000000','52500.00000000','45238.095238095','2261.9047619048','47500','1','0','0','','15/04/2025','','0','47500','0','7702168278477','AGUARDIENTE AMARILLO DE MANZANARES *750 ML','809','COMORIENTE','2025-04-14 18:38:55',  41357, 61766, 2, 19, 8579496)
			   ,('FVE','DP1','022754','2025-04-15 08:26:09','042025','CR','1090518110','SOF iacute A','RAMIREZ','CALLE 4A NO. 14-45 LOMAS DE BO',' 3118253134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','22500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 08:43:23','22500','50','DEPOSITO CUCUTA ','1','22500.00000000','22500.00000000','22500','0','22500','1','0','0','','15/04/2025','','0','0','22500','7702184021002','HEDERA HELIX + PROPOLEO JARABE FRASCO * 100 ML','249','ECAR','2025-04-15 08:26:09',  4365, 63778, 2, 19, 8582193)
			   ,('FVE','DP1','022752','2025-04-15 08:37:15','042025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','4369.7478991596645','830.2521008403355','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 08:39:29','5200','50','DEPOSITO CUCUTA ','2','2600.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','2','0','1','','15/04/2025','','0','5200','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-15 08:37:15',  1613.7, 52184, 2, 19, 8582234)
			   ,('FVE','DP1','022753','2025-04-15 08:43:11','042025','CO','1090516234','KEILA','CARRILLO PARRA','CALLE 9 AVENIDA 19 NO.16 NUEVO',' 3138620788','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','26884.873949579833','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 08:43:11','27300','50','DEPOSITO CUCUTA ','1','24700.00000000','24700.00000000','24700','0','24700','1','0','1','','15/04/2025','','0','27300','0','7702605100927','DICLOFENACO GEL * 50 GR','193','GENFAR','2025-04-15 08:43:11',  18405, 26003, 2, 19, 8578995)
			   ,('FVE','DP1','022753','2025-04-15 08:43:11','042025','CO','1090516234','KEILA','CARRILLO PARRA','CALLE 9 AVENIDA 19 NO.16 NUEVO',' 3138620788','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','26884.873949579833','415.12605042016776','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 08:43:11','27300','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','15/04/2025','','0','27300','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-15 08:43:11',  1613.7, 52184, 2, 19, 8578995)
			   ,('FVE','DP1','022755','2025-04-15 10:51:08','042025','CR','1090531686','ELIAB DANIEL','ROMERO PARRA','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','16400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 10:54:05','16400','50','DEPOSITO CUCUTA ','1','16400.00000000','16400.00000000','16400','0','16400','1','0','0','','15/04/2025','','0','0','16400','7702057061265','OXIMETAZOLINA 0.05% NASAL ADULTOS * 15 ML','654','MK ETICOS CONVENIO','2025-04-15 10:51:08',  11449.5, 43203, 2, 19, 8583491)
			   ,('FVE','DP1','022758','2025-04-15 10:52:14','042025','CR','79415594','LUIS CARLOS','CEBALLOS DUARTE','AV LIBERTADORES EDIFICIO FLORI','000000 3217061656','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','49320','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-15 16:21:44','49320','50','DEPOSITO CUCUTA ','1','54800.00000000','54800.00000000','49320','0','49320','1','0','0','','15/04/2025','','0','0','49320','7702870494325','STODALINE S/AZUCAR *200 ML','1043','BOIRON ','2025-04-15 10:52:14',  31925, 58098, 2, 19, 8583512)
			   ,('FVE','DP1','022770','2025-04-15 12:59:52','042025','CR','1148214962','ESNEIDER MIGUEL','VILLAMIZAR CORTEZ ','TIENDITAS PARTE BAJA',' 3208779164','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','6386.55462184874','1213.4453781512598','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 16:54:14','7600','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','0','','16/04/2025','','0','0','7600','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-15 12:59:52',  1613.7, 52184, 2, 19, 8584585)
			   ,('FVE','DP1','022770','2025-04-15 12:59:52','042025','CR','1148214962','ESNEIDER MIGUEL','VILLAMIZAR CORTEZ ','TIENDITAS PARTE BAJA',' 3208779164','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','6386.55462184874','1213.4453781512598','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 16:54:14','7600','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','16/04/2025','','0','0','7600','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-04-15 12:59:52',  3144, 40145, 2, 19, 8584585)
			   ,('FVE','DP1','022756','2025-04-15 13:32:51','042025','CO','1092525971','SANTOS ALEJANDRO','ROJAS DURAN','CALLE 22 NO.4-67 APTO 202',' 3227890419','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','8000','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 13:32:51','8000','50','DEPOSITO CUCUTA ','10','800.00000000','8000.00000000','8000','0','8000','0','10','1','','15/04/2025','','0','8000','0','7706569000026','AMOXICILINA 500 MG * 50 CAP','614','A.G. MEDICAMENTOS','2025-04-15 13:32:51',  19521.9, 31190, 2, 19, 8584714)
			   ,('FVE','DP1','022757','2025-04-15 15:24:53','042025','CR','1090531686','ELIAB DANIEL','ROMERO PARRA','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','64400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 15:35:42','64400','50','DEPOSITO CUCUTA ','1','64400.00000000','64400.00000000','64400','0','64400','1','0','0','','15/04/2025','','0','0','64400','7896226501796','BACTRIM 400 MG/80 MG * 20 TAB','285','SIEGFRIED FARMA','2025-04-15 15:24:53',  52080.9, 41559, 2, 19, 8585580)
			   ,('FVE','DP1','022761','2025-04-15 15:33:57','042025','CR','1003393111','EDINSON CAMILO','TARAZONA CUVIDES','CRA 9B NO.27-56 BUENA VISTA 2',' 3003402175','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','8235.29411764706','1564.7058823529405','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 18:26:37','9800','50','DEPOSITO CUCUTA ','1','4800.00000000','4800.00000000','4033.6134453782','766.38655462185','4800','1','0','0','','16/04/2025','','0','0','9800','7702010470479','SPEED STICK MEN MINI CLINICAL CREMA * 30 GR','145','COLGATE PALMOLIVE COMPANIA','2025-04-15 15:33:57',  2551, 52614, 2, 19, 8585655)
			   ,('FVE','DP1','022761','2025-04-15 15:33:57','042025','CR','1003393111','EDINSON CAMILO','TARAZONA CUVIDES','CRA 9B NO.27-56 BUENA VISTA 2',' 3003402175','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','8235.29411764706','1564.7058823529405','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 18:26:37','9800','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','16/04/2025','','0','0','9800','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-04-15 15:33:57',  3144, 40145, 2, 19, 8585655)
			   ,('FVE','DP1','022759','2025-04-15 16:35:06','042025','CO','1090484261','ANDERSSON JESUS','BOHADA VILLALBA','AVENIDA 9B # 16LN-26 VILLA NUE','5780943 3203784930','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','29159.66386554622','5540.336134453781','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 16:35:06','34700','50','DEPOSITO CUCUTA ','1','34700.00000000','34700.00000000','29159.663865546','5540.3361344538','34700','1','0','1','','15/04/2025','','0','34700','0','7702035833839','LISTERINE CUIDADO TOTAL * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-15 16:35:06',  21937.3371, 28040, 2, 19, 8585594)
			   ,('FVE','DP1','022760','2025-04-15 16:36:51','042025','CO','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','3600','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-15 16:36:51','3600','50','DEPOSITO CUCUTA ','1','3600.00000000','3600.00000000','3600','0','3600','1','0','1','','15/04/2025','','3600','0','0','7702338689843','EFEXOR XR 37.5 MG * 7 CAP','116','ASPEN COLOMBIANA SAS','2025-04-15 16:36:51',  3288, 39070, 2, 19, 8586135)
			   ,('FVE','DB1','002246','2025-04-15 17:32:26','042025','CR','1010124899','ANDRES FELIPE','ARGOTE GAVIRIA','CRA 5A NO.33E-14 GIRON',' 3013099734','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','9','19700','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-15 17:34:53','19700','DB','DEPOSITO BARRANQUILLA','1','19700.00000000','19700.00000000','19700','0','19700','1','0','0','','15/04/2025','','0','0','19700','7703689000448','CYCLOFEM 0.5 ML * 1 AMP + JERINGA  ','344','PROFAMILIA','2025-04-15 17:32:26',  17329, 40547, 119, 53, 8586628)
			   ,('FVE','DB1','002247','2025-04-15 17:58:02','042025','CO','1048069289','JHOSUAR DE JESUS','VANEGAS CERME ntilde O','CALLE 50 NO.2D3-10 SAN VICENTE',' 3046332176','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','16134.453781512606','3065.546218487394','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-15 17:59:39','19200','DB','DEPOSITO BARRANQUILLA','1','19200.00000000','19200.00000000','16134.453781513','3065.5462184874','19200','1','0','1','','16/04/2025','','0','19200','0','7702433228862','VOGUE PESTAÑINA DE MUÑECA +VOLUMEN+ALARGADAS * 9GR','245','VOGUE','2025-04-15 17:58:02',  12518, 51468, 119, 53, 8586802)
			   ,('FVE','DB2','004118','2025-04-15 18:33:09','042025','CR','1064186454','JULIO','BELTRAN','CARRERA 12 NO. 21-47 SAN JUDAS',' 3203068136','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','123740.3361344538','19159.66386554621','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-15 18:39:01','142900','DBU','DEPOSITO BUCARAMANGA','1','23200.00000000','23200.00000000','19495.798319328','3704.2016806723','23200','1','0','0','','16/04/2025','','0','0','142900','7791293025797','AXE BODY SPRAY DARK TEMPTATION * 150 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-15 18:33:09',  16368, 47452, 426, 249, 8587012)
			   ,('FVE','DB2','004118','2025-04-15 18:33:09','042025','CR','1064186454','JULIO','BELTRAN','CARRERA 12 NO. 21-47 SAN JUDAS',' 3203068136','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','123740.3361344538','19159.66386554621','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-15 18:39:01','142900','DBU','DEPOSITO BUCARAMANGA','1','14000.00000000','14000.00000000','14000','0','14000','1','0','0','','16/04/2025','','0','0','142900','7707355053486','NOXPIRIN SINUS * 12 TAB PAGUE 10 LLEVE 12','626','SIEGFRIED CONSUMO','2025-04-15 18:33:09',  8423, 33749, 426, 249, 8587012)
			   ,('FVE','DB2','004118','2025-04-15 18:33:09','042025','CR','1064186454','JULIO','BELTRAN','CARRERA 12 NO. 21-47 SAN JUDAS',' 3203068136','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','123740.3361344538','19159.66386554621','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-15 18:39:01','142900','DBU','DEPOSITO BUCARAMANGA','2','40500.00000000','81000.00000000','68067.226890756','12932.773109244','81000','2','0','0','','16/04/2025','','0','0','142900','7709990384987','SHOT B *30 CAP','194','GENOMMA LABORATORIO COLOMBIA','2025-04-15 18:33:09',  25833, 26333, 426, 249, 8587012)
			   ,('FVE','DB2','004118','2025-04-15 18:33:09','042025','CR','1064186454','JULIO','BELTRAN','CARRERA 12 NO. 21-47 SAN JUDAS',' 3203068136','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','123740.3361344538','19159.66386554621','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-15 18:39:01','142900','DBU','DEPOSITO BUCARAMANGA','1','8900.00000000','8900.00000000','8900','0','8900','1','0','0','','16/04/2025','','0','0','142900','7703689031190','PIEL EXCITANTE * 3 PRESERVATIVOS','344','PROFAMILIA','2025-04-15 18:33:09',  3380, 40575, 426, 249, 8587012)
			   ,('FVE','DB2','004118','2025-04-15 18:33:09','042025','CR','1064186454','JULIO','BELTRAN','CARRERA 12 NO. 21-47 SAN JUDAS',' 3203068136','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','123740.3361344538','19159.66386554621','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-15 18:39:01','142900','DBU','DEPOSITO BUCARAMANGA','1','15800.00000000','15800.00000000','13277.31092437','2522.6890756303','15800','1','0','0','','16/04/2025','','0','0','142900','7501086454198','PRO CEPILLO 900 MEDIANO * 2 UND ','336','PROCTER & GAMBLE COLOMBIA','2025-04-15 18:33:09',  10260, 40002, 426, 249, 8587012)
			   ,('FVE','DB2','004122','2025-04-15 19:36:20','042025','CR','1093780922','KENNY YELITZA','OVALLOS GOMEZ','CRA 32W NO,64-40 MONTERREDONDO',' 3224159195','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','5400','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-16 18:28:20','5400','DBU','DEPOSITO BUCARAMANGA','2','2700.00000000','5400.00000000','5400','0','5400','2','0','0','','16/04/2025','','0','0','5400','7702057077112','ALGODON MK * 25 GR','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-04-15 19:36:20',  1851, 42770, 426, 249, 8587243)
			   ,('FVE','DP1','022762','2025-04-16 07:31:32','042025','CO','1090488404','WILLIAM MARLON','CACERES','TRASVERSAL 17 NO.K-249 PUEBLO ',' 3228984489','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','4','28154.621848739494','1245.3781512605037','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-16 07:31:32','29400','50','DEPOSITO CUCUTA ','1','9400.00000000','9400.00000000','9400','0','9400','1','0','1','','16/04/2025','','29400','0','0','7702560009525','ALCOHOL JGB *700 ML','219','JGB','2025-04-16 07:31:32',  6669, 27765, 2, 19, 8577978)
			   ,('FVE','DP1','022762','2025-04-16 07:31:32','042025','CO','1090488404','WILLIAM MARLON','CACERES','TRASVERSAL 17 NO.K-249 PUEBLO ',' 3228984489','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','4','28154.621848739494','1245.3781512605037','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-16 07:31:32','29400','50','DEPOSITO CUCUTA ','1','7800.00000000','7800.00000000','6554.6218487395','1245.3781512605','7800','1','0','1','','16/04/2025','','29400','0','0','7702031132844','JOHNSON ACEITE ORIG * 50 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-16 07:31:32',  5435, 27936, 2, 19, 8577978)
			   ,('FVE','DP1','022762','2025-04-16 07:31:32','042025','CO','1090488404','WILLIAM MARLON','CACERES','TRASVERSAL 17 NO.K-249 PUEBLO ',' 3228984489','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','4','28154.621848739494','1245.3781512605037','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-16 07:31:32','29400','50','DEPOSITO CUCUTA ','1','12200.00000000','12200.00000000','12200','0','12200','1','0','1','','16/04/2025','','29400','0','0','7706569001450','NAPROXENO 500 MG * 10 TAB','614','A.G. MEDICAMENTOS','2025-04-16 07:31:32',  4393, 31632, 2, 19, 8577978)
			   ,('FVE','DB1','002248','2025-04-16 07:53:04','042025','CR','1129532465','JESUS CAMILO','GARCIA GUTIERREZ','CALLE 136 NO.9-160 MANZANA 2 T',' 3245857827','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-16 07:55:04','4000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','16/04/2025','','0','0','4000','7702277865964','TOALLITAS ARRURRU AVENA Y KARITE * 20 UND','124','BELLEZA EXPRESS SA','2025-04-16 07:53:04',  2006, 54335, 119, 53, 8587963)
			   ,('FVE','DP1','022763','2025-04-16 08:27:55','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','16092.436974789915','3057.5630252100846','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 08:37:19','19150','50','DEPOSITO CUCUTA ','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','1','','16/04/2025','','0','19150','0','7702354939960','EGO CERA PARA PEINAR *160 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-16 08:27:55',  7093, 49396, 2, 19, 8588151)
			   ,('FVE','DP1','022763','2025-04-16 08:27:55','042025','CO','1093799454','JHORMAN CARDENAS','CARDENAS VALDERRAMA','CARRERA 9B NO.27-34 BUENA VIST',' 3203418091','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','16092.436974789915','3057.5630252100846','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 08:37:19','19150','50','DEPOSITO CUCUTA ','1','7650.00000000','7650.00000000','6428.5714285714','1221.4285714286','7650','1','0','1','','16/04/2025','','0','19150','0','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-04-16 08:27:55',  4412, 55331, 2, 19, 8588151)
			   ,('FVE','DP1','022764','2025-04-16 10:23:15','042025','CR','1010086333','ESNEIDER STYVEN','BECERRA BECERRA','',' 3008081615','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','6428.571428571428','1221.4285714285716','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 10:32:26','7650','50','DEPOSITO CUCUTA ','1','7650.00000000','7650.00000000','6428.5714285714','1221.4285714286','7650','1','0','0','','16/04/2025','','0','0','7650','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-04-16 10:23:15',  4412, 55331, 2, 19, 8588807)
			   ,('FVE','DP1','022765','2025-04-16 10:31:09','042025','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','2025-04-16 10:32:26','2600','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','16/04/2025','','2600','0','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-16 10:31:09',  1613.7, 52184, 2, 19, 8588855)
			   ,('FVE','DP1','022767','2025-04-16 10:47:15','042025','CR','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','60600','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 11:02:55','60600','50','DEPOSITO CUCUTA ','1','60600.00000000','60600.00000000','60600','0','60600','1','0','0','','16/04/2025','','0','0','60600','676194963560','VITAMINA C 1000 MG + COLAGENO 10 MG * 100 TAB','906','ALFA VITAMINS','2025-04-16 10:47:15',  32295, 61331, 2, 19, 8589014)
			   ,('FVE','DP1','022766','2025-04-16 11:02:41','042025','CO','1090531686','ELIAB DANIEL','ROMERO PARRA','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','12500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 11:02:41','12500','50','DEPOSITO CUCUTA ','1','12500.00000000','12500.00000000','12500','0','12500','1','0','1','','16/04/2025','','0','12500','0','7707288821220','ZOPICLONA 7.5 MG * 10 TAB','205','HUMAX PHARMACEUTICAL','2025-04-16 11:02:41',  6831, 27387, 2, 19, 8588775)
			   ,('FVE','DB2','004119','2025-04-16 13:06:35','032025','CO','1042000810','CARLOS ANTONIO ','VILLARREAL MARTINEZ ','MIRADOR DE SAN JUAN MANZANA P ',' 3226821031','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','82280','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-16 13:06:35','82280','DBU','DEPOSITO BUCARAMANGA','1','96800.00000000','96800.00000000','82280','0','82280','1','0','1','','16/04/2025','','0','82280','0','7708152336253','SUREZINC TRANSFER VAINILLA * 1000 GR','1007','SUREZINC','2025-04-16 13:06:35',  33208, 61483, 426, 249, 8489916)
			   ,('FVE','DP1','022768','2025-04-16 13:26:36','042025','CR','1066865433','EDWIN DANILO','CUVIDES PAEZ','CALLE 23 NO.12-18 MONTEVIDEO 1',' 3209625939','219','JHONATAN DAVID ','ZERPA VILLAMIZAR ','','TERCERO','VARIOS','','','','','','2','4453.781512605042','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 13:30:34','5300','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','16/04/2025','','0','0','5300','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-16 13:26:36',  3375, 24465, 2, 19, 8589890)
			   ,('FVE','DP1','022769','2025-04-16 16:27:12','042025','CO','13254155','RENE ','DIAZ','CALLE 17 # 2 - 83, GARCIA HERR','0 3223014163','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','35987.3949579832','6837.605042016806','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 16:27:27','42825','50','DEPOSITO CUCUTA ','1','37525.00000000','37525.00000000','31533.613445378','5991.3865546218','37525','1','0','1','','16/04/2025','','42825','0','0','7702113043259','TANGA BLOQ SPF 50 CREMA *130ML','278','RECAMIER','2025-04-16 16:27:12',  24482.7224, 61925, 2, 19, 8590962)
			   ,('FVE','DP1','022769','2025-04-16 16:27:12','042025','CO','13254155','RENE ','DIAZ','CALLE 17 # 2 - 83, GARCIA HERR','0 3223014163','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','35987.3949579832','6837.605042016806','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 16:27:27','42825','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','16/04/2025','','42825','0','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-16 16:27:12',  3375, 24465, 2, 19, 8590962)
				  ,('FVE','DP1','022773','2025-04-16 16:44:01','042025','CR','1004843315','KEVIN JOEL','OVIEDO VILLALBA','AVENIDA 8 CALLE 0BN-40 SEVILLA',' 3214913491','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','24000','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 18:16:49','24000','50','DEPOSITO CUCUTA ','1','24000.00000000','24000.00000000','24000','0','24000','1','0','0','','16/04/2025','','0','0','24000','7707019334203','FUNGISTEROL SHAMPOO * 100 ML','130','LABQUIFAR PHARMACEUTICA','2025-04-16 16:44:01',  10328, 45856, 2, 19, 8591156);
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','022771','2025-04-16 17:00:58','042025','CR','1093751562','DIEGO ALEXANDER','NI ntilde O CASTILLO','CL 15A # 8-70 TIERRA LINDA LOS','5553105 3132555071','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','17647.058823529413','3352.9411764705874','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 17:08:34','21000','50','DEPOSITO CUCUTA ','1','21000.00000000','21000.00000000','17647.058823529','3352.9411764706','21000','1','0','0','','16/04/2025','','0','0','21000','7702870101636','INTIBON MUJER VINAGRE DE MANZANA Y CALENDULA * 210 GR','124','BELLEZA EXPRESS SA','2025-04-16 17:00:58',  12590, 52799, 2, 19, 8591301)
			   ,('FVE','DB2','004120','2025-04-16 17:01:20','042025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','23580','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-21 10:20:35','23580','DBU','DEPOSITO BUCARAMANGA','1','23580.00000000','23580.00000000','23580','0','23580','1','0','0','','16/04/2025','','0','0','23580','7707232091808','PROPOMIELITO * 350 GR','271','NATURAL FRESHLY','2025-04-16 17:01:20',  14230.05, 30332, 426, 249, 8591307)
			   ,('FVE','DP1','022772','2025-04-16 17:05:20','042025','CO','1101360008','OSCAR JAVIER ','GOMEZ AMADO','',' 3234252451','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','20252.100840336134','3847.8991596638634','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 17:05:20','24099.999999999996','50','DEPOSITO CUCUTA ','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','1','','16/04/2025','','0','24100','0','8412765508905','ENCENDEDOR CLIPPER RECARGABLE','950','TRONEX','2025-04-16 17:05:20',  2205, 62092, 2, 19, 8591247)
			   ,('FVE','DP1','022772','2025-04-16 17:05:20','042025','CO','1101360008','OSCAR JAVIER ','GOMEZ AMADO','',' 3234252451','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','20252.100840336134','3847.8991596638634','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 17:05:20','24099.999999999996','50','DEPOSITO CUCUTA ','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','1','','16/04/2025','','0','24100','0','7702010421013','PROTEX JABON FOR MEN 10X SPORT *110 GR','145','COLGATE PALMOLIVE COMPANIA','2025-04-16 17:05:20',  2648, 52459, 2, 19, 8591247)
			   ,('FVE','DP1','022772','2025-04-16 17:05:20','042025','CO','1101360008','OSCAR JAVIER ','GOMEZ AMADO','',' 3234252451','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','20252.100840336134','3847.8991596638634','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 17:05:20','24099.999999999996','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','1','','16/04/2025','','0','24100','0','7702006206808','REXONA CLINICAL MEN *30 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-16 17:05:20',  2591, 56054, 2, 19, 8591247)
			   ,('FVE','DP1','022772','2025-04-16 17:05:20','042025','CO','1101360008','OSCAR JAVIER ','GOMEZ AMADO','',' 3234252451','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','20252.100840336134','3847.8991596638634','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 17:05:20','24099.999999999996','50','DEPOSITO CUCUTA ','1','4900.00000000','4900.00000000','4117.6470588235','782.35294117647','4900','1','0','1','','16/04/2025','','0','24100','0','7502214739620','SCHICK QUATTRO FOR WOMEN SENSIBLE * 1 UND','417','EDGEWELL','2025-04-16 17:05:20',  0, 56895, 2, 19, 8591247)
			   ,('FVE','DP1','022774','2025-04-16 18:11:27','042025','CR','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','64700','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-16 18:24:25','64700','50','DEPOSITO CUCUTA ','1','64700.00000000','64700.00000000','64700','0','64700','1','0','0','','16/04/2025','','0','0','64700','7501058631152','BABY KLIM 1+ LATA *800 GR','311','NESTLE NUTRICION','2025-04-16 18:11:27',  59868, 51947, 2, 19, 8591776)
			   ,('FVE','DP1','022775','2025-04-16 19:06:56','042025','CO','13254155','RENE ','DIAZ','CALLE 17 # 2 - 83, GARCIA HERR','0 3223014163','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','31533.613445378152','5991.386554621848','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-16 19:06:56','37525','50','DEPOSITO CUCUTA ','1','37525.00000000','37525.00000000','31533.613445378','5991.3865546218','37525','1','0','1','','17/04/2025','','37525','0','0','7702113043259','TANGA BLOQ SPF 50 CREMA *130ML','278','RECAMIER','2025-04-16 19:06:56',  24482.7224, 61925, 2, 19, 8592023)
			   ,('FVE','DB1','002249','2025-04-19 09:43:56','042025','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','','','','','','3','15000','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-19 09:52:59','15000','DB','DEPOSITO BARRANQUILLA','2','7500.00000000','15000.00000000','15000','0','15000','2','0','1','','19/04/2025','','0','15000','0','7707236127688','GENTAMICINA 160MG/2ML * 1 AMP','701','VITALIS COMERCIAL','2025-04-19 09:43:56',  4462, 54109, 119, 53, 8596017)
			   ,('FVE','DB1','002250','2025-04-19 09:44:07','042025','CR','1001871706','JOSE LUIS','CORDEDO VILLAFANE','CALLE 56D NO.36-31 VILLA DEL C',' 3022362183','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','3109.2436974789916','590.7563025210084','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-19 09:52:59','3700','DB','DEPOSITO BARRANQUILLA','1','3700.00000000','3700.00000000','3109.243697479','590.75630252101','3700','1','0','0','','19/04/2025','','0','0','3700','7702026031329','PEQUEÑIN PAÑOS HUMEDOS ALMENDRA * 24 UND','337','FAMILIA SANCELA','2025-04-19 09:44:07',  2478, 44961, 119, 53, 8596022)
			   ,('FVE','DB1','002251','2025-04-19 09:55:03','042025','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','','','','','','2','32100.840336134454','6099.1596638655465','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-19 10:27:36','38200','DB','DEPOSITO BARRANQUILLA','1','38200.00000000','38200.00000000','32100.840336134','6099.1596638655','38200','1','0','1','','19/04/2025','','0','38200','0','7702277233015','ARRURRU SHAMPOO ROMERO * 750 ML','124','BELLEZA EXPRESS SA','2025-04-19 09:55:03',  22432, 61836, 119, 53, 8596041)
			   ,('FVE','DP1','022776','2025-04-21 08:59:08','042025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','4453.781512605042','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 09:06:29','5300','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','21/04/2025','','5300','0','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-21 08:59:08',  3375, 24465, 2, 19, 8600396)
			   ,('FVE','DB2','004124','2025-04-21 09:00:02','042025','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','46016.80672268908','6083.193277310922','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-21 09:00:02','52100','DBU','DEPOSITO BUCARAMANGA','1','14000.00000000','14000.00000000','14000','0','14000','1','0','1','','21/04/2025','','0','52100','0','7707355053486','NOXPIRIN SINUS * 12 TAB PAGUE 10 LLEVE 12','626','SIEGFRIED CONSUMO','2025-04-21 09:00:02',  8423, 33749, 426, 249, 8559006)
			   ,('FVE','DB2','004124','2025-04-21 09:00:02','042025','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','46016.80672268908','6083.193277310922','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-21 09:00:02','52100','DBU','DEPOSITO BUCARAMANGA','1','38100.00000000','38100.00000000','32016.806722689','6083.1932773109','38100','1','0','1','','21/04/2025','','0','52100','0','7702123012108','REDOXON TOTAL * 20 COMP','631','BAYER OTC','2025-04-21 09:00:02',  26560, 56390, 426, 249, 8559006)
			   ,('FVE','DB2','004126','2025-04-21 09:44:23','042025','CR','860008448-2','MEALS DE COLOMBIA','S.A.S.','CL 98  70 90 BOGOTA','6439120 3118749795','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 21, 2025, 11:24 am','','2','3218720.168067227','611556.8319327729','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-21 11:24:03','3830277','DBU','DEPOSITO BUCARAMANGA','1','3830276.80000000','3830276.80000000','3218720.1680672','611556.83193277','3830277','1','0','0','','21/04/2025','','0','0','3830277','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-21 09:44:23',  0, 50141, 426, 249, 8600759)
			   ,('FVE','DP1','022777','2025-04-21 10:55:56','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','8067.226890756303','1532.7731092436973','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 10:56:00','9600','50','DEPOSITO CUCUTA ','1','2100.00000000','2100.00000000','1764.7058823529','335.29411764706','2100','1','0','0','','21/04/2025','','9600','0','0','7707194535815','MASGLO LIMA LAVABLE','801','CERESCOS','2025-04-21 10:55:56',  1089.6, 55572, 2, 19, 8601252)
			   ,('FVE','DP1','022777','2025-04-21 10:55:56','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','8067.226890756303','1532.7731092436973','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 10:56:00','9600','50','DEPOSITO CUCUTA ','1','7500.00000000','7500.00000000','6302.5210084034','1197.4789915966','7500','1','0','0','','21/04/2025','','9600','0','0','7702277082545','CORTAUÑAS GRANDE CURVO FSTYLE','124','BELLEZA EXPRESS SA','2025-04-21 10:55:56',  4089, 46816, 2, 19, 8601252)
			   ,('FVE','DP1','022778','2025-04-21 13:08:15','042025','CR','79415594','LUIS CARLOS','CEBALLOS DUARTE','AV LIBERTADORES EDIFICIO FLORI','000000 3217061656','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','4600','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 14:13:16','4600','50','DEPOSITO CUCUTA ','1','4600.00000000','4600.00000000','4600','0','4600','0','1','0','','21/04/2025','','0','0','4600','7702896001231','DEXABLAS 8 MG * 5 AMP','132','BLASKOV','2025-04-21 13:08:15',  7548, 23704, 2, 19, 8602106)
			   ,('FVE','DP1','022779','2025-04-21 14:25:38','042025','CR','1090534653','JHONIER','SANCHEZ BURGOS','CALLE 32 NO.36-26',' 3227358678','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','9663.865546218487','1836.134453781513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 14:59:00','11500','50','DEPOSITO CUCUTA ','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','21/04/2025','','0','0','11500','7702354939960','EGO CERA PARA PEINAR *160 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-21 14:25:38',  7093, 49396, 2, 19, 8602562)
			   ,('FVE','DP1','022780','2025-04-21 15:27:17','042025','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','9159.66386554622','1740.3361344537807','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 15:31:17','10900','50','DEPOSITO CUCUTA ','1','10900.00000000','10900.00000000','9159.6638655462','1740.3361344538','10900','1','0','0','','21/04/2025','','0','0','10900','7702277395256','TOALLITAS ARRURRU AVENA Y KARITE * 100 UND ','124','BELLEZA EXPRESS SA','2025-04-21 15:27:17',  5788.5, 55332, 2, 19, 8603046)
			   ,('FVE','DB2','004128','2025-04-21 16:37:46','042025','CO','1093785231','YELITZA KATHERINE','SILVA CONTRERAS','CALLE 3 NO.1-37 SAN MATEO','5845734 3115081821','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','5714.285714285715','1085.7142857142853','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-21 16:37:46','6800','DBU','DEPOSITO BUCARAMANGA','1','6800.00000000','6800.00000000','5714.2857142857','1085.7142857143','6800','1','0','1','','21/04/2025','','0','6800','0','7707822757541','PILAS ALKALINA AAA * 2 UND','950','TRONEX','2025-04-21 16:37:46',  2812, 62095, 426, 249, 8603129)
			   ,('FVE','DP1','022781','2025-04-21 16:37:46','042025','CR','1090493292','WEIMAR','TRUJILLO','CALLE 26 NO.1-05 SAN RAFAEL',' 3123045021','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','50924.36974789917','9675.630252100837','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 16:46:57','60600','50','DEPOSITO CUCUTA ','1','13400.00000000','13400.00000000','11260.504201681','2139.4957983193','13400','1','0','0','','21/04/2025','','0','0','60600','7701021145949','WINNY TOALLITAS ALOE VERA * 100 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2025-04-21 16:37:46',  8751, 33273, 2, 19, 8603558)
			   ,('FVE','DP1','022781','2025-04-21 16:37:46','042025','CR','1090493292','WEIMAR','TRUJILLO','CALLE 26 NO.1-05 SAN RAFAEL',' 3123045021','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','50924.36974789917','9675.630252100837','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 16:46:57','60600','50','DEPOSITO CUCUTA ','1','47200.00000000','47200.00000000','39663.865546218','7536.1344537815','47200','1','0','0','','21/04/2025','','0','0','60600','7701021114174','WINNY ULTRATRIM SEC ET 5 * 30 UND  ','653','TECNOQUIMICAS WINNY','2025-04-21 16:37:46',  35304, 43226, 2, 19, 8603558)
			   ,('FVE','DP1','022782','2025-04-21 16:47:01','042025','CR','1090531686','ELIAB DANIEL','ROMERO PARRA','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','5700','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 16:51:22','5700','50','DEPOSITO CUCUTA ','1','5700.00000000','5700.00000000','5700','0','5700','1','0','0','','21/04/2025','','0','0','5700','7702057075088','ALCOHOL MK * 350 ML ','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-04-21 16:47:01',  4290, 42766, 2, 19, 8603618)
			   ,('FVE','DB2','004129','2025-04-21 16:50:13','042025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','14500','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-21 16:57:14','14500','DBU','DEPOSITO BUCARAMANGA','1','14500.00000000','14500.00000000','14500','0','14500','1','0','0','','21/04/2025','','0','0','14500','7706569000958','DICLOFENACO R 100 MG * 20 CAP','614','A.G. MEDICAMENTOS','2025-04-21 16:50:13',  6616.4, 31349, 426, 249, 8603654)
			   ,('FVE','DP1','022783','2025-04-21 16:52:15','042025','CO','1090521222','JOAN SEBASTIAN','RAMIREZ DIAZ','CARRERA 10 NO.4-60 VILLA DEL R',' 3007368791','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','3781.512605042017','718.4873949579828','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-21 16:52:15','4500','50','DEPOSITO CUCUTA ','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','21/04/2025','','0','4500','0','7702010111587','COLGATE CREMA DENTAL TRIPLE EXTRA BLANCURA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-21 16:52:15',  2914, 48567, 2, 19, 8602112)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-22 08:04:27',  1613.7, 52184, 2, 19, 8575018)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','1','378400.00000000','378400.00000000','326059.04761905','16302.952380952','342362','1','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','770709629140637','WHISKY BUCHANANS SPECIAL RESERVE 18 AÑOS * 750 ML ','827','MEICO LICORES','2025-04-22 08:04:27',  324322, 57217, 2, 19, 8575018)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','1','197200.00000000','197200.00000000','169922.85714286','8496.1428571429','178419','1','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','5000196003774','WHISKY BUCHANANS MASTER *750 ML','827','MEICO LICORES','2025-04-22 08:04:27',  163730, 38142, 2, 19, 8575018)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','1','215400.00000000','215400.00000000','185605.71428571','9280.2857142857','194886','1','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','50196364','WHISKY BUCHANANS DELUXE 12 AÑOS * 1000 ML','827','MEICO LICORES','2025-04-22 08:04:27',  183735, 32832, 2, 19, 8575018)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','2','25800.00000000','51600.00000000','43361.344537815','8238.6554621849','51600','2','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','7891150089983','REXONA CLINICAL INTENSE FRESH AEROSOL *150 ML ','388','UNILEVER ANDINA COLOMBIA','2025-04-22 08:04:27',  16999, 63963, 2, 19, 8575018)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','2','23500.00000000','47000.00000000','39495.798319328','7504.2016806723','47000','2','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','7506306213920','AXE ICE CHILL SECO SPRAY * 152 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-22 08:04:27',  14404, 54514, 2, 19, 8575018)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','2','8000.00000000','16000.00000000','13445.378151261','2554.6218487395','16000','2','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-22 08:04:27',  5547, 24467, 2, 19, 8575018)
			   ,('FVE','DP1','022784','2025-04-22 08:04:27','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','12','809234.6778711486','58332.32212885152','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:04:27','867567.0000000001','50','DEPOSITO CUCUTA ','1','34700.00000000','34700.00000000','29159.663865546','5540.3361344538','34700','1','0','1','','22/04/2025','','1.1641532182693E-10','867567','0','7702035432445','LISTERINE CONTROL CALCULO * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-22 08:04:27',  23211, 28024, 2, 19, 8575018)
			   ,('FVE','DP1','022785','2025-04-22 08:21:22','042025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','22436.97478991597','4263.025210084031','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:21:22','26700','50','DEPOSITO CUCUTA ','2','3500.00000000','7000.00000000','5882.3529411765','1117.6470588235','7000','2','0','1','','22/04/2025','','0','26700','0','6910021007206','COLGATE CEPILLO PREMIER CLEAN MEDIO','145','COLGATE PALMOLIVE COMPANIA','2025-04-22 08:21:22',  2006, 47117, 2, 19, 8603258)
			   ,('FVE','DP1','022785','2025-04-22 08:21:22','042025','CO','1095909617','YULY ANDREA','DIAZ RODRIGUEZ','CALLE 16#51-55 ANTONIA SANTOS','3043951374 3147687134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','22436.97478991597','4263.025210084031','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 08:21:22','26700','50','DEPOSITO CUCUTA ','1','19700.00000000','19700.00000000','16554.621848739','3145.3781512605','19700','1','0','1','','22/04/2025','','0','26700','0','7509546651019','COLGATE LUMINOUS WHITE CARBON ACTIVADO * 75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-22 08:21:22',  13038, 56068, 2, 19, 8603258)
			   ,('FVE','DP1','022786','2025-04-22 09:47:16','042025','CR','1005064699','SAMUEL JOSUE','SOLANO ROJAS','AVENIDA 0 NO.3-330 BOCONO',' 3224552356','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','10400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 09:53:50','10400','50','DEPOSITO CUCUTA ','1','10400.00000000','10400.00000000','10400','0','10400','1','0','0','','22/04/2025','','0','0','10400','7702057073985','LOPERAMIDA 2 MG * 6 TAB','654','MK ETICOS CONVENIO','2025-04-22 09:47:16',  7277, 43107, 2, 19, 8606140)
			   ,('FVE','DP1','022787','2025-04-22 10:27:28','042025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','11','14000','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 10:31:42','14000','50','DEPOSITO CUCUTA ','10','1400.00000000','14000.00000000','14000','0','14000','0','10','1','','22/04/2025','','0','14000','0','8850769020786','GOFEN FORTE 400 MG * 60 CAP','802','MEGA WE CARE','2025-04-22 10:27:28',  38258, 55995, 2, 19, 8606412)
			   ,('FVE','DP1','022788','2025-04-22 10:28:56','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','7563.025210084034','1436.9747899159656','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 10:28:56','9000','50','DEPOSITO CUCUTA ','1','9000.00000000','9000.00000000','7563.025210084','1436.974789916','9000','1','0','0','','22/04/2025','','9000','0','0','7707194534153','MASGLO ESMALTE BRILLO SECANTE *13.5 ML','801','CERESCOS','2025-04-22 10:28:56',  6042.24, 55564, 2, 19, 8605509)
			   ,('FVE','DP1','022789','2025-04-22 11:48:15','042025','CR','1004923811','BRAYAN ANDRES','PLATA HERNANDEZ','CALLE 10 AVENIDA 1 NO.9-49 COM',' 3134439122','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','21176.470588235294','4023.5294117647063','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 11:53:51','25200','50','DEPOSITO CUCUTA ','1','25200.00000000','25200.00000000','21176.470588235','4023.5294117647','25200','1','0','0','','22/04/2025','','0','0','25200','7702035432339','LISTERINE COOL MINT * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-22 11:48:15',  15988.9731, 28034, 2, 19, 8607105)
				  ,('FVE','DP1','022790','2025-04-22 14:09:51','042025','CR','1005064699','SAMUEL JOSUE','SOLANO ROJAS','AVENIDA 0 NO.3-330 BOCONO',' 3224552356','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','9159.66386554622','1740.3361344537807','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 14:21:58','10900','50','DEPOSITO CUCUTA ','1','10900.00000000','10900.00000000','9159.6638655462','1740.3361344538','10900','1','0','0','','22/04/2025','','0','0','10900','7702277395256','TOALLITAS ARRURRU AVENA Y KARITE * 100 UND ','124','BELLEZA EXPRESS SA','2025-04-22 14:09:51',  5788.5, 55332, 2, 19, 8607727);
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','004131','2025-04-22 16:54:10','042025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','3109.2436974789916','590.7563025210084','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-22 16:56:16','3700','DBU','DEPOSITO BUCARAMANGA','1','3700.00000000','3700.00000000','3109.243697479','590.75630252101','3700','1','0','0','','22/04/2025','','0','0','3700','7702006299923','EGO GEL EXTREME MAX FCO *110 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-22 16:54:10',  2384, 32598, 426, 249, 8608996)
			   ,('FVE','DP1','022791','2025-04-22 17:09:39','042025','CR','1093751562','DIEGO ALEXANDER','NI ntilde O CASTILLO','CL 15A # 8-70 TIERRA LINDA LOS','5553105 3132555071','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','37240','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-22 17:40:19','37240','50','DEPOSITO CUCUTA ','1','37240.00000000','37240.00000000','37240','0','37240','1','0','0','','22/04/2025','','0','0','37240','7702870940549','BELLANEW 1.5MG/2MG * 28 TAB','619','ABBOTT FARMA','2025-04-22 17:09:39',  32727.5, 54895, 2, 19, 8609130)
			   ,('FVE','DB2','004141','2025-04-22 17:15:31','042025','CR','1102550074','CRISTIAN ANDR eacute S','MART iacute NEZ','CRA 21B NO.1A-33 PIEDECUESTA',' 3023652984','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','15500','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-24 07:03:08','15500','DBU','DEPOSITO BUCARAMANGA','1','15500.00000000','15500.00000000','15500','0','15500','1','0','0','','24/04/2025','','0','0','15500','7501159033565','DUREX MAXIMO PLACER * 3 UND','357','RECKITT BENCKISER COLOMBIA S A','2025-04-22 17:15:31',  13039, 58919, 426, 249, 8609180)
			   ,('FVE','DB1','002252','2025-04-22 17:29:50','042025','CR','1007891376','C eacute SAR LUIS','VASQUEZ MENDOZA','CRA 16 NO.22-30 GALAPA',' 3238451741','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','9200','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-22 17:33:36','9200','DB','DEPOSITO BARRANQUILLA','1','9200.00000000','9200.00000000','9200','0','9200','1','0','0','','22/04/2025','','0','0','9200','7702057075101','ALCOHOL MK * 700 ML','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-04-22 17:29:50',  6925, 42767, 119, 53, 8609295)
			   ,('FVE','DB1','002253','2025-04-22 17:34:16','042025','CR','1129504297','CAMILO ANDR Eacute S','GIM Eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','11764.705882352942','2235.2941176470576','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-22 17:39:40','14000','DB','DEPOSITO BARRANQUILLA','1','14000.00000000','14000.00000000','11764.705882353','2235.2941176471','14000','1','0','0','','22/04/2025','','0','0','14000','7702184680032','DERMICLEAR GEL CAMOMILLA * 120 ML','249','ECAR','2025-04-22 17:34:16',  4317, 48861, 119, 53, 8609341)
			   ,('FVE','DB1','002254','2025-04-22 17:40:13','042025','CR','1007963867','CARLOS ANDRES','MEDINA MENDOZA','CALLE 14 NO.17B-144 LA LUZ',' 3243273899','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-22 17:42:37','4000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','22/04/2025','','0','0','4000','7702277865964','TOALLITAS ARRURRU AVENA Y KARITE * 20 UND','124','BELLEZA EXPRESS SA','2025-04-22 17:40:13',  2006, 54335, 119, 53, 8609398)
			   ,('FVE','DB1','002255','2025-04-22 17:44:39','042025','CR','1001831818','ERICK GABRIEL','VELEZ DIAZ','CALLE 14 NO.50-74 1RO DE MAYO',' 3156518373','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','21428.571428571428','4071.4285714285706','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-22 17:53:52','25500','DB','DEPOSITO BARRANQUILLA','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','22/04/2025','','0','0','25500','7707194530742','MASGLO ESMALTE ILUSION * 13.5 ML','801','CERESCOS','2025-04-22 17:44:39',  0, 55579, 119, 53, 8609434)
			   ,('FVE','DB1','002255','2025-04-22 17:44:39','042025','CR','1001831818','ERICK GABRIEL','VELEZ DIAZ','CALLE 14 NO.50-74 1RO DE MAYO',' 3156518373','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','21428.571428571428','4071.4285714285706','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-22 17:53:52','25500','DB','DEPOSITO BARRANQUILLA','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','22/04/2025','','0','0','25500','7707194530018','MASGLO ESMALTE TIZA *13.5 ML','801','CERESCOS','2025-04-22 17:44:39',  5868, 55546, 119, 53, 8609434)
			   ,('FVE','DB1','002255','2025-04-22 17:44:39','042025','CR','1001831818','ERICK GABRIEL','VELEZ DIAZ','CALLE 14 NO.50-74 1RO DE MAYO',' 3156518373','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','21428.571428571428','4071.4285714285706','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-22 17:53:52','25500','DB','DEPOSITO BARRANQUILLA','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','22/04/2025','','0','0','25500','7707194530971','MASGLO ESMALTE BRILLO *13.5 ML','801','CERESCOS','2025-04-22 17:44:39',  5657.28, 55558, 119, 53, 8609434)
			   ,('FVE','DB2','004132','2025-04-22 18:19:41','042025','CR','1092389349','ALEJANDRO','MIRANDA','CALLE 29 MANZANA J CASA 4 BARR',' 3115979075','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','14033.613445378152','2666.3865546218485','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-22 18:32:00','16700','DBU','DEPOSITO BUCARAMANGA','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','0','','22/04/2025','','0','0','16700','7702045200324','BALANCE CLINICAL CREMA MINI  WOMEN * 30 GR','203','HENKEL COLOMBIANA','2025-04-22 18:19:41',  2888, 52774, 426, 249, 8609676)
			   ,('FVE','DB2','004132','2025-04-22 18:19:41','042025','CR','1092389349','ALEJANDRO','MIRANDA','CALLE 29 MANZANA J CASA 4 BARR',' 3115979075','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','14033.613445378152','2666.3865546218485','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-22 18:32:00','16700','DBU','DEPOSITO BUCARAMANGA','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','22/04/2025','','0','0','16700','7702354939960','EGO CERA PARA PEINAR *160 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-22 18:19:41',  7093, 49396, 426, 249, 8609676)
			   ,('FVE','DB2','004139','2025-04-23 07:09:59','042025','CR','1044608837','BRYAN ARMANDO','DURAN CELIS','CALLE 60E NO.16F-18',' 3014878897','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','36500','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-23 18:13:23','36500','DBU','DEPOSITO BUCARAMANGA','1','36500.00000000','36500.00000000','36500','0','36500','1','0','0','','23/04/2025','','0','0','36500','4048846008770','BISOLVON TOS SECA JBE * 120 ML','772','OPELLA (SANOFI OTC)','2025-04-23 07:09:59',  30141, 25099, 426, 249, 8610454)
			   ,('FVE','DP1','022792','2025-04-23 08:16:21','042025','CR','1036392280-9','ELVIA ROSA','HERNANDEZ VALENCIA ','CARRERA 66 51 99',' 3042928000','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' G.SUAREZ Autoriza la Venta por Cupo. April 23, 2025, 8:20 am','','2','442016.80672268907','83983.19327731093','00','DEPOSITO CUCUTA','G.SUAREZ','2025-04-23 08:20:33','526000','50','DEPOSITO CUCUTA ','1','526000.00000000','526000.00000000','442016.80672269','83983.193277311','526000','1','0','0','','23/04/2025','','0','0','526000','D1994','ARRIENDO 22 MAYO 22 JUNIO 2025','00','VARIOS','2025-04-23 08:16:21',  0, 65385, 2, 19, 8610865)
			   ,('FVE','DP1','022793','2025-04-23 08:25:22','042025','CR','1127361595','JORGE','NIETO','CRA 14 NO.25-12 GRAN COLOMBIA',' 3155354339','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','3','3529.4117647058824','670.5882352941176','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-23 08:42:51','4200','50','DEPOSITO CUCUTA ','2','2100.00000000','4200.00000000','3529.4117647059','670.58823529412','4200','2','0','0','','23/04/2025','','0','0','4200','7702024034186','COCOSETTE MAXI WAFER * 46 GR','776','NESTLE FOOD & BEVERAGE','2025-04-23 08:25:22',  1091, 38319, 2, 19, 8610914)
			   ,('FVE','DP1','022794','2025-04-23 09:15:31','042025','CO','88256247','ELKIN ANTONIO','RODRIGUEZ MALAGON','CALLE 27 NO. 11-35 BELLA VISTA','5781240 3144803965','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','20100','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-23 09:16:15','20100','50','DEPOSITO CUCUTA ','4','1300.00000000','5200.00000000','5200','0','5200','0','4','0','','23/04/2025','','20100','0','0','7702123006718','ASPIRINA EFERVESCENTE 500 MG * 50 TAB','631','BAYER OTC','2025-04-23 09:15:31',  55810, 22880, 2, 19, 8611217)
			   ,('FVE','DP1','022794','2025-04-23 09:15:31','042025','CO','88256247','ELKIN ANTONIO','RODRIGUEZ MALAGON','CALLE 27 NO. 11-35 BELLA VISTA','5781240 3144803965','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','6','20100','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-23 09:16:15','20100','50','DEPOSITO CUCUTA ','1','14900.00000000','14900.00000000','14900','0','14900','1','0','0','','23/04/2025','','20100','0','0','7703197053059','WASSERTROL SUSP OFTALMICA * 5 ML  ','622','MK OFTALMOLOGICO CONVENIO','2025-04-23 09:15:31',  10654, 43398, 2, 19, 8611217)
			   ,('FVE','DB1','002256','2025-04-23 09:54:39','042025','CR','1046693396','JORMAN DAVID','BUELVAS PADILLA','CALLE 113A NO.83-24',' 3209362520','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-23 09:57:00','4000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','23/04/2025','','0','0','4000','7702277865964','TOALLITAS ARRURRU AVENA Y KARITE * 20 UND','124','BELLEZA EXPRESS SA','2025-04-23 09:54:39',  2006, 54335, 119, 53, 8611489)
			   ,('FVE','DP1','022795','2025-04-23 10:20:46','042025','CR','1090518110','SOF iacute A','RAMIREZ','CALLE 4A NO. 14-45 LOMAS DE BO',' 3118253134','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','17200','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-23 10:25:36','17200','50','DEPOSITO CUCUTA ','1','17200.00000000','17200.00000000','17200','0','17200','1','0','0','','23/04/2025','','0','0','17200','7702057717346','LEVOTIROXINA 25 MG CJA * 30 TAB','654','MK ETICOS CONVENIO','2025-04-23 10:20:46',  14520, 62427, 2, 19, 8611683)
			   ,('FVE','DP1','022796','2025-04-23 11:35:16','042025','CR','1090496828','MARIA FERNANDA','ACOSTA CABARCAS','URBANIZACION LA FORTUNA PATIOS','3046614144 3046614144','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','3','8210.084033613446','1559.915966386554','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-23 11:40:46','9770','50','DEPOSITO CUCUTA ','1','6970.00000000','6970.00000000','5857.1428571429','1112.8571428571','6970','1','0','0','','23/04/2025','','0','0','9770','7702026188320','PEQUEÑIN TOALLITAS ANTIBACTERIAL *40 UND','337','FAMILIA SANCELA','2025-04-23 11:35:16',  5106.6, 56770, 2, 19, 8612174)
			   ,('FVE','DP1','022796','2025-04-23 11:35:16','042025','CR','1090496828','MARIA FERNANDA','ACOSTA CABARCAS','URBANIZACION LA FORTUNA PATIOS','3046614144 3046614144','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','3','8210.084033613446','1559.915966386554','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-23 11:40:46','9770','50','DEPOSITO CUCUTA ','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','0','','23/04/2025','','0','0','9770','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2025-04-23 11:35:16',  1823.4, 54241, 2, 19, 8612174)
			   ,('FVE','DB2','004133','2025-04-23 15:43:46','042025','CR','901066280-8','DISTRIBUCIONES','PROVICOL SAS','BG 4 MD 2 BRR CENTRO MAYORISTA',' 3006108297','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 23, 2025, 3:47 pm','','2','110000','20900','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-23 15:59:26','130900','DBU','DEPOSITO BUCARAMANGA','1','130900.00000000','130900.00000000','110000','20900','130900','1','0','0','','23/04/2025','','0','0','130900','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-23 15:43:46',  0, 50141, 426, 249, 8613663)
			   ,('FVE','DB1','002257','2025-04-23 17:04:25','042025','CR','1043439628','MOISES DAVID ','DE LAS AGUAS MELENDRES','CALLE 100 1 SUR II VILLA SAN C',' 3045603820','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','29159.66386554622','5540.336134453781','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-23 17:12:14','34700','DB','DEPOSITO BARRANQUILLA','1','34700.00000000','34700.00000000','29159.663865546','5540.3361344538','34700','1','0','0','','23/04/2025','','0','0','34700','7702035431110','LISTERINE ORIGINAL * 500 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-23 17:04:25',  23184, 28047, 119, 53, 8614289)
			   ,('FVE','DB1','002258','2025-04-23 17:19:06','042025','CR','1001831818','ERICK GABRIEL','VELEZ DIAZ','CALLE 14 NO.50-74 1RO DE MAYO',' 3156518373','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','15500','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-23 17:24:38','15500','DB','DEPOSITO BARRANQUILLA','1','15500.00000000','15500.00000000','15500','0','15500','1','0','0','','23/04/2025','','0','0','15500','7707288820070','ESPIRONOLACTONA 100 MG * 20 TAB','205','HUMAX PHARMACEUTICAL','2025-04-23 17:19:06',  11566, 27348, 119, 53, 8614416)
			   ,('FVE','DB2','004135','2025-04-23 17:31:07','042025','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','21008.40336134454','3991.596638655461','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-23 17:35:45','25000','DBU','DEPOSITO BUCARAMANGA','1','25000.00000000','25000.00000000','21008.403361345','3991.5966386555','25000','1','0','1','','23/04/2025','','0','25000','0','42332862','NIVEA MEN INVISIBLE BLACK & WHITE BARRA *50 GR','123','BDF (BEIERSDORF) ','2025-04-23 17:31:07',  14131, 52628, 426, 249, 8614452)
			   ,('FVE','DB2','004136','2025-04-23 17:31:17','042025','CR','1095957979','DARLY YULYTZA','ROA RUEDA','CALLE 6H NO.32-39',' 3108637007','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','6428.571428571428','1221.4285714285716','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-23 17:40:12','7650','DBU','DEPOSITO BUCARAMANGA','1','7650.00000000','7650.00000000','6428.5714285714','1221.4285714286','7650','1','0','0','','23/04/2025','','0','0','7650','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-04-23 17:31:17',  4412, 55331, 426, 249, 8614476)
			   ,('FVE','DB2','004138','2025-04-23 17:46:06','042025','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','117142.85714285714','22257.142857142855','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-23 17:46:06','139400','DBU','DEPOSITO BUCARAMANGA','2','69700.00000000','139400.00000000','117142.85714286','22257.142857143','139400','2','0','1','','23/04/2025','','0','139400','0','751273786855','COLLAGEN & BIOTIN COMPLEX * 60 SOFTGEL','641','HEALTHY DE AMERICA COLOMBIA','2025-04-23 17:46:06',  35126, 53383, 426, 249, 8614343)
			   ,('FVE','DB2','004140','2025-04-23 18:29:25','042025','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','10100','0','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-23 18:29:25','10100','DBU','DEPOSITO BUCARAMANGA','1','10100.00000000','10100.00000000','10100','0','10100','1','0','1','','23/04/2025','','0','10100','0','7501033957413','PEDIALYTE ACTIVE 45 FRESA * 500 ML','659','ABBOTT NUTRICION','2025-04-23 18:29:25',  0, 22275, 426, 249, 8613467)
			   ,('FVE','DB1','002259','2025-04-24 07:41:51','042025','CO','1042453665','ARLIS','DE LA HOZ YANETH','CRA 7B NO.5-79 FERRY',' 3224065848','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','20588.235294117647','3911.764705882353','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 07:41:51','24500','DB','DEPOSITO BARRANQUILLA','1','24500.00000000','24500.00000000','20588.235294118','3911.7647058824','24500','1','0','1','','24/04/2025','','0','24500','0','7701021115706','WINNY ULTRATRIM SEC ET1 * 30 + 20 TOALLITAS','653','TECNOQUIMICAS WINNY','2025-04-24 07:41:51',  18317, 34273, 119, 53, 8616480)
			   ,('FVE','DB1','002260','2025-04-24 07:55:28','042025','CR','1002213647','CARLOS JOS eacute ','LAMADRID BUELVAS','CALLE 13 NO.91-31',' 3001509823','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','5126.050420168068','973.9495798319323','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 10:24:00','6100','DB','DEPOSITO BARRANQUILLA','1','3000.00000000','3000.00000000','2521.0084033613','478.99159663866','3000','1','0','0','','24/04/2025','','0','0','6100','75900557','SCHICK EXACTA DELICADA * 1 UND ','417','EDGEWELL','2025-04-24 07:55:28',  1365.8, 25499, 119, 53, 8616753)
			   ,('FVE','DB1','002260','2025-04-24 07:55:28','042025','CR','1002213647','CARLOS JOS eacute ','LAMADRID BUELVAS','CALLE 13 NO.91-31',' 3001509823','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','5126.050420168068','973.9495798319323','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 10:24:00','6100','DB','DEPOSITO BARRANQUILLA','1','1100.00000000','1100.00000000','924.36974789916','175.63025210084','1100','1','0','0','','24/04/2025','','0','0','6100','7702006400114','SEDAL CREMA PARA PEINAR RIZOS DEFINIDOS *18 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-24 07:55:28',  666, 60069, 119, 53, 8616753)
			   ,('FVE','DB1','002260','2025-04-24 07:55:28','042025','CR','1002213647','CARLOS JOS eacute ','LAMADRID BUELVAS','CALLE 13 NO.91-31',' 3001509823','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','5126.050420168068','973.9495798319323','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 10:24:00','6100','DB','DEPOSITO BARRANQUILLA','1','2000.00000000','2000.00000000','1680.6722689076','319.32773109244','2000','1','0','0','','24/04/2025','','0','0','6100','7702026032944','PAÑUELOS FAMILIA GRIPAL * 1 UND','337','FAMILIA SANCELA','2025-04-24 07:55:28',  1099.3, 40350, 119, 53, 8616753)
			   ,('FVE','DP1','022797','2025-04-24 08:45:01','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','43500','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-24 08:45:01','43500','50','DEPOSITO CUCUTA ','1','43500.00000000','43500.00000000','43500','0','43500','1','0','1','','24/04/2025','','0','43500','0','7702057065478','NITAZOXANIDA 500 MG * 6 TAB','654','MK ETICOS CONVENIO','2025-04-24 08:45:01',  30400, 43160, 2, 19, 8617221)
			   ,('FVE','DP1','022798','2025-04-24 09:06:59','042025','CR','1004997705','JULIANA VALENTINA','GOMEZ PABON','MANZANA 2 F5 LOTE 4 TUCUNARE P',' 3224693600','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','4440.336134453782','159.6638655462184','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-24 10:00:06','4600','50','DEPOSITO CUCUTA ','2','500.00000000','1000.00000000','840.33613445378','159.66386554622','1000','2','0','0','','24/04/2025','','0','0','4600','7707228361786','JERINGA 5 ML 21G * 1 1/2 HIPODERMICA','429','ALFA SAFE','2025-04-24 09:06:59',  167, 46100, 2, 19, 8617913)
			   ,('FVE','DP1','022798','2025-04-24 09:06:59','042025','CR','1004997705','JULIANA VALENTINA','GOMEZ PABON','MANZANA 2 F5 LOTE 4 TUCUNARE P',' 3224693600','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','4440.336134453782','159.6638655462184','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-24 10:00:06','4600','50','DEPOSITO CUCUTA ','1','3600.00000000','3600.00000000','3600','0','3600','0','1','0','','24/04/2025','','0','0','4600','7703153040949','DICLOFENACO 75 MG / 3 ML * 10 AMP','422','COLMED','2025-04-24 09:06:59',  9311, 61834, 2, 19, 8617913)
			   ,('FVE','DP1','022799','2025-04-24 10:01:27','042025','CR','1090450152','ELIETH','SANCHEZ MEDINA','AV 2 MZ 8 LT 16 # 0-38 LOS ALM',' 3125910187','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','63949.57983193277','12150.420168067223','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-24 11:33:48','76100','50','DEPOSITO CUCUTA ','2','25700.00000000','51400.00000000','43193.277310924','8206.7226890756','51400','2','0','0','','24/04/2025','','0','0','76100','079400301161','REXONA CLINICAL WOMEN EXTRA DRY MORADO * 48 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-24 10:01:27',  15944, 46681, 2, 19, 8618876)
			   ,('FVE','DP1','022799','2025-04-24 10:01:27','042025','CR','1090450152','ELIETH','SANCHEZ MEDINA','AV 2 MZ 8 LT 16 # 0-38 LOS ALM',' 3125910187','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','63949.57983193277','12150.420168067223','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-24 11:33:48','76100','50','DEPOSITO CUCUTA ','1','18300.00000000','18300.00000000','15378.151260504','2921.8487394958','18300','1','0','0','','24/04/2025','','0','0','76100','7509546054650','COLGATE CREMA DENTAL LUMINOUS WHITE *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-24 10:01:27',  8583, 24441, 2, 19, 8618876)
			   ,('FVE','DP1','022799','2025-04-24 10:01:27','042025','CR','1090450152','ELIETH','SANCHEZ MEDINA','AV 2 MZ 8 LT 16 # 0-38 LOS ALM',' 3125910187','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','63949.57983193277','12150.420168067223','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-24 11:33:48','76100','50','DEPOSITO CUCUTA ','1','6400.00000000','6400.00000000','5378.1512605042','1021.8487394958','6400','1','0','0','','24/04/2025','','0','0','76100','7702010130625','COLGATE CEPILLO EXTRA CLEAN DURA','145','COLGATE PALMOLIVE COMPANIA','2025-04-24 10:01:27',  3925, 48362, 2, 19, 8618876)
			   ,('FVE','DB1','002261','2025-04-24 11:28:42','042025','CR','1001831818','ERICK GABRIEL','VELEZ DIAZ','CALLE 14 NO.50-74 1RO DE MAYO',' 3156518373','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','139495.79831932773','26504.201680672268','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 11:31:23','166000','DB','DEPOSITO BARRANQUILLA','1','166000.00000000','166000.00000000','139495.79831933','26504.201680672','166000','1','0','0','','24/04/2025','','0','0','166000','3337875722827','LA ROCHE POSAY SERUM ANTI-IMPERFECCIONES EFFACLAR * 30 ML ','1044','LOREAL COLOMBIA LA ROCHE POSAY','2025-04-24 11:28:42',  101341, 65177, 119, 53, 8620256)
			   ,('FVE','DB1','002262','2025-04-24 13:03:33','042025','CR','1044614032','DILAN ANDR eacute S','P eacute REZ PABA','CALLE 22 NO.23-27',' 3005298678','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','3','33613.445378151264','6386.554621848739','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 13:14:15','40000','DB','DEPOSITO BARRANQUILLA','1','35000.00000000','35000.00000000','29411.764705882','5588.2352941176','35000','1','0','0','','24/04/2025','','0','0','40000','7702006000994','AXE DARK TEMPTATION SPRAY *152 ML X2','388','UNILEVER ANDINA COLOMBIA','2025-04-24 13:03:33',  22434, 48050, 119, 53, 8622165)
			   ,('FVE','DB1','002262','2025-04-24 13:03:33','042025','CR','1044614032','DILAN ANDR eacute S','P eacute REZ PABA','CALLE 22 NO.23-27',' 3005298678','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','3','33613.445378151264','6386.554621848739','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 13:14:15','40000','DB','DEPOSITO BARRANQUILLA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','24/04/2025','','0','0','40000','7702031401049','JOHNSON JABON BABY CREMOSO HUMECT *110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-24 13:03:33',  3093.1, 56125, 119, 53, 8622165)
				  ,('FVE','DB2','004142','2025-04-24 14:05:53','042025','CR','811039091-1','PAPELES Y NEGOCIOS','SAS','CR 43 A 1 85 OF 307','2684959 3052668916','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 24, 2025, 2:21 pm','','2','1295300.8403361344','246107.15966386558','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-24 14:21:28','1541408','DBU','DEPOSITO BUCARAMANGA','1','1541408.19000000','1541408.19000000','1295300.8403361','246107.15966387','1541408','1','0','0','','24/04/2025','','0','0','1541408','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-24 14:05:53',  0, 50141, 426, 249, 8622713);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DB1','002263','2025-04-24 16:51:32','042025','CR','1063717149','DEIVI LUIS','DIAZ ARROYO','CRA 8A NO.42-34 VILLADELA',' 3024691465','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','12100','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 16:56:22','12100','DB','DEPOSITO BARRANQUILLA','1','12100.00000000','12100.00000000','12100','0','12100','1','0','0','','24/04/2025','','0','0','12100','7703381002085','BUSCAPINA FEM * 6 TAB','772','OPELLA (SANOFI OTC)','2025-04-24 16:51:32',  8878, 23810, 119, 53, 8624087)
			   ,('FVE','DB1','002264','2025-04-24 17:53:13','042025','CR','1007963867','CARLOS ANDRES','MEDINA MENDOZA','CALLE 14 NO.17B-144 LA LUZ',' 3243273899','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-24 17:59:46','4000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','24/04/2025','','0','0','4000','7591066701015','SCHICK XTREME SENSIBLE * 1 UND','417','EDGEWELL','2025-04-24 17:53:13',  2235, 25505, 119, 53, 8624478)
			   ,('FVE','DP1','022800','2025-04-24 18:03:29','042025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','55462.18487394958','10537.815126050416','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-24 18:03:29','66000','50','DEPOSITO CUCUTA ','1','45000.00000000','45000.00000000','37815.12605042','7184.8739495798','45000','1','0','1','','24/04/2025','','0','66000','0','7702031927310','LUBRIDERM MEN 3EN1 CON FRAGANCIA *400 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-24 18:03:29',  30083, 50642, 2, 19, 8624530)
			   ,('FVE','DP1','022800','2025-04-24 18:03:29','042025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','55462.18487394958','10537.815126050416','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-24 18:03:29','66000','50','DEPOSITO CUCUTA ','1','21000.00000000','21000.00000000','17647.058823529','3352.9411764706','21000','1','0','1','','24/04/2025','','0','66000','0','7702006302036','SHAMPO SAVITAL ANTICASPA *510 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-24 18:03:29',  13278, 62304, 2, 19, 8624530)
			   ,('FVE','DP1','022801','2025-04-24 18:27:55','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','9400','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-24 18:32:29','9400','50','DEPOSITO CUCUTA ','1','9400.00000000','9400.00000000','9400','0','9400','1','0','0','','25/04/2025','','0','0','9400','7702560009525','ALCOHOL JGB *700 ML','219','JGB','2025-04-24 18:27:55',  6669, 27765, 2, 19, 8624676)
			   ,('FVE','DB1','002265','2025-04-25 07:48:55','042025','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','','','','','','6','7142.857142857143','1357.1428571428569','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-25 07:59:23','8500','DB','DEPOSITO BARRANQUILLA','5','1700.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','5','0','1','','25/04/2025','','0','8500','0','7707822759255','SUPER PEGA ROCKET * 3 GR','950','TRONEX','2025-04-25 07:48:55',  816, 62093, 119, 53, 8625921)
			   ,('FVE','DP1','022802','2025-04-25 07:59:26','042025','CR','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','15966.38655462185','3033.6134453781506','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-25 08:06:20','19000','50','DEPOSITO CUCUTA ','1','19000.00000000','19000.00000000','15966.386554622','3033.6134453782','19000','1','0','0','','25/04/2025','','0','0','19000','6993145612068','MANOS LIBRES ORIGINAL','819','INOVY','2025-04-25 07:59:26',  7983, 57295, 2, 19, 8626143)
			   ,('FVE','DB2','004144','2025-04-25 08:05:59','042025','CO','1028781640','YISED PAOLA','DELGADO SANCHEZ','CALLE 11 # 24-31 BARRIO LA UNI',' 3214789562','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','32016.806722689078','6083.193277310922','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-27 19:22:01','38100','DBU','DEPOSITO BUCARAMANGA','1','38100.00000000','38100.00000000','32016.806722689','6083.1932773109','38100','1','0','1','','25/04/2025','','0','38100','0','7702123012108','REDOXON TOTAL * 20 COMP','631','BAYER OTC','2025-04-25 08:05:59',  26560, 56390, 426, 249, 8626193)
			   ,('FVE','DB2','004145','2025-04-25 08:08:44','042025','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','12','84777.31092436975','8222.689075630251','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-25 08:08:44','93000','DBU','DEPOSITO BUCARAMANGA','1','9600.00000000','9600.00000000','9600','0','9600','1','0','1','','25/04/2025','','0','93000','0','7702057079642','RISPERIDONA 1 MG * 20 TAB','654','MK ETICOS CONVENIO','2025-04-25 08:08:44',  7343, 43276, 426, 249, 8519147)
			   ,('FVE','DB2','004145','2025-04-25 08:08:44','042025','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','12','84777.31092436975','8222.689075630251','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-25 08:08:44','93000','DBU','DEPOSITO BUCARAMANGA','1','14400.00000000','14400.00000000','14400','0','14400','1','0','1','','25/04/2025','','0','93000','0','7702057078799','QUETIAPINA 25 MG * 30 TAB','654','MK ETICOS CONVENIO','2025-04-25 08:08:44',  11633, 43266, 426, 249, 8519147)
			   ,('FVE','DB2','004145','2025-04-25 08:08:44','042025','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','12','84777.31092436975','8222.689075630251','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-25 08:08:44','93000','DBU','DEPOSITO BUCARAMANGA','1','13500.00000000','13500.00000000','11344.537815126','2155.4621848739','13500','1','0','1','','25/04/2025','','0','93000','0','7703378009530','BRILLO DE LABIOS DIAMOND SPARKS SAMY # 03. PALO DE ROSA - ROSEWOOD','1013','COSMETICOS SAMY S.A.','2025-04-25 08:08:44',  6777.6, 63864, 426, 249, 8519147)
			   ,('FVE','DB2','004145','2025-04-25 08:08:44','042025','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','12','84777.31092436975','8222.689075630251','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-25 08:08:44','93000','DBU','DEPOSITO BUCARAMANGA','1','22500.00000000','22500.00000000','18907.56302521','3592.4369747899','22500','1','0','1','','25/04/2025','','0','93000','0','7703378020658','DELINEADOR PLUMÓN EN MARCADOR WP ULTIMATE PRECISION LINER SAMY NEGRO','1013','COSMETICOS SAMY S.A.','2025-04-25 08:08:44',  11445.12, 63870, 426, 249, 8519147)
			   ,('FVE','DB2','004145','2025-04-25 08:08:44','042025','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','12','84777.31092436975','8222.689075630251','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-25 08:08:44','93000','DBU','DEPOSITO BUCARAMANGA','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','1','','25/04/2025','','0','93000','0','78928503','DOVE DESO ROLLON CALENDULA *50 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-25 08:08:44',  9163, 43708, 426, 249, 8519147)
			   ,('FVE','DB2','004145','2025-04-25 08:08:44','042025','CO','37576749','YIRA ELENA','MANJARRES DE LA OSSA','CLL39#29A-132 GIRALUZ GIRON',' 3005688959','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','12','84777.31092436975','8222.689075630251','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-25 08:08:44','93000','DBU','DEPOSITO BUCARAMANGA','1','17500.00000000','17500.00000000','17500','0','17500','1','0','1','','25/04/2025','','0','93000','0','7702870003589','POSTDAY * 1 TAB ','696','ABBOTT FARMA CONVENIO','2025-04-25 08:08:44',  11100, 31697, 426, 249, 8519147)
			   ,('FVE','DB2','004146','2025-04-25 08:59:40','042025','CR','1005150334','JORGE LEONARDO','VILLALBA G oacute MEZ','CALLE 662 # 50-15 FLORIDA BLAN',' 3105718676','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','21008.40336134454','3991.596638655461','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-25 13:04:10','25000','DBU','DEPOSITO BUCARAMANGA','1','25000.00000000','25000.00000000','21008.403361345','3991.5966386555','25000','1','0','0','','25/04/2025','','0','0','25000','4005900036643','NIVEA AEROSOL INV BLACK & WHITE WOMEN *150 ML','123','BDF (BEIERSDORF) ','2025-04-25 08:59:40',  12972, 23071, 426, 249, 8627177)
			   ,('FVE','DP1','022803','2025-04-25 12:12:58','042025','CO','1090531686','ELIAB DANIEL','ROMERO PARRA','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','45900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-25 12:12:58','45900','50','DEPOSITO CUCUTA ','1','29500.00000000','29500.00000000','29500','0','29500','1','0','1','','25/04/2025','','0','45900','0','7707288823927','ZOPICLONA 7.5 MG * 30 TAB','205','HUMAX PHARMACEUTICAL','2025-04-25 12:12:58',  17329, 27389, 2, 19, 8618456)
			   ,('FVE','DP1','022803','2025-04-25 12:12:58','042025','CO','1090531686','ELIAB DANIEL','ROMERO PARRA','CALLE 6 NO. 9E CEIBA 2 CUCUTA','000000 3135712909','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','45900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-25 12:12:58','45900','50','DEPOSITO CUCUTA ','1','16400.00000000','16400.00000000','16400','0','16400','1','0','1','','25/04/2025','','0','45900','0','7702057061265','OXIMETAZOLINA 0.05% NASAL ADULTOS * 15 ML','654','MK ETICOS CONVENIO','2025-04-25 12:12:58',  11449.5, 43203, 2, 19, 8618456)
			   ,('FVE','DP1','022804','2025-04-25 13:24:11','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','15300','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-25 13:26:01','15300','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','8500','0','8500','1','0','0','','25/04/2025','','0','0','15300','7709990751970','HIOSCINA BUTIL 20 MG + DIPIRONA 2.5 GR * 1 AMP','701','VITALIS COMERCIAL','2025-04-25 13:24:11',  6499, 56374, 2, 19, 8629305)
			   ,('FVE','DP1','022804','2025-04-25 13:24:11','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','15300','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-25 13:26:01','15300','50','DEPOSITO CUCUTA ','1','6800.00000000','6800.00000000','6800','0','6800','1','0','0','','25/04/2025','','0','0','15300','7707236124816','AMIKACINA 500MG/2ML * 1 AMP','701','VITALIS COMERCIAL','2025-04-25 13:24:11',  5432, 54346, 2, 19, 8629305)
			   ,('FVE','DB1','002266','2025-04-25 13:54:27','042025','CR','1043962085','JUNIOR RAFAEL','GALINDO BETANCOURT','CRA 8B NO.37C-42',' 3136805041','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','3','39600','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-25 14:01:31','39600','DB','DEPOSITO BARRANQUILLA','1','21400.00000000','21400.00000000','21400','0','21400','1','0','0','','25/04/2025','','0','0','39600','7702057162412','NORAVER-P MENTA * 12 TAB','382','TECNOQUIMICAS','2025-04-25 13:54:27',  17878, 43181, 119, 53, 8629481)
			   ,('FVE','DB1','002266','2025-04-25 13:54:27','042025','CR','1043962085','JUNIOR RAFAEL','GALINDO BETANCOURT','CRA 8B NO.37C-42',' 3136805041','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','3','39600','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-25 14:01:31','39600','DB','DEPOSITO BARRANQUILLA','1','18200.00000000','18200.00000000','18200','0','18200','1','0','0','','25/04/2025','','0','0','39600','7702132008307','TODAY LONG ACTION * 3 PRESERVATIVOS  ','616','HALEON (GLAXO OTC)','2025-04-25 13:54:27',  16703, 39151, 119, 53, 8629481)
			   ,('FVE','DP1','022805','2025-04-25 14:30:47','042025','CR','1129566042','JURANIS','MORE MENDEZ','CALLE 69 NO.63-80 BELLAVISTA',' 3005784686','630','JUAN SEBASTIAN ','BAUTISTA ORTIZ ','','TERCERO','VARIOS','','','','','','3','8403.361344537816','1596.638655462184','00','DEPOSITO CUCUTA','COORDINADORAUDITOR5','2025-04-25 14:43:58','10000','50','DEPOSITO CUCUTA ','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','0','','25/04/2025','','0','0','10000','8412765508905','ENCENDEDOR CLIPPER RECARGABLE','950','TRONEX','2025-04-25 14:30:47',  2205, 62092, 2, 19, 8629719)
			   ,('FVE','DP1','022806','2025-04-25 16:09:18','042025','CO','1090429584','JESSICA  KATHERINE','NI Ntilde O CARO','CALLE 21 NO. 18-62 SAN JOSE CU','3142233732 3142233732','3976','JOEL','OTALVAREZ','','TERCERO','VARIOS','','','','','','2','19000','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-25 16:21:40','19000','50','DEPOSITO CUCUTA ','1','19000.00000000','19000.00000000','19000','0','19000','1','0','1','','25/04/2025','','19000','0','0','7702003459016','PARCHE LEON','123','BDF (BEIERSDORF) ','2025-04-25 16:09:18',  11987, 23303, 2, 19, 8630362)
			   ,('FVE','DB1','002267','2025-04-25 16:26:52','042025','CR','1044614032','DILAN ANDR eacute S','P eacute REZ PABA','CALLE 22 NO.23-27',' 3005298678','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','96200','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-25 16:33:44','96200','DB','DEPOSITO BARRANQUILLA','1','96200.00000000','96200.00000000','96200','0','96200','1','0','0','','25/04/2025','','0','0','96200','7703889016102','LACTULAX SUSP * 240 ML  ','242','CHALVER ','2025-04-25 16:26:52',  84300, 28972, 119, 53, 8630665)
			   ,('FVE','DB1','002268','2025-04-25 16:52:28','042025','CR','1007891376','C eacute SAR LUIS','VASQUEZ MENDOZA','CRA 16 NO.22-30 GALAPA',' 3238451741','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','10000','1900','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-25 16:59:29','11900','DB','DEPOSITO BARRANQUILLA','1','11900.00000000','11900.00000000','10000','1900','11900','1','0','0','','25/04/2025','','0','0','11900','7702277438076','INTIBON AVENA Y CALENDULA *120 GR','124','BELLEZA EXPRESS SA','2025-04-25 16:52:28',  7210, 56829, 119, 53, 8630855)
			   ,('FVE','DP1','022807','2025-04-25 18:47:49','042025','CR','1090534653','JHONIER','SANCHEZ BURGOS','CALLE 32 NO.36-26',' 3227358678','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','23000','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-25 19:32:15','23000','50','DEPOSITO CUCUTA ','2','11500.00000000','23000.00000000','23000','0','23000','2','0','0','','25/04/2025','','0','0','23000','7706569001269','CLOTRIMAZOL CREMA TOPICA * 40 GR','614','A.G. MEDICAMENTOS','2025-04-25 18:47:49',  4692.2, 31314, 2, 19, 8631506)
			   ,('FVE','DP1','022808','2025-04-25 20:45:55','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','5','28655.46218487395','5444.537815126049','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-26 10:00:51','34100','50','DEPOSITO CUCUTA ','3','8200.00000000','24600.00000000','20672.268907563','3927.731092437','24600','3','0','1','','25/04/2025','','34100','0','0','7702090064209','GASEOSA PEPSI * 2.5 LT','192','POSTOBON GASEOSAS','2025-04-25 20:45:55',  3824.3, 58758, 2, 19, 8631761)
			   ,('FVE','DP1','022808','2025-04-25 20:45:55','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','5','28655.46218487395','5444.537815126049','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-26 10:00:51','34100','50','DEPOSITO CUCUTA ','1','9500.00000000','9500.00000000','7983.1932773109','1516.8067226891','9500','1','0','1','','25/04/2025','','34100','0','0','7702535001769','COCA COLA * 2.5 LT','144','COCA COLA','2025-04-25 20:45:55',  5350, 34394, 2, 19, 8631761)
			   ,('FVE','DB2','004147','2025-04-26 07:07:52','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','35462.18487394958','6737.815126050418','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-26 10:00:51','42200','DBU','DEPOSITO BUCARAMANGA','1','16400.00000000','16400.00000000','13781.512605042','2618.487394958','16400','1','0','1','','26/04/2025','','42200','0','0','7702035430090','LISTERINE CONTROL CALCULO * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-26 07:07:52',  10373.793, 28021, 426, 249, 8616313)
			   ,('FVE','DB2','004147','2025-04-26 07:07:52','042025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','35462.18487394958','6737.815126050418','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-26 10:00:51','42200','DBU','DEPOSITO BUCARAMANGA','1','25800.00000000','25800.00000000','21680.672268908','4119.3277310924','25800','1','0','1','','26/04/2025','','42200','0','0','7506306214972','REXONA CLINICAL EXPERT MEN CLEAN SPRAY *150 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-26 07:07:52',  16185, 56419, 426, 249, 8616313)
			   ,('FVE','DP1','022809','2025-04-26 18:39:16','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','9075.63025210084','1724.3697478991598','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-26 18:49:23','10800','50','DEPOSITO CUCUTA ','1','10800.00000000','10800.00000000','9075.6302521008','1724.3697478992','10800','1','0','0','','26/04/2025','','10800','0','0','7702026175375','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO * 4 UNID','337','FAMILIA SANCELA','2025-04-26 18:39:16',  6882.3, 53469, 2, 19, 8634385)
			   ,('FVE','DP1','022812','2025-04-26 18:39:58','042025','CR','1091965380','JHOAN ANDRES','LINDARTE YANEZ','MANZANA 2H LOTE 4 TUCUNARE PAR',' 3124496991','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','33500','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-28 09:49:30','33500','50','DEPOSITO CUCUTA ','1','33500.00000000','33500.00000000','33500','0','33500','1','0','0','','26/04/2025','','0','0','33500','7709990384949','UNESIA CREMA * 20 GR','194','GENOMMA LABORATORIO COLOMBIA','2025-04-26 18:39:58',  26847, 26337, 2, 19, 8634390)
			   ,('FVE','DP1','022810','2025-04-26 18:43:39','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','4201.680672268908','798.319327731092','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-26 18:49:23','5000','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','26/04/2025','','5000','0','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-04-26 18:43:39',  3144, 40145, 2, 19, 8634398)
			   ,('FVE','DP1','022811','2025-04-28 09:32:30','042025','CR','88261284','RAFAEL YADIR','MOROS RIVERA','CONJUNTO CERRADO TERRAVIVA  AP',' 3003412502','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','9400','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-28 09:42:16','9400','50','DEPOSITO CUCUTA ','1','9400.00000000','9400.00000000','9400','0','9400','1','0','0','','28/04/2025','','0','0','9400','7702560009525','ALCOHOL JGB *700 ML','219','JGB','2025-04-28 09:32:30',  6669, 27765, 2, 19, 8637297)
			   ,('FVE','DP1','022813','2025-04-28 10:10:21','042025','CO','1090521222','JOAN SEBASTIAN','RAMIREZ DIAZ','CARRERA 10 NO.4-60 VILLA DEL R',' 3007368791','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','5000','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-28 10:10:21','5000','50','DEPOSITO CUCUTA ','2','2500.00000000','5000.00000000','5000','0','5000','0','2','1','','28/04/2025','','0','5000','0','7707355053431','NOXPIRIN DIA MANDARINA * 6 S/S ','626','SIEGFRIED CONSUMO','2025-04-28 10:10:21',  11836, 48523, 2, 19, 8637402)
			   ,('FVE','DP1','022814','2025-04-28 10:35:31','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','2352.9411764705883','447.0588235294117','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-28 10:43:42','2800','50','DEPOSITO CUCUTA ','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','0','','28/04/2025','','2800','0','0','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2025-04-28 10:35:31',  1823.4, 54241, 2, 19, 8637824)
			   ,('FVE','DP1','022815','2025-04-28 11:23:11','042025','CO','1090534835','MARIA FERNANDA','ACEVEDO LAZARO','AVENIDA 1 NO.1-25 CARLOS RAMIR',' 3023279745','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','14700','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-28 11:24:01','14700','50','DEPOSITO CUCUTA ','1','14700.00000000','14700.00000000','14700','0','14700','1','0','1','','28/04/2025','','0','14700','0','7702605104079','SULFADIAZINA PLATA CREMA * 30 GR ','193','GENFAR','2025-04-28 11:23:11',  10956, 26217, 2, 19, 8638131)
			   ,('FVE','DP1','022816','2025-04-28 13:02:18','042025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','4352.941176470588','447.0588235294117','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-28 13:29:40','4800','50','DEPOSITO CUCUTA ','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','1','','28/04/2025','','4800','0','0','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2025-04-28 13:02:18',  1823.4, 54241, 2, 19, 8638681)
			   ,('FVE','DP1','022816','2025-04-28 13:02:18','042025','CO','6393437','KENSY JAVIER','FERRER SOTO','AVENIDA 7A NO.15AE-52 APT 201','3208891308 3208891308','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','4352.941176470588','447.0588235294117','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-28 13:29:40','4800','50','DEPOSITO CUCUTA ','1','2000.00000000','2000.00000000','2000','0','2000','1','0','1','','28/04/2025','','4800','0','0','7702136646628','CURITAS CURE BAND *10 UNID  ','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-04-28 13:02:18',  1294, 42905, 2, 19, 8638681)
			   ,('FVE','DP1','022817','2025-04-28 14:40:21','042025','CR','1066865433','EDWIN DANILO','CUVIDES PAEZ','CALLE 23 NO.12-18 MONTEVIDEO 1',' 3209625939','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','28453.78151260504','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-28 14:57:26','29300','50','DEPOSITO CUCUTA ','1','24000.00000000','24000.00000000','24000','0','24000','1','0','0','','28/04/2025','','0','0','29300','7707019334203','FUNGISTEROL SHAMPOO * 100 ML','130','LABQUIFAR PHARMACEUTICA','2025-04-28 14:40:21',  10328, 45856, 2, 19, 8639390)
				  ,('FVE','DP1','022817','2025-04-28 14:40:21','042025','CR','1066865433','EDWIN DANILO','CUVIDES PAEZ','CALLE 23 NO.12-18 MONTEVIDEO 1',' 3209625939','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','28453.78151260504','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-28 14:57:26','29300','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','28/04/2025','','0','0','29300','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-28 14:40:21',  3375, 24465, 2, 19, 8639390);
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','004148','2025-04-28 16:44:01','042025','CR','800118334-5','BELLEZA EXPRESS','SA','CL 36 134 201 KM 6 VIA CALI - ','5552255 3136519547','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 28, 2025, 4:50 pm','','2','2826374.7899159663','537011.2100840337','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-28 16:51:04','3363386','DBU','DEPOSITO BUCARAMANGA','1','3363386.25000000','3363386.25000000','2826374.789916','537011.21008403','3363386','1','0','0','','28/04/2025','','0','0','3363386','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-28 16:44:01',  0, 50141, 426, 249, 8640321)
			   ,('FVE','DB2','004149','2025-04-28 16:46:36','042025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','28404.201680672268','1995.7983193277305','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-28 16:51:12','30400','DBU','DEPOSITO BUCARAMANGA','1','17900.00000000','17900.00000000','17900','0','17900','1','0','0','','28/04/2025','','0','0','30400','7707232092294','VALERIANA GOTAS * 25 ML','271','NATURAL FRESHLY','2025-04-28 16:46:36',  9674.6157, 46169, 426, 249, 8640362)
			   ,('FVE','DB2','004149','2025-04-28 16:46:36','042025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','28404.201680672268','1995.7983193277305','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-28 16:51:12','30400','DBU','DEPOSITO BUCARAMANGA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','28/04/2025','','0','0','30400','4891228530136','SCHICK QUATTRO TITANIUM * 1 UND ','417','EDGEWELL','2025-04-28 16:46:36',  2931.7, 25501, 426, 249, 8640362)
			   ,('FVE','DB2','004149','2025-04-28 16:46:36','042025','CR','1093888351','IVAN DAVID','SANCHEZ MALDONADO','CRA 31B NO.5-16 P3 MANZANA E1 ',' 3103428329','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','28404.201680672268','1995.7983193277305','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-28 16:51:12','30400','DBU','DEPOSITO BUCARAMANGA','1','7500.00000000','7500.00000000','6302.5210084034','1197.4789915966','7500','1','0','0','','28/04/2025','','0','0','30400','7702113047707','DEO PIES TALCO * 60GR ','278','RECAMIER','2025-04-28 16:46:36',  5021, 64433, 426, 249, 8640362)
			   ,('FVE','DB2','004151','2025-04-28 16:58:46','042025','CR','1065870246','ANDR eacute S FELIPE','PERALTA BUITRAGO','CRA 16C NO.60A-65 LA ESMERALDA',' 3042297170','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','14789.915966386556','2810.0840336134447','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-28 17:13:54','17600','DBU','DEPOSITO BUCARAMANGA','1','15000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','1','0','0','','28/04/2025','','0','0','17600','7702006301480','PONDS LIMPIADOR FACIAL DIARIO *50 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-28 16:58:46',  9621, 62641, 426, 249, 8640461)
			   ,('FVE','DB2','004151','2025-04-28 16:58:46','042025','CR','1065870246','ANDR eacute S FELIPE','PERALTA BUITRAGO','CRA 16C NO.60A-65 LA ESMERALDA',' 3042297170','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','14789.915966386556','2810.0840336134447','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-28 17:13:54','17600','DBU','DEPOSITO BUCARAMANGA','1','2600.00000000','2600.00000000','2184.8739495798','415.12605042017','2600','1','0','0','','28/04/2025','','0','0','17600','7702026147471','PAPEL HIG FAMILIA ACOLCHAMAX MEGAROLLO *1 UND','337','FAMILIA SANCELA','2025-04-28 16:58:46',  1613.7, 52184, 426, 249, 8640461)
			   ,('FVE','DB2','004150','2025-04-28 16:58:47','042025','CR','800118334-5','BELLEZA EXPRESS','SA','CL 36 134 201 KM 6 VIA CALI - ','5552255 3136519547','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 28, 2025, 5:00 pm','','2','2826374.7899159663','537011.2100840337','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-28 17:02:22','3363386','DBU','DEPOSITO BUCARAMANGA','1','3363386.25000000','3363386.25000000','2826374.789916','537011.21008403','3363386','1','0','0','','28/04/2025','','0','0','3363386','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-28 16:58:47',  0, 50141, 426, 249, 8640462)
			   ,('FVE','DP1','022818','2025-04-28 17:35:01','042025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','12184.873949579833','2315.1260504201673','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-28 17:44:00','14500','50','DEPOSITO CUCUTA ','1','14500.00000000','14500.00000000','12184.87394958','2315.1260504202','14500','1','0','0','','28/04/2025','','0','0','14500','7509546668673','LADY SPEED STICK CLINICAL ANTIBACTERIAL *100 GR','145','COLGATE PALMOLIVE COMPANIA','2025-04-28 17:35:01',  8444, 57775, 2, 19, 8640662)
			   ,('FVE','DP1','022819','2025-04-28 17:48:28','042025','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. April 28, 2025, 5:52 pm','','38918','8097025.210084034','1538434.7899159659','00','DEPOSITO CUCUTA','M.ACOSTA','2025-04-28 17:52:33','9635460','50','DEPOSITO CUCUTA ','38917','247.59000000','9635460.03000000','8097025.210084','1538434.789916','9635460','38917','0','0','','28/04/2025','','0','0','9635460','D1147','VENTA DE FORMULAS A CLOSE UP MES MARZO 2025','348','PROVEEDORES VARIOS','2025-04-28 17:48:28',  0, 41226, 2, 19, 8640746)
			   ,('FVE','DP1','022820','2025-04-28 18:21:50','042025','CR','1090434374','JESSICA LORENA','VELANDIA DAZA','',' 3165717093','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','11000','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-28 18:25:33','11000','50','DEPOSITO CUCUTA ','1','11000.00000000','11000.00000000','11000','0','11000','1','0','0','','28/04/2025','','0','0','11000','7702184130193','COMPLEJO B 10 ML * 1 AMP ','249','ECAR','2025-04-28 18:21:50',  8734, 29728, 2, 19, 8640984)
			   ,('FVE','DB2','004158','2025-04-28 19:21:57','042025','CR','1005150334','JORGE LEONARDO','VILLALBA G oacute MEZ','CALLE 662 # 50-15 FLORIDA BLAN',' 3105718676','1662','JORGE LEONARDO','VILLALBA GóMEZ','','TERCERO','VARIOS','','','','','','2','21512.605042016807','4087.3949579831933','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:34:23','25600','DBU','DEPOSITO BUCARAMANGA','1','25599.99000000','25599.99000000','21512.605042017','4087.3949579832','25600','1','0','0','','29/04/2025','','0','0','25600','079400052919','REXONA CLINICAL MEN AZUL *48 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-28 19:21:57',  15944, 43744, 426, 249, 8641188)
			   ,('FVE','DP1','022821','2025-04-29 08:03:21','042025','CO','900929396-4','SSP ASISTENCIAS ','SAS','CL 0 B N 7 A 42','5781374 3007512180','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','','','','2','126050.42016806723','23949.579831932773','00','DEPOSITO CUCUTA','AUXFINANZAS2','2025-04-29 08:18:25','150000','50','DEPOSITO CUCUTA ','1','150000.00000000','150000.00000000','126050.42016807','23949.579831933','150000','1','0','0','','29/04/2025','','0','150000','0','D1969','SERVICIO DE PARQUEADERO','1053','SERVICIOS','2025-04-29 08:03:21',  0, 64854, 2, 19, 8641989)
			   ,('FVE','DP1','022822','2025-04-29 10:24:44','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','20','35378.1512605042','6721.848739495797','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-29 10:35:21','42100','50','DEPOSITO CUCUTA ','2','2800.00000000','5600.00000000','4705.8823529412','894.11764705882','5600','2','0','0','','29/04/2025','','0','0','42100','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2025-04-29 10:24:44',  1823.4, 54241, 2, 19, 8643123)
			   ,('FVE','DP1','022822','2025-04-29 10:24:44','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','20','35378.1512605042','6721.848739495797','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-29 10:35:21','42100','50','DEPOSITO CUCUTA ','1','6500.00000000','6500.00000000','5462.1848739496','1037.8151260504','6500','1','0','0','','29/04/2025','','0','0','42100','7702090016406','GASEOSA MANZANA * 2.5 LT','192','POSTOBON GASEOSAS','2025-04-29 10:24:44',  4142.86, 35300, 2, 19, 8643123)
			   ,('FVE','DP1','022822','2025-04-29 10:24:44','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','20','35378.1512605042','6721.848739495797','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-29 10:35:21','42100','50','DEPOSITO CUCUTA ','12','2500.00000000','30000.00000000','25210.084033613','4789.9159663866','30000','12','0','0','','29/04/2025','','0','0','42100','7702090071849','SPEED MAX LATA * 310 ML ','192','POSTOBON GASEOSAS','2025-04-29 10:24:44',  1584, 64856, 2, 19, 8643123)
			   ,('FVE','DP1','022823','2025-04-29 11:53:21','042025','CR','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','3361.3445378151264','638.6554621848736','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-29 12:37:05','4000','50','DEPOSITO CUCUTA ','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','29/04/2025','','0','0','4000','7709134774193','VASELINA PURA LUSTRAPEL * 40 GR','1034','LABORATORIOS ROA','2025-04-29 11:53:21',  1503.5, 63957, 2, 19, 8643840)
			   ,('FVE','DP1','022827','2025-04-29 13:14:48','042025','CR','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','13865.546218487396','2634.453781512604','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-30 07:37:15','16500','50','DEPOSITO CUCUTA ','1','16500.00000000','16500.00000000','13865.546218487','2634.4537815126','16500','1','0','0','','30/04/2025','','0','0','16500','7701021142955','WINNY TOALLITAS AVENA Y MIEL * 80 UND','697','TECNOQUIMICAS WINNY TOALLITAS','2025-04-29 13:14:48',  9492, 44841, 2, 19, 8644157)
			   ,('FVE','DP1','022824','2025-04-29 14:22:01','042025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','2352.9411764705883','447.0588235294117','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-29 15:19:35','2800','50','DEPOSITO CUCUTA ','1','2800.00000000','2800.00000000','2352.9411764706','447.05882352941','2800','1','0','1','','29/04/2025','','2800','0','0','7702026180249','PAPEL HIG FAMILIA EXPERT *1 UND','337','FAMILIA SANCELA','2025-04-29 14:22:01',  1823.4, 54241, 2, 19, 8644642)
			   ,('FVE','DB2','004152','2025-04-29 16:14:46','042025','CR','805009691-0','JGB ','SA','CR 5 23 82 ','6851100 3222222222','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 29, 2025, 4:22 pm','','4','1382221.848739496','262622.15126050403','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-29 16:22:31','1644844','DBU','DEPOSITO BUCARAMANGA','1','1644844.18000000','1644844.18000000','1382221.8487395','262622.1512605','1644844','1','0','0','','29/04/2025','','0','0','1644844','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-29 16:14:46',  0, 50141, 426, 249, 8645461)
			   ,('FVE','DB2','004153','2025-04-29 16:42:02','042025','CR','860001942-8','BAYER','S.A.','AV AMERICAS 57  52 BOGOTA  ','4234000 3168772293','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 29, 2025, 4:45 pm','','2','16667000','3166730','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-29 16:52:01','19833730','DBU','DEPOSITO BUCARAMANGA','1','19833730.00000000','19833730.00000000','16667000','3166730','19833730','1','0','0','','29/04/2025','','0','0','19833730','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-29 16:42:02',  0, 50141, 426, 249, 8645659)
			   ,('FVE','DB2','004154','2025-04-29 16:51:08','042025','CR','1095955906','JHON NICOLS ','SANDOVAL SILVA','CRA 16A NO.14B-12 BARRIO LOS B',' 3106986853','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','45200','0','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-29 16:55:48','45200','DBU','DEPOSITO BUCARAMANGA','1','30200.00000000','30200.00000000','30200','0','30200','1','0','0','','29/04/2025','','0','0','45200','7702605107063','DESLORATADINA 5 MG * 10 TAB','193','GENFAR','2025-04-29 16:51:08',  22639.45, 25994, 426, 249, 8645724)
			   ,('FVE','DB2','004154','2025-04-29 16:51:08','042025','CR','1095955906','JHON NICOLS ','SANDOVAL SILVA','CRA 16A NO.14B-12 BARRIO LOS B',' 3106986853','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','3','45200','0','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-29 16:55:48','45200','DBU','DEPOSITO BUCARAMANGA','1','15000.00000000','15000.00000000','15000','0','15000','1','0','0','','29/04/2025','','0','0','45200','7702184020791','DESLORATADINA JBE * 60 ML','249','ECAR','2025-04-29 16:51:08',  3880, 65376, 426, 249, 8645724)
			   ,('FVE','DB2','004155','2025-04-29 16:56:10','042025','CR','1096064470','CAMILO ANDRES','MU Ntilde OZ PABON ','',' 3158373232','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','12605.042016806723','2394.957983193277','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-29 17:06:29','15000','DBU','DEPOSITO BUCARAMANGA','1','15000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','1','0','0','','29/04/2025','','0','0','15000','42277040','NIVEA C/FACIAL CUIDADO NUTRITIVO *50 ML','123','BDF (BEIERSDORF) ','2025-04-29 16:56:10',  7767.41247, 50790, 426, 249, 8645754)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','300.00000000','300.00000000','300','0','300','1','0','0','','29/04/2025','','0','0','56000','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-04-29 17:24:10',  0, 44347, 426, 249, 8645965)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','3000.00000000','3000.00000000','2521.0084033613','478.99159663866','3000','1','0','0','','29/04/2025','','0','0','56000','7501037608946','SCHICK EXACTA SENSIBLE * 1 UND','417','EDGEWELL','2025-04-29 17:24:10',  1341.18, 25500, 426, 249, 8645965)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','3000.00000000','3000.00000000','2521.0084033613','478.99159663866','3000','1','0','0','','29/04/2025','','0','0','56000','75900557','SCHICK EXACTA DELICADA * 1 UND ','417','EDGEWELL','2025-04-29 17:24:10',  1341.18, 25499, 426, 249, 8645965)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','29/04/2025','','0','0','56000','7707194530599','MASGLO ESMALTE EJECUTIVA *13.5 ML','801','CERESCOS','2025-04-29 17:24:10',  5657.376, 55522, 426, 249, 8645965)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','29/04/2025','','0','0','56000','7707773830539','MASGLO ESMALTE DOMINANTE *13.5 ML','801','CERESCOS','2025-04-29 17:24:10',  5262.72, 55521, 426, 249, 8645965)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','29/04/2025','','0','0','56000','7509546677002','PALMOLIVE JABON INTENSA RENOVACION *120 GR','145','COLGATE PALMOLIVE COMPANIA','2025-04-29 17:24:10',  2482.2, 52692, 426, 249, 8645965)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','8000.00000000','8000.00000000','6722.6890756303','1277.3109243697','8000','1','0','0','','29/04/2025','','0','0','56000','7509546000985','COLGATE CREMA DENTAL T/ACCION *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-29 17:24:10',  5546.7, 24467, 426, 249, 8645965)
			   ,('FVE','DB2','004156','2025-04-29 17:24:10','042025','CR','1005150446','DAMI aacute N CAMILO','LOZADA JAIMES','CRA 32A NO. 47A-21',' 3167263801','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','8','47106.72268907563','8893.277310924366','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','55999.99999999999','DBU','DEPOSITO BUCARAMANGA','1','20000.00000000','20000.00000000','16806.722689076','3193.2773109244','20000','1','0','0','','29/04/2025','','0','0','56000','D1346','CABLE IPHONE','819','INOVY','2025-04-29 17:24:10',  7983.19, 51478, 426, 249, 8645965)
			   ,('FVE','DB2','004157','2025-04-29 17:28:28','042025','CR','1097781524','JOHAN NICOL aacute S','FLOREZ ROJAS','MANZANA C CASA 17, BARILOCHE 1',' 3244170946','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','21764.70588235294','4135.2941176470595','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-29 17:59:15','25900','DBU','DEPOSITO BUCARAMANGA','1','25900.00000000','25900.00000000','21764.705882353','4135.2941176471','25900','1','0','0','','29/04/2025','','0','0','25900','75072896','REXONA MEN ANTITRANSPIRANTE XTRACOOL GEL * 80 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-29 17:28:28',  16185.1581, 64038, 426, 249, 8645982)
			   ,('FVE','DP1','022825','2025-04-29 17:37:04','042025','CO','1004806523','VERONICA','MENDEZ BELTRAN','CALLE 14A NO.21-05 NUEVO HORIZ',' 3106995449','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','2','41000','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-29 17:37:04','41000','50','DEPOSITO CUCUTA ','1','41000.00000000','41000.00000000','41000','0','41000','1','0','1','','29/04/2025','','0','41000','0','7703712080454','DERMA-3 CREMA * 40 GR /D20/','387','TRIDEX FARMACEUTICA','2025-04-29 17:37:04',  15709.090909091, 54055, 2, 19, 8644965)
			   ,('FVE','DP1','022826','2025-04-29 18:19:38','042025','CR','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','17142.857142857145','3257.142857142855','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-29 18:30:41','20400','50','DEPOSITO CUCUTA ','2','10200.00000000','20400.00000000','17142.857142857','3257.1428571429','20400','2','0','0','','30/04/2025','','0','0','20400','7509546000343','COLGATE CREMA DENTAL T/ACCION *100 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-29 18:19:38',  6883.2, 24460, 2, 19, 8646360)
			   ,('FVE','DB2','004159','2025-04-30 09:36:27','042025','CR','805009691-0','JGB ','SA','CR 5 23 82 ','6851100 3222222222','053','JOHN JAIRO','DURAN GOMEZ','','TERCERO','VARIOS','','','',' 80849880 Autoriza la Venta por Cupo. April 30, 2025, 9:37 am','','2','2614038.655462185','496667.3445378151','DBU','DEPOSITO BUCARAMANGA','1095955840','2025-04-30 09:41:33','3110706','DBU','DEPOSITO BUCARAMANGA','1','3110706.41000000','3110706.41000000','2614038.6554622','496667.34453782','3110706','1','0','0','','30/04/2025','','0','0','3110706','PCRE0405','DESCUENTO POS MARCA KIDS-XTRA LOKO  ','00','VARIOS','2025-04-30 09:36:27',  0, 50141, 426, 249, 8648310)
			   ,('FVE','DP1','022828','2025-04-30 09:50:08','042025','CR','1121913635','LEONARDO ANDRES','NIETO CHAMORRO','CALLE 13 NO.7-55 APTO 2',' 3177325771','332','JOAN SEBASTIAN','RAMIREZ DIAZ','','TERCERO','VARIOS','','','','','','2','14537.81512605042','2762.18487394958','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-30 09:58:14','17300','50','DEPOSITO CUCUTA ','1','17300.00000000','17300.00000000','14537.81512605','2762.1848739496','17300','1','0','0','','30/04/2025','','0','0','17300','7702277243960','TOALLITAS ARRURRU AVENA KARITE * 170 UND SUPER OFERTA','124','BELLEZA EXPRESS SA','2025-04-30 09:50:08',  9180, 64724, 2, 19, 8648516)
			   ,('FVE','DP1','022829','2025-04-30 10:15:38','042025','CO','88256247','ELKIN ANTONIO','RODRIGUEZ MALAGON','CALLE 27 NO. 11-35 BELLA VISTA','5781240 3144803965','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','5200','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 10:15:38','5200','50','DEPOSITO CUCUTA ','4','1300.00000000','5200.00000000','5200','0','5200','0','4','0','','30/04/2025','','5200','0','0','7702123006718','ASPIRINA EFERVESCENTE 500 MG * 50 TAB','631','BAYER OTC','2025-04-30 10:15:38',  55810, 22880, 2, 19, 8648800)
			   ,('FVE','DB2','004160','2025-04-30 13:07:52','042025','CO','1193443657','JOHAN SEBASTI aacute N','ORD oacute  ntilde EZ BECERRA','CALLE 3 NO.14-21 CECI',' 3104810150','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','3781.512605042017','718.4873949579828','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 13:07:52','4500','DBU','DEPOSITO BUCARAMANGA','1','4500.00000000','4500.00000000','3781.512605042','718.48739495798','4500','1','0','1','','30/04/2025','','0','4500','0','7702010111587','COLGATE CREMA DENTAL TRIPLE EXTRA BLANCURA *60 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 13:07:52',  2913.633, 48567, 426, 249, 8650574)
			   ,('FVE','DP1','022830','2025-04-30 14:41:47','042025','CR','1066865433','EDWIN DANILO','CUVIDES PAEZ','CALLE 23 NO.12-18 MONTEVIDEO 1',' 3209625939','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','4453.781512605042','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 14:57:54','5300','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','0','','30/04/2025','','0','0','5300','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 14:41:47',  3375, 24465, 2, 19, 8651437)
			   ,('FVE','DP1','022831','2025-04-30 15:52:16','042025','CR','1093795610','ADRIANA GICELA ','PE Atilde  plusmn ARANDA ROJAS','AV 13 # 16-15 LA LIBERTAD-CUCU',' 3134507750','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','53361.34453781513','10138.65546218487','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 15:57:40','63500','50','DEPOSITO CUCUTA ','1','63500.00000000','63500.00000000','53361.344537815','10138.655462185','63500','1','0','0','','30/04/2025','','0','0','63500','041554079302','MAYBELLINE LABIAL SUPER STAY VINYL INK PUNDHY X 4.2 ML','292','LOREAL COLOMBIA','2025-04-30 15:52:16',  40276, 64405, 2, 19, 8651901)
				  ,('FVE','DP1','022832','2025-04-30 15:54:04','042025','CR','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','51512.60504201681','9787.39495798319','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 15:59:30','61300','50','DEPOSITO CUCUTA ','1','38500.00000000','38500.00000000','32352.941176471','6147.0588235294','38500','1','0','0','','30/04/2025','','0','0','61300','7506306217683','PONDS FRUITY HYDRA FRESH GEL LIMPIADOR 2EN1 *200ML','388','UNILEVER ANDINA COLOMBIA','2025-04-30 15:54:04',  23158.53, 61753, 2, 19, 8651908);
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','022832','2025-04-30 15:54:04','042025','CR','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','51512.60504201681','9787.39495798319','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 15:59:30','61300','50','DEPOSITO CUCUTA ','1','7800.00000000','7800.00000000','6554.6218487395','1245.3781512605','7800','1','0','0','','30/04/2025','','0','0','61300','7702031132844','JOHNSON ACEITE ORIG * 50 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 15:54:04',  4891.5, 27936, 2, 19, 8651908)
			   ,('FVE','DP1','022832','2025-04-30 15:54:04','042025','CR','1090507432','KAROL PATRICIA','PADUA ASCANIO','CLL12 #15-16 BELISARIO',' 3024763659','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','51512.60504201681','9787.39495798319','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 15:59:30','61300','50','DEPOSITO CUCUTA ','1','15000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','1','0','0','','30/04/2025','','0','0','61300','7702006301480','PONDS LIMPIADOR FACIAL DIARIO *50 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-30 15:54:04',  13193.28, 62641, 2, 19, 8651908)
			   ,('FVE','DB1','002269','2025-04-30 15:59:10','042025','CO','1093744050','WILMER ARMANDO','DUR aacute N MALAGON','CALLE 12N NO. 7-72 CARLOS RAMI',' 3142876443','112','WILMER ARMANDO','DURáN MALAGON','','TERCERO','VARIOS','','','','','','5','121344.53781512605','23055.462184873948','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 15:59:10','144400','DB','DEPOSITO BARRANQUILLA','4','36100.01000000','144400.04000000','121344.53781513','23055.462184874','144400','4','0','1','','30/04/2025','','0','144400','0','7702006914963','REXONA DESO BARRA V8 *50GR *2UND','388','UNILEVER ANDINA COLOMBIA','2025-04-30 15:59:10',  23319, 43761, 119, 53, 8651957)
			   ,('FVE','DP1','022833','2025-04-30 15:59:44','042025','CO','1093795610','ADRIANA GICELA ','PE Atilde  plusmn ARANDA ROJAS','AV 13 # 16-15 LA LIBERTAD-CUCU',' 3134507750','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','11428.57142857143','2171.4285714285706','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 15:59:44','13600','50','DEPOSITO CUCUTA ','1','5800.00000000','5800.00000000','4873.9495798319','926.05042016807','5800','1','0','1','','30/04/2025','','0','13600','0','7702560040863','ECOPITOS JGB * 50 UND','219','JGB','2025-04-30 15:59:44',  4123, 27809, 2, 19, 8651891)
			   ,('FVE','DP1','022833','2025-04-30 15:59:44','042025','CO','1093795610','ADRIANA GICELA ','PE Atilde  plusmn ARANDA ROJAS','AV 13 # 16-15 LA LIBERTAD-CUCU',' 3134507750','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','11428.57142857143','2171.4285714285706','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 15:59:44','13600','50','DEPOSITO CUCUTA ','1','7800.00000000','7800.00000000','6554.6218487395','1245.3781512605','7800','1','0','1','','30/04/2025','','0','13600','0','7702031132844','JOHNSON ACEITE ORIG * 50 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 15:59:44',  4891.5, 27936, 2, 19, 8651891)
			   ,('FVE','DB2','004161','2025-04-30 16:09:24','042025','CR','1095955906','JHON NICOLS ','SANDOVAL SILVA','CRA 16A NO.14B-12 BARRIO LOS B',' 3106986853','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','5','8151.260504201681','1548.7394957983188','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:22:27','9700','DBU','DEPOSITO BUCARAMANGA','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','0','','30/04/2025','','0','0','9700','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 16:09:24',  3090.4227, 40129, 426, 249, 8652023)
			   ,('FVE','DB2','004161','2025-04-30 16:09:24','042025','CR','1095955906','JHON NICOLS ','SANDOVAL SILVA','CRA 16A NO.14B-12 BARRIO LOS B',' 3106986853','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','5','8151.260504201681','1548.7394957983188','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:22:27','9700','DBU','DEPOSITO BUCARAMANGA','1','4700.00000000','4700.00000000','3949.5798319328','750.42016806723','4700','1','0','0','','30/04/2025','','0','0','9700','7702031414346','JOHNSON JABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 16:09:24',  2601, 56006, 426, 249, 8652023)
			   ,('FVE','DP1','022834','2025-04-30 16:13:16','042025','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','9','26006.722689075632','3193.277310924368','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 16:22:27','29200','50','DEPOSITO CUCUTA ','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','1','','30/04/2025','','0','29200','0','7702031401049','JOHNSON JABON BABY CREMOSO HUMECT *110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 16:13:16',  3055.194, 56125, 2, 19, 8652038)
			   ,('FVE','DP1','022834','2025-04-30 16:13:16','042025','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','9','26006.722689075632','3193.277310924368','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 16:22:27','29200','50','DEPOSITO CUCUTA ','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','1','','30/04/2025','','0','29200','0','7702031401032','JOHNSON BABYJABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 16:13:16',  3347.1, 56126, 2, 19, 8652038)
			   ,('FVE','DP1','022834','2025-04-30 16:13:16','042025','CO','1090230087','HERNAN ANTONIO','RINCON CONTRERAS','AV 9 ANEXO DE CASA 0-71 BARRIO',' 3148647357','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','9','26006.722689075632','3193.277310924368','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 16:22:27','29200','50','DEPOSITO CUCUTA ','4','2300.00000000','9200.00000000','9200','0','9200','0','4','1','','30/04/2025','','0','29200','0','7703546041430','DOLORSIN FEM * 40 CAP L-TR-CAPS','630','NOVAMED OTC','2025-04-30 16:13:16',  39242.5, 55304, 2, 19, 8652038)
			   ,('FVE','DP1','022835','2025-04-30 16:16:41','042025','CO','60291739','ELCIDA','SUAREZ RODRIGUEZ','CALLE 17 NO. 19-36 VALLESTER L',' 3183666721','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','7413.44537815126','686.5546218487393','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 16:22:27','8100','50','DEPOSITO CUCUTA ','1','4300.00000000','4300.00000000','3613.4453781513','686.55462184874','4300','1','0','1','','30/04/2025','','8100','0','0','7702645200236','ACEITE DE COCO * 1 ONZ','263','LEON','2025-04-30 16:16:41',  2180.7692307692, 45489, 2, 19, 8652055)
			   ,('FVE','DP1','022835','2025-04-30 16:16:41','042025','CO','60291739','ELCIDA','SUAREZ RODRIGUEZ','CALLE 17 NO. 19-36 VALLESTER L',' 3183666721','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','7413.44537815126','686.5546218487393','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 16:22:27','8100','50','DEPOSITO CUCUTA ','1','3800.00000000','3800.00000000','3800','0','3800','1','0','1','','30/04/2025','','8100','0','0','7702560026577','ALCOHOL JGB *120 ML','219','JGB','2025-04-30 16:16:41',  2529, 27762, 2, 19, 8652055)
			   ,('FVE','DB2','004162','2025-04-30 16:26:40','042025','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','70924.36974789915','13475.63025210084','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:31:28','84400','DBU','DEPOSITO BUCARAMANGA','1','26000.00000000','26000.00000000','21848.739495798','4151.2605042017','26000','1','0','1','','30/04/2025','','0','84400','0','4022679136473','VITAMINA C+B2+ZINC *20 TAB','777','PHARMARIS COLOMBIA','2025-04-30 16:26:40',  11994.8, 56184, 426, 249, 8652111)
			   ,('FVE','DB2','004162','2025-04-30 16:26:40','042025','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','70924.36974789915','13475.63025210084','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:31:28','84400','DBU','DEPOSITO BUCARAMANGA','1','21600.00000000','21600.00000000','18151.260504202','3448.7394957983','21600','1','0','1','','30/04/2025','','0','84400','0','7702123010487','ACID MANTLE JABON TRIPACK * 90 GR','631','BAYER OTC','2025-04-30 16:26:40',  15910, 49720, 426, 249, 8652111)
			   ,('FVE','DB2','004162','2025-04-30 16:26:40','042025','CO','80849880','RAFAEL ANTONIO','LERZUNDY TORRES','AV 10E #9N-99 APT 101','3155444129 3167495696','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','4','70924.36974789915','13475.63025210084','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:31:28','84400','DBU','DEPOSITO BUCARAMANGA','1','36800.00000000','36800.00000000','30924.369747899','5875.6302521008','36800','1','0','1','','30/04/2025','','0','84400','0','7702006200981','REXONA V8 SPRAY 2 UND * 90 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-30 16:26:40',  22202.0781, 52340, 426, 249, 8652111)
			   ,('FVE','DP1','022851','2025-04-30 16:30:12','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','32268.907563025212','6131.092436974787','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 18:32:35','38400','50','DEPOSITO CUCUTA ','1','8200.00000000','8200.00000000','6890.756302521','1309.243697479','8200','1','0','0','','30/04/2025','','0','0','38400','7702090064209','GASEOSA PEPSI * 2.5 LT','192','POSTOBON GASEOSAS','2025-04-30 16:30:12',  3824.3, 58758, 2, 19, 8652179)
			   ,('FVE','DP1','022851','2025-04-30 16:30:12','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','32268.907563025212','6131.092436974787','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 18:32:35','38400','50','DEPOSITO CUCUTA ','1','3400.00000000','3400.00000000','2857.1428571429','542.85714285714','3400','1','0','0','','30/04/2025','','0','0','38400','7702354954994','AMPER BY BLESSD * 473 ML','350','QUALA NEVERA','2025-04-30 16:30:12',  2101, 62826, 2, 19, 8652179)
			   ,('FVE','DP1','022851','2025-04-30 16:30:12','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','32268.907563025212','6131.092436974787','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 18:32:35','38400','50','DEPOSITO CUCUTA ','1','1300.00000000','1300.00000000','1092.4369747899','207.56302521008','1300','1','0','0','','30/04/2025','','0','0','38400','D1037, 75010659','H & S SHAMPOO SOBRE SURTIDO','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 16:30:12',  603.88875, 32623, 2, 19, 8652179)
			   ,('FVE','DP1','022851','2025-04-30 16:30:12','042025','CR','1082848063','JOS iuml  iquest  frac12  ALBERTO','VELEZ MARTINEZ','CLL 2 # 7 41  BRR BELLA VISTA',' 3160513149','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','32268.907563025212','6131.092436974787','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 18:32:35','38400','50','DEPOSITO CUCUTA ','1','25500.00000000','25500.00000000','21428.571428571','4071.4285714286','25500','1','0','0','','30/04/2025','','0','0','38400','7702113011937','DEO PIES XTREM SPRAY *260 ML','278','RECAMIER','2025-04-30 16:30:12',  15583.05, 30610, 2, 19, 8652179)
			   ,('FVE','DB2','004163','2025-04-30 16:34:50','042025','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','','','','','','14','104168.06722689077','17131.93277310924','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:34:50','121300','DBU','DEPOSITO BUCARAMANGA','1','14000.00000000','14000.00000000','14000','0','14000','1','0','1','','30/04/2025','','0','121300','0','7707355053486','NOXPIRIN SINUS * 12 TAB PAGUE 10 LLEVE 12','626','SIEGFRIED CONSUMO','2025-04-30 16:34:50',  8423, 33749, 426, 249, 8629196)
			   ,('FVE','DB2','004163','2025-04-30 16:34:50','042025','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','','','','','','14','104168.06722689077','17131.93277310924','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:34:50','121300','DBU','DEPOSITO BUCARAMANGA','3','5000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','3','0','1','','30/04/2025','','0','121300','0','7702031401049','JOHNSON JABON BABY CREMOSO HUMECT *110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 16:34:50',  3055.194, 56125, 426, 249, 8629196)
			   ,('FVE','DB2','004163','2025-04-30 16:34:50','042025','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','','','','','','14','104168.06722689077','17131.93277310924','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:34:50','121300','DBU','DEPOSITO BUCARAMANGA','3','5000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','3','0','1','','30/04/2025','','0','121300','0','7702031401025','JOHNSON JABON BABY AVENA * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 16:34:50',  3093, 28086, 426, 249, 8629196)
			   ,('FVE','DB2','004163','2025-04-30 16:34:50','042025','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','','','','','','14','104168.06722689077','17131.93277310924','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:34:50','121300','DBU','DEPOSITO BUCARAMANGA','1','26000.00000000','26000.00000000','21848.739495798','4151.2605042017','26000','1','0','1','','30/04/2025','','0','121300','0','4022679136473','VITAMINA C+B2+ZINC *20 TAB','777','PHARMARIS COLOMBIA','2025-04-30 16:34:50',  11994.8, 56184, 426, 249, 8629196)
			   ,('FVE','DB2','004163','2025-04-30 16:34:50','042025','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','','','','','','14','104168.06722689077','17131.93277310924','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:34:50','121300','DBU','DEPOSITO BUCARAMANGA','1','15800.00000000','15800.00000000','13277.31092437','2522.6890756303','15800','1','0','1','','30/04/2025','','0','121300','0','7501086454181','PRO CEPILLO 1000 * 2 UND','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 16:34:50',  10296.162, 39998, 426, 249, 8629196)
			   ,('FVE','DB2','004163','2025-04-30 16:34:50','042025','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','','','','','','14','104168.06722689077','17131.93277310924','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-04-30 16:34:50','121300','DBU','DEPOSITO BUCARAMANGA','1','35500.00000000','35500.00000000','29831.932773109','5668.0672268908','35500','1','0','1','','30/04/2025','','0','121300','0','7500435198172','OLD SPICE DESO SPRAY ADVENTURE  2 UND * 150 ML ','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 16:34:50',  0, 65369, 426, 249, 8629196)
			   ,('FVE','DP1','022836','2025-04-30 16:37:17','042025','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','7785.714285714286','1479.2857142857138','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:08:45','9265','50','DEPOSITO CUCUTA ','1','9265.00000000','9265.00000000','7785.7142857143','1479.2857142857','9265','1','0','0','','30/04/2025','','0','0','9265','7702277395256','TOALLITAS ARRURRU AVENA Y KARITE * 100 UND ','124','BELLEZA EXPRESS SA','2025-04-30 16:37:17',  5788.5, 55332, 2, 19, 8652225)
			   ,('FVE','DP1','022850','2025-04-30 16:38:47','042025','CR','1090398626','SANDY PAOLA','MONTENEGRO  ORTIZ','AV15    15-47  CONTENTO','3147797062 3147797062','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','12857.142857142857','2442.857142857143','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:53:06','15300','50','DEPOSITO CUCUTA ','2','7650.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','2','0','0','','30/04/2025','','0','0','15300','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-04-30 16:38:47',  4411.5, 55331, 2, 19, 8652241)
			   ,('FVE','DB2','004164','2025-04-30 16:42:12','042025','CO','1093886374','WILLIAN MIGUEL','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','34584.03361344538','3815.966386554621','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-30 17:08:45','38400','DBU','DEPOSITO BUCARAMANGA','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','1','','30/04/2025','','0','38400','0','7702045563726','BALANCE CLINICAL CREMA MINI MEN * 30 GR','203','HENKEL COLOMBIANA','2025-04-30 16:42:12',  2888.1129, 52775, 426, 249, 8652227)
			   ,('FVE','DB2','004164','2025-04-30 16:42:12','042025','CO','1093886374','WILLIAN MIGUEL','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','34584.03361344538','3815.966386554621','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-30 17:08:45','38400','DBU','DEPOSITO BUCARAMANGA','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','30/04/2025','','0','38400','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 16:42:12',  3375, 24465, 426, 249, 8652227)
			   ,('FVE','DB2','004164','2025-04-30 16:42:12','042025','CO','1093886374','WILLIAN MIGUEL','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','34584.03361344538','3815.966386554621','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-30 17:08:45','38400','DBU','DEPOSITO BUCARAMANGA','2','4700.00000000','9400.00000000','7899.1596638655','1500.8403361345','9400','2','0','1','','30/04/2025','','0','38400','0','7702031414346','JOHNSON JABON ORIGINAL * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 16:42:12',  2601, 56006, 426, 249, 8652227)
			   ,('FVE','DB2','004164','2025-04-30 16:42:12','042025','CO','1093886374','WILLIAN MIGUEL','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','34584.03361344538','3815.966386554621','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-30 17:08:45','38400','DBU','DEPOSITO BUCARAMANGA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','1','','30/04/2025','','0','38400','0','7591066701015','SCHICK XTREME SENSIBLE * 1 UND','417','EDGEWELL','2025-04-30 16:42:12',  2235.29, 25505, 426, 249, 8652227)
			   ,('FVE','DB2','004164','2025-04-30 16:42:12','042025','CO','1093886374','WILLIAN MIGUEL','PE ntilde A PE ntilde A','AV 36 31-03 BR LA PASTORA',' 3154536603','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','7','34584.03361344538','3815.966386554621','DBU','DEPOSITO BUCARAMANGA','AUXAUDITOR26','2025-04-30 17:08:45','38400','DBU','DEPOSITO BUCARAMANGA','1','14500.00000000','14500.00000000','14500','0','14500','1','0','1','','30/04/2025','','0','38400','0','7703712012097','DERMASKIN CREMA * 20 GR','793','COASPHARMA MEDIBRAND OTX','2025-04-30 16:42:12',  8493.019, 24273, 426, 249, 8652227)
			   ,('FVE','DP1','022837','2025-04-30 16:57:33','042025','CO','1090424006','JULI aacute N ANDR eacute S','D iacute AZ RODR iacute GUEZ','CALLE 16 NO. 51-55 ANTONIA SAN',' 3203401678','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','17310.9243697479','3289.0756302521013','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:08:45','20600','50','DEPOSITO CUCUTA ','1','15300.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','1','0','1','','30/04/2025','','20600','0','0','7500435019958','H & S SHAMPO LIMPIEZA RENOV *180 ML','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 16:57:33',  10191.402, 53528, 2, 19, 8652319)
			   ,('FVE','DP1','022837','2025-04-30 16:57:33','042025','CO','1090424006','JULI aacute N ANDR eacute S','D iacute AZ RODR iacute GUEZ','CALLE 16 NO. 51-55 ANTONIA SAN',' 3203401678','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','17310.9243697479','3289.0756302521013','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:08:45','20600','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','30/04/2025','','20600','0','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 16:57:33',  3375, 24465, 2, 19, 8652319)
			   ,('FVE','DP1','022839','2025-04-30 16:58:19','042025','CR','37398259','LILIANA','RINC oacute N MEDINA','CALLE 20A 22 15 MUJERES DEL FU',' 3133135840','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','12857.142857142857','2442.857142857143','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:13:54','15300','50','DEPOSITO CUCUTA ','2','7650.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','2','0','0','','30/04/2025','','0','0','15300','7702277156673','TOALLITAS ARRURRU AVENA Y KARITE * 70 UND','124','BELLEZA EXPRESS SA','2025-04-30 16:58:19',  4411.5, 55331, 2, 19, 8652327)
			   ,('FVE','DP1','022838','2025-04-30 17:01:59','042025','CO','1090521222','JOAN SEBASTIAN','RAMIREZ DIAZ','CARRERA 10 NO.4-60 VILLA DEL R',' 3007368791','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','19075.63025210084','3624.36974789916','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:08:45','22700','50','DEPOSITO CUCUTA ','1','22700.00000000','22700.00000000','19075.630252101','3624.3697478992','22700','1','0','1','','30/04/2025','','0','22700','0','7702123011545','MEXSANA CLASICO AEROSOL * 260 ML','631','BAYER OTC','2025-04-30 17:01:59',  16170, 33107, 2, 19, 8652335)
			   ,('FVE','DB1','002270','2025-04-30 17:04:06','042025','CR','1063717149','DEIVI LUIS','DIAZ ARROYO','CRA 8A NO.42-34 VILLADELA',' 3024691465','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','3109.2436974789916','590.7563025210084','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-30 17:09:42','3700','DB','DEPOSITO BARRANQUILLA','1','3700.00000000','3700.00000000','3109.243697479','590.75630252101','3700','1','0','0','','30/04/2025','','0','0','3700','7702026031329','PEQUEÑIN PAÑOS HUMEDOS ALMENDRA * 24 UND','337','FAMILIA SANCELA','2025-04-30 17:04:06',  2477.7, 44961, 119, 53, 8652349)
			   ,('FVE','DB1','002271','2025-04-30 17:07:43','042025','CR','1128145656','CARLOS ANTONIO','ARRIETA PE Ntilde A','CALLE 36 NO.37-74',' 3117038131','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','3','15042.016806722688','2857.9831932773113','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:10:42','17900','DB','DEPOSITO BARRANQUILLA','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','30/04/2025','','0','0','17900','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:07:43',  5618.97225, 49624, 119, 53, 8652382)
			   ,('FVE','DB1','002271','2025-04-30 17:07:43','042025','CR','1128145656','CARLOS ANTONIO','ARRIETA PE Ntilde A','CALLE 36 NO.37-74',' 3117038131','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','3','15042.016806722688','2857.9831932773113','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:10:42','17900','DB','DEPOSITO BARRANQUILLA','1','6400.00000000','6400.00000000','5378.1512605042','1021.8487394958','6400','1','0','0','','30/04/2025','','0','0','17900','7702010130625','COLGATE CEPILLO EXTRA CLEAN DURA','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:07:43',  2961, 48362, 119, 53, 8652382)
			   ,('FVE','DB1','002272','2025-04-30 17:09:12','042025','CR','1128146141','GABRIEL JES Uacute S ','CARO ESPA Ntilde A ','CRA 6C NO.47-87 METROPOLITANO',' 3207312086','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','9663.865546218487','1836.134453781513','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:17:53','11500','DB','DEPOSITO BARRANQUILLA','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','30/04/2025','','0','0','11500','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:09:12',  5618.97225, 49624, 119, 53, 8652396)
				  ,('FVE','DB1','002273','2025-04-30 17:12:07','042025','CR','1043116013','ARNOVIS','QUINTERO TONCEL','CALLE 28 NO.143B-93 VILLA SAN ',' 3044761332','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','3109.2436974789916','590.7563025210084','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-30 17:17:53','3700','DB','DEPOSITO BARRANQUILLA','1','3700.00000000','3700.00000000','3109.243697479','590.75630252101','3700','1','0','0','','30/04/2025','','0','0','3700','7702026031329','PEQUEÑIN PAÑOS HUMEDOS ALMENDRA * 24 UND','337','FAMILIA SANCELA','2025-04-30 17:12:07',  2477.7, 44961, 119, 53, 8652421);
INSERT INTO consolida1(TIPODOC, PREFIJODOC, NUMERODOC, FECHADOC, PERIODODOC, FORMAPAGODOC, DNICLIDOC, NOMBRESCLIDOC, APECLIDOC, DIRCLIDOC, TELCLIDOC, CODVENDOC, NOMVENDOC, APEVENDOC, CODMENDOC, NOMMENDOC, APEMENDOC, CODMEDDOC, DNIMEDDOC, NOMMEDDOC, OBSERVADOC, OBSERVACION2, ITEMSDOC, VRBASEDOC, VRIVADOC, CODSUCURSAL, NOMSUCDOC, CREDORDOC, MOMENTODOC, TOTALDOC, DECODBOD, DENOMBOD, DECANTIDAD, DEVALUNI, DEVALPAR, DEVALBASE, DEVALIVA, DEVALTOTAL, DEUNICOM, DEUNIFRA, DEPUNTOS , AGENDO , DVDIAOPE, DDDIAOPE, FPEFECTIVO , FPTARJETAS , FPOTROS , CODPRODUCTO, NOMPRODUCTO, CODLABO, NOMLABO, MOMINSERTADO , COSTOPROD, PRODUCTOID, BODEGAID, SUCURSALID , DOCUID) VALUES ('FVE','DB1','002274','2025-04-30 17:14:37','042025','CR','1193598679','ERNEL ENRIQUE ','MANGONEZ LEDESMA','CALLE 70 NO.16C-09 VILLA ESTAD',' 3243182290','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','21008.40336134454','3991.596638655462','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:17:53','25000','DB','DEPOSITO BARRANQUILLA','1','4000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','1','0','0','','30/04/2025','','0','0','25000','78930841','REXONA DESO MINI ROLLON V8 * 30 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-30 17:14:37',  2466.7719, 43766, 119, 53, 8652441)
			   ,('FVE','DB1','002274','2025-04-30 17:14:37','042025','CR','1193598679','ERNEL ENRIQUE ','MANGONEZ LEDESMA','CALLE 70 NO.16C-09 VILLA ESTAD',' 3243182290','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','21008.40336134454','3991.596638655462','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:17:53','25000','DB','DEPOSITO BARRANQUILLA','1','11500.00000000','11500.00000000','9663.8655462185','1836.1344537815','11500','1','0','0','','30/04/2025','','0','0','25000','7509546062471','COLGATE CREMA DENTAL LUMINOUS WHITE * 50 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:14:37',  5618.97225, 49624, 119, 53, 8652441)
			   ,('FVE','DB1','002274','2025-04-30 17:14:37','042025','CR','1193598679','ERNEL ENRIQUE ','MANGONEZ LEDESMA','CALLE 70 NO.16C-09 VILLA ESTAD',' 3243182290','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','21008.40336134454','3991.596638655462','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:17:53','25000','DB','DEPOSITO BARRANQUILLA','1','9500.00000000','9500.00000000','7983.1932773109','1516.8067226891','9500','1','0','0','','30/04/2025','','0','0','25000','3014260802189','ORAL B CEPILLO COMPLETE 40 MEDIANO * 1 UND','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 17:14:37',  5292, 39977, 119, 53, 8652441)
			   ,('FVE','DB1','002275','2025-04-30 17:15:55','042025','CR','1050277968','JORGE MARIO ','ALVIS DE AVILA','CALLE 80 NO.20-14',' 3146752812','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','29831.932773109245','5668.067226890755','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-30 17:19:58','35500','DB','DEPOSITO BARRANQUILLA','1','35500.00000000','35500.00000000','29831.932773109','5668.0672268908','35500','1','0','0','','30/04/2025','','0','0','35500','7509546687414','COLGATE CEPILLO 360 MEDIO * 2 UND + CREMA TOTAL 12 * 75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:15:55',  22291.2, 51447, 119, 53, 8652454)
			   ,('FVE','DP1','022840','2025-04-30 17:27:20','042025','CO','1090534835','MARIA FERNANDA','ACEVEDO LAZARO','AVENIDA 1 NO.1-25 CARLOS RAMIR',' 3023279745','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','19264.705882352944','3660.2941176470576','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:27:20','22925','50','DEPOSITO CUCUTA ','1','19125.00000000','19125.00000000','16071.428571429','3053.5714285714','19125','1','0','1','','30/04/2025','','0','22925','0','7702277074403','COLONIA ARRURRU ROSADA * 120 ML','124','BELLEZA EXPRESS SA','2025-04-30 17:27:20',  14696.5, 34503, 2, 19, 8652348)
			   ,('FVE','DP1','022840','2025-04-30 17:27:20','042025','CO','1090534835','MARIA FERNANDA','ACEVEDO LAZARO','AVENIDA 1 NO.1-25 CARLOS RAMIR',' 3023279745','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','19264.705882352944','3660.2941176470576','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:27:20','22925','50','DEPOSITO CUCUTA ','1','3800.00000000','3800.00000000','3193.2773109244','606.72268907563','3800','1','0','1','','30/04/2025','','0','22925','0','7702006299251','SAVITAL CREMA PEINAR ACEITE DE ARGAN * 90 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-30 17:27:20',  1954, 65437, 2, 19, 8652348)
			   ,('FVE','DB1','002277','2025-04-30 17:28:34','042025','CR','1129504297','CAMILO ANDR Eacute S','GIM Eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','5','74453.78151260504','14146.218487394955','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-30 17:36:47','88600','DB','DEPOSITO BARRANQUILLA','2','25700.00000000','51400.00000000','43193.277310924','8206.7226890756','51400','2','0','0','','30/04/2025','','0','0','88600','079400300546','REXONA CLINICAL MEN SPORT STRENGTH *48 GR','388','UNILEVER ANDINA COLOMBIA','2025-04-30 17:28:34',  15944.49, 46759, 119, 53, 8652541)
			   ,('FVE','DB1','002277','2025-04-30 17:28:34','042025','CR','1129504297','CAMILO ANDR Eacute S','GIM Eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','5','74453.78151260504','14146.218487394955','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-30 17:36:47','88600','DB','DEPOSITO BARRANQUILLA','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','0','','30/04/2025','','0','0','88600','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:28:34',  6562.93617, 24473, 119, 53, 8652541)
			   ,('FVE','DB1','002277','2025-04-30 17:28:34','042025','CR','1129504297','CAMILO ANDR Eacute S','GIM Eacute NEZ RUIZ ','CRA 16 NO.65A-15 VILLA ESTADIO',' 3002547652','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','5','74453.78151260504','14146.218487394955','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-30 17:36:47','88600','DB','DEPOSITO BARRANQUILLA','1','21700.00000000','21700.00000000','18235.294117647','3464.7058823529','21700','1','0','0','','30/04/2025','','0','0','88600','7702006208093','DOVE TRATAMIENTO CAPILAR HAIR THERAPY * 270 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-30 17:28:34',  14831.9, 61808, 119, 53, 8652541)
			   ,('FVE','DB1','002276','2025-04-30 17:29:27','042025','CR','1143159055','JHOAN DAVID','BERDUGO DITTA','CALLE 37C 3 NO.1H-43',' 3116476074','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','5','53949.57983193278','10250.420168067223','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:36:02','64200','DB','DEPOSITO BARRANQUILLA','1','39500.00000000','39500.00000000','33193.277310924','6306.7226890756','39500','1','0','0','','30/04/2025','','0','0','64200','7702006653305','DOVE SHAMPOO + ACONDICIONADOR RECONSTRUCCION COMPLETA * 370 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-30 17:29:27',  24307.219971, 62321, 119, 53, 8652548)
			   ,('FVE','DB1','002276','2025-04-30 17:29:27','042025','CR','1143159055','JHOAN DAVID','BERDUGO DITTA','CALLE 37C 3 NO.1H-43',' 3116476074','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','5','53949.57983193278','10250.420168067223','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:36:02','64200','DB','DEPOSITO BARRANQUILLA','1','21700.00000000','21700.00000000','18235.294117647','3464.7058823529','21700','1','0','0','','30/04/2025','','0','0','64200','7702006208093','DOVE TRATAMIENTO CAPILAR HAIR THERAPY * 270 ML','388','UNILEVER ANDINA COLOMBIA','2025-04-30 17:29:27',  14831.9, 61808, 119, 53, 8652548)
			   ,('FVE','DB1','002276','2025-04-30 17:29:27','042025','CR','1143159055','JHOAN DAVID','BERDUGO DITTA','CALLE 37C 3 NO.1H-43',' 3116476074','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','5','53949.57983193278','10250.420168067223','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-04-30 17:36:02','64200','DB','DEPOSITO BARRANQUILLA','2','1500.00000000','3000.00000000','2521.0084033613','478.99159663866','3000','2','0','0','','30/04/2025','','0','0','64200','7702024007203','MORENITAS GALLETA * 24 GR','776','NESTLE FOOD & BEVERAGE','2025-04-30 17:29:27',  729, 38407, 119, 53, 8652548)
			   ,('FVE','DP1','022841','2025-04-30 17:29:51','042025','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','44369.747899159665','8430.252100840335','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','52800','50','DEPOSITO CUCUTA ','1','16400.00000000','16400.00000000','13781.512605042','2618.487394958','16400','1','0','1','','30/04/2025','','0','52800','0','7702035430090','LISTERINE CONTROL CALCULO * 180 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 17:29:51',  8841.288, 28021, 2, 19, 8652536)
			   ,('FVE','DP1','022841','2025-04-30 17:29:51','042025','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','44369.747899159665','8430.252100840335','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','52800','50','DEPOSITO CUCUTA ','1','15300.00000000','15300.00000000','12857.142857143','2442.8571428571','15300','1','0','1','','30/04/2025','','0','52800','0','7500435019958','H & S SHAMPO LIMPIEZA RENOV *180 ML','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 17:29:51',  10191.402, 53528, 2, 19, 8652536)
			   ,('FVE','DP1','022841','2025-04-30 17:29:51','042025','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','44369.747899159665','8430.252100840335','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','52800','50','DEPOSITO CUCUTA ','1','4800.00000000','4800.00000000','4033.6134453782','766.38655462185','4800','1','0','1','','30/04/2025','','0','52800','0','7702010470486','LADY SPEED STICK CLINICAL MINI POWDER CREMA * 30 GR','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:29:51',  2474.55, 53264, 2, 19, 8652536)
			   ,('FVE','DP1','022841','2025-04-30 17:29:51','042025','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','44369.747899159665','8430.252100840335','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','52800','50','DEPOSITO CUCUTA ','1','3800.00000000','3800.00000000','3193.2773109244','606.72268907563','3800','1','0','1','','30/04/2025','','0','52800','0','7702560041792','CREMA DENTAL FLUOCARDENT TRIPLE ACCION + CEPILLO * 50 ML','219','JGB','2025-04-30 17:29:51',  2610, 56092, 2, 19, 8652536)
			   ,('FVE','DP1','022841','2025-04-30 17:29:51','042025','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','44369.747899159665','8430.252100840335','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','52800','50','DEPOSITO CUCUTA ','1','7500.00000000','7500.00000000','6302.5210084034','1197.4789915966','7500','1','0','1','','30/04/2025','','0','52800','0','7702277082545','CORTAUÑAS GRANDE CURVO FSTYLE','124','BELLEZA EXPRESS SA','2025-04-30 17:29:51',  4088.5, 46816, 2, 19, 8652536)
			   ,('FVE','DP1','022841','2025-04-30 17:29:51','042025','CO','37441128','VIVIANA JASSMIN','SOLANO ESPINOSA','AV 8 # 2N-43 SAN MARTIN',' 3184715644','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','7','44369.747899159665','8430.252100840335','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','52800','50','DEPOSITO CUCUTA ','1','5000.00000000','5000.00000000','4201.6806722689','798.31932773109','5000','1','0','1','','30/04/2025','','0','52800','0','7702018072439','MAQ VENUS SIMPLY PINK ','336','PROCTER & GAMBLE COLOMBIA','2025-04-30 17:29:51',  3090.4227, 40129, 2, 19, 8652536)
			   ,('FVE','DP1','022842','2025-04-30 17:33:40','042025','CO','60379016','LUZ KARIME','BOTELLO CALDER oacute N','CALLE 15A NO.8-40 TIERRA LINDA',' 3124396518','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','20588.23529411765','3911.7647058823513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','24500','50','DEPOSITO CUCUTA ','1','12900.00000000','12900.00000000','10840.336134454','2059.6638655462','12900','1','0','1','','30/04/2025','','24500','0','0','7702502705300','MEXSANA TALCO * 85 GR','631','BAYER OTC','2025-04-30 17:33:40',  9180, 33174, 2, 19, 8652558)
			   ,('FVE','DP1','022842','2025-04-30 17:33:40','042025','CO','60379016','LUZ KARIME','BOTELLO CALDER oacute N','CALLE 15A NO.8-40 TIERRA LINDA',' 3124396518','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','20588.23529411765','3911.7647058823513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','24500','50','DEPOSITO CUCUTA ','1','3800.00000000','3800.00000000','3193.2773109244','606.72268907563','3800','1','0','1','','30/04/2025','','24500','0','0','7702560041792','CREMA DENTAL FLUOCARDENT TRIPLE ACCION + CEPILLO * 50 ML','219','JGB','2025-04-30 17:33:40',  2610, 56092, 2, 19, 8652558)
			   ,('FVE','DP1','022842','2025-04-30 17:33:40','042025','CO','60379016','LUZ KARIME','BOTELLO CALDER oacute N','CALLE 15A NO.8-40 TIERRA LINDA',' 3124396518','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','20588.23529411765','3911.7647058823513','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:34:37','24500','50','DEPOSITO CUCUTA ','1','7800.00000000','7800.00000000','6554.6218487395','1245.3781512605','7800','1','0','1','','30/04/2025','','24500','0','0','7702031132844','JOHNSON ACEITE ORIG * 50 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 17:33:40',  4891.5, 27936, 2, 19, 8652558)
			   ,('FVE','DP1','022848','2025-04-30 17:34:55','042025','CR','1090507448','KAREN','ASCANIO','AVENIDA 15 CALLE 12 BELISARIO ',' 3228296015','423','JOSï¿½ ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','12605.042016806723','2394.957983193277','00','DEPOSITO CUCUTA','J.VELEZ','2025-04-30 17:52:25','15000','50','DEPOSITO CUCUTA ','1','15000.00000000','15000.00000000','12605.042016807','2394.9579831933','15000','1','0','0','','30/04/2025','','0','0','15000','42277040','NIVEA C/FACIAL CUIDADO NUTRITIVO *50 ML','123','BDF (BEIERSDORF) ','2025-04-30 17:34:55',  7767.41247, 50790, 2, 19, 8652589)
			   ,('FVE','DP1','022843','2025-04-30 17:36:46','042025','CO','1093590959','JOHAN','RODRIGUEZ','CALLE 15 NO.10-01 LA LIBERTAD',' 3204057252','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','6302.5210084033615','1197.4789915966385','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','7500','50','DEPOSITO CUCUTA ','1','7500.00000000','7500.00000000','6302.5210084034','1197.4789915966','7500','1','0','1','','30/04/2025','','0','7500','0','7702031245223','NEKO JABON ALOE * 110 GR','221','JOHNSON Y JOHNSON DE COL SA','2025-04-30 17:36:46',  0, 28108, 2, 19, 8652587)
			   ,('FVE','DP1','022844','2025-04-30 17:37:53','042025','CO','1148214960','ERICKSSON GUSTAVO','VILLAMIZAR CORTEZ','CALLE 2 NO. 0A-22 BOCONO',' 3026897867','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','4453.781512605042','846.2184873949582','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','5300','50','DEPOSITO CUCUTA ','1','5300.00000000','5300.00000000','4453.781512605','846.21848739496','5300','1','0','1','','30/04/2025','','0','5300','0','7702010631382','COLGATE CREMA T/ACCION *50 ML + CEP PREMIER CLEAN','145','COLGATE PALMOLIVE COMPANIA','2025-04-30 17:37:53',  3375, 24465, 2, 19, 8652593)
			   ,('FVE','DP1','022845','2025-04-30 17:38:11','042025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','28991.596638655465','5508.403361344536','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','34500','50','DEPOSITO CUCUTA ','1','9000.00000000','9000.00000000','7563.025210084','1436.974789916','9000','1','0','0','','30/04/2025','','0','0','34500','7707194534153','MASGLO ESMALTE BRILLO SECANTE *13.5 ML','801','CERESCOS','2025-04-30 17:38:11',  6262.08, 55564, 2, 19, 8652608)
			   ,('FVE','DP1','022845','2025-04-30 17:38:11','042025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','28991.596638655465','5508.403361344536','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','34500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','30/04/2025','','0','0','34500','7707194530544','MASGLO ESMALTE NOVIA *13.5 ML','801','CERESCOS','2025-04-30 17:38:11',  5868.48, 55538, 2, 19, 8652608)
			   ,('FVE','DP1','022845','2025-04-30 17:38:11','042025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','28991.596638655465','5508.403361344536','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','34500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','30/04/2025','','0','0','34500','7707194530018','MASGLO ESMALTE TIZA *13.5 ML','801','CERESCOS','2025-04-30 17:38:11',  5868.48, 55546, 2, 19, 8652608)
			   ,('FVE','DP1','022845','2025-04-30 17:38:11','042025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','5','28991.596638655465','5508.403361344536','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','34500','50','DEPOSITO CUCUTA ','1','8500.00000000','8500.00000000','7142.8571428571','1357.1428571429','8500','1','0','0','','30/04/2025','','0','0','34500','7707363368527','MASGLO ESMALTE SOLIDARIA * 13.5 ML','801','CERESCOS','2025-04-30 17:38:11',  5657.28, 55674, 2, 19, 8652608)
			   ,('FVE','DP1','022847','2025-04-30 17:41:02','042025','CR','1092357026','BRANWDON XAMIR','MORANTES CASTRO','CRA 13 NO.4-35',' 3112893338','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','38900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','38900','50','DEPOSITO CUCUTA ','1','14900.00000000','14900.00000000','14900','0','14900','1','0','0','','30/04/2025','','0','0','38900','7441026003348','DOLEX BEBES 1-24 MESES FRAMBUESA * 60 ML','616','HALEON (GLAXO OTC)','2025-04-30 17:41:02',  13026.6, 54127, 2, 19, 8652635)
			   ,('FVE','DP1','022847','2025-04-30 17:41:02','042025','CR','1092357026','BRANWDON XAMIR','MORANTES CASTRO','CRA 13 NO.4-35',' 3112893338','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','3','38900','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','38900','50','DEPOSITO CUCUTA ','1','24000.00000000','24000.00000000','24000','0','24000','1','0','0','','30/04/2025','','0','0','38900','7707019334203','FUNGISTEROL SHAMPOO * 100 ML','130','LABQUIFAR PHARMACEUTICA','2025-04-30 17:41:02',  10327.5, 45856, 2, 19, 8652635)
			   ,('FVE','DP1','022846','2025-04-30 17:43:43','042025','CO','1092353617','GONZALO','SUAREZ FLOREZ','',' 3118366507','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','11000','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','11000','50','DEPOSITO CUCUTA ','1','11000.00000000','11000.00000000','11000','0','11000','1','0','1','','30/04/2025','','0','11000','0','7702184013564','COMPLEJO B * 30 TAB','249','ECAR','2025-04-30 17:43:43',  8148, 63745, 2, 19, 8652647)
			   ,('FVE','DP1','022849','2025-04-30 17:47:27','042025','CR','1005025850','ANGIE VALENTINA','FLORIAN SANTAFE','AVENIDA 2 NO.10-49 SAN LUIS',' 3024406222','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','26974.789915966387','5125.210084033613','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-04-30 17:52:25','32100','50','DEPOSITO CUCUTA ','1','32100.00000000','32100.00000000','26974.789915966','5125.2100840336','32100','1','0','0','','30/04/2025','','0','0','32100','7702502017700','MEXSANA TALCO * 300 GR + 85 GR PROMO','631','BAYER OTC','2025-04-30 17:47:27',  22670, 33173, 2, 19, 8652687)
			   ,('FVE','DB1','002278','2025-04-30 17:51:53','042025','CO','1003115092','KEINER RAFAEL','TORRES ALCINA','',' 3007450397','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','2','8500','0','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-04-30 17:51:53','8500','DB','DEPOSITO BARRANQUILLA','1','8500.00000000','8500.00000000','8500','0','8500','1','0','1','','30/04/2025','','0','8500','0','7709990751970','HIOSCINA BUTIL 20 MG + DIPIRONA 2.5 GR * 1 AMP','701','VITALIS COMERCIAL','2025-04-30 17:51:53',  6499, 56374, 119, 53, 8638762);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '042025' AND DECODBOD='00';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '042025' AND DECODBOD='00';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '042025' AND DECODBOD='00';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '042025' AND DECODBOD='00';
DELETE FROM consolida2 WHERE PERIODOESPE = '042025' AND CODSUCURSAL = '00';
