Skip to main content



No record found.

Dynamics 365 Community / Forums / Finance forum / Product name table loc...
Finance forum

Product name table location?

Posted on by 436

I'm looking at all the product-related tables in D365FO (in the Data Lake). I can see the Product identifiers on our system, but cannot find the corresponding product names anywhere (I need to link both up to product category names after I achieve this). Any ideas which table stores the product names in?

FWIW I regret the day that Microsoft stopped publishing the ERDs on the system (back in AX2012 history). Most of my life in Power BI these days is searching for the tables and then the join relationships.

Ian W.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 225,549 Super User on at
    RE: Product name table location?

    Are you aware of EcoResProductTranslation table?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans