Single-Value Additional Field Data Set Tables

There are two different data sets for populating single-value additional fields:

• Single-Value Field populates regular single-value additional fields
• Single-Value, Multiple Column data set populates fields that use the Variable Field Additional Field Extension.

For details about configuring additional field data sets, see Overview of the Additional Field Data Sets.

Single-Value Additional Fields Data Set

Table Column	Description
SYS_ID	System ID for the contact to update with the additional field values in the row. This column is only included when mapping by Data Source System ID.
LISTING_ID	InterAction Contact ID of the contact to update with the additional field values 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 additional field values 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.
[FIELDS_TO_POPULATE]	The table contains a a column for each InterAction additional field to populate, renamed to be a valid SQL column name. For example, the field Billings 2000 becomes BILLINGS_2000.
[MAPPING_FIELD]	This column displays if you choose to map contacts using an additional field value. The value in this column is used to find the contacts to update with the additional field values harvested in the previous columns. The column is renamed to a valid SQL column name - for example, Client Code becomes CLIENT_CODE.

Single-Value, Multi-Column Additional Fields Data Set

Table Column	Description
SYS_ID	System ID for the contact to update with the additional field values in the row. This column is only included when mapping by Data Source System ID.
LISTING_ID	InterAction Contact ID of the contact to update with the additional field values 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 additional field values 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.
[COLUMNS_TO_POPULATE]	The table contains a a column for each InterAction column configured for the variable field additional field extension, renamed to be a valid SQL column name.
[MAPPING_FIELD]	This column displays if you choose to map contacts using an additional field value. The value in this column is used to find the contacts to update with the additional field values harvested in the previous columns. The column is renamed to a valid SQL column name - for example, Client Code becomes CLIENT_CODE.