MKTMARKETINGPLANITEM

Stores information pertaining to an instance of a level in a marketing plan.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
CODE	nvarchar(10)		Default = ''	An abbreviation for this level used when building the source code.
NAME	nvarchar(100)		Default = ''	A short description of the marketing plan item.
GOALS	nvarchar(max)		Default = ''
ISAPPROVED	bit		Default = 0
APPROVEDBY	nvarchar(100)		Default = ''	The name of the person approving the marketing plan item.
DATEAPPROVED	datetime	yes
STARTDATE	UDT_FUZZYDATE		Default = '00000000'	The date that the indicates the start of activity for this item.
ENDDATE	UDT_FUZZYDATE		Default = '00000000'	The date that indicates the end of all activity for this item.
BUDGETAMOUNT	money		Default = 0	The budget for this marketing plan item, stored in its base currency.
TOTALREVENUEGOAL	money		Default = 0	The total monetary goal for this item, stored in its base currency.
QUANTITY	int		Default = 0	The expected number of pieces to be sent.
TOTALTRANSACTIONSGOAL	int		Default = 0	The goal value for the number of transaction for this item.
AVERAGEREVENUEGOAL	money		Default = 0	The goal value for average revenue for this item, stored in its base currency.
RESPONSERATEGOAL	decimal(20, 4)		Default = 0	The goal value for rate of response.
LEVEL	smallint		Default = ((0))	This item's level, from the plan's template.
APPEALID	nvarchar(20)		Default = ''	An ID to be used to create an appeal that will be associated with gifts received as a result of the planned marketing effort, after it is created and activated.
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
MAILDATE	datetime	yes		For planned marketing effort items, the date the marketing effort is to be sent out.
ORGANIZATIONBUDGETAMOUNT	money		Default = 0	The budget for this marketing plan item, stored in the organization currency.
ORGANIZATIONTOTALREVENUEGOAL	money		Default = 0	The total monetary goal for this item, stored in the organization currency.
ORGANIZATIONAVERAGEREVENUEGOAL	money		Default = 0	The goal value for average revenue for this item, stored in the organization currency.
DATEASSUMPTIONSADDED	datetime	yes		Use internally to indicate when the assumptions for this item were first entered; used when performing currency conversions.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
PLANITEMCATEGORYCODEID	uniqueidentifier	yes	MKTPLANITEMCATEGORYCODE.ID	The category associated with this marketing plan item.
PARENTMARKETINGPLANITEMID	uniqueidentifier	yes	MKTMARKETINGPLANITEM.ID	The parent item for this item; null for the item at the top-most level.
MARKETINGPLANID	uniqueidentifier	yes	MKTMARKETINGPLAN.ID	The marketing plan to which this item belongs.
SOURCECODEID	uniqueidentifier	yes	MKTSOURCECODE.ID	The source code layout used for this marketing effort, for items representing planned marketing efforts.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
PARTDEFINITIONVALUESID	uniqueidentifier	yes	MKTSOURCECODEPARTDEFINITIONVALUES.ID	FK to MKTSOURCECODEPARTDEFINITIONVALUES
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The base currency associated with this item.
CURRENCYEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert base currency amounts to organization amounts.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MKTMARKETINGPLANITEM_BASECURRENCYID	BASECURRENCYID
IX_MKTMARKETINGPLANITEM_CURRENCYEXCHANGERATEID	CURRENCYEXCHANGERATEID
IX_MKTMARKETINGPLANITEM_DATEADDED	DATEADDED			yes
IX_MKTMARKETINGPLANITEM_DATECHANGED	DATECHANGED
IX_MKTMARKETINGPLANITEM_ID	ID
IX_MKTMARKETINGPLANITEM_MARKETINGPLANID	MARKETINGPLANID
IX_MKTMARKETINGPLANITEM_PARENTMARKETINGPLANITEMID	PARENTMARKETINGPLANITEMID
IX_MKTMARKETINGPLANITEM_PARTDEFINITIONVALUESID	PARTDEFINITIONVALUESID
IX_MKTMARKETINGPLANITEM_SOURCECODEID	SOURCECODEID
PK_MKTMARKETINGPLANITEM	ID	yes	yes
UC_MKTMARKETINGPLANITEM_NAME	NAME	yes

Triggers

Trigger Name	Description
TR_MKTMARKETINGPLANITEM_AUDIT_UPDATE
TR_MKTMARKETINGPLANITEM_AUDIT_DELETE
TR_MKTMARKETINGPLANITEM_INSERTUPDATE_CURRENCY

Referenced by

Referenced by	Field
MKTMARKETINGPLANBRIEF	MARKETINGPLANITEMID
MKTMARKETINGPLANITEMATTACHMENT	MARKETINGPLANITEMID
MKTMARKETINGPLANITEMEXPENSE	MARKETINGPLANITEMID
MKTMARKETINGPLANITEMSPEC	MARKETINGPLANITEMID
MKTMARKETINGPLANITEMTASK	MARKETINGPLANITEMID
MKTSEGMENTATION	MARKETINGPLANITEMID
MKTSOURCECODEPART	MARKETINGPLANITEMID