INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1584, '2024-07-10 22:00:49', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"02c00d8e4c6884ada8d589d3b729bdd0d0fb3a6a990e727d3ab7239bf8fe9e9f7495d5e1ed7abb538006021311205b14\",\"sqr\":\"FEF2760 2024-07-10 22:00:53-05:00 19385248 222222222222 27777.78 0.00 2222.22 30000.00 02c00d8e4c6884ada8d589d3b729bdd0d0fb3a6a990e727d3ab7239bf8fe9e9f7495d5e1ed7abb538006021311205b14 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=02c00d8e4c6884ada8d589d3b729bdd0d0fb3a6a990e727d3ab7239bf8fe9e9f7495d5e1ed7abb538006021311205b14\",\"ssignature\":\"hTtcLbdwlo5TbVU+rUclo1FY+yNoNdo9shq0BrSHIunG9+1dUyBMdKW+9xr6z3vppxBE2SIV1fh/063qpyaHk94R5o4jleyhitsdg3iWflqFYJgL5cowUrxdpMvYoeKZO6rQc1yqySJWhOUc7hVvfJu0UXDcJM3lmBli0gUYrsMlIodkwvWnzATRAgkOThoETLEGqxC+9kczx5cFsE3s6kNmXH1YHtUlbj5OPzKgWcB/oh75c+FyPY7nXYtkgn2gVKsXLGNIhabU8YLJOBehNj6X8TGKytTlvzGXaTppxL84jAP9aFtiOnT4T80X5YSsLn+DxOBdM9SsDeH3WyRy6g==\",\"sdocumentreference\":\"FEF2760\",\"rtaxxadocument\":\"87908011\",\"sref\":\"87908011\",\"irefindex\":2760},\"sdebug\":\"Taxxa: 0.117s DIAN: 0.906s (creación 0.643s, revalidación 0.264s)\"}', 47645, NULL),
(1585, '2024-07-10 22:00:55', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-10\",\r\n               \"tduedate\":\"2024-07-17\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2761,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL   \",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL   \",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\" 3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47648\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622193\",\r\n                  \"scustomname\":\"CARNE, PAPA, AREPA, TOMATE\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":18981.481481481,\r\n                  \"icount\":2,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622195\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7222.2222222222,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622197\",\r\n                  \"scustomname\":\"JUGO NATURAL AGUA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":7222.2222222222,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"19385248\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47648, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1586, '2024-07-10 22:00:55', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"2\":\"Regla: FAJ44b, Notificación: Nit o Documento de Identificación informado No corresponde al registrado en el RUT con respecto a la razón social o nombre comercial suministrado.\",\"3\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"4\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"1608878ea47dca5cc0a2301f0f7e72b1a52a0abb47707c02bf1ed3e27c52bca06eef2d8c7202b2211a7cbb1afff9fbe0\",\"sqr\":\"FEF2761 2024-07-10 22:00:58-05:00 19385248 222222222222 52407.41 0.00 4192.60 56600.01 1608878ea47dca5cc0a2301f0f7e72b1a52a0abb47707c02bf1ed3e27c52bca06eef2d8c7202b2211a7cbb1afff9fbe0 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=1608878ea47dca5cc0a2301f0f7e72b1a52a0abb47707c02bf1ed3e27c52bca06eef2d8c7202b2211a7cbb1afff9fbe0\",\"ssignature\":\"gjFsmqhJY5syvyTNS+60BXNQg1rpdVDkDvv7xJ0YlZaxXQK4RP/kGrCDTWlz7WVjo3CLmdw+vq2Jf9/92qgyzzkcgZBW2g8HCXdx0KC0YLAaX86pLbihczTV3KdQQcAnBTPbEvT1NPDaw+InEgnVp5TfizM8aSrkXMiavb7JFPjCzDbNCJj+fGjn1ehuLQ4qvi8zOO0OnPH12lY/rVDG0KHnQOh6LKhwXf5KUW+m4mCSxCv8PILB/aE+8Ox+Dx4dhhJ3FV5HSTHb5ZHui5bR1IdjQTmdUuhnrcSNqKDMg5IJPshtMl+kDkPeRtYNTmkxffW9WK8jNndLpYJmnuotPw==\",\"sdocumentreference\":\"FEF2761\",\"rtaxxadocument\":\"87908034\",\"sref\":\"87908034\",\"irefindex\":2761},\"sdebug\":\"Taxxa: 0.125s DIAN: 1.045s (creación 0.729s, revalidación 0.316s)\"}', 47648, NULL),
(1587, '2024-07-12 17:26:05', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2762,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47657\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622280\",\r\n                  \"scustomname\":\"EJECUTIVO LUNES\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47657, NULL),
(1588, '2024-07-12 17:26:05', '{\"rerror\":649,\"serrormessage\":\"Acceso restringido. Verifique dominio\"}', 47657, NULL),
(1589, '2024-07-12 17:33:56', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2762,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47658\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622287\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":60185.185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622289\",\r\n                  \"scustomname\":\"PICADA PERSONAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":23148.148148148,\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\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47658, NULL),
(1590, '2024-07-12 17:33:56', '{\"rerror\":649,\"serrormessage\":\"Acceso restringido. Verifique dominio\"}', 47658, NULL),
(1591, '2024-07-12 17:35:33', '{\r\n      \"sToken\":\"139643829862\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2762,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47659\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622294\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47659, NULL),
(1592, '2024-07-12 17:35:33', '{\"rerror\":649,\"serrormessage\":\"Acceso restringido. Verifique dominio\"}', 47659, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1593, '2024-07-12 17:36:42', '{\r\n      \"sToken\":\"696628881017\",\r\n      \"jApi\":{\r\n         \"sMethod\":\"classTaxxa.fjDocumentAdd\",\r\n         \"jParams\":{\r\n            \"wEnvironment\": \"prod\", \r\n            \"wVersionUBL\": 2.1,\r\n            \"jDocument\":{\r\n               \"wdocumenttype\":\"Invoice\",\r\n      \"rdocumenttemplate\":\"4477128\",\r\n               \"wcurrency\":\"COP\",\r\n               \"tissuedate\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"FEF\",\r\n            \"sDocumentSuffix\": 2762,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47660\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622297\",\r\n                  \"scustomname\":\"MINI CARNE 160gr\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":21296.296296296,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47660, NULL),
(1594, '2024-07-12 17:36:42', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAB10a, Rechazo: El prefijo de numeración no es igual al código de la sucursal correspondiente a este punto de facturación\",\"1\":\"Regla: FAD05e, Rechazo: Número de factura no existe para el número de autorización.\",\"2\":\"Regla: FAD06, Rechazo: Valor del CUFE no está calculado correctamente.\",\"3\":\"Regla: FAJ50, Notificación: El prefijo debe corresponder  al código de la sucursal de este punto de facturación\",\"4\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"5\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"6\":\"Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"N\",\"scufe\":\"\",\"sqr\":\"SETP990002762 2024-07-12 17:36:46-05:00 901402281 222222222222 21296.30 0.00 1703.70 23000.00 be0558057a8a315dccfd059d2f75d9c5dc1bf904cd451561f3c3003413122994939ce727722a1f5a4dea3562cf232140 https://catalogo-vpfe.dian.gov.co/document/searchqr?documentkey=be0558057a8a315dccfd059d2f75d9c5dc1bf904cd451561f3c3003413122994939ce727722a1f5a4dea3562cf232140\",\"ssignature\":\"IeEI4vW1uQqvpVY8rg8J0IBxBEKbZ51tSmCzu9CkWX1yySTcXjf0KyJsI6oZMswOnbW+iccxSKuRBeztSFxMuIYpbDcB+JnN+5Xf70UI/vCAuozfnwjinytxwX5/mzP+Uj7bra5o8mUgEK9adLGPc9KZZBCmfuNOj6RVupV1a2QSk+3pDXP3Nv4BmjJI58FL1UF6QaHdiB3YhosfgiP0xLfarIG2qkP/OBg/tQg9rsDA1+1WhUCiBRTVipuiR0/zwqq/9G7ZrDqz1H6FBsndFdvrKKnJxAJj8YYw6QsEkoRVdHxcmAI9riaBuGtKKyOcs7Sxw5jWaaEaAKGHyqQ3VQ==\",\"sdocumentreference\":\"SETP990002762\",\"rtaxxadocument\":\"88539413\",\"sref\":\"88539413\",\"irefindex\":990002762},\"sdebug\":\"Taxxa: 0.283s DIAN: 2.615s (creación 1.266s, revalidación 0.694s baja 0.655s)\"}Shutdown function executed...\r\narray(4) {\n  [\"type\"]=>\n  int(8192)\n  [\"message\"]=>\n  string(84) \"base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated\"\n  [\"file\"]=>\n  string(47) \"D:appprodprojectsTaxxaclassclassTaxxa.php\"\n  [\"line\"]=>\n  int(2739)\n}\n', 47660, NULL),
(1595, '2024-07-12 17:36:42', 'El servidor ha devuleto una respuesta inesperada, antes de volver a enviarla deberías revisar en la Dian', 47660, NULL),
(1596, '2024-07-12 17:41:57', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 99002070,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47661\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622300\",\r\n                  \"scustomname\":\"ARROZ PORCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3981.4814814815,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622301\",\r\n                  \"scustomname\":\"ARROZ PORCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3981.4814814815,\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\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47661, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1597, '2024-07-12 17:41:57', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAD05c, Rechazo: Número de factura : superior al final del rango de numeración otorgado\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"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\":\"SETP1089002070 2024-07-12 17:42:01-05:00 901402281 222222222222 7962.96 0.00 637.04 8600.00 29e488fd7c8d7de73f3d8b2f5fbc9121dfeffe7701e0957657b08571725b8336969597965605a76023d27006b89898c0 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=29e488fd7c8d7de73f3d8b2f5fbc9121dfeffe7701e0957657b08571725b8336969597965605a76023d27006b89898c0\",\"ssignature\":\"egaqtzdgPfY6PNU+50BbEjn9W95VnhElfAu+jSTb5/4gf0O65WuDuxN7H6RCPVYBFxydi+vzDSi9aBhZCAgKLLVzEnrwGsE//j93qKFVDgW5Zm084RbFaqHgd2zHcBSF5jKWLv/2YAYYrmvh0E7Sixn+Jpmcp2gryTi43Pgr97108ve7wwz7lidK8JfCgUWtABl0dqtWWNnSSm2j3VIl+jT6mXklKtrGSmBPOg25XipdSPyNqRttfS3E0CS8zcm5ZxFspB7Y7bnnq4D6TYP6YX2A6lRnEfqD+QAoVgdVmUpfRwkMrLgjyCgXI83o9olkG58RTWh/3huhwrgz8dLnlw==\",\"sdocumentreference\":\"SETP1089002070\",\"rtaxxadocument\":\"88541222\",\"sref\":\"88541222\",\"irefindex\":1089002070},\"sdebug\":\"Taxxa: 0.229s DIAN: 2.999s (creación 1.3s, revalidación 0.954s baja 0.745s)\"}Shutdown function executed...\r\narray(4) {\n  [\"type\"]=>\n  int(8192)\n  [\"message\"]=>\n  string(84) \"base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated\"\n  [\"file\"]=>\n  string(47) \"D:appprodprojectsTaxxaclassclassTaxxa.php\"\n  [\"line\"]=>\n  int(2739)\n}\n', 47661, NULL),
(1598, '2024-07-12 17:41:57', 'El servidor ha devuleto una respuesta inesperada, antes de volver a enviarla deberías revisar en la Dian', 47661, NULL),
(1599, '2024-07-12 17:52:36', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 99002070,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47662\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622303\",\r\n                  \"scustomname\":\"AREPA GRATINADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3703.7037037037,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622304\",\r\n                  \"scustomname\":\"ARROZ PORCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3981.4814814815,\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\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47662, NULL),
(1600, '2024-07-12 18:00:39', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 99002070,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47663\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622306\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":60185.185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622308\",\r\n                  \"scustomname\":\"PICADA PERSONAL\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":23148.148148148,\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\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47663, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1601, '2024-07-12 18:00:39', '{\"rerror\":1,\"smessage\":{\"string\":{\"0\":\"Regla: FAD05c, Rechazo: Número de factura : superior al final del rango de numeración otorgado\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"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\":\"SETP1089002070 2024-07-12 18:00:43-05:00 901402281 222222222222 83333.33 0.00 6666.66 89999.99 dd4202955be589aab23bde6645795cb94ab12e6ec7bd75e9489912ae64e8a49e20cbf73a76c8891e179ab7d235c38f42 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=dd4202955be589aab23bde6645795cb94ab12e6ec7bd75e9489912ae64e8a49e20cbf73a76c8891e179ab7d235c38f42\",\"ssignature\":\"Cy9oX9/2luTEqiG/vbB1p4R3MMK9gxm58s2W4i7GBAp829hMdxZxvezcX4v9NCdoQJeUCzpfS1wy6myT5NDDHRI+TP3536nd+wDkGH+7PMtLD4nmPmSxRCye/0dGfxDjwcbH6ybAhzhmVu231tn14aoyyuTl83P13/I0Y5T9IDHm13srlcqVrpbmTxipj5xg57ZoYVBWWcaORTjFmEyWt0IcaZuusxBhndSR0TIemSlDzmuTblW/wvJWKpQszXtX3xDxPfcYPP6xfADBVYy2ZRyQIRfjFLNFfy6qZ4jwcvq0R7mVNccIxELKZ13elG1Jaqzj4VSlQlgThfo/VT2STw==\",\"sdocumentreference\":\"SETP1089002070\",\"rtaxxadocument\":\"88541222\",\"sref\":\"88541222\",\"irefindex\":1089002070},\"sdebug\":\"Taxxa: 0.349s DIAN: 9.555s (creación 7.563s, revalidación 1.208s baja 0.783s)\"}Shutdown function executed...\r\narray(4) {\n  [\"type\"]=>\n  int(8192)\n  [\"message\"]=>\n  string(84) \"base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated\"\n  [\"file\"]=>\n  string(47) \"D:appprodprojectsTaxxaclassclassTaxxa.php\"\n  [\"line\"]=>\n  int(2739)\n}\n', 47663, NULL),
(1602, '2024-07-12 18:00:39', 'El servidor ha devuleto una respuesta inesperada, antes de volver a enviarla deberías revisar en la Dian', 47663, NULL),
(1603, '2024-07-12 18:04:01', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 990002069,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47664\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622313\",\r\n                  \"scustomname\":\"AREPA GRATINADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3703.7037037037,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622314\",\r\n                  \"scustomname\":\"ARROZ PORCION\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":3981.4814814815,\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\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47664, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1604, '2024-07-12 18:04:01', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"51b0a225de9ef6718c158b416209e1d36f79d1d428b91fad6f5df87a98773a0ab5386318bf92b9df174ddb0aa59bf071\",\"sqr\":\"SETP990002069 2024-07-12 18:04:05-05:00 901402281 222222222222 7685.19 0.00 614.82 8300.01 51b0a225de9ef6718c158b416209e1d36f79d1d428b91fad6f5df87a98773a0ab5386318bf92b9df174ddb0aa59bf071 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=51b0a225de9ef6718c158b416209e1d36f79d1d428b91fad6f5df87a98773a0ab5386318bf92b9df174ddb0aa59bf071\",\"ssignature\":\"ElJAvYRhQWIAe36rizODYDREdZ+7pSZG+zJdI0Ioe+f/0QWRHkz5CDoZ9pKXDoJ6dTBl+8OOHOJUm0lUsntui6wcVjpvLlir0vY9LgGDEILaAtZ2OWMumq2b5OeCUURdMActE0LmbOI/0vE9B2zmK+tfBnX7PZqAXODFk4KQB14VqlQmteHIMWEmRLtrK2torcjjvB7NkXKyxkup+fPsFm0UzZWhGiI3UsdHbZZB/xnrV2n//q3+K+kuyvGvk20h87b7O6SNDnefYwkadb8Zz1RGzAkJg4fw4pJtJtY/30o2N6ory9QMUY12ZI/2liWwL+562dZScfaUos8UXMQLGQ==\",\"sdocumentreference\":\"SETP990002069\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990002069},\"sdebug\":\"Taxxa: 0.354s DIAN: 7.639s (creación 6.815s, revalidación 0s baja 0.823s)\"}', 47664, NULL),
(1605, '2024-07-12 18:05:12', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 990002070,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47665\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622316\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47665, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1606, '2024-07-12 18:05:12', '{\"rerror\":2,\"smessage\":{\"string\":\"Regla: 90, Rechazo: Documento procesado anteriormente.\"},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"D\",\"scufe\":\"dd5996b61bf0c36575b755b2bfa7e3e9c170b9f6786b4670bf28247e3d9fa19e32071bb30307f1485d1383883f703be4\",\"sqr\":\"SETP990002070 2024-07-12 18:05:16-05:00 901402281 222222222222 16203.70 0.00 1296.30 17500.00 dd5996b61bf0c36575b755b2bfa7e3e9c170b9f6786b4670bf28247e3d9fa19e32071bb30307f1485d1383883f703be4 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=dd5996b61bf0c36575b755b2bfa7e3e9c170b9f6786b4670bf28247e3d9fa19e32071bb30307f1485d1383883f703be4\",\"ssignature\":\"TJ4IpTQQ22JeafJMbrlcqmF/VKH6yOXbb+kvrLpZOMoC0X2T4vt0rLwdtHo7O4JzmvxujMWuf05kAU4cTecNeFuORidyAk1/gCSFGJCTNEC8gmY2yrPF7i4XZ5T8KUq+u51lCSFMMh6aSegg/1++I50XEfwYbPVL6G5r/wtruAY1/03PrmPP33TtmXZ7OJUFbnd8lwTerNjOhfnvP8orj5LXl+js0xHl+5/ib/TDyl9MZ5tNLiB8tSfbVqFW+NGuEnzZUXljNRgYNbQzhZfaroVqexP3ChdtkkSFnr+CR3R0jyZgCgsV+t4Ibf3Oj6OOz/1XRrSQmSmDJtukqSQdJQ==\",\"sdocumentreference\":\"SETP990002070\",\"rtaxxadocument\":null,\"sref\":null,\"irefindex\":990002070},\"sdebug\":\"Taxxa: 0.189s DIAN: 8.913s (creación 7.841s, revalidación 0s baja 1.072s)\"}', 47665, NULL),
(1607, '2024-07-12 18:05:54', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-12\",\r\n               \"tduedate\":\"2024-07-12\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 990002071,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                     \"stelephone\":\"3053033928\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"Cra 14  9-07\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47666\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622323\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":60185.185185185,\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\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"faurequiceno2008@hotmail.com\",\r\n                        \"stelephone\":\"3053033928\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47666, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1608, '2024-07-12 18:05:54', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"383f93fce8dc2f47c1f787666cb8266ac341d41951c88a03c18161b577e98c19f991395458fd299b8fd5b9d35628e05d\",\"sqr\":\"SETP990002071 2024-07-12 18:05:59-05:00 901402281 222222222222 60185.19 0.00 4814.81 65000.00 383f93fce8dc2f47c1f787666cb8266ac341d41951c88a03c18161b577e98c19f991395458fd299b8fd5b9d35628e05d https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=383f93fce8dc2f47c1f787666cb8266ac341d41951c88a03c18161b577e98c19f991395458fd299b8fd5b9d35628e05d\",\"ssignature\":\"p5j9qppT2t790xs3331X/Rq9iu5NUh49QHa5z+eRw4n/7ovtzVoE58Gc5OQIEdketSSlxB85IwJoLcygxyLCB/tKw9aQQUtiKcqB2aE1/aIjNtphX8NHyARBWh1kinUcOsA1uD6lwXfC3WfPsXvyqxdiuCjewA94cpvMkEdR6obMQErBNePDGqDhgPD5ldhtMJt8FeMkKFKw2+Bb1+DSFjdIBNRzZAQOFpxZCyjvTDbqFtuLfZXQeznrX9Xbwse52KZmRnNYx41mD8DTkhi2kUe6Z9k/oQt8agZJ03125FYnC3tQDGQLlGlF468QP6xLYK8c+wQVzHAeKWCGaijSvg==\",\"sdocumentreference\":\"SETP990002071\",\"rtaxxadocument\":\"88550436\",\"sref\":\"88550436\",\"irefindex\":990002071},\"sdebug\":\"Taxxa: 0.255s DIAN: 11.355s (creación 9.509s, revalidación 0.964s baja 0.883s)\"}', 47666, NULL),
(1609, '2024-07-16 11:16:11', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-16\",\r\n               \"tduedate\":\"2024-07-23\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 990002072,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"person\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"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: 47675\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622376\",\r\n                  \"scustomname\":\"PICADA FAMILIAR\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":60185.185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"2\":{\r\n                  \"sStandardItemIdentification\":\"00622377\",\r\n                  \"scustomname\":\"AGUA BRISA BOTELLA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":5555.5555555556,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"3\":{\r\n                  \"sStandardItemIdentification\":\"00622379\",\r\n                  \"scustomname\":\"ESCARCHADA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":2314.8148148148,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"4\":{\r\n                  \"sStandardItemIdentification\":\"00622380\",\r\n                  \"scustomname\":\"CLUB COLOMBIA\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6018.5185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               },\"5\":{\r\n                  \"sStandardItemIdentification\":\"00622381\",\r\n                  \"scustomname\":\"EJECUTIVO DOMINGO\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":16203.703703704,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"INC\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"TEXAS BURGERS\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"JOSE FAURE QUICENO MOLINA\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47675, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1610, '2024-07-16 11:16:11', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\"}},\"jret\":{\"sreturnedxml\":\"[BLOB]\",\"sdebug1\":\"[BLOB]\",\"yapprovedbytaxoffice\":\"Y\",\"scufe\":\"2b49298249fae724e35dae33ff31b87dc6c1f7f8652e9ee0db74a8fff1e18a1145b89f9af2cd584b94f26383930cbe16\",\"sqr\":\"SETP990002072 2024-07-16 11:16:12-05:00 901402281 222222222222 90277.78 0.00 7222.22 97500.00 2b49298249fae724e35dae33ff31b87dc6c1f7f8652e9ee0db74a8fff1e18a1145b89f9af2cd584b94f26383930cbe16 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=2b49298249fae724e35dae33ff31b87dc6c1f7f8652e9ee0db74a8fff1e18a1145b89f9af2cd584b94f26383930cbe16\",\"ssignature\":\"J1UXRv+mrsXyV2liGCRIzThAj0rF9DPdignGG5GEM+SSdLHKchk7tvQQ9Z22BhadO7ifeVUzYPCUwYeOOFjdO5ZHw/L76jxUYOdkLnOSTBZlbm0V7we2Ce9jQ164zMsSZ4A0iXL5a7B6CzzcYrQQvpORLA5ahX2zDYcGL4CwpbYvOlS8rMcZOMrDBWbvWQ1S6Tu8GYtXtkq8WSQq8/mvc+lv4VmR6xVjJ5651kiN4/lnjD7F5OgOmJD4WST+wyU17J4J+i8kQhFDzFHPhcU3H+uMipenm4Czx2lQXL/CqZCHlFWUXZyjR+hV3Vwyz5YhEpEcAcOadfvDyqCYCjQtgw==\",\"sdocumentreference\":\"SETP990002072\",\"rtaxxadocument\":\"89476014\",\"sref\":\"89476014\",\"irefindex\":990002072},\"sdebug\":\"Taxxa: 0.191s DIAN: 27.151s (creación 26.101s, revalidación 0.383s baja 0.668s)\"}', 47675, NULL),
(1611, '2024-07-16 14:39:52', '{\r\n      \"sToken\":\"696628881017\",\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\":\"2024-07-16\",\r\n               \"tduedate\":\"2024-07-16\",\r\n            \"sDocumentPrefix\":\"SETP\",\r\n            \"sDocumentSuffix\": 990002073,\r\n            \"wpaymentmethod\": \"10\",\r\n            \"wpaymentmeans\":1,\r\n            \"snotetop\":\"Cra 14  9-07\",\r\n               \"jbuyer\":{\r\n                  \"wlegalorganizationtype\":\"company\",\r\n                  \"stributaryidentificationkey\":\"01\",\r\n                  \"stributaryidentificationname\":\"IVA\",\r\n                  \"sfiscalresponsibilities\":\"R-99-PN\",\r\n                  \"sfiscalregime\":\"49\",\r\n                  \"scustomername\":\"CONSUMIDOR FINAL\",\r\n                  \"jpartylegalentity\":{\r\n                     \"wdoctype\":\"CC\",\r\n                     \"sdocno\":\"222222222222\"\r\n                  },\r\n                  \"jcontact\":{\r\n                     \"scontactperson\":\"CONSUMIDOR FINAL\",\r\n                     \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                     \"stelephone\":\" 9874704\",\r\n                     \"jregistrationaddress\":{\r\n                        \"scountrycode\":\"co\",\r\n                        \"wdepartmentcode\":\"63\",\r\n                        \"wtowncode\":\"63001\",\r\n                        \"scityname\":\"ARMENIA\",\r\n                        \"saddressline1\":\"\",\r\n                        \"szip\":\"630001\"\r\n                     }\r\n                  } \r\n               }, \r\n               \"snotes\":\" Id: 47674\"\r\n               ,\"jextrainfo\": {}, \r\n               \"jdocumentitems\":{\"1\":{\r\n                  \"sStandardItemIdentification\":\"00622375\",\r\n                  \"scustomname\":\"COCACOLA 400ml\",\r\n                  \"snotes\":\"\",\r\n                  \"nprice\":6018.5185185185,\r\n                  \"icount\":1,\r\n                    \"jtax\":{\r\n                   \"jinc\":{\r\n                      \"nrate\":8,\r\n                      \"sname\":\"IVA\"\r\n                   }\r\n                  }\r\n               }},\r\n                \"jseller\":{\r\n                    \"sdocid\":\"901402281\",\r\n                    \"sdoctype\":\"NIT\",\r\n                    \"ssellername\":\"Empresa de pruebas\",\r\n                    \"jcontact\":{\r\n                        \"scontactperson\":\"pepito perez\",\r\n                        \"selectronicmail\":\"raulotalvaro@gmail.com\",\r\n                        \"stelephone\":\"1234567890\",\r\n                        \"jregistrationaddress\":{\r\n                           \"wdepartmentcode\":\"63\",\r\n                           \"sdepartmentname\":\"QUINDIO\",\r\n                           \"wtowncode\":\"63001\",\r\n                           \"scityname\":\"ARMENIA\",\r\n                           \"saddressline1\":\"Cra 14  9-07\",\r\n                           \"scountrycode\":\"CO\",\r\n                           \"szip\":\"630001\",\r\n                           \"wprovincecode\":\"63001\"\r\n                        }\r\n                    }\r\n                }\r\n         }\r\n      }\r\n   }\r\n   }\r\n   ', 47674, NULL);
INSERT INTO `trazabilidad` (`id`, `fechacreacion`, `texto`, `idfactura`, `usuarioenvia`) VALUES
(1612, '2024-07-16 14:39:52', '{\"rerror\":0,\"smessage\":{\"string\":{\"0\":\"Regla: FAX14, Notificación: Reporta una tarifa diferente para uno de los tributos enunciados en la tabla 13.3.9\",\"1\":\"Regla: FAJ43b, Notificación: Nombre informado No corresponde al registrado en el RUT con respecto al Nit suminstrado.\",\"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\":\"Y\",\"scufe\":\"d2e021e1d469035d89f686e7eb582f6173f52a06caa44b644470c4bb6f0e9be244de25e68ec5407153a4e6a5da772ee4\",\"sqr\":\"SETP990002073 2024-07-16 14:39:53-05:00 901402281 222222222222 6018.52 481.48 0.00 6500.00 d2e021e1d469035d89f686e7eb582f6173f52a06caa44b644470c4bb6f0e9be244de25e68ec5407153a4e6a5da772ee4 https://catalogo-vpfe-hab.dian.gov.co/document/searchqr?documentkey=d2e021e1d469035d89f686e7eb582f6173f52a06caa44b644470c4bb6f0e9be244de25e68ec5407153a4e6a5da772ee4\",\"ssignature\":\"FK2hVmP2TS0BjMzoBzGifTjn5n6eRMszThxu8lU3FxSM6/i/hxCKJHJs45jKTOfjq4P0ae6ef73cPxnJKOVTKOKnsxPbPaW92bi1rz3Q1hpGN3mb9CiONiiAJrwU5LiJ2EoysOvEb03hLphQ//3P65oCJKKyg3N541wRxdYUyRSimT44d7PAOyMwCNVVlazzxhttsJeCoRPeP5BShYdUAXTnJrkNrSgLvc8KvSr8qYekutSDGVc/d4r4D4f/OACJ4f2iYxDz4S+7kmv9br815PoBJ2dmE+nHuGzj8ycX5g4cQWC7Hnzga5ac/6R8+r8PU2h7TBWiq9xFP1R9Y2l9DQ==\",\"sdocumentreference\":\"SETP990002073\",\"rtaxxadocument\":\"89536573\",\"sref\":\"89536573\",\"irefindex\":990002073},\"sdebug\":\"Taxxa: 0.139s DIAN: 5.446s (creación 4.505s, revalidación 0.58s baja 0.361s)\"}', 47674, NULL),
(1613, '2024-07-16 20:06:00', '{\n   \"sToken\":\"696628881017\",\n   \"jApi\":{\n      \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n      \"jParams\":{\n         \"wVersionUBL\":2.1,\n         \"wEnvironment\":\"test\",\n         \"jDocument\":{\n            \"wdocumenttype\":\"CreditNote\",\n            \"wdocumenttypecode\":\"91\",\n            \"woperationtype\": \"20\",\n            \"sdocsubtype\":\"2\",\n            \"wcurrency\": \"COP\",\n            \"sdocumentprefix\": \"SETP\",\n            \"tissuedate\":\"2024-07-16T20:06:00\",\n            \"tduedate\":\"2024-07-16\",\n            \"sdocumentsuffix\":\"99000207200001\",\n            \"spaymenttype\":\"1\" ,\"jdocumentitems\":{\"1\":{\n       \"scustomname\":\"PICADA FAMILIAR\",\n       \"snotes\":\"\",\n       \"nunitprice\":60185.18518518518,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622376\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"2\":{\n       \"scustomname\":\"AGUA BRISA BOTELLA\",\n       \"snotes\":\"\",\n       \"nunitprice\":5555.555555555555,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622377\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"3\":{\n       \"scustomname\":\"ESCARCHADA\",\n       \"snotes\":\"\",\n       \"nunitprice\":2314.814814814815,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622379\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"4\":{\n       \"scustomname\":\"CLUB COLOMBIA\",\n       \"snotes\":\"\",\n       \"nunitprice\":6018.518518518518,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622380\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"5\":{\n       \"scustomname\":\"EJECUTIVO DOMINGO\",\n       \"snotes\":\"\",\n       \"nunitprice\":16203.703703703703,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622381\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        } \n            },\n            \"spaymentmethod\":\"10\",\n            \"jbuyer\":{\n               \"wlegalorganizationtype\":\"person\",\n               \"stributaryidentificationkey\":\"ZZ\",\n               \"stributaryidentificationnam\":\"No aplica\",\n               \"sfiscalresponsibilities\":\"R-99-PN\",\n               \"sfiscalregime\":\"48\",\n               \"scustomername\":\"CONSUMIDOR FINAL\",\n               \"jpartylegalentity\":{\n                  \"wdoctype\":\"CC\",\n                  \"sdocno\":\"222222222222\"\n               },\n               \"jcontact\":{ \n                  \"scontactperson\":\"CONSUMIDOR FINAL\",\n                  \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                  \"stelephone\":\"1234567890\"\n               } },\n          \"jbillingreference\":{\n               \"sbillingreferenceid\":\"SETP990002072\",\n               \"sbillingreferenceissuedate\":\"2024-07-16\",\n               \"sbillingreferenceuuid\":\"2b49298249fae724e35dae33ff31b87dc6c1f7f8652e9ee0db74a8fff1e18a1145b89f9af2cd584b94f26383930cbe16\",\n               \"scufetoadjust\":\"SETP990002072\"\n            }, \n            \"jseller\":{\n                \"sdocid\":\"901402281\",\n                \"sdoctype\":\"NIT\",\n                \"ssellername\":\"Empresa de pruebas\",\n                \"scontactperson\":\"pepito perez\",\n                \"saddresszip\":\"630001\",\n                \"wdepartmentcode\":\"63\",\n                \"wtowncode \":\"63001\",\n                \"scityname\":\"ARMENIA\",\n                \"jcontact\":{\n                    \"scontactperson\":\"pepito perez\",\n                    \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                    \"stelephone\":\"1234567890\", \n                    \"jregistrationaddress\":{\n                       \"wdepartmentcode\":\"63\",\n                       \"sdepartmentname\":\"QUINDIO\",\n                       \"scityname\":\"ARMENIA\",\n                       \"saddressline1\":\"Cra 14  9-07\",\n                       \"scountrycode\":\"CO\",\n                       \"szip\":\"630001\",\n                       \"wprovincecode\":\"63001\"\n                    } \n                }\n            }\n         }\n      }\n   }\n    }\n    ', 47675, NULL),
(1614, '2024-07-16 20:08:31', '{\n   \"sToken\":\"696628881017\",\n   \"jApi\":{\n      \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n      \"jParams\":{\n         \"wVersionUBL\":2.1,\n         \"wEnvironment\":\"test\",\n         \"jDocument\":{\n            \"wdocumenttype\":\"CreditNote\",\n            \"wdocumenttypecode\":\"91\",\n            \"woperationtype\": \"20\",\n            \"sdocsubtype\":\"2\",\n            \"wcurrency\": \"COP\",\n            \"sdocumentprefix\": \"SETP\",\n            \"tissuedate\":\"2024-07-16T20:08:31\",\n            \"tduedate\":\"2024-07-16\",\n            \"sdocumentsuffix\":\"99000207200001\",\n            \"spaymenttype\":\"1\" ,\"jdocumentitems\":{\"1\":{\n       \"scustomname\":\"PICADA FAMILIAR\",\n       \"snotes\":\"\",\n       \"nunitprice\":60185.18518518518,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622376\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"2\":{\n       \"scustomname\":\"AGUA BRISA BOTELLA\",\n       \"snotes\":\"\",\n       \"nunitprice\":5555.555555555555,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622377\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"3\":{\n       \"scustomname\":\"ESCARCHADA\",\n       \"snotes\":\"\",\n       \"nunitprice\":2314.814814814815,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622379\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"4\":{\n       \"scustomname\":\"CLUB COLOMBIA\",\n       \"snotes\":\"\",\n       \"nunitprice\":6018.518518518518,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622380\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"5\":{\n       \"scustomname\":\"EJECUTIVO DOMINGO\",\n       \"snotes\":\"\",\n       \"nunitprice\":16203.703703703703,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622381\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        } \n            },\n            \"spaymentmethod\":\"10\",\n            \"jbuyer\":{\n               \"wlegalorganizationtype\":\"person\",\n               \"stributaryidentificationkey\":\"ZZ\",\n               \"stributaryidentificationnam\":\"No aplica\",\n               \"sfiscalresponsibilities\":\"R-99-PN\",\n               \"sfiscalregime\":\"48\",\n               \"scustomername\":\"CONSUMIDOR FINAL\",\n               \"jpartylegalentity\":{\n                  \"wdoctype\":\"CC\",\n                  \"sdocno\":\"222222222222\"\n               },\n               \"jcontact\":{ \n                  \"scontactperson\":\"CONSUMIDOR FINAL\",\n                  \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                  \"stelephone\":\"1234567890\"\n               } },\n          \"jbillingreference\":{\n               \"sbillingreferenceid\":\"SETP990002072\",\n               \"sbillingreferenceissuedate\":\"2024-07-16\",\n               \"sbillingreferenceuuid\":\"2b49298249fae724e35dae33ff31b87dc6c1f7f8652e9ee0db74a8fff1e18a1145b89f9af2cd584b94f26383930cbe16\",\n               \"scufetoadjust\":\"SETP990002072\"\n            }, \n            \"jseller\":{\n                \"sdocid\":\"901402281\",\n                \"sdoctype\":\"NIT\",\n                \"ssellername\":\"Empresa de pruebas\",\n                \"scontactperson\":\"pepito perez\",\n                \"saddresszip\":\"630001\",\n                \"wdepartmentcode\":\"63\",\n                \"wtowncode \":\"63001\",\n                \"scityname\":\"ARMENIA\",\n                \"jcontact\":{\n                    \"scontactperson\":\"pepito perez\",\n                    \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                    \"stelephone\":\"1234567890\", \n                    \"jregistrationaddress\":{\n                       \"wdepartmentcode\":\"63\",\n                       \"sdepartmentname\":\"QUINDIO\",\n                       \"scityname\":\"ARMENIA\",\n                       \"saddressline1\":\"Cra 14  9-07\",\n                       \"scountrycode\":\"CO\",\n                       \"szip\":\"630001\",\n                       \"wprovincecode\":\"63001\"\n                    } \n                }\n            }\n         }\n      }\n   }\n    }\n    ', 47675, NULL),
(1615, '2024-07-16 20:09:33', '{\n   \"sToken\":\"696628881017\",\n   \"jApi\":{\n      \"sMethod\":\"classTaxxa.fjDocumentAdd\",\n      \"jParams\":{\n         \"wVersionUBL\":2.1,\n         \"wEnvironment\":\"test\",\n         \"jDocument\":{\n            \"wdocumenttype\":\"CreditNote\",\n            \"wdocumenttypecode\":\"91\",\n            \"woperationtype\": \"20\",\n            \"sdocsubtype\":\"2\",\n            \"wcurrency\": \"COP\",\n            \"sdocumentprefix\": \"SETP\",\n            \"tissuedate\":\"2024-07-16T20:09:33\",\n            \"tduedate\":\"2024-07-16\",\n            \"sdocumentsuffix\":\"99000207200001\",\n            \"spaymenttype\":\"1\" ,\"jdocumentitems\":{\"1\":{\n       \"scustomname\":\"PICADA FAMILIAR\",\n       \"snotes\":\"\",\n       \"nunitprice\":60185.18518518518,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622376\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"2\":{\n       \"scustomname\":\"AGUA BRISA BOTELLA\",\n       \"snotes\":\"\",\n       \"nunitprice\":5555.555555555555,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622377\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"3\":{\n       \"scustomname\":\"ESCARCHADA\",\n       \"snotes\":\"\",\n       \"nunitprice\":2314.814814814815,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622379\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"4\":{\n       \"scustomname\":\"CLUB COLOMBIA\",\n       \"snotes\":\"\",\n       \"nunitprice\":6018.518518518518,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622380\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        },\"5\":{\n       \"scustomname\":\"EJECUTIVO DOMINGO\",\n       \"snotes\":\"\",\n       \"nunitprice\":16203.703703703703,\n       \"icount\":1,\n       \"sStandardItemIdentification\":\"00622381\",\"jtax\":{\n            \"jiva\":{\n               \"nrate\":8,\n              \"sname\":\"IVA\"\n            }\n         }\n        } \n            },\n            \"spaymentmethod\":\"10\",\n            \"jbuyer\":{\n               \"wlegalorganizationtype\":\"person\",\n               \"stributaryidentificationkey\":\"ZZ\",\n               \"stributaryidentificationnam\":\"No aplica\",\n               \"sfiscalresponsibilities\":\"R-99-PN\",\n               \"sfiscalregime\":\"48\",\n               \"scustomername\":\"CONSUMIDOR FINAL\",\n               \"jpartylegalentity\":{\n                  \"wdoctype\":\"CC\",\n                  \"sdocno\":\"222222222222\"\n               },\n               \"jcontact\":{ \n                  \"scontactperson\":\"CONSUMIDOR FINAL\",\n                  \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                  \"stelephone\":\"1234567890\"\n               } },\n          \"jbillingreference\":{\n               \"sbillingreferenceid\":\"SETP990002072\",\n               \"sbillingreferenceissuedate\":\"2024-07-16\",\n               \"sbillingreferenceuuid\":\"2b49298249fae724e35dae33ff31b87dc6c1f7f8652e9ee0db74a8fff1e18a1145b89f9af2cd584b94f26383930cbe16\",\n               \"scufetoadjust\":\"SETP990002072\"\n            }, \n            \"jseller\":{\n                \"sdocid\":\"901402281\",\n                \"sdoctype\":\"NIT\",\n                \"ssellername\":\"Empresa de pruebas\",\n                \"scontactperson\":\"pepito perez\",\n                \"saddresszip\":\"630001\",\n                \"wdepartmentcode\":\"63\",\n                \"wtowncode \":\"63001\",\n                \"scityname\":\"ARMENIA\",\n                \"jcontact\":{\n                    \"scontactperson\":\"pepito perez\",\n                    \"selectronicmail\":\"raulotalvaro@gmail.com\",\n                    \"stelephone\":\"1234567890\", \n                    \"jregistrationaddress\":{\n                       \"wdepartmentcode\":\"63\",\n                       \"sdepartmentname\":\"QUINDIO\",\n                       \"scityname\":\"ARMENIA\",\n                       \"saddressline1\":\"Cra 14  9-07\",\n                       \"scountrycode\":\"CO\",\n                       \"szip\":\"630001\",\n                       \"wprovincecode\":\"63001\"\n                    } \n                }\n            }\n         }\n      }\n   }\n    }\n    ', 47675, NULL);
