Dynamics 365 (CRM) Datatypes with equivalent SQL types and usage

  • CRM Data types
  • Single Line of Text
  • Multiple Lines of Text
  • Option Set
  • Multi Select Option Set
  • Two Options
  • Date and Time
  • Status
  • Status Reason
  • Whole Number
  • Floating Point Number
  • Decimal Number
  • Currency
  • Lookup
  • Customer
  • Sample values in CRM
  • Some Text
  • Some text
    of multiple
    lines
  • Option0
  • MSOption0; MSOption2
  • True
  • 28-04-2021 06:00
  • Active
  • Active
  • 2.147.483.647
  • 900.000.000,90
  • 90.000.000.000,22220
  • 922.337.203.685.401,00
  • Account A
  • Contact ABC
  • SQL Equivalent types
  • nvarchar(100)
  • nvarchar(max)
  • int
  • varchar(1700)
  • bit
  • datetime
  • int
  • int
  • int
  • float
  • decimal(32,10)
  • money
  • uniqueidentifier
  • uniqueidentifier
  • Sample values in DB
  • Some Text
  • Some text
    of multiple
    lines
  • 808000000
  • [-1,808000000,808000002,-1]
  • 1
  • 2021-04-28 06:00:00.000
  • 0
  • 1
  • 2147483647
  • 900000000,9
  • 90000000000,22220
  • 922337203685401,00
  • 65D7AD85-0BA8-EB11-A2D7-005056A428BA
  • 43E4DA9A-0BA8-EB11-A2D7-005056A428BA
  • Coding language types and CRM SDK
  • string
  • string
  • OptionSetValue
  • OptionSetValueCollection
  • bool
  • DateTime
  • OptionSetValue
  • OptionSetValue
  • int
  • float
  • decimal
  • Money
  • Guid
  • Guid
  • Comments
  • Single Line of Text
  • Multiple Lines of Text
  • (int, string) Text part is saved in another table StringMap
  • int, string collection; Text part is saved in another table StringMap
  • Two Options
  • Date and Time
  • (int, string) Text part is saved in another table StringMap
  • (int, string) Text part is saved in another table StringMap
  • Whole Number
  • Floating Point Number
  • Decimal Number
  • decimal
  • extra field gets creating holding Name
  • 2 extra fields gets created holding Name and type (contact or customer)