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

I have the same question (0)

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.

Was this reply helpful? Yes No
GirishS 27,825 Moderator 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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator 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.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,825 Moderator 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.

Was this reply helpful? Yes No