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
True
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 Choices/Options
Value
Label
Description
1
Override Price
0
Use Default
DefaultValue: 0
IsProductOverridden
Property
Value
Description
For system use only.
DisplayName
Select Product
IsValidForForm
True
IsValidForRead
True
IsValidForUpdate
False
LogicalName
isproductoverridden
RequiredLevel
None
Type
Boolean
IsProductOverridden Choices/Options
Value
Label
Description
1
Write-In
0
Existing
DefaultValue: 0
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
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 (internal purposes only)
DisplayName
Name
FormatName
Text
IsLocalizable
False
IsValidForForm
True
IsValidForRead
True
LogicalName
opportunityproductname
MaxLength
500
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 Choices/Options
Value
Label
Description
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 Choices/Options
Value
Label
Description
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 Choices/Options
Value
Label
Description
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
DisplayName
Skip Price Calculation
IsValidForForm
False
IsValidForRead
True
LogicalName
skippricecalculation
RequiredLevel
None
Type
Picklist
SkipPriceCalculation Choices/Options
Value
Label
Description
0
DoPriceCalcAlways
1
SkipPriceCalcOnCreate
2
SkipPriceCalcOnUpdate
3
SkipPriceCalcOnUpSert
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 columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
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.000000000001
Precision
12
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
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 Choices/Options
Value
Label
Description
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.