INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2069, '2025-04-29 11:20:27', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:20:28-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 5366eacd42b79d5aa3c05fcc221cf51e9187bc26b8dd187f103da78807199c5d991aeecae37bebc45b6a5a5a6626fcf8 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5366eacd42b79d5aa3c05fcc221cf51e9187bc26b8dd187f103da78807199c5d991aeecae37bebc45b6a5a5a6626fcf8,ssignature:B8BtraQedApXz0g6FPaWZo8PJM5QcRZAQfVWN3C2zVO3dRvoS2WvT9NpYhGtcxGAsUtVncC+quSGxJkMOi+QTfhASt9nTr5ooaubSJvayBkbgXqZ7WcE38sS1r2zWaYWkt/5GdqIIjA/cpfIceMf1CKGjH8MYj0Zpi6AIhqSM1Y9Ez9OT3DlLxDbrwe/4AvP13TiJ1igKDGGEcx6bPeil6DpO5n0oMI31z3ZraA4XUAMGJsSPiZ9uGhE/cNlGgpuBv2kSrPbuKvtelqaneV6ruPDNBinURDLsQymrjWG8kZedbMVf92ITCnP62QUBEMjo6X/4s+a8JV3Og4KOgnpdg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.326s DIAN: 1.332s (creación 0.861s, revalidación 0.471s baja 0s)}', 47780, '2'),
(2070, '2025-04-29 11:20:36', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2071, '2025-04-29 11:20:36', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:20:37-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 a16b35ff6a7f20c53b1b9c3d644035bbe7d7de6e7fcd04934ab616554998b13fb28821d6f9221adeaf70cb817dd57857 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a16b35ff6a7f20c53b1b9c3d644035bbe7d7de6e7fcd04934ab616554998b13fb28821d6f9221adeaf70cb817dd57857,ssignature:mFpidYw11wHE7+FiMYrlPUFKAvPV28Lnwr55+DjtRLb6zoks8ih2as2RsIphpYweJfWynjs/6mkJb0OYer7zDFTwaLs90WejWCIvcORGj96MtOJHgumR1HFazAtlT4D0eNkQ8LBsgXT1hZRY8y1eo8znAuRwbjS03Zxr0SFl+tt4mdeLUxWrMhp8kFtf4iVenm2Ynwz8uRR17gXq/V4c9UC5uOFz35KTVatC/uCH4kv/UgobzChXuZt+XoqsE0utVpsYURMw4Qj8xXWgOytI5Y/mI04UeNBHCAAU0mAyAhlb8IRlBSvZWtERR2ecWTks6vRpnh2UsPZz3HTfLvVQ2w==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.28s DIAN: 1.489s (creación 0.808s, revalidación 0.681s baja 0s)}', 47780, '2'),
(2072, '2025-04-29 11:20:46', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2073, '2025-04-29 11:20:46', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:20:46-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 6bf79b29850f8849be1fe6d2fd8327e587878d79acf842f94ca999913977a3592028915de88b7da1a0ecb650aadaca88 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=6bf79b29850f8849be1fe6d2fd8327e587878d79acf842f94ca999913977a3592028915de88b7da1a0ecb650aadaca88,ssignature:AjDKYkl/iSJNTsQF7CN2ELYHbtS4cRpdpRYJYWjmBuyyzNUzjDEqu7u6TbrUNYeKbRmbtnKmfh5cL8r1jlBKwDOkbs/xDjD+CQ5PllKeV4W2tRyurneBPb82z+KjRKqQCjZtJ6xepkcjvRT8cMslqyc4zjAYtNSolW6yE45HsTmT++ycbkf6i1ytlsqGVg2bOLAUWDnjhFrtAReguBTAZPxs44opjuM4KKoZKKEzValzL1CirYkDLYnpjv0hZsnXD5nAIs3T82JlfNP1yJwDDYOYbdLqqRLirGnojqp1Jfy7/rERPOflu4YOwoN+3CRxnUc8wVrtG6Kzv6PQQbVSYg==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.281s DIAN: 1.062s (creación 0.676s, revalidación 0.386s baja 0s)}', 47780, '2'),
(2074, '2025-04-29 11:20:54', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2075, '2025-04-29 11:20:54', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:20:55-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 3f38c75ddb148d95ea36eacb0e81c09978feea453c1ccc623f41308635c871496713fe18ba01133eb18dbc2e2a4c3d19 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=3f38c75ddb148d95ea36eacb0e81c09978feea453c1ccc623f41308635c871496713fe18ba01133eb18dbc2e2a4c3d19,ssignature:oWg9Dy5kWkp8qY3J9/6nxzcRDz9HVRxuiAVeIDj9ps4hmJ75M6sDR6uO8T4ac4wthpgzqKP9zfBZtYnFvcpZ7QamR/bF1IiRqaCsmUQ3dcr0zUTBQpMwKRMrcwM4pGBCOdgJHhWoOyrGdl5IuFA2Vpf06+9pSLMWwoEli2EnC4DuOJ0svcw3Sprf9ToobSYPq85weHPSAenNR9IruUX4Qi/OnRFQrYxnCbjJGCbrTjAwl04RoW77L6S9W0aWJOnHVzPcVMjianDZg2Ug5oj+U4C2YyJG5SkmymtiWv9WcZ7TGYwrc+DOEgV/LDLL1aSJUf1cQ8DsIJ6B3+0LRVah2w==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.294s DIAN: 1.176s (creación 0.696s, revalidación 0.48s baja 0s)}', 47780, '2'),
(2076, '2025-04-29 11:21:04', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2077, '2025-04-29 11:21:04', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:21:05-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 ce9d083f10c85d083c1abb852be0219acaabf20040931751c293fe2959601ac67dc45bdaadb129e74cba0f742f664665 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=ce9d083f10c85d083c1abb852be0219acaabf20040931751c293fe2959601ac67dc45bdaadb129e74cba0f742f664665,ssignature:OQ9LA0X0VCMMAWqmh/c5Mr4g7msWpAVikK1PrhW7qgf/cLoOyvng0FXaTuSrHInIn5LkkPycOuRMaPRFweeb95drhjTPSwfa3ukBdcPdqrSbn5ujBz57jFSJgZxwQop6yIF+xapZthVJKlil2ekt9JxZNOq3ivbfvoVQMiltZ4Q8gUh4gUNz4fbUa/R71C1BYoO7MOR5bTBt6l71ZXZsU9YPZAsWvYOc7jzZMbhBUcjH7c44f6Qkd1U8Fvr8RKzADrqXobpryBxwtFybMLAXz3m4gR30sewR4xVNToXSeKGUDdgRNaFrTa97xH7GwrFp4wDaoyEV149fweaVJMX58A==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.273s DIAN: 1.023s (creación 0.679s, revalidación 0.344s baja 0s)}', 47780, '2'),
(2078, '2025-04-29 11:21:13', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2079, '2025-04-29 11:21:13', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:21:14-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 3522b4b625279ccbe4accdd3632fb2fc6140a8e21890ba9926ee8768350bdad3ff3c830b60fbcb8485b67c52ec432721 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=3522b4b625279ccbe4accdd3632fb2fc6140a8e21890ba9926ee8768350bdad3ff3c830b60fbcb8485b67c52ec432721,ssignature:cLaDuquxM7L39cKQrf+6/ENjrzUEqVnWc3bDpKhQLLV8uO1ZaDvkNJCRPmDUuHVge4h1me91l59c10OIQpzrQaaZBQltQZKmhBJB0SxKrmvvS4jzDVMiRmTFjoW/TFKykhodbW5yXSDGrC7R/Xj6IYe2TPBX47LHI4D631S9CPn4Du+S3erPWyov5QS8z1F9i6NQUsqF07uKsw7SLFDjRQ+huCE6F68EZAT32oRhBM8tv9mKviB2O3ut/h7xOgPBi1ySUUD48L4Iw3lPpeTkRkPLMY01C938gRSnNnvLd1Cpr+kqTCvVp3GFFOZmQlpBhAlaqSQZ43zLMza0gXDB5w==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.372s DIAN: 0.997s (creación 0.641s, revalidación 0.356s baja 0s)}', 47780, '2'),
(2080, '2025-04-29 11:21:22', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2081, '2025-04-29 11:21:22', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000979 2025-02-09 16:21:23-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 0e3b4cced149805f061a8e5a8f03dd5cef9ac7735c6caf6707678b967852e563a20b672a21149352adc42018131589f3 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=0e3b4cced149805f061a8e5a8f03dd5cef9ac7735c6caf6707678b967852e563a20b672a21149352adc42018131589f3,ssignature:td+4lKq7uX6ScRraKS1i9PdXK0bzE/+226zseB5Ux4t2+vVNV5hGhHcRtFJ/Z+iAT3OGUrdWtsJRsp7bBFaTOGrUCATwBPrAcMWx7PrAWeTe36NDDOaAA344HScMgQb46PJUrVYU3mC2Oe6tITTjdMmaBvWFkO8AL9qVZ+llwam8IRl4O2ivRufxdrIArAH530rJSQfg+ofUQcsY436meAWkhPM79tcbJ13NMidibc9J+1aGTB9ebnxo8EJ0nokbDEKpectrb//84nDKLSx7PnuDwvd3+xIi1zfU4e2OrStQJfx2VzNeK36zxBMIGBz2AfkBYK7huvT0C1E39k4LKw==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.282s DIAN: 1.506s (creación 0.737s, revalidación 0.769s baja 0s)}', 47780, '2'),
(2082, '2025-04-29 11:21:27', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-04-29 11:19:15\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 979,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"ALEXIS ROMAN\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"FN\",\r\n                     \"sdocno\":\"26234123412400\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"ALEXIS   \",\r\n                     \"selectronicmail\":\"raulotalvaros@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47858\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622881\",\r\n                  \"scustomname\":\"BUDWEISER\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6750,\r\n                  \"icount\":5 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622882\",\r\n                  \"scustomname\":\"ALMUERZO ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20250,\r\n                  \"icount\":2 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47858, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2083, '2025-04-29 11:21:27', '{rerror:0,smessage:{string: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:de2bddcd50ecd6335c79d889df75687ad519a8ddd6569f43e801589ad6439baedbc94f5bf8ab5edf57d8ecf55a8297f5,sqr:SETP990000979 2025-04-29 16:21:27-05:00 901402281 26234123412400 74250.00 0.00 0.00 74250.00 de2bddcd50ecd6335c79d889df75687ad519a8ddd6569f43e801589ad6439baedbc94f5bf8ab5edf57d8ecf55a8297f5 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=de2bddcd50ecd6335c79d889df75687ad519a8ddd6569f43e801589ad6439baedbc94f5bf8ab5edf57d8ecf55a8297f5,ssignature:mA55e0cDfAjS9ysIhKqfM+OeReUC42YIgKixSK699+cXTqpAOyvXUfM+BR/cWktQdCVSiJtss1WgK6up91BADKFYiOKZQjVjmg3Hun8+bKgdkRC2vqxx0vO+DGjVRk4f9Xr823pJyCa+4hCF/qBbtiUSYyWBw/LLWvb+S6cUcqTJVTScAs8lawFr0oz0r7jZF8F4yquZEPpQOrC/CRYeITAOI/yS9/mH3xJB8N/gGIaHN+wJqmLs5eaS1DwNyx1idtnCGYMUNhYWjpA7r/Wt5PjDNY40YlpOf6+1lb8sWqdHC5fqPDAseyU9PudAFcJOB3z4xAJ6y2x6AN0VorPEww==,sdocumentreference:SETP990000979,rtaxxadocument:220666280,sref:SETP990000979,irefindex:990000979},sdebug:Taxxa: 0.315s DIAN: 1.491s (creación 1.14s, revalidación 0.351s baja 0s)}', 47858, '2'),
(2084, '2025-04-29 11:21:31', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 980,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2085, '2025-04-29 11:21:31', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000980 2025-02-09 16:21:32-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 202a954892d8ed437f27ad238285b11e2dd6a33518507208d726d19c5cb6a60eb50c6311bac4e045d4d689f958f082f5 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=202a954892d8ed437f27ad238285b11e2dd6a33518507208d726d19c5cb6a60eb50c6311bac4e045d4d689f958f082f5,ssignature:n0EWne9rMBi/78f/xHGH4ZaA91zINiAk34wC2pICCsVD2PEJZhKRcI2PUTDIcRsQGsldf52O4DFcIFj7I0eH4DwebbSHbNbYHjEAGTAbO9Z1xXkw9vlnVYWpZIKC2bmIdaqi12TcdSQ/JToowczEXhh4iFTG3YO/hF+s02jOivv2pX6tuiUhXroIOc7wRf4Rg5ubRo+Yjfoly4H7jlPBOC3E4cc4XL8Ft2KJD7Hepb/UApn4MgRbzKJMthJgLi8yMCys9ri0GI0o9aeiZOLQTJL9yStgU2Ziv/69+gXn4gJAMlN+644sMF7m0OeYk+AOUCnFAOOPKXGLGGae3ZMv/A==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.351s DIAN: 1.65s (creación 0.761s, revalidación 0.889s baja 0s)}', 47780, '2'),
(2086, '2025-04-29 11:21:40', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 980,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2087, '2025-04-29 11:21:40', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000980 2025-02-09 16:21:41-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 6a6a4880f9ddac0e97b4bb12869b664e149e504b30238d8f0ee832a0b2d17ca5dad80270087286d7af5f7cab85db93ca https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=6a6a4880f9ddac0e97b4bb12869b664e149e504b30238d8f0ee832a0b2d17ca5dad80270087286d7af5f7cab85db93ca,ssignature:xPg2Ewn7f9yKe0JH20KguvGybjnZGWl9j+shHLX9KhZU0WKvqJqRw1R8sZYbS1ofr/VyWzFJbdBfWYx3uQ/7NnwENpTB/AaX5mNmVUDnZHJom1af6r8+ToAfrihE/sQ7jbUIANg+bt6mZAxhTNftM46A7mG4zviP8AuaC4z4wCDBo0PINXgbMgsI8fF7mm694uKlesWxCvzyJM0zHGqhOZgzCyVip4xOnjbjPj8ONt74X9L3RE+2KbdZ3Qq2jLgOTI2ToWxattlybwOL9ImnOxFxEbmG+R8Ka04B0p/20L4vw4lZepLvpCHyIg9T0RZPDm9drlIdADrmVQTxILv1GA==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.303s DIAN: 5.8s (creación 0.65s, revalidación 5.151s baja 0s)}', 47780, '2'),
(2088, '2025-04-29 11:21:54', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2025-02-09 16:16:12\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 980,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2089, '2025-04-29 11:21:54', '{rerror:1,smessage:{string:{0:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,1:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000980 2025-02-09 16:21:55-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 a843bcc9baa69eae39b32bb5989b1e22aec515aceef690b47580a4d9c2d666bb585f78eff816d175f7cb25dbc7df379e https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a843bcc9baa69eae39b32bb5989b1e22aec515aceef690b47580a4d9c2d666bb585f78eff816d175f7cb25dbc7df379e,ssignature:ZLLR0HOt6bhK3FUly4gLBvh6MFPGifO0K1y9a+5vioH3Lw+hVFd4sDhv3SRdrsQgQPwOcXeEeFpS+3vAU8ggl7GHVdQCmLDS9FHZely0SO9ogsNB3D50mDfoYUT2AB+idRBp6I9WiA0skex0sDdt148VsojV+sRU+q8DHj7LlwRxnNfJj5mWxwvxIu3tlCsyKmAe19lq0B6JB9u3Yw2SLCXX8vZ9FQ2diSAIuhs6ynv65Y5/o4uOY/j9Ohgkp1Qg0FG30D1tughQ2PuquJb9mXhi2tp1QBS0F5CXb2SABzmmpoaYp+cf84Hs4E5T3uKrv5KemArPj1UkIoDDAY3ILw==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.372s DIAN: 3.301s (creación 0.761s, revalidación 2.541s baja 0s)}', 47780, '2'),
(2090, '2025-04-29 11:22:06', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2012-12-12 00:00:00\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 980,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2091, '2025-04-29 11:22:06', '{rerror:1,smessage:{string:{0:Regla: FAD09a, Rechazo: Fecha de emision anterior a la fecha de inicio de la autorizacion de la numeracion,1:Regla: FAD09e, Rechazo: Valida que fecha de generación de la factura sea igual a la fecha de firma,2:Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.}},jret:{sreturnedxml:[BLOB],sdebug1:[BLOB],yapprovedbytaxoffice:N,scufe:,sqr:SETP990000980 2012-12-12 16:22:07-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 855e219a4c00029b9f1b840c6bb37cf48cfd7d486a8f833419b5380a706b97f095f05e8126bf92f750b3aeb567101cfe https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=855e219a4c00029b9f1b840c6bb37cf48cfd7d486a8f833419b5380a706b97f095f05e8126bf92f750b3aeb567101cfe,ssignature:AKiXwM9G3sHxbMsM051V5MqQCSTylXLGLQHeIqB2gQKZNHKZeriReFUEUIlo4IDJEuF5tIvlYfvLLGhkui1wbQUGVcZ+9iMk9wZr10qKvEbhqtTRUqTNWO/VUUn7CBXnCsTk2A0FYRGIdiCqPOPm/BDgb8TuTEXuhq9msnbESzQciUawOuQKI7nRYVcGg4caNodOA7X+2z3v4Vi/1ieI/HgvAWedYWDy8gfcjfuhbRo9a4UCB0+H9mm3YQq8lI/1rxecUULleuw6O4/coXW8u6mw1ATRiEawxbaL1lbCK7YBke5ftu7WYqHYVavJriY4LOqTVffRHH0KwbvwEgDSLw==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.296s DIAN: 1.207s (creación 0.763s, revalidación 0.443s baja 0s)}', 47780, '2'),
(2092, '2025-04-29 11:22:15', '{\r\n      \"sToken\":\"647040344268\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"test\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2012-12-12 00:00:00\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 980,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\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\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47780\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":125000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"jcontact\":{\r\n                        \"scontactperson\":\"JUAN ALARCON\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"66\",\r\n                           \"sdepartmentname\":\"RISARALDA\",\r\n                           \"wtowncode\":\"66001\",\r\n                           \"scityname\":\"PEREIRA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"660001\",\r\n                           \"wprovincecode\":\"66001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47780, '2');
