Grant Master (GTM01100)

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

Product: Grant Management (4421)
Series: Financial

Display Name: Grant Master
Physical Name: GTM01100
Technical Name: GTM_Grant_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1GRANTID SearchGTM_GrantIDSTR30_LBAUString30
2GRANTDESC SearchGTM_GrantDescriptionSTR50String50
3GRANTSTATUS SearchGTM_GrantStatusGTM_DDL_GrantStatusInteger0
4STRTDATE SearchStart DateDTDate8
5ENDDATE SearchEnd DateDTDate8
6GRANTTYPE SearchGTM_GrantTypeSTR15_LBAUString15
7VALIDGRANTPERIOD SearchGTM_ValidateGrantPeriodGTM_CB_ValidateGrantPeriodBoolean0
8GRANTPERIODACTION SearchGTM_GrantPeriodActionGTM_RG_GrantActionInteger0
9VALIDGRANTTODATE SearchGTM_ValidateGrantToDateGTM_CB_ValidateGrantToDateBoolean0
10GRANTTODATEACTION SearchGTM_GrantToDateActionGTM_RG_GrantActionInteger0
11VALIDGRANTLIFE SearchGTM_ValidateGrantLifeGTM_CB_ValidateGrantLifeBoolean0
12GRANTLIFEACTION SearchGTM_GrantLifeActionGTM_RG_GrantActionInteger0
13VALIDGRANTTOTAL SearchGTM_ValidateGrantTotalGTM_CB_ValidateGrantTotalBoolean0
14GRANTTOTALTYPE SearchGTM_GrantTotalTypeGTM_RG_GrantActionInteger0
15GRANTTOTALACTION SearchGTM_GrantTotalActionGTM_RG_GrantActionInteger0
16AWARDAMOUNT SearchGTM_AwardAmountDLR19_$U2Currency19
17ENABLEGRANTBUDGET SearchGTM_EnableGrantBudgetGTM_EnableGrantBudgetBoolean0
18UNIQUEGRANTID SearchGTM_UniqueGrantIDGTM_UniqueGrantIDLong Integer8
19NOTEINDX SearchNote IndexDLR14Currency14
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
20aaTrxDim SearchaaTrxDimaaSTR30_LBAUString30
21aaTrxDimCode SearchaaTrxDimCodeaaSTR30_LBAUString30
22BUDGETID SearchBudget IDSTR15_LBAUString15
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
23GTM_BudgetValidationBy SearchGTM_BudgetValidationByGBInteger0
24DEX_ROW_ID Searchintint10

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.

Leave a Reply

Your email address will not be published. Required fields are marked *