Supplier Upload Template

The following table describes the supplier record bulk upload file input requirements.

You can download the template file by clicking here. You can also download the file directly from the VMS.

Field Format Required? Description/Notes
Supplier Name
  • Maximum 150 characters
  • Characters, numbers, symbols acceptable
 Yes
Legal Name
  • Maximum 150 characters
  • Characters, numbers, symbols acceptable
 Yes
Country Registration
  • Only values in VMS standard country list
  • Value is not case sensitive
 Yes
Tax ID
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 Yes
Agreement Types
  • List must be separated by semi-colon (;)
  • Values in VMS agreement type list
  • Value is not case sensitive
 Yes

At least one value from the list is required.

 Acceptable values are:
  • payroll
  • staffing
  • project
  • IC / bizval
  • managed services
Custom Fields Check the client organization's supplier custom field configuration (Configuration > Settings > Custom Fields > Supplier.
Contact Information - Address Line 1
  • Maximum 150 characters
  • Characters, numbers, symbols acceptable
 Yes
Contact Information - Address Line 2
  • Maximum 150 characters
  • Characters, numbers, symbols acceptable
 No
Contact Information - Country
  • Only values in VMS standard country list
  • Value is not case sensitive
 Yes
Contact Information - State/Province
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 Yes
Contact Information - City
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 Yes
Contact Information - Postal Code
  • Maximum 15 characters
  • Characters, numbers, symbols acceptable
 Yes
Contact Information - Phone
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 No
Contact Information - URL
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 No
Preferred Language
  • Value is case sensitive
  • Spaces are acceptable
 No Acceptable values are:
  • US English
  • UK English
  • Dutch
  • German
  • German (Swiss)
  • Italian
  • Korean
  • French
  • French (Canadian)
  • Portuguese (Brazil)
  • Spanish
  • Swedish
  • Chinese
  • Chinese (Traditional)
  • Thai

If this value is empty this value defaults to US English.
Primary Contact - First Name
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 Yes
Primary Contact - Last Name
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 Yes
Primary Contact - Email
  • Maximum 50 characters
  • Characters, numbers, symbols acceptable
 Yes Format must be <value>@<value>.<value>, for example, [email protected]

Value must be unique in the system (must not already exist for another user name).
Primary Contact - Phone
  • Maximum 15 characters
  • Characters, numbers, symbols acceptable
 Yes