Vendor Insurance Fields (Import/Export)

How Do I...

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