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 |
|
Handled by |
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. |
AddrElementAttribute1 |
string |
The first additional address element to support flexible address format. |
AddrElementAttribute2 |
string |
The second additional address element to support flexible address format. |
AddrElementAttribute3 |
string |
The third additional address element to support flexible address format. |
AddrElementAttribute4 |
string |
The fourth additional address element to support flexible address format. |
AddrElementAttribute5 |
string |
The fifth additional address element to support flexible address format. |
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. |
AddressLinesPhonetic |
string |
The phonetic or Kana representation of the Kanji address lines which is used in Japan. |
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. |
Building |
string |
The specific building name or number at a given address. |
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. |
FloorNumber |
string |
The specific floor number at a given address or in a particular building when the building number is provided. |
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. |
PostalPlus4Code |
string |
The four digit extension to the United States Postal ZIP code. |
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 |
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.
|
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. |