INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1727, '2024-08-06 19:35:04', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAV08a, Rechazo: Atributo no puede estar vacío\",\"1\":\"Regla: FBA06, Notificación: No informado el literal “195”\",\"2\":\"Regla: FAK58, Notificación: Estructura código no valida\",\"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:35:05-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 0ff64ce287f16e336eafea00e3bee54b5e6d12d97941c9f4a4d26d0a951ad9c3c36fcbe43614b5cd40f236b48ba2b29b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=0ff64ce287f16e336eafea00e3bee54b5e6d12d97941c9f4a4d26d0a951ad9c3c36fcbe43614b5cd40f236b48ba2b29b\",\"ssignature\":\"FXmG2di0sA8USAFQobF2Q7t4b8AjHSewsdQBqLVbgKpVXUPxOIU2I079SxiwuHlUU+PFwJ23kqMlgHeeLdFy91Xgx95JLOQkCdBL8ntY+79Xlw5rVtkU3dcU6segrR4BaO5ItdIO+L0j7IcdYH9mT8T8bzWxlpuzKBCbBO66yMjj7efcQIGyzkFNypsu0arMRHsx25uV9IbokeiPQtkwhlG4/XuhY1YJqLiOjBNxcnxHxhf240c0usLB+PCT++VKFCXEVyfxyl0IHwnXrxltQugDaNzkIC4k1HvJ9aoHwDx/zW+2a/Dk/2TvJRsfGS32iD0W2ESJzJVQ+GsclCX2PQ==\",\"sdocumentreference\":\"SETP990000839\",\"rtaxxadocument\":\"96760468\",\"sref\":\"96760468\",\"irefindex\":990000839},\"sdebug\":\"Taxxa: 0.125s DIAN: 7.142s (creación 6.11s, revalidación 0.703s baja 0.328s)\"}', 47733, NULL),
(1728, '2024-08-06 19:37: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                \"wdocumenttypecode\": \"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\": 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
(1729, '2024-08-06 19:37: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:37:13-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 74a2383559ca1c2eed1a093294ff57819d9cac4a93e2a6216fea1818626451fb61872e9570a16a00583e9697da8d6909 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=74a2383559ca1c2eed1a093294ff57819d9cac4a93e2a6216fea1818626451fb61872e9570a16a00583e9697da8d6909\",\"ssignature\":\"Z/UzWBQ7FchfvVevoIMspdbeFVlvDgLFaRU0Wq4eYiAwkV/Bx2YKMF1+I2tKq86p8IyNgdcqoOfWoJtnp/3PfWyts5MW86bzHvmf6pIyVvOX4opzzk6JQ6RFCXEe6ASJ2ug9UglJPLzeqaq5V9962Q/na5Pb9Po3ZcY/a5q9s9xDJZ9NOEcb0e0nYnRgbPNowC2YGlG6Q8ZCByjqDLVJd9gS2+wE53dmIQbi4SDOZJKFefZfjeMzGa1BfIDsY/GRiAX86rH345Yen60mzgBFyE76lHFKELWoi9uj7TZgyK6A9LhrxG43vjjX/hMK0VchZA+5AaBSE3b4GEeh+Apl6Q==\",\"sdocumentreference\":\"SETP990000839\",\"rtaxxadocument\":\"96760468\",\"sref\":\"96760468\",\"irefindex\":990000839},\"sdebug\":\"Taxxa: 0.099s DIAN: 7.111s (creación 6.174s, revalidación 0.422s baja 0.516s)\"}', 47733, NULL),
(1730, '2024-08-06 19:46:12', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"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\":\"1_622554\",\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
(1731, '2024-08-06 19:46:12', '{\"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:46:13-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 2d804bc5edbdc2017217f327f1053d71764ebaf5a7788dd9d642edc3c3060f16877c19f173604134fa08ace64a061282 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=2d804bc5edbdc2017217f327f1053d71764ebaf5a7788dd9d642edc3c3060f16877c19f173604134fa08ace64a061282\",\"ssignature\":\"eZMYiHdOIwqjAHGaoA3Dqd1P80EI3eq5qQbQ6MvxcDw5MWrbFm8u3/mgSIGWqI5YV1JzdQR6/dcUKbr1wmKodhKoGQKW0LZgWyylaRxxiQlFZswFOjetpZVO1gc3VK5HU3lz2iuxVi6jqJ9TVJTUgE1aS/cRcJ3FlNjewtXezZWbPX2Q/sPsNvsj7a1DdBojCPVgl74rzetTiPn6bcTPmPHzzaFDRC8WTZCFkPvGjOEKfkckrJhXVVJwEMbp6F281LM+/Mm78k9bwrFqU+CvFPPDKVYroZU7wKx64Xyekz2qWQ8PNX3fAGCUX+QJmWAMGCMSEYdp/efj0pJRo2AhLA==\",\"sdocumentreference\":\"SETP990000839\",\"rtaxxadocument\":\"96760468\",\"sref\":\"96760468\",\"irefindex\":990000839},\"sdebug\":\"Taxxa: 0.107s DIAN: 6.855s (creación 5.835s, revalidación 0.594s baja 0.426s)\"}', 47733, NULL),
(1732, '2024-08-06 19:50:35', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"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\":\"1_622554\",\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
(1733, '2024-08-06 19:50:35', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAV08a, Rechazo: Atributo no puede estar vacío\",\"1\":\"Regla: FBA06, Notificación: No informado el literal “195”\",\"2\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"3\":\"Regla: FAK58, Notificación: Estructura código no valida\",\"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:50:36-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 1bf7112fd37fa45c60ef06fd428e73ea7a9023c04cd65bf9412082daa58000d59740af98706d16736feb79ad10f20728 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1bf7112fd37fa45c60ef06fd428e73ea7a9023c04cd65bf9412082daa58000d59740af98706d16736feb79ad10f20728\",\"ssignature\":\"TVQjjQ9sQUYDKRDTuxpAAp4QeasWTom7w4VJ/lfm1yQbmN30K9Y5bsYzqKivx9JWoby+9kj1tFBZ8fKay9FaY2Bb1vuYV7VHzflXN5zRb53w/43GsYUYcBOGTmaxiiqubYD8hfexfho8UqCgWeTU9S1VlaO8brYF+vjTBZ7YgpnhLb6bUOEDSvMPf45En8fTUXOtM1bItEc+MncysX3uae0GQOTqIJXr5ojxwrIrSjjNEGeP6P8A3gVfd9gYQX8qY84PjrA+AkLEZQP1GFEGcl0rVp+3vyS2MrQzMsG41SWU4qNC0VUQC/E92PRpc328ESgBTSTYDqtODJDK/ZbyKg==\",\"sdocumentreference\":\"SETP990000839\",\"rtaxxadocument\":\"96760468\",\"sref\":\"96760468\",\"irefindex\":990000839},\"sdebug\":\"Taxxa: 0.115s DIAN: 6.944s (creación 5.682s, revalidación 0.825s baja 0.438s)\"}', 47733, NULL),
(1734, '2024-08-06 19:58:43', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"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\":\"1_622554\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\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
(1735, '2024-08-06 19:58:43', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAK58, Notificación: Estructura código no valida\",\"1\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"2\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"3\":\"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\":\"e3ef2620147b55b4bfc9416a32a2ec81c4c3c6e713bf47fa209ccaf369246e6048127e8b335aaf8dcec519e17fc0b913\",\"sqr\":\"SETP990000839 2024-08-06 19:58:46-05:00 901402281 222222222222 7222.22 577.78 0.00 7800.00 e3ef2620147b55b4bfc9416a32a2ec81c4c3c6e713bf47fa209ccaf369246e6048127e8b335aaf8dcec519e17fc0b913 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=e3ef2620147b55b4bfc9416a32a2ec81c4c3c6e713bf47fa209ccaf369246e6048127e8b335aaf8dcec519e17fc0b913\",\"ssignature\":\"mGMsq3gWanhkpdr1YMBkHBwRex+W9w+3b1OL9cfrPBBO3HhcEMGk7aACdfYnXgTd0BOaEprd8PgThV841rIU2IkVjaxwQiyXeFRy6hIXW0Gr5NqCV0G1+7ldR0j4C/Ex9IJGwQouvBSNIepvpvssAbR8BhQdql3LotIUlbUmKrgnl9a1yYCszXjEGcuB04LU6yduwn544sz2tTZUpTM0SSLrilhFPdzBeCVW47FwkFRuChCR36ATin/vqoRgumP1NYlR7gWlYRu5D93ZfGWdR22Ya5pUdJhipCKYY/lNj1lZNRlBiBC8mSvJrgcvBJccbn9qcqbDcS1ZCvSQVFGAgA==\",\"sdocumentreference\":\"SETP990000839\",\"rtaxxadocument\":\"96760468\",\"sref\":\"96760468\",\"irefindex\":990000839},\"sdebug\":\"Taxxa: 0.15s DIAN: 6.826s (creación 5.438s, revalidación 0.745s baja 0.644s)\"}', 47733, NULL),
(1736, '2024-08-06 20:03: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                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47735\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 840,\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: 47735\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622556\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":28888.888888888887,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":2311.1111111111113,\n                            \"nbaseamount\":28888.888888888887\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622557\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5555.5555555556,\n                   \"nusertotal\":22222.22222222222,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1777.7777777777778,\n                            \"nbaseamount\":22222.22222222222\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    ', 47735, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1737, '2024-08-06 20:03: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\":\"d4282018d09e41a58ef06b47309a605c66bde27b289523bddceb984f492503d145bf15176b49122ad8ecc39ff72faf49\",\"sqr\":\"SETP990000840 2024-08-06 20:03:28-05:00 901402281 222222222222 51111.11 4088.89 0.00 55200.00 d4282018d09e41a58ef06b47309a605c66bde27b289523bddceb984f492503d145bf15176b49122ad8ecc39ff72faf49 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d4282018d09e41a58ef06b47309a605c66bde27b289523bddceb984f492503d145bf15176b49122ad8ecc39ff72faf49\",\"ssignature\":\"eD66+SsmEgPkA/SjgCSPoJ7TbqlCw4zRwWUAwaObpFYTqMUiSvG6vvW7KAXHJ5K8QYm4tEJWciGMrysEEyKZcHw1Q3ErYURmT9YndxKg/t2AFFXXrBSADD+KgYNGMUtW+gpNUlvPNkFa5yOfd1XKs3Vcb1ciNTbgqPU7bekO/glJD+CYpypDtLxLx8+ahyh0V6tBzQ1kONW71c0DKThUhAfghWEK1esHQ7HCjczK7OjQl/AInc4sDGb/lxju4Sa6VNupHuert6RNBb9mmv/fnNx3GrV4WwWeHZ8bv7LyPC0NnqhZOVcaHBjHBFpW+K35cNyzWjmuXXZQDb+QnoXIyw==\",\"sdocumentreference\":\"SETP990000840\",\"rtaxxadocument\":\"96773102\",\"sref\":\"96773102\",\"irefindex\":990000840},\"sdebug\":\"Taxxa: 0.141s DIAN: 8.973s (creación 7.094s, revalidación 1.165s baja 0.714s)\"}', 47735, NULL),
(1738, '2024-08-06 20:11:49', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"1164878\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47735\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 841,\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: 47735\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622556\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":28888.888888888887,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":2311.1111111111113,\n                            \"nbaseamount\":28888.888888888887\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622557\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5555.5555555556,\n                   \"nusertotal\":22222.22222222222,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1777.7777777777778,\n                            \"nbaseamount\":22222.22222222222\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    ', 47735, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1739, '2024-08-06 20:11:49', '{\"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\":\"18546e210a027d49beeee9a16855447a18afcb7016cb8e264b73eee1c3ac5278114d291a4647b91b4d044c73d949515b\",\"sqr\":\"SETP990000841 2024-08-06 20:11:50-05:00 901402281 222222222222 51111.11 4088.89 0.00 55200.00 18546e210a027d49beeee9a16855447a18afcb7016cb8e264b73eee1c3ac5278114d291a4647b91b4d044c73d949515b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=18546e210a027d49beeee9a16855447a18afcb7016cb8e264b73eee1c3ac5278114d291a4647b91b4d044c73d949515b\",\"ssignature\":\"hsjDBeSfOsocERnzaCRjkRJscssGEeyxLGxjrI6vNzw/XIL4aoCZMZ/zGDui8bRcjLYZPnJZaAmSvL1ucfrvA4bH3Rpl8s4j3v1umlUGL+ShwqBdMDCdK6by7yQU5wZhZ6qvxlmlD6SSeaQ0WRh/d5lJahf8wQaP5f3cfB/La0PKEVFzdHfiAWdHfzcpAfIc1X5DtM91CcfbymNY7GKKokbjw3JfVTRPKkPxZqxE7onbMXOqynoFkw9qYPr4INZQRxdRrYMymdbPZRR3TUtLpO87uKIjZZWlj2KgptOvOM0w3d0b7fm9tYotltwErvgddk3cCgzEzWVRhh+F+gSM5Q==\",\"sdocumentreference\":\"SETP990000841\",\"rtaxxadocument\":\"96776069\",\"sref\":\"96776069\",\"irefindex\":990000841},\"sdebug\":\"Taxxa: 0.168s DIAN: 8.689s (creación 6.247s, revalidación 0.57s baja 1.871s)\"}', 47735, NULL),
(1740, '2024-08-06 20:12:49', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47735\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 842,\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: 47735\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622556\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":7222.2222222222,\n                   \"nusertotal\":28888.888888888887,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":2311.1111111111113,\n                            \"nbaseamount\":28888.888888888887\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622557\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5555.5555555556,\n                   \"nusertotal\":22222.22222222222,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":8,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1777.7777777777778,\n                            \"nbaseamount\":22222.22222222222\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    ', 47735, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1741, '2024-08-06 20:12:49', '{\"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\":\"f6ae0ef11dd7a9a616586d11cb60642a9474eb92d2386080e7df280445816200b1b29b67d90426ae6c00b66cc9f2a082\",\"sqr\":\"SETP990000842 2024-08-06 20:12:51-05:00 901402281 222222222222 51111.11 4088.89 0.00 55200.00 f6ae0ef11dd7a9a616586d11cb60642a9474eb92d2386080e7df280445816200b1b29b67d90426ae6c00b66cc9f2a082 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=f6ae0ef11dd7a9a616586d11cb60642a9474eb92d2386080e7df280445816200b1b29b67d90426ae6c00b66cc9f2a082\",\"ssignature\":\"h2WgN+vseEW8mQgjtMyVambQirm5O9o2Kr9tEZiUxhYaF+SMbQzw+pJ2kYH4YoHzN8+P2g0cZ42M/135GzlGbyAM+pdUqJ3/ZNgxYhTGWNJA0iuUM/yQr7QaXL56bsY7pqAKg8j8VZXSJpjp0cmOcL7chYclv+fCj+0+CwtHq3ArtVN2r3V7UQhfWxScfVAXZXltsy9UUVG449DUuR3lhm3rNtHSmSyl/DNLLs/WvOjJhPD3RMAIotozmDlE4f5Jhq8lQwPoP9MaRtfjx/ZCm5URPOlOnk0xYF7uhAb/86BTD1K2aJOAeLjD2HxcJ20vf6PhGB4AxQ18wHHo1A5xZQ==\",\"sdocumentreference\":\"SETP990000842\",\"rtaxxadocument\":\"96776432\",\"sref\":\"96776432\",\"irefindex\":990000842},\"sdebug\":\"Taxxa: 0.094s DIAN: 7.602s (creación 5.931s, revalidación 0.799s baja 0.872s)\"}', 47735, NULL),
(1742, '2024-08-06 20:15:55', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"4477128\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47736\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 843,\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: 47736\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622559\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":6554.6218487395,\n                   \"nusertotal\":6554.621848739496,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1245.3781512605042,\n                            \"nbaseamount\":6554.621848739496\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622560\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5042.0168067227,\n                   \"nusertotal\":5042.016806722689,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":957.983193277,\n                            \"nbaseamount\":5042.016806722689\n                        }\n                   }\n                },\"3\":{\n                   \"sStandardItemIdentification\":\"3_622561\",\n                   \"sdescription\":\"MANGO EN AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":4201.6806722689,\n                   \"nusertotal\":4201.680672268908,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":798.3193277310925,\n                            \"nbaseamount\":4201.680672268908\n                        }\n                   }\n                },\"4\":{\n                   \"sStandardItemIdentification\":\"4_622562\",\n                   \"sdescription\":\"PORCION DE AGUACATE\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":2605.0420168067,\n                   \"nusertotal\":2605.0420168067226,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":494.957983193,\n                            \"nbaseamount\":2605.0420168067226\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"901402281\",\n                     \"sdoctype\":\"NIT\",\n                     \"ssellername\":\"FERRE COSTOS LA 14\",\n                     \"jcontact\":{\n                         \"scontactperson\":\"JUAN ALARCON\",\n                         \"selectronicmail\":\"ferrecostos@gmail.com\",\n                         \"stelephone\":\"\",\n                         \"jregistrationaddress\":{\n                            \"wdepartmentcode\":\"66\",\n                            \"sdepartmentname\":\"RISARALDA\",\n                            \"wtowncode\":\"66001\",\n                            \"scityname\":\"PEREIRA\",\n                            \"saddressline1\":\"Cra 14  9-07\",\n                            \"scountrycode\":\"CO\",\n                            \"szip\":\"660001\",\n                            \"wprovincecode\":\"66001\"\n                         }\n                     }\n                 }\n          }\n       }\n    }\n    }\n    ', 47736, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1743, '2024-08-06 20:15:55', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"0b440e3976693b41e4a352b1492e31a061aaef61b6c9b6efcb518c985a2f58f7d3752cd9ceb68c53b60a95b526214e9f\",\"sqr\":\"SETP990000843 2024-08-06 20:15:57-05:00 901402281 222222222222 18403.36 3496.64 0.00 21900.00 0b440e3976693b41e4a352b1492e31a061aaef61b6c9b6efcb518c985a2f58f7d3752cd9ceb68c53b60a95b526214e9f https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=0b440e3976693b41e4a352b1492e31a061aaef61b6c9b6efcb518c985a2f58f7d3752cd9ceb68c53b60a95b526214e9f\",\"ssignature\":\"TxmFNDwz8LgsmkDnyAsRfZ6EU8btoLvXcyS9FgNNjdt29U9sigcymxufzzZ6mE4vbWPGYUrq1BU10oA4zJugPXNlGZUgZ+DI8BF2c10ZvlNSFBApxGx3RWXPjd0vTUw6YG6pkItUhrPVrRor+E0WWW1dPLROzopLIQhj6h2ptJaw8bTrigkpPfHqjvOJjsWoi/w8XxJHcjHK33EcaTvSZePKRMcuPrFxLAAEd7TZkx3Yj/7ST/lvLk0B5oMS987uZjWs8f0CFQNvCkHEi6t4yG63DhXNl+cZWgrEkDWQioVbfDD1YMRpywXALEy5ULnzntSnH3Rz/q+OUJch1HpZxw==\",\"sdocumentreference\":\"SETP990000843\",\"rtaxxadocument\":\"96777638\",\"sref\":\"96777638\",\"irefindex\":990000843},\"sdebug\":\"Taxxa: 0.154s DIAN: 10.463s (creación 8.016s, revalidación 1.771s baja 0.675s)\"}', 47736, NULL),
(1744, '2024-08-06 20:18: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\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"51107426\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47736\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 844,\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: 47736\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622559\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":6554.6218487395,\n                   \"nusertotal\":6554.621848739496,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1245.3781512605042,\n                            \"nbaseamount\":6554.621848739496\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622560\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5042.0168067227,\n                   \"nusertotal\":5042.016806722689,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":957.983193277,\n                            \"nbaseamount\":5042.016806722689\n                        }\n                   }\n                },\"3\":{\n                   \"sStandardItemIdentification\":\"3_622561\",\n                   \"sdescription\":\"MANGO EN AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":4201.6806722689,\n                   \"nusertotal\":4201.680672268908,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":798.3193277310925,\n                            \"nbaseamount\":4201.680672268908\n                        }\n                   }\n                },\"4\":{\n                   \"sStandardItemIdentification\":\"4_622562\",\n                   \"sdescription\":\"PORCION DE AGUACATE\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":2605.0420168067,\n                   \"nusertotal\":2605.0420168067226,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":494.957983193,\n                            \"nbaseamount\":2605.0420168067226\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"901402281\",\n                     \"sdoctype\":\"NIT\",\n                     \"ssellername\":\"FERRE COSTOS LA 14\",\n                     \"jcontact\":{\n                         \"scontactperson\":\"JUAN ALARCON\",\n                         \"selectronicmail\":\"ferrecostos@gmail.com\",\n                         \"stelephone\":\"\",\n                         \"jregistrationaddress\":{\n                            \"wdepartmentcode\":\"66\",\n                            \"sdepartmentname\":\"RISARALDA\",\n                            \"wtowncode\":\"66001\",\n                            \"scityname\":\"PEREIRA\",\n                            \"saddressline1\":\"Cra 14  9-07\",\n                            \"scountrycode\":\"CO\",\n                            \"szip\":\"660001\",\n                            \"wprovincecode\":\"66001\"\n                         }\n                     }\n                 }\n          }\n       }\n    }\n    }\n    ', 47736, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1745, '2024-08-06 20:18:58', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"b494fbcfb6f0f8ddb3112d11ac298d1fd00ff804cd95d403c2e90a05d01dce7ca3ef1f6646d29410d5f1b9acfcc890c5\",\"sqr\":\"SETP990000844 2024-08-06 20:19:00-05:00 901402281 222222222222 18403.36 3496.64 0.00 21900.00 b494fbcfb6f0f8ddb3112d11ac298d1fd00ff804cd95d403c2e90a05d01dce7ca3ef1f6646d29410d5f1b9acfcc890c5 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=b494fbcfb6f0f8ddb3112d11ac298d1fd00ff804cd95d403c2e90a05d01dce7ca3ef1f6646d29410d5f1b9acfcc890c5\",\"ssignature\":\"ZtqpNB5IgOHVgs4k5hQ8XYth8Zcc68/Ut2LmXo7/j+x93LR4TcEihgttLae1iUcVjWnS+M5+yaGQ4w7OmCikWZ8JbxZV5PLrLgfIhQL4TrMd3vUdLkg7pAGInrusILmNXfp9ZJKBEIX5BXY3+6nVGtww1emBpet8bSMuMF8HP5K1qL+bhqztnUU7ntQdqgnWDArjgzuEHRzxe6sJmz0vVAQyXcKeWb2o5zFtDsDlN/4iVe20jnnd8x1LCEPKQTK99t7GwvaQ0+EW9W0nmo+Gme83jLSaiY5BmXWKs9mGKTwD20tCaQQaEGN+Yx1p9JN7MKUo1PMduLRncXu23UYmDg==\",\"sdocumentreference\":\"SETP990000844\",\"rtaxxadocument\":\"96779071\",\"sref\":\"96779071\",\"irefindex\":990000844},\"sdebug\":\"Taxxa: 0.125s DIAN: 8.706s (creación 7.39s, revalidación 0.629s baja 0.688s)\"}', 47736, NULL),
(1746, '2024-08-06 20:19: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\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"1164877\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47736\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 845,\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: 47736\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622559\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":6554.6218487395,\n                   \"nusertotal\":6554.621848739496,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1245.3781512605042,\n                            \"nbaseamount\":6554.621848739496\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622560\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5042.0168067227,\n                   \"nusertotal\":5042.016806722689,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":957.983193277,\n                            \"nbaseamount\":5042.016806722689\n                        }\n                   }\n                },\"3\":{\n                   \"sStandardItemIdentification\":\"3_622561\",\n                   \"sdescription\":\"MANGO EN AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":4201.6806722689,\n                   \"nusertotal\":4201.680672268908,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":798.3193277310925,\n                            \"nbaseamount\":4201.680672268908\n                        }\n                   }\n                },\"4\":{\n                   \"sStandardItemIdentification\":\"4_622562\",\n                   \"sdescription\":\"PORCION DE AGUACATE\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":2605.0420168067,\n                   \"nusertotal\":2605.0420168067226,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":494.957983193,\n                            \"nbaseamount\":2605.0420168067226\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"901402281\",\n                     \"sdoctype\":\"NIT\",\n                     \"ssellername\":\"FERRE COSTOS LA 14\",\n                     \"jcontact\":{\n                         \"scontactperson\":\"JUAN ALARCON\",\n                         \"selectronicmail\":\"ferrecostos@gmail.com\",\n                         \"stelephone\":\"\",\n                         \"jregistrationaddress\":{\n                            \"wdepartmentcode\":\"66\",\n                            \"sdepartmentname\":\"RISARALDA\",\n                            \"wtowncode\":\"66001\",\n                            \"scityname\":\"PEREIRA\",\n                            \"saddressline1\":\"Cra 14  9-07\",\n                            \"scountrycode\":\"CO\",\n                            \"szip\":\"660001\",\n                            \"wprovincecode\":\"66001\"\n                         }\n                     }\n                 }\n          }\n       }\n    }\n    }\n    ', 47736, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1747, '2024-08-06 20:19:58', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"787fb4d431ddbe855601dca9a390825dcbdb2bf1ebd3652f95f2ec98a5a0d6012eec5b4c1cc0e6cf4936ea4640e5e0de\",\"sqr\":\"SETP990000845 2024-08-06 20:19:59-05:00 901402281 222222222222 18403.36 3496.64 0.00 21900.00 787fb4d431ddbe855601dca9a390825dcbdb2bf1ebd3652f95f2ec98a5a0d6012eec5b4c1cc0e6cf4936ea4640e5e0de https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=787fb4d431ddbe855601dca9a390825dcbdb2bf1ebd3652f95f2ec98a5a0d6012eec5b4c1cc0e6cf4936ea4640e5e0de\",\"ssignature\":\"aWQYic4Jpe+mVEyhRM2AMJQfEW98j/DPhjwKhFfmpYzd90qMcDztvJkzvYN4YZ8JNVRAip+KPd4+NtYwcBmBBHzc+p2uLPfOW/nqz9b2r920qtEJZWj7ZwyVm/5F9eGDm0SBHeV9TSFbhhSZY67vJkZiHh4Hgmrr9+dukbIHB0Q0M458HjbRD3e629fOri05sWW1K0OqaVv9R30Ec5k3rLcX0AS4rtRD6sKqrng6B1K/OryatI03WOhi+f67TMW3jhPfqIpAbQcETR6j4RKiz3J9iovQdyTRSS0jRn0h2OE7bbsadZnX4t/I7N9LaZ6PSbUyHWhMXq/bJD96oRZSbA==\",\"sdocumentreference\":\"SETP990000845\",\"rtaxxadocument\":\"96779568\",\"sref\":\"96779568\",\"irefindex\":990000845},\"sdebug\":\"Taxxa: 0.094s DIAN: 8.678s (creación 7.521s, revalidación 0.547s baja 0.609s)\"}', 47736, NULL),
(1748, '2024-08-06 20:21:56', '{\n       \"sToken\":\"696628881017\",\n       \"jApi\":{\n          \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n          \"jParams\":{\n          \"wformat\": \"taxxa.co.dian.document\",\n             \"wEnvironment\": \"test\", \n             \"wVersionUBL\": 2.1,\n             \"jDocument\":{\n                \"scustomizationid\": \"11\",\n                \"wdocumenttype\": \"Invoice\",\n                \"wdocumenttypecode\": \"01\",\n       \"rdocumenttemplate\":\"1164877\",\n                \"wcurrency\":\"COP\",\n                \"tissuedate\":\"2024-08-06\",\n                \"tduedate\":\"2024-08-06\",\n                \"sorderreference\":\"MAN-47736\",\n             \"sDocumentPrefix\":\"SETP\",\n             \"sDocumentSuffix\": 846,\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: 47736\"\n                ,\"jextrainfo\": {}, \n                \"jdocumentitems\":{\"1\":{\n                   \"sStandardItemIdentification\":\"1_622559\",\n                   \"sdescription\":\"JUGO NATURAL AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":6554.6218487395,\n                   \"nusertotal\":6554.621848739496,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":1245.3781512605042,\n                            \"nbaseamount\":6554.621848739496\n                        }\n                   }\n                },\"2\":{\n                   \"sStandardItemIdentification\":\"2_622560\",\n                   \"sdescription\":\"AGUA BRISA BOTELLA\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"901402281\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":5042.0168067227,\n                   \"nusertotal\":5042.016806722689,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":957.983193277,\n                            \"nbaseamount\":5042.016806722689\n                        }\n                   }\n                },\"3\":{\n                   \"sStandardItemIdentification\":\"3_622561\",\n                   \"sdescription\":\"MANGO EN AGUA\",\n                   \"sgroupname\":\"Ingresos Recibidos para Terceros\",\n                   \"smandate\":\"3054456789\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":4201.6806722689,\n                   \"nusertotal\":4201.680672268908,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":798.3193277310925,\n                            \"nbaseamount\":4201.680672268908\n                        }\n                   }\n                },\"4\":{\n                   \"sStandardItemIdentification\":\"4_622562\",\n                   \"sdescription\":\"PORCION DE AGUACATE\",\n                   \"sgroupname\":\"Ingresos propios\",\n                   \"smandate\":\"901402281\",\n                   \"smandateid\": \"1\",\n                   \"nunitprice\":2605.0420168067,\n                   \"nusertotal\":2605.0420168067226,\n                   \"nquantity\": \"1\",\n                    \"jtax\":{\n                        \"jiva\":{\n                            \"nrate\":19,   \n                            \"sname\": \"IVA\",\n                            \"namount\":494.957983193,\n                            \"nbaseamount\":2605.0420168067226\n                        }\n                   }\n                }},\n                 \"jseller\":{\n                     \"sdocid\":\"901402281\",\n                     \"sdoctype\":\"NIT\",\n                     \"ssellername\":\"FERRE COSTOS LA 14\",\n                     \"jcontact\":{\n                         \"scontactperson\":\"JUAN ALARCON\",\n                         \"selectronicmail\":\"ferrecostos@gmail.com\",\n                         \"stelephone\":\"\",\n                         \"jregistrationaddress\":{\n                            \"wdepartmentcode\":\"66\",\n                            \"sdepartmentname\":\"RISARALDA\",\n                            \"wtowncode\":\"66001\",\n                            \"scityname\":\"PEREIRA\",\n                            \"saddressline1\":\"Cra 14  9-07\",\n                            \"scountrycode\":\"CO\",\n                            \"szip\":\"660001\",\n                            \"wprovincecode\":\"66001\"\n                         }\n                     }\n                 }\n          }\n       }\n    }\n    }\n    ', 47736, NULL);
