(40,'GBO081210H72','GRUPO BOSELCO S.A DE C.V.','d7f3b9b7-290e-4802-9dda-e2c3827bcf21',19952.000000,'2015-08-04 13:25:00','1.000000','Pesos','2016-05-25 09:51:55','IOL980901893','[encoded data, 7604 characters]','Advertencia','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCltNb250b3NdIEVycm9yIGRlIGPhbGN1bG86IEVsIHRvdGFsIGRlIGltcHVlc3RvcyB0cmFzbGFkYWRvcyBjYWxjdWxhZG86IDI3NTIgPD4gMCAodmFsb3IgZXhwcmVzYWRvIGVuIGVsIFhNTCk=','A','896'),(41,'GBO081210H72','GRUPO BOSELCO S.A DE C.V.','d7f3b9b7-290e-4802-9dda-e2c3827bcf21',19952.000000,'2015-08-04 13:25:00','1.000000','Pesos','2016-05-25 09:58:50','IOL980901893','[encoded data, 7604 characters]','Advertencia','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCltNb250b3NdIEVycm9yIGRlIGPhbGN1bG86IEVsIHRvdGFsIGRlIGltcHVlc3RvcyB0cmFzbGFkYWRvcyBjYWxjdWxhZG86IDI3NTIgPD4gMCAodmFsb3IgZXhwcmVzYWRvIGVuIGVsIFhNTCk=','A','896'),(42,'GBO081210H72','GRUPO BOSELCO S.A DE C.V.','d7f3b9b7-290e-4802-9dda-e2c3827bcf21',19952.000000,'2015-08-04 13:25:00','1.000000','Pesos','2016-05-25 09:58:57','IOL980901893','[encoded data, 7604 characters]','Advertencia','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCltNb250b3NdIEVycm9yIGRlIGPhbGN1bG86IEVsIHRvdGFsIGRlIGltcHVlc3RvcyB0cmFzbGFkYWRvcyBjYWxjdWxhZG86IDI3NTIgPD4gMCAodmFsb3IgZXhwcmVzYWRvIGVuIGVsIFhNTCk=','A','896'),(43,'GBO081210H72','GRUPO BOSELCO S.A DE C.V.','d7f3b9b7-290e-4802-9dda-e2c3827bcf21',19952.000000,'2015-08-04 13:25:00','1.000000','Pesos','2016-05-25 09:59:03','IOL980901893','[encoded data, 7604 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KRWwgcmVjZXB0b3IgeWEgbm8gY3VlbnRhIGNvbiBjculkaXRvcyBkaXNwb25pYmxlcyBjb21vIERFTU8sIGZhdm9yIGRlIGNvbXVuaWNhcnNlIGEgdmVudGFzQGRpc3hpaS5jb20u','A','896'),(44,'GBO081210H72','GRUPO BOSELCO S.A DE C.V.','d7f3b9b7-290e-4802-9dda-e2c3827bcf21',19952.000000,'2015-08-04 13:25:00','1.000000','Pesos','2016-05-25 10:13:42','IOL980901893','[encoded data, 7604 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KRWwgcmVjZXB0b3IgeWEgbm8gY3VlbnRhIGNvbiBjculkaXRvcyBkaXNwb25pYmxlcyBjb21vIERFTU8sIGZhdm9yIGRlIGNvbXVuaWNhcnNlIGEgdmVudGFzQGRpc3hpaS5jb20u','A','896'),(45,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','ad8808b0-40b6-4d59-9b8c-b779c990b48f',130917.600000,'2016-05-04 10:26:06','1.000000','MXN','2016-05-25 11:00:44','AOZ9903024A5','[encoded data, 11944 characters]','Rechazado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpEb2N1bWVudG8gVuFsaWRvJiMxMzsKW1NBVF0gQ2FuY2VsYWRv','FE','6098'),(46,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','ad8808b0-40b6-4d59-9b8c-b779c990b48f',130917.600000,'2016-05-04 10:26:06','1.000000','MXN','2016-05-25 12:08:24','AOZ9903024A5','[encoded data, 11944 characters]','Rechazado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpEb2N1bWVudG8gVuFsaWRvJiMxMzsKW1NBVF0gQ2FuY2VsYWRv','FE','6098'),(47,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','ad8808b0-40b6-4d59-9b8c-b779c990b48f',130917.600000,'2016-05-04 10:26:06','1.000000','MXN','2016-05-25 12:40:50','AOZ9903024A5','[encoded data, 11944 characters]','Aceptado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpEb2N1bWVudG8gduFsaWRvLg==','FE','6098'),(48,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-05-25 12:41:08','BF&831024CT0','PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPGNmZGk6Q29tcHJvYmFudGUgeG1sbnM6Y2ZkaT0iaHR0cDovL3d3dy5zYXQuZ29iLm14L2NmZC8zIiB4bWxuczp4c2k9Imh0dHA6Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hLWluc3RhbmNlIiB2ZXJzaW9uPSIzLjIiIHNlcmllPSJCIiBmb2xpbz0iOTk5MSIgZmVjaGE9IjIwMTUtMDgtMTBUMTE6MDY6NTciIHNlbGxvPSJFbFpieW9UUnhHd01hb2FjWE5mRjFFUm9tb2VFb3Y1NTBlSjdJZWR5ZzNxYlk2bW9KRVVTZnFTY2I5cmJXa21UUUFLbXl1TFpzakxlcjVuMTJ0cU1LSkg2QWR5dzhIMVVNTmtlQVl0eFBXL2FZUWFFVkRGSG1UaWhTbGNJa2FQSEVsZllQb0JucXhrUzlkcFdYL3Iva203UUZxRXFPTVB1RUZ2ZlY3UWhnSjQ9IiBmb3JtYURlUGFnbz0iUEFHTyBFTiBVTkEgU09MQSBFWEhJQklDScOTTiIgbm9DZXJ0aWZpY2Fkbz0iMDAwMDEwMDAwMDAyMDI1NzgzOTQiIGNlcnRpZmljYWRvPSJNSUlFaVRDQ0EzR2dBd0lCQWdJVU1EQXdNREV3TURBd01EQXlNREkxTnpnek9UUXdEUVlKS29aSWh2Y05BUUVGQlFBd2dnR1ZNVGd3TmdZRFZRUUREQzlCTGtNdUlHUmxiQ0JUWlhKMmFXTnBieUJrWlNCQlpHMXBibWx6ZEhKaFkybkRzMjRnVkhKcFluVjBZWEpwWVRFdk1DMEdBMVVFQ2d3bVUyVnlkbWxqYVc4Z1pHVWdRV1J0YVc1cGMzUnlZV05wdzdOdUlGUnlhV0oxZEdGeWFXRXhPREEyQmdOVkJBc01MMEZrYldsdWFYTjBjbUZqYWNPemJpQmtaU0JUWldkMWNtbGtZV1FnWkdVZ2JHRWdTVzVtYjNKdFlXTnB3N051TVNFd0h3WUpLb1pJaHZjTkFRa0JGaEpoYzJsemJtVjBRSE5oZEM1bmIySXViWGd4SmpBa0JnTlZCQWtNSFVGMkxpQklhV1JoYkdkdklEYzNMQ0JEYjJ3dUlFZDFaWEp5WlhKdk1RNHdEQVlEVlFRUkRBVXdOak13TURFTE1Ba0dBMVVFQmhNQ1RWZ3hHVEFYQmdOVkJBZ01FRVJwYzNSeWFYUnZJRVpsWkdWeVlXd3hGREFTQmdOVkJBY01DME4xWVhWb2RNT3BiVzlqTVJVd0V3WURWUVF0RXd4VFFWUTVOekEzTURGT1RqTXhQakE4QmdrcWhraUc5dzBCQ1FJTUwxSmxjM0J2Ym5OaFlteGxPaUJEWldOcGJHbGhJRWQxYVd4c1pYSnRhVzVoSUVkaGNtUERyV0VnUjNWbGNuSmhNQjRYRFRFeU1USXhNakF4TURReU4xb1hEVEUyTVRJeE1qQXhNRFF5TjFvd2djb3hKREFpQmdOVkJBTVRHMHhCUWs5U1FWUlBVa2xQVXlCQ1JVTkJVaUJUUVNCRVJTQkRWakVrTUNJR0ExVUVLUk1iVEVGQ1QxSkJWRTlTU1U5VElFSkZRMEZTSUZOQklFUkZJRU5XTVNRd0lnWURWUVFLRXh0TVFVSlBVa0ZVVDFKSlQxTWdRa1ZEUVZJZ1UwRWdSRVVnUTFZeEpUQWpCZ05WQkMwVEhFeENSVGc1TURreU5raE5RU0F2SUVOQlNFdzJNekEwTWpKVFVETXhIakFjQmdOVkJBVVRGU0F2SUVOQlNFdzJNekEwTWpKTlJFWk5VbEl3T1RFUE1BMEdBMVVFQ3hNR2RXNXBaR0ZrTUlHZk1BMEdDU3FHU0liM0RRRUJBUVVBQTRHTkFEQ0JpUUtCZ1FDelh6TnhmSDE1T2cxd1Z4Z1JCcDR2QjArYUNOaXZTOHZLcFpCSkRINTZJdUw0UjNBck9PWUFTTThHMTVQem8zTkxac1JoVWR3TXplU3l2dmgxQ2NTVDJjT3N4cXlTME0raHlSdmsxL1BYTXZZdmIxaUpTb0NVWnNhYU5OVExwOHR5ZzFhczExK2VCWWNHcUdyYWpKMTZmQldtR0JRc0l2Qkl1V3BDb3FITXFRSURBUUFCb3gwd0d6QU1CZ05WSFJNQkFmOEVBakFBTUFzR0ExVWREd1FFQXdJR3dEQU5CZ2txaGtpRzl3MEJBUVVGQUFPQ0FRRUFmdnU2Rlc1ZE45UDVhNnVuM045ZHBFWE9XS2JvcWdhUVF3ZFRUdDd0anFMeGFUdDVYU1VjZzNDVHI1Qy9RbjFpSHJQOVRLRDkvVm9Wdk9JR1ZMU0cxUjl4OHpQRWNWV1U3VzJBS1VCUDFBbTFDSFZ6ZjRCb2xHRXpsMldRRVNFWXcvRWFqSzM2cXFCT1dQQlc3SVBRcHliZTZ5TTJqMXpYZVVaR2wwNm5XSWVBYkp3UVY4M2dIek9RREpvY3IwMDZLR2JidzRsNkw2TjYvdnk5QktMZWs4QXBLeUpFdDc4bHJ2S1JOeFdLaUJwU3VOd2RFOUNnOWRERDVTbzZLSWUwd2NNaEpabFdMOHg0NWx0UmcybUg3TVZMdFRVSmRwTFJwc1QvRDF1S05ONkliYlRsM3E5dnFPVzVPRWxCa3pSYXc5bG5ndGFMZlZaTFdJYUVPZjcvbFE9PSIgY29uZGljaW9uZXNEZVBhZ289IkNPTlRBRE8iIHN1YlRvdGFsPSIzMTMwLjAwIiBUaXBvQ2FtYmlvPSIxLjAwIiBNb25lZGE9Ik1YTiIgdG90YWw9IjM2MzAuODAwMCIgdGlwb0RlQ29tcHJvYmFudGU9ImluZ3Jlc28iIG1ldG9kb0RlUGFnbz0iVFJBTlNGRVJFTkNJQSBFTEVDVFJPTklDQSBERSBGT05ET1MiIEx1Z2FyRXhwZWRpY2lvbj0iWmFwb3BhbiwgSmFsLiIgTnVtQ3RhUGFnbz0iMDQ4OCIgeHNpOnNjaGVtYUxvY2F0aW9uPSJodHRwOi8vd3d3LnNhdC5nb2IubXgvY2ZkLzMgaHR0cDovL3d3dy5zYXQuZ29iLm14L3NpdGlvX2ludGVybmV0L2NmZC8zL2NmZHYzMi54c2QiPjxjZmRpOkVtaXNvciByZmM9IkxCRTg5MDkyNkhNQSIgbm9tYnJlPSJMYWJvcmF0b3Jpb3MgQmVjYXIsIFMuQS4gZGUgQy5WLiI+PGNmZGk6RG9taWNpbGlvRmlzY2FsIGNhbGxlPSJJbmR1c3RyaWEgVmluaWNvbGEgICIgbm9FeHRlcmlvcj0iMjQiIGNvbG9uaWE9IkVsIENvbGxpIFVyYmFubyIgbG9jYWxpZGFkPSJaYXBvcGFuIiBtdW5pY2lwaW89IlphcG9wYW4iIGVzdGFkbz0iSmFsaXNjbyIgcGFpcz0iTcOpeGljbyIgY29kaWdvUG9zdGFsPSI0NTA3MCIvPjxjZmRpOkV4cGVkaWRvRW4gY2FsbGU9IkluZHVzdHJpYSBWaW5pY29sYSAgIiBub0V4dGVyaW9yPSIyNCIgY29sb25pYT0iRWwgQ29sbGkgVXJiYW5vIiBsb2NhbGlkYWQ9IlphcG9wYW4iIGVzdGFkbz0iSmFsaXNjbyIgcGFpcz0iTcOpeGljbyIgY29kaWdvUG9zdGFsPSI0NTA3MCIvPjxjZmRpOlJlZ2ltZW5GaXNjYWwgUmVnaW1lbj0iUEVSU09OQSBNT1JBTCBSRUdJTUVOIEdFTkVSQUwiLz48L2NmZGk6RW1pc29yPjxjZmRpOlJlY2VwdG9yIHJmYz0iQkYmYW1wOzgzMTAyNENUMCIgbm9tYnJlPSJCZWxsIEZsYXZvcnMgJmFtcDsgRnJhZ3JhbmNlcyBkZSBN','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KQSBmYXRhbCBlcnJvciBvY2N1cnJlZCBvbiB0aGUgJ29YTUwnIGVsZW1lbnQgKG9mICd4bWxEb2N1bWVudCcgdHlwZSkgYW5kIHByZXZlbnRzIGZyb20gdXNpbmcgaXQuDQpUaGlzIGVycm9yIG9jY3VycmVkIGF0IGxpbmUgMzkgb2YgdGhlICdHbG9iYWwgUHJvY2VkdXJlIFZhbGlkYUNGREknIHByb2Nlc3MuDQpUaGUgWE1MIGRvY3VtZW50IGhhcyBub3QgYmVlbiBsb2FkZWQu','B','9991'),(49,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','35CEC233-EA03-4B8C-BBF6-56D114F8EBA9',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-05-25 12:45:24','BF&831024CT0','[encoded data, 6216 characters]','Advertencia','DQotLS0tLS0tLS0tLS0tLS0tLQ0K','B','9991'),(50,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','35CEC233-EA03-4B8C-BBF6-56D114F8EBA9',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-05-25 13:58:48','BF&831024CT0','[encoded data, 6216 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KQSBmYXRhbCBlcnJvciBvY2N1cnJlZCBvbiB0aGUgJ29YTUwnIGVsZW1lbnQgKG9mICd4bWxEb2N1bWVudCcgdHlwZSkgYW5kIHByZXZlbnRzIGZyb20gdXNpbmcgaXQuDQpUaGlzIGVycm9yIG9jY3VycmVkIGF0IGxpbmUgMzkgb2YgdGhlICdHbG9iYWwgUHJvY2VkdXJlIFZhbGlkYUNGREknIHByb2Nlc3MuDQpUaGUgWE1MIGRvY3VtZW50IGhhcyBub3QgYmVlbiBsb2FkZWQu','B','9991'),(51,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','35CEC233-EA03-4B8C-BBF6-56D114F8EBA9',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-05-25 13:59:32','BF&831024CT0','[encoded data, 6244 characters]','Rechazado','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCltDZXJ0aWZpY2Fkb1ZhbGlkb10gRWwgWE1MIHRpZW5lIHVuIG76bWVybyBkZSBzZXJpZSBkZWwgY2VydGlmaWNhZG8gZGlmZXJlbnRlIGFsIGRlbCBjZXJ0aWZpY2FkbyBpbmNydXN0YWRvIGVuIGVsIG1pc21vLg==','B','9991'),(52,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-05-25 14:01:50','BF&831024CT0','[encoded data, 4192 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KQSBmYXRhbCBlcnJvciBvY2N1cnJlZCBvbiB0aGUgJ29YTUwnIGVsZW1lbnQgKG9mICd4bWxEb2N1bWVudCcgdHlwZSkgYW5kIHByZXZlbnRzIGZyb20gdXNpbmcgaXQuDQpUaGlzIGVycm9yIG9jY3VycmVkIGF0IGxpbmUgMzkgb2YgdGhlICdHbG9iYWwgUHJvY2VkdXJlIFZhbGlkYUNGREknIHByb2Nlc3MuDQpUaGUgWE1MIGRvY3VtZW50IGhhcyBub3QgYmVlbiBsb2FkZWQu','B','9991'),(53,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','35CEC233-EA03-4B8C-BBF6-56D114F8EBA9',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-05-25 14:07:12','BF&831024CT0','[encoded data, 6244 characters]','Rechazado','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCltDZXJ0aWZpY2Fkb1ZhbGlkb10gRWwgWE1MIHRpZW5lIHVuIG76bWVybyBkZSBzZXJpZSBkZWwgY2VydGlmaWNhZG8gZGlmZXJlbnRlIGFsIGRlbCBjZXJ0aWZpY2FkbyBpbmNydXN0YWRvIGVuIGVsIG1pc21vLg==','B','9991'),(54,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-05-25 14:13:18','AOZ9903024A5','[encoded data, 14700 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KRWwgcmVjZXB0b3IgQU9aOTkwMzAyNEE1IHRpZW5lIHVuIHVzdWFyaW8gZGUgcHJvZHVjdGl2bywgZmF2b3IgZGUgdXRpbGl6YXJsby4=','FE','6096'),(55,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-05-25 14:15:35','AOZ9903024A5','[encoded data, 14700 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KRWwgcmVjZXB0b3IgQU9aOTkwMzAyNEE1IHRpZW5lIHVuIHVzdWFyaW8gZGUgcHJvZHVjdGl2bywgZmF2b3IgZGUgdXRpbGl6YXJsby4=','FE','6096'),(56,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-05-25 14:15:49','AOZ9903024A5','[encoded data, 14700 characters]','Rechazado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpbQ2VydGlmaWNhZG9WYWxpZG9dIEVsIFhNTCB0aWVuZSB1biBu+m1lcm8gZGUgc2VyaWUgZGVsIGNlcnRpZmljYWRvIGRpZmVyZW50ZSBhbCBkZWwgY2VydGlmaWNhZG8gaW5jcnVzdGFkbyBlbiBlbCBtaXNtby4=','FE','6096'),(57,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-05-25 14:17:19','AOZ9903024A5','[encoded data, 14700 characters]','Rechazado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpbQ2VydGlmaWNhZG9WYWxpZG9dIEVsIFhNTCB0aWVuZSB1biBu+m1lcm8gZGUgc2VyaWUgZGVsIGNlcnRpZmljYWRvIGRpZmVyZW50ZSBhbCBkZWwgY2VydGlmaWNhZG8gaW5jcnVzdGFkbyBlbiBlbCBtaXNtby4=','FE','6096'),(58,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-05-25 14:17:29','AOZ9903024A5','[encoded data, 14700 characters]','Rechazado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpbQ2VydGlmaWNhZG9WYWxpZG9dIEVsIFhNTCB0aWVuZSB1biBu+m1lcm8gZGUgc2VyaWUgZGVsIGNlcnRpZmljYWRvIGRpZmVyZW50ZSBhbCBkZWwgY2VydGlmaWNhZG8gaW5jcnVzdGFkbyBlbiBlbCBtaXNtby4=','FE','6096'),(59,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-05-25 14:23:19','AOZ9903024A5','[encoded data, 14700 characters]','Aceptado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpEb2N1bWVudG8gVuFsaWRv','FE','6096'),(60,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','35CEC233-EA03-4B8C-BBF6-56D114F8EBA9',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-05-31 17:46:06','BF&831024CT0','[encoded data, 6244 characters]','Aceptado','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCkRvY3VtZW50byBW4WxpZG8=','B','9991'),(61,'EME870831T20','EPSON México, S.A. de C.V.','9A5639AF-F8DE-0731-C70C-3AE3C3BBC74B',8935.380000,'2015-11-10 08:46:28','1.0000','MXN','2016-05-31 17:47:23','GDA1212134L3','[encoded data, 5672 characters]','Rechazado','[encoded data, 8500 characters]','L','18248'),(62,'AARS890227FC0','SANDRA ARAUJO RAMIREZ','3123434B-F26E-438B-8E9C-95CEB81963BE',178170.780000,'2016-05-02 17:49:26','1.00','MXN','2016-06-16 10:12:15','CPO8710026Z3','[encoded data, 152000 characters]','Rechazado','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCltYU0RdIEVsIGRvY3VtZW50byBlcyBJTlbBTElETzoKV2FybmluZzogTm8gc2UgcHVlZGUgY2FyZ2FyIGVsIGVzcXVlbWEgcGFyYSBlbCBlc3BhY2lvIGRlIG5vbWJyZXMgJ2h0dHA6Ly93d3cuY2FwYWRlb3pvbm8uY29tLm14L2NmZC94c2QvJyAtIEVycm9yIGVuIGVsIHNlcnZpZG9yIHJlbW90bzogKDQwMSkgTm8gYXV0b3JpemFkby4=','A','440'),(63,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-06-16 10:12:37','AOZ9903024A5','[encoded data, 14700 characters]','Aceptado','UHJ1ZWJhVG9kb3MNCi0tLS0tLS0tLS0tLS0tLS0tDQpEb2N1bWVudG8gVuFsaWRv','FE','6096'),(64,'LBE890926HMA','Laboratorios Becar, S.A. de C.V.','35CEC233-EA03-4B8C-BBF6-56D114F8EBA9',3630.800000,'2015-08-10 11:06:57','1.00','MXN','2016-06-17 09:40:43','BF&831024CT0','[encoded data, 6244 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KRWwgcmVjZXB0b3IgeWEgbm8gY3VlbnRhIGNvbiBjculkaXRvcyBkaXNwb25pYmxlcyBjb21vIERFTU8sIGZhdm9yIGRlIGNvbXVuaWNhcnNlIGEgdmVudGFzQGRpc3hpaS5jb20u','B','9991'),(65,'EME870831T20','EPSON México, S.A. de C.V.','9A5639AF-F8DE-0731-C70C-3AE3C3BBC74B',8935.380000,'2015-11-10 08:46:28','1.0000','MXN','2016-06-17 09:41:25','GDA1212134L3','[encoded data, 5672 characters]','Rechazado','UHJ1ZWJhVG9kb3N8UHJ1ZWJhRGVtbw0KLS0tLS0tLS0tLS0tLS0tLS0NCltTZWxsb0VtaXNvcl0gRWwgc2VsbG8gZGVsIGNvbXByb2JhbnRlIG5vIGNvcnJlc3BvbmRlIGNvbiBsYSBpbmZvcm1hY2nzbiBkZWwgWE1MIFtTZWxsbyBJbnbhbGlkb10=','L','18248'),(66,'EAC030618A65','EURO AMERICANO DE CALZADO, S.A. DE C.V.','37618CC9-FAAB-2B43-9F05-266B85104ED2',80620.000000,'2016-05-03 09:45:26','1.000000','MXN','2016-08-26 12:11:05','AOZ9903024A5','[encoded data, 14700 characters]','Rechazado','DQotLS0tLS0tLS0tLS0tLS0tLQ0KVXN1YXJpbyB5L28gUGFzc3dvcmQgZXMgaW5jb3JyZWN0by4=','FE','6096');

--
-- Dumping events for database 'disxii_uis'
--

--
-- Dumping routines for database 'disxii_uis'
--
/*!50003 DROP PROCEDURE IF EXISTS `ListaEmisoresPermitidos` */;
DELIMITER ;;
CREATE DEFINER=`root`@`%` PROCEDURE `ListaEmisoresPermitidos`(in tcPerfil char(30) )
BEGIN

declare iRestxEmi int;

select count(*) from RestxEmi where RestxEmi.perfil = tcPerfil COLLATE utf8_spanish_ci into iRestxEmi;

if iRestxEmi > 0 then

	select EMISOR.RFC, Emisor.IDemisor FROM EMISOR where Emisor.IDemisor in (select idEmisor from RestxEmi where RestxEmi.perfil = tcPerfil COLLATE utf8_spanish_ci);

else

    select EMISOR.RFC, Emisor.IDemisor FROM EMISOR;

end if; 

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `ListaTDoctosPermitidos` */;
DELIMITER ;;
CREATE DEFINER=`root`@`%` PROCEDURE `ListaTDoctosPermitidos`(in tcPerfil char(30))
BEGIN

declare iRest int;

select count(*) from RestxEmi where RestxEmi.perfil = tcPerfil COLLATE utf8_spanish_ci into iRest;

if iRest > 0 then

   	select count(*) from ResEmiTDocto where ResEmiTdocto.perfil  = tcPerfil COLLATE utf8_spanish_ci into iRest; 

	if iRest > 0 then    

		SELECT t.tipodocto,t.idemisor,t.filtroa,t.filtrob,t.filtroc FROM tdoctos as t join (select rtd.idEmisor,rtd.tipoDocto from ResEmiTDocto as rtd where rtd.perfil  = tcPerfil COLLATE utf8_spanish_ci) as RTDocto on RTDocto.idEmisor = t.idEmisor and RTDocto.tipoDocto = t.TipoDocto ;

    else

		SELECT tipodocto,idemisor,filtroa,filtrob,filtroc FROM tdoctos where idEmisor in (select idEmisor from RestxEmi where RestxEmi.perfil = tcPerfil COLLATE utf8_spanish_ci);

    end if;

else

    SELECT tipodocto,idemisor,filtroa,filtrob,filtroc FROM tdoctos;

end if; 

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `LoggerEnviaEmail` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `LoggerEnviaEmail`(in tcTO varchar(254), in tcSubject varchar(254), tnNoEnvios TINYINT(2))
BEGIN

    declare lnNoEnvios int;
    declare lnRows int;

    select count(cTo) into lnRows from logenviaemail where cTo COLLATE utf8_spanish2_ci=tcTo COLLATE utf8_spanish2_ci and cSubject COLLATE utf8_spanish2_ci=tcSubject COLLATE utf8_spanish2_ci;
if lnRows < 1 then
    INSERT INTO logenviaemail (cTo,cSubject,nNoEnvios) VALUES (tcTo,tcSubject,1);
    select 1 into lnNoEnvios;
else
 select nNoEnvios+1 into lnNoEnvios from logenviaemail where cTo COLLATE utf8_spanish2_ci=tcTo COLLATE utf8_spanish2_ci and cSubject COLLATE utf8_spanish2_ci=tcSubject COLLATE utf8_spanish2_ci;
    if lnNoEnvios <= tnNoEnvios then
  update logenviaemail set nNoEnvios = lnNoEnvios where cTo COLLATE utf8_spanish2_ci=tcTo COLLATE utf8_spanish2_ci and cSubject COLLATE utf8_spanish2_ci =tcSubject COLLATE utf8_spanish2_ci;
 else
  select -1 into lnNoEnvios;
    end if;
end if;

    select lnNoEnvios;


END ;;
DELIMITER ;


