INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1772, '2025-01-05 06:58:58', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"sqr\":\"SETP990000848 2025-01-05 06:58:59-05:00 901402281 222222222222 4300.00 0.00 0.00 4300.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"W57UdpVuZEpExh08AXTRhH0l3HvSvzs9EqNj5ogu67QF1Qi6ZEXjZbaPW38giEtbd/7JmeSA/xBWNgKa9ZYrfBXivCkVCuW65F5qdi6Qvv9TOsaOGrdW5FGtx3xyCPj//RJ4OGd/cWq+YUkxw481FNOYKPEpHmTtkkyhCyqagRgXq9y0Hedf0NKGTXL8I9WQieGa+ppBTN9B2FrBXGxPZTfm3viMYrdrvapBzTeUnLBBulbRLngGULWrVfCJPCP6YC/V5WA/E3J1wfkRVUMyKgwOhSMQKpbaWc1zTDsmO91YP+c+0aptNiIxdTfKf0zizHIgwGb0MOAXZyibR78yVw==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.094s DIAN: 1.289s (creación 0.656s, revalidación 0s baja 0.633s)\"}', 47755, NULL),
(1773, '2025-01-05 08:53:01', '{\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-01-05\",\r\n               \"tduedate\":\"2025-01-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 848,\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: 47756\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622637\",\r\n                  \"scustomname\":\"LONCHA DE QUESO ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":2000,\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   ', 47756, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1774, '2025-01-05 08:53:01', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"sqr\":\"SETP990000848 2025-01-05 08:53:01-05:00 901402281 222222222222 2000.00 0.00 0.00 2000.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"CMtitQjayGC7pNdVNRu3xUkXYLYP+FNMkj+xZsAARMqmyygKxll3R80Xuqn7PZ8oPyyvlIRSk9MQzi3IDIvM3+VHACWS63dT5iW2Go9MlxyhX20VDBE5MXTxBt11otJhJfz83ka6VP6Q+hbP/CP76ZTnNFWaJi23B82MiYnJUX3vnV1ZoS/1x9AsVYZ3jG9/SzqzPLgl9O8JJgfEZLqEeetJDkhkILqqEINv3TlfUGGZMmjqLjylT4w9kpdejT4p1jOvON0qQ4BP8cwFBgjembElqrIvcaOfUPadmIL4Kx+K7xfO9UuZlJClmCAwksECrdJjIDLB9wI1w332tNE83w==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.07s DIAN: 1.594s (creación 0.977s, revalidación 0s baja 0.617s)\"}', 47756, NULL),
(1775, '2025-01-10 09:58:20', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-01-10\",\r\n               \"tduedate\":\"2025-01-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 848,\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: 47757\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622638\",\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\":\"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   ', 47757, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1776, '2025-01-10 09:58:20', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"sqr\":\"SETP990000848 2025-01-10 09:58:20-05:00 901402281 222222222222 12300.00 0.00 0.00 12300.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"EN2Mo7Mtnaezzq/NupCyI2dSe3XmX0vmT26BlmmZAj7ZfyP5QXjVH4yQscp/cqooJjNx5DvvQZvXIZKGWUJZM16DAVgnZXiNKGrH0D7F3hoWJTlxk5dqg2nNQla4lSKe9mkot/Oa4cfj6Bp+wYIfak+cS5fTikkbgvLqfDH16/Bc+AlaXpGcMKU2eeEr40FalSbQOGd3WPNk27wVDnY77LIGCiLaFS4bz1NU+335mZeVdGfQs6uhTXj6fvaRf6ODgdUT7iLIaZEW/g9rgXqoZryBZkl01N7+pSkqnLssMLmm95iA4z/3p1n3lGACGn/AeeIXC+dJ36Rj9he27LuEcQ==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.07s DIAN: 1.375s (creación 0.891s, revalidación 0s baja 0.484s)\"}', 47757, NULL),
(1777, '2025-01-13 16:24:25', 'En este momento ya tiene un proceso pendiente en la Dian, pida soporte con <br><b>id: pruebaseu 47751</b>', 47751, NULL),
(1778, '2025-01-13 16:24:30', '{\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-01-13\",\r\n               \"tduedate\":\"2025-01-13\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 848,\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\":\"ferrecostos@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: 47748\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622619\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47748, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1779, '2025-01-13 16:24:30', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"sqr\":\"SETP990000848 2025-01-13 16:24:30-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"J4dJDILqQETJKtGZkcHz+Lg3z8/5G7k1jZm+mYE/kUR/hVMWu2VloV1sMvQF6Ou1Z9OBl1I/N2HpZ5qoWZ34qTiq0vgA6tMwKm61efwO0dr22qHjWgxyNC4CI2rGikhl15S3AfI7e+koR+Np9Uz5MIXkMRnqVPnaAKJBu9HmvmoTygl2dOV1pEoI8jTIReV3tyrVaicAbRUWF7Qxoxke+JLoEwMNsH0cvrOlrejYMPTHMFhoCZ5NCjcTSrajDBT6cz1fJsvdmV6OQ4fYLYX9LU5es0zyE8Rf86+jvRlbUWcQGVo6monufBX4fROWu9VVFs11Sh51PGTjuIlGr0M1tA==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.067s DIAN: 1.392s (creación 0.798s, revalidación 0s baja 0.594s)\"}', 47748, NULL),
(1780, '2025-01-13 16:24: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-01-13\",\r\n               \"tduedate\":\"2025-01-13\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8481,\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\":\"ferrecostos@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: 47748\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622619\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47748, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1781, '2025-01-13 16:24: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\":\"a7846a9ebe066dc1e33e1a6a80170060b111eb6e3e5c775f70c7838e304c0c37977f32b711ed7afa000eb461232cb53f\",\"sqr\":\"SETP990008481 2025-01-13 16:24:56-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 a7846a9ebe066dc1e33e1a6a80170060b111eb6e3e5c775f70c7838e304c0c37977f32b711ed7afa000eb461232cb53f https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a7846a9ebe066dc1e33e1a6a80170060b111eb6e3e5c775f70c7838e304c0c37977f32b711ed7afa000eb461232cb53f\",\"ssignature\":\"NCGii9YVH53i+aPVLPxEwi90NgpXEmg+5sxcWpIWizuLzhcMSwmh9Z4AZWNxiqdDrSvRTvtU/MO1EdATRaX5Is18JLuw9Q3ZV05OAMTl+yvLQ6Hypi7ymzMGvn0fcreVWxf/av9RRtPH1nWVVdWv3aswpi+LDZE0A5F6rVhnZOA92/SkHJepVZ1ymJBpsX24Pooq4+wfAsHuKL8FzzhSvdVaQJrw4kEj6oCKxjunXkMOEnlUL0NHK6kM7NOFau4l5ZPn4uZ3dgy6fplZXMF5dLEoUg7cWKZj7lITXmYHnOb+Le53cTPRrLRsgrON+xre67TO7DSpugvSy+l9UiiFaA==\",\"sdocumentreference\":\"SETP990008481\",\"rtaxxadocument\":\"167643121\",\"sref\":\"SETP990008481\",\"irefindex\":990008481},\"sdebug\":\"Taxxa: 0.11s DIAN: 1.282s (creación 0.735s, revalidación 0.547s baja 0s)\"}', 47748, NULL),
(1782, '2025-01-13 16:26:59', '{\n   \"sToken\":\"774855597565\",\n   \"jApi\":{\n      \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n      \"jParams\":{\n         \"wVersionUBL\":2.1,\n         \"wEnvironment\":\"prod\",\n         \"jDocument\":{\n            \"wdocumenttype\":\"CreditNote\",\n            \"wdocumenttypecode\":\"91\",\n            \"woperationtype\": \"20\",\n            \"sdocsubtype\":\"2\",\n            \"wcurrency\": \"COP\",\n            \"sdocumentprefix\": \"SE\",\n            \"tissuedate\":\"2025-01-13T16:26:59\",\n            \"tduedate\":\"2025-01-13\",\n            \"sdocumentsuffix\":\"848100001\",\n            \"spaymenttype\":\"1\" ,\"jdocumentitems\":{\"1\":{\n       \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\n       \"snotes\":\"\",\n       \"nunitprice\":23000,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622619\"\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\":\"SETP8481\",\n               \"sbillingreferenceissuedate\":\"2025-01-13\",\n               \"sbillingreferenceuuid\":\"a7846a9ebe066dc1e33e1a6a80170060b111eb6e3e5c775f70c7838e304c0c37977f32b711ed7afa000eb461232cb53f\",\n               \"scufetoadjust\":\"SETP8481\"\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\":\"ferrecostos@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    ', 47748, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1783, '2025-01-13 16:27:04', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: CDG01, Rechazo: El código del departamento no coincide con el del municipio\",\"1\":\"Regla: NOTREFPLGNS, Rechazo: No se pudo validar referencia.\",\"2\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"N\",\"scufe\":\"\",\"sqr\":\"SE848100001 2025-01-13 16:26:59-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 a10a2dd06fa5eec40ac7489977534b8c1ba5bd78ab69d5586c85ce8df27975bb9f952fcfdce4d4efbfa927f498b4dc45 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=a10a2dd06fa5eec40ac7489977534b8c1ba5bd78ab69d5586c85ce8df27975bb9f952fcfdce4d4efbfa927f498b4dc45\",\"ssignature\":\"liXRnoJXIpjaFdLyoZ6y/DCQTyufcQzM/cRmeeUKmziHTq8j091DTU3mEylbQJeyeIMAnV8c226an42SXJgjceGXblQtPwnYcQhbaXdPvzggK0sQUNMnYU7NHy6Vgdlczx/6VBko1V6mEpHCcNFRLEjJChBxUNeYQE1rHnfeXClV6vBw3Gyg5AbC2K/ec+aK5b80thDiUEe09MMEvjtByzRQgY8J+kZRAFp3oqihHqqDU6ULcKN8hHQuzcZJR1xCCehsHsvKkIQJ45CFd0vIphdFmzkBdVLAnavdNi1VFD5DhIe/BBqpwjoI0IFu9DlmrMeHzq7Ibm8pymTxTl8hnA==\",\"sdocumentreference\":\"SE848100001\",\"rtaxxadocument\":\"167644386\",\"sref\":\"SE848100001\",\"irefindex\":\"848100001\"},\"sdebug\":\"Taxxa: 0.147s DIAN: 4.174s (creación 0.728s, revalidación 3.445s baja 0.001s)\"}', 47748, NULL),
(1784, '2025-01-14 09:26:09', 'En este momento ya tiene un proceso pendiente en la Dian, pida soporte con <br><b>id: pruebaseu 47749</b>', 47749, NULL),
(1785, '2025-01-14 09:26:15', '{\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-01-14\",\r\n               \"tduedate\":\"2025-01-14\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8482,\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\":\"ferrecostos@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: 47749\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622622\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47749, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1786, '2025-01-14 09:26:15', '{\"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\":\"fabbc46ab3e3782d6c99bd63de7671dce0ad5a90d40f7afbe9def32f8cf55978706618af407820fd334e08c101aae73b\",\"sqr\":\"SETP990008482 2025-01-14 09:27:26-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 fabbc46ab3e3782d6c99bd63de7671dce0ad5a90d40f7afbe9def32f8cf55978706618af407820fd334e08c101aae73b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=fabbc46ab3e3782d6c99bd63de7671dce0ad5a90d40f7afbe9def32f8cf55978706618af407820fd334e08c101aae73b\",\"ssignature\":\"j7ykfkermZW3na0seE+h6nXFa6UTQAFGS6UdL0HiFNGvbJ9Ix1ESgQBwKG43D3A7L59F3JEztQVZrQ5cmDZvYp7gcO22l9K3dAV5CbM8eFWWVbk6u7A/yXAjX0T6J4yHtyhAXTRwcOsD9n7evrWrChuQfFSC6TQFwBYP+gGxxTV+M6XiF1M1zXucz11ZyKt1NDbv1uMemkIv0HngbFkvcj2K5K4orlbBYTjOkOK3ax+i0ofwS9BcoytjNhMHwmvp7fCFeTH8a+Posigdyu+ZrObLqNVJSIwflTJ3Ny54uKlAeeZG3eezmqEPR6BfxUFFdjcw33tdLCUvikh7VN4zwA==\",\"sdocumentreference\":\"SETP990008482\",\"rtaxxadocument\":\"167871299\",\"sref\":\"SETP990008482\",\"irefindex\":990008482},\"sdebug\":\"Taxxa: 0.988s DIAN: 2.042s (creación 1.588s, revalidación 0.454s baja 0s)\"}', 47749, NULL),
(1787, '2025-01-15 14:58:03', '{\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-01-15\",\r\n               \"tduedate\":\"2025-01-22\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8483,\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: 47758\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622639\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":17500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622645\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47758, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1788, '2025-01-15 14:58:03', '{\"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\":\"2a79f7f106a0cbb9d415f16228c6a6fd272daa078c89b7bce35e34d6755d7c0916abf4d487c678d14ebaa66de6865099\",\"sqr\":\"SETP990008483 2025-01-15 14:58:31-05:00 901402281 222222222222 40500.00 0.00 0.00 40500.00 2a79f7f106a0cbb9d415f16228c6a6fd272daa078c89b7bce35e34d6755d7c0916abf4d487c678d14ebaa66de6865099 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=2a79f7f106a0cbb9d415f16228c6a6fd272daa078c89b7bce35e34d6755d7c0916abf4d487c678d14ebaa66de6865099\",\"ssignature\":\"o+XCal/+XibY9N5ofCOZKPrdQElv9K8Qptr2Pr3CZXN+I5WOwQ2I8OztE9E+aAzGJCIGZnv7b2UOzXHceco6oBlg1sxrrbnwRiLB4Qlph7/2epguaDL4CsBNnyp1wEGcBtYVMgpUPdsjP3QeD3A6er3YeK7CPAnqQXsvl3KsCUFcWOFBEIiUWPuIIREnHaGYWeYkKmI/Raa8khp1lEothyby34jL8YLb0xw/301m5knMEQNGfyP7aPCFutDFR33KtT1NBwJVoK6wTqrW5nFrAJf1yG7gJwd8g7/m2yW66SIo5KvmFRwtlYVMen/hfgP//bzG7Lqt0E+aC6bkQz2ZBw==\",\"sdocumentreference\":\"SETP990008483\",\"rtaxxadocument\":\"168480030\",\"sref\":\"SETP990008483\",\"irefindex\":990008483},\"sdebug\":\"Taxxa: 0.133s DIAN: 1.543s (creación 1.181s, revalidación 0.362s baja 0s)\"}', 47758, NULL),
(1789, '2025-01-15 14:59:51', '{\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-01-15\",\r\n               \"tduedate\":\"2025-01-22\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8484,\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\":\"raulo otalvaro   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"9874704\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"raulo otalvaro   \",\r\n                     \"selectronicmail\":\"adfsadf6@sfasdf.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47759\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622654\",\r\n                  \"scustomname\":\"BURGER PECHO RES DESMECHADO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47759, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1790, '2025-01-15 14:59:51', '{\"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\":\"fffb6f3b992c4f7095f7864e8e0c2ce30278234f2f755c6db87b95d4ffe1d34a497f103abce95ccf30c1dad342132fdb\",\"sqr\":\"SETP990008484 2025-01-15 15:00:11-05:00 901402281 9874704 23000.00 0.00 0.00 23000.00 fffb6f3b992c4f7095f7864e8e0c2ce30278234f2f755c6db87b95d4ffe1d34a497f103abce95ccf30c1dad342132fdb https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=fffb6f3b992c4f7095f7864e8e0c2ce30278234f2f755c6db87b95d4ffe1d34a497f103abce95ccf30c1dad342132fdb\",\"ssignature\":\"wXCMuIdRfSfRt/Bo23tkYpjAyAfUJOXF+AXORrMjhdQ/+4pf0kmQuuX5SQMWxqb67MCzxXCHjuB5glKOsKH1pCzFGTH8wtG3L7Fok/4Tfmb/T8Xnb5wm8Rv/ZWRZHljptrXSekBphSILJNzsN8bZBc6NQfFvJilT/3W01zzrJLhkswKh1RmgU00FAS6tWX5UQEpnKlCpnjlHxXAs0dvf8iHeSchDMY1FHjSJZ4SA0VEYCx2m+dmJjejwguxi1S6gBhN3s4sX2R4XQfxIjsIhdmSPq303ko16WjTjzwnH+2i2Gvk9H9lkXly/BterXstx+udGeTB6GlCvX0I+aYjCPQ==\",\"sdocumentreference\":\"SETP990008484\",\"rtaxxadocument\":\"168480703\",\"sref\":\"SETP990008484\",\"irefindex\":990008484},\"sdebug\":\"Taxxa: 0.115s DIAN: 1.066s (creación 0.758s, revalidación 0.309s baja 0s)\"}', 47759, NULL),
(1791, '2025-01-16 17:28:04', 'En este momento ya tiene un proceso pendiente en la Dian, pida soporte con <br><b>id: pruebaseu 47750</b>', 47750, NULL),
(1792, '2025-01-16 17:28:10', '{\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-01-16\",\r\n               \"tduedate\":\"2025-01-16\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8485,\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: 47750\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622625\",\r\n                  \"scustomname\":\"Lampara de techo Panel Cuadradad  LED AT45 superpuesta \",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":16500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47750, NULL),
(1793, '2025-01-16 17:28:10', '{\"rerror\":649,\"serrormessage\":\"Acceso restringido. Verifique dominio\"}', 47750, NULL),
(1794, '2025-01-16 17:30:07', 'En este momento ya tiene un proceso pendiente en la Dian, pida soporte con <br><b>id: pruebaseu 47750</b>', 47750, NULL),
(1795, '2025-01-16 17:30:11', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-01-16\",\r\n               \"tduedate\":\"2025-01-16\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8485,\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: 47750\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622625\",\r\n                  \"scustomname\":\"Lampara de techo Panel Cuadradad  LED AT45 superpuesta \",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":16500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47750, NULL),
(1796, '2025-01-16 17:30:11', '{\"rerror\":649,\"serrormessage\":\"Acceso restringido. Verifique dominio\"}', 47750, NULL),
(1797, '2025-01-17 07:54:05', 'En este momento hay intermitencia en la dian, espera varios minutos antes de enviar la siguiente factura (2025-01-17 7:01:24)', 47760, NULL),
(1798, '2025-01-17 07:54:45', '{\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-01-17\",\r\n               \"tduedate\":\"2025-01-24\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8485,\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: 47761\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622660\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47761, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1799, '2025-01-17 07:54:45', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"sqr\":\"SETP990008485 2025-01-17 00:00:00-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"ssignature\":\"hEfiDPs7AQ1GA4fCL8QHGa4bxjldkUoEu3KHd/RirWtO3apDk1BHTFWsZSjFJ9nmBpKuPNqbKl/byVai83qCKLXo/xFrStIZeeqpg2P9FiphqfJ5oub0Szuq+0R9IFyZal/+BK3GMgqtpOzIWfO2k0uBgd60H9FsRklCo6vhcE2Vd0B8R4HvWMGbuKSAZ2EN/3/QMwzg1P1ThXBTL80gWQ4r14AXz2miWFMhYIPk9gaaC3oPyHV9Zji53UO9BczQD0AMO9/UT3AX/KbiW1YlFQ1qkPQ3ewBzazcxU0Ghk6jFibMxAR9lIZISE8gZOvv6vvkcQlGd9gpKbNMN6vDWQA==\",\"sdocumentreference\":\"SETP990008485\",\"rtaxxadocument\":null,\"sref\":\"SETP990008485\",\"irefindex\":990008485},\"sdebug\":\"Taxxa: 3.13s DIAN: 0.81s (creación 0.475s, revalidación 0s baja 0.335s)\"}', 47761, NULL),
(1800, '2025-01-17 14:58: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-01-17\",\r\n               \"tduedate\":\"2025-01-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8485,\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\":\"prueba razonsocila\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"2132132132\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"   \",\r\n                     \"selectronicmail\":\"asdfad@asdfjas.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: 47762\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622663\",\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\":\"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   ', 47762, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1801, '2025-01-17 14:58:29', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"sqr\":\"SETP990008485 2025-01-17 14:58:32-05:00 901402281 2132132132 7800.00 0.00 0.00 7800.00 9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"ssignature\":\"iP92qDpPndrUJ1UItSUN5Y9ZoqMio0SZhst2fXGGdfInIZMXq8rM7IrWhH4MorDrnH4wU9jthI0fN8ycwzpd5a8/01y3uRRclBsAmFFoDsYaobyaXIDPaWZiYYDLqtSFy1fnoZW9KIUdwaQQTM+h17KUPA0I4QXBTb9q7GfZgj4b9Cq8mKQ1WRJj5Z/lKDEicy3a3svMrrWmL2u2JtVohPYkBMVe45Wn+FQ+o3UuvKf0ZmKw79hkYFZB65lezltek7xC5h0/JIAdJZLQXZ5bFXUXvB3ZgFwZTwWyGuFzhXGfX8ZvZFi3Z3tbYFD0Lqgg7SbJCMABKmX1krbBGtnLNg==\",\"sdocumentreference\":\"SETP990008485\",\"rtaxxadocument\":null,\"sref\":\"SETP990008485\",\"irefindex\":990008485},\"sdebug\":\"Taxxa: 3.109s DIAN: 0.618s (creación 0.427s, revalidación 0s baja 0.191s)\"}', 47762, NULL),
(1802, '2025-01-17 15:04:03', '{\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-01-17\",\r\n               \"tduedate\":\"2025-01-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8485,\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\":\"asd fasdf asdf asdf\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"234512354\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"   \",\r\n                     \"selectronicmail\":\"asdf@asdfa.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: 47763\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622664\",\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\":\"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   ', 47763, NULL);
