Price List (PriceLevel) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Entity that defines pricing levels.
Added by: Product Management Solution
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Create | POST /pricelevels See Create |
CreateRequest or Create |
CreateMultiple | CreateMultiple | CreateMultipleRequest |
Delete | DELETE /pricelevels(pricelevelid) See Delete |
DeleteRequest or Delete |
Retrieve | GET /pricelevels(pricelevelid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /pricelevels See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
SetState | PATCH /pricelevels(pricelevelid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /pricelevels(pricelevelid) See Update |
UpdateRequest or Update |
UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
Properties
Property | Value |
---|---|
CollectionSchemaName | PriceLevels |
DisplayCollectionName | Price Lists |
DisplayName | Price List |
EntitySetName | pricelevels |
IsBPFEntity | False |
LogicalCollectionName | pricelevels |
LogicalName | pricelevel |
OwnershipType | OrganizationOwned |
PrimaryIdAttribute | pricelevelid |
PrimaryNameAttribute | name |
SchemaName | PriceLevel |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BeginDate
- Description
- EndDate
- FreightTermsCode
- ImportSequenceNumber
- Name
- OverriddenCreatedOn
- PaymentMethodCode
- PriceLevelId
- ShippingMethodCode
- StateCode
- StatusCode
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UTCConversionTimeZoneCode
BeginDate
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date on which the price list becomes effective. |
DisplayName | Start Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | begindate |
RequiredLevel | None |
Type | DateTime |
Description
Property | Value |
---|---|
Description | Description of the price list. |
DisplayName | Description |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
EndDate
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date that is the last day the price list is valid. |
DisplayName | End Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | enddate |
RequiredLevel | None |
Type | DateTime |
FreightTermsCode
Property | Value |
---|---|
Description | Freight terms for the price list. |
DisplayName | Freight Terms |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | freighttermscode |
RequiredLevel | None |
Type | Picklist |
FreightTermsCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Default Value |
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 |
Name
Property | Value |
---|---|
Description | Name of the price list. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
PaymentMethodCode
Property | Value |
---|---|
Description | Payment terms to use with the price list. |
DisplayName | Payment Method |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | paymentmethodcode |
RequiredLevel | None |
Type | Picklist |
PaymentMethodCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Default Value |
PriceLevelId
Property | Value |
---|---|
Description | Unique identifier of the price list. |
DisplayName | Price List |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | pricelevelid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
ShippingMethodCode
Property | Value |
---|---|
Description | Method of shipment for products in the price list. |
DisplayName | Shipping Method |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | shippingmethodcode |
RequiredLevel | None |
Type | Picklist |
ShippingMethodCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Default Value |
StateCode
Property | Value |
---|---|
Description | Status of the price list. |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 100001 | Active |
1 | Inactive | 100002 | Inactive |
StatusCode
Property | Value |
---|---|
Description | Reason for the status of the price list. |
DisplayName | Status Reason |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
StatusCode Choices/Options
Value | Label | State |
---|---|---|
100001 | Active | 0 |
100002 | Inactive | 1 |
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 | Unique identifier of the currency associated with the price level. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | transactioncurrencyid |
RequiredLevel | ApplicationRequired |
Targets | transactioncurrency |
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.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- TransactionCurrencyIdName
- VersionNumber
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 record was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CreatedOnBehalfBy
Property | Value |
---|---|
Description | Unique identifier of the delegate user who created the pricelevel. |
DisplayName | Created By (Delegate) |
IsValidForForm | False |
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 |
ExchangeRate
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 record was modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Unique identifier of the delegate user who last modified the pricelevel. |
DisplayName | Modified By (Delegate) |
IsValidForForm | False |
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 for the organization |
DisplayName | Organization Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationid |
RequiredLevel | SystemRequired |
Targets | organization |
Type | Lookup |
OrganizationIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
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 |
One-To-Many Relationships
Listed by SchemaName.
- price_level_product_price_levels
- price_level_accounts
- price_level_contacts
- price_level_products
- PriceList_Campaigns
- price_level_invoices
- price_level_opportunties
- price_level_orders
- price_level_quotes
price_level_product_price_levels
Same as the price_level_product_price_levels many-to-one relationship for the productpricelevel table/entity.
Property | Value |
---|---|
ReferencingEntity | productpricelevel |
ReferencingAttribute | pricelevelid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | price_level_product_price_levels |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
price_level_accounts
Same as the price_level_accounts many-to-one relationship for the account table/entity.
Property | Value |
---|---|
ReferencingEntity | account |
ReferencingAttribute | defaultpricelevelid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | price_level_accounts |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
price_level_contacts
Same as the price_level_contacts many-to-one relationship for the contact table/entity.
Property | Value |
---|---|
ReferencingEntity | contact |
ReferencingAttribute | defaultpricelevelid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | price_level_contacts |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
price_level_products
Same as the price_level_products many-to-one relationship for the product table/entity.
Property | Value |
---|---|
ReferencingEntity | product |
ReferencingAttribute | pricelevelid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | price_level_products |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
PriceList_Campaigns
Added by: Marketing Solution
Same as the PriceList_Campaigns many-to-one relationship for the campaign table/entity.
Property | Value |
---|---|
ReferencingEntity | campaign |
ReferencingAttribute | pricelistid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | PriceList_Campaigns |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
price_level_invoices
Added by: Sales Solution
Same as the price_level_invoices many-to-one relationship for the invoice table/entity.
Property | Value |
---|---|
ReferencingEntity | invoice |
ReferencingAttribute | pricelevelid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | price_level_invoices |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
price_level_opportunties
Added by: Sales Solution
Same as the price_level_opportunties many-to-one relationship for the opportunity table/entity.
Property | Value |
---|---|
ReferencingEntity | opportunity |
ReferencingAttribute | pricelevelid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | price_level_opportunties |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
price_level_orders
Added by: Sales Solution
Same as the price_level_orders many-to-one relationship for the salesorder table/entity.
Property | Value |
---|---|
ReferencingEntity | salesorder |
ReferencingAttribute | pricelevelid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | price_level_orders |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
price_level_quotes
Added by: Sales Solution
Same as the price_level_quotes many-to-one relationship for the quote table/entity.
Property | Value |
---|---|
ReferencingEntity | quote |
ReferencingAttribute | pricelevelid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | price_level_quotes |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
See also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें