invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Modèle de données Robaws

Logiciel de comptabilité destiné aux entreprises du secteur de la construction et aux entreprises travaillant par projet.

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/robaws

Les données sont partitionnées par partition (COMPANY_CODE).

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Les données peuvent être aussi bien écrites que lues.
  • Forfaits Invantive Cloud : Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • État de la plateforme : https://status.robaws.be/nl/.
  • Langue de sa communauté d'utilisateurs : néerlandais.

Chiffres

Figure Count
Tables 127
Columns 3,097
Tableaux avec insert 69
Tables avec mise à jour 64
Tables avec la clause DELETE 68
Tableaux documentés 3

Affiche sur le modèle de données

PDF, 1 feuille A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

Robaws Modèle de données, Page 1 sur 1Robaws Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 27.1.33-BETA+6408 · 03-11-2026Sale · Contacts · Stock · Sale · Users · Sale · ExecutionPhases · L’employé · WorkPage 1 sur 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 LocationsStockLocationsStockRobaws.WorkOrders.WorkOrders: Work OrdersWorkOrdersWorkRobaws.Companies.CompaniesCRobaws.Clients.ClientsLRobaws.SalesOrders.SalesOrdersSRobaws.Users.UsersUStock×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 TypesHourTypesWorkL’employéRobaws.EmployeeCertificates.EmployeeCertificates: Employee CertificatesEmployeeCertificatesRobaws.EmployeeRole.EmployeeRoles: Employee RolesEmployeeRolesRobaws.Employees.Employees: EmployeesEmployeesRobaws.Companies.CompaniesCRobaws.StockLocations.StockLocations: Stock LocationsStockLocationsStockRobaws.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: MaterialsMaterialsStockRobaws.Companies.CompaniesCRobaws.Employees.EmployeesERobaws.Clients.ClientsLNATIVEPLATFORMSCALARREQUESTSRobaws.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSTenantRobaws.Tenants.Tenants: TenantsTenantsWebhookRobaws.Webhooks.WebhookEndpoints: Webhook EndpointsWebhookEndpointsRobawsDictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.SujetsL’employé1Sale · Contacts1Sale · ExecutionPhases1Sale · Users1Stock1Work1Tables sans relations1LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes×n: n relations between the same tablesLettres : désigne une table utilisée dans la plupart des rubriques: C = Companies, L = Clients, E =Employees, S = SalesOrders, U = UsersGénéré à partir des métadonnées d'Invantive UniversalSQL 27.1.33-BETA+6408 le 03-11-2026. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/robaws
L'affiche sous forme de texte : tableaux par thème et leurs relations

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

Stock

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

L’employé

EmployeeCertificates, EmployeeRoles, Employees

NATIVEPLATFORMSCALARREQUESTS (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Tenant (sans relations)

Tenants

Webhook (sans relations)

WebhookEndpoints

Relations

Tableaux

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

Exemples 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

Attributs

Les caractéristiques de cette plateforme sont présentées sur la page Attributes.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :