Supply chain | Supply Chain Management, Commerce

Export Data Entity Fields, field attributes and enum values from D365 FO

(0) Share

Report

Posted on by Sumyo

Hi Team,

I need to get the list of Data entities, its associated tables, field attributes, enum values from D365 FO,

Can you please help, how can I get that

All responses (8)

Answers (0)

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

Yes, it needs an visual studio access and you need to add a logic to get fields data type informations.

Thanks,

Girish S.
Sumyo 62 on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

Thank, its loading the fields. I need to check the field attributes (data type, field length) and the enum values. I think, we can get from only Visual studio ?
Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

I found one more way - Navigate to system administration >> Data management >> click on "Data entities" tiles. Select any one of the entities and click on Target fields >> Click on the office icon on top right corner >> Select "Target XML" (Open in excel) - It will download the excel file >> You can sign into excel and it will load all the entities with entity fields. There will be thousands of records, So it will take time to retrieve all of those. Later you can save the excel as a field as you want.

Thanks,

Girish S.
Sumyo 62 on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

Thank you, I will need the full details, seems I need to get the visual studio access. Thanks for clarifying.
GirishS 27,825 Moderator on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

No you need to have visual studio to get the details of data entities.

You can see the list of entities under system administration >> Data management >> click on Data entities tiles - You can see the all the entities and related fields using target fields button on the action pane.

Thanks

Girish S.
Sumyo 62 on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

Thanks Girish, Is there any way to get from FO?
GirishS 27,825 Moderator on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

Hi Sumyo,

You can navigate to Visual studio >> Extensions. >> Dynamics 365 >> Addins >> Data Entity Report.

It will download the CSV excel file format with all the entity details.

Thanks,

Girish S.
Suggested answer

Mohit Rampal 12,558 Moderator on at

Like (0)

Report

RE: Export Data Entity Fields, field attributes and enum values from D365 FO

Hi Sumyo, Please provide more information on what's the requirement.

You can check this thread for list of Data Entities

community.dynamics.com/.../list-all-entities-in-dynamics-365-for-finance-and-operations

For Enums, you can check SRSAnalysisEnums table.

Community site session details

Export Data Entity Fields, field attributes and enum values from D365 FO

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Export Data Entity Fields, field attributes and enum values from D365 FO

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates