invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Robaws Data Model

Boekhoudsoftware voor bouwbedrijven en projectmatigwerkende bedrijven.

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/robaws

De gegevens zijn gepartitioneerd per partitie (COMPANY_CODE).

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.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • Invantive Cloud-abonnementen: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status van het platform: https://status.robaws.be/nl/.
  • Taal van de gebruikersgemeenschap: Nederlands.

Cijfers

Figure Count
Tables 127
Columns 3,097
Tabeller med invoegsel 69
Tabeller med update 64
Tabellen met de functie 'verwijderen' 68
Tabeller gedocumenteerd 3

Poster met datamodel

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Robaws datamodel, Pagina 1 van 1Robaws datamodelvoor gebruik met Invantive UniversalSQLRelease 27.1.33-BETA+6408 · 03-11-2026Sale · Contacts · Voorraad · Sale · Users · Sale · ExecutionPhases · Medewerker · WorkPagina 1 van 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 LocationsStockLocationsVoorraadRobaws.WorkOrders.WorkOrders: Work OrdersWorkOrdersWorkRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.Users.UsersUVoorraad×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 TypesHourTypesWorkMedewerkerRobaws.EmployeeCertificates.EmployeeCertificates: Employee CertificatesEmployeeCertificatesRobaws.EmployeeRole.EmployeeRoles: Employee RolesEmployeeRolesRobaws.Employees.Employees: EmployeesEmployeesRobaws.Companies.CompaniesCRobaws.StockLocations.StockLocations: Stock LocationsStockLocationsVoorraadRobaws.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: MaterialsMaterialsVoorraadRobaws.Companies.CompaniesCRobaws.Employees.EmployeesERobaws.Clients.ClientsLNATIVEPLATFORMSCALARREQUESTSRobaws.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSTenantRobaws.Tenants.Tenants: TenantsTenantsWebhookRobaws.Webhooks.WebhookEndpoints: Webhook EndpointsWebhookEndpointsRobawsDatadictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenMedewerker1Sale · Contacts1Sale · ExecutionPhases1Sale · Users1Voorraad1Work1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten×n: n relations between the same tablesBrieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: C = Companies, L =Clients, E = Employees, S = SalesOrders, U = UsersGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.33-BETA+6408 op 03-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/robaws
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

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

Voorraad

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

Medewerker

EmployeeCertificates, EmployeeRoles, Employees

NATIVEPLATFORMSCALARREQUESTS (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Tenant (zonder relaties)

Tenants

Webhook (zonder relaties)

WebhookEndpoints

Relaties

Tabellen

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

Voorbeeldqueries

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

Attributen

De kenmerken van dit platform staan op de pagina Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: