Understanding Matched Attributes

Overview

The Matched Attributes (MAs) field available in your enrichment report identifies exactly which data points on an incoming record matched a candidate in our database. This level of transparency allows you to understand why a specific record was linked to a supplier profile. 

 

List of Matched Attributes

The following tables define the possible values you may see in the matched_attributes field, along with their descriptions.

There are 3 main categories of MAs:

1. Names

2. Identifiers

3. Location 

 

Names

These attributes indicate a match based on the supplier name provided in the Vendor Master file under the company_name field (see the entire schema here).

Name MAs Prioritization

To keep your data clean, the system prioritizes exact legal and trading name matches above all other name variations. The hierarchy follows this logic:

Legal/trading Name > All other name attributes

If a match is found on the legal_name or trading_name, the system will not display lower-confidence attributes (such as "starts with" or "no spaces").

Handling Multiple Names

The table below references one company name from the file and one name from the Tealbook Legal Entities database.  However, there can be multiple names in each, and the matching process is performed for each available name pair. At least one of the pairs should match for the MA to be present. 

Value	Description
legal_name	company_name exactly matches the candidate’s legal name.
trading_name	company_name exactly matches the candidate’s trading name.
legal_name_no_le_suffix	company_name exactly matches the candidate's legal name after removing the Legal Entity suffix (e.g., "Inc." or "Ltd.").
trading_name_no_le_suffix	company_name exactly matches the candidate's trading name after removing the Legal Entity suffix (e.g., "Inc." or "Ltd."), if there is any (trading names mostly don't have these suffixes).
legal_name_conflicting_le_suffix	company_name exactly matches the candidate's legal name after removing different LE suffixes from both records (e.g., matching "Acme Inc" with "Acme LLC").
trading_name_conflicting_le_suffix	company_name exactly matches the candidate's trading name after removing different LE suffixes from both records (e.g., matching "Acme Inc" with "Acme LLC").
legal_name_starts_with	One of the names (company_name or legal name) starts with the other (e.g., matching "Acme labs Inc" with "Acme").
trading_name_starts_with	One of the names (company_name or trading name) starts with the other (e.g., matching "Acme labs Inc" with "Acme").
legal_name_no_spaces	company_name matches the legal name only after removing all whitespaces from both records.
trading_name_no_spaces	company_name matches the trading name only after removing all whitespaces from both records.
legal_name_stop_words_removed	company_name matches the legal name only after removing non-ASCII characters and "stop words" (common words like a, the, and).
trading_name_stop_words_removed	company_name matches the trading name only after removing non-ASCII characters and "stop words" (common words like a, the, and).
legal_name_single_char_displaced	company_name matches the legal name only after correcting a single character displacement (e.g., "Acme Service" matches "Acme Services")
trading_name_single_char_displaced	company_name matches the trading name only after correcting a single character displacement (typo).
legal_name_name_order	company_name matches the legal name only after sorting the words alphabetically (e.g., "Services Acme" matches "Acme Services").
trading_name_name_order	company_name matches the trading name only after sorting the words alphabetically (e.g., "Services Acme" matches "Acme Services").

 

Identifiers

These MAs indicate a match based on unique identifiers or government-issued tax numbers. The field at the beginning of each description represents the value from the file, while the field specified after represents the value of the Legal Entity candidate.

Value	Description
tealbook_supplier_id	tealbook_supplier_id exactly matches the supplier ID assigned to the candidate by Tealbook.
lei	lei exactly matches the Legal Entity Identifier (LEI) of the candidate (if available).
sam_id	sam_uei exactly matches the System for Award Management (SAM) ID of the candidate (if available).
duns_id	duns_number exactly matches the Dun & Bradstreet (DUNS) ID of the candidate (if available).
certifying_body_id	Matches both the Certifying Body name and the specific Certifying Body ID.
tax_id	tax_id exactly matches the candidate's Tax or Business IDs. Special logic applies for US tax IDs (stripping first/last digits for match validation).
business_id	business_id exactly matches the existing Tax or Business IDs.
company_number	legal_entity_company_number matches the candidate's company Number.
native_company_number	legal_entity_company_number matches the candidate's native company number (the original company number, in case it has changed).
tax_id_prefix_country	tax_id matches the candidate's Tax or Business IDs after removing country code prefixes from tax_id. The system validates that the prefix is a valid country code and matches the candidate's country (based on its jurisdiction code).
business_id_prefix_country	business_id matches the candidate's Tax or Business IDs after removing country code prefixes from business_id. The system validates that the prefix is a valid country code and matches the candidate's country (based on its jurisdiction code).
tax_to_company_number	tax_id exactly matches the candidate's company number or native company number.
business_id_company_number	business_id exactly matches the candidate's company number or native company number.
tax_id_to_ca_bn	tax_id matches the first 9 digits of a Canadian Business Number (the candidate has to be Canadian).
partial_tax_to_company_number	tax_id matches the candidate's company number or native company number after removing a prefix, as per the country-specific rules below: FR/AU: First 2 characters are FR or AU (case insensitive) followed by 11 numbers. These are removed along with the 2 characters that follows. JP: First character is T (case insensitive) followed by 13 numbers. The JP prefix is removed. Candidate's country has to be the same as in the prefix.
partial_business_to_company_number	business matches the candidate's company number or native company number after removing a prefix, as per the country-specific rules below: FR/AU: First 2 characters are FR or AU (case insensitive) followed by 11 numbers. These are removed along with the 2 characters that follows. JP: First character is T (case insensitive) followed by 13 numbers. The JP prefix is removed. Candidate's country has to be the same as in the prefix.

Note: Attributes ending in _parent (e.g., tax_id_parent) indicate the match occurred on the Parent Entity of the candidate record.

 

Location

These attributes indicate a match based on physical address data. The system compares to both the candidate's Registered (legal) addresses and Non-Registered (operating) addresses.

Handling Multiple Addresses

A supplier in the Vendor Master file may have multiple addresses separated by pipes (|) under complete_address. A Legal Entity candidate may also have multiple addresses. The below MAs compare each of the address pairs. At least one of the pairs have to match in order for the relevant MA to be present.

Value	Description
registered_addressline	The address line part of complete_address matches the candidate's registered address line.
non_registered_addressline	The address line part of complete_address matches the candidate's non-registered address line.
registered_city	The city part of complete_address matches the candidate's registered city.
non_registered_city	The city part of complete_address matches the candidate's non-registered city.
registered_state	The state part of complete_address matches the candidate's registered state.
non_registered_state	The state part of complete_address matches the candidate's non-registered state.
registered_country	The country part of complete_address matches the candidate's registered country.
non_registered_country	The country part of complete_address matches the candidate's non-registered country.
registered_zip_postal_code	The zip or postal code part of complete_address matches the candidate's registered zip or postal code.
non_registered_zip_postal_code	The zip or postal code part of complete_address matches the candidate's non-registered zip or postal code.
jurisdiction_code	legal_entity_jurisdiction_code exactly matches the candidate's jurisdiction code.
jurisdiction_country_code	The country part of complete_address matches the candidate's country from its jurisdiction code.
jurisdiction_state_code	The state part of complete_address matches the candidate's state from its jurisdiction code.