Tables and fields reference

This article provides a complete reference of all tables and fields in Ventoo Document Merger.

Doc. Merge Global Rule (Table 70679850)

Stores global merge rules that apply to all documents of a specific type.

Field	Type	Description
Entry No.	Integer	Auto-increment primary key.
Document Type	Enum (Report Selection Usage)	The document type this rule applies to (for example, S.Invoice, P.Order).
Sequence No.	Integer	Position in the merge order. Minimum value: 2 (position 1 is reserved for the main report).
Source Type	Enum (Doc. Merge Source Type)	The source of documents to include.
File Name Pattern	Text[250]	Wildcard pattern for file name matching.
Exclude File Name Pattern	Text[250]	Comma-separated patterns for file name exclusion.
File Type Filter	Text[50]	File extension filter (for example, `pdf,jpg`).
Report ID	Integer	Report ID for BC Report source type.
Report Reference Entry No.	Integer	Links to a Report Reference template.
Active	Boolean	Enables or disables the rule.
Description	Text[100]	Free-text description.
Static Document Code	Code[20]	Code of the static document (for Static Document source type).
Attach Separately	Boolean	When true, the matched document is attached as a separate email file.

Name	Fields	Description
Primary Key	Entry No.	Unique identifier.
DocumentSequence	Document Type, Sequence No.	Orders rules within a document type.
ActiveRules	Document Type, Active	Filters active rules by document type.

Stores partner-specific merge rules that override global rules. Structure is identical to the Global Rule table, with two additional fields.

Field	Type	Description
Partner Type	Option (Customer, Vendor)	Whether this rule applies to a customer or vendor.
Partner No.	Code[20]	The customer or vendor number.
(All fields from Global Rule)		Same fields as the Global Rule table.

Name	Fields
Primary Key	Entry No.
PartnerDocument	Partner Type, Partner No., Document Type, Sequence No.

Stores the persistent document composition for each source document.

Field	Type	Description
Entry No.	Integer	Auto-increment primary key.
Source Table ID	Integer	The table ID of the source document.
Source Document Type	Enum (Report Selection Usage)	The document type.
Source Document No.	Code[20]	The document number.
Source System ID	Guid	SystemId of the source document. Used for SubPageLink filtering.
Sequence No.	Integer	Position in the merge order.
Source Type	Enum (Doc. Merge Source Type)	The type of document source.
Document Name	Text[250]	Display name of the document.
Reference System ID	Guid	SystemId of the linked record (attachment or incoming document).
Report ID	Integer	Report ID for BC Report entries.
Report Filter Record ID	RecordId	RecordId used for filtering reports.
Included	Boolean	Whether the document is included in the merge.
Manually Adjusted	Boolean	Whether the user has manually edited this entry.
Created From Rule Entry No.	Integer	The rule that created this entry.
Created From Rule Level	Option (Global, Partner)	Whether the entry was created from a global or partner rule.
File Extension	Text[10]	File extension (for example, pdf).
MIME Type	Text[100]	Content type.
Report Request XML	Blob	Stored report filter/option configuration.
Static Document Code	Code[20]	Reference to static document.
Added Without Rebuild	Boolean	Indicates the item was appended without a full rebuild.
Attach Separately	Boolean	Whether to attach as a separate email file.

Name	Fields
Primary Key	Entry No.
Document	Source Table ID, Source Document No., Sequence No.
SourceSystemId	Source System ID, Sequence No.
IncludedDocs	Source System ID, Included, Sequence No.

Stores report reference templates for cross-document lookups.

Field	Type	Description
Entry No.	Integer	Auto-increment primary key.
Template Code	Code[20]	Unique template identifier.
Description	Text[100]	Descriptive name.
Reference Type	Enum (Doc. Merge Reference Type)	Line Reference or Header Reference.
Source Table ID	Integer	Table containing the link field.
Source Filter Field No.	Integer	Field used to filter source records (default: 3 = Document No.).
Source Link Field No.	Integer	Field containing the link value.
Target Table ID	Integer	Table containing the related records.
Target Match Field No.	Integer	Field to match against in the target table.
Target Report ID	Integer	Report to render for matched records.
Report Request XML	Blob	Stored report filter configuration.
Is Template	Boolean	Indicates a pre-configured default template (read-only).

Stores global configuration settings. Contains a single record.

Field	Type	Description
Primary Key	Code[10]	Always blank (singleton pattern).
Sales Documents Active	Boolean	Enables merging for sales documents.
Purchase Documents Active	Boolean	Enables merging for purchase documents.
Reminders Active	Boolean	Enables merging for reminders.
Auto Rebuild Active	Boolean	Enables automatic rebuild when attachments change.
Attach Invoices to Reminder	Boolean	Enables automatic invoice attachment for reminders.
Suppress Inc. Doc S.Invoice	Boolean	Suppresses incoming documents on sales invoice emails.

Stores pre-uploaded documents for inclusion in merges.

Field	Type	Description
Code	Code[20]	Unique identifier.
Description	Text[100]	Descriptive name.
File Name	Text[250]	Original file name (read-only, set on import).
File Extension	Text[10]	File extension (read-only, set on import).
Document Content	Blob	The actual file content.
Valid From	Date	Start of validity period (optional).
Valid To	Date	End of validity period (optional).
Language Code	Code[10]	Language code for multi-language support.
Date Comparison Type	Enum (Doc. Merge Date Comparison)	Determines which date to compare against validity.

Field	Type	Description
Attach Invoices To Reminder	Enum (Doc. Merge Override Option)	Overrides the global invoice attachment setting per customer. Options: Default, Yes, No.