| Field |
Field Type |
Null |
Notes |
Description |
 SEQUENCE |
int |
|
Default = 0 |
The sequence in which this letter will be processed. |
| NAME |
nvarchar(100) |
|
Default = '' |
|
| CHANNELCODE |
tinyint |
|
Default = 0 |
0=Email/Mail, 1=Email, 2=Mail |
 CHANNEL |
nvarchar(10) (Computed) |
 |
CASE [CHANNELCODE] WHEN 0 THEN N'Email/Mail' WHEN 1 THEN N'Email' WHEN 2 THEN N'Mail' END |
Provides a translation for the 'CHANNELCODE' field. |
| CHANNELPREFERENCECODE |
tinyint |
|
Default = 0 |
0=Email, 1=Mail |
| CHANNELPREFERENCE |
nvarchar(5) (Computed) |
|
CASE [CHANNELPREFERENCECODE] WHEN 0 THEN N'Email' WHEN 1 THEN N'Mail' END |
Provides a translation for the 'CHANNELPREFERENCECODE' field. |
| SENDTOOPTIONCODE |
tinyint |
|
Default = 0 |
0=Send to, 1=Send to constituents in the following selection(s) |
| SENDTOOPTION |
nvarchar(50) (Computed) |
|
CASE [SENDTOOPTIONCODE] WHEN 0 THEN N'Send to' WHEN 1 THEN N'Send to constituents in the following selection(s)' END |
Provides a translation for the 'SENDTOOPTIONCODE' field. |
| CONSTITUENTINCLUDECODE |
tinyint |
|
Default = 0 |
0=All constituents, 1=Donors, 2=LYBUNTs, 3=SYBUNTs |
| CONSTITUENTINCLUDE |
nvarchar(16) (Computed) |
|
CASE [CONSTITUENTINCLUDECODE] WHEN 0 THEN N'All constituents' WHEN 1 THEN N'Donors' WHEN 2 THEN N'LYBUNTs' WHEN 3 THEN N'SYBUNTs' END |
Provides a translation for the 'CONSTITUENTINCLUDECODE' field. |
| CONSIDERREVENUEHISTORY |
bit |
|
Default = 0 |
Indicates whether or not a constituent's revenue history should be considered when including/excluding constituents. |
| REVENUECRITERIACODE |
tinyint |
|
Default = 3 |
0=Average gift amount, 1=Largest gift amount, 2=Latest gift amount, 3=Total gift amount |
| REVENUECRITERIA |
nvarchar(19) (Computed) |
|
CASE [REVENUECRITERIACODE] WHEN 0 THEN N'Average gift amount' WHEN 1 THEN N'Largest gift amount' WHEN 2 THEN N'Latest gift amount' WHEN 3 THEN N'Total gift amount' END |
Provides a translation for the 'REVENUECRITERIACODE' field. |
| LOWREVENUEAMOUNT |
money |
|
Default = 0 |
|
| HIGHREVENUEAMOUNT |
money |
|
Default = 0 |
|
| MARGINTOP |
decimal(20, 4) |
|
Default = 1 |
|
| MARGINBOTTOM |
decimal(20, 4) |
|
Default = 1 |
|
| MARGINLEFT |
decimal(20, 4) |
|
Default = 1 |
|
| MARGINRIGHT |
decimal(20, 4) |
|
Default = 1 |
|
| PAPERSIZECODE |
tinyint |
|
Default = 0 |
0=Letter, 1=Legal, 2=Executive, 3=A4, 4=A5, 5=B5 (JIS) |
| PAPERSIZE |
nvarchar(9) (Computed) |
|
CASE [PAPERSIZECODE] WHEN 0 THEN N'Letter' WHEN 1 THEN N'Legal' WHEN 2 THEN N'Executive' WHEN 3 THEN N'A4' WHEN 4 THEN N'A5' WHEN 5 THEN N'B5 (JIS)' END |
Provides a translation for the 'PAPERSIZECODE' field. |
| PAPERWIDTH |
decimal(20, 4) |
|
Default = 0 |
|
| PAPERHEIGHT |
decimal(20, 4) |
|
Default = 0 |
|
| 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. |
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
 IX_APPEALMAILINGSETUPLETTER_APPEALMAILINGSETUPID |
APPEALMAILINGSETUPID |
|
|
|
| IX_APPEALMAILINGSETUPLETTER_CANNEDSELECTIONIDSETREGISTERID |
CANNEDSELECTIONIDSETREGISTERID |
|
|
|
 IX_APPEALMAILINGSETUPLETTER_DATEADDED |
DATEADDED |
|
|
|
| IX_APPEALMAILINGSETUPLETTER_DATECHANGED |
DATECHANGED |
|
|
|
| IX_APPEALMAILINGSETUPLETTER_EMAILPACKAGEID |
EMAILPACKAGEID |
|
|
|
| IX_APPEALMAILINGSETUPLETTER_EMAILSEGMENTID |
EMAILSEGMENTID |
|
|
|
| IX_APPEALMAILINGSETUPLETTER_MAILPACKAGEID |
MAILPACKAGEID |
|
|
|
| IX_APPEALMAILINGSETUPLETTER_MAILSEGMENTID |
MAILSEGMENTID |
|
|
|
| IX_APPEALMAILINGSETUPLETTER_MKTASKLADDERID |
MKTASKLADDERID |
|
|
|
 PK_APPEALMAILINGSETUPLETTER |
ID |
|
|
|
| UC_APPEALMAILINGSETUPLETTER_NAME |
NAME |
|
|
|
APPEALMAILINGSETUPID
TR_APPEALMAILINGSETUPLETTER_DELETE
APPEALMAILINGSETUPLETTERSELECTION