This table information is designed to be used when following the steps in the Dun & Bradstreet Migration from Direct 2.0 to Direct+ topic in the Resource Materials section here.
The 'Copy script action' column indicate the changes that will occur once the migration script is executed.
The 'Cleanup attribute group' shows what should manually be deleted or have validity removed after the migration script has successfully been executed.
|
Outdated Direct 2.0 Data Containers |
New in Direct+ |
Copy script action |
Cleanup attribute group |
Comment |
|---|---|---|---|---|
|
Multi valued |
Single valued Data Container |
Copied first instance; User to receive warning if more than one instance is found |
|
Old and new Data Container almost the same: Primary -> Prim |
|
DnBDomesticUltimatePrimaryAddress .DnBTerritoryName .DnBCountryISOAlpha2Code .DnBPrimaryTownName .DnBPostalCode .DnBStreetAddressLine .DnBTerritoryAbbreviatedName |
DnBDomesticUltimatePrimAddress .DnBAddressRegionName .DnBCountryISOAlpha2Code .DnBAddressLocalityName .DnBPostalCode .DnBStreetAddressLine .DnBAddressRegionAbbreviatedName |
- |
Deleted DC |
-
|
|
Multi valued |
Single valued attribute |
Copied first instance to attribute; User to receive warning if more than one instance is found |
|
Old Data Container and new attribute name almost the same: Primary -> Prim |
|
DnBDomesticUltimatePrimaryName .DnBOrganizationName |
DnBDomesticUltimatePrimName |
-
|
Deleted DC
|
-
|
|
Multi valued |
Single valued Data Container |
Copied first instance; Users to receive warning if more than one instance is found |
|
Old and new Data Container almost the same: Primary -> Prim |
|
DnBGlobalUltimatePrimaryAddress .DnBTerritoryName .DnBCountryISOAlpha2Code .DnBPrimaryTownName .DnBPostalCode .DnBStreetAddressLine .DnBTerritoryAbbreviatedName |
DnBGlobalUltimatePrimAddress .DnBAddressRegionName .DnBCountryISOAlpha2Code .DnBAddressLocalityName .DnBPostalCode .DnBStreetAddressLine .DnBAddressRegionAbbreviatedName |
-
|
Deleted DC
|
-
|
|
Multi valued |
Single valued attribute |
Copied first instance to attribute; User to receive warning if more than one instance is found |
|
Old Data Container and new attribute name almost the same: Primary -> Prim |
|
DnBGlobalUltimatePrimaryName .DnBOrganizationName |
DnBGlobalUltimatePrimName |
-
|
Deleted DC |
-
|
|
Multi valued |
Single valued Data Container |
Copied first instance; User to receive warning if more than one instance is found |
|
Old and new Data Container almost the same: Primary -> Prim |
|
DnBHeadquartersPrimaryAddress .DnBTerritoryName .DnBCountryISOAlpha2Code .DnBPrimaryTownName .DnBPostalCode .DnBStreetAddressLine .DnBTerritoryAbbreviatedName |
DnBHeadquartersPrimAddress .DnBAddressRegionName .DnBCountryISOAlpha2Code .DnBAddressLocalityName .DnBPostalCode .DnBStreetAddressLine .DnBAddressRegionAbbreviatedName |
-
|
Deleted DC
|
-
|
|
Multi valued |
Single valued Data Container |
Copied first instance; Users to receive warning if more than one instance is found. |
|
Old and new Data Container almost the same: Organization -> Org |
|
DnBOrganizationMailingAddress .DnBTerritoryOfficialName .DnBCountryISOAlpha2Code .DnBPrimaryTownName .DnBPostalCode .DnBStreetAddressLine .DnBCountyOfficialName .DnBTerritoryAbbreviatedName .DnBUndeliverableIndicator |
DnBOrgMailingAddress .DnBAddressRegionName .DnBCountryISOAlpha2Code .DnBAddressLocalityName .DnBPostalCode .DnBStreetAddressLine .DnBCountyOfficialName .DnBAddressRegionAbbreviatedName DnBIsMailUndeliverable (Attribute on entity) |
Special handling was used for DnBUndeliverableIndicator which is copied to attribute on entity DnBIsMailUndeliverable |
Deleted DC
|
-
|
|
Multi valued |
Single valued Data Container |
Copied first instance; User to receive warning if more than one instance is found. |
|
Old and new Data Container almost the same: Primary -> Prim |
|
DnBOrganizationPrimaryAddress |
DnBOrganizationPrimAddress |
- |
Deleted DC |
- |
| .DnBRegisteredAddressIndicator |
.DnBIsRegisteredAddressIndicator |
Changed from Text to DnBBoolean LOV |
|
- |
|
.DnBGeographicalPrecisionText |
.DnBGeographicalPrecision |
Changed from Text to DnBGeographicalPrecisionLOV |
|
-
|
|
.DnBCountryISOAlpha2Code |
.DnBCountryISOAlpha2Code |
- |
|
-
|
|
.DnBResidentialAddressIndicator |
.DnBResidentialAddressIndicator |
Changed from Text to DnBBoolean LOV |
|
- |
|
.DnBLatitudeMeasurement .DnBPrimaryTownName .DnBAddressUsageTenureDetail .DnBCountryGroupName .DnBPremisesFunctionText .DnBTerritoryOfficialName .DnBMinorTownName .DnBPoliticalDistrict .DnBUndeliverableIndicator .DnBPostalCode .DnBLongitudeMeasurement .DnBStreetAddressLine .DnBTerritoryAbbreviatedName .DnBCountyOfficialName .DnBMetropolitanStatAreaUSCensusCode .DnBPolticalDistrict |
.DnBLatitudeMeasurement .DnBAddressLocalityName .DnBAddressUsageTenureDetail .DnBCountryGroupName <Obsolete> .DnBAddressRegionName .DnBMinorTownName <Obsolete> <Obsolete> .DnBPostalCode .DnBLongitudeMeasurement .DnBStreetAddressLine .DnBAddressRegionAbbreviatedName .DnBCountyOfficialName .DnBMetropolitanStatAreaUSCensusCode <Obsolete> |
- | - | |
|
.DnBUndeliverableIndicator |
<Obsolete> |
- |
Refer to DnBOrganizationMailingAddress |
|
|
.DnBPostalCode .DnBLongitudeMeasurement .DnBStreetAddressLine .DnBTerritoryAbbreviatedName .DnBCountyOfficialName .DnBMetropolitanStatAreaUSCensusCode |
.DnBPostalCode .DnBLongitudeMeasurement .DnBStreetAddressLine .DnBAddressRegionAbbreviatedName .DnBCountyOfficialName .DnBMetropolitanStatAreaUSCensusCode |
- | - | |
|
Multi valued |
Single valued Data Container |
Copied first instance; User to receive warning if more than one instance is found. |
|
Old and new Data Container almost the same: Primary -> Prim |
|
.DnBParentPrimaryAddress .DnBTerritoryName .DnBCountryISOAlpha2Code .DnBPrimaryTownName .DnBPostalCode .DnBStreetAddressLine .DnBTerritoryAbbreviatedName |
DnBParentPrimAddress .DnBAddressRegionName .DnBCountryISOAlpha2Code .DnBAddressLocalityName .DnBPostalCode .DnBStreetAddressLine .DnBAddressRegionAbbreviatedName |
-
|
Deleted DC
|
-
|
|
Single valued |
Single valued attribute |
Copied Data Container instance to attribute |
|
Old Data Container and new attribute name almost the same: Primary -> Prim |
|
DnBParentPrimaryName .DnBOrganizationName |
DnBParentPrimName
|
-
|
Deleted DC
|
- |
|
DnBRegLocationPrimaryAddress |
- |
- |
Deleted |
Obsolete |
|
DnBSocialMediaDetail |
- |
- |
Deleted |
Obsolete |
|
DnBTransferDUNSNumberRegistration |
- |
- |
Deleted |
Obsolete |
Additional D&B migration tables can be found in these topics:
- Migration Table 1: Outdated Direct V2.0 Attributes (here)
- Migration Table 3: Outdated Direct V2.0 Attributes on Outdated Data Containers (here)
- Migration Table 4: Direct V2.0 Data Containers Kept for Direct+ (here)
- Migration Table 5: Outdated Direct V2.0 LOVs (here)