INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1936, '2025-04-01 19:45: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:65cded3fa0ffc2d9bdad16d8ed756056950ca83977af2307e3e9f88069588e3f0c648722f66e58e247363b16cfac1bb6,sqr:SETP990009522 2025-04-01 19:45:59-05:00 901402281 222222222222 6000.00 0.00 0.00 6000.00 65cded3fa0ffc2d9bdad16d8ed756056950ca83977af2307e3e9f88069588e3f0c648722f66e58e247363b16cfac1bb6 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=65cded3fa0ffc2d9bdad16d8ed756056950ca83977af2307e3e9f88069588e3f0c648722f66e58e247363b16cfac1bb6,ssignature:iH55bDrT3IJ+vXv2xwR95zaiiZwfnv0cLEj/6iHA53ft128RSOM0A5lWMdi3uL/DMrJYDbo9T6xw1VMoYvU36gWe2IH1AGgK0BWoKYXxqR2j+czTeM83QCRljE2Eozxq7/GxK4VF4IV04Vwt5N70NVGuU1/J2BHmRS5L92XV8sY1hnC7j3bleiN0ct/oR5RmLJkV5VcqUwu0prn2u/J6/uTUJbhlys4rgBf+W7XayOG5mYQu6qY2LWvEaNCJrS/lp4ytWGkzDPeS7xRpkS1xWW+OciLDAtVgbLAjU86sQ6iISYaEohqTy9T9nq4QVibzBA39bxAxQRsbE8FeS958Kg==,sdocumentreference:SETP990009522,rtaxxadocument:205747268,sref:SETP990009522,irefindex:990009522},sdebug:Taxxa: 0.392s DIAN: 1.665s (creación 1.012s, revalidación 0.653s baja 0s)}', 47813, '2'),
(1937, '2025-04-01 19:48:44', '{\r\n      \"sToken\":\"774855597565\",\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-01\",\r\n               \"tduedate\":\"2025-04-01\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9523,\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\":\"ALEXIS ROMAN\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"FN\",\r\n                     \"sdocno\":\"26234123412400\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"ALEXIS   \",\r\n                     \"selectronicmail\":\"raulotalvaros@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47823\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622797\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":155700,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47823, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1938, '2025-04-01 19:48:44', '{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:87f5a50667662962d7d37cdc4bfac596e60cc161313d9f36a48d9c4ab2cd7583f8f3e4b4da682c2e705a6c99bc5b5942,sqr:SETP990009523 2025-04-01 19:48:45-05:00 901402281 26234123412400 155700.00 0.00 0.00 155700.00 87f5a50667662962d7d37cdc4bfac596e60cc161313d9f36a48d9c4ab2cd7583f8f3e4b4da682c2e705a6c99bc5b5942 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=87f5a50667662962d7d37cdc4bfac596e60cc161313d9f36a48d9c4ab2cd7583f8f3e4b4da682c2e705a6c99bc5b5942,ssignature:Hg0BsILjFK3euIiP+rA1Y+UDFoBGtZNuoeuvBq5lID6Qqas2tWML1Gfk+INJRNxZ5ex1zHOHi6u7C3OkZ3YFnosVEsUzCthoNuLK1wfeYJStJCTE/gtVqnFf1X3lyQDbk2TE7Rwb2ziv0mxJ5EKXJKcbGvqot8K3i/tquv2OXd5VyPwlNHGpAmkleacFdE8wPJ7Whpl5elNNZe8BRiFwErnibxjGSn9KZS0Y9kd+fsti97FsI2P5yA9HbUz00F9EXjqprdYEnescDdF+Sqat+zqUDBwc2oEEz5/KFDDKkIx3ZI9Afs1gj8+77EoTzW9KyfNor8U8TnNb1ZtNUMPpsw==,sdocumentreference:SETP990009523,rtaxxadocument:205748615,sref:SETP990009523,irefindex:990009523},sdebug:Taxxa: 0.594s DIAN: 2.333s (creación 0.729s, revalidación 1.604s baja 0s)}', 47823, '2'),
(1939, '2025-04-01 19:57:05', '{\r\n      \"sToken\":\"774855597565\",\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-01\",\r\n               \"tduedate\":\"2025-04-01\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9524,\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\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTA DIRECTA   \",\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: 47833\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622807\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":900,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47833, '2'),
(1940, '2025-04-05 11:20:45', '{\r\n      \"sToken\":\"774855597565\",\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-05\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9524,\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: 47835\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622809\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":3 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622810\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":2 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622811\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622813\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00622814\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00622815\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\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\",\r\n                    \"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   ', 47835, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1941, '2025-04-05 11:20:45', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:3c0c87a5ca47c1095a7c299160854dc3eb4897134b21857b317b225b953ccdc8ebeaf0d7a41aa897c7f08ea35308d601,sqr:SETP990009524 2025-04-05 11:20:47-05:00 901402281 222222222222 188500.00 0.00 0.00 188500.00 3c0c87a5ca47c1095a7c299160854dc3eb4897134b21857b317b225b953ccdc8ebeaf0d7a41aa897c7f08ea35308d601 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=3c0c87a5ca47c1095a7c299160854dc3eb4897134b21857b317b225b953ccdc8ebeaf0d7a41aa897c7f08ea35308d601,ssignature:By1JIjCHIG1k/NnzGwJTU+qHMFg1v8AJCloHBiJqu2ROrmSecKhe1Uqvr3f6TvPe/q/n8kdFgC15ONA9f201avJS9MZZm71HCWzDytPrmPo6PsZNTFIIpN2a4e7lft7d+QsDjH7i2Vd94bFg5tF3wMVSrmg2zqSIPhi2fv+8XPzHtfjt54FSKFaD3TNSEIaEAJuSm1A0h526CeOoMjSYfzfvZNVAYrgC9wH6K9gPi2bVX4F14leHKTYmeB0So2+homCvMAGGlkJ/AjmQNFsrj/WAf5lpCNQBAuBiYJiPAF8fQmaWa9eybgZ7WjmKRaBkKl4eO4PDm9Ab+Lkm/amP+w==,sdocumentreference:SETP990009524,rtaxxadocument:null,sref:SETP990009524,irefindex:990009524},sdebug:Taxxa: 1.501s DIAN: 1.47s (creación 0.786s, revalidación 0s baja 0.684s)}', 47835, '2'),
(1942, '2025-04-05 11:21:10', '{\r\n      \"sToken\":\"774855597565\",\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-05\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9525,\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: 47835\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622809\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":3 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622810\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":2 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622811\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622813\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00622814\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00622815\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\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\",\r\n                    \"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   ', 47835, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1943, '2025-04-05 11:21:10', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:cf910116586017b662524087d9d176bd743c69e36f19fdec1291363450c6036489b89906a7b400519d95fd4547cc5805,sqr:SETP990009525 2025-04-05 11:21:11-05:00 901402281 222222222222 188500.00 0.00 0.00 188500.00 cf910116586017b662524087d9d176bd743c69e36f19fdec1291363450c6036489b89906a7b400519d95fd4547cc5805 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=cf910116586017b662524087d9d176bd743c69e36f19fdec1291363450c6036489b89906a7b400519d95fd4547cc5805,ssignature:wTH/M5Pm788+wtaeDq9zMA1hP1TXuedR1YrmTM8g4Pnp3YYI3kpc6HMWowHiB04S1z8ctO42gh9HsFIQUClJknRRWcN+gzSqUV6wYS2ZNzCk2KRw/oPPJCcUGZqS9zrbPfvpCkAH3/yPo7sc+CQoFoGlojjYbdwyH9YF/O7MgtUyTi51rjEfaz8CxUOABUgKr87ZH+5Yc0+U5L93gYA3RRzV1mNvt/xka7r17pPIx4bw+vpXbEAdn85EWTzN7hP9hhEIO+SRLne2cLG97fCqK3vAa6ZmT1W4f2WSCjY4WkWsxIfDqzZQXwcz3f5sv9TTXDd8UANqVwzDPD6lVS47xA==,sdocumentreference:SETP990009525,rtaxxadocument:null,sref:SETP990009525,irefindex:990009525},sdebug:Taxxa: 0.834s DIAN: 1.032s (creación 0.374s, revalidación 0s baja 0.658s)}', 47835, '2'),
(1944, '2025-04-05 11:21:19', '{\r\n      \"sToken\":\"774855597565\",\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-05\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9526,\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: 47835\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622809\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":3 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622810\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":2 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622811\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622813\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00622814\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00622815\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\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\",\r\n                    \"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   ', 47835, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1945, '2025-04-05 11:21:19', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:ec57037d62d8368788afcf5fa583efc28f41fdede895639ec3bef62010e68eb7e00cab907608cac63ec4203f0b909a7e,sqr:SETP990009526 2025-04-05 11:21:21-05:00 901402281 222222222222 188500.00 0.00 0.00 188500.00 ec57037d62d8368788afcf5fa583efc28f41fdede895639ec3bef62010e68eb7e00cab907608cac63ec4203f0b909a7e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=ec57037d62d8368788afcf5fa583efc28f41fdede895639ec3bef62010e68eb7e00cab907608cac63ec4203f0b909a7e,ssignature:sLepus15qN5NPfSbvHgoLfSaXtAG4cfZlAzFgxf+UrUX4pSC6xam373IFDEf84eZDhW1qcbMdgawK7zL3KNNqDngDixNLppVFHho5De3DddurMInMfjuK10HyNXNmCZFkOi2TBSLdFnHoeT8/MuofFt3725AKiI2xht9RDZo4KsYHFcNixvTp5t7QTF80XiP/aiPFwTY+A/draUQ8xmvkTnmWBc6WQff0ah5IfZJrHCzPk8PrtSPCL7hwoB7Wu8IV4t92BlxBZkmt+NJiSlpgFa36BYyvJBzs7n4CgxsaGLRHtNVFODlxzvbm6IM+4GQTzvNdrwfABdt3hP8GBc8rA==,sdocumentreference:SETP990009526,rtaxxadocument:null,sref:SETP990009526,irefindex:990009526},sdebug:Taxxa: 1.174s DIAN: 1.747s (creación 1.055s, revalidación 0s baja 0.692s)}', 47835, '2'),
(1946, '2025-04-05 11:21:34', '{\r\n      \"sToken\":\"774855597565\",\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-05\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9527,\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: 47835\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622809\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":3 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622810\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":2 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622811\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622813\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00622814\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00622815\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\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\",\r\n                    \"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   ', 47835, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1947, '2025-04-05 11:21:34', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:ef3250321c1026ed8289a9a24ef248b901a77da4baa095f088063f8e9b51f7da93ae649fdb66e8ed93e59331403240e1,sqr:SETP990009527 2025-04-05 11:21:35-05:00 901402281 222222222222 188500.00 0.00 0.00 188500.00 ef3250321c1026ed8289a9a24ef248b901a77da4baa095f088063f8e9b51f7da93ae649fdb66e8ed93e59331403240e1 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=ef3250321c1026ed8289a9a24ef248b901a77da4baa095f088063f8e9b51f7da93ae649fdb66e8ed93e59331403240e1,ssignature:TXPDIIi1J073zN+BudmchHCpn3w1lAXJNsIbHrgec205jWrsq67L9F2UksWx0c9MmMVNXLCTteI7smCOFL0npEue3VTC+A5/AZSTFdnOkuNeMmm9izegyD+qOo5zTynpJkYJVJ4LOuWJnB7J5egzdh9sv6Lb5i8fDDudn96Kbbb5akN+OvrawqA+lKocgJkAJSo/edT8gP7hvsGrDUeYP/Jn0grSSyu6B3eo5Z/GI4wjLKpGDlLLicIar5Jmwq1UH3rVpil7yfornEiyuKOeTnOaRZ+XHYAZZZT8MI8wRFdmFDrs2spVL1yT1zCFDGA7rL2TPyFKiRedVZcffEhvMw==,sdocumentreference:SETP990009527,rtaxxadocument:null,sref:SETP990009527,irefindex:990009527},sdebug:Taxxa: 0.704s DIAN: 1.279s (creación 0.623s, revalidación 0s baja 0.656s)}', 47835, '2'),
(1948, '2025-04-05 11:21:45', '{\r\n      \"sToken\":\"774855597565\",\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-05\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 952,\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: 47835\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622809\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":3 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622810\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":2 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622811\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622813\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00622814\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00622815\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\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\",\r\n                    \"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   ', 47835, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1949, '2025-04-05 11:21:45', '{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:9ec8a6deffda4ff3538a82872584279195b9286bf5530ff7df4334c9d063134d280288d4105a13bb7d673256c4748c3b,sqr:SETP990000952 2025-04-05 11:21:46-05:00 901402281 222222222222 188500.00 0.00 0.00 188500.00 9ec8a6deffda4ff3538a82872584279195b9286bf5530ff7df4334c9d063134d280288d4105a13bb7d673256c4748c3b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9ec8a6deffda4ff3538a82872584279195b9286bf5530ff7df4334c9d063134d280288d4105a13bb7d673256c4748c3b,ssignature:APF1r+6loj6opk+5IB+l5riPg97g0ho4SLKmp0s4LKkQQtmtamGBAH8kXf1yMA3gG9XxN36mgeEgSUN8tLosTeW0SBqTMu2ME5Ag/qxtptlOs8ehnFaxTTzV9EPURtlncXLHs1Hfv4EFFeyqgecdURQlA3IWvct9VUJoK9F1UEPLur1gyn4JibQqthk5K1+hHyS0j70N0ltAxSL4Z7h59KpEDIrtsd7Fx/mxqBFrEt5wYeO/RZO/rGTdBQw7jH0txNyakIl+fR25c6BWpAXjxN1SjTP+Mh+Bk0nQfpkqh2OdnZZIkR9Z2LuLG9IPxH6+nPV4BrSCPsbxBFNhFmMoOA==,sdocumentreference:SETP990000952,rtaxxadocument:207720631,sref:SETP990000952,irefindex:990000952},sdebug:Taxxa: 1.353s DIAN: 1.679s (creación 0.976s, revalidación 0.703s baja 0s)}', 47835, '2'),
(1950, '2025-04-05 11:24:18', '{\r\n      \"sToken\":\"774855597565\",\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-05\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 953,\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\":\"ALEXIS ROMAN\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"FN\",\r\n                     \"sdocno\":\"26234123412400\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"ALEXIS   \",\r\n                     \"selectronicmail\":\"raulotalvaros@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47816\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47816, '2'),
(1951, '2025-04-05 11:24:18', '{rError:21,sMessage:The JSON format is invalid}', 47816, '2'),
(1952, '2025-04-05 11:24:18', 'The JSON format is invalid', 47816, '2'),
(1953, '2025-04-05 11:29:09', '{\r\n      \"sToken\":\"774855597565\",\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-03-28 18:01:17\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 953,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"VENTA DIRECTA   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTA DIRECTA   \",\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: 47818\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47818, '2'),
(1954, '2025-04-05 11:29:09', '{rError:21,sMessage:The JSON format is invalid}', 47818, '2'),
(1955, '2025-04-05 11:29:09', 'The JSON format is invalid', 47818, '2'),
(1956, '2025-04-05 11:29:20', '{\r\n      \"sToken\":\"774855597565\",\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-03-29 01:36:39\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 953,\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\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTA DIRECTA   \",\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: 47826\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622800\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":900,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47826, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1957, '2025-04-05 11:29:20', '{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:5242283f5a64d5484dc61f7c841341655a3f17811391a60e1597e1217dbe53a4427aadca4afb6f78424343b5746a44aa,sqr:SETP990000953 2025-03-29 16:29:21-05:00 901402281 1564561 900.00 0.00 0.00 900.00 5242283f5a64d5484dc61f7c841341655a3f17811391a60e1597e1217dbe53a4427aadca4afb6f78424343b5746a44aa https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5242283f5a64d5484dc61f7c841341655a3f17811391a60e1597e1217dbe53a4427aadca4afb6f78424343b5746a44aa,ssignature:x2xIu+vQYGDpVk7ty28sWa8q24bA2Zmw35V+/gZ4BeHDyD2TG+7AJuDEusdaSx11SYqbCWT2wc4JqhHRUjQcwrAHbdb2vEUv6K+bMYkd3z9VYIg0pNmfSkdNpeB2X7DNH6c8AEl8ajuUytswbTowZtDCQKQEaY5m081EJ//DcC1ews8gQB6dm0qkOdnorPRdN66FLXHwmsgICxvUluNa6yVrHNFGi4bS+bwHF2fSFPZUtk7+G3+iJksChYefKgUwPyepisulMhfDRQPQWRkJXSNTS4vBcpGwaIUwDVVdkBZDqoIfYmkceEp27rnbTzKxCZWUjdXTqFZrHrgNeJZqrw==,sdocumentreference:SETP990000953,rtaxxadocument:207725596,sref:SETP990000953,irefindex:990000953},sdebug:Taxxa: 0.842s DIAN: 1.409s (creación 1.092s, revalidación 0.318s baja 0s)}', 47826, '2'),
(1958, '2025-04-05 11:32:52', '{\r\n      \"sToken\":\"774855597565\",\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-03-29 01:56:56\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 954,\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\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTA DIRECTA   \",\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: 47834\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622808\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":900,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47834, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1959, '2025-04-05 11:32:52', '{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:93208af1a8661467a8ab71ae5325a6aeb075a860f83af5be8f78959e1159805e7f198564ed65c00f6da39ec8896da280,sqr:SETP990000954 2025-03-29 16:32:53-05:00 901402281 1564561 900.00 0.00 0.00 900.00 93208af1a8661467a8ab71ae5325a6aeb075a860f83af5be8f78959e1159805e7f198564ed65c00f6da39ec8896da280 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=93208af1a8661467a8ab71ae5325a6aeb075a860f83af5be8f78959e1159805e7f198564ed65c00f6da39ec8896da280,ssignature:OOVmSz/OOryFFHau+C7OYdD7TTR5Jx/3WeZUl+7tCBNcrLpQl1EHZmnIHEZFZ3yHvWRGRERAEvdLw3kbw/V3NrBgw1PwYBK9nD8zcQrAPcXKFI3UJHMIRxU3NroIYmKIIR/ZUgXFl04IkoxK/1/pS0J/+Co+avZSfW4vOuIlzBOWmZjGiavnDQqdNKCKanZwbzH0UarNifiAxPrmkPcGzTUJU7sou6YbS9It9vRGsa/W55xKT+bAvZXHW5gjiY31g/vkvKAofnleF+vUqBfpQosH4oPZTS6pOKlv+G++ZoTS2jqXowPH3F/gZo8PXz1sx8JRHLAdzz2lwp2UwwJGOg==,sdocumentreference:SETP990000954,rtaxxadocument:207727896,sref:SETP990000954,irefindex:990000954},sdebug:Taxxa: 0.404s DIAN: 1.564s (creación 0.987s, revalidación 0.577s baja 0s)}', 47834, '2'),
(1960, '2025-04-05 12:16:13', '{\r\n      \"sToken\":\"774855597565\",\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-03-29 01:47:24\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 955,\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\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"VENTA DIRECTA   \",\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: 47830\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622804\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":900,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47830, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1961, '2025-04-05 12:16:13', '{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:86be8667370bfb9363af182fc3d36591d3f848f74c14f0f12652f83c364a39f1cdb6122636ea45cbc8cd131f8a94c9d5,sqr:SETP990000955 2025-03-29 17:16:14-05:00 901402281 1564561 900.00 0.00 0.00 900.00 86be8667370bfb9363af182fc3d36591d3f848f74c14f0f12652f83c364a39f1cdb6122636ea45cbc8cd131f8a94c9d5 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=86be8667370bfb9363af182fc3d36591d3f848f74c14f0f12652f83c364a39f1cdb6122636ea45cbc8cd131f8a94c9d5,ssignature:BWSLbFbgVoNYdgNe2DkoFJ8kK0Zzf8ev9VOE7xFzbe/+lkTdG7Ps0Wvimp8wxpvDevrwOMTGorkJIdKaKokL/FwTS0M8f1EEGWkJhuIojCYOcLMLnGGy5GkNk0XByguErguDXcZdIqthrgW4WI/+qfMOUp1rwYFbbn9uBROjh2LzrJnOyL35+soUkSipcREAoR3SgUyBX/mDBx/lDo6nwtNaDLAFoOZBIX3xAxstBtTwwVLCQXDReVRYPDFMeVx5Ktnobx/kfNTk+dOvJKF6UYTOAsX9FbnYjTsPAnnGDfs5IAicZcu/Jg9vSiyXuaqfhT4ZcA/2TvVjP8Gb9sJzYw==,sdocumentreference:SETP990000955,rtaxxadocument:207757837,sref:SETP990000955,irefindex:990000955},sdebug:Taxxa: 0.667s DIAN: 1.291s (creación 0.89s, revalidación 0.401s baja 0s)}', 47830, '2'),
(1962, '2025-04-05 12:18:08', '{\r\n      \"sToken\":\"774855597565\",\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-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 956,\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\":\"1564561\"\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\",\r\n                    \"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
(1963, '2025-04-05 12:18:08', '{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:3d07fd1054e23933c22cf0e14790ae10da22d8fed25dbc09195fdc6ba7bf1a160143774bf022d19e55f32f922b796f3c,sqr:SETP990000956 2025-02-09 17:18:09-05:00 901402281 1564561 125000.00 0.00 0.00 125000.00 3d07fd1054e23933c22cf0e14790ae10da22d8fed25dbc09195fdc6ba7bf1a160143774bf022d19e55f32f922b796f3c https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=3d07fd1054e23933c22cf0e14790ae10da22d8fed25dbc09195fdc6ba7bf1a160143774bf022d19e55f32f922b796f3c,ssignature:AaWaT55Q5j2fKQupTCqCCjmjSqqEjFCPXf6UwMSnWTmllQ17IF3aOEs0Pfyp/CCNkytmZPolUPVI+HjGFnIVmKUGyj8TYcJpA24E8jRWGUaCGPffbcGQ9fvHyC/NckkCLevYrdzZCexcjjpcdlvdjhCL0vtxigpdDqDk4HutCzYNAJh8C6RXvcG88gGcL6IZC5Jqa7yVFbYMHM7ZlVZ7JhayThPokJHuDRMh9YaZViRglSV/vMWiAHJviqr+33LtkMg9naRLAXk1fbmxm8rEMq84s7RrvjesTtIfjhOhVmrQjMkg3mMBsMuuIoKLnWS8YTcgSjALkYkW8+NimuIKEw==,sdocumentreference:SETP990000956,rtaxxadocument:207759149,sref:SETP990000956,irefindex:990000956},sdebug:Taxxa: 1.076s DIAN: 1.562s (creación 1s, revalidación 0.561s baja 0s)}', 47780, '2'),
(1964, '2025-04-05 12:18:18', '{\r\n      \"sToken\":\"774855597565\",\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:46\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 957,\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\":\"1564561\"\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\",\r\n                    \"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');
