Primary Key Field Type
 ID uniqueidentifier

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) 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 Use internally to indicate when the assumptions for this brief were first entered; used when performing currency conversions.

Foreign Key Field Type Null Notes Description
 MARKETINGPLANITEMID uniqueidentifier MKTMARKETINGPLANITEM.ID The parent ID for this segment.
 PACKAGEID uniqueidentifier MKTPACKAGE.ID The package associated with the segment.
 MARKETINGPLANID uniqueidentifier 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 CURRENCY.ID The base currency associated with this segment summary's costs and revenue.
 CURRENCYEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert base currency amounts to organization amounts.

Index Name Field(s) Unique Primary Clustered
 IX_MKTMARKETINGPLANBRIEF_BASECURRENCYID BASECURRENCYID      
 IX_MKTMARKETINGPLANBRIEF_CURRENCYEXCHANGERATEID CURRENCYEXCHANGERATEID      
 IX_MKTMARKETINGPLANBRIEF_DATEADDED DATEADDED    
 IX_MKTMARKETINGPLANBRIEF_DATECHANGED DATECHANGED      
 IX_MKTMARKETINGPLANBRIEF_MARKETINGPLANID MARKETINGPLANID      
 IX_MKTMARKETINGPLANBRIEF_PACKAGEID PACKAGEID      
 PK_MKTMARKETINGPLANBRIEF ID  
 UIX_MKTMARKETINGPLANBRIEF_MARKETINGPLANITEMID_NAME MARKETINGPLANITEMID, NAME    

Trigger Name Description
 TR_MKTMARKETINGPLANBRIEF_AUDIT_UPDATE
 TR_MKTMARKETINGPLANBRIEF_AUDIT_DELETE
 TR_MKTMARKETINGPLANBRIEF_INSERTUPDATE_CURRENCY

Referenced by Field
 MKTSEGMENTATIONSEGMENT MARKETINGPLANBRIEFID

Entity-Relationship diagram of this table