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.
Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/bouw7
Les comparaisons de texte sur cette plateforme tiennent compte de la casse.
Plate-forme
- Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
- Type : une application accessible via son API.
- Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://status.exact.com/.
Chiffres
| Figure | Count |
|---|---|
| Tables | 270 |
| Columns | 16,125 |
| Tableaux avec insert | 2 |
| Tables avec mise à jour | 0 |
| Tables avec la clause DELETE | 0 |
| Tableaux documentés | 260 |
Affiche sur le modèle de données
Ce modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des points sont dérivées des noms de colonnes.
Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.
L'affiche sous forme de texte : tableaux par thème et leurs relations
Organization
CurrentUser, HourTypes, Organization, OrganizationHourTypePrices
Invoicing
newInvoice_ContactContactDivisions, newInvoice_ContactCustomAttributeValues
Contat
Validation (sans relations)
CriteriaTypes, DefaultApprovalSettings, WorkflowSubTypes, WorkflowTypes
CodeValues (sans relations)
ApprovalTemplateWorkflowTypes, CostTypes, CustomAttributeOwnerTypes, EmployeeUserTypes, ProjectSecurityLinkStatuses
Contrat (sans relations)
PurchaseOrderCostTypes, PurchaseOrderStatuses, SubcontractorStatuses
DeliveryTicket (sans relations)
ExactOnline (sans relations)
Invoicing (sans relations)
InvoiceAttachmentsV2, InvoiceChapterLineLinkedBookingItemsV2, InvoiceChapterLinesV2, InvoiceChaptersV2, InvoiceMailStatuses, InvoiceSentEmailsV2, InvoicesV2, newInvoice_ProjectCustomAttributeValues
Native (sans relations)
Organization (sans relations)
AllowedAccessTypes, CurrentUserPermissions, DefaultProjectStatus, OrganizationSurchargePercentages, ProjectCategories, ProjectCategoryDivisionSettings, ProjectFileCategories
Projet (sans relations)
PurchaseInvoicing (sans relations)
Ubl (sans relations)
Vues (sans relations)
PurchaseInvoiceLines, QuotationAttachments, QuotationChapterLines, QuotationChapters, QuotationSentEmails
Relations
- newInvoice_ContactContactDivisions → ContactTypes (candidat): Derived from the column contactType_id.
- newInvoice_ContactCustomAttributeValues → ContactTypes (candidat): Derived from the column contactType_id.
- CurrentUser → Organization (candidat, 3 keys): Derived from the column organization_id.
- OrganizationHourTypePrices → HourTypes (candidat): Derived from the column hourTypeId.
Tableaux
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
Exemples de 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
Attributs
The attributes of this platform are on the page Attributes.
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :