UFN_OPPORTUNITY_GETAMOUNTPAID

This function gets the amount of revenue that has been applied to an opportunity.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_OPPORTUNITY_GETAMOUNTPAID
            (
                @OPPORTUNITYID uniqueidentifier
            ) returns money as
            begin
                declare @BASECURRENCYID uniqueidentifier;
        select @BASECURRENCYID = OPPORTUNITY.BASECURRENCYID from dbo.OPPORTUNITY where OPPORTUNITY.ID = @OPPORTUNITYID;

                return dbo.UFN_OPPORTUNITY_GETAMOUNTPAID_INCURRENCY(@OPPORTUNITYID, @BASECURRENCYID);
            end