Integration Your Way - (800) 235-7250
RSSBus JDBC Driver for MSCRM
Questions / Feedback? Opportunity

Opportunity

This is a table representing the Opportunity entities in CRM Dynamics.

Columns

Name Type Description ReadOnly
Id [KEY] Edm.String Id of the entity. True
OpportunityRatingCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The OpportunityRatingCode of the Opportunity. False
TotalDiscountAmount Microsoft.Crm.Sdk.Data.Services.Money The TotalDiscountAmount of the Opportunity. False
CreatedOnBehalfBy Microsoft.Crm.Sdk.Data.Services.EntityReference The CreatedOnBehalfBy of the Opportunity. False
DiscountAmount Microsoft.Crm.Sdk.Data.Services.Money The DiscountAmount of the Opportunity. False
ParticipatesInWorkflow Edm.Boolean The ParticipatesInWorkflow of the Opportunity. False
FreightAmount_Base Microsoft.Crm.Sdk.Data.Services.Money The FreightAmount_Base of the Opportunity. False
StateCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The StateCode of the Opportunity. False
CampaignId Microsoft.Crm.Sdk.Data.Services.EntityReference The CampaignId of the Opportunity. False
OwningTeam Microsoft.Crm.Sdk.Data.Services.EntityReference The OwningTeam of the Opportunity. False
OriginatingLeadId Microsoft.Crm.Sdk.Data.Services.EntityReference The OriginatingLeadId of the Opportunity. False
TimeZoneRuleVersionNumber Edm.Int32 The TimeZoneRuleVersionNumber of the Opportunity. False
TotalLineItemDiscountAmount_Base Microsoft.Crm.Sdk.Data.Services.Money The TotalLineItemDiscountAmount_Base of the Opportunity. False
TotalLineItemAmount_Base Microsoft.Crm.Sdk.Data.Services.Money The TotalLineItemAmount_Base of the Opportunity. False
TotalDiscountAmount_Base Microsoft.Crm.Sdk.Data.Services.Money The TotalDiscountAmount_Base of the Opportunity. False
OwningUser Microsoft.Crm.Sdk.Data.Services.EntityReference The OwningUser of the Opportunity. False
OwnerId Microsoft.Crm.Sdk.Data.Services.EntityReference The OwnerId of the Opportunity. False
TotalAmount Microsoft.Crm.Sdk.Data.Services.Money The TotalAmount of the Opportunity. False
EstimatedCloseDate Edm.DateTime The EstimatedCloseDate of the Opportunity. False
OwningBusinessUnit Microsoft.Crm.Sdk.Data.Services.EntityReference The OwningBusinessUnit of the Opportunity. False
ExchangeRate Edm.Decimal The ExchangeRate of the Opportunity. False
CreatedBy Microsoft.Crm.Sdk.Data.Services.EntityReference The CreatedBy of the Opportunity. False
ModifiedOn Edm.DateTime The ModifiedOn of the Opportunity. False
StepId Edm.Guid The StepId of the Opportunity. False
ContactId Microsoft.Crm.Sdk.Data.Services.EntityReference The ContactId of the Opportunity. False
CreatedOn Edm.DateTime The CreatedOn of the Opportunity. False
UTCConversionTimeZoneCode Edm.Int32 The UTCConversionTimeZoneCode of the Opportunity. False
VersionNumber Edm.Int64 The VersionNumber of the Opportunity. False
OverriddenCreatedOn Edm.DateTime The OverriddenCreatedOn of the Opportunity. False
EstimatedValue_Base Microsoft.Crm.Sdk.Data.Services.Money The EstimatedValue_Base of the Opportunity. False
PriceLevelId Microsoft.Crm.Sdk.Data.Services.EntityReference The PriceLevelId of the Opportunity. False
TotalTax_Base Microsoft.Crm.Sdk.Data.Services.Money The TotalTax_Base of the Opportunity. False
TotalTax Microsoft.Crm.Sdk.Data.Services.Money The TotalTax of the Opportunity. False
Description Edm.String The Description of the Opportunity. False
ModifiedOnBehalfBy Microsoft.Crm.Sdk.Data.Services.EntityReference The ModifiedOnBehalfBy of the Opportunity. False
EstimatedValue Microsoft.Crm.Sdk.Data.Services.Money The EstimatedValue of the Opportunity. False
TransactionCurrencyId Microsoft.Crm.Sdk.Data.Services.EntityReference The TransactionCurrencyId of the Opportunity. False
ImportSequenceNumber Edm.Int32 The ImportSequenceNumber of the Opportunity. False
CustomerId Microsoft.Crm.Sdk.Data.Services.EntityReference The CustomerId of the Opportunity. False
DiscountAmount_Base Microsoft.Crm.Sdk.Data.Services.Money The DiscountAmount_Base of the Opportunity. False
StatusCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The StatusCode of the Opportunity. False
TotalAmountLessFreight_Base Microsoft.Crm.Sdk.Data.Services.Money The TotalAmountLessFreight_Base of the Opportunity. False
Name Edm.String The Name of the Opportunity. False
TotalLineItemDiscountAmount Microsoft.Crm.Sdk.Data.Services.Money The TotalLineItemDiscountAmount of the Opportunity. False
PricingErrorCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The PricingErrorCode of the Opportunity. False
ActualCloseDate Edm.DateTime The ActualCloseDate of the Opportunity. False
CloseProbability Edm.Int32 The CloseProbability of the Opportunity. False
ActualValue_Base Microsoft.Crm.Sdk.Data.Services.Money The ActualValue_Base of the Opportunity. False
IsRevenueSystemCalculated Edm.Boolean The IsRevenueSystemCalculated of the Opportunity. False
StepName Edm.String The StepName of the Opportunity. False
FreightAmount Microsoft.Crm.Sdk.Data.Services.Money The FreightAmount of the Opportunity. False
SalesStageCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The SalesStageCode of the Opportunity. False
ModifiedBy Microsoft.Crm.Sdk.Data.Services.EntityReference The ModifiedBy of the Opportunity. False
DiscountPercentage Edm.Decimal The DiscountPercentage of the Opportunity. False
PriorityCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The PriorityCode of the Opportunity. False
TotalAmountLessFreight Microsoft.Crm.Sdk.Data.Services.Money The TotalAmountLessFreight of the Opportunity. False
TotalLineItemAmount Microsoft.Crm.Sdk.Data.Services.Money The TotalLineItemAmount of the Opportunity. False
AccountId Microsoft.Crm.Sdk.Data.Services.EntityReference The AccountId of the Opportunity. False
ActualValue Microsoft.Crm.Sdk.Data.Services.Money The ActualValue of the Opportunity. False
OpportunityId Edm.Guid The OpportunityId of the Opportunity. False
TotalAmount_Base Microsoft.Crm.Sdk.Data.Services.Money The TotalAmount_Base of the Opportunity. False


 
Copyright © 2013 RSSBus Inc.
[x] close

Questions / Feedback?


Name:
Email:
Feedback:
Send Feedback