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.

Sequence	Name	Description	Data Type	Length	Mandatory (Y/N)
1	Reserved1	Customer should not populate this field.		100
2	ApplicationTransactionID	Unique Transaction ID of the request	String	64	Y
3	Customer Reference Text	Filler for any future purposes		100
4	Customer Reference Text	Filler for any future purposes		100
5	Reserved2	Filler for any future purposes
6	Reserved3	Filler for any future purposes
7	Reserved4	Filler for any future purposes		100
8	Reserved5	Filler for any future purposes		100
9	DUNSNumber	The 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).	String	15	N
10	SubjectName	Company name / Principal Name	String	256	N
11	Reserved6	Filler for any future purposes		1
12	StreetAddressLine1	First line of this Organization's address	String	240	N
13	StreetAddressLine2	Second line of this Organization's address	String	240	N
14	PrimaryTownName	The name of the town or city recognized by the Postal Authority for delivering mail.	String	64	N
15	TerritoryName	Abbreviated Territory NameÂ	String	64	N
16	FullPostalCode	The Postal code for this entity's location	String	32	N
17	Reserved7	Filler for any future purposes		50
18	CountryISOAlpha2Code	The 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)	String	2	N
19	Reserved8	Filler for any future purposes		1
20	TelephoneNumber	The telephone number for this Subject	String	50	N
21	OrganizationIdentificationNumber.DNBCodeValue	Organization Identification Number Type code	Integer	7
22	OrganizationIdentificationNumber	Organization Identification Number	String	40	N

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