syUpdates (SYUPDATE)

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: syUpdates

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1UPDATENAME SearchUpdate NameSTR40String40
2POST SearchPostBooleanBoolean0
3UNCPATH SearchUNCPathSTR255String255
4UPDATEFILE SearchUpdate File NameSTR40String40
5NOTEINDX SearchNote IndexDLR14Currency14
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
6DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *