EXEC SP_RPT_VNTK22_3 '01-0000261'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK22' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID
EXEC SP_RPT_FTTK04_1 '0001'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID
EXEC SP_RPT_FTTK04_2 '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 = 'FTTK04'
SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'LOGO' and not imagen is null  
EXEC SP_RPT_VNTK22_1 '01-0000261'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK22' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK22' ORDER BY Fr_ID
EXEC SP_RPT_VNTK22_2 '01-0000261'
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 = 'VNTK22'
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 = '0001'
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 = 'VNTK22'
SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK22'
SELECT Cj_Formato_Ticket_Copia as Formato FROM Caja WHERE Cj_Cve_Caja = '000001' 
SELECT Vn_Credito AS Nombre FROM Venta_Encabezado WHERE Vn_Folio = '01-0000261'
SELECT Fp_Descripcion FROM Forma_Pago WHERE Fp_Cve_Forma_Pago = '0001' AND Fp_Permitir_Punto_Venta = 'SI' AND Es_Cve_Estado <> 'BA'
SELECT Fp_Descripcion FROM Forma_Pago WHERE Fp_Cve_Forma_Pago = '0001' AND Fp_Permitir_Punto_Venta = 'SI' AND Es_Cve_Estado <> 'BA'
SELECT * FROM Forma_Pago WHERE    Fp_Cve_Forma_Pago = '0001' 
SELECT Fp_Comision_Factor,  Fp_Multiplicador,  Fp_Obtener_Tipo_Cambio,  Fp_Moneda_Tipo_Cambio,  Fp_Moneda_Limite,  Fp_Descuento_Factor FROM Forma_Pago WHERE Fp_Cve_Forma_Pago = '0001'
SELECT * FROM Forma_Pago WHERE    Fp_Cve_Forma_Pago = '0001' 
SELECT Fp_Permitir_Punto_Venta AS Nombre FROM Forma_Pago WHERE Fp_Cve_Forma_Pago = '0001'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'TES_PERMITIR_ALTA_MONEDERO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'TES_PERMITIR_SALDO_MONEDERO_NEGATIVO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_FORMA_PAGO_APARTADO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_PERMITIR_PAGO_CON_APARTADO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_NIVEL_VENTA_CREDITO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_NIVEL_DESCUENTO'
SELECT Cliente.Cl_Jerarquia_Credito, Cliente.Cl_Limite_Credito, Cliente.Cl_Saldo, Cadena_Comercial.Cc_Limite_Credito, Cadena_Comercial.Cc_Saldo, Grupo_Comercial.Gc_Limite_Credito, Grupo_Comercial.Gc_Saldo FROM Cliente INNER JOIN Cadena_Comercial ON Cliente.Cc_Cve_Cadena_Comercial = Cadena_Comercial.Cc_Cve_Cadena_Comercial INNER JOIN Grupo_Comercial ON Cliente.Gc_Cve_Grupo_Comercial = Grupo_Comercial.Gc_Cve_Grupo_Comercial WHERE Cl_Cve_Cliente = '0000000198'
SELECT Fp_Descripcion FROM Forma_Pago WHERE Fp_Cve_Forma_Pago = '0001' AND Fp_Permitir_Punto_Venta = 'SI' AND Es_Cve_Estado <> 'BA'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_FORMA_PAGO_DEFAULT'
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 = '0001'
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(sum(cxc_precio_neto_saldo),0) as total FROM Cuenta_x_Cobrar WHERE    Cxc_Folio IN('01-0000080')
SELECT     Cxc_Folio FROM Cuenta_x_Cobrar WHERE    ((Cxc_Tabla LIKE 'PAGARE-%' AND Cxc_Documento = '') OR    (Cxc_Tabla = 'VENTA' AND Cxc_Documento = '01-0000261')) AND    Es_Cve_Estado <> 'CA' AND Cxc_Precio_Neto_Saldo <> 0  
SELECT Pg_Folio FROM Pagare WHERE    Pg_Tabla = 'VENTA' AND    Pg_Documento = '01-0000261' AND    Es_Cve_Estado <> 'CA' 
SELECT Cl_Cve_Cliente, Sc_Cve_Sucursal, Mn_Cve_Moneda, Vn_Tipo_Cambio FROM Venta WHERE Vn_Folio = '01-0000261'
SELECT    Venta.vn_folio,    Venta.vn_tabla,    Venta.vn_documento,    Venta.vn_aplicado,    Venta.es_cve_estado,    Venta.fc_folio,    Venta.Vn_Credito,    Venta.cl_cve_cliente,    isnull(sum(venta.vn_precio_neto_importe),0) as Total FROM venta    INNER JOIN Producto ON venta.Pr_Cve_Producto = Producto.Pr_Cve_Producto WHERE venta.Vn_Folio = '01-0000261' GROUP BY    Venta.vn_folio,    Venta.vn_tabla,    Venta.vn_documento,    Venta.vn_aplicado,    Venta.es_cve_estado,    Venta.fc_folio,    Venta.Vn_Credito,    Venta.cl_cve_cliente 
SELECT TOP 100   
	Vn_Folio as FOLIO, 
	Vn_Fecha as FECHA, 
	Vn_Referencia as REFERENCIA, 
	Cl_Razon_Social_1 As CLIENTE,
	SUM(Venta.Vn_Precio_Neto_Importe) as TOTAL,
	Venta.Es_Cve_Estado as ESTADO,
	Vn_Aplicado as APLICADO,
	CASE WHEN Vn_Credito = 'SI' THEN 'CREDITO' ELSE 'CONTADO' END as TIPO,
	Vn_Comentario as COMENTARIO,
	Rt_Cve_Ruta as RUTA,
	Vn_Descripcion as VENDEDOR
 FROM  	Venta 
	INNER JOIN Cliente ON Venta.Cl_Cve_Cliente = Cliente.Cl_Cve_Cliente 
	INNER JOIN Vendedor ON Venta.Vn_Cve_Vendedor = Vendedor.Vn_Cve_Vendedor
WHERE 
	(Cl_Descripcion LIKE '%sind%' OR
	Cl_Razon_Social_1 LIKE '%sind%' OR
	Cl_R_F_C LIKE '%sind%' OR
	Vn_Comentario LIKE '%sind%' OR
	Vn_Referencia LIKE '%sind%' OR 
	Vn_Descripcion LIKE '%sind%' OR
	Vn_Folio like replace('%sind%','-','%') ) and 
	Vn_Aplicado = 'NO' 
GROUP BY
	Vn_Folio, 
	Vn_Fecha, 
	Vn_Referencia, 
	Cl_Razon_Social_1,
    	Venta.Es_Cve_Estado,
	Vn_Aplicado,
	Vn_Credito,
	Vn_Comentario,
	Rt_Cve_Ruta,
	Vn_Descripcion
ORDER BY 
	Vn_Fecha DESC,
	Vn_Folio DESC
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'VENTA_POS'
SELECT DISTINCT Texto,ID,Transaccion from  Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC