Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM40105
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM VendorAnalysis Options Setup
Physical Name: PM40105
Technical Name: PM_VendorAnalysis_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
['PM VendorAnalysis Options Setup'].USERID AS 'PM VendorAnalysis Options Setup-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM40105 AS ['PM VendorAnalysis Options Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM VendorAnalysis Options Setup'].USERID = ['Users Master'].USERID2 OptionSelected_1 Option Selected[1] Boolean CB 0 3 OptionSelected_2 Option Selected[2] Boolean CB 0 4 OptionSelected_3 Option Selected[3] Boolean CB 0 5 OptionSelected_4 Option Selected[4] Boolean CB 0 6 OptionSelected_5 Option Selected[5] Boolean CB 0 7 OptionSelected_6 Option Selected[6] Boolean CB 0 8 OptionSelected_7 Option Selected[7] Boolean CB 0 9 OptionSelected_8 Option Selected[8] Boolean CB 0