Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV30302
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Service_Call_Task_Lists_TEMP
Physical Name: SV30302
Technical Name: SV_Service_Call_Task_Lists_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Service_Call_Task_Lists_TEMP'].USERID AS 'SV_Service_Call_Task_Lists_TEMP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV30302 AS ['SV_Service_Call_Task_Lists_TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Service_Call_Task_Lists_TEMP'].USERID = ['Users Master'].USERID2 Service_Call_ID Service Call ID STR17_LBAU String 17 3 Task_List_ID Task List ID STR10_LBAU String 10 4 Equipment_ID Equipment ID STR30 String 30 5 Location_Equipment Location Equipment STR50_LBU String 50 6 Task_List_Description Task List Description STR60 String 60