SELECT 'SMR0701293C4' AS RFCE, 'XAXX010101000' AS RFCR, '0F3049BA-7A97-4A36-B16A-F199D64293BA' AS UUID, '168' AS Total, '-----BEGIN CERTIFICATE----- MIIGWTCCBEGgAwIBAgIUMDAwMDEwMDAwMDA0MTE5Mzk5OTMwDQYJKoZIhvcNAQEL BQAwggGyMTgwNgYDVQQDDC9BLkMuIGRlbCBTZXJ2aWNpbyBkZSBBZG1pbmlzdHJh Y2nDs24gVHJpYnV0YXJpYTEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3Ry YWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBT ZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMR8wHQYJKoZIhvcNAQkBFhBhY29k c0BzYXQuZ29iLm14MSYwJAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVy cmVybzEOMAwGA1UEEQwFMDYzMDAxCzAJBgNVBAYTAk1YMRkwFwYDVQQIDBBEaXN0 cml0byBGZWRlcmFsMRQwEgYDVQQHDAtDdWF1aHTDqW1vYzEVMBMGA1UELRMMU0FU OTcwNzAxTk4zMV0wWwYJKoZIhvcNAQkCDE5SZXNwb25zYWJsZTogQWRtaW5pc3Ry YWNpw7NuIENlbnRyYWwgZGUgU2VydmljaW9zIFRyaWJ1dGFyaW9zIGFsIENvbnRy aWJ1eWVudGUwHhcNMTgwODI4MTUzMzIxWhcNMjIwODI4MTUzMzIxWjCB+TEwMC4G A1UEAxMnU0VSVklDSU9TIE1BUklOT1MgUklWSUVSQSBNQVlBIFNBIERFIENWMTAw LgYDVQQpEydTRVJWSUNJT1MgTUFSSU5PUyBSSVZJRVJBIE1BWUEgU0EgREUgQ1Yx MDAuBgNVBAoTJ1NFUlZJQ0lPUyBNQVJJTk9TIFJJVklFUkEgTUFZQSBTQSBERSBD VjElMCMGA1UELRMcU01SMDcwMTI5M0M0IC8gUkVPRTg5MDgyOTZMOTEeMBwGA1UE BRMVIC8gUkVPRTg5MDgyOUhWWllMUjAxMRowGAYDVQQLExFTRVJWSUNJT1MgTUFS SU5PUzCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAMEXuQMZsaHSOFrM VSXkPe2XQA5Y7PC46k+h4tPTp2DSCWQp86bM5t4Fn7QR7+41BQKet8ng6hYoFTE+ XUVvKbRKT95CkWklflQY2BcS6EtyuPWq02aGZn0gjdQRxMkUsz0/BBbjXZLvUYBH y/LNBpG+1QovP6gUN+f+InvMGTTs2Qtr/6STZcI4JrxnyA7F2KR4YDcs3FFOKtca S5stK7O7gojQLC57X/VaEY2jBI04cMI3uwSsW9DiSiDKMaaJZMEb0rfy77CUN3wa 1cqt7x14krLQZKMZQdG7LQKH74yyCVfQnh3c0ZpmoVWWO/Yn269NJPPk1Cp9j8w5 wSnRT8sCAwEAAaMdMBswDAYDVR0TAQH/BAIwADALBgNVHQ8EBAMCBsAwDQYJKoZI hvcNAQELBQADggIBAJ+zfgynCG43gniAzvMxbUMo8/ZW25IYbyDiUptoBpxsG9Hj HD2DUlVXPItzFpe+WJAaNq3p0jRPyveGafv7Go/tKXOe1Mq0G3YcCoiuuf4DA52n FUCsVObnad/aNYXkKuIiTzyUTgm5jVNGF1nlpEjlxdUYan0RYJ14s4/KNhzxcvXq 2MfsnTQvHXqP5EARleV0B9eV8QHkVBzREVnHXaM/B+x9BAIwnVi8aJmyi2HJCcwv 7RP6p7wWm4r3U70DCsLWc/W7RONCIjN3DnTzZNcTBM0sENCUL6gtp3NQSdeykUhz A6VuJNvBl6W1DkmSZR6+9duJyib5I3Z+YJDy72q9AZ9wrwetxF1R3mVSJ4LnHPir HK8DR4k0P0IrYQ1Z4PSRPEZpCUDP/GIPceIldN4a+50e+AKBeCD54Rb0yz3DrJu7 ytlAt4YONbq0GE78h9Gi6iqabkC3eeSlvvvKf42+8G6Z7nf11cBB84T90cHp3lOW RGEc/Psu0FYNpmzeZp/5VPpc395SmVXSU/au4ttRv7Gkwge9eOmvTRcE3qBoP9xK FPj4qJIV1NWtXJPn683dhDoTi1XAfQZx6xwa3vM0hKCXkWHBO5KuXLp2g0kCGr6i RsaQsPt0wvJyEeK2YW5bfKMWwrQDpR6708FtKyaQ6C8HskzjyUpjaQNvY5Kg -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDBF7kDGbGh0jha zFUl5D3tl0AOWOzwuOpPoeLT06dg0glkKfOmzObeBZ+0Ee/uNQUCnrfJ4OoWKBUx Pl1Fbym0Sk/eQpFpJX5UGNgXEuhLcrj1qtNmhmZ9II3UEcTJFLM9PwQW412S71GA R8vyzQaRvtUKLz+oFDfn/iJ7zBk07NkLa/+kk2XCOCa8Z8gOxdikeGA3LNxRTirX GkubLSuzu4KI0Cwue1/1WhGNowSNOHDCN7sErFvQ4kogyjGmiWTBG9K38u+wlDd8 GtXKre8deJKy0GSjGUHRuy0Ch++MsglX0J4d3NGaZqFVljv2J9uvTSTz5NQqfY/M OcEp0U/LAgMBAAECggEBAJAT6GwEzwNk/cHad6p3XTIcSqKp/do80DEtJThT1K+s 6W8A0ppih92gqqLNQ48lpqBm19Jd7a0sqWt+ElCN+rtZO7EnUKL5ZALSKuNEq2oo pxRAK89zd6PkF4/m1kQIGxoXHDEL5DWQNusWJ3r7OuyjTQl1afU7aN/FQ+vFxgUz bT+6SjfuYXALJK4erb0CFwB9q7oaMMunARXhriXa3d2OI+rXDh3DVx34dnN5YdCf Ou7CD0ciT49TwpRG+drsbsR0BVSf4S2/GQFqBqKVfWdkXcoUSNUcQUb5tXdEcmEB VxHax6+hwoUQErzyLYpox9YT6Z4vt2daHTqqr2Q6HpECgYEA6EBoU1uADTEruSbI jNMPEsyOc76QP3aMSX+8refoMvev/ZWIkYD25EnpebVq6fl6ypS8a+gQ9He4jBrC 1WOdcVm9m8zZUVw3g4E+UYGTMiCPSwP/eKQfhWtuNqMEnnzoWNs3K1K8SPDG8hGc Zxbj5lUE876JRWl6dz+VLwKvxWkCgYEA1NZC/cytQUdfVlbiEXbcUuuRYxqrPslT W9+0KXfwuaOqTpGL3/xdnlsJYFkWIHC70w1+1lfNVl4dHvtmDowgmfqdqNB32x7/ 6FVJWoBVcGj1gMDUX0qBsZ6RNFSKbCfwTYhPoDtP7mw5SwI3+s1m1/a3s2Nopb76 acHDdnW2QRMCgYBKqjIf4kGnfBBPZM2CoHOvGn4Nbc0X6fetxVgWHIEEqaY1gvY1 uN0mhTB/BTjK4X59VBXDJwcUYMy+lffe/DhocW5IgTG4O0pJh6pOL7bvnZITjsR5 t2G+1cvH2t6oSQW1UzxIPD/1vxpmRg0fAzffG6QM7EtbOk65uYIva9CwSQKBgCs6 hYrFCp+KnouLxAjmCmPxIqttXEC5ZWvwqMgPa15ZJpskprNMr7sdJG9kSME4BH4e bJeeZ79WCDYlu5nSzkBYDbOe++kOh82pnOd7z16wgsSu5bOhD2yDF1z4mtDS39Tv jbSut1JmutBIWBRhqbTNkIwn8bZQbs4SI+AokmbvAoGACdif226+K3Cp4Xxwv0QB JKoZmpsBGifbDOMln+GHnEW2QN2C/P0ixpPWskfpH1TmpusXgtpDSa/N2DE5HKnV H6gRSTA2e6/sIhKoHdE3Kc6BQDyyXHiFar/hlo47YWLRzJih4YGGgEfGv0v+Isos XZKrcvjPE8ZqCU8dqiksbLU= -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMmQIBAzCCDF8GCSqGSIb3DQEHAaCCDFAEggxMMIIMSDCCBv8GCSqGSIb3DQEHBqCCBvAwggbsAgEAMIIG5QYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIcvPJWBZXFfACAggAgIIGuM4cp74opHMeC5PLgV9ZcCf8uCKiUBHbHLxMpdnuz1x+3wBi16TM1S+uSNxpyhrXxZh7dWinqlzooXUPpxFC2cDVApWunoFTVh/hl3hV5D6eYZCTznQr4VV4WCS9xnWRl5zq5ZdJeJ9gk5Yvn5+JflbDmL/m40A+w/CpusC90NdWrruru6wUAgDOoCmrYfLZWngOJPsqLTktZMW1Z1eTeL4wrXX3tLKc6nnRhUfZD6kKfeDUjIWSoldmckSvH0rHtJWb038VS9W183+MafpY7NY8SfulmbpBkwy+ATr4PunIdOvOwWe0RTMoMwqyYbvzCE4t93zwxjbnRGKn5phG5wMYZwAP0C20LpblLBZ34X6HkldxIsWHDHF5F2T/Qb5NPNNseLkolNKrGMzF0CmVwjNzBCaLDoGgkDH0NZbDymOAAel5mK3hs6RSe5njmabjdY1JM29qc4m4hTM8YEf+G1Nf2rS2aM0KRNdfEUAqpP8l7GkFqX5eZj5pSxSb8p9AmhVr0OY+9obTTHLcnCWO5qIyBLuzkVbQJHWCKtwLi5Oy5dUFP6x9SsAgxokWX1+/kppqpKQLKuZ6H5oWLZkNy6HkuB1uan9gNU9b910Ck1Eh+UGnvamSYd/GmNRnqX3nr6vcFXC6DJ/kZG3GhDUsHPJP5S+1+TnKL0a8MBrxa8tj5WufClnFIKEfGXwJU3SgNsQd42iyIr0PaqrbmEGbxE/eMRsQNafZwltaik5Y2whcRtP+y2tVul9JaECS4r1zSMGskWKBdrzt+sGCyxirhPbhSqzu0HLL3hk1d03sGMOyCG44FI0MfQK9nD1AGVnQeq95UBwsfUK44KBGfxKil1Y6A4pnChmWJKb/BMRB8lAESZzS2tUvw8Vw6LEq4RmCigAIZp/u/jKsl6SSq/7vbL5r7iaitEtTMebegZXfHjNJYk4v60C0POs5S3NGF4UICqB87R/qW8EV0gWh1dr+znUe39TRmKfwvGVu/ZSWvgbdZfSSgaYXTjqPEuXb24pP3XLrSgdpI1Pj9hrqJ8KhQkpZRWOj+Adte/jfCMlbrNoE4bSpoY6E9XMB3yuviOjWdvyhBmfsJenja4JtjJ3GUCazacuyTjgQB3qYnQQZsVDeT3FNdmy1DyZZ08QRBbabYmRB8fYrUezHz00qhYyt92SRaM9SykMkt7PoD3RUoX5K3Mc91rDgUY55h3wi+qU1JvNyCuiZErFTKXQ3II/9q+7WfQzFgkek3rqBBRkPW4hpqtYzP1nf7IIQ+QtW3HHbeWgAlXWOy1m+J3g4SS6gDUsCBi6wbK6EUEpChB1ChPTq/CFgWdPUDSYi99csazGHjO/nbCJqQwwoG7tT9b8Z2pT4Bgnx831XxbWo36ZzIXRHbJ2OH34xPE2lO0kiIEZoMjIEdT7GP8YdY7xEppayS9ViH0DYhQILxrP4WUyVgZtzQyp8HIGHyPPc7kdmRliYoPfgQ02pDk1CnoIqgIUZ1slqT8zfdzl5grQa/sWtInw2CfL9uo5e/wLZk3DBXKpKkcht3OtvOqxmTT3cBUI2OrM9Ki7ne54lGBBozJGZVj3kt2iMZYimnBSSaaYTw/NqcQbOB+3W6v8m40xi4JVriydPoCNRAZ8Ju5R72GFIO8Utd827vju87UToChDUXa3ofpCC2U3Izm+G58ldjwS359myvPcD0WO1LaaSqitt0YxDDVGYceHZlPiuUkrH1wPf9cSD4Ml0fWXLkpe0EzcktKiB+Md1fXYKXLNWP+satNzFCVjiXc2Ek5Ix3ALe6Rc0OBqydJOqsjdAgYCMcRTG+qMapiGem38AnrdyH2xa1cbIthNvStN2aGOFl3pNYPgxt8WxvuN7NifrPgKBIQSMaIr6F+6il+fNW986gd2vW7Oc2siJRSmHtqWnnBJ8ZSmQBYlhdWJ0fU9G7k24YGvzVrCXk1faAlvGygmJ/QcV4pnMnwAoqkG8hKGKIXpL1SMo6ow3+qirxdQ65wW99AcHAki23QRGAnLvriGwUKcp0ZdrybV0rGAYQT/qJUtB2dwWfi/2M+7GYuDZ9iMBOvASJ4Na7yYbaBvkArCjF0uBY3rDxd9+PrsWdxSCTICzd/K8/zNRwfu42sCuDT7oBhQKO2kMZfq4sXgNEI6Mv2fzPpDJLapqGPurFLQfrKOhGXR7JLuCKyosNV2z3KERFgGTvVzyCW6Brkj/tX/LxAIQi2c5zcGFVzBuohYdIc8oMpDkEyfTV7qpd6wRHI6LQr4XlNIFZzvgCivS0IH6JCZUFgHWTINApeu+vzYwggVBBgkqhkiG9w0BBwGgggUyBIIFLjCCBSowggUmBgsqhkiG9w0BDAoBAqCCBO4wggTqMBwGCiqGSIb3DQEMAQMwDgQIVZoxXFjmdYwCAggABIIEyAi735WhBAeZ4Mx2o1dSnIeCg5RtTt91UqJaVu4rPfgxTA0LO8jXsl/3GjufMF09U4ihQowjCBEEoFr0ZHNaGn5I9I0BeVA/D5H1L2RDxe7F8VdG3DV/RaQ3C+il6V/L85X9uPtXihpzb9jDnnB9xwVKrAoZx/3wdyakJ9LRFDXoPleJF5rmOMPhRhruwvec/TOso2nD1V79maFb3+fqwn1Q+MgU1V9m8amaIVDboixejmDfHKfYu5euM2ezLgHQPTXuSCHPmnQF6eVM4ueaoCNFq1M8hOZaQsT3ykA/ZwT1W1ghgJE4GpTktq8MgKChaZrSjoT7nrDanRfLXlOOZYSkcL4Z6xBRvt1/dHLsha6LK2sSfFKeL2x7MG27X/SM8faCargxk6ajUE6bK8CalBkKm6iezXfs5pFw/7QgBPu4ax1Eq99UyOa9BjPi26neV9tt4p2Mrcmmm1zlDoBC3G1bCD2PGdrCt91E8jpjIsHj+b5YIi/QRQfZySoINc98hvMMgcLmoCm1dMpxf3utDvBV4tO4L5jzzDFy0fpmNUPuxBbf4LJ3GiwJXO+sHkH2gbUFTYcEbvBQFuwFYr56Q0CKyBqfetJZdo+z9XrmNOqu+/E7Lgk6fmYjeSJu9npkj5n28H24PqFzoWFcgUQQmD8JGn1vBCk9rApQN+p2CzFWzcHQHQw/8h4KaF60PdWJofxEMPKYYSh2NRYfUwa4+YdA5hd/Y/z17XQrrj+GPUZN58sJWllKtuNs05TIQtqbmEQGkeHtaTfNlCkcBtuPD/H77P2LnG3AwiPw5lwhr/Yi8qKROpenwKu6BmGoQagmPMAk+nOAOAoVyysKQ1smEfstjnaIgfzWFPaaDnkDsmLU1qa7FCntPpVFnJmXteWuQm+g3ZzJwsHUCdSofpshBHF6+qfdzDVgqJCE4idjBy/IMYSwx/t2ZWCBMrQUP48OvHTb069Vb2rKmAs07/LHtqh4YXGtGySunRf7uptPwkhAOAM/DOC+m8MVViSqGhS6iL+xv7rODSgNbMZZJX9C1oQc4V2VVN6vjGWEwB77iTIm2aQuWkCh25P9fw3doJGlYzW1CsCYtHsfud74Ve1FEDEbAZf0XFP9ziAw2nRREs1oUH63qCEuQFxV9ODZu7g7ZeY+xMk9hgsnPTBIFknceMMvU4TMBDaFVqwRAqMcoMePxiok9JmZNNLYokVtBWhiPYXi6ZoHc7aUhjKq6DdhB/JgIzqwUr/OgrjLVrCZ2csbXw6cvwc9xg31MGHFAo2VcrWQDfYkwO7dc0d8xWPTwQVSg0NAQ+fW2trXBnpE00dtFFL+qp0lCtxXuQLDDBp/pe5O5qp7zTxk257rFZHPnZIU9LdG3QQos+5SHByzhuj3i6K/4sRix6JQRLD3OxL9ugjbKFtAaa0cpErKD8xoGzSb7g7M7tHYPbIzus4NjYUOzbFDMRVjf4pqxXD3+VQv2Y6VUkw3DkqCH6AMtaJP1+BFa22Q1qeDvaLXSZS70/l1g3bvvp1qkA8Dtgh4VcbQbZpTrQByYG4QJL+4/hx4SCOmIBoyVycAhOuU0a946OTLTDMX2qCjUYCREg1j5FFq+dr10cvnkfTdTuxJ3wBGd84cOSB4gOnVEjElMCMGCSqGSIb3DQEJFTEWBBTyoc0aB6HnyjnfSz+Pr6RscEihIjAxMCEwCQYFKw4DAhoFAAQUOJEXUdNoiSw1CNJjEgECJbXH6MYECC1FlKy32fHSAgIIAA==' AS Pfx 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_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-0000024' 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-0000024' 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-0000024' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Fc_Folio = '01-0000024' 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-0000024' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0000024' 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-0000024' 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-0000024' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0000024' 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 = 'F -' AND Fs_Tipo IN ('01', '03','04') AND Es_Cve_Estado <> 'BA' SELECT GetDate() as Fecha INSERT INTO Transaccion_Documento_Log ( Tdl_Modulo, Tdl_Tabla, Tdl_Documento, Tdl_Tipo, Tdl_Transaccion, Tdl_Fecha, Tdl_Operador ) VALUES ( 'VENTAS', 'Factura', '01-0000024', 'BAJA', 'FA007', GETDATE(), 'CONFIG') DELETE FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Factura' AND Tdl_Documento = '01-0000024' AND Tdl_Tipo = 'BAJA' AND Tdl_Transaccion = 'FA007' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '02' AND Perfil = '001' AND Menu = 'FA007' 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 = 'Factura' AND Transaccion_Documento_Log.Tdl_Documento = '01-0000024' 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 COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'FA007') SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO'