WorkOrderLineItem

Represents a subtask on a work order, typically in field service. This object is available in API version 36.0 and later.

Supported Calls

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

Fields

Field Name	Details
Address	Type address Properties Filter, Nillable Description The compound form of the address where the line item is completed.
AssetId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The asset associated with the work order line item. The asset is not automatically inherited from the parent work order.
City	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The city where the line item is completed. Maximum length is 40 characters.
Country	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The country where the line item is completed. Maximum length is 80 characters.
CurrencyIsoCode	Type picklist Properties Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update Description Available only for orgs with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization. The label in the user interface is Currency ISO Code.
Description	Type textarea Properties Create, Nillable, Update Description The description of the work order line item. Try to describe the steps needed to mark the line item Completed.
Discount	Type percent Properties Create, Filter, Nillable, Sort, Update Description The percent discount to apply to the line item. You can enter a number with or without the percent symbol, and you can use up to two decimal places.
Duration	Type double Properties Create, Filter, Nillable, Sort, Update Description The estimated time required to complete the line item. Specify the duration unit in the Duration Type field.
DurationType	Type picklist Properties Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update Description The unit of the duration: Minutes or Hours.
EndDate	Type dateTime Properties Create, Filter, Nillable, Sort, Update Description The date on which the line item is completed. This field is blank unless you set up an Apex trigger or quick action to populate it. For example, you can create a quick action that sets the EndDate to 365 days after the StartDate.
GeocodeAccuracy	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort, Update Description The level of accuracy of a location’s geographical coordinates compared with its physical address. Usually provided by a geocoding service based on the address’s latitude and longitude coordinates. This field is available in the API only. Note
IsClosed	Type boolean Properties Defaulted on create, Filter, Group, Sort Description Indicates whether the line item has been closed. Changing the line item’s status to Closed causes this checkbox to be selected in the user interface (sets IsClosed to true). Use this field to report on closed versus open work order line items. Tip
Latitude	Type double Properties Create, Filter, Nillable, Sort, Update Description Used with Longitude to specify the precise geolocation of the address where the line item is completed. Acceptable values are numbers between –90 and 90 with up to 15 decimal places. This field is available in the API only. Note
LineItemNumber	Type string Properties Autonumber, Defaulted on create, Filter, idLookup, Sort Description An auto-generated number that identifies the work order line item. Each work order’s line items start at 1.
ListPrice	Type currency Properties Filter, Nillable, Sort Description The price of the line item (product) as listed in its corresponding price book entry. If a price book entry isn’t specified, the list price defaults to zero.
Longitude	Type double Properties Create, Filter, Nillable, Sort, Update Description Used with Latitude to specify the precise geolocation of the address where the line item is completed. Acceptable values are numbers between –180 and 180 with up to 15 decimal places. This field is available in the API only. Note
OrderId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The order associated with the line item. For example, you may need to order replacement parts before you can complete the line item.
ParentWorkOrderLineItemId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The line item’s parent work order line item, if it has one. Create a custom report to view a line item’s child line items. Tip
PostalCode	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The postal code where the line item is completed. Maximum length is 20 characters.
PricebookEntryId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The price book entry (product) associated with the line item. The label in the user interface is Product. This field’s lookup search only returns products that are included in the work order’s price book.
Product2Id	Type reference Properties Filter, Group, Nillable, Sort Description (Read only) The product associated with the price book entry. This field is not available in the user interface. For best results, use the PricebookEntryId field in any custom code or layouts.
Quantity	Type double Properties Create, Filter, Nillable, Sort, Update Description Number of units of the line item included in the associated work order.
RootWorkOrderLineItemId	Type reference Properties Filter, Group, Nillable, Sort Description (Read only) The top-level line item in a work order line item hierarchy. Depending on where a line item lies in the hierarchy, its root could be the same as its parent. View a line item’s child line items in the Child Work Order Line Items related list. Note
ServiceTerritoryId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The service territory where the line item is completed.
StartDate	Type dateTime Properties Create, Filter, Nillable, Sort, Update Description The date on which the line item goes into effect. This field is blank unless you set up an Apex trigger or quick action to populate it. For example, you can create a quick action that sets the StartDate to the date when the Status changes to In Progress.
State	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The state where the line item is completed. Maximum length is 80 characters.
Status	Type picklist Properties Create, Defaulted on create, Filter, Group, Nillable, Sort, Update Description The status of the line item. The picklist includes the following values, which can be customized: New—Line item was created, but there hasn’t yet been any activity. In Progress—Work has begun. On Hold—Work is paused. Completed—Work is complete. Cannot Complete—Work could not be completed. Closed—All work and associated activity is complete. Canceled—Work is canceled, typically before any work began.
StatusCategory	Type picklist Properties Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort Description The category that each Status value falls into. The Status Category field has eight default values: seven values which are identical to the default Status values, and a None value for statuses without a status category. If you create custom Status values, you must indicate which category it belongs to. For example, if you create a `Waiting for Response` value, you may decide that it belongs in the `On Hold` category. The Status Category field can be useful to reference in custom apps, triggers, and validation rules. Status categories let you extend and customize the work life cycle while still maintaining a consistent work classification for tracking, reporting, and business process management.
Street	Type textarea Properties Create, Filter, Group, Nillable, Sort, Update Description The street number and name where the line item is completed.
Subject	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description A word or phrase describing the line item.
Subtotal	Type currency Properties Filter, Nillable, Sort Description (Read only) The line item’s unit price multiplied by the quantity.
TotalPrice	Type currency Properties Filter, Nillable, Sort Description Read only. The line item’s subtotal with discounts applied.
UnitPrice	Type currency Properties Create, Filter, Nillable, Sort, Update Description Initially, the unit price for a work order line item is the line item’s list price from the price book, but you can change it.
WorkOrderId	Type reference Properties Create, Filter, Group, Sort Description The line item’s parent work order. Because work order line items must be associated with a work order, this is a required field.
WorkTypeId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The work type associated with the line item. When a work type is selected, the line item automatically inherits the work type’s Duration, Duration Type, and required skills.

Usage

A work order line item is a child record of a work order. It represents a specific subtask on a work order.

For example, suppose a customer purchased a truck from you. The truck is represented as an asset in your Salesforce org. After some time, the truck needs both headlight bulbs replaced. Here’s one way that you can use work orders and work order line items to track the repair.

Create a work order named “Replace Headlight Bulbs” from the asset record detail page.
Add three work order line items to the work order: “Replace Left Headlight Bulb,” “Replace Right Headlight Bulb,” and “Test Headlights.”
Assign the work order to a technician via a queue.
As the technician completes each line item, he or she marks the item as Completed.
When all the line items are complete, the technician marks the work order as Completed.

Object Reference for Salesforce and Force.com

WorkOrderLineItem

Supported Calls

Fields

Usage