Encumbrance Grant Master (ENCGTM01100V)

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

Display Name: Encumbrance Grant Master
Physical Name: ENCGTM01100V
Technical Name: ENC_Grant_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	GRANTID	GTM_GrantID	String	STR30_LBAU	30
2	aaBudgetTreeID	aaBudgetTreeID	Long Integer	aaLONG_INT	8
3	aaBudgetID	aaBudgetID	Long Integer	Long Int	8
4	aaTrxDimID	aaTrxDimID	Long Integer	aaLONG_INT	8
5	aaTrxDimCodeID	aaTrxDimCodeID	Long Integer	aaLONG_INT	8
6	aaCodeSequence	aaCodeSequence	Long Integer	aaLONG_INT	8
7	GRANTDESC	GTM_GrantDescription	String	STR50	50
8	GRANTSTATUS	GTM_GrantStatus	Integer	GTM_DDL_GrantStatus	0
9	YEAR1	Year	Integer	Year	4
10	From_Date	From Date	Date	DATE	6
11	TODATE	To Date	Date	DATE	6
12	STRTDATE	Start Date	Date	DT	8
13	ENDDATE	End Date	Date	DT	8
14	UNIQUEGRANTID	GTM_UniqueGrantID	Long Integer	GTM_UniqueGrantID	8
15	GRANTTYPE	GTM_GrantType	String	STR15_LBAU	15
16	AWARDAMOUNT	GTM_AwardAmount	Currency	DLR19_$U2	19
17	ENABLEGRANTBUDGET	GTM_EnableGrantBudget	Boolean	GTM_EnableGrantBudget	0
18	aaLvlCodeString	aaLvlCodeString	String	STR50	50
19	aaTrxDim	aaTrxDim	String	aaSTR30_LBAU	30
20	aaTrxDimCode	aaTrxDimCode	String	aaSTR30_LBAU	30
21	aaBudgetTree	aaBudgetTree	String	STR15_LBAU	15
22	BUDGETID	Budget ID	String	STR15_LBAU	15
	Key to the Budget Master (GL00200). Click to show/hide SELECT ['Encumbrance Grant Master'].BUDGETID AS 'Encumbrance Grant Master-Budget ID' ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID' FROM ENCGTM01100V AS ['Encumbrance Grant Master'] INNER JOIN GL00200 AS ['Budget Master'] ON ['Encumbrance Grant Master'].BUDGETID = ['Budget Master'].BUDGETID
23	GTM_BudgetValidationBy	GTM_BudgetValidationBy	Integer	GB	0