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 SQL DB Length Keyable Length 1 aaTrxDimID aaTrxDimID aaLONG_INT Long Integer 4 8 2 aaTrxDimCodeID aaTrxDimCodeID aaLONG_INT Long Integer 4 8 3 aaTrxDimCode aaTrxDimCode aaSTR30_LBAU String 32 30 4 aaTrxDimCodeDescr aaTrxDimCodeDescr aaStr50 String 52 50 5 aaTrxDimCodeDescr2 aaTrxDimCodeDescr2 aaStr50 String 52 50 6 NOTEINDX Note Index DLR14 Currency 10 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 CB_Inactive Boolean 2 0 8 DEX_ROW_TS datetime datetime 3 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. 9 DEX_ROW_ID int int 10 10