Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP50600
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Sales ID Setup Temp
Physical Name: SOP50600
Technical Name: sopIDSetupTempSeq 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
['Sales ID Setup Temp'].USERID AS 'Sales ID Setup Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SOP50600 AS ['Sales ID Setup Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Sales ID Setup Temp'].USERID = ['Users Master'].USERID2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 DOCID Document ID String STR15_LBAU 15 4 Password_Required Password Required Boolean CB 0 5 PASSWORD Password String STR15_LB 15 6 DUMYPSWD Dummy Password String STR15_LB 15 7 Password_Valid Password Valid Integer INT 0