MKTACKNOWLEDGEMENTMAILINGTEMPLATE (4.0SP12)

Stores information pertaining to a marketing acknowledgement template.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
SOURCECODEID	uniqueidentifier	true	MKTSOURCECODE.ID	The source code layout used for this marketing acknowledgement template.
SITEID	uniqueidentifier	true	SITE.ID	The site to which this acknowledgement mailng template belongs.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
ADDRESSPROCESSINGOPTIONID	uniqueidentifier	true	ADDRESSPROCESSINGOPTION.ID	The address processing options to be used for this marketing acknowledgement.
NAMEFORMATPARAMETERID	uniqueidentifier	true	NAMEFORMATPARAMETER.ID	The name format options to be used for this marketing acknowledgement.
PARTDEFINITIONVALUESID	uniqueidentifier	true	MKTSOURCECODEPARTDEFINITIONVALUES.ID	FK to MKTSOURCECODEPARTDEFINITIONVALUES
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this acknowledgment template.

Fields
Field	Field Type	Null	Notes	Description
CODE	nvarchar(10)	false	''	Source code component for this marketing acknowledgement template.
NAME	nvarchar(50)	false	''	A name for the marketing acknowledgement template.
DESCRIPTION	nvarchar(255)	false	''	A description about the marketing acknowledgement template.
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.
MARKLETTERSACKNOWLEDGED	bit	false	0	Indicates whether or not letters for this process should be marked as acknowledged/receipted.
ACKNOWLEDGEDATETYPECODE	tinyint	false	0	Designates whether to use today's date or a specific date in the marketing acknowledgement process as the acknowledge/receipt date.
ACKNOWLEDGEDATE	datetime	true		This date is used as the acknowledge/receipt date when marking records as acknowledged/receipted.
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	false	0	Indicates the type of date to be used when considering seasonal addresses.
ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	true		The specific date to be used when considering seasonal addresses.
USEADDRESSPROCESSING	bit	false	0	Determines whether or not to apply address processing options when performing calculations and exporting a marketing acknowledgement.
ACKNOWLEDGEDATETYPE	nvarchar(13) (Computed)	true		Provides a translation for the 'ACKNOWLEDGEDATETYPECODE' field.
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE	nvarchar(15) (Computed)	true		Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field.
MULTIPLELETTERSPERREVENUE	bit	false	0	Whether or not to allow multiple letters per revenue.
RUNACTIVATEANDEXPORT	bit	false	0	Run activate and export upon process completion.
CACHESOURCEANALYSISRULEDATA	bit	false	1	Indicates whether source analysis rule data should be cached during activation.
ISSYSTEM	bit	false	0	Flag for hiding acknowledgement mailing templates meant for system use only.
RUNMARKETINGEXCLUSIONSREPORT	bit	false	1

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_ADDRESSPROCESSINGOPTIONID	ADDRESSPROCESSINGOPTIONID	False	False	False
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_BASECURRENCYID	BASECURRENCYID	False	False	False
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_DATEADDED	DATEADDED	False	False	True
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_DATECHANGED	DATECHANGED	False	False	False
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_NAMEFORMATPARAMETERID	NAMEFORMATPARAMETERID	False	False	False
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_PARTDEFINITIONVALUESID	PARTDEFINITIONVALUESID	False	False	False
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_SITEID	SITEID	False	False	False
IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_SOURCECODEID	SOURCECODEID	False	False	False
PK_MKTACKNOWLEDGEMENTMAILINGTEMPLATE	ID	True	True	False
UC_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_NAME	NAME	True	False	False

Triggers
Trigger Name	Description
TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_AUDIT_UPDATE
TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_AUDIT_DELETE
TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_INSERTUPDATE_CURRENCY

Referenced by
Referenced by	Field
MKTACKNOWLEDGEMENTMAILINGPROCESS	ACKNOWLEDGEMENTMAILINGTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEAPPEAL	ACKNOWLEDGEMENTTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE	ACKNOWLEDGEMENTMAILINGTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEEMAILOPTIONS	ACKNOWLEDGEMENTMAILINGTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEEXPORT	ACKNOWLEDGEMENTMAILINGTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEFILTERSELECTION	ACKNOWLEDGEMENTMAILINGTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATEKPI	ACKNOWLEDGEMENTTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE	ACKNOWLEDGEMENTMAILINGTEMPLATEID
MKTACKNOWLEDGEMENTMAILINGTEMPLATESEED	ACKNOWLEDGEMENTMAILINGTEMPLATEID
MKTSOURCECODEPART	ACKNOWLEDGEMENTMAILINGTEMPLATEID