Email Functionality in Dynamics GP – Some Table Definitions


Sivakumar Venkataraman - Click for blog homepageThis is a reposting of an article Sivakumar Venkataraman originally wrote on my Developing for Dynamics GP blog.

Recently, I was working on a community forum request, where the user was requesting for table structure documentation for the email tables in Microsoft Dynamics GP. I have explained some of them in this article for the benefit of the community.

Table: SY04904 (Email Card Setup)
This table is populated with values from the “Select Document Options” section from the Customer Email options (or) Vendor Email options window which opens from the Email Button on the Customer and Vendor Maintenance windows respectively.

  • EmailDictionaryID – 0 (Indicating the dictionary ID of the product where email details are configured. In this case standard  Dynamics GP dictionary ID)
  • EmailSeriesID – 3 (for Sales) & 4 (for Purchasing)
  • EmailCardID – Customer ID or Vendor ID
  • EmailAllowEmbedding – 0 (for False) & 1 (for True)
  • EmailAllowAttachments – 0 (for False) & 1 (for True)
  • AllowMultipleAtt – 0 (for False) & 1 (for True)
  • EmailSetFileSize – 0 (for False) & 1 (for True)
  • EmailMaxFileSize – (Max File size defined in the window)

Table: SY04905 (Email Card Documents)
This table is populated with values from the “Send Forms as E-mail” section from the Customer Email options (or) Vendor Email options window which opens from the Email Button on the Customer and Vendor Maintenance windows respectively.

  • EmailDictionaryID – 0 (Indicating the dictionary ID of the product where email details are configured. In this case standard  Dynamics GP dictionary ID)
  • EmailSeriesID – 3 (for Sales) & 4 (for Purchasing)
  • MODULE1 – 9 (for SOP), 11 (for Receivables), 12 (for POP) & 19 (for Payables)
  • EmailCardID – Customer ID or Vendor ID
  • EmailDocumentID – This is a unique integer indicating each type of document displayed in the window
  • EmailDocumentEnabled – 0 (for False) & 1 (for True)
  • EmailMessageID – Value from the window
  • EmailDocumentFormat – Based on drop down value chosen in the window

Table: SY04910 (Email Details)
This table contains the details of the emails captured at the various transaction levels in the Email Detail Entry window. For e.g.: If you have any email detail captured from the Email icon button next to the Customer ID field on the SOP Entry window, it will be captured in this table. You should be able to correlate these table fields from the window fields respectively.

Hope these details help the community…

Until next post!

Siva

This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.

4 thoughts on “Email Functionality in Dynamics GP – Some Table Definitions

  1. Another interesting piece of information which is related to same topic is – the spot where we store the default email for customer and vendors. I believe now the Internet Information Window which opens from the "I" button on Customer/Vendor has been enhanced to display To, CC and BCC fields. These default on the Email Details Window.
    Can you please add this as well?
    Also I am curious if these have been exposed on eConnect, if not what is the plan and tentative schedule.

    Like

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.