D&B Universe of Abstract Data (SAP Library

D&B Universe of Abstract Data

Technical name: 0DBDUNS_NUM_ABSTRACT_MU.csv

Loaded with data source: 0DBDUNS_NUM_ATTR

0DBDUNS_NUM_ABSTRACT_MU.csv contains the D&B Universe of Abstract Data. The file contains relevant companies (identified by the D-U-N-S number) for an area previously specified by your company in a contract with D&B. A D&B Marketing Universe comprises for example all companies in Germany.

File Structure

Field	Description	Type	Length
DBDUNS_NUM	D-U-N-S number	NUMC	9
	Company name	CHAR	90
DBCTYNAM	Town / city	CHAR	30
DBSECTCOD	Sector code	NUMC	13
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
LATITUDE	Latitude	Number (KYF)
LONGITUDE	Longitude	Number (KYF)
DBRATENW	Rating – net worth	CHAR	3
DBRATECON	Rating - condition	CHAR	1
DBSCORE	Score	CHAR	3