SELECT 'EMR050211JF1' AS RFCE, 'DDF741104HF9' AS RFCR, 'CF5DC752-23B9-4102-BB65-8045EEE4D0DE' AS UUID, '191297.92' AS Total, '-----BEGIN CERTIFICATE----- MIIGXzCCBEegAwIBAgIUMDAwMDEwMDAwMDA3MDk2MzI2MzYwDQYJKoZIhvcNAQEL BQAwggGVMTUwMwYDVQQDDCxBQyBERUwgU0VSVklDSU8gREUgQURNSU5JU1RSQUNJ T04gVFJJQlVUQVJJQTEuMCwGA1UECgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJ T04gVFJJQlVUQVJJQTEaMBgGA1UECwwRU0FULUlFUyBBdXRob3JpdHkxMjAwBgkq hkiG9w0BCQEWI3NlcnZpY2lvc2FsY29udHJpYnV5ZW50ZUBzYXQuZ29iLm14MSYw JAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVycmVybzEOMAwGA1UEEQwF MDYzMDAxCzAJBgNVBAYTAk1YMQ0wCwYDVQQIDARDRE1YMRMwEQYDVQQHDApDVUFV SFRFTU9DMRUwEwYDVQQtEwxTQVQ5NzA3MDFOTjMxXDBaBgkqhkiG9w0BCQITTXJl c3BvbnNhYmxlOiBBRE1JTklTVFJBQ0lPTiBDRU5UUkFMIERFIFNFUlZJQ0lPUyBU UklCVVRBUklPUyBBTCBDT05UUklCVVlFTlRFMB4XDTI0MDgyMzIyMTcwOFoXDTI4 MDgyMzIyMTcwOFowggEbMTMwMQYDVQQDEypFUVVJUE9TIE1FRElDT1MgWSBERSBS RUNVUEVSQUNJT04gU0EgREUgQ1YxMzAxBgNVBCkTKkVRVUlQT1MgTUVESUNPUyBZ IERFIFJFQ1VQRVJBQ0lPTiBTQSBERSBDVjEzMDEGA1UEChMqRVFVSVBPUyBNRURJ Q09TIFkgREUgUkVDVVBFUkFDSU9OIFNBIERFIENWMSUwIwYDVQQtExxFTVIwNTAy MTFKRjEgLyBTQUNSODAwNzE5Tlk3MR4wHAYDVQQFExUgLyBTQUNSODAwNzE5SFlO TFJMMDcxMzAxBgNVBAsTKkVRVUlQT1MgTUVESUNPUyBZIERFIFJFQ1VQRVJBQ0lP TiBTQSBERSBDVjCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBANCVimpA aqD1HwTxgpSxpX/De/PB7l6/ssCoiFHMkaNzZqIP39NtrjRRYW7cMK7dKVM5xUGo 12yDaXgluLtIjDJJqVvMQmHy69iuHYMGkERm2txzrxeyGcCae78DWbXrDJBD2KuH /VV38c0Yo7598zN9I/fLoKYuS7ddEnWARgbPZX16gqm/sLa6q+VY5LyCQuy9yVdx QriAR8FLapApjBMi0JtsFJicmtYz9t/dndJ9UZVylFLi5i0xu6o1JKbD08UtK1nD slFhjSKjVKGVHQ/q+o2XXH9l45TwsX+lsyEuEWsGV/Izf5gtcH08mrR1exWIbUGP VYAtUl9CFjVtvC8CAwEAAaMdMBswDAYDVR0TAQH/BAIwADALBgNVHQ8EBAMCBsAw DQYJKoZIhvcNAQELBQADggIBADHp1pt3PRS2d6RzfgtQ5CoyKloE7piAazRjeYX5 ++HMMxxm3djSrVlXDrELaLvGPy4zJeLcKnTZ8GGqTtIW36AKCdNkgjquQ64VKEPs VfyVuJqs2WX/gbetJ0qz5watawPhsv3kcyqJoerSFsOsNoatUcCTm2ImeSz2RGc3 j3qGgfVC9B1gJCJmif4Hsh7VM6Vsn8UKP4ftRREuQc3GrDQOPgPTpXFevuggphYY Sqmd8ZZ+lx1DUvfJDrdkIfDIGsysh3TJ3+oO2QiP2Hg2+/5WQx4Ujijkwj6jKGNR eQwZg2N09CNySqsNdOildKc1qmca/ANCu/Q7g8qAgX+AddOcyE3ogiWF/Cfpx/8+ +ROTThm5QrDpG50C8i373XFEV1+B14rd5Mta7Zf68daIklv0HfHbXo5XTgcHpq9N Aeh0l6rDsWLs4Nil4YgAtp1/hgBIJtPugW4IIRO3DYpXUR6HWVFPLX20kvtQShG3 iuNoaIQ+SdMo8Z1wwUJqI23BvZRFFlzxlPy5r9k2RzLL7WBGYqpxa9CV0m4AFHeq tAVPFWwt7W8SICkkE2bLEEPCB9SnW3ln4JreJg9YdMqxvYXaiCaykvVCUer9oPK8 L0alG0YJckcsQCLj4aX6axXDFGkPjG+oQ4ITRXAmjaBQezX4I9En556jO+s+MwG+ 5HQv -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQDQlYpqQGqg9R8E 8YKUsaV/w3vzwe5ev7LAqIhRzJGjc2aiD9/Tba40UWFu3DCu3SlTOcVBqNdsg2l4 Jbi7SIwySalbzEJh8uvYrh2DBpBEZtrcc68XshnAmnu/A1m16wyQQ9irh/1Vd/HN GKO+ffMzfSP3y6CmLku3XRJ1gEYGz2V9eoKpv7C2uqvlWOS8gkLsvclXcUK4gEfB S2qQKYwTItCbbBSYnJrWM/bf3Z3SfVGVcpRS4uYtMbuqNSSmw9PFLStZw7JRYY0i o1ShlR0P6vqNl1x/ZeOU8LF/pbMhLhFrBlfyM3+YLXB9PJq0dXsViG1Bj1WALVJf QhY1bbwvAgMBAAECggEBAKcMzOERnBQynFgyL/l0WO59Gh172LOLZdbEYwDYDF/S gYUTn5fOBLGj55uIv3icaYddAiz20yj2ChcOZuefT6DKu9doPFYD3n0X3Uzdidcu ZOQfxj/9BIDreGXfgg6fI926aKHf9LVprX8r16AtcQRwmcjQDWZqN3uwD6OJSwwR xVeD2MuS2MrmRtIedfGhv7lWDpwvfvmTGzOxjnE+Xu5CtwuDiYpxblJ4GJQEq+eO ZQSeryT751C4QM6HqoHIWuz5nhPTZI/aFoRZYobxmqTLPzkD57qCZxe3E352GWNU B9kMbyEvnX8zzGEk6whCr9uG4uxhNd+6x6tyBeMJhokCgYEA8f4Y48klsTH0JEK9 UsdFLYYle6/Ty8dLeSb9kNOlYtMJPFbT5kzNb1mbBmzMqmXCJEB2sxhYt+s/gXIb cLVCOJAAXNQjSKxGm5XPu/Bx8TwymEabnz8dRil5RiAf8jUULAR8cWKaQ3rH9jX2 HFaX+UqgA9RXLt19+zc+Zb2J/+0CgYEA3KhjuyPLWckwwEyCr3N91s3HATNJ473z BZOuiNdBS8i/MJKjxi7rqi63zF7tHLS3GMYO3mCD1DBDSsYqvU5I6a72BManmF6F cJMuqbejaOZd+LMolpOBjPy9LMniySw45p6X3l5myNkhgh3eo2jde2b04tGjskGV HhvxwOZlEQsCgYBezrpZo9jMj1GjUzJxV/jWWRQeXUiRMcdz876sGv9UtHGN3kau l7B0y5pc7gtRRwTExyy6BfPcOqJqyJXPlnQXTPOXatVYB4ayNgNpEk7RwE/iMOeP gF6rulv1CWj6r6jzhd5rXcIqZdQptgJyH8rytDX0yiBOECDnZ0FfAt8qEQKBgBcE KYL3tNpktgUY9fi/Hz0ssblaVDbBNXw7b1Uuvszc37R9Vz/w3Pwfa2SR8kGwR/j5 j8t6XcXgUuSVzxd39vsJGPhekFTAZ0La1180nILwpJSwe2dZc4X1RvZJCLLbPgQw Pr8fMbF5lJkx7Gs3IQMiNiECpQSO+rLtT0ZDwf8JAoGBALxrJTe89kZ2BIC2Q5up cOdYFxEga4mrKXM1gIrmAAT35oijbKQIoMbP67VvG5tFUPuO65up0Zn/sV4h/M3b GGtqarieEzDAIl7GoWPhq6gIaOiYfoLZc2HHpxahUgYZSWcH65PM2bllZsGxrM6v r6xT0UPVu1fHWCHzUUR5eFy0 -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMoQIBAzCCDGcGCSqGSIb3DQEHAaCCDFgEggxUMIIMUDCCBwcGCSqGSIb3DQEHBqCCBvgwggb0AgEAMIIG7QYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIIBzh2Ko53OsCAggAgIIGwO3+A3BwZDy0kjr/mSaLCAGeNCYWHBlapBqrixdir6jIjOlNUfh6nk6EouX1A5kAZj33CkmMzXRFYFnqCFrOPFKHoPoSpFu6I+Zinoke8GEI11H4FClkDcWurro8nERo+ogGhJqWVvwY/BwZwE5332AgOsk+xF2AWWWOMrZKBrk+1FBeSmsjxaDolli+6omkd+e222i0/d5/QJTqWiUvDyjVmB3o0RlI2aL/LG2jDgaVYxVGdg/6MsoY6p6enFAJATFgYO2PqbsB/TAzVOFVD6sww7q1gx8DPkyMnieAJRdeaUKlRupe6O3akCVYp7mofVuMWkIsr7rvBvE9wITzuxKO3jPpZj7C7v1ltaAKkVkALI7RfT+ocGEaAbMdgBhfeD8jH4PkU39fwIxlxSqazTzkzeWCAIlctIE/gW65eWm4iOr02Viaxr6klNUnbxAd5fva9cJkg2JOEjzqBJGmrm+Ll148Vhd94xFSFA1RiaOMq58yiWTdxL8SZpidqX88HysiAK97UrQezSvBgjfWbXJJbUyn6+Fq3J6ht7GPBvxiUOSYW0bqoRoYf5q7tabuekrtmlf7uXJyEOsafrawwJLLLrgy9v72V92FTFdd2T0pXtxt0yJD8HV80y6SNgl42vVVcy6wCbTctZqRBYZeqzU69F0LVtemjYk3kDBGWoe9Dn9GFWrGcejsXJ/NW3L1hon89vC8VmH8vr07d+u39LQC+ajbODN1AgK18U+JZLl5QDvx5spdbANuZm1RKssA90QNEKiF74H7CDtvNU3PNHdVR8MfFQJq0OgSuji5ZsDWEkcKmG7EZmsYMCfEQbbypopx/Tf0IAe73WQzK9ArJnvKF+hIcSw64ilQ/MLcN1CrWa1uTorQmZSWyVorsAoStKNdp4D0MmXyhk+OM0ZC+k7IhlMG5Q8/kiQmHhdaNV2s1N0PNhZVb+zxeZiYB7v5eCjP1adQFRvZ4tQbCaYGsYR6utRUWFeMexw5F7TvHSutHEgnrTn75R2dFDB4kDXlOkDMPvRcnSnDAdQTHBiUoT6+sdhZKsC8rS6YgXW2nNIVFnSRNRzHVJicPN/B+ltM2GR5V+l9U1n6fYLw8dFIqJ7ajV4AAij/kTcS3ZfRKOaXDI9A/YBLX2KnNgILXUg8798a/xJdtc5MZsmufoIdPPie42vmy/mTHcqI+GYXBf1AbQp5JEJnL9A8EtbAnwmLxk2PMv3yLm0Tx0k31d3XRJ3a7cCLC9GyuDLesztQo7GnACvxOnnDEwdphUK60l4LjT9Vfii95QHuoZi0URMf98Wi8sljy2nzV4Kn6BCu+dE8c6viFCUr49cMsVMgELaGnEPkDvx83bkBX8uO53vrp0F4zHW2p3G0x7FIrMWypRWbyoUT/XF8WdKHS2J+5DsUh37hPN6/Gjneb7VR11cBJTr21jUPTiJ5YakbtfHPGGDP4PL/z03tVqXTL2Y22COiSNvh7r/brtO/n88RGEojggnUhvaUzFg3vyKqWO47wVG8TvA6fVxPzC/8NtUElAXJwOyxtLOAu8K5XbyEdE/XBmS31ad+YYF8OjVs7eK0+NKLtIR+6Q7+618KPayrk5M9yaemztDI/6+CidHlDZf8pEvIe+IWEs19skhMlY3tSZT5SWhoR3kUKT/gs297vlfjJpLlYxQJEaD4nMAJ++X7sJAe14hyz36A/FLpaaat1cEbBe8MWvTmJut2j7Op5Me6+TOUM8XFHpZptMAt1SARjAGzb+ViE0VgWsHSCCPl66lXxeHmg1fMJsXvhdAhVav8zKmb5li+21zIq1bMfDxmOkT3UCGrC1lEWenMNQ39CUz8d2bkghJN4BP99skiUbFZNbJuy4Kgl+AEef+pRDpwY5Dn4U1Jj63z9aPD8nnlwXi7+h41Ca+f5jIOnnKcpVpgn+mIoJBkfR9SYobJVJL8/JHhUiCWbEhiM6DAtxuc5LBOhVqZzFAJPqlo3hzemNmX5L/zUZD6Ou3ndKFEALwGTpHBU8/O9cjjIkT6ouTbkMdmSYQcO+O9Beg0BkqaeN/qKb0LC3GhK9KixbWCCsCcYReFAFIYvRRNulonMt2ZedBKE2KxxKbTQXYQtMLDFaZ50Dsg3H5Mq/FIygfjv/5W+alTFT4yFzjN1ovgUMF4HDiwCe0BC7xWbYt2yAUkJYRlTR2gRiXr8510MONr7oaiwf62hadqwpViOcA1l8B/fzSX0otXaZPahstljDXLuwsVyq/H7aNgZHSxoKVqJp7GA20mF5uunOvBSqtS2TXl3P5UZW+oCElayWzrRarB3T05BTCCBUEGCSqGSIb3DQEHAaCCBTIEggUuMIIFKjCCBSYGCyqGSIb3DQEMCgECoIIE7jCCBOowHAYKKoZIhvcNAQwBAzAOBAhc2FWO0/YPbAICCAAEggTINfn06vdDJugI8cpLqiU8xArpr1Tf8/I+U2kBFB9DCr/cT4VLE3h3CPyj3sViU0pp8rDBaZLu3x1Gwszzo/+XyZ9BxgtJsAReZ4fq8EGw6ySU4BeCOrlAH0UFaN0SUlMXgjl0sG9hyptg2sBc/Nhqwd0HML9y8cvIG6fGLE4TKLMezyGRKagG1Oxq9Y+NwPOcenPYW7FOwjvuWDfI6aSdKtd8N3dc8QpAqrEH65o36aL2SZXUr0qPHKbGtMCL8AedOpU3RC4LgZiF2dn1nswHVabTdhcxDEOhPNgnzJejlqqMDUt16xlwYaPzUJVXQp4QNSo/fy0BWqImBssW+5eagLdsQtoV/dC4r4nsvOY7f/T+NY+LqBXLVZXcOhaS/lW3RHqVMXvcxhCySYTPNndEiH7Z5Bw2ez3l2uMiK7b+wguNgdHTfbghVnjAGxfIcsExfaAudOfkd36xTFc8JSmyOeRCB5tDv1DUFVbTcGh4xl8jG/sjjayyA+2kDALvgX59pBUcqPlyLNFGK6kvRK3Jd+MEoZDR3TiCXzuoeFyleP5TClmd+kszVu4TZsWOwRrbCf6oQlSzW+kU0epxBqSop4QRCbC/Xwy/VqIA4ROxHLrdmLMjrMQVbXIE4JiFb33dpnkIGi1ChRT6EXqgVRIcmkT1CDD4jhYqF2tDU4/MivDAFWVYqkDGn8T0SnmrS7quPcLbTMPcM8gjKkfx+AmxYTEG5YYLbk56BvgBarquWbDndfppeWoMM4iLNfPLit5ZR/6iHHWeTwc1DHtmLKuFB6KrHl3OiULTfOpxmU7kFNxk8mt5jvr9yvPPqh66XlsXbMOS5/HvAXonkdFuvFjn6BD5ucaxPDb9PBsVkJkx2TyzXNDTrxiBu2DMQJiBwhz9nsrhjHKgM+CTXrqLA4XuMQ5NucQ6ZiqJR6ipn3u2fTLyKlq+GVrzkkGhpHy87vWxm2Z1rePUR5k6rrMF2aFDWyGqMTKMW0Lchf0Gij5UDaU4VRFOwfglDNGHCK4mMzUcdkUSDaZ4BqkE0RHNrMzXuBdWnhADFQ6sxR7kPKYi0Q58xVpZNTxlEMpxh+QNzVKlHiQreWRF0OyUlYyBTNQos5gs0FCQLW5V4jfQtDzXOGt8iGn1CPWDCchOSpjZhDJ15CRi2gHS0knRNSInZoYtARw1GahnbtP4OtMOso5RYysVWYAep+ZBx7Dpgl4pEfk7UuE7E13ztfyN7pq9xsLeWiYBl1jWRQYAeJCxoq4ZZ1zCapBx3+EOdsj3aTwm9EydOaq3b7erirqDpnZ0lVcIflN8tzpjroxvJB4Vjtai3xthw+bXbWkQPeMvTMMjDwva1/eEiESmQQAa/xBS6gaJc3bs+h17wNakT3YTuR56KLRsSjoOx6Ru0dcHHZ+RkTLDmPVMUPWMHR/3lAsPpZ1I0gpNaT1Zsno2hQmAsv2d6J863wIlHk2TbsmLLzsyAtSUVbC/e5s35B5QZMn9iByscDGriAC4CHHt4d/LH3cAwHqTe9flDZ1pXLgwLp5vC6ujMiPPm0oxteq7Zn+CQGJsINAe6zKMEh6Mtud+pczywK8JXcrsk77jh9Qiu9JfGRyt622aVgdLTkdb6KNO868bGn1elwp81UNOMSUwIwYJKoZIhvcNAQkVMRYEFGVTVnjXPgtESzFESS3uK4V4OCToMDEwITAJBgUrDgMCGgUABBSR2p4t0vmKuxPoqXaT3LihKdXDNwQIBTTq4k4CH+oCAggA' 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 = 'MA-0020501' UPDATE Comprobante_Digital SET Cd_Motivo = '02', Cd_Folio_Sustitucion = '', Fecha_Ult_Modif = '2025-10-06 18:01:39', Oper_Ult_Modif = 'OSALES' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = 'MA-0020501' SELECT GetDate() as Fecha SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento='MA-0020501' 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 = 'MA-0020501' 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 = 'OSALES' 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 = 'MA-0020501' 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 = 'MA-0020501' 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 = 'MA-0020501' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = 'MA-0020790' 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 = 'MA-0020501' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = 'MA-0020501' 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 = 'MA-0020501' 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 = 'MA-0020501' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = 'MA-0020501' 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 = 'CP' 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', 'MA-0020501', 'BAJA', 'FA004', GETDATE(), 'OSALES')