Canonical reference for every field on the Supplier entity in Marquis IQ. These fields appear across Enrich, Explore, Analyze, and Excel exports. See also: Customer.
Fields that represent the Marquis-level supplier structure sitting above individual ERP records.
The unified name assigned to this Master Supplier record. When matched to Dun & Bradstreet, defaults to the D&B primary name. When unmatched, uses a cleansed version of the ERP supplier name. Users who create a Master Supplier manually can enter any name they choose.
The top-level corporate family grouping for this Master Supplier. Defaults to the Global Family Name provided by D&B enrichment. Users can change it at any time in the Maintain workflow to reflect their own grouping preferences. Spend, PPV, and procurement analytics roll up to Family Name across all IQ modules.
The worldwide ultimate parent company name as identified by Dun & Bradstreet. This is the original default value for Family Name. If a user has updated Family Name in Maintain, those two fields may differ.
The official primary business name returned by the Marquis IQ enrichment process for this supplier record. For D&B-matched records, this is the name as registered with D&B. Useful for comparing against the raw ERP supplier name to understand how much the ERP record differs from the official registered business name.
Fields pulled directly from the client's source ERP system, unchanged from how they are stored there.
The primary supplier field as loaded from the source ERP system. This is the main ERP-sourced identifier shown by default in the grid. Shown alongside Master Supplier Name so you can compare the ERP value against the unified Marquis record.
An alternate supplier name field from the ERP record. Available when you need to compare both ERP name fields against the Master Supplier Name or enrichment data.
The unique identifier assigned to this supplier record in the source ERP system. Format varies by ERP platform.
The internal company name used within the client's own organization. A company operating two separate business units would have two distinct organization names. This reflects how the client refers to its own legal entities internally, not the external supplier-facing name.
The ERP platform from which this supplier record was loaded. Useful when working cross-ERP portfolios where the same supplier may appear as separate records across multiple systems.
The federal tax identification number (EIN) for this supplier, as recorded in the ERP system. When present and accurate, this is one of the strongest signals used during the matching process.
The payment terms assigned to this supplier in the ERP system (for example, Net 30, Net 60, 2/10 Net 30). Sourced directly from the ERP vendor record.
The UNSPSC (United Nations Standard Products and Services Code) category description provided by Dun & Bradstreet enrichment. Shown by default as the primary industry classification label for this supplier. For the underlying numeric code, see Primary UNSPSC Code (MIQ).
Supplier records carry two address types: Billing Address (the invoicing/remittance address from the ERP) and Physical Address (the actual operating location, used for Site-level enrichment matching).
The billing or remittance address for this supplier as stored in the ERP system. This is the address used for invoice processing and payments, which may differ from the supplier's physical operating location.
The full physical operating location address for this supplier, combining city, state, and postal code into a single field. The Physical Address is used by the Marquis matching algorithm when grouping ERP records at the same Site (Enrichment Number). Use the individual Physical City, State, Country, and Postal Code columns when you need to filter or sort on a specific component.
The city component of the physical operating address.
The state or province code component of the physical address (for example, WA, CA, ON).
The country name of the physical operating address, as stored in the ERP system.
The two-letter ISO 3166-1 country code for the physical address country (for example, US, CA, DE).
The postal or ZIP code of the physical address.
Fields that describe how each ERP record was linked to its Master Supplier and how confident the system is in that link.
Indicates that a user manually assigned this ERP supplier record to a Master Supplier, rather than accepting the system's automatic match. A blue dot appears on the row for any manually assigned record. Records matched automatically by the system do not show this indicator.
Note: Manual assignment takes priority and is preserved across enrichment refreshes. It will not be overwritten by subsequent auto-matching runs.
The blended, final confidence score (0-100) that Marquis IQ assigns to the match between this ERP supplier record and its Master Supplier. Combines signals from the Marquis internal algorithm and Dun & Bradstreet data. Scores above 70 indicate a high-confidence match. Lower scores warrant review before relying on the assignment.
Note: Sort ascending to surface low-confidence assignments first when prioritizing manual review work.
The internal code used by the Marquis IQ matching algorithm to score this record using non-third-party data signals (for example, Taxpayer ID, address structure, name similarity). One input to the overall Match Confidence score.
The match quality grade returned by Dun & Bradstreet, reflecting how well individual elements of the ERP record (name, address, etc.) matched the D&B database entry. Provided as-is from D&B. Refer to D&B documentation for grade definitions.
The numeric score returned by Dun & Bradstreet indicating how closely the ERP supplier name matched the D&B recommended name for this record. A low Name Match Score on a high-confidence record often means the ERP name is abbreviated or formatted differently, not that the match is wrong.
Describes how precisely the ERP physical address matched the D&B address during enrichment (for example, exact street-level match, city-level match, postal code match). A weaker address match type does not necessarily mean the overall record match is wrong - name and Tax ID signals may have provided sufficient confidence.
The date this supplier ERP record was first loaded into Marquis IQ. Useful for identifying recently imported records that may not yet have been through the mastering workflow.
The date this ERP supplier record was assigned (or auto-matched) to a Master Supplier record. Combined with Added Date, this lets you see how long a record sat unmatched before assignment.
All fields in this section are provided by Marquis IQ - either from Dun & Bradstreet data or from the Marquis matching algorithm. None of these values come from the client's ERP systems.
Marquis IQ's internal identifier (format: EN-XXXXX) for the Site level of the supplier hierarchy. ERP records that share the same physical address are grouped under the same Enrichment Number, even when address formatting differs across records or ERP systems.
Note: See the Enrich Overview for a full explanation of the Family - Master - Site hierarchy.
The status assigned by the Marquis IQ matching algorithm indicating whether enrichment was successful for this record. Records with a non-enriched status may have limited data in the other MIQ columns.
The real-world operating condition of this business as reported by Dun & Bradstreet (for example, Active, Out of Business). Shown by default because supplier viability directly affects sourcing risk. Marquis IQ displays this value as-is from D&B.
Note: An "Out of Business" status here may not be reflected in your ERP if the vendor record has not been deactivated. This field helps surface that gap.
The company website address, provided by Dun & Bradstreet enrichment data. May be blank for suppliers that did not return a D&B match or where D&B does not have a website on record.
The 6-digit NAICS (North American Industry Classification System) code for this supplier's primary industry, provided by Marquis IQ enrichment. Useful for supplier segmentation and sourcing analytics by industry type.
The plain-English industry description corresponding to the Primary NAICS Code (for example, "Industrial Fastener Manufacturing" or "Electronic Component Wholesalers").
The 4-digit SIC (Standard Industrial Classification) code for this supplier's primary industry, provided by Marquis IQ enrichment.
The plain-English industry description corresponding to the Primary SIC Code.
The UNSPSC classification code for this supplier's industry, assigned by Marquis IQ enrichment from D&B data. Distinct from the ERP-sourced UNSPSC Description field, which reflects what your organization has coded on the vendor record in your ERP.
Invoiced amounts used for prioritization and filtering when working the assignment queue. Not financially validated - use IQ modules for reconciled spend analytics.
Total invoiced amount for this ERP supplier record over the last twelve months, through yesterday. Shown by default - sort descending to work highest-spend unassigned records first and ensure your most active suppliers are correctly mastered.
Important: LTM Invoiced is not a financially validated number and should not be used for reporting. It is intended for prioritization and filtering only.
Total invoiced amount for this ERP supplier record over the last five years. Helps identify suppliers with longer-standing relationships that may have low recent activity but represent significant historical spend. Not a financially validated figure.
Total all-time invoiced amount for this ERP supplier record across all available transaction history. Useful for identifying dormant but historically significant suppliers. Not a financially validated figure.
Missing a column or need clarification? Let us know.