USP_SEARCHLIST_UNLINKEDCREDITPAYMENT

Search for refund payments that have been reconciled but are not linked to a bank account deposit.

Parameters

Parameter	Parameter Type	Mode	Description
@AMOUNT	money	IN	Amount
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



create procedure dbo.USP_SEARCHLIST_UNLINKEDCREDITPAYMENT
(
    @AMOUNT money = null,
    @MAXROWS smallint = 500
)
as

    select top(@MAXROWS)
        CREDITPAYMENT.ID
        ,CREDIT.TRANSACTIONDATE
        ,CREDITPAYMENT.AMOUNT
        ,CREDITPAYMENT.PAYMENTMETHOD
        ,convert(nvarchar(100), SALESORDER.SEQUENCEID) [ORDER]
        ,dbo.UFN_CONSTITUENT_BUILDNAME(CREDIT.CONSTITUENTID) as [PATRONNAME]
        ,dbo.UFN_APPUSER_GETNAME(APPUSER.ID) as [USERNAME]
    from dbo.CREDITPAYMENT
    inner join dbo.CREDIT on CREDIT.ID = CREDITPAYMENT.CREDITID
    left join dbo.BANKACCOUNTDEPOSITCREDITPAYMENT LINK on LINK.ID = CREDITPAYMENT.ID
    inner join dbo.APPUSER on CREDIT.APPUSERID = APPUSER.ID
    inner join dbo.SALESORDER on SALESORDER.ID = CREDIT.SALESORDERID
    where CREDITPAYMENT.RECONCILIATIONID is not null and LINK.DEPOSITID is null
        and (@AMOUNT is null or CREDITPAYMENT.AMOUNT = @AMOUNT)