When you purchase D&B data online or batch load D&B information, certain D&B data elements are mapped to the appropriate columns in the TCA Registry. Most of the columns have the same names as the D&B data elements, but other columns have more general names that differ from those used by D&B.
Online purchasing: The Mapping API utility maps and loads the D&B data elements from the HZ_PARTY_INTERFACE table into the TCA Registry. See: Mapping API Utility.
Batch loading: The D&B Import Adapter request set maps and loads the D&B data elements to the appropriate import interface table columns. The mapped data is then ready for import into the Registry. See: D&B Import Adapter.
If the party is the headquarters, the HQ D-U-N-S Number is the same as the D-U-N-S Number for the party. This case also applies to related parties. If the D-U-N-S Number of the related party is the same as the party D-U-N-S Number, two possible scenarios arise:
If the party is a Domestic Ultimate, Global Ultimate, or Headquarters, a relationship is created between the party and its related party. Both of the companies in the relationship will be the same, to convey that the party itself is of type Domestic Ultimate, Global Ultimate, or Headquarters.
If the related party does not have a parent, D&B does not provide parent information.
Outside of North America, D&B does not store information at the branch level. If you request information for a company that is a branch location outside of North America, D&B provides data for its headquarters. The D-U-N-S Number for the branch's headquarters is used to select the D&B data for the headquarters. The D-U-N-S Number for the branch is displayed as the Enquiry D-U-N-S Number. If a headquarters record does not exist in the TCA Registry, Third Party Data Integration automatically creates one.