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 TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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 Integer410
3TYPEID SearchType IDINTInteger20
4CmdID SearchCmdIDINT5_RU0Integer25
5CmdFormID SearchCmdFormIDINT5_RU0Integer25
6CmdDictID SearchCmdDictIDID_INTInteger24
7DSPLNAME SearchDisplay NameSTR80String8280
8ScbTargetStringOne SearchScbTargetStringOneSTR255String256255
9ScbTargetStringTwo SearchScbTargetStringTwoSTR255String256255
10ScbTargetStringThree SearchScbTargetStringThreeSTR255String256255
11ScbTargetLongOne SearchScbTargetLongOneLong IntLong Integer48
12ScbTargetLongTwo SearchScbTargetLongTwoLong IntLong Integer48
13ScbTargetLongThree SearchScbTargetLongThreeLong IntLong Integer48
14ScbTargetLongFour SearchScbTargetLongFourLong IntLong Integer48
15ScbTargetLongFive SearchScbTargetLongFiveLong IntLong Integer48
16DEX_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 *