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.
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
Organization
CurrentUser, HourTypes, Organization, OrganizationHourTypePrices
Invoicing
newInvoice_ContactContactDivisions, newInvoice_ContactCustomAttributeValues
Contact
Approval (without relations)
CriteriaTypes, DefaultApprovalSettings, WorkflowSubTypes, WorkflowTypes
CodeValues (without relations)
ApprovalTemplateWorkflowTypes, CostTypes, CustomAttributeOwnerTypes, EmployeeUserTypes, ProjectSecurityLinkStatuses
Contract (without relations)
PurchaseOrderCostTypes, PurchaseOrderStatuses, SubcontractorStatuses
DeliveryTicket (without relations)
ExactOnline (without relations)
Invoicing (without relations)
InvoiceAttachmentsV2, InvoiceChapterLineLinkedBookingItemsV2, InvoiceChapterLinesV2, InvoiceChaptersV2, InvoiceMailStatuses, InvoiceSentEmailsV2, InvoicesV2, newInvoice_ProjectCustomAttributeValues
Native (without relations)
Organization (without relations)
AllowedAccessTypes, CurrentUserPermissions, DefaultProjectStatus, OrganizationSurchargePercentages, ProjectCategories, ProjectCategoryDivisionSettings, ProjectFileCategories
Project (without relations)
PurchaseInvoicing (without relations)
Ubl (without relations)
Views (without relations)
PurchaseInvoiceLines, QuotationAttachments, QuotationChapterLines, QuotationChapters, QuotationSentEmails
Relations
- newInvoice_ContactContactDivisions → ContactTypes (candidate): Derived from the column contactType_id.
- newInvoice_ContactCustomAttributeValues → ContactTypes (candidate): Derived from the column contactType_id.
- CurrentUser → Organization (candidate, 3 keys): Derived from the column organization_id.
- OrganizationHourTypePrices → HourTypes (candidate): Derived from the column hourTypeId.
Tables
Bouw7.Approval
- ApprovalCriteria: Approval Criteria
- ApprovalTemplateCriteriaById: Approval Template Criteria by ID
- ApprovalTemplateCriteriaSuppliersByCriteriaId: Approval Template Criteria Suppliers by Criteria ID
- ApprovalTemplateWorkflowById: Approval Template Workflow by ID
- ApprovalWorkflows: Approval Workflows
- CriteriaTypes: Criteria Types
- DefaultApprovalSettings: Default Approval Settings
- PendingApprovalsAssignedToMe: Pending Approvals Assigned to Me
- WorkflowSubTypes: Workflow Subtypes
- WorkflowTypes: Workflow Types
Bouw7.Booking
- BookingLineContactHoursByProject: Booking Line Contact Hours by Project
- BookingLineDeliveryTicketsByProject: Booking Line Delivery Tickets by Project
- BookingLineEmployeeHoursByProject: Booking Line Employee Hours by Project
- BookingLineEquipmentsByProject: itgen_bouw7_bookinglineequipmentsbyproject_plural
- BookingLineGarbagesByProject: Booking Line Garbages by Project
- BookingLineMaterialsByProject: Booking Line Materials by Project
- BookingLinePurchaseInvoiceLinesByProject: Booking Line Purchase Invoice Lines by Project
- BookingLinesByProject: Booking Lines by Project
Bouw7.Calendar
- DayOffById: Day-off by ID
- DayOffPerEmployeeById: Day-off per Employee by ID
- DaysOff: Days Off
- DaysOffPerEmployee: Days Off per Employee
Bouw7.CheckoutDocument
- CheckoutDocuments: itgen_bouw7_checkoutdocuments_plural
Bouw7.CodeValues
- ApprovalTemplateWorkflowTypes: Domain ApprovalTemplateWorkflowTypes
- CostTypes: Domain CostTypes
- CustomAttributeOwnerTypes: Domain CustomAttributeOwnerTypes
- EmployeeUserTypes: Domain EmployeeUserTypes
- ProjectSecurityLinkStatuses: Domain ProjectSecurityLinkStatuses
Bouw7.Contact
- ContactById: Contact by ID
- ContactCustomAttributeValuesById: Contact Custom Attribute Values by ID
- ContactDivisionsById: Contact Divisions by ID
- ContactFinancials: Contact Financials
- ContactHourTypePricesById: Contact Hour Type Prices by ID
- ContactPersonById: Contact Person by ID
- ContactPersons: Contact Persons
- ContactTypes: Contact Types
- Contacts: Contacts
- SurchargePercentagesByContact: Surcharge Percentages by Contact
Bouw7.Contract
- CalledReceiptBySubcontractorContract: Called Receipt by Sub-contractor Contract
- CalledReceiptBySubcontractorContract_ProjectFileProjectCategoryDivisionSettings: itgen_bouw7_calledreceiptbysubcontractorcontract_projectfileprojectcategorydivisionsettings_plural
- CalledReceiptsByPurchaseOrderContract: Called Receipts by Purchase Order Contract
- CalledReceiptsByPurchaseOrderContract_ProjectFileProjectCategoryDivisionSettings: itgen_bouw7_calledreceiptsbypurchaseordercontract_projectfileprojectcategorydivisionsettings_plural
- ContractAttachmentsByPurchaseOrderContract: itgen_bouw7_contractattachmentsbypurchaseordercontract_plural
- ContractAttachmentsBySubcontractorContract: itgen_bouw7_contractattachmentsbysubcontractorcontract_plural
- ContractOrderLines: Contract Order Lines
- ContractTermOrderLinesByPurchaseOrderId: itgen_bouw7_contracttermorderlinesbypurchaseorderid_plural
- ContractTermOrderLinesBySubcontractorId: itgen_bouw7_contracttermorderlinesbysubcontractorid_plural
- FilesByPurchaseOrderContract: Files by Purchase Order Contract
- FilesBySubcontractorContract: Files by Sub-contractor Contract
- PurchaseOrderById: Purchase Order by ID
- PurchaseOrderContractHistoryEntriesById: Purchase Order Contract History Entries by ID
- PurchaseOrderContractHistoryEntries_ContractProjectCategoryDivisionSettings: itgen_bouw7_purchaseordercontracthistoryentries_contractprojectcategorydivisionsettings_plural
- PurchaseOrderContractTermDeliveryTicketsById: Purchase Order Contract Term Delivery Tickets by ID
- PurchaseOrderContractTerms: Purchase Order Contract Terms
- PurchaseOrderContractTermsById: Purchase Order Contract Terms by ID
- PurchaseOrderContracts: Purchase Order Contracts
- PurchaseOrderCostTypes: Purchase Order Cost Types
- PurchaseOrderStatuses: Purchase Order Statuses
- PurchaseOrder_ApprovalApprovers: itgen_bouw7_purchaseorder_approvalapprovers_plural
- PurchaseOrder_CommonAttachments: itgen_bouw7_purchaseorder_commonattachments_plural
- PurchaseOrder_ProjectCategoryDivisionSettings: itgen_bouw7_purchaseorder_projectcategorydivisionsettings_plural
- SubcontractContractHistoryEntriesBySubcontractorId: Sub-contract Contract History Entries by Sub-contract or ID
- SubcontractorById: Sub-contractor by ID
- SubcontractorContractHistoryEntries_ContractProjectCategoryDivisionSettings: itgen_bouw7_subcontractorcontracthistoryentries_contractprojectcategorydivisionsettings_plural
- SubcontractorContractTermDeliveryTicketsBySubcontractorId: Sub-contractor Contract Term Delivery Tickets by Sub-contractor ID
- SubcontractorContractTerms: Sub-contractor Contract Terms
- SubcontractorContractTermsBySubcontractorId: Sub-contractor Contract Terms by Sub-contractor ID
- SubcontractorContracts: Sub-contractor Contracts
- SubcontractorStatuses: Sub-contractor Statuses
- Subcontractor_ApprovalApprovers: itgen_bouw7_subcontractor_approvalapprovers_plural
- Subcontractor_CommonAttachments: itgen_bouw7_subcontractor_commonattachments_plural
- Subcontractor_ProjectCategoryDivisionSettings: itgen_bouw7_subcontractor_projectcategorydivisionsettings_plural
Bouw7.DeliveryTicket
- DeliveryTicketById: Delivery Ticket by ID
- DeliveryTicket_ProjectCategoryDivisionSettings: itgen_bouw7_deliveryticket_projectcategorydivisionsettings_plural
- DeliveryTicket_PurchaseInvoiceProjectCategoryDivisionSettings: itgen_bouw7_deliveryticket_purchaseinvoiceprojectcategorydivisionsettings_plural
- DeliveryTickets: Delivery Tickets
- PurchaseTypes: Purchase Types
Bouw7.Department
- DepartmentBranchesByDepartmentId: itgen_bouw7_departmentbranchesbydepartmentid_plural
- DepartmentById: Department by ID
- DepartmentWorkInProgressSettingsByDepartmentId: itgen_bouw7_departmentworkinprogresssettingsbydepartmentid_plural
Bouw7.ExactOnline
- AccessibleDivisions: Accessible Divisions
Bouw7.HourLog
- ContactHourLogs: Contact Hour Logs
- EmployeeHourLogs: Employee Hour Logs
- HourLogs: Hour Logs
- HourLogs_ItemsProjectCategoryDivisionSettings: itgen_bouw7_hourlogs_itemsprojectcategorydivisionsettings_plural
Bouw7.I18n
- Countries: Countries
- Currencies: Currencies
- Locales: Locales
- Timezones: Time Zones
Bouw7.Invoicing
- CollectiveInvoicePdfByInvoice: Collective Invoice PDF by Invoice
- InvoiceAttachmentsByInvoiceId: Invoice Attachments by Invoice ID
- InvoiceAttachmentsByProjectId: itgen_bouw7_invoiceattachmentsbyprojectid_plural
- InvoiceAttachmentsV2: itgen_bouw7_invoiceattachmentsv2_plural
- InvoiceById: Invoice by ID
- InvoiceChapterLineLinkedBookingItemsByInvoiceId: Invoice Chapter Line Linked Booking Items by Invoice ID
- InvoiceChapterLineLinkedBookingItemsV2: itgen_bouw7_invoicechapterlinelinkedbookingitemsv2_plural
- InvoiceChapterLineLinkedBookingItemsV2ByProjectId: itgen_bouw7_invoicechapterlinelinkedbookingitemsv2byprojectid_plural
- InvoiceChapterLinesByInvoiceId: Invoice Chapter Lines by Invoice ID
- InvoiceChapterLinesByProjectId: itgen_bouw7_invoicechapterlinesbyprojectid_plural
- InvoiceChapterLinesV2: itgen_bouw7_invoicechapterlinesv2_plural
- InvoiceChaptersByInvoiceId: Invoice Chapters by Invoice ID
- InvoiceChaptersByProjectId: itgen_bouw7_invoicechaptersbyprojectid_plural
- InvoiceChaptersV2: itgen_bouw7_invoicechaptersv2_plural
- InvoiceCompanyInfoByProject: Invoice Company Information by Project
- InvoiceEquipmentListPdfByInvoice: Invoice Equipment PDFs by Invoice
- InvoiceGarbageListPdfByInvoice: Invoice Garbage List PDFs by Invoice
- InvoiceMailStatuses: Invoice Mail Statuses
- InvoiceMaterialListPdfByInvoice: Invoice Material PDFs by Invoice
- InvoicePdfByInvoice: Invoice PDF by Invoice
- InvoiceSentEmailsByInvoiceId: Invoice Sent Emails by Invoice ID
- InvoiceSentEmailsV2: itgen_bouw7_invoicesentemailsv2_plural
- InvoiceSentEmailsV2ByProjectId: itgen_bouw7_invoicesentemailsv2byprojectid_plural
- Invoice_ContactContactDivisions: itgen_bouw7_invoice_contactcontactdivisions_plural
- Invoice_ContactCustomAttributeValues: itgen_bouw7_invoice_contactcustomattributevalues_plural
- Invoice_ProjectCustomAttributeValues: itgen_bouw7_invoice_projectcustomattributevalues_plural
- Invoices: Invoices
- InvoicesV2: itgen_bouw7_invoicesv2_plural
- newInvoiceForProject: New Invoice for Project
- newInvoiceForProject_ContactContactDivisions: itgen_bouw7_newinvoiceforproject_contactcontactdivisions_plural
- newInvoiceForProject_ContactCustomAttributeValues: itgen_bouw7_newinvoiceforproject_contactcustomattributevalues_plural
- newInvoiceForProject_ProjectCustomAttributeValues: itgen_bouw7_newinvoiceforproject_projectcustomattributevalues_plural
- newInvoice_ContactContactDivisions: itgen_bouw7_newinvoice_contactcontactdivisions_plural
- newInvoice_ContactCustomAttributeValues: itgen_bouw7_newinvoice_contactcustomattributevalues_plural
- newInvoice_ProjectCustomAttributeValues: itgen_bouw7_newinvoice_projectcustomattributevalues_plural
Bouw7.MileageRegistrations
- MileageRegistrationById: Mileage Registration by ID
- MileageRegistrations: Mileage Registrations
Bouw7.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Bouw7.Organization
- AllowedAccessTypes: Allowed Access Types
- BasicEmployeeById: Employee by ID (Basic)
- BasicEmployees: Employees (Basic)
- BranchById: Branch by ID
- Branches: Branches
- CommonInvoiceAttachments: Common Invoice Attachments
- CommonQuotationAttachments: Common Quotation Attachments
- CostCenters: Cost Centres
- CurrentUser: Current User
- CurrentUserPermissions: Current User Permissions
- CurrentUser_DepartmentBranches: itgen_bouw7_currentuser_departmentbranches_plural
- CurrentUser_DepartmentWorkInProgressSettings: itgen_bouw7_currentuser_departmentworkinprogresssettings_plural
- CustomAttributeById: Custom Attribute by ID
- CustomAttributeDropdownValuesById: Custom Attribute Drop-down Values by ID
- CustomAttributeItemDropdownValues: Custom Attribute Item Drop-down Values
- CustomAttributes: Custom Attributes
- DefaultProjectStatus: Default Project Status
- Departments: Departments
- DivisionById: Division by ID
- DivisionPurchaseInvoiceImportJournalsById: itgen_bouw7_divisionpurchaseinvoiceimportjournalsbyid_plural
- Divisions: Divisions
- EmployeeById: Employee by ID
- EmployeeCustomAttributeValuesByEmployeeId: Employee Custom Attribute Values by Employee ID
- EmployeeDivisionsById: itgen_bouw7_employeedivisionsbyid_plural
- EmployeeHourTypePricesByEmployeeId: Employee Hour Type Prices by Employee ID
- Employees: Employees
- GeneralLedgerAccountsByBranch: General Ledger Accounts by Branch
- HourTypeById: Hour Type by ID
- HourTypes: Hour Types
- Organization: Organisation
- OrganizationHourTypePrices: Organisation Hour Type Prices
- OrganizationSurchargePercentages: Organisation Surcharge Percentages
- ProjectCategories: Project Categories
- ProjectCategoryById: Project Category by ID
- ProjectCategoryDivisionSettings: Project Category Division Settings
- ProjectCategoryDivisionSettingsByProjectCategoryId: Project Category Division Settings by Project Category ID
- ProjectFileCategories: Project File Categories
- ProjectFileCategoryById: Project File Category by ID
- ProjectStatuses: Project Statuses
- QuotationConfirmationAttachments: Quotation Confirmation Attachments
- QuotationStatusById: Quotation Status by ID
- TemplatesByCategory: Templates by Category
- VatTariffs: VAT Tariffs
Bouw7.ProgressSheet
- ProgressSheets: itgen_bouw7_progresssheets_plural
Bouw7.Project
- DeletedProjects: Deleted Projects
- InvoiceTermStatements: Invoice Term Statements
- InvoiceTerms: Invoice Terms
- ProjectById: Project by ID
- ProjectCustomAttributeValuesByProjectId: Project Custom Attribute Values by Project ID
- ProjectEmployeesByProjectId: Project Employees by Project ID
- ProjectFileById: Project File by ID
- ProjectFileDepartmentsByProjectId: Project File Departments by Project ID
- ProjectFile_ProjectCategoryDivisionSettings: itgen_bouw7_projectfile_projectcategorydivisionsettings_plural
- ProjectHourEstimatesPerHourTypeByProjectId: Project Hour Estimates per Hour Type by Project ID
- Projects: Projects
- canCreateInvoice: Can Create Invoice
Bouw7.PropertyAsset
- PropertyAssetById: Property Asset by ID
- PropertyAssetCustomAttributeValuesByPropertyAssetId: Property Asset Custom Attribute Values by Property Asset ID
- PropertyAssetProjectsByPropertyAssetId: Property Asset Projects by Property Asset ID
- PropertyAsset_ProjectCategoryDivisionSettings: itgen_bouw7_propertyasset_projectcategorydivisionsettings_plural
- PropertyAsset_ProjectsCategoryDivisionSettings: itgen_bouw7_propertyasset_projectscategorydivisionsettings_plural
- PropertyAssets: Property Assets
Bouw7.PurchaseInvoicing
- PurchaseInvoiceById: Purchase Invoice by ID
- PurchaseInvoiceLinesByPurchaseInvoiceId: Purchase Invoice Lines by Purchase Invoice ID
- PurchaseInvoiceStatuses: Purchase Invoice Statuses
- PurchaseInvoice_ApprovalApprovers: itgen_bouw7_purchaseinvoice_approvalapprovers_plural
- PurchaseInvoice_LinesDeliveryTicketProjectCategoryDivisionSettings: itgen_bouw7_purchaseinvoice_linesdeliveryticketprojectcategorydivisionsettings_plural
- PurchaseInvoice_ProjectCategoryDivisionSettings: itgen_bouw7_purchaseinvoice_projectcategorydivisionsettings_plural
- PurchaseInvoices: Purchase Invoices
Bouw7.Quotation
- QuotationAttachmentsByQuotationId: Quotation Attachments by Quotation ID
- QuotationAttachmentsV2ByProjectId: itgen_bouw7_quotationattachmentsv2byprojectid_plural
- QuotationById: Quotation by ID
- QuotationChapterLinesByQuotationId: Quotation Chapter Lines by Quotation ID
- QuotationChapterLinesV2ByProjectId: itgen_bouw7_quotationchapterlinesv2byprojectid_plural
- QuotationChaptersByQuotationId: Quotation Chapters by Quotation ID
- QuotationChaptersV2ByProjectId: itgen_bouw7_quotationchaptersv2byprojectid_plural
- QuotationCommonAttachmentsByQuotationId: Quotation Common Attachments by Quotation ID
- QuotationCommonAttachmentsV2ByProjectId: itgen_bouw7_quotationcommonattachmentsv2byprojectid_plural
- QuotationReminderById: Quotation Reminder by ID
- QuotationReminders: Quotation Reminders
- QuotationSentEmailsByQuotationId: Quotation Sent Emails by Quotation ID
- QuotationSentEmailsV2ByProjectId: itgen_bouw7_quotationsentemailsv2byprojectid_plural
- QuotationStatusLogs: Quotation Status Logs
- Quotation_ProjectCategoryDivisionSettings: itgen_bouw7_quotation_projectcategorydivisionsettings_plural
- Quotations: Quotations
- newQuotationForProject: New Quotation for Project
- newQuotationForProject_ProjectCategoryDivisionSettings: itgen_bouw7_newquotationforproject_projectcategorydivisionsettings_plural
Bouw7.Resource
- EquipmentBookingById: Equipment Booking by ID
- EquipmentBookingEmployeesByEquipmentBookingId: Equipment Booking Employees by Equipment Booking ID
- EquipmentBooking_ProjectCategoryDivisionSettings: itgen_bouw7_equipmentbooking_projectcategorydivisionsettings_plural
- EquipmentBookings: Equipment Bookings
- EquipmentById: Equipment by ID
- EquipmentById2: Equipment by ID
- EquipmentEmployeesByEquipmentId: Equipment Employees by Equipment ID
- EquipmentGroupById: Equipment Group by ID
- EquipmentGroups: Equipment Groups
- EquipmentPerUnit: Equipment per Unit
- EquipmentUnitById: Equipment Unit by ID
- EquipmentUnits: Equipment Units
- EquipmentUnitsByEquipmentId: Equipment Units by Equipment ID
- GarbageBookings: Garbage Bookings
- GarbagePerUnit: Garbage per Unit
- Garbages: Garbages
- MaterialBookings: Material Bookings
- MaterialById: Material by ID
- MaterialPerUnitById: Material per Unit by ID
- MaterialPerUnitPerDivisionByMaterialPerUnitId: Material per Unit per Division by Material per Unit ID
- MaterialPerUnit_MaterialGroupDivisionSettings: itgen_bouw7_materialperunit_materialgroupdivisionsettings_plural
- MaterialUnitById: Material Unit by ID
- MaterialUnits: Material Units
- Materials: Materials
- MaterialsPerUnit: Materials per Unit
- ResourceBookingById: Resource Booking by ID
- ResourceBookingEmployeesById: Resource Booking Employees by ID
- ResourceBookingItemsByCriteria: Resource Booking Items by Criteria
- ResourceBookingsByCriteria: Resource Bookings by Criteria
- ResourceById: Resource by ID
- ResourceEmployeesById: Resource Employees by ID
- ResourceGroupById: Resource Group by ID
- ResourceItemEmployees: Resource Item Employees
- ResourceItemUnits: Resource Item Units
- ResourceUnitById: Resource Unit by ID
- ResourceUnitsById: Resource Units by ID
- Resources: Resources
- WasteBookingById: Waste Booking by ID
- WasteBooking_ProjectCategoryDivisionSettings: itgen_bouw7_wastebooking_projectcategorydivisionsettings_plural
- WasteById: Waste by ID
- WasteById2: Waste by ID
- WastePerUnitById: Waste per Unit by ID
- WastePerUnitById2: Waste per Unit by ID
- WasteUnitById: Waste Unit by ID
- WasteUnits: Waste Units
Bouw7.Security
- ProjectSecurityLinkById: Project Security Link by ID
- SecurityObjectById: Security Object by ID
Bouw7.Storage
- DownloadFileByHash: Download File by Hash
- FileContentsByHash: File Contents by Hash
Bouw7.Ubl
Bouw7.Views
- PurchaseInvoiceLines: Purchase Invoice Lines
- QuotationAttachments: Quotation Attachments
- QuotationChapterLines: Quotation Chapter Lines
- QuotationChapters: Quotation Chapters
- QuotationSentEmails: Quotation Sent Emails
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: