Work Order

An order received from a customer to perform some work. For example, install cable or fix an air conditioner.

QName: {http://xmlns.oracle.com/apps/crm/service/fieldservice/workOrderService/}WorkOrder

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type	Object or Service
Contains	Work Order Part
Handled by	Work Order Service

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
AccountPartyId	long	Account party identifier.
AccountPartyName	string	Account party name.
ActualEndDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The actual end date and time of the work completed at the customer location.
ActualStartDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The actual start date and time of the work at the customer location.
Address1	string	Work order specific address line 1, where the service will be performed.
Address2	string	Work order specific address line 2, where the service will be performed.
Address3	string	Work order specific address line 3, where the service will be performed.
Address4	string	Work order specific address line 4, where the service will be performed.
AssigneeEmail	string	The assignee resource email associated to the work order.
AssigneePersonName	string	The assignee resource name associated to the work order.
AssigneePhoneNumber	string	The assignee resource phone number associated to the work order.
AssigneeResourceId	long	The assignee resource ID associated to the work order.
BookedDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The booked date of the scheduled date and time slot of the work order.
CancelReason	string	A brief description of the reason for cancelling the work order.
CaseNote	string	A note field to contain any useful information which pertains to the work order as entered by service agents.
City	string	Work order specific city where the service will be performed.
ContactAltPhoneNumber	string	Work order specific alternate phone number of the customer contact.
ContactEmail	string	Work order specific email for the customer contact.
ContactName	string	Work order specific contact name of the customer.
ContactPartyFirstName	string	Contact party first name.
ContactPartyId	long	Contact party identifier.
ContactPartyLastName	string	Contact party last name.
ContactPhoneNumber	string	Work order specific phone number of the customer contact.
Country	string	Work order specific country where the service will be performed.
County	string	Work order specific county where the service will be performed.
CreatedBy	string	Who column: indicates the user who created the row.
CreationDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Who column: indicates the date and time of the creation of the row.
DeliveryWinEndDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	An estimated delivery window end time for the pending work.
DeliveryWinStartDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	An estimated delivery window start time for the pending work.
Duration	int	The manual duration value documenting the expected time to complete the work order.
EstimatedArrivalTime	string	An estimated arrival time window of the field service technician for the pending work.
EstimatedStartDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The estimated expected time of arrival of the field service tech at the customer location.
FieldServiceResourceId	long	The field service resource ID who is assigned to complete the work order.
FormattedAddress	string	Work order-specific formatted address which contains all pertinent information about where the service will be performed.
FsActivityId	long	The integration activity identifier of the work order, used for data synchronization.
FsContactFlag	boolean	Indicates whether the contact came from OFSC into Fusion.
FsErrorDetail	string	Field Service integration error message. Not exposed in the user interface.
FsNote	string	A note field to contain any useful information which pertains to the work order dispatch or scheduling comments.
FsResource	string	The resource being used to complete this work order.
FsResourceExternalId	string	The external ID of the resource being used to complete this work order.
FsTypeCd	string	The work order type. Corresponds to the activity type in OFSC.
IBAssetActiveFlag	boolean	Flag indicating the installed base asset feature is active or inactive.
IBAssetDescription	string	The description of the installed base asset attached to the work order.
IBAssetEndDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The end date of the installed base asset attached to the work order.
IBAssetId	long	The ID of the installed base asset attached to the work order.
IBAssetInstalledDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The install date of the installed base asset attached to the work order.
IBAssetItemDescription	string	The product description of the installed base asset attached to the work order.
IBAssetItemNumber	string	The product number of the installed base asset attached to the work order.
IBAssetNumber	string	The number of the installed base asset attached to the work order.
IBAssetPurchaseDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The purchase date of the installed base asset attached to the work order.
IBAssetQuantity	{http://xmlns.oracle.com/adf/svc/types/}MeasureType	The quantity of the installed base asset attached to the work order.
IBAssetSerialNumber	string	The serial number of the installed base asset attached to the work order.
IBAssetStartDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The start date of the installed base asset attached to the work order.
IBAssetStatusCode	string	The status of the installed base asset attached to the work order.
IBAssetTag	string	The tag of the installed base asset attached to the work order.
IBAssetUOMCode	string	The unit of measure for the quantity of the installed base asset attached to the work order.
LastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	string	Who column: indicates the session login associated to the user who last updated the row.
LastUpdateSourceCd	string	Source code that indicates how the work order was last updated such as AGENT_UI, OFSC or API.
LastUpdatedBy	string	Who column: indicates the user who last updated the row.
ObjectVersionNumber	int	Object version number.
OpportunityId	long	Opportunity identifier.
OverridePartyId	long	Override party identifier.
OverridePartyName	string	Override party name.
OverrideReason	string	A brief description of the reason for requesting an override on the time slot scheduled.
OverrideStatusCd	string	Lookup code used to indicate the status of an override request having lookup type ORA_SVC_WO_OVERRIDE_CD.
OwnerTypeCd	string	The owner type code associated to the account for the work order.
PartnerAccountName	string	The partner account name of the partner associated to the work order.
PartnerAccountPartyId	long	The partner account party id associated to the work order.
PostalCode	string	Work order specific postal code where the service will be performed.
PrimaryAssetDescription	string	The description field of the asset.
PrimaryAssetEndDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	Indicates the date till which the entity is active. The date is inclusive and the status of an entity is dependent on the active date.
PrimaryAssetId	long	The unique identifier of the asset.
PrimaryAssetInstallDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date the asset was installed.
PrimaryAssetName	string	The name that describes the asset.
PrimaryAssetNumber	string	The number that identifies the asset.
PrimaryAssetProduct	string	The product associated to the primary asset for the work order.
PrimaryAssetPurchaseDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date the asset was purchased.
PrimaryAssetQuantity	{http://xmlns.oracle.com/adf/svc/types/}MeasureType	The quantity purchased.
PrimaryAssetSerialNumber	string	The asset's serial number.
PrimaryAssetStartDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	Indicates the date from which this entity is active. The date is inclusive and the status of an entity is dependent on the active date.
PrimaryAssetStatusCode	string	The pre-defined code used to indicate the status.
PrimaryAssetTag	string	The tag number associated with the asset.
PrimaryAssetUOMCode	string	The unit of measure.
Province	string	Work order specific province where the service will be performed.
ReminderTime	int	A time in minutes before the scheduled time slot when a reminder will be given to the field service tech in OFSC.
RequestedDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The requested date of the work order, no time component.
RequestedTime	string	The combined requested date and time slot of the work order.
RequestedTimeSlot	string	The requested time slot for the work order.
RequirementLine	Work Order Part	Parts for an order received from a customer to perform some work.
RescheduleReason	string	A brief description of the reason for rescheduling the work order time slot.
ResolutionDueDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The resolution due date based on customers service level agreement (SLA).
ResolutionDueDateLocal	string	The resolution due date of a service level agreement (SLA) from the time zone of the work order.
ScheduledDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The scheduled date of the work order, no time component.
ScheduledTime	string	The combined scheduled date and time slot of the work order.
ScheduledTimeSlot	string	The scheduled time slot for the work order.
SourceCd	string	Source of the work order. A list of accepted values is defined in the lookup type ORA_SVC_SOURCE_CD.
SrId	long	Service request identifier.
SrNumber	string	The unique number that is used to identify the parent service request of the work order.
State	string	Work order specific state where the service will be performed.
TimezoneCode	string	The time zone code of the work order specific address where the service will be performed.
Title	string	A brief title of the work order.
TravelTime	int	The time in minutes the field service agent.
WoArea	string	The work order location of the customer.
WoId	long	Work order identifier. Primary Key
WoIntegrationCd	string	Work order integration code to represent the current integration state of the work order.
WoIntegrationMsgCd	string	Work order integration message code used to show user-friendly error messages and provide information to fix the issue.
WoIntegrationStatusCd	string	Work order integration status to represent the state of the work order in the work order life cycle.
WoNumber	string	Autogenerated unique number with configurable format.
WoRecordType	string	The type of the work order such as regular, multiday work order, or multiday work order segment.
WoStatusCd	string	Lookup code indicating the current life-cycle status of the work order having configurable values with lookup type ORA_SVC_WO_STATUS_CD.
WoTypeId	long	Work order type identifier.