편집

다음을 통해 공유


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

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

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

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.

Dataverse table/entity reference
Web API Reference