ServiceMax Mappings
ServiceMax Equipment Records Mappings
The following tables contain the list of ServiceMax fields that populate the fields in the Equipment records created in Predix Essentials when you use the ServiceMax Equipment Adapter.
ServiceMax to Predix Essentials Mappings
All of these fields belong to the Predix Essentials Equipment family (ID: MI_EQUIP000).
| ServiceMax Table | ServiceMax Attribute | ServiceMax Adapter Label | Predix Essentials Field Caption | Predix Essentials Field ID | Comments |
|---|---|---|---|---|---|
| SVMXC__Installed_Product | Id | Installed product ID | Equipment ID | MI_EQUIP000_EQUIP_C | This is a Predix Essentials key field. |
| SVMXC__Installed_Product__c.SVMXC__Serial_Lot_Number__c-SVMXC__Installed_Product__c.id | Id | Installed product ID | Unique ID | MI_EQUIP000_UNIQUE_ID_C | The value of this field is populated by Predix Essentials unless you specified a Unique ID value when you create the record in ServiceMax. In this case, the value of Unique ID from ServiceMax is used. |
| SVMXC__Company__r | Name | Account Name | Site Reference Name | MI_SITE_NAME | None |
| SVMXC__Product__c | Name | Product name | Equipment Short Description | MI_EQUIP000_EQUIP_SHRT_DESC_C | None |
| SVMXC__Product__c | Description | Product description | Equipment Long Description | MI_EQUIP000_EQUIP_LNG_DESC_T | None |
| SVMXC__Site__c | Id | Location ID | Functional Location | MI_EQUIP000_FNC_LOC_C | None |
| SVMXC__Site__c | Name | Location Name | Functional Location Description | MI_EQUIP000_FNC_LOC_DESC_C | None |
| SVMXC__Installed_Product__c | SVMXC__Serial_Lot_Number__c | Installed product serial/lot # | Equipment Serial Number | MI_EQUIP000_SN_C | None |
| SVMXC__Installed_Product__c | SVMXC__Status__c | Installed product status | System Status | MI_EQUIP000_SYS_ST_C | None |
| SVMXC__Product__c | ProductCode | Product code | Equipment Type | MI_EQUIP000_OBJ_TYP_C | None |
| SVMXC__Product__c | Name | Product name | Equipment Type Description | MI_EQUIP000_OBJ_TYP_DESC_C | None |
| SVMXC__Installed_Product__c | LastModifiedDate | Last modified date | CMMS Last Changed Date | MI_EQUIP000_CHANGE_DATE | None |
| SVMXC__Installed_Product__c | CreatedDate | Creation date | CMMS Creation Date | MI_EQUIP000_CREATE_DATE | None |
| SVMXC__Installed_Product__c | SVMXC__Warranty_End_Date__c | Warranty End Date | EAM Reference Warranty Expiration Date | MI_EQUIP000_EAM_REF_WRNTY_EXPR_DT_C | The equipment warranty expiration date as specified in the source system. |
| Organization | Id | Org ID | CMMS System | MI_EQUIP000_SAP_SYSTEM_C | This is a Predix Essentials key field. |
Predix Essentials to ServiceMax Mappings
All ServiceMax fields are in the SVMXC__Installed_Product__c object.
| Predix Essentials Field ID | Predix Essentials Field Caption | ServiceMax Attribute | ServiceMax Adapter Label | Comments |
|---|---|---|---|---|
| MI_EQUIP000_MI_EQUIP000_SN_C | Equipment Serial Number | SVMXC__Serial_Lot_Number__c | Serial Lot Number | The serial number of the installed equipment as it exists in Predix Essentials. |
| MI_EQUIP000_EAM_REF_WRNTY_EXPR_DT_C | EAM Reference Warranty Expiration Date | SVMXC__Warranty_End_Date__c | Warranty End Date | The date the warranty for the equipment expires. |
| MI_EQUIP000_EQUIP_LNG_DESC_T | Equipment Long Description | SVMXC__Installation_Notes__c | Installation Notes | This is the equipment description as it exists in Predix Essentials. |
| MI_EQUIP000_EQUIP_SHRT_DESC_C | Equipment Short Description | Name | Name | The serial number of the equipment as it exists in Predix Essentials. |
| MI_EQUIP000_EQUIP_TECH_NBR_C | Equipment Technical Number | SVMXC__Asset_Tag__c | Asset Tag | The technical number assigned to the equipment as it exists in Predix Essentials. |
| MI_EQUIP000_SYS_ST_C | Equipment Status | SVMXC__Status__c | Status | The installation status for the equipment as it exists in Predix Essentials. |
| MI_EQUIP000_UNIQUE_ID_C | Unique ID | SVMXC__SM_External_ID__c | ID | This field is the unique ID of the equipment as it exists in Predix Essentials. |
| MI_EQUIP000_UNIQUE_ID_C | Unique ID of parent in the hierarchy | SVMXC__SM_External_Parent__c | Parent | This field is the ID of the parent equipment as it exists in Predix Essentials. |
| MI_EQUIP000_SAP_SYSTEM_C & "-" & MI_EQUIP000_FNC_LOC_C | Unique ID of functional location | SVMXC__SM_External_Site__c | Site | This field is the unique functional location of the equipement as it exists in Predix Essentials. For example, if this equipment is recorded in SystemB at functional location ROA3, the value would be SystemB-ROA3. |
| MI_EQUIP000_SITE_C | Site | SVMXC__SM_External_Company__c | Company | This field is the site associated with the equipment as it exists in Predix Essentials. |
| MI_EQUIP000_CONSTN_TYP_C | Construction Type | SVMXC__SM_External_Product__c | Product | This field associates the installed equipment in Predix Essentials to the product catalogue configured in ServiceMax |
ServiceMax Functional Location Mappings
The following tables contain the list of ServiceMax fields that populate the fields in the Functional Location records created in Predix Essentials when you use the ServiceMax Equipment Adapter.
ServiceMax to Predix Essentials Mappings
All of these fields belong to the Predix Essentials Functional Location family (ID: MI_FNCLOC000).
| ServiceMax Table | ServiceMax Attribute | ServiceMax Adapter Label | Predix Essentials Field ID | Predix Essentials Field Caption | Comments |
|---|---|---|---|---|---|
| SVMXC__Site__c | Id | Location ID | MI_FNCLOC00_INTERNAL_ID_C | Functional Location Internal ID | None |
| SVMXC__Site__c | Id | Location ID | MI_FNCLOC00_FNC_LOC_C | Functional Location | This is a Predix Essentials key field. |
| SVMXC__Site__c.Name-SVMXC__Site__c.id | Id | Location ID | MI_FNCLOC00_UNIQUE_ID_C | Unique ID | The value of this field is populated by Predix Essentials unless you specified a Unique ID value when you create the record in ServiceMax. In this case, the value of Unique ID from ServiceMax is used. |
| SVMXC__Company__r | Name | Account name | MI_SITE_NAME | Site Reference Name | None |
| SVMXC__Site__c | Name | Location name | MI_FNCLOC00_FNC_LOC_DESC_C | Functional Location Description | None |
| SVMXC__Site__c | Name | Location name | MI_FNCLOC00_FNC_LOC_LNG_DESC_C | Functional Location Long Description | None |
| SVMXC__Site__c | SVMXC__Location_Type__c | Location Type | MI_FNCLOC00_CATEG_C | Category | None |
| SVMXC__Site__c | SVMXC__Parent__c | Parent functional location | MI_FNCLOC00_SUPR_FNC_LOC_C | Superior Function Location | None |
| Organization | Id | Org ID | MI_FNCLOC00_SAP_SYSTEM_C | CMMS System | This is a Predix Essentials key field. |
Predix Essentials to ServiceMax Mappings
All ServiceMax fields are in the SVMXC__Site__c object.
| Predix Essentials Field ID | Predix Essentials Field Caption | ServiceMax Attribute | ServiceMax Adapter Label | Comments |
|---|---|---|---|---|
| MI_FNCLOC00_UNIQUE_ID_C | Unique ID | SVMXC__SM_External_ID__c | External ID | This is the external ID ServiceMax uses to associate a location with a funtional location in Predix Essentials. |
| MI_FNCLOC00_UNIQUE_ID_C | Unique ID of Superior Location | SVMXC__SM_External_Parent__c | External Parent ID | This is the immediate parent location of this functional location. |
| MI_FNCLOC00_SITE_C | Site | SVMXC__SM_External_Company__c | External Company Id | |
| MI_FNCLOC00_FNC_LOC_DESC_C | Functional Location Description | Name | Location name | This is the description of the functional location from Predix Essentials. |
| MI_FNCLOC00_TYPE_C | Location Type | SVMXC__Location_Type__c | Location name | The type associated with the functional location as it exists in Predix Essentials. The default value is FLOC. |
ServiceMax Work History Mappings
The following table contains the list of Predix Essentials Family ID fields in the Work History records created in Predix Essentials that are populated by the ServiceMax Work History Adapter.
| ServiceMax Object Name | ServiceMax Field ID | ServiceMax Caption | Predix Essentials Family ID | Predix Essentials Field ID | Predix Essentials Field Caption | Behavior |
|---|---|---|---|---|---|---|
| SVMXC__Service_Order__c | SVMXC__Purpose_of_Visit__c | Purpose of Visit | MI_EVWKHIST | MI_EVWKHIST_ORDR_PM_ACT_C | Activity Type | The value of this field is the reason for the service visit, for example, Repair. |
| SVMXC__Service_Order__c | SVMXC__Total_Work_Order_Cost__c | Total Work Order Amount | MI_EVWKHIST | MI_EVWKHIST_ACT_SERV_COST_N | Actual Service Cost | The value of this field is the actual cost for this service visit, for example, 100. |
| SVMXC__Service_Order__c | SVMXC__Customer_Down__c | Customer Down | MI_EVWKHIST | MI_EVWKHIST_BRKDN_IND_F | Breakdown Indicator | The value of this field indicates whether this service request was generated because the customer was disabled, for example, TRUE. |
| SVMXC__Service_Contract__r | Name | Service Contract | MI_EVWKHIST | MI_EVWKHIST_CNTRCT_NMR_C | Contract Number | The value of this field, if specified, is the service contract number associated with this request. |
| SVMXC__Service_Group__r | Name | Service Team | MI_EVWKHIST | MI_EVWKHIST_CREW_ID_C | Crew ID | This field, if specified, contains the name of the service team assigned to this request, for example, My Techs. |
|
SVMXC__Component__r, if the source record is a work order. SVMXC__Serial_Number__r, if the source record is a service request. | id | Component | MI_EVENT | MI_EVENT_ASST_ID_CHR | Equipment ID | This is a key field. This field identifies the asset associated with this service request, for example, a0N1I0000030QZl. |
| SVMXC__Service_Order__c | SVMXC__Total_Estimate__c | Total Estimate | MI_EVWKHIST | MI_EVWKHIST_EST_SERV_COST_N | Estimated Service Cost | The value of this field is the estimated cost of the service to be performed, for example, 9000. |
| SVMXC__Service_Order__c and Service_Request__r | Concatenation of WH-Service_request__r.Name and SVMXC__Service_Order__c.NAME | Work Order | MI_EVENT | MI_EVENT_ID | Event ID | This is a key field.
The value in this field identifies the work order associated with this service request For example, WH-SR-00000341-WO-00000025. If there is no service request, the field would have the format WH-WO-00000025. If there is no work order present, the field would have the format WH-SR-00000341 |
| SVMXC__Service_Order__c | SVMXC__Problem_Description__c | Problem Description | MI_EVENT | MI_EVENT_SHRT_DSC_CHR | Event Short Description | The value in this field is a brief description of the problem that generated the service request, for example, Burning smell coming from equipment. |
| SVMXC__Service_Order__c | CreatedDate | Create By | MI_EVENT | MI_EVENT_STRT_DT | Event Start Date | The value in this field is the UTC creation date and time of the service request, for example, 2018-03-27T20:16:35.000+0000. |
| SVMXC__Service_Order__c | SVMXC__Order_Status__c | Status | MI_EVWKHIST | MI_EVWKHIST_STATUS_C | Event Status | The value in this field is the current status of the service request, for example, Closed. |
| SVMXC__Service_Order__c | SVMXC__Order_Type__c | Order Type | MI_EVENT | MI_EVENT_TYP_CHR | Event Type | The value in this field is the type of service request, for example, Field Service. |
| SVMXC__Service_Order__c | SVMXC__Failure_Location__c | Failure Location | MI_EVWKHIST | MI_EVWKHIST_FAILR_MODE_CD_C | Failure Mode | The value in this field identifies the location where the failure occurred. |
| SVMXC__Service_Order__c | SVMXC__Failed_Assembly__c | Failed Assembly | MI_EVWKHIST | MI_EVWKHIST_FAILR_MODE_DESC_C | Failure Mode Description | The value in this field identifies the equipment that failed. |
| SVMXC__Service_Order__c | SVMXC__Customer_Failure_Feedback__c | Customer Failure Feedback | MI_EVWKHIST | MI_EVWKHIST_FAILURE_REM_T | Failure Remarks | This field contains pertinent information from the customer to the service technician. |
|
SVMXC__Component__r, if the source record is a work order. SVMXC__Serial_Number__r, if the source record is a service request. | SVMXC__Site__c | Location | MI_EVENT | MI_EVENT_LOC_ID_CHR | Location ID | The value in this field identifies the location of the equipment to be serviced. |
| SVMXC__Service_Order__c | CreatedDate | Create By | MI_EVWKHIST | MI_EVWKHIST_ORDR_CRT_DT_D | Order Creation Date | The value in this field is the UTC creation date and time of the work order, for example, 2018-03-27T20:16:35.000+0000. |
| SVMXC__Service_Order__c | SVMXC__Problem_Description__c | Problem Description. | MI_EVWKHIST | MI_EVWKHIST_ORDR_DESC_C | Order Description | The value in this field describes the problem addressed by this work order. |
| SVMXC__Service_Order__c | Name | Work Order | MI_EVWKHIST | MI_EVWKHIST_ORDR_ID_C | Order ID | The value in this field identifies the work order associated with this service request. |
| SVMXC__Service_Order__c | LastModifiedDate | Last Modified By | MI_EVWKHIST | MI_EVWKHIST_ORDR_CHNG_DT_D | Order Last Change Date | The value in this field is the UTC date and time the work order was updated, for example, 2018-04-01T16:46:52.000+0000. |
| SVMXC__Service_Order__c | SVMXC__Priority__c | Priority | MI_EVWKHIST | MI_EVWKHIST_ORDR_PRTY_C | Order Priority | This is the priority associated with the work order, for example, Medium. |
| SVMXC__Service_Order__c | SVMXC__Order_Type__c | Order Status | MI_EVWKHIST | MI_EVWKHIST_ORDR_SYS_STAT_C | Order System Status | The value in this field is the current status of the work order, for example, Closed. |
| SVMXC__Service_Order__c | SVMXC__Order_Type__c | Order Type | MI_EVWKHIST | MI_EVWKHIST_ORDR_TYP_CD_C | Order Type | The value in this field identifies the type of work order, for example, Field Service. |
| SVMXC__PM_Plan__r | Name | Preventive Maintenance Plan | MI_EVWKHIST | MI_EVWKHIST_PM_NBR_C | PM Number | The value in this field identifies the maintenance plan associated with this work order, for example, PM Test. |
| Service_Request__r | CreatedDate | Create By | MI_EVWKHIST | MI_EVWKHIST_RQST_CRT_DT_D | Request Creation Date | The value in this field is the UTC date and time this service request was created, for example, 2018-03-27T12:02:38.000+0000. |
| Service_Request__r | SVMXC__Subject__c and SVMXC__Problem_Description__c | Problem Description | MI_EVWKHIST | MI_EVWKHIST_RQST_DESC_C | Request Description | The value in this field identifies the problem associated with this service request, for example, Normal preventative maintenance. |
| Service_Request__r | Name | Service Request | MI_EVWKHIST | MI_EVWKHIST_RQST_ID_C | Request ID | This is a key field. The value in this field identifies the service request associated with this work order. |
| Service_Request__r | LastModifiedDate | Last Modified By | MI_EVWKHIST | MI_EVWKHIST_RQST_CHNG_DT_D | Request Last Change Date | The value in this field is the UTC date and time the service request was changed, for example, 2018-04-01T14:16:49.000+0000. |
| Service_Request__r | SVMXC__Priority__c | Priority | MI_EVWKHIST | MI_EVWKHIST_RQST_PRTY_C | Request Priority | The value in this field identifies the priority associated with this service request, for example, High. |
| Service_Request__r | SVMXC__Status__c | Status | MI_EVWKHIST | MI_EVWKHIST_RQST_SYS_STAT_C | Request System Status | The value in this field identifies the status of the service request, for example, CREATED. |
| Service_Request__r | SVMXC__Type__c | Type | MI_EVWKHIST | MI_EVWKHIST_RQST_TYP_CD_C | Request Type | The value in this field identifies the type of service request, for example, GENERAL. |
| SVMXC__Service_Order__c | SVMXC__Preferred_End_Time__c | Preferred End Time | MI_EVWKHIST | MI_EVWKHIST_TARGET_COMPL_D | Target Completion Date | The value in this field is the UTC date and time work should be completed on this service request, for example, 2018-03-31T22:57:00.000+0000. |
| SVMXC__Service_Order__c | SVMXC__Preferred_Start_Time__c | Preferred Start Time | MI_EVWKHIST | MI_EVWKHIST_TARGET_START_D | Target Start Date | The value in this field is the UTC date and time work should start on this service request, for example, 2018-04-05T22:57:00.000+0000. |
| SVMXC__Service_Order__c | SVMXC__Service_Duration__c | Service Duration | MI_EVWKHIST | MI_EVWKHIST_TIME_TO_REPR_N | Time To Repair (TTR) | The value in this field is the amount of time, in minutes, it took to complete the service, for example, 3600. |
| SVMXC__Service_Order__c | SVMXC__Total_Work_Order_Cost__c | MI_EVWKHIST | MI_EVWKHIST_TOTL_CST_N | Total Cost | The value in this field is the actual cost to perform the work identified on the work order, for example, 1000. |
ServiceMax Work History Detail Mappings
The following table contains the list of ServiceMax fields that populate the fields in the Work History Detail records created in Predix Essentials when you use the ServiceMax Work History Detail Adapter.
All of the fields belong to the Predix Essentials MI_DTWKHIST family.
| Predix Essentials Field ID | Predix Essentials Field Caption | ServiceMax Object Name | ServiceMax Field ID | ServiceMax Caption | Behavior |
|---|---|---|---|---|---|
| MI_DTWKHIST_ASST_ID_C | Equipment ID | SVMXC__Service_SVMXC__Serial_Number__r | id | Equipment ID | This is a key field. |
| MI_DTWKHIST_LOC_ID_C | Location ID | SVMXC__Service_SVMXC__Serial_Number__r | SVMXC__Site_c | Location | This is a key field. |
| MI_DTWKHIST_ORDER_ID_C | Order ID | SVMXC__Service_Order__r | Name | Work Order Number | This is a key field. |
| MI_DTWKHIST_ RQST_ID_C | Request ID | SVMXC__Service_Order_r | Service_Request__c | Service Request Number | This is a key field. |
| MI_DTWKHIST_EVNT_DTL_DESC_C | Work History Detail Description | SVMXC__Service_ Order_Line__c | See comments. | Multiple | If this field is not null, the value could be any of the following:
|
| MI_DTWKHIST_EVNT_DTL_ID_C | Work History Detail ID | SVMXC__Service_Order__c and Service_Request__r | Concatenation of WH-Service_Request__r.Name+SVMXC__Service_Order__c .NAME | Work Order | The value of this field identifies the associated work order. For example, WH-SR-00000341-WO-00000025. If there is no service request, the field has the format WH-WO-00000025. |
| MI_DTWKHIST_WRK_HISTRY_ID_C | Work History ID | SVMXC__Service_Order_Line__c, SVMXC__Service_Order__c and Service_Request__r | Concatenation of WHD-Service_Request__r.Name+SVMXC__Service_Order__c .NAME+SVMXC__Service_Order_Line__c.Name | Work Detail Number | The value in this field identifies the record that contains the details of work performed. For example, WHD-SR-00000341-WO-00000025-WL-0000123. If there is no service request, the field has the format WHD-WO-00000025-WL-0000123. |
ServiceMax Work History Estimates
Work History records contain information received from ServiceMax about the estimates of time and resources required to perform required work for an asset.
All of these fields belong to the Predix Essentials FSM Estimate family (ID: MI_FSM_EST_WHD).
| ServiceMax Field | ServiceMax Adapter Label | Predix Essentials Field ID | Predix Essentials Family Field Caption | Comments |
|---|---|---|---|---|
| Concatenation of WH-Service_Request__r.Name and SVMXC__Service_Order__c .NAME | N/A | MI_FSM_EST_WHD_EVNT_DTL_ID_C | Work History Detail ID |
This is a key field. If both service request and work order are present, this field has the format WH-SR-00000341-WO-00000025. If no service request is present, then this field has the format WH-WO-00000025. |
| Concatenation of WHD-Service_Request__r.Name and SVMXC__Service_Order__c .NAME and SVMXC__Service_Order_Line__c.Name | N/A | MI_FSM_EST_WHD_WRK_HIST_ID_C | Work History ID |
This is a key field. This field has the format WHD-SR-00000341-WO-00000025-WL-0000042. |
| Name | WO | MI_FSM_EST_WHD_ORDR_ID_C | Order ID |
This is a key field. The value of this field is the Work Order Number in ServiceMax. |
| Name | WL | MI_FSM_EST_WHD_DTL_ID_C | Detail ID | The value of this field is the Work Detail Number in ServiceMax. |
| Name | Record Type | MI_FSM_EST_WHD_REC_TP_C | Record Type | The value of this field is the Record Type in ServiceMax. |
| SVMXC__Line_Type__c | Line Type | MI_FSM_EST_WHD_DTL_TP_C | Line Type | The value of this field is the Line Type in ServiceMax. This value can be Parts, Labor, or Expenses. |
| SVMXC__Activity_Type__c | Activity Type | MI_FSM_EST_WHD_ACT_TP_C | Activity Type | The value of this field is the Activity Type in ServiceMax. The value is usually present for labor line types. |
| SVMXC__Product__c | Part | MI_FSM_EST_WHD_PART_ID_C | Part Record ID | The value of this field is the product estimated as defined in a Salesforce product record. |
| SVMXC__Estimated_Quantity2__c | Estimated Quantity | MI_FSM_EST_WHD_QTY_N | Estimated Quantity | The value of this field is the Estimated Quantity in ServiceMax. The value is context-sensitive. For example, the quantity for travel expenses would be in miles. |
| SVMXC__Use_Price_From_Pricebook__c | Use Pricebook | MI_FSM_EST_WHD_PRICEBOOK_L | Use Pricebook | The value of this field specifies whether to use the default price defined in a price book for the estimate. Valid values are TRUE or FALSE. |
| SVMXC__Estimated_Price2__c | Estimated Unit Price | MI_FSM_EST_WHD_UNIT_PRICE_N | Estimated Unit Price | The value of this field is the total estimated price for this line item, whether it is for parts, labor, or expense. |
| SVMXC__Discount__c | Discount Percentage | MI_FSM_EST_WHD_DISC_N | Discount Percentage | The value of this field is the percent discount applied to this line item. |
| SVMXC__Include_in_Quote__c | Included in Quote | MI_FSM_EST_WHD_IN_QUOTE_L | Included in Quote | The value of this field specifies whether this expense is covered by a warranty or contract. The valid values are:
|
| SVMXC__Cost_Category__c | Cost Category | MI_FSM_EST_WHD_COST_CAT_C | Cost Category | The value of this field is the Cost Category in ServiceMax that is applied to this line item. |
| SVMXC__Expense_Type__c | Expense Type | MI_FSM_EST_WHD_EXP_TP_C | Expense Type | The value of this field is the Expense Type in ServiceMax. |
| SVMXC__Start_Date_and_Time__c | Start Time | MI_FSM_EST_WHD_START_DT_D | Start Time |
The value of this field is the estimated date and time to begin the activity is this is a Labor Line Type. The value of this field has the format YYYY-MO-DDTHH:MN:SS.ttt+OOOO, where:
|
| SVMXC__End_Date_and_Time__c | End Time | MI_FSM_EST_WHD_END_DT_D | End Time |
The value of this field is the estimated date and time to end the activity is this is a Labor Line Type. The value of this field has the format YYYY-MO-DDTHH:MN:SS.ttt+OOOO, where:
|
| SVMXC__Work_Description__c | Work Description | MI_FSM_EST_WHD_DTL_DESC_TX | Work Description | This field specifies an assessment of the work or additional details about the line item. |
| SVMXC__Total_Estimated_Price__c | Total Estimated Price | MI_FSM_EST_WHD_TTL_PRICE_N | Total Estimated Price | The value of this field is the Total Estimated Price which is calculated using the values of the Estimated Quantity and Estimated Unit Price (Estimated Quantity x Estimated Unit Price). |
| Description | Record Type | MI_FSM_EST_WHD_REC_TP_DESC_C | Record Type Description | The value of this field is a description of the Record Type. |
| Name | Part Name | MI_FSM_EST_WHD_PART_NM_C | Part Name | The value of this field is the product estimated as defined in a Salesforce product record. |
| SVMXC__Line_Status__c | Line Status | MI_FSM_EST_WHD_DTL_STATUS_C | Line Status | The value of this field is the current status of this line item. |
ServiceMax Work History Request/Receipt
Work History records contain information received from ServiceMax about the work requested for an asset and any acknowledgements that the request has been received.
The following table describes the fields that belong to the Predix Essentials FSM Request/Receipt family (ID: MI_FSM_RR_WHD).
| ServiceMax Field | ServiceMax Adapter Label | Predix Essentials Field ID | Predix Essentials Family Field Caption | Comments |
|---|---|---|---|---|
| Concatenation of WH-Service_Request__r.Name and SVMXC__Service_Order__c .NAME | Work Order | MI_FSM_RR_WHD_EVNT_DTL_ID_C | Work History Detail ID |
This is a key field. If both service request and work order are present, this field has the format WH-SR-00000341-WO-00000025. If no service request is present, then this field has the format WH-WO-00000025. |
| Concatenation of WHD-Service_Request__r.Name and SVMXC__Service_Order__c .NAME and SVMXC__Service_Order_Line__c.Name | Work Detail Number | MI_FSM_RR_WHD_WRK_HIST_ID_C | Work History ID |
This is a key field. This field has the format WHD-SR-00000341-WO-00000025-WL-0000042. |
| Name | Work Order | MI_FSM_RR_WHD_ORDR_ID_C | Order ID |
This is a key field. The value of this field is the Work Order Number in ServiceMax. |
| Name | Work Line | MI_FSM_RR_WHD_DTL_ID_C | Detail ID | The value of this field is the Work Detail Number in ServiceMax. |
| Name | Record Type | MI_FSM_RR_WHD_REC_TP_C | Record Type | The value of this field is the Record Type in ServiceMax. |
| SVMXC__Product__c | Part | MI_FSM_RR_WHD_PART_ID_C | Part Record ID | The value of this field is the product requested as defined in a Salesforce product record. |
| SVMXC__Requested_Quantity2__c | Requested Quantity | MI_FSM_RR_WHD_REQ_QTY_N | Requested Quantity | The value of this field is the number of uits required for this location. |
| SVMXC__Date_Requested__c | Date Required | MI_FSM_RR_WHD_REQ_DT_D | Date Required | The value of this field is the date the part is required at this location. The format of this field is MM/DD/YYYY. |
| SVMXC__From_Location__c | From Location | MI_FSM_RR_WHD_FROM_LOC_C | From Location | The value of this field is the ID of the location from which parts are required. |
| Name | From Location Name | MI_FSM_RR_WHD_FROM_LOC_NM_C | From Location Name | The value of this field is the name of the location from which parts are required. |
| SVMXC__Requested_Location__c | To Location | MI_FSM_RR_WHD_TO_LOC_C | To Location | The value of this field is the ID of the requesting location. |
| Name | To Location Name | [MI_FSM_RR_WHD_TO_LOC_NM_C | To Location Name | The value of this field is the name of the requesting location. |
| SVMXC__Requested_Street__c | Requested Street | MI_FSM_RR_WHD_REQ_ST_C | Requested Street | The value of this field is the street address of the requesting location. |
| SVMXC__Requested_City__c | Requested City | MI_FSM_RR_WHD_REQ_CITY_C | Requested City | The value of this field is the city of the requesting location. |
| SVMXC__Requested_State__c | Requested State | MI_FSM_RR_WHD_REQ_STATE_C | Requested State | The value of this field is the state of the requesting location. |
| SVMXC__Requested_Country__c | Requested Country | MI_FSM_RR_WHD_REQ_COUNTRY_C | Requested Country | The value of this field is the country of the requesting location. |
| SVMXC__Requested_Zip__c | Requesting Zip | MI_FSM_RR_WHD_REQ_ZIP_C | Requesting Zip | The value of this field is the postal code of the requesting location. |
| SVMXC__Received_Quantity2__c | Received Quantity | MI_FSM_RR_WHD_REC_QTY_N | Received Quantity | The value of this field is the current quantity of parts received. |
| SVMXC__Date_Received__c | Date Received | MI_FSM_RR_WHD_REC_DT_D | Date Received | The value of this field is the most recent date on which parts were received. |
| Name | Part Name | MI_FSM_RR_WHD_PART_NM_C | Part Name | The value of this field is the product requested as defined in a Salesforce product record. |
| SVMXC__Line_Status__c | Line Status | MI_FSM_RR_WHD_DTL_STATUS_C | Line Status | The value of this field is the current status of this line item. |
| Description | Record Type Description | MI_FSM_RR_WHD_REC_TP_DESC_C | Record Type Description | The value of this field is an assessment of the work to be performed or additional details about this line item. |
| SVMXC__Line_Type__c | Line Type | MI_FSM_RR_WHD_DTL_TP_C | Line Type | The value of this field is the type of this line item. Valid values are Parts, Labor, or Expenses. |
ServiceMax Work History Usage/Consumption
Work History records contain information received from ServiceMax about the actual resources used to complete the work requested for an asset.
All of these fields belong to the Predix Essentials FSM Usage/Consumption family (ID: MI_FSM_USG_WHD).
| Predix Essentials Field ID | Predix Essentials Family Field Caption | ServiceMax Field | ServiceMax Adapter Label | Comments |
|---|---|---|---|---|
| MI_FSM_USG_WHD_EVNT_DTL_ID_C | Work History Detail ID | Concatenation of WH-Service_Request__r.Name and SVMXC__Service_Order__c .NAME | Work Order |
This is a key field. If both service request and work order are present, this field has the format WH-SR-00000341-WO-00000025. f no service request is present, then this field has the format WH-WO-00000025. |
| MI_FSM_USG_WHD_WRK_HIST_ID_C | Work History ID | Concatenation of WHD-Service_Request__r.Name and SVMXC__Service_Order__c .NAME and SVMXC__Service_Order_Line__c.Name | Work Detail Number |
This is a key field. This field has the format WHD-SR-00000341-WO-00000025-WL-0000042. |
| MI_FSM_USG_WHD_ORDR_ID_C | Order ID | Name | WO |
This is a key field. The value of this field is the Work Order Number in ServiceMax. |
| MI_FSM_USG_WHD_DTL_ID_C | Detail ID | Name | WL | The value of this field is the Work Detail Number in ServiceMax. |
| MI_FSM_USG_WHD_REC_TP_C | Record Type | Name | Record Type | The value of this field is the Record Type in ServiceMax. |
| MI_FSM_USG_WHD_DTL_TP_C | Line Type | SVMXC__Line_Type__c | Line Type | The value of this field is the Line Type in ServiceMax. Valid values are Parts, Labor, or Expenses. |
| MI_FSM_USG_WHD_ACT_TP_C | Activity Type | SVMXC__Activity_Type__c | Activity Type | The value of this field is the Activity Type in ServiceMax. The value is usually present for labor line types. |
| MI_FSM_USG_WHD_PART_ID_C | Part Record ID | SVMXC__Product__c | Part | The value of this field is the product used as defined in a Salesforce product record. |
| MI_FSM_USG_WHD_QTY_N | Line Quantity | MI_FSM_USG_WHD_QTY_N | Line Quantity | The value of this field is the actual units used. The value is context sensitive. For example, the quantity for travel expenses would be miles. |
| MI_FSM_USG_WHD_PRICEBOOK_L | Use Pricebook | SVMXC__Use_Price_From_Pricebook__c | Use Pricebook | The value of this field specifies whether to use the default price defined in a price book. Valid values are TRUE or FALSE. |
| MI_FSM_USG_WHD_UNIT_PRICE_N | Line Unit Price | SVMXC__Actual_Price2__c | Line Unit Price | The value of this field is the actual price of this line item, whether it is for parts, labor, or expenses. |
| MI_FSM_USG_WHD_IS_BILL_L | Billable | SVMXC__Is_Billable__c | Is Billable | The value of this field specifies whether this line item is billable to the customer. Valid values are TRUE or FALSE. |
| MI_FSM_USG_WHD_COST_CAT_C | Cost Category | SVMXC__Cost_Category__c | Cost Category | The value of this field is the Cost Category in ServiceMax that is applied to this line item. |
| MI_FSM_USG_WHD_EXP_TP_C | Expense Type | SVMXC__Expense_Type__c | Expense Type | The value of this field is the Expense Type in ServiceMax. |
| MI_FSM_USG_WHD_START_DT_D | Start Time | SVMXC__Start_Date_and_Time__c | Start Time |
The value of this field is the actual start date and time of the work. The value of this field has the format YYYY-MO-DDTHH:MN:SS.ttt+OOOO, where:
|
| MI_FSM_USG_WHD_END_DT_D | End Time | SVMXC__End_Date_and_Time__c | End Time |
The value of this field is the actual end date and time of the work. The value of this field has the format YYYY-MO-DDTHH:MN:SS.ttt+OOOO, where:
|
| MI_FSM_USG_WHD_DTL_REF_TX | Reference Information | SVMXC__Reference_Information__c | Reference Information | The value of this field is additional information about the completed work. For example, a travel ticket number. |
| MI_FSM_USG_WHD_TTL_PRICE_N | Total Line Price | SVMXC__Total_Line_Price__c | Total Line Price | The value of this field is the actual total price of this line item. |
| MI_FSM_USG_WHD_REC_TP_DESC_C | Record Type Description | Description | Record Type Description | The value of this field is a description of the Record Type. |
| MI_FSM_USG_WHD_PART_NM_C | Part Name | Name | Part Name | The value of this field is the part name as defined in a Salesforce product record. |
| MI_FSM_USG_WHD_DTL_STATUS_C | Line Status | SVMXC__Line_Status__c | Line Status | The value of this field is the current status of the service order. |
ServiceMax Recommendation Mappings
The following table explains the Predix Essentials Recommendation fields that are used to populate ServiceMax Service Request records when using the ServiceMax Adapter.
All of these fields belong to the Predix Essentials Recommendation family (ID: MI_REC).
|
ServiceMax Field |
ServiceMax Label |
Predix Essentials Field |
|---|---|---|
| SVMXC__Subject__c | Product description | MI_REC_SHORT_DESCR_CHR |
| SVMXC__Problem_Description__c | Problem description | MI_REC_LONG_DESCR_TX |
| SVMXC__Priority__c | Priority | MI_REC_PRIORITY_C |
| None | Create date | MI_REC_CREAT_DATE_DT |
| SVMXC__Type__c | Alert type | MI_REC_TYPE_CHR |
| SVMXC__Status__c | Status of the service request | MI_REC_STATU_CHR |
| SVMXC__Preferred_start_Time__c | Start time for the service request | EVNT_START_DT |
| SVMXC__Service_Request_Source__c | The source of the service request | APM The request comes from the Predix Essentials system. |
| Record_ID | Service record Id | MI_REC_EAM_SERVICE_REQ_ID_C |
| Equipment_ID__c | Equipment ID | Equipment ID |