INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1284, '2024-07-07 22:39:07', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"36c9dfba5fcc8447980fa7de1cb1b39fb749d01fa09099aa22ed30e210d59ea2cb7dd60db6b771948398ca8554789799\",\"sqr\":\"FEF2610 2024-07-07 22:39:09-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 36c9dfba5fcc8447980fa7de1cb1b39fb749d01fa09099aa22ed30e210d59ea2cb7dd60db6b771948398ca8554789799 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=36c9dfba5fcc8447980fa7de1cb1b39fb749d01fa09099aa22ed30e210d59ea2cb7dd60db6b771948398ca8554789799\",\"ssignature\":\"OV2/RrR+eKe6dR8HVsXEMZbVlsECdX3mMr4F402oyKg5Gjgh7ojIG8qqio9A7qxGG7T5uVV7WAFkhZe/ew11GpVvDN1dViOhGEo/wruG4B1X657T2e0qlPkGDhmtCu3/GkrKfz+LevPPOJOrAyRp8nl4yWJOCL21V+O8hi/ehyEVXrNOyLv0tPfvlYd6QhWHiRTspbfZsrdNrLWlHGgvr9uBnBNHc+qzGbJATPLh5dPivpFLqCwWThD5wo3g2hMBD4QTOKmo9fj8XVjxbdcssKWO0I46irX0XP22O7tum/WvqFYH2R+sZ3cpZ3feXpvG6DZhsGuMmHWD6FxuL3ImHQ==\",\"sdocumentreference\":\"FEF2610\",\"rtaxxadocument\":\"86998206\",\"sref\":\"86998206\",\"irefindex\":2610},\"sdebug\":\"Taxxa: 0.251s DIAN: 1.377s (creación 1.107s, revalidación 0.27s)\"}', 47327, NULL),
(1285, '2024-07-07 22:39:12', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2611,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47330\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00617835\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47330, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1286, '2024-07-07 22:39:12', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"99ac7d74d9671b75f271d994eaf63e98e5a41fa039eedc62b6fb917442ca03d28276d0bbe22130c883634c156e450a48\",\"sqr\":\"FEF2611 2024-07-07 22:39:15-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 99ac7d74d9671b75f271d994eaf63e98e5a41fa039eedc62b6fb917442ca03d28276d0bbe22130c883634c156e450a48 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=99ac7d74d9671b75f271d994eaf63e98e5a41fa039eedc62b6fb917442ca03d28276d0bbe22130c883634c156e450a48\",\"ssignature\":\"NLgSg9b+tVEz7Wx4XfE6aX6G+uvgwUUQ3m5XhKDU7XBT6I2ZYKIy7ZwSTSLYHx6Na+W9/lJu/rWHa+T7DVJGRkODzCRkJBidqhnqWX+WtZlaophtDpLcjEpDDstZIlsufJ7Yn5D5hg9UVhkTm356vCXhgJ1Nw00oKjTgAmRX3q7Divcr8UXtqJaLurvHeB246OjvSP+RcqV8/Ff2dJz7NUzqMnxCvxmotXqkFexSrTbq5U1mm5aqmEgDx2R2k1avgpiY7tNT7D/lfViRCu32NKwcZJjzRiB5amgCrd0Zrh+YIbtCMMpIfEgTbdjoHbl0MGrUAno4uMtGDVBjCvqyHw==\",\"sdocumentreference\":\"FEF2611\",\"rtaxxadocument\":\"86998225\",\"sref\":\"86998225\",\"irefindex\":2611},\"sdebug\":\"Taxxa: 0.17s DIAN: 0.94s (creación 0.641s, revalidación 0.3s)\"}', 47330, NULL),
(1287, '2024-07-07 22:39:17', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2612,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47333\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00617864\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00617870\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47333, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1288, '2024-07-07 22:39:17', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"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\":\"eeb6e1b9c0f5d750ce82f2953cb0f0a0539485e81fc8b7e40eceb43357969a7883216cf594692d28e0d70159699fdf1b\",\"sqr\":\"FEF2612 2024-07-07 22:39:19-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 eeb6e1b9c0f5d750ce82f2953cb0f0a0539485e81fc8b7e40eceb43357969a7883216cf594692d28e0d70159699fdf1b https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=eeb6e1b9c0f5d750ce82f2953cb0f0a0539485e81fc8b7e40eceb43357969a7883216cf594692d28e0d70159699fdf1b\",\"ssignature\":\"Fx2tb4HljX0XQFeCNTgC+vDbImHR12A1y1d/BR4+jibnGxKxh9+bWTu8y/HS/F3jPZSEDv0zqgs/2JfCPifsyyivxJ/kdzFR9FShb+r01GJn9fZUVsXDNnZ+f7IududLZlUA/LWTlNMRbDFLChjrO1rYMjis2xCJ6Xk7rbHcdEl90uTrdC0XZS6BePF5XbkKBK4MC1EUYtqvaalmwE6iJJal55LgHMnv5h+408f5oJ8Ie1KREIacCoMXy1cRPHfA/bWMtmNdhBnFe414/jPngQrn2gMQ44S0T+UFOYby+ZsUm94YraFe8jffw6+3Q6zleVSq8MqZXE03WwAy3/ebQQ==\",\"sdocumentreference\":\"FEF2612\",\"rtaxxadocument\":\"86998240\",\"sref\":\"86998240\",\"irefindex\":2612},\"sdebug\":\"Taxxa: 0.215s DIAN: 1.094s (creación 0.641s, revalidación 0.453s)\"}', 47333, NULL),
(1289, '2024-07-07 22:39:22', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2613,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47342\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618047\",\r\n                  \"scustomname\":\"SOPA ADICIOONAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":8055.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47342, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1290, '2024-07-07 22:39:22', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"a6160ab77c5ada016d60d9dbc436a7beafbf6b208cc39a48408cf03c4e30b38a97a1bb86c931839d0c9c37d213e1e775\",\"sqr\":\"FEF2613 2024-07-07 22:39:24-05:00 19385248 222222222222 8055.56 0.00 644.44 8700.00 a6160ab77c5ada016d60d9dbc436a7beafbf6b208cc39a48408cf03c4e30b38a97a1bb86c931839d0c9c37d213e1e775 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=a6160ab77c5ada016d60d9dbc436a7beafbf6b208cc39a48408cf03c4e30b38a97a1bb86c931839d0c9c37d213e1e775\",\"ssignature\":\"mXm7PJaoFHoyhOmwOmLAZCMJDFb+hKJ3y/PgRDdCFD9EOCHsOzCgIK71Pag4sDcuLbZwYqkK3SbJ492QzMkI5+QsFDA+63/39Ge9Cav5Z/aHjvLqZRrL0+Obdg2LRDMhORu/8BcmCgaJ015g6J3BTIjhEZILnd+6sy/Yb3HzlDp14F8q39KaxJoE6QQ034WhRjLt3B39OLZ2IMDl/DseIUK+lAu9EKpiWf9PrmXhE3gXUFB4kW+LfCfkIWDvYoaQq7eQDdxT7HvxgvHTXlmckGh5sQyrG+vMjC0/VQB8hGnYyZPlvhT7f3mq+Qu+uKUXCcIRp8jJYVlmP0/+iUirNQ==\",\"sdocumentreference\":\"FEF2613\",\"rtaxxadocument\":\"86998255\",\"sref\":\"86998255\",\"irefindex\":2613},\"sdebug\":\"Taxxa: 0.169s DIAN: 1.41s (creación 0.783s, revalidación 0.627s)\"}', 47342, NULL),
(1291, '2024-07-07 22:39:27', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2614,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47344\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618063\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00618069\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47344, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1292, '2024-07-07 22:39:27', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"e33eaa59c2dc8fb48698ff571b624a2f034a08ee7ece4416b2a5a8312b21d312ab3a46a74f80f6662fc0720675e2110d\",\"sqr\":\"FEF2614 2024-07-07 22:39:29-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 e33eaa59c2dc8fb48698ff571b624a2f034a08ee7ece4416b2a5a8312b21d312ab3a46a74f80f6662fc0720675e2110d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=e33eaa59c2dc8fb48698ff571b624a2f034a08ee7ece4416b2a5a8312b21d312ab3a46a74f80f6662fc0720675e2110d\",\"ssignature\":\"M2L+lfYg/gmJP4yt9LIMJuXYy0jkeFRyu9xMGq5/pmQF1qGXCjM4CbaOcsuZj8YAjlOMBk4F6DHugwznHnDg1cgg5rotktwzh1/bsemXKryOWIjT5b0qi36ydSDwRhvybH6X45eg1QTxu7FPJ+K9psspRz6PNfzxArXTTOeM/8GBU/xICbs+g5DyJf/5N0xUWzT/3+XwRdWEgYkk+/p9xH/uEB4ASzClwnDuQ+rDG+OmoWIp+QEMPNrv3TL9QZwn1sU8E52S7szyb4ur8p6CSKMt9CmTswn+GWZ4aTHEZEynfnleCVo8sZ9PPnZOE1QyjBg3hpc2K8EmKX1MKrHipg==\",\"sdocumentreference\":\"FEF2614\",\"rtaxxadocument\":\"86998272\",\"sref\":\"86998272\",\"irefindex\":2614},\"sdebug\":\"Taxxa: 0.156s DIAN: 1.435s (creación 1.091s, revalidación 0.344s)\"}', 47344, NULL),
(1293, '2024-07-07 22:39:33', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2615,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47345\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618078\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00618084\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47345, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1294, '2024-07-07 22:39:33', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"8a9718442c10dd1b9d727977008c9bc7f1cc0c0d9117d03a058df13a16aff054f2a501bce820bba19a26eaa3aea8957e\",\"sqr\":\"FEF2615 2024-07-07 22:39:35-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 8a9718442c10dd1b9d727977008c9bc7f1cc0c0d9117d03a058df13a16aff054f2a501bce820bba19a26eaa3aea8957e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=8a9718442c10dd1b9d727977008c9bc7f1cc0c0d9117d03a058df13a16aff054f2a501bce820bba19a26eaa3aea8957e\",\"ssignature\":\"u3N8xpXfjmYPsYoMLtWMzptAgA/Wo1s14ChGq8DVF/r8IY5tLEB4n6K2B8V0ijJ94ix1wZPd1tawpmhwninrFaVDhbhq9hPcHsYr7wOg/KlFKKp7X5RM7O2XKqVzBHesBqOp5bkM1GcJr4T/icTQM3CjHrmy9nt3FXvS2WT8+HSZjdjXxvvc/qRrqhysoVnoQODYD0Wx6DF7ZIwyA9yXSSGwnhA0SLpxcFzpF+oVpltPz6vhySUOy2Ogn6JF86DeEesJsq5CXZr7HeJCWbfKkwLLFffPjXK8xfgSOzQR7MVmlZ/QrpQx3IcDn53fSWeCQ0EtclScr9oVaVKGjdEpKQ==\",\"sdocumentreference\":\"FEF2615\",\"rtaxxadocument\":\"86998289\",\"sref\":\"86998289\",\"irefindex\":2615},\"sdebug\":\"Taxxa: 0.141s DIAN: 0.872s (creación 0.591s, revalidación 0.281s)\"}', 47345, NULL),
(1295, '2024-07-07 22:39:38', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2616,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47348\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618115\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47348, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1296, '2024-07-07 22:39:38', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"2b041a333d83447c1cfda6e3b7c8cea71be14a767e4a45a0bd7edc9c4be80fec665f1bd38ea9f6dd31b5dd3ce2317600\",\"sqr\":\"FEF2616 2024-07-07 22:39:41-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 2b041a333d83447c1cfda6e3b7c8cea71be14a767e4a45a0bd7edc9c4be80fec665f1bd38ea9f6dd31b5dd3ce2317600 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=2b041a333d83447c1cfda6e3b7c8cea71be14a767e4a45a0bd7edc9c4be80fec665f1bd38ea9f6dd31b5dd3ce2317600\",\"ssignature\":\"yfnOaRNm63gIhGyTbTkpq9XdDBjPwhPUqjVhsotuHwrgPrBqlFVK5vjv+bXn7Wjj05UOJ3NXALYIiuUSbnmtw3jOYI1oDdqEiDKpoKkjH/JVW7P/OyQNucU5e3ZIK8rjarKPcYSH2STsZ5nItIvK3V/CxOEBwy7J0tw6tOptOjVv/OtheuzOwTjy4E6GZVx5qF3ECREjn+h0I2e+xKsMBOIT6973P7fpyZIOXVILnBzhHIzJvlCmgqqMlpSY4X1JeGdaLTMRI0S+z1kx8WOVJQvdFlebGtgXv6Pf5GXmLa/Vz5vsEruTUUt/s8WoeAotj497lKie09BuFej9C/Bt2Q==\",\"sdocumentreference\":\"FEF2616\",\"rtaxxadocument\":\"86998311\",\"sref\":\"86998311\",\"irefindex\":2616},\"sdebug\":\"Taxxa: 0.168s DIAN: 0.903s (creación 0.625s, revalidación 0.278s)\"}', 47348, NULL),
(1297, '2024-07-07 22:39:43', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2617,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47353\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618222\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":2,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47353, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1298, '2024-07-07 22:39:43', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"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\":\"d15ed1c2a285fee5faf283f72d06e5d7ad8bd0e1c2fde799c30b9e9f6197476b9db1051482218db67f457a8dda322aab\",\"sqr\":\"FEF2617 2024-07-07 22:39:46-05:00 19385248 222222222222 32407.41 0.00 2592.59 35000.00 d15ed1c2a285fee5faf283f72d06e5d7ad8bd0e1c2fde799c30b9e9f6197476b9db1051482218db67f457a8dda322aab https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d15ed1c2a285fee5faf283f72d06e5d7ad8bd0e1c2fde799c30b9e9f6197476b9db1051482218db67f457a8dda322aab\",\"ssignature\":\"rx7P1R3HxnV7XN9H9CopwB6sMbe9POe8AkQj8Zd/wc8zpv+3kKSiZqLzezixqFc8dtN2xU2TWF7yf7ymmv7m+AVGj3WSyouAD0LXigWMon50G4U4DqxJxO6vuglwHYse3VFI5mhm6n9alT0B2hXVgmEB/wjpW4jO0ClN+ecKnA89NqvmbP2c/4csi0Vsw2u1xLhFjVxwloeAxVTTymT9iT0XWm+1PonxqS0PEYZkYgELix3qBn2V9fq2Muv2xwGWVzsYIfKqANXUDNfA8okWBu6/whgPbGbNbmT/taIlo3qy4KMNFyAw0dSTRRdbb+jQqRJeTNJTn1QvU/mYcQRbYQ==\",\"sdocumentreference\":\"FEF2617\",\"rtaxxadocument\":\"86998321\",\"sref\":\"86998321\",\"irefindex\":2617},\"sdebug\":\"Taxxa: 0.188s DIAN: 1.311s (creación 1.045s, revalidación 0.266s)\"}', 47353, NULL),
(1299, '2024-07-07 22:39:49', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2618,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47355\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618236\",\r\n                  \"scustomname\":\"CARNE ENTERA 320gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":25000,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47355, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1300, '2024-07-07 22:39:49', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"158e7712de8fb90bfc2bd56ec6ce77ccd0b90221f8238eaedf7d2e9cf88dcc386449692ad2e5f9f838318a4070dc00fb\",\"sqr\":\"FEF2618 2024-07-07 22:39:52-05:00 19385248 222222222222 25000.00 0.00 2000.00 27000.00 158e7712de8fb90bfc2bd56ec6ce77ccd0b90221f8238eaedf7d2e9cf88dcc386449692ad2e5f9f838318a4070dc00fb https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=158e7712de8fb90bfc2bd56ec6ce77ccd0b90221f8238eaedf7d2e9cf88dcc386449692ad2e5f9f838318a4070dc00fb\",\"ssignature\":\"ngTeqmBueqRl5w730o9rYzVIbPpuBs6GIFU55vzy4HSRKAmzg5N98sryzYiqbVwm6wpd+mBarx+aX5rp1x0VQH0LpVqqogr6yUAGVeALUPTKhJ3rK17elZwqe636LwLppK57r0u1hoe+jxT1FaEIHyf4EWxSLxGWBA2uq21OnPS+X1xvHKwvHDE4SNaQ/gsQ9RVvlirx3z7BlSwMgLrKpNWcNaqfG9mjIpJxcJCL5fKbCagwYbWf6Cmw+gWGwub9upZWoNPGBzTQfqeWqxNdNaVGahVJZgzbTDlMPpNNxIbxheTZ34fIVIu78gw2lk57ueJmhllWkuvTOh56nGfWTw==\",\"sdocumentreference\":\"FEF2618\",\"rtaxxadocument\":\"86998339\",\"sref\":\"86998339\",\"irefindex\":2618},\"sdebug\":\"Taxxa: 0.259s DIAN: 1.275s (creación 0.994s, revalidación 0.281s)\"}', 47355, NULL),
(1301, '2024-07-07 22:39:55', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2619,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47362\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618381\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00618387\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47362, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1302, '2024-07-07 22:39:55', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"1\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"2\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"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\":\"1e89e308b833b20f8b35dd99c5b3b406c2ec8aba0d182f05cc3de33b6a79ff24086067cbd825fb3f1ec3ce6a134f155d\",\"sqr\":\"FEF2619 2024-07-07 22:39:57-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 1e89e308b833b20f8b35dd99c5b3b406c2ec8aba0d182f05cc3de33b6a79ff24086067cbd825fb3f1ec3ce6a134f155d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=1e89e308b833b20f8b35dd99c5b3b406c2ec8aba0d182f05cc3de33b6a79ff24086067cbd825fb3f1ec3ce6a134f155d\",\"ssignature\":\"XoAQTVNT1juB1JYSEevIXdCTVmDoNuIlAoYvsTqZIsH9M95/snHgkU52jonTWhl9YnSHkYid8iRXd22zTxzevzS0xkJ2/B9PBeCGcOBZkuebWhn0D8f78VuZ6fONS2xdupR336lDT2VG+gldgMoYyHc7K9RAHrcs3rAZZjK+Do2xfZsIM88ic3Jys1tGEPFcOJ9t/88hyThdndc10mCqKAXJNh5q93zQIQry1IWFlv+WKmCRs9w2TDiZr3V0YLle9x/iOd3ZFaualCpk9LpgX3Cs21rEY/TSr4p/oXfG11bM480+H9nfBvXyoPX4Nr0NcUFbUaO2I61OdEvkxr+Y4w==\",\"sdocumentreference\":\"FEF2619\",\"rtaxxadocument\":\"86998357\",\"sref\":\"86998357\",\"irefindex\":2619},\"sdebug\":\"Taxxa: 0.165s DIAN: 1.65s (creación 1.028s, revalidación 0.622s)\"}', 47362, NULL),
(1303, '2024-07-07 22:40:00', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-07\",\r\n               \"tduedate\":\"2024-07-14\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2620,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47367\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00618504\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00618508\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6018.5185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47367, NULL);
