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 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 Clave FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE'
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 * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CA0147' ORDER BY Fr_ID
EXEC SP_RPT_CA0147_3  '0000000126', '0000000001' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_DIRECCION_2'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_DIRECCION_1'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RAZON_SOCIAL'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CA0147' ORDER BY Fr_ID
EXEC SP_RPT_CA0147_1  '0000000126', '0000000001' 
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CA0147' ORDER BY Fr_ID
EXEC SP_RPT_CA0147_2  '0000000126', '0000000001' 
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'CA0147'
SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CA0147'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_TICKET_MONEDERO'
SELECT Max(Mc_Id) as Mc_Id FROM Monedero_Control WHERE Mn_Cve_Monedero = '0000000126' 
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 Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MONEDA_LOCAL'
UPDATE Monedero SET    Mn_Saldo = 1000 WHERE    Mn_Cve_Monedero = '0000000126' 
SELECT isnull(SUM(Mc_Importe),0) as Saldo FROM Monedero_Control WHERE Mn_Cve_Monedero = '0000000126' AND    Es_CvE_Estado <> 'CA' 
SELECT mn_cve_monedero FROM Monedero WHERE Mn_Cve_Monedero = '0000000126' 
INSERT INTO Monedero_Control (   Mn_Cve_Monedero,    Mc_ID,    Mc_Tabla,    Mc_Documento,    Mc_Fecha,    Mc_Referencia,    Mc_Comentario,    Mc_Importe,    Oper_Alta,    Fecha_Alta,    Oper_Ult_Modif,    Fecha_Ult_Modif,    Es_CvE_Estado ) VALUES ('0000000126', '0000000001', '', '', '2026-04-11', 'CARGA INICIAL', '', 1000, 'CONFIG', '2026-04-11 18:52:03', 'CONFIG', '2026-04-11 18:52:03','AC')
SELECT IsNull(MAX(Mc_ID),0) as MaxID FROM Monedero_Control WHERE ISNUMERIC(Mc_ID) = 1 AND Mn_Cve_Monedero = '0000000126'
SELECT GetDate() as Fecha
SELECT isnull(SUM(Mc_Importe),0) as Saldo FROM Monedero_Control WHERE Mn_Cve_Monedero = '0000000126' AND    Es_CvE_Estado <> 'CA' 
SELECT mn_cve_monedero FROM Monedero WHERE Mn_Cve_Monedero = '0000000126' 
SELECT Mn_Cve_Monedero AS Nombre FROM MONEDERO WHERE Mn_Cve_Monedero = '0000000126'
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 = 'GEN_URL_SERVIDOR_CENTRAL'
SELECT Mn_Cliente AS Nombre FROM MONEDERO WHERE Mn_Cve_Monedero = '0000000126'
SELECT isnull(SUM(Mc_Importe),0) as Saldo FROM Monedero_Control WHERE Mn_Cve_Monedero = '0000000126' AND    Es_CvE_Estado <> 'CA' 
SELECT mn_cve_monedero FROM Monedero WHERE Mn_Cve_Monedero = '0000000126' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_URL_SERVIDOR_CENTRAL'
SELECT Cl_Descripcion FROM Cliente WHERE Cl_Cve_Cliente = '0000000658'
SELECT Mn_Cliente AS Nombre FROM MONEDERO WHERE Mn_Cve_Monedero = '0000000126'
SELECT isnull(SUM(Mc_Importe),0) as Saldo FROM Monedero_Control WHERE Mn_Cve_Monedero = '0000000126' AND    Es_CvE_Estado <> 'CA' 
SELECT mn_cve_monedero FROM Monedero WHERE Mn_Cve_Monedero = '0000000126' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_URL_SERVIDOR_CENTRAL'
SELECT TOP 100 
	Mn_Cve_Monedero AS CLAVE,
	Mn_Codigo_Barras AS [CODIGO DE BARRAS],
	ISNULL(Cl_Descripcion,'') as CLIENTE,
	MOnedero.Es_Cve_Estado AS ESTADO
 FROM  
	Monedero
	LEFT JOIN Cliente On Monedero.Mn_Cliente = Cliente.Cl_Cve_Cliente
WHERE
(
	Mn_Cve_Monedero LIKE '%M18712411459%' OR
	Mn_Codigo_Barras LIKE '%M18712411459%' OR
	Cl_Descripcion LIKE '%M18712411459%' OR
	Monedero.Es_Cve_Estado LIKE '%M18712411459%'
)
/*Tipo_Monedero AND Monedero.Tm_Cve_Tipo_Monedero= #Tipo_Monedero */
/*Sucursal AND Monedero.Mn_Sucursal= #Sucursal */
/*Cliente AND Monedero.Mn_Cliente= #Cliente */

SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'MONEDERO'