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 TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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_INTInteger4
3CmdFormID SearchCmdFormIDINT5_RU0Integer5
4CmdID SearchCmdIDINT5_RU0Integer5
5CmdCaption SearchCmdCaptionSTR79String79
6CmdTooltip SearchCmdTooltipSTR79String79
7CmdNormalImageType SearchCmdNormalImageTypeDDL_PictureFormatInteger0
8CmdNormalImageDictID SearchCmdNormalImageDictIDID_INTInteger4
9CmdNormalImageResID SearchCmdNormalImageResIDINT5_RU0Integer5
10CmdCheckedImageType SearchCmdCheckedImageTypeDDL_PictureFormatInteger0
11CmdCheckedImageDictID SearchCmdCheckedImageDictIDID_INTInteger4
12CmdCheckedImageResID SearchCmdCheckedImageResIDINT5_RU0Integer5
13CmdMenuDisplayOption SearchCmdMenuDisplayOptionDDL_CmdMenuDisplayOptionsInteger0
14CmdButtonDisplayOption SearchCmdButtonDisplayOptionDDL_CmdButtonDisplayOptionsInteger0
15DEX_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 *