Attribute Mapping for Direct 2.0 Batch API
You can perform the default mapping of D&B attributes with Reltio attributes which are available as out-of-the-box attributes in Account 360 for the Batch API.
The following are the default mapping of D&B attributes with the Reltio attributes for the Batch API.
| D&B Batch Position Names | D&B Attribute Name | Reltio Attribute Name |
|---|---|---|
field073 |
Match Code |
attributes.MatchQuality[0].value.MatchCode[].value |
field074 |
BEMFAB (Marketability) |
attributes.MatchQuality[0].value.BEMFAB[].value |
field075 |
D-U-N-S Number |
attributes.DUNSNumber[0].value |
#Batch |
#N/A |
attributes.DnBSource[0].value |
field076 |
MatchGrade |
attributes.MatchQuality[0].value.MatchGrade[].value |
field077 |
Confidence Code |
attributes.MatchQuality[0].value.ConfidenceCode[].value |
field079 |
Name Profile Code |
attributes.MatchQuality[0].value.NameProfileCode[].value |
field080 |
Street Number Profile Code |
attributes.MatchQuality[0].value.StreetNumberProfileCode[].value |
field081 |
Street Name Profile Code |
attributes.MatchQuality[0].value.StreetNameProfileCode[].value |
field082 |
City Profile Code |
attributes.MatchQuality[0].value.CityProfileCode[].value |
field083 |
State/Province Profile Code |
attributes.MatchQuality[0].value.StateProvinceProfileCode[].value |
field084 |
PO Box Profile Code |
attributes.MatchQuality[0].value.POBoxProfileCode[].value |
field085 |
Phone Profile Code |
attributes.MatchQuality[0].value.PhoneProfileCode[].value |
field086 |
ZIP Profile Code |
attributes.MatchQuality[0].value.ZIPProfileCode[].value |
field087 |
SIC Profile Code |
attributes.MatchQuality[0].value.SICProfileCode[].value |
field088 |
Density Profile Code |
attributes.MatchQuality[0].value.DensityProfileCode[].value |
field089 |
Uniqueness Profile Code |
attributes.MatchQuality[0].value.UniquenessProfileCode[].value |
field107 |
Business Name |
attributes.Name[0].value |
field108 |
Tradestyle Name |
attributes.TradeStyleName[0].value.OrganizationName[].value |
field110 |
Street Address |
attributes.Addresses[0].value.AddressLine1[].value |
#Shipping |
#N/A |
attributes.Addresses[0].value.AddressType[].value |
#true |
#N/A |
attributes.Addresses[0].value.Primary[].value |
field008 |
PO_Box |
attributes.Addresses[0].value.POBox[].value |
field015 |
NCOA Move Effective Date |
attributes.Addresses[0].value.NCOAMoveEffectiveDate[].value |
field017 |
NIXIE A |
attributes.Addresses[0].value.NCOANIXIEA[].value |
field018 |
NIXIE B |
attributes.Addresses[0].value.NCOANIXIEB[].value |
field019 |
NIXIE C |
attributes.Addresses[0].value.NCOANIXIEC[].value |
field020 |
Primary Number |
attributes.Addresses[0].value.PremiseNumber[].value |
field021 |
Pre-Directional |
attributes.Addresses[0].value.USPSPreDirectional[].value |
field022 |
Street Name |
attributes.Addresses[0].value.USPSStreetName[].value |
field023 |
Street Suffix |
attributes.Addresses[0].value.USPSStreetSuffix[].value |
field024 |
Post Directional |
attributes.Addresses[0].value.USPSPostDirectional[].value |
field025 |
Unit Designator |
attributes.Addresses[0].value.UnitName[].value |
field026 |
Secondary Number |
attributes.Addresses[0].value.UnitValue[].value |
field027 |
City |
attributes.Addresses[0].value.USPSCity[].value |
field028 |
State |
attributes.Addresses[0].value.USPSState[].value |
field029 |
ZIP Code |
attributes.Addresses[0].value.USPSZip5[].valu |
field031 |
Delivery Point Barcode |
attributes.Addresses[0].value.DeliveryPointBarCode[].value |
field032 |
Carrier Route Code |
attributes.Addresses[0].value.CarrierRoute[].value |
field033 |
Line of Travel Code |
attributes.Addresses[0].value.USPSLineofTravelCode[].value |
field034 |
AA Match Flag |
attributes.Addresses[0].value.USPSAAMatchFlag[].value |
field035 |
DSF Match Flag |
attributes.Addresses[0].value.USPSDSFMatchFlag[].value |
field036 |
DSF Sort |
attributes.Addresses[0].value.USPSDSFSort[].value |
field037 |
Deliverability Indicator |
attributes.Addresses[0].value.USPSDeliverabilityIndicator[].value |
field038 |
DSF Deliverability Type |
attributes.Addresses[0].value.USPSDSFDeliverabilityType[].value |
field039 |
DSF Vacancy Indicator |
attributes.Addresses[0].value.USPSDSFVacancyIndicator[].value |
field040 |
DSF Seasonal Indicator |
attributes.Addresses[0].value.USPSDSFSeasonalIndicator[].value |
field041 |
DSF Drop Indicator |
attributes.Addresses[0].value.USPSDSFDropIndicator[].value |
field042 |
Primary Address |
attributes.Addresses[0].value.NCOAPrimaryAddress[].value |
field044 |
PriNum Change Indicator |
attributes.Addresses[0].value.NCOAPriNumChangeIndicator[].value |
field045 |
PreDir Change Indicator |
attributes.Addresses[0].value.NCOAPreDirChangeIndicator[].value |
field046 |
PriName Change Indicator |
attributes.Addresses[0].value.NCOAPriNameChangeIndicator[].value |
field047 |
Suffix Change Indicator |
attributes.Addresses[0].value.NCOASuffixChangeIndicator[].value |
field048 |
PostDir Change Indicator |
attributes.Addresses[0].value.NCOAPostDirChangeIndicator[].value |
field049 |
SecUnitDes Change Indicator |
attributes.Addresses[0].value.NCOASecUnitDesChangeIndicator[].value |
field050 |
SecNum Change Indicator |
attributes.Addresses[0].value.NCOASecNumChangeIndicator[].value |
field051 |
CityName Change Indicator |
attributes.Addresses[0].value.NCOACityNameChangeIndicator[].value |
field052 |
StateAbrev Change Indicator |
attributes.Addresses[0].value.NCOAStateAbrevChangeIndicator[].value |
field053 |
ZIPCode Change Indicator |
attributes.Addresses[0].value.NCOAZIPCodeChangeIndicator[].value |
field054 |
ZIP4 Change Indicator |
attributes.Addresses[0].value.NCOAZIP4ChangeIndicator[].value |
field055 |
Cleansed Address 1 |
attributes.Addresses[0].value.DnBCleansedAddress1[].value |
field056 |
Cleansed Address 2 |
attributes.Addresses[0].value.DnBCleansedAddress2[].value |
field057 |
Cleansed Address 3 |
attributes.Addresses[0].value.DnBCleansedAddress3[].value |
field058 |
Cleansed Address 4 |
attributes.Addresses[0].value.DnBCleansedAddress4[].value |
field060 |
Cleansed Country Name |
attributes.Addresses[0].value.DnBCleansedCountryName[].value |
field061 |
Cleansed County/Province |
attributes.Addresses[0].value.DnBCleansedCountyProvince[].value |
field062 |
Cleansed City |
attributes.Addresses[0].value.DnBCleansedCity[].value |
field063 |
Cleansed State/Province |
attributes.Addresses[0].value.DnBCleansedStateProvince[].value |
field064 |
Cleansed Postal Code |
attributes.Addresses[0].value.DnBCleansedPostalCode[].value |
field065 |
Cleansed Process Code |
attributes.Addresses[0].value.DnBCleansedProcessCode[].value |
field066 |
Profanity Flag |
attributes.Addresses[0].value.DnBProfanityFlag[].value |
field067 |
Cleansed Address Status Code |
attributes.Addresses[0].value.DnBCleansedAddressStatusCode[].value |
field068 |
Highest Level of Address Verification |
attributes.Addresses[0].value.DnBHighestLevelofAddressVerification[].value |
field069 |
Cleanse Match Return Code |
attributes.Addresses[0].value.DnBCleanseMatchReturnCode[].value |
field070 |
Global Deliverability Code |
attributes.Addresses[0].value.DnBGlobalDeliverabilityCode[].value |
field071 |
Global Deliverability Summary Code |
attributes.Addresses[0].value.DnBGlobalDeliverabilitySummaryCode[].value |
field090 |
Customer Address DSF Code |
attributes.Addresses[0].value.BDNCustomerAddressDSFCode[].value |
field091 |
Physical Address Type Code |
attributes.Addresses[0].value.BDNPhysicalAddressTypeCode[].value |
field092 |
Physical Address DSF Code |
attributes.Addresses[0].value.BDNPhysicalAddressDSFCode[].value |
field093 |
Mailing Address Type Code |
attributes.Addresses[0].value.BDNMailingAddressTypeCode[].value |
field094 |
Mailing Address DSF Code |
attributes.Addresses[0].value.BDNMailingAddressDSFCode[].value |
field095 |
DPV code-Physical Address (non-branch) |
attributes.Addresses[0].value.DPVConfirmedIndicator[].value |
field096 |
DPV code-Physical Address (branch) |
attributes.Addresses[0].value.BDNDPVcodeBranch[].value |
field097 |
Physical Address Delivery Type Code |
attributes.Addresses[0].value.BDNPhysicalAddressDeliveryTypeCode[].value |
field098 |
Mailing Address Delivery Type Code |
attributes.Addresses[0].value.BDNMailingAddressDeliveryTypeCode[].value |
field099 |
DSF Physical Address Type Match Flag |
attributes.Addresses[0].value.BDNDSFPhysicalAddressTypeMatchFlag[].value |
field100 |
DSF Mailing Address Type Match Flag |
attributes.Addresses[0].value.BDNDSFMailingAddressTypeMatchFlag[].value |
field101 |
CMRA Code - Physical Address |
attributes.Addresses[0].value.CMRAIndicator[].value |
field102 |
CMRA Code - Mailing Address |
attributes.Addresses[0].value.BDNCMRACodeMailingAddress[].value |
field103 |
Correction Opportunity Indicator |
attributes.Addresses[0].value.BDNCorrectionOpportunityIndicator[].value |
field109 |
Registered Address Indicator |
attributes.Addresses[0].value.Registered[].value |
field111 |
Street Address 2 |
attributes.Addresses[0].value.AddressLine2[].value |
field112 |
City Name |
attributes.Addresses[0].value.City[].value |
field113 |
State/Province Name |
attributes.Addresses[0].value.DnBStateProvince[].value |
field114 |
Country Name |
attributes.Addresses[0].value.Country[].value |
field115 |
D&B City Code |
attributes.Addresses[0].value.CityCode[].value |
field116 |
D&B US County Code |
attributes.Addresses[0].value.CountyCode[].value |
field117 |
D&B State Code |
attributes.Addresses[0].value.StateCode[].value |
field118 |
State/Province Abbreviation |
attributes.Addresses[0].value.StateProvince[].value |
field119 |
D&B Country Code |
attributes.Addresses[0].value.CountryCode[].value |
field120 |
Postal Code |
attributes.Addresses[0].value.PostalCode[].value |
field121 |
D&B Continent Code |
attributes.Addresses[0].value.ContinentCode[].value |
field134 |
National Identification Number |
attributes.Addresses[0].value.NationalIDNumber[].value |
field135 |
National Identification Type Code |
attributes.Addresses[0].value.NationalIDTypeCode[].value |
field229 |
Latitude |
attributes.Addresses[0].value.DnBLatitude[].value |
field230 |
Longitude |
attributes.Addresses[0].value.DnBLongitude[].value |
field122 |
Mailing Address |
attributes.Addresses[1].value.AddressLine1[].value |
#Mailing |
#N/A |
attributes.Addresses[1].value.AddressType[].value |
field123 |
Mailing City Name |
attributes.Addresses[1].value.City[].value |
field124 |
Mailing County Name |
attributes.Addresses[1].value.County[].value |
field125 |
Mailing State/Province Name |
attributes.Addresses[1].value.DnBStateProvince[].value |
field126 |
Mailing Country Name |
attributes.Addresses[1].value.Country[].value |
field127 |
D&B Mailing City Code |
attributes.Addresses[1].value.CityCode[].value |
field128 |
D&B Mailing County Code |
attributes.Addresses[1].value.CountyCode[].value |
field129 |
D&B Mailing State/Province Code |
attributes.Addresses[1].value.StateCode[].value |
field130 |
Mailing State/Province Abbreviation |
attributes.Addresses[1].value.StateProvince[].value |
field131 |
D&B Mailing Country Code |
attributes.Addresses[1].value.CountryCode[].value |
field132 |
Mailing Postal Code |
attributes.Addresses[1].value.PostalCode[].value |
field133 |
D&B Mailing Continent Code |
attributes.Addresses[1].value.ContinentCode[].value |
field137 |
Telephone Number |
attributes.Phone[0].value.Number[].value |
#Phone |
#N/A |
attributes.Phone[0].value.Type[].value |
#true |
#N/A |
attributes.Phone[0].value.PrimaryPhoneFlag[].value |
field136 |
Country Access Code |
attributes.Phone[0].value.CountryCode[].value |
field138 |
Cable Telex Number |
attributes.CableTelexNumber[].value |
field139 |
Facsimile Number |
attributes.Phone[1].value.Number[].value |
#Fax |
#N/A |
attributes.Phone[1].value.Type[].value |
#true |
#N/A |
attributes.Phone[1].value.PrimaryPhoneFlag[].value |
field136 |
Country Access Code |
attributes.Phone[1].value.CountryCode[].value |
field140 |
Chief Executive Officer Name |
attributes.CurrentPrincipal[0].value.FullName[].value |
field141 |
Chief Executive Officer Title |
attributes.CurrentPrincipal[0].value.Title[].value |
field142 |
Line of Business |
TRASH |
field143 |
US 1987 SIC 1 |
attributes.IndustryCode[6].value.IndustryCode[].value |
#SIC 1 |
#N/A |
attributes.IndustryCode[6].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[6].value.IndustryTypeCode[].value |
field144 |
US 1987 SIC 2 |
attributes.IndustryCode[7].value.IndustryCode[].value |
#SIC 2 |
#N/A |
attributes.IndustryCode[7].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[7].value.IndustryTypeCode[].value |
field145 |
US 1987 SIC 3 |
attributes.IndustryCode[8].value.IndustryCode[].value |
#SIC 3 |
#N/A |
attributes.IndustryCode[8].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[8].value.IndustryTypeCode[].value |
field146 |
US 1987 SIC 4 |
attributes.IndustryCode[9].value.IndustryCode[].value |
#SIC 4 |
#N/A |
attributes.IndustryCode[9].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[9].value.IndustryTypeCode[].value |
field147 |
US 1987 SIC 5 |
attributes.IndustryCode[10].value.IndustryCode[].value |
#SIC 5 |
#N/A |
attributes.IndustryCode[10].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[10].value.IndustryTypeCode[].value |
field148 |
US 1987 SIC 6 |
attributes.IndustryCode[11].value.IndustryCode[].value |
#SIC 6 |
#N/A |
attributes.IndustryCode[11].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[11].value.IndustryTypeCode[].value |
field149 |
Primary Local Activity Code |
attributes.IndustryCode[12].value.IndustryCode[].value |
#Primary |
#N/A |
attributes.IndustryCode[12].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[12].value.IndustryTypeCode[].value |
field142 |
Line of Business |
attributes.IndustryCode[12].value.IndustryCodeDescription[].value |
field150 |
Local Activity Type Code |
TRASH |
field151 |
Year Started |
attributes.FoundedYear[].value |
field152 |
Sales Volume (local currency) |
attributes.KeyFinancialFiguresOverview[0].value.SalesRevenueAmountLocal[].value |
field153 |
Sales Volume Reliability Code |
TRASH |
field154 |
Sales Volume (US Dollars) |
attributes.KeyFinancialFiguresOverview[0].value.SalesRevenueAmount[].value |
field153 |
Sales Volume Reliability Code |
attributes.KeyFinancialFiguresOverview[0].value.SalesRevenueReliabilityCode[0].value |
field155 |
Currency Code |
attributes.KeyFinancialFiguresOverview[0].value.SalesRevenueCurrencyCode[0].value |
field235 |
3 Year Growth Percentage on Sales Volume |
attributes.KeyFinancialFiguresOverview[0].value.Sales3YryGrowthRate[0].value |
field236 |
3 Year Growth Percentage on Employees |
attributes.KeyFinancialFiguresOverview[0].value.Employee3YryGrowthRate[0].value |
field237 |
5 Year Growth Percentage on Sales Volume |
attributes.KeyFinancialFiguresOverview[0].value.Sales5YryGrowthRate[0].value |
field238 |
5 Year Growth Percentage on Employees |
attributes.KeyFinancialFiguresOverview[0].value.Employee5YryGrowthRate[0].value |
field155 |
Currency Code |
TRASH |
field156 |
Employees Here |
attributes.EmployeeDetails[0].value.IndividualTotalEmployeeQuantity[].value |
field157 |
Employees Here Reliability Code |
attributes.EmployeeDetails[0].value.IndividualReliabilityText[].value |
field158 |
Employees Total |
attributes.EmployeeDetails[0].value.TotalEmployeeQuantity[].value |
field159 |
Employees Total Reliability Code |
attributes.EmployeeDetails[0].value.TotalEmployeeReliability[].value |
field160 |
Principals Included Indicator |
attributes.EmployeeDetails[0].value.PrincipalsIncluded[].value |
field161 |
Import/Export/Agent Code |
attributes.ActivitiesAndOperations[0].value.ImportExportAgentCode[].value |
field162 |
Legal Status Code |
attributes.LegalStatusCode[].value |
field163 |
Filler |
TRASH |
field164 |
Status Code |
attributes.StatusCode[].value |
field165 |
Subsidiary Indicator |
attributes.IsSubsidiary[].value |
field166 |
Previous D-U-N-S Number |
attributes.PriorDUNSNUmber[0].value.TransferredFromDUNSNumber[].value |
field167 |
Full Report Date |
attributes.DnBFullReportDate[].value |
field195 |
Global Ultimate Country Name |
TRASH |
field202 |
Number of Family Members |
attributes.DnBNumberOfFamilyMembers[].value |
field203 |
Dias Code |
attributes.DnBDIASCode[].value |
field204 |
Hierarchy Code |
attributes.DnBHierarchyCode[].value |
field205 |
Last Update Date |
attributes.DnBLastUpdateDate[].value |
field206 |
Filler |
TRASH |
field207 |
NYSE Ticker |
attributes.Ticker[0].value.StockExchange[].value
|
field208 |
ASE Ticker |
attributes.Ticker[1].value.StockExchange[].value |
field209 |
NMS Ticker |
attributes.Ticker[2].value.StockExchange[].value |
field210 |
NAS Ticker |
attributes.Ticker[3].value.StockExchange[].value |
field211 |
OTC Ticker |
attributes.Ticker[4].value.StockExchange[].value
|
field212 |
Tradestyle 2 |
attributes.TradeStyleName[0].value.OrganizationName[].value |
field213 |
Tradestyle 3 |
attributes.TradeStyleName[0].value.OrganizationName[].value |
field214 |
Tradestyle 4 |
attributes.TradeStyleName[0].value.OrganizationName[].value |
field215 |
Tradestyle 5 |
attributes.TradeStyleName[0].value.OrganizationName[].value |
field216 |
Primary NAICS 1_1 Code |
attributes.IndustryCode[0].value.IndustryCode[].value |
#NAICS 1_1 |
#N/A |
attributes.IndustryCode[0].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[0].value.IndustryTypeCode[].value |
field217 |
Primary NAICS 1_1 Description |
attributes.IndustryCode[0].value.IndustryCodeDescription[].value |
field218 |
NAICS 2_1 Code |
attributes.IndustryCode[1].value.IndustryCode[].value |
#NAICS 2_1 |
#N/A |
attributes.IndustryCode[1].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[1].value.IndustryTypeCode[].value |
field219 |
NAICS 2_1 Description |
attributes.IndustryCode[1].value.IndustryCodeDescription[].value |
field220 |
NAICS 3_1 Code |
attributes.IndustryCode[2].value.IndustryCode[].value |
#NAICS 3_1 |
#N/A |
attributes.IndustryCode[2].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[2].value.IndustryTypeCode[].value |
field221 |
NAICS 3_1 Description |
attributes.IndustryCode[2].value.IndustryCodeDescription[].value |
field222 |
NAICS 4_1 Code |
attributes.IndustryCode[3].value.IndustryCode[].value |
#NAICS 4_1 |
#N/A |
attributes.IndustryCode[3].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[3].value.IndustryTypeCode[].value |
field223 |
NAICS 4_1 Description |
attributes.IndustryCode[3].value.IndustryCodeDescription[].value |
field224 |
NAICS 5_1 Code |
attributes.IndustryCode[4].value.IndustryCode[].value |
#NAICS 5_1 |
#N/A |
attributes.IndustryCode[4].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[4].value.IndustryTypeCode[].value |
field225 |
NAICS 5_1 Description |
attributes.IndustryCode[4].value.IndustryCodeDescription[].value |
field226 |
NAICS 6_1 Code |
attributes.IndustryCode[5].value.IndustryCode[].value |
#NAICS 6_1 |
#N/A |
attributes.IndustryCode[5].value.Type[].value |
field150 |
Local Activity Type Code |
attributes.IndustryCode[5].value.IndustryTypeCode[].value |
field227 |
NAICS 6_1 Description |
attributes.IndustryCode[5].value.IndustryCodeDescription[].value |
field228 |
Owns/Rents Code |
attributes.OwnsOrRents[].value |
field231 |
Manufacturing Indicator |
attributes.IsManufacturing[].value |
field232 |
Minority Owned Indicator |
attributes.IsMinorityOwned[].value |
field233 |
Public/Private Indicator |
attributes.IsPublicPrivate[].value |
field234 |
Square Footage |
attributes.FacilitySizeInSqFeet[].value |
field241 |
Marketability Indicator |
attributes.MarketabilityIndicator[].value |
field242 |
#N/A |
attributes.WebsiteURL[].value |