AI Document Capture Transaction Fields

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

Filename: AIDOCCAP.DAT

The AIDOCCAP.DAT file contains metadata linking an uploaded document processed by the AI Document Capture API to its associated journal entry.

• To add AI Document Capture Transaction fields to your Crystal reports, select AIDOCCAP.DAT.

Indexes and their uses

The AIDOCCAP.DAT file has the following indexes:

0 = By GUID

1 = By OrchestrationId

2 = By JournalGUID

Fields

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

Field Name	Type	Size	Comment
GUID	Ubinary		Unique key for this record.
OrchestrationId	Ubinary		Unique identifier generated after a document is uploaded to the AI Document Capture API.
Journal_GUID	Ubinary		Foreign key to the Journal Header record associated with this capture.
Status	Short		Status of the capture (e.g., Registered, Posted).
FileName	String	255	Name of the uploaded document used for preview.
LastUpdateCounter	Integer	4	Helps detect when the record in the table changes after it is opened.