SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'ZADD_SERVIDOR_TIMBRADO_LOCAL' UPDATE Factura_Serie SET Fs_Folio = 719 WHERE Fs_Cve_Factura_Serie = 'CP' AND Es_Cve_Estado <> 'BA' AND Fs_Tipo IN ('04') update recibo_pago set fecha_alta = '2019-09-03 10:56:44' where rp_folio = 'AL-0001108' SELECT GetDate() as Fecha INSERT INTO ZADD_Recibo_Pago (Rp_Folio,Rp_Serie,Rp_Serie_Folio,Rp_UUID_Relacionado,Rp_Banco_Cuenta) values ('AL-0001108','CP','00000718','','0010') SELECT Fs_Folio FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'CP' AND Es_Cve_Estado <> 'BA' AND Fs_Tipo IN ('04') select top 1 Deposito_Pago.Bc_Cve_Banco_Cuenta from Recibo_Pago inner join Deposito_Pago on Deposito_Pago.Dp_Folio = Recibo_Pago.Rp_Folio_Deposito where Rp_Folio = 'AL-0001108' SELECT Sc_Comprobante_Pago_Serie AS Nombre FROM SUCURSAL WHERE SC_CVE_SUCURSAL = '0004' select rp_folio from ZADD_Recibo_Pago where rp_folio = 'AL-0001108' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_RECIBO_PAGO_COMPROBANTE' SELECT Recibo_Pago.Rp_Folio, Recibo_Pago.Rp_Fecha, Recibo_Pago.Sc_Cve_Sucursal, Cliente.Cl_Cve_Cliente, Recibo_Pago.Fecha_Alta as FechaEmision, Recibo_Pago.Rp_Referencia as Rp_Referencia, isnull(ZADD_Recibo_Pago.Rp_Serie,'') + isnull(ZADD_Recibo_Pago.Rp_Serie_Folio,'') as Folio, IsNull(Comprobante_Digital.Cd_Timbre_UUID, '') as UUID, sum(recibo_pago.rp_importe) as Total, Cliente.Cl_R_F_C as RFC, Cliente.Cl_Razon_Social FROM Recibo_Pago INNER JOIN Sucursal On Sucursal.Sc_Cve_Sucursal = Recibo_Pago.Sc_Cve_Sucursal INNER JOIN Cliente ON Recibo_Pago.Rp_Solicitar_Valor = Cliente.Cl_Cve_Cliente LEFT JOIN ZADD_Recibo_Pago ON ZADD_Recibo_Pago.Rp_Folio = Recibo_Pago.Rp_Folio LEFT JOIN comprobante_digital ON comprobante_digital.cd_tabla = 'recibo_pago' and comprobante_digital.cd_documento = Recibo_Pago.Rp_Folio WHERE Recibo_Pago.Rp_folio not in (select pp_documento from Pago_Parcial where es_cve_estado <> 'CA' and pp_documento = recibo_pago.rp_folio and pp_tabla = 'recibo_pago' ) and Recibo_Pago.Trp_Cve_Tipo_Recibo_Pago in ('0002') and Recibo_Pago.Rp_Fecha BETWEEN '2019-08-01' AND '2019-08-31' AND Recibo_Pago.Es_Cve_Estado <> 'CA' GROUP BY Recibo_Pago.Sc_Cve_Sucursal, Cliente.Cl_Cve_Cliente, Recibo_Pago.Rp_Folio, Recibo_Pago.Rp_Fecha, Recibo_Pago.Rp_Referencia, Recibo_Pago.Fecha_Alta, Recibo_Pago.Rp_Cheque, ZADD_Recibo_Pago.Rp_Serie,ZADD_Recibo_Pago.Rp_Serie_Folio, Cliente.Cl_R_F_C, Cliente.Cl_Razon_Social, IsNull(Comprobante_Digital.Cd_Timbre_UUID, '') SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'ZADD_TIPO_RECIBO_GENERA_COMPROBANTE' SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'RECIBO_PAGO' AND Clave = 'AL-0001106' and not imagen is null SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CAPP33' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CAPP33' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CAPP33' ORDER BY Fr_ID EXEC SP_RPT_CAPP33_2 'RECIBO_PAGO', 'AL-0001106', '03', '105' 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 = 'CAPP33' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'SEGIPP' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'SEGIPP' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'SEGIPP' ORDER BY Fr_ID EXEC SP_RPT_SEGIPP_2 'RECIBO_PAGO', 'AL-0001106', '02', '105' 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 = 'SEGIPP' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'SEGIPP' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'SEGIPP' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'SEGIPP' ORDER BY Fr_ID EXEC SP_RPT_SEGIPP_2 'RECIBO_PAGO', 'AL-0001106', '01', '100' 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 = 'SEGIPP' SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'USD' EXEC SP_RPT_CPRCJA_3 'AL-0001106' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CPRCJA' ORDER BY Fr_ID SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'CPRCJA2' and not imagen is null EXEC SP_RPT_CPRCJA_1 'AL-0001106' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CPRCJA' ORDER BY Fr_ID SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'CPRCJA2' and not imagen is null EXEC SP_RPT_CPRCJA_1 'AL-0001106' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CPRCJA' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CPRCJA' ORDER BY Fr_ID EXEC SP_RPT_CPRCJA_2 'AL-0001106' 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 = 'CPRCJA' 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 = 'LLEON' 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 = 'CPRCJA' 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 = 'EMAIL_USUARIO'