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 77, Table 78, and Table 79 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 77. S_DNB_ORG Table Mapping for D&B Update Manager (Siebel)
|
|
|
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 78. S_PRSP_CONTACT Table Mapping for D&B Update Manager (Siebel)
|
|
|
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 79. S_DNB_ORG_SIC Table Mapping for D&B Update Manager (Siebel)
|
|
|
ROW_ID |
S_INDUST |
PR_INDUST_ID |
S_ORG_INDUST |
INDUST_ID |
Table 80 describes how address and contact information is updated by the D&B Update Manager (Siebel) process.
Table 80. Update Rules for Addresses and Contacts
If This D&B Information Changes... |
|
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 81 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 81. 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 82 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 Opportunities (End User).
Table 82. 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 |
|
Account Map |
DNB Account |
Account |
Promotion Specifies the fields in DNB Account that is copied to Account business component |
Contact Map |
DNB Contact |
Contact |
Promotion Specifies the fields in DNB Contact that is copied to Contact business component |
Mailing Address Map |
DNB Account |
Business Address |
Promotion Specifies the mailing address fields in DNB Account that is copied to Business Address |
Physical Address Map |
DNB Account |
Business Address |
Promotion Specifies the physical address fields in DNB Account that is 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 on) |
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 on) fields in the DNB Account that is copied into the List Mgmt Prospective Contact |
|