Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC40000
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Setup
Physical Name: ENC40000
Technical Name: ENC_SetupSeq 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 Setup'].CMPANYID AS 'Encumbrance Setup-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
ENC40000 AS ['Encumbrance Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Encumbrance Setup'].CMPANYID = ['Company Master'].CMPANYID2 ENABLED Enabled Boolean Boolean 0 3 LIQDOPTN Liquidated Option Integer Liquidated Option 0 4 TOLCOPTN Tolerance Option Integer INT 0 5 TOLRANCE Tolerance Currency DLR11_$U5 11 6 POAOPTN POA Option Integer INT 0 7 PASSWORD Password String STR15_LB 15 8 TRKGOPTN Tracking Option Integer Tracking Option 0 9 ENCVLDMTHD ENC Validation Method Integer ENC Validation Method 0 10 ENCMODE ENC Mode Integer INT 0 11 aaBudgetTree aaBudgetTree String STR15_LBAU 15 12 Enable_GL_Validation Enable GL Validation Integer INT 0 13 EnablePMValidation Enable PM Validation Boolean CB 0