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