-- 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=21 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,'PAPELERIA','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'),(17,'GASOLINA','2025-11-13 14:59:43',2,'KALDI'),(18,'MENSAJERÍA','2025-11-15 18:59:45',2,'KALDI'),(20,'INSUMOS','2025-11-15 21:43:22',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=5064 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 (2052,'EFECTIVO',2,1,3,0,0,'KALDI',NULL,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=579 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES (1,'2025-10-11 22:44:28','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-11 22:35:14\",\r\n               \"tduedate\":\"2025-10-18\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 86,\r\n            \"snotetop\":\"\", \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\":\"wiseexperiencecoffee@gmail.com\",\r\n                     \"stelephone\":\" \",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 3\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"009\",\r\n                  \"scustomname\":\"JUGO NATURAL EN AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0010\",\r\n                  \"scustomname\":\"SANDWICH TRADICIONAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3703.7037037037,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"0011\",\r\n                  \"scustomname\":\"PAPAS DE LA CASA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"0012\",\r\n                  \"scustomname\":\"AMERICANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"0013\",\r\n                  \"scustomname\":\"BOTELLA DE AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2037.037037037,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',3,'5'),(2,'2025-10-11 22:44:28','{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[encoded data, 14704 characters],sdebug1:[encoded data, 15976 characters],yapprovedbytaxoffice:D,scufe:64b5cbfd246ecff9dd76c40eca1b28e139f79ea81bf4a4e2db87e1f7b7c0cc9010abe3c3f9392a6521236b176264e319,sqr:NumFac: FE86&#10;FecFac: 2025-10-11&#10;HorFac: 22:35:14-05:00&#10;NitFac: 901818640&#10;DocAdq: 222222222222&#10;ValFac: 34907.41&#10;ValIva: 0.00&#10;ValOtroIm: 2792.59&#10;ValTolFac: 37700.00&#10;CUFE:&#10;64b5cbfd246ecff9dd76c40eca1b28e139f79ea81bf4a4e2db87e1f7b7c0cc9010abe3c3f9392a6521236b176264e319&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=64b5cbfd246ecff9dd76c40eca1b28e139f79ea81bf4a4e2db87e1f7b7c0cc9010abe3c3f9392a6521236b176264e319&#10;,ssignature:aatF/heBp7mGA+UlGhKBxTBznUrc4aigquGL/BSoHt/HdjEF9nb8IsF0pkRSoJZ1iotGodf7j5sLGG4XjVC1FaAORZLIoHHpqY6TJkDqBBdxeJgxBMYCpfD0vLFSDw/8TJ59Ey1O8ZGrNShFB85iEJRcLPIlfYcHBImWEc+uf023iDmONhkId6Rt1F1GdraHkcvufLoXydbIKBip66GpRKchZ8PuCwHF7HbC1mNjIx9rjhMGx+i2NYhv0XpMYkgT6o+/vFNbMBivJZ5b5ljAGdlCLLknmJ7as/WoEfS0nJR44lknPGlPBWvIcaAMKh/qOIWRYjTML6hA3wCVrXrIDw==,sdocumentreference:FE86,rtaxxadocument:312793635,sref:FE86,irefindex:86},sdebug:Taxxa: 0.327s DIAN: 0.305s (creación 0.305s, revalidación 0s baja 0s)}',3,'5'),(3,'2025-10-11 22:44:57','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-11 00:00:00\",\r\n               \"tduedate\":\"2025-10-18\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 87,\r\n            \"snotetop\":\"\", \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\":\"wiseexperiencecoffee@gmail.com\",\r\n                     \"stelephone\":\" \",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 3\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"009\",\r\n                  \"scustomname\":\"JUGO NATURAL EN AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0010\",\r\n                  \"scustomname\":\"SANDWICH TRADICIONAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3703.7037037037,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"0011\",\r\n                  \"scustomname\":\"PAPAS DE LA CASA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"0012\",\r\n                  \"scustomname\":\"AMERICANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"0013\",\r\n                  \"scustomname\":\"BOTELLA DE AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2037.037037037,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',3,'5'),(4,'2025-10-11 22:44:57','{rerror:9001,smessage:Taxxa - Duplicación de consecutivo de factura para documento: FE87}',3,'5'),(5,'2025-10-11 22:53:57','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-11 22:53:57\",\r\n               \"tduedate\":\"2025-10-18\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 88,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"VENTAS DE MOSTRADOR   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 4\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0016\",\r\n                  \"scustomname\":\"PAPAS DE LA CASA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0017\",\r\n                  \"scustomname\":\"AGUILA LIGHT\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":3,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"0018\",\r\n                  \"scustomname\":\"AMERICANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2777.7777777778,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',4,'5'),(6,'2025-10-11 22:53:57','{rerror:9001,smessage:Taxxa - Duplicación de consecutivo de factura para documento: FE88}',4,'5'),(7,'2025-10-11 22:56:42','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-11 22:53:57\",\r\n               \"tduedate\":\"2025-10-18\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 89,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"VENTAS DE MOSTRADOR   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 4\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0016\",\r\n                  \"scustomname\":\"PAPAS DE LA CASA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0017\",\r\n                  \"scustomname\":\"AGUILA LIGHT\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":3,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"0018\",\r\n                  \"scustomname\":\"AMERICANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2777.7777777778,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',4,'5'),(8,'2025-10-11 22:56:42','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16668 characters],yapprovedbytaxoffice:Y,scufe:85fad0c6635555536d99d0e470b101f927114780ac603deb6c40bcf6b73e4929876f76a57456fa30aadf7b0dfec6ef12,sqr:NumFac: FE89&#10;FecFac: 2025-10-11&#10;HorFac: 22:53:57-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 40740.74&#10;ValIva: 0.00&#10;ValOtroIm: 3259.25&#10;ValTolFac: 43999.99&#10;CUFE:&#10;85fad0c6635555536d99d0e470b101f927114780ac603deb6c40bcf6b73e4929876f76a57456fa30aadf7b0dfec6ef12&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=85fad0c6635555536d99d0e470b101f927114780ac603deb6c40bcf6b73e4929876f76a57456fa30aadf7b0dfec6ef12&#10;,ssignature:A/fXv6DhuP9VQVXYrUbY5YCUQyRGTr+gwFQrFvrLqiwI+MhDc8Lg1ffFWxhc08AQgmSpu3vvpxCc2dGe1CH8ltyZc+L/C4msCAfLtbR7V401KLzwdbxLWbX2ZYRLh0pB1LiXNlOLqfAgOZEv1WsYPk89NlQsA++yMTkVfpbPbIMCd9keottnylbY5x71Rj50jaXCwfyAHfPK0oIAu8IO/01Zrj8+foeBp2jURheUlfvWJOEM5kJwvpcQ/dB7gaJ06XrAaSGX9KQjTKL9kOG0Kmbt+FBuVcn6SMhAMTpny7WQqa0Q/J2jaQ/TUcOhAbRlXinR0OmlwVuDqIlqeeCtuw==,sdocumentreference:FE89,rtaxxadocument:312795839,sref:FE89,irefindex:89},sdebug:Taxxa: 0.345s DIAN: 0.912s (creación 0.664s, revalidación 0.248s baja 0s)}',4,'5'),(9,'2025-10-16 08:44:14','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-16 08:42:30\",\r\n               \"tduedate\":\"2025-10-23\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 90,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"JUAN ESTEBAN RAMIREZ RODRIGUEZ\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"1087494007\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"JUAN ESTEBAN RAMIREZ RODRIGUEZ\",\r\n                     \"selectronicmail\":\"JUANRAMIREZ12153388@GMAIL.COM\",\r\n                     \"stelephone\":\" 3136623878\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66088\",\r\n                        \"scityname\":\"BELEN DE UMBRIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"664040\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 5\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0019\",\r\n                  \"scustomname\":\"AFFOGATO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":8333.3333333333,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',5,'18'),(10,'2025-10-16 08:44:14','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16672 characters],yapprovedbytaxoffice:Y,scufe:d4b6259e26e22306c52d5544cf7b033b2f02b7e55aed6afb65e6fc99ccbf26efc763286a3ebeb666268191b82aa840a2,sqr:NumFac: FE90&#10;FecFac: 2025-10-16&#10;HorFac: 08:42:30-05:00&#10;NitFac: 901818640&#10;DocAdq: 1087494007&#10;ValFac: 8333.33&#10;ValIva: 0.00&#10;ValOtroIm: 666.67&#10;ValTolFac: 9000.00&#10;CUFE:&#10;d4b6259e26e22306c52d5544cf7b033b2f02b7e55aed6afb65e6fc99ccbf26efc763286a3ebeb666268191b82aa840a2&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d4b6259e26e22306c52d5544cf7b033b2f02b7e55aed6afb65e6fc99ccbf26efc763286a3ebeb666268191b82aa840a2&#10;,ssignature:foCPtC1jBL6CwLQNV5h6P3Cv7dFIKdtbBB9m21MdM0NdrPVsWgJtg/PVMCRUAUhhdlyl/d4J65J4npbiZGEVIvxH5ocmPP9dtKp1pNV4GtLr3TEyfzg1PmORyL1GsjKAvdHZDCYe4+3TaUrt/XMeAgeVwNj+x/M+wTjtxTbDOsRT40BxkKzy00XQXphGq1IpRTnZjOXqMV+4Btmcip7oKSROXhbeo1XtppZT6KyzoWgk7XFEHI1il1sohNQWIzTWxsp8LEWPnNpf7MDxWjN32jwrKOMwLlFa60YlhboXiUrBj5bTBCZG5cIRMDjpgTJF7dTDWl7stOYCN578pJQLSQ==,sdocumentreference:FE90,rtaxxadocument:314939084,sref:FE90,irefindex:90},sdebug:Taxxa: 0.348s DIAN: 1.316s (creación 0.715s, revalidación 0.601s baja 0s)}',5,'18'),(11,'2025-10-16 22:01:32','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-16 21:58:10\",\r\n               \"tduedate\":\"2025-10-23\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 91,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"48\",\r\n                  \"scustomername\":\"AGROPECUARIA KINAGRO S.A.S\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"900618127\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"AGROPECUARIA KINAGRO S.A.S \",\r\n                     \"selectronicmail\":\"agrokinagro@gmail.com\",\r\n                     \"stelephone\":\" 3104130444\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"05\",\r\n                        \"wtowncode\":\"05001\",\r\n                        \"scityname\":\"MEDELLIN\",\r\n                        \"saddressline1\":\"CR 51 6 SUR 95\",\r\n                        \"szip\":\"050001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 7\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0023\",\r\n                  \"scustomname\":\"LATTE CALIENTE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0024\",\r\n                  \"scustomname\":\"HAMBURGUESA MICHUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":18518.518518519,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',7,'5'),(12,'2025-10-16 22:01:32','{rerror:9001,smessage:Taxxa - Duplicación de consecutivo de factura para documento: FE91}',7,'5'),(13,'2025-10-20 00:00:04','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 13:05:00\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 93,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"LUZ AMPARO RODRIGUEZ HINCAPIE   \",\r\n                     \"selectronicmail\":\"camilaramirez@utp.edu.co\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66088\",\r\n                        \"scityname\":\"BELEN DE UMBRIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"664040\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 21\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0061\",\r\n                  \"scustomname\":\"HAMBURGUESA SOMBA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15740.740740741,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0062\",\r\n                  \"scustomname\":\"HAMBURGUESA SOMBA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15740.740740741,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"0063\",\r\n                  \"scustomname\":\"HAMBURGUESA SOMBA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15740.740740741,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"0064\",\r\n                  \"scustomname\":\"PASTEL DE POLLO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5370.3703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"0065\",\r\n                  \"scustomname\":\"PASTEL DE POLLO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5370.3703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"0066\",\r\n                  \"scustomname\":\"PASTEL DE POLLO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5370.3703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"7\":{\r\n                  \"sStandardItemIdentification\":\"0067\",\r\n                  \"scustomname\":\"BOLA HELADO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2777.7777777778,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"8\":{\r\n                  \"sStandardItemIdentification\":\"0068\",\r\n                  \"scustomname\":\"TORTA DE CHOCOLATE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7870.3703703704,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',21,'5'),(14,'2025-10-20 00:00:04','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16668 characters],yapprovedbytaxoffice:Y,scufe:bd0c9356a21be5c0a6d0ae830617475ce535f2f4b7fd791505d3eb571c3f096217d546510258f60fc678f77d9a50c8d6,sqr:NumFac: FE93&#10;FecFac: 2025-10-20&#10;HorFac: 13:05:00-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 73981.48&#10;ValIva: 0.00&#10;ValOtroIm: 5918.52&#10;ValTolFac: 79900.00&#10;CUFE:&#10;bd0c9356a21be5c0a6d0ae830617475ce535f2f4b7fd791505d3eb571c3f096217d546510258f60fc678f77d9a50c8d6&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=bd0c9356a21be5c0a6d0ae830617475ce535f2f4b7fd791505d3eb571c3f096217d546510258f60fc678f77d9a50c8d6&#10;,ssignature:WEIjvjkGNRwm61yrdLhlwiKblqPpW0+RnhNTWE41/Zr8rdIyesvaIXAcGpRQr27SOdBXKtCn0nZzj5QKiv4czHfZvWnK72VzRSbKug39CYX4MvXwp1Pnnw8IjpI9MFgGQ62Ktsx27b6yIgncKlVgQqqxo58emaHMo1fQPsUQkJjsKWr5MJrudCCeWKuUQx//PYGRcOw1fJrN3KSgKM3miLeGabyOXEZNMkowtLjm6sw63l9eEZgQlBhRlbGSsU9vCKQIe0kf1lajyQvPAT7M07lMquNPSHBIw+t2fA4zj0QVT+9uHrxs6ZCKYgVFmayBZVmC/WRF8gZDgZnh+vzGmw==,sdocumentreference:FE93,rtaxxadocument:317182522,sref:FE93,irefindex:93},sdebug:Taxxa: 0.461s DIAN: 1.012s (creación 0.581s, revalidación 0.431s baja 0s)}',21,'5'),(15,'2025-10-20 00:01:21','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 13:19:16\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 94,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 22\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0076\",\r\n                  \"scustomname\":\"HUEVOS RANCHEROS\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":9259.2592592593,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',22,'5'),(16,'2025-10-20 00:01:21','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16676 characters],yapprovedbytaxoffice:Y,scufe:637e8439d26758cc2c956d7d06bf8145e42b98f401459985db90a75d460b11c1f08496db2075ee9b86fdfcd051dcdc2a,sqr:NumFac: FE94&#10;FecFac: 2025-10-20&#10;HorFac: 13:19:16-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 9259.26&#10;ValIva: 0.00&#10;ValOtroIm: 740.74&#10;ValTolFac: 10000.00&#10;CUFE:&#10;637e8439d26758cc2c956d7d06bf8145e42b98f401459985db90a75d460b11c1f08496db2075ee9b86fdfcd051dcdc2a&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=637e8439d26758cc2c956d7d06bf8145e42b98f401459985db90a75d460b11c1f08496db2075ee9b86fdfcd051dcdc2a&#10;,ssignature:G8DOgf9nt1gCR2pX9ArC3Z3H0xpIef7Bad43N129S5oUK4LUAYbV6ISHSPg2ZEJ4vjjiVGbv2/AZKzuyESkPWg7TKHxxWTPa4ThIeRjpc5+Zd/MgQkI0iHAkSJajyzGpfcRulI1joCBSKY4zSuBf9T2GEThXVU5SexR9L9UGlKRBf0pX9dSd2aXXaD6bVoJMpPbQondMACKLlSCNhJMadVrUvl/H3/dHcAB1ZyYIite9Y5RaYpRIoP5qxL4TV12RhgyudtgmGsi+xnrZRgwuL7EP/iKjq7TDdSJMbQGxPnchTy+/7lnjnD6UzG4ST22wb46K+h0suitjin1spUxIAw==,sdocumentreference:FE94,rtaxxadocument:317182547,sref:FE94,irefindex:94},sdebug:Taxxa: 0.345s DIAN: 0.899s (creación 0.558s, revalidación 0.341s baja 0s)}',22,'5'),(17,'2025-10-20 00:02:26','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 13:21:38\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 95,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"VENTA DIRECTA\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"VENTADIRECTA\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTA DIRECTA   \",\r\n                     \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 23\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0077\",\r\n                  \"scustomname\":\"LIMONADA DE PIÑA Y HIERBABUENA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6944.4444444444,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',23,'5'),(18,'2025-10-20 00:02:26','{rerror:4727,smessage:Taxxa - Buyer document type CC, CE or NIT have some letters in it. Please make sure to only send numbers and do NOT send the validation digit.,sdebug:Provided: VENTADIRECTA}',23,'5'),(19,'2025-10-20 00:06:04','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 13:22:56\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 95,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"JIMMY ZULETA\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"18612448\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"JIMMY ANDRES ZULETA MONCADA\",\r\n                     \"selectronicmail\":\"JIANZUMO1@GMAIL.COM\",\r\n                     \"stelephone\":\"3137702114\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66088\",\r\n                        \"scityname\":\"BELEN DE UMBRIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"664040\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 24\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0078\",\r\n                  \"scustomname\":\"HUEVOS RANCHEROS\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":9259.2592592593,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',24,'5'),(20,'2025-10-20 00:06:04','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16672 characters],yapprovedbytaxoffice:Y,scufe:77563b8bdc05564ae0d2083e77f5dd7bb1b24618ddc74d5d401b0c4ffbcbe35781ab755722530ecd61388737cea077fa,sqr:NumFac: FE95&#10;FecFac: 2025-10-20&#10;HorFac: 13:22:56-05:00&#10;NitFac: 901818640&#10;DocAdq: 18612448&#10;ValFac: 9259.26&#10;ValIva: 0.00&#10;ValOtroIm: 740.74&#10;ValTolFac: 10000.00&#10;CUFE:&#10;77563b8bdc05564ae0d2083e77f5dd7bb1b24618ddc74d5d401b0c4ffbcbe35781ab755722530ecd61388737cea077fa&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=77563b8bdc05564ae0d2083e77f5dd7bb1b24618ddc74d5d401b0c4ffbcbe35781ab755722530ecd61388737cea077fa&#10;,ssignature:O6tsNlLR4Y2Mq2//8w/YWVyuqLqqnJOdtfrtYbBOOMw0JC0VQj5LBNquoqIt6k9b0i8bBSXjkbkaWHU8gUBHYo7FHZsbQXR3eF9vd7mg0z05gHznRt4eqoGLiKxe8mCee0ukmV/DdHLlMMCxwvmv0f4H4dwnFsaCKz0uedsyB/bCID/vPqNz1ZByqn2bzMj2SfpoBmmnwS6V/ucUQF41rQuCjQoZKXSz+kQM0/8XLwL4X0IkYNqrko3PgcK4F5gyOVC+iUQ9b8CxsQtY4+NeFyLzhWbw+iMM3/YDMJp1TWhmB4Z3dp6l07MLYRJGjPGCVGGKil5ji9ff68lZ1uCysQ==,sdocumentreference:FE95,rtaxxadocument:317182698,sref:FE95,irefindex:95},sdebug:Taxxa: 0.34s DIAN: 0.914s (creación 0.624s, revalidación 0.29s baja 0s)}',24,'5'),(21,'2025-10-20 00:06:41','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 13:25:04\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 96,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"JIMMY ZULETA\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"18612448\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"JIMMY ANDRES ZULETA MONCADA\",\r\n                     \"selectronicmail\":\"JIANZUMO1@GMAIL.COM\",\r\n                     \"stelephone\":\"3137702114\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66088\",\r\n                        \"scityname\":\"BELEN DE UMBRIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"664040\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 25\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0079\",\r\n                  \"scustomname\":\"AREPA CON QUESO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":4166.6666666667,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0080\",\r\n                  \"scustomname\":\"AMERICANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"0081\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"0082\",\r\n                  \"scustomname\":\"CAPUCCINO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"0083\",\r\n                  \"scustomname\":\"AMERICANO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',25,'5'),(22,'2025-10-20 00:06:41','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16672 characters],yapprovedbytaxoffice:Y,scufe:d2d94502392e974d669f16b55527d41282b34b205b9824eb7f65ca41f7c7e8f4ca568cd18cdc568977a11ef1a58257f9,sqr:NumFac: FE96&#10;FecFac: 2025-10-20&#10;HorFac: 13:25:04-05:00&#10;NitFac: 901818640&#10;DocAdq: 18612448&#10;ValFac: 19907.41&#10;ValIva: 0.00&#10;ValOtroIm: 1592.59&#10;ValTolFac: 21500.00&#10;CUFE:&#10;d2d94502392e974d669f16b55527d41282b34b205b9824eb7f65ca41f7c7e8f4ca568cd18cdc568977a11ef1a58257f9&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d2d94502392e974d669f16b55527d41282b34b205b9824eb7f65ca41f7c7e8f4ca568cd18cdc568977a11ef1a58257f9&#10;,ssignature:DIa/FU2PkyHrXZcSBEfU5bHHs2W6LFBRM3k+7FeysswBAbeAOtLRWdq+/ZYevPZ9XRxoyg6mXKw8uLr2KCEi2kXX5GFoM/wbohrNOhGYb7xUkbMpmNK/qKu+JLEO2j7rYF3s2SckjLtjl97BGCFN7at+dfUzpvptD4uF1M8jTOiCSq0IG0NmgIB5PUSeaTc0et7MWj6XP+2LfXXLjT5ZvXfea8bSWRoEbExJUmcr6tI+4lVMiAunzzjp2fTwBlpSoYePjGpbpxtyTe13QwhAL4kfbW04lE0ZWUdBh+N/SDC39kH18GuXYvunhdNZmSeYlgIDkoKcIbPSN/i7ECHrqQ==,sdocumentreference:FE96,rtaxxadocument:317182734,sref:FE96,irefindex:96},sdebug:Taxxa: 0.349s DIAN: 0.954s (creación 0.643s, revalidación 0.311s baja 0s)}',25,'5'),(23,'2025-10-20 00:07:25','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 16:32:11\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 97,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 26\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0086\",\r\n                  \"scustomname\":\"CERVEZA ARTESANAL VASO 330 ML\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7407.4074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0087\",\r\n                  \"scustomname\":\"CERVEZA ARTESANAL VASO 330 ML\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7407.4074074074,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',26,'5'),(24,'2025-10-20 00:07:25','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16672 characters],yapprovedbytaxoffice:Y,scufe:3f44b8f2f77970b957110394db3c21c3392a2c7bd58a46183c07508cf9b17db1ecb3e107b8a4b45b1dca0e73aaec8be4,sqr:NumFac: FE97&#10;FecFac: 2025-10-20&#10;HorFac: 16:32:11-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 14814.81&#10;ValIva: 0.00&#10;ValOtroIm: 1185.18&#10;ValTolFac: 15999.99&#10;CUFE:&#10;3f44b8f2f77970b957110394db3c21c3392a2c7bd58a46183c07508cf9b17db1ecb3e107b8a4b45b1dca0e73aaec8be4&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=3f44b8f2f77970b957110394db3c21c3392a2c7bd58a46183c07508cf9b17db1ecb3e107b8a4b45b1dca0e73aaec8be4&#10;,ssignature:Ur4Hs0GsbF/98mmDv7HWgHIusP/0a3mymvMXrxX+O71as/cRl48zXx5Tcy4pr8IEQW134UuhepTRW9siSL9fAmsOHV1QCRV7frAR5cQJG231EjaMcQ2R+V2NyMyJbl1RgY60Qe2hYW3IwvMdOsEiQeGm5vz5/GBDeEIV2zyr4xiA85MP6eOuT2U8iysd1Ji71iu8XR5U9EUth1RMZfDT7w7CFm1CSYRaE+Cejh6e1LEcEp25ySkHjYFfM1QEGJskBW0oKwY/EZgF13SCzVEzhe3+YP1fRsBx8QmzXp/ENILT8W+iA6/xo5xg0ZtWoGKkvfA5AhUHMBxhB25dLZ1m6A==,sdocumentreference:FE97,rtaxxadocument:317182787,sref:FE97,irefindex:97},sdebug:Taxxa: 0.353s DIAN: 1.098s (creación 0.829s, revalidación 0.269s baja 0s)}',26,'5'),(25,'2025-10-20 00:08:03','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 16:55:13\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 98,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 27\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0089\",\r\n                  \"scustomname\":\"PAPAS ESPECIALES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14814.814814815,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',27,'5'),(26,'2025-10-20 00:08:03','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16680 characters],yapprovedbytaxoffice:Y,scufe:67c8a59dc44cb003d539172179e908ac8244430b4c6bac9a620bcac5f8639fcfec178e0b4aae50c9a11cd5cdf4a8c7de,sqr:NumFac: FE98&#10;FecFac: 2025-10-20&#10;HorFac: 16:55:13-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 14814.81&#10;ValIva: 0.00&#10;ValOtroIm: 1185.19&#10;ValTolFac: 16000.00&#10;CUFE:&#10;67c8a59dc44cb003d539172179e908ac8244430b4c6bac9a620bcac5f8639fcfec178e0b4aae50c9a11cd5cdf4a8c7de&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=67c8a59dc44cb003d539172179e908ac8244430b4c6bac9a620bcac5f8639fcfec178e0b4aae50c9a11cd5cdf4a8c7de&#10;,ssignature:MwB3EFLdMD1iXyw9V9tI57i77v/fXAxOG3I1rZgLRCwNK6TMLCA55kAufzxnBC6dd8wXS3bBXMGXxB8tZ5cDl5Z50HlLhzZojZtvHaTeUqHiq6IILVFwwWFqoYDvcwzulfA3tw8rMLNPk8yH1yPyBOVh/Cpz1kS8E4FuUz6pYXaSvWDzopY1konXAZ2FEQ3eZc1mw5i1w9gEnKqvHmkt7qth8j6bYtpXbAEh/q6teLRh6lEGFQ5XJTyA/wLwn67tqAVLEzYwhIrYhc1lsReRtO21jZt6agFAcqZj2r7C+cTHwLnSgWnSPF0nsHvPItVT39mYqyJAWrqRAUNBAwOp+w==,sdocumentreference:FE98,rtaxxadocument:317182841,sref:FE98,irefindex:98},sdebug:Taxxa: 0.37s DIAN: 0.89s (creación 0.572s, revalidación 0.319s baja 0s)}',27,'5'),(27,'2025-10-20 00:08:38','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 17:52:22\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 99,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 28\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0090\",\r\n                  \"scustomname\":\"HAMBURGUESA MICHUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":20833.333333333,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',28,'5'),(28,'2025-10-20 00:08:38','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16672 characters],yapprovedbytaxoffice:Y,scufe:0783c225987c29843aaf6ca57f52aa172847be48aaecdfb006e6cf5801f4591ba5753a458bb1c9c0d93096ea4a592f43,sqr:NumFac: FE99&#10;FecFac: 2025-10-20&#10;HorFac: 17:52:22-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 20833.33&#10;ValIva: 0.00&#10;ValOtroIm: 1666.67&#10;ValTolFac: 22500.00&#10;CUFE:&#10;0783c225987c29843aaf6ca57f52aa172847be48aaecdfb006e6cf5801f4591ba5753a458bb1c9c0d93096ea4a592f43&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=0783c225987c29843aaf6ca57f52aa172847be48aaecdfb006e6cf5801f4591ba5753a458bb1c9c0d93096ea4a592f43&#10;,ssignature:G1+QDPClvBjGmjpJUvjVa3qS9PklI+LfiuvvHLrFXvKPpELI6eLhOTZlmwUSEXJepj1Bq9zI4+qGfNluuUFKKFo9skjl8ejzpEJ7bxzeDe+/7VFAbra58I8TNxx60+BI7zscMCdklGnJC8jWYn/+OqCFdi8OOhrewvpTBse/C7A0We9ct3jkKfdCAm5uymhMXVqmu2k8tuFnIhMdAbgbytBK58IgNBpksbDHa9G4h5OQpv5pKQm02hXHHlrtb3HB3EP36gRO6T0+tYPD+9YLu4fXdRQZM//frqhJ3DJXrRgzoi8cHFE5qSZO3iM/VztD27lrvXnNRl5GkyfEmmd4qw==,sdocumentreference:FE99,rtaxxadocument:317182901,sref:FE99,irefindex:99},sdebug:Taxxa: 0.362s DIAN: 0.85s (creación 0.583s, revalidación 0.267s baja 0s)}',28,'5'),(29,'2025-10-20 00:09:28','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 17:56:04\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 100,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 29\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0091\",\r\n                  \"scustomname\":\"HAMBURGUESA SOMBA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15740.740740741,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"0092\",\r\n                  \"scustomname\":\"SANDWICH TRADICIONAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":4629.6296296296,\r\n                  \"icount\":2,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',29,'5'),(30,'2025-10-20 00:09:28','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16676 characters],yapprovedbytaxoffice:Y,scufe:87c5a12c04c37157377edc58825115550e87f000aaea1a56ee5ab53cb4acb648e2a7f4eb1af9dab597cee6d5a7087d34,sqr:NumFac: FE100&#10;FecFac: 2025-10-20&#10;HorFac: 17:56:04-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 25000.00&#10;ValIva: 0.00&#10;ValOtroIm: 2000.00&#10;ValTolFac: 27000.00&#10;CUFE:&#10;87c5a12c04c37157377edc58825115550e87f000aaea1a56ee5ab53cb4acb648e2a7f4eb1af9dab597cee6d5a7087d34&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=87c5a12c04c37157377edc58825115550e87f000aaea1a56ee5ab53cb4acb648e2a7f4eb1af9dab597cee6d5a7087d34&#10;,ssignature:JgveJM+MYC++cqeC5d/0o27+jTVbdBJ63l0zMFvCIvo+IB011twZiuY5JPOxgdo/DeBh20gQAijh9vrMIp6OPix4qIK6+9YRzyfc+YYGgSgIkoF3izZUGnbSb4sVzpciuxuSm8SU3xPLs4aUXC49AwbS6EVmCvnOzlXYmtPksjkJuTkyILuEOsIMFODtmrsqrlOB+U+mpomxMPWtu+VvwX6vajZslrHoprthXuWa7HaddanEMQtbIcaYXl74t4/SOrl7Pe6jpuvMJx8123KKu6Pyb1+ZL4eHiTXrL4VD4hcy1uf5Yh/f15IvB7hBA+PSZ66ra9CP/3SuN28hZ4zpLA==,sdocumentreference:FE100,rtaxxadocument:317182974,sref:FE100,irefindex:100},sdebug:Taxxa: 0.35s DIAN: 0.817s (creación 0.548s, revalidación 0.269s baja 0s)}',29,'5'),(31,'2025-10-20 00:10:05','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 18:05:59\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 101,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 30\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0094\",\r\n                  \"scustomname\":\"CAFÉ TABI LAVADO MOLIDO * 500 G\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":35185.185185185,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',30,'5'),(32,'2025-10-20 00:10:05','{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.}},jret:{sreturnedxml:[encoded data, 15180 characters],sdebug1:[encoded data, 16676 characters],yapprovedbytaxoffice:Y,scufe:9f4874484a5ba5259b9a30a4f417bc12ca8cec7f00bbf8dff4286a2c98de7f362fe76bde60728ddb0eaafa5b9ddb37ea,sqr:NumFac: FE101&#10;FecFac: 2025-10-20&#10;HorFac: 18:05:59-05:00&#10;NitFac: 901818640&#10;DocAdq: 2222222222&#10;ValFac: 35185.19&#10;ValIva: 0.00&#10;ValOtroIm: 2814.81&#10;ValTolFac: 38000.00&#10;CUFE:&#10;9f4874484a5ba5259b9a30a4f417bc12ca8cec7f00bbf8dff4286a2c98de7f362fe76bde60728ddb0eaafa5b9ddb37ea&#10;https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9f4874484a5ba5259b9a30a4f417bc12ca8cec7f00bbf8dff4286a2c98de7f362fe76bde60728ddb0eaafa5b9ddb37ea&#10;,ssignature:kEZalKnhm4W30hHoqaJi2NxLeMcvgHjDtOh9+FNlJCJaaWHwmUf8YI9Be5tm/3+7U4PXBLeaCWp2Hmxi8PfyCi8QhiG4jScxxN9DpE3syXc39ymUU6y7b70px72GsbdSuUplv23g8kS5cZJqD+4kCD/InsJFn0DumKlyOFgyxyFSKwF+X8B98iYndSo6B0mHUyua1ctYq9BsnfDWMreQJrx15rgcTWVXJzvpbRNChJ0ZK+tKtE6EkAF2Bdo4fyJJYvFTcQaWrPCFsRz2skdXAX6JzCPpjHFt2lcza3f20dTQtpzQ7fq69lriRs2+y2DbAPxuBABIeVDl0+DvvMRsBA==,sdocumentreference:FE101,rtaxxadocument:317183040,sref:FE101,irefindex:101},sdebug:Taxxa: 0.345s DIAN: 0.86s (creación 0.583s, revalidación 0.277s baja 0s)}',30,'5'),(33,'2025-10-20 00:10:49','{\r\n      \"sToken\":\"465900756096\",\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            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-10-19 18:22:13\",\r\n               \"tduedate\":\"2025-10-26\",\r\n            \"sDocumentPrefix\":\"FE\",\r\n            \"sDocumentSuffix\": 102,\r\n            \"snotetop\":\"\", \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\":\"2222222222\" \r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTAS DE MOSTRADOR   \",\r\n                     \"selectronicmail\":\"facturacionelectronicaventas@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 31\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"0095\",\r\n                  \"scustomname\":\"PASTEL DE GUAYABA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3888.8888888889,\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\":\"901818640\",\r\n                    \"saddresszip\":\"664040\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66088\",\r\n                    \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"WISE COFFEE S.A.S BIC\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"CAROL JULIANA ZULETA MONCADA\",\r\n                        \"selectronicmail\":\"wiseexperiencecoffee@gmail.com\",\r\n                        \"stelephone\":\"3105002959\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66088\",\r\n                           \"scityname\":\"BELÉN DE UMBRÍA\",\r\n                           \"saddressline1\":\"CRA 10 6-39\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"664040\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ',31,'5'),