INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(924, '2024-07-04 22:04:24', '{\"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\":\"a2287f2db0e259badbd55a56fc16dd1397845efefb4ac61b66d2e61ee0e304b132a9e4eca17a7ad78676d3baf16c0124\",\"sqr\":\"FEF2430 2024-07-04 22:04:25-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 a2287f2db0e259badbd55a56fc16dd1397845efefb4ac61b66d2e61ee0e304b132a9e4eca17a7ad78676d3baf16c0124 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=a2287f2db0e259badbd55a56fc16dd1397845efefb4ac61b66d2e61ee0e304b132a9e4eca17a7ad78676d3baf16c0124\",\"ssignature\":\"7eVVEtCwA3qMR3gjLrv/n8S4ecF5ymqjmKIF4/EWf6ftsyvi9mI+XWbDjJNq4aXltZ8wE5j1TNsLlRyo12/um0Oyndjd/V8KwGALna6By2O+nFrmQfQCz+hkzV6CFhNnGbuGMcL3HO+nQUtfk6BzRvqBMx+xsDaHrPJgwOXe7I+Og+84bxe9Yk3iwD2t2baQZDyykHXdvN9mMGWOptnIJ+Bzqvag1RNr7cxZLYFnlUk82FrCMiF7UC+ymw4M87i1CRpJLIULOu4oxPdQdVxbF6wcaducpCCWHSEGb9AxqQciDymTTc2gMn7ua/XGzUwtzxLmiVU71HEcuw1BIL4A1A==\",\"sdocumentreference\":\"FEF2430\",\"rtaxxadocument\":\"86051912\",\"sref\":\"86051912\",\"irefindex\":2430},\"sdebug\":\"Taxxa: 0.249s DIAN: 1.261s (creación 1s, revalidación 0.261s)\"}', 47044, NULL),
(925, '2024-07-04 22:04:28', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-04\",\r\n               \"tduedate\":\"2024-07-04\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2431,\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\":\" 3146230195\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"  B/ PATIO BONITO ALTO MZ L CASA 59B \",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47045\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"12\",\r\n                         \"namount\": 3000,\r\n                         \"nbaseamount\": 24074.074074074073\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614329\",\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               }},\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   ', 47045, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(926, '2024-07-04 22:04:28', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"fc0038e03b65b305db81ab778c3944ad463cfcde95b8ef3e6753f4ad66ccca61af4d7621ae82c5cdf6d292878e6ca22b\",\"sqr\":\"FEF2431 2024-07-04 22:04:30-05:00 19385248 222222222222 24074.07 0.00 1925.93 29000.00 fc0038e03b65b305db81ab778c3944ad463cfcde95b8ef3e6753f4ad66ccca61af4d7621ae82c5cdf6d292878e6ca22b https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=fc0038e03b65b305db81ab778c3944ad463cfcde95b8ef3e6753f4ad66ccca61af4d7621ae82c5cdf6d292878e6ca22b\",\"ssignature\":\"kTG+LKWgRrDIPXx+9h1o5a0XoCOBXILokBycUT4BqbRnrLFP29m0vIuJsaOOkFI2tKo3+KuOPosVXyJuHOuj1qqCtjeLYL6gO3CcYJPuOIIKJGg1ohW0gSOEA54Ia1Lau7XquXqSehcGOTIlNfA9lhkGrCaV4yoypfX+cUm/y60/v/GTgJz/o7/wgYmeKf5eFAYEwErXSmdw5dZzOGjTqt5edlRk0egO8FeeqKJAZrypZ5/T81tO5gIcW4bmoRiD5tOYJ0NrulpblP66gmgwiGJLoih3csuZlMKNaP5d48jsqSkrEbeEmlyWZ/hd4Z6WgPPTi/ICDUMS11iKvmGSvQ==\",\"sdocumentreference\":\"FEF2431\",\"rtaxxadocument\":\"86051931\",\"sref\":\"86051931\",\"irefindex\":2431},\"sdebug\":\"Taxxa: 0.251s DIAN: 1.307s (creación 0.676s, revalidación 0.631s)\"}', 47045, NULL),
(927, '2024-07-04 22:04:36', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-04\",\r\n               \"tduedate\":\"2024-07-11\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2432,\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: 47051\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614407\",\r\n                  \"scustomname\":\"BURGER PECHO RES DESMECHADO\",\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\":\"00614409\",\r\n                  \"scustomname\":\"LIMONADA DE COCO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7407.4074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47051, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(928, '2024-07-04 22:04:36', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"a889e47758a8000dd4721b6baa97e69528f074a4330c527e30ca46e82345476566a95a6bded0f8004a964ea6d84f53c7\",\"sqr\":\"FEF2432 2024-07-04 22:04:38-05:00 19385248 222222222222 28703.70 0.00 2296.29 30999.99 a889e47758a8000dd4721b6baa97e69528f074a4330c527e30ca46e82345476566a95a6bded0f8004a964ea6d84f53c7 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=a889e47758a8000dd4721b6baa97e69528f074a4330c527e30ca46e82345476566a95a6bded0f8004a964ea6d84f53c7\",\"ssignature\":\"f6bQKv2uiCFJe9EO7z3z2J4e1qUsVVQy3kL7el63IrzlkIozDjm/5N0bO2bHpF3xr7mAB3nsBlJqgbTbcFdnCJXcRO8TUCvdh7BgXIvMXrAav/KFEbV6uj86A8esDx9dacxGftiYkzog6AWo7mL4rflu6vdxmX7w2pqImVAjuOhI6TxjtLTvq5SQqTvkyCwJK2jzzJoM+R6II0R4tS1fr+aUjUmlkHa9snubeoEGTKDiFWKyysHifZgQZ2MJZY/93eXUc4uY+Fq6TbDV6eHjyOKZzHDdo3Fdj9Yskb+GrGG2cxq2yLKQR2xBD1oWCUEFz+FjYvAH0b5ZT3mNFWJxlQ==\",\"sdocumentreference\":\"FEF2432\",\"rtaxxadocument\":\"86051965\",\"sref\":\"86051965\",\"irefindex\":2432},\"sdebug\":\"Taxxa: 0.209s DIAN: 1.793s (creación 1.078s, revalidación 0.715s)\"}', 47051, NULL),
(929, '2024-07-04 22:04: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-04\",\r\n               \"tduedate\":\"2024-07-11\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2433,\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: 47052\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614410\",\r\n                  \"scustomname\":\"BURGER ESPECIAL PECHO RES\",\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\":\"00614412\",\r\n                  \"scustomname\":\"MILO PEQUEÑO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":4629.6296296296,\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\":\"00614413\",\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   ', 47052, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(930, '2024-07-04 22:04: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\":\"75f181419ebdc4f015fb3a2b6b3f88443f60acdff85cbbaca44722e575bac06f4b52884c861c7cf4d2fbd3bb4204f75b\",\"sqr\":\"FEF2433 2024-07-04 22:04:57-05:00 19385248 222222222222 34722.22 0.00 2777.78 37500.00 75f181419ebdc4f015fb3a2b6b3f88443f60acdff85cbbaca44722e575bac06f4b52884c861c7cf4d2fbd3bb4204f75b https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=75f181419ebdc4f015fb3a2b6b3f88443f60acdff85cbbaca44722e575bac06f4b52884c861c7cf4d2fbd3bb4204f75b\",\"ssignature\":\"4H3TZltKavznzJ5sqFvYi535qmJn+QX8+NODx0L8MKMVcxGNRyNj8qVKjj77TezF9hNtx3Xzw8WRm7zFnDRNWOootKr+EWpgn4NIT/qyuFbohcZ7ePEsa3M3t/4fxZ4TbFDMZHucS3WAThqM18SK2XfEDYmHn1vb9nhCpJA3SHcSWrfZyOU7qUv0S3Ei0STx99Rx5YBwMGqQip+/8rHpHbv1fiEX4QPHpG5A0jpXmoXr0gwezj5zqQsmTEOauAllNv6UnFArpdAOTt6MLOE82Zgs/yeLZpEM99kyR9S04bNcXnXk5ROqvuIkU2IdYDmcTHRulbI1o3Rw091CIk3OIg==\",\"sdocumentreference\":\"FEF2433\",\"rtaxxadocument\":\"86052067\",\"sref\":\"86052067\",\"irefindex\":2433},\"sdebug\":\"Taxxa: 0.17s DIAN: 1.269s (creación 1.016s, revalidación 0.253s)\"}', 47052, NULL),
(931, '2024-07-04 22:05:03', '{\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-04\",\r\n               \"tduedate\":\"2024-07-04\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2434,\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\":\" 3108539195\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"LA GRECIA CASA 66 \",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47054\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"27\",\r\n                         \"namount\": 7000,\r\n                         \"nbaseamount\": 24074.074074074073\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614432\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47054, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(932, '2024-07-04 22:05:03', '{\"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\":\"2925065995eca72eeec49d66f219685fafe462dd4aaa931e876f6b994ec10c0acbe2b99db0b230530ae26b87f0d6794f\",\"sqr\":\"FEF2434 2024-07-04 22:05:05-05:00 19385248 222222222222 24074.07 0.00 1925.93 33000.00 2925065995eca72eeec49d66f219685fafe462dd4aaa931e876f6b994ec10c0acbe2b99db0b230530ae26b87f0d6794f https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=2925065995eca72eeec49d66f219685fafe462dd4aaa931e876f6b994ec10c0acbe2b99db0b230530ae26b87f0d6794f\",\"ssignature\":\"S+QdS+x7MVVRrvVoTfnsz2So0sUERTu8AysFwtXheX4Tp0MIE5IQgGb6lR7hLmhaaBokXhyKxGRHdt38mZgez27xa7yfxyWOyRVsiZsgQ9A9TlM9olvOzBRLG24MhJzfKKZ6YN7ZciBmkKPTYqv4gB8PSkwQnkD8DSr8mSi6ThHhF7/HnXO5Ln+62pL8EwVsqPQOu8hM8IlzULGIKtkPBPCNjkgaVsR4tYVZaruSijmU/Xpifh/+anFQfqUUAG5s+2FYB2mMTs6RO2Kqg1dflHdJ3BuXbAYo8K3oKCYMqzOd+pe4ECeSexP6Hz3D+o/YDS6yGTS92HC8E1OEStM6Rw==\",\"sdocumentreference\":\"FEF2434\",\"rtaxxadocument\":\"86052106\",\"sref\":\"86052106\",\"irefindex\":2434},\"sdebug\":\"Taxxa: 0.22s DIAN: 1.02s (creación 0.729s, revalidación 0.29s)\"}', 47054, NULL),
(933, '2024-07-04 22:05:08', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-04\",\r\n               \"tduedate\":\"2024-07-04\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2435,\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\":\" 3144903341\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"MZ 7 CASA 12\",\r\n                        \"szip\":\"630003\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47055\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"18\",\r\n                         \"namount\": 5000,\r\n                         \"nbaseamount\": 26388.888888888887\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614439\",\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               }},\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   ', 47055, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(934, '2024-07-04 22:05:08', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"173f77bc125e337234e66bebdfdf0e10277c3ae89cbbd90dfdba8d9abe65926d21d5bb772750af163d40f5330b0990d8\",\"sqr\":\"FEF2435 2024-07-04 22:05:10-05:00 19385248 222222222222 26388.89 0.00 2111.11 33500.00 173f77bc125e337234e66bebdfdf0e10277c3ae89cbbd90dfdba8d9abe65926d21d5bb772750af163d40f5330b0990d8 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=173f77bc125e337234e66bebdfdf0e10277c3ae89cbbd90dfdba8d9abe65926d21d5bb772750af163d40f5330b0990d8\",\"ssignature\":\"6Rj0vHcHeXsUuWxfD3O0x9SW4/Irkaf9UTF4INFrvdSqJ8CDgEbR+Dw1SkiyozBxkcHCGeumiqpGiU/Hr3DtuhejRKspsGPY8lJC3u7xAJWeoWWLxIiGEFDygNLHG1lFBVtAQDTIPvD7q+hGDrQ5Mv+IyQDUXU6eFeks1q3ZzGO3BzGmXaWJ7tr6/7ljeVwnvzmsUg+UTc/zbb8zYxID0R0gvnCOBtvW2If4qhDethNpukxHWh/0a0cTVtT9kr7L24A/6Vw6ScMzE6FlosgKMdDwusS+GwrtYF/D5bPmqVdDMkLPGOnP+ZDt+pORy1Svk9e84VeoDxYk9kYZvqfQMg==\",\"sdocumentreference\":\"FEF2435\",\"rtaxxadocument\":\"86052130\",\"sref\":\"86052130\",\"irefindex\":2435},\"sdebug\":\"Taxxa: 0.2s DIAN: 0.975s (creación 0.631s, revalidación 0.344s)\"}', 47055, NULL),
(935, '2024-07-04 22:05:15', '{\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-04\",\r\n               \"tduedate\":\"2024-07-04\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2436,\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\":\" 3144903341\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"MZ 7 CASA 12\",\r\n                        \"szip\":\"630003\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47057\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614453\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":24074.074074074,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47057, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(936, '2024-07-04 22:05:15', '{\"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\":\"d389a26cb46ec09c472109fd58a5092e7228bdcf28f4193c5194ea98c90582ebd0ddb3eb7b66d1028a52c57e53aa8515\",\"sqr\":\"FEF2436 2024-07-04 22:05:17-05:00 19385248 222222222222 24074.07 0.00 1925.93 26000.00 d389a26cb46ec09c472109fd58a5092e7228bdcf28f4193c5194ea98c90582ebd0ddb3eb7b66d1028a52c57e53aa8515 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d389a26cb46ec09c472109fd58a5092e7228bdcf28f4193c5194ea98c90582ebd0ddb3eb7b66d1028a52c57e53aa8515\",\"ssignature\":\"M51YtSd2b+T6SSz0XWNeEjMZYF5QgDxpMQClta8JdGXf11kupBfM0hpoyqFOmxl5vzatoBpGzVNHLahllV0HNaGQutuvke0BEgDFUz5K2I3YiI6REFDLokgHlM5g9MeJfeSssl01AjFybXePMUY0S/2K2eNplftEVcuJBi572tLDIpoYY50lTJ5PiXIuVB/B5Y8bZZkRtxPY+2ve7kHmjWuhrAVadPgLf0lgIoDAj4sBzjCf2yXx58+Y2btnJHQXv4r7AsR0ckDNT2H7PMZcpXP4z9LbyFgEpkuwImy5h6fFI4WyIsDcGdZoRcbqMfcrEBUZmKU4CMbpOPLIlezC7g==\",\"sdocumentreference\":\"FEF2436\",\"rtaxxadocument\":\"86052179\",\"sref\":\"86052179\",\"irefindex\":2436},\"sdebug\":\"Taxxa: 0.283s DIAN: 1.307s (creación 0.89s, revalidación 0.417s)\"}', 47057, NULL),
(937, '2024-07-04 22:05: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-04\",\r\n               \"tduedate\":\"2024-07-04\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2437,\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\":\" 3243444414\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CRA 14 11NORTE 51 RINCON DEL PORTAL \",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47058\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"12\",\r\n                         \"namount\": 4000,\r\n                         \"nbaseamount\": 31481.48148148148\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614460\",\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\":\"00614464\",\r\n                  \"scustomname\":\"COCACOLA 1.5ml\",\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   ', 47058, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(938, '2024-07-04 22:05:20', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"5544ea68c4e11a09d0785f48b1054cc33f4f8ac3648409b330bf57ca77d7e4d0daed87aff5fc84b538aeb83e31a8fda6\",\"sqr\":\"FEF2437 2024-07-04 22:05:22-05:00 19385248 222222222222 31481.48 0.00 2518.52 38000.00 5544ea68c4e11a09d0785f48b1054cc33f4f8ac3648409b330bf57ca77d7e4d0daed87aff5fc84b538aeb83e31a8fda6 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=5544ea68c4e11a09d0785f48b1054cc33f4f8ac3648409b330bf57ca77d7e4d0daed87aff5fc84b538aeb83e31a8fda6\",\"ssignature\":\"7EoKO+0SsiOAMWEX/UiEGqy6/ed2jBA+E8ub+VzlolZqfc00PunzVowiojOmX3zdHMgbk3RQcUYPAjasbhiM10UYG+9GzrQa5K2VaniooeapAVykZKmllpAEt1I+4JFG+W/M5Bru/Dd+8gHu6+pIIBdCTBt5dGBchpNFi2Sbyj1FJbPT8edQNt9Wt66BfiJklvH6zV7ltm+bHRK1R+mpD48+06zYP2j/lc516uzQz/eV958MxVXd/8f8u7qCbtnGolDoL6O/kLpLjj1Io32w9TMgOYtet+SM0oe6rkZC9DPUXnyp2JmYqcifWGcIvmEoBDCYfJVko9on1wnkVrGQbw==\",\"sdocumentreference\":\"FEF2437\",\"rtaxxadocument\":\"86052206\",\"sref\":\"86052206\",\"irefindex\":2437},\"sdebug\":\"Taxxa: 0.415s DIAN: 1.056s (creación 0.658s, revalidación 0.397s)\"}', 47058, NULL),
(939, '2024-07-05 12:46:36', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-05\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2438,\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\":\"FERTIFUTURO   SAS\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"901594370\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"FERTIFUTURO    \",\r\n                     \"selectronicmail\":\"901594370@factureinbox.co\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CRA 19 CALLE 45 44 52 \",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47082\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614804\",\r\n                  \"scustomname\":\"EJECUTIVO VIERNES\",\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   ', 47082, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(940, '2024-07-05 12:46:36', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"692c2999109914b233cd79a54427a9cc295a3e253559885addc4c807a1616b86d9f9ee054b4d47b36edb7f4a3cb89ef6\",\"sqr\":\"FEF2438 2024-07-05 12:46:38-05:00 19385248 901594370 16203.70 0.00 1296.30 17500.00 692c2999109914b233cd79a54427a9cc295a3e253559885addc4c807a1616b86d9f9ee054b4d47b36edb7f4a3cb89ef6 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=692c2999109914b233cd79a54427a9cc295a3e253559885addc4c807a1616b86d9f9ee054b4d47b36edb7f4a3cb89ef6\",\"ssignature\":\"y48axre/qT6NgaiaFoBAeT8VmmXlGGD3lwjlTvZawVhBdugxMOfBmV4HntUJPaGYzlxOE7Bmh1MGUWiKfsjgLCnnBwc5fWqX3ShFNhwPAvUO2NkOVq/yReX6MhBaTJ8b+tcjbWM/WSCDC6ueznW1SgJnCprss2VWOzTh8VJ+aI+rRwBdDc9Ypsb4HyLpk0pAYmd3qdnqC43SJ0YvwUj7lhuO0dTiz2gPxk2dZf196JPmXoQth0v9GhSnsJfg09NtqRO02Vs27rkWy1vC9PUXcchNcVsjMlmJF4br1+aP8C5qNvbfZ13Cjnt+xHsIa1G2lk6ht8IFlgraRUwIQ0uEYQ==\",\"sdocumentreference\":\"FEF2438\",\"rtaxxadocument\":\"86227994\",\"sref\":\"86227994\",\"irefindex\":2438},\"sdebug\":\"Taxxa: 0.225s DIAN: 1.922s (creación 1.188s, revalidación 0.734s)\"}', 47082, NULL),
(941, '2024-07-05 12:47:15', '{\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-05\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2439,\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: 47079\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614751\",\r\n                  \"scustomname\":\"FRIJOLADA\",\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               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00614753\",\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               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00614758\",\r\n                  \"scustomname\":\"EJECUTIVO VIERNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":3,\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   ', 47079, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(942, '2024-07-05 12:47:15', '{\"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\":\"0c3164dc2b47781f30636950880b7cb1029237a8275e9fdf9582ad8b1c146bce6f42e3a96bbe626849ccca5538c42d77\",\"sqr\":\"FEF2439 2024-07-05 12:47:16-05:00 19385248 222222222222 84722.22 0.00 6777.78 91500.00 0c3164dc2b47781f30636950880b7cb1029237a8275e9fdf9582ad8b1c146bce6f42e3a96bbe626849ccca5538c42d77 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=0c3164dc2b47781f30636950880b7cb1029237a8275e9fdf9582ad8b1c146bce6f42e3a96bbe626849ccca5538c42d77\",\"ssignature\":\"V5kCfO1hvg7OO8okQSJGC5faW8cYqF1ayigEaN1OuKfBa7Zf8A+8myO8L+O5oPX/IAPiozJ0gPhldOevsAoeSoUy+illqwaNBqhdMsrSjsfeqQl1GuSqyfU1FrsXStcr3Fh9mWP/J4aTHqpafBg/2bsFIsUtzWhp+k0OSCcwNKNoHQkAHH3F1+7v9sySfa4r9eXGyFsCaqN0oyb/+ZhSChzqP9nyOkjuCNS29JVsRrrh9AApYkRsSDiMK8hLAgBVVUWvJQrPVzp7N2+qcT6zvmixVlNJQzn9HjHtQfEijQo4wVqbRDnuhpAn/4TMxHAcoPPIUi9n3ZGk78vF9QA06w==\",\"sdocumentreference\":\"FEF2439\",\"rtaxxadocument\":\"86228210\",\"sref\":\"86228210\",\"irefindex\":2439},\"sdebug\":\"Taxxa: 0.328s DIAN: 1.082s (creación 0.691s, revalidación 0.391s)\"}', 47079, NULL),
(943, '2024-07-05 12:47: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-05\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2440,\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: 47076\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00614706\",\r\n                  \"scustomname\":\"EJECUTIVO VIERNES\",\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   ', 47076, NULL);
