Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENCGTM01100V
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Grant Master
Physical Name: ENCGTM01100V
Technical Name: ENC_Grant_MSTRSeq 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'].BUDGETID23 GTM_BudgetValidationBy GTM_BudgetValidationBy Integer GB 0