편집

다음을 통해 공유


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

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

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

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.

Dataverse table/entity reference
Web API Reference