SQL query to get contact details for a vendor

(0) Share

Report

Posted on by Community Member

I have a need to retrieve contact addresses and emails for all vendors with current transactions.

According to the Query window from Personalisation VendTable joins to Dirparty then LogisticsElectronicAddress but I can't see what field joins the first two tables. Assuming it is RecId, a record in VendTable finds the incorrect record in DirParty (at least according to the data when viewed in AX).

Can anyone please help?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Anoop Tripathi 790 on at

Like (0)

Report
Copy link

Link copied!

party rec Id should be the field joining them.

Also are you in need of SQL query or and AX query/code ??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sorry it's an AX query that I need help with.

I found that VendTable.Party joins to DirPartyTable.RecId - obvious right?

Was this reply helpful? Yes No
Verified answer

Anoop Tripathi 790 on at

Like (0)

Report
Copy link

Link copied!

yes. Basically party recid uniquely related to all kind of party(customer,vendor etc. )

Was this reply helpful? Yes No