SELECT 'BIHL8305192T1' AS RFCE, 'CDI160330RC9' AS RFCR, '061C1C35-1C9D-46CB-BCB3-F7A742016257' AS UUID, '1592.68' AS Total, '-----BEGIN CERTIFICATE----- MIIGCjCCA/KgAwIBAgIUMDAwMDEwMDAwMDA1MDkwMTk3NTEwDQYJKoZIhvcNAQEL BQAwggGEMSAwHgYDVQQDDBdBVVRPUklEQUQgQ0VSVElGSUNBRE9SQTEuMCwGA1UE CgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJT04gVFJJQlVUQVJJQTEaMBgGA1UE CwwRU0FULUlFUyBBdXRob3JpdHkxKjAoBgkqhkiG9w0BCQEWG2NvbnRhY3RvLnRl Y25pY29Ac2F0LmdvYi5teDEmMCQGA1UECQwdQVYuIEhJREFMR08gNzcsIENPTC4g R1VFUlJFUk8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQ Q0lVREFEIERFIE1FWElDTzETMBEGA1UEBwwKQ1VBVUhURU1PQzEVMBMGA1UELRMM U0FUOTcwNzAxTk4zMVwwWgYJKoZIhvcNAQkCE01yZXNwb25zYWJsZTogQURNSU5J U1RSQUNJT04gQ0VOVFJBTCBERSBTRVJWSUNJT1MgVFJJQlVUQVJJT1MgQUwgQ09O VFJJQlVZRU5URTAeFw0yMTA5MTUyMTI4NDRaFw0yNTA5MTUyMTI4NDRaMIHYMS8w LQYDVQQDFCZMVUlTIEVEVUFSRE8gREVMIEpFU1VTIEJSSUNF0U8gSEVSUkVSQTEv MC0GA1UEKRQmTFVJUyBFRFVBUkRPIERFTCBKRVNVUyBCUklDRdFPIEhFUlJFUkEx LzAtBgNVBAoUJkxVSVMgRURVQVJETyBERUwgSkVTVVMgQlJJQ0XRTyBIRVJSRVJB MRYwFAYDVQQtEw1CSUhMODMwNTE5MlQxMRswGQYDVQQFExJCSUhMODMwNTE5SFlO UlJTMDQxDjAMBgNVBAsTBVVOSUNPMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB CgKCAQEAlLlvQ4ztw4+5eFVFd1WNLR2eZnr0QB/R9O7SkUwQuusgK8GLXi2YcUhD 7QevXyrjwIQPybu8u+AcQQdxJ6lMtVrpXWU2vB20WD9gF4WpIfGplHSz8v2eqaTl SYRLSLbaFuJz0d/lY3ykbYxCAQsel8hV+yKv0eQ2UiKu+qDu/JsWDCGAxNQPDHpQ RaUX91ZrAj2WrB26LnQ/uvJf4myU8lyD6Ty1GUCOaoQckGhzewnilblcg+1NpHpT tTVNUW02DODkfKhhyzgUZJpGUK9wvX5bWtNzcc7JJ5CBy1mPjJPxx/i5FjWIRxWB SarrqpWTkL9BhoGrxY+oC0QOxPTn7wIDAQABox0wGzAMBgNVHRMBAf8EAjAAMAsG A1UdDwQEAwIGwDANBgkqhkiG9w0BAQsFAAOCAgEAUQvQc/vEyLC3Q7Oog68uyfW5 cQOKY4AvaKW1oTsZ+gQgdJc2QZoXQJoQp5EdkTWLJ6IOZSRP2+IQn1afd73a0N49 TUnuow5wt2UCHGF+yirAfsFH1epsxUYjUXKZ/aFrMCUMP8BB/TKU+FUp0S1FVvC1 XeGBBGcCNh3UpoYRATYDTNn/wc73KYm6Bv8aySFzUw5Mvt0ZLsF7+/DyyORbCjAX 4nbEYrIndNTqcLU808GxP28lQYrmypALbFAAPNna+WIn19dtgpqJl4VV++BPLQzF fgaEHpjta7o6DSGRiw6XgS/a4S01/YT4rOR6ss8XGQHLedsisrKqAAaLz05gquE5 altAYn0+r8Hr7O4I9UPzTwm/9Arc4wOFTTLzDM7CG4u27UGv+K2NemdJsQ5bM3Zd xKQhe5tmH2Zj5iom6NHu4wVtCVJWCWS3Wq5GwnbBFfF5TcI8y+7HY4Dy/yD22ciG 56aVjUlvrtV0uyK/D+oSjzp4nf9aFKp7liFRNenlRJ7gs286tX4RVx+PxXtlGIHe yM5AOXDCid4wBfeGVr0zi7kdiwWoIYNUwyl5E9Mv20KmRlOxFSGaWgdRcdG8KOw8 h64Bua3PsV3AQVYdYwD+N7vF7/HgQZZ6qBv7dl05Z6uZUBZP+5tdcUNE5tatpCi6 F142FGFsnTITsMe1JgM= -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCUuW9DjO3Dj7l4 VUV3VY0tHZ5mevRAH9H07tKRTBC66yArwYteLZhxSEPtB69fKuPAhA/Ju7y74BxB B3EnqUy1WuldZTa8HbRYP2AXhakh8amUdLPy/Z6ppOVJhEtIttoW4nPR3+VjfKRt jEIBCx6XyFX7Iq/R5DZSIq76oO78mxYMIYDE1A8MelBFpRf3VmsCPZasHboudD+6 8l/ibJTyXIPpPLUZQI5qhByQaHN7CeKVuVyD7U2kelO1NU1RbTYM4OR8qGHLOBRk mkZQr3C9flta03NxzsknkIHLWY+Mk/HH+LkWNYhHFYFJquuqlZOQv0GGgavFj6gL RA7E9OfvAgMBAAECggEBAJQZF/fvZXDBNVLjrvoHYj8T6IFqXMFiLmQ2Uc7ILTzF GNMZt1vAEbZ03NczOOqOvh8eIs6jOWzo3ZnP/FkfWLibYBlVyayH8+eQrHKf8e1Q RasEj5EgBxgtkPmlWIZ/NytksyrCRx3Lp71C1xNM7Fj+8MfVIbnkBEfEK/R9v54g l6VkY7ZrYACtKqWHKVF/M9inkJhJ4xIu0Yih6G1YPF9Yrz8dC4bsugPDuVL6Dn/H DrHB3ePtc3+n1omNy/8kx+y4eheQR5HAKyssMDDg8Jo65cXov55MAMWS8CLcEv2M hmXPZr+eq6N4+obuzslwOsKzNlNoH1MXCxZd+3Yv7QkCgYEA0iDFhz/KU8eCwW1b o7K7aSr/ExUFXzER8yVCt40DobdKE/Fn2K+qB91WGuCxDmGl40zavKncLZjRLo62 HIl+zoWBDGipjr7rby5ZM9+iw5luwfG8KND9++GnIds2/O2wr1TEdaOhqgL7OU5w pcbGPgeP2TKWFinBHYwvpbFwGtMCgYEAtTENznH1JbxIj4lV1biiICTwkJs5Twd3 PVziMpCl7AK73F976jl0kSIOMWxLltD2o1ZIeOhwOMYeGpjEm8z0BX6P+fhcxNT/ gGxk34lMmFKHA69yWOod7Axk4OXeVXeSgsL0If+f9wCIE+1mFTtLS395AFudZuRp Kmt2RF3qVPUCgYBTq5j78fquwZLfUpxa4qCdj/Fht80byn5LQ1r9m7kGe+WTa1ze e5RI7WmL6kyWXWugxsmStlBmF6Oz1j/NvTIxKhfoyQQ7Quqcquf6L+Kv4DiqIYe6 +P0pfwD+CjwrGrpwFmDkNvP4rpc6inFwkWX+7SPqaKo6yQWMrnWKlMz+4QKBgHqe QsimCA/MdpJkj2j99QGp3f8OfN8Fn2UweYdcqlyokPeWyqX80ezxzgcWUaUzruVk m9DvBBr3wCGhptQFBFK/jrHMqQMvXeVL9YvtP5+JogMVdV3EuhEnZhFonmjabZT+ V/a2Jkwi2PQbYU0W/mKOVpWuajvacW0aokOsBswNAoGAb7lhtFICiWWqApiDrVjz Vx5+fst8vJnu64+9kkpOS1lu6Udjf+VabKd2II3ipWiPkV+reHJGhLg1S8i9c5Wr 3n37B7w7RjzM47BiAcdbqPH3JWfpGuoNKH7w9U2eJT/a69zIYU/vRZU2e+nNDBQ9 vDO5G+9j9byvY9VcP2QfIeY= -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMSQIBAzCCDA8GCSqGSIb3DQEHAaCCDAAEggv8MIIL+DCCBq8GCSqGSIb3DQEHBqCCBqAwggacAgEAMIIGlQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIJoPravbP4oICAggAgIIGaOEHc6rt3614JOF+WeqX0CV98K8uyDX9iaQ55KVk4dkkM8wyTG49QOaq7QPjp9JANjvZZt6Rl8mQ3wBTf+9hsRAXoyL4+VQcHKP92x4lfNRlOQOaxibfHwtURlFqLh6Vx5MZNWrGw96bOwjmQ23cCt7qBdddV7OW3UESCU3Ux2+cAXTRIJXk6XjxynZ9WpUvTJP9VcuX0TEyAC9+6jLoFp45/sRMlicHsgurrQKvshAWI+gaxfomUz1GRNkAU3YdVNkkFrNybWyp3+njp2z1dRjcLKATQZ5zGpSjFkDNxw/T10ZClqnDHk0Z+iEzd2byeZ6wtwkaHtTWYl8fxlnBsuSmPWDCZJU6qiodH/psx4CwaT0pTDUJCpj2tVkmCFN/QMi8DlfKvS1sHPH5JMkUpNbNmLrtuREmsC7Fr26RPkIBn3xOSgs69x3xE54wWzj3XZYUzSZdxXlDKJzLGrAfDYX90vCJGV98ZIzLoDQEBI9cpUlCec4FqZ6VgoArbwrUE2YSCz5mZE0RQaIIctl/wM26NkF/w8/ZDeP8Zn7/aFVFXmlBuBcTUkUF+bqOo9RfI4eVzaiiFh9QS851B1vcb/0bE14KHmO2dGD7jh86ka8D+HAfXWgkiZeE5J++Wh2YRQ5nraKG5hTJpLqIZ/w8GMcGx8B0Pb1CquMl6SnLKzI7Ep13U3RzYtAMqjdhyA443RSvynVmXTuFQR94i2odoavbGCkwJFMHXJ+Yl10rSE34Na3UCQgpWhAsR8zrvxN1nY0ptLBossv2jx4qW3f7KsWvy+dWG+ZVaYQubmCNS8v2huyn2oSOIiEjXDue5qxitqcohcjrSmNbz4rsRjK2PUjRCFTy72t9d6jv2diYf/KAcXK5CfrqG/gAgjt82FYNxuJ3Y8Rze1X+AAYCJl8mjaXHphk65wQ+aSof08a/1f9kABkcEIr/rJpPCKZQ593zSyZHTaHhizU6AGxTNvq7HcJiZyVlyDJDUWP+srHbisWNtslUMSgMb9l7+s8Y+Z8efvpDeDw477lb3qtK6GGzb19E6f5RM7WwFgNlO4aAuxY1SDBM8NE6HhbNgVAQLWcusMolHPbHijbcyUTgehzpjoY3sYp2i0vUL2V4JdzUYkQ6bX0CQg0JQnZ0Pcv7LmyLFxtFrGqBQktd1hT/w8yveXuhwMitQEKDP9cLPdZf32Crj8ltYJ55iigRNZ848jwXe+P25negEXs2TIf1nheaOp3INOCsCzSP7EUPG5lgSex+BEMDR4aOYbfoCVYn+s0vSzVzkqJyeH4fhEmFKJD7PxTsOl5j1oNXUEWd0D5CInoX1P8a7mWMI49ltCJJNuhhbJM0lZxhzz0m/xFV5qj7qXTFAcPvfZqqkDCyZs+bYqAaOtu4N59XfrLBE9UX6cSCRGDeSXlqTzeICxjlNTHQ6arxxCPCj9JHmj5jHx7rWK9jRg/6Oq9W3FrL2bb8wLh1CKyJrIMk6hL9efG7mRrU3tsbUaKmgK1RJPpDhnmZUn97CX4Sxy2usn+nhjUUTV7QM+HR4ETaub8ikuKwC7Q4vXCdoZifKTT9Jb1EaBeBGTjfJ0Q7SJcl+eKu4iMovSDee+PfvPD927CIrqXn4QQVuqJowZ3foUoIejMRcwwluW7sRVbfCZc/zODBVgObOJLHaB5m2PYgeiAOy7PIsw0oW/YJwU5y8DGXzFkOAQldgRSfS0GW9qV6KIMJ/ZoLv/29p/3BLzOe0xM4zac9LNhVlSu9y2fZJQKX2NHvZsivZe6GhpHYp+608H8E5Dx8VRePB6cP/GDS/H6ry9MyiK9ocOdXNRbQ7xclFB/hkk2YGzX0QxCpwjXPTSv+4F856NNj7+WGJkPwAcWCGsO/vZ7qOYdjV3V4SAny+829IgFUfs3h4bLo7x7FQvabsCIwyyk6pGFyVxws9jkxhx4MF447LOcPGpb/OAVU3bGvUWWMfv2OIdztD7KoUgMs9MqAIA49/chJIGX+W0PcHv30Fo9mGPg8Fy0frBvbYBPcZ95Fts+Y8JcaVIS65MtxmZD/k+ek/2K6v5toGkMGaBVDd7neiMtrhgBx2EGgCMQroiCzxCaGa8LDgBVD+r60Au2GtHNb6b2fpPMrnELHSRt8m18I3UKKqKLZvjx7VRWdLXbO8yg8TAjH2WwAE2orwOgmihsgc8xlQ5r9nexeMIIFQQYJKoZIhvcNAQcBoIIFMgSCBS4wggUqMIIFJgYLKoZIhvcNAQwKAQKgggTuMIIE6jAcBgoqhkiG9w0BDAEDMA4ECGJpXwhIVFs5AgIIAASCBMhk1GUZDgxzHDnp66h+Tise+4nZL2HwKHZKk3OV7oXwVOIeAL5bwjelZaLSYlJwyRkpZM5yQ8Yj+6452MZLrpNpywexjLzpsG+rHtc13/IHkVQVAH0gT1YVxUlHuVRDAE1BVx4jcKqkfQ89nFifxR70AWF27ZYON8FrwGvacmAj8+7LZjckoXyZP0iZN5tl7tQ5RT+4rh05EF8qjZl63KeyXJ4BIap3AGFzvUkc0y9Krb5X0CD+RguJPilKIT/tybGLTJtElLYnOwFfZxgLeBirNtP5wmQ/VTyHb3lEf4/xomiBG1B3ZCmwgvmkSl5JZWce0KJCuQ+iv7/NLAZ14/T0Gnf8AUVQr7cp8OaJcXBH+dt5YhPCEBu2dPFS0mDJ4f775S/t+hN245SHDiDOWnJXUg89RKbi+OS4wYLpwK2gOtD7o6Pt6jGv2aoCtBJclDbPzFYtKWE4+yfI06PLZmoLVJM5t6T5bDZe1VP4E+CVO/r9Vz+kYa+dKeg34RydaAh/UJqVjLmHsfOh+KcMxt+pQG80WOtRoXhp95zDu17C+7l4MeNpRAhe+MrbNg2NAFOf7kRZUwirApI3q6tWC7pNC1ZyCiYkTCAEIwfzUHDEoE6m5OjcGb00fp9pJuEmzKihayqWZ9GFqD7tHEtHlP6U/RbY2C1+2x2nBkYy7oJUz3EkU2iWJLd+WIDuMX+Ryq8TVjz9cN02J0cBOpAWYrcwR/wXje/isTuBmqPkawq0xWwBB79P7/F2liUjRbfIhI6LIn52SQR3FBEJ+LHsVf2+cYD8/KMXQxOWltUAHpt69FzsFTOigzhG+iJrtpKhRr6aTqvkYEnsEIegJ2onszzME7eGsJNXQincpZYXLBUNdeC87jXqYLKf4/8XQr/BoCqXflfVNQA4TrxSCZw0Mwro2QJpvS3Grie+/IRWNS34sBy5+j2m9DznidgUFDMG9meIyZ2nn7sygpEy3jV/X3OnXwsYYt6YYZ0D9kZ045ohD32q1yf2cIGo8i0i7UBBopm3iDbBxaRjPHnSiPoN0TYFBTNcQyEUkOKnl6HyYX5KwTIaUDVywHOnG3QlUK0y1cF7V0QpYjb6UtIqkeGeafmQUqgsQc3BAVr2ynyURKRPtzcF673jpm3IxQNE4wdC02gBvRmLoFldYhXLFxs7al4AG4TZo9bGI8skFc14c/Qz0Ho5Gn7kb0kip1biByws1rziKdEfx4tGAUxq8uyKmZaocPuNDS5YqEUv1iJIU/m7BGGWnCDY9SDfCctRIh8Ho6EyRh4Eca2KmGVRTxWtkceCA8u+tzWBLCMAEGw9R8Rl55Q+v+FGHSbxSSn3qbVRM4TH39mTiy+zTv+dtW8GBy67V9fLCoRllbaMsPuR1mmWFZtNtFgWRlxlru1jcZmuLqMufY1TT25dcL4geWv9pdmHKonp+N+B5PpqfoBhH0cKLFiDRrWCzlVnKwf/ZMnDiGZX/eDzJkvaEMq1MR6hw9LrGthiPA+7N8j2slrx0GlYERdU2K1v4Wb+oXlUC2gL6AuuN/La11tmPU76Qne5y5UhMWxjnw6P6OhGQPDyoRGnps6C7HrfA3/cQYMo/GgP/uMThbTkwI9vT4Mw9drKTss5c4s6Y2P+yeMxJTAjBgkqhkiG9w0BCRUxFgQURQoQgDfBFm5vrfSM6uIDi2II2XYwMTAhMAkGBSsOAwIaBQAEFMK2TyimXQEf2LEe190RAoM+82iHBAis1d1nvkuNOAICCAA=' 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-0008012' UPDATE Comprobante_Digital SET Cd_Motivo = '02', Cd_Folio_Sustitucion = '', Fecha_Ult_Modif = '2022-07-25 09:38:51', Oper_Ult_Modif = 'CONTABILIDAD' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0008012' SELECT GetDate() as Fecha SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento='01-0008012' 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-0008012' 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 = 'CONTABILIDAD' 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-0008012' 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-0008012' 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-0008012' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0008012' 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-0008012' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0008012' 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-0008012' 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-0008012' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0008012' 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_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 = 'A' AND Fs_Tipo IN ('01', '03','04') AND Es_Cve_Estado <> 'BA' INSERT INTO Transaccion_Documento_Log ( Tdl_Modulo, Tdl_Tabla, Tdl_Documento, Tdl_Tipo, Tdl_Transaccion, Tdl_Fecha, Tdl_Operador ) VALUES ( 'VENTAS', 'Factura', '01-0008012', 'BAJA', 'FA001', GETDATE(), 'CONTABILIDAD') DELETE FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Factura' AND Tdl_Documento = '01-0008012' AND Tdl_Tipo = 'BAJA' AND Tdl_Transaccion = 'FA001'