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