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

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
richierich79 300 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Hope this helps

Best,

Uday.

Was this reply helpful? Yes No
richierich79 300 on at

Like (0)

Report
Copy link

Link copied!

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....

Was this reply helpful? Yes No
udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Best,

Uday.

Was this reply helpful? Yes No
richierich79 300 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No