Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG00103
Product: Analytical Accounting (3180)
Series:
Display Name: aaSyColumnMstr
Physical Name: AAG00103
Technical Name: aaSyColumnMstrSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 aaColID 
aaColumnID Long Integer aaLONG_INT 8 2 aaColumn aaColumn Integer aaINT 5 3 aaMultiLangStr aaMultiLangStr String aaSTR50 50 4 aaMultiLangStr2 aaMultiLangStr2 String aaSTR50 50 5 aaColType aaColumnType Integer aaDDL_ColumnType 0 6 aaColDataType aaColumnDataType Integer aaDDL_ColumnDataType 0 7 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['aaSyColumnMstr'].NOTEINDX AS 'aaSyColumnMstr-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
AAG00103 AS ['aaSyColumnMstr']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['aaSyColumnMstr'].NOTEINDX = ['Record Notes Master'].NOTEINDX