--- schema_version: "1" id: 5eddd7b300b7db5e38e46cd70a7a293a49bfff16de4b75ee3b90f0fcce2918a2 title: OpportunityLineItemSchedule collection: legacydeveloper version: current locale: en-us portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/object_reference/sforce_api_objects_opportunitylineitemschedule.md canonical_url: https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_opportunitylineitemschedule.htm source_site: developer.salesforce.com content_type: documentation content_hash: ee0e0ae4f80d9571c3f537688c9c47a097d87b52e9b104160146713ea159fa4c description: Represents information about the quantity, revenue distribution, and delivery dates for a particular OpportunityLineItem. --- # OpportunityLineItemSchedule Represents information about the quantity, revenue distribution, and delivery dates for a particular OpportunityLineItem. In API version 38.0 and later, when an OpportunityLineItem record is created for a product with a previously established schedule, an OpportunityLineItemSchedule record is also created. In API version 46.0 and later, this object supports custom fields, validation rules, and Apex triggers. Deleting a schedule now also invokes delete triggers. If customizable product schedules are enabled, you can use custom fields in default schedules and customize their layout. But if you’ve applied validation rules or Apex triggers, they’re bypassed when they’re first inserted. ## Supported Calls create(), delete(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), update(), upsert() ## Fields | Field | Details | | --- | --- | | CurrencyIsoCode | Type picklist Properties Create, Defaulted on create, Filter, Nillable, Restricted picklist, Update Description Available only for organizations with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization. This field is available in version 10.0 and later. | | Description | Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Text description of the opportunity line item schedule. Limit: 80 characters. Label is **Comments**. | | OpportunityLineItemId | Type reference Properties Create, Filter Description Required. ID of the associated OpportunityLineItem. | | Quantity | Type double Properties Create, Filter, Nillable, Sort, Update Description Required. The total number of units to be scheduled in a quantity schedule. | | Revenue | Type currency Properties Create, Filter, Nillable, Sort, Update Description The revenue that should be recognized, or the quantity that should be shipped, or both - depending upon the value of Type. | | ScheduleDate | Type date Properties Create, Filter, Group, Sort, Update Description Required. The date the associated OpportunityLineItem is to be scheduled for an event: delivery, shipping, or any other date you wish to track. | | Type | Type picklist Properties Create, Filter, Group, Restricted picklist, Sort Description The type of the schedule. Required when inserting an OpportunityLineItemSchedule. Valid values include Quantity, Revenue, or Both. | ## Allowed Type Field Values The allowed Type values for an OpportunityLineItemSchedule depend on the product-level schedule preferences and whether the line item has any existing schedules. The following criteria must be met: - The Product2 on which the OpportunityLineItem is based must have the appropriate CanUseRevenueSchedule or CanUseQuantitySchedule fields (or both) set to true. - When you create a schedule for a line item that does not have any existing schedules, you can specify any valid value. - If you create a schedule for a line item that already has existing schedules, the new schedule must be consistent with the existing schedules. The following matrix outlines the allowable values: | Value of HasRevenueSchedule on line item | Value of HasQuantitySchedule on line item | Allowable Type Values | | --- | --- | --- | | false | false | Revenue, Quantity, both | | false | true | Quantity | | true | false | Revenue | | true | true | both | ## Allowed Quantity and Revenue Field Values The allowable Quantity and Revenue field values depend on the value of the Type field: | Type Value | Allowable Quantity Value | Allowable Revenue Value | | --- | --- | --- | | Revenue | Null | Non-null | | Quantity | Non-null | Null | | both | Non-null | Non-null | The Quantity and Revenue fields have the following restrictions when this object is updated: - For a schedule of Type Quantity, you can’t update a null Revenue value to non-null. Likewise for a schedule of Type Revenue, you can’t update a null Quantity value to non-null. - You can’t null out the Quantity field for a schedule of Type Quantity. Likewise you can’t null out the Revenue field for a schedule of Type Revenue. - You can’t null out either the Revenue or Quantity fields for a schedule of type Both. ## Usage OpportunityLineItemSchedule supports two types of schedules: - Quantity schedules - Revenue schedules The user must have edit access rights on the Opportunity in order to create or update line item schedules on that opportunity. ## Products and Schedules Must Be Enabled The OpportunityLineItemSchedule object is defined only for those organizations that have the products and schedules features enabled. If the organization does not have the products and schedules features, the OpportunityLineItemSchedule object is not returned in a describe, and you can't describe or query OpportunityLineItemSchedule records. ## Effects on Opportunities and Opportunity Line Items OpportunityLineItemSchedule records affect opportunities and opportunity line items in the following ways: - Inserting an OpportunityLineItemSchedule of Type “Revenue” or “Quantity” increments the TotalPrice field on the OpportunityLineItem by the OpportunityLineItemSchedule Revenue amount. Inserting an OpportunityLineItemSchedule of Type Quantity or Both increments the Quantity field on the OpportunityLineItem by the OpportunityLineItemSchedule Quantity amount. - Creating an OpportunityLineItemSchedule record affects the original opportunity: 1. The Opportunity Amount is incremented the by OpportunityLineItemSchedule revenue amount 2. The Opportunity ExpectedRevenue is incremented by the line item schedule amount multiplied by the Opportunity Probability - Deleting an OpportunityLineItemSchedule has a similar effect on the related OpportunityLineItemand Opportunity. Deleting an OpportunityLineItemSchedule decrements the OpportunityLineItem TotalPrice by the deleted OpportunityLineItemSchedule Quantity or Revenue amount. The Opportunity Amount is also decremented by the OpportunityLineItemSchedule Quantity or Revenue amount, and the Opportunity ExpectedRevenue is reduced by OpportunityLineItemSchedule Quantity or Revenue amount multiplied by the Opportunity Probability. ## Deleting an Opportunity Line Item Schedule Deleting the last remaining schedule will set the corresponding HasQuantitySchedule or HasRevenueSchedule flags (or both) to false on the parent line item. #### See Also - [OpportunityLineItem](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_opportunitylineitem.htm "Represents an opportunity line item, which is a member of the list of Product2 products associated with an Opportunity.") - [Product2](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_product2.htm "Represents a product that your company sells.")