INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2021, '2025-04-29 11:16:44', '{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: 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:SETP990000979 2025-02-09 16:16:44-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 fe5d51352602c8adf67d2f17f8f5ed9a590fc3ad2511182fb0eac755be6e2b107c12ceb709685010aaeeaece1cd338fe https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=fe5d51352602c8adf67d2f17f8f5ed9a590fc3ad2511182fb0eac755be6e2b107c12ceb709685010aaeeaece1cd338fe,ssignature:M2gBn0y/byYukZ32g0xmlRHVXg2E545NJ2XWHVNNH9xTM4F1J58AISCXHqVGLwTAnmextCWR68MFqKHQ5Aa10f2EGFDvb1tliaysA8vUMesM1kW3xDU09EbhKuKWBpwv5xeGBpmKXFQLAorvgDUbSxjfIkpQycA0Q1R1vctCpln2avGzE0lAhNtjxwrGwJQCMsQSQKZQ0HJu/Uz/3hc2CI6jDbghi2ygOS5PN7wP5A9kU+6wWaUkaTGKNWdOklSLLn6O+ZBwznbaBCLsxJixoiW9XKdAK14n/D4Kv9P59M9MK0gnmk/nBZv98gyCfT+qGtPXS0c6glnyw+T5ZRYGBg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.292s DIAN: 1.855s (creación 1.026s, revalidación 0.829s baja 0s)}', 47780, '2'),
(2022, '2025-04-29 11:16:53', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2023, '2025-04-29 11:16:53', '{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: 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:SETP990000979 2025-02-09 16:16:54-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 d89f10e0915e7e93c00a28778c396172a98d23d9cde51f3c0aeb9f5fa5628f6a01411422389e4a62e25bd2e6197bd27e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d89f10e0915e7e93c00a28778c396172a98d23d9cde51f3c0aeb9f5fa5628f6a01411422389e4a62e25bd2e6197bd27e,ssignature:TAD1jm5utwL7ALdh+eWqVIVncKBN7g/rpTBVhhEkv4z1/zvLSn0yeNKBqEQb3w4kQvVkk2tzM60r7CvQC3UWggNp4ASj5RoQ11NAIR0bFqVxwiw7GEcmrn0pjUz3VMdxuRtnauGIs6f5wjXOgmu9oagm9NbQjXvSfmlXgXwl3wjWJbV65Ve3oNcfSeppdaF/7+TMRMDedtINf7AcHA03/j8NSF5sRZ7sPid6qaDmgk0DlF38P6I36GR7lMc+KHsEy585zdfrmbz5HTMPp0iwBB/hXrxamSGtMG2wL9HXnqoTzwNpmHk6vohWfruSvCMC1VHSe23pVnvgo+lzMpRGsg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.312s DIAN: 1.522s (creación 1.038s, revalidación 0.484s baja 0s)}', 47780, '2'),
(2024, '2025-04-29 11:17: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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2025, '2025-04-29 11:17:02', '{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: 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:SETP990000979 2025-02-09 16:17:03-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 d5687612f23fec2c11ff100649c453e30a9e0303c2af1acb3cc1e78bf7d30c3f2be6d5a5f535ee089f6e9ed6b50cc9b9 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d5687612f23fec2c11ff100649c453e30a9e0303c2af1acb3cc1e78bf7d30c3f2be6d5a5f535ee089f6e9ed6b50cc9b9,ssignature:oZCFYpNWnSG+89vvIvonW6aFRijB91vhl3adt2rQXIbUuDvoz6SKMof1UWvYN+zx4cqkshmxLmHOdiLrZUeVYuld5TYZajVMCFqdy+EfSKDW4H3gIlxekLEgaF14c9V1P0S6fb1AffAlBRrrMgOOljFvS3poo8lraE/kkZE+R1izDiorwjuZdwWPpQqb9jJnXAWHV1GYroPC9WH8aZ/qsh+PpvT0raqtWjICV+azSbkHw/3fD2sKjbXiZPLgH7MKBnYNcvm2son+MUVPPvC2P2LO22YBpeILQZf9q4M7hkKMSalWcBAvjB1XdC2xA8pXkTFhL53ruN4cHb1KznC3kw==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.272s DIAN: 1.428s (creación 0.631s, revalidación 0.797s baja 0s)}', 47780, '2'),
(2026, '2025-04-29 11:17:07', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2027, '2025-04-29 11:17:07', '{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: 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:SETP990000979 2025-02-09 16:17:08-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 321461c83a76adb7da31a014d2d309efe0cc21998096ab386cb3de69b15accb8e785b57f1149fbc207e254530b7e0810 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=321461c83a76adb7da31a014d2d309efe0cc21998096ab386cb3de69b15accb8e785b57f1149fbc207e254530b7e0810,ssignature:wpFs9OA3REBU3bre0ncSwxogLiLWluNsKgm+7Et+XB5iHV62bF5Lhnl8xxed3NXoekQpYvDShdum4/HInBpE+biAQLCU7+69cJcsrlH04UzfsgN2DXqLYohYO1DZWCLtJ2HfvGYAv+YJuMVyLp3GryOYYSkc20sWGat5AfJZN/RMqKbhMKsYv6GdsfNNKBw2ozQYChJUJEWnuw0J13m68e+djcQ8c1lsWFPsSO+NjCOJ9D9e+MCu6STYUiZnGNmNlPlj/GEd7NF4gWE9AGtJEIHSaMA0YaFbR90mKS7ciYp6O9Thjhh2Fl8KHZ6g25BkM7XtvKRI7f7e4q/KWYwuNg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.268s DIAN: 0.969s (creación 0.592s, revalidación 0.378s baja 0s)}', 47780, '2'),
(2028, '2025-04-29 11:17: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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2029, '2025-04-29 11:17:16', '{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: 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:SETP990000979 2025-02-09 16:17:16-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 f6edf6539dd1280312b4157ce1093e0493c3575f63be57c97348152cd54e519bef065c3796f9d2ce32fe7b279cf5c62a https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=f6edf6539dd1280312b4157ce1093e0493c3575f63be57c97348152cd54e519bef065c3796f9d2ce32fe7b279cf5c62a,ssignature:PLB+Rr+zWydz0Xzd2HeZrbaeHC9fWi5+mXKAmxApO71wxxXHsSjjIVYIx9JHQJN4YDEOiX7P2NEXNIUGry+S3xHbF/pzOgDAMyQGWDcyV/BFi0QLAuZbsOxAQ71cGcKsFwsNrUiCGcZJzP7DpRI2gPR0hUC5JKnEI4xwhd5mXPPW+91mdW2uyOYi2MVnAVvGfF5RrLZgpqZpJQeYXZ1EjqxX4S/2BLsNIDyVNxNmLvgYM3mJb6hDP65YZZbs2BDnmRIfBpuRORG4w/IBCnSIVTsKbur3hjfj0/4u1idOhXz/OihJIDbTeGdiLqbIIMak2PoGIkwxVIbxw0FzNgM5pw==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.272s DIAN: 1.568s (creación 0.939s, revalidación 0.629s baja 0s)}', 47780, '2'),
(2030, '2025-04-29 11:17:22', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2031, '2025-04-29 11:17:22', '{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: 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:SETP990000979 2025-02-09 16:17:22-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 6676593f7773e5b4237cd64388e55eb0bd9f1400af8f04600de774e796f4e53487c799d330898a1fb4a4a1b821d40b31 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=6676593f7773e5b4237cd64388e55eb0bd9f1400af8f04600de774e796f4e53487c799d330898a1fb4a4a1b821d40b31,ssignature:pGYC5UkNUktU5Im5KEOSf2V+71ZBA2owFN/O0/sFW2xqw5kHRwhtR28BSflcI1S+acw4i+8GCml41e2/5wXGDhQdcCigGJFWOl+EzrX8CUsoxR50CJA02JnEliDO/AMISqbeNGIc0QgL6AoWiVtLFHmfSoakTJ65VNbpuF2dI7y6Mg4UiN2J1tcksD5/zPgazQdEb5uMWQ0qdQuHzRGbLT08EnBKKxHJAmRVIflQ1lsWyt2KwcgLEvgfpqfofeujAoe0A4DBgH58Eq+L1IyUHWntHPDM8NPLSIscvdJCMWMRYtErt9FimS+r8iyZZMq36U3UvnqWfs+AtHV6npKL+w==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.354s DIAN: 1.441s (creación 0.755s, revalidación 0.686s baja 0s)}', 47780, '2'),
(2032, '2025-04-29 11:17:31', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2033, '2025-04-29 11:17:31', '{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: 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:SETP990000979 2025-02-09 16:17:31-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 b958816ce08f45d491c48287b607baea0e4f2c57e53914d7fd68ccebc3fdc04df6526409d88a44c80953db9fb856403e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=b958816ce08f45d491c48287b607baea0e4f2c57e53914d7fd68ccebc3fdc04df6526409d88a44c80953db9fb856403e,ssignature:d0t14p3YAOK77OqBL/3PzY6vfp9eaPPlIiJ4k1iWhzvTvI1U12aNLLeAtU9lDtAd7R4wM+iPjp8wm6mFXG118x18Kc3Cx96cBS73Pv7iMNtKas/zVdnJ7RrNLts5Lr6nFOIJXBXdEQcCVIspGbyywaBQ8irhOeadZEn1/M+6oBp/XRpMu3AnejkfmjaTTuwxvKaI+xWuwyVZ9w/2Q/cSFGb0r2hpgxVdedPI5smqWO680CTjaE2f/gAGWHs1BWP1ZgIbevWHorI+rl5xSiJ53/zSSvD6xcFgBISJd7/qPg9V3gqtGQIgeDA8ISWfrk6rSGUtrSudztJjRw+c+6N/uA==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.265s DIAN: 4.299s (creación 0.666s, revalidación 3.633s baja 0s)}', 47780, '2'),
(2034, '2025-04-29 11:17:42', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2035, '2025-04-29 11:17:42', '{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: 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:SETP990000979 2025-02-09 16:17:43-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 5cb5fa0cd1d631ce68be3858f52806b0f69e87625200a35505f1ea497d4eeec899ee4a0d0c924e0cd7050c2054eb790a https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5cb5fa0cd1d631ce68be3858f52806b0f69e87625200a35505f1ea497d4eeec899ee4a0d0c924e0cd7050c2054eb790a,ssignature:JB0i0Hvs/yo88rAJyzbqyUzF8cwITmlL63QjfhYme4+Z52O8aXIPXzmPAiJCIJ8a9pmwgtMQoUQXJ1gBa6Lo0dAhBPKv8f5j3vEhZqCzLKFciN/DETZI1eHRrtQFUBUfbpgR2HmY9MibHWe/b5g2VlNhIEzBghY+qOQCv0wI1GsmQA1vD5noMM4VN+L02+RQc6+hegY40yr0lIoQ9IZ6d7qCw0VmaRYn/XIRivPdrXSFXYOm9Fork5bBaPL+E5P12WteoXEjNXk3TypKLzu+E9j3M6S8QhhIUzQULiZz3s+c/W2uxDFcdanycMZ7y/qH3Gpn1Kh/9/sIhaVNYWO4ew==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.28s DIAN: 3.79s (creación 0.571s, revalidación 3.219s baja 0s)}', 47780, '2'),
(2036, '2025-04-29 11:17:54', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2037, '2025-04-29 11:17:54', '{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: 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:SETP990000979 2025-02-09 16:17:54-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 4e85cc3aa38a981ec58ae1b114e7a5c68dc57c246ffd789657241b890b25a8f5cbfd89c32c2316232c62fd60132b0b81 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=4e85cc3aa38a981ec58ae1b114e7a5c68dc57c246ffd789657241b890b25a8f5cbfd89c32c2316232c62fd60132b0b81,ssignature:cSXzfOtTIcpeBQ74CWApTW3D0gH8Ws60FZbR3nkdeZMKuoRLb7Gka51Xdwxx5oTFlaZ2CWNocJDLTKpRs8TWX1Rd4cQSrSiVJGc14dSi9ZIBZyxV3gtTRmqkK/YTwV3aIO5a5DqaA2t6NscoG72BmGxWGpyNVsd3p3tXpwRUTJnQJ+12MCaTs44BTvqCnYensHEQ3UBmo6jC6UNs0ohIBoKophRvcvjR/o+kZlyN/a8ueVxNKaCukQDHlqkWYS3WQ7ljDG1QUyXSOZMzxkHYidOkIGsPvBjDfXy1plgs7/ufNKIU48TNX1aWZhT6CpIuwrnnJAfPk14zrh6WiWs1gQ==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.342s DIAN: 1.321s (creación 0.765s, revalidación 0.556s baja 0s)}', 47780, '2'),
(2038, '2025-04-29 11:18:03', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2039, '2025-04-29 11:18:03', '{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: 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:SETP990000979 2025-02-09 16:18:03-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 54cdfc94f934e5e62a58fdede5eee2463ad37891956872cc9227a221d26e9792a44d886af456759bba5100de636626c0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=54cdfc94f934e5e62a58fdede5eee2463ad37891956872cc9227a221d26e9792a44d886af456759bba5100de636626c0,ssignature:BRSAkcZM1/6pXrZ13vN9pDewrxYrRDFR7CNrggfp/uuO5vKdHMoDIeCAFLyQGGqYhaekEj+iLNQLbtPmp+6SuLTrivOqMLMwB15KF/CAfZpGpWojzw5EIeNzcTJXcSS7gQxmBqE3ikTd6JP26Clptd9ZVwTgdSawNXRWXUeLe47oC6UgigJrUy2+wDb/ajcHLeL+ysm0rzmuqgKgQ0tAREWDMN2VxHv8BLo0Ci1gQNGbkmjiLHE43nOszL/2Zr9NrrcUX7Md7Gg+qk8Y/pum5ptyjHinl/wLrmynF4YgttEKqZpyYzn6m/QzSWAj+q4PKSK4QzEc/B1c6flwV+EQRw==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.296s DIAN: 2.645s (creación 2.209s, revalidación 0.435s baja 0s)}', 47780, '2'),
(2040, '2025-04-29 11:18:13', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2041, '2025-04-29 11:18:13', '{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: 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:SETP990000979 2025-02-09 16:18:14-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 e9be6a686e3684ce44fe55a106c92a243eaad025e6db399556a8a1e903ba4cd0950602ebac1cfc843e98f0d05699a582 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=e9be6a686e3684ce44fe55a106c92a243eaad025e6db399556a8a1e903ba4cd0950602ebac1cfc843e98f0d05699a582,ssignature:WVvS/mw5jTlAJK/lKX287deOBtOXCfP506BbnP/5iqZPbcih5fJA2s7slyPd6/fh9pbd8uaAzKAYmWjoF1N2xQ83pRdnqp6zU3YZvTSeEGtQGsoT4aL8qYSYYCM6zdYL7UIaI3Cp8S/DkghZUTUxtrsAwn10E7r92IJrCNUuvdYzvE+CB/tmKoqZg+ItVS58UIw/tKu0RcQkqjQiu8+BmOOFbx9dYUMzp/99CnIH9XsHzHuJAga6BozT7KqMAJMWdnr5fvf0bKrShGBHsSmloX5V3Hj3XTkE3qvjfoMR68Nixkc/ckgIPoMRfCsj4JKBNN57jg/zeQgOrvd+yXrasA==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.324s DIAN: 1.411s (creación 0.744s, revalidación 0.667s baja 0s)}', 47780, '2'),
(2042, '2025-04-29 11:18:22', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2043, '2025-04-29 11:18:22', '{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: 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:SETP990000979 2025-02-09 16:18:23-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 7a45a42b58f369950be52ba2f9882aa186c8bfdd069a61496802ba39331e76db188c93a9815a4d665cb1e9deb5afd2e7 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=7a45a42b58f369950be52ba2f9882aa186c8bfdd069a61496802ba39331e76db188c93a9815a4d665cb1e9deb5afd2e7,ssignature:VxN+IdcTmbthRD/RXO4xCCfoA/wIgtdon187tSXK3rIPyEcbnooyu/fZjAVe27TlPvYcq/REBXRoYAObrGpfzSyUOa6wNSrSxUFgqFr5eoJt2PaAMj+pkCslUbby/XvL8nbiS7FoJHy8uhBjUrLT/S0Q0bt+0mL/cIP8FzEHtw/4dctgSRnctbH76XasZmwocdnraiq8Av36vAE4x9g1Mv5sD0cpoFeTqOxHnGjyvaoHhk/WOZofuhX4CLInmTjh1YXekBThg7neSLnzrYHtVdmNc0CCYzYX7Nkz83UKDr5iPYfBBbEItvnG55cFeCoCFYYVyTNpFXbdftMeA/5iWg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.33s DIAN: 1.892s (creación 1.005s, revalidación 0.888s baja 0s)}', 47780, '2'),
(2044, '2025-04-29 11:18:32', '{\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-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\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\":\"fasdfasdfasdfasd asd fasd   \",\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: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\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   ', 47780, '2');
