Re-sequencing of fields in Data Management in D365 F&SCM

Recently we got a required to rearranging/resequencing of fields when we export the data from Data Management framework for in Excel or CSV format.

Below are the steps we can do that :

  • Create a export data project

  • Add the entity for which data need to to exported

  • Once entity is add in the selected entities list there is a option Entity Attribute

  • What entity attribute form do? It provide the list of Fields and there sequence.

  • As shown below you can arrange the order in which data required for Integration layer or based 3rd Party Integration data mapping .
  • Now when ever we export or 3rd Party make a call to this data project it will export the data in define format.