Siebel 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 13) 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 14), the fields listed in Table 78, Table 79, and Table 80 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 78. 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 79. 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 80. 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 81 describes how address and contact information is updated by the D&B Update Manager (Siebel) process.
Table 81. 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 82 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 82. 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 83 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 (User).
Table 83. 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 |
|