INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1848, '2025-02-09 16:18:46', '{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:2256188f4d0580127f857043c201e7d05c7e899c75e7fb378b3207a45ae86f863f31dff62a3281cf3b3aab316b437dc9,sqr:SETP990008589 2025-02-09 16:18:48-05:00 901402281 222222222222 7500.00 0.00 0.00 7500.00 2256188f4d0580127f857043c201e7d05c7e899c75e7fb378b3207a45ae86f863f31dff62a3281cf3b3aab316b437dc9 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=2256188f4d0580127f857043c201e7d05c7e899c75e7fb378b3207a45ae86f863f31dff62a3281cf3b3aab316b437dc9,ssignature:FmsoujL/R0YYCBrzTKgTpZmtPofUQ42VhxnIhmxfqSodMXm6yhd/wXf7Cec/aeoirsYnJTAoD+W/65lWQpF9x3zdQiulFzluwiLTiHnF3Z9+lALOSxEgn294Y1Z9gYYsWe2WhLyltyXhpD7RvN6GV1WviHPlti5+F/KwDRIPPWE1Yow+6hRbbQ+LNBTlP9Ewfrz6fjfO347k1n9GBOmbYlkYiB6Nfa5QVGtt/2Ndsmw6obBZgfI4tdV9LPRTMhoh5qVS++MTUbJSu/jlAqAqaRIGDNAha4++Mg8fcpa+PTcG3dVynVKR4bX6+Shil7PHyP9Wq2/hP55oBSrbnvO/JQ==,sdocumentreference:SETP990008589,rtaxxadocument:180995950,sref:SETP990008589,irefindex:990008589},sdebug:Taxxa: 3.801s DIAN: 1.198s (creación 0.827s, revalidación 0.371s baja 0s)}', 47785, '2'),
(1849, '2025-02-10 14:15:22', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-10\",\r\n               \"tduedate\":\"2025-02-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8590,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47786\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622726\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":65000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"ferrecostos@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   ', 47786, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1850, '2025-02-10 14:15:22', '{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:a492766d61e28d67258d29a629b0a8912a773979164b689979b44e5cbc58ea6ae33d8894239fc11b59081d26c9b29ea4,sqr:SETP990008590 2025-02-10 14:15:25-05:00 901402281 222222222222 65000.00 0.00 0.00 65000.00 a492766d61e28d67258d29a629b0a8912a773979164b689979b44e5cbc58ea6ae33d8894239fc11b59081d26c9b29ea4 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a492766d61e28d67258d29a629b0a8912a773979164b689979b44e5cbc58ea6ae33d8894239fc11b59081d26c9b29ea4,ssignature:Mj0xSer34KSyf9dfNJSAPZBTZRFfg+Xq40AhBY5Juqb9KsGjVdOQA3NHxDrlnm9ykdmIq36KAWAUbiRWul4sDDYxBcxvGZQUyqiGQuSWKyd8FW4n9/fHoRK/vbd5NwO+SKYf1qmfu4JpzstYS5qrWoCA95UZ9AdUhEpzYygujUMoBuT+lsLLMYM4nT6pWcTENjnaPt5v8j7+mPv7x6G/RpdyWCi4Q2tnzGd/IZspe89ageBzbglIxjoqTTP+/si4/VtXExKcauB5HsGz5x4aYmhGphL7GKqDw0OGrVu/2Oe9Gr7Pv2Yz6gicCLOvWIOQ1+kQHnm0AoPaDM5C72JiUw==,sdocumentreference:SETP990008590,rtaxxadocument:181354777,sref:SETP990008590,irefindex:990008590},sdebug:Taxxa: 3.927s DIAN: 1.835s (creación 1.459s, revalidación 0.376s baja 0s)}', 47786, '2'),
(1851, '2025-02-10 14:15:54', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-10\",\r\n               \"tduedate\":\"2025-02-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8591,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47787\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622729\",\r\n                  \"scustomname\":\"BANANO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"ferrecostos@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   ', 47787, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1852, '2025-02-10 14:15:54', '{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:59d2fe5c6dd55072e0ba947e4a2b5c78b1b1f19c2335e857ca6b1dfc01c9a656725107bd2ce499df63c69ea6e25d800f,sqr:SETP990008591 2025-02-10 14:15:57-05:00 901402281 222222222222 500.00 0.00 0.00 500.00 59d2fe5c6dd55072e0ba947e4a2b5c78b1b1f19c2335e857ca6b1dfc01c9a656725107bd2ce499df63c69ea6e25d800f https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=59d2fe5c6dd55072e0ba947e4a2b5c78b1b1f19c2335e857ca6b1dfc01c9a656725107bd2ce499df63c69ea6e25d800f,ssignature:k4HmoHP4DMrYXYBM8kJPudW5Ipz/BWBhwWVqayGS2cDxaVt3f3170z84gltlFDbZoDEEWCyHWEqtIWbgz1Ab1ZmICxv7gEqhOQPHbz38Ls07UZNxwA8Ew5vMEuPbDatFP/lmK/me/wxX/NlgenVfRr0wUWLi0/uisuJJvEPtV5eeCpOQ3ZcIASGrqqO/kDDDCILlfDOqvlscFacvJjTaAFkFKqU6OoNdS4e7yxVugi5NILLrAurVbX7VS6vgV9Z6aEe3VhrwViuFso/PLAP/HJAD9QKi8xqEcwD8veUq5wuIlN37WPdlesc1beDMwzRtIMS30jR8nyVxs0l1ssQdUg==,sdocumentreference:SETP990008591,rtaxxadocument:181355020,sref:SETP990008591,irefindex:990008591},sdebug:Taxxa: 3.798s DIAN: 1.351s (creación 1.043s, revalidación 0.308s baja 0s)}', 47787, '2'),
(1853, '2025-02-22 14:40:39', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-22\",\r\n               \"tduedate\":\"2025-03-01\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9500,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47788\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622730\",\r\n                  \"scustomname\":\"PICADA MEGAFAMILIAR \",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47788, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1854, '2025-02-22 14:40:39', '{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:a4a29a82dc71dccf7468063695080862353f62e9c76c4c5bcc0dae29f750d3e77c5c4361331f90ec88ab9b596e43d7ab,sqr:SETP990009500 2025-02-22 14:40:42-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 a4a29a82dc71dccf7468063695080862353f62e9c76c4c5bcc0dae29f750d3e77c5c4361331f90ec88ab9b596e43d7ab https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a4a29a82dc71dccf7468063695080862353f62e9c76c4c5bcc0dae29f750d3e77c5c4361331f90ec88ab9b596e43d7ab,ssignature:paPA58koU86vDpc96KFXCGMIcpMa3ShpoQo79wmMyICI1fvPQ2U7w5nQPdG92K1U1IcOPoDJO2xhPxm0glUj4qeiySy8D3K67iFpAc9wEpm+TMaIQL0SLM33ZDAtJBMfrX+60FzBpw6AmkVksI3V1z1hr8riZROoxrpPBgtIjrd8ZQRZyuaRynoH372+Z2JyHpU90OD0871ai15dGMojwb1ItiHpA/sCJppROMJIkEyYyYZ5dGk8y4wXYo485kXXXF0hdnfMfHvmz+Trbvfl9Or6uEStwxeVYlMLwo3UTYcZqg47taXPFuB/8MN73TFv5CpQwtL4aMq0IWajQ7Wzsw==,sdocumentreference:SETP990009500,rtaxxadocument:186688071,sref:SETP990009500,irefindex:990009500},sdebug:Taxxa: 3.753s DIAN: 1.46s (creación 1.153s, revalidación 0.307s baja 0s)}', 47788, '2'),
(1855, '2025-02-25 17:40:50', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-25\",\r\n               \"tduedate\":\"2025-02-25\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9501,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\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\":\"9874704\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"adfsadf6@sfasdf.com\",\r\n                     \"stelephone\":\" \",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47771\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622687\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622688\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47771, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1856, '2025-02-25 17:40:50', '{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:1b99f21a4f699d4d19f260e4b07dfed147ea97c9855573467892f220eaf71d6a1058aa42cc3cb9b5bce4a095820e7abb,sqr:SETP990009501 2025-02-25 17:40:53-05:00 901402281 9874704 15600.00 0.00 0.00 15600.00 1b99f21a4f699d4d19f260e4b07dfed147ea97c9855573467892f220eaf71d6a1058aa42cc3cb9b5bce4a095820e7abb https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1b99f21a4f699d4d19f260e4b07dfed147ea97c9855573467892f220eaf71d6a1058aa42cc3cb9b5bce4a095820e7abb,ssignature:HOcWk8RH7HmTciO6JKq9b7HAGUW8SeMl0qQQekk/l++cYyhKtYJGJ0jyjApaDDJYVgHZK06+coVGzfRdzDE+MfLia/0aU4Qr5VmRWfjrsmMzT7nINapawYpZ88a8e0gBWBCQIFzlLgSgcqtBGwToXTY2r0qUZ39bgBne+QbzrtnNKDh08DiyoPf5XyYi84TNDOQZIscl1u9YDRMoBDy2RvbhBwlsGFU7sTdwGG0Xk4u0ER1mEDqQoN4Foz5Zfx8IiDPYryXcQAdFYBZC1X1hhQ1WrytXqm4nx3Jywk3dGQ0WyjzGlgtbu6uRpDyeRkKvxLsTmhjyvlxElP4KohzPbA==,sdocumentreference:SETP990009501,rtaxxadocument:188042789,sref:SETP990009501,irefindex:990009501},sdebug:Taxxa: 3.896s DIAN: 1.206s (creación 0.888s, revalidación 0.318s baja 0s)}', 47771, '2'),
(1857, '2025-02-25 17:44:08', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-25\",\r\n               \"tduedate\":\"2025-03-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9502,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47793\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622735\",\r\n                  \"scustomname\":\"PICADA MEGAFAMILIAR \",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47793, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1858, '2025-02-25 17:44:08', '{rerror:0,smessage:{string:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:Y,scufe:c847d66c64e871f61f5e19bfb178fc28a7aceeeba4738e0ce3e3af47a2ec016da6b7e9064525ec3e18b29e5fec6cfa51,sqr:SETP990009502 2025-02-25 17:44:11-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 c847d66c64e871f61f5e19bfb178fc28a7aceeeba4738e0ce3e3af47a2ec016da6b7e9064525ec3e18b29e5fec6cfa51 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c847d66c64e871f61f5e19bfb178fc28a7aceeeba4738e0ce3e3af47a2ec016da6b7e9064525ec3e18b29e5fec6cfa51,ssignature:iyGtHRi73Ug9S7R+Uvn05oY3//8TprAttOrg+Jv2tWJgZY1lJZYLWxjdpDZjkD+JIVFTzonIVGzp6NyfGVw03PNHWIoMHE/jGVIdCoTD0jsj53rGKL+omkMBJm9HLYmZrTqkXEd891VLXvVBIYydp0rq1aCLEzy03rVa20dPbccIfc2/UaCjP1Jh2N8B4OzHF588+qniw1RBkf+zQMVR9qWj3oHq1nZp49DLeYFKvpXaWfUz6V1IApru1yQTPbzZ0UQZAdQ4xw9HIirBMZbds5+O/l9qeDKFSonsh1GLEYw/c29TdS0pUMlC1Z5lxkbKcCbQN4RoyAV249cTlNkkpw==,sdocumentreference:SETP990009502,rtaxxadocument:188045003,sref:SETP990009502,irefindex:990009502},sdebug:Taxxa: 3.942s DIAN: 1.166s (creación 0.781s, revalidación 0.385s baja 0s)}', 47793, '2'),
(1859, '2025-02-25 17:44:40', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-25\",\r\n               \"tduedate\":\"2025-03-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9503,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47794\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622736\",\r\n                  \"scustomname\":\"HEINEKEN\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47794, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1860, '2025-02-25 17:44:40', '{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:8c63ead2f01f1906b791d54aa1c76009900eb11f324af2ec42c586e8405b636bafa780719c8745c3a55886b0299fcbc8,sqr:SETP990009503 2025-02-25 17:44:44-05:00 901402281 222222222222 8500.00 0.00 0.00 8500.00 8c63ead2f01f1906b791d54aa1c76009900eb11f324af2ec42c586e8405b636bafa780719c8745c3a55886b0299fcbc8 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=8c63ead2f01f1906b791d54aa1c76009900eb11f324af2ec42c586e8405b636bafa780719c8745c3a55886b0299fcbc8,ssignature:qmmcd1MOsZN/hPyxu4MdIpG3Czr4W2Kud6Hv1MpcDnuKz+XdyGw+wKQepirVUxYamtnx9TVSBvrYXocNitpriTLKHbhCkrUTGbXsKvGkvI/LC8hXKjXX09ntJQ9k8xv+anb5E4VHLtx64m9F4Id5jfv3ISkzKnUp9lpjhi5VC7SVd/p/Ro7DK8XOS4kIAALIXGIpiHqsFSSiWVYaapx/PAusy4IpHCfAFelmkauElWyhI9lspMgvuNMi42zSLEBKcemqVhMCyNOxTyeeY0tnMRBYaQyywzCP18SG1R0prreDzZ0ZXRrOtlDm+2+H+Chl1mtF1PjOhmvVO5NyytJg2A==,sdocumentreference:SETP990009503,rtaxxadocument:188045383,sref:SETP990009503,irefindex:990009503},sdebug:Taxxa: 3.985s DIAN: 1.093s (creación 0.809s, revalidación 0.284s baja 0s)}', 47794, '2'),
(1861, '2025-02-25 17:49:29', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-25\",\r\n               \"tduedate\":\"2025-03-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9504,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47795\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622737\",\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\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47795, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1862, '2025-02-25 17:49:29', '{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:a0fa5457b922e16b2f57fe1fc2c522e4cc5568361365fad75c0487382bb3fdebba02973db48b2130ce78695e746afe76,sqr:SETP990009504 2025-02-25 17:49:32-05:00 901402281 222222222222 12300.00 0.00 0.00 12300.00 a0fa5457b922e16b2f57fe1fc2c522e4cc5568361365fad75c0487382bb3fdebba02973db48b2130ce78695e746afe76 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a0fa5457b922e16b2f57fe1fc2c522e4cc5568361365fad75c0487382bb3fdebba02973db48b2130ce78695e746afe76,ssignature:oV7BYAXPxK8/VslXBvEgnmi5VTtHdKqHgyLJo5RhFgzle4qA3PxKMKE00d8L7I0yqDrWThVsWszdP3qpyt2euwvTA55kViTWyCPJjIgArrvXFO7DfvelAB+lQ2I5ARIsklCMXQNSfX752JAJuybXCnY6RZ2LEBREVzJte+CSFzvmwqYyJPKM+B/lyHsWGZfKapAcnIxfEevCu3tNyKFLhM2cg4X0TcWaSgHTP5RdrQ3f9B790Ou/cIYM8ZxlwtT4HQr0KoXi40Va9NWncl2qMNabNRktCYgfOL6RE++4/Invu+dr3QZS/9LgieypbEPtWJsF1bTA5dckB6RSxG15og==,sdocumentreference:SETP990009504,rtaxxadocument:188048814,sref:SETP990009504,irefindex:990009504},sdebug:Taxxa: 3.956s DIAN: 1.143s (creación 0.845s, revalidación 0.298s baja 0s)}', 47795, '2'),
(1863, '2025-02-25 17:50:12', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-25\",\r\n               \"tduedate\":\"2025-03-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9505,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47796\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622738\",\r\n                  \"scustomname\":\"AGUILA LIGHT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47796, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1864, '2025-02-25 17:50: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:629fce17846eea17fe9b07aac3886d9ad35efdbd0a2c0b3f99ff9321aaf76d4aa34b04873310a06031ce6b2713bae95b,sqr:SETP990009505 2025-02-25 17:50:15-05:00 901402281 222222222222 6000.00 0.00 0.00 6000.00 629fce17846eea17fe9b07aac3886d9ad35efdbd0a2c0b3f99ff9321aaf76d4aa34b04873310a06031ce6b2713bae95b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=629fce17846eea17fe9b07aac3886d9ad35efdbd0a2c0b3f99ff9321aaf76d4aa34b04873310a06031ce6b2713bae95b,ssignature:GyalB5HmW0KBtF/3Su8V0jUJUzYSG/rd7vNQpp+CxDS55F1efRnc6N9pkFju3TkxEWFyWyVxZ1UWwyIHBEdAXW+oY1EIyPaOWqJiXD7mPmZcc1AregnEfxRukvyi/uZuP1ZXW16wVxibTWKLxIwjXW77HQAk+tHVIPkavPludT9+GQCE+bAoo9btFHvvMQW69Sr1QgXEIPw3UyXhwJsamvuDvsoRoBfKT27DMAJugbIk+z8nGQmXvfTNyifgv2ZG/4dAqHglUApocNc13P9y+LYxgW6V/2m0KYvZOEuyiooCYgwx3GaMwtekLetJIS1Q2c9kWQrBd8zyVlZouYEiOw==,sdocumentreference:SETP990009505,rtaxxadocument:188049343,sref:SETP990009505,irefindex:990009505},sdebug:Taxxa: 3.959s DIAN: 1.207s (creación 0.834s, revalidación 0.374s baja 0s)}', 47796, '2'),
(1865, '2025-02-25 17:51:07', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-25\",\r\n               \"tduedate\":\"2025-03-04\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9506,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47797\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622739\",\r\n                  \"scustomname\":\"CARNE, PAPA, AREPA, TOMATE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47797, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1866, '2025-02-25 17:51:07', '{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:1029941471d3f734fb3a6cf71b8ca91e40fa78c3285540f84a9e7c62e3dae6215cd3ad1ba8cc9a3e9e98244cba693eee,sqr:SETP990009506 2025-02-25 17:51:10-05:00 901402281 222222222222 20500.00 0.00 0.00 20500.00 1029941471d3f734fb3a6cf71b8ca91e40fa78c3285540f84a9e7c62e3dae6215cd3ad1ba8cc9a3e9e98244cba693eee https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1029941471d3f734fb3a6cf71b8ca91e40fa78c3285540f84a9e7c62e3dae6215cd3ad1ba8cc9a3e9e98244cba693eee,ssignature:Bz8ZbH0nyDd5SfsucTQBxFRAXHHTofu4GIKI96xJXEuAm9t3h2oUDME9C0OGR7IHRSvU9ZbwYm2RaO6HeybYIL9j0cRejjBJ9uX6gdjpUePQMXQf8SXFFsHwLGng6/mL+ioeRId2zBUm4z6aMExSl2M270RPg6kmey4cTA2400Kux8+Wchkw8fEcQ1McB5dGrknjhWY16H2IPLhoJYccTyppN57AQ0u0bfIbAmgeRJXb1+55MajPBVMBMMjpYWIOq0qY753L2/FpHwh6kH++/YzCU+ZB1ng5JzpMk5Ygxfg0uK6MfjP8THqdaMxs+teBcp0IhJ1T2LPFniyRvtnepg==,sdocumentreference:SETP990009506,rtaxxadocument:188049956,sref:SETP990009506,irefindex:990009506},sdebug:Taxxa: 3.963s DIAN: 1.052s (creación 0.739s, revalidación 0.312s baja 0s)}', 47797, '2'),
(1867, '2025-02-28 00:29:31', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-28\",\r\n               \"tduedate\":\"2025-02-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9507,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47799\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":240000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47799, '50');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1868, '2025-02-28 00:29:31', '{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:60fda219be23768129a593f6c0044ec5abfde06b98b668180452e5ab496ee231b786d4347853cd7e784128290a9c136f,sqr:SETP990009507 2025-02-28 00:29:34-05:00 901402281 222222222222 240000.00 0.00 0.00 240000.00 60fda219be23768129a593f6c0044ec5abfde06b98b668180452e5ab496ee231b786d4347853cd7e784128290a9c136f https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=60fda219be23768129a593f6c0044ec5abfde06b98b668180452e5ab496ee231b786d4347853cd7e784128290a9c136f,ssignature:xr+z3z9C+ZNpMKs3mu5jaMeCZ7eDFDzkfyxuR8SjBTsog7BTv1GQNDVt6rVt9Ty5a7ndwkEcKwBVbXhYkJF9EM9AsgwGMiurpVlhUfBl8N884zEUgu0N/ZRX659NG11pdVlak3aSD/VHCVNJ/nJfQqVxpGiEqEsl2CT8iHsGN8QzY9nWuiS7QelQAgrECfcX7ihln26u+RIrcckeonji++7IT1dEXa8TPo55uT7mKaoL53z+CHrLMfiY9yADSmRkLBi1hfOfxFjcifMchC2fRry7WlqtM5DHHFJQ45Q8vD416mg//z1+1NBubiiH20g21k7xRHUiPATqZHUH9JJgGw==,sdocumentreference:SETP990009507,rtaxxadocument:189133433,sref:SETP990009507,irefindex:990009507},sdebug:Taxxa: 3.89s DIAN: 1.225s (creación 0.846s, revalidación 0.379s baja 0s)}', 47799, '50'),
(1869, '2025-02-28 00:33:10', '{\n   \"sToken\":\"774855597565\",\n   \"jApi\":{\n      \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n      \"jParams\":{\n         \"wVersionUBL\":2.1,\n         \"wEnvironment\":\"test\",\n         \"jDocument\":{\n            \"wdocumenttype\":\"CreditNote\",\n            \"wdocumenttypecode\":\"91\",\n            \"woperationtype\": \"20\",\n            \"sdocsubtype\":\"2\",\n            \"wcurrency\": \"COP\",\n            \"sdocumentprefix\": \"SE\",\n            \"tissuedate\":\"2025-02-28T00:33:10\",\n            \"tduedate\":\"2025-02-28\",\n            \"sdocumentsuffix\":\"950700001\",\n            \"spaymenttype\":\"1\" ,\"jdocumentitems\":{\"1\":{\n       \"scustomname\":\"VINO BOTELLA\",\n       \"snotes\":\"\",\n       \"nunitprice\":80000,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622743\"\n        },\"2\":{\n       \"scustomname\":\"VINO BOTELLA\",\n       \"snotes\":\"\",\n       \"nunitprice\":80000,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622744\"\n        },\"3\":{\n       \"scustomname\":\"VINO BOTELLA\",\n       \"snotes\":\"\",\n       \"nunitprice\":80000,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622745\"\n        } \n            },\n            \"spaymentmethod\":\"10\",\n            \"jbuyer\":{\n               \"wlegalorganizationtype\":\"person\",\n               \"stributaryidentificationkey\":\"ZZ\",\n               \"stributaryidentificationnam\":\"No aplica\",\n               \"sfiscalresponsibilities\":\"R-99-PN\",\n               \"sfiscalregime\":\"48\",\n               \"scustomername\":\"CONSUMIDOR FINAL\",\n               \"jpartylegalentity\":{\n                  \"wdoctype\":\"CC\",\n                  \"sdocno\":\"222222222222\"\n               },\n               \"jcontact\":{ \n                  \"scontactperson\":\"CONSUMIDOR FINAL   \",\n                  \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                  \"stelephone\":\"\"\n               } },\n          \"jbillingreference\":{\n               \"sbillingreferenceid\":\"SETP9507\",\n               \"sbillingreferenceissuedate\":\"2025-02-28\",\n               \"sbillingreferenceuuid\":\"60fda219be23768129a593f6c0044ec5abfde06b98b668180452e5ab496ee231b786d4347853cd7e784128290a9c136f\",\n               \"scufetoadjust\":\"SETP9507\"\n            }, \n            \"jseller\":{\n                \"sdocid\":\"901402281\",\n                \"sdoctype\":\"NIT\",\n                \"ssellername\":\"FERRE COSTOS LA 14\",\n                \"scontactperson\":\"JUAN ALARCON\",\n                \"saddresszip\":\"660001\",\n                \"wdepartmentcode\":\"66\",\n                \"wtowncode \":\"66001\",\n                \"scityname\":\"PEREIRA\",\n                \"jcontact\":{\n                    \"scontactperson\":\"JUAN ALARCON\",\n                    \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                    \"stelephone\":\"\", \n                    \"jregistrationaddress\":{\n                       \"wdepartmentcode\":\"66\",\n                       \"sdepartmentname\":\"RISARALDA\",\n                       \"scityname\":\"PEREIRA\",\n                       \"saddressline1\":\"Cra 14  9-07\",\n                       \"scountrycode\":\"CO\",\n                       \"szip\":\"660001\",\n                       \"wprovincecode\":\"66001\"\n                    } \n                }\n            }\n         }\n      }\n   }\n    }\n    ', 47799, '50');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1870, '2025-02-28 00:33:16', '{\"rerror\":1,\"smessage\":{\"string\":\"Regla: CDG01, Rechazo: El código del departamento no coincide con el del municipio\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"N\",\"scufe\":\"\",\"sqr\":\"SE950700001 2025-02-28 05:33:13-05:00 901402281 222222222222 240000.00 0.00 0.00 240000.00 77b2eb7a47f0c73665be2bd6b707c7bc2f0b6b79a7ab59a7a2ca511cc59f5223f1c3d6282305614de524b97dc4fe2bf8 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=77b2eb7a47f0c73665be2bd6b707c7bc2f0b6b79a7ab59a7a2ca511cc59f5223f1c3d6282305614de524b97dc4fe2bf8\",\"ssignature\":\"ghV4zGmtJp/tegS0Ch5cTaya4k6slRXFlQtDcFqnDCb+CSO04jNzRj+9FuZ0ztHCrU2zQbNm6GgDiwZO8CRaP/cCbRypjuxVH76AOVAUih8fLQIkph+RcskItHCgUVzFa6JcPiZ88FnEvhnZO3Xg8mYLJa5ettUtYHu3YHMHbeJBz9YfjzEBo1Ssi/V2QfR3A035LYqzjBlap/uq79jCHZ5EfKUMiIz1KMiRDln2WINVWLEQnQlJr6et8LVb0yrRZ9ldqjV8xls7RzsmuVf6A6p+eLHea2qOZzsrHxBK9j1OnUi/D1MnzsbJ79DVPEtVBiquF11xXuZgXyuWT+fbeg==\",\"sdocumentreference\":\"SE950700001\",\"rtaxxadocument\":\"189133655\",\"sref\":\"SE950700001\",\"irefindex\":\"950700001\"},\"sdebug\":\"Taxxa: 3.453s DIAN: 1.115s (creación 0.725s, revalidación 0.391s baja 0s)\"}', 47799, '50'),
(1871, '2025-02-28 00:45:41', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-28\",\r\n               \"tduedate\":\"2025-02-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 9508,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47798\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":225000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47798, '50');
