
create PROCEDURE sp_Api5_AppFac_pvtPagosRead
    @tipdoc INT = NULL,
    @numdoc BIGINT = NULL,
    @idcierre INT = NULL
AS
BEGIN
    SET NOCOUNT ON;

    SELECT tipdoc, numdoc, tipopago, linea, rut, sucursal, caja, monto, montopago,
           glosa, idoperacion, estado, totalcancelado, vuelto, idcierre, fechacomprobante,
           tipocomprobante, numerocomprobante, tbktipopagotbk, tbktipotarjeta, tbk,
           redondeo, hostid, loging, fecing, logmod, fecmod
    FROM pvtPagos
    WHERE (@tipdoc IS NULL OR @tipdoc = 0 OR tipdoc = @tipdoc)
      AND (@numdoc IS NULL OR @numdoc = 0 OR numdoc = @numdoc)
      AND (@idcierre IS NULL OR @idcierre = 0 OR idcierre = @idcierre);
END;
