Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JOET0040
Product: MICR for Canadian Payroll (2916)
Series: Project
Display Name: JOE_Suppress_Paycodes
Physical Name: JOET0040
Technical Name: JOE_Suppress_PaycodesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PPayrollCodeType 
P_Payroll_Code_Type X_Payroll_Code_Type Integer 0 2 PIncomeCode P_Income_Code X_STR06_Upper String 6 3 DSCRIPTN Description STR30 String 30 4 MODIFDT Modified Date DT Date 8 5 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JOE_Suppress_Paycodes'].MDFUSRID AS 'JOE_Suppress_Paycodes-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JOET0040 AS ['JOE_Suppress_Paycodes']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JOE_Suppress_Paycodes'].MDFUSRID = ['Users Master'].USERID