JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

PriceLevel

This is a table representing the PriceLevel entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the price list.

BeginDate Datetime False

Date on which the price list becomes effective.

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 pricelevel.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of the price list.

EndDate Datetime False

Date that is the last day the price list is valid.

ExchangeRate Double True

FreightTermsCode String False

Freight terms for the price list.

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 pricelevel.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the price list.

OrganizationId_Id String True

Unique identifier of the organization associated with the price list.

OrganizationId_LogicalName String True

OrganizationId_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

PaymentMethodCode String False

Payment terms to use with the price list.

PriceLevelId String False

Unique identifier of the price list.

ShippingMethodCode String False

Method of shipment for products in the price list.

StateCode String True

Status of the price list.

StatusCode String False

Reason for the status of the price list.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the price level.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

Time zone code that was in use when the record was created.

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