UFN_MKTMARKETINGPLANITEM_GETBRIEFASSUMPTIONSLIST

Returns a table of all of the assumptions for the selection briefs of a given marketing plan appeal.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MARKETINGPLANITEMID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTMARKETINGPLANITEM_GETBRIEFASSUMPTIONSLIST]
(
  @MARKETINGPLANITEMID uniqueidentifier
)
returns table
as
  return (select
            [ID],
            [MARKETINGPLANID],
            [NAME],
            [BASECURRENCYID],
            [BUDGETAMOUNT],
            [TOTALREVENUEGOAL],
            [QUANTITY],
            [RESPONSERATEGOAL],
            [TOTALTRANSACTIONSGOAL]
          from dbo.[MKTMARKETINGPLANBRIEF]
          where [MARKETINGPLANITEMID] = @MARKETINGPLANITEMID);