How to get te Email address relates to Address of a Customer ?

(1) Share

Report

Posted on by harshil9898

I have a requirement where i want a Email address of a customer related to its Business Address. Is there any way to get that using SQL ? Or where can i find that on frontend ?

Thanks in advance :)

Categories:

Microsoft Dynamics AX

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Abhilash Warrier 4,892 Super User 2025 Season 2 on at

Like (1)

Report
How to get te Email address relates to Address of a Customer ?

Hey,

If you want to review individual Customer records, please follow the step advised by @Adis.

If you want to export the details in bulk you can try using the Data Management framework and export the data for that particular data entity.

I believe it should be Customer Postal Address , but please check further.

CustomerPostalAddressEntity
This entity includes:

Customer account number

Address details (street, city, ZIP/postal code, country, etc.)

Validity dates

Address purpose (delivery, invoice, etc.)

If this helped, please mark it as "Verified" for others facing the same issue.
Keep in mind that it is possible to mark more than one answer as verified.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Adis 5,502 Super User 2025 Season 2 on at

Like (0)

Report

How to get te Email address relates to Address of a Customer ?

Hi,

On the frontend you see it here:

Its stored in this table, however, the 'Purpose' is not visible.

From your previous question regarding this you can modify the sql statement by putting the purpose in the where line.

Solved: How to get unique email addresses of customer ?

'

-Select distinct T1. locator, T2. AccountNum from dirPartyContactInfoView T1JOIN Custtable T2 ON T1.PARTY =T2.PARTY

WHERE T1.Type = LogisticsElectronicAddressType = Email.. (Unable to recall enum value).

'

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No