INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(441, '2024-06-30 23:32:12', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"3dd01cadd8d6e929f09540232991526337f4542f77f5121a2df06dbc878cb2482178df4e7cdbc98c86aa9c2c024f0732\",\"sqr\":\"FEF2194 2024-06-30 23:32:15-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 3dd01cadd8d6e929f09540232991526337f4542f77f5121a2df06dbc878cb2482178df4e7cdbc98c86aa9c2c024f0732 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=3dd01cadd8d6e929f09540232991526337f4542f77f5121a2df06dbc878cb2482178df4e7cdbc98c86aa9c2c024f0732\",\"ssignature\":\"DESB0KrCOzWXSE7EPYEkNtSO9g5Yqna/CMxlZOvmu/jsqWuTg5D+7MFOH8aGPPuQW49xnL/5LMNyTGZWNDhBUs/10Y1cCn3WOl9n3+lnOyXkym7Qj2uZte0ZPwbD+YuSd6icvqc8yOwu+dDfEtmAlHYZxoncRSdkwOw8DaHlegGWgaRlj5yjMXsqPAEC9O/tN33LgYZealA1QGjvOWmQTGQcfBWRwr4dG6FkQLzZiHq+k37/6lGez+ohhEGcZAisgGASXMQ4CNc+JYPCeI3IRVUap/X6BRfdwFbaqUqt57nzpHw1L+sc1709Txo7i9vORTl68thI+OOCOs57IHNGCw==\",\"sdocumentreference\":\"FEF2194\",\"rtaxxadocument\":\"84793374\",\"sref\":\"84793374\",\"irefindex\":2194},\"sdebug\":\"Taxxa: 0.687s DIAN: 1.114s (creación 1.114s, revalidación 0s)\"}', 46539, NULL),
(442, '2024-06-30 23:32:18', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2195,\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: 46540\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608039\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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\":\"00608045\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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   ', 46540, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(443, '2024-06-30 23:32:18', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"fdb6ed7e102e08bd2e5f6501a2fd565fd2c75d8d28b3eb213b1d2dac4e9d87c06a0d0ba57d0e9d72742b8299a9d4eca8\",\"sqr\":\"FEF2195 2024-06-30 23:32:21-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 fdb6ed7e102e08bd2e5f6501a2fd565fd2c75d8d28b3eb213b1d2dac4e9d87c06a0d0ba57d0e9d72742b8299a9d4eca8 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=fdb6ed7e102e08bd2e5f6501a2fd565fd2c75d8d28b3eb213b1d2dac4e9d87c06a0d0ba57d0e9d72742b8299a9d4eca8\",\"ssignature\":\"Pxv/aORyIfK2WKeJ249KdDTMwL5IM/DNXz0YpUqZb1+WsaIaks2O0MyKMdIMLZbTQZfFiqKZQum6OkZajs6IUlr0dbZnFeLXT/tZ2iSbwPtBz8TUNSoZB1ptZXv2ElHEwxVh1LhMb3nC8ITBLtZUYXOl6QqJfo+bgXV9xUpmqTvVcHr1ZnDaZ0vUiZCtUnf4r24ZYIW+gvL9/p3a+XBeaO1aezKNgv6/bRzulupuwyAKOsL7qzrJ3gBCet+rU1hq8gxPqGGUkrGFMW+kMGdI1rzkl1qGEXS2+d8aegx86ViiUkfakNgdLFTko6O8VwopREUvyGdX3NMcN0LBx7LxXg==\",\"sdocumentreference\":\"FEF2195\",\"rtaxxadocument\":\"84793390\",\"sref\":\"84793390\",\"irefindex\":2195},\"sdebug\":\"Taxxa: 0.513s DIAN: 1.121s (creación 1.121s, revalidación 0s)\"}', 46540, NULL),
(444, '2024-06-30 23:32:23', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2196,\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: 46542\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608085\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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   ', 46542, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(445, '2024-06-30 23:32:23', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"db88925ed58df9230655fb8b262c286990618426d713cb57623588310acb70f72f8eecf3c6923685e943b9e1e3c64152\",\"sqr\":\"FEF2196 2024-06-30 23:32:26-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 db88925ed58df9230655fb8b262c286990618426d713cb57623588310acb70f72f8eecf3c6923685e943b9e1e3c64152 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=db88925ed58df9230655fb8b262c286990618426d713cb57623588310acb70f72f8eecf3c6923685e943b9e1e3c64152\",\"ssignature\":\"2nRAPrEKrKcnrUFkoXojQF7nc9/wgxL3OyaZtukMO6i9A595rZELmbCLMbf33eZ4MXsOAFWM1Nu1i6/9wkYkyd07bVutv90Dzr1vT8sQqINmXpds2RVyIWEw9Go7bEnoNzhGRxa+KgWPQqdp+yR/zkHEAVkoYeypT8nbX8upFLbez1d1Pt48zFRG2iYL8k3ClgkKbxCvE5rrveGmYUUTyXBUO+eiZyiRPmoJvH0vNYzr0QaUrDP/33bHyQ221BSYrJZDmkBvD41C3VC2oPyvY0OF7zAMngGdXDhAqRyYIX/Z73NWPGPMX97wjaNNX90v/Dim+3J81UKSpZJwxAgRSA==\",\"sdocumentreference\":\"FEF2196\",\"rtaxxadocument\":\"84793405\",\"sref\":\"84793405\",\"irefindex\":2196},\"sdebug\":\"Taxxa: 0.803s DIAN: 1.157s (creación 1.157s, revalidación 0s)\"}', 46542, NULL),
(446, '2024-06-30 23:32: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-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2197,\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: 46543\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608092\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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   ', 46543, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(447, '2024-06-30 23:32: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\":\"be577955cb210a4a2d88e6b29eebed8f63b460eb2c90eb34971595b1912bb4d20e592e8f0ddcfc89774c6e441e22e9c9\",\"sqr\":\"FEF2197 2024-06-30 23:32:45-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 be577955cb210a4a2d88e6b29eebed8f63b460eb2c90eb34971595b1912bb4d20e592e8f0ddcfc89774c6e441e22e9c9 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=be577955cb210a4a2d88e6b29eebed8f63b460eb2c90eb34971595b1912bb4d20e592e8f0ddcfc89774c6e441e22e9c9\",\"ssignature\":\"laCbVpdrYcd5dGohXHx7ghi4+8di8nZMjKoAsRKY91HpXhUXLk6psRpZDv9Hm2xfWKBBoCheFv96MXFnuKSTVvjfHksViViwAvSdE2FEWoC55D+ZY68QXU0Z9kBaQFDvaWod8xcCUt+AtYAi2mCZ45Ej2EOMVTdpfzR/Nxpv6J+1zRY6uBxMcbOhxNj1UDNYDJcWYZDqtySfVV1YOZ5PdGNjisoZrgl8piTQMoBKxqnRaUTC+RqO47E0ybtsWWRCeuJuHL3x6gCtNX47UCQ3NyCYtELv7Lvh3OQ+jg+0YE8V5BD4BcNpDdnEGmQJqUmnpcE8Inudotm9ytP9SUM46A==\",\"sdocumentreference\":\"FEF2197\",\"rtaxxadocument\":\"84793460\",\"sref\":\"84793460\",\"irefindex\":2197},\"sdebug\":\"Taxxa: 0.434s DIAN: 0.604s (creación 0.604s, revalidación 0s)\"}', 46543, NULL),
(448, '2024-06-30 23:32:46', '{\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-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2198,\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: 46544\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608099\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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\":\"00608105\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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   ', 46544, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(449, '2024-06-30 23:32:46', '{\"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\":\"f0d891c6c6b4a7db999a106c56ec541fc4fe582bcb175545c1a814c71e9a19c720a66862950745b7128f902346620689\",\"sqr\":\"FEF2198 2024-06-30 23:32:49-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 f0d891c6c6b4a7db999a106c56ec541fc4fe582bcb175545c1a814c71e9a19c720a66862950745b7128f902346620689 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=f0d891c6c6b4a7db999a106c56ec541fc4fe582bcb175545c1a814c71e9a19c720a66862950745b7128f902346620689\",\"ssignature\":\"XxDQxMuuMCCE7R8Lg63XLdP9o5v4bScxeZcE5Nu+7wxY83Ogb/nvKGzBwluK7MO9UGtfiBC0g042+FQMPMFnUxt8ib/64TrHhKadarwl+aIoojA3AHrBG6r/knIx1kImF3lyQKNFRspnXp02FXHrVr4uXYteVJuETPzHTnZCDr4QVc2PNm9DH7HsJ2HYRNXEksVJhzPkoTADcwmMrmGJkIgluD5myaeKg6nrEp1EQDOMK+wSQN6gSu2IhwWS9FwSUYJxziYpJGqBcpGUxTzTQg8wFCX2RRuiRiCfetjUNaLx/0HbDY2Vug3qg/lhKYHWYmlcgWLlE17hRjZb87Deaw==\",\"sdocumentreference\":\"FEF2198\",\"rtaxxadocument\":\"84793483\",\"sref\":\"84793483\",\"irefindex\":2198},\"sdebug\":\"Taxxa: 0.532s DIAN: 0.824s (creación 0.824s, revalidación 0s)\"}', 46544, NULL),
(450, '2024-06-30 23:32:52', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2199,\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: 46545\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608114\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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\":\"00608120\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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   ', 46545, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(451, '2024-06-30 23:32:52', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"21073cffe49a3fbd800f30291cb41cf23abee34e1564057f63673d34175d61025ceb1ce685a7f072e5f808871b025df2\",\"sqr\":\"FEF2199 2024-06-30 23:32:54-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 21073cffe49a3fbd800f30291cb41cf23abee34e1564057f63673d34175d61025ceb1ce685a7f072e5f808871b025df2 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=21073cffe49a3fbd800f30291cb41cf23abee34e1564057f63673d34175d61025ceb1ce685a7f072e5f808871b025df2\",\"ssignature\":\"TYDGYngtfkSSPxWuBHrEkhQWU3ACH55bsuiJESK4iQIDS1kGQj6UbR3wWestJMf9LELUi9LVTh/pVbIMKOR9cak9qjkfSi9ON+h96Yl8JTxWWSnLA8vBX7YsZm9vA7OAMkjYFFF+Mj4VdIgm5annNpZJfWD1Wkma+9fDxUNuoZ25G0dpIyZui4LhTwQy8IXlzoxGQDNQ7CZutNGosoZc+mC107rsNf8HZOF/5PAQSxjJCX3Hc7JcIPAcRqqJD6RYYu3UWdorG561AUJKlby73M0TZ9Se+B93H7w7BGXwdNsVgAKQ7Di2ZAbKc8/woMLDJBOVUx2wX9N7XqJqlGClQw==\",\"sdocumentreference\":\"FEF2199\",\"rtaxxadocument\":\"84793501\",\"sref\":\"84793501\",\"irefindex\":2199},\"sdebug\":\"Taxxa: 0.859s DIAN: 0.92s (creación 0.92s, revalidación 0s)\"}', 46545, NULL),
(452, '2024-06-30 23:32: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-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2200,\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: 46546\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608129\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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\":\"00608135\",\r\n                  \"scustomname\":\"JUGO ADICIONAL DE ALMUERZO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":4166.6666666667,\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   ', 46546, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(453, '2024-06-30 23:32: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\":\"d4cbf7f228d3c23271c146ee17373d8b89a28839875cc38406f5b2941f05f55b1253465220d754077598c08b39a33347\",\"sqr\":\"FEF2200 2024-06-30 23:33:00-05:00 19385248 222222222222 20370.37 0.00 1629.63 22000.00 d4cbf7f228d3c23271c146ee17373d8b89a28839875cc38406f5b2941f05f55b1253465220d754077598c08b39a33347 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d4cbf7f228d3c23271c146ee17373d8b89a28839875cc38406f5b2941f05f55b1253465220d754077598c08b39a33347\",\"ssignature\":\"j4DGVWekP4qa5gW5gEas0T1n+2Xut/rNKU7/jVupqAeH14vU5wtdeUrO6bWo5wS3qyMwNxK7M0WoPFMaDeSuR30rq7cfH30SEbOmWzEWJTpPdm+m7F4H1Vm6FUPoWg64wSCqaL/WEifwe7obRFLCJkDu3EPQoJNv8kglgGj1UnbR7gTlpenojugwl4l8Aw1Gq2qkqrGHKwAGWtUXkjbkHluajJwASJVq/mbkA52TyPHcmwaZC6iSZwV9m3DKpktWk3JovVRgyIMPNzKlsneQL6Wvluf3jkw3vsdoJGzkxyZec2SWch+egcJY3mmuDOAWZJkQ93RgJ+dwM4LoDEmNRQ==\",\"sdocumentreference\":\"FEF2200\",\"rtaxxadocument\":\"84793518\",\"sref\":\"84793518\",\"irefindex\":2200},\"sdebug\":\"Taxxa: 0.528s DIAN: 0.635s (creación 0.635s, revalidación 0s)\"}', 46546, NULL),
(454, '2024-06-30 23:33:01', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-06-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2201,\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: 46547\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608136\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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\":\"00608142\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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   ', 46547, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(455, '2024-06-30 23:33:01', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"9df24692510ab826ddc5e1e6540c52f211c8046f0612b6d0607b62d975a47a90152eda6b91a552fa7d9fa21b028e86f1\",\"sqr\":\"FEF2201 2024-06-30 23:33:04-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 9df24692510ab826ddc5e1e6540c52f211c8046f0612b6d0607b62d975a47a90152eda6b91a552fa7d9fa21b028e86f1 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9df24692510ab826ddc5e1e6540c52f211c8046f0612b6d0607b62d975a47a90152eda6b91a552fa7d9fa21b028e86f1\",\"ssignature\":\"XTrcVxR6THJ5nQNT5PQbZjzMSj5gMeAVzKAUTIm0yt0pYMBNFVjvw+OgDZH2iXMPR8Iat00MHi06Y3N6iA7msDpHFilXvd0lvgeuM8KH5yHMtJbLWRdc7Bgei80q5mp68RaZDr4yQhKi7Z865zjrGEf4GD2IgZ5xxa+7Bqpxyn8wQUfOytRqkZ+sWYVr9Hw4txgo3T9diL8Dckkm8tuAHHfv72XjHV1S0Zr/F/Re2DDWOGk7sgrJiFvnW1nlGtCsMbblKSo45qcKXDj12Mr7B7dXNiSsyrpZx4EjCbWryTNe40Acr5K3oaxixt49vdpBjnjORg2J0S3wOQ0INP3jMA==\",\"sdocumentreference\":\"FEF2201\",\"rtaxxadocument\":\"84793528\",\"sref\":\"84793528\",\"irefindex\":2201},\"sdebug\":\"Taxxa: 0.829s DIAN: 0.754s (creación 0.754s, revalidación 0s)\"}', 46547, NULL),
(456, '2024-06-30 23:33:08', '{\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-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2202,\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: 46548\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608151\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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\":\"00608157\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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   ', 46548, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(457, '2024-06-30 23:33:08', '{\"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\":\"c3e04e6125745717d937b7b4964f3a9f7f1a2e30409db4cea76d09e9f80fee3b9d8a9d76115f48696309d1f69f211b4d\",\"sqr\":\"FEF2202 2024-06-30 23:33:11-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 c3e04e6125745717d937b7b4964f3a9f7f1a2e30409db4cea76d09e9f80fee3b9d8a9d76115f48696309d1f69f211b4d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=c3e04e6125745717d937b7b4964f3a9f7f1a2e30409db4cea76d09e9f80fee3b9d8a9d76115f48696309d1f69f211b4d\",\"ssignature\":\"s2hJ5zdd624gZYznU5h27tapWgzyZ2YFvB2dNnJsuWfWCBG9uHR/RdQVS8++CqzLnA/BNeswCiN3lEQdXf5/mGwgShv9Hp/U4gKMS9sxHWO7RbxWWLqEktBQy9AvLlGpHl7kq3Djy2vYc/Pu4YpNVBTZ0hN/2JYiPCQaQA07xZIJtdhaWbWIJf++1y7c8KrqXuz4mVG/w8EprDJUO1dRFwZWsynJu89y5xJfXnFan/rdRFD9mAVNWLxNIQEdYvO/65DS/44Pk/b5oVV4tu3CAIyGzcgMBMdwAIecG74NjeLvdPA45SqefzVPd8vXcEjrtOKRTKv34/un1j6EbSXn5A==\",\"sdocumentreference\":\"FEF2202\",\"rtaxxadocument\":\"84793547\",\"sref\":\"84793547\",\"irefindex\":2202},\"sdebug\":\"Taxxa: 0.665s DIAN: 0.659s (creación 0.659s, revalidación 0s)\"}', 46548, NULL),
(458, '2024-06-30 23:33:14', '{\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-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2203,\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: 46549\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608166\",\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   ', 46549, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(459, '2024-06-30 23:33:14', '{\"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\":\"1991ea77e6376227fcd582ab6c04908d0f34250de8e4dc00bf301d3f98005bbddf237203b2f40e70d4bc44ff5f34424d\",\"sqr\":\"FEF2203 2024-06-30 23:33:16-05:00 19385248 222222222222 16666.67 0.00 1333.33 18000.00 1991ea77e6376227fcd582ab6c04908d0f34250de8e4dc00bf301d3f98005bbddf237203b2f40e70d4bc44ff5f34424d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=1991ea77e6376227fcd582ab6c04908d0f34250de8e4dc00bf301d3f98005bbddf237203b2f40e70d4bc44ff5f34424d\",\"ssignature\":\"U9Kl/fl2+mhjuN6llYjxD44fbetQ39FwLwA8FSMNERrwwGjLFvP6qOBrC+YXVoqSvj+rECxvPoMN8u4MDz7wAHVeyAmD+ewkCzVymZ2pmHHVBlKDeVkM2wCX4fLYPgC5apQO0ERUoj/7IuG/YRORKQFnhFac4Yojanjx36/tbXyWyHiiZCdToPIqFq0J7ajAXLhwPamsp8/wvp46UaTl4nI98a6EfM0sscJOGyu19OFFLPJ5nSQIH7sIPeBcffy9QGiYQpAjmlhf5RWQW724DAkqFDyA9D1tsFBU+YLfCFrg/uV8JII2fEnrvw2rpPDtloVcF6Kdu6gWEQT3Cg6pOw==\",\"sdocumentreference\":\"FEF2203\",\"rtaxxadocument\":\"84793562\",\"sref\":\"84793562\",\"irefindex\":2203},\"sdebug\":\"Taxxa: 0.522s DIAN: 0.683s (creación 0.683s, revalidación 0s)\"}', 46549, NULL),
(460, '2024-06-30 23:33: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-30\",\r\n               \"tduedate\":\"2024-07-07\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2204,\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: 46553\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00608260\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\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\":\"00608266\",\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               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00608270\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6018.5185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 46553, NULL);
