INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(846, '2024-07-03 22:31:11', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"593ede64d2cbf613bc071cf6a637f0c747dde12e2b707d277fbf8288a37787712359d717f7e6e52d270c275b4d7fc58b\",\"sqr\":\"FEF2391 2024-07-03 22:31:13-05:00 19385248 222222222222 6481.48 0.00 518.52 7000.00 593ede64d2cbf613bc071cf6a637f0c747dde12e2b707d277fbf8288a37787712359d717f7e6e52d270c275b4d7fc58b https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=593ede64d2cbf613bc071cf6a637f0c747dde12e2b707d277fbf8288a37787712359d717f7e6e52d270c275b4d7fc58b\",\"ssignature\":\"cMrmtYCrUtWYjKPuM2WfagOuVHA5iowmtWRVz/D3J46dLm6JTaHx7bW+MZhx3Mr1cjtWx1tE9VBZJlVrdpNjYREg0E9OhbMl/716IJN3EmxJ7fGi9kIlQ+dae1ENitIA9tv24CMPQXw/YBCHor0Gi6ctfwlLLP37b3BhSW6b2cbBQiefkpDqUnuvF6Ey1XGoQ9SAA2NObBdltMfqDr+wbiSYl3k7XjvpwobUBM5DuI3x/oHl6DQIueSV5Srzk3W11Lg6IjsGQbV4IHiuVTUhyOKhTUeAVtlCVlEPPNPY1yqPchIva0D53Us79XyCTIDswHkXByxBZNH4BuMXVKOMZQ==\",\"sdocumentreference\":\"FEF2391\",\"rtaxxadocument\":\"85742967\",\"sref\":\"85742967\",\"irefindex\":2391},\"sdebug\":\"Taxxa: 0.152s DIAN: 0.967s (creación 0.672s, revalidación 0.295s)\"}', 46973, NULL),
(847, '2024-07-03 22:31:19', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2392,\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: 46974\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613593\",\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   ', 46974, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(848, '2024-07-03 22:31: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\":\"b995655c6784790bda25e748e704f97c3dde99c2b9cbce0c3a5588fccf370c45889c6622842cf74d32d2561ee24d99b5\",\"sqr\":\"FEF2392 2024-07-03 22:31:21-05:00 19385248 222222222222 26388.89 0.00 2111.11 28500.00 b995655c6784790bda25e748e704f97c3dde99c2b9cbce0c3a5588fccf370c45889c6622842cf74d32d2561ee24d99b5 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b995655c6784790bda25e748e704f97c3dde99c2b9cbce0c3a5588fccf370c45889c6622842cf74d32d2561ee24d99b5\",\"ssignature\":\"YJIizNVOHJysv9UnaJPVkCA5VI7hmlJlKscUIyQHNSzm732FGBv5OuSB0XzL7aT0SKzMe6izwfa2VXabFqJkoGt7ItfM7QwPGfq3Oss7fda8id5qMY8ENvVqn8wfofGNO1xQmHzDLT0oxt5QZhZbblfBDQQpxKArfbK/WFgjCBkDcNzNNBy0H/a21Z8o2MxNbryNJxjQOJlFQE9PNVhATZJGGuj37/lfiYxwdt9n38u/aYpjaWFVEwNyc841uNFs6ztTWrW3nDiRqqqTzrUC0Ty0fjhP7trzgirepHNY+yjLzwnJFgdwBzur9cIxuFR1LbVrGRGE+ZaPhADXQPJ4Fw==\",\"sdocumentreference\":\"FEF2392\",\"rtaxxadocument\":\"85742984\",\"sref\":\"85742984\",\"irefindex\":2392},\"sdebug\":\"Taxxa: 0.16s DIAN: 0.894s (creación 0.598s, revalidación 0.296s)\"}', 46974, NULL),
(849, '2024-07-03 22:31: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-03\",\r\n               \"tduedate\":\"2024-07-03\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2393,\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\":\" 3105619672\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"CUIDADELA COMFENALCO IV EPATA BLOQUE 8 102\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46977\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"10\",\r\n                         \"namount\": 5000,\r\n                         \"nbaseamount\": 47685.18518518518\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613622\",\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\":\"00613625\",\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   ', 46977, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(850, '2024-07-03 22:31: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\":\"d5b2d8eb641eb32a8cb902885f0273ec3aac48bba23eb4adce57955efa6c4b734c86daf539bb5b1fe7c96273b99feb56\",\"sqr\":\"FEF2393 2024-07-03 22:31:25-05:00 19385248 222222222222 47685.19 0.00 3814.81 56500.00 d5b2d8eb641eb32a8cb902885f0273ec3aac48bba23eb4adce57955efa6c4b734c86daf539bb5b1fe7c96273b99feb56 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d5b2d8eb641eb32a8cb902885f0273ec3aac48bba23eb4adce57955efa6c4b734c86daf539bb5b1fe7c96273b99feb56\",\"ssignature\":\"V1HsKkQDdsvsu8e0Nmo/ITX5y40sr6iapcLp2HrwkTaDXx8LUaS8ifDFdm7VbH3ab9NLfsJC4R2g+MFalxqlO4zUXqq2pCF2MkugHtwOBaGDQn9PKwI5j4+nBmgH6dLVgu1w79zsuvIDh6wkPWhkUWUnyP+CxipNnqTl7NxEPj2rUXMUxKdtG1MVwjYOhXYca+CfPcRKxoP3Hp+PGUh+Uox1r3yZbnEm3cflvV82knaxq6cN2o4T4yzGK2SxbBwrTE6GpegRW1hYeWKpygwHSkC64KSSKdXAXwvqAmrksbTqLz0LbVeKgFTvXMCJAVnmhQu+rCmgwRnhVbovs/tc/g==\",\"sdocumentreference\":\"FEF2393\",\"rtaxxadocument\":\"85742995\",\"sref\":\"85742995\",\"irefindex\":2393},\"sdebug\":\"Taxxa: 0.201s DIAN: 0.885s (creación 0.555s, revalidación 0.33s)\"}', 46977, NULL),
(851, '2024-07-03 22:31: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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2394,\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: 46979\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613644\",\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\":\"00613648\",\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   ', 46979, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(852, '2024-07-03 22:31:34', '{\"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\":\"10db9d388081f3d268e3902d0d63306a00434f5957c2d6c3347b75091017b1ed292872bcf12ae2b506a327ce2f34747c\",\"sqr\":\"FEF2394 2024-07-03 22:31:36-05:00 19385248 222222222222 30092.59 0.00 2407.41 32500.00 10db9d388081f3d268e3902d0d63306a00434f5957c2d6c3347b75091017b1ed292872bcf12ae2b506a327ce2f34747c https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=10db9d388081f3d268e3902d0d63306a00434f5957c2d6c3347b75091017b1ed292872bcf12ae2b506a327ce2f34747c\",\"ssignature\":\"odCZVMsjZup6dgoIGNbWO3WvLVMUMIT88Dc4oRJiFvk0aaRZxsXgqmzYNMVvsASvnu0OYNrNkgki8URHae0AI0eKio7GkkNAb/Vtdt26rxXuFDZ+wUYE0aX5J2uvYxfICxSvaiJ5NVKoJUd9CBVEj0tIOE5KzHDF/Su2FW5QQ0a88S/5IX1aFw6/VCvmUwfvfUTOYne4TmOEcV4+3iNybieK7DcDbBLoF8NcZ/O1/5+kZeBKsG4qXj8Co3phCppCe0Yyi8UxoycAZ1vEyK0TTF95Wv71DdlZ1CxOyjTineroZRFQlrQhweym1035TLwsrNxR/8Qz5mX08cqTYbj1eA==\",\"sdocumentreference\":\"FEF2394\",\"rtaxxadocument\":\"85743029\",\"sref\":\"85743029\",\"irefindex\":2394},\"sdebug\":\"Taxxa: 0.188s DIAN: 0.976s (creación 0.674s, revalidación 0.302s)\"}', 46979, NULL),
(853, '2024-07-03 22:31:38', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2395,\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: 46985\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613710\",\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\":\"00613713\",\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   ', 46985, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(854, '2024-07-03 22:31:38', '{\"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\":\"10e584191cff74b375409e13d24b55eefc2af6dbea7ae9d9f56fd0f6934ef77382689855c3d19cb57c6ef88ae075ef9d\",\"sqr\":\"FEF2395 2024-07-03 22:31:40-05:00 19385248 222222222222 28703.70 0.00 2296.29 30999.99 10e584191cff74b375409e13d24b55eefc2af6dbea7ae9d9f56fd0f6934ef77382689855c3d19cb57c6ef88ae075ef9d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=10e584191cff74b375409e13d24b55eefc2af6dbea7ae9d9f56fd0f6934ef77382689855c3d19cb57c6ef88ae075ef9d\",\"ssignature\":\"H8nIlF9WryOY76jVp5WuliOBwnr16U6ZB7crKoytogmUVMfGjN3XRmxj2elz80PqwQR7oWb6e15hLOCe6/DuIA+Qz/Si3w/Syiw1AXsbmuAzIOOOO5wqbsMhlot1aDH1DhbRtPTJvRoCf7rQg0G/uqpHa0Gb3o8/iDaHe5CidZPv2OEKrOtSoGHYMUpxKgJFWRxr3Tkj3hnv8IIYMvlH4BL7f/yeDc8lDQrK21knnFpONokARx7VQSId1Sw1htT5jyxI/d4JfGqkphspUtcZjse+tHB4SzVDZgAtulFAA7kOLu5UyIRdu1s796IBKKbLeQvWkyF19cxq7QX005AL0A==\",\"sdocumentreference\":\"FEF2395\",\"rtaxxadocument\":\"85743042\",\"sref\":\"85743042\",\"irefindex\":2395},\"sdebug\":\"Taxxa: 0.202s DIAN: 1.042s (creación 0.751s, revalidación 0.291s)\"}', 46985, NULL),
(855, '2024-07-03 22:31:46', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-03\",\r\n               \"tduedate\":\"2024-07-03\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2396,\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\":\" 3127383309\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"URGENCIAS DEL SAN JOSE DE DIOS \",\r\n                        \"szip\":\"630003\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 46986\"\r\n                ,\"aallowancecharge\": {\r\n                     \"1\": {\r\n                         \"schargeindicator\": \"true\",\r\n                         \"sallowancechargereason\": \"Domicilio\",\r\n                         \"sallowancechargereasoncode\": \"05\",\r\n                         \"smultiplierfactornumeric\": \"17\",\r\n                         \"namount\": 4000,\r\n                         \"nbaseamount\": 21296.296296296296\r\n                     }\r\n                 },\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613717\",\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               }},\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   ', 46986, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(856, '2024-07-03 22:31:46', '{\"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\":\"a6aee84b67246bed35e21c2271ead7526e8f585dbcd715d23a569f3a0a32214fdd0407432c80b27f974bdeed6e5e621d\",\"sqr\":\"FEF2396 2024-07-03 22:31:48-05:00 19385248 222222222222 21296.30 0.00 1703.70 27000.00 a6aee84b67246bed35e21c2271ead7526e8f585dbcd715d23a569f3a0a32214fdd0407432c80b27f974bdeed6e5e621d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=a6aee84b67246bed35e21c2271ead7526e8f585dbcd715d23a569f3a0a32214fdd0407432c80b27f974bdeed6e5e621d\",\"ssignature\":\"HTCIb1QREuC5z9GIMiguqKClkzkVAwPAne0EniPz0WQQ4Sh+m+AxT3/ujFpi7OtzdMla/BsZngzlCuqCyJyzjIkJomd3wXMtuWVcNjqVsI8vtOu1Qg9reUwSkz68dzM9DyWHsR+eAsfhr6fkWP4d5mkN64pzfweM4rmUo656pXaS53Oj8SQ+YKuxPFLC73W9F89BqrrteIZDtZifRF07Y+g1UX9Adlf27FcNRbVxd0fV5eutA4tmm82SdZOGnqzPla2DdqbXY4Cg3GyLA7ypipgGMXyoZP4c4CeQ5wJl83erNNRP4xqLmm/RB0g9VH2+/HdkBT8+udC5yva6tmIBRw==\",\"sdocumentreference\":\"FEF2396\",\"rtaxxadocument\":\"85743057\",\"sref\":\"85743057\",\"irefindex\":2396},\"sdebug\":\"Taxxa: 0.182s DIAN: 1.04s (creación 0.717s, revalidación 0.323s)\"}', 46986, NULL),
(857, '2024-07-03 22:31:51', '{\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-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2397,\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: 46987\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613720\",\r\n                  \"scustomname\":\"HAMBURGUESA DE PROMOCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":17592.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   ', 46987, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(858, '2024-07-03 22:31:51', '{\"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\":\"c4859873552eaac6285c9462a2445376db8d2d2f1315725a147cb7129a4bf9f7fdd423f4f6a75c2274f4eab61e8212ba\",\"sqr\":\"FEF2397 2024-07-03 22:31:53-05:00 19385248 222222222222 17592.59 0.00 1407.41 19000.00 c4859873552eaac6285c9462a2445376db8d2d2f1315725a147cb7129a4bf9f7fdd423f4f6a75c2274f4eab61e8212ba https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=c4859873552eaac6285c9462a2445376db8d2d2f1315725a147cb7129a4bf9f7fdd423f4f6a75c2274f4eab61e8212ba\",\"ssignature\":\"GKoWLrIyERyVN+LvTY0S7gShctwtxliJ6iK1wM43CyjoP+0ESt/GG4PqW9ManclTLz/eCNMlKd9hu8vaqaACZnTMb1d7i8+R0auR8VK5/NvITIrUCT44Yfwv9AFdo1PRuHBfo05jwHu5IwqAf+KCr83HVyYyx7056JosdY0vgAzvDbdXSg3VVpsV9XAZTe3ZwBWGJuLpIivp2PgyfV38d3cPVBb5BH3KqviUJXOgRKbrugEWFkqz3sEVd2p1XfhX+hSS+YICOMz2KNYsCSpjfbXe0Kgd2meozT6lPS314Pf5lrNP5f1PxiZaaFFqQA7YHd7dGeYodEHEcNHJP43NDA==\",\"sdocumentreference\":\"FEF2397\",\"rtaxxadocument\":\"85743069\",\"sref\":\"85743069\",\"irefindex\":2397},\"sdebug\":\"Taxxa: 0.299s DIAN: 1.261s (creación 0.64s, revalidación 0.621s)\"}', 46987, NULL),
(859, '2024-07-03 22:32:00', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2398,\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: 46988\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613721\",\r\n                  \"scustomname\":\"HAMBURGUESA DE PROMOCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":17592.592592593,\r\n                  \"icount\":3,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00613722\",\r\n                  \"scustomname\":\"HAMBURGUESA DE PROMOCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":17592.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   ', 46988, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(860, '2024-07-03 22:32:00', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"37f40cd5107fe1ce09d4f07c56fb5cb85549e06220e6e0b4e5904c93b46692b45d95b5a028d3a3573e921ac636468000\",\"sqr\":\"FEF2398 2024-07-03 22:32:01-05:00 19385248 222222222222 70370.37 0.00 5629.63 76000.00 37f40cd5107fe1ce09d4f07c56fb5cb85549e06220e6e0b4e5904c93b46692b45d95b5a028d3a3573e921ac636468000 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=37f40cd5107fe1ce09d4f07c56fb5cb85549e06220e6e0b4e5904c93b46692b45d95b5a028d3a3573e921ac636468000\",\"ssignature\":\"0RCAO0w8n6jToBwWv3zTfnREpNNwZcDf2Uq8e4NehsHfn8MyNBXfw0wHvKBDyKOPLhPtE5FTg+BgeQNgZ9PW6hQrPMQYkl3dI6K/jWp6kqYoWdU2eosBAdysYBqMSI3sWzF+6rWlcbzrc/R3ZzQQoB53tEfbr75iTWXZzns9kpOjGkP4sS75Qm5KC3WP33RYdM0UhWM/l+YFkAfre0Q6O2MTx0xvWqzN/j15zGfGQ5fDcDebTLPjjIZDEmPIf5969IxyR203ICwI0Uy8SE+IF5+MU5Ap/bodnn3iwCGoes8tZN5h3j8zdoVnM6Sivcx2Pz6GU2CpDwUDNBcltP7Itw==\",\"sdocumentreference\":\"FEF2398\",\"rtaxxadocument\":\"85743088\",\"sref\":\"85743088\",\"irefindex\":2398},\"sdebug\":\"Taxxa: 0.221s DIAN: 1.077s (creación 0.792s, revalidación 0.285s)\"}', 46988, NULL),
(861, '2024-07-03 22:32:04', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-03\",\r\n               \"tduedate\":\"2024-07-10\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2399,\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: 46991\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613734\",\r\n                  \"scustomname\":\"CARNE TRIMIXTA 460gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":30092.592592593,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00613739\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6018.5185185185,\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   ', 46991, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(862, '2024-07-03 22:32:04', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"d3c2f1cec93a5be6024e22544ab37efc88ce66a843704c607dea872393b832bd85f16a8983df468280ad5ba5f202d103\",\"sqr\":\"FEF2399 2024-07-03 22:32:06-05:00 19385248 222222222222 42129.63 0.00 3370.37 45500.00 d3c2f1cec93a5be6024e22544ab37efc88ce66a843704c607dea872393b832bd85f16a8983df468280ad5ba5f202d103 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=d3c2f1cec93a5be6024e22544ab37efc88ce66a843704c607dea872393b832bd85f16a8983df468280ad5ba5f202d103\",\"ssignature\":\"vsXJ6OvAL9OivZZMYzGShPAARjbTRW7D146/vVIKwrlLdOfa19QOkK+SohH+cumPfXMaU+nMQpQ7XlRh9YR1LuMRG+W+V8Ep7jatY3PBTgX/8ESX3ejr2o1/6gq5/eULoGjVaBQiQXE7hRx0GAKNzi8EX/IJKru/5Ek4eYG6J1+b7JLMgz4r5X5C2DybqhAgUTx9W5L7IuKvy+kZq5JjQtpn82wjL35B3H/ArVC5pnh7oKUZkjNOzY6aFSZe/dFlfsvfNwG0u7e/JkpbvZ2guZuTsrp1Qfng6Ah8lAGWf+X0pv8qW30+zfv8nX8z/1XLiZQqkwJ8uq3xUYSeMp9pHQ==\",\"sdocumentreference\":\"FEF2399\",\"rtaxxadocument\":\"85743101\",\"sref\":\"85743101\",\"irefindex\":2399},\"sdebug\":\"Taxxa: 0.161s DIAN: 1.059s (creación 0.629s, revalidación 0.43s)\"}', 46991, NULL),
(863, '2024-07-04 12:47: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\": 2400,\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: 47001\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613816\",\r\n                  \"scustomname\":\"ALMUERZO JUEVES\",\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   ', 47001, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(864, '2024-07-04 12:47: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\":\"aa7ebbc44cf922d42652f13157196df23c11072214928ec8e146309db95fb16d54c68ad36aa7c3b4bf46ea6321d4c880\",\"sqr\":\"FEF2400 2024-07-04 12:47:58-05:00 19385248 222222222222 16203.70 0.00 1296.30 17500.00 aa7ebbc44cf922d42652f13157196df23c11072214928ec8e146309db95fb16d54c68ad36aa7c3b4bf46ea6321d4c880 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=aa7ebbc44cf922d42652f13157196df23c11072214928ec8e146309db95fb16d54c68ad36aa7c3b4bf46ea6321d4c880\",\"ssignature\":\"4Ph90ryHnn50UYUdNBZUWdEGENUjpotqdzm/ziR7GwuOB6e0lwrz53mjFdPDzdT3Dji+UGwVKgj6rg0QCKyJ2Q0XrJGWvBOUqYfAMvS64UnOXQXsoMEmbPW9o7GKfQgNTARUbDV1pOMWTM2xP0qwjp2gLWukeY8IOjnYURP/5/Myp2AyW7tLPoRjWhzZ1VoGFAQHGmppVUF99mhg/T6wSHiPu1YcZ14qa3lapKk4HOk3HKC3sHlWBE07bSTXWdZ+iKRNQVOihEvcPG1HmATVceIEqFowqZ2ZvTvR6wbdWJlIJG7aisalStF4NR2HfSzcBg+1Gr1NY/VZFQW46+ROpA==\",\"sdocumentreference\":\"FEF2400\",\"rtaxxadocument\":\"85851460\",\"sref\":\"85851460\",\"irefindex\":2400},\"sdebug\":\"Taxxa: 0.203s DIAN: 1.329s (creación 0.641s, revalidación 0.688s)\"}', 47001, NULL),
(865, '2024-07-04 12:59: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-04\",\r\n               \"tduedate\":\"2024-07-11\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2401,\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\":\"DU BRANDS SAS\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"900275221\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"DU BRANDS SAS\",\r\n                     \"selectronicmail\":\"facturaciondubrands@dubrands.com\",\r\n                     \"stelephone\":\"3195499337\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"11\",\r\n                        \"wtowncode\":\"11001\",\r\n                        \"scityname\":\"BOGOTA D.C\",\r\n                        \"saddressline1\":\"CR 13  79  10\",\r\n                        \"szip\":\"110011\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47013\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00613948\",\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\":\"00613949\",\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               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00613950\",\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               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00613951\",\r\n                  \"scustomname\":\"1/2 JARRA DE LIMONADA\",\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   ', 47013, NULL);
