INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1994, '2025-04-11 15:35:06', '{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:d905a9aab75ac74e7e5bded326637210235225e5a5d3125df1dce09ae071511a02b077ed14b4ebba8508d9bdb51a6566,sqr:SETP990000970 2025-04-11 20:35:07-05:00 901402281 222222222222 13500.00 0.00 0.00 13500.00 d905a9aab75ac74e7e5bded326637210235225e5a5d3125df1dce09ae071511a02b077ed14b4ebba8508d9bdb51a6566 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d905a9aab75ac74e7e5bded326637210235225e5a5d3125df1dce09ae071511a02b077ed14b4ebba8508d9bdb51a6566,ssignature:kGolSI8RUt9tskuigrBgBVLEYD6X7hDXcTcwnevXmDVwlLpu72zfxQbMgp2FszsFdsHwd1EpPCB/vlK+sAh9odDxKgqyarMVwKyR8fr1mbKy6tB+mRYdODoPug2rryfulMSlkghdQiEbO1SFvlnqWJHO885oOWkhDlSbHIb23ZE0szi6BiCtjNg9958WnFAVwtE4hGcfljhbsCfD/vzG4odbXcxXxcBscpqXWahuoxQoVWfjVYheN4iZEIQKUu9bN30wgOnPw4JB5RutThiVic3nWnhx/3UZE/9WfCGJxc17VuUrlcmeNEvv7iVsGTCNtGSMje+6d/OZGQLxQNt/Ow==,sdocumentreference:SETP990000970,rtaxxadocument:211072130,sref:SETP990000970,irefindex:990000970},sdebug:Taxxa: 0.998s DIAN: 1.961s (creación 1.186s, revalidación 0.775s baja 0s)}', 47853, '2'),
(1995, '2025-04-15 17:40:48', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-15 17:40:48\",\r\n               \"tduedate\":\"2025-04-22\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 971,\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: 47857\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622878\",\r\n                  \"scustomname\":\"BUDWEISER\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622879\",\r\n                  \"scustomname\":\"CLUB COLOMBIA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\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   ', 47857, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1996, '2025-04-15 17:40:48', '{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:b5b6104a979d884eadb1b6c9a7a4abe8c2de75c8c1ec5052bce042b1b1e1b8d49ff24ddc5f7c8cfca1b569fd9e26ba38,sqr:SETP990000971 2025-04-15 22:40:48-05:00 901402281 222222222222 14000.00 0.00 0.00 14000.00 b5b6104a979d884eadb1b6c9a7a4abe8c2de75c8c1ec5052bce042b1b1e1b8d49ff24ddc5f7c8cfca1b569fd9e26ba38 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=b5b6104a979d884eadb1b6c9a7a4abe8c2de75c8c1ec5052bce042b1b1e1b8d49ff24ddc5f7c8cfca1b569fd9e26ba38,ssignature:qYCRA69ojINGQyyiaH6t+/Nrfx+gjHpMOiDWkAMjWUEThHhGSf0Eco9Y8Xuoxi/S6ZOY3XYD1CzKYWkXnJxu3V8vgCv3zLl2j5bRQJXnAz8qlMPy+uD4XgUXA0yPFQGHDH3A6DgrfFIEaUdk2dliUk1TJHdt3/gCwCs4FAg5+ymCC/cL85ecJj0pzTNXO6BumroPMHt8JMHsaf1Op3BxMskBdWzmOGKs64G1eUCOxQoyXf3OmNk1sSa21g15VF9oIUJyoxC7TKTQWvX1O9sDXh1QbJ/BQP2p3bH9M2xidE+ODPFwFeT1I34/cuI9xRJuFXNxt1AZVqdSgdNKjV+j8w==,sdocumentreference:SETP990000971,rtaxxadocument:213171994,sref:SETP990000971,irefindex:990000971},sdebug:Taxxa: 0.291s DIAN: 1.458s (creación 1.09s, revalidación 0.368s baja 0s)}', 47857, '2'),
(1997, '2025-04-16 14:01:10', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-10 13:07:33\",\r\n               \"tduedate\":\"2025-04-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 972,\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\":\"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: 47851\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622862\",\r\n                  \"scustomname\":\"PICADA PERSONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":25000,\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   ', 47851, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1998, '2025-04-16 14:01:10', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:fc4119af76ca9ed5faa7e9992f23628c5be6f3a79c21832210b46172d7aafc5315a8ecb9ed2c21d7e563a087fa2b2907,sqr:SETP990000972 2025-04-10 19:01:11-05:00 901402281 222222222222 25000.00 0.00 0.00 25000.00 fc4119af76ca9ed5faa7e9992f23628c5be6f3a79c21832210b46172d7aafc5315a8ecb9ed2c21d7e563a087fa2b2907 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=fc4119af76ca9ed5faa7e9992f23628c5be6f3a79c21832210b46172d7aafc5315a8ecb9ed2c21d7e563a087fa2b2907,ssignature:urwYE2XhEkBf7oaFBh3m9n7yz0dIc0ER0VCAf/mgYHFXeEtSVZ9M9l3vktxhPUTeCie/HfO+cWh0PXrnXo2pdyNbBGHINlymujAJsI9o3fTO26rLS87UCRrEpVHpcMqXgrFgkwe6HQUuarNAHUAhwdnN00uggnvLBJ4LqK4n531rPYvE2gEZvVOqA4zuzZZN55ejtCuq6BMU7s7BdOxXYOHCe+YrkUmTxEiO04woA9ICqH/9Sj79QLg7j1VvOpzHkEEnGO84yQEXX+JehAE6otNttEW3wMF3jCFtBpN7iYdjBctiOrrg7J0BI5DOXHStZExxwBPOyV7hAy5LCRFTJw==,sdocumentreference:SETP990000972,rtaxxadocument:213598211,sref:SETP990000972,irefindex:990000972},sdebug:Taxxa: 0.298s DIAN: 1.341s (creación 0.971s, revalidación 0.37s baja 0s)}', 47851, '2'),
(1999, '2025-04-25 13:25:51', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-24 19:23:25\",\r\n               \"tduedate\":\"2025-04-25\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 973,\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\":\"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: 47858\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622881\",\r\n                  \"scustomname\":\"BUDWEISER\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6750,\r\n                  \"icount\":5 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622882\",\r\n                  \"scustomname\":\"ALMUERZO ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20250,\r\n                  \"icount\":2 \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   ', 47858, '2'),
(2000, '2025-04-27 15:02:32', 'En este momento ya tiene un proceso pendiente en la Dian, pida soporte con <br><b>id: pruebaseu 47858</b>', 47858, '2'),
(2001, '2025-04-27 15:02:36', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-24 19:23:25\",\r\n               \"tduedate\":\"2025-04-27\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 973,\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\":\"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: 47858\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622881\",\r\n                  \"scustomname\":\"BUDWEISER\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6750,\r\n                  \"icount\":5 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622882\",\r\n                  \"scustomname\":\"ALMUERZO ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20250,\r\n                  \"icount\":2 \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   ', 47858, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2002, '2025-04-27 15:02:36', '{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:57293300aa55ace590436032c8d5bd20865abeff6a092d670eda5a44ca455c17b62c099e267763b278a365f729ed0395,sqr:SETP990000973 2025-04-24 20:02:37-05:00 901402281 26234123412400 74250.00 0.00 0.00 74250.00 57293300aa55ace590436032c8d5bd20865abeff6a092d670eda5a44ca455c17b62c099e267763b278a365f729ed0395 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=57293300aa55ace590436032c8d5bd20865abeff6a092d670eda5a44ca455c17b62c099e267763b278a365f729ed0395,ssignature:IPlZHhIPOUK0EEwdEv0IgFe7aFZJEz38y4wktysajS+8CUff70Fbp5tE26/JtW5ZjUfLlkyKfnCV7MdAtp45VHmpkaJdKnSEN9My0PAzlqH1f0OlOGMSL/q46k16fYH5IY74RwUDgLIxOKCza+CW/2voXXoP3ePaOUyEmyt3SLxk4/P/ndh1KHgn38JqQckYoDZrp3c+5pJKkn1w7LXOSvIITaAp7DfzfjmI3oS/1m9NyMSVoW2kX5UpzviTXVN38LgCx2hrZKchbpy3sGLKOArM2hFKza6mt5FjvbPLTJ8HYnP/i0dWqaF0sbVgbXB2JgVrG8ky4NPyFg7cL1Mf/A==,sdocumentreference:SETP990000973,rtaxxadocument:219779761,sref:SETP990000973,irefindex:990000973},sdebug:Taxxa: 0.265s DIAN: 1.373s (creación 0.965s, revalidación 0.408s baja 0s)}', 47858, '2'),
(2003, '2025-04-27 15:21: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-04-25 17:53:00\",\r\n               \"tduedate\":\"2025-05-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 974,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"PAULA   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"123\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"PAULA   \",\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: 47859\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622884\",\r\n                  \"scustomname\":\"CARNE, PAPA, AREPA, TOMATE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622885\",\r\n                  \"scustomname\":\"POLLO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":1700,\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   ', 47859, '2'),
(2004, '2025-04-27 15:21:54', '{rerror:4727,smessage:Taxxa - Buyer document type CC, CE or NIT can only contain 5 to 15 numbers. Do not send the validation digit.,sdebug:Provided: 123}', 47859, '2'),
(2005, '2025-04-27 15:22:01', 'En este momento ya tiene un proceso pendiente en la Dian, pida soporte con <br><b>id: pruebaseu 47859</b>', 47859, '2'),
(2006, '2025-04-27 15:22:05', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-25 17:53:00\",\r\n               \"tduedate\":\"2025-05-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 974,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"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: 47859\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622884\",\r\n                  \"scustomname\":\"CARNE, PAPA, AREPA, TOMATE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622885\",\r\n                  \"scustomname\":\"POLLO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":1700,\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   ', 47859, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2007, '2025-04-27 15:22:05', '{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:04309d28fbeb018d2a0a38b32f8a329ca28a3783515348681f3df895763e8e1179886d75fc2fe611fc55d83c7c6bf5d9,sqr:SETP990000974 2025-04-25 20:22:05-05:00 901402281 222222222222 22200.00 0.00 0.00 22200.00 04309d28fbeb018d2a0a38b32f8a329ca28a3783515348681f3df895763e8e1179886d75fc2fe611fc55d83c7c6bf5d9 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=04309d28fbeb018d2a0a38b32f8a329ca28a3783515348681f3df895763e8e1179886d75fc2fe611fc55d83c7c6bf5d9,ssignature:SvYZ6YbDbHSmfp+GV1QQ8v5HTe208etUrlfVrfLa4EAmmK65PqGp2HUe+zf47j8z7A0gljzgGuqI7v6i1q99xj9m1zy16edTRpFnVXNKnJwvUEP1C9A0g9dxUcxPEzwvboUooNKxWcd83UlKnGM7izk17v77EeZWanLqtKbyXahFZvS3m2yXh8ETtepIbmWzj9mRwsmQpKlnzJro1Rv69YbFMaQ31JsBvLH3ggHR7bl5NNg6bpyBxaAImmic3+9oTRxLugJx60idfzt1yXLylmlBHUwL40y35Hz9eD4YKPcYJRge934IVACCKT6OxMGquDcazl1vX2QOBz9OrqiLLg==,sdocumentreference:SETP990000974,rtaxxadocument:219790263,sref:SETP990000974,irefindex:990000974},sdebug:Taxxa: 0.264s DIAN: 1.472s (creación 0.669s, revalidación 0.803s baja 0s)}', 47859, '2'),
(2008, '2025-04-27 15:36:17', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-27 15:36:17\",\r\n               \"tduedate\":\"2025-05-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 975,\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: 47860\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622887\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":18000,\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   ', 47860, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2009, '2025-04-27 15:36:17', '{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:1c9c416076901af2f92f6d4f05c0bcaa63045843b5f6ab56634c7c063285a167918d8519b324c892765befb1c11e1481,sqr:SETP990000975 2025-04-27 20:36:17-05:00 901402281 222222222222 18000.00 0.00 0.00 18000.00 1c9c416076901af2f92f6d4f05c0bcaa63045843b5f6ab56634c7c063285a167918d8519b324c892765befb1c11e1481 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1c9c416076901af2f92f6d4f05c0bcaa63045843b5f6ab56634c7c063285a167918d8519b324c892765befb1c11e1481,ssignature:Y5+PWu7Kci7yyA2wTivgrOKmGDZdOwwY7xpWf9Yg3nghPEIN23r/EVuKu8mfxCgn5ARtYC+zD+vU+mV7lMUEQD/tLVuMVCxBhouQiSKv8mR6G830NBHCn67AQRR/ps18r9WC/T1q1SF0ugEGuM+dJQsUFnguk7jNepX3zGkiJe/HL7C8wr/oj/iIT3VacmM8qqcGeBxw3kPH9CVika0w1QUM4cuUC7D+IlFqgnuo0W/INsTdEYtm9moXsx+rh7xwbLjBHpxAgVutPkLLhZQXwUXkv7lG1a5NqiIPaRehhd8Xiy2JAFYrwhPLnWlUcnHY/a2F9oQaLH1cPtBQi7Bo7Q==,sdocumentreference:SETP990000975,rtaxxadocument:219797434,sref:SETP990000975,irefindex:990000975},sdebug:Taxxa: 0.269s DIAN: 1.732s (creación 0.91s, revalidación 0.822s baja 0s)}', 47860, '2'),
(2010, '2025-04-27 15:53: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-04-27 15:53:42\",\r\n               \"tduedate\":\"2025-05-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 976,\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: 47861\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622888\",\r\n                  \"scustomname\":\"CARNE, PAPA, AREPA, TOMATE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20500,\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   ', 47861, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2011, '2025-04-27 15:53:42', '{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:4c415f2296b103c91185b5d01abcd190c073af7b510c8657e6412601c0647c1057f37b6ffe6cd5a359534b8e431da005,sqr:SETP990000976 2025-04-27 20:53:42-05:00 901402281 222222222222 20500.00 0.00 0.00 20500.00 4c415f2296b103c91185b5d01abcd190c073af7b510c8657e6412601c0647c1057f37b6ffe6cd5a359534b8e431da005 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=4c415f2296b103c91185b5d01abcd190c073af7b510c8657e6412601c0647c1057f37b6ffe6cd5a359534b8e431da005,ssignature:t+JiqfiEeRdObBZQJVjwE4p5Crl5k6If4LVlbC+R5OLgoCiUjaX/oQ4GHYoFJGJtjjcDv2PgxQilDHUa+M2IsG7HxUJAuy5RMyX8oa3VW51FnzONpmJXNGfUWux6XsWer/z1m4nmkrYSoFIGBHlA0K9ZjnF8hWCPvIv56cxLYKBJYd1Sr3pTnOcld41B4RfQvuRwq6dTRT6JBEd/qG1MOoEyy66t0i6aL4k/qwFWBxs1oOYS8m6u9VtINzyl5E0kpmTrX/jbpT+tlLueIc0iB2cpYtRM99H27PIi3aLWbc2D+sAe9cM0Bguhwt8KA+bpZNTSITDgV7lD4vlCyeyeQQ==,sdocumentreference:SETP990000976,rtaxxadocument:219806354,sref:SETP990000976,irefindex:990000976},sdebug:Taxxa: 0.278s DIAN: 1.428s (creación 0.826s, revalidación 0.602s baja 0s)}', 47861, '2'),
(2012, '2025-04-28 18:53:47', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-27 15:36:17\",\r\n               \"tduedate\":\"2025-05-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 977,\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: 47860\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622887\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":18000,\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   ', 47860, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2013, '2025-04-28 18:53:47', '{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:SETP990000977 2025-04-27 23:53:48-05:00 901402281 222222222222 18000.00 0.00 0.00 18000.00 f9f4786f995fca6ee62bd1ae488af9e385f47bf9b383cfc5a2accec10eff9c029c9161f2faaf25f4bc75efe7e1040610 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=f9f4786f995fca6ee62bd1ae488af9e385f47bf9b383cfc5a2accec10eff9c029c9161f2faaf25f4bc75efe7e1040610,ssignature:Sl+KltqT9C2pUTSkFfVlxHmVkIXAXEEe9cLUFrtByIvumdwN39T8TWkHJQM+NjNmCgmv8Odz5PQ0zRJ6A5HM8DZn6LVGO5yPm8yMsQavrWBeRxjib9hXF/TN68vdd+O/8xYJjeth9qWJH9TBiLqrAP3jpfQbZamrr7pAIxIC/FNpRtzvzEfoAMuKJ7eLmHewRUvZ8QRN+xra0JA8Sug3YF0aE+PB2IhbdCAhZBJetc7Ae9ue/GhK0/PwFvt48suI5QFiOLJEB+ajiIjCvP8BNm/31zQSTEnnEio3vI7w0j4LRoVODu5JAyuEVGm36pkhqanu1EBQdbpH5Et0u/DgsQ==,sdocumentreference:SETP990000977,rtaxxadocument:220427383,sref:SETP990000977,irefindex:990000977},sdebug:Taxxa: 0.325s DIAN: 1.352s (creación 1.015s, revalidación 0.336s baja 0s)}', 47860, '2'),
(2014, '2025-04-29 08:16:12', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-29 08:16:12\",\r\n               \"tduedate\":\"2025-05-06\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 977,\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: 47862\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622891\",\r\n                  \"scustomname\":\"cafe de guarin\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":37142.847619048,\r\n                  \"icount\":18,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":5,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47862, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2015, '2025-04-29 08:16:12', '{rerror:0,smessage:{string:{0:Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9,1:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,2:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:787eac2c49e6ec8e53acf6b58e8cabb9981b991aa20c17cd76dd2dfe88c554418f9830df0643694ac9a305288aa229c3,sqr:SETP990000977 2025-04-29 13:16:13-05:00 901402281 222222222222 668571.26 0.00 33428.56 701999.82 787eac2c49e6ec8e53acf6b58e8cabb9981b991aa20c17cd76dd2dfe88c554418f9830df0643694ac9a305288aa229c3 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=787eac2c49e6ec8e53acf6b58e8cabb9981b991aa20c17cd76dd2dfe88c554418f9830df0643694ac9a305288aa229c3,ssignature:MqLwCs7pizjtyIHLWCO2XpIpAxrB3ssoXMrGgkz8Jad7BlVHPfym9yn/fvQTTHhLmEBvo4i/389kEAEYXP+d0R7Mjg0nzqW8g1gIBsNq1YNm/Td0BeLVRJp5xQ8uhiNMX22Sy4m+tAys5zjOvfG2I+ICbukv/rPvoBbjTc9xVxeCpNloTul0Vp/B3QLy7lhURUsIXGlwXipDVTv+n6vaALoFjHVwhI5+3XpVeDK6YHYl8tpKKZ++5hIvDNi2++L6M5Qj8f8YDnwxKJOiwVWJWcEbm3p+Z/s4dFw3bxACE/2uhHBDeJUS006LW7nZQCuissiJLMPd3480HSbD0CYtaQ==,sdocumentreference:SETP990000977,rtaxxadocument:220427383,sref:SETP990000977,irefindex:990000977},sdebug:Taxxa: 0.28s DIAN: 1.41s (creación 0.671s, revalidación 0.739s baja 0s)}', 47862, '2'),
(2016, '2025-04-29 08:21:52', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-29 08:21:52\",\r\n               \"tduedate\":\"2025-05-06\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 978,\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: 47863\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622892\",\r\n                  \"scustomname\":\"cafe de guarin\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":37142.85,\r\n                  \"icount\":18,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":5,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47863, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2017, '2025-04-29 08:21:52', '{rerror:0,smessage:{string:{0:Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9,1:Regla: FAJ41, Notificación: El contenido de este elemento no corresponde al nombre y código valido.,2:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:97c06359fb3d08c085e0a61506755da68c29043fef262c6183571b67003f90e2e3aff46334cf915594f446a09b2681bb,sqr:SETP990000978 2025-04-29 13:21:53-05:00 901402281 222222222222 668571.30 0.00 33428.57 701999.87 97c06359fb3d08c085e0a61506755da68c29043fef262c6183571b67003f90e2e3aff46334cf915594f446a09b2681bb https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=97c06359fb3d08c085e0a61506755da68c29043fef262c6183571b67003f90e2e3aff46334cf915594f446a09b2681bb,ssignature:UST+lKuzVwpzZtH+0cS+4zKTAK6GbCU3jtWVpp1ETK1iMzQ5ftQOWLqiAzdPTJGxfgwuGeDl/Xu4R8QIc5R8+PPAhNHPXRNt+qT5QbG/ZmhiOPz1xIAxc6FgS2efwNWVK1/tdF6kl5LqAShdRihOQMfw6nECl6/mSE3pd7J0hlLoJDP2gCYBCY4+9RHO1MYrObLP8+zyUC4XLNb225lV70sdN2YgPbj8MrumTiDLrElXB43ka4f/+ish+szcJfoUri2knhmW5w5TfnLaDoPxeSGoEdqP0mxnWf5axyzcRNXF+wywpxWAP0FbQ+x2izEeenBR93F7ED9Zj4iJ18E8Aw==,sdocumentreference:SETP990000978,rtaxxadocument:220560909,sref:SETP990000978,irefindex:990000978},sdebug:Taxxa: 0.287s DIAN: 4.765s (creación 0.856s, revalidación 3.909s baja 0s)}', 47863, '2'),
(2018, '2025-04-29 11:16:35', '{\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
(2019, '2025-04-29 11:16:35', '{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:36-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 d7cb3716adf6fd97a821aecf2ec4e550d5bba2db6d93333a2a3191b98d127a1fbd7980dfe258ec084164e9b9339db513 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d7cb3716adf6fd97a821aecf2ec4e550d5bba2db6d93333a2a3191b98d127a1fbd7980dfe258ec084164e9b9339db513,ssignature:ZmqtnOrWwM4Cca7AqKF76NkcUBZ1FsSic4LhiMOGqKK5Gq/U9z8SoyzvOuRA6GgJeZuVeKFb6VdOwwh89CW/DMWc5L4CjhQz38tlC6ko4BeuDtgHGffrTYufadiwn7JCfgdEzQnZODMaO0vde5WUqEcATilb8ahS5AFDKQgZtH/L692sXjMYiwUOnpwbZXw6HIy9LGvurqtuzGS4PsUK+ludWMN5sfSQUJPhlpPm0s5PlhUw41E9FkU5t51HnlqW9TYW5BrKwBApAK8OiWHKS1NUPpJI0YQo/mm8ufTQc8Ojjrtc829HziLETIo+dJ9rzofikdW9Hnz81QLHJ3+41Q==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.303s DIAN: 1.092s (creación 0.707s, revalidación 0.385s baja 0s)}', 47780, '2'),
(2020, '2025-04-29 11:16:44', '{\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');
