Mappable Fields and Labels
The following is a list of mappable fields/labels for Current Values and Previous Values.
- Attachments can be included and stored
- These are not case-sensitive
- Spaces are optional
Current Values
| Value | Additional Information |
|---|---|
Actual_Hours | |
| ADRSCODE | Location ID/Number |
| Appointment | |
| Appointment_Description | |
| Appointment_Group_ID | |
| Appointment_Priority | |
| Appointment_Status | |
| Appointment_Type | |
| Caller_Email_Address | |
| Caller_Name | |
| Caller_Phone | |
| Cancelled_Reason | |
| Completion_Date | |
| Cost_Code_Alias | |
| CREATDDT | Created Date |
| CRUSRID | Created User ID |
| CUSTNAME | Customer Name |
CUSTNMBR | Customer ID/Number |
| Description | |
| DEX_ROW_ID | |
| Divisions | |
| EndDateTime | Ending Date/Time |
| ENDTIME | End Time |
| Estimate_Hours | |
| Labor_Override | |
| Location_ADDRESS1 | |
| Location_CITY | |
| Location_Contact_Person_1 | |
| Location_Phone_1 | |
| Location_STATE | |
| Location_ZIP | |
| LOCATNNM | Location Name |
| MDFUSRID | Modified User ID |
| MODIFDT | Modified Date |
| Modified_Time | |
| Priority_of_Call | |
| Problem_Description | |
Purchase_Order | |
| R_Email | Reply To/Caller Email Address - R_Email comes from the K2A_ResourceExtension table and is the primary email address setup in Schedule. |
Service_Call_ID | |
| Service_Desc_Note | Service Call Description Note |
| Service_Description | |
| Service_User_Defined _10 | |
| Service_User_Defined _11 | |
| Service_User_Defined _12 | |
| Service_User_Defined _18 | |
| Service_User_Defined _19 | |
| Service_User_Defined _2 | |
| Service_User_Defined _20 | |
| Service_User_Defined _21 | |
| Service_User_Defined _3 | |
| Service_User_Defined _4 | |
| Service_User_Defined _5 | |
| Service_User_Defined _6 | |
| Service_User_Defined _7 | |
| Service_User_Defined _8 | |
| Service_User_Defined _9 | |
| Service_User_Defined_1 | |
| Skill_Level | |
| StartDateTime | Start Date/Time |
| State_Created | |
| State_Scheduled | |
| STRTTIME | Start Time |
| SV_Tool_ID | |
| Task_Date | |
| Technician | |
| Technician_Long_Name | |
| Technician_Status | |
| TechnicianEmail | TechnicianEmail comes from the SV00115.SV_Pager_PIN column which can be used for the technician's SMS email gateway email address. e.g. {phone-number}@vtext.com for Verizon as an example. |
| TechnicianPhone | |
| TechnicianSkillLevel | |
| Time_Entered_CB | Time Entered checkbox |
| Type_of_Call | Call Type |
| Type_of_Problem | Problem Type |
| UDCB1 | AC Notify flag |
| UDCB2 | |
| UPRTRXCD | Payroll Transaction Code |
| UserDD1 | |
| UserDD2 | |
| USERDEF1 | |
| USERDEF2 | |
| USRDAT01 | |
| USRDAT02 | |
| Wennsoft_Affiliate | |
| Wennsoft_Branch | |
| Wennsoft_Region | |
| WS_Cost_Code | Cost Code |
| WS_Job_Number | Job Number |
Previous Values
| Value | Additional Information |
|---|---|
prev_Actual_Hours | |
| prev_ADRSCODE | Previous Location ID/Number |
| prev_Appointment | |
| prev_Appointment_Description | |
| prev_Appointment_Group_ID | |
| prev_Appointment_Priority | |
| prev_Appointment_Status | |
| prev_Appointment_Type | |
| prev_Caller_Email_Address | |
| prev_Caller_Name | |
| prev_Caller_Phone | |
| prev_Cancelled_Reason | |
| prev_Completion_Date | |
| prev_Cost_Code_Alias | |
| prev_ prev_CREATDDT | Previous Created Date |
| prev_CRUSRID | Previous Created User ID |
| prev_CUSTNAME | Previous Customer Name |
prev_CUSTNMBR | Previous Customer ID/Number |
| prev_Description | |
| prev_DEX_ROW_ID | |
| prev_Divisions | |
| prev_EndDateTime | Previous Ending Date/Time |
| prev_ENDTIME | Previous End Time |
| Estimate_Hours | |
| prev_Labor_Override | |
| prev_Location_ADDRESS1 | |
| prev_Location_CITY | |
| prev_Location_Contact_Person_1 | |
| prev_Location_Phone_1 | |
| prev_Location_STATE | |
| prev_Location_ZIP | |
| prev_LOCATNNM | Previous Location Name |
| prev_MDFUSRID | Previous Modified User ID |
| prev_MODIFDT | Previous Modified Date |
| prev_Modified_Time | |
| prev_Priority_of_Call | |
| prev_Problem_Description | |
| prev_Purchase_Order | |
| prev_R_Email | Previous Reply To/Caller Email Address - R_Email comes from the K2A_ResourceExtension table and is the primary email address setup in Schedule. |
prev_Service_Call_ID | |
| prev_Service_Desc_Note | Previous Service Call Description Note |
| prev_Service_Description | |
| prev_Service_User_Defined _10 | |
| prev_Service_User_Defined _11 | |
| prev_Service_User_Defined _12 | |
| prev_Service_User_Defined _18 | |
| prev_Service_User_Defined _19 | |
| prev_Service_User_Defined _2 | |
| prev_Service_User_Defined _20 | |
| prev_Service_User_Defined _21 | |
| prev_Service_User_Defined _3 | |
| prev_Service_User_Defined _4 | |
| prev_Service_User_Defined _5 | |
| prev_Service_User_Defined _6 | |
| prev_Service_User_Defined _7 | |
| prev_Service_User_Defined _8 | |
| prev_Service_User_Defined _9 | |
| prev_Service_User_Defined_1 | |
| prev_Skill_Level | |
| prev_StartDateTime | Previous Start Date/Time |
| prev_State_Created | |
| prev_State_Scheduled | |
| prev_STRTTIME | Previous Start Time |
| prev_SV_Tool_ID | |
| prev_Task_Date | |
| prev_Technician | |
| prev_Technician_Long_Name | |
| prev_Technician_Status | |
| prev_TechnicianEmail | TechnicianEmail comes from the SV00115.SV_Pager_PIN column which can be used for the technician's SMS email gateway email address. e.g. {phone-number}@vtext.com for Verizon as an example. |
| prev_TechnicianPhone | |
| prev_TechnicianSkillLevel | |
| prev_Time_Entered_CB | Previous Time Entered checkbox |
| prev_Type_of_Call | Previous Call Type |
| prev_Type_of_Problem | Previous Problem Type |
| prev_UDCB1 | Previous AC Notify flag |
| prev_UDCB2 | |
| prev_UPRTRXCD | Previous Payroll Transaction Code |
| prev_UserDD1 | |
| prev_UserDD2 | |
| prev_USERDEF1 | |
| prev_USERDEF2 | |
| prev_USRDAT01 | |
| prev_USRDAT02 | |
| prev_Wennsoft_Affiliate | |
| prev_Wennsoft_Branch | |
| prev_Wennsoft_Region | |
| prev_WS_Cost_Code | Previous Cost Code |
| prev_WS_Job_Number | Previous Job Number |