INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1364, '2024-07-08 22:09:18', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"81e2fca7d5e504b2043747d9ec9d7df3c134021f16bc40e758a328db4dd554f48c8da0aadf87cdd84b49a94208f4328e\",\"sqr\":\"FEF2650 2024-07-08 22:09:21-05:00 19385248 222222222222 40462.96 0.00 3237.04 47700.00 81e2fca7d5e504b2043747d9ec9d7df3c134021f16bc40e758a328db4dd554f48c8da0aadf87cdd84b49a94208f4328e https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=81e2fca7d5e504b2043747d9ec9d7df3c134021f16bc40e758a328db4dd554f48c8da0aadf87cdd84b49a94208f4328e\",\"ssignature\":\"TpivptPhB7i7KQAC4zBWo4rBwOwICesi2+D3cocCD3COGLhiAo8eZhz4vzIC5I++RvRBi9429aeVBI4aamtJYi/doopaYouTbVlhfxycl6hMySOnD2tO+ln9eq3/3FFx1zgsg+UCeWyULDXhpxpZKPxD+Z+yS10pzkRgUkhMmojyEJNlrLRAzy+8XWG0Z1GmaOrxfUOquyKmOGQ387RJP1KxZENHsjAarCzm0OOnjE+riJ9LboaWvSwrAUIKP4kTG8kPuQOPrcgR8uMIHG17OR6L+4uf3vOPLS3ITb9XGHO219YNEtuNNohXIAeK7DNpY124f3V3HpGn3nkIMqa3qg==\",\"sdocumentreference\":\"FEF2650\",\"rtaxxadocument\":\"87261071\",\"sref\":\"87261071\",\"irefindex\":2650},\"sdebug\":\"Taxxa: 0.703s DIAN: 2.099s (creación 1.349s, revalidación 0.75s)\"}', 47451, NULL),
(1365, '2024-07-08 22:09:25', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2651,\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: 47452\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619695\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00619701\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47452, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1366, '2024-07-08 22:09:25', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\",\"3\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"8e01cffe50276529306991339adb16a2ff7b7ca43459f599ebe7b055dd9a64f1ef70b8d4362b5e871642d1421d0bd5c6\",\"sqr\":\"FEF2651 2024-07-08 22:09:30-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 8e01cffe50276529306991339adb16a2ff7b7ca43459f599ebe7b055dd9a64f1ef70b8d4362b5e871642d1421d0bd5c6 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=8e01cffe50276529306991339adb16a2ff7b7ca43459f599ebe7b055dd9a64f1ef70b8d4362b5e871642d1421d0bd5c6\",\"ssignature\":\"iUPI1I0XH3GaFia0Q7EqJZjeLiMPwjV/t0pySFJrmw3S7smcJqL6eNUHohAlQziGgRJp5/X37T4vPWbW2Jye+AKrKHJPBke/4CiIK9GJ2opKirt/xXBeFKGN04G+CKEn8qfEg3vZMqpz6fwCBbCjNS5Vz43fXAH0a1nDt0gbFZg7nN5c+peKgvmfhMr5zY+5cebyDanqqn7SwB72r1M8ekVPciATP8wILmqjbr1nSZ0w0rB8V/sAveUD2ExikX7sfCWLuc2v0+c11K68IZljJc/wf+g8E8kSX1Wc+l6auqKck1WNYOy5y22MNyqHuAITjDxT16zHXn1jBaJQLYkh9Q==\",\"sdocumentreference\":\"FEF2651\",\"rtaxxadocument\":\"87261094\",\"sref\":\"87261094\",\"irefindex\":2651},\"sdebug\":\"Taxxa: 1.854s DIAN: 3.881s (creación 2.693s, revalidación 1.188s)\"}', 47452, NULL),
(1367, '2024-07-08 22:09: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-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2652,\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: 47454\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619725\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00619731\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47454, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1368, '2024-07-08 22:09: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\":\"c854edacb2aa3dc4b33d954cc3345f103a5b64eb7078b6a17998081a5d6924f0ded9555308219be9fcf77b5963455186\",\"sqr\":\"FEF2652 2024-07-08 22:09:40-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 c854edacb2aa3dc4b33d954cc3345f103a5b64eb7078b6a17998081a5d6924f0ded9555308219be9fcf77b5963455186 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=c854edacb2aa3dc4b33d954cc3345f103a5b64eb7078b6a17998081a5d6924f0ded9555308219be9fcf77b5963455186\",\"ssignature\":\"EcCD5cZNWuuC89nZRqrazDf9hiqHa0nOvAfh+eBFyzbjDrveUNisN6bVVtV4hxHDhIp5PZ62AWoEs5mqp2axDvBIJ/ZFvfC+u7YnwW7Acw5hTEEzK8RDjzndsoRZXCL0BbHe1L0sQF6qz6Dk/vcXY8B78YsXu/DYHgf5H1O+nRjpuHt7acO1d3J741gGxQ9HRvM4F7lhAqG4zFfgWlu25ncVl8KOmsIGSXNp+DKSL3rf+YTXpnfDQ89v9OLq+Gvi8d16CgjYrnSHvkw6q/76FX9D7ckr4rMyVTMWFG09HcFyULQhWNjfph/x41+hdmZ2D2bxAevCGt9sV0Dh9UfoVg==\",\"sdocumentreference\":\"FEF2652\",\"rtaxxadocument\":\"87261122\",\"sref\":\"87261122\",\"irefindex\":2652},\"sdebug\":\"Taxxa: 0.443s DIAN: 2.047s (creación 1.406s, revalidación 0.641s)\"}', 47454, NULL),
(1369, '2024-07-08 22:09:44', '{\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-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2653,\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: 47455\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619740\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00619746\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47455, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1370, '2024-07-08 22:09:44', '{\"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\":\"41d2d47058a2a830ad9459d8c60a604b44d89e8c45d4e3662c63e735b75c2ebe188fb053c34da3c09c9afe6fbc03477b\",\"sqr\":\"FEF2653 2024-07-08 22:09:48-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 41d2d47058a2a830ad9459d8c60a604b44d89e8c45d4e3662c63e735b75c2ebe188fb053c34da3c09c9afe6fbc03477b https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=41d2d47058a2a830ad9459d8c60a604b44d89e8c45d4e3662c63e735b75c2ebe188fb053c34da3c09c9afe6fbc03477b\",\"ssignature\":\"iW0V9Lt3vXuxwxzbyF7IIgSdgrnkIx+FUIJIMdMgqFvmNRMCWO4wtPJ03INIe7oCWjcJT6RSvyYwKKBzSoZ69IylYqPU49+xXXhbp/OMsy8iaQBULw/jM1EVVaDekIDH3o32bK33K6827reHAYON+eEBgCJP91fM7PmpbcNBYXi6CWP+aht5b6AW42bOwMvI0FKw9i9/BJMFY3tccDSyNlRhVeWsPV5o+M2HCfkNfVJ0UHmRUN0JL9o4mJ47blgIumM1ny8uW4fga/uopw92kWC/vaDL8gBO0Shuh0BOx6YjxEIkyuYvugOjrbMH5DFQ9q+IVVYIiURiIrID8AMTQQ==\",\"sdocumentreference\":\"FEF2653\",\"rtaxxadocument\":\"87261150\",\"sref\":\"87261150\",\"irefindex\":2653},\"sdebug\":\"Taxxa: 0.703s DIAN: 1.484s (creación 1.094s, revalidación 0.391s)\"}', 47455, NULL),
(1371, '2024-07-08 22:09:53', '{\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-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2654,\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: 47459\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619755\",\r\n                  \"scustomname\":\"BANDEJA SIN SOPA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14351.851851852,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47459, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1372, '2024-07-08 22:09:53', '{\"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\":\"922caefc1917bd288b1d3620595317ed6f8c0f4d063ebc2a1d13378a9ec40ea2e3bfd1b2a3bb2886f308e0974e65af48\",\"sqr\":\"FEF2654 2024-07-08 22:09:57-05:00 19385248 222222222222 14351.85 0.00 1148.15 15500.00 922caefc1917bd288b1d3620595317ed6f8c0f4d063ebc2a1d13378a9ec40ea2e3bfd1b2a3bb2886f308e0974e65af48 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=922caefc1917bd288b1d3620595317ed6f8c0f4d063ebc2a1d13378a9ec40ea2e3bfd1b2a3bb2886f308e0974e65af48\",\"ssignature\":\"AepPQbjz8TmF9xAsSK52S6tkUzqTk4vBEOKLszKjidaWJ01MbBVVAHAd1wdC8MpOfgWTtl2reyt5GWgNsB8mmp5zfR1dMw7Pw0cjrmQEVUcVsXtlhp4mQiI6aLBSgYwHxQblkpt+40oMYTja9UCcAcYJ630LxV99Ke3a1OPZ1lSl6lKyB60uwUyw8xi3mjFbq/Po63kXXhPQu6vfHoRJsnNj2lSmV7PZfBdizclRi5GD0gLdg3aiSBqta+3SVZ7wvYMQIrCZLduh4A92oUWObHWHh+61q69i8EHVJIj/X+UnHPGWrSfztxTPn1DcaC6458kHjWkZ2kuyQoNAocbwUg==\",\"sdocumentreference\":\"FEF2654\",\"rtaxxadocument\":\"87261184\",\"sref\":\"87261184\",\"irefindex\":2654},\"sdebug\":\"Taxxa: 1.141s DIAN: 2.348s (creación 1.457s, revalidación 0.891s)\"}', 47459, NULL),
(1373, '2024-07-08 22:10:02', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2655,\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: 47462\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619808\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00619814\",\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   ', 47462, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1374, '2024-07-08 22:10:02', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"8ef07d6069b02aa8cd6223bb23ca4088678f354bd56d3e29d9dce3e24fe9aaade84cb1ab628d4b17b166e8a8ed6995fc\",\"sqr\":\"FEF2655 2024-07-08 22:10:07-05:00 19385248 222222222222 33796.30 0.00 2703.71 36500.01 8ef07d6069b02aa8cd6223bb23ca4088678f354bd56d3e29d9dce3e24fe9aaade84cb1ab628d4b17b166e8a8ed6995fc https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=8ef07d6069b02aa8cd6223bb23ca4088678f354bd56d3e29d9dce3e24fe9aaade84cb1ab628d4b17b166e8a8ed6995fc\",\"ssignature\":\"2Kk0anAfpBp70rGiKc7LHzoN2Q5u78z4CFPusmTxSMMaP2fT/v/GdThikPSGEu2/AuHUNrmz/M3LxzJU4yieWiOe4HhMhkv4quKb0FUDqdSalRSQKfuWPwX+tnJ+nXrMh307lidnmexn7lB4ADARYUNMmbgmPo7KEbHhiZnVIX08IM1OLDX4NBFGdXDpOBLCQW0BkBD+D2LmZTIs2bFytQmIWcheLFnwCgR7E8OUjHXAUteoPhkkioydiDpfmhRzURJFYiSjsaLSky6KZF8RmMww70+m1t4XZlr5i4BgmofON7q0v/qtlXYQ2Uie8AG/bb4v15uL3skipqz+3dqVkw==\",\"sdocumentreference\":\"FEF2655\",\"rtaxxadocument\":\"87261206\",\"sref\":\"87261206\",\"irefindex\":2655},\"sdebug\":\"Taxxa: 1.191s DIAN: 2.222s (creación 1.392s, revalidación 0.83s)\"}', 47462, NULL),
(1375, '2024-07-08 22:10:12', '{\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-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2656,\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: 47463\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619815\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00619821\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47463, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1376, '2024-07-08 22:10:12', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: 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\":\"dc1d12cd87bd48e2a95c1a3d470f9a06030a241c537d7b25b6da60aabc04a94b7ee618be2519cdba81caac2f11c2ec6d\",\"sqr\":\"FEF2656 2024-07-08 22:10:17-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 dc1d12cd87bd48e2a95c1a3d470f9a06030a241c537d7b25b6da60aabc04a94b7ee618be2519cdba81caac2f11c2ec6d https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=dc1d12cd87bd48e2a95c1a3d470f9a06030a241c537d7b25b6da60aabc04a94b7ee618be2519cdba81caac2f11c2ec6d\",\"ssignature\":\"Kfo54OFMgu4LxWvuLR3b8pGUBiT2RWOjarjazaTLNfhB1xEvBl3H7znPgUC6R2CRzXPLXBs0vVEuqLW9mKkSzW5nslToAiJAx3J3YIORho+G9ilMbGIKl6jYchYpW4nhtHappaACR7yEDsE5iVAm0WRFdyWrPqyojr4PdtY8V6xKx6Qb/QYDygWXiVL/wvHFjfTVoIEl0qm1umyjCqQHHzNOC73X0RDHRKqATrrWJTr95L3IkZ/bQ6iXKPBnC0B7gk29eIaq5Bo1TY4eJPKbZZp/5qcCWsBQaZIi8H7BW1R2CRctIDAFN1JK7Ox9NAoRFGSc+dQoGZSAD0uJGR3Nww==\",\"sdocumentreference\":\"FEF2656\",\"rtaxxadocument\":\"87261239\",\"sref\":\"87261239\",\"irefindex\":2656},\"sdebug\":\"Taxxa: 1.012s DIAN: 1.569s (creación 0.891s, revalidación 0.679s)\"}', 47463, NULL),
(1377, '2024-07-08 22:10:25', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2657,\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: 47509\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00620369\",\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\":\"00620373\",\r\n                  \"scustomname\":\"HIT 300 ML\",\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   ', 47509, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1378, '2024-07-08 22:10:25', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"f377d712dcc0c034f0f5d3b1b5896c5077f0f022361f63c378423ac1a94ea1345637706299e1b4f258a6d604bf86f792\",\"sqr\":\"FEF2657 2024-07-08 22:10:28-05:00 19385248 222222222222 30092.59 0.00 2407.41 32500.00 f377d712dcc0c034f0f5d3b1b5896c5077f0f022361f63c378423ac1a94ea1345637706299e1b4f258a6d604bf86f792 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=f377d712dcc0c034f0f5d3b1b5896c5077f0f022361f63c378423ac1a94ea1345637706299e1b4f258a6d604bf86f792\",\"ssignature\":\"Aq3iDlU/EpB+yh3ZT3iQC7+bmjxTaK00QTaRCD+OFgzphZQo82+qVS5PQuoUJ7Gav96aOpwcPnmIDBhEZXySArsn21tpWzXu5UxWt5e89IOOZ3YJxVudwrj1OhPVIO3shBsN2snayyleTw6W1bZ5ay4Pl5ICeEx79MZKTP9VC1qkqmEqwdVLPMOzYxKN28HSWpt7BwBzfXhvYX+aZZkQxQp0jqibZF41iSNSomQ0N6EJHe8nD4D+03ERVXlSYMH6x8QOMyXpQlQQy0Mz+RDAN03aC5YjxXxdsvwzH02hDfUBj6zSpwPmn545jcHxPrrg8rrd2ssU6L35saf9a0SZOw==\",\"sdocumentreference\":\"FEF2657\",\"rtaxxadocument\":\"87261272\",\"sref\":\"87261272\",\"irefindex\":2657},\"sdebug\":\"Taxxa: 0.828s DIAN: 2.011s (creación 1.116s, revalidación 0.895s)\"}', 47509, NULL),
(1379, '2024-07-08 22:10:32', '{\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-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2658,\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: 47465\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619837\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00619843\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47465, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1380, '2024-07-08 22:10:32', '{\"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\":\"b3b9835b86f398a0bb6781831da4657372beb7f73dcc09936614922fbaad3697ba896b9c17749fdb2801e35c22e280a7\",\"sqr\":\"FEF2658 2024-07-08 22:10:36-05:00 19385248 222222222222 32407.41 0.00 2592.60 35000.01 b3b9835b86f398a0bb6781831da4657372beb7f73dcc09936614922fbaad3697ba896b9c17749fdb2801e35c22e280a7 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b3b9835b86f398a0bb6781831da4657372beb7f73dcc09936614922fbaad3697ba896b9c17749fdb2801e35c22e280a7\",\"ssignature\":\"rk6qSaQvRh4ES9TxkYqxhbczIsdZh1Vus39EEhNrZw7uvhbEc77SfT2dLwmKAnF4tG95ZHnhx7qMS6Q5ZTiskBUJ1R+2Ynv0pDuAews3SoVFm6p0TLr8f9hS5cYSrNjlU1ARtAjZZAWiPClmnrYA0dPu6emfSRkO8wKOEqElNXC8ApXde4ENdrVEp6BO0ILuh3I9YzqEg5/N3qtMpPCSbMTZq6UKE696f6VFf1X4x+/XYkrX0YvuhsyeQNKsktr6NzszlrUWwaZsuMCMd7KHQ8bx6JNY1mEbLLQ4QUym+mbM3rYjxRYbif7339PaBCh13h8C3E3xnWA+jtVObI1EWQ==\",\"sdocumentreference\":\"FEF2658\",\"rtaxxadocument\":\"87261300\",\"sref\":\"87261300\",\"irefindex\":2658},\"sdebug\":\"Taxxa: 1.901s DIAN: 3.243s (creación 1.703s, revalidación 1.54s)\"}', 47465, NULL),
(1381, '2024-07-08 22:10:43', '{\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-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2659,\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: 47467\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619859\",\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               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00619864\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47467, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1382, '2024-07-08 22:10:43', '{\"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\":\"b8249c0097620ddb8c4455012dace5336ab0ba1007d4e2367d5d647421a0574a91a6d26de777643afce1bdeea5de34ec\",\"sqr\":\"FEF2659 2024-07-08 22:10:48-05:00 19385248 222222222222 30555.56 0.00 2444.45 33000.01 b8249c0097620ddb8c4455012dace5336ab0ba1007d4e2367d5d647421a0574a91a6d26de777643afce1bdeea5de34ec https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=b8249c0097620ddb8c4455012dace5336ab0ba1007d4e2367d5d647421a0574a91a6d26de777643afce1bdeea5de34ec\",\"ssignature\":\"Nu/GV6BYNASm9jrvN8fkzjbCSLo0gl/27PICJEIiFWwei189Vz0hJMbiASA08esMnezCJBL7vMLkJV+C+lUMsUmoC44ziwBg8YrJ93VNVKfbScCFmygZxV9QOi47RDlwlGwN2566UR0ZT8maCSACuWL/xnjxTGGYJ5QDIPxoHfaP/2HjQfyGO4QPPnkKi0P7BM8VA4TwOS19zxgVySlq2EdEZngSLRSOaa/eHOT5c9tOFW5kPO71JsC77c255DZZ8oapMfgZzpyP8I8GtO792i9vauDtLNWPhJPEXLhoZvgX4gMPZDsMsBphY58tPBe4cQo+70+vp2bDGRRzm7vvCA==\",\"sdocumentreference\":\"FEF2659\",\"rtaxxadocument\":\"87261339\",\"sref\":\"87261339\",\"irefindex\":2659},\"sdebug\":\"Taxxa: 1.498s DIAN: 2.3s (creación 1.297s, revalidación 1.003s)\"}', 47467, NULL),
(1383, '2024-07-08 22:11:02', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-08\",\r\n               \"tduedate\":\"2024-07-15\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2660,\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: 47468\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00619874\",\r\n                  \"scustomname\":\"BANDEJA SIN SOPA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":14351.851851852,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47468, NULL);
