Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT00001
Product: Extender (3107)
Series: System
Display Name: Extender Resource List
Physical Name: EXT00001
Technical Name: EXT_Extender_Resource_ListSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Resource_Number 
Extender Resource Number Long_10U Long Integer 10 2 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Extender Resource List'].CMPANYID AS 'Extender Resource List-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
EXT00001 AS ['Extender Resource List']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Extender Resource List'].CMPANYID = ['Company Master'].CMPANYID3 Extender_Type Extender Type INT5 Integer 4 4 Extender_ID Extender ID STR15_LBAU String 15