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 = 'CA016') 
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 = 'CA016') 
SELECT * FROM Forma_Pago WHERE Fp_Cve_Forma_Pago = '0004'
SELECT GetDate() as Fecha
SELECT GetDate() as Fecha
SELECT TOP 100       Fp_Cve_Forma_Pago AS CLAVE,      Fp_Descripcion AS DESCRIPCION,      Fp_Tipo AS TIPO,      Fp_Nivel_Autorizacion AS [NIVEL AUTORIZACION],      Es_Cve_Estado AS ESTADO FROM        Forma_PagoWHERE       Fp_Descripcion LIKE '%tarj%'
SELECT TOP 100       Fp_Cve_Forma_Pago AS CLAVE,      Fp_Descripcion AS DESCRIPCION,      Fp_Tipo AS TIPO,      Fp_Nivel_Autorizacion AS [NIVEL AUTORIZACION],      Es_Cve_Estado AS ESTADO FROM        Forma_PagoWHERE       Fp_Descripcion LIKE '%%'
SELECT TOP 100       Fp_Cve_Forma_Pago AS CLAVE,      Fp_Descripcion AS DESCRIPCION,      Fp_Tipo AS TIPO,      Fp_Nivel_Autorizacion AS [NIVEL AUTORIZACION],      Es_Cve_Estado AS ESTADO FROM        Forma_PagoWHERE       Fp_Descripcion LIKE '%cuenta%'
SELECT TOP 100       Fp_Cve_Forma_Pago AS CLAVE,      Fp_Descripcion AS DESCRIPCION,      Fp_Tipo AS TIPO,      Fp_Nivel_Autorizacion AS [NIVEL AUTORIZACION],      Es_Cve_Estado AS ESTADO FROM        Forma_PagoWHERE       Fp_Descripcion LIKE '%apli%'
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'FORMA_PAGO'
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 = 'CONFIG'
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 Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta'
SELECT TOP 100       Fp_Cve_Forma_Pago AS CLAVE,      Fp_Descripcion AS DESCRIPCION,      Fp_Tipo AS TIPO,      Fp_Nivel_Autorizacion AS [NIVEL AUTORIZACION],      Es_Cve_Estado AS ESTADO FROM        Forma_PagoWHERE       Fp_Descripcion LIKE '%%'
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'FORMA_PAGO'
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 = 'CONFIG'
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 Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta'
SELECT Mp_Cve_Metodo_Pago,     (CASE WHEN Mp_Contabilidad = 'SI' AND Mp_CFDI = 'SI' THEN        CASE Mp_Descripcion WHEN Mp_Descripcion_CFDI THEN Mp_Descripcion ELSE Mp_Descripcion + '/' + Mp_Descripcion_CFDI END     WHEN Mp_Contabilidad = 'NO' AND Mp_CFDI = 'SI' THEN Mp_Descripcion_CFDI     WHEN Mp_Contabilidad = 'SI' AND Mp_CFDI = 'NO' THEN Mp_Descripcion ELSE     Mp_Descripcion END) AS Mp_Descripcion,     (CASE WHEN Mp_Contabilidad = 'SI' AND Mp_CFDI = 'SI' THEN 'Contabilidad/CFDI'     WHEN Mp_Contabilidad = 'NO' AND Mp_CFDI = 'SI' THEN 'CFDI'     WHEN Mp_Contabilidad = 'SI' AND Mp_CFDI = 'NO' THEN 'Contabilidad' ELSE '' END) AS Aplica FROM Metodo_Pago WHERE Es_Cve_Estado <> 'BA' ORDER BY Mp_Cve_Metodo_Pago 
SELECT Name AS Nombre FROM sysobjects WHERE sysobjects.Name = 'Metodo_Pago' AND Type = 'U'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_FORZAR_MAYUSCULAS'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA016' AND Restriccion = 'CAT001'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CAT001'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_FORMA_PAGO_TIPO_CAMBIO_OPCION'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMPUESTO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_PROVEEDOR'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_TIPO_GASTO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_CLIENTE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_FORMA_PAGO'
SELECT DISTINCT Texto,ID,Transaccion from  Configuracion_Etiqueta where (Transaccion = 'CA016' 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 = 'CONFIG'
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 Accesos FROM EMPRESAS..EasyAccess WHERE Empresa = '01' AND Operador = 'CONFIG' AND Transaccion = 'CA016' AND Personalizado = 'SI' 
SELECT * FROM Campos_Adicionales Where     Ca_Tabla = 'Forma_Pago' ORDER BY Ca_Orden ASC 
SELECT Restriccion FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND  Perfil = '001' AND  Menu = 'CA016'
SELECT EasyAccess AS Nombre FROM EMPRESAS..Menus WHERE Clave = 'CA016'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_TIPO_CAMBIO_INICIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_SOLICITAR_MONEDERO'
SELECT EasyAccess, URL FROM EMPRESAS..Menus WHERE Clave = 'CA016'
INSERT INTO EMPRESAS..Transaccion_Uso ( Transaccion,  Fecha,  Server_Id,  Operador )VALUES( 'CA016', '2019-11-07 10:57:53', '24736-42591-61444-1', 'CONFIG') 
SELECT GetDate() as Fecha
SELECT Name FROM EMPRESAS..sysobjects sysobjects WHERE sysobjects.Name = 'Transaccion_Uso' AND type = 'U'
UPDATE EMPRESAS..EasyAccess SET  Accesos = Accesos + 1 WHERE Empresa = '01' AND  Operador = 'CONFIG' AND  Transaccion = 'CA016'
SELECT Accesos FROM EMPRESAS..EasyAccess WHERE Empresa = '01' AND  Operador = 'CONFIG' AND  Transaccion = 'CA016'
Select top 25     Modulos.Clave,     Modulos.Descripcion,     Menus.EasyAccess,     EasyAccess.Transaccion,     EasyAccess.Accesos FROM     EMPRESAS..EasyAccess EasyAccess     INNER JOIN EMPRESAS..Operadores Operadores ON EasyAccess.Operador = Operadores.Operador     INNER JOIN EMPRESAS..Permisos Permisos ON EasyAccess.Empresa = Permisos.Empresa AND EasyAccess.Transaccion = Permisos.Menu AND Operadores.Perfil = Permisos.Perfil AND Permisos.Estado = 'AC'     INNER JOIN EMPRESAS..Menus Menus ON EasyAccess.Transaccion = Menus.Clave     INNER JOIN EMPRESAS..Modulos Modulos ON Menus.Modulo = Modulos.Clave WHERE     EasyAccess.Personalizado = 'SI' AND     EasyAccess.Bloqueado = 'NO' AND     EasyAccess.Operador = 'CONFIG' AND     EasyAccess.Empresa = '01' ORDER BY     EasyAccess.Accesos Desc