invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Gripp CRM Data Model

Gripp CRM offre la gestione dei clienti: progetti, schede attività e flussi di lavoro.

Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/grippcrm

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

Piattaforma

  • Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
  • Tipo: un'applicazione accessibile tramite la propria API.
  • I dati sono suddivisi, ad esempio per azienda o per amministrazione.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Figure

Figure Count
Tables 213
Columns 4,194
Tabella con inserti 1
Tabella con aggiornamento 0
Tabella con la clausola DELETE 0
Tabella documentata 1

Poster sul modello di dati

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Gripp CRM Modello di dati, Foglio 1 di 1Gripp CRM Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.3-BETA+6294 · 01-11-2026GrippCrm · Employees · GrippCrm · Contracts · GrippCrm · TimelineEntries · GrippCrm · Offers · GrippCrm · Projects · GrippCrm · Invoices · GrippCrm · PurchaseOrders ·…Foglio 1 di 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 CRMDizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiGrippCrm · AbsenceRequests1GrippCrm · Contracts1GrippCrm · Employees1GrippCrm · Invoices1GrippCrm · Offers1GrippCrm · Projects1GrippCrm · PurchaseOrders1GrippCrm · TimelineEntries1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleLettere: si riferisce a una tabella utilizzata nella maggior parte degli argomenti: C = Companies, O =Contacts, E = Employees, F = Files, T = TagsGenerato dai metadati di Invantive UniversalSQL 27.1.3-BETA+6294 il 01-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/grippcrm
Il poster come testo: tabelle per argomento e le loro relazioni

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 (senza relazioni)

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

Native (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

Relazioni

Tabelle

GrippCrm.GrippCrm

GrippCrm.Native

Attributi

The attributes of this platform are on the page Attributes.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: