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.
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.
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!
Thanks heaps for this, it would be good to get a full diagram of these. I am always getting asks for a full diagram.
Glenn, If you are looking at table relationships in Dynamics GP as a diagram, you can install the SDK for Dynamics GP, which has these diagramatic representation of GP tables.
You can also get details of Dynamics GP 2010 table objects from the link msdynamicstips.com/.../database-sdk. Hope this helps.
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.
Posting by Mark Polino at DynamicAccounting.net
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.