WorkOrder
Represents a work order describing field service or repair work to be performed.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the record. | |
| OwnerId | String | False |
ID of the user who owns the record. | |
| IsDeleted | Bool | True |
Indicates whether the record has been moved to the Recycle Bin. | |
| WorkOrderNumber | String | True |
WorkOrder identification number. | |
| CurrencyIsoCode | String | False |
ISO code for the currency in which the revenue amount is expressed. | |
| CreatedDate | Datetime | True |
Date and time when the record was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the record. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the record. |
| LastViewedDate | Datetime | True |
Date and time when the record was last viewed in the user interface. | |
| LastReferencedDate | Datetime | True |
Date and time when the record was last referenced. | |
| AccountId | String | False |
Account.Id |
ID of the Account associated with this record. |
| ContactId | String | False |
Contact.Id |
ID of the Contact associated with this record. |
| CaseId | String | False |
Case.Id |
ID of the Case associated with this record. |
| EntitlementId | String | False |
Entitlement.Id |
ID of the Entitlement associated with this record. |
| ServiceContractId | String | False |
ID of the ServiceContract associated with this record. | |
| AssetId | String | False |
Asset.Id |
ID of the Asset associated with this record. |
| Street | String | False |
Street address. | |
| City | String | False |
City portion of the address. | |
| State | String | False |
State or province portion of the address. | |
| PostalCode | String | False |
Postal code portion of the address. | |
| Country | String | False |
Country portion of the address. | |
| Latitude | Double | False |
Used with Longitude to specify the precise geolocation of an address. | |
| Longitude | Double | False |
Used with Latitude to specify the precise geolocation of an address. | |
| GeocodeAccuracy | String | False |
Accuracy level of the geocode for the address. | |
| Description | String | False |
Text description of the record. | |
| StartDate | Datetime | False |
Start date for the record or activity. | |
| EndDate | Datetime | False |
End date for the record or activity. | |
| Subject | String | False |
Subject or title of the activity. | |
| RootWorkOrderId | String | True |
WorkOrder.Id |
ID of the RootWorkOrder associated with this record. |
| Status | String | False |
Status of the record. | |
| Priority | String | False |
Priority level of the record. | |
| Tax | Decimal | False |
Tax amount for the record. | |
| Subtotal | Decimal | True |
Subtotal amount of the work order, before discounts and tax. | |
| TotalPrice | Decimal | True |
Total price of the work order. | |
| LineItemCount | Int | True |
Number of line items included on the work order. | |
| Pricebook2Id | String | False |
Pricebook2.Id |
ID of the Pricebook2 associated with this record. |
| Discount | Double | True |
Percentage discount from the list price. | |
| GrandTotal | Decimal | True |
Grand total amount including tax. | |
| ParentWorkOrderId | String | False |
WorkOrder.Id |
ID of the ParentWorkOrder associated with this record. |
| IsClosed | Bool | True |
Indicates whether the record is closed. | |
| IsStopped | Bool | False |
Indicates whether the record has the Stopped characteristic. | |
| StopStartDate | Datetime | True |
Date associated with StopStart. | |
| SlaStartDate | Datetime | False |
Date associated with SlaStart. | |
| SlaExitDate | Datetime | True |
Date associated with SlaExit. | |
| BusinessHoursId | String | False |
ID of the business hours associated with this record. | |
| MilestoneStatus | String | True |
Status of the Milestone. | |
| Duration | Double | False |
Field containing Duration information. | |
| DurationType | String | False |
Type classification for Duration. | |
| DurationInMinutes | Double | True |
Field containing DurationInMinutes information. | |
| ServiceAppointmentCount | Int | True |
Number of ServiceAppointment associated with this record. | |
| StatusCategory | String | True |
Field containing StatusCategory information. | |
| LocationId | String | False |
Location.Id |
ID of the Location associated with this record. |
| SystemModstamp | Datetime | True |
Date and time when the record was last modified by a user or by an automated process. | |
| LastModifiedDate | Datetime | True |
Date and time when the record was last modified. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| OwnerIdType | String |
Specifies the type of the 'OwnerId' polymorphic field to use in the statement. |
| OwnerIdExternalFieldName | String |
Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement |
| SOQL | String |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. |
| ExternalIdColumn | String |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. |
| FilterScope | String |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. |