JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462