invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Bouw7 Data Model

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

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

Poster sul modello di dati

Questo modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivano dai nomi delle colonne.

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Bouw7 Modello di dati, Foglio 1 di 1Bouw7 Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.3-BETA+6294 · 01-11-2026Organization · Invoicing · ContattoFoglio 1 di 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 TypesContactTypesContattoContattoBouw7.Contact.ContactTypes: Contact TypesContactTypesApprovazioneBouw7.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 ProjectSecurityLinkStatusesProjectSecurityLinkStatusesContrattoBouw7.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 CategoriesProjectFileCategoriesProgettoBouw7.Project.DeletedProjects: Deleted ProjectsDeletedProjectsPurchaseInvoicingBouw7.PurchaseInvoicing.PurchaseInvoiceStatuses: Purchase Invoice StatusesPurchaseInvoiceStatusesUblBouw7.Ubl.Versions: VersionsVersionsVisualizzazioniBouw7.Views.PurchaseInvoiceLines: Purchase Invoice LinesPurchaseInvoiceLinesBouw7.Views.QuotationAttachments: Quotation AttachmentsQuotationAttachmentsBouw7.Views.QuotationChapterLines: Quotation Chapter LinesQuotationChapterLinesBouw7.Views.QuotationChapters: Quotation ChaptersQuotationChaptersBouw7.Views.QuotationSentEmails: Quotation Sent EmailsQuotationSentEmailsBouw7NoteQuesto modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivanodai nomi delle colonne.Dizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiContatto1Invoicing1Organization1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleGenerato dai metadati di Invantive UniversalSQL 27.1.3-BETA+6294 il 01-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/exactonlinebouw
Il poster come testo: tabelle per argomento e le loro relazioni

Organization

CurrentUser, HourTypes, Organization, OrganizationHourTypePrices

Invoicing

newInvoice_ContactContactDivisions, newInvoice_ContactCustomAttributeValues

Contatto

ContactTypes

Approvazione (senza relazioni)

CriteriaTypes, DefaultApprovalSettings, WorkflowSubTypes, WorkflowTypes

CodeValues (senza relazioni)

ApprovalTemplateWorkflowTypes, CostTypes, CustomAttributeOwnerTypes, EmployeeUserTypes, ProjectSecurityLinkStatuses

Contratto (senza relazioni)

PurchaseOrderCostTypes, PurchaseOrderStatuses, SubcontractorStatuses

DeliveryTicket (senza relazioni)

PurchaseTypes

ExactOnline (senza relazioni)

AccessibleDivisions

Invoicing (senza relazioni)

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

Native (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

Organization (senza relazioni)

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

Progetto (senza relazioni)

DeletedProjects

PurchaseInvoicing (senza relazioni)

PurchaseInvoiceStatuses

Ubl (senza relazioni)

Versions

Visualizzazioni (senza relazioni)

PurchaseInvoiceLines, QuotationAttachments, QuotationChapterLines, QuotationChapters, QuotationSentEmails

Relazioni

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.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: