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
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.
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)
Tenant (sans relations)
Webhook (sans relations)
Relations
- Absences → Employees (décrit avec des mots): 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 (clé)
- Absences → PlanningItems (clé)
- ArticleGroups → ArticleGroups (clé)
- ArticleSuppliers → Suppliers (décrit avec des mots): 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 (clé)
- ClaimStateLineItems → VatTariffs (clé)
- ClaimStates → Users (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- Clients → PriceGroups (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- DeliveryNotes → Clients (clé)
- DeliveryNotes → Companies (clé)
- DeliveryNotes → Contacts (clé)
- DeliveryNotes → Projects (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- DeliveryNotes → Users (décrit avec des mots): 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 (clé)
- Employees → Companies (clé)
- Employees → EmployeeRoles (clé)
- Employees → StockLocations (clé)
- Employees → Suppliers (clé)
- Installations → Clients (décrit avec des mots): 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 (clé)
- Installations → Employees (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- Installations → Subscriptions (décrit avec des mots): 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 (clé, 2 keys)
- Materials → Clients (clé)
- Materials → Companies (clé)
- Materials → Employees (clé)
- Materials → Projects (décrit avec des mots): 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 (clé)
- Materials → Suppliers (clé, 2 keys)
- Offers → Clients (clé)
- Offers → Clients (décrit avec des mots): 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 (clé)
- Offers → Contacts (clé)
- Offers → Contacts (décrit avec des mots): 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 (décrit avec des mots): 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 (clé, 2 keys)
- PlanningItems → Companies (clé)
- PlanningItems → Contacts (clé, 2 keys)
- PlanningItems → ExecutionPhases (clé)
- PlanningItems → PlanningItems (clé)
- PlanningItems → PlanningTypes (clé)
- PlanningItems → SalesOrders (clé)
- Posts → ArticleGroups (clé)
- Posts → VatTariffs (clé)
- ProjectConstructionPartners → Contacts (clé)
- ProjectConstructionPartners → Projects (clé)
- ProjectConstructionPartners → Suppliers (clé)
- Projects → Clients (décrit avec des mots, 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 (clé)
- Projects → Contacts (clé)
- Projects → Contacts (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- PurchaseInvoices → PaymentConditions (clé)
- PurchaseInvoices → Suppliers (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- SalesInvoiceLineItems → Installations (clé)
- SalesInvoiceLineItems → Projects (décrit avec des mots): 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 (clé)
- SalesInvoiceLineItems → WorkOrders (clé)
- SalesInvoices → Clients (décrit avec des mots): 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 (clé)
- SalesInvoices → DeliveryNotes (clé)
- SalesInvoices → SalesInvoices (décrit avec des mots): 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 (clé)
- SalesInvoices → Users (décrit avec des mots): 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 (clé)
- SalesOrders → Clients (décrit avec des mots): 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 (clé)
- SalesOrders → Contacts (clé)
- SalesOrders → Contacts (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- SalesOrders → Users (décrit avec des mots): 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 (clé)
- SettlementLineItems → Settlements (clé)
- SettlementLineItems → VatTariffs (décrit avec des mots): 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 (clé)
- Settlements → Clients (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- Settlements → Contacts (décrit avec des mots): 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 (décrit avec des mots): 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 (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- StockChanges → Employees (clé)
- StockChanges → SalesOrders (clé)
- StockChanges → StockLocations (clé, 2 keys)
- StockChanges → Suppliers (clé)
- StockChanges → Users (décrit avec des mots): 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 (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- SubscriptionLineItems → Subscriptions (clé)
- SubscriptionLineItems → VatTariffs (décrit avec des mots): 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 (clé)
- Subscriptions → Clients (décrit avec des mots): 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 (clé)
- Subscriptions → Contacts (clé, 2 keys)
- Subscriptions → Users (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- Tasks → Users (décrit avec des mots, 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 (décrit avec des mots): 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 (décrit avec des mots): 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 (décrit avec des mots): 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 (clé)
- Transports → Employees (clé)
- Transports → Materials (décrit avec des mots): 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 (clé, 2 keys)
- WorkOrderCommuteEntries → Employees (décrit avec des mots): 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 (clé)
- WorkOrderLineItems → WorkOrders (clé)
- WorkOrderMaterialEntries → Materials (décrit avec des mots): 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 (clé)
- WorkOrderTimeEntries → Employees (décrit avec des mots): 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 (clé)
- WorkOrderTimeEntries → WorkOrders (clé)
- WorkOrders → Clients (clé)
- WorkOrders → Clients (décrit avec des mots): 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 (clé)
- WorkOrders → SalesOrders (clé)
- WorkOrders → Users (décrit avec des mots): 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.
Tableaux
Robaws.Absences
- Absences: Absences
Robaws.Activities
- Activités: Activités
Robaws.ApprovalRequestRules
- ApprovalRequestRules: Règles de demande d'approbation
Robaws.ApprovalRequests
- ApprovalRequests : Demandes d'approbation
Robaws.ArticleAdditionalItems
- ArticleAdditionalItems : articles complémentaires
Robaws.ArticleGroups
- ArticleGroups : Groupes d'articles
Robaws.ArticleSuppliers
- ArticleSuppliers : Fournisseurs d'articles
Robaws.ArticleTierPrices
- ArticleTierPrices : Prix par palier d'articles
Robaws.Articles
- ArticleStockMovements: Mouvements de stock d'articles
- Articles: Articles
Robaws.BankPayments
- BankPayments: Paiements bancaires
Robaws.BudgetAdjustments
- BudgetAdjustments : ajustements budgétaires
Robaws.CallOffSupplyOrderLineItems
- CallOffSupplyOrderLineItems : Lignes de commandes d'approvisionnement à appel
Robaws.CallOffSupplyOrders
- CallOffSupplyOrders: Ordres d'approvisionnement sur appel
Robaws.CashEntries
- CashEntries: Saisies de trésorerie
Robaws.CashRegisterClosings
- CashRegisterClosings: Clôtures de caisse enregistreuse
Robaws.CashRegisters
- CashRegisters : Caisses enregistreuses
Robaws.ClaimStateLineItems
- ClaimStateLineItems : Lignes d'état de réclamation
Robaws.ClaimStates
- ClaimStates : États de réclamation
Robaws.Clients
- Clients : Clients
Robaws.Companies
- Sociétés : Sociétés
Robaws.Contacts
- Contacts: Contacts
Robaws.DayPlanningResources
- DayPlanningResources : Ressources de planification journalière
Robaws.DeliveryNoteLineItems
- DeliveryNoteLineItems: Lignes de bon de livraison
Robaws.DeliveryNotes
- DeliveryNotes: Bons de livraison
Robaws.EmployeeCertificates
- EmployeeCertificates: Certificats d'employés
Robaws.EmployeeRole
- EmployeeRoles : Rôles des employés
Robaws.Employees
- Employees : Employés
Robaws.ExecutionPhases
- ExecutionPhases : phases d'exécution
Robaws.ExtraFields
- ResourceTypeExtraFields : Champs supplémentaires des types de ressources
Robaws.FormAnswers
- FormAnswers : Réponses de formulaire
Robaws.FormElementAnswersFromFormAnswer
- FormAnswerFormElementAnswers : Réponses aux éléments de formulaire
Robaws.FormTemplates
- FormTemplateRevisions: Révisions de modèles de formulaire
- FormTemplates : Modèles de formulaire
Robaws.GeneralLedgerAccounts
- GeneralLedgerAccounts : Comptes du grand livre
Robaws.HourTypes
- HourTypes: Types d'heures
Robaws.ImportJobs
- ImportJobMessages : Messages de tâches d'importation
- ImportJobs : Tâches d'importation
Robaws.Inboxes
- Boîtes de réception : Boîtes de réception
Robaws.InstallationCertificates
- InstallationCertificates : Certificats d'installation
Robaws.Installations
- Installations : Installations
Robaws.InternalSupplyOrderLineItems
- InternalSupplyOrderLineItems: Lignes d'ordre d'approvisionnement interne
Robaws.InternalSupplyOrders
- InternalSupplyOrders : ordres d'approvisionnement internes
Robaws.Journals
- Journals : Journaux
Robaws.LegalForms
- LegalForms : Formes juridiques
Robaws.MaintenanceSchedules
- MaintenanceSchedules : Plannings de maintenance
Robaws.MaterialCertificates
- MaterialCertificates : Certificats de matériaux
Robaws.Materials
- Materials : Matériaux
Robaws.MobilityTypes
- MobilityTypes : Types de mobilité
Robaws.Native
- NATIVEPLATFORMSCALARREQUESTS : Demandes scalaires sur plateforme native
Robaws.Notifications
- Notifications : Notifications
Robaws.OfferCalculationLineItems
- OfferCalculationLineItems: Lignes de calcul d'offre
Robaws.OfferLineItemParameters
- OfferLineItemParameters : paramètres des lignes d'offre
Robaws.OfferLineItems
- OfferLineItems : lignes d'offre
Robaws.OfferParameters
- OfferParameters : Paramètres d'offre
Robaws.OfferPhases
- OfferPhases : Phases d'offre
Robaws.Offers
- Offres : Offres
Robaws.PaymentConditions
- PaymentConditions : Conditions de paiement
Robaws.PlaceTransports
- PlaceTransports: Transports de lieu
Robaws.PlanningItemLineItems
- PlanningItemLineItems: Lignes d'éléments de planification
Robaws.PlanningItems
- PlanningItems: Éléments de planification
Robaws.PlanningTypes
- PlanningTypes: Types de planification
Robaws.PostCalculationLineItems
- PostCalculationLineItems: Lignes de calcul a posteriori
Robaws.PostParameters
- PostParameters : Paramètres de publication
Robaws.Posts
- Posts : Messages
Robaws.PriceGroups
- PriceGroups : groupes de prix
Robaws.PriceRequestLineItems
- PriceRequestLineItems: Lignes de demande de prix
Robaws.PriceRequests
- PriceRequests : Demandes de prix
Robaws.ProjectConstructionPartners
- ProjectConstructionPartners : Partenaires de construction de projet
Robaws.ProjectPhases
- ProjectPhases: Phases de projet
Robaws.ProjectSupplyRoutes
- ProjectSupplyRoutes: Routes d'approvisionnement de projet
Robaws.Projects
- Projects : Projets
Robaws.PurchaseInvoiceLineItems
- PurchaseInvoiceLineItems : Lignes de facture d'achat
Robaws.PurchaseInvoices
- PurchaseInvoices : Factures d'achat
Robaws.PurchaseSupplyOrderLineItems
- PurchaseSupplyOrderLineItems: Lignes d'ordre d'achat
Robaws.PurchaseSupplyOrders
- PurchaseSupplyOrders : Commandes d'approvisionnement d'achat
Robaws.RecurrenceTypes
- RecurrenceTypes : Types de récurrence
Robaws.RentalSupplyOrderLineItems
- RentalSupplyOrderLineItems: Lignes d'ordre de location
Robaws.RentalTariffExtraServiceOverrides
- RentalTariffExtraServiceOverrides: Remplacements de services supplémentaires de tarif de location
Robaws.RentalTariffExtraServices
- RentalTariffExtraServices: Services supplémentaires de tarif de location
Robaws.RentalTariffTiers
- RentalTariffTiers : Paliers de tarifs de location
Robaws.RentalTariffs
- RentalTariffs : Tarifs de location
Robaws.RentalTicketLineItems
- RentalTicketLineItems : Lignes de ticket de location
Robaws.RentalTickets
- RentalTickets: Tickets de location
Robaws.ResourceTypeMetadata
- ResourceTypes : Types de ressources
Robaws.SalesInvoiceLineItems
- SalesInvoiceLineItems : Lignes de facture de vente
Robaws.SalesInvoices
- SalesInvoices : Factures de vente
Robaws.SalesOrderLineItems
- SalesOrderLineItems : Lignes de commande client
Robaws.SalesOrders
- SalesOrders: Commandes client
Robaws.ScheduledMaintenances
- ScheduledMaintenances: Maintenances planifiées
Robaws.SettlementCalculationLineItems
- SettlementCalculationLineItems : Lignes de calcul de règlement
Robaws.SettlementLineItemParameters
- SettlementLineItemParameters : paramètres des lignes de règlement
Robaws.SettlementLineItems
- SettlementLineItems : Lignes de règlement
Robaws.SettlementParameters
- SettlementParameters : Paramètres de règlement
Robaws.SettlementPhases
- SettlementPhases: Phases de règlement
Robaws.Settlements
- Règlements : Règlements
Robaws.StockChangeLineItems
- StockChangeLineItems: Lignes de mouvement de stock
Robaws.StockChangeMaterialItems
- StockChangeMaterialItems: Éléments matériels de mouvement de stock
Robaws.StockChanges
- StockChangeFromSupplyOrder: Mouvements de stock depuis ordre d'approvisionnement
- StockChanges: Mouvements de stock
Robaws.StockLocations
- StockLocations : Emplacements de stock
Robaws.StockReservations
- StockReservations: Réservations de stock
Robaws.SubcontractorSupplyOrderLineItems
- SubcontractorSupplyOrderLineItems : lignes d'ordres d'approvisionnement de sous-traitance
Robaws.SubcontractorSupplyOrders
- SubcontractorSupplyOrders: Ordres d'approvisionnement sous-traitants
Robaws.SubscriptionLineItems
- SubscriptionLineItems: Lignes d'abonnement
Robaws.Subscriptions
- Subscriptions : Abonnements
Robaws.SupplierPriceRequests
- SupplierPriceRequests: Demandes de prix fournisseur
Robaws.Suppliers
- Suppliers: Fournisseurs
Robaws.SupplyOrders
- SupplyOrders : Commandes d'approvisionnement
Robaws.Tasks
- Tâches: Tâches
Robaws.Tenants
- Tenants: Locataires
Robaws.TimeOffCategories
- TimeOffCategories : catégories d'absence
Robaws.TimeOffRequests
- TimeOffRequests : Demandes de congé
Robaws.TimeRegistrations
- TimeRegistrations: Enregistrements de temps
Robaws.TransportSupplyOrderLineItems
- TransportSupplyOrderLineItems : Lignes de commandes d'approvisionnement de transport
Robaws.TransportSupplyOrders
- TransportSupplyOrders: Ordres d'approvisionnement de transport
Robaws.Transports
- Transports : Transports
Robaws.Users
- Users: Utilisateurs
Robaws.VatTariffs
- VatTariffs : Taux de TVA
Robaws.Webhooks
- WebhookEndpoints: Points de terminaison de webhook
Robaws.WeeklySchedules
- WeeklySchedules: Plannings hebdomadaires
Robaws.WhoAmI
- Whoami: Qui suis-je
Robaws.WorkOrderCommuteEntries
- WorkOrderCommuteEntries : Entrées de trajet domicile-travail des ordres de travail
Robaws.WorkOrderLineItems
- WorkOrderLineItems : lignes d'ordre de travail
Robaws.WorkOrderMaterialEntries
- WorkOrderMaterialEntries: Saisies de matériel d'ordre de travail
Robaws.WorkOrderTimeEntries
- WorkOrderTimeEntries: Entrées de temps d'ordre de travail
Robaws.WorkOrders
- WorkOrders : ordres de travail
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 :