Technical Episode 4 What are EDTs in D365Fo and How to create string EDTs and add it to tables

Описание: EDTs in Dynamics 365 Finance and Operations
Extended Data Types (EDTs) in Dynamics 365 Finance and Operations are user-defined data types that extend the standard data types provided by the system. They allow you to create custom data types with specific properties and validation rules.

Creating String EDTs:

Navigate to Data Management: Go to Data Management Data Entities.
Create a New Data Entity: Click New to create a new data entity.
Define Entity Details: Specify the entity name, description, and data type for each field.
Create a New EDT: In the Fields section, click New to create a new field.
Set Data Type: Select EDT as the data type.
Define EDT Properties:
Name: Enter a descriptive name for the EDT.
Data Type: Choose String from the available options.
Length: Specify the maximum length of the string.
Validation: Set any required validation rules (e.g., mandatory, regular expressions).
Save and Close: Save the EDT and close the data entity form.
Adding the EDT to Tables:



To create a string EDT named "CustomerCategory" and add it to the "Customer" table:

Create a new EDT named "CustomerCategory" with a string data type and a maximum length of 50 characters.
Open the "Customer" data entity.
Add a new field named "CustomerCategory" and set its data type to the previously created "CustomerCategory" EDT.
Save the changes.
Now you can use the "CustomerCategory" EDT in your Dynamics 365 FO applications to store and validate customer category information.

Additional Tips:

You can create complex EDTs with multiple fields and validation rules.
EDTs can be used in various places within Dynamics 365 FO, such as forms, reports, and workflows.
Consider using existing EDTs provided by Dynamics 365 FO if they meet your requirements.
By following these steps, you can effectively create and use string EDTs to extend the functionality of Dynamics 365 Finance and Operations.