GTM_AllGrantBudgetByAccount (GTM20003V)

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

Display Name: GTM_AllGrantBudgetByAccount
Physical Name: GTM20003V
Technical Name: GTM_AllGrantBudgetByAccount

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	aaBudgetID	aaBudgetID	Long Integer	aaLONG_INT	8
2	aaBudget	aaBudget	String	STR15_LBAU	15
3	YEAR1	Year	Integer	Year	4
4	aaFiscalPeriod	aaFiscalPeriod	Integer	INT3	3
5	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['GTM_AllGrantBudgetByAccount'].ACTINDX AS 'GTM_AllGrantBudgetByAccount-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM GTM20003V AS ['GTM_AllGrantBudgetByAccount'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['GTM_AllGrantBudgetByAccount'].ACTINDX = ['Account Index Master'].ACTINDX
6	aaTrxDim	aaTrxDim	String	aaSTR30_LBAU	30
7	aaTrxDimCode	aaTrxDimCode	String	aaSTR30_LBAU	30
8	STRTDATE	Start Date	Date	DT	8
9	ENDDATE	End Date	Date	DT	8
10	Balance	Balance	Currency	DLR19_$S2	19
11	PERIODDT	Period Date	Date	DT_Date	6