---
title: "Robaws Data Model"
description: "Accounting software for construction and project-based companies."
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/robaws
original: https://documentation.invantive.eu/en/datamodels/robaws
updated: 2026-11-18T23:43:16Z
license: https://documentation.invantive.eu/nl/
---

# 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/](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 |

## Tabellen

### Robaws.Absences

- [Absences](Robaws.Absences.Absences): Afwezigheden

### Robaws.Activities

- [Activities](Robaws.Activities.Activities): Activities

### Robaws.ApprovalRequestRules

- [ApprovalRequestRules](Robaws.ApprovalRequestRules.ApprovalRequestRules): Goedkeuringsaanvraagregels

### Robaws.ApprovalRequests

- [ApprovalRequests](Robaws.ApprovalRequests.ApprovalRequests): Goedkeuringsverzoeken

### Robaws.ArticleAdditionalItems

- [ArticleAdditionalItems](Robaws.ArticleAdditionalItems.ArticleAdditionalItems): Article Additional Items

### Robaws.ArticleGroups

- [ArticleGroups](Robaws.ArticleGroups.ArticleGroups): Artikelgroepen

### Robaws.ArticleSuppliers

- [ArticleSuppliers](Robaws.ArticleSuppliers.ArticleSuppliers): Artikelleveranciers

### Robaws.ArticleTierPrices

- [ArticleTierPrices](Robaws.ArticleTierPrices.ArticleTierPrices): Artikel staffelprijzen

### Robaws.Articles

- [ArticleStockMovements](Robaws.Articles.ArticleStockMovements): Artikelvoorraadbewegingen
- [Artikelen](Robaws.Articles.Articles): Artikelen

### Robaws.BankPayments

- [BankPayments](Robaws.BankPayments.BankPayments): Bankbetalingen

### Robaws.BudgetAdjustments

- [BudgetAdjustments](Robaws.BudgetAdjustments.BudgetAdjustments): Budget Adjustments

### Robaws.CallOffSupplyOrderLineItems

- [CallOffSupplyOrderLineItems](Robaws.CallOffSupplyOrderLineItems.CallOffSupplyOrderLineItems): Call-off-leveringsorderregels

### Robaws.CallOffSupplyOrders

- [CallOffSupplyOrders](Robaws.CallOffSupplyOrders.CallOffSupplyOrders): Call-off-leveringsorders

### Robaws.CashEntries

- [CashEntries](Robaws.CashEntries.CashEntries): Kasmutaties

### Robaws.CashRegisterClosings

- [CashRegisterClosings](Robaws.CashRegisterClosings.CashRegisterClosings): Kassasluitingen

### Robaws.CashRegisters

- [CashRegisters](Robaws.CashRegisters.CashRegisters): Kassaregisters

### Robaws.ClaimStateLineItems

- [ClaimStateLineItems](Robaws.ClaimStateLineItems.ClaimStateLineItems): Claimstatusregels

### Robaws.ClaimStates

- [ClaimStates](Robaws.ClaimStates.ClaimStates): Claimstatussen

### Robaws.Clients

- [Klanten](Robaws.Clients.Clients): Klanten

### Robaws.Companies

- [Bedrijven](Robaws.Companies.Companies): Bedrijven

### Robaws.Contacts

- [Contacten](Robaws.Contacts.Contacts): Contacten

### Robaws.DayPlanningResources

- [DayPlanningResources](Robaws.DayPlanningResources.DayPlanningResources): Dagplanningsresources

### Robaws.DeliveryNoteLineItems

- [DeliveryNoteLineItems](Robaws.DeliveryNoteLineItems.DeliveryNoteLineItems): Leveringsbonregels

### Robaws.DeliveryNotes

- [DeliveryNotes](Robaws.DeliveryNotes.DeliveryNotes): Leveringsbonnen

### Robaws.EmployeeCertificates

- [EmployeeCertificates](Robaws.EmployeeCertificates.EmployeeCertificates): Medewerkerscertificaten

### Robaws.EmployeeRole

- [EmployeeRoles](Robaws.EmployeeRole.EmployeeRoles): Medewerkersrollen

### Robaws.Employees

- [Medewerkers](Robaws.Employees.Employees): Medewerkers

### Robaws.ExecutionPhases

- [ExecutionPhases](Robaws.ExecutionPhases.ExecutionPhases): Execution Phases

### Robaws.ExtraFields

- [ResourceTypeExtraFields](Robaws.ExtraFields.ResourceTypeExtraFields): Extra velden resourcetype

### Robaws.FormAnswers

- [FormAnswers](Robaws.FormAnswers.FormAnswers): Formulierantwoorden

### Robaws.FormElementAnswersFromFormAnswer

- [FormAnswerFormElementAnswers](Robaws.FormElementAnswersFromFormAnswer.FormAnswerFormElementAnswers): Formulierantwoord-formulierelementantwoorden

### Robaws.FormTemplates

- [FormTemplateRevisions](Robaws.FormTemplates.FormTemplateRevisions): Formuliersjabloonrevisies
- [FormTemplates](Robaws.FormTemplates.FormTemplates): Formuliersjablonen

### Robaws.GeneralLedgerAccounts

- [GeneralLedgerAccounts](Robaws.GeneralLedgerAccounts.GeneralLedgerAccounts): Grootboekrekeningen

### Robaws.HourTypes

- [HourTypes](Robaws.HourTypes.HourTypes): Uurtypen

### Robaws.ImportJobs

- [ImportJobMessages](Robaws.ImportJobs.ImportJobMessages): Importtaakberichten
- [ImportJobs](Robaws.ImportJobs.ImportJobs): Importtaken

### Robaws.Inboxes

- [Inboxen](Robaws.Inboxes.Inboxes): Inboxen

### Robaws.InstallationCertificates

- [InstallationCertificates](Robaws.InstallationCertificates.InstallationCertificates): Installatiecertificaten

### Robaws.Installations

- [Installaties](Robaws.Installations.Installations): Installaties

### Robaws.InternalSupplyOrderLineItems

- [InternalSupplyOrderLineItems](Robaws.InternalSupplyOrderLineItems.InternalSupplyOrderLineItems): Interne leveringsorderregels

### Robaws.InternalSupplyOrders

- [InternalSupplyOrders](Robaws.InternalSupplyOrders.InternalSupplyOrders): Internal Supply Orders

### Robaws.Journals

- [Journals](Robaws.Journals.Journals): Journalen

### Robaws.LegalForms

- [LegalForms](Robaws.LegalForms.LegalForms): Rechtsvormen

### Robaws.MaintenanceSchedules

- [MaintenanceSchedules](Robaws.MaintenanceSchedules.MaintenanceSchedules): Onderhoudsschema's

### Robaws.MaterialCertificates

- [MaterialCertificates](Robaws.MaterialCertificates.MaterialCertificates): Materiaalcertificaten

### Robaws.Materials

- [Materials](Robaws.Materials.Materials): Materialen

### Robaws.MobilityTypes

- [MobilityTypes](Robaws.MobilityTypes.MobilityTypes): Mobility Types

### Robaws.Native

- [NATIVEPLATFORMSCALARREQUESTS](Robaws.Native.NATIVEPLATFORMSCALARREQUESTS): Scalaire verzoeken op het native platform

### Robaws.Notifications

- [Notifications](Robaws.Notifications.Notifications): Meldingen

### Robaws.OfferCalculationLineItems

- [OfferCalculationLineItems](Robaws.OfferCalculationLineItems.OfferCalculationLineItems): Offerteberekeningsregels

### Robaws.OfferLineItemParameters

- [OfferLineItemParameters](Robaws.OfferLineItemParameters.OfferLineItemParameters): Offer Line Item Parameters

### Robaws.OfferLineItems

- [OfferLineItems](Robaws.OfferLineItems.OfferLineItems): Offer Line Items

### Robaws.OfferParameters

- [OfferParameters](Robaws.OfferParameters.OfferParameters): Offerteparameters

### Robaws.OfferPhases

- [OfferPhases](Robaws.OfferPhases.OfferPhases): Offertefases

### Robaws.Offers

- [Offers](Robaws.Offers.Offers): Offertes

### Robaws.PaymentConditions

- [PaymentConditions](Robaws.PaymentConditions.PaymentConditions): Betalingsvoorwaarden

### Robaws.PlaceTransports

- [PlaceTransports](Robaws.PlaceTransports.PlaceTransports): Plaatstransporten

### Robaws.PlanningItemLineItems

- [PlanningItemLineItems](Robaws.PlanningItemLineItems.PlanningItemLineItems): Planningsitemregels

### Robaws.PlanningItems

- [PlanningItems](Robaws.PlanningItems.PlanningItems): Planningsitems

### Robaws.PlanningTypes

- [PlanningTypes](Robaws.PlanningTypes.PlanningTypes): Planningstypen

### Robaws.PostCalculationLineItems

- [PostCalculationLineItems](Robaws.PostCalculationLineItems.PostCalculationLineItems): Nacalculatieregels

### Robaws.PostParameters

- [PostParameters](Robaws.PostParameters.PostParameters): Post Parameters

### Robaws.Posts

- [Posts](Robaws.Posts.Posts): Berichten

### Robaws.PriceGroups

- [PriceGroups](Robaws.PriceGroups.PriceGroups): Pricegroups

### Robaws.PriceRequestLineItems

- [PriceRequestLineItems](Robaws.PriceRequestLineItems.PriceRequestLineItems): Prijsaanvraagregels

### Robaws.PriceRequests

- [PriceRequests](Robaws.PriceRequests.PriceRequests): Prijsaanvragen

### Robaws.ProjectConstructionPartners

- [ProjectConstructionPartners](Robaws.ProjectConstructionPartners.ProjectConstructionPartners): Projectbouwpartners

### Robaws.ProjectPhases

- [ProjectPhases](Robaws.ProjectPhases.ProjectPhases): Projectfasen

### Robaws.ProjectSupplyRoutes

- [ProjectSupplyRoutes](Robaws.ProjectSupplyRoutes.ProjectSupplyRoutes): Projectleveringsroutes

### Robaws.Projects

- [Projecten](Robaws.Projects.Projects): Projecten

### Robaws.PurchaseInvoiceLineItems

- [PurchaseInvoiceLineItems](Robaws.PurchaseInvoiceLineItems.PurchaseInvoiceLineItems): Inkoopfactuurregels

### Robaws.PurchaseInvoices

- [PurchaseInvoices](Robaws.PurchaseInvoices.PurchaseInvoices): Inkoopfacturen

### Robaws.PurchaseSupplyOrderLineItems

- [PurchaseSupplyOrderLineItems](Robaws.PurchaseSupplyOrderLineItems.PurchaseSupplyOrderLineItems): Inkoopleveringsorderregels

### Robaws.PurchaseSupplyOrders

- [PurchaseSupplyOrders](Robaws.PurchaseSupplyOrders.PurchaseSupplyOrders): Inkoopleveringsorders

### Robaws.RecurrenceTypes

- [RecurrenceTypes](Robaws.RecurrenceTypes.RecurrenceTypes): Herhalingstypen

### Robaws.RentalSupplyOrderLineItems

- [RentalSupplyOrderLineItems](Robaws.RentalSupplyOrderLineItems.RentalSupplyOrderLineItems): Huurleveringsorderregels

### Robaws.RentalTariffExtraServiceOverrides

- [RentalTariffExtraServiceOverrides](Robaws.RentalTariffExtraServiceOverrides.RentalTariffExtraServiceOverrides): Huurtariefextraservice-overrides

### Robaws.RentalTariffExtraServices

- [RentalTariffExtraServices](Robaws.RentalTariffExtraServices.RentalTariffExtraServices): Huurtariefextraservices

### Robaws.RentalTariffTiers

- [RentalTariffTiers](Robaws.RentalTariffTiers.RentalTariffTiers): Huurtariefschijven

### Robaws.RentalTariffs

- [RentalTariffs](Robaws.RentalTariffs.RentalTariffs): Rental Tariffs

### Robaws.RentalTicketLineItems

- [RentalTicketLineItems](Robaws.RentalTicketLineItems.RentalTicketLineItems): Huurticketregels

### Robaws.RentalTickets

- [RentalTickets](Robaws.RentalTickets.RentalTickets): Huurtickets

### Robaws.ResourceTypeMetadata

- [ResourceTypes](Robaws.ResourceTypeMetadata.ResourceTypes): Resourcetypen

### Robaws.SalesInvoiceLineItems

- [SalesInvoiceLineItems](Robaws.SalesInvoiceLineItems.SalesInvoiceLineItems): Sales Invoice Line Items

### Robaws.SalesInvoices

- [SalesInvoices](Robaws.SalesInvoices.SalesInvoices): Verkoopfacturen

### Robaws.SalesOrderLineItems

- [SalesOrderLineItems](Robaws.SalesOrderLineItems.SalesOrderLineItems): Sales Order Line Items

### Robaws.SalesOrders

- [SalesOrders](Robaws.SalesOrders.SalesOrders): Verkooporders

### Robaws.ScheduledMaintenances

- [ScheduledMaintenances](Robaws.ScheduledMaintenances.ScheduledMaintenances): Geplande onderhoudsbeurten

### Robaws.SettlementCalculationLineItems

- [SettlementCalculationLineItems](Robaws.SettlementCalculationLineItems.SettlementCalculationLineItems): Afrekeningsberekeningsregels

### Robaws.SettlementLineItemParameters

- [SettlementLineItemParameters](Robaws.SettlementLineItemParameters.SettlementLineItemParameters): Settlement Line Item Parameters

### Robaws.SettlementLineItems

- [SettlementLineItems](Robaws.SettlementLineItems.SettlementLineItems): Settlement Line Items

### Robaws.SettlementParameters

- [SettlementParameters](Robaws.SettlementParameters.SettlementParameters): Afrekeningsparameters

### Robaws.SettlementPhases

- [SettlementPhases](Robaws.SettlementPhases.SettlementPhases): Afrekeningsfasen

### Robaws.Settlements

- [Afrekeningen](Robaws.Settlements.Settlements): Afrekeningen

### Robaws.StockChangeLineItems

- [StockChangeLineItems](Robaws.StockChangeLineItems.StockChangeLineItems): Voorraadmutatieregels

### Robaws.StockChangeMaterialItems

- [StockChangeMaterialItems](Robaws.StockChangeMaterialItems.StockChangeMaterialItems): Voorraadmutatie-materiaalitems

### Robaws.StockChanges

- [StockChangeFromSupplyOrder](Robaws.StockChanges.StockChangeFromSupplyOrder): Voorraadmutaties uit leveringsorder
- [StockChanges](Robaws.StockChanges.StockChanges): Voorraadmutaties

### Robaws.StockLocations

- [StockLocations](Robaws.StockLocations.StockLocations): Voorraadlocaties

### Robaws.StockReservations

- [StockReservations](Robaws.StockReservations.StockReservations): Voorraadreserveringen

### Robaws.SubcontractorSupplyOrderLineItems

- [SubcontractorSupplyOrderLineItems](Robaws.SubcontractorSupplyOrderLineItems.SubcontractorSupplyOrderLineItems): Subcontractor Supply Order Line Items

### Robaws.SubcontractorSupplyOrders

- [SubcontractorSupplyOrders](Robaws.SubcontractorSupplyOrders.SubcontractorSupplyOrders): Onderaannemer-leveringsorders

### Robaws.SubscriptionLineItems

- [SubscriptionLineItems](Robaws.SubscriptionLineItems.SubscriptionLineItems): Abonnementsregels

### Robaws.Subscriptions

- [Subscriptions](Robaws.Subscriptions.Subscriptions): Abonnementen

### Robaws.SupplierPriceRequests

- [SupplierPriceRequests](Robaws.SupplierPriceRequests.SupplierPriceRequests): Leveranciersprijsaanvragen

### Robaws.Suppliers

- [Suppliers](Robaws.Suppliers.Suppliers): Leveranciers

### Robaws.SupplyOrders

- [SupplyOrders](Robaws.SupplyOrders.SupplyOrders): Supply Orders

### Robaws.Tasks

- [Taken](Robaws.Tasks.Tasks): Taken

### Robaws.Tenants

- [Huurders](Robaws.Tenants.Tenants): Huurders

### Robaws.TimeOffCategories

- [TimeOffCategories](Robaws.TimeOffCategories.TimeOffCategories): Time Off Categories

### Robaws.TimeOffRequests

- [TimeOffRequests](Robaws.TimeOffRequests.TimeOffRequests): Verlofaanvragen

### Robaws.TimeRegistrations

- [TimeRegistrations](Robaws.TimeRegistrations.TimeRegistrations): Tijdregistraties

### Robaws.TransportSupplyOrderLineItems

- [TransportSupplyOrderLineItems](Robaws.TransportSupplyOrderLineItems.TransportSupplyOrderLineItems): Transportleveringsorderregels

### Robaws.TransportSupplyOrders

- [TransportSupplyOrders](Robaws.TransportSupplyOrders.TransportSupplyOrders): Transportleveringsorders

### Robaws.Transports

- [Transporten](Robaws.Transports.Transports): Transporten

### Robaws.Users

- [Users](Robaws.Users.Users): Gebruikers

### Robaws.VatTariffs

- [VatTariffs](Robaws.VatTariffs.VatTariffs): BTW-tarieven

### Robaws.Webhooks

- [WebhookEndpoints](Robaws.Webhooks.WebhookEndpoints): Webhook-eindpunten

### Robaws.WeeklySchedules

- [WeeklySchedules](Robaws.WeeklySchedules.WeeklySchedules): Wekelijkse planningen

### Robaws.WhoAmI

- [Whoami](Robaws.WhoAmI.Whoami): Wie ben ik

### Robaws.WorkOrderCommuteEntries

- [WorkOrderCommuteEntries](Robaws.WorkOrderCommuteEntries.WorkOrderCommuteEntries): Work Order Commute Entries

### Robaws.WorkOrderLineItems

- [WorkOrderLineItems](Robaws.WorkOrderLineItems.WorkOrderLineItems): Work Order Line Items

### Robaws.WorkOrderMaterialEntries

- [WorkOrderMaterialEntries](Robaws.WorkOrderMaterialEntries.WorkOrderMaterialEntries): Werkorder-materiaalregistraties

### Robaws.WorkOrderTimeEntries

- [WorkOrderTimeEntries](Robaws.WorkOrderTimeEntries.WorkOrderTimeEntries): Werkorder-tijdregistraties

### Robaws.WorkOrders

- [WorkOrders](Robaws.WorkOrders.WorkOrders): Work Orders

## Voorbeeldqueries

```sql
select art.articleNumber
,      art.name
,      art.availableStock
,      art.minimumStock
from   Robaws.Articles.Articles art
where  art.stockArticle = true
and    art.availableStock < art.minimumStock
```

```sql
select cnt.address_city city
,      count(*) client_count
from   Robaws.Clients.Clients cnt
group
by     cnt.address_city
```

```sql
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
```

```sql
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](attributes).


## Release Notes

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

- [ROBAWS](/nl/release-notes/drivers?driver=robaws)
