Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG00401
Product: Analytical Accounting (3180)
Series: Company
Display Name: aaTrxDimCodeSetp DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
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 aaTrxDimID aaTrxDimID aaLONG_INT Long Integer 8 3 aaTrxDimCodeID aaTrxDimCodeID aaLONG_INT Long Integer 8 4 aaTrxDimCodeID aaTrxDimCodeID Long Integer aaLONG_INT 8 5 aaTrxDimCode aaTrxDimCode aaSTR30_LBAU String 30 6 aaTrxDimCode aaTrxDimCode String aaSTR30_LBAU 30 7 aaTrxDimCodeDescr aaTrxDimCodeDescr aaStr50 String 50 8 aaTrxDimCodeDescr aaTrxDimCodeDescr String aaStr50 50 9 aaTrxDimCodeDescr2 aaTrxDimCodeDescr2 String aaStr50 50 10 aaTrxDimCodeDescr2 aaTrxDimCodeDescr2 aaStr50 String 50 11 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'].NOTEINDX12 NOTEINDX Note Index DLR14 Currency 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'].NOTEINDX13 INACTIVE Inactive Boolean CB_Inactive 0 14 INACTIVE Inactive CB_Inactive Boolean 0 15 DEX_ROW_TS datetime datetime 3 DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised. 16 DEX_ROW_ID int int 10