invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Gripp CRM Data Model

Gripp CRM biedt klantenbeheer: projecten, urenstaten en workflows.

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/grippcrm

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Cijfers

Figure Count
Tables 213
Columns 4,194
Tabeller med invoegsel 1
Tabeller med update 0
Tabellen met de functie 'verwijderen' 0
Tabeller gedocumenteerd 1

Poster met datamodel

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Gripp CRM Datamodel, Pagina 1 van 1Gripp CRM Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 27.1.3-BETA+6294 · 01-11-2026GrippCrm · Employees · GrippCrm · Contracts · GrippCrm · TimelineEntries · GrippCrm · Offers · GrippCrm · Projects · GrippCrm · Invoices · GrippCrm · PurchaseOrders · GrippCrm…Pagina 1 van 1 · documentation.invantive.euGrippCrm · Employees×2GrippCrm.GrippCrm.BulkPrices: Bulk PricesBulkPricesGrippCrm.GrippCrm.Companies: CompaniesCompaniesGrippCrm.GrippCrm.CompanyCompanyRoles: Company RolesCompanyCompanyRolesGrippCrm.GrippCrm.CompanyDossierFiles: Company Dossier FilesCompanyDossierFilesGrippCrm.GrippCrm.CompanyDossiers: Company DossiersCompanyDossiersGrippCrm.GrippCrm.CompanyFiles: Company FilesCompanyFilesGrippCrm.GrippCrm.CompanyTags: Company TagsCompanyTagsGrippCrm.GrippCrm.ContactTags: Contact TagsContactTagsGrippCrm.GrippCrm.Contacts: ContactsContactsGrippCrm.GrippCrm.Departments: DepartmentsDepartmentsGrippCrm.GrippCrm.EmployeeFamilies: Employee FamiliesEmployeeFamiliesGrippCrm.GrippCrm.EmployeeTags: Employee TagsEmployeeTagsGrippCrm.GrippCrm.EmployeeTargets: Employee TargetsEmployeeTargetsGrippCrm.GrippCrm.EmployeeYearlyLeaveBudgets: Employee Yearly Leave BudgetsEmployeeYearlyLeaveBudgetsGrippCrm.GrippCrm.Employees: EmployeesEmployeesGrippCrm.GrippCrm.EmploymentContracts: Employment ContractsEmploymentContractsGrippCrm.GrippCrm.Files: FilesFilesGrippCrm.GrippCrm.PriceExceptions: Price ExceptionsPriceExceptionsGrippCrm.GrippCrm.ProductAttachmentsExternal: Product External AttachmentsProductAttachmentsExternalGrippCrm.GrippCrm.ProductAttachmentsInternal: Product Internal AttachmentsProductAttachmentsInternalGrippCrm.GrippCrm.ProductTags: Product TagsProductTagsGrippCrm.GrippCrm.Products: ProductsProductsGrippCrm.GrippCrm.PurchaseInvoiceEmployees: Purchase Invoice EmployeesPurchaseInvoiceEmployeesGrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarred: Purchase Invoice Employees StarredPurchaseInvoiceEmployeesStarredGrippCrm.GrippCrm.PurchaseInvoiceFiles: Purchase Invoice FilesPurchaseInvoiceFilesGrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLines: Purchase Invoice Purchase Invoice LinesPurchaseInvoicePurchaseInvoiceLinesGrippCrm.GrippCrm.PurchaseInvoicePurchasePayments: Purchase Invoice Purchase PaymentsPurchaseInvoicePurchasePaymentsGrippCrm.GrippCrm.PurchaseInvoiceTags: Purchase Invoice TagsPurchaseInvoiceTagsGrippCrm.GrippCrm.PurchaseInvoices: Purchase InvoicesPurchaseInvoicesGrippCrm.GrippCrm.PurchasePayments: Purchase PaymentsPurchasePaymentsGrippCrm.GrippCrm.RevenueTargets: Revenue TargetsRevenueTargetsGrippCrm.GrippCrm.Tags: TagsTagsGrippCrm.GrippCrm.CostHeadings: Cost HeadingsCostHeadingsGrippCrm · ContractsGrippCrm.GrippCrm.Ledgers: LedgersLedgersGrippCrm · ContractsGrippCrm.GrippCrm.TaskTypes: Task TypesTaskTypesGrippCrm · ContractsGrippCrm.GrippCrm.Units: UnitsUnitsGrippCrm · ContractsGrippCrm · ContractsGrippCrm.GrippCrm.ContractContractLines: Contract Contract LinesContractContractLinesGrippCrm.GrippCrm.ContractEmployees: Contract EmployeesContractEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ContractEmployeesStarred: Contract Employees StarredContractEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ContractFiles: Contract FilesContractFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContractLines: Contract LinesContractLinesGrippCrm.GrippCrm.ContractTags: Contract TagsContractTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Contracts: ContractsContractsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.CostHeadings: Cost HeadingsCostHeadingsGrippCrm.GrippCrm.Costs: CostsCostsGrippCrm.GrippCrm.EmployeeSkills: Employee SkillsEmployeeSkillsGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.Hours: HoursHoursGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.InvoiceLines: Invoice LinesInvoiceLinesGrippCrm.GrippCrm.Ledgers: LedgersLedgersGrippCrm.GrippCrm.MemorialLines: Memo Rial LinesMemorialLinesGrippCrm.GrippCrm.MemorialTags: Memo Rial TagsMemorialTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Memorials: MemorialsMemorialsGrippCrm.GrippCrm.OfferProjectLines: Offer Project LinesOfferProjectLinesGrippCrm.GrippCrm.PacketLines: Packet LinesPacketLinesGrippCrm.GrippCrm.PacketPacketLines: Packet Packet LinesPacketPacketLinesGrippCrm.GrippCrm.PacketTags: Packet TagsPacketTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Packets: PacketsPacketsGrippCrm.GrippCrm.PurchaseInvoiceLines: Purchase Invoice LinesPurchaseInvoiceLinesGrippCrm.GrippCrm.PurchaseOrderLines: Purchase Order LinesPurchaseOrderLinesGrippCrm.GrippCrm.TaskCalendarItems: Task Calendar ItemsTaskCalendarItemsGrippCrm.GrippCrm.TaskFiles: Task FilesTaskFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.TaskPhases: Task PhasesTaskPhasesGrippCrm.GrippCrm.TaskTypes: Task TypesTaskTypesGrippCrm.GrippCrm.Tasks: TasksTasksGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.UmbrellaProjectTags: Umbrella Project TagsUmbrellaProjectTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.UmbrellaProjects: Umbrella ProjectsUmbrellaProjectsGrippCrm.GrippCrm.Units: UnitsUnitsGrippCrm.GrippCrm.Invoices: InvoicesInvoicesGrippCrm · InvoicesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Products: ProductsProductsGrippCrm · EmployeesGrippCrm.GrippCrm.Projects: ProjectsProjectsGrippCrm · ProjectsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.PurchaseInvoices: Purchase InvoicesPurchaseInvoicesGrippCrm · EmployeesGrippCrm.GrippCrm.PurchaseOrders: Purchase OrdersPurchaseOrdersGrippCrm · Purchase…GrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm · TimelineEntriesGrippCrm.GrippCrm.CalendarItems: Calendar ItemsCalendarItemsGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.TimelineEntries: Timeline EntriesTimelineEntriesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.TimelineEntryFiles: Timeline Entry FilesTimelineEntryFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.Contracts: ContractsContractsGrippCrm · ContractsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Invoices: InvoicesInvoicesGrippCrm · InvoicesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Offers: OffersOffersGrippCrm · OffersGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Projects: ProjectsProjectsGrippCrm · ProjectsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.PurchaseInvoices: Purchase InvoicesPurchaseInvoicesGrippCrm · EmployeesGrippCrm.GrippCrm.PurchaseOrders: Purchase OrdersPurchaseOrdersGrippCrm · Purchase…GrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Tasks: TasksTasksGrippCrm · ContractsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm · OffersGrippCrm.GrippCrm.OfferEmployees: Offer EmployeesOfferEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.OfferEmployeesStarred: Offer Employees StarredOfferEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.OfferFiles: Offer FilesOfferFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.OfferOfferLines: Offer Offer LinesOfferOfferLinesGrippCrm.GrippCrm.OfferPhases: Offer PhasesOfferPhasesGrippCrm.GrippCrm.OfferTags: Offer TagsOfferTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Offers: OffersOffersGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.UmbrellaProjects: Umbrella ProjectsUmbrellaProjectsGrippCrm · ContractsGrippCrm · ProjectsGrippCrm.GrippCrm.ProjectEmployees: Project EmployeesProjectEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ProjectEmployeesStarred: Project Employees StarredProjectEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ProjectFiles: Project FilesProjectFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ProjectPhases: Project PhasesProjectPhasesGrippCrm.GrippCrm.ProjectProjectLines: Project Project LinesProjectProjectLinesGrippCrm.GrippCrm.ProjectTags: Project TagsProjectTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Projects: ProjectsProjectsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.UmbrellaProjects: Umbrella ProjectsUmbrellaProjectsGrippCrm · ContractsGrippCrm · InvoicesGrippCrm.GrippCrm.InvoiceFiles: Invoice FilesInvoiceFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.InvoiceInvoiceLines: Invoice Invoice LinesInvoiceInvoiceLinesGrippCrm.GrippCrm.InvoicePayments: Invoice PaymentsInvoicePaymentsGrippCrm.GrippCrm.InvoiceTags: Invoice TagsInvoiceTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Invoices: InvoicesInvoicesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Payments: PaymentsPaymentsGrippCrm · PurchaseOrdersGrippCrm.GrippCrm.PurchaseOrderEmployees: Purchase Order EmployeesPurchaseOrderEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.PurchaseOrderEmployeesStarred: Purchase Order Employees StarredPurchaseOrderEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.PurchaseOrderFiles: Purchase Order FilesPurchaseOrderFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLines: Purchase Order Purchase Order LinesPurchaseOrderPurchaseOrderLinesGrippCrm.GrippCrm.PurchaseOrderTags: Purchase Order TagsPurchaseOrderTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.PurchaseOrders: Purchase OrdersPurchaseOrdersGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm · AbsenceRequestsGrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLines: Absence Request LinesAbsenceRequestAbsenceRequestLinesGrippCrm.GrippCrm.AbsenceRequestLines: Absence Request LinesAbsenceRequestLinesGrippCrm.GrippCrm.AbsenceRequests: Absence RequestsAbsenceRequestsGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.YearTargetTypes: Year Target TypesYearTargetTypesGrippCrm.GrippCrm.YearTargets: Year TargetsYearTargetsGrippCrmGrippCrm.GrippCrm.CompanyCustomFieldValues: Company Custom Field ValuesCompanyCustomFieldValuesGrippCrm.GrippCrm.ContactCustomFieldValues: Contact Custom Field ValuesContactCustomFieldValuesGrippCrm.GrippCrm.ContractCustomFieldValues: Contract Custom Field ValuesContractCustomFieldValuesGrippCrm.GrippCrm.EmployeeCustomFieldValues: Employee Custom Field ValuesEmployeeCustomFieldValuesGrippCrm.GrippCrm.ExternalLinks: External LinksExternalLinksGrippCrm.GrippCrm.FileContents: File ContentsFileContentsGrippCrm.GrippCrm.InvoiceCustomFieldValues: Invoice Custom Field ValuesInvoiceCustomFieldValuesGrippCrm.GrippCrm.OfferCustomFieldValues: Offer Custom Field ValuesOfferCustomFieldValuesGrippCrm.GrippCrm.ProductCustomFieldValues: Product Custom Field ValuesProductCustomFieldValuesGrippCrm.GrippCrm.ProjectCustomFieldValues: Project Custom Field ValuesProjectCustomFieldValuesGrippCrm.GrippCrm.PurchaseInvoiceCustomFieldValues: Purchase Invoice Custom Field ValuesPurchaseInvoiceCustomFieldValuesGrippCrm.GrippCrm.PurchaseOrderCustomFieldValues: Purchase Order Custom Field ValuesPurchaseOrderCustomFieldValuesGrippCrm.GrippCrm.RejectionReasons: Rejection ReasonsRejectionReasonsGrippCrm.GrippCrm.TaskCustomFieldValues: Task Custom Field ValuesTaskCustomFieldValuesGrippCrm.GrippCrm.UmbrellaProjectCustomFieldValues: Umbrella Project Custom Field ValuesUmbrellaProjectCustomFieldValuesGrippCrm.GrippCrm.Webhooks: WebhooksWebhooksNativeGrippCrm.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSGripp CRMData DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenGrippCrm · AbsenceRequests1GrippCrm · Contracts1GrippCrm · Employees1GrippCrm · Invoices1GrippCrm · Offers1GrippCrm · Projects1GrippCrm · PurchaseOrders1GrippCrm · TimelineEntries1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenBrieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: C = Companies, O =Contacts, E = Employees, F = Files, T = TagsGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.3-BETA+6294 op 01-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/grippcrm
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

GrippCrm · Employees

BulkPrices, Companies, CompanyCompanyRoles, CompanyDossierFiles, CompanyDossiers, CompanyFiles, CompanyTags, ContactTags, Contacts, Departments, EmployeeFamilies, EmployeeTags, EmployeeTargets, EmployeeYearlyLeaveBudgets, Employees, EmploymentContracts, Files, PriceExceptions, ProductAttachmentsExternal, ProductAttachmentsInternal, ProductTags, Products, PurchaseInvoiceEmployees, PurchaseInvoiceEmployeesStarred, PurchaseInvoiceFiles, PurchaseInvoicePurchaseInvoiceLines, PurchaseInvoicePurchasePayments, PurchaseInvoiceTags, PurchaseInvoices, PurchasePayments, RevenueTargets, Tags

GrippCrm · Contracts

ContractContractLines, ContractEmployees, ContractEmployeesStarred, ContractFiles, ContractLines, ContractTags, Contracts, CostHeadings, Costs, EmployeeSkills, Hours, InvoiceLines, Ledgers, MemorialLines, MemorialTags, Memorials, OfferProjectLines, PacketLines, PacketPacketLines, PacketTags, Packets, PurchaseInvoiceLines, PurchaseOrderLines, TaskCalendarItems, TaskFiles, TaskPhases, TaskTypes, Tasks, UmbrellaProjectTags, UmbrellaProjects, Units

GrippCrm · Offers

OfferEmployees, OfferEmployeesStarred, OfferFiles, OfferOfferLines, OfferPhases, OfferTags, Offers

GrippCrm · Projects

ProjectEmployees, ProjectEmployeesStarred, ProjectFiles, ProjectPhases, ProjectProjectLines, ProjectTags, Projects

GrippCrm · Invoices

InvoiceFiles, InvoiceInvoiceLines, InvoicePayments, InvoiceTags, Invoices, Payments

GrippCrm · PurchaseOrders

PurchaseOrderEmployees, PurchaseOrderEmployeesStarred, PurchaseOrderFiles, PurchaseOrderPurchaseOrderLines, PurchaseOrderTags, PurchaseOrders

GrippCrm · AbsenceRequests

AbsenceRequestAbsenceRequestLines, AbsenceRequestLines, AbsenceRequests, YearTargetTypes, YearTargets

GrippCrm · TimelineEntries

CalendarItems, TimelineEntries, TimelineEntryFiles

GrippCrm (zonder relaties)

CompanyCustomFieldValues, ContactCustomFieldValues, ContractCustomFieldValues, EmployeeCustomFieldValues, ExternalLinks, FileContents, InvoiceCustomFieldValues, OfferCustomFieldValues, ProductCustomFieldValues, ProjectCustomFieldValues, PurchaseInvoiceCustomFieldValues, PurchaseOrderCustomFieldValues, RejectionReasons, TaskCustomFieldValues, UmbrellaProjectCustomFieldValues, Webhooks

Native (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Relaties

Tabellen

GrippCrm.GrippCrm

GrippCrm.Native

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: