SELECT Ln_Descripcion AS Nombre FROM Linea WHERE Ln_Cve_LINEA = '0000' AND Es_Cve_Estado <> 'BA' SELECT Mr_Descripcion AS Nombre FROM Marca WHERE Mr_Cve_MARCA = '0052' AND Es_Cve_Estado <> 'BA' SELECT Ct_Descripcion AS Nombre FROM Categoria WHERE Ct_Cve_Categoria = '0009' AND Es_Cve_Estado <> 'BA' SELECT Pr_Descripcion FROM Producto WHERE Pr_Clave_Corta = '000841' AND Pr_Cve_Producto <> '0000000841' SELECT Pr_Cve_Producto AS Nombre FROM Producto WHERE Pr_Clave_Corta = '000841' SELECT Cf_Descripcion FROM Complemento_Fiscal WHERE Cf_Cve_Complemento_Fiscal = 'PAGO' AND Cf_Tipo = '01' AND Es_Cve_Estado <> 'BA' SELECT Cf_Descripcion FROM Complemento_Fiscal WHERE Cf_Cve_Complemento_Fiscal = 'PAGO' AND Cf_Tipo = '01' AND Es_Cve_Estado <> 'BA' SELECT Cf_Descripcion FROM Complemento_Fiscal WHERE Cf_Cve_Complemento_Fiscal = 'PAGO' AND Cf_Tipo = '01' AND Es_Cve_Estado <> 'BA' SELECT Cf_Descripcion FROM Complemento_Fiscal WHERE Cf_Cve_Complemento_Fiscal = 'PAGO' AND Cf_Tipo = '01' AND Es_Cve_Estado <> 'BA' SELECT TOP 100 Cf_Cve_Complemento_Fiscal AS CLAVE, Cf_Descripcion AS DESCRIPCION, Es_Cve_Estado AS ESTADO FROM Complemento_FiscalWHERE Cf_Descripcion LIKE '%%' ORDER BY CLAVE ASC SELECT Cf_Descripcion FROM Complemento_Fiscal WHERE Cf_Cve_Complemento_Fiscal = '0001' AND Cf_Tipo = '01' AND Es_Cve_Estado <> 'BA' SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'COMPLEMENTO_FISCAL' 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 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 IsNull(MAX(Cf_Cve_Complemento_Fiscal), 0) as Clave FROM Complemento_Fiscal WHERE ISNUMERIC(Cf_Cve_Complemento_Fiscal) = 1 SELECT TOP 100 Cf_Cve_Complemento_Fiscal AS CLAVE, Cf_Descripcion AS DESCRIPCION, Es_Cve_Estado AS ESTADO FROM Complemento_FiscalWHERE Cf_Descripcion LIKE '%%' ORDER BY CLAVE ASC SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'COMPLEMENTO_FISCAL' 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 Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_COMPLEMENTO_FISCAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_AUTOCLAVE' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA084' AND Restriccion = 'CAT001' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CAT001' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = 'CA084' 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_Descripcion FROM Complemento_Fiscal WHERE Cf_Cve_Complemento_Fiscal = 'PAGO' AND Cf_Tipo = '01' AND Es_Cve_Estado <> 'BA' SELECT Accesos FROM EMPRESAS..EasyAccess WHERE Empresa = '01' AND Operador = 'CONFIG' AND Transaccion = 'CA084' AND Personalizado = 'SI' SELECT * FROM Campos_Adicionales Where Ca_Tabla = 'Complemento_Fiscal' ORDER BY Ca_Orden ASC SELECT Restriccion FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA084' SELECT EasyAccess AS Nombre FROM EMPRESAS..Menus WHERE Clave = 'CA084' 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 = 'CA084' 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 = 'CA084' SELECT Accesos FROM EMPRESAS..EasyAccess WHERE Empresa = '01' AND Operador = 'CONFIG' AND Transaccion = 'CA084' SELECT TOP 100 Cf_Cve_Complemento_Fiscal AS CLAVE, Cf_Descripcion AS DESCRIPCION, Es_Cve_Estado AS ESTADO FROM Complemento_FiscalWHERE Cf_Descripcion LIKE '%%' ORDER BY CLAVE ASC SELECT Cf_Descripcion FROM Complemento_Fiscal WHERE Cf_Cve_Complemento_Fiscal = 'PAGO' AND Cf_Tipo = '01' AND Es_Cve_Estado <> 'BA'