INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(301, '2024-06-29 23:30: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\":\"489364c4f63d6dea2010bbc6639e442c0204d7762331448278cff011cb9782dd945c74bccd0619e58b506cdc55969987\",\"sqr\":\"FEF2124 2024-06-29 23:30:14-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 489364c4f63d6dea2010bbc6639e442c0204d7762331448278cff011cb9782dd945c74bccd0619e58b506cdc55969987 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=489364c4f63d6dea2010bbc6639e442c0204d7762331448278cff011cb9782dd945c74bccd0619e58b506cdc55969987\",\"ssignature\":\"yZ1Lb5qEpfLSZRofF7VDzmG5XuzhFcbHHrj5EuIkiGU730BhyDDMX8090B7jtbbLavJ28ygY1EZ2w8QDKJaVMRwaBWcI0H8JiFoD8H8GDPy6ClN7vFAXcJ+cLvQFgRrGunSHxk6M6nS8C2Q5yIl1g0G3/7zhl2eQQd7qBmRpW8IQiznMV+wFMvrvsHD2owLpY/8nWlF/Z5JiNcNDGPIscaFvUZZ7ywyWaUj2hvo5EF0GRJPXeEY3iQHCzh4yCK2MqQigh5Nbnv2BZp0tlx+KHqeqr20ylZ19CWlPa1BPuv1uTzAU1LUBUyEr9QTYBHxaaGIBcBNmUUCConzMyJQVDQ==\",\"sdocumentreference\":\"FEF2124\",\"rtaxxadocument\":\"84584115\",\"sref\":\"84584115\",\"irefindex\":2124},\"sdebug\":\"Taxxa: 0.185s DIAN: 1.535s (creación 1.188s, revalidación 0.347s)\"}', 46385, NULL),
(302, '2024-06-29 23:30:20', '{\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\": 2125,\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: 46386\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606466\",\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\":\"00606472\",\r\n                  \"scustomname\":\"BANDEJA SIN SOPA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14351.851851852,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 46386, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(303, '2024-06-29 23:30:20', '{\"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\":\"88157504b83b91d7406aaeb06efa9f7aab8089dc3b52f30a40c203cae60677ed31072eda6e61dd73283404e10c79bd7f\",\"sqr\":\"FEF2125 2024-06-29 23:30:23-05:00 19385248 222222222222 30555.56 0.00 2444.45 33000.01 88157504b83b91d7406aaeb06efa9f7aab8089dc3b52f30a40c203cae60677ed31072eda6e61dd73283404e10c79bd7f https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=88157504b83b91d7406aaeb06efa9f7aab8089dc3b52f30a40c203cae60677ed31072eda6e61dd73283404e10c79bd7f\",\"ssignature\":\"zeZ9+24OT9Vkf22OV0ZiUSNdvdJqH9Mq/z7X5+i4lKpXX3MP7Z/OCyJZ1JWDJs//CUKqGjdGhVYq4SDG6Amx8FU1G/wNfufTHYl7O43ljzM2jChgRlsQKC93XUlyND5LDDJiT2elu6vQegCWtHLIPsFYx5Yap1dU1kBSGooTnbYEx9QGeBiAyOsanahz9iTsuuh8SQTjh8eeeEZ3tJoogV+bDConiAQEzWhuKkc6JckKg4d5tDD8sg/l4I8MFlMZf5UemGfHHjx/VJFqUlYeVi+Xmyvpdn62qt/3UIZ7pf8O1/fpW1rUAIGV/9nNaZVFvnc0eehplC2SPNAetZ4z4Q==\",\"sdocumentreference\":\"FEF2125\",\"rtaxxadocument\":\"84584145\",\"sref\":\"84584145\",\"irefindex\":2125},\"sdebug\":\"Taxxa: 0.182s DIAN: 1.086s (creación 0.644s, revalidación 0.442s)\"}', 46386, NULL),
(304, '2024-06-29 23:30:28', '{\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\": 2126,\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: 46389\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606543\",\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\":\"00606549\",\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   ', 46389, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(305, '2024-06-29 23:30:28', '{\"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\":\"bbe9de30a18b53664eaf33431559f3c4bae966cf1e0dceb39be2352aeb657b7b6d5d87c23ba4dd530427700a26b713bc\",\"sqr\":\"FEF2126 2024-06-29 23:30:30-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 bbe9de30a18b53664eaf33431559f3c4bae966cf1e0dceb39be2352aeb657b7b6d5d87c23ba4dd530427700a26b713bc https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=bbe9de30a18b53664eaf33431559f3c4bae966cf1e0dceb39be2352aeb657b7b6d5d87c23ba4dd530427700a26b713bc\",\"ssignature\":\"DAJLp71NTmHCFqALUUJB15tcfLTdnQL+twzpzmIyzg+b1vwrP18Bzx7/vgwS46pQlwvIA8ccxBSNQY+pKLLL0UQEwHRO5BHoBeMZDpejmp3hEp8lp0JouLL+Uy+IwqzOBFpmS1t+e2RCVn0JUtSk/XRQVdSdMeIyYM8w/y8TsSZo6P+f6h55E+5yStvli3uEFeIu5GA0rqSMwHqQWNa/xAxWTTmRy0TwAZApJ0bxlup/qIJ5EZ4Y+iPVrlPAqgTWUqYZZ8sJLbZFY+Aq/BydQwLDoPiuwyuRZYmTcE0QutmNOheC6MbAXTOHc+KD+tfLx8qiI+IjOXvUbFEVL4DuHQ==\",\"sdocumentreference\":\"FEF2126\",\"rtaxxadocument\":\"84584175\",\"sref\":\"84584175\",\"irefindex\":2126},\"sdebug\":\"Taxxa: 0.383s DIAN: 1.326s (creación 0.965s, revalidación 0.361s)\"}', 46389, NULL),
(306, '2024-06-29 23:30: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-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2127,\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: 46390\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606558\",\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\":\"00606564\",\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   ', 46390, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(307, '2024-06-29 23:30: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\":\"b381672e144aab3a387f5e3e8ee67080ac488f41c0a107ae70cd884fb29c9995bd1c68295413f3ed901d0262d63f33cc\",\"sqr\":\"FEF2127 2024-06-29 23:30:39-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 b381672e144aab3a387f5e3e8ee67080ac488f41c0a107ae70cd884fb29c9995bd1c68295413f3ed901d0262d63f33cc https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b381672e144aab3a387f5e3e8ee67080ac488f41c0a107ae70cd884fb29c9995bd1c68295413f3ed901d0262d63f33cc\",\"ssignature\":\"2lPwrwOB1fCREiXuFYdAYbIAIyF/SQ96Z5Bop3THT/kNhrnxcMf9ng/gBqekxgbUmPT3Io7q0hwMQpGumW4uDj3F+emOaBgki293h0bFaArI//pTItWxC2jBbq/IZHslOsmV7J+4AszjrzIvUckaq7rH57e1ua+/Ia6YS1IxfBB1CgL1wBjyxjEAZvGkMBYGhr4hoXJdsmm1Hm7+4/mSGiITyg3/eyNJDBonU5e1IG81SGnSq04amqbWkID39ikNk7+DJ76m20e33f8bt9R6DQy7CVEFlyGL1CWNqs/EwHPz/XDDbG+Nwkzc7+QROsVG3kBOHq2Kx2cQ70E5z5gvzQ==\",\"sdocumentreference\":\"FEF2127\",\"rtaxxadocument\":\"84584213\",\"sref\":\"84584213\",\"irefindex\":2127},\"sdebug\":\"Taxxa: 0.213s DIAN: 0.991s (creación 0.697s, revalidación 0.294s)\"}', 46390, NULL),
(308, '2024-06-29 23:30:43', '{\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\": 2128,\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: 46391\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606573\",\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               }},\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   ', 46391, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(309, '2024-06-29 23:30:43', '{\"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\":\"a66528e329badc5b76b3f831f4c8de1091a351e5121e1794e0b8de1527261372882d1e4cf2e7c9b39c870dfddbe2ce55\",\"sqr\":\"FEF2128 2024-06-29 23:30:46-05:00 19385248 222222222222 30092.59 0.00 2407.41 32500.00 a66528e329badc5b76b3f831f4c8de1091a351e5121e1794e0b8de1527261372882d1e4cf2e7c9b39c870dfddbe2ce55 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=a66528e329badc5b76b3f831f4c8de1091a351e5121e1794e0b8de1527261372882d1e4cf2e7c9b39c870dfddbe2ce55\",\"ssignature\":\"m+hewCdQ8gsVPlkzmztJwlDV/lChWcQlAyzThFpy4MU1nevA3J+VcoEQMMPTRZLeWTjh69X5tgqCb7+EkE88Nq1pXgmgoMwP9KuKyWllFz5mracWLkO2I1MMa8iLYhSgoTa+GEJU+OSKqfLgPONn9GgaJxsrGgMgnM3PeVlxrtIi7MGaAml5Pwofrwj5xl4nvRhnnZlNjUQOU3d0fZsz940jcsNgP8lcuvk5uw5Ec3Xi6b1tqs6JJQv1dSQaF5rr3TBSR0yRvBmTN4k2DctRpUMbWrQK0IbKWAWn4imzrLtSglPk6pZFP4WYOntfdfl9wGlK2tBRP3LNp0vvl4XD/w==\",\"sdocumentreference\":\"FEF2128\",\"rtaxxadocument\":\"84584244\",\"sref\":\"84584244\",\"irefindex\":2128},\"sdebug\":\"Taxxa: 0.229s DIAN: 1.184s (creación 0.901s, revalidación 0.282s)\"}', 46391, NULL),
(310, '2024-06-29 23:30:50', '{\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\": 2129,\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: 46392\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606576\",\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\":\"00606582\",\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   ', 46392, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(311, '2024-06-29 23:30:50', '{\"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\":\"2c63d08b149329aaee93d5437cf65067f991f24a3f5eee41dd462ad254061a1c81fdc7cdbedcb1dbce97a4d0565186e6\",\"sqr\":\"FEF2129 2024-06-29 23:30:53-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 2c63d08b149329aaee93d5437cf65067f991f24a3f5eee41dd462ad254061a1c81fdc7cdbedcb1dbce97a4d0565186e6 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=2c63d08b149329aaee93d5437cf65067f991f24a3f5eee41dd462ad254061a1c81fdc7cdbedcb1dbce97a4d0565186e6\",\"ssignature\":\"uDodvYJZ5PlywPpNFMU+4qlqyrjbPMCnd+IZKPUEw6up2KQAQc8Cpz7eucczZ+b4Tq/K9NRjazBtVnNGJmadxlPBQ80GMODrBcojfE29Yc761RyaPx48eCZQuIvnnRH3tSQa8bBaZNuTx9RbvHKAwkmPwoVSNSV+oVRWWJ32y4GJ61ogYkVZaFOfEhF8lXmW2OsOnmcO6UB0ih0cm443wVWm80poAPVf5k81dlraxY3J3u+OSLYKdZORwpoqt2mIuewFstABsEcN5y2UKyDiPfquHdaF/WTBVdFY+NDPgV/rRXJZUPrDhzJuUC6T/LHVibONRdUZTa+zgE06iQmmEA==\",\"sdocumentreference\":\"FEF2129\",\"rtaxxadocument\":\"84584273\",\"sref\":\"84584273\",\"irefindex\":2129},\"sdebug\":\"Taxxa: 0.194s DIAN: 0.93s (creación 0.526s, revalidación 0.403s)\"}', 46392, NULL),
(312, '2024-06-29 23:30:57', '{\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\": 2130,\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: 46393\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606591\",\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   ', 46393, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(313, '2024-06-29 23:30:57', '{\"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\":\"3568a362878254bf9cb6a3e7a5339cac6db94edb97bd9e08e1e46d50ccdd07386d266775fd839c0db149b713a2c728a6\",\"sqr\":\"FEF2130 2024-06-29 23:31:00-05:00 19385248 222222222222 16666.67 0.00 1333.33 18000.00 3568a362878254bf9cb6a3e7a5339cac6db94edb97bd9e08e1e46d50ccdd07386d266775fd839c0db149b713a2c728a6 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=3568a362878254bf9cb6a3e7a5339cac6db94edb97bd9e08e1e46d50ccdd07386d266775fd839c0db149b713a2c728a6\",\"ssignature\":\"hi/0Gp+pBlVGLpwIBZT9V3DVqcdVZgl4CfBvif2tQ0FilDd5dREpEQghZTuiyUUMWfdWvli03o+JiotoKFWlepFG32Po251smmyjxhpnbcJoTZyIolhuAPfjwhIIGsQv6shBUtJK7s71yW3dURs8fKFq8SwnI9WSK2EGu5t8U5+kHLkb3Z9CM0Gp8xBNMIEoE8s+djfk0kOc/WK62KqKWYsXuoV0NO1eKwlJN6q2FASA4rH+PjyNSEzNEr6lddP9oU+SpBeJAq8qVJECKuL2EmL3TLX9/8gArBNIRvqYIzDlVjLhYRXb9y02qrzeIYb3jbdIWpVQKbTO3VUgaY4wJg==\",\"sdocumentreference\":\"FEF2130\",\"rtaxxadocument\":\"84584308\",\"sref\":\"84584308\",\"irefindex\":2130},\"sdebug\":\"Taxxa: 0.187s DIAN: 0.953s (creación 0.745s, revalidación 0.208s)\"}', 46393, NULL),
(314, '2024-06-29 23:31:04', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2131,\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: 46394\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606592\",\r\n                  \"scustomname\":\"COSTILLA 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\":\"00606594\",\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   ', 46394, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(315, '2024-06-29 23:31:04', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"7412b5be767206d4a5eef419e700fd68a141fc0e92cca5ddfd38587645032b931f87aad147d5d68eb42e1c2142bfc7c8\",\"sqr\":\"FEF2131 2024-06-29 23:31:07-05:00 19385248 222222222222 36574.07 0.00 2925.93 39500.00 7412b5be767206d4a5eef419e700fd68a141fc0e92cca5ddfd38587645032b931f87aad147d5d68eb42e1c2142bfc7c8 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=7412b5be767206d4a5eef419e700fd68a141fc0e92cca5ddfd38587645032b931f87aad147d5d68eb42e1c2142bfc7c8\",\"ssignature\":\"jfShIUquYZg7joDlZLoNP4MaiM11KT0Izr6/tkuGhYHEGtdR+QZekyUUtLy309duPQAhUwFS0Sgvt4EUyjlCtbU3bZtT0f7384tS/edEOGX7T0gVcIG00NSAvm9nDwA4woqDlDtxhpwyF+Zgh8PxNpAOXcORTICPPz54C4YtSSPKT6ogI8+jxxHxcmSqeewYnzjXkN3X0CqbaqHtBEoML32xYhqufflqS6MliAeGAWIYI8LfL6WArIZC4yZVnQtNoZjlEm5Qiuo84k+n9oZTZT7JYnNVH1Wm+VhKVpb5vGM5HDvs/lzsNecksbwCORDDvvcWy0tFp9KD0kcbNIDKTg==\",\"sdocumentreference\":\"FEF2131\",\"rtaxxadocument\":\"84584339\",\"sref\":\"84584339\",\"irefindex\":2131},\"sdebug\":\"Taxxa: 0.157s DIAN: 1.002s (creación 0.703s, revalidación 0.299s)\"}', 46394, NULL),
(316, '2024-06-29 23:31:13', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2132,\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: 46398\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606680\",\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\":\"00606684\",\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   ', 46398, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(317, '2024-06-29 23:31:13', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"77b564f0f46fa2283552c57c5110af64a74a5263e7a07235e97ae1ce40be6398d01097ae7955c45b9b866d5937b84960\",\"sqr\":\"FEF2132 2024-06-29 23:31:15-05:00 19385248 222222222222 31481.48 0.00 2518.52 34000.00 77b564f0f46fa2283552c57c5110af64a74a5263e7a07235e97ae1ce40be6398d01097ae7955c45b9b866d5937b84960 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=77b564f0f46fa2283552c57c5110af64a74a5263e7a07235e97ae1ce40be6398d01097ae7955c45b9b866d5937b84960\",\"ssignature\":\"5KBrL4zOliR8s7BfiQLnPY0KhMlUO+kOhjJ0qi25+8NYNeT9KiPrKP3NT7WbZz5kM+MoPlBtUnOR+38Dla0eGvVa6Q1S8GyuYBwRBKoauSoIeZ/p3Nf25w3Z7JPO4fstK+fvin+rF8ZpbAxVJZDC/6HdAehYxTEzHJ818rl03X5t6Vp7JGf3pbMZJLlp33iKag5hfmTlCqowZeCehhkgX8zaGeQ1E6IbkxiXmfxsi0gdSKLyykQKKGWrqyeH4jjeVasdwmdwyruGaxvHzJGr9tsSBHuWvfh6EYoTSiGkFe/jnlmO1vdu/Gb+2h7k8lc37b5jp3EkCE1cg0LgC9pyAQ==\",\"sdocumentreference\":\"FEF2132\",\"rtaxxadocument\":\"84584385\",\"sref\":\"84584385\",\"irefindex\":2132},\"sdebug\":\"Taxxa: 0.196s DIAN: 1.086s (creación 0.735s, revalidación 0.351s)\"}', 46398, NULL),
(318, '2024-06-29 23:31:19', '{\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\": 2133,\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: 46403\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606755\",\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   ', 46403, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(319, '2024-06-29 23:31:19', '{\"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\":\"141d3ebee5ed81eee55ab6d6d50248dfe530765d4693a9b2a3ba48597e1138a9c97e412a46caa89f39554f89abdcb0cc\",\"sqr\":\"FEF2133 2024-06-29 23:31:22-05:00 19385248 222222222222 16666.67 0.00 1333.33 18000.00 141d3ebee5ed81eee55ab6d6d50248dfe530765d4693a9b2a3ba48597e1138a9c97e412a46caa89f39554f89abdcb0cc https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=141d3ebee5ed81eee55ab6d6d50248dfe530765d4693a9b2a3ba48597e1138a9c97e412a46caa89f39554f89abdcb0cc\",\"ssignature\":\"xMQFAmB5os5K3WTZXs52/0KOTQCpOkyqFkwAkFcwzbrGAocW+rfNFZqBswJusv4cEk8JSlKnfKea8hF1w3/WZ4UZ4BdB5PTgjOQRNl2NKg1aC3yK3PbfUcYBz+bERpVkEJF/yBqrgTC9imefxa/qbL8Pelgd4SK2p9yDfiqXJ8bLP8/olhC+0FdTuKJLPP7mUJE1Bs1aSK0GyaBlsJmjr0mz0aQxY33uSiOuFaOVc6qIpO5jiSAoktesvODYrdVLTOh80YdrZxefIkp1KwU4tT7NleBGz2srFobni7KnkWLA5FWDS4jeloylm8l9shT3eA3hZO7XS2hm2kVOuWm0bA==\",\"sdocumentreference\":\"FEF2133\",\"rtaxxadocument\":\"84584428\",\"sref\":\"84584428\",\"irefindex\":2133},\"sdebug\":\"Taxxa: 0.341s DIAN: 1.431s (creación 1.119s, revalidación 0.312s)\"}', 46403, NULL),
(320, '2024-06-29 23:31: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-06-29\",\r\n               \"tduedate\":\"2024-07-06\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2134,\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: 46406\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00606778\",\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\":\"00606781\",\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   ', 46406, NULL);
