Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV30301
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Appointment_History_MSTR
Physical Name: SV30301
Technical Name: SV_Appointment_History_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 WS_Appointment_ID 
WS Appointment ID Long Int Long Integer 8 2 Appointment_Action Appointment Action STR17_LBAU String 17 3 Service_Call_ID Service Call ID STR17_LBAU String 17 4 Appointment Appointment STR25 String 25 5 Appointment_Type Appointment Type DDL_Appointment_Type Integer 0 6 Appointment_Priority Appointment Priority STR2 String 2 7 Technician Technician STR10_LBAU String 10 8 Skill_Level Skill Level STR15_LBAU String 15 9 Task_Date Task Date Date Date 10 10 STRTTIME Start Time TM6 Time 6 11 ENDTIME End Time TM6 Time 6 12 Estimate_Hours Estimate Hours LI6_S2 Long Integer 6 13 Actual_Hours Actual Hours LI6_S2 Long Integer 6 14 Technician_Status Technician Status STR17_LBAU String 17 15 Appointment_Status Appointment Status STR10_LBAU String 10 16 Status_Date Status_Date DT Date 8 17 Status_Time Status_Time TM6 Time 6 18 Completion_Date SV Completion Date DT Date 8 19 Time_Entered_CB Time_Entered_CB CB_Time_Entered Boolean 0 20 Labor_Override Labor Override CB_Labor_Override Boolean 0 21 CREATDDT Created Date DT Date 8 22 CRUSRID Created User ID STR15_User_ID String 15 23 MODIFDT Modified Date DT Date 8 24 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Appointment_History_MSTR'].MDFUSRID AS 'SV_Appointment_History_MSTR-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV30301 AS ['SV_Appointment_History_MSTR']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Appointment_History_MSTR'].MDFUSRID = ['Users Master'].USERID25 Modified_Time Modified Time TM6 Time 6 26 USERDEF1 User Defined 1 STR20 String 20 27 USERDEF2 User Defined 2 STR20 String 20 28 UDCB1 User Defined CB 11 CB Boolean 0 29 UDCB2 User Defined CB 21 CB Boolean 0 30 USRDAT01 User Defined Date 1 DT Date 8 31 USRDAT02 User Defined Date 2 DT Date 8 32 UserDD1 User Defined Dollar 11 DLR14_RBS0_STR$ Currency 14 33 UserDD2 User Defined Dollar 21 DLR14_RBS0_STR$ Currency 14 34 SV_Tool_ID SV_Tool_ID LI6_U Long Integer 0