CampaignResponse table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Response from an existing or a potential new customer for a campaign.

Added by: Marketing Solution

Messages

Message	Web API Operation	SDK class or method
Assign	PATCH /campaignresponses(activityid) Update ownerid property.	AssignRequest
CopyCampaignResponse		CopyCampaignResponseRequest
Create	POST /campaignresponses See Create	CreateRequest or Create
CreateMultiple	CreateMultiple	CreateMultipleRequest
Delete	DELETE /campaignresponses(activityid) See Delete	DeleteRequest or Delete
GrantAccess	GrantAccess	GrantAccessRequest
ModifyAccess	ModifyAccess	ModifyAccessRequest
Retrieve	GET /campaignresponses(activityid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET /campaignresponses See Query Data	RetrieveMultipleRequest or RetrieveMultiple
RetrievePrincipalAccess	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess	RevokeAccess	RevokeAccessRequest
SetState	PATCH /campaignresponses(activityid) Update statecode and statuscode properties.	SetStateRequest
Update	PATCH /campaignresponses(activityid) See Update	UpdateRequest or Update
UpdateMultiple	UpdateMultiple	UpdateMultipleRequest

Properties

Property	Value
CollectionSchemaName	CampaignResponses
DisplayCollectionName	Campaign Responses
DisplayName	Campaign Response
EntitySetName	campaignresponses
IsBPFEntity	False
LogicalCollectionName	campaignresponses
LogicalName	campaignresponse
OwnershipType	UserOwned
PrimaryIdAttribute	activityid
PrimaryNameAttribute	subject
SchemaName	CampaignResponse

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• ActivityAdditionalParams
• ActivityId
• ActualDurationMinutes
• ActualEnd
• ActualStart
• BCC
• Category
• CC
• ChannelTypeCode
• Community
• CompanyName
• Customer
• Customers
• DeliveryPriorityCode
• Description
• EMailAddress
• ExchangeItemId
• ExchangeWebLink
• Fax
• FirstName
• from
• ImportSequenceNumber
• IsBilled
• IsMapiPrivate
• IsWorkflowCreated
• LastName
• LastOnHoldTime
• LeftVoiceMail
• OptionalAttendees
• Organizer
• OriginatingActivityId
• OriginatingActivityIdTypeCode
• OverriddenCreatedOn
• OwnerId
• OwnerIdType
• Partner
• Partners
• PriorityCode
• ProcessId
• PromotionCodeName
• ReceivedOn
• RegardingObjectId
• RegardingObjectTypeCode
• RequiredAttendees
• Resources
• ResponseCode
• ScheduledEnd
• ScheduledStart
• ServiceId
• SLAId
• SortDate
• StageId
• StateCode
• StatusCode
• Subcategory
• Subject
• Telephone
• TimeZoneRuleVersionNumber
• To
• TransactionCurrencyId
• TraversedPath
• UTCConversionTimeZoneCode
• YomiCompanyName
• YomiFirstName
• YomiLastName

ActivityAdditionalParams

Property	Value
Description	For internal use only.
DisplayName	Additional Parameters
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	activityadditionalparams
MaxLength	8192
RequiredLevel	None
Type	Memo

ActivityId

Property	Value
Description	Unique identifier of the campaign response.
DisplayName	Campaign Response
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	activityid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ActualDurationMinutes

Property	Value
Description	Type the number of minutes spent on this activity. The duration is used in reporting.
DisplayName	Actual Duration
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	actualdurationminutes
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

ActualEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the date when the campaign response was actually completed.
DisplayName	Actual End
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	actualend
RequiredLevel	None
Type	DateTime

ActualStart

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the actual start date and time for the campaign response.
DisplayName	Actual Start
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	actualstart
RequiredLevel	None
Type	DateTime

BCC

Property	Value
Description	Blind Carbon-copy (bcc) recipients of the activity.
DisplayName	BCC
IsValidForForm	True
IsValidForRead	True
LogicalName	bcc
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

Category

Property	Value
Description	Type a category to identify the campaign response type, such as new business development or customer retention, to tie the campaign response to a business group or function.
DisplayName	Category
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	category
MaxLength	250
RequiredLevel	None
Type	String

CC

Property	Value
Description	Carbon-copy (cc) recipients of the activity.
DisplayName	CC
IsValidForForm	True
IsValidForRead	True
LogicalName	cc
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

ChannelTypeCode

Property	Value
Description	Select how the response was received, such as phone, letter, fax, or email.
DisplayName	Channel
IsValidForForm	True
IsValidForRead	True
LogicalName	channeltypecode
RequiredLevel	None
Type	Picklist

ChannelTypeCode Choices/Options

Value	Label	Description
1	Email
2	Phone
3	Fax
4	Letter
5	Appointment
6	Others

Community

Property	Value
Description	Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only.
DisplayName	Social Channel
IsValidForForm	False
IsValidForRead	True
LogicalName	community
RequiredLevel	None
Type	Picklist

Community Choices/Options

Value	Label	Description
0	Other	Other default
1	Facebook	Facebook item.
2	Twitter	Twitter.
3	Line
4	Wechat
5	Cortana
6	Direct Line
7	Microsoft Teams
8	Direct Line Speech
9	Email
10	GroupMe
11	Kik
12	Telegram
13	Skype
14	Slack
15	WhatsApp
16	Apple Messages For Business
17	Google's Business Messages

CompanyName

Property	Value
Description	Type the name of the company if the campaign response was received from a new prospect or customer.
DisplayName	Company Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	companyname
MaxLength	100
RequiredLevel	None
Type	String

Customer

Property	Value
Description	Enter the account, contact, or lead that submitted the campaign response, if it was received from an existing prospect or customer.
DisplayName	Customer
IsValidForForm	True
IsValidForRead	True
LogicalName	customer
RequiredLevel	None
Targets	account,contact,lead
Type	PartyList

Customers

Property	Value
Description	Customer with which the activity is associated.
DisplayName	Customers
IsValidForForm	True
IsValidForRead	True
LogicalName	customers
RequiredLevel	None
Targets	account,contact
Type	PartyList

DeliveryPriorityCode

Property	Value
Description	Priority of delivery of the activity to the email server.
DisplayName	Delivery Priority
IsValidForForm	True
IsValidForRead	True
IsValidForUpdate	False
LogicalName	deliveryprioritycode
RequiredLevel	None
Type	Picklist

DeliveryPriorityCode Choices/Options

Value	Label	Description
0	Low
1	Normal
2	High

Description

Property	Value
Description	Type additional information to describe the campaign response, such as key discussion points or objectives.
DisplayName	Description
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	description
MaxLength	2000
RequiredLevel	None
Type	Memo

EMailAddress

Property	Value
Description	Type the responder's email address.
DisplayName	Email
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	emailaddress
MaxLength	100
RequiredLevel	None
Type	String

ExchangeItemId

Property	Value
Description	The message id of activity which is returned from Exchange Server.
DisplayName	Exchange Item ID
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeitemid
MaxLength	200
RequiredLevel	None
Type	String

ExchangeWebLink

Property	Value
Description	Shows the web link of Activity of type email.
DisplayName	Exchange WebLink
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeweblink
MaxLength	1250
RequiredLevel	None
Type	String

Fax

Property	Value
Description	Type the responder's fax number.
DisplayName	Fax
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	fax
MaxLength	50
RequiredLevel	None
Type	String

FirstName

Property	Value
Description	Type the responder's first name if the campaign response was received from a new prospect or customer.
DisplayName	First Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	firstname
MaxLength	50
RequiredLevel	None
Type	String

from

Property	Value
Description	For system use only.
DisplayName	From
IsValidForForm	True
IsValidForRead	True
LogicalName	from
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
Format	None
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importsequencenumber
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

IsBilled

Property	Value
Description	Specifies whether the campaign response was billed as part of resolving a case.
DisplayName	Is Billed
IsValidForForm	False
IsValidForRead	True
LogicalName	isbilled
RequiredLevel	None
Type	Boolean

IsBilled Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

IsMapiPrivate

Property	Value
Description	For internal use only.
DisplayName	Is Private
IsValidForForm	False
IsValidForRead	True
LogicalName	ismapiprivate
RequiredLevel	None
Type	Boolean

IsMapiPrivate Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

IsWorkflowCreated

Property	Value
Description	Specifies whether the campaign response is created by a workflow rule.
DisplayName	Is Workflow Created
IsValidForForm	False
IsValidForRead	True
LogicalName	isworkflowcreated
RequiredLevel	None
Type	Boolean

IsWorkflowCreated Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

LastName

Property	Value
Description	Type the responder's last name if the campaign response was received from a new prospect or customer.
DisplayName	Last Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	lastname
MaxLength	50
RequiredLevel	None
Type	String

LastOnHoldTime

Property	Value
DateTimeBehavior	UserLocal
Description	Contains the date and time stamp of the last on hold time.
DisplayName	Last On Hold Time
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	lastonholdtime
RequiredLevel	None
Type	DateTime

LeftVoiceMail

Property	Value
Description	Left the voice mail
DisplayName	Left Voice Mail
IsValidForForm	True
IsValidForRead	True
LogicalName	leftvoicemail
RequiredLevel	None
Type	Boolean

LeftVoiceMail Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

OptionalAttendees

Property	Value
Description	List of optional attendees for the activity.
DisplayName	Optional Attendees
IsValidForForm	True
IsValidForRead	True
LogicalName	optionalattendees
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

Organizer

Property	Value
Description	Person who organized the activity.
DisplayName	Organizer
IsValidForForm	True
IsValidForRead	True
LogicalName	organizer
RequiredLevel	None
Targets	systemuser
Type	PartyList

OriginatingActivityId

Property	Value
Description	Choose the phone call, email, fax, letter, or appointment activity that led the prospect or customer to respond to the campaign.
DisplayName	Originating Activity
IsValidForForm	True
IsValidForRead	True
LogicalName	originatingactivityid
RequiredLevel	None
Targets	appointment,email,fax,letter,phonecall
Type	Lookup

OriginatingActivityIdTypeCode

Added by: Active Solution Solution

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	originatingactivityidtypecode
RequiredLevel	None
Type	EntityName

OverriddenCreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time that the record was migrated.
DisplayName	Record Created On
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime

OwnerId

Property	Value
Description	Unique identifier of the user or team who owns the activity.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	ownerid
RequiredLevel	SystemRequired
Targets	systemuser,team
Type	Owner

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridtype
RequiredLevel	SystemRequired
Type	EntityName

Partner

Property	Value
Description	Enter the vendor account or contact to capture any third-party used to obtain the campaign response.
DisplayName	Outsource Vendor
IsValidForForm	True
IsValidForRead	True
LogicalName	partner
RequiredLevel	None
Targets	account,contact
Type	PartyList

Partners

Property	Value
Description	Outsource vendor with which activity is associated.
DisplayName	Outsource Vendors
IsValidForForm	True
IsValidForRead	True
LogicalName	partners
RequiredLevel	None
Targets	account,contact
Type	PartyList

PriorityCode

Property	Value
Description	Select the priority so that preferred customers or critical issues are handled quickly.
DisplayName	Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	prioritycode
RequiredLevel	None
Type	Picklist

PriorityCode Choices/Options

Value	Label	Description
0	Low
1	Normal
2	High

ProcessId

Property	Value
Description	Unique identifier of the Process.
DisplayName	Process
IsValidForForm	False
IsValidForRead	True
LogicalName	processid
RequiredLevel	None
Type	Uniqueidentifier

PromotionCodeName

Property	Value
Description	Type a promotional code to track sales related to the campaign response or to allow the responder to redeem a discount offer.
DisplayName	Promotion Code
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	promotioncodename
MaxLength	250
RequiredLevel	None
Type	String

ReceivedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the date when the campaign response was received.
DisplayName	Received On
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	receivedon
RequiredLevel	None
Type	DateTime

RegardingObjectId

Property	Value
Description	Choose the parent campaign so that the campaign's response rate is tracked correctly.
DisplayName	Parent Campaign
IsValidForForm	True
IsValidForRead	True
IsValidForUpdate	False
LogicalName	regardingobjectid
RequiredLevel	ApplicationRequired
Targets	bulkoperation,campaign
Type	Lookup

RegardingObjectTypeCode

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	regardingobjecttypecode
RequiredLevel	None
Type	EntityName

RequiredAttendees

Property	Value
Description	List of required attendees for the activity.
DisplayName	Required Attendees
IsValidForForm	True
IsValidForRead	True
LogicalName	requiredattendees
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

Resources

Property	Value
Description	Users or facility/equipment that are required for the activity.
DisplayName	Resources
IsValidForForm	True
IsValidForRead	True
LogicalName	resources
RequiredLevel	None
Targets	systemuser
Type	PartyList

ResponseCode

Property	Value
Description	Select the type of response from the prospect or customer to indicate their interest in the campaign.
DisplayName	Response Code
IsValidForForm	True
IsValidForRead	True
LogicalName	responsecode
RequiredLevel	None
Type	Picklist

ResponseCode Choices/Options

Value	Label	Description
1	Interested
2	Not Interested
3	Do Not Send Marketing Materials
4	Error

ScheduledEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the expected due date and time for the activity to be completed to provide details about the timing of the campaign response.
DisplayName	Close By
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledend
RequiredLevel	None
Type	DateTime

ScheduledStart

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the expected start date and time for the activity to provide details about the timing of the campaign response.
DisplayName	Scheduled Start
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledstart
RequiredLevel	None
Type	DateTime

ServiceId

Added by: Marketing Service Solution

Property	Value
Description	Unique identifier for the associated service.
DisplayName	Service
IsValidForForm	False
IsValidForRead	True
LogicalName	serviceid
RequiredLevel	None
Targets	service
Type	Lookup

SLAId

Property	Value
Description	Choose the service level agreement (SLA) that you want to apply to the case record.
DisplayName	SLA
IsValidForForm	True
IsValidForRead	True
LogicalName	slaid
RequiredLevel	None
Targets	sla
Type	Lookup

SortDate

Property	Value
DateTimeBehavior	UserLocal
Description	Shows the date and time by which the activities are sorted.
DisplayName	Sort Date
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	sortdate
RequiredLevel	None
Type	DateTime

StageId

Property	Value
Description	Unique identifier of the Stage.
DisplayName	(Deprecated) Process Stage
IsValidForForm	False
IsValidForRead	True
LogicalName	stageid
RequiredLevel	None
Type	Uniqueidentifier

StateCode

Property	Value
Description	Shows whether the campaign response is open, closed, or canceled. Closed and canceled campaign responses are read-only and can't be edited.
DisplayName	Status
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State

StateCode Choices/Options

Value	Label	DefaultStatus	InvariantName
0	Open	1	Open
1	Closed	2	Closed
2	Canceled	3	Canceled

StatusCode

Property	Value
Description	Select the campaign response's status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status

StatusCode Choices/Options

Value	Label	State
1	Open	0
2	Closed	1
3	Canceled	2

Subcategory

Property	Value
Description	Type a subcategory to identify the campaign response type and relate the activity to a specific product, sales region, business group, or other function.
DisplayName	Sub-Category
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	subcategory
MaxLength	250
RequiredLevel	None
Type	String

Subject

Property	Value
Description	Type a short description about the objective or primary topic of the campaign response.
DisplayName	Subject
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	subject
MaxLength	200
RequiredLevel	ApplicationRequired
Type	String

Telephone

Property	Value
Description	Type the responder's primary phone number.
DisplayName	Phone
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	telephone
MaxLength	50
RequiredLevel	None
Type	String

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

To

Property	Value
Description	Person who is the receiver of the activity.
DisplayName	To
IsValidForForm	True
IsValidForRead	True
LogicalName	to
RequiredLevel	None
Targets	account,contact,systemuser
Type	PartyList

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
Targets	transactioncurrency
Type	Lookup

TraversedPath

Property	Value
Description	For internal use only.
DisplayName	(Deprecated) Traversed Path
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
MaxLength	1250
RequiredLevel	None
Type	String

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

YomiCompanyName

Property	Value
Description	Type the phonetic spelling of the company name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications.
DisplayName	Yomi Company Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomicompanyname
MaxLength	100
RequiredLevel	None
Type	String

YomiFirstName

Property	Value
Description	Type the phonetic spelling of the campaign responder's first name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications.
DisplayName	Yomi First Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomifirstname
MaxLength	150
RequiredLevel	None
Type	String

YomiLastName

Property	Value
Description	Type the phonetic spelling of the campaign responder's last name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications.
DisplayName	Yomi Last Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomilastname
MaxLength	150
RequiredLevel	None
Type	String

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• ActivityTypeCode
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• DeliveryLastAttemptedOn
• ExchangeRate
• InstanceTypeCode
• IsRegularActivity
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• OnHoldTime
• OriginatingActivityIdYomiName
• OriginatingActivityName
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningBusinessUnitName
• OwningTeam
• OwningUser
• PostponeActivityProcessingUntil
• RegardingObjectIdName
• RegardingObjectIdYomiName
• ScheduledDurationMinutes
• SenderMailboxId
• SenderMailboxIdName
• SentOn
• SeriesId
• SLAInvokedId
• SLAInvokedIdName
• SLAName
• TransactionCurrencyIdName
• VersionNumber

ActivityTypeCode

Property	Value
Description	Type of activity.
DisplayName	Activity Type
IsValidForForm	False
IsValidForRead	True
LogicalName	activitytypecode
RequiredLevel	SystemRequired
Type	EntityName

CreatedBy

Property	Value
Description	Unique identifier of the user who created the activity.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the activity was created.
DisplayName	Date Created
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the activitypointer.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

DeliveryLastAttemptedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the delivery of the activity was last attempted.
DisplayName	Date Delivery Last Attempted
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	deliverylastattemptedon
RequiredLevel	None
Type	DateTime

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
MaxValue	100000000000
MinValue	0.000000000001
Precision	12
RequiredLevel	None
Type	Decimal

InstanceTypeCode

Property	Value
Description	Type of instance of a recurring series.
DisplayName	Recurring Instance Type
IsValidForForm	False
IsValidForRead	True
LogicalName	instancetypecode
RequiredLevel	SystemRequired
Type	Picklist

InstanceTypeCode Choices/Options

Value	Label	Description
0	Not Recurring
1	Recurring Master
2	Recurring Instance
3	Recurring Exception
4	Recurring Future Exception

IsRegularActivity

Property	Value
Description	Information regarding whether the activity is a regular activity type or event type.
DisplayName	Is Regular Activity
IsValidForForm	False
IsValidForRead	True
LogicalName	isregularactivity
RequiredLevel	SystemRequired
Type	Boolean

IsRegularActivity Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

ModifiedBy

Property	Value
Description	Unique identifier of user who last modified the activity.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when activity was last modified.
DisplayName	Last Updated
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the activitypointer.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

OnHoldTime

Property	Value
Description	Shows how long, in minutes, that the record was on hold.
DisplayName	On Hold Time (Minutes)
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	onholdtime
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

OriginatingActivityIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	originatingactivityidyominame
MaxLength	4000
RequiredLevel	None
Type	String

OriginatingActivityName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	originatingactivityname
MaxLength	100
RequiredLevel	None
Type	String

OwnerIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwnerIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridyominame
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwningBusinessUnit

Property	Value
Description	Unique identifier of the business unit that owns the activity.
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	owningbusinessunit
RequiredLevel	None
Targets	businessunit
Type	Lookup

OwningBusinessUnitName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owningbusinessunitname
MaxLength	160
RequiredLevel	None
Type	String

OwningTeam

Property	Value
Description	Unique identifier of the team that owns the activity.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	owningteam
RequiredLevel	None
Targets	team
Type	Lookup

OwningUser

Property	Value
Description	Unique identifier of the user that owns the activity.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Targets	systemuser
Type	Lookup

PostponeActivityProcessingUntil

Property	Value
DateTimeBehavior	UserLocal
Description	For internal use only.
DisplayName	Delay activity processing until
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	postponeactivityprocessinguntil
RequiredLevel	None
Type	DateTime

RegardingObjectIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjectidname
MaxLength	100
RequiredLevel	None
Type	String

RegardingObjectIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjectidyominame
MaxLength	100
RequiredLevel	None
Type	String

ScheduledDurationMinutes

Property	Value
Description	Scheduled duration of the campaign response in minutes.
DisplayName	Scheduled Duration
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	scheduleddurationminutes
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

SenderMailboxId

Property	Value
Description	Unique identifier of the mailbox associated with the sender of the email message.
DisplayName	Sender's Mailbox
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxid
RequiredLevel	None
Targets	mailbox
Type	Lookup

SenderMailboxIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxidname
MaxLength	100
RequiredLevel	None
Type	String

SentOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the activity was sent.
DisplayName	Date Sent
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	senton
RequiredLevel	None
Type	DateTime

SeriesId

Property	Value
Description	Uniqueidentifier specifying the id of recurring series of an instance.
DisplayName	Series Id
IsValidForForm	False
IsValidForRead	True
LogicalName	seriesid
RequiredLevel	None
Type	Uniqueidentifier

SLAInvokedId

Property	Value
Description	Last SLA that was applied to this case. This field is for internal use only.
DisplayName	Last SLA applied
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedid
RequiredLevel	None
Targets	sla
Type	Lookup

SLAInvokedIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedidname
MaxLength	100
RequiredLevel	None
Type	String

SLAName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slaname
MaxLength	100
RequiredLevel	None
Type	String

TransactionCurrencyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyidname
MaxLength	100
RequiredLevel	None
Type	String

VersionNumber

Property	Value
Description	Version number of the activity.
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

One-To-Many Relationships

Listed by SchemaName.

CampaignResponse_Lead

Same as the CampaignResponse_Lead many-to-one relationship for the lead table/entity.

Property	Value
ReferencingEntity	lead
ReferencingAttribute	relatedobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	CampaignResponse_Lead
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: RemoveLink Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

• lead_CampaignResponses
• Campaign_CampaignResponses
• campaignactivity_CampaignResponses
• account_CampaignResponses
• contact_CampaignResponses
• BulkOperation_CampaignResponse
• CampaignResponse_OpportunityCloses
• CampaignResponse_OrderCloses
• CampaignResponse_QuoteCloses

lead_CampaignResponses

Added by: Lead Management Solution

See the lead_CampaignResponses one-to-many relationship for the lead table/entity.

Campaign_CampaignResponses

See the Campaign_CampaignResponses one-to-many relationship for the campaign table/entity.

campaignactivity_CampaignResponses

See the campaignactivity_CampaignResponses one-to-many relationship for the campaignactivity table/entity.

account_CampaignResponses

Added by: System Solution Solution

See the account_CampaignResponses one-to-many relationship for the account table/entity.

contact_CampaignResponses

Added by: System Solution Solution

See the contact_CampaignResponses one-to-many relationship for the contact table/entity.

BulkOperation_CampaignResponse

See the BulkOperation_CampaignResponse one-to-many relationship for the bulkoperation table/entity.

CampaignResponse_OpportunityCloses

Added by: Sales Solution

See the CampaignResponse_OpportunityCloses one-to-many relationship for the opportunityclose table/entity.

CampaignResponse_OrderCloses

Added by: Sales Solution

See the CampaignResponse_OrderCloses one-to-many relationship for the orderclose table/entity.

CampaignResponse_QuoteCloses

Added by: Sales Solution

See the CampaignResponse_QuoteCloses one-to-many relationship for the quoteclose table/entity.

Related information

Dataverse table/entity reference
Web API Reference