Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GTM01100
Product: Grant Management (4421)
Series: Financial
Display Name: Grant Master 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.
Physical Name: GTM01100
Technical Name: GTM_Grant_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 GRANTID 
GTM_GrantID STR30_LBAU String 32 30 2 GRANTDESC GTM_GrantDescription STR50 String 52 50 3 GRANTSTATUS GTM_GrantStatus GTM_DDL_GrantStatus Integer 2 0 4 STRTDATE Start Date DT Date 4 8 5 ENDDATE End Date DT Date 4 8 6 GRANTTYPE GTM_GrantType STR15_LBAU String 16 15 7 VALIDGRANTPERIOD GTM_ValidateGrantPeriod GTM_CB_ValidateGrantPeriod Boolean 2 0 8 GRANTPERIODACTION GTM_GrantPeriodAction GTM_RG_GrantAction Integer 2 0 9 VALIDGRANTTODATE GTM_ValidateGrantToDate GTM_CB_ValidateGrantToDate Boolean 2 0 10 GRANTTODATEACTION GTM_GrantToDateAction GTM_RG_GrantAction Integer 2 0 11 VALIDGRANTLIFE GTM_ValidateGrantLife GTM_CB_ValidateGrantLife Boolean 2 0 12 GRANTLIFEACTION GTM_GrantLifeAction GTM_RG_GrantAction Integer 2 0 13 VALIDGRANTTOTAL GTM_ValidateGrantTotal GTM_CB_ValidateGrantTotal Boolean 2 0 14 GRANTTOTALTYPE GTM_GrantTotalType GTM_RG_GrantAction Integer 2 0 15 GRANTTOTALACTION GTM_GrantTotalAction GTM_RG_GrantAction Integer 2 0 16 AWARDAMOUNT GTM_AwardAmount DLR19_$U2 Currency 10 19 17 ENABLEGRANTBUDGET GTM_EnableGrantBudget GTM_EnableGrantBudget Boolean 2 0 18 UNIQUEGRANTID GTM_UniqueGrantID GTM_UniqueGrantID Long Integer 4 8 19 NOTEINDX Note Index DLR14 Currency 10 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 aaSTR30_LBAU String 32 30 21 aaTrxDimCode aaTrxDimCode aaSTR30_LBAU String 32 30 22 BUDGETID Budget ID STR15_LBAU String 16 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 GB Integer 2 0 24 DEX_ROW_ID int int 10 10