Robaws Data Model
Software de contabilidad para empresas de construcción y basadas en proyectos.
Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/robaws
The data is partitioned per partition (COMPANY_CODE).
Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.
Plataforma
- Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
- Tipo: una aplicación a la que se accede a través de su API.
- Los datos se agrupan por categorías, como por empresa o por administración.
- Los datos se pueden leer y escribir.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Estado de la plataforma: https://status.robaws.be/nl/.
- Language of its user community: Dutch.
Cifras
| Figure | Count |
|---|---|
| Tables | 127 |
| Columns | 3,097 |
| Tablas con inserciones | 69 |
| Tablas con actualización | 64 |
| Tablas con la instrucción «DELETE» | 68 |
| Tablas documentadas | 3 |
Póster del Modelo de Datos
En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.
El póster en forma de texto: tablas por tema y sus relaciones
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
Almacén
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
Empleado
EmployeeCertificates, EmployeeRoles, Employees
NATIVEPLATFORMSCALARREQUESTS (sin relaciones)
Tenant (sin relaciones)
Webhook (sin relaciones)
Relaciones
- Absences → Employees (descrito con palabras): The referenced row, for 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 (clave)
- Absences → PlanningItems (clave)
- ArticleGroups → ArticleGroups (clave)
- ArticleSuppliers → Suppliers (descrito con palabras): The referenced row, for 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 (clave)
- ClaimStateLineItems → VatTariffs (clave)
- ClaimStates → Users (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- Clients → PriceGroups (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- DeliveryNotes → Clients (clave)
- DeliveryNotes → Companies (clave)
- DeliveryNotes → Contacts (clave)
- DeliveryNotes → Projects (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- DeliveryNotes → Users (descrito con palabras): The referenced row, for 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 (clave)
- Employees → Companies (clave)
- Employees → EmployeeRoles (clave)
- Employees → StockLocations (clave)
- Employees → Suppliers (clave)
- Installations → Clients (descrito con palabras): The referenced row, for 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 (clave)
- Installations → Employees (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- Installations → Subscriptions (descrito con palabras): The referenced row, for 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 (clave, 2 keys)
- Materials → Clients (clave)
- Materials → Companies (clave)
- Materials → Employees (clave)
- Materials → Projects (descrito con palabras): The referenced row, for 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 (clave)
- Materials → Suppliers (clave, 2 keys)
- Offers → Clients (clave)
- Offers → Clients (descrito con palabras): The referenced row, for 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 (clave)
- Offers → Contacts (clave)
- Offers → Contacts (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave, 2 keys)
- PlanningItems → Companies (clave)
- PlanningItems → Contacts (clave, 2 keys)
- PlanningItems → ExecutionPhases (clave)
- PlanningItems → PlanningItems (clave)
- PlanningItems → PlanningTypes (clave)
- PlanningItems → SalesOrders (clave)
- Posts → ArticleGroups (clave)
- Posts → VatTariffs (clave)
- ProjectConstructionPartners → Contacts (clave)
- ProjectConstructionPartners → Projects (clave)
- ProjectConstructionPartners → Suppliers (clave)
- Projects → Clients (descrito con palabras, 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 (clave)
- Projects → Contacts (clave)
- Projects → Contacts (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- PurchaseInvoices → PaymentConditions (clave)
- PurchaseInvoices → Suppliers (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- SalesInvoiceLineItems → Installations (clave)
- SalesInvoiceLineItems → Projects (descrito con palabras): The referenced row, for 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 (clave)
- SalesInvoiceLineItems → WorkOrders (clave)
- SalesInvoices → Clients (descrito con palabras): The referenced row, for 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 (clave)
- SalesInvoices → DeliveryNotes (clave)
- SalesInvoices → SalesInvoices (descrito con palabras): The referenced row, for 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 (clave)
- SalesInvoices → Users (descrito con palabras): The referenced row, for 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 (clave)
- SalesOrders → Clients (descrito con palabras): The referenced row, for 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 (clave)
- SalesOrders → Contacts (clave)
- SalesOrders → Contacts (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- SalesOrders → Users (descrito con palabras): The referenced row, for 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 (clave)
- SettlementLineItems → Settlements (clave)
- SettlementLineItems → VatTariffs (descrito con palabras): The referenced row, for 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 (clave)
- Settlements → Clients (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- Settlements → Contacts (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- StockChanges → Employees (clave)
- StockChanges → SalesOrders (clave)
- StockChanges → StockLocations (clave, 2 keys)
- StockChanges → Suppliers (clave)
- StockChanges → Users (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- SubscriptionLineItems → Subscriptions (clave)
- SubscriptionLineItems → VatTariffs (descrito con palabras): The referenced row, for 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 (clave)
- Subscriptions → Clients (descrito con palabras): The referenced row, for 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 (clave)
- Subscriptions → Contacts (clave, 2 keys)
- Subscriptions → Users (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- Tasks → Users (descrito con palabras, 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 (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (descrito con palabras): The referenced row, for 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 (clave)
- Transports → Employees (clave)
- Transports → Materials (descrito con palabras): The referenced row, for 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 (clave, 2 keys)
- WorkOrderCommuteEntries → Employees (descrito con palabras): The referenced row, for 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 (clave)
- WorkOrderLineItems → WorkOrders (clave)
- WorkOrderMaterialEntries → Materials (descrito con palabras): The referenced row, for 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 (clave)
- WorkOrderTimeEntries → Employees (descrito con palabras): The referenced row, for 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 (clave)
- WorkOrderTimeEntries → WorkOrders (clave)
- WorkOrders → Clients (clave)
- WorkOrders → Clients (descrito con palabras): The referenced row, for 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 (clave)
- WorkOrders → SalesOrders (clave)
- WorkOrders → Users (descrito con palabras): The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it.
Tablas
Robaws.Absences
- Absences: Absences
Robaws.Activities
- Activities: Activities
Robaws.ApprovalRequestRules
- ApprovalRequestRules: Approval Request Rules
Robaws.ApprovalRequests
- ApprovalRequests: Approval Requests
Robaws.ArticleAdditionalItems
- ArticleAdditionalItems: Article Additional Items
Robaws.ArticleGroups
- ArticleGroups: Article Groups
Robaws.ArticleSuppliers
- ArticleSuppliers: Article Suppliers
Robaws.ArticleTierPrices
- ArticleTierPrices: Article Tier Prices
Robaws.Articles
- ArticleStockMovements: Article Stock Movements
- Articles: Articles
Robaws.BankPayments
- BankPayments: Bank Payments
Robaws.BudgetAdjustments
- BudgetAdjustments: Budget Adjustments
Robaws.CallOffSupplyOrderLineItems
- CallOffSupplyOrderLineItems: Call-Off Supply Order Line Items
Robaws.CallOffSupplyOrders
- CallOffSupplyOrders: Call-Off Supply Orders
Robaws.CashEntries
- CashEntries: Cash Entries
Robaws.CashRegisterClosings
- CashRegisterClosings: Cash Register Closings
Robaws.CashRegisters
- CashRegisters: Cash Registers
Robaws.ClaimStateLineItems
- ClaimStateLineItems: Claim State Line Items
Robaws.ClaimStates
- ClaimStates: Claim States
Robaws.Clients
- Clients: Customers
Robaws.Companies
- Companies: Companies
Robaws.Contacts
- Contacts: Contacts
Robaws.DayPlanningResources
- DayPlanningResources: Day Planning Resources
Robaws.DeliveryNoteLineItems
- DeliveryNoteLineItems: Delivery Note Line Items
Robaws.DeliveryNotes
- DeliveryNotes: Delivery Notes
Robaws.EmployeeCertificates
- EmployeeCertificates: Employee Certificates
Robaws.EmployeeRole
- EmployeeRoles: Employee Roles
Robaws.Employees
- Employees: Employees
Robaws.ExecutionPhases
- ExecutionPhases: Execution Phases
Robaws.ExtraFields
- ResourceTypeExtraFields: Resource Type Extra Fields
Robaws.FormAnswers
- FormAnswers: Form Answers
Robaws.FormElementAnswersFromFormAnswer
- FormAnswerFormElementAnswers: Form Answer Form Element Answers
Robaws.FormTemplates
- FormTemplateRevisions: Form Template Revisions
- FormTemplates: Form Templates
Robaws.GeneralLedgerAccounts
- GeneralLedgerAccounts: General Ledger Accounts
Robaws.HourTypes
- HourTypes: Hour Types
Robaws.ImportJobs
- ImportJobMessages: Import Job Messages
- ImportJobs: Import Jobs
Robaws.Inboxes
- Inboxes: Inboxes
Robaws.InstallationCertificates
- InstallationCertificates: Installation Certificates
Robaws.Installations
- Installations: Installations
Robaws.InternalSupplyOrderLineItems
- InternalSupplyOrderLineItems: Internal Supply Order Line Items
Robaws.InternalSupplyOrders
- InternalSupplyOrders: Internal Supply Orders
Robaws.Journals
- Journals: Journals
Robaws.LegalForms
- LegalForms: Legal Forms
Robaws.MaintenanceSchedules
- MaintenanceSchedules: Maintenance Schedules
Robaws.MaterialCertificates
- MaterialCertificates: Material Certificates
Robaws.Materials
- Materials: Materials
Robaws.MobilityTypes
- MobilityTypes: Mobility Types
Robaws.Native
- NATIVEPLATFORMSCALARREQUESTS: Solicitudes escalares de plataformas nativas
Robaws.Notifications
- Notifications: Notifications
Robaws.OfferCalculationLineItems
- OfferCalculationLineItems: Offer Calculation Line Items
Robaws.OfferLineItemParameters
- OfferLineItemParameters: Offer Line Item Parameters
Robaws.OfferLineItems
- OfferLineItems: Offer Line Items
Robaws.OfferParameters
- OfferParameters: Offer Parameters
Robaws.OfferPhases
- OfferPhases: Offer Phases
Robaws.Offers
- Offers: Offers
Robaws.PaymentConditions
- PaymentConditions: Payment Conditions
Robaws.PlaceTransports
- PlaceTransports: Place Transports
Robaws.PlanningItemLineItems
- PlanningItemLineItems: Planning Item Line Items
Robaws.PlanningItems
- PlanningItems: Planning Items
Robaws.PlanningTypes
- PlanningTypes: Planning Types
Robaws.PostCalculationLineItems
- PostCalculationLineItems: Post Calculation Line Items
Robaws.PostParameters
- PostParameters: Post Parameters
Robaws.Posts
- Posts: Posts
Robaws.PriceGroups
- PriceGroups: Pricegroups
Robaws.PriceRequestLineItems
- PriceRequestLineItems: Price Request Line Items
Robaws.PriceRequests
- PriceRequests: Price Requests
Robaws.ProjectConstructionPartners
- ProjectConstructionPartners: Project Construction Partners
Robaws.ProjectPhases
- ProjectPhases: Project Phases
Robaws.ProjectSupplyRoutes
- ProjectSupplyRoutes: Project Supply Routes
Robaws.Projects
- Projects: Projects
Robaws.PurchaseInvoiceLineItems
- PurchaseInvoiceLineItems: Purchase Invoice Line Items
Robaws.PurchaseInvoices
- PurchaseInvoices: Purchase Invoices
Robaws.PurchaseSupplyOrderLineItems
- PurchaseSupplyOrderLineItems: Purchase Supply Order Line Items
Robaws.PurchaseSupplyOrders
- PurchaseSupplyOrders: Purchase Supply Orders
Robaws.RecurrenceTypes
- RecurrenceTypes: Recurrence Types
Robaws.RentalSupplyOrderLineItems
- RentalSupplyOrderLineItems: Rental Supply Order Line Items
Robaws.RentalTariffExtraServiceOverrides
- RentalTariffExtraServiceOverrides: Rental Tariff Extra Service Overrides
Robaws.RentalTariffExtraServices
- RentalTariffExtraServices: Rental Tariff Extra Services
Robaws.RentalTariffTiers
- RentalTariffTiers: Rental Tariff Tiers
Robaws.RentalTariffs
- RentalTariffs: Rental Tariffs
Robaws.RentalTicketLineItems
- RentalTicketLineItems: Rental Ticket Line Items
Robaws.RentalTickets
- RentalTickets: Rental Tickets
Robaws.ResourceTypeMetadata
- ResourceTypes: Resource Types
Robaws.SalesInvoiceLineItems
- SalesInvoiceLineItems: Sales Invoice Line Items
Robaws.SalesInvoices
- SalesInvoices: Sales Invoices
Robaws.SalesOrderLineItems
- SalesOrderLineItems: Sales Order Line Items
Robaws.SalesOrders
- SalesOrders: Sales Orders
Robaws.ScheduledMaintenances
- ScheduledMaintenances: Scheduled Maintenances
Robaws.SettlementCalculationLineItems
- SettlementCalculationLineItems: Settlement Calculation Line Items
Robaws.SettlementLineItemParameters
- SettlementLineItemParameters: Settlement Line Item Parameters
Robaws.SettlementLineItems
- SettlementLineItems: Settlement Line Items
Robaws.SettlementParameters
- SettlementParameters: Settlement Parameters
Robaws.SettlementPhases
- SettlementPhases: Settlement Phases
Robaws.Settlements
- Settlements: Settlements
Robaws.StockChangeLineItems
- StockChangeLineItems: Stock Change Line Items
Robaws.StockChangeMaterialItems
- StockChangeMaterialItems: Stock Change Material Items
Robaws.StockChanges
- StockChangeFromSupplyOrder: Stock Changes From Supply Order
- StockChanges: Stock Changes
Robaws.StockLocations
- StockLocations: Stock Locations
Robaws.StockReservations
- StockReservations: Stock Reservations
Robaws.SubcontractorSupplyOrderLineItems
- SubcontractorSupplyOrderLineItems: Subcontractor Supply Order Line Items
Robaws.SubcontractorSupplyOrders
- SubcontractorSupplyOrders: Subcontractor Supply Orders
Robaws.SubscriptionLineItems
- SubscriptionLineItems: Subscription Line Items
Robaws.Subscriptions
- Subscriptions: Subscriptions
Robaws.SupplierPriceRequests
- SupplierPriceRequests: Supplier Price Requests
Robaws.Suppliers
- Suppliers: Suppliers
Robaws.SupplyOrders
- SupplyOrders: Supply Orders
Robaws.Tasks
- Tasks: Tasks
Robaws.Tenants
- Tenants: Tenants
Robaws.TimeOffCategories
- TimeOffCategories: Time Off Categories
Robaws.TimeOffRequests
- TimeOffRequests: Time Off Requests
Robaws.TimeRegistrations
- TimeRegistrations: Time Registrations
Robaws.TransportSupplyOrderLineItems
- TransportSupplyOrderLineItems: Transport Supply Order Line Items
Robaws.TransportSupplyOrders
- TransportSupplyOrders: Transport Supply Orders
Robaws.Transports
- Transports: Transports
Robaws.Users
- Users: Users
Robaws.VatTariffs
- VatTariffs: VAT Tariffs
Robaws.Webhooks
- WebhookEndpoints: Webhook Endpoints
Robaws.WeeklySchedules
- WeeklySchedules: Weekly Schedules
Robaws.WhoAmI
- Whoami: Who Am I
Robaws.WorkOrderCommuteEntries
- WorkOrderCommuteEntries: Work Order Commute Entries
Robaws.WorkOrderLineItems
- WorkOrderLineItems: Work Order Line Items
Robaws.WorkOrderMaterialEntries
- WorkOrderMaterialEntries: Work Order Material Entries
Robaws.WorkOrderTimeEntries
- WorkOrderTimeEntries: Work Order Time Entries
Robaws.WorkOrders
- WorkOrders: Work Orders
Ejemplos 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
Atributos
Las características de esta plataforma se encuentran en la página Attributes.
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: