Data Type, Length and other details of Data Entity Columns

(1) Share

Report

Posted on by MYGz

2,059

Hi,

If I want to get all the details about the fields in a data entity, for eg. Vendors V2 (details like field type, field length if it's string, etc), whats the best approach?

I can export the table column definition from SSMS on dev server, but is there a better approach?

Best Regards,

Mohammad Yusuf

I have the same question (0)

All responses (5)

Answers (1)

André Arnaud de Cal... 299,415 Super User 2025 Season 2 on at

Like (1)

Report

Data Type, Length and other details of Data Entity Columns

Hi Mohammad,

Do you need to have the column definitions from a few entities just once? Or are you looking for something dynamic to retrieve information depending on e.g. configuration? Do you need the SQL types, or the types used in Dynamics 365 itself? E.g. a F&O enumeration is an integer in SQL. Can you tell more about the purpose and what you will do with the information once you have the column definition?

Was this reply helpful? Yes No
MYGz 2,059 on at

Like (0)

Report

Data Type, Length and other details of Data Entity Columns

Hello @Andre

Yeah, I wanted to have the column definitions of few entities just once. Dynamics Data Types would be preferred but SQL would suffice if that's not possible.

Appreciate any tips.

Thanks.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 299,415 Super User 2025 Season 2 on at

Like (0)

Report

Data Type, Length and other details of Data Entity Columns

Hi Mohammad,

If it is for a few entities only, you can look at the staging tables for the data types used. You can find type information for the fields in the system table SQLDictionary. You can first find a record with the name of the staging table. Then you know the table ID. Using that table ID, you can find the fields for that table in the same SQLDictionary table.

Was this reply helpful? Yes No
MYGz 2,059 on at

Like (0)

Report

Data Type, Length and other details of Data Entity Columns

Hello @Andre

The SQLDictionary table has FieldType column which have the following values:

49: (BigInt)
8:VarString
6:UtcDateTime
4:Enum
3:Date
2:Real
1:Integer
0:String

Out of these values, I need to drill down on 2 types of values i.e 4:Enum and 8:VarString (Which is EDT?)

How can I get the enumType used on the field and subsequently it's values. Similarly the EDTType and it's length/values.

Best Regards,

Was this reply helpful? Yes No
Verified answer

Ankit Life 681 on at

Like (2)

Report

Data Type, Length and other details of Data Entity Columns

Hi,
You can try Entity attribute.

1 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Data Type, Length and other details of Data Entity Columns

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Data Type, Length and other details of Data Entity Columns

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates