SELECT 'HOR820325EA3' AS RFCE, 'MAGM761004UL7' AS RFCR, 'AFC95540-A338-4681-8B92-24ADEB53205A' AS UUID, '1828' AS Total, '-----BEGIN CERTIFICATE----- MIIFxTCCA62gAwIBAgIUMDAwMDEwMDAwMDA1MTAxMTQyODMwDQYJKoZIhvcNAQEL BQAwggGEMSAwHgYDVQQDDBdBVVRPUklEQUQgQ0VSVElGSUNBRE9SQTEuMCwGA1UE CgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJT04gVFJJQlVUQVJJQTEaMBgGA1UE CwwRU0FULUlFUyBBdXRob3JpdHkxKjAoBgkqhkiG9w0BCQEWG2NvbnRhY3RvLnRl Y25pY29Ac2F0LmdvYi5teDEmMCQGA1UECQwdQVYuIEhJREFMR08gNzcsIENPTC4g R1VFUlJFUk8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQ Q0lVREFEIERFIE1FWElDTzETMBEGA1UEBwwKQ1VBVUhURU1PQzEVMBMGA1UELRMM U0FUOTcwNzAxTk4zMVwwWgYJKoZIhvcNAQkCE01yZXNwb25zYWJsZTogQURNSU5J U1RSQUNJT04gQ0VOVFJBTCBERSBTRVJWSUNJT1MgVFJJQlVUQVJJT1MgQUwgQ09O VFJJQlVZRU5URTAeFw0yMTExMjkxNjIwMThaFw0yNTExMjkxNjIwMThaMIGTMRIw EAYDVQQDEwlIT1JGRUwgU0ExEjAQBgNVBCkTCUhPUkZFTCBTQTESMBAGA1UEChMJ SE9SRkVMIFNBMSUwIwYDVQQtExxIT1I4MjAzMjVFQTMgLyBMRUdGMzYwNzI5R0o3 MR4wHAYDVQQFExUgLyBMRUdGMzYwNzI5SEhHTkRMMDQxDjAMBgNVBAsTBVVuaWNh MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAgz01i5W+wfOnYy2rt6e6 XeLxt54YzWLEZzYMTmsEJkD16/6Te3pKhz4PClj8794PrmRnBlVYi670vCtrCl5L NDSJE0jB/1hENWAqjkbVHU6iu3FdYvcTrMp6L+LcTOVPqQp6nbicdHjkORwT7VCR OVw1eFmxWm2pN6dfILD94Y/ZbxAyqB4grU1hwt2V90ZorQsObt5JfILFBqTKfHgl MEPzlT6zo+jht8rOK87HCHDHRNmjMQvTaPnIFHCjErqtFe7EbM9/9RkoAW+OWleK cvqg4HdzUUDkE9ib7l5WvlvItC3HzL4YKTfuQjzPdDFwLILJq7R8GGmbP82Fq1BQ 0wIDAQABox0wGzAMBgNVHRMBAf8EAjAAMAsGA1UdDwQEAwIGwDANBgkqhkiG9w0B AQsFAAOCAgEAMZY8DYaIdEd3dzL7p8iB6MPDh2DrDejTkV3JaX2xeVMYPK6YxQQ4 JJyB3N/36BSEj4tJqNfV2Gv0Ilpk0cnE9PEBBHNlpz07kXx7PuvF5vfaNRBtMRXZ j/kFIJfee+hCp7nf4giSDw74brKUoerg2yYYwMdEvPDgZq5FW78HMm2Q14sWK/iU BWbEx2qbwZH+9YgThaWHCSv64bBrxjvBFcz+Ee7NnxSHhdxy7GENvSz4I+m8nkFu yWVpx+AI8O9lHIlPFmuXSnaETtrhL9kvvmfVGB/+dB4PJ5XR0RTIxvxlHt+3LRac cQIIyP327k67eUfVOcSRAXk3pDOIulh13SzK4E1rryGmZ4el/5NmoAwJ9K1UhNAx eBWb6Z+dzCQBUY+hKfQcXoLfrTYC++lAc7nTLNRdSp4r75svjpX2EoP4LNEjrQlR nE5ChWj8FVusFl0alWc3YzUlXwv2+kgmJxObaMilsaXuDD9faXGpL9cfVZhqGx81 RNZhsjZjVYOgqsZylfAC1h6eaCl3rx8bUGaqOC7gMO3XNGr9MdFVmHAMnyUdK4oI IEzdwic8gJayNy8w/si6srcBy3ugU7+WmXdQfi/LF708MAx/qX2W/Eop4KttR5cc ul/EBN0/a/aupC/7TOFFeIblTio3+jjZnby4wNmt7T24tDje1rlgoBg= -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCDPTWLlb7B86dj Lau3p7pd4vG3nhjNYsRnNgxOawQmQPXr/pN7ekqHPg8KWPzv3g+uZGcGVViLrvS8 K2sKXks0NIkTSMH/WEQ1YCqORtUdTqK7cV1i9xOsynov4txM5U+pCnqduJx0eOQ5 HBPtUJE5XDV4WbFabak3p18gsP3hj9lvEDKoHiCtTWHC3ZX3RmitCw5u3kl8gsUG pMp8eCUwQ/OVPrOj6OG3ys4rzscIcMdE2aMxC9No+cgUcKMSuq0V7sRsz3/1GSgB b45aV4py+qDgd3NRQOQT2JvuXla+W8i0LcfMvhgpN+5CPM90MXAsgsmrtHwYaZs/ zYWrUFDTAgMBAAECggEARxHEh1yGOr3ZrYmz7fa0o9ccEtVYlRChT0sjiuvFCXow MqZf84QcC/T9bBsYjkTwtP3GFNXu52XNPoE8rBa4HwM8H+dMtxxzg3waT4XoLsDA u0T+z3MBgpb7aCcwKawcYWw9TmAEycYVwR+FYwQ4QJnAkvXvZwrvkiXfC/MM6TKY N9EAv53q0xxKncvhPwSN56S3rH6NujbIqmFoA7XlNNdgIeDrAoDVOiKwcl2vOXqU VnWpFJ3MCqAK+HaDrkL9x4GABwTMwCYKG/U1hJh/u2q3RlqmsBH1iuY/RixtztUP zxWkcAuNKkNzGFyulz4nIq8tp9KpU2doyrz/31dPAQKBgQDBtDOxxf6e35Erj7sn OK9zOFL5lBysDto+ZHK4DwoSiziBt8/RR5KTaXEn/hrISUCY/b291aQlSKyMlo+2 W4L4qt/f0bAFSn9yugaFBw67zoo4m6aaIdGwk5OeXCFDZtlUrvmttcQJGWz3Inxo aTo/AdTowTm3EgbJZe7JKvJ3kwKBgQCtcjqiB/lCSlRmXpkn7qkZzz3SKoFBnKgO 06KRWDk4ucHRnqQY+DQHvRMveAcq2t/Pv0hVSoFPvovj2LKg8QyKQpUUAg0AF1ep Slu1xJOMjgCjstzJPRsrRY4ERs3VCecS+LbLwW1Y9MDBhCIqKcLSHkUjlqTx2REX dVUlPHAJwQKBgQCsVy0rPTLmnZkmvdHQ+qE3jWRdxAaimvBYVLywwEjA6PdUinsv A1QJLeZMo8umaW488H2R2fQabAeBai/hGphzsGxRUdofSwILzDEiyH22YPQfm3Tm a7KKPTM40VWTB33T134zrKYHRoTpeNhheUYmavXIRKqaFELPi46hk0F5WwKBgQCG Jy4WmVg/38H8E/seGciNf+/vGJU1LHgIT8UT6ksIBxVUjwGZlpCX07R9KLdSfExU IT1PSvtNtLH6n2c6eHcckXdBLHzlryhMdokMxGjjdAomk3eV5z+Wbovz3tfhiXFD CUBJxOhQv64/f3X1aquXXXZYmnIl5aEEpeofjOmTgQKBgQCZRE4QC2jDyvOmYzpM Hwfu+ybzTnT2pT5Ji2jnFX6HbXHRNLG0DIdtEiOse20QiRgoBI5t3cGujF85LmR2 2fhbEDVXx7+vh63Phmlid3bbyZeP5bU7h7kf0d29+yaSNf+wYOA876JvsnuA9NG1 Pswbf68/DdnEGp8d4ztjnfkQmw== -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMCQIBAzCCC88GCSqGSIb3DQEHAaCCC8AEggu8MIILuDCCBm8GCSqGSIb3DQEHBqCCBmAwggZcAgEAMIIGVQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIJEC7xtjbquQCAggAgIIGKL3UnhPRHjW3049C+ppmtM9hZg6sr5/xz6WwHy+prNYOAqE1lVGrv2LyJPfAkFKpWE0TBStxmvsxCs+i47BaJjbTE+wVTCt9G/+ioHXROqyAeZuM9oUQ+aCaHmsPd6f660rnD6Fkzm14huwwR19/fs4pjGArZ3Pbe9sm7JMfFobYmps90fOhTJEXnGXJygoAO6FZ9oaPkV87xzGF3pTvBHFiP6tuGdQtGY21oyqj6uPCgVkOUUQy6B1jSjB+1Zagfje0YOP0pDwub7zcDxswWHpTecebe8+VTbaWBns38cBIFSe4fQrEVmmNlxvyJqzJ3aWmF4eQqyNz+U5StZvSOZUivIynni0fevKcPSDzr+25y67Veuo4eymQYh62fI8CZyxSbRcTEEh8UzDkXK1QsV+9cBq/HyIk8PR33C3arCSKIaO3a5ioQ+leNy2pXq51kA3a0lGtWwB5vMM/uOfC1ieoB3IcPw70a+S1VTYehXSJuGL+8T3oBFnHzq2VTy0ADZ4vcb2ktQi9AwJKqvyiZve6jG+hLL7ueyxSa95FuQDRsttk+vvZh2KD2eq6Jvg5Wnv6DQvPkqR6ukUbWIlhC3XXimIq9KlHHd9+EcA4OPYNjLGggd3F2tZnwJj+3k/nM+SgWRxB26Sz2+TMBUABczWP+DZi8WFGPB9xIhtJR9BICclLmeh+7WC+ylmlEj/CH+GBOzIvTW1hSOSYOFrT3+bRf1+MjowcX7I3CziHD+XLaa71LjjrnjErSkmjU5gw+CU/qUmCCc/iVQOqRKKG3bhinNnSvAmEB0gJbLXqf6qzdg3lUFsa07RU0P1ObLr/yUmbZETTR0uuW3LcCLanmJJhI5t2iz+74yjh6xHkHLrnYAA7HJtLnJZGG9b/Ymr9n5g78ObOMvjuqDhEwwA22gUWXfd1TUwF97tnxgNBJJDRbLsWiBzYbrCW2rBvVfKNlRktOKRpnh4gmILZZaILwr3fNNRvBKJTA2W8iVNdRgSUpdHcf3uQZwZ/YpiNoJ2SK0N9Ho1i9r4H+99o5TfWzpOKFOoMIJh1VX71yP1XHla3pCsspMflTacuB2ErkBmzL3fZyNq+JqN1n09sVADL+ddevLsWfpKM1Oj/0IkeNjlWwaiFihc/nnBNhKOP4Cx5KDZBtC2jBohmpKdoqPdptcoyQyMrUYo74UpRK0pvHZFzdXqEdHmWuS+TG7htDiTBskoMIKtMabpo8OZ/7L/q9srvoeX4o1Z+rZi6aswkfAkSKH0aHiLE1VSrIfaSsl3nTUAryASDG2FHEQ3XWVcpFQ41QwDhLsM0VnUC9tyPHTQIT/9ifxMru0uslgiiFUDlFw8PReUsi+qzDRyh6bYHWHVgtYwPlhTXmgEQiAmlL8PzzATYpoA0HG0pBxxYSqVA2xap3YbRQk7xdoODvLHpzEX64hHil1I/ehGeEK2kmCP7xfiEWAjuqQefFd83VHPlcrh6vgdLBYdiLtX8cTGE7ElWXe1c20sb8CKq9Dkryl75P3kSEPs+zpss6rNVzLDxuc0v2+W071DEqaX27tXr4u/JKQa4wnRZD1qcjoo14o5NSSCRBbUMTdSilYol0puusDPL24QdjWwDESbQ4dE6kZFsVKuagi2tGxJqSiMhipj7U+Ufz7/uhRLS2eoPKbY5YJtfTHmqx9joUUh7G79PtmruerZRIeZRwdGNencJi//TO8hr1kyd7mxUppYK+XCewgpYEqr44FWZvw1jDArQ4anR/dx+b+O0qBCUy6J3zbqaVyyw5vNnVZKSierkbm57BnKK9Zeh6V3HcQMuRNz57jLptVB3sQd3zLuPRI3WQtq/OmsqqgQ6RWaXdaZL0kGl4gzGEAdIAYfraSBhE52UaXOIEJ5jMYSWCReJJdjyxF4Pz/LqnPjxNK+BYdouJP6BEbdFqjMyPPGCuEFXaduEzi3nJj7nm6cDJC+0ILTQkeI8QrUdvxx9L8rcQwHXzwCXwJ4zGUa0+FXgaMg1cS3AtuTmEqCjgq6JXIhGCx7K5q4k/s/EVvbnYfkPXD7MsNEA0GuBjh33vdF/Y0Zfn3c2cux1QeKe686+ZjysqwIeLfjDVGkiieTwdkMwggVBBgkqhkiG9w0BBwGgggUyBIIFLjCCBSowggUmBgsqhkiG9w0BDAoBAqCCBO4wggTqMBwGCiqGSIb3DQEMAQMwDgQIcfY8saQsIaYCAggABIIEyD+y2iCN/ij92kXV7OqgXfHCTawUhfRMl1pzydNgsiDeSLGWmYBzeHw04mKb44MrGZZFcFL8wqUTctvDozppPTlZams5cingRe4jY0az2L8a4RdJz/wX65m6d8UwhH4t/ZaCvIHXIBRUwcmmczncHr4R+JBTjkQUEQt9zsmQwEqwiSRy6P+AF2UkklVboMm9pQShKy98baWLqG09Jcwd9K+DLWJD1ag1/Hv0l1lNNtB3kzPsh1mBULCVOW8cAXVq4Si51BJYGlLlAt7CP/V+P/MOU0iRoAaKnnVAFstS4MERHGA0NUtmcpP1IijkUPgwPVse6YdS2sjWJg2gGbnxtcmhM+J0Je5ZXNt/CnZEV4PPF61Crqxks/A4yNKW6lFKDh+AzTKgwSGoB717ydsb+FVk5f3NmFd+ZrirVX/Mchn7e6D0Nb4XiHczLr1KbpOEdOTghduV4fcFr4u5D0zbqN3VivUe3stxLvwZuh5tiKnxeVXkOGgClVuaTEQpXmxOr0j2IiPRBKcFZ5DmwcgpzdmSBvTEKSeajA14lTwk9hvZIKsY1iBwYagQ2bWfFORYJiyrhkWMDhQYwj8lVT/cWl4SCda7PblTGgwgV7dkYNU9EAxGyLgokZPca350aEaGyy+MMe0A/zftz2vDzOhen4wjDtZDs5AhV3suv5FoXOJhqn6QfRX29HKFhXgZyNH5WqeyrJxajq6QR+qMP2f5hLwydLURGrNk5vqXMsK0n1dKAymp1viDf/lhXWO/DrRqZNja6S2IfoOtvxUp3KcvlRvXcMWX8RYpBzrPUHKG1jPAYtgRWyVv0QxuPIAEvxmFH/N3BYUlR2JsIp/he0HtCOrhocFYAQWoUTxIddYbaM8ZMjs7P75ndZ/SBVGJPx2UBsUMe0jMuqRGPK1ZdqBBcJEBxKVjXuKH9zh/xka0sJ4WQmxam36xgo2r1qBcqbpSRtRLtWlBjwF9IwUTZRWtfgGQlduMxYU1QOl1keBpPyWpCMvvk71k3bL7elsa+ZmHU9FwcCTqUNCS0ZoDW85PzP7erBJZ43iN2cRCekrIYJy6hf0FQFVd7Ehf702PNBVj3C1nhXFT0jPxOoQeHh6CUTHfQ22LTRv/kSvGOZLrk8fW/PfvTahsKUm/G7QGsnahrfSecNtMd2ksdmW/EBpMvBmD5ueFbXg2Lo/PHbbAws3GkbCoPrMUCyQwWiZmoeE83QAr1FIR05rjLpr1OmJCIL5gHgCaea2t3NiHz87u1eR7Z40wUvpIixsYlkcCHIWQd0o4gwa52CIzNBOZA1Sd7P0RXQXgbu/GSrEGgZjZFeOAUvnDJZZgFR5+L/yU9XVXCfDHyBSBcDfl0ct3wyLGWZK+YjmZaL7L+VHP8fM2d3OZNZJCUJeabVvHeNkkBxGZ/TEuvICniJ2hNUNP0G5kuC2Xdr3nnngvlx9Bh+ycd7knhFo3ydnlL84+GodOQeAJeAGd/VFoRFZ7q+V80DD7jhbGVP+hapiK780gsa1dOCnD3gY4U1HoVBKNfBRrJOXRKGazkGCfNJypKvt435X/DJE5MUN893Gdxpe3BmTfnmGpu9kjldTEwEyID1gcplkUXPhdEzeE9lG9594nPTexXoSCW6OuN0fKQTElMCMGCSqGSIb3DQEJFTEWBBQ6Jf5WXkdZ9kYPMF5YYHeGCbKlezAxMCEwCQYFKw4DAhoFAAQUvoAW8qnGmVwwlhDd7lP4lSZCmfwECASFSDCTMD5GAgIIAA==' AS Pfx, '02' AS Motivo, '' AS FolioSustitucion SELECT St_ID, St_Servidor, St_Url, St_Url_33, St_Soap_Cancela, St_Soap_Cancela_Test, St_Namespace, Es_Cve_Estado FROM EMPRESAS..Servidor_Timbrado WHERE St_Ping >= 0 AND Es_Cve_Estado <> 'BA' ORDER BY St_Ping ASC SELECT Factura.Fc_Serie as Serie, Factura_Serie.Fs_Tipo, Factura_Serie.Fs_Cancela_Test, Factura_Serie.Fs_Usuario_WS, Factura_Serie.Fs_Password_WS, Factura_Serie.Fs_Ruta_Archivo_Pfx, Factura_Serie.Fs_Password_Certificado_Digital, Factura_Serie.Fs_Pfx_B64, Factura_Serie.Fs_Cer_Openssl_B64, Factura_Serie.Fs_Key_Openssl_B64, Comprobante_Digital.Cd_Motivo, Comprobante_Digital.Cd_Folio_Sustitucion, Comprobante_Digital.Cd_RFC_Emisor, Comprobante_Digital.Cd_RFC_Receptor, Comprobante_Digital.Cd_Monto, Comprobante_Digital.Cd_Timbre_UUID FROM Factura_Encabezado Factura INNER JOIN Factura_Serie Factura_Serie ON Factura.Fc_Serie = Factura_Serie.Fs_Cve_Factura_Serie INNER JOIN Comprobante_Digital ON Cd_Tabla = 'FACTURA' AND Cd_Documento = Factura.Fc_Folio WHERE Factura.Fc_Folio = '01-0003824' UPDATE Comprobante_Digital SET Cd_Motivo = '02', Cd_Folio_Sustitucion = '', Fecha_Ult_Modif = '2025-09-25 12:00:01', Oper_Ult_Modif = 'MARY' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0003824' SELECT GetDate() as Fecha SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento='01-0003824' SELECT CD1.Cd_Motivo, CD1.Cd_Folio_Sustitucion, CD1.Cd_Timbre_UUID, ISNULL(( SELECT TOP 1 cd.Cd_Documento FROM Comprobante_Digital cd Where cd.Cd_Timbre_UUID = CD1.Cd_Folio_Sustitucion ),'') AS Origen FROM Comprobante_Digital CD1 WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0003824' AND Cd_Motivo <> '' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'MARY' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Es_CvE_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0003824' SELECT Poliza_Control.Pl_Folio, CAST(Poliza.Pl_Tipo AS CHAR(2)) + ' - ' +CASE Poliza.Pl_Tipo WHEN 1 THEN 'INGRESOS' WHEN 2 THEN 'EGRESOS' WHEN 3 THEN 'DIARIO' ELSE '' END AS Pl_Tipo, Poliza.Pl_Numero FROM Poliza_Control INNER JOIN Poliza ON Poliza_Control.Pl_Folio = Poliza.Pl_Folio WHERE Poliza_Control.Pc_Tabla = 'FACTURA' AND Poliza_Control.Pc_Documento = '01-0003824' AND Poliza_Control.Es_Cve_Estado = 'AC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0003824' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0035041' SELECT Factura.Es_Cve_Estado AS STDoc, ISNULL(Comprobante_Digital.Es_Cve_Estado,'NE') AS STComp, Factura.Fc_Tabla as Tabla, Factura.Fc_Documento as Documento FROM Factura_Encabezado Factura LEFT JOIN Comprobante_Digital ON Cd_Tabla = 'FACTURA' AND Cd_Documento = Factura.Fc_Folio WHERE Factura.Fc_Folio = '01-0003824' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0003824' AND Es_Cve_Estado <> 'CA' SELECT Poliza_Control.Pl_Folio, CAST(Poliza.Pl_Tipo AS CHAR(2)) + ' - ' +CASE Poliza.Pl_Tipo WHEN 1 THEN 'INGRESOS' WHEN 2 THEN 'EGRESOS' WHEN 3 THEN 'DIARIO' ELSE '' END AS Pl_Tipo, Poliza.Pl_Numero FROM Poliza_Control INNER JOIN Poliza ON Poliza_Control.Pl_Folio = Poliza.Pl_Folio WHERE Poliza_Control.Pc_Tabla = 'FACTURA' AND Poliza_Control.Pc_Documento = '01-0003824' AND Poliza_Control.Es_Cve_Estado = 'AC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT Es_Cve_Estado AS Nombre FROM Factura WHERE Fc_Folio = '01-0003824' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0003824' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_CAMPO_NUMERO_IDENTIFICACION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_TABLA_SOLICITA_DOCUMENTO_RELACIONADO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_CFDI_EGRESO_CONCEPTO_UNICO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_PRODUCTO_CUENTA_PREDIAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_CAMPO_NUM_CUENTA_PREDIAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_METODO_PAGO_CLAVE_DEFAULT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_ACTIVA_METODO_PAGO_CLAVE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_DIAS_VENCIMIENTO_CERTIFICADO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_PRODUCTO_ANTICIPO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_IMPUESTO_IEPS_TASA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_IMPUESTO_IEPS_CONCEPTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_RECEPTOR_CON_CRUZAMIENTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DESCRIPCION_AMPLIADA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_FISCAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPORTE_MXN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_CANTIDAD_NOMINA12' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPORTE_NOMINA12' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPUESTO_LOCAL_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_CANTIDAD_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_PRECIO_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPUESTO_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPORTE_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_RECEPTOR_CON_CRUZAMIENTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_URL_SERVIDOR_TIMBRADO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DESCRIPCION_AMPLIADA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_FISCAL' SELECT Fs_Tipo FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'FAC' AND Fs_Tipo IN ('01', '03','04') AND Es_Cve_Estado <> 'BA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO'