INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(2093, '2025-04-29 11:22:15', '{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:16-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 1259a304bd613be940d53d0fa3699894ecb552e65b279851ba1a137800b0edf72c6966cc71807412472d56da0f52d727 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=1259a304bd613be940d53d0fa3699894ecb552e65b279851ba1a137800b0edf72c6966cc71807412472d56da0f52d727,ssignature:enmiQl45PD7NscXLCtYDSQAaOfRnHw5qbSoUMExAwfh7Xrfq55HMoUgcUZvDbfcRROODuh8d6X/clkxX+cJDafVwzqtPR96SIkK0xvELAKjUq1SVcBG1nqrfc751nGCsDgS2U0ITd7sWkCGiCHMladOvnfTInHuU8U+PWxi3Pm8Kbk+DJAYWFNcboBj0NcsPnTiymd7cZzwY3jadEI0RXPFcx6wCye8ffGRf+DRsqJxfmg6WsjVDJvqLD0jSi+vK3ORFHce0ibtC7pMT5kivnf2/mXuRi2ZwkWrcF7UZg2524ZetOP4buly/r58W/utvTxWwPdthKevir2dTBeE2Iw==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.279s DIAN: 1.876s (creación 1.086s, revalidación 0.79s baja 0s)}', 47780, '2'),
(2094, '2025-04-29 11:22:25', '{\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
(2095, '2025-04-29 11:22:25', '{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:25-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 c4863d8ab99e6cca2e837f39059fc6f585a28b477f457f701e9dfb15bbf6d58bceecf48d47110a44e73d84b8bf4071a5 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c4863d8ab99e6cca2e837f39059fc6f585a28b477f457f701e9dfb15bbf6d58bceecf48d47110a44e73d84b8bf4071a5,ssignature:Hlkzs/ckuRu450YJH943PMix3xEHw4YqobVBlTw4jMFAs5+LI1tyRjaAci+Dl3eixiT6h12p1yjojC8NuWlC9/LGlPQ0aDygbsR1ft8RXiJY0JlCIKMAf+HsuQr2fMn2FyMcLNeoYZO5CMu+QaqbwPhGzZfJYqn+0K26Jbsb8N2tdmnZlVTGmyNlhcOBrPOFC0z1zjTC62AH5DoDXivSMP3U8ZNUOTCcF3nHoGrh1o8djUM9r87/mLRaKipQ7C3nMpXY7NS293SrpXG+a4OfrMgjrGYx7TzPepJ8EjofPWqP6XnveQpzXF5QdDJjqocwyZpmndHjgotrQyc5X3QwXg==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.296s DIAN: 0.975s (creación 0.563s, revalidación 0.412s baja 0s)}', 47780, '2'),
(2096, '2025-04-29 11:22:34', '{\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
(2097, '2025-04-29 11:22:34', '{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:34-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 8d66e09c175e618325da87f4be8b5d9fbc2af4d5723760149733cea3a0ed2114192a8dcf0e0b4dc627660a87575d8cfb https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=8d66e09c175e618325da87f4be8b5d9fbc2af4d5723760149733cea3a0ed2114192a8dcf0e0b4dc627660a87575d8cfb,ssignature:W/KJfy5nR4qPbsrdNP4pvnuHcIL+ZR2LgVIcDSm5qfklPJaahpzKMxIRc2spCG2oDsQdKb0Wk1memKBKX27Gg1QRr+lLiQjX3kZWRBuEmpDwugAHELpojb1boovjAu0+LkpKGQ8OHgKWAU6WEr/1eTbZJ4eRJ+TjtUShMZfuAEU6OrCLXnSG3wvYhnvLw/iCQt4DEfp0jL9ddiODV5NFA6expriouF9nTD/UAoRi7CIQbds7vHsy5M2qxobzIQaoHss7/eykbQDI6yo19D/EhHQP/YxpqL+HqQTI5B9wQB7R+tUZ0JDFo7Iqbu/x7rDn/lSaTVtHLPA+1RRwz1Qizg==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.312s DIAN: 1.253s (creación 0.735s, revalidación 0.519s baja 0s)}', 47780, '2'),
(2098, '2025-04-29 11:22:43', '{\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
(2099, '2025-04-29 11:22:43', '{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:43-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 56251ae393f48073f1f4c7a1e78e2cadbb178f496275e855d19f221051a831d47b3b29af4e5908058026d52c254a8e15 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=56251ae393f48073f1f4c7a1e78e2cadbb178f496275e855d19f221051a831d47b3b29af4e5908058026d52c254a8e15,ssignature:KZmcHHCsjHN1dDw60ZOQO2gY0mcOo6DDPze20AFeFaGIiuhbYpjDS3OCM7xO2KmPKs5/ACA+IgvzKpFLuW4tC2eZSLz+y10KoWXM6qX/igtju6iZHwyFs89ch4DOwvMBTW5/xUaTAK1mXjJEERNc98zD5GI8O53ANq2chU7BegvPwcdISTb2lxsDybga7DOX289C89JO9ays08W4HZ1rOL79zsFc2NWNsXxw+0k/JhQZ68mMuEHoANW1FeW6rGHrGj3EGqPQ4IVEifs2DDz+O7S16y4b/115nKWSEXF1M8R0B49x5jEdFluvmPngelpUc9gTxc5Wg4Ho8BUTTs3PHQ==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.33s DIAN: 1.292s (creación 0.614s, revalidación 0.678s baja 0s)}', 47780, '2'),
(2100, '2025-04-29 11:22:51', '{\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
(2101, '2025-04-29 11:22:51', '{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:52-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 a75e0da90c29c286094a2a4c857f49e561410d9caf1357dc9cb457594a3c93a0c145bdf2ec01988ccb70a251c1849587 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a75e0da90c29c286094a2a4c857f49e561410d9caf1357dc9cb457594a3c93a0c145bdf2ec01988ccb70a251c1849587,ssignature:re+ZuL+xm7GkEaYZFt3si8yXxKFQhJ8o1H9rd2XiJ8dk/snDl3/EYInxqIuJal1MC1u4BWVZ9Ns3Nzu9ApgvMJcXvPDzKnQO9KteV+w6WORZS7xXI6WwwWKn99+gDGQw51GMfLhZmUHKsMrBjXbNwVZ4hnTYLXpRntAlTZPuXOq+05arvu1yqiObR0clO5wuqs6k7wit7H1jEhbJb9FDTRBO1WvGhWG4zlsIdLFnUMSivs19nKYV2lMVXw3VQI2hB1r2fbl92g9v9wG9kKexWHidn5VJKVr9PcK4d+07IR+0aL+0+9EIqWNtDZf/CNxnCn8w8CgBnh4a7JawaYxrOw==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.289s DIAN: 1.17s (creación 0.707s, revalidación 0.463s baja 0s)}', 47780, '2'),
(2102, '2025-04-29 11:23:00', '{\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
(2103, '2025-04-29 11:23:00', '{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:23:01-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 c7a1019a75b7b97a6c01a45f4018f9c8687b46d463c5264dc93586c6f77a277eccf88695214bb8991ac4ab9e572821fd https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=c7a1019a75b7b97a6c01a45f4018f9c8687b46d463c5264dc93586c6f77a277eccf88695214bb8991ac4ab9e572821fd,ssignature:sp6+NCpxiZW3gNsTsNQasPowx+eG8I1wSCaTxVhmS3X0Bf9dRArs9+VQ6pFBh1xxBou2Tng+PzUqhF219ozmeqW4T2LRJt6NP2Sd7+4+XthTQookAd9EDAyVjI155EnXWIqD0x/sQnJ3xwT8WMAkcbcPS35uxyO4XGzhZfWlfVXSxpA0j8EAKFMODoeLLBXrMa8afbpsTt6Pq1HLncb0uuMoaQR4NjI1GUfQ4UBGCXAq4CQokjFIP/oTqxOHu+jX38QtQdAXftzcDA9JzaT6WpGGHzCMs9qfYPp0fNe9YFi6KnNA2DaQGL8VB96VfbOjGTX0GDqQPMq1BNjxXau+zQ==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.266s DIAN: 1.527s (creación 1.116s, revalidación 0.412s baja 0s)}', 47780, '2'),
(2104, '2025-04-29 11:23:09', '{\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
(2105, '2025-04-29 11:23:09', '{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:23:10-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 57374210c924db7f72ea70b1f0fa5a2f275dcd066e1d1df0e22d6394dff334a02a4f1f47cc61bc6c93b3b7ee98be5748 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=57374210c924db7f72ea70b1f0fa5a2f275dcd066e1d1df0e22d6394dff334a02a4f1f47cc61bc6c93b3b7ee98be5748,ssignature:GferWPpPggLRM8vuBfmcyk7Lsb3hzMh08sp9uzdK3HwxLEloZGJI8i3DhOVrHgRfpAkaUWywWwWKHozj+aI/yjTypyKTPSNsK+S4sb2xqMW+oTTE7VG0OxRj9/8/0AwhH2LhXwc4Jc0OzsoZ2MNIwwciUo2rRl1fguhYG1KKSEwDsmRgmQeHhH8pqZiT+L81PfYEnmxygFg7kYsAKup8nrMIZcQ08ijZh7ktr3z1AeHZOv5h6n4379VBord+cmYiVICCntWsT38WLFG1RGhNzopX0wtcdhv1XElyaO3AKYOilVvJmG11nt6BFTgur3ToOrQ+YG2QiSJP0yL3H5d3uw==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.269s DIAN: 1.381s (creación 0.985s, revalidación 0.396s baja 0s)}', 47780, '2'),
(2106, '2025-04-29 11:23:18', '{\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
(2107, '2025-04-29 11:23:18', '{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:23:19-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 49241db556979c78a9c6d352b7a4bcdb54b6bdbd77b4818c4d8f4695e5160954f11532e1c4c60d75f0f30bad1d00592f https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=49241db556979c78a9c6d352b7a4bcdb54b6bdbd77b4818c4d8f4695e5160954f11532e1c4c60d75f0f30bad1d00592f,ssignature:VRpgHfNPwlfkf+EzhOJo8+QYipo3PWwDYrGZxC7KZvcIGY9Nq2RouxI/BMWV+fjuRlEcPoyTW2BML5Yey/US+TpQnMQTjJ+/f//dz24L63M21/snEYVzS9OeBbGhdnZ38HsH3a05wVwaZc4CoYtgFEdAvDxEOkcyn6L34qyHBY+ovuN5kpsox05KDise3qBJDV5VLXglcSP7AfZUIths/oNJCPVZ922JcQcshQ+MMi60EJcbVE3uscrjY4uY6vn9dp1SCl01sjrUuf1GQhA6946bEWLC7qiH+XkejYP+bhVusaPt7Lr30L/J+kVUMu1u8xyw7lRR83uWxmunpU/k7w==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.287s DIAN: 2.236s (creación 0.712s, revalidación 1.525s baja 0s)}', 47780, '2'),
(2108, '2025-04-29 11:23:29', '{\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
(2109, '2025-04-29 11:23:29', '{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:23:29-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 6b27abeef73e8345ff578ef356e4d458f9252bce5110417af7b66974147ce4f68c436483d456c7d722e07fc9dfc98955 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=6b27abeef73e8345ff578ef356e4d458f9252bce5110417af7b66974147ce4f68c436483d456c7d722e07fc9dfc98955,ssignature:C2HsxMWYNZyrgAK9rXfi3+2+tahGb9Lbhqad69ca2mjTUfL1A7FVuStzkEtAi9zz+YtMsckqY32zyGutbKszBBov3IoYp52GyFaANxfGLhXE9Xfg0tD+4ZryQfRo/hTI95nTEhHEHSXJ7yfugAmtyN+GpMtvZr7fyH/gif/x8a+Eot7fpAVQUTfpuk7XdCOGl+FsDzZUVhgsG/QM0ptASNzvO5W/RMlXQ9K2iRYxJuuMXJng0CvTYWGwCKEb5LDGF8X0dI+MsQzAczQeu4RkPxcXYRgUThkGsAt2F4FunS6yTMk++pg2/wN7QVNsyH5fyeZANHTRZZFKlOdjhrv9NQ==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.275s DIAN: 1.568s (creación 0.928s, revalidación 0.64s baja 0s)}', 47780, '2'),
(2110, '2025-04-29 11:23:38', '{\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
(2111, '2025-04-29 11:23:38', '{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:23:38-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 261557e455c9bb00caadb63e3660d5cf98325bddaf1c43edfdaaecfdbe4587340d6a11acdba22e8fb2f81d9cd5dd3e38 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=261557e455c9bb00caadb63e3660d5cf98325bddaf1c43edfdaaecfdbe4587340d6a11acdba22e8fb2f81d9cd5dd3e38,ssignature:IcKYVONB4MqNBPnBgFW45957sZpKfa3fwJNg4ATYO9uSyLgGq+b7laF6a0bIDokYX6s0/0Ckou6POhdVUniIe2OFxk29mEp6106G7xIi9XZrFM2g4PO6ingEO3Arl5PuczPVAjFyQU5StZmVNr9VIhhra8iUGH4wGehEip01S6nESaOU6jk0oJL1SgMsoXPB84LMMWVuX2Y6X3FTgIGC7RZAoUTtftIUFrRVCO3ejqm+YJQb5s5LWGPFP3wLdxWO7WkZxHbgrl/B6MyUtmE+It8Q4el1fb5xI6AbUVmOJSGaBg+h39E5+yaihs4HiWl4OX5CllGNBnJs23YEGrATAw==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.279s DIAN: 1.066s (creación 0.618s, revalidación 0.447s baja 0s)}', 47780, '2'),
(2112, '2025-04-29 11:23: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-04-29 11:23:39\",\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
(2113, '2025-04-29 11:23:46', '{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:37ad4a753cda841ed56dbca0390c3af3f5ed09465958b61fbe592e65d1b1dd8927f6b906fcef7edb23e14a0eebdcc15c,sqr:SETP990000980 2025-04-29 16:23:47-05:00 901402281 222222222222 125000.00 0.00 0.00 125000.00 37ad4a753cda841ed56dbca0390c3af3f5ed09465958b61fbe592e65d1b1dd8927f6b906fcef7edb23e14a0eebdcc15c https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=37ad4a753cda841ed56dbca0390c3af3f5ed09465958b61fbe592e65d1b1dd8927f6b906fcef7edb23e14a0eebdcc15c,ssignature:wcrFzZUsLv1C9VRV6qm9JUPSCyuB9qFO72i4o5u6T54r74uSsfOngAWOVcjG/3puTUGysQZwZ2WghmpSCWnI/KUduNzDp4tWUT8D9gOmT1YgUgbBbcbMGttMjuFHmbe/NA6eN9FaFG3KJ9EUIz6e72zLGYkM2wX1arMJMQEFSEqfhH/LNYwAwUNmZcUUsq6hqT5FwXvKflqoVZOto+NeSc8ggE241O4F8FShbgp5xF2YiYf+qrezzAxGs1XoDo50junQZCPsiCqni/w1pOgjHB7iCBxiwBCZ+CShGraq+YjlLt901aW/ZSCPQV8nvP1CIGiwuuye92KvB/6d0PZGbA==,sdocumentreference:SETP990000980,rtaxxadocument:220669792,sref:SETP990000980,irefindex:990000980},sdebug:Taxxa: 0.266s DIAN: 1.281s (creación 0.653s, revalidación 0.629s baja 0s)}', 47780, '2'),
(2114, '2025-04-29 11:23:53', '{\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:23:39\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 981,\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\":\"   \",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\"1234567890\",\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: 47704\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":50462.962962963,\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\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\"stributaryidentificationkey\":\"ZA\",\r\n                                    \"stributaryidentificationname\":\"IVA E INC\",\"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   ', 47704, '2'),
(2115, '2025-04-29 11:23:53', '{\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:23:39\",\r\n               \"tduedate\":\"2025-04-29\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 981,\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\":\"   \",\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: 47781\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"001\",\r\n                  \"scustomname\":\"Servicio de comedor\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\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   ', 47781, '2');
