SELECT 'CCO2011091U5' AS RFCE, 'QPE010322184' AS RFCR, '9018D2C5-6AB2-4E48-9565-6EAC00D8B584' AS UUID, '4186.15' AS Total, '-----BEGIN CERTIFICATE----- MIIGKDCCBBCgAwIBAgIUMDAwMDEwMDAwMDA3MTE3MDA4ODIwDQYJKoZIhvcNAQEL BQAwggGVMTUwMwYDVQQDDCxBQyBERUwgU0VSVklDSU8gREUgQURNSU5JU1RSQUNJ T04gVFJJQlVUQVJJQTEuMCwGA1UECgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJ T04gVFJJQlVUQVJJQTEaMBgGA1UECwwRU0FULUlFUyBBdXRob3JpdHkxMjAwBgkq hkiG9w0BCQEWI3NlcnZpY2lvc2FsY29udHJpYnV5ZW50ZUBzYXQuZ29iLm14MSYw JAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVycmVybzEOMAwGA1UEEQwF MDYzMDAxCzAJBgNVBAYTAk1YMQ0wCwYDVQQIDARDRE1YMRMwEQYDVQQHDApDVUFV SFRFTU9DMRUwEwYDVQQtEwxTQVQ5NzA3MDFOTjMxXDBaBgkqhkiG9w0BCQITTXJl c3BvbnNhYmxlOiBBRE1JTklTVFJBQ0lPTiBDRU5UUkFMIERFIFNFUlZJQ0lPUyBU UklCVVRBUklPUyBBTCBDT05UUklCVVlFTlRFMB4XDTI0MTEyNzIyMjgxMFoXDTI4 MTEyNzIyMjgxMFowgeUxLTArBgNVBAMTJENPTUVSQ0lBTElaQURPUkEgQ0hPQkkg UyBERSBSTCBERSBDVjEtMCsGA1UEKRMkQ09NRVJDSUFMSVpBRE9SQSBDSE9CSSBT IERFIFJMIERFIENWMS0wKwYDVQQKEyRDT01FUkNJQUxJWkFET1JBIENIT0JJIFMg REUgUkwgREUgQ1YxJTAjBgNVBC0THENDTzIwMTEwOTFVNSAvIE1PTUc5MDA2MjFE VzgxHjAcBgNVBAUTFSAvIE1PTUc5MDA2MjFIWU5TTkIwNzEPMA0GA1UECxMGTWF0 cml6MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAiQPPI7DypdQjIgzU nGiPg+Q+4EGwe34vO2RMxziyTRz5B2XQa1/vlP7XJxVUaMNCFx5EnLYNLp2fRCjT a5Y4MJ9zggZ0txvanDgVPgN87qF9R4k0dZs/XDEBuFM8QhLe4yNK7ZrtvkrPf0fB qYBA1HxVZ+4eIsdVCCpBC+OEX/Ll/wI9O2emVtlP6QSRLCiQPRdfS0MjzUM57Ymr IiG6I/2ImqfFwXrQwBf0MwL1o6StwonNM5qgMSJ6fnfwbTIr6xqLDFjkQjM5oYWe 2KiHPhgACo40qaJES5hvwSu1Dv4jZnTnU4XF/7nHTRe1CU7d1/mpn/26WqwSq8fz rwjnSwIDAQABox0wGzAMBgNVHRMBAf8EAjAAMAsGA1UdDwQEAwIGwDANBgkqhkiG 9w0BAQsFAAOCAgEAsu+XtLgFATqAjhGW/YjP8xzeL9qPXdUua1T8PDjaynhHq+Zy FQiDdP5ReX3QtLIEUWlKIliqpEYeAFC5lftJIQ6KH3W50U1KWmtKH+SbkchVF/tg ZzfX3+k0azNbgpGhjzlIG7Q7xFbP1oc3ikPFsKMsxIJvyFonw0K+OZK0BrBfh7v4 DeOwzNjux5N2orD5HHEjPiO4Uvu2J8IfdIotQxzwIouE6KUT603mopUEeFoYPRVW Vkdy5NM+AG9nJ97HgkjBqui31vxRqWoLdUNKUaXQJyxmiCHMs5gcAt9/cA0TwJrK 2ohmE0LyeDsI0BNfddUt6fAw8A66T9BxAy71HZifGRXeldvi7OvEa8hlvdH95kdF DftwicG75k8JUYZF1+ZaPvG+4wFm3zXgocolVKyl+ne/ZRDu5ouIjlhP/xPT6PX/ oX57a+kZkSd1KLLn6Vp+nEYpXE/LGQpmnDIjxiY7dcNpKiEFPXG/PL9fEHMjAKS8 8Pc+CSuvk+Ev34warUwJY0uQDgs2INzlntIPuUyUOGah7fMv4MmAg7c5YURKST58 rzPDNpV3BC7surp4txwF7lWFzh4uIUQ8HfE7emSc6C9ZI2/snyl6yaPGPEYnnQw7 6Gyh9yALx0H0tKF9DrKYk2S64ydbvDTyycjPEx/zNOryd/rf5W/wXgZNoEo= -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCJA88jsPKl1CMi DNScaI+D5D7gQbB7fi87ZEzHOLJNHPkHZdBrX++U/tcnFVRow0IXHkSctg0unZ9E KNNrljgwn3OCBnS3G9qcOBU+A3zuoX1HiTR1mz9cMQG4UzxCEt7jI0rtmu2+Ss9/ R8GpgEDUfFVn7h4ix1UIKkEL44Rf8uX/Aj07Z6ZW2U/pBJEsKJA9F19LQyPNQznt iasiIboj/Yiap8XBetDAF/QzAvWjpK3Cic0zmqAxInp+d/BtMivrGosMWORCMzmh hZ7YqIc+GAAKjjSpokRLmG/BK7UO/iNmdOdThcX/ucdNF7UJTt3X+amf/bparBKr x/OvCOdLAgMBAAECggEAB2R9OJ/Dd88KVjv6/LVniOY3vkHNE9yrD7lJqzYT6LU3 en6z0BdNBez6DtHHzB884aJwcUQhUfKPNU4+mf9w6K6xvMI8aeTG1sbv3nixtO5h pApzGiVWNdMvFJLpHWeHPxoYYNmLGklPCL8GY+7XkJ9kvEbMuXOn0tj0yX9tFQAh 0E2p+mi/ODeTWTEN3gt/X7+UdKQtvQBzUlKTewMy9ppbfA7F6hAr+5+Mr8HDFn3K 90yZFaq1ox/SjBjKJuV1D5ywozaw5n+GZkIl3bAau3WsMuo6Q+JJnzwwmU3La0+z 3tC0uyw9DCxVASfWMqw/kA8OCFn+6CgvqJuRNfm8gQKBgQDBWbBQ+HiqYoDujNTT Mgafgp1XdKIJV3a1RuJnjteli3L0itnn6YIZccBi+AjwgHH3bQo/Zt+tfsAKDHew 1DIWkGXkaxA57oYETO8zA8cq9/lpVhVK817OLjLy4H1TPEG0qKD7mXerLWaLGq3j 43RVpdW13WTkML+uiMq7U/1a/QKBgQC1aR9eWw/hPf0wpylwbnM2kyr0/7Sfll1K iBvW3PEITXDxbOO7nHQ5WRdBWl1vHC8hsZ7NWJ5UKCSijPspnID0jYwW/71c62R0 n0NMkUM2Xmp8mV1Q8ZcLbzhSx1A2TeBmvX8aXCgm9GWvDruHaNyv2QvDuxDIG4Jp 3v2q7DUR5wKBgAFecTEhkTkjmWYW+SrFn+ZhNlv4J22JgP2nktLI4B377sRsdz59 GL61X3dT6jxJrITj8L6iK9M+on1vuSk3V2NxgkcruuGuHqTJJqhlznMvbkSgp2Xw cytiiFnP3RNJye1NhFZDr+U2XRN/DNwgMCKrGeg/uQckkTbbIRRSc+jBAoGBAI/b NtbaG3OgdqEYThIsZAzJE22JQLC0ynIKERmHx1OwJXotwUHLRZccgQaAJEux6+Yq NiXcumE+HB8S8TEEPHaxsH+keYOv3s9kZDfZkZURthvsekVv7zlQDzgFeiQ2CVcv uhUrM2QAtonlguxUSXzg/yVNuHcW6YoPHNVnzoXNAoGASHv7Wvc0ZDr1VMOx/2pV INkvtB/i7EM2/rgStDJ7dZ1sgpFtEjSFDlWutlLluK8iwzDi1OvX/9AbiunJIgIU 8l8bQyFRivj5ABhN5xKD+7arDJ1UODgdrH/bNzYriFIrnZQJn2lJ53EULNXUdfIx sPE7aLHRXI7+xduZkf4n6cc= -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMaQIBAzCCDC8GCSqGSIb3DQEHAaCCDCAEggwcMIIMGDCCBs8GCSqGSIb3DQEHBqCCBsAwgga8AgEAMIIGtQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIwLnDPbl3oC0CAggAgIIGiA9Bxwqi3tqtvFdjp5mHlZ5JUH7MqkfPT8RJ83SaTnqofpLSrp1qIsL2vo+SjW7Anol/Yalrnfp38Y0CUN1DZOBuwSqXIV7d0mNG7WLnJviuCEMZ87DG3h5Q0EWJcvbfA866MoYf2afl/iyz54w5y5+SJ0x6odiR5KXTAu0e6rTJ8eTZ7RfYZCBlXT6rl+FcWbkqwHgIOkZzCa0WCAeMnMq/hLSAqh1fFTg2SOI92Wlo/uzgUgswWOvxeYFZqRtOXJuZjhDZRSdWaZnhv1PXGsmZSTydOcgOVKvhXuKvhBf5dIv7BcgMaVRc+hEktt0v5pkHtNgaSowGmLqGZSW98jI2pRZeJ1bkK3b8qqFaMcNbBuGg9HzBFuP/3ZdGgMf9CLMFDQfam9YB8xDs3UhLewUILWWv+ABxRPRVKWYKOvunbOk3CJfcpoCj93FEiCzyr1im7kbOLH/8uj/KK4ASRNrf72SLiOW2Y0yldMA6l6eC/l11Zaa/ssFcVYr2IGFgDOJHsQWodCw0CRhj1ExlKD17plWMOPUyUDgqod2NazAHzmUnFaLMq+rqsVdwrsPOLltV6yu77x1LdaqGPXhmEJcFdLqOYlcuYRT7tO1Q9bho1fAueeKJfYiIbl9Iv3UB/h7/T7OK9+EYMR3wrW4IPjgP+K52jlz338aD5dEGjVUYr9PM+1E+U9MC3mLtrf5flP2QhNrWdHGXocgYwWvrIcR6mjD41/mWwQYTVtfxwhLDR9jHF1HyyxMtG6ddjPe5rrpYhUzobt5YuLyTHjy24QHVS2f8PYV1Q6jR3rWoQ8dtLIBZCXLdjMqmdmt0w5FRSt5vV/+696z+7an8FGd+zqRc4eJfOeC5hxaI275a6o7ZORICQqAOx5cJHa9+3bwelhsf+4OYg2q1s4DDsRLDc4c9dF3zSfgTCEq9v4qRtiznLbZDOcWVN/z+XI4xwob2bym1lTZlGhgIKpylSxDbearIk6lisvUXshRysHUlYd2QedZEGdHfYZE+uzZYb1c451igGsi7jQJ0O02QnijLJhkAziFtS105c0wWB075Xx9UNl9XVctYZ8qA1z2xpY2M9T50WAsqaj5lKzItAtq1WQ0uKhEBA9OEokouQ4PPUXu8LB5zkwj7dyXe1G+wjZcCoA6ygEBVVjXY5bLCTEqeuptmswc1V5mSs/ixNHbCNzbcrhaQ2u/SzAW+g2gVDQLdQ0Yurj6Zsh+RbzxonEraiUGM+Z+gdFMTANUISXW1GqfABUDsv5e3YQ7ClbiLICpGUuOcGExjgyc9ShvXYEDhmTvJi9UYWYRjhBdk02M6353pOwJxHtSIHflp8zl6Imdt9BncjM8+7aVaagBmKw+GeEak7E9L/EAQVMgM/qkIKCAk2WwJiDUUseHvdwuXFXi05QpGgyVxm5Da85a/FhU0Fye/IM1o4IvCN2FDbVJDaFktQCz1NVXPuGPDHdjyOc2tEyOcFoztAgSveQ4H6UQgKuBOMqRJHyvwmSborJIx0wB5Xeb2cfEeHCt8nZazloLiCJuCKxilYLnt/2o0CPgX2js7KGC2PdNgDBif/XY1h58VQFpLqZp112AZgebEIsYh78wLiaWpMBp5GTrAdd5QNp3WT5EXKIgupEvxNUsFX2s6mIbYwIw7KasIJ5x9IKl2bQO4De1L5Qykyl6rBAGX3/A5N2ag+A9UVp3kq1rhwJvd2AMAU9w1cbbktZYhS2zOCz6Vv4Xfhq3hpAowfLS1jjmv5/+YtBUDeclarjJXIYOm4/uKQVkGR0U7ZTJ/h8d9/NHlxZrPPJjHAUw4lya/7xqzqRoyHQYPbW5rbtyuVIZJjv2kaOb9SjwFsXfSCclZQF6a7/9gn12LxE7VZ0i0nA3ndvCjSPM+QAssaFHeIDtg9XsfSiaQ0los2MeAOdlMYE8nzmkdTFIhUS9ioRURUP1dyZQQzfTJZyhDrUnkZPVQFysQL90CWdCxT5D3PQJyZ29xvq1eH8DKABNTcTaBMitJrnFj296dSq8ZMuo93llCbvhcFAL7Ew8hgRAfCnKaDALZ7Wnt50OwWhSrX8xf251V8vtZfNh5ZcUG5LSb27aavM50eQCcSUQHg0BbJDyggVh9eYsfB6MlOtwggPLqWd6siJoSyBXXNEmZ+2smzJNEwZ+PcUNUrbLpgzEnM/C0kOZLsu7tfsaTEgK7H/4wboS0IJXkD0DUKE2pK9Z5Bij2pTBjYtXDRhYwggVBBgkqhkiG9w0BBwGgggUyBIIFLjCCBSowggUmBgsqhkiG9w0BDAoBAqCCBO4wggTqMBwGCiqGSIb3DQEMAQMwDgQIfrICkNN0qB0CAggABIIEyOHDsphoYO2i+NQCvrCTV7pfKGJRPa8yCezscS7wey3/ijCG/NLV604yaAQtDbk2WaxRiYv6JpwulURcmOb/5CAG2relxuVBVoEe6DGz5+jyijGcujYRdP7TYd3s0EHn6t1dZH3ri3DgC3ofs9qgZO0jWVuMC4mu2lMFG3ni2xPkQFV99Pm8YG0HVFzvi5CvwXhLo+AFeeeXJk10csOrks6spLd1/6oWd2iG4IjqRiDj5gBRoddAfQP2PdktbKMZzAz7HxHZQDVJxVfhJ3sE7Agy/8u2ZRrY19W9/Dm+UX7k3TTVOnoq6goO8RONtOp1CN2UoOryKMTzEUoPrmxvGnwp+T1ieCxImVB1K6/eZhTr/6i7d1C3u34lhjWpfpPoyu5CdEDmlmiwI4uSfPQM0Yvh9CCnhpcglXJeKdjTMRh4vd0QCoxITFZhoIGwHoh8fT10kUom1K/yw55kEGFUx9YvonZHUIOxKJRXlgwl3vv3Q1jvgzjPi5K0FwChiz9ndzMYtEQJJQlsh69HxPuUui0hYi/D/GefdCTjm4SdkWbD3YRD1Cd9LaKFVDB1IF7E4RatOarVXprp6dlFqM6bYCIpBYjCrzfnVcqSBzw/VoQrtvzTq1JNYgXx/mjzk5dqlpyIxBAOmHPJolEucL7vWhoxNK1rCGm5g9OcHzEWlqyskGqHz5O3sB8Uz/VYQTn+SxwE4hZlaBq77455IW0XxXxtkg2YdemQRJy8F6qT64g8AM0Iz8bwirhBenUJQpQqem5TVGGC1ffU0T1ADsvwBjhJVGUjPodhtyFcrTL1WPDSF7RVeeRfmDmwV4grsy/5AG/S9v8WrR/S73praqlzCdnAGHAskEJJfihJty4vhlSA8pM0dY5mf4lHIp0z6yj4VGW1WK5Wp4nzCrYcvwvEqCt3dN01mgrd9jUuWX85WqBJ9JZhkxXsebd0dhpCLmDEDyDMtWDx+vyGSEHDnf1A08tMCcYZB5OprC5Gr1QkAM1iFHGHSosBhKPGCFEfaNnvlu5YDNPGS55/7wOaX7rtWndWSXy0IjCduARyh4RrkOYp1RmKi1wD6hXYNowDTeP2pbKK/t4pihaBk4t/tEnRP1RBvpuHzwdBW3Grey6NgejWff1lxGt8leI5yF6+aBEpgqQP9EkIY/xmw1sIdv+XBaYiAjBcKO31G4GETHNwdHyLde1MCXdK7TXvFCzyEwmZgATyqw9kkuR4/IXzuWvFLvpnP+6yd+kMjZTW9A/bPXdnbpw30qhe8uN9JxZAW+WWTdlfOFjCiwSSAZ5FAksZisCOiTNYLd0kuakQ2OlBYJ1JfsXBhn2VpR8JXU4mPnhO97Psr6bM+DfkmnUKlAwND33wkO2IbIHjoTWSI32uv59dgQGL6CR4fT+kQLsuehn0BEHKlvZ+CsIbMC/so6xYlwwZMpqiVkHP30eSKUMnzXyaepJo5tzaTNt4HTSEJ0f7DxBf9eK1EecqXEY/fSFOYpvTBOvgzv7dpshqS4Tl7lRuCWoKt5JRvA0OdHs662PBf7wHuZnZRgAY7NUE7Z8HkuV0NWtbGrf6C5lGl8/MxdQKkydj5Jaz89j88nEOxDht0DLaHfjrIU7xb1chiFzuxE770a1EXGacVjElMCMGCSqGSIb3DQEJFTEWBBT4Ogr7nGZaqS0L+QHMhvOuOHuC5zAxMCEwCQYFKw4DAhoFAAQUniHXqVtSbQr389adKYTriPBH8J4ECOs0VRkan2IDAgIIAA==' 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 Nota_Credito.Nc_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 Nota_Credito INNER JOIN Factura_Serie Factura_Serie ON Nota_Credito.Nc_Serie = Factura_Serie.Fs_Cve_Factura_Serie INNER JOIN Comprobante_Digital ON Cd_Tabla = 'NOTA_CREDITO' AND Cd_Documento = Nota_Credito.Nc_Folio WHERE Nota_Credito.Nc_Folio = '01-0000018' UPDATE Comprobante_Digital SET Cd_Motivo = '02', Cd_Folio_Sustitucion = '', Fecha_Ult_Modif = '2026-02-06 18:38:43', Oper_Ult_Modif = 'ROSY' WHERE Cd_Tabla = 'NOTA_CREDITO' AND Cd_Documento = '01-0000018' SELECT GetDate() as Fecha SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'NOTA_CREDITO' AND Cd_Documento='01-0000018' 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 = 'NOTA_CREDITO' AND Cd_Documento = '01-0000018' 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 = 'ROSY' 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 = 'NOTA_CREDITO' AND Cd_Documento = '01-0000018' SELECT Nota_Credito.Es_Cve_Estado AS STDoc, ISNULL(Comprobante_Digital.Es_Cve_Estado,'NE') AS STComp, Nota_Credito.Nc_Tabla as Tabla, Nota_Credito.Nc_Documento as Documento FROM Nota_Credito LEFT JOIN Comprobante_Digital ON Cd_Tabla = 'NOTA_CREDITO' AND Cd_Documento = Nota_Credito.Nc_Folio WHERE Nota_Credito.Nc_Folio = '01-0000018' 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 = 'N' AND Fs_Tipo IN ('02', '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', 'Nota_Credito', '01-0000018', 'BAJA', 'NC001', GETDATE(), 'ROSY') DELETE FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Nota_Credito' AND Tdl_Documento = '01-0000018' AND Tdl_Tipo = 'BAJA' AND Tdl_Transaccion = 'NC001' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '10' AND Perfil = '038' AND Menu = 'NC001' AND Restriccion = 'COMBAJA' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'COMBAJA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_COMENTARIO_CANCELACION' SELECT TOP 1 Tdl_Tabla, Tdl_Fecha, Tdl_Transaccion FROM Transaccion_Documento_Log WHERE Tdl_Tipo = 'ALTA' AND Tdl_Tabla = 'Nota_Credito' AND Transaccion_Documento_Log.Tdl_Documento = '01-0000018' ORDER BY Transaccion_Documento_Log.Tdl_Fecha DESC SELECT NULL FROM sysobjects WHERE sysobjects.Name = 'Transaccion_Documento_Log' AND type = 'U' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_VALIDA_BAJA' SELECT Es_Descripcion AS Nombre FROM Estado WHERE Es_Cve_Estado = 'AP' SELECT TOP 1 * FROM NOTA_CREDITO WHERE Nc_Folio = '01-0000018'