invantive documentation
Invantive Support ForumsLog In / Sign Up

Bouw7 Data Model

Bouw7 is a cloud solution for construction companies. Bouw7 is also known as "Exact Online Bouw" and integrates into Exact Online. Bouw7 also provides service and maintenance modules, plus CRM functionality.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/bouw7

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.exact.com/.

Figures

Figure Count
Tables 270
Columns 16,125
Tables with insert 2
Tables with update 0
Tables with delete 0
Tables documented 260

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Bouw7 data model, Sheet 1 of 1Bouw7 data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026Organization · Invoicing · ContactSheet 1 of 1 · documentation.invantive.euOrganization×3Bouw7.Organization.CurrentUser: Current User (Bouw7.Organization.CurrentUser_DepartmentBranches, Bouw7.Organization.CurrentUser_DepartmentWorkInProgressSettings)CurrentUser+_DepartmentBranches +_DepartmentWork…Bouw7.Organization.HourTypes: Hour TypesHourTypesBouw7.Organization.Organization: OrganisationOrganizationBouw7.Organization.OrganizationHourTypePrices: Organisation Hour Type PricesOrganizationHourTypePricesInvoicingBouw7.Invoicing.newInvoice_ContactContactDivisions: itgen_bouw7_newinvoice_contactcontactdivisions_pluralnewInvoice_ContactContactDivisionsBouw7.Invoicing.newInvoice_ContactCustomAttributeValues: itgen_bouw7_newinvoice_contactcustomattributevalues_pluralnewInvoice_ContactCustomAttributeV…Bouw7.Contact.ContactTypes: Contact TypesContactTypesContactContactBouw7.Contact.ContactTypes: Contact TypesContactTypesApprovalBouw7.Approval.CriteriaTypes: Criteria TypesCriteriaTypesBouw7.Approval.DefaultApprovalSettings: Default Approval SettingsDefaultApprovalSettingsBouw7.Approval.WorkflowSubTypes: Workflow SubtypesWorkflowSubTypesBouw7.Approval.WorkflowTypes: Workflow TypesWorkflowTypesCodeValuesBouw7.CodeValues.ApprovalTemplateWorkflowTypes: Domain ApprovalTemplateWorkflowTypesApprovalTemplateWorkflowTypesBouw7.CodeValues.CostTypes: Domain CostTypesCostTypesBouw7.CodeValues.CustomAttributeOwnerTypes: Domain CustomAttributeOwnerTypesCustomAttributeOwnerTypesBouw7.CodeValues.EmployeeUserTypes: Domain EmployeeUserTypesEmployeeUserTypesBouw7.CodeValues.ProjectSecurityLinkStatuses: Domain ProjectSecurityLinkStatusesProjectSecurityLinkStatusesContractBouw7.Contract.PurchaseOrderCostTypes: Purchase Order Cost TypesPurchaseOrderCostTypesBouw7.Contract.PurchaseOrderStatuses: Purchase Order StatusesPurchaseOrderStatusesBouw7.Contract.SubcontractorStatuses: Sub-contractor StatusesSubcontractorStatusesDeliveryTicketBouw7.DeliveryTicket.PurchaseTypes: Purchase TypesPurchaseTypesExactOnlineBouw7.ExactOnline.AccessibleDivisions: Accessible DivisionsAccessibleDivisionsInvoicingBouw7.Invoicing.InvoiceAttachmentsV2: itgen_bouw7_invoiceattachmentsv2_pluralInvoiceAttachmentsV2Bouw7.Invoicing.InvoiceChapterLineLinkedBookingItemsV2: itgen_bouw7_invoicechapterlinelinkedbookingitemsv2_pluralInvoiceChapterLineLinkedBookingItemsV2Bouw7.Invoicing.InvoiceChapterLinesV2: itgen_bouw7_invoicechapterlinesv2_pluralInvoiceChapterLinesV2Bouw7.Invoicing.InvoiceChaptersV2: itgen_bouw7_invoicechaptersv2_pluralInvoiceChaptersV2Bouw7.Invoicing.InvoiceMailStatuses: Invoice Mail StatusesInvoiceMailStatusesBouw7.Invoicing.InvoiceSentEmailsV2: itgen_bouw7_invoicesentemailsv2_pluralInvoiceSentEmailsV2Bouw7.Invoicing.InvoicesV2: itgen_bouw7_invoicesv2_pluralInvoicesV2Bouw7.Invoicing.newInvoice_ProjectCustomAttributeValues: itgen_bouw7_newinvoice_projectcustomattributevalues_pluralnewInvoice_ProjectCustomAttributeValuesNativeBouw7.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSOrganizationBouw7.Organization.AllowedAccessTypes: Allowed Access TypesAllowedAccessTypesBouw7.Organization.CurrentUserPermissions: Current User PermissionsCurrentUserPermissionsBouw7.Organization.DefaultProjectStatus: Default Project StatusDefaultProjectStatusBouw7.Organization.OrganizationSurchargePercentages: Organisation Surcharge PercentagesOrganizationSurchargePercentagesBouw7.Organization.ProjectCategories: Project CategoriesProjectCategoriesBouw7.Organization.ProjectCategoryDivisionSettings: Project Category Division SettingsProjectCategoryDivisionSettingsBouw7.Organization.ProjectFileCategories: Project File CategoriesProjectFileCategoriesProjectBouw7.Project.DeletedProjects: Deleted ProjectsDeletedProjectsPurchaseInvoicingBouw7.PurchaseInvoicing.PurchaseInvoiceStatuses: Purchase Invoice StatusesPurchaseInvoiceStatusesUblBouw7.Ubl.Versions: VersionsVersionsViewsBouw7.Views.PurchaseInvoiceLines: Purchase Invoice LinesPurchaseInvoiceLinesBouw7.Views.QuotationAttachments: Quotation AttachmentsQuotationAttachmentsBouw7.Views.QuotationChapterLines: Quotation Chapter LinesQuotationChapterLinesBouw7.Views.QuotationChapters: Quotation ChaptersQuotationChaptersBouw7.Views.QuotationSentEmails: Quotation Sent EmailsQuotationSentEmailsBouw7NotesThis data model declares no keys yet; the dotted relations are derived from column names.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsContact1Invoicing1Organization1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n keys between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/exactonlinebouw
The poster as text: tables per topic and their relations

Organization

CurrentUser, HourTypes, Organization, OrganizationHourTypePrices

Invoicing

newInvoice_ContactContactDivisions, newInvoice_ContactCustomAttributeValues

Contact

ContactTypes

Approval (without relations)

CriteriaTypes, DefaultApprovalSettings, WorkflowSubTypes, WorkflowTypes

CodeValues (without relations)

ApprovalTemplateWorkflowTypes, CostTypes, CustomAttributeOwnerTypes, EmployeeUserTypes, ProjectSecurityLinkStatuses

Contract (without relations)

PurchaseOrderCostTypes, PurchaseOrderStatuses, SubcontractorStatuses

DeliveryTicket (without relations)

PurchaseTypes

ExactOnline (without relations)

AccessibleDivisions

Invoicing (without relations)

InvoiceAttachmentsV2, InvoiceChapterLineLinkedBookingItemsV2, InvoiceChapterLinesV2, InvoiceChaptersV2, InvoiceMailStatuses, InvoiceSentEmailsV2, InvoicesV2, newInvoice_ProjectCustomAttributeValues

Native (without relations)

NATIVEPLATFORMSCALARREQUESTS

Organization (without relations)

AllowedAccessTypes, CurrentUserPermissions, DefaultProjectStatus, OrganizationSurchargePercentages, ProjectCategories, ProjectCategoryDivisionSettings, ProjectFileCategories

Project (without relations)

DeletedProjects

PurchaseInvoicing (without relations)

PurchaseInvoiceStatuses

Ubl (without relations)

Versions

Views (without relations)

PurchaseInvoiceLines, QuotationAttachments, QuotationChapterLines, QuotationChapters, QuotationSentEmails

Relations

Tables

Bouw7.Approval

Bouw7.Booking

Bouw7.Calendar

Bouw7.CheckoutDocument

Bouw7.CodeValues

Bouw7.Contact

Bouw7.Contract

Bouw7.DeliveryTicket

Bouw7.Department

Bouw7.ExactOnline

Bouw7.HourLog

Bouw7.I18n

Bouw7.Invoicing

Bouw7.MileageRegistrations

Bouw7.Native

Bouw7.Organization

Bouw7.ProgressSheet

Bouw7.Project

Bouw7.PropertyAsset

Bouw7.PurchaseInvoicing

Bouw7.Quotation

Bouw7.Resource

Bouw7.Security

Bouw7.Storage

Bouw7.Ubl

Bouw7.Views

Sample Queries

--
-- Retrieve list of all Bouw7 companies.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/bouw7-data-model/webhelp/bouw7-connector-contact-contacts.html
--
select *
from   Bouw7.Contact.Contacts@bow
limit  100
--
-- Retrieve list of all Bouw7 projects.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/bouw7-data-model/webhelp/bouw7-connector-project-projects.html
--
select *
from   Bouw7.Project.Projects@bow
limit  100

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: