Loading

Partners
Collapse

Results File Definition and Error Processing

As the D&B Global Batch Service cleanses and matches the entries in your list, it builds a results file with added fields as described in the output specification.

Output Specification

Output file fields will be fully-quoted and comma-separated. Records will be returned for each matched input record. Output records will be followed by a carriage return/line-feed combination.

SequenceNameDescriptionData TypeLength
1Reserved1Internal number generated by D&B  
2ApplicationTransactionIDUnique Transaction ID of the requestString64
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
9DUNSNumber (from the input request)The D-U-N-S Number is D&Bs identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).String15
10SubjectName (from the input request)Company nameString240
11Reserved6Filler for any future purposes 1
12StreetAddressLine1 (from the input request)First line of this Organization's addressString240
13StreetAddressLine2 (from the input request)Second line of this Organization's addressString240
14PrimaryTownName (from the input request)The name of the town or city recognized by the Postal Authority for delivering mail.String64
15TerritoryName (from the input request)TerritoryNameString64
16FullPostalCode (from the input request)The country code for this entity's locationString32
17Reserved7Filler for any future purposes 50
18CountryISOAlpha2Code (from the input request)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)String2
19Reserved8  1
20TelephoneNumber (from the input request)The telephone number for this SubjectString50
21OrganizationIdentificationNumber (from the input request)Organization Identification NumberString40
22OrganizationIdentificationNumber. DNBCodeValue (from the input request)Organization Identification Number Type codeInteger7
23OrganizationIdentificationNumber. TypeText (from the input request)Current version of service doesn't support this field. Filler for future useString256
24MatchDataCriteriaTextCurrent version of service doesn't support this fieldString256
25MatchDataCriteriaText. DNBCodeValueCurrent version of service doesn't support this fieldInteger7
26DUNSNumberThe D-U-N-S Number is D&Bs identification number, which provides unique identification of this organization, in accordance with the Data Universal Numbering System (D-U-N-S).Integer15
27OrganizationPrimaryName. OrganizationNameCompany NameString256
28TradeStyleName .OrganizationNameTrade Style NameString256
29SeniorPrinicipalName. FullNameCurrent version of service does nott support this fieldString240
30PrimaryAddress. StreetAddressLine1First Line of this Organization AddressString240
31PrimaryAddress. StreetAddressLine2Second Line of this Organization AddressString240
32PrimaryAddress. PrimaryTownNameThe name of the town or city recognized by the Postal Authority for delivering mail.String64
33PrimaryAddress. CountryISOAlpha2CodeThe 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)String2
34PrimaryAddress. PostalCodePostal Code with Extension, if Extension is availableString16
35PrimaryAddress. PostalCodeExtensionCodeCurrent version of service does not support this field (Extension will be part of the Postal Code field)String16
36PrimaryAddress. TerritoryOfficialNameTerritory Office NameString64
Current version of service does notsupport this field
37PrimaryAddress. TerritoryAbbreviatedNameAvailable only for US and Canada (See ISO STATE/PROVINCE CODES)String64
38PrimaryAddress. UndeliverableIndicator Boolean1
Both 0/1 OR Y/N can be returned in this field.
 
0=Deliverable
1=Undeliverable
 
N=Deliverable
Y=Undeliverable
39TelephoneNumber. TelecommunicationNumberThe telephone number for this SubjectString50
40TelephoneNumber. UnreachableIndicatorCurrent version of service does not support this fieldBoolean1
41 Both 0/1 OR Y/N can be returned in this field.String256
Out of Business Indicator 
 0 = In business
 1- Out of Business
  
 N = In business
 Y- Out of Business
42OperatingStatusText. DNBCodeValueCurrent version of service does not support this fieldInteger7
43 Current version of service does not support this fieldString256
StandAloneOrganizationIndicator
44ReservedFor future UseInteger7
Current version of service does not support this field
45FamilyMemberRole. FamilyMemberRoleText0=HQBoolean1
1=Single
2=Branch
Blank = Subsidiary
46OrganizationIdentificationNumberDetail. OrganizationIdentificationNumberOrganization Identification NumberString40
47OrganizationIdentificationNumberDetail. DNBCodeValueOrganization Identification Number Type CodeInteger7
48OrganizationIdentificationNumberDetail. DNBTypeText String256
49MatchQualityInformation. ConfidenceCodeValueConfidence Code ValueInteger2
50MatchQualityInformation.MatchGradeTextMatch Grade TextString11
51MatchQualityInformation. MatchGradeComponent_1. MatchGradeComponentScore Float11
52MatchQualityInformation. MatchGradeComponent_2. MatchGradeComponentScore Float11
53MatchQualityInformation. MatchGradeComponent_3. MatchGradeComponentScore Float11
54MatchQualityInformation. MatchGradeComponent_4. MatchGradeComponentScore Float11
55MatchQualityInformation. MatchGradeComponent_5. MatchGradeComponentScore Float11
56MatchQualityInformation. MatchGradeComponent_6. MatchGradeComponentScore Float11
57MatchQualityInformation. MatchGradeComponent_7. MatchGradeComponentScore Float11
58MatchQualityInformation. MatchGradeComponent_8. MatchGradeComponentScore Float11
59MatchQualityInformation. MatchGradeComponent_9. MatchGradeComponentScore Float11
60MatchQualityInformation. MatchGradeComponent_10. MatchGradeComponentScore Float11
61MatchQualityInformation. MatchGradeComponent_11. MatchGradeComponentScore Float11
62MatchQualityInformation. MatchDataProfileComponent_1. MatchDataProfileComponentValue String2
63MatchQualityInformation. MatchDataProfileComponent_2. MatchDataProfileComponentValue String2
64MatchQualityInformation. MatchDataProfileComponent_3. MatchDataProfileComponentValue String2
65MatchQualityInformation. MatchDataProfileComponent_4. MatchDataProfileComponentValue String2
66MatchQualityInformation. MatchDataProfileComponent_5. MatchDataProfileComponentValue String2
67MatchQualityInformation. MatchDataProfileComponent_6. MatchDataProfileComponentValue String2
68MatchQualityInformation. MatchDataProfileComponent_7. MatchDataProfileComponentValue String2
69MatchQualityInformation. MatchDataProfileComponent_8. MatchDataProfileComponentValue String2
70MatchQualityInformation. MatchDataProfileComponent_9. MatchDataProfileComponentValue String2
71MatchQualityInformation. MatchDataProfileComponent_10. MatchDataProfileComponentValue String2
72MatchQualityInformation. MatchDataProfileComponent_11. MatchDataProfileComponentValue String2
73MatchQualityInformation. MatchDataProfileComponent_12. MatchDataProfileComponentValue String2
74MatchQualityInformation. MatchDataProfileComponent_13. MatchDataProfileComponentValue String2
75MatchQualityInformation. MatchDataProfileComponent_14. MatchDataProfileComponentValue String2
76CleanseAndStandardizeResponseDetail. StandardizedName. OrganizationNameCleansed Company NameString256
77CleanseAndStandardizeResponseDetail. StandardizedName. OrganizationName. LanguageCodeCurrent Version of the service doesn't support this fieldInteger7
78CleanseAndStandardizeResponseDetail. StandardizedName. OrganizationName. WritingScriptISOAlpha4CodeCurrent Version of the service does not support this fieldString4
79CleanseAndStandardizeResponseDetail. StandardizedAddress. StreetAddressLine1First line of this Organization's address (Cleansed)String240
80CleanseAndStandardizeResponseDetail. StandardizedAddress. StreetAddressLine2Second line of this Organization's address (Cleansed)String240
81CleanseAndStandardizeResponseDetail. StandardizedAddress. PrimaryTownNameThe name of the town or city recognized by the Postal Authority for delivering mail. (Cleansed)String64
82CleanseAndStandardizeResponseDetail. StandardizedAddress. CountyNameCleansed Address - County NameString64
83CleanseAndStandardizeResponseDetail. StandardizedAddress. TerritoryAbbreviatedNameCleansed Address - Territory Abbreviated NameString64
84CleanseAndStandardizeResponseDetail. StandardizedAddress. TerritoryNameCleansed Address - Territory NameString64
85CleanseAndStandardizeResponseDetail. StandardizedAddress. PostalCodeCleansed Address - Postal CodeString16
86CleanseAndStandardizeResponseDetail. StandardizedAddress. PostalCodeExtensionCodeCurrent version of the service does not support this field.String16
87CleanseAndStandardizeResponseDetail. StandardizedAddress. CountryISOAlpha2CodeThe two-letter country code, defined in the ISO 3166-1 scheme published by International Organization for Standardization (ISO), identifying the country for this address.String2
88CleanseAndStandardizeResponseDetail. StandardizedAddress. CountryNameCleansed Address - Country NameString64
89CleanseAndStandardizeResponseDetail. StandardizedAddress. DeliveryPointValidationDetail. StatusValueBR: Y - Submitted address is valid, including, if required for delivery, the secondary address: suite, room, floor or apartment #. This is equal to DSF Deliverability Indicator #1.String64
N - Submitted address is invalid and possibly to definitely undeliverable. It might however, qualify for a ZIP+4. This is equal to DSF Deliverability Indicator #4 or higher or X.
S - Secondary address invalid: submitted street address is valid, but the submitted secondary address - the suite, room, floor or apartment # -- required for delivery at this location, is incorrect. This address is possibly deliverable, at the letter carrier's option. This is equal to DSF Deliverability Indicator #2.
D - Secondary address missing: submitted street address is valid, but the secondary address - the suite, room, floor or apartment # -- required for delivery at this location, is missing. This address is possibly deliverable, at the letter carrier's option.
L - Submitted address is invalid, undeliverable and could not be identified by DPV. This is a fictitious address on the DPV file designed to identify miss-use of USPS data. Contact your DB rep.
Blank - DPV cannot categorize the input address.
90CleanseAndStandardizeResponseDetail. StandardizedAddress. DeliveryPointValidationDetail. CMRAValueBR: Y - The address is a valid Commercial Mail Receiving Agency (CMRA). A CMRA is a private business that accepts mail delivery from the Postal Service for others (addressee), holds it for pickup (in most cases a private mailbox ("PMB") or re-mails it to another address with payment of new postage. (Example: "Mailboxes, Etc.")String64
N - The address is not a valid Commercial Mail Receiving Agency (CMRA).
L - Submitted address is invalid, undeliverable and could not be identified by DPV. These are "decoy" fantasy addresses.
Blank - DPV cannot categorize the input address
91CleanseAndStandardizeResponseDetail. StandardizedAddress. AddressTypeValueAddress TypeString64

Batch Errors

All the records that failed processing will be returned in a CSV file. The format of this CSV file is similar to the Input CSV file except that there is an additional field at the end that has the error code.

ErrorCode
Invalid Input Record FormatCM002
Missing Country CodeCM003
Invalid / Unsupported Country CodeCM011
Missing Chunks RecordsCM004
Invalid Territory ProvidedCM016