SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' EXEC SP_RPT_ZZVNGR_3 '01-0006182' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZZVNGR' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DESE14' ORDER BY Fr_ID EXEC SP_RPT_DESE14_2 'REMISION', '01-0006182', '0002', '115' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZZVNGR' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'DESE14' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DEGR02' ORDER BY Fr_ID EXEC SP_RPT_DEGR02_2 'REMISION', '01-0006182', '0002' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZZVNGR' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'DEGR02' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DESE14' ORDER BY Fr_ID EXEC SP_RPT_DESE14_2 'REMISION', '01-0006182', '0001', '115' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZZVNGR' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'DESE14' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DEGR02' ORDER BY Fr_ID EXEC SP_RPT_DEGR02_2 'REMISION', '01-0006182', '0001' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZZVNGR' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'DEGR02' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RAZON_SOCIAL' EXEC SP_RPT_ZZVNGR_1 '01-0006182' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZZVNGR' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZZVNGR' ORDER BY Fr_ID EXEC SP_RPT_ZZVNGR_2 '01-0006182' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Horizontal, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'ZZVNGR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' 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 Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZZVNGR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_REMISION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PRINTER_ESC_P' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REDIMENSIONAR_IMAGEN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VISTA_PREVIA_IMPRESION_MULTIPLE' SELECT * FROM Documento_Descripcion_Extendida WHERE Dd_Tabla='Remision' AND Dd_Documento = '01-0006182' AND Dd_Documento_ID = '0002' ORDER BY Dd_Documento_ID, Dd_ID SELECT Pr_Tipo_Producto AS Nombre FROM Producto WHERE Pr_Cve_Producto = '0000006472' SELECT Pr_Numero_Parte AS Nombre FROM Producto WHERE Pr_Cve_Producto = '0000006472' SELECT * FROM Documento_Descripcion_Extendida WHERE Dd_Tabla='Remision' AND Dd_Documento = '01-0006182' AND Dd_Documento_ID = '0001' ORDER BY Dd_Documento_ID, Dd_ID SELECT Pr_Tipo_Producto AS Nombre FROM Producto WHERE Pr_Cve_Producto = '0000006087' SELECT Pr_Numero_Parte AS Nombre FROM Producto WHERE Pr_Cve_Producto = '0000006087' SELECT Dl_Lectura AS Nombre FROM Documento_Lectura WHERE Dl_Documento = '01-0006182' AND Dl_Tabla = 'Remision' SELECT Af_Cve_Activo_Fijo AS Nombre FROM Documento_Activo_Fijo WHERE Da_Documento = '01-0006182' AND Da_Tabla = 'Remision' SELECT Uen_Cve_Unidad_Estrategica_Negocio AS Nombre FROM Documento_UEN WHERE Du_Documento = '01-0006182' AND Du_Tabla = 'Remision' SELECT Cc_Cve_Centro_Costo AS Nombre FROM Documento_Centro_Costo WHERE Dc_Documento = '01-0006182' AND Dc_Tabla = 'Remision' SELECT Py_Cve_Proyecto AS Nombre FROM Documento_Proyecto WHERE Dp_Documento = '01-0006182' AND Dp_Tabla = 'Remision' 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 = '0000000006' AND De_ID = '0001' SELECT De_ID AS DIR_ENTREGA FROM Entrega_Documento WHERE Entrega_Documento.Ed_Tabla = 'Remision' AND Entrega_Documento.Ed_Documento = '01-0006182' AND Entrega_Documento.De_Tabla = 'Cliente' AND Entrega_Documento.De_Documento = '0000000006' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_MODO_VISOR_WEB'