web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / xRMCenter / Data Types in Microsoft Dyn...

Data Types in Microsoft Dynamic CRM

Views (7661)
nghieppham Profile Picture nghieppham 4,755

Data type is very important to design any LOB application, this article will discuss about data types which being avaiable in Micrsoft Dynamic CRM (2015 version and later). 

Microsoft Dynamic CRM’s data type

All data types of Microsoft Dynamic CRM are listed in following table.

Data Type Specification
 Single line of text
  •  Single line of text is used for single lines of text.
  • Support a maximum of 4,000 characters.
  • Using Options
    • Email:
    • Text
    • Text area
    • URL
    • Ticker Symbol
    • Phone:
 Option sets
  •  It is look like drop down list in Web page or combobox window form. It provide several options for selecting.
  • Just 1 value can be selected.
  • Storing the text as Title and integer as Vaue.
  • Entity table just store the Value in database, other information are stored in stringmap table.
  • There are 2 type of optionSet
    • Global
      • Created in solution and can be refered to any local optionSet.
    • Local
      • specify to entity only
 Two options
  •  It is Boolean Vaue
  • Yes/No is default option, can be renamed as needs
  • Can be set default option
  • Can be format the Control
    • Traditional (2 radio buttons)
      • It was shown as Toggle button from 2013 version to later version.
    • Check box
    • List
 Images
  •  Storing image of entity.
  • Only 1 field supports for per entities.
  • There are 24 system entities where an image field is
    available.
  • Supported format
    • BMP, GIF, JPG, JPEG,PNG, TIFF, TIF
  • 5120KB is default configuration, we can change in System Settings
 Whole numbers
  • Using to store whole integer values.
  • Range from -2147483648 and +2147483647
  • Support for several formats
    • None: This is the default integer format.
    • Duration: This option provides a drop-down field with value options for minutes, hours, and days; this option should be only used when we want to represent time: durationTime zone.
    • Language: This option can be used to select language options based on the language packs installed.
 Floating point numbers
  •  Using to store fraction values.
  • Range from -100000000000 to +100000000000
 Decimals
  •  Using to store store decimal numbers.
  • Range from -100,000,000,000.00 and 100,000,000,000.00.
 Currency
  •  Using to store money values.
  • Range from -922,337,203,685,477.0000 and 922,337,203,685,477.0000
  • 4 fields will be created automatically when 1 currency is added to entity.
    • prefix_fieldname: Store the value entered by the user.
    • Currency: Lookup field is created for currency.
    • ExchangerateStores: The exchange rate value, based on the currency setup
    • Prefix_fieldname_base: value of the amount that is entered in the first field in the base currency
 Multiple lines of text
  •  Using to store multiple lines of text.
  • Supporting for 1,048,576 characters.
 Date and time
  •  Using to store date and time information.
  • Supporting for 2 format control
    • Date Only
    • Date Time
  • Value are stored as Coordinated Universal Time (UTC).
  • Data values automatically converted to the date and time format selected in the user’s personal settings.
 Lookup
  •  Using to store  values which setup n:1 relationships between entities.
  • Can select our target entity to set a relationship.
  • it is available as a lookup control that provides a list of available and related records for selection when clicked

Field Properties

Every time you create new field, rember that there are several properties that you can configure this field. All properties are decribled as following points:

  • Display Name: The label of the field, visible in all the places where field is
    referenced such as forms, views, and reports.
  • Name: The logical name of the field; it is used while coding for Microsoft
    Dynamics CRM 2015.
  • Description: This is used to provide additional information or setup tooltips
    for the field.
  • Field Requirement: The requirement level of the fields. It has three options:
    • Business Required, which is mandatory;
    • Business Recommended, which means it is recommended for business: and Optional.
  • Searchable: This property defines whether we can query the entity record
    based on this field or not using advanced find.
  • Field Security: Used to protect fields based on the field level security profile;
    we can configure the field level security for both custom and system fields.
  •  Auditing: Used to keep track of the changes in field value; provides two
    options, Enable or Disable.
  •  Date Type: Available data types in Microsoft Dynamics CRM 2015; we can
    select them based on the data that we want to store in a field.
  • Field Type: Dependent on the data type selected. It has three options:
    • Simple,
    • Calculated
    • Rollup.
  • Format: Allows us to format fields based on the data type selected.


This was originally posted here.

Comments

*This post is locked for comments