Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY00100
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: System Database Name
Physical Name: SY00100
Technical Name: sySystemDBSeq 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
['System Database Name'].CMPANYID AS 'System Database Name-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
SY00100 AS ['System Database Name']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['System Database Name'].CMPANYID = ['Company Master'].CMPANYID2 DBNAME Database Name String STR10_LBAU 10