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.
Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/bouw7
Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.
Platform
- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://status.exact.com/.
Cijfers
| Figure | Count |
|---|---|
| Tables | 270 |
| Columns | 16,125 |
| Tabeller med invoegsel | 2 |
| Tabeller med update | 0 |
| Tabellen met de functie 'verwijderen' | 0 |
| Tabeller gedocumenteerd | 260 |
Poster met datamodel
In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden
Organization
CurrentUser, HourTypes, Organization, OrganizationHourTypePrices
Invoicing
newInvoice_ContactContactDivisions, newInvoice_ContactCustomAttributeValues
Contactpersoon
Goedkeuring (zonder relaties)
CriteriaTypes, DefaultApprovalSettings, WorkflowSubTypes, WorkflowTypes
CodeValues (zonder relaties)
ApprovalTemplateWorkflowTypes, CostTypes, CustomAttributeOwnerTypes, EmployeeUserTypes, ProjectSecurityLinkStatuses
Contract (zonder relaties)
PurchaseOrderCostTypes, PurchaseOrderStatuses, SubcontractorStatuses
DeliveryTicket (zonder relaties)
ExactOnline (zonder relaties)
Invoicing (zonder relaties)
InvoiceAttachmentsV2, InvoiceChapterLineLinkedBookingItemsV2, InvoiceChapterLinesV2, InvoiceChaptersV2, InvoiceMailStatuses, InvoiceSentEmailsV2, InvoicesV2, newInvoice_ProjectCustomAttributeValues
Native (zonder relaties)
Organization (zonder relaties)
AllowedAccessTypes, CurrentUserPermissions, DefaultProjectStatus, OrganizationSurchargePercentages, ProjectCategories, ProjectCategoryDivisionSettings, ProjectFileCategories
Project (zonder relaties)
PurchaseInvoicing (zonder relaties)
Ubl (zonder relaties)
Views (zonder relaties)
PurchaseInvoiceLines, QuotationAttachments, QuotationChapterLines, QuotationChapters, QuotationSentEmails
Relaties
- newInvoice_ContactContactDivisions → ContactTypes (kandidaat): Derived from the column contactType_id.
- newInvoice_ContactCustomAttributeValues → ContactTypes (kandidaat): Derived from the column contactType_id.
- CurrentUser → Organization (kandidaat, 3 keys): Derived from the column organization_id.
- OrganizationHourTypePrices → HourTypes (kandidaat): Derived from the column hourTypeId.
Tabellen
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
Voorbeeldqueries
--
-- 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
Attributen
The attributes of this platform are on the page Attributes.
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: