Work Order Follow-Up Activity Field Mappings (21B)
The table in this topic details field mappings for when a follow-up activity is updated in Oracle Field Service. The fields are updated in Oracle Fusion Service through Oracle Integration.
Work Order Field Mapping
The following table shows the Oracle Field Service follow-up activity field mapping to the Oracle Fusion Service work order.
|
Oracle Fusion Service Attribute |
Data Type |
Oracle Field Service Property |
Data Type |
Condition |
|---|---|---|---|---|
|
FsActivityId |
Long |
activityId |
NA |
NA |
|
FsTypeCd |
String |
activityType |
NA |
NA |
|
WoTypeId |
String |
|
NA |
NA |
|
Country |
String |
country_code |
String |
NA |
|
ContactAltPhoneNumber |
String |
customerCell |
String |
NA |
|
ContactEmail |
String |
customerEmail |
String |
NA |
|
ContactName |
String |
customerName |
String |
NA |
|
ContactPhoneNumber |
String |
customerPhone |
String |
NA |
|
ScheduledDate |
Date |
date |
String |
NA |
|
RequestedDate |
Date |
date |
String |
NA |
|
DeliveryWinEndDate |
deliveryWindowEnd |
NA |
||
|
DeliveryWinStartDate |
deliveryWindowStart |
NA |
||
|
Duration |
NA |
duration |
NA |
NA |
|
WoIntegrationStatusCd |
String |
NA |
NA |
NA |
|
LastUpdateSourceCd |
NA |
NA |
||
|
WoIntegrationCd |
NA |
NA |
||
|
WoParentId |
NA |
NA |
||
|
PostalCode |
String |
postalCode |
String |
NA |
|
WoArea |
String |
resourceId |
String |
NA |
|
FieldServiceResourceId |
resourceId |
NA |
||
|
SourceCd |
NA |
NA |
||
|
EstimatedStartDate |
startTime |
NA |
||
|
State |
String |
stateProvince |
String |
NA |
|
WoStatusCd |
String |
status |
NA |
NA |
|
Address1 |
String |
streetAddress |
String |
|
|
Address2 |
String |
streetAddress |
String |
|
|
Address3 |
String |
streetAddress |
String |
|
|
Address4 |
String |
streetAddress |
String |
|
|
City |
String |
city |
String |
NA |
|
County |
String |
NA |
String |
NA |
|
BookedDate |
DateTime |
timeOfBooking |
NA |
|
|
ScheduledTimeSlot |
String |
timeSlot |
String |
NA |
|
RequestedTimeSlot |
String |
timeSlot |
String |
NA |
|
TimezoneCode |
String |
timeZoneIANA |
String |
NA |
|
FsNote |
String |
wo_fs_note |
String |
NA |
|
SrId |
NA |
|||
|
NA |
workZone |
|||
|
PrimaryAssetId |
NA |
|||
|
IBAssetId |
NA |
|||
|
AccountPartyId |
NA |
|||
|
PartnerAccountPartyId |
NA |
|||
|
ContactPartyId |
NA |
|||
|
ContactPartySiteId |
NA |
|||
|
FsContactFlag |
NA |
|||
|
ProdGroupId |
|
NA |
||
|
WoNumber |
String |
wo_parent_number |
||
|
WoNumber |
String |
wo_number |
String |
|
|
WoId |
Long |
apptNumber |
String |