Available in Sage 50 Quantum Accounting.
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
VENDINS.DAT is the Vendor Insurance file. The information below is entered or displayed on the Insurance tab in the Maintain Vendors window.
This file has three indexes:
0 = By vendor record number.
1 = By vendor record number, then by insurance type.
2 = By GUID
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. |