DMRecipientColumnType Enumeration

Alterian Email Manager 6.2.3 SDK Help File
Available recipient column types

Namespace:  DMLibrary
Assembly:  DMLibrary (in DMLibrary.dll) Version: 1.0.6340.17420

Syntax
public enum DMRecipientColumnType
Members
Member nameValueDescription
DMRC_RECIPIENT_ID0Internal ID of recipient
DMRC_PREFERTEXT1Prefers text flag: indicates that the recipient has chosen to receive textonly communications
DMRC_RSSONLY2RSS Only flag: indicates that the recipient has chosen to have their RSS feed updated rather than receive email
DMRC_VERIFIED3Verified flag: indicates that the recipient has been successfully tracked at least once
DMRC_IP4IP address from last captured event
DMRC_OS5Operating System code from last captured event (0: Unknown, 1: Win95, 2: Win98, 3: Win2000, 4: WinXP, 5: WinNT, 6: Win16, 7: WinCE, 8: Mac68K, 9: MacPPC, 10: UNIX, 11: WebTV)
DMRC_WB_TOKEN6ID of browser string from last captured event
DMRC_WB_VALUE7Browser string from last captured event
DMRC_PK8ID of field used as primary key for this recipient
DMRC_ENABLED9Enabled flag: when false, indicates that the recipient has unsubscribed, complained or otherwise opted out of further communications
DMRC_CREATED10Date recipient was created
DMRC_MODIFIED11Date recipient was last modified
DMRC_FIELD_TOKEN12ID of value for specified field. This can only be returned for fields of type DMFT_EMAIL, DMFT_STRING and DMFT_UNICODE
DMRC_FIELD_VALUE13Value for specified field
DMRC_EMAIL_HEALTH14Current health of the specified email field
DMRC_EMAIL_DOMAIN_TOKEN15ID of domain for specified email field
DMRC_EMAIL_DOMAIN_VALUE16Domain name for specified email field
Remarks
Compatible SQL datatypes when exported in BCP format:
DMRC_RECIPIENT_IDint not null
DMRC_PREFERTEXTtinyint not null
DMRC_RSSONLYtinyint not null
DMRC_VERIFIEDtinyint not null
DMRC_IPint not null
DMRC_OStinyint not null
DMRC_WB_TOKENsmallint not null
DMRC_WB_VALUEvarchar(100) null
DMRC_PKint not null
DMRC_ENABLEDtinyint not null
DMRC_CREATEDdatetime not null
DMRC_MODIFIEDdatetime not null
DMRC_FIELD_TOKENint null
DMRC_FIELD_VALUEDepends on field type, see below
DMRC_EMAIL_HEALTHsmallint null
DMRC_EMAIL_DOMAIN_TOKENint null
DMRC_EMAIL_DOMAIN_VALUEvarchar(100) null
For field values:
DMFT_BOOLEANbit null
DMFT_DATEdatetime null
DMFT_DECIMALfloat null
DMFT_EMAILvarchar(200) null
DMFT_NUMERICint null
DMFT_STRINGvarchar(450) null
DMFT_TEXTntext null
DMFT_UNICODEnvarchar(450) null
See Also