INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1654, '2024-07-22 15:17:26', '{\r\n      \"sToken\":\"696628881017\",\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-07-22\",\r\n               \"tduedate\":\"2024-07-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 805,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47713\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622518\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47713, NULL),
(1655, '2024-07-22 15:17:26', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"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\":\"fa73c4dfe914061466333d0487ca8a291b3168e6b1e1b1e9ab4746a5407027aef725ac4d45f5968c6636a66fbae8a01d\",\"sqr\":\"SETP990000805 2024-07-22 15:17:30-05:00 901402281 222222222222 21296.30 1703.70 0.00 23000.00 fa73c4dfe914061466333d0487ca8a291b3168e6b1e1b1e9ab4746a5407027aef725ac4d45f5968c6636a66fbae8a01d https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=fa73c4dfe914061466333d0487ca8a291b3168e6b1e1b1e9ab4746a5407027aef725ac4d45f5968c6636a66fbae8a01d\",\"ssignature\":\"fi+J44Cx2v1IXVi6gvTbCHG6BNX/t7yIymWF+pvKDIMRpfGfmvH2kXX9PV97t10nQpDyzSu4N67HDnx/Gc4SdCtdlxRmKhybxBoxEpu/PahqcESeDiK2ewmtpIgfq5CjBeDwToH3eDRQvlFodwCueCI01HDd0A3kueCoY1htMSY0XmLc6MsP9JTKLl9pZNo2Xnt/q8aw6iwtAIJyCMp2XydHvAqwK9hvvTwY7rQimkRit2v4qh6kANVI/cvxMyxnVU0wYEiM3yxBdW1iLm3Myfcj3+UMm8PRG6yUJU8mOtjif2ldMJ0RWQgz1RXeEYoZrUrseNieJfEuu+wxVJXNGA==\",\"sdocumentreference\":\"SETP990000805\",\"rtaxxadocument\":\"91215810\",\"sref\":\"91215810\",\"irefindex\":990000805},\"sdebug\":\"Taxxa: 0.185s DIAN: 6.554s (creación 4.584s, revalidación 1.315s baja 0.655s)\"}', 47713, NULL),
(1646, '2024-07-21 00:32:36', '{\r\n      \"sToken\":\"696628881017\",\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-07-21\",\r\n               \"tduedate\":\"2024-07-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 804,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47705\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622492\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":60185.185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47705, NULL),
(1647, '2024-07-21 00:40:14', '{\r\n      \"sToken\":\"696628881017\",\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-07-21\",\r\n               \"tduedate\":\"2024-07-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 804,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47706\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622495\",\r\n                  \"scustomname\":\"TRASPORTE ASAMBLEA 2023\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":240740.74074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47706, NULL),
(1648, '2024-07-21 00:43:03', '{\r\n      \"sToken\":\"696628881017\",\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-07-21\",\r\n               \"tduedate\":\"2024-07-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 804,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47707\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622496\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622499\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47707, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1649, '2024-07-21 00:45:10', '{\r\n      \"sToken\":\"696628881017\",\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-07-21\",\r\n               \"tduedate\":\"2024-07-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 804,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47708\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622503\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":60185.185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47708, NULL),
(1650, '2024-07-21 00:45:56', '{\r\n      \"sToken\":\"696628881017\",\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-07-21\",\r\n               \"tduedate\":\"2024-07-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 804,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47709\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622506\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":60185.185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47709, NULL),
(1651, '2024-07-21 00:46:18', 'En este momento hay intermitencia en la dian, espera varios minutos antes de enviar la siguiente factura', 47710, NULL),
(1652, '2024-07-21 16:32:48', '{\r\n      \"sToken\":\"696628881017\",\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-07-21\",\r\n               \"tduedate\":\"2024-07-28\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 804,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47712\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622515\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47712, NULL),
(1653, '2024-07-21 16:32:48', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"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\":\"d62cb1273b1d9a51907015a423bb35141d77f3f9f7a6637bc62dec6de771ef8ea429773b47cee55095d5170c0b4b6b5b\",\"sqr\":\"SETP990000804 2024-07-21 16:32:49-05:00 901402281 222222222222 21296.30 1703.70 0.00 23000.00 d62cb1273b1d9a51907015a423bb35141d77f3f9f7a6637bc62dec6de771ef8ea429773b47cee55095d5170c0b4b6b5b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d62cb1273b1d9a51907015a423bb35141d77f3f9f7a6637bc62dec6de771ef8ea429773b47cee55095d5170c0b4b6b5b\",\"ssignature\":\"oG8IekwJlNhO6IlsXypTy3Ce+q239YBToLYvUucMl41gbsoT4U92hmvNDUaU+BjzF8I0Ov6I+q62InphNI9gjCSCrL5rtiMkRxz0c8WBVMhn9hbsloTs4Iys+meBUuTAgcUGxgtR3j8LAJ6fli+KDoHa9+0VhKlDUTvkjwc6RUD6DWuodvPrFpuPyjrAb3lwv1gFKZlKUL4yt4zSGi8qOlPX9GOdqrpxGdKpMhkSwM5jOAZaDyApkarcfhEhMUOdRp4GjlEFSGi95LluCq60rl09oldc0/Z5joWT7Vli0OgRPgAnE62geblOxE+8xjmO7eFEVm2qwlvD56OckkC5Rw==\",\"sdocumentreference\":\"SETP990000804\",\"rtaxxadocument\":\"90976585\",\"sref\":\"90976585\",\"irefindex\":990000804},\"sdebug\":\"Taxxa: 0.146s DIAN: 7.868s (creación 6.905s, revalidación 0.382s baja 0.582s)\"}', 47712, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1645, '2024-07-20 08:12:17', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"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\":\"25715d0bad86a5c778136049db209b87ce1eee344b0f8c78716aaddb98373a5f8a0abcd834603489cf8baa7ac5426d52\",\"sqr\":\"SETP990000803 2024-07-20 08:12:18-05:00 901402281 222222222222 50462.96 4037.04 0.00 54500.00 25715d0bad86a5c778136049db209b87ce1eee344b0f8c78716aaddb98373a5f8a0abcd834603489cf8baa7ac5426d52 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=25715d0bad86a5c778136049db209b87ce1eee344b0f8c78716aaddb98373a5f8a0abcd834603489cf8baa7ac5426d52\",\"ssignature\":\"ktbtqhnxJWVZXCk6D25v3ZZCLkvKSlM1evt1oY/p4dwo7qFpU6gF7/P6AYOzS2p73Ra1+s/0iE7mc8jAWaLL0TOVGePneppPwu/ZaM97Y4tjDOirSQjoNpPWp6atPTS0HtIVDU3oxEjp6Z/gLybruFYC9hpWXbK2FEMRkxFn3URvaRFoysSfU4X3hm2hIsTKslh9GV0M35dSk2iTZPFbY771/HQIPOGKciYoUgSV9fSVXhUBJgULGob4HmRFWHojDXAqdDIIOkNrbRNqmD+KJYJBAhESl8ucwN/phopD2Gb7mJTJddOeLNWEnIz9/6KgvDt/F/7fLu47Rx9x7zMuow==\",\"sdocumentreference\":\"SETP990000803\",\"rtaxxadocument\":\"90580933\",\"sref\":\"90580933\",\"irefindex\":990000803},\"sdebug\":\"Taxxa: 0.148s DIAN: 6.76s (creación 5.935s, revalidación 0.312s baja 0.513s)\"}', 47704, NULL),
(1637, '2024-07-17 19:16:14', '{\r\n      \"sToken\":\"696628881017\",\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-07-17\",\r\n               \"tduedate\":\"2024-07-24\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 800,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47700\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622463\",\r\n                  \"scustomname\":\"TRASPORTE ASAMBLEA 2023\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":240740.74074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47700, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1638, '2024-07-17 19:16:14', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"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\":\"ade0ed5b3d947bec97a50d2b6f954ce976c9e6356772cdcfab6f2f22355c1a3f47be42425798001def93185dd8cef0fb\",\"sqr\":\"SETP990000800 2024-07-17 19:16:15-05:00 901402281 222222222222 240740.74 19259.26 0.00 260000.00 ade0ed5b3d947bec97a50d2b6f954ce976c9e6356772cdcfab6f2f22355c1a3f47be42425798001def93185dd8cef0fb https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=ade0ed5b3d947bec97a50d2b6f954ce976c9e6356772cdcfab6f2f22355c1a3f47be42425798001def93185dd8cef0fb\",\"ssignature\":\"FV+dFTqQTs9SWgJmg3si8+jebrnqbNAfj7g8w831Gptxm6pN9Br3k3u2sqobHRVGLOq73gpEdRBhMh+SJi7PzS+dJOvNSfbZHSczyheLRe+FAgKiBVCkpuOaSiU7TIFO2CZbYB6w7Tv4YdvPnC22ExPi/RwB7aioa9KkfDKtvE71aWO3IsoBt9R0qBZGmSGA4Sa+HxJeoELVZCJwCeeirUMy/d4KA/tQZ23Qgo89AzQnP8QtG3V3Hrz027b6ZEUDOcVBp40NAcMLAgP2R4wc6bcr++z3htrhPDNlvrmTvh8mHe5ffB5+lvpcAyIliWU/2GAEp3Ri6avgrqhxfjM5+A==\",\"sdocumentreference\":\"SETP990000800\",\"rtaxxadocument\":\"89919419\",\"sref\":\"89919419\",\"irefindex\":990000800},\"sdebug\":\"Taxxa: 0.152s DIAN: 2.193s (creación 0.952s, revalidación 0.583s baja 0.658s)\"}', 47700, NULL),
(1639, '2024-07-17 19:16:31', '{\r\n      \"sToken\":\"696628881017\",\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-07-17\",\r\n               \"tduedate\":\"2024-07-24\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 801,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47701\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622464\",\r\n                  \"scustomname\":\"ESCARCHADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622465\",\r\n                  \"scustomname\":\"POKER\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622466\",\r\n                  \"scustomname\":\"ESCARCHADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47701, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1640, '2024-07-17 19:16:31', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"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\":\"4723f7620d43921b936ed867332c5603940a710a05f4e67db7740f491e8927b93f773b87b4c5bc4eb875055f73c05b63\",\"sqr\":\"SETP990000801 2024-07-17 19:16:32-05:00 901402281 222222222222 10185.19 814.82 0.00 11000.01 4723f7620d43921b936ed867332c5603940a710a05f4e67db7740f491e8927b93f773b87b4c5bc4eb875055f73c05b63 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=4723f7620d43921b936ed867332c5603940a710a05f4e67db7740f491e8927b93f773b87b4c5bc4eb875055f73c05b63\",\"ssignature\":\"PKSgYDsYkoSRY8mImuTJNHMxb6POrPBwjmZ27zZHP6TiPW1ig/Vx1NJ3vHCf7E6mI6iWbDTrwNAAepxx9hXUAB51/8qP9q0ZNsrpsmVacEGCQsaDM6AtSq6DrNbVJjk9tHln6j8sbP5bquAKHeyl57Z3Kl6jqikSpaoN7jkIIeIhN5zJpuxtFQZKXZI9A1VZ/5Kx6f0J2ho72fWDeTMxu1ajon18T4J+qr5yaqAA6m5tPXYwB0MhzpnH1a/2+uRDdnj739Zjnctd1Dkx4d5JwF03/V83CfpGjFPy/yx9ZaV7hKEEu4tm5NUXd7C490WNPiEKluuxNtlBqJ6+/qP+8g==\",\"sdocumentreference\":\"SETP990000801\",\"rtaxxadocument\":\"89919494\",\"sref\":\"89919494\",\"irefindex\":990000801},\"sdebug\":\"Taxxa: 0.131s DIAN: 7.259s (creación 5.904s, revalidación 0.467s baja 0.889s)\"}', 47701, NULL),
(1644, '2024-07-20 08:12:17', '{\r\n      \"sToken\":\"696628881017\",\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-07-20\",\r\n               \"tduedate\":\"2024-07-27\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 803,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47704\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622477\",\r\n                  \"scustomname\":\"BURGER TRIMIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":26388.888888889,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622482\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47704, NULL),
(1642, '2024-07-18 19:08:03', '{\r\n      \"sToken\":\"696628881017\",\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-07-18\",\r\n               \"tduedate\":\"2024-07-25\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 802,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\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\":\"1234567890\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47703\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622474\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47703, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1643, '2024-07-18 19:08:03', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"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\":\"dd899b41c5486e1d4b2ade2c6ad23cf16312f11064a8c699b3e8b9eed7079ecacc14621cf9def24b247e63520cae391c\",\"sqr\":\"SETP990000802 2024-07-18 19:08:05-05:00 901402281 222222222222 21296.30 1703.70 0.00 23000.00 dd899b41c5486e1d4b2ade2c6ad23cf16312f11064a8c699b3e8b9eed7079ecacc14621cf9def24b247e63520cae391c https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=dd899b41c5486e1d4b2ade2c6ad23cf16312f11064a8c699b3e8b9eed7079ecacc14621cf9def24b247e63520cae391c\",\"ssignature\":\"R9huRJNFCidyBhHkKdasG4icdCSW7GmXL1k8vr+I6lMNvLVPXuNKxKgxqfF7rxL2fyLhK91wN43Vmd8MvUr9ia3oGDCRYEMYSk5Z1vk3SkvRqdCwwXCKQzQ0oYTkcM+Qj9eSq1NajGbvXr/vOuysiTr/w2WvjDpT8DCt+SfExD6eH3+FrFkHPbCfX36CpTnD8ESHN6XtonvKKzHdimBFnQa2hrccuYZ7ThNbw0F24b9Zay0xviNVAmowkBxn62ku3WVXmUkD/BAvcLFHwpeA0ntxwE2QpkyDGSZ18mZTknKNHz6j3skCdCTG0YHR+Pla5tjXq1nKUzIJoBAHnK39TA==\",\"sdocumentreference\":\"SETP990000802\",\"rtaxxadocument\":\"90177677\",\"sref\":\"90177677\",\"irefindex\":990000802},\"sdebug\":\"Taxxa: 0.178s DIAN: 7.609s (creación 5.731s, revalidación 1.326s baja 0.552s)\"}', 47703, NULL),
(1656, '2024-08-04 05:37:15', '{\r\n      \"sToken\":\"696628881017\",\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-08-04\",\r\n               \"tduedate\":\"2024-08-11\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 806,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"17\",\r\n                        \"wtowncode\":\"17877\",\r\n                        \"scityname\":\"VITERBO\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"177020\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47716\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622527\",\r\n                  \"scustomname\":\"HAMBURGUESA DE PROMOCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":17592.592592593,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622528\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"90140255\",\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\":\"17\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17877\",\r\n                           \"scityname\":\"VITERBO\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"177020\",\r\n                           \"wprovincecode\":\"17877\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47716, NULL),
(1657, '2024-08-04 05:37:15', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47716, NULL),
(1658, '2024-08-05 19:26:10', '{\r\n      \"sToken\":\"696628881017\",\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-08-05\",\r\n               \"tduedate\":\"2024-08-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 806,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"17\",\r\n                        \"wtowncode\":\"17877\",\r\n                        \"scityname\":\"VITERBO\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"177020\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47717\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622534\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"90140255\",\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\":\"17\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17877\",\r\n                           \"scityname\":\"VITERBO\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"177020\",\r\n                           \"wprovincecode\":\"17877\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47717, NULL),
(1659, '2024-08-05 19:26:10', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47717, NULL),
(1660, '2024-08-05 19:26:37', '{\r\n      \"sToken\":\"696628881017\",\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-08-05\",\r\n               \"tduedate\":\"2024-08-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 806,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"17\",\r\n                        \"wtowncode\":\"17877\",\r\n                        \"scityname\":\"VITERBO\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"177020\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47718\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622537\",\r\n                  \"scustomname\":\"Lampara de techo Panel Cuadradad  LED AT45 superpuesta \",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15277.777777778,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"90140255\",\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\":\"17\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17877\",\r\n                           \"scityname\":\"VITERBO\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"177020\",\r\n                           \"wprovincecode\":\"17877\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47718, NULL),
(1661, '2024-08-05 19:26:37', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47718, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1662, '2024-08-05 19:27:06', '{\r\n      \"sToken\":\"696628881017\",\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-08-05\",\r\n               \"tduedate\":\"2024-08-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 806,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"17\",\r\n                        \"wtowncode\":\"17877\",\r\n                        \"scityname\":\"VITERBO\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"177020\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47719\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622538\",\r\n                  \"scustomname\":\"Lampara de techo Panel Cuadradad  LED AT45 superpuesta \",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15277.777777778,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"90140255\",\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\":\"17\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17877\",\r\n                           \"scityname\":\"VITERBO\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"177020\",\r\n                           \"wprovincecode\":\"17877\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47719, NULL),
(1663, '2024-08-05 19:27:06', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47719, NULL),
(1664, '2024-08-05 19:28:23', '{\r\n      \"sToken\":\"696628881017\",\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-08-05\",\r\n               \"tduedate\":\"2024-08-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 806,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"ferrecostos@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"17\",\r\n                        \"wtowncode\":\"17877\",\r\n                        \"scityname\":\"VITERBO\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"177020\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47720\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622539\",\r\n                  \"scustomname\":\"Lampara techo Led 5T B34\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":11388.888888889,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"90140255\",\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\":\"17\",\r\n                           \"sdepartmentname\":\"CALDAS\",\r\n                           \"wtowncode\":\"17877\",\r\n                           \"scityname\":\"VITERBO\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"177020\",\r\n                           \"wprovincecode\":\"17877\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47720, NULL),
(1665, '2024-08-05 19:28:23', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47720, NULL),
(1666, '2024-08-06 10:26:43', 'No puede crear una factura de mandato si la cédula del Mandante no es correcta', 47724, NULL),
(1667, '2024-08-06 10:28:09', 'No puede crear una factura de mandato si la cédula del Mandante no es correcta', 47725, NULL),
(1668, '2024-08-06 10:28:52', 'No puede crear una factura de mandato si la cédula del Mandante no es correcta', 47726, NULL),
(1669, '2024-08-06 10:38:00', 'No puede crear una factura de mandato si la cédula del Mandante no es correcta', 47727, NULL),
(1670, '2024-08-06 10:40:16', 'No puede crear una factura de mandato si la cédula del Mandante no es correcta', 47728, NULL),
(1671, '2024-08-06 11:08:09', 'No puede crear una factura de mandato si la cédula del Mandante no es correcta', 47729, NULL),
(1672, '2024-08-06 13:57:07', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47730\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47730\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622551\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":,\n                            \"nbaseamount\":7222.222222222223,\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47730, NULL),
(1673, '2024-08-06 13:57:07', '{\"rError\":21,\"sMessage\":\"The JSON format is invalid\"}', 47730, NULL),
(1674, '2024-08-06 13:57:07', 'The JSON format is invalid', 47730, NULL),
(1675, '2024-08-06 14:15:29', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47731\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47731\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622552\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":,\n                            \"nbaseamount\":7222.222222222223,\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47731, NULL),
(1676, '2024-08-06 14:15:29', '{\"rError\":21,\"sMessage\":\"The JSON format is invalid\"}', 47731, NULL),
(1677, '2024-08-06 14:15:29', 'The JSON format is invalid', 47731, NULL),
(1678, '2024-08-06 14:17:20', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47732\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47732\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622553\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223,\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47732, NULL),
(1679, '2024-08-06 14:17:20', '{\"rError\":21,\"sMessage\":\"The JSON format is invalid\"}', 47732, NULL),
(1680, '2024-08-06 14:17:20', 'The JSON format is invalid', 47732, NULL),
(1681, '2024-08-06 14:17:53', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223,\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47733, NULL),
(1682, '2024-08-06 14:17:53', '{\"rError\":21,\"sMessage\":\"The JSON format is invalid\"}', 47733, NULL),
(1683, '2024-08-06 14:17:53', 'The JSON format is invalid', 47733, NULL),
(1684, '2024-08-06 14:38:14', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47733, NULL),
(1685, '2024-08-06 14:38:14', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47733, NULL),
(1686, '2024-08-06 14:46:06', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47733, NULL),
(1687, '2024-08-06 14:46:06', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47733, NULL),
(1688, '2024-08-06 15:07:58', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47733, NULL),
(1689, '2024-08-06 15:07:58', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47733, NULL),
(1690, '2024-08-06 15:09: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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"90140255\",\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    ', 47733, NULL),
(1691, '2024-08-06 15:09:09', '{\"rerror\":3344,\"smessage\":\"Taxxa - The seller document document \"90140255\" was not found in the DB.\"}', 47733, NULL),
(1692, '2024-08-06 15:10:04', '{\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\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\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    ', 47733, NULL),
(1693, '2024-08-06 15:10:04', '{\"rError\":1,\"sMessage\":\"Error:Bad document type: 01\"}', 47733, NULL),
(1694, '2024-08-06 15:10:04', 'Error:Bad document type: 01', 47733, NULL),
(1695, '2024-08-06 15:13:42', '{\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                \"wdocumenttypecode\": \"01\",\n                \"wdocumenttype\":\"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\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    ', 47733, NULL),
(1696, '2024-08-06 15:13:42', '{\"rError\":1,\"sMessage\":\"Error:Bad document type: 01\"}', 47733, NULL),
(1697, '2024-08-06 15:13:42', 'Error:Bad document type: 01', 47733, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1698, '2024-08-06 18:24:34', '{\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       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\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    ', 47733, NULL),
(1699, '2024-08-06 18:24:34', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739\",\"sqr\":\"SETP990000806 2024-08-06 18:24:36-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739\",\"ssignature\":\"XlSvV6QbVoDkFXBjBjh67MR/L0ej1S1D5Vpp/gSEQhr78EUZwMvGddLzbKr/oc/BwnQSBGBwnIOiroSDmgp71cDA7ZLHRcXk/7saFZrnWv6IMJXAsMsA8YOf+W6+/+EmmHWkTpYx+Ngdw19ALsay+s0wev9hlV8azEDXGfpjS4ciaeBA9zjqQO8AiOo2RuAkfQ3dTBx9aYHDyxu4U1gbv5ZOmyDTZ1svdLAyjphS6kapqkPoPql8bqP3cvNoVd/0zFWZIRky+mkusrw6RHyGQxDZ7UIs1g9uQ/1Di9X2AcY0NXw07CU06QVvOsbWyWVIuxRLASP7kL5u/xuyr7s7/g==\",\"sdocumentreference\":\"SETP990000806\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000806},\"sdebug\":\"Taxxa: 0.109s DIAN: 6.149s (creación 5.289s, revalidación 0s baja 0.86s)\"}', 47733, NULL),
(1700, '2024-08-06 18:25:08', '{\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       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\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\":\"ferrecostos@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: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\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    ', 47733, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1701, '2024-08-06 18:25:08', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739\",\"sqr\":\"SETP990000806 2024-08-06 18:25:10-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739\",\"ssignature\":\"hIxNuaLv8s4PAZQcc8WwYZJfWotrPCHKRpv0FY7eS9nndKwhqooOf5mMZC/CYjQy0AF5LPr/RJSu2e/dWRaDXWLWUn0FpaOkYfxB46fHg6mC4wyQD652/xnHiO3HokKC2kmPgyRxNi0eYtD1wzus03nTC+Xxaic9VAdbbMZlX7BsdQ/Dp40q49r9D38W3wpelet1fyDSy6PYdpdLjYgsz9DCWRSiDKBsoo3iS18cxwq33PKixK0kGQaDtrCnm3h+868g13n5ZhVgEJs81id1rbH+Kxtb/6fNqZvlId4OCgywW8xDkCbfgtKk3Wg7HIeojrR/4KiFLweK391jdm7iug==\",\"sdocumentreference\":\"SETP990000806\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000806},\"sdebug\":\"Taxxa: 0.078s DIAN: 6.048s (creación 4.475s, revalidación 0s baja 1.573s)\"}', 47733, NULL),
(1702, '2024-08-06 18:29:47', '{\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       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\n             \"wpaymentmethod\": \"10\",\n             \"wpaymentmeans\":1,\n             \"snotetop\":\"Cra 14  9-07\",\n                \"jbuyer\":{\n                   \"wlegalorganizationtype\":\"company\",\n                   \"stributaryidentificationkey\":\"01\",\n                   \"stributaryidentificationname\":\"IVA\",\n                   \"sfiscalresponsibilities\":\"O-15\",\n                   \"sfiscalregime\":\"48\",\n                   \"scustomername\":\"LABORATORIOS SOPHIA DE COLOMBIA LTDA \",\n                   \"jpartylegalentity\":{\n                      \"wdoctype\":\"NIT\",\n                      \"sdocno\":\"222222222222\"\n                   },\n                   \"jcontact\":{\n                      \"scontactperson\":\"CONSUMIDOR FINAL\",\n                      \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                      \"stelephone\":\"3176614919\",\n                      \"jregistrationaddress\":{\n                         \"scountrycode\":\"co\",\n                         \"wdepartmentcode\":\"11\",\n                         \"wtowncode\":\"11001\",\n                         \"scityname\":\"BOGOTA D.C\",\n                         \"saddressline1\":\"CL 98 9 A 41 ED AB PROYECTOS OF 507 \",\n                         \"szip\":\"110011\"\n                      }\n                   } \n                }, \n                \"snotes\":\" Id: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\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    ', 47733, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1703, '2024-08-06 18:29:47', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739\",\"sqr\":\"SETP990000806 2024-08-06 18:29:48-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739\",\"ssignature\":\"hh2mOJqJ0y5ua0ik3DpuXRE6ZtAYIqoMtb/le1yseYvsY+bMZMBd0B5TxaNHFUkvu9F2xn3LN8q9OtbEn+ZNsH6Ctx0qEmf+KW0jSkihkrb+n0Y3bEFZFBggCdfoh3ljwh1VywRZCR7QV4uE/RJHFckR4aczlBjb1dFzCVNhljK+0Fez+IzjfBf2AL1ixTP5Ty0kU0Li6vzI+wwxYEjBN3kJyvznQROk0REUtOWFsANPHYFvkaVfZY7wgKgkGMkJcrZmyBucRTyC34SE3n+JfLLkhtMRzTLhozmVhcHcIDAh/e1oh00dKkdKg5pNe+jcrAnByM+rtEecShnVQ6t2lg==\",\"sdocumentreference\":\"SETP990000806\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000806},\"sdebug\":\"Taxxa: 0.078s DIAN: 4.821s (creación 3.978s, revalidación 0s baja 0.844s)\"}', 47733, NULL),
(1704, '2024-08-06 18:39:36', '{\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       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47733\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 806,\n             \"wpaymentmethod\": \"10\",\n             \"wpaymentmeans\":1,\n             \"snotetop\":\"Cra 14  9-07\",\n                \"jbuyer\":{\n                   \"wlegalorganizationtype\":\"company\",\n                   \"stributaryidentificationkey\":\"01\",\n                   \"stributaryidentificationname\":\"IVA\",\n                   \"sfiscalresponsibilities\":\"O-15\",\n                   \"sfiscalregime\":\"48\",\n                   \"scustomername\":\"LABORATORIOS SOPHIA DE COLOMBIA LTDA \",\n                   \"jpartylegalentity\":{\n                      \"wdoctype\":\"NIT\",\n                      \"sdocno\":\"222222222222\"\n                   },\n                   \"jcontact\":{\n                      \"scontactperson\":\"CONSUMIDOR FINAL\",\n                      \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                      \"stelephone\":\"3176614919\",\n                      \"jregistrationaddress\":{\n                         \"scountrycode\":\"co\",\n                         \"wdepartmentcode\":\"11\",\n                         \"wtowncode\":\"11001\",\n                         \"scityname\":\"BOGOTA D.C\",\n                         \"saddressline1\":\"CL 98 9 A 41 ED AB PROYECTOS OF 507 \",\n                         \"szip\":\"110011\"\n                      }\n                   } \n                }, \n                \"snotes\":\" Id: 47733\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":7222.222222222223,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":577.777777777,\n                            \"nbaseamount\":7222.222222222223\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    ', 47733, NULL);
