This table holds letters associated with each appeal mailing.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
SEQUENCE
|
int
|
false
|
|
The sequence in which this letter will be processed.
|
|
NAME
|
nvarchar(100)
|
false
|
|
|
|
CHANNELCODE
|
tinyint
|
false
|
|
0=Email/Mail, 1=Email, 2=Mail
|
|
CHANNEL
|
nvarchar(10) (Computed)
|
true
|
|
Provides a translation for the 'CHANNELCODE' field.
|
|
CHANNELPREFERENCECODE
|
tinyint
|
false
|
|
0=Email, 1=Mail
|
|
CHANNELPREFERENCE
|
nvarchar(5) (Computed)
|
true
|
|
Provides a translation for the 'CHANNELPREFERENCECODE' field.
|
|
SENDTOOPTIONCODE
|
tinyint
|
false
|
|
0=Send to, 1=Send to constituents in the following selection(s)
|
|
SENDTOOPTION
|
nvarchar(50) (Computed)
|
true
|
|
Provides a translation for the 'SENDTOOPTIONCODE' field.
|
|
CONSTITUENTINCLUDECODE
|
tinyint
|
false
|
|
0=All constituents, 1=Donors, 2=LYBUNTs, 3=SYBUNTs
|
|
CONSTITUENTINCLUDE
|
nvarchar(16) (Computed)
|
true
|
|
Provides a translation for the 'CONSTITUENTINCLUDECODE' field.
|
|
CONSIDERREVENUEHISTORY
|
bit
|
false
|
|
Indicates whether or not a constituent's revenue history should be considered when including/excluding constituents.
|
|
REVENUECRITERIACODE
|
tinyint
|
false
|
|
0=Average gift amount, 1=Largest gift amount, 2=Latest gift amount, 3=Total gift amount
|
|
REVENUECRITERIA
|
nvarchar(19) (Computed)
|
true
|
|
Provides a translation for the 'REVENUECRITERIACODE' field.
|
|
LOWREVENUEAMOUNT
|
money
|
false
|
|
|
|
HIGHREVENUEAMOUNT
|
money
|
false
|
|
|
|
MARGINTOP
|
decimal(20, 4)
|
false
|
|
|
|
MARGINBOTTOM
|
decimal(20, 4)
|
false
|
|
|
|
MARGINLEFT
|
decimal(20, 4)
|
false
|
|
|
|
MARGINRIGHT
|
decimal(20, 4)
|
false
|
|
|
|
PAPERSIZECODE
|
tinyint
|
false
|
|
0=Letter, 1=Legal, 2=Executive, 3=A4, 4=A5, 5=B5 (JIS)
|
|
PAPERSIZE
|
nvarchar(9) (Computed)
|
true
|
|
Provides a translation for the 'PAPERSIZECODE' field.
|
|
PAPERWIDTH
|
decimal(20, 4)
|
false
|
|
|
|
PAPERHEIGHT
|
decimal(20, 4)
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_APPEALMAILINGSETUPLETTER_APPEALMAILINGSETUPID
|
|
False
|
False
|
False
|
|
IX_APPEALMAILINGSETUPLETTER_CANNEDSELECTIONIDSETREGISTERID
|
CANNEDSELECTIONIDSETREGISTERID
|
False
|
False
|
False
|
|
IX_APPEALMAILINGSETUPLETTER_DATEADDED
|
|
False
|
False
|
True
|
|
IX_APPEALMAILINGSETUPLETTER_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_APPEALMAILINGSETUPLETTER_EMAILPACKAGEID
|
|
False
|
False
|
False
|
|
IX_APPEALMAILINGSETUPLETTER_EMAILSEGMENTID
|
|
False
|
False
|
False
|
|
IX_APPEALMAILINGSETUPLETTER_MAILPACKAGEID
|
|
False
|
False
|
False
|
|
IX_APPEALMAILINGSETUPLETTER_MAILSEGMENTID
|
|
False
|
False
|
False
|
|
IX_APPEALMAILINGSETUPLETTER_MKTASKLADDERID
|
|
False
|
False
|
False
|
|
PK_APPEALMAILINGSETUPLETTER
|
|
True
|
True
|
False
|
|
UC_APPEALMAILINGSETUPLETTER_NAME
|
|
True
|
False
|
False
|
