Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CLM40701
Product: Certification Manager (4933)
Series:
Display Name: CLM Endorse EE Cert Assign
Physical Name: CLM40701
Technical Name: CLM_Endorse_EE_Cert_AssignSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID 
Employee ID String STR15_Employee_ID 15 2 DEPRTMNT Department String STR6_Payroll_Code 6 3 JOBTITLE Job Title String STR6_Payroll_Code 6 4 CLM_Cert_Code CLM Cert Code String STR6_U 6 5 CLM_Endorsement CLM Endorsement String STR50 50 6 CLM_Assigned CLM Assigned Boolean CB 0 7 CHANGEBY_I Change By String STR15_User_ID 15 8 CHANGEDATE_I Change Date Date DT 8 9 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CLM Endorse EE Cert Assign'].NOTEINDX AS 'CLM Endorse EE Cert Assign-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CLM40701 AS ['CLM Endorse EE Cert Assign']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CLM Endorse EE Cert Assign'].NOTEINDX = ['Record Notes Master'].NOTEINDX