INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1464, '2024-07-09 22:14:29', '{\"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\":\"e1d40f6ab80a405b4fa3c7fbfdf5d9283db37951279bb1e7163e29807c8693bf86ab5f632d54c035812fcad5bc989e17\",\"sqr\":\"FEF2700 2024-07-09 22:14:32-05:00 19385248 222222222222 26388.89 0.00 2111.11 32500.00 e1d40f6ab80a405b4fa3c7fbfdf5d9283db37951279bb1e7163e29807c8693bf86ab5f632d54c035812fcad5bc989e17 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=e1d40f6ab80a405b4fa3c7fbfdf5d9283db37951279bb1e7163e29807c8693bf86ab5f632d54c035812fcad5bc989e17\",\"ssignature\":\"uQbf51u1UKZMbL1b/HQu1vv1WYOavEIV2Pu3EXWrm+5LiBnf/36zkSpCJf4Q65pBXVsJw2/vkKQSvokQhjr/DfFprHYPVTX3RPA49nx6NICFhBuTsqjJyw1CvJeNvMiLx7IoYNt/Wn6Xqjfki4eOhOsVxlF9MqFYNh7Jzt4xMv8AHnT43Rth+2NeJNDaNlXr5swIw+hq/hFbiF6NRbsYrncJOC9oqa7yiTlhi2gMcx+pJ1vB42DIQP6+ZSwJL9+oHlyyw/USqJzSZocTWM4Ql8iNW1nTmk+Y43mYtnUCqahuV5GFQ3DIOM6JpuJ7V6VKwQIdirfiNgxKNzGPwPFDLQ==\",\"sdocumentreference\":\"FEF2700\",\"rtaxxadocument\":\"87559587\",\"sref\":\"87559587\",\"irefindex\":2700},\"sdebug\":\"Taxxa: 0.141s DIAN: 2.155s (creación 1.405s, revalidación 0.75s)\"}', 47543, NULL),
(1465, '2024-07-09 22:14:35', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2701,\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: 47544\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620863\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47544, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1466, '2024-07-09 22:14:35', '{\"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\":\"01f28da04e856033f10c7fe282fc0c12fa1272bce2bb633f3e838155d40d26427765effa705bf3aae6ce1f54a6d573a9\",\"sqr\":\"FEF2701 2024-07-09 22:14:40-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 01f28da04e856033f10c7fe282fc0c12fa1272bce2bb633f3e838155d40d26427765effa705bf3aae6ce1f54a6d573a9 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=01f28da04e856033f10c7fe282fc0c12fa1272bce2bb633f3e838155d40d26427765effa705bf3aae6ce1f54a6d573a9\",\"ssignature\":\"1QEssYDQP6UDmo7+0kiF7FsbB5c75zYD/usoHRT4okuQFvsnWAf5FOC3XjoOXgSmbCk6eMoW9ZBIKEk48bmz1/Hu53kWFpjR2V0OO2yQgWKl084Of9NcwsMkDMA60tLZajMBiTJAWr1+VoNNCxX3LLjC1DG8uSLN6UyQUFo56b/RGqu8sG4ygUcz1hIjnTQ5FVZw+304gTcIXgsfUJkCC8VlcELDNCbuLSxbx651JaheWkmrc3OxoH1oD0L2TYzmbDuDvWlKjRxhZKsoCbPXY0Ps0Ze5eFaIIYCPWnpiAVCbn5tEtoqapT87K3pmp9+WR73QRN3aOJgbT6mDKfn8Ow==\",\"sdocumentreference\":\"FEF2701\",\"rtaxxadocument\":\"87559638\",\"sref\":\"87559638\",\"irefindex\":2701},\"sdebug\":\"Taxxa: 0.141s DIAN: 2.839s (creación 1.406s, revalidación 1.433s)\"}', 47544, NULL),
(1467, '2024-07-09 22:14:44', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2702,\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: 47546\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620901\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47546, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1468, '2024-07-09 22:14:44', '{\"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\":\"968ff77d62205c56aa82666b7dfd5fe0f5fa00c47da3838df2714683d28ee8370d9680f1fca1eb8b5c4b3faa19f54fe8\",\"sqr\":\"FEF2702 2024-07-09 22:14:47-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 968ff77d62205c56aa82666b7dfd5fe0f5fa00c47da3838df2714683d28ee8370d9680f1fca1eb8b5c4b3faa19f54fe8 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=968ff77d62205c56aa82666b7dfd5fe0f5fa00c47da3838df2714683d28ee8370d9680f1fca1eb8b5c4b3faa19f54fe8\",\"ssignature\":\"a5R/oKCMKfSoDNp1vUG668cYbAvGEOmvVLULZlcx11PwqBe01U0T/1mam6iCoK5oy/LlVtC/EiWB/5wI1TWBrIcyoJSY7/YMVe8sSJVrFB3jF6G/eAvBBfV+JS7QdY112zRu0wU8ajJZODa9jU5Gmxqxo6SY/NSGQ+WXPmyz/dBooEE11GPhi5rWGb5akU3ALoiouLH4mDNGyfI8TsrCtgWLdcUhbEk9ViAVYTy4MxkYV+SM2jyLOmhvvTRO0jt9F0s7yKp0lyeWeJPJtz4pBfcgMoCmlTZeDnwhMVgSP7xnj6mcxnoo6C+vordxyUMmUoUMMj+jssRzA0rBON+3xg==\",\"sdocumentreference\":\"FEF2702\",\"rtaxxadocument\":\"87559697\",\"sref\":\"87559697\",\"irefindex\":2702},\"sdebug\":\"Taxxa: 0.156s DIAN: 4.61s (creación 3.923s, revalidación 0.688s)\"}', 47546, NULL),
(1469, '2024-07-09 22:14:53', '{\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-09\",\r\n               \"tduedate\":\"2024-07-09\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2703,\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\":\" 3214381235\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"EDF CAMACOL OFC 301 CLL 23 12-59 ESQUINA\",\r\n                        \"szip\":\"630003\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47550\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"17\",\r\n                         \"namount\": 3000,\r\n                         \"nbaseamount\": 16203.703703703703\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620931\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47550, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1470, '2024-07-09 22:14:53', '{\"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\":\"82b4797fcc9ef38597afe1523eb354bcf210164cec65ecf032d0a4a1090c82bbfd3aa9f8c01a29e00ea8ef3f8288061a\",\"sqr\":\"FEF2703 2024-07-09 22:14:59-05:00 19385248 222222222222 16203.70 0.00 1296.30 20500.00 82b4797fcc9ef38597afe1523eb354bcf210164cec65ecf032d0a4a1090c82bbfd3aa9f8c01a29e00ea8ef3f8288061a https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=82b4797fcc9ef38597afe1523eb354bcf210164cec65ecf032d0a4a1090c82bbfd3aa9f8c01a29e00ea8ef3f8288061a\",\"ssignature\":\"MtGtmAdxGvX4OeG/U9LR+fWJgqDOPVVh9xuyF5HBjltARjmf1pYKOx+/IPQcn5goKd1AKujCjFISg9cgjWQVpU0HVTBYI5BOLBXB+YKe62IH2rsujd4WU8CrmYd+YX+pP1fZJxR8DeAhnSwsBVfTFX8qAMumCy9MY0cYMwF8fu1SjXCVhCdoVfpBqq2U3t/wAvsV5HPuV24I3LWWmQKdT40tkf6SoHy30kCoVVRcIrTAyraLSYXKGQpB04JsGWzmhk50C+x7Vh5f3R62+hhQzsL+xPKbRjHXgEZdnIsDdRM8xs+Ntm2jpa7OCcmXWMtr4HlUZkjn0RyI4jBl/D8ymQ==\",\"sdocumentreference\":\"FEF2703\",\"rtaxxadocument\":\"87559780\",\"sref\":\"87559780\",\"irefindex\":2703},\"sdebug\":\"Taxxa: 0.141s DIAN: 2.078s (creación 1.703s, revalidación 0.375s)\"}', 47550, NULL),
(1471, '2024-07-09 22:15:03', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2704,\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: 47551\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620938\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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\":\"00620944\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47551, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1472, '2024-07-09 22:15:03', '{\"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\":\"b4039fc39937f88f743e4abb2e14ee587e00c754b3fd0bc8947e298935b59026e68a109adaa53a6265bf1d64acdb68aa\",\"sqr\":\"FEF2704 2024-07-09 22:15:05-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 b4039fc39937f88f743e4abb2e14ee587e00c754b3fd0bc8947e298935b59026e68a109adaa53a6265bf1d64acdb68aa https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b4039fc39937f88f743e4abb2e14ee587e00c754b3fd0bc8947e298935b59026e68a109adaa53a6265bf1d64acdb68aa\",\"ssignature\":\"u/a6Zcrvbv+YetmLVorsxK3R8j5MO4p3rPtaKoxerjYoKKBxVBrRBWQKrRds2uXARPWyieSSBfyVpk+cLddhPocUckeCnuS0bN2Aihf96viveQswcL7pJuFhFwF5HPMw8a8ZARj6hbsydKQkDim4xpiBqdS97y8wz/LkJG7kC7SFuKJ6c6wr2lA4xc3Chpn8e8rnc5X4r3nR+6XgXnPrbIZWJOGEpTSsLmIshhw/TK1tIH5Fx++YO6VHTDLduaA0fMhlERCjMLp1sXFv9eNDdVRVEZAVFTxV4nRgRmHLIG11oQGLtMUG07zS8oPjkp94ABOCMgwaj3jdcxSBOu7qmg==\",\"sdocumentreference\":\"FEF2704\",\"rtaxxadocument\":\"87559830\",\"sref\":\"87559830\",\"irefindex\":2704},\"sdebug\":\"Taxxa: 0.109s DIAN: 1.916s (creación 1.229s, revalidación 0.688s)\"}', 47551, NULL),
(1473, '2024-07-09 22:15:09', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2705,\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: 47552\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620953\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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\":\"00620959\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47552, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1474, '2024-07-09 22:15:09', '{\"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\":\"56acfdd90a8472f7022e0a1e8a8a0ac25304e8431875f519218b0801b08e20da3fd93405b3167aa0fb9b6536901a2eaf\",\"sqr\":\"FEF2705 2024-07-09 22:15:12-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 56acfdd90a8472f7022e0a1e8a8a0ac25304e8431875f519218b0801b08e20da3fd93405b3167aa0fb9b6536901a2eaf https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=56acfdd90a8472f7022e0a1e8a8a0ac25304e8431875f519218b0801b08e20da3fd93405b3167aa0fb9b6536901a2eaf\",\"ssignature\":\"hqB5vbZHc5MBb4G3DAjFaXIfVG5wZnmCZ5M7BpSXDck4q3LI64yo0lvi3Uo8PJdA5ZrAzDIxYNgTCiaZWyaTBkT0zJeaH4/zW2worswFgLNC9YLcIueIbkAOhK4X4SALDc3AP3tqTo+VKjXyclEnzXR50lZFqC/qbOzCVOLPjbQCSW9HzjvpaxaA7Hu2Pq2inF7Nf/MdosVlIrq1milwgz35KAtvzWyHMvPJqqcEfX3o1r7S1C/d/i9ouN4770gylQdo8mMqkp2B8PdmYhuDchk1kyT7rXk+BxPkhTXrb3IO0+VgJtrrZzfpChZjsRCPRzt8bQot7vfbmaeXGB0FFg==\",\"sdocumentreference\":\"FEF2705\",\"rtaxxadocument\":\"87559897\",\"sref\":\"87559897\",\"irefindex\":2705},\"sdebug\":\"Taxxa: 0.156s DIAN: 1.578s (creación 0.953s, revalidación 0.625s)\"}', 47552, NULL),
(1475, '2024-07-09 22:15:14', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2706,\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: 47553\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620968\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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\":\"00620974\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47553, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1476, '2024-07-09 22:15:14', '{\"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\":\"cd053c3766230279b39471aaf247d6792904f2cc0f880c0354d82aad98512a80c6ad655955e0dd96d97b0027123cd376\",\"sqr\":\"FEF2706 2024-07-09 22:15:17-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 cd053c3766230279b39471aaf247d6792904f2cc0f880c0354d82aad98512a80c6ad655955e0dd96d97b0027123cd376 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=cd053c3766230279b39471aaf247d6792904f2cc0f880c0354d82aad98512a80c6ad655955e0dd96d97b0027123cd376\",\"ssignature\":\"sBhoD+v6b1TE41Jx8kmD9KmhfOZnqMCQtrQABDWfAK/A1Yeur+v2lJR2I6T8EnstF9KaoCPpHL1CUtpNJL72B6Dr+A+UPk6y1aM7AIIrOH7t0taaPDXpDL3fiV2PBLd8kcdQet4yZ1hYM5eTNXiNosmzgfKLQ2GkfRdGXBLYXD1t8h/szn762nE/RQNSHrE/Knf5x4k/HXAa5dagrWK3LW6eTXbJzCXMsKgLqIVcM9omFNWkhkDbG0TzlSjYlYKcczvRLxLLZQqvShLzIyAI86xo5RLs+KuXeH3/OUjQ11/ti5qm+Jl2MopvKhuq8FcgrkckFrQtz7AQ7zZ8l0o0nQ==\",\"sdocumentreference\":\"FEF2706\",\"rtaxxadocument\":\"87559939\",\"sref\":\"87559939\",\"irefindex\":2706},\"sdebug\":\"Taxxa: 0.161s DIAN: 5.724s (creación 5.13s, revalidación 0.594s)\"}', 47553, NULL),
(1477, '2024-07-09 22:15:25', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2707,\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: 47555\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620998\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47555, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1478, '2024-07-09 22:15:25', '{\"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\":\"b4bb328cbded8d3618320f8adb5060dd27e517719246896237a12ae1aeda56aebe882a63b3c21186a523458d05b976b4\",\"sqr\":\"FEF2707 2024-07-09 22:15:27-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 b4bb328cbded8d3618320f8adb5060dd27e517719246896237a12ae1aeda56aebe882a63b3c21186a523458d05b976b4 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b4bb328cbded8d3618320f8adb5060dd27e517719246896237a12ae1aeda56aebe882a63b3c21186a523458d05b976b4\",\"ssignature\":\"8B7NaqrXkdSkRxqPmrVcGgmBEX/BTKWgqnCj0ASAskzOxFkJ8ehJzBM3+LXI2HqUxqwUQv2wotS5AUlAjgakk7P8S+kzFT8aT5ZvNCK71HEaXxJoALi/Ua4rSC53fF+Ggylbz3OPN8hoDp7oEXM/l12OPEFVrNtjmLT2LW/u2eRt4iFgzqZ6kzzQMuRZKsPbu7YxIS3ZUb+5tguojDwrEgkrpg9dgSYZALtW9KppSBLLVjv+N2cvKfJU5vrRvINA0t/hwK0sgjJDB3Z0rljsDpwFSJUDq172u/z7BfrMEd7BOt5DL5L1o0SCftHpOLI2PYMX1FKYCN0iJqrU83eedw==\",\"sdocumentreference\":\"FEF2707\",\"rtaxxadocument\":\"87560003\",\"sref\":\"87560003\",\"irefindex\":2707},\"sdebug\":\"Taxxa: 0.155s DIAN: 1.089s (creación 0.803s, revalidación 0.286s)\"}', 47555, NULL),
(1479, '2024-07-09 22:15:31', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2708,\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: 47556\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621005\",\r\n                  \"scustomname\":\"PORCION ENSALADA VERDURAS\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":9722.2222222222,\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   ', 47556, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1480, '2024-07-09 22:15:31', '{\"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\":\"975a38edcd020e1d693d50e8b14e4445686e595558b673eb9c2b9be94bdf836106230a4d0bde6e2ea0337f3acb580ae0\",\"sqr\":\"FEF2708 2024-07-09 22:15:34-05:00 19385248 222222222222 9722.22 0.00 777.78 10500.00 975a38edcd020e1d693d50e8b14e4445686e595558b673eb9c2b9be94bdf836106230a4d0bde6e2ea0337f3acb580ae0 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=975a38edcd020e1d693d50e8b14e4445686e595558b673eb9c2b9be94bdf836106230a4d0bde6e2ea0337f3acb580ae0\",\"ssignature\":\"Zi7tSMCMv8IAjJ8HJesYtHbo3t2u1MkExrzjedq7UM7L+BQZ20g1N8o9LnAZk+tx6lCTYn+RaOdQNgX7Mejx7BZeof4W0Rdv+G1CzB3eSZtu/diLTphuaU9tg4enw537zWpMrh5cxbzCRs+3Ct2qYeFJZmEWEpLmlFdr6fGzrxoC80KZUnctSmiPEBBhZ7MybzMQ3rrdOsQ40ctQHefi2+gbv0dD2R1HIhHklXMweoHXKTQ7ihfrseNpwZYxKRB3mvLg501QQCFoUd+GeVgMzrIjR0YLtPVDNg4hT6mtj4+uTy9IGZTH7rNeYv2ZpPccR28AvwQlmCB8JQWQB7mDrw==\",\"sdocumentreference\":\"FEF2708\",\"rtaxxadocument\":\"87560074\",\"sref\":\"87560074\",\"irefindex\":2708},\"sdebug\":\"Taxxa: 0.203s DIAN: 1.612s (creación 1.003s, revalidación 0.609s)\"}', 47556, NULL),
(1481, '2024-07-09 22:15:37', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2709,\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: 47557\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621006\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47557, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1482, '2024-07-09 22:15:37', '{\"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\":\"b1299536fbaf274bc2f81fdc4db699ce680bbe01e5ced3a52b1245cba5092e8d81acc2f156dfb10a633db9eccf463719\",\"sqr\":\"FEF2709 2024-07-09 22:15:43-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 b1299536fbaf274bc2f81fdc4db699ce680bbe01e5ced3a52b1245cba5092e8d81acc2f156dfb10a633db9eccf463719 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b1299536fbaf274bc2f81fdc4db699ce680bbe01e5ced3a52b1245cba5092e8d81acc2f156dfb10a633db9eccf463719\",\"ssignature\":\"cwMWPnZrhNuf3hgqXwuNHReGVsuNq2xDO4Kz3qKGt2aGdTFGZ3i2Y8s/bUVq432b8N7s+L9UeKckWIvBjDuUkZrPU7z/gNl3XxJibagDo1+GIul7Qn9eLilw3rFLY/CNEYehW67Nb9W2tgJyBPL1i8WhQoUWu27zV+xRJSig5s3rCbaPEwZ8tkVLkutCcjhcURDqfoqEG4Z5PgOBBAPPaMGW+W8mkCB0FKFcs0DcMuq4UYq/mKRRJEJs+CXllLnoJZBm57kiIrIz/Re7EQnD2j+CKw2/5A+65ZsDVQMsduaX8W0lH79hIfmUxiRFNuWZ3vGvTt03a2bd+egl8r5yDA==\",\"sdocumentreference\":\"FEF2709\",\"rtaxxadocument\":\"87560114\",\"sref\":\"87560114\",\"irefindex\":2709},\"sdebug\":\"Taxxa: 0.141s DIAN: 4.113s (creación 3.785s, revalidación 0.328s)\"}', 47557, NULL),
(1483, '2024-07-09 22:15:48', '{\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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2710,\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: 47559\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621028\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 47559, NULL);
