List View Options (SY07225)

Easily find this page again using the shortlink: https://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 TypeLength
1ListDictID SearchListDictIDID_INTInteger4
2ListID SearchListIDID_INTInteger4
3ViewID SearchViewIDLI_MasterNumberLong Integer9
4USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

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_PreviewPaneVisibleBoolean0
6PreviewPaneHeight SearchPreviewPaneHeightINTInteger0
7AdvFilterPaneVisible SearchAdvFilterPaneVisibleCB_AdvFilterPaneVisibleBoolean0
8AdvFilterPaneHeight SearchAdvFilterPaneHeightINTInteger0
9ActionsPaneVisible SearchActionsPaneVisibleCB_ActionsPaneVisibleBoolean0
10IncludeWorkflowInfo SearchIncludeWorkflowInfoCB_IncludeWorkflowInfoBoolean0
11ListDateRestriction SearchListDateRestrictionLong IntLong Integer8
12STRTDATE SearchStart DateDTDate8
13ENDDATE SearchEnd DateDTDate8
14ListOption SearchListOptionLong IntLong Integer8
15FactBoxVisible SearchFactBoxVisibleBooleanBoolean0
16FactBoxWidth SearchFactBoxWidthINTInteger0
17FactBoxMode SearchFactBoxModeINTInteger0
18FactBoxSRAVisible SearchFactBoxSRAVisibleBooleanBoolean0
19FactBoxSRAHeight SearchFactBoxSRAHeightINTInteger0
20FactBoxSRADockMode SearchFactBoxSRADockModeINTInteger0
21ListOption2 SearchListOption2Long IntLong Integer8
22DEX_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 *