Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Data Type, Length and other details of Data Entity Columns

(1) ShareShare
ReportReport
Posted on by 1,874
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 567 on at
    Data Type, Length and other details of Data Entity Columns
    Hi,
    You can try Entity attribute.
     
     
  • MYGz Profile Picture
    MYGz 1,874 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... 291,904 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,874 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... 291,904 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? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans