UFN_MKTMARKETINGPLANITEM_GETCHILDASSUMPTIONSLIST

Returns a table of all of the assumptions for the children of a given marketing plan item.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PARENTMARKETINGPLANITEMID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTMARKETINGPLANITEM_GETCHILDASSUMPTIONSLIST]
(
  @PARENTMARKETINGPLANITEMID uniqueidentifier
)
returns table
as
  return (select
            [ID],
            [MARKETINGPLANID],
            [LEVEL],
            [NAME],
            [STARTDATE],
            [BASECURRENCYID],
            [BUDGETAMOUNT],
            [TOTALREVENUEGOAL],
            [QUANTITY],
            [RESPONSERATEGOAL],
            [TOTALTRANSACTIONSGOAL]
          from dbo.[MKTMARKETINGPLANITEM]
          where [PARENTMARKETINGPLANITEMID] = @PARENTMARKETINGPLANITEMID);