Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GTM41000
Product: Grant Management (4421)
Series:
Display Name: Grant Management Setup
Physical Name: GTM41000
Technical Name: GTM_Grant_SETPSeq 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
['Grant Management Setup'].CMPANYID AS 'Grant Management Setup-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
GTM41000 AS ['Grant Management Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Grant Management Setup'].CMPANYID = ['Company Master'].CMPANYID2 ENABLEGTM GTM_EnableGrantManagement Boolean GTM_CB_EnableGrantManagement 0 3 UNIQUEGRANTID GTM_UniqueGrantID Long Integer GTM_UniqueGrantID 8 4 USRDFPR1 User Defined Prompt 1 String STR15 15 5 USRDRPR2 User Defined Prompt 2 String STR15 15 6 USRDRPR3 User Defined Prompt 3 String STR15 15 7 USRDRPR4 User Defined Prompt 4 String STR15 15 8 USRDRPR5 User Defined Prompt 5 String STR15 15 9 USRDRPR6 User Defined Prompt 6 String STR15 15 10 USRDRPR7 User Defined Prompt 7 String STR15 15 11 USRDRPR8 User Defined Prompt 8 String STR15 15 12 USRDRPR9 User Defined Prompt 9 String STR15 15 13 USRDRP10 User Defined Prompt 10 String STR15 15 14 USRDRP11 User Defined Prompt 11 String STR15 15 15 USRDRP12 User Defined Prompt 12 String STR15 15 16 aaTrxDim aaTrxDim String aaSTR30_LBAU 30