INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2116, '2025-04-29 11:23:53', '{rerror:1,smessage:{string:{0:Regla: 90, Rechazo: Documento procesado anteriormente.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:7319bc878ddd6d24aaa38ee22692af35ef92af3e2a6dfe6a7a23f18b1a1bc2533386505e39fdc3f81472ff371f1df210,sqr:SETP990000981 2025-04-29 16:23:54-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 7319bc878ddd6d24aaa38ee22692af35ef92af3e2a6dfe6a7a23f18b1a1bc2533386505e39fdc3f81472ff371f1df210 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=7319bc878ddd6d24aaa38ee22692af35ef92af3e2a6dfe6a7a23f18b1a1bc2533386505e39fdc3f81472ff371f1df210,ssignature:vOIN8EliW290K7IHcjBLkkmMlusa+rczuu0UQQk4sYiRTxAdvpIUPi9x4GwPQjVRLcZ9+DneYfK6j0OQvk65e6dL8dcG6j8kJb5FNQj4bOFoMGMNeyQnqnuTFUs6+17cSzHiCSe8GpvJ3EQpfo9kISyf/WP/fDPdv85/Pf1CL7xFHDTvKmTjoRiPNMUgc21qmphlmvA8ORxsLocZwINHTlZ/b6YbaU/smqCOzhafHCwyMAhaSugWI4v3/3D71i0PENf+101obj2SFHjNTRTfh49G17ePDq1gwpkURPoNk18vItafnrga+zUYXeRvgpe4VXEIXEUfSDegTbaKobu8mg==,sdocumentreference:SETP990000981,rtaxxadocument:220671725,sref:SETP990000981,irefindex:990000981},sdebug:Taxxa: 0.297s DIAN: 0.8s (creación 0.8s, revalidación 0s baja 0s)}', 47781, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2117, '2025-04-29 11:23:53', '{rerror:0,smessage:{string:{0:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:be046252f6c13d51913bd5741baade32c709b5a8c47d3e0c6b5399d0cc6adc0bdf200915f714eb404adc9cc874465cf3,sqr:SETP990000981 2025-04-29 16:23:54-05:00 901402281 222222222222 50462.96 0.00 4037.04 54500.00 be046252f6c13d51913bd5741baade32c709b5a8c47d3e0c6b5399d0cc6adc0bdf200915f714eb404adc9cc874465cf3 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=be046252f6c13d51913bd5741baade32c709b5a8c47d3e0c6b5399d0cc6adc0bdf200915f714eb404adc9cc874465cf3,ssignature:fyvPkshpOI94oxVC5Y+SfoRmSLqkF+naXTT5rgKkWwmzT1mDS/MJmzMERojGK/rl8+DJc2lojgdBU9+pbkYaBYju+jJqHHHRcYVehJY+DvrOXtW/FOlM0inbKgspfC493MYzBIBA5zpVM85Ni8nbizQDN1Xbt+/Mhy5fLJ0V8Z/0jbXoVhwXjR9t73T4dpX6ahpeQh2lozYa6Kw7NxBT7k/KOpw0ly2xF1dg56kdroyI95u/fC2N8tztW5SE8xLQsEdnHInzOhtOJmmnc18VI5SiS0ep7b55gzv5KT+iI88EOMqqEUGeC/BhJrHbl2dJcIUn+1QGms/rzRqNLDTgNg==,sdocumentreference:SETP990000981,rtaxxadocument:null,sref:SETP990000981,irefindex:990000981},sdebug:Taxxa: 0.313s DIAN: 1.46s (creación 1.162s, revalidación 0.298s baja 0s)}', 47704, '2'),
(2118, '2025-04-29 11:24:02', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-29 11:23:39\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 982,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\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\":\"   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47781\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47781, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2119, '2025-04-29 11:24:02', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:0e698705674adc30513e05138ba7d69a3e1a5601ac2d7e43218ec5357fc17df7577819f381be60acd17057e80a7e68e7,sqr:SETP990000982 2025-04-29 16:24:03-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 0e698705674adc30513e05138ba7d69a3e1a5601ac2d7e43218ec5357fc17df7577819f381be60acd17057e80a7e68e7 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=0e698705674adc30513e05138ba7d69a3e1a5601ac2d7e43218ec5357fc17df7577819f381be60acd17057e80a7e68e7,ssignature:hDRvQTqTt6yYWUBdIVWOFX2DArgqliYZqZhGsDp0nup8ym2/MK9hwBRVllctNJCCFUAWV66Bg7baaDBuWp/qlrjJBsNyfrDAADthBb/oSUwlki27gRFzjrtzi1QDV5aT1wiZsiJFdbRwQpizSp7epp1wSTCxM3lPjOfj8aqPkmhH9kdk1wqELAPweC1EgLMChhe1HzE0XqKKdoycFFqJNjUouF3BmsBN8nchXJH8GA7AUy67d7XEH6T16i1VvJ/GHU5CuLetkSQIQbdIU7wb1mNO3sFbIFPxWVo7wOrcsyJ1ybPJdTsa3REthsuYkQErjYV75+0Xs9v/hbL1d6M4/w==,sdocumentreference:SETP990000982,rtaxxadocument:220671868,sref:SETP990000982,irefindex:990000982},sdebug:Taxxa: 0.481s DIAN: 1.104s (creación 0.811s, revalidación 0.293s baja 0s)}', 47781, '2'),
(2120, '2025-04-29 11:24:10', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-29 11:23:39\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 983,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\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\":\"   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47806\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622749\",\r\n                  \"scustomname\":\"SALCHICHA ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":3000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622750\",\r\n                  \"scustomname\":\"SALCHICHA ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":3000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47806, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2121, '2025-04-29 11:24:10', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:db6ab0b75938c089d8ed3bdb9e7f7c3da31a2b46d5e14fe3d2d7814ef89f1307601431bc20272031b3b42ea349cebd91,sqr:SETP990000983 2025-04-29 16:24:11-05:00 901402281 222222222222 6000.00 0.00 0.00 6000.00 db6ab0b75938c089d8ed3bdb9e7f7c3da31a2b46d5e14fe3d2d7814ef89f1307601431bc20272031b3b42ea349cebd91 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=db6ab0b75938c089d8ed3bdb9e7f7c3da31a2b46d5e14fe3d2d7814ef89f1307601431bc20272031b3b42ea349cebd91,ssignature:FW95Nx0Alym+UNunI8Ly2ElHRrurrdbrGVFFNSMuQTbu3zjt57qmwN3QLdQ9OU16R/qzEhSF21bWx/NMsJHl6cg/k7KoqfSpdwpjiXo5uufMcczy18jyR6e9bbsrAQqZCmkO2k0RX30dn3tDhcwKsTqOZA5TkeWnLzAN7j2ZLLWnGLjqLhJvjvpydEzJIcb7ETreHFOzhkjxqgq+qxN3OaA23SaFG4q2hnQAxcDpWUrkxRtV/+gfWDA78/QpJBa5yOEWnmYDpLFeRcuDUPuKryEbRy5Tq44Kte7rmkgeDrozpORbxbBWmzku6fLLeC7P/mlHzm2GeEJPsQjZLOCKHw==,sdocumentreference:SETP990000983,rtaxxadocument:220671985,sref:SETP990000983,irefindex:990000983},sdebug:Taxxa: 0.259s DIAN: 0.959s (creación 0.642s, revalidación 0.317s baja 0s)}', 47806, '2'),
(2122, '2025-04-29 20:08:16', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-29 20:08:16\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 984,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"asdkfl@asasfd.asdfcom\",\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: 47869\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622898\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":2 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622899\",\r\n                  \"scustomname\":\"MANGO EN AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8900,\r\n                  \"icount\":200 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622900\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA MORA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":13000,\r\n                  \"icount\":12 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47869, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2123, '2025-04-29 20:08:16', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:3b7d38ae22761eb8df1d0e494f78460345342e205760110f70bcdfeea1e28fe699ee75be43cb34a62c94473b525e870b,sqr:SETP990000984 2025-04-29 01:08:16-05:00 901402281 222222222222 1951600.00 0.00 0.00 1951600.00 3b7d38ae22761eb8df1d0e494f78460345342e205760110f70bcdfeea1e28fe699ee75be43cb34a62c94473b525e870b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=3b7d38ae22761eb8df1d0e494f78460345342e205760110f70bcdfeea1e28fe699ee75be43cb34a62c94473b525e870b,ssignature:BPKFLchyKoih3fHY/uw1ap7qK0ZwdXtoCV0SA/IpjahgnUFCe2Nzp1NcvijDlulkQuG2+0GsL+84ERtoapcrK4XDY250YJ0uoqqGA+JBKapafghb3+nTJHJJ31ocxerD6MqPyHX6I3V/scvgORY8nbC3s7eoD36HxpbzOwDsRYJHU+4/EmlJ1Ld+6fkVzAxlWfT6b9YCSCO0msL5nwqAy7ZVuOn68qwwiPRQ565Sr7sLKzuR7SlK5c7gP/1ijrwTaMDT/MWKZQDo2Q0qWcspecBiy9ulMa0SC9nPOyFoJ+KH37n43j7WzEL2SAFTV7fND7yNPPrsEic52aKwXWABiw==,sdocumentreference:SETP990000984,rtaxxadocument:221044819,sref:SETP990000984,irefindex:990000984},sdebug:Taxxa: 0.319s DIAN: 1.041s (creación 0.657s, revalidación 0.384s baja 0s)}', 47869, '2'),
(2124, '2025-05-02 15:20:04', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-29 11:23:39\",\r\n               \"tduedate\":\"2025-05-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 985,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\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\":\"   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47700\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":240740.74074074,\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\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47700, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2125, '2025-05-02 15:20:04', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,2:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000985 2025-04-29 15:20:05-05:00 901402281 222222222222 240740.74 0.00 19259.26 260000.00 cf559e1e7d5fa5222b1c52dd75b6b67a95eb113b51fea51fa866b3f4256623413e0ee361c89558f48e2f82178458b3f2 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=cf559e1e7d5fa5222b1c52dd75b6b67a95eb113b51fea51fa866b3f4256623413e0ee361c89558f48e2f82178458b3f2,ssignature:Lj9g/9ctXc+wL9sWQ4DktlmtEvelsIGc5sgyN2b9PmlKCe40skK3vGiz6IhrNBU/fiIFBhJMm5k+C6u138Km8mWsU+1W9XoiNVvQyIra9faieLIOBNyESBKL/fmGe51XsBtb1ebP336J0kmWvX0cwSkzNMQoTbMC1IcgVc97G+eB4MUDsyhP1Oprx0Fa3xmzLSxcVRw9zwEw8/6D0fX4OzARpWKz+GK+GygAjhmGR4kVMoR90g2vkpAw20bKeGJeYpWwmf1DRPcasymNc9pm2lgvKXVIcm6fIY6CnpqaM8ymMZRmQMwIZJbTQXecIVlOKQBD/hAq+iYEsLInEu0Ejg==,sdocumentreference:SETP990000985,rtaxxadocument:222638523,sref:SETP990000985,irefindex:990000985},sdebug:Taxxa: 0.304s DIAN: 1.38s (creación 0.63s, revalidación 0.751s baja 0s)}', 47700, '2'),
(2126, '2025-05-20 18:41:17', '{\r\n      \"sToken\":\"396316085266\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-05-20 18:41:17\",\r\n               \"tduedate\":\"2025-05-20\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 985,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"O-23\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"raul   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"9874704\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"raul   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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: 47891\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622937\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622938\",\r\n                  \"scustomname\":\"MANGO EN AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8900,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622939\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA MORA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":13000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47891, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2127, '2025-05-20 18:41:17', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:487edd45cefc195e1fbb162365ee35662cd2acedb06414552f04adb848ff13eb2a73218b8918f1b02ae713304d1882b4,sqr:SETP990000985 2025-05-20 18:41:17-05:00 901402281 9874704 29700.00 0.00 0.00 29700.00 487edd45cefc195e1fbb162365ee35662cd2acedb06414552f04adb848ff13eb2a73218b8918f1b02ae713304d1882b4 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=487edd45cefc195e1fbb162365ee35662cd2acedb06414552f04adb848ff13eb2a73218b8918f1b02ae713304d1882b4,ssignature:gGxExQjMvhFw76Wy8Zl+bMBMZ5uEnpgce8agbw8tscO2KErqNOtAEy99GlevVF5c5mp8/0i4uP9BhJxt0EM1nW9AiPJQRisoeM3LKchI4bDbewlYvqDj4/JkTyrx76Ssr5aNgFoSIO3NaE4LFliI0UPEH4hTKmY23ssxSkT0PgVyjKz7XIo5w+13KqdZarKAKD/hc9o7peGr8Yjmhp/T5UTwl6N+2HSyoR2l5naiRL23Glp/Xa92BGC+71HxhAIN7DL1hdT4VXDCXZd+8htG+6WfphdP3OncQ2OM/9kK7M/nuuwvZdfHLD2qMCLpqytL6EOuzn+0o44v+Wf0vM2D0Q==,sdocumentreference:SETP990000985,rtaxxadocument:null,sref:SETP990000985,irefindex:990000985},sdebug:Taxxa: 0.259s DIAN: 0.57s (creación 0.57s, revalidación 0s baja 0s)}', 47891, '2'),
(2128, '2025-05-20 19:22:24', '{\r\n      \"sToken\":\"396316085266\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-05-20 18:41:17\",\r\n               \"tduedate\":\"2025-05-20\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 986,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"O-23\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"jpepi   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"9874704\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"jpepi   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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: 47891\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622937\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622938\",\r\n                  \"scustomname\":\"MANGO EN AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8900,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622939\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA MORA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":13000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47891, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2129, '2025-05-20 19:22:24', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:01dec671c5d721b4393f0e098279af585e2d89926bd7c5ce6ec1ce5caf08a3dadab1106efd4b67cce3f3684ac7534df2,sqr:SETP990000986 2025-05-20 19:22:24-05:00 901402281 9874704 29700.00 0.00 0.00 29700.00 01dec671c5d721b4393f0e098279af585e2d89926bd7c5ce6ec1ce5caf08a3dadab1106efd4b67cce3f3684ac7534df2 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=01dec671c5d721b4393f0e098279af585e2d89926bd7c5ce6ec1ce5caf08a3dadab1106efd4b67cce3f3684ac7534df2,ssignature:QE+jctN0wLmMQdZnTOOx/N8IBWgcSg7mwCzNDJ0KZzkM3YMh5SS8/lMSpKHUg0hSlPIlXg7zjzuSFWMJUFP6GXwNQhuDYIlg5cgocpyBU5sIlDniy94zxaStQc2fC6bnOxMoZ0MKmRJLluyQoUYXhpHqK9Qf6gKuOLXt1IQFz5abRS3gws2zDvO/z/Q+V+gct/pyGZLe7qdx7Yi+kbN0G+KhFakim414prpS2j7XL4HH4s2qH6RKwxn0IrEDdVi4JEwEZTCfUK2mavC1CnwC6HYALQ5gZdQWCfx+LTLxN4zxnrXAJy9YiUaUW8xW5q6H9LeqtuxT9P0sE7S5NHc5bg==,sdocumentreference:SETP990000986,rtaxxadocument:232801913,sref:SETP990000986,irefindex:990000986},sdebug:Taxxa: 0.294s DIAN: 1.814s (creación 1.122s, revalidación 0.691s baja 0s)}', 47891, '2'),
(2130, '2025-05-20 20:00:59', '{\r\n      \"sToken\":\"396316085266\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-05-20 20:00:59\",\r\n               \"tduedate\":\"2025-05-20\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 987,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47892\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622940\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622941\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA MORA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":13000,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622942\",\r\n                  \"scustomname\":\"MANGO EN AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8900,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622943\",\r\n                  \"scustomname\":\"MORA EN AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":15300,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47892, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2131, '2025-05-20 20:00:59', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:7e3b51d0bd5ee88e1729e027c9a515d52d2141a833adff390571db523f90848f0d273f2999f3377e0839b6dba23ae9df,sqr:SETP990000987 2025-05-20 20:01:00-05:00 901402281 222222222222 45000.00 0.00 0.00 45000.00 7e3b51d0bd5ee88e1729e027c9a515d52d2141a833adff390571db523f90848f0d273f2999f3377e0839b6dba23ae9df https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=7e3b51d0bd5ee88e1729e027c9a515d52d2141a833adff390571db523f90848f0d273f2999f3377e0839b6dba23ae9df,ssignature:EUzQHFbSjqEagnczjf278uUMxGPvaZqRmjp6UlXvTew8dyw8sQoNtpdvN2vd6p7lRWuZOWt7pVLzfXCeK64wkg/E4x1oHam8Ixrf+ii51Gtg9qL/E2RG0K4YWcrbRq2845eUYhI35gzWUQ719cN86Jymyi5ojbQG4O/lXy8TSgGIrpxuVupZVKvIHT+v/3cp/dCYiX4a64RezLaoQG2WROv7gIbcOvtUSBMtd88FoWHYlN2yFfy+qOK1qVrK84+p9RY8e9/s3v8mQ61x0KO72T52DHjAty3mFpC0LuT834nXuhst4DtfjEYhiXU0d7+f/Q0UuSRIEnDmwmgtbS9fWQ==,sdocumentreference:SETP990000987,rtaxxadocument:232823039,sref:SETP990000987,irefindex:990000987},sdebug:Taxxa: 0.311s DIAN: 1.386s (creación 0.694s, revalidación 0.691s baja 0s)}', 47892, '2'),
(2132, '2025-05-20 20:03:11', '{\r\n      \"sToken\":\"396316085266\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-05-20 20:03:11\",\r\n               \"tduedate\":\"2025-05-20\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 988,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"O-23\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"ghjkllñkjklñjLKÑJlkjJ lkj ñlkj lkñ\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"9874704\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"ghjkllñkjklñjLKÑJlkjJ lkj ñlkj lkñ\",\r\n                     \"selectronicmail\":\"raulotalvaro@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: 47893\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622947\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622948\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA MORA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":13000,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622949\",\r\n                  \"scustomname\":\"MANGO EN AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8900,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622950\",\r\n                  \"scustomname\":\"MORA EN AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":15300,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47893, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2133, '2025-05-20 20:03:11', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:34dd945021565cd4f6c0e1b23335bb155baa97123990032dfe542934ae757bd6112400eb83c65e9ac826cf68cc3f6753,sqr:SETP990000988 2025-05-20 20:03:12-05:00 901402281 9874704 45000.00 0.00 0.00 45000.00 34dd945021565cd4f6c0e1b23335bb155baa97123990032dfe542934ae757bd6112400eb83c65e9ac826cf68cc3f6753 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=34dd945021565cd4f6c0e1b23335bb155baa97123990032dfe542934ae757bd6112400eb83c65e9ac826cf68cc3f6753,ssignature:FGY8Ez9W8MGVyHlabNE2QoMoOd8E3Co6Pev22zkuV/1TwX9tAzTuCeujwyW36F9G5ZIlAx1JMfiRuzjG/BJ3lub+zxZDAaGVme6ba5GbXGd7KMiU3Yr6n265WnY/MUksT5LW02w8Qgh3vaKTmYOvMG/uA08PYbXtJ1ACdoQ287Ks5VyLmnNxqz1MebHlz9tHaaaEJ//QEwCeVRB1wK432jFAhov9ugUNjnXx+4LE6sPaqDA4Gt2JLI4ZeinIREQ22n5njJuC4xGRK7OwhLhh4MetXEM6QhJT8HPpnX2G2dT8zKX6g/7cOOf80yOWTYNywWp/SgYl2WZLMAiLuIJHCg==,sdocumentreference:SETP990000988,rtaxxadocument:232823942,sref:SETP990000988,irefindex:990000988},sdebug:Taxxa: 0.35s DIAN: 5.196s (creación 1.006s, revalidación 4.189s baja 0s)}', 47893, '2'),
(2134, '2025-05-20 20:30:50', '{\r\n      \"sToken\":\"396316085266\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-05-20 20:30:50\",\r\n               \"tduedate\":\"2025-05-20\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 989,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47895\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622955\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA MORA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":13000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47895, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2135, '2025-05-20 20:30:50', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:a90978af5fafeb7234a8689d1020d6094e444a6d9529260162de748dbccda8d50af1430ce90a13ca0955b5739d028d5e,sqr:SETP990000989 2025-05-20 20:30:51-05:00 901402281 222222222222 13000.00 0.00 0.00 13000.00 a90978af5fafeb7234a8689d1020d6094e444a6d9529260162de748dbccda8d50af1430ce90a13ca0955b5739d028d5e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a90978af5fafeb7234a8689d1020d6094e444a6d9529260162de748dbccda8d50af1430ce90a13ca0955b5739d028d5e,ssignature:KHvyeTR8rppHhD/Vj15OKB7DxVaRfevRbqbJUmO6rr+ZwGlkUHBZ5KIU/Qc+rp9Yykd8KDpH3wn8gWVbLm6RdN0duP0ABxL3BIh8W3lfr31PS+IN/VKfpdWV2hLf7w+fxHinC6sn97TgHqF5GG/+M94AOUNaDV2QllU4Hu7SIfgpeZ9r15m0dFJFlbGQxGz45+IZkWieT5ywtJv3c5js6wMwCM8zxU/xMgvTATS0pn3laajJKn2FsDgWMz+nd6D33OI332zC09hdjZvIWRLNPZv6raQ7AFrX6iwkvpC/wq6jZv/L5YHedjO90cLoukIYm6IePwHqrV0q5MEL3V1Zrg==,sdocumentreference:SETP990000989,rtaxxadocument:232835155,sref:SETP990000989,irefindex:990000989},sdebug:Taxxa: 0.418s DIAN: 1.042s (creación 0.618s, revalidación 0.424s baja 0s)}', 47895, '2'),
(2136, '2025-05-26 13:16:13', '1. Parece que tu token ha expirado, En el módulo de configuracion tirilla se puede actualizar', 48923, '2'),
(2137, '2025-05-26 13:28:41', '{\r\n      \"sToken\":\"396316085266\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-05-26 13:28:41\",\r\n               \"tduedate\":\"2025-06-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 990,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 48924\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00623983\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 48924, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2138, '2025-05-26 13:28:41', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:3dc871bcb0a3225f29473d031f53d15c0e3b1a421b1ca623d8d7f48c760c3ad86edd68bcc2fa61c697588769d1895188,sqr:SETP990000990 2025-05-26 13:28:41-05:00 901402281 222222222222 7800.00 0.00 0.00 7800.00 3dc871bcb0a3225f29473d031f53d15c0e3b1a421b1ca623d8d7f48c760c3ad86edd68bcc2fa61c697588769d1895188 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=3dc871bcb0a3225f29473d031f53d15c0e3b1a421b1ca623d8d7f48c760c3ad86edd68bcc2fa61c697588769d1895188,ssignature:JiMOi7TyD7Kql1Nu7lglv8pWZsXFyo4IE/WxaS1DrHI7L869XILiCBPhtkII7j59FfJfBHtSprePp90HmQ5TUPdQAjsUd4It3xIJB/kCgLI0yDebbRUCj4dJLNUB1zl9DoFWA01cdpIzuwDZEKPzW9wleDZsPri9Yz2IJ1XeeycUSAZIkPjE3dbVTR6pPbXGGHpSCUq73MuNplrzwqA3GEwsqOkVfaUPr4zJEGmDwzsTl2qXCc9Nk2ZDoaOD4WQ+x27sT+HvvIQW80ImUUjSvLKiiHvPtGPdT0CLCfapf+i+qUdf/Fr8e9PtBJgthRfRtxBFLmUdkSkCkQy2xghmxg==,sdocumentreference:SETP990000990,rtaxxadocument:235747075,sref:SETP990000990,irefindex:990000990},sdebug:Taxxa: 0.295s DIAN: 0.976s (creación 0.683s, revalidación 0.292s baja 0s)}', 48924, '2'),
(2139, '2025-05-26 13:43:49', '{\r\n      \"sToken\":\"396316085266\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-05-26 13:43:49\",\r\n               \"tduedate\":\"2025-06-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 1,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@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\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 48925\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00623986\",\r\n                  \"scustomname\":\"MILO PEQUEÑO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":5000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 48925, '2');
