INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1803, '2025-01-17 15:04:03', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"sqr\":\"SETP990008485 2025-01-17 15:04:06-05:00 901402281 234512354 7800.00 0.00 0.00 7800.00 9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"ssignature\":\"pTuhW+dnxhtsoXzzbz6p0BSjNrWBCB2kqLryxTHCbloMTpvg8Ls/IM8V20IyhxMWdueSwnd+pFWDUgGtnitwamxpIgAs4VVXn77q37DJS+kFkw1A0Xxc0P6vmM1vvYxP1dLSetHuwGBtt6heFSzsp9EPPnoPOXdxOiNftrJ0lwkv54CSnflbBvspQa/wkyWYOT5fS45u/CRodFerM3Mh1wX2jr6xO9bQFIO6UBQLURZk1W4Scoyvfmdg5lS8KXtiKLrU0xEyTtmbb+7nzF19yMY67bXb+ImzTSILQrP8zgSydCbyhPEfPkTTda7IVZDhSu5BFDaaRSiek73vOkvPhQ==\",\"sdocumentreference\":\"SETP990008485\",\"rtaxxadocument\":null,\"sref\":\"SETP990008485\",\"irefindex\":990008485},\"sdebug\":\"Taxxa: 3.111s DIAN: 0.594s (creación 0.409s, revalidación 0s baja 0.184s)\"}', 47763, NULL),
(1804, '2025-01-18 13:56:24', '{\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-18\",\r\n               \"tduedate\":\"2025-01-25\",\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\":\"Nairobi Tavera Restrepo\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"42123757\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nairobi Tavera Restrepo   \",\r\n                     \"selectronicmail\":\"nairobitavera2007@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\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47764\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622665\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622666\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622667\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622668\",\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\":\"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   ', 47764, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1805, '2025-01-18 13:56:24', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"sqr\":\"SETP990008485 2025-01-18 13:56:27-05:00 901402281 42123757 148400.00 0.00 0.00 148400.00 9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9aed9ad88c2ef49ca53e90b7c06accb7927c34811cc3554b4daa5cd5b4888d59493f64315a90467e3cfd7b37de54c10a\",\"ssignature\":\"fDLzgFiQg6b2NjuTmU5F63cMUOqL2psqu0SlX/2UDc2NdCRFGKFqQNKJO2CPwEm1YrxJsqQJX8kcTz/v0AkuhEKclwSzyOiWoXZyLxEqA99XCSFLAUyN/ur4763SMp9GVc/2OPqln2Ge7ovtyiPny84oTKhE6lAn6lgd97MdhQazjK65V5P2Llncjm6OhQVVMLUW8E4Cvh0VPvor91gNmMne/WSrPVGRx4jwv23po9CzenVwgWledlRhViRWmDlP4ZEuQG9uss+H4uTd0yyFpGlcpu4YxJSGtcgCqKpWGuqSFHzLKN6TnEArVKcb3ZzZs7Y8TWqt7TNgqnBNjudzeA==\",\"sdocumentreference\":\"SETP990008485\",\"rtaxxadocument\":null,\"sref\":\"SETP990008485\",\"irefindex\":990008485},\"sdebug\":\"Taxxa: 3.064s DIAN: 0.793s (creación 0.521s, revalidación 0s baja 0.272s)\"}', 47764, NULL),
(1806, '2025-01-18 14:00:07', 'En este momento ya tiene un proceso pendiente en la Dian, pida soporte con <br><b>id: pruebaseu 47764</b>', 47764, NULL),
(1807, '2025-01-18 14:01:21', '{\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-18\",\r\n               \"tduedate\":\"2025-01-25\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8527,\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\":\"Nairobi Tavera Restrepo\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"42123757\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nairobi Tavera Restrepo   \",\r\n                     \"selectronicmail\":\"nairobitavera2007@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\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47764\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622665\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622666\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622667\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7800,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622668\",\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\":\"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   ', 47764, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1808, '2025-01-18 14:01:21', '{\"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\":\"59d3413089ca57ffba5ef0bd4989792fd1be924dc579347b3375d77e5f7e335676bad1abd0fc3b03c5de204d97373d52\",\"sqr\":\"SETP990008527 2025-01-18 14:01:24-05:00 901402281 42123757 148400.00 0.00 0.00 148400.00 59d3413089ca57ffba5ef0bd4989792fd1be924dc579347b3375d77e5f7e335676bad1abd0fc3b03c5de204d97373d52 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=59d3413089ca57ffba5ef0bd4989792fd1be924dc579347b3375d77e5f7e335676bad1abd0fc3b03c5de204d97373d52\",\"ssignature\":\"eNJJpO07rzZij8ig81seYYWx2O28C6NNWboOWbJdNzmIP6xh4xEdwb1ZuJAzG/pupnZxgQWNtBg0Eu/xcFVlo1ku5A6PP0PYwnUOciWuO9CyDZoKXcT5eQ/idXUIC0bxao8bL2+B11LJ5Ee9SakTaMVYd5TUO6Um/qfciIcelO1AtBJV/ty1Qk3vyrAy8VdUllIq3Fm77+ZdHW6Lgbq/9SeMOLXiQQ//cWBvzHB3Hkdm/l9P8TUy08IP7gOJ4pW0dLaLtra410y77EOmjm2mKuB3vrC/c/kZD5azaHfgBRIrsgziuO+yDKa8zD7QuSFWzqquKbKxAC980vrIh8STKA==\",\"sdocumentreference\":\"SETP990008527\",\"rtaxxadocument\":\"169793336\",\"sref\":\"SETP990008527\",\"irefindex\":990008527},\"sdebug\":\"Taxxa: 3.809s DIAN: 1.834s (creación 0.967s, revalidación 0.867s baja 0s)\"}', 47764, NULL),
(1809, '2025-01-18 14:02: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-18\",\r\n               \"tduedate\":\"2025-01-25\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8528,\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\":\"Nairobi Tavera Restrepo\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"42123757\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nairobi Tavera Restrepo   \",\r\n                     \"selectronicmail\":\"nairobitavera2007@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\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47765\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622672\",\r\n                  \"scustomname\":\"BUDWEISER\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622673\",\r\n                  \"scustomname\":\"REDS\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\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   ', 47765, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1810, '2025-01-18 14:02:45', '{\"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\":\"3491f8d60c8d3c215188275ca5e12d0a7045165d9353b309405ea1b4596078796722dc80fbce0adbf3f27012ef3830e4\",\"sqr\":\"SETP990008528 2025-01-18 14:02:48-05:00 901402281 42123757 14000.00 0.00 0.00 14000.00 3491f8d60c8d3c215188275ca5e12d0a7045165d9353b309405ea1b4596078796722dc80fbce0adbf3f27012ef3830e4 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=3491f8d60c8d3c215188275ca5e12d0a7045165d9353b309405ea1b4596078796722dc80fbce0adbf3f27012ef3830e4\",\"ssignature\":\"iuA6c3ZjIu1jGZRNW+vlRSH7c2Ul+ldYGLa5f4hTNZVC2cfcbJ+Ga/tAvOOk3NdIJF3YeTnn4F7VC9SbvBRmzw4Qf8ViBgoFXUf2LSMeQofQI1tobKKE8rsz81Fcm7sMzM1Bxs243rVzQSl3DdOib2DOU8n72f6OvasIVQefBpX1IPXu9e4ZQVqFcECTNINgg14lel2y67mDjpb2BH91vo7tVGA5Gsl2gmcjpCP5RSHD/Y5Ff7p3q8aQNMCfM/i2l46vCQtJSKH4tZ2FOwToVB6ARiscIwqsivuC7D0fm4lvgdX4MD1g5YZjZrinfgEFrliY9B0xuDDRJXWSvPN7xg==\",\"sdocumentreference\":\"SETP990008528\",\"rtaxxadocument\":\"169793849\",\"sref\":\"SETP990008528\",\"irefindex\":990008528},\"sdebug\":\"Taxxa: 3.853s DIAN: 1.183s (creación 0.899s, revalidación 0.285s baja 0s)\"}', 47765, NULL),
(1811, '2025-01-18 14:04: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-18\",\r\n               \"tduedate\":\"2025-01-25\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8529,\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\":\"Nairobi Tavera Restrepo\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"42123757\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nairobi Tavera Restrepo   \",\r\n                     \"selectronicmail\":\"nairobitavera2007@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\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47766\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622675\",\r\n                  \"scustomname\":\"AGUILA LIGHT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622676\",\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\":\"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   ', 47766, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1812, '2025-01-18 14:04:45', '{\"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\":\"66de2bc3bc088560271c8b71001b51c9115760769b98c89a348e7cd141ef75bce3ace3b148002669e24be539428e78e5\",\"sqr\":\"SETP990008529 2025-01-18 14:04:48-05:00 901402281 42123757 12000.00 0.00 0.00 12000.00 66de2bc3bc088560271c8b71001b51c9115760769b98c89a348e7cd141ef75bce3ace3b148002669e24be539428e78e5 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=66de2bc3bc088560271c8b71001b51c9115760769b98c89a348e7cd141ef75bce3ace3b148002669e24be539428e78e5\",\"ssignature\":\"xGIdwfY5bB023/v30crKI0jOf+/gQkljgQYs8X+WU84ZcFotVWclKxAtpK26+b7fcjkPVY1GwgUvLuJV1E8cobWSn8JXioyrVwzii0lthDtHyKpz6SKWi2BLAGqwJWv/iqDqc+OW7c2QqJaKXtrKLnt8eDCD5XTod4P9Gl0N8S9Sz5k1VFWT7A0lqb0eCdSkHqAB9dsPmAfEYYaSk9bD+ZGnz/NiV+MVnBEvzxIx9J32QDZnnH6CgUuEnEENWS3yLSioNwtrE6JAKSjrWgVy6e/iuRGJdEIflKTBGBUOv7twEHz/Uz3bY8hLpJrcrUysvXCxH2XGIPWyBF+Lni5y/Q==\",\"sdocumentreference\":\"SETP990008529\",\"rtaxxadocument\":\"169794686\",\"sref\":\"SETP990008529\",\"irefindex\":990008529},\"sdebug\":\"Taxxa: 3.773s DIAN: 1.109s (creación 0.817s, revalidación 0.292s baja 0s)\"}', 47766, NULL),
(1813, '2025-01-18 14:10:21', '{\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-18\",\r\n               \"tduedate\":\"2025-01-25\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8530,\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\":\"Nairobi Tavera Restrepo\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"42123757\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"Nairobi Tavera Restrepo   \",\r\n                     \"selectronicmail\":\"nairobitavera2007@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\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47767\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622678\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622679\",\r\n                  \"scustomname\":\"COCACOLA 1.5ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8000,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622680\",\r\n                  \"scustomname\":\"LIMONADA DE COCO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"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   ', 47767, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1814, '2025-01-18 14:10:21', '{\"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\":\"63112f4e49280d33a0249b01f9668f11c703a88a921c8ee62e13ad6a7f68aba301ef24ed48648e7727a605416c01cabc\",\"sqr\":\"SETP990008530 2025-01-18 14:10:24-05:00 901402281 42123757 22000.00 0.00 0.00 22000.00 63112f4e49280d33a0249b01f9668f11c703a88a921c8ee62e13ad6a7f68aba301ef24ed48648e7727a605416c01cabc https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=63112f4e49280d33a0249b01f9668f11c703a88a921c8ee62e13ad6a7f68aba301ef24ed48648e7727a605416c01cabc\",\"ssignature\":\"nva4WVYbnTgQ+Y6XOVCC3NRUAmWwxmI1t/c9ufX8P8Iuvl94Az3KBZdGNbyPC0EyYA+ha85a5WpA0u1F1IoRQSrb7xS8lDuy4dj6mrWdD7GPuh3LA2rBi1ocrGhZPjQkUeE4anXGuzcep5wXrnsD9HkbeB8YS52/iPc+jsjzBQfUs9ljFRlq8j2FqlDBeQQSClVcwrurFf0vi9Edyz29WTgGQ+aOqIVwrPFyFpeCasBIqTMm7sFGGydKb4vMxM4Eax6kda0zTZg8Wixag0igch7L42rqFDedBpLlB4ENvReEErIwjAvXMhk070GczBvUtFx5R37/+auNLJkeENJnHQ==\",\"sdocumentreference\":\"SETP990008530\",\"rtaxxadocument\":\"169797133\",\"sref\":\"SETP990008530\",\"irefindex\":990008530},\"sdebug\":\"Taxxa: 3.766s DIAN: 1.157s (creación 0.82s, revalidación 0.337s baja 0s)\"}', 47767, NULL),
(1815, '2025-01-30 19:19:23', '{\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-30\",\r\n               \"tduedate\":\"2025-02-06\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8531,\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\":\"fasdfasdfasdfasd asd fasdf\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"98984584\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"asdfjadsf@sahsd.com\",\r\n                     \"stelephone\":\"2315423452345\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"54\",\r\n                        \"wtowncode\":\"54001\",\r\n                        \"scityname\":\"CUCUTA\",\r\n                        \"saddressline1\":\"asd fasdf asdf asdfga\",\r\n                        \"szip\":\"540011\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47768\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622681\",\r\n                  \"scustomname\":\"CHUZO DE CERDO\",\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\":\"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   ', 47768, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1816, '2025-01-30 19:19:23', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Error al validar regla: Validate SigningTime Issued Date,1:Regla: FAD06, Rechazo: Error al validar regla: Valida que valor del CUFE esté calculado correctamente,2:Regla: 90, Rechazo: Error al validar regla: Valida duplicidad documento,3:Regla: FAB27b, Rechazo: Error al validar regla: Valida el software,4:Regla: FAJ26, Rechazo: Error al validar regla: Valida TaxLevelCode,5:Regla: ZE02, Rechazo: Error al validar regla: Valida firma del documento,6:Regla: FAJ44b, Rechazo: Error al validar regla: NIT o documento de identificación del emisor debe corresponder al informado en el RUT y debe coincidir con la Razón Social o Nombre comercial registrado.,7:Regla: FAB10b, Rechazo: Error al validar regla: Valida el rango de numeracion autorizado,8:Regla: FAB19b, Rechazo: Error al validar regla: Valida NIT}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990008531 2025-01-30 19:19:26-05:00 901402281 98984584 20500.00 0.00 0.00 20500.00 4246db27587a48ba266463b7f4b6978390ddd325d7ffffeded49d3a63fcdaabc93f3c998c390d049b6cfdc9cb8c467d3 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=4246db27587a48ba266463b7f4b6978390ddd325d7ffffeded49d3a63fcdaabc93f3c998c390d049b6cfdc9cb8c467d3,ssignature:mVdPWEwaeNUV8JGHvJMb13NpGfcy5xS89bLqyFWhzPgWG+4LrqGbLoArWozXhjolTrCel9LCH5DzUHp1Ut2/m/JHMbwA28DI664svR2arnuy6lj0Fo+JLWbWAkZbAZkvId39+35V6sLtAruEWpS9JqR9bNCwg1c44scUMA4k/TM7Wt7Bx9nKiUNDsqA8OgckACO7D7JpC0IIR/kshrjUzrp0Wi8lpFCtV1Vhky98qyUG9tXNfZQDk1GylKTNvMWjy4TNXLophr6F7zTdoK8cbVwIra1bRseOTzmE67vc4k20Wd2hL9JM33WZgLt6VeW0nioUerlIEhHAZb7lwIxaMQ==,sdocumentreference:SETP990008531,rtaxxadocument:175921405,sref:SETP990008531,irefindex:990008531},sdebug:Taxxa: 3.183s DIAN: 1.316s (creación 0.902s, revalidación 0.414s baja 0s)}', 47768, NULL),
(1817, '2025-01-30 21:36:04', '{\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-30\",\r\n               \"tduedate\":\"2025-02-06\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8531,\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\":\"fasdfasdfasdfasd asd fasdf\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"98984584\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"asdfjadsf@sahsd.com\",\r\n                     \"stelephone\":\"2315423452345\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"54\",\r\n                        \"wtowncode\":\"54001\",\r\n                        \"scityname\":\"CUCUTA\",\r\n                        \"saddressline1\":\"asd fasdf asdf asdfga\",\r\n                        \"szip\":\"540011\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47768\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622681\",\r\n                  \"scustomname\":\"CHUZO DE CERDO\",\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\":\"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   ', 47768, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1818, '2025-01-30 21:36:04', '{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:0ec8ab0133aecd6ebfe900ad25dde3bfa4f5f21c241bcc4d07dd3ad1ec5e6bc497f2cd6615e5cd5194b218881c60fc60,sqr:SETP990008531 2025-01-30 21:36:07-05:00 901402281 98984584 20500.00 0.00 0.00 20500.00 0ec8ab0133aecd6ebfe900ad25dde3bfa4f5f21c241bcc4d07dd3ad1ec5e6bc497f2cd6615e5cd5194b218881c60fc60 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=0ec8ab0133aecd6ebfe900ad25dde3bfa4f5f21c241bcc4d07dd3ad1ec5e6bc497f2cd6615e5cd5194b218881c60fc60,ssignature:LeiGP8PEmKYdEOOlCb5pgg+RCKPXfe6B+flzaVIHtGXzMRFlZ4RljjL0FI8Qx//F6oqwFQCUQlL5FWlyfpjelGYLk6RBwwDZcq98GKWou8AJIjkyoc+T1NwlrNJEljCCO9ADkLeMGxhndtb9U/AOTNCuY3y19H7SclocVmKR5ixXQaqudA4SffLD/hIbtWdRUYya2i4rrK8aK3ah3tPRpDcblefxtsMY9Rxa0qpth/QkuPLbzxW5Bf0Ng2Dgdwz5mj1tn1sS1gijelOPeDHBehehDrkXNe8ie8caCE9LfS6oykXE7bfadp2+vqOrO7n2801WZx+XExUxPId21su1lA==,sdocumentreference:SETP990008531,rtaxxadocument:175921405,sref:SETP990008531,irefindex:990008531},sdebug:Taxxa: 3.859s DIAN: 1.278s (creación 0.95s, revalidación 0.328s baja 0s)}', 47768, NULL),
(1819, '2025-02-04 14:06:24', '{\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-04\",\r\n               \"tduedate\":\"2025-02-11\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8532,\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: 47769\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622683\",\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\":\"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   ', 47769, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1820, '2025-02-04 14:06:24', '{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:9b3b222752b770642e207b1db45cbd547933a7d3600ed75a88d71ed914b868ccc2e3e838633a7cc183a04f82eac97f62,sqr:SETP990008532 2025-02-04 14:06:27-05:00 901402281 9874704 125000.00 0.00 0.00 125000.00 9b3b222752b770642e207b1db45cbd547933a7d3600ed75a88d71ed914b868ccc2e3e838633a7cc183a04f82eac97f62 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9b3b222752b770642e207b1db45cbd547933a7d3600ed75a88d71ed914b868ccc2e3e838633a7cc183a04f82eac97f62,ssignature:ZiQ79wg/ePawgyHEMJI6S5au7JRqgh0qWo9fekLX0fZSebVIj1EJaHZcEyCyfnPsoh9a80oPf+tgoCSQ+XaMabxrBcqPUIZeKs2kqM5f6F/ow0OD2uLnIpK8WjPDG4Wm+oQEcSQ74uHeUVwzWZQjw+pR6HAVjO2kVLuUnkuGK+7ITpmzljZOEFktxBUknRSiIkIfU2t2/33hoD0z2fOCEeV7QRbhIPq+9ABFP9pg/0qD+ue6l4BkBbvfGo3i20QbXU3ski/BGjtDP+Pf36zlwGadG2Nutm4+0xWI2xraz8JuH8j2pJ6Ot8Hb37IHrpqHtgJH0nMGWpsYzU0iTN1uuA==,sdocumentreference:SETP990008532,rtaxxadocument:178462388,sref:SETP990008532,irefindex:990008532},sdebug:Taxxa: 3.975s DIAN: 1.185s (creación 0.857s, revalidación 0.328s baja 0s)}', 47769, '2'),
(1821, '2025-02-04 14:07:16', '{\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-04\",\r\n               \"tduedate\":\"2025-02-11\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8533,\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: 47770\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622684\",\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   ', 47770, '9');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1822, '2025-02-04 14:07:16', '{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:1e1586c3ff605c413fd95eec94816ffa43e672f87ca3e8a6be918fb0e3c4f8624f4b1ceb311650572b4dd315ad87144e,sqr:SETP990008533 2025-02-04 14:07:19-05:00 901402281 222222222222 23000.00 0.00 0.00 23000.00 1e1586c3ff605c413fd95eec94816ffa43e672f87ca3e8a6be918fb0e3c4f8624f4b1ceb311650572b4dd315ad87144e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1e1586c3ff605c413fd95eec94816ffa43e672f87ca3e8a6be918fb0e3c4f8624f4b1ceb311650572b4dd315ad87144e,ssignature:T36bb/qy9poiuMt+8pIj8E+BKT7hHWvhm2DllNu1O7sbhKBAEhJ+rxISjjB8vySsqNSZ33Cd+DE646/MMsyYT98RiviQ863Kqv0ShVjxluPj/W73mImtwR/y20txunpzpWR9Zm+59tDtf2HB21FshTsAea55oOi8ZM4PEMiGNG24gVWLxA5k+2ocwgTd1RCRvrlHKUhbnUW6XNkDTV25AwaiQ1srFX0a6OjJak+GcjRDSVpqgbeb1DF+6c9Hi/bvd2nbxZt6p7bSJl8vXwNJBwttD93ETa7EUhMFBW6X+ILumeTrUnqYKg8JICm30g4uUoWcTlt41sEXcCa8WzdyuQ==,sdocumentreference:SETP990008533,rtaxxadocument:178462759,sref:SETP990008533,irefindex:990008533},sdebug:Taxxa: 4.219s DIAN: 1.141s (creación 0.831s, revalidación 0.31s baja 0s)}', 47770, '9'),
(1823, '2025-02-08 19:52:24', '{\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-08\",\r\n               \"tduedate\":\"2025-02-15\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8534,\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: 47772\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622690\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622691\",\r\n                  \"scustomname\":\"ARROZ PORCION\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":4300,\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   ', 47772, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1824, '2025-02-08 19:52:24', '{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:7f7e8b61662f295117051b452bda6d136a98659f3258e5e099946b7024c3b96b1a8f78e41c7e2a266a28e9b8a41d1ef7,sqr:SETP990008534 2025-02-08 19:52:27-05:00 901402281 222222222222 27300.00 0.00 0.00 27300.00 7f7e8b61662f295117051b452bda6d136a98659f3258e5e099946b7024c3b96b1a8f78e41c7e2a266a28e9b8a41d1ef7 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=7f7e8b61662f295117051b452bda6d136a98659f3258e5e099946b7024c3b96b1a8f78e41c7e2a266a28e9b8a41d1ef7,ssignature:X/5HQ5hI3hnVPqptm42qN80yOVN4oUGZ+UyjvcvelkvEIk2CVaR7BSaAR0R6zXg8ovSlyRK4SMuG3y0MwWMttF+h1OU/fHnhst85fzRMSQctAZgqfTs718bHADLYIOSRS/utdmvmdHXAnNyCIdxiPau+O/w5F/Mm/TiZOlaSl7vbIKLbuLugH1m1+1CHxtoSi8vqbn0vkQxhDU0Fihtgnmu3UfXIUVhWBm5m2WQQzLvDndkGOxuFhwnh18UCC7QyQiWel4MlzG3R6EZaLTanDBcZLrKTgidX7BpK0jFutDC14dzSo8msZhpCiFIrc19Mxm1+mi749mrHqyQzeuNj5w==,sdocumentreference:SETP990008534,rtaxxadocument:180670682,sref:SETP990008534,irefindex:990008534},sdebug:Taxxa: 4.276s DIAN: 1.491s (creación 0.939s, revalidación 0.552s baja 0s)}', 47772, '2'),
(1825, '2025-02-09 14:29:52', '{\r\n      \"sToken\":\"774855597565\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09\",\r\n               \"tduedate\":\"2025-02-16\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 8535,\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: 47773\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622693\",\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   ', 47773, '2');
