syHomePageQuickLinks (SY08140)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: syHomePageQuickLinks
Physical Name: SY08140
Technical Name: syHomePageQuickLinks

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['syHomePageQuickLinks'].USERID AS 'syHomePageQuickLinks-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY08140 AS ['syHomePageQuickLinks']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['syHomePageQuickLinks'].USERID = ['Users Master'].USERID
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
3TYPEID SearchType IDINTInteger0
4CmdID SearchCmdIDINT5_RU0Integer5
5CmdFormID SearchCmdFormIDINT5_RU0Integer5
6CmdDictID SearchCmdDictIDID_INTInteger4
7DSPLNAME SearchDisplay NameSTR80String80
8ScbTargetStringOne SearchScbTargetStringOneSTR255String255
9ScbTargetStringTwo SearchScbTargetStringTwoSTR255String255
10ScbTargetStringThree SearchScbTargetStringThreeSTR255String255
11ScbTargetLongOne SearchScbTargetLongOneLong IntLong Integer8
12ScbTargetLongTwo SearchScbTargetLongTwoLong IntLong Integer8
13ScbTargetLongThree SearchScbTargetLongThreeLong IntLong Integer8
14ScbTargetLongFour SearchScbTargetLongFourLong IntLong Integer8
15ScbTargetLongFive SearchScbTargetLongFiveLong IntLong Integer8
16DEX_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 *