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