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, ... Mandatory fields of Da...

Finance | Project Operations, Human Resources, ...

Answered

Mandatory fields of Data Entity

(3) Share

Report

Report

Posted on by MacNeg

167

Hello,

When using data entity thru DMF to import or update data in D365 FAO, how to quickly determine the mandatory fields to be included in the import file? Is there a way to see this thru X++ code (is it the primary key setup)? I did a copilot and suggested checking the staging table in SQL DB but all fields are set to not null constraints.

Thanks!

Joseph

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

CA Neeraj Kumar 5,099 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi Joseph,

To check which field is mandatory and which are part of Key, you can simply create a export project, add your data entity, and click on Entity Attribute

Here we can see, the fields which are mandatory and which are part of key.

The entity attributes get stored in table : DMFDefinitionGroupEntityXMLFields (only for those entities, which are part of any data projects).

Regards,

Neeraj Kumar

1 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 617

#2

André Arnaud de Cal... 461 Super User 2026 Season 1

#3

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans