OpportunityProduct

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

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier of the opportunity product.
BaseAmount	Double	True	Subtotal for the opportunity product before discounts are applied and taxes are added.
BaseAmount_Base	Double	True	Base currency equivalent of the subtotal for the opportunity product before discounts are applied and taxes are added.
CreatedBy_Id	String	True	Unique identifier of the user who created the opportunity product.
CreatedBy_LogicalName	String	True
CreatedBy_Name	String	True
CreatedOn	Datetime	True	Date and time when the opportunity product was created.
CreatedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who created the opportunity product.
CreatedOnBehalfBy_LogicalName	String	True
CreatedOnBehalfBy_Name	String	True
Description	String	False	Description of the opportunity product.
ExchangeRate	Double	True	Exchange rate for the currency associated with the opportunity product with respect to the base currency.
ExtendedAmount	Double	True	Subtotal of the opportunity product after discounts are applied and taxes are added.
ExtendedAmount_Base	Double	True	Base currency equivalent of the subtotal of the opportunity product after discounts are applied and taxes are added.
ImportSequenceNumber	Integer	False	Unique identifier of the data import or data migration that created this record.
IsPriceOverridden	Boolean	False	Specifies whether to override product catalog pricing.
IsProductOverridden	Boolean	False	Specifies whether the product is a write-in product or an existing product.
LineItemNumber	Integer	False	Line item number for the opportunity product.
ManualDiscountAmount	Double	False	Customized discount amount for the opportunity product.
ManualDiscountAmount_Base	Double	True	Base currency equivalent of the customized discount amount for the opportunity product.
ModifiedBy_Id	String	True	Unique identifier of the user who last modified the opportunity product.
ModifiedBy_LogicalName	String	True
ModifiedBy_Name	String	True
ModifiedOn	Datetime	True	Date and time when the opportunity product was last modified.
ModifiedOnBehalfBy_Id	String	True	Unique identifier of the delegate user who last modified the opportunity product.
ModifiedOnBehalfBy_LogicalName	String	True
ModifiedOnBehalfBy_Name	String	True
OpportunityId_Id	String	False	Unique identifier of the opportunity with which the opportunity product is associated.
OpportunityId_LogicalName	String	False
OpportunityId_Name	String	False
OpportunityProductId	String	False	Unique identifier of the opportunity product.
OpportunityStateCode	String	True	Status of the opportunity product.
OverriddenCreatedOn	Datetime	False	Date and time that the record was migrated.
OwnerId_Id	String	True	Unique identifier of the user or team who owns the opportunity product.
OwnerId_LogicalName	String	True
OwnerId_Name	String	True
OwningBusinessUnit	String	True	Unique identifier of the business unit that owns the opportunity product.
OwningUser	String	True	Unique identifier of the user who owns the opportunity product.
PricePerUnit	Double	False	Price per unit for the opportunity product.
PricePerUnit_Base	Double	True	Base currency equivalent of the price per unit for the opportunity product.
PricingErrorCode	String	False	Pricing error for the opportunity product.
ProductDescription	String	False	Product description for the opportunity product.
ProductId_Id	String	False	Unique identifier of the product listed for the opportunity product.
ProductId_LogicalName	String	False
ProductId_Name	String	False
Quantity	Double	False	Product quantity specified for the opportunity product.
Tax	Double	False	Tax amount for the opportunity product.
Tax_Base	Double	True	Base currency equivalent of the tax amount for the opportunity product.
TimeZoneRuleVersionNumber	Integer	False	For internal use only.
TransactionCurrencyId_Id	String	True	Unique identifier of the currency associated with the opportunity product.
TransactionCurrencyId_LogicalName	String	True
TransactionCurrencyId_Name	String	True
UoMId_Id	String	False	Unique identifier of the unit that is associated with the opportunity product.
UoMId_LogicalName	String	False
UoMId_Name	String	False
UTCConversionTimeZoneCode	Integer	False	Time zone code that was in use when the record was created.
VolumeDiscountAmount	Double	True	Volume discount amount for the opportunity product.
VolumeDiscountAmount_Base	Double	True	Base currency equivalent of the volume discount amount for the opportunity product.

Tableau Connector for Microsoft Dynamics CRM

OpportunityProduct

Columns