Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IF000001
Product: Interfund Management (1042)
Series:
Display Name: IF_Method_Setup
Physical Name: IF000001
Technical Name: IF_Method_SetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 UNIQKEY 
Key String STR1 1 2 IF_Activated IF_Activated Boolean IF_CB_Activated 0 3 IF_Distribution_Created IF_Distribution Created Boolean IF_CB_Distribution_Created 0 4 IF_Method IF_Method Integer GB 0 5 SGMTNUMB Segment Number Integer INT2 2 6 SGMNTID Segment ID String STR66_Seg_ID 66 7 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['IF_Method_Setup'].NOTEINDX AS 'IF_Method_Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
IF000001 AS ['IF_Method_Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['IF_Method_Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX