Primary Key Field Type
 ID uniqueidentifier

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

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

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

Trigger Name Description
 TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_INSERTUPDATE_CURRENCY
 TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_AUDIT_UPDATE
 TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_AUDIT_DELETE

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

Entity-Relationship diagram of this table