D-U-N-S Contact Details File
D-U-N-S Contact Details File
Technical name: 0DBDUNS_NUM_CONT_MU.csv (D&B Marketing Universe for SAP BW solution), 0DBDUNS_NUM_CONT_VC.csv (D&B Vendor/Customer Analytics for SAP BW solution)
Loaded with data source: 0DBDUNS_NUM3_ATTR
This file is optional for the D&B Vendor/Customer Analytics for SAP BW solution.
The D-U-N-S Contact Details file contains detailed address and contact information for the specified D-U-N-S numbers. The D-U-N-S Contact Details file is uploaded into SAP BW as master data for the D-U-N-S number (InfoObject 0DBDUNS_NUM). During the upload process, the tactical data flag is filled.
File Structure
|
Field |
Description |
Type |
Length |
|
DBDUNS_NUM |
D-U-N-S number |
CHAR |
9 |
|
DBBUSNAME |
Company name |
CHAR |
90 |
|
DBADDRES1 |
Address 1 (physical) |
CHAR |
64 |
|
DBADDRES2 |
Address 2 (physical) |
CHAR |
64 |
|
DBCTYNAM |
City name |
CHAR |
50 |
|
DBSTATPRV |
State / province |
CHAR |
50 |
|
DBSTATPRCOD |
State / province code |
CHAR |
3 |
|
DBPOSTCOD |
Postal code / zip code |
CHAR |
16 |
|
DBCTRYNA |
Country name |
CHAR |
20 |
|
DBCTRYCOD |
Country code |
CHAR |
3 |
|
COUNTRYISO |
ISO code for country |
CHAR |
2 |
|
DBCTRYACO |
Country telephone access code |
CHAR |
8 |
|
DBTELPHON |
Telephone |
CHAR |
16 |
|
DBFAXNBR |
Fax number |
CHAR |
16 |
|
DBKEYCONT |
Executive 1 name |
CHAR |
60 |
|
DBKEYTITL |
Executive title |
CHAR |
60 |
|
DBTIMSTMP |
Timestamp |
DATS |
8 |