INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(766, '2024-07-03 22:25: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\":\"c46dac98aad5ae64b79ed0642e2c32e46e8e0b753fa9a40af60f82825ec49c378f34d04cbdb03d2415ed1dc592f3866c\",\"sqr\":\"FEF2351 2024-07-03 22:25:55-05:00 19385248 222222222222 32407.41 0.00 2592.60 39000.01 c46dac98aad5ae64b79ed0642e2c32e46e8e0b753fa9a40af60f82825ec49c378f34d04cbdb03d2415ed1dc592f3866c https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=c46dac98aad5ae64b79ed0642e2c32e46e8e0b753fa9a40af60f82825ec49c378f34d04cbdb03d2415ed1dc592f3866c\",\"ssignature\":\"tbfOqhc0hyEMUTu23CKi3LhO6OmyyyuoohL1sG2nker4VNWngb99qwLabiCg2HSqDWwxCHtHYu3DclHxHfWSFVVOLRmGbl0B6737I9NalVx/nZucHnEJ7pbVvkyEWviuDeILB83MIzr6Ng8ECC5V3GHY61jWQ1gOlN82fsFD2W9zJthc7fSxwV1ptGOaqngsRe0SAJdqoZuUelSHwQe4Sz4tESyvd+y3biN7G+hN/0Rp15ECgaYTsEvtcITmpkj9MSGmKBzGhlP0PeB29gAmjj1Uy9AQwac34sZiG72JqMbeWOVtD1RyFPE5m7JjRQVeLsZ+EEpAap9tx1sZDilw5Q==\",\"sdocumentreference\":\"FEF2351\",\"rtaxxadocument\":\"85742257\",\"sref\":\"85742257\",\"irefindex\":2351},\"sdebug\":\"Taxxa: 0.214s DIAN: 1.41s (creación 1.061s, revalidación 0.35s)\"}', 46926, NULL),
(767, '2024-07-03 22:26: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-03\",\r\n               \"tduedate\":\"2024-07-03\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2352,\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\":\" 3216446547\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"AV BOLIVAR 28Norte -61 CONJUNTO LA HACIENDA CASA 12\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46927\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"16\",\r\n                         \"namount\": 5000,\r\n                         \"nbaseamount\": 28703.7037037037\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613058\",\r\n                  \"scustomname\":\"BANDEJA SIN SOPA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14351.851851852,\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\":\"00613063\",\r\n                  \"scustomname\":\"BANDEJA SIN SOPA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14351.851851852,\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   ', 46927, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(768, '2024-07-03 22:26: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\":\"811f6a27ae4d3bc344d731058c968e8658bb87efdbac0de3d8d0309b202b81593b8f06c4a98f186095f7cef2322745d8\",\"sqr\":\"FEF2352 2024-07-03 22:26:05-05:00 19385248 222222222222 28703.70 0.00 2296.30 36000.00 811f6a27ae4d3bc344d731058c968e8658bb87efdbac0de3d8d0309b202b81593b8f06c4a98f186095f7cef2322745d8 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=811f6a27ae4d3bc344d731058c968e8658bb87efdbac0de3d8d0309b202b81593b8f06c4a98f186095f7cef2322745d8\",\"ssignature\":\"dcTr1WTk5E34d0FgARLJIHeg6ovayb75iKcaR5FcxorkBHt9KCIjPXb9+4lazO21nWCw3lOuyghKTVdvbxmC1xD+qFnCM7KSDus1PI/zI0keLbji+I3lPUhd1AzCNJPLBCO/lDg5n7B+QwTbyh1kI87tCOUp9fdjTfruecIXIlqFX/P8zmddL6y5F7WkgjofV1kYkOciqo5hcDwVYxaSfO6anSnOUxUMFfmHN85VgBLNusaLguMngIbTdYjCa7yliVrk95a7L1XrGtj5NivfdBJIy8UlALD8RC2GpZzzG1vGgiU75XgIpzxLp1+zXIZ+R4+QHv/rZYUKEx9B3/+/Ew==\",\"sdocumentreference\":\"FEF2352\",\"rtaxxadocument\":\"85742290\",\"sref\":\"85742290\",\"irefindex\":2352},\"sdebug\":\"Taxxa: 0.179s DIAN: 1.875s (creación 1.184s, revalidación 0.691s)\"}', 46927, NULL),
(769, '2024-07-03 22:26: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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2353,\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: 46928\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613073\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"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   ', 46928, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(770, '2024-07-03 22:26: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\":\"ed99861b63babfd4a3a7addb414aeeb711a92eaad1291c44d86bf6a1c3d6f2a514efcbc8e13e1255607a13dfc6815818\",\"sqr\":\"FEF2353 2024-07-03 22:26:11-05:00 19385248 222222222222 21296.30 0.00 1703.70 23000.00 ed99861b63babfd4a3a7addb414aeeb711a92eaad1291c44d86bf6a1c3d6f2a514efcbc8e13e1255607a13dfc6815818 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=ed99861b63babfd4a3a7addb414aeeb711a92eaad1291c44d86bf6a1c3d6f2a514efcbc8e13e1255607a13dfc6815818\",\"ssignature\":\"B7Zfg8jJJP1k9cRXlr15PGYQrC4ZAn9DdVyoJqscbz7FeswNYKm6xcKaT9Q7e/HLbiuZUE6NqJH71p8YNVPDH2Gdfs4Kf32vy05s/QFLQfbp1NwVgJjjCaSObh9WU+COcw1ca7bNA2WGRbDyAREAsbDUCr59hgg05T8KgloNodEQ3ZIkZNGge9xQn1ZvLDUC9LVG7ZVSWnBiEDmyN7Vo5lYSIkDChuDVVBmsgKcPpXJuOZq6fGi2gKwtodwsZWcRPmNdFgJHWJOdaZXGXZPBHHqr4M5AbNtyopufxuCuNVNsQkpSwMayg9V51pC/7Ts8ZITVVrbpNldTvD6gywUauA==\",\"sdocumentreference\":\"FEF2353\",\"rtaxxadocument\":\"85742310\",\"sref\":\"85742310\",\"irefindex\":2353},\"sdebug\":\"Taxxa: 0.173s DIAN: 0.921s (creación 0.636s, revalidación 0.285s)\"}', 46928, NULL),
(771, '2024-07-03 22:26:21', '{\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-03\",\r\n               \"tduedate\":\"2024-07-03\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2354,\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\":\" 3163334331\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"conjunto castellon casa j4\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46929\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"11\",\r\n                         \"namount\": 4000,\r\n                         \"nbaseamount\": 32407.407407407405\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613076\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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\":\"00613082\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 46929, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(772, '2024-07-03 22:26:21', '{\"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\":\"7c2b22a0f6829e5122bd47d4644de00ad8f5fdf33d82867ac83af9bfdd87662d56cafbac12153731cffb6697c213b008\",\"sqr\":\"FEF2354 2024-07-03 22:26:23-05:00 19385248 222222222222 32407.41 0.00 2592.60 39000.01 7c2b22a0f6829e5122bd47d4644de00ad8f5fdf33d82867ac83af9bfdd87662d56cafbac12153731cffb6697c213b008 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=7c2b22a0f6829e5122bd47d4644de00ad8f5fdf33d82867ac83af9bfdd87662d56cafbac12153731cffb6697c213b008\",\"ssignature\":\"Yq9L2SLeUKfT0OcTZWzKFi49PqUeKo/zzuoGRoIn1diOpsoGdeX5QJgK2m0BpuSrl5LUTpFkNSVyzg0+7dal7gqeis3bF/M+069vElGRB6cofVfK0lamh5Mrl1kE3Yl7lNAh/0A5GATzRVLKvkQXg6NQZl6E8wNX1oukVSRZsWLp87BquA80nUTDjV2ESk+47ojLzvuEn+2aGP/E8rgEqMNo/EivDBwV9HvueQLAS0Ib+6dTlHw296zGncEwkoavDcJKazpQfkD/CkHhu5qR1C9ekZNUNjZXeoEArd+oNm/5/BkLGTSiitMNCboVjprA3QRAtHbVUdQ78StYrQAmng==\",\"sdocumentreference\":\"FEF2354\",\"rtaxxadocument\":\"85742334\",\"sref\":\"85742334\",\"irefindex\":2354},\"sdebug\":\"Taxxa: 0.16s DIAN: 1.418s (creación 1.086s, revalidación 0.332s)\"}', 46929, NULL),
(773, '2024-07-03 22:26: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-03\",\r\n               \"tduedate\":\"2024-07-03\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2355,\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\":\" 3053237193\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"ALTOS DE AGUABONITA TORRI 5 APTO 211\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46930\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"11\",\r\n                         \"namount\": 4000,\r\n                         \"nbaseamount\": 32407.407407407405\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613091\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 46930, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(774, '2024-07-03 22:26: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\":\"933aad724d445311858e54f049245b7d5d3146c9d3c32e7644c258ff8de4254054e515f9b698a627bfc7819c4608b0b7\",\"sqr\":\"FEF2355 2024-07-03 22:26:29-05:00 19385248 222222222222 32407.41 0.00 2592.59 39000.00 933aad724d445311858e54f049245b7d5d3146c9d3c32e7644c258ff8de4254054e515f9b698a627bfc7819c4608b0b7 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=933aad724d445311858e54f049245b7d5d3146c9d3c32e7644c258ff8de4254054e515f9b698a627bfc7819c4608b0b7\",\"ssignature\":\"akj0FelGUUeZ2lYMF1Dr9gDEunp4Q4JCqo6MMfkTUUKLIusWZ6sK4U61090Nd+NkTMiX4RS3wXlX+4x5ppsUMXgXg99A2M4/qXGUneWzP4VRi/qQgoUiuZveQfuwYxuMjyi5sf8P7XvT7KhVY3qZvpxX404qqtBoGTs5F1IXHdI0v6Z3bpphAZv77GEqQsh+ZmTe9YbjIoWV73GPZG1mOPMJ4TRH3CWEfqHLOdFEVNlMdLseCOqHJMe928VyXxWNK2XWVszWU+uHOZUgwUgr2bCfPLNvj03V1KFaR1bc2v6Iwets82wlYckafQIhHONfIoYhwgs2DzNfaNIqeYfRPw==\",\"sdocumentreference\":\"FEF2355\",\"rtaxxadocument\":\"85742352\",\"sref\":\"85742352\",\"irefindex\":2355},\"sdebug\":\"Taxxa: 0.113s DIAN: 1.066s (creación 0.704s, revalidación 0.362s)\"}', 46930, NULL),
(775, '2024-07-03 22:26: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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2356,\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: 46931\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613098\",\r\n                  \"scustomname\":\"BANDEJA SIN SOPA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14351.851851852,\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   ', 46931, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(776, '2024-07-03 22:26: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\":\"05cadcf73a41294bef758ef689fd72a248989cafd091f7391b2fd7ce657693241e220304a14b7e19ab9d3f7b23bda2ac\",\"sqr\":\"FEF2356 2024-07-03 22:26:37-05:00 19385248 222222222222 14351.85 0.00 1148.15 15500.00 05cadcf73a41294bef758ef689fd72a248989cafd091f7391b2fd7ce657693241e220304a14b7e19ab9d3f7b23bda2ac https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=05cadcf73a41294bef758ef689fd72a248989cafd091f7391b2fd7ce657693241e220304a14b7e19ab9d3f7b23bda2ac\",\"ssignature\":\"GDiIESFfJdxE0w818ZW0UysXCZ6aNi3jBUJSM8QCvrkU00X2X9LZcotDrCiaw9wMHVl6aM4uHhxECPiuFtyNAh5/D+TPZ147fM/MOMCrk/RX3vksmLNSd4DhBp/HIz1YjbCGsj3qyzLnBYcnddfsKBHXgNDfb7EJbls+il1vHyabGrJQqSdZW2kwsVXgR6iEPj08EwEngumpjEJej3zHEP/F4tp/mGvyqSFG7yD0aV5Ivgig0sTFPm/FVgMt2wlomLpONKN8yfp9qJ07E/z0nqxPdbKA1LZplxkQNWI7JAYO5We7GD9LStO/hUoUSK8RSxZQDud+jKvChI4PCGV/WA==\",\"sdocumentreference\":\"FEF2356\",\"rtaxxadocument\":\"85742374\",\"sref\":\"85742374\",\"irefindex\":2356},\"sdebug\":\"Taxxa: 0.234s DIAN: 1.355s (creación 0.779s, revalidación 0.576s)\"}', 46931, NULL),
(777, '2024-07-03 22:26:40', '{\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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2357,\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: 46932\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613105\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 46932, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(778, '2024-07-03 22:26:40', '{\"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\":\"9248fc3300b7ddb09880567b95d1a8bb3e3b9f075da08c201f23788a54deaa07c6c08870dd6f530c92cccc2c3e0f32db\",\"sqr\":\"FEF2357 2024-07-03 22:26:42-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 9248fc3300b7ddb09880567b95d1a8bb3e3b9f075da08c201f23788a54deaa07c6c08870dd6f530c92cccc2c3e0f32db https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9248fc3300b7ddb09880567b95d1a8bb3e3b9f075da08c201f23788a54deaa07c6c08870dd6f530c92cccc2c3e0f32db\",\"ssignature\":\"Ikb1pw9A+alXXW4vW59eo7DxKDMCQYUZtEODsHGcwUkFaMFL4pnl+PpSo7cMgOLDOcv5ww6BJdmWetK0r413izzaHiUFRkGE1JscvtLGxkLxZNjfElaLqy91n2STLenYKPph85WkGsIwuYkNPqMbHFs3h7v4MX46+3RWtPrST/odEwObhOi+2Ttck4SivsFDnBz2OdOOD9XB3Lj+T4dATAySNPrH/sFGfQY+R6hz7s8l2ACRCAEOhyaTYYmr7vp1Wqah0+Re5xnp2A+bo/XN4BMiVvTCUwhApYKPrqsjisfwahi64S9qDQUjogmHssLFJJ5PhUCX4xpTidV/GYFc7w==\",\"sdocumentreference\":\"FEF2357\",\"rtaxxadocument\":\"85742397\",\"sref\":\"85742397\",\"irefindex\":2357},\"sdebug\":\"Taxxa: 0.217s DIAN: 1.009s (creación 0.67s, revalidación 0.339s)\"}', 46932, NULL),
(779, '2024-07-03 22:26:47', '{\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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2358,\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: 46933\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613112\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 46933, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(780, '2024-07-03 22:26:47', '{\"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\":\"1093a203904e5bfba0d9cfd7c61bc06e63e768934b920fd6dcb3dcdc9f5e51c4c345c1b33d81c02b28fe9fadca87d98e\",\"sqr\":\"FEF2358 2024-07-03 22:26:49-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 1093a203904e5bfba0d9cfd7c61bc06e63e768934b920fd6dcb3dcdc9f5e51c4c345c1b33d81c02b28fe9fadca87d98e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=1093a203904e5bfba0d9cfd7c61bc06e63e768934b920fd6dcb3dcdc9f5e51c4c345c1b33d81c02b28fe9fadca87d98e\",\"ssignature\":\"e4X7mGK+uWTuppb9ta6t4sIf2/Zbp1HPclwcvNaxxWeRNDZ3mgj6i8rYI7nYRTwqkUHsV4FLTvaQ0nLOp28OB4GL5iAc2uB1RXg1AfjD2/43fbsVKDi9H13ocgqoOLojGhFMd2UJYAVqE3ZBKxbm1khVmQn72mtwQnkaZR8W5E2fO2RWjFEISJtkr4KwseiinSjcp0omcW2Yt5m1PX5VlTOhUTFfG/F+H3tiBwohe3UZusayLY83h8k4vxj9JhzHVL2SiPz6BWBFOmeVrj/+d3/aqCFNW7zzk7JjzqfkHcj6aXIO9EaSsXGk1lOEWhIvJ/ogFn25TvGgZJTZO/92tA==\",\"sdocumentreference\":\"FEF2358\",\"rtaxxadocument\":\"85742413\",\"sref\":\"85742413\",\"irefindex\":2358},\"sdebug\":\"Taxxa: 0.19s DIAN: 1.405s (creación 1.047s, revalidación 0.358s)\"}', 46933, NULL),
(781, '2024-07-03 22:26: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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2359,\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: 46934\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613119\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 46934, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(782, '2024-07-03 22:26: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\":\"531f6a7bdf8149c4d0f7b9f0243ce5e182bf4bd2f678d8b16d8ca6a743f54d23ae9bca1b706c45d4dececcb66d5393c7\",\"sqr\":\"FEF2359 2024-07-03 22:26:55-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 531f6a7bdf8149c4d0f7b9f0243ce5e182bf4bd2f678d8b16d8ca6a743f54d23ae9bca1b706c45d4dececcb66d5393c7 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=531f6a7bdf8149c4d0f7b9f0243ce5e182bf4bd2f678d8b16d8ca6a743f54d23ae9bca1b706c45d4dececcb66d5393c7\",\"ssignature\":\"nKO4kSKd2rwPzc26+G9ZBpZr/P7GdvVEPMUtdO+JQo8zSE1svlVK7fbH9T7wJPxU8cizrRdmatZ8hyrEjMNJ6cUi35JY+NZ+JkZCWm5eYIbNea+nkvuon8w+WRCXsQzVYjP6uSDUzcBGgPakQ4i1jvSX65MJSPSvav+mJK7GGG+tymx10cTnhBTe4Qp5i9ixolXhzxIrQi4zzpIRb9GidE5xn42/6UsuBH3zpRUW3Lhi3l4UwvCHntXgcYL2Tn5lF20NoE+HrSIPcDnLr43JOI8c2VU7zOY4Koq261U5CAW8PkeBwGn2XGEUMtHXfSOuLAIVD9sKERmqR1B4fUfaAA==\",\"sdocumentreference\":\"FEF2359\",\"rtaxxadocument\":\"85742427\",\"sref\":\"85742427\",\"irefindex\":2359},\"sdebug\":\"Taxxa: 0.187s DIAN: 0.986s (creación 0.7s, revalidación 0.286s)\"}', 46934, NULL),
(783, '2024-07-03 22:27:01', '{\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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2360,\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: 46935\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613126\",\r\n                  \"scustomname\":\"BANDEJA SIN SOPA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14351.851851852,\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\":\"00613131\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 46935, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(784, '2024-07-03 22:27:01', '{\"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\":\"8fa49e2b5baafbd60e32260b8d27e176beb566baec10283c04599030f7b53bd651ef75ba8b71c77efb76de991b46e507\",\"sqr\":\"FEF2360 2024-07-03 22:27:03-05:00 19385248 222222222222 30555.56 0.00 2444.45 33000.01 8fa49e2b5baafbd60e32260b8d27e176beb566baec10283c04599030f7b53bd651ef75ba8b71c77efb76de991b46e507 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=8fa49e2b5baafbd60e32260b8d27e176beb566baec10283c04599030f7b53bd651ef75ba8b71c77efb76de991b46e507\",\"ssignature\":\"HE3qP295HCbS4kEtU5xn8z2IEvjtCo+kY+ExQvYwvlZYKw7QevNVZg9NomZhWANfvTl/qRzrZHHfm7ZBpE7mkp7VjsY8Ghrf0Bdz6Ds4q8XzhgnghepkkAwnHHk3uaG0p5XoAQD+r3zZld//BbuGa3P1ZwZRZNU29X/Rf5HBpDCh287tEnUWndetscAT9iBCBbd0gsLM7lunatnrA6JWCDYHg6mDYtjgQp8dmMH6TGZ+BnrveGqUpf8rOO3RAUfMKa6TM7/sHYol0xWKGyg3RoOKrFEsSQzsaUP6L9XU0hQ8WuqI7K7pcmLNt2FgV53e4skZ6xOOXmkUJgdXvJ1bCQ==\",\"sdocumentreference\":\"FEF2360\",\"rtaxxadocument\":\"85742453\",\"sref\":\"85742453\",\"irefindex\":2360},\"sdebug\":\"Taxxa: 0.199s DIAN: 1.291s (creación 0.984s, revalidación 0.307s)\"}', 46935, NULL),
(785, '2024-07-03 22:27:06', '{\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-03\",\r\n               \"tduedate\":\"2024-07-03\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2361,\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\":\" 3011690428\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CLINICA DEL CAFE \",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46936\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613141\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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\":\"00613147\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 46936, NULL);
