Price List Item (ProductPriceLevel) table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Information about how to price a product in the specified price level, including pricing method, rounding option, and discount type based on a specified product unit.

Added by: Product Management Solution

Messages

Message	Web API Operation	SDK class or method
Create	POST /productpricelevels See Create	CreateRequest or Create
Delete	DELETE /productpricelevels(productpricelevelid) See Delete	DeleteRequest or Delete
Retrieve	GET /productpricelevels(productpricelevelid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET /productpricelevels See Query Data	RetrieveMultipleRequest or RetrieveMultiple
Update	PATCH /productpricelevels(productpricelevelid) See Update	UpdateRequest or Update

Properties

Property	Value
CollectionSchemaName	ProductPriceLevels
DisplayCollectionName	Price List Items
DisplayName	Price List Item
EntitySetName	productpricelevels
IsBPFEntity	False
LogicalCollectionName	productpricelevels
LogicalName	productpricelevel
OwnershipType	None
PrimaryIdAttribute	productpricelevelid
PrimaryNameAttribute	productidname
SchemaName	ProductPriceLevel

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• Amount
• DiscountTypeId
• ImportSequenceNumber
• OverriddenCreatedOn
• Percentage
• PriceLevelId
• PricingMethodCode
• ProcessId
• ProductId
• ProductPriceLevelId
• QuantitySellingCode
• RoundingOptionAmount
• RoundingOptionCode
• RoundingPolicyCode
• StageId
• TimeZoneRuleVersionNumber
• TransactionCurrencyId
• TraversedPath
• UoMId
• UoMScheduleId
• UTCConversionTimeZoneCode

Amount

Property	Value
Description	Monetary amount for the price list.
DisplayName	Amount
IsValidForForm	False
IsValidForRead	True
LogicalName	amount
MaxValue	100000000000000
MinValue	0
Precision	2
PrecisionSource	1
RequiredLevel	ApplicationRequired
Type	Money

DiscountTypeId

Added by: Sales Solution

Property	Value
Description	Unique identifier of the discount list associated with the price list.
DisplayName	Discount List
IsValidForForm	False
IsValidForRead	True
LogicalName	discounttypeid
RequiredLevel	None
Targets	discounttype
Type	Lookup

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
Format	None
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importsequencenumber
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

OverriddenCreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time that the record was migrated.
DisplayName	Record Created On
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime

Percentage

Property	Value
Description	Percentage for the price list.
DisplayName	Percentage
IsValidForForm	False
IsValidForRead	True
LogicalName	percentage
MaxValue	1000000000
MinValue	0
Precision	2
RequiredLevel	ApplicationRequired
Type	Decimal

PriceLevelId

Property	Value
Description	Unique identifier of the price level associated with this price list.
DisplayName	Price List
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	pricelevelid
RequiredLevel	SystemRequired
Targets	pricelevel
Type	Lookup

PricingMethodCode

Property	Value
Description	Pricing method applied to the price list.
DisplayName	Pricing Method
IsValidForForm	False
IsValidForRead	True
LogicalName	pricingmethodcode
RequiredLevel	ApplicationRequired
Type	Picklist

PricingMethodCode Choices/Options

Value	Label	Description
1	Currency Amount
2	Percent of List
3	Percent Markup - Current Cost
4	Percent Margin - Current Cost
5	Percent Markup - Standard Cost
6	Percent Margin - Standard Cost

ProcessId

Property	Value
Description	Contains the id of the process associated with the entity.
DisplayName	Process Id
IsValidForForm	False
IsValidForRead	True
LogicalName	processid
RequiredLevel	None
Type	Uniqueidentifier

ProductId

Property	Value
Description	Product associated with the price list.
DisplayName	Product
IsValidForForm	False
IsValidForRead	True
LogicalName	productid
RequiredLevel	SystemRequired
Targets	product
Type	Lookup

ProductPriceLevelId

Property	Value
Description	Unique identifier of the price list.
DisplayName	Product Price List
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	productpricelevelid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

QuantitySellingCode

Property	Value
Description	Quantity of the product that must be sold for a given price level.
DisplayName	Quantity Selling Option
IsValidForForm	False
IsValidForRead	True
LogicalName	quantitysellingcode
RequiredLevel	ApplicationRequired
Type	Picklist

QuantitySellingCode Choices/Options

Value	Label	Description
1	No Control
2	Whole
3	Whole and Fractional

RoundingOptionAmount

Property	Value
Description	Rounding option amount for the price list.
DisplayName	Rounding Amount
IsValidForForm	False
IsValidForRead	True
LogicalName	roundingoptionamount
MaxValue	100000000000000
MinValue	-100000000000000
Precision	2
PrecisionSource	1
RequiredLevel	ApplicationRequired
Type	Money

RoundingOptionCode

Property	Value
Description	Option for rounding the price list.
DisplayName	Rounding Option
IsValidForForm	False
IsValidForRead	True
LogicalName	roundingoptioncode
RequiredLevel	ApplicationRequired
Type	Picklist

RoundingOptionCode Choices/Options

Value	Label	Description
1	Ends in
2	Multiple of

RoundingPolicyCode

Property	Value
Description	Policy for rounding the price list.
DisplayName	Rounding Policy
IsValidForForm	False
IsValidForRead	True
LogicalName	roundingpolicycode
RequiredLevel	ApplicationRequired
Type	Picklist

RoundingPolicyCode Choices/Options

Value	Label	Description
1	None
2	Up
3	Down
4	To Nearest

StageId

Property	Value
Description	Contains the id of the stage where the entity is located.
DisplayName	(Deprecated) Stage Id
IsValidForForm	False
IsValidForRead	True
LogicalName	stageid
RequiredLevel	None
Type	Uniqueidentifier

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Targets	transactioncurrency
Type	Lookup

TraversedPath

Property	Value
Description	A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur.
DisplayName	(Deprecated) Traversed Path
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
MaxLength	1250
RequiredLevel	None
Type	String

UoMId

Property	Value
Description	Unique identifier of the unit for the price list.
DisplayName	Unit
IsValidForForm	False
IsValidForRead	True
LogicalName	uomid
RequiredLevel	ApplicationRequired
Targets	uom
Type	Lookup

UoMScheduleId

Property	Value
Description	Unique identifier of the unit schedule for the price list.
DisplayName	Unit Schedule ID
IsValidForForm	False
IsValidForRead	True
LogicalName	uomscheduleid
RequiredLevel	None
Targets	uomschedule
Type	Lookup

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• Amount_Base
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• DiscountTypeIdName
• ExchangeRate
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• OrganizationId
• PriceLevelIdName
• ProductIdName
• ProductNumber
• RoundingOptionAmount_Base
• TransactionCurrencyIdName
• UoMIdName
• UoMScheduleIdName
• VersionNumber

Amount_Base

Property	Value
Description	Value of the Amount in base currency.
DisplayName	Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	amount_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	1
RequiredLevel	None
Type	Money

CreatedBy

Property	Value
Description	Unique identifier of the user who created the price list.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the price list was created.
DisplayName	Created On
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime

CreatedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

DiscountTypeIdName

Added by: Sales Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	discounttypeidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

ExchangeRate

Added by: Active Solution Solution

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	exchangerate
MaxValue	100000000000
MinValue	0.000000000001
Precision	12
RequiredLevel	None
Type	Decimal

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the price list.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the price list was last modified.
DisplayName	Modified On
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime

ModifiedOnBehalfBy

Property	Value
Description	Shows who last updated the record on behalf of another user.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

OrganizationId

Property	Value
Description	Unique identifier of the organization associated with the price list.
DisplayName	Organization
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

PriceLevelIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	pricelevelidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

ProductIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	productidname
MaxLength	100
RequiredLevel	None
Type	String

ProductNumber

Property	Value
Description	User-defined product number.
DisplayName	Product ID
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	productnumber
MaxLength	100
RequiredLevel	SystemRequired
Type	String

RoundingOptionAmount_Base

Property	Value
Description	Value of the Rounding Amount in base currency.
DisplayName	Rounding Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	roundingoptionamount_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	1
RequiredLevel	None
Type	Money

TransactionCurrencyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyidname
MaxLength	100
RequiredLevel	None
Type	String

UoMIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	uomidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

UoMScheduleIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	uomscheduleidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

• price_level_product_price_levels
• product_price_levels
• unit_of_measurement_product_price_levels
• unit_of_measure_schedule_product_price_level
• discount_type_product_price_levels

price_level_product_price_levels

See the price_level_product_price_levels one-to-many relationship for the pricelevel table/entity.

product_price_levels

See the product_price_levels one-to-many relationship for the product table/entity.

unit_of_measurement_product_price_levels

See the unit_of_measurement_product_price_levels one-to-many relationship for the uom table/entity.

unit_of_measure_schedule_product_price_level

See the unit_of_measure_schedule_product_price_level one-to-many relationship for the uomschedule table/entity.

discount_type_product_price_levels

Added by: Sales Solution

See the discount_type_product_price_levels one-to-many relationship for the discounttype table/entity.

Related information

Dataverse table/entity reference
Web API Reference