Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENCAA40510V
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance AA Budget By Account
Physical Name: ENCAA40510V
Technical Name: ENC_aaBudgetAccountSeq 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 By Account'].INVINDX AS 'Encumbrance AA Budget By Account-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ENCAA40510V AS ['Encumbrance AA Budget By Account']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Encumbrance AA Budget By Account'].INVINDX = ['Account Index Master'].ACTINDX5 PERIODDT Period Date Date DT_Date 6 6 YEAR1 Year Integer Year 4 7 PERIODID Period ID Integer INT3 3 8 aaCodeSequence aaCodeSequence Long Integer aaLONG_INT 8 9 aaTrxDimID aaTrxDimID Long Integer aaLONG_INT 8 10 aaTrxDimCodeID aaTrxDimCodeID Long Integer aaLONG_INT 8 11 aaTrxDimParCodeID aaTrxDimParCodeID Long Integer aaLONG_INT 8 12 aaLvlCodeString aaLvlCodeString String STR50 50 13 Balance Balance Currency DLR19_$S2 19