Vendor/Customer Analytics Import File (SAP Library - D&B Vendor Analysis for SAP BW)

Vendor/Customer Analytics Import File

Technical name: 0DB_IMPORTFILE_VC.csv

Loaded with data source: 0DBDUNS_IMPORT_ATTR

The Vendor/Customer Analytics Import File contains all supplier attributes included in the standard set as delivered by SAP. There are two types of attributes:

· Pre-defined InfoObjects that have been previously assigned to 0VENDOR/0CUSTOMER

· Pre-defined InfoObjects that still require assignment to 0VENDOR/ 0CUSTOMER since they are exclusive to the D&B scenario.

Note

Some InfoObjects are smaller than the incoming D&B data. When uploading the Vendor/Customer Analytics Import File, fields larger than 60 characters (for example Business Name DBBUSNAME) are adjusted to a max. length of 60 characters.

File Structure

Field	Description	Type	Length in D&B File
SOURSYSTEM	BW Source System ID	CHAR	2
VENDOR	Vendor ID	CHAR	10
DB_FILLER	Filler for Customer Extension	CHAR	50
DB_CHANGE	D-U-N-S changed flag	CHAR	1
DB_OLDDUNS	Former D-U-N-S number	NUMC	9
DB_MATCDS	Match Codes	CHAR	8
DB_MATGRD	Match Confidence Grades	CHAR	7
DBFILLER1	Filler	CHAR	2
DBDUNS_NUM	D-U-N-S Number	NUMC	9
DBBUSNAME	Company Name	CHAR	90
DBTRDSTYL	Trade Style (Primary)	CHAR	90
DBREGADDR	Registered Address	CHAR	1
DBADDRES1	Address 1	CHAR	64
DBADDRES2	Address 2	CHAR	64
DBCTYNAM	City Name	CHAR	30
DBSTATPRV	State/ Province	CHAR	30
DBCTRYNA	Country	CHAR	20
DBCTYCOD	City Code	CHAR	6
DBCNTYCO	County Code	CHAR	3
DBSTPRCOD	State/Province Code	CHAR	3
DBSTPRABB	State/Province Abbreviation	CHAR	4
DBCTRYCOD	Country Code	CHAR	3
DBPOSTCOD	Postal/ Zip code	CHAR	9
DBCONTCOD	Continent Code	NUMC	1
DBMADDR	Mailing Address	CHAR	32
DBMCTYNAM	Mail Address: City Name	CHAR	30
DBMCNTYNA	Mail Address: County Name	CHAR	30
DBMSTPRNA	Mailing State/Province Name	CHAR	30
DBMCTRYNA	Mail Address: Country	CHAR	20
DBMCTYCOD	Mail Address: City Code	CHAR	6
DBMCNTYCO	Mail Address: County Code	CHAR	3
DBMSTPRCO	Mailing State/Province Code	CHAR	3
DBMSTPRAB	Mail address: State/Province Abbr.	CHAR	4
DBMCTRYCO	Mail Address: Country Code	CHAR	3
DBMPOSTCO	Post Code For Mailing Address	CHAR	9
DBMCONTCO	Mail Address: Continent Code	NUMC	1
DBNATID	National ID (VAT, and so on)	CHAR	16
DBNATIDCO	Nat’l ID System Code	CHAR	5
DBCTRYACO	Country Access Code	CHAR	4
DBTELPHON	Telephone	CHAR	16
DBCABTELX	Fax/ Telex	CHAR	16
DBFAXNBR	Fax Number	CHAR	16
DBCEONAME	CEO Name	CHAR	60
DBCEOTITL	CEO Title	CHAR	60
DBLNOFBUS	Line of Business	CHAR	41
DB87SIC1	US 1987 SIC 1	CHAR	4
DB87SIC2	US 1987 SIC 2	CHAR	4
DB87SIC3	US 1987 SIC 3	CHAR	4
DB87SIC4	US 1987 SIC 4	CHAR	4
DB87SIC5	US 1987 SIC 5	CHAR	4
DB87SIC6	U.S. 1987 SIC 6	CHAR	4
DBLOACTCO	Primary Local Activity Code	CHAR	8
DBACTIND	Activity Indicator	CHAR	3
DBYRSTD	Year Started (Control)	CHAR	4
DBANSALES	Annual Turnover	NUMC	18
DBANSLIND	Annual Sales Indicator	CHAR	1
DBANSLUS	Annual Sales US $	NUMC	15
DBCURNCCO	Currency Key	CHAR	4
DBEMPHERE	Employees Here	NUMC	7
DBEMPHIND	Employees Here Ind.	CHAR	1
DBEMPTOT	Employees Total	NUMC	7
DBEMPIND	Employees Total Ind.	CHAR	1
DBPRNIND	Principles Included	CHAR	1
DBIMPTXPT	Import/Export Code	CHAR	1
DBLGLSTAT	Legal status	CHAR	3
DBCTRLIND	Control Indicator	CHAR	1
0DBLOCACOD	Location Code	CHAR	1
DBSUBCODE	Subsidiary Code	CHAR	1
DBFILLER2	Filler	CHAR	2
DBPREVDUN	Previous D-U-N-S Number	NUMC	9
DBRPTDATE	Report Date	DATS	8
DBFILLER3	HQ/Parent: Filler	CHAR	2
DBHQDUNS	HQ/Parent: D-U-N-S Number	NUMC	9
DBHQNAME	HQ/Parent: Name	CHAR	90
DBHQADDR	HQ/Parent: Address	CHAR	64
DBHQCTYNM	HQ/Parent: City Name	CHAR	30
DBHQSTPR	HQ/Parent: State/Province	CHAR	30
DBHQCTRYN	HQ/Parent: Country Name	CHAR	20
DBHQCTYCO	HQ/Parent: City Code	CHAR	6
DBHQCNTYC	HQ/Parent: County Code	CHAR	3
DBHQSTABB	HQ/Parent: State/Province Abbreviation	CHAR	4
DBHQCTRYC	HQ/Parent: Country Code	CHAR	3
DBHQPOSCO	HQ/Parent: Postal Code/ Zip Code	CHAR	9
DBHQCONTC	HQ/Parent: Continent Code	NUMC	1
DBFILLER4	Domestic Ultimate:Filler	CHAR	2
DBULDUNS	Domestic Ultimate: D-U-N-S Numbers	NUMC	9
DBULNAME	Domestic Ultimate: Name	CHAR	90
DBULADDR	Domestic Ultimate: Address	CHAR	64
DBULCTYNM	Domestic Ultimate: City Name	CHAR	30
DBULSTPR	Domestic Ultimate: State/Province Name	CHAR	30
DBULCTYCO	Domestic Ultimate: City Code	CHAR	6
DBULCNTYC	Domestic Ultimate: County Code	CHAR	3
DBULSTABB	Domestic Ultimate: State Abbreviation	CHAR	4
DBULPOSCO	Domestic Ultimate: Postal Code/ Zip Code	CHAR	9
DBGUIND	Global Ultimate Ind.	CHAR	1
DBFILLER5	Global Ultimate: Filler	CHAR	2
DBGUDUNS	Global Ultimate: DUNS Number	NUMC	9
DBGUNAME	Global Ultimate: Name	CHAR	90
DBGUADDR	Global Ultimate: Address	CHAR	64
DBGUCTYNM	Global Ultimate: City Name	CHAR	30
DBGUSTPR	Global Ultimate: State/Province	CHAR	30
DBGUCTRYN	Global Ultimate: Country Name	CHAR	20
DBGUCTYCO	Global Ultimate: City Code	CHAR	6
DBGUCNTYC	Global Ultimate: County Code	CHAR	3
DBGUSTABB	Global Ultimate: State/Province Abbreviation	CHAR	4
DBGUCTRYC	Global Ultimate: Country Code	CHAR	3
DBGUPOSCO	Global Ultimate: Postal Code/ Zip Code	CHAR	9
DBGUCONCO	Global Ultimate: Continent Code	NUMC	1
DBNUMFAM	# Fam Members Glb	NUMC	5
DBDIASCO	Dias Code	CHAR	9
DBHIERCO	Hierarchy Code	NUMC	2
DBFAMUPDT	Family Update Date	DATE	8
COUNTRYISO	Country ISO Code (1)	CHAR	2
DB COUNMA	Mail Address: Country ISO Code (1)	CHAR	2
DB COUNHQ	HQ/Parent: Country ISO Code (1)	CHAR	2
DB COUNGU	Global Ultimate: Country ISO Code (1)	CHAR	2
DBCURNISO	ISO Currency Code (2)	CHAR	3
DBUSERARE	User Area	CHAR	16

(1) The 2 character standard ISO code indicates the country, mailing address, HQ/Parent, and Global Ultimate respectively, for example DE = Germany; UK = United Kingdom and so on.

(2) The 3 character standard ISO code indicates the currency for which annual sales are provided. For example, DEM = Deutschmarks; GBP = British Pounds Sterling.

Since there is no exact 1-1 match between the two codification systems, ISO codes are provided in addition to the standard 1784 codes.

A description for the 1784 byte file can be found in the Worldbase Data Dictionary.

Record Status

The record status, that is the status of a data set relating to a vendor, is described by match codes and match grades. It indicates whether or not a match was successful. It also specifies how the match was achieved (if successful) or why it was unsuccessful. A match for a single record is classified as unsuccessful if the D-U-N-S field is filled with zeros. Refer to Match Codes and Match Grades for an explanation of the match codes and match confidence grades.

D-U-N-S Changed Flags, Former D-U-N-S Numbers

As a result of database maintenance and normal business activities (i.e. mergers, acquisitions, divestitures) it is possible that a D-U-N-S Number assigned to a company may change between refreshes. If this occurs, the original D-U-N-S Number extracted from BW is listed in the Former D-U-N-S Number field, whereas the current D-U-N-S Number is provided in the D-U-N-S field. The reason for changing the D-U-N-S Number is indicated in the D-U-N-S Changed Flag field. Key to acronyms:

Acronym	Description
N	No change
M	Merger/acquisition
D	Deleted during file maintenance, referred to a different D-U-N-S number
B	Both M & D occurred
G	Deleted during file maintenance, no surviving D-U-N-S number

Non-Standard Import Files

In addition to the fields included in the standard Worldbase Record file, there may be requirements for data available from other D&B data sources only. In the U.S., for example, data on minority ownership may be required. This type of data is country-specific and therefore not included in Business Content.

If a requirement of this kind exists, D&B supplies data in a separate, customized file. The D-U-N-S and Vendor numbers function as the key.