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