AI Document Capture Vendor Sync Fields

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

Filename: AIDOCVEN.DAT

The AIDOCVEN.DAT file contains metadata indicating which vendor records have been synced with the AI Document Capture service.

• To add AI Document Capture Vendor Sync fields to your Crystal reports, select AIDOCVEN.DAT.

Indexes and their uses

The AIDOCVEN.DAT file has the following indexes:

0 = By RecordNumber

1 = By VendorGUID

2 = By LastUploadStatus

Fields

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

Field Name	Type	Size	Comment
RecordNumber	Integer		Unique key for this record.
VendorGUID	Ubinary		Foreign key to the Vendor record.
LastUploadStatus	Short		Status of the capture (e.g., Pending, Success, or Failed).
LastUpdateCounter	Integer	4	Helps detect when the record in the table changes after it is opened.