INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1965, '2025-04-05 12:18:18', '{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:a266d1ae8199865b55eab98aeb75c234f179bc02efca7a58e85211e56e20153df0a986a7f8591158f07c4d4160eda5f9,sqr:SETP990000957 2025-02-09 17:18:18-05:00 901402281 1564561 23000.00 0.00 0.00 23000.00 a266d1ae8199865b55eab98aeb75c234f179bc02efca7a58e85211e56e20153df0a986a7f8591158f07c4d4160eda5f9 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=a266d1ae8199865b55eab98aeb75c234f179bc02efca7a58e85211e56e20153df0a986a7f8591158f07c4d4160eda5f9,ssignature:WPGGy/vTiRhrs3pE+PA3+S4AJrEc71ogsg0XgPBvoX16/oyBjagIVS6nXHePd94k9BkpeCuDQRy60pxjUhVvwSLVCTdcfq622GgkiZIRNPWb/YlWLEFdBsoI/mj4R+xYiuQK3pIIHSviJ9Hu9z1fgkVeKQjH+w9vGvkUn8Eh3mpV09Q1JaTQE6AVYOTmeAdMcrzmA4etidGMYLklbE1wSFuph/Wikebd9cuj4irpk9li4+PQByfvgLnObBvy75hZp/QPYCcjUZKocrAlJuxxtQN+E1VLzgbhF9ZTGzx5A8dTM0eQZO0AsK/DifdtK+2dT6H66nNI4BH1L+QtBhDq0g==,sdocumentreference:SETP990000957,rtaxxadocument:207759252,sref:SETP990000957,irefindex:990000957},sdebug:Taxxa: 0.446s DIAN: 1.165s (creación 0.619s, revalidación 0.546s baja 0s)}', 47781, '2'),
(1966, '2025-04-05 12:18:25', '{\r\n      \"sToken\":\"774855597565\",\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-03-03 07:43:17\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 958,\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\":\"1564561\"\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: 47806\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622749\",\r\n                  \"scustomname\":\"SALCHICHA ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":3000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622750\",\r\n                  \"scustomname\":\"SALCHICHA ADICIONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":3000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47806, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1967, '2025-04-05 12:18:25', '{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:93117a893b35f57938b4030b6cef874c9e705a4606c805e776e5f8dd71a2b32b3093c4f3735986bf7e9922d175da9a18,sqr:SETP990000958 2025-03-03 17:18:26-05:00 901402281 1564561 6000.00 0.00 0.00 6000.00 93117a893b35f57938b4030b6cef874c9e705a4606c805e776e5f8dd71a2b32b3093c4f3735986bf7e9922d175da9a18 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=93117a893b35f57938b4030b6cef874c9e705a4606c805e776e5f8dd71a2b32b3093c4f3735986bf7e9922d175da9a18,ssignature:co9ahT/jE+2Nt5gZn6nI3grfWo7E2NZJFTSEz66fCtP9NtuszvUGC9PKKULlw7zMDw4cZZoyaopU1iDmn+GQfZWFGGnMEAGNu+OE/0DHAb+RYcTX/pdYpCb/PnZ4Me/0dFbKhyQYImlHWOhlkcfw74Wu8K8B6F22eiNGdWN+znGcZfP961VpcvOv8+Xv0e5nVMVR8JMqSVrqCzXkcHEMnogRIKbJzgAbHcYWtyqv1yDwPGVaWCkQ/adLCqq+6tvqEw/q+7oVOGUEjE4nDFxrZrrG8/ybkcmjgtUQ2OdiPO7mHAKD0IXLAdyGQEvdHLOOH51SQTI+nSM8nw7uenyzpQ==,sdocumentreference:SETP990000958,rtaxxadocument:207759317,sref:SETP990000958,irefindex:990000958},sdebug:Taxxa: 0.373s DIAN: 1.518s (creación 0.878s, revalidación 0.64s baja 0s)}', 47806, '2'),
(1968, '2025-04-05 12:18:33', '{\r\n      \"sToken\":\"774855597565\",\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-02 11:52:13\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 959,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\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: 47835\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622809\",\r\n                  \"scustomname\":\"BURGER ESPECIAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":3 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622810\",\r\n                  \"scustomname\":\"BURGER ESPECIAL MIXTA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":26000,\r\n                  \"icount\":2 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622811\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622813\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00622814\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6500,\r\n                  \"icount\":1 \r\n               },\"6\":{\r\n                  \"sStandardItemIdentification\":\"00622815\",\r\n                  \"scustomname\":\"BURGER MIXTA SIN ACOMPAÑANTE\",\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\",\r\n                    \"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   ', 47835, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1969, '2025-04-05 12:18:33', '{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:9cf3d236e3f6fa8059877921058000c3381755d55a9328bbe7e77df865d7f30ca3164574b43a731bd54bd3e5a8bd018c,sqr:SETP990000959 2025-04-02 17:18:34-05:00 901402281 222222222222 188500.00 0.00 0.00 188500.00 9cf3d236e3f6fa8059877921058000c3381755d55a9328bbe7e77df865d7f30ca3164574b43a731bd54bd3e5a8bd018c https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=9cf3d236e3f6fa8059877921058000c3381755d55a9328bbe7e77df865d7f30ca3164574b43a731bd54bd3e5a8bd018c,ssignature:DvlboSqldIQnk6L7wQ6hRGoGe3RD/po4lf8Wg6byOJWCUT1ODC1nBUzi3mBppEnFXGRrejiVbY5obCUpM7xJdTIXq2vcUHHdMWIcTlzYn2ZppFJaXE4oqbgGDwUsnFtHTHB2l4VkSPi96b+8vTekxqMhjpbLup2FOZb/ZeZMsZJCAEEuCXZ4900rkkLzIRwWi8LxKeU1UuqaPb4hnRryifBe6bhjbp4Uw8fC9pdhTBZ7utrr31d5rfnbX7SGke4HshLwnVLTOYvxu20sy1UE0q56aVARHOTie3fo+r6rWv88EX0ADmsKoJBSgaWodrXyOC1cRFGtnKyB3XYIdPLpBQ==,sdocumentreference:SETP990000959,rtaxxadocument:207759421,sref:SETP990000959,irefindex:990000959},sdebug:Taxxa: 0.73s DIAN: 1.256s (creación 0.662s, revalidación 0.594s baja 0s)}', 47835, '2'),
(1970, '2025-04-05 12:18:47', '{\r\n      \"sToken\":\"774855597565\",\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-03-06 04:12:02\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 960,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"O-23\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"JULIANA  QUICENO \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"JULIANA  QUICENO \",\r\n                     \"selectronicmail\":\"adfsadf6@sfasdf.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\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47808\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622753\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47808, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1971, '2025-04-05 12:18:47', '{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:4c2d07d88859bfae1a9683ed733231b8ecbe846f249dd2d242fffe1a742921add1f75c5eccaf7bf548208d165e6f52f1,sqr:SETP990000960 2025-03-06 17:18:48-05:00 901402281 1564561 6000.00 0.00 0.00 6000.00 4c2d07d88859bfae1a9683ed733231b8ecbe846f249dd2d242fffe1a742921add1f75c5eccaf7bf548208d165e6f52f1 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=4c2d07d88859bfae1a9683ed733231b8ecbe846f249dd2d242fffe1a742921add1f75c5eccaf7bf548208d165e6f52f1,ssignature:RYAoP9cQRtOtYEh21CkPzrn4DE7DM6I8vtoHCbZBc7T/CkYJzGupbSJdvO6AwW6+YRjxaZqGPZtMyVMc+Uf2r9nweh+3Xbgto85Bxtm8IZwhsyc9qppa2ZH/6Z7d9Syrc1R/anXF0mYT+uXtxzWmKP1Ufypgajo2p8KDtK6XFE1k+/oJo8I4PvLFikG05W/K6uHo5l8O3MdhXxe655YobtFwMiaib5qMhfDSIBzSIQUksahMj96KReTPtZg+j1FbvXd70rdBQh8UpuKPOkovJSs8O1j/gjIDUNOZ1fnGgxZN/Vy2gugE+7JgGK0VohqhRFIZE4mRxZxZ5gbMcd0cFA==,sdocumentreference:SETP990000960,rtaxxadocument:207759570,sref:SETP990000960,irefindex:990000960},sdebug:Taxxa: 0.319s DIAN: 1.246s (creación 0.662s, revalidación 0.583s baja 0s)}', 47808, '2'),
(1972, '2025-04-05 12:19:27', '{\r\n      \"sToken\":\"774855597565\",\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-03-18 09:40:52\",\r\n               \"tduedate\":\"2025-04-18\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 961,\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\":\"raulo otalvaro   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"raulo otalvaro   \",\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\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47809\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622754\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622755\",\r\n                  \"scustomname\":\"CARNE, PAPA, AREPA, TOMATE\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":20500,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47809, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1973, '2025-04-05 12:19: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:eb95609a0840d29b9573d4c3935d332d768b6394512ccce36995d9a4f393ef746a245cb73eefbfcea57b1edd5f2a7d17,sqr:SETP990000961 2025-03-18 17:19:28-05:00 901402281 1564561 26500.00 0.00 0.00 26500.00 eb95609a0840d29b9573d4c3935d332d768b6394512ccce36995d9a4f393ef746a245cb73eefbfcea57b1edd5f2a7d17 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=eb95609a0840d29b9573d4c3935d332d768b6394512ccce36995d9a4f393ef746a245cb73eefbfcea57b1edd5f2a7d17,ssignature:HnppsYxuU/z1ag3Qtk0iiI1beUtRY/TVp9YrNEolrzGUuwgUehvhUvRyhZ7Mb2gRZ9yhhs5UbeN02C4CYQj8JDvxHBtTjP7of2PO6KgAdXUQ8TEyzJYI0ERmQN8qYkrENKRmHZL/dO/+25cTwjm5dlIR0r+e0k8jvaVq+1DUGxdVOjrX0UUNzYSYRQwRFiB3TFxCRmSTU9gfcmJzeO6Kcu7JDp7pmMjDRN2Jn0+6RSjuk1L/s8Exlwbk1IjSHgSsTFXFYtw7zPULf5vCWxxNoF0xpEWiUZuzzjvE4OymXKM8D4HWF0bqdwTcPgI/pY+V8p66dG+2oD+c2+OICqC6pA==,sdocumentreference:SETP990000961,rtaxxadocument:207760068,sref:SETP990000961,irefindex:990000961},sdebug:Taxxa: 0.931s DIAN: 6.411s (creación 1.392s, revalidación 5.019s baja 0s)}', 47809, '2'),
(1974, '2025-04-05 12:22:37', '{\r\n      \"sToken\":\"774855597565\",\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-03-18 14:45:18\",\r\n               \"tduedate\":\"2025-04-05\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 962,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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: 47811\"\r\n                ,\"aallowancecharge\": {\r\n            \"0\": {\r\n                  \"schargeindicator\": \"true\",\r\n                  \"sallowancechargereason\": \"Propina\",\r\n                  \"sallowancechargereasoncode\": \"04\",\r\n                  \"smultiplierfactornumeric\": \"5\",\r\n                  \"namount\": 2000,\r\n                  \"nbaseamount\": 41000\r\n            }\r\n         },\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622758\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":23000,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622761\",\r\n                  \"scustomname\":\"COCACOLA 192ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":5000,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622762\",\r\n                  \"scustomname\":\"COCACOLA 192ml\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":5000,\r\n                  \"icount\":1 \r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622763\",\r\n                  \"scustomname\":\"LIMONADA DE COCO\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":8000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47811, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1975, '2025-04-05 12:22:37', '{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:33d860dccd34e302e502c6799c24595ec3889418bab54e7d3d307325ae39dc3992d3839707994a836c82ef73f676f9fa,sqr:SETP990000962 2025-03-18 17:22:37-05:00 901402281 26234123412400 41000.00 0.00 0.00 43000.00 33d860dccd34e302e502c6799c24595ec3889418bab54e7d3d307325ae39dc3992d3839707994a836c82ef73f676f9fa https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=33d860dccd34e302e502c6799c24595ec3889418bab54e7d3d307325ae39dc3992d3839707994a836c82ef73f676f9fa,ssignature:FZX3NF4MpCtfzP88fBdygXklsLSehcmGIGKcsCCkFS87/ZIeqvz/Inz07/Bcyp6tVNE8LLv4bC9U2xBqTzeu5oZg8y26orSCVdS0qa7eqwTtDOErJrv2MM5G2zdKsRD4KRqLXmSYtWkrXDgln5ITFSxK8hpgizq1EVlnNT0gDFFvZ1xXEiopw35j2/xkE+HdaGgVsRaLfzsKW5obi6I35MhUtn9TTqSGH+aOplYY9MT3zsxHqdcmTR6bsjyfZ9lXcDUN5jyogxohm0TXWHCGtk72SLgIr/lSSBxVeOOyuig1LvivxdDLDH5E/gdDrS0mLXKideMswu3YjoDm2LvI0g==,sdocumentreference:SETP990000962,rtaxxadocument:207762252,sref:SETP990000962,irefindex:990000962},sdebug:Taxxa: 0.629s DIAN: 1.542s (creación 1.002s, revalidación 0.54s baja 0s)}', 47811, '2'),
(1976, '2025-04-08 10:34:33', '{\r\n      \"sToken\":\"774855597565\",\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-08 10:34:33\",\r\n               \"tduedate\":\"2025-04-15\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 963,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\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: 47843\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622844\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":18000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47843, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1977, '2025-04-08 10:34:33', '{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:35e69c1106ec5d6f71be96b55ddf4c0be24a2a36267353a5c9ca3997b3589615736c603b9b01334b45a0a1c8b40e3935,sqr:SETP990000963 2025-04-08 15:34:34-05:00 901402281 222222222222 18000.00 0.00 0.00 18000.00 35e69c1106ec5d6f71be96b55ddf4c0be24a2a36267353a5c9ca3997b3589615736c603b9b01334b45a0a1c8b40e3935 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=35e69c1106ec5d6f71be96b55ddf4c0be24a2a36267353a5c9ca3997b3589615736c603b9b01334b45a0a1c8b40e3935,ssignature:O41RBGfUKA8TJFwwBdkKTDcVK2Wx2+8BBn8VPpqo3XBmoK/aY1Mu+7OnGDCnLXWhmmlWScLRGd0GWONQwf+/PEUJzDl8HY1EYRdtPDrSQhrkcBkKuMYfjZWahqfjHPqChmNwwewTMXddehc8WInhW0GDIWppxhYY4Xp1EHaBJFQTofq4F0ePjMpID7d7wLQ96m/h6x+S52izIJV1ZbehTZarnAeNjP7tMfjB2LvY5Y6CvLG4o7KmIKW/orU5I5qJlMnGGWK7KYIFrexFpJ/i7+BzGWT9OV67dAfok84FL7htz5cc+qlQoIMTH3bgVrnAjTqAm2n30CQxgLTAeYDW5g==,sdocumentreference:SETP990000963,rtaxxadocument:209148908,sref:SETP990000963,irefindex:990000963},sdebug:Taxxa: 0.536s DIAN: 1.476s (creación 1.133s, revalidación 0.343s baja 0s)}', 47843, '2'),
(1978, '2025-04-08 18:30:49', '{\r\n      \"sToken\":\"774855597565\",\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-08 18:30:49\",\r\n               \"tduedate\":\"2025-04-15\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 964,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"fasdfasdfasdfasd asd fasdf\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"98984584\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"fasdfasdfasdfasd asd fasd   \",\r\n                     \"selectronicmail\":\"asdfjadsf@sahsd.com\",\r\n                     \"stelephone\":\"2315423452345\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"54\",\r\n                        \"wtowncode\":\"54001\",\r\n                        \"scityname\":\"CUCUTA\",\r\n                        \"saddressline1\":\"asd fasdf asdf asdfga\",\r\n                        \"szip\":\"540011\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47844\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622845\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7742,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622846\",\r\n                  \"scustomname\":\"BURGER NORMALITA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":22540,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622849\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7742,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47844, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1979, '2025-04-08 18:30:49', '{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:5e29c92eaaec277af5b1784fdd9bd8615c38e0662a2ef6ef15d2cffd7bf9b158c754e0837f5ff9365b7d5104a97179ec,sqr:SETP990000964 2025-04-08 23:30:50-05:00 901402281 98984584 38024.00 0.00 0.00 38024.00 5e29c92eaaec277af5b1784fdd9bd8615c38e0662a2ef6ef15d2cffd7bf9b158c754e0837f5ff9365b7d5104a97179ec https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=5e29c92eaaec277af5b1784fdd9bd8615c38e0662a2ef6ef15d2cffd7bf9b158c754e0837f5ff9365b7d5104a97179ec,ssignature:DTDQrQIuxj7ecqxUe4Ftcp1i9+vFzB1ryrsTKsCzkDArpInZM5U+yKTlaDk/p3mPSASi0hPgmNodfI8WF8ghoGq6AWNQj2klqX/4pHHUoNMTvMbXpI3W1rH78/duLTB7E7Ei5PZ80iWE1K5TDppgPD2AozbswLpgeQRPnlEjsDKKV9u8AkpFsU6ocNKAuqF9eCGlrmUZr3Y/VrywCO04zo8zZlZiUNnm+1i0nr8ANzeNTyPBhO7oyB5HwxAu8l+jWvqp2XNpFHMs3c6CNc55Qv6kTqXp8KxmhGUvcpQl7NpVQaIYU8qoaQZOHoKySL/PINqIWQmRywdXWtmQdGtd1g==,sdocumentreference:SETP990000964,rtaxxadocument:209433687,sref:SETP990000964,irefindex:990000964},sdebug:Taxxa: 1.244s DIAN: 2.283s (creación 0.982s, revalidación 1.301s baja 0s)}', 47844, '2'),
(1980, '2025-04-08 18:31:21', '{\r\n      \"sToken\":\"774855597565\",\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-08 18:31:21\",\r\n               \"tduedate\":\"2025-04-15\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 965,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\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: 47845\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622852\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7900,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622853\",\r\n                  \"scustomname\":\"Lampara de techo Panel Cuadradad  LED AT45 superpuesta\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":16500,\r\n                  \"icount\":1 \r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622854\",\r\n                  \"scustomname\":\"Lampara techo Led 5T B34\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":12300,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47845, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1981, '2025-04-08 18:31:21', '{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:429ed30edfe11f1604f05e70e0a4f4b8da070901fc3dd155ad3e090342256d0b609b4d0b6f2a8873408e0034d12ccc81,sqr:SETP990000965 2025-04-08 23:31:23-05:00 901402281 222222222222 36700.00 0.00 0.00 36700.00 429ed30edfe11f1604f05e70e0a4f4b8da070901fc3dd155ad3e090342256d0b609b4d0b6f2a8873408e0034d12ccc81 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=429ed30edfe11f1604f05e70e0a4f4b8da070901fc3dd155ad3e090342256d0b609b4d0b6f2a8873408e0034d12ccc81,ssignature:gnXAvu16ge4qkkmlLKeuJgt84NFbpClZomsXca7cwPwmgLDdKKmkRZ5UiXwSIvSGz0GQB9OI+YMKi/BmgK2FIEOXlBE0d0GDyKx95h+aVA/nNvBw0OCYi7nq8Be5SayNX14PRicyktcLAs1LylFOhlsl7PPitBFJvux/w6Xt9gdyyUDb4T45ssg5ouLduwqFz2+FG9HL47J9+j/iM/ny3My+kKK860pTr/ZGCtp+mx3Kz0Fh2qjjcM875LNt/ezieL218ILiGj9i3bKcaYaNYJ5A/FGW8nOwcsqJUnf1OT/Sn/q/n5MBLaXr2MiSSTBi1kgUnidfJaV7Gy/1jVPO3w==,sdocumentreference:SETP990000965,rtaxxadocument:209433990,sref:SETP990000965,irefindex:990000965},sdebug:Taxxa: 0.782s DIAN: 1.576s (creación 1.007s, revalidación 0.569s baja 0s)}', 47845, '2'),
(1982, '2025-04-09 15:21:32', '{\r\n      \"sToken\":\"774855597565\",\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-03-18 09:44:11\",\r\n               \"tduedate\":\"2025-04-09\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 966,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":2,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"sfiscalresponsibilities\":\"O-23\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"NIT\",\r\n                     \"sdocno\":\"1564561\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"adfsadf6@sfasdf.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\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47810\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622757\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47810, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1983, '2025-04-09 15:21:32', '{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:400fb29a939ff748cfacbd45e6c42d317fdf9e393143e9569d2544dfe75f2a0bba2574589db0a4e820da1f1963ff0538,sqr:SETP990000966 2025-03-18 20:21:33-05:00 901402281 1564561 6000.00 0.00 0.00 6000.00 400fb29a939ff748cfacbd45e6c42d317fdf9e393143e9569d2544dfe75f2a0bba2574589db0a4e820da1f1963ff0538 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=400fb29a939ff748cfacbd45e6c42d317fdf9e393143e9569d2544dfe75f2a0bba2574589db0a4e820da1f1963ff0538,ssignature:hu51m23jiWBTGhtbgdPd0Tx/BP4zF7GAe5bsFRZGXfYsap3Kt/KbU3ihzk+ht7ourkFktz1PUnc5XQv1ay9LDsJXzieuPEH/JUEpD/r1B5Nw1aBRMeZwNw8sOwLliSJk5jwoKGPYS6iwrc74AmEnxQKnoloolltZBNHQkuiVjdSZr60ODFHM2VYP8o1/SBtvD1xKPlSr5H1LW1JK1amaR7AypOiSlhdX2jCsiVWiD1NCu7HYvtwHXVmA9GcQU9H4FNxgr/yqnYX2N+42hUs3+smDV8i4yVP4xQbxUe31wJN3CibDVDdkrEpwSxu9JT746VUVF6Iv45EnaQOiBaxAEQ==,sdocumentreference:SETP990000966,rtaxxadocument:209805502,sref:SETP990000966,irefindex:990000966},sdebug:Taxxa: 0.543s DIAN: 1.728s (creación 1.004s, revalidación 0.724s baja 0s)}', 47810, '2'),
(1984, '2025-04-09 19:03:20', '{\r\n      \"sToken\":\"774855597565\",\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-09 19:03:20\",\r\n               \"tduedate\":\"2025-04-09\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 967,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\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: 47850\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622861\",\r\n                  \"scustomname\":\"CHORIZO X5\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":18000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47850, '2'),
(1985, '2025-04-09 19:03:20', '{rerror:1262,wdianscenario:Internal Server Error,smessage:Factura registrada, pendiente respuesta de la Dian, favor imprima su documento y continue su proceso de facturación. Sistema de la DIAN esta en contingencia y/o presenta intermitencia. ,jret:{yapprovedbytaxoffice:C,scufe:df7e0569534acf6fff6fbaedddad438209aec88cdd546943b7dd30a4caafa0a4a9057f422ad2331fa91d9d29d8eaaa5b,sqr:SETP990000967 2025-04-09 00:03:21-05:00 901402281 222222222222 18000.00 0.00 0.00 18000.00 df7e0569534acf6fff6fbaedddad438209aec88cdd546943b7dd30a4caafa0a4a9057f422ad2331fa91d9d29d8eaaa5b https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=df7e0569534acf6fff6fbaedddad438209aec88cdd546943b7dd30a4caafa0a4a9057f422ad2331fa91d9d29d8eaaa5b,ssignature:bKcPD6SD99Eoluzuc8MS+lVKFDmvzMvDZnc4C5mmAdY7OVxxnH0/rdazthvHWPEvcYKmT8bi7P5vfCvx4/L72o4sXiHbreaMvJHXNXs7bDq6WratVU2gH5e7RAuIr6NPFbSTNqAgsOqXGijVKSxxyICKUf5+Z9dn35nv1gEayYotxSaX8G0PNGNyGJDLZczh9MmR3IqO15LkTyJAxxftRXvRc7GB8uvJda1BUwfgDSx0iXQtWLthHne5OXym4uKPGBBOKUUmzfVWbgqaEKtGiqdRCRPR9pRirvrDG4QXy5OMgfabHmVrqlSvKf491Iy8ZeuigEqLIL9mvvnvaEA8sA==,sdocumentreference:SETP990000967,rtaxxadocument:210074361,sref:SETP990000967,irefindex:990000967},sdebug:Taxxa: 0.355s DIAN: 0.74s (creación 0.74s, revalidación 0s baja 0s)}', 47850, '2'),
(1986, '2025-04-09 19:05:36', '{\r\n      \"sToken\":\"774855597565\",\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-03 17:20:32\",\r\n               \"tduedate\":\"2025-04-09\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 968,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"\", \r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\" 123\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"66\",\r\n                        \"wtowncode\":\"66001\",\r\n                        \"scityname\":\"PEREIRA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"660001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47837\"\r\n                ,\"aallowancecharge\": {\r\n            \"1\": {\r\n                  \"schargeindicator\": \"true\",\r\n                  \"sallowancechargereason\": \"Domicilio\",\r\n                  \"sallowancechargereasoncode\": \"05\",\r\n                  \"smultiplierfactornumeric\": \"12\",\r\n                  \"namount\": 3000,\r\n                  \"nbaseamount\": 25900\r\n            }\r\n         },\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622819\",\r\n                  \"scustomname\":\"ELECTROLIT\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7900,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622820\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":18000,\r\n                  \"icount\":1 \r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"FERRE COSTOS LA 14\",\r\n                    \"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   ', 47837, '2'),
(1987, '2025-04-09 19:05:36', '{rerror:1262,wdianscenario:Internal Server Error,smessage:Factura registrada, pendiente respuesta de la Dian, favor imprima su documento y continue su proceso de facturación. Sistema de la DIAN esta en contingencia y/o presenta intermitencia. ,jret:{yapprovedbytaxoffice:C,scufe:bb00c53794b358038ac12c18e7fd2123e69779c15e661c53e3eb388046950d46d3a1ffc3547826752b693fdaf4c0f6ac,sqr:SETP990000968 2025-04-03 00:05:37-05:00 901402281 222222222222 25900.00 0.00 0.00 28900.00 bb00c53794b358038ac12c18e7fd2123e69779c15e661c53e3eb388046950d46d3a1ffc3547826752b693fdaf4c0f6ac https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=bb00c53794b358038ac12c18e7fd2123e69779c15e661c53e3eb388046950d46d3a1ffc3547826752b693fdaf4c0f6ac,ssignature:Q29Rjhh5lA0n2refjAnafKEuhP493Yuy73oVkxQK1iSpXo3uhqhBQ+m+NO/y0XWjsgWayLUsuGemOFoCU30/uPlxHNFRupifsRrH2xLaJlTtnWhwFC9iccr6ta8krrCBDqAQ0qKcozEt1ZlX7waFjhDxv7ZkuzZD/Rq2pmKTcUTtvQjnaE4R7em5jPBP4f1NdGCXsmj4rXsJ31vUDybNkWWPz1mmWBskn929w7xpCvHDHBAMWeOAiBjGFp+4157vEOg5lBY6nMVFMRPa4reSuQDnjxB3VyJJP3T72QhHMFYTwT61SI/QrVcEZlgu/4iOlv+Ee5B6AJBuO6bylgWJhQ==,sdocumentreference:SETP990000968,rtaxxadocument:210075570,sref:SETP990000968,irefindex:990000968},sdebug:Taxxa: 0.705s DIAN: 0.66s (creación 0.66s, revalidación 0s baja 0s)}', 47837, '2'),
(1988, '2025-04-10 13:07:33', '{\r\n      \"sToken\":\"774855597565\",\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-10 13:07:33\",\r\n               \"tduedate\":\"2025-04-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 969,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\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: 47851\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622862\",\r\n                  \"scustomname\":\"PICADA PERSONAL\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":25000,\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   ', 47851, '2'),
(1989, '2025-04-10 13:07:33', '{rerror:68,serrormessage:Expired session}', 47851, '2'),
(1990, '2025-04-10 13:07:33', 'La sesión expiró', 47851, '2'),
(1991, '2025-04-10 13:08:24', '{\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-10 13:08:24\",\r\n               \"tduedate\":\"2025-04-17\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 969,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\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: 47852\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622865\",\r\n                  \"scustomname\":\"FESTIVAL 2x1\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":18000,\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   ', 47852, '2');
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1992, '2025-04-10 13:08:24', '{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:8dbacf80b751e075b38865968a3f2ccb96326b55c8c7abef9bd8af7e808e09f0fd530a603b8756e991b0e6925fca6c67,sqr:SETP990000969 2025-04-10 18:08:25-05:00 901402281 222222222222 18000.00 0.00 0.00 18000.00 8dbacf80b751e075b38865968a3f2ccb96326b55c8c7abef9bd8af7e808e09f0fd530a603b8756e991b0e6925fca6c67 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=8dbacf80b751e075b38865968a3f2ccb96326b55c8c7abef9bd8af7e808e09f0fd530a603b8756e991b0e6925fca6c67,ssignature:SJ4V6r6+EmYimQfDBjBECzuwPdWW/vCTVYNMe/0RPujPkv/h2GLJaf1sO3Xo8ojJUkgqZKbYTib9IH9qTNv9jHh/zazVhrFUo0tQXEkMHTTZsTNd5oS99uyJlqJbpZoWXEgXmzkDA6am9MEUwpfEpmJuL+DF4jvWXFjddmXna7oALWwZMZhJTtAgSC5IHjFjGJWe5lKptvJmYvD8Lgm/tmSLVtbYCGuxaXEqxKvReoMZ50VLzhvNdPt57HFVlnMZiwr15OaKWeqIr2wa+D0UJG69bZgtCFwTmKlw4GyzR9fGJw/5RB9QEwC6/vo+ryDw20Pa6ZAoUWTTg6ZZ8jvHjA==,sdocumentreference:SETP990000969,rtaxxadocument:210333403,sref:SETP990000969,irefindex:990000969},sdebug:Taxxa: 0.277s DIAN: 1.129s (creación 0.73s, revalidación 0.399s baja 0s)}', 47852, '2'),
(1993, '2025-04-11 15:35: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\":\"2025-04-11 15:35:06\",\r\n               \"tduedate\":\"2025-04-18\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 970,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\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\":\"FN\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\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: 47853\"\r\n               ,\"jextrainfo\": {}, \r\n      \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622866\",\r\n                  \"scustomname\":\"BUDWEISER\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":7500,\r\n                  \"icount\":1 \r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622867\",\r\n                  \"scustomname\":\"COSTEÑA\",\r\n                  \"snotes\":\".\",\r\n                  \"nprice\":6000,\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   ', 47853, '2');
