Product Entity Metadata

  • Article

[Applies to: Microsoft Dynamics CRM 2011]

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

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

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the product entity.

Entity metadata property Value

EntityLogicalName

product

OTC

1024

OwnershipType

OrganizationOwned

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

False

IsAuditEnabled

False

IsAvailableOffline

True

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsCustomizable

True

IsDocumentManagementEnabled

True

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

productid

PrimaryNameAttribute

name

ReportViewName

FilteredProduct

RecurrenceBaseEntityLogicalName

x

Description

Information about products and their pricing information.

DisplayName

Product

DisplayCollectionName

Products

Privilege Metadata

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

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendProduct

d589f1a0-e1e1-4585-86c4-6b6dc33e8f65

Append

False

False

True

False

prvAppendToProduct

cc345e3d-927f-4aa2-9be5-6a79e2db3577

AppendTo

False

False

True

False

prvCreateProduct

5f873211-084e-4eb2-94b8-98f068440dc2

Create

False

False

True

False

prvDeleteProduct

cc04cb55-cc00-4315-a100-0dafd1f1caba

Delete

False

False

True

False

prvReadProduct

60d420ca-7a88-4c0d-8286-c425b527fa98

Read

False

False

True

False

prvWriteProduct

4f86580f-d0ad-473a-91e2-e3fc7b7d5d0c

Write

False

False

True

False

Attribute Metadata

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

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

createdby

CreatedBy

Lookup

None

False

True

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By

Unique identifier of the user who created the product.

createdon

CreatedOn

DateTime

None

False

True

False

True

False

False

False

False

False

True

False

False

True

False

True

Created On

Date and time when the product was created.

createdonbehalfby

CreatedOnBehalfBy

Lookup

None

False

True

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By (Delegate)

Unique identifier of the delegate user who created the product.

currentcost

CurrentCost

Money

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Current Cost

Current cost for the product item. Used in price calculations.

currentcost_base

CurrentCost_Base

Money

None

False

True

False

True

False

False

False

False

True

True

False

False

True

False

True

Current Cost (Base)

Base currency equivalent of the current cost for the product item.

defaultuomid

DefaultUoMId

Lookup

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Default Unit

Default unit for the product.

defaultuomscheduleid

DefaultUoMScheduleId

Lookup

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Unit Group

Default unit group for the product.

description

Description

Memo

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Description

Description of the product.

exchangerate

ExchangeRate

Decimal

None

False

True

False

True

False

False

False

False

True

True

False

False

True

False

True

Exchange Rate

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

importsequencenumber

ImportSequenceNumber

Integer

None

False

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Import Sequence Number

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

iskit

IsKit

Boolean

None

False

True

True

True

True

False

False

False

True

True

False

False

False

False

False

Is Kit

Information that specifies whether the product is a kit.

isstockitem

IsStockItem

Boolean

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Stock Item

Information about whether the product is a stock item.

modifiedby

ModifiedBy

Lookup

None

False

True

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By

Unique identifier of the user who last modified the product.

modifiedon

ModifiedOn

DateTime

None

False

True

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified On

Date and time when the product was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Lookup

None

False

True

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By (Delegate)

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

name

Name

String

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

True

True

False

True

Product Name

Name of the product.

organizationid

OrganizationId

Lookup

SystemRequired

False

False

False

True

False

False

False

False

False

True

False

False

False

False

False

Organization

Unique identifier of the organization associated with the product.

overriddencreatedon

OverriddenCreatedOn

DateTime

None

False

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Record Created On

Date and time that the record was migrated.

price

Price

Money

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

List Price

List price of the product.

price_base

Price_Base

Money

None

False

True

False

True

False

False

False

False

True

True

False

False

True

False

True

List Price (Base)

Base currency equivalent of the list price of the product

pricelevelid

PriceLevelId

Lookup

Recommended

False

True

False

True

True

False

False

False

True

True

False

False

True

False

True

Default Price List

Unique identifier of the price list associated with the product.

productid

ProductId

Uniqueidentifier

SystemRequired

False

True

True

True

False

False

False

False

False

True

True

False

True

False

True

Product

Unique identifier of the product.

productnumber

ProductNumber

String

SystemRequired

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

ID

User-defined product number.

producttypecode

ProductTypeCode

Picklist

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Product Type

Type of product.

producturl

ProductUrl

String

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

URL

URL for the Web site associated with the product.

quantitydecimal

QuantityDecimal

Integer

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Decimals Supported

Number of decimal places that can be used in monetary amounts for the product.

quantityonhand

QuantityOnHand

Decimal

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Quantity On Hand

Quantity of the product in stock.

size

Size

String

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Size

Product size.

standardcost

StandardCost

Money

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Standard Cost

Standard cost of the product.

standardcost_base

StandardCost_Base

Money

None

False

True

False

True

False

False

False

False

True

True

False

False

True

False

True

Standard Cost (Base)

Base currency equivalent of the standard cost of the product.

statecode

StateCode

State

SystemRequired

False

True

False

True

False

False

False

False

True

True

False

False

True

False

True

Status

Status of the product.

statuscode

StatusCode

Status

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Status Reason

Reason for the status of the product.

stockvolume

StockVolume

Decimal

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Stock Volume

Stock volume of the product.

stockweight

StockWeight

Decimal

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Stock Weight

Stock weight of the product.

subjectid

SubjectId

Lookup

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Subject

Unique identifier of the subject associated with the product.

suppliername

SupplierName

String

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Supplier Name

Name of the product's supplier.

timezoneruleversionnumber

TimeZoneRuleVersionNumber

Integer

None

False

True

True

True

True

False

False

False

False

True

False

False

False

False

False

Time Zone Rule Version Number

For internal use only.

transactioncurrencyid

TransactionCurrencyId

Lookup

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Currency

Unique identifier of the currency associated with the product.

utcconversiontimezonecode

UTCConversionTimeZoneCode

Integer

None

False

True

True

True

True

False

False

False

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

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

vendorname

VendorName

String

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Vendor

Name of the product vendor.

vendorpartnumber

VendorPartNumber

String

None

False

True

True

True

True

False

False

False

True

True

False

False

True

False

True

Vendor Part Number

Part number for the vendor's product.

versionnumber

VersionNumber

BigInt

None

False

False

False

True

False

False

False

False

False

True

False

False

False

False

False

Version Number

Version number of the product.

One-to-Many Relationships

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

Relationship schema name Referencing entity

Product_Annotation

annotation

Product_AsyncOperations

asyncoperation

Product_BulkDeleteFailures

bulkdeletefailure

product_contract_line_items

contractdetail

product_incidents

incident

product_invoice_details

invoicedetail

opportunity_products

opportunityproduct

product_principalobjectattributeaccess

principalobjectattributeaccess

Product_ProcessSessions

processsession

product_price_levels

productpricelevel

product_quote_details

quotedetail

product_order_details

salesorderdetail

Product_SharepointDocumentLocation

sharepointdocumentlocation

userentityinstancedata_product

userentityinstancedata

Many-to-Many Relationships

The following table shows the many-to-many relationships for the product entity.

Relationship schema name Entity 1 Entity 2 Intersect entity

campaignproduct_association

campaign

product

campaignitem

competitorproduct_association

competitor

product

competitorproduct

leadproduct_association

lead

product

leadproduct

productassociation_association

product

product

productassociation

productsalesliterature_association

product

salesliterature

productsalesliterature

productsubstitute_association

product

product

productsubstitute

For information about using intersect entities, see Retrieve Records for Many-To-Many Relationships Using Intersect Entities.

Many-to-One Relationships

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

Relationship schema name Referenced entity

organization_products

organization

price_level_products

pricelevel

subject_products

subject

lk_productbase_modifiedby

systemuser

lk_productbase_createdby

systemuser

lk_product_modifiedonbehalfby

systemuser

lk_product_createdonbehalfby

systemuser

transactioncurrency_product

transactioncurrency

unit_of_measurement_products

uom

unit_of_measurement_schedule_products

uomschedule

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

Product Entity Messages and Methods
Product Entity OptionSet Attribute Metadata
Product Entity Privileges

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