ProductPriceLevel (Price List Item) Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the product price level (price list item) entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is ProductPriceLevel.

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 price level (price list item) entity.

Metdadata property Value

OTC

1026

EntityLogicalName

productpricelevel

EntitySchemaName

ProductPriceLevel

DisplayName

Price List Item

DisplayCollectionName

Price List Items

IsCustomizable

True

OwnershipType

None

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

False

CanBeRelatedEntityInRelationship

False

CanCreateAttributes

False

CanCreateCharts

False

CanCreateForms

False

CanCreateViews

False

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

False

IsAuditEnabled

False

IsAvailableOffline

True

IsChildEntity

True

IsConnectionsEnabled

canmodifyconnectionsettings

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

False

IsValidForAdvancedFind

False

IsValidForQueue

False

IsVisibleInMobile

True

PrimaryIdAttribute

productpricelevelid

PrimaryNameAttribute

productidname

ReportViewName

FilteredProductPriceLevel

Privilege Metadata

There is no entity privilege metadata for the product price level (price list item) entity.

Attribute Metadata

The following table shows the attribute metadata for the product price level (price list item) entity.

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

amount

Amount

Money

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Amount

Monetary amount for the price list.

amount_base

Amount_Base

Money

None

False

True

False

True

False

False

False

False

True

True

False

False

False

False

True

Amount (Base)

Base currency equivalent of the monetary amount for the price list.

createdby

CreatedBy

Lookup

None

False

False

False

True

False

False

False

False

False

True

False

False

False

False

True

Created By

Unique identifier of the user who created the price list.

createdon

CreatedOn

DateTime

None

False

False

False

True

False

False

False

False

False

True

False

False

False

False

True

Created On

Date and time when the price list was created.

createdonbehalfby

CreatedOnBehalfBy

Lookup

None

False

True

False

True

False

False

False

False

False

True

False

False

False

False

True

Created By (Delegate)

Unique identifier of the delegate user who created the lead.

discounttypeid

DiscountTypeId

Lookup

None

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Discount List

Unique identifier of the discount list associated with the price list.

exchangerate

ExchangeRate

Decimal

None

False

True

False

True

False

False

False

False

True

True

False

False

False

False

True

Exchange Rate

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

importsequencenumber

ImportSequenceNumber

Integer

None

False

True

True

True

False

False

False

False

True

True

False

False

False

False

True

Import Sequence Number

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

modifiedby

ModifiedBy

Lookup

None

False

False

False

True

False

False

False

False

False

True

False

False

False

False

True

Modified By

Unique identifier of the user who last modified the price list.

modifiedon

ModifiedOn

DateTime

None

False

False

False

True

False

False

False

False

False

True

False

False

False

False

True

Modified On

Date and time when the price list was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Lookup

None

False

True

False

True

False

False

False

False

False

True

False

False

False

False

True

Modified By (Delegate)

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

organizationid

OrganizationId

Uniqueidentifier

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 price list.

overriddencreatedon

OverriddenCreatedOn

DateTime

None

False

True

True

True

False

False

False

False

True

True

False

False

False

False

True

Record Created On

Date and time that the record was migrated.

percentage

Percentage

Decimal

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Percentage

Percentage for the price list.

pricelevelid

PriceLevelId

Lookup

SystemRequired

False

True

True

True

False

False

False

False

True

True

False

False

False

False

True

Price List

Unique identifier of the price level associated with this price list.

pricingmethodcode

PricingMethodCode

Picklist

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Pricing Method

Pricing method applied to the price list.

productid

ProductId

Lookup

SystemRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Product

Product associated with the price list.

productpricelevelid

ProductPriceLevelId

Uniqueidentifier

SystemRequired

False

False

True

True

False

False

False

False

False

True

True

False

False

False

False

Product Price List

Unique identifier of the price list.

quantitysellingcode

QuantitySellingCode

Picklist

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Quantity Selling Option

Quantity of the product that must be sold for a given price level.

roundingoptionamount

RoundingOptionAmount

Money

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Rounding Amount

Rounding option amount for the price list.

roundingoptionamount_base

RoundingOptionAmount_Base

Money

None

False

True

False

True

False

False

False

False

True

True

False

False

False

False

True

Rounding Amount (Base)

Base currency equivalent of the rounding option amount for the price list.

roundingoptioncode

RoundingOptionCode

Picklist

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Rounding Option

Option for rounding the price list.

roundingpolicycode

RoundingPolicyCode

Picklist

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Rounding Policy

Policy for rounding the price list.

transactioncurrencyid

TransactionCurrencyId

Lookup

None

False

True

False

True

False

False

False

False

True

True

False

False

False

False

True

Currency

Unique identifier of the currency associated with the product price level.

uomid

UoMId

Lookup

ApplicationRequired

False

True

True

True

True

False

False

False

True

True

False

False

False

False

True

Unit

Unique identifier of the unit for the price list.

uomscheduleid

UoMScheduleId

Lookup

None

False

True

True

True

True

False

False

False

True

True

False

False

False

False

False

Unit Schedule ID

Unique identifier of the unit schedule for the price list.

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 price list.

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the product price level (price list item) entity.

Relationship schema name Referencing entity

ProductPriceLevel_AsyncOperations

asyncoperation

ProductPriceLevel_BulkDeleteFailures

bulkdeletefailure

ProductPriceLevel_ProcessSessions

processsession

userentityinstancedata_productpricelevel

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the product price level (price list item) entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the product price level (price list item) entity.

Relationship schema name Referenced entity

discount_type_product_price_levels

discounttype

price_level_product_price_levels

pricelevel

product_price_levels

product

lk_productpricelevel_modifiedonbehalfby

systemuser

lk_productpricelevelbase_createdby

systemuser

lk_productpricelevelbase_modifiedby

systemuser

lk_productpricelevel_createdonbehalfby

systemuser

transactioncurrency_productpricelevel

transactioncurrency

unit_of_measurement_product_price_levels

uom

unit_of_measure_schedule_product_price_level

uomschedule

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

ProductPriceLevel (Price List Item) Entity Messages and Methods
ProductPriceLevel (Price List Item) Entity Privileges

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