INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1749, '2024-08-06 20:21:56', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"e000a46474c793b967b604171906ab5df21b6c37bead16b66f1aca84ea3a38437158bb256bb0f924a9543b1d77ee1900\",\"sqr\":\"SETP990000846 2024-08-06 20:21:58-05:00 901402281 222222222222 18403.36 3496.64 0.00 21900.00 e000a46474c793b967b604171906ab5df21b6c37bead16b66f1aca84ea3a38437158bb256bb0f924a9543b1d77ee1900 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=e000a46474c793b967b604171906ab5df21b6c37bead16b66f1aca84ea3a38437158bb256bb0f924a9543b1d77ee1900\",\"ssignature\":\"kv0h02MPm6N3ENhcd0P0zp/oz/UVFquLiYlSt65Xy1l7RSX/sO2q2Qs59IdNwbs5T9rqul2dQCVArAQTJ9c1qwLAl9h+2LzL5XWDpbUDSZcCI1/4mlHtpxrUkNxGPBsXwQFGfdZ1idhS+9tB/1TMG+ezKNKE3OOBkz6RFDCEvp8DH0Gi90dEmCP+cU7eV7cbs7vJiNlHqOyNIfM+IT/UrSTZhDwRRlEKyj0IoRc3MJePwiHWcS9oPJW8BJRDkeIyiLA+bacVKFZneQPo1dsfYJ1qXJGvttzkrFrXWy1hhYppY3wTtrgM2M8xLMCa2gSHeDr3S6NBlEBolg30hhYfNA==\",\"sdocumentreference\":\"SETP990000846\",\"rtaxxadocument\":\"96780575\",\"sref\":\"96780575\",\"irefindex\":990000846},\"sdebug\":\"Taxxa: 0.141s DIAN: 10.273s (creación 8.262s, revalidación 1.334s baja 0.678s)\"}', 47736, NULL),
(1750, '2024-08-06 20:24:09', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"1164877\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47737\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 847,\n             \"wpaymentmethod\": \"10\",\n             \"wpaymentmeans\":1,\n             \"snotetop\":\"Cra 14  9-07\",\n                \"jbuyer\":{\n                   \"wlegalorganizationtype\":\"person\",\n                   \"stributaryidentificationkey\":\"01\",\n                   \"stributaryidentificationname\":\"IVA\",\n                   \"sfiscalresponsibilities\":\"R-99-PN\",\n                   \"sfiscalregime\":\"49\",\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                      \"jregistrationaddress\":{\n                         \"scountrycode\":\"co\",\n                         \"wdepartmentcode\":\"66\",\n                         \"wtowncode\":\"66001\",\n                         \"scityname\":\"PEREIRA\",\n                         \"saddressline1\":\"Cra 14  9-07\",\n                         \"szip\":\"660001\"\n                      }\n                   } \n                }, \n                \"snotes\":\" Id: 47737\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622566\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":6554.6218487395,\n                   \"nusertotal\":6554.621848739496,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1245.3781512605042,\n                            \"nbaseamount\":6554.621848739496\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622567\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"901402281\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5042.0168067227,\n                   \"nusertotal\":5042.01680672269,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":957.9831932773109,\n                            \"nbaseamount\":5042.01680672269\n                        }\n                   }\n                },\"3\":{\n                   \"sStandardItemIdentification\":\"3_622568\",\n                   \"sdescription\":\"MANGO EN AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"901402281\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":4201.6806722689,\n                   \"nusertotal\":4201.680672268908,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":798.319327731,\n                            \"nbaseamount\":4201.680672268908\n                        }\n                   }\n                },\"4\":{\n                   \"sStandardItemIdentification\":\"4_622569\",\n                   \"sdescription\":\"PORCION DE AGUACATE\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":2605.0420168067,\n                   \"nusertotal\":2605.0420168067226,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":494.9579831932773,\n                            \"nbaseamount\":2605.0420168067226\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"901402281\",\n                     \"sdoctype\":\"NIT\",\n                     \"ssellername\":\"FERRE COSTOS LA 14\",\n                     \"jcontact\":{\n                         \"scontactperson\":\"JUAN ALARCON\",\n                         \"selectronicmail\":\"ferrecostos@gmail.com\",\n                         \"stelephone\":\"\",\n                         \"jregistrationaddress\":{\n                            \"wdepartmentcode\":\"66\",\n                            \"sdepartmentname\":\"RISARALDA\",\n                            \"wtowncode\":\"66001\",\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    ', 47737, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1751, '2024-08-06 20:24:09', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"77aa767a4d991e4868961ec15ea725f18683b056f8e96d5b5ab548b90e6b986b70f46cf472e33000732ee229b25a5f98\",\"sqr\":\"SETP990000847 2024-08-06 20:24:11-05:00 901402281 222222222222 18403.36 3496.64 0.00 21900.00 77aa767a4d991e4868961ec15ea725f18683b056f8e96d5b5ab548b90e6b986b70f46cf472e33000732ee229b25a5f98 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=77aa767a4d991e4868961ec15ea725f18683b056f8e96d5b5ab548b90e6b986b70f46cf472e33000732ee229b25a5f98\",\"ssignature\":\"RE3oZ4mv7Y6ykGnElooN3Rrx2nBu1tA+Fyfh4RrVbttyxi9FdFqNcppR+EBKGfQPYqMYfXE3RdIxPiyOO2I/Zo/D8zYeXmPGhCAQI+i5MNfCEgh3YpR+iBqy5UzM8AZKMAebMjHgEMYdAzgN4AaLTuz7sdYCCusjCoSPpx9UP76y4+FnU2EBG3Xq8sfKEy2KEiiJ9BTxSSfKxlkQpFy/jISsnDTBmtL5Qiln5JQM2nbXL+Kgb2lGPt0LiB9fKhOjeXku3X3Qfz9orbFgWnFpdhshtB59YfO/UQnB5EuebocNfRz3TxLM4EwdbkbEDsNFVSkrws36cVeoxX9qezGcaQ==\",\"sdocumentreference\":\"SETP990000847\",\"rtaxxadocument\":\"96781486\",\"sref\":\"96781486\",\"irefindex\":990000847},\"sdebug\":\"Taxxa: 0.172s DIAN: 8.222s (creación 5.644s, revalidación 1.625s baja 0.953s)\"}', 47737, NULL),
(1752, '2024-12-27 18:08: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\":\"2024-12-27\",\r\n               \"tduedate\":\"2025-01-03\",\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: 47745\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622612\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":65000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47745, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1753, '2024-12-27 18:08:16', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"sqr\":\"SETP990000848 2024-12-27 18:09:06-05:00 901402281 222222222222 65000.00 0.00 0.00 65000.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"UyCCcq2pDsbvo+jm8vmFi8+KGqAEPn4N+956baSEX0LTiPxTDKLTLjl0lgnzfX4ayUgGW5mZ1TdU93dq6/ZGVuHAYqYQXABXAhVJo6AktFWwccHY/xebWKvREMSqV6aJ4LLpbNwcTkw2sGgcacpQPlifkG63aZuO5jH+RnrTVv3aaAOCFdpEAc3bqPbtNuWgj/okbD4QEUSySdCSJyAqMCcw4QrMttxxinKdz7EWJv+8yxTxTg6x5krNGfRevLzkqcOa3/yOXMNIbu3oF8FQMgmgidcQNWlXGw9AmiiKUXyk9K3z+GLyhdE9U7YGqqWIux+QxELgLtg3ImX4gbLkFw==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":\"159164548\",\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.15s DIAN: 0.929s (creación 0.433s, revalidación 0s baja 0.496s)\"}', 47745, NULL),
(1754, '2024-12-27 18:45:14', 'En este momento hay intermitencia en la dian, espera varios minutos antes de enviar la siguiente factura (2024-12-27 18:50:00\n)', 47746, NULL),
(1755, '2024-12-27 19:21: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\":\"2024-12-27\",\r\n               \"tduedate\":\"2025-01-03\",\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: 47747\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622618\",\r\n                  \"scustomname\":\"AGUILA CERO\",\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   ', 47747, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1756, '2024-12-27 19:21:04', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"sqr\":\"SETP990000848 2024-12-27 19:21:52-05:00 901402281 222222222222 6000.00 0.00 0.00 6000.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"uSYX3MWTLv4wwyztoNzbYk97ggHnWrCKVfLu4YUwXM98OxS7rWQ2xu/2zHdDaEO03E8Z0ns5h0bbSc/b/8mhTbeVo551QPM8NIetWbz+FtMLRkVl/zyzHFKfsLMcW1THQs8t6/fefNhNKPOYPaJQ5fODc7OPX8zlELGH7peT0TgCTZod93MKrwEAB9oKRY7L4lRe/mSLW9jAgMa0PBOXA0vXO4lTy+NzJsTvN1ie1QT/OpB0gaPe0So6fJF0lckZ/Jmivi5mTJecy12FQ/H48t3EjEowgz1YoyBYEFfvp+HaUKlKgAG8OBD5Zy0eWmBI4PVOgt26JKTG0sFe/itcYg==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.061s DIAN: 1.145s (creación 0.408s, revalidación 0s baja 0.736s)\"}', 47747, NULL),
(1757, '2025-01-05 06:47:58', '{\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: 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
(1758, '2025-01-05 06:47: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:47:59-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\":\"epfVmIXbbW+DlYGhd4c9DrmlMbD1aLjFVpF8KbjaFMkcJvT/k15UYT/j4tDX+W0OXHFvz+krfj8ofWE0419FF4+FqCUn15eFzDJ6ulYQ3Dsi0ECP6Gfxi5laHy73McG0fN1HXX7SRGDeYuoXvncbLjMGakeHjJMNtqHDf1yzHADpmYupEojEQLWuHuSR+HiId6RvajPzuIjpZDQG/QKWojYJS5Tqx9AblWSAjLMsOBsaPTyh/m/jeY0sgCS+WKePOJuWq3totI+bvjo0lWhTohG7sPMdRMJa+4eUn5YLhZgzeDJX+sZJv9xDCQbkOdQ0/TlGIQyJRbInPXhReIHj6g==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.086s DIAN: 1.586s (creación 0.945s, revalidación 0s baja 0.641s)\"}', 47748, NULL),
(1759, '2025-01-05 06:49: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-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: 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
(1760, '2025-01-05 06:49:04', '{\"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:49:04-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\":\"R3z8evF6RTg4nmPWYNi/blWo0hViIIJdbRVWtvR/iBdgfduHhVal8EBpy8xUslPZeDKQV0VaX40go2Z2CDp1E1r12POn/Oc3sI1Yuq2PdryQc5pmnbJRTJMchmav5Bq5CJYmflL3mKeXKYAMUkJK21zmtPk+6B9zGeNJ1THb4Iis3oHCLmpfEENJm2pmR0pcH/njMxEBotpNb/ccQFVNGuFsVvR/5FAZTMKxjw3+ulr1iT1yfd0XplyUdSOYDMNho8BlshhUufWxwANUYAUYiSkxw5JPkEzA8X13Su7LNUGltvu2+10JaWHlPAItK3LliAMuTuIUaxOGwzksl3/CDA==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.063s DIAN: 1.266s (creación 0.695s, revalidación 0s baja 0.57s)\"}', 47749, NULL),
(1761, '2025-01-05 06:53:25', '{\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: 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);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1762, '2025-01-05 06:53:25', '{\"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:53:26-05:00 901402281 222222222222 16500.00 0.00 0.00 16500.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"hZ/R7a/6TRrS7ykZOOypb4CotajpNGkYvRkDUv61pG7bG/UwJt11PxWRkLV8QD5iId9R9XxhOM18GvQ82GcaANtLUv8qjW8Mbyzpt/5Svmdg/JqfhXnf3yIkoQ6fnIgjMBNwYUsRCiiSV8vfV2W3wt0asXAbaUjFZR8BAqWsMToejoO9LnWWCmi0cQwOaSehLennQ0FMId4XJsl+dLzLXUqOb3Sh6fnxMG08HR4An+40TTevWD++Wk4iTzOkPdFXZZ5PDH01Bz/iSSh9EulhPESI5VnsxjCR3Zo7GV140if64oJ0lsfHtOOolFx+rnhHkW0+6HzFvxf/PbO8MAZx2g==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.047s DIAN: 1.07s (creación 0.539s, revalidación 0s baja 0.531s)\"}', 47750, NULL),
(1763, '2025-01-05 06:53:55', '{\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: 47751\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622626\",\r\n                  \"scustomname\":\"CARNE TRIMIXTA 460gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":32500,\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   ', 47751, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1764, '2025-01-05 06:53:55', '{\"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:53:56-05:00 901402281 222222222222 32500.00 0.00 0.00 32500.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"CJdwLy1FO58ChgNfjBD14vbYuLFIhLNVNhfXWHIl/BwziYz85o5DHzVxpIt/Nma4QHWGyyfU/rJqtL/eOeDuNjsM3TN6tRNx5qojY2SzLG2xwIS8Rxmbx83Jw9hh3EmunP1iMOzCouPMwvJ6ln1YPNiWYO+FaaNeaQi/qPM8HNOErWLFCYdTzD4/JYluNB+85d5sd7W2LFnXsuKYLnT8Cp85Zz9tf4clM3BC/jYt5oRfDsQRT0yNFI7FEl3Un6i+qk5ODxoJy6dCc0yw49gKSn/numpcx9fhSoig0kzIAQnTAs2izW8wg9T7jVc7QxSPesAQtHKqTIemhyApDJislg==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.063s DIAN: 1.273s (creación 0.711s, revalidación 0s baja 0.563s)\"}', 47751, NULL),
(1765, '2025-01-05 06:56: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-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: 47752\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622633\",\r\n                  \"scustomname\":\"AREPA GRATINADA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":4000,\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   ', 47752, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1766, '2025-01-05 06:56:15', '{\"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:56:15-05:00 901402281 222222222222 4000.00 0.00 0.00 4000.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"NhI478yprDHT7+ISSLzH2fHyrsMvlJ1W0/gduSir9oXjB17nwUm4Zb8++N9j8iuOaY59A08825A3NuF9RrcUlyW5M335ll86AqxJp8pnbgZoK09IfutG3OAaOuEWeVF+eoJRDmfeLwviH2L+PGPVHO4dTlI5clVrkpcRzlF+u2fQjdAybWE6Bsk5Of+p9GEOw9qoKjMfdU1VjbkuXqwx/96XAUkWfUmdzyIGSblftFvLU0up1pzPiQDSXaS5lnHm/x48o8cFnSsiDgZ8NFS9SxIxgyCfRzNi47LAiF1D9VVvPji54ICp4a3cy2SvyffpQdhgffHsUDXYuJDGfiFBlA==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.07s DIAN: 0.75s (creación 0.281s, revalidación 0s baja 0.469s)\"}', 47752, NULL),
(1767, '2025-01-05 06:57:46', '{\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: 47753\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622634\",\r\n                  \"scustomname\":\"BANANO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47753, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1768, '2025-01-05 06:57:46', '{\"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:57:47-05:00 901402281 222222222222 500.00 0.00 0.00 500.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"cxa7r1F29EB3z2maTFFSq6pNwkSv3lenv0lNS+Nhms2uOsWxEIBa3DHt6BIbk7phvCa5VN1KurzMCIFslCqMuCKRjI6ps+To09mptmMhgQBr8BCWY/KOxgwHPFNYN5c5UF5JZfixQFnsabF2g2W1GAOPKnpYAcsEWk9zpxJj/S/2xRdnAnRvGpK+X+uw4/OrzqF7sNmXq6gU2MQvSbMfsrzpFUMH4gspXvyI7zxIWcrfg8hWZl6I5DnYPgcH+d+OWG8HYmra72bLOEZDSKeo8PGBxWfbkMFdxaytdCO3hd7QIoBLLovKxc+6MmVFPybFZn1EXOmBoC/mp1wyUITPOA==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.078s DIAN: 1.133s (creación 0.547s, revalidación 0s baja 0.586s)\"}', 47753, NULL),
(1769, '2025-01-05 06:58:06', '{\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: 47754\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622635\",\r\n                  \"scustomname\":\"BANANO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47754, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1770, '2025-01-05 06:58:06', '{\"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:07-05:00 901402281 222222222222 500.00 0.00 0.00 500.00 c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c531f00735dd4dfc7177037405b4e8f471abf269acdd1fef51517352238457a77f9a84c11f730e15e30a4bd3b1f5b9d0\",\"ssignature\":\"JDns8NfVHn35X2qppG8cdfC4cCU0+9CxGgpbL12rTAwa8lkDFfs9Zol4MmHIC/t0n1/MZhSa25lmdKqID3WeImyiUjKytL6VtkOY1qwBB3gWwmmckybA6JuiqZgjizsSYvaNshQM7pIqpg36Ucip2D1IVsmHdFg3DyXdwmW2PAMbjGJ62rvwyP8mBkYy149KIRyeg9pDyndQkpSBEFBuGCTt6f9REY9iSZGSd9FBG2qt3NSFg0N9NOQQ9giqr01izvw4fQuDr5hneB914fGLoyYrIXML20rRxSmq3VIfcrfkomQ/JrvM5QD6JJA7nnAva6RVV0DON53xUvVX0M76Yw==\",\"sdocumentreference\":\"SETP990000848\",\"rtaxxadocument\":null,\"sref\":\"SETP990000848\",\"irefindex\":990000848},\"sdebug\":\"Taxxa: 0.086s DIAN: 1.055s (creación 0.523s, revalidación 0s baja 0.531s)\"}', 47754, NULL),
(1771, '2025-01-05 06:58:58', '{\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: 47755\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622636\",\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   ', 47755, NULL);
