Finance | Project Operations, Human Resources, ...

What is the relation between VendTable and LogisticsElectronicAddess

(0) Share

Report

Posted on by Akbarpasha

Hi All,

I need to get the list of Vendors not having email address as "IsPrimary" not checked, trying to find the relation, but somehow not able to get the exact relation with LogisticsElectronicAddress.

Found the below tables related:

1. VendTable,

2. DirPartyTable,

3. DirPartyView

4. LogisticsElectronicAddress.

Please advice how can i get the list of Vendors not having "IsPrimary" email address checked.

Regards,

Akbar

All responses (4)

Answers (0)

Akbarpasha on at

Like (0)

Report

RE: What is the relation between VendTable and LogisticsElectronicAddess

Thank you Girish and Mohit, it helped me to get the required data.

Thanks again for your help.
GirishS 27,821 Super User 2024 Season 1 on at

Like (1)

Report

RE: What is the relation between VendTable and LogisticsElectronicAddess

You can follow Mohit suggestions.

But I think the view will be much better as it will remove extra joins on the select statement.

Just join VendTable.Party == DirPartyContactInfoView.Party and DirPartyContactInfoView.IsPrimary == NoYes::No to get the non-primary email address.

Thanks,

Girish S.
Suggested answer

Mohit Rampal 12,552 Super User 2024 Season 1 on at

Like (0)

Report

RE: What is the relation between VendTable and LogisticsElectronicAddess

Hi Akbarpasha, Please check email method in VendTable, all relationship is defined there.

For primary email, the relation is VendTable.party == DirPartyTable.RecId and DirPartyTable has relation with LogisticsElectronicAddress table DirPartyTable.PrimaryContactEmail == logisticsElectronicAddress.RecId

Below code will give the primary email address of vendor, you can leverage it to find party field from VendTable and check if related record exists in LogisticsElectronicAddress table.
Suggested answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (0)

Report

RE: What is the relation between VendTable and LogisticsElectronicAddess - D365FO

Hi Akbarpasha,

You can make use of the "DirPartyContactInfoView" to get the email address of the vendor which is not primary.

All the details is available in that view. You can open that in table browser and have a look at it you will get some idea.

Thanks,

Girish S.