OpportunityProduct Entity Reference
Association between an opportunity and a product.
Added by: Sales Solution
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| CalculatePrice | CalculatePrice Action | CalculatePriceRequest |
| Create | POST [org URI]/api/data/v9.0/opportunityproducts See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/opportunityproducts(opportunityproductid) See Delete |
DeleteRequest or Delete |
| Retrieve | GET [org URI]/api/data/v9.0/opportunityproducts(opportunityproductid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/opportunityproducts See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/opportunityproducts(opportunityproductid) See Update |
UpdateRequest or Update |
Entity Properties
| Property | Value |
|---|---|
| CollectionSchemaName | OpportunityProducts |
| DisplayCollectionName | Opportunity Lines |
| DisplayName | Opportunity Line |
| EntitySetName | opportunityproducts |
| IsBPFEntity | False |
| LogicalCollectionName | opportunityproducts |
| LogicalName | opportunityproduct |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | opportunityproductid |
| PrimaryNameAttribute | opportunityproductname |
| SchemaName | OpportunityProduct |
Writable attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BaseAmount
- Description
- EntityImage
- ExtendedAmount
- ImportSequenceNumber
- IsPriceOverridden
- IsProductOverridden
- LineItemNumber
- ManualDiscountAmount
- msdyn_BillingMethod
- msdyn_BudgetAmount
- msdyn_CostAmount
- msdyn_CostPricePerUnit
- msdyn_Duration
- msdyn_enddate
- msdyn_LineType
- msdyn_pricelist
- msdyn_Project
- msdyn_serviceaccount
- msdyn_startdate
- OpportunityId
- OpportunityProductId
- OpportunityProductName
- OverriddenCreatedOn
- ParentBundleId
- ParentBundleIdRef
- PricePerUnit
- PricingErrorCode
- ProductAssociationId
- ProductDescription
- ProductId
- ProductName
- ProductTypeCode
- PropertyConfigurationStatus
- Quantity
- SequenceNumber
- SkipPriceCalculation
- Tax
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UoMId
- UTCConversionTimeZoneCode
BaseAmount
| Property | Value |
|---|---|
| Description | Shows the total price of the opportunity product, based on the price per unit, volume discount, and quantity. |
| DisplayName | Amount |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | baseamount |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
Description
| Property | Value |
|---|---|
| Description | Type additional information to describe the opportunity product, such as manufacturing details. |
| DisplayName | Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
EntityImage
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | The default image for the entity. |
| DisplayName | Entity Image |
| IsPrimaryImage | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage |
| MaxHeight | 144 |
| MaxWidth | 144 |
| RequiredLevel | None |
| Type | Image |
ExtendedAmount
| Property | Value |
|---|---|
| Description | Shows the total amount due for the opportunity product, calculated on the Amount value minus the Manual Discount amount. |
| DisplayName | Extended Amount |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | extendedamount |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
IsPriceOverridden
| Property | Value |
|---|---|
| Description | Select whether the pricing on the opportunity product reflects an override of the product catalog pricing. |
| DisplayName | Price Overridden |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ispriceoverridden |
| RequiredLevel | None |
| Type | Boolean |
IsPriceOverridden Options
| Value | Label |
|---|---|
| 1 | Override Price |
| 0 | Use Default |
DefaultValue: False
IsProductOverridden
| Property | Value |
|---|---|
| Description | For system use only. |
| DisplayName | Select Product |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | isproductoverridden |
| RequiredLevel | None |
| Type | Boolean |
IsProductOverridden Options
| Value | Label |
|---|---|
| 1 | Write-In |
| 0 | Existing |
DefaultValue: False
LineItemNumber
| Property | Value |
|---|---|
| Description | Type the line item number for the opportunity product to easily identify the product in the opportunity documents and make sure it's listed in the correct order. |
| DisplayName | Line Item Number |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lineitemnumber |
| MaxValue | 1000000000 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
ManualDiscountAmount
| Property | Value |
|---|---|
| Description | Type the manual discount amount for the opportunity product to deduct any negotiated or other savings from the product total. |
| DisplayName | Manual Discount Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | manualdiscountamount |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_BillingMethod
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Billing method for the project opportunity line. Valid values are Time and Material and Fixed Price |
| DisplayName | Billing Method |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_billingmethod |
| RequiredLevel | Recommended |
| Type | Picklist |
msdyn_BillingMethod Options
| Value | Label |
|---|---|
| 192350000 | Time and Material |
| 192350001 | Fixed Price |
msdyn_BudgetAmount
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Enter the customer budget amount for this opportunity line. |
| DisplayName | Budget Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_budgetamount |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_CostAmount
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Shows the total cost price of the product based on the cost price per unit and quantity. |
| DisplayName | Cost Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costamount |
| MaxValue | 922337203685477 |
| MinValue | 0 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_CostPricePerUnit
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Cost price per unit of the product. The default is the cost price of the product. |
| DisplayName | Cost Price Per Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costpriceperunit |
| MaxValue | 922337203685477 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
msdyn_Duration
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | Enter the duration of the agreement |
| DisplayName | Duration |
| Format | Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_duration |
| MaxValue | 2147483647 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
msdyn_enddate
Added by: Field Service Solution
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Enter the end date of the agreement |
| DisplayName | End Date |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_enddate |
| RequiredLevel | None |
| Type | DateTime |
msdyn_LineType
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | The field to distinguish the order lines to be of project service or field service |
| DisplayName | Line Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_linetype |
| RequiredLevel | None |
| Type | Picklist |
msdyn_LineType Options
| Value | Label |
|---|---|
| 690970000 | Project Service Line |
| 690970001 | Field Service Line |
msdyn_pricelist
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | Select a price list for the opportunity line |
| DisplayName | Price List |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_pricelist |
| RequiredLevel | None |
| Targets | pricelevel |
| Type | Lookup |
msdyn_Project
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select the project for this opportunity line. |
| DisplayName | Project |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_project |
| RequiredLevel | None |
| Targets | msdyn_project |
| Type | Lookup |
msdyn_serviceaccount
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | Select the service account for the opportunity line |
| DisplayName | Service Account |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_serviceaccount |
| RequiredLevel | None |
| Targets | account |
| Type | Lookup |
msdyn_startdate
Added by: Field Service Solution
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Start date of the Agreement |
| DisplayName | Start Date |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_startdate |
| RequiredLevel | None |
| Type | DateTime |
OpportunityId
| Property | Value |
|---|---|
| Description | Unique identifier of the opportunity with which the opportunity product is associated. |
| DisplayName | Opportunity |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | opportunityid |
| RequiredLevel | SystemRequired |
| Targets | opportunity |
| Type | Lookup |
OpportunityProductId
| Property | Value |
|---|---|
| Description | Unique identifier of the opportunity product. |
| DisplayName | Opportunity Product |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | opportunityproductid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
OpportunityProductName
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Opportunity Product Name. Added for 1:n Referential relationship |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | opportunityproductname |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
OverriddenCreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
ParentBundleId
| Property | Value |
|---|---|
| Description | Choose the parent bundle associated with this product |
| DisplayName | Parent Bundle |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | parentbundleid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ParentBundleIdRef
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Choose the parent bundle associated with this product |
| DisplayName | Parent bundle product |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentbundleidref |
| RequiredLevel | None |
| Targets | opportunityproduct |
| Type | Lookup |
PricePerUnit
| Property | Value |
|---|---|
| Description | Shows the price per unit of the opportunity product, based on the price list specified on the parent opportunity. |
| DisplayName | Price Per Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | priceperunit |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
PricingErrorCode
| Property | Value |
|---|---|
| Description | Select the pricing error for the opportunity product. |
| DisplayName | Pricing Error |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | pricingerrorcode |
| RequiredLevel | None |
| Type | Picklist |
PricingErrorCode Options
| Value | Label |
|---|---|
| 0 | None |
| 1 | Detail Error |
| 2 | Missing Price Level |
| 3 | Inactive Price Level |
| 4 | Missing Quantity |
| 5 | Missing Unit Price |
| 6 | Missing Product |
| 7 | Invalid Product |
| 8 | Missing Pricing Code |
| 9 | Invalid Pricing Code |
| 10 | Missing UOM |
| 11 | Product Not In Price Level |
| 12 | Missing Price Level Amount |
| 13 | Missing Price Level Percentage |
| 14 | Missing Price |
| 15 | Missing Current Cost |
| 16 | Missing Standard Cost |
| 17 | Invalid Price Level Amount |
| 18 | Invalid Price Level Percentage |
| 19 | Invalid Price |
| 20 | Invalid Current Cost |
| 21 | Invalid Standard Cost |
| 22 | Invalid Rounding Policy |
| 23 | Invalid Rounding Option |
| 24 | Invalid Rounding Amount |
| 25 | Price Calculation Error |
| 26 | Invalid Discount Type |
| 27 | Discount Type Invalid State |
| 28 | Invalid Discount |
| 29 | Invalid Quantity |
| 30 | Invalid Pricing Precision |
| 31 | Missing Product Default UOM |
| 32 | Missing Product UOM Schedule |
| 33 | Inactive Discount Type |
| 34 | Invalid Price Level Currency |
| 35 | Price Attribute Out Of Range |
| 36 | Base Currency Attribute Overflow |
| 37 | Base Currency Attribute Underflow |
| 38 | Transaction currency is not set for the product price list item |
ProductAssociationId
| Property | Value |
|---|---|
| Description | Unique identifier of the product line item association with bundle in the opportunity |
| DisplayName | Bundle Item Association |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | productassociationid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ProductDescription
| Property | Value |
|---|---|
| Description | Type a detailed product description or additional notes about the opportunity product, such as talking points or product updates, that will assist the sales team when they discuss the product with the customer. |
| DisplayName | Write-In Product |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productdescription |
| MaxLength | 500 |
| RequiredLevel | None |
| Type | String |
ProductId
| Property | Value |
|---|---|
| Description | Choose the product to include on the opportunity to link the product's pricing and other information to the opportunity. |
| DisplayName | Existing Product |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productid |
| RequiredLevel | None |
| Targets | product |
| Type | Lookup |
ProductName
| Property | Value |
|---|---|
| Description | Calculated field that will be populated by name and description of the product. |
| DisplayName | Product Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | productname |
| MaxLength | 500 |
| RequiredLevel | None |
| Type | String |
ProductTypeCode
| Property | Value |
|---|---|
| Description | Product Type |
| DisplayName | Product type |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | producttypecode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
ProductTypeCode Options
| Value | Label |
|---|---|
| 1 | Product |
| 2 | Bundle |
| 3 | Required Bundle Product |
| 4 | Optional Bundle Product |
| 5 | Project-based Service |
PropertyConfigurationStatus
| Property | Value |
|---|---|
| Description | Status of the property configuration. |
| DisplayName | Property Configuration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | propertyconfigurationstatus |
| RequiredLevel | SystemRequired |
| Type | Picklist |
PropertyConfigurationStatus Options
| Value | Label |
|---|---|
| 0 | Edit |
| 1 | Rectify |
| 2 | Not Configured |
Quantity
| Property | Value |
|---|---|
| Description | Type the amount or quantity of the product the customer would like to purchase. |
| DisplayName | Quantity |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quantity |
| MaxValue | 100000000000 |
| MinValue | -100000000000 |
| Precision | 5 |
| RequiredLevel | ApplicationRequired |
| Type | Decimal |
SequenceNumber
| Property | Value |
|---|---|
| Description | Shows the ID of the data that maintains the sequence. |
| DisplayName | Sequence Number |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
SkipPriceCalculation
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Skip price calculation. Used with bulk update and bulk insert operations. |
| DisplayName | Skip Price Calculation |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | skippricecalculation |
| RequiredLevel | None |
| Type | Picklist |
SkipPriceCalculation Options
| Value | Label |
|---|---|
| 0 | DoPriceCalcAlways |
| 1 | SkipPriceCalcOnCreate |
| 2 | SkipPriceCalcOnUpdate |
Tax
| Property | Value |
|---|---|
| Description | Type the tax amount to be applied on the opportunity product. |
| DisplayName | Tax |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | tax |
| MaxValue | 100000000000000 |
| MinValue | -100000000000000 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Targets | transactioncurrency |
| Type | Lookup |
UoMId
| Property | Value |
|---|---|
| Description | Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. |
| DisplayName | Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | uomid |
| RequiredLevel | None |
| Targets | uom |
| Type | Lookup |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
Read-only attributes
These attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- BaseAmount_Base
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- ExtendedAmount_Base
- ManualDiscountAmount_Base
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- msdyn_budgetamount_Base
- msdyn_costamount_Base
- msdyn_costpriceperunit_Base
- msdyn_pricelistName
- msdyn_ProjectName
- msdyn_serviceaccountName
- msdyn_serviceaccountYomiName
- OpportunityIdName
- OpportunityStateCode
- OwnerId
- OwnerIdName
- OwnerIdType
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PricePerUnit_Base
- ProductIdName
- Tax_Base
- TransactionCurrencyIdName
- UoMIdName
- VersionNumber
- VolumeDiscountAmount
- VolumeDiscountAmount_Base
BaseAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Amount in base currency. |
| DisplayName | Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | baseamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
EntityImage_Timestamp
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_timestamp |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
EntityImage_URL
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_url |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
EntityImageId
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ExchangeRate
Added by: Active Solution Solution
| Property | Value |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| MaxValue | 100000000000 |
| MinValue | 0.0000000001 |
| Precision | 10 |
| RequiredLevel | None |
| Type | Decimal |
ExtendedAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Extended Amount in base currency. |
| DisplayName | Extended Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | extendedamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
ManualDiscountAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Manual Discount Amount in base currency. |
| DisplayName | Manual Discount Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | manualdiscountamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who last modified the opportunityproduct. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
msdyn_budgetamount_Base
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Value of the Budget Amount in base currency. |
| DisplayName | Budget Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_budgetamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_costamount_Base
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Value of the Cost Amount in base currency. |
| DisplayName | Cost Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_costpriceperunit_Base
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Value of the Cost Price Per Unit in base currency. |
| DisplayName | Cost Price Per Unit (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costpriceperunit_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
msdyn_pricelistName
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_pricelistname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
msdyn_ProjectName
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_projectname |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
msdyn_serviceaccountName
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_serviceaccountname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
msdyn_serviceaccountYomiName
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_serviceaccountyominame |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OpportunityIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | opportunityidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OpportunityStateCode
| Property | Value |
|---|---|
| Description | Select the status of the opportunity product. |
| DisplayName | Opportunity Status |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | opportunitystatecode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
OpportunityStateCode Options
| Value | Label |
|---|
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | ApplicationRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | ApplicationRequired |
| Targets | |
| Type | Lookup |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | ApplicationRequired |
| Targets | |
| Type | Lookup |
PricePerUnit_Base
| Property | Value |
|---|---|
| Description | Value of the Price Per Unit in base currency. |
| DisplayName | Price Per Unit (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | priceperunit_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
ProductIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | productidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
Tax_Base
| Property | Value |
|---|---|
| Description | Value of the Tax in base currency. |
| DisplayName | Tax (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | tax_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
TransactionCurrencyIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | transactioncurrencyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
UoMIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | uomidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
VolumeDiscountAmount
| Property | Value |
|---|---|
| Description | Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area. |
| DisplayName | Volume Discount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | volumediscountamount |
| MaxValue | 922337203685477 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
VolumeDiscountAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Volume Discount in base currency. |
| DisplayName | Volume Discount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | volumediscountamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
One-To-Many Relationships
Listed by SchemaName.
- OpportunityProduct_SyncErrors
- OpportunityProduct_AsyncOperations
- opportunityproduct_MailboxTrackingFolders
- OpportunityProduct_ProcessSessions
- OpportunityProduct_BulkDeleteFailures
- opportunityproduct_principalobjectattributeaccess
- opportunityproduct_parent_opportunityproduct
- OpportunityProduct_Dynamicpropertyinstance
- opportunityproduct_parentref_opportunityproduct
OpportunityProduct_SyncErrors
Added by: System Solution Solution
Same as syncerror entity OpportunityProduct_SyncErrors Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | OpportunityProduct_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
OpportunityProduct_AsyncOperations
Added by: System Solution Solution
Same as asyncoperation entity OpportunityProduct_AsyncOperations Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | OpportunityProduct_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
opportunityproduct_MailboxTrackingFolders
Added by: System Solution Solution
Same as mailboxtrackingfolder entity opportunityproduct_MailboxTrackingFolders Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | opportunityproduct_MailboxTrackingFolders |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
OpportunityProduct_ProcessSessions
Added by: System Solution Solution
Same as processsession entity OpportunityProduct_ProcessSessions Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | OpportunityProduct_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
OpportunityProduct_BulkDeleteFailures
Added by: System Solution Solution
Same as bulkdeletefailure entity OpportunityProduct_BulkDeleteFailures Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | OpportunityProduct_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
opportunityproduct_principalobjectattributeaccess
Added by: System Solution Solution
Same as principalobjectattributeaccess entity opportunityproduct_principalobjectattributeaccess Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | opportunityproduct_principalobjectattributeaccess |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
opportunityproduct_parent_opportunityproduct
Same as opportunityproduct entity opportunityproduct_parent_opportunityproduct Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | opportunityproduct |
| ReferencingAttribute | parentbundleid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | opportunityproduct_parent_opportunityproduct |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
OpportunityProduct_Dynamicpropertyinstance
Same as dynamicpropertyinstance entity OpportunityProduct_Dynamicpropertyinstance Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | dynamicpropertyinstance |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | OpportunityProduct_Dynamicpropertyinstance |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: Cascade Unshare: NoCascade |
opportunityproduct_parentref_opportunityproduct
Added by: Sales Patch Solution
Same as opportunityproduct entity opportunityproduct_parentref_opportunityproduct Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | opportunityproduct |
| ReferencingAttribute | parentbundleidref |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | opportunityproduct_parentref_opportunityproduct |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related entity. Listed by SchemaName.
- lk_opportunityproductbase_createdby
- lk_opportunityproduct_createdonbehalfby
- lk_opportunityproductbase_modifiedby
- lk_opportunityproduct_modifiedonbehalfby
- user_opportunityproduct
- team_opportunityproduct
- transactioncurrency_opportunityproduct
- product_opportunities
- opportunityproduct_parent_opportunityproduct
- opportunity_products
- productAssociation_opportunity_product
- unit_of_measurement_opportunity_products
- opportunityproduct_parentref_opportunityproduct
- msdyn_msdyn_project_opportunityproduct_Project
- msdyn_account_opportunityproduct_ServiceAccount
- msdyn_pricelevel_opportunityproduct_PriceList
lk_opportunityproductbase_createdby
Added by: System Solution Solution
See systemuser Entity lk_opportunityproductbase_createdby One-To-Many relationship.
lk_opportunityproduct_createdonbehalfby
Added by: System Solution Solution
See systemuser Entity lk_opportunityproduct_createdonbehalfby One-To-Many relationship.
lk_opportunityproductbase_modifiedby
Added by: System Solution Solution
See systemuser Entity lk_opportunityproductbase_modifiedby One-To-Many relationship.
lk_opportunityproduct_modifiedonbehalfby
Added by: System Solution Solution
See systemuser Entity lk_opportunityproduct_modifiedonbehalfby One-To-Many relationship.
user_opportunityproduct
Added by: System Solution Solution
See systemuser Entity user_opportunityproduct One-To-Many relationship.
team_opportunityproduct
Added by: System Solution Solution
See team Entity team_opportunityproduct One-To-Many relationship.
transactioncurrency_opportunityproduct
Added by: System Solution Solution
See transactioncurrency Entity transactioncurrency_opportunityproduct One-To-Many relationship.
product_opportunities
See opportunity Entity product_opportunities One-To-Many relationship.
opportunityproduct_parent_opportunityproduct
See opportunityproduct Entity opportunityproduct_parent_opportunityproduct One-To-Many relationship.
opportunity_products
Added by: Product Management Solution
See product Entity opportunity_products One-To-Many relationship.
productAssociation_opportunity_product
Added by: Product Management Solution
See productassociation Entity productAssociation_opportunity_product One-To-Many relationship.
unit_of_measurement_opportunity_products
Added by: Product Management Solution
See uom Entity unit_of_measurement_opportunity_products One-To-Many relationship.
opportunityproduct_parentref_opportunityproduct
See opportunityproduct Entity opportunityproduct_parentref_opportunityproduct One-To-Many relationship.
msdyn_msdyn_project_opportunityproduct_Project
Added by: Project Service Automation Solution
See msdyn_project Entity msdyn_msdyn_project_opportunityproduct_Project One-To-Many relationship.
msdyn_account_opportunityproduct_ServiceAccount
Added by: System Solution Solution
See account Entity msdyn_account_opportunityproduct_ServiceAccount One-To-Many relationship.
msdyn_pricelevel_opportunityproduct_PriceList
Added by: Product Management Solution
See pricelevel Entity msdyn_pricelevel_opportunityproduct_PriceList One-To-Many relationship.
See also
About the Entity Reference
Programming reference for Dynamics 365 Customer Engagement
Web API Reference
opportunityproduct EntityType
Note
Can you tell us about your documentation language preferences? Take a short survey.
The survey will take about seven minutes. No personal data is collected (privacy statement).