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. |