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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sumyo 62 on at

Like (0)

Report

Thanks Girish, Is there any way to get from FO?

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sumyo 62 on at

Like (0)

Report

Thank you, I will need the full details, seems I need to get the visual studio access. Thanks for clarifying.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sumyo 62 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

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

Thanks,

Girish S.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates