Command Customizations (SY07105)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY07105

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Command Customizations
Physical Name: SY07105
Technical Name: syCmdCustomization

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Command Customizations'].USERID AS 'Command Customizations-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY07105 AS ['Command Customizations']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Command Customizations'].USERID = ['Users Master'].USERID
2CmdDictID SearchCmdDictIDID_INTInteger24
3CmdFormID SearchCmdFormIDINT5_RU0Integer25
4CmdID SearchCmdIDINT5_RU0Integer25
5CmdCaption SearchCmdCaptionSTR79String8079
6CmdTooltip SearchCmdTooltipSTR79String8079
7CmdNormalImageType SearchCmdNormalImageTypeDDL_PictureFormatInteger20
8CmdNormalImageDictID SearchCmdNormalImageDictIDID_INTInteger24
9CmdNormalImageResID SearchCmdNormalImageResIDINT5_RU0Integer25
10CmdCheckedImageType SearchCmdCheckedImageTypeDDL_PictureFormatInteger20
11CmdCheckedImageDictID SearchCmdCheckedImageDictIDID_INTInteger24
12CmdCheckedImageResID SearchCmdCheckedImageResIDINT5_RU0Integer25
13CmdMenuDisplayOption SearchCmdMenuDisplayOptionDDL_CmdMenuDisplayOptionsInteger20
14CmdButtonDisplayOption SearchCmdButtonDisplayOptionDDL_CmdButtonDisplayOptionsInteger20
15DEX_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 *