Robaws-Datenmodell
Buchhaltungssoftware für Bauunternehmen und projektbezogene Unternehmen.
Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/robaws
Die Daten sind pro Partition (COMPANY_CODE) partitioniert.
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
- Daten können sowohl geschrieben als auch gelesen werden.
- Invantive Cloud-Pläne: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status der Plattform: https://status.robaws.be/nl/.
- Sprache ihrer Benutzergemeinschaft: Niederländisch.
Angaben
| Figure | Count |
|---|---|
| Tables | 127 |
| Columns | 3,097 |
| Tabellen mit Einfügung | 69 |
| Tabellen mit Aktualisierung | 64 |
| Tabellen mit Löschfunktion | 68 |
| Tabellen dokumentiert | 3 |
Poster zum Daten Muster
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
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
Lager
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
Mitarbeiter
EmployeeCertificates, EmployeeRoles, Employees
NATIVEPLATFORMSCALARREQUESTS (ohne Beziehungen)
Tenant (ohne Beziehungen)
Webhook (ohne Beziehungen)
Beziehungen
- Absences → Employees (in Worten beschrieben): 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 (Schlüssel)
- Absences → PlanningItems (Schlüssel)
- ArticleGroups → ArticleGroups (Schlüssel)
- ArticleSuppliers → Suppliers (in Worten beschrieben): 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 (Schlüssel)
- ClaimStateLineItems → VatTariffs (Schlüssel)
- ClaimStates → Users (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- Clients → PriceGroups (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- DeliveryNotes → Clients (Schlüssel)
- DeliveryNotes → Companies (Schlüssel)
- DeliveryNotes → Contacts (Schlüssel)
- DeliveryNotes → Projects (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- DeliveryNotes → Users (in Worten beschrieben): 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 (Schlüssel)
- Employees → Companies (Schlüssel)
- Employees → EmployeeRoles (Schlüssel)
- Employees → StockLocations (Schlüssel)
- Employees → Suppliers (Schlüssel)
- Installations → Clients (in Worten beschrieben): 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 (Schlüssel)
- Installations → Employees (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- Installations → Subscriptions (in Worten beschrieben): 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 (Schlüssel, 2 keys)
- Materials → Clients (Schlüssel)
- Materials → Companies (Schlüssel)
- Materials → Employees (Schlüssel)
- Materials → Projects (in Worten beschrieben): 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 (Schlüssel)
- Materials → Suppliers (Schlüssel, 2 keys)
- Offers → Clients (Schlüssel)
- Offers → Clients (in Worten beschrieben): 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 (Schlüssel)
- Offers → Contacts (Schlüssel)
- Offers → Contacts (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel, 2 keys)
- PlanningItems → Companies (Schlüssel)
- PlanningItems → Contacts (Schlüssel, 2 keys)
- PlanningItems → ExecutionPhases (Schlüssel)
- PlanningItems → PlanningItems (Schlüssel)
- PlanningItems → PlanningTypes (Schlüssel)
- PlanningItems → SalesOrders (Schlüssel)
- Posts → ArticleGroups (Schlüssel)
- Posts → VatTariffs (Schlüssel)
- ProjectConstructionPartners → Contacts (Schlüssel)
- ProjectConstructionPartners → Projects (Schlüssel)
- ProjectConstructionPartners → Suppliers (Schlüssel)
- Projects → Clients (in Worten beschrieben, 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 (Schlüssel)
- Projects → Contacts (Schlüssel)
- Projects → Contacts (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- PurchaseInvoices → PaymentConditions (Schlüssel)
- PurchaseInvoices → Suppliers (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- SalesInvoiceLineItems → Installations (Schlüssel)
- SalesInvoiceLineItems → Projects (in Worten beschrieben): 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 (Schlüssel)
- SalesInvoiceLineItems → WorkOrders (Schlüssel)
- SalesInvoices → Clients (in Worten beschrieben): 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 (Schlüssel)
- SalesInvoices → DeliveryNotes (Schlüssel)
- SalesInvoices → SalesInvoices (in Worten beschrieben): 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 (Schlüssel)
- SalesInvoices → Users (in Worten beschrieben): 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 (Schlüssel)
- SalesOrders → Clients (in Worten beschrieben): 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 (Schlüssel)
- SalesOrders → Contacts (Schlüssel)
- SalesOrders → Contacts (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- SalesOrders → Users (in Worten beschrieben): 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 (Schlüssel)
- SettlementLineItems → Settlements (Schlüssel)
- SettlementLineItems → VatTariffs (in Worten beschrieben): 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 (Schlüssel)
- Settlements → Clients (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- Settlements → Contacts (in Worten beschrieben): 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 Worten beschrieben): 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 Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- StockChanges → Employees (Schlüssel)
- StockChanges → SalesOrders (Schlüssel)
- StockChanges → StockLocations (Schlüssel, 2 keys)
- StockChanges → Suppliers (Schlüssel)
- StockChanges → Users (in Worten beschrieben): 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 Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- SubscriptionLineItems → Subscriptions (Schlüssel)
- SubscriptionLineItems → VatTariffs (in Worten beschrieben): 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 (Schlüssel)
- Subscriptions → Clients (in Worten beschrieben): 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 (Schlüssel)
- Subscriptions → Contacts (Schlüssel, 2 keys)
- Subscriptions → Users (in Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- Tasks → Users (in Worten beschrieben, 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 Worten beschrieben): 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 Worten beschrieben): 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 Worten beschrieben): 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 (Schlüssel)
- Transports → Employees (Schlüssel)
- Transports → Materials (in Worten beschrieben): 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 (Schlüssel, 2 keys)
- WorkOrderCommuteEntries → Employees (in Worten beschrieben): 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 (Schlüssel)
- WorkOrderLineItems → WorkOrders (Schlüssel)
- WorkOrderMaterialEntries → Materials (in Worten beschrieben): 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 (Schlüssel)
- WorkOrderTimeEntries → Employees (in Worten beschrieben): 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 (Schlüssel)
- WorkOrderTimeEntries → WorkOrders (Schlüssel)
- WorkOrders → Clients (Schlüssel)
- WorkOrders → Clients (in Worten beschrieben): 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 (Schlüssel)
- WorkOrders → SalesOrders (Schlüssel)
- WorkOrders → Users (in Worten beschrieben): 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: Abwesenheiten
Robaws.Activities
- Activities: Aktivitäten
Robaws.ApprovalRequestRules
- ApprovalRequestRules: Genehmigungsanforderungsregeln
Robaws.ApprovalRequests
- ApprovalRequests: Genehmigungsanfragen
Robaws.ArticleAdditionalItems
- ArticleAdditionalItems: Artikel-Zusatzpositionen
Robaws.ArticleGroups
- ArticleGroups: Artikelgruppen
Robaws.ArticleSuppliers
- ArticleSuppliers: Artikellieferanten
Robaws.ArticleTierPrices
- ArticleTierPrices: Artikel-Staffelpreise
Robaws.Articles
- ArticleStockMovements: Artikelbewegungen
- Artikel: Artikel
Robaws.BankPayments
- BankPayments: Bankzahlungen
Robaws.BudgetAdjustments
- BudgetAdjustments: Budgetanpassungen
Robaws.CallOffSupplyOrderLineItems
- CallOffSupplyOrderLineItems: Abruflieferauftragspositionen
Robaws.CallOffSupplyOrders
- CallOffSupplyOrders: Abrufbestellungen
Robaws.CashEntries
- CashEntries: Kassenbuchungen
Robaws.CashRegisterClosings
- CashRegisterClosings: Kassenabschlüsse
Robaws.CashRegisters
- CashRegisters: Kassen
Robaws.ClaimStateLineItems
- ClaimStateLineItems: Anspruchsstatus-Positionen
Robaws.ClaimStates
- ClaimStates: Anspruchsstatus
Robaws.Clients
- Clients: Kunden
Robaws.Companies
- Firmen: Firmen
Robaws.Contacts
- Contacts: Kontakte
Robaws.DayPlanningResources
- DayPlanningResources: Tagesplanungsressourcen
Robaws.DeliveryNoteLineItems
- DeliveryNoteLineItems: Lieferscheinpositionen
Robaws.DeliveryNotes
- DeliveryNotes: Lieferscheine
Robaws.EmployeeCertificates
- EmployeeCertificates: Mitarbeiterzertifikate
Robaws.EmployeeRole
- EmployeeRoles: Mitarbeiterrollen
Robaws.Employees
- Mitarbeiter: Mitarbeiter
Robaws.ExecutionPhases
- ExecutionPhases: Ausführungsphasen
Robaws.ExtraFields
- ResourceTypeExtraFields: Ressourcentyp-Zusatzfelder
Robaws.FormAnswers
- FormAnswers: Formularantworten
Robaws.FormElementAnswersFromFormAnswer
- FormAnswerFormElementAnswers: Formularantworten Formularelement-Antworten
Robaws.FormTemplates
- FormTemplateRevisions: Formularvorlagenrevisionen
- FormTemplates: Formularvorlagen
Robaws.GeneralLedgerAccounts
- GeneralLedgerAccounts: Hauptbuchkonten
Robaws.HourTypes
- HourTypes: Stundenarten
Robaws.ImportJobs
- ImportJobMessages: Importauftragsnachrichten
- ImportJobs: Importaufträge
Robaws.Inboxes
- Posteingänge: Posteingänge
Robaws.InstallationCertificates
- InstallationCertificates: Installationszertifikate
Robaws.Installations
- Installations: Installationen
Robaws.InternalSupplyOrderLineItems
- InternalSupplyOrderLineItems: Interne Lieferauftragspositionen
Robaws.InternalSupplyOrders
- InternalSupplyOrders: Interne Lieferaufträge
Robaws.Journals
- Journals: Journale
Robaws.LegalForms
- LegalForms: Rechtsformen
Robaws.MaintenanceSchedules
- MaintenanceSchedules: Wartungspläne
Robaws.MaterialCertificates
- MaterialCertificates: Materialzertifikate
Robaws.Materials
- Materialien: Materialien
Robaws.MobilityTypes
- MobilityTypes: Mobilitätstypen
Robaws.Native
- NATIVEPLATFORMSCALARREQUESTS: Skalare Anfragen auf nativen Plattformen
Robaws.Notifications
- Notifications: Benachrichtigungen
Robaws.OfferCalculationLineItems
- OfferCalculationLineItems: Angebotskalkulationspositionen
Robaws.OfferLineItemParameters
- OfferLineItemParameters: Angebotspositionsparameter
Robaws.OfferLineItems
- OfferLineItems: Angebotspositionen
Robaws.OfferParameters
- OfferParameters: Angebotsparameter
Robaws.OfferPhases
- OfferPhases: Angebotsphasen
Robaws.Offers
- Angebote: Angebote
Robaws.PaymentConditions
- PaymentConditions: Zahlungsbedingungen
Robaws.PlaceTransports
- PlaceTransports: Ortstransporte
Robaws.PlanningItemLineItems
- PlanningItemLineItems: Planungselementpositionen
Robaws.PlanningItems
- PlanningItems: Planungselemente
Robaws.PlanningTypes
- PlanningTypes: Planungstypen
Robaws.PostCalculationLineItems
- PostCalculationLineItems: Postkalkulationspositionen
Robaws.PostParameters
- PostParameters: Postparameter
Robaws.Posts
- Posts: Beiträge
Robaws.PriceGroups
- PriceGroups: Preisgruppen
Robaws.PriceRequestLineItems
- PriceRequestLineItems: Preisanfragepositionen
Robaws.PriceRequests
- PriceRequests: Preisanfragen
Robaws.ProjectConstructionPartners
- ProjectConstructionPartners: Projekt-Baupartner
Robaws.ProjectPhases
- ProjectPhases: Projektphasen
Robaws.ProjectSupplyRoutes
- ProjectSupplyRoutes: Projekt-Versorgungswege
Robaws.Projects
- Projects: Projekte
Robaws.PurchaseInvoiceLineItems
- PurchaseInvoiceLineItems: Eingangsrechnungspositionen
Robaws.PurchaseInvoices
- PurchaseInvoices: Einkaufsrechnungen
Robaws.PurchaseSupplyOrderLineItems
- PurchaseSupplyOrderLineItems: Einkaufslieferauftragspositionen
Robaws.PurchaseSupplyOrders
- PurchaseSupplyOrders: Einkaufsbestellungen
Robaws.RecurrenceTypes
- RecurrenceTypes: Wiederholungstypen
Robaws.RentalSupplyOrderLineItems
- RentalSupplyOrderLineItems: Mietlieferauftragspositionen
Robaws.RentalTariffExtraServiceOverrides
- RentalTariffExtraServiceOverrides: Überschreibungen der Miettarif-Zusatzleistungen
Robaws.RentalTariffExtraServices
- RentalTariffExtraServices: Miettarif-Zusatzleistungen
Robaws.RentalTariffTiers
- RentalTariffTiers: Miettarifstufen
Robaws.RentalTariffs
- RentalTariffs: Mietntarife
Robaws.RentalTicketLineItems
- RentalTicketLineItems: Mietticket-Positionen
Robaws.RentalTickets
- RentalTickets: Mietquittungen
Robaws.ResourceTypeMetadata
- ResourceTypes: Ressourcentypen
Robaws.SalesInvoiceLineItems
- SalesInvoiceLineItems: Verkaufsrechnungspositionen
Robaws.SalesInvoices
- SalesInvoices: Verkaufsrechnungen
Robaws.SalesOrderLineItems
- SalesOrderLineItems: Verkaufsauftragspositionen
Robaws.SalesOrders
- SalesOrders: Verkaufsaufträge
Robaws.ScheduledMaintenances
- ScheduledMaintenances: Geplante Wartungen
Robaws.SettlementCalculationLineItems
- SettlementCalculationLineItems: Abrechnungskalkulationspositionen
Robaws.SettlementLineItemParameters
- SettlementLineItemParameters: Parameter der Abrechnungspositionen
Robaws.SettlementLineItems
- SettlementLineItems: Abrechnungspositionen
Robaws.SettlementParameters
- SettlementParameters: Abrechnungsparameter
Robaws.SettlementPhases
- SettlementPhases: Abrechnungsphasen
Robaws.Settlements
- Settlements: Abrechnungen
Robaws.StockChangeLineItems
- StockChangeLineItems: Lagerbestandsänderungs-Positionen
Robaws.StockChangeMaterialItems
- StockChangeMaterialItems: Materialpositionen der Bestandsänderung
Robaws.StockChanges
- StockChangeFromSupplyOrder: Lagerbestandsänderungen aus Lieferauftrag
- StockChanges: Lagerbestandsänderungen
Robaws.StockLocations
- StockLocations: Lagerorte
Robaws.StockReservations
- StockReservations: Lagerreservierungen
Robaws.SubcontractorSupplyOrderLineItems
- SubcontractorSupplyOrderLineItems: Lieferauftragspositionen des Subunternehmers
Robaws.SubcontractorSupplyOrders
- SubcontractorSupplyOrders: Subunternehmer-Bestellungen
Robaws.SubscriptionLineItems
- SubscriptionLineItems: Abonnementpositionen
Robaws.Subscriptions
- Subscriptions: Abonnements
Robaws.SupplierPriceRequests
- SupplierPriceRequests: Lieferantenpreisanfragen
Robaws.Suppliers
- Suppliers: Lieferanten
Robaws.SupplyOrders
- SupplyOrders: Lieferaufträge
Robaws.Tasks
- Tasks: Aufgaben
Robaws.Tenants
- Tenants: Mandanten
Robaws.TimeOffCategories
- TimeOffCategories: Abwesenheitskategorien
Robaws.TimeOffRequests
- TimeOffRequests: Abwesenheitsanträge
Robaws.TimeRegistrations
- TimeRegistrations: Zeiterfassungen
Robaws.TransportSupplyOrderLineItems
- TransportSupplyOrderLineItems: Transportbestellpositionen
Robaws.TransportSupplyOrders
- TransportSupplyOrders: Transportbestellungen
Robaws.Transports
- Transports: Transporte
Robaws.Users
- Users: Benutzer
Robaws.VatTariffs
- VatTariffs: USt-Tarife
Robaws.Webhooks
- WebhookEndpoints: Webhook-Endpunkte
Robaws.WeeklySchedules
- WeeklySchedules: Wochenpläne
Robaws.WhoAmI
- Whoami: Wer bin ich
Robaws.WorkOrderCommuteEntries
- WorkOrderCommuteEntries: Arbeitsauftrag-Fahrtzeiteinträge
Robaws.WorkOrderLineItems
- WorkOrderLineItems: Arbeitsauftragspositionen
Robaws.WorkOrderMaterialEntries
- WorkOrderMaterialEntries: Materialeinträge des Arbeitsauftrags
Robaws.WorkOrderTimeEntries
- WorkOrderTimeEntries: Arbeitsauftrag-Zeiterfassungen
Robaws.WorkOrders
- WorkOrders: Arbeitsaufträge
Beispiel-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
Attribute
Die Eigenschaften dieser Plattform finden Sie auf der Seite Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: