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 Length 1 GRANTID GTM_GrantID STR30_LBAU String 30 2 GRANTDESC GTM_GrantDescription STR50 String 50 3 GRANTSTATUS GTM_GrantStatus GTM_DDL_GrantStatus Integer 0 4 STRTDATE Start Date DT Date 8 5 ENDDATE End Date DT Date 8 6 GRANTTYPE GTM_GrantType STR15_LBAU String 15 7 VALIDGRANTPERIOD GTM_ValidateGrantPeriod GTM_CB_ValidateGrantPeriod Boolean 0 8 GRANTPERIODACTION GTM_GrantPeriodAction GTM_RG_GrantAction Integer 0 9 VALIDGRANTTODATE GTM_ValidateGrantToDate GTM_CB_ValidateGrantToDate Boolean 0 10 GRANTTODATEACTION GTM_GrantToDateAction GTM_RG_GrantAction Integer 0 11 VALIDGRANTLIFE GTM_ValidateGrantLife GTM_CB_ValidateGrantLife Boolean 0 12 GRANTLIFEACTION GTM_GrantLifeAction GTM_RG_GrantAction Integer 0 13 VALIDGRANTTOTAL GTM_ValidateGrantTotal GTM_CB_ValidateGrantTotal Boolean 0 14 GRANTTOTALTYPE GTM_GrantTotalType GTM_RG_GrantAction Integer 0 15 GRANTTOTALACTION GTM_GrantTotalAction GTM_RG_GrantAction Integer 0 16 AWARDAMOUNT GTM_AwardAmount DLR19_$U2 Currency 19 17 ENABLEGRANTBUDGET GTM_EnableGrantBudget GTM_EnableGrantBudget Boolean 0 18 UNIQUEGRANTID GTM_UniqueGrantID GTM_UniqueGrantID Long Integer 8 19 NOTEINDX Note Index DLR14 Currency 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'].NOTEINDX
20 aaTrxDim aaTrxDim aaSTR30_LBAU String 30 21 aaTrxDimCode aaTrxDimCode aaSTR30_LBAU String 30 22 BUDGETID Budget ID STR15_LBAU String 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'].BUDGETID
23 GTM_BudgetValidationBy GTM_BudgetValidationBy GB Integer 0 24 DEX_ROW_ID int int 10