UFN_OPPORTUNITY_DESIGNATION_2

Returns the designation splits for an opportunity (including multicurrency fields).

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_OPPORTUNITY_DESIGNATION_2(
  @OPPORTUNITYID uniqueidentifier
)
returns table
as return
    select 
        ID,
        DESIGNATIONID,
        AMOUNT,
        TRANSACTIONAMOUNT,
        ORGANIZATIONAMOUNT,
        SEQUENCE,
        CONSTITUENTID,
        NF.NAME as CONSTITUENTNAME,
        BASECURRENCYID,
        TRANSACTIONCURRENCYID,
        BASEEXCHANGERATEID,
        ORGANIZATIONEXCHANGERATEID,
        FUNDINGMETHODCODEID,
        CATEGORYCODEID,
        TYPECODEID,
        USECODEID
    from
        dbo.OPPORTUNITYDESIGNATION 
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENTID) NF
    where
        OPPORTUNITYID=@OPPORTUNITYID