web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Table inheritance in D...

Finance | Project Operations, Human Resources, ...

Answered

Table inheritance in D365 FO

(0) Share

Report

Report

Posted on by Community Member

Hello Community,

I have a question regarding the table inheritance in D365FO if you may answer.

How are the base and derived tables are represented in SQL ?

I was checking for EcoResProduct (Base) and EcoResDistinctProduct (Derived) but I only find the EcoResProduct table in SQL database.

Thanks.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (0)

Report

Your findings are correct. The database contains just a single table for the whole hierarchy. InstanceRelationType identifies the actual type. Fields that aren't defined for a particular subtype contain NULL.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 467 Super User 2025 Season 2

#2

Martin Dráb 420 Most Valuable Professional

#3

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans