INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1024, '2024-07-05 22:32: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: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"1ee7f0e36f2304b46fb002762d9c7e3db28f16c7735ee0bd0651ecd87119a0ba075e678423e09adef7d03314bf46e3c6\",\"sqr\":\"FEF2480 2024-07-05 22:32:33-05:00 19385248 222222222222 87962.96 0.00 7037.04 99000.00 1ee7f0e36f2304b46fb002762d9c7e3db28f16c7735ee0bd0651ecd87119a0ba075e678423e09adef7d03314bf46e3c6 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=1ee7f0e36f2304b46fb002762d9c7e3db28f16c7735ee0bd0651ecd87119a0ba075e678423e09adef7d03314bf46e3c6\",\"ssignature\":\"cHndATr8I+K/Wa/umZvB41FW4XzdYTjrVyeHPZB2zDGe6eLzupr7o2zkxATD5Bd2WI+hmoVgShp4DLDZvzbXL0dr+sy964KZWz9Y46UJXiQPPinc70SZyxoSRrwhdvOztPpOmJqHqwxsqN35ZYGseybnx3dAmlytioCTJMlJjUyj2ySSC+UqM4PFnFjZIeQQsPT1wu24c0FFOj3a2t1r5NkVcbxZs6gyF7AEjoENZI/Azwmgahd+Hx+LEN9i+I239C0fKy5nL4jcKv4ojMCfAn7QoNLNr1n89vsq4Thff64kzwgrEtJnGWVQulGDSy5AuzYKgrXKiPO8RiRY7mZwIw==\",\"sdocumentreference\":\"FEF2480\",\"rtaxxadocument\":\"86402699\",\"sref\":\"86402699\",\"irefindex\":2480},\"sdebug\":\"Taxxa: 0.266s DIAN: 0.877s (creación 0.595s, revalidación 0.282s)\"}', 47128, NULL),
(1025, '2024-07-05 22:32:36', '{\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-05\",\r\n               \"tduedate\":\"2024-07-05\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2481,\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\":\" 3222062559\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CLINICA SAN JUAN DE DIOS QUIROFANOS \",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47129\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"15\",\r\n                         \"namount\": 4000,\r\n                         \"nbaseamount\": 25000\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615344\",\r\n                  \"scustomname\":\"CARNE ENTERA 320gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":25000,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47129, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1026, '2024-07-05 22:32:36', '{\"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\":\"43522b2bac103eef288e0bade268309f0939fb62703ba2c851652dd9febc432bbb512a27ee3a02305a96d9b950d8dc20\",\"sqr\":\"FEF2481 2024-07-05 22:32:38-05:00 19385248 222222222222 25000.00 0.00 2000.00 31000.00 43522b2bac103eef288e0bade268309f0939fb62703ba2c851652dd9febc432bbb512a27ee3a02305a96d9b950d8dc20 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=43522b2bac103eef288e0bade268309f0939fb62703ba2c851652dd9febc432bbb512a27ee3a02305a96d9b950d8dc20\",\"ssignature\":\"MS4+8efgICZFQKHtytjnurUrc8frFzOznDL4/NyStprWqHOvA9H2K5wdAsn8/csRD+HP5fPFTkDjZASCfQXtW9XFGRl7vtPauJRuUFl4B+XYYnxqFwRQ73PhNkgHrqu0vHuJv8hfL5wqGZbyMUx3z5IGDwdB+yLbWAam604Iim5V5opunvKiqwM4AaoRATKeoAIOPF/9RkzTtPJEfGs9MywXwtsYmR2CUGJHgP9vua/ufabA5qJGMxVS5efENv8Qo4CE+TS1HkOqAwvlignLv2BDMOqSQD942b4t95T/p2MeHck/VGhBCCAxU8Gyk6vy5lMACmJfbzfTyRwFSFrQ3A==\",\"sdocumentreference\":\"FEF2481\",\"rtaxxadocument\":\"86402712\",\"sref\":\"86402712\",\"irefindex\":2481},\"sdebug\":\"Taxxa: 0.171s DIAN: 1.046s (creación 0.686s, revalidación 0.36s)\"}', 47129, NULL),
(1027, '2024-07-05 22:32: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-05\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2482,\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: 47136\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615421\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00615425\",\r\n                  \"scustomname\":\"LIMONADA NATURAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6481.4814814815,\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   ', 47136, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1028, '2024-07-05 22:32: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\":\"425c2811214055ee179173e13277fa5b170f17adc7fa55709e3d1d60eaf5469928c16ac51bcb2e219d6fb635905f5992\",\"sqr\":\"FEF2482 2024-07-05 22:32:46-05:00 19385248 222222222222 30555.56 0.00 2444.45 33000.01 425c2811214055ee179173e13277fa5b170f17adc7fa55709e3d1d60eaf5469928c16ac51bcb2e219d6fb635905f5992 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=425c2811214055ee179173e13277fa5b170f17adc7fa55709e3d1d60eaf5469928c16ac51bcb2e219d6fb635905f5992\",\"ssignature\":\"ncYAhGSbw2mM8MJjbBoqCucRpjh7bNF0+nEUTc+HkL2Ym+wRjhsB1nHfluI/Bmt7SZp2IQ2OmJuTrozZYslVnAAJCmqNlIn6+vASpJAxGX7gv2cd/qH7dKQcYD+izmMhSbOYOj0CUfZ4/be4uHMChf7UcSH6Nh7I8/Gxsv1GM5SloE7lhCZtudQ0AoaRWywlFrLuUUPA74Xe4+7kHxwvKxwW5YfGo81wVPFHBXQX72068BEGq7toKurkEXrgEtuq9VamhbcOVgeYCGy1mFo4QgPus3ISV9hoEKgl1UrHBFwFYEOQmIp0dS/b10b4he4totv7nY1P6Yhy1v77NKTsqw==\",\"sdocumentreference\":\"FEF2482\",\"rtaxxadocument\":\"86402731\",\"sref\":\"86402731\",\"irefindex\":2482},\"sdebug\":\"Taxxa: 0.245s DIAN: 1.043s (creación 0.671s, revalidación 0.372s)\"}', 47136, NULL),
(1029, '2024-07-05 22:32: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-05\",\r\n               \"tduedate\":\"2024-07-05\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2483,\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\":\" 3104640519\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CRA 13 16 45 EDIFICIO TORRES DE LOS ANDES TORRE A APTO 301\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47138\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"6\",\r\n                         \"namount\": 3000,\r\n                         \"nbaseamount\": 48148.148148148146\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615443\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\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   ', 47138, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1030, '2024-07-05 22:32:48', '{\"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\":\"0165f7d8068dc2f5ff3cf991558baa4c62a71e8793cb0150c5275f89540cc0476f4a4c784545123e0d9ff7a678f38d38\",\"sqr\":\"FEF2483 2024-07-05 22:32:50-05:00 19385248 222222222222 48148.15 0.00 3851.85 55000.00 0165f7d8068dc2f5ff3cf991558baa4c62a71e8793cb0150c5275f89540cc0476f4a4c784545123e0d9ff7a678f38d38 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=0165f7d8068dc2f5ff3cf991558baa4c62a71e8793cb0150c5275f89540cc0476f4a4c784545123e0d9ff7a678f38d38\",\"ssignature\":\"W8r9TdnCNlc55nZ6yfb4mvbniKM8AoXVoyJiWgkZtfdNb9VaFOaLmoRVVIWAEhgHGlEbcJzPW/mgHYkxnOdaEa7m/skcfgj4lqepm8Vp0KGlc1BqqQHZqLde9vu1MTh8MxKmWmA082ubznkquPbP1HWYEE3jqeMStRcZXGnMIvnhSoIUQDi5vNrFX1hm9YWcU6tNWT1BYeB7IC9/e8Cfk4C9+2Vbg5XgiKkQ7CiOnakWh3SIM+4w2S0nmMioUn8c6uq6wabQ5FT4fTnCUkmVT5ImSn2d7u1PxXXE/65Qh6dpgFjQMcp6DizeIQ5VUsne7F9ol9S2A37sLS+zYSiUTQ==\",\"sdocumentreference\":\"FEF2483\",\"rtaxxadocument\":\"86402743\",\"sref\":\"86402743\",\"irefindex\":2483},\"sdebug\":\"Taxxa: 0.183s DIAN: 0.945s (creación 0.637s, revalidación 0.309s)\"}', 47138, NULL),
(1031, '2024-07-05 22:32:59', '{\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-05\",\r\n               \"tduedate\":\"2024-07-05\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2484,\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: 47141\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"10\",\r\n                         \"namount\": 5000,\r\n                         \"nbaseamount\": 45370.370370370365\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615480\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00615484\",\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   ', 47141, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1032, '2024-07-05 22:32:59', '{\"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\":\"6752817feba0146be963017c600c5e3ff56b856ba2020a2da8a41cc69a1b052cce233448d8709189ed4fe38d8a9f6fe1\",\"sqr\":\"FEF2484 2024-07-05 22:33:01-05:00 19385248 222222222222 45370.37 0.00 3629.63 54000.00 6752817feba0146be963017c600c5e3ff56b856ba2020a2da8a41cc69a1b052cce233448d8709189ed4fe38d8a9f6fe1 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=6752817feba0146be963017c600c5e3ff56b856ba2020a2da8a41cc69a1b052cce233448d8709189ed4fe38d8a9f6fe1\",\"ssignature\":\"nzktZhX+Szwj+/WJj7YQJ9jEagZwmaDxJvgQENU/r28U2+jhs77Ue3YMbAfgBlp0ETcflHRw8VXpOEgU5eldxVyUsvAxuuMQeKF/eXU6Nd3mD7beBXUpXbViO1SoY4Ke5KdomgPu1ruSop64WrdxP2VX0MclOWuxsnwTFsj4Qs5x8zuMCyCrabLx7Wl7dWomFHB7IGdrztk0o4CiBhz4/ekwbLxytLxBlg5z3sf6A8iTX4pJ722uJs4G/sGD5A7SKmRW4l9iqLc6fOpiPnTVEUNvBvlhc/omcfFsm8d241VNVJAXa7d3M9MR4pI5hy8Z5SpHs9NTKwRmSCEuUgMXWQ==\",\"sdocumentreference\":\"FEF2484\",\"rtaxxadocument\":\"86402773\",\"sref\":\"86402773\",\"irefindex\":2484},\"sdebug\":\"Taxxa: 0.218s DIAN: 1.032s (creación 0.733s, revalidación 0.299s)\"}', 47141, NULL),
(1033, '2024-07-05 22:33:04', '{\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-05\",\r\n               \"tduedate\":\"2024-07-05\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2485,\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\":\" 3155012426\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CONDOMINIO IBERICA  BLOQUE 3 APTO 502 \",\r\n                        \"szip\":\"630003\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47146\"\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\": 4000,\r\n                         \"nbaseamount\": 21296.296296296296\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615547\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\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   ', 47146, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1034, '2024-07-05 22:33:04', '{\"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\":\"3280678d22614f428d45ce352daa8b4b9850d15ba2e82931ce5dee4b473a6caf8ae622f5b3c5a2507f14f0d09a214bdc\",\"sqr\":\"FEF2485 2024-07-05 22:33:06-05:00 19385248 222222222222 21296.30 0.00 1703.70 27000.00 3280678d22614f428d45ce352daa8b4b9850d15ba2e82931ce5dee4b473a6caf8ae622f5b3c5a2507f14f0d09a214bdc https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=3280678d22614f428d45ce352daa8b4b9850d15ba2e82931ce5dee4b473a6caf8ae622f5b3c5a2507f14f0d09a214bdc\",\"ssignature\":\"ivDYnKjAV23U2BpSKytwGLtJ6244aSFwNpi1QGy1M/V3JFx2CC495+EASYkKDmUTpX4L9j89Iz6RC8pxElk39ql9OAgfb281+kwVMhzLso8K1mBZAVo01LwdRVS1wRtBlaTDjODZU+bqAbwulikCswLhQWGYHW1vbacyvBlCDrOB8P108VqS/5LcKAQroWkgS199IBpdgT0NdgaFhLuROzgWVkISPoVbmbyD9XUtq5fTZXMU1028PIync9ZGjcSXJiryaBDb6AFcR+yGnJ/UwIGBcUYMPxaBxzOdvPpKMyPl4RBpTEJN8fZdvsFysbIprxSxKpBINXP+T7JwUcj5qg==\",\"sdocumentreference\":\"FEF2485\",\"rtaxxadocument\":\"86402787\",\"sref\":\"86402787\",\"irefindex\":2485},\"sdebug\":\"Taxxa: 0.266s DIAN: 1.001s (creación 0.657s, revalidación 0.344s)\"}', 47146, NULL),
(1035, '2024-07-06 22:54:02', '{\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-06\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2486,\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\":\" 3165855567\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"MZ E CASA 5\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47151\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"23\",\r\n                         \"namount\": 4000,\r\n                         \"nbaseamount\": 16203.703703703703\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615611\",\r\n                  \"scustomname\":\"EJECUTIVO SABADO\",\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   ', 47151, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1036, '2024-07-06 22:54:02', '{\"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\":\"14d2794829ea12cd9db6e2e40cc701f712067e20ff18a78cf171e0273700b78145a327e309fea2d4b1752333f9b64ffd\",\"sqr\":\"FEF2486 2024-07-06 22:54:04-05:00 19385248 222222222222 16203.70 0.00 1296.30 21500.00 14d2794829ea12cd9db6e2e40cc701f712067e20ff18a78cf171e0273700b78145a327e309fea2d4b1752333f9b64ffd https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=14d2794829ea12cd9db6e2e40cc701f712067e20ff18a78cf171e0273700b78145a327e309fea2d4b1752333f9b64ffd\",\"ssignature\":\"YtaA4hVKK4I70Hfxc4Jqo7mm7Qzm2l7S9Wn4uLp8OwjYS/lA29ayflhCkrkMp/zziUHhaKMhu2HeDu/Qdl/uI91uq1b4L0q2IwsMo9557bdSiLLR2ZbFomCgq6QdEWVQlPqpzJO+ErrS+zsH9MaGzXlBeJ6oAHsrvHaJx2yK1qc1deKwd45G554ivpEFPMPufB/2iGHuGPBnvuxjuVC5eiLWqetyYtz9moKW/6EwJiudn4Pn86REIXzjC0ZaaR+M40hp5A2jHyk9puQivprKDYBqouHskKd9POqnZgwlucR1PBnpSA3faBfkpfchVDPXrEmpfUj+rUqdA+c39DALmw==\",\"sdocumentreference\":\"FEF2486\",\"rtaxxadocument\":\"86709772\",\"sref\":\"86709772\",\"irefindex\":2486},\"sdebug\":\"Taxxa: 0.172s DIAN: 1s (creación 0.703s, revalidación 0.297s)\"}', 47151, NULL),
(1037, '2024-07-06 22:54:07', '{\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-06\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2487,\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\":\" 3001617355\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"EL PLACER MZ L CASA 266 \",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47152\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"15\",\r\n                         \"namount\": 4000,\r\n                         \"nbaseamount\": 25000\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615618\",\r\n                  \"scustomname\":\"CARNE ENTERA 320gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":25000,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47152, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1038, '2024-07-06 22:54:07', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"f187a0202b5513864922b2bd2bd5d7a486225fdc315fe00ebfc82080e0fdd39a0179be62929036de737c0bde40874c86\",\"sqr\":\"FEF2487 2024-07-06 22:54:09-05:00 19385248 222222222222 25000.00 0.00 2000.00 31000.00 f187a0202b5513864922b2bd2bd5d7a486225fdc315fe00ebfc82080e0fdd39a0179be62929036de737c0bde40874c86 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=f187a0202b5513864922b2bd2bd5d7a486225fdc315fe00ebfc82080e0fdd39a0179be62929036de737c0bde40874c86\",\"ssignature\":\"aReVAdWgMWbeAjibINFAszP4mQ9QaIvZ4ba0a+ft+wAezXFeu8FvVbXKwKiYDiT4/+raqqW/mDiMXd4pF0nsRKC0W/yBRBim/RM+bcBL1iK8/5w/tvIKwzQ7lQCkVHFJ/r+VpXQhQdTzVUtjIbd+QR8zXn/zqMwPmG11XWBiL5XXtucbcCCfgHEFzKgKbSbC7YM566QXw/CJpWmvHvYDh2AzJcJ9vYQaZtY/nSduWXVjoDz6HFNjU4wPaRBnRMrd27HE5658wJ4plqBhbjHbRQ+dugbELcFija5n6zHMkGg3uZxS5rHBTMDKDiW3CQWaErQUZhvlwSaGJAglXZ2MOA==\",\"sdocumentreference\":\"FEF2487\",\"rtaxxadocument\":\"86709778\",\"sref\":\"86709778\",\"irefindex\":2487},\"sdebug\":\"Taxxa: 0.219s DIAN: 1.047s (creación 0.719s, revalidación 0.328s)\"}', 47152, NULL),
(1039, '2024-07-06 22:54:13', '{\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-06\",\r\n               \"tduedate\":\"2024-07-13\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2488,\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: 47155\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615640\",\r\n                  \"scustomname\":\"EJECUTIVO SABADO\",\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   ', 47155, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1040, '2024-07-06 22:54:13', '{\"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\":\"bdcef76bf138e7722f5bca7cc695e381cd9047f7a74e619479b0d6ae8c4884e7a12493e739fedc51550c09b5165e2f24\",\"sqr\":\"FEF2488 2024-07-06 22:54:15-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 bdcef76bf138e7722f5bca7cc695e381cd9047f7a74e619479b0d6ae8c4884e7a12493e739fedc51550c09b5165e2f24 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=bdcef76bf138e7722f5bca7cc695e381cd9047f7a74e619479b0d6ae8c4884e7a12493e739fedc51550c09b5165e2f24\",\"ssignature\":\"A/7xSoAkDetY6iCw+E+QQlIqlwyrdMqWds6TlPRjxM9h0Zqz+lu+8qzoA4N7ARWhGgJLFLnV06VeUfttdvp77eincbjNtQdXE3hGsxYaVSpsi+soY88JpaZm5gbK3eljwrOUGrZnIjL0pePmvlE/E9Wd/t50m76DBeuHI9jRsFWOIv+R3uR/czB7F/V/p9Jmd6XfoDbh/rIh2oRIsBppQcONkWv9BpFPaxHALYEIqzWa3NvU1JB5XYTbkcniiXBhm5lI4sHVqcg7LJe9UEfmkyLRVjzfVZDtWpDNCItpMeDYsojMH2e5oh6m7c4GwQXbhFodYmb1szIZRaHJfcayrQ==\",\"sdocumentreference\":\"FEF2488\",\"rtaxxadocument\":\"86709791\",\"sref\":\"86709791\",\"irefindex\":2488},\"sdebug\":\"Taxxa: 0.297s DIAN: 0.924s (creación 0.641s, revalidación 0.283s)\"}', 47155, NULL),
(1041, '2024-07-06 22:54:18', '{\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-06\",\r\n               \"tduedate\":\"2024-07-13\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2489,\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: 47157\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615654\",\r\n                  \"scustomname\":\"EJECUTIVO SABADO\",\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\":\"00615660\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6018.5185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47157, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1042, '2024-07-06 22:54:18', '{\"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\":\"f6c2730151921e6ea215e21bed081cd0ace8b11f1c9052815989afc994a4d1f645774377156767e87337fddca4ae3ead\",\"sqr\":\"FEF2489 2024-07-06 22:54:20-05:00 19385248 222222222222 22222.22 0.00 1777.78 24000.00 f6c2730151921e6ea215e21bed081cd0ace8b11f1c9052815989afc994a4d1f645774377156767e87337fddca4ae3ead https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=f6c2730151921e6ea215e21bed081cd0ace8b11f1c9052815989afc994a4d1f645774377156767e87337fddca4ae3ead\",\"ssignature\":\"coKD48pB7l93FaSu+MHKzpkEmEdWkat2OHDOhKKlbhsUbwG2MomQAHMo2wCtTMKbYRZ8MGCZfXkffdtBzU8D+/fHgSdx5K6sy6ZAu6Z5wnsCFIhH0LYZJdSsxq+4xIDI1LinwaXyIH/kc9rQQ8IVGGhqft1TTXJSeGnbk3ejyQULCTvhzMLNpBrAit7C0GK/ce3ArFa+VYEFpGYtvnAxAmCXjnwb/wVRapbtlTZ4lBS2xoqzKf8L1wEz1KsFBTyHZU53pfecIAQTrcXmYUIFu/2oRjeg50Oxb5BHqyoYjjv6I9f16NWAr5azp9gDAV8Tr8EguKqaT6YEUOT7aHDrDA==\",\"sdocumentreference\":\"FEF2489\",\"rtaxxadocument\":\"86709810\",\"sref\":\"86709810\",\"irefindex\":2489},\"sdebug\":\"Taxxa: 0.328s DIAN: 0.875s (creación 0.578s, revalidación 0.297s)\"}', 47157, NULL),
(1043, '2024-07-06 22:54:23', '{\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-06\",\r\n               \"tduedate\":\"2024-07-13\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2490,\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: 47158\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00615661\",\r\n                  \"scustomname\":\"EJECUTIVO SABADO\",\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               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00615667\",\r\n                  \"scustomname\":\"SOPA ADICIOONAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":8055.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47158, NULL);
