OpportunityClose table/entity reference

Note

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

Activity that is created automatically when an opportunity is closed, containing information such as the description of the closing and actual revenue.

Added by: Sales Solution

Messages

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

Properties

Property	Value
CollectionSchemaName	OpportunityCloses
DisplayCollectionName	Opportunity Close Activities
DisplayName	Opportunity Close
EntitySetName	opportunitycloses
IsBPFEntity	False
LogicalCollectionName	opportunitycloses
LogicalName	opportunityclose
OwnershipType	UserOwned
PrimaryIdAttribute	activityid
PrimaryNameAttribute	subject
SchemaName	OpportunityClose

Writable columns/attributes

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

• ActivityAdditionalParams
• ActivityId
• ActualDurationMinutes
• ActualEnd
• ActualRevenue
• ActualStart
• BCC
• Category
• CC
• Community
• CompetitorId
• Customers
• DeliveryPriorityCode
• Description
• ExchangeItemId
• ExchangeWebLink
• From
• ImportSequenceNumber
• IsBilled
• IsMapiPrivate
• IsWorkflowCreated
• LastOnHoldTime
• LeftVoiceMail
• OpportunityId
• OpportunityStateCode
• OpportunityStatusCode
• OptionalAttendees
• Organizer
• OverriddenCreatedOn
• OwnerId
• OwnerIdType
• Partners
• PriorityCode
• ProcessId
• RegardingObjectId
• RegardingObjectIdName
• RegardingObjectIdYomiName
• RegardingObjectTypeCode
• RequiredAttendees
• Resources
• ScheduledEnd
• ScheduledStart
• ServiceId
• SLAId
• SortDate
• StageId
• StateCode
• StatusCode
• Subcategory
• Subject
• TimeZoneRuleVersionNumber
• To
• TransactionCurrencyId
• TraversedPath
• UTCConversionTimeZoneCode

ActivityAdditionalParams

Property	Value
Description	Additional information provided by the external application as JSON. For internal use only.
DisplayName	Activity 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 opportunity close activity.
DisplayName	Opportunity Close
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	activityid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ActualDurationMinutes

Property	Value
Description	Actual duration of the opportunity close activity in minutes.
DisplayName	Actual Duration
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	actualdurationminutes
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

ActualEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Actual end time of the opportunity close activity.
DisplayName	Closed On
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	actualend
RequiredLevel	None
Type	DateTime

ActualRevenue

Property	Value
Description	Actual revenue generated for the opportunity.
DisplayName	Actual Revenue
IsValidForForm	True
IsValidForRead	True
LogicalName	actualrevenue
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	2
RequiredLevel	None
Type	Money

ActualStart

Property	Value
DateTimeBehavior	UserLocal
Description	Actual start time of the opportunity close activity.
DisplayName	Actual Start
Format	DateOnly
IsValidForForm	False
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,lead,systemuser
Type	PartyList

Category

Property	Value
Description	Category of the opportunity close activity.
DisplayName	Category
FormatName	Text
IsLocalizable	False
IsValidForForm	False
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,lead,systemuser
Type	PartyList

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

CompetitorId

Property	Value
Description	Unique identifier of the competitor with which the opportunity close activity is associated.
DisplayName	Competitor
IsValidForForm	True
IsValidForRead	True
LogicalName	competitorid
RequiredLevel	None
Targets	competitor
Type	Lookup

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	Activity that is created automatically when an opportunity is closed, containing information such as the description of the closing and actual revenue.
DisplayName	Description
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	description
MaxLength	2000
RequiredLevel	None
Type	Memo

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

From

Property	Value
Description	Person who the activity is from.
DisplayName	From
IsValidForForm	True
IsValidForRead	True
LogicalName	from
RequiredLevel	None
Targets	account,contact,lead,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	Information about whether the opportunity close activity 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	Information that specifies if the opportunity close activity was created from 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

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

OpportunityId

Property	Value
Description	Unique identifier of the opportunity closed.
DisplayName	Opportunity
IsValidForForm	True
IsValidForRead	True
LogicalName	opportunityid
RequiredLevel	ApplicationRequired
Targets	opportunity
Type	Lookup

OpportunityStateCode

Added by: Sales Patch Version 2 Solution

Property	Value
Description	Status of the opportunity.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	opportunitystatecode
RequiredLevel	None
Type	Picklist

OpportunityStateCode Choices/Options

Value	Label	Description
0	Open
1	Won
2	Lost

OpportunityStatusCode

Added by: Sales Patch Version 2 Solution

Property	Value
Description	Status reason of the opportunity.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	opportunitystatuscode
RequiredLevel	None
Type	Picklist

OpportunityStatusCode Choices/Options

Value	Label	Description
1	In Progress
2	On Hold
3	Won
4	Canceled
5	Out-Sold

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,lead,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

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

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	Priority of the activity.
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

RegardingObjectId

Property	Value
Description	Unique identifier of the object with which the activity is associated.
DisplayName	Regarding
IsValidForForm	True
IsValidForRead	True
LogicalName	regardingobjectid
RequiredLevel	None
Targets	account,adx_invitation,bookableresourcebooking,bookableresourcebookingheader,bulkoperation,campaign,campaignactivity,entitlement,entitlementtemplate,incident,interactionforemail,knowledgearticle,knowledgebaserecord,lead,msdyn_customerasset,msdyn_playbookinstance,mspp_adplacement,mspp_pollplacement,mspp_publishingstatetransitionrule,mspp_redirect,mspp_shortcut,mspp_website,opportunity,site
Type	Lookup

RegardingObjectIdName

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

RegardingObjectIdYomiName

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

RegardingObjectTypeCode

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
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,lead,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	equipment,systemuser
Type	PartyList

ScheduledEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Scheduled end time of the opportunity close activity.
DisplayName	Scheduled End
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
LogicalName	scheduledend
RequiredLevel	None
Type	DateTime

ScheduledStart

Property	Value
DateTimeBehavior	UserLocal
Description	Scheduled start time of the opportunity close activity.
DisplayName	Scheduled Start
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
LogicalName	scheduledstart
RequiredLevel	None
Type	DateTime

ServiceId

Property	Value
Description	Unique identifier of the service with which the opportunity close activity is associated.
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 opportunity close activity is open, completed, or canceled. By default, opportunity close activities are completed unless the opportunity is reactivated, which updates them to canceled.
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	Completed	2	Completed
2	Canceled	3	Canceled

StatusCode

Property	Value
Description	Reason for the status of the opportunity close activity.
DisplayName	Status Reason
IsValidForForm	False
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status

StatusCode Choices/Options

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

Subcategory

Property	Value
Description	Subcategory of the opportunity close activity.
DisplayName	Sub-Category
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	subcategory
MaxLength	250
RequiredLevel	None
Type	String

Subject

Property	Value
Description	Subject associated with the opportunity close activity.
DisplayName	Subject
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	subject
MaxLength	200
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,lead,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

Read-only columns/attributes

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

• ActivityTypeCode
• ActualRevenue_Base
• CompetitorIdName
• CompetitorIdYomiName
• CreatedBy
• CreatedByExternalParty
• CreatedByExternalPartyName
• CreatedByExternalPartyYomiName
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• DeliveryLastAttemptedOn
• ExchangeRate
• InstanceTypeCode
• IsRegularActivity
• ModifiedBy
• ModifiedByExternalParty
• ModifiedByExternalPartyName
• ModifiedByExternalPartyYomiName
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• OnHoldTime
• OpportunityIdName
• OpportunityIdType
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningBusinessUnitName
• OwningTeam
• OwningUser
• PostponeActivityProcessingUntil
• ScheduledDurationMinutes
• SenderMailboxId
• SenderMailboxIdName
• SentOn
• SeriesId
• ServiceIdName
• 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

ActualRevenue_Base

Property	Value
Description	Value of the Actual Revenue in base currency.
DisplayName	Actual Revenue (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	actualrevenue_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2
RequiredLevel	None
Type	Money

CompetitorIdName

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

CompetitorIdYomiName

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

CreatedBy

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

CreatedByExternalParty

Added by: Sales Service Solution

Property	Value
Description	Shows the external party who created the record.
DisplayName	Created By (External Party)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdbyexternalparty
RequiredLevel	None
Targets	externalparty
Type	Lookup

CreatedByExternalPartyName

Added by: Sales Service Solution

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

CreatedByExternalPartyYomiName

Added by: Sales Service Solution

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

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 opportunity close activity was created.
DisplayName	Created On
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 opportunityclose.
DisplayName	Created By (Delegate)
IsValidForForm	False
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 the user who last modified the opportunity close activity.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByExternalParty

Added by: Sales Service Solution

Property	Value
Description	Shows the external party who modified the record.
DisplayName	Modified By (External Party)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedbyexternalparty
RequiredLevel	None
Targets	externalparty
Type	Lookup

ModifiedByExternalPartyName

Added by: Sales Service Solution

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

ModifiedByExternalPartyYomiName

Added by: Sales Service Solution

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

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 the opportunity close activity was last modified.
DisplayName	Modified On
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the opportunityclose.
DisplayName	Modified By (Delegate)
IsValidForForm	False
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

OpportunityIdName

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

OpportunityIdType

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

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

ScheduledDurationMinutes

Property	Value
Description	Scheduled duration of the opportunity close activity, specified 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

ServiceIdName

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

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_OpportunityCloses

Added by: Marketing Solution

Same as the CampaignResponse_OpportunityCloses many-to-one relationship for the campaignresponse table/entity.

Property	Value
ReferencingEntity	campaignresponse
ReferencingAttribute	originatingactivityid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	CampaignResponse_OpportunityCloses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade 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_OpportunityCloses
• bulkoperation_OpportunityCloses
• campaign_OpportunityCloses
• campaignactivity_OpportunityCloses
• opportunity_OpportunityCloses
• account_OpportunityCloses
• Opportunity_OpportunityClose
• competitor_opportunity_activities

lead_OpportunityCloses

Added by: Lead Management Solution

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

bulkoperation_OpportunityCloses

Added by: Marketing Solution

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

campaign_OpportunityCloses

Added by: Marketing Solution

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

campaignactivity_OpportunityCloses

Added by: Marketing Solution

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

opportunity_OpportunityCloses

See the opportunity_OpportunityCloses one-to-many relationship for the opportunity table/entity.

account_OpportunityCloses

Added by: System Solution Solution

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

Opportunity_OpportunityClose

See the Opportunity_OpportunityClose one-to-many relationship for the opportunity table/entity.

competitor_opportunity_activities

See the competitor_opportunity_activities one-to-many relationship for the competitor table/entity.

Related information

Dataverse table/entity reference
Web API Reference