Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Activity that is created automatically when an opportunity is closed, containing information such as the description of the closing and actual revenue.
Messages
The following table lists the messages for the Opportunity Close (OpportunityClose) table. Messages represent operations that can be performed on the table. They may also be events.
| Name Is Event? |
Web API Operation | SDK for .NET |
|---|---|---|
AssignEvent: True |
PATCH /opportunitycloses(activityid)Update the ownerid property. |
AssignRequest |
AssociateEvent: True |
Associate records | Associate records |
CreateEvent: True |
POST /opportunityclosesSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /opportunitycloses(activityid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
GrantAccessEvent: True |
GrantAccess | GrantAccessRequest |
ModifyAccessEvent: True |
ModifyAccess | ModifyAccessRequest |
RetrieveEvent: True |
GET /opportunitycloses(activityid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /opportunityclosesSee Query data |
Query data |
RetrievePrincipalAccessEvent: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: True |
RevokeAccess | RevokeAccessRequest |
SetStateEvent: True |
PATCH /opportunitycloses(activityid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /opportunitycloses(activityid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /opportunitycloses(activityid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
Properties
The following table lists selected properties for the Opportunity Close (OpportunityClose) table.
| Property | Value |
|---|---|
| DisplayName | Opportunity Close |
| DisplayCollectionName | Opportunity Close Activities |
| SchemaName | OpportunityClose |
| CollectionSchemaName | OpportunityCloses |
| EntitySetName | opportunitycloses |
| LogicalName | opportunityclose |
| LogicalCollectionName | opportunitycloses |
| PrimaryIdAttribute | activityid |
| PrimaryNameAttribute | subject |
| TableType | Standard |
| OwnershipType | UserOwned |
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
- 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 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | activityadditionalparams |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 8192 |
ActivityId
| Property | Value |
|---|---|
| Description | Unique identifier of the opportunity close activity. |
| DisplayName | Opportunity Close |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | activityid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ActualDurationMinutes
| Property | Value |
|---|---|
| Description | Actual duration of the opportunity close activity in minutes. |
| DisplayName | Actual Duration |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | actualdurationminutes |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
ActualEnd
| Property | Value |
|---|---|
| Description | Actual end time of the opportunity close activity. |
| DisplayName | Closed On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualend |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ActualRevenue
| Property | Value |
|---|---|
| Description | Actual revenue generated for the opportunity. |
| DisplayName | Actual Revenue |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualrevenue |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
ActualStart
| Property | Value |
|---|---|
| Description | Actual start time of the opportunity close activity. |
| DisplayName | Actual Start |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | actualstart |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
BCC
| Property | Value |
|---|---|
| Description | Blind Carbon-copy (bcc) recipients of the activity. |
| DisplayName | BCC |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | bcc |
| RequiredLevel | None |
| Type | PartyList |
| Targets | account, contact, lead, systemuser |
Category
| Property | Value |
|---|---|
| Description | Category of the opportunity close activity. |
| DisplayName | Category |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | category |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
CC
| Property | Value |
|---|---|
| Description | Carbon-copy (cc) recipients of the activity. |
| DisplayName | CC |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | cc |
| RequiredLevel | None |
| Type | PartyList |
| Targets | account, contact, lead, systemuser |
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 |
| DefaultFormValue | -1 |
| GlobalChoiceName | socialprofile_community |
Community Choices/Options
| Value | Label |
|---|---|
| 0 | Other |
| 1 | |
| 2 | |
| 3 | Line |
| 4 | |
| 5 | Cortana |
| 6 | Direct Line |
| 7 | Microsoft Teams |
| 8 | Direct Line Speech |
| 9 | |
| 10 | GroupMe |
| 11 | Kik |
| 12 | Telegram |
| 13 | Skype |
| 14 | Slack |
| 15 | |
| 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 |
| Type | Lookup |
| Targets | competitor |
Customers
| Property | Value |
|---|---|
| Description | Customer with which the activity is associated. |
| DisplayName | Customers |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | customers |
| RequiredLevel | None |
| Type | PartyList |
| Targets | account, contact |
DeliveryPriorityCode
| Property | Value |
|---|---|
| Description | Priority of delivery of the activity to the email server. |
| DisplayName | Delivery Priority |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | deliveryprioritycode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | activitypointer_deliveryprioritycode |
DeliveryPriorityCode Choices/Options
| Value | Label |
|---|---|
| 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 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
ExchangeItemId
| Property | Value |
|---|---|
| Description | The message id of activity which is returned from Exchange Server. |
| DisplayName | Exchange Item ID |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | exchangeitemid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 200 |
ExchangeWebLink
| Property | Value |
|---|---|
| Description | Shows the web link of Activity of type email. |
| DisplayName | Exchange WebLink |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | exchangeweblink |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
From
| Property | Value |
|---|---|
| Description | Person who the activity is from. |
| DisplayName | From |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | from |
| RequiredLevel | None |
| Type | PartyList |
| Targets | account, contact, lead, systemuser |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importsequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
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 |
| GlobalChoiceName | opportunityclose_isbilled |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
IsMapiPrivate
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Is Private |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ismapiprivate |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | _opportunityclose_ismapiprivate |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
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 |
| GlobalChoiceName | opportunityclose_isworkflowcreated |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
LastOnHoldTime
| Property | Value |
|---|---|
| Description | Contains the date and time stamp of the last on hold time. |
| DisplayName | Last On Hold Time |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastonholdtime |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
LeftVoiceMail
| Property | Value |
|---|---|
| Description | Left the voice mail |
| DisplayName | Left Voice Mail |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | leftvoicemail |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | _opportunityclose_leftvoicemail |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
OpportunityId
| Property | Value |
|---|---|
| Description | Unique identifier of the opportunity closed. |
| DisplayName | Opportunity |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | opportunityid |
| RequiredLevel | ApplicationRequired |
| Type | Lookup |
| Targets | opportunity |
OpportunityStateCode
| Property | Value |
|---|---|
| Description | Status of the opportunity. |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | opportunitystatecode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | OpportunityClose_opportunity_statecode |
OpportunityStateCode Choices/Options
| Value | Label |
|---|---|
| 0 | Open |
| 1 | Won |
| 2 | Lost |
OpportunityStatusCode
| Property | Value |
|---|---|
| Description | Status reason of the opportunity. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | opportunitystatuscode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | OpportunityClose_opportunity_statuscode |
OpportunityStatusCode Choices/Options
| Value | Label |
|---|---|
| 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 |
| Type | PartyList |
| Targets | account, contact, lead, systemuser |
Organizer
| Property | Value |
|---|---|
| Description | Person who organized the activity. |
| DisplayName | Organizer |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | organizer |
| RequiredLevel | None |
| Type | PartyList |
| Targets | systemuser |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
OwnerId
| Property | Value |
|---|---|
| Description | Unique identifier of the user or team who owns the activity. |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Type | Owner |
| Targets | systemuser, team |
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 |
| Type | PartyList |
| Targets | account, contact |
PriorityCode
| Property | Value |
|---|---|
| Description | Priority of the activity. |
| DisplayName | Priority |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | prioritycode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | _opportunityclose_prioritycode |
PriorityCode Choices/Options
| Value | Label |
|---|---|
| 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 |
| Type | Lookup |
| 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 |
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 |
| Type | PartyList |
| Targets | account, contact, lead, systemuser |
Resources
| Property | Value |
|---|---|
| Description | Users or facility/equipment that are required for the activity. |
| DisplayName | Resources |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | resources |
| RequiredLevel | None |
| Type | PartyList |
| Targets | equipment, systemuser |
ScheduledEnd
| Property | Value |
|---|---|
| Description | Scheduled end time of the opportunity close activity. |
| DisplayName | Scheduled End |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | scheduledend |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ScheduledStart
| Property | Value |
|---|---|
| Description | Scheduled start time of the opportunity close activity. |
| DisplayName | Scheduled Start |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | scheduledstart |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
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 |
| Type | Lookup |
| Targets | service |
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 |
| Type | Lookup |
| Targets | sla |
SortDate
| Property | Value |
|---|---|
| Description | Shows the date and time by which the activities are sorted. |
| DisplayName | Sort Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sortdate |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
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 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
| DefaultFormValue | 0 |
| GlobalChoiceName | opportunityclose_statecode |
StateCode Choices/Options
| Value | Details |
|---|---|
| 0 | Label: Open DefaultStatus: 1 InvariantName: Open |
| 1 | Label: Completed DefaultStatus: 2 InvariantName: Completed |
| 2 | Label: Canceled DefaultStatus: 3 InvariantName: 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 |
| DefaultFormValue | -1 |
| GlobalChoiceName | opportunityclose_statuscode |
StatusCode Choices/Options
| Value | Details |
|---|---|
| 1 | Label: Open State:0 TransitionData: None |
| 2 | Label: Completed State:1 TransitionData: None |
| 3 | Label: Canceled State:2 TransitionData: None |
Subcategory
| Property | Value |
|---|---|
| Description | Subcategory of the opportunity close activity. |
| DisplayName | Sub-Category |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | subcategory |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 250 |
Subject
| Property | Value |
|---|---|
| Description | Subject associated with the opportunity close activity. |
| DisplayName | Subject |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | subject |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 200 |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
To
| Property | Value |
|---|---|
| Description | Person who is the receiver of the activity. |
| DisplayName | To |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | to |
| RequiredLevel | None |
| Type | PartyList |
| Targets | account, contact, lead, systemuser |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | transactioncurrency |
TraversedPath
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | (Deprecated) Traversed Path |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- ActivityTypeCode
- ActualRevenue_Base
- CreatedBy
- CreatedByExternalParty
- CreatedOn
- CreatedOnBehalfBy
- DeliveryLastAttemptedOn
- ExchangeRate
- InstanceTypeCode
- IsRegularActivity
- ModifiedBy
- ModifiedByExternalParty
- ModifiedOn
- ModifiedOnBehalfBy
- OnHoldTime
- OpportunityIdType
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PostponeActivityProcessingUntil
- ScheduledDurationMinutes
- SenderMailboxId
- SentOn
- SeriesId
- SLAInvokedId
- 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 |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
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 |
| Type | Lookup |
| Targets | systemuser |
CreatedByExternalParty
| Property | Value |
|---|---|
| Description | Shows the external party who created the record. |
| DisplayName | Created By (External Party) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdbyexternalparty |
| RequiredLevel | None |
| Type | Lookup |
| Targets | externalparty |
CreatedOn
| Property | Value |
|---|---|
| Description | Date and time when the opportunity close activity was created. |
| DisplayName | Created On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who created the opportunityclose. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
DeliveryLastAttemptedOn
| Property | Value |
|---|---|
| Description | Date and time when the delivery of the activity was last attempted. |
| DisplayName | Date Delivery Last Attempted |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | deliverylastattemptedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ExchangeRate
| Property | Value |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| RequiredLevel | None |
| Type | Decimal |
| ImeMode | Disabled |
| MaxValue | 100000000000 |
| MinValue | 1E-12 |
| Precision | 12 |
| SourceTypeMask | 0 |
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 |
| DefaultFormValue | 0 |
| GlobalChoiceName | _opportunityclose_instancetypecode |
InstanceTypeCode Choices/Options
| Value | Label |
|---|---|
| 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 |
| GlobalChoiceName | activitypointer_isregularactivity |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
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 |
| Type | Lookup |
| Targets | systemuser |
ModifiedByExternalParty
| Property | Value |
|---|---|
| Description | Shows the external party who modified the record. |
| DisplayName | Modified By (External Party) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedbyexternalparty |
| RequiredLevel | None |
| Type | Lookup |
| Targets | externalparty |
ModifiedOn
| Property | Value |
|---|---|
| Description | Date and time when the opportunity close activity was last modified. |
| DisplayName | Modified On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
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 |
| Type | Lookup |
| Targets | systemuser |
OnHoldTime
| Property | Value |
|---|---|
| Description | Shows how long, in minutes, that the record was on hold. |
| DisplayName | On Hold Time (Minutes) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | onholdtime |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
OpportunityIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | opportunityidtype |
| RequiredLevel | None |
| Type | EntityName |
OwnerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit that owns the activity. |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Type | Lookup |
| Targets | businessunit |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier of the team that owns the activity. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Type | Lookup |
| Targets | team |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier of the user that owns the activity. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
PostponeActivityProcessingUntil
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Delay activity processing until |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postponeactivityprocessinguntil |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ScheduledDurationMinutes
| Property | Value |
|---|---|
| Description | Scheduled duration of the opportunity close activity, specified in minutes. |
| DisplayName | Scheduled Duration |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | scheduleddurationminutes |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
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 |
| Type | Lookup |
| Targets | mailbox |
SentOn
| Property | Value |
|---|---|
| Description | Date and time when the activity was sent. |
| DisplayName | Date Sent |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | senton |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
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 |
| Type | Lookup |
| Targets | sla |
VersionNumber
| Property | Value |
|---|---|
| Description | Version number of the activity. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| RequiredLevel | None |
| Type | BigInt |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- account_OpportunityCloses
- activity_pointer_opportunity_close
- adx_invitation_OpportunityCloses
- bookableresourcebooking_OpportunityCloses
- bookableresourcebookingheader_OpportunityCloses
- bulkoperation_OpportunityCloses
- business_unit_opportunity_close_activities
- campaign_OpportunityCloses
- campaignactivity_OpportunityCloses
- competitor_opportunity_activities
- entitlement_OpportunityCloses
- entitlementtemplate_OpportunityCloses
- incident_OpportunityCloses
- interactionforemail_OpportunityCloses
- knowledgearticle_OpportunityCloses
- knowledgebaserecord_OpportunityCloses
- lead_OpportunityCloses
- lk_opportunityclose_createdby
- lk_opportunityclose_createdonbehalfby
- lk_opportunityclose_modifiedby
- lk_opportunityclose_modifiedonbehalfby
- msdyn_customerasset_OpportunityCloses
- mspp_adplacement_OpportunityCloses
- mspp_pollplacement_OpportunityCloses
- mspp_publishingstatetransitionrule_OpportunityCloses
- mspp_redirect_OpportunityCloses
- mspp_shortcut_OpportunityCloses
- mspp_website_OpportunityCloses
- Opportunity_OpportunityClose
- opportunity_OpportunityCloses
- opportunityclose_mailbox_sendermailboxid
- opportunityclose_owner_ownerid
- opportunityclose_sla_slaid
- opportunityclose_sla_slainvokedid
- service_opportunityclose
- site_OpportunityCloses
- team_opportunityclose
- transactioncurrency_opportunityclose
- user_opportunityclose
account_OpportunityCloses
One-To-Many Relationship: account account_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | account |
| ReferencedAttribute | accountid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_account_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: CascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
activity_pointer_opportunity_close
One-To-Many Relationship: activitypointer activity_pointer_opportunity_close
| Property | Value |
|---|---|
| ReferencedEntity | activitypointer |
| ReferencedAttribute | activityid |
| ReferencingAttribute | activityid |
| ReferencingEntityNavigationPropertyName | activityid_activitypointer |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
adx_invitation_OpportunityCloses
One-To-Many Relationship: adx_invitation adx_invitation_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | adx_invitation |
| ReferencedAttribute | adx_invitationid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_adx_invitation_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
bookableresourcebooking_OpportunityCloses
One-To-Many Relationship: bookableresourcebooking bookableresourcebooking_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | bookableresourcebooking |
| ReferencedAttribute | bookableresourcebookingid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_bookableresourcebooking_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
bookableresourcebookingheader_OpportunityCloses
One-To-Many Relationship: bookableresourcebookingheader bookableresourcebookingheader_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | bookableresourcebookingheader |
| ReferencedAttribute | bookableresourcebookingheaderid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_bookableresourcebookingheader_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
bulkoperation_OpportunityCloses
One-To-Many Relationship: bulkoperation bulkoperation_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | bulkoperation |
| ReferencedAttribute | activityid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_bulkoperation_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
business_unit_opportunity_close_activities
One-To-Many Relationship: businessunit business_unit_opportunity_close_activities
| Property | Value |
|---|---|
| ReferencedEntity | businessunit |
| ReferencedAttribute | businessunitid |
| ReferencingAttribute | owningbusinessunit |
| ReferencingEntityNavigationPropertyName | owningbusinessunit_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
campaign_OpportunityCloses
One-To-Many Relationship: campaign campaign_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | campaign |
| ReferencedAttribute | campaignid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_campaign_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
campaignactivity_OpportunityCloses
One-To-Many Relationship: campaignactivity campaignactivity_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | campaignactivity |
| ReferencedAttribute | activityid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_campaignactivity_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
competitor_opportunity_activities
One-To-Many Relationship: competitor competitor_opportunity_activities
| Property | Value |
|---|---|
| ReferencedEntity | competitor |
| ReferencedAttribute | competitorid |
| ReferencingAttribute | competitorid |
| ReferencingEntityNavigationPropertyName | competitorid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
entitlement_OpportunityCloses
One-To-Many Relationship: entitlement entitlement_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | entitlement |
| ReferencedAttribute | entitlementid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_entitlement_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
entitlementtemplate_OpportunityCloses
One-To-Many Relationship: entitlementtemplate entitlementtemplate_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | entitlementtemplate |
| ReferencedAttribute | entitlementtemplateid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_entitlementtemplate_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
incident_OpportunityCloses
One-To-Many Relationship: incident incident_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | incident |
| ReferencedAttribute | incidentid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_incident_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: CascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
interactionforemail_OpportunityCloses
One-To-Many Relationship: interactionforemail interactionforemail_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | interactionforemail |
| ReferencedAttribute | interactionforemailid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_new_interactionforemail_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
knowledgearticle_OpportunityCloses
One-To-Many Relationship: knowledgearticle knowledgearticle_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | knowledgearticle |
| ReferencedAttribute | knowledgearticleid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_knowledgearticle_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
knowledgebaserecord_OpportunityCloses
One-To-Many Relationship: knowledgebaserecord knowledgebaserecord_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | knowledgebaserecord |
| ReferencedAttribute | knowledgebaserecordid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_knowledgebaserecord_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lead_OpportunityCloses
One-To-Many Relationship: lead lead_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | lead |
| ReferencedAttribute | leadid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_lead_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: CascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
lk_opportunityclose_createdby
One-To-Many Relationship: systemuser lk_opportunityclose_createdby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdby |
| ReferencingEntityNavigationPropertyName | createdby_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_opportunityclose_createdonbehalfby
One-To-Many Relationship: systemuser lk_opportunityclose_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_opportunityclose_modifiedby
One-To-Many Relationship: systemuser lk_opportunityclose_modifiedby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedby |
| ReferencingEntityNavigationPropertyName | modifiedby_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_opportunityclose_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_opportunityclose_modifiedonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedonbehalfby |
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_customerasset_OpportunityCloses
One-To-Many Relationship: msdyn_customerasset msdyn_customerasset_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_customerasset |
| ReferencedAttribute | msdyn_customerassetid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_msdyn_customerasset_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
mspp_adplacement_OpportunityCloses
One-To-Many Relationship: mspp_adplacement mspp_adplacement_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | mspp_adplacement |
| ReferencedAttribute | mspp_adplacementid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_mspp_adplacement_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
mspp_pollplacement_OpportunityCloses
One-To-Many Relationship: mspp_pollplacement mspp_pollplacement_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | mspp_pollplacement |
| ReferencedAttribute | mspp_pollplacementid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_mspp_pollplacement_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
mspp_publishingstatetransitionrule_OpportunityCloses
One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | mspp_publishingstatetransitionrule |
| ReferencedAttribute | mspp_publishingstatetransitionruleid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_mspp_publishingstatetransitionrule_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
mspp_redirect_OpportunityCloses
One-To-Many Relationship: mspp_redirect mspp_redirect_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | mspp_redirect |
| ReferencedAttribute | mspp_redirectid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_mspp_redirect_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
mspp_shortcut_OpportunityCloses
One-To-Many Relationship: mspp_shortcut mspp_shortcut_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | mspp_shortcut |
| ReferencedAttribute | mspp_shortcutid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_mspp_shortcut_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
mspp_website_OpportunityCloses
One-To-Many Relationship: mspp_website mspp_website_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | mspp_website |
| ReferencedAttribute | mspp_websiteid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_mspp_website_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
Opportunity_OpportunityClose
One-To-Many Relationship: opportunity Opportunity_OpportunityClose
| Property | Value |
|---|---|
| ReferencedEntity | opportunity |
| ReferencedAttribute | opportunityid |
| ReferencingAttribute | opportunityid |
| ReferencingEntityNavigationPropertyName | opportunityid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
opportunity_OpportunityCloses
One-To-Many Relationship: opportunity opportunity_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | opportunity |
| ReferencedAttribute | opportunityid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_opportunity_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
opportunityclose_mailbox_sendermailboxid
One-To-Many Relationship: mailbox opportunityclose_mailbox_sendermailboxid
| Property | Value |
|---|---|
| ReferencedEntity | mailbox |
| ReferencedAttribute | mailboxid |
| ReferencingAttribute | sendermailboxid |
| ReferencingEntityNavigationPropertyName | sendermailboxid_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
opportunityclose_owner_ownerid
One-To-Many Relationship: owner opportunityclose_owner_ownerid
| Property | Value |
|---|---|
| ReferencedEntity | owner |
| ReferencedAttribute | ownerid |
| ReferencingAttribute | ownerid |
| ReferencingEntityNavigationPropertyName | ownerid_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
opportunityclose_sla_slaid
One-To-Many Relationship: sla opportunityclose_sla_slaid
| Property | Value |
|---|---|
| ReferencedEntity | sla |
| ReferencedAttribute | slaid |
| ReferencingAttribute | slaid |
| ReferencingEntityNavigationPropertyName | sla_activitypointer_sla_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
opportunityclose_sla_slainvokedid
One-To-Many Relationship: sla opportunityclose_sla_slainvokedid
| Property | Value |
|---|---|
| ReferencedEntity | sla |
| ReferencedAttribute | slaid |
| ReferencingAttribute | slainvokedid |
| ReferencingEntityNavigationPropertyName | slainvokedid_activitypointer_sla_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
service_opportunityclose
One-To-Many Relationship: service service_opportunityclose
| Property | Value |
|---|---|
| ReferencedEntity | service |
| ReferencedAttribute | serviceid |
| ReferencingAttribute | serviceid |
| ReferencingEntityNavigationPropertyName | serviceid_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
site_OpportunityCloses
One-To-Many Relationship: site site_OpportunityCloses
| Property | Value |
|---|---|
| ReferencedEntity | site |
| ReferencedAttribute | siteid |
| ReferencingAttribute | regardingobjectid |
| ReferencingEntityNavigationPropertyName | regardingobjectid_site_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
team_opportunityclose
One-To-Many Relationship: team team_opportunityclose
| Property | Value |
|---|---|
| ReferencedEntity | team |
| ReferencedAttribute | teamid |
| ReferencingAttribute | owningteam |
| ReferencingEntityNavigationPropertyName | owningteam_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
transactioncurrency_opportunityclose
One-To-Many Relationship: transactioncurrency transactioncurrency_opportunityclose
| Property | Value |
|---|---|
| ReferencedEntity | transactioncurrency |
| ReferencedAttribute | transactioncurrencyid |
| ReferencingAttribute | transactioncurrencyid |
| ReferencingEntityNavigationPropertyName | transactioncurrencyid_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
user_opportunityclose
One-To-Many Relationship: systemuser user_opportunityclose
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | owninguser |
| ReferencingEntityNavigationPropertyName | owninguser_opportunityclose |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- CampaignResponse_OpportunityCloses
- opportunityclose_activity_parties
- OpportunityClose_Annotation
- OpportunityClose_AsyncOperations
- OpportunityClose_BulkDeleteFailures
- opportunityclose_MailboxTrackingFolders
- opportunityclose_PrincipalObjectAttributeAccesses
- OpportunityClose_SyncErrors
CampaignResponse_OpportunityCloses
Many-To-One Relationship: campaignresponse CampaignResponse_OpportunityCloses
| Property | Value |
|---|---|
| ReferencingEntity | campaignresponse |
| ReferencingAttribute | originatingactivityid |
| ReferencedEntityNavigationPropertyName | CampaignResponse_OpportunityCloses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunityclose_activity_parties
Many-To-One Relationship: activityparty opportunityclose_activity_parties
| Property | Value |
|---|---|
| ReferencingEntity | activityparty |
| ReferencingAttribute | activityid |
| ReferencedEntityNavigationPropertyName | opportunityclose_activity_parties |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
OpportunityClose_Annotation
Many-To-One Relationship: annotation OpportunityClose_Annotation
| Property | Value |
|---|---|
| ReferencingEntity | annotation |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | OpportunityClose_Annotation |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
OpportunityClose_AsyncOperations
Many-To-One Relationship: asyncoperation OpportunityClose_AsyncOperations
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | OpportunityClose_AsyncOperations |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
OpportunityClose_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure OpportunityClose_BulkDeleteFailures
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | OpportunityClose_BulkDeleteFailures |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunityclose_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder opportunityclose_MailboxTrackingFolders
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunityclose_MailboxTrackingFolders |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunityclose_PrincipalObjectAttributeAccesses
Many-To-One Relationship: principalobjectattributeaccess opportunityclose_PrincipalObjectAttributeAccesses
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | opportunityclose_PrincipalObjectAttributeAccesses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
OpportunityClose_SyncErrors
Many-To-One Relationship: syncerror OpportunityClose_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | OpportunityClose_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference