List View Options (SY07225)

Easily find this page again using the shortlink: http://gpt.azrcrv.co.uk/SY07225

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: List View Options
Physical Name: SY07225
Technical Name: syListViewOptions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ListDictID SearchListDictIDID_INTInteger24
2ListID SearchListIDID_INTInteger24
3ViewID SearchViewIDLI_MasterNumberLong Integer49
4USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide example SQL

SELECT
       ['List View Options'].USERID AS 'List View Options-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY07225 AS ['List View Options']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['List View Options'].USERID = ['Users Master'].USERID
5PreviewPaneVisible SearchPreviewPaneVisibleCB_PreviewPaneVisibleBoolean20
6PreviewPaneHeight SearchPreviewPaneHeightINTInteger20
7AdvFilterPaneVisible SearchAdvFilterPaneVisibleCB_AdvFilterPaneVisibleBoolean20
8AdvFilterPaneHeight SearchAdvFilterPaneHeightINTInteger20
9ActionsPaneVisible SearchActionsPaneVisibleCB_ActionsPaneVisibleBoolean20
10IncludeWorkflowInfo SearchIncludeWorkflowInfoCB_IncludeWorkflowInfoBoolean20
11ListDateRestriction SearchListDateRestrictionLong IntLong Integer48
12STRTDATE SearchStart DateDTDate48
13ENDDATE SearchEnd DateDTDate48
14ListOption SearchListOptionLong IntLong Integer48
15FactBoxVisible SearchFactBoxVisibleBooleanBoolean20
16FactBoxWidth SearchFactBoxWidthINTInteger20
17FactBoxMode SearchFactBoxModeINTInteger20
18FactBoxSRAVisible SearchFactBoxSRAVisibleBooleanBoolean20
19FactBoxSRAHeight SearchFactBoxSRAHeightINTInteger20
20FactBoxSRADockMode SearchFactBoxSRADockModeINTInteger20
21ListOption2 SearchListOption2Long IntLong Integer48
22DEX_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 *