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

# Modello Dati Robaws

Software di contabilità per aziende edili e basate su progetti.

Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/robaws

I dati sono partizionati per partizione (`COMPANY_CODE`).

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

## Piattaforma

- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria API.
- I dati sono suddivisi, ad esempio per azienda o per amministrazione.
- I dati possono essere sia letti che scritti.
- Piani Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Stato della piattaforma: [https://status.robaws.be/nl/](https://status.robaws.be/nl/).
- Lingua della sua comunità di utenti: olandese.

## Figure

| Figure | Count |
|---|---:|
| Tables | 127 |
| Columns | 3,097 |
| Tabella con inserti | 69 |
| Tabella con aggiornamento | 64 |
| Tabella con la clausola DELETE | 68 |
| Tabella documentata | 3 |

## Tabelle

### Robaws.Absences

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

### Robaws.Activities

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

### Robaws.ApprovalRequestRules

- [ApprovalRequestRules](Robaws.ApprovalRequestRules.ApprovalRequestRules): Regole delle richieste di approvazione

### Robaws.ApprovalRequests

- [ApprovalRequests](Robaws.ApprovalRequests.ApprovalRequests): Richieste di approvazione

### Robaws.ArticleAdditionalItems

- [ArticleAdditionalItems](Robaws.ArticleAdditionalItems.ArticleAdditionalItems): Articoli Aggiuntivi

### Robaws.ArticleGroups

- [ArticleGroups](Robaws.ArticleGroups.ArticleGroups): Gruppi di articoli

### Robaws.ArticleSuppliers

- [ArticleSuppliers](Robaws.ArticleSuppliers.ArticleSuppliers): Fornitori degli articoli

### Robaws.ArticleTierPrices

- [ArticleTierPrices](Robaws.ArticleTierPrices.ArticleTierPrices): Prezzi a scaglioni degli articoli

### Robaws.Articles

- [ArticleStockMovements](Robaws.Articles.ArticleStockMovements): Movimenti di magazzino articoli
- [Articles](Robaws.Articles.Articles): Articoli

### Robaws.BankPayments

- [BankPayments](Robaws.BankPayments.BankPayments): Pagamenti bancari

### Robaws.BudgetAdjustments

- [BudgetAdjustments](Robaws.BudgetAdjustments.BudgetAdjustments): Rettifiche di Budget

### Robaws.CallOffSupplyOrderLineItems

- [CallOffSupplyOrderLineItems](Robaws.CallOffSupplyOrderLineItems.CallOffSupplyOrderLineItems): Righe degli ordini di fornitura a chiamata

### Robaws.CallOffSupplyOrders

- [CallOffSupplyOrders](Robaws.CallOffSupplyOrders.CallOffSupplyOrders): Ordini di fornitura a chiamata

### Robaws.CashEntries

- [CashEntries](Robaws.CashEntries.CashEntries): Movimenti di cassa

### Robaws.CashRegisterClosings

- [CashRegisterClosings](Robaws.CashRegisterClosings.CashRegisterClosings): Chiusure di cassa

### Robaws.CashRegisters

- [CashRegisters](Robaws.CashRegisters.CashRegisters): Registratori di Cassa

### Robaws.ClaimStateLineItems

- [ClaimStateLineItems](Robaws.ClaimStateLineItems.ClaimStateLineItems): Righe Stati dei Reclami

### Robaws.ClaimStates

- [ClaimStates](Robaws.ClaimStates.ClaimStates): Stati dei Reclami

### Robaws.Clients

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

### Robaws.Companies

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

### Robaws.Contacts

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

### Robaws.DayPlanningResources

- [DayPlanningResources](Robaws.DayPlanningResources.DayPlanningResources): Risorse di Pianificazione Giornaliera

### Robaws.DeliveryNoteLineItems

- [DeliveryNoteLineItems](Robaws.DeliveryNoteLineItems.DeliveryNoteLineItems): Righe dei documenti di trasporto

### Robaws.DeliveryNotes

- [DeliveryNotes](Robaws.DeliveryNotes.DeliveryNotes): Documenti di trasporto

### Robaws.EmployeeCertificates

- [EmployeeCertificates](Robaws.EmployeeCertificates.EmployeeCertificates): Certificati dipendenti

### Robaws.EmployeeRole

- [EmployeeRoles](Robaws.EmployeeRole.EmployeeRoles): Ruoli Dipendente

### Robaws.Employees

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

### Robaws.ExecutionPhases

- [ExecutionPhases](Robaws.ExecutionPhases.ExecutionPhases): Fasi di Esecuzione

### Robaws.ExtraFields

- [ResourceTypeExtraFields](Robaws.ExtraFields.ResourceTypeExtraFields): Campi extra del tipo di risorsa

### Robaws.FormAnswers

- [FormAnswers](Robaws.FormAnswers.FormAnswers): Risposte al Modulo

### Robaws.FormElementAnswersFromFormAnswer

- [FormAnswerFormElementAnswers](Robaws.FormElementAnswersFromFormAnswer.FormAnswerFormElementAnswers): Risposte agli Elementi del Modulo

### Robaws.FormTemplates

- [FormTemplateRevisions](Robaws.FormTemplates.FormTemplateRevisions): Revisioni dei modelli di modulo
- [FormTemplates](Robaws.FormTemplates.FormTemplates): Modelli di modulo

### Robaws.GeneralLedgerAccounts

- [GeneralLedgerAccounts](Robaws.GeneralLedgerAccounts.GeneralLedgerAccounts): Conti di contabilità generale

### Robaws.HourTypes

- [HourTypes](Robaws.HourTypes.HourTypes): Tipi di ore

### Robaws.ImportJobs

- [ImportJobMessages](Robaws.ImportJobs.ImportJobMessages): Messaggi dei job di importazione
- [ImportJobs](Robaws.ImportJobs.ImportJobs): Job di importazione

### Robaws.Inboxes

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

### Robaws.InstallationCertificates

- [InstallationCertificates](Robaws.InstallationCertificates.InstallationCertificates): Certificati di installazione

### Robaws.Installations

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

### Robaws.InternalSupplyOrderLineItems

- [InternalSupplyOrderLineItems](Robaws.InternalSupplyOrderLineItems.InternalSupplyOrderLineItems): Righe degli ordini di fornitura interni

### Robaws.InternalSupplyOrders

- [InternalSupplyOrders](Robaws.InternalSupplyOrders.InternalSupplyOrders): Ordini di fornitura interni

### Robaws.Journals

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

### Robaws.LegalForms

- [LegalForms](Robaws.LegalForms.LegalForms): Forme giuridiche

### Robaws.MaintenanceSchedules

- [MaintenanceSchedules](Robaws.MaintenanceSchedules.MaintenanceSchedules): Piani di manutenzione

### Robaws.MaterialCertificates

- [MaterialCertificates](Robaws.MaterialCertificates.MaterialCertificates): Certificati dei materiali

### Robaws.Materials

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

### Robaws.MobilityTypes

- [MobilityTypes](Robaws.MobilityTypes.MobilityTypes): Tipi di Mobilità

### Robaws.Native

- [NATIVEPLATFORMSCALARREQUESTS](Robaws.Native.NATIVEPLATFORMSCALARREQUESTS): Richieste scalari della piattaforma nativa

### Robaws.Notifications

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

### Robaws.OfferCalculationLineItems

- [OfferCalculationLineItems](Robaws.OfferCalculationLineItems.OfferCalculationLineItems): Righe del calcolo dell'offerta

### Robaws.OfferLineItemParameters

- [OfferLineItemParameters](Robaws.OfferLineItemParameters.OfferLineItemParameters): Parametri delle righe dell'offerta

### Robaws.OfferLineItems

- [OfferLineItems](Robaws.OfferLineItems.OfferLineItems): Righe dell'offerta

### Robaws.OfferParameters

- [OfferParameters](Robaws.OfferParameters.OfferParameters): Parametri Offerta

### Robaws.OfferPhases

- [FasiOfferPhases](Robaws.OfferPhases.OfferPhases): Fasi offerta

### Robaws.Offers

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

### Robaws.PaymentConditions

- [PaymentConditions](Robaws.PaymentConditions.PaymentConditions): Condizioni di pagamento

### Robaws.PlaceTransports

- [PlaceTransports](Robaws.PlaceTransports.PlaceTransports): Trasporti di luogo

### Robaws.PlanningItemLineItems

- [PlanningItemLineItems](Robaws.PlanningItemLineItems.PlanningItemLineItems): Righe degli elementi di pianificazione

### Robaws.PlanningItems

- [PlanningItems](Robaws.PlanningItems.PlanningItems): Elementi di pianificazione

### Robaws.PlanningTypes

- [PlanningTypes](Robaws.PlanningTypes.PlanningTypes): Tipi di pianificazione

### Robaws.PostCalculationLineItems

- [PostCalculationLineItems](Robaws.PostCalculationLineItems.PostCalculationLineItems): Righe di Calcolo Post

### Robaws.PostParameters

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

### Robaws.Posts

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

### Robaws.PriceGroups

- [PriceGroups](Robaws.PriceGroups.PriceGroups): Gruppi di prezzo

### Robaws.PriceRequestLineItems

- [PriceRequestLineItems](Robaws.PriceRequestLineItems.PriceRequestLineItems): Righe delle richieste di prezzo

### Robaws.PriceRequests

- [PriceRequests](Robaws.PriceRequests.PriceRequests): Richieste di prezzo

### Robaws.ProjectConstructionPartners

- [ProjectConstructionPartners](Robaws.ProjectConstructionPartners.ProjectConstructionPartners): Partner di costruzione del progetto

### Robaws.ProjectPhases

- [ProjectPhases](Robaws.ProjectPhases.ProjectPhases): Fasi progetto

### Robaws.ProjectSupplyRoutes

- [ProjectSupplyRoutes](Robaws.ProjectSupplyRoutes.ProjectSupplyRoutes): Percorsi di fornitura del progetto

### Robaws.Projects

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

### Robaws.PurchaseInvoiceLineItems

- [PurchaseInvoiceLineItems](Robaws.PurchaseInvoiceLineItems.PurchaseInvoiceLineItems): Righe Fatture di Acquisto

### Robaws.PurchaseInvoices

- [PurchaseInvoices](Robaws.PurchaseInvoices.PurchaseInvoices): Fatture di acquisto

### Robaws.PurchaseSupplyOrderLineItems

- [PurchaseSupplyOrderLineItems](Robaws.PurchaseSupplyOrderLineItems.PurchaseSupplyOrderLineItems): Righe degli ordini di acquisto

### Robaws.PurchaseSupplyOrders

- [PurchaseSupplyOrders](Robaws.PurchaseSupplyOrders.PurchaseSupplyOrders): Ordini di Fornitura Acquisto

### Robaws.RecurrenceTypes

- [RecurrenceTypes](Robaws.RecurrenceTypes.RecurrenceTypes): Tipi di Ricorrenza

### Robaws.RentalSupplyOrderLineItems

- [RentalSupplyOrderLineItems](Robaws.RentalSupplyOrderLineItems.RentalSupplyOrderLineItems): Righe degli ordini di noleggio

### Robaws.RentalTariffExtraServiceOverrides

- [RentalTariffExtraServiceOverrides](Robaws.RentalTariffExtraServiceOverrides.RentalTariffExtraServiceOverrides): Sostituzioni dei servizi extra della tariffa di noleggio

### Robaws.RentalTariffExtraServices

- [RentalTariffExtraServices](Robaws.RentalTariffExtraServices.RentalTariffExtraServices): Servizi extra della tariffa di noleggio

### Robaws.RentalTariffTiers

- [RentalTariffTiers](Robaws.RentalTariffTiers.RentalTariffTiers): Scaglioni Tariffe di Noleggio

### Robaws.RentalTariffs

- [RentalTariffs](Robaws.RentalTariffs.RentalTariffs): Tariffe di Noleggio

### Robaws.RentalTicketLineItems

- [RentalTicketLineItems](Robaws.RentalTicketLineItems.RentalTicketLineItems): Righe Ticket di Noleggio

### Robaws.RentalTickets

- [RentalTickets](Robaws.RentalTickets.RentalTickets): Ticket di Noleggio

### Robaws.ResourceTypeMetadata

- [ResourceTypes](Robaws.ResourceTypeMetadata.ResourceTypes): Tipi risorsa

### Robaws.SalesInvoiceLineItems

- [SalesInvoiceLineItems](Robaws.SalesInvoiceLineItems.SalesInvoiceLineItems): Righe Fatture di Vendita

### Robaws.SalesInvoices

- [SalesInvoices](Robaws.SalesInvoices.SalesInvoices): Fatture di vendita

### Robaws.SalesOrderLineItems

- [SalesOrderLineItems](Robaws.SalesOrderLineItems.SalesOrderLineItems): Righe Ordini di Vendita

### Robaws.SalesOrders

- [SalesOrders](Robaws.SalesOrders.SalesOrders): Ordini cliente

### Robaws.ScheduledMaintenances

- [ScheduledMaintenances](Robaws.ScheduledMaintenances.ScheduledMaintenances): Manutenzioni Programmate

### Robaws.SettlementCalculationLineItems

- [SettlementCalculationLineItems](Robaws.SettlementCalculationLineItems.SettlementCalculationLineItems): Righe del calcolo di liquidazione

### Robaws.SettlementLineItemParameters

- [SettlementLineItemParameters](Robaws.SettlementLineItemParameters.SettlementLineItemParameters): Parametri delle righe di liquidazione

### Robaws.SettlementLineItems

- [SettlementLineItems](Robaws.SettlementLineItems.SettlementLineItems): Righe di Liquidazione

### Robaws.SettlementParameters

- [SettlementParameters](Robaws.SettlementParameters.SettlementParameters): Parametri di Liquidazione

### Robaws.SettlementPhases

- [SettlementPhases](Robaws.SettlementPhases.SettlementPhases): Fasi di Liquidazione

### Robaws.Settlements

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

### Robaws.StockChangeLineItems

- [StockChangeLineItems](Robaws.StockChangeLineItems.StockChangeLineItems): Righe Movimenti di Magazzino

### Robaws.StockChangeMaterialItems

- [StockChangeMaterialItems](Robaws.StockChangeMaterialItems.StockChangeMaterialItems): Articoli di variazione di magazzino

### Robaws.StockChanges

- [StockChangeFromSupplyOrder](Robaws.StockChanges.StockChangeFromSupplyOrder): Variazioni di magazzino da ordine di fornitura
- [StockChanges](Robaws.StockChanges.StockChanges): Movimenti di Magazzino

### Robaws.StockLocations

- [StockLocations](Robaws.StockLocations.StockLocations): Ubicazioni di magazzino

### Robaws.StockReservations

- [StockReservations](Robaws.StockReservations.StockReservations): Riserve di Magazzino

### Robaws.SubcontractorSupplyOrderLineItems

- [SubcontractorSupplyOrderLineItems](Robaws.SubcontractorSupplyOrderLineItems.SubcontractorSupplyOrderLineItems): Righe degli ordini di fornitura dei subappaltatori

### Robaws.SubcontractorSupplyOrders

- [SubcontractorSupplyOrders](Robaws.SubcontractorSupplyOrders.SubcontractorSupplyOrders): Ordini di Fornitura ai Subappaltatori

### Robaws.SubscriptionLineItems

- [SubscriptionLineItems](Robaws.SubscriptionLineItems.SubscriptionLineItems): Righe di Abbonamento

### Robaws.Subscriptions

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

### Robaws.SupplierPriceRequests

- [SupplierPriceRequests](Robaws.SupplierPriceRequests.SupplierPriceRequests): Richieste di Prezzo ai Fornitori

### Robaws.Suppliers

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

### Robaws.SupplyOrders

- [SupplyOrders](Robaws.SupplyOrders.SupplyOrders): Ordini di Fornitura

### Robaws.Tasks

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

### Robaws.Tenants

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

### Robaws.TimeOffCategories

- [TimeOffCategories](Robaws.TimeOffCategories.TimeOffCategories): Categorie di assenza

### Robaws.TimeOffRequests

- [TimeOffRequests](Robaws.TimeOffRequests.TimeOffRequests): Richieste di assenza

### Robaws.TimeRegistrations

- [TimeRegistrations](Robaws.TimeRegistrations.TimeRegistrations): Registrazioni del tempo

### Robaws.TransportSupplyOrderLineItems

- [TransportSupplyOrderLineItems](Robaws.TransportSupplyOrderLineItems.TransportSupplyOrderLineItems): Righe degli ordini di fornitura per il trasporto

### Robaws.TransportSupplyOrders

- [TransportSupplyOrders](Robaws.TransportSupplyOrders.TransportSupplyOrders): Ordini di fornitura di trasporto

### Robaws.Transports

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

### Robaws.Users

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

### Robaws.VatTariffs

- [VatTariffs](Robaws.VatTariffs.VatTariffs): Aliquote IVA

### Robaws.Webhooks

- [WebhookEndpoints](Robaws.Webhooks.WebhookEndpoints): Endpoint webhook

### Robaws.WeeklySchedules

- [WeeklySchedules](Robaws.WeeklySchedules.WeeklySchedules): Pianificazioni Settimanali

### Robaws.WhoAmI

- [Chi sono io](Robaws.WhoAmI.Whoami): Chi sono io

### Robaws.WorkOrderCommuteEntries

- [WorkOrderCommuteEntries](Robaws.WorkOrderCommuteEntries.WorkOrderCommuteEntries): Registrazioni Spostamenti Ordini di Lavoro

### Robaws.WorkOrderLineItems

- [WorkOrderLineItems](Robaws.WorkOrderLineItems.WorkOrderLineItems): Righe degli ordini di lavoro

### Robaws.WorkOrderMaterialEntries

- [WorkOrderMaterialEntries](Robaws.WorkOrderMaterialEntries.WorkOrderMaterialEntries): Voci materiali dell'ordine di lavoro

### Robaws.WorkOrderTimeEntries

- [WorkOrderTimeEntries](Robaws.WorkOrderTimeEntries.WorkOrderTimeEntries): Registrazioni Ore Ordini di Lavoro

### Robaws.WorkOrders

- [WorkOrders](Robaws.WorkOrders.WorkOrders): Ordini di lavoro

## Esempi di Query

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

## Attributi

Le caratteristiche di questa piattaforma sono riportate nella pagina [Attributes](attributes).


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

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