invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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/.
  • 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

Póster del Modelo de Datos

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Robaws Modelo de Datos, Hoja 1 de 1Robaws Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.33-BETA+6408 · 03-11-2026Sale · Contacts · Almacén · Sale · Users · Sale · ExecutionPhases · Empleado · WorkHoja 1 de 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 LocationsStockLocationsAlmacénRobaws.WorkOrders.WorkOrders: Work OrdersWorkOrdersWorkRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.Users.UsersUAlmacén×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 TypesHourTypesWorkEmpleadoRobaws.EmployeeCertificates.EmployeeCertificates: Employee CertificatesEmployeeCertificatesRobaws.EmployeeRole.EmployeeRoles: Employee RolesEmployeeRolesRobaws.Employees.Employees: EmployeesEmployeesRobaws.Companies.CompaniesCRobaws.StockLocations.StockLocations: Stock LocationsStockLocationsAlmacénRobaws.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: MaterialsMaterialsAlmacénRobaws.Companies.CompaniesCRobaws.Employees.EmployeesERobaws.Clients.ClientsLNATIVEPLATFORMSCALARREQUESTSRobaws.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSTenantRobaws.Tenants.Tenants: TenantsTenantsWebhookRobaws.Webhooks.WebhookEndpoints: Webhook EndpointsWebhookEndpointsRobawsDiccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasAlmacén1Empleado1Sale · Contacts1Sale · ExecutionPhases1Sale · Users1Work1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes×n: n relations between the same tablesLetras: se refiere a una tabla que se utiliza en la mayoría de los temas: C = Companies, L = Clients, E =Employees, S = SalesOrders, U = UsersGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.33-BETA+6408 el 03-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/robaws
El póster en forma de texto: tablas por tema y sus relaciones

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

Almacén

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

Empleado

EmployeeCertificates, EmployeeRoles, Employees

NATIVEPLATFORMSCALARREQUESTS (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Tenant (sin relaciones)

Tenants

Webhook (sin relaciones)

WebhookEndpoints

Relaciones

Tablas

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

Ejemplos de 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

Atributos

Las características de esta plataforma se encuentran en la página Attributes.

Notas de la Versión

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