OpportunityLineItem
Represents products or services associated with an opportunity, tracking pricing and quantities.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the opportunity line item. | |
| OpportunityId | String | False |
Opportunity.Id |
Reference to the opportunity associated with this line item. |
| SortOrder | Int | True |
Position of the line item in the opportunity's product list. | |
| PricebookEntryId | String | False |
Reference to the price book entry for the associated product. | |
| Quantity | Double | False |
Number of product units included in the line item. | |
| TotalPrice | Double | False |
Total price for the line item, calculated as quantity multiplied by unit price. | |
| UnitPrice | Double | False |
Actual sales price per unit for the product. | |
| ListPrice | Double | True |
Standard list price per unit from the price book. | |
| ServiceDate | Datetime | False |
Date when the product or service is scheduled for delivery or service. | |
| Description | String | False |
Description or details of the opportunity line item. | |
| CreatedDate | Datetime | True |
Date and time when the line item was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the line item. |
| LastModifiedDate | Datetime | True |
Date and time when the line item was last modified. | |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the line item. |
| SystemModstamp | Datetime | True |
System timestamp used for tracking and replication purposes. | |
| IsDeleted | Boolean | True |
Indicates whether the opportunity line item has been deleted. |