EXEC SP_RPT_VNTK22_3 '01-0023524'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK22' 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_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK22'
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_VNTK22_1 '01-0023524'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK22' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK22' ORDER BY Fr_ID
EXEC SP_RPT_VNTK22_2 '01-0023524'
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 = 'VNTK22'
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 = 'VNTK22'
SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK22'
SELECT Cj_Formato_Ticket_Cobro as Formato FROM Caja WHERE Cj_Cve_Caja = '000001' 
*** COMMIT ***
SELECT     isnull(sum(cxc_precio_neto_saldo),0) as total FROM Cuenta_x_Cobrar WHERE    Cxc_Folio IN('01-0000063')
SELECT    Obj.name AS Nombre,    Obj.type AS Tipo,    Obj.type_desc AS nTiop,    Modu.definition AS Consulta FROM AYLMACIASBASED.sys.objects Obj    INNER JOIN AYLMACIASBASED.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 = 'PAGO_CXC' 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 Fc_Folio FROM Venta_Encabezado WHERE Vn_Folio = '01-0023524' 
SELECT Cxc_Tabla, Cxc_Documento, Es_Cve_Estado FROM Cuenta_X_Cobrar WHERE Cxc_Folio = '01-0000063' 
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 = 'PAGO_CXC' 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
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_VALIDAR_DATOS_CONTABILIDAD_ELECTRONICA'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CENTRO_COSTO_AJUSTE_REDONDEO_EGRESO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CUENTA_CONTABLE_AJUSTE_REDONDEO_EGRESO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CENTRO_COSTO_AJUSTE_REDONDEO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CUENTA_CONTABLE_AJUSTE_REDONDEO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_IMPORTE_MAXIMO_REDONDEO'
UPDATE Grupo_Comercial SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2025-08-27 11:54:08',    Gc_Saldo = Gc_Saldo - 200 WHERE Gc_Cve_Grupo_Comercial = '0000000000'
SELECT GetDate() as Fecha
UPDATE Cadena_Comercial SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2025-08-27 11:54:08',    Cc_Saldo = Cc_Saldo - 200 WHERE Cc_Cve_Cadena_Comercial = '0000000000'
SELECT GetDate() as Fecha
UPDATE Cliente SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2025-08-27 11:54:08',    Cl_Saldo = Cl_Saldo - 200 WHERE Cl_Cve_Cliente = '0000000004'
SELECT GetDate() as Fecha