Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

(0) Share

Report

Posted on by richierich79

300

I have seen that email addresses along with telephone numbers are stored in dbo.LOGISTICSELECTRONICADDRESS. Customer emails can be accessed through relationships between DIRPARTYTABLE, DIRPARTYLOCATION, and LOGISTICSELECTRONICADDRESS.

Looking at these tables there doesn't appear to be any flag to determine a usage of these email addresses (e.g. Default, payroll). Is it possible to assign a flag such as this to an email address, and where would it be stored?

Many thanks

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

Hello richierich79

Seems like you are on a old 2012 version.

Currently I do not have this version on hand to verify.

Judging from a later version.

The Roles StringEdit control have Autodeclaration property set to "Yes".

The form has a specific handler class called "LogisticsEntityContactInfoFormHandler" under AOT\Classes.

On the version I have, Roles is being populated under write method.

Hope this could provide you some starting points on figuring out where the role information is stored in this version.

Thanks
richierich79 300 on at

Like (0)

Report

RE: Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

Hi Uday

So you know I'm a .Net dev learning Ax

I've taken a look at the form in the AOT and taken a look at the Design. From what I can see it uses the extended datatype DirPartyContactLocationRoleNames but I can't see where it specifically gets the data from. Any pointers on where to find this would be greatly appreciated.
udaY-ch 4,624 on at

Like (0)

Report

RE: Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

Hi,

Can you tell me, the location of the purpose field in your screen. Field and table name

Best,

Uday.
richierich79 300 on at

Like (0)

Report

RE: Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

I don't know if this is a version issue but I don't have a LogisticsElectronicAddressRole table in the database.

My contact for looks like this...

and here is a screenshot of my Logistics tables in SQL....
udaY-ch 4,624 on at

Like (0)

Report

RE: Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

Hi,

The relation is LogisticsElectronicAddress.RecId = LogisticsElectronicAddressRole.ElectrnoicAddress and LogisticsElectronicAddressRole.LocationRole = LogisticsLocationRole.RecId

Hope this helps

Best,

Uday.
richierich79 300 on at

Like (0)

Report

RE: Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

Hi David

Im happy to accept your answer with one added point. I couldn't find a table or column called "LogisticsElectronicAddressRole".

I appreciate this could be down a different version, I am using Dynamics 2012 R2,

I have found a relationship between [dbo].[LOGISTICSELECTRONICADDRESS].[LOCATION] and [dbo].[LOGISTICSLOCATIONROLE] .[RECID]

Could you confirm this is correct?
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Email addresses Flag for addresses stored in dbo.LOGISTICSELECTRONICADDRESS

Hello richierich79

On the email, there are certain tags you can associate with.

You can enable additional tags under "Organization administration > Setup > Global address book > Address and contact information purpose"

The address and its associated tags are stored under Table\LogisticsElectronicAddressRole.

Thanks