invantive documentation
Invantive SupportforenAnmelden / Eintragen

Gripp CRM Data Model

Gripp CRM bietet Kundenmanagement: Projekte, Stundenzettel und Workflows.

Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/grippcrm

Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.

Plattform

  • Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
  • Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
  • Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Angaben

Figure Count
Tables 213
Columns 4,194
Tabellen mit Einfügung 1
Tabellen mit Aktualisierung 0
Tabellen mit Löschfunktion 0
Tabellen dokumentiert 1

Poster zum Daten Muster

PDF, 1 A0-Blatt

Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.

Gripp CRM Daten Muster, Seite 1 von 1Gripp CRM Daten Musterzur Verwendung mit Invantive UniversalSQLVeröffentlichung 27.1.3-BETA+6294 · 01-11-2026GrippCrm · Employees · GrippCrm · Contracts · GrippCrm · TimelineEntries · GrippCrm · Offers · GrippCrm · Projects · GrippCrm · Invoices · GrippCrm · PurchaseOrder…Seite 1 von 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 CRMDatadictionaryJede Tabelle und jede Spalte dieses Daten Musters wird mit einer entsprechenden Dokumentationauf documentation.invantive.eu beschrieben, wo die Dokumentation auch in anderen Sprachenverfügbar ist.NotizenDie Boxen sind nach Themen gruppiert und je nach Kategorie farblich gekennzeichnet. Im Themader Tabelle, die den Schlüssel enthält, wird eine Beziehung eingezeichnet; in einem anderen Themawird eine hellgraue Box definiert.ThemenGrippCrm · AbsenceRequests1GrippCrm · Contracts1GrippCrm · Employees1GrippCrm · Invoices1GrippCrm · Offers1GrippCrm · Projects1GrippCrm · PurchaseOrders1GrippCrm · TimelineEntries1Tabellen ohne Beziehungen1LegendeTransaktionalSetupTechnischFest codierte WerteIn einem anderen Thema definiertDeklarierter SchlüsselIn Worten beschriebene BeziehungAus Spaltennamen abgeleiteter KandidatFett: eine beliebte Tabelle+Bulk, +Read: Die Tabelle ist auch in diesen Varianten verfügbar\u00D7n: n Schlüssel zwischen denselben TabellenBuchstaben: Bezieht sich auf eine Tabelle, die in den meisten Themen verwendet wird: C = Companies, O= Contacts, E = Employees, F = Files, T = TagsErstellt anhand der Metadaten von Invantive UniversalSQL 27.1.3-BETA+6294 am 01-11-2026. Jede Tabelle enthälteinen Link zu ihrer Seite mit Spalten, Schlüsseln und Beispiel-Queries.documentation.invantive.eu/de/datamodels/grippcrm
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge

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 (ohne Beziehungen)

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

Native (ohne Beziehungen)

NATIVEPLATFORMSCALARREQUESTS

Beziehungen

Tabellen

GrippCrm.GrippCrm

GrippCrm.Native

Attribute

The attributes of this platform are on the page Attributes.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: