Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY04911
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Email Temp
Physical Name: SY04911
Technical Name: syEmailTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Identity_Column 
Identity Column Long Integer Identity Column 0 2 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Email Temp'].USERID AS 'Email Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY04911 AS ['Email Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Email Temp'].USERID = ['Users Master'].USERID3 MODULE1 Module Integer DDL 0 4 DOCTYPE Document Type Integer DDL_Document_Type 0 5 EmailMessageFrom Email Message From String STR255 255 6 EmailSubject Email Subject String STR255 255 7 AllowMultipleAtt Email Allow Multiple Attachments Boolean CB 0 8 DICTRYID Dictionary ID Integer DDL_Dictionary 0 9 EmailMessageID Email Message ID String STR25_LBAU 25 10 Master_ID Master ID String STR30_LBAU 30 11 EmailToAddress Email To Address Text TX32000 32000 12 EmailCcAddress Email Cc Address Text TX32000 32000 13 EmailBccAddress Email Bcc Address Text TX32000 32000 14 EmailReplyToAddress Email Reply To Address Text TX32000 32000 15 EmailBody Email Body Text TX32000 32000