Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME_UpgradeHistory
Product: Mekorma Products Manager (7156)
Series: 3rd Party
Display Name: ME_UpgradeHistory
Physical Name: ME_UpgradeHistory
Technical Name: ME_UpgradeHistorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ME_UpgradeId 
ME_UpgradeId ME_UpgradeId String 36 2 ME_UpgradeDate ME_UpgradeDate ME_UpgradeDate Date 10 3 ME_UpgradeTime ME_UpgradeTime ME_UpgradeTime Time 6 4 ME_UpgradeEndDate ME_UpgradeEndDate ME_UpgradeDate Date 10 5 ME_UpgradeEndTime ME_UpgradeEndTime ME_UpgradeTime Time 6 6 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ME_UpgradeHistory'].USERID AS 'ME_UpgradeHistory-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ME_UpgradeHistory AS ['ME_UpgradeHistory']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ME_UpgradeHistory'].USERID = ['Users Master'].USERID