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.

JDBC Driver for Microsoft Dynamics CRM

Product

Columns