UFN_CAMPAIGNSUBPRIORITY_GETTOTALRECEIVEDINCURRENCY

Returns the total amount received for a given campaign sub priority converting amounts to the specified currency.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@CAMPAIGNSUBPRIORITYID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CAMPAIGNSUBPRIORITY_GETTOTALRECEIVEDINCURRENCY
            (
                @CAMPAIGNSUBPRIORITYID uniqueidentifier,
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @CURRENCYID uniqueidentifier = null
            )
            returns money
            as
            begin
                declare @RESULT money;

                select
                    @RESULT = coalesce(sum(dbo.UFN_REVENUESPLIT_GETAMOUNTINCURRENCY(REVENUESPLIT.ID, @CURRENCYID)), 0)
                from
                    dbo.REVENUESPLIT
                inner join dbo.REVENUE with (nolock) on REVENUE.ID = REVENUESPLIT.REVENUEID 
                inner join dbo.REVENUESPLITCAMPAIGN on REVENUESPLITCAMPAIGN.REVENUESPLITID = REVENUESPLIT.ID
                where
                    REVENUESPLITCAMPAIGN.CAMPAIGNSUBPRIORITYID = @CAMPAIGNSUBPRIORITYID
                    and REVENUE.TRANSACTIONTYPECODE = 0
                    and REVENUESPLIT.APPLICATIONCODE in (0, 6, 7, 3)
                    and (REVENUE.DATE >= @STARTDATE or @STARTDATE is null)
                    and (REVENUE.DATE <= @ENDDATE or @ENDDATE is null);

                return @RESULT;
            end