SELECT Cl_Descripcion FROM Cliente WHERE Cl_Cve_Cliente='0000000835' AND Es_cve_Estado <> 'BA' SELECT CASE De_Direccion_1 WHEN '' THEN De_Calle + ' ' + De_Numero_Interior + ' ' + De_Numero_Exterior +' '+ De_Cruzamiento_1 +' ' + De_Cruzamiento_2 ELSE De_Direccion_1 END AS Domicilio FROM Direccion_Entrega WHERE De_Tabla = 'CLIENTE' AND De_Documento = '0000000835' AND De_ID = '0001' SELECT De_ID FROM Direccion_Entrega WHERE De_Tabla = 'Cliente' AND De_Documento = '0000000835' AND Es_Cve_Estado = 'AC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_VALIDAR_COLONIA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_GRUPO_IMPUESTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_DIRECCION_ENTREGA_SIMPLE' SELECT Cv_Descripcion FROM Condicion_Venta WHERE Cv_Cve_Condicion_Venta = 'CRED' AND Cv_Tipo_Condicion = '01' and Es_Cve_Estado<> 'BA' SELECT Cl_Condicion_Venta FROM Cliente WHERE Cl_Cve_Cliente = '0000000835' SELECT isnull(SUM(Cxc_Precio_Neto_Saldo),0) as Cl_Saldo, Cliente.Cl_Limite_Credito FROM cliente left join cuenta_x_cobrar on cliente.cl_cve_cliente = cuenta_x_cobrar.cl_cve_cliente and Cxc_Precio_Neto_Saldo <> 0 and cuenta_x_cobrar.es_cve_estado <> 'CA' WHERE cliente.Cl_Cve_Cliente = '0000000835' group by Cliente.Cl_Limite_Credito SELECT Rt_Descripcion AS Nombre FROM Ruta WHERE Rt_Cve_Ruta = '0000' AND Es_Cve_Estado <> 'BA' SELECT Sg_Descripcion AS Nombre FROM Segmento WHERE Sg_Cve_Segmento = '0000' AND Es_Cve_Estado <> 'BA' SELECT * FROM Cliente WHERE Cl_Cve_Cliente = '0000000835' AND Es_Cve_Estado <> 'BA' AND Sc_Cve_Sucursal = '0001' SELECT Cl_Descripcion FROM Cliente WHERE Cl_Cve_Cliente='0000000835' AND Es_cve_Estado <> 'BA' SELECT Vn_Descripcion FROM Vendedor WHERE Vn_Cve_Vendedor = '0000000002' and es_cve_estado <> 'BA' SELECT Vn_Descripcion FROM Vendedor WHERE Vn_Cve_Vendedor = '0000000002' and es_cve_estado <> 'BA' SELECT Vn_Descripcion FROM Vendedor WHERE Vn_Cve_Vendedor = '0000000023' and es_cve_estado <> 'BA' SELECT Al_Controlar_Ubicacion as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0001' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Serie as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0001' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Lote as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0001' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Color as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0001' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Talla as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0001' AND Al_Cve_Almacen = '0001' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0001' AND Al_Cve_Almacen = '0001' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0001' AND Al_Cve_Almacen = '0001' SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0001' and es_cve_estado <> 'BA' SELECT Fs_Folio, Fs_Tipo FROM Factura_Serie WHERE (Fs_Tipo = '01' OR Fs_Tipo = '03' OR Fs_Tipo = '04' OR Fs_Tipo = '05' ) AND Fs_Cve_Factura_Serie = 'A' AND Es_Cve_Estado <> 'BA' SELECT Fs_Cve_Factura_Serie, Fs_Tipo FROM Factura_Serie WHERE (Fs_Sucursal = '0001' OR Fs_Cve_Factura_Serie IN (SELECT Sc_Factura_Serie FROM Sucursal WHERE Sc_Cve_Sucursal = '0001') OR Fs_Cve_Factura_Serie IN (SELECT Sc_Factura_Serie_Web FROM Sucursal WHERE Sc_Cve_Sucursal = '0001')) AND (Fs_Tipo = '01' OR Fs_Tipo = '03' OR Fs_Tipo = '04' OR Fs_Tipo = '05' ) AND Es_Cve_Estado <> 'BA' ORDER BY Fs_Cve_Factura_Serie SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0001' and es_cve_estado <> 'BA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MONEDA_LOCAL' SELECT Mn_Descripcion FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MONEDA_LOCAL' SELECT Mn_Descripcion FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MONEDA_LOCAL' SELECT Mn_Descripcion FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MONEDA_LOCAL' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'CHDG01' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHDG01' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'PMINIMO' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'PMINIMO' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'VASUC' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'VASUC' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'CHFECHA' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHFECHA' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'CHTC01' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHTC01' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'CHDM01' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHDM01' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'CHDS01'