INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1705, '2024-08-06 18:39:36', '{\"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:39:37-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\":\"qHNHK1kBCt+hmPGeJYL4/u2BZPfhR/iklNds7xwciOCgR8E7aA5Ll1rhliZ7nwyR6vNar+ENt7ECbe3PFLcX3rmUBH4T1otWarx1fFxYIY2Oqrwz97Cm5dUdmrJFq/OsSWIzSQcP02MEuGAAz1BjP/qVRGEpQh6ffomK9Yx/pAMWhXmGO75SYrLDi45PrSRdf2iCY+8J/lvqqp0vgHRgrsvFmRc/6B0PTaFz4ubvp7H3YjeQrKBzNdU9Ghj+ZQeEEF0+v8Gh0U7lIJHO/9rn/vjl0YRJVteYsG5KCPa1OPydvIa0Oq/uXPOvi27eFmhV8WvxTjB0nZJ5h2KYBgEaCA==\",\"sdocumentreference\":\"SETP990000806\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000806},\"sdebug\":\"Taxxa: 0.073s DIAN: 5.482s (creación 5.082s, revalidación 0s baja 0.4s)\"}', 47733, NULL),
(1706, '2024-08-06 18:46: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\": \"Invoice\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47734\",\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\":\"raulotalvaro@gmail.com\",\n                      \"stelephone\":\"\",\n                      \"jregistrationaddress\":{\n                         \"scountrycode\":\"co\",\n                         \"wdepartmentcode\":\"66\",\n                         \"wtowncode\":\"66001\",\n                         \"scityname\":\"PEREIRA\",\n                         \"saddressline1\":\"Cra 14  9-07\",\n                         \"szip\":\"660001\"\n                      }\n                   } \n                }, \n                \"snotes\":\" Id: 47734\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"00622555\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7223.1481481481,\n                   \"nusertotal\":86677.77777777777,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":6934.222222222223,\n                            \"nbaseamount\":86677.77777777777\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    ', 47734, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1707, '2024-08-06 18:46:07', '{\"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:46:09-05:00 901402281 222222222222 86677.78 6934.22 0.00 93612.00 11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=11efac44f7f3ae80e85b0b4744e315f5fd2aa2564f3b7ccc106a8299bd419fe0d2eeaa885a37139998c2063d86f52739\",\"ssignature\":\"PG/FiYMPgoqL/W074sSjnB4M4yjMygSTx+yBm3b3MvKp1Bv6zJGCOYR0xMG3FV/5hwIwpLOxfhU4A8aHQ3CFTTtrvJwOs5RuC66pfkkabniL7j99i6Ir8SDRVz7ro5kpt56A7EkjD1GWewwkoyrPVNgpf2Fjw0LCyt6V2ENMKTvJL9lrzAgJ3nm78965yL0h8xlAiSQcSjuQ4bPKQ6WG9I2mti3KN4/HB7/d9uzo7p8xLVMZpQiMzs95GUKakWYhOE36acyaAl9Qh21flXCt5xR/s8qtWmfdQXU/GMNBMLnq1SHN9cCDnNbkbVkb4AFdUtrHWw3FxfG7CUr0NwuQpQ==\",\"sdocumentreference\":\"SETP990000806\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000806},\"sdebug\":\"Taxxa: 0.063s DIAN: 5.344s (creación 4.984s, revalidación 0s baja 0.359s)\"}', 47734, NULL),
(1708, '2024-08-06 18:55:05', '{\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\": 807,\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
(1709, '2024-08-06 18:55:05', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAV08a, Rechazo: Atributo no puede estar vacío\",\"1\":\"Regla: FAK58, Notificación: Estructura código no valida\",\"2\":\"Regla: FBA06, Notificación: No informado el literal “195”\",\"3\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"5\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"N\",\"scufe\":\"\",\"sqr\":\"SETP990000807 2024-08-06 18:55:06-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 f35d6657f6149e780de85a4d09ff125e2ad57ae7304bf47645cad127fd68ba48dd23eb1d546a70434ad5e084858a0253 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=f35d6657f6149e780de85a4d09ff125e2ad57ae7304bf47645cad127fd68ba48dd23eb1d546a70434ad5e084858a0253\",\"ssignature\":\"OY9V/bFxE0ioy7nJ261VA/RjSVTb18KxLLsElajHvbLluEyHdZ8GgllmIOdHuStp3OgUYzlw0qNgkp+P0ZIVdY9ZFxnPH/RwqS6jd/07fZ/al6caaJZszafGlqgAsPxumnNOkRFZ7VykrPDjtO0+m0Gg4UdfuCf4627B8P7xhNthXxqP3wwyYLseK9ZpAjnCGCOgn5+nf6PcxTHuBM4H+tSyhWHZKLSCtfVR0j5S5/Ghw41tz9GdIlvNQWSen4CC1hNSpLBewa3iRPfc5Arp3Fe7fZK6aFK14uL69Pnhe0oE4NsNgjRhpAnqi+/VVJcJl0Huurve8piz76aSqvVgHw==\",\"sdocumentreference\":\"SETP990000807\",\"rtaxxadocument\":\"92484286\",\"sref\":\"92484286\",\"irefindex\":990000807},\"sdebug\":\"Taxxa: 0.141s DIAN: 4.407s (creación 3.517s, revalidación 0.406s baja 0.484s)\"}', 47733, NULL),
(1710, '2024-08-06 18:59:26', '{\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\": 808,\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
(1711, '2024-08-06 18:59:26', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e\",\"sqr\":\"SETP990000808 2024-08-06 18:59:27-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e\",\"ssignature\":\"OUNcCdMhuIq6G/KcZdoII37hp6V8v0oG+Ky5yvYA8h+j7bJW57e40z5t6/r3LHMl38ng2I1AG2qWv4lTfhV05KiuxUoQgAptv4UPQxWQGINvHiQ0TJ+W/eYc8D/s+ENdsClLQOcKl/a4OlGvysSN5kANL1dhItaV1dPQ+Ohz5VInLzT+amzQcPxnm9KL3Xv7cuZsWBtsJb912whogk5eGfUi16uB6Fv2PiqLGpaC79RbUgGiVGXp+qANJNajdd322UggSgrXt60x5x+dLbQYx8aix+ZmgpRW46XLTPvcCaazyPgxFV6q2W4JNK7qK0MuVa3BcHYgZeXp3161gtdX/A==\",\"sdocumentreference\":\"SETP990000808\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000808},\"sdebug\":\"Taxxa: 0.094s DIAN: 5.116s (creación 4.851s, revalidación 0s baja 0.266s)\"}', 47733, NULL),
(1712, '2024-08-06 19:00:05', '{\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\": 808,\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
(1713, '2024-08-06 19:00:05', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e\",\"sqr\":\"SETP990000808 2024-08-06 19:00:06-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e\",\"ssignature\":\"Iy8UIgBj7s7u16X69qKH3tLa+WoI76VK6ruHIMS/1IJ43iODE0LBJsQsmYchFw3rE+dpvOqilX5tXhp2hPXST9mtRCOM9IUJbieRA7a2VICiRrtlldjyH/2hzYX1qgXTiJJTX4u/d1HXSXa1sEE2sn/h6Dd+yz8/yoKe1ngHOYPGWdh3ZasadmtYpNZFIY9K/LaQEy5MMjwFITFXYQ/wU8/dFBEY/HusdoaF50ZfPCGofGz7T1QEXLqyrUmF/dzOlEHSRGcuEyZtz6WFaICD9+LLsQKgnj3USAmupvwNJSbHhoIrVP6H8pMu8GYihb9SAQqa5anNNQ1XeN/PjKzUlg==\",\"sdocumentreference\":\"SETP990000808\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000808},\"sdebug\":\"Taxxa: 0.078s DIAN: 4.829s (creación 4.688s, revalidación 0s baja 0.141s)\"}', 47733, NULL),
(1714, '2024-08-06 19:00:21', '{\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\": 808,\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
(1715, '2024-08-06 19:00:21', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e\",\"sqr\":\"SETP990000808 2024-08-06 19:00:22-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=8cbe4b1da40891eb53a19aff20630b8a43f09e21e14e51324eac3889104bde270feda33403e7a865422d4497de37bf4e\",\"ssignature\":\"cxmXANtZK8S8m7k9WJbvSwJNuIMO9waHVaaAUQEugP4MXni9fm8C3LqwBrrDOMy78EMDXZ8RTHJeGd689G2D6LpNJ3jG7XtQ+lAMcmBlbI4ol6LJVZzuraA8P0iMvyY7NlYWvFKIhkCSOx1+/LMDqcQ4wIZE7LfupsJ1QXucDoZ2DSCccxr7kDUyBCIK0HBSpc8aX8gGYbyRdS4O86LC5YLicINOR1XrTERQWMicVjDfn0+D3qhAynTp7xIZXAN9mzumDV+2tQBKsEGf7b2tf521fqSIzuSlUxbPtC8BhMIXH7uTwcfaYSonvTjqCkp49/0hlNiUH+BSS+xIt8Q1nw==\",\"sdocumentreference\":\"SETP990000808\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000808},\"sdebug\":\"Taxxa: 0.078s DIAN: 4.699s (creación 4.371s, revalidación 0s baja 0.328s)\"}', 47733, NULL),
(1716, '2024-08-06 19:02: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\": 810,\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
(1717, '2024-08-06 19:02:34', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"45fda4df3fb0b792f64b5640c4734fdf8955340071df895175977f211f0d2bcd178a8e530d5a74bdbb7fd7a4f5716735\",\"sqr\":\"SETP990000810 2024-08-06 19:02:35-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 45fda4df3fb0b792f64b5640c4734fdf8955340071df895175977f211f0d2bcd178a8e530d5a74bdbb7fd7a4f5716735 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=45fda4df3fb0b792f64b5640c4734fdf8955340071df895175977f211f0d2bcd178a8e530d5a74bdbb7fd7a4f5716735\",\"ssignature\":\"J3ze8N6VCk4bNZDY1u4CB4+D5lbZdLMXuby5/d5GuOGZTJe09OIHz3AH342tJhadRu0CgRUJ2yqTbYRY2xU4eYzjF3RCIoD1nNNVvyxN0qvhKLtS5KJMoTCzGKc7iUBoDsUsChZSsj1AjRYXVeOtoAsyEsQ/l1toB8Gpgjstpak3io1z0Z9YBm1WhBk1+/pWXbvIvxkQJ6ywas4wtkXS7/EGtXf18C+aAmETqxpeEwpUC/19ccYBgCGuT+WZo8rMUNru9h2FTVAvXDqZtVyl2DOTF3C1o0MZlB6NqeFOESmkluBOtI9L64nK9QjIvPlgFHvVHQj7zHOHCGnq5+xhTQ==\",\"sdocumentreference\":\"SETP990000810\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000810},\"sdebug\":\"Taxxa: 0.078s DIAN: 5.962s (creación 5.524s, revalidación 0s baja 0.438s)\"}', 47733, NULL),
(1718, '2024-08-06 19:03:22', '{\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\": 811,\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
(1719, '2024-08-06 19:03:22', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"ac1bfd891817a395999515954fc0d052c353841df86847c77d34d699e2a85e4e8cbb51a1f96c74c6dbb018414ba05bba\",\"sqr\":\"SETP990000811 2024-08-06 19:03:23-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 ac1bfd891817a395999515954fc0d052c353841df86847c77d34d699e2a85e4e8cbb51a1f96c74c6dbb018414ba05bba https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=ac1bfd891817a395999515954fc0d052c353841df86847c77d34d699e2a85e4e8cbb51a1f96c74c6dbb018414ba05bba\",\"ssignature\":\"NZFxKV+zKNeCFqgaoKe/tiHoHOmKPi/e/8YccSjSryqb1snGNN2BuMWNowLxSx5dw8hm7DYtXshPua3fvb0TXDHAD8kCZWQvDzuXjQA39vFt2hGK8QHJFptMjkFnaJa0zuFnYfZZ9JCRgSwuZqduh6uZLHYI6hbh1q49DzohwVGmxYtWXQS3UmrhlwFV46f1DsoY6npifkeqPHCBD/TKwVpFHvGih9pCotN0BS1FidAjM5ef4Cya45ADXV5CEzURKm6AixkXHfqhbbvAN6a9U1932J8vSuk69pgTC3xHikYHJbsFO/4lqfX75EQOZGSkHm+3+/+lwbE/VoLxW1IcHQ==\",\"sdocumentreference\":\"SETP990000811\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000811},\"sdebug\":\"Taxxa: 0.094s DIAN: 4.772s (creación 4.188s, revalidación 0s baja 0.584s)\"}', 47733, NULL),
(1720, '2024-08-06 19:04:15', '{\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\": 809,\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
(1721, '2024-08-06 19:04:15', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"5df764e1994eaa865e91d3390dd274019ab53d677c27d0abb9ece345ed46d066022bcbc8f651fc2876074c84ca72ccb6\",\"sqr\":\"SETP990000809 2024-08-06 19:04:18-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 5df764e1994eaa865e91d3390dd274019ab53d677c27d0abb9ece345ed46d066022bcbc8f651fc2876074c84ca72ccb6 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5df764e1994eaa865e91d3390dd274019ab53d677c27d0abb9ece345ed46d066022bcbc8f651fc2876074c84ca72ccb6\",\"ssignature\":\"ZolvtaTiDj7YumacOJepT8bhzFhG8RjU9Bm7SfEjf6NvMcTsZcqI1JG4qeRVn5Ud+0xBAGrhRHW413HLWgdLrC8BWBOFQSU0KAlFC5u5QSuUjBUHYCYkjy/Ql7Id5Jhhfm8V7mWbXXO5Ob3wYobvldRq0A3FO2qveldpEy9jPXi/BeGyH0FpH40r3yl4SBXylm22A9sj2MRYLc+UnoMWXYNptW8hwhRhGEUqrDNI+Jpdg0yJCJSnLIqwC0X+N6NcBo7izDx3gFJfOx1/WF4wAcj4LJm4A6JgjGPjl6YYt1X3FKu3OVH4HWYReer24tCoCkt70LKgx4L7KfXRF42Y+Q==\",\"sdocumentreference\":\"SETP990000809\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990000809},\"sdebug\":\"Taxxa: 0.141s DIAN: 5.188s (creación 4.5s, revalidación 0s baja 0.688s)\"}', 47733, NULL),
(1722, '2024-08-06 19:30:40', '{\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\": 829,\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
(1723, '2024-08-06 19:30:40', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAV08a, Rechazo: Atributo no puede estar vacío\",\"1\":\"Regla: FAK58, Notificación: Estructura código no valida\",\"2\":\"Regla: FBA06, Notificación: No informado el literal “195”\",\"3\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"5\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"N\",\"scufe\":\"\",\"sqr\":\"SETP990000829 2024-08-06 19:30:41-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 21f4502e12308267c8cba092670b57a40480516b5e4fa0ec62423bf4c08d9a1c6a40853afe4bd9f1e9c097a635ff5e49 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=21f4502e12308267c8cba092670b57a40480516b5e4fa0ec62423bf4c08d9a1c6a40853afe4bd9f1e9c097a635ff5e49\",\"ssignature\":\"jgHzwzhNETXrJzGnr6l/pdinVzqkx5CfaFChhBAYjmrXT2LK9XesMZ0LE8UI6mE/kubEGlR5NrqO7WzMHQSFb5YPos6fJ7+wB/pvEkvkVi+DjqtmzkfpTbYPrp7PygREelldb8HGD4WmZqS4dydlpDhX5QVRkUQgsdB55svLyKIBqhV/sEAJC7O25S7LjfFE9Swhoe5chL4zyn8CCWCrpNIGIh+/dm71+f668t18r22xkRMRxE0ffLcLltrO83lfd3Wr13AXD4k0dAlPs8Dghr5Mi2wzeMGXUzmFSeUehIJr3/j/tTs3sKn7KGA/o7rUBGzsrT89n6n+w1rT6dblYg==\",\"sdocumentreference\":\"SETP990000829\",\"rtaxxadocument\":\"96759886\",\"sref\":\"96759886\",\"irefindex\":990000829},\"sdebug\":\"Taxxa: 0.125s DIAN: 6.235s (creación 5.078s, revalidación 0.626s baja 0.531s)\"}', 47733, NULL),
(1724, '2024-08-06 19:32:11', '{\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\": 839,\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
(1725, '2024-08-06 19:32:11', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAV08a, Rechazo: Atributo no puede estar vacío\",\"1\":\"Regla: FAK58, Notificación: Estructura código no valida\",\"2\":\"Regla: FBA06, Notificación: No informado el literal “195”\",\"3\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"5\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"N\",\"scufe\":\"\",\"sqr\":\"SETP990000839 2024-08-06 19:32:12-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 7a5ecbbe1fab4d4ff865c10ba8b2453c892d92dc6430763dd4e8fba8a695d20c4e01a81e253818e49f82ed9812e2393b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=7a5ecbbe1fab4d4ff865c10ba8b2453c892d92dc6430763dd4e8fba8a695d20c4e01a81e253818e49f82ed9812e2393b\",\"ssignature\":\"tMdK9WV2DaMAHW+j9SiuPIUhfSRJjioY8Jpz6CyXqPyp++r0WkKGD/UZfxwZ6tTOoXSb+cfYIakAqz0HDLfF6hG72AnFFgM8ybCNWp8Y4NyGh8nDYnh5h4A2x7lEdr95XgnjzIkHP3xPLGcBHzu0SmdRKsVvhgnZF41ZYEbH9xDZSYwuhBBXednRDo/OtjME2FlCEcjDvOl7fndgSVVMLWPeEAySdZWIUxiVKctkFT5UGBhpJK41tO5rNBSRWvF1N33O0mJas3d9ztWqo/eXzOHvENgA95jKJ2j+LgxwQev/CUZ6uAI3aT232pqehihLIyrUkvcckx1H9/MihHxOLA==\",\"sdocumentreference\":\"SETP990000839\",\"rtaxxadocument\":\"96760468\",\"sref\":\"96760468\",\"irefindex\":990000839},\"sdebug\":\"Taxxa: 0.141s DIAN: 7.735s (creación 6.517s, revalidación 0.672s baja 0.547s)\"}', 47733, NULL),
(1726, '2024-08-06 19:35:04', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2,\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\": 839,\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);
