Robaws Data Model
Accounting software for construction and project-based companies.
Set up this platform in Invantive Cloud: https://cloud.invantive.com/robaws
The data is partitioned per partition (COMPANY_CODE).
Text comparisons on this platform are case sensitive.
Platform
- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Data can be written as well as read.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://status.robaws.be/nl/.
- Language of its user community: Dutch.
Figures
| Figure | Count |
|---|---|
| Tables | 127 |
| Columns | 3,097 |
| Tables with insert | 69 |
| Tables with update | 64 |
| Tables with delete | 68 |
| Tables documented | 3 |
Data Model Poster
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their 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
Employee
EmployeeCertificates, EmployeeRoles, Employees
NATIVEPLATFORMSCALARREQUESTS (without relations)
Tenant (without relations)
Webhook (without relations)
Relations
- Absences → Employees (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Absences → HourTypes (key)
- Absences → PlanningItems (key)
- ArticleGroups → ArticleGroups (key)
- ArticleSuppliers → Suppliers (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- ClaimStateLineItems → ClaimStates (key)
- ClaimStateLineItems → VatTariffs (key)
- ClaimStates → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Clients → LegalForms (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Clients → PaymentConditions (key)
- Clients → PriceGroups (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Clients → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Clients → VatTariffs (key)
- DeliveryNotes → Clients (key)
- DeliveryNotes → Companies (key)
- DeliveryNotes → Contacts (key)
- DeliveryNotes → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- DeliveryNotes → SalesOrders (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- DeliveryNotes → Suppliers (key)
- DeliveryNotes → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- EmployeeCertificates → Employees (key)
- Employees → Companies (key)
- Employees → EmployeeRoles (key)
- Employees → StockLocations (key)
- Employees → Suppliers (key)
- Installations → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Installations → Companies (key)
- Installations → Employees (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Installations → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Installations → StockLocations (key)
- Installations → Subscriptions (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Installations → Suppliers (key, 2 keys)
- Materials → Clients (key)
- Materials → Companies (key)
- Materials → Employees (key)
- Materials → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Materials → StockLocations (key)
- Materials → Suppliers (key, 2 keys)
- Offers → Clients (key)
- Offers → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Offers → Companies (key)
- Offers → Contacts (key)
- Offers → Contacts (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Offers → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- PlanningItems → Clients (key, 2 keys)
- PlanningItems → Companies (key)
- PlanningItems → Contacts (key, 2 keys)
- PlanningItems → ExecutionPhases (key)
- PlanningItems → PlanningItems (key)
- PlanningItems → PlanningTypes (key)
- PlanningItems → SalesOrders (key)
- Posts → ArticleGroups (key)
- Posts → VatTariffs (key)
- ProjectConstructionPartners → Contacts (key)
- ProjectConstructionPartners → Projects (key)
- ProjectConstructionPartners → Suppliers (key)
- Projects → Clients (described in words, 2 keys): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Projects → Companies (key)
- Projects → Contacts (key)
- Projects → Contacts (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Projects → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- PurchaseInvoices → Companies (key)
- PurchaseInvoices → PaymentConditions (key)
- PurchaseInvoices → Suppliers (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- PurchaseInvoices → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesInvoiceLineItems → Activities (key)
- SalesInvoiceLineItems → Installations (key)
- SalesInvoiceLineItems → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesInvoiceLineItems → VatTariffs (key)
- SalesInvoiceLineItems → WorkOrders (key)
- SalesInvoices → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesInvoices → Companies (key)
- SalesInvoices → DeliveryNotes (key)
- SalesInvoices → SalesInvoices (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesInvoices → Subscriptions (key)
- SalesInvoices → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesOrders → Clients (key)
- SalesOrders → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesOrders → Companies (key)
- SalesOrders → Contacts (key)
- SalesOrders → Contacts (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesOrders → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SalesOrders → Subscriptions (key)
- SalesOrders → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SettlementLineItems → Materials (key)
- SettlementLineItems → Settlements (key)
- SettlementLineItems → VatTariffs (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Settlements → Clients (key)
- Settlements → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Settlements → Companies (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Settlements → Contacts (key)
- Settlements → Contacts (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Settlements → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Settlements → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- StockChanges → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- StockChanges → DeliveryNotes (key)
- StockChanges → Employees (key)
- StockChanges → SalesOrders (key)
- StockChanges → StockLocations (key, 2 keys)
- StockChanges → Suppliers (key)
- StockChanges → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- StockChanges → WorkOrders (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- StockReservations → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- SubscriptionLineItems → Projects (key)
- SubscriptionLineItems → Subscriptions (key)
- SubscriptionLineItems → VatTariffs (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Subscriptions → Clients (key)
- Subscriptions → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Subscriptions → Companies (key)
- Subscriptions → Contacts (key, 2 keys)
- Subscriptions → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Suppliers → LegalForms (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Suppliers → VatTariffs (key)
- Tasks → Users (described in words, 2 keys): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- TimeRegistrations → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- TimeRegistrations → Employees (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- TimeRegistrations → Projects (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Transports → Clients (key)
- Transports → Employees (key)
- Transports → Materials (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- Transports → PlaceTransports (key, 2 keys)
- WorkOrderCommuteEntries → Employees (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- WorkOrderCommuteEntries → WorkOrders (key)
- WorkOrderLineItems → WorkOrders (key)
- WorkOrderMaterialEntries → Materials (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- WorkOrderMaterialEntries → WorkOrders (key)
- WorkOrderTimeEntries → Employees (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- WorkOrderTimeEntries → HourTypes (key)
- WorkOrderTimeEntries → WorkOrders (key)
- WorkOrders → Clients (key)
- WorkOrders → Clients (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
- WorkOrders → Companies (key)
- WorkOrders → SalesOrders (key)
- WorkOrders → Users (described in words): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
Tables
Robaws.Absences
- Absences: Absences
Robaws.Activities
- Activities: Activities
Robaws.ApprovalRequestRules
- ApprovalRequestRules: Approval Request Rules
Robaws.ApprovalRequests
- ApprovalRequests: Approval Requests
Robaws.ArticleAdditionalItems
- ArticleAdditionalItems: Article Additional Items
Robaws.ArticleGroups
- ArticleGroups: Article Groups
Robaws.ArticleSuppliers
- ArticleSuppliers: Article Suppliers
Robaws.ArticleTierPrices
- ArticleTierPrices: Article Tier Prices
Robaws.Articles
- ArticleStockMovements: Article Stock Movements
- Articles: Articles
Robaws.BankPayments
- BankPayments: Bank Payments
Robaws.BudgetAdjustments
- BudgetAdjustments: Budget Adjustments
Robaws.CallOffSupplyOrderLineItems
- CallOffSupplyOrderLineItems: Call-Off Supply Order Line Items
Robaws.CallOffSupplyOrders
- CallOffSupplyOrders: Call-Off Supply Orders
Robaws.CashEntries
- CashEntries: Cash Entries
Robaws.CashRegisterClosings
- CashRegisterClosings: Cash Register Closings
Robaws.CashRegisters
- CashRegisters: Cash Registers
Robaws.ClaimStateLineItems
- ClaimStateLineItems: Claim State Line Items
Robaws.ClaimStates
- ClaimStates: Claim States
Robaws.Clients
- Clients: Customers
Robaws.Companies
- Companies: Companies
Robaws.Contacts
- Contacts: Contacts
Robaws.DayPlanningResources
- DayPlanningResources: Day Planning Resources
Robaws.DeliveryNoteLineItems
- DeliveryNoteLineItems: Delivery Note Line Items
Robaws.DeliveryNotes
- DeliveryNotes: Delivery Notes
Robaws.EmployeeCertificates
- EmployeeCertificates: Employee Certificates
Robaws.EmployeeRole
- EmployeeRoles: Employee Roles
Robaws.Employees
- Employees: Employees
Robaws.ExecutionPhases
- ExecutionPhases: Execution Phases
Robaws.ExtraFields
- ResourceTypeExtraFields: Resource Type Extra Fields
Robaws.FormAnswers
- FormAnswers: Form Answers
Robaws.FormElementAnswersFromFormAnswer
- FormAnswerFormElementAnswers: Form Answer Form Element Answers
Robaws.FormTemplates
- FormTemplateRevisions: Form Template Revisions
- FormTemplates: Form Templates
Robaws.GeneralLedgerAccounts
- GeneralLedgerAccounts: General Ledger Accounts
Robaws.HourTypes
- HourTypes: Hour Types
Robaws.ImportJobs
- ImportJobMessages: Import Job Messages
- ImportJobs: Import Jobs
Robaws.Inboxes
- Inboxes: Inboxes
Robaws.InstallationCertificates
- InstallationCertificates: Installation Certificates
Robaws.Installations
- Installations: Installations
Robaws.InternalSupplyOrderLineItems
- InternalSupplyOrderLineItems: Internal Supply Order Line Items
Robaws.InternalSupplyOrders
- InternalSupplyOrders: Internal Supply Orders
Robaws.Journals
- Journals: Journals
Robaws.LegalForms
- LegalForms: Legal Forms
Robaws.MaintenanceSchedules
- MaintenanceSchedules: Maintenance Schedules
Robaws.MaterialCertificates
- MaterialCertificates: Material Certificates
Robaws.Materials
- Materials: Materials
Robaws.MobilityTypes
- MobilityTypes: Mobility Types
Robaws.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Robaws.Notifications
- Notifications: Notifications
Robaws.OfferCalculationLineItems
- OfferCalculationLineItems: Offer Calculation Line Items
Robaws.OfferLineItemParameters
- OfferLineItemParameters: Offer Line Item Parameters
Robaws.OfferLineItems
- OfferLineItems: Offer Line Items
Robaws.OfferParameters
- OfferParameters: Offer Parameters
Robaws.OfferPhases
- OfferPhases: Offer Phases
Robaws.Offers
- Offers: Offers
Robaws.PaymentConditions
- PaymentConditions: Payment Conditions
Robaws.PlaceTransports
- PlaceTransports: Place Transports
Robaws.PlanningItemLineItems
- PlanningItemLineItems: Planning Item Line Items
Robaws.PlanningItems
- PlanningItems: Planning Items
Robaws.PlanningTypes
- PlanningTypes: Planning Types
Robaws.PostCalculationLineItems
- PostCalculationLineItems: Post Calculation Line Items
Robaws.PostParameters
- PostParameters: Post Parameters
Robaws.Posts
- Posts: Posts
Robaws.PriceGroups
- PriceGroups: Pricegroups
Robaws.PriceRequestLineItems
- PriceRequestLineItems: Price Request Line Items
Robaws.PriceRequests
- PriceRequests: Price Requests
Robaws.ProjectConstructionPartners
- ProjectConstructionPartners: Project Construction Partners
Robaws.ProjectPhases
- ProjectPhases: Project Phases
Robaws.ProjectSupplyRoutes
- ProjectSupplyRoutes: Project Supply Routes
Robaws.Projects
- Projects: Projects
Robaws.PurchaseInvoiceLineItems
- PurchaseInvoiceLineItems: Purchase Invoice Line Items
Robaws.PurchaseInvoices
- PurchaseInvoices: Purchase Invoices
Robaws.PurchaseSupplyOrderLineItems
- PurchaseSupplyOrderLineItems: Purchase Supply Order Line Items
Robaws.PurchaseSupplyOrders
- PurchaseSupplyOrders: Purchase Supply Orders
Robaws.RecurrenceTypes
- RecurrenceTypes: Recurrence Types
Robaws.RentalSupplyOrderLineItems
- RentalSupplyOrderLineItems: Rental Supply Order Line Items
Robaws.RentalTariffExtraServiceOverrides
- RentalTariffExtraServiceOverrides: Rental Tariff Extra Service Overrides
Robaws.RentalTariffExtraServices
- RentalTariffExtraServices: Rental Tariff Extra Services
Robaws.RentalTariffTiers
- RentalTariffTiers: Rental Tariff Tiers
Robaws.RentalTariffs
- RentalTariffs: Rental Tariffs
Robaws.RentalTicketLineItems
- RentalTicketLineItems: Rental Ticket Line Items
Robaws.RentalTickets
- RentalTickets: Rental Tickets
Robaws.ResourceTypeMetadata
- ResourceTypes: Resource Types
Robaws.SalesInvoiceLineItems
- SalesInvoiceLineItems: Sales Invoice Line Items
Robaws.SalesInvoices
- SalesInvoices: Sales Invoices
Robaws.SalesOrderLineItems
- SalesOrderLineItems: Sales Order Line Items
Robaws.SalesOrders
- SalesOrders: Sales Orders
Robaws.ScheduledMaintenances
- ScheduledMaintenances: Scheduled Maintenances
Robaws.SettlementCalculationLineItems
- SettlementCalculationLineItems: Settlement Calculation Line Items
Robaws.SettlementLineItemParameters
- SettlementLineItemParameters: Settlement Line Item Parameters
Robaws.SettlementLineItems
- SettlementLineItems: Settlement Line Items
Robaws.SettlementParameters
- SettlementParameters: Settlement Parameters
Robaws.SettlementPhases
- SettlementPhases: Settlement Phases
Robaws.Settlements
- Settlements: Settlements
Robaws.StockChangeLineItems
- StockChangeLineItems: Stock Change Line Items
Robaws.StockChangeMaterialItems
- StockChangeMaterialItems: Stock Change Material Items
Robaws.StockChanges
- StockChangeFromSupplyOrder: Stock Changes From Supply Order
- StockChanges: Stock Changes
Robaws.StockLocations
- StockLocations: Stock Locations
Robaws.StockReservations
- StockReservations: Stock Reservations
Robaws.SubcontractorSupplyOrderLineItems
- SubcontractorSupplyOrderLineItems: Subcontractor Supply Order Line Items
Robaws.SubcontractorSupplyOrders
- SubcontractorSupplyOrders: Subcontractor Supply Orders
Robaws.SubscriptionLineItems
- SubscriptionLineItems: Subscription Line Items
Robaws.Subscriptions
- Subscriptions: Subscriptions
Robaws.SupplierPriceRequests
- SupplierPriceRequests: Supplier Price Requests
Robaws.Suppliers
- Suppliers: Suppliers
Robaws.SupplyOrders
- SupplyOrders: Supply Orders
Robaws.Tasks
- Tasks: Tasks
Robaws.Tenants
- Tenants: Tenants
Robaws.TimeOffCategories
- TimeOffCategories: Time Off Categories
Robaws.TimeOffRequests
- TimeOffRequests: Time Off Requests
Robaws.TimeRegistrations
- TimeRegistrations: Time Registrations
Robaws.TransportSupplyOrderLineItems
- TransportSupplyOrderLineItems: Transport Supply Order Line Items
Robaws.TransportSupplyOrders
- TransportSupplyOrders: Transport Supply Orders
Robaws.Transports
- Transports: Transports
Robaws.Users
- Users: Users
Robaws.VatTariffs
- VatTariffs: VAT Tariffs
Robaws.Webhooks
- WebhookEndpoints: Webhook Endpoints
Robaws.WeeklySchedules
- WeeklySchedules: Weekly Schedules
Robaws.WhoAmI
- Whoami: Who Am I
Robaws.WorkOrderCommuteEntries
- WorkOrderCommuteEntries: Work Order Commute Entries
Robaws.WorkOrderLineItems
- WorkOrderLineItems: Work Order Line Items
Robaws.WorkOrderMaterialEntries
- WorkOrderMaterialEntries: Work Order Material Entries
Robaws.WorkOrderTimeEntries
- WorkOrderTimeEntries: Work Order Time Entries
Robaws.WorkOrders
- WorkOrders: Work Orders
Sample 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
Attributes
The attributes of this platform are on the page Attributes.
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: