-- Table structure for table `registrosmediosdepago2021`
--

CREATE TABLE `registrosmediosdepago2021` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `idmayor` int NOT NULL DEFAULT '0',
  `mediodepago` varchar(200) DEFAULT NULL,
  `cc` int DEFAULT '2',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idfactura` int DEFAULT '0',
  `idabono` int DEFAULT '0',
  `valor` double DEFAULT '0',
  `anulado` int NOT NULL DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idabonoprestamo` int DEFAULT '0',
  `idabonoseparado` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `idabonoordenservicio` int DEFAULT '0',
  `abonado` int DEFAULT '0',
  `cuenta_contable` int DEFAULT NULL,
  `idusuariomedidepago` int DEFAULT '0',
  `serviciomediopago` decimal(9,2) DEFAULT '0.00',
  `idabonoreserva` int DEFAULT '0',
  `esanticipo` int DEFAULT '0',
  `idanticipo` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`),
  KEY `idfactura` (`idfactura`),
  KEY `idz` (`idz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `registrosmediosdepago2021`
--


--
-- Table structure for table `registrosmediosdepago2022`
--

CREATE TABLE `registrosmediosdepago2022` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `idmayor` int NOT NULL DEFAULT '0',
  `mediodepago` varchar(200) DEFAULT NULL,
  `cc` int DEFAULT '2',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idfactura` int DEFAULT '0',
  `idabono` int DEFAULT '0',
  `valor` double DEFAULT '0',
  `anulado` int NOT NULL DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idabonoprestamo` int DEFAULT '0',
  `idabonoseparado` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `idabonoordenservicio` int DEFAULT '0',
  `abonado` int DEFAULT '0',
  `cuenta_contable` int DEFAULT NULL,
  `idusuariomedidepago` int DEFAULT '0',
  `serviciomediopago` decimal(9,2) DEFAULT '0.00',
  `idabonoreserva` int DEFAULT '0',
  `esanticipo` int DEFAULT '0',
  `idanticipo` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`),
  KEY `idfactura` (`idfactura`),
  KEY `idz` (`idz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `registrosmediosdepago2022`
--


--
-- Table structure for table `reservas`
--

CREATE TABLE `reservas` (
  `id` bigint unsigned NOT NULL,
  `fechacreacion` datetime DEFAULT NULL,
  `fechain` date DEFAULT NULL,
  `fechaout` date DEFAULT NULL,
  `idusuario` int DEFAULT NULL,
  `idmesa` int DEFAULT NULL,
  `responsable` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `reservas`
--

INSERT INTO `reservas` (`id`, `fechacreacion`, `fechain`, `fechaout`, `idusuario`, `idmesa`, `responsable`) VALUES (0,NULL,'2025-04-08','2025-04-08',NULL,1,NULL),(0,NULL,'2025-04-08','2025-04-08',NULL,1,NULL),(0,NULL,'2025-04-30','2025-04-30',NULL,20,NULL),(0,NULL,'2025-04-30','2025-04-30',NULL,6,NULL),(0,NULL,'2025-04-30','2025-04-30',NULL,7,NULL),(0,NULL,'2025-04-30','2025-04-30',NULL,3,NULL),(0,NULL,'2025-04-30','2025-04-30',NULL,3,NULL),(0,NULL,'2025-05-23','2025-05-23',NULL,1,NULL),(0,NULL,'2025-05-23','2025-05-23',NULL,39,NULL);

--
-- Table structure for table `reservasauxiliar`
--

CREATE TABLE `reservasauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cliente` varchar(100) DEFAULT NULL,
  `cedula` varchar(15) DEFAULT NULL,
  `telefono` varchar(25) DEFAULT NULL,
  `fechaentrada` date DEFAULT NULL,
  `fechasalida` date DEFAULT NULL,
  `nacionalidad` varchar(25) DEFAULT NULL,
  `direccion` varchar(100) DEFAULT NULL,
  `ciudad` varchar(25) DEFAULT NULL,
  `marca` varchar(25) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `idcliente` bigint unsigned DEFAULT NULL,
  `idusuario` bigint unsigned DEFAULT NULL,
  `fechacreacion` datetime DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  `idreserva` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idcliente` (`idcliente`,`idreserva`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `reservasauxiliar`
--


--
-- Table structure for table `resoluciones`
--

CREATE TABLE `resoluciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `fechainicioresolucion` date DEFAULT NULL,
  `fechafinresolucion` date DEFAULT NULL,
  `desde` bigint NOT NULL DEFAULT '0',
  `hasta` bigint NOT NULL DEFAULT '0',
  `numero` varchar(20) DEFAULT NULL,
  `prefijo` varchar(20) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `resoluciones`
--

INSERT INTO `resoluciones` (`id`, `fecha`, `fechainicioresolucion`, `fechafinresolucion`, `desde`, `hasta`, `numero`, `prefijo`, `cc`, `pv`) VALUES (1,NULL,NULL,NULL,0,0,'1',NULL,1,'KALDI'),(2,NULL,NULL,NULL,0,0,'1',NULL,2,'KALDI');

--
-- Table structure for table `respuestacostoagrupado`
--

CREATE TABLE `respuestacostoagrupado` (
  `idarticulo` int NOT NULL,
  `idinsumo` int NOT NULL,
  `idusuario` int NOT NULL,
  `cantidad` double NOT NULL,
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `respuestacostoagrupado`
--


--
-- Table structure for table `respuestacotizacionreceta`
--

CREATE TABLE `respuestacotizacionreceta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` int NOT NULL,
  `idinsumo` bigint NOT NULL,
  `idusuario` int NOT NULL,
  `cantidad` double NOT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `respuestacotizacionreceta`
--

INSERT INTO `respuestacotizacionreceta` (`id`, `idarticulo`, `idinsumo`, `idusuario`, `cantidad`, `pv`) VALUES (1,0,20,1,1,'KALDI'),(2,0,20,102,1,'KALDI');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `rol` varchar(50) DEFAULT ' ',
  `cc` int NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `rol`, `cc`, `pv`) VALUES (7,'CLIENTE',1,'KALDI'),(11,'PROVEEDOR',2,'KALDI'),(14,'VENDEDOR',2,'KALDI'),(15,'PATINADOR',2,'KALDI'),(16,'CAJERO (A)',2,'KALDI'),(18,'Papitas',2,'KALDI'),(21,'DOMICILIARIO',2,'KALDI'),(22,'Parrilla ',2,'KALDI'),(34,'MESERO',2,'KALDI'),(39,'ADMINISTRADOR',2,'KALDI');

--
-- Table structure for table `rutasauxiliar`
--

CREATE TABLE `rutasauxiliar` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `saldo` double DEFAULT '0',
  `fechacreacion` datetime DEFAULT NULL,
  `idusuario` bigint unsigned NOT NULL,
  `cliente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `consecutivo` int DEFAULT '0',
  `idcliente` bigint unsigned DEFAULT NULL,
  `idvendedor` bigint unsigned NOT NULL,
  `idzona` bigint unsigned DEFAULT NULL,
  `valor` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_idfactura` (`idfactura`),
  KEY `idx_idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idzona` (`idzona`),
  CONSTRAINT `rutasauxiliar_ibfk_1` FOREIGN KEY (`idvendedor`) REFERENCES `clientes` (`id`),
  CONSTRAINT `rutasauxiliar_ibfk_2` FOREIGN KEY (`idvendedor`) REFERENCES `clientes` (`id`),
  CONSTRAINT `rutasauxiliar_ibfk_3` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `rutasauxiliar_ibfk_4` FOREIGN KEY (`idzona`) REFERENCES `zonasclientes` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rutasauxiliar`
--


--
-- Table structure for table `secciones`
--

CREATE TABLE `secciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idtienda` bigint unsigned DEFAULT '1',
  `seccion` varchar(30) NOT NULL DEFAULT '',
  `alias` varchar(30) NOT NULL DEFAULT '',
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `orden` int NOT NULL DEFAULT '0',
  `sevende` int NOT NULL DEFAULT '1',
  `extension` varchar(5) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'texasburgers',
  `sesubeaifood` int DEFAULT '0',
  `idifood` varchar(50) DEFAULT NULL,
  `sesubearappi` int DEFAULT '1',
  `cantidaddearticulos` int DEFAULT '0',
  `mostrarnombreentienda` bit(1) DEFAULT b'1',
  `iddomiciliario` int DEFAULT NULL,
  `saleentiendavirtual` int DEFAULT '0',
  `idseccionpagina` int DEFAULT '0',
  `urlfoto2` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `secciones`
--

INSERT INTO `secciones` (`id`, `idtienda`, `seccion`, `alias`, `cc`, `orden`, `sevende`, `extension`, `pv`, `sesubeaifood`, `idifood`, `sesubearappi`, `cantidaddearticulos`, `mostrarnombreentienda`, `iddomiciliario`, `saleentiendavirtual`, `idseccionpagina`, `urlfoto2`) VALUES (1,1,'TOPPING PRECIO','',2,7,1,NULL,'texasburgers',0,NULL,1,18,_binary '',NULL,0,0,NULL),(2,1,'ADICIONES','',2,7,1,NULL,'texasburgers',0,NULL,1,7,_binary '',NULL,0,0,NULL),(3,1,'TOPPING PREMIUM','',2,5,1,NULL,'texasburgers',0,NULL,1,10,_binary '',NULL,0,0,NULL),(4,1,'TOPPING INCLUIDO','',2,5,0,NULL,'texasburgers',0,NULL,1,10,_binary '',NULL,0,0,NULL),(5,1,'TOPPING CLASICO','',2,5,1,NULL,'texasburgers',0,NULL,1,10,_binary '',NULL,0,0,NULL),(6,1,'BEBIDAS CALIENTES','',2,1,1,NULL,'texasburgers',0,NULL,1,7,_binary '',NULL,0,0,NULL),(7,1,'BEBIDAS FRIAS','',2,2,1,NULL,'texasburgers',0,NULL,1,6,_binary '',NULL,0,0,NULL),(8,1,'OTRAS BEBIDAS','',2,3,1,NULL,'texasburgers',0,NULL,1,5,_binary '',NULL,0,0,NULL),(9,1,'ARMA TU ACAI','',2,4,1,NULL,'texasburgers',0,NULL,1,4,_binary '',NULL,0,0,NULL),(11,1,'SALSA CLASICAS','',2,11,1,NULL,'texasburgers',0,NULL,1,2,_binary '',NULL,0,0,NULL),(12,1,'SALSA PREMIUM','',2,12,1,NULL,'texasburgers',0,NULL,1,4,_binary '',NULL,0,0,NULL);

--
-- Table structure for table `seccionespagina`
--

CREATE TABLE `seccionespagina` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seccion` varchar(30) NOT NULL DEFAULT '',
  `orden` int NOT NULL DEFAULT '0',
  `publico` bit(1) DEFAULT b'1',
  `extension1` varchar(5) DEFAULT 'jpg',
  `extension2` varchar(5) DEFAULT 'jpg',
  `tipo` varchar(25) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `seccionespagina`
--

INSERT INTO `seccionespagina` (`id`, `seccion`, `orden`, `publico`, `extension1`, `extension2`, `tipo`, `url`) VALUES (1,'url_hero',0,_binary '','jpg','jpg',NULL,'https://misterwings.control2.com.co/imagenes_comco/1751923389_kebab.jpg'),(2,'url_logo',0,_binary '','jpg','jpg',NULL,'https://misterwings.control2.com.co/imagenes_comco/1751923389_kebab.jpg'),(3,'url_iconoquegira',0,_binary '','jpg','jpg',NULL,'https://control2.eu/imagenes/susoftware.png'),(4,'url_favicon',0,_binary '','jpg','jpg',NULL,'https://control2.eu/imagenes/susoftware.png');

--
-- Table structure for table `seguimientovehiculos`
--

CREATE TABLE `seguimientovehiculos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(200) DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL,
  `placa` varchar(7) DEFAULT NULL,
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `vencido` bigint NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `placa` (`placa`),
  CONSTRAINT `seguimientovehiculos_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `seguimientovehiculos_ibfk_3` FOREIGN KEY (`idz`) REFERENCES `z` (`id`),
  CONSTRAINT `seguimientovehiculos_ibfk_4` FOREIGN KEY (`placa`) REFERENCES `vehiculos` (`placa`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `seguimientovehiculos`
--


--
-- Table structure for table `separados`
--

CREATE TABLE `separados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` int NOT NULL DEFAULT '0',
  `idmayor` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `bruto` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idmayor` (`idmayor`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `separados`
--


--
-- Table structure for table `shopify`
--

CREATE TABLE `shopify` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sku` varchar(20) DEFAULT NULL,
  `inventory_item_id` varchar(20) DEFAULT NULL,
  `location_id` varchar(20) DEFAULT NULL,
  `product_id` varchar(20) DEFAULT NULL,
  `variant_id` varchar(20) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `sku` (`sku`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `shopify`
--


--
-- Table structure for table `situacionesdecocina`
--

CREATE TABLE `situacionesdecocina` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `nombreimpresora` varchar(50) DEFAULT NULL,
  `cc` int DEFAULT NULL,
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'texasburgers',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `situacionesdecocina`
--

INSERT INTO `situacionesdecocina` (`id`, `situacioncocina`, `nombreimpresora`, `cc`, `COD_SATELITE`, `pv`) VALUES (1,'COCINA','COCINA',2,'pruebas','pruebas'),(4,'BEBIDAS','COCINA',2,'pruebas','pruebas'),(5,'CAJA','CAJA',2,'pruebas','pruebas'),(6,'NO IMPRIME','NO',2,'pruebas','pruebas');

--
-- Table structure for table `solicitudesauxiliar`
--

CREATE TABLE `solicitudesauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmesa` int DEFAULT '1',
  `descuento` double NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL,
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `observaciones` varchar(125) DEFAULT NULL,
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirvio el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que el mesero ya entrego el producto',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `descripcion` varchar(100) DEFAULT NULL,
  `referenciacruzada` int DEFAULT NULL,
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcaja` (`idcaja`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `solicitudesauxiliar`
--


--
-- Table structure for table `solicitudesenviadas`
--

CREATE TABLE `solicitudesenviadas` (
  `consecutivo` int NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `valorunitario` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `origen` varchar(25) DEFAULT NULL,
  `destino` varchar(50) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `idmayor` int DEFAULT '0',
  `ESTADO` varchar(12) NOT NULL DEFAULT 'ENVIADA',
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `costomedio` double DEFAULT '0',
  `referenciacruzada` int DEFAULT NULL,
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `solicitudesenviadas`
--


--
-- Table structure for table `solicitudesrecibidas`
--

CREATE TABLE `solicitudesrecibidas` (
  `consecutivo` int NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `valorunitario` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `origen` varchar(25) DEFAULT NULL,
  `destino` varchar(50) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `idmayor` int DEFAULT '0',
  `estado` varchar(25) DEFAULT 'ENVIADA',
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `costomedio` double DEFAULT '0',
  `referenciacruzada` int DEFAULT NULL,
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  `idfactura` int DEFAULT NULL,
  `referencia` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `solicitudesrecibidas`
--


--
-- Table structure for table `tareas`
--

CREATE TABLE `tareas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `idprospecto` bigint unsigned NOT NULL,
  `nota` text,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL,
  `orden` int DEFAULT '0',
  `estado` varchar(25) DEFAULT 'PENDIENTE',
  `tarea` text,
  `pv` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `fecha` (`fecha`,`idprospecto`),
  KEY `idprospecto` (`idprospecto`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tareas`
--

INSERT INTO `tareas` (`id`, `fecha`, `idprospecto`, `nota`, `fechacreacion`, `idusuario`, `orden`, `estado`, `tarea`, `pv`) VALUES (1,NULL,2,NULL,'2023-02-19 20:47:16',11,0,'PENDIENTE','Limpiar cerco ,telarañas, barrer afuera, no recochar tanto\n\n',NULL);

--
-- Table structure for table `temporal`
--

CREATE TABLE `temporal` (
  `id` int NOT NULL,
  `idarticulo` int NOT NULL DEFAULT '0',
  `cantidad` double NOT NULL DEFAULT '0',
  `idusuario` int NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `temporal`
--


--
-- Table structure for table `temporal2`
--

CREATE TABLE `temporal2` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idinsumo` int NOT NULL DEFAULT '0',
  `cantidad` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `temporal2`
--


--
-- Table structure for table `tiendas`
--

CREATE TABLE `tiendas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tienda` varchar(50) DEFAULT NULL,
  `extension` varchar(4) DEFAULT NULL,
  `cc` int DEFAULT '2',
  `orden` int DEFAULT '0',
  `url` varchar(220) DEFAULT NULL,
  `COD_SATELITE` varchar(50) DEFAULT NULL,
  `esbodega` int DEFAULT '0',
  `integradoabodega` int DEFAULT '1',
  `pv` varchar(25) DEFAULT 'texasburgers',
  `estadotienda` varchar(25) DEFAULT 'ABIERTA',
  `urllogo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiendas`
--

INSERT INTO `tiendas` (`id`, `tienda`, `extension`, `cc`, `orden`, `url`, `COD_SATELITE`, `esbodega`, `integradoabodega`, `pv`, `estadotienda`, `urllogo`) VALUES (1,'pruebaseu','png',2,0,NULL,'pruebaseu',0,0,'pruebaseu','ABIERTA',NULL);

--
-- Table structure for table `tiposdecarroceria`
--

CREATE TABLE `tiposdecarroceria` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tipodecarroceria` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `tipodecarroceria` (`tipodecarroceria`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiposdecarroceria`
--

INSERT INTO `tiposdecarroceria` (`id`, `tipodecarroceria`) VALUES (1,'Van'),(2,'Wagon'),(3,'Station '),(4,'Camioneta'),(5,'Microbus'),(6,'Bus'),(7,'Cerrado'),(8,'Doble cabina');

--
-- Table structure for table `tiposdegasto`
--

CREATE TABLE `tiposdegasto` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tipodegasto` varchar(150) NOT NULL,
  `fechadecreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cc` bigint unsigned NOT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiposdegasto`
--

INSERT INTO `tiposdegasto` (`id`, `tipodegasto`, `fechadecreacion`, `cc`, `pv`) VALUES (3,'NOMINA','2021-03-05 20:21:18',2,'KALDI'),(4,'MANTENIMIENTO','2021-03-05 20:21:26',2,'KALDI'),(5,'INSUMOS','2021-03-05 20:21:32',2,'KALDI'),(10,'AGUA','2021-03-17 10:21:03',2,'KALDI'),(11,'ENERGIA','2021-03-17 10:21:11',2,'KALDI'),(12,'GAS NATURAL','2021-03-17 10:21:18',2,'KALDI'),(13,'INTERNET','2021-03-17 10:21:27',2,'KALDI'),(14,'PUBLICIDAD','2021-03-17 10:21:41',2,'KALDI'),(15,'IMPLEMENTOS DE ASEO','2021-03-17 10:37:11',2,'KALDI'),(16,'VIGILANCIA PRIVADA','2021-04-07 10:42:28',2,'KALDI');

--
-- Table structure for table `tiposdeingreso`
--

CREATE TABLE `tiposdeingreso` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tipo` varchar(50) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiposdeingreso`
--

INSERT INTO `tiposdeingreso` (`id`, `tipo`, `pv`) VALUES (1,'INSUMOS','KALDI'),(2,'NOMINA ','KALDI'),(3,'SERVICIOS','KALDI'),(4,'MANTENIMIENTO','KALDI'),(5,'BASE','KALDI');

--
-- Table structure for table `tiposdenovedad`
--

CREATE TABLE `tiposdenovedad` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tipodenovedad` varchar(50) DEFAULT NULL,
  `descuentoauxilio` int DEFAULT '0',
  `porcentajepagado` decimal(5,2) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  `cuenta_mediosdepago` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cc` (`descuentoauxilio`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiposdenovedad`
--


--
-- Table structure for table `tiquetsmediosdepago`
--

CREATE TABLE `tiquetsmediosdepago` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `mediodepago` varchar(200) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `idmesa` bigint unsigned NOT NULL DEFAULT '1',
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` int DEFAULT '0',
  `valor` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `cuenta_contable` int DEFAULT NULL,
  `esanticipo` tinyint unsigned DEFAULT '0',
  `idanticipo` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`cc`),
  KEY `idfactura` (`idmesa`)
) ENGINE=InnoDB AUTO_INCREMENT=32572 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tiquetsmediosdepago`
--

INSERT INTO `tiquetsmediosdepago` (`id`, `mediodepago`, `cc`, `idmesa`, `idcliente`, `idnc`, `valor`, `pv`, `cuenta_contable`, `esanticipo`, `idanticipo`, `anticpoencm`) VALUES (32571,'EFECTIVO',2,1,1,0,0,'KALDI',110505,0,0,0);

--
-- Table structure for table `tokenifood`
--

CREATE TABLE `tokenifood` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `token` text,
  `fecha` datetime DEFAULT NULL,
  `merchant_id` varchar(100) DEFAULT NULL,
  `catalog_id` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `client_secret` varchar(100) DEFAULT NULL,
  `url_ifood_authentication_token` varchar(250) DEFAULT NULL,
  `grantType` varchar(25) DEFAULT NULL,
  `clientId` varchar(250) DEFAULT NULL,
  `Secret` varchar(250) DEFAULT NULL,
  `refreshToken` varchar(1250) DEFAULT NULL,
  `urlcreararticulos` varchar(200) DEFAULT NULL,
  `urlparamirarlatienda` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tokenifood`
--


--
-- Table structure for table `tokenrappi`
--

CREATE TABLE `tokenrappi` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `COD_SATELITE` varchar(25) DEFAULT 'texasburgers',
  `token` text,
  `fecha` datetime DEFAULT NULL,
  `audience` varchar(100) DEFAULT NULL,
  `client_id` varchar(100) DEFAULT NULL,
  `client_secret` varchar(100) DEFAULT NULL,
  `urltoken` varchar(100) DEFAULT NULL,
  `urlmenu` varchar(200) DEFAULT NULL,
  `storeId` varchar(50) NOT NULL,
  `urlactivaciones` varchar(200) DEFAULT NULL,
  `taken` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tokenrappi`
--

INSERT INTO `tokenrappi` (`id`, `COD_SATELITE`, `token`, `fecha`, `audience`, `client_id`, `client_secret`, `urltoken`, `urlmenu`, `storeId`, `urlactivaciones`, `taken`) VALUES (2,'texasburgers','',NULL,'','','','','','lagringa','','');

--
-- Table structure for table `traslados`
--

CREATE TABLE `traslados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `referenciacruzada` int DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `factor` int DEFAULT '0',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `destino` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  `sku_traslados` varchar(25) DEFAULT NULL,
  `idmayor` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`),
  KEY `fk_traslados_idmayor` (`idmayor`),
  CONSTRAINT `fk_traslados_idmayor` FOREIGN KEY (`idmayor`) REFERENCES `mayorestraslados` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `traslados`
--


--
-- Table structure for table `trasladosauxiliar`
--

CREATE TABLE `trasladosauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmesa` int DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `origen` varchar(25) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃƒÂ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃƒÂ² el producto',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `factor` int DEFAULT '1',
  `unidaddemedida` varchar(50) DEFAULT NULL,
  `descripcion` varchar(50) DEFAULT NULL,
  `consecutivo` int DEFAULT '0',
  `referenciacruzada` int DEFAULT '0',
  `destino` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  `sku_traslados_auxiliar` varchar(25) DEFAULT NULL,
  `idcliente` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosauxiliar`
--


--
-- Table structure for table `trasladosdesdecaja`
--

CREATE TABLE `trasladosdesdecaja` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `usuario` varchar(100) DEFAULT NULL,
  `valor` int DEFAULT '0',
  `mediodepago` varchar(100) DEFAULT NULL,
  `idz` int DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosdesdecaja`
--


--
-- Table structure for table `trasladosentransito`
--

CREATE TABLE `trasladosentransito` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `consecutivo` int NOT NULL,
  `referenciacruzada` int DEFAULT '0',
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `origen` varchar(25) DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `descripcion` varchar(100) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  `sku` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosentransito`
--


--
-- Table structure for table `trasladosenviados`
--

CREATE TABLE `trasladosenviados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `referenciacruzada` int DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `factor` int DEFAULT '0',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `destino` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosenviados`
--


--
-- Table structure for table `trasladosrecibidos`
--

CREATE TABLE `trasladosrecibidos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `consecutivo` int NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `bruto` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `referenciacruzada` int DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `factor` int DEFAULT '0',
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `destino` varchar(25) DEFAULT NULL,
  `estado` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasladosrecibidos`
--


--
-- Table structure for table `trasteos`
--

CREATE TABLE `trasteos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` int DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trasteos`
--


--
-- Table structure for table `trazabilidad`
--

CREATE TABLE `trazabilidad` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `texto` text,
  `idfactura` bigint unsigned NOT NULL,
  `usuarioenvia` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idfactura_f` (`idfactura`)
) ENGINE=MyISAM AUTO_INCREMENT=2146 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trazabilidad`
--

INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES (1,'2025-09-15 14:46:28','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-15 14:46:27\",\r\n               \"tduedate\":\"2025-09-22\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 1,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                     \"stelephone\":\"3207434410\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 657\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"005095\",\r\n                  \"scustomname\":\"BANANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":925.92592592593,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',657,'7'),(2,'2025-09-15 14:46:28','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 17032 characters],sdebug1:[encoded data, 18480 characters],yapprovedbytaxoffice:D,scufe:c06297895c6084e4809d46f0b0b2134223624183b62b3b3731272342fa033c32c9e071b84c79da340fae69cf5fdaac14,sqr:NumFac: FECO1&#10;FecFac: 2025-09-15&#10;HorFac: 14:46:29-05:00&#10;NitFac: 1053877618&#10;DocAdq: 222222222222&#10;ValFac: 925.93&#10;ValIva: 0.00&#10;ValOtroIm: 74.07&#10;ValTolFac: 1000.00&#10;CUFE:&#10;c06297895c6084e4809d46f0b0b2134223624183b62b3b3731272342fa033c32c9e071b84c79da340fae69cf5fdaac14&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=c06297895c6084e4809d46f0b0b2134223624183b62b3b3731272342fa033c32c9e071b84c79da340fae69cf5fdaac14&#10;,ssignature:R4YWfe/CT5xenmpfjHXG/46dFIVwNdo8r39ThUoob0/u10C5UXvgBNcwC+cmAnyTLeK3XFhe/cs8CII3UNN8U9Y3R2G03PIDYFsktoQdMV40ZoSidVCefrXsERtupPaV+6S59sxUYLptqgW/v5YVF/45zjwGKRtN39m3ML9Qr5vvhwIIvfhlZEkgmLtB7nlTGCFvbczPzOM9g1tvVghNdawmyG9lq2gY7xJG0EE+kNKqySUOdKPd83ZbEm7TuiksggYUy+0h2nlsOYhLiapU+Z6+EoBj6HcdvMEr2s5Xkz12Zv2At00aDpJIeAhCpNKMd1t6IgT+e3xu1Isc8xLJ9w==,sdocumentreference:FECO1,rtaxxadocument:null,sref:FECO1,irefindex:1},sdebug:Taxxa: 0.288s DIAN: 0.498s (creación 0.498s, revalidación 0s baja 0s)}',657,'7'),(3,'2025-09-15 14:47:06','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-15 14:46:27\",\r\n               \"tduedate\":\"2025-09-22\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 2,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                     \"stelephone\":\"3207434410\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 657\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"005095\",\r\n                  \"scustomname\":\"BANANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":925.92592592593,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',657,'7'),(4,'2025-09-15 14:47:06','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 17032 characters],sdebug1:[encoded data, 18476 characters],yapprovedbytaxoffice:D,scufe:9f02d0af3382b881629e6ddfa01166052429e90e34ee63b2a8dc02898fb836db4b3a140b57e59918b70305b518a46238,sqr:NumFac: FECO2&#10;FecFac: 2025-09-15&#10;HorFac: 14:47:07-05:00&#10;NitFac: 1053877618&#10;DocAdq: 222222222222&#10;ValFac: 925.93&#10;ValIva: 0.00&#10;ValOtroIm: 74.07&#10;ValTolFac: 1000.00&#10;CUFE:&#10;9f02d0af3382b881629e6ddfa01166052429e90e34ee63b2a8dc02898fb836db4b3a140b57e59918b70305b518a46238&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9f02d0af3382b881629e6ddfa01166052429e90e34ee63b2a8dc02898fb836db4b3a140b57e59918b70305b518a46238&#10;,ssignature:H8PfodyfRzPoxeN5u50r8WG06JL8Ly5hjwEwNDXuneqvsSDhDkSmDizvhweMOGidFiEjDk2drxN6EECA0c3o905ZhfJX0W7aP2uca/w8m8OTFL3zV/O6RuI/UA1Yn8e7skij1beELmBvldn3bdNH6vz0/M7ZjGgfSkOUv6yr0bNYAC7UAfyElLLi79WEYMsNRlGh/xZkDn0OGd0drDVh27P7KHzdilMG91giIorSN9k/BDn4RQzi8c/Nf32w2X7Ptt7X8PdtA8Tw2rO1zWlPfPbGnQpkNY5FgRyJzI2CZO8gqgUMd0QvjzoTIc5dZB+Edc1TPVz7SFf2i5zfyZ1bZQ==,sdocumentreference:FECO2,rtaxxadocument:null,sref:FECO2,irefindex:2},sdebug:Taxxa: 0.305s DIAN: 0.469s (creación 0.469s, revalidación 0s baja 0s)}',657,'7'),(5,'2025-09-15 18:04:12','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 3,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                     \"stelephone\":\" 3207434410\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'5'),(6,'2025-09-15 18:04:12','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 15780 characters],sdebug1:[encoded data, 17112 characters],yapprovedbytaxoffice:D,scufe:6ed92f48775b977678040e2a5dda1a5609035fd0727215af8361f059912d526a9f23f516d0d3feb22e829d99f33481a0,sqr:NumFac: FECO3&#10;FecFac: 2025-09-11&#10;HorFac: 18:04:13-05:00&#10;NitFac: 1053877618&#10;DocAdq: 222222222222&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;6ed92f48775b977678040e2a5dda1a5609035fd0727215af8361f059912d526a9f23f516d0d3feb22e829d99f33481a0&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=6ed92f48775b977678040e2a5dda1a5609035fd0727215af8361f059912d526a9f23f516d0d3feb22e829d99f33481a0&#10;,ssignature:kOSIZlBfuaHSkeJZtbaAVXdL7Ah3O7jKRAM1SzYmcIBSuTBLxSrD7A2RM9JAt7su3AyUmUY/3A2ZVQRoOdCfrNXDtQS0rwzuMvOtbE8tflwdx03Ter/X3Ez/nAZjtHfx+81nW354H6m3wJtZ9RffYktf7s+yglfLFWQlwk+A71mNKkWzycEE4u2W91LJxhPhfFif+jHLcJeyOWyhIdq9ER3R6dYT/gURLiJiCfbgJisOxL+WrNe8y8zMIjIpx+TDF965I848ozqN6tN18aYzp8y6GWPAdy5dBCFc9fzzhhgW91p59ZL7lA9v4zK/Xq6C1UgyMMqXK4g1V5D/vB3bCg==,sdocumentreference:FECO3,rtaxxadocument:null,sref:FECO3,irefindex:3},sdebug:Taxxa: 0.287s DIAN: 0.306s (creación 0.306s, revalidación 0s baja 0s)}',375,'5'),(7,'2025-09-15 19:14:15','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 4,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"805014047-7\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'5'),(8,'2025-09-15 19:14:15','{rerror:2092,smessage:Taxxa - The Buyer NIT identification should contain only numbers. It should NOT contain the validation digit or dashes.}',375,'5'),(9,'2025-09-15 19:40:25','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 4,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'5'),(10,'2025-09-15 19:40:25','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17864 characters],yapprovedbytaxoffice:D,scufe:5f672f12b64b0a4f2ce0d8409ee17842cd3f3a1680bf9d7efb4b10d8b32597db98f5188d91e43da9fa6c61564f321b97,sqr:NumFac: FECO4&#10;FecFac: 2025-09-11&#10;HorFac: 19:40:26-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;5f672f12b64b0a4f2ce0d8409ee17842cd3f3a1680bf9d7efb4b10d8b32597db98f5188d91e43da9fa6c61564f321b97&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=5f672f12b64b0a4f2ce0d8409ee17842cd3f3a1680bf9d7efb4b10d8b32597db98f5188d91e43da9fa6c61564f321b97&#10;,ssignature:osN9SBoTl0KJxi12Ennc16hjwXRqa+8URxZUXpab0MIF/0NVjNS1YevwUAyvwzuQxMG75L8c/flKQ+BVOJwUjaft2i7YcwAlN7ZekYmX5BGHk1SNiXdO4WqNmAg+9DaMQw41uQqI1/B0rBySxZEAcnfOcrOXjTKEgtYYlLN9XpgR/nyRd2VWLCSabqequ2VmdxnTqa9CQ0LkOIfgX3CKHOz2zzflqt+icxJ2Xx63dm095A83peNZP4cBwvTI/nhPyAtohpHulzAGq2ifWiKElvKiOWUbsRoODEW8ltjGrgt32h4hVGex4T9MnIAifVIaUvJo/haWyhdSyVGWWy4P8g==,sdocumentreference:FECO4,rtaxxadocument:null,sref:FECO4,irefindex:4},sdebug:Taxxa: 0.311s DIAN: 0.427s (creación 0.427s, revalidación 0s baja 0s)}',375,'5'),(11,'2025-09-15 19:43:03','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 5,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'5'),(12,'2025-09-15 19:43:03','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17860 characters],yapprovedbytaxoffice:D,scufe:07d04d91a7ef9c72b6b7146835a6e7de3316fa9506aa1fd2efd7e7a201a4799deb044895f5c9dc99f0399eed80744402,sqr:NumFac: FECO5&#10;FecFac: 2025-09-11&#10;HorFac: 19:43:04-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;07d04d91a7ef9c72b6b7146835a6e7de3316fa9506aa1fd2efd7e7a201a4799deb044895f5c9dc99f0399eed80744402&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=07d04d91a7ef9c72b6b7146835a6e7de3316fa9506aa1fd2efd7e7a201a4799deb044895f5c9dc99f0399eed80744402&#10;,ssignature:OFpRlt+9vxZ5zpH+cZHI8aqIUs6iLDA/MVnGVv9AySFkWujcA36Rj3trrx6q84EXylO9Jg16C+W1qMcPhggA1yVLTIVbZCxs7PyxSXhvQM1rZDcAweRzekAkTkuHvkDkxDGRwyMUebmrwYzZMj+mOQdU3uPq4baHBOtS9SNFmWzySt4a2pzn/JTHlS9yu7u3MJYY/EFXApznyQz/pLloya3udySGilmAyQGCypsggRUsjNENok9FgKH7Kv7x/4bLtalTVJZtuoBy48hzoRNUOC+F33PCg7OEhR7K5tKALLACHohNX3oe6J2FIeTIRUWvlMQpgc5PPm2e0a7d8823fQ==,sdocumentreference:FECO5,rtaxxadocument:null,sref:FECO5,irefindex:5},sdebug:Taxxa: 0.3s DIAN: 0.542s (creación 0.542s, revalidación 0s baja 0s)}',375,'5'),(13,'2025-09-15 19:46:40','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 6,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'2'),(14,'2025-09-15 19:46:40','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17860 characters],yapprovedbytaxoffice:D,scufe:254d519d8fc0f2c17641d66d42f2c19460fa99841768e547051b512f75a575f701425304915f3d8faf9441883b5c6532,sqr:NumFac: FECO6&#10;FecFac: 2025-09-11&#10;HorFac: 19:46:42-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;254d519d8fc0f2c17641d66d42f2c19460fa99841768e547051b512f75a575f701425304915f3d8faf9441883b5c6532&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=254d519d8fc0f2c17641d66d42f2c19460fa99841768e547051b512f75a575f701425304915f3d8faf9441883b5c6532&#10;,ssignature:fPn3FViay2952D+UqaxrGq50Lk4ebU4b3/XR+6UC6459v3wjE12qwzmMeo2iNHkv4DnRmvhKnmvdxGmOuTpgqvTzk6RH2+G1A5trlH4wpwa00X8MTXuWenbgdXGjSTHZSH+KwnFPhz5wmvvDdBVSNTO+dfPpxoh9/mp1Z0hbYDCITug4j+gkawfRDr+32IL8Q0rNJ8d4AxK6Z+x+GejveSW0X42n8GrbT9XuyEjStMduczVzXz40rNli5Skxmwjgaa8eTtE42Dx9HBVWAYrnd1DV+QHc4AtMFizG8x/x8BGyRdwlgQ7KO7yFv2FRbARrSWTD3xAQc+gWlOATwc/riA==,sdocumentreference:FECO6,rtaxxadocument:null,sref:FECO6,irefindex:6},sdebug:Taxxa: 0.284s DIAN: 0.293s (creación 0.293s, revalidación 0s baja 0s)}',375,'2'),(15,'2025-09-15 19:49:57','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 7,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'2'),(16,'2025-09-15 19:49:57','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17860 characters],yapprovedbytaxoffice:D,scufe:fba3d849e8136d54ff0e51ee6bbea08e87f8ca7b5ebe1dd0d9e830e02ed4c3456e17e525a1596332f15036cdc2e0d7ae,sqr:NumFac: FECO7&#10;FecFac: 2025-09-11&#10;HorFac: 19:49:57-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;fba3d849e8136d54ff0e51ee6bbea08e87f8ca7b5ebe1dd0d9e830e02ed4c3456e17e525a1596332f15036cdc2e0d7ae&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=fba3d849e8136d54ff0e51ee6bbea08e87f8ca7b5ebe1dd0d9e830e02ed4c3456e17e525a1596332f15036cdc2e0d7ae&#10;,ssignature:O8JmU1Vmeq9BkAp7heFgSKFIhTjRrOC6fPIEh82ddjPmOz79uRythfCD+HTLJvSsTUOWxiwK0Q+cQE4yWQ00vPnpS0SrmWd434BuaL1nVIdH9vSOjMq5P82lUia+/5QaF7QmIVrV9EZj1nL2MZ44ZE0dTDWN01YJyIPGnsxk3aNLLHGF1VY2zIXnqt0LI++ypkgj5511c52Maw7aS+/rM7RJwYpBjJnh3wGbfNgVtI594MOoYJTLgn6Ab5O4Q4b1LEcDC/wghI04rPZ2IRCsfx7V4aBvHJQR7QuOYhBKsbM05LZ9ncvT4UV1ncWoqw+uBjj0mt6mw2kv6HQuEgYvCA==,sdocumentreference:FECO7,rtaxxadocument:null,sref:FECO7,irefindex:7},sdebug:Taxxa: 0.293s DIAN: 0.376s (creación 0.376s, revalidación 0s baja 0s)}',375,'2'),(17,'2025-09-15 19:52:11','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 8,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'1'),(18,'2025-09-15 19:52:11','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17852 characters],yapprovedbytaxoffice:D,scufe:868fa73b4ab39b04b8599dc9be6db272da52e8c11c69fcfb22b2c1e1341a2dac770dc31d5ba1e18e019b1b2fc5357813,sqr:NumFac: FECO8&#10;FecFac: 2025-09-11&#10;HorFac: 19:52:12-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;868fa73b4ab39b04b8599dc9be6db272da52e8c11c69fcfb22b2c1e1341a2dac770dc31d5ba1e18e019b1b2fc5357813&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=868fa73b4ab39b04b8599dc9be6db272da52e8c11c69fcfb22b2c1e1341a2dac770dc31d5ba1e18e019b1b2fc5357813&#10;,ssignature:lwh+4l+xdCj203Ofa4TvwTM63rD2owH0ds5FrgtRaD0CaLPAgQDwIE7Tol8JfhOiuBBMnlgUQX0W7D0geGlL4EwzT5R6GgvYcroF3KLheIT9dW/jvPS8Oo8RPofiCCPziNUUUueISbbYstjNKOkkJC2vae5rt5RYpmytNEF3vUngx8pcyTsgxdIba0U4MOuq+Wst971NfVVq5uYGa6L6lKkML2bbwa+PZ5o9iWHxOqTAGLyAqVekYlLymqIGRPeNQS4/V/Hwf7B3oikzDlfbaK+D/Z+BDGMfzrRvYxxopnE/7NPx1+hmUpKRB49vXlr6CQ0CnpgVkJE8yrsTG7dEXA==,sdocumentreference:FECO8,rtaxxadocument:null,sref:FECO8,irefindex:8},sdebug:Taxxa: 0.345s DIAN: 0.337s (creación 0.337s, revalidación 0s baja 0s)}',375,'1'),(19,'2025-09-15 19:53:17','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 9,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'1'),(20,'2025-09-15 19:53:17','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17852 characters],yapprovedbytaxoffice:D,scufe:b9bea69726a511b0162a19e755268428a0468553e0634f15d4db89a0b99c6d3151aac971c1e6c031fd43b39c53e14457,sqr:NumFac: FECO9&#10;FecFac: 2025-09-11&#10;HorFac: 19:53:18-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;b9bea69726a511b0162a19e755268428a0468553e0634f15d4db89a0b99c6d3151aac971c1e6c031fd43b39c53e14457&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b9bea69726a511b0162a19e755268428a0468553e0634f15d4db89a0b99c6d3151aac971c1e6c031fd43b39c53e14457&#10;,ssignature:KSgyTMWLH4fSJSGfP/bnA/BRzBjII21gvKgJu6X0nmsAgGJtqO6iJMuM/tnwXR0C21qRSSfpVUBKVagp4KqxBjmpTW/cYTOXw/P3moxbE4fwzQ8nvm2jr9ijGusC+AyWjl1VvWpkqzUx/2Y9WKAfjQKrCNnKETpkrEXKRXDJLBLGauTZl+cdro8AxHFgApjwmdLuhqiPBdDTpKUkGqS8ENfkNH6dAQXaDB1xtrZBRv25x/GjaBw+gV/0CaGfZ/LnZ5wljYM1/SuNge2gNeN5tu5FgOuQ0JiJXiWVk71w1WJwq5Qm5uUTtBnVasUWLiABpoStQpKMrlVvTmzVVioreg==,sdocumentreference:FECO9,rtaxxadocument:297474615,sref:FECO9,irefindex:9},sdebug:Taxxa: 0.285s DIAN: 0.335s (creación 0.335s, revalidación 0s baja 0s)}',375,'1'),(21,'2025-09-15 19:55:44','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 10,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'1'),(22,'2025-09-15 19:55:44','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17864 characters],yapprovedbytaxoffice:D,scufe:6bd04698395da2e91904d3481b8da396b53c42cf11062d14a2d09fdda28fd641602f6283ee08f180589a511e7194b563,sqr:NumFac: FECO10&#10;FecFac: 2025-09-11&#10;HorFac: 19:55:44-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;6bd04698395da2e91904d3481b8da396b53c42cf11062d14a2d09fdda28fd641602f6283ee08f180589a511e7194b563&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=6bd04698395da2e91904d3481b8da396b53c42cf11062d14a2d09fdda28fd641602f6283ee08f180589a511e7194b563&#10;,ssignature:giTFk6vgysrulypItPQfBzDfhos9/pzNYOscc+KP13wudKTSEqyNWhai9iyEOkBWOlu+yyqUsDseHrddivzAnTJajld1xeM2jPcOdD7GBvn4hMvtq7nXXN3kLQLX5rJM0wTwjxqPHXloeFRJqziR+1+VLWal9UOvZEnftOlzTq8yRgXjsChkho5FgeP5woMAWNcBiMUznjDWKNeRhguFXijBLrBrS7W340le46n9f0PBRAIbIHPIFBB6X4WMt42zzY+MymXKSD3hh99wrMcFwD9t6TMopvDkpjBjvKA8sH86oiuVR6KZApFBnvX9HwOXubG7XXsAk/XTvR8IV2pbYA==,sdocumentreference:FECO10,rtaxxadocument:null,sref:FECO10,irefindex:10},sdebug:Taxxa: 0.316s DIAN: 0.959s (creación 0.959s, revalidación 0s baja 0s)}',375,'1'),(23,'2025-09-15 19:57:31','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 11,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'1'),(24,'2025-09-15 19:57:31','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 16456 characters],sdebug1:[encoded data, 17860 characters],yapprovedbytaxoffice:D,scufe:87026d64c81cc11bd9470d33e9774b32268663df42cdf4b92d3bb9a8f44c77db4ec55d3ecd2e46a7a0dec8d4c60a5ea7,sqr:NumFac: FECO11&#10;FecFac: 2025-09-11&#10;HorFac: 19:57:32-05:00&#10;NitFac: 1053877618&#10;DocAdq: 80501404&#10;ValFac: 13000.00&#10;ValIva: 0.00&#10;ValOtroIm: 0.00&#10;ValTolFac: 13000.00&#10;CUFE:&#10;87026d64c81cc11bd9470d33e9774b32268663df42cdf4b92d3bb9a8f44c77db4ec55d3ecd2e46a7a0dec8d4c60a5ea7&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=87026d64c81cc11bd9470d33e9774b32268663df42cdf4b92d3bb9a8f44c77db4ec55d3ecd2e46a7a0dec8d4c60a5ea7&#10;,ssignature:ORkXyAhoe6jgXYwKc53i2L7m8VAG2S9X4EtkCek10GTaEqsbjMWyaXm1VvPnDHPBpKHrm36GugzXb6jNKqt6B0N32se+SzshNv/bQxPnPHwyxbK+F/n4L4XDfqdAjHlUYQVrZHSMFrbuJUUhsTbjT8LdclbWboPiFuXJ/yH/DETH3STicTvDgkj01Cmk0z3LYwlNU2+NdenGxD0NWZpMQJHtka22Wk4O73S0BXIy8bvE/mhzhoLw/BUMOc2gT2ObtSTd9d68wYxXmFlhwqKQRLC76za33pW4hnaF4Zmvtv/ClzAHHOjBAfS7rIVtMa9llMsTzWFUutXALpVxYOnK0Q==,sdocumentreference:FECO11,rtaxxadocument:null,sref:FECO11,irefindex:11},sdebug:Taxxa: 0.289s DIAN: 0.327s (creación 0.327s, revalidación 0s baja 0s)}',375,'1'),(25,'2025-09-15 19:59:45','{\r\n      \"sToken\":\"393035418116\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-09-11 18:24:29\",\r\n               \"tduedate\":\"2025-09-18\",\r\n            \"sDocumentPrefix\":\"\",\r\n            \"sDocumentSuffix\": 12,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n\r\n            \"snotetop\":\"CAPPRI COOKIES & COFFEE\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"AVANCE MEDICO\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"80501404\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nicol  Palomino \",\r\n                     \"selectronicmail\":\"gerencia@avancemedico.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"60\",\r\n                        \"wtowncode\":\"17000\",\r\n                        \"scityname\":\"MANIZALES\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"170001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 375\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"002689\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"002690\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"1053877618\",\r\n                    \"saddresszip\":\"170001\",\r\n                    \"wdepartmentcode\":\"60\",\r\n                    \"wtowncode\":\"17000\",\r\n                    \"scityname\":\"MANIZALES\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"CAPPRI & COFFE\",\"jcontact\":{\r\n                        \"scontactperson\":\"ADRIANA SANCHEZ TICONO\",\r\n                        \"selectronicmail\":\"cappri.0.2@gmail.com\",\r\n                        \"stelephone\":\"3207434410\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"60\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17000\",\r\n                           \"scityname\":\"MANIZALES\",\r\n                           \"saddressline1\":\"AV KEVIN ANGEL MALL PLAZA SZ2 PISO 2\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"170001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',375,'1'),