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 |
|
|
StartDate |
Start Date |
|
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 |