SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS'
SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
EXEC SP_RPT_VNTK05_3 '01-0019339'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK05' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK05' ORDER BY Fr_ID
EXEC SP_RPT_FTTK05_1 '0001'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK05' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK05' ORDER BY Fr_ID
EXEC SP_RPT_FTTK05_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 = 'FTTK05'
SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'LOGO' and not imagen is null  
EXEC SP_RPT_VNTK05_1 '01-0019339'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK05' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK05' ORDER BY Fr_ID
EXEC SP_RPT_VNTK05_2 '01-0019339'
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 = 'VNTK05'
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 = '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 = 'VNTK05'
SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK05'
SELECT Cj_Formato_Ticket as Formato FROM CAja WHERE Cj_Cve_Caja = '000003' 
SELECT Vn_Credito AS Nombre FROM Venta_Encabezado WHERE Vn_Folio = '01-0019339'
SELECT Cl_Descripcion AS Nombre FROM CLIENTE WHERE Cl_Cve_cliente = '0000000001'
*** COMMIT ***
SELECT    Obj.name AS Nombre,    Obj.type AS Tipo,    Obj.type_desc AS nTiop,    Modu.definition AS Consulta FROM SAYER.sys.objects Obj    INNER JOIN SAYER.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 = 'VENTA' 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 Venta WHERE Vn_Folio = '01-0019339'
SELECT Vn_Fecha AS Nombre FROM Venta WHERE Vn_Folio = '01-0019339'
SELECT    Poliza_Configuracion.Pc_Cve_Poliza_Configuracion,    Poliza_Configuracion.Pc_Descripcion,    Poliza_Configuracion.Pc_Tabla FROM Poliza_Configuracion    INNER JOIN Poliza_Configuracion_Tabla ON Poliza_Configuracion.Pc_Tabla = Poliza_Configuracion_Tabla.Pc_Tabla WHERE    Poliza_Configuracion_Tabla.Pc_Tabla = 'VENTA' AND    Poliza_Configuracion.Es_Cve_Estado <> 'BA' AND Poliza_Configuracion_Tabla.Pc_Contabiliza_Linea = 'SI' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CENTRO_COSTO_OBLIGATORIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_PERIODO_ACTUAL'
SELECT GetDate() as Fecha
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_EJERCICIO_ACTUAL'
SELECT GetDate() as Fecha
UPDATE Venta_Encabezado SET    Vn_Descuento_Global_Importe = 0,   Vn_Precio_Lista_Importe = 55,   Vn_Descuento_Importe = 0,   Vn_Precio_Descontado_Importe = 55,   Vn_Impuesto_Importe = 0,   Vn_Precio_Neto_Importe = 55,    Vn_Folio_Web = (       SELECT           LEFT(RIGHT(CL.Cl_R_F_C, 3), 2) +            CAST(CAST( LEFT(RIGHT(VE.Vn_Folio, 7), 3) as numeric(18,0)) as nvarchar) +            LEFT(RIGHT('0' + CAST(DAY(VE.Vn_Fecha) AS NVARCHAR(2)), 2), 1) +            LEFT(RIGHT(CL.Cl_R_F_C, 7), 2) +            LEFT(VE.Vn_Folio, 2) +            RIGHT('0' + CAST(MONTH(VE.Vn_Fecha) AS NVARCHAR(2)), 2) +            RIGHT(LEFT(CL.Cl_R_F_C, 3), 2) +            CAST(CAST(RIGHT(VE.Vn_Folio, 3) as numeric(18,0)) as nvarchar) +            RIGHT(LEFT(VE.Vn_Condicion_Venta, 2), 1) +            RIGHT(RIGHT('0' + CAST(DAY(VE.Vn_Fecha) AS NVARCHAR(2)), 2), 1)        FROM Venta_Encabezado VE            INNER JOIN Sucursal SU ON VE.Sc_Cve_Sucursal = SU.Sc_Cve_Sucursal           INNER JOIN Cliente CL ON VE.Cl_Cve_Cliente = CL.Cl_Cve_Cliente       WHERE VE.Vn_Folio = Venta_Encabezado.Vn_Folio) WHERE    Vn_Folio = '01-0019339' 
INSERT INTO Venta_Total_Impuesto(Vn_Folio,Vt_ID,Vt_Impuesto,Vt_SubTotal_Importe,Vt_Impuesto_Importe,Vt_Total_Importe ) VALUES ('01-0019339','0001','',0,0,0)
SELECT    isnull(SUM(isnull(Venta_Impuesto.Vi_Base,0)),0) as Base,    isnull(SUM(isnull(Venta_Impuesto.Im_Importe,0)),0) as Importe,    ISNULL(Impuesto.Im_Cve_Impuesto,'') as Impuesto,    ISNULL(Impuesto.Im_Tasa,0) / 100 as Tasa FROM Venta    LEFT JOIN Venta_Impuesto on Venta.Vn_Folio = Venta_Impuesto.Vn_Folio and Venta.Vn_ID = Venta_Impuesto.Vn_ID    LEFT JOIN Impuesto on Impuesto.Im_Cve_Impuesto = Venta_Impuesto.Im_Cve_Impuesto WHERE Venta.Vn_Folio = '01-0019339' GROUP BY    Impuesto.Im_Cve_Impuesto,    Impuesto.Im_Tasa,    Impuesto.Im_Descripcion ORDER BY Tasa DESC 
SELECT    ISNULL(SUM(Vn_Precio_Lista_Importe),0) as Vn_Precio_Lista_Importe,    ISNULL(SUM(Vn_Descuento_Importe),0) as Vn_Descuento_Importe,   ISNULL(SUM(Vn_Precio_Descontado_Importe),0) as Vn_Precio_Descontado_Importe,    ISNULL(SUM(Vn_Descuento_Global_Importe),0) as Vn_Descuento_Global_Importe FROM Venta WHERE Vn_Folio = '01-0019339' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_MODO_TOTALIZA_IMPUESTO'
UPDATE Venta_Encabezado SET Vn_Condicion_Venta = 'CONT' WHERE Vn_Folio = '01-0019339'
UPDATE Venta SET Vn_Condicion_Venta = 'CONT' WHERE Vn_Folio = '01-0019339'
INSERT INTO POS_Pagos (Cj_Cve_Caja, Ca_Cve_Cajero, Cj_Transaccion, POS_ID, POS_Folio,Vn_Folio,Fp_Cve_Forma_Pago, POS_Importe, POS_Referencia, POS_Fecha_Transaccion, Rv_Folio, POS_Chofer, POS_Tipo, POS_Multiplicador, POS_Importe_Real, POS_Comision_Factor, POS_Comision_Importe, POS_Descuento_Factor, POS_Descuento_Importe, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif ) VALUES ('000003', '0001', '0000019274', '9999', '01-0001545','01-0019339','0001', -945, '', '2025-11-25', '', '', '0000', 1, -945, 0, 0, 0, 0, '0001','2025-11-25 15:18:50','0001','2025-11-25 15:18:50' )
SELECT GetDate() as Fecha