UFN_OPPORTUNITY_REVENUECOMMITTED

Calculates the amount of revenue committed to an opportunity.

Return

Return Type
money

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_OPPORTUNITY_REVENUECOMMITTED(@ID uniqueidentifier)
            returns money 
            with execute as caller
            as begin

                declare @BASECURRENCYID uniqueidentifier;
                select @BASECURRENCYID = OPPORTUNITY.BASECURRENCYID from dbo.OPPORTUNITY where OPPORTUNITY.ID = @ID;

                return dbo.UFN_OPPORTUNITY_REVENUECOMMITTEDINCURRENCY(@ID, @BASECURRENCYID);
            end