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 TypeSQL DB LengthKeyable Length
1UPDATENAME SearchUpdate NameSTR40String4240
2POST SearchPostBooleanBoolean20
3UNCPATH SearchUNCPathSTR255String256255
4UPDATEFILE SearchUpdate File NameSTR40String4240
5NOTEINDX SearchNote IndexDLR14Currency1014
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 Searchintint1010

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 *