Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(128)   Default = '' The name of the rule used for processing acknowledgments and receipts.
 ISEMAIL bit   Default = 0 Determines if this general rule is for email.
 ISMAIL bit   Default = 0 Determines if this general rule is for mail.
 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.
 PREFERREDCOMMUNICATIONCODE tinyint   Default = 0 0=Email, 1=Mail
 PREFERREDCOMMUNICATION nvarchar(5) (Computed) CASE [PREFERREDCOMMUNICATIONCODE] WHEN 0 THEN N'Email' WHEN 1 THEN N'Mail' END Provides a translation for the 'PREFERREDCOMMUNICATIONCODE' field.
 REVENUEUPPERLIMIT money   Default = 0 The upper limit of the selection input by the user.
 REVENUELOWERLIMIT money   Default = 0 The lower limit of the selection input by the user.
 LETTERTYPECODE tinyint   Default = 0 0=Email, 1=Mail, 2=Email and Mail
 LETTERTYPE nvarchar(14) (Computed) CASE [LETTERTYPECODE] WHEN 0 THEN N'Email' WHEN 1 THEN N'Mail' WHEN 2 THEN N'Email and Mail' END Provides a translation for the 'LETTERTYPECODE' field.
 SEGMENTOPTIONCODE tinyint   Default = 0 0=All unacknowledged revenue, 1=All unacknowledged revenue in amount range, 2=All unacknowledged revenue from user selection
 SEGMENTOPTION nvarchar(46) (Computed) CASE [SEGMENTOPTIONCODE] WHEN 0 THEN N'All unacknowledged revenue' WHEN 1 THEN N'All unacknowledged revenue in amount range' WHEN 2 THEN N'All unacknowledged revenue from user selection' END Provides a translation for the 'SEGMENTOPTIONCODE' field.
 SEQUENCE int   Default = 0 The order of setup rules for each acknowledgement and receipting setup rules.

Foreign Key Field Type Null Notes Description
 MKTACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier   MKTACKNOWLEDGEMENTMAILINGTEMPLATE.ID The acknowledgement mailing template associated with the setup.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID The ID of the selection chosen by the user.
 MKTACKNOWLEDGEMENTMAILINGTEMPLATERULEEMAILID uniqueidentifier MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE.ID The acknowledgement mailing template email rule associated with the setup
 MKTACKNOWLEDGEMENTMAILINGTEMPLATERULEMAILID uniqueidentifier MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE.ID The acknowledgement mailing template mail rule associated with the setup

Index Name Field(s) Unique Primary Clustered
 IX_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_DATEADDED DATEADDED    
 IX_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_DATECHANGED DATECHANGED      
 IX_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_IDSETREGISTERID IDSETREGISTERID      
 IX_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_MKTACKNOWLEDGEMENTMAILINGTEMPLATEID MKTACKNOWLEDGEMENTMAILINGTEMPLATEID      
 IX_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULEEMAILID MKTACKNOWLEDGEMENTMAILINGTEMPLATERULEEMAILID      
 IX_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULEMAILID MKTACKNOWLEDGEMENTMAILINGTEMPLATERULEMAILID      
 PK_ACKNOWLEDGEMENTANDRECEIPTINGSETUP ID  
 UC_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_NAME NAME    

Trigger Name Description
 TR_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_AUDIT_UPDATE
 TR_ACKNOWLEDGEMENTANDRECEIPTINGSETUP_AUDIT_DELETE

Entity-Relationship diagram of this table