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.
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?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.