The following table lists the fields available for import or export, with a brief description of the field and (when necessary) a character limit for the field. The Import? column identifies which fields are available for import (all are available for export).
Note: Vendor fields are exported using VENDINS.CSV as the default file name.
Field Name |
Import? |
Description of Field |
Limit |
---|---|---|---|
Vendor ID |
Y |
Alphanumeric – Vendor ID number |
Up to 20 characters |
Insurance Type |
Y |
1.Workers' Compensation 2. General Liability 3. Umbrella Policy 4. Automobile Policy |
|
Expiration Date |
Y |
Date - Date the insurance policy expires. Must be in ##/##/## (month/day/yr) format. |
|
Company Name |
Y |
Alphanumeric – Insurance company name |
Up to 30 characters |
Policy Number |
Y |
Alphanumeric – Insurance policy number |
up to 25 characters |
Insurance Notes |
Y |
Alphanumeric – Additional notes about the insurance policy |
Up to 255 characters |