UFN_BANKACCOUNTDEPOSIT_GETAPPLICATIONFROMREVENUESPLIT

This function returns the application from the revenue split.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BANKACCOUNTDEPOSIT_GETAPPLICATIONFROMREVENUESPLIT
            (
                @REVENUEID uniqueidentifier
            )
            returns nvarchar(100)
            with execute as caller
            as begin
                declare @APPLICATION nvarchar(100) = 'Multiple';
                declare @NUMBEROFRECORDS int; 

                select @APPLICATION = APPLICATION from dbo.FINANCIALTRANSACTIONLINEITEM T1 inner join dbo.REVENUESPLIT_EXT  T2 on T1.ID = T2.ID where T1.FINANCIALTRANSACTIONID = @REVENUEID  group by APPLICATION  having COUNT(T1.FINANCIALTRANSACTIONID) = 1

    /*            

                select
                    @NUMBEROFRECORDS = count(REVENUESPLIT.APPLICATION) 
                from
                    dbo.REVENUESPLIT
                    inner join dbo.REVENUE on
                    REVENUESPLIT.REVENUEID = REVENUE.ID
                where
                    REVENUESPLIT.REVENUEID = @REVENUEID

                if @NUMBEROFRECORDS > 1
                    set @APPLICATION = 'Multiple'
                else
                    set @APPLICATION = (select REVENUESPLIT.APPLICATION from dbo.REVENUESPLIT
                    inner join dbo.REVENUE on
                    REVENUESPLIT.REVENUEID = REVENUE.ID
                where
                    REVENUESPLIT.REVENUEID = @REVENUEID)
*/





                return @APPLICATION
            end