Cleanse and Match CDL Input

The following fields (fully-quoted and comma-separated) should be provided for each product request, followed by a carriage return/line-feed combination. If a specific data element is empty in the input file, still a comma delimiter should be present.

IMPORTANT: a carriage return/line-feed is required for the last record.

Sample

,1,,,,,,,804735132,"GORMAN MANUFACTURING COMPANY, INC.",,492 KOLLER ST,,SAN FRANCISCO,,94110,,US,,06505550000,,
,2,,,,,,,214567885,"D & B SAMPLE CO LTD",,MARLOW INTERNATIONAL PARKWAY,,MARLOW,,SL7 1AJ,,GB,,98841212120,,
,3,,,bloomberg.net,,,,,,,,,,,,,,,,,
,4,,,,test@bloomberg.net,,,,,,,,,,,,,,,,
,5,,,,,,,,bloomberg.net,,,,,,,,US,,,,

Sequence	Name	Description	Data Type	Length	Mandatory (Y/N)
1	Reserved1			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	URL	URL Information	String	100
6	Email	Email Address	String	100
7	Reserved4			100
8	Reserved5			100
9	DUNSNumber	The D-U-N-S Number is DandBs 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	String	256	N
11	Reserved6			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	TerritoryName	String	64	N
16	FullPostalCode	The country code for this entity's location	String	32	N
17	Reserved7			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.	String	2	N
19	Reserved8			1
20	TelephoneNumber	The telephone number for this Subject	String	50	N
21	OrganizationIdentificationNumber.DNBCodeValue		Integer	7
22	OrganizationIdentificationNumber	Organization Identification Number	String	40	N

Loading

Cleanse and Match CDL Input