SSIS Components for Microsoft Dynamics CRM

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060