---
title: "Release notes of Gripp CRM"
description: "What changed in the drivers of Invantive UniversalSQL per release: tables, columns, attributes and capabilities, and what to change in statements and connection strings."
language: en
canonical: https://documentation.invantive.eu/en/release-notes/drivers?driver=gripp-crm
---

# Release notes of Gripp CRM

**Drivers:** [ActiveCampaign](/en/release-notes/drivers.md?driver=activecampaign&driver=gripp-crm) | [Autotask](/en/release-notes/drivers.md?driver=autotask&driver=gripp-crm) | [Bouw7](/en/release-notes/drivers.md?driver=bouw7&driver=gripp-crm) | [Brevo](/en/release-notes/drivers.md?driver=brevo&driver=gripp-crm) | [Calendly](/en/release-notes/drivers.md?driver=calendly&driver=gripp-crm) | [CBS](/en/release-notes/drivers.md?driver=cbs&driver=gripp-crm) | [Chargebee](/en/release-notes/drivers.md?driver=chargebee&driver=gripp-crm) | [CompanyInfo](/en/release-notes/drivers.md?driver=companyinfo&driver=gripp-crm) | [Conversion](/en/release-notes/drivers.md?driver=conversion&driver=gripp-crm) | [Crisp](/en/release-notes/drivers.md?driver=crisp&driver=gripp-crm) | [Data Cache](/en/release-notes/drivers.md?driver=data-cache&driver=gripp-crm) | [Data Dictionary](/en/release-notes/drivers.md?driver=data-dictionary&driver=gripp-crm) | [Discourse](/en/release-notes/drivers.md?driver=discourse&driver=gripp-crm) | [Dummy](/en/release-notes/drivers.md?driver=dummy&driver=gripp-crm) | [Easyflex](/en/release-notes/drivers.md?driver=easyflex&driver=gripp-crm) | [ECB Exchange Rates](/en/release-notes/drivers.md?driver=ecb-exchange-rates&driver=gripp-crm) | [Exact Online](/en/release-notes/drivers.md?driver=exact-online&driver=gripp-crm) | [Fortnox](/en/release-notes/drivers.md?driver=fortnox&driver=gripp-crm) | [Freshdesk](/en/release-notes/drivers.md?driver=freshdesk&driver=gripp-crm) | [Freshservice](/en/release-notes/drivers.md?driver=freshservice&driver=gripp-crm) | **[Gripp CRM](/en/release-notes/drivers.md)** (chosen) | [Horeko](/en/release-notes/drivers.md?driver=gripp-crm&driver=horeko) | [HubSpot](/en/release-notes/drivers.md?driver=gripp-crm&driver=hubspot) | [In-Memory Storage](/en/release-notes/drivers.md?driver=gripp-crm&driver=in-memory-storage) | [ionBIZ](/en/release-notes/drivers.md?driver=gripp-crm&driver=ionbiz) | [Kadaster](/en/release-notes/drivers.md?driver=gripp-crm&driver=kadaster) | [KeePass](/en/release-notes/drivers.md?driver=gripp-crm&driver=keepass) | [Knack](/en/release-notes/drivers.md?driver=gripp-crm&driver=knack) | [KOOP (NL) BWB](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-bwb) | [KOOP (NL) CVDR](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-cvdr) | [KOOP (NL) Europese Richtlijnen](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-europese-richtlijnen) | [KOOP (NL) Officiele Publicaties](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-officiele-publicaties) | [KOOP (NL) PLOOI](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-plooi) | [KOOP (NL) PUC Open Data](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-puc-open-data) | [KOOP (NL) Samenwerkende Catalogi](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-samenwerkende-catalogi) | [KOOP (NL) Staatsalmanak](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-staatsalmanak) | [KOOP (NL) Staten Generaal Digitaal](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-staten-generaal-digitaal) | [KOOP (NL) Tuchtrecht](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-tuchtrecht) | [KOOP (NL) Verdragenbank](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-verdragenbank) | [KOOP (NL) Wetgevingskader](/en/release-notes/drivers.md?driver=gripp-crm&driver=koop-nl-wetgevingskader) | [Localazy](/en/release-notes/drivers.md?driver=gripp-crm&driver=localazy) | [LogiusCor](/en/release-notes/drivers.md?driver=gripp-crm&driver=logiuscor) | [Loket.nl REST](/en/release-notes/drivers.md?driver=gripp-crm&driver=loket-nl-rest) | [Mail](/en/release-notes/drivers.md?driver=gripp-crm&driver=mail) | [Minox](/en/release-notes/drivers.md?driver=gripp-crm&driver=minox) | [Mollie](/en/release-notes/drivers.md?driver=gripp-crm&driver=mollie) | [Nmbrs](/en/release-notes/drivers.md?driver=gripp-crm&driver=nmbrs) | [Odoo](/en/release-notes/drivers.md?driver=gripp-crm&driver=odoo) | [Open Exchange Rates](/en/release-notes/drivers.md?driver=gripp-crm&driver=open-exchange-rates) | [OpenArch](/en/release-notes/drivers.md?driver=gripp-crm&driver=openarch) | [OpenSpending](/en/release-notes/drivers.md?driver=gripp-crm&driver=openspending) | [OS](/en/release-notes/drivers.md?driver=gripp-crm&driver=os) | [Outlook](/en/release-notes/drivers.md?driver=gripp-crm&driver=outlook) | [Postman](/en/release-notes/drivers.md?driver=gripp-crm&driver=postman) | [RDW](/en/release-notes/drivers.md?driver=gripp-crm&driver=rdw) | [ROBAWS](/en/release-notes/drivers.md?driver=gripp-crm&driver=robaws) | [Roller](/en/release-notes/drivers.md?driver=gripp-crm&driver=roller) | [Simplicate](/en/release-notes/drivers.md?driver=gripp-crm&driver=simplicate) | [SnelStart](/en/release-notes/drivers.md?driver=gripp-crm&driver=snelstart) | [Teamleader Focus](/en/release-notes/drivers.md?driver=gripp-crm&driver=teamleader-focus) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=gripp-crm&driver=teamleaderorbit) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=gripp-crm&driver=teamleader-orbit) | [Tixly](/en/release-notes/drivers.md?driver=gripp-crm&driver=tixly) | [Tweede Kamer](/en/release-notes/drivers.md?driver=gripp-crm&driver=tweede-kamer) | [Tweede Kamer NL](/en/release-notes/drivers.md?driver=gripp-crm&driver=tweede-kamer-nl) | [Twinfield](/en/release-notes/drivers.md?driver=gripp-crm&driver=twinfield) | [Visma Severa](/en/release-notes/drivers.md?driver=gripp-crm&driver=visma-severa) | [Visma.net Financials](/en/release-notes/drivers.md?driver=gripp-crm&driver=visma-net-financials) | [Visual FoxPro](/en/release-notes/drivers.md?driver=gripp-crm&driver=visual-foxpro) | [Wikipedia](/en/release-notes/drivers.md?driver=gripp-crm&driver=wikipedia) | [Yuki](/en/release-notes/drivers.md?driver=gripp-crm&driver=yuki)

**Releases:** [26.0 to 27.0](/en/release-notes/drivers.md?driver=gripp-crm&step=26.0-to-27.0) | [new in 27.0](/en/release-notes/drivers.md?driver=gripp-crm&step=new-in-27.0)

<div class="rn-block" id="gripp-crm-26.0-to-27.0">

<div class="rn-head">

Driver Release Note - Cloud

## Gripp CRM driver 27.0, from 26.0

| Build | Date | Description |
|---|---|---|
| `26.0.4` | 22-03-2026 | first build of release 26.0 |
| `27.0.93` | 10-11-2026 | latest build of release 27.0 at the time of writing |

Data models compared: `26.0.340-PROD+6295` and `27.0.6-PROD+6293`.

The older end is the first build of release 26.0, not its last, because later builds of 26.0 received ports of changes made for 27.0. The data model of a release is the model that a later build of the same release generated.

- **221** changes
- **213** can break a statement
- **0** groups not available

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

- [By Group](#gripp-crm-26.0-to-27.0-groups)
- [Before You Upgrade](#gripp-crm-26.0-to-27.0-before)
- [Top 14 Changes](#gripp-crm-26.0-to-27.0-top)

**Groups**

- [Data model](#gripp-crm-26.0-to-27.0-g-data_model) 214
- [Provider attributes](#gripp-crm-26.0-to-27.0-g-provider_attributes) 1
- [Capabilities](#gripp-crm-26.0-to-27.0-g-capabilities) 0
- [Performance](#gripp-crm-26.0-to-27.0-g-performance) 2
- [Bug fixes](#gripp-crm-26.0-to-27.0-g-bug_fixes) 1
- [Enhancements](#gripp-crm-26.0-to-27.0-g-enhancements) 3
- [Log-on and platform](#gripp-crm-26.0-to-27.0-g-authentication_platform) 0

**More**

- [In Numbers](#gripp-crm-26.0-to-27.0-numbers)
- [More Information](#gripp-crm-26.0-to-27.0-more)

</div>

<div class="rn-main">

<a id="gripp-crm-26.0-to-27.0-groups"></a>

### What Changed, by Group

Every change is in one group: the group answers the question that you ask before you upgrade.

<div class="rn-cards">

- [Data model](#gripp-crm-26.0-to-27.0-g-data_model)
  - 214
  - **212 can break a statement**
  - Do my statements and views still work?
- [Provider attributes](#gripp-crm-26.0-to-27.0-g-provider_attributes)
  - 1
  - Do I have to change my connection string, provider file or settings?
- [Capabilities](#gripp-crm-26.0-to-27.0-g-capabilities)
  - 0
  - What can the driver do with a table?
- [Performance](#gripp-crm-26.0-to-27.0-g-performance)
  - 2
  - Is it faster, and does it call the platform less?
- [Bug fixes](#gripp-crm-26.0-to-27.0-g-bug_fixes)
  - 1
  - Is the defect that I met repaired?
- [Enhancements](#gripp-crm-26.0-to-27.0-g-enhancements)
  - 3
  - **1 can break a statement**
  - What can I do now that I could not?
- [Log-on and platform](#gripp-crm-26.0-to-27.0-g-authentication_platform)
  - 0
  - Do I have to log on again, or change something because of the platform?

</div>

[Download Changes as CSV](/en/release-notes/drivers/gripp-crm/26.0-to-27.0.csv) | [Data Model of Gripp CRM](/en/datamodels/grippcrm)

<div class="rn-before" id="gripp-crm-26.0-to-27.0-before">

### Before You Upgrade

These changes can stop an existing statement, view, connection string or script from working:

- [Table GrippCrm..AbsenceRequestAbsenceRequestLines is renamed to GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLines](#GRP-27.0-D001)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..AbsenceRequestLines is renamed to GrippCrm.GrippCrm.AbsenceRequestLines](#GRP-27.0-D002)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..AbsenceRequests is renamed to GrippCrm.GrippCrm.AbsenceRequests](#GRP-27.0-D003)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..BulkPrices is renamed to GrippCrm.GrippCrm.BulkPrices](#GRP-27.0-D004)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..CalendarItems is renamed to GrippCrm.GrippCrm.CalendarItems](#GRP-27.0-D005)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Companies is renamed to GrippCrm.GrippCrm.Companies](#GRP-27.0-D006)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..CompanyCompanyRoles is renamed to GrippCrm.GrippCrm.CompanyCompanyRoles](#GRP-27.0-D007)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..CompanyDossierFiles is renamed to GrippCrm.GrippCrm.CompanyDossierFiles](#GRP-27.0-D008)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..CompanyDossiers is renamed to GrippCrm.GrippCrm.CompanyDossiers](#GRP-27.0-D009)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..CompanyFiles is renamed to GrippCrm.GrippCrm.CompanyFiles](#GRP-27.0-D010)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..CompanyTags is renamed to GrippCrm.GrippCrm.CompanyTags](#GRP-27.0-D011)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ContactTags is renamed to GrippCrm.GrippCrm.ContactTags](#GRP-27.0-D012)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Contacts is renamed to GrippCrm.GrippCrm.Contacts](#GRP-27.0-D013)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ContractContractLines is renamed to GrippCrm.GrippCrm.ContractContractLines](#GRP-27.0-D014)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ContractEmployees is renamed to GrippCrm.GrippCrm.ContractEmployees](#GRP-27.0-D015)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ContractEmployeesStarred is renamed to GrippCrm.GrippCrm.ContractEmployeesStarred](#GRP-27.0-D016)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ContractFiles is renamed to GrippCrm.GrippCrm.ContractFiles](#GRP-27.0-D017)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ContractLines is renamed to GrippCrm.GrippCrm.ContractLines](#GRP-27.0-D018)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ContractTags is renamed to GrippCrm.GrippCrm.ContractTags](#GRP-27.0-D019)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Contracts is renamed to GrippCrm.GrippCrm.Contracts](#GRP-27.0-D020)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..CostHeadings is renamed to GrippCrm.GrippCrm.CostHeadings](#GRP-27.0-D021)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Costs is renamed to GrippCrm.GrippCrm.Costs](#GRP-27.0-D022)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Departments is renamed to GrippCrm.GrippCrm.Departments](#GRP-27.0-D023)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..EmployeeFamilies is renamed to GrippCrm.GrippCrm.EmployeeFamilies](#GRP-27.0-D024)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..EmployeeSkills is renamed to GrippCrm.GrippCrm.EmployeeSkills](#GRP-27.0-D025)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..EmployeeTags is renamed to GrippCrm.GrippCrm.EmployeeTags](#GRP-27.0-D026)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..EmployeeTargets is renamed to GrippCrm.GrippCrm.EmployeeTargets](#GRP-27.0-D027)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..EmployeeYearlyLeaveBudgets is renamed to GrippCrm.GrippCrm.EmployeeYearlyLeaveBudgets](#GRP-27.0-D028)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Employees is renamed to GrippCrm.GrippCrm.Employees](#GRP-27.0-D029)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..EmploymentContracts is renamed to GrippCrm.GrippCrm.EmploymentContracts](#GRP-27.0-D030)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ExternalLinks is renamed to GrippCrm.GrippCrm.ExternalLinks](#GRP-27.0-D031)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Files is renamed to GrippCrm.GrippCrm.Files](#GRP-27.0-D032)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Hours is renamed to GrippCrm.GrippCrm.Hours](#GRP-27.0-D033)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..InvoiceFiles is renamed to GrippCrm.GrippCrm.InvoiceFiles](#GRP-27.0-D034)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..InvoiceInvoiceLines is renamed to GrippCrm.GrippCrm.InvoiceInvoiceLines](#GRP-27.0-D035)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..InvoiceLines is renamed to GrippCrm.GrippCrm.InvoiceLines](#GRP-27.0-D036)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..InvoicePayments is renamed to GrippCrm.GrippCrm.InvoicePayments](#GRP-27.0-D037)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..InvoiceTags is renamed to GrippCrm.GrippCrm.InvoiceTags](#GRP-27.0-D038)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Invoices is renamed to GrippCrm.GrippCrm.Invoices](#GRP-27.0-D039)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Ledgers is renamed to GrippCrm.GrippCrm.Ledgers](#GRP-27.0-D040)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..MemorialLines is renamed to GrippCrm.GrippCrm.MemorialLines](#GRP-27.0-D041)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..MemorialTags is renamed to GrippCrm.GrippCrm.MemorialTags](#GRP-27.0-D042)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Memorials is renamed to GrippCrm.GrippCrm.Memorials](#GRP-27.0-D043)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..OfferEmployees is renamed to GrippCrm.GrippCrm.OfferEmployees](#GRP-27.0-D044)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..OfferEmployeesStarred is renamed to GrippCrm.GrippCrm.OfferEmployeesStarred](#GRP-27.0-D045)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..OfferFiles is renamed to GrippCrm.GrippCrm.OfferFiles](#GRP-27.0-D046)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..OfferOfferLines is renamed to GrippCrm.GrippCrm.OfferOfferLines](#GRP-27.0-D047)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..OfferPhases is renamed to GrippCrm.GrippCrm.OfferPhases](#GRP-27.0-D048)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..OfferProjectLines is renamed to GrippCrm.GrippCrm.OfferProjectLines](#GRP-27.0-D049)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..OfferTags is renamed to GrippCrm.GrippCrm.OfferTags](#GRP-27.0-D050)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Offers is renamed to GrippCrm.GrippCrm.Offers](#GRP-27.0-D051)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PacketLines is renamed to GrippCrm.GrippCrm.PacketLines](#GRP-27.0-D052)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PacketPacketLines is renamed to GrippCrm.GrippCrm.PacketPacketLines](#GRP-27.0-D053)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PacketTags is renamed to GrippCrm.GrippCrm.PacketTags](#GRP-27.0-D054)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Packets is renamed to GrippCrm.GrippCrm.Packets](#GRP-27.0-D055)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Payments is renamed to GrippCrm.GrippCrm.Payments](#GRP-27.0-D056)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PriceExceptions is renamed to GrippCrm.GrippCrm.PriceExceptions](#GRP-27.0-D057)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProductAttachmentsExternal is renamed to GrippCrm.GrippCrm.ProductAttachmentsExternal](#GRP-27.0-D058)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProductAttachmentsInternal is renamed to GrippCrm.GrippCrm.ProductAttachmentsInternal](#GRP-27.0-D059)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProductTags is renamed to GrippCrm.GrippCrm.ProductTags](#GRP-27.0-D060)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Products is renamed to GrippCrm.GrippCrm.Products](#GRP-27.0-D061)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProjectEmployees is renamed to GrippCrm.GrippCrm.ProjectEmployees](#GRP-27.0-D062)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProjectEmployeesStarred is renamed to GrippCrm.GrippCrm.ProjectEmployeesStarred](#GRP-27.0-D063)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProjectFiles is renamed to GrippCrm.GrippCrm.ProjectFiles](#GRP-27.0-D064)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProjectPhases is renamed to GrippCrm.GrippCrm.ProjectPhases](#GRP-27.0-D065)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProjectProjectLines is renamed to GrippCrm.GrippCrm.ProjectProjectLines](#GRP-27.0-D066)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..ProjectTags is renamed to GrippCrm.GrippCrm.ProjectTags](#GRP-27.0-D067)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Projects is renamed to GrippCrm.GrippCrm.Projects](#GRP-27.0-D068)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoiceEmployees is renamed to GrippCrm.GrippCrm.PurchaseInvoiceEmployees](#GRP-27.0-D069)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoiceEmployeesStarred is renamed to GrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarred](#GRP-27.0-D070)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoiceFiles is renamed to GrippCrm.GrippCrm.PurchaseInvoiceFiles](#GRP-27.0-D071)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoiceLines is renamed to GrippCrm.GrippCrm.PurchaseInvoiceLines](#GRP-27.0-D072)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoicePurchaseInvoiceLines is renamed to GrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLines](#GRP-27.0-D073)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoicePurchasePayments is renamed to GrippCrm.GrippCrm.PurchaseInvoicePurchasePayments](#GRP-27.0-D074)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoiceTags is renamed to GrippCrm.GrippCrm.PurchaseInvoiceTags](#GRP-27.0-D075)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseInvoices is renamed to GrippCrm.GrippCrm.PurchaseInvoices](#GRP-27.0-D076)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseOrderEmployees is renamed to GrippCrm.GrippCrm.PurchaseOrderEmployees](#GRP-27.0-D077)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseOrderEmployeesStarred is renamed to GrippCrm.GrippCrm.PurchaseOrderEmployeesStarred](#GRP-27.0-D078)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseOrderFiles is renamed to GrippCrm.GrippCrm.PurchaseOrderFiles](#GRP-27.0-D079)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseOrderLines is renamed to GrippCrm.GrippCrm.PurchaseOrderLines](#GRP-27.0-D080)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseOrderPurchaseOrderLines is renamed to GrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLines](#GRP-27.0-D081)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseOrderTags is renamed to GrippCrm.GrippCrm.PurchaseOrderTags](#GRP-27.0-D082)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchaseOrders is renamed to GrippCrm.GrippCrm.PurchaseOrders](#GRP-27.0-D083)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..PurchasePayments is renamed to GrippCrm.GrippCrm.PurchasePayments](#GRP-27.0-D084)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..RejectionReasons is renamed to GrippCrm.GrippCrm.RejectionReasons](#GRP-27.0-D085)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..RevenueTargets is renamed to GrippCrm.GrippCrm.RevenueTargets](#GRP-27.0-D086)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Tags is renamed to GrippCrm.GrippCrm.Tags](#GRP-27.0-D087)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..TaskCalendarItems is renamed to GrippCrm.GrippCrm.TaskCalendarItems](#GRP-27.0-D088)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..TaskFiles is renamed to GrippCrm.GrippCrm.TaskFiles](#GRP-27.0-D089)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..TaskPhases is renamed to GrippCrm.GrippCrm.TaskPhases](#GRP-27.0-D090)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..TaskTypes is renamed to GrippCrm.GrippCrm.TaskTypes](#GRP-27.0-D091)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Tasks is renamed to GrippCrm.GrippCrm.Tasks](#GRP-27.0-D092)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..TimelineEntries is renamed to GrippCrm.GrippCrm.TimelineEntries](#GRP-27.0-D093)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..TimelineEntryFiles is renamed to GrippCrm.GrippCrm.TimelineEntryFiles](#GRP-27.0-D094)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..UmbrellaProjectTags is renamed to GrippCrm.GrippCrm.UmbrellaProjectTags](#GRP-27.0-D095)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..UmbrellaProjects is renamed to GrippCrm.GrippCrm.UmbrellaProjects](#GRP-27.0-D096)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Units is renamed to GrippCrm.GrippCrm.Units](#GRP-27.0-D097)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..Webhooks is renamed to GrippCrm.GrippCrm.Webhooks](#GRP-27.0-D098)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..YearTargetTypes is renamed to GrippCrm.GrippCrm.YearTargetTypes](#GRP-27.0-D099)
  - Check statements, views and scripts that use it before the upgrade.
- [Table GrippCrm..YearTargets is renamed to GrippCrm.GrippCrm.YearTargets](#GRP-27.0-D100)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..AbsenceRequestAbsenceRequestLinesByAbsenceRequestId is renamed to GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLinesByAbsenceRequestId](#GRP-27.0-D101)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..AbsenceRequestById is renamed to GrippCrm.GrippCrm.AbsenceRequestById](#GRP-27.0-D102)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..AbsenceRequestLineById is renamed to GrippCrm.GrippCrm.AbsenceRequestLineById](#GRP-27.0-D103)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..BulkPriceById is renamed to GrippCrm.GrippCrm.BulkPriceById](#GRP-27.0-D104)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CalendarItemById is renamed to GrippCrm.GrippCrm.CalendarItemById](#GRP-27.0-D105)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyByCocNumber is renamed to GrippCrm.GrippCrm.CompanyByCocNumber](#GRP-27.0-D106)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyById is renamed to GrippCrm.GrippCrm.CompanyById](#GRP-27.0-D107)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyCompanyRolesByCompanyId is renamed to GrippCrm.GrippCrm.CompanyCompanyRolesByCompanyId](#GRP-27.0-D108)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyDossierById is renamed to GrippCrm.GrippCrm.CompanyDossierById](#GRP-27.0-D109)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyDossierFilesByCompanyDossierId is renamed to GrippCrm.GrippCrm.CompanyDossierFilesByCompanyDossierId](#GRP-27.0-D110)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyFilesByCompanyId is renamed to GrippCrm.GrippCrm.CompanyFilesByCompanyId](#GRP-27.0-D111)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyTagsByCocNumber is renamed to GrippCrm.GrippCrm.CompanyTagsByCocNumber](#GRP-27.0-D112)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CompanyTagsByCompanyId is renamed to GrippCrm.GrippCrm.CompanyTagsByCompanyId](#GRP-27.0-D113)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContactById is renamed to GrippCrm.GrippCrm.ContactById](#GRP-27.0-D114)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContactTagsByContactId is renamed to GrippCrm.GrippCrm.ContactTagsByContactId](#GRP-27.0-D115)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContractById is renamed to GrippCrm.GrippCrm.ContractById](#GRP-27.0-D116)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContractContractLinesByContractId is renamed to GrippCrm.GrippCrm.ContractContractLinesByContractId](#GRP-27.0-D117)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContractEmployeesByContractId is renamed to GrippCrm.GrippCrm.ContractEmployeesByContractId](#GRP-27.0-D118)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContractEmployeesStarredByContractId is renamed to GrippCrm.GrippCrm.ContractEmployeesStarredByContractId](#GRP-27.0-D119)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContractFilesByContractId is renamed to GrippCrm.GrippCrm.ContractFilesByContractId](#GRP-27.0-D120)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContractLineById is renamed to GrippCrm.GrippCrm.ContractLineById](#GRP-27.0-D121)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ContractTagsByContractId is renamed to GrippCrm.GrippCrm.ContractTagsByContractId](#GRP-27.0-D122)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..CostHeadingById is renamed to GrippCrm.GrippCrm.CostHeadingById](#GRP-27.0-D123)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..DepartmentById is renamed to GrippCrm.GrippCrm.DepartmentById](#GRP-27.0-D124)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..EmployeeById is renamed to GrippCrm.GrippCrm.EmployeeById](#GRP-27.0-D125)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..EmployeeFamilyById is renamed to GrippCrm.GrippCrm.EmployeeFamilyById](#GRP-27.0-D126)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..EmployeeSkillsByEmployeeId is renamed to GrippCrm.GrippCrm.EmployeeSkillsByEmployeeId](#GRP-27.0-D127)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..EmployeeTagsByEmployeeId is renamed to GrippCrm.GrippCrm.EmployeeTagsByEmployeeId](#GRP-27.0-D128)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..EmployeeTargetById is renamed to GrippCrm.GrippCrm.EmployeeTargetById](#GRP-27.0-D129)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..EmployeeYearlyLeaveBudgetById is renamed to GrippCrm.GrippCrm.EmployeeYearlyLeaveBudgetById](#GRP-27.0-D130)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..EmploymentContractById is renamed to GrippCrm.GrippCrm.EmploymentContractById](#GRP-27.0-D131)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..FileContentsById is renamed to GrippCrm.GrippCrm.FileContentsById](#GRP-27.0-D132)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..HourById is renamed to GrippCrm.GrippCrm.HourById](#GRP-27.0-D133)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..InvoiceById is renamed to GrippCrm.GrippCrm.InvoiceById](#GRP-27.0-D134)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..InvoiceFilesByInvoiceId is renamed to GrippCrm.GrippCrm.InvoiceFilesByInvoiceId](#GRP-27.0-D135)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..InvoiceInvoiceLinesByInvoiceId is renamed to GrippCrm.GrippCrm.InvoiceInvoiceLinesByInvoiceId](#GRP-27.0-D136)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..InvoiceLineById is renamed to GrippCrm.GrippCrm.InvoiceLineById](#GRP-27.0-D137)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..InvoicePaymentsByInvoiceId is renamed to GrippCrm.GrippCrm.InvoicePaymentsByInvoiceId](#GRP-27.0-D138)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..InvoiceTagsByInvoiceId is renamed to GrippCrm.GrippCrm.InvoiceTagsByInvoiceId](#GRP-27.0-D139)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..LedgerById is renamed to GrippCrm.GrippCrm.LedgerById](#GRP-27.0-D140)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferById is renamed to GrippCrm.GrippCrm.OfferById](#GRP-27.0-D141)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferEmployeesByOfferId is renamed to GrippCrm.GrippCrm.OfferEmployeesByOfferId](#GRP-27.0-D142)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferEmployeesStarredByOfferId is renamed to GrippCrm.GrippCrm.OfferEmployeesStarredByOfferId](#GRP-27.0-D143)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferFilesByOfferId is renamed to GrippCrm.GrippCrm.OfferFilesByOfferId](#GRP-27.0-D144)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferOfferLinesByOfferId is renamed to GrippCrm.GrippCrm.OfferOfferLinesByOfferId](#GRP-27.0-D145)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferPhaseById is renamed to GrippCrm.GrippCrm.OfferPhaseById](#GRP-27.0-D146)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferProjectLineById is renamed to GrippCrm.GrippCrm.OfferProjectLineById](#GRP-27.0-D147)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..OfferTagsByOfferId is renamed to GrippCrm.GrippCrm.OfferTagsByOfferId](#GRP-27.0-D148)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PacketById is renamed to GrippCrm.GrippCrm.PacketById](#GRP-27.0-D149)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PacketLineById is renamed to GrippCrm.GrippCrm.PacketLineById](#GRP-27.0-D150)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PacketPacketLinesByPacketId is renamed to GrippCrm.GrippCrm.PacketPacketLinesByPacketId](#GRP-27.0-D151)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PacketTagsByPacketId is renamed to GrippCrm.GrippCrm.PacketTagsByPacketId](#GRP-27.0-D152)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PaymentById is renamed to GrippCrm.GrippCrm.PaymentById](#GRP-27.0-D153)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PriceExceptionById is renamed to GrippCrm.GrippCrm.PriceExceptionById](#GRP-27.0-D154)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProductAttachmentsExternalByProductId is renamed to GrippCrm.GrippCrm.ProductAttachmentsExternalByProductId](#GRP-27.0-D155)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProductAttachmentsInternalByProductId is renamed to GrippCrm.GrippCrm.ProductAttachmentsInternalByProductId](#GRP-27.0-D156)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProductById is renamed to GrippCrm.GrippCrm.ProductById](#GRP-27.0-D157)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProductTagsByProductId is renamed to GrippCrm.GrippCrm.ProductTagsByProductId](#GRP-27.0-D158)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProjectById is renamed to GrippCrm.GrippCrm.ProjectById](#GRP-27.0-D159)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProjectEmployeesByProjectId is renamed to GrippCrm.GrippCrm.ProjectEmployeesByProjectId](#GRP-27.0-D160)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProjectEmployeesStarredByProjectId is renamed to GrippCrm.GrippCrm.ProjectEmployeesStarredByProjectId](#GRP-27.0-D161)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProjectFilesByProjectId is renamed to GrippCrm.GrippCrm.ProjectFilesByProjectId](#GRP-27.0-D162)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProjectPhaseById is renamed to GrippCrm.GrippCrm.ProjectPhaseById](#GRP-27.0-D163)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProjectProjectLinesByProjectId is renamed to GrippCrm.GrippCrm.ProjectProjectLinesByProjectId](#GRP-27.0-D164)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ProjectTagsByProjectId is renamed to GrippCrm.GrippCrm.ProjectTagsByProjectId](#GRP-27.0-D165)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoiceById is renamed to GrippCrm.GrippCrm.PurchaseInvoiceById](#GRP-27.0-D166)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoiceEmployeesByPurchaseInvoiceId is renamed to GrippCrm.GrippCrm.PurchaseInvoiceEmployeesByPurchaseInvoiceId](#GRP-27.0-D167)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoiceEmployeesStarredByPurchaseInvoiceId is renamed to GrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarredByPurchaseInvoiceId](#GRP-27.0-D168)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoiceFilesByPurchaseInvoiceId is renamed to GrippCrm.GrippCrm.PurchaseInvoiceFilesByPurchaseInvoiceId](#GRP-27.0-D169)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoiceLineById is renamed to GrippCrm.GrippCrm.PurchaseInvoiceLineById](#GRP-27.0-D170)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoicePurchaseInvoiceLinesByPurchaseInvoiceId is renamed to GrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLinesByPurchaseInvoiceId](#GRP-27.0-D171)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoicePurchasePaymentsByPurchaseInvoiceId is renamed to GrippCrm.GrippCrm.PurchaseInvoicePurchasePaymentsByPurchaseInvoiceId](#GRP-27.0-D172)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseInvoiceTagsByPuchaseInvoiceId is renamed to GrippCrm.GrippCrm.PurchaseInvoiceTagsByPuchaseInvoiceId](#GRP-27.0-D173)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseOrderById is renamed to GrippCrm.GrippCrm.PurchaseOrderById](#GRP-27.0-D174)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseOrderEmployeesByPurchaseOrderId is renamed to GrippCrm.GrippCrm.PurchaseOrderEmployeesByPurchaseOrderId](#GRP-27.0-D175)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseOrderEmployeesStarredByPurchaseOrderId is renamed to GrippCrm.GrippCrm.PurchaseOrderEmployeesStarredByPurchaseOrderId](#GRP-27.0-D176)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseOrderFilesByPurchaseOrderId is renamed to GrippCrm.GrippCrm.PurchaseOrderFilesByPurchaseOrderId](#GRP-27.0-D177)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseOrderLineById is renamed to GrippCrm.GrippCrm.PurchaseOrderLineById](#GRP-27.0-D178)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseOrderPurchaseOrderLinesByPurchaseOrderId is renamed to GrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLinesByPurchaseOrderId](#GRP-27.0-D179)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchaseOrderTagsByPurchaseOrderId is renamed to GrippCrm.GrippCrm.PurchaseOrderTagsByPurchaseOrderId](#GRP-27.0-D180)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..PurchasePaymentById is renamed to GrippCrm.GrippCrm.PurchasePaymentById](#GRP-27.0-D181)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..RejectionReasonById is renamed to GrippCrm.GrippCrm.RejectionReasonById](#GRP-27.0-D182)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..RevenueTargetById is renamed to GrippCrm.GrippCrm.RevenueTargetById](#GRP-27.0-D183)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TagById is renamed to GrippCrm.GrippCrm.TagById](#GRP-27.0-D184)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TaskById is renamed to GrippCrm.GrippCrm.TaskById](#GRP-27.0-D185)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TaskCalendarItemsByTaskId is renamed to GrippCrm.GrippCrm.TaskCalendarItemsByTaskId](#GRP-27.0-D186)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TaskFilesByTaskId is renamed to GrippCrm.GrippCrm.TaskFilesByTaskId](#GRP-27.0-D187)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TaskPhaseById is renamed to GrippCrm.GrippCrm.TaskPhaseById](#GRP-27.0-D188)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TaskTypeById is renamed to GrippCrm.GrippCrm.TaskTypeById](#GRP-27.0-D189)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TimelineEntryById is renamed to GrippCrm.GrippCrm.TimelineEntryById](#GRP-27.0-D190)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..TimelineEntryFilesByTimelineEntryId is renamed to GrippCrm.GrippCrm.TimelineEntryFilesByTimelineEntryId](#GRP-27.0-D191)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..UmbrellaProjectById is renamed to GrippCrm.GrippCrm.UmbrellaProjectById](#GRP-27.0-D192)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..UmbrellaProjectTagsByUmbrellaProjectId is renamed to GrippCrm.GrippCrm.UmbrellaProjectTagsByUmbrellaProjectId](#GRP-27.0-D193)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..UnitById is renamed to GrippCrm.GrippCrm.UnitById](#GRP-27.0-D194)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..ViewOnlineUrlById is renamed to GrippCrm.GrippCrm.ViewOnlineUrlById](#GRP-27.0-D195)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..WebhookById is renamed to GrippCrm.GrippCrm.WebhookById](#GRP-27.0-D196)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..WorkingHoursByEmployeeId is renamed to GrippCrm.GrippCrm.WorkingHoursByEmployeeId](#GRP-27.0-D197)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..YearTargetById is renamed to GrippCrm.GrippCrm.YearTargetById](#GRP-27.0-D198)
  - Check statements, views and scripts that use it before the upgrade.
- [Table function GrippCrm..YearTargetTypeById is renamed to GrippCrm.GrippCrm.YearTargetTypeById](#GRP-27.0-D199)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..CompanyCustomFieldValues is renamed to GrippCrm.GrippCrm.CompanyCustomFieldValues](#GRP-27.0-D200)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..ContactCustomFieldValues is renamed to GrippCrm.GrippCrm.ContactCustomFieldValues](#GRP-27.0-D201)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..ContractCustomFieldValues is renamed to GrippCrm.GrippCrm.ContractCustomFieldValues](#GRP-27.0-D202)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..EmployeeCustomFieldValues is renamed to GrippCrm.GrippCrm.EmployeeCustomFieldValues](#GRP-27.0-D203)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..FileContents is renamed to GrippCrm.GrippCrm.FileContents](#GRP-27.0-D204)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..InvoiceCustomFieldValues is renamed to GrippCrm.GrippCrm.InvoiceCustomFieldValues](#GRP-27.0-D205)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..OfferCustomFieldValues is renamed to GrippCrm.GrippCrm.OfferCustomFieldValues](#GRP-27.0-D206)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..ProductCustomFieldValues is renamed to GrippCrm.GrippCrm.ProductCustomFieldValues](#GRP-27.0-D207)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..ProjectCustomFieldValues is renamed to GrippCrm.GrippCrm.ProjectCustomFieldValues](#GRP-27.0-D208)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..PurchaseInvoiceCustomFieldValues is renamed to GrippCrm.GrippCrm.PurchaseInvoiceCustomFieldValues](#GRP-27.0-D209)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..PurchaseOrderCustomFieldValues is renamed to GrippCrm.GrippCrm.PurchaseOrderCustomFieldValues](#GRP-27.0-D210)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..TaskCustomFieldValues is renamed to GrippCrm.GrippCrm.TaskCustomFieldValues](#GRP-27.0-D211)
  - Check statements, views and scripts that use it before the upgrade.
- [View GrippCrm..UmbrellaProjectCustomFieldValues is renamed to GrippCrm.GrippCrm.UmbrellaProjectCustomFieldValues](#GRP-27.0-D212)
  - Check statements, views and scripts that use it before the upgrade.
- [Gripp CRM schema name added to all tables, views and table functions](#GRP-27.0-E001)
  - Check statements, views and scripts that name Gripp CRM objects with a catalogue and an empty schema, and change them to the form with the schema GrippCrm.

</div>

<a id="gripp-crm-26.0-to-27.0-top"></a>

### Top 14 Changes

Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.

<div class="rn-top">

1. [Table GrippCrm..AbsenceRequestAbsenceRequestLines is renamed to GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLines](#GRP-27.0-D001)
   - *Data model*
   - Breaks an existing statement or script.
2. [Table GrippCrm..AbsenceRequestLines is renamed to GrippCrm.GrippCrm.AbsenceRequestLines](#GRP-27.0-D002)
   - *Data model*
   - Breaks an existing statement or script.
3. [Table GrippCrm..AbsenceRequests is renamed to GrippCrm.GrippCrm.AbsenceRequests](#GRP-27.0-D003)
   - *Data model*
   - Breaks an existing statement or script.
4. [Table GrippCrm..BulkPrices is renamed to GrippCrm.GrippCrm.BulkPrices](#GRP-27.0-D004)
   - *Data model*
   - Breaks an existing statement or script.
5. [Table GrippCrm..CalendarItems is renamed to GrippCrm.GrippCrm.CalendarItems](#GRP-27.0-D005)
   - *Data model*
   - Breaks an existing statement or script.
6. [Table GrippCrm..Companies is renamed to GrippCrm.GrippCrm.Companies](#GRP-27.0-D006)
   - *Data model*
   - Breaks an existing statement or script.
7. [Table GrippCrm..CompanyCompanyRoles is renamed to GrippCrm.GrippCrm.CompanyCompanyRoles](#GRP-27.0-D007)
   - *Data model*
   - Breaks an existing statement or script.
8. [Table GrippCrm..CompanyDossierFiles is renamed to GrippCrm.GrippCrm.CompanyDossierFiles](#GRP-27.0-D008)
   - *Data model*
   - Breaks an existing statement or script.
9. [Gripp CRM schema name added to all tables, views and table functions](#GRP-27.0-E001)
   - *Enhancements*
   - Breaks an existing statement or script.
10. [Gripp CRM covers more entities, file contents and custom fields, and counts in one call](#GRP-27.0-E002)
    - *Enhancements*
    - Importance 4 of 5.
11. [Reading stops as soon as the requested number of rows has been fetched](#GRP-27.0-P001)
    - *Performance*
    - Importance 3 of 5.
12. [Filters that Gripp CRM cannot apply are no longer sent to it](#GRP-27.0-B001)
    - *Bug fixes*
    - Importance 3 of 5.
13. [Lower memory use when reading JSON answers](#GRP-27.0-P002)
    - *Performance*
    - Importance 2 of 5.
14. [Throughput figures of Gripp CRM tables included](#GRP-27.0-E003)
    - *Enhancements*
    - Importance 2 of 5.

</div>

<a id="gripp-crm-26.0-to-27.0-g-data_model"></a>

### Data model

Do my statements and views still work? Tables, views, table functions, columns, parameters, keys, code values, packages and procedures that appear, disappear, are renamed or change type.

<div class="rn-chips">

- 214 changes
- model files

</div>

#### Tables, Views and Table Functions

<a id="GRP-27.0-D001"></a><a id="GRP-27.0-D101"></a><a id="GRP-27.0-D102"></a><a id="GRP-27.0-D103"></a><a id="GRP-27.0-D002"></a><a id="GRP-27.0-D003"></a><a id="GRP-27.0-D104"></a><a id="GRP-27.0-D004"></a><a id="GRP-27.0-D105"></a><a id="GRP-27.0-D005"></a><a id="GRP-27.0-D006"></a><a id="GRP-27.0-D106"></a><a id="GRP-27.0-D107"></a><a id="GRP-27.0-D007"></a><a id="GRP-27.0-D108"></a><a id="GRP-27.0-D200"></a><a id="GRP-27.0-D109"></a><a id="GRP-27.0-D008"></a><a id="GRP-27.0-D110"></a><a id="GRP-27.0-D009"></a><a id="GRP-27.0-D010"></a><a id="GRP-27.0-D111"></a><a id="GRP-27.0-D011"></a><a id="GRP-27.0-D112"></a><a id="GRP-27.0-D113"></a><a id="GRP-27.0-D114"></a><a id="GRP-27.0-D201"></a><a id="GRP-27.0-D012"></a><a id="GRP-27.0-D115"></a><a id="GRP-27.0-D013"></a><a id="GRP-27.0-D116"></a><a id="GRP-27.0-D014"></a><a id="GRP-27.0-D117"></a><a id="GRP-27.0-D202"></a><a id="GRP-27.0-D015"></a><a id="GRP-27.0-D118"></a><a id="GRP-27.0-D016"></a><a id="GRP-27.0-D119"></a><a id="GRP-27.0-D017"></a><a id="GRP-27.0-D120"></a><a id="GRP-27.0-D121"></a><a id="GRP-27.0-D018"></a><a id="GRP-27.0-D019"></a><a id="GRP-27.0-D122"></a><a id="GRP-27.0-D020"></a><a id="GRP-27.0-D123"></a><a id="GRP-27.0-D021"></a><a id="GRP-27.0-D022"></a><a id="GRP-27.0-D124"></a><a id="GRP-27.0-D023"></a><a id="GRP-27.0-D125"></a><a id="GRP-27.0-D203"></a><a id="GRP-27.0-D024"></a><a id="GRP-27.0-D126"></a><a id="GRP-27.0-D025"></a><a id="GRP-27.0-D127"></a><a id="GRP-27.0-D026"></a><a id="GRP-27.0-D128"></a><a id="GRP-27.0-D129"></a><a id="GRP-27.0-D027"></a><a id="GRP-27.0-D130"></a><a id="GRP-27.0-D028"></a><a id="GRP-27.0-D029"></a><a id="GRP-27.0-D131"></a><a id="GRP-27.0-D030"></a><a id="GRP-27.0-D031"></a><a id="GRP-27.0-D204"></a><a id="GRP-27.0-D132"></a><a id="GRP-27.0-D032"></a><a id="GRP-27.0-D133"></a><a id="GRP-27.0-D033"></a><a id="GRP-27.0-D134"></a><a id="GRP-27.0-D205"></a><a id="GRP-27.0-D034"></a><a id="GRP-27.0-D135"></a><a id="GRP-27.0-D035"></a><a id="GRP-27.0-D136"></a><a id="GRP-27.0-D137"></a><a id="GRP-27.0-D036"></a><a id="GRP-27.0-D037"></a><a id="GRP-27.0-D138"></a><a id="GRP-27.0-D038"></a><a id="GRP-27.0-D139"></a><a id="GRP-27.0-D039"></a><a id="GRP-27.0-D140"></a><a id="GRP-27.0-D040"></a><a id="GRP-27.0-D041"></a><a id="GRP-27.0-D042"></a><a id="GRP-27.0-D043"></a><a id="GRP-27.0-D141"></a><a id="GRP-27.0-D206"></a><a id="GRP-27.0-D044"></a><a id="GRP-27.0-D142"></a><a id="GRP-27.0-D045"></a><a id="GRP-27.0-D143"></a><a id="GRP-27.0-D046"></a><a id="GRP-27.0-D144"></a><a id="GRP-27.0-D047"></a><a id="GRP-27.0-D145"></a><a id="GRP-27.0-D146"></a><a id="GRP-27.0-D048"></a><a id="GRP-27.0-D147"></a><a id="GRP-27.0-D049"></a><a id="GRP-27.0-D050"></a><a id="GRP-27.0-D148"></a><a id="GRP-27.0-D051"></a><a id="GRP-27.0-D149"></a><a id="GRP-27.0-D150"></a><a id="GRP-27.0-D052"></a><a id="GRP-27.0-D053"></a><a id="GRP-27.0-D151"></a><a id="GRP-27.0-D054"></a><a id="GRP-27.0-D152"></a><a id="GRP-27.0-D055"></a><a id="GRP-27.0-D153"></a><a id="GRP-27.0-D056"></a><a id="GRP-27.0-D154"></a><a id="GRP-27.0-D057"></a><a id="GRP-27.0-D058"></a><a id="GRP-27.0-D155"></a><a id="GRP-27.0-D059"></a><a id="GRP-27.0-D156"></a><a id="GRP-27.0-D157"></a><a id="GRP-27.0-D207"></a><a id="GRP-27.0-D060"></a><a id="GRP-27.0-D158"></a><a id="GRP-27.0-D061"></a><a id="GRP-27.0-D159"></a><a id="GRP-27.0-D208"></a><a id="GRP-27.0-D062"></a><a id="GRP-27.0-D160"></a><a id="GRP-27.0-D063"></a><a id="GRP-27.0-D161"></a><a id="GRP-27.0-D064"></a><a id="GRP-27.0-D162"></a><a id="GRP-27.0-D163"></a><a id="GRP-27.0-D065"></a><a id="GRP-27.0-D066"></a><a id="GRP-27.0-D164"></a><a id="GRP-27.0-D067"></a><a id="GRP-27.0-D165"></a><a id="GRP-27.0-D068"></a><a id="GRP-27.0-D166"></a><a id="GRP-27.0-D209"></a><a id="GRP-27.0-D069"></a><a id="GRP-27.0-D167"></a><a id="GRP-27.0-D070"></a><a id="GRP-27.0-D168"></a><a id="GRP-27.0-D071"></a><a id="GRP-27.0-D169"></a><a id="GRP-27.0-D170"></a><a id="GRP-27.0-D072"></a><a id="GRP-27.0-D073"></a><a id="GRP-27.0-D171"></a><a id="GRP-27.0-D074"></a><a id="GRP-27.0-D172"></a><a id="GRP-27.0-D075"></a><a id="GRP-27.0-D173"></a><a id="GRP-27.0-D076"></a><a id="GRP-27.0-D174"></a><a id="GRP-27.0-D210"></a><a id="GRP-27.0-D077"></a><a id="GRP-27.0-D175"></a><a id="GRP-27.0-D078"></a><a id="GRP-27.0-D176"></a><a id="GRP-27.0-D079"></a><a id="GRP-27.0-D177"></a><a id="GRP-27.0-D178"></a><a id="GRP-27.0-D080"></a><a id="GRP-27.0-D081"></a><a id="GRP-27.0-D179"></a><a id="GRP-27.0-D082"></a><a id="GRP-27.0-D180"></a><a id="GRP-27.0-D083"></a><a id="GRP-27.0-D181"></a><a id="GRP-27.0-D084"></a><a id="GRP-27.0-D182"></a><a id="GRP-27.0-D085"></a><a id="GRP-27.0-D183"></a><a id="GRP-27.0-D086"></a><a id="GRP-27.0-D184"></a><a id="GRP-27.0-D087"></a><a id="GRP-27.0-D185"></a><a id="GRP-27.0-D088"></a><a id="GRP-27.0-D186"></a><a id="GRP-27.0-D211"></a><a id="GRP-27.0-D089"></a><a id="GRP-27.0-D187"></a><a id="GRP-27.0-D188"></a><a id="GRP-27.0-D090"></a><a id="GRP-27.0-D189"></a><a id="GRP-27.0-D091"></a><a id="GRP-27.0-D092"></a><a id="GRP-27.0-D093"></a><a id="GRP-27.0-D190"></a><a id="GRP-27.0-D094"></a><a id="GRP-27.0-D191"></a><a id="GRP-27.0-D192"></a><a id="GRP-27.0-D212"></a><a id="GRP-27.0-D095"></a><a id="GRP-27.0-D193"></a><a id="GRP-27.0-D096"></a><a id="GRP-27.0-D194"></a><a id="GRP-27.0-D097"></a><a id="GRP-27.0-D195"></a><a id="GRP-27.0-D196"></a><a id="GRP-27.0-D098"></a><a id="GRP-27.0-D197"></a><a id="GRP-27.0-D198"></a><a id="GRP-27.0-D199"></a><a id="GRP-27.0-D099"></a><a id="GRP-27.0-D100"></a>

Renamed: use the new name in statements, views and reports.

| Kind | Old Name | New Name |
|---|---|---|
| table | `GrippCrm..AbsenceRequestAbsenceRequestLines` | [`GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLines) |
| table function | `GrippCrm..AbsenceRequestAbsenceRequestLinesByAbsenceRequestId` | [`GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLinesByAbsenceRequestId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLinesByAbsenceRequestId) |
| table function | `GrippCrm..AbsenceRequestById` | [`GrippCrm.GrippCrm.AbsenceRequestById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.AbsenceRequestById) |
| table function | `GrippCrm..AbsenceRequestLineById` | [`GrippCrm.GrippCrm.AbsenceRequestLineById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.AbsenceRequestLineById) |
| table | `GrippCrm..AbsenceRequestLines` | [`GrippCrm.GrippCrm.AbsenceRequestLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.AbsenceRequestLines) |
| table | `GrippCrm..AbsenceRequests` | [`GrippCrm.GrippCrm.AbsenceRequests`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.AbsenceRequests) |
| table function | `GrippCrm..BulkPriceById` | [`GrippCrm.GrippCrm.BulkPriceById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.BulkPriceById) |
| table | `GrippCrm..BulkPrices` | [`GrippCrm.GrippCrm.BulkPrices`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.BulkPrices) |
| table function | `GrippCrm..CalendarItemById` | [`GrippCrm.GrippCrm.CalendarItemById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CalendarItemById) |
| table | `GrippCrm..CalendarItems` | [`GrippCrm.GrippCrm.CalendarItems`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CalendarItems) |
| table | `GrippCrm..Companies` | [`GrippCrm.GrippCrm.Companies`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Companies) |
| table function | `GrippCrm..CompanyByCocNumber` | [`GrippCrm.GrippCrm.CompanyByCocNumber`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyByCocNumber) |
| table function | `GrippCrm..CompanyById` | [`GrippCrm.GrippCrm.CompanyById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyById) |
| table | `GrippCrm..CompanyCompanyRoles` | [`GrippCrm.GrippCrm.CompanyCompanyRoles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyCompanyRoles) |
| table function | `GrippCrm..CompanyCompanyRolesByCompanyId` | [`GrippCrm.GrippCrm.CompanyCompanyRolesByCompanyId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyCompanyRolesByCompanyId) |
| view | `GrippCrm..CompanyCustomFieldValues` | [`GrippCrm.GrippCrm.CompanyCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyCustomFieldValues) |
| table function | `GrippCrm..CompanyDossierById` | [`GrippCrm.GrippCrm.CompanyDossierById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyDossierById) |
| table | `GrippCrm..CompanyDossierFiles` | [`GrippCrm.GrippCrm.CompanyDossierFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyDossierFiles) |
| table function | `GrippCrm..CompanyDossierFilesByCompanyDossierId` | [`GrippCrm.GrippCrm.CompanyDossierFilesByCompanyDossierId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyDossierFilesByCompanyDossierId) |
| table | `GrippCrm..CompanyDossiers` | [`GrippCrm.GrippCrm.CompanyDossiers`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyDossiers) |
| table | `GrippCrm..CompanyFiles` | [`GrippCrm.GrippCrm.CompanyFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyFiles) |
| table function | `GrippCrm..CompanyFilesByCompanyId` | [`GrippCrm.GrippCrm.CompanyFilesByCompanyId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyFilesByCompanyId) |
| table | `GrippCrm..CompanyTags` | [`GrippCrm.GrippCrm.CompanyTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyTags) |
| table function | `GrippCrm..CompanyTagsByCocNumber` | [`GrippCrm.GrippCrm.CompanyTagsByCocNumber`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyTagsByCocNumber) |
| table function | `GrippCrm..CompanyTagsByCompanyId` | [`GrippCrm.GrippCrm.CompanyTagsByCompanyId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CompanyTagsByCompanyId) |
| table function | `GrippCrm..ContactById` | [`GrippCrm.GrippCrm.ContactById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContactById) |
| view | `GrippCrm..ContactCustomFieldValues` | [`GrippCrm.GrippCrm.ContactCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContactCustomFieldValues) |
| table | `GrippCrm..ContactTags` | [`GrippCrm.GrippCrm.ContactTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContactTags) |
| table function | `GrippCrm..ContactTagsByContactId` | [`GrippCrm.GrippCrm.ContactTagsByContactId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContactTagsByContactId) |
| table | `GrippCrm..Contacts` | [`GrippCrm.GrippCrm.Contacts`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Contacts) |
| table function | `GrippCrm..ContractById` | [`GrippCrm.GrippCrm.ContractById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractById) |
| table | `GrippCrm..ContractContractLines` | [`GrippCrm.GrippCrm.ContractContractLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractContractLines) |
| table function | `GrippCrm..ContractContractLinesByContractId` | [`GrippCrm.GrippCrm.ContractContractLinesByContractId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractContractLinesByContractId) |
| view | `GrippCrm..ContractCustomFieldValues` | [`GrippCrm.GrippCrm.ContractCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractCustomFieldValues) |
| table | `GrippCrm..ContractEmployees` | [`GrippCrm.GrippCrm.ContractEmployees`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractEmployees) |
| table function | `GrippCrm..ContractEmployeesByContractId` | [`GrippCrm.GrippCrm.ContractEmployeesByContractId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractEmployeesByContractId) |
| table | `GrippCrm..ContractEmployeesStarred` | [`GrippCrm.GrippCrm.ContractEmployeesStarred`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractEmployeesStarred) |
| table function | `GrippCrm..ContractEmployeesStarredByContractId` | [`GrippCrm.GrippCrm.ContractEmployeesStarredByContractId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractEmployeesStarredByContractId) |
| table | `GrippCrm..ContractFiles` | [`GrippCrm.GrippCrm.ContractFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractFiles) |
| table function | `GrippCrm..ContractFilesByContractId` | [`GrippCrm.GrippCrm.ContractFilesByContractId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractFilesByContractId) |
| table function | `GrippCrm..ContractLineById` | [`GrippCrm.GrippCrm.ContractLineById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractLineById) |
| table | `GrippCrm..ContractLines` | [`GrippCrm.GrippCrm.ContractLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractLines) |
| table | `GrippCrm..ContractTags` | [`GrippCrm.GrippCrm.ContractTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractTags) |
| table function | `GrippCrm..ContractTagsByContractId` | [`GrippCrm.GrippCrm.ContractTagsByContractId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ContractTagsByContractId) |
| table | `GrippCrm..Contracts` | [`GrippCrm.GrippCrm.Contracts`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Contracts) |
| table function | `GrippCrm..CostHeadingById` | [`GrippCrm.GrippCrm.CostHeadingById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CostHeadingById) |
| table | `GrippCrm..CostHeadings` | [`GrippCrm.GrippCrm.CostHeadings`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.CostHeadings) |
| table | `GrippCrm..Costs` | [`GrippCrm.GrippCrm.Costs`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Costs) |
| table function | `GrippCrm..DepartmentById` | [`GrippCrm.GrippCrm.DepartmentById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.DepartmentById) |
| table | `GrippCrm..Departments` | [`GrippCrm.GrippCrm.Departments`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Departments) |
| table function | `GrippCrm..EmployeeById` | [`GrippCrm.GrippCrm.EmployeeById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeById) |
| view | `GrippCrm..EmployeeCustomFieldValues` | [`GrippCrm.GrippCrm.EmployeeCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeCustomFieldValues) |
| table | `GrippCrm..EmployeeFamilies` | [`GrippCrm.GrippCrm.EmployeeFamilies`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeFamilies) |
| table function | `GrippCrm..EmployeeFamilyById` | [`GrippCrm.GrippCrm.EmployeeFamilyById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeFamilyById) |
| table | `GrippCrm..EmployeeSkills` | [`GrippCrm.GrippCrm.EmployeeSkills`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeSkills) |
| table function | `GrippCrm..EmployeeSkillsByEmployeeId` | [`GrippCrm.GrippCrm.EmployeeSkillsByEmployeeId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeSkillsByEmployeeId) |
| table | `GrippCrm..EmployeeTags` | [`GrippCrm.GrippCrm.EmployeeTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeTags) |
| table function | `GrippCrm..EmployeeTagsByEmployeeId` | [`GrippCrm.GrippCrm.EmployeeTagsByEmployeeId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeTagsByEmployeeId) |
| table function | `GrippCrm..EmployeeTargetById` | [`GrippCrm.GrippCrm.EmployeeTargetById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeTargetById) |
| table | `GrippCrm..EmployeeTargets` | [`GrippCrm.GrippCrm.EmployeeTargets`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeTargets) |
| table function | `GrippCrm..EmployeeYearlyLeaveBudgetById` | [`GrippCrm.GrippCrm.EmployeeYearlyLeaveBudgetById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeYearlyLeaveBudgetById) |
| table | `GrippCrm..EmployeeYearlyLeaveBudgets` | [`GrippCrm.GrippCrm.EmployeeYearlyLeaveBudgets`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmployeeYearlyLeaveBudgets) |
| table | `GrippCrm..Employees` | [`GrippCrm.GrippCrm.Employees`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Employees) |
| table function | `GrippCrm..EmploymentContractById` | [`GrippCrm.GrippCrm.EmploymentContractById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmploymentContractById) |
| table | `GrippCrm..EmploymentContracts` | [`GrippCrm.GrippCrm.EmploymentContracts`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.EmploymentContracts) |
| table | `GrippCrm..ExternalLinks` | [`GrippCrm.GrippCrm.ExternalLinks`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ExternalLinks) |
| view | `GrippCrm..FileContents` | [`GrippCrm.GrippCrm.FileContents`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.FileContents) |
| table function | `GrippCrm..FileContentsById` | [`GrippCrm.GrippCrm.FileContentsById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.FileContentsById) |
| table | `GrippCrm..Files` | [`GrippCrm.GrippCrm.Files`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Files) |
| table function | `GrippCrm..HourById` | [`GrippCrm.GrippCrm.HourById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.HourById) |
| table | `GrippCrm..Hours` | [`GrippCrm.GrippCrm.Hours`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Hours) |
| table function | `GrippCrm..InvoiceById` | [`GrippCrm.GrippCrm.InvoiceById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceById) |
| view | `GrippCrm..InvoiceCustomFieldValues` | [`GrippCrm.GrippCrm.InvoiceCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceCustomFieldValues) |
| table | `GrippCrm..InvoiceFiles` | [`GrippCrm.GrippCrm.InvoiceFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceFiles) |
| table function | `GrippCrm..InvoiceFilesByInvoiceId` | [`GrippCrm.GrippCrm.InvoiceFilesByInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceFilesByInvoiceId) |
| table | `GrippCrm..InvoiceInvoiceLines` | [`GrippCrm.GrippCrm.InvoiceInvoiceLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceInvoiceLines) |
| table function | `GrippCrm..InvoiceInvoiceLinesByInvoiceId` | [`GrippCrm.GrippCrm.InvoiceInvoiceLinesByInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceInvoiceLinesByInvoiceId) |
| table function | `GrippCrm..InvoiceLineById` | [`GrippCrm.GrippCrm.InvoiceLineById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceLineById) |
| table | `GrippCrm..InvoiceLines` | [`GrippCrm.GrippCrm.InvoiceLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceLines) |
| table | `GrippCrm..InvoicePayments` | [`GrippCrm.GrippCrm.InvoicePayments`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoicePayments) |
| table function | `GrippCrm..InvoicePaymentsByInvoiceId` | [`GrippCrm.GrippCrm.InvoicePaymentsByInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoicePaymentsByInvoiceId) |
| table | `GrippCrm..InvoiceTags` | [`GrippCrm.GrippCrm.InvoiceTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceTags) |
| table function | `GrippCrm..InvoiceTagsByInvoiceId` | [`GrippCrm.GrippCrm.InvoiceTagsByInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.InvoiceTagsByInvoiceId) |
| table | `GrippCrm..Invoices` | [`GrippCrm.GrippCrm.Invoices`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Invoices) |
| table function | `GrippCrm..LedgerById` | [`GrippCrm.GrippCrm.LedgerById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.LedgerById) |
| table | `GrippCrm..Ledgers` | [`GrippCrm.GrippCrm.Ledgers`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Ledgers) |
| table | `GrippCrm..MemorialLines` | [`GrippCrm.GrippCrm.MemorialLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.MemorialLines) |
| table | `GrippCrm..MemorialTags` | [`GrippCrm.GrippCrm.MemorialTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.MemorialTags) |
| table | `GrippCrm..Memorials` | [`GrippCrm.GrippCrm.Memorials`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Memorials) |
| table function | `GrippCrm..OfferById` | [`GrippCrm.GrippCrm.OfferById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferById) |
| view | `GrippCrm..OfferCustomFieldValues` | [`GrippCrm.GrippCrm.OfferCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferCustomFieldValues) |
| table | `GrippCrm..OfferEmployees` | [`GrippCrm.GrippCrm.OfferEmployees`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferEmployees) |
| table function | `GrippCrm..OfferEmployeesByOfferId` | [`GrippCrm.GrippCrm.OfferEmployeesByOfferId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferEmployeesByOfferId) |
| table | `GrippCrm..OfferEmployeesStarred` | [`GrippCrm.GrippCrm.OfferEmployeesStarred`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferEmployeesStarred) |
| table function | `GrippCrm..OfferEmployeesStarredByOfferId` | [`GrippCrm.GrippCrm.OfferEmployeesStarredByOfferId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferEmployeesStarredByOfferId) |
| table | `GrippCrm..OfferFiles` | [`GrippCrm.GrippCrm.OfferFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferFiles) |
| table function | `GrippCrm..OfferFilesByOfferId` | [`GrippCrm.GrippCrm.OfferFilesByOfferId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferFilesByOfferId) |
| table | `GrippCrm..OfferOfferLines` | [`GrippCrm.GrippCrm.OfferOfferLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferOfferLines) |
| table function | `GrippCrm..OfferOfferLinesByOfferId` | [`GrippCrm.GrippCrm.OfferOfferLinesByOfferId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferOfferLinesByOfferId) |
| table function | `GrippCrm..OfferPhaseById` | [`GrippCrm.GrippCrm.OfferPhaseById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferPhaseById) |
| table | `GrippCrm..OfferPhases` | [`GrippCrm.GrippCrm.OfferPhases`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferPhases) |
| table function | `GrippCrm..OfferProjectLineById` | [`GrippCrm.GrippCrm.OfferProjectLineById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferProjectLineById) |
| table | `GrippCrm..OfferProjectLines` | [`GrippCrm.GrippCrm.OfferProjectLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferProjectLines) |
| table | `GrippCrm..OfferTags` | [`GrippCrm.GrippCrm.OfferTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferTags) |
| table function | `GrippCrm..OfferTagsByOfferId` | [`GrippCrm.GrippCrm.OfferTagsByOfferId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.OfferTagsByOfferId) |
| table | `GrippCrm..Offers` | [`GrippCrm.GrippCrm.Offers`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Offers) |
| table function | `GrippCrm..PacketById` | [`GrippCrm.GrippCrm.PacketById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PacketById) |
| table function | `GrippCrm..PacketLineById` | [`GrippCrm.GrippCrm.PacketLineById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PacketLineById) |
| table | `GrippCrm..PacketLines` | [`GrippCrm.GrippCrm.PacketLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PacketLines) |
| table | `GrippCrm..PacketPacketLines` | [`GrippCrm.GrippCrm.PacketPacketLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PacketPacketLines) |
| table function | `GrippCrm..PacketPacketLinesByPacketId` | [`GrippCrm.GrippCrm.PacketPacketLinesByPacketId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PacketPacketLinesByPacketId) |
| table | `GrippCrm..PacketTags` | [`GrippCrm.GrippCrm.PacketTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PacketTags) |
| table function | `GrippCrm..PacketTagsByPacketId` | [`GrippCrm.GrippCrm.PacketTagsByPacketId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PacketTagsByPacketId) |
| table | `GrippCrm..Packets` | [`GrippCrm.GrippCrm.Packets`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Packets) |
| table function | `GrippCrm..PaymentById` | [`GrippCrm.GrippCrm.PaymentById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PaymentById) |
| table | `GrippCrm..Payments` | [`GrippCrm.GrippCrm.Payments`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Payments) |
| table function | `GrippCrm..PriceExceptionById` | [`GrippCrm.GrippCrm.PriceExceptionById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PriceExceptionById) |
| table | `GrippCrm..PriceExceptions` | [`GrippCrm.GrippCrm.PriceExceptions`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PriceExceptions) |
| table | `GrippCrm..ProductAttachmentsExternal` | [`GrippCrm.GrippCrm.ProductAttachmentsExternal`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductAttachmentsExternal) |
| table function | `GrippCrm..ProductAttachmentsExternalByProductId` | [`GrippCrm.GrippCrm.ProductAttachmentsExternalByProductId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductAttachmentsExternalByProductId) |
| table | `GrippCrm..ProductAttachmentsInternal` | [`GrippCrm.GrippCrm.ProductAttachmentsInternal`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductAttachmentsInternal) |
| table function | `GrippCrm..ProductAttachmentsInternalByProductId` | [`GrippCrm.GrippCrm.ProductAttachmentsInternalByProductId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductAttachmentsInternalByProductId) |
| table function | `GrippCrm..ProductById` | [`GrippCrm.GrippCrm.ProductById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductById) |
| view | `GrippCrm..ProductCustomFieldValues` | [`GrippCrm.GrippCrm.ProductCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductCustomFieldValues) |
| table | `GrippCrm..ProductTags` | [`GrippCrm.GrippCrm.ProductTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductTags) |
| table function | `GrippCrm..ProductTagsByProductId` | [`GrippCrm.GrippCrm.ProductTagsByProductId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProductTagsByProductId) |
| table | `GrippCrm..Products` | [`GrippCrm.GrippCrm.Products`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Products) |
| table function | `GrippCrm..ProjectById` | [`GrippCrm.GrippCrm.ProjectById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectById) |
| view | `GrippCrm..ProjectCustomFieldValues` | [`GrippCrm.GrippCrm.ProjectCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectCustomFieldValues) |
| table | `GrippCrm..ProjectEmployees` | [`GrippCrm.GrippCrm.ProjectEmployees`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectEmployees) |
| table function | `GrippCrm..ProjectEmployeesByProjectId` | [`GrippCrm.GrippCrm.ProjectEmployeesByProjectId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectEmployeesByProjectId) |
| table | `GrippCrm..ProjectEmployeesStarred` | [`GrippCrm.GrippCrm.ProjectEmployeesStarred`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectEmployeesStarred) |
| table function | `GrippCrm..ProjectEmployeesStarredByProjectId` | [`GrippCrm.GrippCrm.ProjectEmployeesStarredByProjectId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectEmployeesStarredByProjectId) |
| table | `GrippCrm..ProjectFiles` | [`GrippCrm.GrippCrm.ProjectFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectFiles) |
| table function | `GrippCrm..ProjectFilesByProjectId` | [`GrippCrm.GrippCrm.ProjectFilesByProjectId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectFilesByProjectId) |
| table function | `GrippCrm..ProjectPhaseById` | [`GrippCrm.GrippCrm.ProjectPhaseById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectPhaseById) |
| table | `GrippCrm..ProjectPhases` | [`GrippCrm.GrippCrm.ProjectPhases`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectPhases) |
| table | `GrippCrm..ProjectProjectLines` | [`GrippCrm.GrippCrm.ProjectProjectLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectProjectLines) |
| table function | `GrippCrm..ProjectProjectLinesByProjectId` | [`GrippCrm.GrippCrm.ProjectProjectLinesByProjectId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectProjectLinesByProjectId) |
| table | `GrippCrm..ProjectTags` | [`GrippCrm.GrippCrm.ProjectTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectTags) |
| table function | `GrippCrm..ProjectTagsByProjectId` | [`GrippCrm.GrippCrm.ProjectTagsByProjectId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ProjectTagsByProjectId) |
| table | `GrippCrm..Projects` | [`GrippCrm.GrippCrm.Projects`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Projects) |
| table function | `GrippCrm..PurchaseInvoiceById` | [`GrippCrm.GrippCrm.PurchaseInvoiceById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceById) |
| view | `GrippCrm..PurchaseInvoiceCustomFieldValues` | [`GrippCrm.GrippCrm.PurchaseInvoiceCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceCustomFieldValues) |
| table | `GrippCrm..PurchaseInvoiceEmployees` | [`GrippCrm.GrippCrm.PurchaseInvoiceEmployees`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceEmployees) |
| table function | `GrippCrm..PurchaseInvoiceEmployeesByPurchaseInvoiceId` | [`GrippCrm.GrippCrm.PurchaseInvoiceEmployeesByPurchaseInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceEmployeesByPurchaseInvoiceId) |
| table | `GrippCrm..PurchaseInvoiceEmployeesStarred` | [`GrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarred`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarred) |
| table function | `GrippCrm..PurchaseInvoiceEmployeesStarredByPurchaseInvoiceId` | [`GrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarredByPurchaseInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarredByPurchaseInvoiceId) |
| table | `GrippCrm..PurchaseInvoiceFiles` | [`GrippCrm.GrippCrm.PurchaseInvoiceFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceFiles) |
| table function | `GrippCrm..PurchaseInvoiceFilesByPurchaseInvoiceId` | [`GrippCrm.GrippCrm.PurchaseInvoiceFilesByPurchaseInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceFilesByPurchaseInvoiceId) |
| table function | `GrippCrm..PurchaseInvoiceLineById` | [`GrippCrm.GrippCrm.PurchaseInvoiceLineById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceLineById) |
| table | `GrippCrm..PurchaseInvoiceLines` | [`GrippCrm.GrippCrm.PurchaseInvoiceLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceLines) |
| table | `GrippCrm..PurchaseInvoicePurchaseInvoiceLines` | [`GrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLines) |
| table function | `GrippCrm..PurchaseInvoicePurchaseInvoiceLinesByPurchaseInvoiceId` | [`GrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLinesByPurchaseInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLinesByPurchaseInvoiceId) |
| table | `GrippCrm..PurchaseInvoicePurchasePayments` | [`GrippCrm.GrippCrm.PurchaseInvoicePurchasePayments`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoicePurchasePayments) |
| table function | `GrippCrm..PurchaseInvoicePurchasePaymentsByPurchaseInvoiceId` | [`GrippCrm.GrippCrm.PurchaseInvoicePurchasePaymentsByPurchaseInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoicePurchasePaymentsByPurchaseInvoiceId) |
| table | `GrippCrm..PurchaseInvoiceTags` | [`GrippCrm.GrippCrm.PurchaseInvoiceTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceTags) |
| table function | `GrippCrm..PurchaseInvoiceTagsByPuchaseInvoiceId` | [`GrippCrm.GrippCrm.PurchaseInvoiceTagsByPuchaseInvoiceId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoiceTagsByPuchaseInvoiceId) |
| table | `GrippCrm..PurchaseInvoices` | [`GrippCrm.GrippCrm.PurchaseInvoices`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseInvoices) |
| table function | `GrippCrm..PurchaseOrderById` | [`GrippCrm.GrippCrm.PurchaseOrderById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderById) |
| view | `GrippCrm..PurchaseOrderCustomFieldValues` | [`GrippCrm.GrippCrm.PurchaseOrderCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderCustomFieldValues) |
| table | `GrippCrm..PurchaseOrderEmployees` | [`GrippCrm.GrippCrm.PurchaseOrderEmployees`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderEmployees) |
| table function | `GrippCrm..PurchaseOrderEmployeesByPurchaseOrderId` | [`GrippCrm.GrippCrm.PurchaseOrderEmployeesByPurchaseOrderId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderEmployeesByPurchaseOrderId) |
| table | `GrippCrm..PurchaseOrderEmployeesStarred` | [`GrippCrm.GrippCrm.PurchaseOrderEmployeesStarred`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderEmployeesStarred) |
| table function | `GrippCrm..PurchaseOrderEmployeesStarredByPurchaseOrderId` | [`GrippCrm.GrippCrm.PurchaseOrderEmployeesStarredByPurchaseOrderId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderEmployeesStarredByPurchaseOrderId) |
| table | `GrippCrm..PurchaseOrderFiles` | [`GrippCrm.GrippCrm.PurchaseOrderFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderFiles) |
| table function | `GrippCrm..PurchaseOrderFilesByPurchaseOrderId` | [`GrippCrm.GrippCrm.PurchaseOrderFilesByPurchaseOrderId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderFilesByPurchaseOrderId) |
| table function | `GrippCrm..PurchaseOrderLineById` | [`GrippCrm.GrippCrm.PurchaseOrderLineById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderLineById) |
| table | `GrippCrm..PurchaseOrderLines` | [`GrippCrm.GrippCrm.PurchaseOrderLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderLines) |
| table | `GrippCrm..PurchaseOrderPurchaseOrderLines` | [`GrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLines`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLines) |
| table function | `GrippCrm..PurchaseOrderPurchaseOrderLinesByPurchaseOrderId` | [`GrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLinesByPurchaseOrderId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLinesByPurchaseOrderId) |
| table | `GrippCrm..PurchaseOrderTags` | [`GrippCrm.GrippCrm.PurchaseOrderTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderTags) |
| table function | `GrippCrm..PurchaseOrderTagsByPurchaseOrderId` | [`GrippCrm.GrippCrm.PurchaseOrderTagsByPurchaseOrderId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrderTagsByPurchaseOrderId) |
| table | `GrippCrm..PurchaseOrders` | [`GrippCrm.GrippCrm.PurchaseOrders`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchaseOrders) |
| table function | `GrippCrm..PurchasePaymentById` | [`GrippCrm.GrippCrm.PurchasePaymentById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchasePaymentById) |
| table | `GrippCrm..PurchasePayments` | [`GrippCrm.GrippCrm.PurchasePayments`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.PurchasePayments) |
| table function | `GrippCrm..RejectionReasonById` | [`GrippCrm.GrippCrm.RejectionReasonById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.RejectionReasonById) |
| table | `GrippCrm..RejectionReasons` | [`GrippCrm.GrippCrm.RejectionReasons`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.RejectionReasons) |
| table function | `GrippCrm..RevenueTargetById` | [`GrippCrm.GrippCrm.RevenueTargetById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.RevenueTargetById) |
| table | `GrippCrm..RevenueTargets` | [`GrippCrm.GrippCrm.RevenueTargets`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.RevenueTargets) |
| table function | `GrippCrm..TagById` | [`GrippCrm.GrippCrm.TagById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TagById) |
| table | `GrippCrm..Tags` | [`GrippCrm.GrippCrm.Tags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Tags) |
| table function | `GrippCrm..TaskById` | [`GrippCrm.GrippCrm.TaskById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskById) |
| table | `GrippCrm..TaskCalendarItems` | [`GrippCrm.GrippCrm.TaskCalendarItems`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskCalendarItems) |
| table function | `GrippCrm..TaskCalendarItemsByTaskId` | [`GrippCrm.GrippCrm.TaskCalendarItemsByTaskId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskCalendarItemsByTaskId) |
| view | `GrippCrm..TaskCustomFieldValues` | [`GrippCrm.GrippCrm.TaskCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskCustomFieldValues) |
| table | `GrippCrm..TaskFiles` | [`GrippCrm.GrippCrm.TaskFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskFiles) |
| table function | `GrippCrm..TaskFilesByTaskId` | [`GrippCrm.GrippCrm.TaskFilesByTaskId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskFilesByTaskId) |
| table function | `GrippCrm..TaskPhaseById` | [`GrippCrm.GrippCrm.TaskPhaseById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskPhaseById) |
| table | `GrippCrm..TaskPhases` | [`GrippCrm.GrippCrm.TaskPhases`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskPhases) |
| table function | `GrippCrm..TaskTypeById` | [`GrippCrm.GrippCrm.TaskTypeById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskTypeById) |
| table | `GrippCrm..TaskTypes` | [`GrippCrm.GrippCrm.TaskTypes`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TaskTypes) |
| table | `GrippCrm..Tasks` | [`GrippCrm.GrippCrm.Tasks`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Tasks) |
| table | `GrippCrm..TimelineEntries` | [`GrippCrm.GrippCrm.TimelineEntries`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TimelineEntries) |
| table function | `GrippCrm..TimelineEntryById` | [`GrippCrm.GrippCrm.TimelineEntryById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TimelineEntryById) |
| table | `GrippCrm..TimelineEntryFiles` | [`GrippCrm.GrippCrm.TimelineEntryFiles`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TimelineEntryFiles) |
| table function | `GrippCrm..TimelineEntryFilesByTimelineEntryId` | [`GrippCrm.GrippCrm.TimelineEntryFilesByTimelineEntryId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.TimelineEntryFilesByTimelineEntryId) |
| table function | `GrippCrm..UmbrellaProjectById` | [`GrippCrm.GrippCrm.UmbrellaProjectById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.UmbrellaProjectById) |
| view | `GrippCrm..UmbrellaProjectCustomFieldValues` | [`GrippCrm.GrippCrm.UmbrellaProjectCustomFieldValues`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.UmbrellaProjectCustomFieldValues) |
| table | `GrippCrm..UmbrellaProjectTags` | [`GrippCrm.GrippCrm.UmbrellaProjectTags`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.UmbrellaProjectTags) |
| table function | `GrippCrm..UmbrellaProjectTagsByUmbrellaProjectId` | [`GrippCrm.GrippCrm.UmbrellaProjectTagsByUmbrellaProjectId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.UmbrellaProjectTagsByUmbrellaProjectId) |
| table | `GrippCrm..UmbrellaProjects` | [`GrippCrm.GrippCrm.UmbrellaProjects`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.UmbrellaProjects) |
| table function | `GrippCrm..UnitById` | [`GrippCrm.GrippCrm.UnitById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.UnitById) |
| table | `GrippCrm..Units` | [`GrippCrm.GrippCrm.Units`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Units) |
| table function | `GrippCrm..ViewOnlineUrlById` | [`GrippCrm.GrippCrm.ViewOnlineUrlById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.ViewOnlineUrlById) |
| table function | `GrippCrm..WebhookById` | [`GrippCrm.GrippCrm.WebhookById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.WebhookById) |
| table | `GrippCrm..Webhooks` | [`GrippCrm.GrippCrm.Webhooks`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.Webhooks) |
| table function | `GrippCrm..WorkingHoursByEmployeeId` | [`GrippCrm.GrippCrm.WorkingHoursByEmployeeId`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.WorkingHoursByEmployeeId) |
| table function | `GrippCrm..YearTargetById` | [`GrippCrm.GrippCrm.YearTargetById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.YearTargetById) |
| table function | `GrippCrm..YearTargetTypeById` | [`GrippCrm.GrippCrm.YearTargetTypeById`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.YearTargetTypeById) |
| table | `GrippCrm..YearTargetTypes` | [`GrippCrm.GrippCrm.YearTargetTypes`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.YearTargetTypes) |
| table | `GrippCrm..YearTargets` | [`GrippCrm.GrippCrm.YearTargets`](/en/datamodels/grippcrm/GrippCrm.GrippCrm.YearTargets) |

#### Columns

0 added, 0 removed, 2 changed, in 1 tables.

<a id="GRP-27.0-D213"></a><a id="GRP-27.0-D214"></a>

<details>
<summary>

`GrippCrm.Native.NATIVEPLATFORMSCALARREQUESTS`: 0 added, 0 removed, 2 changed

</summary>

- `~` `DURATION_MS` (`database_data_type`: `int64` &rarr; `double`)
- `~` `DURATION_MS` (`dotnet_data_type`: `int64` &rarr; `double`)

</details>

<a id="gripp-crm-26.0-to-27.0-g-provider_attributes"></a>

### Provider attributes

Do I have to change my connection string, provider file or settings? Attributes of the connection and settings of the driver that appear, disappear or change default or place where they can be set.

<div class="rn-chips">

- 1 changes
- model files

</div>

<div class="rn-item" id="GRP-27.0-A001">

##### Engine-wide connection attributes change

28 attributes added, 2 removed and 5 settings of attributes changed. These attributes belong to the SQL engine and exist for every driver; the Query Tool notes describe them.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="gripp-crm-26.0-to-27.0-g-capabilities"></a>

### Capabilities

What can the driver do with a table? Whether a table or table function can be selected from, inserted into, updated and deleted from.

<div class="rn-chips">

- 0 changes
- model files

</div>

No changes in this group.

<a id="gripp-crm-26.0-to-27.0-g-performance"></a>

### Performance

Is it faster, and does it call the platform less? Paging, batching, caching, filters and projections sent to the platform, fewer requests, less memory.

<div class="rn-chips">

- 2 changes
- commits

</div>

<div class="rn-item" id="GRP-27.0-P001">

##### Reading stops as soon as the requested number of rows has been fetched

A statement with a row limit on one unsorted table no longer fetches further pages once the limit is reached.

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<div class="rn-item" id="GRP-27.0-P002">

##### Lower memory use when reading JSON answers

The driver reads the answers of Gripp CRM with a lighter JSON reader that allocates less memory, and uses the shared JSON settings for error messages.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<a id="gripp-crm-26.0-to-27.0-g-bug_fixes"></a>

### Bug fixes

Is the defect that I met repaired? Wrong or missing rows, wrong values, crashes and wrong messages, repaired in a release line that had the defect.

<div class="rn-chips">

- 1 changes
- commits

</div>

<div class="rn-item" id="GRP-27.0-B001">

##### Filters that Gripp CRM cannot apply are no longer sent to it

A filter on a reference with an id that does not exist, a like pattern with an underscore, a text with a space at its start or end, and a filter on a field such as the password or the type indicator could return wrong rows or an error from Gripp CRM. Such filters are now left to the engine, and a reference to a missing entity returns no rows.

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<a id="gripp-crm-26.0-to-27.0-g-enhancements"></a>

### Enhancements

What can I do now that I could not? New functions and options that are not a table or a column.

<div class="rn-chips">

- 3 changes
- commits

</div>

<div class="rn-item" id="GRP-27.0-E002">

##### Gripp CRM covers more entities, file contents and custom fields, and counts in one call

The driver reads more Gripp CRM entities, with their child tables such as lines, files, dossiers, tags and employees, file contents and the custom fields of an environment. A count of all rows is answered with one call when Gripp applies every filter. The limit of the rate limiter follows measurements of 29 October 2026: 12 calls per 5 seconds instead of 18 per 11 seconds. A page of file contents holds 10 files, and the driver warns early when the hourly allowance of calls runs out.

<div class="rn-chips">

- importance 4
- confidence medium

</div>

</div>

<div class="rn-item" id="GRP-27.0-E001">

##### Gripp CRM schema name added to all tables, views and table functions

The objects of Gripp CRM now live in a schema named GrippCrm, where they had no schema before. A statement that names an object with its full qualified name has to be adjusted.

<div class="rn-action">

**What to Do**

Check statements, views and scripts that name Gripp CRM objects with a catalogue and an empty schema, and change them to the form with the schema GrippCrm.

</div>

<div class="rn-chips">

- **can break a statement**
- importance 4
- confidence medium

</div>

</div>

<div class="rn-item" id="GRP-27.0-E003">

##### Throughput figures of Gripp CRM tables included

The driver carries measured latency and rows-per-minute figures for its tables and passes them to every table definition. The engine uses such figures to estimate how long a statement takes.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<a id="gripp-crm-26.0-to-27.0-g-authentication_platform"></a>

### Log-on and platform

Do I have to log on again, or change something because of the platform? Log-on and token handling, scopes and permissions, a new version of the platform API, retired endpoints and changed limits.

<div class="rn-chips">

- 0 changes
- commits

</div>

No changes in this group.

<a id="gripp-crm-26.0-to-27.0-numbers"></a>

### In Numbers

Objects of the data model at both ends of the step.

| Objects | 26.0 | 27.0 | Change |
|---|---:|---:|---:|
| tables | 100 | 100 | +0 |
| views | 14 | 14 | +0 |
| table functions | 0 | 0 | +0 |
| columns | 4,194 | 4,194 | +0 |
| function parameters | 103 | 103 | +0 |
| attributes of driver | 0 | 0 | +0 |
| tables that can insert | 1 | 1 | +0 |
| tables that can update | 0 | 0 | +0 |
| tables that can delete | 0 | 0 | +0 |

<a id="gripp-crm-26.0-to-27.0-more"></a>

### More Information

- [Data model documentation of the driver](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/tag/gripp-crm)
- [Invantive Cloud page of the driver](https://cloud.invantive.com/grippcrm)
- [Documentation of the platform](https://api.gripp.com/public/api3.php)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

- 2026-11-01T10:16:22.0458993Z
- 2026-11-01T10:11:15.2338532Z
- Fields that only the newer model has.
- Fields that only the newer model has.
- Fields that only the newer model has.
- Fields that only the newer model has.
- Fields that only the newer model has.
- Fields that only the newer model has.
- Commit items were classified by one reader; the model changes are derived and need no reading.
- Commits: the commits of the driver directory in the range that have no equivalent patch in the older state, without merges and version stamps; each was classified by reading its message and change.
- Model: the NDJSON files of data-models/database of the workspace of each release are compared record by record; only fields that both models have are compared, and texts are counted, not listed.
- A model generated from a later build of the same release (for example 26.0.340 for 26.0) stands for the release.
- 229 links between a change and a source commit are recorded.

</div>

</div>

</div>

</div>

