Skip to main content

Dynamics CRM 2016/365 Data Types

Dynamics CRM 2016/365 Data Types

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 combo box window form. It provide several options for selecting.
  • Just 1 value can be selected.
  • Storing the text as Title and integer as Value.
  • Entity table just store the Value in database, other information are stored in string map table.
  • There are 2 type of option Set
    • Global
      • Created in solution and can be referred to any local option Set.
    • Local
      • specify to entity only
 Two options
  •  It is Boolean Value
  • 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: duration Time 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.
    • Exchange Rate Stores: 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

Comments

Popular posts from this blog

How to Integrate WhatsApp with Dynamics 365 Omnichannel – On Trial

How to Integrate WhatsApp with Dynamics 365 Omni Channel – On Trial Pre Requisites a.        Trail Environment with Customer Service Enabled, Preferably Netherlands as Location Ref : https://docs.microsoft.com/en-us/dynamics365/omnichannel/try-channels b.        Twilio Trial Account Ref : https://www.twilio.com/docs/usage/tutorials/how-to-use-your-free-trial-account#sign-up-for-your-free-twilio-trial Let’s Start the Configuration! Configuration: Dynamics 365 Channel Integration Framework - V2 1.        Go to dynamic 365 administration center via below link after logging to trial account https://port.crm4.dynamics.com/G/Applications/Index.aspx 2.        Make Sure Channel Integration Framework in Enabled, like in below screen shot else, configure it . By default, this should have enabled. Configuration: Omnichannel for Custo...

Delete record using JQuery and OData in Dynamics CRM 2011

function DeleteRecord(id, oDataSetName) {     var serverUrl = Xrm.Page.context.getServerUrl();     var ODATA_ENDPOINT = "/XRMServices/2011/OrganizationData.svc";     $.ajax({         type: "POST",         contentType: "application/json; charset=utf-8",         datatype: "json",         url: serverUrl + ODATA_ENDPOINT + "/" + odataSetName + "(guid'" + id + "')",         beforeSend: function (XMLHttpRequest) {             //results will be returned as JSON.              XMLHttpRequest.setRequestHeader("Accept", "application/json");             //HTTP method DELETE               XMLHttpRequest.setRequestHeader("X-HTTP-Method", "DELETE");         },         success: function (da...

How to attach refresh event on Dynamic CRM 2011 subgrid using Java Script / JQuery ?

// Attach the function OnFormLoad event function OnFormLoad() {     setTimeout("SubGridRefresh();", 2500 ); } function   SubGridRefresh() {     var subgrid = document.getElementById("subgridid");     if (subgrid.readyState != "complete") {         // recursive till the subgrid is loaded         setTimeout(SubGridRefresh, 1000);         return;     }     // if subgrid fully loaded       if (subgrid) {         // attach the name of the custom function to grid          subgrid .attachEvent("onrefresh", OnRefresh_SubGrid);          subgrid .control.add_onRefresh(OnRefresh_SubGrid);     } } function   OnRefresh_SubGrid() {     //custom code to execute     var entityid = Xrm.Page.data.entity.getId();     alert(entityid); } ...