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 = 'PROIMP'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DESAFA' ORDER BY Fr_ID
EXEC SP_RPT_DESAFA_2 'FACTURA', '03-0000506', '0003'
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 = 'DESAFA'
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 = 'PROIMP'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DESAFA' ORDER BY Fr_ID
EXEC SP_RPT_DESAFA_2 'FACTURA', '03-0000506', '0002'
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 = 'DESAFA'
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 = 'PROIMP'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DESAFA' ORDER BY Fr_ID
EXEC SP_RPT_DESAFA_2 'FACTURA', '03-0000506', '0001'
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 = 'DESAFA'
SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'CFDI17' and not imagen is null  
EXEC SP_RPT_CFDI40_1 '03-0000506'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CFDI40' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CFDI40' ORDER BY Fr_ID
EXEC SP_RPT_CFDI40_2 '03-0000506'
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 = 'CFDI40'
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 = 'CFDI40'
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 DISTINCT  Fr_Cve_Formato, Fr_Descripcion,Fr_Grafico FROM Formato WHERE Fr_Cve_Formato in('CFDI33','CFDI40')
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_FACTURA'
SELECT Sc_Formato_Factura FROM Sucursal WHERE Sc_Cve_Sucursal = '0003'
SELECT Cl_Formato_Factura FROM Cliente WHERE Cl_Cve_Cliente = '0000000002'
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 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 = 'FA008') 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO'
SELECT Cd_Documento AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'Factura' AND Cd_Documento = '03-0000506'
SELECT Fs_Tipo FROM Factura_Serie WHERE    Fs_Cve_Factura_Serie = 'FAR' AND    Fs_Tipo IN ('01', '03','04') AND    Es_Cve_Estado <> 'BA' 
SELECT    Devolucion_Cliente.Dc_Folio,    Devolucion_Cliente.Vn_Cve_Vendedor,    Devolucion_Cliente.Dc_Fecha,    Devolucion_Cliente.Dc_Referencia,    SUM(CAST(Devolucion_Cliente.Dc_Precio_Lista_Importe AS Decimal(18,2))) as SUM_Suma_Importe,   SUM(CAST(Devolucion_Cliente.Dc_Precio_Neto_Importe AS Decimal(18,2))) as SUM_Importe,   SUM(CAST(Devolucion_Cliente.Dc_Impuesto_Importe AS Decimal(18,2))) As SUM_Impuesto,    SUM(CAST(Devolucion_Cliente.Dc_Descuento_Importe AS Decimal(18,2))) As SUM_Descuento_Importe,    SUM(CAST(Devolucion_Cliente.Dc_Descuento_Global_Importe AS Decimal(18,2))) AS Dc_Descuento_Global_Importe FROM Devolucion_Cliente WHERE    Devolucion_Cliente.Fc_Folio = '03-0000506' and Devolucion_Cliente.Es_Cve_Estado <> 'CA' GROUP BY    Devolucion_Cliente.Dc_Folio,    Devolucion_Cliente.Vn_Cve_Vendedor,    Devolucion_Cliente.Dc_Fecha,    Devolucion_Cliente.Dc_Referencia 
SELECT    Venta.Vn_Folio,    Venta.Vn_Cve_Vendedor,    Venta.Vn_Fecha,    Venta.Vn_Referencia,    Venta.Vn_Credito,    SUM(CAST(Venta.Vn_Precio_Lista_Importe AS Decimal(18,2))) as SUM_Suma_Importe,   SUM(CAST(Venta.Vn_Precio_Neto_Importe AS Decimal(18,2))) as SUM_Importe,   SUM(CAST(Venta.Vn_Impuesto_Importe AS Decimal(18,2))) As SUM_Impuesto,    SUM(CAST(Venta.Vn_Descuento_Importe AS Decimal(18,2))) As SUM_Descuento_Importe,    SUM(CAST(Venta.Vn_Descuento_Global_Importe AS Decimal(18,2))) AS Vn_Descuento_Global_Importe FROM Venta_Encabezado Venta WHERE    Venta.Fc_Folio = '03-0000506' and Venta.Es_Cve_Estado <> 'CA' GROUP BY    Venta.Vn_Credito,    Venta.Vn_Folio,    Venta.Vn_Cve_Vendedor,    Venta.Vn_Fecha,    Venta.Vn_Referencia 
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 = 'FAR' 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 = 'FAR' AND Es_Cve_Estado <> 'BA'
SELECT Fs_Cve_Factura_Serie, Fs_Tipo FROM Factura_Serie WHERE (Fs_Sucursal = '0003' OR    Fs_Cve_Factura_Serie IN (SELECT Sc_Factura_Serie FROM Sucursal WHERE Sc_Cve_Sucursal = '0003') OR    Fs_Cve_Factura_Serie IN (SELECT Sc_Factura_Serie_Web FROM Sucursal WHERE Sc_Cve_Sucursal = '0003')) 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 Cv_Descripcion FROM Condicion_Venta WHERE Cv_Cve_Condicion_Venta = 'CONT' AND Cv_Tipo_Condicion = '01'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_CONDICION_VENTA_CONTADO'
SELECT Sc_Condicion_Venta FROM Sucursal WHERE Sc_Cve_Sucursal = '0003' 
SELECT Cl_Condicion_Venta FROM Cliente WHERE Cl_Cve_Cliente = '0000000002' 
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 = '0000000002' group by Cliente.Cl_Limite_Credito 
SELECT Rt_Descripcion AS Nombre FROM Ruta WHERE Rt_Cve_Ruta = '0000' AND Es_Cve_Estado <> 'BA'