Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM40701
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM CustAnalysis Options SETP
Physical Name: RM40701
Technical Name: RM_CustAnalysis_Options_SETPSeq 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
['RM CustAnalysis Options SETP'].USERID AS 'RM CustAnalysis Options SETP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM40701 AS ['RM CustAnalysis Options SETP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM CustAnalysis Options SETP'].USERID = ['Users Master'].USERID2 RMOptionMarked_1 RM Option Marked[1] Boolean CB 0 3 RMOptionMarked_2 RM Option Marked[2] Boolean CB 0 4 RMOptionMarked_3 RM Option Marked[3] Boolean CB 0 5 RMOptionMarked_4 RM Option Marked[4] Boolean CB 0 6 RMOptionMarked_5 RM Option Marked[5] Boolean CB 0 7 RMOptionMarked_6 RM Option Marked[6] Boolean CB 0 8 RMOptionMarked_7 RM Option Marked[7] Boolean CB 0 9 RMOptionMarked_8 RM Option Marked[8] Boolean CB 0 10 RMOptionMarked_9 RM Option Marked[9] Boolean CB 0 11 RMOptionMarked_10 RM Option Marked[10] Boolean CB 0 12 RMOptionMarked_11 RM Option Marked[11] Boolean CB 0 13 RMOptionMarked_12 RM Option Marked[12] Boolean CB 0 14 RMOptionMarked_13 RM Option Marked[13] Boolean CB 0 15 RMOptionMarked_14 RM Option Marked[14] Boolean CB 0