Microsoft Dynamics 365 for Sales Connector > Data type reference > Microsoft Dynamics 365 for Sales and transformation data types
  

Microsoft Dynamics 365 for Sales and transformation data types

The following table lists the Microsoft Dynamics 365 for Sales data types that Data Integration supports and the corresponding transformation data types:
Microsoft Dynamics 365 for Sales Data Type
Microsoft Dynamics 365 Web API Specific DataType
Range and Description
Transformation Data Type
Bigint
Int64
You can specify the maximum and minimum values between 922, 337, 203, 685, 477 and 922, 337, 203, 685, 477.
Bigint
Boolean
Boolean
You can specify the text for both options. When added to a form, the field properties control whether the attribute is displayed as two radio buttons, a check box, or a list. Input must be True or False.
String
Customer
String
Customer attribute represents a type of lookup where either an account or contact is a valid type of record. Input must be in the following format:
/LogicalCollectionName(guid) or LogicalCollectionName(guid)
For example, /accounts(4fca93d7-b73d-e011-b010-005056a8019b) or accounts(4fca93d7-b73d-e011-b010-005056a8019b)
The source field uses the following naming convention:
_<name>_value, where <name> matches the name of the Customer data type.
For example, _customerid_value
The target field uses the following naming convention:
<name>_<reference>, where <reference> is an entity that has a relationship with the object.
For example, customerid_account
Note: A field name starting with an underscore character (_), for example _customerid_value, also appears under the target object. However, you cannot write the field to the target object.
For more information about the naming convention, refer to the following URL:
To use an alternate key, input must be in the following format:
\LogicalCollectionName(<field1name>=value,<field2name>=value,...), where field name is the alternate key defined in the LogicalCollectionName.
String
DateTime
DateTimeOffset
Date and time values.
The minimum value is 1900-01-01T00:00:00.000Z. The maximum value is 9999-12-30T23:59:59Z.
Date/Time
Decimal
Decimal
You can specify the level of precision up to ten decimal places and the minimum and maximum values from -1,000,000,000 to 1,000,000,000.
Decimal
Double
Double
A decimal attribute. You can specify the level of precision up to five decimal places and the minimum and maximum values from -1,000,000,000 to 1,000,000,000.
Double
EntityName
String
The entity attribute represents the logical name of an entity. You cannot write the EntityName data type.
String
Integer
Int32
Integer values. You can specify the maximum and minimum values from -2,147,483,648 to 2,147,483,647.
Integer
Lookup
String
The lookup attribute represents the relationship attribute on the related entity. The valid type for the lookup is established in the relationship. Input must be in the following format:
/LogicalCollectionName(guid) or LogicalCollectionName(guid)
For example, /accounts(4fca93d7-b73d-e011-b010-005056a8019b) or accounts(4fca93d7-b73d-e011-b010-005056a8019b)
The source field uses the following naming convention:
_<name>_value, where <name> matches the name of the Lookup data type.
For example, _lookupid_value
The target field uses the following naming convention:
<name>
For example, lookupid
Note: A field name starting with an underscore character (_), for example _lookupid_value, also appears under the target object. However, you cannot write the field to the target object.
For more information about the naming convention, refer to the following URL:
To use an alternate key, input must be in the following format:
\LogicalCollectionName(<field1name>=value,<field2name>=value,...), where field name is the alternate key defined in the LogicalCollectionName.
String
Memo
String
The memo attribute represents a multiline text box.
String
Money
Decimal
You can specify the maximum and minimum values between -922,337,203,685,477 and 922,337,203,685,477. You can set the precision as one, two, or three.
Decimal
Owner
String
The owner attribute represents the relationship attribute on the related entity. The valid type for the owner is established in the relationship. Input must be in the following format:
/LogicalCollectionName(guid) or LogicalCollectionName(guid)
For example, /accounts(4fca93d7-b73d-e011-b010-005056a8019b) or accounts(4fca93d7-b73d-e011-b010-005056a8019b)
The source field uses the following naming convention:
_<name>_value, where <name> matches the name of the Owner data type.
For example, _ownerid_value
The target field uses the following naming convention:
<name>
For example, ownerid
Note: A field name starting with an underscore character (_), for example _ownerid_value, also appears under the target object. However, you cannot write the field to the target object.
For more information about the naming convention, refer to the following URL:
To use an alternate key, input must be in the following format:
\LogicalCollectionName(<field1name>=value,<field2name>=value,...), where field name is the alternate key defined in the LogicalCollectionName.
String
Picklist
Int32
The picklist attribute provides a set of options that are displayed in a list. You can create the picklist attribute so that it can contain its own options or use a global options set. An option value of a picklist is an integer that corresponds to the option description. You can find the option values and description for the default entities in the Microsoft Dynamics CRM documentation.
For example, for an AccountRole picklist, to set the picklist value to Decision Maker, the option value is 1.
Integer
State
Int32
The state attribute is automatically created when you create an entity. The state attribute internally represents the status of the entity. A value of a state is an integer that corresponds to the state description. You can find the state values and description for the default entities in the Microsoft Dynamics CRM documentation.
For example, to set the state as Open, the value is 0 for the Activity entity.
Integer
Status
Int32
The status attribute is automatically created when you create an entity. Each of the options must be associated with the state attribute for the entity. The status attribute displays the value of state to the end user. A value of a status is an integer that corresponds to the status description. You can find the status values and description for the default entities in the Microsoft Dynamics CRM documentation.
For example, to set the status as Active, the value is 1 for the Account entity.
Integer
String
String
The string attribute represents a single line of text.
String
UniqueIdentifier
Guid
UniqueIdentifier represents an attribute that is the guid of another entity instance. UniqueIdentifier must be in the guid format.
For example, 4fca93d7-b73d-e011-b010-005056a8019b
String