Comparisons

Supplier and vendor

Each active supplier that has an active vendor number is compared. If multiple suppliers are tied to the same vendor number, then conflicts will occur in the compare process.

  • Name
  • Tax ID
  • Global Location Number
  • Doing Business As (compared to vendor search name)

These billing address fields are compared to the current address for the vendor. If no billing address fields are specified, then mailing address is compared:

  • First, Second, Third, and Fourth address lines
  • City
  • State/Province
  • Postal Code
  • County
  • Country

The supplier primary contact is compared to vendor contact information:

  • First Name/Last Name is compared to Contact Name
  • Phone Prefix/Number/Extension
  • Fax Prefix/Number/Extension
  • Email Address

Supplier contacts and vendor locations

Each supplier contact that has a vendor location is compared. If multiple supplier contacts are tied to the same vendor location, conflicts will occur in the compare process. If the primary contact for a supplier is tied to a vendor location, then the contact information on the supplier side is compared to vendor contact. This can lead to record conflicts.

  • Location Name
  • First Name/Last name is compared to Contact Name

These address fields are compared to the current address for the vendor location:

  • First, Second, Third, and Fourth address lines
  • City
  • State/Province
  • Postal Code
  • County
  • Country
  • Phone Prefix/Number/Extension
  • Fax Prefix/Number/Extension
  • Email Address

Supplier diversity codes

Comparison records are created if these circumstances apply:

  • The diversity code is active and there is a vendor diversity code, but there is no equivalent supplier diversity code.

    One record is created regardless of whether there were multiple vendor records for the diversity code (multiple decertification dates). The record that is created uses the newest decertification date as the diversity code on the Vendor.

  • There is a supplier diversity code, but no equivalent vendor diversity code.
  • The same diversity code exists on both. In this case, the supplier diversity code (there can only be one record) is compared to the newest vendor diversity code by decertification date. Certification date, Decertification Date, and Review Date are compared. For each date that does not match, a record is created.

Certification codes

Comparison records are created if these circumstances apply:

  • The certification code is active and a vendor certification exists, but no equivalent supplier certification exists
  • a supplier certification exists, but no equivalent vendor certification exists
  • the same certification exists on both sides, but the Expiration Dates are different