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 TypeSQL DB LengthKeyable Length
1GRANTID SearchGTM_GrantIDSTR30_LBAUString3230
2GRANTDESC SearchGTM_GrantDescriptionSTR50String5250
3GRANTSTATUS SearchGTM_GrantStatusGTM_DDL_GrantStatusInteger20
4STRTDATE SearchStart DateDTDate48
5ENDDATE SearchEnd DateDTDate48
6GRANTTYPE SearchGTM_GrantTypeSTR15_LBAUString1615
7VALIDGRANTPERIOD SearchGTM_ValidateGrantPeriodGTM_CB_ValidateGrantPeriodBoolean20
8GRANTPERIODACTION SearchGTM_GrantPeriodActionGTM_RG_GrantActionInteger20
9VALIDGRANTTODATE SearchGTM_ValidateGrantToDateGTM_CB_ValidateGrantToDateBoolean20
10GRANTTODATEACTION SearchGTM_GrantToDateActionGTM_RG_GrantActionInteger20
11VALIDGRANTLIFE SearchGTM_ValidateGrantLifeGTM_CB_ValidateGrantLifeBoolean20
12GRANTLIFEACTION SearchGTM_GrantLifeActionGTM_RG_GrantActionInteger20
13VALIDGRANTTOTAL SearchGTM_ValidateGrantTotalGTM_CB_ValidateGrantTotalBoolean20
14GRANTTOTALTYPE SearchGTM_GrantTotalTypeGTM_RG_GrantActionInteger20
15GRANTTOTALACTION SearchGTM_GrantTotalActionGTM_RG_GrantActionInteger20
16AWARDAMOUNT SearchGTM_AwardAmountDLR19_$U2Currency1019
17ENABLEGRANTBUDGET SearchGTM_EnableGrantBudgetGTM_EnableGrantBudgetBoolean20
18UNIQUEGRANTID SearchGTM_UniqueGrantIDGTM_UniqueGrantIDLong Integer48
19NOTEINDX SearchNote IndexDLR14Currency1014
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_LBAUString3230
21aaTrxDimCode SearchaaTrxDimCodeaaSTR30_LBAUString3230
22BUDGETID SearchBudget IDSTR15_LBAUString1615
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_BudgetValidationByGBInteger20
24DEX_ROW_ID Searchintint1010

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 *