Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GTM01100
Product: Grant Management (4421)
Series:
Display Name: Grant Master
Physical Name: GTM01100
Technical Name: GTM_Grant_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 GRANTID 
GTM_GrantID String STR30_LBAU 30 2 GRANTDESC GTM_GrantDescription String STR50 50 3 GRANTSTATUS GTM_GrantStatus Integer GTM_DDL_GrantStatus 0 4 STRTDATE Start Date Date DT 8 5 ENDDATE End Date Date DT 8 6 GRANTTYPE GTM_GrantType String STR15_LBAU 15 7 VALIDGRANTPERIOD GTM_ValidateGrantPeriod Boolean GTM_CB_ValidateGrantPeriod 0 8 GRANTPERIODACTION GTM_GrantPeriodAction Integer GTM_RG_GrantAction 0 9 VALIDGRANTTODATE GTM_ValidateGrantToDate Boolean GTM_CB_ValidateGrantToDate 0 10 GRANTTODATEACTION GTM_GrantToDateAction Integer GTM_RG_GrantAction 0 11 VALIDGRANTLIFE GTM_ValidateGrantLife Boolean GTM_CB_ValidateGrantLife 0 12 GRANTLIFEACTION GTM_GrantLifeAction Integer GTM_RG_GrantAction 0 13 VALIDGRANTTOTAL GTM_ValidateGrantTotal Boolean GTM_CB_ValidateGrantTotal 0 14 GRANTTOTALTYPE GTM_GrantTotalType Integer GTM_RG_GrantAction 0 15 GRANTTOTALACTION GTM_GrantTotalAction Integer GTM_RG_GrantAction 0 16 AWARDAMOUNT GTM_AwardAmount Currency DLR19_$U2 19 17 ENABLEGRANTBUDGET GTM_EnableGrantBudget Boolean GTM_EnableGrantBudget 0 18 UNIQUEGRANTID GTM_UniqueGrantID Long Integer GTM_UniqueGrantID 8 19 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Grant Master'].NOTEINDX AS 'Grant Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
GTM01100 AS ['Grant Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Grant Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX20 aaTrxDim aaTrxDim String aaSTR30_LBAU 30 21 aaTrxDimCode aaTrxDimCode String aaSTR30_LBAU 30 22 BUDGETID Budget ID String STR15_LBAU 15 Key to the Budget Master (GL00200).
Click to show/hide
SELECT
['Grant Master'].BUDGETID AS 'Grant Master-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
GTM01100 AS ['Grant Master']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['Grant Master'].BUDGETID = ['Budget Master'].BUDGETID23 GTM_BudgetValidationBy GTM_BudgetValidationBy Integer GB 0