Vendor Import Template Data
General Information
-
Do not change the column headers in Row 1 as this is used to complete the upload.
Data Columns
The table below lists the columns and which columns are required or optional.
| Column Name | Column Required | Max Length | Notes |
|---|---|---|---|
| Vendor ID |
Yes | 100 | Unique identifier for a vendor. If the vendor doesn't exist in the sytem then the new vendor will be uploaded. |
| Vendor Name | Yes | 50 | Full name of the vendor. |
| Preferred Name | 50 | ||
| Vendor Type | 100 | ||
| Email Address | 100 | ||
| URL | 60 | ||
| Used in Work Orders | |||
| Phone | |||
| Address Line 1 | 50 | ||
| Address Line 2 | 50 | ||
| City | 30 | ||
| State/Province | |||
| Zip/Postal | 16 | ||
| Status | Yes | 24 | |
| Lead Time (Days) | |||
| Labor Rate | Hourly rate he vendor charges if they can be assigned labor on work orders. | ||
| Default Sales Tax ID | 24 |