invantive documentation
Invantive Support ForumsLog In / Sign Up

Robaws Data Model

Accounting software for construction and project-based companies.

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

The data is partitioned per partition (COMPANY_CODE).

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.
  • Data can be written as well as read.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.robaws.be/nl/.
  • Language of its user community: Dutch.

Figures

Figure Count
Tables 127
Columns 3,097
Tables with insert 69
Tables with update 64
Tables with delete 68
Tables documented 3

Data Model Poster

PDF, 1 A0 sheet

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

Robaws data model, Sheet 1 of 1Robaws data modelfor use with Invantive UniversalSQLRelease 27.1.33-BETA+6408 · 03-11-2026Sale · Contacts · Stock · Sale · Users · Sale · ExecutionPhases · Employee · WorkSheet 1 of 1 · documentation.invantive.euSale · Contacts×2×2Robaws.Activities.Activities: ActivitiesActivitiesRobaws.ArticleGroups.ArticleGroups: Article GroupsArticleGroupsRobaws.ArticleSuppliers.ArticleSuppliers: Article SuppliersArticleSuppliersRobaws.ClaimStateLineItems.ClaimStateLineItems: Claim State Line ItemsClaimStateLineItemsRobaws.ClaimStates.ClaimStates: Claim StatesClaimStatesRobaws.Users.UsersURobaws.Contacts.Contacts: ContactsContactsRobaws.DeliveryNotes.DeliveryNotes: Delivery NotesDeliveryNotesRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.Installations.Installations: InstallationsInstallationsRobaws.Companies.CompaniesCRobaws.Employees.EmployeesERobaws.Clients.ClientsLRobaws.LegalForms.LegalForms: Legal FormsLegalFormsRobaws.Offers.Offers: OffersOffersRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.PaymentConditions.PaymentConditions: Payment ConditionsPaymentConditionsRobaws.Posts.Posts: PostsPostsRobaws.ProjectConstructionPartners.ProjectConstructionPartners: Project Construction PartnersProjectConstructionPartnersRobaws.Projects.Projects: ProjectsProjectsRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.PurchaseInvoices.PurchaseInvoices: Purchase InvoicesPurchaseInvoicesRobaws.Companies.CompaniesCRobaws.Users.UsersURobaws.SalesInvoiceLineItems.SalesInvoiceLineItems: Sales Invoice Line ItemsSalesInvoiceLineItemsRobaws.SalesInvoices.SalesInvoices: Sales InvoicesSalesInvoicesRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.SalesOrders.SalesOrders: Sales OrdersSalesOrdersRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.SubscriptionLineItems.SubscriptionLineItems: Subscription Line ItemsSubscriptionLineItemsRobaws.Subscriptions.Subscriptions: SubscriptionsSubscriptionsRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.Suppliers.Suppliers: SuppliersSuppliersRobaws.TimeRegistrations.TimeRegistrations: Time RegistrationsTimeRegistrationsRobaws.Employees.EmployeesERobaws.Clients.ClientsLRobaws.VatTariffs.VatTariffs: VAT TariffsVatTariffsRobaws.StockLocations.StockLocations: Stock LocationsStockLocationsStockRobaws.WorkOrders.WorkOrders: Work OrdersWorkOrdersWorkRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.Users.UsersUStock×2×2×2Robaws.Materials.Materials: MaterialsMaterialsRobaws.Companies.CompaniesCRobaws.Employees.EmployeesERobaws.Clients.ClientsLRobaws.PlaceTransports.PlaceTransports: Place TransportsPlaceTransportsRobaws.SettlementLineItems.SettlementLineItems: Settlement Line ItemsSettlementLineItemsRobaws.Settlements.Settlements: SettlementsSettlementsRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.StockChanges.StockChanges: Stock ChangesStockChangesRobaws.Employees.EmployeesERobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.Users.UsersURobaws.StockLocations.StockLocations: Stock LocationsStockLocationsRobaws.StockReservations.StockReservations: Stock ReservationsStockReservationsRobaws.Transports.Transports: TransportsTransportsRobaws.Employees.EmployeesERobaws.Clients.ClientsLRobaws.Contacts.Contacts: ContactsContactsSale · ContactsRobaws.DeliveryNotes.DeliveryNotes: Delivery NotesDeliveryNotesSale · ContactsRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.Projects.Projects: ProjectsProjectsSale · ContactsRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.Users.UsersURobaws.Suppliers.Suppliers: SuppliersSuppliersSale · ContactsRobaws.VatTariffs.VatTariffs: VAT TariffsVatTariffsSale · ContactsRobaws.WorkOrders.WorkOrders: Work OrdersWorkOrdersWorkRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.Users.UsersUSale · Users×2Robaws.Clients.Clients: CustomersClientsRobaws.Companies.Companies: CompaniesCompaniesRobaws.PriceGroups.PriceGroups: PricegroupsPriceGroupsRobaws.Tasks.Tasks: TasksTasksRobaws.Users.Users: UsersUsersRobaws.LegalForms.LegalForms: Legal FormsLegalFormsSale · ContactsRobaws.PaymentConditions.PaymentConditions: Payment ConditionsPaymentConditionsSale · ContactsRobaws.VatTariffs.VatTariffs: VAT TariffsVatTariffsSale · ContactsSale · ExecutionPhases×2Robaws.Absences.Absences: AbsencesAbsencesRobaws.Employees.EmployeesERobaws.ExecutionPhases.ExecutionPhases: Execution PhasesExecutionPhasesRobaws.PlanningItems.PlanningItems: Planning ItemsPlanningItemsRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.PlanningTypes.PlanningTypes: Planning TypesPlanningTypesRobaws.Contacts.Contacts: ContactsContactsSale · ContactsRobaws.HourTypes.HourTypes: Hour TypesHourTypesWorkEmployeeRobaws.EmployeeCertificates.EmployeeCertificates: Employee CertificatesEmployeeCertificatesRobaws.EmployeeRole.EmployeeRoles: Employee RolesEmployeeRolesRobaws.Employees.Employees: EmployeesEmployeesRobaws.Companies.CompaniesCRobaws.StockLocations.StockLocations: Stock LocationsStockLocationsStockRobaws.Suppliers.Suppliers: SuppliersSuppliersSale · ContactsWorkRobaws.HourTypes.HourTypes: Hour TypesHourTypesRobaws.WorkOrderCommuteEntries.WorkOrderCommuteEntries: Work Order Commute EntriesWorkOrderCommuteEntriesRobaws.Employees.EmployeesERobaws.WorkOrderLineItems.WorkOrderLineItems: Work Order Line ItemsWorkOrderLineItemsRobaws.WorkOrderMaterialEntries.WorkOrderMaterialEntries: Work Order Material EntriesWorkOrderMaterialEntriesRobaws.WorkOrderTimeEntries.WorkOrderTimeEntries: Work Order Time EntriesWorkOrderTimeEntriesRobaws.Employees.EmployeesERobaws.WorkOrders.WorkOrders: Work OrdersWorkOrdersRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.Users.UsersURobaws.Materials.Materials: MaterialsMaterialsStockRobaws.Companies.CompaniesCRobaws.Employees.EmployeesERobaws.Clients.ClientsLNATIVEPLATFORMSCALARREQUESTSRobaws.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSTenantRobaws.Tenants.Tenants: TenantsTenantsWebhookRobaws.Webhooks.WebhookEndpoints: Webhook EndpointsWebhookEndpointsRobawsData 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.TopicsEmployee1Sale · Contacts1Sale · ExecutionPhases1Sale · Users1Stock1Work1Tables 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 relations between the same tablesLetters: refers to a table used by most topics: C = Companies, L = Clients, E = Employees, S =SalesOrders, U = UsersGenerated from the metadata of Invantive UniversalSQL 27.1.33-BETA+6408 on 03-11-2026. Every table links toits page with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/robaws
The poster as text: tables per topic and their relations

Sale · Contacts

Activities, ArticleGroups, ArticleSuppliers, ClaimStateLineItems, ClaimStates, Contacts, DeliveryNotes, Installations, LegalForms, Offers, PaymentConditions, Posts, ProjectConstructionPartners, Projects, PurchaseInvoices, SalesInvoiceLineItems, SalesInvoices, SalesOrders, SubscriptionLineItems, Subscriptions, Suppliers, TimeRegistrations, VatTariffs

Stock

Materials, PlaceTransports, SettlementLineItems, Settlements, StockChanges, StockLocations, StockReservations, Transports

Work

HourTypes, WorkOrderCommuteEntries, WorkOrderLineItems, WorkOrderMaterialEntries, WorkOrderTimeEntries, WorkOrders

Sale · Users

Clients, Companies, PriceGroups, Tasks, Users

Sale · ExecutionPhases

Absences, ExecutionPhases, PlanningItems, PlanningTypes

Employee

EmployeeCertificates, EmployeeRoles, Employees

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Tenant (without relations)

Tenants

Webhook (without relations)

WebhookEndpoints

Relations

Tables

Robaws.Absences

Robaws.Activities

Robaws.ApprovalRequestRules

Robaws.ApprovalRequests

Robaws.ArticleAdditionalItems

Robaws.ArticleGroups

Robaws.ArticleSuppliers

Robaws.ArticleTierPrices

Robaws.Articles

Robaws.BankPayments

Robaws.BudgetAdjustments

Robaws.CallOffSupplyOrderLineItems

Robaws.CallOffSupplyOrders

Robaws.CashEntries

Robaws.CashRegisterClosings

Robaws.CashRegisters

Robaws.ClaimStateLineItems

Robaws.ClaimStates

Robaws.Clients

Robaws.Companies

Robaws.Contacts

Robaws.DayPlanningResources

Robaws.DeliveryNoteLineItems

Robaws.DeliveryNotes

Robaws.EmployeeCertificates

Robaws.EmployeeRole

Robaws.Employees

Robaws.ExecutionPhases

Robaws.ExtraFields

Robaws.FormAnswers

Robaws.FormElementAnswersFromFormAnswer

Robaws.FormTemplates

Robaws.GeneralLedgerAccounts

Robaws.HourTypes

Robaws.ImportJobs

Robaws.Inboxes

Robaws.InstallationCertificates

Robaws.Installations

Robaws.InternalSupplyOrderLineItems

Robaws.InternalSupplyOrders

Robaws.Journals

Robaws.LegalForms

Robaws.MaintenanceSchedules

Robaws.MaterialCertificates

Robaws.Materials

Robaws.MobilityTypes

Robaws.Native

Robaws.Notifications

Robaws.OfferCalculationLineItems

Robaws.OfferLineItemParameters

Robaws.OfferLineItems

Robaws.OfferParameters

Robaws.OfferPhases

Robaws.Offers

Robaws.PaymentConditions

Robaws.PlaceTransports

Robaws.PlanningItemLineItems

Robaws.PlanningItems

Robaws.PlanningTypes

Robaws.PostCalculationLineItems

Robaws.PostParameters

Robaws.Posts

Robaws.PriceGroups

Robaws.PriceRequestLineItems

Robaws.PriceRequests

Robaws.ProjectConstructionPartners

Robaws.ProjectPhases

Robaws.ProjectSupplyRoutes

Robaws.Projects

Robaws.PurchaseInvoiceLineItems

Robaws.PurchaseInvoices

Robaws.PurchaseSupplyOrderLineItems

Robaws.PurchaseSupplyOrders

Robaws.RecurrenceTypes

Robaws.RentalSupplyOrderLineItems

Robaws.RentalTariffExtraServiceOverrides

Robaws.RentalTariffExtraServices

Robaws.RentalTariffTiers

Robaws.RentalTariffs

Robaws.RentalTicketLineItems

Robaws.RentalTickets

Robaws.ResourceTypeMetadata

Robaws.SalesInvoiceLineItems

Robaws.SalesInvoices

Robaws.SalesOrderLineItems

Robaws.SalesOrders

Robaws.ScheduledMaintenances

Robaws.SettlementCalculationLineItems

Robaws.SettlementLineItemParameters

Robaws.SettlementLineItems

Robaws.SettlementParameters

Robaws.SettlementPhases

Robaws.Settlements

Robaws.StockChangeLineItems

Robaws.StockChangeMaterialItems

Robaws.StockChanges

Robaws.StockLocations

Robaws.StockReservations

Robaws.SubcontractorSupplyOrderLineItems

Robaws.SubcontractorSupplyOrders

Robaws.SubscriptionLineItems

Robaws.Subscriptions

Robaws.SupplierPriceRequests

Robaws.Suppliers

Robaws.SupplyOrders

Robaws.Tasks

Robaws.Tenants

Robaws.TimeOffCategories

Robaws.TimeOffRequests

Robaws.TimeRegistrations

Robaws.TransportSupplyOrderLineItems

Robaws.TransportSupplyOrders

Robaws.Transports

Robaws.Users

Robaws.VatTariffs

Robaws.Webhooks

Robaws.WeeklySchedules

Robaws.WhoAmI

Robaws.WorkOrderCommuteEntries

Robaws.WorkOrderLineItems

Robaws.WorkOrderMaterialEntries

Robaws.WorkOrderTimeEntries

Robaws.WorkOrders

Sample Queries

select art.articleNumber
,      art.name
,      art.availableStock
,      art.minimumStock
from   Robaws.Articles.Articles art
where  art.stockArticle = true
and    art.availableStock < art.minimumStock
select cnt.address_city city
,      count(*) client_count
from   Robaws.Clients.Clients cnt
group
by     cnt.address_city
select inv.logicId
,      inv.date
,      inv.expireDate
,      inv.openTotal
,      cnt.name client_name
from   Robaws.SalesInvoices.SalesInvoices inv
join   Robaws.Clients.Clients cnt
on     cnt.id = inv.clientId
where  inv.openTotal > 0
select prj.logicId
,      prj.date
,      prj.siteAddress_city site_city
,      cnt.name client_name
from   Robaws.Projects.Projects prj
join   Robaws.Clients.Clients cnt
on     cnt.id = prj.clientId
where  prj.archivedAt is null

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: