Uploading Repeatedly Delivered D&B Files 

Use

In addition to the D&B files delivered only once, you also get the following files:

D&B file	Technical Name
D-U-N-S Text File	0DBDUNS_NUM_TEXT_VC.csv
D-U-N-S Family Tree File	0DBDUNS_NUM_HIER_VC.csv
D-U-N-S Contact Details File (optional)	0DBDUNS_CONT_VC.csv
Vendor/Customer Analytics Import File	0DB_IMPORTFILE_VC.csv

These files are also delivered each time you request new data from D&B, for example on a six-monthly or quarterly basis depending on your contract with D&B.

Each time D&B provides new data both the master data for the D-U-N-S number and the vendor number (0VENDOR) and/or customer number require updating. The upload process for these files can be described as a five step procedure.

Prerequisites

You have successfully performed the previous steps of the upload process.

Procedure

Uploading D-U-N-S Text Files

Data source:0DBDUNS_NUM_TEXT

Upload the D-U-N-S Text File (0DBDUNS_NUM_TEXT_VC.csv) into the D-U-N-S number (InfoObject 0DBDUNS_NUM).

For step-by-step instructions, see Uploading Initially Delivered D&B Files.

Uploading D-U-N-S Family Tree Files

Data source:0DBDUNS_NUM_HIER

Upload the D-U-N-S Family Tree File (0DBDUNS_NUM_HIER_VC.csv) into the D-U-N-S number (InfoObject 0DBDUNS_NUM).

For step-by-step instructions, see Uploading Initially Delivered D&B Files.

Uploading D-U-N-S Contact Information Files

Data source:0DBDUNS_NUM3_ATTR

If you also requested detailed address information for your vendors, D&B returns the D-U-N-S Contact Details File (0DBDUNS_CONT_VC.csv). Upload this file into the D-U-N-S number (InfoObject 0DBDUNS_NUM).

For step-by-step instructions, see Uploading Initially Delivered D&B Files.

Uploading Vendor/Customer Analytics Import File

You can change the transfer rules to handle particular situations, for example, the same D-U-N-S number has been matched to more than one vendor or customer number, a D-U-N-S number is listed as having been changed or deleted and so on. Changes to a transfer rule have to be done before you upload Vendor/ Customer Analytics Import Files.

.

Data source: 0DBDUNS_IMPORT_ATTR

Upload the Vendor/Customer Analytics Import File (0DB_IMPORTFILE_VC.csv) into the customer number (InfoObject 0CUSTOMER / 0VENDOR). Data target 0CUSTOMER / 0VENDOR is provided with flexible updating from InfoSource 0DBDUNS_IMPORT_ATTR.

The InfoObject 0VENDOR / 0CUSTOMER is enhanced with the D-U-N-S Number and current data provided by D&B.  During the upload, the match recommended flag in the vendor master data should be cleared – that is set to the constant space – for each vendor (see also Customizing the Match Recommended Flag)

For step-by-step instructions, see Uploading Initially Delivered D&B Files.

Applying Attribute Changes

After the D-U-N-S number, vendor master data, and customer master data has been reloaded, you have to apply attribute changes to the InfoObjects 0DBDUNS_NUM, 0VENDOR, and/or 0CUSTOMER.

To apply attribute changes to an InfoObject, proceed as follows:

1.       From the Administrator Workbench menu, select Tools and then Apply Hierarchy/Attribute change.

2.       Click on the InfoObject list button.

3.       Select the InfoObject to be activated and deselect any other InfoObjects.

4.       Click on the Save InfoObject list icon.

5.       Click on the Execute button.