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

# Robaws Data Model

Software de contabilidad para empresas de construcción y basadas en proyectos.

Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/robaws

The data is partitioned per partition (`COMPANY_CODE`).

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

## Plataforma

- Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
- Tipo: una aplicación a la que se accede a través de su API.
- Los datos se agrupan por categorías, como por empresa o por administración.
- Los datos se pueden leer y escribir.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Estado de la plataforma: [https://status.robaws.be/nl/](https://status.robaws.be/nl/).
- Language of its user community: Dutch.

## Cifras

| Figure | Count |
|---|---:|
| Tables | 127 |
| Columns | 3,097 |
| Tablas con inserciones | 69 |
| Tablas con actualización | 64 |
| Tablas con la instrucción «DELETE» | 68 |
| Tablas documentadas | 3 |

## Tablas

### Robaws.Absences

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

### Robaws.Activities

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

### Robaws.ApprovalRequestRules

- [ApprovalRequestRules](Robaws.ApprovalRequestRules.ApprovalRequestRules): Approval Request Rules

### Robaws.ApprovalRequests

- [ApprovalRequests](Robaws.ApprovalRequests.ApprovalRequests): Approval Requests

### Robaws.ArticleAdditionalItems

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

### Robaws.ArticleGroups

- [ArticleGroups](Robaws.ArticleGroups.ArticleGroups): Article Groups

### Robaws.ArticleSuppliers

- [ArticleSuppliers](Robaws.ArticleSuppliers.ArticleSuppliers): Article Suppliers

### Robaws.ArticleTierPrices

- [ArticleTierPrices](Robaws.ArticleTierPrices.ArticleTierPrices): Article Tier Prices

### Robaws.Articles

- [ArticleStockMovements](Robaws.Articles.ArticleStockMovements): Article Stock Movements
- [Articles](Robaws.Articles.Articles): Articles

### Robaws.BankPayments

- [BankPayments](Robaws.BankPayments.BankPayments): Bank Payments

### Robaws.BudgetAdjustments

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

### Robaws.CallOffSupplyOrderLineItems

- [CallOffSupplyOrderLineItems](Robaws.CallOffSupplyOrderLineItems.CallOffSupplyOrderLineItems): Call-Off Supply Order Line Items

### Robaws.CallOffSupplyOrders

- [CallOffSupplyOrders](Robaws.CallOffSupplyOrders.CallOffSupplyOrders): Call-Off Supply Orders

### Robaws.CashEntries

- [CashEntries](Robaws.CashEntries.CashEntries): Cash Entries

### Robaws.CashRegisterClosings

- [CashRegisterClosings](Robaws.CashRegisterClosings.CashRegisterClosings): Cash Register Closings

### Robaws.CashRegisters

- [CashRegisters](Robaws.CashRegisters.CashRegisters): Cash Registers

### Robaws.ClaimStateLineItems

- [ClaimStateLineItems](Robaws.ClaimStateLineItems.ClaimStateLineItems): Claim State Line Items

### Robaws.ClaimStates

- [ClaimStates](Robaws.ClaimStates.ClaimStates): Claim States

### Robaws.Clients

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

### Robaws.Companies

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

### Robaws.Contacts

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

### Robaws.DayPlanningResources

- [DayPlanningResources](Robaws.DayPlanningResources.DayPlanningResources): Day Planning Resources

### Robaws.DeliveryNoteLineItems

- [DeliveryNoteLineItems](Robaws.DeliveryNoteLineItems.DeliveryNoteLineItems): Delivery Note Line Items

### Robaws.DeliveryNotes

- [DeliveryNotes](Robaws.DeliveryNotes.DeliveryNotes): Delivery Notes

### Robaws.EmployeeCertificates

- [EmployeeCertificates](Robaws.EmployeeCertificates.EmployeeCertificates): Employee Certificates

### Robaws.EmployeeRole

- [EmployeeRoles](Robaws.EmployeeRole.EmployeeRoles): Employee Roles

### Robaws.Employees

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

### Robaws.ExecutionPhases

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

### Robaws.ExtraFields

- [ResourceTypeExtraFields](Robaws.ExtraFields.ResourceTypeExtraFields): Resource Type Extra Fields

### Robaws.FormAnswers

- [FormAnswers](Robaws.FormAnswers.FormAnswers): Form Answers

### Robaws.FormElementAnswersFromFormAnswer

- [FormAnswerFormElementAnswers](Robaws.FormElementAnswersFromFormAnswer.FormAnswerFormElementAnswers): Form Answer Form Element Answers

### Robaws.FormTemplates

- [FormTemplateRevisions](Robaws.FormTemplates.FormTemplateRevisions): Form Template Revisions
- [FormTemplates](Robaws.FormTemplates.FormTemplates): Form Templates

### Robaws.GeneralLedgerAccounts

- [GeneralLedgerAccounts](Robaws.GeneralLedgerAccounts.GeneralLedgerAccounts): General Ledger Accounts

### Robaws.HourTypes

- [HourTypes](Robaws.HourTypes.HourTypes): Hour Types

### Robaws.ImportJobs

- [ImportJobMessages](Robaws.ImportJobs.ImportJobMessages): Import Job Messages
- [ImportJobs](Robaws.ImportJobs.ImportJobs): Import Jobs

### Robaws.Inboxes

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

### Robaws.InstallationCertificates

- [InstallationCertificates](Robaws.InstallationCertificates.InstallationCertificates): Installation Certificates

### Robaws.Installations

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

### Robaws.InternalSupplyOrderLineItems

- [InternalSupplyOrderLineItems](Robaws.InternalSupplyOrderLineItems.InternalSupplyOrderLineItems): Internal Supply Order Line Items

### Robaws.InternalSupplyOrders

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

### Robaws.Journals

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

### Robaws.LegalForms

- [LegalForms](Robaws.LegalForms.LegalForms): Legal Forms

### Robaws.MaintenanceSchedules

- [MaintenanceSchedules](Robaws.MaintenanceSchedules.MaintenanceSchedules): Maintenance Schedules

### Robaws.MaterialCertificates

- [MaterialCertificates](Robaws.MaterialCertificates.MaterialCertificates): Material Certificates

### Robaws.Materials

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

### Robaws.MobilityTypes

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

### Robaws.Native

- [NATIVEPLATFORMSCALARREQUESTS](Robaws.Native.NATIVEPLATFORMSCALARREQUESTS): Solicitudes escalares de plataformas nativas

### Robaws.Notifications

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

### Robaws.OfferCalculationLineItems

- [OfferCalculationLineItems](Robaws.OfferCalculationLineItems.OfferCalculationLineItems): Offer Calculation Line Items

### 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): Offer Parameters

### Robaws.OfferPhases

- [OfferPhases](Robaws.OfferPhases.OfferPhases): Offer Phases

### Robaws.Offers

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

### Robaws.PaymentConditions

- [PaymentConditions](Robaws.PaymentConditions.PaymentConditions): Payment Conditions

### Robaws.PlaceTransports

- [PlaceTransports](Robaws.PlaceTransports.PlaceTransports): Place Transports

### Robaws.PlanningItemLineItems

- [PlanningItemLineItems](Robaws.PlanningItemLineItems.PlanningItemLineItems): Planning Item Line Items

### Robaws.PlanningItems

- [PlanningItems](Robaws.PlanningItems.PlanningItems): Planning Items

### Robaws.PlanningTypes

- [PlanningTypes](Robaws.PlanningTypes.PlanningTypes): Planning Types

### Robaws.PostCalculationLineItems

- [PostCalculationLineItems](Robaws.PostCalculationLineItems.PostCalculationLineItems): Post Calculation Line Items

### Robaws.PostParameters

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

### Robaws.Posts

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

### Robaws.PriceGroups

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

### Robaws.PriceRequestLineItems

- [PriceRequestLineItems](Robaws.PriceRequestLineItems.PriceRequestLineItems): Price Request Line Items

### Robaws.PriceRequests

- [PriceRequests](Robaws.PriceRequests.PriceRequests): Price Requests

### Robaws.ProjectConstructionPartners

- [ProjectConstructionPartners](Robaws.ProjectConstructionPartners.ProjectConstructionPartners): Project Construction Partners

### Robaws.ProjectPhases

- [ProjectPhases](Robaws.ProjectPhases.ProjectPhases): Project Phases

### Robaws.ProjectSupplyRoutes

- [ProjectSupplyRoutes](Robaws.ProjectSupplyRoutes.ProjectSupplyRoutes): Project Supply Routes

### Robaws.Projects

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

### Robaws.PurchaseInvoiceLineItems

- [PurchaseInvoiceLineItems](Robaws.PurchaseInvoiceLineItems.PurchaseInvoiceLineItems): Purchase Invoice Line Items

### Robaws.PurchaseInvoices

- [PurchaseInvoices](Robaws.PurchaseInvoices.PurchaseInvoices): Purchase Invoices

### Robaws.PurchaseSupplyOrderLineItems

- [PurchaseSupplyOrderLineItems](Robaws.PurchaseSupplyOrderLineItems.PurchaseSupplyOrderLineItems): Purchase Supply Order Line Items

### Robaws.PurchaseSupplyOrders

- [PurchaseSupplyOrders](Robaws.PurchaseSupplyOrders.PurchaseSupplyOrders): Purchase Supply Orders

### Robaws.RecurrenceTypes

- [RecurrenceTypes](Robaws.RecurrenceTypes.RecurrenceTypes): Recurrence Types

### Robaws.RentalSupplyOrderLineItems

- [RentalSupplyOrderLineItems](Robaws.RentalSupplyOrderLineItems.RentalSupplyOrderLineItems): Rental Supply Order Line Items

### Robaws.RentalTariffExtraServiceOverrides

- [RentalTariffExtraServiceOverrides](Robaws.RentalTariffExtraServiceOverrides.RentalTariffExtraServiceOverrides): Rental Tariff Extra Service Overrides

### Robaws.RentalTariffExtraServices

- [RentalTariffExtraServices](Robaws.RentalTariffExtraServices.RentalTariffExtraServices): Rental Tariff Extra Services

### Robaws.RentalTariffTiers

- [RentalTariffTiers](Robaws.RentalTariffTiers.RentalTariffTiers): Rental Tariff Tiers

### Robaws.RentalTariffs

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

### Robaws.RentalTicketLineItems

- [RentalTicketLineItems](Robaws.RentalTicketLineItems.RentalTicketLineItems): Rental Ticket Line Items

### Robaws.RentalTickets

- [RentalTickets](Robaws.RentalTickets.RentalTickets): Rental Tickets

### Robaws.ResourceTypeMetadata

- [ResourceTypes](Robaws.ResourceTypeMetadata.ResourceTypes): Resource Types

### Robaws.SalesInvoiceLineItems

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

### Robaws.SalesInvoices

- [SalesInvoices](Robaws.SalesInvoices.SalesInvoices): Sales Invoices

### Robaws.SalesOrderLineItems

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

### Robaws.SalesOrders

- [SalesOrders](Robaws.SalesOrders.SalesOrders): Sales Orders

### Robaws.ScheduledMaintenances

- [ScheduledMaintenances](Robaws.ScheduledMaintenances.ScheduledMaintenances): Scheduled Maintenances

### Robaws.SettlementCalculationLineItems

- [SettlementCalculationLineItems](Robaws.SettlementCalculationLineItems.SettlementCalculationLineItems): Settlement Calculation Line Items

### 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): Settlement Parameters

### Robaws.SettlementPhases

- [SettlementPhases](Robaws.SettlementPhases.SettlementPhases): Settlement Phases

### Robaws.Settlements

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

### Robaws.StockChangeLineItems

- [StockChangeLineItems](Robaws.StockChangeLineItems.StockChangeLineItems): Stock Change Line Items

### Robaws.StockChangeMaterialItems

- [StockChangeMaterialItems](Robaws.StockChangeMaterialItems.StockChangeMaterialItems): Stock Change Material Items

### Robaws.StockChanges

- [StockChangeFromSupplyOrder](Robaws.StockChanges.StockChangeFromSupplyOrder): Stock Changes From Supply Order
- [StockChanges](Robaws.StockChanges.StockChanges): Stock Changes

### Robaws.StockLocations

- [StockLocations](Robaws.StockLocations.StockLocations): Stock Locations

### Robaws.StockReservations

- [StockReservations](Robaws.StockReservations.StockReservations): Stock Reservations

### Robaws.SubcontractorSupplyOrderLineItems

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

### Robaws.SubcontractorSupplyOrders

- [SubcontractorSupplyOrders](Robaws.SubcontractorSupplyOrders.SubcontractorSupplyOrders): Subcontractor Supply Orders

### Robaws.SubscriptionLineItems

- [SubscriptionLineItems](Robaws.SubscriptionLineItems.SubscriptionLineItems): Subscription Line Items

### Robaws.Subscriptions

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

### Robaws.SupplierPriceRequests

- [SupplierPriceRequests](Robaws.SupplierPriceRequests.SupplierPriceRequests): Supplier Price Requests

### Robaws.Suppliers

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

### Robaws.SupplyOrders

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

### Robaws.Tasks

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

### Robaws.Tenants

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

### Robaws.TimeOffCategories

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

### Robaws.TimeOffRequests

- [TimeOffRequests](Robaws.TimeOffRequests.TimeOffRequests): Time Off Requests

### Robaws.TimeRegistrations

- [TimeRegistrations](Robaws.TimeRegistrations.TimeRegistrations): Time Registrations

### Robaws.TransportSupplyOrderLineItems

- [TransportSupplyOrderLineItems](Robaws.TransportSupplyOrderLineItems.TransportSupplyOrderLineItems): Transport Supply Order Line Items

### Robaws.TransportSupplyOrders

- [TransportSupplyOrders](Robaws.TransportSupplyOrders.TransportSupplyOrders): Transport Supply Orders

### Robaws.Transports

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

### Robaws.Users

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

### Robaws.VatTariffs

- [VatTariffs](Robaws.VatTariffs.VatTariffs): VAT Tariffs

### Robaws.Webhooks

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

### Robaws.WeeklySchedules

- [WeeklySchedules](Robaws.WeeklySchedules.WeeklySchedules): Weekly Schedules

### Robaws.WhoAmI

- [Whoami](Robaws.WhoAmI.Whoami): Who Am I

### 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): Work Order Material Entries

### Robaws.WorkOrderTimeEntries

- [WorkOrderTimeEntries](Robaws.WorkOrderTimeEntries.WorkOrderTimeEntries): Work Order Time Entries

### Robaws.WorkOrders

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

## Ejemplos de queries

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

## Atributos

Las características de esta plataforma se encuentran en la página [Attributes](attributes).


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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