OpportunityClose
This is a table representing the OpportunityClose entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the opportunity closed. |
| ActivityId | String | False |
Unique identifier of the opportunity close activity. |
| ActivityTypeCode | String | True |
Type of activity. |
| ActualDurationMinutes | Integer | False |
Actual duration of the opportunity close activity in minutes. |
| ActualEnd | Datetime | False |
Actual end time of the opportunity close activity. |
| ActualRevenue | Double | False |
Actual revenue generated for the opportunity. |
| ActualRevenue_Base | Double | True |
Base currency equivalent of the actual revenue generated for the opportunity. |
| ActualStart | Datetime | False |
Actual start time of the opportunity close activity. |
| Category | String | False |
Category of the opportunity close activity. |
| CompetitorId_Id | String | False |
Unique identifier of the competitor with which the opportunity close activity is associated. |
| CompetitorId_LogicalName | String | False | |
| CompetitorId_Name | String | False | |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the opportunity close activity. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the opportunity close activity was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the opportunityclose. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Description | String | False |
Activity that is created automatically when an opportunity is closed, containing information such as the description of the closing and actual revenue. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the opportunity close activity with respect to the base currency. |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| IsBilled | Boolean | False |
Information about whether the opportunity close activity was billed as part of resolving a case. |
| IsRegularActivity | Boolean | True |
Information regarding whether the activity is a regular activity type or event type. |
| IsWorkflowCreated | Boolean | False |
Information that specifies if the opportunity close activity was created from a workflow rule. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the opportunity close activity. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the opportunity close activity was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the opportunityclose. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| OpportunityId_Id | String | False |
Unique identifier of the opportunity closed. |
| OpportunityId_LogicalName | String | False | |
| OpportunityId_Name | String | False | |
| OverriddenCreatedOn | Datetime | False |
Date and time that the record was migrated. |
| OwnerId_Id | String | False |
Unique identifier of the user or team who owns the opportunity close activity. |
| OwnerId_LogicalName | String | False | |
| OwnerId_Name | String | False | |
| OwningBusinessUnit_Id | String | True |
Unique identifier of the business unit that owns the opportunity close activity. |
| OwningBusinessUnit_LogicalName | String | True | |
| OwningBusinessUnit_Name | String | True | |
| OwningTeam_Id | String | True |
Unique identifier of the team who owns the opportunity close activity. |
| OwningTeam_LogicalName | String | True | |
| OwningTeam_Name | String | True | |
| OwningUser_Id | String | True |
Unique identifier of the user who owns the opportunity close activity. |
| OwningUser_LogicalName | String | True | |
| OwningUser_Name | String | True | |
| ScheduledDurationMinutes | Integer | True |
Scheduled duration of the opportunity close activity, specified in minutes. |
| ScheduledEnd | Datetime | False |
Scheduled end time of the opportunity close activity. |
| ScheduledStart | Datetime | False |
Scheduled start time of the opportunity close activity. |
| ServiceId_Id | String | False |
Unique identifier of the service with which the opportunity close activity is associated. |
| ServiceId_LogicalName | String | False | |
| ServiceId_Name | String | False | |
| StateCode | String | True |
Status of the opportunity close activity. |
| StatusCode | String | False |
Reason for the status of the opportunity close activity. |
| Subcategory | String | False |
Subcategory of the opportunity close activity. |
| Subject | String | False |
Subject associated with the opportunity close activity. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| TransactionCurrencyId_Id | String | False |
Unique identifier of the currency associated with the opportunity close. |
| TransactionCurrencyId_LogicalName | String | False | |
| TransactionCurrencyId_Name | String | False | |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |