INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1911, '2025-03-02 10:42:46', '{\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-02\",\r\n               \"tduedate\":\"2025-03-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9511,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"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'),
(1912, '2025-03-02 10:42:46', 'Operation timed out after 3000 milliseconds with 0 bytes received', 47781, '2'),
(1913, '2025-03-03 07:43:17', '{\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-03\",\r\n               \"tduedate\":\"2025-03-03\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9511,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47806\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622749\",\r\n                  \"scustomname\":\"SALCHICHA ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":3000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622750\",\r\n                  \"scustomname\":\"SALCHICHA ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":3000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\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   ', 47806, '2'),
(1914, '2025-03-03 07:43:17', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:432452285e3741ac7f01c0c694f6ed1c7b835daa548e95b5cfb4ab8ee73bff56aaf8c6bca3388997aaf1d55b4a9230eb,sqr:SETP990009511 2025-03-03 07:43:20-05:00 901402281 222222222222 6000.00 0.00 0.00 6000.00 432452285e3741ac7f01c0c694f6ed1c7b835daa548e95b5cfb4ab8ee73bff56aaf8c6bca3388997aaf1d55b4a9230eb https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=432452285e3741ac7f01c0c694f6ed1c7b835daa548e95b5cfb4ab8ee73bff56aaf8c6bca3388997aaf1d55b4a9230eb,ssignature:XlhsxDDtKY8Ute/4CdMSR260M8kgiPXXkPtUi6/c3IexWucy6g96GoYyTJNu7e91bQCl0NL/tl9wrEma+dZ0PROFJMSOqwwubnwvOOj/6KqbzeXrwTZRVBMxbUy589WDbWiM8mfpIpMDCbsrQE4TQ8sizIF9OvIMDz0PFqpadzKTZM+cNbulVZpe2RWmF4DpvgvbC5U19FKOkg4Sn9IBt1uTB3ER6ySFxOS6CrImLtaD9Qh6I0S52y19spSARSexIpsDQkPWonSVZL15CtSM6pbVrTscLNu8vTB8oiBA12m7tM3+negJ2WM6oYt0ubOOlSBRCWpgM9s1bQ6rIcYAVA==,sdocumentreference:SETP990009511,rtaxxadocument:null,sref:SETP990009511,irefindex:990009511},sdebug:Taxxa: 3.143s DIAN: 0.932s (creación 0.51s, revalidación 0s baja 0.422s)}', 47806, '2'),
(1915, '2025-03-03 07:43: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-03\",\r\n               \"tduedate\":\"2025-03-03\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9512,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"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: 47807\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622752\",\r\n                  \"scustomname\":\"SALCHICHA ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":3000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\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   ', 47807, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1916, '2025-03-03 07:43: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:5d51f169a24fa678bdce2a82ddb0c1d1a11be6422feccde055fc2a77c55bc534e86a4e40e490bf7c11a9690f66b00094,sqr:SETP990009512 2025-03-03 07:43:55-05:00 901402281 222222222222 3000.00 0.00 0.00 3000.00 5d51f169a24fa678bdce2a82ddb0c1d1a11be6422feccde055fc2a77c55bc534e86a4e40e490bf7c11a9690f66b00094 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5d51f169a24fa678bdce2a82ddb0c1d1a11be6422feccde055fc2a77c55bc534e86a4e40e490bf7c11a9690f66b00094,ssignature:l14zIhz145XAPxSHOup4Lc0zsSQTYj+bWthLb9b389gDOlDGoNhCQPZTcGLezGpPyIUN7jq6XCJiTWWrRo5qQ8CIj7w/haXYAcrprq+cmfVUYJFZtlPqAO0NcyIoPj0gEyM/iy+2A/cXOXzHt1n4vGLHr2SHE6+1jweSbzOgw4mjQUEL+ulCU4gYHMZMMdJG+qnYPW9YcP4mTALECavLXz/ZkuuWNIm30aCnbR7ZcY7wU2Oty8Wwim6gxu19g4bkMin1h/RV5KUxfsKqLNPIiWj0uujFJJ+56yvfwjw2hNIRfXQbReESQrH0P0XOOjno9YDVmDx/BP4+I662zhx6nQ==,sdocumentreference:SETP990009512,rtaxxadocument:190775833,sref:SETP990009512,irefindex:990009512},sdebug:Taxxa: 3.855s DIAN: 1.28s (creación 0.96s, revalidación 0.32s baja 0s)}', 47807, '2'),
(1917, '2025-03-18 09:40: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-18\",\r\n               \"tduedate\":\"2025-04-18\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9513,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"O-23\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"raulo otalvaro   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"9874704\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"raulo otalvaro   \",\r\n                     \"selectronicmail\":\"adfsadf6@sfasdf.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: 47809\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622754\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622755\",\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\",\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   ', 47809, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1918, '2025-03-18 09:40: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:75eab0133536696fe33926164ec6d007be87a7d8c52c38bcc997b6311cfa45c5fafdcbfca7003004bb470736f750f817,sqr:SETP990009513 2025-03-18 09:40:53-05:00 901402281 9874704 26500.00 0.00 0.00 26500.00 75eab0133536696fe33926164ec6d007be87a7d8c52c38bcc997b6311cfa45c5fafdcbfca7003004bb470736f750f817 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=75eab0133536696fe33926164ec6d007be87a7d8c52c38bcc997b6311cfa45c5fafdcbfca7003004bb470736f750f817,ssignature:aWbJPoAJz3YknzDqkLnNqZgaHdZTJIDxS6RSnK4t3p8HWKU7+rzxPq+h5ZtZIZVXvrHupezDIcPFe3NE0SiWAViz6qYpkBj/U7mn4BrsSbxOmN5v29NTIomD2yztJHNSu2H+ysfkpu45I8QCglQWLbVOeESNK0IB5+uG/Z+cxepYqz8O8vpk+UUJh4rXWOFAE1ngVonvhFoJ+MYpOAwP/JDImogSZ8UZijO36TYzOQ6A9VU3XjecvmW7T8gW5+GVXfWy2uQAD4Q389DXJ+Cqe+/883LJCQCQEePKC5TCmWla+PWfuBMFl8yOM7IesN+0ELlrhFw7//YOBMsjEbu3Pg==,sdocumentreference:SETP990009513,rtaxxadocument:198386009,sref:SETP990009513,irefindex:990009513},sdebug:Taxxa: 0.313s DIAN: 2.308s (creación 1.156s, revalidación 1.152s baja 0s)}', 47809, '2'),
(1919, '2025-03-18 09:44:11', '{\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-18\",\r\n               \"tduedate\":\"2025-03-18\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9514,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"O-23\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"raulo otalvaro   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"9874704\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"raulo otalvaro   \",\r\n                     \"selectronicmail\":\"adfsadf6@sfasdf.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: 47810\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622757\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\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   ', 47810, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1920, '2025-03-18 09:44:11', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:d5fb722711857d7f94528aee39263ee8f95161e942f362930699ec624f487f4bcd96f1c30ca075fb952645d72191390e,sqr:SETP990009514 2025-03-18 09:44:12-05:00 901402281 9874704 6000.00 0.00 0.00 6000.00 d5fb722711857d7f94528aee39263ee8f95161e942f362930699ec624f487f4bcd96f1c30ca075fb952645d72191390e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d5fb722711857d7f94528aee39263ee8f95161e942f362930699ec624f487f4bcd96f1c30ca075fb952645d72191390e,ssignature:KR0WT6RYLo4DpMWmFwMVAmKS2H0xbEbpYcuRIY8mUlOQvMFRaWbUBtbVVvNdDf8TL0aEKTRkkA1vJZn+NMqRprJOFfUpqek3i0qoOgbXgMBT/hRt2/0Zp5wphxpoUv6tAu84Au7cmmz1tX2fv86XUYN57SMgMF4mGM8EovmEEL/V99JxUsL/XNfulsaRWqmgrhfyLp9HmcGs5QtcfjLrPeZJy6ihsi5vi1gl+sOyjZ6FIhSLS90y0cglZ8GzbCoUIesHpyzeFgq6AxasQqksf5pH0VeRfwmCsDhfACqqzH3c8rE2OfD9zwgTzvX7eDUlPBrTEqxzjgmy3ae+VzupFg==,sdocumentreference:SETP990009514,rtaxxadocument:198387643,sref:SETP990009514,irefindex:990009514},sdebug:Taxxa: 0.281s DIAN: 2.327s (creación 0.958s, revalidación 1.37s baja 0s)}', 47810, '2'),
(1921, '2025-03-19 14:42:06', '{\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-19\",\r\n               \"tduedate\":\"2025-03-26\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9515,\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\":\"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: 47814\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622781\",\r\n                  \"scustomname\":\"PICADA MEGAFAMILIAR \",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622782\",\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\",\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   ', 47814, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1922, '2025-03-19 14:42: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:dffa52790a3ee4e49bfb52d74d2f7a6c765419677328e16c0e451c1290fedff84aa23d9721a336be4467458d47e50e6f,sqr:SETP990009515 2025-03-19 14:42:06-05:00 901402281 222222222222 150000.00 0.00 0.00 150000.00 dffa52790a3ee4e49bfb52d74d2f7a6c765419677328e16c0e451c1290fedff84aa23d9721a336be4467458d47e50e6f https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=dffa52790a3ee4e49bfb52d74d2f7a6c765419677328e16c0e451c1290fedff84aa23d9721a336be4467458d47e50e6f,ssignature:rNxWna/vkHPHtP6PDTJwC/vanx8Hp2Ja9ZF4CjFan9uFJMy8BqH734JnDFux4+OEW640kC/FGdKpePGeQ9TmPIfwd3GLkZinNRwjnamyI2g+wmd50fRaNIpMal5knfkLI4/uRSC9EMXYLXpKE/VSYDUDKOy9se7Gp4tp+nUc3zLmxKfxo1gWWnW9o3dF+B2t5o6D4x0l5NLPZ17qsp8ryB75bJXunTBDIDHqDhcyWSsOSjXY8u8Aub+vWPcsQN6S0YHEmZKjCWj19WTDvI7QkYuiCw1ysP4b0WCgoxxKqtoj/WWQQOG0BwN1JjX7ie74F+S95FzpkqpmBFqqtAgcCQ==,sdocumentreference:SETP990009515,rtaxxadocument:199027306,sref:SETP990009515,irefindex:990009515},sdebug:Taxxa: 0.326s DIAN: 1.512s (creación 0.962s, revalidación 0.55s baja 0s)}', 47814, '2'),
(1923, '2025-03-26 20:31:41', '{\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-26\",\r\n               \"tduedate\":\"2025-04-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9516,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"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: 47815\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622788\",\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   ', 47815, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1924, '2025-03-26 20:31:41', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:5d16046c9f5af6851b984a4ddeda9881f8d96f60796d71add427d9b5ed24f227cc014da77165efc4d5f441a86b4b7eb9,sqr:SETP990009516 2025-03-26 20:31:41-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 5d16046c9f5af6851b984a4ddeda9881f8d96f60796d71add427d9b5ed24f227cc014da77165efc4d5f441a86b4b7eb9 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5d16046c9f5af6851b984a4ddeda9881f8d96f60796d71add427d9b5ed24f227cc014da77165efc4d5f441a86b4b7eb9,ssignature:ueOtz8srt32Ij9pPSIqQ4PErIHKZwGAAbD9tmsio96elGJSQrfUCoKijmFfxe3c/ZsfuaGswiVqn/04KoRZ3QigWnhO7Jeaszp4zR7ybFcIdPmpFEIw7UgnzER9E8HrxX4kmP6Y8m5Tp1XAN5Rfgg+NJRi8fsSehvbm7PEh31+Twd853qeUEfd+La9NcUv2kH9CAoIk3eyfJ19h6qj5pM6kNZRyktBjm3WJzf69cITyfH6WbbcoupuuqypBMC18MlBQzddIxgHJ7BA6NDKmfXabNTI+sKNEgvhzEfBaPEGXm/JDroqSNyvQO2duVrSwRQWBp1nbEmtBkZ+CAURMlog==,sdocumentreference:SETP990009516,rtaxxadocument:202602753,sref:SETP990009516,irefindex:990009516},sdebug:Taxxa: 0.486s DIAN: 1.373s (creación 1.001s, revalidación 0.372s baja 0s)}', 47815, '2'),
(1925, '2025-03-29 01:25: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\",\r\n               \"tduedate\":\"2025-03-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9517,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"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: 47822\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622796\",\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   ', 47822, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1926, '2025-03-29 01:25: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:937d4c46d5645cd80473a1cde561f6ebb849fa058accaf046739f74f966b583bcc7efbf2fdbe3c7174e4792cd9fc6e05,sqr:SETP990009517 2025-03-29 01:25:21-05:00 901402281 222222222222 900.00 0.00 0.00 900.00 937d4c46d5645cd80473a1cde561f6ebb849fa058accaf046739f74f966b583bcc7efbf2fdbe3c7174e4792cd9fc6e05 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=937d4c46d5645cd80473a1cde561f6ebb849fa058accaf046739f74f966b583bcc7efbf2fdbe3c7174e4792cd9fc6e05,ssignature:tedmqdlnn3k0Ur+uEXabhbP2sIBIEqHpAhXruhgYavoV0P93wh+btHVfyM+Sycf4RDke6jxTCJPH4V5VAFt+NLojI30pINST6UdPLzMgDgG0MWNS/K459sCjfEB0L9uUwYIzFnAPFfVWoZt6RQmj6UCCTgX3IIXe2hjLYcDtMwxTyhnJqd4IZXkqkCcSBvCq74HyXs4aTUlnjQHlfS0W5NR4ImAmRNHgnm5vlLPPH9zoPXy1wZcM/9IDtbH9QbK0vOngvzp7PvJW9oBh6HFCJahPyYmQRSYQMKFs5TRNorTKkgTvxYs1jEYFAgBnYQ2NnTAo3baKcm9w8nTD2ddDzg==,sdocumentreference:SETP990009517,rtaxxadocument:203671648,sref:SETP990009517,irefindex:990009517},sdebug:Taxxa: 0.284s DIAN: 1.701s (creación 1.033s, revalidación 0.668s baja 0s)}', 47822, '2'),
(1927, '2025-03-29 01:45:33', '{\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\",\r\n               \"tduedate\":\"2025-03-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9518,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"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: 47829\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622803\",\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   ', 47829, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1928, '2025-03-29 01:45:33', '{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:22c43cf90a05825676d64ca905cef3ec88635fd4c76134191415077e7961f93f8960beb670d8ed088d9ee18effe900e2,sqr:SETP990009518 2025-03-29 01:45:34-05:00 901402281 222222222222 900.00 0.00 0.00 900.00 22c43cf90a05825676d64ca905cef3ec88635fd4c76134191415077e7961f93f8960beb670d8ed088d9ee18effe900e2 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=22c43cf90a05825676d64ca905cef3ec88635fd4c76134191415077e7961f93f8960beb670d8ed088d9ee18effe900e2,ssignature:m2R6gY06nNltvTruntGpbNdr2uh6ghueDZBapGRbxwxwd0SW4+vC1+buQHhR6GxWLW5IgapSYjnHuvCLzIKt2mBVNKcQZY297u43pZF4p/q39nWgBeEQd3/HPyNPZffuR/biR6ksLOk9s3oKOxp62p0wEHs1wsN3oTadLpmLduFdMKnSSkRuws3SruEAX1RNZS0JwQGBhXcRLfO7m3qDhjPRCAyjhIuY4Ivti8ULAA0QYe/JzEmDl2/n0csMkUFqTTM43obsq8juh0fVi4ISimFc+Af1cgPTNmulj0bBPTPkwj09KEsXzzzRP6LtiHquIa2mvpFq4q0O3dBwJ4DNUw==,sdocumentreference:SETP990009518,rtaxxadocument:203672761,sref:SETP990009518,irefindex:990009518},sdebug:Taxxa: 0.274s DIAN: 1.276s (creación 0.82s, revalidación 0.456s baja 0s)}', 47829, '2'),
(1929, '2025-03-29 02:15: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-29\",\r\n               \"tduedate\":\"2025-03-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9519,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"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: 47828\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622802\",\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   ', 47828, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1930, '2025-03-29 02:15:09', '{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:dae855f1120f91f246b0154cdce8c96e0eff0fc9f6c1711d7ab4b618dd4399c3fb4a53b665c6c67cb205c5a07748400a,sqr:SETP990009519 2025-03-29 02:15:09-05:00 901402281 222222222222 900.00 0.00 0.00 900.00 dae855f1120f91f246b0154cdce8c96e0eff0fc9f6c1711d7ab4b618dd4399c3fb4a53b665c6c67cb205c5a07748400a https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=dae855f1120f91f246b0154cdce8c96e0eff0fc9f6c1711d7ab4b618dd4399c3fb4a53b665c6c67cb205c5a07748400a,ssignature:YoyZTjdjzcZNIUkCdEzO0hB7K3aStnX2AcMWg0LO5utNqxPnPtKDXKccwG+PMLRgypqd7b9IHAp9i5FgS3CWOK7o5d5r8Dc6jsBdzy+IX6C+enJxBX0Zazdzzd8/Tr290Dw09+2vwFJA2GDYuPql2d0IWRXM8LrvSAlczMPuBQYI5D77wbXyagR/PFJiaL2kSXLWBI/SpMsLz8lQBFE5kFNEHvlUwOKYzD/cWPCLwHUxeeezr+M3SxrVZfgadfsKqLLhL9qhY997YZJ29tk5g4sd9zXVSnPrDkAhrhO21dWbhabZsFyHiPbB1i8v8VyQCK6OgpTLNLjK8KVGEgQR0A==,sdocumentreference:SETP990009519,rtaxxadocument:203674038,sref:SETP990009519,irefindex:990009519},sdebug:Taxxa: 0.26s DIAN: 1.607s (creación 0.931s, revalidación 0.676s baja 0s)}', 47828, '2'),
(1931, '2025-04-01 19:44: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-04-01\",\r\n               \"tduedate\":\"2025-04-01\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9520,\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\":\"JULIANA  QUICENO \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"JULIANA  QUICENO \",\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: 47811\"\r\n                ,\"aallowancecharge\": {\r\n            \"0\": {\r\n                  \"schargeindicator\": \"true\",\r\n                  \"sallowancechargereason\": \"Propina\",\r\n                  \"sallowancechargereasoncode\": \"04\",\r\n                  \"smultiplierfactornumeric\": \"5\",\r\n                  \"namount\": 2000,\r\n                  \"nbaseamount\": 41000\r\n            }\r\n         },\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622758\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622761\",\r\n                  \"scustomname\":\"COCACOLA 192ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":5000,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622762\",\r\n                  \"scustomname\":\"COCACOLA 192ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":5000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622763\",\r\n                  \"scustomname\":\"LIMONADA DE COCO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8000,\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   ', 47811, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1932, '2025-04-01 19:44: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:cc15f62814a7c2f6fbaa4923acd3b640666b87206d523160bacc446de610895587656fb16efc2d9cda32d6ead3a97be0,sqr:SETP990009520 2025-04-01 19:44:14-05:00 901402281 1564561 41000.00 0.00 0.00 43000.00 cc15f62814a7c2f6fbaa4923acd3b640666b87206d523160bacc446de610895587656fb16efc2d9cda32d6ead3a97be0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=cc15f62814a7c2f6fbaa4923acd3b640666b87206d523160bacc446de610895587656fb16efc2d9cda32d6ead3a97be0,ssignature:wBg/oqREg2DlzzNUFly/o1islJYCkKYDo0jXv7B9NAdJTw36lqVU82ci4y0adeEr/8zqMg9zd1Jv8KCGQwoXmJCv+J9mbNV4gRafB4Ey/ULAA0ZNjzpXRFAH4AZEs2n7J/f9OZuu40CtLgO12RWzLPYYa1IMkCjXUslTC0MYbs5/T5a64lvEn0a74CWqUdgpGLuOh78xdLpCUNGNL4/XurW6zXueFRemRa+ITo2jWiiUTuY/ooaskg4M54SqXqO5yEYoDKP1OL22t/7NI081YEOIqahxuXc76XkLsRlM/LvXSICXNBr9duyMgXOHrGHXu0+0BmM+OuOXZ8Jv1nQdwg==,sdocumentreference:SETP990009520,rtaxxadocument:205746343,sref:SETP990009520,irefindex:990009520},sdebug:Taxxa: 0.514s DIAN: 1.689s (creación 0.809s, revalidación 0.881s baja 0s)}', 47811, '2'),
(1933, '2025-04-01 19:44:59', '{\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\": 9521,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"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: 47812\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622765\",\r\n                  \"scustomname\":\"ALMUERZO ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":22500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622768\",\r\n                  \"scustomname\":\"CARNE TRIMIXTA 460gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":32500,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622773\",\r\n                  \"scustomname\":\"CARNE ENTERA 320gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":27000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622777\",\r\n                  \"scustomname\":\"COMBO INFANTIL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":16500,\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   ', 47812, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1934, '2025-04-01 19:44: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:4c22cedb993995983acef66a937a54bfcf03e12d6a34c6458c3dc12dbe1f8aac2dd0d86a2f0655a063043fe5b740bc42,sqr:SETP990009521 2025-04-01 19:45:00-05:00 901402281 222222222222 98500.00 0.00 0.00 98500.00 4c22cedb993995983acef66a937a54bfcf03e12d6a34c6458c3dc12dbe1f8aac2dd0d86a2f0655a063043fe5b740bc42 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=4c22cedb993995983acef66a937a54bfcf03e12d6a34c6458c3dc12dbe1f8aac2dd0d86a2f0655a063043fe5b740bc42,ssignature:Lnbsuw5oPMOV4HqBxSYKYvw7KSYXxbdLFfAXztPZAhuIu/K/vxy3napX2p9iOgx/xjF4+GDnhKwtkEQ0LAYCDtgqcWlg9sMmesHci3b3AKbHVY5yvFJDwnh/0Eplm2Z7ynP1C3sV7r67H+ITex7PdAp1dbYD+p0hBuy/J5MlUf9iAeORfUQc61IHOQMm0d6DhIIGxjC/Hj3ZktTStOe63lCSWXHHxpgvmDEeZ959B/QwOXKTap8dyipqv44XkeEimBBCKTpO96JBueKfNTu6oTp77Ho/YZu1eyCvE3uwy2fS0oSM5sqtYAPq5OpuZShNRqtbWAJi+XiyUHf4hEnHcw==,sdocumentreference:SETP990009521,rtaxxadocument:205746755,sref:SETP990009521,irefindex:990009521},sdebug:Taxxa: 0.758s DIAN: 5.325s (creación 2.762s, revalidación 2.563s baja 0s)}', 47812, '2'),
(1935, '2025-04-01 19:45:59', '{\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\": 9522,\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: 47813\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622780\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\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   ', 47813, '2');
