MKTMARKETINGPLANBRIEF
Stores the marketing plan segment summary information.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| NAME |
nvarchar(100) |
|
Default = '' |
A short description of the segment summary. |
| DESCRIPTION |
nvarchar(max) |
|
Default = '' |
|
| QUANTITY |
int |
|
Default = 0 |
Number of expected pieces to be sent. |
| UNITCOST |
money |
|
Default = 0 |
The expected per unit cost of the package to be sent, stored in the base currency. |
| BUDGETAMOUNT |
money |
|
Default = 0 |
The budget amount for this segment, stored in the base currency. |
| TOTALREVENUEGOAL |
money |
|
Default = 0 |
The total monetary goal for this segment, stored in the base currency. |
| TOTALTRANSACTIONSGOAL |
int |
|
Default = 0 |
The goal value for the number of transaction for this segment. |
| AVERAGEREVENUEGOAL |
money |
|
Default = 0 |
The goal value for average revenue for this segment, stored in the base currency. |
| RESPONSERATEGOAL |
decimal(20, 4) |
|
Default = 0 |
The goal value for rate of response. |
| SEQUENCE |
int |
|
Default = 0 |
|
| COLLAPSED |
bit |
|
Default = 0 |
The collapsed/expanded state of the segment in the marketing effort segments UI. |
| 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. |
| ORGANIZATIONUNITCOST |
money |
|
Default = 0 |
The expected per unit cost of the package to be sent, stored in the organization currency. |
| ORGANIZATIONBUDGETAMOUNT |
money |
|
Default = 0 |
The budget amount for this segment, stored in the organization currency. |
| ORGANIZATIONTOTALREVENUEGOAL |
money |
|
Default = 0 |
The total monetary goal for this segment, stored in the organization currency. |
| ORGANIZATIONAVERAGEREVENUEGOAL |
money |
|
Default = 0 |
The goal value for average revenue for this segment, stored in the organization currency. |
| DATEASSUMPTIONSADDED |
datetime |
yes |
|
Use internally to indicate when the assumptions for this brief were first entered; used when performing currency conversions. |
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| MARKETINGPLANITEMID |
uniqueidentifier |
yes |
MKTMARKETINGPLANITEM.ID
|
The parent ID for this segment. |
| PACKAGEID |
uniqueidentifier |
yes |
MKTPACKAGE.ID
|
The package associated with the segment. |
| MARKETINGPLANID |
uniqueidentifier |
yes |
MKTMARKETINGPLAN.ID
|
Use this ID when looking up level information in the PLANTEMPLATEITEM table. |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| BASECURRENCYID |
uniqueidentifier |
yes |
CURRENCY.ID
|
The base currency associated with this segment summary's costs and revenue. |
| 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_MKTMARKETINGPLANBRIEF_BASECURRENCYID |
BASECURRENCYID |
|
|
|
| IX_MKTMARKETINGPLANBRIEF_CURRENCYEXCHANGERATEID |
CURRENCYEXCHANGERATEID |
|
|
|
| IX_MKTMARKETINGPLANBRIEF_DATEADDED |
DATEADDED |
|
|
yes |
| IX_MKTMARKETINGPLANBRIEF_DATECHANGED |
DATECHANGED |
|
|
|
| IX_MKTMARKETINGPLANBRIEF_MARKETINGPLANID |
MARKETINGPLANID |
|
|
|
| IX_MKTMARKETINGPLANBRIEF_PACKAGEID |
PACKAGEID |
|
|
|
| PK_MKTMARKETINGPLANBRIEF |
ID |
yes |
yes |
|
| UIX_MKTMARKETINGPLANBRIEF_MARKETINGPLANITEMID_NAME |
MARKETINGPLANITEMID, NAME |
yes |
|
|
Triggers
Referenced by