aaTrxDimCodeSetp (AAG00401)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG00401

Display Name: aaTrxDimCodeSetp
Physical Name: AAG00401
Technical Name: aaTrxDimCodeSetp

Seq 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
	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.