Data Type, Length and other details of Data Entity Columns

(1) Share

Report

Posted on by MYGz

2,473

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)

Sort by

André Arnaud de Cal... 306,446 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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,473 on at

Like (0)

Report
Copy link

Link copied!

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... 306,446 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,473 on at

Like (0)

Report
Copy link

Link copied!

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 687 on at

Like (2)

Report
Copy link

Link copied!

Hi,
You can try Entity attribute.

1 people found this reply helpful.

Was this reply helpful? Yes No