Applications Administration Guide > D&B Integration >

Field Mappings for Configuration of D&B Integration

This section provides field mapping information for three types of D&B integration processes:

Field Mapping for the D&B Update Manager Process

D&B Update Manager (D&B) server component. For the table mapping for the D&B Update Manager (D&B) component, examine the appropriate tables (Figure 19) using Siebel Tools. The default field mappings can be determined by examining the UPDATE_DNB* sections of the RTI configuration file (dnbmaps.sql or dnbmaps.tsq).

D&B Update Manager (Siebel) server component. When the D&B Update Manager (Siebel) server component is run (Figure 20), the fields listed in Table 33, Table 34, and Table 35 are mapped. The field mappings can also be determined by examining the UPDATE_SIEBEL* sections of the RTI configuration file.

For information about changing these default mappings, see Update Server Process Configuration.

Table 33.  S_DNB_ORG Table Mapping for D&B Update Manager (Siebel)
From Column
To Table
To Column
DUNS_NUM
S_ORG_EXT
DUNS_NUMBER
BUSINESS_NAME
S_ORG_EXT
NAME
TRADESTYLE
S_ORG_SYN
NAME
SCND_TRADESTYLE
S_ORG_SYN
NAME
PHYS_STREET_ADDR
S_ADDR_ORG
ADDR
SECOND_STREET_ADDR
S_ADDR_ORG
ADDR
PHYSICAL_CITY
S_ADDR_ORG
CITY
PHYSICAL_STATE
S_ADDR_ORG
PROVINCE or STATE
PHYSICAL_ZIP
S_ADDR_ORG
ZIPCODE
COUNTRY_NAME
S_ADDR_ORG
COUNTRY
COUNTY_NAME
S_ADDR_ORG
COUNTY
MAIL_ADDRESS
S_ADDR_ORG
ADDR
MAIL_ADDRESS_2
S_ADDR_ORG
ADDR
MAIL_CITY
S_ADDR_ORG
CITY
MAIL_STATE
S_ADDR_ORG
STATE
MAIL_ZIP
S_ADDR_ORG
ZIPCODE
TELEPHONE
S_ORG_EXT
PH_NUM
FAX_NUMBER
S_ORG_EXT
FAX_PH_NUM
ANNL_SLS_AMT
S_ORG_EXT_X
ATTRIB_14
CURRENCY_CODE
S_ORG_EXT
BASE_CURCY_CD
EMPLOYEES_TOTAL
S_ORG_EXT_X
ATTRIB_26
EMPLOYEES_HERE
S_ORG_EXT
EMP_COUNT
YEAR_STARTED
S_ORG_EXT_X
ATTRIB_27
LOC_TYPE_STAT_IND
S_ORG_EXT
included in LOC
PUBLIC_PRIVATE_IND
S_ORG_EXT_X
ATTRIB_08
GLBLULT_DUNS_NUM
S_ORG_EXT
GLBLULT_DUNS_NUM
DOM_ULT_DUNS_NUM
S_ORG_EXT
DOM_ULT_DUNS_NUM
PAR_DUNS_NUM
S_ORG_EXT
PAR_DUNS_NUM
LINE_OF_BUSINESS
S_ORG_EXT_X
ATTRIB 03
PCT_GROWTH_SLS_3YR
S_ORG_EXT_X
ATTRIB_15

The S_PRSP_CONTACT table contains information about the D&B contacts such as the name of the CEO and various company executives. D&B provides up to four contacts per D&B account.

Table 34.  S_PRSP_CONTACT Table Mapping for D&B Update Manager
From Column
To Table
To Column
LAST_NAME
S_CONTACT
LAST_NAME
FST_NAME
S_CONTACT
FST_NAME
MID_NAME
S_CONTACT
MID_NAME
PER_TITLE
S_CONTACT
PER_TITLE
PER_TITLE_SUFFIX
S_CONTACT
PER_TITLE_SUFFIX
JOB_TITLE
S_CONTACT
JOB_TITLE
SEX_MF
S_CONTACT
SEX_MF

The S_DNB_ORG_SIC table contains the Standard Industrial Classification (SIC) code developed by the US Government. The code is assigned to businesses and other organizations by classifying and subdividing the activity performed by that establishment at that location. D&B provides up to six SICs per D&B account. In the D&B Update Manager process, the primary SIC code is mapped to the S_INDUST table and all SIC codes are mapped to the S_ORG_INDUST table.

Table 35.  S_DNB_ORG_SIC Table Mapping for D&B Update Manager
From Column
To Table
To Column
ROW_ID
S_INDUST
PR_INDUST_ID
S_ORG_INDUST
INDUST_ID

Table 36 describes how address and contact information is updated by the D&B Update Manager (Siebel) process.

Table 36.  Update Rules for Addresses and Contacts
If This D&B Information Changes...
Then...
Street address
City
(Abbreviated) state
A new address record is added to the Address table.
Address information other than street address, city, or state
The address record is updated in the Address table.
Phone number
Fax number
The address record is updated in the Address table.
Contact first name or
Contact last name
A new contact record is added to the Contact table.
Contact information other than first or last name
The contact record is updated in the Contact table.

Field Mapping for D&B Real-Time Updates

When you purchase account information through the D&B Web site using the D&B real-time search and update feature in the Siebel application, certain fields in the Siebel business components are populated. These fields are a subset of the fields that are populated by the D&B Update Manager (D&B) server component. For example, D&B does not provide the contact first, last, and middle names fields in the real-time update.

Table 37 lists the fields that may be populated or updated when you purchase account information using the D&B real-time search and update feature.

Table 37.  Fields Populated by D&B Real-Time Search and Update
D&B WorldBase Marketing Plus with Linkage
Siebel Business Component Name.Field Name
Business Structure Code (Location Type)
DNB Account.Location Type
Domestic Ultimate Name
DNB Account.Domestic Ultimate Business Name
Global Ultimate Name
DNB Account.Global Ultimate Business Name
Parent/HQ Business Name
DNB Account.Parent HQ Name
Physical State
DNB Account.State Name
Business Name
DNB Account.Business Name
Trade Style
DNB Account.Trade Style
Street Address
DNB Account.Physical Address
Mail Address
DNB Account.Mail Address
City Name
DNB Account.Physical City
Mail City Name
DNB Account.Mail City
Physical State/Province Abbreviation
DNB Account.Physical State
Mailing State/Province Abbreviation
DNB Account.Mail State
ZIP/Postal Code
DNB Account.Physical Zip
Mail Postal/ZIP Code
DNB Account.Mail Zip
Country Name
DNB Account.Country Name
D&B D-U-N-S Number
DNB Account.DUNS Number
Telephone Number
DNB Account.Main Phone 2
Cable/Telex Code
DNB Account.Cable Telex Number
Facsimile Number
DNB Account.Main Fax 2
National ID
DNB Account.National Identification Number 2
SIC Code
DNB Account.SIC Code
Primary Local Activity Code
DNB Account.Primary Local Activity Code
Year Started
DNB Account.Year Started 1
Employees Here
DNB Account.Employee Here
Employees Total
DNB Account.Employee Total
Annual Sales US Dollars
DNB Account.Sales Volume
Annual Sales Local
DNB Account.Annual Sales Local Currency
Legal Status
DNB Account.Legal Status
Subsidiary Code
DNB Account.Subsidiary Indicator
Import / Export / Agent Ind.
DNB Account.Import Export Code
Global Ultimate D&B D-U-N-S Number
DNB Account.Global Ultimate DUNS
Global Ultimate Indicator
DNB Account.Global Ultimate Indicator
Global Ultimate WorldBase Country Code
DNB Account.Global Ultimate Country Code
Domestic Ultimate D&B D-U-N-S Number
DNB Account.Domestic Ultimate DUNS
Headquarter/Parent D&B D-U-N-S Number
DNB Account.Parent HQ DUNS
HQ/Parent WorldBase Country Code
DNB Account.Parent/HQ Country Code

Field Mapping for Account Promotion and Prospect Lists

When end users promote D&B accounts or create prospect lists from the D&B screen, fields in the DNB Account and DNB Contact business components are mapped to fields in other business components. These maps are listed in Table 38 and can be viewed in detail in the Business Component User Properties window of Siebel Tools.

For information about promoting accounts and creating prospect lists, see Siebel Sales User Guide.

Table 38.  Maps of D&B to Siebel Fields for Promotion and List Creation
User Property Prefix and Map Name
D&B Source Business Component
Siebel Destination Business Component
Process and Description
Account Map
DNB Account
Account
Promotion
Specifies the fields in DNB Account that will be copied to Account business component
Contact Map
DNB Contact
Contact
Promotion
Specifies the fields in DNB Contact that will be copied to Contact business component
Mailing Address Map
DNB Account
Business Address
Promotion
Specifies the mailing address fields in DNB Account that will be copied to Business Address
Physical Address Map
DNB Account
Business Address
Promotion
Specifies the physical address fields in DNB Account that will be copied to Business Address
Prospect Info Map
DNB Contact
List Mgmt Prospective Contact
Create Prospect List
Specifies the biological information (such as last name, first name, and so forth)
Prospect Contact Info Map
DNB Account
List Mgmt Prospective Contact
Create Prospect List
Specifies the contact information (such as company, address, phone number, and so forth) fields in the DNB Account that will be copied into the List Mgmt Prospective Contact

 Applications Administration Guide
 Published: 09 September 2004