INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(697, '2024-07-01 21:54:25', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"9b5174a32193d53b42422b7531472755a1d28f1c8a1b5092a486a4b3cefc1b459cc74f44eecc028dd50678cce60d90a3\",\"sqr\":\"FEF2322 2024-07-01 21:54:27-05:00 19385248 222222222222 200000.00 0.00 15999.99 215999.99 9b5174a32193d53b42422b7531472755a1d28f1c8a1b5092a486a4b3cefc1b459cc74f44eecc028dd50678cce60d90a3 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9b5174a32193d53b42422b7531472755a1d28f1c8a1b5092a486a4b3cefc1b459cc74f44eecc028dd50678cce60d90a3\",\"ssignature\":\"roAjTG7BVfyg2+tneZU0TvMG+YqbT5sW421n8lEacElCuomKBtyx2XBXOdUbMvqv0oT7fG4fdOigJIqkouD1XUAzudADlzCwn75RNLe/d+HZa8X8yNF16yMp8ykk92hhljyu2OrUYVKc0zaLzRBbDmWAnsatDg8EbJ3n81gTvaAUX+MAm6UK7QLbXw767zna78i1U6Dm9DFeIGux+x1GpkzSlJPgVwVJuZYZtrz7uYXbl5YNqYF2tY0AZo2HQfni2q2iGSz4mTmWDdVb2TSISU4gjelbSJl4Y9fpUjZk9IWiXRPP/gmaNQTv/x6N6tItAhWOUfj+DWlubD0u2emSCw==\",\"sdocumentreference\":\"FEF2322\",\"rtaxxadocument\":\"85092327\",\"sref\":\"85092327\",\"irefindex\":2322},\"sdebug\":\"Taxxa: 0.472s DIAN: 1.177s (creación 0.799s, revalidación 0.378s)\"}', 46846, NULL),
(698, '2024-07-01 21:54:33', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-01\",\r\n               \"tduedate\":\"2024-07-08\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2323,\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: 46847\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00612087\",\r\n                  \"scustomname\":\"PORCION PAPAS A LA FRANCESA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":8796.2962962963,\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\":\"00612088\",\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\":\"00612092\",\r\n                  \"scustomname\":\"AGUILA LIGHT\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00612093\",\r\n                  \"scustomname\":\"ESCARCHADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00612094\",\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               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00612095\",\r\n                  \"scustomname\":\"CARNE ENTERA 320gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":25000,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 46847, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(699, '2024-07-01 21:54:33', '{\"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\":\"5fa0b17d3adb1eb558925f761ef8e7e704fcb130fce1ff9be1fbca8c24d988cec0a9e6e3d752788e0b30baeae09acefd\",\"sqr\":\"FEF2323 2024-07-01 21:54:34-05:00 19385248 222222222222 72685.19 0.00 5814.81 78500.00 5fa0b17d3adb1eb558925f761ef8e7e704fcb130fce1ff9be1fbca8c24d988cec0a9e6e3d752788e0b30baeae09acefd https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=5fa0b17d3adb1eb558925f761ef8e7e704fcb130fce1ff9be1fbca8c24d988cec0a9e6e3d752788e0b30baeae09acefd\",\"ssignature\":\"Am0K6IAdxvNMXUArTJ6g+8sxg3KVzbCU0Kj95O8jZ00ylj0JyeObHVC5mhOrz3noYDakPFAFb/8iXUJBdbUI1hUVeviH0YuMFxzCt8yxdluoVuGXFbqKV6LAwqXAw3QEnYxX4vpvwoBKULTuEBFruoVHLPR7E3fOkvJuaqirH32rTD+sz4MFNNMggIzxhYBB5ohUwu19gJ4+xJGrJcRvf6LRCACTRw8eV2sv8b+MtPRtVn4dSbjGkHPGfWGaVrTobWmYTG7w0ulEYx1FHdG0s4AkaRJx4WpNQPA7KJqdHvXDN/dUwfjY+RCGeys0VZZsztHmeNIcf3DQ2CJ3hi2fvg==\",\"sdocumentreference\":\"FEF2323\",\"rtaxxadocument\":\"85092361\",\"sref\":\"85092361\",\"irefindex\":2323},\"sdebug\":\"Taxxa: 0.318s DIAN: 1.282s (creación 0.936s, revalidación 0.347s)\"}', 46847, NULL),
(700, '2024-07-01 21:54:56', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-01\",\r\n               \"tduedate\":\"2024-07-08\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2324,\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: 46829\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00611835\",\r\n                  \"scustomname\":\"COMBO INFANTIL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15277.777777778,\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\":\"00611837\",\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\":\"00611841\",\r\n                  \"scustomname\":\"AREPA GRATINADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3703.7037037037,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00611842\",\r\n                  \"scustomname\":\"BURGER TRIMIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":26388.888888889,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00611847\",\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               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00611851\",\r\n                  \"scustomname\":\"JARRA DE LIMONADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":13425.925925926,\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   ', 46829, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(701, '2024-07-01 21:54:56', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"6cf9f526762d36b3df73100df4477a454d76829044209d1ee23c9ecff4a9201d1d8b0ead8125a40c4bfd5c49468c9a9f\",\"sqr\":\"FEF2324 2024-07-01 21:54:58-05:00 19385248 222222222222 108796.30 0.00 8703.70 117500.00 6cf9f526762d36b3df73100df4477a454d76829044209d1ee23c9ecff4a9201d1d8b0ead8125a40c4bfd5c49468c9a9f https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=6cf9f526762d36b3df73100df4477a454d76829044209d1ee23c9ecff4a9201d1d8b0ead8125a40c4bfd5c49468c9a9f\",\"ssignature\":\"ItjBQE3jsIaDBbamSZ2ooSiA9pTaOE6EspXeQUj21qwue7JfMy2In4TGgltI8pmwfsfkbvJ9qk8m6HWKpAEI3HU0quDnelbJlzjRY2k6Km6APaESZoYV6F35PLipKutp0zoEsNkiS49uPhyPu+3+9u05ku31/Ha8cTebk5JxNAyIPvODww2eNGO81X0bM+mr1GWRX2lrSpGCkDDjuS8bL4pQV6Fk6M8VE81F3R7aoMaqTUdmELvKF9QSeRL/bJxo4ibzF0Jk/Xx63XKdXBMEqgbICKWSVilVkx2j8upjfNQG2aaSDEoCF7djqAmz6q3w4OY6tC3ZgPk5pwPfK8gP+A==\",\"sdocumentreference\":\"FEF2324\",\"rtaxxadocument\":\"85092468\",\"sref\":\"85092468\",\"irefindex\":2324},\"sdebug\":\"Taxxa: 0.425s DIAN: 1.441s (creación 0.721s, revalidación 0.721s)\"}', 46829, NULL),
(702, '2024-07-01 21:55:07', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-01\",\r\n               \"tduedate\":\"2024-07-08\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2325,\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: 46834\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00611926\",\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\":\"00611929\",\r\n                  \"scustomname\":\"SALCHIPAPA AGRANDADA CON CARNE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21759.259259259,\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\":\"00611931\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00611934\",\r\n                  \"scustomname\":\"CARNE TRIMIXTA 460gr\",\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               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00611939\",\r\n                  \"scustomname\":\"CARNE TRIMIXTA 460gr\",\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               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00611944\",\r\n                  \"scustomname\":\"JARRA DE LIMONADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":13425.925925926,\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   ', 46834, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(703, '2024-07-01 21:55:07', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"7bf75623a8adf9ebb3d687d5ec0597fb65ba2ed255dea836aa0785c6034f882e05baa35a893bfc290a2cbc68ac30bcb4\",\"sqr\":\"FEF2325 2024-07-01 21:55:09-05:00 19385248 222222222222 140740.74 0.00 11259.26 152000.00 7bf75623a8adf9ebb3d687d5ec0597fb65ba2ed255dea836aa0785c6034f882e05baa35a893bfc290a2cbc68ac30bcb4 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=7bf75623a8adf9ebb3d687d5ec0597fb65ba2ed255dea836aa0785c6034f882e05baa35a893bfc290a2cbc68ac30bcb4\",\"ssignature\":\"AS6JUd2i/QQLa8nnorUyePkEiiZHqqEOKN1UFwA7cCI4pIfCK+vwtRYS0YiXy06fu9x/xdYR5XFP3xRtIkn5aJcI3q4ytLPPxRrV8NA/UEWppjFflqX/XOkmlEFNJ/dT0QarGFDEzcwYL65MtXsim8HkN940FLOnVbHWZNTkjaTNRRJU2ex/fA1EXo7vhV0mUKMrQpp02gJA60/OFSUZR7tzceflVMlUp4hwl5rhwN+efuCHOP0bcRXxQzdBH8SG3bS3gZkset4oyIE1NovOIjLVyu//Obcye6W/xl2GjhcC58SS3x3IGP7GHjXOlA66GlK+K9we4pzYDDBM92t2fg==\",\"sdocumentreference\":\"FEF2325\",\"rtaxxadocument\":\"85092517\",\"sref\":\"85092517\",\"irefindex\":2325},\"sdebug\":\"Taxxa: 0.586s DIAN: 1.114s (creación 0.707s, revalidación 0.407s)\"}', 46834, NULL),
(704, '2024-07-01 22:17:22', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-01\",\r\n               \"tduedate\":\"2024-07-08\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2326,\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: 46697\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00610152\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\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\":\"00610158\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\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   ', 46697, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(705, '2024-07-01 22:17:22', '{\"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\":\"9aecc291402d69fcbbcff3349ab22cab3abb67f4d74aa599344f6f2e61cd40322772c09df636a50b572d00be2c7a8b24\",\"sqr\":\"FEF2326 2024-07-01 22:17:24-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 9aecc291402d69fcbbcff3349ab22cab3abb67f4d74aa599344f6f2e61cd40322772c09df636a50b572d00be2c7a8b24 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=9aecc291402d69fcbbcff3349ab22cab3abb67f4d74aa599344f6f2e61cd40322772c09df636a50b572d00be2c7a8b24\",\"ssignature\":\"dw6Ad48T4t/SMD//w/f7M1lJWi+D/K36CL+K+ZvIS0RPITbaQF0MVXipuLLQWRmqOE2gzFnyNz9tnd6FgfnJsJI8tX3Khl5ee1gxc/SSQ8xr3sL8qAxNefIetwTluOZzQGk/iBc7INsAnxFcDLYHfrvnXViTjcGpEncfpKA+T2gv7FM1QXu/6+IaxLt0zcf14UO/ofZjd31Q9D0OHOGAKH3LeLdmutT9R81600KGnWnAUf7RrA/YhIJsqVx8Nrzq266TGHurImV5KYOLaIvERDf5lUUcYHjNu3gt4rpXWWI3288scidq2wHdyqnRafn09oWsJlmEDD1xUeuYUheTJg==\",\"sdocumentreference\":\"FEF2326\",\"rtaxxadocument\":\"85095894\",\"sref\":\"85095894\",\"irefindex\":2326},\"sdebug\":\"Taxxa: 0.35s DIAN: 1.502s (creación 1.127s, revalidación 0.375s)\"}', 46697, NULL),
(706, '2024-07-02 12:22:00', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-02\",\r\n               \"tduedate\":\"2024-07-02\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2327,\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\":\"MARCELA DIAZ      \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"MARCELA DIAZ      \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3113057819\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CLL 1 12 17 EDIFICIO LUXOS ACCESO 2 LOCAL 3\",\r\n                        \"szip\":\"630003\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46854\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"17\",\r\n                         \"namount\": 3000,\r\n                         \"nbaseamount\": 16203.703703703703\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00612176\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 46854, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(707, '2024-07-02 12:22:00', '{\"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\":\"c90eb2e79122d0beb2604d20e591d6c147d0cacb60d21c0b94494edfa9f033c111ba2073e9f37e4e3638a09fccc58076\",\"sqr\":\"FEF2327 2024-07-02 12:22:03-05:00 19385248 222222222222 16203.70 0.00 1296.30 20500.00 c90eb2e79122d0beb2604d20e591d6c147d0cacb60d21c0b94494edfa9f033c111ba2073e9f37e4e3638a09fccc58076 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=c90eb2e79122d0beb2604d20e591d6c147d0cacb60d21c0b94494edfa9f033c111ba2073e9f37e4e3638a09fccc58076\",\"ssignature\":\"BtwGpuFkGGycYyyaQP4cPlGvHDEpO9QXNp5uoVE2Us+KlcFEQI6cUBcrMfokMiz1ctcCsYnOfi5AXD3xUKWQKVuJmipwd5V+QzgunqjjJb2Rd7OvHu5faZ0vPwa99u+RuCmVWZkLnC8tBagAyHpzaOyG0wBEXMIZ2D2t6uMbaTmI8ubLznAmP75+UlelPrPzYVvXs7VA2thQNLzW1TzHVAo4wBYYiDgiUESXXoXqiu8TLe1vGjkTnl4q/YwEou2I0d9G5F7st4GONc0l6xF1kPuLbIZbThko24PNoniawIYGwJ7dHjfx21gfII0/tsfSOPUY5nQgwKY315LHARz6gg==\",\"sdocumentreference\":\"FEF2327\",\"rtaxxadocument\":\"85219746\",\"sref\":\"85219746\",\"irefindex\":2327},\"sdebug\":\"Taxxa: 3.225s DIAN: 3.678s (creación 2.056s, revalidación 1.622s)\"}', 46854, NULL),
(708, '2024-07-02 12:34:11', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-02\",\r\n               \"tduedate\":\"2024-07-09\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2328,\r\n            \"wpaymentmethod\": 10,\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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: 46856\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00612190\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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\":\"00612196\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 46856, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(709, '2024-07-02 12:34: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\":\"5ae6662f9a316fc6e44f6eaf5520fd60b6cfaff23c249adcabc019f7fd858b0b2290cdce25ebafc367e8146bd041d5c7\",\"sqr\":\"FEF2328 2024-07-02 12:34:13-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 5ae6662f9a316fc6e44f6eaf5520fd60b6cfaff23c249adcabc019f7fd858b0b2290cdce25ebafc367e8146bd041d5c7 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=5ae6662f9a316fc6e44f6eaf5520fd60b6cfaff23c249adcabc019f7fd858b0b2290cdce25ebafc367e8146bd041d5c7\",\"ssignature\":\"jqVxrolU0WWfuUqUzPEjqY4Q8hpKhnNkwMvRIyhmZbxeBqUNtGeoXn9W9duw1nvPW+rIXr1loQ5RORHki82kKOI8gRMJppb64/x0+A/DpEVh4qj1ZPkr3yHdX9NhwCoqaJHslr/206mlgmTNSddYEUnrgkKtlRph08ueGjWSrjQobQI5pwTcU9P8oK/lfKjUERapzfVHdQn5s9DRH+t9KOIE4/FFIug8mupm7JfLWmDtJNBP45bVgu4e30ZZMd71FxF4PQ46gYLqui7o6HXzwhK81uSma+EgZa6ii/R//AZF9HlqBP0ntU996UFIxHApjb8r9jF3FDYzafc6aaECfw==\",\"sdocumentreference\":\"FEF2328\",\"rtaxxadocument\":\"85221950\",\"sref\":\"85221950\",\"irefindex\":2328},\"sdebug\":\"Taxxa: 3.707s DIAN: 3.902s (creación 2.491s, revalidación 1.411s)\"}', 46856, NULL),
(710, '2024-07-02 13:09:39', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-02\",\r\n               \"tduedate\":\"2024-07-09\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2329,\r\n            \"wpaymentmethod\": 10,\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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: 46873\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00612409\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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\":\"00612415\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 46873, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(711, '2024-07-02 13:09:39', '{\"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\":\"7d845f68744a236d6b5ed0bc5330d25d8d81e66e5a937c3d15de7821cfef93c9858d4bab303084d70848b401b3ef3e7c\",\"sqr\":\"FEF2329 2024-07-02 13:09:41-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 7d845f68744a236d6b5ed0bc5330d25d8d81e66e5a937c3d15de7821cfef93c9858d4bab303084d70848b401b3ef3e7c https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=7d845f68744a236d6b5ed0bc5330d25d8d81e66e5a937c3d15de7821cfef93c9858d4bab303084d70848b401b3ef3e7c\",\"ssignature\":\"FmWOkHLPDckbi9BwV7yf7KUkY9buPZZh+vo4ZhXHi8a6eQmAq+rqVkFeNjzyR/T8eip1Q1EtBug2nnHe8aLRtq6Ytrrzgp4+JUpDPFwecSSn5Hx2AayiF6C8INRVEQKdgDpALRP1fqsyRjfe/E/IxqkUc679bfOeVEbrMu3wgxsTKgmkxH+cTe2gr6SPCul44Wjp0HZjgiiTPSd1wQKlQnUpnICm3VzLlNuuywv3/0FQGeESjGypXR0pC3t4KRwP0tr8SMspwKKRHmwo4kbDNDWYFGlyGBZrbV1O/LEpoJk1vaZvtI3V3xdJZ44Ni4VkKkMBuZgN4mxz6mgS0qp5Ag==\",\"sdocumentreference\":\"FEF2329\",\"rtaxxadocument\":\"85229703\",\"sref\":\"85229703\",\"irefindex\":2329},\"sdebug\":\"Taxxa: 3.086s DIAN: 3.332s (creación 2.185s, revalidación 1.147s)\"}', 46873, NULL),
(712, '2024-07-02 13:23:11', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-02\",\r\n               \"tduedate\":\"2024-07-09\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2330,\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: 46877\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00612461\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00612464\",\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               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00612467\",\r\n                  \"scustomname\":\"COMBO INFANTIL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":15277.777777778,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00612469\",\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               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00612472\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00612478\",\r\n                  \"scustomname\":\"JARRA DE LIMONADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":13425.925925926,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"7\":{\r\n                  \"sStandardItemIdentification\":\"00612479\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7222.2222222222,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"8\":{\r\n                  \"sStandardItemIdentification\":\"00612481\",\r\n                  \"scustomname\":\"PORCION YUCA CROCANTE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":8796.2962962963,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"9\":{\r\n                  \"sStandardItemIdentification\":\"00612482\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7222.2222222222,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 46877, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(713, '2024-07-02 13:23: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\":\"60c46bb5303f0436812046aa6e797774341625def401435b83706534bfecf38cde5094e5d21ed4be808b541b7a9169d6\",\"sqr\":\"FEF2330 2024-07-02 13:23:13-05:00 19385248 222222222222 134814.81 0.00 10785.18 145599.99 60c46bb5303f0436812046aa6e797774341625def401435b83706534bfecf38cde5094e5d21ed4be808b541b7a9169d6 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=60c46bb5303f0436812046aa6e797774341625def401435b83706534bfecf38cde5094e5d21ed4be808b541b7a9169d6\",\"ssignature\":\"Aew3fEkb5ACWJWKkSg+yv///G0r27p18YrO1JNKWDkTHe9X8z2QFt9SbkDZ/Y/5UXb1JAg9ytYK8vB+2f3jksije1bbChJmLJb8TbUZDU2DK1r9/UVnDbFe3cTDeUSJyNicz5pDuCT9S4QLZrCNLi7FNwfmNDrWGaD5js9PVj/qtpJGxyVSULyIFYCVgb+vE8gyM3f3Xh7eJNDyzCV2uN35V+6+LbVfw7xgFj8XQ++AZ9HG1izQTBqOZXvVFywQZxI9KTZ3OGynVs6S/i5itLB+bjgXcsRZJ0rRhouZ+Dp8U+LW1wtZT1EV+gxVmrekfRYRvnDCR8m4xSHPE5VNzyw==\",\"sdocumentreference\":\"FEF2330\",\"rtaxxadocument\":\"85232998\",\"sref\":\"85232998\",\"irefindex\":2330},\"sdebug\":\"Taxxa: 3.176s DIAN: 2.299s (creación 1.738s, revalidación 0.561s)\"}', 46877, NULL),
(714, '2024-07-02 13:28:38', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-02\",\r\n               \"tduedate\":\"2024-07-09\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2331,\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\":\"O-47\",\r\n                  \"sfiscalregime\":\"48\",\r\n                  \"scustomername\":\"LABORATORIOS BLASKOV\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"800198146\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"3450650\",\r\n                     \"selectronicmail\":\"800198146@factureinbox.co\",\r\n                     \"stelephone\":\"3168780505\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"11\",\r\n                        \"wtowncode\":\"11001\",\r\n                        \"scityname\":\"BOGOTA D.C\",\r\n                        \"saddressline1\":\"TV 25 53 C 50 BRR GALERIAS\",\r\n                        \"szip\":\"110011\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46880\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00612538\",\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   ', 46880, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(715, '2024-07-02 13:28:38', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAK57, Notificación: Estructura de código no valida\",\"1\":\"Regla: FAK58, Notificación: Estructura código no valida\",\"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: 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.\",\"5\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"6\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"ba8939af31275b23e5ec8858eda03d0a2110a89391f868246a0e8edaeaf5b2f4c3f941572ff90b1d0fd8bb2c4ec5c14b\",\"sqr\":\"FEF2331 2024-07-02 13:28:41-05:00 19385248 800198146 14351.85 0.00 1148.15 15500.00 ba8939af31275b23e5ec8858eda03d0a2110a89391f868246a0e8edaeaf5b2f4c3f941572ff90b1d0fd8bb2c4ec5c14b https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=ba8939af31275b23e5ec8858eda03d0a2110a89391f868246a0e8edaeaf5b2f4c3f941572ff90b1d0fd8bb2c4ec5c14b\",\"ssignature\":\"pdW8TUv1W3KUFddcCyFNKFZ2sSxxnWgETwhfwN8YeBVP7b1Mg6x0LqhgLY33XIWXluJDTr+U5ADwc33pjvMgv6MR9ySmXG5Cc185mObeNb6lQtZKvlxD2bBYECPGBcb3MJcfVlhrm0rfODtHg4lL43IFHgd5ffJWBam7r7oAdTMIL3qO2m2VIvGsn+R/UZ+6uhNq/bG1aNFyBlyz6nTvPm5tBua0Cg29EgczSs/9c8PyJqKH4QC5NZ5ibrHOmz+8QuK/Zd55gusGCv9US5tbOA/UTXBCUo3MAFSxKJkaB1J6X7tufXarBFOQq0MTE9eZcMUJjcRnHQT4ROE+lPFZ0w==\",\"sdocumentreference\":\"FEF2331\",\"rtaxxadocument\":\"85234356\",\"sref\":\"85234356\",\"irefindex\":2331},\"sdebug\":\"Taxxa: 3.647s DIAN: 3.525s (creación 1.955s, revalidación 1.57s)\"}', 46880, NULL),
(716, '2024-07-02 13:29: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-07-02\",\r\n               \"tduedate\":\"2024-07-09\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2332,\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\":\"O-47\",\r\n                  \"sfiscalregime\":\"48\",\r\n                  \"scustomername\":\"LABORATORIOS BLASKOV\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"800198146\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"3450650\",\r\n                     \"selectronicmail\":\"800198146@factureinbox.co\",\r\n                     \"stelephone\":\"3168780505\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"11\",\r\n                        \"wtowncode\":\"11001\",\r\n                        \"scityname\":\"BOGOTA D.C\",\r\n                        \"saddressline1\":\"TV 25 53 C 50 BRR GALERIAS\",\r\n                        \"szip\":\"110011\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46881\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00612545\",\r\n                  \"scustomname\":\"EJECUTIVO MARTES\",\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   ', 46881, NULL);
