Encumbrance Grant Master (ENCGTM01100V)

azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance Grant Master (ENCGTM01100V)

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

Product: Encumbrance Management (3258)
Series:

Display Name: Encumbrance Grant Master
Physical Name: ENCGTM01100V
Technical Name: ENC_Grant_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1GRANTID SearchGTM_GrantIDStringSTR30_LBAU30
2aaBudgetTreeID SearchaaBudgetTreeIDLong IntegeraaLONG_INT8
3aaBudgetID SearchaaBudgetIDLong IntegerLong Int8
4aaTrxDimID SearchaaTrxDimIDLong IntegeraaLONG_INT8
5aaTrxDimCodeID SearchaaTrxDimCodeIDLong IntegeraaLONG_INT8
6aaCodeSequence SearchaaCodeSequenceLong IntegeraaLONG_INT8
7GRANTDESC SearchGTM_GrantDescriptionStringSTR5050
8GRANTSTATUS SearchGTM_GrantStatusIntegerGTM_DDL_GrantStatus0
9YEAR1 SearchYearIntegerYear4
10From_Date SearchFrom DateDateDATE6
11TODATE SearchTo DateDateDATE6
12STRTDATE SearchStart DateDateDT8
13ENDDATE SearchEnd DateDateDT8
14UNIQUEGRANTID SearchGTM_UniqueGrantIDLong IntegerGTM_UniqueGrantID8
15GRANTTYPE SearchGTM_GrantTypeStringSTR15_LBAU15
16AWARDAMOUNT SearchGTM_AwardAmountCurrencyDLR19_$U219
17ENABLEGRANTBUDGET SearchGTM_EnableGrantBudgetBooleanGTM_EnableGrantBudget0
18aaLvlCodeString SearchaaLvlCodeStringStringSTR5050
19aaTrxDim SearchaaTrxDimStringaaSTR30_LBAU30
20aaTrxDimCode SearchaaTrxDimCodeStringaaSTR30_LBAU30
21aaBudgetTree SearchaaBudgetTreeStringSTR15_LBAU15
22BUDGETID SearchBudget IDStringSTR15_LBAU15
Key to the Budget Master (GL00200).

Click to show/hide

SELECT
       ['Encumbrance Grant Master'].BUDGETID AS 'Encumbrance Grant Master-Budget ID'
       ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
       ENCGTM01100V AS ['Encumbrance Grant Master']
INNER JOIN
       GL00200 AS ['Budget Master']
              ON
                     ['Encumbrance Grant Master'].BUDGETID = ['Budget Master'].BUDGETID
23GTM_BudgetValidationBy SearchGTM_BudgetValidationByIntegerGB0
azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance Grant Master (ENCGTM01100V)

Leave a Reply

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