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','023907','2025-05-30 14:36:39','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:44:47','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','30/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:36:39',  0, 61074, 2, 19, 8790550)
			   ,('FVE','DP1','023908','2025-05-30 14:38:26','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:44:47','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','30/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:38:26',  0, 61074, 2, 19, 8790558)
			   ,('FVE','DP1','023909','2025-05-30 14:40:27','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:44:47','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','30/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:40:27',  0, 61074, 2, 19, 8790566)
			   ,('FVE','DP1','023910','2025-05-30 14:41:53','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:44:47','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','30/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:41:53',  0, 61074, 2, 19, 8790579)
			   ,('FVE','DP1','023911','2025-05-30 14:43:41','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:44:47','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:43:41',  0, 61074, 2, 19, 8790598)
			   ,('FVE','DP1','023912','2025-05-30 14:47:22','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:52:51','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','30/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:47:22',  0, 61074, 2, 19, 8790614)
			   ,('FVE','DP1','023913','2025-05-30 14:50:19','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:52:51','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:50:19',  0, 61074, 2, 19, 8790643)
			   ,('FVE','DP1','023914','2025-05-30 14:53:02','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:53:02','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:53:02',  0, 61074, 2, 19, 8790656)
			   ,('FVE','DP1','023915','2025-05-30 14:54:41','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:57:34','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','30/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:54:41',  0, 61074, 2, 19, 8790663)
			   ,('FVE','DP1','023916','2025-05-30 14:56:48','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:57:34','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','30/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:56:48',  0, 61074, 2, 19, 8790676)
			   ,('FVE','DP1','023917','2025-05-30 14:58:37','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 14:58:37','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','30/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 14:58:37',  0, 61074, 2, 19, 8790684)
			   ,('FVE','DP1','023918','2025-05-30 15:01:57','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:06:06','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','30/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:01:57',  0, 61074, 2, 19, 8790715)
			   ,('FVE','DP1','023919','2025-05-30 15:04:00','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:06:06','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','30/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:04:00',  0, 61074, 2, 19, 8790726)
			   ,('FVE','DP1','023920','2025-05-30 15:06:11','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:06:11','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','30/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:06:11',  0, 61074, 2, 19, 8790743)
			   ,('FVE','DP1','023923','2025-05-30 15:06:18','052025','CR','1092353617','GONZALO','SUAREZ FLOREZ','',' 3118366507','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','4','27900','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-30 15:10:38','27900','50','DEPOSITO CUCUTA ','1','27900.00000000','27900.00000000','27900','0','27900','1','0','0','','30/05/2025','','0','0','27900','7707210530541','FORZ CREMA * 30 GR ','256','GERCO','2025-05-30 15:06:18',  21588.75, 29849, 2, 19, 8790753)
			   ,('FVE','DP1','023922','2025-05-30 15:08:45','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:10:23','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:08:45',  0, 61074, 2, 19, 8790758)
			   ,('FVE','DP1','023921','2025-05-30 15:08:46','052025','CO','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','16400','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-05-30 15:08:46','16400','50','DEPOSITO CUCUTA ','1','16400.00000000','16400.00000000','16400','0','16400','1','0','1','','30/05/2025','','0','16400','0','7702057061265','OXIMETAZOLINA 0.05% NASAL ADULTOS * 15 ML','654','MK ETICOS CONVENIO','2025-05-30 15:08:46',  11058.4278, 43203, 2, 19, 8790555)
			   ,('FVE','DP1','023924','2025-05-30 15:10:58','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','10','871200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:10:58','871200','50','DEPOSITO CUCUTA ','9','96800.00000000','871200.00000000','871200','0','871200','9','0','0','','30/05/2025','','871200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:10:58',  0, 61074, 2, 19, 8790776)
			   ,('FVE','DP1','023925','2025-05-30 15:12:03','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:16:55','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','30/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:12:03',  0, 61074, 2, 19, 8790791)
			   ,('FVE','DP1','023926','2025-05-30 15:13:01','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:16:55','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:13:01',  0, 61074, 2, 19, 8790797)
			   ,('FVE','DP1','023927','2025-05-30 15:14:04','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:16:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:14:04',  0, 61074, 2, 19, 8790802)
			   ,('FVE','DP1','023928','2025-05-30 15:15:18','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:16:55','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','30/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:15:18',  0, 61074, 2, 19, 8790808)
			   ,('FVE','DP1','023929','2025-05-30 15:16:25','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','9','774400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:16:55','774400','50','DEPOSITO CUCUTA ','8','96800.00000000','774400.00000000','774400','0','774400','8','0','0','','30/05/2025','','774400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:16:25',  0, 61074, 2, 19, 8790819)
			   ,('FVE','DP1','023931','2025-05-30 15:18:16','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:18:16','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:18:16',  0, 61074, 2, 19, 8790833)
			   ,('FVE','DP1','023932','2025-05-30 15:19:51','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','10','871200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:20:22','871200','50','DEPOSITO CUCUTA ','9','96800.00000000','871200.00000000','871200','0','871200','9','0','0','','30/05/2025','','871200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:19:51',  0, 61074, 2, 19, 8790849)
			   ,('FVE','DP1','023933','2025-05-30 15:21:13','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:21:13','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:21:13',  0, 61074, 2, 19, 8790863)
			   ,('FVE','DP1','023934','2025-05-30 15:22:26','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:26:08','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:22:26',  0, 61074, 2, 19, 8790876)
			   ,('FVE','DP1','023935','2025-05-30 15:23:31','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','10','871200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:26:08','871200','50','DEPOSITO CUCUTA ','9','96800.00000000','871200.00000000','871200','0','871200','9','0','0','','30/05/2025','','871200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:23:31',  0, 61074, 2, 19, 8790881)
			   ,('FVE','DP1','023936','2025-05-30 15:24:30','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:26:08','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:24:30',  0, 61074, 2, 19, 8790887)
			   ,('FVE','DP1','023937','2025-05-30 15:25:48','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:26:08','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','30/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:25:48',  0, 61074, 2, 19, 8790895)
			   ,('FVE','DP1','023938','2025-05-30 15:37:01','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:38:01','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:37:01',  0, 61074, 2, 19, 8790957)
			   ,('FVE','DP1','023939','2025-05-30 15:38:37','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:38:37','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:38:37',  0, 61074, 2, 19, 8790962)
			   ,('FVE','DP1','023940','2025-05-30 15:40:27','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:40:38','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','30/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:40:27',  0, 61074, 2, 19, 8790974)
			   ,('FVE','DP1','023941','2025-05-30 15:43:11','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:43:11','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','30/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:43:11',  0, 61074, 2, 19, 8790981)
			   ,('FVE','DP1','023942','2025-05-30 15:44:23','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:44:23','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','30/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:44:23',  0, 61074, 2, 19, 8791000)
			   ,('FVE','DP1','023943','2025-05-30 15:45:45','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:45:52','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','30/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:45:45',  0, 61074, 2, 19, 8791011)
			   ,('FVE','DP1','023944','2025-05-30 15:46:50','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:48:58','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','30/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:46:50',  0, 61074, 2, 19, 8791018)
			   ,('FVE','DP1','023945','2025-05-30 15:48:24','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:48:58','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','30/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:48:24',  0, 61074, 2, 19, 8791034)
			   ,('FVE','DP1','023946','2025-05-30 15:49:30','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:49:30','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:49:30',  0, 61074, 2, 19, 8791041)
			   ,('FVE','DP1','023947','2025-05-30 15:51:04','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','10','871200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:54:37','871200','50','DEPOSITO CUCUTA ','9','96800.00000000','871200.00000000','871200','0','871200','9','0','0','','30/05/2025','','871200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:51:04',  0, 61074, 2, 19, 8791049)
				  ,('FVE','DP1','023948','2025-05-30 15:52:31','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:54:37','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','30/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:52:31',  0, 61074, 2, 19, 8791057);
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','023949','2025-05-30 15:53:35','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:54:37','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:53:35',  0, 61074, 2, 19, 8791065)
			   ,('FVE','DP1','023950','2025-05-30 15:54:35','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:54:37','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:54:35',  0, 61074, 2, 19, 8791070)
			   ,('FVE','DP1','023951','2025-05-30 15:56:20','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 15:56:20','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','30/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:56:20',  0, 61074, 2, 19, 8791074)
			   ,('FVE','DP1','023952','2025-05-30 15:58:00','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','9','774400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:05:25','774400','50','DEPOSITO CUCUTA ','8','96800.00000000','774400.00000000','774400','0','774400','8','0','0','','30/05/2025','','774400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:58:00',  0, 61074, 2, 19, 8791084)
			   ,('FVE','DP1','023953','2025-05-30 15:59:16','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:05:25','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 15:59:16',  0, 61074, 2, 19, 8791092)
			   ,('FVE','DP1','023954','2025-05-30 16:00:32','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:05:25','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','30/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:00:32',  0, 61074, 2, 19, 8791103)
			   ,('FVE','DP1','023955','2025-05-30 16:01:30','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:05:25','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:01:30',  0, 61074, 2, 19, 8791111)
			   ,('FVE','DP1','023956','2025-05-30 16:02:35','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:05:25','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:02:35',  0, 61074, 2, 19, 8791121)
			   ,('FVE','DP1','023957','2025-05-30 16:03:38','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:05:25','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','30/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:03:38',  0, 61074, 2, 19, 8791133)
			   ,('FVE','DP1','023958','2025-05-30 16:07:25','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:09:01','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','30/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:07:25',  0, 61074, 2, 19, 8791145)
			   ,('FVE','DP1','023959','2025-05-30 16:08:38','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:09:01','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','30/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:08:38',  0, 61074, 2, 19, 8791167)
			   ,('FVE','DP1','023960','2025-05-30 16:14:40','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:33:01','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','30/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:14:40',  0, 61074, 2, 19, 8791201)
			   ,('FVE','DP1','023961','2025-05-30 16:16:18','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:33:01','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','30/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:16:18',  0, 61074, 2, 19, 8791208)
			   ,('FVE','DB2','004226','2025-05-30 16:21:15','052025','CR','1065870246','ANDR eacute S FELIPE','PERALTA BUITRAGO','CRA 16C NO.60A-65 LA ESMERALDA',' 3042297170','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','11848.73949579832','2251.2605042016803','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-05-30 16:33:01','14100','DBU','DEPOSITO BUCARAMANGA','1','14100.00000000','14100.00000000','11848.739495798','2251.2605042017','14100','1','0','0','','30/05/2025','','0','0','14100','4005800137655','NIVEA CREMA *30 GR','123','BDF (BEIERSDORF) ','2025-05-30 16:21:15',  7409.68125, 23201, 426, 249, 8791245)
			   ,('FVE','DP1','023962','2025-05-30 16:26:31','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:33:01','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','30/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:26:31',  0, 61074, 2, 19, 8791271)
			   ,('FVE','DP1','023963','2025-05-30 16:28:20','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:33:01','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:28:20',  0, 61074, 2, 19, 8791279)
			   ,('FVE','DP1','023964','2025-05-30 16:29:40','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','10','871200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:33:01','871200','50','DEPOSITO CUCUTA ','9','96800.00000000','871200.00000000','871200','0','871200','9','0','0','','30/05/2025','','871200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:29:40',  0, 61074, 2, 19, 8791292)
			   ,('FVE','DP1','023965','2025-05-30 16:30:57','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:33:01','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','30/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:30:57',  0, 61074, 2, 19, 8791300)
			   ,('FVE','DP1','023966','2025-05-30 16:33:05','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:33:05','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:33:05',  0, 61074, 2, 19, 8791303)
			   ,('FVE','DP1','023967','2025-05-30 16:34:19','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:35:18','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:34:19',  0, 61074, 2, 19, 8791316)
			   ,('FVE','DP1','023968','2025-05-30 16:35:38','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:35:38','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','30/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:35:38',  0, 61074, 2, 19, 8791337)
			   ,('FVE','DP1','023969','2025-05-30 16:36:56','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','9','774400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:36:56','774400','50','DEPOSITO CUCUTA ','8','96800.00000000','774400.00000000','774400','0','774400','8','0','0','','30/05/2025','','774400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:36:56',  0, 61074, 2, 19, 8791345)
			   ,('FVE','DP1','023970','2025-05-30 16:37:51','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:42:20','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:37:51',  0, 61074, 2, 19, 8791359)
			   ,('FVE','DP1','023971','2025-05-30 16:39:02','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:42:20','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','30/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:39:02',  0, 61074, 2, 19, 8791375)
			   ,('FVE','DP1','023972','2025-05-30 16:40:35','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:42:20','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','30/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:40:35',  0, 61074, 2, 19, 8791390)
			   ,('FVE','DP1','023973','2025-05-30 16:41:29','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:42:20','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','30/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:41:29',  0, 61074, 2, 19, 8791420)
			   ,('FVE','DP1','023974','2025-05-30 16:43:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-30 16:43:10','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','30/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-30 16:43:10',  0, 61074, 2, 19, 8791428)
			   ,('FVE','DP1','023975','2025-05-30 16:51:38','052025','CO','1094046024','JOEL','OTALVAREZ','PALMERAS PARTE BAJA',' 3134607035','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','2','6500','0','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-05-30 16:51:38','6500','50','DEPOSITO CUCUTA ','1','6500.00000000','6500.00000000','6500','0','6500','1','0','1','','30/05/2025','','0','6500','0','7706569001467','CETIRIZINA 10 MG * 10 TAB','614','A.G. MEDICAMENTOS','2025-05-30 16:51:38',  2323.7, 31293, 2, 19, 8790845)
			   ,('FVE','DB1','002349','2025-05-30 17:27:26','052025','CR','1129532465','JESUS CAMILO','GARCIA GUTIERREZ','CALLE 136 NO.9-160 MANZANA 2 T',' 3245857827','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:06 am','','2','6890.756302521008','1309.2436974789916','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-05-31 09:08:53','8200','DB','DEPOSITO BARRANQUILLA','1','8200.00000000','8200.00000000','6890.756302521','1309.243697479','8200','1','0','0','','31/05/2025','','0','0','8200','7702090064209','GASEOSA PEPSI * 2.5 LT','192','POSTOBON GASEOSAS','2025-05-30 17:27:26',  4317.65, 58758, 119, 53, 8791806)
			   ,('FVE','DB1','002356','2025-05-30 17:34:37','052025','CR','1007891376','C eacute SAR LUIS','VASQUEZ MENDOZA','CRA 16 NO.22-30 GALAPA',' 3238451741','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:18 am','','4','13109.243697478993','2490.7563025210075','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-05-31 09:19:05','15600','DB','DEPOSITO BARRANQUILLA','1','2000.00000000','2000.00000000','1680.6722689076','319.32773109244','2000','1','0','0','','31/05/2025','','0','0','15600','7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2025-05-30 17:34:37',  1142.83, 60397, 119, 53, 8791858)
			   ,('FVE','DB1','002356','2025-05-30 17:34:37','052025','CR','1007891376','C eacute SAR LUIS','VASQUEZ MENDOZA','CRA 16 NO.22-30 GALAPA',' 3238451741','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:18 am','','4','13109.243697478993','2490.7563025210075','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-05-31 09:19:05','15600','DB','DEPOSITO BARRANQUILLA','1','7100.00000000','7100.00000000','5966.3865546218','1133.6134453782','7100','1','0','0','','31/05/2025','','0','0','15600','7702535024423','COCA COLA * 1.5 LT','144','COCA COLA','2025-05-30 17:34:37',  4127, 56142, 119, 53, 8791858)
			   ,('FVE','DB1','002356','2025-05-30 17:34:37','052025','CR','1007891376','C eacute SAR LUIS','VASQUEZ MENDOZA','CRA 16 NO.22-30 GALAPA',' 3238451741','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:18 am','','4','13109.243697478993','2490.7563025210075','DB','DEPOSITO BARRANQUILLA','LIDERBODEGABQ','2025-05-31 09:19:05','15600','DB','DEPOSITO BARRANQUILLA','1','6500.00000000','6500.00000000','5462.1848739496','1037.8151260504','6500','1','0','0','','31/05/2025','','0','0','15600','7702090064186','GASEOSA MANZANA * 2.5 LT','192','POSTOBON GASEOSAS','2025-05-30 17:34:37',  4318.5, 56646, 119, 53, 8791858)
			   ,('FVE','DB1','002348','2025-05-30 18:45:38','052025','CO','1001782737','BRAYAN ENRIQUE','POLO MURILLO','CALLE 50B NO.3A-09 SOLEDAD',' 3013130195','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','12311.344537815126','638.6554621848736','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-05-30 19:24:26','12950','DB','DEPOSITO BARRANQUILLA','1','8950.00000000','8950.00000000','8950','0','8950','1','0','1','','31/05/2025','','0','12950','0','7502316493284','ELECTROLIT PONCHE DE FRUTAS *625 ML','780','PISA (SUEROS LIQUIDOS)','2025-05-30 18:45:38',  7200, 64997, 119, 53, 8792263)
			   ,('FVE','DB1','002348','2025-05-30 18:45:38','052025','CO','1001782737','BRAYAN ENRIQUE','POLO MURILLO','CALLE 50B NO.3A-09 SOLEDAD',' 3013130195','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','','','','4','12311.344537815126','638.6554621848736','DB','DEPOSITO BARRANQUILLA','AUXAUDITOR14','2025-05-30 19:24:26','12950','DB','DEPOSITO BARRANQUILLA','2','2000.00000000','4000.00000000','3361.3445378151','638.65546218487','4000','2','0','1','','31/05/2025','','0','12950','0','7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2025-05-30 18:45:38',  1142.83, 60397, 119, 53, 8792263)
			   ,('FVE','DP1','023976','2025-05-31 08:05:46','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:05:46','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:05:46',  0, 61074, 2, 19, 8793115)
			   ,('FVE','DP1','023977','2025-05-31 08:05:50','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:05:50','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:05:50',  0, 61074, 2, 19, 8793116)
			   ,('FVE','DP1','023978','2025-05-31 08:06:06','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:06:06','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:06:06',  0, 61074, 2, 19, 8793117)
			   ,('FVE','DP1','023979','2025-05-31 08:06:08','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:06:08','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:06:08',  0, 61074, 2, 19, 8793118)
			   ,('FVE','DP1','023980','2025-05-31 08:06:08','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:06:08','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:06:08',  0, 61074, 2, 19, 8793119)
			   ,('FVE','DP1','023981','2025-05-31 08:06:28','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:06:28','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:06:28',  0, 61074, 2, 19, 8793120)
				  ,('FVE','DP1','023982','2025-05-31 08:09:25','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','9','774400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:09:25','774400','50','DEPOSITO CUCUTA ','8','96800.00000000','774400.00000000','774400','0','774400','8','0','0','','31/05/2025','','774400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:09:25',  0, 61074, 2, 19, 8793153);
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','023983','2025-05-31 08:20:51','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:20:51','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:20:51',  0, 61074, 2, 19, 8793181)
			   ,('FVE','DP1','023984','2025-05-31 08:22:48','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:22:58','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:22:48',  0, 61074, 2, 19, 8793242)
			   ,('FVE','DP1','023985','2025-05-31 08:23:15','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:15','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:15',  0, 61074, 2, 19, 8793167)
			   ,('FVE','DP1','023986','2025-05-31 08:23:18','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:18','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:18',  0, 61074, 2, 19, 8793168)
			   ,('FVE','DP1','023987','2025-05-31 08:23:21','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:21','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:21',  0, 61074, 2, 19, 8793169)
			   ,('FVE','DP1','023988','2025-05-31 08:23:25','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:25','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:25',  0, 61074, 2, 19, 8793170)
			   ,('FVE','DP1','023989','2025-05-31 08:23:26','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:26','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:26',  0, 61074, 2, 19, 8793172)
			   ,('FVE','DP1','023990','2025-05-31 08:23:30','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:30','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:30',  0, 61074, 2, 19, 8793173)
			   ,('FVE','DP1','023991','2025-05-31 08:23:32','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:32','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:32',  0, 61074, 2, 19, 8793174)
			   ,('FVE','DP1','023992','2025-05-31 08:23:39','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:23:39','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:23:39',  0, 61074, 2, 19, 8793175)
			   ,('FVE','DP1','023993','2025-05-31 08:24:20','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:28:18','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:24:20',  0, 61074, 2, 19, 8793265)
			   ,('FVE','DP1','023994','2025-05-31 08:26:45','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:28:18','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:26:45',  0, 61074, 2, 19, 8793273)
			   ,('FVE','DP1','023995','2025-05-31 08:29:05','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:29:05','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:29:05',  0, 61074, 2, 19, 8793288)
			   ,('FVE','DP1','023996','2025-05-31 08:31:58','052025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','13','103976.19047619047','3523.8095238095266','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-05-31 08:31:58','107500','50','DEPOSITO CUCUTA ','1','74000.00000000','74000.00000000','70476.19047619','3523.8095238095','74000','1','0','1','','31/05/2025','','0','107500','0','5000289925440','GORDONS DRY GIN * 700 ML','827','MEICO LICORES','2025-05-31 08:31:58',  0, 57099, 2, 19, 8725934)
			   ,('FVE','DP1','023996','2025-05-31 08:31:58','052025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','13','103976.19047619047','3523.8095238095266','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-05-31 08:31:58','107500','50','DEPOSITO CUCUTA ','10','1500.00000000','15000.00000000','15000','0','15000','0','10','1','','31/05/2025','','0','107500','0','7707397790356','DOLEX ACTIVGEL * 20 CAP','616','HALEON (GLAXO OTC)','2025-05-31 08:31:58',  26059.5, 57296, 2, 19, 8725934)
			   ,('FVE','DP1','023996','2025-05-31 08:31:58','052025','CO','72260401','JOHN JAIRO','DURAN GOMEZ','AVENIDA 7A # 0BN-38 BARRIO SEV','5781240 3168777004','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','13','103976.19047619047','3523.8095238095266','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-05-31 08:31:58','107500','50','DEPOSITO CUCUTA ','1','18500.00000000','18500.00000000','18500','0','18500','1','0','1','','31/05/2025','','0','107500','0','7702184530023','ATLETICS GEL * 60 GR ','249','ECAR','2025-05-31 08:31:58',  6305, 58868, 2, 19, 8725934)
			   ,('FVE','DP1','023997','2025-05-31 08:31:58','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:38:56','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:31:58',  0, 61074, 2, 19, 8793309)
			   ,('FVE','DP1','023998','2025-05-31 08:34:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:38:56','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:34:10',  0, 61074, 2, 19, 8793323)
			   ,('FVE','DP1','023999','2025-05-31 08:36:16','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','5','387200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:38:56','387200','50','DEPOSITO CUCUTA ','4','96800.00000000','387200.00000000','387200','0','387200','4','0','0','','31/05/2025','','387200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:36:16',  0, 61074, 2, 19, 8793336)
			   ,('FVE','DP1','024000','2025-05-31 08:40:49','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:58:17','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:40:49',  0, 61074, 2, 19, 8793352)
			   ,('FVE','DP1','024001','2025-05-31 08:46:16','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:58:17','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:46:16',  0, 61074, 2, 19, 8793364)
			   ,('FVE','DP1','024002','2025-05-31 08:49:52','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:58:17','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:49:52',  0, 61074, 2, 19, 8793394)
			   ,('FVE','DP1','024003','2025-05-31 08:51:27','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:58:17','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:51:27',  0, 61074, 2, 19, 8793403)
			   ,('FVE','DP1','024004','2025-05-31 08:53:31','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:58:17','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:31',  0, 61074, 2, 19, 8793423)
			   ,('FVE','DP1','024005','2025-05-31 08:53:37','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:58:17','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:37',  0, 61074, 2, 19, 8793411)
			   ,('FVE','DP1','024006','2025-05-31 08:53:41','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:53:41','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:41',  0, 61074, 2, 19, 8793326)
			   ,('FVE','DP1','024007','2025-05-31 08:53:46','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:53:46','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:46',  0, 61074, 2, 19, 8793328)
			   ,('FVE','DP1','024008','2025-05-31 08:53:47','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:58:17','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:47',  0, 61074, 2, 19, 8793404)
			   ,('FVE','DP1','024009','2025-05-31 08:53:48','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:58:17','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:48',  0, 61074, 2, 19, 8793405)
			   ,('FVE','DP1','024010','2025-05-31 08:53:54','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:58:17','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:54',  0, 61074, 2, 19, 8793407)
			   ,('FVE','DP1','024011','2025-05-31 08:53:57','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:58:17','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:53:57',  0, 61074, 2, 19, 8793408)
			   ,('FVE','DP1','024012','2025-05-31 08:54:00','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 08:58:17','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:54:00',  0, 61074, 2, 19, 8793409)
			   ,('FVE','DP1','024013','2025-05-31 08:56:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:58:17','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:56:10',  0, 61074, 2, 19, 8793442)
			   ,('FVE','DP1','024014','2025-05-31 08:58:02','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 08:58:17','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 08:58:02',  0, 61074, 2, 19, 8793453)
			   ,('FVE','DP1','024015','2025-05-31 09:07:07','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:07:07',  0, 61074, 2, 19, 8793475)
			   ,('FVE','DP1','024016','2025-05-31 09:07:18','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:07:18',  0, 61074, 2, 19, 8793476)
			   ,('FVE','DP1','024017','2025-05-31 09:07:29','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:07:29',  0, 61074, 2, 19, 8793477)
			   ,('FVE','DP1','024018','2025-05-31 09:07:33','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:07:33',  0, 61074, 2, 19, 8793480)
			   ,('FVE','DP1','024019','2025-05-31 09:07:35','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:07:35',  0, 61074, 2, 19, 8793478)
			   ,('FVE','DB2','004228','2025-05-31 09:07:54','052025','CR','1004360497','WENDY CAROLINA','TERNERA URIELES','CALLE 37 NO.29B-264',' 3229277162','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','19800','0','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-05-31 09:12:55','19800','DBU','DEPOSITO BUCARAMANGA','1','19800.00000000','19800.00000000','19800','0','19800','1','0','0','','31/05/2025','','0','0','19800','7707019344202','NITOXIPAR 500 MG * 6 TAB','130','LABQUIFAR PHARMACEUTICA','2025-05-31 09:07:54',  15000, 23597, 426, 249, 8793525)
				  ,('FVE','DP1','024020','2025-05-31 09:10:02','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:10:02',  0, 61074, 2, 19, 8793481);
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','024021','2025-05-31 09:10:08','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:10:08',  0, 61074, 2, 19, 8793488)
			   ,('FVE','DP1','024022','2025-05-31 09:10:17','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:12:55','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:10:17',  0, 61074, 2, 19, 8793489)
			   ,('FVE','DP1','024024','2025-05-31 09:19:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:19:10','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:19:10',  0, 61074, 2, 19, 8793540)
			   ,('FVE','DP1','024025','2025-05-31 09:19:15','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:19:15','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:19:15',  0, 61074, 2, 19, 8793541)
			   ,('FVE','DP1','024026','2025-05-31 09:19:20','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:19:20','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:19:20',  0, 61074, 2, 19, 8793548)
			   ,('FVE','DP1','024023','2025-05-31 09:19:37','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','43','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 09:19:37','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:19:37',  0, 61074, 2, 19, 8793553)
			   ,('FVE','DP1','024027','2025-05-31 09:20:18','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','2','96800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','96800','50','DEPOSITO CUCUTA ','1','96800.00000000','96800.00000000','96800','0','96800','1','0','0','','31/05/2025','','96800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:20:18',  0, 61074, 2, 19, 8793568)
			   ,('FVE','DP1','024028','2025-05-31 09:22:00','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:22:00',  0, 61074, 2, 19, 8793591)
			   ,('FVE','DP1','024029','2025-05-31 09:23:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:23:10',  0, 61074, 2, 19, 8793594)
			   ,('FVE','DP1','024030','2025-05-31 09:24:50','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:24:50',  0, 61074, 2, 19, 8793600)
			   ,('FVE','DP1','024031','2025-05-31 09:27:54','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:27:54',  0, 61074, 2, 19, 8793611)
			   ,('FVE','DP1','024032','2025-05-31 09:29:28','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:29:28',  0, 61074, 2, 19, 8793629)
			   ,('FVE','DP1','024033','2025-05-31 09:31:23','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:31:23',  0, 61074, 2, 19, 8793632)
			   ,('FVE','DB1','002366','2025-05-31 09:32:36','052025','CR','1143148098','CARLOS JAVIER','AHUMADA BOH oacute RQUEZ','BARRIO CARRIZAL',' 3244537634','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:34 am','','2','2200','0','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','2200','DB','DEPOSITO BARRANQUILLA','1','2200.00000000','2200.00000000','2200','0','2200','1','0','0','','31/05/2025','','0','0','2200','7709008052563','AGUA FARMANORTE * 600 ML','893','SALUS','2025-05-31 09:32:36',  938.75, 48019, 119, 53, 8793651)
			   ,('FVE','DP1','024034','2025-05-31 09:32:40','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:32:40',  0, 61074, 2, 19, 8793644)
			   ,('FVE','DB1','002367','2025-05-31 09:34:54','052025','CR','1143265157','LUIS JESUS','ORTIZ RAMIREZ','CRA 85 NO.129-27 CIUDAD CARIBE',' 3024387336','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:41 am','','2','5762.18487394958','1037.81512605042','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','6800','DB','DEPOSITO BARRANQUILLA','1','300.00000000','300.00000000','300','0','300','1','0','0','','31/05/2025','','0','0','6800','BOLSAX','BOLSAS PLASTICAS','00','VARIOS','2025-05-31 09:34:54',  0, 44347, 119, 53, 8793663)
			   ,('FVE','DB1','002367','2025-05-31 09:34:54','052025','CR','1143265157','LUIS JESUS','ORTIZ RAMIREZ','CRA 85 NO.129-27 CIUDAD CARIBE',' 3024387336','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:41 am','','2','5762.18487394958','1037.81512605042','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','6800','DB','DEPOSITO BARRANQUILLA','1','6500.00000000','6500.00000000','5462.1848739496','1037.8151260504','6500','1','0','0','','31/05/2025','','0','0','6800','7702090064186','GASEOSA MANZANA * 2.5 LT','192','POSTOBON GASEOSAS','2025-05-31 09:34:54',  4318.49, 56646, 119, 53, 8793663)
			   ,('FVE','DP1','024035','2025-05-31 09:37:24','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:37:24',  0, 61074, 2, 19, 8793649)
			   ,('FVE','DP1','024036','2025-05-31 09:37:29','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:37:29',  0, 61074, 2, 19, 8793646)
			   ,('FVE','DP1','024037','2025-05-31 09:37:38','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:37:38',  0, 61074, 2, 19, 8793647)
			   ,('FVE','DP1','024038','2025-05-31 09:37:41','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:37:41',  0, 61074, 2, 19, 8793648)
			   ,('FVE','DB1','002368','2025-05-31 09:41:59','052025','CR','1143265157','LUIS JESUS','ORTIZ RAMIREZ','CRA 85 NO.129-27 CIUDAD CARIBE',' 3024387336','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:46 am','','2','5966.386554621849','1133.6134453781506','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','7100','DB','DEPOSITO BARRANQUILLA','1','7100.00000000','7100.00000000','5966.3865546218','1133.6134453782','7100','1','0','0','','31/05/2025','','0','0','7100','7702535024423','COCA COLA * 1.5 LT','144','COCA COLA','2025-05-31 09:41:59',  4126.6666, 56142, 119, 53, 8793711)
			   ,('FVE','DP1','024039','2025-05-31 09:43:25','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:43:25',  0, 61074, 2, 19, 8793713)
			   ,('FVE','DP1','024040','2025-05-31 09:45:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:45:10',  0, 61074, 2, 19, 8793694)
			   ,('FVE','DP1','024041','2025-05-31 09:45:13','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:45:13',  0, 61074, 2, 19, 8793691)
			   ,('FVE','DP1','024042','2025-05-31 09:45:17','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:45:17',  0, 61074, 2, 19, 8793680)
			   ,('FVE','DP1','024043','2025-05-31 09:45:19','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:45:19',  0, 61074, 2, 19, 8793681)
			   ,('FVE','DP1','024044','2025-05-31 09:45:38','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:45:38',  0, 61074, 2, 19, 8793685)
			   ,('FVE','DP1','024045','2025-05-31 09:45:42','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:45:42',  0, 61074, 2, 19, 8793688)
			   ,('FVE','DP1','024046','2025-05-31 09:45:54','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 10:00:24','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:45:54',  0, 61074, 2, 19, 8793689)
			   ,('FVE','DB1','002369','2025-05-31 09:46:49','052025','CR','1063717149','DEIVI LUIS','DIAZ ARROYO','CRA 8A NO.42-34 VILLADELA',' 3024691465','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:53 am','','5','10756.302521008403','2043.6974789915967','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','12800','DB','DEPOSITO BARRANQUILLA','3','3600.00000000','10800.00000000','9075.6302521008','1724.3697478992','10800','3','0','0','','31/05/2025','','0','0','12800','7702535011089,7','COCA COLA *400 ML','144','COCA COLA','2025-05-31 09:46:49',  1994.6666, 34397, 119, 53, 8793745)
			   ,('FVE','DB1','002369','2025-05-31 09:46:49','052025','CR','1063717149','DEIVI LUIS','DIAZ ARROYO','CRA 8A NO.42-34 VILLADELA',' 3024691465','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:53 am','','5','10756.302521008403','2043.6974789915967','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','12800','DB','DEPOSITO BARRANQUILLA','1','2000.00000000','2000.00000000','1680.6722689076','319.32773109244','2000','1','0','0','','31/05/2025','','0','0','12800','7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2025-05-31 09:46:49',  1142.833, 60397, 119, 53, 8793745)
			   ,('FVE','DP1','024047','2025-05-31 09:47:52','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:47:52',  0, 61074, 2, 19, 8793733)
			   ,('FVE','DP1','024048','2025-05-31 09:50:25','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:50:25',  0, 61074, 2, 19, 8793763)
			   ,('FVE','DB1','002370','2025-05-31 09:55:00','052025','CR','1046695022','JOINNER','OSPINO RODR iacute GUEZ','CALLE 81 NO.11-70',' 3043371697','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:59 am','','3','7647.058823529413','1452.9411764705874','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','9100','DB','DEPOSITO BARRANQUILLA','1','2000.00000000','2000.00000000','1680.6722689076','319.32773109244','2000','1','0','0','','31/05/2025','','0','0','9100','7702535022054','JUGO DEL VALLE FRUTAS CITRICAS *400 ML','144','COCA COLA','2025-05-31 09:55:00',  1142.833, 60397, 119, 53, 8793808)
			   ,('FVE','DB1','002370','2025-05-31 09:55:00','052025','CR','1046695022','JOINNER','OSPINO RODR iacute GUEZ','CALLE 81 NO.11-70',' 3043371697','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 9:59 am','','3','7647.058823529413','1452.9411764705874','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 10:00:24','9100','DB','DEPOSITO BARRANQUILLA','1','7100.00000000','7100.00000000','5966.3865546218','1133.6134453782','7100','1','0','0','','31/05/2025','','0','0','9100','7702535024423','COCA COLA * 1.5 LT','144','COCA COLA','2025-05-31 09:55:00',  4126.6666, 56142, 119, 53, 8793808)
			   ,('FVE','DP1','024049','2025-05-31 09:55:22','052025','CO','1091679143','ADRIAN CAMILO','VERGEL MELO','CRA 29 NO.10-10',' 3205730652','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','32941.17647058824','6258.823529411762','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:00:24','39200','50','DEPOSITO CUCUTA ','1','39200.00000000','39200.00000000','32941.176470588','6258.8235294118','39200','1','0','1','','31/05/2025','','0','39200','0','7702113682335','DEO PIES SPRAY ANTIBACTERIAL  X 260 ML 2X1','278','RECAMIER','2025-05-31 09:55:22',  24932.88, 51168, 2, 19, 8793799)
			   ,('FVE','DP1','024050','2025-05-31 09:59:09','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:00:24','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 09:59:09',  0, 61074, 2, 19, 8793792)
			   ,('FVE','DP1','024051','2025-05-31 10:01:53','052025','CO','1090438621','SERGIO GABRIEL','PAEZ APONTE','CALLE 21 A NO.69 SAN MARTIN',' 3174246376','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','20504.20168067227','3895.7983193277296','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:02:33','24400','50','DEPOSITO CUCUTA ','1','5200.00000000','5200.00000000','4369.7478991597','830.25210084034','5200','1','0','0','','31/05/2025','','0','24400','0','7702045200324','BALANCE CLINICAL CREMA MINI  WOMEN * 30 GR','203','HENKEL COLOMBIANA','2025-05-31 10:01:53',  2888, 52774, 2, 19, 8793821)
			   ,('FVE','DP1','024051','2025-05-31 10:01:53','052025','CO','1090438621','SERGIO GABRIEL','PAEZ APONTE','CALLE 21 A NO.69 SAN MARTIN',' 3174246376','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','20504.20168067227','3895.7983193277296','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:02:33','24400','50','DEPOSITO CUCUTA ','1','19200.00000000','19200.00000000','16134.453781513','3065.5462184874','19200','1','0','0','','31/05/2025','','0','24400','0','7702277327721','TOALLITAS HUMEDAS ARRURRU ALOE * 190 UND','124','BELLEZA EXPRESS SA','2025-05-31 10:01:53',  10268, 64730, 2, 19, 8793821)
				  ,('FVE','DP1','024052','2025-05-31 10:06:43','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:19:30','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:06:43',  0, 61074, 2, 19, 8793837);
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','024053','2025-05-31 10:07:18','052025','CO','1091384385','LUIS JESUS','SIERRA MOROS','CALLE 4 CRA 11 BARRIO JOSE FEL',' 3203764959','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','21400','0','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','21400','50','DEPOSITO CUCUTA ','1','17100.00000000','17100.00000000','17100','0','17100','1','0','1','','31/05/2025','','0','21400','0','7703451000010','SOREL LOCION * 120 ML','249','ECAR','2025-05-31 10:07:18',  13677, 31139, 2, 19, 8793838)
			   ,('FVE','DP1','024053','2025-05-31 10:07:18','052025','CO','1091384385','LUIS JESUS','SIERRA MOROS','CALLE 4 CRA 11 BARRIO JOSE FEL',' 3203764959','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','21400','0','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','21400','50','DEPOSITO CUCUTA ','1','4300.00000000','4300.00000000','4300','0','4300','0','1','1','','31/05/2025','','0','21400','0','7707210530114','FORZ CREMA * 24 S/S','256','GERCO','2025-05-31 10:07:18',  45714.89376, 46090, 2, 19, 8793838)
			   ,('FVE','DP1','024054','2025-05-31 10:09:35','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:19:30','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:09:35',  0, 61074, 2, 19, 8793856)
			   ,('FVE','DP1','024055','2025-05-31 10:10:53','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:19:30','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:10:53',  0, 61074, 2, 19, 8793866)
			   ,('FVE','DP1','024056','2025-05-31 10:11:30','052025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','5','62605.04201680672','11894.957983193273','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','74500','50','DEPOSITO CUCUTA ','1','25300.00000000','25300.00000000','21260.504201681','4039.4957983193','25300','1','0','1','','31/05/2025','','0','74500','0','7707263005713','AGUA MICELAR ACED PIEL * 230 ML','387','TRIDEX FARMACEUTICA','2025-05-31 10:11:30',  9853, 62208, 2, 19, 8793857)
			   ,('FVE','DP1','024056','2025-05-31 10:11:30','052025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','5','62605.04201680672','11894.957983193273','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','74500','50','DEPOSITO CUCUTA ','1','12900.00000000','12900.00000000','10840.336134454','2059.6638655462','12900','1','0','1','','31/05/2025','','0','74500','0','7702502705300','MEXSANA TALCO * 85 GR','631','BAYER OTC','2025-05-31 10:11:30',  9180, 33174, 2, 19, 8793857)
			   ,('FVE','DP1','024056','2025-05-31 10:11:30','052025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','5','62605.04201680672','11894.957983193273','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','74500','50','DEPOSITO CUCUTA ','1','10500.00000000','10500.00000000','8823.5294117647','1676.4705882353','10500','1','0','1','','31/05/2025','','0','74500','0','7702006298926','EGO GEL FOR MEN ATTRACTION * 240 ML','388','UNILEVER ANDINA COLOMBIA','2025-05-31 10:11:30',  6470.8164, 54211, 2, 19, 8793857)
			   ,('FVE','DP1','024056','2025-05-31 10:11:30','052025','CO','1125758057','CARLOS ANDRES','VILLAMIZAR PALENCIA','AV 11A NO.16-21 EL CONTENTO',' 3133133686','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','5','62605.04201680672','11894.957983193273','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','74500','50','DEPOSITO CUCUTA ','1','25800.00000000','25800.00000000','21680.672268908','4119.3277310924','25800','1','0','1','','31/05/2025','','0','74500','0','7891150089983','REXONA CLINICAL INTENSE FRESH AEROSOL * 150 ML ','388','UNILEVER ANDINA COLOMBIA','2025-05-31 10:11:30',  16185.1581, 63963, 2, 19, 8793857)
			   ,('FVE','DP1','024057','2025-05-31 10:12:47','052025','CO','1093795610','ADRIANA GICELA','PE Atilde  plusmn ARANDA ROJAS','AV 13 # 16-15 LA LIBERTAD-CUCU',' 3134507750','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','14705.882352941177','2794.1176470588234','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:19:30','17500','50','DEPOSITO CUCUTA ','1','17500.00000000','17500.00000000','14705.882352941','2794.1176470588','17500','1','0','1','','31/05/2025','','0','17500','0','7702031036746','JOHNSON CREMA LIQ ANTES DE DORMIR * 200 ML','221','JOHNSON Y JOHNSON DE COL SA','2025-05-31 10:12:47',  9878.64552, 27997, 2, 19, 8793864)
			   ,('FVE','DP1','024058','2025-05-31 10:13:02','052025','CO','1090466899','DEIVER FABI aacute N','TORRES MIRANDA','CALLE 13 SUR AV 7 K 111-16 BAR',' 3013680911','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','20525.210084033613','2474.7899159663866','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','23000','50','DEPOSITO CUCUTA ','1','7500.00000000','7500.00000000','7500','0','7500','1','0','1','','31/05/2025','','23000','0','0','7702136649520','CUREBAND MICROPORE PIEL 1 * 10 YARDAS','624','TECNOQUIMICAS CUIDADO DE HERIDA','2025-05-31 10:13:02',  6221.9775, 45306, 2, 19, 8793878)
			   ,('FVE','DP1','024058','2025-05-31 10:13:02','052025','CO','1090466899','DEIVER FABI aacute N','TORRES MIRANDA','CALLE 13 SUR AV 7 K 111-16 BAR',' 3013680911','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','3','20525.210084033613','2474.7899159663866','00','DEPOSITO CUCUTA','1090521222','2025-05-31 10:19:30','23000','50','DEPOSITO CUCUTA ','1','15500.00000000','15500.00000000','13025.210084034','2474.7899159664','15500','1','0','1','','31/05/2025','','23000','0','0','099176480310','COLGATE CREMA DENTAL TOTAL 12 CLEAN MINT *75 ML','145','COLGATE PALMOLIVE COMPANIA','2025-05-31 10:13:02',  6949.8, 24473, 2, 19, 8793878)
			   ,('FVE','DP1','024059','2025-05-31 10:13:11','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:19:30','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:13:11',  0, 61074, 2, 19, 8793880)
			   ,('FVE','DP1','024060','2025-05-31 10:18:27','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:19:30','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:18:27',  0, 61074, 2, 19, 8793888)
			   ,('FVE','DP1','024061','2025-05-31 10:39:14','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:42:08','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:39:14',  0, 61074, 2, 19, 8793924)
			   ,('FVE','DP1','024062','2025-05-31 10:40:24','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:42:08','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:40:24',  0, 61074, 2, 19, 8793925)
			   ,('FVE','DP1','024063','2025-05-31 10:41:16','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:42:08','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:41:16',  0, 61074, 2, 19, 8793926)
			   ,('FVE','DP1','024064','2025-05-31 10:42:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:42:10','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:42:10',  0, 61074, 2, 19, 8793928)
			   ,('FVE','DP1','024065','2025-05-31 10:43:44','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:43:44','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:43:44',  0, 61074, 2, 19, 8793930)
			   ,('FVE','DP1','024066','2025-05-31 10:44:31','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:44:31','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:44:31',  0, 61074, 2, 19, 8793932)
			   ,('FVE','DP1','024067','2025-05-31 10:45:14','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:48:14','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:45:14',  0, 61074, 2, 19, 8793935)
			   ,('FVE','DP1','024074','2025-05-31 10:49:51','052025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','8','108214.28571428572','20560.71428571428','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:57:14','128775','50','DEPOSITO CUCUTA ','1','27100.00000000','27100.00000000','22773.109243697','4326.8907563025','27100','1','0','0','','31/05/2025','','0','0','128775','7509552847499','ELVIVE SHAMPOO COLOR VIVE * 370 ML','292','LOREAL COLOMBIA','2025-05-31 10:49:51',  18718, 65203, 2, 19, 8793943)
			   ,('FVE','DP1','024074','2025-05-31 10:49:51','052025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','8','108214.28571428572','20560.71428571428','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:57:14','128775','50','DEPOSITO CUCUTA ','2','4800.00000000','9600.00000000','8067.2268907563','1532.7731092437','9600','2','0','0','','31/05/2025','','0','0','128775','7702010470486','LADY SPEED STICK CLINICAL MINI POWDER CREMA * 30 GR','145','COLGATE PALMOLIVE COMPANIA','2025-05-31 10:49:51',  2474.55, 53264, 2, 19, 8793943)
			   ,('FVE','DP1','024074','2025-05-31 10:49:51','052025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','8','108214.28571428572','20560.71428571428','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:57:14','128775','50','DEPOSITO CUCUTA ','1','35800.00000000','35800.00000000','30084.033613445','5715.9663865546','35800','1','0','0','','31/05/2025','','0','0','128775','7509552928563','ELVIVE GLYCOLIC GLOSS TRATAMIENTO CAPILAR * 200 ML','292','LOREAL COLOMBIA','2025-05-31 10:49:51',  0, 65549, 2, 19, 8793943)
			   ,('FVE','DP1','024074','2025-05-31 10:49:51','052025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','8','108214.28571428572','20560.71428571428','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:57:14','128775','50','DEPOSITO CUCUTA ','1','12900.00000000','12900.00000000','10840.336134454','2059.6638655462','12900','1','0','0','','31/05/2025','','0','0','128775','7702502705300','MEXSANA TALCO * 85 GR','631','BAYER OTC','2025-05-31 10:49:51',  9180, 33174, 2, 19, 8793943)
			   ,('FVE','DP1','024074','2025-05-31 10:49:51','052025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','8','108214.28571428572','20560.71428571428','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:57:14','128775','50','DEPOSITO CUCUTA ','1','6375.00000000','6375.00000000','5357.1428571429','1017.8571428571','6375','1','0','0','','31/05/2025','','0','0','128775','7707773834728','MASGLO ESMALTE BASE ANTIESCAMACION *13.5 ML','801','CERESCOS','2025-05-31 10:49:51',  5868.48, 55557, 2, 19, 8793943)
			   ,('FVE','DP1','024074','2025-05-31 10:49:51','052025','CR','60391568','SANDRA MARITZA','GAVANZO GALINDO','AV 9A 16A-49 VILLA CELINA CUCU','5781240 3138434492','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','8','108214.28571428572','20560.71428571428','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:57:14','128775','50','DEPOSITO CUCUTA ','1','37000.00000000','37000.00000000','31092.43697479','5907.5630252101','37000','1','0','0','','31/05/2025','','0','0','128775','7500435202497','GILLETTE GEL TRAINING GUARD 82 GR X2 UND','336','PROCTER & GAMBLE COLOMBIA','2025-05-31 10:49:51',  25554, 65483, 2, 19, 8793943)
			   ,('FVE','DP1','024068','2025-05-31 10:51:26','052025','CO','1090488404','WILLIAM MARLON','CACERES','TRASVERSAL 17 NO.K-249 PUEBLO ',' 3228984489','692','WILLIAM MARLON','CACERES','','TERCERO','VARIOS','','','','','','2','23697.47899159664','4502.521008403361','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 10:51:26','28200','50','DEPOSITO CUCUTA ','1','28200.00000000','28200.00000000','23697.478991597','4502.5210084034','28200','1','0','1','','31/05/2025','','0','28200','0','7702560043499','KOLA GRANULADA JGB FRESA * 330 GTS 80 GR','219','JGB','2025-05-31 10:51:26',  19999.107, 27878, 2, 19, 8793941)
			   ,('FVE','DP1','024069','2025-05-31 10:51:48','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:52:21','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:51:48',  0, 61074, 2, 19, 8793942)
			   ,('FVE','DP1','024070','2025-05-31 10:52:56','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:52:56','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:52:56',  0, 61074, 2, 19, 8793946)
			   ,('FVE','DP1','024071','2025-05-31 10:53:49','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:54:39','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:53:49',  0, 61074, 2, 19, 8793949)
			   ,('FVE','DP1','024072','2025-05-31 10:54:51','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:54:51','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:54:51',  0, 61074, 2, 19, 8793951)
			   ,('FVE','DP1','024073','2025-05-31 10:55:51','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:56:51','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:55:51',  0, 61074, 2, 19, 8793954)
			   ,('FVE','DP1','024075','2025-05-31 10:57:43','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:57:43','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:57:43',  0, 61074, 2, 19, 8793959)
			   ,('FVE','DP1','024076','2025-05-31 10:59:26','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 10:59:38','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 10:59:26',  0, 61074, 2, 19, 8793969)
			   ,('FVE','DP1','024077','2025-05-31 11:01:00','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 11:03:15','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:01:00',  0, 61074, 2, 19, 8793975)
			   ,('FVE','DP1','024078','2025-05-31 11:01:54','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 11:03:15','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:01:54',  0, 61074, 2, 19, 8793977)
			   ,('FVE','DP1','024079','2025-05-31 11:02:44','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 11:03:15','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:02:44',  0, 61074, 2, 19, 8793983)
			   ,('FVE','DP1','024080','2025-05-31 11:07:34','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 11:07:34','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:07:34',  0, 61074, 2, 19, 8793999)
			   ,('FVE','DP1','024081','2025-05-31 11:08:22','052025','CO','1143168041','OSCAR FABIAN','OTERO RODRIGUEZ','CALLE 47 NO.44-152',' 3022070318','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','21596.638655462186','4103.361344537814','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-05-31 11:08:38','25700','50','DEPOSITO CUCUTA ','1','15700.00000000','15700.00000000','13193.277310924','2506.7226890756','15700','1','0','1','','31/05/2025','','0','25700','0','7509546063331','COLGATE CREMA TRIPLE ACCION *150 ML','145','COLGATE PALMOLIVE COMPANIA','2025-05-31 11:08:22',  8779.6809, 48127, 2, 19, 8794009)
			   ,('FVE','DP1','024081','2025-05-31 11:08:22','052025','CO','1143168041','OSCAR FABIAN','OTERO RODRIGUEZ','CALLE 47 NO.44-152',' 3022070318','2139','KENSY JAVIER','FERRER SOTO','','TERCERO','VARIOS','','','','','','4','21596.638655462186','4103.361344537814','00','DEPOSITO CUCUTA','DEVOLUCIONESCUC','2025-05-31 11:08:38','25700','50','DEPOSITO CUCUTA ','2','5000.00000000','10000.00000000','8403.3613445378','1596.6386554622','10000','2','0','1','','31/05/2025','','0','25700','0','7702018880409','GILLETTE PRESTOBARBA 3 HOMBRE ','336','PROCTER & GAMBLE COLOMBIA','2025-05-31 11:08:22',  3090.42531, 40145, 2, 19, 8794009)
				  ,('FVE','DP1','024082','2025-05-31 11:55:20','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','10','871200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 11:55:20','871200','50','DEPOSITO CUCUTA ','9','96800.00000000','871200.00000000','871200','0','871200','9','0','0','','31/05/2025','','871200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:55:20',  0, 61074, 2, 19, 8793916);
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','024083','2025-05-31 11:55:22','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 11:55:22','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:55:22',  0, 61074, 2, 19, 8793917)
			   ,('FVE','DP1','024084','2025-05-31 11:55:27','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 11:55:27','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:55:27',  0, 61074, 2, 19, 8793919)
			   ,('FVE','DP1','024085','2025-05-31 11:58:57','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:06:00','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 11:58:57',  0, 61074, 2, 19, 8794087)
			   ,('FVE','DP1','024086','2025-05-31 12:02:46','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:02:46','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:02:46',  0, 61074, 2, 19, 8793920)
			   ,('FVE','DP1','024087','2025-05-31 12:03:37','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','32','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:03:37','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:03:37',  0, 61074, 2, 19, 8793921)
			   ,('FVE','DP1','024088','2025-05-31 12:04:26','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:04:26','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:04:26',  0, 61074, 2, 19, 8793922)
			   ,('FVE','DP1','024089','2025-05-31 12:04:28','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:04:28','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:04:28',  0, 61074, 2, 19, 8793339)
			   ,('FVE','DP1','024090','2025-05-31 12:04:44','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:06:00','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:04:44',  0, 61074, 2, 19, 8794117)
			   ,('FVE','DP1','024091','2025-05-31 12:04:52','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:04:52','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:04:52',  0, 61074, 2, 19, 8794031)
			   ,('FVE','DP1','024092','2025-05-31 12:06:07','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:06:07','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:06:07',  0, 61074, 2, 19, 8794125)
			   ,('FVE','DP1','024093','2025-05-31 12:07:08','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:09:51','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:07:08',  0, 61074, 2, 19, 8794136)
			   ,('FVE','DP1','024094','2025-05-31 12:08:57','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:09:51','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:08:57',  0, 61074, 2, 19, 8794148)
			   ,('FVE','DP1','024095','2025-05-31 12:09:42','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:09:51','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:09:42',  0, 61074, 2, 19, 8794164)
			   ,('FVE','DP1','024096','2025-05-31 12:10:34','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:11:54','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:10:34',  0, 61074, 2, 19, 8794173)
			   ,('FVE','DP1','024097','2025-05-31 12:11:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:11:54','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:11:10',  0, 61074, 2, 19, 8794176)
			   ,('FVE','DP1','024098','2025-05-31 12:15:49','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:17:43','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:15:49',  0, 61074, 2, 19, 8794226)
			   ,('FVE','DP1','024099','2025-05-31 12:17:24','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:17:43','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:17:24',  0, 61074, 2, 19, 8794245)
			   ,('FVE','DB2','004229','2025-05-31 12:17:37','052025','CR','1095580470','BRAYAN STIVEN','LOPEZ SANCHEZ','CRA 13 NO.17-05 BAMBUES ',' 3204239370','2140','CRISTIAN ANDRéS','MARTíNEZ','','TERCERO','VARIOS','','','','','','2','18907.563025210085','3592.4369747899145','DBU','DEPOSITO BUCARAMANGA','LIDERBODEGABGA','2025-05-31 12:24:25','22500','DBU','DEPOSITO BUCARAMANGA','1','22500.00000000','22500.00000000','18907.56302521','3592.4369747899','22500','1','0','0','','31/05/2025','','0','0','22500','7702277074328','COLONIA ARRURRU AZUL * 120 ML ','124','BELLEZA EXPRESS SA','2025-05-31 12:17:37',  14696.5, 34506, 426, 249, 8794250)
			   ,('FVE','DP1','024100','2025-05-31 12:19:21','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:20:15','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:21',  0, 61074, 2, 19, 8794253)
			   ,('FVE','DP1','024101','2025-05-31 12:19:22','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','36','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:19:22','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:22',  0, 61074, 2, 19, 8794197)
			   ,('FVE','DP1','024102','2025-05-31 12:19:24','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','36','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:19:24','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:24',  0, 61074, 2, 19, 8794198)
			   ,('FVE','DP1','024103','2025-05-31 12:19:33','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:19:33','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:33',  0, 61074, 2, 19, 8794200)
			   ,('FVE','DP1','024104','2025-05-31 12:19:37','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:19:37','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:37',  0, 61074, 2, 19, 8794199)
			   ,('FVE','DP1','024105','2025-05-31 12:19:45','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:19:45','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:45',  0, 61074, 2, 19, 8794202)
			   ,('FVE','DP1','024108','2025-05-31 12:19:49','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:19:49','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:49',  0, 61074, 2, 19, 8794201)
			   ,('FVE','DP1','024106','2025-05-31 12:19:50','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:19:50','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:19:50',  0, 61074, 2, 19, 8794204)
			   ,('FVE','DP1','024107','2025-05-31 12:20:04','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:20:04','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:20:04',  0, 61074, 2, 19, 8794203)
			   ,('FVE','DP1','024109','2025-05-31 12:20:56','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:20:56','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:20:56',  0, 61074, 2, 19, 8794259)
			   ,('FVE','DP1','024110','2025-05-31 12:21:54','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:23:32','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:21:54',  0, 61074, 2, 19, 8794265)
			   ,('FVE','DP1','024111','2025-05-31 12:22:56','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:23:32','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:22:56',  0, 61074, 2, 19, 8794267)
			   ,('FVE','DP1','024112','2025-05-31 12:24:31','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:24:31','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:24:31',  0, 61074, 2, 19, 8794275)
			   ,('FVE','DP1','024113','2025-05-31 12:30:07','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:39:02','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:30:07',  0, 61074, 2, 19, 8794316)
			   ,('FVE','DP1','024114','2025-05-31 12:32:44','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','24','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:39:02','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:32:44',  0, 61074, 2, 19, 8794320)
			   ,('FVE','DP1','024115','2025-05-31 12:33:41','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:39:02','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:33:41',  0, 61074, 2, 19, 8794328)
			   ,('FVE','DP1','024116','2025-05-31 12:34:18','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:18',  0, 61074, 2, 19, 8794288)
			   ,('FVE','DP1','024117','2025-05-31 12:34:21','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:21',  0, 61074, 2, 19, 8794289)
			   ,('FVE','DP1','024118','2025-05-31 12:34:30','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:30',  0, 61074, 2, 19, 8794290)
			   ,('FVE','DP1','024119','2025-05-31 12:34:33','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:33',  0, 61074, 2, 19, 8794291)
			   ,('FVE','DP1','024120','2025-05-31 12:34:46','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:46',  0, 61074, 2, 19, 8794293)
			   ,('FVE','DP1','024121','2025-05-31 12:34:46','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:39:02','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:46',  0, 61074, 2, 19, 8794338)
				  ,('FVE','DP1','024122','2025-05-31 12:34:47','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:47',  0, 61074, 2, 19, 8794307);
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','024123','2025-05-31 12:34:49','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:49',  0, 61074, 2, 19, 8794292)
			   ,('FVE','DP1','024124','2025-05-31 12:34:51','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:34:51',  0, 61074, 2, 19, 8794308)
			   ,('FVE','DP1','024125','2025-05-31 12:35:09','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:09',  0, 61074, 2, 19, 8794310)
			   ,('FVE','DP1','024126','2025-05-31 12:35:11','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:11',  0, 61074, 2, 19, 8794311)
			   ,('FVE','DP1','024127','2025-05-31 12:35:14','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:14',  0, 61074, 2, 19, 8794312)
			   ,('FVE','DP1','024128','2025-05-31 12:35:17','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:17',  0, 61074, 2, 19, 8794313)
			   ,('FVE','DP1','024129','2025-05-31 12:35:24','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:39:02','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:24',  0, 61074, 2, 19, 8794342)
			   ,('FVE','DP1','024130','2025-05-31 12:35:29','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:29',  0, 61074, 2, 19, 8794294)
			   ,('FVE','DP1','024131','2025-05-31 12:35:30','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','3140','ANGIE CAMILA','MORENO RINCON','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','AUXILIAR10.CONTAB','2025-05-31 12:39:02','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:30',  0, 61074, 2, 19, 8794314)
			   ,('FVE','DP1','024132','2025-05-31 12:35:41','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:39:02','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:35:41',  0, 61074, 2, 19, 8794335)
			   ,('FVE','DP1','024133','2025-05-31 12:36:26','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:39:02','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:36:26',  0, 61074, 2, 19, 8794344)
			   ,('FVE','DP1','024134','2025-05-31 12:36:49','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:39:02','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:36:49',  0, 61074, 2, 19, 8794349)
			   ,('FVE','DP1','024135','2025-05-31 12:37:15','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:39:02','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:37:15',  0, 61074, 2, 19, 8794347)
			   ,('FVE','DP1','024136','2025-05-31 12:38:34','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:39:02','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:38:34',  0, 61074, 2, 19, 8794356)
			   ,('FVE','DP1','024137','2025-05-31 12:38:46','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:39:02','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:38:46',  0, 61074, 2, 19, 8794355)
			   ,('FVE','DP1','024138','2025-05-31 12:40:01','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','48','1452000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:40:01','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:40:01',  0, 61074, 2, 19, 8794353)
			   ,('FVE','DP1','024139','2025-05-31 12:42:40','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','20','1742400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:46:03','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:42:40',  0, 61074, 2, 19, 8794366)
			   ,('FVE','DP1','024140','2025-05-31 12:42:52','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','18','1645600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:46:03','1645600','50','DEPOSITO CUCUTA ','17','96800.00000000','1645600.00000000','1645600','0','1645600','17','0','0','','31/05/2025','','1645600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:42:52',  0, 61074, 2, 19, 8794364)
			   ,('FVE','DP1','024141','2025-05-31 12:43:10','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','17','1548800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:43:10','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:43:10',  0, 61074, 2, 19, 8794362)
			   ,('FVE','DP1','024142','2025-05-31 12:43:15','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','34','1548800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:46:03','1548800','50','DEPOSITO CUCUTA ','16','96800.00000000','1548800.00000000','1548800','0','1548800','16','0','0','','31/05/2025','','1548800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:43:15',  0, 61074, 2, 19, 8794368)
			   ,('FVE','DP1','024143','2025-05-31 12:43:45','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','20','1839200','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:46:03','1839200','50','DEPOSITO CUCUTA ','19','96800.00000000','1839200.00000000','1839200','0','1839200','19','0','0','','31/05/2025','','1839200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:43:45',  0, 61074, 2, 19, 8794382)
			   ,('FVE','DP1','024144','2025-05-31 12:44:40','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:46:03','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:44:40',  0, 61074, 2, 19, 8794385)
			   ,('FVE','DP1','024145','2025-05-31 12:46:07','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','19','1742400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:46:07','1742400','50','DEPOSITO CUCUTA ','18','96800.00000000','1742400.00000000','1742400','0','1742400','18','0','0','','31/05/2025','','1742400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:46:07',  0, 61074, 2, 19, 8794386)
			   ,('FVE','DP1','024146','2025-05-31 12:46:10','052025','CO','1005029164','JOHAN','PE ntilde ARANDA','CALLE 10 NO.1-25 MOTILONES. CU',' 3138860242','423','JOS� ALBERTO','VELEZ MARTINEZ','','TERCERO','VARIOS','','','','','','2','46200','0','00','DEPOSITO CUCUTA','J.VELEZ','2025-05-31 12:46:10','46200','50','DEPOSITO CUCUTA ','1','46200.00000000','46200.00000000','46200','0','46200','1','0','1','','31/05/2025','','0','46200','0','7708109834184','COLLAGENFIT COLAGENO HIDROLIZADO * 700 GR','1000','NATURALMENTE','2025-05-31 12:46:10',  23000, 60996, 2, 19, 8794374)
			   ,('FVE','DP1','024147','2025-05-31 12:46:38','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:46:38','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:46:38',  0, 61074, 2, 19, 8794392)
			   ,('FVE','DP1','024148','2025-05-31 12:46:49','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:46:49','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:46:49',  0, 61074, 2, 19, 8794389)
			   ,('FVE','DP1','024149','2025-05-31 12:47:44','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','7','580800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:59:43','580800','50','DEPOSITO CUCUTA ','6','96800.00000000','580800.00000000','580800','0','580800','6','0','0','','31/05/2025','','580800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:47:44',  0, 61074, 2, 19, 8794396)
			   ,('FVE','DP1','024150','2025-05-31 12:48:13','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:59:43','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:48:13',  0, 61074, 2, 19, 8794400)
			   ,('FVE','DP1','024151','2025-05-31 12:49:46','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','838','SAMUEL JOSUE','SOLANO ROJAS','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','1005064699','2025-05-31 12:59:43','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:49:46',  0, 61074, 2, 19, 8794413)
			   ,('FVE','DP1','024152','2025-05-31 12:50:07','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','11','968000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 12:59:43','968000','50','DEPOSITO CUCUTA ','10','96800.00000000','968000.00000000','968000','0','968000','10','0','0','','31/05/2025','','968000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 12:50:07',  0, 61074, 2, 19, 8794415)
			   ,('FVE','DB1','002371','2025-05-31 12:53:47','052025','CR','1001917294','JAIDER MANUEL','NAVARRO FERRER','CALLE 869 NO.15A1-82',' 3015099813','985','NABYS  DE JESúS','MORENO RIVERO','','TERCERO','VARIOS','','','',' C.GOMEZ Autoriza la Venta por Cupo. May 31, 2025, 12:54 pm','','2','5966.386554621849','1133.6134453781506','DB','DEPOSITO BARRANQUILLA','C.GOMEZ','2025-05-31 12:59:43','7100','DB','DEPOSITO BARRANQUILLA','1','7100.00000000','7100.00000000','5966.3865546218','1133.6134453782','7100','1','0','0','','31/05/2025','','0','0','7100','7702535024423','COCA COLA * 1.5 LT','144','COCA COLA','2025-05-31 12:53:47',  0, 56142, 119, 53, 8794443)
			   ,('FVE','DP1','024153','2025-05-31 13:00:42','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','12','1064800','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 13:00:42','1064800','50','DEPOSITO CUCUTA ','11','96800.00000000','1064800.00000000','1064800','0','1064800','11','0','0','','31/05/2025','','1064800','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 13:00:42',  0, 61074, 2, 19, 8794426)
			   ,('FVE','DP1','024154','2025-05-31 13:04:11','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','13','1161600','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 13:12:57','1161600','50','DEPOSITO CUCUTA ','12','96800.00000000','1161600.00000000','1161600','0','1161600','12','0','0','','31/05/2025','','1161600','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 13:04:11',  0, 61074, 2, 19, 8794492)
			   ,('FVE','DP1','024155','2025-05-31 13:05:17','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','14','1258400','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 13:12:57','1258400','50','DEPOSITO CUCUTA ','13','96800.00000000','1258400.00000000','1258400','0','1258400','13','0','0','','31/05/2025','','1258400','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 13:05:17',  0, 61074, 2, 19, 8794496)
			   ,('FVE','DP1','024156','2025-05-31 13:06:08','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','15','1355200','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 13:12:57','1355200','50','DEPOSITO CUCUTA ','14','96800.00000000','1355200.00000000','1355200','0','1355200','14','0','0','','31/05/2025','','1355200','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 13:06:08',  0, 61074, 2, 19, 8794507)
			   ,('FVE','DP1','024157','2025-05-31 13:08:07','052025','CO','222222222222','CONSUMIDOR','FINAL','',' 3000000000','2653','LEONARDO ANDRES','NIETO CHAMORRO','','TERCERO','VARIOS','','','','','','16','1452000','0','00','DEPOSITO CUCUTA','AUXPRESUPUESTO','2025-05-31 13:12:57','1452000','50','DEPOSITO CUCUTA ','15','96800.00000000','1452000.00000000','1452000','0','1452000','15','0','0','','31/05/2025','','1452000','0','0','7709375370369','SUREZINC VAINILLA * 1000 GR ','1007','SUREZINC','2025-05-31 13:08:07',  0, 61074, 2, 19, 8794517);
UPDATE consolida1 SET DEVALPAR  = DEVALUNI*DECANTIDAD WHERE DEVALPAR = 0 AND PERIODODOC = '052025' AND DECODBOD='00';
UPDATE consolida1 SET DEVALBASE = DEVALTOTAL*DEVALIVA WHERE DEVALBASE = 0 AND PERIODODOC = '052025' AND DECODBOD='00';
UPDATE consolida1 SET DEVALIVA  = DEVALTOTAL-DEVALBASE WHERE PERIODODOC = '052025' AND DECODBOD='00';
UPDATE consolida1 SET VRBASEDOC = TOTALDOC-VRIVADOC WHERE VRBASEDOC = 0 AND VRIVADOC = 0 AND PERIODODOC = '052025' AND DECODBOD='00';
DELETE FROM consolida2 WHERE PERIODOESPE = '052025' AND CODSUCURSAL = '00';
