Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG00401
Product: Analytical Accounting (3180)
Series:
Display Name: aaTrxDimCodeSetp
Physical Name: AAG00401
Technical Name: aaTrxDimCodeSetpSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 aaTrxDimID aaTrxDimID Long Integer aaLONG_INT 8 2 aaTrxDimCodeID aaTrxDimCodeID Long Integer aaLONG_INT 8 3 aaTrxDimCode aaTrxDimCode String aaSTR30_LBAU 30 4 aaTrxDimCodeDescr aaTrxDimCodeDescr String aaStr50 50 5 aaTrxDimCodeDescr2 aaTrxDimCodeDescr2 String aaStr50 50 6 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['aaTrxDimCodeSetp'].NOTEINDX AS 'aaTrxDimCodeSetp-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
AAG00401 AS ['aaTrxDimCodeSetp']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['aaTrxDimCodeSetp'].NOTEINDX = ['Record Notes Master'].NOTEINDX
7 INACTIVE Inactive Boolean CB_Inactive 0