INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2140, '2025-05-26 13:43:49', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:9e5266cc1a93b506599e82896e26279c8aad55f7039c2237bcdd9f23b8aefe5a276464a1bb4f05784e2ab420ab370abd,sqr:SETP990000001 2025-05-26 13:43:49-05:00 901402281 222222222222 5000.00 0.00 0.00 5000.00 9e5266cc1a93b506599e82896e26279c8aad55f7039c2237bcdd9f23b8aefe5a276464a1bb4f05784e2ab420ab370abd https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9e5266cc1a93b506599e82896e26279c8aad55f7039c2237bcdd9f23b8aefe5a276464a1bb4f05784e2ab420ab370abd,ssignature:G35MiL2moXs43JoOkAquIAsfHUmocQYXuayGdkruCBr0sTfVBV756AJ9G+zJs8LexlgHhKGDAM5S19MghzHXZ+eyiBTWjG6QfREt/sTfYeST0lM6ouzbQJ9sVgwxwka10jk/Y+1ez1Mm6If0mgE+nSLXjO59Er89YBlrUB8uxLWhyovis5EFbA6UHPkxyvctP3p0YY5HhcLibd4WWPTVjylwARgpp+xVttx2R+GYcW4Uw6TBBPvwiJ3/on/0MoFs0c+OTEZjWkCTzmm4FE7rjWZSe+8wvOFBaTMnqIpQeipOXmIY7TKOd/EH1RltGiEo3XOTBLLq9s2yjl2c1/WQlw==,sdocumentreference:SETP990000001,rtaxxadocument:234958700,sref:SETP990000001,irefindex:990000001},sdebug:Taxxa: 0.308s DIAN: 0.614s (creación 0.614s, revalidación 0s baja 0s)}', 48925, '2'),
(2141, '2025-05-26 13:44:16', '{\r\n      \"sToken\":\"396316085266\",\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-05-26 13:44:16\",\r\n               \"tduedate\":\"2025-06-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 2,\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: 48926\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00623987\",\r\n                  \"scustomname\":\"Lampara techo Led 5T B34\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":12300,\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   ', 48926, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2142, '2025-05-26 13:44:16', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:975c417de7d25a783d57d27a64b3dfa747b13cb17ac766760610640661f080d1978afa80f868160606d8945e2a6ad0c6,sqr:SETP990000002 2025-05-26 13:44:16-05:00 901402281 222222222222 12300.00 0.00 0.00 12300.00 975c417de7d25a783d57d27a64b3dfa747b13cb17ac766760610640661f080d1978afa80f868160606d8945e2a6ad0c6 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=975c417de7d25a783d57d27a64b3dfa747b13cb17ac766760610640661f080d1978afa80f868160606d8945e2a6ad0c6,ssignature:Q1+SQeAgzG/ZyeZMOnrN7E8l1PXokSI/nZumi7DGxcfYciM3ZgCyhdFY+9deJ2H8JnG5wfJ8mFUoJlXPRV1cu/pmfliwVe10lvXx1IEPt58Susi4+wbR13MVE5PT8zver+Sbk0qNmmme8nZMpDm22HSGiERIahBRgim5UCygIvECyBjPDfZnRQgvmrK78ugYobzwHfbn5wmuz5ThVwxfBz78QTYS+O197CBqJ1MVusZRLGTU0DVAqZb+V3EIOBErUbvNaNYuId8qvE0EMDb6jjQF1KRYwQjJqKrIrapWQbkWjoaiqIFkzJpZ3Hu84bE1POo/xv2/+ro7kc4dTvZldA==,sdocumentreference:SETP990000002,rtaxxadocument:235758021,sref:SETP990000002,irefindex:990000002},sdebug:Taxxa: 0.299s DIAN: 0.362s (creación 0.362s, revalidación 0s baja 0s)}', 48926, '2'),
(2143, '2025-05-28 16:41:12', '{\r\n      \"sToken\":\"396316085266\",\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-05-28 16:41:12\",\r\n               \"tduedate\":\"2025-05-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 991,\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: 48927\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00623988\",\r\n                  \"scustomname\":\"PICADA PERSONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":25000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 48927, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2144, '2025-05-28 16:41:12', '{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:2caae0e43aeabeda8d8d42fad7834faf3746271c192aea2f310673892ef31beec8af23a0b2bcd1e46937d0970ce4da2e,sqr:SETP990000991 2025-05-28 16:41:13-05:00 901402281 222222222222 25000.00 0.00 0.00 25000.00 2caae0e43aeabeda8d8d42fad7834faf3746271c192aea2f310673892ef31beec8af23a0b2bcd1e46937d0970ce4da2e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=2caae0e43aeabeda8d8d42fad7834faf3746271c192aea2f310673892ef31beec8af23a0b2bcd1e46937d0970ce4da2e,ssignature:PRz6i0p2ZLiOasJZWErRq7/IZ1uuxtN1s0gtrUSDwjXNFeEO8h3wp9GOgV+1dw4Fc7hcsdZmHu841dGqo7ddpPBZj3AXUGN8Xz8nnqdFEKO8Z9NAqR/GkQ2uOnMUtS9XE3LlofTBcESgJ1uRFitYf/meIDsoOSoVWia7Vf2W8LlFfaJa9wLBg6HZUehQKyQ9HaKi/qOOJFg8pAQ9mDEY6VrWS1KYiC2wZ/c0oliw/Oczonlt80vVGRNFe9eOnIwO9OLbvMvc4jyvhdilfBHJJiXXRsbpTCyY4fqE112B66p0AYMmpCH0UVmldXA1hbuqmIdqpXGIHS0I8ojrS+7jNQ==,sdocumentreference:SETP990000991,rtaxxadocument:236949208,sref:SETP990000991,irefindex:990000991},sdebug:Taxxa: 0.286s DIAN: 1.137s (creación 0.731s, revalidación 0.405s baja 0s)}', 48927, '2'),
(2145, '2025-05-28 18:18:21', '{\r\n      \"sToken\":\"396316085266\",\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-05-28 18:14:29\",\r\n               \"tduedate\":\"2025-05-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 992,\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\":\"JOHAN SEBASTIAN\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"1088024379\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"HURTADO GARCIA JOHAN SEBASTIAN   \",\r\n                     \"selectronicmail\":\"cartafacturacion@gmail.com\",\r\n                     \"stelephone\":\"123456789\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 48928\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00623991\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\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\",\"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   ', 48928, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2146, '2025-05-28 18:18:21', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:c78125716db2788f6f5ce26df952c84d36a9be1d23bb3db529c9e7715046809736c08deccb5cca41447cc42f9e70bf1c,sqr:SETP990000992 2025-05-28 18:18:22-05:00 901402281 1088024379 3000.00 0.00 0.00 3000.00 c78125716db2788f6f5ce26df952c84d36a9be1d23bb3db529c9e7715046809736c08deccb5cca41447cc42f9e70bf1c https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c78125716db2788f6f5ce26df952c84d36a9be1d23bb3db529c9e7715046809736c08deccb5cca41447cc42f9e70bf1c,ssignature:fsjdzb575NJYrfejRM85SLf3HTxUmqC+EnvxaRp2AgddjgO/GerRo4R2UciuHGqqc3iM+6k5y/nFqrGZE89ica6EPLjdk4jkGmni58gDDtRF4KHIrWMas3s693IaZMYinsZB8GxBf3xjvI6O2aYuTrXPkf4W3Q1NN6yCLiiO0C7apKVH0qQpK17x4vIsOR5jMh3h9ij8KPCJJO0ulJcWfwYZsWO4035e26kRUYorytTfJ/OcAV2xaxQihPrEdC08FDV2sKJKSY9MSphxfzgJrPTV7Z+u/xSjxOuq/goGFzFpkfWT7RM17ODXDZJieMCe0vMl7XtTWqDVUztFsIRGuw==,sdocumentreference:SETP990000992,rtaxxadocument:237042114,sref:SETP990000992,irefindex:990000992},sdebug:Taxxa: 0.294s DIAN: 0.412s (creación 0.412s, revalidación 0s baja 0s)}', 48928, '2'),
(2147, '2025-05-28 18:22:08', '{\r\n      \"sToken\":\"396316085266\",\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-05-28 18:21:14\",\r\n               \"tduedate\":\"2025-05-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 993,\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\":\"JOHAN SEBASTIAN\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"1088024379\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"HURTADO GARCIA JOHAN SEBASTIAN   \",\r\n                     \"selectronicmail\":\"cartafacturacion@gmail.com\",\r\n                     \"stelephone\":\"123456789\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 48929\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00623992\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\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\",\"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   ', 48929, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2148, '2025-05-28 18:22:08', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:0d57520568e8f53fc0e758f0f2070de00134941b7bd8b66c81febd64b2eaf572e75e85fd43193863c8678c7f838000aa,sqr:SETP990000993 2025-05-28 18:22:09-05:00 901402281 1088024379 3000.00 0.00 0.00 3000.00 0d57520568e8f53fc0e758f0f2070de00134941b7bd8b66c81febd64b2eaf572e75e85fd43193863c8678c7f838000aa https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=0d57520568e8f53fc0e758f0f2070de00134941b7bd8b66c81febd64b2eaf572e75e85fd43193863c8678c7f838000aa,ssignature:ZD/hGPptGAlK6hkidsRnRzS5sLCvncnT5qSV6gIZ9ZeHNgjtKJe7eqVcEg5wFeGLZH9dlCINNkac86hv9R+rCsWi+DhrXaLxxDiHm5mjvIF/i9LYKCH0EP7+9YvAV5N/saEsUU5ioyWMBND1EknYeqDJt69yd/UWlGlPjBicf+YWAf09Y/gpRCczDYPQhFmWhXYs8AqB1Ui/lTvOjX+dT7DbWnaDPvcIpnHVgSVVidovm/zwgQuLfa9Lu+kd+6hbY+O5zJ3EH5krNqrTGCF3EgJUMyXMWZsyvwTmLooIJO3CkgWh3EYAFoVenKhuhbnHAPPgeK28Cb9NKeOfGqKv2A==,sdocumentreference:SETP990000993,rtaxxadocument:237044057,sref:SETP990000993,irefindex:990000993},sdebug:Taxxa: 0.274s DIAN: 0.382s (creación 0.382s, revalidación 0s baja 0s)}', 48929, '2'),
(2149, '2025-05-28 18:22:59', '{\r\n      \"sToken\":\"396316085266\",\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-05-28 18:21:14\",\r\n               \"tduedate\":\"2025-05-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 994,\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\":\"JOHAN SEBASTIAN\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"1088024379\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"HURTADO GARCIA JOHAN SEBASTIAN   \",\r\n                     \"selectronicmail\":\"cartafacturacion@gmail.com\",\r\n                     \"stelephone\":\"123456789\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 48929\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00623992\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\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\",\"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   ', 48929, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2150, '2025-05-28 18:22:59', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:e6553125fba73e072d5d49b7221501c19fc1eaee8a1427b135d7f94008a3d41825462881fffe7d46925e7f39afadf5e2,sqr:SETP990000994 2025-05-28 18:23:00-05:00 901402281 1088024379 3000.00 0.00 0.00 3000.00 e6553125fba73e072d5d49b7221501c19fc1eaee8a1427b135d7f94008a3d41825462881fffe7d46925e7f39afadf5e2 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=e6553125fba73e072d5d49b7221501c19fc1eaee8a1427b135d7f94008a3d41825462881fffe7d46925e7f39afadf5e2,ssignature:x2JjmRasrdsYj454Xv/HQ0GkMCRPk0H9NOC4uhR7tUFBLJ5E2qn/TCiQteN7xlIGTausfLY1u7s+NVy6MPRZ7ADkchSZp+vkK+xfyzbS9iBdjKRALbpGhTldxRvsaYFTcAZN8xb1vDkgnB6UY913ggcShxl1kl5w4Ktktb0lhS3PvO52P+EfC1+ccbDDuVC9N/2+KdiRG836Mhm0YTuKnjq9xzSQyB86oAMJG5rpLnlr4P6DOGuiJauQwplT6Jr5U44HyEQOI5t054HtJUjOCvDqS5FkgKjQFt/6OOSQolW7NcPtwhHcxIezC3Ic7hn3zj4gewt4JG161yEhTzlg1A==,sdocumentreference:SETP990000994,rtaxxadocument:237044510,sref:SETP990000994,irefindex:990000994},sdebug:Taxxa: 0.29s DIAN: 0.488s (creación 0.488s, revalidación 0s baja 0s)}', 48929, '2'),
(2151, '2025-06-04 13:16:54', '{\r\n      \"sToken\":\"396316085266\",\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            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-06-04 13:16:54\",\r\n               \"tduedate\":\"2025-06-11\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 995,\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: 48963\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00624046\",\r\n                  \"scustomname\":\"1/2 JARRA DE LIMONADA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"saddresszip\":\"660001\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66001\",\r\n                    \"scityname\":\"PEREIRA\",\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                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 48963, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2152, '2025-06-04 13:16:54', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:95df757056935e15dbc7a9ba9e22713eb85afa98a1286b1dbb7832db355d3604b4e3c57edeae4b987e05d26fca8d38eb,sqr:SETP990000995 2025-06-04 13:16:55-05:00 901402281 222222222222 8000.00 0.00 0.00 8000.00 95df757056935e15dbc7a9ba9e22713eb85afa98a1286b1dbb7832db355d3604b4e3c57edeae4b987e05d26fca8d38eb https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=95df757056935e15dbc7a9ba9e22713eb85afa98a1286b1dbb7832db355d3604b4e3c57edeae4b987e05d26fca8d38eb,ssignature:UcocS98j2MjbJyzOyDn5WEZDUz2ARl/+AiViv60ajVkV9qOWwfoPOMkwpdhU8yFxgDx/hhL+zrVCxQ1ZrNmlAjtmJ+BhoD+aKu43cEWmz3GYTfBdMn3MfUivLFUwjt8RsbOfSCAUKvPjE4sUBgZAZn/wDQZMA0tNPwIGXyGQjxkSLNJOjMUZeokTx3iHBPUGRpMS1JiSuX9TGKMKDNLwJi3xM9+eamC5D4po182kQmznK6Hpt+2SaWgah8luK+E7zMhfoSlc1DeG03vCCYHbj4IgcYjrooTaHtA+iXZdDXcWoXd1aZUjdUgbdfetlK134cRfjowOygPfkIHP+Kehsg==,sdocumentreference:SETP990000995,rtaxxadocument:240818268,sref:SETP990000995,irefindex:990000995},sdebug:Taxxa: 0.286s DIAN: 0.344s (creación 0.344s, revalidación 0s baja 0s)}', 48963, '2'),
(2153, '2025-06-04 15:46:26', '{\r\n      \"sToken\":\"396316085266\",\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            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-06-04 15:46:26\",\r\n               \"tduedate\":\"2025-06-11\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 996,\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\":\"   raul\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"3158\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"   raul   \",\r\n                     \"selectronicmail\":\"sarasdfasd@sasdf.com\",\r\n                     \"stelephone\":\"otalvaro\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"casdlfj asdlfj asdf\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 48972\"\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\": 3790,\r\n                  \"nbaseamount\": 71600\r\n            }\r\n         },\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00624055\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA MORA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":13000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00624056\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7900,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00624057\",\r\n                  \"scustomname\":\"ADICIONAL DE CARNE DE RES\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8500,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00624058\",\r\n                  \"scustomname\":\"ADICIONAL DE CARNE DE RES\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8500,\r\n                  \"icount\":1 \r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00624059\",\r\n                  \"scustomname\":\"PICADA PERSONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":25000,\r\n                  \"icount\":1 \r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00624060\",\r\n                  \"scustomname\":\"POLLO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":1700,\r\n                  \"icount\":1 \r\n               },\"7\":{\r\n                  \"sStandardItemIdentification\":\"00624061\",\r\n                  \"scustomname\":\"LIMONADA NATURAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"saddresszip\":\"660001\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66001\",\r\n                    \"scityname\":\"PEREIRA\",\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                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 48972, '2'),
(2154, '2025-06-04 15:46:26', '{rerror:4727,smessage:Taxxa - Buyer document type CC, CE or NIT can only contain 5 to 15 numbers. Do not send the validation digit.,sdebug:Provided: 3158}', 48972, '2'),
(2155, '2025-06-04 15:46:44', '{\r\n      \"sToken\":\"396316085266\",\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            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-06-04 15:46:44\",\r\n               \"tduedate\":\"2025-06-11\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 996,\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: 48973\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00624062\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":18000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"saddresszip\":\"660001\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66001\",\r\n                    \"scityname\":\"PEREIRA\",\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                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 48973, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2156, '2025-06-04 15:46:44', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:21751d7dd9ed9d1febef97aa5c37068b36858864d9f1e424eba8e151da476d5bea0b1814d1b81854521bb69f34eda1db,sqr:SETP990000996 2025-06-04 15:46:44-05:00 901402281 222222222222 18000.00 0.00 0.00 18000.00 21751d7dd9ed9d1febef97aa5c37068b36858864d9f1e424eba8e151da476d5bea0b1814d1b81854521bb69f34eda1db https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=21751d7dd9ed9d1febef97aa5c37068b36858864d9f1e424eba8e151da476d5bea0b1814d1b81854521bb69f34eda1db,ssignature:DS6KZ5rqOKyEfz6AdAY0iROn72i5EgCSBYt2/1otdZvOX+OYpsl74cxYmcSJxHMscf1RoQDUSBSeG6Dqy+A62A2VxsHnsMHSdXZfxAnIcNr0tuTDS/xKl/f7OaGRCzzMSFHUdOSUZMUsZurbJiLP03y7YNqVCUuaU/+0KOI2Cq4zo1xUHIkUBI3Ei1VSK+1AqDOWMwejOsxSuLl8cLsFg2YmmVIgGDrQcbgwJsgc3VNPqNAMUo4tElxNDi4FFXQTEYiEC/EUgTDJ9il49uUCoaeOmBEPBWCuIzisC/dEZPSAtZT0LVX4FFOCYimVPTfS8bGCBtXjp6mWTjXYEiM6jw==,sdocumentreference:SETP990000996,rtaxxadocument:240913950,sref:SETP990000996,irefindex:990000996},sdebug:Taxxa: 0.302s DIAN: 24.785s (creación 24.785s, revalidación 0s baja 0s)}', 48973, '2'),
(2157, '2025-06-20 16:50:14', '{\r\n      \"sToken\":\"396316085266\",\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            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-06-20 16:50:14\",\r\n               \"tduedate\":\"2025-06-27\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 997,\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: 49011\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00624153\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21904.761904762,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":5,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00624156\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21904.761904762,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":5,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"saddresszip\":\"660001\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66001\",\r\n                    \"scityname\":\"PEREIRA\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\" \r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 49011, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2158, '2025-06-20 16:50:14', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:d0e1ef0a4a63894a1809ccdc4f20309e835a7290912875e4b967700c39263c66b7867628dbce69812d3a09348f8b9131,sqr:SETP990000997 2025-06-20 16:50:15-05:00 901402281 222222222222 43809.52 0.00 2190.48 46000.00 d0e1ef0a4a63894a1809ccdc4f20309e835a7290912875e4b967700c39263c66b7867628dbce69812d3a09348f8b9131 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d0e1ef0a4a63894a1809ccdc4f20309e835a7290912875e4b967700c39263c66b7867628dbce69812d3a09348f8b9131,ssignature:VPjTsR6jcI3lBiW2KjQpxKMVFw2G/e3iEWl0vs/9w/U+WSdgdioiQMPBlqSwSyeHUzGKw7Ps4xd4/nzukDXLTtvM5lr2xS/Pqbw9Tsi2HTyeWsb1ctv1dkOuAFYqsRGbUOZvJQRUIbavRTEjLy2I9BLQ0wDlpb/FtW7YRYpft6wD7lp80aXtMH2D0sWIYGfOPYI2eTt9fgoe/5Djy5bWFfZOX0+HTjUv3GitqU1OPMQMcv/cfMmzHdm1FzZ0Y7P6Hplmlp1RVqpUk9XYuxOpnqs/kjCC5/jvPanFFqPuic4DF9MNjVdTZIDDydmGJx7oxkQNR9aNNVJRMSlFuX3lpg==,sdocumentreference:SETP990000997,rtaxxadocument:249632822,sref:SETP990000997,irefindex:990000997},sdebug:Taxxa: 0.359s DIAN: 0.385s (creación 0.385s, revalidación 0s baja 0s)}', 49011, '2'),
(2159, '2025-06-25 10:30:35', '{\r\n      \"sToken\":\"396316085266\",\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            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-06-25 10:30:35\",\r\n               \"tduedate\":\"2025-07-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 998,\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: 49016\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00624172\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":9000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"saddresszip\":\"660001\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66001\",\r\n                    \"scityname\":\"PEREIRA\",\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                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 49016, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2160, '2025-06-25 10:30:35', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:b03bf7e3b7c1c8ac8d58de8a63b7368206ec51c7402e31fe03d6e2c390e082f79246c390f4d3e4fbdcb32e403d17c62c,sqr:SETP990000998 2025-06-25 10:30:36-05:00 901402281 222222222222 9000.00 0.00 0.00 9000.00 b03bf7e3b7c1c8ac8d58de8a63b7368206ec51c7402e31fe03d6e2c390e082f79246c390f4d3e4fbdcb32e403d17c62c https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=b03bf7e3b7c1c8ac8d58de8a63b7368206ec51c7402e31fe03d6e2c390e082f79246c390f4d3e4fbdcb32e403d17c62c,ssignature:QVHpPTEY0C9rGUg2G+uW4V19J8iKxpfYfs+wRBoT4CWAbfbJqK6wtM5NnGgcq3IhMwJlR+0Hh8ws5fg66vGZ6qkpZfQ9nZCEyRWs43x6VkomOaVXmGfKScUDgkDz7CVFg+6r7mYWIeG2WSIj0MtU9fZN3FYm5bQWVWP43qx8LCL9So+D3UZT9wHk05s2Umt+39kZYQnkIXpOEuQDKTecDoag5T15KisEhfy6BCOmnxgT7yd506IBIeXWC3gph8++4IijXOVJN7Xdg8vos8Ie+DZ0beOhCpK8tWqtgYpyKEFxRMhy+kJsqO/svvXIWZTFDqq2Xf5bWeCcr4UsOY4PdA==,sdocumentreference:SETP990000998,rtaxxadocument:251867553,sref:SETP990000998,irefindex:990000998},sdebug:Taxxa: 0.354s DIAN: 0.812s (creación 0.812s, revalidación 0s baja 0s)}', 49016, '2'),
(2161, '2025-06-25 10:55:09', '{\r\n      \"sToken\":\"396316085266\",\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            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-06-25 10:55:09\",\r\n               \"tduedate\":\"2025-07-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 999,\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\":\"CLAUDIA\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"39456008\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CLAUDIA   \",\r\n                     \"selectronicmail\":\"claualzate2017@gmail.com\",\r\n                     \"stelephone\":\"3003963140\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"CL 51 60 34\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 49017\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00624173\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":9000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"saddresszip\":\"660001\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66001\",\r\n                    \"scityname\":\"PEREIRA\",\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                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 49017, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2162, '2025-06-25 10:55:09', '{rerror:2,smessage:{string:Regla: 90, Rechazo: Documento procesado anteriormente.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:D,scufe:e0ba86eab84dd0e8b0570c429b43ad90dde3a37a1ff6e3e00220542f08500363a03955105de4008cb56c3529cc452a36,sqr:SETP990000999 2025-06-25 10:55:18-05:00 901402281 39456008 9000.00 0.00 0.00 9000.00 e0ba86eab84dd0e8b0570c429b43ad90dde3a37a1ff6e3e00220542f08500363a03955105de4008cb56c3529cc452a36 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=e0ba86eab84dd0e8b0570c429b43ad90dde3a37a1ff6e3e00220542f08500363a03955105de4008cb56c3529cc452a36,ssignature:oxScsfTYVI+RvI6VZk4146SgXS2CtmpCHGfEN4c4E9Qos/CIQTOqOYwMCXElcwEM8RVWcPNa0Xgn1bD7Y2M8lYDXeKrc5+WMgFls02QQ0C58+QD7rz5crEzvmmLBCsmv72W/DqDlNKkXYZf8A5NBa/nTRyyE0iKExoyOA2kPuLNMuRy0ZSM72+amOuxTITMHW1HgC+03dbvat8oB759x6l/B4LJk9Og2pdVusHHeDIL9ssGT4coCi/6FtU+XE56R+jHc6+ymW66zqCzlGyXLY2njQOfCVubh+ac1oLu600PZx1Vo1EjWGIfOBOKrTg2WSKAH0SJRcgIFLr5oJdNh/Q==,sdocumentreference:SETP990000999,rtaxxadocument:251884530,sref:SETP990000999,irefindex:990000999},sdebug:Taxxa: 0.315s DIAN: 0.489s (creación 0.489s, revalidación 0s baja 0s)}', 49017, '2'),
(2163, '2025-06-25 10:57:08', '{\r\n      \"sToken\":\"396316085266\",\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            \"wdocumenttypecode\": \"01\",\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-06-25 10:57:08\",\r\n               \"tduedate\":\"2025-07-02\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 1000,\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\":\"CLAUDIA\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"39456008\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CLAUDIA   \",\r\n                     \"selectronicmail\":\"claualzate2017@gmail.com\",\r\n                     \"stelephone\":\"3003963140\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"CL 51 60 34\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 49018\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00624174\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":9000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00624175\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":9000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"saddresszip\":\"660001\",\r\n                    \"wdepartmentcode\":\"66\",\r\n                    \"wtowncode\":\"66001\",\r\n                    \"scityname\":\"PEREIRA\",\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                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 49018, '2');
