INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1484, '2024-07-09 22:15:48', '{\"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\":\"3059c5ef33e859d0a4cb3108d4d2b8860e7c1baa6080262c07abef7cee1dd712ebbbe8f803f1e4cdb1b8a0c79152249f\",\"sqr\":\"FEF2710 2024-07-09 22:15:52-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 3059c5ef33e859d0a4cb3108d4d2b8860e7c1baa6080262c07abef7cee1dd712ebbbe8f803f1e4cdb1b8a0c79152249f https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=3059c5ef33e859d0a4cb3108d4d2b8860e7c1baa6080262c07abef7cee1dd712ebbbe8f803f1e4cdb1b8a0c79152249f\",\"ssignature\":\"KoXe6UJ1OKEO0m40N9a+X/L41yNquuXhhdVViMafMHAinuUASF/V6v6NSrfHBHFq4FsnkZwZeeanjBD9ih3xt18lDFUy6qCRbipuP1e7FvzfpIbBIkX0+/zAN2TNzexscgPo6PZfs1jQSqmraz+k8Alc7PW61T6OWtnJ7rWm0OfmV0ehyhZmabxPlG4ZatqOOk57bi4BM7eZGg/yjEVZaTbSMVoix+wZrRCLeV2YFLGXYE+/UgJU/W9eAwHDLgCANwaR/mRsY0f0qNO2Bx/dl05+w+QL1wNYFQQ/kC4t7pmO3KQ1SiXEn9M7sRuwZgXiWgg7yqk2vnNRihyeAcKjpA==\",\"sdocumentreference\":\"FEF2710\",\"rtaxxadocument\":\"87560200\",\"sref\":\"87560200\",\"irefindex\":2710},\"sdebug\":\"Taxxa: 0.156s DIAN: 1.578s (creación 0.859s, revalidación 0.719s)\"}', 47559, NULL),
(1485, '2024-07-09 22:15: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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2711,\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: 47582\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621303\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00621304\",\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   ', 47582, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1486, '2024-07-09 22:15:56', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"1\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"2\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"767b584cfc98e2302e6f2e72cfbfc6dd269eaa067cf8189a8a659b96a103bd3aee3ead791f9db57d62e70f237c505809\",\"sqr\":\"FEF2711 2024-07-09 22:15:59-05:00 19385248 222222222222 30092.59 0.00 2407.41 32500.00 767b584cfc98e2302e6f2e72cfbfc6dd269eaa067cf8189a8a659b96a103bd3aee3ead791f9db57d62e70f237c505809 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=767b584cfc98e2302e6f2e72cfbfc6dd269eaa067cf8189a8a659b96a103bd3aee3ead791f9db57d62e70f237c505809\",\"ssignature\":\"RUqlVguKMw7Pn7n1SrhopurodnFdJ5npnmnUcLSCm+/i8pIRe3y4QWiZUmTU6Ub+/zg6nZzB2bCLJNbpWhB7ZHa/bzPUxoWvnYMMZ30AClF69nYF/d+PUGzr/5IaAPymj+Lo5OeBmF7DcIiYtls+wegbujUPvIC9OtG/HxBRG/Ecz/Ovk3+egLEAfhbGWfabWagWvMew8eekHuf/Q4xdNCKWkNew90oVTSEaoCp5/TkXucyy8pP8s5VXrppPoD1QSV/eTFOZwsrO+3LA7RF7WKZq1CQIYbwM1mguG1sPFCQtsR4UBFXJBiLUPqjCK+OFUs9E7JfJMKt98xRqtZkzVA==\",\"sdocumentreference\":\"FEF2711\",\"rtaxxadocument\":\"87560271\",\"sref\":\"87560271\",\"irefindex\":2711},\"sdebug\":\"Taxxa: 0.151s DIAN: 1.406s (creación 0.656s, revalidación 0.75s)\"}', 47582, NULL),
(1487, '2024-07-09 22:16:02', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2712,\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: 47576\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621229\",\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\":\"00621232\",\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   ', 47576, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1488, '2024-07-09 22:16:02', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"1a14b9ca2d445d404aefecd058b3a932990efd12c888dec1bafd4513798a50e954e15f52d458cdb015ebec22655d872e\",\"sqr\":\"FEF2712 2024-07-09 22:16:05-05:00 19385248 222222222222 27314.81 0.00 2185.18 29499.99 1a14b9ca2d445d404aefecd058b3a932990efd12c888dec1bafd4513798a50e954e15f52d458cdb015ebec22655d872e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=1a14b9ca2d445d404aefecd058b3a932990efd12c888dec1bafd4513798a50e954e15f52d458cdb015ebec22655d872e\",\"ssignature\":\"Z+ugTIRuhBtBbLiUvODkpuBJ+60ZKyt+MKDaGlxnEswVwnnRNAB7sbBiTQe6r8LnGw5tlnJ40ekU2kNke42lZ7O5Y5mdi0IzbpdlY+GXZ1yQUFa82M65W840f/e7Gfj8GzxOQiJw9uDbA/ERNr3V1mb4wTjhTnD+Iy/o6krh5NdGSMj++c+kgztBh+m+ltLZJDZGmKUEwbRA75HM7sVqhof6jJEoRUdasj+NE2sJQOp/SGjBvMt+Mz/OFgannL8QZ0nW+NNDxPHo0cwzmm4qDC4bESSwHhXj5SgklWxi56lPDUz4Tv2knatXnnlWnNGB+YS6cjvB3tpMBaXamhaU4w==\",\"sdocumentreference\":\"FEF2712\",\"rtaxxadocument\":\"87560320\",\"sref\":\"87560320\",\"irefindex\":2712},\"sdebug\":\"Taxxa: 0.182s DIAN: 1.294s (creación 0.607s, revalidación 0.687s)\"}', 47576, NULL),
(1489, '2024-07-09 22:16: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-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2713,\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: 47560\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621035\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47560, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1490, '2024-07-09 22:16: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\":\"f8035ad8c8b55aa86264da4e09567ae835722b435f46d6aba85b205f58a2515c10066264fb3c95723da8623a97ae9102\",\"sqr\":\"FEF2713 2024-07-09 22:16:11-05:00 19385248 222222222222 21296.30 0.00 1703.70 23000.00 f8035ad8c8b55aa86264da4e09567ae835722b435f46d6aba85b205f58a2515c10066264fb3c95723da8623a97ae9102 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=f8035ad8c8b55aa86264da4e09567ae835722b435f46d6aba85b205f58a2515c10066264fb3c95723da8623a97ae9102\",\"ssignature\":\"g9Hsx7rgbeDg6FqSCxjCGy8pRGD+b02+w8vE7JflyPEE+0SvBQ08pcCQ3FgotLVejlxxign7jYDKIMsaGf0kaiLvRMpL55sZVmjW1kE/h3mV92bwIqGAzhRdsr6c5sp4PmPjm39+AOrSkdn2DzLAVKp8khkC20cxGygRM6/tqZ87JzV4phsQv0hb18u70nuVUmM7ZNIXTR+F1MgUx25zLLXtJWzRkJrGmmaWMJmlRWtFZv4DCZeQ27aztA/ygqsDW9rwt5Vo5qgcPMDyx+k6gycX/mjUj5cAcAJ21upvpbKVD/m7thqqyV4fN6/hwZUdtB9Ft4bL+tRKnwJmqYP0yg==\",\"sdocumentreference\":\"FEF2713\",\"rtaxxadocument\":\"87560376\",\"sref\":\"87560376\",\"irefindex\":2713},\"sdebug\":\"Taxxa: 0.156s DIAN: 1.308s (creación 0.683s, revalidación 0.625s)\"}', 47560, NULL),
(1491, '2024-07-09 22:16:13', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2714,\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: 47561\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621038\",\r\n                  \"scustomname\":\"CHULETON DE CERDO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":30092.592592593,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\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   ', 47561, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1492, '2024-07-09 22:16:13', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"7c8b4954dfebc633967805203ba119e501284416de3ec6029a4992491f1d296892c08fc6c854aeb9a13f6a8af7934117\",\"sqr\":\"FEF2714 2024-07-09 22:16:17-05:00 19385248 222222222222 30092.59 0.00 2407.41 32500.00 7c8b4954dfebc633967805203ba119e501284416de3ec6029a4992491f1d296892c08fc6c854aeb9a13f6a8af7934117 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=7c8b4954dfebc633967805203ba119e501284416de3ec6029a4992491f1d296892c08fc6c854aeb9a13f6a8af7934117\",\"ssignature\":\"t4el6MqRrcPl6W7k4p7SB1tuWCIBWAlyrpizH+9E14JQYuPMgPjbt+LekFtwtB9IL6aV4VLULrkUF7XxX3QXCSaPfNG7PiDWjc6B8qsCSEMyvOzoAiTrvCx4yHrUSp7pvgHpCbcRm/tJSqeFfN3QEYTZSDPs2ymiGHP2fXI5DmbryR17M3K0umeWkpgel3T3gKTDBj0n/Nz0tWn1pyH4K6zCpJpyPqfqGnSuOSg+vn9QlnWFFtvqjrd/Jc5caySjQdqtka1YhXpONRgfTf8f5DNk9wfNN+b/yb5n1wxjzrJy/xg5XAemXUk/F5nIAJVG72pI+UgpoyGfHqsKgBAang==\",\"sdocumentreference\":\"FEF2714\",\"rtaxxadocument\":\"87560421\",\"sref\":\"87560421\",\"irefindex\":2714},\"sdebug\":\"Taxxa: 0.141s DIAN: 1.563s (creación 1.203s, revalidación 0.359s)\"}', 47561, NULL),
(1493, '2024-07-09 22:16: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-07-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2715,\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: 47562\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621041\",\r\n                  \"scustomname\":\"CLUB COLOMBIA\",\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   ', 47562, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1494, '2024-07-09 22:16:19', '{\"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\":\"6ec76610da32411c6e2f3f50d148e32ac2a2b535965b726e102c797a2105209144172c5f4451880b38ac95286e7bccaa\",\"sqr\":\"FEF2715 2024-07-09 22:16:22-05:00 19385248 222222222222 6018.52 0.00 481.48 6500.00 6ec76610da32411c6e2f3f50d148e32ac2a2b535965b726e102c797a2105209144172c5f4451880b38ac95286e7bccaa https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=6ec76610da32411c6e2f3f50d148e32ac2a2b535965b726e102c797a2105209144172c5f4451880b38ac95286e7bccaa\",\"ssignature\":\"nOqhOK/4cBSL3BP8FGa/UeFJuKHzdHoKXLcCF9muNfDEOwLRrYNigOo4f+PPx5gVl4bnbtzOKDNVOivM2lkyuxOmy8b1dA8nH6vgNPFOCPZpisssAUS4SSyvRAPTWv1o65LhCtto8IAFYkBAbFEI0azOF5h7BV1OQ3EKLVVQ5KA7zWx7PAErAAQTva4qJ8LVcar/PlJ74bAvFsjaB9xVVvMIS3E6hxX230zs4xKy530DYULwKD991mHq4Bc//1pBFRfy0bCssKHaXCbVM+/jK308tlyTC9UIZrSPZoOuVPxbAon/jxld8QJhIwP2DzQtZU7Uz0JXyPlipe4sxhmTQA==\",\"sdocumentreference\":\"FEF2715\",\"rtaxxadocument\":\"87560489\",\"sref\":\"87560489\",\"irefindex\":2715},\"sdebug\":\"Taxxa: 0.141s DIAN: 0.984s (creación 0.641s, revalidación 0.344s)\"}', 47562, NULL),
(1495, '2024-07-09 22:16:25', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-09\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2716,\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: 47572\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621177\",\r\n                  \"scustomname\":\"CARNE ENTERA 320gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":25000,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00621181\",\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   ', 47572, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1496, '2024-07-09 22:16: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\":\"3e40b537574151facb011beb8b50bce2eb4b4c9bee66576cb4353b2ba2195e9f856806f368cbfdd34f9e8f33e06330d4\",\"sqr\":\"FEF2716 2024-07-09 22:16:30-05:00 19385248 222222222222 32222.22 0.00 2577.78 34800.00 3e40b537574151facb011beb8b50bce2eb4b4c9bee66576cb4353b2ba2195e9f856806f368cbfdd34f9e8f33e06330d4 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=3e40b537574151facb011beb8b50bce2eb4b4c9bee66576cb4353b2ba2195e9f856806f368cbfdd34f9e8f33e06330d4\",\"ssignature\":\"YuDu/rkxFoKylqXgxWeeBjOAm4wivX16uWQ073FwbYuwUxK3AR9DuCU1fYQLXDjnI2Gz0MvL/hcYafxdQKuFtIGxJIRzOGm3vLQCNCidvsh2dLlQEQEI+mZ37klKN4tLABkEriDB8SzGJ5H1BpcxKR3cDJCdsx4LrfT5FKYqypmTRSc2oEp/evgPYIsx3B5qCbthm+y8kWcQJzVBXAOGlRq99UFW9luixt7LmywSVnLZSPZ06V8qUZ3pJIjrP+7GDA7Dzs1HhqxZXIl8JbcYXaAXytiDSotDK7ghYggM9bUo4W6n2iYA91o5M7er7BSR99alsnRj0qrRFHnSP6bxFA==\",\"sdocumentreference\":\"FEF2716\",\"rtaxxadocument\":\"87560519\",\"sref\":\"87560519\",\"irefindex\":2716},\"sdebug\":\"Taxxa: 0.146s DIAN: 1.45s (creación 0.981s, revalidación 0.469s)\"}', 47572, NULL),
(1497, '2024-07-10 12:22:09', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-10\",\r\n               \"tduedate\":\"2024-07-17\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2717,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"48\",\r\n                  \"scustomername\":\"P.L FIRMA SAS \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"901507511\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"P.L FIRMA SAS \",\r\n                     \"selectronicmail\":\"servicioalcliente@pongalelafirma.net\",\r\n                     \"stelephone\":\"3103491350\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"11\",\r\n                        \"wtowncode\":\"11001\",\r\n                        \"scityname\":\"BOGOTA D.C\",\r\n                        \"saddressline1\":\"CL 124 57 45 IN 1 AP 702 \",\r\n                        \"szip\":\"110011\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47596\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621485\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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\":\"00621491\",\r\n                  \"scustomname\":\"JUGO NATURAL LECHE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7407.4074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47596, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1498, '2024-07-10 12:22:09', '{\"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\":\"0d91ecb2a4168c8fc6cf640d1e5a4c82772a2dbfd8a1cf77978d1a92d75b000fbfce255bf75c50dea12fa7aed6fce066\",\"sqr\":\"FEF2717 2024-07-10 12:22:12-05:00 19385248 901507511 23611.11 0.00 1888.89 25500.00 0d91ecb2a4168c8fc6cf640d1e5a4c82772a2dbfd8a1cf77978d1a92d75b000fbfce255bf75c50dea12fa7aed6fce066 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=0d91ecb2a4168c8fc6cf640d1e5a4c82772a2dbfd8a1cf77978d1a92d75b000fbfce255bf75c50dea12fa7aed6fce066\",\"ssignature\":\"RPB1GW6HCNvViQ32XLBh3Cm8w+H674Bdv4nzaxc9ivdF8falzuKQ/iDTfeiTPYwdmsr6Gh/VFu3sDpHTchX2gvLizOSTRhTLScTpUN7ywnHyuPMGduE7QzBPna0fpgIyEDPl1u3UVSn2M+iX3fxQ1WtTJzVBpny8XAJxrdMpb3EbkJ5oaaLOfQEzKRUQhzBEZmprasLcfilM+zc1U2TdDtkzKvvvd7n+jsrA/p1XSBV4IM9XCVYUyV0UYQK1piYnvmLlG8xIZy+Ygz1nrBGAzP/SH2vx4werD2hsLqnwVilHh3qyQV6OvBi1TgZT/wzJaQgTwG17efBbWg70IRVMeA==\",\"sdocumentreference\":\"FEF2717\",\"rtaxxadocument\":\"87733701\",\"sref\":\"87733701\",\"irefindex\":2717},\"sdebug\":\"Taxxa: 0.121s DIAN: 1.896s (creación 1.186s, revalidación 0.711s)\"}', 47596, NULL),
(1499, '2024-07-10 21:54:23', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-10\",\r\n               \"tduedate\":\"2024-07-17\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2718,\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: 47583\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621306\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":2,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47583, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1500, '2024-07-10 21:54: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\":\"ac0db56e596a32169d732da921444bcfa0702645c3af93c248fb8bc264c38242b273d03fc30452785b37606a22493ad2\",\"sqr\":\"FEF2718 2024-07-10 21:54:26-05:00 19385248 222222222222 42592.59 0.00 3407.41 46000.00 ac0db56e596a32169d732da921444bcfa0702645c3af93c248fb8bc264c38242b273d03fc30452785b37606a22493ad2 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=ac0db56e596a32169d732da921444bcfa0702645c3af93c248fb8bc264c38242b273d03fc30452785b37606a22493ad2\",\"ssignature\":\"XF+wZUJr4KBfz0pC8p5w44EvmFsFXGK8ffuhvaJqxA/72FeKQg0CGQZF3cVD8Gl+h6+JYDJX+0jsgaKwNXYbmfDLHD3SOx49KqNEPQr9f1tQD0/tVBkUy8ti8dCBoY+O32WztbsQBjA+vdXbigxjt5RzH3Y25eaqxzHlIqcI3AWCkpkYRzfz9++1VsFc/cjW50BopKkdGUc0uizCp/uAcmnHGmm5pZq+pm0fI3/Cz0SnMNsLJ+1l+25lYBVVPem5nZx6C2vnEOVyNKjM8bcMTKi9PnlnyLx/2D+y3kZTIDuvsTQ471Hx83j0nwGPX8j1rNBrDRVzXk8Yb4tydFhyag==\",\"sdocumentreference\":\"FEF2718\",\"rtaxxadocument\":\"87906283\",\"sref\":\"87906283\",\"irefindex\":2718},\"sdebug\":\"Taxxa: 0.122s DIAN: 1.263s (creación 0.685s, revalidación 0.578s)\"}', 47583, NULL),
(1501, '2024-07-10 21:54:29', '{\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-10\",\r\n               \"tduedate\":\"2024-07-17\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2719,\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: 47584\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621309\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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\":\"00621315\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 47584, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1502, '2024-07-10 21:54:29', '{\"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\":\"db9a6cefcee6481221c00e309cdd1c6aaf291c4ee801fc94407e973c3e8c6dc26712a0f8fcb8a0870bc904a3eddf0b6e\",\"sqr\":\"FEF2719 2024-07-10 21:54:32-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 db9a6cefcee6481221c00e309cdd1c6aaf291c4ee801fc94407e973c3e8c6dc26712a0f8fcb8a0870bc904a3eddf0b6e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=db9a6cefcee6481221c00e309cdd1c6aaf291c4ee801fc94407e973c3e8c6dc26712a0f8fcb8a0870bc904a3eddf0b6e\",\"ssignature\":\"4lg3xwWTygoo7XlsS6HKpEOqIcLLZ6Yrw4K4rwHDwBmaGP5+vaTuU2JK9ajop2pwfTUDBwWlYCwKKGj5TFIs45gfhp2PlCfgFmwJ08QivgIu+Or7EFD9eO7DGb/V92shir4luy138Et2QaDg1dk2AbHDUcfmyur//JFCzQFr8n98giBX2PtsaeGD7YjuAxVsZEU93QUjO+ltzJw57GBm9Vk7lueNcV54sTuZzv/cwwqhPZfM6aR/JV9KyG4wkAMhRycjZpB4cTUg1oRKsqVhSwYnLHd13r4UytvC9YSdYy/T0Q3YgZmu6NozRIVTGWjw+J80etCfrRDJJEOCmM0KcQ==\",\"sdocumentreference\":\"FEF2719\",\"rtaxxadocument\":\"87906315\",\"sref\":\"87906315\",\"irefindex\":2719},\"sdebug\":\"Taxxa: 0.139s DIAN: 1.301s (creación 0.708s, revalidación 0.593s)\"}', 47584, NULL),
(1503, '2024-07-10 21:54:34', '{\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-10\",\r\n               \"tduedate\":\"2024-07-17\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2720,\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: 47586\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00621331\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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\":\"00621337\",\r\n                  \"scustomname\":\"EJECUTIVO MIERCOLES\",\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   ', 47586, NULL);
