Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

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

Posted on by 62

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

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    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 Profile Picture
    Sumyo 62 on at
    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 Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    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 Profile Picture
    Sumyo 62 on at
    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 Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    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 Profile Picture
    Sumyo 62 on at
    RE: Export Data Entity Fields, field attributes and enum values from D365 FO

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

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    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 Profile Picture
    Mohit Rampal 12,547 Super User 2024 Season 1 on at
    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.

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans