Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Data Type, Length and ...
Finance forum
Answered

Data Type, Length and other details of Data Entity Columns

Posted on by 1,819
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
  • Verified answer
    Ankit Life Profile Picture
    Ankit Life 570 on at
    Data Type, Length and other details of Data Entity Columns
    Hi,
    You can try Entity attribute.
     
     
  • MYGz Profile Picture
    MYGz 1,819 on at
    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,
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,115 Super User 2024 Season 2 on at
    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.
  • MYGz Profile Picture
    MYGz 1,819 on at
    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.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,115 Super User 2024 Season 2 on at
    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? 

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans