Available in Sage 50 Quantum Accounting.

Vendor Insurance Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: VENDINS.DAT

VENDINS.DAT is the Vendor Insurance file. The information below is entered or displayed on the Insurance tab in the Maintain Vendors window.

• To add Sage 50 Vendor Insurance fields to your Crystal reports, select VENDINS.DAT.

Indexes and Their Uses

This file has three indexes:

0 = By vendor record number.

1 = By vendor record number, then by insurance type.

2 = By GUID

Fields

The following table shows the fields available in the VENDINS.DAT file and includes the type and size in number of bytes of each field.

Field Name	Type	Size	Comment
VendorRecordNumber	Integer		This (internal) vendor field is used for linking purposes to other Sage 50 data tables. For more information, This field is unique in the table and never changes.
InsuranceType	Integer		The Insurance policy type on the Insurance tab in the Maintain Vendors window. 1=Workers' Compensation 2=General Liability 3=Umbrella Policy 4=Automobile Policy
GUID	UBinary		GUID (Globally Unique Identifier) used for linking the Vendor Insurance table.
ExpirationDate	Date	4	Insurance policy expiration date
InsurCompanyName	Zstring	30	Name of the Insurance Company that issued the policy
PolicyNum	Zstring	25	Insurance policy number
InsuranceNotes	Zstring	255	Notes used to store additional policy information
LastUpdateCounter	Integer		This increases incrementally when the record is changed.