D&B Marketing Universe Matched Client File
Technical name: 0DB_IMPORTFILE_MU.csv
Loaded with data source: 0CUSTOMER_ATTR, 0BPARTNER_ATTR and 0DBDUNS_NUM2_ATTR
The D&B Marketing Universe Matched Client File contains the following information:
It also contains additional information like employee number, turnover band, D-U-N-S number of the H/Q parent and the global ultimate companies.
File Structure
|
Field |
Description |
Type |
Length |
|
DBSOURSYST |
Source system key |
CHAR |
2 |
|
CUSTOMER |
Customer ID |
CHAR |
10 |
|
BPARTNER |
Business partner ID |
CHAR |
10 |
|
DBDUNS_NUM |
D-U-N-S number |
CHAR |
9 |
|
DB_MATCDS |
Match code |
CHAR |
8 |
|
DB_MAKTCOD |
Marketability code |
CHAR |
1 |
|
Company name |
CHAR |
60 |
|
|
DBCTYNAM |
City name |
CHAR |
30 |
|
DBCTRYCOD |
Country code |
CHAR |
3 |
|
DB87SIC1 |
Full US 1987 SIC code |
CHAR |
4 |
|
DBEMPTOT |
Total employees for company |
NUMC |
7 |
|
DBANSALES |
Annual turnover |
NUMC |
18 |
|
DBLGLSTAT |
Legal status |
CHAR |
3 |
|
DBYRSTD |
Year started |
CHAR |
4 |
|
DBHQDUNS |
HQ/Parent D-U-N-S number |
NUMC |
9 |
|
DBGUDUNS |
Global ultimate parent D-U-N-S number |
NUMC |
9 |
|
DBLOCACOD |
Location code |
CHAR |
1 |