PowerExchange for Microsoft Dynamics CRM User Guide for PowerCenter

10.4.0
- 10.5.6
- 10.5.2
- 10.5.1
- 10.5

Back Next

Alternate Key as Reference

You can specify an alternate key as reference for Lookup, Customer, Owner, and PartyList data types.

Use the following format to specify an alternate key as reference for Lookup, Customer, and Owner data types:

<entity_name>:alternate_key(<Lower Case Field Name 1: Value>,...,
                            <Lower Case Field Name N: Value>)

For example,

contact:alternate_key(firstname:Account_Contact_alterkey 1,
                       new_customkey:lookup_customer_partylist1@alt.com)

Use the following XML format to specify an alternate key as reference for a PartyList entity:

<EntityCollection>
       <Entity Name="activityparty">
          <Attribute Name="partyid" Value="<entity_name>:alternate_key
           (<Lower Case Field Name 1: Value>,...,<Lower Case Field Name N: Value>)"/>
          <Attribute Name="participationtypemask" Value="2"/>
          <Attribute Name="activitypartyid" Value="<entity_name>:alternate_key
           (<Lower Case Field Name 1: Value>,...,<Lower Case Field Name N: Value>)"/>
       </Entity>
       <Entity Name="activityparty">
          <Attribute Name="partyid" Value="<entity_name>:alternate_key
           (<Lower Case Field Name 1: Value>,...,<Lower Case Field Name N: Value>)"/>
          <Attribute Name="participationtypemask" Value="2"/>
          <Attribute Name="activitypartyid" Value="<entity_name>:alternate_key
           (<Lower Case Field Name 1: Value>,...,<Lower Case Field Name N: Value>)"/>
       </Entity>
</EntityCollection>

Rename Saved Search

Table of Contents

PowerExchange for Microsoft Dynamics CRM User Guide for PowerCenter

PowerExchange for Microsoft Dynamics CRM User Guide for PowerCenter

Alternate Key as Reference

Alternate Key as Reference