Loading

Partners
Collapse

Preparing Your Lists for Upload

The D&B Global Batch Service expects customer files to be uploaded in a specific format/layout with a standardized name.

[ARE GBS CUSTOMERS ALLOWED TO PROVIDE THE CONTROL FILES?]

Required File Naming

The customer list file name should follow the following format:

<APPID>.<ProfileID>.<AppBatchID>.<MMDDYYYYHHMISSS>.PCMGBIMatch

[WE NEED EXPLANATION OF THESE VALUES]

  • APPID
  • ProfileID
  • AppBatchID

NOTE: The maximum uncompressed customer input file size one gigabyte (1 GB). Whenever are particular customer file size exceeds this size, the file should be subdivided, generating unique timestamps in the name of each file.

Input Specification

Input file fields must be fully-quoted and comma-separated (CSV) for each record to be matched. Every record must be followed by a carriage return/line-feed combination. IMPORTANT: Carriage return/line-feed is required for the last record also. If a specific data element is empty in the input file, still a comma delimiter should be present.

SequenceNameDescriptionData TypeLengthMandatory (Y/N)
1Reserved1Customer should not populate this field. 100 
2ApplicationTransactionIDUnique Transaction ID of the requestString64Y
3Customer Reference TextFiller for any future purposes 100 
4Customer Reference TextFiller for any future purposes 100 
5Reserved2Filler for any future purposes   
6Reserved3Filler for any future purposes   
7Reserved4Filler for any future purposes 100 
8Reserved5Filler for any future purposes 100 
9DUNSNumberThe D-U-N-S Number is D&B's identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).String15N
10SubjectNameCompany name / Principal NameString256N
11Reserved6Filler for any future purposes 1 
12StreetAddressLine1First line of this Organization's addressString240N
13StreetAddressLine2Second line of this Organization's addressString240N
14PrimaryTownNameThe name of the town or city recognized by the Postal Authority for delivering mail.String64N
15TerritoryNameAbbreviated Territory Name String64N
16FullPostalCodeThe Postal code for this entity's locationString32N
17Reserved7Filler for any future purposes 50 
18CountryISOAlpha2CodeThe two-letter country code, defined in the ISO 3166-1 scheme published by International Organization for Standardization (ISO), identifying the country for this address. (See ISO COUNTRY CODES)String2N
19Reserved8Filler for any future purposes 1 
20TelephoneNumberThe telephone number for this SubjectString50N
21OrganizationIdentificationNumber.DNBCodeValueOrganization Identification Number Type codeInteger7 
22OrganizationIdentificationNumberOrganization Identification NumberString40N

Compression Requirement

The D&B Global Batch Service requires GZIP compression for all input and output files. Customers are expected to support GZIP compressed/un-compression methods.

Optional Encryption

In scenarios where a customer is concerned about the transfer of sensitive data, the customer may request to use encryption file using a D&B Public key that will be provided by a D&B representative. PGP- RSA is the preferred encryption for STP.

What to do Next

Once your list has been prepared, you may access the STP site and upload it.