SSIS Components for Microsoft Dynamics CRM

Build 24.0.9060

List

This is a table representing the List entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the marketing list.

Cost Double False

Cost of the marketing list.

Cost_Base Double True

Base currency equivalent of the cost of the marketing list.

CreatedBy_Id String True

Unique Identifier of the user who created the marketing list.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedFromCode String False

Information about how the marketing list was created. Restricts the type of objects that can be added to the list.

CreatedOn Datetime True

Date and time when the marketing list was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the list.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of the marketing list.

DoNotSendOnOptOut Boolean False

Information about whether to send marketing material to list members that prohibit sending of marketing material.

ExchangeRate Double True

Exchange rate for the currency associated with the list with respect to the base currency.

IgnoreInactiveListMembers Boolean False

Information about whether to ignore inactive marketing list members during propagation/execution.

ImportSequenceNumber Integer False

Unique identifier of the data import or data migration that created this record.

LastUsedOn Datetime True

Date and time when the list was last used in a campaign, to create activities, or to create opportunities.

ListId String False

Unique identifier of the marketing list.

ListName String False

User-defined name of the marketing list.

LockStatus Boolean False

Indicates whether the marketing list is locked.

MemberCount Integer True

Total number of members in the marketing list.

MemberType Integer False

Type of the members that can be stored in the marketing list.

ModifiedBy_Id String True

Unique identifier of the user who last modified the marketing list.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the marketing list was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the list.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

Unique identifier of the user or team who owns the marketing list.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the marketing list.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the marketing list.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the marketing list.

OwningUser_LogicalName String True

OwningUser_Name String True

Purpose String False

Reason why the marketing list was created.

Query String False

Query used for retrieving members of marketing list.

Source String False

Source of the marketing list.

StateCode String True

Status of the marketing list.

StatusCode String False

Reason for the status of the marketing list.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the list.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

Type Boolean False

Type of marketing list (Static or Dynamic).

UTCConversionTimeZoneCode Integer False

Time zone code that was in use when the record was created.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060