MKTACKNOWLEDGEMENTMAILINGTEMPLATE
Stores information pertaining to a marketing acknowledgement template.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| 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) | yes | 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 | yes | 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 | yes | 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) | yes | 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) | yes | 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 Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SOURCECODEID | uniqueidentifier | yes | MKTSOURCECODE.ID | The source code layout used for this marketing acknowledgement template. |
| SITEID | uniqueidentifier | yes | SITE.ID | The site to which this acknowledgement mailing template belongs. |
| ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| ADDRESSPROCESSINGOPTIONID | uniqueidentifier | yes | ADDRESSPROCESSINGOPTION.ID | The address processing options to be used for this marketing acknowledgement. |
| NAMEFORMATPARAMETERID | uniqueidentifier | yes | NAMEFORMATPARAMETER.ID | The name format options to be used for this marketing acknowledgement. |
| PARTDEFINITIONVALUESID | uniqueidentifier | yes | MKTSOURCECODEPARTDEFINITIONVALUES.ID | FK to MKTSOURCECODEPARTDEFINITIONVALUES |
| BASECURRENCYID | uniqueidentifier | yes | CURRENCY.ID | The base currency associated with this acknowledgment template. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_ADDRESSPROCESSINGOPTIONID | ADDRESSPROCESSINGOPTIONID | |||
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_BASECURRENCYID | BASECURRENCYID | |||
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_DATEADDED | DATEADDED | yes | ||
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_DATECHANGED | DATECHANGED | |||
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_NAMEFORMATPARAMETERID | NAMEFORMATPARAMETERID | |||
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_PARTDEFINITIONVALUESID | PARTDEFINITIONVALUESID | |||
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_SITEID | SITEID | |||
| IX_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_SOURCECODEID | SOURCECODEID | |||
| PK_MKTACKNOWLEDGEMENTMAILINGTEMPLATE | ID | yes | yes | |
| UC_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_NAME | NAME | yes |
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 |