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.

What do you want to do next?