MKTPACKAGE (4.0)

Stores information pertaining to package records.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
SITEID	uniqueidentifier	true	SITE.ID	The site to which this package belongs.
PACKAGECATEGORYCODEID	uniqueidentifier	true	MKTPACKAGECATEGORYCODE.ID	FK to MKTPACKAGECATEGORYCODE
LETTERCODEID	uniqueidentifier	true	LETTERCODE.ID	The letter associated with this mail package.
CREATIVEID	uniqueidentifier	true	MKTCREATIVE.ID	The creative associated with this public media package.
EXPORTDEFINITIONID	uniqueidentifier	true	EXPORTDEFINITION.ID	The export definition associated with this package, if one is not already associated with its content.
PARTDEFINITIONVALUESID	uniqueidentifier	true	MKTSOURCECODEPARTDEFINITIONVALUES.ID	FK to MKTSOURCECODEPARTDEFINITIONVALUES
CHANNELPARTDEFINITIONVALUESID	uniqueidentifier	true	MKTSOURCECODEPARTDEFINITIONVALUES.ID	FK to MKTSOURCECODEPARTDEFINITIONVALUES
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this package.
CURRENCYEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert from amount to organization amount.

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)	false	''	The name of the package.
DESCRIPTION	nvarchar(255)	false	''	The description of the package.
UNITCOST	money	false	0	The base cost of the package.
CODE	nvarchar(10)	false	''	A unique code that identifies the package.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
CHANNELCODE	tinyint	false	0	0=Mail, 1=Email, 2=Phone, 3=Public media
NETCOMMUNITYTEMPLATEID	int	false	0	The ID of the NetCommunity email message associated with this email package
NETCOMMUNITYDATASOURCEID	int	false	0	The ID of the NetCommunity data source associated with this email package
CHANNEL	nvarchar(12) (Computed)	true		Provides a translation for the 'CHANNELCODE' field.
COSTDISTRIBUTIONMETHODCODE	tinyint	false	0	The method to be used to apply the package's base cost to a marketing effort.
DOCUMENTFILENAME	nvarchar(255)	false	''	Filename of the document associated with this package.
DOCUMENTFILE	varbinary	true		The document associated with this package.
CHANNELSOURCECODE	nvarchar(10)	false	''	Code that defines the source code of the channel.
ORGANIZATIONUNITCOST	money	false	0	The amount of the unit cost in organization currency.
ISSYSTEM	bit	false	0	Flag used to hide packages meant for system use only.
COSTDISTRIBUTIONMETHOD	nvarchar(37) (Computed)	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_MKTPACKAGE_BASECURRENCYID	BASECURRENCYID	False	False	False
IX_MKTPACKAGE_CHANNELPARTDEFINITIONVALUESID	CHANNELPARTDEFINITIONVALUESID	False	False	False
IX_MKTPACKAGE_CREATIVEID	CREATIVEID	False	False	False
IX_MKTPACKAGE_CURRENCYEXCHANGERATEID	CURRENCYEXCHANGERATEID	False	False	False
IX_MKTPACKAGE_DATEADDED	DATEADDED	False	False	True
IX_MKTPACKAGE_DATECHANGED	DATECHANGED	False	False	False
IX_MKTPACKAGE_EXPORTDEFINITIONID	EXPORTDEFINITIONID	False	False	False
IX_MKTPACKAGE_ID	ID	False	False	False
IX_MKTPACKAGE_LETTERCODEID	LETTERCODEID	False	False	False
IX_MKTPACKAGE_NETCOMMUNITYDATASOURCEID	NETCOMMUNITYDATASOURCEID	False	False	False
IX_MKTPACKAGE_PARTDEFINITIONVALUESID	PARTDEFINITIONVALUESID	False	False	False
IX_MKTPACKAGE_SITEID	SITEID	False	False	False
PK_MKTPACKAGE	ID	True	True	False
UC_MKTPACKAGE_NAME	NAME	True	False	False

Triggers
Trigger Name	Description
TR_MKTPACKAGE_AUDIT_UPDATE
TR_MKTPACKAGE_AUDIT_DELETE
TR_MKTPACKAGE_IU_ORGANIZATIONUNITCOST

Referenced by
Referenced by	Field
APPEALMAILINGSETUP	MAILPACKAGEID
APPEALMAILINGSETUP	EMAILPACKAGEID
APPEALMAILINGSETUPLETTER	MAILPACKAGEID
APPEALMAILINGSETUPLETTER	EMAILPACKAGEID
BATCHDIRECTMARKETINGEFFORTPACKAGE	MKTPACKAGEID
BATCHREVENUECONSTITUENTAPPEAL	MKTPACKAGEID
COMMUNICATIONLETTER	MAILPACKAGEID
COMMUNICATIONLETTER	EMAILPACKAGEID
CONSTITUENTAPPEAL	MKTPACKAGEID
INVITATION	MAILPACKAGEID
INVITATION	EMAILPACKAGEID
INVITATIONHISTORY	MAILPACKAGEID
INVITATIONHISTORY	EMAILPACKAGEID
INVITEEHISTORY	MKTPACKAGEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE	PACKAGEID
MKTFINDERNUMBERCONSTITUENTAPPEAL	MKTPACKAGEID
MKTMARKETINGPLANBRIEF	PACKAGEID
MKTMEMBERSHIPMAILINGTEMPLATERULE	PACKAGEID
MKTPACKAGECREATIVE	PACKAGEID
MKTPACKAGEDOCUMENT	PACKAGEID
MKTPACKAGEEXPENSE	PACKAGEID
MKTPACKAGEMATERIAL	PACKAGEID
MKTSEGMENTATIONLISTACTIVE	PACKAGEID
MKTSEGMENTATIONPACKAGE	PACKAGEID
MKTSEGMENTATIONSEGMENT	PACKAGEID
MKTSEGMENTATIONTESTSEGMENT	PACKAGEID
MKTSPONSORSHIPMAILINGTEMPLATERULE	PACKAGEID
PLEDGEREMINDERSENT	PACKAGEID
REVENUELETTER	MKTPACKAGEID
REVENUELETTERMARKETING	MKTPACKAGEID