PowerExchange Adapters for PowerCenter
- PowerExchange Adapters for PowerCenter 10.5.6
- All Products
Microsoft Dynamics CRM Data Type
| Range and Description
| Transformation Data Type
|
---|---|---|
Bigint
| Big integer attribute. You can specify the maximum and minimum values between -922,337,203,685,477 and 922,337,203,685,477.
| Bigint
|
Boolean
| A Boolean attribute. 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 should be 0 or 1 , where 0 is for false and 1 for true.
| Integer
|
Customer
| Customer attribute represents a type of lookup where either an account or contact is a valid type of record.
Input must be in the <logicalname:guid> format . For example,
account:4fca93d7-b73d-e011-b010-005056a8019b.
| String
|
DateTime
| Date and time values.
Minimum value: 1900/1/1 00:00:00
Maximum value: 9999/12/30 23:59:59
| Date/Time
Null dates are filtered and passed to the target as Null.
|
Decimal
| A decimal attribute. 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
| 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
| Entity attribute represents the logical name of an entity.
You cannot write EntityName data type.
| String
|
Integer
| Integer values. You can specify the maximum and minimum values from -2,147,483,648 to 2,147,483,647.
| Integer
|
Lookup
| 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 <logicalname:guid> or <guid> format . For example,
account:4fca93d7-b73d-e011-b010-005056a8019b
or 4fca93d7-b73d-e011-b010-005056a8019b.
| String
|
ManagedProperty
| ManagedProperty attribute specifies the managed properties for an entity. The value can be either 0 or 1.
| String
|
Memo
| Memo attribute represents a multiline text box .
| String
|
Money
| Money attribute. 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.
| Money
|
Owner
| Owner attribute refers to the owner of an entity.
Owner name contains a logical name which can be either systemuser or team. For example, <systemuser:guid> or <team:guid>.
| String
|
PartyList
| Activity party details that has information about PartyId, ActivityPartyId, and ParticipationTypeMask.
A PartyId is a unique identifier of the party associated with the activity. For example, <logicalname:guid>.
An ActivityPartyId is a unique identifier of the activity associated with the activity party. A party is any person who is associated with an activity. ActivityParytId does not have to be populated while writing as it will be populated if a value is not provided.
If you populate the ActivityPartyId more than once, the task fails with a duplicate key error.
A ParticipationTypeMask is the role of the person in the activity, such as sender, organizer, or owner.
While reading and writing, the PartyList data type is in string format, but it contains XML data.
| String
|
Picklist
| Picklist attribute provides a set of options that are displayed in a drop-down 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 in the Microsoft Dynamics CRM documentation for the default entities. For example, for an AccountRole picklist , to set the picklist value to " Decision Maker", the option value is 1.
| Integer
|
State
| 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 in the Microsoft Dynamics CRM documentation for the default entities. For example, to set the state as "Open", the value is 0 for the Activity entity.
| Integer
|
Status
| Status attribute is automatically created when you create an entity. Each of the options must be associated with the state attribute for the entity. 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 in the Microsoft Dynamics CRM documentation for the default entities For example, to set the status as " Active", the value is 1 for the Account entity.
| Integer
|
String
| String attribute represents a single line of text.
| String
|
UniqueIdentifier
| Unique identifier represents an attribute that is the guid of another entity instance.
UniqueIdentifier should be in the guid format. For example, 4fca93d7-b73d-e011-b010-005056a8019b.
| String
|