INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(261, '2024-06-29 21:41:09', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"fae4c0f8c30b0d243b25ebbd8c830572276da6754cda13157af4caf2e7d26c912a38cbed33132286bd1693463e856638\",\"sqr\":\"FEF2104 2024-06-29 21:41:12-05:00 19385248 222222222222 52777.78 0.00 4222.22 61000.00 fae4c0f8c30b0d243b25ebbd8c830572276da6754cda13157af4caf2e7d26c912a38cbed33132286bd1693463e856638 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=fae4c0f8c30b0d243b25ebbd8c830572276da6754cda13157af4caf2e7d26c912a38cbed33132286bd1693463e856638\",\"ssignature\":\"efyuLzxVJ7Oa9plhe6IrphU8RHVOsw+9oWDsmfunmNQYyfJaSlABpAzseqLpXsHVe5240Yq2AP1+38KlU9xnRvMW0COzuj5MYrOot1J/5uj6pcPT2gNjmjKkugU2h6prx87kg6PEplDoLvqr4cGt6H4PtGLNHpAnPq5uujbpztyvHxiD+0Zy0yQN41N9rQIdRF8VxspSy6h7GVeHkJbbK9IfUSxl0RJCJ00DQYyRG61ExEKn44OnykXMxROskYZrrdg1p9Kh9dGjE9vDPoCsSryXh8Z52KAiq6ZF0mvkOf4mVdb4wCdghZebr9Z4TynrPTvm9RYrocl06mbgCacZ1Q==\",\"sdocumentreference\":\"FEF2104\",\"rtaxxadocument\":\"84570402\",\"sref\":\"84570402\",\"irefindex\":2104},\"sdebug\":\"Taxxa: 0.22s DIAN: 1.005s (creación 0.658s, revalidación 0.347s)\"}', 46495, NULL),
(262, '2024-06-29 21:41: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-06-29\",\r\n               \"tduedate\":\"2024-06-29\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2105,\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\":\"GUSTAVO ALDOLFO OROZCO    \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"GUSTAVO ALDOLFO OROZCO    \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3177179687\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"EDEN DE LA VICTORIA CASA B 2 \",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46497\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"9\",\r\n                         \"namount\": 5000,\r\n                         \"nbaseamount\": 54166.666666666664\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00607512\",\r\n                  \"scustomname\":\"CHURRASCO ASADO\",\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\":\"00607514\",\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               }},\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   ', 46497, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(263, '2024-06-29 21:41: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\":\"8a0e199250d9e9ffe98760284963a89c708af06de59535d5adad78a4ceb29cf9c96c6ae8d196f7907316af0ea0016ce1\",\"sqr\":\"FEF2105 2024-06-29 21:41:39-05:00 19385248 222222222222 54166.67 0.00 4333.34 63500.01 8a0e199250d9e9ffe98760284963a89c708af06de59535d5adad78a4ceb29cf9c96c6ae8d196f7907316af0ea0016ce1 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=8a0e199250d9e9ffe98760284963a89c708af06de59535d5adad78a4ceb29cf9c96c6ae8d196f7907316af0ea0016ce1\",\"ssignature\":\"BxRtXQjC8K4T6mzmignynfdCV6ukJi3oSi/z19v9FC/RMxTgp1LJ/3TWrjQmMNzQTbuGgHjako5xlSNZSGXXnAsVAwnbsWWAyD02M68jru7Ig/nZUogRM/13FnoFp/aDHFoLdioOgUIh8VWTrUiF9BvbyOQW60scNEPpEj1WO7hJa/xo7Mp57emZyaaAMW6iGWzM2Y5x9Q2VQV9TcwdQulW0GVedw/p5orKksZpz2ufHJ4+wHWwbwxP6Vkm7Svso+YjT1Yl40dOgK2Woj/2dPWee8ympk8xuPXNr5j8yCbSJW6zAvTE8TeC5dgqS3Ig5dSI27qJGoAdlNg60sECVyg==\",\"sdocumentreference\":\"FEF2105\",\"rtaxxadocument\":\"84570473\",\"sref\":\"84570473\",\"irefindex\":2105},\"sdebug\":\"Taxxa: 0.194s DIAN: 1.3s (creación 0.714s, revalidación 0.586s)\"}', 46497, NULL),
(264, '2024-06-29 22:45:49', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2106,\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\":\"48\",\r\n                  \"scustomername\":\"FERREINOX SAS BIC\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"800224617\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"ANDRES\",\r\n                     \"selectronicmail\":\"tiendapintucoarmenia@ferreinox.co\",\r\n                     \"stelephone\":\"3104531280\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"CR 13N 19-26\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46520\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00607789\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16666.666666667,\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\":\"00607790\",\r\n                  \"scustomname\":\"LIMONADA DE COCO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7407.4074074074,\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   ', 46520, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(265, '2024-06-29 22:45:49', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"70e62a9e4c79ba9ef81ef3df709d7a61f3fbc3ac346e2e137d0a70cf9be0edf1107523c7dd2dc0fcd17ad5311893f71c\",\"sqr\":\"FEF2106 2024-06-29 22:45:52-05:00 19385248 800224617 40740.74 0.00 3259.26 44000.00 70e62a9e4c79ba9ef81ef3df709d7a61f3fbc3ac346e2e137d0a70cf9be0edf1107523c7dd2dc0fcd17ad5311893f71c https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=70e62a9e4c79ba9ef81ef3df709d7a61f3fbc3ac346e2e137d0a70cf9be0edf1107523c7dd2dc0fcd17ad5311893f71c\",\"ssignature\":\"r69VRezo63bo8uaQmqCTYLznv+nhXKEoZJ8Dub/X5hrCSL1yUxFQqoj9C/LbViX9pHj+Z6H8rYItBSw1h1CgwLjPK5+ya/FQyLBVL9r6zq4v2Z+7fAyTwpv13SQTlysC1XouH7RXKcf6WRgu+n2FrNFKLifeggsTCrGTVJwmNwtVbuE/LiY6gAIsIoGObTY6cG4erAMr+NiTa4oeBV6FaXCK2OvI0ffO95N2gHzYXqTBnO4ovgu6oLk2nvJf5y+NtuxM2yVRO2MFW9yqhZNTwKKpUk1at5yF+ZnbQi8NZELHGwAejBBFYpfPmp00uwQqtATVK3Q7ed8kTX9ZNCDiHQ==\",\"sdocumentreference\":\"FEF2106\",\"rtaxxadocument\":\"84579585\",\"sref\":\"84579585\",\"irefindex\":2106},\"sdebug\":\"Taxxa: 0.196s DIAN: 1.174s (creación 0.66s, revalidación 0.514s)\"}', 46520, NULL),
(266, '2024-06-29 23:24:42', '{\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-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2107,\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: 46349\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00605917\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16666.666666667,\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   ', 46349, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(267, '2024-06-29 23:24: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\":\"180371272fa9ae3e1facbdf8c803c23afb278452ad034eb0b3dd5cdd428d103729734aa30ae2ab6244cb493a9be3f9ab\",\"sqr\":\"FEF2107 2024-06-29 23:24:44-05:00 19385248 222222222222 16666.67 0.00 1333.33 18000.00 180371272fa9ae3e1facbdf8c803c23afb278452ad034eb0b3dd5cdd428d103729734aa30ae2ab6244cb493a9be3f9ab https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=180371272fa9ae3e1facbdf8c803c23afb278452ad034eb0b3dd5cdd428d103729734aa30ae2ab6244cb493a9be3f9ab\",\"ssignature\":\"7c/h4G+YMdjjvf2b+2N3082RCjw9s7s5p6quG28Ao87joi7oZhGRnIzkYqm4TCaGGP3YB2Fl6+EdnVqlBFdolrzpG0baaRGU8rfTnFlz5zJYTV8HtFLDyhhkqOumiPDqafNTDFszseD/zgkXQbtNXJ3lFWsiPWX9BYRp2a2pG/PSuoCIM+Uob6wwmHkhkM2TfJJN255k/1IuxOpGZfAbVxkyGhVPl18E9iPiqgEKCBfCjsvmVN/nSay1afevsIu5lkPrG+L74KmvLuWPhn4OVLNXRvr3BHnQTp2HsoIVgI1ygB06xtZlDr8sPd6mWy1SOPOMZfZX6CfIxv1g6Gg0ng==\",\"sdocumentreference\":\"FEF2107\",\"rtaxxadocument\":\"84583576\",\"sref\":\"84583576\",\"irefindex\":2107},\"sdebug\":\"Taxxa: 0.149s DIAN: 0.928s (creación 0.625s, revalidación 0.303s)\"}', 46349, NULL),
(268, '2024-06-29 23:24:49', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2108,\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: 46355\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00605957\",\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\":\"00605963\",\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   ', 46355, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(269, '2024-06-29 23:24:49', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"1\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"2\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"4958e8163ea742e625b456efb47fc75d96de29b54163a34b913e2f1c326699d5b184c487f1d0a2295e70268ad5c6781d\",\"sqr\":\"FEF2108 2024-06-29 23:24:52-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 4958e8163ea742e625b456efb47fc75d96de29b54163a34b913e2f1c326699d5b184c487f1d0a2295e70268ad5c6781d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=4958e8163ea742e625b456efb47fc75d96de29b54163a34b913e2f1c326699d5b184c487f1d0a2295e70268ad5c6781d\",\"ssignature\":\"wTdjUOyCsB/v1bovFicSc7Xa0TnrbvdJse2szNf+ox2xCdgQAg7gxq364kXOwmlfnyAJ3B25BmoOh8sQqNec9AnbERbggY/li3LZaL2UmYyhTzR0DnUzvhksIGo/iuLG3sVMb2ec+wLmzmDwdMzxdI96AgI/Uloqz2RAXYvJw6Kcb0jJuTsziXVTKN9f+VPtmcvu4BQMqcyAQnO5IuWq/YtDwwQAK+p8pGAGHLwLUSRLwBsNYo1N1UVI5XhZ41x8NgMeSsSdxeT3cFS0whCm0XwNioAajvJmoxGi5kds3rnSA43Y5nDWfT1HEuDgWGDkrXkmd+M/OSQ7kMSlHX6p2Q==\",\"sdocumentreference\":\"FEF2108\",\"rtaxxadocument\":\"84583586\",\"sref\":\"84583586\",\"irefindex\":2108},\"sdebug\":\"Taxxa: 0.167s DIAN: 1.048s (creación 0.747s, revalidación 0.301s)\"}', 46355, NULL),
(270, '2024-06-29 23:24:56', '{\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-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2109,\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: 46356\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00605972\",\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   ', 46356, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(271, '2024-06-29 23:24:56', '{\"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\":\"0fef4bb9d71658409186aa97ad7199dc7f7a03d383501892ae6cebd166f901998ce427e2636c527e9cf6edebc5ebe656\",\"sqr\":\"FEF2109 2024-06-29 23:24:59-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 0fef4bb9d71658409186aa97ad7199dc7f7a03d383501892ae6cebd166f901998ce427e2636c527e9cf6edebc5ebe656 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=0fef4bb9d71658409186aa97ad7199dc7f7a03d383501892ae6cebd166f901998ce427e2636c527e9cf6edebc5ebe656\",\"ssignature\":\"4c3MH+7ayr0uXc0/7pWCkn/OmaTpYCL4SEd93vNx/ax/Irjb0UrkMPKrvxTcNsySko+u5NOvopQD5tVLXSk8CHKDwuIbSwfzcNWLVG/wUUJHdi9i4FTwrRJKqA4bqhJfjJ1XLxXVEr0f0xNEtHiV09Mnm929c/BsBIXpGJ/EcW+fhQgD4+G7yHDEoqOyPmUFZIatrxcT+44cYRWigfyL6OyXzf7SBIiEK44q7Ju68LoZ+BXMF7EoicKNrnZo3dQJrf1wyqZC/Bi8OjHvZEugChXVUfx6kwMvp6SLDbyuVapyHK69noDDvSwLoBSWS5g/z8SeGT/jkhlmf6sHmulNEA==\",\"sdocumentreference\":\"FEF2109\",\"rtaxxadocument\":\"84583599\",\"sref\":\"84583599\",\"irefindex\":2109},\"sdebug\":\"Taxxa: 0.195s DIAN: 1.038s (creación 0.744s, revalidación 0.294s)\"}', 46356, NULL),
(272, '2024-06-29 23:25:09', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2110,\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: 46357\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00605979\",\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\":\"00605985\",\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   ', 46357, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(273, '2024-06-29 23:25:09', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"fdfa2b21322be5103a5d8aae9ad130d4a51b82b53295af4bac2c62702cf5e76a6ede858a817990d670357aa6070a2183\",\"sqr\":\"FEF2110 2024-06-29 23:25:11-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 fdfa2b21322be5103a5d8aae9ad130d4a51b82b53295af4bac2c62702cf5e76a6ede858a817990d670357aa6070a2183 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=fdfa2b21322be5103a5d8aae9ad130d4a51b82b53295af4bac2c62702cf5e76a6ede858a817990d670357aa6070a2183\",\"ssignature\":\"Ivh84XH7719QlCo8OvdQsCZu3KOmcJ1oLfIHGAGrnCvauo/JhS87RqmdEaB4r1bsIz6F0BFxxspZmcOYnAR3BgJtOrubavt4VItfrFiFwaK7wyb7aEhZowlTEUK91mB92fghk182XpyFJgbMWbTuHdbDJdEPGECWrBLqY2Bmz68bnGWNRPu6b6kl8YEgvAj+0nGMRCPc/H+6AUqP2YVQ8Th3fFluuzCT9Gg0G05lNFU7Q34gW5I1osjuYO+trApdxVJxVnHXhq0P6PGbBN6Yc2Q/uvvlDXmWRdcJexPlqQr+qCBjSemJj3h4na/cpJWhsiouGLUXf3HkqLu8Q0OpnA==\",\"sdocumentreference\":\"FEF2110\",\"rtaxxadocument\":\"84583622\",\"sref\":\"84583622\",\"irefindex\":2110},\"sdebug\":\"Taxxa: 0.216s DIAN: 1.266s (creación 0.927s, revalidación 0.339s)\"}', 46357, NULL),
(274, '2024-06-29 23:25:17', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2111,\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: 46363\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606125\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16666.666666667,\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   ', 46363, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(275, '2024-06-29 23:25:17', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: 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\":\"68c74f9e4446c985460f2e89ff79cbcababb5fc8ee0d436b21eeb53d78a5c598ebb5ea0aa625ab33101b561e730ca721\",\"sqr\":\"FEF2111 2024-06-29 23:25:20-05:00 19385248 222222222222 16666.67 0.00 1333.33 18000.00 68c74f9e4446c985460f2e89ff79cbcababb5fc8ee0d436b21eeb53d78a5c598ebb5ea0aa625ab33101b561e730ca721 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=68c74f9e4446c985460f2e89ff79cbcababb5fc8ee0d436b21eeb53d78a5c598ebb5ea0aa625ab33101b561e730ca721\",\"ssignature\":\"crEAkViVbWC8/cy4US55w+sznvbUqD/NSqfDeO0DIpxyUgtuSx3L+27up9r7NOjcv1Ajb/PzKTUWY+dgbtcCudF+NnQxi444Fcndo9ggGkh7n0+WAt/9eqfhIAoxVRz/EnnXgykmvmu8zr7A2hQo9z2YxIwC/kaWtlFOPjBK+1uB96XisDypT11x14SCLSz0Un4rHABUm2RWpkYCss+ctamBgg1FJSAPycDrW5HHGmHYlAT/k96NH5+b/p4Ov4LLeAt8nUnYXV9Kbho+Km9sQx7Ox8N3ZutmAASvKn4zJCdtNV7q3tLKoZm2GjkUnf9utQxCvqQdbrtM6rXN8CcysA==\",\"sdocumentreference\":\"FEF2111\",\"rtaxxadocument\":\"84583637\",\"sref\":\"84583637\",\"irefindex\":2111},\"sdebug\":\"Taxxa: 0.167s DIAN: 1.381s (creación 0.699s, revalidación 0.682s)\"}', 46363, NULL),
(276, '2024-06-29 23:28: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-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2112,\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: 46365\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606133\",\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   ', 46365, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(277, '2024-06-29 23:28: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\":\"e88c0d79a76897f0e55eb4ca6075f12624bf9af6ed467f6d98e0b99e9af36a34c11bf9726ffbcb3f0085ad2c47af5a7e\",\"sqr\":\"FEF2112 2024-06-29 23:28:19-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 e88c0d79a76897f0e55eb4ca6075f12624bf9af6ed467f6d98e0b99e9af36a34c11bf9726ffbcb3f0085ad2c47af5a7e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=e88c0d79a76897f0e55eb4ca6075f12624bf9af6ed467f6d98e0b99e9af36a34c11bf9726ffbcb3f0085ad2c47af5a7e\",\"ssignature\":\"ssktYeYN/eBkMI4ar1n7MxmpOc+QNEYaB3snqLFQRWY/BT1nYl6yG+L+E5BQZUFyYApAZTLaB0UschsBh5tAuoWjn7U25BM8FpzXuD1Tpbhw04YJ5+QYnH7RwR8B3SKjb6z3m+8fA9DauW5ZqYGh+U56RVLOGFMw/8EoActz01on+Px1RR+h5Y+SWBORJLKfprfw2JKQsH51VdvoiXPnhtnDhohwY/UdHvDmDV/ZsCDH6y3CqbCo8N6vUVaB/HAtcWyj+YZOJuwonlzbGLVqlgKhtmvBp28Fe1SmWCXQZOoZ+zufXJCOPqwyHFlDQIWUoOKQgT2KucOzxy4jMYpn7g==\",\"sdocumentreference\":\"FEF2112\",\"rtaxxadocument\":\"84583883\",\"sref\":\"84583883\",\"irefindex\":2112},\"sdebug\":\"Taxxa: 0.213s DIAN: 1.084s (creación 0.758s, revalidación 0.326s)\"}', 46365, NULL),
(278, '2024-06-29 23:28:25', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2113,\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: 46366\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606140\",\r\n                  \"scustomname\":\"PORCION ENSALADA VERDURAS\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":9722.2222222222,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 46366, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(279, '2024-06-29 23:28:25', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"9c5e5ffcf8180e3713dd428f391bf25598e8e7a99feb34627ac0eaaa08189d3c7fed09914368348ecb88d3098e7eb7ad\",\"sqr\":\"FEF2113 2024-06-29 23:28:28-05:00 19385248 222222222222 9722.22 0.00 777.78 10500.00 9c5e5ffcf8180e3713dd428f391bf25598e8e7a99feb34627ac0eaaa08189d3c7fed09914368348ecb88d3098e7eb7ad https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9c5e5ffcf8180e3713dd428f391bf25598e8e7a99feb34627ac0eaaa08189d3c7fed09914368348ecb88d3098e7eb7ad\",\"ssignature\":\"SZsBHE+S4GVxOTENHpn86BZ7OwGqxcghOdQfJLjBtJUE/MsJnDstxE/HcbZeEllNfMGe0QTQ2GKaZGeTZQakZfm4ap8hg2y+2EZGAVhSTPJ7PhNKkIF+8jTTtCqXGcOQ1Bir4KljN1ZVkm94m/Ty9pwcAsUDq1If2xVkr1iOGvR/clcQsMv1gI6FnIRX0jNgu9mRcl+uC+qmmgyELm7hB4g52WifZKB25GkLizS0fkI2cZnNtMYUc1LNHdP4z4Z9Pji5LFR6KmykPH6g96+R5SWeEYAgk/RqUoyhdpxm8WBP0jfvdb4S/km8urDMJhCL24uj96ozCJYSsnsKGFjnVA==\",\"sdocumentreference\":\"FEF2113\",\"rtaxxadocument\":\"84583908\",\"sref\":\"84583908\",\"irefindex\":2113},\"sdebug\":\"Taxxa: 0.179s DIAN: 0.96s (creación 0.623s, revalidación 0.337s)\"}', 46366, NULL),
(280, '2024-06-29 23:28:31', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2114,\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: 46367\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606141\",\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   ', 46367, NULL);
