ProductPriceLevel
This is a table representing the ProductPriceLevel entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the price list. |
| Amount | Double | False |
Monetary amount for the price list. |
| Amount_Base | Double | True |
Base currency equivalent of the monetary amount for the price list. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the price list. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the price list was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the lead. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| DiscountTypeId_Id | String | False |
Unique identifier of the discount list associated with the price list. |
| DiscountTypeId_LogicalName | String | False | |
| DiscountTypeId_Name | String | False | |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the product price level with respect to the base currency. |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the price list. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the price list was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the lead. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| OrganizationId | String | True |
Unique identifier of the organization associated with the price list. |
| OverriddenCreatedOn | Datetime | False |
Date and time that the record was migrated. |
| Percentage | Double | False |
Percentage for the price list. |
| PriceLevelId_Id | String | False |
Unique identifier of the price level associated with this price list. |
| PriceLevelId_LogicalName | String | False | |
| PriceLevelId_Name | String | False | |
| PricingMethodCode | String | False |
Pricing method applied to the price list. |
| ProductId_Id | String | False |
Product associated with the price list. |
| ProductId_LogicalName | String | False | |
| ProductId_Name | String | False | |
| ProductPriceLevelId | String | False |
Unique identifier of the price list. |
| QuantitySellingCode | String | False |
Quantity of the product that must be sold for a given price level. |
| RoundingOptionAmount | Double | False |
Rounding option amount for the price list. |
| RoundingOptionAmount_Base | Double | True |
Base currency equivalent of the rounding option amount for the price list. |
| RoundingOptionCode | String | False |
Option for rounding the price list. |
| RoundingPolicyCode | String | False |
Policy for rounding the price list. |
| TransactionCurrencyId_Id | String | True |
Unique identifier of the currency associated with the product price level. |
| TransactionCurrencyId_LogicalName | String | True | |
| TransactionCurrencyId_Name | String | True | |
| UoMId_Id | String | False |
Unique identifier of the unit for the price list. |
| UoMId_LogicalName | String | False | |
| UoMId_Name | String | False | |
| UoMScheduleId_Id | String | False |
Unique identifier of the unit schedule for the price list. |
| UoMScheduleId_LogicalName | String | False | |
| UoMScheduleId_Name | String | False |