Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Group of existing or potential customers created for a marketing campaign or other sales purposes.
Messages
The following table lists the messages for the Marketing List (List) table. Messages represent operations that can be performed on the table. They may also be events.
| Name Is Event? |
Web API Operation | SDK for .NET |
|---|---|---|
AddListMembersListEvent: True |
AddListMembersList action | AddListMembersListRequest |
AddMemberListEvent: True |
AddMemberList action | AddMemberListRequest |
AddMembersBatchListEvent: True |
AddMembersBatchList action | Learn to use messages with the SDK for .NET |
AssignEvent: True |
PATCH /lists(listid)Update the ownerid property. |
AssignRequest |
AssociateEvent: True |
Associate records | Associate records |
CopyDynamicListToStaticEvent: True |
CopyDynamicListToStatic action | CopyDynamicListToStaticRequest |
CopyMembersListEvent: False |
CopyMembersList action | CopyMembersListRequest |
CreateEvent: True |
POST /listsSee Create |
Create records |
CreateActivitiesListEvent: False |
CreateActivitiesList action | CreateActivitiesListRequest |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /lists(listid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
GrantAccessEvent: True |
GrantAccess | GrantAccessRequest |
ModifyAccessEvent: True |
ModifyAccess | ModifyAccessRequest |
QualifyMemberListEvent: False |
QualifyMemberList action | QualifyMemberListRequest |
RemoveListMembersListEvent: True |
RemoveListMembersList action | Learn to use messages with the SDK for .NET |
RemoveMemberListEvent: True |
RemoveMemberList action | RemoveMemberListRequest |
RetrieveEvent: True |
GET /lists(listid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /listsSee Query data |
Query data |
RetrievePrincipalAccessEvent: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: True |
RevokeAccess | RevokeAccessRequest |
SetStateEvent: True |
PATCH /lists(listid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /lists(listid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /lists(listid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
Properties
The following table lists selected properties for the Marketing List (List) table.
| Property | Value |
|---|---|
| DisplayName | Marketing List |
| DisplayCollectionName | Marketing Lists |
| SchemaName | List |
| CollectionSchemaName | Lists |
| EntitySetName | lists |
| LogicalName | list |
| LogicalCollectionName | lists |
| PrimaryIdAttribute | listid |
| PrimaryNameAttribute | listname |
| TableType | Standard |
| OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Cost
- CreatedFromCode
- Description
- DoNotSendOnOptOut
- IgnoreInactiveListMembers
- ImportSequenceNumber
- LastUsedOn
- ListId
- ListName
- LockStatus
- MemberCount
- MemberType
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- processedMemberCount
- processFetchXML
- ProcessId
- Purpose
- Query
- Source
- StageId
- StateCode
- StatusCode
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- TraversedPath
- Type
- UTCConversionTimeZoneCode
Cost
| Property | Value |
|---|---|
| Description | Type the cost of obtaining the marketing list. |
| DisplayName | Cost |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | cost |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 1000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
CreatedFromCode
| Property | Value |
|---|---|
| Description | Select the type of members that this marketing list will contain: accounts, contacts, or leads. Each list can have only one member type and this value can't be changed after the marketing list is created. |
| DisplayName | Marketing List Member Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdfromcode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | list_createdfromcode |
CreatedFromCode Choices/Options
| Value | Label |
|---|---|
| 1 | Account |
| 2 | Contact |
| 4 | Lead |
Description
| Property | Value |
|---|---|
| Description | Type additional information to describe the marketing list, such as the intended use or date of the last update. |
| DisplayName | Description |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
DoNotSendOnOptOut
| Property | Value |
|---|---|
| Description | Select whether to override the opt-out settings on leads, contacts, and accounts for the members of the target marketing lists of the campaign activity. If No is selected, those who have chosen to opt out won't be excluded from the list. This means they will receive marketing materials. |
| DisplayName | Exclude Members Who Opt Out |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotsendonoptout |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | list_donotsendonoptout |
| DefaultValue | True |
| True Label | Yes |
| False Label | No |
IgnoreInactiveListMembers
| Property | Value |
|---|---|
| Description | Select whether inactive accounts, contacts, or leads should be excluded from the campaign activity distribution when the marketing list is included in a campaign. |
| DisplayName | Ignore Inactive List Members |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ignoreinactivelistmembers |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | list_ignoreinactivelistmembers |
| DefaultValue | True |
| True Label | Yes |
| False Label | No |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importsequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
LastUsedOn
| Property | Value |
|---|---|
| Description | Shows the date and time when the marketing list was last used in a campaign or in the creation of activities or opportunities. |
| DisplayName | Last Used On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastusedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ListId
| Property | Value |
|---|---|
| Description | Unique identifier of the marketing list. |
| DisplayName | Marketing List |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | listid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ListName
| Property | Value |
|---|---|
| Description | Type a name for the marketing list so that it is identified correctly in lists. |
| DisplayName | Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | listname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 128 |
LockStatus
| Property | Value |
|---|---|
| Description | Select whether the marketing list is locked. If Yes is selected, no additional members can be added to the marketing list. |
| DisplayName | Locked |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lockstatus |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | list_lockstatus |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
MemberCount
| Property | Value |
|---|---|
| Description | Shows the sum of all members in the marketing list. |
| DisplayName | Members Count |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | membercount |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
MemberType
| Property | Value |
|---|---|
| Description | Type of the members that can be stored in the marketing list. Please do not remove from form! |
| DisplayName | Member Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | membertype |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Type | Owner |
| Targets | systemuser, team |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
processedMemberCount
| Property | Value |
|---|---|
| Description | |
| DisplayName | processedMemberCount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | processedmembercount |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
processFetchXML
| Property | Value |
|---|---|
| Description | |
| DisplayName | processFetchXML |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processfetchxml |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 10000 |
ProcessId
| Property | Value |
|---|---|
| Description | Contains the id of the process associated with the entity. |
| DisplayName | Process Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Purpose
| Property | Value |
|---|---|
| Description | Type the intended use of the marketing list to identify its key segments, target offers, or business group. |
| DisplayName | Purpose |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | purpose |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 512 |
Query
| Property | Value |
|---|---|
| Description | Query used for retrieving members of marketing list. |
| DisplayName | Query |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | query |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
Source
| Property | Value |
|---|---|
| Description | Type the source of the marketing list, such as a third-party supplier or internal database. |
| DisplayName | Source |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | source |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 128 |
StageId
| Property | Value |
|---|---|
| Description | Contains the id of the stage where the entity is located. |
| DisplayName | (Deprecated) Stage Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
StateCode
| Property | Value |
|---|---|
| Description | Shows whether the marketing list is active or inactive. Inactive marketing lists are read-only and can't be edited unless they are reactivated. |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
| DefaultFormValue | 0 |
| GlobalChoiceName | list_statecode |
StateCode Choices/Options
| Value | Details |
|---|---|
| 0 | Label: Active DefaultStatus: 0 InvariantName: Active |
| 1 | Label: Inactive DefaultStatus: 1 InvariantName: Inactive |
StatusCode
| Property | Value |
|---|---|
| Description | Select the marketing list's status. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
| DefaultFormValue | -1 |
| GlobalChoiceName | list_statuscode |
StatusCode Choices/Options
| Value | Details |
|---|---|
| 0 | Label: Active State:0 TransitionData: None |
| 1 | Label: Inactive State:1 TransitionData: None |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | transactioncurrency |
TraversedPath
| Property | Value |
|---|---|
| Description | A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur. |
| DisplayName | (Deprecated) Traversed Path |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
Type
| Property | Value |
|---|---|
| Description | Select whether you want the marketing list to be static or dynamic. The members in a static marketing list are unchanging. A dynamic marketing list is based on a dynamic query that retrieves the updated list of members |
| DisplayName | Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | type |
| RequiredLevel | SystemRequired |
| Type | Boolean |
| GlobalChoiceName | list_type |
| DefaultValue | False |
| True Label | Dynamic |
| False Label | Static |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- Cost_Base
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ExchangeRate
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- VersionNumber
Cost_Base
| Property | Value |
|---|---|
| Description | Value of the Cost in base currency. |
| DisplayName | Cost (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | cost_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CreatedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ExchangeRate
| Property | Value |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| RequiredLevel | None |
| Type | Decimal |
| ImeMode | Disabled |
| MaxValue | 100000000000 |
| MinValue | 1E-12 |
| Precision | 12 |
| SourceTypeMask | 0 |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record on behalf of another user. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Type | Lookup |
| Targets | businessunit |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Type | Lookup |
| Targets | team |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| RequiredLevel | None |
| Type | BigInt |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- business_unit_list
- lk_list_createdby
- lk_list_createdonbehalfby
- lk_list_modifiedby
- lk_list_modifiedonbehalfby
- owner_lists
- processstage_lists
- team_list
- transactioncurrency_list
- user_list
business_unit_list
One-To-Many Relationship: businessunit business_unit_list
| Property | Value |
|---|---|
| ReferencedEntity | businessunit |
| ReferencedAttribute | businessunitid |
| ReferencingAttribute | owningbusinessunit |
| ReferencingEntityNavigationPropertyName | owningbusinessunit |
| IsHierarchical | |
| CascadeConfiguration | Archive: RestrictAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_list_createdby
One-To-Many Relationship: systemuser lk_list_createdby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdby |
| ReferencingEntityNavigationPropertyName | createdby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_list_createdonbehalfby
One-To-Many Relationship: systemuser lk_list_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_list_modifiedby
One-To-Many Relationship: systemuser lk_list_modifiedby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedby |
| ReferencingEntityNavigationPropertyName | modifiedby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_list_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_list_modifiedonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedonbehalfby |
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
owner_lists
One-To-Many Relationship: owner owner_lists
| Property | Value |
|---|---|
| ReferencedEntity | owner |
| ReferencedAttribute | ownerid |
| ReferencingAttribute | ownerid |
| ReferencingEntityNavigationPropertyName | ownerid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
processstage_lists
One-To-Many Relationship: processstage processstage_lists
| Property | Value |
|---|---|
| ReferencedEntity | processstage |
| ReferencedAttribute | processstageid |
| ReferencingAttribute | stageid |
| ReferencingEntityNavigationPropertyName | stageid_processstage |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
team_list
One-To-Many Relationship: team team_list
| Property | Value |
|---|---|
| ReferencedEntity | team |
| ReferencedAttribute | teamid |
| ReferencingAttribute | owningteam |
| ReferencingEntityNavigationPropertyName | owningteam |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
transactioncurrency_list
One-To-Many Relationship: transactioncurrency transactioncurrency_list
| Property | Value |
|---|---|
| ReferencedEntity | transactioncurrency |
| ReferencedAttribute | transactioncurrencyid |
| ReferencingAttribute | transactioncurrencyid |
| ReferencingEntityNavigationPropertyName | transactioncurrencyid |
| IsHierarchical | |
| CascadeConfiguration | Archive: RestrictAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
user_list
One-To-Many Relationship: systemuser user_list
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | owninguser |
| ReferencingEntityNavigationPropertyName | owninguser |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- List_Annotation
- List_AsyncOperations
- List_BulkDeleteFailures
- List_BulkOperations
- list_connections1
- list_connections2
- List_DuplicateBaseRecord
- List_DuplicateMatchingRecord
- list_listoperation_ListId
- list_MailboxTrackingFolders
- list_principalobjectattributeaccess
- List_ProcessSessions
- List_SyncErrors
List_Annotation
Many-To-One Relationship: annotation List_Annotation
| Property | Value |
|---|---|
| ReferencingEntity | annotation |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | List_Annotation |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
List_AsyncOperations
Many-To-One Relationship: asyncoperation List_AsyncOperations
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | List_AsyncOperations |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
List_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure List_BulkDeleteFailures
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | List_BulkDeleteFailures |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
List_BulkOperations
Many-To-One Relationship: bulkoperation List_BulkOperations
| Property | Value |
|---|---|
| ReferencingEntity | bulkoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | List_BulkOperations |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: BulkOperation.RetrieveMiniCampaignsForListViewId: 83dc2389-0a4c-4249-a5d3-ba1ab401ff1c |
list_connections1
Many-To-One Relationship: connection list_connections1
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record1id |
| ReferencedEntityNavigationPropertyName | list_connections1 |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
list_connections2
Many-To-One Relationship: connection list_connections2
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record2id |
| ReferencedEntityNavigationPropertyName | list_connections2 |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
List_DuplicateBaseRecord
Many-To-One Relationship: duplicaterecord List_DuplicateBaseRecord
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | baserecordid |
| ReferencedEntityNavigationPropertyName | List_DuplicateBaseRecord |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
List_DuplicateMatchingRecord
Many-To-One Relationship: duplicaterecord List_DuplicateMatchingRecord
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | duplicaterecordid |
| ReferencedEntityNavigationPropertyName | List_DuplicateMatchingRecord |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
list_listoperation_ListId
Many-To-One Relationship: listoperation list_listoperation_ListId
| Property | Value |
|---|---|
| ReferencingEntity | listoperation |
| ReferencingAttribute | listid |
| ReferencedEntityNavigationPropertyName | list_listoperation_ListId |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
list_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder list_MailboxTrackingFolders
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | list_MailboxTrackingFolders |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
list_principalobjectattributeaccess
Many-To-One Relationship: principalobjectattributeaccess list_principalobjectattributeaccess
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | list_principalobjectattributeaccess |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
List_ProcessSessions
Many-To-One Relationship: processsession List_ProcessSessions
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | List_ProcessSessions |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
List_SyncErrors
Many-To-One Relationship: syncerror List_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | List_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-to-Many relationships
These relationships are many-to-many. Listed by SchemaName.
- campaignactivitylist_association
- campaignlist_association
- listaccount_association
- listcontact_association
- listlead_association
campaignactivitylist_association
See campaignactivity campaignactivitylist_association Many-To-Many Relationship
| Property | Value |
|---|---|
| IntersectEntityName | campaignactivityitem |
| IsCustomizable | False |
| SchemaName | campaignactivitylist_association |
| IntersectAttribute | itemid |
| NavigationPropertyName | campaignactivitylist_association |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
campaignlist_association
See campaign campaignlist_association Many-To-Many Relationship
| Property | Value |
|---|---|
| IntersectEntityName | campaignitem |
| IsCustomizable | False |
| SchemaName | campaignlist_association |
| IntersectAttribute | entityid |
| NavigationPropertyName | campaignlist_association |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
listaccount_association
See account listaccount_association Many-To-Many Relationship
| Property | Value |
|---|---|
| IntersectEntityName | listmember |
| IsCustomizable | False |
| SchemaName | listaccount_association |
| IntersectAttribute | listid |
| NavigationPropertyName | listaccount_association |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: MarketingLabel: MenuId: null Order: 10 QueryApi: List.RetrieveListsForMemberViewId: bdd93547-53f6-4609-b591-9f48ce86295f |
listcontact_association
See contact listcontact_association Many-To-Many Relationship
| Property | Value |
|---|---|
| IntersectEntityName | listmember |
| IsCustomizable | False |
| SchemaName | listcontact_association |
| IntersectAttribute | listid |
| NavigationPropertyName | listcontact_association |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: MarketingLabel: MenuId: null Order: 10 QueryApi: List.RetrieveListsForMemberViewId: bdd93547-53f6-4609-b591-9f48ce86295f |
listlead_association
See lead listlead_association Many-To-Many Relationship
| Property | Value |
|---|---|
| IntersectEntityName | listmember |
| IsCustomizable | False |
| SchemaName | listlead_association |
| IntersectAttribute | listid |
| NavigationPropertyName | listlead_association |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: MarketingLabel: MenuId: null Order: 10 QueryApi: List.RetrieveListsForMemberViewId: bdd93547-53f6-4609-b591-9f48ce86295f |
See also
Dataverse table/entity reference
Dataverse Web API Reference