Robaws Data Model
Boekhoudsoftware voor bouwbedrijven en projectmatigwerkende bedrijven.
Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/robaws
De gegevens zijn gepartitioneerd per partitie (COMPANY_CODE).
Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.
Platform
- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Gegevens kunnen zowel worden geschreven als gelezen.
- Invantive Cloud-abonnementen: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status van het platform: https://status.robaws.be/nl/.
- Taal van de gebruikersgemeenschap: Nederlands.
Cijfers
| Figure | Count |
|---|---|
| Tables | 127 |
| Columns | 3,097 |
| Tabeller med invoegsel | 69 |
| Tabeller med update | 64 |
| Tabellen met de functie 'verwijderen' | 68 |
| Tabeller gedocumenteerd | 3 |
Poster met datamodel
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden
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
Voorraad
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
Medewerker
EmployeeCertificates, EmployeeRoles, Employees
NATIVEPLATFORMSCALARREQUESTS (zonder relaties)
Tenant (zonder relaties)
Webhook (zonder relaties)
Relaties
- Absences → Employees (in woorden beschreven): 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 (sleutel)
- Absences → PlanningItems (sleutel)
- ArticleGroups → ArticleGroups (sleutel)
- ArticleSuppliers → Suppliers (in woorden beschreven): 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 (sleutel)
- ClaimStateLineItems → VatTariffs (sleutel)
- ClaimStates → Users (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- Clients → PriceGroups (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- DeliveryNotes → Clients (sleutel)
- DeliveryNotes → Companies (sleutel)
- DeliveryNotes → Contacts (sleutel)
- DeliveryNotes → Projects (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- DeliveryNotes → Users (in woorden beschreven): 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 (sleutel)
- Employees → Companies (sleutel)
- Employees → EmployeeRoles (sleutel)
- Employees → StockLocations (sleutel)
- Employees → Suppliers (sleutel)
- Installations → Clients (in woorden beschreven): 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 (sleutel)
- Installations → Employees (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- Installations → Subscriptions (in woorden beschreven): 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 (sleutel, 2 keys)
- Materials → Clients (sleutel)
- Materials → Companies (sleutel)
- Materials → Employees (sleutel)
- Materials → Projects (in woorden beschreven): 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 (sleutel)
- Materials → Suppliers (sleutel, 2 keys)
- Offers → Clients (sleutel)
- Offers → Clients (in woorden beschreven): 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 (sleutel)
- Offers → Contacts (sleutel)
- Offers → Contacts (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel, 2 keys)
- PlanningItems → Companies (sleutel)
- PlanningItems → Contacts (sleutel, 2 keys)
- PlanningItems → ExecutionPhases (sleutel)
- PlanningItems → PlanningItems (sleutel)
- PlanningItems → PlanningTypes (sleutel)
- PlanningItems → SalesOrders (sleutel)
- Posts → ArticleGroups (sleutel)
- Posts → VatTariffs (sleutel)
- ProjectConstructionPartners → Contacts (sleutel)
- ProjectConstructionPartners → Projects (sleutel)
- ProjectConstructionPartners → Suppliers (sleutel)
- Projects → Clients (in woorden beschreven, 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 (sleutel)
- Projects → Contacts (sleutel)
- Projects → Contacts (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- PurchaseInvoices → PaymentConditions (sleutel)
- PurchaseInvoices → Suppliers (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- SalesInvoiceLineItems → Installations (sleutel)
- SalesInvoiceLineItems → Projects (in woorden beschreven): 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 (sleutel)
- SalesInvoiceLineItems → WorkOrders (sleutel)
- SalesInvoices → Clients (in woorden beschreven): 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 (sleutel)
- SalesInvoices → DeliveryNotes (sleutel)
- SalesInvoices → SalesInvoices (in woorden beschreven): 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 (sleutel)
- SalesInvoices → Users (in woorden beschreven): 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 (sleutel)
- SalesOrders → Clients (in woorden beschreven): 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 (sleutel)
- SalesOrders → Contacts (sleutel)
- SalesOrders → Contacts (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- SalesOrders → Users (in woorden beschreven): 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 (sleutel)
- SettlementLineItems → Settlements (sleutel)
- SettlementLineItems → VatTariffs (in woorden beschreven): 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 (sleutel)
- Settlements → Clients (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- Settlements → Contacts (in woorden beschreven): 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 (in woorden beschreven): 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 (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- StockChanges → Employees (sleutel)
- StockChanges → SalesOrders (sleutel)
- StockChanges → StockLocations (sleutel, 2 keys)
- StockChanges → Suppliers (sleutel)
- StockChanges → Users (in woorden beschreven): 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 (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- SubscriptionLineItems → Subscriptions (sleutel)
- SubscriptionLineItems → VatTariffs (in woorden beschreven): 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 (sleutel)
- Subscriptions → Clients (in woorden beschreven): 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 (sleutel)
- Subscriptions → Contacts (sleutel, 2 keys)
- Subscriptions → Users (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- Tasks → Users (in woorden beschreven, 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 (in woorden beschreven): 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 (in woorden beschreven): 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 (in woorden beschreven): 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 (sleutel)
- Transports → Employees (sleutel)
- Transports → Materials (in woorden beschreven): 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 (sleutel, 2 keys)
- WorkOrderCommuteEntries → Employees (in woorden beschreven): 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 (sleutel)
- WorkOrderLineItems → WorkOrders (sleutel)
- WorkOrderMaterialEntries → Materials (in woorden beschreven): 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 (sleutel)
- WorkOrderTimeEntries → Employees (in woorden beschreven): 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 (sleutel)
- WorkOrderTimeEntries → WorkOrders (sleutel)
- WorkOrders → Clients (sleutel)
- WorkOrders → Clients (in woorden beschreven): 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 (sleutel)
- WorkOrders → SalesOrders (sleutel)
- WorkOrders → Users (in woorden beschreven): 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.
Tabellen
Robaws.Absences
- Absences: Afwezigheden
Robaws.Activities
- Activities: Activities
Robaws.ApprovalRequestRules
- ApprovalRequestRules: Goedkeuringsaanvraagregels
Robaws.ApprovalRequests
- ApprovalRequests: Goedkeuringsverzoeken
Robaws.ArticleAdditionalItems
- ArticleAdditionalItems: Article Additional Items
Robaws.ArticleGroups
- ArticleGroups: Artikelgroepen
Robaws.ArticleSuppliers
- ArticleSuppliers: Artikelleveranciers
Robaws.ArticleTierPrices
- ArticleTierPrices: Artikel staffelprijzen
Robaws.Articles
- ArticleStockMovements: Artikelvoorraadbewegingen
- Artikelen: Artikelen
Robaws.BankPayments
- BankPayments: Bankbetalingen
Robaws.BudgetAdjustments
- BudgetAdjustments: Budget Adjustments
Robaws.CallOffSupplyOrderLineItems
- CallOffSupplyOrderLineItems: Call-off-leveringsorderregels
Robaws.CallOffSupplyOrders
- CallOffSupplyOrders: Call-off-leveringsorders
Robaws.CashEntries
- CashEntries: Kasmutaties
Robaws.CashRegisterClosings
- CashRegisterClosings: Kassasluitingen
Robaws.CashRegisters
- CashRegisters: Kassaregisters
Robaws.ClaimStateLineItems
- ClaimStateLineItems: Claimstatusregels
Robaws.ClaimStates
- ClaimStates: Claimstatussen
Robaws.Clients
- Klanten: Klanten
Robaws.Companies
- Bedrijven: Bedrijven
Robaws.Contacts
- Contacten: Contacten
Robaws.DayPlanningResources
- DayPlanningResources: Dagplanningsresources
Robaws.DeliveryNoteLineItems
- DeliveryNoteLineItems: Leveringsbonregels
Robaws.DeliveryNotes
- DeliveryNotes: Leveringsbonnen
Robaws.EmployeeCertificates
- EmployeeCertificates: Medewerkerscertificaten
Robaws.EmployeeRole
- EmployeeRoles: Medewerkersrollen
Robaws.Employees
- Medewerkers: Medewerkers
Robaws.ExecutionPhases
- ExecutionPhases: Execution Phases
Robaws.ExtraFields
- ResourceTypeExtraFields: Extra velden resourcetype
Robaws.FormAnswers
- FormAnswers: Formulierantwoorden
Robaws.FormElementAnswersFromFormAnswer
- FormAnswerFormElementAnswers: Formulierantwoord-formulierelementantwoorden
Robaws.FormTemplates
- FormTemplateRevisions: Formuliersjabloonrevisies
- FormTemplates: Formuliersjablonen
Robaws.GeneralLedgerAccounts
- GeneralLedgerAccounts: Grootboekrekeningen
Robaws.HourTypes
- HourTypes: Uurtypen
Robaws.ImportJobs
- ImportJobMessages: Importtaakberichten
- ImportJobs: Importtaken
Robaws.Inboxes
- Inboxen: Inboxen
Robaws.InstallationCertificates
- InstallationCertificates: Installatiecertificaten
Robaws.Installations
- Installaties: Installaties
Robaws.InternalSupplyOrderLineItems
- InternalSupplyOrderLineItems: Interne leveringsorderregels
Robaws.InternalSupplyOrders
- InternalSupplyOrders: Internal Supply Orders
Robaws.Journals
- Journals: Journalen
Robaws.LegalForms
- LegalForms: Rechtsvormen
Robaws.MaintenanceSchedules
- MaintenanceSchedules: Onderhoudsschema's
Robaws.MaterialCertificates
- MaterialCertificates: Materiaalcertificaten
Robaws.Materials
- Materials: Materialen
Robaws.MobilityTypes
- MobilityTypes: Mobility Types
Robaws.Native
- NATIVEPLATFORMSCALARREQUESTS: Scalaire verzoeken op het native platform
Robaws.Notifications
- Notifications: Meldingen
Robaws.OfferCalculationLineItems
- OfferCalculationLineItems: Offerteberekeningsregels
Robaws.OfferLineItemParameters
- OfferLineItemParameters: Offer Line Item Parameters
Robaws.OfferLineItems
- OfferLineItems: Offer Line Items
Robaws.OfferParameters
- OfferParameters: Offerteparameters
Robaws.OfferPhases
- OfferPhases: Offertefases
Robaws.Offers
- Offers: Offertes
Robaws.PaymentConditions
- PaymentConditions: Betalingsvoorwaarden
Robaws.PlaceTransports
- PlaceTransports: Plaatstransporten
Robaws.PlanningItemLineItems
- PlanningItemLineItems: Planningsitemregels
Robaws.PlanningItems
- PlanningItems: Planningsitems
Robaws.PlanningTypes
- PlanningTypes: Planningstypen
Robaws.PostCalculationLineItems
- PostCalculationLineItems: Nacalculatieregels
Robaws.PostParameters
- PostParameters: Post Parameters
Robaws.Posts
- Posts: Berichten
Robaws.PriceGroups
- PriceGroups: Pricegroups
Robaws.PriceRequestLineItems
- PriceRequestLineItems: Prijsaanvraagregels
Robaws.PriceRequests
- PriceRequests: Prijsaanvragen
Robaws.ProjectConstructionPartners
- ProjectConstructionPartners: Projectbouwpartners
Robaws.ProjectPhases
- ProjectPhases: Projectfasen
Robaws.ProjectSupplyRoutes
- ProjectSupplyRoutes: Projectleveringsroutes
Robaws.Projects
- Projecten: Projecten
Robaws.PurchaseInvoiceLineItems
- PurchaseInvoiceLineItems: Inkoopfactuurregels
Robaws.PurchaseInvoices
- PurchaseInvoices: Inkoopfacturen
Robaws.PurchaseSupplyOrderLineItems
- PurchaseSupplyOrderLineItems: Inkoopleveringsorderregels
Robaws.PurchaseSupplyOrders
- PurchaseSupplyOrders: Inkoopleveringsorders
Robaws.RecurrenceTypes
- RecurrenceTypes: Herhalingstypen
Robaws.RentalSupplyOrderLineItems
- RentalSupplyOrderLineItems: Huurleveringsorderregels
Robaws.RentalTariffExtraServiceOverrides
- RentalTariffExtraServiceOverrides: Huurtariefextraservice-overrides
Robaws.RentalTariffExtraServices
- RentalTariffExtraServices: Huurtariefextraservices
Robaws.RentalTariffTiers
- RentalTariffTiers: Huurtariefschijven
Robaws.RentalTariffs
- RentalTariffs: Rental Tariffs
Robaws.RentalTicketLineItems
- RentalTicketLineItems: Huurticketregels
Robaws.RentalTickets
- RentalTickets: Huurtickets
Robaws.ResourceTypeMetadata
- ResourceTypes: Resourcetypen
Robaws.SalesInvoiceLineItems
- SalesInvoiceLineItems: Sales Invoice Line Items
Robaws.SalesInvoices
- SalesInvoices: Verkoopfacturen
Robaws.SalesOrderLineItems
- SalesOrderLineItems: Sales Order Line Items
Robaws.SalesOrders
- SalesOrders: Verkooporders
Robaws.ScheduledMaintenances
- ScheduledMaintenances: Geplande onderhoudsbeurten
Robaws.SettlementCalculationLineItems
- SettlementCalculationLineItems: Afrekeningsberekeningsregels
Robaws.SettlementLineItemParameters
- SettlementLineItemParameters: Settlement Line Item Parameters
Robaws.SettlementLineItems
- SettlementLineItems: Settlement Line Items
Robaws.SettlementParameters
- SettlementParameters: Afrekeningsparameters
Robaws.SettlementPhases
- SettlementPhases: Afrekeningsfasen
Robaws.Settlements
- Afrekeningen: Afrekeningen
Robaws.StockChangeLineItems
- StockChangeLineItems: Voorraadmutatieregels
Robaws.StockChangeMaterialItems
- StockChangeMaterialItems: Voorraadmutatie-materiaalitems
Robaws.StockChanges
- StockChangeFromSupplyOrder: Voorraadmutaties uit leveringsorder
- StockChanges: Voorraadmutaties
Robaws.StockLocations
- StockLocations: Voorraadlocaties
Robaws.StockReservations
- StockReservations: Voorraadreserveringen
Robaws.SubcontractorSupplyOrderLineItems
- SubcontractorSupplyOrderLineItems: Subcontractor Supply Order Line Items
Robaws.SubcontractorSupplyOrders
- SubcontractorSupplyOrders: Onderaannemer-leveringsorders
Robaws.SubscriptionLineItems
- SubscriptionLineItems: Abonnementsregels
Robaws.Subscriptions
- Subscriptions: Abonnementen
Robaws.SupplierPriceRequests
- SupplierPriceRequests: Leveranciersprijsaanvragen
Robaws.Suppliers
- Suppliers: Leveranciers
Robaws.SupplyOrders
- SupplyOrders: Supply Orders
Robaws.Tasks
- Taken: Taken
Robaws.Tenants
- Huurders: Huurders
Robaws.TimeOffCategories
- TimeOffCategories: Time Off Categories
Robaws.TimeOffRequests
- TimeOffRequests: Verlofaanvragen
Robaws.TimeRegistrations
- TimeRegistrations: Tijdregistraties
Robaws.TransportSupplyOrderLineItems
- TransportSupplyOrderLineItems: Transportleveringsorderregels
Robaws.TransportSupplyOrders
- TransportSupplyOrders: Transportleveringsorders
Robaws.Transports
- Transporten: Transporten
Robaws.Users
- Users: Gebruikers
Robaws.VatTariffs
- VatTariffs: BTW-tarieven
Robaws.Webhooks
- WebhookEndpoints: Webhook-eindpunten
Robaws.WeeklySchedules
- WeeklySchedules: Wekelijkse planningen
Robaws.WhoAmI
- Whoami: Wie ben ik
Robaws.WorkOrderCommuteEntries
- WorkOrderCommuteEntries: Work Order Commute Entries
Robaws.WorkOrderLineItems
- WorkOrderLineItems: Work Order Line Items
Robaws.WorkOrderMaterialEntries
- WorkOrderMaterialEntries: Werkorder-materiaalregistraties
Robaws.WorkOrderTimeEntries
- WorkOrderTimeEntries: Werkorder-tijdregistraties
Robaws.WorkOrders
- WorkOrders: Work Orders
Voorbeeldqueries
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
Attributen
De kenmerken van dit platform staan op de pagina Attributes.
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: