AA Budget Master (AAG00903)

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

Display Name: AA Budget Master
Physical Name: AAG00903
Technical Name: aaBudgetMstr

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	aaBudgetID	aaBudgetID	aaLONG_INT	Long Integer	4	8
2	aaBudget	aaBudget	aaSTR15_LBAU	String	16	15
3	aaBudgetDescr	aaBudgetDescr	aaSTR50	String	52	50
4	aaBudgetTreeID	aaBudgetTreeID	aaLONG_INT	Long Integer	4	8
5	Based_On	Based On	BasedOnDDL	Integer	2	0
6	YEAR1	Year	Year	Integer	2	4
7	From_Date	From Date	DATE	Date	4	6
8	TODATE	To Date	DATE	Date	4	6
9	BUDPWRD	Budget Password	STR15_LBAU	String	16	15
10	aaBudgetRollUp	aaBudgetRollUp	aaBoolean	Boolean	2	0
11	NOTEINDX	Note Index	DLR14	Currency	10	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['AA Budget Master'].NOTEINDX AS 'AA Budget Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM AAG00903 AS ['AA Budget Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['AA Budget Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
12	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.
13	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.