| NAME |
nvarchar(100) |
|
Default = '' |
The name given to this option set. |
| PURPOSE |
nvarchar(500) |
|
Default = '' |
The purpose for this option set. |
| INDUSECONSTITUENTPREFS |
bit |
|
Default = 1 |
Flag to true if the processing should try to use constituent preferences. |
| INDALTADDRESS1ISPRIMARY |
bit |
|
Default = 0 |
Flag to true to use the primary address as the first alternative, regardless of type. |
| INDALTADDRESS2ISPRIMARY |
bit |
|
Default = 0 |
Flag to true to use the primary address as the second alternative, regardless of type. |
| INDUSESEASONALADDRESS |
bit |
|
Default = 0 |
Flag to true if the processing should try to use a seasonal address. |
| INDINCLUDEWITHNOADDRESS |
bit |
|
Default = 1 |
Flag to true is the individual should be included even if no address is found. |
| ORGMAILINGPREFERENCE |
tinyint |
|
Default = 0 |
Defines the action to be taken when mailing to an organization. |
| ORGALTADDRESS1ISPRIMARY |
bit |
|
Default = 0 |
Flag to true to use the primary address as the first alternative, regardless of type. |
| ORGALTADDRESS2ISPRIMARY |
bit |
|
Default = 0 |
Flag to true to use the primary address as the second alternative, regardless of type. |
| ORGINCLUDEWITHNOADDRESS |
bit |
|
Default = 0 |
Flag to true is the organization should be included even if no address is found. |
| ORGSENDTOALLCONTACTS |
bit |
|
Default = 1 |
Flag to true if all contacts should be used, not just the first one found. |
| ORGINCLUDEWITHNOCONTACT |
bit |
|
Default = 1 |
Flag to true is the organization should be included even if no contacts are found. |
| ORGCONTACTALSOINDACTION |
tinyint |
|
Default = 0 |
Defines what to do if an organization's contact is also set to receive the mailing as an individual. Only applicable to certain kinds of mailings. |
| 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. |
| ORGUSECONSTITUENTPREFS |
bit |
|
Default = 1 |
Flag to true if the processing should try to use constituent preferences. |
| ISDEFAULT |
bit |
|
Default = 0 |
Flagged to true if the record is the default option set. |
| GROUPUSECONSTITUENTPREFS |
bit |
|
Default = 1 |
|
| GROUPUSESEASONALADDRESS |
bit |
|
Default = 1 |
|
| GROUPALTADDRESS1ISPRIMARY |
bit |
|
Default = 0 |
|
| GROUPALTADDRESS2ISPRIMARY |
bit |
|
Default = 0 |
|
| GROUPINCLUDEWITHNOADDRESS |
bit |
|
Default = 1 |
|
| ISSYSTEM |
bit |
|
Default = 0 |
|