Modello Dati Robaws
Software di contabilità per aziende edili e basate su progetti.
Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/robaws
I dati sono partizionati per partizione (COMPANY_CODE).
I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.
Piattaforma
- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria API.
- I dati sono suddivisi, ad esempio per azienda o per amministrazione.
- I dati possono essere sia letti che scritti.
- Piani Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Stato della piattaforma: https://status.robaws.be/nl/.
- Lingua della sua comunità di utenti: olandese.
Figure
| Figure | Count |
|---|---|
| Tables | 127 |
| Columns | 3,097 |
| Tabella con inserti | 69 |
| Tabella con aggiornamento | 64 |
| Tabella con la clausola DELETE | 68 |
| Tabella documentata | 3 |
Poster sul modello di dati
Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.
Il poster come testo: tabelle per argomento e le loro relazioni
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
Disponibilità
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
Dipendente
EmployeeCertificates, EmployeeRoles, Employees
NATIVEPLATFORMSCALARREQUESTS (senza relazioni)
Tenant (senza relazioni)
Webhook (senza relazioni)
Relazioni
- Absences → Employees (descritto a parole): 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 (chiave)
- Absences → PlanningItems (chiave)
- ArticleGroups → ArticleGroups (chiave)
- ArticleSuppliers → Suppliers (descritto a parole): 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 (chiave)
- ClaimStateLineItems → VatTariffs (chiave)
- ClaimStates → Users (descritto a parole): 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 (descritto a parole): 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 (chiave)
- Clients → PriceGroups (descritto a parole): 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 (descritto a parole): 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 (chiave)
- DeliveryNotes → Clients (chiave)
- DeliveryNotes → Companies (chiave)
- DeliveryNotes → Contacts (chiave)
- DeliveryNotes → Projects (descritto a parole): 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 (descritto a parole): 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 (chiave)
- DeliveryNotes → Users (descritto a parole): 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 (chiave)
- Employees → Companies (chiave)
- Employees → EmployeeRoles (chiave)
- Employees → StockLocations (chiave)
- Employees → Suppliers (chiave)
- Installations → Clients (descritto a parole): 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 (chiave)
- Installations → Employees (descritto a parole): 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 (descritto a parole): 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 (chiave)
- Installations → Subscriptions (descritto a parole): 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 (chiave, 2 keys)
- Materials → Clients (chiave)
- Materials → Companies (chiave)
- Materials → Employees (chiave)
- Materials → Projects (descritto a parole): 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 (chiave)
- Materials → Suppliers (chiave, 2 keys)
- Offers → Clients (chiave)
- Offers → Clients (descritto a parole): 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 (chiave)
- Offers → Contacts (chiave)
- Offers → Contacts (descritto a parole): 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 (descritto a parole): 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 (chiave, 2 keys)
- PlanningItems → Companies (chiave)
- PlanningItems → Contacts (chiave, 2 keys)
- PlanningItems → ExecutionPhases (chiave)
- PlanningItems → PlanningItems (chiave)
- PlanningItems → PlanningTypes (chiave)
- PlanningItems → SalesOrders (chiave)
- Posts → ArticleGroups (chiave)
- Posts → VatTariffs (chiave)
- ProjectConstructionPartners → Contacts (chiave)
- ProjectConstructionPartners → Projects (chiave)
- ProjectConstructionPartners → Suppliers (chiave)
- Projects → Clients (descritto a parole, 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 (chiave)
- Projects → Contacts (chiave)
- Projects → Contacts (descritto a parole): 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 (descritto a parole): 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 (chiave)
- PurchaseInvoices → PaymentConditions (chiave)
- PurchaseInvoices → Suppliers (descritto a parole): 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 (descritto a parole): 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 (chiave)
- SalesInvoiceLineItems → Installations (chiave)
- SalesInvoiceLineItems → Projects (descritto a parole): 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 (chiave)
- SalesInvoiceLineItems → WorkOrders (chiave)
- SalesInvoices → Clients (descritto a parole): 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 (chiave)
- SalesInvoices → DeliveryNotes (chiave)
- SalesInvoices → SalesInvoices (descritto a parole): 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 (chiave)
- SalesInvoices → Users (descritto a parole): 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 (chiave)
- SalesOrders → Clients (descritto a parole): 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 (chiave)
- SalesOrders → Contacts (chiave)
- SalesOrders → Contacts (descritto a parole): 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 (descritto a parole): 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 (chiave)
- SalesOrders → Users (descritto a parole): 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 (chiave)
- SettlementLineItems → Settlements (chiave)
- SettlementLineItems → VatTariffs (descritto a parole): 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 (chiave)
- Settlements → Clients (descritto a parole): 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 (descritto a parole): 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 (chiave)
- Settlements → Contacts (descritto a parole): 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 (descritto a parole): 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 (descritto a parole): 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 (descritto a parole): 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 (chiave)
- StockChanges → Employees (chiave)
- StockChanges → SalesOrders (chiave)
- StockChanges → StockLocations (chiave, 2 keys)
- StockChanges → Suppliers (chiave)
- StockChanges → Users (descritto a parole): 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 (descritto a parole): 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 (descritto a parole): 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 (chiave)
- SubscriptionLineItems → Subscriptions (chiave)
- SubscriptionLineItems → VatTariffs (descritto a parole): 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 (chiave)
- Subscriptions → Clients (descritto a parole): 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 (chiave)
- Subscriptions → Contacts (chiave, 2 keys)
- Subscriptions → Users (descritto a parole): 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 (descritto a parole): 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 (chiave)
- Tasks → Users (descritto a parole, 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 (descritto a parole): 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 (descritto a parole): 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 (descritto a parole): 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 (chiave)
- Transports → Employees (chiave)
- Transports → Materials (descritto a parole): 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 (chiave, 2 keys)
- WorkOrderCommuteEntries → Employees (descritto a parole): 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 (chiave)
- WorkOrderLineItems → WorkOrders (chiave)
- WorkOrderMaterialEntries → Materials (descritto a parole): 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 (chiave)
- WorkOrderTimeEntries → Employees (descritto a parole): 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 (chiave)
- WorkOrderTimeEntries → WorkOrders (chiave)
- WorkOrders → Clients (chiave)
- WorkOrders → Clients (descritto a parole): 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 (chiave)
- WorkOrders → SalesOrders (chiave)
- WorkOrders → Users (descritto a parole): 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.
Tabelle
Robaws.Absences
- Assenze: Assenze
Robaws.Activities
- Activities: Attività
Robaws.ApprovalRequestRules
- ApprovalRequestRules: Regole delle richieste di approvazione
Robaws.ApprovalRequests
- ApprovalRequests: Richieste di approvazione
Robaws.ArticleAdditionalItems
- ArticleAdditionalItems: Articoli Aggiuntivi
Robaws.ArticleGroups
- ArticleGroups: Gruppi di articoli
Robaws.ArticleSuppliers
- ArticleSuppliers: Fornitori degli articoli
Robaws.ArticleTierPrices
- ArticleTierPrices: Prezzi a scaglioni degli articoli
Robaws.Articles
- ArticleStockMovements: Movimenti di magazzino articoli
- Articles: Articoli
Robaws.BankPayments
- BankPayments: Pagamenti bancari
Robaws.BudgetAdjustments
- BudgetAdjustments: Rettifiche di Budget
Robaws.CallOffSupplyOrderLineItems
- CallOffSupplyOrderLineItems: Righe degli ordini di fornitura a chiamata
Robaws.CallOffSupplyOrders
- CallOffSupplyOrders: Ordini di fornitura a chiamata
Robaws.CashEntries
- CashEntries: Movimenti di cassa
Robaws.CashRegisterClosings
- CashRegisterClosings: Chiusure di cassa
Robaws.CashRegisters
- CashRegisters: Registratori di Cassa
Robaws.ClaimStateLineItems
- ClaimStateLineItems: Righe Stati dei Reclami
Robaws.ClaimStates
- ClaimStates: Stati dei Reclami
Robaws.Clients
- Clienti: Clienti
Robaws.Companies
- Aziende: Aziende
Robaws.Contacts
- Contacts: Contatti
Robaws.DayPlanningResources
- DayPlanningResources: Risorse di Pianificazione Giornaliera
Robaws.DeliveryNoteLineItems
- DeliveryNoteLineItems: Righe dei documenti di trasporto
Robaws.DeliveryNotes
- DeliveryNotes: Documenti di trasporto
Robaws.EmployeeCertificates
- EmployeeCertificates: Certificati dipendenti
Robaws.EmployeeRole
- EmployeeRoles: Ruoli Dipendente
Robaws.Employees
- Employees: Dipendenti
Robaws.ExecutionPhases
- ExecutionPhases: Fasi di Esecuzione
Robaws.ExtraFields
- ResourceTypeExtraFields: Campi extra del tipo di risorsa
Robaws.FormAnswers
- FormAnswers: Risposte al Modulo
Robaws.FormElementAnswersFromFormAnswer
- FormAnswerFormElementAnswers: Risposte agli Elementi del Modulo
Robaws.FormTemplates
- FormTemplateRevisions: Revisioni dei modelli di modulo
- FormTemplates: Modelli di modulo
Robaws.GeneralLedgerAccounts
- GeneralLedgerAccounts: Conti di contabilità generale
Robaws.HourTypes
- HourTypes: Tipi di ore
Robaws.ImportJobs
- ImportJobMessages: Messaggi dei job di importazione
- ImportJobs: Job di importazione
Robaws.Inboxes
- Caselle: Caselle
Robaws.InstallationCertificates
- InstallationCertificates: Certificati di installazione
Robaws.Installations
- Installazioni: Installazioni
Robaws.InternalSupplyOrderLineItems
- InternalSupplyOrderLineItems: Righe degli ordini di fornitura interni
Robaws.InternalSupplyOrders
- InternalSupplyOrders: Ordini di fornitura interni
Robaws.Journals
- Libri giornale: Libri giornale
Robaws.LegalForms
- LegalForms: Forme giuridiche
Robaws.MaintenanceSchedules
- MaintenanceSchedules: Piani di manutenzione
Robaws.MaterialCertificates
- MaterialCertificates: Certificati dei materiali
Robaws.Materials
- Materials: Materiali
Robaws.MobilityTypes
- MobilityTypes: Tipi di Mobilità
Robaws.Native
- NATIVEPLATFORMSCALARREQUESTS: Richieste scalari della piattaforma nativa
Robaws.Notifications
- Notifications: Notifiche
Robaws.OfferCalculationLineItems
- OfferCalculationLineItems: Righe del calcolo dell'offerta
Robaws.OfferLineItemParameters
- OfferLineItemParameters: Parametri delle righe dell'offerta
Robaws.OfferLineItems
- OfferLineItems: Righe dell'offerta
Robaws.OfferParameters
- OfferParameters: Parametri Offerta
Robaws.OfferPhases
- FasiOfferPhases: Fasi offerta
Robaws.Offers
- Offerte: Offerte
Robaws.PaymentConditions
- PaymentConditions: Condizioni di pagamento
Robaws.PlaceTransports
- PlaceTransports: Trasporti di luogo
Robaws.PlanningItemLineItems
- PlanningItemLineItems: Righe degli elementi di pianificazione
Robaws.PlanningItems
- PlanningItems: Elementi di pianificazione
Robaws.PlanningTypes
- PlanningTypes: Tipi di pianificazione
Robaws.PostCalculationLineItems
- PostCalculationLineItems: Righe di Calcolo Post
Robaws.PostParameters
- PostParameters: Parametri Post
Robaws.Posts
- Posts: Post
Robaws.PriceGroups
- PriceGroups: Gruppi di prezzo
Robaws.PriceRequestLineItems
- PriceRequestLineItems: Righe delle richieste di prezzo
Robaws.PriceRequests
- PriceRequests: Richieste di prezzo
Robaws.ProjectConstructionPartners
- ProjectConstructionPartners: Partner di costruzione del progetto
Robaws.ProjectPhases
- ProjectPhases: Fasi progetto
Robaws.ProjectSupplyRoutes
- ProjectSupplyRoutes: Percorsi di fornitura del progetto
Robaws.Projects
- Projects: Progetti
Robaws.PurchaseInvoiceLineItems
- PurchaseInvoiceLineItems: Righe Fatture di Acquisto
Robaws.PurchaseInvoices
- PurchaseInvoices: Fatture di acquisto
Robaws.PurchaseSupplyOrderLineItems
- PurchaseSupplyOrderLineItems: Righe degli ordini di acquisto
Robaws.PurchaseSupplyOrders
- PurchaseSupplyOrders: Ordini di Fornitura Acquisto
Robaws.RecurrenceTypes
- RecurrenceTypes: Tipi di Ricorrenza
Robaws.RentalSupplyOrderLineItems
- RentalSupplyOrderLineItems: Righe degli ordini di noleggio
Robaws.RentalTariffExtraServiceOverrides
- RentalTariffExtraServiceOverrides: Sostituzioni dei servizi extra della tariffa di noleggio
Robaws.RentalTariffExtraServices
- RentalTariffExtraServices: Servizi extra della tariffa di noleggio
Robaws.RentalTariffTiers
- RentalTariffTiers: Scaglioni Tariffe di Noleggio
Robaws.RentalTariffs
- RentalTariffs: Tariffe di Noleggio
Robaws.RentalTicketLineItems
- RentalTicketLineItems: Righe Ticket di Noleggio
Robaws.RentalTickets
- RentalTickets: Ticket di Noleggio
Robaws.ResourceTypeMetadata
- ResourceTypes: Tipi risorsa
Robaws.SalesInvoiceLineItems
- SalesInvoiceLineItems: Righe Fatture di Vendita
Robaws.SalesInvoices
- SalesInvoices: Fatture di vendita
Robaws.SalesOrderLineItems
- SalesOrderLineItems: Righe Ordini di Vendita
Robaws.SalesOrders
- SalesOrders: Ordini cliente
Robaws.ScheduledMaintenances
- ScheduledMaintenances: Manutenzioni Programmate
Robaws.SettlementCalculationLineItems
- SettlementCalculationLineItems: Righe del calcolo di liquidazione
Robaws.SettlementLineItemParameters
- SettlementLineItemParameters: Parametri delle righe di liquidazione
Robaws.SettlementLineItems
- SettlementLineItems: Righe di Liquidazione
Robaws.SettlementParameters
- SettlementParameters: Parametri di Liquidazione
Robaws.SettlementPhases
- SettlementPhases: Fasi di Liquidazione
Robaws.Settlements
- Liquidazioni: Liquidazioni
Robaws.StockChangeLineItems
- StockChangeLineItems: Righe Movimenti di Magazzino
Robaws.StockChangeMaterialItems
- StockChangeMaterialItems: Articoli di variazione di magazzino
Robaws.StockChanges
- StockChangeFromSupplyOrder: Variazioni di magazzino da ordine di fornitura
- StockChanges: Movimenti di Magazzino
Robaws.StockLocations
- StockLocations: Ubicazioni di magazzino
Robaws.StockReservations
- StockReservations: Riserve di Magazzino
Robaws.SubcontractorSupplyOrderLineItems
- SubcontractorSupplyOrderLineItems: Righe degli ordini di fornitura dei subappaltatori
Robaws.SubcontractorSupplyOrders
- SubcontractorSupplyOrders: Ordini di Fornitura ai Subappaltatori
Robaws.SubscriptionLineItems
- SubscriptionLineItems: Righe di Abbonamento
Robaws.Subscriptions
- Subscriptions: Abbonamenti
Robaws.SupplierPriceRequests
- SupplierPriceRequests: Richieste di Prezzo ai Fornitori
Robaws.Suppliers
- Fornitori: Fornitori
Robaws.SupplyOrders
- SupplyOrders: Ordini di Fornitura
Robaws.Tasks
- Attività: Attività
Robaws.Tenants
- Tenant: Tenant
Robaws.TimeOffCategories
- TimeOffCategories: Categorie di assenza
Robaws.TimeOffRequests
- TimeOffRequests: Richieste di assenza
Robaws.TimeRegistrations
- TimeRegistrations: Registrazioni del tempo
Robaws.TransportSupplyOrderLineItems
- TransportSupplyOrderLineItems: Righe degli ordini di fornitura per il trasporto
Robaws.TransportSupplyOrders
- TransportSupplyOrders: Ordini di fornitura di trasporto
Robaws.Transports
- Trasporti: Trasporti
Robaws.Users
- Utenti: Utenti
Robaws.VatTariffs
- VatTariffs: Aliquote IVA
Robaws.Webhooks
- WebhookEndpoints: Endpoint webhook
Robaws.WeeklySchedules
- WeeklySchedules: Pianificazioni Settimanali
Robaws.WhoAmI
- Chi sono io: Chi sono io
Robaws.WorkOrderCommuteEntries
- WorkOrderCommuteEntries: Registrazioni Spostamenti Ordini di Lavoro
Robaws.WorkOrderLineItems
- WorkOrderLineItems: Righe degli ordini di lavoro
Robaws.WorkOrderMaterialEntries
- WorkOrderMaterialEntries: Voci materiali dell'ordine di lavoro
Robaws.WorkOrderTimeEntries
- WorkOrderTimeEntries: Registrazioni Ore Ordini di Lavoro
Robaws.WorkOrders
- WorkOrders: Ordini di lavoro
Esempi di Query
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
Attributi
Le caratteristiche di questa piattaforma sono riportate nella pagina Attributes.
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: