INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1104, '2024-07-06 22:57:42', '{\"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\":\"f6f1349b3071edba0490802bae8da3ea9efd5ca41e3adfad5ae93bf7a11e347e7cde0b6d8c04ddd77f1cac8b02f27ffa\",\"sqr\":\"FEF2520 2024-07-06 22:57:45-05:00 19385248 222222222222 36574.07 0.00 2925.93 39500.00 f6f1349b3071edba0490802bae8da3ea9efd5ca41e3adfad5ae93bf7a11e347e7cde0b6d8c04ddd77f1cac8b02f27ffa https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=f6f1349b3071edba0490802bae8da3ea9efd5ca41e3adfad5ae93bf7a11e347e7cde0b6d8c04ddd77f1cac8b02f27ffa\",\"ssignature\":\"zlTcquCbLjl9qcGbR4zVpWYVEOhWGltOxGCLB7m9+RyRSQRtAArNodhxEHd5YQy3ROEVC+c2aF933GQfPLCOEen8vi3qnfEL+sHj7w9dFC5JeM39zdyN+FHknuZJP+LWzZON1eZlOIkLvXvrROFCy7G9cuUzC/LoqVqTTxtfKXjV+N4+dkiVizW/3xLE+WIdbOcIwXxBrUh7j/FEGZ9NEVxy08DWeGGj+DV+3bc8jZzF/3x+2YvpPU7eRa/FaHFRnxIcZ0EolZfw6mLM/NNJ+v+ZSmB1q4k4nTtwBzFHYbP6YMCsMtZ50kZi6p1ES9T40pOZDUIihhWshyXAuNHzxA==\",\"sdocumentreference\":\"FEF2520\",\"rtaxxadocument\":\"86710247\",\"sref\":\"86710247\",\"irefindex\":2520},\"sdebug\":\"Taxxa: 0.19s DIAN: 0.942s (creación 0.646s, revalidación 0.297s)\"}', 47197, NULL),
(1105, '2024-07-06 22:57: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-06\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2521,\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\":\" 3113348529\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CLLE 6 NORTE 16-25 ALIANZA FRANCESA \",\r\n                        \"szip\":\"630003\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47198\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"8\",\r\n                         \"namount\": 3000,\r\n                         \"nbaseamount\": 35185.18518518518\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616185\",\r\n                  \"scustomname\":\"HAMBURGUESA DE PROMOCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":17592.592592593,\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   ', 47198, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1106, '2024-07-06 22:57: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\":\"5c2320962c75e3dbd4e4ea733aa819b292feed186769e5fd7e6749b6ad6c4bdc87f92fd7dd21f3a7df3beb7d7006a18f\",\"sqr\":\"FEF2521 2024-07-06 22:57:49-05:00 19385248 222222222222 35185.19 0.00 2814.81 41000.00 5c2320962c75e3dbd4e4ea733aa819b292feed186769e5fd7e6749b6ad6c4bdc87f92fd7dd21f3a7df3beb7d7006a18f https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=5c2320962c75e3dbd4e4ea733aa819b292feed186769e5fd7e6749b6ad6c4bdc87f92fd7dd21f3a7df3beb7d7006a18f\",\"ssignature\":\"mFMGKn83HfGmfkBZMx13XNc7WkzdR4E+pkgwusdoTyPy5mn1DpYV70umZUxuaywj7nREderPFf39+ZJTXBF7ZUZMzWuOfyoM5hFVe7N7YtJLaIJjiqQtuhDeEkxUwBuer1O7Lot4VmBO3C0bJ4zkx71WQjxU2u8XLCWt/xvabc0mj5JY5JT1HMkH7Bvjy8btle3/5yIaMiSqykZCPqNKMc4vDQ6MOmgYUbcPnW0KdalOD5YBV2Z+WND9lWhAFy6yOHxlV4T1ER+aHWIWVvXWbZZtU2n2eOXEe8Y2xWju5TACzp2MF1Tc/iRrM78WvODkdrstxkp9Mk/nUEpgtLsqsw==\",\"sdocumentreference\":\"FEF2521\",\"rtaxxadocument\":\"86710260\",\"sref\":\"86710260\",\"irefindex\":2521},\"sdebug\":\"Taxxa: 0.172s DIAN: 0.883s (creación 0.602s, revalidación 0.281s)\"}', 47198, NULL),
(1107, '2024-07-06 22:57:52', '{\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\": 2522,\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: 47199\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616186\",\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\":\"00616192\",\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   ', 47199, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1108, '2024-07-06 22:57:52', '{\"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\":\"406c01f8d8cffaa3979d6d1152b38fd29230e1c10d6cf9610bf0f197020033739a071f82cc751f57831cf9daf71d8886\",\"sqr\":\"FEF2522 2024-07-06 22:57:55-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 406c01f8d8cffaa3979d6d1152b38fd29230e1c10d6cf9610bf0f197020033739a071f82cc751f57831cf9daf71d8886 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=406c01f8d8cffaa3979d6d1152b38fd29230e1c10d6cf9610bf0f197020033739a071f82cc751f57831cf9daf71d8886\",\"ssignature\":\"Dc8GhXRCuvXNsQ33Uws/NzjSN6bhGkt3o5ZJfjHUoI/S3+mtoPj4YHErVhiB0Jke2Or4S1P9mXcO1rjBARYILxRKRupOpFbznsOwMxcxPL5Q+kvvo8UtdKUfXqRuJ+eK2xGN6RE2jxMhM1psr2UCyxGkBffG18aRXS36nL9J6hhzT02U1AstGv7KoaC9ZZLp0LUtHlk/s7s/mO7Nf44AeuqXXlGdI0YhYVfV0VJEo/X2sgWnbV+JpoFNM29JFR/5fWTf15K+FMVAQCzek33vqpNeHMapYNgV61i9a42VZ1mL8hEJdGONcCjF6HoWWZxxDpN7MeFMyhJTMPQVgligZw==\",\"sdocumentreference\":\"FEF2522\",\"rtaxxadocument\":\"86710272\",\"sref\":\"86710272\",\"irefindex\":2522},\"sdebug\":\"Taxxa: 0.159s DIAN: 0.918s (creación 0.604s, revalidación 0.314s)\"}', 47199, NULL),
(1109, '2024-07-06 22:57:58', '{\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\": 2523,\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: 47200\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616201\",\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   ', 47200, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1110, '2024-07-06 22:57:58', '{\"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\":\"0d0e26797ae8f680d0f6418d5de5160a69a44d39c71308f61c55851e24b9463a5e2eec942ca00dda4dba4414d5b30c80\",\"sqr\":\"FEF2523 2024-07-06 22:58:00-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 0d0e26797ae8f680d0f6418d5de5160a69a44d39c71308f61c55851e24b9463a5e2eec942ca00dda4dba4414d5b30c80 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=0d0e26797ae8f680d0f6418d5de5160a69a44d39c71308f61c55851e24b9463a5e2eec942ca00dda4dba4414d5b30c80\",\"ssignature\":\"oeU09xcCrlTB3vmtf6IAGiOft7h2qqgeuZHcajwqzhAj7wUHI2OyVBVYNHbxSOYfNdUOssRCrNN4s0l8xtjfoo3bNfn0cCRC3DiRLTGcNqteCF9vNOS97mFq7oXQ3lU02nfZryVjWlDnwqu4XVMtGhzdbTxFSCy1Df7UJn9P4onHBFX8dqPbGTNUMdGQoz2Rb3f8/Qy1NALZlK+y1MstgfOmkNonUYL1PMq0KPhYob30vg/OlZHekCkVc8PliPv6nWAJO6IVeVfJRyDIzpFHgOUzTJS7knfYOn1VDRqprESxblw1ZXk735oxBv2+1I24SlXKh1UgqCirn/l6j62lAQ==\",\"sdocumentreference\":\"FEF2523\",\"rtaxxadocument\":\"86710285\",\"sref\":\"86710285\",\"irefindex\":2523},\"sdebug\":\"Taxxa: 0.25s DIAN: 0.953s (creación 0.672s, revalidación 0.281s)\"}', 47200, NULL),
(1111, '2024-07-06 22:58: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-13\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2524,\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: 47202\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616215\",\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               }},\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   ', 47202, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1112, '2024-07-06 22:58: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\":\"a04c5863b69c0ef18050041aee6fe7ff59cd614562912c2f4e0d200449fe6c4a184614b13bb614d1016f92a79512950d\",\"sqr\":\"FEF2524 2024-07-06 22:58:04-05:00 19385248 222222222222 32407.41 0.00 2592.59 35000.00 a04c5863b69c0ef18050041aee6fe7ff59cd614562912c2f4e0d200449fe6c4a184614b13bb614d1016f92a79512950d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=a04c5863b69c0ef18050041aee6fe7ff59cd614562912c2f4e0d200449fe6c4a184614b13bb614d1016f92a79512950d\",\"ssignature\":\"ku9eeCwU8fsPwQA9PpaZk5l23GMeVGQnM76LiCuQNc/6HoGSDDmuMjvN8N06oXLnKCqleS2JwUV7VgP5A9PeAICttcuKZHSYIN8jtqMqcUC5anzBt2W4Vn2Lk/Bvg4jU9TkgSqPIoxRpbXp7MRVXwMpaQ5BerszU1F+xaYk1JjhW5sZ42DjYkOp8uhO4hk/s3QqM4ntilBGBJCl21SF8pgga4QfkcU+HyYsSQvjHcPFqiX1t2rS4zOYdgCJGKM5G3Iy6MentpBtDtVek8VVNwve9oQPBHaF61Go3JgbGPhOUaHxlHZ7AzOjGk1x2tz7cnV4vDq8d2E9ZB2z6Pj9vEA==\",\"sdocumentreference\":\"FEF2524\",\"rtaxxadocument\":\"86710296\",\"sref\":\"86710296\",\"irefindex\":2524},\"sdebug\":\"Taxxa: 0.188s DIAN: 0.883s (creación 0.602s, revalidación 0.281s)\"}', 47202, NULL),
(1113, '2024-07-06 22:58: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-13\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2525,\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: 47204\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616237\",\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\":\"00616243\",\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   ', 47204, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1114, '2024-07-06 22:58: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\":\"1ac402dbaef235853029a836a35dbae2584f0e058f5e127da1e419c4589081ae958ddf25a5ac07470b01706ba27df85e\",\"sqr\":\"FEF2525 2024-07-06 22:58:09-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 1ac402dbaef235853029a836a35dbae2584f0e058f5e127da1e419c4589081ae958ddf25a5ac07470b01706ba27df85e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=1ac402dbaef235853029a836a35dbae2584f0e058f5e127da1e419c4589081ae958ddf25a5ac07470b01706ba27df85e\",\"ssignature\":\"sxGbfq/wLMkns29+NSA80uH65IpGu3PfkjZzIUjkXBMKXYyvrmwKh2SJBgdNhdbRuzhbK0htQEU+Ms+8CmJdXPdf7KXL4m5xhcLIvCLpwRPZg3Ua5Uuvp/FuD+oYJ+K8gIz2o9FdYJfQavpB31A8wR8QSwMbU44hsGZvXRlCf/jJNQt2gDLChqalEYZzceTIgq/Z5EHyD6J8/T6DvROA9qUwVyFELkkMBGfkkdDt2UynPP2NTalmCndex85X0AIJ/1ivzb0k4ULVvpomRMq4gDBnf26BmnhbN/Jnp5CSx0XlzAsQEbsid9tZiMM1ZmXc1hTGal7YbCV2ZJq99vAxuA==\",\"sdocumentreference\":\"FEF2525\",\"rtaxxadocument\":\"86710311\",\"sref\":\"86710311\",\"irefindex\":2525},\"sdebug\":\"Taxxa: 0.203s DIAN: 0.982s (creación 0.688s, revalidación 0.295s)\"}', 47204, NULL),
(1115, '2024-07-06 22:58:11', '{\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\": 2526,\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: 47205\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616252\",\r\n                  \"scustomname\":\"CHULETON DE CERDO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":30092.592592593,\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\":\"00616254\",\r\n                  \"scustomname\":\"TAMARINDO MICHELADA\",\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   ', 47205, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1116, '2024-07-06 22:58:11', '{\"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\":\"9c4f16cb29b7559ecfefe73b34b7af8214960dbdccaa0cc4a529fe5de487319f7188f0a4f46d4a0e66cc149c21eb63ec\",\"sqr\":\"FEF2526 2024-07-06 22:58:14-05:00 19385248 222222222222 36574.07 0.00 2925.93 39500.00 9c4f16cb29b7559ecfefe73b34b7af8214960dbdccaa0cc4a529fe5de487319f7188f0a4f46d4a0e66cc149c21eb63ec https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9c4f16cb29b7559ecfefe73b34b7af8214960dbdccaa0cc4a529fe5de487319f7188f0a4f46d4a0e66cc149c21eb63ec\",\"ssignature\":\"L9S8KoP9/YGsfyBbVFdiuiBDizdt7vvSc+HBcStPQ8Mf9KJJ9AXD3+hwuX37izWbdN+noLW5CcPWv2wDtIt6Xnu2LnIG5pYgTeJS4bmhdz3Fq3poo/p9DT72/nh9AA/JpOUTyFJq55A0RAWyteMg/bLnp/AIbMmqfSUBpa1BYfFQ+aXwHn0OfSAEJPTEvORbLtBvJaFAfC/CwocYy8Ye2ZndmAegxGfoEOtXeVtd25Z3KqY2zI8Rf06Kl75PW4SNV1Pv53byrzj9YkrZo4I8kkWybjE+dHvTeWzQwxjzgz9RRjIXRV8dmTXkN4LGRXYOV1K/lwRE8zwLcxDaLAr+HA==\",\"sdocumentreference\":\"FEF2526\",\"rtaxxadocument\":\"86710321\",\"sref\":\"86710321\",\"irefindex\":2526},\"sdebug\":\"Taxxa: 0.156s DIAN: 0.969s (creación 0.625s, revalidación 0.344s)\"}', 47205, NULL),
(1117, '2024-07-06 22:58:16', '{\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\": 2527,\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: 47209\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616300\",\r\n                  \"scustomname\":\"HAMBURGUESA DE PROMOCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":17592.592592593,\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   ', 47209, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1118, '2024-07-06 22:58:16', '{\"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\":\"3005365773db4590618084b8e86677c336a4a243f45132168ca377581fe88b53e3e87a0e3d45fa87d449dffc7fb1aa04\",\"sqr\":\"FEF2527 2024-07-06 22:58:18-05:00 19385248 222222222222 35185.19 0.00 2814.81 38000.00 3005365773db4590618084b8e86677c336a4a243f45132168ca377581fe88b53e3e87a0e3d45fa87d449dffc7fb1aa04 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=3005365773db4590618084b8e86677c336a4a243f45132168ca377581fe88b53e3e87a0e3d45fa87d449dffc7fb1aa04\",\"ssignature\":\"GoZGHq3y0LFCTSS448bxEAYoQYR8TZ+D2bAgqgPYpc32CDX/fqbe2PBqr5Ap+wXl+/MWRKaVR//DHr/m038S0G9eo0gOxcUfo24t4zDLVzk79/ZANajlt9VQSRRDeB0NhZQ/oUQ76R8DAgvS1hzRAe6j8Lr2L4bpnm5Sdg2lKj6fAmzdnM3FdDxs9LtSMEe376voX/ZGBF4iqcMTr1FUFGy3SXYce7m0W6dF0irmiMk+eDHZGPTyh3QGLDAHPaDi8nBJGsByHZJhfM2EIZIibnW/MbF7LBbkjkmgvNhqD4Iveyz9RCN/1sy2hhoRyt76GXgwimRAf1p/PmXdT0QJ9g==\",\"sdocumentreference\":\"FEF2527\",\"rtaxxadocument\":\"86710331\",\"sref\":\"86710331\",\"irefindex\":2527},\"sdebug\":\"Taxxa: 0.172s DIAN: 0.938s (creación 0.625s, revalidación 0.313s)\"}', 47209, NULL),
(1119, '2024-07-06 22:58: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\": 2528,\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: 47219\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616444\",\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               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00616448\",\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   ', 47219, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1120, '2024-07-06 22:58:23', '{\"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\":\"4783d3fdbbac1d32bb340e33ec4b8ec6f4bee34e616d5d3a63966a72cf007f3b7435a87a1ce19769a7a81b4fc4af2bed\",\"sqr\":\"FEF2528 2024-07-06 22:58:25-05:00 19385248 222222222222 31481.48 0.00 2518.52 34000.00 4783d3fdbbac1d32bb340e33ec4b8ec6f4bee34e616d5d3a63966a72cf007f3b7435a87a1ce19769a7a81b4fc4af2bed https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=4783d3fdbbac1d32bb340e33ec4b8ec6f4bee34e616d5d3a63966a72cf007f3b7435a87a1ce19769a7a81b4fc4af2bed\",\"ssignature\":\"JzpGgwZ8RgWARDknr8EtjOgQWZnVEHXfes+dIyFGZLuawTUVen26Ly20Hnmq7ps2SX5Aahaxy1K04nKkvO5LYTrY3Ge1QOuWe3Hr+S+eAKqo5xMgt9Giywu1IfL76mIUMgRPEaFP+iablJc5t18H3qq++3wrDt2Fsmc6SU/EhT5pJMPFof/WJrzFvQvzEy058XQYHAa6V9x4yHgQU85mqWGgI2XW5GwjCMczNrEmDNG5GvcGgjPnN0N6earquFeGYpenHZ2nOv5ER5JcPr0/m9i8ykiWteZjarv1IXFORxmPZBfGIY3oK5K1CuYqt9dk+TQY8n2s/l9snXZSbdiS4Q==\",\"sdocumentreference\":\"FEF2528\",\"rtaxxadocument\":\"86710343\",\"sref\":\"86710343\",\"irefindex\":2528},\"sdebug\":\"Taxxa: 0.234s DIAN: 0.953s (creación 0.672s, revalidación 0.281s)\"}', 47219, NULL),
(1121, '2024-07-06 22:58: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-06\",\r\n               \"tduedate\":\"2024-07-13\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2529,\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: 47220\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616451\",\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   ', 47220, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1122, '2024-07-06 22:58: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\":\"5db1f5ddb1428b7e7aaf2d28b7fa602a4f8fb6769d406315a732971c857c4a35f4ae0d4df1ce405e98df5b7491cc748e\",\"sqr\":\"FEF2529 2024-07-06 22:58:29-05:00 19385248 222222222222 21296.30 0.00 1703.70 23000.00 5db1f5ddb1428b7e7aaf2d28b7fa602a4f8fb6769d406315a732971c857c4a35f4ae0d4df1ce405e98df5b7491cc748e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=5db1f5ddb1428b7e7aaf2d28b7fa602a4f8fb6769d406315a732971c857c4a35f4ae0d4df1ce405e98df5b7491cc748e\",\"ssignature\":\"IenbkbZ1tOgCDB+ZAAwavszEU2NttkHsBzHcYwR/zqCs8hc9XrOpooH+GhNae5UP24LkTUwetqxLhnKqMrxzVBcYC/oRbr8HdZm8R1N4VvZCwh2ocZnnfkmJNkPa9Ahi2afa1n1O1u54++PMQyP3Pk4CF00vDtJkRIWBu+kXW067NfzHY1yOqrIgEW9NA8R4dv64tbLK5knkVf+Af0/2sNH8K3/1ORrGqY3I3lvKYZecOZ1FOFeSb8d/LFJwupJC+GWBUMdh/Cqu2ELPEA084nKxz4c7XujCqyck+K4qIHCRjVK8vTXL8tDFqCS7/gzjRsvTdkB7ROiYdhVW7fR2Tg==\",\"sdocumentreference\":\"FEF2529\",\"rtaxxadocument\":\"86710351\",\"sref\":\"86710351\",\"irefindex\":2529},\"sdebug\":\"Taxxa: 0.203s DIAN: 1.078s (creación 0.719s, revalidación 0.359s)\"}', 47220, NULL),
(1123, '2024-07-06 22:58:32', '{\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\": 2530,\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\":\" 3128710990\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"B/ LA GRECIA MZ 36 CASA 3\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47223\"\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\": 5000,\r\n                         \"nbaseamount\": 42592.59259259259\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00616484\",\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               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00616487\",\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   ', 47223, NULL);
