Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV585CLP
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Contract_Tasks_TEMP
Physical Name: SV585CLP
Technical Name: SV_Contract_Tasks_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Contract_Tasks_TEMP'].CUSTNMBR AS 'SV_Contract_Tasks_TEMP-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV585CLP AS ['SV_Contract_Tasks_TEMP']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Contract_Tasks_TEMP'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Contract_Number WS Contract Number STR10 String 10 4 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 5 Task_Code Task Code STR10 String 10 6 Equipment_ID Equipment ID STR30 String 30 7 Contract_Task_List_ID Contract Task List ID STR10_LBAU String 10 8 Technician_ID Technician ID STR15_Employee_ID String 15 9 Out_of_Service_Flag Out of Service Flag CB_Out_Of_Service_Flag Boolean 0 10 Jan_Est_Hours Jan Est Hours LI6_S2 Long Integer 6 11 Feb_Est_Hours Feb Est Hours LI6_S2 Long Integer 6 12 March_Est_Hours March Est Hours LI6_S2 Long Integer 6 13 April_Est_Hours April Est Hours LI6_S2 Long Integer 6 14 May_Est_Hours May Est Hours LI6_S2 Long Integer 6 15 June_Est_Hours June Est Hours LI6_S2 Long Integer 6 16 July_Est_Hours July Est Hours LI6_S2 Long Integer 6 17 Aug_Est_Hours Aug Est Hours LI6_S2 Long Integer 6 18 Sept_Est_Hours Sept Est Hours LI6_S2 Long Integer 6 19 Oct_Est_Hours Oct Est Hours LI6_S2 Long Integer 6 20 Nov_Est_Hours Nov Est Hours LI6_S2 Long Integer 6 21 Dec_Est_Hours Dec Est Hours LI6_S2 Long Integer 6 22 Equipment_Type Equipment Type STR30 String 30 23 Task_Description Task Description STR60 String 60 24 Task_Description_Long Task Description Long STR255 String 255 25 Jan_Required Jan Required CB Boolean 0 26 Feb_Required Feb Required CB Boolean 0 27 March_Required March Required CB Boolean 0 28 April_Required April Required CB Boolean 0 29 May_Required May Required CB Boolean 0 30 June_Required June Required CB Boolean 0 31 July_Required July Required CB Boolean 0 32 Aug_Required Aug Required CB Boolean 0 33 Sept_Required Sept Required CB Boolean 0 34 Oct_Required Oct Required CB Boolean 0 35 Nov_Required Nov Required CB Boolean 0 36 Dec_Required Dec Required CB Boolean 0 37 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Contract_Tasks_TEMP'].USERID AS 'SV_Contract_Tasks_TEMP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV585CLP AS ['SV_Contract_Tasks_TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Contract_Tasks_TEMP'].USERID = ['Users Master'].USERID38 Schedule_Description WS Schedule Description STR30 String 30