USP_SEARCH_DDRETURNREVENUE

Search for Direct Debit Payments

Parameters

Parameter	Parameter Type	Mode	Description
@LOOKUPID	nvarchar(100)	IN	Lookup ID
@INDIVIDUALNAME	nvarchar(100)	IN	INDIVIDUALNAME
@KEYNAME	nvarchar(50)	IN	Last/Org/Group name
@FIRSTNAME	nvarchar(50)	IN	First name
@ROUTINGNUMBER	nvarchar(9)	IN	Routing number
@ACCOUNTNUMBER	nvarchar(50)	IN	Account number
@SEARCHAMOUNT	nvarchar(100)	IN	Amount
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.
@REVENUELOOKUPID	nvarchar(100)	IN	Revenue ID
@USDCURRENCYID	uniqueidentifier	IN	USDCURRENCYID
@ENDTOENDID	nvarchar(36)	IN

Definition

Copy



                CREATE procedure dbo.USP_SEARCH_DDRETURNREVENUE(
                    @LOOKUPID nvarchar(100) = null,
                    @INDIVIDUALNAME nvarchar(100) = null,
                    @KEYNAME nvarchar(50) = null,
                    @FIRSTNAME nvarchar(50) = null,
                    @ROUTINGNUMBER nvarchar(9) = null,
                    @ACCOUNTNUMBER nvarchar(50) = null,
                    @SEARCHAMOUNT nvarchar(100) = null,
                    @MAXROWS smallint = 500,
                    @REVENUELOOKUPID nvarchar(100) = null,
                    @USDCURRENCYID uniqueidentifier = null,
                    @ENDTOENDID nvarchar(36) = null
                )
                as
                    exec dbo.USP_GET_KEY_ACCESS;

                    declare @AMOUNT money;
                    begin try
                        set @AMOUNT = cast(@SEARCHAMOUNT as money)
                    end try
                    begin catch
                        set @AMOUNT = 0.00
                    end catch

                    select top(@MAXROWS) REVENUEID, NAME, AMOUNT, REVENUEDATE, ACCOUNTNUMBER, REVENUELOOKUPID, TRANSACTIONCURRENCYID,ENDTOENDID
                    from dbo.UFN_DDRETURN_MATCHINGREVENUES_WITHLOOKUP_2(@LOOKUPID, null, @KEYNAME, @FIRSTNAME, @ROUTINGNUMBER, @ACCOUNTNUMBER, @AMOUNT, @REVENUELOOKUPID, @ENDTOENDID)

                    close symmetric key sym_BBInfinity;