Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

OpportunityProduct Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the opportunity product entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is OpportunityProduct.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

The following table shows the metadata for the opportunity product entity.

 

Entity metadata property Value

OTC

1083

EntityLogicalName

opportunityproduct

DisplayName

Opportunity Product

OwnershipType

None

IsCustomizable

True

Description

Association between an opportunity and a product.

IsAvailableOffline

True

IsAuditEnabled

False

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

False

IsChildEntity

True

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

True

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

opportunityproductid

PrimaryNameAttribute

productidname

ReportViewName

FilteredOpportunityProduct

RecurrenceBaseEntityLogicalName

DisplayCollectionName

Opportunity Products

Privilege Metadata

There is no privilege metadata for the opportunity product entity.

Attribute Metadata

The following table shows the attribute metadata for the opportunity product entity.

 

EntityLogicalName IsCustomizableEntity IsIntersect LogicalName Description Type SchemaName IsCustomAttribute IsCustomizable RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName

opportunityproduct

yes

no

baseamount

Subtotal for the opportunity product before discounts are applied and taxes are added.

Money

BaseAmount

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Amount

opportunityproduct

yes

no

baseamount_base

Base currency equivalent of the subtotal for the opportunity product before discounts are applied and taxes are added.

Money

BaseAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Amount (Base)

opportunityproduct

yes

no

createdby

Unique identifier of the user who created the opportunity product.

Lookup

CreatedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By

opportunityproduct

yes

no

createdon

Date and time when the opportunity product was created.

DateTime

CreatedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created On

opportunityproduct

yes

no

createdonbehalfby

Unique identifier of the delegate user who created the opportunityproduct.

Lookup

CreatedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By (Delegate)

opportunityproduct

yes

no

description

Description of the opportunity product.

Memo

Description

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Description

opportunityproduct

yes

no

exchangerate

Exchange rate for the currency associated with the opportunity product with respect to the base currency.

Decimal

ExchangeRate

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Exchange Rate

opportunityproduct

yes

no

extendedamount

Subtotal of the opportunity product after discounts are applied and taxes are added.

Money

ExtendedAmount

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Extended Amount

opportunityproduct

yes

no

extendedamount_base

Base currency equivalent of the subtotal of the opportunity product after discounts are applied and taxes are added.

Money

ExtendedAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Extended Amount (Base)

opportunityproduct

yes

no

importsequencenumber

Unique identifier of the data import or data migration that created this record.

Integer

ImportSequenceNumber

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Import Sequence Number

opportunityproduct

yes

no

ispriceoverridden

Specifies whether to override product catalog pricing.

Boolean

IsPriceOverridden

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Price Overridden

opportunityproduct

yes

no

isproductoverridden

Specifies whether the product is a write-in product or an existing product.

Boolean

IsProductOverridden

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Select Product

opportunityproduct

yes

no

lineitemnumber

Line item number for the opportunity product.

Integer

LineItemNumber

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Line Item Number

opportunityproduct

yes

no

manualdiscountamount

Customized discount amount for the opportunity product.

Money

ManualDiscountAmount

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Manual Discount Amount

opportunityproduct

yes

no

manualdiscountamount_base

Base currency equivalent of the customized discount amount for the opportunity product.

Money

ManualDiscountAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Manual Discount Amount (Base)

opportunityproduct

yes

no

modifiedby

Unique identifier of the user who last modified the opportunity product.

Lookup

ModifiedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By

opportunityproduct

yes

no

modifiedon

Date and time when the opportunity product was last modified.

DateTime

ModifiedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified On

opportunityproduct

yes

no

modifiedonbehalfby

Unique identifier of the delegate user who last modified the opportunityproduct.

Lookup

ModifiedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By (Delegate)

opportunityproduct

yes

no

opportunityid

Unique identifier of the opportunity with which the opportunity product is associated.

Lookup

OpportunityId

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

False

Opportunity

opportunityproduct

yes

no

opportunityproductid

Unique identifier of the opportunity product.

Uniqueidentifier

OpportunityProductId

False

True

SystemRequired

True

True

False

False

False

False

False

True

True

False

True

False

True

Opportunity Product

opportunityproduct

yes

no

opportunitystatecode

Status of the opportunity product.

Picklist

OpportunityStateCode

False

True

SystemRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Opportunity Status

opportunityproduct

yes

no

overriddencreatedon

Date and time that the record was migrated.

DateTime

OverriddenCreatedOn

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Record Created On

opportunityproduct

yes

no

ownerid

Unique identifier of the user or team who owns the opportunity product.

Owner

OwnerId

False

True

ApplicationRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Owner

opportunityproduct

yes

no

owningbusinessunit

Unique identifier of the business unit that owns the opportunity product.

Uniqueidentifier

OwningBusinessUnit

False

False

ApplicationRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning Business Unit

opportunityproduct

yes

no

owninguser

Unique identifier of the user who owns the opportunity product.

Uniqueidentifier

OwningUser

False

False

ApplicationRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning User

opportunityproduct

yes

no

priceperunit

Price per unit for the opportunity product.

Money

PricePerUnit

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Price Per Unit

opportunityproduct

yes

no

priceperunit_base

Base currency equivalent of the price per unit for the opportunity product.

Money

PricePerUnit_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Price Per Unit (Base)

opportunityproduct

yes

no

pricingerrorcode

Pricing error for the opportunity product.

Picklist

PricingErrorCode

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Pricing Error

opportunityproduct

yes

no

productdescription

Product description for the opportunity product.

String

ProductDescription

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Write-In Product

opportunityproduct

yes

no

productid

Unique identifier of the product listed for the opportunity product.

Lookup

ProductId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Existing Product

opportunityproduct

yes

no

quantity

Product quantity specified for the opportunity product.

Decimal

Quantity

False

True

ApplicationRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Quantity

opportunityproduct

yes

no

tax

Tax amount for the opportunity product.

Money

Tax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Tax

opportunityproduct

yes

no

tax_base

Base currency equivalent of the tax amount for the opportunity product.

Money

Tax_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Tax (Base)

opportunityproduct

yes

no

timezoneruleversionnumber

For internal use only.

Integer

TimeZoneRuleVersionNumber

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

Time Zone Rule Version Number

opportunityproduct

yes

no

transactioncurrencyid

Unique identifier of the currency associated with the opportunity product.

Lookup

TransactionCurrencyId

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Currency

opportunityproduct

yes

no

uomid

Unique identifier of the unit that is associated with the opportunity product.

Lookup

UoMId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Unit

opportunityproduct

yes

no

utcconversiontimezonecode

Time zone code that was in use when the record was created.

Integer

UTCConversionTimeZoneCode

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

opportunityproduct

yes

no

versionnumber

Version number of the opportunity product.

BigInt

VersionNumber

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Version Number

opportunityproduct

yes

no

volumediscountamount

Volume discount amount for the opportunity product.

Money

VolumeDiscountAmount

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Volume Discount

opportunityproduct

yes

no

volumediscountamount_base

Base currency equivalent of the volume discount amount for the opportunity product.

Money

VolumeDiscountAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Volume Discount (Base)

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the opportunity product entity.

 

Relationship schema name Referencing Entity

OpportunityProduct_AsyncOperations

asyncoperation

OpportunityProduct_BulkDeleteFailures

bulkdeletefailure

opportunityproduct_principalobjectattributeaccess

principalobjectattributeaccess

OpportunityProduct_ProcessSessions

processsession

userentityinstancedata_opportunityproduct

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the opportunity product entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the opportunity product entity.

 

Relationship schema name Referenced Entity

product_opportunities

opportunity

opportunity_products

product

lk_opportunityproduct_modifiedonbehalfby

systemuser

lk_opportunityproductbase_modifiedby

systemuser

lk_opportunityproduct_createdonbehalfby

systemuser

lk_opportunityproductbase_createdby

systemuser

transactioncurrency_opportunityproduct

transactioncurrency

unit_of_measurement_opportunity_products

uom

See Also

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.

Community Additions

Show:
© 2015 Microsoft