INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2045, '2025-04-29 11:18:32', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:18:32-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 5434bc3e8f5c67c09033c603f23ad4ea904ea95c1e904e271f9a0afbefc64807a2a4a36a589e3195ec19f545c35ed55f https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5434bc3e8f5c67c09033c603f23ad4ea904ea95c1e904e271f9a0afbefc64807a2a4a36a589e3195ec19f545c35ed55f,ssignature:ZX6sb+9SshwCVPZLj4t4fJ70XccFMgcJyLthYVbyPEwNC0f+znU+wWEUSmVuwIAO8vnMaNU+yaiOQAKxCT4pRNutmzTNaBwlNV/U/4Sw7O/BQUtjDkweQU2Zq8X3okyG1g+5XVRCiAHLfj1mHNk1wvdtb+/5G/S7Vh6nyMcJgni3IaKENhSQdWXIzM6qB5cqze5bFUEOx1iVM4VWAFZVMcMUaZbA062aAI1MpdYNayXoQJ2m9MJV/qGz4iDw/YI9N0QzjZ/WVoB7P5i7kZff+Tc+GXLAMQ9rZwCbQa/hVca9DBbkaz2nHTYjsVjAoGuoTVI5swR6kIq2Vv0MG4kg/w==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.268s DIAN: 1.005s (creación 0.63s, revalidación 0.375s baja 0s)}', 47780, '2'),
(2046, '2025-04-29 11:18:40', '{\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
(2047, '2025-04-29 11:18:40', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:18:41-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 fed9f13a4c3ae2646fa161fe3ebe9bc63380ba2e04d362ee101d7849b27e482004229e990e8a120050a4abd72005cbce https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=fed9f13a4c3ae2646fa161fe3ebe9bc63380ba2e04d362ee101d7849b27e482004229e990e8a120050a4abd72005cbce,ssignature:SKbh3CKBF5UVGu0wraNHSwYwrRfMlxt2ds7dIuNCTyOLcc3T3LzB/MxU6dSGdpGSojg/Ey4Djtp1o6NMiFniuOiUwqVIEOOJZf9nSITi1TzsBRvCfldzEYR9ZL5cj0229vmdzpmLqn2lJwHqGjJ0TcFvAvcd1ucDSsB8WhmGxgKD8OR8m1m//kU8OBE57FHVsEkUiDKy1z3dPJ1GwqXyWstwX2ovrDZ+FYS3HhkYywSKXfK0KBvq+bKJ53Y/wqxz0oelNAoFpkarusp731KTS3LKArjT2TYarqXGdATDxqt9fr/bIi72oiGjzF2ZZz7ts5eKlTqteQqGp6ypJrOmag==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.287s DIAN: 1.021s (creación 0.557s, revalidación 0.464s baja 0s)}', 47780, '2'),
(2048, '2025-04-29 11:18:49', '{\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
(2049, '2025-04-29 11:18:49', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:18:50-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 a1777665ed87c70db8fc7e25d2f5a62abcfafd4be1d1d3db9f51f9d0783c32c58dd1f1c6ca569b871f2f41a61bb176d3 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a1777665ed87c70db8fc7e25d2f5a62abcfafd4be1d1d3db9f51f9d0783c32c58dd1f1c6ca569b871f2f41a61bb176d3,ssignature:P4I9NqT4vfHPtzxVazeQo83/tHltfewM1IK2ApDUNDWk2E1XRXExm6GzvZEFjsirKo/ZoteKo5/zKbQxmywqGR4nPGD38lxa9yssS1HybuGgVfH200wN/F227jPWFf1SnQ1/y0VywjPvILSETVDM3AeOGxg5YbXa/4B+jV/lP4TupiGci7ZK3CceXNq1Y96IeGJJO4N0v1CtFy6s1Wz/myXSjm7CMxIOnh4OdW+XGgcet7b6nd1AhVL2n0IG1aqUgcdNzZze7bCYtP3lTQhdGJfInMEO4p8h+FylVcW5WogqicOFw2UszA1UelRzfTtbhqaiyQpdVYBmLqLt7h5HwA==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.319s DIAN: 1.326s (creación 0.573s, revalidación 0.754s baja 0s)}', 47780, '2'),
(2050, '2025-04-29 11:18:58', '{\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
(2051, '2025-04-29 11:18:58', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:18:59-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 7300742530ced9def2b61a18d986b930262819e7652bb9983f59159fd90fd0c1822e9926e60a5d82137679d34c3de5f0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=7300742530ced9def2b61a18d986b930262819e7652bb9983f59159fd90fd0c1822e9926e60a5d82137679d34c3de5f0,ssignature:mm4nQCBhp/XIO3S2VQ1dZUnRO45bziWEGBND3b61WG+O7KBhgLWK7LZ7HckQsC8aftY5ubse185tVJprucv4rE1NQojrZK+tmR+cA0B3CmerHWIwmDJfT3pTWykcgXLsHeUYQamoUrDVCERj33gWtJS13DnMBCQNyu+i5fTOebuxahGCeHTH0MlDyPCgh3NbG+GlZksy9Y4fUgASWsREDx/HJpw3EPUDiunDqF0dqeZBxjIwKX6SbJU9EMNQbjo+TEhUqD+dBhWreapssrhPD7OLBThLoj32FWx8PjPu+b9uJbiI7i8FDURNlR7XpKWRuN2b6GTSlTR8U4XbelpCNw==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.282s DIAN: 1.119s (creación 0.67s, revalidación 0.449s baja 0s)}', 47780, '2'),
(2052, '2025-04-29 11:19:07', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2053, '2025-04-29 11:19:07', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:19:08-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 f59d6a3fde3c98306a50ac9e3b0cb35bf8023b56add9f76061d19a239d56e4c776f894a1f5ae675d405b1a9007eef4b5 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=f59d6a3fde3c98306a50ac9e3b0cb35bf8023b56add9f76061d19a239d56e4c776f894a1f5ae675d405b1a9007eef4b5,ssignature:CAVq60nJcMfosGa474/rZuoE2IVGcehx60gM8UcuWr8bmCqUilVMGujzdmH5Tg8XgEnIx1DGZVElh7bSUOoNiynyS1VAuqhHAuhDB5H+9mG++PvmfSi+sVlzEWzI5S37IaT9iehm7oDcC1cLCOHixJbEoqg8yGdgf02p6bKeyYz+MXCbhswvp32GFuQwMZwSzsbwK9/9DQiuaUL4LU9Z/piUzw7IU6++neB+XTC5R4gV9Ysa4ViarDf/wfJMcw1MRIjFX2ESZ4nb3yLnfu7DcpD5GSAsR4XxHsRnra1lumU/3/KnSn+eIIBhg18/iH3qK131Tz0hoM5ROAUrTk0VRw==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.296s DIAN: 1.582s (creación 0.915s, revalidación 0.667s baja 0s)}', 47780, '2'),
(2054, '2025-04-29 11:19:16', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2055, '2025-04-29 11:19:16', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:19:18-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 24df47a05452cc200521689f3e8741ecfaffeb8cf8763a4379536dab9a6c0573cb3a05e909ea0aea59dc010228d3f8fc https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=24df47a05452cc200521689f3e8741ecfaffeb8cf8763a4379536dab9a6c0573cb3a05e909ea0aea59dc010228d3f8fc,ssignature:FZoHnUDdvmGBaRB+VeYRjHe6fGSLNWclhLyqtp+TJq9RH8u4uGX/i7Qh9SZO17EgpfJK+I306QmOtnq6tSH0eHKUWRJ+2JoNsHY1VDPzaF2vf4tNgLalltWP1geMDVYbFwgNM7NVuNc/5USuc2tVrOSSNJYcnpCc7bshASxa16KdczaRsppC0vtIZMpQ12R2rFzEYZQVlgtE/JO9aZX+0LwDzMtQ7LR0T/RW4gv+YezzBQ5ZgsUZ8cU69rjfME5kxg7IkdKd8Su59J/BukxBjLMXUBPSrBMaXiuN+TskpiZy7IifqhmWUn2ZDrfBl6PUOsj+I3rH2PcgJhE7W6oZBQ==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.283s DIAN: 1.919s (creación 1.206s, revalidación 0.713s baja 0s)}', 47780, '2'),
(2056, '2025-04-29 11:19:29', '{\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
(2057, '2025-04-29 11:19:29', '{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:19:30-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 1168718acd93191a14950eac088f9bdc74ca138179d0c8d4e11c09dea05803b2fc46475001ad9acdff25f3698833a5b2 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1168718acd93191a14950eac088f9bdc74ca138179d0c8d4e11c09dea05803b2fc46475001ad9acdff25f3698833a5b2,ssignature:t3k12NDr3SLtu5f8RriWX1+SExcf4k/5mPBUQMzp4h5LC/xwaSDCELVPrtbgIPmAEDu3ff/d1plYhhJCXPyWUaN+qo6kksbcXh6d6HG6ZAfMRL7u7v2JBovLhDVxVk/VzX51HFo1zxF8gpbX6znZtck/80baxFR1gZQxXB8p/HffQXkrl8ldki7uI/Rb8bAptehmeHKoNTLw+MtngAmz3eO5oyPQqAZsX8zGL1Yubxdr4Vew7ldmPyXP5b5hRBSgP7QNCKJEPvzf/wLsPCjKdiilnjX4s1H99nyc18tJmd8qFR7fLa6vO28+btDSxgt9qnBlUQYvguFqrO5CzxW3DQ==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.292s DIAN: 1.242s (creación 0.863s, revalidación 0.379s baja 0s)}', 47780, '2'),
(2058, '2025-04-29 11:19:38', '{\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
(2059, '2025-04-29 11:19:38', '{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:19:39-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 afbdf70fa956d82ab395e569948fdc5aede176071cfa75531ff2a8cd815b1b997592f6509b44ef31f34945fc482284e2 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=afbdf70fa956d82ab395e569948fdc5aede176071cfa75531ff2a8cd815b1b997592f6509b44ef31f34945fc482284e2,ssignature:xPMoll9Ki2Cy7Nffk/E3FfNeoYoRgWEC+D/ef/YSbBLo24TOqRNCttCWjdeVnwEHqg7gd5YSMdpX1htEl1v2S4zZ3iu2VoxbbFWWJfat9hXlKoCIJNWzHqPrRLxZHJLDtWaBT5boNpBNlron8bE8DCyYN06n1ITn+5OAWFFI+hi2vyPiw7LhMSKhvIisscO9BQBPSzBdHWUAUKR5NdCWGnNSk16+g3wOBi61WBGPLZoF0w9Vr27pNVvIIyOXZxuy0KJB0JzgWAO/A2Nw6hKU7u2vyf/z8wxhk6umhLM675+RGBsBGlCI0hEkFjt3E3PpC/zb9S7QBTmg+rZyA5b5Xg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.282s DIAN: 2.122s (creación 0.948s, revalidación 1.174s baja 0s)}', 47780, '2'),
(2060, '2025-04-29 11:19: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-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
(2061, '2025-04-29 11:19:48', '{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:19:49-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 0f716749e93235daa8774fcdbb4bb379912a5966a456fe34184cfdae168ca72ad190bf4d2379cb8a64b836f3bcf30a00 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=0f716749e93235daa8774fcdbb4bb379912a5966a456fe34184cfdae168ca72ad190bf4d2379cb8a64b836f3bcf30a00,ssignature:qkqGXfVvwcvj5+vHOpG9Wlxa9IWYFT5aO66d1PHtMv6bIIfci6/lVtT5tSFIFAq/7kv1QkN1tHxri1B4BQL5I3V+Oncca49cTd7N2EQy8YPp+QjYC1xp2TqDINy9AFbD8pl57yAWMIraiNxRTz6gRTPrWs50n1EH5EqJnrnxdsUXEB+iKxx36P8yQm5CVfYQCQU/6lZ01+ar5z82l2DH3Q+uJARIXI5RdqPNDVh8WaK1s5FyHxi1QsfNnH72q1QR25XsdhojMv1q6ZBi5RqCfqxj6UOxTQznEpQkhFYTZhIqAZO7jHA2EZnJ5jDNDaFA+RYLIBZm42T6B/QV5IN5Jg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.274s DIAN: 2.027s (creación 0.783s, revalidación 1.244s baja 0s)}', 47780, '2'),
(2062, '2025-04-29 11:19:58', '{\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
(2063, '2025-04-29 11:19:58', '{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:19:59-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 eda5c493b47b3d994737b434784e2b1ef855742afc3ae06219ba2e2284b5f33dd6d3d698131e8ad8761f946deb70c187 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=eda5c493b47b3d994737b434784e2b1ef855742afc3ae06219ba2e2284b5f33dd6d3d698131e8ad8761f946deb70c187,ssignature:gHtcf2rZGKg22L9VR+KYQ/uxNFFurs0k/uGAVaScEyVtWGwsUM0zFuZcOAoTGUJ6cCWGG90nrK604CuHX8UfMy2Ar+DMxpLACfbScGn34L4c4YoEH7WX9e99aVPz5pGpylle785rVwhu9X/G/MwAA1THdOUGMhM6kOolyMFzFvgCxqoGCmyLe5KNNOHobVlZB7fVE+guWnVLUNUhgplVK9MXQwZqy7hLGDsCyKOEk3H060qvd/dSv1mG9pJryuGrfe4WKPs8tHnNxC+MnbGqRsXmdo3Ma0JB6GgOyRXMLEBtcrQMNU49s1WZV8wzVV3sxAih9PTezF83UVnBFN4lwA==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.266s DIAN: 1.882s (creación 1.182s, revalidación 0.7s baja 0s)}', 47780, '2'),
(2064, '2025-04-29 11:20:08', '{\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
(2065, '2025-04-29 11:20:08', '{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:20:09-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 1837d4fd13cfbf18dd6681774377f02c430a3d4b4d612ebcf6130f43948c709684b898bdab850707cb159ff8d1ffed59 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1837d4fd13cfbf18dd6681774377f02c430a3d4b4d612ebcf6130f43948c709684b898bdab850707cb159ff8d1ffed59,ssignature:SlQtfaLudBAyfDZUrJt0OY23xWnKJEqlqf/8nksK1Iuv184i9jU+rSJKn1dEzpFhnwruHRhx1FvSUExfGgnS2ihEihWN41ZLHYzEFKOykQibzY+oaWfqtHXMz0elKW5kzpQrshNmAO+7kwczk3FPb4Oz4u/ePDvyX9A1MhCbAY8mCN7LtxJgERT+xiA2ZW9TqJGoUvosjCw++2a3FptVcKCmuqxKvlBXmip+icMldPGC8M6O+YSnZzDqUViOyBA3HTcA4m+Ltb+rynaPyIguY1Ju+5UtDGk3ej9jLVagmhla/1NPxBzawFxbldHfjzEteLep4ecEvtYkS/n7p9/lWg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.277s DIAN: 1.404s (creación 0.741s, revalidación 0.662s baja 0s)}', 47780, '2'),
(2066, '2025-04-29 11:20: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-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
(2067, '2025-04-29 11:20:17', '{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:20:18-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 e2d847d98482d52c18b832778b188bb5e6085f12d8d24632780581f6c11a01b5327fd89f18ef4cfbab3849c89dd4c308 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=e2d847d98482d52c18b832778b188bb5e6085f12d8d24632780581f6c11a01b5327fd89f18ef4cfbab3849c89dd4c308,ssignature:s0IR28xK0yroSqcsA9udQP4FQ9HeQFY0lwMWYRdnkbGr2zBEQ7W84mnOHUZxNrVVgAaphH9ngfu1xp+6IN4oLsqIWhEHXAYENerEZUv/zEBegD+OJYOH1OFOxm0kGAluzBkAdkXtD44Eqj+GP3oJQLHRMAIi1B36dTGzm6F0Pf7LycP+JL9y7Arr7+L1wEbATLe4epJgfr3aWRlt1T5FGsSRIU3K8MAZ2Oy6q4uY6MZIJgr44p66k4CzvGYg9FuBozAy/q+BIDK6Odyc1s6T47gwh6rBMjCfLBiVmxMStH7+MkQcEM/qvgsmT+33GoqmQvjVcoS3bc+YWqA+Myj9lg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.282s DIAN: 1.563s (creación 0.988s, revalidación 0.575s baja 0s)}', 47780, '2'),
(2068, '2025-04-29 11:20:27', '{\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');
