Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY08100
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: syHomePageLayout
Physical Name: SY08100
Technical Name: syHomePageLayoutSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['syHomePageLayout'].USERID AS 'syHomePageLayout-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY08100 AS ['syHomePageLayout']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['syHomePageLayout'].USERID = ['Users Master'].USERID2 SectionID SectionID Integer INT 0 3 DICTID DictID Integer ID_INT 4 4 COLNUMBR Column Number Integer INT 0 5 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 6 Visible Visible Boolean CB_Visible 0 7 MetricSequence MetricSequence Long Integer LI_Sequence_Number 10 8 Selected Selected Boolean Boolean 0 9 Mode Mode Integer INT1 1