Grant Master (GTM01100)

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_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1GRANTID SearchGTM_GrantIDStringSTR30_LBAU30
2GRANTDESC SearchGTM_GrantDescriptionStringSTR5050
3GRANTSTATUS SearchGTM_GrantStatusIntegerGTM_DDL_GrantStatus0
4STRTDATE SearchStart DateDateDT8
5ENDDATE SearchEnd DateDateDT8
6GRANTTYPE SearchGTM_GrantTypeStringSTR15_LBAU15
7VALIDGRANTPERIOD SearchGTM_ValidateGrantPeriodBooleanGTM_CB_ValidateGrantPeriod0
8GRANTPERIODACTION SearchGTM_GrantPeriodActionIntegerGTM_RG_GrantAction0
9VALIDGRANTTODATE SearchGTM_ValidateGrantToDateBooleanGTM_CB_ValidateGrantToDate0
10GRANTTODATEACTION SearchGTM_GrantToDateActionIntegerGTM_RG_GrantAction0
11VALIDGRANTLIFE SearchGTM_ValidateGrantLifeBooleanGTM_CB_ValidateGrantLife0
12GRANTLIFEACTION SearchGTM_GrantLifeActionIntegerGTM_RG_GrantAction0
13VALIDGRANTTOTAL SearchGTM_ValidateGrantTotalBooleanGTM_CB_ValidateGrantTotal0
14GRANTTOTALTYPE SearchGTM_GrantTotalTypeIntegerGTM_RG_GrantAction0
15GRANTTOTALACTION SearchGTM_GrantTotalActionIntegerGTM_RG_GrantAction0
16AWARDAMOUNT SearchGTM_AwardAmountCurrencyDLR19_$U219
17ENABLEGRANTBUDGET SearchGTM_EnableGrantBudgetBooleanGTM_EnableGrantBudget0
18UNIQUEGRANTID SearchGTM_UniqueGrantIDLong IntegerGTM_UniqueGrantID8
19NOTEINDX SearchNote IndexCurrencyDLR1414
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 SearchaaTrxDimStringaaSTR30_LBAU30
21aaTrxDimCode SearchaaTrxDimCodeStringaaSTR30_LBAU30
22BUDGETID SearchBudget IDStringSTR15_LBAU15
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_BudgetValidationByIntegerGB0

Leave a Reply

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