SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' EXEC SP_RPT_ZZVNGR_3 '03-0040093' 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', '03-0040093', '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', '03-0040093', '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', '03-0040093', '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', '03-0040093', '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 '03-0040093' 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 '03-0040093' 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 GetDate() as Fecha INSERT INTO Transaccion_Documento_Log ( Tdl_Modulo, Tdl_Tabla, Tdl_Documento, Tdl_Tipo, Tdl_Transaccion, Tdl_Fecha, Tdl_Operador ) VALUES ( 'VENTAS', 'Remision', '03-0040093', 'ALTA', 'VN012', GETDATE(), 'CONFIG') SELECT * FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Remision' AND Tdl_Documento = '03-0040093' AND Tdl_Tipo = 'ALTA' AND Tdl_Transaccion = 'VN012' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REGISTRAR_ALTA_LOG' *** COMMIT *** SELECT Remision.*, Cliente.Cl_Database, Cliente.Cl_Proveedor, Cliente.Cl_Almacen, Cliente.Cl_Comprador, Cliente.Cl_Sucursal, Cliente.Cl_Registrar_Compra_Remision, Cliente.Cl_Generar_Cxp, Producto.Pr_Tipo_Costeo, Producto.Pr_Unidad_Compra, Producto.Pr_Tipo_Producto FROM Remision INNER JOIN Producto ON Producto.Pr_Cve_Producto = Remision.Pr_Cve_Producto INNER JOIN Cliente ON Cliente.Cl_Cve_Cliente = Remision.Cl_Cve_Cliente WHERE RM_Folio = '03-0040093' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_GENERAR_GASTO_REMISION' SELECT IsNull(MAX(Au_Folio), 0) as Clave FROM AUTOMATIZACION WHERE ISNUMERIC(Au_Folio) = 1 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 = 'COM_AUTORIZAR_ORDEN_COMPRA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COM_CLASIFICADOR_DESCUENTO_AUTOMATIZACION'