Company Data Set Table

For details about configuring a company data set, see Overview of the Company and Person Data Sets.

Company Data Set
Table Column Description
SYS_ID

System ID for the contact. This is a unique identifier provided by the external system. It is used to identify the contact for updates, as well as to tie the contact to additional fields, addresses, classifications, and activities. It is also used to tie companies to people for company association.

This column does not apply when mapping by InterAction Contact ID (ListingID) or when you have chosen not to claim the contact.

COMPANY_NM The name for the company.
COMPANY_KNOWN_AS The Also Known As name for the company.
LISTING_ID

InterAction Contact ID of the contact to update with the company data in this row. This column only applies when mapping by InterAction Contact ID (ListingID).

The contact ID is called Listing ID in previous versions and in the InterAction database.

LISTING_SRC_ID

InterAction Contact Source ID of the contact to update with the company data in this row. This column only applies when mapping 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.

MAP_[ADDITIONAL FIELD NAME]

This column only applies when mapping by Additional Information. Application Collaboration maps an existing InterAction contact if the value of this additional field matches the value harvested into this column.

The column is named based on the additional field value you select, for example, MAP_CLIENT_CODE.