Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC10300
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Account Budget
Physical Name: ENC10300
Technical Name: ENC_AccountBudgetSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BUDGETID 
Budget ID String STR15_LBAU 15 Key to the Budget Master (GL00200).
Click to show/hide
SELECT
['Encumbrance Account Budget'].BUDGETID AS 'Encumbrance Account Budget-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
ENC10300 AS ['Encumbrance Account Budget']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['Encumbrance Account Budget'].BUDGETID = ['Budget Master'].BUDGETID2 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Encumbrance Account Budget'].ACTINDX AS 'Encumbrance Account Budget-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ENC10300 AS ['Encumbrance Account Budget']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Encumbrance Account Budget'].ACTINDX = ['Account Index Master'].ACTINDX3 YEAR1 Year Integer Year 4 4 PERIODID Period ID Integer INT3 3 5 PERIODDT Period Date Date DT_Date 6 6 PERDENDT Period-Ending Date Date DT_Ending_Date 0 7 Actual_Amount Actual Amount Currency DLR19_$S2 19 8 UNPOSTEDAMT Unposted Amount Currency DLR19_$S2 19 9 BUDGETAMT Budget Amount Currency DLR19_$S2 19 10 ENCMBAMT Encumbered Amount Currency DLR19_$S2 19 11 PreEncumberedAmt PreEncumbered Amount Currency DLR19_$S2 19 12 PreBudgetAmt PreBudget Amount Currency DLR19_$S2 19