---
title: "Supplier Profiles Table"
canonical: "https://help.agiloft.com/space/SD/44433957/Supplier+Profiles+Table"
format: markdown
---
The Supplier Profiles table stores registration forms for suppliers. Supplier managers review and approve the profiles before a new Company record is created for the supplier. Once the profile is approved, the supplier gets access to the full [Supplier Portal](https://agiloft-public.atlassian.net/wiki/spaces/SD/pages/44434184).

# Creating Records

There are four ways to create Supplier Profile records:

- Supplier self-registration: Suppliers register through a link on a public website. After creating an external user account, they receive an email with a link to complete their profile. Basic information is prepopulated, such as the company name and primary contact.
- New Supplier from a Contract: When Supplier Management is enabled, creating a new Company from a Contract can also create a Supplier Profile if the company's primary role is Supplier. The supplier's primary contact receives an email to complete the profile. If a Contract reaches Pending Signature before the Supplier Profile is approved, the system displays a warning, which can be configured as a required validation.
- New Supplier from a Sourcing Event: When a new company is invited to a Sourcing Event, a Company record is created with a Pending status. If the invited representative responds “I'm interested,” a profile is created for the supplier to complete.
- Update supplier information: After a Supplier Profile is approved, suppliers can no longer edit the record except to add users and locations. To update company information, the supplier can click Clone and Request Changes to create a copy, make the necessary updates, and submit it for review. Once approved, the new profile replaces the previous one.

## Supplier Screening and Approval

In the out-of-the-box system, the Supplier Manager is notified when a supplier submits a profile. The manager checks for duplicate Company records and can reject a duplicate profile with a reason that is sent to the supplier.

For valid profiles, the manager can request more information, send surveys, and launch approvals as needed. Survey emails include a guest login link, allowing the Supplier Lead to forward the survey to others in their organization.

After approval, the Company record is set to Active, and the related Supplier, Location, and Person records are updated. The supplier’s primary user is added to the Supplier Lead and Supplier groups, granting access to the supplier portal.

Supplier Leads cannot edit an approved profile directly. To request changes, they click Clone and Request Changes to create a copy of the approved profile. Once approved, the updated profile replaces the previous version.

# Views

The Default View for the out-of-the-box Supplier Profiles table shows the Edit icon, ID, Type of Request, Company, Company Type, Industry, Primary Contact, Assigned Supplier Manager, Source, and Status fields.

![Default View for the Supplier Profiles table](media://a6e8404f-9740-4be4-930f-42c23bfc76cf)

In addition to Default View and other [standard views](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43718574), the Supplier Profiles table includes an EUI Supplier View, which is the default view in the End User Interface. The view includes the Clone and Request Changes button so suppliers can easily clone records for editing.

# Saved Searches

The out-of-the-box Supplier Profiles table includes the following saved search in the table menu:

- **Approved Supplier Profiles**: Finds all of the Supplier Profile records where the Status is Approved.

# Charts/Reports

In the out-of-the-box system, the Supplier Profiles table includes the following charts and reports:

- **In Progress Supplier Profiles by Assigned Supplier Manager**: Chart that shows the number of profiles that each assigned Supplier Manager has in progress.
- **Supplier Profiles by Status**: Chart that shows the number of supplier profiles in each workflow state.

# Related Tables

The diagram below shows the default incoming table relationships and linked fields in the Supplier Profiles table.

![Default table relationships for the Supplier Profiles table](media://130318fe-87f9-48fa-ab28-bef3d766d489)

# Fields

In addition to the [standard fields](https://agiloft-public.atlassian.net/wiki/spaces/SD/pages/44434023/Table+Concepts#standard_fields), the out-of-the-box Supplier Profiles table includes the following fields.

| **Field Label** | **Data Type** | **Description** |
| --- | --- | --- |
| Add Additional Address | Choice: True, False | If Show Linked Records is None, this field controls whether to show the additional address fields. |
| Add Note to Supplier | Text | Notes to the supplier. |
| Add Response | Text | Response to the supplier. |
| Add Stakeholder | Choice: True, False | Checkbox that controls whether the fields for adding a stakeholder are shown or hidden. |
| Additional Notes | Text | Additional notes to add to the profile. |
| Address 1 City | Short Text | The city for address 1. |
| Address 1 Country  
Address 1 Country ID  
Address 1 Country State Type | Link to selected fields from other table: Countries | The country for address 1. |
| Address 1 Location Name | Short Text | Defines the name of the location for address 1 and is used in the conversion to a Location record. |
| Address 1 Location Type | Multi-Choice:<br>Headquarters. Billing, Branch, Campus, Physical, PO Box, Shipping, Subsidiary, Other | The type of location for address 1. |
| Address 1 State ID  
Address 1 State  
Address 1 State Abbreviation | Link to selected fields from other table: States | The state for address 1. |
| Address 1 State or Province | Short Text | The state for address 1. |
| Address 1 Street Address 1 | Short Text | The street address for address 1. |
| Address 1 Street Address 2 | Short Text | Additional street address details for address 1. |
| Address 1 Zip or Postal Code | Short Text | The zip code for address 1. |
| Address 2 City | Short Text | The city for address 2. |
| Address 2 Country  
Address 2 Country ID  
Address 2 Country State Type | Link to selected fields from other table: Countries | The country for address 2. |
| Address 2 Location Name | Short Text | Defines the name of the location for address 2 and is used in the conversion to a Location record. |
| Address 2 Location Type | Multi-Choice:<br>Headquarters. Billing, Branch, Campus, Physical, PO Box, Shipping, Subsidiary, Other | The type of location for address 2. |
| Address 2 State ID  
Address 2 State  
Address 2 State Abbreviation | Link to selected fields from other table: States | The state for address 2. |
| Address 2 State or Province | Short Text | The state for address 2. |
| Address 2 Street Address 1 | Short Text | The street address for address 2. |
| Address 2 Street Address 2 | Short Text | Additional street address details for address 2. |
| Address 2 Zip or Postal Code | Short Text | The zip code for address 2. |
| Annual Revenue | Currency | The amount of annual revenue for the supplier. |
| Approval Notes | Append Only Text | Lists the comments from Approval records related to the profile. |
| Approval Progress Bar | Heat Bar | When the Status is Pending Approval, this progress bar shows the status of the approval workflow. |
| Approvals Launched | Choice: Yes, No | Flag that indicates whether approvals have been launched. Controls visibility of the Launch Approvals button. |
| Approvals Needed | Related Table: Approvals | Lists the approvals that need to be completed. |
| Approved | Calculation on Multiple Linked Records: Approvals | Lists the number of approvals that are Approved. |
| Assigned Supplier Manager  
Supplier Manager ID | Link to selected fields from other table: People | The person assigned as the Supplier Manager. |
| Attachment Type to Upload  
Attachment Type ID | Link to selected fields from other table: Attachment Types | Lists the type of attachment to upload. |
| Button: Add File | Action button | Adds the documents in Files to Upload to the Company Documents table. |
| Button: Add Main Contact | Action button | Adds fields for supplying another main contact. |
| Button: Add Related Company | Action button | Adds fields for supplying another company. |
| Button: Add Stakeholder | Action button | Adds the stakeholder as a new record in the Supplier Stakeholders table. |
| Button: Create Approvals | Action button | Creates Approval records for the selected Approval Workflow. |
| Button: Create Company | Action button | Creates a Company record for the specified company. |
| Button: Generate Surveys | Action button | Generates surveys from the selected survey types. |
| Button: Launch Approvals | Action button | Launches the approval process. |
| Button: Recheck Conditional Approvals | Action button | Evaluates the conditions in the Approval Templates in the selected workflow. |
| Button: Reject | Action button | Rejects the profile. |
| Button: Save Draft | Action button | If Status is Draft, this button saves the current state of the record so the supplier can come back to it. |
| Button: Send Email | Action button | Sends the drafted email. |
| Button: Submit | Action button | If Status is Draft, this button can be used to submit the profile. It sets the status to Pending Review. |
| Certified Diverse Business Categories | Multi-Choice:<br>Small Business (SBE), Small Disadvantaged Business (SDB), Minority Owned (MBE), Women Owned Enterprise (WBE), LGBTQ-Owned, Veteran Owned or Service-Disabled Veteran-Owned, B(a) Small Business, HUBZone Business | The business categories for which the supplier is certified. |
| Click here to complete supplier profile | Text | Used as a hyperlink to open the record for editing from within a Supplier Response. |
| Clone and Request Changes | Action button | If Status is Approved, this button can be used to create a copy of the record for editing. |
| Company | Text | Lists the company name for the table view. Do not add this field to the record layout. |
| Company Lookup | Link to selected fields from other table: Companies | If Show Linked Records is No, you can use this lookup to search for an existing Company record before creating a new one. |
| Company Name  
Company Goods and Services IDs  
Company ID  
Company Status | Link to selected fields from other table: Companies | Lists details about the company. |
| Company Type | Choice:<br>Parent, Holding, Affiliate, Subsidiary, Legal Entity, DBA | The type of company. |
| D&B Number | Short Text | The unique identifier for the company. |
| Date of Establishment | Date | The date the supplier’s business was established. |
| Describe the relationship | Text | If the supplier is a related party, this field describes the relationship. |
| Email | EMail | The supplier’s email address. |
| Email Template Available for Recipients  
Email Subject  
Email Text  
Email Text ID  
Addresses to CC  
Email Template | Link to selected fields from other table: Email Texts | Lists the email templates available for use. |
| External Contact(s) to Email | Link to single field from other table: People | Lists the supplier contacts to send email to. |
| File(s) to Upload | File with Versioning | Files to upload to Company Documents and link to the profile. |
| Files to Send with Email | Link to single field from other table: Company Documents | Files to attached to the email. |
| Filter Email Templates | Choice:<br>No Filter, External Party Only, Internal Contacts Only, Both External and Internal Contacts | Defines whether to filter the list of available email templates. Default is No Filter. |
| First Name | Short Text | The supplier’s first name. |
| Generate Survey Types | Link to single field from other table: Survey Types | The types of surveys to generate. |
| Goods and Services,  
Goods and Services IDs | Link to selected fields from other table: Goods and Services | Lists the goods and services the supplier provides. |
| Industry | Choice:<br>To view the choices, go to **Setup Supplier Profiles** and click the Fields tab. Edit the Industry field, and click Edit Choice List on the General tab. | The industry the supplier works in. |
| Internal Contact(s) to Email | Link to single field from other table: People | Lists the internal contacts to send email to. |
| Internal Notes | Append Only Text | Notes about the supplier or profile. |
| Is the supplier a related party? | Choice: Yes, No | Indicates whether the supplier has a relationship with the buyer. |
| Last Name | Short Text | The supplier’s last name. |
| Not Needed | Calculation on Multiple Linked Records: Approvals | Approval record status that indicates the approval is not needed. |
| Number of Approvals Completed | Calculation on Multiple Linked Records: Approvals | The number of Approvals that are Approved. |
| Number of Approvals Needed | Calculation on Multiple Linked Records: Approvals | The number of Approvals that need to be completed. |
| Number of Employees | Integer | The number of employees at the supplier company. |
| Number of Supplier Related Companies | Calculation on Multiple Linked Records: Supplier Related Companies | Counts the number of companies linked to this company. |
| Number of Supplier Stakeholders | Calculation on Multiple Linked Records: Supplier Stakeholders | Counts the number of stakeholders linked to this supplier. |
| Pending Approval | Calculation on Multiple Linked Records: Approvals | The number of Approvals that are Pending. |
| Permanently Rejected | Calculation on Multiple Linked Records: Approvals | The number of Approvals that are Permanently Rejected. |
| Phone | Telephone/Fax | Phone number for the supplier. |
| Primary Contact Email  
Primary Contact  
Primary Contact ID | Link to selected fields from other table: People | Identifies the primary contact for the supplier. |
| Primary Region | Choice:<br>Western US, Central US, Eastern US, Canada, Central America, South America, Europe, Asia, Australasia, Africa, Other | The primary region the supplier is in. |
| Primary Role for Conversion | Choice:<br>Customer, Internal, Partner, Supplier, Other | The role of the company. |
| Public Company | Choice: Yes, No | Indicates whether the company is public. |
| Queued | Calculation on Multiple Linked Records: Approvals | The number of approvals with a Queued status. |
| Reason for Rejection | Text | If the profile is rejected, this field lists the reason. |
| Related Company Name | Text | The name of the related company. |
| Requires Change | Calculation on Multiple Linked Records: Approvals | The number of approvals that require changes. |
| Requires Reapproval | Calculation on Multiple Linked Records: Approvals | Indicates whether an approval needs to go through the approval process again. |
| Running Notes to/from Supplier | Append Only Text | Running notes from the supplier. |
| Show Create Approvals Button | Choice: Yes, No | Controls whether to show the Create Approvals button. |
| Show Linked Records | Choice: None, All, Company Only | Indicates which linked records are available.<br>- When set to None, no company or location records have been created for the supplier, so fields related to creating a new company and location are displayed. For example, if a supplier self-registered and created a new profile, Show Linked Records is set to None.
- When All, company and location records exist, so linked fields to company and location are displayed. If a profile is created from a contract or a profile is Approved, Show Linked Records is set to All.
- When Company, a Company record is linked to the profile but a location record doesn’t exist. If a profile was created because of a Sourcing Event invitation, but the profile isn’t approved yet, Show Linked Records is set to Company. Fields related to creating a new location are displayed. |
| Source | Choice:<br>Contract, Supplier Response, Self-Registration, Company, Clone | The source of the profile. |
| Source Contract ID | Link to selected fields from other table: Contracts | If the profile source is Contract, this field lists the ID of the linked contract. |
| Source Supplier Profile ID | Link to selected fields from other table: Supplier Profiles | If the profile source is Clone, this field lists the ID of the profile that was cloned. |
| Source Supplier Response ID | Link to selected fields from other table: Supplier Responses | If the profile source is Supplier Response, this field lists the ID of the linked response. |
| Status | Choice:<br>Draft, Pending Review, Pending Supplier, Rejected, Pending Approval, Approved, Modification In Progress, Superseded | The current state of the profile from the [workflow](#workflow). |
| Summary of changes | Text | If this is an update to an existing profile, this field summarizes the changes. |
| Supplier Contacts | Embedded Search Result | Lists any people related to the supplier. |
| Supplier Documents | Related Table: Company Documents | Lists any company documents that have been uploaded. |
| Supplier Locations | Embedded Search Result | Lists all locations for the supplier. |
| Supplier Related Companies | Embedded Search Result | Lists other companies related to the supplier. |
| Supplier Related Companies from Latest Supplier Profile | Related Table: Supplier Related Companies | List of related companies from the Supplier Related Companies table. |
| Supplier Stakeholders | Embedded Search Result | Lists any supplier stakeholders. |
| Supplier Stakeholders from Latest Supplier Profile | Related Table: Supplier Stakeholders | List of supplier stakeholders from the Supplier Stakeholders table. |
| Supplier Surveys | Related Table: Surveys | Lists any surveys related to this profile. |
| Tax ID | Short Text | The company’s tax ID. |
| Telephone | Telephone/Fax | The supplier’s telephone number. |
| Times Sent for Approval | Integer | Shows the number of times the profile was sent for approval. |
| Title | Short Text | The name of the profile. |
| Type of Relationship | Choice:<br>Parent, Subsidiary, Partner, Other | Identifies the relationship between the supplier and the related company. |
| Type of Request | Choice: Modification, New | Default to New. Set to Modification when cloned |
| Type of Request for Conversion | Choice: Modification, New | Used during conversion to indicate whether the profile is for a new supplier or a modification to an existing supplier. |
| Type of Stakeholder | Choice:<br>Board Member, Director, Executive, Owner, Senior Manager, Other | Identifies the stakeholder’s role or relationship to the supplier. |
| Unsubmitted Profile Reminder Sent | Choice: Yes, No | Flag that indicates whether the vendor has been sent a reminder to submit their profile. |
| Website URL | URL | The URL for the supplier’s website. |
| Workflow ID  
Workflow Title | Link to selected fields from other table: Approval Workflows | Lists the Approval Workflow to use for the profile. |
| Your Company Name | Text | Lists the company name. |

# Automation

This section describes the rules that are implemented for the out-of-the-box Supplier Profiles table. For details about rule configuration options, see [Rules](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714473) in the CLM Help.

- **Edit: All Edit Actions by web or API**: This rule runs when a Supplier Profile is edited and performs the following actions:
  - If the supplier submitted the profile for review, it notifies the Supplier Management Team.
  - If the profile was rejected, it notifies the Primary Contact. The email contains the reason for the rejection.
  - If a note to the supplier was added, it copies the text to Running Notes and notifies the Primary Contact. If the Status was Pending Review, it’s changed to Pending Supplier.
  - If a supplier response was added, it copies the text to Running Notes and notifies the Assigned Supplier Manager. If the Status was Pending Supplier, it’s changed to Pending Review.
  - If all Approvals were completed, it sets the Status to Approved.
- **Create: All Create Actions (web, API)**: This rule runs when a Supplier Profile is created and performs the following actions:
  - It sets the fields based on the source the record was created from:
    - If it was created via a Contract: the rule creates a link to the source Contract, sets Source field to Contract and shows all linked records.
    - If it was created when a supplier clicks “I’m interested” in a Supplier Response to a Sourcing Event: the rule creates a link to the source Supplier Response, sets Source field to Supplier Response, shows company-related linked records.
    - If it was created by cloning an existing Supplier Profile: the rule updates links from Supplier Related Companies and Supplier Stakeholders to lead to the newest Supplier Profile, sets Source field to Clone, sets Status of the source Supplier Profile to Modification in Progress.
  - If the source is Contract or Self-Registration, the rule sends the Primary Contact an email with a link which they can click to finish registering their Supplier Profile.
  - Another notification is sent to the Supplier Manager Team if during Supplier Profile creation Primary Contact Email remains empty. This situation should never happen, but is built in as a safety precaution.
- **Edit: Supplier Approval Actions (web, API)**: This rule runs when profiles are edited. For records where the status changed to Approved, the actions:
    - Create or update the Company record and set the status to Active.
    - Update the Company Name in the Primary Contact user record if needed.
    - Add the Primary Contact to the Supplier Lead group.
    - Notify the Primary Contact about the approval.
    - If the profile is a modification, set the status of the original profile to Superseded.
    - Add the company location information to Location records.
- **TB: (DISABLED) Remind Supplier Primary Contact to Submit Profile**: This time-based rule is disabled by default. It checks for profiles in Draft status that were last updated 5 or more days ago and sends a reminder email to the supplier's Primary Contact.

# > Macro (anchor)

Workflow

The Supplier Profile workflow is linear, and records are created in Draft status. Status changes are performed with action buttons and automatic changes when certain conditions are reached. Workflow status transitions do not execute any actions. 

![Workflow for Supplier Profiles table](media://f9ca9f30-a4d7-43e0-a525-213177935946)

# Ownership

Supplier Profile records are owned by the person who is listed as the company’s Primary Contact. The field by which the ownership is determined is user Email.