Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC40100
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Budget Setup
Physical Name: ENC40100
Technical Name: ENC_SetupLineSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Encumbrance Budget Setup'].CMPANYID AS 'Encumbrance Budget Setup-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
ENC40100 AS ['Encumbrance Budget Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Encumbrance Budget Setup'].CMPANYID = ['Company Master'].CMPANYID2 BUDGETID Budget ID String STR15_LBAU 15 Key to the Budget Master (GL00200).
Click to show/hide
SELECT
['Encumbrance Budget Setup'].BUDGETID AS 'Encumbrance Budget Setup-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
ENC40100 AS ['Encumbrance Budget Setup']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['Encumbrance Budget Setup'].BUDGETID = ['Budget Master'].BUDGETID3 DSCRIPTN Description String STR30 30 4 YEAR1 Year Integer Year 4 5 From_Date From Date Date DATE 6 6 TODATE To Date Date DATE 6 7 ENCAAValidationType ENC_AAValidationType Integer ENC_AAValidationType 0 8 aaBudgetID aaBudgetID Long Integer Long Int 8 9 aaBudget aaBudget String STR15_LBAU 15 10 aaBudgetTreeID aaBudgetTreeID Long Integer aaLONG_INT 8 11 aaBudgetTree aaBudgetTree String STR15_LBAU 15 12 FiscalYear FiscalYear Integer Year 4