Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CLM50801
Product: Certification Manager (4933)
Series:
Display Name: CLM Endorse EE License Assign History
Physical Name: CLM50801
Technical Name: CLM_Endorse_EE_Lic_Assign_HISTSeq 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_License_Code CLM License 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 License Assign History'].NOTEINDX AS 'CLM Endorse EE License Assign History-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CLM50801 AS ['CLM Endorse EE License Assign History']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CLM Endorse EE License Assign History'].NOTEINDX = ['Record Notes Master'].NOTEINDX