SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PREFIJO_FOLIOS_EMPRESA'
SELECT Fl_Folio FROM Folio WHERE Fl_Tabla = 'CAJA:000003'
SELECT Pr_Cve_Producto AS Nombre FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Paquete Amigo Sin Limite' AND Psp_Monto = '30'
SELECT Psp_Cve_Producto AS Nombre FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Paquete Amigo Sin Limite' AND Psp_Monto = '30'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PREFIJO_FOLIOS_EMPRESA'
SELECT Fl_Folio FROM Folio WHERE Fl_Tabla = 'CAJA:000003'
SELECT Pr_Cve_Producto AS Nombre FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Paquete Amigo Sin Limite' AND Psp_Monto = '30'
SELECT Psp_Cve_Producto AS Nombre FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Paquete Amigo Sin Limite' AND Psp_Monto = '30'
SELECT Psp_Monto FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Paquete Amigo Sin Limite' ORDER BY Psp_Monto 
SELECT Psp_Descripcion FROM Pos_Servicio_Producto WHERE Psp_Grupo = 'TAE' GROUP BY Psp_Descripcion, Psp_Cve_Producto ORDER BY Psp_Cve_Producto ,Psp_Descripcion 
SELECT * FROM Pos_Servicio_Configuracion 
SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
EXEC SP_RPT_VNTK04_3 '01-0002704'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK04' 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_VNTK04_1 '01-0002704'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID
EXEC SP_RPT_VNTK04_2 '01-0002704'
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 = 'VNTK04'
SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
EXEC SP_RPT_VNTK04_3 '01-0002704'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK04' 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_VNTK04_1 '01-0002704'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID
EXEC SP_RPT_VNTK04_2 '01-0002704'
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 = 'VNTK04'
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 = 'VNTK04'
SELECT Vn_Credito AS Nombre FROM Venta_Encabezado WHERE Vn_Folio = '01-0002704'
SELECT Cl_Descripcion AS Nombre FROM CLIENTE WHERE Cl_Cve_cliente = '0000000001'
*** COMMIT ***