MKTMARKETINGPLANITEM (4.0SP20)

ID

uniqueidentifier

PLANITEMCATEGORYCODEID

uniqueidentifier

true

The category associated with this marketing plan item.

PARENTMARKETINGPLANITEMID

uniqueidentifier

true

The parent item for this item; null for the item at the top-most level.

MARKETINGPLANID

uniqueidentifier

true

The marketing plan to which this item belongs.

SOURCECODEID

uniqueidentifier

true

The source code layout used for this marketing effort, for items representing planned marketing efforts.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

PARTDEFINITIONVALUESID

uniqueidentifier

true

FK to MKTSOURCECODEPARTDEFINITIONVALUES

BASECURRENCYID

uniqueidentifier

true

The base currency associated with this item.

CURRENCYEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert base currency amounts to organization amounts.

CODE

nvarchar(10)

false

An abbreviation for this level used when building the source code.

NAME

nvarchar(100)

false

A short description of the marketing plan item.

GOALS

nvarchar(max)

false

ISAPPROVED

bit

false

APPROVEDBY

nvarchar(100)

false

The name of the person approving the marketing plan item.

DATEAPPROVED

datetime

true

STARTDATE

UDT_FUZZYDATE

false

The date that the indicates the start of activity for this item.

ENDDATE

UDT_FUZZYDATE

false

The date that indicates the end of all activity for this item.

BUDGETAMOUNT

money

false

The budget for this marketing plan item, stored in its base currency.

TOTALREVENUEGOAL

money

false

The total monetary goal for this item, stored in its base currency.

QUANTITY

int

false

The expected number of pieces to be sent.

TOTALTRANSACTIONSGOAL

int

false

The goal value for the number of transaction for this item.

AVERAGEREVENUEGOAL

money

false

The goal value for average revenue for this item, stored in its base currency.

RESPONSERATEGOAL

decimal(20, 4)

false

The goal value for rate of response.

LEVEL

smallint

false

This item's level, from the plan's template.

APPEALID

nvarchar(20)

false

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

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

MAILDATE

datetime

true

For planned marketing effort items, the date the marketing effort is to be sent out.

ORGANIZATIONBUDGETAMOUNT

money

false

The budget for this marketing plan item, stored in the organization currency.

ORGANIZATIONTOTALREVENUEGOAL

money

false

The total monetary goal for this item, stored in the organization currency.

ORGANIZATIONAVERAGEREVENUEGOAL

money

false

The goal value for average revenue for this item, stored in the organization currency.

DATEASSUMPTIONSADDED

datetime

true

Use internally to indicate when the assumptions for this item were first entered; used when performing currency conversions.

IX_MKTMARKETINGPLANITEM_BASECURRENCYID

False

False

False

IX_MKTMARKETINGPLANITEM_CURRENCYEXCHANGERATEID

False

False

False

IX_MKTMARKETINGPLANITEM_DATEADDED

False

False

True

IX_MKTMARKETINGPLANITEM_DATECHANGED

False

False

False

IX_MKTMARKETINGPLANITEM_ID

False

False

False

IX_MKTMARKETINGPLANITEM_MARKETINGPLANID

False

False

False

IX_MKTMARKETINGPLANITEM_PARENTMARKETINGPLANITEMID

False

False

False

IX_MKTMARKETINGPLANITEM_PARTDEFINITIONVALUESID

False

False

False

IX_MKTMARKETINGPLANITEM_SOURCECODEID

False

False

False

PK_MKTMARKETINGPLANITEM

True

True

False

UC_MKTMARKETINGPLANITEM_NAME

True

False

False

TR_MKTMARKETINGPLANITEM_AUDIT_UPDATE

TR_MKTMARKETINGPLANITEM_AUDIT_DELETE

TR_MKTMARKETINGPLANITEM_INSERTUPDATE_CURRENCY

MKTMARKETINGPLANBRIEF

MARKETINGPLANITEMID

MKTMARKETINGPLANITEMATTACHMENT

MARKETINGPLANITEMID

MKTMARKETINGPLANITEMEXPENSE

MARKETINGPLANITEMID

MKTMARKETINGPLANITEMSPEC

MARKETINGPLANITEMID

MKTMARKETINGPLANITEMTASK

MARKETINGPLANITEMID

MKTSEGMENTATION

MARKETINGPLANITEMID

MKTSOURCECODEPART

MARKETINGPLANITEMID