SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
EXEC SP_RPT_VNGR1N_3 '02-0001442'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNGR1N' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DEGR06' ORDER BY Fr_ID
EXEC SP_RPT_DEGR06_2 'COTIZACION', '02-0001442', '0002'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNGR1N'
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 = 'DEGR06'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DEGR06' ORDER BY Fr_ID
EXEC SP_RPT_DEGR06_2 'COTIZACION', '02-0001442', '0001'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNGR1N'
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 = 'DEGR06'
EXEC SP_RPT_VNGR1N_1 '02-0001442'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNGR1N' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNGR1N' ORDER BY Fr_ID
EXEC SP_RPT_VNGR1N_2 '02-0001442'
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 = 'VNGR1N'
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 = 'DIRECCION'
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 = 'VNGR1N'
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 = 'FTO_IMP_COTIZACION_NORMAL'
SELECT Pe_HTML AS Nombre FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL19'
SELECT  Cotizacion.Ct_Folio,  Vendedor.Vn_Email,  Vendedor.Vn_Descripcion,  Vendedor.Vn_Email_Contacto,  (SELECT MAX(ISNULL(Ct_Partida,0)) FROM Cotizacion c WHERE c.Ct_Folio = Cotizacion.Ct_Folio) AS PARTIDA FROM Cotizacion_Encabezado Cotizacion     INNER JOIN Vendedor ON Vendedor.Vn_Cve_Vendedor = Cotizacion.Vn_Cve_Vendedor     INNER JOIN Cliente ON Cliente.Cl_Cve_Cliente = Cotizacion.Cl_Cve_Cliente WHERE Cotizacion.Ct_Folio = '02-0001442' 
SELECT Cotizacion.Ct_Folio AS FOLIO,
    Cliente.Cl_Razon_Social AS CLIENTE_RAZON_SOCIAL,
    CASE WHEN Cliente.Cl_Contacto_1 <> '' THEN Cliente.Cl_Contacto_1
            ELSE Cliente.Cl_Contacto_2
    END AS CONTACTO,
    CASE WHEN Cliente.Cl_email_contacto_1 <> '' THEN Cliente.Cl_email_contacto_1
            ELSE Cliente.Cl_email_contacto_2
    END EMAIL,
    Empresa.Em_Razon_Social AS EMPRESA,
    Vendedor.Vn_Telefono_1 AS TELEFONO1,
    Vendedor.Vn_Telefono_2 AS TELEFONO2,
    Vendedor.Vn_Telefono_3 AS TELEFONO3
FROM Cotizacion_Encabezado Cotizacion
INNER JOIN Cliente ON Cliente.Cl_Cve_Cliente = Cotizacion.Cl_Cve_Cliente
INNER JOIN Vendedor ON Vendedor.Vn_Cve_Vendedor = Cotizacion.Vn_Cve_Vendedor
INNER JOIN Sucursal ON Sucursal.Sc_Cve_Sucursal = Cliente.Sc_Cve_Sucursal
INNER JOIN Empresa ON Empresa.Em_Cve_Empresa = Sucursal.Em_Cve_Empresa
WHERE Cotizacion.Ct_Folio = '02-0001442'

SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'COTIZACION_PL'
SELECT Pe_Texto FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL19'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'PL_COTIZACION'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COT_ENVIAR_EMAIL_VENDEDOR'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COT_ENVIAR_AUTOMATICAMENTE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'PL_COTIZACION'
*** COMMIT ***
UPDATE Cotizacion_Encabezado SET    Ct_Fecha='2025-11-15',   Ct_Referencia='',   Ct_Atencion='Isaac Cante',   Ct_Comentario='',   Ct_Condicion_Venta='CONT',   Sc_Cve_Sucursal='0002',   Al_Cve_Almacen='0001',   Cl_Cve_Cliente='0002000147',   Vn_Cve_Vendedor='0000000002',   Mn_Cve_Moneda='MXN',   Ct_Tipo_Cambio=1,   Ct_Oportunidad = '',    Ct_Fecha_Vencimiento = '2025-11-15',   Oper_Ult_Modif='DIRECCION',   Fecha_Ult_Modif ='2025-11-15 11:14:50' WHERE Ct_Folio='02-0001442' 
SELECT    Obj.name AS Nombre,    Obj.type AS Tipo,    Obj.type_desc AS nTiop,    Modu.definition AS Consulta FROM BOUTIQUE.sys.objects Obj    INNER JOIN BOUTIQUE.sys.sql_modules Modu ON Obj.object_id = Modu.object_id WHERE    (Obj.name IN (SELECT Ats_Sp FROM Afectar_Tabla_Sp WHERE At_Tabla = 'COTIZACION' AND    Es_Cve_Estado <> 'BA') ) AND    Obj.type = 'P' ORDER BY Obj.name ASC 
SELECT @@VERSION AS xVersion 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION_SQL_AFECTAR'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_HISTORIAL_SEGUIMIENTO'
SELECT Cl_Cve_Cliente AS Nombre FROM Cotizacion WHERE Ct_Folio = '02-0001442'
SELECT Ct_Fecha AS Nombre FROM Cotizacion WHERE Ct_Folio = '02-0001442'
UPDATE Cotizacion_Encabezado SET    Ct_Descuento_Global_Importe = 0,   Ct_Precio_Lista_Importe = 3517.24137912,   Ct_Descuento_Importe = 10.620689654,   Ct_Precio_Descontado_Importe = 3506.620689466,   Ct_Impuesto_Importe = 561.06,   Ct_Precio_Neto_Importe = 4067.68 WHERE    Ct_Folio = '02-0001442' 
SELECT    ISNULL(SUM(Ct_Precio_Lista_Importe),0) as Ct_Precio_Lista_Importe,    ISNULL(SUM(Ct_Descuento_Importe),0) as Ct_Descuento_Importe,   ISNULL(SUM(Ct_Impuesto_Importe),0) as Ct_Impuesto_Importe,   ISNULL(SUM(Ct_Precio_Descontado_Importe),0) as Ct_Precio_Descontado_Importe,    ISNULL(SUM(Ct_Descuento_Global_Importe),0) as Ct_Descuento_Global_Importe FROM Cotizacion WHERE Ct_Folio = '02-0001442' 
DELETE Documento_Lectura WHERE Dl_Tabla = 'COTIZACION' AND Dl_Documento = '02-0001442'
DELETE Documento_Activo_Fijo WHERE Da_Tabla = 'COTIZACION' AND Da_Documento = '02-0001442'
DELETE Documento_UEN WHERE Du_Tabla = 'COTIZACION' AND Du_Documento = '02-0001442'
DELETE Documento_Centro_Costo WHERE Dc_Tabla = 'COTIZACION' AND Dc_Documento = '02-0001442'