Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SYUPDATE
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: syUpdates
Physical Name: SYUPDATE
Technical Name: syUpdatesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 UPDATENAME 
Update Name String STR40 40 2 POST Post Boolean Boolean 0 3 UNCPATH UNCPath String STR255 255 4 UPDATEFILE Update File Name String STR40 40 5 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['syUpdates'].NOTEINDX AS 'syUpdates-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SYUPDATE AS ['syUpdates']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['syUpdates'].NOTEINDX = ['Record Notes Master'].NOTEINDX