For details about configuring related contact data sets, see Overview of the Related Contact Data Set.
Related Contacts Data Set
| Table Column | Description |
|---|---|
| SYS_ID | System ID for the contact that is on the left side of the relationship. This column only applies when mapping the left side of the relationship by Data Source System ID. |
| [MAPPING_FIELD] |
Additional field mapping value for finding the contact that is on the left side of the relationship. This column displays if you choose to map the left side of the relationship using an additional field value. The column is renamed to a valid SQL column name - for example, Client Code becomes CLIENT_CODE. |
| LIST1_ID |
InterAction Contact ID for the contact that is on the left side of the relationship. This column only applies when mapping the left side of the relationship by InterAction Contact ID (ListingID). The contact ID is called Listing ID in previous versions and in the InterAction database. |
| LIST1_SRC_ID |
InterAction Contact Source ID for the contact that is on the left side of the relationship. This column only applies when mapping the left side of the relationship by InterAction Contact ID (ListingID). The Contact Source ID identifies the database on which the contact was created. Combined with the Contact ID, it uniquely identifies the contact. The contact Source ID is called Listing Source ID in previous versions and in the InterAction database. |
| SYS2_ID |
System ID for the contact that is on the right side of the relationship. This column only applies when mapping the right side of the relationship by Data Source System ID. |
| [MAPPING_FIELD2] |
Additional field mapping value for finding the contact that is on the right side of the relationship. This column displays if you choose to map the right side of the relationship using an additional field value. The column is renamed to a valid SQL column name - for example, Client Code becomes CLIENT_CODE. |
| LIST2_ID |
InterAction Contact ID for the contact that is on the right side of the relationship. This column only applies when mapping the right side of the relationship by InterAction Contact ID (ListingID). The contact ID is called Listing ID in previous versions and in the InterAction database. |
| LIST2_SRC_ID |
InterAction Contact Source ID for the contact that is on the right side of the relationship. This column only applies when mapping the right side of the relationship by InterAction Contact ID (ListingID). The Contact Source ID identifies the database on which the contact was created. Combined with the Contact ID, it uniquely identifies the contact. The contact Source ID is called Listing Source ID in previous versions and in the InterAction database. |
| RELATED_DESC | The text description for the relationship. This column is optional. |
| CONVERSE_DESC | The relationship description for the converse relationship. This column is optional. |