JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Product

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the product.

CreatedBy_Id String True

Unique identifier of the user who created the product.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the product was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the product.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CurrentCost Double False

Current cost for the product item. Used in price calculations.

CurrentCost_Base Double True

Base currency equivalent of the current cost for the product item.

DefaultUoMId_Id String False

Default unit for the product.

DefaultUoMId_LogicalName String False

DefaultUoMId_Name String False

DefaultUoMScheduleId_Id String False

Default unit group for the product.

DefaultUoMScheduleId_LogicalName String False

DefaultUoMScheduleId_Name String False

Description String False

Description of the product.

ExchangeRate Double True

Exchange rate for the currency associated with the product with respect to the base currency.

ImportSequenceNumber Integer False

Unique identifier of the data import or data migration that created this record.

IsKit Boolean False

Information that specifies whether the product is a kit.

IsStockItem Boolean False

Information about whether the product is a stock item.

ModifiedBy_Id String True

Unique identifier of the user who last modified the product.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the product was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the product.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the product.

OrganizationId_Id String True

Unique identifier of the organization associated with the product.

OrganizationId_LogicalName String True

OrganizationId_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

Price Double False

List price of the product.

Price_Base Double True

Base currency equivalent of the list price of the product

PriceLevelId_Id String False

Unique identifier of the price list associated with the product.

PriceLevelId_LogicalName String False

PriceLevelId_Name String False

ProductId String False

Unique identifier of the product.

ProductNumber String False

User-defined product number.

ProductTypeCode String False

Type of product.

ProductUrl String False

URL for the Web site associated with the product.

QuantityDecimal Integer False

Number of decimal places that can be used in monetary amounts for the product.

QuantityOnHand Double False

Quantity of the product in stock.

Size String False

Product size.

StandardCost Double False

Standard cost of the product.

StandardCost_Base Double True

Base currency equivalent of the standard cost of the product.

StateCode String True

Status of the product.

StatusCode String False

Reason for the status of the product.

StockVolume Double False

Stock volume of the product.

StockWeight Double False

Stock weight of the product.

SubjectId_Id String False

Unique identifier of the subject associated with the product.

SubjectId_LogicalName String False

SubjectId_Name String False

SupplierName String False

Name of the product's supplier.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the product.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

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

VendorName String False

Name of the product vendor.

VendorPartNumber String False

Part number for the vendor's product.

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