Primary Key Field Type
 ID uniqueidentifier

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
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 MAILDATE datetime 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 Use internally to indicate when the assumptions for this item were first entered; used when performing currency conversions.

Foreign Key Field Type Null Notes Description
 PLANITEMCATEGORYCODEID uniqueidentifier MKTPLANITEMCATEGORYCODE.ID The category associated with this marketing plan item.
 PARENTMARKETINGPLANITEMID uniqueidentifier MKTMARKETINGPLANITEM.ID The parent item for this item; null for the item at the top-most level.
 MARKETINGPLANID uniqueidentifier MKTMARKETINGPLAN.ID The marketing plan to which this item belongs.
 SOURCECODEID uniqueidentifier 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 MKTSOURCECODEPARTDEFINITIONVALUES.ID FK to MKTSOURCECODEPARTDEFINITIONVALUES
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this item.
 CURRENCYEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert base currency amounts to organization amounts.

Index Name Field(s) Unique Primary Clustered
 IX_MKTMARKETINGPLANITEM_BASECURRENCYID BASECURRENCYID      
 IX_MKTMARKETINGPLANITEM_CURRENCYEXCHANGERATEID CURRENCYEXCHANGERATEID      
 IX_MKTMARKETINGPLANITEM_DATEADDED DATEADDED    
 IX_MKTMARKETINGPLANITEM_DATECHANGED DATECHANGED      
 IX_MKTMARKETINGPLANITEM_MARKETINGPLANID MARKETINGPLANID      
 IX_MKTMARKETINGPLANITEM_PARENTMARKETINGPLANITEMID PARENTMARKETINGPLANITEMID      
 IX_MKTMARKETINGPLANITEM_PARTDEFINITIONVALUESID PARTDEFINITIONVALUESID      
 IX_MKTMARKETINGPLANITEM_SOURCECODEID SOURCECODEID      
 PK_MKTMARKETINGPLANITEM ID  
 UC_MKTMARKETINGPLANITEM_NAME NAME    

Trigger Name Description
 TR_MKTMARKETINGPLANITEM_AUDIT_UPDATE
 TR_MKTMARKETINGPLANITEM_AUDIT_DELETE
 TR_MKTMARKETINGPLANITEM_INSERTUPDATE_CURRENCY

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

Entity-Relationship diagram of this table